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

{"sheet":"T","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Tipo de vehículo",null,"Pregunta",null,null,"Adquisicion",null,"Editable"]
["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)","22/01/2024"]
[null,"Tipo interes",null,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534,null,0.0534]
[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,124387.3,null,124387.3,null,124387.3,null,124387.3,null,124387.3,null,76916.1,null,124387.3,null,124387.3,null,124387.3,null,124387.3,null,76916.1,null,124387.3,null,124387.3,null,26034.19,null,26034.19,null,124387.3]
[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":111949.0},null,{"$f":"(1-G20/100)*G19","v":111949.0},null,{"$f":"(1-I20/100)*I19","v":111949.0},null,111949.0,null,{"$f":"(1-M20/100)*M19","v":111949.0},null,{"$f":"(1-O20/100)*O19","v":69224.0},null,{"$f":"(1-Q20/100)*Q19","v":111949.0},null,{"$f":"(1-S20/100)*S19","v":111949.0},null,111949.0,null,{"$f":"(1-W20/100)*W19","v":111949.0},null,{"$f":"(1-Y20/100)*Y19","v":69224.0},null,{"$f":"(1-AA20/100)*AA19","v":111949.0},null,111949.0,null,{"$f":"(1-AE20/100)*AE19","v":23431.0},null,{"$f":"(1-AG20/100)*AG19","v":23431.0},null,{"$f":"(1-AI20/100)*AI19","v":111949.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":18658.0},20.0,{"$f":"G19*F23/100","v":24877.0},20.0,{"$f":"I19*H23/100","v":24877.0},20.0,{"$f":"K19*J23/100","v":24877.0},20.0,{"$f":"M19*L23/100","v":24877.0},10.0,{"$f":"O19*N23/100","v":7692.0},20.0,{"$f":"Q19*P23/100","v":24877.0},20.0,{"$f":"S19*R23/100","v":24877.0},20.0,{"$f":"U19*T23/100","v":24877.0},20.0,{"$f":"W19*V23/100","v":24877.0},10.0,{"$f":"Y19*X23/100","v":7692.0},20.0,{"$f":"AA19*Z23/100","v":24877.0},20.0,{"$f":"AC19*AB23/100","v":24877.0},15.0,{"$f":"AE19*AD23/100","v":3905.0},15.0,{"$f":"AG19*AF23/100","v":3905.0},20.0,{"$f":"AI19*AH23/100","v":24877.0}]
[null,"AMORTIZACIÓN DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E90*E94-E91*E95-E92*E96)/E22,0),0)","v":17847.0},null,{"$f":"IFERROR(ROUND((G21-G23-G90*G94-G91*G95-G92*G96)/G22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((I21-I23-I90*I94-I91*I95-I92*I96)/I22,0),0)","v":10208.0},null,{"$f":"IFERROR(ROUND((K21-K23-K90*K94-K91*K95-K92*K96)/K22,0),0)","v":10208.0},null,{"$f":"IFERROR(ROUND((M21-M23-M90*M94-M91*M95-M92*M96)/M22,0),0)","v":10377.0},null,{"$f":"IFERROR(ROUND((O21-O23-O90*O94-O91*O95-O92*O96)/O22,0),0)","v":5723.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q90*Q94-Q91*Q95-Q92*Q96)/Q22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((S21-S23-S90*S94-S91*S95-S92*S96)/S22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((U21-U23-U90*U94-U91*U95-U92*U96)/U22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((W21-W23-W90*W94-W91*W95-W92*W96)/W22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y90*Y94-Y91*Y95-Y92*Y96)/Y22,0),0)","v":5723.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA90*AA94-AA91*AA95-AA92*AA96)/AA22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC90*AC94-AC91*AC95-AC92*AC96)/AC22,0),0)","v":13836.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE90*AE94-AE91*AE95-AE92*AE96)/AE22,0),0)","v":2342.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG90*AG94-AG91*AG95-AG92*AG96)/AG22,0),0)","v":2342.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI90*AI94-AI91*AI95-AI92*AI96)/AI22,0),0)","v":13836.0}]
[null,"GASTOS FINANCIEROS DEL VEHÍCULO DE TRACCIÓN",null,null,{"$f":"IFERROR(ROUND((E21-E23-E90*E94-E91*E95-E92*E96)*(E$3/(1-POWER(1+E$3,-E22))-1/E22),0),0)","v":2958.0},null,{"$f":"IFERROR(ROUND((G21-G23-G90*G94-G91*G95-G92*G96)*(G$3/(1-POWER(1+G$3,-G22))-1/G22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((I21-I23-I90*I94-I91*I95-I92*I96)*(I$3/(1-POWER(1+I$3,-I22))-1/I22),0),0)","v":2601.0},null,{"$f":"IFERROR(ROUND((K21-K23-K90*K94-K91*K95-K92*K96)*(K$3/(1-POWER(1+K$3,-K22))-1/K22),0),0)","v":2601.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":2644.0},null,{"$f":"IFERROR(ROUND((O21-O23-O90*O94-O91*O95-O92*O96)*(O$3/(1-POWER(1+O$3,-O22))-1/O22),0),0)","v":1811.0},null,{"$f":"IFERROR(ROUND((Q21-Q23-Q90*Q94-Q91*Q95-Q92*Q96)*(Q$3/(1-POWER(1+Q$3,-Q22))-1/Q22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((S21-S23-S90*S94-S91*S95-S92*S96)*(S$3/(1-POWER(1+S$3,-S22))-1/S22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((U21-U23-U90*U94-U91*U95-U92*U96)*(U$3/(1-POWER(1+U$3,-U22))-1/U22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((W21-W23-W90*W94-W91*W95-W92*W96)*(W$3/(1-POWER(1+W$3,-W22))-1/W22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((Y21-Y23-Y90*Y94-Y91*Y95-Y92*Y96)*(Y$3/(1-POWER(1+Y$3,-Y22))-1/Y22),0),0)","v":1811.0},null,{"$f":"IFERROR(ROUND((AA21-AA23-AA90*AA94-AA91*AA95-AA92*AA96)*(AA$3/(1-POWER(1+AA$3,-AA22))-1/AA22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((AC21-AC23-AC90*AC94-AC91*AC95-AC92*AC96)*(AC$3/(1-POWER(1+AC$3,-AC22))-1/AC22),0),0)","v":2698.0},null,{"$f":"IFERROR(ROUND((AE21-AE23-AE90*AE94-AE91*AE95-AE92*AE96)*(AE$3/(1-POWER(1+AE$3,-AE22))-1/AE22),0),0)","v":597.0},null,{"$f":"IFERROR(ROUND((AG21-AG23-AG90*AG94-AG91*AG95-AG92*AG96)*(AG$3/(1-POWER(1+AG$3,-AG22))-1/AG22),0),0)","v":597.0},null,{"$f":"IFERROR(ROUND((AI21-AI23-AI90*AI94-AI91*AI95-AI92*AI96)*(AI$3/(1-POWER(1+AI$3,-AI22))-1/AI22),0),0)","v":2698.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,8343.72,null,null,null,null,null,null,null,null,null,42669.75,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":7927.0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND((1-Y28/100)*Y27,0)","v":40536.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":834.0},null,null,null,null,null,null,null,null,10.0,{"$f":"ROUND(Y27*X31/100,0)","v":4267.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":709.0},null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND((Y29-Y31)/Y30,0),0)","v":3627.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":224.5},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":1147.97},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,38675.39,null,38675.39,null,30331.08,null,30331.08,null,34334.03,null,null,null,95236.51,null,95236.51,null,95236.51,null,66653.02,null,null,null,41816.35,null,41816.35,null,null,null,null,null,38675.39]
[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":36742.0},null,{"$f":"ROUND((1-G36/100)*G35,0)","v":36742.0},null,{"$f":"ROUND((1-I36/100)*I35,0)","v":28815.0},null,{"$f":"ROUND((1-K36/100)*K35,0)","v":28815.0},null,{"$f":"ROUND((1-M36/100)*M35,0)","v":32617.0},null,null,null,{"$f":"ROUND((1-Q36/100)*Q35,0)","v":90475.0},null,{"$f":"ROUND((1-S36/100)*S35,0)","v":90475.0},null,{"$f":"ROUND((1-U36/100)*U35,0)","v":90475.0},null,{"$f":"ROUND((1-W36/100)*W35,0)","v":63320.0},null,null,null,{"$f":"ROUND((1-AA36/100)*AA35,0)","v":39726.0},null,{"$f":"ROUND((1-AC36/100)*AC35,0)","v":39726.0},null,null,null,null,null,{"$f":"ROUND((1-AI36/100)*AI35,0)","v":36742.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":3868.0},15.0,{"$f":"ROUND(G35*F39/100,0)","v":5801.0},15.0,{"$f":"ROUND(I35*H39/100,0)","v":4550.0},15.0,{"$f":"ROUND(K35*J39/100,0)","v":4550.0},15.0,{"$f":"ROUND(M35*L39/100,0)","v":5150.0},null,null,20.0,{"$f":"ROUND(Q35*P39/100,0)","v":19047.0},15.0,{"$f":"ROUND(S35*R39/100,0)","v":14285.0},15.0,{"$f":"ROUND(U35*T39/100,0)","v":14285.0},15.0,{"$f":"ROUND(W35*V39/100,0)","v":9998.0},null,null,10.0,{"$f":"ROUND(AA35*Z39/100,0)","v":4182.0},10.0,{"$f":"ROUND(AC35*AB39/100,0)","v":4182.0},null,null,null,null,15.0,{"$f":"ROUND(AI35*AH39/100,0)","v":5801.0}]
[null,"AMORTIZACIÓN REMOLQUE",null,null,{"$f":"IFERROR(ROUND((E37-E39-E93*E97)/E38,0),0)","v":4117.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)/G38,0),0)","v":3361.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)/I38,0),0)","v":1684.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)/K38,0),0)","v":1684.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)/M38,0),0)","v":1838.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)/Q38,0),0)","v":8421.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)/S38,0),0)","v":7213.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)/U38,0),0)","v":7213.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)/W38,0),0)","v":4927.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)/AA38,0),0)","v":3149.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)/AC38,0),0)","v":3149.0},null,null,null,null,null,{"$f":"IFERROR(ROUND((AI37-AI39-AI93*AI97)/AI38,0),0)","v":3361.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":925.0},null,{"$f":"IFERROR(ROUND((G37-G39-G93*G97)*(G$3/(1-POWER(1+G$3,-G38))-1/G38),0),0)","v":856.0},null,{"$f":"IFERROR(ROUND((I37-I39-I93*I97)*(I$3/(1-POWER(1+I$3,-I38))-1/I38),0),0)","v":640.0},null,{"$f":"IFERROR(ROUND((K37-K39-K93*K97)*(K$3/(1-POWER(1+K$3,-K38))-1/K38),0),0)","v":640.0},null,{"$f":"IFERROR(ROUND((M37-M39-M93*M97)*(M$3/(1-POWER(1+M$3,-M38))-1/M38),0),0)","v":698.0},null,null,null,{"$f":"IFERROR(ROUND((Q37-Q39-Q93*Q97)*(Q$3/(1-POWER(1+Q$3,-Q38))-1/Q38),0),0)","v":2146.0},null,{"$f":"IFERROR(ROUND((S37-S39-S93*S97)*(S$3/(1-POWER(1+S$3,-S38))-1/S38),0),0)","v":2283.0},null,{"$f":"IFERROR(ROUND((U37-U39-U93*U97)*(U$3/(1-POWER(1+U$3,-U38))-1/U38),0),0)","v":2283.0},null,{"$f":"IFERROR(ROUND((W37-W39-W93*W97)*(W$3/(1-POWER(1+W$3,-W38))-1/W38),0),0)","v":1559.0},null,null,null,{"$f":"IFERROR(ROUND((AA37-AA39-AA93*AA97)*(AA$3/(1-POWER(1+AA$3,-AA38))-1/AA38),0),0)","v":997.0},null,{"$f":"IFERROR(ROUND((AC37-AC39-AC93*AC97)*(AC$3/(1-POWER(1+AC$3,-AC38))-1/AC38),0),0)","v":997.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":856.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":25847.0},null,{"$f":"G24+G25+G32+G33+G40+G41+G48+G49","v":20751.0},null,{"$f":"I24+I25+I32+I33+I40+I41+I48+I49","v":15133.0},null,15133.0,null,{"$f":"M24+M25+M32+M33+M40+M41+M48+M49","v":15557.0},null,{"$f":"O24+O25+O32+O33+O40+O41+O48+O49","v":8467.5},null,{"$f":"Q24+Q25+Q32+Q33+Q40+Q41+Q48+Q49","v":27101.0},null,{"$f":"S24+S25+S32+S33+S40+S41+S48+S49","v":26030.0},null,26030.0,null,{"$f":"W24+W25+W32+W33+W40+W41+W48+W49","v":23020.0},null,{"$f":"Y24+Y25+Y32+Y33+Y40+Y41+Y48+Y49","v":12308.97},null,{"$f":"AA24+AA25+AA32+AA33+AA40+AA41+AA48+AA49","v":20680.0},null,20680.0,null,{"$f":"AE24+AE25+AE32+AE33+AE40+AE41+AE48+AE49","v":2939.0},null,{"$f":"AG24+AG25+AG32+AG33+AG40+AG41+AG48+AG49","v":2939.0},null,{"$f":"AI24+AI25+AI32+AI33+AI40+AI41+AI48+AI49","v":20751.0}]
[null,"Coste total anual del conductor, incluidos costes de empresa (Seg. Soc. y otros) €",null,null,35720.78,null,32180.89,null,32180.89,null,32180.89,null,32180.89,null,32180.89,null,35398.97,null,35398.97,null,35398.97,null,32180.89,null,32180.89,null,32180.89,null,32180.89,null,28962.8,null,28962.8,null,32180.89]
[null,"Dieta total diaria del conductor (€/día)",null,null,79.89,null,35.6,null,35.6,null,35.6,null,16.18,null,32.37,null,35.6,null,35.6,null,35.6,null,35.6,null,32.37,null,32.37,null,32.37,null,16.18,null,16.18,null,35.6]
[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":19973.0},null,{"$f":"G52*G53","v":8010.0},null,{"$f":"I52*I53","v":7120.0},null,7120.0,null,{"$f":"M52*M53","v":2912.0},null,{"$f":"O52*O53","v":4305.0},null,{"$f":"Q52*Q53","v":7120.0},null,{"$f":"S52*S53","v":7120.0},null,7120.0,null,{"$f":"W52*W53","v":8010.0},null,{"$f":"Y52*Y53","v":2428.0},null,{"$f":"AA52*AA53","v":6474.0},null,6474.0,null,{"$f":"AE52*AE53","v":2427.0},null,{"$f":"AG52*AG53","v":2427.0},null,{"$f":"AI52*AI53","v":8010.0}]
[null,"Plus anual de actividad del conductor (€/km)",null,null,0.06,null,0.06,null,0.06,null,0.06,null,0.06,null,0.06,null,0.09,null,0.09,null,0.09,null,0.06,null,0.06,null,0.06,null,0.06,null,0.06,null,0.06,null,0.06]
[null,"Plus anual de actividad del conductor (€)",null,null,{"$f":"E55*E9","v":9000.0},null,{"$f":"G55*G9","v":7200.0},null,{"$f":"I55*I9","v":6000.0},null,6000.0,null,{"$f":"M55*M9","v":3600.0},null,{"$f":"O55*O9","v":5400.0},null,{"$f":"Q55*Q9","v":9450.0},null,{"$f":"S55*S9","v":9000.0},null,9000.0,null,{"$f":"W55*W9","v":7200.0},null,{"$f":"Y55*Y9","v":4200.0},null,{"$f":"AA55*AA9","v":7200.0},null,7200.0,null,{"$f":"AE55*AE9","v":3000.0},null,{"$f":"AG55*AG9","v":3000.0},null,{"$f":"AI55*AI9","v":7200.0}]
[null,"COSTES DE PERSONAL",null,null,{"$f":"E51+E54+E56","v":64693.78},null,{"$f":"G51+G54+G56","v":47390.89},null,{"$f":"I51+I54+I56","v":45300.89},null,45300.89,null,{"$f":"M51+M54+M56","v":38692.89},null,{"$f":"O51+O54+O56","v":41885.89},null,{"$f":"Q51+Q54+Q56","v":51968.97},null,{"$f":"S51+S54+S56","v":51518.97},null,51518.97,null,{"$f":"W51+W54+W56","v":47390.89},null,{"$f":"Y51+Y54+Y56","v":38808.89},null,{"$f":"AA51+AA54+AA56","v":45854.89},null,45854.89,null,{"$f":"AE51+AE54+AE56","v":34389.8},null,{"$f":"AG51+AG54+AG56","v":34389.8},null,{"$f":"AI51+AI54+AI56","v":47390.89}]
[null,"Responsabilidad civil del vehículo de tracción (€)",null,null,1593.3,null,1593.3,null,1593.3,null,1593.3,null,1593.3,null,1651.51,null,1593.3,null,1593.3,null,1593.3,null,1593.3,null,1651.51,null,1593.3,null,1593.3,null,1115.55,null,115.55,null,1593.3]
[null,"Responsabilidad civil del remolque o semirremolque (€)",null,null,502.65,null,502.65,null,502.65,null,502.65,null,502.65,null,null,null,502.65,null,502.65,null,502.65,null,502.65,null,null,null,502.65,null,502.65,null,null,null,null,null,502.65]
[null,"Responsabilidad civil de la mercancía (€)",null,null,119.43,null,119.43,null,119.43,null,119.43,null,119.43,null,119.43,null,630.35,null,998.83,null,998.83,null,139.53,null,119.43,null,119.43,null,119.43,null,null,null,null,null,119.43]
[null,"Seguro de accidentes de personal de a bordo (€)",null,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43,null,55.43]
[null,"Retirada del carné de conducir (€)",null,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99,null,137.99]
[null,"Seguro de la mercancía (€)",null,null,676.06,null,676.06,null,367.45,null,367.45,null,0.0,null,403.6,null,676.06,null,676.06,null,676.06,null,974.94,null,825.43,null,337.32,null,337.32,null,247.0,null,247.0,null,676.06]
[null,"Daños propios (seguro todo riesgo) (€)",null,null,2977.9,null,2977.9,null,2977.9,null,2977.9,null,3140.13,null,1343.96,null,3577.65,null,3577.65,null,3577.65,null,3878.79,null,1669.15,null,2977.9,null,2977.9,null,1869.85,null,1869.85,null,2977.9]
[null,"Otros seguros (€)",null,null,477.2,null,477.2,null,477.2,null,477.2,null,500.1,null,477.2,null,477.2,null,477.2,null,477.2,null,477.2,null,477.2,null,477.2,null,477.2,null,226.56,null,226.56,null,477.2]
[null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,{"$f":"SUM(E58:E65)","v":6539.96},null,{"$f":"SUM(G58:G65)","v":6539.96},null,{"$f":"SUM(I58:I65)","v":6231.35},null,6231.35,null,{"$f":"SUM(M58:M65)","v":6049.03},null,{"$f":"SUM(O58:O65)","v":4189.12},null,{"$f":"SUM(Q58:Q65)","v":7650.63},null,{"$f":"SUM(S58:S65)","v":8019.11},null,8019.11,null,{"$f":"SUM(W58:W65)","v":7759.83},null,{"$f":"SUM(Y58:Y65)","v":4936.14},null,{"$f":"SUM(AA58:AA65)","v":6201.22},null,6201.22,null,{"$f":"SUM(AE58:AE65)","v":3652.38},null,2652.38,null,{"$f":"SUM(AI58:AI65)","v":6539.96}]
[null,"Visados",null,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,16.34,null,15.68,null,15.68,null,16.34]
[null,"Inspección técnica de vehículos (I.T.V.) (€)",null,null,111.92,null,111.92,null,111.92,null,111.92,null,111.92,null,68.09,null,111.92,null,111.92,null,111.92,null,111.92,null,68.09,null,111.92,null,111.92,null,51.44,null,51.44,null,111.92]
[null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo (€)",null,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,354.07,null,290.22,null,290.22,null,354.07]
[null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.) (€)",null,null,304.82,null,304.82,null,304.82,null,304.82,null,304.82,null,217.06,null,304.82,null,304.82,null,304.82,null,304.82,null,217.06,null,304.82,null,304.82,null,152.4,null,152.4,null,304.82]
[null,"Revisión tacógrafo (€)",null,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,82.34,null,null,null,82.34]
[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,75.8,null,75.8,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,130.68,null,692.64,null,692.64,null,null,null,null,null,null,null,null,null,null,null,null,null,0.0]
[null,"Otros costes fiscales (€)",null,null,28.75,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":898.24},null,{"$f":"SUM(G67:G74)","v":869.49},null,{"$f":"SUM(I67:I74)","v":869.49},null,869.49,null,{"$f":"SUM(M67:M74)","v":869.49},null,{"$f":"SUM(O67:O74)","v":737.9},null,{"$f":"SUM(Q67:Q74)","v":1000.17},null,{"$f":"SUM(S67:S74)","v":1562.13},null,1562.13,null,{"$f":"SUM(W67:W74)","v":945.29},null,{"$f":"SUM(Y67:Y74)","v":813.7},null,{"$f":"SUM(AA67:AA74)","v":869.49},null,869.49,null,{"$f":"SUM(AE67:AE74)","v":592.08},null,{"$f":"SUM(AG67:AG74)","v":509.74},null,{"$f":"SUM(AI67:AI74)","v":869.49}]
[null,"SEGUROS Y COSTES FISCALES",null,null,{"$f":"E66+E75","v":7438.2},null,{"$f":"G66+G75","v":7409.45},null,{"$f":"I66+I75","v":7100.84},null,7100.84,null,{"$f":"M66+M75","v":6918.52},null,{"$f":"O66+O75","v":4927.02},null,{"$f":"Q66+Q75","v":8650.8},null,{"$f":"S66+S75","v":9581.24},null,9581.24,null,{"$f":"W66+W75","v":8705.12},null,{"$f":"Y66+Y75","v":5749.84},null,{"$f":"AA66+AA75","v":7070.71},null,7070.71,null,{"$f":"AE66+AE75","v":4244.46},null,{"$f":"AG66+AG75","v":3162.12},null,{"$f":"AI66+AI75","v":7409.45}]
[null,"Precio del carburante, con IVA (€/litro)",null,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877,null,1.6877]
[null,"Descuento (%, €/litro)",null,6.73,{"$f":"ROUND(E77*D78/100,4)","v":0.11},6.73,{"$f":"ROUND(G77*F78/100,4)","v":0.11},6.73,{"$f":"ROUND(I77*H78/100,4)","v":0.11},6.73,{"$f":"ROUND(K77*J78/100,4)","v":0.11},6.73,{"$f":"ROUND(M77*L78/100,4)","v":0.11},6.73,{"$f":"ROUND(O77*N78/100,4)","v":0.11},6.73,{"$f":"ROUND(Q77*P78/100,4)","v":0.11},6.73,{"$f":"ROUND(S77*R78/100,4)","v":0.11},6.73,{"$f":"ROUND(U77*T78/100,4)","v":0.11},6.73,{"$f":"ROUND(W77*V78/100,4)","v":0.11},6.73,{"$f":"ROUND(Y77*X78/100,4)","v":0.11},6.73,{"$f":"ROUND(AA77*Z78/100,4)","v":0.11},6.73,{"$f":"ROUND(AC77*AB78/100,4)","v":0.11},3.83,{"$f":"ROUND(AE77*AD78/100,4)","v":0.06},3.83,{"$f":"ROUND(AG77*AF78/100,4)","v":0.06},6.73,{"$f":"ROUND(AI77*AH78/100,4)","v":0.11}]
[null,"IVA aplicado al carburante (%)(€/litro)",null,21.0,{"$f":"ROUND((D79/100)*(E77-E78)/(1+D79/100),2)","v":0.27},21.0,{"$f":"ROUND((F79/100)*(G77-G78)/(1+F79/100),2)","v":0.27},21.0,{"$f":"ROUND((H79/100)*(I77-I78)/(1+H79/100),2)","v":0.27},21.0,{"$f":"ROUND((J79/100)*(K77-K78)/(1+J79/100),2)","v":0.27},21.0,{"$f":"ROUND((L79/100)*(M77-M78)/(1+L79/100),2)","v":0.27},21.0,{"$f":"ROUND((N79/100)*(O77-O78)/(1+N79/100),2)","v":0.27},21.0,{"$f":"ROUND((P79/100)*(Q77-Q78)/(1+P79/100),2)","v":0.27},21.0,{"$f":"ROUND((R79/100)*(S77-S78)/(1+R79/100),2)","v":0.27},21.0,{"$f":"ROUND((T79/100)*(U77-U78)/(1+T79/100),2)","v":0.27},21.0,{"$f":"ROUND((V79/100)*(W77-W78)/(1+V79/100),2)","v":0.27},21.0,{"$f":"ROUND((X79/100)*(Y77-Y78)/(1+X79/100),2)","v":0.27},21.0,{"$f":"ROUND((Z79/100)*(AA77-AA78)/(1+Z79/100),2)","v":0.27},21.0,{"$f":"ROUND((AB79/100)*(AC77-AC78)/(1+AB79/100),2)","v":0.27},21.0,{"$f":"ROUND((AD79/100)*(AE77-AE78)/(1+AD79/100),2)","v":0.28},21.0,{"$f":"ROUND((AF79/100)*(AG77-AG78)/(1+AF79/100),2)","v":0.28},21.0,{"$f":"ROUND((AH79/100)*(AI77-AI78)/(1+AH79/100),2)","v":0.27}]
[null,"Precio carburante sin IVA (€/litro)",null,null,{"$f":"ROUND((E77-E78)/(1+D79/100),2)","v":1.3},null,{"$f":"ROUND((G77-G78)/(1+F79/100),2)","v":1.3},null,{"$f":"ROUND((I77-I78)/(1+H79/100),2)","v":1.3},null,{"$f":"ROUND((K77-K78)/(1+J79/100),2)","v":1.3},null,{"$f":"ROUND((M77-M78)/(1+L79/100),2)","v":1.3},null,{"$f":"ROUND((O77-O78)/(1+N79/100),2)","v":1.3},null,{"$f":"ROUND((Q77-Q78)/(1+P79/100),2)","v":1.3},null,{"$f":"ROUND((S77-S78)/(1+R79/100),2)","v":1.3},null,{"$f":"ROUND((U77-U78)/(1+T79/100),2)","v":1.3},null,{"$f":"ROUND((W77-W78)/(1+V79/100),2)","v":1.3},null,{"$f":"ROUND((Y77-Y78)/(1+X79/100),2)","v":1.3},null,{"$f":"ROUND((AA77-AA78)/(1+Z79/100),2)","v":1.3},null,{"$f":"ROUND((AC77-AC78)/(1+AB79/100),2)","v":1.3},null,{"$f":"ROUND((AE77-AE78)/(1+AD79/100),2)","v":1.35},null,{"$f":"ROUND((AG77-AG78)/(1+AF79/100),2)","v":1.35},null,{"$f":"ROUND((AI77-AI78)/(1+AH79/100),2)","v":1.3}]
[null,"GASTO TOTAL ANUAL EN CARBURANTE DEL VEHÍCULO (€, SIN IVA)",null,null,{"$f":"ROUND(E9/100*E12*E80,0)","v":68250.0},null,{"$f":"ROUND(G9/100*G12*G80,0)","v":54600.0},null,{"$f":"ROUND(I9/100*I12*I80,0)","v":45500.0},null,{"$f":"ROUND(K9/100*K12*K80,0)","v":45500.0},null,{"$f":"ROUND(M9/100*M12*M80,0)","v":30030.0},null,{"$f":"ROUND(O9/100*O12*O80,0)","v":29250.0},null,{"$f":"ROUND(Q9/100*Q12*Q80,0)","v":47093.0},null,{"$f":"ROUND(S9/100*S12*S80,0)","v":44850.0},null,{"$f":"ROUND(U9/100*U12*U80,0)","v":44850.0},null,{"$f":"ROUND(W9/100*W12*W80,0)","v":54600.0},null,{"$f":"ROUND(Y9/100*Y12*Y80,0)","v":22750.0},null,{"$f":"ROUND(AA9/100*AA12*AA80,0)","v":54600.0},null,{"$f":"ROUND(AC9/100*AC12*AC80,0)","v":54600.0},null,{"$f":"ROUND(AE9/100*AE12*AE80,0)","v":7763.0},null,{"$f":"ROUND(AG9/100*AG12*AG80,0)","v":7763.0},null,{"$f":"ROUND(AI9/100*AI12*AI80,0)","v":54600.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.2584,null,1.2584,null,null,null,null,null,null,null,null,null,0.0]
[null,"Descuento (%, €)  ",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,"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.22},null,{"$f":"(Y84/100)*(Y82-Y83)/(1+Y84/100)","v":0.22},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":1.04},null,{"$f":"(Y82-Y83)/(1+Y84/100)","v":1.04},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":8320.0},null,{"$f":"Y86*Y87*Y88","v":6240.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,676.14,null,676.14,null,676.14,null,676.14,null,676.14,null,716.91,null,676.14,null,676.14,null,676.14,null,676.14,null,716.91,null,676.14,null,676.14,null,196.8,null,196.8,null,676.14]
[null,"Precio sin IVA de un neumático motriz (€)",null,null,676.14,null,676.14,null,676.14,null,676.14,null,676.14,null,716.91,null,676.14,null,676.14,null,676.14,null,676.14,null,716.91,null,676.14,null,676.14,null,196.8,null,196.8,null,676.14]
[null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,676.14,null,676.14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,676.14]
[null,"Precio sin IVA de un neumático remolque-semirremolque (€)",null,null,676.14,null,676.14,null,676.14,null,676.14,null,676.14,null,null,null,676.14,null,676.14,null,676.14,null,676.14,null,null,null,676.14,null,676.14,null,null,null,null,null,676.14]
[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":8113.68},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":6490.94},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":6310.64},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":6310.64},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":11359.15},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":3097.05},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":5679.58},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":5409.12},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":5409.12},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":6490.94},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":2408.82},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":6490.94},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":6490.94},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":656.0},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":656.0},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":6490.94}]
[null,"Coste de mantenimiento por km, sin IVA (€/km)",null,null,0.0172,null,0.0172,null,0.0206,null,0.0206,null,0.0696,null,0.0204,null,0.0556,null,0.0556,null,0.0556,null,0.0204,null,0.0271,null,0.0172,null,0.0172,null,0.0098,null,0.098,null,0.0172]
[null,"GASTO ANUAL EN MANTENIMIENTO, SIN IVA (€)",null,null,{"$f":"E103*E9","v":2580.0},null,{"$f":"G103*G9","v":2064.0},null,{"$f":"I103*I9","v":2060.0},null,2060.0,null,{"$f":"M103*M9","v":4176.0},null,{"$f":"O103*O9","v":1836.0},null,{"$f":"Q103*Q9","v":5838.0},null,{"$f":"S103*S9","v":5560.0},null,5560.0,null,{"$f":"W103*W9","v":2448.0},null,{"$f":"Y103*Y9","v":1897.0},null,{"$f":"AA103*AA9","v":2064.0},null,2064.0,null,{"$f":"AE103*AE9","v":490.0},null,{"$f":"AG103*AG9","v":4900.0},null,{"$f":"AI103*AI9","v":2064.0}]
[null,"Coste de reparaciones por km, sin IVA (€/km)",null,null,0.0339,null,0.0339,null,0.0339,null,0.0339,null,0.0436,null,0.0271,null,0.0428,null,0.0428,null,0.0428,null,0.0428,null,0.0339,null,0.0339,null,0.0339,null,0.0174,null,0.0174,null,0.0339]
[null,"GASTO ANUAL EN REPARACIONES, SIN IVA (€)",null,null,{"$f":"E105*E9","v":5085.0},null,{"$f":"G105*G9","v":4068.0},null,{"$f":"I105*I9","v":3390.0},null,3390.0,null,{"$f":"M105*M9","v":2616.0},null,{"$f":"O105*O9","v":2439.0},null,{"$f":"Q105*Q9","v":4494.0},null,{"$f":"S105*S9","v":4280.0},null,4280.0,null,{"$f":"W105*W9","v":5136.0},null,{"$f":"Y105*Y9","v":2373.0},null,{"$f":"AA105*AA9","v":4068.0},null,4068.0,null,{"$f":"AE105*AE9","v":870.0},null,{"$f":"AG105*AG9","v":870.0},null,{"$f":"AI105*AI9","v":4068.0}]
[null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,null,17642.53,null,2195.51,null,1829.6,null,1829.6,null,0.0,null,1411.41,null,9605.39,null,9147.98,null,9147.98,null,2195.51,null,1097.76,null,2195.51,null,2195.51,null,0.0,null,0.0,null,2195.51]
[null,"COSTES VARIABLES",null,null,{"$f":"ROUND(E81+E89+E102+E104+E106+E107,0)","v":101671.21},null,{"$f":"ROUND(G81+G89+G102+G104+G106+G107,0)","v":69418.45},null,{"$f":"ROUND(I81+I89+I102+I104+I106+I107,0)","v":59090.24},null,{"$f":"ROUND(K81+K89+K102+K104+K106+K107,0)","v":59090.24},null,{"$f":"ROUND(M81+M89+M102+M104+M106+M107,0)","v":48181.15},null,{"$f":"ROUND(O81+O89+O102+O104+O106+O107,0)","v":38033.46},null,{"$f":"ROUND(Q81+Q89+Q102+Q104+Q106+Q107,0)","v":72709.97},null,{"$f":"ROUND(S81+S89+S102+S104+S106+S107,0)","v":69247.1},null,{"$f":"ROUND(U81+U89+U102+U104+U106+U107,0)","v":69247.1},null,{"$f":"ROUND(W81+W89+W102+W104+W106+W107,0)","v":79190.45},null,{"$f":"ROUND(Y81+Y89+Y102+Y104+Y106+Y107,0)","v":36766.58},null,{"$f":"ROUND(AA81+AA89+AA102+AA104+AA106+AA107,0)","v":69418.45},null,{"$f":"ROUND(AC81+AC89+AC102+AC104+AC106+AC107,0)","v":69418.45},null,{"$f":"ROUND(AE81+AE89+AE102+AE104+AE106+AE107,0)","v":9779.0},null,{"$f":"ROUND(AG81+AG89+AG102+AG104+AG106+AG107,0)","v":14189.0},null,{"$f":"ROUND(AI81+AI89+AI102+AI104+AI106+AI107,0)","v":69418.45}]
[null,"Coste anual estructura(gestión, administración,) repercutible a este vehículo",null,null,{"$f":"E$112/3","v":4328.33},null,{"$f":"G$112/3","v":3143.09},null,{"$f":"I$112/3","v":2745.27},null,{"$f":"K$112/3","v":2745.27},null,{"$f":"M$112/3","v":2370.18},null,{"$f":"O$112/3","v":2023.23},null,{"$f":"Q$112/3","v":3357.7},null,{"$f":"S$112/3","v":3381.9},null,{"$f":"U$112/3","v":3381.9},null,{"$f":"W$112/3","v":3431.62},null,{"$f":"Y$112/3","v":2029.95},null,{"$f":"AA$112/3","v":3101.02},null,3101.02,null,{"$f":"AE$112/3","v":1112.93},null,1112.93,null,{"$f":"AI$112/3","v":3143.09}]
[null,"Coste anual comercialización repercutible a este vehículo",null,null,{"$f":"E$112/3","v":4328.33},null,3143.09,null,2745.27,null,2745.27,null,2370.18,null,2023.23,null,3357.7,null,3381.9,null,3381.9,null,3431.62,null,2029.95,null,3101.02,null,3101.02,null,1112.93,null,1112.93,null,3143.09]
[null,"Otros costes indirectos anuales repercutibles a este vehículo",null,null,4328.33,null,3143.09,null,2745.27,null,2745.27,null,2370.18,null,2023.23,null,3357.69,null,3381.9,null,3381.9,null,3431.62,null,2029.95,null,3101.02,null,3101.02,null,1112.93,null,1112.93,null,3143.09]
[null,"COSTES INDIRECTOS",null,null,{"$f":"6.5/100*(E50+E57+E76+E108)","v":12984.99},null,{"$f":"6.5/100*(G50+G57+G76+G108)","v":9429.27},null,{"$f":"6.5/100*(I50+I57+I76+I108)","v":8235.81},null,{"$f":"6.5/100*(K50+K57+K76+K108)","v":8235.81},null,{"$f":"6.5/100*(M50+M57+M76+M108)","v":7110.54},null,{"$f":"6.5/100*(O50+O57+O76+O108)","v":6069.69},null,{"$f":"6.5/100*(Q50+Q57+Q76+Q108)","v":10073.09},null,{"$f":"6.5/100*(S50+S57+S76+S108)","v":10145.7},null,{"$f":"6.5/100*(U50+U57+U76+U108)","v":10145.7},null,{"$f":"6.5/100*(W50+W57+W76+W108)","v":10294.86},null,{"$f":"6.5/100*(Y50+Y57+Y76+Y108)","v":6089.85},null,{"$f":"6.5/100*(AA50+AA57+AA76+AA108)","v":9303.06},null,{"$f":"6.5/100*(AC50+AC57+AC76+AC108)","v":9303.06},null,{"$f":"6.5/100*(AE50+AE57+AE76+AE108)","v":3338.79},null,{"$f":"6.5/100*(AG50+AG57+AG76+AG108)","v":3338.79},null,{"$f":"6.5/100*(AI50+AI57+AI76+AI108)","v":9429.27}]
[null,"COSTES TOTALES",null,null,{"$f":"(E50+E57+E76+E108)+E112","v":0},null,{"$f":"(G50+G57+G76+G108)+G112","v":0},null,{"$f":"(I50+I57+I76+I108)+I112","v":0},null,{"$f":"(K50+K57+K76+K108)+K112","v":0},null,{"$f":"(M50+M57+M76+M108)+M112","v":0},null,{"$f":"(O50+O57+O76+O108)+O112","v":0},null,{"$f":"(Q50+Q57+Q76+Q108)+Q112","v":0},null,{"$f":"(S50+S57+S76+S108)+S112","v":0},null,{"$f":"(U50+U57+U76+U108)+U112","v":0},null,{"$f":"(W50+W57+W76+W108)+W112","v":0},null,{"$f":"(Y50+Y57+Y76+Y108)+Y112","v":0},null,{"$f":"(AA50+AA57+AA76+AA108)+AA112","v":0},null,0,null,{"$f":"(AE50+AE57+AE76+AE108)+AE112","v":0},null,{"$f":"(AG50+AG57+AG76+AG108)+AG112","v":0},null,{"$f":"(AI50+AI57+AI76+AI108)+AI112","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Valor de adquisición del vehículo sin IVA y sin neumáticos (€)",null,null,{"$f":"E21-(E90*E94+E91*E95)","v":0},null,{"$f":"G21-(G90*G94+G91*G95)","v":0},null,{"$f":"I21-(I90*I94+I91*I95)","v":0},null,{"$f":"K21-(K90*K94+K91*K95)","v":0},null,{"$f":"M21-(M90*M94+M91*M95)","v":0},null,{"$f":"O21-(O90*O94+O91*O95)","v":0},null,{"$f":"Q21-(Q90*Q94+Q91*Q95)","v":0},null,{"$f":"S21-(S90*S94+S91*S95)","v":0},null,{"$f":"U21-(U90*U94+U91*U95)","v":0},null,{"$f":"W21-(W90*W94+W91*W95)","v":0},null,{"$f":"Y21-(Y90*Y94+Y91*Y95)","v":0},null,{"$f":"AA21-(AA90*AA94+AA91*AA95)","v":0},null,{"$f":"AC21-(AC90*AC94+AC91*AC95)","v":0},null,{"$f":"AE21-(AE90*AE94+AE91*AE95)","v":0},null,{"$f":"AG21-(AG90*AG94+AG91*AG95)","v":0},null,{"$f":"AI21-(AI90*AI94+AI91*AI95)","v":0}]
[null,"Valor de adquisición del remolque-semirremolque sin IVA y sin neumáticos (€)",null,null,{"$f":"E37-(E93*E97)","v":0},null,{"$f":"G37-(G93*G97)","v":0},null,{"$f":"I37-(I93*I97)","v":0},null,{"$f":"K37-(K93*K97)","v":0},null,{"$f":"M37-(M93*M97)","v":0},null,{"$f":"O37-(O93*O97)","v":0},null,{"$f":"Q37-(Q93*Q97)","v":0},null,{"$f":"S37-(S93*S97)","v":0},null,{"$f":"U37-(U93*U97)","v":0},null,{"$f":"W37-(W93*W97)","v":0},null,{"$f":"Y37-(Y93*Y97)","v":0},null,{"$f":"AA37-(AA93*AA97)","v":0},null,{"$f":"AC37-(AC93*AC97)","v":0},null,{"$f":"AE37-(AE93*AE97)","v":0},null,{"$f":"AG37-(AG93*AG97)","v":0},null,{"$f":"AI37-(AI93*AI97)","v":0}]
[null,"Dietas y plus de actividad anuales del conductor (€)",null,null,{"$f":"E54+E56","v":0},null,{"$f":"G54+G56","v":0},null,{"$f":"I54+I56","v":0},null,{"$f":"K54+K56","v":0},null,{"$f":"M54+M56","v":0},null,{"$f":"O54+O56","v":0},null,{"$f":"Q54+Q56","v":0},null,{"$f":"S54+S56","v":0},null,{"$f":"U54+U56","v":0},null,{"$f":"W54+W56","v":0},null,{"$f":"Y54+Y56","v":0},null,{"$f":"AA54+AA56","v":0},null,{"$f":"AC54+AC56","v":0},null,{"$f":"AE54+AE56","v":0},null,{"$f":"AG54+AG56","v":0},null,{"$f":"AI54+AI56","v":0}]
[null,"Gasto anual en mantenimiento, sin IVA (€)",null,null,{"$f":"E104+E106","v":0},null,{"$f":"G104+G106","v":0},null,{"$f":"I104+I106","v":0},null,{"$f":"K104+K106","v":0},null,{"$f":"M104+M106","v":0},null,{"$f":"O104+O106","v":0},null,{"$f":"Q104+Q106","v":0},null,{"$f":"S104+S106","v":0},null,{"$f":"U104+U106","v":0},null,{"$f":"W104+W106","v":0},null,{"$f":"Y104+Y106","v":0},null,{"$f":"AA104+AA106","v":0},null,{"$f":"AC104+AC106","v":0},null,{"$f":"AE104+AE106","v":0},null,{"$f":"AG104+AG106","v":0},null,{"$f":"AI104+AI106","v":0}]
[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":0},null,{"$f":"IFERROR((G90*G94/G98),0)+IFERROR((G91*G95/G99),0)+IFERROR((G92*G96/G100),0)+IFERROR((G93*G97/G101),0)","v":0},null,{"$f":"IFERROR((I90*I94/I98),0)+IFERROR((I91*I95/I99),0)+IFERROR((I92*I96/I100),0)+IFERROR((I93*I97/I101),0)","v":0},null,{"$f":"IFERROR((K90*K94/K98),0)+IFERROR((K91*K95/K99),0)+IFERROR((K92*K96/K100),0)+IFERROR((K93*K97/K101),0)","v":0},null,{"$f":"IFERROR((M90*M94/M98),0)+IFERROR((M91*M95/M99),0)+IFERROR((M92*M96/M100),0)+IFERROR((M93*M97/M101),0)","v":0},null,{"$f":"IFERROR((O90*O94/O98),0)+IFERROR((O91*O95/O99),0)+IFERROR((O92*O96/O100),0)+IFERROR((O93*O97/O101),0)","v":0},null,{"$f":"IFERROR((Q90*Q94/Q98),0)+IFERROR((Q91*Q95/Q99),0)+IFERROR((Q92*Q96/Q100),0)+IFERROR((Q93*Q97/Q101),0)","v":0},null,{"$f":"IFERROR((S90*S94/S98),0)+IFERROR((S91*S95/S99),0)+IFERROR((S92*S96/S100),0)+IFERROR((S93*S97/S101),0)","v":0},null,{"$f":"IFERROR((U90*U94/U98),0)+IFERROR((U91*U95/U99),0)+IFERROR((U92*U96/U100),0)+IFERROR((U93*U97/U101),0)","v":0},null,{"$f":"IFERROR((W90*W94/W98),0)+IFERROR((W91*W95/W99),0)+IFERROR((W92*W96/W100),0)+IFERROR((W93*W97/W101),0)","v":0},null,{"$f":"IFERROR((Y90*Y94/Y98),0)+IFERROR((Y91*Y95/Y99),0)+IFERROR((Y92*Y96/Y100),0)+IFERROR((Y93*Y97/Y101),0)","v":0},null,{"$f":"IFERROR((AA90*AA94/AA98),0)+IFERROR((AA91*AA95/AA99),0)+IFERROR((AA92*AA96/AA100),0)+IFERROR((AA93*AA97/AA101),0)","v":0},null,{"$f":"IFERROR((AC90*AC94/AC98),0)+IFERROR((AC91*AC95/AC99),0)+IFERROR((AC92*AC96/AC100),0)+IFERROR((AC93*AC97/AC101),0)","v":0},null,{"$f":"IFERROR((AE90*AE94/AE98),0)+IFERROR((AE91*AE95/AE99),0)+IFERROR((AE92*AE96/AE100),0)+IFERROR((AE93*AE97/AE101),0)","v":0},null,{"$f":"IFERROR((AG90*AG94/AG98),0)+IFERROR((AG91*AG95/AG99),0)+IFERROR((AG92*AG96/AG100),0)+IFERROR((AG93*AG97/AG101),0)","v":0},null,{"$f":"IFERROR((AI90*AI94/AI98),0)+IFERROR((AI91*AI95/AI99),0)+IFERROR((AI92*AI96/AI100),0)+IFERROR((AI93*AI97/AI101),0)","v":0}]

{"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":"T16"},"Vehículo genérico (para todos aquellos vehículos que no puedan ser englobados en las categorías anteriores)"]
[]
[null,null,"¿Desea comenzar la simulación con los datos estadísticos añadidos a los formularios de cálculo?"]

{"sheet":"Características Vehículo","index":3,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,9,10,13]]}
[]
[]
[]
[]
[]
[null,null,"1. Características del vehículo"]
[]
[]
[null,null,"Características técnicas del vehiculo",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Descripción:",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$E$1:$AI$284,2,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$E$1:$AI$284,2,0))","v":"Vehículo genérico (para todos aquellos vehículos que no puedan ser englobados en las categorías anteriores)"}]
[]
[null,null,"Potencia:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,4,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,4,0))","v":""}]
[]
[null,null,"MMA (Tm):",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,5,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,5,0))","v":""}]
[]
[null,null,"Carga útil:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,6,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,6,0))","v":""}]
[]
[null,null,"Número de ejes:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,7,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,7,0))","v":""}]
[]
[null,null,"Número de neumáticos:",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,8,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,8,0))","v":""}]
[]
[null,null,"Características de explotación del vehículo",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Kilómetros recorridos anualmente",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,9,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,9,0))","v":""}]
[]
[null,null,"Kilometros recorridos anualmente en carga (%,km) €",null,null,null,null,null,"%",{"$f":"ROUND(J25*H27/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,10,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,10,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,10,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,10,0))","v":0}]
[]
[null,null,"Kilometros recorridos anualmente en vacío (%,km) €",null,null,null,null,{"$f":"100-H27","v":100},"%",{"$f":"ROUND(J25-J27,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,11,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,11,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,11,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,11,0))","v":0}]
[]
[null,null,"Consumo medio (litros/100km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,12,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,12,0))","v":""}]
[]
[null,null,"Horas trabajadas al año",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,13,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,13,0))","v":""}]
[]
[null,null,"Horas trabajadas al año en carga (%,h)",null,null,null,null,null,"%",{"$f":"ROUND(J33*H35/100,2)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,14,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,14,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,14,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,14,0))","v":0}]
[]
[null,null,"Horas trabajadas al año en vacío (%,h)",null,null,null,null,{"$f":"100-H35","v":100},"%",{"$f":"J33-J35","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,15,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,15,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,15,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,15,0))","v":0}]
[]
[null,null,"Dias trabajados al año",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,16,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,16,0))","v":""}]
[]
[null,null,"Horas trabajadas por jornada",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(J33/J39,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,17,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,17,0))","v":{"$error":"#DIV/0!"}}]

