NanoImport← Todos los documentos

Documentos completos en su idioma

Libro de datos de ensayos AREI

Hoja de cálculo suministrada con tablas de ensayos y valores registrados.

Descargar PDF en español

Hoja de cálculo: remolacha

Tabla 1
Rendimiento de remolacha en Stende, 2025B1
CultivoB2remolachaC2
CampoB3SKL 10C3
SembradoB426.05.2025.C4
CosechadoB510.-11.09.2025. Olena y SolveigaC5
Longitud de las hojas, cmD6Masa de las hojas, kgE6Peso en kgF6Diámetro de la remolacha, cmG6Brix % (contenido de azúcar)H6GrandesI6Tamaño medianoK6PequeñoM6Peso en kgO6
unidadesI7kgJ7unidadesK7kgL7unidadesM7kgN7por hileraO7
Tratamiento 1A8IB81.0C845.0D80.115E80.205F88.5G89.5H83.0I81.305J816.0K82.92L825.0M80.995N85.22O8
Fórmula=SUM(J8+L8+N8)
Hilera 1P8
2.0C942.0D90.09E90.17F98.0G97.3H92.0I90.655J921.0K93.08L935.0M90.925N94.66O9
Fórmula=SUM(J9+L9+N9)
Hilera 2P9
3.0C1045.0D100.1E100.24F107.1G107.7H10
4.0C1146.0D110.13E110.255F116.2G1110.6H11
5.0C1241.0D120.05E120.135F126.5G1210.4H12
por réplicaB1343.8D13
Fórmula=AVERAGE(D8:D12)
0.097E13
Fórmula=AVERAGE(E8:E12)
0.201F13
Fórmula=AVERAGE(F8:F12)
7.26G13
Fórmula=AVERAGE(G8:G12)
9.1H13
Fórmula=AVERAGE(H8:H12)
9.88O13
Fórmula=SUM(O8:O12)
IIB141.0C1437.0D140.08E140.155F147.0G149.7H141.0I140.46J146.0K140.85L1435.0M141.015N142.325O14
Fórmula=SUM(J14+L14+N14)
2.0C1534.0D150.05E150.145F156.3G1510.7H152.0I150.685J1525.0K153.55L1534.0M151.05N155.285O15
Fórmula=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
por réplicaB1937.2D19
Fórmula=AVERAGE(D14:D18)
0.062E19
Fórmula=AVERAGE(E14:E18)
0.16F19
Fórmula=AVERAGE(F14:F18)
6.12G19
Fórmula=AVERAGE(G14:G18)
10.34H19
Fórmula=AVERAGE(H14:H18)
7.61O19
Fórmula=SUM(O14:O18)
IIIB201.0C2041.0D200.055E200.16F206.0G2010.0H200.0I200.0J207.0K200.89L2017.0M200.325N201.215O20
Fórmula=SUM(J20+L20+N20)
2.0C2140.0D210.07E210.12F216.8G2110.2H213.0I210.92J2125.0K213.83L2122.0M210.775N215.525O21
Fórmula=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
por réplicaB2541.2D25
Fórmula=AVERAGE(D20:D24)
0.075E25
Fórmula=AVERAGE(E20:E24)
0.156F25
Fórmula=AVERAGE(F20:F24)
6.44G25
Fórmula=AVERAGE(G20:G24)
10.62H25
Fórmula=AVERAGE(H20:H24)
6.74O25
Fórmula=SUM(O20:O24)
IVB261.0C2635.0D260.075E260.24F267.8G2610.3H260.0I260.0J2623.0K262.54L2627.0M260.89N263.43O26
Fórmula=SUM(J26+L26+N26)
2.0C2739.0D270.08E270.28F278.2G2711.3H274.0I271.81J2734.0K274.615L2720.0M270.61N277.035O27
Fórmula=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
por réplicaB3138.2D31
Fórmula=AVERAGE(D26:D30)
0.071E31
Fórmula=AVERAGE(E26:E30)
0.219F31
Fórmula=AVERAGE(F26:F30)
7.42G31
Fórmula=AVERAGE(G26:G30)
10.78H31
Fórmula=AVERAGE(H26:H30)
10.465O31
Fórmula=SUM(O26:O30)
por tratamientoB3240.1D32
Fórmula=SUM(D13+D19+D25+D31)/4
0.07625E32
Fórmula=SUM(E13+E19+E25+E31)/4
0.184F32
Fórmula=SUM(F13+F19+F25+F31)/4
6.81G32
Fórmula=SUM(G13+G19+G25+G31)/4
10.21H32
Fórmula=SUM(H13+H19+H25+H31)/4
1.875I32
Fórmula=AVERAGE(I8:I31)
0.729375J32
Fórmula=AVERAGE(J8:J31)
19.625K32
Fórmula=AVERAGE(K8:K31)
2.784375L32
Fórmula=AVERAGE(L8:L31)
26.875M32
Fórmula=AVERAGE(M8:M31)
0.823125N32
Fórmula=AVERAGE(N8:N31)
8.67375O32
Fórmula=SUM(O13+O19+O25+O31)/4
Tratamiento 2A33IB331.0C3338.0D330.075E330.22F337.3G3312.1H337.0I333.6J3326.0K334.155L339.0M330.34N338.095O33
Fórmula=SUM(J33+L33+N33)
2.0C3440.0D340.08E340.19F346.5G3410.4H342.0I341.185J3426.0K344.725L3417.0M340.56N346.47O34
Fórmula=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
por réplicaB3842.2D38
Fórmula=AVERAGE(D33:D37)
0.092E38
Fórmula=AVERAGE(E33:E37)
0.224F38
Fórmula=AVERAGE(F33:F37)
7.04G38
Fórmula=AVERAGE(G33:G37)
11.02H38
Fórmula=AVERAGE(H33:H37)
14.565O38
Fórmula=SUM(O33:O37)
IIB391.0C3952.0D390.09E390.19F396.4G3911.3H392.0I391.04J3916.0K392.31L3920.0M390.7N394.05O39
Fórmula=SUM(J39+L39+N39)
2.0C4042.0D400.055E400.215F407.2G4011.4H403.0I401.32J4028.0K404.19L4060.0M400.56N406.07O40
Fórmula=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
por réplicaB4444D44
Fórmula=AVERAGE(D39:D43)
0.074E44
Fórmula=AVERAGE(E39:E43)
0.211F44
Fórmula=AVERAGE(F39:F43)
7.04G44
Fórmula=AVERAGE(G39:G43)
10.8H44
Fórmula=AVERAGE(H39:H43)
10.12O44
Fórmula=SUM(O39:O43)
IIIB451.0C4543.0D450.065E450.15F457.3G4512.0H452.0I450.705J4525.0K453.76L4526.0M450.8N455.265O45
Fórmula=SUM(J45+L45+N45)
2.0C4650.0D460.09E460.245F466.4G4612.3H462.0I460.79J4628.0K464.405L4626.0M460.835N466.03O46
Fórmula=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
por réplicaB5046.4D50
Fórmula=AVERAGE(D45:D49)
0.076E50
Fórmula=AVERAGE(E45:E49)
0.212F50
Fórmula=AVERAGE(F45:F49)
6.58G50
Fórmula=AVERAGE(G45:G49)
12.1H50
Fórmula=AVERAGE(H45:H49)
11.295O50
Fórmula=SUM(O45:O49)
IVB511.0C5149.0D510.095E510.21F517.9G5112.0H513.0I511.525J5122.0K513.155L5119.0M510.715N515.395O51
Fórmula=SUM(J51+L51+N51)
2.0C5249.0D520.1E520.255F527.6G5212.8H523.0I521.315J5221.0K524.53L5214.0M520.545N526.39O52
Fórmula=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
por réplicaB5647D56
Fórmula=AVERAGE(D51:D55)
0.095E56
Fórmula=AVERAGE(E51:E55)
0.215F56
Fórmula=AVERAGE(F51:F55)
7.1G56
Fórmula=AVERAGE(G51:G55)
12.62H56
Fórmula=AVERAGE(H51:H55)
11.785O56
Fórmula=SUM(O51:O55)
por tratamientoB5744.9D57
Fórmula=SUM(D38+D44+D50+D56)/4
0.08425E57
Fórmula=SUM(E38+E44+E50+E56)/4
0.2155F57
Fórmula=SUM(F38+F44+F50+F56)/4
6.94G57
Fórmula=SUM(G38+G44+G50+G56)/4
11.635H57
Fórmula=SUM(H38+H44+H50+H56)/4
3I57
Fórmula=AVERAGE(I33:I56)
1.435J57
Fórmula=AVERAGE(J33:J56)
24K57
Fórmula=AVERAGE(K33:K56)
3.90375L57
Fórmula=AVERAGE(L33:L56)
23.875M57
Fórmula=AVERAGE(M33:M56)
0.631875N57
Fórmula=AVERAGE(N33:N56)
11.94125O57
Fórmula=SUM(O38+O44+O50+O56)/4
Tratamiento 3A58IB581.0C5841.0D580.08E580.225F587.1G5811.7H581.0I580.515J5824.0K583.865L5825.0M580.835N585.215O58
Fórmula=SUM(J58+L58+N58)
2.0C5942.0D590.195E590.275F597.4G5911.2H590.0I590.0J5925.0K594.26L5930.0M591.015N595.275O59
Fórmula=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
por réplicaB6341.4D63
Fórmula=AVERAGE(D58:D62)
0.122E63
Fórmula=AVERAGE(E58:E62)
0.254F63
Fórmula=AVERAGE(F58:F62)
7.42G63
Fórmula=AVERAGE(G58:G62)
10.72H63
Fórmula=AVERAGE(H58:H62)
10.49O63
Fórmula=SUM(O58:O62)
IIB641.0C6443.0D641.14E640.25F647.8G6411.4H641.0I640.355J6422.0K642.74L6421.0M640.715N643.81O64
Fórmula=SUM(J64+L64+N64)
2.0C6539.0D650.08E650.27F658.0G6512.0H650.0I650.0J6525.0K653.74L6534.0M651.27N655.01O65
Fórmula=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
por réplicaB6944.4D69
Fórmula=AVERAGE(D64:D68)
0.319E69
Fórmula=AVERAGE(E64:E68)
0.252F69
Fórmula=AVERAGE(F64:F68)
7.76G69
Fórmula=AVERAGE(G64:G68)
11.22H69
Fórmula=AVERAGE(H64:H68)
8.82O69
Fórmula=SUM(O64:O68)
IIIB701.0C7039.0D700.09E700.32F708.7G7012.9H701.0I700.635J7011.0K701.71L7039.0M701.21N703.555O70
Fórmula=SUM(J70+L70+N70)
2.0C7138.0D710.1E710.245F717.3G719.3H712.0I711.02J7121.0K713.015L7123.0M710.915N714.95O71
Fórmula=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
por réplicaB7540.2D75
Fórmula=AVERAGE(D70:D74)
0.099E75
Fórmula=AVERAGE(E70:E74)
0.257F75
Fórmula=AVERAGE(F70:F74)
7.78G75
Fórmula=AVERAGE(G70:G74)
10.68H75
Fórmula=AVERAGE(H70:H74)
8.505O75
Fórmula=SUM(O70:O74)
IVB761.0C7643.0D760.14E760.305F767.4G7613.1H762.0I760.84J7613.0K761.515L7635.0M761.36N763.715O76
Fórmula=SUM(J76+L76+N76)
2.0C7743.0D770.14E770.225F776.6G7713.4H774.0I772.07J7726.0K774.345L7722.0M770.9N777.315O77
Fórmula=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
por réplicaB8142D81
Fórmula=AVERAGE(D76:D80)
0.124E81
Fórmula=AVERAGE(E76:E80)
0.242F81
Fórmula=AVERAGE(F76:F80)
6.96G81
Fórmula=AVERAGE(G76:G80)
11.7H81
Fórmula=AVERAGE(H76:H80)
11.03O81
Fórmula=SUM(O76:O80)
por tratamientoB8242D82
Fórmula=SUM(D63+D69+D75+D81)/4
0.166E82
Fórmula=SUM(E63+E69+E75+E81)/4
0.25125F82
Fórmula=SUM(F63+F69+F75+F81)/4
7.48G82
Fórmula=SUM(G63+G69+G75+G81)/4
11.08H82
Fórmula=SUM(H63+H69+H75+H81)/4
1.375I82
Fórmula=AVERAGE(I58:I81)
0.679375J82
Fórmula=AVERAGE(J58:J81)
20.875K82
Fórmula=AVERAGE(K58:K81)
3.14875L82
Fórmula=AVERAGE(L58:L81)
28.625M82
Fórmula=AVERAGE(M58:M81)
1.0275N82
Fórmula=AVERAGE(N58:N81)
9.71125O82
Fórmula=SUM(O63+O69+O75+O81)/4
Tratamiento 4A83IB831.0C8340.0D830.115E830.275F837.5G8312.8H835.0I832.135J8318.0K832.5L8320.0M830.795N835.43O83
Fórmula=SUM(J83+L83+N83)
2.0C8440.0D840.08E840.21F847.2G8411.9H842.0I841.4J8414.0K842.72L8421.0M841.035N845.155O84
Fórmula=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
por réplicaB8841D88
Fórmula=AVERAGE(D83:D87)
0.085E88
Fórmula=AVERAGE(E83:E87)
0.228F88
Fórmula=AVERAGE(F83:F87)
7.12G88
Fórmula=AVERAGE(G83:G87)
11.96H88
Fórmula=AVERAGE(H83:H87)
10.585O88
Fórmula=SUM(O83:O87)
IIB891.0C8942.0D890.09E890.21F896.5G8913.7H892.0I890.86J8917.0K892.82L8928.0M891.015N894.695O89
Fórmula=SUM(J89+L89+N89)
2.0C9047.0D900.12E900.215F906.4G9012.1H900.0I900.0J9029.0K904.945L9040.0M901.34N906.285O90
Fórmula=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
por réplicaB9444.2D94
Fórmula=AVERAGE(D89:D93)
0.106E94
Fórmula=AVERAGE(E89:E93)
0.203F94
Fórmula=AVERAGE(F89:F93)
6.82G94
Fórmula=AVERAGE(G89:G93)
11.14H94
Fórmula=AVERAGE(H89:H93)
10.98O94
Fórmula=SUM(O89:O93)
IIIB951.0C9537.0D950.06E950.17F956.5G9510.5H950.0I950.0J9522.0K953.225L9539.0M951.435N954.66O95
Fórmula=SUM(J95+L95+N95)
2.0C9640.0D960.1E960.295F967.0G9610.5H964.0I961.535J9630.0K964.765L9634.0M961.46N967.76O96
Fórmula=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
por réplicaB10039.4D100
Fórmula=AVERAGE(D95:D99)
0.079E100
Fórmula=AVERAGE(E95:E99)
0.208F100
Fórmula=AVERAGE(F95:F99)
7.02G100
Fórmula=AVERAGE(G95:G99)
10.86H100
Fórmula=AVERAGE(H95:H99)
12.42O100
Fórmula=SUM(O95:O99)
IVB1011.0C10140.0D1010.08E1010.165F1017.1G1017.0H1010.0I1010.0J10117.0K1012.15L10134.0M1010.98N1013.13O101
Fórmula=SUM(J101+L101+N101)
2.0C10236.0D1020.07E1020.18F1026.3G1028.8H1023.0I1021.37J10232.0K1025.605L10228.0M1021.095N1028.07O102
Fórmula=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
por réplicaB10641.6D106
Fórmula=AVERAGE(D101:D105)
0.081E106
Fórmula=AVERAGE(E101:E105)
0.198F106
Fórmula=AVERAGE(F101:F105)
6.66G106
Fórmula=AVERAGE(G101:G105)
8.78H106
Fórmula=AVERAGE(H101:H105)
11.2O106
Fórmula=SUM(O101:O105)
por tratamientoB10741.55D107
Fórmula=SUM(D88+D94+D100+D106)/4
0.08775E107
Fórmula=SUM(E88+E94+E100+E106)/4
0.20925F107
Fórmula=SUM(F88+F94+F100+F106)/4
6.905G107
Fórmula=SUM(G88+G94+G100+G106)/4
10.685H107
Fórmula=SUM(H88+H94+H100+H106)/4
2I107
Fórmula=AVERAGE(I83:I105)
0.9125J107
Fórmula=AVERAGE(J83:J105)
22.375K107
Fórmula=AVERAGE(K83:K105)
3.59125L107
Fórmula=AVERAGE(L83:L105)
30.5M107
Fórmula=AVERAGE(M83:M105)
1.144375N107
Fórmula=AVERAGE(N83:N105)
11.29625O107
Fórmula=SUM(O88+O94+O100+O106)/4
Tratamiento 5A108IB1081.0C10847.0D1080.12E1080.325F1087.1G10813.0H1082.0I1081.335J10830.0K1085.13L10824.0M1080.805N1087.27O108
Fórmula=SUM(J108+L108+N108)
2.0C10945.0D1090.11E1090.235F1099.0G10910.4H1096.0I1092.92J10917.0K1093.22L10929.0M1090.95N1097.09O109
Fórmula=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
por réplicaB11346.6D113
Fórmula=AVERAGE(D108:D112)
0.111E113
Fórmula=AVERAGE(E108:E112)
0.299F113
Fórmula=AVERAGE(F108:F112)
7.54G113
Fórmula=AVERAGE(G108:G112)
12.54H113
Fórmula=AVERAGE(H108:H112)
14.36O113
Fórmula=SUM(O108:O112)
IIB1141.0C11450.0D1140.125E1140.29F1148.4G11413.9H1141.0I1141.09J11414.0K1142.38L11427.0M1140.81N1144.28O114
Fórmula=SUM(J114+L114+N114)
2.0C11539.0D1150.09E1150.19F1158.0G11511.4H1154.0I1152.195J11523.0K1154.89L11524.0M1150.81N1157.895O115
Fórmula=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
por réplicaB11947.4D119
Fórmula=AVERAGE(D114:D118)
0.107E119
Fórmula=AVERAGE(E114:E118)
0.281F119
Fórmula=AVERAGE(F114:F118)
7.46G119
Fórmula=AVERAGE(G114:G118)
11.96H119
Fórmula=AVERAGE(H114:H118)
12.175O119
Fórmula=SUM(O114:O118)
IIIB1201.0C12048.0D1200.145E1200.235F1206.8G12012.8H1203.0I1201.925J12013.0K1202.435L12013.0M1200.395N1204.755O120
Fórmula=SUM(J120+L120+N120)
2.0C12139.0D1210.125E1210.25F1217.1G12112.6H1212.0I1210.99J12118.0K1213.005L12121.0M1210.7N1214.695O121
Fórmula=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
por réplicaB12543D125
Fórmula=AVERAGE(D120:D124)
0.111E125
Fórmula=AVERAGE(E120:E124)
0.257F125
Fórmula=AVERAGE(F120:F124)
7.4G125
Fórmula=AVERAGE(G120:G124)
11.58H125
Fórmula=AVERAGE(H120:H124)
9.45O125
Fórmula=SUM(O120:O124)
IVB1261.0C12642.0D1260.08E1260.275F1266.7G12612.5H1263.0I1261.495J12623.0K1264.29L12624.0M1260.765N1266.55O126
Fórmula=SUM(J126+L126+N126)
2.0C12749.0D1270.095E1270.2F1277.5G12711.3H1279.0I1275.34J12719.0K1273.825L12714.0M1270.365N1279.53O127
Fórmula=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
por réplicaB13147.2D131
Fórmula=AVERAGE(D126:D130)
0.119E131
Fórmula=AVERAGE(E126:E130)
0.298F131
Fórmula=AVERAGE(F126:F130)
7.58G131
Fórmula=AVERAGE(G126:G130)
11.48H131
Fórmula=AVERAGE(H126:H130)
16.08O131
Fórmula=SUM(O126:O130)
por tratamientoB13246.05D132
Fórmula=SUM(D113+D119+D125+D131)/4
0.112E132
Fórmula=SUM(E113+E119+E125+E131)/4
0.28375F132
Fórmula=SUM(F113+F119+F125+F131)/4
7.495G132
Fórmula=SUM(G113+G119+G125+G131)/4
11.89H132
Fórmula=SUM(H113+H119+H125+H131)/4
3.75I132
Fórmula=AVERAGE(I108:I131)
2.16125J132
Fórmula=AVERAGE(J108:J131)
19.625K132
Fórmula=AVERAGE(K108:K131)
3.646875L132
Fórmula=AVERAGE(L108:L131)
22M132
Fórmula=AVERAGE(M108:M131)
0.7N132
Fórmula=AVERAGE(N108:N131)
13.01625O132
Fórmula=SUM(O113+O119+O125+O131)/4
Tratamiento 6A133IB1331.0C13345.0D1330.1E1330.205F1337.6G13310.4H1338.0I1334.27J1336.0K1330.795L13312.0M1330.625N1335.69O133
Fórmula=SUM(J133+L133+N133)
2.0C13440.0D1340.075E1340.195F1347.3G13410.2H1345.0I1342.385J13428.0K1345.3L13418.0M1340.365N1348.05O134
Fórmula=SUM(J134+L134+N134)
3.0C13544.0D1350.125E1350.31F1357.0G13511.0H135GrandesR135Tamaño medianoU135PequeñoX135
4.0C13642.0D1360.11E1360.28F1367.4G13610.9H136unidadesR136kgS136% del número totalT136unidadesU136kgV136% del número totalW136unidadesX136kgY136% del número totalZ136Número total, unidadesAA136Total kgAB136
5.0C13742.0D1370.125E1370.275F1376.3G13712.3H1371.875R1370.7293750000000001S1373.875968992T137
Fórmula=R137/AA137*100
19.625U1372.784375V13740.56847545W137
Fórmula=U137/AA137*100
26.875X1370.823125Y13755.55555556Z137
Fórmula=X137/AA137*100
48.375AA137
Fórmula=SUM(R137+U137+X137)
4.336875AB137
Fórmula=SUM(S137+V137+Y137)
por réplicaB13842.6D138
Fórmula=AVERAGE(D133:D137)
0.107E138
Fórmula=AVERAGE(E133:E137)
0.253F138
Fórmula=AVERAGE(F133:F137)
7.12G138
Fórmula=AVERAGE(G133:G137)
10.96H138
Fórmula=AVERAGE(H133:H137)
13.74O138
Fórmula=SUM(O133:O137)
3.0R1381.435S1385.896805897T138
Fórmula=R138/AA138*100
24.0U1383.9037500000000005V13847.17444717W138
Fórmula=U138/AA138*100
23.875X1380.631875Y13846.92874693Z138
Fórmula=X138/AA138*100
50.875AA138
Fórmula=SUM(R138+U138+X138)
5.970625AB138
Fórmula=SUM(S138+V138+Y138)
IIB1391.0C13949.0D1390.195E1390.425F1397.1G13910.8H1391.0I1390.545J13921.0K1392.45L13919.0M1390.665N1393.66O139
Fórmula=SUM(J139+L139+N139)
1.375R1390.679375S1392.702702703T139
Fórmula=R139/AA139*100
20.875U1393.14875V13941.03194103W139
Fórmula=U139/AA139*100
28.625X1391.0275Y13956.26535627Z139
Fórmula=X139/AA139*100
50.875AA139
Fórmula=SUM(R139+U139+X139)
4.855625AB139
Fórmula=SUM(S139+V139+Y139)
2.0C14049.0D1400.125E1400.26F1408.6G14010.0H1400.0I1400.0J14033.0K1406.26L14026.0M1400.84N1407.1O140
Fórmula=SUM(J140+L140+N140)
2.0R1400.9125S1403.644646925T140
Fórmula=R140/AA140*100
22.375U1403.59125V14040.77448747W140
Fórmula=U140/AA140*100
30.5X1401.144375Y14055.5808656Z140
Fórmula=X140/AA140*100
54.875AA140
Fórmula=SUM(R140+U140+X140)
5.648125AB140
Fórmula=SUM(S140+V140+Y140)
3.0C14143.0D1410.09E1410.17F1418.8G14110.8H1413.75R1412.16125S1418.26446281T141
Fórmula=R141/AA141*100
19.625U1413.6468749999999996V14143.25068871W141
Fórmula=U141/AA141*100
22.0X1410.7Y14148.48484848Z141
Fórmula=X141/AA141*100
45.375AA141
Fórmula=SUM(R141+U141+X141)
6.508125AB141
Fórmula=SUM(S141+V141+Y141)
4.0C14241.0D1420.1E1420.36F1426.5G14212.4H1422.4R142
Fórmula=AVERAGE(R118:R141)
1.1835S142
Fórmula=AVERAGE(S118:S141)
4.792810784T142
Fórmula=R142/AA142*100
21.3U142
Fórmula=AVERAGE(U118:U141)
3.415V142
Fórmula=AVERAGE(V118:V141)
42.53619571W142
Fórmula=U142/AA142*100
26.375X142
Fórmula=AVERAGE(X118:X141)
0.865375Y142
Fórmula=AVERAGE(Y118:Y141)
52.67099351Z142
Fórmula=X142/AA142*100
50.075AA142
Fórmula=SUM(R142+U142+X142)
5.463875AB142
Fórmula=SUM(S142+V142+Y142)
5.0C14349.0D1430.125E1430.39F1438.5G14310.8H143
por réplicaB14446.2D144
Fórmula=AVERAGE(D139:D143)
0.127E144
Fórmula=AVERAGE(E139:E143)
0.321F144
Fórmula=AVERAGE(F139:F143)
7.9G144
Fórmula=AVERAGE(G139:G143)
10.96H144
Fórmula=AVERAGE(H139:H143)
10.76O144
Fórmula=SUM(O139:O143)
IIIB1451.0C14550.0D1450.1E1450.2F1457.3G14511.8H1454.0I1452.94J14517.0K1452.455L14512.0M1450.34N1455.735O145
Fórmula=SUM(J145+L145+N145)
2.0C14647.0D1460.185E1460.34F1466.9G14611.9H1461.0I1460.575J14630.0K1465.825L14619.0M1460.46N1466.86O146
Fórmula=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
por réplicaB15045.4D150
Fórmula=AVERAGE(D145:D149)
0.146E150
Fórmula=AVERAGE(E145:E149)
0.284F150
Fórmula=AVERAGE(F145:F149)
7.66G150
Fórmula=AVERAGE(G145:G149)
12.34H150
Fórmula=AVERAGE(H145:H149)
12.595O150
Fórmula=SUM(O145:O149)
IVB1511.0C15149.0D1510.165E1510.39F1518.7G15111.0H1514.0I1512.94J15117.0K1512.455L15112.0M1510.34N1515.735O151
Fórmula=SUM(J151+L151+N151)
2.0C15248.0D1520.085E1520.28F1528.2G15211.8H1521.0I1520.575J15230.0K1525.825L15219.0M1520.46N1526.86O152
Fórmula=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
por réplicaB15648.6D156
Fórmula=AVERAGE(D151:D155)
0.137E156
Fórmula=AVERAGE(E151:E155)
0.355F156
Fórmula=AVERAGE(F151:F155)
8.28G156
Fórmula=AVERAGE(G151:G155)
11.48H156
Fórmula=AVERAGE(H151:H155)
12.595O156
Fórmula=SUM(O151:O155)
por tratamientoB15745.7D157
Fórmula=SUM(D138+D144+D150+D156)/4
0.12925E157
Fórmula=SUM(E138+E144+E150+E156)/4
0.30325F157
Fórmula=SUM(F138+F144+F150+F156)/4
7.74G157
Fórmula=SUM(G138+G144+G150+G156)/4
11.435H157
Fórmula=SUM(H138+H144+H150+H156)/4
3I157
Fórmula=AVERAGE(I133:I156)
1.77875J157
Fórmula=AVERAGE(J133:J156)
22.75K157
Fórmula=AVERAGE(K133:K156)
3.920625L157
Fórmula=AVERAGE(L133:L156)
17.125M157
Fórmula=AVERAGE(M133:M156)
0.511875N157
Fórmula=AVERAGE(N133:N156)
12.4225O157
Fórmula=SUM(O138+O144+O150+O156)/4
Rendimiento de remolacha de mesa, kg por 2 m², SPC, 2025B159Anova: Factor únicoY159
N.º de tratamientoA160Código de tratamientoB160IC160IID160IIIE160IVF160MediaG160Respecto a KH160Código de tratamientoN160Rendimiento de remolacha de mesa, t ha-1O160MediaS160Respecto a K, t ha-1T160Respecto a K, %U160
1.0A161NPK 0B1619.88C161
Fórmula=O13
7.61D161
Fórmula=O19
6.74E161
Fórmula=O25
10.465F161
Fórmula=O31
8.67375G161
Fórmula=AVERAGE(C161:F161)
9.879999999999999I1617.609999999999999J1616.74K16110.465000000000002L161NPK 0N16149.4O161
Fórmula=I161*10000/2/1000
38.05P161
Fórmula=J161*10000/2/1000
33.7Q161
Fórmula=K161*10000/2/1000
52.325R161
Fórmula=L161*10000/2/1000
41.35833333S161
Fórmula=AVERAGE(P161:R161)
ResumenY161
3.0A162NPK0 C1B16210.49C162
Fórmula=O63
8.82D162
Fórmula=O69
8.505E162
Fórmula=O75
11.03F162
Fórmula=O81
9.71125G162
Fórmula=AVERAGE(C162:F162)
1.0375H162
Fórmula=G162-$G$161
10.489999999999998I1628.82J1628.504999999999999K16211.03L162NPK0 C1N16252.45O162
Fórmula=I162*10000/2/1000
44.1P162
Fórmula=J162*10000/2/1000
42.525Q162
Fórmula=K162*10000/2/1000
55.15R162
Fórmula=L162*10000/2/1000
47.25833333S162
Fórmula=AVERAGE(P162:R162)
5.9T162
Fórmula=S162-$S$161
114.2655652U162
Fórmula=S162/$S$161*100
GruposY162NúmeroZ162SumaAA162PromedioAB162VarianzaAC162
4.0A163NPK0 C2B16310.585C163
Fórmula=O88
10.98D163
Fórmula=O94
12.42E163
Fórmula=O100
11.2F163
Fórmula=O106
11.29625G163
Fórmula=AVERAGE(C163:F163)
2.6225H163
Fórmula=G163-$G$161
10.585I16310.98J16312.42K16311.2L163NPK0 C2N16352.925O163
Fórmula=I163*10000/2/1000
54.9P163
Fórmula=J163*10000/2/1000
62.1Q163
Fórmula=K163*10000/2/1000
56R163
Fórmula=L163*10000/2/1000
57.66666667S163
Fórmula=AVERAGE(P163:R163)
16.30833333T163
Fórmula=S163-$S$161
139.4317953U163
Fórmula=S163/$S$161*100
Fila 1Y1634.0Z163173.475AA16343.36875AB16379.45473958333362AC163
2.0A164NPKB16414.565C164
Fórmula=O38
10.12D164
Fórmula=O44
11.295E164
Fórmula=O50
11.785F164
Fórmula=O56
11.94125G164
Fórmula=AVERAGE(C164:F164)
14.565000000000001I16410.120000000000001J16411.295K16411.785L164NPKN16472.825O164
Fórmula=I164*10000/2/1000
50.6P164
Fórmula=J164*10000/2/1000
56.475Q164
Fórmula=K164*10000/2/1000
58.925R164
Fórmula=L164*10000/2/1000
55.33333333S164
Fórmula=AVERAGE(P164:R164)
Fila 2Y1644.0Z164194.225AA16448.55625AB16438.29098958333331AC164
5.0A165NPK C1B16514.36C165
Fórmula=O113
12.175D165
Fórmula=O119
9.45E165
Fórmula=O125
16.08F165
Fórmula=O131
13.01625G165
Fórmula=AVERAGE(C165:F165)
1.075H165
Fórmula=G165-$G$164
14.36I16512.174999999999999J1659.450000000000001K16516.08L165NPK C1N16571.8O165
Fórmula=I165*10000/2/1000
60.875P165
Fórmula=J165*10000/2/1000
47.25Q165
Fórmula=K165*10000/2/1000
80.4R165
Fórmula=L165*10000/2/1000
62.84166667S165
Fórmula=AVERAGE(P165:R165)
7.508333333T165
Fórmula=S165-$S$164
113.5692771U165
Fórmula=S165/$S$164*100
Fila 3Y1654.0Z165225.925AA16556.48125AB16515.649739583333329AC165
6.0A166NPK C2B16613.74C166
Fórmula=O138
10.76D166
Fórmula=O144
12.595E166
Fórmula=O150
12.595F166
Fórmula=O156
12.4225G166
Fórmula=AVERAGE(C166:F166)
0.48125H166
Fórmula=G166-$G$164
13.739999999999998I16610.76J16612.594999999999999K16612.594999999999999L166NPK C2N16668.7O166
Fórmula=I166*10000/2/1000
53.8P166
Fórmula=J166*10000/2/1000
62.975Q166
Fórmula=K166*10000/2/1000
62.975R166
Fórmula=L166*10000/2/1000
59.91666667S166
Fórmula=AVERAGE(P166:R166)
4.583333333T166
Fórmula=S166-$S$164
108.2831325U166
Fórmula=S166/$S$164*100
Fila 4Y1664.0Z166238.825AA16659.70625AB16688.6922395833335AC166
RS0.05N16713.081T167Fila 5Y1674.0Z167260.325AA16765.08125AB167205.15057291666622AC167
Fila 6Y1684.0Z168248.44999999999996AA16862.11249999999999AB16837.99354166666663AC168
N.º de tratamientoA170Código de tratamientoB170Longitud de las hojas, cm (a la cosecha, media de 5 remolachas)C170MediaG170Respecto a K, %H170Respecto a K, cmI170N.º de tratamientoL170Código de tratamientoM170Diámetro de la raíz, cm (a la cosecha, media de 5 remolachas)N170MediaR170Respecto a K, %S170Respecto a K, cmU170
1.0A171NPK 0B17143.8C17137.2D17141.2E17138.2F17140.1G171
Fórmula=AVERAGE(C171:F171)
1.0L171NPK 0M1717.3N1716.1O1716.4P1717.4Q1716.8R171
Fórmula=AVERAGE(N171:Q171)
ANOVAY171
3.0A172NPK0 C1B17242.2C17244.0D17246.4E17247.0F17244.9G172
Fórmula=AVERAGE(C172:F172)
111.9700748H172
Fórmula=G172/$G$171*100
4.8I172
Fórmula=G172-$G$171
3.0L172NPK0 C1M1727.4N1727.8O1727.8P1727.0Q1727.5R172
Fórmula=AVERAGE(N172:Q172)
110.2941176S172
Fórmula=R172/$R$171*100
0.7U172
Fórmula=R172-$R$171
Fuente de variaciónY172SS (suma de cuadrados)Z172df (grados de libertad)AA172MS (cuadrado medio)AB172FAC172Valor de PAD172F críticoAE172
4.0A173NPK0 C2B17341.4C17344.4D17340.2E17342.0F17342G173
Fórmula=AVERAGE(C173:F173)
104.7381546H173
Fórmula=G173/$G$171*100
1.9I173
Fórmula=G173-$G$171
4.0L173NPK0 C2M1737.1N1736.8O1737.0P1736.7Q1736.9R173
Fórmula=AVERAGE(N173:Q173)
101.4705882S173
Fórmula=R173/$R$171*100
0.1U173
Fórmula=R173-$R$171
Entre gruposY1731394.7092968750005Z1735.0AA173278.9418593750001AB1733.597456308464499AC1730.019754897640893988AD1732.77285315299783AE1734.4028013AF173
Fórmula=SQRT(AB174/4)
2.0A174NPKB17441.0C17444.2D17439.4E17441.6F17441.55G174
Fórmula=AVERAGE(C174:F174)
2.0L174NPKM1747.0N1747.0O1746.6P1747.1Q1746.925R174
Fórmula=AVERAGE(N174:Q174)
Dentro de los gruposY1741395.6954687499995Z17418.0AA17477.53863715277775AB174
5.0A175NPK C1B17546.6C17547.4D17543.0E17547.2F17546.05G175
Fórmula=AVERAGE(C175:F175)
110.8303249H175
Fórmula=G175/$G$174*100
4.5I175
Fórmula=G175-$G$174
5.0L175NPK C1M1757.5N1757.5O1757.4P1757.6Q1757.5R175
Fórmula=AVERAGE(N175:Q175)
108.3032491S175
Fórmula=R175/$R$174*100
0.575U175
Fórmula=R175-$R$174
6.226501311AF175
Fórmula=SQRT(2)*AF173
6.0A176NPK C2B17642.6C17646.2D17645.4E17648.6F17645.7G176
Fórmula=AVERAGE(C176:F176)
109.9879663H176
Fórmula=G176/$G$174*100
4.15I176
Fórmula=G176-$G$174
6.0L176NPK C2M1767.1N1767.9O1767.7P1768.3Q1767.75R176
Fórmula=AVERAGE(N176:Q176)
111.9133574S176
Fórmula=R176/$R$174*100
0.825U176
Fórmula=R176-$R$174
TotalY1762790.404765625Z17623.0AA17613.08139384AF176
Fórmula=TINV(0.05,AA174)*AF175
Desviación de la mediaH1773.397I177Desviación de la mediaT1770.577U177
Anova: Factor únicoX178
N.º de tratamientoA180Código de tratamientoB180Masa de las hojas, kg (a la cosecha, media de 5 remolachas)C180MediaG180Respecto a K, %H180Respecto a K, kgI180N.º de tratamientoL180Código de tratamientoM180Brix, % (a la cosecha, media de 5 remolachas)N180MediaR180Respecto a K, %S180%U180ResumenX180
1.0A181NPK 0B1810.097C1810.062D1810.07500000000000001E1810.071F1810.07625G181
Fórmula=AVERAGE(C181:F181)
1.0L181NPK 0M1819.1N18110.3O18110.6P18110.8Q18110.2R181
Fórmula=AVERAGE(N181:Q181)
GruposX181NúmeroY181SumaZ181PromedioAA181VarianzaAB181
3.0A182NPK0 C1B1820.092C1820.07400000000000001D1820.076E1820.095F1820.08425G182
Fórmula=AVERAGE(C182:F182)
110.4918033H182
Fórmula=G182/$G$181*100
0.008I182
Fórmula=G182-$G$181
3.0L182NPK0 C1M18210.7N18211.2O18210.7P18211.7Q18211.075R182
Fórmula=AVERAGE(N182:Q182)
108.5784314S182
Fórmula=R182/$R$181*100
0.875U182
Fórmula=R182-$R$181
Fila 1X1824.0Y182160.4Z18240.1AA1828.97333333333332AB182
4.0A183NPK0 C2B1830.122C1830.31899999999999995D1830.099E1830.12400000000000003F1830.166G183
Fórmula=AVERAGE(C183:F183)
217.704918H183
Fórmula=G183/$G$181*100
0.08975I183
Fórmula=G183-$G$181
4.0L183NPK0 C2M18312.0N18311.1O18310.9P1838.8Q18310.7R183
Fórmula=AVERAGE(N183:Q183)
104.9019608S183
Fórmula=R183/$R$181*100
0.5U183
Fórmula=R183-$R$181
Fila 2X1834.0Y183179.6Z18344.9AA1834.919999999999994AB183
2.0A184NPKB1840.085C1840.10600000000000001D1840.07899999999999999E1840.081F1840.08775G184
Fórmula=AVERAGE(C184:F184)
2.0L184NPKM18411.0N18410.8O18412.1P18412.6Q18411.625R184
Fórmula=AVERAGE(N184:Q184)
Fila 3X1844.0Y184168.0Z18442.0AA1843.119999999999995AB184
5.0A185NPK C1B1850.11099999999999999C1850.10699999999999998D1850.11100000000000002E1850.119F1850.112G185
Fórmula=AVERAGE(C185:F185)
127.6353276H185
Fórmula=G185/$G$184*100
0.02425I185
Fórmula=G185-$G$184
5.0L185NPK C1M18512.5N18512.0O18511.6P18511.5Q18511.9R185
Fórmula=AVERAGE(N185:Q185)
102.3655914S185
Fórmula=R185/$R$184*100
0.275U185
Fórmula=R185-$R$184
Fila 4X1854.0Y185166.2Z18541.55AA1853.983333333333341AB185
6.0A186NPK C2B1860.10699999999999998C1860.127D1860.14600000000000002E1860.137F1860.12925G186
Fórmula=AVERAGE(C186:F186)
147.2934473H186
Fórmula=G186/$G$184*100
0.0415I186
Fórmula=G186-$G$184
6.0L186NPK C2M18611.0N18611.0O18612.3P18611.5Q18611.45R186
Fórmula=AVERAGE(N186:Q186)
98.49462366S186
Fórmula=R186/$R$184*100
-0.175U186
Fórmula=R186-$R$184
Fila 5X1864.0Y186184.2Z18646.05AA1864.250000000000001AB186
Desviación de la mediaH1870.065I187Desviación de la mediaT1871.209U187Fila 6X1874.0Y187182.8Z18745.7AA1876.120000000000001AB187
N.º de tratamientoA189Código de tratamientoB189Masa de raíces, kg (a la cosecha, media de 5 remolachas)C189MediaG189Respecto a K, %H189Respecto a K, kgI189
1.0A190NPK 0B1900.20099999999999998C1900.16D1900.156E1900.219F1900.184G190
Fórmula=AVERAGE(C190:F190)
ANOVAX190
3.0A191NPK0 C1B1910.22400000000000003C1910.211D1910.21200000000000002E1910.215F1910.2155G191
Fórmula=AVERAGE(C191:F191)
117.1195652H191
Fórmula=G191/$G$190*100
0.0315I191
Fórmula=G191-$G$190
Fuente de variaciónX191SS (suma de cuadrados)Y191df (grados de libertad)Z191MS (cuadrado medio)AA191FAB191Valor de PAC191F críticoAD191
4.0A192NPK0 C2B1920.254C1920.252D1920.257E1920.242F1920.25125G192
Fórmula=AVERAGE(C192:F192)
136.548913H192
Fórmula=G192/$G$190*100
0.06725I192
Fórmula=G192-$G$190
Entre gruposX192123.33333333333333Y1925.0Z19224.666666666666664AA1924.7183846971307135AB1920.0062760657457942AC1922.77285315299783AD1921.143216709AE192
Fórmula=SQRT(AA193/4)
2.0A193NPKB1930.22800000000000004C1930.203D1930.20800000000000002E1930.198F1930.20925G193
Fórmula=AVERAGE(C193:F193)
Dentro de los gruposX19394.09999999999995Y19318.0Z1935.227777777777775AA193
5.0A194NPK C1B1940.29900000000000004C1940.281D1940.257E1940.29800000000000004F1940.28375G194
Fórmula=AVERAGE(C194:F194)
135.6033453H194
Fórmula=G194/$G$193*100
0.0745I194
Fórmula=G194-$G$193
1.616752575AE194
Fórmula=SQRT(2)*AE192
6.0A195NPK C2B1950.253C1950.321D1950.28400000000000003E1950.35500000000000004F1950.30325G195
Fórmula=AVERAGE(C195:F195)
144.9223417H195
Fórmula=G195/$G$193*100
0.094I195
Fórmula=G195-$G$193
TotalX195217.43333333333328Y19523.0Z1953.396671119AE195
Fórmula=TINV(0.05,Z193)*AE194
Desviación de la mediaH1960.036I196
Anova: Factor únicoX197
TA-28/25, 30.05.2025B199ResumenX199
Número de identificación asignado por el clienteB200Parámetro y método de ensayoC200GruposX200NúmeroY200SumaZ200PromedioAA200VarianzaAB200
*pH (LVS ISO 10390:2022) en solución de KCl, c = 1 mol/lC201Materia orgánica, % (procedimiento del Ministerio de Agricultura n.º 1 del 4 de enero de 2022, anexo 5, método 1)D201Fósforo extraíble P2O5, mg/kg (método Egner–Riehm)E201Potasio extraíble K2O, mg/kg (método Egner–Riehm)F201Fila 1X2014.0Y2010.305Z2010.07625AA2010.00022091666666666787AB201
RemolachaB2025.27C2022.52D202238.75E202369.5F202Fila 2X2024.0Y2020.33699999999999997Z2020.08424999999999999AA2020.00011625000000000292AB202
Fila 3X2034.0Y2030.6639999999999999Z2030.16599999999999998AA2030.010532666666666657AB203
Fila 4X2044.0Y2040.35100000000000003Z2040.08775000000000001AA2040.00015424999999999814AB204
GrandesC205Tamaño medianoF205PequeñoI205Fila 5X2054.0Y2050.44799999999999995Z2050.11199999999999999AA2052.533333333333336e-05AB205
unidadesC206kgD206% del número totalE206unidadesF206kgG206% del número totalH206unidadesI206kgJ206% del número totalK206Número total, unidadesL206Total kgM206Fila 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.970625000000001M210Fuente de variaciónX210SS (suma de cuadrados)Y210df (grados de libertad)Z210MS (cuadrado medio)AA210FAB210Valor de PAC210F críticoAD210
5.0A211NPK C1B2113.75C2112.16125D2118.264462809917356E21119.625F2113.6468749999999996G21143.25068870523416H21122.0I2110.7J21148.484848484848484K21145.375L2116.508125M211Entre gruposX2110.023217499999999995Y2115.0Z2110.004643499999999999AA2112.4591191267763106AB2110.07258289240782158AC2112.77285315299783AD2110.02172715914AE211
Fórmula=SQRT(AA212/4)
6.0A212NPK C2B2122.4C2121.1835D2124.7928107838242635E21221.3F2123.4150000000000005G21242.53619570644034H21226.375I2120.865375J21252.670993509735396K21250.075L2125.463875000000001M212Dentro de los gruposX2120.033988999999999985Y21218.0Z2120.001888277777777777AA212
0.03072684313AE213
Fórmula=SQRT(2)*AE211
TotalX2140.05720649999999998Y21423.0Z2140.06455470196AE214
Fórmula=TINV(0.05,Z212)*AE213
Anova: Factor únicoX216
ResumenX218
GruposX219NúmeroY219SumaZ219PromedioAA219VarianzaAB219
Fila 1X2204.0Y2200.736Z2200.184AA2200.0009579999999999959AB220
Fila 2X2214.0Y2210.862Z2210.2155AA2213.500000000000015e-05AB221
Fila 3X2224.0Y2221.005Z2220.25125AA2224.225000000000008e-05AB222
Fila 4X2234.0Y2230.837Z2230.20925AA2230.000172916666666667AB223
Fila 5X2244.0Y2241.1350000000000002Z2240.28375000000000006AA2240.00038625000000000074AB224
Fila 6X2254.0Y2251.213Z2250.30325AA2250.001962916666666666AB225
ANOVAX228
Fuente de variaciónX229SS (suma de cuadrados)Y229df (grados de libertad)Z229MS (cuadrado medio)AA229FAB229Valor de PAC229F críticoAD229
Entre gruposX2300.042859333333333346Y2305.0Z2300.008571866666666669AA23014.457796101949022AB2309.122691996504591e-06AC2302.77285315299783AD2300.01217465491AE230
Fórmula=SQRT(AA231/4)
Dentro de los gruposX2310.010672000000000006Y23118.0Z2310.0005928888888888892AA231
0.01721756209AE232
Fórmula=SQRT(2)*AE230
TotalX2330.053531333333333354Y23323.0Z2330.03617275568AE233
Fórmula=TINV(0.05,Z231)*AE232
Anova: Factor únicoX236
ResumenX238
GruposX239NúmeroY239SumaZ239PromedioAA239VarianzaAB239
Fila 1X2404.0Y24027.199999999999996Z2406.799999999999999AA2400.42000000000000015AB240
Fila 2X2414.0Y24130.0Z2417.5AA2410.14666666666666658AB241
Fila 3X2424.0Y24227.599999999999998Z2426.8999999999999995AA2420.03333333333333328AB242
Fila 4X2434.0Y24327.700000000000003Z2436.925000000000001AA2430.0491666666666667AB243
Fila 5X2444.0Y24430.0Z2447.5AA2440.006666666666666619AB244
Fila 6X2454.0Y24531.0Z2457.75AA2450.25000000000000044AB245
ANOVAX248
Fuente de variaciónX249SS (suma de cuadrados)Y249df (grados de libertad)Z249MS (cuadrado medio)AA249FAB249Valor de PAC249F críticoAD249
Entre gruposX2503.212083333333333Y2505.0Z2500.6424166666666666AA2504.255197792088315AB2500.009926178291078318AC2502.77285315299783AD2500.1942757204AE250
Fórmula=SQRT(AA251/4)
Dentro de los gruposX2512.717500000000001Y25118.0Z2510.15097222222222229AA251
0.2747473587AE252
Fórmula=SQRT(2)*AE250
TotalX2535.929583333333334Y25323.0Z2530.5772227814AE253
Fórmula=TINV(0.05,Z251)*AE252
Anova: Factor únicoV255
ResumenV257
GruposV258NúmeroX258SumaY258PromedioZ258VarianzaAA258
Fila 1V2594.0X25940.8Y25910.2Z2590.5800000000000005AA259
Fila 2V2604.0X26044.3Y26011.075Z2600.22916666666666666AA260
Fila 3V2614.0X26142.8Y26110.7Z2611.8333333333333524AA261
Fila 4V2624.0X26246.5Y26211.625Z2620.749166666666666AA262
Fila 5V2634.0X26347.6Y26311.9Z2630.20666666666666675AA263
Fila 6V2644.0X26445.8Y26411.45Z2640.3766666666666671AA264
ANOVAV267
Fuente de variaciónV268SS (suma de cuadrados)X268df (grados de libertad)Y268MS (cuadrado medio)Z268FAA268Valor de PAB268F críticoAC268
Entre gruposV2697.953333333333331X2695.0Y2691.5906666666666662Z2692.4010062893081754AA2690.07785755194524464AB2692.77285315299783AC2690.4069705149AD269
Fórmula=SQRT(Z270/4)
Dentro de los gruposV27011.924999999999999X27018.0Y2700.6625Z270
0.5755432217AD271
Fórmula=SQRT(2)*AD269
TotalV27219.87833333333333X27223.0Y2721.209171439AD272
Fórmula=TINV(0.05,Y270)*AD271

