See the top rated post in this thread. Click here

Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Plumbing Fixture Counts

  1. #1
    Member
    Join Date
    2011-10
    Posts
    5
    Login to Give a bone
    0

    Default Plumbing Fixture Counts

    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
    Attached Images Attached Images

  2. #2
    AUGI Addict jsteinhauer's Avatar
    Join Date
    2015-11
    Location
    Madison, WI
    Posts
    1,317
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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.
    'When I am working on a problem, I never think about beauty but when I have finished, if the solution is not beautiful, I know it is wrong.' - R. Buckminster Fuller

  3. #3
    Active Member
    Join Date
    2004-06
    Posts
    77
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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.
    Regards,

    Glynnis Patterson, Architect
    www.ideatebimlink.com | www.ideateexplorer.com

  4. #4
    All AUGI, all the time
    Join Date
    2008-11
    Location
    Australia
    Posts
    754
    Login to Give a bone
    1

    Default Re: Plumbing Fixture Counts

    Pretty sure this will solve it for you

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

  5. #5
    Member
    Join Date
    2011-10
    Posts
    5
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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

  6. #6
    Member
    Join Date
    2011-10
    Posts
    5
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    I forgot to attach the scaled down project
    Attached Files Attached Files

  7. #7
    Member
    Join Date
    2011-10
    Posts
    5
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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

  8. #8
    Member
    Join Date
    2011-10
    Posts
    5
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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

  9. #9
    Active Member
    Join Date
    2004-06
    Posts
    77
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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
    Regards,

    Glynnis Patterson, Architect
    www.ideatebimlink.com | www.ideateexplorer.com

  10. #10
    AUGI Addict jsteinhauer's Avatar
    Join Date
    2015-11
    Location
    Madison, WI
    Posts
    1,317
    Login to Give a bone
    0

    Default Re: Plumbing Fixture Counts

    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.
    'When I am working on a problem, I never think about beauty but when I have finished, if the solution is not beautiful, I know it is wrong.' - R. Buckminster Fuller

Page 1 of 2 12 LastLast

Similar Threads

  1. Fixture Unit Counts
    By Wish List System in forum Revit MEP - Wish List
    Replies: 1
    Last Post: 2013-01-24, 06:44 PM
  2. 2011: Plumbing Fixture
    By jamie santiago in forum Revit Architecture - General
    Replies: 3
    Last Post: 2011-09-29, 01:26 PM
  3. Plumbing Fixture Families, what is this?
    By lonewolfjustin in forum Revit MEP - Families
    Replies: 4
    Last Post: 2009-12-18, 03:01 PM
  4. Plumbing Fixture
    By sjsl in forum Revit Architecture - General
    Replies: 1
    Last Post: 2008-04-10, 03:31 PM
  5. Plumbing Fixture
    By nsinha73 in forum Revit Architecture - General
    Replies: 2
    Last Post: 2006-10-13, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •