{"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":88,"n_cols":36,"rows_kept":88,"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,"22/01/2024"]
[null,"Tipo interes",null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534]
[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",95,3.0,95,2.0,95,2.0,95,2.0,95,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)",91,30.0,91,26.0,91,21.0,91,15.5,91,26.0]
[null,"Horas trabajadas al año",90,1800.0,90,1800.0,90,1800.0,90,1800.0,90,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 (€)",20,125573.76,20,110877.76,20,75360.14,20,38485.76,20,110877.76]
[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":25115.0},20.0,{"$f":"ROUND(F17*E19/100,0)","v":22176.0},20.0,{"$f":"ROUND(H17*G19/100,0)","v":15072.0},20.0,{"$f":"ROUND(J17*I19/100,0)","v":7697.0},20.0,{"$f":"ROUND(L17*K19/100,0)","v":22176.0}]
[null,"AMORTIZACION DEL CHASIS",null,{"$f":"IFERROR(ROUND((D17-D19-D71*D74-D72*D75-D73*D76)/D18,0),0)","v":7924.0},null,{"$f":"IFERROR(ROUND((F17-F19-F71*F74-F72*F75-F73*F76)/F18,0),0)","v":7113.0},null,{"$f":"IFERROR(ROUND((H17-H19-H71*H74-H72*H75-H73*H76)/H18,0),0)","v":4778.0},null,{"$f":"IFERROR(ROUND((J17-J19-J71*J74-J72*J75-J73*J76)/J18,0),0)","v":2365.0},null,{"$f":"IFERROR(ROUND((L17-L19-L71*L74-L72*L75-L73*L76)/L18,0),0)","v":7113.0}]
[null,"GASTOS FINANCIEROS DEL CHASIS",null,{"$f":"IFERROR(ROUND(IF(D17=0,0,(D17-D19-D71*D74-D72*D75-D73*D76)*(D$3/(1-POWER(1+D$3,-D18))-1/D18)),0),0)","v":3010.95},null,{"$f":"IFERROR(ROUND(IF(F17=0,0,(F17-F19-F71*F74-F72*F75-F73*F76)*(F$3/(1-POWER(1+F$3,-F18))-1/F18)),0),0)","v":2702.87},null,{"$f":"IFERROR(ROUND(IF(H17=0,0,(H17-H19-H71*H74-H72*H75-H73*H76)*(H$3/(1-POWER(1+H$3,-H18))-1/H18)),0),0)","v":1815.55},null,{"$f":"IFERROR(ROUND(IF(J17=0,0,(J17-J19-J71*J74-J72*J75-J73*J76)*(J$3/(1-POWER(1+J$3,-J18))-1/J18)),0),0)","v":898.52},null,{"$f":"IFERROR(ROUND(IF(L17=0,0,(L17-L19-L71*L74-L72*L75-L73*L76)*(L$3/(1-POWER(1+L$3,-L18))-1/L18)),0),0)","v":2702.87}]
[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 (€)",20,125573.76,20,110877.76,20,75360.14,20,38485.76,20,110877.76]
[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":25115.0},20.0,{"$f":"ROUND(F23*E25/100,0)","v":22176.0},20.0,{"$f":"ROUND(H23*G25/100,0)","v":15072.0},20.0,{"$f":"ROUND(J23*I25/100,0)","v":7697.0},20.0,{"$f":"ROUND(L23*K25/100,0)","v":22176.0}]
[null,"AMORTIZACION CARROZADO",null,{"$f":"IFERROR(ROUND((D23-D25)/D24,0),0)","v":8372.0},null,{"$f":"IFERROR(ROUND((F23-F25)/F24,0),0)","v":7392.0},null,{"$f":"IFERROR(ROUND((H23-H25)/H24,0),0)","v":5024.0},null,{"$f":"IFERROR(ROUND((J23-J25)/J24,0),0)","v":2566.0},null,{"$f":"IFERROR(ROUND((L23-L25)/L24,0),0)","v":7392.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":3181.11},null,{"$f":"IFERROR(ROUND(IF(F17=0,0,(F23-F25)*(F$3/(1-POWER(1+F$3,-F24))-1/F24)),0),0)","v":2808.82},null,{"$f":"IFERROR(ROUND(IF(H17=0,0,(H23-H25)*(H$3/(1-POWER(1+H$3,-H24))-1/H24)),0),0)","v":1909.08},null,{"$f":"IFERROR(ROUND(IF(J17=0,0,(J23-J25)*(J$3/(1-POWER(1+J$3,-J24))-1/J24)),0),0)","v":974.95},null,{"$f":"IFERROR(ROUND(IF(L17=0,0,(L23-L25)*(L$3/(1-POWER(1+L$3,-L24))-1/L24)),0),0)","v":2808.82}]
[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 (€)",0,0.0,0,0.0,0,0.0,0,0.0,0,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":22488.06},null,{"$f":"F16+F20+F21+F22+F26+F27+F28+F32+F33","v":20016.69},null,{"$f":"H16+H20+H21+H22+H26+H27+H28+H32+H33","v":13526.63},null,{"$f":"J16+J20+J21+J22+J26+J27+J28+J32+J33","v":6804.47},null,{"$f":"L16+L20+L21+L22+L26+L27+L28+L32+L33","v":20016.69}]
[null,"Coste total anual del personal de a bordo, incluidos costes de empresa (Seguridad Social y otros) (€)",null,33173.74,null,33173.74,null,33173.74,null,33173.74,null,33173.74]
[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,30.22,null,30.22,null,24.18,null,24.18,null,30.22]
[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":3022.0},null,{"$f":"F37*F38+F39*F40","v":3022.0},null,{"$f":"H37*H38+H39*H40","v":1209.0},null,{"$f":"J37*J38+J39*J40","v":604.5},null,{"$f":"L37*L38+L39*L40","v":3022.0}]
[null,"Dieta total diaria del personal de a bordo de transporte discrecional (€/día)",null,30.22,null,30.22,null,24.18,null,24.18,null,30.22]
[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":3022.0},null,{"$f":"F42*F43+F44*F45","v":3022.0},null,{"$f":"H42*H43+H44*H45","v":1209.0},null,{"$f":"J42*J43+J44*J45","v":604.5},null,{"$f":"L42*L43+L44*L45","v":3022.0}]
[null,"COSTES DE PERSONAL",null,{"$f":"D35+D41+D46","v":39217.74},null,{"$f":"F35+F41+F46","v":39217.74},null,{"$f":"H35+H41+H46","v":35591.74},null,{"$f":"J35+J41+J46","v":34382.74},null,{"$f":"L35+L41+L46","v":39217.74}]
[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,2872.33,null,2443.47,null,2014.12,null,1725.83,null,2443.47]
[null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,{"$f":"D55","v":2872.33},null,{"$f":"F55","v":2443.47},null,{"$f":"H55","v":2014.12},null,{"$f":"J55","v":1725.83},null,{"$f":"L55","v":2443.47}]
[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,1158.39,null,1098.55,null,924.68,null,702.26,null,1098.55]
[null,"COSTE FISCAL TOTAL ANUAL",null,{"$f":"D63","v":1158.39},null,{"$f":"F63","v":1098.55},null,{"$f":"H63","v":924.68},null,{"$f":"J63","v":702.26},null,{"$f":"L63","v":1098.55}]
[null,"SEGUROS Y COSTES FISCALES",6.8,{"$f":"D56+D64","v":4030.72},6.8,{"$f":"F56+F64","v":3542.02},6.8,{"$f":"H56+H64","v":2938.8},6.8,{"$f":"J56+J64","v":2428.09},6.8,{"$f":"L56+L64","v":3542.02}]
[null,"Precio del carburante, con IVA (€/litro)",21,1.6831,21,1.6831,21,1.6831,21,1.6831,21,1.6831]
[null,"Descuento (%, €/litro)",6.8,{"$f":"ROUND(D66*C67/100,3)","v":0.11},6.8,{"$f":"ROUND(F66*E67/100,3)","v":0.11},6.8,{"$f":"ROUND(H66*G67/100,3)","v":0.11},6.8,{"$f":"ROUND(J66*I67/100,3)","v":0.11},6.8,{"$f":"ROUND(L66*K67/100,3)","v":0.11}]
[null,"IVA aplicado al carburante (€/litro)",21.0,{"$f":"ROUND((C68/100)*(D66-D67)/(1+C68/100),2)","v":0.27},21.0,{"$f":"ROUND((E68/100)*(F66-F67)/(1+E68/100),2)","v":0.27},21.0,{"$f":"ROUND((G68/100)*(H66-H67)/(1+G68/100),2)","v":0.27},21.0,{"$f":"ROUND((I68/100)*(J66-J67)/(1+I68/100),2)","v":0.27},21.0,{"$f":"ROUND((K68/100)*(L66-L67)/(1+K68/100),2)","v":0.27}]
[null,"Precio carburante sin IVA (€/litro)",null,{"$f":"ROUND((D66-D67)/(1+C68/100),2)","v":1.3},null,{"$f":"ROUND((F66-F67)/(1+E68/100),2)","v":1.3},null,{"$f":"ROUND((H66-H67)/(1+G68/100),2)","v":1.3},null,{"$f":"ROUND((J66-J67)/(1+I68/100),2)","v":1.3},null,{"$f":"ROUND((L66-L67)/(1+K68/100),2)","v":1.3}]
[null,"GASTO TOTAL ANUAL EN CARBURANTE, SIN IVA (€)",null,{"$f":"ROUND(D8/100*D10*D69,0)","v":29250.0},null,{"$f":"ROUND(F8/100*F10*F69,0)","v":21970.0},null,{"$f":"ROUND(H8/100*H10*H69,0)","v":13650.0},null,{"$f":"ROUND(J8/100*J10*J69,0)","v":8060.0},null,{"$f":"ROUND(L8/100*L10*L69,0)","v":21970.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,671.71,null,557.64,null,492.26,null,402.28,null,557.64]
[null,"Precio sin IVA de un neumático motriz (€)",null,671.71,null,557.64,null,492.26,null,402.28,null,557.64]
[null,"Precio sin IVA de un neumático arrastre (€)",null,671.71,null,557.64,null,492.26,null,402.28,null,557.64]
[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":5757.51},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":3106.85},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":2109.69},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":1379.25},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":3106.85}]
[null,"Coste de mantenimento y reparaciones por km, sin IVA (€/km)",null,0.1578,null,0.15,null,0.1096,null,0.0672,null,0.15]
[null,"GASTO ANUAL EN MANTENIMIENTO Y REPARACIONES, SIN IVA (€)",null,{"$f":"ROUND(D81*D8,2)","v":11835.0},null,{"$f":"ROUND(F81*F8,2)","v":9750.0},null,{"$f":"ROUND(H81*H8,2)","v":5480.0},null,{"$f":"ROUND(J81*J8,2)","v":2688.0},null,{"$f":"ROUND(L81*L8,2)","v":9750.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,2)","v":46842.51},null,{"$f":"ROUND(F70+F80+F82+F83,2)","v":34826.85},null,{"$f":"ROUND(H70+H80+H82+H83,2)","v":21239.69},null,{"$f":"ROUND(J70+J80+J82+J83,2)","v":12127.25},null,{"$f":"ROUND(L70+L80+L82+L83,2)","v":34826.85}]
[null,"COSTES DIRECTOS",null,{"$f":"ROUND(D34+D47+D65+D84,2)","v":112579.03},null,{"$f":"ROUND(F34+F47+F65+F84,2)","v":97603.3},null,{"$f":"ROUND(H34+H47+H65+H84,2)","v":73296.86},null,{"$f":"ROUND(J34+J47+J65+J84,2)","v":55742.55},null,{"$f":"ROUND(L34+L47+L65+L84,2)","v":97603.3}]
[null,"Costes anuales de gestión, administración y comercialización, repercutibles a este vehículo",null,{"$f":"ROUND(12.5/100*D85,0)","v":14072.38},null,{"$f":"ROUND(12.5/100*F85,0)","v":12200.41},null,{"$f":"ROUND(12.5/100*H85,0)","v":9162.11},null,{"$f":"ROUND(12.5/100*J85,0)","v":6967.82},null,{"$f":"ROUND(12.5/100*L85,0)","v":12200.41}]
[null,"COSTES INDIRECTOS",null,{"$f":"ROUND(D86,0)","v":14072.38},null,{"$f":"ROUND(F86,0)","v":12200.41},null,{"$f":"ROUND(H86,0)","v":9162.11},null,{"$f":"ROUND(J86,0)","v":6967.82},null,{"$f":"ROUND(L86,0)","v":12200.41}]
[null,"COSTES TOTALES",null,{"$f":"ROUND(D85+D87,0)","v":126651.41},null,{"$f":"ROUND(F85+F87,0)","v":109803.71},null,{"$f":"ROUND(H85+H87,0)","v":82458.97},null,{"$f":"ROUND(J85+J87,0)","v":62710.37},null,{"$f":"ROUND(L85+L87,0)","v":109803.71}]

{"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":"T18"},"12 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":"08/01/2024"}]
[]
[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 12 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":""}]
[]
[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":""}]
[]
[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":""}]
[]
[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":""}]
[]
[null,null,"Ibilgailuaren ustiapen-ezaugarriak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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":""}]
[]
[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":""},{"$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":0}]
[]
[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":""}]
[]
[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":""}]
[]
[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":""},{"$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":0}]
[]
[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":""},{"$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":0}]
[]
[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":""},{"$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":0}]
[]
[null,null,"Urteko ekoizpena: bidaiariak x kilometroak ",null,null,null,null,null,null,{"$f":"J35*(J13-1)*H37/100","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":0}]

{"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":"08/01/2024"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,3,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,3,0))","v":""}]
[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$285,16,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,16,0))","v":""}]
[]
[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$285,17,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,17,0))","v":""}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,18,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,18,0))","v":""}]
[]
[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$185,19,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$185,19,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,19,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,19,0))","v":0}]
[]
[null,null,"BASTIDOREAREN AMORTIZAZIOA  (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(IF(J11=T!F2,ROUND((J17-J21-('Kostu aldakorrak'!J$23*'Kostu aldakorrak'!J$29)-('Kostu aldakorrak'!J$25*'Kostu aldakorrak'!J$31)-('Kostu aldakorrak'!J$27*'Kostu aldakorrak'!J$33))*(1/J19),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,20,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,20,0))","v":0}]
[]
[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$23*'Kostu aldakorrak'!J$29)-('Kostu aldakorrak'!J$25*'Kostu aldakorrak'!J$31)-('Kostu aldakorrak'!J$27*'Kostu aldakorrak'!J$33))*(-(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$285,21,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,21,0))","v":0}]
[]
[null,null,"Karrozeria jartzea ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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$285,22,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,22,0))","v":""}]
[]
[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$285,23,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,23,0))","v":""}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,24,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,24,0))","v":""}]
[]
[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$185,25,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$185,25,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,25,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,25,0))","v":0}]
[]
[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$285,26,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,26,0))","v":0}]
[]
[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$285,27,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,27,0))","v":0}]
[]
[null,null,"Ekipo osagarriak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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$285,28,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,28,0))","v":""}]
[]
[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$285,29,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,29,0))","v":""}]
[]
[null,null,"Bizitza teknikoa (urteak) ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,30,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,30,0))","v":""}]
[]
[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$185,31,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$185,31,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,31,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,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$285,32,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,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$285,33,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,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$285,34,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AX$285,34,0))","v":0}]

