Results 1 to 5 of 5

Thread: Formula Annoyances: Inconsistent Units, Etc.

  1. #1
    Member
    Join Date
    2006-05
    Posts
    43
    Login to Give a bone
    0

    Default Formula Annoyances: Inconsistent Units, Etc.

    Hi all -

    I'm still quite new to using schedules in Revit, and am having a beastly time creating a schedule for calculating required number of fixtures in bathrooms.

    My schedule is based on net square footage from rooms. I've got the following fields: Level and Department (both used to sort out things I don't want), Area, Occupancy Load (an instance parameter, type = area, that is entered for each level - in this case, all of them at 50 SF), Occupants (calc. value, type is number, Formula is Area / Occupancy Load), and Half Occupants (calc. value, type is integer, Formula is Occupants / 2).

    The schedule is giving me *insane* numbers. literally. Like this:

    "Bathroom Calc" "" "" "" ""
    "Level" "Area" "Occupancy Load" "Occupants" "Half Occupants"
    "Level 1" "11575 SF" "50 SF" "231.49569" "116"
    "Level 2" "11629 SF" "50 SF" "232.582293" "102"
    "Level 3" "11043 SF" "50 SF" "220.860526" "94"
    "Level 4" "9632 SF" "50 SF" "192.649297" "87"
    "" "43879 SF" "" "877.587807" "399"

    Occupants is fine - but Half Occupants is doing wacky things with the numbers, and I have no idea why. Both Occupants and Half Occupants have "Calculate Totals" checked under the Formatting Tab.

    Once I get past that hurdle, I just want to divide half occupants by 40 and by 30 to get fixture counts for men and women, respectively.

    Help, please!!

    Thanks to everyone, as always.

    Peter

  2. #2
    All AUGI, all the time
    Join Date
    2005-01
    Location
    Milwaukee, Wisconsin
    Posts
    636
    Login to Give a bone
    0

    Default Re: Formula Annoyances: Inconsistent Units, Etc.

    If the project is small enough, would you mind posting? Might be easier to figure out what is happening after seeing what you have done so far. Thanks.

  3. #3
    Member
    Join Date
    2006-05
    Posts
    43
    Login to Give a bone
    0

    Default Re: Formula Annoyances: Inconsistent Units, Etc.

    Here's the schedule by itself, without any of the project data.

    Any help would be most appreciated!

    Cheers,
    Peter
    Attached Files Attached Files

  4. #4
    Member
    Join Date
    2006-05
    Posts
    43
    Login to Give a bone
    0

    Default Re: Formula Annoyances: Inconsistent Units, Etc.

    Okay - figured a workaround. I'm still having problems with integers and rounding, so I did this instead - used numbers, and set the field format to round to 1 decimal place. How would others do this with integers and the .5 rounding trick that I've seen in other posts?

    Thanks,
    Peter
    Attached Files Attached Files

  5. #5
    I could stop if I wanted to Tom Dorner's Avatar
    Join Date
    2003-11
    Location
    Phoenix, AZ
    Posts
    371
    Login to Give a bone
    0

    Default Re: Formula Annoyances: Inconsistent Units, Etc.

    The problem with trying to round the values to integers on each space/room occupancy calculation is that you will get an incorrect result for the grand total. This holds true if you are using Excel or Revit. In Excel there is a roundup() function which you can use only on the grand total to take any fraction above a whole number up to the next highest integer. Revit has no such functionality, so I choose to not try and perform rounding in Revit occupancy schedules. I have to simply look at the grand total and do the 'roundup()' in my head.

Similar Threads

  1. 2015: Help, Inconsistent Units in Parameter Formula
    By svaldes88482617 in forum Revit - Platform
    Replies: 1
    Last Post: 2015-01-09, 05:46 PM
  2. 2014: Inconsistent Units with Lookup Table - What Am I Doing Wrong?
    By DMagillIII in forum Revit MEP - Families
    Replies: 1
    Last Post: 2013-08-07, 07:14 PM
  3. Parameter Types. Inconsistent Units converting Sqare Feet to GPM
    By The-Revit-MEPlumbing-User in forum Revit MEP - Families
    Replies: 2
    Last Post: 2011-03-31, 02:26 PM
  4. nested array - Inconsistent units??
    By Martin P in forum Revit Architecture - Families
    Replies: 0
    Last Post: 2007-07-05, 01:27 PM
  5. Schedule - Inconsistent Units
    By Dimitri Harvalias in forum Revit Architecture - General
    Replies: 3
    Last Post: 2006-05-16, 07:05 AM

Posting Permissions

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