Revit Tip - Occupancy Loads / Room Capacity Scheduling and Calculations

An interesting issue that I worked through at the office today...  Thought I would share.

Basically, the issue is in the math.  When calculating the occupancy load using the schedule we had a parameter already in the schedule that divided the Room Area (based on the Revit Model) and the SF Per Person (A fixed number manually typed in based on certain factors).  This would then yield the Room Capacity.  Because we cannot have 1.75 of a person this number is usually rounded.  First, to round the number I used a Field Format override of (0 decimal places).  This rounds the number found up (if over 0.5) and down (if under 0.5).

This worked great but now we have an issue of rooms with a Room Capacity calculated at 0.35…  This will round down to 0 in our schedule.  Some of these rooms will need a Room Capacity of 1 as a minimum.  I solved this with an IF statement.  First, I had to create 2 parameters… One is called Room Capacity Multiplier (which is the quotient of Room Area divided by SF Per Person) and becomes a hidden field.  I then created a new “Calculate Value” parameter called “Room Capacity” (which will be the final number).  The IF statement looked like this:

if(Room Capacity Multiplier < 0.5, 1, Room Capacity Multiplier)

Based on the If Statement formula :  If(<condition>, <result-if-True>, <result-if-False>)

And that is it… Now if the number is less than 0.5 is will now show as 1 instead of 0 on the schedule.

Now, if we could only get the darn plan Symbol for room capacity to link with this schedule.

Please, share you experience, ideas, and solutions to using Revit for these types of Load Calcs, Fixture coutns, etc...  Comment below.

 ** Edit ** There is now an Add-in for Revit that handles Occupant Loads and Tags... I teamed up with another awesome Revit blogger to create SAuBIM - Code Calculations for Revit...