Create a laminate spreadsheet report

This example shows how to create a laminate spreadsheet report in Excel. The spreadsheet report lists elements which have a ply margin of safety below 0. The list is sorted in descending order of the XY stress component.

1. In the Simulation Navigator, right-click the laminate post report node and choose Create Spreadsheet Report.The Spreadsheet Report dialog box opens.

2. (Optional) Change the name of the laminate spreadsheet report.The name is displayed in the Simulation Navigator as the node name for the laminate spreadsheet report node.

3. On the Input page, select one or both of the following check boxes:To compute ply stresses, strains, failure indices, strength ratios, and margins of safety from the FEM’s laminate physical properties and the structural solver shell stress resultants, select the Solver Shell Stress Resultants check box and, under Ply Stress Calculation Location, select the ply stress calculation locations.To compute ply failure indices, strength ratios, and margins of safety from the FEM’s laminate physical properties and the structural solver ply stresses and strains, select the Solver Ply Stresses and Strains check box.

4. On the Output page, select the shell stress resultants, ply stress and strain components, and strength analysis results that you are interested in.If you selected the Solver Shell Stress Resultants check box, in the Shell Stress Resultants group, select shell stress resultants.In the Ply Stresses and Strains group, select ply stress and strain components, and their enveloping rule.In the Strength Analysis group, select the strength analysis results and their enveloping rule.The strength analysis results are failure index, strength ratio, and margin of safety results.

5. On the Report Options page, in the Report Object group, create or select a laminate report object that defines the elements and plies for the report.

6. (Optional) In the Failure Theory Override 1 and Failure Theory Override 2 groups, specify up to two ply failure theories and interlaminar failure theories to generate additional results, which you can compare to the results from the failure theories you defined in the FEM.

7. Select the Enable Detailed Output check box to enable filter and sorting of laminate results.Form the Filter Type list, select Ply Margin of Safety.From the Threshold Type list, select Below Threshold.In the Threshold Value box, type 0.0.Clear the Using Absolute Values check box to allow values that are negative.From the Sort On list, select Stress XY.

8. Click OK.In the Simulation Navigator, the laminate spreadsheet report node is created under the laminate post report node. Laminate Post Report 1 Spreadsheet Report 1

9. Right-click the laminate spreadsheet report node and choose Export to Spreadsheet.The spreadsheet opens in Excel.

How do I

Create a laminate post report

Create a laminate graphical report

Create a laminate quick report

View laminate physical properties for a selected element in post processing

Learn more

Advanced post processing of laminate results

Laminate spreadsheet report

Laminate graphical report

Laminate quick report

Laminate report objects

Look up more details

Right-click commands for the laminate post report nodes

Quick links

Command reference

Pre/Post video examples

Bulk Entry Descriptions

Simcenter 3D tutorials

Browse Simcenter 3D help by product area

Create a 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 } });