# 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.

- Make a backup copy of your SCIA Engineer project
- 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.

- Item 'Name' must be unique
- 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.

- 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

- Importing the exported NonLinear functions into SCIA Engineer

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