PDA

View Full Version : Rounding for occupancy load calculations



pinky
2006-04-19, 06:24 PM
I have made a schedule for room occupancy using a formula where the aea is divided by the load factor. I want to make sure that the reult is rounded up. How do I go about doing this?

Thanks

Pinky

patricks
2006-04-19, 06:26 PM
I don't think you can change Revit's rounding rules, it always round 0.49 down to 0 or 0.50 up to 1 if rounding to the nearest whole number. You can only change to which place holder it rounds. (nearest hundred, ten, whole number, tenth, etc.).

greg.mcdowell
2006-04-19, 06:58 PM
most jurisdictions I've worked in consider all fractions to be round up... regardless of the typical rules - 23.3 people should really count as 24 - if you can't control how Revit rounds that could lead to problems

Dimitri Harvalias
2006-04-19, 07:01 PM
Check out this thread. (Make sure you scroll down to the later parts of the conversation)

http://forums.augi.com/showthread.php?t=4899&highlight=rounding+bleacher

In short if you want to be sure formulas are always rounded up add .5 to the resulting value, if you want to round down, subtract .5.

greg.mcdowell
2006-04-19, 09:09 PM
Nice workaround!

dhurtubise
2006-04-19, 09:25 PM
Post that in the tips and tricks section. Purely math but works like a charm