| Info | ||
|---|---|---|
| ||
This function is not available in Source (public version). |
...
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. 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
Figure 5. Column formatting, header
Figure 6. Column formatting, functions
Override Visualization Assistant
...
Click on the cell with any pen icon, the user can enter an override value ( e.g. 965. 200 35 on Figure 7). The new value (e.g., 200 965.35 to replace previous 0 sourced from a time series in Data Sources) will be used by the model running.
...
Figure 7. Override Visualization Assistant
Override Values in Data Source
The Override function can also be used to fill in missing values of the time series being fed into the model. In Source 5.20, “Data Source” is available in the Tabular Editor to do so (Figure 8).
Figure 8. Override values in Data Source
|
|
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.
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 89). Click on Edit Comment (shown in the orange box on Figure 89) 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.
Figure
...
9. The menu for the Comment Editor
Other menu items on Figure 8 9 are described below:
Cut, Copy and Past are self-explained and can be used to edit the values in the selected cells.
...
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.
...
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 910) 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
...
10. 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.