Announcement

Collapse
No announcement yet.

"Target" Room Area in Schedule?

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

    "Target" Room Area in Schedule?

    This may have been discussed here already, but a quick search did not find anything.

    Trying to see if there is a way in Revit to include a "Target Area" in a Room Schedule, to show the "Desired Program Area" -VS- the Actual Area
    that Revit reports from the Room.

    Sounds like a complex possible solution with "reporting parameters", calculated values, formulas, parameters, etc.

    We know we can do this with an add-in or software such as Trelligence Affinity for Revit, but are wondering if there is a "native" way to do it in Revit?
    Cliff B. Collins
    Registered Architect
    The Lamar Johnson Collaborative Architects, St. Louis, MO
    Autodesk Expert Elite

    #2
    I've done it by adding a Project Parameter "Target Area", which is added to the schedule. In the schedule I also have a calculated field ""Percentage" using a formula = Area / Target Area and formatted as a percentage with no decimals.

    On the "percentage" field, I've also added a conditional formatting = Not between 95% and 105% so that any difference over 5% is displayed in red.
    Attached Files
    Last edited by Munkholm; November 9, 2011, 10:06 PM.
    Klaus Munkholm
    "Do. Or do not. There is no try."

    Comment


      #3
      Thats what we do as well. Very confused why it would be a difficuly or complex task. One additional parameter, one additional Calculated Value, and youre done. Heck, our rooms figure out their occupancy and plumbing fixture requirements (conservatively), based on Use Classifications, too. No other app needed. All simple math.
      Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
      @Web | @Twitter | @LinkedIn | @Email

      Comment


        #4
        And egress door width, ventilation needs, daylighting needs, amount of toilets, staircases and elevators, and so on.
        You could also look into Key schedules for this.
        Martijn de Riet
        Professional Revit Consultant | Revit API Developer
        MdR Advies
        Planta1 Revit Online Consulting

        Comment


          #5
          Good suggestions guys--and we are already doing this. Works great, EXCEPT---it requires manual entering of the Target Area from the Program--thus a chance for human error and coordination problems when changes are made, etc.

          We have looked at Trelligence Affinity for Revit for automating/linking the Program with an Excel database and Revit. Could the DB Link Extension also be used to do this? If we had the Program ( list of spaces, sizes, etc. ) in Excel or Access format?
          Cliff B. Collins
          Registered Architect
          The Lamar Johnson Collaborative Architects, St. Louis, MO
          Autodesk Expert Elite

          Comment


            #6
            Call me stupid but aren't you just moving the problem? One can make mistakes in Excel too you know...
            Martijn de Riet
            Professional Revit Consultant | Revit API Developer
            MdR Advies
            Planta1 Revit Online Consulting

            Comment


              #7
              Originally posted by mdradvies View Post
              Call me stupid but aren't you just moving the problem? One can make mistakes in Excel too you know...
              The Excel file is the Program, which in most cases is provided by the Owner, who controls it and updates it. So--yep, if the Owner makes a mistake in Excel, it ripples thru to Revit.

              But the point is to minimize the manual editing/input, and link the Program to Revit. Same thing as using E-Specs for Revit to link the Specs and Revit model via a database and not rely on a disconnected document which is much more subject to human error.
              Cliff B. Collins
              Registered Architect
              The Lamar Johnson Collaborative Architects, St. Louis, MO
              Autodesk Expert Elite

              Comment


                #8
                A very very simple API function can export a schedule of parameter values to CSV, and can then re-import changes to it. So if someone is hell-bent on mitigating risk, do it that way. Create the parameter, Export the schedule to CSV, and have the owner control and update it in the CSV file, in excel. Then whenever they send you updates, the API command can "reimport" the values for target area.

                Its not seamless, since if they monkey with the spreadsheet in any way other than changing the values, it gets unhappy. But there isnt a cure for the human condition, and there are always ways to mess up a project. Can you tie the revit manual entry to the excel doc? Yep. Does it solve all the issues? Nope.
                Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
                @Web | @Twitter | @LinkedIn | @Email

                Comment


                  #9
                  Have you looked at Mario's utilities on Whitefeet?

                  Comment


                    #10
                    There are several solutions to importing excel data into revit. Google for "Excel to Revit" or "Import Excel Revit" and you'll find a ton, both paid and free. Create a schedule in Revit that matches the layout from Excel and you're good to go.

                    BUT:
                    Is it worth the hassle? I think not...
                    Your principal will create a Program before hand. So without any Room names, numbers or even Levels they should be on (most of the time). Ours usually look like:
                    - Office space 3000m2
                    - Separate office 10pc, 50m2 each
                    - Toilets 1/500m2 Gross building Area
                    And so on... (more fancy layout and just giving examples of different formats but you get my drift). It hardly ever matches Revit format and even if it did: there's a ton of work in creating a Revit Schedule that looks like an Excel spreadsheet. Not to mention Aaron's point about the s**t hitting the fan when anything changes other then the actual values.

                    My guess is that this is just a liability issue... And there's nothing wrong with that. But it might be easier to create some Revit schedules that count all relevant data, and build in the check with manual typing. Can't prevent to do that every once and a while.
                    Last edited by mdradvies; November 16, 2011, 06:24 PM.
                    Martijn de Riet
                    Professional Revit Consultant | Revit API Developer
                    MdR Advies
                    Planta1 Revit Online Consulting

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X