{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["T","DE","Ibilgailu-mota","Ibilgailuaren Ezaugarriak","Erosketa kostuak","Pertsonal-kostuak","Aseguruak eta zerga arloko kost","Kostu aldakorrak","Zeharkako kostuak ","Emaitzak","Zerbitzuaren kostua"],"not_rendered":{"charts":6,"images":6,"macros":1,"external_links":1,"defined_names":5,"comments":1,"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":"T","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Tipo de vehículo",null,"Pregunta",null,null,"Adquisicion",null,"Editar"]
["Ibilbide luzeko zama arrunteko ibilgailu artikulatua","T1","Bai","S",null," EROSKETA"]
["Ibilbide laburreko zama arrunteko ibilgailu artikulatua","T2","Ez","N",null," ALOKAIRUA, LEASING..."]
["Edukiontziak eramateko ibilbide luzeko ibilgailua","T3"]
["Edukiontziak eramateko ibilbide laburreko ibilgailua","T4"]
["Obrako brozel artikulatua","T5"]
["Zama orokorreko ardatz 2ko ibilgailua","T6"]
["Ibilbide luzeko salgai arriskutsuen (kimikoak) ibilgailu artikulatua","T7"]
["Petrolioaren deribatuen (gasolio, gasolina, fuel-olioa) ibilgailu artikulatua","T8"]
["Ibilbide luzeko salgai arriskutsuen (gasak) patin-ibilgailua","T9"]
["Ibilgailu hozkailu artikulatua","T10"]
["Ardatz 2ko ibilgailu hozkailua","T11"]
["Ibilbide luzeko solteko gaien brozela","T12"]
["Ibilbide laburreko solteko gaien brozela","T13"]
["3T-ko banaketa-kamioi arina","T14"]
["Furgonetak","T15"]
["Ibilgailu arrunta (aurreko kategorietan sartzen ez diren gainerako ibilgailu guztiak)","T16"]

{"sheet":"DE","index":1,"n_rows":124,"n_cols":36,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"T1A","T1","T2A","T2","T3A","T3","T4A","T4","T5A","T5","T6A","T6","T7A","T7","T8A","T8","T9A","T9","T10A","T10","T11A","T11","T12A","T12","T13A","T13","T14A","T14","T15A","T15","T16A","T16"]
[null,"Descripción:",null," ","Ibilbide luzeko zama arrunteko ibilgailu artikulatua"," ","Ibilbide laburreko zama arrunteko ibilgailu artikulatua"," ","Edukiontziak eramateko ibilbide luzeko ibilgailua"," ","Edukiontziak eramateko ibilbide laburreko ibilgailua"," ","Obrako brozel artikulatua"," ","Zama orokorreko ardatz 2ko ibilgailua"," ","Ibilbide luzeko salgai arriskutsuen (kimikoak) ibilgailu artikulatua"," ","Petrolioaren deribatuen (gasolio, gasolina, fuel-olioa) ibilgailu artikulatua"," ","Ibilbide luzeko salgai arriskutsuen (gasak) patin-ibilgailua"," ","Ibilgailu hozkailu artikulatua"," ","Ardatz 2ko ibilgailu hozkailua"," ","Ibilbide luzeko solteko gaien brozela"," ","Ibilbide laburreko solteko gaien brozela"," ","3T-ko banaketa-kamioi arina"," ","Furgonetak"," ","Ibilgailu arrunta (aurreko kategorietan sartzen ez diren gainerako ibilgailu guztiak)","07/04/2026"]
[null,"Tipo interes",null,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425,null,0.0425]
[null,"Potencia",null,null,455.0,null,455.0,null,455.0,null,455.0,null,455.0,null,280.0,null,455.0,null,455.0,null,455.0,null,455.0,null,280.0,null,455.0,null,455.0,null,130.0,null,130.0,null,455.0]
[null,"MMA",null,null,40000.0,null,40000.0,null,44000.0,null,44000.0,null,40000.0,null,18000.0,null,40000.0,null,40000.0,null,40000.0,null,40000.0,null,18000.0,null,40000.0,null,40000.0,null,35000.0,null,3500.0,null,40000.0]
[null,"Carga útil",null,null,25000.0,null,25000.0,null,26250.0,null,26250.0,null,23000.0,null,9500.0,null,0.0,null,0.0,null,0.0,null,24000.0,null,9000.0,null,24000.0,null,24000.0,null,1500.0,null,1500.0,null,25000.0]
[null,"Número de ejes",null,null,5.0,null,5.0,null,6.0,null,6.0,null,4.0,null,2.0,null,5.0,null,5.0,null,5.0,null,5.0,null,2.0,null,5.0,null,5.0,null,2.0,null,2.0,null,5.0]
[null,"Número de neumáticos",null,null,12.0,null,12.0,null,14.0,null,14.0,null,14.0,null,6.0,null,12.0,null,12.0,null,12.0,null,12.0,null,6.0,null,12.0,null,12.0,null,4.0,null,4.0,null,12.0]
[null,"Kilómetros recorridos anualmente",null,null,150000.0,null,120000.0,null,100000.0,null,100000.0,null,60000.0,null,90000.0,null,105000.0,null,100000.0,null,100000.0,null,120000.0,null,70000.0,null,120000.0,null,120000.0,null,50000.0,null,50000.0,null,120000.0]
[null,"Kilómetros recorridos anualmente en carga (%, km)",null,90.0,{"$f":"E9*D10/100","v":135000.0},85.0,{"$f":"G9*F10/100","v":102000.0},85.0,{"$f":"I9*H10/100","v":85000.0},85.0,85000.0,50.0,{"$f":"M9*L10/100","v":30000.0},80.0,{"$f":"O9*N10/100","v":72000.0},75.0,{"$f":"Q9*P10/100","v":78750.0},50.0,{"$f":"S9*R10/100","v":50000.0},50.0,50000.0,80.0,{"$f":"W9*V10/100","v":96000.0},75.0,{"$f":"Y9*X10/100","v":52500.0},80.0,{"$f":"AA9*Z10/100","v":96000.0},80.0,96000.0,75.0,{"$f":"AE9*AD10/100","v":37500.0},75.0,{"$f":"AG9*AF10/100","v":37500.0},85.0,{"$f":"AI9*AH10/100","v":102000.0}]
[null,"Kilómetros recorridos anualmente en vacío (%, km)",null,10.0,{"$f":"E9*D11/100","v":15000.0},15.0,{"$f":"G9*F11/100","v":18000.0},15.0,{"$f":"I9*H11/100","v":15000.0},15.0,{"$f":"K9*J11/100","v":15000.0},50.0,{"$f":"M9*L11/100","v":30000.0},20.0,{"$f":"O9*N11/100","v":18000.0},25.0,{"$f":"Q9*P11/100","v":26250.0},50.0,{"$f":"S9*R11/100","v":50000.0},50.0,{"$f":"U9*T11/100","v":50000.0},20.0,{"$f":"W9*V11/100","v":24000.0},25.0,{"$f":"Y9*X11/100","v":17500.0},20.0,{"$f":"AA9*Z11/100","v":24000.0},20.0,{"$f":"AC9*AB11/100","v":24000.0},25.0,{"$f":"AE9*AD11/100","v":12500.0},25.0,{"$f":"AG9*AF11/100","v":12500.0},15.0,{"$f":"AI9*AH11/100","v":18000.0}]
[null,"Consumo medio (litros/100km)",null,null,35.0,null,35.0,null,35.0,null,35.0,null,38.5,null,25.0,null,34.5,null,34.5,null,34.5,null,35.0,null,25.0,null,35.0,null,35.0,null,11.5,null,11.5,null,35.0]
[null,"Horas trabajadas al año",null,null,2000.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0]
[null,"Horas trabajadas al año en carga (%, h)",null,90.0,{"$f":"E13*D14/100","v":1800.0},85.0,{"$f":"G13*F14/100","v":1530.0},85.0,{"$f":"I13*H14/100","v":1530.0},85.0,1530.0,50.0,{"$f":"M13*L14/100","v":900.0},80.0,{"$f":"O13*N14/100","v":1440.0},75.0,{"$f":"Q13*P14/100","v":1350.0},50.0,{"$f":"S13*R14/100","v":900.0},50.0,900.0,80.0,{"$f":"W13*V14/100","v":1440.0},75.0,{"$f":"Y13*X14/100","v":1350.0},80.0,{"$f":"AA13*Z14/100","v":1440.0},80.0,1440.0,75.0,{"$f":"AE13*AD14/100","v":1350.0},75.0,{"$f":"AG13*AF14/100","v":1350.0},85.0,{"$f":"AI13*AH14/100","v":1530.0}]
[null,"Horas trabajadas al año en vacío (%, h)",null,10.0,{"$f":"E13*D15/100","v":200.0},15.0,{"$f":"G13*F15/100","v":270.0},15.0,{"$f":"I13*H15/100","v":270.0},15.0,{"$f":"K13*J15/100","v":270.0},50.0,{"$f":"M13*L15/100","v":900.0},20.0,{"$f":"O13*N15/100","v":360.0},25.0,{"$f":"Q13*P15/100","v":450.0},50.0,{"$f":"S13*R15/100","v":900.0},50.0,{"$f":"U13*T15/100","v":900.0},20.0,{"$f":"W13*V15/100","v":360.0},25.0,{"$f":"Y13*X15/100","v":450.0},20.0,{"$f":"AA13*Z15/100","v":360.0},20.0,{"$f":"AC13*AB15/100","v":360.0},25.0,{"$f":"AE13*AD15/100","v":450.0},25.0,{"$f":"AG13*AF15/100","v":450.0},15.0,{"$f":"AI13*AH15/100","v":270.0}]
[null,"Días trabajados al año",null,null,250.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0]
[null,"Horas trabajadas por jornada",null,null,{"$f":"E13/E16","v":8.0},null,{"$f":"G13/G16","v":8.0},null,{"$f":"I13/I16","v":8.0},null,8.0,null,{"$f":"M13/M16","v":8.0},null,{"$f":"O13/O16","v":8.0},null,{"$f":"Q13/Q16","v":8.0},null,{"$f":"S13/S16","v":8.0},null,8.0,null,{"$f":"W13/W16","v":8.0},null,{"$f":"Y13/Y16","v":8.0},null,{"$f":"AA13/AA16","v":8.0},null,8.0,null,{"$f":"AE13/AE16","v":8.0},null,{"$f":"AG13/AG16","v":8.0},null,{"$f":"AI13/AI16","v":8.0}]
[null,"Pago de leasing o renta anual (€)",null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,131208.73,null,131208.73,null,131208.73,null,131208.73,null,131208.73,null,81134.25,null,131208.73,null,131208.73,null,131208.73,null,131208.73,null,81134.25,null,131208.73,null,131208.73,null,27461.92,null,27461.92,null,131208.73]
[null,"Descuento sobre tarifa (%)",null,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0]
[null,"Precio de adquisición sin IVA (€)",null,null,{"$f":"ROUND((1-E20/100)*E19,0)","v":118088.0},null,{"$f":"(1-G20/100)*G19","v":118088.0},null,{"$f":"(1-I20/100)*I19","v":118088.0},null,118088.0,null,{"$f":"(1-M20/100)*M19","v":118088.0},null,{"$f":"(1-O20/100)*O19","v":73021.0},null,{"$f":"(1-Q20/100)*Q19","v":118088.0},null,{"$f":"(1-S20/100)*S19","v":118088.0},null,118088.0,null,{"$f":"(1-W20/100)*W19","v":118088.0},null,{"$f":"(1-Y20/100)*Y19","v":73021.0},null,{"$f":"(1-AA20/100)*AA19","v":118088.0},null,118088.0,null,{"$f":"(1-AE20/100)*AE19","v":24716.0},null,{"$f":"(1-AG20/100)*AG19","v":24716.0},null,{"$f":"(1-AI20/100)*AI19","v":118088.0}]
[null,"Vida útil (años)",null,null,5.0,null,6.0,null,8.0,null,8.0,null,8.0,null,10.0,null,6.0,null,6.0,null,6.0,null,6.0,null,10.0,null,6.0,null,6.0,null,8.0,null,8.0,null,6.0]
[null,"Valor residual sobre precio de tarifa (%)",null,15.0,{"$f":"ROUND(E19*D23/100,0)","v":19681.0},20.0,{"$f":"G19*F23/100","v":26242.0},20.0,{"$f":"I19*H23/100","v":26242.0},20.0,{"$f":"K19*J23/100","v":26242.0},20.0,{"$f":"M19*L23/100","v":26242.0},10.0,{"$f":"O19*N23/100","v":8113.0},20.0,{"$f":"Q19*P23/100","v":26242.0},20.0,{"$f":"S19*R23/100","v":26242.0},20.0,{"$f":"U19*T23/100","v":26242.0},20.0,{"$f":"W19*V23/100","v":26242.0},10.0,{"$f":"Y19*X23/100","v":8113.0},20.0,{"$f":"AA19*Z23/100","v":26242.0},20.0,{"$f":"AC19*AB23/100","v":26242.0},15.0,{"$f":"AE19*AD23/100","v":4119.0},15.0,{"$f":"AG19*AF23/100","v":4119.0},20.0,{"$f":"AI19*AH23/100","v":26242.0}]
[null,"AMORTIZACIÓN DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E102)/E22,0),0)","v":17932.0},null,{"$f":"IFERROR(ROUND((G21-G23-G102)/G22,0),0)","v":14141.0},null,{"$f":"IFERROR(ROUND((I21-I23-I102)/I22,0),0)","v":10630.0},null,{"$f":"IFERROR(ROUND((K21-K23-K102)/K22,0),0)","v":10630.0},null,{"$f":"IFERROR(ROUND((M21-M23-M102)/M22,0),0)","v":9950.0},null,{"$f":"IFERROR(ROUND((O21-O23-O102)/O22,0),0)","v":6157.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q102)/Q22,0),0)","v":14287.0},null,{"$f":"IFERROR(ROUND((S21-S23-S102)/S22,0),0)","v":14336.0},null,{"$f":"IFERROR(ROUND((U21-U23-U102)/U22,0),0)","v":14336.0},null,{"$f":"IFERROR(ROUND((W21-W23-W102)/W22,0),0)","v":14141.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y102)/Y22,0),0)","v":6231.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA102)/AA22,0),0)","v":14141.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC102)/AC22,0),0)","v":14141.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE102)/AE22,0),0)","v":2486.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG102)/AG22,0),0)","v":2486.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI102)/AI22,0),0)","v":14141.0}]
[null,"GASTOS FINANCIEROS DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E102)*(E$3/(1-POWER(1+E$3,-E22))-1/E22),0),0)","v":2350.0},null,{"$f":"IFERROR(ROUND((G21-G23-G102)*(G$3/(1-POWER(1+G$3,-G22))-1/G22),0),0)","v":2176.0},null,{"$f":"IFERROR(ROUND((I21-I23-I102)*(I$3/(1-POWER(1+I$3,-I22))-1/I22),0),0)","v":2132.0},null,{"$f":"IFERROR(ROUND((K21-K23-K102)*(K$3/(1-POWER(1+K$3,-K22))-1/K22),0),0)","v":2132.0},null,{"$f":"IFERROR(ROUND((M21-M23-M102)*(M$3/(1-POWER(1+M$3,-M22))-1/M22),0),0)","v":1995.0},null,{"$f":"IFERROR(ROUND((O21-O23-O102)*(O$3/(1-POWER(1+O$3,-O22))-1/O22),0),0)","v":1529.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q102)*(Q$3/(1-POWER(1+Q$3,-Q22))-1/Q22),0),0)","v":2199.0},null,{"$f":"IFERROR(ROUND((S21-S23-S102)*(S$3/(1-POWER(1+S$3,-S22))-1/S22),0),0)","v":2206.0},null,{"$f":"IFERROR(ROUND((U21-U23-U102)*(U$3/(1-POWER(1+U$3,-U22))-1/U22),0),0)","v":2206.0},null,{"$f":"IFERROR(ROUND((W21-W23-W102)*(W$3/(1-POWER(1+W$3,-W22))-1/W22),0),0)","v":2176.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y102)*(Y$3/(1-POWER(1+Y$3,-Y22))-1/Y22),0),0)","v":1547.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA102)*(AA$3/(1-POWER(1+AA$3,-AA22))-1/AA22),0),0)","v":2176.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC102)*(AC$3/(1-POWER(1+AC$3,-AC22))-1/AC22),0),0)","v":2176.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE102)*(AE$3/(1-POWER(1+AE$3,-AE22))-1/AE22),0),0)","v":499.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG102)*(AG$3/(1-POWER(1+AG$3,-AG22))-1/AG22),0),0)","v":499.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI102)*(AI$3/(1-POWER(1+AI$3,-AI22))-1/AI22),0),0)","v":2176.0}]
[null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,8801.3,null,null,null,null,null,null,null,null,null,45009.78,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,5.0,null,null,null,null,null,null,null,null,null,5.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de adquisición sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((1-O28/100)*O27,0)","v":8361.0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND((1-Y28/100)*Y27,0)","v":42759.0},null,null,null,null,null,null,null,null,null,0.0]
[null,"Vida útil (años)",null,null,null,null,null,null,null,null,null,null,null,null,10.0,null,null,null,null,null,null,null,null,null,10.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,10.0,{"$f":"ROUND(O27*N31/100,0)","v":880.0},null,null,null,null,null,null,null,null,10.0,{"$f":"ROUND(Y27*X31/100,0)","v":4501.0},null,null,null,null,null,null,null,null,0.0,0.0]
[null,"AMORTIZACION CARROZADO",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((O29-O31)/O30,0),0)","v":748.0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((Y29-Y31)/Y30,0),0)","v":3826.0},null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTOS FINANCIEROS CARROZADO",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((O29-O31)*(O$3/(1-POWER(1+O$3,-O30))-1/O30),0),0)","v":185.75},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((Y29-Y31)*(Y$3/(1-POWER(1+Y$3,-Y30))-1/Y30),0),0)","v":949.95},null,null,null,null,null,null,null,null,null,0.0]
[null,"Pago de leasing o renta anual (€)",null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,40796.37,null,40796.37,null,31994.46,null,31994.46,null,36217.25,null,null,null,100459.33,null,100459.33,null,100459.33,null,70308.31,null,null,null,44109.58,null,44109.58,null,null,null,null,null,40796.37]
[null,"Descuento sobre tarifa (%)",null,null,5.0,null,5.0,null,5.0,null,5.0,null,5.0,null,null,null,5.0,null,5.0,null,5.0,null,5.0,null,null,null,5.0,null,5.0,null,null,null,null,null,5.0]
[null,"Precio de adquisición sin IVA (€)",null,null,{"$f":"ROUND((1-E36/100)*E35,0)","v":38757.0},null,{"$f":"ROUND((1-G36/100)*G35,0)","v":38757.0},null,{"$f":"ROUND((1-I36/100)*I35,0)","v":30395.0},null,{"$f":"ROUND((1-K36/100)*K35,0)","v":30395.0},null,{"$f":"ROUND((1-M36/100)*M35,0)","v":34406.0},null,null,null,{"$f":"ROUND((1-Q36/100)*Q35,0)","v":95436.0},null,{"$f":"ROUND((1-S36/100)*S35,0)","v":95436.0},null,{"$f":"ROUND((1-U36/100)*U35,0)","v":95436.0},null,{"$f":"ROUND((1-W36/100)*W35,0)","v":66793.0},null,null,null,{"$f":"ROUND((1-AA36/100)*AA35,0)","v":41904.0},null,{"$f":"ROUND((1-AC36/100)*AC35,0)","v":41904.0},null,null,null,null,null,{"$f":"ROUND((1-AI36/100)*AI35,0)","v":38757.0}]
[null,"Vida útil (años)",null,null,7.0,null,8.0,null,12.0,null,12.0,null,12.0,null,null,null,8.0,null,10.0,null,10.0,null,10.0,null,null,null,10.0,null,10.0,null,null,null,null,null,8.0]
[null,"Valor residual sobre precio de tarifa (%)",null,10.0,{"$f":"ROUND(E35*D39/100,0)","v":4080.0},15.0,{"$f":"ROUND(G35*F39/100,0)","v":6119.0},15.0,{"$f":"ROUND(I35*H39/100,0)","v":4799.0},15.0,{"$f":"ROUND(K35*J39/100,0)","v":4799.0},15.0,{"$f":"ROUND(M35*L39/100,0)","v":5433.0},null,null,20.0,{"$f":"ROUND(Q35*P39/100,0)","v":20092.0},15.0,{"$f":"ROUND(S35*R39/100,0)","v":15069.0},15.0,{"$f":"ROUND(U35*T39/100,0)","v":15069.0},15.0,{"$f":"ROUND(W35*V39/100,0)","v":10546.0},null,null,10.0,{"$f":"ROUND(AA35*Z39/100,0)","v":4411.0},10.0,{"$f":"ROUND(AC35*AB39/100,0)","v":4411.0},null,null,null,null,15.0,{"$f":"ROUND(AI35*AH39/100,0)","v":6119.0}]
[null,"AMORTIZACIÓN REMOLQUE",null,null,{"$f":"IFERROR(ROUND((E37-E39-E93*E97)/E38,0),0)","v":4329.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)/G38,0),0)","v":3533.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)/I38,0),0)","v":1769.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)/K38,0),0)","v":1769.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)/M38,0),0)","v":1928.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)/Q38,0),0)","v":8871.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)/S38,0),0)","v":7599.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)/U38,0),0)","v":7599.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)/W38,0),0)","v":5187.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)/AA38,0),0)","v":3312.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)/AC38,0),0)","v":3312.0},null,null,null,null,null,{"$f":"IFERROR(ROUND((AI37-AI39-AI93*AI97)/AI38,0),0)","v":3533.0}]
[null,"GASTOS FINANCIEROS REMOLQUE",null,null,{"$f":"IFERROR(ROUND((E37-E39-E93*E97)*(E$3/(1-POWER(1+E$3,-E38))-1/E38),0),0)","v":767.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)*(G$3/(1-POWER(1+G$3,-G38))-1/G38),0),0)","v":708.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)*(I$3/(1-POWER(1+I$3,-I38))-1/I38),0),0)","v":526.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)*(K$3/(1-POWER(1+K$3,-K38))-1/K38),0),0)","v":526.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)*(M$3/(1-POWER(1+M$3,-M38))-1/M38),0),0)","v":573.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)*(Q$3/(1-POWER(1+Q$3,-Q38))-1/Q38),0),0)","v":1779.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)*(S$3/(1-POWER(1+S$3,-S38))-1/S38),0),0)","v":1887.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)*(U$3/(1-POWER(1+U$3,-U38))-1/U38),0),0)","v":1887.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)*(W$3/(1-POWER(1+W$3,-W38))-1/W38),0),0)","v":1288.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)*(AA$3/(1-POWER(1+AA$3,-AA38))-1/AA38),0),0)","v":822.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)*(AC$3/(1-POWER(1+AC$3,-AC38))-1/AC38),0),0)","v":822.0},null,null,null,null,null,{"$f":"IFERROR(ROUND((AI37-AI39-AI93*AI97)*(AI$3/(1-POWER(1+AI$3,-AI38))-1/AI38),0),0)","v":708.0}]
[null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de adquisición sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Vida útil (años)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,null,0.0,0.0]
[null,"AMORTIZACION EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTOS FINANCIEROS EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"COSTES DE ADQUISICION",null,null,{"$f":"E24+E25+E32+E33+E40+E41+E48+E49","v":25378.0},null,{"$f":"G24+G25+G32+G33+G40+G41+G48+G49","v":20558.0},null,{"$f":"I24+I25+I32+I33+I40+I41+I48+I49","v":15057.0},null,15057.0,null,{"$f":"M24+M25+M32+M33+M40+M41+M48+M49","v":14446.0},null,{"$f":"O24+O25+O32+O33+O40+O41+O48+O49","v":8619.75},null,{"$f":"Q24+Q25+Q32+Q33+Q40+Q41+Q48+Q49","v":27136.0},null,{"$f":"S24+S25+S32+S33+S40+S41+S48+S49","v":26028.0},null,26028.0,null,{"$f":"W24+W25+W32+W33+W40+W41+W48+W49","v":22792.0},null,{"$f":"Y24+Y25+Y32+Y33+Y40+Y41+Y48+Y49","v":12553.95},null,{"$f":"AA24+AA25+AA32+AA33+AA40+AA41+AA48+AA49","v":20451.0},null,20451.0,null,{"$f":"AE24+AE25+AE32+AE33+AE40+AE41+AE48+AE49","v":2985.0},null,{"$f":"AG24+AG25+AG32+AG33+AG40+AG41+AG48+AG49","v":2985.0},null,{"$f":"AI24+AI25+AI32+AI33+AI40+AI41+AI48+AI49","v":20558.0}]
[null,"Coste total anual del conductor, incluidos costes de empresa (Seg. Soc. y otros) €",null,null,41626.13,null,37501.03,null,37501.03,null,37501.03,null,37501.03,null,37501.03,null,41251.12,null,41251.12,null,41251.12,null,37501.03,null,37501.03,null,37501.03,null,37501.03,null,33750.92,null,33750.92,null,37501.03]
[null,"Dieta total diaria del conductor (€/día)",null,null,93.09,null,41.49,null,41.49,null,41.49,null,18.86,null,37.72,null,41.49,null,41.49,null,41.49,null,41.49,null,37.72,null,37.72,null,37.72,null,18.86,null,18.86,null,41.49]
[null,"Número de días con dieta al año",null,null,250.0,null,225.0,null,200.0,null,200.0,null,180.0,null,133.0,null,200.0,null,200.0,null,200.0,null,225.0,null,75.0,null,200.0,null,200.0,null,150.0,null,150.0,null,225.0]
[null,"Dietas totales anuales (€)",null,null,{"$f":"E52*E53","v":23273.0},null,{"$f":"G52*G53","v":9335.0},null,{"$f":"I52*I53","v":8298.0},null,8298.0,null,{"$f":"M52*M53","v":3395.0},null,{"$f":"O52*O53","v":5017.0},null,{"$f":"Q52*Q53","v":8298.0},null,{"$f":"S52*S53","v":8298.0},null,8298.0,null,{"$f":"W52*W53","v":9335.0},null,{"$f":"Y52*Y53","v":2829.0},null,{"$f":"AA52*AA53","v":7544.0},null,7544.0,null,{"$f":"AE52*AE53","v":2829.0},null,{"$f":"AG52*AG53","v":2829.0},null,{"$f":"AI52*AI53","v":9335.0}]
[null,"Plus anual de actividad del conductor (€/km)",null,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.1016,null,0.1016,null,0.1016,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.0708,null,0.0708]
[null,"Plus anual de actividad del conductor (€)",null,null,{"$f":"E55*E9","v":10620.0},null,{"$f":"G55*G9","v":8496.0},null,{"$f":"I55*I9","v":7080.0},null,7080.0,null,{"$f":"M55*M9","v":4248.0},null,{"$f":"O55*O9","v":6372.0},null,{"$f":"Q55*Q9","v":10668.0},null,{"$f":"S55*S9","v":10160.0},null,10160.0,null,{"$f":"W55*W9","v":8496.0},null,{"$f":"Y55*Y9","v":4956.0},null,{"$f":"AA55*AA9","v":8496.0},null,8496.0,null,{"$f":"AE55*AE9","v":3540.0},null,{"$f":"AG55*AG9","v":3540.0},null,{"$f":"AI55*AI9","v":8496.0}]
[null,"COSTES DE PERSONAL",null,null,{"$f":"E51+E54+E56","v":75519.13},null,{"$f":"G51+G54+G56","v":55332.03},null,{"$f":"I51+I54+I56","v":52879.03},null,52879.03,null,{"$f":"M51+M54+M56","v":45144.03},null,{"$f":"O51+O54+O56","v":48890.03},null,{"$f":"Q51+Q54+Q56","v":60217.12},null,{"$f":"S51+S54+S56","v":59709.12},null,59709.12,null,{"$f":"W51+W54+W56","v":55332.03},null,{"$f":"Y51+Y54+Y56","v":45286.03},null,{"$f":"AA51+AA54+AA56","v":53541.03},null,53541.03,null,{"$f":"AE51+AE54+AE56","v":40119.92},null,{"$f":"AG51+AG54+AG56","v":40119.92},null,{"$f":"AI51+AI54+AI56","v":55332.03}]
[null,"Responsabilidad civil del vehículo de tracción (€)",null,null,2030.8,null,2030.8,null,2030.8,null,2030.8,null,2030.8,null,2104.99,null,2030.8,null,2030.8,null,2030.8,null,2030.8,null,2104.99,null,2030.8,null,2030.8,null,1421.87,null,1421.87,null,2030.8]
[null,"Responsabilidad civil del remolque o semirremolque (€)",null,null,640.67,null,640.67,null,640.67,null,640.67,null,640.67,null,null,null,640.67,null,640.67,null,640.67,null,640.67,null,null,null,640.67,null,640.67,null,null,null,null,null,640.67]
[null,"Responsabilidad civil de la mercancía (€)",null,null,152.23,null,152.23,null,152.23,null,152.23,null,152.23,null,152.23,null,803.44,null,1273.1,null,1273.1,null,177.84,null,152.23,null,152.23,null,152.23,null,null,null,null,null,152.23]
[null,"Seguro de accidentes de personal de a bordo (€)",null,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65,null,70.65]
[null,"Retirada del carné de conducir (€)",null,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87,null,175.87]
[null,"Seguro de la mercancía (€)",null,null,861.7,null,861.7,null,468.35,null,468.35,null,0.0,null,514.43,null,861.7,null,861.7,null,861.7,null,1242.65,null,1052.09,null,429.95,null,429.95,null,314.82,null,314.82,null,861.7]
[null,"Daños propios (seguro todo riesgo) (€)",null,null,3795.6,null,3795.6,null,3795.6,null,3795.6,null,4002.37,null,1713.0,null,4560.03,null,4560.03,null,4560.03,null,4943.86,null,2127.47,null,3795.6,null,3795.6,null,2383.29,null,2383.29,null,3795.6]
[null,"Otros seguros (€)",null,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,637.43,null,288.77,null,288.77,null,637.43]
[null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,{"$f":"SUM(E58:E65)","v":8364.95},null,{"$f":"SUM(G58:G65)","v":8364.95},null,{"$f":"SUM(I58:I65)","v":7971.6},null,7971.6,null,{"$f":"SUM(M58:M65)","v":7710.02},null,{"$f":"SUM(O58:O65)","v":5368.6},null,{"$f":"SUM(Q58:Q65)","v":9780.59},null,{"$f":"SUM(S58:S65)","v":10250.25},null,10250.25,null,{"$f":"SUM(W58:W65)","v":9919.77},null,{"$f":"SUM(Y58:Y65)","v":6320.73},null,{"$f":"SUM(AA58:AA65)","v":7933.2},null,7933.2,null,{"$f":"SUM(AE58:AE65)","v":4655.27},null,4655.27,null,{"$f":"SUM(AI58:AI65)","v":8364.95}]
[null,"Visados",null,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.75,null,17.03,null,17.03,null,17.75]
[null,"Inspección técnica de vehículos (I.T.V.) (€)",null,null,121.58,null,121.58,null,121.58,null,121.58,null,121.58,null,73.97,null,121.58,null,121.58,null,121.58,null,121.58,null,73.97,null,121.58,null,121.58,null,55.87,null,55.87,null,121.58]
[null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo (€)",null,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,384.61,null,315.25,null,315.25,null,384.61]
[null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.) (€)",null,null,331.11,null,331.11,null,331.11,null,331.11,null,331.11,null,235.79,null,331.11,null,331.11,null,331.11,null,331.11,null,235.79,null,331.11,null,331.11,null,165.55,null,165.55,null,331.11]
[null,"Revisión tacógrafo (€)",null,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,89.44,null,null,null,89.44]
[null,"Inspecciones A.T.P. (transporte mercancías perecederas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82.34,null,82.34,null,null,null,null,null,null,null,null,null,0.0]
[null,"Inspecciones A.D.R. (transporte mercancías peligrosas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,141.95,null,752.39,null,752.39,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,"Otros costes fiscales (€)",null,null,31.23,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"COSTE FISCAL TOTAL ANUAL",null,null,{"$f":"SUM(E67:E74)","v":975.72},null,{"$f":"SUM(G67:G74)","v":944.49},null,{"$f":"SUM(I67:I74)","v":944.49},null,944.49,null,{"$f":"SUM(M67:M74)","v":944.49},null,{"$f":"SUM(O67:O74)","v":801.56},null,{"$f":"SUM(Q67:Q74)","v":1086.44},null,{"$f":"SUM(S67:S74)","v":1696.88},null,1696.88,null,{"$f":"SUM(W67:W74)","v":1026.83},null,{"$f":"SUM(Y67:Y74)","v":883.9},null,{"$f":"SUM(AA67:AA74)","v":944.49},null,944.49,null,{"$f":"SUM(AE67:AE74)","v":643.14},null,{"$f":"SUM(AG67:AG74)","v":553.7},null,{"$f":"SUM(AI67:AI74)","v":944.49}]
[null,"SEGUROS Y COSTES FISCALES",null,null,{"$f":"E66+E75","v":9340.67},null,{"$f":"G66+G75","v":9309.44},null,{"$f":"I66+I75","v":8916.09},null,8916.09,null,{"$f":"M66+M75","v":8654.51},null,{"$f":"O66+O75","v":6170.16},null,{"$f":"Q66+Q75","v":10867.03},null,{"$f":"S66+S75","v":11947.13},null,11947.13,null,{"$f":"W66+W75","v":10946.6},null,{"$f":"Y66+Y75","v":7204.63},null,{"$f":"AA66+AA75","v":8877.69},null,8877.69,null,{"$f":"AE66+AE75","v":5298.41},null,{"$f":"AG66+AG75","v":5208.97},null,{"$f":"AI66+AI75","v":9309.44}]
[null,"Precio del carburante, con IVA (€/litro)",null,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903,null,1.3903]
[null,"Descuento (€/litro)",null,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.1192,null,0.702,null,0.702,null,0.1192]
[null,"IVA aplicado al carburante (%)(€/litro)",null,21.0,{"$f":"ROUND((D79/100)*(E77-E78)/(1+D79/100),4)","v":0.2206},21.0,{"$f":"ROUND((F79/100)*(G77-G78)/(1+F79/100),4)","v":0.2206},21.0,{"$f":"ROUND((H79/100)*(I77-I78)/(1+H79/100),4)","v":0.2206},21.0,{"$f":"ROUND((J79/100)*(K77-K78)/(1+J79/100),4)","v":0.2206},21.0,{"$f":"ROUND((L79/100)*(M77-M78)/(1+L79/100),4)","v":0.2206},21.0,{"$f":"ROUND((N79/100)*(O77-O78)/(1+N79/100),4)","v":0.2206},21.0,{"$f":"ROUND((P79/100)*(Q77-Q78)/(1+P79/100),4)","v":0.2206},21.0,{"$f":"ROUND((R79/100)*(S77-S78)/(1+R79/100),4)","v":0.2206},21.0,{"$f":"ROUND((T79/100)*(U77-U78)/(1+T79/100),4)","v":0.2206},21.0,{"$f":"ROUND((V79/100)*(W77-W78)/(1+V79/100),4)","v":0.2206},21.0,{"$f":"ROUND((X79/100)*(Y77-Y78)/(1+X79/100),4)","v":0.2206},21.0,{"$f":"ROUND((Z79/100)*(AA77-AA78)/(1+Z79/100),4)","v":0.2206},21.0,{"$f":"ROUND((AB79/100)*(AC77-AC78)/(1+AB79/100),4)","v":0.2206},21.0,{"$f":"ROUND((AD79/100)*(AE77-AE78)/(1+AD79/100),4)","v":0.1195},21.0,{"$f":"ROUND((AF79/100)*(AG77-AG78)/(1+AF79/100),4)","v":0.1195},21.0,{"$f":"ROUND((AH79/100)*(AI77-AI78)/(1+AH79/100),4)","v":0.2206}]
[null,"Precio carburante sin IVA (€/litro)",null,null,{"$f":"ROUND((E77-E78)/(1+D79/100),4)","v":1.0505},null,{"$f":"ROUND((G77-G78)/(1+F79/100),4)","v":1.0505},null,{"$f":"ROUND((I77-I78)/(1+H79/100),4)","v":1.0505},null,{"$f":"ROUND((K77-K78)/(1+J79/100),4)","v":1.0505},null,{"$f":"ROUND((M77-M78)/(1+L79/100),4)","v":1.0505},null,{"$f":"ROUND((O77-O78)/(1+N79/100),4)","v":1.0505},null,{"$f":"ROUND((Q77-Q78)/(1+P79/100),4)","v":1.0505},null,{"$f":"ROUND((S77-S78)/(1+R79/100),4)","v":1.0505},null,{"$f":"ROUND((U77-U78)/(1+T79/100),4)","v":1.0505},null,{"$f":"ROUND((W77-W78)/(1+V79/100),4)","v":1.0505},null,{"$f":"ROUND((Y77-Y78)/(1+X79/100),4)","v":1.0505},null,{"$f":"ROUND((AA77-AA78)/(1+Z79/100),4)","v":1.0505},null,{"$f":"ROUND((AC77-AC78)/(1+AB79/100),4)","v":1.0505},null,{"$f":"ROUND((AE77-AE78)/(1+AD79/100),4)","v":0.5688},null,{"$f":"ROUND((AG77-AG78)/(1+AF79/100),4)","v":0.5688},null,{"$f":"ROUND((AI77-AI78)/(1+AH79/100),4)","v":1.0505}]
[null,"GASTO TOTAL ANUAL EN CARBURANTE DEL VEHÍCULO (€, SIN IVA)",null,null,{"$f":"ROUND(E9/100*E12*E80,0)","v":55151.0},null,{"$f":"ROUND(G9/100*G12*G80,0)","v":44121.0},null,{"$f":"ROUND(I9/100*I12*I80,0)","v":36768.0},null,{"$f":"ROUND(K9/100*K12*K80,0)","v":36768.0},null,{"$f":"ROUND(M9/100*M12*M80,0)","v":24267.0},null,{"$f":"ROUND(O9/100*O12*O80,0)","v":23636.0},null,{"$f":"ROUND(Q9/100*Q12*Q80,0)","v":38054.0},null,{"$f":"ROUND(S9/100*S12*S80,0)","v":36242.0},null,{"$f":"ROUND(U9/100*U12*U80,0)","v":36242.0},null,{"$f":"ROUND(W9/100*W12*W80,0)","v":44121.0},null,{"$f":"ROUND(Y9/100*Y12*Y80,0)","v":18384.0},null,{"$f":"ROUND(AA9/100*AA12*AA80,0)","v":44121.0},null,{"$f":"ROUND(AC9/100*AC12*AC80,0)","v":44121.0},null,{"$f":"ROUND(AE9/100*AE12*AE80,0)","v":3271.0},null,{"$f":"ROUND(AG9/100*AG12*AG80,0)","v":3271.0},null,{"$f":"ROUND(AI9/100*AI12*AI80,0)","v":44121.0}]
[null,"Precio de compra de carburante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9561,null,0.9561,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"IVA aplicado al carburante (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.0,null,21.0,null,null,null,null,null,null,null,null,null,21.0]
[null,"IVA aplicado al carburante (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W84/100)*(W82-W83)/(1+W84/100)","v":0.17},null,{"$f":"(Y84/100)*(Y82-Y83)/(1+Y84/100)","v":0.17},null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W82-W83)/(1+W84/100)","v":0.7902},null,{"$f":"(Y82-Y83)/(1+Y84/100)","v":0.7902},null,null,null,null,null,null,null,null,null,0.0]
[null,"Consumo medio de los equipos (litros/hora)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0,null,3.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Horas anuales de utilización de los equipos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000.0,null,2000.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTO TOTAL ANUAL EN CARBURANTE EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W86*W87*W88","v":6321.6},null,{"$f":"Y86*Y87*Y88","v":4741.2},null,null,null,null,null,null,null,null,null,0.0]
[null,"Número de neumáticos direccionables",null,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0]
[null,"Número de neumáticos motrices",null,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,2.0,null,2.0,null,4.0]
[null,"Número de neumáticos arrastre",null,null,null,null,null,null,2.0,null,2.0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,"Número de neumáticos semirremolque o remolque",null,null,6.0,null,6.0,null,6.0,null,6.0,null,8.0,null,null,null,6.0,null,6.0,null,6.0,null,6.0,null,null,null,6.0,null,6.0,null,null,null,null,null,6.0]
[null,"Precio sin IVA de un neumático direccionable (€)",null,null,728.93,null,728.93,null,728.93,null,728.93,null,728.93,null,772.88,null,728.93,null,728.93,null,728.93,null,728.93,null,772.88,null,728.93,null,728.93,null,212.16,null,212.16,null,728.93]
[null,"Precio sin IVA de un neumático motriz (€)",null,null,728.93,null,728.93,null,728.93,null,728.93,null,728.93,null,772.88,null,728.93,null,728.93,null,728.93,null,728.93,null,772.88,null,728.93,null,728.93,null,212.16,null,212.16,null,728.93]
[null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,728.93,null,728.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,728.93]
[null,"Precio sin IVA de un neumático remolque-semirremolque (€)",null,null,728.93,null,728.93,null,728.93,null,728.93,null,728.93,null,null,null,728.93,null,728.93,null,728.93,null,728.93,null,null,null,728.93,null,728.93,null,null,null,null,null,728.93]
[null,"Duración media de un neumático direccionable (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,125000.0,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,125000.0,null,150000.0,null,150000.0,null,60000.0,null,60000.0,null,150000.0]
[null,"Duración media de un neumático motriz (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,125000.0,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,125000.0,null,150000.0,null,150000.0,null,60000.0,null,60000.0,null,150000.0]
[null,"Duración media de un neumático arrastre (km)",null,null,null,null,null,null,150000.0,null,150000.0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150000.0]
[null,"Duración media de un neumático remolque-semirremolque (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,null,null,150000.0,null,150000.0,null,null,null,null,null,150000.0]
[null,"GASTO TOTAL ANUAL EN NEUMATICOS (€, SIN IVA)",null,null,{"$f":"ROUND(IFERROR(E90*E94*E9/E98,0)+IFERROR(E91*E95*E9/E99,0)+IFERROR(E92*E96*E9/E100,0)+IFERROR(E93*E97*E9/E101,0),0)","v":8747.16},null,{"$f":"ROUND(IFERROR(G90*G94*G9/G98,0)+IFERROR(G91*G95*G9/G99,0)+IFERROR(G92*G96*G9/G100,0)+IFERROR(G93*G97*G9/G101,0),0)","v":6997.73},null,{"$f":"ROUND(IFERROR(I90*I94*I9/I98,0)+IFERROR(I91*I95*I9/I99,0)+IFERROR(I92*I96*I9/I100,0)+IFERROR(I93*I97*I9/I101,0),0)","v":6803.35},null,{"$f":"ROUND(IFERROR(K90*K94*K9/K98,0)+IFERROR(K91*K95*K9/K99,0)+IFERROR(K92*K96*K9/K100,0)+IFERROR(K93*K97*K9/K101,0),0)","v":6803.35},null,{"$f":"ROUND(IFERROR(M90*M94*M9/M98,0)+IFERROR(M91*M95*M9/M99,0)+IFERROR(M92*M96*M9/M100,0)+IFERROR(M93*M97*M9/M101,0),0)","v":12246.02},null,{"$f":"ROUND(IFERROR(O90*O94*O9/O98,0)+IFERROR(O91*O95*O9/O99,0)+IFERROR(O92*O96*O9/O100,0)+IFERROR(O93*O97*O9/O101,0),0)","v":3338.84},null,{"$f":"ROUND(IFERROR(Q90*Q94*Q9/Q98,0)+IFERROR(Q91*Q95*Q9/Q99,0)+IFERROR(Q92*Q96*Q9/Q100,0)+IFERROR(Q93*Q97*Q9/Q101,0),0)","v":6123.01},null,{"$f":"ROUND(IFERROR(S90*S94*S9/S98,0)+IFERROR(S91*S95*S9/S99,0)+IFERROR(S92*S96*S9/S100,0)+IFERROR(S93*S97*S9/S101,0),0)","v":5831.44},null,{"$f":"ROUND(IFERROR(U90*U94*U9/U98,0)+IFERROR(U91*U95*U9/U99,0)+IFERROR(U92*U96*U9/U100,0)+IFERROR(U93*U97*U9/U101,0),0)","v":5831.44},null,{"$f":"ROUND(IFERROR(W90*W94*W9/W98,0)+IFERROR(W91*W95*W9/W99,0)+IFERROR(W92*W96*W9/W100,0)+IFERROR(W93*W97*W9/W101,0),0)","v":6997.73},null,{"$f":"ROUND(IFERROR(Y90*Y94*Y9/Y98,0)+IFERROR(Y91*Y95*Y9/Y99,0)+IFERROR(Y92*Y96*Y9/Y100,0)+IFERROR(Y93*Y97*Y9/Y101,0),0)","v":2596.88},null,{"$f":"ROUND(IFERROR(AA90*AA94*AA9/AA98,0)+IFERROR(AA91*AA95*AA9/AA99,0)+IFERROR(AA92*AA96*AA9/AA100,0)+IFERROR(AA93*AA97*AA9/AA101,0),0)","v":6997.73},null,{"$f":"ROUND(IFERROR(AC90*AC94*AC9/AC98,0)+IFERROR(AC91*AC95*AC9/AC99,0)+IFERROR(AC92*AC96*AC9/AC100,0)+IFERROR(AC93*AC97*AC9/AC101,0),0)","v":6997.73},null,{"$f":"ROUND(IFERROR(AE90*AE94*AE9/AE98,0)+IFERROR(AE91*AE95*AE9/AE99,0)+IFERROR(AE92*AE96*AE9/AE100,0)+IFERROR(AE93*AE97*AE9/AE101,0),0)","v":707.2},null,{"$f":"ROUND(IFERROR(AG90*AG94*AG9/AG98,0)+IFERROR(AG91*AG95*AG9/AG99,0)+IFERROR(AG92*AG96*AG9/AG100,0)+IFERROR(AG93*AG97*AG9/AG101,0),0)","v":707.2},null,{"$f":"ROUND(IFERROR(AI90*AI94*AI9/AI98,0)+IFERROR(AI91*AI95*AI9/AI99,0)+IFERROR(AI92*AI96*AI9/AI100,0)+IFERROR(AI93*AI97*AI9/AI101,0),0)","v":6997.73}]
[null,"Coste de mantenimiento por km, sin IVA (€/km)",null,null,0.0194,null,0.0194,null,0.0233,null,0.0233,null,0.0785,null,0.023,null,0.0628,null,0.0628,null,0.0628,null,0.023,null,0.3061,null,0.0194,null,0.0194,null,0.011,null,0.011,null,0.0194]
[null,"GASTO ANUAL EN MANTENIMIENTO, SIN IVA (€)",null,null,{"$f":"E103*E9","v":2910.0},null,{"$f":"G103*G9","v":2328.0},null,{"$f":"I103*I9","v":2330.0},null,{"$f":"K103*K9","v":2330.0},null,{"$f":"M103*M9","v":4710.0},null,{"$f":"O103*O9","v":2070.0},null,{"$f":"Q103*Q9","v":6594.0},null,{"$f":"S103*S9","v":6280.0},null,{"$f":"U103*U9","v":6280.0},null,{"$f":"W103*W9","v":2760.0},null,{"$f":"Y103*Y9","v":21427.0},null,{"$f":"AA103*AA9","v":2328.0},null,{"$f":"AC103*AC9","v":2328.0},null,{"$f":"AE103*AE9","v":550.0},null,{"$f":"AG103*AG9","v":550.0},null,{"$f":"AI103*AI9","v":2328.0}]
[null,"Coste de reparaciones por km, sin IVA (€/km)",null,null,0.0383,null,0.0383,null,0.0383,null,0.0383,null,0.0491,null,0.0307,null,0.0482,null,0.0482,null,0.0482,null,0.0482,null,0.0383,null,0.0383,null,0.0383,null,0.0196,null,0.0196,null,0.0383]
[null,"GASTO ANUAL EN REPARACIONES, SIN IVA (€)",null,null,{"$f":"E105*E9","v":5745.0},null,{"$f":"G105*G9","v":4596.0},null,{"$f":"I105*I9","v":3830.0},null,{"$f":"K105*K9","v":3830.0},null,{"$f":"M105*M9","v":2946.0},null,{"$f":"O105*O9","v":2763.0},null,{"$f":"Q105*Q9","v":5061.0},null,{"$f":"S105*S9","v":4820.0},null,{"$f":"U105*U9","v":4820.0},null,{"$f":"W105*W9","v":5784.0},null,{"$f":"Y105*Y9","v":2681.0},null,{"$f":"AA105*AA9","v":4596.0},null,{"$f":"AC105*AC9","v":4596.0},null,{"$f":"AE105*AE9","v":980.0},null,{"$f":"AG105*AG9","v":980.0},null,{"$f":"AI105*AI9","v":4596.0}]
[null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,null,19164.56,null,2384.92,null,1987.44,null,1987.44,null,0.0,null,1533.17,null,10434.05,null,9937.18,null,9937.18,null,2384.92,null,1192.47,null,2384.92,null,2384.92,null,0.0,null,0.0,null,2384.92]
[null,"COSTES VARIABLES",null,null,{"$f":"ROUND(E81+E89+E102+E104+E106+E107+E114,0)","v":94390.76},null,{"$f":"ROUND(G81+G89+G102+G104+G106+G107+G114,0)","v":62566.08},null,{"$f":"ROUND(I81+I89+I102+I104+I106+I107+I114,0)","v":53500.82},null,{"$f":"ROUND(K81+K89+K102+K104+K106+K107+K114,0)","v":53500.82},null,{"$f":"ROUND(M81+M89+M102+M104+M106+M107+M114,0)","v":45345.16},null,{"$f":"ROUND(O81+O89+O102+O104+O106+O107+O114,0)","v":34486.6},null,{"$f":"ROUND(Q81+Q89+Q102+Q104+Q106+Q107+Q114,0)","v":68110.46},null,{"$f":"ROUND(S81+S89+S102+S104+S106+S107+S114,0)","v":64867.2},null,{"$f":"ROUND(U81+U89+U102+U104+U106+U107+U114,0)","v":64867.2},null,{"$f":"ROUND(W81+W89+W102+W104+W106+W107+W114,0)","v":70507.68},null,{"$f":"ROUND(Y81+Y89+Y102+Y104+Y106+Y107+Y114,0)","v":51913.56},null,{"$f":"ROUND(AA81+AA89+AA102+AA104+AA106+AA107+AA114,0)","v":62566.08},null,{"$f":"ROUND(AC81+AC89+AC102+AC104+AC106+AC107+AC114,0)","v":62566.08},null,{"$f":"ROUND(AE81+AE89+AE102+AE104+AE106+AE107+AE114,0)","v":5800.97},null,{"$f":"ROUND(AG81+AG89+AG102+AG104+AG106+AG107+AG114,0)","v":5800.97},null,{"$f":"ROUND(AI81+AI89+AI102+AI104+AI106+AI107+AI114,0)","v":62566.08}]
[null,"% Costes anuales de gestión, administración y comercialización, repercutibles a este vehículo ",null,6.5,{"$f":"ROUND((E50+E57+E76+E108)*(D109/100),0)","v":13300.86},6.5,{"$f":"ROUND((G50+G57+G76+G108)*(F109/100),0)","v":9604.76},6.5,{"$f":"ROUND((I50+I57+I76+I108)*(H109/100),0)","v":8472.94},6.5,{"$f":"ROUND((K50+K57+K76+K108)*(J109/100),0)","v":8472.94},6.5,{"$f":"ROUND((M50+M57+M76+M108)*(L109/100),0)","v":7383.33},6.5,{"$f":"ROUND((O50+O57+O76+O108)*(N109/100),0)","v":6380.83},6.5,{"$f":"ROUND((Q50+Q57+Q76+Q108)*(P109/100),0)","v":10811.49},6.5,{"$f":"ROUND((S50+S57+S76+S108)*(R109/100),0)","v":10565.84},6.5,{"$f":"ROUND((U50+U57+U76+U108)*(T109/100),0)","v":10565.84},6.5,{"$f":"ROUND((V109/100)*(W50+W57+W76+W108),0)","v":10372.59},6.5,{"$f":"ROUND((X109/100)*(Y50+Y57+Y76+Y108),0)","v":7602.28},6.5,{"$f":"ROUND((Z109/100)*(AA50+AA57+AA76+AA108),0)","v":9453.33},6.5,{"$f":"ROUND((AB109/100)*(AC50+AC57+AC76+AC108),0)","v":9453.33},6.5,{"$f":"ROUND((AD109/100)*(AE50+AE57+AE76+AE108),0)","v":3523.28},6.5,{"$f":"ROUND((AF109/100)*(AG50+AG57+AG76+AG108),0)","v":3517.47},6.5,{"$f":"ROUND((AH109/100)*(AI50+AI57+AI76+AI108),0)","v":9604.76}]
[]
[]
[null,"COSTES INDIRECTOS",null,null,{"$f":"ROUND((E50+E57+E76+E108)*(D109/100),0)","v":13300.86},null,{"$f":"ROUND((G50+G57+G76+G108)*(F109/100),0)","v":9604.76},null,{"$f":"ROUND((I50+I57+I76+I108)*(H109/100),0)","v":8472.94},null,{"$f":"ROUND((K50+K57+K76+K108)*(J109/100),0)","v":8472.94},null,{"$f":"ROUND((M50+M57+M76+M108)*(L109/100),0)","v":7383.33},null,{"$f":"ROUND((O50+O57+O76+O108)*(N109/100),0)","v":6380.83},null,{"$f":"ROUND((Q50+Q57+Q76+Q108)*(P109/100),0)","v":10811.49},null,{"$f":"ROUND((S50+S57+S76+S108)*(R109/100),0)","v":10565.84},null,{"$f":"ROUND((U50+U57+U76+U108)*(T109/100),0)","v":10565.84},null,{"$f":"ROUND((V109/100)*(W50+W57+W76+W108),0)","v":10372.59},null,{"$f":"ROUND((X109/100)*(Y50+Y57+Y76+Y108),0)","v":7602.28},null,{"$f":"ROUND((Z109/100)*(AA50+AA57+AA76+AA108),0)","v":9453.33},null,{"$f":"ROUND((AB109/100)*(AC50+AC57+AC76+AC108),0)","v":9453.33},null,{"$f":"ROUND((AD109/100)*(AE50+AE57+AE76+AE108),0)","v":3523.28},null,{"$f":"ROUND((AF109/100)*(AG50+AG57+AG76+AG108),0)","v":3517.47},null,{"$f":"ROUND((AH109/100)*(AI50+AI57+AI76+AI108),0)","v":9604.76}]
[null,"COSTES TOTALES",null,null,{"$f":"(E50+E57+E76+E108)+E112","v":241236.41999999998},null,{"$f":"(G50+G57+G76+G108)+G112","v":153670.62},null,{"$f":"(I50+I57+I76+I108)+I112","v":134962.96000000002},null,{"$f":"(K50+K57+K76+K108)+K112","v":134962.96000000002},null,{"$f":"(M50+M57+M76+M108)+M112","v":116779.59},null,{"$f":"(O50+O57+O76+O108)+O112","v":100459.42},null,{"$f":"(Q50+Q57+Q76+Q108)+Q112","v":171694.08000000002},null,{"$f":"(S50+S57+S76+S108)+S112","v":167601.64000000001},null,{"$f":"(U50+U57+U76+U108)+U112","v":167601.64000000001},null,{"$f":"(W50+W57+W76+W108)+W112","v":166481.23000000001},null,{"$f":"(Y50+Y57+Y76+Y108)+Y112","v":100545.06},null,{"$f":"(AA50+AA57+AA76+AA108)+AA112","v":151493.87},null,{"$f":"(AC50+AC57+AC76+AC108)+AC112","v":151493.87},null,{"$f":"(AE50+AE57+AE76+AE108)+AE112","v":56318.16},null,{"$f":"(AG50+AG57+AG76+AG108)+AG112","v":56318.16},null,{"$f":"(AI50+AI57+AI76+AI108)+AI112","v":153670.62}]
[null,"GASTO ANUAL POR CONSUMO DE DISOLUCION DE UREA (€, sin IVA)",null,null,2673.04,null,2138.43,null,1782.03,null,1782.03,null,1176.14,null,1145.59,null,1844.4,null,1756.58,null,1756.58,null,2138.43,null,891.01,null,2138.43,null,2138.43,null,292.77,null,292.77,null,2138.43]
[null,"Coste anual por disolucion de urea por kilometro(€/km, sin IVA)",null,null,0.0178,null,0.0178,null,0.0178,null,0.0178,null,0.0196,null,0.0127,null,0.0176,null,0.0176,null,0.0176,null,0.0178,null,0.0127,null,0.0178,null,0.0178,null,0.0059,null,0.0059,null,0.0178]
[]
[]
[]
[]
[null,"Valor de adquisición del vehículo sin IVA y sin neumáticos (€)",null,null,{"$f":"E21-(E90*E94+E91*E95+E92*E96)","v":111140.04},null,{"$f":"G21-(G90*G94+G91*G95+G92*G96)","v":111139.98299999999},null,{"$f":"I21-(I90*I94+I91*I95+I92*I96)","v":109713.663},null,{"$f":"K21-(K90*K94+K91*K95+K92*K96)","v":109713.663},null,{"$f":"M21-(M90*M94+M91*M95+M92*M96)","v":111139.98299999999},null,{"$f":"O21-(O90*O94+O91*O95+O92*O96)","v":66833.568000000014},null,{"$f":"Q21-(Q90*Q94+Q91*Q95+Q92*Q96)","v":111139.98299999999},null,{"$f":"S21-(S90*S94+S91*S95+S92*S96)","v":111139.98299999999},null,{"$f":"U21-(U90*U94+U91*U95+U92*U96)","v":111139.98299999999},null,{"$f":"W21-(W90*W94+W91*W95+W92*W96)","v":111139.98299999999},null,{"$f":"Y21-(Y90*Y94+Y91*Y95+Y92*Y96)","v":66833.568000000014},null,{"$f":"AA21-(AA90*AA94+AA91*AA95+AA92*AA96)","v":111139.98299999999},null,{"$f":"AC21-(AC90*AC94+AC91*AC95+AC92*AC96)","v":111139.98299999999},null,{"$f":"AE21-(AE90*AE94+AE91*AE95+AE92*AE96)","v":23326.845000000001},null,{"$f":"AG21-(AG90*AG94+AG91*AG95+AG92*AG96)","v":23326.845000000001},null,{"$f":"AI21-(AI90*AI94+AI91*AI95+AI92*AI96)","v":111139.98299999999}]
[null,"Valor de adquisición del remolque-semirremolque sin IVA y sin neumáticos (€)",null,null,{"$f":"E37-(E93*E97)","v":33602.04},null,{"$f":"G37-(G93*G97)","v":33602.04},null,{"$f":"I37-(I93*I97)","v":25429.040000000001},null,{"$f":"K37-(K93*K97)","v":25429.040000000001},null,{"$f":"M37-(M93*M97)","v":27923.72},null,{"$f":"O37-(O93*O97)","v":0},null,{"$f":"Q37-(Q93*Q97)","v":89000.04},null,{"$f":"S37-(S93*S97)","v":89000.04},null,{"$f":"U37-(U93*U97)","v":89000.04},null,{"$f":"W37-(W93*W97)","v":61004.04},null,{"$f":"Y37-(Y93*Y97)","v":0},null,{"$f":"AA37-(AA93*AA97)","v":36678.04},null,{"$f":"AC37-(AC93*AC97)","v":36678.04},null,{"$f":"AE37-(AE93*AE97)","v":0},null,{"$f":"AG37-(AG93*AG97)","v":0},null,{"$f":"AI37-(AI93*AI97)","v":33602.04}]
[null,"Dietas y plus de actividad anuales del conductor (€)",null,null,{"$f":"E54+E56","v":30650},null,{"$f":"G54+G56","v":16122},null,{"$f":"I54+I56","v":13904},null,{"$f":"K54+K56","v":13904},null,{"$f":"M54+M56","v":6910.7999999999993},null,{"$f":"O54+O56","v":10296.630000000001},null,{"$f":"Q54+Q56","v":17153.5},null,{"$f":"S54+S56","v":16694},null,{"$f":"U54+U56","v":16694},null,{"$f":"W54+W56","v":15774},null,{"$f":"Y54+Y56","v":7038.25},null,{"$f":"AA54+AA56","v":14502},null,{"$f":"AC54+AC56","v":14502},null,{"$f":"AE54+AE56","v":5759},null,{"$f":"AG54+AG56","v":5759},null,{"$f":"AI54+AI56","v":16122}]
[null,"Gasto anual en mantenimiento, sin IVA (€)",null,null,{"$f":"E104+E106","v":8100},null,{"$f":"G104+G106","v":6480},null,{"$f":"I104+I106","v":5760},null,{"$f":"K104+K106","v":5760},null,{"$f":"M104+M106","v":7164},null,{"$f":"O104+O106","v":4509},null,{"$f":"Q104+Q106","v":10899},null,{"$f":"S104+S106","v":10380},null,{"$f":"U104+U106","v":10380},null,{"$f":"W104+W106","v":7992},null,{"$f":"Y104+Y106","v":4508},null,{"$f":"AA104+AA106","v":6480},null,{"$f":"AC104+AC106","v":6480},null,{"$f":"AE104+AE106","v":1430},null,{"$f":"AG104+AG106","v":1430},null,{"$f":"AI104+AI106","v":6480}]
[null,"Costo neumáticos por km",null,null,{"$f":"IFERROR((E90*E94/E98),0)+IFERROR((E91*E95/E99),0)+IFERROR((E92*E96/E100),0)+IFERROR((E93*E97/E101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((G90*G94/G98),0)+IFERROR((G91*G95/G99),0)+IFERROR((G92*G96/G100),0)+IFERROR((G93*G97/G101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((I90*I94/I98),0)+IFERROR((I91*I95/I99),0)+IFERROR((I92*I96/I100),0)+IFERROR((I93*I97/I101),0)","v":6.6561599999999999E-2},null,{"$f":"IFERROR((K90*K94/K98),0)+IFERROR((K91*K95/K99),0)+IFERROR((K92*K96/K100),0)+IFERROR((K93*K97/K101),0)","v":6.6561599999999999E-2},null,{"$f":"IFERROR((M90*M94/M98),0)+IFERROR((M91*M95/M99),0)+IFERROR((M92*M96/M100),0)+IFERROR((M93*M97/M101),0)","v":0.1996848},null,{"$f":"IFERROR((O90*O94/O98),0)+IFERROR((O91*O95/O99),0)+IFERROR((O92*O96/O100),0)+IFERROR((O93*O97/O101),0)","v":3.62952E-2},null,{"$f":"IFERROR((Q90*Q94/Q98),0)+IFERROR((Q91*Q95/Q99),0)+IFERROR((Q92*Q96/Q100),0)+IFERROR((Q93*Q97/Q101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((S90*S94/S98),0)+IFERROR((S91*S95/S99),0)+IFERROR((S92*S96/S100),0)+IFERROR((S93*S97/S101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((U90*U94/U98),0)+IFERROR((U91*U95/U99),0)+IFERROR((U92*U96/U100),0)+IFERROR((U93*U97/U101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((W90*W94/W98),0)+IFERROR((W91*W95/W99),0)+IFERROR((W92*W96/W100),0)+IFERROR((W93*W97/W101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((Y90*Y94/Y98),0)+IFERROR((Y91*Y95/Y99),0)+IFERROR((Y92*Y96/Y100),0)+IFERROR((Y93*Y97/Y101),0)","v":3.62952E-2},null,{"$f":"IFERROR((AA90*AA94/AA98),0)+IFERROR((AA91*AA95/AA99),0)+IFERROR((AA92*AA96/AA100),0)+IFERROR((AA93*AA97/AA101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((AC90*AC94/AC98),0)+IFERROR((AC91*AC95/AC99),0)+IFERROR((AC92*AC96/AC100),0)+IFERROR((AC93*AC97/AC101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((AE90*AE94/AE98),0)+IFERROR((AE91*AE95/AE99),0)+IFERROR((AE92*AE96/AE100),0)+IFERROR((AE93*AE97/AE101),0)","v":1.3838E-2},null,{"$f":"IFERROR((AG90*AG94/AG98),0)+IFERROR((AG91*AG95/AG99),0)+IFERROR((AG92*AG96/AG100),0)+IFERROR((AG93*AG97/AG101),0)","v":1.3838E-2},null,{"$f":"IFERROR((AI90*AI94/AI98),0)+IFERROR((AI91*AI95/AI99),0)+IFERROR((AI92*AI96/AI100),0)+IFERROR((AI93*AI97/AI101),0)","v":5.7052800000000001E-2}]

{"sheet":"Ibilgailu-mota","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"1. Ibilgailu-mota hautatu"]
[]
[]
[]
[null,null,"Ibilgailu-mota:",null,{"$f":"VLOOKUP(F10,T!A2:B17,2,0)","v":"T1"},"Ibilbide luzeko zama arrunteko ibilgailu artikulatua"]
[]
[null,null,"Kalkulu-formularioetara gehitutako datu estatistikoekin simulazioa hasi nahi duzu?"]

{"sheet":"Ibilgailuaren Ezaugarriak","index":3,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,9,10,12]]}
[]
[]
[]
[]
[]
[null,null,"1. Ibilgailuaren Ezaugarriak"]
[]
[]
[null,null,"Ibilgailuaren ezaugarri teknikoak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Deskripzioa:",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$E$1:$AI$283,2,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$E$1:$AI$283,2,0))","v":"Ibilbide luzeko zama arrunteko ibilgailu artikulatua"},null,null,null,null,null,null,null,null,null,null,null,"2024-01-12"]
[]
[null,null,"Potentzia:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,4,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,4,0))","v":200}]
[]
[null,null,"MMA (Tm):",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,5,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,5,0))","v":41000}]
[]
[null,null,"Karga erabilgarria:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,6,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,6,0))","v":25000}]
[]
[null,null,"Ardatz-kopurua:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,7,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,7,0))","v":6}]
[]
[null,null,"Pneumatiko-kopurua:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,8,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,8,0))","v":12}]
[]
[null,null,"Ibilgailuaren ustiapen-ezaugarriak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Urtero egindako kilometroak ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,9,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,9,0))","v":150000}]
[]
[null,null,"Urtean zamarekin egindako kilometroak (%,km) €",null,null,null,null,null,"%",{"$f":"ROUND(J25*H27/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,10,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,10,0))","v":90},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,10,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,10,0))","v":135000}]
[]
[null,null,"Urtero hutsik egindako kilometroak (%,km) €",null,null,null,null,{"$f":"100-H27","v":100},"%",{"$f":"ROUND(J25-J27,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,11,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,11,0))","v":10},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,11,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,11,0))","v":15000}]
[]
[null,null,"Batez besteko kontsumoa (litro/100km) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,12,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,12,0))","v":35}]
[]
[null,null,"Urtean lanean emandako orduak ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,13,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,13,0))","v":2000}]
[]
[null,null,"Uretan lanean zamarekin emandako orduak (%,h)",null,null,null,null,null,"%",{"$f":"ROUND(J33*H35/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,14,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,14,0))","v":90},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,14,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,14,0))","v":1800}]
[]
[null,null,"Urtean lanean hutsik emandako orduak (%,h)",null,null,null,null,{"$f":"100-H35","v":100},"%",{"$f":"J33-J35","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,15,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,15,0))","v":10},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,15,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,15,0))","v":200}]
[]
[null,null,"Urtean betetako lan-egunak ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,16,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,16,0))","v":250}]
[]
[null,null,"Jardunaldi bakoitzeko sartutako orduak ",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(J33/J39,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,17,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,17,0))","v":8}]

{"sheet":"Erosketa kostuak","index":4,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[10,7,10,8],[34,7,34,8],[58,7,58,8],[82,7,82,8]]}
[]
[]
[]
[]
[]
[null,null,"2. Erosketa kostuak"]
[]
[]
[null,null,"Trakziozko Ibilgailua ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$283,3,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$283,3,0))","v":5.6099999999999997E-2}]
[null,null,"Erosteko modua:",null,null,null,null," EROSKETA"]
[]
[null,null,"Leasinga edo urteko errenta ordainduz (€)",null,null,null,null,0,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,18,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,18,0))","v":0}]
[]
[null,null,"Trakziozko ibilgailuaren erosketa  (€) "]
[]
[null,null,"Tarifako prezioa BEZ gabe (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,19,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,19,0))","v":128243.27}]
[]
[null,null,"Tarifa gaineko deskontua (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,20,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,20,0))","v":10}]
[]
[null,null,"Erosketa-prezioa BEZ gabe (€)",null,null,null,null,{"$f":"ROUND((1-H19/100)*H17,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,21,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,21,0))","v":115419}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,22,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,22,0))","v":5}]
[]
[null,null,"Tarifako prezioaren gaineko hondar-balioa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,23,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,23,0))","v":15}]
[]
[null,null,"Hondar-balioa BEZ gabe (€)",null,null,null,null,{"$f":"ROUND(H25/100*H17,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,23,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,23,0))","v":19236}]
[]
[null,null,"TRAKZIOZKO IBILGAILUAREN AMORTIZAZIOA ",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H11=T!F2,ROUND((H21-H27-('Kostu aldakorrak'!J$71))*(1/H23),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,24,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,24,0))","v":17525}]
[]
[null,null,"TRAKZIOZKO IBILGAILUAREN FINANTZA GASTUAK ",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H11=T!F2,ROUND((H21-H27-('Kostu aldakorrak'!J$71))*(-(1/H23)+J$10/(1-POWER(1+J$10,-H23))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,25,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,25,0))","v":3057}]
[]
[null,null,"Ibilgailuari karrozeria jartzea",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Erosteko modua:",null,null,null,null,"EROSKETA"]
[]
[null,null,"Leasinga edo urteko errenta ordainduz (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,26,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,26,0))","v":""}]
[]
[null,null,"Compra carrozado (€) "]
[]
[null,null,"Tarifako prezioa BEZ gabe (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,27,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,27,0))","v":""}]
[]
[null,null,"Tarifa gaineko deskontua (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,28,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,28,0))","v":""}]
[]
[null,null,"Erosketa-prezioa BEZ gabe (€)",null,null,null,null,{"$f":"(1-H43/100)*H41","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,29,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,29,0))","v":""}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,30,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,30,0))","v":""}]
[]
[null,null,"Tarifako prezioaren gaineko hondar-balioa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,31,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,31,0))","v":""}]
[]
[null,null,"Hondar-balio BEZ gabe (€)",null,null,null,null,{"$f":"ROUND(H49/100*H41,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,31,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,31,0))","v":""}]
[]
[null,null,"KARROZERIAREN AMORTIZAZIOA",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H35=T!F2,ROUND((H45-H51)*(1/H47),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,32,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,32,0))","v":""}]
[]
[null,null,"KARROZERIAREN FINANTZA GASTUAK",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H35=T!F2,ROUND((H45-H51)*(-(1/H47)+J$10/(1-POWER(1+J$10,-H47))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,33,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,33,0))","v":""}]
[]
[null,null,"Erdi-atoia edo atoia  ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Erosteko modua:",null,null,null,null," EROSKETA"]
[]
[null,null,"Leasinga edo urteko errenta ordainduz (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,34,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,34,0))","v":0}]
[]
[null,null,"Atoi edo erdi-atoiaren erosketa  (€) "]
[]
[null,null,"Tarifako prezioa BEZ gabe (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,35,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,35,0))","v":39874.33}]
[]
[null,null,"Tarifa gaineko deskontua (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,36,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,36,0))","v":5}]
[]
[null,null,"Erosketa-prezioa BEZ gabe (€)",null,null,null,null,{"$f":"(1-H67/100)*H65","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,37,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,37,0))","v":37881}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,38,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,38,0))","v":7}]
[]
[null,null,"Tarifako prezioaren gaineko hondar-balioa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,39,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,39,0))","v":10}]
[]
[null,null,"Hondar-balio BEZ gabe (€)",null,null,null,null,{"$f":"ROUND(H73/100*H65,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,39,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,39,0))","v":3987}]
[]
[null,null,"ATORIAREN AMORTIZAZIOA ",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H59=T!F2,ROUND((H69-H75-('Kostu aldakorrak'!J53*'Kostu aldakorrak'!J61))*(1/H71),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,40,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,40,0))","v":4231}]
[]
[null,null,"ATORIAREN FINANTZA GASTUAK ",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H59=T!F2,ROUND((H69-H75-('Kostu aldakorrak'!J$53*'Kostu aldakorrak'!J$61))*(-(1/H71)+J$10/(1-POWER(1+J$10,-H71))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,41,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,41,0))","v":1001}]
[]
[null,null,"Ekipo osagarriak",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Erosteko modua:",null,null,null,null,"EROSKETA"]
[]
[null,null,"Leasinga edo urteko errenta ordainduz (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,42,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,42,0))","v":""}]
[]
[null,null,"Compra de los equipos (€) "]
[]
[null,null,"Tarifako prezioa BEZ gabe (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,43,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,43,0))","v":""}]
[]
[null,null,"Tarifa gaineko deskontua (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,44,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,44,0))","v":""}]
[]
[null,null,"Erosketa-prezioa BEZ gabe (€)",null,null,null,null,{"$f":"(1-H91/100)*H89","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,45,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,45,0))","v":""}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,46,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,46,0))","v":""}]
[]
[null,null,"Tarifako prezioaren gaineko hondar-balioa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,47,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,47,0))","v":""}]
[]
[null,null,"Hondar-balio BEZ gabe (€)",null,null,null,null,{"$f":"H97/100*H89","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,47,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,47,0))","v":""}]
[]
[null,null,"EKIPOEN AMORTIZAZIOA",null,null,null,null,{"$f":"IFERROR(IF(H83=T!F2,ROUND((H93-H99)*(1/H95),2),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,48,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,48,0))","v":""}]
[]
[null,null,"EKIPOEN FINANTZA GASTUAK",null,null,null,null,{"$f":"IFERROR(IF(H83=T!F2,ROUND((H93-H99)*(-(1/H95)+J$10/(1-POWER(1+J$10,-H95))),2),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,49,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,49,0))","v":""}]
[]
[null,null,"EROSKETA KOSTUAK",null,null,null,null,{"$f":"ROUND(H13+H29+H31+H37+H53+H55+H61+H77+H79+H85+H101+H103,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,50,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,50,0))","v":25814}]

{"sheet":"Pertsonal-kostuak","index":5,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"3. Pertsonal-kostuak "]
[]
[]
[null,null,"Pertsonal-kostuak ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Gidariaren urteko kostua guztira, enpresa-kostuak barne (Gizarte Seg. eta abar)  €",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,51,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,51,0))","v":37649.699999999997}]
[]
[null,null,"Gidariaren eguneko dieta guztira (€/eguneko) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,52,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,52,0))","v":84.2}]
[]
[null,null,"Urteko dieta egun-kopurua ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,53,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,53,0))","v":250}]
[]
[null,null,"Urteko dieta guztiak (€)",null,null,null,null,{"$f":"H15*H13","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,54,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,54,0))","v":21050}]
[]
[null,null,"Gidariaren urteko jarduera-plusa (€/km) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,55,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,55,0))","v":6.4000000000000001E-2}]
[]
[null,null,"Gidariaren urteko jarduera-plusa (€)",null,null,null,null,{"$f":"H19*'Ibilgailuaren Ezaugarriak'!J25","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,56,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,56,0))","v":9600}]
[]
[null,null,"PERTSONAL KOSTUAK",null,null,null,null,{"$f":"H11+H17+H21","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,57,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,57,0))","v":68299.7}]

{"sheet":"Aseguruak eta zerga arloko kost","index":6,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"4. Aseguruak eta zerga arloko kostuak"]
[]
[]
[null,null,"Seguros",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Responsabilidad civil del vehículo de tracción (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,58,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,58,0))","v":1696.86}]
[]
[null,null,"Responsabilidad civil del remolque o semirremolque (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,59,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,59,0))","v":535.32000000000005}]
[]
[null,null,"Responsabilidad civil de la mercancía (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,60,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,60,0))","v":127.19}]
[]
[null,null,"Accidente del conductor (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,61,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,61,0))","v":59.04}]
[]
[null,null,"Retirada del carné de conducir (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,62,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,62,0))","v":146.94999999999999}]
[]
[null,null,"Seguro de la mercancía (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,63,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,63,0))","v":720}]
[]
[null,null,"Daños propios (seguro todo riesgo) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,64,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,64,0))","v":3171.47}]
[]
[null,null,"Otros seguros (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,65,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,65,0))","v":508.22}]
[]
[null,null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,null,null,{"$f":"H11+H13+H15+H17+H19+H21+H23+H25","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,66,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,66,0))","v":6965.05}]
[]
[null,null,"Costes fiscales",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Visados",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,67,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,67,0))","v":16.91}]
[]
[null,null,"Inspección técnica de vehículos (I.T.V.)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,68,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,68,0))","v":115.84}]
[]
[null,null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,69,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,69,0))","v":366.46}]
[]
[null,null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,70,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,70,0))","v":315.48}]
[]
[null,null,"Revisión tacógrafo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,71,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,71,0))","v":85.22}]
[]
[null,null,"Inspecciones A.T.P. (transporte mercancías perecederas)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,72,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,72,0))","v":""}]
[]
[null,null,"Inspecciones A.D.R. (transporte mercancías peligrosas)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,73,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,73,0))","v":""}]
[]
[null,null,"Otros costes fiscales",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,74,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,74,0))","v":29.76}]
[]
[null,null,"COSTE FISCAL TOTAL ANUAL",null,null,null,null,{"$f":"H31+H33+H35+H37+H39+H41+H43+H45","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,75,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,75,0))","v":929.67000000000007}]
[]
[null,null,"SEGUROS Y COSTES FISCALES ",null,null,null,null,{"$f":"H27+H47","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,76,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,76,0))","v":7894.72}]

{"sheet":"Kostu aldakorrak","index":7,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"5. Kostu aldakorrak"]
[]
[]
[null,null,"Ibilgailuaren erregaia ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Erregaiaren prezioa BEZ barne (€/litroko) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,77,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,77,0))","v":2.1230000000000002}]
[]
[null,null,"Deskontua (€/litroko)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,78,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,78,0))","v":0.1159}]
[]
[null,null,"Erregaiari aplikatutako BEZa (€/litroKO) ",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H15/100)*(J11-J13)/(1+H15/100),4),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,79,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,79,0))","v":21},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,79,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,79,0))","v":0.3483}]
[]
[null,null,"Erregaiaren prezioa BEZ gabe (€/litroko) ",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J11-J13)/(1+H15/100),4),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,80,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,80,0))","v":1.6588000000000001}]
[]
[null,null,"IBILGAILUAREN ERREGAIAN URTEAN GUZTIRA GASTATUTAKOA (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(('Ibilgailuaren Ezaugarriak'!J25/100)*'Ibilgailuaren Ezaugarriak'!J31*J17,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,81,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,81,0))","v":87087}]
[]
[null,null,"Carburante de los equipos ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Precio de compra de carburante",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,82,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,82,0))","v":""}]
[null,null,null,null,null,null,null,null,null,35]
[null,null,"Deskontua (€)  ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,83,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,83,0))","v":""}]
[]
[null,null,"IVA aplicado al carburante (%) (€/litro)",null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,88,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,88,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,84,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,84,0))","v":""}]
[]
[null,null,"IVA aplicado al carburante (€/litro)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J27/100)*(J23-J25)/(1+J27/100),4),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,85,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,85,0))","v":""}]
[]
[null,null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,{"$f":"ROUND((J23-J25)/(1+J27/100),4)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,86,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,86,0))","v":""}]
[]
[null,null,"Consumo medio de los equipos (litros/hora)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,87,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,87,0))","v":""}]
[]
[null,null,"Horas anuales de utilización de los equipos",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,88,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,88,0))","v":""}]
[]
[null,null,"GASTO TOTAL ANUAL EN CARBURANTE EQUIPOS",null,null,null,null,null,null,{"$f":"J31*J33*J35","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,89,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,89,0))","v":""}]
[]
[null,null,"Urea disoluzioaren kontsumoagatiko urteko kostua",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"UREA DISOLUZIOARENU KONTSUMOAGATIKO URTEKO KOSTUA (€, BEZ gabe)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,114,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,114,0))","v":2500.16}]
[]
[null,null,"Urea disoluzioaren kontsumoagatiko urteko kostua (€/km, BEZ gabe)",null,null,null,null,null,null,{"$f":"IFERROR(J41/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,{"$f":"IFERROR(L41/'Ibilgailuaren Ezaugarriak'!L25,0)","v":1.6667733333333334E-2}]
[]
[null,null,"Urtean pneumatikoetan gastatutakoa ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Norabidezko pneumatiko-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,90,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,90,0))","v":2}]
[]
[null,null,"Pneumatiko eragile-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,91,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,91,0))","v":4}]
[]
[null,null,"Número de neumáticos arrastre",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,92,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,92,0))","v":""}]
[]
[null,null,"Erdi-atoi edo atoiko pneumatiko-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,93,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,93,0))","v":6}]
[]
[null,null,"Norabidezko pneumatiko baten prezioa BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,94,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,94,0))","v":713.16}]
[]
[null,null,"Pneumatiko eragile bat prezioa BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,95,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,95,0))","v":713.16}]
[]
[null,null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,96,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,96,0))","v":""}]
[]
[null,null,"Atoi edo erdi-atoiko pneumatiko baten prezioa BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,97,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,97,0))","v":713.16}]
[]
[null,null,"Norabidezko pneumatiko baten batez besteko iraunaldia (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,98,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,98,0))","v":150000}]
[]
[null,null,"Pneumatiko eragile baten batez besteko iraunaldia (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,99,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,99,0))","v":150000}]
[]
[null,null,"Duración media de un neumático arrastre (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,100,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,100,0))","v":""}]
[]
[null,null,"Atoi edo erdi-atoiko pneumatiko baten batez besteko iraunaldia (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,101,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,101,0))","v":150000}]
[]
[null,null,"URTEAN GUZTIRA PNEUMATIKOETAN GASTATUTAKOA (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR((J47*J55*'Ibilgailuaren Ezaugarriak'!J25/J63),0)+IFERROR((J49*J57*'Ibilgailuaren Ezaugarriak'!J25/J65),0)+IFERROR((J51*J59*'Ibilgailuaren Ezaugarriak'!J25/J67),0)+IFERROR((J53*J61*'Ibilgailuaren Ezaugarriak'!J25/J69),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,102,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,102,0))","v":8558}]
[]
[null,null,"Mantentze-gastuak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Mantentze-kostua kilometroko, BEZ gabe (€/km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,103,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,103,0))","v":1.8200000000000001E-2}]
[]
[null,null,"URTEAN MANTENTZEAN GASTATUTAKOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"'Ibilgailuaren Ezaugarriak'!J25*J75","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,104,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,104,0))","v":2730}]
[]
[null,null,"Konponketak",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"Konponketen kostua kilometroko, BEZ gabe (€/km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,105,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,105,0))","v":3.5799999999999998E-2}]
[]
[null,null,"URTEAN KONPONKETETAN GASTATUTAKOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"'Ibilgailuaren Ezaugarriak'!J25*J81","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,106,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,106,0))","v":5370}]
[]
[null,null,"Bidesariak",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"URTEAN BIDESARITAN GASTATUTAKOA, BEZ GABE (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,107,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,107,0))","v":18260.02}]
[]
[null,null,"KOSTU ALDAKORRAK",null,null,null,null,null,null,{"$f":"ROUND(J19+J37+J71+J77+J83+J87+J41,1)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,108,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,108,0))","v":124505}]

