{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instrucciones para diligenciar","Hoja1","PLAN_DE_GESTION","GESTION DE RECURSOS","IND AMBIENTALES"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"Instrucciones para diligenciar","index":0,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[48,1,49,11],[32,2,32,10],[33,2,33,10],[34,2,34,10],[36,2,36,10],[37,2,37,10],[38,2,38,10],[39,2,39,10],[40,2,40,10],[41,2,41,10],[42,2,42,10],[44,2,45,11],[31,2,31,10],[19,2,19,10],[20,2,20,10],[21,2,21,10],[22,2,22,10],[23,2,23,10],[24,2,24,10],[25,2,25,10],[26,2,26,10],[28,2,28,10],[29,2,29,10],[30,2,30,10],[18,2,18,10],[4,1,4,11],[6,2,6,4],[6,7,6,9],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[16,2,16,10],[17,2,17,10],[0,2,2,7],[0,8,0,9],[0,10,0,11],[1,8,1,9],[1,10,1,11],[2,8,2,11]]}
[null,null,"PROCESO\nSERVICIOS ADMINISTRATIVOS\n\nFORMATO CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTIÓN AMBIENTAL",null,null,null,null,null,"F2.P29.SA",null,"2026-03-31"]
[null,null,null,null,null,null,null,null,"Versión 11",null,"Página 1 de 4"]
[null,null,null,null,null,null,null,null,"Clasificación de la Información:\nPública"]
[]
[null,"RECOMENDACIONES DE DILIGENCIAMIENTO PLAN DE GESTIÓN AMBIENTAL"]
[]
[null,null,"INFORMACIÓN TECNICA",null,null,null,null,"VALORES DE LAS ACTIVIDADES SEGÚN FRECUENCIAS DE REPORTES"]
[null,null,"Cronograma mes de inicio ","Abril",null,null,null,"TIEMPO","MESES","REPRESENTACION"]
[null,null,"Cronograma mes de final ","Diciembre",null,null,null,"MENSUAL",9,{"$f":"+D12/I9","v":0.1111111111111111}]
[null,null,"Fecha de reporte ","5 dias del mes siguiente",null,null,null,"BIMESTRAL",4,{"$f":"+D12/I10","v":0.25}]
[null,null,"Tiempo total (meses)",9,null,null,null,"TRIMESTRAL",3,{"$f":"+D12/I11","v":0.33333333333333331}]
[null,null,"Representación total de la actividad",1,null,null,null,"CUATRIMESTRAL",2,{"$f":"+D12/I12","v":0.5}]
[null,null,"Cortes de seguimiento semestrales, de la siguiente manera","1. Corte al 30 de Julio \n2.  Corte al 15 de diciembre",null,null,null,"SEMESTRAL",2,{"$f":"+J12","v":0.5}]
[null,null,null,null,null,null,null,"ANUAL",1,1]
[]
[]
[null,null,"RECOMENDACIONES"]
[null,null,"1. Para el mes de abril se debe reportar las evidencias de las actividades realizadas en los meses de enero, febrero y marzo."]
[null,null,"2. El resultado total de actividades se redondeo a dos (2) dédimas y el porcentaje de avance de cumplimiento se redondeo a una (1) décima."]
[null,null,"3. Tener presente que se efectuarán dos seguimientos de gestión, uno a corte del 30 de julio y el segundo corresponde al último reporte del año."]
[null,null,"4. El resultado final del primer semestre sera el dato de inicio para el segundo semestre, en caso de no haber realizado alguna actividad programada para el primer semestre no será posible su reporte."]
[null,null,"5. No enmarcar al Referente Ambiental y al Coordinador Administrativo como unicos responsables de la implementación del cronograma de gestión ambiental, esto considerando que hay otros colaboradores que aportan en dicho proceso."]
[null,null,"6. Se debe realizar el diligenciamiento de la columna denominada \"DESCRIPCION DE ACTIVIDADES\", con un breve resumen de la gestion realizada en el mes y mantener la trazabilidad de la actividad.\nEjemplo:\nAbril: Jornada de socialización de cláusulas contractuales con el hogar infantil XXXX\nMayo: Participación de la jornada de inducción en la Regional "]
[null,null,"8. Incluir el número de filas que se consideren necesarias para dar cumplimiento a las actividades de los programas del PGA formulado, en este caso es necesario tener presente las formulas y si es necesario arrastrar las celdas para garantizar que la formulación quede registrada en la respectiva celda."]
[null,null,"9. En la columna denominada\"ACTIVIDADES EJECUTADAS POR PROGRAMA\" se debe tener presente si se incorporaron nuevas filas, para que la formula que se aplica contenga las respectivas celdas."]
[null,null,"10. La columna denominada \"COMENTARIOS DE REVISION\", es diligenciada exclusivamente por el profesional ambiental enlace de la Sede de la Dirección General"]
[null,null,"11. El cuadro denominado \"CUADRO SEGUIMIENTO REPORTE MENSUAL - SEDE NACIONAL\", es de diligenciamiento exclusivo del profesional ambiental enlace de la Sede de la Dirección General"]
[]
[null,null,"GESTIÓN DE RECURSOS"]
[null,null,"1. Se debe diligenciar el valor presupuestal para la vigencia en caso de solicitar adicion y ser aprobada se debe digenciar el valor."]
[null,null,"2. Se debe definir cual es el programa definido en el PGA, el cual se definió la necesidad"]
[null,null,"3. En la Descripcion de elementos  definir las mismas actividades referidas en el PACCO."]
[null,null,"4. En la columna IDENTIFICACIÓN ITEM CONTRALORIA, escoger de acuerdo la lista desplegable la inversion a la que corresponda."]
[null,null,"5. En la descripción de la contratación escribir la  Fecha de suscripcion del contrato, Número de contrato y Objeto y el valor de contrato"]
[null,null,"6. En la columna de RESUMEN DE EJECUCIÓN describir el estado del contrato."]
[]
[null,null,"ÍNDICES AMBIENTALES"]
[null,null,"1. La meta de los índices de desempeño se definirán al principio de la vigencia."]
[null,null,"2. Se debe diligenciar mensualmente y su seguimiento obedece a la frecuencia establecida."]
[null,null,"3. El porcentaje de meta propuesta se debe cumplir al final de la vigencia."]
[null,null,"4. El denominador del índice de sensibilizacion ambiental, será el promedio de los colaboradores de la vigencia anterior y sera fijo durante la vigencia."]
[null,null,"5. La gestión de RAEE's y peligrosos solo serán los que gestione el profesional ambiental y no los incluidos en los contratos de almacen."]
[null,null,"6. El índice de desempeño de consumo sostenible - papel, solo aplicará el reporte relacionado con la Sede de la Dirección General y la Regional con los Centros Zonales, este último siempre y cuando se cuente con la información."]
[]
[null,null,"Nota: los indicadores de agua y energía no están incluidos dentro del los índices de desempeño ya que hacen parte del tablero de control."]
[]
[]
[]
[null,"¡Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA.\nLOS DATOS PROPORCIONADOS SERÁN TRATADOS DE ACUERDO A LA POLÍTICA DE TRATAMIENTO DE DATOS PERSONALES DEL ICBF Y A LA LEY 1581 DE 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ABRIL ","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,"MENSUAL "]
[null,"BIMENSUAL "]
[null,"TIRMESTRAL"]

{"sheet":"Hoja1","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["CUADRO DE PONDERACION "]
["PROGRAMA","%"]
["comunicación",0.05]
["infraestructura",0.2]
["residuos",0.2]
["automotor",0.15]
["zonas verdes",0.1]
["sustancias",0.1]
["vertimientos",0.15]
["seguimiento",0.05]
["TOTAL ",{"$f":"+SUM(B3:B10)","v":1}]

{"sheet":"PLAN_DE_GESTION","index":2,"n_rows":361,"n_cols":60,"rows_kept":361,"cut":false,"hidden":false,"merged":[[10,40,13,40],[26,42,29,42],[30,42,33,42],[34,42,37,42],[42,43,45,43],[14,43,17,43],[18,43,21,43],[11,42,13,42],[12,43,13,43],[11,43,11,44],[12,44,13,44],[95,24,95,45],[95,1,95,23],[50,43,55,43],[59,1,59,11],[59,12,60,12],[59,17,59,44],[60,17,60,44],[64,17,64,44],[68,17,68,44],[50,1,54,1],[50,42,55,42],[7,37,7,38],[10,37,13,37],[10,38,13,38],[55,8,55,33],[10,20,13,20],[10,21,13,21],[10,8,10,19],[7,28,7,30],[11,28,11,30],[12,28,13,28],[12,29,13,29],[12,30,13,30],[10,22,10,36],[12,13,13,13],[12,25,13,25],[12,18,13,18],[11,14,11,16],[11,17,11,19],[11,25,11,27],[12,26,13,26],[12,24,13,24],[12,14,13,14],[12,27,13,27],[12,11,13,11],[96,31,97,45],[11,45,13,45],[3,0,3,45],[7,3,7,6],[5,4,5,6],[6,4,6,6],[10,41,13,41],[10,39,13,39],[7,25,7,27],[7,31,7,33],[12,36,13,36],[7,34,7,36],[12,32,13,32],[12,22,13,22],[12,35,13,35],[12,33,13,33],[12,34,13,34],[82,1,82,9],[83,1,83,9],[79,1,79,9],[80,1,80,9],[74,2,74,4],[22,42,25,42],[38,43,41,43],[18,1,21,1],[14,1,17,1],[42,0,45,0],[22,0,25,0],[42,1,45,1],[46,1,49,1],[38,0,41,0],[26,0,29,0],[30,0,33,0],[34,0,37,0],[14,0,17,0],[38,1,41,1],[18,0,21,0],[22,1,25,1],[30,1,33,1],[34,1,37,1],[11,31,11,33],[11,34,11,36],[14,42,17,42],[18,42,21,42],[12,31,13,31],[12,9,13,9],[12,8,13,8],[11,0,11,7],[12,0,13,0],[12,1,13,1],[12,23,13,23],[12,15,13,15],[12,16,13,16],[12,17,13,17],[11,8,11,10],[12,2,13,2],[12,6,12,7],[12,3,13,3],[12,4,13,4],[12,19,13,19],[11,11,11,13],[11,22,11,24],[12,12,13,12],[12,5,13,5],[46,43,49,43],[34,43,37,43],[26,43,29,43],[22,43,25,43],[30,43,33,43],[42,42,45,42],[46,42,49,42],[38,42,41,42],[50,0,55,0],[26,1,29,1],[46,0,49,0],[12,10,13,10],[0,26,0,27],[0,28,0,29],[1,26,1,27],[1,28,1,29],[2,26,2,29],[7,8,7,10],[7,11,7,13],[7,14,7,16],[7,17,7,19],[7,20,7,21],[7,22,7,24],[0,2,2,25]]}
[null,null,"PROCESO\nSERVICIOS ADMINISTRATIVOS \n\nFORMATO CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTIÓN AMBIENTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2.P29.SA",null,"2026-03-31"]
[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 11",null,"Página 2 de 4"]
[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,"Clasificación de la Información:\nPública"]
[]
[]
[null,null,null,"1, Regional"]
[null,null,null,"2. Vigencia"]
[null,null,null,"3. Fecha de Corte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GESTIÓN PRIMER SEMESTRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GESTIÓN SEGUNDO SEMESTRE"]
[]
[]
[null,null,null,null,null,null,null,null,"GESTIÓN  PRIMER SEMESTRE",null,null,null,null,null,null,null,null,null,null,null,"ACUMULADO","% DE AVANCE I SEMESTRE","GESTIÓN  SEGUNDO SEMESTRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACUMULADO","% DE AVANCE II SEMESTRE","FRECUENCIA","% POR ACTIVIDAD","GESTIÓN POR ACTIVIDADES ACUMULADA"]
["PROGRAMACIÓN",null,null,null,null,null,null,null,"ABRIL",null,null,"MAYO",null,null,"JUNIO",null,null,"JULIO",null,null,null,null,"AGOSTO",null,null,"SEPTIEMBRE",null,null,"OCTUBRE",null,null,"NOVIEMBRE",null,null,"DICIEMBRE",null,null,null,null,null,null,null,"ACTIVIDADES EJECUTADAS  POR PROGRAMA","SEGUIMIENTO",null,"COMENTARIOS DE REVISIÓN"]
["N°","Programa del PGA","No.","Actividades","Responsable de la \nActividad","Periodicidad","Fechas Programación Actividades",null,"Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance",null,null,"Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance","Fecha Ejecución ","Estado Tarea","Avance",null,null,null,null,null,null,"Evidencia/ Registro","Descripción  de la Actividad"]
[null,null,null,null,null,null,"Fecha\n Inicio","Fecha\nFinal"]
[1,"COMUNICACIÓN Y SENSIBILIZACION AMBIENTAL",null,null,null,null,null,null,null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(I15>0,\"C\",IF($I$8<G15,0,IF($I$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(I15=0,0,IF($G$13>=I15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(L15>0,\"C\",IF($L$8<G15,0,IF($L$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(L15=0,0,IF($G$13>=L15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(O15>0,\"C\",IF($O$8<G15,0,IF($O$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(O15=0,0,IF($G$13>=O15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(R15>0,\"C\",IF($R$8<G15,0,IF($R$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(R15=0,0,IF($G$13>=R15,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(I15:T15,\"CC\")","v":0},{"$f":"+IFERROR(AO15*U15,0)","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(W15>0,\"C\",IF($W$8<G15,0,IF($W$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(W15=0,0,IF($G$13>=W15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(Z15>0,\"C\",IF($Z$8<G15,0,IF($Z$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(Z15=0,0,IF($G$13>=Z15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AC15>0,\"C\",IF($AC$8<G15,0,IF($AC$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AC15=0,0,IF($G$13>=AC15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AF15>0,\"C\",IF($AF$8<G15,0,IF($AF$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AF15=0,0,IF($G$13>=AF15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AI15>0,\"C\",IF($AI$8<G15,0,IF($AI$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AI15=0,0,IF($G$13>=AI15,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(W15:AK15,\"CC\")","v":0},{"$f":"+IFERROR(AO15*AL15,0)","v":0},{"$f":"+IF(F15=\"MENSUAL\",9,IF(F15=\"BIMESTRAL\",4,IF(F15=\"TRIMESTRAL\",3,IF(F15=\"CUATRIMESTRAL\",2,IF(F15=\"SEMESTRAL\",2,IF(F15=\"ANUAL\",1,0))))))","v":0},{"$f":"IFERROR(1/AN15,0)","v":0},{"$f":"+V15+AM15","v":0},{"$f":"+IFERROR(SUM(AP15:AP18),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(I16>0,\"C\",IF($I$8<G16,0,IF($I$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(I16=0,0,IF($G$13>=I16,\"CC\",\"E\"))","v":0},null,0,{"$f":"IF(L16=0,0,IF($G$13>=L16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(O16>0,\"C\",IF($O$8<G16,0,IF($O$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(O16=0,0,IF($G$13>=O16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(R16>0,\"C\",IF($R$8<G16,0,IF($R$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(R16=0,0,IF($G$13>=R16,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(I16:T16,\"CC\")","v":0},0,null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(W16>0,\"C\",IF($W$8<G16,0,IF($W$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(W16=0,0,IF($G$13>=W16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(Z16>0,\"C\",IF($Z$8<G16,0,IF($Z$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(Z16=0,0,IF($G$13>=Z16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AC16>0,\"C\",IF($AC$8<G16,0,IF($AC$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AC16=0,0,IF($G$13>=AC16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AF16>0,\"C\",IF($AF$8<G16,0,IF($AF$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AF16=0,0,IF($G$13>=AF16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AI16>0,\"C\",IF($AI$8<G16,0,IF($AI$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AI16=0,0,IF($G$13>=AI16,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(W16:AK16,\"CC\")","v":0},{"$f":"+IFERROR(AO16*AL16,0)","v":0},0,{"$f":"IFERROR(1/AN16,0)","v":0},{"$f":"+V16+AM16","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[2,"MANEJO DE RESIDUOS SÓLIDOS ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP19:AP22),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[3,"MANEJO DE VERTIMIENTOS",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP23:AP26),0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D24=0,0,IF(G24=0,0,IF(H24=0,0,IF(I24>0,\"C\",IF($I$8<G24,0,IF($I$8>H24,\"V\",\"E\"))))))","v":0},0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,{"$f":"+COUNTIF(I25:T25,\"CC\")","v":0},0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[4,"MANEJO DEL PARQUE AUTOMOTOR",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP27:AP30),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[5,"MANEJO DE ZONAS VERDES",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP31:AP34),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[6,"GESTIÓN AMBIENTAL CONTRACTUAL ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP35:AP38),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[7,"CONSUMO SOSTENIBLE ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP39:AP42),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,{"$f":"+COUNTIF(I42:T42,\"CC\")","v":0},0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[8,"SITUACIONES DE EMERGENCIA AMBIENTAL",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,{"$f":"+COUNTIF(I43:T43,\"CC\")","v":0},0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP43:AP46),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[9,"CALIDAD DEL AIRE (AIRE - RUIDO -PEV) ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP47:AP50),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[10,"PLANIFICACIÓN DE RECURSOS EJE AMBIENTAL",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0,{"$f":"+IFERROR(SUM(AP51:AP56),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,{"$f":"IF(L54=0,0,IF($G$13>=L54,\"CC\",\"E\"))","v":0},null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,{"$f":"IFERROR(1/AN54,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0,null,0,{"$f":"IF(L55=0,0,IF($G$13>=L55,\"CC\",\"E\"))","v":0},null,0,0,null,0,0,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,0,0,0,0,0]
[null,"EJECUCIÓN DE RECURSOS EJE AMBIENTAL",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,{"$f":"+'GESTION DE RECURSOS'!F7","v":{"$error":"#DIV/0!"}},{"$f":"+IF(AJ56>=50%,\"CC\",\"NC\")","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"IFERROR(1/AN56,0)","v":0},{"$f":"+V57+AM56","v":0}]
[]
[]
[]
[null,"CUADRO SEGUIMIENTO REPORTE MENSUAL - SEDE NACIONAL",null,null,null,null,null,null,null,null,null,null,"ACUMULADO GENERAL",null,null,null,null,"Logros Periodicos"]
[null,"Programa del PGA","Núm Act","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE ","DICIEMBRE",null,null,null,null,null,"I PERIODO DE MARZO A JUNIO"]
[null,"Programa No. 1",{"$f":"COUNTA(C15:C18)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ15","v":0}]
[null,"Programa No. 2",{"$f":"COUNTA(C19:C22)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ19","v":0}]
[null,"Programa No. 3",{"$f":"COUNTA(C23:C26)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ23","v":0}]
[null,"Programa No. 4",{"$f":"COUNTA(C27:C30)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ27","v":0},null,null,null,null,"II PERIODO DE JULIO A SEPTIEMBRE"]
[null,"Programa No. 5",{"$f":"COUNTA(C31:C34)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ31","v":0}]
[null,"Programa No. 6",{"$f":"COUNTA(C35:C38)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ35","v":0}]
[null,"Programa No. 7",{"$f":"COUNTA(C39:C42)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ39","v":0}]
[null,"Programa No. 8",{"$f":"COUNTA(C43:C46)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ43","v":0},null,null,null,null,"III PERIODO DE OCTUBRE A DICIEMBRE"]
[null,"Programa No. 9",{"$f":"COUNTA(C47:C50)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ47","v":0}]
[null,"Programa No. 10",{"$f":"COUNTA(C51:C56)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+AQ51","v":0}]
[null,"TOTALES",{"$f":"SUBTOTAL(109,Tabla3[Núm Act])","v":0},{"$f":"SUBTOTAL(109,Tabla3[ABRIL])","v":0},{"$f":"SUBTOTAL(109,Tabla3[MAYO])","v":0},{"$f":"SUBTOTAL(109,Tabla3[JUNIO])","v":0},{"$f":"SUBTOTAL(109,Tabla3[JULIO])","v":0},{"$f":"SUBTOTAL(109,Tabla3[AGOSTO])","v":0},{"$f":"SUBTOTAL(109,Tabla3[SEPTIEMBRE])","v":0},{"$f":"SUBTOTAL(109,Tabla3[OCTUBRE])","v":0},{"$f":"SUBTOTAL(109,Tabla3[[NOVIEMBRE ]])","v":0},{"$f":"SUBTOTAL(109,Tabla3[DICIEMBRE])","v":0},{"$f":"++SUM(M62:M71)","v":0}]
[]
[]
[null,null,"AVANCE TOTAL"]
[null,"TOTAL DE ACTIVIDADES",{"$f":"+SUM(C62:C71)","v":0},{"$f":"+ROUND(M72,2)","v":0},{"$f":"+IFERROR(ROUND(D76/C76,3),0)","v":0}]
[]
[]
[]
[null,"OBSERVACIONES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"¡Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA.\nLOS DATOS PROPORCIONADOS SERÁN TRATADOS DE ACUERDO A LA POLÍTICA DE TRATAMIENTO DE DATOS PERSONALES DEL ICBF Y A LA LEY 1581 DE 2012.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"¡Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA.\nLOS DATOS PROPORCIONADOS SERÁN TRATADOS DE ACUERDO A LA POLÍTICA DE TRATAMIENTO DE DATOS PERSONALES DEL ICBF Y A LA LEY 1581 DE 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARAUCA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATLANTICO"]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAQUETA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASANARE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAUCA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CESAR"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORDOBA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUNDINAMARCA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUAJIRA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUANIA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUAVIARE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUILA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAGDALENA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NARIÑO"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTE DE SANTANDER"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUTUMAYO"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINDIO"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISARALDA"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAN ANDRES "]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANTANDER"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEDE DE LA DIRECCION GENERAL"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUCRE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOLIMA "]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALLE"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUPES"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VICHADA"]

{"sheet":"GESTION DE RECURSOS","index":3,"n_rows":167,"n_cols":15,"rows_kept":167,"cut":false,"hidden":false,"merged":[[15,7,15,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[28,7,28,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[23,7,23,9],[24,7,24,9],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[31,0,32,9],[29,0,29,5],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,12,6],[12,7,13,9],[14,7,14,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[5,1,5,2],[4,7,4,8],[0,2,2,6],[0,8,0,9],[1,8,1,9],[2,7,2,9],[4,1,4,2]]}
[null,null,"PROCESO\nSERVICIOS ADMINISTRATIVOS\n\n\nFORMATO CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTIÓN AMBIENTAL",null,null,null,null,"F2.P29.SA","2026-03-31"]
[null,null,null,null,null,null,null,"Versión 11","Página 3 de 4"]
[null,null,null,null,null,null,null,"Clasificación de la Información:\nPública"]
[]
[null,"ASIGNACION PRESUPUESTAL\n(Apropiación Inicial)",null,null,null,null,null,"ACUERDO DE GESTION ",null,null,null,6,"OPTIMO",0.95,1]
[null,"ADICIONES",null,null,null,"PORCENTAJE DE EJECUCION ",null,"50,00% o más","CUMPLIDA",null,null,5,"RIESGO",0.90100000000000002,0.94899999999999995]
[null,"TOTAL APROPIACION VIGENTE",null,null,null,{"$f":"+(D8)/D7","v":{"$error":"#DIV/0!"}},null,"< 49,99% ","NO CUMPLIDA",null,null,4,"RIESGO",0.85,0.9]
[null,"VALOR CONTRATOS",null,null,null,null,null,null,null,null,null,3,"CRITICO",0.35010000000000002,0.84899999999999998]
[null,"SALDO",null,{"$f":"+D7-D8","v":0}]
[null,"LIBERACIÓN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,2,"CRITICO",0,0.35]
["ITEM","PROGRAMA DEL PGA","DESCRIPCIÓN DE ELEMENTOS","IDENTIFIACIÓN ITEM CONTRALORIA\n(SELECCIONAR UNA OPCIÓN)","DESCRIPCION DE LA CONTRATACIÓN",null,null,"RESUMEN DE EJECUCIÓN"]
[null,null,null,null,"FECHA DE SUSCRIPCIÓN","Número de contrato y Objeto","Valor del Contrato"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
["TOTALES",null,null,null,null,null,{"$f":"SUM(G15:G29)","v":0}]
[]
["¡Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA.\nLOS DATOS PROPORCIONADOS SERÁN TRATADOS DE ACUERDO A LA POLÍTICA DE TRATAMIENTO DE DATOS PERSONALES DEL ICBF Y A LA LEY 1581 DE 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"INVERSIÓN OPERATIVA (O DE APOYO) / EDUCACIÓN"]
[null,null,"INVERSIÓN OPERATIVA (O DE APOYO) / FOMENTO"]
[null,null,"INVERSIÓN OPERATIVA (O DE APOYO) / ADMINISTRACIÓN"]
[null,null,"INVERSIÓN OPERATIVA (O DE APOYO) / OTROS"]
[null,null," INVERSIÓN EN MEDIO AMBIENTE / RECURSO HÍDRICO"]
[null,null,"INVERSIÓN EN MEDIO AMBIENTE / BOSQUES"]
[null,null,"INVERSIÓN EN MEDIO AMBIENTE / AIRE"]
[null,null,"INVERSIÓN EN MEDIO AMBIENTE / SUELO"]
[null,null,"INVERSIÓN EN MEDIO AMBIENTE / BIODIVERSIDAD"]
[null,null,"INVERSIÓN EN AGUA POTABLE Y SANEAMIENTO BASICO / AGUA POTABLE"]
[null,null,"INVERSIÓN EN AGUA POTABLE Y SANEAMIENTO BASICO  / TRATAMIENTO DE VERTIMIENTOS"]
[null,null,"INVERSIÓN EN AGUA POTABLE Y SANEAMIENTO BÁSICO / MANEJO Y DISPOSICIÓN DE RESIDUOS SÓLIDOS"]
[null,null,"INVERSIÓN EN AGUA POTABLE Y SANEAMIENTO BÁSICO / MANEJO Y DISPOSICIÓN DE RESIDUOS PELIGROSOS"]
[null,null,"INVERSIÓN EN GESTIÓN DEL RIESGO / PREVENCIÓN DE DESASTRES"]
[null,null,"INVERSIÓN EN GESTIÓN DEL RIESGO / INCENDIOS FORESTALES"]
[null,null,"INVERSIÓN EN GESTIÓN DEL RIESGO / APOYO A LA ATENCIÓN DE DESASTRES"]
[null,null,"INVERSIÓN EN GESTIÓN DEL RIESGO / ACTIVIDADES POST-DESASTRE"]
[null,null,"INVERSIÓN EN GESTIÓN AMBIENTAL URBANA"]

{"sheet":"IND AMBIENTALES","index":4,"n_rows":18,"n_cols":36,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,0,18,35],[15,27,16,27],[15,29,16,29],[15,31,16,31],[15,33,16,33],[15,34,16,34],[15,35,16,35],[15,16,16,16],[15,18,16,18],[15,20,16,20],[15,22,16,22],[15,24,16,24],[15,25,16,25],[15,6,16,6],[15,7,16,7],[15,9,16,9],[15,11,16,11],[15,13,16,13],[15,15,16,15],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[11,34,12,34],[11,35,12,35],[13,1,14,1],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,34,14,34],[13,35,14,35],[9,30,10,30],[9,32,10,32],[9,33,10,33],[9,34,10,34],[9,35,10,35],[11,0,14,0],[11,1,12,1],[11,3,12,3],[11,4,12,4],[11,5,12,5],[9,28,10,28],[9,8,10,8],[9,10,10,10],[9,12,10,12],[9,14,10,14],[9,15,10,15],[9,17,10,17],[9,19,10,19],[9,21,10,21],[9,23,10,23],[9,24,10,24],[9,26,10,26],[7,30,8,30],[7,32,8,32],[7,33,8,33],[7,34,8,34],[7,35,8,35],[7,26,8,26],[9,1,10,1],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[7,17,8,17],[7,19,8,19],[7,21,8,21],[7,23,8,23],[7,24,8,24],[7,8,8,8],[7,10,8,10],[7,12,8,12],[7,14,8,14],[7,15,8,15],[7,6,8,6],[3,0,3,35],[4,0,5,1],[4,3,4,11],[4,12,4,13],[4,14,4,27],[4,28,4,32],[5,3,5,11],[5,12,5,13],[5,14,5,27],[7,0,10,0],[7,1,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,28,8,28],[0,2,2,31],[0,32,0,33],[0,34,0,35],[1,32,1,33],[1,34,1,35],[2,32,2,35]]}
[null,null,"PROCESO\nSERVICIOS ADMINISTRATIVOS \n\n\nFORMATO CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTIÓN AMBIENTAL",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,"F2.P29.SA",null,"2026-03-31"]
[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 11",null,"Página 4 de 4"]
[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,"Clasificación de la Información:\nPública"]
["INDICES DE DESEMPEÑO AMBIENTAL"]
["Recomendaciones para el reporte de índices:\n\nA continuación, encontrará las recomendaciones a tener en cuenta para cada uno de los índices, con el fin de  precisar la información a reportar y la metodología de cálculo para cada uno de ellos.\n\nLa información presentada en el cuadro, corresponde a datos aleatorios para guia de diligenciamiento.\n\nNota: La frecuencia de corte para estos indices es cuatrimestral, sin embargo, se deben realizar los reportes mensuales; en caso que no se tenga información se debe colocar cero (0).",null,"SENSIBILIZACION AMBIENTAL","1. En la columna denominada \"Datos de promedio / Línea base\" se debe colocar el número promedio de colaboradores de la vigencia anterior. \n2. En la columna de denominada \"Resultado # Corte\", se obtendra el resultado  promedio de los % de desempeño de cada mes del cuatrimestre, esto obedece a que por las temáticas o actividades algún colaborador pueda repetir más de una jornada.\n3. La columna denominada \"Desempeño Anual\" corresponde al resultado promedio de cada uno de los cortes cuatrimestrales.",null,null,null,null,null,null,null,null,"MANEJO DE RESIDUOS SÓLIDOS\n\nÍNDICE ENTREGA DE MATERIAL APROVECHABLE",null,"1. La información que aparece en la columna denominada \"Resultado # Corte\" en cada uno de los 3 cortes corresponde a la sumatoria individual de la información relacionada a la entrega y a la generación de residuos aprovechables.\n2. Este índice no tiene metodología de cálculo por reporte mensual, para este caso la gestión se verá reflejada en la columna denominada \"Desempeño Anual\" sumando los registros mensuales de residuos de entrega dividido entre la suma de los registros mensuales de residuos generados.\n3. En caso que se tengan residuos por gestionar de la vigencia anterior se deben relacionar en el mes de enero como residuos generados.",null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL CENTROS ZONALES Y REGIONAL QUE HACEN PARTE DE LA LINEA BASE"]
[null,null,"MANEJO DE RESIDUOS SÓLIDOS\n\nÍNDICE DISPOSICION FINAL DE RESIDUOS RAEES Y PELIGROSOS","\n1. La información que aparece en la columna denominada \"Resultado # Corte\" en cada uno de los 3 cortes corresponde a la sumatoria individual de la información relacionada a la entrega y a la generación de este tipo de residuos.\n2. Este índice no tiene metodología de cálculo por reporte mensual, para este caso la gestión se verá reflejada en la columna denominada \"Desempeño Anual\" sumando los registros mensuales de residuos de entrega dividido entre la suma de los registros mensuales de residuos generados.\n3. En caso que se tengan residuos por gestionar de la vigencia anterior se deben relacionar en el mes de enero como residuos generados.",null,null,null,null,null,null,null,null,"CONSUMO PAPEL",null,"\n1. La línea base para este índice se determina de la siguiente manera:   \n- Sumar los consumos mensuales de la vigencia anterior, para determinar el consumo anual, este valor será la linea base.\n2. La información que se debe diligenciar mensualmente corresponde a los consumos del mes incluyendo la información de la regional y centros zonales.\n3. Se realizará un seguimiento cuatrimestral, el cual se verá reflejado en la columna denominada \"Resultado # Corte\", este se determina como la  suma de los consumos mensuales del cuatrimestre de la vigencia actual.\n4. El calculo de cada uno de los cortes se reflejara en número.\n5.La información de la columna \"Desempeño Anual\" se expresa en números de resmas de papel y corresponde a la sumatoria de cada uno de los resultados de los cortes cuatrimestrales, el cual para cumplir la meta deberá ser menor o igual a la línea base.\n"]
["PROGRAMA DEL PGA","OBJETIVO PROGRAMA PGA","FORMULACIÓN","FRECUENCIA DEL REPORTE","META ANUAL","DESCRIPCIÓN","DATOS DE PROMEDIO/LíNEA BASE","ENERO","% DESEMPEÑO","FEBRERO","% DESEMPEÑO","MARZO","% DESEMPEÑO","ABRIL","% DESEMPEÑO","RESULTADO I CORTE","MAYO","% DESEMPEÑO","JUNIO","% DESEMPEÑO","JULIO","% DESEMPEÑO","AGOSTO","% DESEMPEÑO","RESULTADO II CORTE","SEPTIEMBRE","% DESEMPEÑO","OCTUBRE","% DESEMPEÑO","NOVIEMBRE","% DESEMPEÑO","DICIEMBRE","% DESEMPEÑO","RESULTADO III CORTE","DESEMPEÑO ANUAL","ESTADO"]
["SENSIBILIZACION AMBIENTAL","Regionales iguales o superior a 10 Centros Zonales\nSensibilizar a los colaboradores y visitantes en buenas prácticas ambientales ","Número de colaboradores sensibilizados en Regional y CZ","MENSUAL",null,"Sensibilizar como mínimo el porcentaje de colaboradores propuestos en la meta ",null,null,{"$f":"+IFERROR(H8/H9,0)","v":0},null,{"$f":"+IFERROR(J8/J9,0)","v":0},null,{"$f":"+IFERROR(L8/L9,0)","v":0},null,{"$f":"+IFERROR(N8/N9,0)","v":0},{"$f":"AVERAGE(I8+K8+M8+O8)","v":0},null,{"$f":"+IFERROR(Q8/Q9,0)","v":0},null,{"$f":"+IFERROR(S8/S9,0)","v":0},null,{"$f":"+IFERROR(U8/U9,0)","v":0},null,{"$f":"+IFERROR(W8/W9,0)","v":0},{"$f":"+AVERAGE(R8+T8+V8+X8)","v":0},null,{"$f":"+IFERROR(Z8/Z9,0)","v":0},null,{"$f":"+IFERROR(AB8/AB9,0)","v":0},null,{"$f":"+IFERROR(AD8/AD9,0)","v":0},null,{"$f":"+IFERROR(AF8/AF9,0)","v":0},{"$f":"+AVERAGE(AA8+AC8+AE8+AG8)","v":0},{"$f":"AVERAGE(P8,Y8,AH8)","v":0},{"$f":"+IF(AI8>=E8,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"META CUMPLIDA"}]
[null,null,"Promedio de colaboradores de la vigencia anterior"]
[null,"Regionales iguales o  inferiores a 9 Centros Zonales\nSensibilizar a los colaboradores y visitantes en buenas prácticas ambientales","Número de colaboradores sensibilizados en Regional y CZ","MENSUAL",null,"Sensibilizar como mínimo el porcentaje de colaboradores propuestos en la meta ",null,null,{"$f":"+IFERROR(H10/H11,0)","v":0},null,{"$f":"+IFERROR(J10/J11,0)","v":0},null,{"$f":"+IFERROR(L10/L11,0)","v":0},null,{"$f":"+IFERROR(N10/N11,0)","v":0},{"$f":"+I10+K10+M10+O10","v":0},null,{"$f":"+IFERROR(Q10/Q11,0)","v":0},null,{"$f":"+IFERROR(S10/S11,0)","v":0},null,{"$f":"+IFERROR(U10/U11,0)","v":0},null,{"$f":"+IFERROR(W10/W11,0)","v":0},{"$f":"+R10+T10+V10+X10","v":0},null,{"$f":"+IFERROR(Z10/Z11,0)","v":0},null,{"$f":"+IFERROR(AB10/AB11,0)","v":0},null,{"$f":"+IFERROR(AD10/AD11,0)","v":0},null,{"$f":"+IFERROR(AF10/AF11,0)","v":0},{"$f":"+AA10+AC10+AE10+AG10","v":0},{"$f":"+AVERAGE(P10,Y10,AH10)","v":0},{"$f":"+IF(AI10>=E10,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"META CUMPLIDA"}]
[null,null,"Promedio de colaboradores de la vigencia anterior"]
["MANEJO DE RESIDUOS SÓLIDOS ","Disminuir la cantidad de residuos entregados a la empresa de servicios públicos de aseo, mediante la separación en la fuente y aprovechamiento de estos.","Total kg de residuos sólidos aprovechados entregados al gestor","MENSUAL",null,"Gestionar como mínimo el porcentaje de residuos aprovechables propuestos en la meta","N.A.",null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(H12+J12+L12+N12)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q12+S12+U12+W12)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Z12+AB12+AD12+AF12)","v":0},{"$f":"+IFERROR(SUM(P12+Y12+AH12)/SUM(P13+Y13+AH13),0)","v":0},{"$f":"+IF(AI12>=E12,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"META CUMPLIDA"}]
[null,null,"Total kg de residuos sólidos generados",null,null,null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(H13+J13+L13+N13)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q13+S13+U13+W13)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Z13+AB13+AD13+AF13)","v":0}]
[null,"Garantizar la disposición final de residuos RAEEs y peligrosos mediante su entrega a gestores ambientales y/o puntos autorizados","Total Kg de residuos especiales y peligrosos  entregados a los gestores ambientales para disposición final","MENSUAL",null,"Gestionar el 55% de los residuos RESPEL y RAEES generados","N.A.",null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(H14+J14+L14+N14)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q14+S14+U14+W14)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Z14+AB14+AD14+AF14)","v":0},{"$f":"+IFERROR(SUM(P14+Y14+AH14)/SUM(P15+Y15+AH15),0)","v":0},{"$f":"+IF(AI14>=E14,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"META CUMPLIDA"}]
[null,null,"Total Kg de residuos especiales y peligrosos generados ",null,null,null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(H15+J15+L15+N15)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q15+S15+U15+W15)","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Z15+AB15+AD15+AF15)","v":0}]
["CONSUMO PAPEL","Implementar medidas que propendan por el ahorro y uso racional de los recursos agua, energía y papel\n\nNota: tener presente que agua y energía hacen parte del tablero de control.","Meta Anual de resmas de papel definida para la Regional y Centros Zonales - Número de resmas de papel consumidas en la vigencia evaluado","MENSUAL",null,"Disminuir una resma de papel por cada centro zonal y regional que haga parte de la linea base. ",null,null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+H16+J16+L16+N16","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+Q16+S16+U16+W16","v":0},null,"N.A.",null,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+Z16+AB16+AD16+AF16","v":0},{"$f":"+SUM(P16,Y16,AH16)","v":0},{"$f":"+IF(AI16<=E16,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"META CUMPLIDA"}]
[]
["¡Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA.\nLOS DATOS PROPORCIONADOS SERÁN TRATADOS DE ACUERDO A LA POLÍTICA DE TRATAMIENTO DE DATOS PERSONALES DEL ICBF Y A LA LEY 1581 DE 2012."]