Skip to main content

Input Load Cases via Excel

Use this MS Excel VBA-based tool to import the defined load cases into SCIA Engineer. Input the parameters for permanent and variable Load Groups, and input the parameters for permanent and variable Load Cases. Very useful when you have to add a lot of load cases, or when you want to ‘generate’ these load cases yourself, and import them into SCIA Engineer 

Instructions

Macros need to be enabled for this tool to work.

  1. Copy-paste the forces data to the “Point loads” sheet
  2. Click “Create file” to generate an XML input file for SCIA Engineer (and its associated “*.xml.def” definition file)
  3. In SCIA Engineer, make sure that there are load cases and node names as used in the Excel
  4. Importing the exported Line Load on Beam into SCIA Engineer
    • Open SCIA Engineer
    • Open the .esa project from point 1. (see above)
    • Select Main menu > File > Update from > XML file, and select the exported XML file from point 3. (see below)