X.E An Excel workbook devoted to post-processing

In directory “COM/EX99_XL_POST”, an Excel workbook “PostProject.xlsm” is provided, devoted to the automation of stressing of the satellite.

This example shows how FeResPost COM component can be used to build an excel project defining post-processing methods and data. More precisely, the purpose of this example is to define with excel a post-processing similar to the example of Chapter IV.4 with FeResPost ruby extension.

The advantage of using Excel and COM component, is that it is now possible to use Excel to define the different data of the detailed calculation, and several formatting functions. In fact, the definition of data is no longer dispersed in the Ruby programming code. At the same time, The use of functions in Excel allows defining many things such as the sequencing of calculations, the formatting of results, the calculation and archive of results for load cases or not...

Here again, the example is defined in a workbook that contains both worksheets (section X.E.2) and VBA modules (section X.E.3).

X.E.1 Preparing the application
X.E.1.1 “Optimizing” excel
X.E.1.2 Referencing FeResPost in VBA
X.E.1.3 Installing “SQLite for Excel”
X.E.2 Worksheets
X.E.2.1 “LcSelector” worksheet
X.E.2.2 Worksheet for Definition of databases and load cases
X.E.2.3 Worksheet for Selection of load cases and associated parameters
X.E.2.4 Post-processing worksheets
X.E.2.5 “envelopeGMSH” worksheet
X.E.3 VBA modules
X.E.3.1 “DbAndLoadCases” VBA module
X.E.3.2 “ExtractionCriteria” VBA module
X.E.3.3 “ResultsExtraction” VBA module
X.E.3.4 “ResultsArchiver” VBA module
X.E.3.5 “ResultsGmsh” VBA module
X.E.3.6 “Sqlite3” VBA module
X.E.3.7 “UTIL” VBA module
X.E.4 “ExtractionCriteria” VBA module
X.E.4.1 Post-processing of stress Results
X.E.4.2 Post-processing of connection loads
X.E.4.3 composite post-processing

Appendix X.EAn Excel workbook devoted to post-processing

Appendix X.E
An Excel workbook devoted to post-processing