{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Verificaciones","POA","Puntajes","Capacidad Financiera","PO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"Verificaciones","index":0,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":true,"merged":[[34,2,37,21],[3,19,3,22],[3,1,4,2],[3,3,4,3],[3,15,3,18],[3,4,3,14],[6,1,12,1],[14,1,20,1],[21,1,25,1],[26,1,30,1]]}
[]
[]
[]
[null,"No. Oferta",null,"OFERENTE","Verificación Formulario No. 03",null,null,null,null,null,null,null,null,null,null,"Datos Declaración Renta 2003",null,null,null,"Variación"]
[null,null,null,null,"Activo Corriente","Activo Fijo","Otros Activos","Total Activo","Pasivo Corriente","Pasivo Mediano y Largo Plazo","Total Pasivo","Patrimonio","Total Pasivo + Patrimonio","Utilidad Antes de Impuesto","Utilidad Neta","Patrimonio Bruto","Total Pasivo","Patrimonio Liquido","Renta Liquida","Patrimonio Bruto","Total Pasivo","Patrimonio Liquido","Renta Liquida"]
[]
[null,1,null,"CONSORCIO LAS ANIMAS #1"]
[null,null,1.1000000000000001,"GERMA TORRES SALGADO",661279000,586850000,null,{"$f":"SUM(E8:G8)","v":1248129000},133995725,243009275,{"$f":"SUM(I8:J8)","v":377005000},{"$f":"+H8-K8","v":871124000},{"$f":"+K8+L8","v":1248129000},89170000,65583000,1248129000,353418000,894711000,93656000,{"$f":"(H8-P8)/P8","v":0},{"$f":"+(K8-Q8)/Q8","v":6.673966804180885E-2},{"$f":"(L8-R8)/R8","v":-2.6362702593351373E-2},{"$f":"(O8-S8)/S8","v":-0.29974587853421031}]
[null,null,1.2,"MARIO GIRALDO ENCISO",902790808,22582416,15532940,{"$f":"SUM(E9:G9)","v":940906164},69497421,467428657,{"$f":"SUM(I9:J9)","v":536926078},403980086,{"$f":"+K9+L9","v":940906164},18766695,20396695,null,null,null,null,{"$f":"(H9-P9)/P9","v":{"$error":"#DIV/0!"}},{"$f":"+(K9-Q9)/Q9","v":{"$error":"#DIV/0!"}},{"$f":"(L9-R9)/R9","v":{"$error":"#DIV/0!"}},{"$f":"(O9-S9)/S9","v":{"$error":"#DIV/0!"}}]
[null,null,1.3,"MANUEL MOSQUERA",300353422,251940082,69532472,621825976,153716887,54587444,208304331,413521645,621825976,16241438,16221673,611957000,208285000,403672000,17042000,1.6126910877725067E-2,9.2810331997023312E-5,2.4400119403872451E-2,-4.8135606149512969E-2]
[null,null,1.4,"JORGE DE JESUS E.",506655816,152054516,245059330,903769662,137779007,42562365,180341372,723428291,903769663,50395207,42647207,903769000,180341000,723428000,46988000,7.3248805834234188E-7,2.0627588845575881E-6,4.0225150256832744E-7,-9.2380884481144121E-2]
[null,null,1.5,"REPRESENTA Y CONS PAI LTDA",378072865,103601233,955950,482630048,36771662,134085789,170857451,311772597,482630048,15703386,7048986,482631000,170858000,311773000,22479000,-1.9725214501347823E-6,-3.2131945826358732E-6,-1.2926071212067754E-6,-0.68641905778726808]
[null,null,1.6,"ASFALTOS DE OCCID S.A.",69932426,460250218,107112095,637294739,29489669,80572256,110061925,527232814,637294739,8363847,3783847,637294000,110061000,527233000,11897000,1.1595903931309569E-6,8.4044302704863674E-6,-3.527852012298168E-7,-0.681949483062957]
[null,2,null,"CONCAY S.A.",40069494079,5482697057,13667555753,59219746889,21914617588,7301680273,29216297861,30003449028,59219746889,6682012591,6273203591,42778874000,22139102000,20639772000,1168027000,0.3843222448772261,0.31966950877230704,0.453671534162296,4.3707693323870078]
[null,3,null,"UNION TEMPORAL PAVIMENTACION DEL CHOCO"]
[null,null,3.1,"AULI FERNANDO VELANDIA M",1044688000,114208000,507125000,1666021000,89341000,920563000,1009904000,656117000,1666021000,82940000,65192000,1666021000,1009904000,656117000,82940000,0,0,0,-0.213986013986014]
[null,null,3.2,"HIFO S.A.",2210583412,1796245413,950172658,4957001483,578205453,2306752990,2884958443,2072043050,4957001493,126050800,81933020,4957002000,2884958000,2072044000,126051000,-1.042969117220449E-7,1.5355509508284004E-7,-4.5848447233746003E-7,-0.35000103132858923]
[null,null,3.3,"INFICAS S.A.",1128389590,497010730,450516529,2075916849,843827380,171544974,1015372354,1060544495,2075916849,150152888,84818888,2075917000,1014364000,1061553000,186669000,-7.2738938984554782E-8,9.9407510518906435E-4,-9.5002793077689012E-4,-0.54561877976525297]
[null,null,3.4,"CATOBRAS LTDA",null,null,null,0,null,null,0,null,0,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,3.5,"CARLOS MARIO PALACIO CH",397516649,44535519,null,442052168,205584360,null,205584360,236467808,442052168,52120000,52120000,442053000,205584000,{"$f":"P20-Q20","v":236469000},52120000,-1.8821272562339809E-6,1.7511090357226243E-6,-5.0408298762205619E-6,0]
[null,null,3.6,"LUIS CORANDO VELAZQUEZ",230187357,487735892,9625046,727548295,117145481,76862715,194008196,533540099,727548295,null,null,727548000,194008000,533540000,null,4.0547152902626356E-7,1.0102676178301925E-6,1.855530981744574E-7,{"$error":"#DIV/0!"}]
[null,4,null,"CONSORCIO GOMGO 35"]
[null,null,4.0999999999999996,"MIGUEL EDGAR ALFONSO",940500000,220000000,19500000,1180000000,50000000,50000000,100000000,1080000000,1180000000,38000000,38000000,1180000000,100000000,1080000000,35000000,0,0,0,8.5714285714285715E-2]
[null,null,4.2,"ABEL FRANCISCO VALBUENA",1215892000,443008000,283790000,1942690000,374625000,55000000,429625000,1513065000,1942690000,47375000,47375000,1942690000,429625000,1513065000,47375000,0,0,0,0]
[null,null,4.3,"CESAR GOMEZ",2149248232,390736722,null,2539984954,1922763807,93405043,2016168850,523816104,2539984954,41060626,54549620,2539984000,2016168000,523816000,71993000,3.7559291712073775E-7,4.2159185147269473E-7,1.9854299983200209E-7,-0.24229272290361564]
[null,null,4.4000000000000004,"LUIS MAYORGA AGUIRRE",1286602000,529776000,367025000,2183403000,631956000,6584000,638540000,1544863000,2183403000,null,null,2183403000,638540000,{"$f":"P26-Q26","v":1544863000},null,0,0,0,{"$error":"#DIV/0!"}]
[null,5,null,"CONSORCIO PLAN VIAL CHOCO 2005"]
[null,null,5.0999999999999996,"VARGAS VELANDIA LTDA",3662005000,457085000,114779000,4233869000,530721000,160038000,690759000,3543110000,4233869000,457250000,297212000,4229443000,686333000,3543110000,457250000,1.0464734954460906E-3,6.4487646667142628E-3,0,-0.35000109349371239]
[null,null,5.2,"NACIONAL DE PAVIMENTOS LTDA",1345051857,622683311,1888148909,3855884077,235974264,1059293810,1295268074,2560616003,3855884077,211804765,128144765,1968115000,1295268000,672847000,239030000,0.95917620515061364,5.7131033886423504E-8,2.8056437838022612,-0.46389672844412833]
[null,null,5.3,"JAIME VARGAS GALINDO",68481000,248149000,1829723000,2146353000,20336000,1030069000,1050405000,1095948000,2146353000,63435000,51635000,2146353000,1050405000,1095948000,63435000,0,0,0,-0.18601718294317018]
[null,null,5.4,"VINDICO S.A.",9098479232,531593591,{"$f":"1377315265+27043045","v":1404358310},11034431133,1681476244,4212950518,5894426762,5140004372,11034431134,101528025,54379630,11007389000,5894427000,5112962000,122857000,2.4567254777677068E-3,-4.0377122322492076E-8,5.2889835676463073E-3,-0.55737458997045342]
[]
[]
[null,"OBSERVACIONES:"]
[null,null,"CONSORCIO LAS ANIMAS #1,,se subsana integrante 1,2porque no conciliacines  "]

{"sheet":"POA","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Modulo","PO","N","Anticipo",null,"SMMLV 2020"]
[1,1756906480,24,0,null,877803]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]

