Laminate Composites > Solution and post processing > Advanced post processing
Laminate spreadsheet report
The laminate spreadsheet report contains reports on the following laminate results:
The shell stress resultants. The shell stress resultants are written in the material coordinate system.
The specific components of ply stress and strain results.
The failure indices, strength ratios, and margins of safety.
You can sort and filter the laminate results. The spreadsheet also provides summaries for every load case that lists elements and plies with the most critical values.
For each laminate result, you must specify an enveloping type. The software reports:
The maximum and minimum values of the specified laminate results if you select Max & Min.
The minimum values of the specified laminate results if you select Min.
The maximum values of the specified laminate results if you select Max.
The maximum absolute values of the specified laminate results if you select Max Absolute.
The minimum absolute values of the specified laminate results if you select Min Absolute.
The software produces the laminate spreadsheet report from the results sets that you specify for the laminate post report metasolution.
Use the Spreadsheet Report command to specify the structural data, the laminate results, and the filtering settings that you want. You can select the ply coordinate system or the laminate coordinate system for the ply results. You can change your specified settings using the Edit command that you access from the spreadsheet report node. When you specify:
Solver Shell Stress Resultants structural data, the laminate solver gets the shell stress resultants from the structural solver and calculates ply stresses and strains. You can select any combination of bottom, middle, and top locations for the ply stress calculation.
Solver Ply Stresses and Strains structural data, the laminate solver gets ply stresses and strains from the structural solver.
As the laminate solver and the structural solvers do not use same algorithms, the calculated values for ply stresses and strains can differ between the two structural data input selections.
You can export the report to:
A Microsoft Excel spreadsheet
A comma separated-values (CSV) file
Because the software uses the laminate properties in your current FEM, you can switch failure theories and even modify your laminates without updating your solution results to perform what-if analyses.
Changing the ply and interlaminar failure theories in post processing
You can specify one or two ply and interlaminar failure theories in the Simulation file without having to return to the FEM. The software applies the theories to all elements and generates additional results in spreadsheet report when you request one or more of the following outputs:
Failure index
Strength ratio
Margins of safety
Where do I find it?
| Application | Pre/Post |
|---|---|
| Prerequisite | You must work in the Simulation file and a laminate post report must be active. |
| Command Finder | Spreadsheet Report |
| Simulation Navigator | Right-click the laminate post report node→Create Spreadsheet Report |
How do I
View laminate physical properties for a selected element in post processing
Look up more details
Laminate spreadsheet summary tables
Filtering results in laminate spreadsheet reports
Quick links
Command reference
Pre/Post video examples
Bulk Entry Descriptions
Simcenter 3D tutorials
Browse Simcenter 3D help by product area
Laminate spreadsheet report, Simcenter 3D 2021.1 Series
© 2020 Siemens
window.mainLanguage="en_US"
window.delivId=""
window.projectId=""
MathJax.Hub.Config({ TeX: { extensions: ["autoload-all.js"] }, tex2jax: { displayMath: [ ] }, "SVG": { scale: 125 } });
Source: https://docs.sw.siemens.com/en-US/doc/289054037/PL20200601120302950.advanced/id626091 · retrieved 2026-07-17