Revit Conditional Formula in Schedules

[Anonymous]

Hello all,

I'm not even sure if what I am asking is possible but here goes:

I am trying to create a formula to schedule my occupant load by using live linked areas.

So I started by creating an area table and include the associated level and area. I have then used the "comments" field to filter the schedule. My comments field will have a letter associated to indicate the type of occupancy based on our Canadian code. So in this project I have a parkade (F3), retail (E), and Lobby (D). 

The next step is to set up a new formulated parameter that will tell revit if "comments" = F3, then "area"/6  and if "comments" = E, then "area"/9 and if "comments" = D, then "area"/2.

I have been messing with if conditional formulas all afternoon and I dont believe I can use a letter, correct me if im wrong? but I could change it to a number if the formula worked. ie: if "comments" = 1, then "area"/6

Hoping to take full advantage of Revit, so would be great to hear if this formula exists.

Thanks

[ToanDN]

You cannot use a text field for the formula.  Entering a number in the Comments field doesn't work because it is still a text parameter.  Create a new Number or Integer parameter and use it instead.

[Anonymous]

Okay, makes sense.

So i have created a new parameter that is under the number category called "room assembly". Can I create a new field for occupancy with a formula that says if "room assembly"=1 then D, if not F3. Just assigning a letter or letter and number to the calculated parameter?

Because youre right, after I changed my 'occupancy" to a number i was able to accomplish the area/6 formula no problem.

Cheers

[ToanDN]

Yes you can create a calculated parameter "Occupancy" in the schedule with that formula. "Occupancy" can be a text parameter and its formula should read:
if (room assembly = 1, D, F3)

[barthbradley]

Worth watching: 

https://www.youtube.com/watch?v=tU93AbeVZZo

...FWIW: "Occupancy" already exists as a Room Parameter (Text). 

[ToanDN]

You know what is a better approach than using a formula for populating room occupancy? A key schedule.

[Anonymous]

I'm aware that the "occupancy" already exists, and after watching the video it seems very much manual still. Having to enter values for the load factor and for the occupancy. I have attached a snip of my excel sheet that I am trying to recreate, disregard the provided columns because I still haven't determined how I will show this (probably be manual).

But essentially If I can create a formula that ties everything back to the occupancy that way when I type in the occupancy field = F3 then it will auto fill my occupant load, door width required, corridor required and so on.

I'm really close, I just can't get this formula to accept the F3, is revit not understanding because it is a letter and a number?

ToanDN, I haven't looked into Key schedules much. But maybe my next schedule will be a key schedule

Thanks

[ToanDN]

Key schedule example:

[Anonymous]

2 issues with key schedules that I found:

- It doesnt allow me to include linked elements

- It doesnt allow me to show the area only

[ToanDN]

You are correct, linked elements are the killing factor. But I don'y understand your other comment. Key schedules are meant for populating preset values to multiple fields by choosing a single key. If you want to show actual rooms' Area and calculate Occupant Loads you do need regular schedules.