{"sheet":"Puntajes","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[9,1,9,3],[1,5,1,7]]}
[]
[null,"EXPERIENCIA",null,null,null,"CAPACIDAD TÉCNICA"]
[null,"Mayor a","Menor o Igual a","Puntaje",null,"Desde","Hasta","Puntaje"]
[null,0,3,60,null,1,5,20]
[null,3,6,80,null,6,10,30]
[null,6,10,100,null,11,"Mayores",40]
[null,10,"Mayores",120]
[]
[]
[null,"CAPACIDAD FINANCIERA"]
[null,"Mayor a","Menor o Igual a","Puntaje"]
[null,0,0.5,20]
[null,0.5,0.75,25]
[null,0.75,1,30]
[null,1,1.5,35]
[null,1.5,"Mayores",40]

{"sheet":"Capacidad Financiera","index":3,"n_rows":33,"n_cols":35,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,27],[3,1,3,34],[2,1,2,34],[1,1,1,34],[7,15,9,15],[7,14,9,14],[7,13,9,13],[7,2,9,2],[7,9,9,9],[7,4,9,4],[6,1,6,3],[6,20,6,21],[6,22,6,23],[6,4,6,9],[4,1,4,34],[7,1,9,1],[7,3,9,3],[7,5,9,5],[7,7,9,7],[7,8,9,8],[7,10,9,10],[7,6,9,6],[7,34,9,34],[6,25,6,26],[7,25,7,26],[6,30,6,31],[7,30,7,31],[6,28,6,29],[7,27,9,27],[6,16,6,17],[7,16,7,17],[6,18,6,19],[7,18,7,19],[6,32,6,33],[7,32,7,33],[7,20,7,21],[7,22,7,23],[7,24,9,24]]}
[]
[]
[null,"UNIVERSIDAD DEL ATLÁNTICO"]
[null,"CONVOCATORIA INVITACIÓN PÚBLICA 003 DE 2020"]
[null,"EVALUACIÓN CAPACIDAD RESIDUAL, ORGANIZACIONAL Y FINANCIERA"]
[]
[null,"DATOS DEL INTERESADO",null,null,"INFORMACIÓN  FINANCIERA - RUP",null,null,null,null,null,null,null,null,null,null,null,"INDICE-CAPITAL DE TRABAJO DEMANDADO",null,"INDICE-PATRIMONIO",null,"INDICE-LIQUIDEZ",null,"INDICE-ENDEUDAMIENTO",null,null,"RAZON DE COBERTURA DE INTERESES",null,"EVALUACIÓN CAPACIDAD FINANCIERA","CALIDAD DE MIPYME",null,"RENTABILIDAD DEL PATRIMONIO (ROE)",null,"RENTABILIDAD DEL ACTIVO (ROA)",null,"EVALUACIÓN CAPACIDAD ORGANIZACIÓN"]
[null,"OFERTA","PROPONENTE","PORCENTAJE DE PARTICIPACION","ACTIVO CORRIENTE","ACTIVO TOTAL","PASIVO CORRIENTE","PASIVO TOTAL","CAPITAL DE TRABAJO\n\n(Activo Corriente - Pasivo Corriente)","PATRIMONIO\n\n(Activo Total - Pasivo Total)","PATRIMONIO ROE\n\n(Activo Total - Pasivo Total)",null,null,"MÓDULO","PLAZO (P)","VALOR PRESUPUESTO OFICIAL ANUAL(PO)","Fórmula: CT=AC-PC>=(50%*PO)",null,"Fórmula: P=AT-PT >= (70%*PO)",null,"Fórmula: Liquidez=AC/PC>=1,5",null,"Fórmula: Endeudamiento = Pas.T/Act.Tot. <= 0,70",null,"VALOR PATRIMONIO REQUERIDO MODULOS ADJUDICADOS","Fórmula: Razón Cobertura Intereses = UO/GI >= 1,3",null,"HABIL/NO HABIL","SMMLV 2011",535600,"Fórmula:                        ROE=UO/Pat.>=0,10",null,"Fórmula:                        ROE=UO/Act.Tot.>=0,05",null,"HABIL/NO HABIL"]
[null,null,null,null,null,null,null,null,null,null,null,"UTILIDAD OPERACIONAL","GASTOS DE INTERESES",null,null,null,"Req. Min. CTd: > =","(50%*PO)","Req. Min. Patrimonio: > =","70%*PO","Req. Min. Solvencia: > =",1.5,"Req. Min. Endeudamiento: < =",0.7,null,"Req. Min. Cobertura Intereses: > =",1.3,null,"SMMLV 2012",566700,"Req. Min. ROE: > =",0.1,"Req. Min. ROA: > =",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDICADOR","RESULTADO","INDICADOR","RESULTADO","INDICADOR","RESULTADO","INDICADOR","RESULTADO",null,"INDICADOR","RESULTADO",null,"CALIDAD DE MIPYME EN SMMLV",30000,"INDICADOR","RESULTADO","INDICADOR","RESULTADO"]
[]
[null,1,"CONSORCIO ADECUACION UNIVERSITARIA",1,28919251000,30660236600,6995645200,14120315800,27499875000,20712833000,16539920800,2833431400,411363800,1,24,1756906480,27499875000,"HABIL",20712833000,"HABIL",4.1338933255219974,"HABIL",0.46054164500478773,"HABIL",0,6.887896795974755,"HABIL","HABIL",null,null,0.1713086437511841,"HABIL",9.2413879154474632E-2,"HABIL","HABIL"]
[null,1.1000000000000001,"PROYECTOS Y GESTIÓN DEL DESARROLLO S.A.S",0.8,36110362000,38286594000,8737644000,17624337000,27372718000,20662257000,20662257000,3534685000,514107000,null,"","",null,"",null,"",null,"",null,"","",null,"","",67560.603493912116,"NO CUMPLE",null,"",null,"",""]
[null,1.2000000000000002,"PROYECTOS Y DESARROLLO DE COLOMBIA S.A.S",0.2,154807000,154807000,27650000,104231000,127157000,50576000,50576000,28417000,391000,null,"","",null,"",null,"",null,"",null,"","",null,"","",273.17275454385037,"MIPYME",null,"",null,"",""]
[null,"",null,null,null,null,null,null,0,0,0,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,null,null,null,null,0,0,0,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,2,"CONSORCIO URBANO - DEPORTIVO",1,9963139010.5,12268500131,5841478427,6786335354,8243321167,10964329554,5482164777,1557315101.5,179777057.5,1,24,1756906480,8243321167,"HABIL",10964329554,"HABIL",1.7055851759118377,"HABIL",0.55315118242142036,"HABIL",0,8.6624796464921552,"HABIL","HABIL",null,null,0.28406937128807136,"HABIL",0.12693606267036522,"HABIL","HABIL"]
[null,2.1,"CONSULTORES DE INGENIERIA UG21 SL SUCURSAL COLOMBIA",0.5,18194433218,21313587895,11218462852,12547182927,6975970366,8766404968,8766404968,2658235132,359522370,null,"","",null,"",null,"",null,"",null,"","",null,"","",37610.001579318865,"NO CUMPLE",null,"",null,"",""]
[null,2.2000000000000002,"TITO VELASQUEZ BECERRA",0.5,1731844803,3223412367,464494002,1025487781,1267350801,2197924586,2197924586,456395071,31745,null,"","",null,"",null,"",null,"",null,"","",null,"","",5688.0401746956059,"MIPYME",null,"",null,"",""]
[null,"",null,null,null,null,null,null,0,0,0,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,null,null,null,null,0,0,0,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]
[null,"",null,null,0,0,0,0,0,0,null,null,null,null,"","",null,"",null,"",null,"",null,"","",null,"","",0,"MIPYME",null,"",null,"",""]

{"sheet":"PO","index":4,"n_rows":101,"n_cols":2,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["ANEXO 1 - ADENDO 4 - DG-164-2004"]
[]
["NUMERO DE GRUPO","TOTAL GRUPO DE TRAMOS"]
[]
["Tramo 01",16097532669.306931]
["Tramo 02",18724260670]
["Tramo 03",15886461489]
["Tramo 04",18533406621]
["Tramo 05",14971945628]
["Tramo 06",16484340849]
["Tramo 07",16686919713.999998]
["Tramo 08",11566305868]
["Tramo 09",6300474910]
["Tramo 10",1428162158.4158416]
["Tramo 11",1292851961.3861387]
["Tramo 12",14200237260]
["Tramo 13",14388115033]
["Tramo 14",7076050599]
["Tramo 15",20893814942]
["Tramo 16",8810989120]
["Tramo 17",5818381842]
["Tramo 18",9650261634]
["Tramo 19",5385776414]
["Tramo 20",5759505844]
["Tramo 21",11365045650]
["Tramo 22",15652530637]
["Tramo 23",5772808797]
["Tramo 24",7512106130]
["Tramo 25",9347559589]
["Tramo 26",19825977010]
["Tramo 27",9200191515]
["Tramo 29",18743806542]
["Tramo 30",12488203547]
["Tramo 31",12337277639]
["Tramo 32",16198497482.999998]
["Tramo 33",17764576319]
["Tramo 35",22882731815]
["Tramo 36",7383905477]
["Tramo 37",12423743774]
["Tramo 38",14187262851]
["Tramo 39",9099377756]
["Tramo 40",7416098511]
["Tramo 41",16654736652]
["Tramo 42",12006016561]
["Tramo 43",14602426835]
["Tramo 44",16600395825]
["Tramo 45",9490692823]
["Tramo 46",14966356774]
["Tramo 47",16628059484]
["Tramo 48",11545020876]
["Tramo 49",11069859631]
["Tramo 50",16462254401]
["Tramo 51",29122451003]
["Tramo 52",19110837484]
["Tramo 53",14355039068]
["Tramo 54",10742553232]
["Tramo 55",12944688820]
["Tramo 56",11689433662]
["Tramo 57",11397659254]
["Tramo 59",16236395384]
["Tramo 60",6151462908.9075203]
["Tramo 61",24188206629]
["Tramo 62",22229863427]
["Tramo 63",23200278421]
["Tramo 64",33729146012]
["Tramo 65",25741331764]
["Tramo 66",10895316694.06304]
["Tramo 67",15574902572]
["Tramo 68",11085498362]
["Tramo 69",15569378930]
["Tramo 70",19872456988.21376]
["Tramo 71",9279916346]
["Tramo 72",11879598172]
["Tramo 73",14944234555]
["Tramo 74",8486287813]
["Tramo 75",7048832262]
["Tramo 76",5348779190]
["Tramo 77",5466387046]
["Tramo 78",16518448889]
["Tramo 79",8675202615]
["Tramo 81",16760013498]
["Tramo 82",12438755743]
["Tramo 83",14593425402]
["Tramo 84",6689468251]
["Tramo 85",8186369892]
["Tramo 86",28561249598]
["Tramo 87",34980509996]
["Tramo 88",6950846586]
["Tramo 89",11116163961]
["Tramo 90",21274070645]
["Tramo 91",2826770201]
["Tramo 92",4775546619]
["Tramo 93",23755514236]
["Tramo 94",22463613073]
["Tramo 95",20949816946]
["Tramo 96",14104036918]
["Tramo 97",1396272140.5940592]
["Tramo 98",1211346171.2871287]
["Tramo 99",1239693623.7623763]
["Tramo 100",1625508018.1759996]
[null,{"$f":"SUM(B4:B100)","v":1276966895152.1125}]