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