{"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":8,"macros":1,"external_links":0,"defined_names":10,"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":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Tipo de vehículo",null,"Pregunta",null,null,"Adquisicion",null,"Editar"]
["Vehículo articulado de carga general de larga distancia","T1","Si","S",null,"Compra"]
["Vehículo articulado de carga general de corta distancia","T2","No","N",null,"Alquiler, leasing…"]
["Portacontenedores de larga distancia","T3"]
["Portacontenedores de corta distancia","T4"]
["Volquete articulado de obra","T5"]
["Vehículo de 2 ejes de carga general","T6"]
["Vehículo articulado de mercancías peligrosas (químicas) de larga distancia","T7"]
["Vehículo articulado de productos derivados del petróleo (gasoil, gasolina, fueloil)","T8"]
["Vehículo cisterna de mercancías peligrosas (gases) de larga distancia","T9"]
["Vehículo frigorífico articulado","T10"]
["Vehículo frigorífico de 2 ejes","T11"]
["Volquete graneles de larga distancia","T12"]
["Volquete graneles de corta distancia","T13"]
["Camión ligero 3T distribución","T14"]
["Furgonetas","T15"]
["Vehículo genérico (para todos aquellos vehículos que no puedan ser englobados en las categorías anteriores)","T16"]

{"sheet":"DE","index":1,"n_rows":125,"n_cols":36,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"T1A","T1","T2A","T2","T3A","T3","T4A","T4","T5A","T5","T6A","T6","T7A","T7","T8A","T8","T9A","T9","T10A","T10","T11A","T11","T12A","T12","T13A","T13","T14A","T14","T15A","T15","T16A","T16"]
[null,"Descripción:",null," ","Vehículo articulado de carga general de larga distancia"," ","Vehículo articulado de carga general de corta distancia"," ","Portacontenedores de larga distancia"," ","Portacontenedores de corta distancia"," ","Volquete articulado de obra"," ","Vehículo de 2 ejes de carga general"," ","Vehículo articulado de mercancías peligrosas (químicas) de larga distancia"," ","Vehículo articulado de productos derivados del petróleo (gasoil, gasolina, fueloil)"," ","Vehículo cisterna de mercancías peligrosas (gases) de larga distancia"," ","Vehículo frigorífico articulado"," ","Vehículo frigorífico de 2 ejes"," ","Volquete graneles de larga distancia"," ","Volquete graneles de corta distancia"," ","Camión ligero 3T distribución"," ","Furgonetas"," ","Vehículo genérico (para todos aquellos vehículos que no puedan ser englobados en las categorías anteriores)","03/07/2025"]
[null,"Tipo interes",null,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453,null,0.0453]
[null,"Potencia",null,null,455.0,null,455.0,null,455.0,null,455.0,null,455.0,null,280.0,null,455.0,null,455.0,null,455.0,null,455.0,null,280.0,null,455.0,null,455.0,null,130.0,null,130.0,null,455.0]
[null,"MMA",null,null,40000.0,null,40000.0,null,44000.0,null,44000.0,null,40000.0,null,18000.0,null,40000.0,null,40000.0,null,40000.0,null,40000.0,null,18000.0,null,40000.0,null,40000.0,null,35000.0,null,3500.0,null,40000.0]
[null,"Carga útil",null,null,25000.0,null,25000.0,null,26250.0,null,26250.0,null,23000.0,null,9500.0,null,0.0,null,0.0,null,0.0,null,24000.0,null,9000.0,null,24000.0,null,24000.0,null,1500.0,null,1500.0,null,25000.0]
[null,"Número de ejes",null,null,5.0,null,5.0,null,6.0,null,6.0,null,4.0,null,2.0,null,5.0,null,5.0,null,5.0,null,5.0,null,2.0,null,5.0,null,5.0,null,2.0,null,2.0,null,5.0]
[null,"Número de neumáticos",null,null,12.0,null,12.0,null,14.0,null,14.0,null,14.0,null,6.0,null,12.0,null,12.0,null,12.0,null,12.0,null,6.0,null,12.0,null,12.0,null,4.0,null,4.0,null,12.0]
[null,"Kilómetros recorridos anualmente",null,null,150000.0,null,120000.0,null,100000.0,null,100000.0,null,60000.0,null,90000.0,null,105000.0,null,100000.0,null,100000.0,null,120000.0,null,70000.0,null,120000.0,null,120000.0,null,50000.0,null,50000.0,null,120000.0]
[null,"Kilómetros recorridos anualmente en carga (%, km)",null,90.0,{"$f":"E9*D10/100","v":135000.0},85.0,{"$f":"G9*F10/100","v":102000.0},85.0,{"$f":"I9*H10/100","v":85000.0},85.0,85000.0,50.0,{"$f":"M9*L10/100","v":30000.0},80.0,{"$f":"O9*N10/100","v":72000.0},75.0,{"$f":"Q9*P10/100","v":78750.0},50.0,{"$f":"S9*R10/100","v":50000.0},50.0,50000.0,80.0,{"$f":"W9*V10/100","v":96000.0},75.0,{"$f":"Y9*X10/100","v":52500.0},80.0,{"$f":"AA9*Z10/100","v":96000.0},80.0,96000.0,75.0,{"$f":"AE9*AD10/100","v":37500.0},75.0,{"$f":"AG9*AF10/100","v":37500.0},85.0,{"$f":"AI9*AH10/100","v":102000.0}]
[null,"Kilómetros recorridos anualmente en vacío (%, km)",null,10.0,{"$f":"E9*D11/100","v":15000.0},15.0,{"$f":"G9*F11/100","v":18000.0},15.0,{"$f":"I9*H11/100","v":15000.0},15.0,{"$f":"K9*J11/100","v":15000.0},50.0,{"$f":"M9*L11/100","v":30000.0},20.0,{"$f":"O9*N11/100","v":18000.0},25.0,{"$f":"Q9*P11/100","v":26250.0},50.0,{"$f":"S9*R11/100","v":50000.0},50.0,{"$f":"U9*T11/100","v":50000.0},20.0,{"$f":"W9*V11/100","v":24000.0},25.0,{"$f":"Y9*X11/100","v":17500.0},20.0,{"$f":"AA9*Z11/100","v":24000.0},20.0,{"$f":"AC9*AB11/100","v":24000.0},25.0,{"$f":"AE9*AD11/100","v":12500.0},25.0,{"$f":"AG9*AF11/100","v":12500.0},15.0,{"$f":"AI9*AH11/100","v":18000.0}]
[null,"Consumo medio (litros/100km)",null,null,35.0,null,35.0,null,35.0,null,35.0,null,38.5,null,25.0,null,34.5,null,34.5,null,34.5,null,35.0,null,25.0,null,35.0,null,35.0,null,11.5,null,11.5,null,35.0]
[null,"Horas trabajadas al año",null,null,2000.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0,null,1800.0]
[null,"Horas trabajadas al año en carga (%, h)",null,90.0,{"$f":"E13*D14/100","v":1800.0},85.0,{"$f":"G13*F14/100","v":1530.0},85.0,{"$f":"I13*H14/100","v":1530.0},85.0,1530.0,50.0,{"$f":"M13*L14/100","v":900.0},80.0,{"$f":"O13*N14/100","v":1440.0},75.0,{"$f":"Q13*P14/100","v":1350.0},50.0,{"$f":"S13*R14/100","v":900.0},50.0,900.0,80.0,{"$f":"W13*V14/100","v":1440.0},75.0,{"$f":"Y13*X14/100","v":1350.0},80.0,{"$f":"AA13*Z14/100","v":1440.0},80.0,1440.0,75.0,{"$f":"AE13*AD14/100","v":1350.0},75.0,{"$f":"AG13*AF14/100","v":1350.0},85.0,{"$f":"AI13*AH14/100","v":1530.0}]
[null,"Horas trabajadas al año en vacío (%, h)",null,10.0,{"$f":"E13*D15/100","v":200.0},15.0,{"$f":"G13*F15/100","v":270.0},15.0,{"$f":"I13*H15/100","v":270.0},15.0,{"$f":"K13*J15/100","v":270.0},50.0,{"$f":"M13*L15/100","v":900.0},20.0,{"$f":"O13*N15/100","v":360.0},25.0,{"$f":"Q13*P15/100","v":450.0},50.0,{"$f":"S13*R15/100","v":900.0},50.0,{"$f":"U13*T15/100","v":900.0},20.0,{"$f":"W13*V15/100","v":360.0},25.0,{"$f":"Y13*X15/100","v":450.0},20.0,{"$f":"AA13*Z15/100","v":360.0},20.0,{"$f":"AC13*AB15/100","v":360.0},25.0,{"$f":"AE13*AD15/100","v":450.0},25.0,{"$f":"AG13*AF15/100","v":450.0},15.0,{"$f":"AI13*AH15/100","v":270.0}]
[null,"Días trabajados al año",null,null,250.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0,null,225.0]
[null,"Horas trabajadas por jornada",null,null,{"$f":"E13/E16","v":8.0},null,{"$f":"G13/G16","v":8.0},null,{"$f":"I13/I16","v":8.0},null,8.0,null,{"$f":"M13/M16","v":8.0},null,{"$f":"O13/O16","v":8.0},null,{"$f":"Q13/Q16","v":8.0},null,{"$f":"S13/S16","v":8.0},null,8.0,null,{"$f":"W13/W16","v":8.0},null,{"$f":"Y13/Y16","v":8.0},null,{"$f":"AA13/AA16","v":8.0},null,8.0,null,{"$f":"AE13/AE16","v":8.0},null,{"$f":"AG13/AG16","v":8.0},null,{"$f":"AI13/AI16","v":8.0}]
[null,"Pago de leasing o renta anual (€)",null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,129778.36,null,129778.36,null,129778.36,null,129778.36,null,129778.36,null,80249.76,null,129778.36,null,129778.36,null,129778.36,null,129778.36,null,80249.76,null,129778.36,null,129778.36,null,27162.55,null,27162.55,null,129778.36]
[null,"Descuento sobre tarifa (%)",null,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0,null,10.0]
[null,"Precio de adquisición sin IVA (€)",null,null,{"$f":"ROUND((1-E20/100)*E19,0)","v":116801.0},null,{"$f":"(1-G20/100)*G19","v":116801.0},null,{"$f":"(1-I20/100)*I19","v":116801.0},null,116801.0,null,{"$f":"(1-M20/100)*M19","v":116801.0},null,{"$f":"(1-O20/100)*O19","v":72225.0},null,{"$f":"(1-Q20/100)*Q19","v":116801.0},null,{"$f":"(1-S20/100)*S19","v":116801.0},null,116801.0,null,{"$f":"(1-W20/100)*W19","v":116801.0},null,{"$f":"(1-Y20/100)*Y19","v":72225.0},null,{"$f":"(1-AA20/100)*AA19","v":116801.0},null,116801.0,null,{"$f":"(1-AE20/100)*AE19","v":24446.0},null,{"$f":"(1-AG20/100)*AG19","v":24446.0},null,{"$f":"(1-AI20/100)*AI19","v":116801.0}]
[null,"Vida útil (años)",null,null,5.0,null,6.0,null,8.0,null,8.0,null,8.0,null,10.0,null,6.0,null,6.0,null,6.0,null,6.0,null,10.0,null,6.0,null,6.0,null,8.0,null,8.0,null,6.0]
[null,"Valor residual sobre precio de tarifa (%)",null,15.0,{"$f":"ROUND(E19*D23/100,0)","v":19467.0},20.0,{"$f":"G19*F23/100","v":25956.0},20.0,{"$f":"I19*H23/100","v":25956.0},20.0,{"$f":"K19*J23/100","v":25956.0},20.0,{"$f":"M19*L23/100","v":25956.0},10.0,{"$f":"O19*N23/100","v":8025.0},20.0,{"$f":"Q19*P23/100","v":25956.0},20.0,{"$f":"S19*R23/100","v":25956.0},20.0,{"$f":"U19*T23/100","v":25956.0},20.0,{"$f":"W19*V23/100","v":25956.0},10.0,{"$f":"Y19*X23/100","v":8025.0},20.0,{"$f":"AA19*Z23/100","v":25956.0},20.0,{"$f":"AC19*AB23/100","v":25956.0},15.0,{"$f":"AE19*AD23/100","v":4074.0},15.0,{"$f":"AG19*AF23/100","v":4074.0},20.0,{"$f":"AI19*AH23/100","v":25956.0}]
[null,"AMORTIZACIÓN DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E102)/E22,0),0)","v":17742.0},null,{"$f":"IFERROR(ROUND((G21-G23-G102)/G22,0),0)","v":13991.0},null,{"$f":"IFERROR(ROUND((I21-I23-I102)/I22,0),0)","v":10517.0},null,{"$f":"IFERROR(ROUND((K21-K23-K102)/K22,0),0)","v":10517.0},null,{"$f":"IFERROR(ROUND((M21-M23-M102)/M22,0),0)","v":9846.0},null,{"$f":"IFERROR(ROUND((O21-O23-O102)/O22,0),0)","v":6091.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q102)/Q22,0),0)","v":14134.0},null,{"$f":"IFERROR(ROUND((S21-S23-S102)/S22,0),0)","v":14182.0},null,{"$f":"IFERROR(ROUND((U21-U23-U102)/U22,0),0)","v":14182.0},null,{"$f":"IFERROR(ROUND((W21-W23-W102)/W22,0),0)","v":13991.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y102)/Y22,0),0)","v":6164.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA102)/AA22,0),0)","v":13991.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC102)/AC22,0),0)","v":13991.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE102)/AE22,0),0)","v":2459.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG102)/AG22,0),0)","v":2459.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI102)/AI22,0),0)","v":13991.0}]
[null,"GASTOS FINANCIEROS DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E102)*(E$3/(1-POWER(1+E$3,-E22))-1/E22),0),0)","v":2482.0},null,{"$f":"IFERROR(ROUND((G21-G23-G102)*(G$3/(1-POWER(1+G$3,-G22))-1/G22),0),0)","v":2300.0},null,{"$f":"IFERROR(ROUND((I21-I23-I102)*(I$3/(1-POWER(1+I$3,-I22))-1/I22),0),0)","v":2254.0},null,{"$f":"IFERROR(ROUND((K21-K23-K102)*(K$3/(1-POWER(1+K$3,-K22))-1/K22),0),0)","v":2254.0},null,{"$f":"IFERROR(ROUND((M21-M23-M90*M94-M91*M95-M92*M96)*(M$3/(1-POWER(1+M$3,-M22))-1/M22),0),0)","v":2111.0},null,{"$f":"IFERROR(ROUND((O21-O23-O102)*(O$3/(1-POWER(1+O$3,-O22))-1/O22),0),0)","v":1618.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q102)*(Q$3/(1-POWER(1+Q$3,-Q22))-1/Q22),0),0)","v":2324.0},null,{"$f":"IFERROR(ROUND((S21-S23-S90*S102)*(S$3/(1-POWER(1+S$3,-S22))-1/S22),0),0)","v":2332.0},null,{"$f":"IFERROR(ROUND((U21-U23-U102)*(U$3/(1-POWER(1+U$3,-U22))-1/U22),0),0)","v":2332.0},null,{"$f":"IFERROR(ROUND((W21-W23-W102)*(W$3/(1-POWER(1+W$3,-W22))-1/W22),0),0)","v":2300.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y102)*(Y$3/(1-POWER(1+Y$3,-Y22))-1/Y22),0),0)","v":1637.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA102)*(AA$3/(1-POWER(1+AA$3,-AA22))-1/AA22),0),0)","v":2300.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC102)*(AC$3/(1-POWER(1+AC$3,-AC22))-1/AC22),0),0)","v":2300.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE102)*(AE$3/(1-POWER(1+AE$3,-AE22))-1/AE22),0),0)","v":527.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG90*AG102)*(AG$3/(1-POWER(1+AG$3,-AG22))-1/AG22),0),0)","v":527.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI90*AI102)*(AI$3/(1-POWER(1+AI$3,-AI22))-1/AI22),0),0)","v":2300.0}]
[null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,null,null,null,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,8705.35,null,null,null,null,null,null,null,null,null,44519.11,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,5.0,null,null,null,null,null,null,null,null,null,5.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de adquisición sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((1-O28/100)*O27,0)","v":8270.0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND((1-Y28/100)*Y27,0)","v":42293.0},null,null,null,null,null,null,null,null,null,0.0]
[null,"Vida útil (años)",null,null,null,null,null,null,null,null,null,null,null,null,10.0,null,null,null,null,null,null,null,null,null,10.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,10.0,{"$f":"ROUND(O27*N31/100,0)","v":871.0},null,null,null,null,null,null,null,null,10.0,{"$f":"ROUND(Y27*X31/100,0)","v":4452.0},null,null,null,null,null,null,null,null,0.0,0.0]
[null,"AMORTIZACION CARROZADO",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((O29-O31)/O30,0),0)","v":740.0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((Y29-Y31)/Y30,0),0)","v":3784.0},null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTOS FINANCIEROS CARROZADO",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((O29-O31)*(O$3/(1-POWER(1+O$3,-O30))-1/O30),0),0)","v":196.56},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((Y29-Y31)*(Y$3/(1-POWER(1+Y$3,-Y30))-1/Y30),0),0)","v":1005.26},null,null,null,null,null,null,null,null,null,0.0]
[null,"Pago de leasing o renta anual (€)",null,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,0.0,null,0.0,null,null,null,0.0,null,0.0,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,40351.63,null,40351.63,null,31645.67,null,31645.67,null,35822.42,null,null,null,99364.18,null,99364.18,null,99364.18,null,69541.85,null,null,null,43628.72,null,43628.72,null,null,null,null,null,40351.63]
[null,"Descuento sobre tarifa (%)",null,null,5.0,null,5.0,null,5.0,null,5.0,null,5.0,null,null,null,5.0,null,5.0,null,5.0,null,5.0,null,null,null,5.0,null,5.0,null,null,null,null,null,5.0]
[null,"Precio de adquisición sin IVA (€)",null,null,{"$f":"ROUND((1-E36/100)*E35,0)","v":38334.0},null,{"$f":"ROUND((1-G36/100)*G35,0)","v":38334.0},null,{"$f":"ROUND((1-I36/100)*I35,0)","v":30063.0},null,{"$f":"ROUND((1-K36/100)*K35,0)","v":30063.0},null,{"$f":"ROUND((1-M36/100)*M35,0)","v":34031.0},null,null,null,{"$f":"ROUND((1-Q36/100)*Q35,0)","v":94396.0},null,{"$f":"ROUND((1-S36/100)*S35,0)","v":94396.0},null,{"$f":"ROUND((1-U36/100)*U35,0)","v":94396.0},null,{"$f":"ROUND((1-W36/100)*W35,0)","v":66065.0},null,null,null,{"$f":"ROUND((1-AA36/100)*AA35,0)","v":41447.0},null,{"$f":"ROUND((1-AC36/100)*AC35,0)","v":41447.0},null,null,null,null,null,{"$f":"ROUND((1-AI36/100)*AI35,0)","v":38334.0}]
[null,"Vida útil (años)",null,null,7.0,null,8.0,null,12.0,null,12.0,null,12.0,null,null,null,8.0,null,10.0,null,10.0,null,10.0,null,null,null,10.0,null,10.0,null,null,null,null,null,8.0]
[null,"Valor residual sobre precio de tarifa (%)",null,10.0,{"$f":"ROUND(E35*D39/100,0)","v":4035.0},15.0,{"$f":"ROUND(G35*F39/100,0)","v":6053.0},15.0,{"$f":"ROUND(I35*H39/100,0)","v":4747.0},15.0,{"$f":"ROUND(K35*J39/100,0)","v":4747.0},15.0,{"$f":"ROUND(M35*L39/100,0)","v":5373.0},null,null,20.0,{"$f":"ROUND(Q35*P39/100,0)","v":19873.0},15.0,{"$f":"ROUND(S35*R39/100,0)","v":14905.0},15.0,{"$f":"ROUND(U35*T39/100,0)","v":14905.0},15.0,{"$f":"ROUND(W35*V39/100,0)","v":10431.0},null,null,10.0,{"$f":"ROUND(AA35*Z39/100,0)","v":4363.0},10.0,{"$f":"ROUND(AC35*AB39/100,0)","v":4363.0},null,null,null,null,15.0,{"$f":"ROUND(AI35*AH39/100,0)","v":6053.0}]
[null,"AMORTIZACIÓN REMOLQUE",null,null,{"$f":"IFERROR(ROUND((E37-E39-E93*E97)/E38,0),0)","v":4284.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)/G38,0),0)","v":3496.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)/I38,0),0)","v":1750.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)/K38,0),0)","v":1750.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)/M38,0),0)","v":1909.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)/Q38,0),0)","v":8776.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)/S38,0),0)","v":7518.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)/U38,0),0)","v":7518.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)/W38,0),0)","v":5132.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)/AA38,0),0)","v":3277.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)/AC38,0),0)","v":3277.0},null,null,null,null,null,{"$f":"IFERROR(ROUND((AI37-AI39-AI93*AI97)/AI38,0),0)","v":3496.0}]
[null,"GASTOS FINANCIEROS REMOLQUE",null,null,{"$f":"IFERROR(ROUND((E37-E39-E93*E97)*(E$3/(1-POWER(1+E$3,-E38))-1/E38),0),0)","v":811.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)*(G$3/(1-POWER(1+G$3,-G38))-1/G38),0),0)","v":749.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)*(I$3/(1-POWER(1+I$3,-I38))-1/I38),0),0)","v":557.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)*(K$3/(1-POWER(1+K$3,-K38))-1/K38),0),0)","v":557.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)*(M$3/(1-POWER(1+M$3,-M38))-1/M38),0),0)","v":608.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)*(Q$3/(1-POWER(1+Q$3,-Q38))-1/Q38),0),0)","v":1881.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)*(S$3/(1-POWER(1+S$3,-S38))-1/S38),0),0)","v":1997.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)*(U$3/(1-POWER(1+U$3,-U38))-1/U38),0),0)","v":1997.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)*(W$3/(1-POWER(1+W$3,-W38))-1/W38),0),0)","v":1363.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)*(AA$3/(1-POWER(1+AA$3,-AA38))-1/AA38),0),0)","v":871.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)*(AC$3/(1-POWER(1+AC$3,-AC38))-1/AC38),0),0)","v":871.0},null,null,null,null,null,{"$f":"IFERROR(ROUND((AI37-AI39-AI93*AI97)*(AI$3/(1-POWER(1+AI$3,-AI38))-1/AI38),0),0)","v":749.0}]
[null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio de adquisición sin IVA (€)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Vida útil (años)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,0.0,0.0,0.0,null,null,null,null,null,null,null,null,0.0,0.0]
[null,"AMORTIZACION EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTOS FINANCIEROS EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"COSTES DE ADQUISICION",null,null,{"$f":"E24+E25+E32+E33+E40+E41+E48+E49","v":25319.0},null,{"$f":"G24+G25+G32+G33+G40+G41+G48+G49","v":20536.0},null,{"$f":"I24+I25+I32+I33+I40+I41+I48+I49","v":15078.0},null,15078.0,null,{"$f":"M24+M25+M32+M33+M40+M41+M48+M49","v":14474.0},null,{"$f":"O24+O25+O32+O33+O40+O41+O48+O49","v":8645.56},null,{"$f":"Q24+Q25+Q32+Q33+Q40+Q41+Q48+Q49","v":27115.0},null,{"$f":"S24+S25+S32+S33+S40+S41+S48+S49","v":26029.0},null,26029.0,null,{"$f":"W24+W25+W32+W33+W40+W41+W48+W49","v":22786.0},null,{"$f":"Y24+Y25+Y32+Y33+Y40+Y41+Y48+Y49","v":12590.26},null,{"$f":"AA24+AA25+AA32+AA33+AA40+AA41+AA48+AA49","v":20439.0},null,20439.0,null,{"$f":"AE24+AE25+AE32+AE33+AE40+AE41+AE48+AE49","v":2986.0},null,{"$f":"AG24+AG25+AG32+AG33+AG40+AG41+AG48+AG49","v":2986.0},null,{"$f":"AI24+AI25+AI32+AI33+AI40+AI41+AI48+AI49","v":20536.0}]
[null,"Coste total anual del conductor, incluidos costes de empresa (Seg. Soc. y otros) €",null,null,39569.84,null,35648.51,null,35648.51,null,35648.51,null,35648.51,null,35648.51,null,39213.35,null,39213.35,null,39213.35,null,35648.51,null,35648.51,null,35648.51,null,35648.51,null,32083.65,null,32083.65,null,35648.51]
[null,"Dieta total diaria del conductor (€/día)",null,null,88.5,null,39.44,null,39.44,null,39.44,null,17.93,null,35.85,null,39.44,null,39.44,null,39.44,null,39.44,null,35.85,null,35.85,null,35.85,null,17.93,null,17.93,null,39.44]
[null,"Número de días con dieta al año",null,null,250.0,null,225.0,null,200.0,null,200.0,null,180.0,null,133.0,null,200.0,null,200.0,null,200.0,null,225.0,null,75.0,null,200.0,null,200.0,null,150.0,null,150.0,null,225.0]
[null,"Dietas totales anuales (€)",null,null,{"$f":"E52*E53","v":22125.0},null,{"$f":"G52*G53","v":8874.0},null,{"$f":"I52*I53","v":7888.0},null,7888.0,null,{"$f":"M52*M53","v":3227.0},null,{"$f":"O52*O53","v":4768.0},null,{"$f":"Q52*Q53","v":7888.0},null,{"$f":"S52*S53","v":7888.0},null,7888.0,null,{"$f":"W52*W53","v":8874.0},null,{"$f":"Y52*Y53","v":2689.0},null,{"$f":"AA52*AA53","v":7170.0},null,7170.0,null,{"$f":"AE52*AE53","v":2690.0},null,{"$f":"AG52*AG53","v":2690.0},null,{"$f":"AI52*AI53","v":8874.0}]
[null,"Plus anual de actividad del conductor (€/km)",null,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0965,null,0.0965,null,0.0965,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0673,null,0.0673]
[null,"Plus anual de actividad del conductor (€)",null,null,{"$f":"E55*E9","v":10095.0},null,{"$f":"G55*G9","v":8076.0},null,{"$f":"I55*I9","v":6730.0},null,6730.0,null,{"$f":"M55*M9","v":4038.0},null,{"$f":"O55*O9","v":6057.0},null,{"$f":"Q55*Q9","v":10133.0},null,{"$f":"S55*S9","v":9650.0},null,9650.0,null,{"$f":"W55*W9","v":8076.0},null,{"$f":"Y55*Y9","v":4711.0},null,{"$f":"AA55*AA9","v":8076.0},null,8076.0,null,{"$f":"AE55*AE9","v":3365.0},null,{"$f":"AG55*AG9","v":3365.0},null,{"$f":"AI55*AI9","v":8076.0}]
[null,"COSTES DE PERSONAL",null,null,{"$f":"E51+E54+E56","v":71789.84},null,{"$f":"G51+G54+G56","v":52598.51},null,{"$f":"I51+I54+I56","v":50266.51},null,50266.51,null,{"$f":"M51+M54+M56","v":42913.51},null,{"$f":"O51+O54+O56","v":46473.51},null,{"$f":"Q51+Q54+Q56","v":57234.35},null,{"$f":"S51+S54+S56","v":56751.35},null,56751.35,null,{"$f":"W51+W54+W56","v":52598.51},null,{"$f":"Y51+Y54+Y56","v":43048.51},null,{"$f":"AA51+AA54+AA56","v":50894.51},null,50894.51,null,{"$f":"AE51+AE54+AE56","v":38138.65},null,{"$f":"AG51+AG54+AG56","v":38138.65},null,{"$f":"AI51+AI54+AI56","v":52598.51}]
[null,"Responsabilidad civil del vehículo de tracción (€)",null,null,1866.55,null,1866.55,null,1866.55,null,1866.55,null,1866.55,null,1934.74,null,1866.55,null,1866.55,null,1866.55,null,1866.55,null,1934.74,null,1866.55,null,1866.55,null,1306.87,null,1306.87,null,1866.55]
[null,"Responsabilidad civil del remolque o semirremolque (€)",null,null,588.86,null,588.86,null,588.86,null,588.86,null,588.86,null,null,null,588.86,null,588.86,null,588.86,null,588.86,null,null,null,588.86,null,588.86,null,null,null,null,null,588.86]
[null,"Responsabilidad civil de la mercancía (€)",null,null,139.91,null,139.91,null,139.91,null,139.91,null,139.91,null,139.91,null,738.46,null,1170.13,null,1170.13,null,163.46,null,139.91,null,139.91,null,139.91,null,null,null,null,null,139.91]
[null,"Seguro de accidentes de personal de a bordo (€)",null,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94,null,64.94]
[null,"Retirada del carné de conducir (€)",null,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65,null,161.65]
[null,"Seguro de la mercancía (€)",null,null,792.0,null,792.0,null,430.47,null,430.47,null,0.0,null,472.82,null,792.0,null,792.0,null,792.0,null,1142.14,null,967.0,null,395.18,null,395.18,null,289.36,null,289.36,null,792.0]
[null,"Daños propios (seguro todo riesgo) (€)",null,null,3488.62,null,3488.62,null,3488.62,null,3488.62,null,3678.67,null,1955.4,null,4191.22,null,4191.22,null,4191.22,null,4544.0,null,1955.4,null,3488.62,null,3488.62,null,2190.53,null,2190.53,null,3488.62]
[null,"Otros seguros (€)",null,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,559.05,null,265.42,null,265.42,null,559.05]
[null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,{"$f":"SUM(E58:E65)","v":7661.58},null,{"$f":"SUM(G58:G65)","v":7661.58},null,{"$f":"SUM(I58:I65)","v":7300.05},null,7300.05,null,{"$f":"SUM(M58:M65)","v":7059.63},null,{"$f":"SUM(O58:O65)","v":5288.51},null,{"$f":"SUM(Q58:Q65)","v":8962.73},null,{"$f":"SUM(S58:S65)","v":9394.4},null,9394.4,null,{"$f":"SUM(W58:W65)","v":9090.65},null,{"$f":"SUM(Y58:Y65)","v":5782.69},null,{"$f":"SUM(AA58:AA65)","v":7264.76},null,7264.76,null,{"$f":"SUM(AE58:AE65)","v":4278.77},null,4278.77,null,{"$f":"SUM(AI58:AI65)","v":7661.58}]
[null,"Visados",null,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,17.21,null,16.52,null,16.52,null,17.21]
[null,"Inspección técnica de vehículos (I.T.V.) (€)",null,null,117.92,null,117.92,null,117.92,null,117.92,null,117.92,null,71.74,null,117.92,null,117.92,null,117.92,null,117.92,null,71.74,null,117.92,null,117.92,null,54.19,null,54.19,null,117.92]
[null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo (€)",null,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,373.05,null,305.78,null,305.78,null,373.05]
[null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.) (€)",null,null,321.16,null,321.16,null,321.16,null,321.16,null,321.16,null,228.7,null,321.16,null,321.16,null,321.16,null,321.16,null,228.7,null,321.16,null,321.16,null,160.58,null,160.58,null,321.16]
[null,"Revisión tacógrafo (€)",null,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,86.75,null,0.0,null,null,null,86.75]
[null,"Inspecciones A.T.P. (transporte mercancías perecederas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79.87,null,79.87,null,null,null,null,null,null,null,null,null,0.0]
[null,"Inspecciones A.D.R. (transporte mercancías peligrosas)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,137.69,null,729.78,null,729.78,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,"Otros costes fiscales (€)",null,null,30.29,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0,null,0.0]
[null,"COSTE FISCAL TOTAL ANUAL",null,null,{"$f":"SUM(E67:E74)","v":946.38},null,{"$f":"SUM(G67:G74)","v":916.09},null,{"$f":"SUM(I67:I74)","v":916.09},null,916.09,null,{"$f":"SUM(M67:M74)","v":916.09},null,{"$f":"SUM(O67:O74)","v":777.45},null,{"$f":"SUM(Q67:Q74)","v":1053.78},null,{"$f":"SUM(S67:S74)","v":1645.87},null,1645.87,null,{"$f":"SUM(W67:W74)","v":995.96},null,{"$f":"SUM(Y67:Y74)","v":857.32},null,{"$f":"SUM(AA67:AA74)","v":916.09},null,916.09,null,{"$f":"SUM(AE67:AE74)","v":537.07},null,{"$f":"SUM(AG67:AG74)","v":537.07},null,{"$f":"SUM(AI67:AI74)","v":916.09}]
[null,"SEGUROS Y COSTES FISCALES",null,null,{"$f":"E66+E75","v":8607.96},null,{"$f":"G66+G75","v":8577.67},null,{"$f":"I66+I75","v":8216.14},null,8216.14,null,{"$f":"M66+M75","v":7975.72},null,{"$f":"O66+O75","v":6065.96},null,{"$f":"Q66+Q75","v":10016.51},null,{"$f":"S66+S75","v":11040.27},null,11040.27,null,{"$f":"W66+W75","v":10086.61},null,{"$f":"Y66+Y75","v":6640.01},null,{"$f":"AA66+AA75","v":8180.85},null,8180.85,null,{"$f":"AE66+AE75","v":4815.84},null,{"$f":"AG66+AG75","v":4815.84},null,{"$f":"AI66+AI75","v":8577.67}]
[null,"Precio del carburante, con IVA (€/litro)",null,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871,null,1.4871]
[null,"Descuento (€/litro)",null,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.1171,null,0.0681,null,0.0681,null,0.1171]
[null,"IVA aplicado al carburante (%)(€/litro)",null,21.0,{"$f":"ROUND((D79/100)*(E77-E78)/(1+D79/100),4)","v":0.2378},21.0,{"$f":"ROUND((F79/100)*(G77-G78)/(1+F79/100),4)","v":0.2378},21.0,{"$f":"ROUND((H79/100)*(I77-I78)/(1+H79/100),4)","v":0.2378},21.0,{"$f":"ROUND((J79/100)*(K77-K78)/(1+J79/100),4)","v":0.2378},21.0,{"$f":"ROUND((L79/100)*(M77-M78)/(1+L79/100),4)","v":0.2378},21.0,{"$f":"ROUND((N79/100)*(O77-O78)/(1+N79/100),4)","v":0.2378},21.0,{"$f":"ROUND((P79/100)*(Q77-Q78)/(1+P79/100),4)","v":0.2378},21.0,{"$f":"ROUND((R79/100)*(S77-S78)/(1+R79/100),4)","v":0.2378},21.0,{"$f":"ROUND((T79/100)*(U77-U78)/(1+T79/100),4)","v":0.2378},21.0,{"$f":"ROUND((V79/100)*(W77-W78)/(1+V79/100),4)","v":0.2378},21.0,{"$f":"ROUND((X79/100)*(Y77-Y78)/(1+X79/100),4)","v":0.2378},21.0,{"$f":"ROUND((Z79/100)*(AA77-AA78)/(1+Z79/100),4)","v":0.2378},21.0,{"$f":"ROUND((AB79/100)*(AC77-AC78)/(1+AB79/100),4)","v":0.2378},21.0,{"$f":"ROUND((AD79/100)*(AE77-AE78)/(1+AD79/100),4)","v":0.2463},21.0,{"$f":"ROUND((AF79/100)*(AG77-AG78)/(1+AF79/100),4)","v":0.2463},21.0,{"$f":"ROUND((AH79/100)*(AI77-AI78)/(1+AH79/100),4)","v":0.2378}]
[null,"Precio carburante sin IVA (€/litro)",null,null,{"$f":"ROUND((E77-E78)/(1+D79/100),4)","v":1.1322},null,{"$f":"ROUND((G77-G78)/(1+F79/100),4)","v":1.1322},null,{"$f":"ROUND((I77-I78)/(1+H79/100),4)","v":1.1322},null,{"$f":"ROUND((K77-K78)/(1+J79/100),4)","v":1.1322},null,{"$f":"ROUND((M77-M78)/(1+L79/100),4)","v":1.1322},null,{"$f":"ROUND((O77-O78)/(1+N79/100),4)","v":1.1322},null,{"$f":"ROUND((Q77-Q78)/(1+P79/100),4)","v":1.1322},null,{"$f":"ROUND((S77-S78)/(1+R79/100),4)","v":1.1322},null,{"$f":"ROUND((U77-U78)/(1+T79/100),4)","v":1.1322},null,{"$f":"ROUND((W77-W78)/(1+V79/100),4)","v":1.1322},null,{"$f":"ROUND((Y77-Y78)/(1+X79/100),4)","v":1.1322},null,{"$f":"ROUND((AA77-AA78)/(1+Z79/100),4)","v":1.1322},null,{"$f":"ROUND((AC77-AC78)/(1+AB79/100),4)","v":1.1322},null,{"$f":"ROUND((AE77-AE78)/(1+AD79/100),4)","v":1.1727},null,{"$f":"ROUND((AG77-AG78)/(1+AF79/100),4)","v":1.1727},null,{"$f":"ROUND((AI77-AI78)/(1+AH79/100),4)","v":1.1322}]
[null,"GASTO TOTAL ANUAL EN CARBURANTE DEL VEHÍCULO (€, SIN IVA)",null,null,{"$f":"ROUND(E9/100*E12*E80,0)","v":59441.0},null,{"$f":"ROUND(G9/100*G12*G80,0)","v":47552.0},null,{"$f":"ROUND(I9/100*I12*I80,0)","v":39627.0},null,{"$f":"ROUND(K9/100*K12*K80,0)","v":39627.0},null,{"$f":"ROUND(M9/100*M12*M80,0)","v":26154.0},null,{"$f":"ROUND(O9/100*O12*O80,0)","v":25475.0},null,{"$f":"ROUND(Q9/100*Q12*Q80,0)","v":41014.0},null,{"$f":"ROUND(S9/100*S12*S80,0)","v":39061.0},null,{"$f":"ROUND(U9/100*U12*U80,0)","v":39061.0},null,{"$f":"ROUND(W9/100*W12*W80,0)","v":47552.0},null,{"$f":"ROUND(Y9/100*Y12*Y80,0)","v":19814.0},null,{"$f":"ROUND(AA9/100*AA12*AA80,0)","v":47552.0},null,{"$f":"ROUND(AC9/100*AC12*AC80,0)","v":47552.0},null,{"$f":"ROUND(AE9/100*AE12*AE80,0)","v":6743.0},null,{"$f":"ROUND(AG9/100*AG12*AG80,0)","v":6743.0},null,{"$f":"ROUND(AI9/100*AI12*AI80,0)","v":47552.0}]
[null,"Precio de compra de carburante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0654,null,1.0654,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0,null,0.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"IVA aplicado al carburante (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.0,null,21.0,null,null,null,null,null,null,null,null,null,21.0]
[null,"IVA aplicado al carburante (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W84/100)*(W82-W83)/(1+W84/100)","v":0.18},null,{"$f":"(Y84/100)*(Y82-Y83)/(1+Y84/100)","v":0.18},null,null,null,null,null,null,null,null,null,0.0]
[null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(W82-W83)/(1+W84/100)","v":0.8805},null,{"$f":"(Y82-Y83)/(1+Y84/100)","v":0.8805},null,null,null,null,null,null,null,null,null,0.0]
[null,"Consumo medio de los equipos (litros/hora)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0,null,3.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"Horas anuales de utilización de los equipos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000.0,null,2000.0,null,null,null,null,null,null,null,null,null,0.0]
[null,"GASTO TOTAL ANUAL EN CARBURANTE EQUIPOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W86*W87*W88","v":7044.0},null,{"$f":"Y86*Y87*Y88","v":5283.0},null,null,null,null,null,null,null,null,null,0.0]
[null,"Número de neumáticos direccionables",null,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0,null,2.0]
[null,"Número de neumáticos motrices",null,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,4.0,null,2.0,null,2.0,null,4.0]
[null,"Número de neumáticos arrastre",null,null,null,null,null,null,2.0,null,2.0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,"Número de neumáticos semirremolque o remolque",null,null,6.0,null,6.0,null,6.0,null,6.0,null,8.0,null,null,null,6.0,null,6.0,null,6.0,null,6.0,null,null,null,6.0,null,6.0,null,null,null,null,null,6.0]
[null,"Precio sin IVA de un neumático direccionable (€)",null,null,718.84,null,718.84,null,718.84,null,718.84,null,718.84,null,762.17,null,718.84,null,718.84,null,718.84,null,718.84,null,762.17,null,718.84,null,718.84,null,209.22,null,209.22,null,718.84]
[null,"Precio sin IVA de un neumático motriz (€)",null,null,718.84,null,718.84,null,718.84,null,718.84,null,718.84,null,762.17,null,718.84,null,718.84,null,718.84,null,718.84,null,762.17,null,718.84,null,718.84,null,209.22,null,209.22,null,718.84]
[null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,718.84,null,718.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,718.84]
[null,"Precio sin IVA de un neumático remolque-semirremolque (€)",null,null,718.84,null,718.84,null,718.84,null,718.84,null,718.84,null,null,null,718.84,null,718.84,null,718.84,null,718.84,null,null,null,718.84,null,718.84,null,null,null,null,null,718.84]
[null,"Duración media de un neumático direccionable (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,125000.0,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,125000.0,null,150000.0,null,150000.0,null,60000.0,null,60000.0,null,150000.0]
[null,"Duración media de un neumático motriz (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,125000.0,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,125000.0,null,150000.0,null,150000.0,null,60000.0,null,60000.0,null,150000.0]
[null,"Duración media de un neumático arrastre (km)",null,null,null,null,null,null,150000.0,null,150000.0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150000.0]
[null,"Duración media de un neumático remolque-semirremolque (km)",null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,50000.0,null,null,null,150000.0,null,150000.0,null,150000.0,null,150000.0,null,null,null,150000.0,null,150000.0,null,null,null,null,null,150000.0]
[null,"GASTO TOTAL ANUAL EN NEUMATICOS (€, SIN IVA)",null,null,{"$f":"ROUND(IFERROR(E90*E94*E9/E98,0)+IFERROR(E91*E95*E9/E99,0)+IFERROR(E92*E96*E9/E100,0)+IFERROR(E93*E97*E9/E101,0),0)","v":8626.08},null,{"$f":"ROUND(IFERROR(G90*G94*G9/G98,0)+IFERROR(G91*G95*G9/G99,0)+IFERROR(G92*G96*G9/G100,0)+IFERROR(G93*G97*G9/G101,0),0)","v":6900.86},null,{"$f":"ROUND(IFERROR(I90*I94*I9/I98,0)+IFERROR(I91*I95*I9/I99,0)+IFERROR(I92*I96*I9/I100,0)+IFERROR(I93*I97*I9/I101,0),0)","v":6709.17},null,{"$f":"ROUND(IFERROR(K90*K94*K9/K98,0)+IFERROR(K91*K95*K9/K99,0)+IFERROR(K92*K96*K9/K100,0)+IFERROR(K93*K97*K9/K101,0),0)","v":6709.17},null,{"$f":"ROUND(IFERROR(M90*M94*M9/M98,0)+IFERROR(M91*M95*M9/M99,0)+IFERROR(M92*M96*M9/M100,0)+IFERROR(M93*M97*M9/M101,0),0)","v":12076.51},null,{"$f":"ROUND(IFERROR(O90*O94*O9/O98,0)+IFERROR(O91*O95*O9/O99,0)+IFERROR(O92*O96*O9/O100,0)+IFERROR(O93*O97*O9/O101,0),0)","v":3292.57},null,{"$f":"ROUND(IFERROR(Q90*Q94*Q9/Q98,0)+IFERROR(Q91*Q95*Q9/Q99,0)+IFERROR(Q92*Q96*Q9/Q100,0)+IFERROR(Q93*Q97*Q9/Q101,0),0)","v":6038.26},null,{"$f":"ROUND(IFERROR(S90*S94*S9/S98,0)+IFERROR(S91*S95*S9/S99,0)+IFERROR(S92*S96*S9/S100,0)+IFERROR(S93*S97*S9/S101,0),0)","v":5750.72},null,{"$f":"ROUND(IFERROR(U90*U94*U9/U98,0)+IFERROR(U91*U95*U9/U99,0)+IFERROR(U92*U96*U9/U100,0)+IFERROR(U93*U97*U9/U101,0),0)","v":5750.72},null,{"$f":"ROUND(IFERROR(W90*W94*W9/W98,0)+IFERROR(W91*W95*W9/W99,0)+IFERROR(W92*W96*W9/W100,0)+IFERROR(W93*W97*W9/W101,0),0)","v":6900.86},null,{"$f":"ROUND(IFERROR(Y90*Y94*Y9/Y98,0)+IFERROR(Y91*Y95*Y9/Y99,0)+IFERROR(Y92*Y96*Y9/Y100,0)+IFERROR(Y93*Y97*Y9/Y101,0),0)","v":2560.89},null,{"$f":"ROUND(IFERROR(AA90*AA94*AA9/AA98,0)+IFERROR(AA91*AA95*AA9/AA99,0)+IFERROR(AA92*AA96*AA9/AA100,0)+IFERROR(AA93*AA97*AA9/AA101,0),0)","v":6900.86},null,{"$f":"ROUND(IFERROR(AC90*AC94*AC9/AC98,0)+IFERROR(AC91*AC95*AC9/AC99,0)+IFERROR(AC92*AC96*AC9/AC100,0)+IFERROR(AC93*AC97*AC9/AC101,0),0)","v":6900.86},null,{"$f":"ROUND(IFERROR(AE90*AE94*AE9/AE98,0)+IFERROR(AE91*AE95*AE9/AE99,0)+IFERROR(AE92*AE96*AE9/AE100,0)+IFERROR(AE93*AE97*AE9/AE101,0),0)","v":697.4},null,{"$f":"ROUND(IFERROR(AG90*AG94*AG9/AG98,0)+IFERROR(AG91*AG95*AG9/AG99,0)+IFERROR(AG92*AG96*AG9/AG100,0)+IFERROR(AG93*AG97*AG9/AG101,0),0)","v":697.4},null,{"$f":"ROUND(IFERROR(AI90*AI94*AI9/AI98,0)+IFERROR(AI91*AI95*AI9/AI99,0)+IFERROR(AI92*AI96*AI9/AI100,0)+IFERROR(AI93*AI97*AI9/AI101,0),0)","v":6900.86}]
[null,"Coste de mantenimiento por km, sin IVA (€/km)",null,null,0.0187,null,0.0187,null,0.0224,null,0.0224,null,0.0757,null,0.0221,null,0.0605,null,0.0605,null,0.0605,null,0.0221,null,0.0295,null,0.0187,null,0.0187,null,0.0106,null,0.0106,null,0.0187]
[null,"GASTO ANUAL EN MANTENIMIENTO, SIN IVA (€)",null,null,{"$f":"E103*E9","v":2805.0},null,{"$f":"G103*G9","v":2244.0},null,{"$f":"I103*I9","v":2240.0},null,{"$f":"K103*K9","v":2240.0},null,{"$f":"M103*M9","v":4542.0},null,{"$f":"O103*O9","v":1989.0},null,{"$f":"Q103*Q9","v":6353.0},null,{"$f":"S103*S9","v":6050.0},null,{"$f":"U103*U9","v":6050.0},null,{"$f":"W103*W9","v":2652.0},null,{"$f":"Y103*Y9","v":2065.0},null,{"$f":"AA103*AA9","v":2244.0},null,{"$f":"AC103*AC9","v":2244.0},null,{"$f":"AE103*AE9","v":530.0},null,{"$f":"AG103*AG9","v":530.0},null,{"$f":"AI103*AI9","v":2244.0}]
[null,"Coste de reparaciones por km, sin IVA (€/km)",null,null,0.0369,null,0.0369,null,0.0369,null,0.0369,null,0.0474,null,0.0295,null,0.0465,null,0.0465,null,0.0465,null,0.0465,null,0.0369,null,0.0369,null,0.0369,null,0.0189,null,0.0189,null,0.0369]
[null,"GASTO ANUAL EN REPARACIONES, SIN IVA (€)",null,null,{"$f":"E105*E9","v":5535.0},null,{"$f":"G105*G9","v":4428.0},null,{"$f":"I105*I9","v":3690.0},null,{"$f":"K105*K9","v":3690.0},null,{"$f":"M105*M9","v":2844.0},null,{"$f":"O105*O9","v":2655.0},null,{"$f":"Q105*Q9","v":4883.0},null,{"$f":"S105*S9","v":4650.0},null,{"$f":"U105*U9","v":4650.0},null,{"$f":"W105*W9","v":5580.0},null,{"$f":"Y105*Y9","v":2583.0},null,{"$f":"AA105*AA9","v":4428.0},null,{"$f":"AC105*AC9","v":4428.0},null,{"$f":"AE105*AE9","v":945.0},null,{"$f":"AG105*AG9","v":945.0},null,{"$f":"AI105*AI9","v":4428.0}]
[null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,null,18588.7,null,2313.26,null,1927.72,null,1927.72,null,0.0,null,1487.1,null,10120.52,null,9638.59,null,9638.59,null,2313.26,null,1156.64,null,2313.26,null,2313.26,null,0.0,null,0.0,null,2313.26]
[null,"COSTES VARIABLES",null,null,{"$f":"ROUND(E81+E89+E102+E104+E106+E107+E114,0)","v":97573.5},null,{"$f":"ROUND(G81+G89+G102+G104+G106+G107+G114,0)","v":65500.3},null,{"$f":"ROUND(I81+I89+I102+I104+I106+I107+I114,0)","v":55912.37},null,{"$f":"ROUND(K81+K89+K102+K104+K106+K107+K114,0)","v":55912.37},null,{"$f":"ROUND(M81+M89+M102+M104+M106+M107+M114,0)","v":46750.71},null,{"$f":"ROUND(O81+O89+O102+O104+O106+O107+O114,0)","v":36003.41},null,{"$f":"ROUND(Q81+Q89+Q102+Q104+Q106+Q107+Q114,0)","v":70187.42},null,{"$f":"ROUND(S81+S89+S102+S104+S106+S107+S114,0)","v":66844.25},null,{"$f":"ROUND(U81+U89+U102+U104+U106+U107+U114,0)","v":66844.25},null,{"$f":"ROUND(W81+W89+W102+W104+W106+W107+W114,0)","v":74104.3},null,{"$f":"ROUND(Y81+Y89+Y102+Y104+Y106+Y107+Y114,0)","v":34321.77},null,{"$f":"ROUND(AA81+AA89+AA102+AA104+AA106+AA107+AA114,0)","v":65500.3},null,{"$f":"ROUND(AC81+AC89+AC102+AC104+AC106+AC107+AC114,0)","v":65500.3},null,{"$f":"ROUND(AE81+AE89+AE102+AE104+AE106+AE107+AE114,0)","v":9197.73},null,{"$f":"ROUND(AG81+AG89+AG102+AG104+AG106+AG107+AG114,0)","v":9197.73},null,{"$f":"ROUND(AI81+AI89+AI102+AI104+AI106+AI107+AI114,0)","v":65500.3}]
[null,"% Costes anuales de gestión, administración y comercialización, repercutibles a este vehículo ",null,6.5,{"$f":"ROUND((E50+E57+E76+E108)*(D109/100),0)","v":13213.87},6.5,{"$f":"ROUND((G50+G57+G76+G108)*(F109/100),0)","v":9568.81},6.5,{"$f":"ROUND((I50+I57+I76+I108)*(H109/100),0)","v":8415.75},6.5,{"$f":"ROUND((K50+K57+K76+K108)*(J109/100),0)","v":8415.75},6.5,{"$f":"ROUND((M50+M57+M76+M108)*(L109/100),0)","v":7287.41},6.5,{"$f":"ROUND((O50+O57+O76+O108)*(N109/100),0)","v":6317.25},6.5,{"$f":"ROUND((Q50+Q57+Q76+Q108)*(P109/100),0)","v":10695.96},6.5,{"$f":"ROUND((S50+S57+S76+S108)*(R109/100),0)","v":10443.22},6.5,{"$f":"ROUND((U50+U57+U76+U108)*(T109/100),0)","v":10443.22},6.5,{"$f":"ROUND((V109/100)*(W50+W57+W76+W108),0)","v":10372.4},6.5,{"$f":"ROUND((X109/100)*(Y50+Y57+Y76+Y108),0)","v":6279.04},6.5,{"$f":"ROUND((Z109/100)*(AA50+AA57+AA76+AA108),0)","v":9425.95},6.5,{"$f":"ROUND((AB109/100)*(AC50+AC57+AC76+AC108),0)","v":9425.95},6.5,{"$f":"ROUND((AD109/100)*(AE50+AE57+AE76+AE108),0)","v":3583.98},6.5,{"$f":"ROUND((AF109/100)*(AG50+AG57+AG76+AG108),0)","v":3583.98},6.5,{"$f":"ROUND((AH109/100)*(AI50+AI57+AI76+AI108),0)","v":9568.81}]
[]
[]
[null,"COSTES INDIRECTOS",null,null,{"$f":"ROUND((E50+E57+E76+E108)*(D109/100),0)","v":13213.87},null,{"$f":"ROUND((G50+G57+G76+G108)*(F109/100),0)","v":9568.81},null,{"$f":"ROUND((I50+I57+I76+I108)*(H109/100),0)","v":8415.75},null,{"$f":"ROUND((K50+K57+K76+K108)*(J109/100),0)","v":8415.75},null,{"$f":"ROUND((M50+M57+M76+M108)*(L109/100),0)","v":7287.41},null,{"$f":"ROUND((O50+O57+O76+O108)*(N109/100),0)","v":6317.25},null,{"$f":"ROUND((Q50+Q57+Q76+Q108)*(P109/100),0)","v":10695.96},null,{"$f":"ROUND((S50+S57+S76+S108)*(R109/100),0)","v":10443.22},null,{"$f":"ROUND((U50+U57+U76+U108)*(T109/100),0)","v":10443.22},null,{"$f":"ROUND((V109/100)*(W50+W57+W76+W108),0)","v":10372.4},null,{"$f":"ROUND((X109/100)*(Y50+Y57+Y76+Y108),0)","v":6279.04},null,{"$f":"ROUND((Z109/100)*(AA50+AA57+AA76+AA108),0)","v":9425.95},null,{"$f":"ROUND((AB109/100)*(AC50+AC57+AC76+AC108),0)","v":9425.95},null,{"$f":"ROUND((AD109/100)*(AE50+AE57+AE76+AE108),0)","v":3583.98},null,{"$f":"ROUND((AF109/100)*(AG50+AG57+AG76+AG108),0)","v":3583.98},null,{"$f":"ROUND((AH109/100)*(AI50+AI57+AI76+AI108),0)","v":9568.81}]
[null,"COSTES TOTALES",null,null,{"$f":"(E50+E57+E76+E108)+E112","v":241236.41999999998},null,{"$f":"(G50+G57+G76+G108)+G112","v":153670.62},null,{"$f":"(I50+I57+I76+I108)+I112","v":134962.96000000002},null,{"$f":"(K50+K57+K76+K108)+K112","v":134962.96000000002},null,{"$f":"(M50+M57+M76+M108)+M112","v":117054.59},null,{"$f":"(O50+O57+O76+O108)+O112","v":100459.42},null,{"$f":"(Q50+Q57+Q76+Q108)+Q112","v":171694.08000000002},null,{"$f":"(S50+S57+S76+S108)+S112","v":167394.64000000001},null,{"$f":"(U50+U57+U76+U108)+U112","v":167601.64000000001},null,{"$f":"(W50+W57+W76+W108)+W112","v":166481.23000000001},null,{"$f":"(Y50+Y57+Y76+Y108)+Y112","v":100545.06},null,{"$f":"(AA50+AA57+AA76+AA108)+AA112","v":151493.87},null,{"$f":"(AC50+AC57+AC76+AC108)+AC112","v":151493.87},null,{"$f":"(AE50+AE57+AE76+AE108)+AE112","v":56318.16},null,{"$f":"(AG50+AG57+AG76+AG108)+AG112","v":56294.16},null,{"$f":"(AI50+AI57+AI76+AI108)+AI112","v":153421.62}]
[null,"GASTO ANUAL POR CONSUMO DE DISOLUCION DE UREA (€, sin IVA)",null,null,2577.72,null,2062.18,null,1718.48,null,1718.48,null,1134.2,null,1104.74,null,1778.64,null,1693.94,null,1693.94,null,2062.18,null,859.24,null,2062.18,null,2062.18,null,282.33,null,282.33,null,2062.18]
[null,"Coste anual por disolucion de urea por kilometro(€/km, sin IVA)",null,null,0.0172,null,0.0172,null,0.0172,null,0.0172,null,0.0189,null,0.0123,null,0.0169,null,0.0169,null,0.0169,null,0.0172,null,0.0123,null,0.0172,null,0.0172,null,0.0056,null,0.0056,null,0.0172]
[]
[]
[]
[]
[]
[null,"Valor de adquisición del vehículo sin IVA y sin neumáticos (€)",null,null,{"$f":"E21-E102","v":106861},null,{"$f":"G21-G102","v":108572.943},null,{"$f":"I21-I102","v":108762.943},null,{"$f":"K21-K102","v":108762.943},null,{"$f":"M21-M102","v":103437.943},null,{"$f":"O21-O102","v":68103.468000000008},null,{"$f":"Q21-Q102","v":109427.943},null,109713.943,null,109713.943,null,108572.943,null,68829.468000000008,null,108572.943,null,108572.943,null,23465.125,null,23465.125,null,108572.943]
[null,"Valor de adquisición del remolque-semirremolque sin IVA y sin neumáticos (€)",null,null,{"$f":"E37-(E93*E97)","v":33602.04},null,{"$f":"G37-(G93*G97)","v":33602.04},null,{"$f":"I37-(I93*I97)","v":25429.040000000001},null,{"$f":"K37-(K93*K97)","v":25429.040000000001},null,{"$f":"M37-(M93*M97)","v":27923.72},null,{"$f":"O37-(O93*O97)","v":0},null,{"$f":"Q37-(Q93*Q97)","v":89000.04},null,{"$f":"S37-(S93*S97)","v":89000.04},null,{"$f":"U37-(U93*U97)","v":89000.04},null,{"$f":"W37-(W93*W97)","v":61004.04},null,{"$f":"Y37-(Y93*Y97)","v":0},null,{"$f":"AA37-(AA93*AA97)","v":36678.04},null,{"$f":"AC37-(AC93*AC97)","v":36678.04},null,{"$f":"AE37-(AE93*AE97)","v":0},null,{"$f":"AG37-(AG93*AG97)","v":0},null,{"$f":"AI37-(AI93*AI97)","v":33602.04}]
[null,"Dietas y plus de actividad anuales del conductor (€)",null,null,{"$f":"E54+E56","v":30650},null,{"$f":"G54+G56","v":16122},null,{"$f":"I54+I56","v":13904},null,{"$f":"K54+K56","v":13904},null,{"$f":"M54+M56","v":6910.7999999999993},null,{"$f":"O54+O56","v":10296.630000000001},null,{"$f":"Q54+Q56","v":17153.5},null,{"$f":"S54+S56","v":16694},null,{"$f":"U54+U56","v":16694},null,{"$f":"W54+W56","v":15774},null,{"$f":"Y54+Y56","v":7038.25},null,{"$f":"AA54+AA56","v":14502},null,{"$f":"AC54+AC56","v":14502},null,{"$f":"AE54+AE56","v":5759},null,{"$f":"AG54+AG56","v":5759},null,{"$f":"AI54+AI56","v":16122}]
[null,"Gasto anual en mantenimiento, sin IVA (€)",null,null,{"$f":"E104+E106","v":8100},null,{"$f":"G104+G106","v":6480},null,{"$f":"I104+I106","v":5760},null,{"$f":"K104+K106","v":5760},null,{"$f":"M104+M106","v":7164},null,{"$f":"O104+O106","v":4509},null,{"$f":"Q104+Q106","v":10899},null,{"$f":"S104+S106","v":10380},null,{"$f":"U104+U106","v":10380},null,{"$f":"W104+W106","v":7992},null,{"$f":"Y104+Y106","v":4508},null,{"$f":"AA104+AA106","v":6480},null,{"$f":"AC104+AC106","v":6480},null,{"$f":"AE104+AE106","v":1430},null,{"$f":"AG104+AG106","v":1430},null,{"$f":"AI104+AI106","v":6480}]
[null,"Costo neumáticos por km",null,null,{"$f":"IFERROR((E90*E94/E98),0)+IFERROR((E91*E95/E99),0)+IFERROR((E92*E96/E100),0)+IFERROR((E93*E97/E101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((G90*G94/G98),0)+IFERROR((G91*G95/G99),0)+IFERROR((G92*G96/G100),0)+IFERROR((G93*G97/G101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((I90*I94/I98),0)+IFERROR((I91*I95/I99),0)+IFERROR((I92*I96/I100),0)+IFERROR((I93*I97/I101),0)","v":6.6561599999999999E-2},null,{"$f":"IFERROR((K90*K94/K98),0)+IFERROR((K91*K95/K99),0)+IFERROR((K92*K96/K100),0)+IFERROR((K93*K97/K101),0)","v":6.6561599999999999E-2},null,{"$f":"IFERROR((M90*M94/M98),0)+IFERROR((M91*M95/M99),0)+IFERROR((M92*M96/M100),0)+IFERROR((M93*M97/M101),0)","v":0.1996848},null,{"$f":"IFERROR((O90*O94/O98),0)+IFERROR((O91*O95/O99),0)+IFERROR((O92*O96/O100),0)+IFERROR((O93*O97/O101),0)","v":3.62952E-2},null,{"$f":"IFERROR((Q90*Q94/Q98),0)+IFERROR((Q91*Q95/Q99),0)+IFERROR((Q92*Q96/Q100),0)+IFERROR((Q93*Q97/Q101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((S90*S94/S98),0)+IFERROR((S91*S95/S99),0)+IFERROR((S92*S96/S100),0)+IFERROR((S93*S97/S101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((U90*U94/U98),0)+IFERROR((U91*U95/U99),0)+IFERROR((U92*U96/U100),0)+IFERROR((U93*U97/U101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((W90*W94/W98),0)+IFERROR((W91*W95/W99),0)+IFERROR((W92*W96/W100),0)+IFERROR((W93*W97/W101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((Y90*Y94/Y98),0)+IFERROR((Y91*Y95/Y99),0)+IFERROR((Y92*Y96/Y100),0)+IFERROR((Y93*Y97/Y101),0)","v":3.62952E-2},null,{"$f":"IFERROR((AA90*AA94/AA98),0)+IFERROR((AA91*AA95/AA99),0)+IFERROR((AA92*AA96/AA100),0)+IFERROR((AA93*AA97/AA101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((AC90*AC94/AC98),0)+IFERROR((AC91*AC95/AC99),0)+IFERROR((AC92*AC96/AC100),0)+IFERROR((AC93*AC97/AC101),0)","v":5.7052800000000001E-2},null,{"$f":"IFERROR((AE90*AE94/AE98),0)+IFERROR((AE91*AE95/AE99),0)+IFERROR((AE92*AE96/AE100),0)+IFERROR((AE93*AE97/AE101),0)","v":1.3838E-2},null,{"$f":"IFERROR((AG90*AG94/AG98),0)+IFERROR((AG91*AG95/AG99),0)+IFERROR((AG92*AG96/AG100),0)+IFERROR((AG93*AG97/AG101),0)","v":1.3838E-2},null,{"$f":"IFERROR((AI90*AI94/AI98),0)+IFERROR((AI91*AI95/AI99),0)+IFERROR((AI92*AI96/AI100),0)+IFERROR((AI93*AI97/AI101),0)","v":5.7052800000000001E-2}]

{"sheet":"Tipo Vehículo","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"Seleccionar tipo de vehículo"]
[]
[]
[]
[null,null,"Tipo de vehículo:",null,{"$f":"VLOOKUP(F10,T!A2:B17,2,0)","v":"T1"},"Vehículo articulado de carga general de larga distancia"]
[]
[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":52,"n_cols":11,"rows_kept":52,"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$285,3,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AT$285,3,0))","v":5.6099999999999997E-2}]
[null,null,"Kilómetros recorridos anualmente",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$SS$300,9,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,9,0))","v":150000}]
[]
[null,null,"Horas trabajadas al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,13,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,13,0))","v":2000}]
[]
[null,null,"Valor de adquisición del vehículo sin IVA y sin neumáticos (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,121,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,121,0))","v":106861}]
[]
[null,null,"Vida útil del vehículo (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,22,0))","v":5}]
[]
[null,null,"Valor residual sin IVA del vehículo (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,23,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,23,0))","v":19236}]
[]
[null,null,"Valor de adquisición del remolque-semirremolque sin IVA y sin neumáticos (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,122,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,122,0))","v":33602.04}]
[]
[null,null,"Vida útil del remolque-semirremolque (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,38,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,38,0))","v":7}]
[]
[null,null,"Valor residual del remolque-semirremolque sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,39,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,39,0))","v":3987}]
[]
[null,null,"Leasing y alquiler (vehículo de tracción, carrozado, semirremolque, equipos auxiliares)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,18,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,18,0))","v":0}]
[]
[null,null,"Coste total anual del conductor, incluidos costes de empresa, Seg. Soc y otros (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,51,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,51,0))","v":37649.699999999997}]
[]
[null,null,"Dietas y plus de actividad anuales del conductor (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,123,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,123,0))","v":30650}]
[]
[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:$AI$300,66,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,66,0))","v":6965.05}]
[]
[null,null,"Coste fiscal total anual (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,75,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,75,0))","v":929.67000000000007}]
[]
[null,null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,80,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,80,0))","v":1.6588000000000001}]
[]
[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:$AI$300,114,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,114,0))","v":2500.16}]
[]
[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:$AI$300,81,0)=\"\",0,HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,81,0))+IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,89,0)=\"\",0)","v":87087}]
[]
[null,null,"Gasto total anual en neumáticos (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,102,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,102,0))","v":8558}]
[]
[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:$AI$300,104,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,104,0))+IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,106,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,106,0))","v":8100}]
[]
[null,null,"Coste anual en peajes, sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,107,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,107,0))","v":18260.02}]
[]
[null,null,"Total costes anuales indirectos repercutibles a este vehículo (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,112,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,112,0))","v":14723}]
[]
[]
[null,null,"(*) Los campos marcados con asterisco se recalcularán automaticamente al cambiar los kilómetros."]

