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.
...
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.
...
- 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
...
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.
...
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
Clear Historical Overrides: this command button will clear overrides values in whole historical period and will only display overrides values in the forecast period (from “tomorrow “ only). This action is not reversed.