{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Solicitud","Cotización","Datos","BDPorcentajes"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Solicitud","index":0,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[[32,0,32,1],[32,2,32,8],[34,0,34,1],[34,2,34,8],[24,0,24,12],[26,0,26,1],[26,2,26,3],[28,0,28,1],[28,2,28,3],[30,0,30,1],[30,2,30,8],[26,10,26,12],[28,10,34,12],[18,6,18,7],[12,2,12,8],[12,0,12,1],[10,10,10,11],[14,0,14,12],[10,2,10,8],[18,8,18,9],[10,0,10,1],[16,0,16,1],[16,2,16,3],[16,10,16,11],[16,4,16,5],[16,6,16,7],[16,8,16,9],[18,10,18,11],[36,0,36,12],[38,0,39,12],[46,7,46,8],[46,4,46,6],[41,7,41,8],[42,7,42,8],[41,1,41,6],[42,1,42,6],[43,1,43,6],[43,7,43,8],[44,1,44,6],[44,7,44,8],[22,7,22,8],[22,11,22,12],[0,0,1,12],[4,0,4,12],[6,0,6,1],[6,10,6,12],[8,0,8,1],[6,2,6,8],[8,2,8,8],[2,0,2,12],[8,10,8,12],[22,0,22,1],[22,2,22,3],[22,4,22,5],[20,0,20,12],[18,4,18,5]]}
["Solicitud de Cotización",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha límite:","2018-09-16",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asesores:",1,1]
["Acuerdo Marco de Precios suministro de Tiquetes Aéreos"]
[]
["Información de la Entidad Compradora"]
[]
["Nombre de la Entidad:",null,"Universidad Distrital Francisco José de Caldas",null,null,null,null,null,null,"NIT:","899 999 230-7"]
[]
["Dirección de la Entidad:",null,"Cra 7ma N° 40 B 53",null,null,null,null,null,null,"Municipio:","Bogotá D.C."]
[]
["Nombre del Comprador:",null,"Universidad Distrital Francisco José de Caldas",null,null,null,null,null,null,"Teléfono",3239300,null,"1801/02/03/"]
[]
["Correo del comprador",null,"vicerrecadmin@udistrital.edu.co"]
[]
["Fechas estimadas"]
[]
["Fecha creación solicitud cotización",null,"2018-03-05",null,"Fecha generación OC",null,{"$f":"IF(C17=\"\",\"\",WORKDAY($C$17,10))","v":"2018-03-19"},null,"Fecha vencimiento OC",null,"2018-09-16"]
[]
[null,null,null,null,"Vigencia estimada OC (Días)",null,390,null,"Vigencia estimada OC (Meses)",null,{"$f":"+IF(G19=\"\",\"\",G19/30)","v":13}]
[]
["Presupuesto"]
[]
["Presupuesto de la Entidad",null,1006284450,null,"% Tiquetes Nacionales",null,0.5,"% Tiquetes Internacionales",null,{"$f":"IF(G23=\"\",\"\",1-G23)","v":0.5},"Promedio anual",{"$f":"IF(C23=\"\",\"\",IF(K19>12,C23*12/$K$19,\"Menor a un año\"))","v":928877953.84615386}]
[]
["Asesores"]
[]
["Requiere Asesores",null,"Si",null,null,null,null,null,null,null,"Convenios"]
[]
["Cantidad de Asesores",null,1,null,null,null,null,null,null,null,"Convenio No. 29167-17 (Avianca- Acumulación de Millas), Convenio LATAM Ahorro (Tarifa Económica (15% Nacional, 15%Internacional), Tarifa Flexible (18%Nacional, 18% Internacional), Full Flexible (18% Nacional, 18% Internacional)) "]
[]
["Nombre de la sede",null,"Sede administrativa Calle 40"]
[]
["Dirección de la sede",null,"Carrera 7ma N° 40 B 53"]
[]
["Horario de los asesores",null,"8:00 am - 5:00pm"]
[]
["Gravámenes adicionales (estampillas)"]
[]
["Si los hay, indique los gravámenes adicionales (estampillas) a los que está sujeta la Orden de Compra. Son gravámenes adicionales 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,null,null,"% Gravamen"]
[1,"Estampilla \"Universidad Distrital Francisco José de Caldas\"-50 Años",null,null,null,null,null,1.0999999999999999E-2]
[2,"Pro Adulto Mayor",null,null,null,null,null,0.02]
[3,"Pro Cultura",null,null,null,null,null,5.0000000000000001E-3]
[]
[null,null,null,null,"Total Gravámenes adicionales",null,null,{"$f":"SUM(H43:I45)","v":3.5999999999999997E-2}]

{"sheet":"Cotización","index":1,"n_rows":120,"n_cols":18,"rows_kept":120,"cut":false,"hidden":false,"merged":[[18,16,18,17],[19,16,19,17],[19,4,19,5],[18,14,18,15],[104,3,105,11],[18,6,18,7],[19,6,19,7],[18,2,18,3],[18,0,18,1],[19,0,19,1],[19,2,19,3],[18,10,18,11],[19,10,19,11],[28,3,28,5],[28,0,28,2],[103,3,103,7],[99,0,99,2],[99,3,99,5],[100,0,100,2],[100,3,100,5],[82,0,82,2],[76,0,76,2],[76,3,76,5],[89,0,89,2],[83,0,83,2],[83,3,83,5],[84,0,84,2],[86,0,86,2],[86,3,86,5],[84,3,84,5],[85,0,85,2],[85,3,85,5],[20,16,20,17],[21,16,21,17],[21,14,21,15],[20,14,20,15],[35,3,35,5],[33,0,33,2],[33,3,33,5],[34,0,34,2],[30,0,30,2],[30,3,30,5],[31,0,31,2],[31,3,31,5],[32,0,32,2],[32,3,32,5],[25,0,25,14],[78,0,78,2],[79,0,79,2],[79,3,79,5],[81,3,81,5],[71,3,71,5],[82,3,82,5],[80,0,80,2],[80,3,80,5],[81,0,81,2],[71,0,71,2],[72,0,72,2],[72,3,72,5],[75,0,75,2],[74,0,74,2],[74,3,74,5],[77,0,77,2],[77,3,77,5],[67,3,67,5],[61,0,61,2],[61,3,61,5],[62,0,62,2],[66,0,66,2],[67,0,67,2],[78,3,78,5],[45,0,45,2],[58,0,58,2],[58,3,58,5],[59,0,59,2],[59,3,59,5],[45,3,45,5],[60,0,60,2],[60,3,60,5],[51,0,51,2],[51,3,51,5],[52,0,52,2],[52,3,52,5],[53,0,53,2],[53,3,53,5],[62,3,62,5],[57,0,57,2],[49,3,49,5],[98,0,98,2],[98,3,98,5],[93,0,93,2],[93,3,93,5],[94,0,94,2],[94,3,94,5],[92,0,92,2],[92,3,92,5],[87,0,87,2],[87,3,87,5],[88,0,88,2],[88,3,88,5],[95,0,95,2],[95,3,95,5],[96,0,96,2],[96,3,96,5],[97,0,97,2],[97,3,97,5],[91,3,91,5],[89,3,89,5],[90,0,90,2],[90,3,90,5],[91,0,91,2],[2,0,2,14],[4,0,4,14],[18,4,18,5],[18,8,18,9],[19,8,19,9],[16,0,16,14],[12,10,12,11],[14,0,14,1],[14,2,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[8,0,8,14],[29,0,29,2],[29,3,29,5],[34,3,34,5],[35,0,35,2],[36,0,36,2],[36,3,36,5],[37,0,37,2],[50,0,50,2],[50,3,50,5],[44,0,44,2],[44,3,44,5],[42,0,42,2],[42,3,42,5],[43,0,43,2],[43,3,43,5],[39,3,39,5],[40,0,40,2],[40,3,40,5],[41,0,41,2],[41,3,41,5],[69,3,69,5],[70,0,70,2],[70,3,70,5],[75,3,75,5],[0,0,1,14],[10,0,10,1],[10,2,10,8],[10,10,10,12],[6,0,6,1],[6,10,6,12],[6,2,6,8],[66,3,66,5],[14,10,14,11],[19,14,19,15],[56,0,56,9],[27,0,27,9],[54,8,54,9],[63,0,63,2],[63,3,63,5],[64,0,64,2],[64,3,64,5],[57,3,57,5],[48,3,48,5],[49,0,49,2],[21,0,21,1],[22,0,23,11],[54,4,54,5],[101,4,101,5],[12,12,12,13],[101,8,101,9],[18,12,18,13],[19,12,19,13],[37,3,37,5],[38,0,38,2],[38,3,38,5],[39,0,39,2],[46,0,46,2],[46,3,46,5],[47,0,47,2],[47,3,47,5],[48,0,48,2],[73,0,73,2],[73,3,73,5],[65,0,65,2],[65,3,65,5],[68,0,68,2],[68,3,68,5],[69,0,69,2]]}
["Cotización",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Solicitud!H47","v":3.5999999999999997E-2}]
[]
["Acuerdo Marco de Precios suministro de Tiquetes Aéreos"]
[1]
["Información del Proveedor"]
[]
["Proveedor",null,"Subatours S.A.S., ",null,null,null,null,null,null,"NIT:",{"$f":"VLOOKUP(C7,Datos!$A$13:$B$18,2,0)","v":"800.075.003-6"}]
[]
["Información de la Entidad Compradora"]
[]
["Nombre de la Entidad:",null,{"$f":"+IF(Solicitud!$C$7=\"\",\"\",Solicitud!$C$7)","v":"Universidad Distrital Francisco José de Caldas"},null,null,null,null,null,null,"NIT:",{"$f":"+IF(Solicitud!$K$7=\"\",\"\",Solicitud!$K$7)","v":"899 999 230-7"}]
[]
["Fecha creación solicitud cotización",null,{"$f":"+IF(Solicitud!$C$17=\"\",\"\",Solicitud!$C$17)","v":"2018-03-05"},null,"Fecha generación OC",null,{"$f":"+IF(Solicitud!$G$17=\"\",\"\",Solicitud!$G$17)","v":"2018-03-19"},null,"Fecha vencimiento OC",null,{"$f":"+IF(Solicitud!$K$17=\"\",\"\",Solicitud!$K$17)","v":"2018-09-16"},null,"Duración OC (Días)",null,{"$f":"+IF(Solicitud!$G$19=\"\",\"\",Solicitud!$G$19)","v":390}]
[]
["Presupuesto de la Entidad",null,{"$f":"+IF(Solicitud!$C$23=\"\",\"\",Solicitud!$C$23)","v":1006284450},null,"% Tiquetes Nacionales",null,{"$f":"Solicitud!G23","v":0.5},null,"% Tiquetes Internacionales",null,{"$f":"IF(G15=\"\",\"\",1-G15)","v":0.5}]
[]
["Asesores"]
[]
["Nombre de la sede",null,"Dirección de la sede",null,"Horario de los asesores",null,"Cantidad de Asesores",null,"Precio Asesor (mes)",null,"Cantidad de meses",null,"Valor asesores",null,"Gravámenes adicionales",null,"Valor Total asesores"]
[{"$f":"Solicitud!C31","v":"Sede administrativa Calle 40"},null,{"$f":"Solicitud!C33","v":"Carrera 7ma N° 40 B 53"},null,{"$f":"Solicitud!C35","v":"8:00 am - 5:00pm"},null,{"$f":"+Solicitud!C29","v":1},null,0,null,{"$f":"+Solicitud!G19/30","v":13},null,{"$f":"+G20*I20*K20","v":0},null,{"$f":"(M20/(1-R1))-M20","v":0},null,{"$f":"M20+O20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA",null,{"$f":"Q20*0.16","v":0}]
["Convenios",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Asesor",null,{"$f":"SUM(Q20:R21)","v":0}]
[{"$f":"IF(Solicitud!K29=\"\",\"\",Solicitud!K29)","v":"Convenio No. 29167-17 (Avianca- Acumulación de Millas), Convenio LATAM Ahorro (Tarifa Económica (15% Nacional, 15%Internacional), Tarifa Flexible (18%Nacional, 18% Internacional), Full Flexible (18% Nacional, 18% Internacional)) "}]
[]
[]
["Descuento Tiquetes Aéreos"]
[]
["% Tiquetes Aéreos Nacionales",null,null,null,null,null,null,null,null,null,{"$f":"IF(Solicitud!$G$23=\"\",\"\",Solicitud!$G$23)","v":0.5}]
["Aerolínea",null,null,"Rango Tarifario",null,null,"Ponderación","Descuento minimo","Descuento adicional","Descuento Total","% Ponderado Nacional"]
["Avianca",null,null,"Clase Económica Rango Promocional",null,null,5.3199999999999997E-2,0.113,5.7000000000000002E-2,{"$f":"+H30+I30","v":0.17},{"$f":"+J30*G30","v":9.044E-3},null,{"$f":"\"Descuento \"&A30&\" \"&D30&\" Nacional\"","v":"Descuento Avianca Clase Económica Rango Promocional Nacional"}]
["Avianca",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,4.8000000000000001E-2,2.1999999999999999E-2,{"$f":"+H31+I31","v":7.0000000000000007E-2},{"$f":"+J31*G31","v":3.6820000000000004E-3},null,{"$f":"\"Descuento \"&A31&\" \"&D31&\" Nacional\"","v":"Descuento Avianca Clase Económica Rango Económico Nacional"}]
["Avianca",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,5.9000000000000004E-2,0.02,7.9000000000000001E-2,4.1554000000000001E-3,null,"Descuento Avianca Clase Económica Rango Flexible Nacional"]
["Avianca",null,null,"Clase Ejecutiva",null,null,5.2600000000000001E-2,0.14300000000000002,null,0.14300000000000002,7.5218000000000012E-3,null,"Descuento Avianca Clase Ejecutiva Nacional"]
["LATAM",null,null,"Clase Económica Rango Promocional",null,null,5.2600000000000001E-2,0.10300000000000001,7.6999999999999999E-2,0.18,9.467999999999999E-3,null,"Descuento LATAM Clase Económica Rango Promocional Nacional"]
["LATAM",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,5.9000000000000004E-2,7.0999999999999994E-2,0.13,6.8380000000000003E-3,null,"Descuento LATAM Clase Económica Rango Económico Nacional"]
["LATAM",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,8.3000000000000004E-2,9.7000000000000003E-2,0.18,9.467999999999999E-3,null,"Descuento LATAM Clase Económica Rango Flexible Nacional"]
["Viva Colombia",null,null,"Clase Económica Rango Promocional",null,null,5.2600000000000001E-2,0.14300000000000002,6.7000000000000004E-2,0.21000000000000002,1.1046000000000002E-2,null,"Descuento Viva Colombia Clase Económica Rango Promocional Nacional"]
["Viva Colombia",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,0.12300000000000001,7.6999999999999999E-2,0.2,1.0520000000000002E-2,null,"Descuento Viva Colombia Clase Económica Rango Económico Nacional"]
["Viva Colombia",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,0.14800000000000002,5.1999999999999998E-2,0.2,1.0520000000000002E-2,null,"Descuento Viva Colombia Clase Económica Rango Flexible Nacional"]
["Satena",null,null,"Clase Económica Rango Promocional",null,null,5.2600000000000001E-2,0.08,0.24,0.32,1.6832E-2,null,"Descuento Satena Clase Económica Rango Promocional Nacional"]
["Satena",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,4.2999999999999997E-2,0.14699999999999999,0.19,9.9940000000000011E-3,null,"Descuento Satena Clase Económica Rango Económico Nacional"]
["Satena",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,4.2999999999999997E-2,0.14699999999999999,0.19,9.9940000000000011E-3,null,"Descuento Satena Clase Económica Rango Flexible Nacional"]
["Easy Fly",null,null,"Clase Económica Rango Promocional",null,null,5.2600000000000001E-2,7.2999999999999995E-2,0.33700000000000002,0.41000000000000003,2.1566000000000002E-2,null,"Descuento Easy Fly Clase Económica Rango Promocional Nacional"]
["Easy Fly",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,4.7E-2,0.123,0.16999999999999998,8.9419999999999986E-3,null,"Descuento Easy Fly Clase Económica Rango Económico Nacional"]
["Easy Fly",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,0.08,0.09,0.16999999999999998,8.9419999999999986E-3,null,"Descuento Easy Fly Clase Económica Rango Flexible Nacional"]
["Copa",null,null,"Clase Económica Rango Promocional",null,null,5.2600000000000001E-2,0.12300000000000001,0.127,0.25,1.315E-2,null,"Descuento Copa Clase Económica Rango Promocional Nacional"]
["Copa",null,null,"Clase Económica Rango Económico",null,null,5.2600000000000001E-2,0.08,0.17,0.25,1.315E-2,null,"Descuento Copa Clase Económica Rango Económico Nacional"]
["Copa",null,null,"Clase Económica Rango Flexible",null,null,5.2600000000000001E-2,0.12300000000000001,0.127,0.25,1.315E-2,null,"Descuento Copa Clase Económica Rango Flexible Nacional"]
["Aero Antioquia",null,null,"Clase Económica Rango Promocional",null,null,0,5.9000000000000004E-2,null,5.9000000000000004E-2,0,null,"Descuento Aero Antioquia Clase Económica Rango Promocional Nacional"]
["Aero Antioquia",null,null,"Clase Económica Rango Económico",null,null,0,3.4000000000000002E-2,null,3.4000000000000002E-2,0,null,"Descuento Aero Antioquia Clase Económica Rango Económico Nacional"]
["Aero Antioquia",null,null,"Clase Económica Rango Flexible",null,null,0,5.7000000000000002E-2,null,5.7000000000000002E-2,0,null,"Descuento Aero Antioquia Clase Económica Rango Flexible Nacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Promocional",null,null,0,0.13300000000000001,null,0.13300000000000001,0,null,"Descuento Otras Aerolíneas Clase Económica Rango Promocional Nacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Económico",null,null,0,0.114,null,0.114,0,null,"Descuento Otras Aerolíneas Clase Económica Rango Económico Nacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Flexible",null,null,0,0.14300000000000002,null,0.14300000000000002,0,null,"Descuento Otras Aerolíneas Clase Económica Rango Flexible Nacional"]
[null,null,null,null,"% Ponderación total:",null,{"$f":"SUM(G30:G54)","v":0.99999999999999978},null,"% Ponderado Nacionales:",null,{"$f":"+SUM(K30:K54)","v":0.19798320000000003}]
[]
["% Tiquetes Aéreos Internacionales",null,null,null,null,null,null,null,null,null,{"$f":"IF($K$28=\"\",\"\",1-$K$28)","v":0.5}]
["Aerolínea",null,null,"Rango Tarifario",null,null,"Ponderación","Descuento minimo","Descuento adicional","Descuento Total","% Ponderado Nacional"]
["Avianca – Aerogal – Taca- Lacsa",null,null,"Clase Económica Rango Promocional",null,null,2.5600000000000001E-2,4.7E-2,4.2999999999999997E-2,{"$f":"+H59+I59","v":0.09},{"$f":"+J59*G59","v":2.3040000000000001E-3},null,{"$f":"\"Descuento \"&A59&\" \"&D59&\" Internacional\"","v":"Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Promocional Internacional"}]
["Avianca – Aerogal – Taca- Lacsa",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,6.0999999999999999E-2,8.9999999999999993E-3,{"$f":"+H60+I60","v":6.9999999999999993E-2},{"$f":"+J60*G60","v":1.6239999999999998E-3},null,{"$f":"\"Descuento \"&A60&\" \"&D60&\" Internacional\"","v":"Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Económico Internacional"}]
["Avianca – Aerogal – Taca- Lacsa",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.12300000000000001,null,0.12300000000000001,2.8536E-3,null,"Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Flexible Internacional"]
["Avianca – Aerogal – Taca- Lacsa",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Avianca – Aerogal – Taca- Lacsa Clase Ejecutiva Internacional"]
["Copa",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,5.2999999999999999E-2,0.1,2.32E-3,null,"Descuento Copa Clase Económica Rango Promocional Internacional"]
["Copa",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,7.2999999999999995E-2,1.7000000000000001E-2,0.09,2.0879999999999996E-3,null,"Descuento Copa Clase Económica Rango Económico Internacional"]
["Copa",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.124,null,0.124,2.8767999999999997E-3,null,"Descuento Copa Clase Económica Rango Flexible Internacional"]
["Copa",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14800000000000002,null,0.14800000000000002,3.4336000000000002E-3,null,"Descuento Copa Clase Ejecutiva Internacional"]
["American Airlines",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,4.2999999999999997E-2,0.09,2.0879999999999996E-3,null,"Descuento American Airlines Clase Económica Rango Promocional Internacional"]
["American Airlines",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,7.2999999999999995E-2,1.7000000000000001E-2,0.09,2.0879999999999996E-3,null,"Descuento American Airlines Clase Económica Rango Económico Internacional"]
["American Airlines",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.124,null,0.124,2.8767999999999997E-3,null,"Descuento American Airlines Clase Económica Rango Flexible Internacional"]
["American Airlines",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14400000000000002,null,0.14400000000000002,3.3408000000000001E-3,null,"Descuento American Airlines Clase Ejecutiva Internacional"]
["LATAM",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,9.2999999999999999E-2,0.14000000000000001,3.248E-3,null,"Descuento LATAM Clase Económica Rango Promocional Internacional"]
["LATAM",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,7.2999999999999995E-2,2.7E-2,9.9999999999999992E-2,2.3199999999999996E-3,null,"Descuento LATAM Clase Económica Rango Económico Internacional"]
["LATAM",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.124,null,0.124,2.8767999999999997E-3,null,"Descuento LATAM Clase Económica Rango Flexible Internacional"]
["LATAM",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14400000000000002,null,0.14400000000000002,3.3408000000000001E-3,null,"Descuento LATAM Clase Ejecutiva Internacional"]
["Jet Blue",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,9.6999999999999989E-2,3.0000000000000001E-3,9.9999999999999992E-2,2.3199999999999996E-3,null,"Descuento Jet Blue Clase Económica Rango Promocional Internacional"]
["Jet Blue",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,9.6999999999999989E-2,3.0000000000000001E-3,9.9999999999999992E-2,2.3199999999999996E-3,null,"Descuento Jet Blue Clase Económica Rango Económico Internacional"]
["Jet Blue",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.124,null,0.124,2.8767999999999997E-3,null,"Descuento Jet Blue Clase Económica Rango Flexible Internacional"]
["Jet Blue",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Jet Blue Clase Ejecutiva Internacional"]
["Spirit",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,0.14699999999999999,null,0.14699999999999999,3.4103999999999996E-3,null,"Descuento Spirit Clase Económica Rango Promocional Internacional"]
["Spirit",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,0.14699999999999999,null,0.14699999999999999,3.4103999999999996E-3,null,"Descuento Spirit Clase Económica Rango Económico Internacional"]
["Spirit",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.14699999999999999,null,0.14699999999999999,3.4103999999999996E-3,null,"Descuento Spirit Clase Económica Rango Flexible Internacional"]
["United",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,4.2999999999999997E-2,0.09,2.0879999999999996E-3,null,"Descuento United Clase Económica Rango Promocional Internacional"]
["United",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,9.6999999999999989E-2,null,9.6999999999999989E-2,2.2503999999999996E-3,null,"Descuento United Clase Económica Rango Económico Internacional"]
["United",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.124,null,0.124,2.8767999999999997E-3,null,"Descuento United Clase Económica Rango Flexible Internacional"]
["United",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento United Clase Ejecutiva Internacional"]
["Iberia",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,4.2999999999999997E-2,0.09,2.0879999999999996E-3,null,"Descuento Iberia Clase Económica Rango Promocional Internacional"]
["Iberia",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,8.4000000000000005E-2,null,8.4000000000000005E-2,1.9487999999999999E-3,null,"Descuento Iberia Clase Económica Rango Económico Internacional"]
["Iberia",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.13300000000000001,null,0.13300000000000001,3.0856E-3,null,"Descuento Iberia Clase Económica Rango Flexible Internacional"]
["Iberia",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Iberia Clase Ejecutiva Internacional"]
["Lufthansa",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.7E-2,4.2999999999999997E-2,0.09,2.0879999999999996E-3,null,"Descuento Lufthansa Clase Económica Rango Promocional Internacional"]
["Lufthansa",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,4.7E-2,null,4.7E-2,1.0903999999999998E-3,null,"Descuento Lufthansa Clase Económica Rango Económico Internacional"]
["Lufthansa",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.13300000000000001,null,0.13300000000000001,3.0856E-3,null,"Descuento Lufthansa Clase Económica Rango Flexible Internacional"]
["Lufthansa",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Lufthansa Clase Ejecutiva Internacional"]
["Delta",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,4.9000000000000002E-2,4.1000000000000002E-2,0.09,2.0879999999999996E-3,null,"Descuento Delta Clase Económica Rango Promocional Internacional"]
["Delta",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,4.9000000000000002E-2,null,4.9000000000000002E-2,1.1367999999999999E-3,null,"Descuento Delta Clase Económica Rango Económico Internacional"]
["Delta",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.13300000000000001,null,0.13300000000000001,3.0856E-3,null,"Descuento Delta Clase Económica Rango Flexible Internacional"]
["Delta",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Delta Clase Ejecutiva Internacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Promocional",null,null,2.3199999999999998E-2,5.7000000000000002E-2,3.3000000000000002E-2,0.09,2.0879999999999996E-3,null,"Descuento Otras Aerolíneas Clase Económica Rango Promocional Internacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Económico",null,null,2.3199999999999998E-2,8.4000000000000005E-2,null,8.4000000000000005E-2,1.9487999999999999E-3,null,"Descuento Otras Aerolíneas Clase Económica Rango Económico Internacional"]
["Otras Aerolíneas",null,null,"Clase Económica Rango Flexible",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Otras Aerolíneas Clase Económica Rango Flexible Internacional"]
["Otras Aerolíneas",null,null,"Clase Ejecutiva",null,null,2.3199999999999998E-2,0.14300000000000002,null,0.14300000000000002,3.3176E-3,null,"Descuento Otras Aerolíneas Clase Ejecutiva Internacional"]
[null,null,null,null,"% Ponderación total:",null,{"$f":"+SUM(G59:G101)","v":0.99999999999999989},null,"% Ponderado Internacionales:",null,{"$f":"+SUM(K59:K101)","v":0.11491680000000001}]
[]
[null,null,null,"Descuento total ponderado Cotización",null,null,null,null,{"$f":"(K102*K57)+(K55*K28)-(Q22/C15)","v":0.15645000000000003}]
[null,null,null,"El descuento cotizado no incluye los gravámenes adicionales (estampillas). El Proveedor en la facturación ajusta el porcentaje de descuento para cubrir los gravámenes adicionales."]
[]
[]
[]
[]
[]
[null,"DP= Descuento ponderado de la Cotización"]
[null,"XI= Peso estimado por la Entidad Compradora para los Tiquetes Aéreos internacionales"]
[null,"XN= Peso estimado por la Entidad Compradora para los Tiquetes Aéreos nacionales"]
[null,"DIi= Es el descuento cotizado para el Ítem i en Tiquetes Aéreos internacionales"]
[null,"PIi= Es el porcentaje de ponderación del Ítem i en Tiquetes Aéreos internacionales de acuerdo con la tabla publicada en el Catálogo."]
[null,"DNi= Es el descuento Cotizado para el Ítem i en Tiquetes Aéreos nacionales."]
[null,"PNi= Es el porcentaje de ponderación del Ítem i en Tiquetes Aéreos nacionales de acuerdo con la tabla publicada en el Catálogo."]
[null,"A = Precio total mensual del asesor Implant (para Entidades Compradoras que hayan solicitado un asesor Implant en Órdenes de Compra de menos de $1.000.000.000 promedio anual). "]
[null,"T = Tiempo en meses de la Orden de Compra"]
[null,"PT = Valor total de la Orden de Compra "]

{"sheet":"Datos","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Promedio anual de la Orden de Compra","Número máximo de Asesores Implant"]
["Menor a $1.000.000.000",0,"Tiene precio, no hay techo"]
["$1.000.000.000 hasta $1.500.000.000",1,"gratis"]
["$1.500.000.001 hasta $2.000.000.000",2,"gratis"]
["$2.000.000.001 hasta $2.500.000.000",3,"gratis"]
["$2.500.000.001 o mayor",4,"gratis"]
[]
[]
[]
["Proveedor","NIT"]
["Expreso Viajes y Turismo Expreso S.A.S.","800.206.979-2"]
["Agencia de Viajes y Turismo Goldtour S.A.S.","800.212.545-4"]
["Mayatur S.A.S.","860.015.826-2"]
["Servicio Aéreo a Territorios Nacionales S.A.","899.999.143-4"]
["Subatours S.A.S., ","800.075.003-6"]
["Unión Temporal Novatours – Vision Tours 04-2015","900.889.896-2"]

{"sheet":"BDPorcentajes","index":3,"n_rows":70,"n_cols":7,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Expreso Viajes y Turismo Expreso S.A.S.","Subatours S.A.S., ","Mayatur S.A.S.","Servicio Aéreo a Territorios Nacionales S.A.","Agencia de Viajes y Turismo Goldtour S.A.S.","Unión Temporal Novatours – Vision Tours 04-2015"]
["Descuento Avianca Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.113,3.5000000000000003E-2,0.04,0.1,0.03]
["Descuento Avianca Clase Económica Rango Económico Nacional",3.7999999999999999E-2,4.8000000000000001E-2,3.5000000000000003E-2,0.04,0.08,0.03]
["Descuento Avianca Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,5.9000000000000004E-2,3.5000000000000003E-2,0.04,0.06,1.3000000000000001E-2]
["Descuento Avianca Clase Ejecutiva Nacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,3.5000000000000003E-2,0.12,0.01]
["Descuento LATAM Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.10300000000000001,3.5000000000000003E-2,0.06,0.1,5.7999999999999996E-2]
["Descuento LATAM Clase Económica Rango Económico Nacional",3.7999999999999999E-2,5.9000000000000004E-2,3.5000000000000003E-2,0.06,0.08,5.7999999999999996E-2]
["Descuento LATAM Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,8.3000000000000004E-2,3.5000000000000003E-2,0.06,0.06,5.7999999999999996E-2]
["Descuento Viva Colombia Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.03,0.1,5.0000000000000001E-3]
["Descuento Viva Colombia Clase Económica Rango Económico Nacional",3.7999999999999999E-2,0.12300000000000001,3.5000000000000003E-2,0.03,0.08,5.0000000000000001E-3]
["Descuento Viva Colombia Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,0.14800000000000002,3.5000000000000003E-2,0.03,0.06,5.0000000000000001E-3]
["Descuento Satena Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.08,3.5000000000000003E-2,3.2000000000000001E-2,0.1,0.03]
["Descuento Satena Clase Económica Rango Económico Nacional",3.7999999999999999E-2,4.2999999999999997E-2,3.5000000000000003E-2,2.5000000000000001E-2,0.08,0.03]
["Descuento Satena Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,4.2999999999999997E-2,3.5000000000000003E-2,2.3E-2,0.06,0.03]
["Descuento Easy Fly Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,7.2999999999999995E-2,3.5000000000000003E-2,0.05,0.1,0.06]
["Descuento Easy Fly Clase Económica Rango Económico Nacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.05,0.08,0.06]
["Descuento Easy Fly Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,0.08,3.5000000000000003E-2,0.05,0.06,0.06]
["Descuento Copa Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.12300000000000001,3.5000000000000003E-2,0.04,0.1,0.03]
["Descuento Copa Clase Económica Rango Económico Nacional",3.7999999999999999E-2,0.08,3.5000000000000003E-2,0.04,0.08,0.03]
["Descuento Copa Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,0.12300000000000001,3.5000000000000003E-2,0.04,0.06,0.03]
["Descuento Aero Antioquia Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,5.9000000000000004E-2,3.5000000000000003E-2,0.03,0.1,0.01]
["Descuento Aero Antioquia Clase Económica Rango Económico Nacional",3.7999999999999999E-2,3.4000000000000002E-2,3.5000000000000003E-2,0.03,0.08,0.01]
["Descuento Aero Antioquia Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,5.7000000000000002E-2,3.5000000000000003E-2,0.03,0.06,0.01]
["Descuento Otras Aerolíneas Clase Económica Rango Promocional Nacional",3.7999999999999999E-2,0.13300000000000001,3.5000000000000003E-2,0.03,0.1,0.01]
["Descuento Otras Aerolíneas Clase Económica Rango Económico Nacional",3.7999999999999999E-2,0.114,3.5000000000000003E-2,0.03,0.08,0.01]
["Descuento Otras Aerolíneas Clase Económica Rango Flexible Nacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.03,0.06,0.01]
["Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.03]
["Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Económico Internacional",3.7999999999999999E-2,6.0999999999999999E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.02]
["Descuento Avianca – Aerogal – Taca- Lacsa Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.12300000000000001,3.5000000000000003E-2,3.5000000000000003E-2,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento Avianca – Aerogal – Taca- Lacsa Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,3.5000000000000003E-2,0.12,0.01]
["Descuento Copa Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,1.3000000000000001E-2]
["Descuento Copa Clase Económica Rango Económico Internacional",3.7999999999999999E-2,7.2999999999999995E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,1.3000000000000001E-2]
["Descuento Copa Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.124,3.5000000000000003E-2,3.5000000000000003E-2,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento Copa Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14800000000000002,3.5000000000000003E-2,3.5000000000000003E-2,0.12,1.3000000000000001E-2]
["Descuento American Airlines Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.04,0.04,1.3000000000000001E-2]
["Descuento American Airlines Clase Económica Rango Económico Internacional",3.7999999999999999E-2,7.2999999999999995E-2,3.5000000000000003E-2,0.04,0.04,1.3000000000000001E-2]
["Descuento American Airlines Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.124,3.5000000000000003E-2,0.04,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento American Airlines Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14400000000000002,3.5000000000000003E-2,0.04,0.12,1.3000000000000001E-2]
["Descuento LATAM Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.04,0.04,0.04]
["Descuento LATAM Clase Económica Rango Económico Internacional",3.7999999999999999E-2,7.2999999999999995E-2,3.5000000000000003E-2,0.04,0.04,0.04]
["Descuento LATAM Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.124,3.5000000000000003E-2,0.04,7.0000000000000007E-2,0.04]
["Descuento LATAM Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14400000000000002,3.5000000000000003E-2,0.04,0.12,0.01]
["Descuento Jet Blue Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,9.6999999999999989E-2,3.5000000000000003E-2,0.02,0.04,0.03]
["Descuento Jet Blue Clase Económica Rango Económico Internacional",3.7999999999999999E-2,9.6999999999999989E-2,3.5000000000000003E-2,0.02,0.04,0.03]
["Descuento Jet Blue Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.124,3.5000000000000003E-2,0.02,7.0000000000000007E-2,0.03]
["Descuento Jet Blue Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.02,0.12,0.03]
["Descuento Spirit Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,0.14699999999999999,3.5000000000000003E-2,0.02,0.04,0.01]
["Descuento Spirit Clase Económica Rango Económico Internacional",3.7999999999999999E-2,0.14699999999999999,3.5000000000000003E-2,0.02,0.04,0.01]
["Descuento Spirit Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.14699999999999999,3.5000000000000003E-2,0.02,7.0000000000000007E-2,0.01]
["Descuento United Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.03,0.04,1.3000000000000001E-2]
["Descuento United Clase Económica Rango Económico Internacional",3.7999999999999999E-2,9.6999999999999989E-2,3.5000000000000003E-2,0.03,0.04,1.3000000000000001E-2]
["Descuento United Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.124,3.5000000000000003E-2,0.03,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento United Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.03,0.12,1.3000000000000001E-2]
["Descuento Iberia Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Iberia Clase Económica Rango Económico Internacional",3.7999999999999999E-2,8.4000000000000005E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Iberia Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.13300000000000001,3.5000000000000003E-2,0.02,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento Iberia Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.02,0.12,1.3000000000000001E-2]
["Descuento Lufthansa Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Lufthansa Clase Económica Rango Económico Internacional",3.7999999999999999E-2,4.7E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Lufthansa Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.13300000000000001,3.5000000000000003E-2,0.02,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento Lufthansa Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.02,0.12,1.3000000000000001E-2]
["Descuento Delta Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,4.9000000000000002E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.01]
["Descuento Delta Clase Económica Rango Económico Internacional",3.7999999999999999E-2,4.9000000000000002E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.05]
["Descuento Delta Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.13300000000000001,3.5000000000000003E-2,3.5000000000000003E-2,7.0000000000000007E-2,0.05]
["Descuento Delta Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,3.5000000000000003E-2,0.12,0.03]
["Descuento Otras Aerolíneas Clase Económica Rango Promocional Internacional",3.7999999999999999E-2,5.7000000000000002E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Otras Aerolíneas Clase Económica Rango Económico Internacional",3.7999999999999999E-2,8.4000000000000005E-2,3.5000000000000003E-2,0.02,0.04,1.3000000000000001E-2]
["Descuento Otras Aerolíneas Clase Económica Rango Flexible Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.02,7.0000000000000007E-2,1.3000000000000001E-2]
["Descuento Otras Aerolíneas Clase Ejecutiva Internacional",3.7999999999999999E-2,0.14300000000000002,3.5000000000000003E-2,0.02,0.12,1.3000000000000001E-2]