Announcement

Collapse
No announcement yet.

Using Excel to drive HP pier foundation heights

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

    Using Excel to drive HP pier foundation heights

    I feel like i'm missing something really easy here. I'm trying to use an excel table to drive my elevation heights. I currently have all of the piers placed in the right spot with Marks. but for some reason the Elements.SetParameterByName is not setting my elevation offset. Any help would be much appreciated?
    Attached Files
    Ryan Taube
    BIM Manager - Clayco Construction | Lamar Johnson Collaborative

    #2
    Originally posted by ryntau View Post
    I feel like i'm missing something really easy here. I'm trying to use an excel table to drive my elevation heights. I currently have all of the piers placed in the right spot with Marks. but for some reason the Elements.SetParameterByName is not setting my elevation offset. Any help would be much appreciated?
    The Element input expects a list of "revit elements" currently you are inputting "values"


    Sent from my iPhone using Tapatalk

    Comment


      #3
      That makes sense. I'm not sure how to input the elements in the correct order (by Mark) ?
      Ryan Taube
      BIM Manager - Clayco Construction | Lamar Johnson Collaborative

      Comment


        #4
        Originally posted by ryntau View Post
        That makes sense. I'm not sure how to input the elements in the correct order (by Mark) ?
        Try looking at 'sort by key' this should allow you to sort the original element list by the Mark value list.


        Sent from my iPhone using Tapatalk

        Comment


          #5
          Hello Ryntau,

          Is this what you are after?



          Bear in mind that this system works on internal logiac, so that it functions correctly with regards to numbers but will fail if we have a different mark system.

          For example:

          W1
          W11
          W12
          W13
          ...
          W2
          W21

          In lieu of an actual ordering system. In this case, you would have to split the string into numbers only for ordering purposes.
          Attached Files

          Sol Amour

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

          Comment

          Working...
          X