{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["T","DE","Tipo Vehículo","Características Vehículo","Costes Adquisición","Costes Personal","Seguros y Costes Fiscales","Costes Variables","Costes Indirectos","Resultados","Coste Servicio"],"not_rendered":{"charts":6,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"T","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Tipo de vehículo",null,"Pregunta",null,null,"Adquisicion",null,"Editar"]
["Autocar de 15 metros","T17","Si","S",null,"COMPRA"]
["Autocar de 12 metros","T18","No","N",null,"ALQUILER, LEASING…"]
["Autocar de 9 metros","T19"]
["Microbús","T20"]
["Autocar genérico (autocares no englobados en las categorías anteriores)","T21"]

{"sheet":"DE","index":1,"n_rows":90,"n_cols":36,"rows_kept":90,"cut":false,"hidden":true,"merged":[[16,13,16,14],[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,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":"Tipo Vehículo","index":2,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"1. Seleccionar tipo de vehículo"]
[]
[]
[]
[null,null,"Tipo de vehículo:",null,{"$f":"VLOOKUP(F10,T!A2:B17,2,0)","v":"T17"},"Autocar de 15 metros"]
[]
[]
[null,null,"¿Desea cargar los datos estadísticos en los campos a rellenar?",null,null,null,"No"]
[]
[]
[null,null,"¿Desea comenzar la simulación con los datos estadísticos añadidos a los formularios de cálculo?"]

{"sheet":"Características Vehículo","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,9,10,13]]}
[]
[]
[]
[]
[]
[null,null,"1. Características del vehículo"]
[]
[]
[null,null,"Características técnicas del vehículo",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Descripción:",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$15,2,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$15,2,0))","v":"Autocar de 15 metros"}]
[]
[null,null,"Número de plazas incluido el conductor",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,4,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,4,0))","v":15}]
[]
[null,null,"Potencia (CV)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,5,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,5,0))","v":15}]
[]
[null,null,"MMA ( Tm)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,6,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,6,0))","v":0}]
[]
[null,null,"Número de ejes",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,7,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,7,0))","v":4}]
[]
[null,null,"Características de explotación del vehículo",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Kilómetros recorridos anualmente (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,8,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,8,0))","v":75000}]
[]
[null,null,"Kilómetros facturados de los recorridos al año (km)",null,null,null,null,null,"%",{"$f":"ROUND(J23*H25/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,9,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,9,0))","v":95},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,9,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,9,0))","v":71250}]
[]
[null,null,"Consumo medio (litros/100km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,10,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,10,0))","v":30}]
[]
[null,null,"Horas trabajadas al año",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,11,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,11,0))","v":1800}]
[]
[null,null,"Horas facturadas de las trabajadas al año (h,%)",null,null,null,null,null,"%",{"$f":"ROUND(J29*H31/100,0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,12,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,12,0))","v":91},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,12,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,12,0))","v":1638}]
[]
[null,null,"Personas transportadas"]
[]
[null,null,"Kilómetros con personas de los recorridos al año (km,%)",null,null,null,null,null,"%",{"$f":"ROUND(J23*H35/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,13,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,13,0))","v":90},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,13,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,13,0))","v":67500}]
[]
[null,null,"Ocupación media de las plazas en los kilómetros recorridos con personas (personas/autocar,%)",null,null,null,null,null,"%",{"$f":"ROUND((J13-1)*H37/100,0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,14,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$15,14,0))","v":80},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,14,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,14,0))","v":11}]
[]
[null,null,"Producción anual: Personas x Kilómetros",null,null,null,null,null,null,{"$f":"J35*J37","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,15,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$15,15,0))","v":742500}]

