{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["T","DE","Ibilgailu-mota","Ibilgailuaren Ezaugarriak","Erosketa kostuak","Ibilgailuan doazen langileen ko","Aseguruak esta zerga arloko kos","Kostu aldakorrak","Zeharkako kostuak","Emaitzak","Zerbitzuaren kostua"],"not_rendered":{"charts":6,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"T","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Tipo de vehículo",null,"Pregunta",null,null,"Adquisicion",null,"Editar"]
["15 metroko autobusa","T17","Bai","S",null," EROSKETA"]
["12 metroko autobusa","T18","Ez","N",null,"ALOKAIRUA, LEASING..."]
["9 metroko autobusa","T19"]
["Mikrobusa","T20"]
["Autobus arrunta (aurreko kategorietan sartzen ez diren gainerako ibilgailu guztiak)","T21"]

{"sheet":"DE","index":1,"n_rows":90,"n_cols":36,"rows_kept":90,"cut":false,"hidden":true,"merged":[[36,13,36,14]]}
[null,null,"T17A","T17","T18A","T18","T19A","T19","T20A","T20","T21A","T21"]
[null,"Descripción:"," ","Autocar de 15 metros"," ","Autocar de 12 metros"," ","Autocar de 9 metros"," ","Microbús"," ","Autocar genérico (autocares no englobados en las categorías anteriores)",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,"03/07/2025"]
[null,"Tipo interes",null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453]
[null,"Número de plazas incluido el conductor",null,65.0,null,55.0,null,35.0,null,25.0,null,55.0]
[null,"Potencia (CV)",null,420.0,null,380.0,null,280.0,null,160.0,null,380.0]
[null,"Masa Máxima Autorizada (kg)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Número de ejes",null,3.0,null,2.0,null,2.0,null,2.0,null,2.0]
[null,"Kilómetros recorridos anualmente",null,75000.0,null,65000.0,null,50000.0,null,40000.0,null,65000.0]
[null,"Kilómetros facturados de los recorridos al año (km)",95.0,{"$f":"ROUND(D8*C9/100,2)","v":71250.0},95.0,{"$f":"F8*E9/100","v":61750.0},95.0,{"$f":"H8*G9/100","v":47500.0},95.0,{"$f":"J8*I9/100","v":38000.0},95.0,{"$f":"L8*K9/100","v":61750.0}]
[null,"Consumo medio (litros/100km)",null,30.0,null,26.0,null,21.0,null,15.5,null,26.0]
[null,"Horas trabajadas al año",null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0]
[null,"Horas facturadas de las trabajadas al año (h,%)",91.0,{"$f":"ROUND(D11*C12/100,0)","v":1638.0},91.0,{"$f":"F11*E12/100","v":1638.0},91.0,{"$f":"H11*G12/100","v":1638.0},91.0,{"$f":"J11*I12/100","v":1638.0},91.0,{"$f":"L11*K12/100","v":1638.0}]
[null,"Kilómetros con viajeros de los recorridos al año (km,%)",90.0,{"$f":"ROUND(D8*C13/100,2)","v":67500.0},90.0,{"$f":"F8*E13/100","v":58500.0},90.0,{"$f":"H8*G13/100","v":45000.0},90.0,{"$f":"J8*I13/100","v":36000.0},90.0,{"$f":"L8*K13/100","v":58500.0}]
[null,"Ocupación media de las plazas en los kilómetros recorridos con viajeros (viajeros/autocar,%)",80.0,{"$f":"ROUND((D4-1)*C14/100,0)","v":51.0},80.0,{"$f":"ROUND((F4-1)*E14/100,0)","v":43.0},80.0,{"$f":"ROUND((H4-1)*G14/100,0)","v":27.0},80.0,{"$f":"ROUND((J4-1)*I14/100,0)","v":19.0},80.0,{"$f":"ROUND((L4-1)*K14/100,0)","v":43.0}]
[null,"Producción anual: Viajeros x Kilómetros",null,{"$f":"D13*D14","v":3442500.0},null,{"$f":"F13*F14","v":2515500.0},null,{"$f":"H13*H14","v":1215000.0},null,{"$f":"J13*J14","v":684000.0},null,{"$f":"L13*L14","v":2515500.0}]
[null,"Pago de alquiler o leasing anual (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,"CHASIS"]
[null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,131408.55,null,116029.69,null,78861.75,null,40274.0,null,116029.69]
[null,"Vida útil (años)",null,12.0,null,12.0,null,12.0,null,12.0,null,12.0]
[null,"Valor residual sin IVA (€)",20.0,{"$f":"ROUND(D17*C19/100,0)","v":26282.0},20.0,{"$f":"ROUND(F17*E19/100,0)","v":23206.0},20.0,{"$f":"ROUND(H17*G19/100,0)","v":15772.0},20.0,{"$f":"ROUND(J17*I19/100,0)","v":8055.0},20.0,{"$f":"ROUND(L17*K19/100,0)","v":23206.0}]
[null,"AMORTIZACION DEL CHASIS",null,{"$f":"IFERROR(ROUND((D17-D19-D80)/D18,0),0)","v":8246.0},null,{"$f":"IFERROR(ROUND((F17-F19-F80)/F18,0),0)","v":7451.0},null,{"$f":"IFERROR(ROUND((H17-H19-H80)/H18,0),0)","v":5069.0},null,{"$f":"IFERROR(ROUND((J17-J19-J80)/J18,0),0)","v":2562.0},null,{"$f":"IFERROR(ROUND((L17-L19-L80)/L18,0),0)","v":7451.0}]
[null,"GASTOS FINANCIEROS DEL CHASIS",null,{"$f":"IFERROR(ROUND(IF(D17=0,0,(D17-D19-D80)*(D$3/(1-POWER(1+D$3,-D18))-1/D18)),0),0)","v":2624.28},null,{"$f":"IFERROR(ROUND(IF(F17=0,0,(F17-F19-F80)*(F$3/(1-POWER(1+F$3,-F18))-1/F18)),0),0)","v":2371.33},null,{"$f":"IFERROR(ROUND(IF(H17=0,0,(H17-H19-H80)*(H$3/(1-POWER(1+H$3,-H18))-1/H18)),0),0)","v":1613.19},null,{"$f":"IFERROR(ROUND(IF(J17=0,0,(J17-J19-J80)*(J$3/(1-POWER(1+J$3,-J18))-1/J18)),0),0)","v":815.24},null,{"$f":"IFERROR(ROUND(IF(L17=0,0,(L17-L19-L80)*(L$3/(1-POWER(1+L$3,-L18))-1/L18)),0),0)","v":2371.33}]
[null,"Pago de alquiler o leasing anual (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,"CARROZADO"]
[null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,131408.55,null,116029.69,null,78861.75,null,40274.0,null,116029.69]
[null,"Vida útil (años)",null,12.0,null,12.0,null,12.0,null,12.0,null,12.0]
[null,"Valor residual sin IVA (€)",20.0,{"$f":"ROUND(D23*C25/100,0)","v":26282.0},20.0,{"$f":"ROUND(F23*E25/100,0)","v":23206.0},20.0,{"$f":"ROUND(H23*G25/100,0)","v":15772.0},20.0,{"$f":"ROUND(J23*I25/100,0)","v":8055.0},20.0,{"$f":"ROUND(L23*K25/100,0)","v":23206.0}]
[null,"AMORTIZACION CARROZADO",null,{"$f":"IFERROR(ROUND((D23-D25)/D24,0),0)","v":8761.0},null,{"$f":"IFERROR(ROUND((F23-F25)/F24,0),0)","v":7735.0},null,{"$f":"IFERROR(ROUND((H23-H25)/H24,0),0)","v":5257.0},null,{"$f":"IFERROR(ROUND((J23-J25)/J24,0),0)","v":2685.0},null,{"$f":"IFERROR(ROUND((L23-L25)/L24,0),0)","v":7735.0}]
[null,"GASTOS FINANCIEROS CARROZADO",null,{"$f":"IFERROR(ROUND(IF(D17=0,0,(D23-D25)*(D$3/(1-POWER(1+D$3,-D24))-1/D24)),0),0)","v":2788.08},null,{"$f":"IFERROR(ROUND(IF(F17=0,0,(F23-F25)*(F$3/(1-POWER(1+F$3,-F24))-1/F24)),0),0)","v":2461.79},null,{"$f":"IFERROR(ROUND(IF(H17=0,0,(H23-H25)*(H$3/(1-POWER(1+H$3,-H24))-1/H24)),0),0)","v":1673.21},null,{"$f":"IFERROR(ROUND(IF(J17=0,0,(J23-J25)*(J$3/(1-POWER(1+J$3,-J24))-1/J24)),0),0)","v":854.48},null,{"$f":"IFERROR(ROUND(IF(L17=0,0,(L23-L25)*(L$3/(1-POWER(1+L$3,-L24))-1/L24)),0),0)","v":2461.79}]
[null,"Pago de alquiler o leasing anual (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,"EQUIPOS"]
[null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Vida útil (años)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Valor residual sin IVA (€)",0.0,{"$f":"ROUND(D29*C31/100,0)","v":0.0},0.0,{"$f":"ROUND(F29*E31/100,0)","v":0.0},0.0,{"$f":"ROUND(H29*G31/100,0)","v":0.0},0.0,{"$f":"ROUND(J29*I31/100,0)","v":0.0},0.0,{"$f":"ROUND(L29*K31/100,0)","v":0.0}]
[null,"AMORTIZACION EQUIPOS",null,{"$f":"IFERROR(ROUND((D29-D31)/D30,0),0)","v":0.0},null,{"$f":"IFERROR(ROUND((F29-F31)/F30,0),0)","v":0.0},null,{"$f":"IFERROR(ROUND((H29-H31)/H30,0),0)","v":0.0},null,{"$f":"IFERROR(ROUND((J29-J31)/J30,0),0)","v":0.0},null,{"$f":"IFERROR(ROUND((L29-L31)/L30,0),0)","v":0.0}]
[null,"GASTOS FINANCIEROS EQUIPOS",null,{"$f":"IFERROR(ROUND(IF(D17=0,0,(D29-D31)*(D$3/(1-POWER(1+D$3,-D30))-1/D30)),0),0)","v":0.0},null,{"$f":"IFERROR(ROUND(IF(F17=0,0,(F29-F31)*(F$3/(1-POWER(1+F$3,-F30))-1/F30)),0),0)","v":0.0},null,{"$f":"IFERROR(ROUND(IF(H17=0,0,(H29-H31)*(H$3/(1-POWER(1+H$3,-H30))-1/H30)),0),0)","v":0.0},null,{"$f":"IFERROR(ROUND(IF(J17=0,0,(J29-J31)*(J$3/(1-POWER(1+J$3,-J30))-1/J30)),0),0)","v":0.0},null,{"$f":"IFERROR(ROUND(IF(L17=0,0,(L29-L31)*(L$3/(1-POWER(1+L$3,-L30))-1/L30)),0),0)","v":0.0}]
[null,"COSTES DE ADQUISICION",null,{"$f":"D16+D20+D21+D22+D26+D27+D28+D32+D33","v":22419.36},null,{"$f":"F16+F20+F21+F22+F26+F27+F28+F32+F33","v":20019.12},null,{"$f":"H16+H20+H21+H22+H26+H27+H28+H32+H33","v":13612.4},null,{"$f":"J16+J20+J21+J22+J26+J27+J28+J32+J33","v":6916.72},null,{"$f":"L16+L20+L21+L22+L26+L27+L28+L32+L33","v":20019.12}]
[null,"Coste total anual del personal de a bordo, incluidos costes de empresa (Seguridad Social y otros) (€)",null,36783.34,null,36783.34,null,36783.34,null,36783.34,null,36783.34]
[null,"Otros complementos retributivos del personal de a bordo (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Dieta total diaria del personal de a bordo de transporte regular (€/día)",null,33.51,null,33.51,null,26.81,null,26.81,null,33.51]
[null,"Número de días de transporte regular con dieta al año",null,100.0,null,100.0,null,50.0,null,25.0,null,100.0]
[null,"Dieta total diaria internacional del personal de a bordo de transporte regular (€/día)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Número de días de transporte regular con dieta internacional al año",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Dietas totales anuales por transporte regular (€)",null,{"$f":"D37*D38+D39*D40","v":3351.0},null,{"$f":"F37*F38+F39*F40","v":3351.0},null,{"$f":"H37*H38+H39*H40","v":1340.5},null,{"$f":"J37*J38+J39*J40","v":670.25},null,{"$f":"L37*L38+L39*L40","v":3351.0}]
[null,"Dieta total diaria del personal de a bordo de transporte discrecional (€/día)",null,33.51,null,33.51,null,26.81,null,26.81,null,33.51]
[null,"Número de días de transporte discrecional con dieta al año",null,100.0,null,100.0,null,50.0,null,25.0,null,100.0]
[null,"Dieta total diaria internacional del personal de a bordo de transporte discrecional (€/día)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Número de días de transporte discrecional con dieta internacional al año",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Dietas totales anuales por transporte discrecional (€)",null,{"$f":"D42*D43+D44*D45","v":3351.0},null,{"$f":"F42*F43+F44*F45","v":3351.0},null,{"$f":"H42*H43+H44*H45","v":1340.5},null,{"$f":"J42*J43+J44*J45","v":670.25},null,{"$f":"L42*L43+L44*L45","v":3351.0}]
[null,"COSTES DE PERSONAL",null,{"$f":"D35+D41+D46","v":43485.34},null,{"$f":"F35+F41+F46","v":43485.34},null,{"$f":"H35+H41+H46","v":39464.34},null,{"$f":"J35+J41+J46","v":38123.84},null,{"$f":"L35+L41+L46","v":43485.34}]
[null,"Seguro obligatorio del autocar (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Responsabilidad civil (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Seguro obligatorio de viajeros (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Seguro de accidentes del conductor (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Defensa y reclamación de daños (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Seguro de incendios (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Otros seguros (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"TOTAL SEGUROS (€)",null,3365.4,null,2862.53,null,2359.54,null,2021.81,null,2862.53]
[null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,{"$f":"D55","v":3365.4},null,{"$f":"F55","v":2862.53},null,{"$f":"H55","v":2359.54},null,{"$f":"J55","v":2021.81},null,{"$f":"L55","v":2862.53}]
[null,"Visados",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Inspección técnica de vehículos (I.T.V.) (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.) (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Revisión tacógrafo (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Otros costes fiscales (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"TOTAL COSTES FISCALES (€)",null,1227.74,null,1164.32,null,980.04,null,744.3,null,1164.32]
[null,"COSTE FISCAL TOTAL ANUAL",null,{"$f":"D63","v":1227.74},null,{"$f":"F63","v":1164.32},null,{"$f":"H63","v":980.04},null,{"$f":"J63","v":744.3},null,{"$f":"L63","v":1164.32}]
[null,"SEGUROS Y COSTES FISCALES",null,{"$f":"D56+D64","v":4593.14},null,{"$f":"F56+F64","v":4026.85},null,{"$f":"H56+H64","v":3339.58},null,{"$f":"J56+J64","v":2766.11},null,{"$f":"L56+L64","v":4026.85}]
[null,"Precio del carburante, con IVA (€/litro)",null,1.4363,null,1.4363,null,1.4363,null,1.4363,null,1.4363]
[null,"Descuento (€/litro)",null,0.1179,null,0.1179,null,0.1179,null,0.1179,null,0.1179]
[null,"IVA aplicado al carburante (€/litro)",21.0,{"$f":"ROUND((C68/100)*(D66-D67)/(1+C68/100),4)","v":0.2288},21.0,{"$f":"ROUND((E68/100)*(F66-F67)/(1+E68/100),4)","v":0.2288},21.0,{"$f":"ROUND((G68/100)*(H66-H67)/(1+G68/100),4)","v":0.2288},21.0,{"$f":"ROUND((I68/100)*(J66-J67)/(1+I68/100),4)","v":0.2288},21.0,{"$f":"ROUND((K68/100)*(L66-L67)/(1+K68/100),4)","v":0.2288}]
[null,"Precio carburante sin IVA (€/litro)",null,{"$f":"ROUND((D66-D67)/(1+C68/100),4)","v":1.0896},null,{"$f":"ROUND((F66-F67)/(1+E68/100),4)","v":1.0896},null,{"$f":"ROUND((H66-H67)/(1+G68/100),4)","v":1.0896},null,{"$f":"ROUND((J66-J67)/(1+I68/100),4)","v":1.0896},null,{"$f":"ROUND((L66-L67)/(1+K68/100),4)","v":1.0896}]
[null,"GASTO TOTAL ANUAL EN CARBURANTE, SIN IVA (€)",null,{"$f":"ROUND(D8/100*D10*D69,0)","v":24516.0},null,{"$f":"ROUND(F8/100*F10*F69,0)","v":18414.0},null,{"$f":"ROUND(H8/100*H10*H69,0)","v":11441.0},null,{"$f":"ROUND(J8/100*J10*J69,0)","v":6756.0},null,{"$f":"ROUND(L8/100*L10*L69,0)","v":18414.0}]
[null,"Número de neumáticos direccionables",null,4.0,null,2.0,null,2.0,null,2.0,null,2.0]
[null,"Número de neumáticos motrices",null,4.0,null,4.0,null,4.0,null,4.0,null,4.0]
[null,"Número de neumáticos arrastre",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Precio sin IVA de un neumático direccionable (€)",null,720.56,null,612.24,null,528.06,null,431.54,null,612.24]
[null,"Precio sin IVA de un neumático motriz (€)",null,720.56,null,612.24,null,528.06,null,431.54,null,612.24]
[null,"Precio sin IVA de un neumático arrastre (€)",null,726.56,null,612.24,null,528.06,null,431.54,null,612.24]
[null,"Duración media de un neumático direccionable (km)",null,70000.0,null,70000.0,null,70000.0,null,70000.0,null,70000.0]
[null,"Duración media de un neumático motriz (km)",null,70000.0,null,70000.0,null,70000.0,null,70000.0,null,70000.0]
[null,"Duración media de un neumático arrastre (km)",null,70000.0,null,70000.0,null,70000.0,null,70000.0,null,70000.0]
[null,"GASTO TOTAL ANUAL EN NEUMATICOS, SIN IVA (€)",null,{"$f":"ROUND(IFERROR(D71*D74*D$8/D77,0)+IFERROR(D72*D75*D$8/D78,0)+IFERROR(D73*D76*D$8/D79,0),0)","v":6176.23},null,{"$f":"ROUND(IFERROR(F71*F74*F$8/F77,0)+IFERROR(F72*F75*F$8/F78,0)+IFERROR(F73*F76*F$8/F79,0),0)","v":3411.05},null,{"$f":"ROUND(IFERROR(H71*H74*H$8/H77,0)+IFERROR(H72*H75*H$8/H78,0)+IFERROR(H73*H76*H$8/H79,0),0)","v":2263.11},null,{"$f":"ROUND(IFERROR(J71*J74*J$8/J77,0)+IFERROR(J72*J75*J$8/J78,0)+IFERROR(J73*J76*J$8/J79,0),0)","v":1479.57},null,{"$f":"ROUND(IFERROR(L71*L74*L$8/L77,0)+IFERROR(L72*L75*L$8/L78,0)+IFERROR(L73*L76*L$8/L79,0),0)","v":3411.05}]
[null,"Coste de mantenimento y reparaciones por km, sin IVA (€/km)",null,0.1717,null,0.1632,null,0.1192,null,0.0731,null,0.1632]
[null,"GASTO ANUAL EN MANTENIMIENTO Y REPARACIONES, SIN IVA (€)",null,{"$f":"ROUND(D81*D8,2)","v":12877.5},null,{"$f":"ROUND(F81*F8,2)","v":10608.0},null,{"$f":"ROUND(H81*H8,2)","v":5960.0},null,{"$f":"ROUND(J81*J8,2)","v":2924.0},null,{"$f":"ROUND(L81*L8,2)","v":10608.0}]
[null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"COSTES VARIABLES",null,{"$f":"ROUND(D70+D80+D82+D83+D89,2)","v":44384.85},null,{"$f":"ROUND(F70+F80+F82+F83+F89,2)","v":33045.29},null,{"$f":"ROUND(H70+H80+H82+H83+H89,2)","v":20044.5},null,{"$f":"ROUND(J70+J80+J82+J83+J89,2)","v":11384.18},null,{"$f":"ROUND(L70+L80+L82+L83+L89,2)","v":33045.29}]
[null,"COSTES DIRECTOS",null,{"$f":"ROUND(D34+D47+D65+D84,2)","v":114882.69},null,{"$f":"ROUND(F34+F47+F65+F84,2)","v":100576.6},null,{"$f":"ROUND(H34+H47+H65+H84,2)","v":76460.82},null,{"$f":"ROUND(J34+J47+J65+J84,2)","v":59190.85},null,{"$f":"ROUND(L34+L47+L65+L84,2)","v":100576.6}]
[null,"% Costes variables de gestión, administración y comercialización",12.5,{"$f":"ROUND((D34+D47+D65+D84)*(C86/100),0)","v":14360.34},12.5,{"$f":"ROUND((F34+F47+F65+F84)*(E86/100),0)","v":12572.08},12.5,{"$f":"ROUND((H34+H47+H65+H84)*(G86/100),0)","v":9557.6},12.5,{"$f":"ROUND((J34+J47+J65+J84)*(I86/100),0)","v":7398.86},12.5,{"$f":"ROUND((L34+L47+L65+L84)*(K86/100),0)","v":12572.08}]
[null,"COSTES INDIRECTOS",null,{"$f":"ROUND((D34+D47+D65+D84)*(C86/100),0)","v":14360.34},null,{"$f":"ROUND((F34+F47+F65+F84)*(E86/100),0)","v":12572.08},null,{"$f":"ROUND((H34+H47+H65+H84)*(G86/100),0)","v":9557.6},null,{"$f":"ROUND((J34+J47+J65+J84)*(I86/100),0)","v":7398.86},null,{"$f":"ROUND((L34+L47+L65+L84)*(K86/100),0)","v":12572.08}]
[null,"COSTES TOTALES",null,{"$f":"ROUND(D85+D87,0)","v":129243.03},null,{"$f":"ROUND(F85+F87,0)","v":113148.68},null,{"$f":"ROUND(H85+H87,0)","v":86018.42},null,{"$f":"ROUND(J85+J87,0)","v":66589.71},null,{"$f":"ROUND(L85+L87,0)","v":113148.68}]
[null,"GASTO ANUAL POR CONSUMO DE DISOLUCION DE UREA (€, sin IVA)",null,815.12,null,612.24,null,380.39,null,224.61,null,612.24]
[null,"Coste anual por disolucion de urea por kilometro(€/km, sin IVA)",null,0.0109,null,0.0094,null,0.0076,null,0.0056,null,0.0094]

{"sheet":"Ibilgailu-mota","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"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":"T17"},"15 metroko autobusa"]
[]
[]
[null,null,"¿Desea cargar los datos estadísticos en los campos a rellenar?",null,null,null,"No"]
[]
[]
[null,null,"Kalkulu-formularioetara gehitutako datu estatistikoekin simulazioa hasi nahi duzu?"]

{"sheet":"Ibilgailuaren Ezaugarriak","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,9,10,13]]}
[]
[]
[]
[]
[]
[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":"19/06/2025"}]
[]
[null,null,"Deskripzioa:",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$15,2,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$15,2,0))","v":"Autocar de 15 metros"}]
[]
[null,null,"Plaza kopurua, gidaria barne ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,4,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,4,0))","v":15}]
[]
[null,null,"Potentzia (CV) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,5,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,5,0))","v":15}]
[]
[null,null,"MMA ( Tm)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,6,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,6,0))","v":0}]
[]
[null,null,"Ardatz-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,7,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,7,0))","v":4}]
[]
[null,null,"Ibilgailuaren ustiapen-ezaugarriak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Urtero egindako kilometroak  (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,8,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,8,0))","v":75000}]
[]
[null,null,"Urtean egindako kilometroetatik fakturatutakoak (km)",null,null,null,null,null,"%",{"$f":"ROUND(J23*H25/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,9,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,9,0))","v":95},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,9,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,9,0))","v":71250}]
[]
[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:$AK$15,10,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,10,0))","v":30}]
[]
[null,null,"Urtean lanean emandako orduak ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,11,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,11,0))","v":1800}]
[]
[null,null,"Urtean egindakoetatik orduetatik fakturatutakoak (h,%)",null,null,null,null,null,"%",{"$f":"ROUND(J29*H31/100,0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,12,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,12,0))","v":91},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,12,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,12,0))","v":1638}]
[]
[null,null,"Garraiatutako bidaiariak"]
[]
[null,null,"Egindako kilometroetatik bidaiariekin egindako kilometroak (km,%)",null,null,null,null,null,"%",{"$f":"ROUND(J23*H35/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,13,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,13,0))","v":90},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,13,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,13,0))","v":67500}]
[]
[null,null,"Bidaiariekin egindako kilometroetan batez beste okupatutako plazak (% bidaiari/autobus)",null,null,null,null,null,"%",{"$f":"ROUND((J13-1)*H37/100,0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,14,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$15,14,0))","v":80},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,14,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,14,0))","v":11}]
[]
[null,null,"Urteko ekoizpena: bidaiariak x kilometroak ",null,null,null,null,null,null,{"$f":"J35*J37","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,15,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$15,15,0))","v":742500}]

{"sheet":"Erosketa kostuak","index":4,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[10,9,10,10],[28,9,28,10],[46,9,46,10]]}
[]
[]
[]
[]
[]
[null,null,"2. Erosketa kostuak"]
[]
[]
[null,null,"Autobusaren bastidorea ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,3,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,3,0))","v":5.6099999999999997E-2}]
[null,null,"Autobusaren bastidorea: ",null,null,null,null,null,null," EROSKETA"]
[]
[null,null,"Urteko alokairu edo leasing-aren ordainketa (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,16,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,16,0))","v":0}]
[]
[null,null,"Bastidorearen erosketa (€)"]
[]
[null,null,"Erosketa-prezioa (tarifa prezioa-deskontua), BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,17,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,17,0))","v":129466.55}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,18,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,18,0))","v":12}]
[]
[null,null,"Hondar-balioa BEZ gabe (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J$17*H21/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,19,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,19,0))","v":20},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,19,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,19,0))","v":25893}]
[]
[null,null,"BASTIDOREAREN AMORTIZAZIOA  (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(IF(J11=T!F2,ROUND((J17-J21-('Kostu aldakorrak'!J$47))*(1/J19),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,20,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,20,0))","v":8123}]
[]
[null,null,"TRAKZIOZKO IBILGAILUAREN FINANTZA GASTUAK  (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(IF(J11=T!F2,ROUND((J17-J21-('Kostu aldakorrak'!J$47))*(-(1/J19)+L$10/(1-POWER(1+L$10,-J19))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,21,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,21,0))","v":3256}]
[]
[null,null,"Karrozeria jartzea ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Erosteko modua:",null,null,null,null,null,null," EROSKETA"]
[]
[null,null,"Urteko alokairu edo leasing-aren ordainketa (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,22,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,22,0))","v":0}]
[]
[null,null,"Karrozeriaren erosketa  (€)"]
[]
[null,null,"Erosketa-prezioa (tarifa prezioa-deskontua), BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,23,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,23,0))","v":129466.55}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,24,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,24,0))","v":12}]
[]
[null,null,"Hondar-balioa BEZ gabe (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J35*H39/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,25,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,25,0))","v":20},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,25,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,25,0))","v":25893}]
[]
[null,null,"KARROZERIAREN AMORTIZAZIOA  (€)",null,null,null,null,null,null,{"$f":"IFERROR(IF(J29=T!F2,ROUND((J35-J39)*(1/J37),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,26,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,26,0))","v":8631}]
[]
[null,null,"KARROZERIAREN FINANTZA GASTUAK  (€)",null,null,null,null,null,null,{"$f":"IFERROR(IF(J29=T!F2,ROUND((J35-J39)*(-(1/J$19)+L$10/(1-POWER(1+L$10,-J37))),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,27,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,27,0))","v":3460}]
[]
[null,null,"Ekipo osagarriak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Erosteko modua: ",null,null,null,null,null,null," EROSKETA"]
[]
[null,null,"Urteko alokairu edo leasing-aren ordainketa (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,28,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,28,0))","v":0}]
[]
[null,null,"Ekipamendu osagarri amortizagarrien erosketa (€)"]
[]
[null,null,"Erosketa-prezioa (tarifa prezioa - deskontua) BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,29,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,29,0))","v":0}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,30,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,30,0))","v":0}]
[]
[null,null,"Hondar-balioa BEZ gabe (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J53*H57/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,31,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$186,31,0))","v":0},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,31,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,31,0))","v":0}]
[]
[null,null,"EKIPOEN AMORTIZAZIOA  (€)",null,null,null,null,null,null,{"$f":"IFERROR(IF(J47=T!F2,ROUND((J53-J57)*(1/J55),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,32,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,32,0))","v":0}]
[]
[null,null,"EKIPOEN FINANTZA GASTUAK  (€)",null,null,null,null,null,null,{"$f":"IFERROR(IF(J47=T!F2,ROUND((J53-J57)*(-(1/J$19)+L$10/(1-POWER(1+L$10,-J55))),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,33,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,33,0))","v":0}]
[]
[null,null,"EROSKETA KOSTUAK (€)",null,null,null,null,null,null,{"$f":"IFERROR(IF(J11=T!F2,J23+J25,J13)+IF(J29=T!F2,J41+J43,J31)+IF(J47=T!F2,J59+J61,J49),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,34,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$286,34,0))","v":23470}]

