NanoImport← Tous les documents

Documents complets dans votre langue

Classeur de données des essais AREI

Tableur fourni avec les tableaux des essais et les valeurs enregistrées.

Télécharger le PDF en français

Feuille de calcul: betterave

Tableau 1
Rendement de betterave à Stende, 2025B1
CultureB2betteraveC2
ChampB3SKL 10C3
SeméB426.05.2025.C4
RécoltéB510.-11.09.2025. Olena et SolveigaC5
Longueur des feuilles, cmD6Masse des feuilles, kgE6Poids en kgF6Diamètre de la betterave, cmG6Brix % (teneur en sucre)H6GrandesI6Calibre moyenK6PetitM6Poids en kgO6
unitésI7kgJ7unitésK7kgL7unitésM7kgN7par rangO7
Traitement 1A8IB81.0C845.0D80.115E80.205F88.5G89.5H83.0I81.305J816.0K82.92L825.0M80.995N85.22O8
Formule=SUM(J8+L8+N8)
Rang 1P8
2.0C942.0D90.09E90.17F98.0G97.3H92.0I90.655J921.0K93.08L935.0M90.925N94.66O9
Formule=SUM(J9+L9+N9)
Rang 2P9
3.0C1045.0D100.1E100.24F107.1G107.7H10
4.0C1146.0D110.13E110.255F116.2G1110.6H11
5.0C1241.0D120.05E120.135F126.5G1210.4H12
par répétitionB1343.8D13
Formule=AVERAGE(D8:D12)
0.097E13
Formule=AVERAGE(E8:E12)
0.201F13
Formule=AVERAGE(F8:F12)
7.26G13
Formule=AVERAGE(G8:G12)
9.1H13
Formule=AVERAGE(H8:H12)
9.88O13
Formule=SUM(O8:O12)
IIB141.0C1437.0D140.08E140.155F147.0G149.7H141.0I140.46J146.0K140.85L1435.0M141.015N142.325O14
Formule=SUM(J14+L14+N14)
2.0C1534.0D150.05E150.145F156.3G1510.7H152.0I150.685J1525.0K153.55L1534.0M151.05N155.285O15
Formule=SUM(J15+L15+N15)
3.0C1637.0D160.055E160.23F165.6G1610.5H16
4.0C1739.0D170.06E170.14F175.7G1710.1H17
5.0C1839.0D180.065E180.13F186.0G1810.7H18
par répétitionB1937.2D19
Formule=AVERAGE(D14:D18)
0.062E19
Formule=AVERAGE(E14:E18)
0.16F19
Formule=AVERAGE(F14:F18)
6.12G19
Formule=AVERAGE(G14:G18)
10.34H19
Formule=AVERAGE(H14:H18)
7.61O19
Formule=SUM(O14:O18)
IIIB201.0C2041.0D200.055E200.16F206.0G2010.0H200.0I200.0J207.0K200.89L2017.0M200.325N201.215O20
Formule=SUM(J20+L20+N20)
2.0C2140.0D210.07E210.12F216.8G2110.2H213.0I210.92J2125.0K213.83L2122.0M210.775N215.525O21
Formule=SUM(J21+L21+N21)
3.0C2239.0D220.075E220.135F226.5G2211.4H22
4.0C2345.0D230.1E230.19F236.2G2310.9H23
5.0C2441.0D240.075E240.175F246.7G2410.6H24
par répétitionB2541.2D25
Formule=AVERAGE(D20:D24)
0.075E25
Formule=AVERAGE(E20:E24)
0.156F25
Formule=AVERAGE(F20:F24)
6.44G25
Formule=AVERAGE(G20:G24)
10.62H25
Formule=AVERAGE(H20:H24)
6.74O25
Formule=SUM(O20:O24)
IVB261.0C2635.0D260.075E260.24F267.8G2610.3H260.0I260.0J2623.0K262.54L2627.0M260.89N263.43O26
Formule=SUM(J26+L26+N26)
2.0C2739.0D270.08E270.28F278.2G2711.3H274.0I271.81J2734.0K274.615L2720.0M270.61N277.035O27
Formule=SUM(J27+L27+N27)
3.0C2847.0D280.055E280.18F287.4G2810.4H28
4.0C2932.0D290.09E290.215F296.5G2911.3H29
5.0C3038.0D300.055E300.18F307.2G3010.6H30
par répétitionB3138.2D31
Formule=AVERAGE(D26:D30)
0.071E31
Formule=AVERAGE(E26:E30)
0.219F31
Formule=AVERAGE(F26:F30)
7.42G31
Formule=AVERAGE(G26:G30)
10.78H31
Formule=AVERAGE(H26:H30)
10.465O31
Formule=SUM(O26:O30)
par traitementB3240.1D32
Formule=SUM(D13+D19+D25+D31)/4
0.07625E32
Formule=SUM(E13+E19+E25+E31)/4
0.184F32
Formule=SUM(F13+F19+F25+F31)/4
6.81G32
Formule=SUM(G13+G19+G25+G31)/4
10.21H32
Formule=SUM(H13+H19+H25+H31)/4
1.875I32
Formule=AVERAGE(I8:I31)
0.729375J32
Formule=AVERAGE(J8:J31)
19.625K32
Formule=AVERAGE(K8:K31)
2.784375L32
Formule=AVERAGE(L8:L31)
26.875M32
Formule=AVERAGE(M8:M31)
0.823125N32
Formule=AVERAGE(N8:N31)
8.67375O32
Formule=SUM(O13+O19+O25+O31)/4
Traitement 2A33IB331.0C3338.0D330.075E330.22F337.3G3312.1H337.0I333.6J3326.0K334.155L339.0M330.34N338.095O33
Formule=SUM(J33+L33+N33)
2.0C3440.0D340.08E340.19F346.5G3410.4H342.0I341.185J3426.0K344.725L3417.0M340.56N346.47O34
Formule=SUM(J34+L34+N34)
3.0C3541.0D350.095E350.245F357.1G359.7H35
4.0C3652.0D360.125E360.235F366.8G3610.8H36
5.0C3740.0D370.085E370.23F377.5G3712.1H37
par répétitionB3842.2D38
Formule=AVERAGE(D33:D37)
0.092E38
Formule=AVERAGE(E33:E37)
0.224F38
Formule=AVERAGE(F33:F37)
7.04G38
Formule=AVERAGE(G33:G37)
11.02H38
Formule=AVERAGE(H33:H37)
14.565O38
Formule=SUM(O33:O37)
IIB391.0C3952.0D390.09E390.19F396.4G3911.3H392.0I391.04J3916.0K392.31L3920.0M390.7N394.05O39
Formule=SUM(J39+L39+N39)
2.0C4042.0D400.055E400.215F407.2G4011.4H403.0I401.32J4028.0K404.19L4060.0M400.56N406.07O40
Formule=SUM(J40+L40+N40)
3.0C4142.0D410.05E410.225F417.0G419.9H41
4.0C4241.0D420.1E420.23F428.0G429.2H42
5.0C4343.0D430.075E430.195F436.6G4312.2H43
par répétitionB4444D44
Formule=AVERAGE(D39:D43)
0.074E44
Formule=AVERAGE(E39:E43)
0.211F44
Formule=AVERAGE(F39:F43)
7.04G44
Formule=AVERAGE(G39:G43)
10.8H44
Formule=AVERAGE(H39:H43)
10.12O44
Formule=SUM(O39:O43)
IIIB451.0C4543.0D450.065E450.15F457.3G4512.0H452.0I450.705J4525.0K453.76L4526.0M450.8N455.265O45
Formule=SUM(J45+L45+N45)
2.0C4650.0D460.09E460.245F466.4G4612.3H462.0I460.79J4628.0K464.405L4626.0M460.835N466.03O46
Formule=SUM(J46+L46+N46)
3.0C4752.0D470.1E470.265F476.4G4712.5H47
4.0C4844.0D480.055E480.205F485.7G4812.6H48
5.0C4943.0D490.07E490.195F497.1G4911.1H49
par répétitionB5046.4D50
Formule=AVERAGE(D45:D49)
0.076E50
Formule=AVERAGE(E45:E49)
0.212F50
Formule=AVERAGE(F45:F49)
6.58G50
Formule=AVERAGE(G45:G49)
12.1H50
Formule=AVERAGE(H45:H49)
11.295O50
Formule=SUM(O45:O49)
IVB511.0C5149.0D510.095E510.21F517.9G5112.0H513.0I511.525J5122.0K513.155L5119.0M510.715N515.395O51
Formule=SUM(J51+L51+N51)
2.0C5249.0D520.1E520.255F527.6G5212.8H523.0I521.315J5221.0K524.53L5214.0M520.545N526.39O52
Formule=SUM(J52+L52+N52)
3.0C5345.0D530.08E530.17F538.8G5312.3H53
4.0C5451.0D540.12E540.305F545.8G5413.1H54
5.0C5541.0D550.08E550.135F555.4G5512.9H55
par répétitionB5647D56
Formule=AVERAGE(D51:D55)
0.095E56
Formule=AVERAGE(E51:E55)
0.215F56
Formule=AVERAGE(F51:F55)
7.1G56
Formule=AVERAGE(G51:G55)
12.62H56
Formule=AVERAGE(H51:H55)
11.785O56
Formule=SUM(O51:O55)
par traitementB5744.9D57
Formule=SUM(D38+D44+D50+D56)/4
0.08425E57
Formule=SUM(E38+E44+E50+E56)/4
0.2155F57
Formule=SUM(F38+F44+F50+F56)/4
6.94G57
Formule=SUM(G38+G44+G50+G56)/4
11.635H57
Formule=SUM(H38+H44+H50+H56)/4
3I57
Formule=AVERAGE(I33:I56)
1.435J57
Formule=AVERAGE(J33:J56)
24K57
Formule=AVERAGE(K33:K56)
3.90375L57
Formule=AVERAGE(L33:L56)
23.875M57
Formule=AVERAGE(M33:M56)
0.631875N57
Formule=AVERAGE(N33:N56)
11.94125O57
Formule=SUM(O38+O44+O50+O56)/4
Traitement 3A58IB581.0C5841.0D580.08E580.225F587.1G5811.7H581.0I580.515J5824.0K583.865L5825.0M580.835N585.215O58
Formule=SUM(J58+L58+N58)
2.0C5942.0D590.195E590.275F597.4G5911.2H590.0I590.0J5925.0K594.26L5930.0M591.015N595.275O59
Formule=SUM(J59+L59+N59)
3.0C6044.0D600.1E600.29F607.3G6011.5H60
4.0C6143.0D610.13E610.26F616.5G6110.1H61
5.0C6237.0D620.105E620.22F628.8G629.1H62
par répétitionB6341.4D63
Formule=AVERAGE(D58:D62)
0.122E63
Formule=AVERAGE(E58:E62)
0.254F63
Formule=AVERAGE(F58:F62)
7.42G63
Formule=AVERAGE(G58:G62)
10.72H63
Formule=AVERAGE(H58:H62)
10.49O63
Formule=SUM(O58:O62)
IIB641.0C6443.0D641.14E640.25F647.8G6411.4H641.0I640.355J6422.0K642.74L6421.0M640.715N643.81O64
Formule=SUM(J64+L64+N64)
2.0C6539.0D650.08E650.27F658.0G6512.0H650.0I650.0J6525.0K653.74L6534.0M651.27N655.01O65
Formule=SUM(J65+L65+N65)
3.0C6653.0D660.15E660.21F668.6G6612.4H66
4.0C6744.0D670.105E670.28F677.2G678.7H67
5.0C6843.0D680.12E680.25F687.2G6811.6H68
par répétitionB6944.4D69
Formule=AVERAGE(D64:D68)
0.319E69
Formule=AVERAGE(E64:E68)
0.252F69
Formule=AVERAGE(F64:F68)
7.76G69
Formule=AVERAGE(G64:G68)
11.22H69
Formule=AVERAGE(H64:H68)
8.82O69
Formule=SUM(O64:O68)
IIIB701.0C7039.0D700.09E700.32F708.7G7012.9H701.0I700.635J7011.0K701.71L7039.0M701.21N703.555O70
Formule=SUM(J70+L70+N70)
2.0C7138.0D710.1E710.245F717.3G719.3H712.0I711.02J7121.0K713.015L7123.0M710.915N714.95O71
Formule=SUM(J71+L71+N71)
3.0C7237.0D720.105E720.2F728.8G7211.0H72
4.0C7346.0D730.105E730.27F738.0G7310.8H73
5.0C7441.0D740.095E740.25F746.1G749.4H74
par répétitionB7540.2D75
Formule=AVERAGE(D70:D74)
0.099E75
Formule=AVERAGE(E70:E74)
0.257F75
Formule=AVERAGE(F70:F74)
7.78G75
Formule=AVERAGE(G70:G74)
10.68H75
Formule=AVERAGE(H70:H74)
8.505O75
Formule=SUM(O70:O74)
IVB761.0C7643.0D760.14E760.305F767.4G7613.1H762.0I760.84J7613.0K761.515L7635.0M761.36N763.715O76
Formule=SUM(J76+L76+N76)
2.0C7743.0D770.14E770.225F776.6G7713.4H774.0I772.07J7726.0K774.345L7722.0M770.9N777.315O77
Formule=SUM(J77+L77+N77)
3.0C7839.0D780.085E780.245F786.8G7811.4H78
4.0C7946.0D790.115E790.225F797.5G799.7H79
5.0C8039.0D800.14E800.21F806.5G8010.9H80
par répétitionB8142D81
Formule=AVERAGE(D76:D80)
0.124E81
Formule=AVERAGE(E76:E80)
0.242F81
Formule=AVERAGE(F76:F80)
6.96G81
Formule=AVERAGE(G76:G80)
11.7H81
Formule=AVERAGE(H76:H80)
11.03O81
Formule=SUM(O76:O80)
par traitementB8242D82
Formule=SUM(D63+D69+D75+D81)/4
0.166E82
Formule=SUM(E63+E69+E75+E81)/4
0.25125F82
Formule=SUM(F63+F69+F75+F81)/4
7.48G82
Formule=SUM(G63+G69+G75+G81)/4
11.08H82
Formule=SUM(H63+H69+H75+H81)/4
1.375I82
Formule=AVERAGE(I58:I81)
0.679375J82
Formule=AVERAGE(J58:J81)
20.875K82
Formule=AVERAGE(K58:K81)
3.14875L82
Formule=AVERAGE(L58:L81)
28.625M82
Formule=AVERAGE(M58:M81)
1.0275N82
Formule=AVERAGE(N58:N81)
9.71125O82
Formule=SUM(O63+O69+O75+O81)/4
Traitement 4A83IB831.0C8340.0D830.115E830.275F837.5G8312.8H835.0I832.135J8318.0K832.5L8320.0M830.795N835.43O83
Formule=SUM(J83+L83+N83)
2.0C8440.0D840.08E840.21F847.2G8411.9H842.0I841.4J8414.0K842.72L8421.0M841.035N845.155O84
Formule=SUM(J84+L84+N84)
3.0C8536.0D850.075E850.24F857.0G8512.4H85
4.0C8646.0D860.08E860.165F866.4G8612.5H86
5.0C8743.0D870.075E870.25F877.5G8710.2H87
par répétitionB8841D88
Formule=AVERAGE(D83:D87)
0.085E88
Formule=AVERAGE(E83:E87)
0.228F88
Formule=AVERAGE(F83:F87)
7.12G88
Formule=AVERAGE(G83:G87)
11.96H88
Formule=AVERAGE(H83:H87)
10.585O88
Formule=SUM(O83:O87)
IIB891.0C8942.0D890.09E890.21F896.5G8913.7H892.0I890.86J8917.0K892.82L8928.0M891.015N894.695O89
Formule=SUM(J89+L89+N89)
2.0C9047.0D900.12E900.215F906.4G9012.1H900.0I900.0J9029.0K904.945L9040.0M901.34N906.285O90
Formule=SUM(J90+L90+N90)
3.0C9143.0D910.11E910.19F917.6G9110.0H91
4.0C9241.0D920.085E920.175F927.0G9210.2H92
5.0C9348.0D930.125E930.225F936.6G939.7H93
par répétitionB9444.2D94
Formule=AVERAGE(D89:D93)
0.106E94
Formule=AVERAGE(E89:E93)
0.203F94
Formule=AVERAGE(F89:F93)
6.82G94
Formule=AVERAGE(G89:G93)
11.14H94
Formule=AVERAGE(H89:H93)
10.98O94
Formule=SUM(O89:O93)
IIIB951.0C9537.0D950.06E950.17F956.5G9510.5H950.0I950.0J9522.0K953.225L9539.0M951.435N954.66O95
Formule=SUM(J95+L95+N95)
2.0C9640.0D960.1E960.295F967.0G9610.5H964.0I961.535J9630.0K964.765L9634.0M961.46N967.76O96
Formule=SUM(J96+L96+N96)
3.0C9742.0D970.08E970.175F976.4G979.6H97
4.0C9844.0D980.09E980.195F988.0G9812.2H98
5.0C9934.0D990.065E990.205F997.2G9911.5H99
par répétitionB10039.4D100
Formule=AVERAGE(D95:D99)
0.079E100
Formule=AVERAGE(E95:E99)
0.208F100
Formule=AVERAGE(F95:F99)
7.02G100
Formule=AVERAGE(G95:G99)
10.86H100
Formule=AVERAGE(H95:H99)
12.42O100
Formule=SUM(O95:O99)
IVB1011.0C10140.0D1010.08E1010.165F1017.1G1017.0H1010.0I1010.0J10117.0K1012.15L10134.0M1010.98N1013.13O101
Formule=SUM(J101+L101+N101)
2.0C10236.0D1020.07E1020.18F1026.3G1028.8H1023.0I1021.37J10232.0K1025.605L10228.0M1021.095N1028.07O102
Formule=SUM(J102+L102+N102)
3.0C10345.0D1030.095E1030.24F1036.2G1039.4H103
4.0C10444.0D1040.09E1040.235F1046.6G1049.0H104
5.0C10543.0D1050.07E1050.17F1057.1G1059.7H105
par répétitionB10641.6D106
Formule=AVERAGE(D101:D105)
0.081E106
Formule=AVERAGE(E101:E105)
0.198F106
Formule=AVERAGE(F101:F105)
6.66G106
Formule=AVERAGE(G101:G105)
8.78H106
Formule=AVERAGE(H101:H105)
11.2O106
Formule=SUM(O101:O105)
par traitementB10741.55D107
Formule=SUM(D88+D94+D100+D106)/4
0.08775E107
Formule=SUM(E88+E94+E100+E106)/4
0.20925F107
Formule=SUM(F88+F94+F100+F106)/4
6.905G107
Formule=SUM(G88+G94+G100+G106)/4
10.685H107
Formule=SUM(H88+H94+H100+H106)/4
2I107
Formule=AVERAGE(I83:I105)
0.9125J107
Formule=AVERAGE(J83:J105)
22.375K107
Formule=AVERAGE(K83:K105)
3.59125L107
Formule=AVERAGE(L83:L105)
30.5M107
Formule=AVERAGE(M83:M105)
1.144375N107
Formule=AVERAGE(N83:N105)
11.29625O107
Formule=SUM(O88+O94+O100+O106)/4
Traitement 5A108IB1081.0C10847.0D1080.12E1080.325F1087.1G10813.0H1082.0I1081.335J10830.0K1085.13L10824.0M1080.805N1087.27O108
Formule=SUM(J108+L108+N108)
2.0C10945.0D1090.11E1090.235F1099.0G10910.4H1096.0I1092.92J10917.0K1093.22L10929.0M1090.95N1097.09O109
Formule=SUM(J109+L109+N109)
3.0C11045.0D1100.115E1100.31F1107.0G11012.8H110
4.0C11150.0D1110.075E1110.185F1116.7G11112.7H111
5.0C11246.0D1120.135E1120.44F1127.9G11213.8H112
par répétitionB11346.6D113
Formule=AVERAGE(D108:D112)
0.111E113
Formule=AVERAGE(E108:E112)
0.299F113
Formule=AVERAGE(F108:F112)
7.54G113
Formule=AVERAGE(G108:G112)
12.54H113
Formule=AVERAGE(H108:H112)
14.36O113
Formule=SUM(O108:O112)
IIB1141.0C11450.0D1140.125E1140.29F1148.4G11413.9H1141.0I1141.09J11414.0K1142.38L11427.0M1140.81N1144.28O114
Formule=SUM(J114+L114+N114)
2.0C11539.0D1150.09E1150.19F1158.0G11511.4H1154.0I1152.195J11523.0K1154.89L11524.0M1150.81N1157.895O115
Formule=SUM(J115+L115+N115)
3.0C11650.0D1160.12E1160.365F1167.3G11611.3H116
4.0C11750.0D1170.09E1170.29F1177.1G11711.7H117
5.0C11848.0D1180.11E1180.27F1186.5G11811.5H118
par répétitionB11947.4D119
Formule=AVERAGE(D114:D118)
0.107E119
Formule=AVERAGE(E114:E118)
0.281F119
Formule=AVERAGE(F114:F118)
7.46G119
Formule=AVERAGE(G114:G118)
11.96H119
Formule=AVERAGE(H114:H118)
12.175O119
Formule=SUM(O114:O118)
IIIB1201.0C12048.0D1200.145E1200.235F1206.8G12012.8H1203.0I1201.925J12013.0K1202.435L12013.0M1200.395N1204.755O120
Formule=SUM(J120+L120+N120)
2.0C12139.0D1210.125E1210.25F1217.1G12112.6H1212.0I1210.99J12118.0K1213.005L12121.0M1210.7N1214.695O121
Formule=SUM(J121+L121+N121)
3.0C12241.0D1220.1E1220.26F1227.0G12212.8H122
4.0C12337.0D1230.07E1230.23F1238.5G12310.4H123
5.0C12450.0D1240.115E1240.31F1247.6G1249.3H124
par répétitionB12543D125
Formule=AVERAGE(D120:D124)
0.111E125
Formule=AVERAGE(E120:E124)
0.257F125
Formule=AVERAGE(F120:F124)
7.4G125
Formule=AVERAGE(G120:G124)
11.58H125
Formule=AVERAGE(H120:H124)
9.45O125
Formule=SUM(O120:O124)
IVB1261.0C12642.0D1260.08E1260.275F1266.7G12612.5H1263.0I1261.495J12623.0K1264.29L12624.0M1260.765N1266.55O126
Formule=SUM(J126+L126+N126)
2.0C12749.0D1270.095E1270.2F1277.5G12711.3H1279.0I1275.34J12719.0K1273.825L12714.0M1270.365N1279.53O127
Formule=SUM(J127+L127+N127)
3.0C12848.0D1280.125E1280.32F1288.7G12812.5H128
4.0C12947.0D1290.14E1290.345F1296.0G12911.1H129
5.0C13050.0D1300.155E1300.35F1309.0G13010.0H130
par répétitionB13147.2D131
Formule=AVERAGE(D126:D130)
0.119E131
Formule=AVERAGE(E126:E130)
0.298F131
Formule=AVERAGE(F126:F130)
7.58G131
Formule=AVERAGE(G126:G130)
11.48H131
Formule=AVERAGE(H126:H130)
16.08O131
Formule=SUM(O126:O130)
par traitementB13246.05D132
Formule=SUM(D113+D119+D125+D131)/4
0.112E132
Formule=SUM(E113+E119+E125+E131)/4
0.28375F132
Formule=SUM(F113+F119+F125+F131)/4
7.495G132
Formule=SUM(G113+G119+G125+G131)/4
11.89H132
Formule=SUM(H113+H119+H125+H131)/4
3.75I132
Formule=AVERAGE(I108:I131)
2.16125J132
Formule=AVERAGE(J108:J131)
19.625K132
Formule=AVERAGE(K108:K131)
3.646875L132
Formule=AVERAGE(L108:L131)
22M132
Formule=AVERAGE(M108:M131)
0.7N132
Formule=AVERAGE(N108:N131)
13.01625O132
Formule=SUM(O113+O119+O125+O131)/4
Traitement 6A133IB1331.0C13345.0D1330.1E1330.205F1337.6G13310.4H1338.0I1334.27J1336.0K1330.795L13312.0M1330.625N1335.69O133
Formule=SUM(J133+L133+N133)
2.0C13440.0D1340.075E1340.195F1347.3G13410.2H1345.0I1342.385J13428.0K1345.3L13418.0M1340.365N1348.05O134
Formule=SUM(J134+L134+N134)
3.0C13544.0D1350.125E1350.31F1357.0G13511.0H135GrandesR135Calibre moyenU135PetitX135
4.0C13642.0D1360.11E1360.28F1367.4G13610.9H136unitésR136kgS136% du nombre totalT136unitésU136kgV136% du nombre totalW136unitésX136kgY136% du nombre totalZ136Nombre total, unitésAA136Total kgAB136
5.0C13742.0D1370.125E1370.275F1376.3G13712.3H1371.875R1370.7293750000000001S1373.875968992T137
Formule=R137/AA137*100
19.625U1372.784375V13740.56847545W137
Formule=U137/AA137*100
26.875X1370.823125Y13755.55555556Z137
Formule=X137/AA137*100
48.375AA137
Formule=SUM(R137+U137+X137)
4.336875AB137
Formule=SUM(S137+V137+Y137)
par répétitionB13842.6D138
Formule=AVERAGE(D133:D137)
0.107E138
Formule=AVERAGE(E133:E137)
0.253F138
Formule=AVERAGE(F133:F137)
7.12G138
Formule=AVERAGE(G133:G137)
10.96H138
Formule=AVERAGE(H133:H137)
13.74O138
Formule=SUM(O133:O137)
3.0R1381.435S1385.896805897T138
Formule=R138/AA138*100
24.0U1383.9037500000000005V13847.17444717W138
Formule=U138/AA138*100
23.875X1380.631875Y13846.92874693Z138
Formule=X138/AA138*100
50.875AA138
Formule=SUM(R138+U138+X138)
5.970625AB138
Formule=SUM(S138+V138+Y138)
IIB1391.0C13949.0D1390.195E1390.425F1397.1G13910.8H1391.0I1390.545J13921.0K1392.45L13919.0M1390.665N1393.66O139
Formule=SUM(J139+L139+N139)
1.375R1390.679375S1392.702702703T139
Formule=R139/AA139*100
20.875U1393.14875V13941.03194103W139
Formule=U139/AA139*100
28.625X1391.0275Y13956.26535627Z139
Formule=X139/AA139*100
50.875AA139
Formule=SUM(R139+U139+X139)
4.855625AB139
Formule=SUM(S139+V139+Y139)
2.0C14049.0D1400.125E1400.26F1408.6G14010.0H1400.0I1400.0J14033.0K1406.26L14026.0M1400.84N1407.1O140
Formule=SUM(J140+L140+N140)
2.0R1400.9125S1403.644646925T140
Formule=R140/AA140*100
22.375U1403.59125V14040.77448747W140
Formule=U140/AA140*100
30.5X1401.144375Y14055.5808656Z140
Formule=X140/AA140*100
54.875AA140
Formule=SUM(R140+U140+X140)
5.648125AB140
Formule=SUM(S140+V140+Y140)
3.0C14143.0D1410.09E1410.17F1418.8G14110.8H1413.75R1412.16125S1418.26446281T141
Formule=R141/AA141*100
19.625U1413.6468749999999996V14143.25068871W141
Formule=U141/AA141*100
22.0X1410.7Y14148.48484848Z141
Formule=X141/AA141*100
45.375AA141
Formule=SUM(R141+U141+X141)
6.508125AB141
Formule=SUM(S141+V141+Y141)
4.0C14241.0D1420.1E1420.36F1426.5G14212.4H1422.4R142
Formule=AVERAGE(R118:R141)
1.1835S142
Formule=AVERAGE(S118:S141)
4.792810784T142
Formule=R142/AA142*100
21.3U142
Formule=AVERAGE(U118:U141)
3.415V142
Formule=AVERAGE(V118:V141)
42.53619571W142
Formule=U142/AA142*100
26.375X142
Formule=AVERAGE(X118:X141)
0.865375Y142
Formule=AVERAGE(Y118:Y141)
52.67099351Z142
Formule=X142/AA142*100
50.075AA142
Formule=SUM(R142+U142+X142)
5.463875AB142
Formule=SUM(S142+V142+Y142)
5.0C14349.0D1430.125E1430.39F1438.5G14310.8H143
par répétitionB14446.2D144
Formule=AVERAGE(D139:D143)
0.127E144
Formule=AVERAGE(E139:E143)
0.321F144
Formule=AVERAGE(F139:F143)
7.9G144
Formule=AVERAGE(G139:G143)
10.96H144
Formule=AVERAGE(H139:H143)
10.76O144
Formule=SUM(O139:O143)
IIIB1451.0C14550.0D1450.1E1450.2F1457.3G14511.8H1454.0I1452.94J14517.0K1452.455L14512.0M1450.34N1455.735O145
Formule=SUM(J145+L145+N145)
2.0C14647.0D1460.185E1460.34F1466.9G14611.9H1461.0I1460.575J14630.0K1465.825L14619.0M1460.46N1466.86O146
Formule=SUM(J146+L146+N146)
3.0C14740.0D1470.185E1470.32F1478.2G14712.3H147
4.0C14845.0D1480.13E1480.3F1487.9G14812.9H148
5.0C14945.0D1490.13E1490.26F1498.0G14912.8H149
par répétitionB15045.4D150
Formule=AVERAGE(D145:D149)
0.146E150
Formule=AVERAGE(E145:E149)
0.284F150
Formule=AVERAGE(F145:F149)
7.66G150
Formule=AVERAGE(G145:G149)
12.34H150
Formule=AVERAGE(H145:H149)
12.595O150
Formule=SUM(O145:O149)
IVB1511.0C15149.0D1510.165E1510.39F1518.7G15111.0H1514.0I1512.94J15117.0K1512.455L15112.0M1510.34N1515.735O151
Formule=SUM(J151+L151+N151)
2.0C15248.0D1520.085E1520.28F1528.2G15211.8H1521.0I1520.575J15230.0K1525.825L15219.0M1520.46N1526.86O152
Formule=SUM(J152+L152+N152)
3.0C15350.0D1530.145E1530.315F1538.5G15311.3H153
4.0C15446.0D1540.15E1540.34F1548.2G15411.6H154
5.0C15550.0D1550.14E1550.45F1557.8G15511.7H155
par répétitionB15648.6D156
Formule=AVERAGE(D151:D155)
0.137E156
Formule=AVERAGE(E151:E155)
0.355F156
Formule=AVERAGE(F151:F155)
8.28G156
Formule=AVERAGE(G151:G155)
11.48H156
Formule=AVERAGE(H151:H155)
12.595O156
Formule=SUM(O151:O155)
par traitementB15745.7D157
Formule=SUM(D138+D144+D150+D156)/4
0.12925E157
Formule=SUM(E138+E144+E150+E156)/4
0.30325F157
Formule=SUM(F138+F144+F150+F156)/4
7.74G157
Formule=SUM(G138+G144+G150+G156)/4
11.435H157
Formule=SUM(H138+H144+H150+H156)/4
3I157
Formule=AVERAGE(I133:I156)
1.77875J157
Formule=AVERAGE(J133:J156)
22.75K157
Formule=AVERAGE(K133:K156)
3.920625L157
Formule=AVERAGE(L133:L156)
17.125M157
Formule=AVERAGE(M133:M156)
0.511875N157
Formule=AVERAGE(N133:N156)
12.4225O157
Formule=SUM(O138+O144+O150+O156)/4
Rendement de betterave potagère, kg pour 2 m², SPC, 2025B159Anova: Facteur uniqueY159
N° de traitementA160Code de traitementB160IC160IID160IIIE160IVF160MoyenneG160Par rapport à KH160Code de traitementN160Rendement de betterave potagère, t ha-1O160MoyenneS160Par rapport à K, t ha-1T160Par rapport à K, %U160
1.0A161NPK 0B1619.88C161
Formule=O13
7.61D161
Formule=O19
6.74E161
Formule=O25
10.465F161
Formule=O31
8.67375G161
Formule=AVERAGE(C161:F161)
9.879999999999999I1617.609999999999999J1616.74K16110.465000000000002L161NPK 0N16149.4O161
Formule=I161*10000/2/1000
38.05P161
Formule=J161*10000/2/1000
33.7Q161
Formule=K161*10000/2/1000
52.325R161
Formule=L161*10000/2/1000
41.35833333S161
Formule=AVERAGE(P161:R161)
RésuméY161
3.0A162NPK0 C1B16210.49C162
Formule=O63
8.82D162
Formule=O69
8.505E162
Formule=O75
11.03F162
Formule=O81
9.71125G162
Formule=AVERAGE(C162:F162)
1.0375H162
Formule=G162-$G$161
10.489999999999998I1628.82J1628.504999999999999K16211.03L162NPK0 C1N16252.45O162
Formule=I162*10000/2/1000
44.1P162
Formule=J162*10000/2/1000
42.525Q162
Formule=K162*10000/2/1000
55.15R162
Formule=L162*10000/2/1000
47.25833333S162
Formule=AVERAGE(P162:R162)
5.9T162
Formule=S162-$S$161
114.2655652U162
Formule=S162/$S$161*100
GroupesY162NombreZ162SommeAA162MoyenneAB162VarianceAC162
4.0A163NPK0 C2B16310.585C163
Formule=O88
10.98D163
Formule=O94
12.42E163
Formule=O100
11.2F163
Formule=O106
11.29625G163
Formule=AVERAGE(C163:F163)
2.6225H163
Formule=G163-$G$161
10.585I16310.98J16312.42K16311.2L163NPK0 C2N16352.925O163
Formule=I163*10000/2/1000
54.9P163
Formule=J163*10000/2/1000
62.1Q163
Formule=K163*10000/2/1000
56R163
Formule=L163*10000/2/1000
57.66666667S163
Formule=AVERAGE(P163:R163)
16.30833333T163
Formule=S163-$S$161
139.4317953U163
Formule=S163/$S$161*100
Ligne 1Y1634.0Z163173.475AA16343.36875AB16379.45473958333362AC163
2.0A164NPKB16414.565C164
Formule=O38
10.12D164
Formule=O44
11.295E164
Formule=O50
11.785F164
Formule=O56
11.94125G164
Formule=AVERAGE(C164:F164)
14.565000000000001I16410.120000000000001J16411.295K16411.785L164NPKN16472.825O164
Formule=I164*10000/2/1000
50.6P164
Formule=J164*10000/2/1000
56.475Q164
Formule=K164*10000/2/1000
58.925R164
Formule=L164*10000/2/1000
55.33333333S164
Formule=AVERAGE(P164:R164)
Ligne 2Y1644.0Z164194.225AA16448.55625AB16438.29098958333331AC164
5.0A165NPK C1B16514.36C165
Formule=O113
12.175D165
Formule=O119
9.45E165
Formule=O125
16.08F165
Formule=O131
13.01625G165
Formule=AVERAGE(C165:F165)
1.075H165
Formule=G165-$G$164
14.36I16512.174999999999999J1659.450000000000001K16516.08L165NPK C1N16571.8O165
Formule=I165*10000/2/1000
60.875P165
Formule=J165*10000/2/1000
47.25Q165
Formule=K165*10000/2/1000
80.4R165
Formule=L165*10000/2/1000
62.84166667S165
Formule=AVERAGE(P165:R165)
7.508333333T165
Formule=S165-$S$164
113.5692771U165
Formule=S165/$S$164*100
Ligne 3Y1654.0Z165225.925AA16556.48125AB16515.649739583333329AC165
6.0A166NPK C2B16613.74C166
Formule=O138
10.76D166
Formule=O144
12.595E166
Formule=O150
12.595F166
Formule=O156
12.4225G166
Formule=AVERAGE(C166:F166)
0.48125H166
Formule=G166-$G$164
13.739999999999998I16610.76J16612.594999999999999K16612.594999999999999L166NPK C2N16668.7O166
Formule=I166*10000/2/1000
53.8P166
Formule=J166*10000/2/1000
62.975Q166
Formule=K166*10000/2/1000
62.975R166
Formule=L166*10000/2/1000
59.91666667S166
Formule=AVERAGE(P166:R166)
4.583333333T166
Formule=S166-$S$164
108.2831325U166
Formule=S166/$S$164*100
Ligne 4Y1664.0Z166238.825AA16659.70625AB16688.6922395833335AC166
RS0.05N16713.081T167Ligne 5Y1674.0Z167260.325AA16765.08125AB167205.15057291666622AC167
Ligne 6Y1684.0Z168248.44999999999996AA16862.11249999999999AB16837.99354166666663AC168
N° de traitementA170Code de traitementB170Longueur des feuilles, cm (à la récolte, moyenne de 5 betteraves)C170MoyenneG170Par rapport à K, %H170Par rapport à K, cmI170N° de traitementL170Code de traitementM170Diamètre de la racine, cm (à la récolte, moyenne de 5 betteraves)N170MoyenneR170Par rapport à K, %S170Par rapport à K, cmU170
1.0A171NPK 0B17143.8C17137.2D17141.2E17138.2F17140.1G171
Formule=AVERAGE(C171:F171)
1.0L171NPK 0M1717.3N1716.1O1716.4P1717.4Q1716.8R171
Formule=AVERAGE(N171:Q171)
ANOVAY171
3.0A172NPK0 C1B17242.2C17244.0D17246.4E17247.0F17244.9G172
Formule=AVERAGE(C172:F172)
111.9700748H172
Formule=G172/$G$171*100
4.8I172
Formule=G172-$G$171
3.0L172NPK0 C1M1727.4N1727.8O1727.8P1727.0Q1727.5R172
Formule=AVERAGE(N172:Q172)
110.2941176S172
Formule=R172/$R$171*100
0.7U172
Formule=R172-$R$171
Source de variationY172SS (somme des carrés)Z172df (degrés de liberté)AA172MS (carré moyen)AB172FAC172Valeur de PAD172F critiqueAE172
4.0A173NPK0 C2B17341.4C17344.4D17340.2E17342.0F17342G173
Formule=AVERAGE(C173:F173)
104.7381546H173
Formule=G173/$G$171*100
1.9I173
Formule=G173-$G$171
4.0L173NPK0 C2M1737.1N1736.8O1737.0P1736.7Q1736.9R173
Formule=AVERAGE(N173:Q173)
101.4705882S173
Formule=R173/$R$171*100
0.1U173
Formule=R173-$R$171
Entre les groupesY1731394.7092968750005Z1735.0AA173278.9418593750001AB1733.597456308464499AC1730.019754897640893988AD1732.77285315299783AE1734.4028013AF173
Formule=SQRT(AB174/4)
2.0A174NPKB17441.0C17444.2D17439.4E17441.6F17441.55G174
Formule=AVERAGE(C174:F174)
2.0L174NPKM1747.0N1747.0O1746.6P1747.1Q1746.925R174
Formule=AVERAGE(N174:Q174)
Au sein des groupesY1741395.6954687499995Z17418.0AA17477.53863715277775AB174
5.0A175NPK C1B17546.6C17547.4D17543.0E17547.2F17546.05G175
Formule=AVERAGE(C175:F175)
110.8303249H175
Formule=G175/$G$174*100
4.5I175
Formule=G175-$G$174
5.0L175NPK C1M1757.5N1757.5O1757.4P1757.6Q1757.5R175
Formule=AVERAGE(N175:Q175)
108.3032491S175
Formule=R175/$R$174*100
0.575U175
Formule=R175-$R$174
6.226501311AF175
Formule=SQRT(2)*AF173
6.0A176NPK C2B17642.6C17646.2D17645.4E17648.6F17645.7G176
Formule=AVERAGE(C176:F176)
109.9879663H176
Formule=G176/$G$174*100
4.15I176
Formule=G176-$G$174
6.0L176NPK C2M1767.1N1767.9O1767.7P1768.3Q1767.75R176
Formule=AVERAGE(N176:Q176)
111.9133574S176
Formule=R176/$R$174*100
0.825U176
Formule=R176-$R$174
TotalY1762790.404765625Z17623.0AA17613.08139384AF176
Formule=TINV(0.05,AA174)*AF175
Écart par rapport à la moyenneH1773.397I177Écart par rapport à la moyenneT1770.577U177
Anova: Facteur uniqueX178
N° de traitementA180Code de traitementB180Masse des feuilles, kg (à la récolte, moyenne de 5 betteraves)C180MoyenneG180Par rapport à K, %H180Par rapport à K, kgI180N° de traitementL180Code de traitementM180Brix, % (à la récolte, moyenne de 5 betteraves)N180MoyenneR180Par rapport à K, %S180%U180RésuméX180
1.0A181NPK 0B1810.097C1810.062D1810.07500000000000001E1810.071F1810.07625G181
Formule=AVERAGE(C181:F181)
1.0L181NPK 0M1819.1N18110.3O18110.6P18110.8Q18110.2R181
Formule=AVERAGE(N181:Q181)
GroupesX181NombreY181SommeZ181MoyenneAA181VarianceAB181
3.0A182NPK0 C1B1820.092C1820.07400000000000001D1820.076E1820.095F1820.08425G182
Formule=AVERAGE(C182:F182)
110.4918033H182
Formule=G182/$G$181*100
0.008I182
Formule=G182-$G$181
3.0L182NPK0 C1M18210.7N18211.2O18210.7P18211.7Q18211.075R182
Formule=AVERAGE(N182:Q182)
108.5784314S182
Formule=R182/$R$181*100
0.875U182
Formule=R182-$R$181
Ligne 1X1824.0Y182160.4Z18240.1AA1828.97333333333332AB182
4.0A183NPK0 C2B1830.122C1830.31899999999999995D1830.099E1830.12400000000000003F1830.166G183
Formule=AVERAGE(C183:F183)
217.704918H183
Formule=G183/$G$181*100
0.08975I183
Formule=G183-$G$181
4.0L183NPK0 C2M18312.0N18311.1O18310.9P1838.8Q18310.7R183
Formule=AVERAGE(N183:Q183)
104.9019608S183
Formule=R183/$R$181*100
0.5U183
Formule=R183-$R$181
Ligne 2X1834.0Y183179.6Z18344.9AA1834.919999999999994AB183
2.0A184NPKB1840.085C1840.10600000000000001D1840.07899999999999999E1840.081F1840.08775G184
Formule=AVERAGE(C184:F184)
2.0L184NPKM18411.0N18410.8O18412.1P18412.6Q18411.625R184
Formule=AVERAGE(N184:Q184)
Ligne 3X1844.0Y184168.0Z18442.0AA1843.119999999999995AB184
5.0A185NPK C1B1850.11099999999999999C1850.10699999999999998D1850.11100000000000002E1850.119F1850.112G185
Formule=AVERAGE(C185:F185)
127.6353276H185
Formule=G185/$G$184*100
0.02425I185
Formule=G185-$G$184
5.0L185NPK C1M18512.5N18512.0O18511.6P18511.5Q18511.9R185
Formule=AVERAGE(N185:Q185)
102.3655914S185
Formule=R185/$R$184*100
0.275U185
Formule=R185-$R$184
Ligne 4X1854.0Y185166.2Z18541.55AA1853.983333333333341AB185
6.0A186NPK C2B1860.10699999999999998C1860.127D1860.14600000000000002E1860.137F1860.12925G186
Formule=AVERAGE(C186:F186)
147.2934473H186
Formule=G186/$G$184*100
0.0415I186
Formule=G186-$G$184
6.0L186NPK C2M18611.0N18611.0O18612.3P18611.5Q18611.45R186
Formule=AVERAGE(N186:Q186)
98.49462366S186
Formule=R186/$R$184*100
-0.175U186
Formule=R186-$R$184
Ligne 5X1864.0Y186184.2Z18646.05AA1864.250000000000001AB186
Écart par rapport à la moyenneH1870.065I187Écart par rapport à la moyenneT1871.209U187Ligne 6X1874.0Y187182.8Z18745.7AA1876.120000000000001AB187
N° de traitementA189Code de traitementB189Masse des racines, kg (à la récolte, moyenne de 5 betteraves)C189MoyenneG189Par rapport à K, %H189Par rapport à K, kgI189
1.0A190NPK 0B1900.20099999999999998C1900.16D1900.156E1900.219F1900.184G190
Formule=AVERAGE(C190:F190)
ANOVAX190
3.0A191NPK0 C1B1910.22400000000000003C1910.211D1910.21200000000000002E1910.215F1910.2155G191
Formule=AVERAGE(C191:F191)
117.1195652H191
Formule=G191/$G$190*100
0.0315I191
Formule=G191-$G$190
Source de variationX191SS (somme des carrés)Y191df (degrés de liberté)Z191MS (carré moyen)AA191FAB191Valeur de PAC191F critiqueAD191
4.0A192NPK0 C2B1920.254C1920.252D1920.257E1920.242F1920.25125G192
Formule=AVERAGE(C192:F192)
136.548913H192
Formule=G192/$G$190*100
0.06725I192
Formule=G192-$G$190
Entre les groupesX192123.33333333333333Y1925.0Z19224.666666666666664AA1924.7183846971307135AB1920.0062760657457942AC1922.77285315299783AD1921.143216709AE192
Formule=SQRT(AA193/4)
2.0A193NPKB1930.22800000000000004C1930.203D1930.20800000000000002E1930.198F1930.20925G193
Formule=AVERAGE(C193:F193)
Au sein des groupesX19394.09999999999995Y19318.0Z1935.227777777777775AA193
5.0A194NPK C1B1940.29900000000000004C1940.281D1940.257E1940.29800000000000004F1940.28375G194
Formule=AVERAGE(C194:F194)
135.6033453H194
Formule=G194/$G$193*100
0.0745I194
Formule=G194-$G$193
1.616752575AE194
Formule=SQRT(2)*AE192
6.0A195NPK C2B1950.253C1950.321D1950.28400000000000003E1950.35500000000000004F1950.30325G195
Formule=AVERAGE(C195:F195)
144.9223417H195
Formule=G195/$G$193*100
0.094I195
Formule=G195-$G$193
TotalX195217.43333333333328Y19523.0Z1953.396671119AE195
Formule=TINV(0.05,Z193)*AE194
Écart par rapport à la moyenneH1960.036I196
Anova: Facteur uniqueX197
TA-28/25, 30.05.2025B199RésuméX199
Numéro d'identification attribué par le clientB200Paramètre et méthode d’essaiC200GroupesX200NombreY200SommeZ200MoyenneAA200VarianceAB200
*pH (LVS ISO 10390:2022) en solution KCl, c = 1 mol/lC201Matière organique, % (procédure du ministère de l’Agriculture n° 1 du 4 janvier 2022, annexe 5, méthode 1)D201Phosphore extractible P2O5, mg/kg (méthode Egner–Riehm)E201Potassium extractible K2O, mg/kg (méthode Egner–Riehm)F201Ligne 1X2014.0Y2010.305Z2010.07625AA2010.00022091666666666787AB201
BetteraveB2025.27C2022.52D202238.75E202369.5F202Ligne 2X2024.0Y2020.33699999999999997Z2020.08424999999999999AA2020.00011625000000000292AB202
Ligne 3X2034.0Y2030.6639999999999999Z2030.16599999999999998AA2030.010532666666666657AB203
Ligne 4X2044.0Y2040.35100000000000003Z2040.08775000000000001AA2040.00015424999999999814AB204
GrandesC205Calibre moyenF205PetitI205Ligne 5X2054.0Y2050.44799999999999995Z2050.11199999999999999AA2052.533333333333336e-05AB205
unitésC206kgD206% du nombre totalE206unitésF206kgG206% du nombre totalH206unitésI206kgJ206% du nombre totalK206Nombre total, unitésL206Total kgM206Ligne 6X2064.0Y2060.517Z2060.12925AA2060.00028025000000000505AB206
1.0A207NPK 0B2071.875C2070.7293750000000001D2073.87596899224806E20719.625F2072.784375G20740.56847545219638H20726.875I2070.823125J20755.55555555555556K20748.375L2074.336875M207
3.0A208NPK0 C1B2081.375C2080.679375D2082.7027027027027026E20820.875F2083.14875G20841.03194103194103H20828.625I2081.0275J20856.26535626535627K20850.875L2084.855625M208
4.0A209NPK0 C2B2092.0C2090.9125D2093.644646924829157E20922.375F2093.59125G20940.77448747152619H20930.5I2091.144375J20955.58086560364465K20954.875L2095.648125M209ANOVAX209
2.0A210NPKB2103.0C2101.435D2105.896805896805897E21024.0F2103.9037500000000005G21047.174447174447174H21023.875I2100.631875J21046.928746928746925K21050.875L2105.970625000000001M210Source de variationX210SS (somme des carrés)Y210df (degrés de liberté)Z210MS (carré moyen)AA210FAB210Valeur de PAC210F critiqueAD210
5.0A211NPK C1B2113.75C2112.16125D2118.264462809917356E21119.625F2113.6468749999999996G21143.25068870523416H21122.0I2110.7J21148.484848484848484K21145.375L2116.508125M211Entre les groupesX2110.023217499999999995Y2115.0Z2110.004643499999999999AA2112.4591191267763106AB2110.07258289240782158AC2112.77285315299783AD2110.02172715914AE211
Formule=SQRT(AA212/4)
6.0A212NPK C2B2122.4C2121.1835D2124.7928107838242635E21221.3F2123.4150000000000005G21242.53619570644034H21226.375I2120.865375J21252.670993509735396K21250.075L2125.463875000000001M212Au sein des groupesX2120.033988999999999985Y21218.0Z2120.001888277777777777AA212
0.03072684313AE213
Formule=SQRT(2)*AE211
TotalX2140.05720649999999998Y21423.0Z2140.06455470196AE214
Formule=TINV(0.05,Z212)*AE213
Anova: Facteur uniqueX216
RésuméX218
GroupesX219NombreY219SommeZ219MoyenneAA219VarianceAB219
Ligne 1X2204.0Y2200.736Z2200.184AA2200.0009579999999999959AB220
Ligne 2X2214.0Y2210.862Z2210.2155AA2213.500000000000015e-05AB221
Ligne 3X2224.0Y2221.005Z2220.25125AA2224.225000000000008e-05AB222
Ligne 4X2234.0Y2230.837Z2230.20925AA2230.000172916666666667AB223
Ligne 5X2244.0Y2241.1350000000000002Z2240.28375000000000006AA2240.00038625000000000074AB224
Ligne 6X2254.0Y2251.213Z2250.30325AA2250.001962916666666666AB225
ANOVAX228
Source de variationX229SS (somme des carrés)Y229df (degrés de liberté)Z229MS (carré moyen)AA229FAB229Valeur de PAC229F critiqueAD229
Entre les groupesX2300.042859333333333346Y2305.0Z2300.008571866666666669AA23014.457796101949022AB2309.122691996504591e-06AC2302.77285315299783AD2300.01217465491AE230
Formule=SQRT(AA231/4)
Au sein des groupesX2310.010672000000000006Y23118.0Z2310.0005928888888888892AA231
0.01721756209AE232
Formule=SQRT(2)*AE230
TotalX2330.053531333333333354Y23323.0Z2330.03617275568AE233
Formule=TINV(0.05,Z231)*AE232
Anova: Facteur uniqueX236
RésuméX238
GroupesX239NombreY239SommeZ239MoyenneAA239VarianceAB239
Ligne 1X2404.0Y24027.199999999999996Z2406.799999999999999AA2400.42000000000000015AB240
Ligne 2X2414.0Y24130.0Z2417.5AA2410.14666666666666658AB241
Ligne 3X2424.0Y24227.599999999999998Z2426.8999999999999995AA2420.03333333333333328AB242
Ligne 4X2434.0Y24327.700000000000003Z2436.925000000000001AA2430.0491666666666667AB243
Ligne 5X2444.0Y24430.0Z2447.5AA2440.006666666666666619AB244
Ligne 6X2454.0Y24531.0Z2457.75AA2450.25000000000000044AB245
ANOVAX248
Source de variationX249SS (somme des carrés)Y249df (degrés de liberté)Z249MS (carré moyen)AA249FAB249Valeur de PAC249F critiqueAD249
Entre les groupesX2503.212083333333333Y2505.0Z2500.6424166666666666AA2504.255197792088315AB2500.009926178291078318AC2502.77285315299783AD2500.1942757204AE250
Formule=SQRT(AA251/4)
Au sein des groupesX2512.717500000000001Y25118.0Z2510.15097222222222229AA251
0.2747473587AE252
Formule=SQRT(2)*AE250
TotalX2535.929583333333334Y25323.0Z2530.5772227814AE253
Formule=TINV(0.05,Z251)*AE252
Anova: Facteur uniqueV255
RésuméV257
GroupesV258NombreX258SommeY258MoyenneZ258VarianceAA258
Ligne 1V2594.0X25940.8Y25910.2Z2590.5800000000000005AA259
Ligne 2V2604.0X26044.3Y26011.075Z2600.22916666666666666AA260
Ligne 3V2614.0X26142.8Y26110.7Z2611.8333333333333524AA261
Ligne 4V2624.0X26246.5Y26211.625Z2620.749166666666666AA262
Ligne 5V2634.0X26347.6Y26311.9Z2630.20666666666666675AA263
Ligne 6V2644.0X26445.8Y26411.45Z2640.3766666666666671AA264
ANOVAV267
Source de variationV268SS (somme des carrés)X268df (degrés de liberté)Y268MS (carré moyen)Z268FAA268Valeur de PAB268F critiqueAC268
Entre les groupesV2697.953333333333331X2695.0Y2691.5906666666666662Z2692.4010062893081754AA2690.07785755194524464AB2692.77285315299783AC2690.4069705149AD269
Formule=SQRT(Z270/4)
Au sein des groupesV27011.924999999999999X27018.0Y2700.6625Z270
0.5755432217AD271
Formule=SQRT(2)*AD269
TotalV27219.87833333333333X27223.0Y2721.209171439AD272
Formule=TINV(0.05,Y270)*AD271

