Chapter VII.3
Extraction and manipulation of Results with excel

In directory “COMEX/EX09”, one gives an excel workbook “PostXdbRandom.xlsm” devoted to the post-processing of finite element Results. More precisely, the excel workbook allows to access randomly Nastran XDB results attached to a NastranDb DataBase.

This spreadsheet is not very different than the one presented in Chapter VII.4. Indeed the global 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.
• Spreadsheet “FemDbIds” is devoted to the access to finite element model and Results. This spreadsheet is discussed in section VII.3.2.
• Spreadsheet “GroupEdit” that allows to manipulate groups stored in the current database. This spreadsheet is discussed in section VII.3.3.
• Spreadsheet “ResExtract” performs simple extractions of Results on specified Groups. A description is given in section VII.3.4.
• Spreadsheet “ResCombiliExtract” performs extractions of linear combination of Results on specified Groups. A description is given in section VII.3.5.
• In “WorstResExtract” spreadsheet, presented in section VII.3.6, one shows that the spreadsheets may be used to select a certain number of values based on a specified criterion.
• Spreadsheet “DynamResExtract” is devoted to the extraction of complex Results corresponding to dynamic response analysis. The spreadsheet is discussed in section VII.3.7.
• Possible improvements of the excel spreadsheet are discussed in section VII.3.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.3.1.

A Samcef version of the workbook is also given in directory “COMEX/EX09” (file “PostDesFacRandom.xlsm”). Its functionalities and principles are very similar to those of Nastran version.