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

Instructions

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.

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