Input Non-Linear Functions via Excel


Excel VBA-based tool to import the dynamic load functions into SCIA Engineer via Excel

Input the Displacement-Force or the Rotation-Moment values for the Non-linear functions, that can be used in a non-linear support or non-linear hinge. Very useful when you have to add a lot of non-linear functions, or when you want to ‘generate’ these functions yourself, and import them into SCIA Engineer


Macros need to be enabled for this tool to work.


  1. Make a backup copy of your SCIA Engineer project
  2. Creating a set of Non-linear functions in this excel workbook
    • Go to the Input-sheet in this excel workbook
    • Input a value for 'Name', 'Type', 'Positive End' and 'Negative End'
      • Item 'Name' must be unique
        • When 'Name' is empty, then a red background appears. Exporting stops at the function where the first empty 'Name' is encountered.
      • Item 'Type' equals 0 for Translation, 1 for Rotation.
      • Item 'Positive End' and 'Negative End' equals 0 for Rigid, 1 for Free, 2 for Flexible.
    • Input columns 'u[m]', 'F[N]
      • When Type=Translation, then u is the translation in meter and F is the force in Newton.
      • When Type=Rotation, then u is the rotation in radians and F is the moment in NewtonMeter.
  3. Exporting the NonLinear functions from this excel workbook
    • Go to the Input-sheet in this excel workbook
    • Click the [Export NonLinear Functions]-button
    • Input a name for the XML-file that will contain the definitions of the NonLinear Functions
  4. Importing the exported NonLinear functions 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.