{"sheet":"Costes Adquisición","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. Costes de adquisición"]
[]
[]
[null,null,"Chasis del autocar",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,3,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,3,0))","v":5.6099999999999997E-2}]
[null,null,"Forma de adquisición: ",null,null,null,null,null,null,"COMPRA"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,16,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,16,0))","v":0}]
[]
[null,null,"Compra del chasis (€)"]
[]
[null,null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,17,0))","v":129466.55}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,18,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,18,0))","v":12}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J$17*H21/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,19,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,19,0))","v":20},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,19,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,19,0))","v":25893}]
[]
[null,null,"AMORTIZACION DEL CHASIS (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(IF(J11=T!F2,ROUND((J17-J21-('Costes Variables'!J$47))*(1/J19),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,20,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,20,0))","v":8123}]
[]
[null,null,"GASTOS FINANCIEROS DEL CHASIS (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR(IF(J11=T!F2,ROUND((J17-J21-('Costes Variables'!J$47))*(-(1/J19)+L$10/(1-POWER(1+L$10,-J19))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,21,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,21,0))","v":3256}]
[]
[null,null,"Carrozado del autocar",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Forma de adquisición: ",null,null,null,null,null,null,"COMPRA"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,22,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,22,0))","v":0}]
[]
[null,null,"Compra carrozado (€)"]
[]
[null,null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,23,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,23,0))","v":129466.55}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,24,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,24,0))","v":12}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J35*H39/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,25,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,25,0))","v":20},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,25,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,25,0))","v":25893}]
[]
[null,null,"AMORTIZACION CARROZADO (€)",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('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,26,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,26,0))","v":8631}]
[]
[null,null,"GASTOS FINANCIEROS CARROZADO (€)",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('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,27,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,27,0))","v":3460}]
[]
[null,null,"Equipos auxiliares",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Forma de adquisición: ",null,null,null,null,null,null,"COMPRA"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,28,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,28,0))","v":0}]
[]
[null,null,"Compra de equipos auxiliares amortizables (€)"]
[]
[null,null,"Precio de adquisición (precio de tarifa - descuento) sin IVA (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,29,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,29,0))","v":0}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,30,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,30,0))","v":0}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND(J53*H57/100,0),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,31,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$186,31,0))","v":0},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,31,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,31,0))","v":0}]
[]
[null,null,"AMORTIZACION EQUIPOS (€)",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('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,32,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,32,0))","v":0}]
[]
[null,null,"GASTOS FINANCIEROS EQUIPOS (€)",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('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,33,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,33,0))","v":0}]
[]
[null,null,"COSTES DE ADQUISICION (€)",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('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,34,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$AK$286,34,0))","v":23470}]

{"sheet":"Costes Personal","index":5,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"3. Costes de personal de a bordo"]
[]
[]
[null,null,"COSTES DE PERSONAL DE A BORDO",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Coste total anual del personal de a bordo, incluidos costes de empresa (Seguridad Social y otros) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,35,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,35,0))","v":34931.949999999997}]
[]
[null,null,"Otros complementos retributivos del personal de a bordo (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,36,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,36,0))","v":0}]
[]
[null,null,"SERVICIOS DE TRANSPORTE REGULARES"]
[]
[null,null,"Dieta total diaria del personal de a bordo de transporte regular (€/día)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,37,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,37,0))","v":31.82}]
[]
[null,null,"Número de días de transporte regular con dieta al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,38,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,38,0))","v":100}]
[]
[null,null,"Dieta total diaria internacional del personal de a bordo de transporte regular (€/día)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,39,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,39,0))","v":0}]
[]
[null,null,"Número de días de transporte regular con dieta internacional al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,40,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,40,0))","v":0}]
[]
[null,null,"Dietas totales anuales por transporte regular (€)",null,null,null,null,{"$f":"IFERROR((H17*H19)+(H21*H23),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,41,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,41,0))","v":3182}]
[]
[null,null,"SERVICIOS DE TRANSPORTE DISCRECIONAL"]
[]
[null,null,"Dieta total diaria del personal de a bordo de transporte discrecional (€/día)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,42,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,42,0))","v":31.82}]
[]
[null,null,"Número de días de transporte discrecional con dieta al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,43,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,43,0))","v":100}]
[]
[null,null,"Dieta total diaria internacional del personal de a bordo de transporte discrecional (€/día)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,44,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,44,0))","v":0}]
[]
[null,null,"Número de días de transporte discrecional con dieta internacional al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,45,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,45,0))","v":0}]
[]
[null,null,"Dietas totales anuales por transporte discrecional (€)",null,null,null,null,{"$f":"IFERROR((H29*H31)+(H33*H35),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,46,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,46,0))","v":3182}]
[]
[null,null,"COSTES DE PERSONAL (€)",null,null,null,null,{"$f":"IFERROR(H11+H13+H25+H37,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,47,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,47,0))","v":41295.949999999997}]