{"sheet":"Costes Adquisición","index":4,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[10,7,10,8],[34,7,34,8],[58,7,58,8],[82,7,82,8]]}
[]
[]
[]
[]
[]
[null,null,"2. Costes de adquisición"]
[]
[]
[null,null,"Vehículo de Tracción",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AX$284,3,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AX$284,3,0))","v":""}]
[null,null,"Forma de adquisición:",null,null,null,null,"COMPRA"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,0,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,18,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,18,0))","v":""}]
[]
[null,null,"Compra del vehículo de tracción (€) "]
[]
[null,null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,19,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,19,0))","v":""}]
[]
[null,null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,20,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,20,0))","v":""}]
[]
[null,null,"Precio de adquisición sin IVA (€)",null,null,null,null,{"$f":"ROUND((1-H19/100)*H17,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,21,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,21,0))","v":0}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,22,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,22,0))","v":""}]
[]
[null,null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,23,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,23,0))","v":""}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,{"$f":"ROUND(H25/100*H17,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,23,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,23,0))","v":0}]
[]
[null,null,"AMORTIZACIÓN DEL VEHÍCULO DE TRACCIÓN",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H11=T!F2,ROUND((H21-H27-('Costes Variables'!J$41*'Costes Variables'!J$49)-('Costes Variables'!J$43*'Costes Variables'!J$51)-('Costes Variables'!J$45*'Costes Variables'!J$53))*(1/H23),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,24,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,24,0))","v":0}]
[]
[null,null,"GASTOS FINANCIEROS DEL VEHÍCULO DE TRACCIÓN",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H11=T!F2,ROUND((H21-H27-('Costes Variables'!J$41*'Costes Variables'!J$49)-('Costes Variables'!J$43*'Costes Variables'!J$51)-('Costes Variables'!J$45*'Costes Variables'!J$53))*(-(1/H23)+J$10/(1-POWER(1+J$10,-H23))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,25,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,25,0))","v":0}]
[]
[null,null,"Carrozado del vehículo",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Forma de adquisición: ",null,null,null,null,"Compra"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,26,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,26,0))","v":0}]
[]
[null,null,"Compra carrozado (€) "]
[]
[null,null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,27,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,27,0))","v":0}]
[]
[null,null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,28,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,28,0))","v":0}]
[]
[null,null,"Precio de adquisición sin IVA (€)",null,null,null,null,{"$f":"(1-H43/100)*H41","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,29,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,29,0))","v":0}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,30,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,30,0))","v":0}]
[]
[null,null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,31,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,31,0))","v":0}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,{"$f":"ROUND(H49/100*H41,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,31,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,31,0))","v":0}]
[]
[null,null,"AMORTIZACIÓN CARROZADO",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H35=T!F2,ROUND((H45-H51)*(1/H47),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,32,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,32,0))","v":0}]
[]
[null,null,"GASTOS FINANCIEROS CARROZADO",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H35=T!F2,ROUND((H45-H51)*(-(1/H47)+J$10/(1-POWER(1+J$10,-H47))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,33,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,33,0))","v":0}]
[]
[null,null,"Semirremolque o remolque ",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Forma de adquisición: ",null,null,null,null,"COMPRA"]
[]
[null,null,"Pago de alquiler o leasing anual (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,34,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,34,0))","v":""}]
[]
[null,null,"Compra remolque o semiremolque (€) "]
[]
[null,null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,35,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,35,0))","v":""}]
[]
[null,null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,36,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,36,0))","v":""}]
[]
[null,null,"Precio de adquisición sin IVA (€)",null,null,null,null,{"$f":"(1-H67/100)*H65","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,37,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,37,0))","v":0}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,38,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,38,0))","v":""}]
[]
[null,null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,39,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,39,0))","v":""}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,{"$f":"ROUND(H73/100*H65,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,39,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,39,0))","v":0}]
[]
[null,null,"AMORTIZACIÓN REMOLQUE",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H59=T!F2,ROUND((H69-H75-('Costes Variables'!J47*'Costes Variables'!J55))*(1/H71),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,40,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,40,0))","v":0}]
[]
[null,null,"GASTOS FINANCIEROS REMOLQUE",null,null,null,null,{"$f":"ROUND(IFERROR(IF(H59=T!F2,ROUND((H69-H75-('Costes Variables'!J$47*'Costes Variables'!J$55))*(-(1/H71)+J$10/(1-POWER(1+J$10,-H71))),2),0),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,41,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,41,0))","v":0}]
[]
[null,null,"Equipos auxiliares",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Forma de adquisición: ",null,null,null,null,"Compra"]
[]
[null,null,"Pago de leasing o renta anual (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,42,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,42,0))","v":0}]
[]
[null,null,"Compra de los equipos (€) "]
[]
[null,null,"Precio de tarifa sin IVA (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,43,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,43,0))","v":0}]
[]
[null,null,"Descuento sobre tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,44,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,44,0))","v":0}]
[]
[null,null,"Precio de adquisición sin IVA (€)",null,null,null,null,{"$f":"(1-H91/100)*H89","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,45,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,45,0))","v":0}]
[]
[null,null,"Vida útil (años)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,46,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,46,0))","v":0}]
[]
[null,null,"Valor residual sobre precio de tarifa (%)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,47,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,47,0))","v":0}]
[]
[null,null,"Valor residual sin IVA (€)",null,null,null,null,{"$f":"H97/100*H89","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,47,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,47,0))","v":0}]
[]
[null,null,"AMORTIZACIÓN EQUIPOS",null,null,null,null,{"$f":"IFERROR(IF(H83=T!F2,ROUND((H93-H99)*(1/H95),2),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,48,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,48,0))","v":0}]
[]
[null,null,"GASTOS FINANCIEROS EQUIPOS",null,null,null,null,{"$f":"IFERROR(IF(H83=T!F2,ROUND((H93-H99)*(-(1/H95)+J$10/(1-POWER(1+J$10,-H95))),2),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,49,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,49,0))","v":0}]
[]
[null,null,"COSTES DE ADQUISICIÓN",null,null,null,null,{"$f":"ROUND(H13+H29+H31+H37+H53+H55+H61+H77+H79+H85+H101+H103,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,50,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,50,0))","v":0}]

