Formula for Wall footprint area

[Anonymous]

We are seeing a high square footage number from our contractor, when referring to the space that walls occupy. 

What is the best way to get Revit to give us those numbers?  Does someone have a formula  that can work in a schedule?  I tried to simply make a formula that calculated the walls length by its width.  But that cell in the schedule only filled out for 3 wall types out of about 20.  What am I missing here?

Thanks

Nardo

[constantin.stroescu]

Maybe not to smart, but I'll do it quicqly using ........ a Room Schedule  in which I'll introduce a Gross Area Field ( the value calculated with Area ) and a Calculated Value : Wall Area Projection = Gross Area- Room Area ( the Sum of all Room Areas)

• in Sorting and Gouping - uncheck Itemize Every Instance 
• in Formating, check Calculate Totals for Room Area and Wall Area Projection

• 1.png

[Anonymous]

One important thing to remember when using this system is that you must also subtract out "Open to below" and Stair spaces that are not included automatically. 

To figure out the Stair spaces not included you need to list all or the spaces.  If you have several floors but the stairs are only listed on one floor, then you need to also subtract the square footage of the un-included stair space on each floor out of the final square footage.  Same for the "Open to below" space and Elevator space and any Chases not include on any particular floor.

Nardo

[ToanDN]

@Anonymous

If your schedule does not report every wall you have placed in the model then you may want to take a look at its Phase and Phase Filter, then schedule Filter.

[kdickdoyle24XH7]

Very late to the party on this one but in case it helps anyone else - we've just had this as an issue during Stage 5 GIFA / NIA checks. Our relatively basic workaround was: 

1. Assign a new shared area parameter to the wall families across the project

2. Use our DIRoots plug-in to export a wall schedule (that includes the new blank parameter in addition to wall width and length fields) to Mircosoft Excel

3. Apply a simple formula that calculates the cross sectional footprint area of a wall instance by multiplying base width x length, and copy across all instances

4. Re-insert the scheduled data using DI Roots 

5. Format the Revit schedule to show the new 'dumb' text data as an area with appropriate decimal point. 

This does us for now but going forward I'll look to create a smarter parameter built into our wall families. Imagine this will especially help us for early stage area schedules for Client review.