Misc. Configuration

Spreadsheets

MIKE Workbench contains a spreadsheet manager for making and maintaining spreadsheets. These spreadsheets can be configured to be shown when clicking on a ribbon item in the ribbon of MIKE OPERATIONS.

Create and configure spreadsheet ribbon items from the General Settings page by clicking on the ‘Spreadsheets’ button.

The dialog will display the spreadsheets configured.

Click on the ‘New’ button to add a new spreadsheet configuration.

Click on the ‘Details’ button to configure the spreadsheet.

Item	Description
Active Activate the spreadsheet by checking this field.
Id Id of the spreadsheet. The id is used as a reference.
Name Name of the spreadsheet ribbon item, shown in the ribbon
Description Description of the spreadsheet.
Script Name Name of the spreadsheet in MIKE Workbench to display when clicking on the ribbon item.
Enable Change Log Enables change log for the spreadsheet when saving the spreadsheet.
Ribbon Page Name The name of the ribbon page where the button of the spreadsheet is shown.
Group Name Group name sets the group of the script in the ribbon.
Ribbon Item Type Ribbon item type controls the type of control added to the ribbon. Check Item A simple check item Gallery Check Item A check item added to a gallery of items. Menu Check Item A menu item added to a menu. The path of the menu is specified in the Group name field, separating each sub menu entry with a vertical bar ‘|’. E.g. “My Group|Menu button name|First parent menu|Second parent menu”. Images of each menu item can be specified by adding Feature Types for each sub menu. Item (default) A simple item like ‘Check Item’ without ‘check mark’ functionality. Menu item A menu item like ’Menu Check Item’ without ‘check mark’ functionality. Hidden (Always on) The script is not shown in the ribbon.
Resource Image Name Resource images are a list of built in images for spreadsheets. Clicking on the dropdown will display the available images. The selected image will be used where the feature type is displayed, E.g. in the ribbon, in tooltips and the Table View. Images with a ‘_32’ postfix have an initial size of 32x32 pixels. Images without a postfix have a size of 16x16 pixels. The initial size has an impact on the quality of the image when displayed in MIKE OPERATIONS.
Document Image Path Document Image Path is for additional user images placed in the Document Manager in MIKE Workbench. Images specified in this path will overwrite the image specified in the Resource Image Path.

Messages

Messages holds a library of messages to be used by alerts. Messages can contain language translations.

Item	Description
Name The name of the messages used for placeholders in alert messages.
Text The message text.
Translations Click on the translation button to create messages in other languages.

Languages

Create languages so that messages can be translated into other languages.

Each contact will have a language specified, so that alert messages generated will be in the language specified.

Notifications

The notifications dialog shows generated notifications on contacts.

Refer to the “Alert Message Setup” and the “Contacts” sections on how to setup alert messages.

In order to configure automatic notification message generation, a job must be scheduled to run.

The job must contain a “Run script” task, calling a script making the notifications.

The following script sample shows how a script generating notifications could look.

The notifications generated are written into a spreadsheet, one line per notification. By default, notifications are written into the “Notifications” spreadsheet found in the Real Time Configurations folder in MIKE Workbench.

A method for generating notifications in user defined spreadsheets is available. Please refer to the API documentation.

R Statistics Support

R is a language and environment for statistical computing and graphics. It is a GNU project which is similar to the S language and environment which was developed at Bell Laboratories (formerly AT&T, now Lucent Technologies) by John Chambers and colleagues. R can be considered as a different implementation of S. There are some important differences, but much code written for S runs unaltered under R.

R provides a wide variety of statistical (linear and nonlinear modelling, classical statistical tests, time-series analysis, classification, clustering, etc.) and graphical techniques, and is highly extensible. The S language is often the vehicle of choice for research in statistical methodology, and R provides an Open Source route to participation in that activity.

