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 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 to 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.
There are two ways to apply formatting:
- By To the entire table as a whole - by adjusting a set of user preferences. See Refer to Tabular Editor Formatting. Changes made via this method apply to all projects; or
- By 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.
Customising columns
The Formatting Editor for a column can be used to edit the display of the columns.In this window, the Multiple Expressions tab (as shown in Figure 1) allows column allows you to apply the following conditional formatting to cells in the tabular editor to highlight when thresholds or rules are breached eg. Flow < 500 ML/day. More than one expression can be applied to a cell. Click Add to specify the details of an expression, and Edit to define the expression using the Function editor. When more than one condition is satisfied, the cell is formatted as per the left side of the panel. Hover the mouse over the cell with the conditional format, and the expression name is displayed. Click Remove to delete an expression from the list.
Figure 1. Tabular editor, Formatting, multiple expressions
The Column Settings tab allows you to override :
- Individual column settings. Here, you can override project-related Tabular Editor Format Settings for the parameters displayed in the Tabular Editor
...
Figure 2. Tabular editor, Formatting, column settings
...
- (Figure 4);
- Create a header title (label) and choose the header colour for
...
Figure 3. Tabular editor, Formatting, header settings
- 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).