{"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":"08/01/2024"}]
[]
[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$284,35,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,35,0))","v":""}]
[]
[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$284,36,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,36,0))","v":""}]
[]
[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$284,37,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,37,0))","v":""}]
[]
[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$284,38,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,38,0))","v":""}]
[]
[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$284,39,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,39,0))","v":""}]
[]
[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$284,40,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,40,0))","v":""}]
[]
[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$284,41,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,41,0))","v":0}]
[]
[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$284,42,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,42,0))","v":""}]
[]
[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$284,43,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,43,0))","v":""}]
[]
[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$284,44,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,44,0))","v":""}]
[]
[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$284,45,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,45,0))","v":""}]
[]
[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$284,46,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,46,0))","v":0}]
[]
[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$284,47,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,47,0))","v":0}]

{"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":"08/01/2024"}]
[]
[null,null,"Autobusaren nahitaezko asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,48,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,48,0))","v":""}]
[]
[null,null,"Erantzukizun zibila (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,49,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,49,0))","v":""}]
[]
[null,null,"Bidaiarien nahitaezko asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,50,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,50,0))","v":""}]
[]
[null,null,"Gidariaren istripu-asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,51,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,51,0))","v":""}]
[]
[null,null,"Defentsa eta kalteengatiko erreklamazioa (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,52,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,52,0))","v":""}]
[]
[null,null,"Suteen kontrako asegurua (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,53,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,53,0))","v":""}]
[]
[null,null,"Beste aseguru batzuk (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,54,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,54,0))","v":""}]
[]
[null,null,"ASEGURUEN GUZTIRA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,55,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,55,0))","v":""}]
[]
[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$284,56,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,56,0))","v":0}]
[]
[null,null,"Zerga-arloko kostuak ",null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Oniritziak  (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,57,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,57,0))","v":""}]
[]
[null,null,"Ibilgailuen azterketa teknikoa (IAT) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,58,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,58,0))","v":""}]
[]
[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$284,59,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,59,0))","v":""}]
[]
[null,null,"Trakzio Mekanikozko Ibilgailuen Zerga (TMIZ) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,60,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,60,0))","v":""}]
[]
[null,null,"Takografoaren azterketa (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,61,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,61,0))","v":""}]
[]
[null,null,"Zerga-arloko beste kostu batzuk (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,62,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,62,0))","v":""}]
[]
[null,null,"ZERGA ARLOKO KOSTUAK GUZTIRA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,63,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,63,0))","v":""}]
[]
[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$284,64,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,64,0))","v":0}]
[]
[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$284,65,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,65,0))","v":0}]

