SImple Question Please help! Schedules

[josborn]

Hi everyone,
I am new to the site and am still learning Revit, I am on 2009 Arch. and I am building an area schedule. I am trying to make a calculated value but when I add my values together is gives me an error saying Inconsitent Units???? I just want the values from one column to add with another? Is that allot to ask this program to do? Also when calcing occupant loads, how do I make Revit round up? For example, if my occupant load is 23.6 it needs to be 24. When I try and make the number round up in the formatting tab in schedule properties under field format, it won't work. It's great that it lets you round, but I need it to round up to the next whole number when there is a decimal place. Am I going about this all wrong? Can Revit Calc occupant loads for me or am I asking to much????

Thanks
Joe

[sjsl]

If you are trying to get Revit to tell you how many occupants are in a given space automatically, it cannot and Autodesk will probably never put it in. We have been asking for this prior to aquisition 5 years ago.

[Scott Womack]

Hi everyone,
I am new to the site and am still learning Revit, I am on 2009 Arch. and I am building an area schedule. I am trying to make a calculated value but when I add my values together is gives me an error saying Inconsistent Units???? I just want the values from one column to add with another? Is that allot to ask this program to do? Also when calcing occupant loads, how do I make Revit round up? For example, if my occupant load is 23.6 it needs to be 24. When I try and make the number round up in the formatting tab in schedule properties under field format, it won't work. It's great that it lets you round, but I need it to round up to the next whole number when there is a decimal place. Am I going about this all wrong? Can Revit Calc occupant loads for me or am I asking to much????

You can make it work. To divide to get an integer, you may have to divide the area by 1 SF to remove the units.

To get it to always round up, add .49 in the formula, or get the calculated column, create an additional calculated column and in that column add .49 to the 26.05, which would then force Revit to round the number up.

[josborn]

Hi Scott,
When you get a chance, how do you add the .49 to the formula? aren't the formulas all letter based? Thanks for your help as well!
Joe

[Scott Womack]

Hi Scott,
When you get a chance, how do you add the .49 to the formula? aren't the formulas all letter based?

I/ we use a Key Schedule that is the ICC occupancy loads - #people/SF of the use of the space. We have one for Area Plans, and for smaller projects, we have one for rooms. We feed this one parameter into the type of item we are using, and this puts the use and #people/SF into the area or room, and then a special schedule has the formulas built in.

Take a look at this thread. It is rather long, but has a wealth of information in it. I found it again by doding a search on "Occupancy Schedule" in the forum tools. It explains the rounding, and has examples of these schedules as well.

http://forums.augi.com/showthread.php?t=33275&highlight=Occupancy+Schedules