Excel file description for Scage
Excel file description for ScageIntroductionStructure of the Excel file to be respectedStaged construction managementSheet structure
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 internal efforts (N, V, M) that can be imported into Scage.
Structure of the Excel file to be respected
Staged construction management
When importing, each sheet of the Excel file will be interpreted as a calculation phase in Scage.
Sheet structure
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.
About the system of units
An Excel file can use one unit system per tab :
- Metric unit system
- Imperial unit system
The unit system is detected with the field in A2 of each tab :
- If this field is "ft", the considered unit system will be the imperial one
- If this field is anything else, the considered unit system will be metric
The table below details the exact column expected for each quantity.
It is important to note the presence of empty columns between certain sizes.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Level | Moment | Shear force | Axial force | ||||
| 2 | m or ft | m.kN/m or ft.kips/ft | kN/m ou kips/ft | kN/m or kips/ft | ||||
| 3 | 0 | 0 | 0 | 0 | ||||
| 4 | ... | ... | ... | ... |
Example of a table that can be imported into Scage :
