calculating m2 per person

[abespalov]

Hi,

Is there a way to set up some variables to calculate total sqm per person for a floor plan.

The total area is derived from an area schedule, where a total of all areas, minus the core areas (basically the NLA).

The number of people is calculated based on the count of a particular workstation. (once again, this is in a schedule)

Ideally, dividing the area by the count so that it updates automatically is the goal.

Any assistance would be great.

Thanks

[Steve_Stafford]

On the simplest level you need to create a calculated value in your schedule. Revit provides a button in the schedule properties dialog under the "Fields" tab to do this. In order for this to work the fields need to part of your schedule so you can do "math" with them. If they are then you just need to divide "parameter A by Parameter B" The actual syntax would be A/B if the parameters were called A and B...the / is the same divide symbol that excel uses.

If the parameters don't exist as part of the area or room category you need to create a project parameter or possibly a shared parameter to allow you enter data that can be used to do the math you need.

Refer to the image below for the calculated field button and notice the Add Parameter button too...

I have been writing some bits in my blog about parameters that might be helpful or at least I hope they are! The link is RevitOpEd (revitoped.blogspot.com)

[abespalov]

Thanks Steve. That helped. I was stumped on how to actually get the value into the project parameter. I created families and symbols.......then I just typed it into the schedule!.

Now that that is OK, do you have any advice on how to get The 'NLA' project parameter to link to the 'Total NLA' that is calculated by the schedule, and is there a way to get the 'headcount' project parameter to link to the 'number parameter' which is a count toye parameter in the schedule.

Please see attached image

Thanks for your help so far.

[Steve_Stafford]

The only way I know of to get a calculated value from one schedule into another is to manually enter it. That said you can reduce how much you have to enter the value, if you create a schedule key that has only one piece of data, the NLA value.

You can select this value in your related schedule. Then when the total is updated all existing fields in your project will get the new value as soon as you update your schedule key. New rows of data will need to select the NLA value naturally. So you have to update the schedule key and make sure all data rows have selected the key value.