Skip to main content

Input Combinations Via Excel

Use this MS 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 nonlinear 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. Export the loadcases from the existing project (Main menu > File > Export to > XML file)
  3. Import 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. Create 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. Export 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. Import the exported combinations 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 5. (see below)