The spreadsheet “WorstResExtract” 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, one can select a criterion among a small predefined selection, and an integer number between 1 and 100 corresponding to the number of values that shall be extracted.
When the “Extract” button is clicked, the following operations are performed:
First, the same steps 1 to 5 as in section VII.3.4 are performed. The extracted Result is stored in “res” variable.
The selected criterion is calculated by calling among the methods “deriveScalToScal”, “deriveVectorToScal” and “deriveTensorToScal” the of “Result” class the one that is appropriate. A “tmpRes” Result is created.
One extracts the nbrVals largest values of this “tmpRes” Result by calling “extractResultForNbrVals” method.
Correspondingly, one also extracts the critical values of “res” Result using “extractResultOnResultKeys” method.
Finally, the data are printed in spreadsheet cells with appropriate title lines.
Instead of simply extracting FeResPost pre-defined scalar derived criteria, it should not be very difficult calculated more specific criteria by modifying the spreadsheet and associated VBA code. For example, you can try to modify the spreadsheet and calculate minimum reserve factors instead of maximum Von Mises stress.
The spreadsheet works with real Results only.