Wind Tunnel Loading Data

Wind tunnel data is huge and tedious to input in ETABS. The data is produced from wind engineering team’s softwares and usually provided in Excel format. If the building is not regular, number of load cases could be more than 20.
How to import all this data into ETABS 9.7 is a big issue because ETABS only lets you export the data to Excel. There is no import facility from any database or Excel sheet. Unlike SAFE and SAP, ETABS does not offer the facility to use interactive database editing too.
I encountered this problem in a recent project and imported the bulk of numbers successfully in ETABS by using Excel and VBA. Please leave your comments on the topic and share your experience on projects that involved wind tunnel loads.

5 Comments

  1. you can just copy and paste the column of data (floor diaphragm wind loads) from Ecel directly into the ETABS load input table.Just make sure the levels in the model correspond to the levels in the worksheet.

  2. yes! but the project i was working had stepped floors so no diaphragms. It was an odd shape! Wind tunnel team provided 27 load cases for about more than 100 panels of steps! thats a lot of data to be applied manually so i did it by vba macros! It was in 2012.

    1. Hi Rana,
      Can you tell me more about this, as i have a building with 652 load cases with 652 time histories one for each case, that needs to be applied separately for x and y direction giving me 1304 separate cases, please help.

  3. Hi Rana,
    Can you tell me more about this, as i have a building with 652 load cases with 652 time histories one for each case, that needs to be applied separately for x and y direction giving me 1304 separate cases, please help.

  4. Well what you can do is,
    apply loads in ETABS and check its text file to know what is ETABS syntax for for applying load.
    Next you can automate this process by using VBA for example and generate a lot of lines of text following this syntax.
    Then save it in a text file and import back in ETABS.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.