Wind Tunnel Loading Data
Wind Tunnel Loading Data
Wind tunnel data is huge and tedious to input in ETABS or structural softwares. This data is produced from the wind engineering team’s softwares and usually provided in excel format. Usually if the building not regular, number of load cases are more than 20.
How to import all that data into ETABS model is still 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.
Well, I encountered this problem in my recent project, and then atlast I was able to import this bulk of numbers successfully in ETABS by using excel and VBA. Although I wrote the code for the format of data presented to me by the wind engineering team but it can be quite easily modified to satisfy other formats. Alternatively the wind tunnel data can be reformatted to match with the format, the coding accepts.
If someone out of you has faced a similar problem and is unable to execute it, you can contact me personally. May be I upload the sheet soon here but for sure not now.