Input Line Loads on Beams via Excel
Excel VBA-based tool to import the defined line loads on Beams into SCIA Engineer
Input the parameters for line loads on beams. Very useful when you have to add a lot of line loads, or when you want to ‘generate’ these loads 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 Line Load on Beam properties in this excel workbook
- Go to the Input-sheet in this excel workbook
- Input a value for 'id' and 'Name'
- Item 'id' is an integer number and must be unique
- Item 'Name' is the name of the Line Load, and must be unique
- Input columns 'Load Case', …
- here you can input the different Line Load on Beam properties
- Exporting the Line Load on Beam from this excel workbook
- Go to the Input-sheet in this excel workbook
- Click the [Export Line Loads on Beams]-button
- Input a name for the XML-file that will contain the definitions of the Effective css properties
- Importing the exported Line Load on Beam 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)