Feuille de calcul: laitue

Tableau 2
SerreB1
Planté le 7.08.2025.B2
Récolte de biomasse fraîche et lavage des racinesB306.09.2025./09.09.2025.F3
Mesures et observations, laitueB5
PlantesB6Code de traitementC6Biomasse fraîche par plante, gD6Matière sèche par plante, % (Règlement du Cabinet n° 518)E6Longueur des feuilles, cmF6Nombre de feuillesG6Diamètre du collet, mmH6Longueur des racines, cmI6Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)J6Cellulose brute dans la matière sèche, % (ISO 5498:1981)K6Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)L6Calcium dans la matière sèche, % (GOST 26570-95)M6Magnésium dans la matière sèche, % (GOST 26570-95)N6
1.0B7K 1C71.05D714.29E75.0F75.0G70.25H711.0I7
2.0B8K 2C81.37D815.33E85.0F85.0G80.2H89.0I8
3.0B9K 3C90.62D911.29E94.0F95.0G90.2H915.0I9
4.0B10K 4C101.02D1010.78E104.0F105.0G100.2H1014.0I10
5.0B11K 5C111.48D1112.84E114.5F115.0G110.2H1111.5I11
6.0B12K 6C121.46D1214.38E124.5F125.0G120.25H1210.5I12
7.0B13K 7C131.52D139.21E134.5F136.0G130.25H1314.0I13
8.0B14K 8C140.82D1413.41E144.0F145.0G140.2H1411.5I14
9.0B15K 9C151.46D1514.38E154.5F155.0G150.25H1517.0I15
10.0B16K 10C160.94D1615.96E164.0F165.0G160.2H1614.5I16
MoyenneC171.174D17
Formule=AVERAGE(D7:D16)
13.187E17
Formule=AVERAGE(E7:E16)
4.4F17
Formule=AVERAGE(F7:F16)
5.1G17
Formule=AVERAGE(G7:G16)
0.22H17
Formule=AVERAGE(H7:H16)
12.8I17
Formule=AVERAGE(I7:I16)
15.74J17aucunK173.42L171.32M170.23N17
21.0B18C1 1C180.94D1812.77E184.0F184.0G180.2H1810.5I18
22.0B19C1 2C191.42D1915.49E194.5F195.0G190.25H199.0I19
23.0B20C1 3C201.47D2012.93E204.5F205.0G200.2H209.5I20
24.0B21C1 4C211.79D2112.29E214.5F216.0G210.25H2113.0I21
25.0B22C1 5C221.04D2213.46E224.0F224.0G220.2H226.0I22
26.0B23C1 6C231.92D2312.5E235.0F236.0G230.2H2314.5I23
27.0B24C1 7C241.36D2413.97E245.0F245.0G240.2H2412.0I24
28.0B25C1 8C251.45D2513.79E255.0F255.0G250.25H259.0I25
29.0B26C1 9C260.72D2618.06E264.0F264.0G260.15H2617.0I26
30.0B27C1 10C271.38D2715.94E275.0F275.0G270.2H2715.5I27
MoyenneC281.349D28
Formule=AVERAGE(D18:D27)
14.12E28
Formule=AVERAGE(E18:E27)
4.55F28
Formule=AVERAGE(F18:F27)
4.9G28
Formule=AVERAGE(G18:G27)
0.21H28
Formule=AVERAGE(H18:H27)
11.6I28
Formule=AVERAGE(I18:I27)
14.93J28aucunK282.98L281.32M280.3N28
31.0B29C2 1C290.83D2915.66E294.0F294.0G290.1H2916.0I29
32.0B30C2 2C301.81D3013.81E305.0F305.0G300.25H3015.5I30
33.0B31C2 3C311.07D3115.89E314.5F315.0G310.2H3112.0I31
34.0B32C2 4C320.62D3216.13E323.5F324.0G320.2H3216.5I32
35.0B33C2 5C331.05D338.57E334.0F335.0G330.2H3317.0I33
36.0B34C2 6C342.31D3411.69E345.0F347.0G340.25H3418.0I34
37.0B35C2 7C351.4D3510.0E355.0F355.0G350.2H3513.0I35
38.0B36C2 8C361.68D3613.69E365.0F366.0G360.25H3613.5I36
39.0B37C2 9C370.61D3713.11E373.5F374.0G370.15H3713.0I37
40.0B38C2 10C382.25D3813.33E385.0F386.0G380.3H3812.0I38
MoyenneC391.363D39
Formule=AVERAGE(D29:D38)
13.188E39
Formule=AVERAGE(E29:E38)
4.45F39
Formule=AVERAGE(F29:F38)
5.1G39
Formule=AVERAGE(G29:G38)
0.21H39
Formule=AVERAGE(H29:H38)
14.65I39
Formule=AVERAGE(I29:I38)
16.12J39aucunK393.21L391.28M390.31N39
11.0B40NPK 1C4063.95D405.29E4017.0F4012.0G401.05H4016.5I40
12.0B41NPK 2C4187.26D414.88E4120.0F4112.0G411.1H4118.5I41
13.0B42NPK 3C4262.06D425.95E4216.0F4212.0G420.85H4219.5I42
14.0B43NPK 4C4363.65D435.69E4317.0F4311.0G430.95H4325.5I43
15.0B44NPK 5C4461.11D445.79E4416.5F4411.0G441.0H4426.5I44
16.0B45NPK 6C4567.11D455.08E4519.0F4512.0G450.9H4520.5I45
17.0B46NPK 7C4676.96D465.57E4620.0F4611.0G461.1H4620.0I46
18.0B47NPK 8C4771.7D474.97E4720.5F4713.0G471.4H4718.0I47
19.0B48NPK 9C4870.16D485.4E4818.5F4811.0G481.0H4821.0I48
20.0B49NPK 10C4978.12D495.85E4920.0F4912.0G491.0H4922.0I49
MoyenneC5070.208D50
Formule=AVERAGE(D40:D49)
5.447E50
Formule=AVERAGE(E40:E49)
18.45F50
Formule=AVERAGE(F40:F49)
11.7G50
Formule=AVERAGE(G40:G49)
1.035H50
Formule=AVERAGE(H40:H49)
20.8I50
Formule=AVERAGE(I40:I49)
37.39J5012.79K507.7L500.52M500.68N50
41.0B51NPK C1 1C5161.68D514.96E5118.0F5111.0G510.8H5114.0I51
42.0B52NPK C1 2C5266.91D524.71E5220.0F5212.0G521.1H5215.0I52
43.0B53NPK C1 3C5359.22D535.15E5317.5F5311.0G530.9H5318.0I53
44.0B54NPK C1 4C5460.12D545.84E5416.5F5412.0G541.05H5421.5I54
45.0B55NPK C1 5C5563.56D555.66E5517.0F5513.0G550.95H5522.0I55
46.0B56NPK C1 6C5665.75D564.97E5618.0F5611.0G560.9H5618.0I56
47.0B57NPK C1 7C5766.28D575.13E5718.0F5713.0G570.95H5719.0I57
48.0B58NPK C1 8C5876.33D584.95E5819.5F5812.0G581.0H5815.0I58
49.0B59NPK C1 9C5969.52D595.58E5918.0F5912.0G591.2H5921.5I59
50.0B60NPK C1 10C6061.31D605.48E6018.0F6013.0G601.0H6017.5I60
MoyenneC6165.068D61
Formule=AVERAGE(D51:D60)
5.243E61
Formule=AVERAGE(E51:E60)
18.05F61
Formule=AVERAGE(F51:F60)
12G61
Formule=AVERAGE(G51:G60)
0.985H61
Formule=AVERAGE(H51:H60)
18.15I61
Formule=AVERAGE(I51:I60)
39.59J6112.57K617.27L610.45M610.74N61
51.0B62NPK C2 1C6292.36D624.09E6222.0F6213.0G621.2H6223.0I62
52.0B63NPK C2 2C6374.22D634.81E6320.0F6313.0G630.9H6320.0I63
53.0B64NPK C2 3C6478.46D645.25E6418.0F6412.0G640.95H6422.0I64
54.0B65NPK C2 4C6568.92D654.88E6519.5F6512.0G650.9H6520.0I65
55.0B66NPK C2 5C6665.44D664.86E6621.5F6613.0G660.75H6615.0I66
56.0B67NPK C2 6C6776.69D675.74E6722.0F6713.0G671.0H6722.0I67
57.0B68NPK C2 7C6866.53D685.13E6819.5F6811.0G680.9H6822.0I68
58.0B69NPK C2 8C6984.74D695.39E6921.5F6912.0G691.0H6920.0I69
59.0B70NPK C2 9C7071.04D704.8E7019.0F7012.0G700.85H7019.5I70
60.0B71NPK C2 10C7195.67D715.15E7121.5F7114.0G711.1H7123.0I71
MoyenneC7277.407D72
Formule=AVERAGE(D62:D71)
5.01E72
Formule=AVERAGE(E62:E71)
20.45F72
Formule=AVERAGE(F62:F71)
12.5G72
Formule=AVERAGE(G62:G71)
0.955H72
Formule=AVERAGE(H62:H71)
20.65I72
Formule=AVERAGE(I62:I71)
36.64J7212.96K727.92L720.6M720.79N72
Données moyennes, laitueC74
Code de traitementC75Biomasse fraîche par plante, gD75% par rapport à KE75Matière sèche par plante, % (Règlement du Cabinet n° 518)F75% par rapport à KG75Longueur des feuilles, cmH75Nombre de feuillesI75Diamètre du collet, mmJ75% par rapport à KK75Longueur des racines, cm (tourbe difficile à éliminer par lavage)L75% par rapport à KM75Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)N75% par rapport à KO75Cellulose brute dans la matière sèche, % (ISO 5498:1981)P75Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)Q75Calcium dans la matière sèche, % (GOST 26570-95)R75Magnésium dans la matière sèche, % (GOST 26570-95)S75
KC761.174D7613.187000000000001F764.4H765.1I760.22000000000000003J7612.8L7615.74N76aucunP763.42Q761.32R760.23S76
C1C771.35D77114.9914821E77
Formule=D77/$D$76*100
14.12F77107.0751498G77
Formule=F77/$F$76*100
4.55H774.9I770.21000000000000002J7795.45454545K77
Formule=J77/$J$76*100
11.6L7790.625M77
Formule=L77/$L$76*100
14.93N7794.85387548O77
Formule=N77/$N$76*100
aucunP772.98Q771.32R770.3S77
C2C781.363D78116.0988075E78
Formule=D78/$D$76*100
13.187999999999999F78100.0075832G78
Formule=F78/$F$76*100
4.45H785.1I780.20999999999999996J7895.45454545K78
Formule=J78/$J$76*100
14.65L78114.453125M78
Formule=L78/$L$76*100
16.12N78102.4142313O78
Formule=N78/$N$76*100
aucunP783.21Q781.28R780.31S78
NPKC7970.208D795.447F7918.45H7911.7I791.0350000000000001J7920.8L7937.39N7912.79P797.7Q790.52R790.68S79
NPK C1C8065.06800000000001D8092.67889699E80
Formule=D80/$D$79*100
5.243F8096.25481917G80
Formule=F80/$F$79*100
18.05H8012.0I800.9850000000000001J8095.16908213K80
Formule=J80/$J$79*100
18.15L8087.25961538M80
Formule=L80/$L$79*100
39.59N80105.8839262O80
Formule=N80/$N$79*100
12.57P807.27Q800.45R800.74S80
NPK C2C8177.407D81110.2538172E81
Formule=D81/$D$79*100
5.01F8191.97723518G81
Formule=F81/$F$79*100
20.45H8112.5I810.9549999999999998J8192.2705314K81
Formule=J81/$J$79*100
20.65L8199.27884615M81
Formule=L81/$L$79*100
36.64N8197.99411607O81
Formule=N81/$N$79*100
12.96P817.92Q810.6R810.79S81
Rapport d'essaiB83TN-103/25E8307.10.25.F83
LaitueB84
Numéro d'identification attribué par le clientB85Paramètre et méthode d’essaiC85
Matière sèche, % (Règlement du Cabinet n° 518)C86Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)D86Cellulose brute dans la matière sèche, % (ISO 5498:1981)E86Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)F86Calcium dans la matière sèche, % (GOST 26570-95)G86Magnésium dans la matière sèche, % (GOST 26570-95)H86
K 1B8714.29C8715.74D87-E873.42F871.32G870.23H87
K 2B8815.33C88
K 3B8911.29C89
K 4B9010.78C90
K 5B9112.84C91
K 6B9214.38C92
K 7B939.21C93
K 8B9413.41C94
K 9B9514.38C95
K 10B9615.96C96
NPK 1B975.29C9737.39D9712.79E977.7F970.52G970.68H97
NPK 2B984.88C98
NPK 3B995.95C99
NPK 4B1005.69C100
NPK 5B1015.79C101
NPK 6B1025.08C102
NPK 7B1035.57C103
NPK 8B1044.97C104
NPK 9B1055.4C105
NPK 10B1065.85C106
C1 1B10712.77C10714.93D107-E1072.98F1071.32G1070.3H107
C1 2B10815.49C108
C1 3B10912.93C109
C1 4B11012.29C110
C1 5B11113.46C111
C1 6B11212.5C112
C1 7B11313.97C113
C1 8B11413.79C114
C1 9B11518.06C115
C1 10B11615.94C116
C2 1B11715.66C11716.12D117-E1173.21F1171.28G1170.31H117
C2 2B11813.81C118
C2 3B11915.89C119
C2 4B12016.13C120
C2 5B1218.57C121
C2 6B12211.69C122
C2 7B12310.0C123
C2 8B12413.69C124
C2 9B12513.11C125
C2 10B12613.33C126
NPK C1 1B1274.96C12739.59D12712.57E1277.27F1270.45G1270.74H127
NPK C1 2B1284.71C128
NPK C1 3B1295.15C129
NPK C1 4B1305.84C130
NPK C1 5B1315.66C131
NPK C1 6B1324.97C132
NPK C1 7B1335.13C133
NPK C1 8B1344.95C134
NPK C1 9B1355.58C135
NPK C1 10B1365.48C136
NPK C2 1B1374.09C13736.64D13712.96E1377.92F1370.6G1370.79H137
NPK C2 2B1384.81C138
NPK C2 3B1395.25C139
NPK C2 4B1404.88C140
NPK C2 5B1414.86C141
NPK C2 6B1425.74C142
NPK C2 7B1435.13C143
NPK C2 8B1445.39C144
NPK C2 9B1454.8C145
NPK C2 10B1465.15C146

