Announcement

Collapse
No announcement yet.

Scheduling the Maximum Number of fittings / area

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

    Scheduling the Maximum Number of fittings / area

    To comply with the sound building regulations (code) here in the UK, I need to make sure that there is not more than 1 light fitting per 2m2 of ceiling area in each room.

    I thought that this should be simple to schedule in Revit, and it probably is, but I'm getting stuck at the starting point.

    I have my light fixture schedule which has a quantity (count) total per room, and each room area in m2. So the schedule fields include 'Count' and 'Room: Area'. But when I go to add a Calculated Value the available fields doesn't have 'count'. So my great idea of making a formula that is area/count is a non starter.
    I'm looking to have in my schedule a column that if the area/# of fittings are >2m2 then all is OK but if area/# of fittings is less than 2m2 then it'll flag up in red. (I'm OK with the conditional formatting, its the formula that has me stuck).

    Thanks

    #2
    Yes, unfortunately you cant do anything with the totals, of count or any other parameter, in Revit itself. (Yet another example of Autodesks typical 'unfinished', almost there but not quite, functionality...)

    I personally recommend using an Excel Import/Export tool, such as BIMLink or make one yourself with Dynamo. Use Revit to extract data from your models and to store the results of calculations but do the actual calcs in another program. It is simply much much easier to handle data any way you want in excel than it is to struggle with revits limitations.

    What I would really like to see is the implementation of a simple version of Excel (Or to be correct 'An open source cell based calculator') in the title areas of schedules, where it is already possible to make cells.
    "One must imagine Sisyphus happy." Albert Camus - "The innovator has for enemies all those who have done well under the old conditions, and lukewarm defenders in those who may ​do well under the new." Nicolo Machiavelli -"Things that are too complex are not useful, Things that are useful are simple." Mikhail Kalashnikov

    Comment


      #3
      Agree with Joseph, also , learning Dynamo can help you with a lot of the heavy lifting, and export / import with Dynamo is really easy.
      There are no stupid questions, only stupid people

      Comment


        #4
        Originally posted by elton williams View Post
        learning Dynamo can help you with a lot of the heavy lifting
        I was really hoping that this could be done within Revit with formulas without me having to learn Dynamo.

        I suspect lots here will tell me Dynamo is easy, but when you have little time to set aside to learn something completely new from scratch you'll tend to put it aside, which is what I'll have to do. I have a list of things I need to learn, including all the latest and greatest social media platforms, Apps and this week's 'really useful stuff' my kids keep telling me about
        ("forget ebay, try this: all you need to do is set up an account, click here, select this then......."), so I guess Dynamo will have to be added to this list.

        Comment


          #5
          with a few parameters and some math you can do what you need with a schedule:
          https://www.revitforum.org/tutorials...al-mayhem.html
          https://www.revitforum.org/architect...tml#post158176
          Last edited by cellophane; January 23, 2017, 02:43 PM.
          Revit for newbies - A starting point for RFO


          chad
          BEER: Better, Efficient, Elegant, Repeatable.

          Comment


            #6
            Whaaat????
            Thats clever...

            Never thought of doing Number / %of Total Number

            You can get the percent of total by type or family too, instead of by grand total like in the example.

            {Adds Number=1 parameter to family template}
            Last edited by josephpeel; January 23, 2017, 02:58 PM.
            "One must imagine Sisyphus happy." Albert Camus - "The innovator has for enemies all those who have done well under the old conditions, and lukewarm defenders in those who may ​do well under the new." Nicolo Machiavelli -"Things that are too complex are not useful, Things that are useful are simple." Mikhail Kalashnikov

            Comment

            Loading...
            Working...
            X