Torsors import from Excel for the pile preliminary design

1 Introduction
Scage allows the import of internal efforts from an Excel file of type .xls and .xlsx.
The purpose of this document is to detail the structure of the Excel file containing the torsors for preliminary design on piles that can be imported into Scage.
2 Structure of the Excel file to be respected
2.1 Sheet structure
Only the “Torsors” tab of the Excel file will be imported.
The first 2 lines of each tab are reserved for quantities and units and must not have numerical values.
The first line describes what is in the column.
The second line describes the unit of the column.
The table below details the exact column expected for each quantity.
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Pile | Combination | Situation | N | Mx | My | Vx | Vy |
2 | kN | kN.m | kN.m | kN | kN | |||
3 | Name of the pieu | 1 : ULS 2 : SLS |
1 : Transient 2: Accidental 3 : Frequent 4 : Quasi-Permanent |
0 | 0 | 0 | 0 | 0 |
4 | … | … | … | … | … | … | … | … |

Example of a table that can be imported into Scage