Feuille de calcul: Pommes de terre

Tableau 3
Champ de rotation – SKL 10B2
PlantéB323.05.2025.C3
RécoltéB425.-26.09.2025.C4
N° de traitementA5TraitementB5N° de parcelleC5Surface de la parcelle, m2G5Récolte par parcelle, kgK5TotalN5Récolte par parcelle, kgO5TotalR5Rendement par parcelle, kgS5TotalV5Rendement par parcelle, kgW5TotalZ5t ha-1AB5MoyenneAF5Par rapport à K, %AH5
1.0A6NPKB61 IC61 IID61 IIIE61 IVF616.5G6
Formule=11*1.5
14.55H6
Formule=9.7*1.5
14.85I6
Formule=9.9*1.5
14.4J6
Formule=9.6*1.5
28.76K624.44L619.54M672.74N6
Formule=SUM(K6:M6)
24.8O626.72P618.78Q670.3R6
Formule=SUM(O6:Q6)
24.04S624.46T618.68U667.18V6
Formule=SUM(S6:U6)
23.5W626.14X624.24Y673.88Z6
Formule=SUM(W6:Y6)
71.025AA6
Formule=SUM(Z6,V6,R6,N6)/4
44.08484848AB6
Formule=N6*10000/G6/1000
48.3161512AC6
Formule=R6*10000/H6/1000
45.23905724AD6
Formule=V6*10000/I6/1000
51.30555556AE6
Formule=Z6*10000/J6/1000
47.23640312AF6
Formule=AVERAGE(AB6:AE6)
2.0A7NPK C1B72 IC72 IID72 IIIE72 IVF715.75G7
Formule=10.5*1.5
14.55H7
Formule=9.7*1.5
14.85I7
Formule=9.9*1.5
14.4J7
Formule=9.6*1.5
22.64K722.58L730.66M775.88N7
Formule=SUM(K7:M7)
25.8O725.34P722.2Q773.34R7
Formule=SUM(O7:Q7)
24.02S725.74T721.26U771.02V7
Formule=SUM(S7:U7)
26.44W724.7X722.2Y773.34Z7
Formule=SUM(W7:Y7)
73.395AA7
Formule=SUM(Z7,V7,R7,N7)/4
48.17777778AB7
Formule=N7*10000/G7/1000
50.40549828AC7
Formule=R7*10000/H7/1000
47.82491582AD7
Formule=V7*10000/I7/1000
50.93055556AE7
Formule=Z7*10000/J7/1000
49.33468686AF7
Formule=AVERAGE(AB7:AE7)
104.4420904AH7
Formule=AF7/AF6*100
3.0A8NPK C2B83 IC83 IID83 IIIE83 IVF815.9G8
Formule=10.6*1.5
14.85H8
Formule=9.9*1.5
14.85I8
Formule=9.9*1.5
14.4J8
Formule=9.6*1.5
23.3K823.82L827.78M874.9N8
Formule=SUM(K8:M8)
24.18O821.94P828.86Q874.98R8
Formule=SUM(O8:Q8)
19.24S823.69T823.24U866.17V8
Formule=SUM(S8:U8)
23.66W824.14X822.06Y869.86Z8
Formule=SUM(W8:Y8)
71.4775AA8
Formule=SUM(Z8,V8,R8,N8)/4
47.10691824AB8
Formule=N8*10000/G8/1000
50.49158249AC8
Formule=R8*10000/H8/1000
44.55892256AD8
Formule=V8*10000/I8/1000
48.51388889AE8
Formule=Z8*10000/J8/1000
47.66782804AF8
Formule=AVERAGE(AB8:AE8)
100.9133314AH8
Formule=AF8/AF6*100
4.0A9NPK0B94 IC94 IID94 IIIE94 IVF915.75G9
Formule=10.5*1.5
15.3H9
Formule=10.2*1.5
14.85I9
Formule=9.9*1.5
14.4J9
Formule=9.6*1.5
23.68K923.76L915.0M962.44N9
Formule=SUM(K9:M9)
20.82O921.14P913.4Q955.36R9
Formule=SUM(O9:Q9)
22.08S924.88T946.96V9
Formule=SUM(S9:U9)
21.32W927.48X948.8Z9
Formule=SUM(W9:Y9)
53.39AA9
Formule=SUM(Z9,V9,R9,N9)/4
39.64444444AB9
Formule=N9*10000/G9/1000
36.18300654AC9
Formule=R9*10000/H9/1000
31.62289562AD9
Formule=V9*10000/I9/1000
33.88888889AE9
Formule=Z9*10000/J9/1000
35.33480887AF9
Formule=AVERAGE(AB9:AE9)
5.0A10NPK0 C1B105 IC105 IID105 IIIE105 IVF1015.6G10
Formule=10.4*1.5
15.3H10
Formule=10.2*1.5
14.85I10
Formule=9.9*1.5
14.4J10
Formule=9.6*1.5
25.56K1032.98L1058.54N10
Formule=SUM(K10:M10)
21.66O1019.16P1018.46Q1059.28R10
Formule=SUM(O10:Q10)
24.42S1025.06T1049.48V10
Formule=SUM(S10:U10)
23.78W1013.44X1017.34Y1054.56Z10
Formule=SUM(W10:Y10)
55.465AA10
Formule=SUM(Z10,V10,R10,N10)/4
37.52564103AB10
Formule=N10*10000/G10/1000
38.74509804AC10
Formule=R10*10000/H10/1000
33.31986532AD10
Formule=V10*10000/I10/1000
37.88888889AE10
Formule=Z10*10000/J10/1000
36.86987332AF10
Formule=AVERAGE(AB10:AE10)
104.3443406AH10
Formule=AF10/AF9*100
6.0A11NPK0 C2B116 IC116 IID116 IIIE116 IVF1115.6G11
Formule=10.4*1.5
15.15H11
Formule=10.1*1.5
14.85I11
Formule=9.9*1.5
14.4J11
Formule=9.6*1.5
19.78K1133.92L1153.7N11
Formule=SUM(K11:M11)
19.14O1127.18P1146.32R11
Formule=SUM(O11:Q11)
19.24S1125.22T1144.46V11
Formule=SUM(S11:U11)
23.94W1117.66X1141.6Z11
Formule=SUM(W11:Y11)
46.52AA11
Formule=SUM(Z11,V11,R11,N11)/4
34.42307692AB11
Formule=N11*10000/G11/1000
30.57425743AC11
Formule=R11*10000/H11/1000
29.93939394AD11
Formule=V11*10000/I11/1000
28.88888889AE11
Formule=Z11*10000/J11/1000
30.95640429AF11
Formule=AVERAGE(AB11:AE11)
87.60880639AH11
Formule=AF11/AF9*100
7.0A12NPK0 C3B127 IC127 IID127 IIIE127 IVF1215.75G12
Formule=10.5*1.5
15H12
Formule=10*1.5
14.85I12
Formule=9.9*1.5
14.4J12
Formule=9.6*1.5
25.5K1229.06L1254.56N12
Formule=SUM(K12:M12)
24.44O1226.66P1251.1R12
Formule=SUM(O12:Q12)
22.56S1223.84T1246.4V12
Formule=SUM(S12:U12)
22.74W1222.42X1245.16Z12
Formule=SUM(W12:Y12)
49.305AA12
Formule=SUM(Z12,V12,R12,N12)/4
34.64126984AB12
Formule=N12*10000/G12/1000
34.06666667AC12
Formule=R12*10000/H12/1000
31.24579125AD12
Formule=V12*10000/I12/1000
31.36111111AE12
Formule=Z12*10000/J12/1000
32.82870972AF12
Formule=AVERAGE(AB12:AE12)
92.90756272AH12
Formule=AF12/AF9*100
Analyse de 4 plants de pomme de terre (déterrés le 24.09.2025.)B13
TraitementB14ConsommationC14SemenceF14Récolte hors calibre / petits tuberculesI14EndommagésL14
Gros calibre (>80 g), diamètre >55 mmC15Part de la récolte, %D15Calibre moyen (40–80 g), diamètre 35–55 mmF15Part de la récolte, %G15Petit calibre (<40 g), diamètre 35 mmI15Part de la récolte, %J15Inclus dans la masse des petits tubercules au totalL15Part de la récolte, %M15TraitementP15Nombre total, unitésQ15Total, kgR15Fraction de tubercules commercialisablesS15Part de tubercules commercialisables dans la récolte, %T15Par rapport à la masse de K, %U15Masse moyenne d’un tubercule commercialisableV15
Masse, kgC16Nombre, unitésE16Masse, kgF16Nombre, unitésH16Masse, kgI16Nombre, unitésK16Masse, kgL16Nombre, unitésN16
NPKB170.57C179.018987342D17
Formule=C17/R17*100
2.0E172.58F1740.82278481G17
Formule=F17/R17*100
25.0H172.3I1736.39240506J17
Formule=I17/R17*100
13.0K170.87L1713.76582278M17
Formule=L17/R17*100
7.0N17NPKP1747Q17
Formule=E17+H17+K17+N17
6.32R17
Formule=C17+F17+I17+L17
3.15S17
Formule=C17+F17
49.84177215T17
Formule=S17/R17*100
0.1166666667V17
Formule=(C17+F17)/(E17+H17)
NPK C1B180.67C1817.3126615D18
Formule=C18/R18*100
4.0E181.24F1832.04134367G18
Formule=F18/R18*100
18.0H180.24I186.201550388J18
Formule=I18/R18*100
12.0K181.72L1844.44444444M18
Formule=L18/R18*100
19.0N18NPK C1P1853Q18
Formule=E18+H18+K18+N18
3.87R18
Formule=C18+F18+I18+L18
1.91S18
Formule=C18+F18
49.35400517T18
Formule=S18/R18*100
60.63492063U18
Formule=S18/S17*100
0.08681818182V18
Formule=(C18+F18)/(E18+H18)
NPK C2B191.22C1936.14814815D19
Formule=C19/R19*100
6.0E191.72F1950.96296296G19
Formule=F19/R19*100
22.0H190.13I193.851851852J19
Formule=I19/R19*100
8.0K190.305L199.037037037M19
Formule=L19/R19*100
4.0N19NPK C2P1940Q19
Formule=E19+H19+K19+N19
3.375R19
Formule=C19+F19+I19+L19
2.94S19
Formule=C19+F19
87.11111111T19
Formule=S19/R19*100
93.33333333U19
Formule=S19/S17*100
0.105V19
Formule=(C19+F19)/(E19+H19)
NPK0B203.11C2067.75599129D20
Formule=C20/R20*100
23.0E201.09F2023.74727669G20
Formule=F20/R20*100
19.0H200.215I204.684095861J20
Formule=I20/R20*100
16.0K200.175L203.812636166M20
Formule=L20/R20*100
1.0N20NPK0P2059Q20
Formule=E20+H20+K20+N20
4.59R20
Formule=C20+F20+I20+L20
4.2S20
Formule=C20+F20
91.50326797T20
Formule=S20/R20*100
0.1V20
Formule=(C20+F20)/(E20+H20)
NPK0 C1B212.23C2141.99623352D21
Formule=C21/R21*100
13.0E211.98F2137.28813559G21
Formule=F21/R21*100
24.0H210.09I211.694915254J21
Formule=I21/R21*100
6.0K211.01L2119.02071563M21
Formule=L21/R21*100
7.0N21NPK0 C1P2150Q21
Formule=E21+H21+K21+N21
5.31R21
Formule=C21+F21+I21+L21
4.21S21
Formule=C21+F21
79.28436911T21
Formule=S21/R21*100
100.2380952U21
Formule=S21/S20*100
0.1137837838V21
Formule=(C21+F21)/(E21+H21)
NPK0 C2B220.38C229.523809524D22
Formule=C22/R22*100
3.0E221.3F2232.58145363G22
Formule=F22/R22*100
17.0H220.135I223.383458647J22
Formule=I22/R22*100
8.0K222.175L2254.5112782M22
Formule=L22/R22*100
21.0N22NPK0 C2P2249Q22
Formule=E22+H22+K22+N22
3.99R22
Formule=C22+F22+I22+L22
1.68S22
Formule=C22+F22
42.10526316T22
Formule=S22/R22*100
40U22
Formule=S22/S20*100
0.084V22
Formule=(C22+F22)/(E22+H22)
NPK0 C3B230.705C2317.64705882D23
Formule=C23/R23*100
4.0E231.945F2348.68585732G23
Formule=F23/R23*100
23.0H230.27I236.75844806J23
Formule=I23/R23*100
13.0K231.075L2326.90863579M23
Formule=L23/R23*100
8.0N23NPK0 C3P2348Q23
Formule=E23+H23+K23+N23
3.995R23
Formule=C23+F23+I23+L23
2.65S23
Formule=C23+F23
66.33291615T23
Formule=S23/R23*100
63.0952381U23
Formule=S23/S20*100
0.09814814815V23
Formule=(C23+F23)/(E23+H23)
Rendement et qualité des pommes de terreB25Rendement de pommes de terre, t ha-1O25
TraitementB26Rendement, t ha-1C26Par rapport à K, t ha-1D26Par rapport à K, %E26Amidon dans le produit, %F26Amidon dans la matière sèche, %H26Rendement en amidon, t ha-1I26Par rapport à K, %J26Nombre moyen de plantesK26kg/parcelleL26Masse moyenne par plante, kgM26Par rapport à K, %N26IO26IIP26IIIQ26IVR26MoyenneS26Anova: Facteur uniqueU26
NPKB2747.23640312055261C2710.27F2763.93H274.8511786I27
Formule=F27*C27/100
37.875K2771.025L271.875247525M27
Formule=L27*1/K27
44.08484848484849O2748.31615120274914P2745.23905723905724Q2751.305555555555564R2747.23640312S27
Formule=AVERAGE(O27:R27)
NPK C1B2849.33468686000903C282.09828373945642D28104.4420904E28
Formule=C28/$C$27*100
12.86F28125.2190847G28
Formule=F28/$F$27*100
68.54H286.34444073I28
Formule=F28*C28/100
107.211012J28
Formule=H28/$H$27*100
35.625K2873.39500000000001L282.060210526M28
Formule=L28*1/K28
109.8633913N28
Formule=M28/$M$27*100
48.177777777777784O2850.40549828178695P2847.82491582491582Q2850.930555555555564R2849.33468686S28
Formule=AVERAGE(O28:R28)
RésuméU28
NPK C2B2947.66782804459691C290.43142492404430044D29100.9133314E29
Formule=C29/$C$27*100
14.72F29143.3300876G29
Formule=F29/$F$27*100
78.9H297.016704288I29
Formule=F29*C29/100
123.4162365J29
Formule=H29/$H$27*100
34.375K2971.47749999999999L292.079345455M29
Formule=L29*1/K29
110.8837861N29
Formule=M29/$M$27*100
47.106918238993714O2950.491582491582484P2944.55892255892255Q2948.51388888888889R2947.66782804S29
Formule=AVERAGE(O29:R29)
GroupesU29NombreV29SommeW29MoyenneX29VarianceY29
NPK0B3035.33480887304417C3012.72F3069.15H304.494587689I30
Formule=F30*C30/100
35.25K3053.39L301.514609929M30
Formule=L30*1/K30
39.644444444444446O3036.18300653594772P3031.622895622895616Q3033.88888888888889R3035.33480887S30
Formule=AVERAGE(O30:R30)
Ligne 1U304.0V30188.94561248221044W3047.23640312055261X3010.548514884150729Y30
NPK0 C1B3136.86987331840273C311.5350644453585645D31104.3443406E31
Formule=C31/$C$30*100
12.97F31101.9654088G31
Formule=F31/$F$30*100
76.9H314.782022569I31
Formule=F31*C31/100
111.2075199J31
Formule=H31/$H$30*100
35.375K3155.464999999999996L311.567915194M31
Formule=L31*1/K31
103.5194055N31
Formule=M31/$M$30*100
37.525641025641015O3138.74509803921569P3133.31986531986532Q3137.88888888888889R3136.86987332S31
Formule=AVERAGE(O31:R31)
Ligne 2U314.0V31197.33874744003612W3149.33468686000903X312.4370937324636692Y31
NPK0 C2B3230.95640429427558C32-4.378404578768588D3287.60880639E32
Formule=C32/$C$30*100
12.66F3299.52830189G32
Formule=F32/$F$30*100
75.03H323.919080784I32
Formule=F32*C32/100
108.5032538J32
Formule=H32/$H$30*100
35.875K3246.519999999999996L321.296724739M32
Formule=L32*1/K32
85.61443536N32
Formule=M32/$M$30*100
34.42307692307692O3230.574257425742577P3229.939393939393934Q3228.88888888888889R3230.95640429S32
Formule=AVERAGE(O32:R32)
Ligne 3U324.0V32190.67131217838764W3247.66782804459691X326.223107085997597Y32
NPK0 C3B3332.828709716209715C33-2.506099156834452D3392.90756272E33
Formule=C33/$C$30*100
12.78F33100.4716981G33
Formule=F33/$F$30*100
74.35H334.195509102I33
Formule=F33*C33/100
107.5198843J33
Formule=H33/$H$30*100
35.375K3349.305L331.393780919M33
Formule=L33*1/K33
92.02243376N33
Formule=M33/$M$30*100
34.641269841269846O3334.06666666666666P3331.245791245791242Q3331.36111111111111R3332.82870972S33
Formule=AVERAGE(O33:R33)
Ligne 4U334.0V33141.33923549217667W3335.33480887304417X3311.720460870280542Y33
RS0.05B343.76D34Écart par rapport à la moyenneR343.7603918150516047S34Ligne 5U344.0V34147.47949327361093W3436.86987331840273X345.862482853992472Y34
Ligne 6U354.0V35123.82561717710232W3530.95640429427558X355.824261785952586Y35
Pommes de terre, amidon, TN-127/25, 06.10.25.B36Ligne 7U364.0V36131.31483886483886W3632.828709716209715X363.1591293892739967Y36
Numéro d'identification attribué par le clientB37Paramètre et méthode d’essaiC37TraitementG37Rendement, t ha-1H37Par rapport à K, t ha-1I37Par rapport à K, %J37Nombre moyen de plantesK37kg/parcelleL37Masse moyenne par plante, kgM37Par rapport à K, %N37Rendement, t ha-1P37Par rapport à K, t ha-1Q37Par rapport à K, %R37
Humidité, % (ISO 6496:1999)C38Amidon, % (LVS EN ISO 10520:2001)D38NPKG3847.23640312055261H3837.875K3871.025L381.875247525M38
Formule=L38*1/K38
47.23640312055261P38
Dans le produit, %D39Dans la matière sèche, %E39NPK C1G3949.33468686000903H392.09828373945642I39104.4420904J39
Formule=H39/$C$27*100
35.625K3973.39500000000001L392.060210526M39
Formule=L39*1/K39
109.8633913N39
Formule=M39/$M$27*100
49.33468686000903P39ANOVAU39
NPKB4083.92C4010.27D4063.93E40NPK C2G4047.66782804459691H400.43142492404430044I40100.9133314J40
Formule=H40/$C$27*100
34.375K4071.47749999999999L402.079345455M40
Formule=L40*1/K40
110.8837861N40
Formule=M40/$M$27*100
47.66782804459691P40Source de variationU40SS (somme des carrés)V40df (degrés de liberté)W40MS (carré moyen)X40FY40Valeur de PZ40F critiqueAA40
NPK + Cito Humus C1B4181.22C4112.86D4168.54E41NPK0G4135.33480887304417H4135.25K4153.39L411.514609929M41
Formule=L41*1/K41
35.33480887304417P41Entre les groupesU411452.263007402201V416.0W41242.0438345670335X4137.01376229371282Y414.150722270436615e-10Z412.5727116405095254AA411.278602063AB41
Formule=SQRT(X42/4)
NPK + Cito Humus C2B4281.31C4214.72D4278.9E42NPK0 C1G4236.86987331840273H421.5350644453585645I42104.3443406J42
Formule=H42/$C$30*100
35.375K4255.464999999999996L421.567915194M42
Formule=L42*1/K42
103.5194055N42
Formule=M42/$M$30*100
36.86987331840273P4274.80419028R42
Formule=P41/P38*100
Au sein des groupesU42137.3251518063348V4221.0W426.5392929431588X42
Témoin NPK 0B4381.6C4312.72D4369.15E43NPK0 C2G4330.95640429427558H43-4.378404578768588I4387.60880639J43
Formule=H43/$C$30*100
35.875K4346.519999999999996L431.296724739M43
Formule=L43*1/K43
85.61443536N43
Formule=M43/$M$30*100
30.95640429427558P4374.73417927R43
Formule=P42/P39*100
1.808216379AB43
Formule=SQRT(2)*AB41
Cito Humus C1B4483.14C4412.97D4476.9E44NPK0 C3G4432.828709716209715H44-2.506099156834452I4492.90756272J44
Formule=H44/$C$30*100
35.375K4449.305L441.393780919M44
Formule=L44*1/K44
92.02243376N44
Formule=M44/$M$30*100
32.828709716209715P4464.94192323R44
Formule=P43/P40*100
TotalU441589.588159208536V4427.0W443.760391815AB44
Formule=TINV(0.05,W42)*AB43
Cito Humus C2B4583.08C4512.66D4575.03E45RS0.05G453.76I45
Cito Humus C3B4682.81C4612.78D4674.35E46

