I need to calc fenestration percentage of total exterior wall area. I can create individual schedules for wall, window and door area, and then create a legend with text notes to calc manually. But I'd like to create a schedule to do the calc's. I'm running into problems I don't understand.
I use two wall types for exterior walls - one for 2x framing with interior finish and the other for sheathing with exterior finish. I can use the exterior finish walls for a close-enough exterior wall area, filtered by type comments.
Revit's wall area calc shows the wall area minus the window and door area. I need to calc the total wall area including window and door area. I've created project parameters for total exterior door area and total window area, and added these parameters to the schedule. I have to manually input the values into each column, as generated by the appropriate schedules.
One problem is I made a total exterior wall area calculated parameter to add the wall area + total window area + total exterior door area, but it's not working. I added a fenestration area calculated parameter which adds total window area + total exterior door area, and that works fine. The total exterior wall area parameter is taking whatever the number is inputted into the total window area and total exterior door area parameters and multiplying is by 26, and then adding it.
The wall area and total exterior wall area parameters are formatted to calculated totals, otherwise they report as <varies>. the total window area and total exterior door area parameters are formatted to no calculation. If I change to calculate totals, the values change to whatever number was last inputted * 26.
And I haven't even gotten to the percentage parameter. I can't get that to work yet either.
There are several things going on that I do not understand. I thought this would be a fairly simple schedule to make, but of course it's not. Revit 2023 model attached, look at Schedules>Fenestration, TIA for any assistance, greatly appreciated.
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
Gelöst von syman2000. Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
A different approach that does not require any manual input:
- create walls in phase 1
- create doors and windows in phase 2
- create a wall schedule in phase 2, phase filter = show all
- add phase demolished and area parameters to schedule, format area to calculate totals
- sort by phase demolished, untick itemized
- create a calculated parameter, choose percentage, not formula
Now you have fenestration %.
Similar to @ToanDN method. Create a new phase called Wall Penetration. Have doors and windows demolished at this phase. However if you want to split the schedule into each individual column area like you see below
Simply add YES/NO parameter to separate the fenestration. Then use the calculated value to extract the area.
@ToanDN & @syman2000 thank you for the replies. I follow your logic, but I cannot recreate what you've done. I get the phase 1 and phase 2. But I cannot get the schedules to work. I've not used phases and schedules at this level.
@ToanDN - are there step(s) that you did not describe? Do you have the doors & windows to be demolished or none? If so what phase?
In your third bullet point, where are you setting the Phase Filet = Show All? In a schedule, or view?
Every step is listed. Please read and follow carefully. The 3rd bullet point is about the schedule, why would a view phase filter relevant here?
See attached file and see how the schedule works
@ToanDN & @syman2000 I was able to get it to work. Thank you for your assistance. As always, greatly appreciated! mpp
One important point to make: when adding new phases just to get the fenestration percentage calc, I have to go through all views - including schedules - and update the Phase, otherwise they do not display properly.
@mpukas wrote:
One important point to make: when adding new phases just to get the fenestration percentage calc, I have to go through all views - including schedules - and update the Phase, otherwise they do not display properly.
Keep your main new phase as is and add a phase before it. Then change the wall to that phase. This way you don't need to fix any views.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.