{"sheet":"Costes Personal","index":5,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"3. Costes de personal"]
[]
[]
[null,null,"Costes de Personal",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[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$282,51,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,51,0))","v":""}]
[]
[null,null,"Dieta total diaria del conductor (€/día)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,52,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,52,0))","v":""}]
[]
[null,null,"Número de días con dieta al año",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,53,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,53,0))","v":""}]
[]
[null,null,"Dietas totales anuales (€)",null,null,null,null,{"$f":"H15*H13","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,54,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,54,0))","v":0}]
[]
[null,null,"Plus anual de actividad del conductor (€/km)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,55,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,55,0))","v":""}]
[]
[null,null,"Plus anual de actividad del conductor (€)",null,null,null,null,{"$f":"H19*'Características Vehículo'!J25","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,56,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,56,0))","v":0}]
[]
[null,null,"COSTES DE PERSONAL",null,null,null,null,{"$f":"H11+H17+H21","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,57,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,57,0))","v":0}]

{"sheet":"Seguros y Costes Fiscales","index":6,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"4. Seguros y costes fiscales"]
[]
[]
[null,null,"Seguros",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Responsabilidad civil del vehículo de tracción (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,58,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,58,0))","v":""}]
[]
[null,null,"Responsabilidad civil del remolque o semirremolque (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,59,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,59,0))","v":""}]
[]
[null,null,"Responsabilidad civil de la mercancía (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,60,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,60,0))","v":""}]
[]
[null,null,"Accidente del conductor (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,61,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,61,0))","v":""}]
[]
[null,null,"Retirada del carné de conducir (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,62,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,62,0))","v":""}]
[]
[null,null,"Seguro de la mercancía (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,63,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,63,0))","v":""}]
[]
[null,null,"Daños propios (seguro todo riesgo) (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,64,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,64,0))","v":""}]
[]
[null,null,"Otros seguros (€)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,65,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,65,0))","v":""}]
[]
[null,null,"COSTE TOTAL ANUAL DE LOS SEGUROS (€)",null,null,null,null,{"$f":"H11+H13+H15+H17+H19+H21+H23+H25","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,66,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,66,0))","v":0}]
[]
[null,null,"Costes fiscales",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Visados",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,67,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,67,0))","v":""}]
[]
[null,null,"Inspección técnica de vehículos (I.T.V.)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,68,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,68,0))","v":""}]
[]
[null,null,"Impuesto de actividades económicas (I.A.E.) repercutible a este vehículo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,69,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,69,0))","v":""}]
[]
[null,null,"Impuesto de Vehículos de Tracción Mecánica (I.T.V.M.)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,70,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,70,0))","v":""}]
[]
[null,null,"Revisión tacógrafo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,71,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,71,0))","v":""}]
[]
[null,null,"Inspecciones A.T.P. (transporte mercancías perecederas)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,72,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,72,0))","v":0}]
[]
[null,null,"Inspecciones A.D.R. (transporte mercancías peligrosas)",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,73,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,73,0))","v":0}]
[]
[null,null,"Otros costes fiscales",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,74,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,74,0))","v":""}]
[]
[null,null,"COSTE FISCAL TOTAL ANUAL",null,null,null,null,{"$f":"H31+H33+H35+H37+H39+H41+H43+H45","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,75,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,75,0))","v":0}]
[]
[null,null,"SEGUROS Y COSTES FISCALES ",null,null,null,null,{"$f":"H27+H47","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,76,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,76,0))","v":0}]

