The directory “COM/EX99_XL_EXTRACT” contains an Excel workbook, “PostXdbRandom.xlsm”, devoted to the post-processing of finite element results. More precisely, the Excel workbook allows random access to Nastran XDB results attached to a NastranDb database.
This spreadsheet is not very different from the one presented in Chapter X.D.2. Indeed, the overall organization of the workbook is more or less the same, with spreadsheets and modules devoted to specific tasks:
A hidden spreadsheet called “FemHiddenData” contains some persistent data for menus or selections.
The “FemDbIds” spreadsheet is devoted to accessing the finite element model and results. This spreadsheet is discussed in section VII.4.2.
The “GroupEdit” spreadsheet allows manipulation of the groups stored in the current database. This spreadsheet is discussed in section VII.4.3.
The “ResExtract” spreadsheet performs simple extractions of results for specified groups. A description is given in section VII.4.4.
The “ResExtractCombili” spreadsheet performs extractions of linear combinations of results for specified groups. A description is given in section VII.4.5.
The “WorstResExtract” spreadsheet, presented in section VII.4.6, shows that spreadsheets can be used to select a certain number of values based on a specified criterion.
The “DynamResExtract” spreadsheet is devoted to the extraction of complex results corresponding to dynamic response analyses. This spreadsheet is discussed in section VII.4.7.
Possible improvements to the Excel spreadsheet are discussed in section VII.4.8.
The Excel workbook makes use of the FeResPost COM component. This means that the component must be registered and referenced in the workbook. More information on this subject is given in section VII.4.1.
A Samcef version of the workbook is also provided in directory “COM/EX09” (file “PostDesFacRandom.xlsm”). Its functionalities and principles are very similar to those of the Nastran version.