{"sheet":"Seguros y Costes Fiscales","index":6,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"4. Seguros y costes fiscales"]
[]
[]
[null,null,"SEGUROS",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Seguro obligatorio del autocar (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,48,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,48,0))","v":0}]
[]
[null,null,"Responsabilidad civil (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,49,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,49,0))","v":0}]
[]
[null,null,"Seguro obligatorio de personas (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,50,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,50,0))","v":0}]
[]
[null,null,"Seguro de accidentes del conductor (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,51,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,51,0))","v":0}]
[]
[null,null,"Defensa y reclamación de daños (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,52,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,52,0))","v":0}]
[]
[null,null,"Seguro de incendios (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,53,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,53,0))","v":0}]
[]
[null,null,"Otros seguros (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,54,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,54,0))","v":0}]
[]
[null,null,"TOTAL SEGUROS (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,55,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,55,0))","v":3059.46}]
[]
[null,null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,null,null,{"$f":"IFERROR(H11+H13+H15+H17+H19+H21+H23+H25,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,56,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,56,0))","v":3059.46}]
[]
[null,null,"Costes fiscales",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Visados (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,57,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,57,0))","v":0}]
[]
[null,null,"Inspección técnica de vehículos (I.T.V.) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,58,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,58,0))","v":0}]
[]
[null,null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,59,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,59,0))","v":0}]
[]
[null,null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,60,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,60,0))","v":0}]
[]
[null,null,"Revisión tacógrafo (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,61,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,61,0))","v":0}]
[]
[null,null,"Otros costes fiscales (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,62,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,62,0))","v":0}]
[]
[null,null,"TOTAL COSTES FISCALES (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,63,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,63,0))","v":1194.3}]
[]
[null,null,"COSTE FISCAL TOTAL ANUAL (€)",null,null,null,null,{"$f":"IFERROR(H31+H33+H35+H37+H39+H41+H43,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,64,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,64,0))","v":1194.3}]
[]
[null,null,"SEGUROS Y COSTES FISCALES (€)",null,null,null,null,{"$f":"IFERROR(H27+H45,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,65,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,65,0))","v":4253.76}]

