|
Forums >> Revit Building >> Technical Support >> Room Tags That Calculate
|
|
|
active
Joined: Sat, Jun 2, 2007
34 Posts
 |
I want to calculate the occupancy information for a room tag and I can't get formulas that will do what I want... I either have a units conflict or my formulas end up being booleans...Also, I want to make different parts of the tags visible for different sheets...I want to read the occupancy type from the room properties.I want to use an IF statement to set the SF per occupant value.I want to read the area from the room properties.I want to calculate the code occupancy, always rounding up.I want to enter the design occpuancy as a room property and have it display in the tag.In some plans, I want the room name and number to display.In others, the fire code information that I have discussed, including area, occupancy, sf per occupant, occupant load, and design occupant load.Has anyone done this already or know how to do it?TIAC#
|
This user is offline |
|
 |
|
|
|
active
Joined: Mon, Mar 20, 2006
219 Posts
 |
We have separate Room Tags that show different information, for the different sheets. One shows the occupancy for use on the Life Safety Plan for instance. Since Room Tags don't carry over from sheet to sheet it isn't any harder to place the appropriate tag by view used on each sheet. The occupancy is calculated using a Room Schedule. It could be more automatic, but what we do is have a parameter for "Square Feet Per Person" in which we enter the value from the code book for each Occupancy Type. I haven't bothered to figure out tte IF statement like you describe, partially because the numbers vary by code but also because I'm lazy. The area is reported automatically by Revit. We then make a column that reports (as an integer) the Area divided by the Square Feet Per Person plus .4999. That last bit makes the calculated value round up. (If you use .5 then you'll get an extra person for rooms with areas that divide evenly by the per-person-number.) This is obviously not a definitive answer to your questions, but more a small collection of semi-useful info.
|
This user is offline |
|
|
|
active
Joined: Sat, Jun 2, 2007
34 Posts
|
OK. So there's a way to get a value from a schedule back in to a tag? Or, in your case, a schedule suffices? Thanks. C#
|
This user is offline |
|
|
|
active
Joined: Tue, Nov 8, 2005
8 Posts
 |
Have either of you uploaded your room tag to the familys directory. I was just going to attempt to creat one that does exactly what you are talking about and would save me some time. Thank you
|
This user is offline |
|
|
|
active
Joined: Tue, Oct 16, 2007
16 Posts
No Rating |
We are in need of this also, but haven't had much luck in getting the info together in a tag. (i.e. - area parameter isn't available to put into a formula in the room tag). Any help would be greatly appreciated. Would be quite helpful on code plans!
|
This user is offline |
|
|
|
active
Joined: Mon, Mar 20, 2006
219 Posts
|
To respond to each in order: cwsharp...We put the scheduled number back into the tag. The problem is that formula parameters don't seem to "labelizable" so we have to create a column where we manually transfer the numbers into a column we hide in schedule and link to for tags. It makes it less than automatic, but much faster than recalculating each time. Jtouchstone...Because of what I said in my original reply and what I just added above, my room tag would do you little good. The label is simply a manually entered parameter. It's the schedule that works the magic and those don't like to exist outside of the project file. The process, though, is described as best I can. lbrooksher...Area should be one of the selectable options when you make a label in a Room Tag family.
|
This user is offline |
|
|
|
active
Joined: Tue, Oct 16, 2007
16 Posts
No Rating |
 I tried the schedule idea and still hit a dead end. Sorry, I'm an experienced Autocad user but a fairly new Revit user so could be missing a basic issue. Attached is a screen shot... maybe you have some thoughts? I keep getting Boolean and various formula errors. The Revit help... wasn't much help on formula syntax.
