Post-processing: Basic commands

Load <file name>

This command tells the spreadsheet to open the specified file. Subsequent results extraction commands then apply to that file.

You can either give the full path of the file, for example

Load c:\Project100\Case1.sim

or use a relative path (relative to the directory containing the spreadsheet). The latter is often more convenient. For example if the file Case1.sim is in the same directory as the spreadsheet then you can use the command

Load Case1.sim

and this has the advantage that there is no need to alter the spreadsheet if the directory is renamed or the files are collectively moved.

If you specify a data file (.dat or .yml) then the file is loaded and the OrcaFlex statics calculation is performed. Subsequent results extraction gives results for the static configuration.

Simulation files (.sim) containing either static state results or dynamic simulation results can be loaded.

OrcFxAPI version

This outputs the version of the OrcFxAPI DLL which is being used by the spreadsheet. This is not necessarily the version of the program which performed the calculations (for example if you load a simulation file which was generated by a different version of OrcaFlex).

Working directory

Outputs the directory where the spreadsheet is stored. If you are using relative paths then it can be useful to keep track of the base path for QA purposes.

Warnings

Outputs the text from any warnings reported during the OrcaFlex calculations (static or dynamic). Simulations run in batch mode or by Distributed OrcaFlex do not display such warnings since to do so would require user intervention. This command allows you to check whether any such warnings were generated.

This command is the equivalent of the Calculation | View warnings menu item in OrcaFlex.

Clear

Clears the contents of cells in the specified output sheet. All cell formatting is preserved.

This should generally be the first command in the instructions sheet or the first command following a Load command, depending on whether the results are being output to a single or multiple sheets. Results extraction spreadsheets are typically run repeatedly. The purpose of this command is to ensure that previously extracted results are removed and so cannot get mixed up with the latest results.

If the additional data column is empty then the entire sheet is cleared. If the additional data column is not empty, then its value is taken to mean a range of cells to be cleared. The range is specified using Excel's A1 reference style. The following table illustrates some typical A1-style references:

Duplicate sheet

Copies the entire contents of the worksheet named in the additional data column to the specified output sheet. All charts, formulae, formatting etc. in the source worksheet are copied.