Area Formula

[bgauthier]

I'm trying to figure out how to calculate this one. I have a small shopping center with walking areas. I need to calculate the ratio of the walking area and apply it the the store area. Lets say that the shopping center is 8000 ft2, the store is 1500 ft2 and the walking area is 900 ft2. The area applied will be ((1500/8000)*900). But how do I insert a formula for this and should I use the area or room schedule.

Hope it is clear

[brett05]

Have you tried using a Calculated Value in your schedule?

Cheers, Brett

[tomnewsom]

Have you tried using a Calculated Value in your schedule?

Cheers, Brett
That'll do it. And calculate the totals as well.

[bgauthier]

I know that the calculated value is the thing to do. The real questions are: do I use the room or area schedule and what is the formula for that kind figure.
I'm so confused

[D_Driver]

Probably you want to use the areas because you have absolute control of which side (or middle) of the wall you want the calculation to use.



Lets say that the shopping center is 8000 ft2, the store is 1500 ft2 and the walking area is 900 ft2. The area applied will be ((1500/8000)*900). But how do I insert a formula for this and should I use the area or room schedule.

As far as the end figure you are looking for, you are attempting to do numeric transformation on a calculated total. Revit does not like this. it will give you the total numbers for shop, gross and walking, but taking that final step of performing the ratio is something you can:
1) export the schedule to excel and perform the calc there
2) create a project paramter to hold the information, manually enter the values into these parameters and then create a schedule to display these values.


you can try to use percent calculated parameter types to do this:
Assuming you just have 2 types of areas and name them Walking and Shop, then set up a schedule with the following:
Name, Area
on the Sorting tab; set sort by name and add a footer to separate out walking from shop. Do not itemize each instance, add grand totals

go back to the fields and add a calculated parameter, Name = percent of total, make it a percent, Of=Area, By=Grandtotal (should end up being your gross depending on where you drew the lines in the area plan