Spreadsheet Report dialog box

Basic Settings
Name	Specifies a name for the laminate spreadsheet report. The name is displayed in the Simulation Navigator as the node name for the laminate spreadsheet report node.

Input page

Solver Input
Specifies the structural results that are used as the input to the laminate solver for calculating laminate graphical results.
Solver Shell Stress Resultants	Computes ply stresses, strains, failure indices, strength ratios, and margins of safety from the FEM's laminate physical properties and the solver shell stress resultants.
Solver Ply Stresses and Strains	Computes ply failure indices, strength ratios, and margins of safety from the FEM's laminate physical properties and the solver ply stresses and strains.
Ply Stress Calculation Options
Available when Solver Shell Stress Resultants is selected.
Ply Location	Determines where the software computes and displays the ply stress results. You can select any combination of bottom, middle, or top of the ply.
Coordinate System	Specifies the coordinate system.PlyUses the ply's coordinate system.LaminateUses the laminate's coordinate system. The laminate coordinate system is the material coordinate system.
Element Nodal Results
Specifies the format for storing and displaying laminate results.
Elemental	Averages the element-nodal values received from the structural solver, and uses the average value at the element centroid.
Element-Nodal	Uses the element-nodal values received from the structural solver.

Output page

Shell Stress Resultants
Available when you select the Solver Shell Stress Resultants option on the Input page.If you export the spreadsheet report to Excel, the results of the selected shell stress resultants are written to the 1–1–1. Results (Shell) sheet where 1–1–1 is the index for the solution set.
All	Selects all shell stress resultants components to write to the spreadsheet report. If all check boxes are selected, it deselects them all.
Fx	Writes the X component of the shell stress resultant.
Fy	Writes the Y component of the shell stress resultant.
Fxy	Writes the XY component of the shell stress resultant.
Qx	Writes the X component of the transverse shear resultant.
Mx	Writes the X component of the moment stress resultant.
My	Writes the Y component of the moment stress resultant.
Mxy	Writes the XY component of the moment stress resultant.
Qy	Writes the Y component of the transverse shear resultant.
Ply Stresses and Strains
If you export the spreadsheet report to Excel, the results of the selected ply stress and strain components are written to the 1–1–1. Results (Stress) sheet where 1–1–1 is the index for the solution set.
Ply Stresses Ply Strains	Writes ply results to the spreadsheet report.Max & Min specifies both the maximum and minimum values for the selected result type.Min specifies the minimum values for the selected result type.Max specifies the maximum values for the selected result type.Max Absolute specifies the maximum absolute values for the selected result type.Min Absolute specifies the minimum absolute values for the selected result type.
All	Selects all ply stress or strain components to write to the spreadsheet report. If all check boxes are selected, it deselects them all.
11	Writes the 1 direction components.
22	Writes the 2 direction components.
33	Writes the 3 direction components.
12	Writes the 12 direction components.
23	Writes the 23 direction components.
31	Writes the 31 direction components.
Maximum Principal	Writes the maximum principal stress or strain.
Minimum Principal	Writes the minimum principal stress or strain.
Max Shear	Writes the maximum shear stress or strain.
Von Mises	Writes the Von Mises stress or strain.
Strength Analysis
Failure Index Strength Ratio Margin of Safety	Specifies the type of strength analysis results to output. For each result type that you select, you can specify one of the following enveloping rules:Max & Min specifies both the maximum and minimum values for the selected result type.Min specifies the minimum values for the selected result type.Max specifies the maximum values for the selected result type.Max Absolute specifies the maximum absolute values for the selected result type.Min Absolute specifies the minimum absolute values for the selected result type.
Failure Mode	Specifies the failure mode that the result module uses to calculate failure indices.In-plane plyComputes the ply failure.InterlaminarComputes the bond failure.BothComputes both the in-plane ply failure and the bond failure.
Factor of Safety	Sets a safety factor for the margin of safety computation.

Report Options

Report Object
Report object list	Specifies the laminate report object that defines the elements and plies used in the laminate spreadsheet report.
Create Report Object	Available when you select None from the report object list.Opens the Laminate Report Object dialog box that lets you create a laminate report object.
Edit	Available when you select an existing report from the report object list.Opens the Laminate Report Object dialog box that lets you modify the selected laminate report object.
Open Manager	Opens the Report Object Manager dialog box that lets you create or select a laminate report object.
More Options	Displays the Options subgroup.
Options	Lets you search and filter laminate report objects using the following options:FindLets you search for a laminate report object by entering the full name of the object.For example, to find a report object named ABC_report, type ABC_report in the search box and press Enter or click Find .Filter by NameLets you filter the list by the names of the report objects. This filter supports wildcards. The default wildcard is the asterisk (), and it displays all entries in the list.For example, to filter the list to display every report object with a name starting with the letter “a," enter a as the filter string.
Failure Theory Override 1 and Failure Theory Override 2
Specifies the ply and interlaminar failure theories that the software uses for ply failure results that are additional to the ones generated using the failure theories defined in the FEM. You can select one or two different failure theories to generate and then compare the results in the report.
Ply Failure Theory	Lets you specify a ply failure theory.
Interlaminar Failure Theory	Lets you specify an interlaminar failure theory.
Detailed Output
Enable Detailed Output	Writes the detailed ply results table in the spreadsheet.
Filter Results	Available when the Enable Detailed Output check box is selected.Specifies how the data is filtered. You can limit the output by only displaying data that are above or below a specified threshold of a selected filter type. You can also filter results using their absolute value.
Sort Results	Available when the Enable Detailed Output check box is selected.Specifies the type of data that is used to sort the filtered results and how the results are ordered in the spreadsheet report. You can also choose to sort results using their absolute value.

How do I

Specify a user-defined failure theory

Create a laminate post report

Create a laminate spreadsheet report

Learn more

Advanced post processing of laminate results

Laminate spreadsheet report

Look up more details

Hill failure analysis (2D)

Hoffman failure analysis (2D)

Tsai-Wu failure analysis (2D)

Maximum stress failure analysis (2D)

Maximum strain failure analysis (2D)

Von Mises yield and Von Mises ultimate failure analyses (2D and 3D)

Maximum transverse shear stress

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

Spreadsheet Report dialog box, 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 } });