{"sheet":"Ibilgailuan doazen langileen ko","index":5,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"3. Ibilgailuan doazen langileen kostuak "]
[]
[]
[null,null,"IBIGAILUAN DOAZEN LANGILEEN KOSTUAK ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Ibilgailuan doazen langileen urteko kostuak, guztira, enpresa-kostuak barne (Gizarte Segurantza eta beste)(€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,35,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,35,0))","v":34931.949999999997}]
[]
[null,null,"Ibilgailuan doazen langileen beste ordainsari osagarri batzuk (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,36,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,36,0))","v":0}]
[]
[null,null,"GARRAIO ERREGULARREKO ZERBITZUAK"]
[]
[null,null,"Garraio erregularreko ibilgailuan doazen langileen eguneko dieta osoa (€/egun) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,37,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,37,0))","v":31.82}]
[]
[null,null,"Dietarekin urtean emandako garraio erregularreko egunen kopurua ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,38,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,38,0))","v":100}]
[]
[null,null,"Garraio erregularreko ibilgailuan doazen langileen eguneko nazioarteko dieta osoa (€/egun) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,39,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,39,0))","v":0}]
[]
[null,null,"Nazioarteko dietarekin urtean egindako garraio erregularreko egunen kopurua ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,40,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,40,0))","v":0}]
[]
[null,null,"Garraio erregularrengatiko urteko dieta guztiak (€)",null,null,null,null,{"$f":"IFERROR((H17*H19)+(H21*H23),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,41,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,41,0))","v":3182}]
[]
[null,null,"ESKATU AHALAKO GARRAIO ZERBITZUAK"]
[]
[null,null,"Eskatu ahalako garraioko ibilgailuan doazen langileen eguneko dieta osoa (€/egun) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,42,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,42,0))","v":31.82}]
[]
[null,null,"Dietarekin urtean egindako eskatu ahalako garraio egunen kopurua ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,43,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,43,0))","v":100}]
[]
[null,null,"Eskatu ahalako garraioko ibilgailuan doazen langileen eguneko nazioarteko dieta osoa (€/egun) ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,44,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,44,0))","v":0}]
[]
[null,null,"Nazioarteko dietarekin urtean egindako eskatu ahalako garraio egunen kopurua ",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,45,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,45,0))","v":0}]
[]
[null,null,"Garraio erregularrengatiko urteko dieta guztiak (€)",null,null,null,null,{"$f":"IFERROR((H29*H31)+(H33*H35),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,46,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,46,0))","v":3182}]
[]
[null,null,"PERTSONAL KOSTUAK (€)",null,null,null,null,{"$f":"IFERROR(H11+H13+H25+H37,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,47,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,47,0))","v":41295.949999999997}]

