Growing better pinot noir – Data
Data in different worksheets in the Excel workbook
The data file includes six worksheets. The data sheet describing trunk diameter gives results for individual vines. In the other data sheets, there are 18 cases corresponding to the treatment and block combinations. Juice analysis data are based on the juice of all grapes from the 9 vines in each treatment and block combination crushed together. Soil sample data are based on 6 soil samples in each treatment and block combination pooled together. Petiole samples were also pooled for each treatment and block combination. On the remaining data sheets, the data from the 9 vines in each treatment and block combination have been averaged.
Definition of variables included on all worksheets in the Excel workbook
| Treatment | Under soil treatment |
|---|---|
| 1 = Herbicide | |
| 2 = Compost | |
| 3 = Straw | |
| EWblock | Blocking from East to West on the vineyard |
| 1 = East West block 1 | |
| 2 = East West block 2 | |
| 3 = East West block 3 | |
| Aspect | North or south aspect of the vineyard |
| 1 = North | |
| 2 = South | |
| Block | Block (East-West block and Aspect) |
| 1= East West block 1 – South side | |
| 2 = East West block 1 – North side | |
| 3 = East West block 2 – South side | |
| 4 = East West block 2 – North side | |
| 5 = East West block 3 – South side | |
| 6 = East West block 3 – North side |
Definition of variable on individual worksheets in the Excel workbook
Click on the element to see the list of variables for that worksheet.
- Variables on the vine growth worksheet
Mean Vine growth stage, 15 September 2001 Mean Vine growth stage, 22 September 2001 Mean Vine growth stage, 29 September 2001 Mean Vine growth stage, 6 October 2001 Mean Vine growth stage, 20 September 2002 Mean Vine growth stage, 27 September 2002 Grapevine Growth stages
Shoot and inforescence development
Stage Number Stage Name Major Stage 1 Budswell 2 Winter bud 3 Woolly bud – brown wool visible 4 Green tip – first leaf visible Budburst 5 Rosette of leaf tips visible 7 First leaf separated from shoot tip 9 2-3 leaves separated; shoots 2-4cm long 11 4 leaves separated 12 5 leaves separated; shoots about 10cm long; inflorescence clear Shoots 10cm 13 6 leaves separated 14 7 leaves separated 15 8 leaves separated; shoot elongating rapidly; single flowers in compact groups 16 10 leaves separated 17 12 leaves separated; inflorescence well developed; single flowers separated 18 14 leaves separated; flower caps still in place, but cap colour fading from green Flowering
Stage Number Stage Name Major Stage 19 About 16 leaves separated; beginning of flowering Flowering begins 20 10% caps off 21 30% caps off 23 17-20 leaves separated; 50% caps off Full bloom 25 80% caps off 26 Cap-fall complete Berry development
Stage Number Stage Name Major Stage 27 Setting; young berries enlarging, bunch at right angles to stem Setting 29 Berries pepper-corn size; bunches tending downwards 31 Berries pea-size (7mm diameter) Berries pea size 32 Beginning of bunch closure; berries touching (if bunches are tight) 33 Berries still hard and green Ripening
Stage Number Stage Name Major Stage 34 Berries begin to soften; Brix starts increasing 35 Berries begin to colour and enlarge Veraison 36 Berries with intermediate Brix values 37 Berries not quite ripe 38 Berries harvest-ripe Harvest 39 Berries over-ripe Senescence
Stage Number Stage Name Major Stage 41 After harves; cane maturation complete 43 Beginning of leaf fall 47 End of leaf fall - Variables on the juice analysis worksheet
Brix of juice (2001 harvest) Brix of juice (2002 harvest) Brix of juice (2003 harvest) pH of juice (2001 harvest) pH of juice (2002 harvest) pH of juice (2003 harvest) Titration of tartaric acid in juice (2001 harvest) Titration of tartaric acid in juice (2002 harvest) Titration of tartaric acid in juice (2003 harvest) - Variables on the harvest yield worksheet
Number of bunches harvested per vine (2001 harvest) Number of bunches harvested per vine (2002 harvest) Number of bunches harvested per vine (2003 harvest) Weight of bunches harvested per vine in kg (2001 harvest) Weight of bunches harvested per vine in kg (2002 harvest) Weight of bunches harvested per vine in kg (2003 harvest) Weight of material pruned per vine in kg (2001) Weight of material pruned per vine in kg (2002) Weight of material pruned per vine in kg (2003) - Variables on the soil samples worksheet
Dry weight 01 Dry weight of 1 gram of fresh soil (in grams) (2001) Dry weight 02 Dry weight of 1 gram of fresh soil (in grams) (2002) Bacteria 01 Weight of active bacteria in micrograms per 1 gram of soil (2001) Bacteria 02 Weight of active bacteria in micrograms per 1 gram of soil (2002) Fungi 01 Weight of active fungus in micrograms per 1 gram of soil (2001) Fungi 02 Weight of active fungus in micrograms per 1 gram of soil (2002) Ca/Mg ratio 01 Calcium to magnesium ratio in the soil (2001) Ca/Mg ratio 02 Calcium to magnesium ratio in the soil (2002) pH CaCl 01 pH of the soil (in calcium chloride solution) (2001) pH CaCl 02 pH of the soil (in calcium chloride solution) (2002) Soil chloride 01 Amount of chloride in the soil in milligrams per kilogram (2001) Soil chloride 02 Amount of chloride in the soil in milligrams per kilogram (2002) Soil phosphorus 01 Amount of phosphorus in the soil in milligrams per kilogram (2001) Soil phosphorus 02 Amount of phosphorus in the soil in milligrams per kilogram (2002) Soil potassium 01 Amount of potassium in the soil in milligrams per kilogram (2001) Soil potassium 02 Amount of potassium in the soil in milligrams per kilogram (2002) Soluble calcium 01 Amount of calcium in the water contained in the soil in milliequivalents per kilogram (2001) Soluble calcium 02 Amount of calcium in the water contained in the soil in milliequivalents per kilogram (2002) Soluble magnesium 01 Amount of magnesium in the water contained in the soil in milliequivalents per kilogram (2001) Soluble magnesium 02 Amount of magnesium in the water contained in the soil in milliequivalents per kilogram (2002) Soluble potassium 01 Amount of potassium in the water contained in the soil in milliequivalents per kilogram (2001) Soluble potassium 02 Amount of potassium in the water contained in the soil in milliequivalents per kilogram (2002) Soluble sodium 01 Amount of sodium in the water contained in the soil in milliequivalents per kilogram (2001) Soluble sodium 02 Amount of sodium in the water contained in the soil in milliequivalents per kilogram (2002) - Variables on the petiole samples worksheet
Calcium01 Percentage of calcium contained in the dry matter of the petiole (2001) Calcium02 Percentage of calcium contained in the dry matter of the petiole (2002) Magnesium01 Percentage of magnesium contained in the dry matter of the petiole (2001) Magnesium02 Percentage of magnesium contained in the dry matter of the petiole (2002) Potassium01 Percentage of potassium contained in the dry matter of the petiole (2001) Potassium02 Percentage of potassium contained in the dry matter of the petiole (2002) Sodium01 Percentage of sodium contained in the dry matter of the petiole (2001) Sodium02 Percentage of sodium contained in the dry matter of the petiole (2002) - Variables on the trunk diameter worksheet
Row Row number in the vineyard Panel Panel number in the row Vine Vine number in the panel Trunk diameter in 2000 (cm) Trunk diameter in 2001 (cm) Trunk diameter in 2002 (cm) Trunk diameter in 2003 (cm)