FeResPost Web Site                     FeResPost Online User Manual

Chapter VII.2
CLA analyses in excel

In the examples of section VII.1.4, one shows how the FeResPost COM component can be used to automate CLA calculations with different programming languages. However, the small programs done with these examples are not significantly different than the programs presented in Chapter IV.3.

One presents here an example in which the COM component is used in excel and allows to perform operations where the capabilities of excel and FeResPost are used together to produce a small application devoted to CLA calculations. The example is presented in excel spreadsheet “COMEX/EX06/LaminateAnalysis.xlsm”.

The presentation of the example is organized as follows:

The example is meant to be the presentation of a small application devoted to classical laminate analysis. This application is highly customizable provided the user is ready to adapt it to its needs by modifying the spreadsheets and the associated VBA programming.

VII.2.1 Preparing the application
VII.2.2 Workbook events
VII.2.3 Spreadsheets
VII.2.3.1 Spreadsheet “HiddenData”
VII.2.3.2 Spreadsheet “NeutralLines”
VII.2.3.3 Spreadsheet “ClaDbIds”
VII.2.3.4 Spreadsheet “DbUnitsEdit”
VII.2.3.5 Spreadsheet “MatEdit”
VII.2.3.6 Spreadsheet “LamEdit”
VII.2.3.7 Spreadsheet “LoadEdit”
VII.2.3.8 Spreadsheet “MatProperties”
VII.2.3.9 Spreadsheet “LamProperties”
VII.2.3.10 Spreadsheet “LamText”
VII.2.3.11 Spreadsheet “LamLoadResponse_A”
VII.2.3.12 Spreadsheet “LamLoadResponse_B”
VII.2.3.13 Spreadsheet “LamMinMaxCalcArray”
VII.2.3.14 Spreadsheet “LamMinRfCalcScal”
VII.2.4 VBA modules
VII.2.4.1 “calcMatProperties” module
VII.2.4.2 “calcLamProperties” module
VII.2.4.3 “calcLamLoadResponse” module