FeResPost Web Site                     FeResPost Online User Manual

Chapter VII.3
CLA analyses in excel

The examples of section VII.1.1 show how the FeResPost COM component can be used to automate CLA calculations with different programming languages. However, the small programs used in these examples are not significantly different from the programs presented in Chapter IV.3.

An example is presented here in which the COM component is used in Excel, combining the capabilities of Excel and FeResPost to produce a small application devoted to CLA calculations. The example is presented in the Excel spreadsheet “COM/EX99_XL_CLA/LaminateAnalysis.xlsm”.

The presentation of the example is organized as follows:

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

VII.3.1 Preparing the application
VII.3.2 Workbook events
VII.3.3 Spreadsheets
VII.3.3.1 Spreadsheet “HiddenData”
VII.3.3.2 Spreadsheet “NeutralLines”
VII.3.3.3 Spreadsheet “ClaDbIds”
VII.3.3.4 Spreadsheet “DbUnitsEdit”
VII.3.3.5 Spreadsheet “MatEdit”
VII.3.3.6 Spreadsheet “LamEdit”
VII.3.3.7 Spreadsheet “LoadEdit”
VII.3.3.8 Spreadsheet “MatProperties”
VII.3.3.9 Spreadsheet “LamProperties”
VII.3.3.10 Spreadsheet “LamText”
VII.3.3.11 Spreadsheet “LamLoadResponse_A”
VII.3.3.12 Spreadsheet “LamLoadResponse_B”
VII.3.3.13 Spreadsheet “LamMinMaxCalcArray”
VII.3.3.14 Spreadsheet “LamMinRfCalcScal”
VII.3.4 VBA modules
VII.3.4.1 “calcMatProperties” module
VII.3.4.2 “calcLamProperties” module
VII.3.4.3 “calcLamLoadResponse” module