See the top rated post in this thread. Click here

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

Thread: Schedules and rounding

  1. #1
    Certifiable AUGI Addict Dimitri Harvalias's Avatar
    Join Date
    2015-12
    Location
    Vancouver, BC Canada
    Posts
    3,753
    Login to Give a bone
    0

    Default Schedules and rounding

    Is there a way to deal with rounding errors in a schedule total?
    Check the attached image. The individual room areas are rounded to one decimal place, as is the total. The problem is when you add the digits up for the decimal values they don't add up to the value displayed in the grand total.

    I know the areas are correct but some people get worked up about the fact that Revit 'can't add' a simple column of numbers and they start to doubt the accuracy of the numbers.

    Thanks
    Attached Images Attached Images

  2. #2
    Active Member
    Join Date
    2007-04
    Posts
    80
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    This seems to be typical of CAD applications in general.

    ACA2008 also has this problem with it's Spaces Tool (similar to Revit rooms). I've had an entire building Area Analysis plan dismissed because of it.

    To rectify I had to display a ridiculous amount of decimal placings. Wish they would fix it.

  3. #3
    Revit Forum Manager Steve_Stafford's Avatar
    Join Date
    2001-12
    Location
    Irvine, CA
    Posts
    7,567
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    cad in general, try life... our bank has a "keep the change" program where they round purchases up and down depending on the how close to a whole dollar they are. This means we have fun balancing our checking...but we've collected several hundred dollars in the process, at least it looks that way

    We also have overall dimensions that don't "add" up correctly don't we?

    Where such rounding is employed I'd state it with a disclaimer at the bottom/top or both so it is clear that the individuals are rounded and the total represents the accurate accounting of area.

    We had a project where school rooms had to be a minimum area and we designed them slightly larger. We arrived at the same number for all but the end rooms where thicker wall construction reduced the size by a little bit but not less than the required minimum. The client objected to the difference and the PM blamed it on a computer glitch rather than explaining that the room is actually a little smaller in reality from a construction standpoint. The answer, we just want the tag to say the same number please. So room area accuracy...in whose eyes? Sorry no help...just blabbering...

    Might be nice if we could tell the schedule totals to report the rounded total so the column(s) does add up eh?
    Last edited by Steve_Stafford; 2007-06-28 at 03:18 AM.

  4. #4
    Certifiable AUGI Addict Dimitri Harvalias's Avatar
    Join Date
    2015-12
    Location
    Vancouver, BC Canada
    Posts
    3,753
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    Thanks guys. That's what I figured. The municpal authority that my client is dealing with seems to be just looking for an excuse to be a PITA.

  5. #5
    Count (Formula) dbaldacchino's Avatar
    Join Date
    2005-07
    Location
    Missouri City, Texas (Houston area)
    Posts
    3,250
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    You could always use a shared parameter and type the area in manually I'd only do that in case they're being a PITA. We always turn off areas on our final plans and just have occupancy numbers showing.

    I have not played around with this, but am wondering if it's possible to create a calculated column that would round your area and make it an absolute number; then your totals should not have any variation. You would then hide the actual area column in your schedules and just use this calculated column.

  6. #6
    Revit Mararishi aaronrumple's Avatar
    Join Date
    2002-02
    Location
    St. Louis, MO
    Posts
    4,695
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    ...just increase the accuracy out to the square nanometer. Let the complainers do the rounding.

    We had a project (school) where the classrooms were to be 800 sf. I had the rounding set to 2 decimal places. and the classroom was 800.25 sf. Only off by 34.56 sq. in. - or the size of standard envelope. The CM reviewer said no good - redesign. I reset the rounding to no decimals.

    Lets face it - in construction if the contractor is within +/-1" - I'm thrilled.

  7. #7
    I could stop if I wanted to rdaniel's Avatar
    Join Date
    2006-12
    Location
    Dallas, TX
    Posts
    215
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    Quote Originally Posted by dbaldacchino View Post
    We always turn off areas on our final plans and just have occupancy numbers showing.
    David,

    How are you rounding up for occupancy loads? Ex. if the area is 110SF & and the occ. factor is 100, then the occupancy load is 1.1, but needs to round up to 2. Standard rounding in Revit would round it down to 1.

  8. #8
    Active Member
    Join Date
    2004-05
    Posts
    77
    Login to Give a bone
    1

    Default Re: Schedules and rounding

    One workaround that I use all the time is to add 0.49 to the occupancy calculation formula. (I think I got that tip on this newsgroup).
    So my occupancy calc reads " (Area/Occupant Load Factor) + 0.49.
    It seems crude but it works all the time, at least so far.

    John Tobin

  9. #9
    Count (Formula) dbaldacchino's Avatar
    Join Date
    2005-07
    Location
    Missouri City, Texas (Houston area)
    Posts
    3,250
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    That's exactly what I do and I also learned that technique a while back from these forums.

  10. #10
    I could stop if I wanted to rdaniel's Avatar
    Join Date
    2006-12
    Location
    Dallas, TX
    Posts
    215
    Login to Give a bone
    0

    Default Re: Schedules and rounding

    Ah, another workaround, but at least it works. Thanks guys.

Page 1 of 2 12 LastLast

Similar Threads

  1. 2013: Rounding to nearest .5 in schedules
    By jplatte in forum Revit MEP - General
    Replies: 8
    Last Post: 2013-04-08, 06:30 PM
  2. Revit Schedules Rounding up and adding up..correctly
    By Wish List System in forum Revit Architecture - Wish List
    Replies: 1
    Last Post: 2012-05-04, 03:58 AM
  3. Rounding in Schedules- display correct totals
    By tarrah in forum Revit Architecture - Tips & Tricks
    Replies: 3
    Last Post: 2012-03-14, 07:28 PM
  4. Rounding Up in Schedules
    By Hulston1982 in forum Revit Architecture - General
    Replies: 7
    Last Post: 2011-05-23, 04:38 PM
  5. I wish Revit could add correctly when using rounding in schedules.
    By revit.wishlist1942 in forum Revit Architecture - Wish List
    Replies: 1
    Last Post: 2010-03-12, 12:18 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
  •