{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["SolCotizacion","ResumenCotizacion","solCotizacionCSV","Tarifa","DetalleCotizacion","Cotizacion","Listas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":35,"comments":2,"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":"SolCotizacion","index":0,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,1,11],[2,0,2,11],[6,0,6,2],[8,0,8,2],[4,0,4,11],[6,3,6,5],[8,3,8,5],[6,7,6,8],[8,7,8,8],[37,3,37,4],[21,0,21,1],[21,2,21,3],[29,0,29,11],[31,0,32,11],[28,1,28,4],[35,1,35,4],[20,0,20,11],[14,0,14,11],[10,3,10,5],[12,3,12,5],[34,1,34,4],[12,0,12,2],[16,0,16,2],[10,0,10,2],[10,7,10,8],[12,7,12,8],[16,4,18,11]]}
["Solicitud de Cotización",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(MAX(rangofecha))+1,MONTH(MAX(rangofecha)),DAY(MAX(rangofecha))-1)","v":"1900-12-30"},"Fecha Máxima"]
[]
["Acuerdo Marco de SOAT"]
[null,"Versión: 36","2018-09-10"]
["Información de la Entidad Compradora"]
[]
["Nombre de la Entidad:",null,null,null,null,null,"NIT:"]
[]
["Dirección de la Entidad:",null,null,null,null,null,"Municipio:"]
[]
["Nombre del Comprador:",null,null,null,null,null,"Teléfono:"]
[]
["Correo del comprador:",null,null,null,null,null,"Extension:"]
[]
["Fechas estimadas"]
[]
["Fecha creación solicitud cotización:",null,null,null,"De acuerdo con la Resolución 4170 de 2016 del Ministerio de Transporte, la verificación de la existencia y vigencia de la Póliza SOAT debe ser realizada en el Registro Único Nacional de Tránsito (RUNT), por lo tanto, Colombia Compra Eficiente solicita amablemente a las Entidades Compradoras verificar la existencia del SOAT en el (RUNT) antes de iniciar el proceso de cotización."]
[]
[]
[]
[" Artículos Solicitud de Cotización"]
[null,null,"Filas a agregar o eliminar:"]
[null,null,1,null,null,null,null,null,null,"Vehículo Nuevo","No"]
[]
["No.","Placa","Número de Motor","Número de Chasis","VIN","Marca","Línea","Modelo","Servicio","Toneladas","Número de\nPasajeros","SOAT Vencido?","Fecha de Inicio (Desde las 00 Horas)","Vigencia Contrato en días","Fecha de Vencimiento (Hasta las 24 Horas)","Clase de vehículo","Subtipo","Cilindraje","Detalle Clase de vehículo (No afecta los precios del simulador)"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N26<>\"\",IF(AND(M26>=DATE(2016,1,1),M26<=DATE(2016,2,28)),M26+N26+2,M26+N26-1),\"\")","v":""},null,null,null,null,{"$f":"IF(COUNTIF(placa,B26)<=1,TRUE,FALSE)","v":true},{"$f":"IF(COUNTIF(motor,C26)<=1,TRUE,FALSE)","v":true},{"$f":"IF(COUNTIF(chasis,D26)<=1,TRUE,FALSE)","v":true},{"$f":"IF(COUNTIF(vin,E26)<=1,TRUE,FALSE)","v":true},null,null,365]
[]
[]
[]
["Gravámenes adicionales (estampillas)"]
[]
["Si los hay, indique los gravámenes adicionales (estampilllas) a los que está sujeta la Orden de Compra. Son gravámens adiconales por ejemplo; estampillas y demás impuestos territoriales. Los impuestos como ICA y retención en la fuente NO son gravámenes adicionales."]
[]
[]
["No.","Descripción ",null,null,null,"% Gravámen"]
[1]
[]
[null,null,null,"Total Gravámenes adicionales:",null,{"$f":"SUM(F36:F36)","v":0}]

{"sheet":"ResumenCotizacion","index":1,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,4,9],[0,1,1,9],[2,1,2,9],[10,4,10,5],[12,1,12,13],[8,1,8,13],[10,1,10,3],[6,1,6,3],[30,4,30,5],[6,4,6,5],[6,7,6,8],[15,13,15,20],[27,2,27,5],[28,2,28,5],[15,9,15,12],[15,2,15,8],[12,14,12,15],[22,1,22,13],[24,1,26,10]]}
[null,"Resumen de Cotización Para SOAT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G31","v":0},{"$f":"YEAR(TODAY())","v":2018}]
[]
[null,"Acuerdo Marco de SOAT"]
[]
[null,"Información de la Entidad Compradora"]
[]
[null,"Nombre de la Entidad:",null,null,{"$f":"IF(SolCotizacion!D7=\"\",\"\",SolCotizacion!D7)","v":""},null,"NIT:",{"$f":"IF(SolCotizacion!H7=\"\",\"\",SolCotizacion!H7)","v":""}]
[]
[null,"Fechas estimadas"]
[]
[null,"Fecha creación solicitud cotización:",null,null,{"$f":"IF(SolCotizacion!D17=\"\",\"\",SolCotizacion!D17)","v":""}]
[]
[null," Artículos de la Cotización"]
[]
[]
[null,null,"Vehículo",null,null,null,null,null,null,"Tarifa anual en el AMP del Proveedor",null,null,null,"Cotización según vigencia de compra"]
[null,"No.","Placa","Código de la Tarifa","Marca","Clase de vehículo","Detalle Clase de vehículo \n(No afecta los precios del simulador)","Subtipo","Cilindraje","Prima Emitida Máxima del proveedor en el Acuerdo Marco de Precios","Contribución 50% Fosyga","Tasa RUNT","Tarifa Máxima del proveedor en el Acuerdo Marco de Precios","Prima Emitida con la nueva vigencia","Contribución FOSYGA","Tasa RUNT","Vigencia Contrato en días","Tarifa con la nueva vigencia","edad","Gravámenes","Valor total Tarifa"]
[null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J18+K18+L18,0)","v":0},null,null,null,null,{"$f":"ROUND((N18+O18)*(Q18/365)+P18,0)","v":0},1,{"$f":"(R18/(1-R1))-R18","v":0},{"$f":"ROUND(R18+T18,0)","v":0}]
[null,"Totales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SubTotal",{"$f":"ROUND(SUM(U18:U18),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor Total",{"$f":"SUM(U19:U19)","v":0}]
[]
[]
[null,"Gravámenes adicionales (estampillas)"]
[]
[null,"Si los hay, indique los gravámenes adicionales (estampilllas) a los que está sujeta la Orden de Compra. Son gravámens adiconales por ejemplo; estampillas y demás impuestos territoriales. Los impuestos como ICA y retención en la fuente NO son gravámenes adicionales."]
[]
[]
[null,"No.","Descripción ",null,null,null,"% Gravámen"]
[null,1]
[]
[null,null,null,null,"Total Gravámenes adicionales:",null,{"$f":"SUM(G29:G29)","v":0}]

{"sheet":"solCotizacionCSV","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Tipo (servicio o artÃ­culo)","Cantidad","CÃ³digo de unidad de medida*","PosiciÃ³n","Precio base","Divisa","DescripciÃ³n","MercancÃ­a"]
["item",1,"Und",null,"\"0\"","COP","soa01--101 CICLOMOTOR  "]
["item",1,"Und",null,"\"0\"","COP","soa01--110 MOTOS Hasta 100c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--120 MOTOS 100 a 200c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--130 MOTOS MÃ¡s de 200c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--140 MOTOS Motocarros "]
["item",1,"Und",null,"\"0\"","COP","soa01--211 CAMPEROS Y CAMIONETAS Hasta 1500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--212 CAMPEROS Y CAMIONETAS Hasta 1500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--221 CAMPEROS Y CAMIONETAS 1500 a 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--222 CAMPEROS Y CAMIONETAS 1500 a 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--231 CAMPEROS Y CAMIONETAS MÃ¡s de 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--232 CAMPEROS Y CAMIONETAS MÃ¡s de 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--310 CARGA O MIXTO Hasta 5 toneladas "]
["item",1,"Und",null,"\"0\"","COP","soa01--320 CARGA O MIXTO 5 a 15 toneladas "]
["item",1,"Und",null,"\"0\"","COP","soa01--330 CARGA O MIXTO MÃ¡s de 15 toneladas "]
["item",1,"Und",null,"\"0\"","COP","soa01--410 OFICIALES ESPECIALES Hasta 1500c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--420 OFICIALES ESPECIALES 1500 a 2500c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--430 OFICIALES ESPECIALES MÃ¡s de 2500 c.c. "]
["item",1,"Und",null,"\"0\"","COP","soa01--511 AUTOS FAMILIARES Hasta 1500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--512 AUTOS FAMILIARES Hasta 1500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--521 AUTOS FAMILIARES 1500 a 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--522 AUTOS FAMILIARES 1500 a 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--531 AUTOS FAMILIARES MÃ¡s de 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--532 AUTOS FAMILIARES MÃ¡s de 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--611 VEHICULOS PARA SEIS O MAS PASAJEROS Hasta 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--612 VEHICULOS PARA SEIS O MAS PASAJEROS Hasta 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--621 VEHICULOS PARA SEIS O MAS PASAJEROS MÃ¡s de 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--622 VEHICULOS PARA SEIS O MAS PASAJEROS MÃ¡s de 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--711 AUTOS DE NEGOCIOS Y TAXIS Hasta 1500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--712 AUTOS DE NEGOCIOS Y TAXIS Hasta 1500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--721 AUTOS DE NEGOCIOS Y TAXIS 1500 a 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--722 AUTOS DE NEGOCIOS Y TAXIS 1500 a 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--731 AUTOS DE NEGOCIOS Y TAXIS MÃ¡s de 2500c.c. 0 a 9 aÃ±os"]
["item",1,"Und",null,"\"0\"","COP","soa01--732 AUTOS DE NEGOCIOS Y TAXIS MÃ¡s de 2500c.c. MÃ¡s de 10"]
["item",1,"Und",null,"\"0\"","COP","soa01--810 BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO  "]
["item",1,"Und",null,"\"0\"","COP","soa01--910 SERVICIO PUBLICO INTERMUNICIPAL Hasta 10 pasajeros "]
["item",1,"Und",null,"\"0\"","COP","soa01--920 SERVICIO PUBLICO INTERMUNICIPAL MÃ¡s de 10 pasajeros "]

{"sheet":"Tarifa","index":3,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,1,1,9],[1,10,1,12],[1,13,1,15],[1,16,1,18]]}
[]
[null,"TARIFAS MÁXIMAS SOAT 2018",null,null,null,null,null,null,null,null,"Descuento Ofrecido",null,null,"Prima Emitida con Descuento",null,null,"Tarifa Máxima en el Acuerdo Marco de Precios"]
[null,"Código","CLASE DE VEHICULO","SUBTIPO","EDAD","Tasa comercial (CE04-09 SFC)","Valor prima","Contribución 50% Fosyga","Tasa RUNT","TOTAL A PAGAR","% de descuento Suramericana ","% de descuento La Previsora ","% de descuento QBE","Seguros Generales Suramericana S.A.","La Previsora S.A. Compañía de Seguros","QBE Seguros S.A ","tarifa máxima Suramericana","tarifa máxima La Previsora","tarifa máxima \nQBE Compañía de Seguros",null,"Seguros Generales Suramericana S.A.","La Previsora S.A. Compañía de Seguros","QBE Seguros S.A "]
[null,101,"CICLOMOTOR",null,null,4.13,107500,{"$f":"G4/2","v":53750},1900,{"$f":"ROUND(+I4+H4+G4,0)","v":163150},0.16,0.22,0.16170000000000001,{"$f":"$G4*(1-K4)","v":90300},{"$f":"$G4*(1-L4)","v":83850},{"$f":"$G4*(1-M4)","v":90117.25},{"$f":"ROUND(N4+H4+I4,0)","v":145950},{"$f":"ROUND(+I4+H4+O4,0)","v":139500},{"$f":"ROUND(+P4+H4+I4,0)","v":145767},null,{"$f":"+N4*T4","v":0},{"$f":"O4*T4","v":0},{"$f":"P4*T4","v":0}]
[null,110,"MOTOS","Menos de 100 c.c.",null,8.6,223900,{"$f":"G5/2","v":111950},1900,{"$f":"ROUND(+I5+H5+G5,0)","v":337750},0.16,0.22,0.16170000000000001,{"$f":"$G5*(1-K5)","v":188076},{"$f":"$G5*(1-L5)","v":174642},187695.37000000002,{"$f":"ROUND(N5+H5+I5,0)","v":301926},{"$f":"ROUND(+I5+H5+O5,0)","v":288492},{"$f":"ROUND(+P5+H5+I5,0)","v":301545},null,{"$f":"+N5*T5","v":0},{"$f":"O5*T5","v":0},{"$f":"P5*T5","v":0}]
[null,120,"MOTOS","De 100 a 200 c.c.",null,11.55,300700,{"$f":"G6/2","v":150350},1900,{"$f":"ROUND(+I6+H6+G6,0)","v":452950},0.16,0.22,0.16170000000000001,{"$f":"$G6*(1-K6)","v":252588},{"$f":"$G6*(1-L6)","v":234546},{"$f":"$G6*(1-M6)","v":252076.81000000003},{"$f":"ROUND(N6+H6+I6,0)","v":404838},{"$f":"ROUND(+I6+H6+O6,0)","v":386796},{"$f":"ROUND(+P6+H6+I6,0)","v":404327},null,{"$f":"+N6*T6","v":0},{"$f":"O6*T6","v":0},{"$f":"P6*T6","v":0}]
[null,130,"MOTOS","Más de 200 c.c.",null,13.03,339300,{"$f":"G7/2","v":169650},1900,510850,0.16,0.22,0.16170000000000001,285012,264654,284435.19,456562,436204,455985,null,0,0,0]
[null,140,"MOTOS","Motocarros",null,13.03,339300,169650,1900,510850,0.16,0.22,0.16170000000000001,285012,264654,284435.19,456562,436204,455985,null,0,0,0]
[null,211,"CAMPEROS Y CAMIONETAS","Menos de 1500 c.c.","0 a 9 años",13.57,353300,176650,1900,531850,0.19,0.19,0.20019999999999999,286173,286173,282569.34000000003,464723,464723,461119,null,0,0,0]
[null,212,"CAMPEROS Y CAMIONETAS","Menos de 1500 c.c.","10 años o mas",16.32,424900,212450,1900,639250,0.19,0.19,0.20019999999999999,344169,344169,339835.02,558519,558519,554185,null,0,0,0]
[null,221,"CAMPEROS Y CAMIONETAS","1500 a 2500","0 a 9 años",16.21,422100,211050,1900,635050,0.19,0.19,0.20019999999999999,341901,341901,337595.58,554851,554851,550546,null,0,0,0]
[null,222,"CAMPEROS Y CAMIONETAS","1500 a 2500","10 años o mas",19.21,500200,250100,1900,752200,0.19,0.19,0.20019999999999999,405162,405162,400059.96,657162,657162,652060,null,0,0,0]
[null,231,"CAMPEROS Y CAMIONETAS","Más de 2500 c.c.","0 a 9 años",19.02,495300,247650,1900,744850,0.19,0.19,0.20019999999999999,401193,401193,396140.94000000006,650743,650743,645691,null,0,0,0]
[null,232,"CAMPEROS Y CAMIONETAS","Más de 2500 c.c.","10 años o mas",21.83,568400,284200,1900,854500,0.19,0.19,0.20019999999999999,460404.00000000006,460404.00000000006,454606.32000000007,746504,746504,740706,null,0,0,0]
[null,310,"CARGA O MIXTO","Menos de 5 toneladas",null,15.21,396000,198000,1900,595900,0.19,0.21,0.1925,320760,312840,319770,520660,512740,519670,null,0,0,0]
[null,320,"CARGA O MIXTO","De 5 a 15 toneladas",null,21.98,572300,286150,1900,860350,0.19,0.21,0.1925,463563.00000000006,452117,462132.25,751613,740167,750182,null,0,0,0]
[null,330,"CARGA O MIXTO","Más de 15 toneladas",null,27.8,723900,361950,1900,1087750,0.19,0.21,0.1925,586359,571881,584549.25,950209,935731,948399,null,0,0,0]
[null,410,"OFICIALES ESPECIALES","Menos de 1500 c.c.",null,17.12,445800,222900,1900,670600,0.19,0.21,0.20019999999999999,361098,352182,356550.84,585898,576982,581351,null,0,0,0]
[null,420,"OFICIALES ESPECIALES","1500 a 2500",null,21.59,562200,281100,1900,845200,0.19,0.21,0.20019999999999999,455382.00000000006,444138,449647.56000000006,738382,727138,732648,null,0,0,0]
[null,430,"OFICIALES ESPECIALES","Más de 2500 c.c.",null,25.89,674200,337100,1900,1013200,0.19,0.21,0.20019999999999999,546102,532618,539225.16,885102,871618,878225,null,0,0,0]
[null,511,"AUTOS FAMILIARES","Menos de 1500 c.c.","0 a 9 años",7.64,198900,99450,1900,300250,0.19,0.21,0.20019999999999999,161109,157131,159080.22,262459,258481,260430,null,0,0,0]
[null,512,"AUTOS FAMILIARES","Menos de 1500 c.c.","10 años o mas",10.14,264000,132000,1900,397900,0.19,0.21,0.20019999999999999,213840,208560,211147.2,347740,342460,345047,null,0,0,0]
[null,521,"AUTOS FAMILIARES","1500 a 2500","0 a 9 años",9.31,242400,121200,1900,365500,0.19,0.21,0.20019999999999999,196344,191496,193871.52000000002,319444,314596,316972,null,0,0,0]
[null,522,"AUTOS FAMILIARES","1500 a 2500","10 años o mas",11.59,301800,150900,1900,454600,0.19,0.21,0.20019999999999999,244458.00000000003,238422,241379.64,397258,391222,394180,null,0,0,0]
[null,531,"AUTOS FAMILIARES","Más de 2500 c.c.","0 a 9 años",10.88,283300,141650,1900,426850,0.19,0.21,0.20019999999999999,229473.00000000003,223807,226583.34000000003,373023,367357,370133,null,0,0,0]
[null,532,"AUTOS FAMILIARES","Más de 2500 c.c.","10 años o mas",12.91,336100,168050,1900,506050,0.19,0.21,0.20019999999999999,272241,265519,268812.78000000003,442191,435469,438763,null,0,0,0]
[null,611,"VEHICULOS PARA SEIS O MAS PASAJEROS","Menos de 2500","0 a 9 años",13.65,355400,177700,1900,535000,0.19,0.21,0.16170000000000001,287874,280766,297931.82,467474,460366,477532,null,0,0,0]
[null,612,"VEHICULOS PARA SEIS O MAS PASAJEROS","Menos de 2500","10 años o mas",17.43,453900,226950,1900,682750,0.19,0.21,0.16170000000000001,367659,358581,380504.37,596509,587431,609354,null,0,0,0]
[null,621,"VEHICULOS PARA SEIS O MAS PASAJEROS","2500 o más","0 a 9 años",18.28,476000,238000,1900,715900,0.19,0.21,0.16170000000000001,385560,376040,399030.80000000005,625460,615940,638931,null,0,0,0]
[null,622,"VEHICULOS PARA SEIS O MAS PASAJEROS","2500 o más","10 años o mas",21.96,571800,285900,1900,859600,0.19,0.21,0.16170000000000001,463158.00000000006,451722,479339.94,750958,739522,767140,null,0,0,0]
[null,711,"AUTOS DE NEGOCIOS Y TAXIS","Menos de 1500 c.c.","0 a 9 años",9.4700000000000006,246600,123300,1900,371800,0.19,0.21,0.16170000000000001,199746,194814,206724.78,324946,320014,331925,null,0,0,0]
[null,712,"AUTOS DE NEGOCIOS Y TAXIS","Menos de 1500 c.c.","10 años o mas",11.84,308300,154150,1900,464350,0.19,0.21,0.16170000000000001,249723.00000000003,243557,258447.89,405773,399607,414498,null,0,0,0]
[null,721,"AUTOS DE NEGOCIOS Y TAXIS","1500 a 2500","0 a 9 años",11.78,306700,153350,1900,461950,0.19,0.21,0.16170000000000001,248427.00000000003,242293,257106.61000000002,403677,397543,412357,null,0,0,0]
[null,722,"AUTOS DE NEGOCIOS Y TAXIS","1500 a 2500","10 años o mas",14.57,379400,189700,1900,571000,0.19,0.21,0.16170000000000001,307314,299726,318051.02,498914,491326,509651,null,0,0,0]
[null,731,"AUTOS DE NEGOCIOS Y TAXIS","Más de 2500 c.c.","0 a 9 años",15.21,396000,198000,1900,595900,0.19,0.21,0.16170000000000001,320760,312840,331966.80000000005,520660,512740,531867,null,0,0,0]
[null,732,"AUTOS DE NEGOCIOS Y TAXIS","Más de 2500 c.c.","10 años o mas",17.850000000000001,464800,232400,1900,699100,0.19,0.21,0.16170000000000001,376488,367192,389641.84,610788,601492,623942,null,0,0,0]
[null,810,"BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO",null,null,22.72,591600,295800,1900,889300,0.19,0.21,0.1925,479196.00000000006,467364,477717,776896,765064,775417,null,0,0,0]
[null,910,"SERVICIO PUBLICO INTERMUNICIPAL","Menor 10 pasajeros",null,22.47,585100,292550,1900,879550,0.19,0.21,0.16170000000000001,473931.00000000006,462229,490489.33,768381,756679,784939,null,0,0,0]
[null,920,"SERVICIO PUBLICO INTERMUNICIPAL","10 o más pasajeros",null,32.619999999999997,849400,424700,1900,1276000,0.19,0.21,0.16170000000000001,688014,671026,712052.02,1114614,1097626,1138652,1,688014,671026,712052.02]
[]
[null,"SMLDV = Salarios Mínimos Legales Diarios Vigentes",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U5:U39)","v":688014},{"$f":"SUM(V5:V39)","v":671026},{"$f":"SUM(W5:W39)","v":712052.02}]
[null,"(1) Conforme la Circular 004 de 2009, \"el valor de la prima deberá redondearse a la cifra inferior más cercana a la centena que resulte de la liquidación correspondiente.\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(N41:P41)","v":671026}]
[]
[null,null,null,null,null,null,null,{"$f":"G5*1.046","v":234199.40000000002},null,null,null,null,null,{"$f":"IF(N41=$N$43,\"VERDADERO\",\"FALSO\")","v":"FALSO"},{"$f":"IF(O41=$N$43,\"VERDADERO\",\"FALSO\")","v":"VERDADERO"},{"$f":"IF(P41=$N$43,\"VERDADERO\",\"FALSO\")","v":"FALSO"}]

{"sheet":"DetalleCotizacion","index":4,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,1,12,13],[14,4,14,5],[16,1,16,13],[14,1,14,3],[36,2,36,5],[19,13,19,22],[34,2,34,5],[35,2,35,5],[25,1,25,13],[27,1,29,10],[30,2,30,5],[31,2,31,5],[33,4,33,5],[19,9,19,12],[19,2,19,8],[0,1,1,9],[2,1,2,9],[10,4,10,5],[8,1,8,9],[10,7,10,8],[6,3,6,5],[6,7,6,8],[4,1,4,9],[6,1,6,2],[10,1,10,3]]}
[null,"Cotización Para SOAT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G34","v":0}]
[]
[null,"Acuerdo Marco de SOAT"]
[]
[null,"Información del Proveedor"]
[]
[null,"Proveedor:",null,null,null,null,"NIT:",{"$f":"IF(OR(D7=\" \",D7=\"\"),\"\",VLOOKUP($D$7,Listas!$P$1:$Q$4,2,0))","v":""}]
[]
[null,"Información de la Entidad Compradora"]
[]
[null,"Nombre de la Entidad:",null,null,{"$f":"IF(SolCotizacion!D7=\"\",\"\",SolCotizacion!D7)","v":""},null,"NIT:",{"$f":"IF(SolCotizacion!H7=\"\",\"\",SolCotizacion!H7)","v":""}]
[]
[null,"Fechas estimadas"]
[]
[null,"Fecha creación solicitud cotización:",null,null,{"$f":"IF(SolCotizacion!D17=\"\",\"\",SolCotizacion!D17)","v":""}]
[]
[null," Artículos de la Cotización"]
[]
[]
[null,null,"Vehículo",null,null,null,null,null,null,"Tarifa anual en el AMP del Proveedor",null,null,null,"Cotización según vigencia de compra"]
[null,"No.","Placa","Código de la Tarifa","Marca","Clase de vehículo","Detalle Clase de vehículo \n(No afecta los precios del simulador)","Subtipo","Cilindraje","Prima Emitida Máxima del proveedor en el Acuerdo Marco de Precios","Contribución 50% Fosyga","Tasa RUNT","Tarifa Máxima del proveedor en el Acuerdo Marco de Precios","Prima Emitida con la nueva vigencia","Contribución FOSYGA","Tasa RUNT","Vigencia Contrato en días","Tarifa con la nueva vigencia","Descuento Adicional","Tarifa + Descuento","edad","Gravámenes","Valot total Tarifa"]
[null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J22+K22+L22,0)","v":0},null,null,null,null,{"$f":"ROUND((N22+O22)*(Q22/365)+P22,0)","v":0},null,{"$f":"ROUND((N22+O22)*(Q22/365)+P22-((N22*S22%)*(Q22/365)),0)","v":0},1,{"$f":"(T22/(1-$R$1))-T22","v":0},{"$f":"ROUND(T22+V22,0)","v":0}]
[null,"Totales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SubTotal",{"$f":"ROUND(SUM(W22:W22),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor Total",{"$f":"SUM(W23:W23)","v":0}]
[]
[null,"Gravámenes adicionales (estampillas)"]
[]
[null,"Si los hay, indique los gravámenes adicionales (estampilllas) a los que está sujeta la Orden de Compra. Son gravámens adiconales por ejemplo; estampillas y demás impuestos territoriales. Los impuestos como ICA y retención en la fuente NO son gravámenes adicionales."]
[]
[]
[null,"No.","Descripción ",null,null,null,"% Gravámen"]
[null,1]
[]
[null,null,null,null,"Total Gravámenes adicionales:",null,{"$f":"SUM(G32:G32)","v":0}]

{"sheet":"Cotizacion","index":5,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Código","Detalle Cotización",null,null,"Edad Vehículo","Cantidad","Valor"]
[101,{"$f":"A2&\" \"&C2&\" \"&D2&\" \"&E2","v":"101 CICLOMOTOR  "},"CICLOMOTOR",null,null,1,0]
[110,{"$f":"A3&\" \"&C3&\" \"&D3&\" \"&E3","v":"110 MOTOS Hasta 100c.c. "},"MOTOS","Hasta 100c.c.",null,1,0]
[120,{"$f":"A4&\" \"&C4&\" \"&D4&\" \"&E4","v":"120 MOTOS 100 a 200c.c. "},"MOTOS","100 a 200c.c.",null,1,0]
[130,"130 MOTOS Más de 200c.c. ","MOTOS","Más de 200c.c.",null,1,0]
[140,"140 MOTOS Motocarros ","MOTOS","Motocarros",null,1,0]
[211,"211 CAMPEROS Y CAMIONETAS Hasta 1500c.c. 0 a 9 años","CAMPEROS Y CAMIONETAS","Hasta 1500c.c.","0 a 9 años",1,0]
[212,"212 CAMPEROS Y CAMIONETAS Hasta 1500c.c. Más de 10","CAMPEROS Y CAMIONETAS","Hasta 1500c.c.","Más de 10",1,0]
[221,"221 CAMPEROS Y CAMIONETAS 1500 a 2500c.c. 0 a 9 años","CAMPEROS Y CAMIONETAS","1500 a 2500c.c.","0 a 9 años",1,0]
[222,"222 CAMPEROS Y CAMIONETAS 1500 a 2500c.c. Más de 10","CAMPEROS Y CAMIONETAS","1500 a 2500c.c.","Más de 10",1,0]
[231,"231 CAMPEROS Y CAMIONETAS Más de 2500c.c. 0 a 9 años","CAMPEROS Y CAMIONETAS","Más de 2500c.c.","0 a 9 años",1,0]
[232,"232 CAMPEROS Y CAMIONETAS Más de 2500c.c. Más de 10","CAMPEROS Y CAMIONETAS","Más de 2500c.c.","Más de 10",1,0]
[310,"310 CARGA O MIXTO Hasta 5 toneladas ","CARGA O MIXTO","Hasta 5 toneladas",null,1,0]
[320,"320 CARGA O MIXTO 5 a 15 toneladas ","CARGA O MIXTO","5 a 15 toneladas",null,1,0]
[330,"330 CARGA O MIXTO Más de 15 toneladas ","CARGA O MIXTO","Más de 15 toneladas",null,1,0]
[410,"410 OFICIALES ESPECIALES Hasta 1500c.c. ","OFICIALES ESPECIALES","Hasta 1500c.c.",null,1,0]
[420,"420 OFICIALES ESPECIALES 1500 a 2500c.c. ","OFICIALES ESPECIALES","1500 a 2500c.c.",null,1,0]
[430,"430 OFICIALES ESPECIALES Más de 2500 c.c. ","OFICIALES ESPECIALES","Más de 2500 c.c.",null,1,0]
[511,"511 AUTOS FAMILIARES Hasta 1500c.c. 0 a 9 años","AUTOS FAMILIARES","Hasta 1500c.c.","0 a 9 años",1,0]
[512,"512 AUTOS FAMILIARES Hasta 1500c.c. Más de 10","AUTOS FAMILIARES","Hasta 1500c.c.","Más de 10",1,0]
[521,"521 AUTOS FAMILIARES 1500 a 2500c.c. 0 a 9 años","AUTOS FAMILIARES","1500 a 2500c.c.","0 a 9 años",1,0]
[522,"522 AUTOS FAMILIARES 1500 a 2500c.c. Más de 10","AUTOS FAMILIARES","1500 a 2500c.c.","Más de 10",1,0]
[531,"531 AUTOS FAMILIARES Más de 2500c.c. 0 a 9 años","AUTOS FAMILIARES","Más de 2500c.c.","0 a 9 años",1,0]
[532,"532 AUTOS FAMILIARES Más de 2500c.c. Más de 10","AUTOS FAMILIARES","Más de 2500c.c.","Más de 10",1,0]
[611,"611 VEHICULOS PARA SEIS O MAS PASAJEROS Hasta 2500c.c. 0 a 9 años","VEHICULOS PARA SEIS O MAS PASAJEROS","Hasta 2500c.c.","0 a 9 años",1,0]
[612,"612 VEHICULOS PARA SEIS O MAS PASAJEROS Hasta 2500c.c. Más de 10","VEHICULOS PARA SEIS O MAS PASAJEROS","Hasta 2500c.c.","Más de 10",1,0]
[621,"621 VEHICULOS PARA SEIS O MAS PASAJEROS Más de 2500c.c. 0 a 9 años","VEHICULOS PARA SEIS O MAS PASAJEROS","Más de 2500c.c.","0 a 9 años",1,0]
[622,"622 VEHICULOS PARA SEIS O MAS PASAJEROS Más de 2500c.c. Más de 10","VEHICULOS PARA SEIS O MAS PASAJEROS","Más de 2500c.c.","Más de 10",1,0]
[711,"711 AUTOS DE NEGOCIOS Y TAXIS Hasta 1500c.c. 0 a 9 años","AUTOS DE NEGOCIOS Y TAXIS","Hasta 1500c.c.","0 a 9 años",1,0]
[712,"712 AUTOS DE NEGOCIOS Y TAXIS Hasta 1500c.c. Más de 10","AUTOS DE NEGOCIOS Y TAXIS","Hasta 1500c.c.","Más de 10",1,0]
[721,"721 AUTOS DE NEGOCIOS Y TAXIS 1500 a 2500c.c. 0 a 9 años","AUTOS DE NEGOCIOS Y TAXIS","1500 a 2500c.c.","0 a 9 años",1,0]
[722,"722 AUTOS DE NEGOCIOS Y TAXIS 1500 a 2500c.c. Más de 10","AUTOS DE NEGOCIOS Y TAXIS","1500 a 2500c.c.","Más de 10",1,0]
[731,"731 AUTOS DE NEGOCIOS Y TAXIS Más de 2500c.c. 0 a 9 años","AUTOS DE NEGOCIOS Y TAXIS","Más de 2500c.c.","0 a 9 años",1,0]
[732,"732 AUTOS DE NEGOCIOS Y TAXIS Más de 2500c.c. Más de 10","AUTOS DE NEGOCIOS Y TAXIS","Más de 2500c.c.","Más de 10",1,0]
[810,"810 BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO  ","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO",null,null,1,0]
[910,"910 SERVICIO PUBLICO INTERMUNICIPAL Hasta 10 pasajeros ","SERVICIO PUBLICO INTERMUNICIPAL","Hasta 10 pasajeros",null,1,0]
[920,"920 SERVICIO PUBLICO INTERMUNICIPAL Más de 10 pasajeros ","SERVICIO PUBLICO INTERMUNICIPAL","Más de 10 pasajeros",null,1,0]
[null,null,null,null,null,"TOTAL",{"$f":"SUM(G3:G37)","v":0}]

{"sheet":"Listas","index":6,"n_rows":31,"n_cols":32,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Servicio","Proveedor","CLASE DE VEHICULO","MOTOSsubtipo","CAMPEROSYCAMIONETASsubtipo","CARGAOMIXTOsubtipo","OFICIALESESPECIALESsubtipo","AUTOSFAMILIARESsubtipo","VEHICULOSPARASEISOMASPASAJEROSsubtipo","AUTOSDENEGOCIOSYTAXISsubtipo","BUSESYBUSETASDE SERVICIOPUBLICOURBANOsubtipo","SERVICIOPUBLICOINTERMUNICIPALsubtipo",null,"Vencido",null,"Prvoeedor","Nit",null,"Ambulancia","Bomberos","Carro Fúnebre","Diplomáticos","Enseñanza Automotriz","Fuerzas Militares Especiales","Oficial Escolar","Oficiales","Particular","Particular Escolar","Publico Intermunicipal","Publico Urbano","Trabajo Agroindustrial","Transporte de Valores"]
["Ambulancia","Seguros Generales Suramericana S.A.","CICLOMOTOR","Menos de 100 c.c.","Menos de 1500 c.c.","Menos de 5 toneladas","Menos de 1500 c.c.","Menos de 1500 c.c.","Menos de 2500","Menos de 1500 c.c.",null,"Menor 10 pasajeros",null,"Si",null,"La Previsora S.A. Compañía de Seguros","860.002.400-2",null,"OFICIALES ESPECIALES","OFICIALES ESPECIALES","AUTOS DE NEGOCIOS Y TAXIS","OFICIALES ESPECIALES","AUTOS DE NEGOCIOS Y TAXIS","CICLOMOTOR","CAMPEROS Y CAMIONETAS","CICLOMOTOR","CICLOMOTOR","CAMPEROS Y CAMIONETAS","CAMPEROS Y CAMIONETAS","CAMPEROS Y CAMIONETAS","CARGA O MIXTO","OFICIALES ESPECIALES"]
["Bomberos","La Previsora S.A. Compañía de Seguros","MOTOS","De 100 a 200 c.c.","1500 a 2500","De 5 a 15 toneladas","1500 a 2500","1500 a 2500","2500 o más","1500 a 2500",null,"10 o más pasajeros",null,"No",null,"Seguros Generales Suramericana S.A.","890.903.407-9",null,null,null,null,null,null,"MOTOS","OFICIALES ESPECIALES","MOTOS","MOTOS","CARGA O MIXTO","AUTOS DE NEGOCIOS Y TAXIS","AUTOS DE NEGOCIOS Y TAXIS"]
["Carro Fúnebre","QBE Seguros S.A ","CAMPEROS Y CAMIONETAS","Más de 200 c.c.","Más de 2500 c.c.","Más de 15 toneladas","Más de 2500 c.c.","Más de 2500 c.c.",null,"Más de 2500 c.c.",null,null,null,null,null,"QBE Seguros S.A ","860.002.534-0",null,null,null,null,null,null,"CAMPEROS Y CAMIONETAS","AUTOS FAMILIARES","CAMPEROS Y CAMIONETAS","CAMPEROS Y CAMIONETAS","VEHICULOS PARA SEIS O MAS PASAJEROS","VEHICULOS PARA SEIS O MAS PASAJEROS","VEHICULOS PARA SEIS O MAS PASAJEROS"]
["Diplomáticos"," ","CARGA O MIXTO","Motocarros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CARGA O MIXTO","VEHICULOS PARA SEIS O MAS PASAJEROS","CARGA O MIXTO","CARGA O MIXTO","AUTOS DE NEGOCIOS Y TAXIS","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO"]
["Enseñanza Automotriz",null,"OFICIALES ESPECIALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFICIALES ESPECIALES","AUTOS DE NEGOCIOS Y TAXIS","OFICIALES ESPECIALES","AUTOS FAMILIARES","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO","SERVICIO PUBLICO INTERMUNICIPAL","SERVICIO PUBLICO INTERMUNICIPAL"]
["Fuerzas Militares Especiales",null,"AUTOS FAMILIARES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTOS FAMILIARES","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO","AUTOS FAMILIARES","VEHICULOS PARA SEIS O MAS PASAJEROS","SERVICIO PUBLICO INTERMUNICIPAL"]
["Oficial Escolar",null,"VEHICULOS PARA SEIS O MAS PASAJEROS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VEHICULOS PARA SEIS O MAS PASAJEROS","SERVICIO PUBLICO INTERMUNICIPAL","VEHICULOS PARA SEIS O MAS PASAJEROS","AUTOS DE NEGOCIOS Y TAXIS"]
["Oficiales",null,"AUTOS DE NEGOCIOS Y TAXIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUTOS DE NEGOCIOS Y TAXIS",null,"AUTOS DE NEGOCIOS Y TAXIS","BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO"]
["Particular",null,"BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO",null,"BUSES Y BUSETAS DE SERVICIO PUBLICO URBANO","SERVICIO PUBLICO INTERMUNICIPAL"]
["Particular Escolar",null,"SERVICIO PUBLICO INTERMUNICIPAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SERVICIO PUBLICO INTERMUNICIPAL",null,"SERVICIO PUBLICO INTERMUNICIPAL"]
["Publico Intermunicipal"]
["Publico Urbano"]
["Trabajo Agroindustrial"]
["Transporte De Valores"]
[]
["TIPO DE VEHICULOS"]
["Automóvil"]
["Bus"]
["Buseta"]
["Camión","TIPO_DE_VEHICULOS"]
["Camioneta"]
["Campero"]
["Maquinaria Agrícola"]
["Maquinaria Industrial"]
["Microbús"]
["Motocarro"]
["Motocicleta"]
["Motociclo"]
["Tracto camión"]
["Volqueta"]