Calculated values in a Life Safety schedule

[patricks]

I have a schedule showing rooms and occupancy types, which calculates occupant load and also egress widths.

On my current project, part of the building is unsprinkled, and the other part is sprinkled. So according to IBC 2006, you need 0.15" of egress width per person in sprinkled areas, and 0.2" for unsprinkled areas.

So right now I have added a Yes/No parameter, which is hidden, saying if the room is sprinkled or not. I also have the schedule sorted first by the Yes/No parameter, and then by room number, separate and showing totals for each.

So at this point I have the schedule calculating both sprinkled and unsprinkled widths for all rooms. How can I make the rooms with the No parameter only calculate for unsprinkled egress, and vice versa? Is it even possible with a single schedule? We're trying to issue today so I may just make 2 separate schedules if we get right down to the wire.

[dhurtubise]

Not sure i totally understand the question but you could use an IF to associate the yes/no to the respective value (0.15 or 0.2)

[patricks]

yeah I just thought about trying that, but I just need to find the proper syntax for conditional statements.

I'm guessing I would go to my calculated value parameters, which currently says 'Persons * 0.2" ' or 0.15", and put an IF statement in there.

[c-hawk]

something like: if (not(sprinklered), persons * 0.2, persons * 015))

[patricks]

That would calculate it either way in the same field, based on whether it's sprinkled or not, right?

I'd really rather have separate fields so that my column heading says either Sprinkled or Unsprinkled. I may just go ahead and do 2 schedules with one or the other field hidden.

[c-hawk]

then try:

'if (not(sprinklered), persons * 0.2, 0))' for the unsprinklered calc
'if (sprinklered, persons * 0.15, 0)' for the sprinklered calc

Not sure if the '0' at the end of these equaltions will work or not.

Yep, you can always fall back on two schedules quite easily.

[Justin Marchiel]

you could have a schedule to work but you would need to have some dumy fields that report the values of the calculated field

schedule field = if(sprinklered,sprinkcalc,calc)
you would need some yes/no parameters and dummy field like i said, but you could get it all in 1 schedule if you wanted to.

Justin

[patricks]

Thanks, I may try that later on if I have time, just under the gun at the moment.

If I had it in one schedule, with separate fields reporting the width for each Yes/No case, then I would want the field that was not calculate to remain blank, rather than showing as 0 or anything else.

At this point I just have 2 schedules with Sprinkled and Unsprinkled added to the titles, and the fields I don't want to show are just hidden or filtered out from each schedule.

[greg.mcdowell]

You won't be able to get the field blank as a calculated value... you'll need a manual (dummy?) field for that.