{"sheet":"Costes Variables","index":7,"n_rows":83,"n_cols":13,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"5. Costes variables"]
[]
[]
[null,null,"Carburante del vehículo",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Precio del carburante con IVA (€/litro)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,77,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,77,0))","v":""}]
[]
[null,null,"Descuento (%, €/litro)  ",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H13/100)*(J11),2),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,78,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,78,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,78,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,78,0))","v":0}]
[]
[null,null,"IVA aplicado al carburante (%)  (€/litro)",null,null,null,null,null,"%",{"$f":"IFERROR(ROUND((H15/100)*(J11-J13)/(1+H15/100),2),0)","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,79,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,79,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,79,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,79,0))","v":0}]
[]
[null,null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J11-J13)/(1+H15/100),2),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,80,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,80,0))","v":0}]
[]
[null,null,"GASTO TOTAL ANUAL EN CARBURANTE DEL VEHÍCULO (€)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND(('Características Vehículo'!J25/100)*'Características Vehículo'!J31*J17,0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,81,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,81,0))","v":0}]
[]
[null,null,"Carburante de los equipos ",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Precio de compra de carburante",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,82,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,82,0))","v":0}]
[null,null,null,null,null,null,null,null,null,35]
[null,null,"Descuento (%, €)  ",null,null,null,null,null,"%",{"$f":"(H25/100)*J23","v":0},{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,83,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,83,0))","v":0},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,83,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,83,0))","v":0}]
[]
[null,null,"IVA aplicado al carburante (%)",null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,88,0)=\"\",\"\",HLOOKUP(CONCATENATE('Tipo Vehículo'!$E$10,\"A\"),DE!$D$1:$AI$282,88,0))","v":""},{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,84,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,84,0))","v":21}]
[]
[null,null,"IVA aplicado al carburante (€/litro)",null,null,null,null,null,null,{"$f":"IFERROR(ROUND((J27/100)*(J23-J25)/(1+J27/100),2),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,85,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,85,0))","v":0}]
[]
[null,null,"Precio carburante sin IVA (€/litro)",null,null,null,null,null,null,{"$f":"ROUND((J23-J25)/(1+J27/100),2)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,86,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,86,0))","v":0}]
[]
[null,null,"Consumo medio de los equipos (litros/hora)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,87,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,87,0))","v":0}]
[]
[null,null,"Horas anuales de utilización de los equipos",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,88,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,88,0))","v":0}]
[]
[null,null,"GASTO TOTAL ANUAL EN CARBURANTE EQUIPOS",null,null,null,null,null,null,{"$f":"J31*J33*J35","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,89,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,89,0))","v":0}]
[]
[null,null,"Coste anual de neumáticos ",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Número de neumáticos direccionables",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,90,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,90,0))","v":""}]
[]
[null,null,"Número de neumáticos motrices",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,91,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,91,0))","v":""}]
[]
[null,null,"Número de neumáticos arrastre",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,92,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,92,0))","v":""}]
[]
[null,null,"Número de neumáticos semirremolque o remolque",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,93,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,93,0))","v":""}]
[]
[null,null,"Precio sin IVA de un neumático direccionable (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,94,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,94,0))","v":""}]
[]
[null,null,"Precio sin IVA de un neumático motriz (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,95,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,95,0))","v":""}]
[]
[null,null,"Precio sin IVA de un neumático arrastre (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,96,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,96,0))","v":""}]
[]
[null,null,"Precio sin IVA de un neumático remolque-semirremolque (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,97,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,97,0))","v":""}]
[]
[null,null,"Duración media de un neumático direccionable (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,98,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,98,0))","v":""}]
[]
[null,null,"Duración media de un neumático motriz (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,99,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,99,0))","v":""}]
[]
[null,null,"Duración media de un neumático arrastre (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,100,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,100,0))","v":""}]
[]
[null,null,"Duración media de un neumático remolque-semirremolque (km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,101,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,101,0))","v":""}]
[]
[null,null,"GASTO TOTAL ANUAL EN NEUMÁTICOS (€)",null,null,null,null,null,null,{"$f":"ROUND(IFERROR((J41*J49*'Características Vehículo'!J25/J57),0)+IFERROR((J43*J51*'Características Vehículo'!J25/J59),0)+IFERROR((J45*J53*'Características Vehículo'!J25/J61),0)+IFERROR((J47*J55*'Características Vehículo'!J25/J63),0),0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,102,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,102,0))","v":0}]
[]
[null,null,"Gastos de mantenimiento ",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Coste de mantenimiento por km, sin IVA (€/km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,103,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,103,0))","v":""}]
[]
[null,null,"GASTO ANUAL EN MANTENIMIENTO, SIN IVA (€)",null,null,null,null,null,null,{"$f":"'Características Vehículo'!J25*J69","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,104,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,104,0))","v":0}]
[]
[null,null,"Reparaciones",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Coste de reparaciones por km, sin IVA (€/km)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,105,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,105,0))","v":""}]
[]
[null,null,"GASTO ANUAL EN REPARACIONES, SIN IVA (€)",null,null,null,null,null,null,{"$f":"'Características Vehículo'!J25*J75","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,106,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,106,0))","v":0}]
[]
[null,null,"Peajes",null,null,null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"GASTO ANUAL EN PEAJES, SIN IVA (€)",null,null,null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,107,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,107,0))","v":""}]
[]
[null,null,"COSTES VARIABLES",null,null,null,null,null,null,{"$f":"ROUND(J19+J37+J65+J71+J77+J81,0)","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,108,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,108,0))","v":0}]

