Donate Now Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

Results 1 to 5 of 5

Thread: Using Excel to drive HP pier foundation heights

  1. #1
    Member ryntau's Avatar
    Join Date
    October 11, 2012
    Location
    St. Louis
    Posts
    403
    Current Local Time
    02:14 PM

    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 Thumbnails Attached Thumbnails Using Excel to drive HP pier foundation heights-sfpier_elevation.png  
    Attached Files Attached Files

  2. #2
    Member
    Join Date
    May 30, 2015
    Posts
    201
    Current Local Time
    04:14 PM
    Quote 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

  3. #3
    Member ryntau's Avatar
    Join Date
    October 11, 2012
    Location
    St. Louis
    Posts
    403
    Current Local Time
    02:14 PM
    That makes sense. I'm not sure how to input the elements in the correct order (by Mark) ?

  4. #4
    Member
    Join Date
    May 30, 2015
    Posts
    201
    Current Local Time
    04:14 PM
    Quote 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

  5. #5
    Senior Member amoursol's Avatar
    Join Date
    November 21, 2012
    Location
    London, United Kingdom
    Posts
    612
    Current Local Time
    10:14 PM
    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 Thumbnails Attached Thumbnails Using Excel to drive HP pier foundation heights-revitforumquery_ryntau_sorting.jpg  

Similar Threads

  1. Renaming From Excel - After Sorting Data in Excel
    By cellophane in forum Dynamo BIM
    Replies: 8
    Last Post: January 18th, 2016, 01:24 PM
  2. Replies: 0
    Last Post: October 19th, 2015, 05:15 AM
  3. Replies: 3
    Last Post: June 6th, 2015, 11:18 AM
  4. create Foundation Tag to be placed at foundation corner
    By khalid_omar in forum Structure - Family Creation
    Replies: 4
    Last Post: March 30th, 2015, 10:16 AM
  5. SSD as os drive or data drive
    By Zacsixchip in forum Hardware and Infrastructure
    Replies: 17
    Last Post: April 12th, 2013, 06:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •