3.8 Value column and unit conversion

The column number containing the actual values must be specified here. If there is a separate column containing a quality indicator, it may be specified. If the quality indicator is part of the values column, the value for the quality column may be left blank or zero. When you alter the column number, the corresponding column in the example file will be coloured light green.

The value column can be left empty or 0 if the station translation or the parameter translation indicated a specific value column already.

If conversion of values is needed, for instance if the data is given in inches and has to be stored in HYMOS in centimetres, this screen gives you the possibility to define the conversion formulae. Use the number sign # to denote the value as read from the data, Y is the value stored in HYMOS. Conversion is limited to a single operation , without parenthesis, which may be addition of a fixed number, subtraction of a fixed number, multiplication with a fixed number or division by a fixed number. For each parameter separate conversions may be specified.

Table 9: Examples of valid and invalid conversionsof values.

valid

invalid

1.2 + #

2 * # + 11

  1. + 1.2

(# + 3) * 2

  1. / 100.0

(# + 3)

3 / #

100 - 2 * #

  1. - 25

100 + # + 50

2.54*#

12 \ #


Example file

In our example file each column that needs to be read is already interpreted, because it is assigned to a certain parameter. Hence, no value column is assigned. Also, no conversion is made.

  • No labels