Feuille de calcul: Pois

Tableau 4
Pois 1 en substratB3Pois 2 en terreAB325.11.2025. AdriansAD3
PlantesB4Code de traitementC4Biomasse fraîche par plante, gD4Biomasse fraîche par pot, gJ4Biomasse fraîche moyenne par plante, gK4Calculé à partir du total du potL4Longueur des racines, cmM4MoyenneS4Matière sèche, % (Règlement du Cabinet n° 518)T4Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)U4Cellulose brute dans la matière sèche, % (ISO 5498:1981)V4Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)W4Phosphore dans la matière sèche, g/kg (ISO 6491:1998)X4NDF dans la matière sèche, % (LVS EN ISO 16472:2006)Y4ADF dans la matière sèche, % (ISO 13906:2008)Z4PlantesAB4Code de traitementAC4Biomasse fraîche par plante, gAD4Matière sèche, %AE4Longueur de la plante, cmAF4Nombre de vrilles, unitésAG4Longueur des racines, cmAH4Masse des racines, gAI4Matière sèche, %AJ4
1.0B5K 1C54.82D55.36E53.15F54.03G52.75H5aucunI520.06J54.022K5
Formule=AVERAGE(D5:I5)
20.11L5
Formule=SUM(D5:I5)
38.0M537.0N531.0O540.0P548.0Q533.0R537.83333333S5
Formule=AVERAGE(M5:R5)
28.19T51.0AB5KAC510.95AD518.26AE559.0AF515.0AG519.5AH510.15AI512.02AJ5OïdiumAK5
2.0B6K 2C63.91D63.45E62.73F63.6G63.82H63.4I620.85J63.485K6
Formule=AVERAGE(D6:I6)
20.91L6
Formule=SUM(D6:I6)
37.5M625.0N633.0O639.0P650.0Q629.0R635.58333333S6
Formule=AVERAGE(M6:R6)
25.97T62.0AB6KAC613.7AD617.01AE672.0AF616.0AG627.2AH66.81AI610.13AJ6OïdiumAK6
3.0B7K 3C72.95D71.26E72.65F73.01G74.18H74.05I718.03J73.016666667K7
Formule=AVERAGE(D7:I7)
18.1L7
Formule=SUM(D7:I7)
37.0M732.0N737.0O733.0P734.0Q725.0R733S7
Formule=AVERAGE(M7:R7)
26.85T73.0AB7KAC76.82AD716.86AE741.0AF715.0AG721.0AH75.57AI79.87AJ7OïdiumAK7
4.0B8K 4C82.54D83.84E83.65F83.12G82.99H83.04I819.1J83.196666667K8
Formule=AVERAGE(D8:I8)
19.18L8
Formule=SUM(D8:I8)
31.5M834.0N824.5O835.5P835.0Q833.0R832.25S8
Formule=AVERAGE(M8:R8)
25.55T84.0AB8KAC89.84AD820.43AE860.0AF815.0AG824.1AH88.17AI810.53AJ8
5.0B9K 5C92.69D93.15E94.31F93.45G93.2H92.88I919.3J93.28K9
Formule=AVERAGE(D9:I9)
19.68L9
Formule=SUM(D9:I9)
25.41T9MoyenneAC910.3275AD9
Formule=AVERAGE(AD5:AD8)
18.14AE9
Formule=AVERAGE(AE5:AE8)
58AF9
Formule=AVERAGE(AF5:AF8)
15.25AG9
Formule=AVERAGE(AG5:AG8)
22.95AH9
Formule=AVERAGE(AH5:AH8)
7.675AI9
Formule=AVERAGE(AI5:AI8)
10.6375AJ9
Formule=AVERAGE(AJ5:AJ8)
6.0B10K 6C103.44D103.44E103.21F104.14G103.75H102.01I1020.02J103.331666667K10
Formule=AVERAGE(D10:I10)
19.99L10
Formule=SUM(D10:I10)
27.53T101.0AB10C1AC1013.08AD1015.83AE1072.0AF1016.0AG1028.2AH107.28AI1010.99AJ10OïdiumAK10
7.0B11K 7C113.0D113.78E113.8F114.43G112.62H112.8I1120.4J113.405K11
Formule=AVERAGE(D11:I11)
20.43L11
Formule=SUM(D11:I11)
25.45T112.0AB11C1AC1111.85AD1118.65AE1165.5AF1116.0AG1118.0AH118.32AI1110.22AJ11OïdiumAK11
8.0B12K 8C121.55D120.98E123.91F123.48G121.95H121.96I1213.82J122.305K12
Formule=AVERAGE(D12:I12)
13.83L12
Formule=SUM(D12:I12)
24.73T123.0AB12C1AC1212.81AD1219.75AE1267.0AF1215.0AG1225.2AH129.17AI1212.1AJ12OïdiumAK12
9.0B13K 9C132.58D134.12E134.59F131.26G134.28H13aucunI1316.81J133.366K13
Formule=AVERAGE(D13:I13)
16.83L13
Formule=SUM(D13:I13)
23.95T134.0AB13C1AC1312.17AD1319.06AE1370.5AF1316.0AG1323.7AH137.81AI1311.65AJ13OïdiumAK13
10.0B14K 10C142.49D143.52E144.44F143.88G143.17H142.65I1420.1J143.358333333K14
Formule=AVERAGE(D14:I14)
20.15L14
Formule=SUM(D14:I14)
25.46T14MoyenneAC1412.4775AD14
Formule=AVERAGE(AD10:AD13)
18.3225AE14
Formule=AVERAGE(AE10:AE13)
68.75AF14
Formule=AVERAGE(AF10:AF13)
15.75AG14
Formule=AVERAGE(AG10:AG13)
23.775AH14
Formule=AVERAGE(AH10:AH13)
8.145AI14
Formule=AVERAGE(AI10:AI13)
11.24AJ14
Formule=AVERAGE(AJ10:AJ13)
MoyenneC1518.849J15
Formule=AVERAGE(J5:J14)
3.276633333K15
Formule=AVERAGE(K5:K14)
18.921L15
Formule=AVERAGE(L5:L14)
34.66666667S15
Formule=AVERAGE(S5:S14)
25.909T15
Formule=AVERAGE(T5:T14)
17.82U1530.99V151.97W151.59X1546.33Y1541.41Z151.0AB15C2AC1510.26AD1521.83AE1563.5AF1515.0AG1525.9AH157.05AI1511.49AJ15OïdiumAK15
21.0B16C1 1C163.37D162.49E163.27F163.44G164.0H163.25I1619.81J163.303333333K16
Formule=AVERAGE(D16:I16)
19.82L16
Formule=SUM(D16:I16)
29.0M1632.0N1639.0O1632.0P1629.0Q1634.0R1632.5S16
Formule=AVERAGE(M16:R16)
24.97T162.0AB16C2AC1610.25AD1623.12AE1667.0AF1615.0AG1622.4AH167.9AI1611.14AJ16OïdiumAK16
22.0B17C1 2C173.75D173.88E172.78F173.79G173.86H173.04I1721.07J176.024285714K17
Formule=AVERAGE(D17:J17)
21.1L17
Formule=SUM(D17:I17)
39.0M1740.0N1727.0O1740.0P1727.0Q1738.0R1735.16666667S17
Formule=AVERAGE(M17:R17)
25.83T173.0AB17C2AC1713.96AD1720.56AE1773.0AF1716.0AG1718.8AH1710.4AI1712.6AJ17OïdiumAK17
23.0B18C1 3C183.83D183.3E183.62F182.65G182.21H183.37I1818.92J185.414285714K18
Formule=AVERAGE(D18:J18)
18.98L18
Formule=SUM(D18:I18)
39.0M1835.0N1833.0O1836.0P1833.0Q1832.0R1834.66666667S18
Formule=AVERAGE(M18:R18)
26.37T184.0AB18C2AC1814.49AD1819.67AE1871.0AF1816.0AG1837.0AH1811.74AI1811.93AJ18OïdiumAK18
24.0B19C1 4C192.44D193.21E194.86F192.36G192.62H192.71I1918.2J195.2K19
Formule=AVERAGE(D19:J19)
18.2L19
Formule=SUM(D19:I19)
32.0M1942.0N1934.0O1932.0P1930.0Q1941.0R1935.16666667S19
Formule=AVERAGE(M19:R19)
25.66T19MoyenneAC1912.24AD19
Formule=AVERAGE(AD15:AD18)
21.295AE19
Formule=AVERAGE(AE15:AE18)
68.625AF19
Formule=AVERAGE(AF15:AF18)
15.5AG19
Formule=AVERAGE(AG15:AG18)
26.025AH19
Formule=AVERAGE(AH15:AH18)
9.2725AI19
Formule=AVERAGE(AI15:AI18)
11.79AJ19
Formule=AVERAGE(AJ15:AJ18)
25.0B20C1 5C203.63D202.55E201.95F203.75G203.96H203.41I2019.21J205.494285714K20
Formule=AVERAGE(D20:J20)
19.25L20
Formule=SUM(D20:I20)
27.12T201.0AB20N C1AC2012.2AD2017.3AE2065.8AF2016.0AG2022.5AH209.6AI2016.77AJ20
26.0B21C1 6C213.67D211.61E215.67F213.59G214.62H213.58I2122.68J216.488571429K21
Formule=AVERAGE(D21:J21)
22.74L21
Formule=SUM(D21:I21)
24.54T212.0AB21N C1AC2113.08AD2121.02AE2170.0AF2116.0AG2122.0AH2111.46AI2112.3AJ21
27.0B22C1 7C220.97D223.54E223.71F223.83G224.08H222.44I2218.56J225.304285714K22
Formule=AVERAGE(D22:J22)
18.57L22
Formule=SUM(D22:I22)
24.34T223.0AB22N C1AC2214.02AD2221.4AE2264.0AF2219.0AG2223.9AH228.41AI2211.77AJ22
28.0B23C1 8C234.59D234.96E234.33F233.79G233.29H23aucunI2320.87J236.971666667K23
Formule=AVERAGE(D23:J23)
20.96L23
Formule=SUM(D23:I23)
24.43T234.0AB23N C1AC2313.1AD2318.32AE2367.0AF2316.0AG2323.1AH237.33AI2312.55AJ23
29.0B24C1 9C240.36D243.76E244.13F243.77G244.88H244.14I2420.94J245.997142857K24
Formule=AVERAGE(D24:J24)
21.04L24
Formule=SUM(D24:I24)
23.57T24MoyenneAC2413.1AD24
Formule=AVERAGE(AD20:AD23)
19.51AE24
Formule=AVERAGE(AE20:AE23)
66.7AF24
Formule=AVERAGE(AF20:AF23)
16.75AG24
Formule=AVERAGE(AG20:AG23)
22.875AH24
Formule=AVERAGE(AH20:AH23)
9.2AI24
Formule=AVERAGE(AI20:AI23)
13.3475AJ24
Formule=AVERAGE(AJ20:AJ23)
30.0B25C1 10C252.82D253.62E253.84F252.65G252.48H252.72I2518.04J255.167142857K25
Formule=AVERAGE(D25:J25)
18.13L25
Formule=SUM(D25:I25)
24.43T251.0AB25N C2AC2514.85AD2517.04AE2563.4AF2517.0AG2527.0AH2515.16AI2519.13AJ25
MoyenneC2619.83J26
Formule=AVERAGE(J16:J25)
5.5365K26
Formule=AVERAGE(K16:K25)
19.879L26
Formule=AVERAGE(L16:L25)
34.375S26
Formule=AVERAGE(S16:S25)
25.126T26
Formule=AVERAGE(T16:T25)
25.04U2622.95V264.6W266.73X2638.41Y2631.4Z262.0AB26N C2AC2613.29AD2617.83AE2669.3AF2616.0AG2628.4AH2612.16AI2614.14AJ26
31.0B27C2 1C272.92D274.09E273.38F273.74G273.86H271.38I2719.36J273.228333333K27
Formule=AVERAGE(D27:I27)
19.37L27
Formule=SUM(D27:I27)
34.0M2740.0N2741.0O2745.0P2737.0Q2744.0R2740.16666667S27
Formule=AVERAGE(M27:R27)
26.07T273.0AB27N C2AC2712.41AD2714.34AE2772.6AF2714.0AG2725.3AH2710.29AI2714.29AJ27
32.0B28C2 2C284.18D282.02E282.56F282.58G283.64H283.56I2818.72J283.09K28
Formule=AVERAGE(D28:I28)
18.54L28
Formule=SUM(D28:I28)
32.0M2833.0N2835.0O2822.0P2831.0Q2827.0R2830S28
Formule=AVERAGE(M28:R28)
25.19T284.0AB28N C2AC2812.18AD2818.14AE2865.0AF2815.0AG2830.0AH286.61AI2817.7AJ28
33.0B29C2 3C292.95D291.14E294.29F292.49G293.67H292.67I2917.07J292.868333333K29
Formule=AVERAGE(D29:I29)
17.21L29
Formule=SUM(D29:I29)
37.0M2930.0N2937.0O2942.0P2934.0Q2932.0R2935.33333333S29
Formule=AVERAGE(M29:R29)
22.89T29MoyenneAC2913.1825AD29
Formule=AVERAGE(AD25:AD28)
16.8375AE29
Formule=AVERAGE(AE25:AE28)
67.575AF29
Formule=AVERAGE(AF25:AF28)
15.5AG29
Formule=AVERAGE(AG25:AG28)
27.675AH29
Formule=AVERAGE(AH25:AH28)
11.055AI29
Formule=AVERAGE(AI25:AI28)
16.315AJ29
Formule=AVERAGE(AJ25:AJ28)
34.0B30C2 4C303.48D303.53E304.09F302.21G303.58H302.67I3019.55J303.26K30
Formule=AVERAGE(D30:I30)
19.56L30
Formule=SUM(D30:I30)
40.0M3042.0N3040.0O3035.0P3039.0Q3033.0R3038.16666667S30
Formule=AVERAGE(M30:R30)
25.15T30
35.0B31C2 5C313.54D313.86E313.39F314.23G312.54H313.55I3121.02J313.518333333K31
Formule=AVERAGE(D31:I31)
21.11L31
Formule=SUM(D31:I31)
25.2T31
36.0B32C2 6C322.89D323.79E323.19F323.33G321.82H322.46I3217.47J322.913333333K32
Formule=AVERAGE(D32:I32)
17.48L32
Formule=SUM(D32:I32)
23.86T32
37.0B33C2 7C332.56D331.8E333.89F333.23G333.27H331.92I3316.65J332.778333333K33
Formule=AVERAGE(D33:I33)
16.67L33
Formule=SUM(D33:I33)
24.24T33
38.0B34C2 8C342.64D343.24E343.17F344.83G342.86H342.71I3419.4J343.241666667K34
Formule=AVERAGE(D34:I34)
19.45L34
Formule=SUM(D34:I34)
24.27T34
39.0B35C2 9C353.2D353.3E352.13F352.48G352.4H351.98I3515.47J352.581666667K35
Formule=AVERAGE(D35:I35)
15.49L35
Formule=SUM(D35:I35)
24.47T35
40.0B36C2 10C363.02D364.31E363.07F363.82G364.04H362.99I3620.94J363.541666667K36
Formule=AVERAGE(D36:I36)
21.25L36
Formule=SUM(D36:I36)
23.76T36
MoyenneC3718.565J37
Formule=AVERAGE(J27:J36)
3.102166667K37
Formule=AVERAGE(K27:K36)
18.613L37
Formule=AVERAGE(L27:L36)
35.91666667S37
Formule=AVERAGE(S27:S36)
24.51T37
Formule=AVERAGE(T27:T36)
22.22U3724.44V374.28W375.98X3739.25Y3735.66Z37
11.0B38NPK 1C3818.18D3823.11E3814.03F3821.56G3823.2H3819.14I38119.07J3819.87K38
Formule=AVERAGE(D38:I38)
119.22L38
Formule=SUM(D38:I38)
21.0M3836.0N3834.0O3838.0P3833.0Q3827.0R3831.5S38
Formule=AVERAGE(M38:R38)
16.79T38
12.0B39NPK 2C3918.15D3921.09E3919.8F3922.06G3916.57H3921.44I39118.96J3919.85166667K39
Formule=AVERAGE(D39:I39)
119.11L39
Formule=SUM(D39:I39)
30.0M3939.0N3925.0O3931.0P3929.0Q3930.0R3930.66666667S39
Formule=AVERAGE(M39:R39)
17.61T39
13.0B40NPK 3C4020.84D4016.45E4014.7F4010.01G40aucunH40aucunI4061.91J4015.5K40
Formule=AVERAGE(D40:I40)
62L40
Formule=SUM(D40:I40)
34.0M4031.0N4044.0O4034.0P4040.0Q4045.0R4038S40
Formule=AVERAGE(M40:R40)
19.42T40
14.0B41NPK 4C4112.61D4114.13E4112.41F4115.13G41aucunH41aucunI4154.17J4113.57K41
Formule=AVERAGE(D41:I41)
54.28L41
Formule=SUM(D41:I41)
33.0M4134.0N4135.0O4131.0P4133.0Q4139.0R4134.16666667S41
Formule=AVERAGE(M41:R41)
20.03T41
15.0B42NPK 5C422.25D4211.17E427.68F428.2G428.1H4210.32I4247.61J427.953333333K42
Formule=AVERAGE(D42:I42)
47.72L42
Formule=SUM(D42:I42)
21.84T42
16.0B43NPK 6C4315.15D4317.8E4325.4F4322.08G4323.61H4325.42I43129.3J4321.57666667K43
Formule=AVERAGE(D43:I43)
129.46L43
Formule=SUM(D43:I43)
17.32T43
17.0B44NPK 7C4410.41D448.51E4412.81F446.87G449.41H445.35I4453.29J448.893333333K44
Formule=AVERAGE(D44:I44)
53.36L44
Formule=SUM(D44:I44)
22.41T44
18.0B45NPK 8C457.34D4512.36E457.03F4511.21G4510.4H453.48I4551.63J458.636666667K45
Formule=AVERAGE(D45:I45)
51.82L45
Formule=SUM(D45:I45)
20.98T45
19.0B46NPK 9C469.66D467.62E4610.82F468.75G467.82H468.42I4653.02J468.848333333K46
Formule=AVERAGE(D46:I46)
53.09L46
Formule=SUM(D46:I46)
21.98T46
20.0B47NPK 10C47N’a pas germéD47-T47
MoyenneC4876.55111111J48
Formule=AVERAGE(J38:J47)
13.85555556K48
Formule=AVERAGE(K38:K47)
76.67333333L48
Formule=AVERAGE(L38:L47)
33.58333333S48
Formule=AVERAGE(S38:S47)
19.82T48
Formule=AVERAGE(T38:T47)
22.81U4826.1V484.35W486.67X4842.2Y4835.35Z48
41.0B49NPK C1 1C4917.24D4931.76E4925.29F499.71G4910.18H4920.72I49114.88J4932.82571429K49
Formule=AVERAGE(D49:J49)
114.9L49
Formule=SUM(D49:I49)
39.0M4935.0N4937.0O4931.0P4927.0Q4926.0R4932.5S49
Formule=AVERAGE(M49:R49)
14.36T49
42.0B50NPK C1 2C5010.32D5013.69E506.73F507.8G5010.65H5013.83I5063.0J5018.00285714K50
Formule=AVERAGE(D50:J50)
63.02L50
Formule=SUM(D50:I50)
29.0M5033.0N5030.0O5032.0P5035.0Q5035.0R5032.33333333S50
Formule=AVERAGE(M50:R50)
17.9T50
43.0B51NPK C1 3C5110.93D5112.48E517.21F5112.12G5111.68H515.9I5160.3J5117.23142857K51
Formule=AVERAGE(D51:J51)
60.32L51
Formule=SUM(D51:I51)
42.0M5129.0N5128.0O5126.0P5127.0Q5139.0R5131.83333333S51
Formule=AVERAGE(M51:R51)
17.36T51
44.0B52NPK C1 4C5217.75D5223.35E5214.99F5220.0G5216.37H5220.92I52113.32J5232.38571429K52
Formule=AVERAGE(D52:J52)
113.38L52
Formule=SUM(D52:I52)
21.0M5226.0N5230.0O5224.0P5238.0Q5240.0R5229.83333333S52
Formule=AVERAGE(M52:R52)
15.51T52
45.0B53NPK C1 5C5315.15D5320.93E5310.12F5317.46G5320.03H536.08I5389.75J5325.64571429K53
Formule=AVERAGE(D53:J53)
89.77L53
Formule=SUM(D53:I53)
15.86T53
46.0B54NPK C1 6C5414.19D549.51E5417.65F5419.5G5415.11H5416.18I5492.11J5426.32142857K54
Formule=AVERAGE(D54:J54)
92.14L54
Formule=SUM(D54:I54)
15.23T54
47.0B55NPK C1 7C5512.95D5514.11E5513.29F5510.21G5515.74H5512.4I5578.68J5522.48285714K55
Formule=AVERAGE(D55:J55)
78.7L55
Formule=SUM(D55:I55)
17.64T55
48.0B56NPK C1 8C5612.75D5616.26E5610.81F560.6G5613.85H5610.9I5665.14J5618.61571429K56
Formule=AVERAGE(D56:J56)
65.17L56
Formule=SUM(D56:I56)
18.26T56
49.0B57NPK C1 9C5715.72D5720.3E5722.75F5719.4G5718.55H5712.62I57109.31J5731.23571429K57
Formule=AVERAGE(D57:J57)
109.34L57
Formule=SUM(D57:I57)
15.79T57
50.0B58NPK C1 10C5811.31D5810.07E586.42F586.45G586.74H5812.1I5853.05J5815.16285714K58
Formule=AVERAGE(D58:J58)
53.09L58
Formule=SUM(D58:I58)
19.04T58
MoyenneC5983.954J59
Formule=AVERAGE(J49:J58)
23.991K59
Formule=AVERAGE(K49:K58)
83.983L59
Formule=AVERAGE(L49:L58)
31.625S59
Formule=AVERAGE(S49:S58)
16.695T59
Formule=AVERAGE(T49:T58)
17.61U5929.93V591.97W591.54X5947.45Y5943.37Z59
51.0B60NPK C2 1C605.46D607.4E6025.19F6017.26G6012.66H6018.63I6086.57J6024.73857143K60
Formule=AVERAGE(D60:J60)
86.6L60
Formule=SUM(D60:I60)
27.0M6030.0N6033.0O6029.0P6032.0Q6031.0R6030.33333333S60
Formule=AVERAGE(M60:R60)
14.24T60
52.0B61NPK C2 2C6119.39D617.12E6120.75F6123.02G6121.91H6192.15J6130.72333333K61
Formule=AVERAGE(D61:J61)
92.19L61
Formule=SUM(D61:I61)
33.0M6140.0N6129.0O6137.0P6133.0Q6140.0R6135.33333333S61
Formule=AVERAGE(M61:R61)
14.74T61
53.0B62NPK C2 3C6215.75D6224.0E629.21F6222.84G6214.77H6226.55I62113.1J6232.31714286K62
Formule=AVERAGE(D62:J62)
113.12L62
Formule=SUM(D62:I62)
31.0M6239.0N6226.0O6232.0P6236.0Q6230.0R6232.33333333S62
Formule=AVERAGE(M62:R62)
14.07T62
54.0B63NPK C2 4C6328.11D6324.95E6323.48F6316.06G6321.37H6320.73I63134.65J6338.47857143K63
Formule=AVERAGE(D63:J63)
134.7L63
Formule=SUM(D63:I63)
31.0M6331.0N6328.0O6332.0P6336.0Q6324.0R6330.33333333S63
Formule=AVERAGE(M63:R63)
14.27T63
55.0B64NPK C2 5C6419.05D646.41E6425.1F6417.94G6427.08H6427.78I64123.33J6435.24142857K64
Formule=AVERAGE(D64:J64)
123.36L64
Formule=SUM(D64:I64)
14.55T64
56.0B65NPK C2 6C6522.09D6514.13E6518.89F659.95G6518.12H6521.51I65104.66J6529.90714286K65
Formule=AVERAGE(D65:J65)
104.69L65
Formule=SUM(D65:I65)
14.36T65
57.0B66NPK C2 7C6626.46D6621.46E6622.79F6627.29G6619.88H66117.85J6639.28833333K66
Formule=AVERAGE(D66:J66)
117.88L66
Formule=SUM(D66:I66)
14.23T66
58.0B67NPK C2 8C6714.65D6712.57E673.92F675.57G6724.32H6726.84I6787.86J6725.10428571K67
Formule=AVERAGE(D67:J67)
87.87L67
Formule=SUM(D67:I67)
14.77T67
59.0B68NPK C2 9C6819.13D6829.93E6817.94F6867.0J6822.33333333K68
Formule=AVERAGE(D68:I68)
67L68
Formule=SUM(D68:I68)
14.81T68
60.0B69NPK C2 10C6917.57D6928.22E6914.91F6914.94G6922.33H6997.94J6932.65166667K69
Formule=AVERAGE(D69:J69)
97.97L69
Formule=SUM(D69:I69)
15.18T69
MoyenneC70102.511J70
Formule=AVERAGE(J60:J69)
31.07838095K70
Formule=AVERAGE(K60:K69)
102.538L70
Formule=AVERAGE(L60:L69)
32.08333333S70
Formule=AVERAGE(S60:S69)
14.522T70
Formule=AVERAGE(T60:T69)
18.6U7030.36V702.08W701.51X7046.18Y7039.7Z70
Pois 1 en substrat, synthèseB72
Code de traitementB73Biomasse fraîche par pot, gC73% par rapport à KD73Biomasse fraîche moyenne par plante, gE73% par rapport à KF73Longueur moyenne des racines, cmG73% par rapport à KH73Matière sèche, % (Règlement du Cabinet n° 518)I73% par rapport à KJ73Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)K73% par rapport à KL73Cellulose brute dans la matière sèche, % (ISO 5498:1981)M73% par rapport à KN73Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)O73Phosphore dans la matière sèche, g/kg (ISO 6491:1998)P73NDF dans la matière sèche, % (LVS EN ISO 16472:2006)Q73% par rapport à KR73ADF dans la matière sèche, % (ISO 13906:2008)S73% par rapport à KT73
KB7418.848999999999997C743.276633333333333E7434.66666666666667G7425.909I7417.82K7430.99M741.97O741.59P7446.33Q7441.41S74
C1B7519.830000000000002C75105.2045201D75
Formule=C75/$C$74*100
5.5365E75168.9691655F75
Formule=E75/$E$74*100
34.37499999999999G7599.15865385H75
Formule=G75/$G$74*100
25.125999999999998I7596.97788413J75
Formule=I75/$I$74*100
25.04K75140.5162738L75
Formule=K75/$K$74*100
22.95M7574.05614714N75
Formule=M75/$M$74*100
4.6O756.73P7538.41Q7582.90524498R75
Formule=Q75/$Q$74*100
31.4S7575.8270949T75
Formule=S75/$S$74*100
C2B7618.565C7698.49328877D76
Formule=C76/$C$74*100
3.1021666666666667E7694.67542905F76
Formule=E76/$E$74*100
35.916666666666664G76103.6057692H76
Formule=G76/$G$74*100
24.51I7694.60033193J76
Formule=I76/$I$74*100
22.22K76124.691358L76
Formule=K76/$K$74*100
24.44M7678.86414973N76
Formule=M76/$M$74*100
4.28O765.98P7639.25Q7684.71832506R76
Formule=Q76/$Q$74*100
35.66S7686.11446511T76
Formule=S76/$S$74*100
NPKB7776.5511111111111C7713.855555555555556E7733.583333333333336G7719.819999999999997I7722.81K7726.1M774.35O776.67P7742.2Q7735.35S77
NPK C1B7883.954C78109.6705179D78
Formule=C78/$C$77*100
23.991000000000003E78173.1507618F78
Formule=E78/$E$77*100
31.625G7894.16873449H78
Formule=G78/$G$77*100
16.695I7884.23309788J78
Formule=I78/$I$77*100
17.61K7877.20298115L78
Formule=K78/$K$77*100
29.93M78114.6743295N78
Formule=M78/$M$77*100
1.97O781.54P7847.45Q78112.4407583R78
Formule=Q78/$Q$77*100
43.37S78122.6874116T78
Formule=S78/$S$77*100
NPK C2B79102.51100000000001C79133.9118381D79
Formule=C79/$C$77*100
31.07838095238095E79224.3026693F79
Formule=E79/$E$77*100
32.083333333333336G7995.53349876H79
Formule=G79/$G$77*100
14.522I7973.26942482J79
Formule=I79/$I$77*100
18.6K7981.54318281L79
Formule=K79/$K$77*100
30.36M79116.3218391N79
Formule=M79/$M$77*100
2.08O791.51P7946.18Q79109.4312796R79
Formule=Q79/$Q$77*100
39.7S79112.3055163T79
Formule=S79/$S$77*100
Pois 2 dans le sol, résuméB81
Code de traitementB82Biomasse fraîche par plante, gC82% par rapport à KD82Matière sèche, %E82Longueur de la plante, cmF82% par rapport à KG82Nombre de vrilles, unitésH82Code de traitementJ82Longueur des racines, cmK82% par rapport à KL82Masse des racines, gM82% par rapport à KN82Matière sèche, %O82
KB8310.3275C8318.14E8358.0F8315.25H83KJ8322.950000000000003K837.675000000000001M8310.64O83
C1B8412.477500000000001C84120.8182038D84
Formule=C84/$C$83*100
18.32E8468.75F84118.5344828G84
Formule=F84/$F$83*100
15.75H84C1J8423.775000000000002K84103.5947712L84
Formule=K84/$K$83*100
8.145000000000001M84106.1237785N84
Formule=M84/$M$83*100
11.24O84
C2B8512.24C85118.5185185D85
Formule=C85/$C$83*100
21.3E8568.625F85118.3189655G85
Formule=F85/$F$83*100
15.5H85C2J8526.025K85113.3986928L85
Formule=K85/$K$83*100
9.2725M85120.8143322N85
Formule=M85/$M$83*100
11.79O85
N C1B8613.1C86126.8458D86
Formule=C86/$C$83*100
19.51E8666.7F86115G86
Formule=F86/$F$83*100
16.75H86N C1J8622.875K8699.67320261L86
Formule=K86/$K$83*100
9.200000000000001M86119.8697068N86
Formule=M86/$M$83*100
13.35O86
N C2B8713.1825C87127.6446381D87
Formule=C87/$C$83*100
16.84E8767.57499999999999F87116.5086207G87
Formule=F87/$F$83*100
15.5H87N C2J8727.675K87120.5882353L87
Formule=K87/$K$83*100
11.055M87144.0390879N87
Formule=M87/$M$83*100
16.32O87
TN-125/25, 08.10.25.C91TN-166/25, 28.11.25.M91TN-167/25, 28.11.25.P91
Pois 1, plantesC92Pois 2, plantesM92Pois 2, racinesP92
Numéro d'identification attribué par le clientC93Paramètre et méthode d’essaiD93Numéro d'identification attribué par le clientM93Paramètre et méthode d’essaiN93Numéro d'identification attribué par le clientP93Paramètre et méthode d’essaiQ93
Matière sèche, % (Règlement du Cabinet n° 518)D94Protéines dans la matière sèche, % (analyse élémentaire, combustion sèche)E94Cellulose brute dans la matière sèche, % (ISO 5498:1981)F94Potassium dans la matière sèche, % (LVS EN ISO 6869:2002)G94Phosphore dans la matière sèche, g/kg (ISO 6491:1998)H94NDF dans la matière sèche, % (LVS EN ISO 16472:2006)I94ADF dans la matière sèche, % (ISO 13906:2008)J94Matière sèche, % (Règlement du Cabinet n° 518)N94Matière sèche, % (Règlement du Cabinet n° 518)Q94
K 1C9528.19D9517.82E9530.99F951.97G951.59H9546.33I9541.41J951.N C2M9517.04N951.N C2P9519.13Q95
K 2C9625.97D962.N C2M9617.83N962.N C2P9614.14Q96
K 3C9726.85D973.N C2M9714.34N973.N C2P9714.29Q97
K 4C9825.55D984.N C2M9818.14N984.N C2P9817.7Q98
K 5C9925.41D991.N C1M9917.3N991.N C1P9916.77Q99
K 6C10027.53D1002.N C1M10021.02N1002.N C1P10012.3Q100
K 7C10125.45D1013.N C1M10121.4N1013.N C1P10111.77Q101
K 8C10224.73D1024.N C1M10218.32N1024.N C1P10212.55Q102
K 9C10323.95D1031.C1M10315.83N1031.C1P10310.99Q103
K 10C10425.46D1042.C1M10418.65N1042.C1P10410.22Q104
NPK 1C10516.79D10522.81E10526.1F1054.35G1056.67H10542.2I10535.35J1053.C1M10519.75N1053.C1P10512.1Q105
NPK 2C10617.61D1064.C1M10619.06N1064.C1P10611.65Q106
NPK 3C10719.42D1071.C2M10721.83N1071.C2P10711.49Q107
NPK 4C10820.03D1082.C2M10823.12N1082.C2P10811.14Q108
NPK 5C10921.84D1093.C2M10920.56N1093.C2P10912.6Q109
NPK 6C11017.32D1104.C2M11019.67N1104.C2P11011.93Q110
NPK 7C11122.41D1111.KM11118.26N1111.KP11112.02Q111
NPK 8C11220.98D1122.KM11217.01N1122.KP11210.13Q112
NPK 9C11321.98D1133.KM11316.86N1133.KP1139.87Q113
NPK 10C114-D1144.KM11420.43N1144.KP11410.53Q114
C1 1C11524.97D11525.04E11522.95F1154.6G1156.73H11538.41I11531.4J115
C1 2C11625.83D116
C1 3C11726.37D117
C1 4C11825.66D118
C1 5C11927.12D119
C1 6C12024.54D120
C1 7C12124.34D121
C1 8C12224.43D122
C1 9C12323.57D123
C1 10C12424.43D124
C2 1C12526.07D12522.22E12524.44F1254.28G1255.98H12539.25I12535.66J125
C2 2C12625.19D126
C2 3C12722.89D127
C2 4C12825.15D128
C2 5C12925.2D129
C2 6C13023.86D130
C2 7C13124.24D131
C2 8C13224.27D132
C2 9C13324.47D133
C2 10C13423.76D134
NPK C1 1C13514.36D13517.61E13529.93F1351.97G1351.54H13547.45I13543.37J135
NPK C1 2C13617.9D136
NPK C1 3C13717.36D137
NPK C1 4C13815.51D138
NPK C1 5C13915.86D139
NPK C1 6C14015.23D140
NPK C1 7C14117.64D141
NPK C1 8C14218.26D142
NPK C1 9C14315.79D143
NPK C1 10C14419.04D144
NPK C2 1C14514.24D14518.6E14530.36F1452.08G1451.51H14546.18I14539.7J145
NPK C2 2C14614.74D146
NPK C2 3C14714.07D147
NPK C2 4C14814.27D148
NPK C2 5C14914.55D149
NPK C2 6C15014.36D150
NPK C2 7C15114.23D151
NPK C2 8C15214.77D152
NPK C2 9C15314.81D153
NPK C2 10C15415.18D154
TA-59/25, 23.10.2025C157
Numéro d'identification attribué par le clientC159Paramètre et méthode d’essaiD159
*pH (LVS ISO 10390:2022) en solution KCl, c = 1 mol/lD160Matière organique, % (procédure du ministère de l’Agriculture n° 1 du 4 janvier 2022, annexe 5, méthode 1)E160Phosphore extractible P2O5, mg/kg (méthode Egner–Riehm)F160Potassium extractible K2O, mg/kg (méthode Egner–Riehm)G160Azote total, mg/g (LVS EN ISO 11261:2002)H160Humidité, % (LVS EN ISO 11465:2006)I160
SKL1, pois, 14.10.25.C1615.81D1612.03E161355.17F161236.5G1610.81H1610.89I161

Feuille de calcul: Plan de l’essai

Tableau 5
SKL 10C1
BetteraveC2
IC3IID3IIIE3IVF3IH3III3IIIJ3IVK3IM3IIN3IIIO3IVP3IR3IIS3IIIT3IVU3IW3IIX3IIIY3IVZ3IAB3IIAC3IIIAD3IVAE3
NPK C2D4NPK C1I4C2N4C1S4NPKX40.0AC4
IVAH5
IIIAH6
IIAH7
IAH8
NPKAI9NPK C1AJ9NPK C2AK9C1AL9C2AM90.0AN9C3AO9