{"sheet":"Aseguruak esta zerga arloko kos","index":6,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"4. Aseguruak esta zerga arloko kostuak"]
[]
[]
[null,null,"Aseguruak ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Autobusaren nahitaezko asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,48,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,48,0))","v":0}]
[]
[null,null,"Erantzukizun zibila (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,49,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,49,0))","v":0}]
[]
[null,null,"Bidaiarien nahitaezko asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,50,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,50,0))","v":0}]
[]
[null,null,"Gidariaren istripu-asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,51,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,51,0))","v":0}]
[]
[null,null,"Defentsa eta kalteengatiko erreklamazioa (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,52,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,52,0))","v":0}]
[]
[null,null,"Suteen kontrako asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,53,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,53,0))","v":0}]
[]
[null,null,"Beste aseguru batzuk (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,54,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,54,0))","v":0}]
[]
[null,null,"ASEGURUEN GUZTIRA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,55,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,55,0))","v":3059.46}]
[]
[null,null,"URTEAN GUZTIRA ASEGURUETAN GASTATUTAKOA (€)",null,null,null,null,{"$f":"IFERROR(H11+H13+H15+H17+H19+H21+H23+H25,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,56,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,56,0))","v":3059.46}]
[]
[null,null,"Zerga-arloko kostuak ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Oniritziak  (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,57,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,57,0))","v":0}]
[]
[null,null,"Ibilgailuen azterketa teknikoa (IAT) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,58,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,58,0))","v":0}]
[]
[null,null,"Ibilgailu honi jasanaraz dakiokeen jarduera ekonomikoen gaineko zerga (JEZ) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,59,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,59,0))","v":0}]
[]
[null,null,"Trakzio Mekanikozko Ibilgailuen Zerga (TMIZ) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,60,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,60,0))","v":0}]
[]
[null,null,"Takografoaren azterketa (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,61,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,61,0))","v":0}]
[]
[null,null,"Zerga-arloko beste kostu batzuk (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,62,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,62,0))","v":0}]
[]
[null,null,"ZERGA ARLOKO KOSTUAK GUZTIRA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,63,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,63,0))","v":1194.3}]
[]
[null,null,"URTEKO ZERGA ARLOKO KOSTUA GUZTIRA  (€)",null,null,null,null,{"$f":"IFERROR(H31+H33+H35+H37+H39+H41+H43,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,64,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,64,0))","v":1194.3}]
[]
[null,null,"ASEGURUAK ETA ZERGA ARLOKO KOSTUAK (€)",null,null,null,null,{"$f":"IFERROR(H27+H45,0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,65,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,65,0))","v":4253.76}]

