Export to Excel¶
Exports the analysis results of the currently active system into an Excel file *.xlsx
.
There, elements identification information as well as internal forces and moments can be exported
for the following elements:
Beams
Columns
Wall (Resultant forces)
Design Elements
Supports
The results can be exported either only for Revit load cases (single load cases where loads have been defined in Revit) or for all load cases available in the SOFiSTiK Database (also design load cases etc.).
The following identification information is available:
Revit Element ID
orSource Element ID
unique identifier number of element in the Revit model (as provided in Revit by )SPT ID
and/orSLN ID
and/orSAR ID
and/orDSLN ID
ID number of the corresponding structural element in SOFiSTiK’s database (*.cdb
)Element Name
name of the Revit Family of the elementLevel
and/orBase level
and/orTop level
Revit level-related properties of the element (instance properties)SOFiSTiK Name
value provided in the shared parameterSOFiSTiK_Name
of the elementSOFiSTiK Type
type of the element in the SOFiSTiK database (SLN
being a structural line andSPT
a structural point)
Note
The results in Excel are provided in the following Coordinate Systems:
Beam and Column Support results are in the local coordinate system of the Revit analytical element
Wall and Design Element results are with X going upwards, Y orthogonal to the element’s plane and Z in the element’s plane
Support results are in the global coordinate system of the Revit model
Note
Location refers to the relative position along the element’s length, resp. height, where the results is returned. 0 being the Start, resp. Bottom, of the element and 1 being the End, resp. Top, of the element.
Note
Results provided for Supports are reaction forces and moments for the boundary condition elements as well as for supporting elements in subsystems. Line Supports (of type
SLN
) show the summed reaction force/moment over the complete line support’s length.Important
Results provided for Walls (Resultant Forces) and Design Elements are integrated Finite Element Results over the complete length and thickness of the walls. They are sensitive to the mesh quality of the Finite Element Model (especially the number of finite elements in the height of walls).
Important
Wall Resultant forces are integrated values of Gauss Points’ finite element results. They cannot be processed by SOFiSTiK automatic superposition and enveloping mechanisms. If you wish to obtain envelops or superpositions results for wall elements, please activate and use Design Elements.
See also
The following explanatory videos are related to this command: