The Tabular Editor is used for River 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 1. Tabular Editor
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).
...
- The travel-time indicator is only calculated for the last cell that was clicked; and
- The selection statistics are updated to show the sum and mean for all cells in the selection.
- Export saves the current configuration to an .xml file, Import loads a configuration from an .xml file
The Show Column Editor button expands the window to include an hierarchical list of data sources that are candidates for inclusion in the Tabular Editor. Click Hide Column Editor to return to the original view.
...
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 Settings. 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.
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).