|
This user is offline |
|
|
|
active
Joined: Mon, Mar 20, 2006
219 Posts
|
That part looks good. Make sure that your "Occupancy Factor" is a "Area" type, not "Number" type, but may want to try this formula for code purposes (fraction of a person counts as a whole person): (Area / Occupancy Factor) + 0.499
|
This user is offline |
|
|
|
active
Joined: Wed, Sep 10, 2008
15 Posts
No Rating |
Improper use of boolean expressions. Anyone else have any life safety tips?
|
This user is offline |
|
|
|
active
Joined: Mon, Mar 20, 2006
219 Posts
|
I like your post. I have been providing information specific to the questions asked, which doesn't work in your particular situation...so you post that you are having boolean trouble, with no information about what is giving you the error or what you are trying to accomplish. You, then, reach out to "anyone else"...presumeably anyone other than me but who, also, can read your mind. good luck to you.
|
This user is offline |
|
|
|
|
|
active
Joined: Wed, Sep 10, 2008
15 Posts
No Rating |
I apologize. When I try to follow your listed advice... "Make sure that your "Occupancy Factor" is a "Area" type, not "Number" type, but may want to try this formula for code purposes (fraction of a person counts as a whole person): (Area / Occupancy Factor) + 0.499" I get the response from Revit of "Improper use of boolean expressions." when I try and finish out the calcualted value field. I then went on to ask in poor fashion " while we are on the subject of life safety issues) Anyone else have any life safety tips?" "Anyone else" was not supposed to mean "Anyone but this clown" I'm sorry you took offense. My communication skills aren't that far above binary. So again, your advice didn't seem to work for me and I was also wondering, on a SEPARATE NOTE, if anyone had some more life safety suggestions and tips. TL:DR Why didn't Revit think that we would want our room tags to list life safety information?
Edited on: Wed, Apr 22, 2009 at 2:59:23 PM
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
It would be better if you gave us a screen shot of the parameter (area & occupancy factor) setups (types) and then either type your formula exactly as you have entered it or give us another screenshot if we can see it all.
|
This user is offline |
|
|
|
active
Joined: Mon, Mar 20, 2006
219 Posts
|
I apologize as well...for my heightened sensitivity. In trying to figure out your issue I realized something that I didn't catch in the other screenshot, that they had "Room Occupancy" as "Number" type rather than "Integer". I thought maybe this was what was causing your error message, but I tested it and it doesn't. I'll poke at it some more and see if I can figure anything out.
|
This user is offline |
|
|
|
active
Joined: Tue, Oct 9, 2007
285 Posts
 |
It looks like your issue could be related to the units not meshing out. The formula we use is as follows: (Area / Occupant Load Factor) / 1 SF + 0.499 You have to remove the area in oder to get an Occ load. Along the lines of other life saftey issues, we use schedule keys for Occupant Load Factor, Gross/ Net and # of exits Required. It takes a little setup but in the end it works very well. Our basic flow for life saftey is: - Use the Load Calculation table to input all of the required information (Revit gives you area between wall faces but you may want an area adjustment for spaces that allow net; ie removing fixed casework) - Use a Compare Columns table to push the calculated values into shared parameters (the same calculations as above but with a filter set up so that if the shared parameter Occ Load = the calcualted value Occupant Load and the same for number of occupants and exits then that row doesnt show up) So that when theCompare Columns schedule is empty then you know the calculated values are the same as the tagged valuses I find that the area adjustment works well for exiting and then you can use the base area for program justification. If you want to get really compliacted you can have 2 area adjustments; 1 that is subtractive for fixed casework and the like which is used in exiting and the other would be additive where you take the perimiter of the room x half the average thickness of the wall (manuall input) for a more accurate occupancy usage within the building area. Hope thats not to confusing. I will provide screen shots but the grunt work of getting the schedules to work and talk to each other is up to you  Nick PS I know this uses many a dreaded work around, but its better than drawing a polyline, getting that area, putting it into a spreadsheet to calculate and then placing it back in a tag. At least some of it updates automatically and you just learn to check the Compare Columns schedule before printing for agency review.
|
This user is offline |
View Website
|
|
|
active
Joined: Fri, Apr 17, 2009
30 Posts
No Rating |
I realize no one has posted on this thread for a while. I the last attached image a room schedule, an area schedule, or a multi-schedule? Area schedules out of the box do not allow you to 'select available fileds from' rooms. o room names and numbers are not available in a standard area schedule. Also in a code plan there are typically gross and net square footages. For a school classroom casework is the boundary for room areas, How is this best accomplished in the earlier examples? Thank
|
This user is offline |
|
|
|
Search
