If/Then Formula to calculate Occupant Load

[Anonymous]

I am creating an office template and would like to pre-load the Occupant Load Factors (from Table 1004.1.2) into the template.  For instance, if someone clicked the dropdown in 'Space Function', selected 'Assembly - Concentrated (Chairs Only)' --> I would like the value 7 to show up in Load Factor.  As opposed to them manually entering all the load factors.  The 'Occupant Load' calculated parameter is working correctly.

I would like to have a nested If statement, as in If (Space Function = Assembly - Concentrated (Chairs Only), 7, etc etc etc through all the Space Function types from Table 1004.1.2.  However, I realize that calculated parameters need to reference an actual parameter so I can't just enter that text and expect it to work.  I also tried a version with check boxes, such that you would check the box for which space function the room is, but there are so many types, it gets overwhelming in the schedule.

Are there any other ways to do this?  I do not know Dynamo.

Thank you!

[Viveka_CD]

Hi @Anonymous

It's been a while and I wanted to check back on this post.

Please see the blog HERE to Show Room Occupancy Loads in Revit Schedule.

Check out the video below to do a room occupancy load tag/code using Dynamo. (Room Occupancy Load tool that automatically generates Occupancy Load value for each room based on Filled Region defined Area Deductions and Occupancy Type parameters. It then automatically fills those parameters so they can be scheduled)

You can also try posting to the DynamoBIM forum

Please select the Accept as Solution button if my post solves your issue or answers your question. Kudos welcome!

Regards,

[Alfredo_Medina]

@Anonymous Your options for type occupancy could be represented by a list of integers. 1 is assembly this, 2 is as assembly that, etc... Then, you can create IF formulas, based on the meaning of those values. Such as "if occupancy integer is 1, then, type of asembly is this, then, occupancy load is this, if... , etc." No need to use Dynamo for this. 

[Viveka_CD]

Hi @Anonymous

I just wanted to follow up here, any progress on this issue?

Let us know if are seeking additional assistance from the community.

Please mark any posts that help with "Accept as Solution" and thanks! Kudos welcome.

[Anonymous]

I don't know how to use Dynamo so I'm just going to leave it as is.  People can just look to the table and type it in.  It won't auto-populate since I don't know Dynamo.

Thank you for following up.

Angie

[Alfredo_Medina]

Post # 3 above is giving you other alternatives, saying that you don't need Dynamo to do this.

[Anonymous]

Thank you.  I just think it may be an extra complication for staff to refer to a list to see which number is which type and then they might as well just refer to the list to see the load information and type that in instead.  I think it just doesn't work as ideally.

[ToanDN · Accepted solution]

There is no need for dynamo, or formula even.  Simply create a Key schedule for Rooms Category and add a Key for each Occupancy group.  Go to a plan, select the Rooms, assign a key, and all the information will populate to these Rooms.

[Anonymous]

Thank you!  That is exactly what I was looking for!  

Would you mind sharing screenshots of the other schedules that you've created to use this info?  I'm assuming the load factors calculate in schedules?

Thanks again!

Angie

[ToanDN · Accepted solution]

There is no calculation.  You just enter the value once for each row.

The most uses for Key Schedules are Hardware Group and Room Finishes.  below is another example.

[Anonymous]

Thank you very much for the help!!

[Anonymous]

ToanDN,

The Key schedule approach conceptually makes a lot of sense, can you post a file that has your Occupant load tables loaded so we can see the internal workings. I have read and seen many approaches to this issue and yours is the first to keep it within Revit in a workable manner. I would also appreciate a look at the life safety lines family you have.

Thank you. 

[ToanDN]

I have been out and about for the last couple weeks but I will try to find an example in the office tomorrow.

[ToanDN]

Revit 2016 file attached.

[mjmcdoDPLV5]

how did you do the room tag? room tag only use shared parameters but key schedule doesn't

[ToanDN]

Maybe post a new topic to ask your new questions.

[mjmcdoDPLV5]

ok - but is directly related to this post. i created key schedule and room schedule and calculate occ load perfectly. now trying to get a label as you show above... thank's i will post on different thread

[ToanDN]

I don't believe there are any questions asking about the room tags. Furthermore, the sample file I used is 2016 which doesn't support calculated labels so you posting a separate topic would generate better responses.

[yes_and_no]

Alfredo,

I love this idea, and going to give it a try.

((( We have been using many separate schedules for each occupancy types WITHIN a project, and have to sum up OL manually. Needless to say errors do occur from time to time.)))

Q: instead of going by integer order 1, 2, 3 can we set 7, 15, 30, 100, 200 as to mimitting OLF ?

Thanks a bunch