The “WorstResExtract” spreadsheet is very similar to “ResExtract”. It is used to illustrate the possibility of writing small post-processing spreadsheets.
In this case, no coordinate system can be specified. Instead, the user can select a criterion from a small predefined list, and an integer between 1 and 100 corresponding to the number of values to be extracted.
When the “Extract” button is clicked, the following operations are performed:
First, the same steps 1 to 5 as in section VII.4.4 are performed. The extracted result is stored in the “res” variable.
The selected criterion is calculated by calling whichever of the “Result” class methods “deriveScalToScal”, “deriveVectorToScal” and “deriveTensorToScal” is appropriate. A “tmpRes” result is created.
The nbrVals largest values of this “tmpRes” result are extracted by calling the “extractResultForNbrVals” method.
Correspondingly, the critical values of the “res” result are also extracted using the “extractResultOnResultKeys” method.
Finally, the data are printed in spreadsheet cells with appropriate title lines.
Instead of simply extracting FeResPost’s predefined scalar derived criteria, it should not be very difficult to calculate more specific criteria by modifying the spreadsheet and the associated VBA code. For example, you can try modifying the spreadsheet to calculate minimum reserve factors instead of maximum Von Mises stress.
This spreadsheet works with real results only.