{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instrucciones para dilegenciar","PLAN_DE_GESTION","RECURSOS GESTION AMBIENTAL","Hoja1","IND AMBIENTALES"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"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 dilegenciar","index":0,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":false,"merged":[[28,2,28,10],[30,2,30,10],[1,2,1,7],[2,2,2,7],[39,1,40,11],[0,2,0,7],[4,1,4,11],[36,2,37,11],[16,2,16,10],[17,2,17,10],[18,2,18,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],[0,8,0,9],[1,8,1,9],[2,8,2,11],[0,10,0,11],[1,10,1,11],[33,2,33,10],[34,2,34,10],[31,2,31,10],[32,2,32,10],[29,2,29,10],[12,3,12,4],[6,2,6,4],[26,2,26,10],[7,3,7,4],[8,3,8,4],[10,3,10,4],[11,3,11,4],[9,3,9,4],[6,7,6,9]]}
[null,null,"PROCESO",null,null,null,null,null,"F2.P29.SA",null,"2020-03-05"]
[null,null,"SERVICIOS ADMINISTRATIVOS",null,null,null,null,null,"Versión 5",null,"Página 1 de 2"]
[null,null,"CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTION AMBIENTAL",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":"+I12/D11","v":0.22222222222222221}]
[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.22222222222222221}]
[null,null,null,null,null,null,null,"ANUAL",1,1]
[]
[]
[null,null,"RECOMENDACIONES"]
[null,null,"1. Para el mes de abril se revisará y validará las evidencias de los meses de enero, febrero y marzo."]
[null,null,"2. Los números de trabajaran con dos (2) decimas"]
[null,null,"3. Se efectuaran dos cortes semestrales, cada corte tendra un resultado y la gestión del año será la suma de los dos periodos."]
[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. Para considerar el reporte de alguna actividad, se debe presentar la justificación que soporte el motivo del no realizar el reporte oportuno."]
[null,null,"5. Se debe precisar el responsable de la actividad, no enmarcar al Referente Ambiental y al Coridnador Administrativo como unicos responsables de la implementación del cronograma de gestión ambiental"]
[null,null,"6. Si la actividad tiene una frecuencia Anual y en caso de desarrollarse mas de dos veces, se debe realizar un solo reporte y realizar el registro de las dos fechas."]
[null,null,"7. Se debe realizar el diligenciamiento de la columna denominada \"DESCRIPCION DE ACTIVIDADES\", con un breve resumen de la gestion realizada mes a mes.\nEjemplo:\nAbril: Jornada de socializaicon de clausulas 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 los programas del PGA formulado, en este caso es necesario tener presenta las formulas y si es necesario arrastrar las celdas para garantizar que la formulación quede registrado 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 contanga 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,"INDICES DE DESEMPEÑO"]
[null,null,"1. La meta de los indices de desempeño se definiran 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 indice 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 indice 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 energia no estan incluidos dentro del los indices 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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ABRIL ","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,"MENSUAL "]
[null,"BIMENSUAL "]
[null,"TIRMESTRAL"]

{"sheet":"PLAN_DE_GESTION","index":1,"n_rows":364,"n_cols":115,"rows_kept":364,"cut":false,"hidden":false,"merged":[[11,37,11,39],[11,54,13,54],[3,0,3,54],[10,8,10,28],[10,31,10,45],[7,3,7,6],[5,4,5,6],[6,4,6,6],[7,29,7,30],[10,29,13,29],[10,30,13,30],[7,46,7,47],[10,46,13,46],[10,47,13,47],[10,50,13,50],[10,48,13,48],[7,26,7,28],[7,31,7,33],[12,36,13,36],[7,34,7,36],[7,37,7,39],[7,40,7,42],[7,43,7,45],[12,31,13,31],[12,32,13,32],[12,43,13,43],[12,35,13,35],[12,42,13,42],[12,45,13,45],[12,41,13,41],[12,37,13,37],[14,51,17,51],[18,51,21,51],[92,1,93,11],[67,26,67,53],[63,15,63,16],[64,15,64,16],[67,12,67,13],[67,15,67,16],[12,33,13,33],[12,34,13,34],[79,1,79,9],[80,1,80,9],[34,1,37,1],[38,1,41,1],[76,1,76,9],[77,1,77,9],[71,2,71,4],[50,1,53,1],[11,23,11,25],[12,24,13,24],[12,22,13,22],[58,20,58,21],[12,23,13,23],[68,15,68,16],[58,15,58,16],[57,1,57,17],[59,10,59,11],[59,15,59,16],[59,12,59,13],[61,10,61,11],[62,10,62,11],[63,10,63,11],[64,10,64,11],[65,10,65,11],[67,10,67,11],[68,10,68,11],[65,12,65,13],[66,12,66,13],[68,12,68,13],[12,25,13,25],[11,20,11,22],[66,15,66,16],[65,15,65,16],[61,15,61,16],[62,15,62,16],[63,12,63,13],[63,20,63,21],[64,20,64,21],[11,11,11,13],[60,12,60,13],[60,15,60,16],[65,20,65,21],[66,20,66,21],[11,8,11,10],[46,0,49,0],[50,0,53,0],[18,1,21,1],[66,10,66,11],[60,10,60,11],[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,1,17,1],[30,1,33,1],[59,26,59,53],[63,26,63,53],[58,26,58,53],[11,40,11,42],[11,43,11,45],[12,40,13,40],[12,44,13,44],[12,38,13,38],[11,31,11,33],[11,34,11,36],[42,52,45,52],[46,52,49,52],[34,52,37,52],[50,52,53,52],[26,52,29,52],[22,52,25,52],[30,52,33,52],[42,51,45,51],[50,51,53,51],[46,51,49,51],[38,51,41,51],[22,51,25,51],[38,52,41,52],[26,51,29,51],[30,51,33,51],[34,51,37,51],[12,20,13,20],[58,12,58,13],[57,20,57,23],[67,20,67,21],[68,20,68,21],[64,12,64,13],[61,12,61,13],[62,12,62,13],[58,22,58,23],[12,14,13,14],[14,52,17,52],[12,39,13,39],[12,26,13,26],[18,52,21,52],[11,51,13,51],[12,52,13,52],[10,49,13,49],[12,28,13,28],[11,52,11,53],[12,53,13,53],[69,20,69,21],[59,22,59,23],[60,22,60,23],[61,22,61,23],[62,22,62,23],[63,22,63,23],[64,22,64,23],[65,22,65,23],[66,22,66,23],[67,22,67,23],[68,22,68,23],[59,20,59,21],[60,20,60,21],[61,20,61,21],[62,20,62,21],[69,12,69,13],[69,15,69,16],[12,15,13,15],[12,16,13,16],[12,17,13,17],[12,18,13,18],[11,14,11,16],[11,17,11,19],[14,0,17,0],[18,0,21,0],[58,10,58,11],[12,9,13,9],[12,8,13,8],[22,1,25,1],[26,1,29,1],[12,6,12,7],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,11,13,11],[69,10,69,11],[12,10,13,10],[12,19,13,19],[12,1,13,1],[11,0,11,7],[12,12,13,12],[12,13,13,13],[12,21,13,21],[0,27,0,28],[0,29,0,30],[1,27,1,28],[1,29,1,30],[2,27,2,30],[7,8,7,10],[7,11,7,13],[7,14,7,16],[7,17,7,19],[7,20,7,22],[0,2,0,26],[1,2,1,26],[7,23,7,25],[2,2,2,26],[12,0,13,0],[12,2,13,2],[11,26,11,28],[12,27,13,27]]}
[null,null,"PROCESO",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,"2020-03-05"]
[null,null,"SERVICIOS ADMINISTRATIVOS",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 5",null,"Página 1 de 6"]
[null,null,"CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTION 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,"Clasificación de la Información:\nPública"]
[]
[]
[null,null,null,"1, Regional","SEDE DE LA DIRECCION GENERAL"]
[null,null,null,"2. Vigencia"]
[null,null,null,"3. Fecha de Corte",null,null,null,null,"2020-01-30",null,null,"2020-02-28",null,null,"2020-03-30",null,null,"2020-04-30",null,null,"2020-05-30",null,null,"2020-06-30",null,null,"2020-07-30",null,null,"GESTIÓN PRIMER SEMESTRE",null,"2020-08-30",null,null,"2020-09-30",null,null,"2020-10-30",null,null,"2020-11-30",null,null,"2020-12-30",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,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,"ENERO ",null,null,"FEBRERO",null,null,"MARZO",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","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},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(U15>0,\"C\",IF($U$8<G15,0,IF($U$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(U15=0,0,IF($G$13>=U15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(X15>0,\"C\",IF($X$8<G15,0,IF($X$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(X15=0,0,IF($G$13>=X15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AA15>0,\"C\",IF($AA$8<G15,0,IF($AA$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AA15=0,0,IF($G$13>=AA15,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(R15:AC15,\"CC\")","v":0},{"$f":"+IFERROR(AX15*AD15,0)","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},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AL15>0,\"C\",IF($AL$8<G15,0,IF($AL$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AL15=0,0,IF($G$13>=AL15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AO15>0,\"C\",IF($AO$8<G15,0,IF($AO$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AO15=0,0,IF($G$13>=AO15,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D15=0,0,IF(G15=0,0,IF(H15=0,0,IF(AR15>0,\"C\",IF($AR$8<G15,0,IF($AR$8>H15,\"V\",\"E\"))))))","v":0},{"$f":"IF(AR15=0,0,IF($G$13>=AR15,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(AF15:AT15,\"CC\")","v":0},{"$f":"+IFERROR(AX15*AU15,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/AW15,0)","v":0},{"$f":"+AE15+AV15","v":0},{"$f":"+IFERROR(SUM(AY15:AY18),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,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(L16>0,\"C\",IF($L$8<G16,0,IF($L$8>H16,\"V\",\"E\"))))))","v":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},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(U16>0,\"C\",IF($U$8<G16,0,IF($U$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(U16=0,0,IF($G$13>=U16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(X16>0,\"C\",IF($X$8<G16,0,IF($X$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(X16=0,0,IF($G$13>=X16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AA16>0,\"C\",IF($AA$8<G16,0,IF($AA$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AA16=0,0,IF($G$13>=AA16,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(R16:AC16,\"CC\")","v":0},{"$f":"+IFERROR(AX16*AD16,0)","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},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AL16>0,\"C\",IF($AL$8<G16,0,IF($AL$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AL16=0,0,IF($G$13>=AL16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AO16>0,\"C\",IF($AO$8<G16,0,IF($AO$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AO16=0,0,IF($G$13>=AO16,\"CC\",\"E\"))","v":0},null,{"$f":"IF(D16=0,0,IF(G16=0,0,IF(H16=0,0,IF(AR16>0,\"C\",IF($AR$8<G16,0,IF($AR$8>H16,\"V\",\"E\"))))))","v":0},{"$f":"IF(AR16=0,0,IF($G$13>=AR16,\"CC\",\"E\"))","v":0},{"$f":"+COUNTIF(AF16:AT16,\"CC\")","v":0},{"$f":"+IFERROR(AX16*AU16,0)","v":0},{"$f":"+IF(F16=\"MENSUAL\",9,IF(F16=\"BIMESTRAL\",4,IF(F16=\"TRIMESTRAL\",3,IF(F16=\"CUATRIMESTRAL\",2,IF(F16=\"SEMESTRAL\",2,IF(F16=\"ANUAL\",1,0))))))","v":0},{"$f":"IFERROR(1/AW16,0)","v":0},{"$f":"+AE16+AV16","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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(AY19:AY22),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,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(AY23:AY26),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,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(AY27:AY30),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,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(AY31:AY34),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,"GESTION AMBIENTAL CONTRACTUAL ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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(AY35:AY38),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,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(AY39:AY42),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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]
[8,"CALIDAD DEL AIRE (AIRE - RUIDO -PEV) ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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(AY43:AY46),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,"SITUACIONES DE EMERGENCIA AMBIENTAL",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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(AY47:AY50),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,"PROCESO CONTRACTUAL ",null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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(AY51:AY54),0)","v":0}]
[null,null,null,null,null,null,null,null,null,0,0,null,0,0,null,0,0,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,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,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,"CUADRO RESUMEN ACTIVIDADES CUMPLIDAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN GENERAL"]
[null,"Programa del PGA","Número Actividades","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO",null,"SEPTIEMBRE",null,"OCTUBRE","NOVIEMBRE ",null,"DICIEMBRE",null,null,"ACUMULADO GENERAL",null,"Avance por programa",null,null,null,"Logros Periodicos"]
[null,"Programa No. 1",{"$f":"COUNTA(C15:C18)","v":0},{"$f":"COUNTIF(K15:K18,\"CC\")","v":0},{"$f":"COUNTIF(N15:N18,\"CC\")","v":0},{"$f":"COUNTIF(Q15:Q18,\"CC\")","v":0},{"$f":"COUNTIF(T15:T18,\"CC\")","v":0},{"$f":"COUNTIF(W15:W18,\"CC\")","v":0},{"$f":"COUNTIF(Z15:Z18,\"cC\")","v":0},{"$f":"COUNTIF(AC15:AC18,\"Cc\")","v":0},{"$f":"COUNTIF(AH15:AH18,\"Cc\")","v":0},null,{"$f":"COUNTIF(AK15:AK18,\"CC\")","v":0},null,{"$f":"COUNTIF(AM15:AM18,\"CC\")","v":0},{"$f":"COUNTIF(AQ15:AQ18,\"CC\")","v":0},null,{"$f":"COUNTIF(AT15:AT18,\"CC\")","v":0},null,null,{"$f":"+AZ15","v":0},null,{"$f":"IFERROR(U60/C60,0)","v":0},null,null,null,"I PERIODO DE MARZO A JUNIO"]
[null,"Programa No. 2",{"$f":"COUNTA(C19:C22)","v":0},{"$f":"COUNTIF(K19:K22,\"C\")","v":0},{"$f":"COUNTIF(N19:N22,\"CC\")","v":0},{"$f":"COUNTIF(Q19:Q22,\"CC\")","v":0},{"$f":"COUNTIF(T19:T22,\"CC\")","v":0},{"$f":"COUNTIF(W19:W22,\"CC\")","v":0},{"$f":"COUNTIF(Z19:Z22,\"cC\")","v":0},{"$f":"COUNTIF(AC19:AC22,\"cC\")","v":0},{"$f":"COUNTIF(AH19:AH22,\"cC\")","v":0},null,{"$f":"COUNTIF(AK19:AK22,\"CC\")","v":0},{"$f":"COUNTIF(V19:V22,\"C\")","v":0},{"$f":"COUNTIF(AM19:AM22,\"CC\")","v":0},{"$f":"COUNTIF(AQ19:AQ22,\"CC\")","v":0},{"$f":"COUNTIF(Y19:Y22,\"C\")","v":0},{"$f":"COUNTIF(AT19:AT22,\"CC\")","v":0},null,null,{"$f":"+AZ19","v":0},null,{"$f":"IFERROR(U61/C61,0)","v":0}]
[null,"Programa No. 3",{"$f":"COUNTA(C23:C26)","v":0},{"$f":"COUNTIF(K23:K26,\"CC\")","v":0},{"$f":"COUNTIF(N23:N26,\"Cc\")","v":0},{"$f":"COUNTIF(Q23:Q26,\"CC\")","v":0},{"$f":"COUNTIF(T23:T26,\"CC\")","v":0},{"$f":"COUNTIF(W23:W26,\"CC\")","v":0},{"$f":"COUNTIF(Z23:Z26,\"Cc\")","v":0},{"$f":"COUNTIF(AC23:AC26,\"cC\")","v":0},{"$f":"COUNTIF(AH23:AH26,\"cC\")","v":0},null,{"$f":"COUNTIF(AK23:AK26,\"CC\")","v":0},{"$f":"COUNTIF(V23:V26,\"C\")","v":0},{"$f":"COUNTIF(AM23:AM26,\"CC\")","v":0},{"$f":"COUNTIF(AQ23:AQ26,\"CC\")","v":0},{"$f":"COUNTIF(Y23:Y26,\"C\")","v":0},{"$f":"COUNTIF(AT23:AT26,\"CC\")","v":0},null,null,{"$f":"+AZ23","v":0},null,0]
[null,"Programa No. 4",{"$f":"COUNTA(C27:C30)","v":0},{"$f":"COUNTIF(K27:K30,\"CC\")","v":0},{"$f":"COUNTIF(N27:N30,\"CC\")","v":0},{"$f":"COUNTIF(Q27:Q30,\"CC\")","v":0},{"$f":"COUNTIF(T27:T30,\"CC\")","v":0},{"$f":"COUNTIF(W27:W30,\"CC\")","v":0},{"$f":"COUNTIF(Z27:Z30,\"Cc\")","v":0},{"$f":"COUNTIF(AC27:AC30,\"cC\")","v":0},{"$f":"COUNTIF(AH27:AH30,\"cC\")","v":0},null,{"$f":"COUNTIF(AK27:AK30,\"CC\")","v":0},{"$f":"COUNTIF(V27:V30,\"C\")","v":0},{"$f":"COUNTIF(AM27:AM30,\"CC\")","v":0},{"$f":"COUNTIF(AQ27:AQ30,\"CC\")","v":0},{"$f":"COUNTIF(Y27:Y30,\"C\")","v":0},{"$f":"COUNTIF(AT27:AT30,\"CC\")","v":0},null,null,{"$f":"+AZ27","v":0},null,0]
[null,"Programa No. 5",{"$f":"COUNTA(C31:C34)","v":0},{"$f":"COUNTIF(K31:K34,\"CC\")","v":0},{"$f":"COUNTIF(N31:N34,\"CC\")","v":0},{"$f":"COUNTIF(Q31:Q34,\"CC\")","v":0},{"$f":"COUNTIF(T31:T34,\"CC\")","v":0},{"$f":"COUNTIF(W31:W34,\"CC\")","v":0},{"$f":"COUNTIF(Z31:Z34,\"cC\")","v":0},{"$f":"COUNTIF(AC31:AC34,\"cC\")","v":0},{"$f":"COUNTIF(AH31:AH34,\"cC\")","v":0},null,{"$f":"COUNTIF(AK31:AK34,\"CC\")","v":0},{"$f":"COUNTIF(V31:V34,\"C\")","v":0},{"$f":"COUNTIF(AM31:AM34,\"CC\")","v":0},{"$f":"COUNTIF(AQ31:AQ34,\"CC\")","v":0},{"$f":"COUNTIF(Y31:Y34,\"C\")","v":0},{"$f":"COUNTIF(AT31:AT34,\"CC\")","v":0},null,null,{"$f":"+AZ31","v":0},null,0,null,null,null,"II PERIODO DE JULIO A SEPTIEMBRE"]
[null,"Programa No. 6",{"$f":"COUNTA(C35:C38)","v":0},{"$f":"COUNTIF(K35:K38,\"CC\")","v":0},{"$f":"COUNTIF(N35:N38,\"CC\")","v":0},{"$f":"COUNTIF(Q35:Q38,\"CC\")","v":0},{"$f":"COUNTIF(T35:T38,\"CC\")","v":0},{"$f":"COUNTIF(W35:W38,\"CC\")","v":0},{"$f":"COUNTIF(Z35:Z38,\"cC\")","v":0},{"$f":"COUNTIF(AC35:AC38,\"cC\")","v":0},{"$f":"COUNTIF(AH35:AH38,\"cC\")","v":0},null,{"$f":"COUNTIF(AK35:AK38,\"CC\")","v":0},{"$f":"COUNTIF(V35:V38,\"C\")","v":0},{"$f":"COUNTIF(AM35:AM38,\"CC\")","v":0},{"$f":"COUNTIF(AQ35:AQ38,\"CC\")","v":0},{"$f":"COUNTIF(Y35:Y38,\"C\")","v":0},{"$f":"COUNTIF(AT35:AT38,\"CC\")","v":0},null,null,{"$f":"+AZ35","v":0},null,0]
[null,"Programa No. 7",{"$f":"COUNTA(C39:C42)","v":0},{"$f":"COUNTIF(K39:K42,\"CC\")","v":0},{"$f":"COUNTIF(N39:N42,\"CC\")","v":0},{"$f":"COUNTIF(Q39:Q42,\"CC\")","v":0},{"$f":"COUNTIF(T39:T42,\"CC\")","v":0},{"$f":"COUNTIF(W39:W42,\"CC\")","v":0},{"$f":"COUNTIF(Z39:Z42,\"CC\")","v":0},{"$f":"COUNTIF(AC39:AC42,\"cC\")","v":0},{"$f":"COUNTIF(AH39:AH42,\"cC\")","v":0},null,{"$f":"COUNTIF(AK39:AK42,\"CC\")","v":0},{"$f":"COUNTIF(V39:V42,\"C\")","v":0},{"$f":"COUNTIF(AM39:AM42,\"CC\")","v":0},{"$f":"COUNTIF(AQ39:AQ42,\"CC\")","v":0},{"$f":"COUNTIF(Y39:Y42,\"C\")","v":0},{"$f":"COUNTIF(AT39:AT42,\"CC\")","v":0},null,null,{"$f":"+AZ39","v":0},null,0]
[null,"Programa No. 8",{"$f":"COUNTA(C43:C46)","v":0},{"$f":"COUNTIF(K43:K46,\"CC\")","v":0},{"$f":"COUNTIF(N43:N46,\"CC\")","v":0},{"$f":"COUNTIF(Q43:Q46,\"CC\")","v":0},{"$f":"COUNTIF(T43:T46,\"CC\")","v":0},{"$f":"COUNTIF(W43:W46,\"CC\")","v":0},{"$f":"COUNTIF(Z43:Z46,\"CC\")","v":0},{"$f":"COUNTIF(AC43:AC46,\"Cc\")","v":0},{"$f":"COUNTIF(AH43:AH46,\"Cc\")","v":0},null,{"$f":"COUNTIF(AK43:AK46,\"CC\")","v":0},{"$f":"COUNTIF(V43:V46,\"C\")","v":0},{"$f":"COUNTIF(AM43:AM46,\"CC\")","v":0},{"$f":"COUNTIF(AQ43:AQ46,\"CC\")","v":0},{"$f":"COUNTIF(Y43:Y46,\"C\")","v":0},{"$f":"COUNTIF(AT43:AT46,\"CC\")","v":0},null,null,{"$f":"+AZ43","v":0},null,0]
[null,"Programa No. 9",{"$f":"COUNTA(C47:C50)","v":0},{"$f":"COUNTIF(K47:K50,\"CC\")","v":0},{"$f":"COUNTIF(N47:N50,\"CC\")","v":0},{"$f":"COUNTIF(Q47:Q50,\"CC\")","v":0},{"$f":"COUNTIF(T47:T50,\"CC\")","v":0},{"$f":"COUNTIF(W47:W50,\"CC\")","v":0},{"$f":"COUNTIF(Z47:Z50,\"CC\")","v":0},{"$f":"COUNTIF(AC47:AC50,\"Cc\")","v":0},{"$f":"COUNTIF(AH47:AH50,\"Cc\")","v":0},null,{"$f":"COUNTIF(AK47:AK50,\"CC\")","v":0},{"$f":"COUNTIF(V47:V50,\"C\")","v":0},{"$f":"COUNTIF(AN47:AN50,\"CC\")","v":0},{"$f":"COUNTIF(AQ47:AQ50,\"CC\")","v":0},{"$f":"COUNTIF(Y47:Y50,\"C\")","v":0},{"$f":"COUNTIF(AT47:AT50,\"CC\")","v":0},null,null,{"$f":"+AZ47","v":0},null,0,null,null,null,"III PERIODO DE OCTUBRE A DICIEMBRE"]
[null,"Programa No. 10",{"$f":"COUNTA(C51:C54)","v":0},{"$f":"COUNTIF(K51:K54,\"CC\")","v":0},{"$f":"COUNTIF(N51:N54,\"CC\")","v":0},{"$f":"COUNTIF(Q51:Q54,\"CC\")","v":0},{"$f":"COUNTIF(T51:T54,\"CC\")","v":0},{"$f":"COUNTIF(W51:W54,\"CC\")","v":0},{"$f":"COUNTIF(Z51:Z54,\"CC\")","v":0},{"$f":"COUNTIF(AC51:AC54,\"CC\")","v":0},{"$f":"COUNTIF(AH51:AH54,\"CC\")","v":0},null,{"$f":"COUNTIF(AK51:AK54,\"CC\")","v":0},{"$f":"COUNTIF(#REF!,\"C\")","v":{"$error":"#REF!"}},{"$f":"COUNTIF(AN51:AN54,\"CC\")","v":0},{"$f":"COUNTIF(AQ51:AQ54,\"CC\")","v":0},{"$f":"COUNTIF(#REF!,\"C\")","v":{"$error":"#REF!"}},{"$f":"COUNTIF(AT51:AT54,\"CC\")","v":0},null,null,{"$f":"+AZ51","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U60:W69)","v":0}]
[]
[null,null,"AVANCE TOTAL"]
[null,"TOTAL DE ACTIVIDADES",{"$f":"+SUM(C60:C69)","v":0},{"$f":"+U70","v":0},{"$f":"+IFERROR(D73/C73,0)","v":0}]
[]
[]
[]
[null,"OBSERVACIONES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"\n"]
[]
[]
[null,"INCLUIDO EN EL PLAN OPERATIVO POR ACTIVIDAD"]
[null,"NO ICLUIDO PERO ACTIVIDAD PUNTUAL"]
[null,"NO INCLUIDO DEPENDE DE INFORMACION DE LA SEDE NACIONAL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(VLOOKUP($DI$326,#REF!,DK326,FALSE)=0,\"\",VLOOKUP($DI$326,$BQ$330:$CT$3093,DK326,FALSE))","v":{"$error":"#REF!"}},{"$f":"+E6","v":"SEDE DE LA DIRECCION GENERAL"},{"$f":"IF(VLOOKUP($DI$326,#REF!,DK326,FALSE)=0,\"\",VLOOKUP($DI$326,#REF!,DK326,FALSE))","v":{"$error":"#REF!"}},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(VLOOKUP($DI$326,#REF!,DK327,FALSE)=0,\"\",VLOOKUP($DI$326,$BQ$330:$CT$3093,DK327,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(VLOOKUP($DI$326,#REF!,DK327,FALSE)=0,\"\",VLOOKUP($DI$326,#REF!,DK327,FALSE))","v":{"$error":"#REF!"}},3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(VLOOKUP($DI$326,#REF!,DK328,FALSE)=0,\"\",VLOOKUP($DI$326,$BQ$330:$CT$3093,DK328,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(VLOOKUP($DI$326,#REF!,DK328,FALSE)=0,\"\",VLOOKUP($DI$326,#REF!,DK328,FALSE))","v":{"$error":"#REF!"}},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(VLOOKUP($DI$326,#REF!,DK329,FALSE)=0,\"\",VLOOKUP($DI$326,$BQ$330:$CT$3093,DK329,FALSE))","v":{"$error":"#REF!"}},null,{"$f":"IF(VLOOKUP($DI$326,#REF!,DK329,FALSE)=0,\"\",VLOOKUP($DI$326,#REF!,DK329,FALSE))","v":{"$error":"#REF!"}},5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMAZONAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANTIOQUIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,"BOGOTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOLIVAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOYACA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,null,null,null,null,null,null,null,null,null,"CHOCO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,"VICHADA"]

{"sheet":"RECURSOS GESTION AMBIENTAL","index":2,"n_rows":28,"n_cols":31,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,28,11],[24,0,24,8],[25,0,25,8],[25,10,25,21],[12,10,12,21],[12,4,12,9],[12,3,13,3],[12,0,13,0],[12,2,13,2],[12,1,13,1],[12,24,13,24],[12,22,12,23],[4,6,4,8],[4,11,4,14],[2,2,2,20],[0,2,0,20],[1,2,1,20],[5,6,6,7],[5,8,6,8],[4,10,5,10],[0,21,0,22],[0,23,0,24],[1,21,1,22],[1,23,1,24],[2,21,2,24]]}
[null,null,"PROCESO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F2.P29.SA",null,"2020-03-05"]
[null,null,"SERVICIOS ADMINISTRATIVOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión 5",null,"Página 1 de 2"]
[null,null,"CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTION AMBIENTAL",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,"ASIGNACION PRESUPUESTAL\n(Apropiación Inicial)",null,null,null,"% de Ejecución del Mes ",null,null,null,"ESTADO ","% de Cumplimiento",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"OPTIMO",0.95,1]
[null,null,"ADICIONES",null,null,null,"% de Ejecución",null,{"$f":"+D8/D7","v":{"$error":"#DIV/0!"}},null,null,"Agosto ","Septiembre","Octubre","Noviembre",null,null,null,null,null,null,null,null,null,null,null,null,5,"RIESGO",0.90100000000000002,0.94899999999999995]
[null,null,"TOTAL APROPIACION VIGENTE",{"$f":"+(D6+D5)-D10","v":0},null,null,null,null,null,null,"OPTIMO","85% - 100%","90% - 100%",1,1,null,null,null,null,null,null,null,null,null,null,null,null,4,"RIESGO",0.85,0.9]
[null,null,"VALOR CONTRATOS",{"$f":"+J25","v":0},null,null,null,null,null,null,"ADECUADO ","75% - 84,9%","80% - 89,9%","85% - 99,9%","85% - 99,9%",null,null,null,null,null,null,null,null,null,null,null,null,3,"CRITICO",0.35010000000000002,0.84899999999999998]
[null,null,"SALDO",{"$f":"+(D5-D8)","v":0},null,null,null,null,null,null,"RIESGO","50% - 74,9%","60% - 79,9%","80% - 84,9%","80% - 84,9%"]
[null,null,"LIBERACIÓN",null,null,null,null,null,null,null,"CRITICO","0 - 49,9%","0-59,9%","0% - 79,9%","0% - 79,9%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"CRITICO",0,0.35]
["ITEM","PROGRAMA DEL PGA","DESCRIPCION DE ELEMENTOS","Asignación Presupuestal\nSegún Plan de Compras","DESCRIPCION DE LA CONTRATACIÓN",null,null,null,null,null,"PAGOS EJECUTADOS",null,null,null,null,null,null,null,null,null,null,null,"RESUMEN DE EJECUCIÓN",null,"Análisis y Observaciones"]
[null,null,null,null,"Objeto","Convenio /Contrato No","   Fecha Inicio","   Fecha Terminacion","TIEMPO DE EJECUCION\n(MESES)","VALOR  COMPRA  ($)","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","TOTAL DE PAGOS","SALDO POR PAGAR"]
[1,null,null,null,null,null,null,null,{"$f":"DATEDIF(G15,H15,\"M\")","v":0},null,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K15:V15)","v":0},{"$f":"+J15-W15","v":0}]
[2,null,null,null,null,null,null,null,{"$f":"DATEDIF(G16,H16,\"M\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K16:V16)","v":0},0]
[3,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K17:V17)","v":0},0]
[4,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K21:V21)","v":0},0]
[8,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K22:V22)","v":0},0]
[9,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(K23:V23)","v":0},0]
[10,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["TOTALES",null,null,null,null,null,null,null,null,{"$f":"+SUM(J14:J24)","v":0},{"$f":"+SUM(K15:K24)","v":0},{"$f":"+SUM(L15:L24)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(K25:V25)","v":0}]
["LIBERACION DE RECURSOS\nFecha de Devolución (dia/mes/año) ",null,null,null,null,null,null,null,null,{"$f":"+D10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(W15:W24)","v":0},{"$f":"+SUM(X15:X24)","v":0}]
[]
[null,"Antes de imprimir este documento… piense en el medio ambiente!\nCualquier copia impresa de este documento se considera como COPIA NO CONTROLADA."]

{"sheet":"Hoja1","index":3,"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":"IND AMBIENTALES","index":4,"n_rows":18,"n_cols":36,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,33,8,33],[7,34,8,34],[7,35,8,35],[7,0,10,0],[7,24,8,24],[7,26,8,26],[7,28,8,28],[7,30,8,30],[7,32,8,32],[7,1,8,1],[7,3,8,3],[7,4,8,4],[7,5,8,5],[9,35,10,35],[9,8,10,8],[9,10,10,10],[13,4,14,4],[13,5,14,5],[13,34,14,34],[15,34,16,34],[15,22,16,22],[15,25,16,25],[15,27,16,27],[15,29,16,29],[11,35,12,35],[13,35,14,35],[15,35,16,35],[17,0,18,11],[15,0,16,0],[15,1,16,1],[15,3,16,3],[15,4,16,4],[15,5,16,5],[11,0,14,0],[11,1,12,1],[11,3,12,3],[11,4,12,4],[11,5,12,5],[13,1,14,1],[13,3,14,3],[7,19,8,19],[7,21,8,21],[7,23,8,23],[9,6,10,6],[4,0,5,1],[4,3,4,11],[5,3,5,11],[5,12,5,13],[9,12,10,12],[9,14,10,14],[9,3,10,3],[7,10,8,10],[7,12,8,12],[7,14,8,14],[7,15,8,15],[7,17,8,17],[9,1,10,1],[9,4,10,4],[9,5,10,5],[7,6,8,6],[7,8,8,8],[3,0,3,35],[5,14,5,27],[4,14,4,27],[4,12,4,13],[0,2,0,31],[1,2,1,31],[2,2,2,31],[9,24,10,24],[9,33,10,33],[9,32,10,32],[9,17,10,17],[9,30,10,30],[9,19,10,19],[9,21,10,21],[9,23,10,23],[9,26,10,26],[9,28,10,28],[2,32,2,35],[0,32,0,33],[0,34,0,35],[1,32,1,33],[1,34,1,35],[15,31,16,31],[9,34,10,34],[15,24,16,24],[15,33,16,33],[15,2,16,2],[15,16,16,16],[15,18,16,18],[15,20,16,20],[15,7,16,7],[15,9,16,9],[15,11,16,11],[15,13,16,13],[15,6,16,6],[15,15,16,15],[11,34,12,34],[9,15,10,15]]}
[null,null,"PROCESO",null,null,null,null,null,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,"2020-03-05"]
[null,null,"SERVICIOS ADMINISTRATIVOS",null,null,null,null,null,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 5",null,"Página 1 de 2"]
[null,null,"CRONOGRAMA DE EJECUCIÓN DEL PLAN DE GESTION 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,"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. Este dato se actualizará automaticamente en los espacios de cada uno de los meses asociados al denominador.\n2. En la columna de denominada \"Resultado I 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ÓLIDO\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,"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 2019 para determinar el consumo cuatrimestral y de estos tres datos tomar el valor máximo, 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 mayor o igual a la línea base."]
["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",0.15,"Sensibilizar como mínimo el porcentaje de colaboradores propuestos en la meta ",1579,25,{"$f":"+IFERROR(H8/H9,0)","v":1.5832805573147563E-2},0,{"$f":"+IFERROR(J8/J9,0)","v":0},220,{"$f":"+IFERROR(L8/L9,0)","v":0.13932868904369855},0,{"$f":"+IFERROR(N8/N9,0)","v":0},{"$f":"+I8+K8+M8+O8","v":0.15516149461684611},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":"+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":"+AA8+AC8+AE8+AG8","v":0},{"$f":"AVERAGE(P8,Y8,AH8)","v":5.1720498205615369E-2},{"$f":"+IF(AI8>=E8,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"NO CUMPLE"}]
[null,null,"Promedio de colaboradores de la vigencia anterior",null,null,null,null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579},null,{"$f":"+G8","v":1579}]
[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",0.25,"Sensibilizar como mínimo el porcentaje de colaboradores propuestos en la meta ",130,0,{"$f":"+IFERROR(H10/H11,0)","v":0},26,{"$f":"+IFERROR(J10/J11,0)","v":0.2},90,{"$f":"+IFERROR(L10/L11,0)","v":0.69230769230769229},78,{"$f":"+IFERROR(N10/N11,0)","v":0.6},{"$f":"+AVERAGE(I10,K10,M10,O10)","v":0.37307692307692308},13,{"$f":"+IFERROR(Q10/Q11,0)","v":0.1},40,{"$f":"+IFERROR(S10/S11,0)","v":0.30769230769230771},12,{"$f":"+IFERROR(U10/U11,0)","v":9.2307692307692313E-2},98,{"$f":"+IFERROR(W10/W11,0)","v":0.75384615384615383},{"$f":"+AVERAGE(R10,T10,V10,X10)","v":0.31346153846153846},12,{"$f":"+IFERROR(Z10/Z11,0)","v":9.2307692307692313E-2},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":"+AVERAGE(AA10,AC10,AE10,AG10)","v":2.3076923076923078E-2},{"$f":"+AVERAGE(P10,Y10,AH10)","v":0.23653846153846156},{"$f":"+IF(AI10>=E10,\"META CUMPLIDA\",\"NO CUMPLE\")","v":"NO CUMPLE"}]
[null,null,"Promedio de colaboradores de la vigencia anterior",null,null,null,null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130},null,{"$f":"+G10","v":130}]
["MANEJO DE RESIDUOS SÓLIDOS ","Disminuir la cantidad de residuos entregados a la empresa de servicios públicos de aseo, mediante estrategias de separación en la fuente y aprovechamiento de estos.","Total kg de residuos sólidos aprovechados entregados al gestor","MENSUAL",0.2,"Gestionar como mínimo el porcentaje de residuos aprovechables propuestos en la meta","N.A.",0,"N.A.",0,"N.A.",1200.8,"N.A.",0,"N.A.",{"$f":"+SUM(H12+J12+L12+N12)","v":1200.8},5,"N.A.",599.20000000000005,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q12+S12+U12+W12)","v":604.20000000000005},2074,"N.A.",null,"N.A.",null,"N.A.",399.69,"N.A.",{"$f":"+SUM(Z12+AB12+AD12+AF12)","v":2473.69},{"$f":"+IFERROR(SUM(P12+Y12+AH12)/SUM(P13+Y13+AH13),0)","v":0.40246387063033096},{"$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.",750,"N.A.",0,"N.A.",2360.8200000000002,"N.A.",0,"N.A.",{"$f":"+SUM(H13+J13+L13+N13)","v":3110.82},5,"N.A.",1630.4,"N.A.",null,"N.A.",null,"N.A.",{"$f":"+SUM(Q13+S13+U13+W13)","v":1635.4},4096,"N.A.",null,"N.A.",null,"N.A.",1789.02,"N.A.",{"$f":"+SUM(Z13+AB13+AD13+AF13)","v":5885.02}]
[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",0.55000000000000004,"Gestionar el 100% de los residuos RESPEL y RAEES generados","N.A.",0,"N.A.",644,"N.A.",197.4,"N.A.",41,"N.A.",{"$f":"+SUM(H14+J14+L14+N14)","v":882.4},40.700000000000003,"N.A.",114.7,"N.A.",4,"N.A.",53,"N.A.",{"$f":"+SUM(Q14+S14+U14+W14)","v":212.4},52,"N.A.",0,"N.A.",10,"N.A.",8,"N.A.",{"$f":"+SUM(Z14+AB14+AD14+AF14)","v":70},{"$f":"+SUM(P14+Y14+AH14)/SUM(P15+Y15+AH15)","v":0.65434526150216277},{"$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.",644,"N.A.",0,"N.A.",841.4,"N.A.",0,"N.A.",{"$f":"+SUM(H15+J15+L15+N15)","v":1485.4},0,"N.A.",114.7,"N.A.",0,"N.A.",0,"N.A.",{"$f":"+SUM(Q15+S15+U15+W15)","v":114.7},0,"N.A.",80,"N.A.",50,"N.A.",50,"N.A.",{"$f":"+SUM(Z15+AB15+AD15+AF15)","v":180}]
["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.","Línea base de resmas de papel definida para la Regional y Centros Zonales - Número de resmas de papel consumidas en el cuatrimestre evaluado","MENSUAL",{"$f":"+G16-3","v":2853},"Consumir 3 resmas de papel menos de la línea base determinada con la información de la vigencia 2019.",2856,397,"N.A.",567,"N.A.",49,"N.A.",693,"N.A.",{"$f":"+H16+J16+L16+N16","v":1706},0,"N.A.",0,"N.A.",0,"N.A.",512,"N.A.",{"$f":"+Q16+S16+U16+W16","v":512},420,"N.A.",150,"N.A.",0,"N.A.",50,"N.A.",{"$f":"+Z16+AB16+AD16+AF16","v":620},{"$f":"+P16+Y16+AH16","v":2838},{"$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."]