Versions Compared

Key

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

This function is not available in Source (public version).

...

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.

...

  • 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.

...

  • 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

Override Visualization Assistant

...

Figure 8. Override values in Data Source

Image RemovedImage Added

Image RemovedImage Added


For instance, time series data assigned to the flow of an inflow node can have missing values that the user can replace them in with new values in the operation Tabular Editor. However, if the time series of this node is used in multiple places in the model, the user can override the missing values through the time series “Data Source” in the Tabular Editor. This way the new values are propagated to all the usage of that Data Source in the model.

...

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.

...

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.

Minimum Flow Requirement nodes in Tabular Editor

Minimum Flow Requirement (MFR) nodes can now be accessed from the Tabular Editor and can be overridden. The recorder of Required Flow Arriving Current Timestep on MFR nodes was added to handle the complex concepts of the water flow due to the travel times.  Required Flow Arriving Current Timestep recorder needs to be added to Tabular Editor as one column for Override if required (Figure 11). The user should override any cells in this column using the required flow that will arrive at the MFR node in the current time step considering the travel time. Another column/recorder of Required Flow is not editable in Tabular Editor and this Required Flow column reflects the default Required Flow, Forecast Required Flow and Overridden Required Flow at a source site (e.g., storage). The travel time in Figure 11 is three days and “today” in the operation model is 10/01/2000.

Figure 11. Override for Minimum Flow Requirement in Tabular Editor

Image Added