Occupancy Load Tabulation

[john.cantrell]

How can you schedule area settings to divide that area by the occupancy load tabulation and calculate that for you? I know there must be a way, but it's probably a shared parameter thing that I'm not sure of.

Thanks anyone.

[anthony.67953]

I don't think it can be done in a schedule.

Respond to David Conent post Crossing the Divide. This is a major impediment.

[Scott D Davis]

I can be done, and there are several threads here about it. The only impediment is that the Tags will not fill themselves out with calculated values. You must create a "QA" schedule, where you comapre two columns and manually type in the calculated values so that they will appear in Tags.

THIS LINK (http://forums.augi.com/showthread.php?t=27192&highlight=occupancy) should help.

[john.cantrell]

Well actually, this would be for an interiors calculated Gross Building square footage. I would need this table for the front-end sheets, not necessarily a tag. But I'm looking for a way to create a parameter calc. that takes my Gross Building area and divides is by 100(type B occupancy).

[stuntmonkee]

Here is an all purpose schedule that factors out your occupancy, and then from there, calcs out your plumbing & exiting as well.

There is also another for Parking.

You have to fill out the variable numbers, but after that it does the math for you. . . .meaning you can't just put "B". . .you have to input 100. Look at the sheet in the file to see where info must be added.

Hope this works for some of you, and if nothing else, I would like some feed back on how to improve it.

Thanks
Stunts

[sbrown]

Come to AU and I'll show you. It is done using a schedule key, basically copy the code table in(yes using shared parameters for Area Type and Occupant load factor.) then in your room schedule you will select the key for each room type, create a calculated value including your area and your OLF.

[ford347]

Scott's solution works great...as a matter of fact, I think I got my schedule from him or someone in here. But copying the code and applying a good schedule key rocks.....easy to fill out and every area or room is availiable in a schedule with the appropriate values!

[archjake]

Come to AU and I'll show you. It is done using a schedule key, basically copy the code table in(yes using shared parameters for Area Type and Occupant load factor.) then in your room schedule you will select the key for each room type, create a calculated value including your area and your OLF.
This is the ONLY way to do this. We do a lot of electrical and mechanical engineering as well as the architectural portion. This has saved us so much time when it comes to calculating various code requirements. Once the code info is in your key schedule you hardly have to pick up the code book for this sort of thing.

[phillipluuluu]

i downloaded one of the occupancy load tabulation on this site and it works great. one question though. is there a way to edit the calculated value so whenever something divides by 0 it comes out as zero on the schedule and not a blank space.

example ( bathroom's sf is 300. I divide that by 0 for the S.F.PerPerson. Instead of showing the number 0, the schedule leaves it blank.)

I need it to show as zero!!! help please...

[Scott Womack]

You'll actually have to add another calculated column, where it does the previous formula again. If it is not 0, print the value, it is is 0, print 0

[Ning Zhou]

or simply modify formula as below:
if(S.F.PerPerson = 0, 0, (Area / S.F.PerPerson) / 1' ^ 2)

[bt1138]

or simply modify formula as below:
if(S.F.PerPerson = 0, 0, (Area / S.F.PerPerson) / 1' ^ 2)

Where in the revit documentation is the syntax for a formula like that explained?

b

[phillipluuluu]

thanks for the help !!

i don't know the answer to the question that person above is asking but i do have another question.

is there a formula or a way to override the value that comes up in the schedule on the calculated value column. For instance if it calculates the value to be 5.25, how can I override it to have instead 6 or maybe 7.

I know there's a way to modify the formula to make it round up and down, but is there a way to just put whatever you need to for the sake of it.

[Scott Womack]

thanks for the help !!

i don't know the answer to the question that person above is asking but i do have another question.

is there a formula or a way to override the value that comes up in the schedule on the calculated value column. For instance if it calculates the value to be 5.25, how can I override it to have instead 6 or maybe 7.

I know there's a way to modify the formula to make it round up and down, but is there a way to just put whatever you need to for the sake of it.

Nope. In fact Revit was designed originally to prevent that type of "falsifying"/over-riding of data.

Now, I don't mean anything nasty by the use of the term falsifying. It's just in the use/definition of BIM as is seems to be evolving in the industry, others downstream of you would not know how this value was arrived at.

[mthurnauer]

I my schedule, I have a column that is a yes/ no parameter for Calculated Value. In instances where you want to use Actual Count. If the Calculated Value is yes, then it uses the computed occupancy. If it is no then Occupant Load=Actual Count which is a number you just type in. This is useful for areas with fixed seating or where you may have a posted occupancy.

[Scott D Davis]

Where in the revit documentation is the syntax for a formula like that explained?

b

Got o help and search for "Conditional Statements in Formulas" or just "formulas". There is an example there of an "embedded IF Statement" that looks like this:

Embedded IF statements: =IF ( Length < 35' , 2' 6" , IF ( Length < 45' , 3' , IF ( Length < 55' , 5' , 8' ) ) )

[shamshirha]

I understand why they don't provide it, but programmers can't never foresee how the data needs to be presented and shouldn't take simple tools away such as Ceiling or round.

One way to get around this, at least in a annotation family is to create two parameters w/ different types and compare the two.

For example, your formula is Z = X / Y, where Z should always be rounded up (Ceiling function in excel).

Create a Calculated parameter that is type Integer (Zi) = X / Y
Create a Calculated parameter that is type Number (Z) = if( (X/Y) > Zi),Zi + 1, Zi)


i know you have to create two parameters, but that is the only workaround I have figured out w/out the Ceiling function.