Page History

3.7 Time step definition

Manual HYMOS Import Wizard^image029.jpg! Image Added

In this form you specify which column in the file(s) is the Date column or the Date and time column . Also the correct format for this column must be specified: use a 'd' to indicate days with one or two numbers (e.g. 2 and 21), 'dd' for days with two numbers (e.g. 02 and 21), m for months with one or two numbers (e.g. 1 and 11) and 'mm' for months using two numbers (e.g. 01 and 11).

The Time column number may be left blank (or zero) if there is no separate column for the time (or the time is in the same column as the date). When you alter the column number, the corresponding column in the example file will be coloured light green.

The 'Equidistant timesteps' checkbox and the Time step mapping inputs will determine what series the import will create.
The Timebase and divider are similar to what is used in HYMOS. The three options for interpolation define how the data will be interpreted when the time stamps in the import file are to be translated to equidistant time steps. The options: 1.

1. Step : if the time stamp in the impor data is not within one second after the time as defined in the equidistant step, the value on the previous time step before this is used.

...

1. Linear interpolation : linear interpolation is used to compute the value on each time step.

...

1. Window : before and after the equidistant timestep a search window is kept. If no value is available in this window, the equidistant timestep gets the value "missing". If more timestamps are found in this window, the value store is the average (arithmetic mean) of the values on these time stamps.

An example of the time step methods is shown in Table 7and 7 and Table 8.

Table 7: Original series in import file Anchor_Ref160000002_Ref160000002

Table 8: Hourly series saved to database for diferent interpolation options and import file in Table 7.
Anchor_Ref160000004_Ref160000004

...