{"sheet":"Kostu aldakorrak","index":7,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"5. Kostu aldakorrak "]
[]
[]
[null,null,"Erregaia ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/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:$AK$285,66,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,66,0))","v":1.234}]
[]
[null,null,"Deskontua (€/litroko)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,67,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,67,0))","v":0.11600000000000001}]
[]
[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!$C$1:$AK$301,68,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$301,68,0))","v":21},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,68,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,68,0))","v":0.19400000000000001}]
[]
[null,null,"Erregaiaren prezioa, BEZ gabe (€/litro) ",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:$AK$285,69,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,69,0))","v":0.92400000000000004}]
[]
[null,null,"URTEAN ERREGAITAN EGINDAKO GASTU OSOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(('Ibilgailuaren Ezaugarriak'!J23/100)*'Ibilgailuaren Ezaugarriak'!J27*'Kostu aldakorrak'!J17,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,70,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,70,0))","v":20790}]
[]
[null,null,"Urea disoluzioaren kontsumoagatiko urteko kostua",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/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:$AK$285,89,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,89,0))","v":791.37}]
[]
[null,null,"Urea disoluzioaren kontsumoagatiko urteko kostua (€/km, BEZ gabe)",null,null,null,null,null,null,{"$f":"IFERROR(J23/'Ibilgailuaren Ezaugarriak'!J23,0)","v":0},null,{"$f":"IFERROR(L23/'Ibilgailuaren Ezaugarriak'!L23,0)","v":1.05516E-2}]
[]
[null,null,"Urtean pneumatikoetan gastatutakoa ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/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:$AK$285,71,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,71,0))","v":4}]
[]
[null,null,"Pneumatiko eragile-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,72,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,72,0))","v":4}]
[]
[null,null,"Arrasteko pneumatiko-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,73,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,73,0))","v":0}]
[]
[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:$AK$285,74,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,74,0))","v":712.02}]
[]
[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:$AK$285,75,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,75,0))","v":712.02}]
[]
[null,null,"Arrasteko pneumatiko baten prezioa BEZ gabe (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,76,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,76,0))","v":712.02}]
[]
[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:$AK$285,77,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,77,0))","v":70000}]
[]
[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:$AK$285,78,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,78,0))","v":70000}]
[]
[null,null,"Arrasteko pneumatiko baten batez besteko iraunaldia (km) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,79,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,79,0))","v":70000}]
[]
[null,null,"URTEAN GUZTIRA PNEUMATIKOETAN GASTATUTAKOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J29*J35*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J41)+(J31*J37*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J43)+(J33*J39*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J45),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,80,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,80,0))","v":6103}]
[]
[null,null,"Mantentze eta konponketengatiko gastuak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Mantentze eta konponketengatiko kilometroko gastuak, BEZ gabe (€/km) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,81,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,81,0))","v":0.16669999999999999}]
[]
[null,null,"URTEAN MANTENTZE ETA KONPONKETETAN EGINDAKO GASTU OSOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Ibilgailuaren Ezaugarriak'!J23*'Kostu aldakorrak'!J51,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,82,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,82,0))","v":12502.5}]
[]
[null,null,"Bidesariak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/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:$AK$285,83,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,83,0))","v":0}]
[]
[null,null,"KOSTU ALDAKORRAK  (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Kostu aldakorrak'!J19+'Kostu aldakorrak'!J47+'Kostu aldakorrak'!J53+'Kostu aldakorrak'!J57+J23,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,84,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,84,0))","v":40186.870000000003}]
[]
[null,null,"ZUZENEKO KOSTUAK  (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Erosketa kostuak'!J63+'Ibilgailuan doazen langileen ko'!H39+'Aseguruak esta zerga arloko kos'!H47+'Kostu aldakorrak'!J59,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,85,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,85,0))","v":109206.58}]

