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

{"sheet":"Resultados","index":4,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[58,4,58,5],[8,4,8,5],[35,4,35,5]]}
[]
[]
[]
[]
[]
[null,null,"Resultados"]
[]
[]
[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(IFERROR(ROUND(('Cálculo Simplificado'!I25-'Cálculo Simplificado'!I29)*(1/'Cálculo Simplificado'!I27)+('Cálculo Simplificado'!I31-'Cálculo Simplificado'!I35)*(1/'Cálculo Simplificado'!I33)+('Cálculo Simplificado'!I25-'Cálculo Simplificado'!I29)*(-(1/'Cálculo Simplificado'!I27)+'Cálculo Simplificado'!J10/(1-POWER(1+'Cálculo Simplificado'!J10,((-1)*'Cálculo Simplificado'!I27))))+('Cálculo Simplificado'!I31-'Cálculo Simplificado'!I35)*(-(1/'Cálculo Simplificado'!I33)+'Cálculo Simplificado'!J10/(1-POWER(1+'Cálculo Simplificado'!J10,((-1)*'Cálculo Simplificado'!I33)))),0)+'Cálculo Simplificado'!I37,0),0)","v":0},{"$f":"IFERROR(E11*F$16/E$16,0)","v":0},"A",{"$f":"ROUND(IFERROR(ROUND(('Cálculo Simplificado'!J25-'Cálculo Simplificado'!J29)*(1/'Cálculo Simplificado'!J27)+('Cálculo Simplificado'!J31-'Cálculo Simplificado'!J35)*(1/'Cálculo Simplificado'!J33)+('Cálculo Simplificado'!J25-'Cálculo Simplificado'!J29)*(-(1/'Cálculo Simplificado'!J27)+'Cálculo Simplificado'!J10/(1-POWER(1+'Cálculo Simplificado'!J10,((-1)*'Cálculo Simplificado'!J27))))+('Cálculo Simplificado'!J31-'Cálculo Simplificado'!J35)*(-(1/'Cálculo Simplificado'!J33)+'Cálculo Simplificado'!J10/(1-POWER(1+'Cálculo Simplificado'!J10,((-1)*'Cálculo Simplificado'!J33)))),0)+'Cálculo Simplificado'!J37,0),0)","v":23470},{"$f":"IFERROR(H11*I$16/H$16,0)","v":19.103355092871446}]
[null,null,"Personal","B",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!I39+'Cálculo Simplificado'!I41,0),0)","v":0},{"$f":"IFERROR(E12*F$16/E$16,0)","v":0},"B",{"$f":"ROUND('Cálculo Simplificado'!J39+'Cálculo Simplificado'!J41,0)","v":41296},{"$f":"IFERROR(H12*I$16/H$16,0)","v":33.612788747985476}]
[null,null,"Seguros, costes fiscales, gestión y comercialización","C",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!I43+'Cálculo Simplificado'!I45+'Cálculo Simplificado'!I59,0),0)","v":0},{"$f":"IFERROR(E13*F$16/E$16,0)","v":0},"C",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!J43+'Cálculo Simplificado'!J45+'Cálculo Simplificado'!J59,0),0)","v":17905},{"$f":"IFERROR(H13*I$16/H$16,0)","v":14.573735532077682}]
[null,null,"Carburante, neumáticos, reparaciones, mantenimiento y peajes","D",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!I49+'Cálculo Simplificado'!I51+'Cálculo Simplificado'!I53+'Cálculo Simplificado'!I55+'Cálculo Simplificado'!I57,0),0)","v":0},{"$f":"IFERROR(E14*F$16/E$16,0)","v":0},"D",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!J49+'Cálculo Simplificado'!J51+'Cálculo Simplificado'!J53+'Cálculo Simplificado'!J55+'Cálculo Simplificado'!J57,0),0)","v":40187},{"$f":"IFERROR(H14*I$16/H$16,0)","v":32.710120627065393}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E11:E14),0)","v":0},100,null,{"$f":"ROUND(SUM(H11:H14),0)","v":122858},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(E11+E12+E13,0)","v":0},{"$f":"IFERROR(E40*F$16/E$16,0)","v":0},"A",{"$f":"ROUND(H11+H12+H13,0)","v":82671},{"$f":"IFERROR(H40*I$16/H$16,0)","v":67.289879372934607}]
[null,null,"Costes por distancia","B",{"$f":"ROUND(E14,0)","v":0},{"$f":"IFERROR(E41*F$16/E$16,0)","v":0},"B",{"$f":"ROUND(H14,0)","v":40187},{"$f":"IFERROR(H41*I$16/H$16,0)","v":32.710120627065393}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E40:E41),0)","v":0},100,null,{"$f":"ROUND(SUM(H40:H41),0)","v":122858},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(E43/'Cálculo Simplificado'!I11,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J11,0)","v":1.6381066666666666}]
[null,null,"Coste total medio (por hora)",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I21,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J21,0)","v":68.254444444444445}]
[null,null,"Coste total medio (por km. facturado)",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I13,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J13,0)","v":1.7243228070175438}]
[null,null,"Coste total medio (por hora facturada)",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I23,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J23,0)","v":75.004884004884005}]
[null,null,"Coste por distancia media (por km.)",null,{"$f":"IFERROR(E41/'Cálculo Simplificado'!I11,0)","v":0},null,null,{"$f":"IFERROR(H41/'Cálculo Simplificado'!J11,0)","v":0.53582666666666667}]
[null,null,"Coste por distancia media (por km. facturado)",null,{"$f":"IFERROR(E41/'Cálculo Simplificado'!I13,0)","v":0},null,null,{"$f":"IFERROR(H41/'Cálculo Simplificado'!J13,0)","v":0.56402807017543855}]
[null,null,"Coste por tiempo medio (por hora)",null,{"$f":"IFERROR(E40/'Cálculo Simplificado'!I21,0)","v":0},null,null,{"$f":"IFERROR(H40/'Cálculo Simplificado'!J21,0)","v":45.928333333333335}]
[null,null,"Coste por tiempo medio (por hora facturada)",null,{"$f":"IFERROR(E40/'Cálculo Simplificado'!I23,0)","v":0},null,null,{"$f":"IFERROR(H40/'Cálculo Simplificado'!J23,0)","v":50.470695970695971}]
[null,null,"Costes totales por persona-kilómetro",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I15/'Cálculo Simplificado'!I17,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J15/'Cálculo Simplificado'!J17,0)","v":0.16546531986531987}]

{"sheet":"Coste Servicio","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,5,10,8]]}
[]
[]
[]
[]
[]
[null,null,"1. 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,{"$f":"IFERROR(ROUND((F13*F17/100*'Cálculo Simplificado'!I47)+(F13*('Cálculo Simplificado'!I53+'Cálculo Simplificado'!I55)/'Cálculo Simplificado'!I11)+F23,2),0)","v":0}]
[]
[null,null,"Coste por tiempo de este servicio (€)",null,null,{"$f":"IFERROR(ROUND(F21*(Resultados!E11+Resultados!E12+Resultados!E13)/'Cálculo Simplificado'!I21,0),0)","v":0}]
[]
[null,null,"Otros costes asociados a este servicio (€)"]
[]
[null,null,"Coste total de este servicio (€)",null,null,{"$f":"IFERROR(ROUND(F25+F27+F29,2),0)","v":0}]
[]
[null,null,"Coste por persona-kilómetro de este servicio (€)",null,null,{"$f":"IFERROR(F31/F13/F19,0)","v":0}]