Announcement

Collapse
No announcement yet.

Not a big mistake but annoying to see...

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Not a big mistake but annoying to see...

    How do you handle the small but annoying mistakes in schedules?
    The attached image is a simple example...
    7.10+3.30+1.67 = 12.06(!) instead of 12.07 ....not a big deal but I don't like it... Apparently Revit adds the real values and not the rounded values inside the cells but is there a way to change it?
    I go to rounding options and change the 2 digits to 0.005 but this shows 3 decimals to my schedule and this is too much for area calculation for a building.
    Attached Files
    Revit Architecture - 3ds MAX Design - Octane Render - and many working hours...
    Tags: None
    #2
    I tell it not to round the values.
    Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
    @Web | @Twitter | @LinkedIn | @Email

    Comment

      #3
      I don't think you can have it both ways: either you round to two digits, or you don't.
      But this is IMHO the right way to handle it. How would you like Revit to use the rounded values when you're dimensioning stuff? It's not supposed to do that. Unfortunately, it's not that smart as to determine by itself whether it's ok to round or not.
      Martijn de Riet
      Professional Revit Consultant | Revit API Developer
      MdR Advies
      Planta1 Revit Online Consulting

      Comment

        #4
        @Twiceroadsfool : How?

        @mdradvies: All I say is that Revit should add the rounded values to find the total and not the measured values... This will be the same as if you added these numbers yourself and it would appear correct.
        Revit Architecture - 3ds MAX Design - Octane Render - and many working hours...

        Comment

          #5
          Originally posted by JTB View Post
          @Twiceroadsfool : How?

          @mdradvies: All I say is that Revit should add the rounded values to find the total and not the measured values... This will be the same as if you added these numbers yourself and it would appear correct.
          I know, and I understand where you´re coming from. But it´s a more difficult question than you´d probably realize. ALL dimensions are rounded values... If I copy a wall 2 times, both times 1000,6mm, the total should never be 2002mm. It should be 2001mm.

          So, when would you want Revit to round, and when wouldn´t you? That's a kind of "smart" thinking IMHO you cannot expect a brainless piece of software to do.
          Martijn de Riet
          Professional Revit Consultant | Revit API Developer
          MdR Advies
          Planta1 Revit Online Consulting

          Comment

            #6
            Originally posted by JTB View Post
            @Twiceroadsfool : How?

            @mdradvies: All I say is that Revit should add the rounded values to find the total and not the measured values... This will be the same as if you added these numbers yourself and it would appear correct.
            Isn't it also incorrect if Revit were to add rounded values? Rounding added to rounding introduces twice the error.
            Scott D Davis
            Sr. AEC Technical Specialist
            Autodesk, Inc.
            http://bit.ly/aboutsdd

            Comment

              #7
              Go in to the Formatting tab of the schedule, select the field, and change the fields rounding down to the most precise it can be.

              Ive had clients ask about it, and i explain that its rounded the parts, and rounding the wholes, and that if theyd like to see the raw data we can look at that as well. That has never NOT been a good enough explanation. Its just logical math.
              Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
              @Web | @Twitter | @LinkedIn | @Email

              Comment

                #8
                Originally posted by Scott D Davis View Post
                Isn't it also incorrect if Revit were to add rounded values? Rounding added to rounding introduces twice the error.
                In the past, I had to correct some of the drawings where the calculations were made... It is a little complicated to explain here, but when we design a building in a property, the sq meters, the volume and the height of the building are connected to the surface of the property.
                Well, correct or not, that's the human way... If you use your calculator for these numbers then when you see 7.096 ->7.10 , 3.296 -> 3.30 and 1.667 -> 1.67... so later you will add 7.10+3.30+1.67 = 12.07 m2.... But if you add 7.096+3.296+1.667= 12.059 -> 12.06
                12.06= closer to reality but when you read these tables you see an error... so, I would prefer the human way, or at least an option to choose.
                Revit Architecture - 3ds MAX Design - Octane Render - and many working hours...

                Comment

                  #9
                  From what I remember of those old lessons in statistics, you're only allowed to round off the result of the equasion, not the input figures. Just like a good calculator and the usual spreadsheets work. I've noticed that the 'ROUND' formula was added to the 2012 versions of Revit, maybe you can use this tool also in schedules?

                  And for doing it 100%: a result can't have more digits than the least significant figure from it's input. So in this case: 7.096 + 3.296 + 1.667 = 12.06. But (assuming these figures aren't rounded before calculating the equasion): 7.10 + 3.30 + 1.67 = 12.1.
                  Arjan Ikink, BIM-engineer at PHB Deventer
                  LinkedIn

                  Comment

                  Previous template Next

                  Related Topics

                  Collapse
                  Working...
                  X