Results 1 to 8 of 8

Thread: Rounding Up in Schedules

  1. #1
    Member
    Join Date
    2007-03
    Location
    Redditch. UK
    Posts
    31
    Login to Give a bone
    0

    Default Rounding Up in Schedules

    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

  2. #2
    AUGI Addict aggockel50321's Avatar
    Join Date
    2003-05
    Location
    Waterville, Maine
    Posts
    1,748
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

    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

  3. #3
    I could stop if I wanted to
    Join Date
    2007-07
    Location
    London, UK
    Posts
    361
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

    In 2012, there are new round functions to do just that.
    Check here:
    http://www.revitforum.org/showthread...light=formulas

  4. #4
    Member
    Join Date
    2007-03
    Location
    Redditch. UK
    Posts
    31
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

    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

  5. #5
    Certified AUGI Addict patricks's Avatar
    Join Date
    2004-06
    Location
    Memphis TN area
    Posts
    7,048
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

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

  6. #6
    100 Club
    Join Date
    2004-09
    Posts
    104
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

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

  7. #7
    Certified AUGI Addict patricks's Avatar
    Join Date
    2004-06
    Location
    Memphis TN area
    Posts
    7,048
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

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

  8. #8
    All AUGI, all the time archjake's Avatar
    Join Date
    2003-07
    Location
    Tucson, AZ
    Posts
    531
    Login to Give a bone
    0

    Default Re: Rounding Up in Schedules

    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".

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. 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
  5. Schedules and rounding
    By Dimitri Harvalias in forum Revit Architecture - General
    Replies: 11
    Last Post: 2008-08-26, 12:56 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
  •