Return to the examples


Classical Laminate Analysis in Excel using FeResPost COM Component



Purpose of the excel workbook


The excel workbook discussed here illustrates what is possible to do with excel, VBA and FeResPost COM component. In this case one is particularly interested in classical laminate analysis capabilities of FeResPost. In this page, one presents the excel workbook usage, but not the programming of VBA code. Information on this VBA code can be found in FeResPost Reference Manual and of course, you can read the VBA code with excel VBA editor.

The workbook we present here is provided with FeResPost COM example in "COMEX/EX06/LaminateAnalysis.xls" excel file. To run this example, you need to register properly the corresponding version of FeResPost COM component. The way to do it is explained in FeResPost Reference Manual.

Note that the excel workbook we describe here is used to perform Classical Laminate Analysis (CLA) with FeResPost in excel, without interaction with Nastran or Samcef finite element results post-processing. It allows though to import CLA entities from Nastran and Samcef FE models. But the reader should be aware that FeResPost's CLA classes are more powerful than what is presented here. In particular, they can interact with other FeResPost classes and be used in FEM results post-processing by for example:

(This makes the CLA classes of FeResPost a very powerful tool for composite assessment in structure.)


Excel workbook

At the moment, we just present different worksheets that can be used to perform classical laminate analysis (CLA) calculations. (You can access the VBA code of the application via excel VBA editor, but we do not explain here how this code works.)

"ClaDb" worksheet

The "ClaDb" worksheet should be considered as the main worksheet of the excel workbook. Among other things, it allows you to:

If you want to retrieve the current composite database next time you open the workbook, you have to make sure that the two previous operations have been done. (Be careful with this because it is a common mistake to forget one of the operations.)

"MatEdit" worksheet

The "MatEdit" worksheet allows you to create or modify materials (ClaMat objects) in the composite database:

 The edition of material properties is done by filling the lower tables in the worksheet:

Note that the user is entirely responsible for the data inserted in the different tables. Data that can not be interpreted by FeResPost are simply ignored when the material is inserted in the composite database. User is referred to the description of "ClaMat" class and theoretical background in FeResPost Reference Manual to identify which data must be defined.

"LamEdit" worksheet

The "LamEdit" worksheet is used to create new laminates (ClaLam objects) or modify existing ones. The worksheet has three form controls:

The data defining the laminate must be introduced in the tables below the controls:


"LoadEdit" worksheet

The composite database also allows to defined and store "ClaLoad" objects. The "LoadEdit" worksheet allows to define or modify these "ClaLoad" objects. The worksheet has two form controls:

The following data allow the definition of load object:

For all the mechanical components of laminate loading, one can choose to define the component as strain or curvature, or as force or moment. This is the reason why a Combo box is associated to each component. The Combo box has two values: "SC" (strain/curvature) or "FM" (force/moment).

"DbUnitsEdit" worksheet

This worksheet allows you to modify the system of units associated to entities stored in the composite database. In the spreadsheet, one finds the following elements:

Note the difference between the "setting" and "changing" of units:


"MatProperties" worksheet

The "MatProperties" worksheet allows you to examine material properties:

Then, the following properties are displayed:


"LamProperties" worksheet

The "LamProperties" worksheet allows you to examine material properties:

Then, the following properties are displayed:

"LamLoadResponse_A" worksheet

The "LamLoadResponse_A" worksheet allows the calculation of laminate load response and ply failure indices for a specified loading. The loading is selected among the loads stored in the composite database.

The calculation data are defined as follows:

The following results are calculated:


"LamLoadResponse_B" worksheet

This worksheet performs the same calculations as "LamLoadResponse_A", but the loading applied to the laminate id directly defined in the spreadsheet. One no longer selects a loading defined in the composite database.

The definition of loading is done by specifying the different components by filling the corresponding cells. Combo boxes allow to define whether the component is defined as shell force or moments, or as average strain or curvature. For the other data, please go to the description of "LamLoadResponse_A" worksheet for more information.


"LamMinMaxCalcArray" worksheet

In "LamMinMaxCalcArray" worksheet, one calculates critical (i.e. the value for most critical ply) failure indices, reserve factors or equivalent stresses, for several composite failure criteria and several load cases.

The calculation data are defined as follows:

(In the spreadsheet, that calculates the most critical ply, the "MIN/MAX" value is calculated by a formula that depends on the type of result that is calculated. Its result is "MAX" for equivalent stress, and "MIN" otherwise.)

The calculation is done by calling "calcPliesMinMaxCriterionArray" that returns a matrix that performs the array calculation by a single function call. Note that  a "LamMinMaxCalcArray" scalar version of the spreadsheet exists. In that version, each calculated value is obtained by a separate call  to "calcPliesMinMaxCriterionArray" VBA function.

Array calculation of failure criteria



More information on this example, and the manual explaining the functions used in this example are given in FeResPost Reference Manual.



FeResPost Home Page