Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

If/Then Formula to calculate Occupant Load

17 ANTWORTEN 17
GELÖST
Antworten
Nachricht 1 von 18
Anonymous
8888 Aufrufe, 17 Antworten

If/Then Formula to calculate Occupant Load

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!

17 ANTWORTEN 17
Nachricht 2 von 18
Viveka_CD
als Antwort auf: Anonymous

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,

Nachricht 3 von 18
Alfredo_Medina
als Antwort auf: Anonymous

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


Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin
Nachricht 4 von 18
Viveka_CD
als Antwort auf: Anonymous

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.

Nachricht 5 von 18
Anonymous
als Antwort auf: Viveka_CD

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

Nachricht 6 von 18
Alfredo_Medina
als Antwort auf: Anonymous

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


Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin
Nachricht 7 von 18
Anonymous
als Antwort auf: Alfredo_Medina

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.

Nachricht 8 von 18
ToanDN
als Antwort auf: Anonymous

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.

 

Capture.PNGCapture1.PNG

Nachricht 9 von 18
Anonymous
als Antwort auf: ToanDN

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

Nachricht 10 von 18
ToanDN
als Antwort auf: Anonymous

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.

 

Capture.PNG

Nachricht 11 von 18
Anonymous
als Antwort auf: ToanDN

Thank you very much for the help!!

Nachricht 12 von 18
Anonymous
als Antwort auf: ToanDN

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. 

Nachricht 13 von 18
ToanDN
als Antwort auf: Anonymous

I have been out and about for the last couple weeks but I will try to find an example in the office tomorrow.
Nachricht 14 von 18
ToanDN
als Antwort auf: Anonymous

Revit 2016 file attached.

 

Capture.PNG

 

 

Nachricht 15 von 18
mjmcdoDPLV5
als Antwort auf: ToanDN

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

Nachricht 16 von 18
ToanDN
als Antwort auf: mjmcdoDPLV5

Maybe post a new topic to ask your new questions.
Nachricht 17 von 18
mjmcdoDPLV5
als Antwort auf: ToanDN

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

Nachricht 18 von 18
ToanDN
als Antwort auf: mjmcdoDPLV5

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.

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report