Seismic Spectrum Generator

 

Excel VBA-based tool to define seismic spectrum into SCIA Engineer

Input of Frequency/Period and Acceleration for a horizontal and vertical spectrum. Very useful when you want to generate the spectrum with formulas from a foreign national code, and import this into SCIA Engineer.

Instructions

Macros need to be enabled for this tool to work.

  1. Make a backup copy of your SCIA Engineer project

  2. Creating a spectrum in this excel workbook

    • Go to the Input-sheet in this excel workbook

    • Input a value for 'ID' and 'Name' (for the Horizonal and Vertical spectrum)

      • Item 'Name' must be unique

      • Item 'ID' equals 1 for the first spectrum, 2 for the second, 3 for the third, and so on

    • Input columns 'Line Nr', 'Frequency', 'Period' and 'Acceleration' (for the Horizonal and Vertical spectrum)

      • Item 'Line Nr' starts with value 1, then 2, then 3, and so on

  3. Exporting the spectrum from this excel workbook

    • Go to the Input-sheet in this excel workbook

    • Click the [Export Spectrum]-button

    • Input a name for the XML-file that will contain the definitions of the spectrum

  4. Importing the exported spectrum into SCIA Engineer

    • Open SCIA Engineer

    • Open the .esa project from point 1. (see above)

    • Select File > Update > XML, and select the exported XML file from point 3. (see below)

This is not official SCIA software and is delivered without any warranty, so always verify the imported data.

If you have any feedback, comments, requests, please feel free to contact us at our e-mail garage@scia.net.