Set module = ("PostProcessing.OrcaFlexSpreadsheet").Object Sometimes it is convenient to be able to invoke the post-processing actions from VBA. Errors are always ignored until processing completes and the number of threads used is controlled by OrcaFlex. When a spreadsheet is processed in an OrcaFlex batch all the option settings are ignored apart from "contains dependencies". It is only available if contains dependencies is not checked.
By default the spreadsheet will utilise all the available processing cores. The thread count can be set to reduce the impact processing spreadsheets will have on the responsiveness of your computer. If ignore errors is checked then all error messages are collated while the spreadsheet continues to process instructions. If this box is checked, then you can choose to either allow errors to be reported during the processing or to ignore errors until the sheet is completed. If this box is not checked, then the order in which instructions are processed is not defined and multiple rows may be processed simultaneously by multiple threads. one of the cells in the row is a reference to the output of an earlier instruction, then the contains dependencies box must be checked to ensure that the whole sheet is processed row by row from top to bottom using a single thread. If an instruction depends upon the result of a previous instruction, i.e. Click on this to bring up the available options.
The processing options ribbon button allows you to change the way an instructions sheet is processed. The process selected instructions command tells the spreadsheet to process only the instructions in the currently selected cell or block of cells. If the currently selected sheet is not an instructions sheet and the workbook contains more than one instructions sheet, then you will be asked to select which instructions sheet you wish to process. The process all instructions command runs all the instructions in the table. If you are using a pre-2007 version of Excel, you should interpret any reference here to the OrcaFlex ribbon as being to the OrcaFlex menu, and ribbon buttons as instead referring to the corresponding menu item. The OrcaFlex menu in Excel versions prior to 2007 This menu contains the same commands as the ribbon does in later versions: In versions of Excel earlier than 2007, an OrcaFlex menu is added to the Excel menu bar. In an OrcaFlex spreadsheet, OrcaFlex integrates with the Excel ribbon as shown here: Warning:ĭo not change rows 3 and 4 of an instructions table, since these are used to identify it as such. This can be useful when developing and building the table. Instructions in hidden rows in the instructions table are not applied, allowing you to effectively disable certain instructions. Also, the spreadsheet assumes that the first instruction is row 5 of the worksheet, so do not insert or delete rows above this.Īny formatting is ignored, so you can use bold, italic, colour etc. In particular, you cannot have a blank row in the middle of the instruction table. Hence you cannot have an instruction row that has no label and no command. The end of the table is indicated by the first row that has blank label cell, label and command columns. That is, you can have an instruction that has a blank command cell and so only writes a label, or one that has a blank label cell and so only writes results. You may complete, independently for each row, one or both of sections 2 and 3.
These columns can specify output of time histories, range graphs, data values etc. The other columns (D to I) specify some results or data which are output on the sheet specified in column A and in the cell specified in column D.The text of the label is specified in column C. This label is output on the worksheet specified in column A and in the cell specified in column B. The entries in columns B and C (titled label cell and label respectively) specify a label.The entry in column A (titled sheet name) specifies the name of the Excel worksheet on which any output is produced.The instruction can be thought of as 3 separate sections: Instructions tableĮach row in the instructions table is a separate instruction. These tools are the instructions wizard and the duplicate instructions form. The spreadsheet also provides tools to help build the list of instructions.
OrcaFlex spreadsheets also provide facilities for automating the production of batch script files and text data files.įor results post-processing, an OrcaFlex spreadsheet contains one or more instructions worksheets, plus other worksheets to receive the OrcaFlex results and for any derived results. The OrcaFlex spreadsheet enables you to automate the extraction of results and data from OrcaFlex files into Excel.