| Info | ||
|---|---|---|
| ||
This function is not available in Source (public version). |
...
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).
...
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
The Override function in Tabular Editor allows to change values for the editable parameters in historical and forecast period for an operation model. The override values will then be used to replace the previous cell value (s) in the modelling running, without overwriting the source data of previous cell value (s).
...
Lock Cutout line: it can lock the Cutout for deletion.
Override Summary table, including exporting and inputting override records
The Overrides Summary table can manage all override values in the operation model. Its user interface can be accessed from the Tabular Editor using the command button Overrides (highlighted by the green box in Figure 7). Clicking on Overrides will display the Overrides Summary editor (Figure 10) with all existing override values.
...
Figure 10. Override Summary
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
Function Overridden in Tabular Editor
Now, the overridden functionality works for the Source function in Tabular Editor. This functionality is implemented for normal Source functions and not for custom functions (e.g. the functions from the MDBA plugin). The user can override the result of a function at one or more timesteps, and the override(s) will apply at the same Time of Evaluation as that function’s Time of Evaluation (EOT). This also applies to other functions that are referencing an original overridden function, and those functions will cite the overridden value(s) of the original function at the same EOT if their EOT is the same as that in the original function or after within the timestep.
The steps to set the function for overrides are below:
- Open Tabular Editor and Run a scenario (left screen capture in Figure 12).
- Open Tabular Editor Column Editor (right screen capture in Figure 12) by clicking on the Edit button (green highlighted on left screen).
- Add function(s) to Tabular Editor table for overridden (from right screen capture in Figure 12):
-Click on Functions (1) (top-left panel) to select the type and show it to (2), and click on Functions (2) to show all functions in the model to the top-right panel.
-Tick the functions, which you want to override such as (3 in Figure 12) $f_t_07_a and $f_t_07_b that is $f_t_07_a +10, in the top-right panel.
-Click on the Add Selected button (4 in Figure 12) to add the selected functions to the bottom panel (5 in Figure 12) and remove them from the top-right panel.
-Click on the OK button to close the interface and return the Tabular Editor table.
- Run a scenario to display the original values of selected functions (left screen capture in Figure 12).
- Override the result/values of the functions (e.g. set 1,2,3 for $f_t_07_a from 10/06/2020 to 12/06/2020 respectively and 4,5,6 for $f_t_07_b from 16/06/2020 to 18/06/2020 respectively).
- Run the scenario.
- Function values were changed in Tabular Editor (left screen capture in Figure 12). The function values of $f_t_07_a from 10/06/2020 to 12/06/2020 were changed to 1,2 and 3 (yellow highlighted in left screen) and $f_t_07_b values in the same period were also changed to 11,12 and 13 (orange highlighted in left screen as $f_t_07_b =$f_t_07_a +10) while $f_t_07_b values from 16/06/2020 to 18/06/2020 were changed 4,5,6 respectively (orange highlighted in left screen) and the function values of $f_t_07_a in the same period are not affected.
Figure 12. Override for Functions in Tabular Editor
