Announcement

Collapse
No announcement yet.

Swapping out Curtain Panels

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

    Swapping out Curtain Panels

    I wondering if this is even possible. I have a Curtain wall with a regular grid, 20 wide by 9 tall. I have 18 different curtain panels that i'd like to place in this curtain wall following certain rules. Is it possible to swap out panels for my custom panels using corresponding cells in Excel?

    or is there a different approach i should be looking for?
    I've attached a couple of images

    Thanks,
    Attached Files
    Ryan Taube
    BIM Manager - Clayco Construction | Lamar Johnson Collaborative

    #2
    Simply put, yes. Several plugins will do this as will Dynamo.


    Sent from my iPad using Tapatalk
    Greg McDowell Jr
    about.me/GMcDowellJr

    Comment


      #3
      at its most basic, here's the graph. i think it's just a matter of parsing down the list of panels now.
      Attached Files
      Ryan Taube
      BIM Manager - Clayco Construction | Lamar Johnson Collaborative

      Comment


        #4
        Hello Ryan,

        So you're going to run into one or two problems. Namely, paring the structure of your Excel with the actual panels. But it's all solvable.

        I've re-created your example in my own way as follows:



        I've generated 100x shuffled Types of panel I want to match. In this case, they are also colour coded.

        I want to pair each one within Revit as it appears in Excel. To do so, we need to check if the way in which the panels are sequentially built in Revit matches our system.

        I bring through my excel data (Which is just text) and flatten off the listings (As the Curtain panels are a flat list).



        I then simply use them as a Key when I'm pairing my panels through the List.GroupByKey method.



        As my families are called the same thing as my keys, I can simply use FamilyType.ByName to pull them from the Revit document. If you'rs are different, you'll simply have to create a list of them based around your key list structure.

        This gives me the following results:



        However, the way the Curtain Panels have been generated doesn't quite match my colour scheme in Excel. So I need to fix my panels first.



        What I want is to find out how they panels appear in the list. If I use a simple colour override and pick elements of a full line and one additional, I can see how this builds:



        This is showing that my first line is running along the base, then it starts back at the same place, but one line above. You can test this by changing the designscript format.




        So what we need to do, is chop up our list using List.TakeEveryNthItem, transpose said list, reverse the sub-groupings and then reverse the entire outer list... rather convoluted I know



        But it does give us our result!!

        Attached Files

        Sol Amour

        Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
        Portfolio Website @ Cargo Collective

        Comment


          #5
          Another approach to make lists match could consist in classifying the panels by their coordinates.

          Comment


            #6
            Originally posted by Yna_Db View Post
            Another approach to make lists match could consist in classifying the panels by their coordinates.
            Totally! The problem with geometrical methods is they get heavy, and you can't use Element.GetLocation on Curtain Panels If you have to pull Element.Geometry it get's nasty the bigger the panels are.

            Sol Amour

            Architectural Explorer, Digital warrior, Affectual adventurer and Curious Human Being
            Portfolio Website @ Cargo Collective

            Comment


              #7
              You can still use the elements bounding boxes min points, it shouldn't be too heavy to manipulate...

              Comment


                #8
                this is the way i approached it, i'm sure there is some consolidation that could take place. this is also assuming that the number of panels in the x and y direction don't change.

                Edit: i've also chopped it down a bit, i have 19 panels to choose from, not just the 4 shown here.
                I think your Keys approach will allow me to make it much simpler
                Attached Files
                Last edited by ryntau; September 8, 2017, 06:32 PM.
                Ryan Taube
                BIM Manager - Clayco Construction | Lamar Johnson Collaborative

                Comment

                Related Topics

                Collapse

                Working...
                X