Formula to calculate the area of the 2nd floor divided by the 1st floor

Formula to calculate the area of the 2nd floor divided by the 1st floor

Anonymous
Not applicable
990 Views
4 Replies
Message 1 of 5

Formula to calculate the area of the 2nd floor divided by the 1st floor

Anonymous
Not applicable

I was wondering if it's possible to create a formula in an area schedule that would allow the area of the 2nd floor be divided by the 1st floor.  

0 Likes
991 Views
4 Replies
Replies (4)
Message 2 of 5

Alfredo_Medina
Mentor
Mentor

For this type of operations, I suggest to export a schedule of floors from Revit to .txt. Then, open that file in Excel and add formulas that relate to the value of a cell. 


Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin
0 Likes
Message 3 of 5

barthbradley
Consultant
Consultant

Sure. Manually enter the Floor Area of Level 2 into a second Project Parameter Field Column in the Schedule and then create another Column which computes a value based on the Calculated Formula =Area/[the manually inputting value].  

0 Likes
Message 4 of 5

Anonymous
Not applicable

I was hoping to avoid manual input so that when the form moves the area adapts.

0 Likes
Message 5 of 5

ToanDN
Consultant
Consultant
For a starter, add a Calculated Value parameter and choose Percentage instead of Formula.
0 Likes