Announcement

Collapse
No announcement yet.

Schedules & formulas

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    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
    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 ?
    Klaus Munkholm
    "Do. Or do not. There is no try."

    Comment


      #3
      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 Files
      Freelance BIM Provider at Autodesk Services Marketplace | Linkedin

      Comment


        #4
        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 Files

        Comment


          #5
          Make "HOTEL CALC" calculate totals. Then create a calculated value such as "HOTEL QUANTUM" as shown in this illustration:
          Attached Files
          Freelance BIM Provider at Autodesk Services Marketplace | Linkedin

          Comment


            #6
            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)
            Klaus Munkholm
            "Do. Or do not. There is no try."

            Comment


              #7
              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 Files

              Comment


                #8
                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.
                Freelance BIM Provider at Autodesk Services Marketplace | Linkedin

                Comment


                  #9
                  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.

                  Comment


                    #10
                    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

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X