File Testeco

(To be stored on a EXCEL or QUATTRO spreadsheet)

Column A: Code

Code of the test  

This code is link 2 and is in column A of file Test.

The code of the test comprises three components :

* the letter T

* two letters corresponding to the country where the test is planted (AT: Austria, BE: Belgium, DK: Denmark, FR: France, DE: Germany, NL: Netherlands, ES: Spain, GB: United Kingdom)

* a number in sequence given by the institute. Different participants of the same country hosting tests ( P2 and P3 for Germany, and P7 and P11 for Danemark) agree on the numbers given. For example, P2 would number his tests from T-DE-01 to T-DE-10 and P3 from T-DE-11 to T-DE-20.

For example, T-DE-06 would be test 6 established in Germany

Column B: Name

Usual name of the test, or code used by the Institute hosting the test (same as column B of file Test)

Column C: Institute

Code of the institute hosting the test.

This code is Link3 and is in column C of file Test.

Column D: Aspect

Indicate aspect of the experimental plantation. Use 2 digits maximum as follows:

N : North

NE : Northeast

E : East

SE : South East

S : South

SW : Southwest

W : West

NW : Northwest

Column E: Slope

Indicate the slope of the experimental plantation :

variable

0%

0 to 10 %

10 to 20 %

> 20 %

Column F: Location of climatic station

Indicate the name of the locality of the climatic station.

Column G: Altitude of climatic station

In meters

Column H: Distance of climatic station from stand where the provenance was collected

In kilometers with one decimal place

Column I: Direction of climatic station from stand where the provenance was collected.

Indicate compass direction:

N : North

NE : Northeast

E : East

SE : South East

S : South

SW : Southwest

W : West

NW : Northwest

Column J: Mean monthly precipitation

Mean monthly precipitation (over the observation period) in millimeters

Column K : Growing period.

Indicate the months (in numbers, inclusive) of growing period for which the column K was calculated (for example 4-9)

Column L: Mean monthly temperature

Mean annual temperature calculated over the observation period (in °C,with one decimal place). calculated over the observation period

Column M: Mean monthly minimum temperature

in °C, with one decimal place, calculated over the observation period

Column N Mean monthly maximum temperature

in °C, with one decimal place, calculated over the observation period

Column O: Mean number of freezing days per year

Number of days per year when freezing occured (calculated over the observation period)

Column P: Observation period for climatic data

Indicate the dates (inclusive in years) during which climatic records were taken (example 1951-1991). A period of at least 10 years is recommended

Column Q: Geology

Indicate the type of rocks on which the stand is growing as one of the following types:

eruptive

acidic sedimentary

basic sedimentary

alluvium

clay

schist

metamorphic

others

Column R: Soil Type

Indicate the most frequent soil type on the experimental plot according to international classification rules to be sent later on.


If for some columns, the informations exists but is not yet available, put a question mark ?

If for some columns, the information is not available and will never be, put a dash -