{"sheet":"Resultados","index":4,"n_rows":67,"n_cols":9,"rows_kept":67,"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(('Cálculo Simplificado'!I15-'Cálculo Simplificado'!I19)*(1/'Cálculo Simplificado'!I17)+('Cálculo Simplificado'!I15-'Cálculo Simplificado'!I19)*(-(1/'Cálculo Simplificado'!I17)+'Cálculo Simplificado'!I$10/(1-POWER(1+'Cálculo Simplificado'!I$10,-'Cálculo Simplificado'!I17)))+IFERROR(('Cálculo Simplificado'!I21-'Cálculo Simplificado'!I25)*(1/'Cálculo Simplificado'!I23)+('Cálculo Simplificado'!I21-'Cálculo Simplificado'!I25)*(-(1/'Cálculo Simplificado'!I23)+'Cálculo Simplificado'!I$10/(1-POWER(1+'Cálculo Simplificado'!I$10,-'Cálculo Simplificado'!I23))),0)+'Cálculo Simplificado'!I27 + IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,32,0))+IFERROR(IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,33,0)),0),0)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E11*F$16/E$16,0)","v":0},"A",{"$f":"ROUND(('Cálculo Simplificado'!J15-'Cálculo Simplificado'!J19)*(1/'Cálculo Simplificado'!J17)+('Cálculo Simplificado'!J15-'Cálculo Simplificado'!J19)*(-(1/'Cálculo Simplificado'!J17)+'Cálculo Simplificado'!J$10/(1-POWER(1+'Cálculo Simplificado'!J$10,-'Cálculo Simplificado'!J17)))+IFERROR(('Cálculo Simplificado'!J21-'Cálculo Simplificado'!J25)*(1/'Cálculo Simplificado'!J23)+('Cálculo Simplificado'!J21-'Cálculo Simplificado'!J25)*(-(1/'Cálculo Simplificado'!J23)+'Cálculo Simplificado'!J$10/(1-POWER(1+'Cálculo Simplificado'!J$10,-'Cálculo Simplificado'!J23))),0)+'Cálculo Simplificado'!J27 + IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,32,0))+IFERROR(IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$300,33,0)),0),0)","v":25813},{"$f":"IFERROR(H11*I$16/H$16,0)","v":10.700310069807159}]
[null,null,"Personal","B",{"$f":"ROUND('Cálculo Simplificado'!I29+'Cálculo Simplificado'!I31,0)","v":0},{"$f":"IFERROR(E12*F$16/E$16,0)","v":0},"B",{"$f":"ROUND('Cálculo Simplificado'!J29+'Cálculo Simplificado'!J31,0)","v":68300},{"$f":"IFERROR(H12*I$16/H$16,0)","v":28.312523835580095}]
[null,null,"Seguros, costes fiscales, gestión y comercialización","C",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!I33+'Cálculo Simplificado'!I35+'Cálculo Simplificado'!I49,0),0)","v":0},{"$f":"IFERROR(E13*F$16/E$16,0)","v":0},"C",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!J33+'Cálculo Simplificado'!J35+'Cálculo Simplificado'!J49,0),0)","v":22618},{"$f":"IFERROR(H13*I$16/H$16,0)","v":9.3758808801339768}]
[null,null,"Carburante, neumáticos, reparaciones, mantenimiento y peajes","D",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!I39+'Cálculo Simplificado'!I41+'Cálculo Simplificado'!I43+'Cálculo Simplificado'!I45+'Cálculo Simplificado'!I47,0),0)","v":0},{"$f":"IFERROR(E14*F$16/E$16,0)","v":0},"D",{"$f":"ROUND(IFERROR('Cálculo Simplificado'!J39+'Cálculo Simplificado'!J41+'Cálculo Simplificado'!J43+'Cálculo Simplificado'!J45+'Cálculo Simplificado'!J47,0),0)","v":124505},{"$f":"IFERROR(H14*I$16/H$16,0)","v":51.611285214478769}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E11:E14),0)","v":{"$error":"#DIV/0!"}},100,null,{"$f":"ROUND(SUM(H11:H14),0)","v":241236},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":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E40*F$16/E$16,0)","v":0},"A",{"$f":"ROUND(H11+H12+H13,0)","v":116731},{"$f":"IFERROR(H40*I$16/H$16,0)","v":48.388714785521231}]
[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":124505},{"$f":"IFERROR(H41*I$16/H$16,0)","v":51.611285214478769}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"ROUND(SUM(E40:E41),0)","v":{"$error":"#DIV/0!"}},100,null,{"$f":"ROUND(SUM(H40:H41),0)","v":241236},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.6082399999999999}]
[null,null,"Coste total medio (por hora)",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I13,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J13,0)","v":120.61799999999999}]
[null,null,"Coste por distancia",null,{"$f":"IFERROR(E41,0)","v":0},null,null,{"$f":"IFERROR(H41,0)","v":124505}]
[null,null,"Coste por distancia media (por km.)",null,{"$f":"IFERROR(E63/'Cálculo Simplificado'!I11,0)","v":0},null,null,{"$f":"IFERROR(H63/'Cálculo Simplificado'!J11,0)","v":0.83003333333333329}]
[null,null,"Coste por tiempo",null,{"$f":"IFERROR(E40,0)","v":0},null,null,{"$f":"IFERROR(H40,0)","v":116731}]
[null,null,"Coste por tiempo medio (por hora)",null,{"$f":"IFERROR(E65/'Cálculo Simplificado'!I13,0)","v":0},null,null,{"$f":"IFERROR(H65/'Cálculo Simplificado'!J13,0)","v":58.365499999999997}]
[null,null,"Costes totales por viajero-kilómetro",null,{"$f":"IFERROR(E43/'Cálculo Simplificado'!I11/'Cálculo Simplificado'!I15,0)","v":0},null,null,{"$f":"IFERROR(H43/'Cálculo Simplificado'!J11/'Cálculo Simplificado'!J15,0)","v":1.5049831088984754E-5}]

{"sheet":"Coste Servicio","index":5,"n_rows":37,"n_cols":8,"rows_kept":37,"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,null,null,{"$f":"H15+H17","v":0}]
[]
[null,null,"Kilómetros en carga (km) "]
[]
[null,null,"Kilómetros en vacío (km) "]
[]
[null,null,"Consumo medio por kilómetro en este servicio (litros / 100 km) "]
[]
[null,null,"Horas empleadas en este servicio ",null,null,null,null,{"$f":"H23+H25+H27","v":0}]
[]
[null,null,"Horas en carga "]
[]
[null,null,"Horas en vacío "]
[null,null,null,null,null,null,null,6]
[null,null,"Horas en carga, descarga y paralización "]
[]
[null,null,"Peajes "]
[]
[null,null,"Coste por distancia de este servicio (€)",null,null,null,null,{"$f":"IFERROR(ROUND(H13*(H19/100)*'Cálculo Simplificado'!I37+H13*(('Cálculo Simplificado'!I43+'Cálculo Simplificado'!I45)/'Cálculo Simplificado'!I11)+H29,2),0)","v":0}]
[]
[null,null,"Coste por tiempo de este servicio (€)",null,null,null,null,{"$f":"IFERROR(H21*((Resultados!E11+Resultados!E12+Resultados!E13)/'Cálculo Simplificado'!I13),0)","v":0}]
[]
[null,null,"Otros costes asociados a este servicio (€)"]
[]
[null,null,"Coste total de este servicio (€)",null,null,null,null,{"$f":"IFERROR(H31+H33+H35,0)","v":0}]