{"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":"19/06/2025"}]
[]
[null,null,"% Kudeaketa-, administrazio- eta merkaturatze-kostu aldakorrak",null,null,null,null,null,"%",{"$f":"ROUND(('Erosketa kostuak'!J63+'Ibilgailuan doazen langileen ko'!H39+'Aseguruak esta zerga arloko kos'!H47+'Kostu aldakorrak'!J59)*('Zeharkako kostuak'!H11/100),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$301,86,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$301,86,0))","v":12.5},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,86,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,86,0))","v":13651}]
[]
[null,null,"ZEHARKAKO GASTUAK  (€)",null,null,null,null,{"$f":"J11","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,87,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,87,0))","v":13651}]
[]
[null,null,"KOSTU GUZTIAK (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H13+'Kostu aldakorrak'!J61,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,88,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$285,88,0))","v":122858}]

{"sheet":"Emaitzak","index":9,"n_rows":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":false,"merged":[[8,4,8,5],[90,4,90,5],[40,4,40,5],[67,4,67,5]]}
[]
[]
[]
[]
[]
[null,null,"Emaitzak"]
[]
[]
[null,null,"URTEKO KOSTUEN EMAITZAK ",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[null,null,"KOSTU GUZTIAK",null,{"$f":"ROUND(E12+E21,0)","v":0},100,null,{"$f":"ROUND(H12+H21,0)","v":122857},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":82670},{"$f":"IFERROR(H12*I11/H11,0)","v":67.28961312745713}]
[null,null,"Leasinga ","A",{"$f":"ROUND('Erosketa kostuak'!J13+'Erosketa kostuak'!J31+'Erosketa kostuak'!J49,0)","v":0},{"$f":"IFERROR(E13*F$11/E$11,0)","v":0},"A",{"$f":"ROUND('Erosketa kostuak'!L13+'Erosketa kostuak'!L31+'Erosketa kostuak'!L49,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,"Amortización ","B",{"$f":"ROUND('Erosketa kostuak'!J23+'Erosketa kostuak'!J41+'Erosketa kostuak'!J59,0)","v":0},0,"B",{"$f":"ROUND('Erosketa kostuak'!L23+'Erosketa kostuak'!L41+'Erosketa kostuak'!L59,0)","v":16754},13.636992601154187,null,"B",0,0,"B",16754,13.636992601154187]
[null,null,"Finantza-gastuak ","C",{"$f":"ROUND('Erosketa kostuak'!J25+'Erosketa kostuak'!J43+'Erosketa kostuak'!J61,0)","v":0},0,"C",{"$f":"ROUND('Erosketa kostuak'!L25+'Erosketa kostuak'!L43+'Erosketa kostuak'!L61,0)","v":6716},5.4665179843232377,null,"C",0,0,"C",6716,5.4665179843232377]
[null,null,"Gidariaren urteko kostua guztira ","D",{"$f":"ROUND('Ibilgailuan doazen langileen ko'!H11,0)","v":0},0,"D",{"$f":"ROUND('Ibilgailuan doazen langileen ko'!J11,0)","v":34932},28.433056317507347,null,"D",0,0,"D",34932,28.433056317507347]
[null,null,"Dietak guztira eta jarduera-plusa ","E",{"$f":"ROUND('Ibilgailuan doazen langileen ko'!H13+'Ibilgailuan doazen langileen ko'!H25+'Ibilgailuan doazen langileen ko'!H37,0)","v":0},0,"E",{"$f":"ROUND('Ibilgailuan doazen langileen ko'!J13+'Ibilgailuan doazen langileen ko'!J25+'Ibilgailuan doazen langileen ko'!J37,0)","v":6364},5.180006023262818,null,"E",0,0,"E",6364,5.180006023262818]
[null,null,"Aseguruak ","F",{"$f":"ROUND('Aseguruak esta zerga arloko kos'!H27,0)","v":0},0,"F",{"$f":"ROUND('Aseguruak esta zerga arloko kos'!J27,0)","v":3059},2.4898866161472282,null,"F",0,0,"F",3059,2.4898866161472282]
[null,null,"Zerga-arloko kostuak ","G",{"$f":"ROUND('Aseguruak esta zerga arloko kos'!H45,0)","v":0},0,"G",{"$f":"ROUND('Aseguruak esta zerga arloko kos'!J45,0)","v":1194},0.97186159518790138,null,"G",0,0,"G",1194,0.97186159518790138]
[null,null,"Kudeaketa eta merkaturatzea ","H",{"$f":"ROUND('Zeharkako kostuak'!H13,0)","v":0},0,"H",{"$f":"ROUND('Zeharkako kostuak'!J13,0)","v":13651},11.111291989874406,null,"H",0,0,"H",13651,11.111291989874406]
[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":40187},{"$f":"IFERROR(H21*I20/H20,0)","v":32.71038687254287},null,"I",{"$f":"E22","v":0},0,"I",{"$f":"H22","v":21581},17.565950658082162]
[null,null,"Erregaia ","I",{"$f":"ROUND('Kostu aldakorrak'!J19+'Kostu aldakorrak'!J23,0)","v":0},{"$f":"IFERROR(E22*F$11/E$11,0)","v":0},"I",{"$f":"ROUND('Kostu aldakorrak'!L19+'Kostu aldakorrak'!L23,0)","v":21581},{"$f":"IFERROR(H22*I$11/H$11,0)","v":17.565950658082162},null,"J",0,0,"J",6103,4.9675639157719953]
[null,null,"Pneumatikoak ","J",{"$f":"ROUND('Kostu aldakorrak'!J47,0)","v":0},{"$f":"IFERROR(E23*F$11/E$11,0)","v":0},"J",{"$f":"ROUND('Kostu aldakorrak'!L47,0)","v":6103},{"$f":"IFERROR(H23*I$11/H$11,0)","v":4.9675639157719953},null,"K",0,0,"K",12503,10.176872298688719]
[null,null,"Mantentzea eta konponketak","K",{"$f":"ROUND('Kostu aldakorrak'!J53,0)","v":0},{"$f":"IFERROR(E24*F$11/E$11,0)","v":0},"K",{"$f":"ROUND('Kostu aldakorrak'!L53,0)","v":12503},{"$f":"IFERROR(H24*I$11/H$11,0)","v":10.176872298688719},null,"L",0,0,"L",0,0]
[null,null,"Bidesariak","L",{"$f":"ROUND('Kostu aldakorrak'!J57,0)","v":0},{"$f":"IFERROR(E25*F$11/E$11,0)","v":0},"L",{"$f":"ROUND('Kostu aldakorrak'!L57,0)","v":0},{"$f":"IFERROR(H25*I$11/H$11,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"URTEKO KOSTUEN EGITURA ",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[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":23470},{"$f":"IFERROR(H43*$I$48/$H$48,0)","v":19.103510585477427}]
[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":41296},{"$f":"IFERROR(H44*$I$48/$H$48,0)","v":33.613062340770163}]
[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":17904},{"$f":"IFERROR(H45*$I$48/$H$48,0)","v":14.573040201209537}]
[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":40187},{"$f":"IFERROR(H46*$I$48/$H$48,0)","v":32.710386872542877}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"ROUND(SUM(E43:E46),0)","v":0},100,null,{"$f":"ROUND(SUM(H43:H46),0)","v":122857},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"KOSTUAK DENBORAREN ARABERA- KOSTUAK IBILBIDEAREN ARABERA ",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[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":82670},{"$f":"IFERROR(H72*$I$48/$H$48,0)","v":67.28961312745713}]
[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":40187},{"$f":"IFERROR(H73*$I$48/$H$48,0)","v":32.710386872542877}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"ROUND(SUM(E72:E73),0)","v":0},100,null,{"$f":"ROUND(SUM(H72:H73),0)","v":122857},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BATEZ BESTEKO KOSTUAK",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Batez besteko kostu guztia (km-ko)",null,{"$f":"IFERROR('Zeharkako kostuak'!H15/'Ibilgailuaren Ezaugarriak'!J23,0)","v":0},null,null,{"$f":"IFERROR('Zeharkako kostuak'!J15/'Ibilgailuaren Ezaugarriak'!L23,0)","v":1.6381066666666666}]
[null,null,"Batez besteko kostu guztia (orduko)",null,{"$f":"IFERROR('Zeharkako kostuak'!H15/'Ibilgailuaren Ezaugarriak'!J29,0)","v":0},null,null,{"$f":"IFERROR('Zeharkako kostuak'!J15/'Ibilgailuaren Ezaugarriak'!L29,0)","v":68.254444444444445}]
[null,null,"Batez besteko kostu guztia (fakturatutako km-ko) ",null,{"$f":"IFERROR('Zeharkako kostuak'!H15/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,null,{"$f":"IFERROR('Zeharkako kostuak'!J15/'Ibilgailuaren Ezaugarriak'!L25,0)","v":1.7243228070175438}]
[null,null,"Batez besteko kostu guztia (fakturatutako orduko) ",null,{"$f":"IFERROR('Zeharkako kostuak'!H15/'Ibilgailuaren Ezaugarriak'!J31,0)","v":0},null,null,{"$f":"IFERROR('Zeharkako kostuak'!J15/'Ibilgailuaren Ezaugarriak'!L31,0)","v":75.004884004884005}]
[null,null,"Distantzia ertaineko kostua (km-ko) ",null,{"$f":"IFERROR(E73/'Ibilgailuaren Ezaugarriak'!J23,0)","v":0},null,null,{"$f":"IFERROR(H73/'Ibilgailuaren Ezaugarriak'!L23,0)","v":0.53582666666666667}]
[null,null,"Distantzia ertaineko kostua (fakturatutako km-ko) ",null,{"$f":"IFERROR(E73/'Ibilgailuaren Ezaugarriak'!J25,0)","v":0},null,null,{"$f":"IFERROR(H73/'Ibilgailuaren Ezaugarriak'!L25,0)","v":0.56402807017543855}]
[null,null,"Bidaldi ertaineko kostua (orduko) ",null,{"$f":"IFERROR(E72/'Ibilgailuaren Ezaugarriak'!J29,0)","v":0},null,null,{"$f":"IFERROR(H72/'Ibilgailuaren Ezaugarriak'!L29,0)","v":45.927777777777777}]
[null,null,"Bidaldi ertaineko kostua (fakturatutako orduko) ",null,{"$f":"IFERROR(E72/'Ibilgailuaren Ezaugarriak'!J31,0)","v":0},null,null,{"$f":"IFERROR(H72/'Ibilgailuaren Ezaugarriak'!L31,0)","v":50.470085470085472}]
[null,null,"Bidaiari-kilometroko kostu guztiak",null,{"$f":"IFERROR('Zeharkako kostuak'!H15/'Ibilgailuaren Ezaugarriak'!J35/'Ibilgailuaren Ezaugarriak'!J37,0)","v":0},null,null,{"$f":"IFERROR('Zeharkako kostuak'!J15/'Ibilgailuaren Ezaugarriak'!L35/'Ibilgailuaren Ezaugarriak'!L37,0)","v":0.16546531986531987}]

{"sheet":"Zerbitzuaren kostua","index":10,"n_rows":33,"n_cols":8,"rows_kept":33,"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 "]
[]
[null,null,"Kilometroak bidaiariko (km) "]
[]
[null,null,"Zerbitzu honetan batez besteko kontsumoa kilometroko (litro / 100 km-ko) "]
[]
[null,null,"Zerbitzu honetan bidaiariek batez beste okupatutako plaza kopurua "]
[]
[null,null,"Zerbitzu honen guztizko orduak  (h)"]
[]
[null,null,"Bidesariak (€)"]
[]
[null,null,"Zerbitzu honen kostua ibilbidearen arabera  (€)",null,null,null,null,{"$f":"IFERROR(ROUND((H13*H17/100*'Kostu aldakorrak'!J17)+(H13*('Kostu aldakorrak'!J47+'Kostu aldakorrak'!J53)/'Ibilgailuaren Ezaugarriak'!J23)+H23,2),0)","v":0}]
[]
[null,null,"Zerbitzu honen kostua denboraren arabera  (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H21*('Erosketa kostuak'!J63+'Ibilgailuan doazen langileen ko'!H39+'Aseguruak esta zerga arloko kos'!H47+'Zeharkako kostuak'!H13)/'Ibilgailuaren Ezaugarriak'!J29,2),0)","v":0}]
[]
[null,null,"Zerbitzu honekin lotutako beste kostu batzuk  (€)"]
[]
[null,null,"Zerbitzu honen guztizko kostua  (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H25+H27+H29,2),0)","v":0}]
[]
[null,null,"Zerbitzu honen bidaiari-kilometroko kostua  (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H31/H13/H19,3),0)","v":0}]