Hoja de cálculo: lechuga

Tabla 2
InvernaderoB1
Plantado el 7.08.2025.B2
Cosecha de biomasa fresca y lavado de raícesB306.09.2025./09.09.2025.F3
Mediciones y observaciones, lechugaB5
PlantasB6Código de tratamientoC6Biomasa fresca por planta, gD6Materia seca por planta, % (Reglamento del Consejo de Ministros n.º 518)E6Longitud de las hojas, cmF6Número de hojasG6Diámetro del cuello de la raíz, mmH6Longitud de la raíz, cmI6Proteína en materia seca, % (análisis elemental, combustión seca)J6Fibra bruta en materia seca, % (ISO 5498:1981)K6Potasio en materia seca, % (LVS EN ISO 6869:2002)L6Calcio en materia seca, % (GOST 26570-95)M6Magnesio en materia seca, % (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
MediaC171.174D17
Fórmula=AVERAGE(D7:D16)
13.187E17
Fórmula=AVERAGE(E7:E16)
4.4F17
Fórmula=AVERAGE(F7:F16)
5.1G17
Fórmula=AVERAGE(G7:G16)
0.22H17
Fórmula=AVERAGE(H7:H16)
12.8I17
Fórmula=AVERAGE(I7:I16)
15.74J17ningunoK173.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
MediaC281.349D28
Fórmula=AVERAGE(D18:D27)
14.12E28
Fórmula=AVERAGE(E18:E27)
4.55F28
Fórmula=AVERAGE(F18:F27)
4.9G28
Fórmula=AVERAGE(G18:G27)
0.21H28
Fórmula=AVERAGE(H18:H27)
11.6I28
Fórmula=AVERAGE(I18:I27)
14.93J28ningunoK282.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
MediaC391.363D39
Fórmula=AVERAGE(D29:D38)
13.188E39
Fórmula=AVERAGE(E29:E38)
4.45F39
Fórmula=AVERAGE(F29:F38)
5.1G39
Fórmula=AVERAGE(G29:G38)
0.21H39
Fórmula=AVERAGE(H29:H38)
14.65I39
Fórmula=AVERAGE(I29:I38)
16.12J39ningunoK393.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
MediaC5070.208D50
Fórmula=AVERAGE(D40:D49)
5.447E50
Fórmula=AVERAGE(E40:E49)
18.45F50
Fórmula=AVERAGE(F40:F49)
11.7G50
Fórmula=AVERAGE(G40:G49)
1.035H50
Fórmula=AVERAGE(H40:H49)
20.8I50
Fórmula=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
MediaC6165.068D61
Fórmula=AVERAGE(D51:D60)
5.243E61
Fórmula=AVERAGE(E51:E60)
18.05F61
Fórmula=AVERAGE(F51:F60)
12G61
Fórmula=AVERAGE(G51:G60)
0.985H61
Fórmula=AVERAGE(H51:H60)
18.15I61
Fórmula=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
MediaC7277.407D72
Fórmula=AVERAGE(D62:D71)
5.01E72
Fórmula=AVERAGE(E62:E71)
20.45F72
Fórmula=AVERAGE(F62:F71)
12.5G72
Fórmula=AVERAGE(G62:G71)
0.955H72
Fórmula=AVERAGE(H62:H71)
20.65I72
Fórmula=AVERAGE(I62:I71)
36.64J7212.96K727.92L720.6M720.79N72
Datos medios, lechugaC74
Código de tratamientoC75Biomasa fresca por planta, gD75% respecto a KE75Materia seca por planta, % (Reglamento del Consejo de Ministros n.º 518)F75% respecto a KG75Longitud de las hojas, cmH75Número de hojasI75Diámetro del cuello de la raíz, mmJ75% respecto a KK75Longitud de la raíz, cm (difícil eliminar la turba al lavar)L75% respecto a KM75Proteína en materia seca, % (análisis elemental, combustión seca)N75% respecto a KO75Fibra bruta en materia seca, % (ISO 5498:1981)P75Potasio en materia seca, % (LVS EN ISO 6869:2002)Q75Calcio en materia seca, % (GOST 26570-95)R75Magnesio en materia seca, % (GOST 26570-95)S75
KC761.174D7613.187000000000001F764.4H765.1I760.22000000000000003J7612.8L7615.74N76ningunoP763.42Q761.32R760.23S76
C1C771.35D77114.9914821E77
Fórmula=D77/$D$76*100
14.12F77107.0751498G77
Fórmula=F77/$F$76*100
4.55H774.9I770.21000000000000002J7795.45454545K77
Fórmula=J77/$J$76*100
11.6L7790.625M77
Fórmula=L77/$L$76*100
14.93N7794.85387548O77
Fórmula=N77/$N$76*100
ningunoP772.98Q771.32R770.3S77
C2C781.363D78116.0988075E78
Fórmula=D78/$D$76*100
13.187999999999999F78100.0075832G78
Fórmula=F78/$F$76*100
4.45H785.1I780.20999999999999996J7895.45454545K78
Fórmula=J78/$J$76*100
14.65L78114.453125M78
Fórmula=L78/$L$76*100
16.12N78102.4142313O78
Fórmula=N78/$N$76*100
ningunoP783.21Q781.28R780.31S78
NPKC7970.208D795.447F7918.45H7911.7I791.0350000000000001J7920.8L7937.39N7912.79P797.7Q790.52R790.68S79
NPK C1C8065.06800000000001D8092.67889699E80
Fórmula=D80/$D$79*100
5.243F8096.25481917G80
Fórmula=F80/$F$79*100
18.05H8012.0I800.9850000000000001J8095.16908213K80
Fórmula=J80/$J$79*100
18.15L8087.25961538M80
Fórmula=L80/$L$79*100
39.59N80105.8839262O80
Fórmula=N80/$N$79*100
12.57P807.27Q800.45R800.74S80
NPK C2C8177.407D81110.2538172E81
Fórmula=D81/$D$79*100
5.01F8191.97723518G81
Fórmula=F81/$F$79*100
20.45H8112.5I810.9549999999999998J8192.2705314K81
Fórmula=J81/$J$79*100
20.65L8199.27884615M81
Fórmula=L81/$L$79*100
36.64N8197.99411607O81
Fórmula=N81/$N$79*100
12.96P817.92Q810.6R810.79S81
Informe de pruebasB83TN-103/25E8307.10.25.F83
LechugaB84
Número de identificación asignado por el clienteB85Parámetro y método de ensayoC85
Materia seca, % (Reglamento del Consejo de Ministros n.º 518)C86Proteína en materia seca, % (análisis elemental, combustión seca)D86Fibra bruta en materia seca, % (ISO 5498:1981)E86Potasio en materia seca, % (LVS EN ISO 6869:2002)F86Calcio en materia seca, % (GOST 26570-95)G86Magnesio en materia seca, % (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

Hoja de cálculo: Patatas

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

Hoja de cálculo: Guisantes

Tabla 4
Guisantes 1 en sustratoB3Guisantes 2 en sueloAB325.11.2025. AdriansAD3
PlantasB4Código de tratamientoC4Biomasa fresca por planta, gD4Biomasa fresca por maceta, gJ4Biomasa fresca media por planta, gK4Calculado a partir del total de la macetaL4Longitud de la raíz, cmM4MediaS4Materia seca, % (Reglamento del Consejo de Ministros n.º 518)T4Proteína en materia seca, % (análisis elemental, combustión seca)U4Fibra bruta en materia seca, % (ISO 5498:1981)V4Potasio en materia seca, % (LVS EN ISO 6869:2002)W4Fósforo en materia seca, g/kg (ISO 6491:1998)X4NDF en materia seca, % (LVS EN ISO 16472:2006)Y4ADF en materia seca, % (ISO 13906:2008)Z4PlantasAB4Código de tratamientoAC4Biomasa fresca por planta, gAD4Materia seca, %AE4Longitud de la planta, cmAF4Número de zarcillos, unidadesAG4Longitud de la raíz, cmAH4Masa de raíces, gAI4Materia seca, %AJ4
1.0B5K 1C54.82D55.36E53.15F54.03G52.75H5ningunoI520.06J54.022K5
Fórmula=AVERAGE(D5:I5)
20.11L5
Fórmula=SUM(D5:I5)
38.0M537.0N531.0O540.0P548.0Q533.0R537.83333333S5
Fórmula=AVERAGE(M5:R5)
28.19T51.0AB5KAC510.95AD518.26AE559.0AF515.0AG519.5AH510.15AI512.02AJ5OídioAK5
2.0B6K 2C63.91D63.45E62.73F63.6G63.82H63.4I620.85J63.485K6
Fórmula=AVERAGE(D6:I6)
20.91L6
Fórmula=SUM(D6:I6)
37.5M625.0N633.0O639.0P650.0Q629.0R635.58333333S6
Fórmula=AVERAGE(M6:R6)
25.97T62.0AB6KAC613.7AD617.01AE672.0AF616.0AG627.2AH66.81AI610.13AJ6OídioAK6
3.0B7K 3C72.95D71.26E72.65F73.01G74.18H74.05I718.03J73.016666667K7
Fórmula=AVERAGE(D7:I7)
18.1L7
Fórmula=SUM(D7:I7)
37.0M732.0N737.0O733.0P734.0Q725.0R733S7
Fórmula=AVERAGE(M7:R7)
26.85T73.0AB7KAC76.82AD716.86AE741.0AF715.0AG721.0AH75.57AI79.87AJ7OídioAK7
4.0B8K 4C82.54D83.84E83.65F83.12G82.99H83.04I819.1J83.196666667K8
Fórmula=AVERAGE(D8:I8)
19.18L8
Fórmula=SUM(D8:I8)
31.5M834.0N824.5O835.5P835.0Q833.0R832.25S8
Fórmula=AVERAGE(M8:R8)
25.55T84.0AB8KAC89.84AD820.43AE860.0AF815.0AG824.1AH88.17AI810.53AJ8
5.0B9K 5C92.69D93.15E94.31F93.45G93.2H92.88I919.3J93.28K9
Fórmula=AVERAGE(D9:I9)
19.68L9
Fórmula=SUM(D9:I9)
25.41T9MediaAC910.3275AD9
Fórmula=AVERAGE(AD5:AD8)
18.14AE9
Fórmula=AVERAGE(AE5:AE8)
58AF9
Fórmula=AVERAGE(AF5:AF8)
15.25AG9
Fórmula=AVERAGE(AG5:AG8)
22.95AH9
Fórmula=AVERAGE(AH5:AH8)
7.675AI9
Fórmula=AVERAGE(AI5:AI8)
10.6375AJ9
Fórmula=AVERAGE(AJ5:AJ8)
6.0B10K 6C103.44D103.44E103.21F104.14G103.75H102.01I1020.02J103.331666667K10
Fórmula=AVERAGE(D10:I10)
19.99L10
Fórmula=SUM(D10:I10)
27.53T101.0AB10C1AC1013.08AD1015.83AE1072.0AF1016.0AG1028.2AH107.28AI1010.99AJ10OídioAK10
7.0B11K 7C113.0D113.78E113.8F114.43G112.62H112.8I1120.4J113.405K11
Fórmula=AVERAGE(D11:I11)
20.43L11
Fórmula=SUM(D11:I11)
25.45T112.0AB11C1AC1111.85AD1118.65AE1165.5AF1116.0AG1118.0AH118.32AI1110.22AJ11OídioAK11
8.0B12K 8C121.55D120.98E123.91F123.48G121.95H121.96I1213.82J122.305K12
Fórmula=AVERAGE(D12:I12)
13.83L12
Fórmula=SUM(D12:I12)
24.73T123.0AB12C1AC1212.81AD1219.75AE1267.0AF1215.0AG1225.2AH129.17AI1212.1AJ12OídioAK12
9.0B13K 9C132.58D134.12E134.59F131.26G134.28H13ningunoI1316.81J133.366K13
Fórmula=AVERAGE(D13:I13)
16.83L13
Fórmula=SUM(D13:I13)
23.95T134.0AB13C1AC1312.17AD1319.06AE1370.5AF1316.0AG1323.7AH137.81AI1311.65AJ13OídioAK13
10.0B14K 10C142.49D143.52E144.44F143.88G143.17H142.65I1420.1J143.358333333K14
Fórmula=AVERAGE(D14:I14)
20.15L14
Fórmula=SUM(D14:I14)
25.46T14MediaAC1412.4775AD14
Fórmula=AVERAGE(AD10:AD13)
18.3225AE14
Fórmula=AVERAGE(AE10:AE13)
68.75AF14
Fórmula=AVERAGE(AF10:AF13)
15.75AG14
Fórmula=AVERAGE(AG10:AG13)
23.775AH14
Fórmula=AVERAGE(AH10:AH13)
8.145AI14
Fórmula=AVERAGE(AI10:AI13)
11.24AJ14
Fórmula=AVERAGE(AJ10:AJ13)
MediaC1518.849J15
Fórmula=AVERAGE(J5:J14)
3.276633333K15
Fórmula=AVERAGE(K5:K14)
18.921L15
Fórmula=AVERAGE(L5:L14)
34.66666667S15
Fórmula=AVERAGE(S5:S14)
25.909T15
Fórmula=AVERAGE(T5:T14)
17.82U1530.99V151.97W151.59X1546.33Y1541.41Z151.0AB15C2AC1510.26AD1521.83AE1563.5AF1515.0AG1525.9AH157.05AI1511.49AJ15OídioAK15
21.0B16C1 1C163.37D162.49E163.27F163.44G164.0H163.25I1619.81J163.303333333K16
Fórmula=AVERAGE(D16:I16)
19.82L16
Fórmula=SUM(D16:I16)
29.0M1632.0N1639.0O1632.0P1629.0Q1634.0R1632.5S16
Fórmula=AVERAGE(M16:R16)
24.97T162.0AB16C2AC1610.25AD1623.12AE1667.0AF1615.0AG1622.4AH167.9AI1611.14AJ16OídioAK16
22.0B17C1 2C173.75D173.88E172.78F173.79G173.86H173.04I1721.07J176.024285714K17
Fórmula=AVERAGE(D17:J17)
21.1L17
Fórmula=SUM(D17:I17)
39.0M1740.0N1727.0O1740.0P1727.0Q1738.0R1735.16666667S17
Fórmula=AVERAGE(M17:R17)
25.83T173.0AB17C2AC1713.96AD1720.56AE1773.0AF1716.0AG1718.8AH1710.4AI1712.6AJ17OídioAK17
23.0B18C1 3C183.83D183.3E183.62F182.65G182.21H183.37I1818.92J185.414285714K18
Fórmula=AVERAGE(D18:J18)
18.98L18
Fórmula=SUM(D18:I18)
39.0M1835.0N1833.0O1836.0P1833.0Q1832.0R1834.66666667S18
Fórmula=AVERAGE(M18:R18)
26.37T184.0AB18C2AC1814.49AD1819.67AE1871.0AF1816.0AG1837.0AH1811.74AI1811.93AJ18OídioAK18
24.0B19C1 4C192.44D193.21E194.86F192.36G192.62H192.71I1918.2J195.2K19
Fórmula=AVERAGE(D19:J19)
18.2L19
Fórmula=SUM(D19:I19)
32.0M1942.0N1934.0O1932.0P1930.0Q1941.0R1935.16666667S19
Fórmula=AVERAGE(M19:R19)
25.66T19MediaAC1912.24AD19
Fórmula=AVERAGE(AD15:AD18)
21.295AE19
Fórmula=AVERAGE(AE15:AE18)
68.625AF19
Fórmula=AVERAGE(AF15:AF18)
15.5AG19
Fórmula=AVERAGE(AG15:AG18)
26.025AH19
Fórmula=AVERAGE(AH15:AH18)
9.2725AI19
Fórmula=AVERAGE(AI15:AI18)
11.79AJ19
Fórmula=AVERAGE(AJ15:AJ18)
25.0B20C1 5C203.63D202.55E201.95F203.75G203.96H203.41I2019.21J205.494285714K20
Fórmula=AVERAGE(D20:J20)
19.25L20
Fórmula=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
Fórmula=AVERAGE(D21:J21)
22.74L21
Fórmula=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
Fórmula=AVERAGE(D22:J22)
18.57L22
Fórmula=SUM(D22:I22)
24.34T223.0AB22N C1AC2214.02AD2221.4AE2264.0AF2219.0AG2223.9AH228.41AI2211.77AJ22
28.0B23C1 8C234.59D234.96E234.33F233.79G233.29H23ningunoI2320.87J236.971666667K23
Fórmula=AVERAGE(D23:J23)
20.96L23
Fórmula=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
Fórmula=AVERAGE(D24:J24)
21.04L24
Fórmula=SUM(D24:I24)
23.57T24MediaAC2413.1AD24
Fórmula=AVERAGE(AD20:AD23)
19.51AE24
Fórmula=AVERAGE(AE20:AE23)
66.7AF24
Fórmula=AVERAGE(AF20:AF23)
16.75AG24
Fórmula=AVERAGE(AG20:AG23)
22.875AH24
Fórmula=AVERAGE(AH20:AH23)
9.2AI24
Fórmula=AVERAGE(AI20:AI23)
13.3475AJ24
Fórmula=AVERAGE(AJ20:AJ23)
30.0B25C1 10C252.82D253.62E253.84F252.65G252.48H252.72I2518.04J255.167142857K25
Fórmula=AVERAGE(D25:J25)
18.13L25
Fórmula=SUM(D25:I25)
24.43T251.0AB25N C2AC2514.85AD2517.04AE2563.4AF2517.0AG2527.0AH2515.16AI2519.13AJ25
MediaC2619.83J26
Fórmula=AVERAGE(J16:J25)
5.5365K26
Fórmula=AVERAGE(K16:K25)
19.879L26
Fórmula=AVERAGE(L16:L25)
34.375S26
Fórmula=AVERAGE(S16:S25)
25.126T26
Fórmula=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
Fórmula=AVERAGE(D27:I27)
19.37L27
Fórmula=SUM(D27:I27)
34.0M2740.0N2741.0O2745.0P2737.0Q2744.0R2740.16666667S27
Fórmula=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
Fórmula=AVERAGE(D28:I28)
18.54L28
Fórmula=SUM(D28:I28)
32.0M2833.0N2835.0O2822.0P2831.0Q2827.0R2830S28
Fórmula=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
Fórmula=AVERAGE(D29:I29)
17.21L29
Fórmula=SUM(D29:I29)
37.0M2930.0N2937.0O2942.0P2934.0Q2932.0R2935.33333333S29
Fórmula=AVERAGE(M29:R29)
22.89T29MediaAC2913.1825AD29
Fórmula=AVERAGE(AD25:AD28)
16.8375AE29
Fórmula=AVERAGE(AE25:AE28)
67.575AF29
Fórmula=AVERAGE(AF25:AF28)
15.5AG29
Fórmula=AVERAGE(AG25:AG28)
27.675AH29
Fórmula=AVERAGE(AH25:AH28)
11.055AI29
Fórmula=AVERAGE(AI25:AI28)
16.315AJ29
Fórmula=AVERAGE(AJ25:AJ28)
34.0B30C2 4C303.48D303.53E304.09F302.21G303.58H302.67I3019.55J303.26K30
Fórmula=AVERAGE(D30:I30)
19.56L30
Fórmula=SUM(D30:I30)
40.0M3042.0N3040.0O3035.0P3039.0Q3033.0R3038.16666667S30
Fórmula=AVERAGE(M30:R30)
25.15T30
35.0B31C2 5C313.54D313.86E313.39F314.23G312.54H313.55I3121.02J313.518333333K31
Fórmula=AVERAGE(D31:I31)
21.11L31
Fórmula=SUM(D31:I31)
25.2T31
36.0B32C2 6C322.89D323.79E323.19F323.33G321.82H322.46I3217.47J322.913333333K32
Fórmula=AVERAGE(D32:I32)
17.48L32
Fórmula=SUM(D32:I32)
23.86T32
37.0B33C2 7C332.56D331.8E333.89F333.23G333.27H331.92I3316.65J332.778333333K33
Fórmula=AVERAGE(D33:I33)
16.67L33
Fórmula=SUM(D33:I33)
24.24T33
38.0B34C2 8C342.64D343.24E343.17F344.83G342.86H342.71I3419.4J343.241666667K34
Fórmula=AVERAGE(D34:I34)
19.45L34
Fórmula=SUM(D34:I34)
24.27T34
39.0B35C2 9C353.2D353.3E352.13F352.48G352.4H351.98I3515.47J352.581666667K35
Fórmula=AVERAGE(D35:I35)
15.49L35
Fórmula=SUM(D35:I35)
24.47T35
40.0B36C2 10C363.02D364.31E363.07F363.82G364.04H362.99I3620.94J363.541666667K36
Fórmula=AVERAGE(D36:I36)
21.25L36
Fórmula=SUM(D36:I36)
23.76T36
MediaC3718.565J37
Fórmula=AVERAGE(J27:J36)
3.102166667K37
Fórmula=AVERAGE(K27:K36)
18.613L37
Fórmula=AVERAGE(L27:L36)
35.91666667S37
Fórmula=AVERAGE(S27:S36)
24.51T37
Fórmula=AVERAGE(T27:T36)
22.22U3724.44V374.28W375.98X3739.25Y3735.66Z37
11.0B38NPK 1C3818.18D3823.11E3814.03F3821.56G3823.2H3819.14I38119.07J3819.87K38
Fórmula=AVERAGE(D38:I38)
119.22L38
Fórmula=SUM(D38:I38)
21.0M3836.0N3834.0O3838.0P3833.0Q3827.0R3831.5S38
Fórmula=AVERAGE(M38:R38)
16.79T38
12.0B39NPK 2C3918.15D3921.09E3919.8F3922.06G3916.57H3921.44I39118.96J3919.85166667K39
Fórmula=AVERAGE(D39:I39)
119.11L39
Fórmula=SUM(D39:I39)
30.0M3939.0N3925.0O3931.0P3929.0Q3930.0R3930.66666667S39
Fórmula=AVERAGE(M39:R39)
17.61T39
13.0B40NPK 3C4020.84D4016.45E4014.7F4010.01G40ningunoH40ningunoI4061.91J4015.5K40
Fórmula=AVERAGE(D40:I40)
62L40
Fórmula=SUM(D40:I40)
34.0M4031.0N4044.0O4034.0P4040.0Q4045.0R4038S40
Fórmula=AVERAGE(M40:R40)
19.42T40
14.0B41NPK 4C4112.61D4114.13E4112.41F4115.13G41ningunoH41ningunoI4154.17J4113.57K41
Fórmula=AVERAGE(D41:I41)
54.28L41
Fórmula=SUM(D41:I41)
33.0M4134.0N4135.0O4131.0P4133.0Q4139.0R4134.16666667S41
Fórmula=AVERAGE(M41:R41)
20.03T41
15.0B42NPK 5C422.25D4211.17E427.68F428.2G428.1H4210.32I4247.61J427.953333333K42
Fórmula=AVERAGE(D42:I42)
47.72L42
Fórmula=SUM(D42:I42)
21.84T42
16.0B43NPK 6C4315.15D4317.8E4325.4F4322.08G4323.61H4325.42I43129.3J4321.57666667K43
Fórmula=AVERAGE(D43:I43)
129.46L43
Fórmula=SUM(D43:I43)
17.32T43
17.0B44NPK 7C4410.41D448.51E4412.81F446.87G449.41H445.35I4453.29J448.893333333K44
Fórmula=AVERAGE(D44:I44)
53.36L44
Fórmula=SUM(D44:I44)
22.41T44
18.0B45NPK 8C457.34D4512.36E457.03F4511.21G4510.4H453.48I4551.63J458.636666667K45
Fórmula=AVERAGE(D45:I45)
51.82L45
Fórmula=SUM(D45:I45)
20.98T45
19.0B46NPK 9C469.66D467.62E4610.82F468.75G467.82H468.42I4653.02J468.848333333K46
Fórmula=AVERAGE(D46:I46)
53.09L46
Fórmula=SUM(D46:I46)
21.98T46
20.0B47NPK 10C47No germinóD47-T47
MediaC4876.55111111J48
Fórmula=AVERAGE(J38:J47)
13.85555556K48
Fórmula=AVERAGE(K38:K47)
76.67333333L48
Fórmula=AVERAGE(L38:L47)
33.58333333S48
Fórmula=AVERAGE(S38:S47)
19.82T48
Fórmula=AVERAGE(T38:T47)
22.81U4826.1V484.35W486.67X4842.2Y4835.35Z48
41.0B49NPK C1 1C4917.24D4931.76E4925.29F499.71G4910.18H4920.72I49114.88J4932.82571429K49
Fórmula=AVERAGE(D49:J49)
114.9L49
Fórmula=SUM(D49:I49)
39.0M4935.0N4937.0O4931.0P4927.0Q4926.0R4932.5S49
Fórmula=AVERAGE(M49:R49)
14.36T49
42.0B50NPK C1 2C5010.32D5013.69E506.73F507.8G5010.65H5013.83I5063.0J5018.00285714K50
Fórmula=AVERAGE(D50:J50)
63.02L50
Fórmula=SUM(D50:I50)
29.0M5033.0N5030.0O5032.0P5035.0Q5035.0R5032.33333333S50
Fórmula=AVERAGE(M50:R50)
17.9T50
43.0B51NPK C1 3C5110.93D5112.48E517.21F5112.12G5111.68H515.9I5160.3J5117.23142857K51
Fórmula=AVERAGE(D51:J51)
60.32L51
Fórmula=SUM(D51:I51)
42.0M5129.0N5128.0O5126.0P5127.0Q5139.0R5131.83333333S51
Fórmula=AVERAGE(M51:R51)
17.36T51
44.0B52NPK C1 4C5217.75D5223.35E5214.99F5220.0G5216.37H5220.92I52113.32J5232.38571429K52
Fórmula=AVERAGE(D52:J52)
113.38L52
Fórmula=SUM(D52:I52)
21.0M5226.0N5230.0O5224.0P5238.0Q5240.0R5229.83333333S52
Fórmula=AVERAGE(M52:R52)
15.51T52
45.0B53NPK C1 5C5315.15D5320.93E5310.12F5317.46G5320.03H536.08I5389.75J5325.64571429K53
Fórmula=AVERAGE(D53:J53)
89.77L53
Fórmula=SUM(D53:I53)
15.86T53
46.0B54NPK C1 6C5414.19D549.51E5417.65F5419.5G5415.11H5416.18I5492.11J5426.32142857K54
Fórmula=AVERAGE(D54:J54)
92.14L54
Fórmula=SUM(D54:I54)
15.23T54
47.0B55NPK C1 7C5512.95D5514.11E5513.29F5510.21G5515.74H5512.4I5578.68J5522.48285714K55
Fórmula=AVERAGE(D55:J55)
78.7L55
Fórmula=SUM(D55:I55)
17.64T55
48.0B56NPK C1 8C5612.75D5616.26E5610.81F560.6G5613.85H5610.9I5665.14J5618.61571429K56
Fórmula=AVERAGE(D56:J56)
65.17L56
Fórmula=SUM(D56:I56)
18.26T56
49.0B57NPK C1 9C5715.72D5720.3E5722.75F5719.4G5718.55H5712.62I57109.31J5731.23571429K57
Fórmula=AVERAGE(D57:J57)
109.34L57
Fórmula=SUM(D57:I57)
15.79T57
50.0B58NPK C1 10C5811.31D5810.07E586.42F586.45G586.74H5812.1I5853.05J5815.16285714K58
Fórmula=AVERAGE(D58:J58)
53.09L58
Fórmula=SUM(D58:I58)
19.04T58
MediaC5983.954J59
Fórmula=AVERAGE(J49:J58)
23.991K59
Fórmula=AVERAGE(K49:K58)
83.983L59
Fórmula=AVERAGE(L49:L58)
31.625S59
Fórmula=AVERAGE(S49:S58)
16.695T59
Fórmula=AVERAGE(T49:T58)
17.61U5929.93V591.97W591.54X5947.45Y5943.37Z59
51.0B60NPK C2 1C605.46D607.4E6025.19F6017.26G6012.66H6018.63I6086.57J6024.73857143K60
Fórmula=AVERAGE(D60:J60)
86.6L60
Fórmula=SUM(D60:I60)
27.0M6030.0N6033.0O6029.0P6032.0Q6031.0R6030.33333333S60
Fórmula=AVERAGE(M60:R60)
14.24T60
52.0B61NPK C2 2C6119.39D617.12E6120.75F6123.02G6121.91H6192.15J6130.72333333K61
Fórmula=AVERAGE(D61:J61)
92.19L61
Fórmula=SUM(D61:I61)
33.0M6140.0N6129.0O6137.0P6133.0Q6140.0R6135.33333333S61
Fórmula=AVERAGE(M61:R61)
14.74T61
53.0B62NPK C2 3C6215.75D6224.0E629.21F6222.84G6214.77H6226.55I62113.1J6232.31714286K62
Fórmula=AVERAGE(D62:J62)
113.12L62
Fórmula=SUM(D62:I62)
31.0M6239.0N6226.0O6232.0P6236.0Q6230.0R6232.33333333S62
Fórmula=AVERAGE(M62:R62)
14.07T62
54.0B63NPK C2 4C6328.11D6324.95E6323.48F6316.06G6321.37H6320.73I63134.65J6338.47857143K63
Fórmula=AVERAGE(D63:J63)
134.7L63
Fórmula=SUM(D63:I63)
31.0M6331.0N6328.0O6332.0P6336.0Q6324.0R6330.33333333S63
Fórmula=AVERAGE(M63:R63)
14.27T63
55.0B64NPK C2 5C6419.05D646.41E6425.1F6417.94G6427.08H6427.78I64123.33J6435.24142857K64
Fórmula=AVERAGE(D64:J64)
123.36L64
Fórmula=SUM(D64:I64)
14.55T64
56.0B65NPK C2 6C6522.09D6514.13E6518.89F659.95G6518.12H6521.51I65104.66J6529.90714286K65
Fórmula=AVERAGE(D65:J65)
104.69L65
Fórmula=SUM(D65:I65)
14.36T65
57.0B66NPK C2 7C6626.46D6621.46E6622.79F6627.29G6619.88H66117.85J6639.28833333K66
Fórmula=AVERAGE(D66:J66)
117.88L66
Fórmula=SUM(D66:I66)
14.23T66
58.0B67NPK C2 8C6714.65D6712.57E673.92F675.57G6724.32H6726.84I6787.86J6725.10428571K67
Fórmula=AVERAGE(D67:J67)
87.87L67
Fórmula=SUM(D67:I67)
14.77T67
59.0B68NPK C2 9C6819.13D6829.93E6817.94F6867.0J6822.33333333K68
Fórmula=AVERAGE(D68:I68)
67L68
Fórmula=SUM(D68:I68)
14.81T68
60.0B69NPK C2 10C6917.57D6928.22E6914.91F6914.94G6922.33H6997.94J6932.65166667K69
Fórmula=AVERAGE(D69:J69)
97.97L69
Fórmula=SUM(D69:I69)
15.18T69
MediaC70102.511J70
Fórmula=AVERAGE(J60:J69)
31.07838095K70
Fórmula=AVERAGE(K60:K69)
102.538L70
Fórmula=AVERAGE(L60:L69)
32.08333333S70
Fórmula=AVERAGE(S60:S69)
14.522T70
Fórmula=AVERAGE(T60:T69)
18.6U7030.36V702.08W701.51X7046.18Y7039.7Z70
Guisantes 1 en sustrato, resumenB72
Código de tratamientoB73Biomasa fresca por maceta, gC73% respecto a KD73Biomasa fresca media por planta, gE73% respecto a KF73Longitud media de la raíz, cmG73% respecto a KH73Materia seca, % (Reglamento del Consejo de Ministros n.º 518)I73% respecto a KJ73Proteína en materia seca, % (análisis elemental, combustión seca)K73% respecto a KL73Fibra bruta en materia seca, % (ISO 5498:1981)M73% respecto a KN73Potasio en materia seca, % (LVS EN ISO 6869:2002)O73Fósforo en materia seca, g/kg (ISO 6491:1998)P73NDF en materia seca, % (LVS EN ISO 16472:2006)Q73% respecto a KR73ADF en materia seca, % (ISO 13906:2008)S73% respecto a KT73
KB7418.848999999999997C743.276633333333333E7434.66666666666667G7425.909I7417.82K7430.99M741.97O741.59P7446.33Q7441.41S74
C1B7519.830000000000002C75105.2045201D75
Fórmula=C75/$C$74*100
5.5365E75168.9691655F75
Fórmula=E75/$E$74*100
34.37499999999999G7599.15865385H75
Fórmula=G75/$G$74*100
25.125999999999998I7596.97788413J75
Fórmula=I75/$I$74*100
25.04K75140.5162738L75
Fórmula=K75/$K$74*100
22.95M7574.05614714N75
Fórmula=M75/$M$74*100
4.6O756.73P7538.41Q7582.90524498R75
Fórmula=Q75/$Q$74*100
31.4S7575.8270949T75
Fórmula=S75/$S$74*100
C2B7618.565C7698.49328877D76
Fórmula=C76/$C$74*100
3.1021666666666667E7694.67542905F76
Fórmula=E76/$E$74*100
35.916666666666664G76103.6057692H76
Fórmula=G76/$G$74*100
24.51I7694.60033193J76
Fórmula=I76/$I$74*100
22.22K76124.691358L76
Fórmula=K76/$K$74*100
24.44M7678.86414973N76
Fórmula=M76/$M$74*100
4.28O765.98P7639.25Q7684.71832506R76
Fórmula=Q76/$Q$74*100
35.66S7686.11446511T76
Fórmula=S76/$S$74*100
NPKB7776.5511111111111C7713.855555555555556E7733.583333333333336G7719.819999999999997I7722.81K7726.1M774.35O776.67P7742.2Q7735.35S77
NPK C1B7883.954C78109.6705179D78
Fórmula=C78/$C$77*100
23.991000000000003E78173.1507618F78
Fórmula=E78/$E$77*100
31.625G7894.16873449H78
Fórmula=G78/$G$77*100
16.695I7884.23309788J78
Fórmula=I78/$I$77*100
17.61K7877.20298115L78
Fórmula=K78/$K$77*100
29.93M78114.6743295N78
Fórmula=M78/$M$77*100
1.97O781.54P7847.45Q78112.4407583R78
Fórmula=Q78/$Q$77*100
43.37S78122.6874116T78
Fórmula=S78/$S$77*100
NPK C2B79102.51100000000001C79133.9118381D79
Fórmula=C79/$C$77*100
31.07838095238095E79224.3026693F79
Fórmula=E79/$E$77*100
32.083333333333336G7995.53349876H79
Fórmula=G79/$G$77*100
14.522I7973.26942482J79
Fórmula=I79/$I$77*100
18.6K7981.54318281L79
Fórmula=K79/$K$77*100
30.36M79116.3218391N79
Fórmula=M79/$M$77*100
2.08O791.51P7946.18Q79109.4312796R79
Fórmula=Q79/$Q$77*100
39.7S79112.3055163T79
Fórmula=S79/$S$77*100
Guisantes 2 en el suelo, resumenB81
Código de tratamientoB82Biomasa fresca por planta, gC82% respecto a KD82Materia seca, %E82Longitud de la planta, cmF82% respecto a KG82Número de zarcillos, unidadesH82Código de tratamientoJ82Longitud de la raíz, cmK82% respecto a KL82Masa de raíces, gM82% respecto a KN82Materia seca, %O82
KB8310.3275C8318.14E8358.0F8315.25H83KJ8322.950000000000003K837.675000000000001M8310.64O83
C1B8412.477500000000001C84120.8182038D84
Fórmula=C84/$C$83*100
18.32E8468.75F84118.5344828G84
Fórmula=F84/$F$83*100
15.75H84C1J8423.775000000000002K84103.5947712L84
Fórmula=K84/$K$83*100
8.145000000000001M84106.1237785N84
Fórmula=M84/$M$83*100
11.24O84
C2B8512.24C85118.5185185D85
Fórmula=C85/$C$83*100
21.3E8568.625F85118.3189655G85
Fórmula=F85/$F$83*100
15.5H85C2J8526.025K85113.3986928L85
Fórmula=K85/$K$83*100
9.2725M85120.8143322N85
Fórmula=M85/$M$83*100
11.79O85
N C1B8613.1C86126.8458D86
Fórmula=C86/$C$83*100
19.51E8666.7F86115G86
Fórmula=F86/$F$83*100
16.75H86N C1J8622.875K8699.67320261L86
Fórmula=K86/$K$83*100
9.200000000000001M86119.8697068N86
Fórmula=M86/$M$83*100
13.35O86
N C2B8713.1825C87127.6446381D87
Fórmula=C87/$C$83*100
16.84E8767.57499999999999F87116.5086207G87
Fórmula=F87/$F$83*100
15.5H87N C2J8727.675K87120.5882353L87
Fórmula=K87/$K$83*100
11.055M87144.0390879N87
Fórmula=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
Guisantes 1, plantasC92guisantes 2, plantasM92Guisantes 2, raícesP92
Número de identificación asignado por el clienteC93Parámetro y método de ensayoD93Número de identificación asignado por el clienteM93Parámetro y método de ensayoN93Número de identificación asignado por el clienteP93Parámetro y método de ensayoQ93
Materia seca, % (Reglamento del Consejo de Ministros n.º 518)D94Proteína en materia seca, % (análisis elemental, combustión seca)E94Fibra bruta en materia seca, % (ISO 5498:1981)F94Potasio en materia seca, % (LVS EN ISO 6869:2002)G94Fósforo en materia seca, g/kg (ISO 6491:1998)H94NDF en materia seca, % (LVS EN ISO 16472:2006)I94ADF en materia seca, % (ISO 13906:2008)J94Materia seca, % (Reglamento del Consejo de Ministros n.º 518)N94Materia seca, % (Reglamento del Consejo de Ministros 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
Número de identificación asignado por el clienteC159Parámetro y método de ensayoD159
*pH (LVS ISO 10390:2022) en solución de KCl, c = 1 mol/lD160Materia orgánica, % (procedimiento del Ministerio de Agricultura n.º 1 del 4 de enero de 2022, anexo 5, método 1)E160Fósforo extraíble P2O5, mg/kg (método Egner–Riehm)F160Potasio extraíble K2O, mg/kg (método Egner–Riehm)G160Nitrógeno total, mg/g (LVS EN ISO 11261:2002)H160Humedad, % (LVS EN ISO 11465:2006)I160
SKL1, guisantes, 14.10.25.C1615.81D1612.03E161355.17F161236.5G1610.81H1610.89I161

Hoja de cálculo: Diseño del ensayo

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