Page 1 of 2 12 LastLast
Results 1 to 10 of 18
Like Tree8Likes

Thread: Schedules & formulas

  1. #1
    Member
    Join Date
    December 31, 2010
    Location
    Singapore
    Posts
    190
    Current Local Time
    11:20 PM

    Schedules & formulas

    Within a schedule formula I am attempting to generate a percentage or a ratio out of 2 areas. It seems that schedules aren't able to generate a number from 2 or more areas. Is this right?
    For instance, I want to divide my hotel GFA against my total GFA to get a percentage.
    If I type either 1 GFA as a number into the formula a get the correct percentage, but if I use both tagged areas in the formula I don't get a percentage or anything.
    The obvious reason I would like to do this is so that I don't have to manually go into my formula's and update the specific areas once they have been redefined.
    Are revit schedules not able to mixed units in formula's?

  2. #2
    Administrator Munkholm's Avatar
    Join Date
    December 7, 2010
    Location
    Kingdom of Denmark
    Posts
    4,138
    Current Local Time
    05:20 PM
    Should be possible, but not quite sure that I understand the question... could you post a screen dump of your schedule ?
    Where do you get the total GFA from ?
    hashimah786 likes this.

  3. #3
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Orlando, FL, USA | info@planta1.com
    Posts
    2,788
    Current Local Time
    11:20 AM
    If I understand your post correctly, yes, it is possible, but you are doing it in the hard way. You can do this with a calculated value, either in a Schedule of Rooms or in a Schedule of Areas (which seems to be the one you need). In the illustration provided, I have made a simple schedule of rooms with Room Name and Room Area. Then I added a calculated value named Percentage, which is already in percentage units, and is set to provide the ratio of each room against the grand total. In the Formatting tab, both "Area" and "Percentage" were set to "Calculate totals".
    Attached Thumbnails Attached Thumbnails Schedules & formulas-percentage.jpg  
    hashimah786 likes this.

  4. #4
    Member
    Join Date
    December 31, 2010
    Location
    Singapore
    Posts
    190
    Current Local Time
    11:20 PM
    This is an area schedule issue.
    Simply put, I would like to generate a number (ratio or percentage) from 2 sets of defined areas within a formula.
    It's possible to add or minus areas but not divide them into an non area figure, ie meters squared into a percentage. It is here that I think Revit is having some trouble. (or me)
    It is highly possible I'm missing something. I have noticed that formulas do not work properly if the area property ticks are left greyed in, they need to be clearly either on or off.
    Attached Thumbnails Attached Thumbnails Schedules & formulas-area-shedule-formula.jpg  
    hashimah786 likes this.

  5. #5
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Orlando, FL, USA | info@planta1.com
    Posts
    2,788
    Current Local Time
    11:20 AM
    Make "HOTEL CALC" calculate totals. Then create a calculated value such as "HOTEL QUANTUM" as shown in this illustration:
    Attached Thumbnails Attached Thumbnails Schedules & formulas-percentage2.jpg  
    hashimah786 likes this.

  6. #6
    Administrator Munkholm's Avatar
    Join Date
    December 7, 2010
    Location
    Kingdom of Denmark
    Posts
    4,138
    Current Local Time
    05:20 PM
    Are you getting the "inconsistent units" error ? If so, try either dividing or multiplying one of the values by 1
    ie: Total GFA / (Hotel GFA * 1)
    hashimah786 likes this.

  7. #7
    Member
    Join Date
    December 31, 2010
    Location
    Singapore
    Posts
    190
    Current Local Time
    11:20 PM
    Yes Alfredo that is what I'm wanting to do. But in my case I am calculating multiple areas in a formula. These area's are calculated from an if statement formula.
    I can't just use area in the formula because there are multiple use area's on the area plan.
    Does that make sense?
    Attached Thumbnails Attached Thumbnails Schedules & formulas-area-shedule-formula-1.jpg  
    hashimah786 likes this.

  8. #8
    Forum Co-Founder Alfredo Medina's Avatar
    Join Date
    December 7, 2010
    Location
    Orlando, FL, USA | info@planta1.com
    Posts
    2,788
    Current Local Time
    11:20 AM
    It does not matter if the other field is in itself a formula. A calculated value can work with the value of another calculated value, as shown in Reply # 5. If the units of the two fields are the same, fine. If the units are different, multiply by one, as in reply # 6.
    hashimah786 likes this.

  9. #9
    Member
    Join Date
    December 31, 2010
    Location
    Singapore
    Posts
    190
    Current Local Time
    11:20 PM
    Thanks to both of your replies. What you're saying makes sense I that was my initial approach but for some reason it just doesn't work. I keep getting figures such 700% percentage or 7 as a ratio. Should be 48.5% or such. There must be something I'm missing, will have any crack at it.
    hashimah786 likes this.

  10. #10
    Member
    Join Date
    December 31, 2010
    Location
    Singapore
    Posts
    190
    Current Local Time
    11:20 PM
    Finally I've had some time to come back and reexamine this problem, ie basing a calculated value on another calculated value. Typically I need to break down planning data and create percentages and ration. To get this to work will be of huge importance to our practice regarding the stringent and thorough area/planning calculations they have here in Singapore. I've been aiming to achieve what Alfredo above had outlined to no success. I tested this out in another test file again to no success.
    I wondering if someone can look at this really simple file and tell me where I'm going wrong?
    My profound thanks.
    Attached Files Attached Files

Page 1 of 2 12 LastLast

Similar Threads

  1. Formulas Type Parameters - Switches
    By Alex Cunningham in forum Architecture - Family Creation
    Replies: 33
    Last Post: May 27th, 2011, 02:45 PM
  2. Interiors & equipment loading | Creating RDS & RLE packages
    By snowyweston in forum Architecture and General Revit Questions
    Replies: 1
    Last Post: May 6th, 2011, 08:49 AM
  3. Schedules within Schedules.
    By Alex Cunningham in forum Architecture and General Revit Questions
    Replies: 7
    Last Post: March 16th, 2011, 03:02 PM
  4. Schedules & Symbols
    By SimAll in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: January 27th, 2011, 10:49 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
  •