Data processing

Options for interpolating data processing

For the data import there exist three different options for interpolation of the data processing, including the normal interpolation, the arbitrary interpolation and the Change-of-Value-Interpolation:

Option 1: Normal Interpolation

14Data_Data Processing

a. Interpolation of both values to max. one time step forward and backward
b. Shifting of the next value to max. one time step forward and backward
c. No import-value

Only the data closely to the target time points t will be processed. If there is no value, that lies chronologically close-by, no value for the target time point will be indicated. If no value for the interpolation is defined, the workspace standard-quantization is used for the interpolation (e.g. minute, quarter of an hour, day).

14Data_Data Processing3

This option displays the standard setting.

Option 2: Discretionary Interpolation

14Data_Data Processing1

An arbitrary time frame* in minutes can be chosen, to look out for values in both directions. The interpolation takes place between the closest values based on the weighted mean.

*until 366 days. The input occurs in minutes, so max. 527.040 minutes.

14Data_Data Processing3

To choose this option, the requested time frame should be inserted next to “Interpolation:”

Option 3: Change-of-Value

14Data_Data Processing2

For a target time point, the last valid data point will be interpolated. The data set ends with the last change in value and includes the last value.

14Data_Data Processing3

For the third option, activate the Change of Value settings by placing a checkmark to COV-Modus.

Supported Aliases

Besides the import of numeric values the import of  datapoints its values contain strings (for example: “on”, “off”) is supported. During the import of those strings they get transformed into boolean datapoints (true/false) so that they can be further refined in the digital testbench. The following strings are supported at the moment:

strings (true aliases) strings (false aliases)
active abwesend
aktiv aus
an ausgeschaltet
auf close
betrieb closed
comfort economy
ein falsch
eingeschaltet geschlossen
geöffnet inactive
ja inaktiv
on nein
open no
opened off
precomfort zu