{"sheet":"Costes Variables","index":7,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"5. Costes variables"]
[]
[]
[null,null,"Carburante",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Precio del carburante, con IVA (€/litro)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,66,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,66,0))","v":1.234}]
[]
[null,null,"Descuento (€/litro)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,67,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,67,0))","v":0.11600000000000001}]
[]
[null,null,"IVA aplicado al carburante (€/litro)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H15/100)*(J11-J13)/(1+H15/100),4),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$301,68,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$301,68,0))","v":21},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,68,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,68,0))","v":0.19400000000000001}]
[]
[null,null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J11-J13)/(1+H15/100),4),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,69,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,69,0))","v":0.92400000000000004}]
[]
[null,null,"GASTO TOTAL ANUAL EN CARBURANTE, SIN IVA (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(('Características Vehículo'!J23/100)*'Características Vehículo'!J27*'Costes Variables'!J17,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,70,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,70,0))","v":20790}]
[]
[null,null,"Coste anual por consumo de disolución de urea",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"GASTO TOTAL ANUAL POR CONSUMO DE DISOLUCION DE UREA",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,89,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,89,0))","v":791.37}]
[]
[null,null,"Coste anual por disolución de urea por kilómetro(€/km, sin IVA)",null,null,null,null,null,null,{"$f":"IFERROR(J23/'Características Vehículo'!J23,0)","v":0},null,{"$f":"IFERROR(L23/'Características Vehículo'!L23,0)","v":1.05516E-2}]
[]
[null,null,"Coste anual de neumáticos",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Número de neumáticos direccionables",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,71,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,71,0))","v":4}]
[]
[null,null,"Número de neumáticos motrices",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,72,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,72,0))","v":4}]
[]
[null,null,"Número de neumáticos arrastre",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,73,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,73,0))","v":0}]
[]
[null,null,"Precio sin IVA de un neumático direccionable (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,74,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,74,0))","v":712.02}]
[]
[null,null,"Precio sin IVA de un neumático motriz (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,75,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,75,0))","v":712.02}]
[]
[null,null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,76,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,76,0))","v":712.02}]
[]
[null,null,"Duración media de un neumático direccionable (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,77,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,77,0))","v":70000}]
[]
[null,null,"Duración media de un neumático motriz (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,78,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,78,0))","v":70000}]
[]
[null,null,"Duración media de un neumático arrastre (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,79,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,79,0))","v":70000}]
[]
[null,null,"GASTO TOTAL ANUAL EN NEUMATICOS, SIN IVA (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J29*J35*'Características Vehículo'!J23/'Costes Variables'!J41)+(J31*J37*'Características Vehículo'!J23/'Costes Variables'!J43)+(J33*J39*'Características Vehículo'!J23/'Costes Variables'!J45),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,80,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,80,0))","v":6103}]
[]
[null,null,"Gastos de mantenimiento y reparaciones",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Coste de mantenimento y reparaciones por km, sin IVA (€/km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,81,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,81,0))","v":0.16669999999999999}]
[]
[null,null,"GASTO ANUAL EN MANTENIMIENTO Y REPARACIONES, SIN IVA (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Características Vehículo'!J23*'Costes Variables'!J51,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,82,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,82,0))","v":12502.5}]
[]
[null,null,"Peajes",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,83,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,83,0))","v":0}]
[]
[null,null,"COSTES VARIABLES (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Costes Variables'!J19+'Costes Variables'!J47+'Costes Variables'!J53+'Costes Variables'!J57+J23,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,84,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,84,0))","v":40186.870000000003}]
[]
[null,null,"COSTES DIRECTOS (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND('Costes Adquisición'!J63+'Costes Personal'!H39+'Seguros y Costes Fiscales'!H47+'Costes Variables'!J59,2),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,85,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,85,0))","v":109206.58}]

{"sheet":"Costes Indirectos","index":8,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"6. Costes indirectos"]
[]
[]
[null,null,"Costes Indirectos",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"% Costes variables de gestión, administración y comercialización",null,null,null,null,null,"%",{"$f":"ROUND(('Costes Adquisición'!J63+'Costes Personal'!H39+'Seguros y Costes Fiscales'!H47+'Costes Variables'!J59)*(H11/100),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$301,86,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$C$1:$X$301,86,0))","v":12.5},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,86,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,86,0))","v":13651}]
[]
[null,null,"COSTES INDIRECTOS (€)",null,null,null,null,{"$f":"J11","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,87,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,87,0))","v":13651}]
[]
[null,null,"COSTES TOTALES (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H13+'Costes Variables'!J61,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,88,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$C$1:$X$285,88,0))","v":122858}]

