Input Combinations Via Excel

 

Excel VBA-based tool to import the defined combination into SCIA Engineer

Export the list of load cases from a SCIA Engineer project to this XLS-file, and then create linear (type: linear, envelope and EN) and non-linear combinations, by specifying the coefficients for each load case.

For detailed information: see the Instructions-Sheet inside the excel workbook.

Instructions

Macros need to be enabled for this tool to work.

  1. Make a backup copy of your SCIA Engineer project
  2. Exporting the loadcases from the existing project
  3. Importing the exported loadcases in the Combi-tab
    • Go to the Combi-sheet in this excel workbook
    • Click the [Import Load Cases]-button
    • Select the XML-file from point 2. (see above)
  4. Creating combinations in this excel workbook
    • Go to the Combi-sheet in this excel workbook
    • Define 1 row per combination
    • The column 'Combi ID', 'Name', 'Description' and 'Type' must be inputted
    • Item 'Combi ID' equals 1 for the first combination, 2 for the second, 3 for the third, and so on
    • Item 'Name' is a text-string.
    • Item 'Description' is a text-string.
    • Item 'Type' equals:
      • ENVULS Envelope - ultimate
      • ENVSLS Envelope - serviceability
      • LINULS or ULS Linear - ultimate
      • LINSLS or SLS Linear - serviceability
      • ENULSB or ENULS EN-ULS (STR/GEO) Set B
      • ENACC1 EN-Accidental 1
      • ENACC2 EN-Accidental 2
      • ENSEISM EN-Seismic
      • ENSLSC or ENSLS EN-SLS Characteristic
      • ENSLSF EN-SLS Frequent
      • ENSLSQP EN-SLS Quasi-permanent
      • ENULSC EN-ULS (STR/GEO) Set C
      • NLULS Non-Linear - ultimate
      • NLSLS Non-Linear - serviceability
    • Define a coefficient for each load case
  5. Exporting the combinations from this excel workbook
    • Go to the Combi-sheet in this excel workbook
    • Click the [Export Combi]-button
    • Input a name for the XML-file that will contain the definitions of the combinations
  6. Importing the exported combinations 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 5. (see below)

 

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