{"sheet":"Costes Indirectos","index":8,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,"6. Costes indirectos"]
[]
[]
[null,null,"Costes Indirectos",null,null,null,null,null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[]
[null,null,"Coste anual estructura(gestión, administración,) repercutible a este vehículo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,109,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,109,0))","v":0}]
[]
[null,null,"Coste anual comercialización repercutible a este vehículo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,110,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,110,0))","v":0}]
[]
[null,null,"Otros costes indirectos anuales repercutibles a este vehículo",null,null,null,null,null,null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,111,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,111,0))","v":0}]
[]
[null,null,"COSTES INDIRECTOS",null,null,null,null,{"$f":"H11+H13+H15","v":0},null,{"$f":"IF(HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,112,0)=\"\",\"\",HLOOKUP('Tipo Vehículo'!$E$10,DE!$D$1:$AI$282,112,0))","v":0}]

{"sheet":"Resultados","index":9,"n_rows":97,"n_cols":16,"rows_kept":97,"cut":false,"hidden":false,"merged":[[90,7,90,8],[90,4,90,5],[8,4,8,5],[40,7,40,8],[40,4,40,5],[67,7,67,8],[67,4,67,5]]}
[]
[]
[]
[]
[]
[null,null,"Resultados"]
[]
[]
[null,null,"RESULTADOS COSTES ANUALES",null,"Usuario",null,null,"Datos estadísticos",{"$f":"DE!$AJ$2","v":"08/01/2024"}]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[null,null,"COSTES TOTALES",null,{"$f":"E12+E21","v":0},100,null,{"$f":"H12+H21","v":0},100]
[null,null,"COSTES POR TIEMPO",null,{"$f":"IFERROR(SUM(E13:E20),0)","v":0},{"$f":"IFERROR(E12*F11/E11,0)","v":0},null,{"$f":"IFERROR(SUM(H13:H20),0)","v":0},{"$f":"IFERROR(H12*I11/H11,0)","v":0}]
[null,null,"Leasing","A",{"$f":"IFERROR('Costes Adquisición'!H13+0,0)+IFERROR('Costes Adquisición'!H37+0,0)+IFERROR('Costes Adquisición'!H61+0,0)+IFERROR('Costes Adquisición'!H85+0,0)","v":0},{"$f":"IFERROR(E13*F$11/E$11,0)","v":0},"A",{"$f":"IFERROR('Costes Adquisición'!J13+0,0)+IFERROR('Costes Adquisición'!J37+0,0)+IFERROR('Costes Adquisición'!J61+0,0)+IFERROR('Costes Adquisición'!J85+0,0)","v":0},{"$f":"IFERROR(H13*I$11/H$11,0)","v":0},null,"A",{"$f":"E13","v":0},0,"A",{"$f":"H13","v":0},0]
[null,null,"Amortización","B",{"$f":"IFERROR(0+'Costes Adquisición'!H29,0)+IFERROR(0+'Costes Adquisición'!H53,0)+IFERROR(0+'Costes Adquisición'!H77,0)+IFERROR(0+'Costes Adquisición'!H101,0)","v":0},0,"B",{"$f":"IFERROR(0+'Costes Adquisición'!J29,0)+IFERROR(0+'Costes Adquisición'!J53,0)+IFERROR(0+'Costes Adquisición'!J77,0)+IFERROR(0+'Costes Adquisición'!J101,0)","v":0},0,null,"B",0,0,"B",0,0]
[null,null,"Gastos financieros","C",{"$f":"IFERROR(0+'Costes Adquisición'!H31,0)+IFERROR(0+'Costes Adquisición'!H55,0)+IFERROR(0+'Costes Adquisición'!H79,0)+IFERROR(0+'Costes Adquisición'!H103,0)","v":0},0,"C",{"$f":"IFERROR(0+'Costes Adquisición'!J31,0)+IFERROR(0+'Costes Adquisición'!J55,0)+IFERROR(0+'Costes Adquisición'!J79,0)+IFERROR(0+'Costes Adquisición'!J101,0)","v":0},0,null,"C",0,0,"C",0,0]
[null,null,"Coste total anual del conductor","D",{"$f":"'Costes Personal'!H11","v":0},0,"D",{"$f":"'Costes Personal'!J11","v":""},0,null,"D",0,0,"D","",0]
[null,null,"Dietas y otros complementos retributivos del personal de a bordo","E",{"$f":"'Costes Personal'!H17+'Costes Personal'!H21","v":0},0,"E",{"$f":"'Costes Personal'!J17+'Costes Personal'!J21","v":0},0,null,"E",0,0,"E",0,0]
[null,null,"Seguros","F",{"$f":"'Seguros y Costes Fiscales'!H27","v":0},0,"F",{"$f":"'Seguros y Costes Fiscales'!J27","v":0},0,null,"F",0,0,"F",0,0]
[null,null,"Costes fiscales","G",{"$f":"'Seguros y Costes Fiscales'!H47","v":0},0,"G",{"$f":"'Seguros y Costes Fiscales'!J47","v":0},0,null,"G",0,0,"G",0,0]
[null,null,"Gestión y comercialización","H",{"$f":"'Costes Indirectos'!H11+'Costes Indirectos'!H13+'Costes Indirectos'!H15","v":0},0,"H",{"$f":"'Costes Indirectos'!J11+'Costes Indirectos'!J13+'Costes Indirectos'!J15","v":0},0,null,"H",0,0,"H",0,0]
[null,null,"COSTES POR DISTANCIA",null,{"$f":"IFERROR(SUM(E22:E25),0)","v":0},{"$f":"IFERROR(E21*F20/E20,0)","v":0},null,{"$f":"IFERROR(SUM(H22:H25),0)","v":0},{"$f":"IFERROR(H21*I20/H20,0)","v":0},null,"I",{"$f":"E22","v":0},0,"I",{"$f":"H22","v":0},0]
[null,null,"Combustible","I",{"$f":"'Costes Variables'!J19","v":0},{"$f":"IFERROR(E22*F$11/E$11,0)","v":0},"I",{"$f":"'Costes Variables'!L19","v":0},{"$f":"IFERROR(H22*I$11/H$11,0)","v":0},null,"J",0,0,"J",0,0]
[null,null,"Neumáticos","J",{"$f":"'Costes Variables'!J65","v":0},{"$f":"IFERROR(E23*F$11/E$11,0)","v":0},"J",{"$f":"'Costes Variables'!L65","v":0},{"$f":"IFERROR(H23*I$11/H$11,0)","v":0},null,"K",0,0,"K",0,0]
[null,null,"Mantenimiento y reparaciones","K",{"$f":"'Costes Variables'!J71+'Costes Variables'!J77","v":0},{"$f":"IFERROR(E24*F$11/E$11,0)","v":0},"K",{"$f":"'Costes Variables'!L71+'Costes Variables'!L77","v":0},{"$f":"IFERROR(H24*I$11/H$11,0)","v":0},null,"L",0,0,"L","",0]
[null,null,"Peajes","L",{"$f":"'Costes Variables'!J81","v":0},{"$f":"IFERROR(E25*F$11/E$11,0)","v":0},"L",{"$f":"'Costes Variables'!L81","v":""},{"$f":"IFERROR(H25*I$11/H$11,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ESTRUCTURA DE COSTES ANUALES",null,"Usuario",null,null,"Datos estadísticos (2023/1)"]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[null,null,"Amortización y gastos financieros y leasing","A",{"$f":"E13+E14+E15","v":0},{"$f":"IFERROR(E43*$F$48/$E$48,0)","v":0},"A",{"$f":"H13+H14+H15","v":0},{"$f":"IFERROR(H43*$I$48/$H$48,0)","v":0}]
[null,null,"Personal","B",{"$f":"E16+E17","v":0},{"$f":"IFERROR(E44*$F$48/$E$48,0)","v":0},"B",{"$f":"H16+H17","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H44*$I$48/$H$48,0)","v":0}]
[null,null,"Seguros, costes fiscales, gestión y comercialización","C",{"$f":"E18+E19+E20","v":0},{"$f":"IFERROR(E45*$F$48/$E$48,0)","v":0},"C",{"$f":"H18+H19+H20","v":0},{"$f":"IFERROR(H45*$I$48/$H$48,0)","v":0}]
[null,null,"Carburante, neumáticos, reparaciones, mantenimiento y peajes","D",{"$f":"E22+E23+E24+E25","v":0},{"$f":"IFERROR(E46*$F$48/$E$48,0)","v":0},"D",{"$f":"H22+H23+H24+H25","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(H46*$I$48/$H$48,0)","v":0}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"SUM(E43:E46)","v":0},100,null,{"$f":"SUM(H43:H46)","v":{"$error":"#VALUE!"}},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"COSTES POR TIEMPO-COSTES POR DISTANCIA",null,"Usuario",null,null,"Datos estadísticos (2023/1/31)"]
[]
[null,null,null,null,"Euros","%",null,"Euros","%"]
[]
[null,null,"Costes por tiempo","A",{"$f":"E12","v":0},{"$f":"IFERROR(E72*$F$48/$E$48,0)","v":0},"A",{"$f":"H12","v":0},{"$f":"IFERROR(H72*$I$48/$H$48,0)","v":0}]
[null,null,"Costes por distancia","B",{"$f":"E21","v":0},{"$f":"IFERROR(E73*$F$48/$E$48,0)","v":0},"B",{"$f":"H21","v":0},{"$f":"IFERROR(H73*$I$48/$H$48,0)","v":0}]
[]
[null,null,"COSTES TOTALES",null,{"$f":"SUM(E72:E73)","v":0},100,null,{"$f":"SUM(H72:H73)","v":0},100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"COSTES MEDIOS",null,"Usuario",null,null,"Datos estadísticos (2023/1/31)"]
[]
[null,null,"Coste total medio (por km)",null,{"$f":"IFERROR(E75/'Características Vehículo'!J25,0)","v":0},null,null,{"$f":"IFERROR(H75/'Características Vehículo'!L25,0)","v":0}]
[null,null,"Coste total medio (por hora)",null,{"$f":"IFERROR(E75/'Características Vehículo'!J33,0)","v":0},null,null,{"$f":"IFERROR(H75/'Características Vehículo'!L33,0)","v":0}]
[null,null,"Coste por distancia medio (por km)",null,{"$f":"IFERROR(E73/'Características Vehículo'!J25,0)","v":0},null,null,{"$f":"IFERROR(H73/'Características Vehículo'!L25,0)","v":0}]
[null,null,"Coste por tiempo medio (por hora)",null,{"$f":"IFERROR(E72/'Características Vehículo'!J33,0)","v":0},null,null,{"$f":"IFERROR(H72/'Características Vehículo'!L33,0)","v":0}]
[null,null,"Coste medio neumáticos, mantenimiento y reparaciones (por km)",null,{"$f":"IFERROR((E23+E24)/'Características Vehículo'!J25,0)","v":0},null,null,{"$f":"IFERROR((H23+H24)/'Características Vehículo'!L25,0)","v":0}]

{"sheet":"Coste Servicio","index":10,"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)*'Costes Variables'!J17+H13*(('Costes Variables'!J65+'Costes Variables'!J71+'Costes Variables'!J77)/'Características Vehículo'!J25)+H29,2),0)","v":0}]
[]
[null,null,"Coste por tiempo de este servicio (€)",null,null,null,null,{"$f":"IFERROR(H21*(('Costes Adquisición'!H105+'Costes Personal'!H23+'Seguros y Costes Fiscales'!H49+'Costes Indirectos'!H17)/'Características Vehículo'!J33),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}]