{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SolCotizacion","ResumenCotizacion","Cotizacion","CSV","LISTAS","Consolidado"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":41,"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":"SolCotizacion","index":0,"n_rows":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,1,3,15],[5,12,5,15],[7,4,7,8],[7,12,7,15],[11,1,11,3],[11,4,11,8],[30,19,30,21],[31,16,31,18],[31,19,31,21],[30,16,30,18],[5,1,5,3],[5,4,5,8],[5,10,5,11],[13,1,13,3],[13,4,13,8],[9,10,9,11],[7,10,7,11],[9,12,9,15],[9,1,9,3],[9,4,9,8],[7,1,7,3],[18,1,18,2],[18,3,18,6],[15,1,15,15],[20,1,20,2],[22,2,22,10],[26,1,26,15],[30,2,30,10],[30,12,30,15],[31,2,31,10],[31,12,31,15],[0,1,0,15],[1,1,1,15],[40,1,40,4],[40,5,40,6],[38,2,38,6],[34,1,34,15],[32,1,32,3],[32,12,32,15],[32,8,32,11],[23,2,23,10],[22,12,22,15],[23,12,23,15],[36,1,36,2],[39,2,39,6],[28,1,28,2],[24,1,24,3]]}
[null,"SOLICITUD DE COTIZACIÓN"]
[null,"Hemofilia y otros trastornos de coagulación"]
[null,"Versión: 12",null,"2024-01-05","Nota: Los medicamentos Eloctate® y Alprolix® fueron retirados del catalogo debido a que se dejaron de producir para Colombia."]
[null,"Información de la Entidad Compradora"]
[]
[null,"Nombre de la Entidad",null,null,null,null,null,null,null,null,"NIT"]
[]
[null,"Dirección de la Entidad",null,null,null,null,null,null,null,null,"Correo de contacto"]
[]
[null,"Municipio",null,null,null,null,null,null,null,null,"Teléfono de contacto"]
[]
[null,"Nombre funcionario Comprador"]
[]
[]
[]
[null,"Solicitud de Cotización"]
[]
[]
[null,"Meses de tratamiento"]
[null,"1) Filas a agregar o eliminar:"]
[null,1]
[]
[null,"No.","Factores de Coagulación",null,null,null,null,null,null,null,null,"Unidad","Consumo estimado de Factores de Coagulación (mensual)"]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C24,LISTAS!$AL$2:$AM$58,2,0)","v":{"$error":"#N/A"}}]
[null,"1) Si requiere agregue o elimine filas."]
[]
[null,"Ubicación de los Pacientes"]
[null,"2) Filas a agregar o eliminar:"]
[null,1]
[null,1]
[null,"No.","Severidad del trastorno de coagulación",null,null,null,null,null,null,null,null,"Unidad","Número de Pacientes",null,null,null,"Departamento",null,null,"Municipio o Ciudad",null,null,"Rural o Urbana"]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C32,LISTAS!$AO$2:$AP$14,2,0)","v":{"$error":"#N/A"}},null,null,null,null,"BOGOTÁ, D. C.",null,null,"BOGOTÁ, D.C.",null,null,"Urbana"]
[null,"2) Si requiere agregue o elimine filas.",null,null,null,null,null,null,"Total Pacientes",null,null,null,{"$f":"SUM(M32:M32)","v":0}]
[]
[null,"Gravámenes adicionales (estampillas)"]
[null,"3) Filas a agregar o eliminar:"]
[null,1]
[]
[null,"No.","Descripción",null,null,null,null,"Porcentaje"]
[null,1]
[null,"3) Si requiere agregue o elimine filas Gravámenes.",null,null,null,"Total porcentaje:",null,{"$f":"SUM(H40:H40)","v":0}]