{"sheet":"Kostu aldakorrak","index":7,"n_rows":55,"n_cols":13,"rows_kept":55,"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":"08/01/2024"}]
[]
[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$284,66,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,66,0))","v":""}]
[]
[null,null,"Deskontua (%, €/litroko)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H13/100)*J11,2),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$300,67,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$300,67,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,67,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,67,0))","v":0}]
[]
[null,null,"Erregaiari aplikatutako BEZa (€/litroKO)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H15/100)*(J11-J13)/(1+H15/100),2),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$300,68,0)=\"\",\"\",HLOOKUP(CONCATENATE('Ibilgailu-mota'!$E$10,\"A\"),DE!$C$1:$AK$300,68,0))","v":""},{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,68,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,68,0))","v":0}]
[]
[null,null,"Erregaiaren prezioa, BEZ gabe (€/litro) ",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J11-J13)/(1+H15/100),2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,69,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,69,0))","v":0}]
[]
[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$284,70,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,70,0))","v":0}]
[]
[null,null,"Urtean pneumatikoetan gastatutakoa ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Norabidezko pneumatiko-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,71,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,71,0))","v":""}]
[]
[null,null,"Pneumatiko eragile-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,72,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,72,0))","v":""}]
[]
[null,null,"Arrasteko pneumatiko-kopurua ",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,73,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,73,0))","v":""}]
[]
[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$284,74,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,74,0))","v":""}]
[]
[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$284,75,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,75,0))","v":""}]
[]
[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$284,76,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,76,0))","v":""}]
[]
[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$284,77,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,77,0))","v":""}]
[]
[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$284,78,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,78,0))","v":""}]
[]
[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$284,79,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,79,0))","v":""}]
[]
[null,null,"URTEAN GUZTIRA PNEUMATIKOETAN GASTATUTAKOA, BEZ GABE (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J23*J29*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J35)+(J25*J31*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J37)+(J27*J33*'Ibilgailuaren Ezaugarriak'!J23/'Kostu aldakorrak'!J39),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,80,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,80,0))","v":0}]
[]
[null,null,"Mantentze eta konponketengatiko gastuak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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$284,81,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,81,0))","v":""}]
[]
[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'!J45,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,82,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,82,0))","v":0}]
[]
[null,null,"Bidesariak ",null,null,null,null,null,null,null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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$284,83,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,83,0))","v":""}]
[]
[null,null,"KOSTU ALDAKORRAK  (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Kostu aldakorrak'!J19+'Kostu aldakorrak'!J41+'Kostu aldakorrak'!J47+'Kostu aldakorrak'!J51,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,84,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,84,0))","v":0}]
[]
[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'!J53,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,85,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,85,0))","v":0}]

{"sheet":"Zeharkako kostuak","index":8,"n_rows":15,"n_cols":11,"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":"08/01/2024"}]
[]
[null,null,"Urtean izandako kudeketa, administrazio eta merkaturatze kostuak, ibilgailu honi egoztekoak direnak  (€)",null,null,null,null,{"$f":"IFERROR(ROUND('Kostu aldakorrak'!J55/8,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,86,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,86,0))","v":0}]
[]
[null,null,"ZEHARKAKO GASTUAK  (€)",null,null,null,null,{"$f":"H11","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,87,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,87,0))","v":0}]
[]
[null,null,"KOSTU GUZTIAK (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H13+'Kostu aldakorrak'!J55,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,88,0)=\"\",\"\",HLOOKUP('Ibilgailu-mota'!$E$10,DE!$D$1:$AK$284,88,0))","v":0}]