{"sheet":"Resultados","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,"Resultados"]
[]
[]
[null,null,"RESULTADOS COSTES ANUALES",null,"Usuario",null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[null,null,"COSTES TOTALES",null,{"$f":"ROUND(E12+E21,0)","v":0},100,null,{"$f":"ROUND(H12+H21,0)","v":122857},100]
[null,null,"COSTES POR TIEMPO",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,"Leasing","A",{"$f":"ROUND('Costes Adquisición'!J13+'Costes Adquisición'!J31+'Costes Adquisición'!J49,0)","v":0},{"$f":"IFERROR(E13*F$11/E$11,0)","v":0},"A",{"$f":"ROUND('Costes Adquisición'!L13+'Costes Adquisición'!L31+'Costes Adquisición'!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('Costes Adquisición'!J23+'Costes Adquisición'!J41+'Costes Adquisición'!J59,0)","v":0},{"$f":"IFERROR(E14*F$11/E$11,0)","v":0},"B",{"$f":"ROUND('Costes Adquisición'!L23+'Costes Adquisición'!L41+'Costes Adquisición'!L59,0)","v":16754},13.636992601154187,null,"B",0,0,"B",16754,13.636992601154187]
[null,null,"Gastos financieros","C",{"$f":"ROUND('Costes Adquisición'!J25+'Costes Adquisición'!J43+'Costes Adquisición'!J61,0)","v":0},0,"C",{"$f":"ROUND('Costes Adquisición'!L25+'Costes Adquisición'!L43+'Costes Adquisición'!L61,0)","v":6716},5.4665179843232377,null,"C",0,0,"C",6716,5.4665179843232377]
[null,null,"Coste total anual del conductor","D",{"$f":"ROUND('Costes Personal'!H11,0)","v":0},0,"D",{"$f":"ROUND('Costes Personal'!J11,0)","v":34932},28.433056317507347,null,"D",0,0,"D",34932,28.433056317507347]
[null,null,"Dietas y otros complementos retributivos del personal de a bordo","E",{"$f":"ROUND('Costes Personal'!H13+'Costes Personal'!H25+'Costes Personal'!H37,0)","v":0},0,"E",{"$f":"ROUND('Costes Personal'!J13+'Costes Personal'!J25+'Costes Personal'!J37,0)","v":6364},5.180006023262818,null,"E",0,0,"E",6364,5.180006023262818]
[null,null,"Seguros","F",{"$f":"ROUND('Seguros y Costes Fiscales'!H27,0)","v":0},0,"F",{"$f":"ROUND('Seguros y Costes Fiscales'!J27,0)","v":3059},2.4898866161472282,null,"F",0,0,"F",3059,2.4898866161472282]
[null,null,"Costes fiscales","G",{"$f":"ROUND('Seguros y Costes Fiscales'!H45,0)","v":0},0,"G",{"$f":"ROUND('Seguros y Costes Fiscales'!J45,0)","v":1194},0.97186159518790138,null,"G",0,0,"G",1194,0.97186159518790138]
[null,null,"Gestión y comercialización","H",{"$f":"ROUND('Costes Indirectos'!H13,0)","v":0},0,"H",{"$f":"ROUND('Costes Indirectos'!J13,0)","v":13651},11.111291989874406,null,"H",0,0,"H",13651,11.111291989874406]
[null,null,"COSTES POR DISTANCIA",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,"Combustible","I",{"$f":"ROUND('Costes Variables'!J19+'Costes Variables'!J23,0)","v":0},{"$f":"IFERROR(E22*F$11/E$11,0)","v":0},"I",{"$f":"ROUND('Costes Variables'!L19+'Costes Variables'!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,"Neumáticos","J",{"$f":"ROUND('Costes Variables'!J47,0)","v":0},{"$f":"IFERROR(E23*F$11/E$11,0)","v":0},"J",{"$f":"ROUND('Costes Variables'!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,"Mantenimiento y reparaciones","K",{"$f":"ROUND('Costes Variables'!J53,0)","v":0},{"$f":"IFERROR(E24*F$11/E$11,0)","v":0},"K",{"$f":"ROUND('Costes Variables'!L53,0)","v":12503},{"$f":"IFERROR(H24*I$11/H$11,0)","v":10.176872298688719},null,"L",0,0,"L",0,0]
[null,null,"Peajes","L",{"$f":"ROUND('Costes Variables'!J57,0)","v":0},{"$f":"IFERROR(E25*F$11/E$11,0)","v":0},"L",{"$f":"ROUND('Costes Variables'!L57,0)","v":0},{"$f":"IFERROR(H25*I$11/H$11,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ESTRUCTURA DE COSTES ANUALES",null,"Usuario",null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[null,null,"Amortización y gastos financieros y leasing","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,"Personal","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,"Seguros, costes fiscales, gestión y comercialización","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,"Carburante, neumáticos, reparaciones, mantenimiento y peajes","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,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E43:E46),0)","v":0},100,null,{"$f":"ROUND(SUM(H43:H46),0)","v":122857},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"COSTES POR TIEMPO-COSTES POR DISTANCIA",null,"Usuario",null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[]
[null,null,"Costes por tiempo","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,"Costes por distancia","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,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E72:E73),0)","v":0},100,null,{"$f":"ROUND(SUM(H72:H73),0)","v":122857},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"COSTES MEDIOS",null,"Usuario",null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"19/06/2025"}]
[]
[null,null,"Coste total medio (por km)",null,{"$f":"IFERROR('Costes Indirectos'!H15/'Características Vehículo'!J23,0)","v":0},null,null,{"$f":"IFERROR('Costes Indirectos'!J15/'Características Vehículo'!L23,0)","v":1.6381066666666666}]
[null,null,"Coste total medio (por hora)",null,{"$f":"IFERROR('Costes Indirectos'!H15/'Características Vehículo'!J29,0)","v":0},null,null,{"$f":"IFERROR('Costes Indirectos'!J15/'Características Vehículo'!L29,0)","v":68.254444444444445}]
[null,null,"Coste total medio (por km. facturado)",null,{"$f":"IFERROR('Costes Indirectos'!H15/'Características Vehículo'!J25,0)","v":0},null,null,{"$f":"IFERROR('Costes Indirectos'!J15/'Características Vehículo'!L25,0)","v":1.7243228070175438}]
[null,null,"Coste total medio (por hora facturada)",null,{"$f":"IFERROR('Costes Indirectos'!H15/'Características Vehículo'!J31,0)","v":0},null,null,{"$f":"IFERROR('Costes Indirectos'!J15/'Características Vehículo'!L31,0)","v":75.004884004884005}]
[null,null,"Coste por distancia media (por km)",null,{"$f":"IFERROR(E73/'Características Vehículo'!J23,0)","v":0},null,null,{"$f":"IFERROR(H73/'Características Vehículo'!L23,0)","v":0.53582666666666667}]
[null,null,"Coste por distancia media (por km. facturado)",null,{"$f":"IFERROR(E73/'Características Vehículo'!J25,0)","v":0},null,null,{"$f":"IFERROR(H73/'Características Vehículo'!L25,0)","v":0.56402807017543855}]
[null,null,"Coste por tiempo medio (por hora)",null,{"$f":"IFERROR(E72/'Características Vehículo'!J29,0)","v":0},null,null,{"$f":"IFERROR(H72/'Características Vehículo'!L29,0)","v":45.927777777777777}]
[null,null,"Coste por tiempo medio (por hora facturada)",null,{"$f":"IFERROR(E72/'Características Vehículo'!J31,0)","v":0},null,null,{"$f":"IFERROR(H72/'Características Vehículo'!L31,0)","v":50.470085470085472}]
[null,null,"Costes totales por persona-kilómetro",null,{"$f":"IFERROR('Costes Indirectos'!H15/'Características Vehículo'!J35/'Características Vehículo'!J37,0)","v":0},null,null,{"$f":"IFERROR('Costes Indirectos'!J15/'Características Vehículo'!L35/'Características Vehículo'!L37,0)","v":0.16546531986531987}]

{"sheet":"Coste Servicio","index":10,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,7,10,10]]}
[]
[]
[]
[]
[]
[null,null,"Coste de un servicio"]
[]
[]
[null,null,"Coste de un servicio"]
[]
[null,null,"Denominación del servicio"]
[]
[null,null,"Kilómetros recorridos en este servicio (km)"]
[]
[null,null,"Kilómetros con personas (km)"]
[]
[null,null,"Consumo medio por kilómetro en este servicio (litros / 100 km)"]
[]
[null,null,"Número medio de plazas de personas ocupadas en este servicio"]
[]
[null,null,"Horas empleadas en este servicio (h)"]
[]
[null,null,"Peajes (€)"]
[]
[null,null,"Coste por distancia de este servicio (€)",null,null,null,null,{"$f":"IFERROR(ROUND((H13*H17/100*'Costes Variables'!J17)+(H13*('Costes Variables'!J47+'Costes Variables'!J53)/'Características Vehículo'!J23)+H23,2),0)","v":0}]
[]
[null,null,"Coste por tiempo de este servicio (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H21*('Costes Adquisición'!J63+'Costes Personal'!H39+'Seguros y Costes Fiscales'!H47+'Costes Indirectos'!H13)/'Características Vehículo'!J29,2),0)","v":0}]
[]
[null,null,"Otros costes asociados a este servicio (€)"]
[]
[null,null,"Coste total de este servicio (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H25+H27+H29,2),0)","v":0}]
[]
[null,null,"Coste por persona-kilómetro de este servicio (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H31/H13/H19,3),0)","v":0}]