VII.4.2.1 “LcSelector” worksheet
This worksheet is used to select the definition of databases and load cases, and to select a sub-set of
load cases that shall be post-processed. Two data must be entered “manually” (they appear in blue in
the worksheet):
- The name of the worksheet in which the definition of databases and load cases is
provided.
- The name of a worksheet containing a selection of load cases and defining the associated
parameters.
The worksheet also defines several automation buttons:
- “ReadDbAndLoadCases” is used to read the definition of databases and load
cases, and the selection of load cases and parameters. The names of the two
corresponding worksheets must first be defined in the appropriate cells below the
“ReadDbAndLoadCases” button. This button is the first to use after opening the
workbook. Indeed, this button initializes lists of load cases and databases in the
“LcSelector” worksheet and several variables in “DbAndLoadCases” module.
- The ComboBox allows to manually select and calculate a load case.
- The “ArchiveResults” button can be used to manually archive the calculated Results in a
separate workbook.
- The “ReinitArchiveResults” button reinitializes all the VBA variables related to the
archiving of calculated Results.
- The “WriteGmshFiles” button performs the writing of Results in GMSH files.
- The “ReinitGmshFilesList” clears all the variables related to the archiving of Results into
GMSH files.
- The “LoopOnLoadCases” button performs the calculations for all the selected load cases
and archives the Results in a separate workbook.
- “Reinit FeResPost Objects” button re-inits all the variables defined in the VBA project,
which restarts from scratch.
- “Debug Current Load Case” button prints in the standard output file debugging
information about the current load case.
More information on the archiving of Results and the creation of GMSH files is provided in the sections
devoted to the corresponding VBA modules.