Used for Operations scenarios, the Tabular Editor only contains information after a warm-up or scenario run and is positioned to the first time-step in the forecast period. Refer to Forecasting and Operations for details. It provides a spreadsheet-like representation of data that is otherwise presented in graphical form in the Recording Manager. Figure 1 shows an example of historical and forecast data in the Tabular Editor. The row where the cells have a pale blue background is the first day of the forecast period (ie. normally “today”). Rows prior to this show historical data. At this point, all values in the forecast period are zero because no forecasting has been done.
...
Clicking the column title opens the Charting Tool for the node/link’s time series. This is synonymous to right clicking and choosing Time Series Graph from the contextual menu (Figure 1). Choosing Feature Editor opens the node/link’s feature editor that is associated with that column. Note that you can view lagged and storage routing statistics here as well (provided they are recorded when the scenario is run).
Additionally, the contextual menu provides a means of changing the column’s units and access to a formatting editor for the individual column (see Customising the Tabular Editor below).
...
Figure 2. Show Column Editor (Column re-ordered)
Figure 3. Show Column Editor (Add group)
Customising the Tabular Editor
You can customise the Tabular Editor display to your needs. For each type of node or link, you can select:
- A background colour for the cell;
- A foreground colour and stylistic variation (eg. bold-face) for values displayed in the cell; and
- The number of decimal places to be displayed.
...
- To the entire table as a whole - by adjusting a set of user preferences. Refer to Tabular Editor Formatting. Changes made via this method apply to all projects; or
- To individual columns and cells - by right-clicking a column heading and choosing Column Formatting (refer to Customising columns). Changes made via this method only apply to the current project, and will override the Tabular Editor Format settings including templates.
It is also possible to copy and paste single or multiple values across rows and/or columns, including dragging to select multiple cells. Copy and paste are accessed through the right click or with Ctrl C and Ctrl V, respectively.
Customising columns
The Formatting Editor for a column allows you to apply the following conditional formatting to cells in the tabular editor:
- Individual column settings. Here, you can override project-related Tabular Editor Format Settings for the parameters displayed in the Tabular Editor (Figure 4);
- Create a header title (label) and choose the header colour for a column using the Header item (Figure 5); and
- Highlight when thresholds or rules are breached by specifying a function eg. Flow < 500 ML/day (Figure 6).
Figure 4. Column formatting
Figure 5. Column formatting, header
Figure 6. Column formatting, functions
Override Visualization Assistant
The Override function in Tabular Editor allows to change values for the editable parameters in historical and forecast period for an operation model. The override values will then be used to replace the previous cell value (s) in the modelling running, without overwriting the source data of previous cell value (s).
The developed function about Override Visualization Assistant can help the user to find the editable data in an operation model, enter and edit the comments for changed values and generate a summary table for all overridable values. The functions can be though the editable indicator, comment editor and view override command button.
Override editable indicator
The cell with pen icon on the Tabular Editor (Figure 7) indicates the value in that cell can be changed from the Table Editor. The changed values will be used in the model running, and the source data for that cell will not be replaced.
Click on the cell with any pen icon , the user can enter an override value ( e.g. 200 on Figure 7). The new value (e.g., 200 to replace previous 0 sourced from a time series in Data Sources) will be used by the model running.
Figure 7. Override Visualization Assistant
Comment Editor
Comment Editor can be accessed by right clicking on an editable cell with Pen icon and it then will display a menu item (Figure 8). Click on Edit Comment (shown in the orange box on Figure 8) will display a text box for the comment continents. The notice icon will be added to the cell (highlighted by the orange box on Figure 7) if the text box is with any contents (e.g., Demo add 200). Enter key can save the contents in the text box.
Figure 8 The menu for the Comment Editor
Other menu items on Figure 8 are described below:
Cut, Copy and Past are self-explained and can be used to edit the values in the selected cells.
Clear Overrides: it will use the previous cell value from the source data in the model running, and the previous source value will be displayed on the Table Editor after the model running.
Add Additional Cutout Line: by configured color in Scenario options, it can highlight one discontinuous line, which shows the water travel time between the selected cell and relevant columns on Tabular Editor table.
Delete Additional Cutout Line: it will remove the highlighted line (by configured color) from the selected cell on Tabular Editor table.
Lock Cutout line: it can lock the Cutout for deletion.
Override Summary table
Override Summary table can display all override values in the operation model. This function can be accessed also from Tabular Editor using command button View Override (highlighted by green box in Figure 7). Clicking on View Override will display a table ( Figure 9) including all override values such as 200/”Demo: add 200” on 19/04/2021for Dam’s rainfall value and comments respectively, the unchanged value (i.e. zero) for Dam: Unaccounted Difference on 19/04/2021.
Figure 9 Override Summary