{"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":"08/01/2024"}]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[null,null,"KOSTU GUZTIAK",null,{"$f":"E12+E21","v":0},100,null,{"$f":"H12+H21","v":0},100]
[null,null,"KOSTUAK DENBORAREN ARABERA ",null,{"$f":"IFERROR(SUM(E13:E20),0)","v":0},{"$f":"IFERROR(E12*F11/E11,0)","v":0},null,{"$f":"IFERROR(SUM(H13:H20),0)","v":0},{"$f":"IFERROR(H12*I11/H11,0)","v":0}]
[null,null,"Leasinga ","A",{"$f":"'Erosketa kostuak'!J13+'Erosketa kostuak'!J31+'Erosketa kostuak'!J49","v":0},{"$f":"IFERROR(E13*F$11/E$11,0)","v":0},"A",{"$f":"'Erosketa kostuak'!L13+'Erosketa kostuak'!L31+'Erosketa kostuak'!L49","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H13*I$11/H$11,0)","v":0},null,"A",{"$f":"E13","v":0},0,"A",{"$f":"H13","v":{"$error":"#VALUE!"}},0]
[null,null,"Amortización ","B",{"$f":"'Erosketa kostuak'!J23+'Erosketa kostuak'!J41+'Erosketa kostuak'!J59","v":0},0,"B",{"$f":"'Erosketa kostuak'!L23+'Erosketa kostuak'!L41+'Erosketa kostuak'!L59","v":0},0,null,"B",0,0,"B",0,0]
[null,null,"Finantza-gastuak ","C",{"$f":"'Erosketa kostuak'!J25+'Erosketa kostuak'!J43+'Erosketa kostuak'!J61","v":0},0,"C",{"$f":"'Erosketa kostuak'!L25+'Erosketa kostuak'!L43+'Erosketa kostuak'!L61","v":0},0,null,"C",0,0,"C",0,0]
[null,null,"Gidariaren urteko kostua guztira ","D",{"$f":"'Ibilgailuan doazen langileen ko'!H11","v":0},0,"D",{"$f":"'Ibilgailuan doazen langileen ko'!J11","v":""},0,null,"D",0,0,"D","",0]
[null,null,"Dietak guztira eta jarduera-plusa ","E",{"$f":"'Ibilgailuan doazen langileen ko'!H13+'Ibilgailuan doazen langileen ko'!H25+'Ibilgailuan doazen langileen ko'!H37","v":0},0,"E",{"$f":"'Ibilgailuan doazen langileen ko'!J13+'Ibilgailuan doazen langileen ko'!J25+'Ibilgailuan doazen langileen ko'!J37","v":{"$error":"#VALUE!"}},0,null,"E",0,0,"E",{"$error":"#VALUE!"},0]
[null,null,"Aseguruak ","F",{"$f":"'Aseguruak esta zerga arloko kos'!H27","v":0},0,"F",{"$f":"'Aseguruak esta zerga arloko kos'!J27","v":0},0,null,"F",0,0,"F",0,0]
[null,null,"Zerga-arloko kostuak ","G",{"$f":"'Aseguruak esta zerga arloko kos'!H45","v":0},0,"G",{"$f":"'Aseguruak esta zerga arloko kos'!J45","v":0},0,null,"G",0,0,"G",0,0]
[null,null,"Kudeaketa eta merkaturatzea ","H",{"$f":"'Zeharkako kostuak'!H13","v":0},0,"H",{"$f":"'Zeharkako kostuak'!J13","v":0},0,null,"H",0,0,"H",0,0]
[null,null,"KOSTUAK IBILBIDEAREN ARABERA ",null,{"$f":"IFERROR(SUM(E22:E25),0)","v":0},{"$f":"IFERROR(E21*F20/E20,0)","v":0},null,{"$f":"IFERROR(SUM(H22:H25),0)","v":0},{"$f":"IFERROR(H21*I20/H20,0)","v":0},null,"I",{"$f":"E22","v":0},0,"I",{"$f":"H22","v":0},0]
[null,null,"Erregaia ","I",{"$f":"'Kostu aldakorrak'!J19","v":0},{"$f":"IFERROR(E22*F$11/E$11,0)","v":0},"I",{"$f":"'Kostu aldakorrak'!L19","v":0},{"$f":"IFERROR(H22*I$11/H$11,0)","v":0},null,"J",0,0,"J",0,0]
[null,null,"Pneumatikoak ","J",{"$f":"'Kostu aldakorrak'!J41","v":0},{"$f":"IFERROR(E23*F$11/E$11,0)","v":0},"J",{"$f":"'Kostu aldakorrak'!L41","v":0},{"$f":"IFERROR(H23*I$11/H$11,0)","v":0},null,"K",0,0,"K",0,0]
[null,null,"Mantentzea eta konponketak","K",{"$f":"'Kostu aldakorrak'!J47","v":0},{"$f":"IFERROR(E24*F$11/E$11,0)","v":0},"K",{"$f":"'Kostu aldakorrak'!L47","v":0},{"$f":"IFERROR(H24*I$11/H$11,0)","v":0},null,"L",0,0,"L","",0]
[null,null,"Bidesariak","L",{"$f":"'Kostu aldakorrak'!J51","v":0},{"$f":"IFERROR(E25*F$11/E$11,0)","v":0},"L",{"$f":"'Kostu aldakorrak'!L51","v":""},{"$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":"08/01/2024"}]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[null,null,"Amortizazioa eta finantza-gastuak eta leasinga ","A",{"$f":"E13+E14+E15","v":0},{"$f":"IFERROR(E43*$F$48/$E$48,0)","v":0},"A",{"$f":"H13+H14+H15","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H43*$I$48/$H$48,0)","v":0}]
[null,null,"Langileak","B",{"$f":"E16+E17","v":0},{"$f":"IFERROR(E44*$F$48/$E$48,0)","v":0},"B",{"$f":"H16+H17","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H44*$I$48/$H$48,0)","v":0}]
[null,null,"Aseguruak, zerga-arloko kostuak, kudeaketa eta merkaturatzea ","C",{"$f":"E18+E19+E20","v":0},{"$f":"IFERROR(E45*$F$48/$E$48,0)","v":0},"C",{"$f":"H18+H19+H20","v":0},{"$f":"IFERROR(H45*$I$48/$H$48,0)","v":0}]
[null,null,"Erregaia, pneumatikoak, konponketak, mantentzea eta bidesariak ","D",{"$f":"E22+E23+E24+E25","v":0},{"$f":"IFERROR(E46*$F$48/$E$48,0)","v":0},"D",{"$f":"H22+H23+H24+H25","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H46*$I$48/$H$48,0)","v":0}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"SUM(E43:E46)","v":0},100,null,{"$f":"SUM(H43:H46)","v":{"$error":"#VALUE!"}},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"KOSTUAK DENBORAREN ARABERA- KOSTUAK IBILBIDEAREN ARABERA ",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,null,null,"Euro","%",null,"Euro","%"]
[]
[null,null,"Kostuak denboraren arabera ","A",{"$f":"E12","v":0},{"$f":"IFERROR(E72*$F$48/$E$48,0)","v":0},"A",{"$f":"H12","v":0},{"$f":"IFERROR(H72*$I$48/$H$48,0)","v":0}]
[null,null,"Kostuak ibilbidearen arabera ","B",{"$f":"E21","v":0},{"$f":"IFERROR(E73*$F$48/$E$48,0)","v":0},"B",{"$f":"H21","v":0},{"$f":"IFERROR(H73*$I$48/$H$48,0)","v":0}]
[]
[null,null,"GUZTIZKO KOSTUAK",null,{"$f":"SUM(E72:E73)","v":0},100,null,{"$f":"SUM(H72:H73)","v":0},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BATEZ BESTEKO KOSTUAK",null,"Erabiltzailea",null,null,"Datu estadistikoak",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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":0}]
[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":0}]
[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":0}]
[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":0}]
[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}]
[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}]
[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":0}]
[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":0}]
[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}]

{"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'!J41+'Kostu aldakorrak'!J47)/'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}]