Torsors import from Excel for the interaction diagrams of the pile preliminary design

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 interaction diagrams on preliminary design on piles that can be imported into Scage.

 

Structure of the Excel file to be respected

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.

 

Import structure for ULS import

The table below details the exact column expected for each quantity.

 ACDEF
1PileSituationNMxMy
2  kNkN.mkN.m
3Name of the pile1 : Transient
2: Accidental
000
4...............

 

Example of a table that can be imported into Scage :

 

image-20230531163938524

 

Import structure for SLS import

The table below details the exact column expected for each quantity.

 ACDEF
1PileSituationNMxMy
2  kNkN.mkN.m
3Name of the pile3 : Frequent
4: Quasi-Permanent
000
4...............

 

Example of a table that can be imported into Scage :

 

image-20230531164057393

set_logo_terrasol_v_rvb_300dpi