{"sheet":"ResumenCotizacion","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,13,32,17],[7,12,7,15],[9,1,9,3],[9,4,9,8],[9,10,9,11],[9,12,9,15],[7,1,7,3],[7,4,7,8],[7,10,7,11],[20,12,20,15],[21,12,21,15],[24,12,24,15],[21,2,21,10],[20,2,20,10],[29,2,29,6],[31,5,31,6],[30,2,30,6],[30,13,30,17],[31,13,31,17],[3,1,3,15],[5,1,5,3],[5,4,5,8],[5,10,5,11],[5,12,5,15],[11,1,11,3],[13,1,13,3],[13,4,13,8],[15,1,15,15],[11,4,11,8],[25,12,25,15],[28,1,28,7],[0,1,0,15],[1,1,1,15],[18,1,18,2],[18,3,18,6],[26,1,26,3],[24,2,24,10],[25,2,25,10],[23,1,23,4],[22,1,22,3]]}
[null,"RESUMEN DE COTIZACIÓN"]
[null,"Hemofilia y otros trastornos de coagulación"]
[null,{"$f":"+SolCotizacion!B3","v":"Versión: 12"},{"$f":"+SolCotizacion!D3","v":"2024-01-05"},null,{"$f":"+SolCotizacion!E3","v":"Nota: Los medicamentos Eloctate® y Alprolix® fueron retirados del catalogo debido a que se dejaron de producir para Colombia."}]
[null,"Información de la Entidad Compradora"]
[]
[null,"Nombre de la Entidad:",null,null,{"$f":"IF(SolCotizacion!$E$6 = \"\",\"\",SolCotizacion!$E$6)","v":""},null,null,null,null,null,"NIT",null,{"$f":"IF(SolCotizacion!$M$6 = \"\",\"\",SolCotizacion!$M$6)","v":""}]
[]
[null,"Dirección de la Entidad:",null,null,{"$f":"IF(SolCotizacion!$E$8 = \"\",\"\",SolCotizacion!$E$8)","v":""},null,null,null,null,null,"Correo de contacto",null,{"$f":"IF(SolCotizacion!$M$8 = \"\",\"\",SolCotizacion!$M$8)","v":""}]
[]
[null,"Municipio:",null,null,{"$f":"IF(SolCotizacion!$E$10 = \"\",\"\",SolCotizacion!$E$10)","v":""},null,null,null,null,null,"Teléfono de contacto",null,{"$f":"IF(SolCotizacion!$M$10 = \"\",\"\",SolCotizacion!$M$10)","v":""}]
[]
[null,"Nombre funcionario Comprador:",null,null,{"$f":"IF(SolCotizacion!$E$12 = \"\",\"\",SolCotizacion!$E$12)","v":""}]
[]
[]
[]
[null,"Resumen de Cotización"]
[]
[]
[null,"Meses de tratamiento",null,{"$f":"SolCotizacion!$D$19","v":0}]
[]
[null,"No.","Factores de Coagulación",null,null,null,null,null,null,null,null,"Unidad","Consumo estimado de Factores de Coagulación (mensual)",null,null,null,"Precio \n(mensual)","Precio + Gravámenes","Precio * No. Total de meses de prestación del Tratamiento","Total del Tratamiento"]
["Und",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M22<>\"\",VLOOKUP(C22,Consolidado!$A$1:$I$71,9,0),0)","v":0},{"$f":"Q22 + ((Q22*(VLOOKUP($F$32,F:H,3,0)))/100%)","v":0},{"$f":"$D$19*R22","v":0},{"$f":"S22*M22","v":0}]
[null,"1) Si requiere agregue o elimine filas."]
[]
[null,"No.","Severidad del trastorno de coagulación",null,null,null,null,null,null,null,null,"Unidad","No. de Pacientes estimados (mensual)",null,null,null,"Precio \n(mensual)","Precio + Gravámenes","Precio * No. Total de meses de prestación del Tratamiento","Total del Tratamiento"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M26<>\"\",VLOOKUP(C26,Consolidado!$A$1:$I$71,9,0),0)","v":0},{"$f":"Q26 + ((Q26*(VLOOKUP($F$32,F:H,3,0)))/100%)","v":0},{"$f":"$D$19*R26","v":0},{"$f":"S26*M26","v":0}]
[null,"2) Si requiere agregue o elimine filas."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(T22:T26)","v":0}]
[null,"Gravámenes adicionales (estampillas)"]
[null,"No.","Descripción",null,null,null,null,"Porcentaje"]
[null,1]
[null,"3) Si requiere agregue o elimine filas Gravámenes.",null,null,null,"Total_Porcentaje:",null,{"$f":"SUM(H31:H31)","v":0}]

{"sheet":"Cotizacion","index":2,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,1,22,3],[23,1,23,4],[7,1,7,3],[7,4,7,8],[7,10,7,11],[11,1,11,3],[11,4,11,8],[13,1,13,3],[13,4,13,8],[0,1,0,15],[1,1,1,15],[7,12,7,15],[9,1,9,3],[9,4,9,8],[9,10,9,11],[9,12,9,15],[3,1,3,15],[5,1,5,3],[5,4,5,8],[5,10,5,11],[5,12,5,15],[21,12,21,15],[21,2,21,10],[15,1,15,15],[20,12,20,15],[18,1,18,2],[18,3,18,6],[18,8,18,9],[18,10,18,15],[20,2,20,10],[26,1,26,3],[31,5,31,6],[24,12,24,15],[24,2,24,10],[25,2,25,10],[28,1,28,7],[29,2,29,6],[30,2,30,6],[25,12,25,15]]}
[null,"COTIZACIÓN"]
[null,"Hemofilia y otros trastornos de coagulación"]
[null,{"$f":"+SolCotizacion!B3","v":"Versión: 12"},{"$f":"+SolCotizacion!D3","v":"2024-01-05"},null,"Nota: Los medicamentos Eloctate® y Alprolix® fueron retirados del catalogo debido a que se dejaron de producir para Colombia."]
[null,"Información de la Entidad Compradora"]
[]
[null,"Nombre de la Entidad:",null,null,{"$f":"IF(SolCotizacion!$E$6=\"\",\"\",SolCotizacion!$E$6)","v":""},null,null,null,null,null,"NIT",null,{"$f":"IF(SolCotizacion!$M$6=\"\",\"\",SolCotizacion!$M$6)","v":""}]
[]
[null,"Dirección de la Entidad:",null,null,{"$f":"IF(SolCotizacion!$E$8=\"\",\"\",SolCotizacion!$E$8)","v":""},null,null,null,null,null,"Correo de contacto",null,{"$f":"IF(SolCotizacion!$M$8=\"\",\"\",SolCotizacion!$M$8)","v":""}]
[]
[null,"Municipio:",null,null,{"$f":"IF(SolCotizacion!$E$10=\"\",\"\",SolCotizacion!$E$10)","v":""},null,null,null,null,null,"Teléfono de contacto",null,{"$f":"IF(SolCotizacion!$M$10=\"\",\"\",SolCotizacion!$M$10)","v":""}]
[]
[null,"Nombre funcionario Comprador:",null,null,{"$f":"IF(SolCotizacion!$E$12=\"\",\"\",SolCotizacion!$E$12)","v":""}]
[]
[]
[]
[null,"Resumen de Cotización"]
[]
[]
[null,"Meses de tratamiento",null,{"$f":"IF(SolCotizacion!$D$19=\"\",\"\",SolCotizacion!$D$19)","v":""},null,null,null,null,"Proveedor",null,"MEDICARTE S.A."]
[]
[null,"No.","Factores de Coagulación",null,null,null,null,null,null,null,null,"Unidad","No. de Pacientes estimados (mensual)",null,null,null,"Precio \n(mensual)","Precio + Gravámenes","Descuento","Precio con Descuento","Precio * No. Total de meses de prestación del Tratamiento","Aplicar IVA","Total del Tratamiento(Con o sin IVA)"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Consolidado!$B$2:$F$71,MATCH(C22,Consolidado!$A$2:$A$71,0),MATCH($K$19,Consolidado!$B$1:$F$1,0)),0)","v":0},{"$f":"Q22 + ((Q22*(VLOOKUP($F$32,F:H,3,0)))/100%)","v":0},null,{"$f":"R22*(1-S22)","v":0},{"$f":"IFERROR($D$19*T22,0)","v":0},null,{"$f":"IF(V22=\"Si\",(U22*M22) + ((U22*M22)*19%),U22*M22)","v":0}]
[null,"1) Si requiere agregue o elimine filas."]
[]
[null,"No.","Severidad del trastorno de coagulación",null,null,null,null,null,null,null,null,"Unidad","No. de Pacientes estimados (mensual)",null,null,null,"Precio \n(mensual)","Precio + Gravámenes","Descuento","Precio con Descuento","Precio * No. Total de meses de prestación del Tratamiento","Aplicar IVA","Total del Tratamiento(Con o sin IVA)"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Consolidado!$B$2:$F$71,MATCH(C26,Consolidado!$A$2:$A$71,0),MATCH($K$19,Consolidado!$B$1:$F$1,0)),0)","v":0},{"$f":"Q26 + ((Q26*(VLOOKUP($F$32,F:H,3,0)))/100%)","v":0},null,{"$f":"R26*(1-S26)","v":0},{"$f":"IFERROR($D$19*T26,0)","v":0},null,{"$f":"IF(V26=\"Si\",(U26*M26) + ((U26*M26)*19%),U26*M26)","v":0}]
[null,"2) Si requiere agregue o elimine filas."]
[null,null,null,null,null,null,null,{"$f":"SUM(H27:H27)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W22:W26)","v":0}]
[null,"Gravámenes adicionales (estampillas)"]
[null,"No","Descripción",null,null,null,null,"Porcentaje"]
[null,1]
[null,"3) Si requiere agregue o elimine filas Gravámenes.",null,null,null,"Total_Porcentaje:",null,{"$f":"SUM(H31:H31)","v":0}]

{"sheet":"CSV","index":3,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Tipo","Cantidad","CÃ³digo de unidad de medida*","Precio base","Divisa","DescripciÃ³n","MercancÃ­a"]
["item",20,"UI","\"1150566,9\"","COP","hem02ADVATE 500 UI"]
["item",30,"UI","\"4356191,7\"","COP","hem02ADYNOVATE 2000 UI / VIAL"]
["item",2,"Und","\"52689\"","COP","hem02ValoraciÃ³n trabajo social por paciente"]
["item",4,"Und","\"583220,4\"","COP","hem02Tratamiento integral Hemofilia moderada y EvW tipo III (mensual)"]

{"sheet":"LISTAS","index":4,"n_rows":124,"n_cols":43,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["Proveedor","Severidad","Departamento","AMAZONAS","ANTIOQUIA","ARAUCA","ARCHIPIÉLAGODESANANDRÉSPROVIDENCIAY","ATLÁNTICO","BOGOTÁDC","BOLÍVAR","BOYACÁ","CALDAS","CAQUETÁ","CASANARE","CAUCA","CESAR","CHOCÓ","CÓRDOBA","CUNDINAMARCA","GUAINÍA","GUAVIARE","HUILA","LAGUAJIRA","MAGDALENA","META","NARIÑO","NORTEDESANTANDER","QUINDÍO","RISARALDA","SANTANDER","SUCRE","TOLIMA","VALLEDELCAUCA","VAUPÉS","VICHADA","PUTUMAYO",null,"BIENES","UND",null,"SERVICIOS","UND","IVA"]
["MEDICARTE S.A.","Hemofilia leve y EvW tipo I y II (mensual)","AMAZONAS","EL ENCANTO","ABEJORRAL","ARAUCA","PROVIDENCIA","BARANOA","BOGOTÁ, D.C.","ACHÍ","ALMEIDA","AGUADAS","ALBANIA","AGUAZUL","ALMAGUER","AGUACHICA","ACANDÍ","AYAPEL","AGUA DE DIOS","BARRANCO MINAS","CALAMAR","ACEVEDO","ALBANIA","ALGARROBO","ACACÍAS","ALBÁN","ÁBREGO","ARMENIA","APÍA","AGUADA","BUENAVISTA","ALPUJARRA","ALCALÁ","CARURÚ","CUMARIBO","COLÓN",null,"ADVATE 1000UI","UI",null,"Apoyos diagnósticos (laboratorio clínico e imágenes diagnósticas) por paciente","Und","Si"]
["IPS ESPECIALIZADA","Hemofilia moderada y EvW tipo III (mensual)","ANTIOQUIA","LA CHORRERA","ABRIAQUÍ","ARAUQUITA","SAN ANDRÉS","BARRANQUILLA",null,"ALTOS DEL ROSARIO","AQUITANIA","ANSERMA","BELÉN DE LOS ANDAQUÍES","CHÁMEZA","ARGELIA","AGUSTÍN CODAZZI","ALTO BAUDÓ","BUENAVISTA","ALBÁN","CACAHUAL","EL RETORNO","AGRADO","BARRANCAS","ARACATACA","BARRANCA DE UPÍA","ALDANA","ARBOLEDAS","BUENAVISTA","BALBOA","ALBANIA","CAIMITO","ALVARADO","ANDALUCÍA","MITÚ","LA PRIMAVERA","MOCOA",null,"ADVATE 250 UI","UI",null,"Asesoría en planificación familiar por paciente","Und","No"]
[null,"Hemofilia severa (mensual)","ARAUCA","LA PEDRERA","ALEJANDRÍA","CRAVO NORTE",null,"CAMPO DE LA CRUZ",null,"ARENAL","ARCABUCO","ARANZAZU","CARTAGENA DEL CHAIRÁ","HATO COROZAL","BALBOA","ASTREA","ATRATO","CANALETE","ANAPOIMA","INÍRIDA","MIRAFLORES","AIPE","DIBULLA","ARIGUANÍ","CABUYARO","ANCUYÁ","BOCHALEMA","CALARCÁ","BELÉN DE UMBRÍA","ARATOCA","CHALÁN","AMBALEMA","ANSERMANUEVO","PACOA","PUERTO CARREÑO","ORITO",null,"ADVATE 500 UI","UI",null,"Consejería genética por paciente","Und"]
[null,null,"ARCHIPIÉLAGO DE SAN ANDRÉS, PROVIDENCIA Y","LA VICTORIA","AMAGÁ","FORTUL",null,"CANDELARIA",null,"ARJONA","BELÉN","BELALCÁZAR","CURILLO","LA SALINA","BOLÍVAR","BECERRIL","BAGADÓ","CERETÉ","ANOLAIMA","LA GUADALUPE","SAN JOSÉ DEL GUAVIARE","ALGECIRAS","DISTRACCIÓN","CERRO DE SAN ANTONIO","CASTILLA LA NUEVA","ARBOLEDA","BUCARASICA","CIRCASIA","DOSQUEBRADAS","BARBOSA","COLOSÓ","ANZOÁTEGUI","ARGELIA","PAPUNAUA","SANTA ROSALÍA","PUERTO ASÍS",null,"ADYNOVATE 1000 UI / VIAL","UI",null,"Consulta psicología por paciente","Und"]
[null,null,"ATLÁNTICO","LETICIA","AMALFI","PUERTO RONDÓN",null,"GALAPA",null,"ARROYOHONDO","BERBEO","CHINCHINÁ","EL DONCELLO","MANÍ","BUENOS AIRES","BOSCONIA","BAHÍA SOLANO","CHIMÁ","APULO","MAPIRIPANA",null,"ALTAMIRA","EL MOLINO","CHIVOLO","CUBARRAL","BARBACOAS","CÁCHIRA","CÓRDOBA","GUÁTICA","BARICHARA","COROZAL","ARMERO GUAYABAL","BOLÍVAR","TARAIRA",null,"PUERTO CAICEDO",null,"ADYNOVATE 2000 UI / VIAL","UI",null,"Tratamiento integral Hemofilia leve y EvW tipo I y II (mensual)","Und"]
[null,null,"BOGOTÁ, D. C.","MIRITÍ - PARANÁ","ANDES","SARAVENA",null,"JUAN DE ACOSTA",null,"BARRANCO DE LOBA","BETÉITIVA","FILADELFIA","EL PAUJÍL","MONTERREY","CAJIBÍO","CHIMICHAGUA","BAJO BAUDÓ","CHINÚ","ARBELÁEZ","MORICHAL",null,"BARAYA","FONSECA","CIÉNAGA","CUMARAL","BELÉN","CÁCOTA","FILANDIA","LA CELIA","BARRANCABERMEJA","COVEÑAS","ATACO","BUENAVENTURA","YAVARATÉ",null,"PUERTO GUZMÁN",null,"ADYNOVATE 250 UI/VIAL","UI",null,"Tratamiento integral Hemofilia moderada y EvW tipo III (mensual)","Und"]
[null,null,"BOLÍVAR","PUERTO ALEGRÍA","ANGELÓPOLIS","TAME",null,"LURUACO",null,"CALAMAR","BOAVITA","LA DORADA","FLORENCIA","NUNCHÍA","CALDONO","CHIRIGUANÁ","BOJAYÁ","CIÉNAGA DE ORO","BELTRÁN","PANA PANA",null,"CAMPOALEGRE","HATONUEVO","CONCORDIA","EL CALVARIO","BUESACO","CHINÁCOTA","GÉNOVA","LA VIRGINIA","BETULIA","EL ROBLE","CAJAMARCA","BUGALAGRANDE",null,null,"PUERTO LEGUÍZAMO",null,"ADYNOVATE 500 UI / VIAL","UI",null,"Tratamiento integral Hemofilia severa (mensual)","Und"]
[null,null,"BOYACÁ","PUERTO ARICA","ANGOSTURA",null,null,"MALAMBO",null,"CANTAGALLO","BOYACÁ","LA MERCED","LA MONTAÑITA","OROCUÉ","CALOTO","CURUMANÍ","CARMEN DEL DARIÉN","COTORRA","BITUIMA","PUERTO COLOMBIA",null,"COLOMBIA","LA JAGUA DEL PILAR","EL BANCO","EL CASTILLO","CHACHAGÜÍ","CHITAGÁ","LA TEBAIDA","MARSELLA","BOLÍVAR","GALERAS","CARMEN DE APICALÁ","CAICEDONIA",null,null,"SAN FRANCISCO",null,"AIMAFIX 500 U.I. POLVO PARA RECONSTITUIR A SOLUCIÓN DE INFUSIÓN INTRAVENOSA","UI",null,"Valoración medicina general por paciente","Und"]
[null,null,"CALDAS","PUERTO NARIÑO","ANORÍ",null,null,"MANATÍ",null,"CARTAGENA DE INDIAS","BRICEÑO","MANIZALES","MILÁN","PAZ DE ARIPORO","CORINTO","EL COPEY","CÉRTEGUI","LA APARTADA","BOJACÁ","SAN FELIPE",null,"ELÍAS","MAICAO","EL PIÑÓN","EL DORADO","COLÓN","CONVENCIÓN","MONTENEGRO","MISTRATÓ","BUCARAMANGA","GUARANDA","CASABIANCA","CALI",null,null,"SAN MIGUEL",null,"BENEFIX 1000 UI","UI",null,"Valoración nutrición y dietética por paciente","Und"]
[null,null,"CAQUETÁ","PUERTO SANTANDER","ANZÁ",null,null,"PALMAR DE VARELA",null,"CICUCO","BUENAVISTA","MANZANARES","MORELIA","PORE","EL TAMBO","EL PASO","CONDOTO","LORICA","CABRERA",null,null,"GARZÓN","MANAURE","EL RETÉN","FUENTE DE ORO","CONSACÁ","CÚCUTA","PIJAO","PEREIRA","CABRERA","LA UNIÓN","CHAPARRAL","CALIMA",null,null,"SANTIAGO",null,"BENEFIX 2000 UI","UI",null,"Valoración odontología por paciente","Und"]
[null,null,"CASANARE","TARAPACÁ","APARTADÓ",null,null,"PIOJÓ",null,"CLEMENCIA","BUSBANZÁ","MARMATO","PUERTO RICO","RECETOR","FLORENCIA","GAMARRA","EL CANTÓN DEL SAN PABLO","LOS CÓRDOBAS","CACHIPAY",null,null,"GIGANTE","RIOHACHA","FUNDACIÓN","GRANADA","CONTADERO","CUCUTILLA","QUIMBAYA","PUEBLO RICO","CALIFORNIA","LOS PALMITOS","COELLO","CANDELARIA",null,null,"SIBUNDOY",null,"BENEFIX 250 U.I.","UI",null,"Valoración trabajo social por paciente","Und"]
[null,null,"CAUCA",null,"ARBOLETES",null,null,"POLONUEVO",null,"CÓRDOBA","CALDAS","MARQUETALIA","SAN JOSÉ DEL FRAGUA","SABANALARGA","GUACHENÉ","GONZÁLEZ","EL CARMEN DE ATRATO","MOMIL","CAJICÁ",null,null,"GUADALUPE","SAN JUAN DEL CESAR","GUAMAL","GUAMAL","CÓRDOBA","DURANIA","SALENTO","QUINCHÍA","CAPITANEJO","MAJAGUAL","COYAIMA","CARTAGO",null,null,"VALLE DEL GUAMUEZ",null,"BENEFIX 500 U.I. ","UI",null,"Valoración y manejo por grupo osteo-muscular (ortopedia, terapia física, terapia ocupacional) por paciente","Und"]
[null,null,"CESAR",null,"ARGELIA",null,null,"PONEDERA",null,"EL CARMEN DE BOLÍVAR","CAMPOHERMOSO","MARULANDA","SAN VICENTE DEL CAGUÁN","SÁCAMA","GUAPÍ","LA GLORIA","EL LITORAL DEL SAN JUAN","MOÑITOS","CAPARRAPÍ",null,null,"HOBO","URIBIA","NUEVA GRANADA","LA MACARENA","CUASPÚD","EL CARMEN",null,"SANTA ROSA DE CABAL","CARCASÍ","MORROA","CUNDAY","DAGUA",null,null,"VILLAGARZÓN",null,"BERIATE 500U.I.","UI",null,"Valoración y manejo por hematología por paciente","Und"]
[null,null,"CHOCÓ",null,"ARMENIA",null,null,"PUERTO COLOMBIA",null,"EL GUAMO","CERINZA","NEIRA","SOLANO","SAN LUIS DE PALENQUE","INZÁ","LA JAGUA DE IBIRICO","ISTMINA","MONTELÍBANO","CÁQUEZA",null,null,"ÍQUIRA","URUMITA","PEDRAZA","LEJANÍAS","CUMBAL","EL TARRA",null,"SANTUARIO","CEPITÁ","OVEJAS","DOLORES","EL ÁGUILA",null,null,null,null,"BERIATE POLVO CON SOLVENTE","UI"]
[null,null,"CÓRDOBA",null,"BARBOSA",null,null,"REPELÓN",null,"EL PEÑÓN","CHINAVITA","NORCASIA","SOLITA","TÁMARA","JAMBALÓ","LA PAZ","JURADÓ","MONTERÍA","CARMEN DE CARUPA",null,null,"ISNOS","VILLANUEVA","PIJIÑO DEL CARMEN","MAPIRIPÁN","CUMBITARA","EL ZULIA",null,null,"CERRITO","PALMITO","ESPINAL","EL CAIRO",null,null,null,null,"EMICIZUMAB 150.0000mg/1.0000 ml  (HEMLIBRA) VIAL 0.4000 ml/CAJA X 1","ML"]
[null,null,"GUAVIARE",null,"BETANIA",null,null,"SANTA LUCÍA",null,"MAHATES","CHISCAS","PENSILVANIA",null,"VILLANUEVA","LÓPEZ DE MICAY","PELAYA","MEDIO BAUDÓ","PUERTO ESCONDIDO","CHIPAQUE",null,null,"NÁTAGA",null,"PUEBLOVIEJO","PUERTO GAITÁN","EL ROSARIO","HERRÁN",null,null,"CHIMA","SAN JUAN DE BETULIA","FRESNO","FLORIDA",null,null,null,null,"EMICIZUMAB 150.0000mg/1.0000 ml (HEMLIBRA) VIAL 0.7000 ml/CAJA X 1","ML"]
[null,null,"HUILA",null,"BETULIA",null,null,"SANTO TOMÁS",null,"MARGARITA","CHITA","RIOSUCIO",null,"YOPAL","MERCADERES","PUEBLO BELLO","MEDIO SAN JUAN","PUERTO LIBERTADOR","CHOACHÍ",null,null,"NEIVA",null,"REMOLINO","PUERTO LLERAS","EL TABLÓN DE GÓMEZ","LA ESPERANZA",null,null,"CHIPATÁ","SAN LUIS DE SINCÉ","GUAMO","GINEBRA",null,null,null,null,"EMICIZUMAB 150.0000mg/1.0000 ml (HEMLIBRA) VIAL 1.0000 ml/CAJA X 1","ML"]
[null,null,"LA GUAJIRA",null,"BRICEÑO",null,null,"SOLEDAD",null,"MARÍA LA BAJA","CHITARAQUE","RISARALDA",null,null,"MIRANDA","RÍO DE ORO","NÓVITA","PURÍSIMA DE LA CONCEPCIÓN","CHOCONTÁ",null,null,"OPORAPA",null,"SABANAS DE SAN ÁNGEL","PUERTO LÓPEZ","EL TAMBO","LA PLAYA",null,null,"CIMITARRA","SAN MARCOS","HERVEO","GUACARÍ",null,null,null,null,"EMICIZUMAB 30.0000mg/1.0000 ml (HEMLIBRA) VIAL 1.0000 ml/CAJA X 1","ML"]
[null,null,"MAGDALENA",null,"BURITICÁ",null,null,"SUAN",null,"MOMPÓS","CHIVATÁ","SALAMINA",null,null,"MORALES","SAN ALBERTO","NUQUÍ","SAHAGÚN","COGUA",null,null,"PAICOL",null,"SALAMINA","PUERTO RICO","FRANCISCO PIZARRO","LABATECA",null,null,"CONCEPCIÓN","SAN ONOFRE","HONDA","GUADALAJARA DE BUGA",null,null,null,null,"FACTOR HUMANO ANTIHEMOFILICO METODO M HEMOFIL M","M"]
[null,null,"META",null,"CÁCERES",null,null,"TUBARÁ",null,"MONTECRISTO","CHIVOR","SAMANÁ",null,null,"PADILLA","SAN DIEGO","QUIBDÓ","SAN ANDRÉS DE SOTAVENTO","COTA",null,null,"PALERMO",null,"SAN SEBASTIÁN DE BUENAVISTA","RESTREPO","FUNES","LOS PATIOS",null,null,"CONFINES","SAN PEDRO","IBAGUÉ","JAMUNDÍ",null,null,null,null,"FANHDI 250 U.I. FACTOR VIII ANTIHEMOFILICO","UI"]
[null,null,"NARIÑO",null,"CAICEDO",null,null,"USIACURÍ",null,"MORALES","CIÉNEGA","SAN JOSÉ",null,null,"PÁEZ","SAN MARTÍN","RÍO IRÓ","SAN ANTERO","CUCUNUBÁ",null,null,"PALESTINA",null,"SAN ZENÓN","SAN CARLOS DE GUAROA","GUACHUCAL","LOURDES",null,null,"CONTRATACIÓN","SANTIAGO DE TOLÚ","ICONONZO","LA CUMBRE",null,null,null,null,"FANHDI 500 U.I. FACTOR VIII ANTIHEMOFILICO","UI"]
[null,null,"NORTE DE SANTANDER",null,"CALDAS",null,null,null,null,"NOROSÍ","CÓMBITA","SUPÍA",null,null,"PATÍA","TAMALAMEQUE","RÍO QUITO","SAN BERNARDO DEL VIENTO","EL COLEGIO",null,null,"PITAL",null,"SANTA ANA","SAN JUAN DE ARAMA","GUAITARILLA","MUTISCUA",null,null,"COROMORO","SINCELEJO","LÉRIDA","LA UNIÓN",null,null,null,null,"FEIBA 1000U","U"]
[null,null,"PUTUMAYO",null,"CAMPAMENTO",null,null,null,null,"PINILLOS","COPER","VICTORIA",null,null,"PIAMONTE","VALLEDUPAR","RIOSUCIO","SAN CARLOS","EL PEÑÓN",null,null,"PITALITO",null,"SANTA BÁRBARA DE PINTO","SAN JUANITO","GUALMATÁN","OCAÑA",null,null,"CURITÍ","SUCRE","LÍBANO","LA VICTORIA",null,null,null,null,"FEIBA 500 U","U"]
[null,null,"QUINDÍO",null,"CAÑASGORDAS",null,null,null,null,"REGIDOR","CORRALES","VILLAMARÍA",null,null,"PIENDAMÓ",null,"SAN JOSÉ DEL PALMAR","SAN JOSÉ DE URÉ","EL ROSAL",null,null,"RIVERA",null,"SANTA MARTA","SAN MARTÍN","ILES","PAMPLONA",null,null,"EL CARMEN DE CHUCURÍ","TOLÚ VIEJO","MELGAR","OBANDO",null,null,null,null,"HAEMATE P. 500 U.I.","UI"]
[null,null,"RISARALDA",null,"CARACOLÍ",null,null,null,null,"RÍO VIEJO","COVARACHÍA","VITERBO",null,null,"POPAYÁN",null,"SIPÍ","SAN PELAYO","FACATATIVÁ",null,null,"SALADOBLANCO",null,"SITIONUEVO","URIBE","IMUÉS","PAMPLONITA",null,null,"EL GUACAMAYO",null,"MURILLO","PALMIRA",null,null,null,null,"IMMUNATE 1000 UI FACTOR VIII DE COAGULACION","UI"]
[null,null,"SANTANDER",null,"CARAMANTA",null,null,null,null,"SAN CRISTÓBAL","CUBARÁ",null,null,null,"PUERTO TEJADA",null,"TADÓ","TIERRALTA","FÓMEQUE",null,null,"SAN AGUSTÍN",null,"TENERIFE","VILLAVICENCIO","IPIALES","PUERTO SANTANDER",null,null,"EL PEÑÓN",null,"NATAGAIMA","PRADERA",null,null,null,null,"IMMUNATE 500 UI FACTOR VIII DE COAGULACION","UI"]
[null,null,"SUCRE",null,"CAREPA",null,null,null,null,"SAN ESTANISLAO","CUCAITA",null,null,null,"PURACÉ",null,"UNGUÍA","TUCHÍN","FOSCA",null,null,"SANTA MARÍA",null,"ZAPAYÁN","VISTAHERMOSA","LA CRUZ","RAGONVALIA",null,null,"EL PLAYÓN",null,"ORTEGA","RESTREPO",null,null,null,null,"IMMUNATE FACTOR VIII DE COAGULACION 250 UI","UI"]
[null,null,"TOLIMA",null,"CAROLINA",null,null,null,null,"SAN FERNANDO","CUÍTIVA",null,null,null,"ROSAS",null,"UNIÓN PANAMERICANA","VALENCIA","FUNZA",null,null,"SUAZA",null,"ZONA BANANERA",null,"LA FLORIDA","SALAZAR",null,null,"ENCINO",null,"PALOCABILDO","RIOFRÍO",null,null,null,null,"IMMUNINE  600 U.I. CONCENTRADO DE FACTOR IX","UI"]
[null,null,"VALLE DEL CAUCA",null,"CAUCASIA",null,null,null,null,"SAN JACINTO","DUITAMA",null,null,null,"SAN SEBASTIÁN",null,null,null,"FÚQUENE",null,null,"TARQUI",null,null,null,"LA LLANADA","SAN CALIXTO",null,null,"ENCISO",null,"PIEDRAS","ROLDANILLO",null,null,null,null,"KOVALTRY  1000 UI","UI"]
[null,null,"VAUPÉS",null,"CHIGORODÓ",null,null,null,null,"SAN JACINTO DEL CAUCA","EL COCUY",null,null,null,"SANTA ROSA",null,null,null,"FUSAGASUGÁ",null,null,"TELLO",null,null,null,"LA TOLA","SAN CAYETANO",null,null,"FLORIÁN",null,"PLANADAS","SAN PEDRO",null,null,null,null,"KOVALTRY  250 UI","UI"]
[null,null,"VICHADA",null,"CISNEROS",null,null,null,null,"SAN JUAN NEPOMUCENO","EL ESPINO",null,null,null,"SANTANDER DE QUILICHAO",null,null,null,"GACHALÁ",null,null,"TERUEL",null,null,null,"LA UNIÓN","SANTIAGO",null,null,"FLORIDABLANCA",null,"PRADO","SEVILLA",null,null,null,null,"KOVALTRY  500 UI","UI"]
[null,null,null,null,"CIUDAD BOLÍVAR",null,null,null,null,"SAN MARTÍN DE LOBA","FIRAVITOBA",null,null,null,"SILVIA",null,null,null,"GACHANCIPÁ",null,null,"TESALIA",null,null,null,"LEIVA","SARDINATA",null,null,"GALÁN",null,"PURIFICACIÓN","TORO",null,null,null,null,"NOVOEIGHT 1000 UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","UI"]
[null,null,null,null,"COCORNÁ",null,null,null,null,"SAN PABLO","FLORESTA",null,null,null,"SOTARA",null,null,null,"GACHETÁ",null,null,"TIMANÁ",null,null,null,"LINARES","SILOS",null,null,"GÁMBITA",null,"RIOBLANCO","TRUJILLO",null,null,null,null,"NOVOEIGHT 1500 UI POLVO Y SOLVENTE PARA SOLUCIÓN PARA INYECCIÓN","UI"]
[null,null,null,null,"CONCEPCIÓN",null,null,null,null,"SANTA CATALINA","GACHANTIVÁ",null,null,null,"SUÁREZ",null,null,null,"GAMA",null,null,"VILLAVIEJA",null,null,null,"LOS ANDES","TEORAMA",null,null,"GIRÓN",null,"RONCESVALLES","TULUÁ",null,null,null,null,"NOVOEIGHT 250 UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","UI"]
[null,null,null,null,"CONCORDIA",null,null,null,null,"SANTA ROSA","GÁMEZA",null,null,null,"SUCRE",null,null,null,"GIRARDOT",null,null,"YAGUARÁ",null,null,null,"MAGÜÍ","TIBÚ",null,null,"GUACA",null,"ROVIRA","ULLOA",null,null,null,null,"NOVOEIGHT 500UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","UI"]
[null,null,null,null,"COPACABANA",null,null,null,null,"SANTA ROSA DEL SUR","GARAGOA",null,null,null,"TIMBÍO",null,null,null,"GRANADA",null,null,null,null,null,null,"MALLAMA","TOLEDO",null,null,"GUADALUPE",null,"SALDAÑA","VERSALLES",null,null,null,null,"NOVOSEVEN RT 1 MG","MG"]
[null,null,null,null,"DABEIBA",null,null,null,null,"SIMITÍ","GUACAMAYAS",null,null,null,"TIMBIQUÍ",null,null,null,"GUACHETÁ",null,null,null,null,null,null,"MOSQUERA","VILLA CARO",null,null,"GUAPOTÁ",null,"SAN ANTONIO","VIJES",null,null,null,null,"NOVOSEVEN RT 2 MG","MG"]
[null,null,null,null,"DONMATÍAS",null,null,null,null,"SOPLAVIENTO","GUATEQUE",null,null,null,"TORIBÍO",null,null,null,"GUADUAS",null,null,null,null,null,null,"NARIÑO","VILLA DEL ROSARIO",null,null,"GUAVATÁ",null,"SAN LUIS","YOTOCO",null,null,null,null,"NUWIQ 1000UI","UI"]
[null,null,null,null,"EBÉJICO",null,null,null,null,"TALAIGUA NUEVO","GUAYATÁ",null,null,null,"TOTORÓ",null,null,null,"GUASCA",null,null,null,null,null,null,"OLAYA HERRERA",null,null,null,"GÜEPSA",null,"SAN SEBASTIÁN DE MARIQUITA","YUMBO",null,null,null,null,"NUWIQ 2000 UI","UI"]
[null,null,null,null,"EL BAGRE",null,null,null,null,"TIQUISIO","GÜICÁN DE LA SIERRA",null,null,null,"VILLA RICA",null,null,null,"GUATAQUÍ",null,null,null,null,null,null,"OSPINA",null,null,null,"HATO",null,"SANTA ISABEL","ZARZAL",null,null,null,null,"NUWIQ 250UI","UI"]
[null,null,null,null,"EL CARMEN DE VIBORAL",null,null,null,null,"TURBACO","IZA",null,null,null,null,null,null,null,"GUATAVITA",null,null,null,null,null,null,"PASTO",null,null,null,"JESÚS MARÍA",null,"SUÁREZ",null,null,null,null,null,"NUWIQ 500 UI","UI"]
[null,null,null,null,"EL SANTUARIO",null,null,null,null,"TURBANÁ","JENESANO",null,null,null,null,null,null,null,"GUAYABAL DE SÍQUIMA",null,null,null,null,null,null,"POLICARPA",null,null,null,"JORDÁN",null,"VALLE DE SAN JUAN",null,null,null,null,null,"OCTANATE 1000 UI.","UI"]
[null,null,null,null,"ENTRERRÍOS",null,null,null,null,"VILLANUEVA","JERICÓ",null,null,null,null,null,null,null,"GUAYABETAL",null,null,null,null,null,null,"POTOSÍ",null,null,null,"LA BELLEZA",null,"VENADILLO",null,null,null,null,null,"OCTANATE 250 UI.","UI"]
[null,null,null,null,"ENVIGADO",null,null,null,null,"ZAMBRANO","LA CAPILLA",null,null,null,null,null,null,null,"GUTIÉRREZ",null,null,null,null,null,null,"PROVIDENCIA",null,null,null,"LA PAZ",null,"VILLAHERMOSA",null,null,null,null,null,"OCTANATE 500 UI.","UI"]
[null,null,null,null,"FREDONIA",null,null,null,null,null,"LA UVITA",null,null,null,null,null,null,null,"JERUSALÉN",null,null,null,null,null,null,"PUERRES",null,null,null,"LANDÁZURI",null,"VILLARRICA",null,null,null,null,null,"OCTANINE F  1000 UI","UI"]
[null,null,null,null,"FRONTINO",null,null,null,null,null,"LA VICTORIA",null,null,null,null,null,null,null,"JUNÍN",null,null,null,null,null,null,"PUPIALES",null,null,null,"LEBRIJA",null,null,null,null,null,null,null,"OCTANINE F  250 UI","UI"]
[null,null,null,null,"GIRALDO",null,null,null,null,null,"LABRANZAGRANDE",null,null,null,null,null,null,null,"LA CALERA",null,null,null,null,null,null,"RICAURTE",null,null,null,"LOS SANTOS",null,null,null,null,null,null,null,"OCTANINE F 500 UI","UI"]
[null,null,null,null,"GIRARDOTA",null,null,null,null,null,"MACANAL",null,null,null,null,null,null,null,"LA MESA",null,null,null,null,null,null,"ROBERTO PAYÁN",null,null,null,"MACARAVITA",null,null,null,null,null,null,null,"RECOMBINATE (RECOMBINANTE) 500 UI","UI"]
[null,null,null,null,"GÓMEZ PLATA",null,null,null,null,null,"MARIPÍ",null,null,null,null,null,null,null,"LA PALMA",null,null,null,null,null,null,"SAMANIEGO",null,null,null,"MÁLAGA",null,null,null,null,null,null,null,"RIXUBIS  2000 UI","UI"]
[null,null,null,null,"GRANADA",null,null,null,null,null,"MIRAFLORES",null,null,null,null,null,null,null,"LA PEÑA",null,null,null,null,null,null,"SAN ANDRÉS DE TUMACO",null,null,null,"MATANZA",null,null,null,null,null,null,null,"RIXUBIS  500 UI","UI"]
[null,null,null,null,"GUADALUPE",null,null,null,null,null,"MONGUA",null,null,null,null,null,null,null,"LA VEGA",null,null,null,null,null,null,"SAN BERNARDO",null,null,null,"MOGOTES",null,null,null,null,null,null,null,"RIXUBIS 250 UI","UI"]
[null,null,null,null,"GUARNE",null,null,null,null,null,"MONGUÍ",null,null,null,null,null,null,null,"LENGUAZAQUE",null,null,null,null,null,null,"SAN LORENZO",null,null,null,"MOLAGAVITA",null,null,null,null,null,null,null,"WILATE 500 UI","UI"]
[null,null,null,null,"GUATAPÉ",null,null,null,null,null,"MONIQUIRÁ",null,null,null,null,null,null,null,"MACHETÁ",null,null,null,null,null,null,"SAN PABLO",null,null,null,"OCAMONTE",null,null,null,null,null,null,null,"WILATE1000","UI"]
[null,null,null,null,"HELICONIA",null,null,null,null,null,"MOTAVITA",null,null,null,null,null,null,null,"MADRID",null,null,null,null,null,null,"SAN PEDRO DE CARTAGO",null,null,null,"OIBA",null,null,null,null,null,null,null,"XYNTHA  1000 UI SOLUCIÓN INYECTABLE","UI"]
[null,null,null,null,"HISPANIA",null,null,null,null,null,"MUZO",null,null,null,null,null,null,null,"MANTA",null,null,null,null,null,null,"SANDONÁ",null,null,null,"ONZAGA",null,null,null,null,null,null,null,"XYNTHA  500 UI SOLUCIÓN INYECTABLE","UI"]
[null,null,null,null,"ITAGÜÍ",null,null,null,null,null,"NOBSA",null,null,null,null,null,null,null,"MEDINA",null,null,null,null,null,null,"SANTA BÁRBARA",null,null,null,"PALMAR",null,null,null,null,null,null,null,"XYNTHA 2000 UI","UI"]
[null,null,null,null,"ITUANGO",null,null,null,null,null,"NUEVO COLÓN",null,null,null,null,null,null,null,"MOSQUERA",null,null,null,null,null,null,"SANTACRUZ",null,null,null,"PALMAS DEL SOCORRO",null,null,null,null,null,null,null,"XYNTHA 250 UI SOLUCION INYECTABLE","UI"]
[null,null,null,null,"JARDÍN",null,null,null,null,null,"OICATÁ",null,null,null,null,null,null,null,"NARIÑO",null,null,null,null,null,null,"SAPUYES",null,null,null,"PÁRAMO"]
[null,null,null,null,"JERICÓ",null,null,null,null,null,"OTANCHE",null,null,null,null,null,null,null,"NEMOCÓN",null,null,null,null,null,null,"TAMINANGO",null,null,null,"PIEDECUESTA"]
[null,null,null,null,"LA CEJA",null,null,null,null,null,"PACHAVITA",null,null,null,null,null,null,null,"NILO",null,null,null,null,null,null,"TANGUA",null,null,null,"PINCHOTE"]
[null,null,null,null,"LA ESTRELLA",null,null,null,null,null,"PÁEZ",null,null,null,null,null,null,null,"NIMAIMA",null,null,null,null,null,null,"TÚQUERRES",null,null,null,"PUENTE NACIONAL"]
[null,null,null,null,"LA PINTADA",null,null,null,null,null,"PAIPA",null,null,null,null,null,null,null,"NOCAIMA",null,null,null,null,null,null,"YACUANQUER",null,null,null,"PUERTO PARRA"]
[null,null,null,null,"LA UNIÓN",null,null,null,null,null,"PAJARITO",null,null,null,null,null,null,null,"PACHO",null,null,null,null,null,null,null,null,null,null,"PUERTO WILCHES"]
[null,null,null,null,"LIBORINA",null,null,null,null,null,"PANQUEBA",null,null,null,null,null,null,null,"PAIME",null,null,null,null,null,null,null,null,null,null,"RIONEGRO"]
[null,null,null,null,"MACEO",null,null,null,null,null,"PAUNA",null,null,null,null,null,null,null,"PANDI",null,null,null,null,null,null,null,null,null,null,"SABANA DE TORRES"]
[null,null,null,null,"MARINILLA",null,null,null,null,null,"PAYA",null,null,null,null,null,null,null,"PARATEBUENO",null,null,null,null,null,null,null,null,null,null,"SAN ANDRÉS"]
[null,null,null,null,"MEDELLÍN",null,null,null,null,null,"PAZ DE RÍO",null,null,null,null,null,null,null,"PASCA",null,null,null,null,null,null,null,null,null,null,"SAN BENITO"]
[null,null,null,null,"MONTEBELLO",null,null,null,null,null,"PESCA",null,null,null,null,null,null,null,"PUERTO SALGAR",null,null,null,null,null,null,null,null,null,null,"SAN GIL"]
[null,null,null,null,"MURINDÓ",null,null,null,null,null,"PISBA",null,null,null,null,null,null,null,"PULÍ",null,null,null,null,null,null,null,null,null,null,"SAN JOAQUÍN"]
[null,null,null,null,"MUTATÁ",null,null,null,null,null,"PUERTO BOYACÁ",null,null,null,null,null,null,null,"QUEBRADANEGRA",null,null,null,null,null,null,null,null,null,null,"SAN JOSÉ DE MIRANDA"]
[null,null,null,null,"NARIÑO",null,null,null,null,null,"QUÍPAMA",null,null,null,null,null,null,null,"QUETAME",null,null,null,null,null,null,null,null,null,null,"SAN MIGUEL"]
[null,null,null,null,"NECHÍ",null,null,null,null,null,"RAMIRIQUÍ",null,null,null,null,null,null,null,"QUIPILE",null,null,null,null,null,null,null,null,null,null,"SAN VICENTE DE CHUCURÍ"]
[null,null,null,null,"NECOCLÍ",null,null,null,null,null,"RÁQUIRA",null,null,null,null,null,null,null,"RICAURTE",null,null,null,null,null,null,null,null,null,null,"SANTA BÁRBARA"]
[null,null,null,null,"OLAYA",null,null,null,null,null,"RONDÓN",null,null,null,null,null,null,null,"SAN ANTONIO DEL TEQUENDAMA",null,null,null,null,null,null,null,null,null,null,"SANTA HELENA DEL OPÓN"]
[null,null,null,null,"PEÑOL",null,null,null,null,null,"SABOYÁ",null,null,null,null,null,null,null,"SAN BERNARDO",null,null,null,null,null,null,null,null,null,null,"SIMACOTA"]
[null,null,null,null,"PEQUE",null,null,null,null,null,"SÁCHICA",null,null,null,null,null,null,null,"SAN CAYETANO",null,null,null,null,null,null,null,null,null,null,"SOCORRO"]
[null,null,null,null,"PUEBLORRICO",null,null,null,null,null,"SAMACÁ",null,null,null,null,null,null,null,"SAN FRANCISCO",null,null,null,null,null,null,null,null,null,null,"SUAITA"]
[null,null,null,null,"PUERTO BERRÍO",null,null,null,null,null,"SAN EDUARDO",null,null,null,null,null,null,null,"SAN JUAN DE RIOSECO",null,null,null,null,null,null,null,null,null,null,"SUCRE"]
[null,null,null,null,"PUERTO NARE",null,null,null,null,null,"SAN JOSÉ DE PARE",null,null,null,null,null,null,null,"SASAIMA",null,null,null,null,null,null,null,null,null,null,"SURATÁ"]
[null,null,null,null,"PUERTO TRIUNFO",null,null,null,null,null,"SAN LUIS DE GACENO",null,null,null,null,null,null,null,"SESQUILÉ",null,null,null,null,null,null,null,null,null,null,"TONA"]
[null,null,null,null,"REMEDIOS",null,null,null,null,null,"SAN MATEO",null,null,null,null,null,null,null,"SIBATÉ",null,null,null,null,null,null,null,null,null,null,"VALLE DE SAN JOSÉ"]
[null,null,null,null,"RETIRO",null,null,null,null,null,"SAN MIGUEL DE SEMA",null,null,null,null,null,null,null,"SILVANIA",null,null,null,null,null,null,null,null,null,null,"VÉLEZ"]
[null,null,null,null,"RIONEGRO",null,null,null,null,null,"SAN PABLO DE BORBUR",null,null,null,null,null,null,null,"SIMIJACA",null,null,null,null,null,null,null,null,null,null,"VETAS"]
[null,null,null,null,"SABANALARGA",null,null,null,null,null,"SANTA MARÍA",null,null,null,null,null,null,null,"SOACHA",null,null,null,null,null,null,null,null,null,null,"VILLANUEVA"]
[null,null,null,null,"SABANETA",null,null,null,null,null,"SANTA ROSA DE VITERBO",null,null,null,null,null,null,null,"SOPÓ",null,null,null,null,null,null,null,null,null,null,"ZAPATOCA"]
[null,null,null,null,"SALGAR",null,null,null,null,null,"SANTA SOFÍA",null,null,null,null,null,null,null,"SUBACHOQUE"]
[null,null,null,null,"SAN ANDRÉS DE CUERQUÍA",null,null,null,null,null,"SANTANA",null,null,null,null,null,null,null,"SUESCA"]
[null,null,null,null,"SAN CARLOS",null,null,null,null,null,"SATIVANORTE",null,null,null,null,null,null,null,"SUPATÁ"]
[null,null,null,null,"SAN FRANCISCO",null,null,null,null,null,"SATIVASUR",null,null,null,null,null,null,null,"SUSA"]
[null,null,null,null,"SAN JERÓNIMO",null,null,null,null,null,"SIACHOQUE",null,null,null,null,null,null,null,"SUTATAUSA"]
[null,null,null,null,"SAN JOSÉ DE LA MONTAÑA",null,null,null,null,null,"SOATÁ",null,null,null,null,null,null,null,"TABIO"]
[null,null,null,null,"SAN JUAN DE URABÁ",null,null,null,null,null,"SOCHA",null,null,null,null,null,null,null,"TAUSA"]
[null,null,null,null,"SAN LUIS",null,null,null,null,null,"SOCOTÁ",null,null,null,null,null,null,null,"TENA"]
[null,null,null,null,"SAN PEDRO DE LOS MILAGROS",null,null,null,null,null,"SOGAMOSO",null,null,null,null,null,null,null,"TENJO"]
[null,null,null,null,"SAN PEDRO DE URABÁ",null,null,null,null,null,"SOMONDOCO",null,null,null,null,null,null,null,"TIBACUY"]
[null,null,null,null,"SAN RAFAEL",null,null,null,null,null,"SORA",null,null,null,null,null,null,null,"TIBIRITA"]
[null,null,null,null,"SAN ROQUE",null,null,null,null,null,"SORACÁ",null,null,null,null,null,null,null,"TOCAIMA"]
[null,null,null,null,"SAN VICENTE FERRER",null,null,null,null,null,"SOTAQUIRÁ",null,null,null,null,null,null,null,"TOCANCIPÁ"]
[null,null,null,null,"SANTA BÁRBARA",null,null,null,null,null,"SUSACÓN",null,null,null,null,null,null,null,"TOPAIPÍ"]
[null,null,null,null,"SANTA FÉ DE ANTIOQUIA",null,null,null,null,null,"SUTAMARCHÁN",null,null,null,null,null,null,null,"UBALÁ"]
[null,null,null,null,"SANTA ROSA DE OSOS",null,null,null,null,null,"SUTATENZA",null,null,null,null,null,null,null,"UBAQUE"]
[null,null,null,null,"SANTO DOMINGO",null,null,null,null,null,"TASCO",null,null,null,null,null,null,null,"UNE"]
[null,null,null,null,"SEGOVIA",null,null,null,null,null,"TENZA",null,null,null,null,null,null,null,"ÚTICA"]
[null,null,null,null,"SONSÓN",null,null,null,null,null,"TIBANÁ",null,null,null,null,null,null,null,"VENECIA"]
[null,null,null,null,"SOPETRÁN",null,null,null,null,null,"TIBASOSA",null,null,null,null,null,null,null,"VERGARA"]
[null,null,null,null,"TÁMESIS",null,null,null,null,null,"TINJACÁ",null,null,null,null,null,null,null,"VIANÍ"]
[null,null,null,null,"TARAZÁ",null,null,null,null,null,"TIPACOQUE",null,null,null,null,null,null,null,"VILLA DE SAN DIEGO DE UBATÉ"]
[null,null,null,null,"TARSO",null,null,null,null,null,"TOCA",null,null,null,null,null,null,null,"VILLAGÓMEZ"]
[null,null,null,null,"TITIRIBÍ",null,null,null,null,null,"TOGÜÍ",null,null,null,null,null,null,null,"VILLAPINZÓN"]
[null,null,null,null,"TOLEDO",null,null,null,null,null,"TÓPAGA",null,null,null,null,null,null,null,"VILLETA"]
[null,null,null,null,"TURBO",null,null,null,null,null,"TOTA",null,null,null,null,null,null,null,"VIOTÁ"]
[null,null,null,null,"URAMITA",null,null,null,null,null,"TUNJA",null,null,null,null,null,null,null,"YACOPÍ"]
[null,null,null,null,"URRAO",null,null,null,null,null,"TUNUNGUÁ",null,null,null,null,null,null,null,"ZIPACÓN"]
[null,null,null,null,"VALDIVIA",null,null,null,null,null,"TURMEQUÉ",null,null,null,null,null,null,null,"ZIPAQUIRÁ"]
[null,null,null,null,"VALPARAÍSO",null,null,null,null,null,"TUTA"]
[null,null,null,null,"VEGACHÍ",null,null,null,null,null,"TUTAZÁ"]
[null,null,null,null,"VENECIA",null,null,null,null,null,"ÚMBITA"]
[null,null,null,null,"VIGÍA DEL FUERTE",null,null,null,null,null,"VENTAQUEMADA"]
[null,null,null,null,"YALÍ",null,null,null,null,null,"VILLA DE LEYVA"]
[null,null,null,null,"YARUMAL",null,null,null,null,null,"VIRACACHÁ"]
[null,null,null,null,"YOLOMBÓ",null,null,null,null,null,"ZETAQUIRA"]
[null,null,null,null,"YONDÓ"]
[null,null,null,null,"ZARAGOZA"]

{"sheet":"Consolidado","index":5,"n_rows":71,"n_cols":9,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Articulo","idarticulo","unidad","unidad TVEC","MEDICARTE S.A.","IPS ESPECIALIZADA","%Descuento","Cantidad","Minimo"]
["Tratamiento integral Hemofilia leve y EvW tipo I y II (mensual)","AM-TH-01-01","Unidad","Und",120628.79,596553.09,null,null,{"$f":"MIN(E2,F2)","v":120628.79}]
["Tratamiento integral Hemofilia moderada y EvW tipo III (mensual)","AM-TH-01-02","Unidad","Und",311245.28999999998,778257.79,null,null,{"$f":"MIN(E3,F3)","v":311245.28999999998}]
["Tratamiento integral Hemofilia severa (mensual)","AM-TH-01-03","Unidad","Und",670629.12,1043848,null,null,670629.12]
["Valoración y manejo por hematología por paciente","AM-TH-01-04","Unidad","Und",168711.3,258786.44,null,null,168711.3]
["Valoración y manejo por grupo osteo-muscular (ortopedia, terapia física, terapia ocupacional) por paciente","AM-TH-01-05","Unidad","Und",197673.55,346582.08,null,null,197673.55]
["Valoración trabajo social por paciente","AM-TH-01-06","Unidad","Und",28118.36,42559.7,null,null,28118.36]
["Consulta psicología por paciente","AM-TH-01-07","Unidad","Und",33742.04,44201.53,null,null,33742.04]
["Valoración medicina general por paciente","AM-TH-01-08","Unidad","Und",42177.54,68565.55,null,null,42177.54]
["Valoración odontología por paciente","AM-TH-01-09","Unidad","Und",56236.73,131089.4,null,null,56236.73]
["Valoración nutrición y dietética por paciente","AM-TH-01-10","Unidad","Und",33742.04,50126.67,null,null,33742.04]
["Apoyos diagnósticos (laboratorio clínico e imágenes diagnósticas) por paciente","AM-TH-01-11","Unidad","Und",178553.29,190781.24,null,null,178553.29]
["Consejería genética por paciente","AM-TH-01-12","Unidad","Und",126533.75,166857.66,null,null,126533.75]
["Asesoría en planificación familiar por paciente","AM-TH-01-13","Unidad","Und",14059.18,166857.66,null,null,14059.18]
["EMICIZUMAB 150.0000mg/1.0000 ml (HEMLIBRA) VIAL 1.0000 ml/CAJA X 1","AM-TH-02-01","ML","ML",31895316,30782437,null,null,30782437]
["EMICIZUMAB 150.0000mg/1.0000 ml (HEMLIBRA) VIAL 0.7000 ml/CAJA X 1","AM-TH-02-02","ML","ML",22326720,21547705,null,null,21547705]
["EMICIZUMAB 150.0000mg/1.0000 ml  (HEMLIBRA) VIAL 0.4000 ml/CAJA X 1","AM-TH-02-03","ML","ML",12758126,12312975,null,null,12312975]
["EMICIZUMAB 30.0000mg/1.0000 ml (HEMLIBRA) VIAL 1.0000 ml/CAJA X 1","AM-TH-02-04","ML","ML",6379062,6156486,null,null,6156486]
["NOVOSEVEN RT 2 MG","AM-TH-02-05","MG","MG",4256877,4044033,null,null,4044033]
["BENEFIX 2000 UI","AM-TH-02-06","UI","UI",3696700,3369278,null,null,3369278]
["RIXUBIS  2000 UI","AM-TH-02-08","UI","UI",3216129,3334318,null,null,3216129]
["XYNTHA 2000 UI","AM-TH-02-09","UI","UI",1880036,2422749,null,null,1880036]
["FEIBA 1000U","AM-TH-02-10","UI","U",2439822,2396983,null,null,2396983]
["NUWIQ 2000 UI","AM-TH-02-11","UI","UI",2408136,2234919,null,null,2234919]
["NOVOSEVEN RT 1 MG","AM-TH-02-12","MG","MG",2128438,2022017,null,null,2022017]
["ADYNOVATE 2000 UI / VIAL","AM-TH-02-13","UI","UI",2218020,2074377,null,null,2074377]
["BENEFIX 1000 UI","AM-TH-02-14","UI","UI",1848350,1684639,null,null,1684639]
["NOVOEIGHT 1500 UI POLVO Y SOLVENTE PARA SOLUCIÓN PARA INYECCIÓN","AM-TH-02-16","UI","UI",1505085,1324475,null,null,1324475]
["XYNTHA  1000 UI SOLUCIÓN INYECTABLE","AM-TH-02-18","UI","UI",940018,1211374,null,null,940018]
["ADVATE 1000UI","AM-TH-02-19","UI","UI",1109010,1095778,null,null,1095778]
["ADYNOVATE 1000 UI / VIAL","AM-TH-02-20","UI","UI",1109010,1149146,null,null,1109010]
["KOVALTRY  1000 UI","AM-TH-02-21","UI","UI",1267440,1204068,null,null,1204068]
["FEIBA 500 U","AM-TH-02-22","UI","U",1219911,1198491,null,null,1198491]
["NUWIQ 1000UI","AM-TH-02-23","UI","UI",1204068,1117460,null,null,1117460]
["NOVOEIGHT 1000 UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","AM-TH-02-24","UI","UI",1003390,882983,null,null,882983]
["IMMUNATE 1000 UI FACTOR VIII DE COAGULACION","AM-TH-02-25","UI","UI",892753,924312,null,null,892753]
["FACTOR HUMANO ANTIHEMOFILICO METODO M HEMOFIL M","AM-TH-02-26","UI","UI",923805,903685,null,null,903685]
["HAEMATE P. 500 U.I.","AM-TH-02-27","UI","UI",864645,890091,null,null,864645]
["BENEFIX 500 U.I. ","AM-TH-02-28","UI","UI",924175,842320,null,null,842320]
["OCTANINE F  1000 UI","AM-TH-02-29","UI","UI",955861,919316,null,null,919316]
["WILATE1000","AM-TH-02-30","UI","UI",940018,928314,null,null,928314]
["BERIATE POLVO CON SOLVENTE","AM-TH-02-31","UI","UI",404789,810486,null,null,404789]
["RIXUBIS  500 UI","AM-TH-02-32","UI","UI",804032,833579,null,null,804032]
["OCTANATE 1000 UI.","AM-TH-02-33","UI","UI",844960,821301,null,null,821301]
["XYNTHA  500 UI SOLUCIÓN INYECTABLE","AM-TH-02-35","UI","UI",470009,605687,null,null,470009]
["RECOMBINATE (RECOMBINANTE) 500 UI","AM-TH-02-36","UI","UI",554505,634280,null,null,554505]
["ADVATE 500 UI","AM-TH-02-37","UI","UI",554505,547889,null,null,547889]
["ADYNOVATE 500 UI / VIAL","AM-TH-02-38","UI","UI",554505,574573,null,null,554505]
["KOVALTRY  500 UI","AM-TH-02-39","UI","UI",633720,602034,null,null,602034]
["NUWIQ 500 UI","AM-TH-02-40","UI","UI",602034,602034,null,null,602034]
["IMMUNINE  600 U.I. CONCENTRADO DE FACTOR IX","AM-TH-02-41","UI","UI",587405,553352,null,null,553352]
["IMMUNATE 500 UI FACTOR VIII DE COAGULACION","AM-TH-02-42","UI","UI",446377,478855,null,null,446377]
["OCTANINE F 500 UI","AM-TH-02-43","UI","UI",477931,482641,null,null,477931]
["NOVOEIGHT 500UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","AM-TH-02-44","UI","UI",501695,441492,null,null,441492]
["WILATE 500 UI","AM-TH-02-45","UI","UI",484579,487364,null,null,484579]
["BENEFIX 250 U.I.","AM-TH-02-46","UI","UI",462088,421160,null,null,421160]
["OCTANATE 500 UI.","AM-TH-02-47","UI","UI",422480,410651,null,null,410651]
["RIXUBIS 250 UI","AM-TH-02-48","UI","UI",402016,392273,null,null,392273]
["BERIATE 500U.I.","AM-TH-02-49","UI","UI",385513,373115,null,null,373115]
["FANHDI 500 U.I. FACTOR VIII ANTIHEMOFILICO","AM-TH-02-50","UI","UI",369670,337984,null,null,337984]
["XYNTHA 250 UI SOLUCION INYECTABLE","AM-TH-02-51","UI","UI",235005,302843,null,null,235005]
["ADVATE 250 UI","AM-TH-02-52","UI","UI",277253,273944,null,null,273944]
["ADYNOVATE 250 UI/VIAL","AM-TH-02-53","UI","UI",277253,287286,null,null,{"$f":"MIN(E63,F63)","v":277253}]
["KOVALTRY  250 UI","AM-TH-02-54","UI","UI",316860,301017,null,null,301017]
["NUWIQ 250UI","AM-TH-02-55","UI","UI",301017,291511,null,null,291511]
["NOVOEIGHT 250 UI POLVO Y SOLVENTE PARA SOLUCIÓN INYECTABLE","AM-TH-02-56","UI","UI",250848,220746,null,null,220746]
["OCTANINE F  250 UI","AM-TH-02-57","UI","UI",238965,229829,null,null,229829]
["IMMUNATE FACTOR VIII DE COAGULACION 250 UI","AM-TH-02-58","UI","UI",223189,222435,null,null,222435]
["OCTANATE 250 UI.","AM-TH-02-59","UI","UI",211240,205325,null,null,205325]
["AIMAFIX 500 U.I. POLVO PARA RECONSTITUIR A SOLUCIÓN DE INFUSIÓN INTRAVENOSA","AM-TH-02-60","UI","UI",208071,204903,null,null,204903]
["FANHDI 250 U.I. FACTOR VIII ANTIHEMOFILICO","AM-TH-02-61","UI","UI",179554,168992,null,null,168992]