VII.4.2.4 Post-processing worksheets

Those are the worksheets in which the detailed data of post-processing are defined. Four such worksheets are defined so far: “post_connect” is devoted to the post-processing of connection loads, “post_sandwich” is devoted to the post-processing of stresses in sandwich panels, and “post_composite” uses the function “getCompositeRf” that calculates reserve factors using the classical laminate analysis. Worksheet “post_extract” has been added to illustrate the extraction of Results on lists of elements and/or nodes defined explicitly in ranges of cells.

These worksheets mainly use the functions defined in “ExtractionCriteria”, "ResultsExtraction", and “ResultsArchiver” modules. Basically, they define the data, and perform the call to functions of these modules. One makes several remarks about the use of these worksheets:

• The number of worksheets could be increased if necessary without problem. So far, one created three post-processing worksheets, each being devoted to a peculiar type of post-processing (connections, stresses or extraction). However, other types of separations are possible: type of margin, part of the structure...
• One also uses the “getParameter” function of “DbAndLoadCases” VBA module to obtain the appropriate safety factors.
• The functions must depend directly or indirectly on the current load case name if one wants them to be re-calculated each time the selected load case is modified. This means that all the functions refer directly or indirectly to the corresponding cell in “LcSelector” worksheet.
• One separates the calls to the post-processing function from the formatting of Results for archiving. This formatting is used to:
  • Select the values that shall be archived,
  • Modify units (MPa instead of Pa, mm instead of m...),
  • Perform additional calculations (calculation of margins of safety),
  • ...
• Calls to “saveToArchive” function are done to allow to archive calculated Results. (This is particularly useful when one performs loops on a selection of load cases.)