Plumbing Fixture Counts

[kim579708]

I have set up several schedules based on Occupancy to determine Plumbing Counts. Each schedule seems to work with the exception of the "B Occupancy". I'm certain that others have had problems with the formula. Initially when I created my schedule, I created these parameters: WCMen, LavMen, WCWomen, and LavWomen to calculate the fixtures required. I also have created other parameters for this schedule. When I created the parameters for WCMen, LavMen, WCWomen and LavWomen I created them as a Calculated Value (i.e. Name: WCMen with the following formula: if((Men < 50), (Men / 25), (((Men - 50) / 50) + 2)). This formula seems to be calculating more than it should be. If I have a "B" Occupancy Group Classification and 358 Occupants. 2012 code indicates for water closets I need 1 per 25 for the first 50 and 1 per 50 for the remaining exceeding 50. So, 358 Occupants means I have 179 Men & 179 Women. Therefore 179 Occupants - 50 = 129, 129/50 = 2.58, 2.58+2=4.58, I would then be required 5 Water Closets. Apparently I am missing something with my formula. Any thoughts would be greatly appreciated. All my other schedules work but this one.

Thanks
Kim Candelario
Method Studio, Inc
Salt Lake City, Utah
801-718-1527

[jsteinhauer]

Kim,

I am able to make the math work in Excel. Could you post a scaled down project file for us to try and help you? Your formulas look correct, so it might be something else.

Sorry I can't help further,
Jeff S.

[glynnis.patterson]

Hi Kim,

I've been meaning to write a detailed post on this question as I've been taking a very close look at this lately. The bottom line is that when Revit does the rounding it's doing it on each row of data. I'm assuming that in your B_Occ schedule that there are actually several Areas (or Rooms) that are being summarized? If Revit was able to apply the formula only to the total, the math would work. My own workaround to this is to do the math externally and then log the results on either a Level Schedule or in some instances via a 'dumb' Key Schedule. If I can find the time I'll post a video to explain better - hope this makes sense.

[Craig_L]

Pretty sure this will solve it for you

http://revitrants.blogspot.ch/2012/0...-rounding.html

[kim579708]

Jeff,

I am attaching the scaled down project file, this file seems to work, I have modified the walls for the "B" Occupancy and checked the values. Where I was going with this until I experienced a flaw in my main project file, Is there a way that I can total all fixture counts into a single table, I know of a work around, and that is to set up a dummy schedule and manually input those values. At least I got every other schedule to calculate automatically. My next step is to use these working schedules in my current project and have them as part of my template.

Thanks
Kim

[kim579708]

I forgot to attach the scaled down project

[kim579708]

Jeff,

If you do get a chance to review my scaled down file, I hope it all makes sense, there are several ways to skin a cat, not that I would do that, in the meantime this may work, I am always trying to find ways to simplify. You may notice that I placed a conditional format so that if any spaces change the cell then changes to red and provides an alert. In which I have tied an occupant load label to a room tag.

Thanks Again
Kim

[kim579708]

Glynnis,

Thanks for the info, I will certainly look into that, I am really trying to make the majority of my code related items automatic.

Kim

[glynnis.patterson]

I hear you on that one, I'm all for automation - just trying to save you the effort. Keep me posted if you find anything different, but pretty sure you'll need to go this manual route. See screenshot for my explanation on how Revit manages the calculations versus how I think it should be done.


Excel calcs.jpg

-Glynnis

[jsteinhauer]

Kim,

As Glynnis was saying there is a rounding error inside of Revit. Because you are incorporating multiple rooms into your calculations, instead of looking at the total area for each classification, Revit calculates the values for each and the reports the totals. You could use Area Plans instead of rooms. Or, do a calculation based upon the total area, hard coded into your formula.

Sorry for the bad news.
Jeff S.