...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| 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.
...
- 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
...
Lock Cutout line: it can lock the Cutout for deletion.
Override Summary table
...
, including exporting and inputting override records
The Overrides Summary table can display manage all override values in the operation model. This function Its user interface can be accessed also from the Tabular Editor using the command button View Override Overrides (highlighted by the green box in Figure 7). Clicking on View Override Overrides will display a table the Overrides Summary editor (Figure 10) including with all existing 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 .
The Overrides Summary editor displays six columns: Recorder Name, Override Date, Override Value, Units, Null Value, and Override Comment. Only the Override Value and Override Comment are editable from the Interface. The Editor interface has six command buttons to manage the override values: `
- Output: This command button allows for exporting all override records into a specified CSV file, which consists of the columns Recorder Name, Override Date, Override Value, Units, Null Value, Override Comment, and Recorder Key. Recorder Key collum is the unique ID.
- Input: The button allows for importing overrides from a specified CSV file to the Overrides Summary table. The inputted overridden data will only exist in the Overrides Summary table if “Apply” is not hit.
- Clear All Overrides: This button allows you to clear all override values in the Override Summary table, then in the Tabular Editor after Apply button is hit. This action is not reversed.
- Clear Historical Overrides: This button will clear override values in the whole historical period and will only display
...
- override values in the forecast period (from “tomorrow
...
- “only). The action is from values in the Override Summary table, then in the Tabular Editor after Apply button is hit. This action is not reversed
- Apply: The button can save the changes in the Overrides Summary table to the whole Tabular Editor (including changes made by Input/Clear ALL/Historic Overrides buttons and manually from the interface).
- Clear: The button can discard all changes made by Input/Clear ALL/Historic Overrides buttons or manually from the interface in the current Overrides Summary table.
Note that:
- Although the user can edit all contents of export/input CSV files outside of the Source, the user should only edit Override Value and Override Comment and never touch the Recorder Key.
- While importing, if the CSV contains multiple duplicate Recorder Key + Override Date + Override Value/Override Comment rows, that latest row will be considered for overriding.
- Errors occurring during the import/export will be displayed in the error bar at the top, as well as logged to the log reporter if required.
- If the user wants to edit the value of the unit in the CSV file, the user also needs to manually change the relevant Override Value. The input functionality does not automatically convert the relevant Override value between the old unit and the updated unit.
Figure 10. Override Summary
Minimum Flow Requirement nodes in Tabular Editor
...