{"sheet":"Zeharkako kostuak ","index":8,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"6. Zeharkako kostuak "]
[]
[]
[null,null,"Zeharkako kostuak ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[]
[null,null,"% Urteko kudeaketa-, administrazio- eta merkaturatze-kostuak, ibilgailu honi dagozkionak",null,null,null,null,null,"%",{"$f":"ROUND(('Erosketa kostuak'!H105+'Pertsonal-kostuak'!H23+'Aseguruak eta zerga arloko kost'!H49+'Kostu aldakorrak'!J89)*('Zeharkako kostuak '!H11/100),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,109,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$D$1:$AI$281,109,0))","v":6.5},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,109,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,109,0))","v":14723}]
[]
[]
[]
[null,null,"ZEHARKAKO GASTUAK",null,null,null,null,{"$f":"J11","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,112,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AI$281,112,0))","v":14723}]

{"sheet":"Emaitzak","index":9,"n_rows":97,"n_cols":16,"rows_kept":97,"cut":false,"hidden":false,"merged":[[90,7,90,8],[90,4,90,5],[8,4,8,5],[40,7,40,8],[40,4,40,5],[67,7,67,8],[67,4,67,5]]}
[]
[]
[]
[]
[]
[null,null,"Emaitzak"]
[]
[]
[null,null,"URTEKO KOSTUEN EMAITZAK ",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"20/06/2025"}]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[null,null,"GUZTIZKO KOSTUAK ",null,{"$f":"ROUND(E12+E21,0)","v":0},100,null,{"$f":"ROUND(H12+H21,0)","v":226514},100]
[null,null,"KOSTUAK DENBORAREN ARABERA ",null,{"$f":"ROUND(IFERROR(SUM(E13:E20),0),0)","v":0},{"$f":"IFERROR(E12*F11/E11,0)","v":0},null,{"$f":"ROUND(IFERROR(SUM(H13:H20),0),0)","v":102009},{"$f":"IFERROR(H12*I11/H11,0)","v":45.034302515517801}]
[null,null,"Leasinga","A",{"$f":"ROUND(IFERROR('Erosketa kostuak'!H13+0,0)+IFERROR('Erosketa kostuak'!H37+0,0)+IFERROR('Erosketa kostuak'!H61+0,0)+IFERROR('Erosketa kostuak'!H85+0,0),0)","v":0},{"$f":"IFERROR(E13*F$11/E$11,0)","v":0},"A",{"$f":"ROUND(IFERROR('Erosketa kostuak'!J13+0,0)+IFERROR('Erosketa kostuak'!J37+0,0)+IFERROR('Erosketa kostuak'!J61+0,0)+IFERROR('Erosketa kostuak'!J85+0,0),0)","v":0},{"$f":"IFERROR(H13*I$11/H$11,0)","v":0},null,"A",{"$f":"E13","v":0},0,"A",{"$f":"H13","v":0},0]
[null,null,"Amortizazioa","B",{"$f":"ROUND(IFERROR(0+'Erosketa kostuak'!H29,0)+IFERROR(0+'Erosketa kostuak'!H53,0)+IFERROR(0+'Erosketa kostuak'!H77,0)+IFERROR(0+'Erosketa kostuak'!H101,0),0)","v":0},0,"B",{"$f":"ROUND(IFERROR(0+'Erosketa kostuak'!J29,0)+IFERROR(0+'Erosketa kostuak'!J53,0)+IFERROR(0+'Erosketa kostuak'!J77,0)+IFERROR(0+'Erosketa kostuak'!J101,0),0)","v":21756},9.6047043449852989,null,"B",0,0,"B",21756,9.6047043449852989]
[null,null,"Finantza-gastuak ","C",{"$f":"ROUND(IFERROR(0+'Erosketa kostuak'!H31,0)+IFERROR(0+'Erosketa kostuak'!H55,0)+IFERROR(0+'Erosketa kostuak'!H79,0)+IFERROR(0+'Erosketa kostuak'!H103,0),0)","v":0},0,"C",{"$f":"ROUND(IFERROR(0+'Erosketa kostuak'!J31,0)+IFERROR(0+'Erosketa kostuak'!J55,0)+IFERROR(0+'Erosketa kostuak'!J79,0)+IFERROR(0+'Erosketa kostuak'!J103,0),0)","v":4058},1.7915007460907493,null,"C",0,0,"C",4058,1.7915007460907493]
[null,null,"Gidariaren urteko kostua guztira ","D",{"$f":"ROUND('Pertsonal-kostuak'!H11,0)","v":0},0,"D",{"$f":"ROUND('Pertsonal-kostuak'!J11,0)","v":37650},16.621489179476765,null,"D",0,0,"D",37650,16.621489179476765]
[null,null,"Dietak guztira eta jarduera-plusa ","E",{"$f":"ROUND('Pertsonal-kostuak'!H17+'Pertsonal-kostuak'!H21,0)","v":0},0,"E",{"$f":"ROUND('Pertsonal-kostuak'!J17+'Pertsonal-kostuak'!J21,0)","v":30650},13.531172466161031,null,"E",0,0,"E",30650,13.531172466161031]
[null,null,"Seguruak","F",{"$f":"ROUND('Aseguruak eta zerga arloko kost'!H27,0)","v":0},0,"F",{"$f":"ROUND('Aseguruak eta zerga arloko kost'!J27,0)","v":6965},3.0748651297491545,null,"F",0,0,"F",6965,3.0748651297491545]
[null,null,"Zerga-arloko kostuak ","G",{"$f":"ROUND('Aseguruak eta zerga arloko kost'!H47,0)","v":0},0,"G",{"$f":"ROUND('Aseguruak eta zerga arloko kost'!J47,0)","v":930},0.41057064905480456,null,"G",0,0,"G",930,0.41057064905480456]
[null,null,"Kudeaketa eta merkaturatzea ","H",{"$f":"ROUND('Zeharkako kostuak '!H15,0)","v":0},0,"H",{"$f":"ROUND('Zeharkako kostuak '!J11,0)","v":0},0,null,"H",0,0,"H",0,0]
[null,null,"KOSTUAK IBILBIDEAREN ARABERA ",null,{"$f":"ROUND(IFERROR(SUM(E22:E25),0),0)","v":0},{"$f":"IFERROR(E21*F20/E20,0)","v":0},null,{"$f":"ROUND(IFERROR(SUM(H22:H25),0),0)","v":124505},{"$f":"IFERROR(H21*I20/H20,0)","v":0},null,"I",{"$f":"E22","v":0},0,"I",{"$f":"H22","v":89587},39.550314770830944]
[null,null,"Erregaia","I",{"$f":"ROUND('Kostu aldakorrak'!J19+'Kostu aldakorrak'!J41+'Kostu aldakorrak'!J37,0)","v":0},{"$f":"IFERROR(E22*F$11/E$11,0)","v":0},"I",{"$f":"ROUND('Kostu aldakorrak'!L19+'Kostu aldakorrak'!L41+IF('Kostu aldakorrak'!L37<>\"\",'Kostu aldakorrak'!L37,0),0)","v":89587},{"$f":"IFERROR(H22*I$11/H$11,0)","v":39.550314770830944},null,"J",0,0,"J",8558,3.7781329189365778]
[null,null,"Pneumatikoak","J",{"$f":"ROUND('Kostu aldakorrak'!J71,0)","v":0},{"$f":"IFERROR(E23*F$11/E$11,0)","v":0},"J",{"$f":"ROUND('Kostu aldakorrak'!L71,0)","v":8558},{"$f":"IFERROR(H23*I$11/H$11,0)","v":3.7781329189365778},null,"K",0,0,"K",8100,3.5759379111224914]
[null,null,"Mantentzea eta konponketak","K",{"$f":"ROUND('Kostu aldakorrak'!J77+'Kostu aldakorrak'!J83,0)","v":0},{"$f":"IFERROR(E24*F$11/E$11,0)","v":0},"K",{"$f":"ROUND('Kostu aldakorrak'!L77+'Kostu aldakorrak'!L83,0)","v":8100},{"$f":"IFERROR(H24*I$11/H$11,0)","v":3.5759379111224914},null,"L",0,0,"L",18260,8.0613118835921842]
[null,null,"Bidesariak","L",{"$f":"ROUND('Kostu aldakorrak'!J87,0)","v":0},{"$f":"IFERROR(E25*F$11/E$11,0)","v":0},"L",{"$f":"ROUND('Kostu aldakorrak'!L87,0)","v":18260},{"$f":"IFERROR(H25*I$11/H$11,0)","v":8.0613118835921842}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"URTEKO KOSTUEN EGITURA ",null,"Erabiltzailea",null,null,"Datu estadistikoak (2023/01)"]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[null,null,"Amortizazioa eta finantza-gastuak eta leasinga ","A",{"$f":"ROUND(E13+E14+E15,0)","v":0},{"$f":"IFERROR(E43*$F$48/$E$48,0)","v":0},"A",{"$f":"ROUND(H13+H14+H15,0)","v":25814},{"$f":"IFERROR(H43*$I$48/$H$48,0)","v":11.396205091076048}]
[null,null,"Langileak","B",{"$f":"ROUND(E16+E17,0)","v":0},{"$f":"IFERROR(E44*$F$48/$E$48,0)","v":0},"B",{"$f":"ROUND(H16+H17,0)","v":68300},{"$f":"IFERROR(H44*$I$48/$H$48,0)","v":30.152661645637796}]
[null,null,"Aseguruak, zerga-arloko kostuak, kudeaketa eta merkaturatzea ","C",{"$f":"ROUND(E18+E19+E20,0)","v":0},{"$f":"IFERROR(E45*$F$48/$E$48,0)","v":0},"C",{"$f":"ROUND(H18+H19+H20,0)","v":7895},{"$f":"IFERROR(H45*$I$48/$H$48,0)","v":3.4854357788039589}]
[null,null,"Erregaia, pneumatikoak, konponketak, mantentzea eta bidesariak ","D",{"$f":"ROUND(E22+E23+E24+E25,0)","v":0},{"$f":"IFERROR(E46*$F$48/$E$48,0)","v":0},"D",{"$f":"ROUND(H22+H23+H24+H25,0)","v":124505},{"$f":"IFERROR(H46*$I$48/$H$48,0)","v":54.965697484482199}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"ROUND(SUM(E43:E46),0)","v":0},100,null,{"$f":"ROUND(SUM(H43:H46),0)","v":226514},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"KOSTUAK DENBORAREN ARABERA- KOSTUAK IBILBIDEAREN ARABERA ",null,"Erabiltzailea",null,null,"Datu estadistikoak (2023/01)"]
[]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[]
[null,null,"Kostuak denboraren arabera ","A",{"$f":"ROUND(E12,0)","v":0},{"$f":"IFERROR(E72*$F$48/$E$48,0)","v":0},"A",{"$f":"ROUND(H12,0)","v":102009},{"$f":"IFERROR(H72*$I$48/$H$48,0)","v":45.034302515517801}]
[null,null,"Kostuak ibilbidearen arabera ","B",{"$f":"ROUND(E21,0)","v":0},{"$f":"IFERROR(E73*$F$48/$E$48,0)","v":0},"B",{"$f":"ROUND(H21,0)","v":124505},{"$f":"IFERROR(H73*$I$48/$H$48,0)","v":54.965697484482199}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"ROUND(SUM(E72:E73),0)","v":0},100,null,{"$f":"ROUND(SUM(H72:H73),0)","v":226514},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BATEZ BESTEKO KOSTUAK",null,"Erabiltzailea",null,null,"Datu estadistikoak (2023/01)"]
[]
[null,null,"Batez besteko kostua guztira (km-ko) ",null,{"$f":"IFERROR(E75/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,null,{"$f":"IFERROR(H75/'Ibilgailuaren Ezaugarriak'!L25,0)","v":1.5100933333333333}]
[null,null,"Batez besteko kostua guztira (orduko)",null,{"$f":"IFERROR(E75/'Ibilgailuaren Ezaugarriak'!J33,0)","v":0},null,null,{"$f":"IFERROR(H75/'Ibilgailuaren Ezaugarriak'!L33,0)","v":113.25700000000001}]
[null,null,"Batez besteko kostua ibilbidearen arabera (km-ko) ",null,{"$f":"IFERROR(E73/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,null,{"$f":"IFERROR(H73/'Ibilgailuaren Ezaugarriak'!L25,0)","v":0.83003333333333329}]
[null,null,"Batez besteko kostua denboraren arabera (orduko) ",null,{"$f":"IFERROR(E72/'Ibilgailuaren Ezaugarriak'!J33,0)","v":0},null,null,{"$f":"IFERROR(H72/'Ibilgailuaren Ezaugarriak'!L33,0)","v":51.0045}]
[null,null,"Pneumatiko, mantentze eta konponketen batez besteko kostua (km-ko)",null,{"$f":"IFERROR((E23+E24)/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,null,{"$f":"IFERROR((H23+H24)/'Ibilgailuaren Ezaugarriak'!L25,0)","v":0.11105333333333334}]

{"sheet":"Zerbitzuaren kostua","index":10,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[10,7,10,10]]}
[]
[]
[]
[]
[]
[null,null,"Zerbitzuaren kostua"]
[]
[]
[null,null,"Zerbitzuaren kostua "]
[]
[null,null,"Zerbitzuaren izena "]
[]
[null,null,"Zerbitzu honetan egindako kilometroak (zamarekin hutsik)  (km)",null,null,null,null,{"$f":"H15+H17","v":0}]
[]
[null,null,"Kilometroak zamarekin (km) "]
[]
[null,null,"Kilometroak hutsik (km) "]
[]
[null,null,"Zerbitzu honetako batez besteko kontsumoa kilometroko (litro / 100 km) "]
[]
[null,null,"Zerbitzu honetan emandako orduak ",null,null,null,null,{"$f":"H23+H25+H27","v":0}]
[]
[null,null,"Orduak zamarekin "]
[]
[null,null,"Orduak hutsik "]
[null,null,null,null,null,null,null,6]
[null,null,"Zamaketa-lanetan eta geldirik emandako orduak "]
[]
[null,null,"Bidesariak "]
[]
[null,null,"Zerbitzu honen kostua ibilbidearen arabera  (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H13*(H19/100)*'Kostu aldakorrak'!J17+H13*(('Kostu aldakorrak'!J71+'Kostu aldakorrak'!J77+'Kostu aldakorrak'!J83)/'Ibilgailuaren Ezaugarriak'!J25)+H29,2),0)","v":0}]
[]
[null,null,"Zerbitzu honen kostua denboraren arabera  (€)",null,null,null,null,{"$f":"IFERROR(H21*(('Erosketa kostuak'!H105+'Pertsonal-kostuak'!H23+'Aseguruak eta zerga arloko kost'!H49+'Zeharkako kostuak '!H15)/'Ibilgailuaren Ezaugarriak'!J33),0)","v":0}]
[]
[null,null,"Zerbitzu honi atxikitako kostu gehigarriak  (€)"]
[]
[null,null,"Zerbitzu honen guztizko kostua (€)",null,null,null,null,{"$f":"IFERROR(H31+H33+H35,0)","v":0}]