Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Edit through the REST API

The Tabular Editor is used for River Operations scenarios, the Tabular Editor only contains information after a warm-up or scenario run (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)

Image Modified

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.

...

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

Image Modified

Figure 5. Column formatting, header

Image Modified

Figure 6.  Column formatting, functions

Image Modified