Skip to content

Time series Calculator Wizard

The Time series calculator wizard was released with MIKE OPERATIONS 2025.1. It allows constructing formulas for the time series calculator tool.

The Time series calculator wizard can be found in the Data ribbon page.

Selecting the Time series calculator wizard will open a new docking windows with the wizard.

This allows working on more screens when creating time series using the Time series calculator wizard.

Time series

The time series list contains the time series selected before opening the wizard (tool input items).

MIKE OPERATIONS 2025.2

Time series in sub-folders are also loaded.

Double clicking on a Time series will add it in the formula.

MIKE OPERATIONS 2025.2

With the right click menu, time series can be deleted and added as placeholder (see Formula).

Formula

The formula in the Time series calculator is using Excel formula syntax.

The Formula field can be edited manually as well as adding functions, operators and time series from the lists by double clicking the function, time series or operator.

Please refer to Excel documentation for additional documentation on constructing formulas and to Excel functions for documentation of functions supported.

In the formula, time series are refered to using square brackets (e.g. [timeseries1]). The name should match the time series name found in the time series (mapping) list. When using such saved formula, the wizzard expects a time series with a similar name to be listed. [*] can be used as a placeholder for the first time series in the list. Using the placeholder means that the formula can be used for any selection of time series.

MIKE OPERATIONS 2025.2

Saved formulas can be easily applied on any time series, regardless of their name, extending the [*] option. When adding a time series as placeholder, the format changes to: [*{Number}:{TimeseriesName}], where:
- {Number} is the ranking in the list
- {TimeseriesName} the text written after ':' is only for the user to document what this refers too. This free text should be 15 character long maximum and should not include space or special characters.
For example [*1:WaterDepth]" means that the formula should take the first timeseries in the list.

In the example below, the wizzard will consider that the second time series (i.e., TS3) is the Speed and the first time series (i.e., TS2) is the WaterDepth.

Operators and constant

The Operators list shows the available operators.

Refer to the Excel calculation operators documentation for more information.

MIKE OPERATIONS 2025.2

The category was renamed "Operators and constant" and a Delete value constant was introduced.

Function

Category

MIKE OPERATIONS supports most Excel functions.

Available functions are grouped by category.

The following categories are available (the link points to the online help documentation of Excel of the function category).

List

The functions list shows the functions of the category selected.

Double click a function to insert the function with function arguments in the formula field.

When selecting a function (single click), the function description and function arguments are shown in the box above the formula.

Function paramerets in square brackets are optional parameters. E.g. INDEX(array, row_num, [column_num])

Filter

Time series values (time steps) of time series in the formula can be filtered, so that only some time steps are included in the calculation.

Click the Filter... button to show the Filter dialog.

  • From date Specify the data and time from where time steps should be taken.
  • To date Specify the data and time to where time steps should be taken.
  • Min value Only time steps with a value greater than or equal the minimum value will be included. 0 means that Min value will not be considered.
  • Max value Only time steps with a value less than or equal the maximum value will be included. 0 means that Max value will not be considered.
  • Ignore empty values When checked, only time steps with a value will be included in the calculation.

Formula

Formula can be saved in the database and reused later with the same or differnet time series.

Save

Clicking save will open a form where the formula name should be specified. After clicking OK, the formula and filter will be saved.

Access

Saved tool settings can be seen of the Time series calculator tool.

Load

Once saved, the formula can be reloaded in the Time Series Calculator Wizzard.

Run

The run button will run the Timeseries calculator tool and show the results in a data view.

To list

Run the Timeseries calculator tool using the To list tool, displaying the result in a list.

To chart

Run the Timeseries calculator tool using the To chart tool, displaying the result in a chart.

To time series table

Run the Timeseries calculator tool using the To time series table tool, displaying the result in a table.

Save to database

MIKE OPERATIONS 2025.2

Run the Timeseries calculator tool using the Save to database tool, to save time series into the database. A window will pop up to specify the path.

Run options

Use filter

MIKE OPERATIONS 2025.2

Selecting Use filter will apply the filter defined.

Keep spreadsheet

MIKE OPERATIONS 2025.2

Selecting Keep spreadsheet will create a spreadsheet in the Spreadsheet Manager where the last timestep calculation is visible. The cell A1 shows the input time series value and the cell B1 the corresponding calculation. This is usefull to debug and understand what is the tool calculating behind the scene.