The Data Format (IMPORTANT)


Test me!
Download an example data file for test purposes.

The data format is quite simple, but is the key to a successful processing. In the testing 99% of errors were related to this issue. The data should be provided as column-oriented ASCII file, e.g. TAB-delimited, as you can simply achieve by saving in EXCEL as text, TAB delimited.
For testing, you can download this file. The file contains Tharandt 1998 data from the CARBODATA CD. Then go to the Upload page and specify the Data File Location, the Year='1998', the Time Format: 'Julian Day, hour (decimal)', Delimiter='<TAB>', Latitude=51.0.

Please refer to the following minimum template.

Day
Hour
qcNEE
NEE
LE
H
Rg
Tair
Tsoil
rH
VPD
Ustar
--
--
--
umolm-2s-1
Wm-2
Wm-2
Wm-2
degC
degC
%
hPa
ms-1

1

0.5

1

-1.21

1.49

-11.77

0

7.4

4.19

55.27

4.6

0.72

1

1

1

1.72

3.8

-13.5

0

7.5

4.2

55.95

4.6

0.52

1

1.5

2

-9999

1.52

-18.3

0

7.1

4.22

57.75

4.3

0.22

1

2

2

-9999

3.94

-17.47

0

6.6

4.23

60.2

3.9

0.2

1

2.5

1

2.55

8.3

-21.42

0

6.6

4.22

59.94

3.9

0.33

1

3

2

-9999

1.33

-20.55

0

6.5

4.21

59.25

4.0

0.15

Most importantly the file should have the following properties:

  1. The first line contains the variable names that are exactly the same as in the template (but not case-sensitive), since columns will be identified by the variable names. The same order of columns is preferred but not necessary. Also you may have additional columns without any problems.
  2. The qc variables indicate if the values is valid. If qc>1 then value is considered as faultly and internally replaced by 'missing'. Currently this is only important for NEE.
  3. The second line contains the variable units. Use e.g. 'umol m-2 s-1' or 'm s-1'.
  4. The date/time components are separated into columns. E.g. first column: julian day, second column: decimal hour. Possible date formats are indicated in the input form. Never use an hour of 24 with the time format 'year', 'month', 'day', 'hour', 'minute' (use 0 instead). Hour '0' is interpreted as first hour of the day, i.e. when you have transition from one to another it must be like (day, 23 --> day+1, 0) not like (day, 23 --> day, 0), because then the data set is not chronological (this misunderstanding happened before).
  5. Missing values are indicated by -9999.
  6. Since VPD is used for gap-filling NEE, you should provide it. If you provide Tair and rH, the processing calculates VPD for you from those, using standard assumptions/equations. If none is provided gap-filling category A will more rarely be reached.