{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Apero","Tractor"],"not_rendered":{"charts":3,"images":36,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Apero","index":0,"n_rows":111,"n_cols":34,"rows_kept":111,"cut":false,"hidden":false,"merged":[[64,1,64,2],[33,9,33,10],[18,1,18,2],[43,1,43,2],[33,1,33,2],[20,9,20,10],[23,9,23,10],[42,1,42,2],[34,1,34,2],[41,1,41,2],[47,1,47,2],[60,3,60,6],[19,1,19,2],[29,1,29,2],[26,9,26,10],[4,27,4,31],[40,1,40,2],[22,1,22,2],[3,15,3,16],[8,9,8,10],[38,1,38,2],[25,9,25,10],[3,19,3,20],[3,17,3,18],[3,22,3,23],[14,9,14,10],[12,1,12,2],[13,1,13,2]]}
[]
[null,null,"APERO / MÁQUINA: "]
[]
[null,null,null,"max",{"$f":"+P110","v":240},null,null,null,null,{"$f":"+AC110","v":"Suelo"},{"$f":"+AB110","v":"Resist.esp."},null,null,null,null,"Anchura",null,"Profundidad",null,"Velocidad",null,null,"Amortización"]
[null,null,"Anchura de trabajo:",259,{"$f":"IF(D5<E6,E6,IF(D5<E4,D5,E4))","v":240},"cm",null,null,null,{"$f":"+IF(O110=28, \"sin acond.\", \"baja\")","v":"baja"},{"$f":"+AD111","v":40},false,null,"Apero - máquina arrastrada",null,"Max","Min","Max","Min","Min","Max","Coef.","A1","A2","Mant-rep.","Adqusición","Peso","Hipótesis / Leyenda"]
[null,null,null,"min",{"$f":"+Q110","v":40},null,null,null,null,{"$f":"+IF(O110=28, \"con acond.\", \"media\")","v":"media"},{"$f":"+AE111","v":60},true,null,null,null,"cm","cm","cm","cm","km/h","km/h",null,"horas","años","(€/ha)","(€/m-€/t)","(kg/m)"]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(O111=28, \"\", \"alta\")","v":"alta"},{"$f":"+AF111","v":80},false,null,"Arado vertedera/disco",1,240,40,32,18,3,8,1,3000,20,6,8000,1000,"Resist.esp.","Suelo",40,60,80]
[null,null,null,"max",{"$f":"+R110","v":32},null,null,null,null,null,null,null,null,"Chisel",2,600,300,25,18,5,11,0.5,3000,20,1.1000000000000001,2500,250,"Resist.esp.","Suelo",40,60,80]
[null,null,"Profundidad / factor corrector",2,{"$f":"IF(D9<E10,E10,IF(D9>E8,E8,D9))","v":18},"cm/ud.",null,null,null,"Eficiencia ",149,null,null,"Subsolador",3,400,100,65,30,3,8,0.5,3000,20,2.1,2500,1000,"Resist.esp.","Suelo",40,60,80]
[null,null,null,"min",{"$f":"+S110","v":18},null,null,null,null,"Baja",0.65,false,null,"Rotocultivador",4,350,150,30,20,3,6,1,1500,20,3.9,2500,250,"Resist.esp.","Suelo",40,60,80]
[null,null,null,null,null,null,null,null,null,"Media",0.75,false,null,"Grada de discos",5,800,200,20,10,5,12,0.5,3000,20,0.75,2600,400,"Resist.esp.","Suelo",40,60,80]
[null,"Profundidad / corrección",null,null,{"$f":"+E9","v":18},"cm",null,null,null,"Alta",0.85,true,null,"Cultivador",6,800,250,20,5,5,12,0.2,3000,20,0.9,2200,200,"Resist.esp.","Suelo",40,60,80]
[null,"Anchura trabajo",null,null,{"$f":"+E5/100","v":2.4},"m",null,null,null,null,null,null,null,"Grada accionada",7,700,300,15,10,4,8,0.7,3000,20,1.65,2500,250,"Resist.esp.","Suelo",40,60,80]
[null,"Peso máquina (carga equiv.)",null,null,{"$f":"IF(O111>=17,E16*1.2,G14*E13)","v":2400},"kg/ud.",{"$f":"+AA110","v":1000},"kg/m",null,null,null,null,null,"Vibrocultivador",8,1000,300,10,4,4,10,0.2,3000,20,0.9,2700,200,"Resist.esp.","Suelo",40,60,80]
[null,null,null,null,null,null,null,null,null,"Nivel de carga (%)",null,null,null,"Rodillo",9,1000,300,10,2,4,12,0.5,3000,20,0.3,600,300,"Resist.esp.","Suelo",40,60,80]
[null,"Resistencia suelo /eqiv.",null,null,{"$f":"IF(L5=TRUE,K5,IF(L6=TRUE,K6,IF(L7=TRUE,K7)))","v":60},"kPa/ud.",null,null,null,"Bajo",25,false,null,null,10]
[null,"Coeficiente corrector",null,null,{"$f":"+V110","v":1},null,null,null,null,"Medio",50,false,null,"Sembradora chorrillo",11,800,250,10,5,5,12,0.5,1200,20,0.45,3500,500,"Resist.esp.","Suelo",40,60,80]
[null,"Fuerza /equivalente",null,{"$f":"+T110*10","v":30},{"$f":"+IF(O110>=17,E16*4*E17*0.1*10*E9/10,E16*E12*E17*0.1*E13*10)","v":2592},"daN/ud.",null,null,null,"Alto",75,true,null,"Sembradora chorrillo - SD",12,800,300,15,10,5,12,0.8,1200,20,2.7,10000,1000,"Resist.esp.","Suelo",40,60,80]
[null,"Velocidad de trabajo",null,90,{"$f":"IF(D19<D18,D18/10,IF(D19>D20,D20/10,D19/10))","v":8},"km/h",null,null,null,null,null,null,null,"Sembradora monograno",13,600,300,10,5,3,10,0.5,1200,20,0.75,6500,400,"Resist.esp.","Suelo",40,60,80]
[null,"Potencia de tracción",null,{"$f":"+U110*10","v":80},{"$f":"+IF(O110>27,E16*E19*E5*0.001*E9/6,E18*10*E19/3600)","v":57.6},"kW",null,null,null,null,null,null,null,"Sembradora hortícolas",14,300,100,10,5,2,6,0.5,1200,20,0.75,6500,250,"Resist.esp.","Suelo",40,60,80]
[null,null,null,"s / n",{"$f":"E20*1.36","v":78.336000000000013},"CV",null,true,{"$f":"IF(L16=TRUE,K16,IF(L17=TRUE,K17,IF(L18=TRUE,K18)))","v":75},"Nivel carga elegido (%)",null,null,null,"Plantadora patatas",15,400,150,15,10,2,8,0.5,1200,20,3.5,5500,500,"Resist.esp.","Suelo",40,60,80]
[null,"Pendientes fuertes (s/n)",null,null,{"$f":"IF(H21=TRUE,E21*0.2,0)","v":15.667200000000003},"CV","(D 20%)",false,null,null,null,null,null,null,16]
[null,"Pot a la barra i/rod+desliz",null,null,{"$f":"(E21+E22)/0.75","v":125.33760000000002},"CV",null,null,"CV",{"$f":"+G91","v":"x"},null,null,null,"Abonadora suspendida",17,2000,1000,15,10,5,15,0.15,800,20,0.3,7000,null,"Tamaño (L)",null,800,1000,1200]
[null,null,null,null,null,null,null,null,{"$f":"E23*100/I21","v":167.11680000000004},"Potencia tractor necesaria",true,null,null,"Abonadora arrastrada",18,3000,2000,15,10,5,15,0.15,800,20,0.3,8000,null,"Tamaño (L)",null,1500,2500,3000]
[null,"Capacidad trabajo teórica",null,null,{"$f":"10/(E19*E13)","v":0.52083333333333337},"h/ha",null,null,{"$f":"IF(K25,I26,I24)","v":167.11680000000004},{"$f":"+J91","v":0},false,null,null,"Remolque estiércol",19,700,300,20,10,2,8,0.05,6000,20,1.2,2500,null,"Tamaño (kg)",null,7000,12000,20000]
[null,"Eficiencia",null,null,{"$f":"IF(L10=TRUE,K10,IF(L11=TRUE,K11,IF(L12=TRUE,K12)))","v":0.85},null,null,null,225,"Potencia tractor escogido",null,null,null,"Cisterna purín",20,1200,500,20,10,2,8,0.05,2500,20,0.9,2000,null,"Tamaño (L)",null,7000,12000,20000]
[null,"Capacidad trabajo real",null,null,{"$f":"E25/E26","v":0.61274509803921573},"h/ha",null,null,null,null,null,null,null,null,21]
[null,null,null,null,{"$f":"1/E27","v":1.6319999999999999},"ha/h",null,null,null,null,null,null,null,"Pulverizador suspendido",22,2000,1000,20,10,4,15,0.2,1000,20,0.6,7000,null,"Tamaño (L)",null,500,1000,1200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulverizador arrastrado",23,3000,2000,20,10,5,16,0.2,1000,20,0.75,9000,null,"Tamaño (L)",null,1500,2000,2500]
[null,"COSTES DE UTILIZACIÓN",null,null,null,null,null,null,null,100,null,null,null,"Atomizador suspendido",24,600,300,20,10,2,7,0.4,1000,20,0.9,6000,null,"Tamaño (L)",null,400,600,1000]
[null,null,null,null,"L/h","L/ha","€/h","€/ha",null,"Coste Gasóleo",null,null,null,"Atomizador arrastrado",25,1000,300,20,10,2,7,0.3,1000,20,0.9,7000,null,"Tamaño (L)",null,1200,2000,3000]
[null,null,null,"Combustible",{"$f":"+E54","v":25.436160000000005},{"$f":"E32*E27","v":15.58588235294118},{"$f":"J32*E32","v":25.436160000000005},{"$f":"F32*J32","v":15.58588235294118},null,{"$f":"+J30/100","v":1},"€/L",null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Remoque autocargador",27,500,150,8,4,2,10,0.05,2000,20,10,3500,null,"Tamaño (L)",null,25000,35000,50000]
[null,"Coste apero/máquina ",null,null,null,null,null,null,null,null,null,null,null,"Segadora-acondicionadora",28,600,300,20,10,4,12,null,1000,20,7,4500,1200,"kW/m","Potencia",5,8]
[null,"Horas trabajo anuales",null,null,{"$f":"+I35*E27","v":306.37254901960785}," h/año",null,"Superficie",500," ha/año",null,null,null,"Rastrilo hilerador-volteador",29,800,300,20,10,4,15,null,800,20,1.1000000000000001,1100,250,"kW/m","Potencia",2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Empacadora convencional",30,600,200,10,5,4,8,null,1000,20,10,1700,null,"t/h","Capacidad",8,10,12]
[null,null,null,"Precio de adqusición",{"$f":"IF(O111>29,H37*E14,IF(O111>27,+H37*E13,IF(O111>16,H37*E14/1000,+H37*E13)))","v":19200},"€",null,{"$f":"+Z111","v":8000},"€/m-€/kL","Apero","Vida útil",null,null,"Rotoempacadora",31,600,200,11,5,4,8,null,2000,20,8,2500,null,"t/h","Capacidad",10,12,14]
[null,null,null,"recomendado       ","propio",null,true,false,null,{"$f":"+E35","v":306.37254901960785},"h/año",null,null,"Macroempacadora",32,700,300,12,5,4,10,null,3000,20,6,3000,null,"t/h","Capacidad",12,14,16]
[null,"amort. - desgaste",null,{"$f":"+W110","v":3000},{"$f":"IF($G$38,D39,F39)","v":3000},null,"h",{"$f":"+$E$37/$E$39","v":6.4},"€/h","horas",{"$f":"+$E$37/($H$39+$H$40)","v":2013.9634801288935},null,null,"Segadora-picadora",33,300,150,60,30,3,6,null,1600,20,15,1750,null,"t/h","Capacidad",8,10,12]
[null,null,"amort. - obsolescencia",{"$f":"+X110","v":20},20,20,"años",{"$f":"+$E$37/($E$40*$E$35)","v":3.1334399999999998},"€/h","años",{"$f":"+$E$37/($E$35*($H$39+$H$40))","v":6.5735767991407084},null,null,null,34]
[null,"interés",null,5,5,null,"%",{"$f":"+$E$37*0.006*$E$41/$E$35","v":1.880064},"€/h",null,null,null,null,"Desbrozadora-picadora",35,600,400,20,10,3,6,null,1200,20,2.5,1200,null,"t/h","Capacidad",8,10,12]
[null,"seguros",null,0.2,0.2,0.2,"% PA",{"$f":"+$E$37*$E$42/(100*$E$35)","v":0.12533759999999999},"€/h","Tractor","Vida útil",null,null,null,36]
[null,"resguardo",null,0.1,0.1,0.1,"% PA",{"$f":"+$E$37*$E$43/($E$35*100)","v":6.2668799999999997E-2},"€/h",{"$f":"+B62","v":800},"h/año",null,null,null,37]
[null,"mantenim-reparaciones",null,{"$f":"+Y110","v":6},6,null,"€/ha",{"$f":"+$E$44/$E$27","v":9.7919999999999998},"€/h","horas",{"$f":"+$D$50/($D$63+$E$63)","v":6857.1428571428569},null,null,null,38]
[null,null,null,null,null,null,"Coste total",{"$f":"SUM(H39:H44)","v":21.3935104},"€/h","años",{"$f":"+$D$50/($J$43*($D$63+$E$63))","v":8.5714285714285712},null,null,null,39]
[null,null,null,null,null,null,null,{"$f":"+$H$45*$E$27","v":13.108768627450981},"€/ha",null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,"Coste tractor auxiliar",null,null,"Adqusición",560,"€/kW",null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,"Amortizac.",null,null,null,null,43]
[null,null,"PA",{"$f":"+G50*F48","v":68812.800000000017},"€","Potencia",{"$f":"+G51/1.36","v":122.88000000000002},"kW",null,12000,"horas",null,null,null,44]
[null,null,"tasa interés",{"$f":"+E41","v":5},"%",null,{"$f":"+I25","v":167.11680000000004},"CV",null,20,"años",null,null,null,45]
[null,null,"gasóleo",{"$f":"+J32","v":1},"€/L",null,null,null,"Seguros",0.2,"%",null,null,null,46]
[null,null,null,null,null,null,null,null,"Resguardo",0.1,"%",null,null,null,47]
[null,null,"Consumo de combustible",null,{"$f":"+H63/$J$32","v":25.436160000000005},"L/h",null,null,"Factor M-R",0.2,"€/L",null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,"baja",null,"media","alta",null,null,"Factor carga",null,null,null,null,50]
[null,null,"carga",25,40,50,75,85,"%"]
[null,null,"factor",0.1,0.129,0.15,0.20699999999999999,0.23599999999999999,"L/h-kW",{"$f":"IF(G59<30,D58,IF(G59<45,E58,IF(G59<55,F58,IF(G59<80,G58,IF(G59<110,H58)))))","v":0.20699999999999999}]
[null,null,"Carga recomendada",{"$f":"+I21","v":75},"%","Real",{"$f":"+E23*100/I25","v":75},"%"]
[]
[null,null,"Tractor (horas/año)","Costes horarios (€/h)",null,null,null,null,null,"[€/h]","[€/h]"]
[null,800,null,"A1","A2","I","S+R","Comb.","M-R","Total","s/comb."]
[null,null,{"$f":"+IF(B62>E35,B62,E35)","v":800},{"$f":"+$D$50/$J$50","v":5.7344000000000017},{"$f":"+$D$50/(J51*B62)","v":4.3008000000000015},{"$f":"+$D$50*D51*0.6/(B62*100)","v":2.5804800000000006},{"$f":"+$D$50*(J52+J53)/(100*B62)","v":0.25804800000000011},{"$f":"+$G$50*$J$58*$J$32","v":25.436160000000005},{"$f":"+$J$54*$J$58*G50","v":5.0872320000000011},{"$f":"SUM(D63:I63)","v":43.397120000000008},{"$f":"+J63-H63","v":17.960960000000004}]
[]
[null,"Coste apero + tractor",null,"Apero",null,"Tractor",null,"Conjunto",null,"Conjunto+MO"]
[null,null,{"$f":"+Grada_de_discos","v":"Arado vertedera/disco"},{"$f":"+H45","v":21.3935104},"€/h",{"$f":"+J63","v":43.397120000000008},"€/h",{"$f":"+D66+F66","v":64.790630400000012},"€/h",{"$f":"+H66+K70","v":74.790630400000012},"€/h"]
[null,{"$f":"+I35","v":500},"ha/año - apero",{"$f":"+H46","v":13.108768627450981},"€/ha",{"$f":"+F66*E27","v":26.591372549019614},"€/ha",{"$f":"+D67+F67","v":39.700141176470595},"€/ha",{"$f":"+J66*E27","v":45.827592156862757},"€/ha"]
[null,null,null,{"$f":"+E35","v":306.37254901960785},"h/año"]
[null,{"$f":"+C63","v":800},"h/año - tractor","Tractor ",{"$f":"+G51","v":167.11680000000004},"CV",null,"Utilización tractor",{"$f":"+B62","v":800},"h/año","Mano de obra (€/h)",100]
[null,null,null,"Apero",{"$f":"+E13","v":2.4},"m",null,"Utilización apero",{"$f":"+I35","v":500},"ha/año",{"$f":"+L69/10","v":10}]
[null,{"$f":"+J32","v":1},"gasóleo (€/L)"]
[null,null,null,"h/año","€/h","ha/año","apero","T+ap","total+MO"]
[null,null,"   anchura (m)",10,{"$f":"+($E$37/$E$39)+($E$37/($E$40*D73))+($E$37*0.006*$E$41/D73)+($E$37*($E$42+$E$43)/(100*D73))+($E$44/$E$27)","v":175.55199999999999},{"$f":"+D73*$E$28","v":16.32},{"$f":"+E73*$E$27","v":107.5686274509804},{"$f":"+G73+$F$67","v":134.16000000000003},{"$f":"+H73+$K$70*$E$27","v":140.28745098039218}]
[null,null,{"$f":"+E13","v":2.4},25,{"$f":"+($E$37/$E$39)+($E$37/($E$40*D74))+($E$37*0.006*$E$41/D74)+($E$37*($E$42+$E$43)/(100*D74))+($E$44/$E$27)","v":79.936000000000007},{"$f":"+D74*$E$28","v":40.799999999999997},{"$f":"+E74*$E$27","v":48.980392156862756},{"$f":"+G74+$F$67","v":75.571764705882373},{"$f":"+H74+$K$70*$E$27","v":81.699215686274528}]
[null,"velocidad",null,50,48.064000000000007,81.599999999999994,29.450980392156868,56.042352941176482,62.169803921568636]
[null,{"$f":"+E19","v":8},"km/h",75,37.440000000000005,122.39999999999999,22.941176470588239,49.532549019607856,55.660000000000011]
[null,null,null,100,32.128,163.19999999999999,19.686274509803923,46.277647058823533,52.405098039215687]
[null,null,null,150,26.816000000000003,244.79999999999998,16.43137254901961,43.022745098039223,49.150196078431378]
[null,null,null,200,24.159999999999997,326.39999999999998,14.80392156862745,41.395294117647062,47.522745098039216]
[null,null,null,250,22.566400000000002,408,13.827450980392159,40.418823529411775,46.546274509803929]
[null,null,null,300,21.504000000000001,489.59999999999997,13.176470588235295,39.767843137254907,45.895294117647062]
[null,null,null,350,20.745142857142859,571.19999999999993,12.711484593837538,39.30285714285715,45.430308123249304]
[null,null,null,400,20.176000000000002,652.79999999999995,12.362745098039218,38.95411764705883,45.081568627450984]
[null,null,null,450,19.733333333333334,734.4,12.091503267973858,38.682875816993473,44.810326797385628]
[null,null,null,500,19.379199999999997,816,11.874509803921567,38.465882352941179,44.593333333333334]
[null,null,null,{"$f":"IF(D68<500,600,D68)","v":600},{"$f":"+($E$37/$E$39)+($E$37/($E$40*D86))+($E$37*0.006*$E$41/D86)+($E$37*($E$42+$E$43)/(100*D86))+($E$44/$E$27)","v":18.847999999999999},{"$f":"+D86*$E$28","v":979.19999999999993},{"$f":"+E86*$E$27","v":11.549019607843137},{"$f":"+G86+$F$67","v":38.140392156862752},44.267843137254907]
[null,null,null,{"$f":"+D86+25","v":625},{"$f":"+($E$37/$E$39)+($E$37/($E$40*D87))+($E$37*0.006*$E$41/D87)+($E$37*($E$42+$E$43)/(100*D87))+($E$44/$E$27)","v":18.741759999999999},{"$f":"+D87*$E$28","v":1019.9999999999999},{"$f":"+E87*$E$27","v":11.483921568627451},{"$f":"+G87+$F$67","v":38.075294117647061},44.202745098039216]
[null,"profundidad",null,null,null,{"$f":"+I70","v":500},null,0]
[null,{"$f":"+E12","v":18},"cm",null,null,{"$f":"+I70","v":500},{"$f":"+D67","v":13.108768627450981},{"$f":"+H67","v":39.700141176470595},{"$f":"+J67","v":45.827592156862757}]
[null,null,null,null,null,null,null,null,0]
[null,null,"Capacidad trabajo",null,"Carga real (%)",{"$f":"+G59","v":75},{"$f":"IF(K25,0,\"x\")","v":"x"},null,null,{"$f":"IF(K25,\"x\",0)","v":0}]
[null,null,"real (h/ha)",null,null,"Tractor necesario",{"$f":"+I24","v":167.11680000000004},null,"Tractor elegido",{"$f":"+IF(G59<100,E69)","v":167.11680000000004},"CV"]
[null,null,{"$f":"+E27","v":0.61274509803921573}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Arado vertedera/disco",{"$f":"+O111","v":1},{"$f":"+P111","v":240},{"$f":"+Q111","v":40},{"$f":"+R111","v":32},{"$f":"+S111","v":18},{"$f":"+T111","v":3},8,1,3000,20,6,8000,1000,"Resist.esp.","Suelo",40,60,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($N$110,N7:AB56,1,FALSE)","v":"Arado vertedera/disco"},{"$f":"VLOOKUP($N$110,$N7:$AC56,2,FALSE)","v":1},{"$f":"VLOOKUP($O$111,O7:AF56,2)","v":240},{"$f":"VLOOKUP($O$111,$O7:$AF56,3)","v":40},{"$f":"VLOOKUP($O$111,$O7:$AF56,4)","v":32},{"$f":"VLOOKUP($O$111,$O7:$AF56,5)","v":18},{"$f":"VLOOKUP($O$111,$O7:$AF56,6)","v":3},{"$f":"VLOOKUP($O$111,$O7:$AF56,7)","v":8},{"$f":"VLOOKUP($O$111,$O7:$AF56,8)","v":1},{"$f":"VLOOKUP($O$111,$O7:$AF56,9)","v":3000},{"$f":"VLOOKUP($O$111,$O7:$AF56,10)","v":20},{"$f":"VLOOKUP($O$111,$O7:$AF56,11)","v":6},{"$f":"VLOOKUP($O$111,$O7:$AF56,12)","v":8000},{"$f":"VLOOKUP($O$111,$O7:$AF56,13)","v":1000},{"$f":"VLOOKUP($O$111,$O7:$AF56,14)","v":"Resist.esp."},{"$f":"VLOOKUP($O$111,$O7:$AF56,15)","v":"Suelo"},{"$f":"VLOOKUP($O$111,$O7:$AF56,16)","v":40},{"$f":"VLOOKUP($O$111,$O7:$AF56,17)","v":60},{"$f":"VLOOKUP($O$111,$O7:$AF56,18)","v":80}]

{"sheet":"Tractor","index":1,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
["PA",{"$f":"+E2*E5","v":20000},"€","Potencia",{"$f":"+J3","v":50},"kW","Amortizac.",12000,"horas","Potencia"]
["tasa interés",7,"%",null,{"$f":"+E2*1.36","v":68},"CV",null,20,"años",50,"kW"]
["gasóleo",1,"€/L"]
[null,null,null,null,400,"€/kW","Seguros",0.2,"%"]
[null,"Consumo de combustible",null,null,null,null,"Resguardo",0.1,"%"]
[null,"baja","media","alta",null,"Factor carga"]
["carga",25,50,75,"%",{"$f":"+K10/1000","v":0.15},null,null,"Mantenim- reparaciones",0.2,"€/L"]
["factor",0.1,0.15,0.20699999999999999,"L/h-kW",null,null,null,"Consumo (carga media)",{"$f":"+F13/$B$4","v":7.5},"L/h"]
[null,null,null,null,null,null,null,null,null,null,150]
[null,"Costes horarios (€/h)",null,null,null,null,null,null,"[€/h]","[€/h]"]
["Horas año","A1","A2","I","S+R","Comb.","Mant-repar",null,"Total","s/comb."]
[100,{"$f":"+$B$2/$H$2","v":1.6666666666666667},{"$f":"+$B$2/($H$3*A13)","v":10},{"$f":"+$B$2*$B$3*0.6/(A13*100)","v":8.4},{"$f":"+$B$2*($H$5+$H$6)/(A13*100)","v":0.60000000000000009},{"$f":"+$E$2*$F$8*$B$4","v":7.5},{"$f":"+$E$2*$C$9*$J$8","v":1.5},null,{"$f":"SUM(B13:G13)","v":29.666666666666668},{"$f":"+I13-F13","v":22.166666666666668}]
[{"$f":"+A13+100","v":200},1.6666666666666667,5,{"$f":"+$B$2*$B$3*0.6/(A14*100)","v":4.2},0.30000000000000004,{"$f":"+$E$2*$F$8*$B$4","v":7.5},1.5,null,20.166666666666668,12.666666666666668]
[300,1.6666666666666667,3.3333333333333335,2.8,0.20000000000000004,7.5,1.5,null,17,9.5]
[400,1.6666666666666667,2.5,2.1,0.15000000000000002,7.5,1.5,null,15.416666666666668,7.9166666666666679]
[500,1.6666666666666667,2,1.68,0.12000000000000002,7.5,1.5,null,14.466666666666667,6.9666666666666668]
[600,1.6666666666666667,1.6666666666666667,1.4,0.10000000000000002,7.5,1.5,null,13.833333333333332,6.3333333333333321]
[700,1.6666666666666667,1.4285714285714286,1.2,8.5714285714285729E-2,7.5,1.5,null,13.38095238095238,5.8809523809523796]
[800,1.6666666666666667,1.25,1.05,7.5000000000000011E-2,7.5,1.5,null,13.041666666666668,5.5416666666666679]
[900,1.6666666666666667,1.1111111111111112,0.93333333333333335,6.666666666666668E-2,7.5,1.5,null,12.777777777777779,5.2777777777777786]
[1000,1.6666666666666667,1,0.84,6.0000000000000012E-2,7.5,1.5,null,12.566666666666666,5.0666666666666664]
[1100,1.6666666666666667,0.90909090909090906,0.76363636363636367,5.4545454545454557E-2,7.5,1.5,null,12.393939393939394,4.8939393939393945]
[1200,1.6666666666666667,0.83333333333333337,0.7,5.000000000000001E-2,7.5,1.5,null,12.25,4.75]
[1300,1.6666666666666667,0.76923076923076927,0.64615384615384619,4.6153846153846163E-2,7.5,1.5,null,12.128205128205128,4.6282051282051277]
[1400,1.6666666666666667,0.7142857142857143,0.6,4.2857142857142864E-2,7.5,1.5,null,12.023809523809524,4.5238095238095237]
[1500,1.6666666666666667,0.66666666666666663,0.56000000000000005,4.0000000000000008E-2,7.5,1.5,null,11.933333333333334,4.4333333333333336]
[1600,1.6666666666666667,0.625,0.52500000000000002,3.7500000000000006E-2,7.5,1.5,null,11.854166666666668,4.3541666666666679]
[1700,1.6666666666666667,0.58823529411764708,0.49411764705882355,3.529411764705883E-2,7.5,1.5,null,11.784313725490197,4.2843137254901968]
[1800,1.6666666666666667,0.55555555555555558,0.46666666666666667,3.333333333333334E-2,7.5,1.5,null,11.722222222222221,4.2222222222222214]
[1900,1.6666666666666667,0.52631578947368418,0.44210526315789472,3.1578947368421061E-2,7.5,1.5,null,11.666666666666668,4.1666666666666679]
[2000,1.6666666666666667,0.5,0.42,3.0000000000000006E-2,7.5,1.5,null,11.616666666666667,4.1166666666666671]
[]
[]
[null,"Costes anuales (€/año)",null,null,null,null,null,null,"€/año","€/año"]
["Horas año","A1","A2","I","S+R","Comb.","Mant-repar",null,"Total","s/comb","[L/año]"]
[{"$f":"+A13","v":100},{"$f":"+B13*A37","v":166.66666666666669},{"$f":"+C13*A37","v":1000},{"$f":"+D13*A37","v":840},{"$f":"+E13*A37","v":60.000000000000007},{"$f":"+F13*A37","v":750},{"$f":"+G13*A37","v":150},null,{"$f":"SUM(B37:G37)","v":2966.666666666667},{"$f":"+I37-F37","v":2216.666666666667},{"$f":"+F37/$B$4","v":750}]
[200,333.33333333333337,1000,840,60.000000000000007,1500,300,null,4033.3333333333335,2533.3333333333335,1500]
[300,500,1000,840,60.000000000000014,2250,450,null,5100,2850,2250]
[400,666.66666666666674,1000,840,60.000000000000007,3000,600,null,6166.666666666667,3166.666666666667,3000]
[500,833.33333333333337,1000,840,60.000000000000014,3750,750,null,7233.3333333333339,3483.3333333333339,3750]
[600,1000,1000,840,60.000000000000014,4500,900,null,8300,3800,4500]
[700,1166.6666666666667,1000,840,60.000000000000007,5250,1050,null,9366.6666666666679,4116.6666666666679,5250]
[800,1333.3333333333335,1000,840,60.000000000000007,6000,1200,null,10433.333333333334,4433.3333333333339,6000]
[900,1500,1000,840,60.000000000000014,6750,1350,null,11500,4750,6750]
[1000,1666.6666666666667,1000,840,60.000000000000014,7500,1500,null,12566.666666666668,5066.6666666666679,7500]
[1100,1833.3333333333335,1000,840,60.000000000000014,8250,1650,null,13633.333333333334,5383.3333333333339,8250]
[1200,2000,1000,840,60.000000000000014,9000,1800,null,14700,5700,9000]
[1300,2166.666666666667,1000,840,60.000000000000014,9750,1950,null,15766.666666666668,6016.6666666666679,9750]
[1400,2333.3333333333335,1000,840,60.000000000000007,10500,2100,null,16833.333333333336,6333.3333333333358,10500]
[1500,2500,1000,840.00000000000011,60.000000000000014,11250,2250,null,17900,6650,11250]
[1600,2666.666666666667,1000,840,60.000000000000007,12000,2400,null,18966.666666666668,6966.6666666666679,12000]
[1700,2833.3333333333335,1000,840,60.000000000000014,12750,2550,null,20033.333333333336,7283.3333333333358,12750]
[1800,3000,1000,840,60.000000000000014,13500,2700,null,21100,7600,13500]
[1900,3166.666666666667,1000,840,60.000000000000014,14250,2850,null,22166.666666666668,7916.6666666666679,14250]
[2000,3333.3333333333335,1000,840,60.000000000000014,15000,3000,null,23233.333333333336,8233.3333333333358,15000]