Return to the examples


Extraction of Nastran XDB file results into excel



Purpose of the excel workbook


The excel workbook discussed here allows to extract results from a Nastran XDB file in excel. The example, contains several worksheets with controls that are linked to excel VBA functions. These functions use the FeResPost COM component that performs the interactions with Nastran model and results. The VBA code is not described here. Those who are interested are referred to the FeResPost Reference Manual for more explanation.

The workbook we present here is provided with FeResPost COM example in "COMEX/EX09/PostXdbRandom.xls" excel file. To run this example, you need to register properly the corresponding version of FeResPost COM component. (The way to do it is explained in FeResPost Reference Manual.)

Note that a similar "COMEX/EX09/PostDesFacRandom.xls" worksheet allows ,to perform similar operations with SAMCEF models, and results extracted from DES & FAC files.

"FemDbIds" worksheet

The first worksheet in which on has to work is the "FemDbIds" worksheet that is used to read the finite element model, and attach an XDB file. Several control buttons allow to perform this operation:

Two other buttons allow to show or hide FeResPost window, and one button allows to close FeResPost. (This last button also destroys all the objects that have been created.)

Finally, an "Export Groups" button allows to save the database groups in a Patran session file.

"ResExtract" worksheet

The "ResExtract" worksheet allows the extraction of Results from the XDB file attached to the current database. Several controls allow to perform this operation:

Finally, the "Extract" button allows to extract the results and fills the spreadsheet starting at line 15. Note that the results are sorted by increasing element ID, node ID, layer ID and sub-layer ID.

"ResExtractCombili" worksheet

"ResExtractCombili" is a variant of "ResExtract" worksheet that allows the extraction of linear combinations of elementary load cases results. It differs from "ResExtract" by:

This worksheet can be useful when the sizing is done using combinations elementary load case results as acceleration load cases.

"WorstResExtract" worksheet

This spreadsheet allows to extracted a limited number of results (the worst one according to a specified criterion). More precisely:

Results are output by decreasing order for the selected criterion. The calculated criterion is given first, then the associated keys and values (components). Note that one has no possibility here to modify the coordinate system wrt which the components are expressed.

"DynamResExtract" worksheet

The "DynamResExtract" worksheet allows the extraction of XDB complex results for SOL 108 and SOL 111 analyses. The differences with "ResExtract" worksheet can be summarized as follows:

"GroupEdit" worksheet

When performing extractions, it can be very frustrating to discover that the group you need is not defined in the current database because it is not defined in the Patran session file you have read in the "FemDbIds" spreadsheet. The "GroupEdit" spreadsheet has been added to allow the user to define new groups, or modify existing groups during an excel session.

The spreadsheet has several capabilities:

The data and controls in range "I1:N7" can be used to define new groups by topological operations.

If you want to save created groups for a later usage, you can export a Patran session file by clicking the corresponding buttons in "FemDbIds" worksheet.



More information on this example, and the manual explaining the functions used in this example are given in FeResPost Reference Manual.



FeResPost Home Page