topic Re: If/Then Formula to calculate Occupant Load in Revit Architecture Forum

If/Then Formula to calculate Occupant Load

Anonymous — Thu, 19 Oct 2017 19:52:30 GMT

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!

Re: If/Then Formula to calculate Occupant Load

Viveka_CD — Wed, 25 Oct 2017 15:08:43 GMT

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,

Re: If/Then Formula to calculate Occupant Load

Alfredo_Medina — Wed, 25 Oct 2017 18:16:10 GMT

@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.

Re: If/Then Formula to calculate Occupant Load

Viveka_CD — Thu, 26 Oct 2017 13:15:18 GMT

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.

Re: If/Then Formula to calculate Occupant Load

Anonymous — Thu, 26 Oct 2017 14:11:00 GMT

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

Re: If/Then Formula to calculate Occupant Load

Alfredo_Medina — Thu, 26 Oct 2017 14:29:06 GMT

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

Re: If/Then Formula to calculate Occupant Load

Anonymous — Thu, 26 Oct 2017 16:25:47 GMT

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.

Re: If/Then Formula to calculate Occupant Load

ToanDN — Thu, 26 Oct 2017 17:09:22 GMT

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.

Re: If/Then Formula to calculate Occupant Load

Anonymous — Thu, 26 Oct 2017 20:55:01 GMT

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

Re: If/Then Formula to calculate Occupant Load

ToanDN — Thu, 26 Oct 2017 22:46:09 GMT

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.

Re: If/Then Formula to calculate Occupant Load

Anonymous — Wed, 01 Nov 2017 15:26:23 GMT

Thank you very much for the help!!

Re: If/Then Formula to calculate Occupant Load

Anonymous — Tue, 18 Dec 2018 19:48:51 GMT

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.

Re: If/Then Formula to calculate Occupant Load

ToanDN — Wed, 19 Dec 2018 07:16:49 GMT

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

Re: If/Then Formula to calculate Occupant Load

ToanDN — Wed, 19 Dec 2018 17:44:00 GMT

Revit 2016 file attached.

Re: If/Then Formula to calculate Occupant Load

mjmcdoDPLV5 — Thu, 23 Jul 2020 19:15:19 GMT

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

Re: If/Then Formula to calculate Occupant Load

ToanDN — Thu, 23 Jul 2020 19:25:12 GMT

Maybe post a new topic to ask your new questions.

Re: If/Then Formula to calculate Occupant Load

mjmcdoDPLV5 — Thu, 23 Jul 2020 19:52:24 GMT

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

Re: If/Then Formula to calculate Occupant Load

ToanDN — Thu, 23 Jul 2020 19:56:43 GMT

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.

Re: If/Then Formula to calculate Occupant Load

yes_and_no — Thu, 10 Apr 2025 21:49:10 GMT

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

Re: If/Then Formula to calculate Occupant Load

octavio2 — Sat, 21 Feb 2026 12:15:45 GMT

Any body want to share this tag? Or where we can get it?