Rounding Up in Schedules

[Hulston1982]

I am creating a Fire Occupancy Load Schedule, and coming accross a problem.

The Fire Engineer has obviously manufactured his results to give a minimum value of 1 as the room occupancies he has shown all = 1 or above.

But when filling out my schedule, using the same calculations i get 0 in many rows.

My situation is -

I am using a Calculated Value to gain my Occupancy Load. (Area /Occupancy Load Factor)

I have Room A that has an area of 14sq m. The Fire Engineer has given this room an Occupancy Load Factor of 46.5. Meaning the Occupancy Load I am getting = 0.31.

I am currently rounding to the nearest 1 (or no decimal places) as you cannot have half people?

Within Revit this is obviously rounding down to 0, wheras the Fire Engineer has this room as 1.

Is there a way in Revit that I can simply round up and never to the nearest whole number, as in these situations anything over a whole number will always have to be rounded up to the next whole number?

Many thanks for any help available.

Alex

[aggockel50321]

Try this.

Make your Occupancy Load parameter an integer, and use the following expression for your calculated value:

Occupancy Load = Area /Occupancy Load Factor + 0.5

[arqt49]

In 2012, there are new round functions to do just that.
Check here:
http://www.revitforum.org/showthread.php/1046-Revit-Formulas-for-quot-everyday-quot-usage?highlight=formulas

[Hulston1982]

Andrew,

Thanks for your reply. I tried this but didn't recognise that anything that went over the whole number would still round down to the correct number......doh. So should work.


Glad to also hear 2012 has new fnctions like this, although my practice isn't rolling it out just yet.

Many thanks,

Alex

[patricks]

Is it just me or do the ROUNDUP and ROUNDDOWN functions seem backwards?

[peterjegan]

They work the way I would have expected. What are you referring to?

[patricks]

I see it does work as expected. However the link above lists the functions backwards.

[archjake]

You can put an IF statement into a calculated value:

Example formula for Revit:

if((Area / S.F.PerPerson) / 1' ^ 2 < 1, 1, (Area / S.F.PerPerson) / 1' ^ 2)

In English:
If the Area parameter divided by the SF per Person parameter divided by 1 square foot (to strip the units) is less than 1 then make the value 1. If it is greater than 1 it will just perform the calculation of Area / SF per person divided by the 1 square foot.

Then if you need to round any of the fractional occupants up you can add the 0.49 or use the new rounding functions. Both of which were previously mentioned.

P.S. you can also use "/1 SF" in lieu of "/1'^2".