Room Area and Occupancy

[davidtetro]

I have been trying to find an answer to this on the discussion groups and cannot.  I was wondering how to go about doing this.  I have a building with multiple spaces in it.  I need to figure the occupancy of each space for egress and toilet fixture calculations.

I have tried toying around with formulas in the schedule by making a formula column and bringing the room area into the equation.  However, the results in the schedule are identical to the formula - the formula isn't calculating.  I tried placing an equal sign first, tried different types of characters and I cannot seem to get the formula correct.

In this example, it is a college classroom building so all the rooms have an occupancy of 1 person per 20 net square feet - so I am trying to get the room area to be divided by 20 - I cannot seem to get that calculation to work...

Any help or suggestions or ideas?

Thanks.

[David_W_Koch]

I assume that the red circle in your image means you want to have "--" replace 0 in the FT2 PER PERSON column (occupant load).  Since the occupant formula property needs that value to be a number, what you can do is create a formula property that tests the value of the occupant load and, if zero, returns "--" and if not, passes through the occupant load value.  That property would then replace the actual occupant load property in the Schedule Table.

In the attached file, in the SpaceStylesCalcs Property Set Definition, there is a formula property called Occupant_Load_Schedule that does what is described above.  Rather than rely on a Property Data Format to add a suffix to the non-zero values (which would also be added to the double hyphen), I converted the Occupant_Load value to a string by enclosing the property definition reference in double quotation marks, and then concatenated that with " OCC/SF" to create the return value when the occupant load is not zero.

If [Occupant_Load] = 0 Then
	RESULT = "--"
Else
	RESULT = "[Occupant_Load]" & " OCC/SF"
End If

In the attached file, I left the Occupant_Load column in the Schedule Table and added the Occupant_Load_Schedule property next to it, so you can compare the two.

[David_W_Koch]

Something similar could be done to the Occupants column, but having text values in that column would mess up the column total.

[alogan]

Thank you! You've made my job so much easier.