You can maintain or create new time series in this dialog. Various setting options allow many configurations.

Related Links:

▪Persistent origins

▪Create new origin

▪Time series type, time series definition, origins & origin specific parameters

▪Create new origin with "free formula"

▪Calculation formulas and Boolean formulas

▪Delete time series

Features in This Dialog:

Create new time series

▪From the Station and Time Series drop-down list boxes in the Time series header section, select the entries that you want to base the new time series on.

▪If the desired time series definition is not listed in the time series drop-down list box, you have the option of creating the desired time series definition online using main templates.

▪The time series type is automatically taken from the time series specification.

▪A name for the time series is formed from these two entries in the Time series name entry.

▪Then click the [Accept] button.

▪In the Source time series section, select a time series for each item listed from the respective drop-down list box.

▪The time grid of the source time series must be smaller than the time grid of the "target" time series, and also divisible by it.

▪In the Specific parameters section, the yellow highlighted input box for minimum overcoverage (see above) requires a mandatory entry.

▪You decide about entries in the other two input boxes.

▪Finally, confirm your entries with [OK].

▪The new time series is created in the system.

Time series head section

▪From the Station and Time series definition drop-down list boxes select the station and the time series definition that you want to base the new time series on.

▪If the desired time series definition is not listed in the time series definition drop-down list box, you have the option of creating the desired time series definition online using main templates.

▪For time series that are not imported into AquisNet, you can change the time series name.

▪Click with the mouse in the name box and change the entry according to your wish.

▪Then click the [Accept] button.

▪You can now further define the new time series in the two sections below:

Source time series section

▪For each item listed, select a time series from the respective drop-down list box to create the new time series with the selected source time series.

▪Only the time series belonging to the station you selected in the Time series head section are offered.

▪Select the time grid of the source time series so that it is smaller than the time grid of the "target" time series, and also divisible by it.

▪For an origin of the "Free formula" type, the time grids of the source time series and the target time series must be identical.

Specific parameters section

▪Yellow highlighted input boxes require mandatory input. You decide about entries in input fields that are not highlighted with colour.

▪By selecting the time series definition and thus the time series type, the system determines the list of origin-specific parameters.

▪After completing your entries, confirm them with [OK].

▪The new time series is now created in the system.

Create new time series with free formula

This tool gives you the possibility to specify formulas that serve as the creation rule (origin) of a time series from up to ten other time series.

▪Select the desired station in the Station drop-down list box.

▪From the Time series definition drop-down list box, enter an entry of the Free formula (type) type.

▪If the desired time series definition does not yet exist, you can design a new time series definition online using main templates according to your wish to define a formula later.

▪In the Time series name dialog you can now select a suitable name.

▪Click the [Accept] button.

▪Select a time series for each of the up to ten items listed from the respective drop-down list box to form the new time series with the selected source time series.

▪Now enter a formula in the "Specific parameters" section:

▪Start by entering the expression "expr" for a calculation formula or the expression "if" for a Boolean formula.

▪Now insert – separated by a space – the calculation rule behind it with which the target value of the new time series is to be calculated from the individual values of the selected source time series.

▪Note the format of the formula entries: The expression "$x" (with x for "a" to "i" ) represents the value of a time series at a time stamp. This value is calculated against the other value(s) of one or more other time series with the same time stamp according to the calculation rule.

▪The notation types for calculation formulas, as well as for Boolean formulas, can be found in the Calculation formulas and Boolean formulas section

▪Now confirm your entries with [OK].

▪The newly calculated time series is created in the system and is ready for use.

Calculation formulas

Formulas are formed according to the known rules with constants, functions, operators and brackets, whereby the usual object hierarchy – potentiation before multiplication/division before addition/subtraction – applies. When entering constants, please pay attention that the system distinguishes float and integer constants. Thus, the expression 1/2 as division of two int values (integer division) yields the result 0.0, while 1.0/2.0 as division of two float values yields the result 0.5. If the data type of an argument is not correct, a type conversion from float to int or vice versa is automatically carried out. The conversion from float to int is done by separating the decimal places.

▪Standard operators

▪Addition: float1+float2

▪Subtraction: float1-float2

▪Multiplication: float1* float2

▪Division: float1/float2

▪Division for integer values with integer result: int1 div int2

▪Potentiation: float1^float2

▪Comparison operators, result is of type int (0 or 1): float1 <, <=, =, >, >= float2

▪Standard functions

▪Absolute value of the argument: float abs(float)

▪Sign of the argument: float sign(float) (-1, 0 or 1, if arg < 0, == 0 or > 0, respectively)

▪Sine of the argument (in radiant): float sin(float)

▪Cosine of the argument (in radian): float cos(float)

▪Tangent of the argument (in radian): float tan(float)

▪Arc tangent of the argument (in radian): float arctan(float)

▪Power with Euler's constant e as the base and the argument as the exponent: float exp(float)

▪Decadic logarithm of the argument: float log(float)

▪Natural logarithm of the argument: float ln(float)

▪Square root of the argument: float sqrt(float)

▪Integer part of the argument: float int(float)

▪Decimal part of the argument: float frac(float)

▪Pseudo-random number between 0 and 1: float rnd()

▪Default constants

▪pi: approximation to the circular number

▪e: Approximation to Euler's constant e

Boolean formulas

Boolean formulas allow you to specify conditions that control the calculation of a formula, for example, calculating a target time series depending on the key curve of a source time series above a certain value.

Example:

The expression “if { $a<99 } { expr $a+$b } else { expr $a-$b }” means:

Only if the value ($a) at a time stamp of the 1st source time series is smaller than 99 g/cm³, an addition with the corresponding value ($b) of the 2nd source time series takes place. If this is not the case, a subtraction of ( $a-$b) takes place.

The following standard operators and standard functions represent the most important notation types:

▪Standard operators

▪binary AND operator, result is of type int: int1 AND int2

▪binary OR operator, result is of type int: int1 OR int 2

▪binary negation, result is of type int: NOT int

▪Standard functions

▪<float1> if <intBool>!=0

▪<float2> if <intBool>==0

▪float if(intBool, float1, float2)