{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Información General","Matriz"," Mapa de Riesgos","PTAR 2025"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Información General","index":0,"n_rows":118,"n_cols":13,"rows_kept":118,"cut":false,"hidden":false,"merged":[[20,2,20,5],[18,6,18,9],[20,6,20,9],[13,3,13,4],[9,2,9,3],[16,6,16,9],[16,2,16,5],[18,2,18,5],[14,5,14,6],[13,5,13,6],[14,7,14,8],[13,7,13,8],[14,9,14,11],[13,9,13,11],[6,2,7,3],[9,4,9,9],[11,2,11,3],[11,4,11,9],[6,4,7,9]]}
[]
[]
[]
[]
[]
[]
[null,null,"DEPENDENCIA",null,"NOMBRE DE LA DEPENDENCIA O ENTIDAD PÚBLICA"]
[]
[null,null," "]
[null,null,"SUPERIOR JERÁRQUICO ",null,"NOMBRE DEL TITULAR DE LA DEPENDENCIA O ENTIDAD PÚBLICA"]
[]
[null,null,"UNIDAD RESPONSABLE DEL PROCESO",null,"NOMBRE DE LA UNIDAD RESPONSABLE DEL PROCESO"]
[]
[null,null,"AÑO:",2024]
[]
[]
[null,null,"COORDINADOR DE CONTROL INTERNO",null,null,null,"NOMBRE DEL COORDINADOR DE CONTROL INTERNO"]
[]
[null,null,"TITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO",null,null,null,"NOMBRE DEL TITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO"]
[]
[null,null,"  ENLACE DE ADMINISTRACIÓN DE RIESGOS",null,null,null,"NOMBRE DEL ENLACE DE ADMINISTRACIÓN DE RIESGOS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ramo / Sector"]
[null,null,null,null,null,null,null,null,null,null,null,null,"04 Gobernación"]
[null,null,null,null,null,null,null,null,null,null,null,null,"05 Relaciones Exteriores"]
[null,null,null,null,null,null,null,null,null,null,null,null,"06 Hacienda y Crédito Público"]
[null,null,null,null,null,null,null,null,null,null,null,null,"07 Defensa Nacional"]
[null,null,null,null,null,null,null,null,null,null,null,null,"08 Agricultura, Ganadería, Desarrollo Rural, Pesca y Alimentación"]
[null,null,null,null,null,null,null,null,null,null,null,null,"09 Comunicaciones y Transportes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"10 Economía"]
[null,null,null,null,null,null,null,null,null,null,null,null,"11 Educación Pública"]
[null,null,null,null,null,null,null,null,null,null,null,null,"12 Salud"]
[null,null,null,null,null,null,null,null,null,null,null,null,"13 Marina"]
[null,null,null,null,null,null,null,null,null,null,null,null,"14 Trabajo y Previsión Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,"15 Reforma Agraria"]
[null,null,null,null,null,null,null,null,null,null,null,null,"16 Medio Ambiente y Recursos Naturales"]
[null,null,null,null,null,null,null,null,null,null,null,null,"17 Procuraduría General de la República"]
[null,null,null,null,null,null,null,null,null,null,null,null,"18 Energía"]
[null,null,null,null,null,null,null,null,null,null,null,null,"20 Desarrollo Social"]
[null,null,null,null,null,null,null,null,null,null,null,null,"21 Turismo"]
[null,null,null,null,null,null,null,null,null,null,null,null,"27 Función Pública"]
[null,null,null,null,null,null,null,null,null,null,null,null,"37 Consejería Jurídica del Ejecutivo Federal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"38 Ciencia y Tecnología"]
[null,null,null,null,null,null,null,null,null,null,null,null,"48 Cultura"]
[null,null,null,null,null,null,null,null,null,null,null,null,"48 Cultura"]

{"sheet":"Matriz","index":1,"n_rows":54,"n_cols":45,"rows_kept":54,"cut":false,"hidden":false,"merged":[[49,1,50,2],[49,19,50,21],[17,5,17,43],[20,5,20,43],[44,19,44,21],[46,7,46,9],[44,6,44,7],[44,9,44,10],[49,12,50,14],[44,12,44,14],[21,31,21,32],[22,31,22,32],[47,5,47,6],[49,9,50,10],[22,28,23,28],[22,16,23,16],[22,42,23,42],[24,37,28,37],[21,38,21,41],[21,16,21,28],[18,5,18,43],[19,5,19,43],[29,14,33,14],[29,15,33,15],[22,44,23,44],[24,44,28,44],[24,34,28,34],[24,33,28,33],[21,42,21,43],[22,43,23,43],[22,38,22,41],[24,7,28,7],[24,4,28,4],[22,4,23,4],[25,11,28,11],[22,8,22,11],[25,8,28,8],[25,9,28,9],[25,10,28,10],[24,12,28,12],[24,40,28,40],[24,41,28,41],[24,13,28,13],[24,14,28,14],[24,15,28,15],[24,31,28,31],[24,32,28,32],[24,38,28,38],[29,41,33,41],[22,13,22,15],[22,21,22,25],[21,0,21,15],[49,6,50,7],[25,16,28,16],[45,2,45,3],[45,6,45,7],[45,9,45,10],[22,0,23,0],[22,12,23,12],[22,6,22,7],[22,5,23,5],[22,2,22,3],[24,2,28,2],[24,0,28,0],[24,3,28,3],[24,5,28,5],[24,6,28,6],[44,1,44,2],[35,3,35,4],[22,1,23,1],[24,1,28,1],[36,3,36,4],[29,31,33,31],[29,32,33,32],[29,38,33,38],[29,39,33,39],[29,40,33,40],[49,3,50,4],[40,3,40,4],[38,3,38,4],[39,3,39,4],[37,3,37,4],[25,17,28,17],[25,42,28,42],[25,43,28,43],[25,18,28,18],[25,19,28,19],[25,20,28,20],[25,21,28,21],[25,22,28,22],[25,23,28,23],[25,24,28,24],[25,25,28,25],[25,28,28,28],[24,29,28,29],[24,30,28,30],[24,36,28,36],[24,35,28,35],[24,39,28,39],[29,0,33,0],[29,1,33,1],[29,2,33,2],[29,3,33,3],[29,4,33,4],[29,5,33,5],[29,6,33,6],[29,7,33,7],[29,29,33,29],[29,12,33,12],[29,13,33,13],[29,44,33,44],[30,8,33,8],[30,9,33,9],[30,10,33,10],[30,11,33,11],[30,16,33,16],[30,17,33,17],[30,18,33,18],[30,19,33,19],[30,20,33,20],[30,21,33,21],[30,22,33,22],[30,23,33,23],[30,24,33,24],[30,25,33,25],[30,28,33,28],[29,33,33,33],[30,43,33,43],[29,30,33,30],[29,34,33,34],[29,35,33,35],[29,36,33,36],[29,37,33,37],[30,42,33,42]]}
[]
[null,null,"Estrategia",null,null,"Estratégico","Sustantivo",null,null,null,"Humano","Interno",null,1,1,null,"SI",null,null,null,"Preventivo","SI",null,null,null,"Suficiente",null,null,null,null,null,1,1]
[null,null,"Objetivo",null,null,"Directivo","Administrativo",null,null,null,"Financiero-Presupuestal","Externo",null,2,2,null,"NO",null,null,null,"Detectivo","NO",null,null,null,"Deficiente",null,null,null,null,null,2,2,null,null,null,null,null,null,null,null,null,"EVITAR EL RIESGO",null,"EVITAR EL RIESGO"]
[null,null,"Meta",null,null,"Operativo","Legal",null,null,null,"Técnico-Administrativo",null,null,3,3,null,null,null,null,null,"Correctivo",null,null,null,null,null,null,null,null,null,null,3,3,null,null,null,null,null,null,null,null,null,"REDUCIR EL RIESGO",null,"REDUCIR EL RIESGO"]
[null,null,"Proceso",null,null,null,"Financiero",null,null,null,"TIC's",null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,"ASUMIR EL RIESGO",null,"ASUMIR EL RIESGO"]
[null,null,null,null,null,null,"Presupuestal",null,null,null,"Material",null,null,5,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,null,null,null,null,null,null,null,null,null,"TRANSFERIR EL RIESGO",null,"TRANSFERIR EL RIESGO"]
[null,null,null,null,null,null,"De servicios",null,null,null,"Normativo",null,null,6,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,null,null,null,null,null,null,null,null,null,"COMPARTIR EL RIESGO",null,"COMPARTIR EL RIESGO"]
[null,null,null,null,null,null,"De seguridad",null,null,null,"Entorno",null,null,7,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7]
[null,null,null,null,null,null,"De Obra Pública",null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8]
[null,null,null,null,null,null,"De Recursos Humanos",null,null,null,null,null,null,9,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9]
[null,null,null,null,null,null,"De Imagen ",null,null,null,null,null,null,10,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10]
[null,null,null,null,null,null,"De Tic´s"]
[null,null,null,null,null,null,"De Salud",null,{"$f":"IF(Matriz!AR25=\"\",\"\")","v":false}]
[null,null,null,null,null,null,"De Corrupción",{"$f":"IF(Matriz!J26=\"\",\"\")","v":false}]
[null,null,null,null,null,null,"Otros"]
[]
["2011-02-03"]
[null,null,null,null,null,"Matriz de Identificación, Análisis y Valoración de Riesgos"]
[null,null,null,null,null,"UNIDAD RESPONSABLE DEL PROCESO"]
[null,null,null,null,null,"Área responsable del Proceso"]
[null,null,null,null,null,"PROCESO: NOMBRE DEL PROCESO"]
["I. EVALUACIÓN RIESGOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"II. EVALUACIÓN DE CONTROLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"III. VALORACIÓN  DE RIESGOS \nVS. CONTROLES",null,null,null,null,null,null,{"$f":"+\"IV. MAPA \nDE RIESGOS    \"&'Información General'!D14","v":"IV. MAPA \nDE RIESGOS    2024"},null,null,null,"V. ESTRATEGIAS Y ACCIONES",null,"MEDIO DE VERIFICACION"]
["No. de Riesgo","Àrea Responsable del Proceso ","Alineación a Estrategias, Objetivos, \no Metas Institucionales",null,"R I E S G O","Nivel de decisión\ndel Riesgo","Clasificación del Riesgo",null,"F A C T O R",null,null,null,"Principales Impactos si se materializa el riesgo","Valoración Inicial",null,null,"¿Tiene controles?",{"$f":"SUM(R25:R29)","v":2},"C O N T R O L",null,null,"Determinación de Suficiencia o Deficiencia\ndel Control",null,null,null,null,null,null,"Riesgo\nControlado\nSuficientemente",null,null,"Valoración Final",null,null,null,null,null,null,"UBICACIÓN EN CUADRANTES",null,null,null,"Estrategia para Administrar el Riesgo","Descripción de la(s) Acción(es)","Estrategia para Administrar el Riesgo"]
[null,null,"Selección","Descripción",null,null,"Selección","Especificar Otro","No. de Factor","Descripción","Clasificación","Tipo",null,"Grado\nImpacto","Probabilidad\nOcurrencia","Cuadrante",null,{"$f":"COUNTIF(R25:R29,1)","v":2},"No.","Descripción","Tipo","Está Documentado","Está Formalizado","Se \nAplica","Es \nEfectivo","Resultado de la determinación del Control",{"$f":"SUM(AA25:AA29)","v":0},null,null,null,null,"Grado \nde Impacto","Probabilidad \nde Ocurrencia",null,null,null,null,null,"I","II","III","IV"]
[{"$f":"IF(E25<>\"\",'Información General'!$D$14&\"_\"&+$A$1+1,\"\")","v":"2024_1"},"aaa","Proceso",null,"RIESGO 1","Operativo","Administrativo",null,1.1000000000000001,"a","Humano","Interno",null,9,5,{"$f":"IF(AND(N25<>\"\",O25<>\"\"),IF(AND(N25>5,O25>5),\"I\",IF(AND(N25<=5,O25>5),\"II\",IF(AND(N25>5,O25<=5),\"IV\",IF(AND(N25<=5,O25<=5),\"III\")))),\"\")","v":"IV"},"SI",{"$f":"IF(Q25=\"SI\",1,IF(Q25=\"NO\",3,0))","v":1},"1.1.1",null,"Preventivo","SI","SI","SI","SI",{"$f":"IF($T25<>\"\",IF(AND(V25=\"SI\",W25=\"SI\",X25=\"SI\",Y25=\"SI\"),\"Suficiente\",IF(OR(V25=\"NO\",W25=\"NO\",X25=\"NO\",Y25=\"NO\"),\"Deficiente\",IF(OR(V25=\"\",W25=\"\",X25=\"\",Y25=\"\"),\"Falta Valorar el Control\",\"\"))),\"\")","v":""},{"$f":"IF(Z25=\"Suficiente\",1,0)","v":0},{"$f":"IF(Z25=\"Deficiente\",1,0)","v":0},{"$f":"IF(SUM(R25:R25)>=1,IF((SUM(R25:R25)/COUNTA(Q25:Q25))=1,IF(SUM(AA25:AA25)>=1,IF(SUM(AA25:AA25)/(SUM(AA25:AA25)+SUM(AB25:AB25))=100%,\"SI\",\"NO\"),\"NO\"),\"NO\"),\"\")","v":"NO"},{"$f":"IF($N25=1,\"b\",\"\")","v":""},{"$f":"IF($O25=1,\"b\",\"\")","v":""},3,3,{"$f":"IF(OR($AD25=\"b\",$AE25=\"b\"),2,0)","v":0},{"$f":"IF(AND($N25=1,$AF25=1,$O25=1,$AG25=1),1,0)","v":0},{"$f":"IF(AF25<>\"\",IF(AI25=1,1,IF(OR($AF25>$N25,AND($AC25=\"SI\",$AF25=$N25),AND($AC25=\"NO\",$AF25<>$N25)),0,1)),0)","v":0},{"$f":"IF(AG25<>\"\",IF(AI25=1,1,IF(OR(AG25>O25,AND(AC25=\"SI\",AG25=O25),AND(AC25=\"NO\",AG25<>O25)),0,1)),0)","v":0},{"$f":"IF(AC25<>\"\",(+AI25+AJ25+AK25),0)","v":0},{"$f":"IF(AND($AF25=\"\",$AG25=\"\"),\"\",IF(AND($AF25>5,$AG25>5),\"I\",\"\"))","v":""},{"$f":"IF(AND($AF25=\"\",$AG25=\"\"),\"\",IF(AND($AF25<6,$AG25>5),\"II\",\"\"))","v":""},{"$f":"IF(AND($AF25=\"\",$AG25=\"\"),\"\",IF(AND($AF25<6,$AG25<6),\"III\",\"\"))","v":"III"},{"$f":"IF(AND($AF25=\"\",$AG25=\"\"),\"\",IF(AND($AF25>5,$AG25<6),\"IV\",\"\"))","v":""},"EVITAR EL RIESGO","e","REDUCIR EL RIESGO"]
[null,null,null,null,null,null,null,null,1.2,"b","Humano","Interno",null,null,null,null,"SI",{"$f":"IF(Q26=\"SI\",1,IF(Q26=\"NO\",3,0))","v":1},"1.2.1",null,"Preventivo","SI","SI","SI","SI",{"$f":"IF($T26<>\"\",IF(AND(V26=\"SI\",W26=\"SI\",X26=\"SI\",Y26=\"SI\"),\"Suficiente\",IF(OR(V26=\"NO\",W26=\"NO\",X26=\"NO\",Y26=\"NO\"),\"Deficiente\",IF(OR(V26=\"\",W26=\"\",X26=\"\",Y26=\"\"),\"Falta Valorar el Control\",\"\"))),\"\")","v":""},0,0,{"$f":"IF(SUM(R26:R26)>=1,IF((SUM(R26:R26)/COUNTA(Q26:Q26))=1,IF(SUM(AA26:AA26)>=1,IF(SUM(AA26:AA26)/(SUM(AA26:AA26)+SUM(AB26:AB26))=100%,\"SI\",\"NO\"),\"NO\"),\"NO\"),\"\")","v":"NO"},null,null,null,null,null,null,null,null,null,null,null,null,null,"REDUCIR EL RIESGO","f"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[{"$f":"IF(E30<>\"\",'Información General'!$D$14&\"_\"&+$A$1+2,\"\")","v":"2024_2"},"bbb","Proceso",null,"RIESGO 2","Directivo","Legal",null,2.1,"c","Humano","Interno",null,4,5,{"$f":"IF(AND(N30<>\"\",O30<>\"\"),IF(AND(N30>5,O30>5),\"I\",IF(AND(N30<=5,O30>5),\"II\",IF(AND(N30>5,O30<=5),\"IV\",IF(AND(N30<=5,O30<=5),\"III\")))),\"\")","v":"III"},"SI",{"$f":"IF(Q30=\"SI\",1,IF(Q30=\"NO\",3,0))","v":1},"2.1.1",null,"Preventivo","SI","SI","SI","SI",{"$f":"IF($T30<>\"\",IF(AND(V30=\"SI\",W30=\"SI\",X30=\"SI\",Y30=\"SI\"),\"Suficiente\",IF(OR(V30=\"NO\",W30=\"NO\",X30=\"NO\",Y30=\"NO\"),\"Deficiente\",IF(OR(V30=\"\",W30=\"\",X30=\"\",Y30=\"\"),\"Falta Valorar el Control\",\"\"))),\"\")","v":""},{"$f":"IF(Z30=\"Suficiente\",1,0)","v":0},{"$f":"IF(Z30=\"Deficiente\",1,0)","v":0},{"$f":"IF(SUM(R30:R30)>=1,IF((SUM(R30:R30)/COUNTA(Q30:Q30))=1,IF(SUM(AA30:AA30)>=1,IF(SUM(AA30:AA30)/(SUM(AA30:AA30)+SUM(AB30:AB30))=100%,\"SI\",\"NO\"),\"NO\"),\"NO\"),\"\")","v":"NO"},{"$f":"IF($N30=1,\"b\",\"\")","v":""},{"$f":"IF($O30=1,\"b\",\"\")","v":""},7,8,{"$f":"IF(OR($AD30=\"b\",$AE30=\"b\"),2,0)","v":0},{"$f":"IF(AND($N30=1,$AF30=1,$O30=1,$AG30=1),1,0)","v":0},{"$f":"IF(AF30<>\"\",IF(AI30=1,1,IF(OR($AF30>$N30,AND($AC30=\"SI\",$AF30=$N30),AND($AC30=\"NO\",$AF30<>$N30)),0,1)),0)","v":0},{"$f":"IF(AG30<>\"\",IF(AI30=1,1,IF(OR(AG30>O30,AND(AC30=\"SI\",AG30=O30),AND(AC30=\"NO\",AG30<>O30)),0,1)),0)","v":0},{"$f":"IF(AC30<>\"\",(+AI30+AJ30+AK30),0)","v":0},{"$f":"IF(AND($AF30=\"\",$AG30=\"\"),\"\",IF(AND($AF30>5,$AG30>5),\"I\",\"\"))","v":"I"},{"$f":"IF(AND($AF30=\"\",$AG30=\"\"),\"\",IF(AND($AF30<6,$AG30>5),\"II\",\"\"))","v":""},{"$f":"IF(AND($AF30=\"\",$AG30=\"\"),\"\",IF(AND($AF30<6,$AG30<6),\"III\",\"\"))","v":""},{"$f":"IF(AND($AF30=\"\",$AG30=\"\"),\"\",IF(AND($AF30>5,$AG30<6),\"IV\",\"\"))","v":""},"ASUMIR EL RIESGO","g","REDUCIR EL RIESGO"]
[null,null,null,null,null,null,null,null,2.2000000000000002,"d","Humano","Interno",null,null,null,null,"SI",{"$f":"IF(Q31=\"SI\",1,IF(Q31=\"NO\",3,0))","v":1},"2.2.1",null,"Preventivo","SI","SI","SI","SI",{"$f":"IF($T31<>\"\",IF(AND(V31=\"SI\",W31=\"SI\",X31=\"SI\",Y31=\"SI\"),\"Suficiente\",IF(OR(V31=\"NO\",W31=\"NO\",X31=\"NO\",Y31=\"NO\"),\"Deficiente\",IF(OR(V31=\"\",W31=\"\",X31=\"\",Y31=\"\"),\"Falta Valorar el Control\",\"\"))),\"\")","v":""},0,0,{"$f":"IF(SUM(R31:R31)>=1,IF((SUM(R31:R31)/COUNTA(Q31:Q31))=1,IF(SUM(AA31:AA31)>=1,IF(SUM(AA31:AA31)/(SUM(AA31:AA31)+SUM(AB31:AB31))=100%,\"SI\",\"NO\"),\"NO\"),\"NO\"),\"\")","v":"NO"},null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSFERIR EL RIESGO","h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[null,"Valo de escala","Impacto","Probabilidad de Ocurrencia"]
[null,"10-9","Catastrofico","Recurrente"]
[null,"8-7","Grave","Muy probable"]
[null,"6-5","Moderado","Probable"]
[null,"4-3","Bajo","Inusual"]
[null,"2-1","Menor","Remota"]
[]
[]
[]
[null,"INTEGRÓ",null,null,null,null,null,null,null,"REVISÓ",null,null,null,null,null,null,null,null,null,"Vo.Bo."]
[]
[]
[]
[]
[null,{"$f":"IF(+'Información General'!G19=\"\",\"\",'Información General'!G19&\" \n\"&'Información General'!C19)","v":"NOMBRE DEL TITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO \nTITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO"},null,null,null,null,null,null,null,{"$f":"IF(+'Información General'!G21=\"\",\"\",'Información General'!G21&\" \n\"&'Información General'!C21)","v":"NOMBRE DEL ENLACE DE ADMINISTRACIÓN DE RIESGOS \n  ENLACE DE ADMINISTRACIÓN DE RIESGOS"},null,null,null,null,null,null,null,null,null,{"$f":"IF(+'Información General'!G17=\"\",\"\",'Información General'!G17&\"\n\"&'Información General'!C17)","v":"NOMBRE DEL COORDINADOR DE CONTROL INTERNO\nCOORDINADOR DE CONTROL INTERNO"}]
[]
[]
[null,null,null,null,null,{"$f":"IF(+'Información General'!F45=\"\",\"\",'Información General'!F45&\", \n\"&'Información General'!B45)","v":""}]
[null,null,null,null,null,{"$f":"IF(+'Información General'!F46=\"\",\"\",'Información General'!F46&\", \n\"&'Información General'!B46)","v":""}]

{"sheet":" Mapa de Riesgos","index":2,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[8,3,8,8],[12,0,14,0],[12,1,14,1],[12,2,14,2],[10,3,10,9],[34,7,34,11],[27,6,27,8],[30,10,31,12],[27,10,27,12],[30,6,31,8]]}
[]
[]
[]
[]
[]
[]
[{"$f":"\"MAPA    DE    RIESGOS    INSTITUCIONAL    \"&'Información General'!D14","v":"MAPA    DE    RIESGOS    INSTITUCIONAL    2024"}]
[]
[null,"TITULAR DE LA INSTITUCIÓN",null,{"$f":"'Información General'!E10","v":"NOMBRE DEL TITULAR DE LA DEPENDENCIA O ENTIDAD PÚBLICA"}]
[]
[null,"ÀREA RESPONSABLE DEL PROCESO",null,{"$f":"'Información General'!E12","v":"NOMBRE DE LA UNIDAD RESPONSABLE DEL PROCESO"}]
[]
["No. de Riesgo","R I E S G O","Clasificación del Riesgo","III. VALORACIÓN\nDE RIESGOS VS. CONTROLES"]
[null,null,null,"Valoración Final"]
[null,null,null,"GRADO DE \nIMPACTO","PROBABILIDAD DE OCURRENCIA\n"]
[{"$f":"IF(+Matriz!A25<>\"\",+Matriz!A25,\"\")","v":"2024_1"},{"$f":"IF(+Matriz!E25<>\"\",+Matriz!E25,\"\")","v":"RIESGO 1"},{"$f":"IF(Matriz!G25=\"\",\"\",Matriz!G25)","v":"Administrativo"},{"$f":"+Matriz!AF25","v":3},{"$f":"+Matriz!AG25","v":3}]
[{"$f":"IF(+Matriz!A30<>\"\",+Matriz!A30,\"\")","v":"2024_2"},{"$f":"IF(+Matriz!E30<>\"\",+Matriz!E30,\"\")","v":"RIESGO 2"},{"$f":"IF(Matriz!G30=\"\",\"\",Matriz!G30)","v":"Legal"},{"$f":"+Matriz!AF30","v":7},{"$f":"+Matriz!AG30","v":8}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"INTEGRÓ",null,null,null,"REVISÓ"]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(+Matriz!B50<>\"\",+Matriz!B50,\"\")","v":"NOMBRE DEL TITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO \nTITULAR DE LA UNIDAD RESPONSABLE DEL PROCESO"},null,null,null,{"$f":"IF(+Matriz!J50<>\"\",+Matriz!J50,\"\")","v":"NOMBRE DEL ENLACE DE ADMINISTRACIÓN DE RIESGOS \n  ENLACE DE ADMINISTRACIÓN DE RIESGOS"}]
[]
[null,null,null,null,null,null,null,null,null,"Vo. Bo"]
[null,"Fecha de Impresión:  ",null,{"$f":"NOW()","v":"2025-04-24T15:07:23.680"}]
[null,null,null,null,null,null,null,{"$f":"IF(+Matriz!T50<>\"\",+Matriz!T50,\"\")","v":"NOMBRE DEL COORDINADOR DE CONTROL INTERNO\nCOORDINADOR DE CONTROL INTERNO"}]

{"sheet":"PTAR 2025","index":3,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,13,14,14],[14,5,14,6],[14,8,14,9],[10,6,10,8],[15,6,16,8],[15,10,16,12],[10,10,10,12],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[7,10,8,10],[5,3,6,3],[5,4,6,4],[5,5,6,5],[7,5,8,5],[7,3,8,3],[7,4,8,4],[5,11,6,11],[7,11,8,11],[19,10,19,12],[7,0,8,0],[7,1,8,1],[7,2,8,2],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,10,6,10],[15,1,16,3],[10,1,10,3],[12,1,13,3]]}
["Programa de Administración de Riesgos 2025 (PTAR)"]
["UNIDAD RESPONSABLE"]
["Área responsable del proceso"]
["PROCESO "]
["No. Riesgo","Descripción del Riesgo","Clasificación del Riesgo","Valor de\nImpacto","Valor de\nProbabilidad","Cuadrante","Estrategia","No. Factor\nde Riesgo","Factor de Riesgo","Descripción de la acción de control","Àrea responsable de la acción de Control","Responsable de la acción de Control","Fecha de Inicio","Fecha de Término","Medios de verificación"]
[{"$f":"IF(Matriz!A25=\"\",\"\",Matriz!A25)","v":"2024_1"},{"$f":"IF(Matriz!E25=\"\",\"\",Matriz!E25)","v":"RIESGO 1"},{"$f":"IF(Matriz!G25=\"\",\"\",Matriz!G25)","v":"Administrativo"},{"$f":"Matriz!AF25","v":3},{"$f":"Matriz!AG25","v":3},{"$f":"CONCATENATE(Matriz!AM25,Matriz!AN25,Matriz!AO25,Matriz!AP25)","v":"III"},{"$f":"IF(Matriz!AQ25=\"\",\"\",Matriz!AQ25)","v":"EVITAR EL RIESGO"},{"$f":"IF(Matriz!I25=\"\",\"\",Matriz!I25)","v":1.1000000000000001},{"$f":"IF(Matriz!J25=\"\",\"\",Matriz!J25)","v":"a"},{"$f":"IF(Matriz!AR25=\"\",\"\",Matriz!AR25)","v":"e"},{"$f":"Matriz!B25","v":"aaa"}]
[null,null,null,null,null,null,{"$f":"IF(Matriz!AQ26=\"\",\"\",Matriz!AQ26)","v":"REDUCIR EL RIESGO"},{"$f":"IF(Matriz!I26=\"\",\"\",Matriz!I26)","v":1.2},{"$f":"IF(Matriz!J26=\"\",\"\",Matriz!J26)","v":"b"},{"$f":"IF(Matriz!AR26=\"\",\"\",Matriz!AR26)","v":"f"}]
[{"$f":"IF(Matriz!A30=\"\",\"\",Matriz!A30)","v":"2024_2"},{"$f":"IF(Matriz!E30=\"\",\"\",Matriz!E30)","v":"RIESGO 2"},{"$f":"IF(Matriz!G30=\"\",\"\",Matriz!G30)","v":"Legal"},{"$f":"Matriz!AF30","v":7},{"$f":"Matriz!AG30","v":8},{"$f":"CONCATENATE(Matriz!AM30,Matriz!AN30,Matriz!AO30,Matriz!AP30)","v":"I"},{"$f":"IF(Matriz!AQ30=\"\",\"\",Matriz!AQ30)","v":"ASUMIR EL RIESGO"},2.1,{"$f":"IF(Matriz!J30=\"\",\"\",Matriz!J30)","v":"c"},{"$f":"IF(Matriz!AR30=\"\",\"\",Matriz!AR30)","v":"g"},{"$f":"Matriz!B30","v":"bbb"}]
[null,null,null,null,null,null,{"$f":"IF(Matriz!AQ31=\"\",\"\",Matriz!AQ31)","v":"TRANSFERIR EL RIESGO"},2.2000000000000002,{"$f":"IF(Matriz!J31=\"\",\"\",Matriz!J31)","v":"d"},{"$f":"IF(Matriz!AR31=\"\",\"\",Matriz!AR31)","v":"h"}]
[]
[null,"Enlace de Administración de Riesgos",null,null,null,null,"Coordinador de Control Interno ",null,null,null,"Titular "]
[]
[]
[]
[]
[null,"Nombre y Cargo",null,null,null,null,"Nombre",null,null,null,"Nombre y cargo"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Villahermosa,  Tabasco a XX de XXXXX de 202X"]