{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["1 Etapa Asignacion Proyectos","Base Datos Consolidado General","Desplegables"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1 Etapa Asignacion Proyectos","index":0,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,0,4,13],[11,4,11,6],[0,0,2,2],[0,12,0,14],[1,12,1,14],[2,12,2,14],[0,3,2,11]]}
[null,null,null,"FORMATO: BASE DE DATOS CONSOLIDADA DE PRONUNCIAMIENTOS\n\nPROCESO: DIRECCIONAMIENTO ESTRATÉGICO\n\nHOJA 1  DE 2 ",null,null,null,null,null,null,null,null,"Versión: 1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Fecha:01/08/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Código:  DET-F-32"]
["Asignación del proyecto"]
[]
["CODIGO DE LA SOLICITUD","BPIN","DEPARTAMENTO","MUNICIPIO","Sector","Politica","Componente","PROYECTO","OCAD","VALOR TOTAL ($)","Evaluador Asignado","Tipo de Solicitud","Fecha Solicitud en SUIFP-SGR","Fecha Solicitud al Evaluador ","ESTADO DE ALERTA"]
[{"$f":"CONCATENATE(\"SGR-\",LEFT(ASIG.PROYECTOS[[#This Row],[DEPARTAMENTO]],2),LEFT(ASIG.PROYECTOS[[#This Row],[VALOR TOTAL ($)]],2),\"-\",RIGHT(ASIG.PROYECTOS[[#This Row],[BPIN]],2),RIGHT(ASIG.PROYECTOS[[#This Row],[Fecha Solicitud al Evaluador ]],1),RANDBETWEEN(0,1000))","v":"SGR--44"}]
[]
[]
[null,null,null,null,null,null,"  ",{"$f":"UPPER(H12)","v":""}]
[]
[null,null,null,null,"Si esta en minuscula usar la siguiente celda y se cambiara, luego aparecera en la celda superior y la podras pegar clic derecho opcion \"Valores\"(V) en la celda \"PROYECTO\""]
[]
["OCAD"]
["PAZ"]
["REGIONAL"]
["N/A LEY 2056","Proyectos que corresponden antes del 2020 "]
[]
["Tipo de proyecto"]
["VIABILIDAD","Concepto de Viabilidad, Documento mediante el cual se determina si un proyecto de inversión cumple las condiciones y criterios que lo hacen susceptible de financiación o cofinanciación con recursos del Sistema General de Regalías y si ofrece los beneficios suficientes frente a los costos en los cuales se va a incurrir, a través del análisis de la información técnica, social, ambiental, jurídica y financiera bajo los estándares metodológicos que para el efecto expida el Departamento Nacional de Planeación."]
["CTUS","Concepto Técnico Único sectorial, Es el documento que contiene el análisis integral de los componentes jurídico, técnico, social, ambiental y financiero del proyecto de inversión, solicitado por la secretaría técnica de los órganos colegiados de administración y decisión para la asignación de la inversión regional en cabeza de las regiones - OCAD Regional o del OCAD Paz"]
["CONCEPTO INTEGRADO","Concepto Integrado de Viabilidad Y Técnico Único Sectorial, Es el documento de análisis integral de la viabilidad y concepto técnico único sectorial, que incluye los componentes jurídico, técnico, social, ambiental y financiero, solicitado por la entidad que presenta el proyecto susceptible de financiarse o cofinanciarse con recursos de la fuente de inversión para la asignación regional en cabeza de regiones, al Departamento Nacional de Planeación o al Ministerio o al Departamento Administrativo líder del sector en el que se clasifique el proyecto de inversión."]
["AJUSTE","Concepto de Ajuste a Proyectos de Inversión Financiados o Cofinanciados con Recursos del Sistema General de Regalías, Es el documento que contiene el análisis integral de los requisitos y soportes de aquellas modificaciones introducidas al proyecto de inversión que no cambian su alcance, entendido como los objetivos generales y específicos, los productos y la localización"]

{"sheet":"Base Datos Consolidado General","index":1,"n_rows":17,"n_cols":67,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,2,2],[3,1,3,2],[14,55,15,60],[15,49,15,53],[15,35,15,39],[14,61,14,64],[15,61,15,64],[14,23,14,29],[15,23,15,29],[4,1,4,2],[5,1,5,2],[15,42,15,48],[4,3,5,7],[6,4,6,7],[7,3,9,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMATO: BASE DE DATOS CONSOLIDADA DE PRONUNCIAMIENTOS\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión: 1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROCESO: DIRECCIONAMIENTO ESTRATÉGICO\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha:01/08/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOJA 2 DE 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código:  DET-F-32"]
["N° de Proyectos Total",{"$f":"SUM(IFERROR(1/COUNTIF(BD[BPIN],BD[BPIN]),0))","v":0}]
["N° de Pronunciamientos",{"$f":"SUBTOTAL(3,B18:B21)","v":0},null,"Base de Datos Proyectos"]
["Valor total de Proyectos",{"$f":"SUBTOTAL(9,J18:J21)","v":0}]
[null,null,null,null,"Hacer Click al Perfil o Modulo Correspondiente "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Asignación del proyecto",null,null,null,null,null,null,null,null,null,null,null,null,"1ra Etapa de Evaluación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2da Etapa de Evaluación",null,null,null,null,null,null,"SEGUIMIENTO FINAL DE LA GESTION",null,null,null,null,null,"AJUSTE DE PROYECTOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUENTES SGR",null,null,null,null,null,null,null,null,null,null,null,"OTRAS FUENTES",null,null,null,null,null,null,"Cumplimiento de condiciones y criterios del proyecto de inversión presentado para ser financiado con recursos del SGR",null,null,null,null,null,null,"Gestión",null,null,null,null,null,null,null,null,null,null,null,"VALOR"]
["CODIGO DE LA SOLICITUD","BPIN","Departamento","Municipio","Sector","Politica","Componente","PROYECTO","OCAD","VALOR TOTAL ($)","EVALUADOR ASIGNADO","TIPO DE SOLICITUD","Fecha Solicitud en SUIFP SGR","Fecha Solicitud al Evaluador","DIAS DE PLAZO","Fecha Limite del Evaluador","ESTADO DE ALERTA","ALERTAS","Resultado de los días revisión del EV","AÑO","MES","Subsector","TIPO DE PROYECTO","Asignación para la inversión regional 40%","Asignación para la inversión regional 60%","Fonpet","Asignaciones para la paz","Asignaciones Directas (servicio a la deuda)","Asignación para la inversión local según NBI y municipios de cuarta, quinta y sexta categoría","Asignaciones directas","Fondo de compensación regional ","Fondo de desarrollo regional ","Incentivo a al Producción Rendimiento financieros 30%","Incentivo la Producción","VALOR TOTAL SGR","PGN","ESPECIE","Programa VIPA","SGP","Propios","VALOR TOTAL OTRAS FUENTES","VALOR TOTAL PROYECTO","TECNICO","FINANCIERO","JURIDICO","SOCIAL","AMBIENTAL","Observaciones puntuales-N/A","RESULTADO DEL CTUS / VIABILIDAD","NÚMERO DE REVISIÓN","Número de CTUS/VIABILIDAD previos emitidos","Fecha envío para VB° a Perfil aprobador","Fecha envío definitiva a perfil aprobador para cargue en SUIFP - SGR","Fase del Proyecto","HIPERVINCULO  DE CONCEPTO","Fecha de Aprobación Proyecto OCAD","Estado de Aprobación Proyecto OCAD","No. de Acta","Fecha de Acta","No. De Acuerdo","Fecha Acuerdo","VALOR ADICIONAL SOLICITADO SGR","TIPO DE ASIGNACIÓN SGR","VALOR ADICIONAL SOLICITADO OTRAS FUENTES","TIPO DE ASIGNACIÓN OTRAS FUENTES","VALOR TOTAL+AJUSTE","NUMERO DE CONTRATO-AÑO (EVALUADOR)"]

{"sheet":"Desplegables","index":2,"n_rows":105,"n_cols":17,"rows_kept":105,"cut":false,"hidden":true,"merged":[]}
["EVALUADORES","CONTRATO ",null,null,null,null,null,null,null,null,null,null,null,null,null,"FESTIVOS","2018-01-01"]
["Luis Ramirez","C 425-22",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-08"]
["Monica Orozco","C 931-21",null,null,"POLITICA",null,null,null,null,null,null,null,null,null,null,null,"2018-03-19"]
["Leyder Chiquillo","C 401-22",null,null,"V.Vivienda","V.Agua.y.Saneamiento",null,null,null,null,null,null,null,null,null,null,"2018-03-29"]
["Karina Manco","C 924-21",null,null,"COMPONENTE",null,null,null,null,null,null,null,null,null,null,null,"2018-03-30"]
["Maria Angelica Castelblanco","C 1063 21",null,null,"Vivienda","Espacio.Urbano.y.Territorial",null,null,null,null,null,null,null,null,null,null,"2018-05-01"]
["Osnayder Ebrat Angarita","C 404-22",null,null,"APSB",null,null,null,null,null,null,null,null,null,null,null,"2018-05-14"]
["Pablo Arango","C 977-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-02"]
[null,null,null,null,"SUBSECTOR",null,null,null,null,null,null,null,null,null,null,null,"2018-07-20"]
[null,null,null,null,"Vivienda.Rural","Vivienda.Urbana","Espacio.Publico","Operaciones.Urbana.Integrales","Renovacion.Urbana","Mejoramiento.Integral.de.Barrio","Ordenamiento.Territorial","ACUEDUCTO","ALCANTARILLADO","ASEO","SANEAMIENTO.BASICO","ACUEDUCTO.Y.ALCANTARILLADO","2018-08-07"]
["ALERTAS","DIAS",null,null,"Vivienda Nueva en Especie","Adquisición de Vivienda Nueva","Plazas","Operaciones Urbanas Integrales","Renovación Urbana","Mejoramiento Integral de Barrio","POT ","Acueducto","Alcantarillado Sanitario","Residuos Solidos","Planta de Tratamiento de Agua Residual (PTAR)","Acueducto y Alcantarillado","2018-08-20"]
["OK",5,null,null,"Mejoramiento de Vivienda","Construcción en Sitio Propio","Parque",null,null,null,"EOT","Planta de tratamiento de agua potable (PTAP)","Alcantarillado Pluvial",null,"Soluciones Individuales de Saneamiento Basico",null,"2018-10-15"]
["Alerta",0,null,null,null,"Mejoramiento de Vivienda","Alameda",null,null,null,"PBOT","Redes de distribucion","Alcantarillado Combinado",null,null,null,"2018-11-05"]
[null,null,null,null,null,null,"Malecón",null,null,null,"POD",null,null,null,null,null,"2018-12-08"]
[null,null,null,null,null,null,"Andén",null,null,null,null,null,null,null,null,null,"2018-12-25"]
[null,null,null,null,null,null,"Otro",null,null,null,null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-03-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-04-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-06-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-08-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-10-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-03-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-06-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-08-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-10-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-11-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-06-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-07-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-08-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-10-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-11-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-25"]