R is available as Free Software under the terms of the Free Software Foundation's GNU General Public License in source code form. It compiles and runs on a wide variety of UNIX platforms and similar systems (including FreeBSD and Linux), Windows and MacOS.

In MIKE OPERATIONS, R for Windows is supported from MIKE Workbench by introducing a tool, taking R scripts as arguments. Please refer to the MIKE Workbench Help file for information about the R tools.

Configuration

Note that the R tools described in this chapter is supported using R libraries before R version 3.5.

In MIKE OPERATIONS, R-Statistics tools is supported through configuration of stations. This is done by introducing a number of new time series types (object types).

• Skill Scores

• Confidence Intervals

• Goodness of Fit

When adding a new statistics time series (object), additional information must be specified on the time series.

This is done in the details view of the time series on the Statistics Tab.

Item	Description
Statistics Results For Skill Scores and Goodness of Fit calculations, analysis results are saved in spreadsheets in MIKE Workbench. Specify the Results Spreadsheet by clicking on the ellipsis button.
Error model For Confidence Intervals, the results of the analysis are saved as error models in the document manager in MIKE Workbench. Select the error model from the Error model dropdown box.
Measure Selection For each statistics type, a list of available measures can be selected. Select the measures to be displayed for each station from the check box list.
Reference Time Series Specify the reference time series used as base for the statistics.
Historical Simulation Path Path to a simulation used for calculation of Last Error. Last error can be taken into account when creating confidence intervals. Last error is calculated as the last observed value on a specified date and time as a historical simulation result (obs. value – sim. value). When calculating the Last error, the observation time series is the first time series definition of the feature type of the type “Time series”.
Max. Search Window The maximum search window used when finding the “last error” when creating confidence intervals. The maximum search windows is specified as a time span back from Time of Forecast (period before ToF). The time span is specified as days, hours, minutes and seconds (dd:hh:mm:ss).

When the configuration has been completed, the results can be displayed when clicking on a station in the map or in the table view of MIKE OPERATIONS.

Quality verification of data collection spreadsheet

Skill scores and goodness-of-fit measures and the error models are sensitive to the quality of observations as they are regarded as the true value of what is modelled. Error in collected observations are therefore reflected in the statistics and can render the results useless. In the example below, a scatterplot of collected simulated and observed discharge pairs at 10 hours forecast lead-time is shown. Missing observation values have the default value of -999 and several observations are seen to have negative values.

If we look at the Nash-Sutcliffe index for the above dataset, as seen on the right figure below, it does not give us much information about the forecast quality as it changes with lead-time. To the left, all values below zero have been removed and the decay in forecast skill is visible from the dataset.

If the error model is trained on bad data, the observation errors are present in the calculated confidence bands. This is clear from the two plots below where the top plot includes the complete dataset and the bottom show the model trained on the dataset where negative observations has been removed.

Proper quality verification of the observed data is therefore very important when used in the statistical applications.

Performance

MIKE OPERATIONS loads time series, layers and thresholds of the current configuration into memory at startup to give a better user experience.

Loading and threshold calculation is also done when:

• Changing the Observation Period Setup

• Changing between Data & Maps and Scenario mode

• Changing the current configuration

• Saving the current configuration

• Changing Unit Sets

When ‘playing’ a time frame of the configuration, data is taken from memory.

The following parameters will have an impact on performance when loading, ’playing’ and selecting.

• Feature layer size
  The size of multiline and polygon feature layers will have an impact of on the maps performance when redrawing.

• Time Varying Raster layer size
  The size of time varying raster layers will have an impact of on the maps performance when redrawing.

• Observation Period Length
  The length of the observation period, and hereby also the number of time steps taken into consideration will have an impact on performance when calculation current thresholds.

• Threshold Time Step Length
  Short threshold time steps affect performance.

• Number of feature classes
  The number of feature classes visible on the map impacts performance.

• Views
  Visible Views (e.g. Chart View, Time Series View, and Document View) are redrawn every time the current time is changed or when a feature is selected.