VII.3.4 Simple extraction of Results

This spreadsheet is used to perform simple extraction of Results but nothing more. (Except that modification of coordinate systems are also done.) Several ComboBoxes allow to define the parameters for the extraction:

• Selection of the name of the Group on which the Results shall be extracted.
• Selection of the load case name.
• Selection of the sub-case name.
• Selection of the Result type name.
• Selection of the “location” parameter. For example “Nodes”, “Elements” “ElemCenters”... This parameter, together with the name of the Group determines on which element and node entities the Results are extracted.
• The coordinate system in which the Result components shall be extracted. This is the only parameter corresponding to a post-processing calculation done on the Result.
• A checkBox allows to specify whether the data are recovered in a projected coordinate system (when applicable). Then, three real values specify the components of the coordinate systems given in the selected coordinate system.
• It is possible to select the layers on which results will be extracted (when applicable). The choice is between “all layers” (no layers selection) or a range address. The range corresponds to a selection of cells in which the layers are given.

When all the parameters have been defined, the “Extract” button performs the extraction and fills cells in the spreadsheet starting at line 15. More precisely, the following operations are done in the corresponding VBA subroutine:

1.

The current NastranDb DataBase is retrieved using method “getDb” of FemDbIds spreadsheet.

2.

The names of selected load case, sub case and result type are used to import Results into the current DataBase. (The XDB file name has been selected in “FemDbIds” spreadsheet.)

3.

The Group corresponding to the selected Group Name is retrieved from the current DataBase. (“getGroupCopy” method of NastranDb class.)

4.

This Group, the selected location and the names of load case, sub-case and result type are used to retrieve a Result from the DataBase using “getResultCopy” method.

5.

The Results stored in the DataBase are removed by calling method “removeAllResults”.

6.

If necessary, the components of the Result are expressed in a new coordinate system by calling “modifyRefCoordSys” of “Result” class.

7.

The previous results are erased.

8.

The data are extracted from the Result and pasted into the spreadsheet starting at line 16.

9.

A title line is added at line 15.

At different steps, an Error message is defined. This error message is printed at line 15 of the spreadsheet is an Error occurs during execution. In most cases, this error is related to inconsistencies in the definition of data. Then the error message should help the user to correct his data.

Note that this spreadsheet should work for real as well as complex Results.