{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Matriz de Riesgo SI-IDEAM","Matriz de Calor (Zona)","CONTROL DE CAMBIOS","Mapa Vulnerabilidades","PROBABILIDAD","IMPACTO","Matriz Opciones Riesgo","BD ID COLOR","CONTROLES"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":16,"comments":1,"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":"Matriz de Riesgo SI-IDEAM","index":0,"n_rows":89,"n_cols":48,"rows_kept":89,"cut":false,"hidden":false,"merged":[[8,19,8,27],[0,0,7,6],[5,7,5,15],[6,7,7,15],[14,0,14,16383],[16,33,16,38],[17,33,17,38],[18,33,18,38],[11,0,13,15],[16,0,18,15],[11,33,11,38],[12,33,12,38],[13,33,13,38],[21,0,23,15],[21,33,21,38],[22,33,22,38],[23,33,23,38],[19,0,19,16383],[24,0,24,16383],[26,0,28,15],[26,33,26,38],[27,33,27,38],[28,33,28,38],[29,0,29,16383],[31,0,33,15],[31,33,31,38],[32,33,32,38],[33,33,33,38],[34,0,34,16383],[36,0,38,15],[36,33,36,38],[37,33,37,38],[38,33,38,38],[39,0,39,16383],[41,0,43,15],[41,33,41,38],[42,33,42,38],[43,33,43,38],[44,0,44,16383],[46,0,48,15],[46,33,46,38],[47,33,47,38],[48,33,48,38],[49,0,49,16383],[51,0,53,15],[51,33,51,38],[52,33,52,38],[53,33,53,38],[54,0,54,16383],[56,0,58,15],[56,33,56,38],[57,33,57,38],[58,33,58,38],[59,0,59,16383],[61,0,63,15],[61,33,61,38],[62,33,62,38],[63,33,63,38],[64,0,64,16383],[66,0,68,15],[66,33,66,38],[67,33,67,38],[68,33,68,38],[69,0,69,16383],[71,0,73,15],[71,33,71,38],[72,33,72,38],[73,33,73,38],[74,0,74,16383],[76,0,78,15],[76,33,76,38],[77,33,77,38],[78,33,78,38],[79,0,79,16383],[81,0,83,15],[81,33,81,38],[82,33,82,38],[83,33,83,38],[84,0,84,16383],[86,0,88,15],[86,33,86,38],[87,33,87,38],[88,33,88,38]]}
["Muy BajaCatastrófico"]
[]
[null,null,null,null,null,null,null,"CÓDIGO:","E-SGI-SI-F003"]
[null,null,null,null,null,null,null,"VERSIÓN:"]
[null,null,null,null,null,null,null,"FECHA:"]
[null,null,null,null,null,null,null,"PÁGINA 1 DE 1"]
[null,null,null,null,null,null,null,"HERRAMIENTA MATRIZ DE RIESGO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afectación","Atributos Controles"]
["ID. Riesgo","Proceso","Activo de\nInformación (Nombre)","Descripción \nActivo","Identificación Impacto","Vulnerabilidad","Consecuencia \nInmediata","Causa Raíz","Descripción del Riesgo","Clasificación del Riesgo","Probabilidad Inherente","Valor en %","Impacto Inherente","Valor en %","LLAVE","Zona de Riesgo Inherente","DOMINIOS","Número de Control/Descripción del Control","Probabilidad","Tipo","Valor Preventivo","Implementación","Valor Implementación","Documentado","Valor Documentado","Frecuencia","Valor Frecuencia","Evidencia","Valor Evidencia","Calificación","Promedio Probabilidad","Promedio Impacto","Promedio No aplica","Probabilidad Residual","Valor en %","Impacto Residual","Valor en %","Verificar Zona Residual en Matriz de Calor","Zona de Riesgo Residual","Tratamiento","Aplica Plan de Acción?","Plan de Acción","Responsable","Fecha Inicio implementación","Fecha Seguimiento","Seguimiento","Estado","Observaciones"]
[null,"A_GESTIÓN FINANCIERA",null,null,"Económica y \nReputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Alta",{"$f":"IF(K11=\"Muy Baja\",0.2,IF(K11=\"Baja\",0.4,IF(K11=\"Media\",0.6,IF(K11=\"Alta\",0.8,IF(K11=\"Muy Alta\",1,)))))","v":1},"Mayor",{"$f":"IF(M11=\"Leve\",0.2,IF(M11=\"Menor\",0.4,IF(M11=\"Moderado\",0.6,IF(M11=\"Mayor\",0.8,IF(M11=\"Catastrófico\",1,)))))","v":0.8},{"$f":"K11&M11","v":"Muy AltaMayor"},{"$f":"VLOOKUP(O11,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"ALTO"},"A.12_SEGURIDAD_DE_LAS_OPERACIONES","A.12.1.3 Gestión de capacidad","Probabilidad","Preventivo",{"$f":"IF(T11=\"Preventivo\",0.35,IF(T11=\"Detectivo\",0.15,IF(T11=\"Correctivo\",0.1,)))","v":0.35},"Automático",{"$f":"IF(V11=\"Manual\",0.15,IF(V11=\"Automático\",0.3,))","v":0.3},"Documentado",{"$f":"IF(X11=\"Documentado\",0.1,IF(X11=\"Sin Documentar\",0.02,))","v":0.1},"Aleatoria",{"$f":"IF(Z11=\"Continua\",0.15,IF(Z11=\"Aleatoria\",0.05,))","v":0.05},"Con registro",{"$f":"IF(AB11=\"Con registro\",0.1,IF(AB11=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S11=\"No Aplica\",0,(U11+W11+Y11+AA11+AC11))","v":0.89999999999999991},{"$f":"IFERROR(AVERAGEIF(S11:S14,\"Probabilidad\",AD11:AD14),0)","v":0.89999999999999991},{"$f":"IFERROR(AVERAGEIF(S11:S14,\"Impacto\",AD11:AD14),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S11:S14,\"No Aplica\",AD11:AD14),0)","v":0},{"$f":"IF(AI11<=20%,\"Muy Baja\",IF(AI11<=40%,\"Baja\",IF(AI11<=60%,\"Media\",IF(AI11<=80%,\"Alta\",IF(AI11<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L11-(L11*AE11)","v":0.10000000000000009},{"$f":"IF(AK11<=20%,\"Leve\",IF(AK11<=40%,\"Menor\",IF(AK11<=60%,\"Moderado\",IF(AK11<=80%,\"Mayor\",IF(AK11<=100%,\"Catastrófico\",)))))","v":"Mayor"},{"$f":"(N11-(N11*AF11))","v":0.8},{"$f":"AH11&AJ11","v":"Muy BajaMayor"},{"$f":"VLOOKUP(AL11,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"ALTO"},"Aceptar",{"$f":"IF(AM11=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"Si Aplica"},null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T12=\"Preventivo\",0.35,IF(T12=\"Detectivo\",0.15,IF(T12=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V12=\"Manual\",0.15,IF(V12=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X12=\"Documentado\",0.1,IF(X12=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z12=\"Continua\",0.15,IF(Z12=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB12=\"Con registro\",0.1,IF(AB12=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S12=\"No Aplica\",0,(U12+W12+Y12+AA12+AC12))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S13=\"No Aplica\",0,(U13+W13+Y13+AA13+AC13))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K16=\"Muy Baja\",0.2,IF(K16=\"Baja\",0.4,IF(K16=\"Media\",0.6,IF(K16=\"Alta\",0.8,IF(K16=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M16=\"Leve\",0.2,IF(M16=\"Menor\",0.4,IF(M16=\"Moderado\",0.6,IF(M16=\"Mayor\",0.8,IF(M16=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K16&M16","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O16,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T16=\"Preventivo\",0.35,IF(T16=\"Detectivo\",0.15,IF(T16=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V16=\"Manual\",0.15,IF(V16=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X16=\"Documentado\",0.1,IF(X16=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z16=\"Continua\",0.15,IF(Z16=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB16=\"Con registro\",0.1,IF(AB16=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S16=\"No Aplica\",0,(U16+W16+Y16+AA16+AC16))","v":0},{"$f":"IFERROR(AVERAGEIF(S16:S19,\"Probabilidad\",AD16:AD19),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S16:S19,\"Impacto\",AD16:AD19),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S16:S19,\"No Aplica\",AD16:AD19),0)","v":0},{"$f":"IF(AI16<=20%,\"Muy Baja\",IF(AI16<=40%,\"Baja\",IF(AI16<=60%,\"Media\",IF(AI16<=80%,\"Alta\",IF(AI16<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L16-(L16*AE16)","v":0.2},{"$f":"IF(AK16<=20%,\"Leve\",IF(AK16<=40%,\"Menor\",IF(AK16<=60%,\"Moderado\",IF(AK16<=80%,\"Mayor\",IF(AK16<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N16-(N16*AF16))","v":0.4},{"$f":"AH16&AJ16","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL16,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM16=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T17=\"Preventivo\",0.35,IF(T17=\"Detectivo\",0.15,IF(T17=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V17=\"Manual\",0.15,IF(V17=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X17=\"Documentado\",0.1,IF(X17=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z17=\"Continua\",0.15,IF(Z17=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB17=\"Con registro\",0.1,IF(AB17=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S17=\"No Aplica\",0,(U17+W17+Y17+AA17+AC17))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S18=\"No Aplica\",0,(U18+W18+Y18+AA18+AC18))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K21=\"Muy Baja\",0.2,IF(K21=\"Baja\",0.4,IF(K21=\"Media\",0.6,IF(K21=\"Alta\",0.8,IF(K21=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M21=\"Leve\",0.2,IF(M21=\"Menor\",0.4,IF(M21=\"Moderado\",0.6,IF(M21=\"Mayor\",0.8,IF(M21=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K21&M21","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O21,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T21=\"Preventivo\",0.35,IF(T21=\"Detectivo\",0.15,IF(T21=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V21=\"Manual\",0.15,IF(V21=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X21=\"Documentado\",0.1,IF(X21=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z21=\"Continua\",0.15,IF(Z21=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB21=\"Con registro\",0.1,IF(AB21=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S21=\"No Aplica\",0,(U21+W21+Y21+AA21+AC21))","v":0},{"$f":"IFERROR(AVERAGEIF(S21:S24,\"Probabilidad\",AD21:AD24),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S21:S24,\"Impacto\",AD21:AD24),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S21:S24,\"No Aplica\",AD21:AD24),0)","v":0},{"$f":"IF(AI21<=20%,\"Muy Baja\",IF(AI21<=40%,\"Baja\",IF(AI21<=60%,\"Media\",IF(AI21<=80%,\"Alta\",IF(AI21<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L21-(L21*AE21)","v":0.2},{"$f":"IF(AK21<=20%,\"Leve\",IF(AK21<=40%,\"Menor\",IF(AK21<=60%,\"Moderado\",IF(AK21<=80%,\"Mayor\",IF(AK21<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N21-(N21*AF21))","v":0.4},{"$f":"AH21&AJ21","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL21,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM21=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T22=\"Preventivo\",0.35,IF(T22=\"Detectivo\",0.15,IF(T22=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V22=\"Manual\",0.15,IF(V22=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X22=\"Documentado\",0.1,IF(X22=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z22=\"Continua\",0.15,IF(Z22=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB22=\"Con registro\",0.1,IF(AB22=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S22=\"No Aplica\",0,(U22+W22+Y22+AA22+AC22))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S23=\"No Aplica\",0,(U23+W23+Y23+AA23+AC23))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K26=\"Muy Baja\",0.2,IF(K26=\"Baja\",0.4,IF(K26=\"Media\",0.6,IF(K26=\"Alta\",0.8,IF(K26=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M26=\"Leve\",0.2,IF(M26=\"Menor\",0.4,IF(M26=\"Moderado\",0.6,IF(M26=\"Mayor\",0.8,IF(M26=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K26&M26","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O26,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T26=\"Preventivo\",0.35,IF(T26=\"Detectivo\",0.15,IF(T26=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V26=\"Manual\",0.15,IF(V26=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X26=\"Documentado\",0.1,IF(X26=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z26=\"Continua\",0.15,IF(Z26=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB26=\"Con registro\",0.1,IF(AB26=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S26=\"No Aplica\",0,(U26+W26+Y26+AA26+AC26))","v":0},{"$f":"IFERROR(AVERAGEIF(S26:S29,\"Probabilidad\",AD26:AD29),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S26:S29,\"Impacto\",AD26:AD29),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S26:S29,\"No Aplica\",AD26:AD29),0)","v":0},{"$f":"IF(AI26<=20%,\"Muy Baja\",IF(AI26<=40%,\"Baja\",IF(AI26<=60%,\"Media\",IF(AI26<=80%,\"Alta\",IF(AI26<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L26-(L26*AE26)","v":0.2},{"$f":"IF(AK26<=20%,\"Leve\",IF(AK26<=40%,\"Menor\",IF(AK26<=60%,\"Moderado\",IF(AK26<=80%,\"Mayor\",IF(AK26<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N26-(N26*AF26))","v":0.4},{"$f":"AH26&AJ26","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL26,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM26=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T27=\"Preventivo\",0.35,IF(T27=\"Detectivo\",0.15,IF(T27=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V27=\"Manual\",0.15,IF(V27=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X27=\"Documentado\",0.1,IF(X27=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z27=\"Continua\",0.15,IF(Z27=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB27=\"Con registro\",0.1,IF(AB27=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S27=\"No Aplica\",0,(U27+W27+Y27+AA27+AC27))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S28=\"No Aplica\",0,(U28+W28+Y28+AA28+AC28))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K31=\"Muy Baja\",0.2,IF(K31=\"Baja\",0.4,IF(K31=\"Media\",0.6,IF(K31=\"Alta\",0.8,IF(K31=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M31=\"Leve\",0.2,IF(M31=\"Menor\",0.4,IF(M31=\"Moderado\",0.6,IF(M31=\"Mayor\",0.8,IF(M31=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K31&M31","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O31,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T31=\"Preventivo\",0.35,IF(T31=\"Detectivo\",0.15,IF(T31=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V31=\"Manual\",0.15,IF(V31=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X31=\"Documentado\",0.1,IF(X31=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z31=\"Continua\",0.15,IF(Z31=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB31=\"Con registro\",0.1,IF(AB31=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S31=\"No Aplica\",0,(U31+W31+Y31+AA31+AC31))","v":0},{"$f":"IFERROR(AVERAGEIF(S31:S34,\"Probabilidad\",AD31:AD34),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S31:S34,\"Impacto\",AD31:AD34),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S31:S34,\"No Aplica\",AD31:AD34),0)","v":0},{"$f":"IF(AI31<=20%,\"Muy Baja\",IF(AI31<=40%,\"Baja\",IF(AI31<=60%,\"Media\",IF(AI31<=80%,\"Alta\",IF(AI31<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L31-(L31*AE31)","v":0.2},{"$f":"IF(AK31<=20%,\"Leve\",IF(AK31<=40%,\"Menor\",IF(AK31<=60%,\"Moderado\",IF(AK31<=80%,\"Mayor\",IF(AK31<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N31-(N31*AF31))","v":0.4},{"$f":"AH31&AJ31","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL31,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM31=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T32=\"Preventivo\",0.35,IF(T32=\"Detectivo\",0.15,IF(T32=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V32=\"Manual\",0.15,IF(V32=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X32=\"Documentado\",0.1,IF(X32=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z32=\"Continua\",0.15,IF(Z32=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB32=\"Con registro\",0.1,IF(AB32=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S32=\"No Aplica\",0,(U32+W32+Y32+AA32+AC32))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S33=\"No Aplica\",0,(U33+W33+Y33+AA33+AC33))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K36=\"Muy Baja\",0.2,IF(K36=\"Baja\",0.4,IF(K36=\"Media\",0.6,IF(K36=\"Alta\",0.8,IF(K36=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M36=\"Leve\",0.2,IF(M36=\"Menor\",0.4,IF(M36=\"Moderado\",0.6,IF(M36=\"Mayor\",0.8,IF(M36=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K36&M36","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O36,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T36=\"Preventivo\",0.35,IF(T36=\"Detectivo\",0.15,IF(T36=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V36=\"Manual\",0.15,IF(V36=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X36=\"Documentado\",0.1,IF(X36=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z36=\"Continua\",0.15,IF(Z36=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB36=\"Con registro\",0.1,IF(AB36=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S36=\"No Aplica\",0,(U36+W36+Y36+AA36+AC36))","v":0},{"$f":"IFERROR(AVERAGEIF(S36:S39,\"Probabilidad\",AD36:AD39),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S36:S39,\"Impacto\",AD36:AD39),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S36:S39,\"No Aplica\",AD36:AD39),0)","v":0},{"$f":"IF(AI36<=20%,\"Muy Baja\",IF(AI36<=40%,\"Baja\",IF(AI36<=60%,\"Media\",IF(AI36<=80%,\"Alta\",IF(AI36<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L36-(L36*AE36)","v":0.2},{"$f":"IF(AK36<=20%,\"Leve\",IF(AK36<=40%,\"Menor\",IF(AK36<=60%,\"Moderado\",IF(AK36<=80%,\"Mayor\",IF(AK36<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N36-(N36*AF36))","v":0.4},{"$f":"AH36&AJ36","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL36,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM36=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T37=\"Preventivo\",0.35,IF(T37=\"Detectivo\",0.15,IF(T37=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V37=\"Manual\",0.15,IF(V37=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X37=\"Documentado\",0.1,IF(X37=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z37=\"Continua\",0.15,IF(Z37=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB37=\"Con registro\",0.1,IF(AB37=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S37=\"No Aplica\",0,(U37+W37+Y37+AA37+AC37))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S38=\"No Aplica\",0,(U38+W38+Y38+AA38+AC38))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K41=\"Muy Baja\",0.2,IF(K41=\"Baja\",0.4,IF(K41=\"Media\",0.6,IF(K41=\"Alta\",0.8,IF(K41=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M41=\"Leve\",0.2,IF(M41=\"Menor\",0.4,IF(M41=\"Moderado\",0.6,IF(M41=\"Mayor\",0.8,IF(M41=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K41&M41","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O41,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T41=\"Preventivo\",0.35,IF(T41=\"Detectivo\",0.15,IF(T41=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V41=\"Manual\",0.15,IF(V41=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X41=\"Documentado\",0.1,IF(X41=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z41=\"Continua\",0.15,IF(Z41=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB41=\"Con registro\",0.1,IF(AB41=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S41=\"No Aplica\",0,(U41+W41+Y41+AA41+AC41))","v":0},{"$f":"IFERROR(AVERAGEIF(S41:S44,\"Probabilidad\",AD41:AD44),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S41:S44,\"Impacto\",AD41:AD44),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S41:S44,\"No Aplica\",AD41:AD44),0)","v":0},{"$f":"IF(AI41<=20%,\"Muy Baja\",IF(AI41<=40%,\"Baja\",IF(AI41<=60%,\"Media\",IF(AI41<=80%,\"Alta\",IF(AI41<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L41-(L41*AE41)","v":0.2},{"$f":"IF(AK41<=20%,\"Leve\",IF(AK41<=40%,\"Menor\",IF(AK41<=60%,\"Moderado\",IF(AK41<=80%,\"Mayor\",IF(AK41<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N41-(N41*AF41))","v":0.4},{"$f":"AH41&AJ41","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL41,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM41=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T42=\"Preventivo\",0.35,IF(T42=\"Detectivo\",0.15,IF(T42=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V42=\"Manual\",0.15,IF(V42=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X42=\"Documentado\",0.1,IF(X42=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z42=\"Continua\",0.15,IF(Z42=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB42=\"Con registro\",0.1,IF(AB42=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S42=\"No Aplica\",0,(U42+W42+Y42+AA42+AC42))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S43=\"No Aplica\",0,(U43+W43+Y43+AA43+AC43))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K46=\"Muy Baja\",0.2,IF(K46=\"Baja\",0.4,IF(K46=\"Media\",0.6,IF(K46=\"Alta\",0.8,IF(K46=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M46=\"Leve\",0.2,IF(M46=\"Menor\",0.4,IF(M46=\"Moderado\",0.6,IF(M46=\"Mayor\",0.8,IF(M46=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K46&M46","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O46,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T46=\"Preventivo\",0.35,IF(T46=\"Detectivo\",0.15,IF(T46=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V46=\"Manual\",0.15,IF(V46=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X46=\"Documentado\",0.1,IF(X46=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z46=\"Continua\",0.15,IF(Z46=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB46=\"Con registro\",0.1,IF(AB46=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S46=\"No Aplica\",0,(U46+W46+Y46+AA46+AC46))","v":0},{"$f":"IFERROR(AVERAGEIF(S46:S49,\"Probabilidad\",AD46:AD49),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S46:S49,\"Impacto\",AD46:AD49),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S46:S49,\"No Aplica\",AD46:AD49),0)","v":0},{"$f":"IF(AI46<=20%,\"Muy Baja\",IF(AI46<=40%,\"Baja\",IF(AI46<=60%,\"Media\",IF(AI46<=80%,\"Alta\",IF(AI46<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L46-(L46*AE46)","v":0.2},{"$f":"IF(AK46<=20%,\"Leve\",IF(AK46<=40%,\"Menor\",IF(AK46<=60%,\"Moderado\",IF(AK46<=80%,\"Mayor\",IF(AK46<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N46-(N46*AF46))","v":0.4},{"$f":"AH46&AJ46","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL46,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM46=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T47=\"Preventivo\",0.35,IF(T47=\"Detectivo\",0.15,IF(T47=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V47=\"Manual\",0.15,IF(V47=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X47=\"Documentado\",0.1,IF(X47=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z47=\"Continua\",0.15,IF(Z47=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB47=\"Con registro\",0.1,IF(AB47=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S47=\"No Aplica\",0,(U47+W47+Y47+AA47+AC47))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S48=\"No Aplica\",0,(U48+W48+Y48+AA48+AC48))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K51=\"Muy Baja\",0.2,IF(K51=\"Baja\",0.4,IF(K51=\"Media\",0.6,IF(K51=\"Alta\",0.8,IF(K51=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M51=\"Leve\",0.2,IF(M51=\"Menor\",0.4,IF(M51=\"Moderado\",0.6,IF(M51=\"Mayor\",0.8,IF(M51=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K51&M51","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O51,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T51=\"Preventivo\",0.35,IF(T51=\"Detectivo\",0.15,IF(T51=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V51=\"Manual\",0.15,IF(V51=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X51=\"Documentado\",0.1,IF(X51=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z51=\"Continua\",0.15,IF(Z51=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB51=\"Con registro\",0.1,IF(AB51=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S51=\"No Aplica\",0,(U51+W51+Y51+AA51+AC51))","v":0},{"$f":"IFERROR(AVERAGEIF(S51:S54,\"Probabilidad\",AD51:AD54),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S51:S54,\"Impacto\",AD51:AD54),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S51:S54,\"No Aplica\",AD51:AD54),0)","v":0},{"$f":"IF(AI51<=20%,\"Muy Baja\",IF(AI51<=40%,\"Baja\",IF(AI51<=60%,\"Media\",IF(AI51<=80%,\"Alta\",IF(AI51<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L51-(L51*AE51)","v":0.2},{"$f":"IF(AK51<=20%,\"Leve\",IF(AK51<=40%,\"Menor\",IF(AK51<=60%,\"Moderado\",IF(AK51<=80%,\"Mayor\",IF(AK51<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N51-(N51*AF51))","v":0.4},{"$f":"AH51&AJ51","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL51,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM51=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T52=\"Preventivo\",0.35,IF(T52=\"Detectivo\",0.15,IF(T52=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V52=\"Manual\",0.15,IF(V52=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X52=\"Documentado\",0.1,IF(X52=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z52=\"Continua\",0.15,IF(Z52=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB52=\"Con registro\",0.1,IF(AB52=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S52=\"No Aplica\",0,(U52+W52+Y52+AA52+AC52))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S53=\"No Aplica\",0,(U53+W53+Y53+AA53+AC53))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K56=\"Muy Baja\",0.2,IF(K56=\"Baja\",0.4,IF(K56=\"Media\",0.6,IF(K56=\"Alta\",0.8,IF(K56=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M56=\"Leve\",0.2,IF(M56=\"Menor\",0.4,IF(M56=\"Moderado\",0.6,IF(M56=\"Mayor\",0.8,IF(M56=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K56&M56","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O56,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T56=\"Preventivo\",0.35,IF(T56=\"Detectivo\",0.15,IF(T56=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V56=\"Manual\",0.15,IF(V56=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X56=\"Documentado\",0.1,IF(X56=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z56=\"Continua\",0.15,IF(Z56=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB56=\"Con registro\",0.1,IF(AB56=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S56=\"No Aplica\",0,(U56+W56+Y56+AA56+AC56))","v":0},{"$f":"IFERROR(AVERAGEIF(S56:S59,\"Probabilidad\",AD56:AD59),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S56:S59,\"Impacto\",AD56:AD59),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S56:S59,\"No Aplica\",AD56:AD59),0)","v":0},{"$f":"IF(AI56<=20%,\"Muy Baja\",IF(AI56<=40%,\"Baja\",IF(AI56<=60%,\"Media\",IF(AI56<=80%,\"Alta\",IF(AI56<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L56-(L56*AE56)","v":0.2},{"$f":"IF(AK56<=20%,\"Leve\",IF(AK56<=40%,\"Menor\",IF(AK56<=60%,\"Moderado\",IF(AK56<=80%,\"Mayor\",IF(AK56<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N56-(N56*AF56))","v":0.4},{"$f":"AH56&AJ56","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL56,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM56=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T57=\"Preventivo\",0.35,IF(T57=\"Detectivo\",0.15,IF(T57=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V57=\"Manual\",0.15,IF(V57=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X57=\"Documentado\",0.1,IF(X57=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z57=\"Continua\",0.15,IF(Z57=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB57=\"Con registro\",0.1,IF(AB57=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S57=\"No Aplica\",0,(U57+W57+Y57+AA57+AC57))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S58=\"No Aplica\",0,(U58+W58+Y58+AA58+AC58))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K61=\"Muy Baja\",0.2,IF(K61=\"Baja\",0.4,IF(K61=\"Media\",0.6,IF(K61=\"Alta\",0.8,IF(K61=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M61=\"Leve\",0.2,IF(M61=\"Menor\",0.4,IF(M61=\"Moderado\",0.6,IF(M61=\"Mayor\",0.8,IF(M61=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K61&M61","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O61,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T61=\"Preventivo\",0.35,IF(T61=\"Detectivo\",0.15,IF(T61=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V61=\"Manual\",0.15,IF(V61=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X61=\"Documentado\",0.1,IF(X61=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z61=\"Continua\",0.15,IF(Z61=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB61=\"Con registro\",0.1,IF(AB61=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S61=\"No Aplica\",0,(U61+W61+Y61+AA61+AC61))","v":0},{"$f":"IFERROR(AVERAGEIF(S61:S64,\"Probabilidad\",AD61:AD64),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S61:S64,\"Impacto\",AD61:AD64),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S61:S64,\"No Aplica\",AD61:AD64),0)","v":0},{"$f":"IF(AI61<=20%,\"Muy Baja\",IF(AI61<=40%,\"Baja\",IF(AI61<=60%,\"Media\",IF(AI61<=80%,\"Alta\",IF(AI61<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L61-(L61*AE61)","v":0.2},{"$f":"IF(AK61<=20%,\"Leve\",IF(AK61<=40%,\"Menor\",IF(AK61<=60%,\"Moderado\",IF(AK61<=80%,\"Mayor\",IF(AK61<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N61-(N61*AF61))","v":0.4},{"$f":"AH61&AJ61","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL61,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM61=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T62=\"Preventivo\",0.35,IF(T62=\"Detectivo\",0.15,IF(T62=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V62=\"Manual\",0.15,IF(V62=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X62=\"Documentado\",0.1,IF(X62=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z62=\"Continua\",0.15,IF(Z62=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB62=\"Con registro\",0.1,IF(AB62=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S62=\"No Aplica\",0,(U62+W62+Y62+AA62+AC62))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S63=\"No Aplica\",0,(U63+W63+Y63+AA63+AC63))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K66=\"Muy Baja\",0.2,IF(K66=\"Baja\",0.4,IF(K66=\"Media\",0.6,IF(K66=\"Alta\",0.8,IF(K66=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M66=\"Leve\",0.2,IF(M66=\"Menor\",0.4,IF(M66=\"Moderado\",0.6,IF(M66=\"Mayor\",0.8,IF(M66=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K66&M66","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O66,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T66=\"Preventivo\",0.35,IF(T66=\"Detectivo\",0.15,IF(T66=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V66=\"Manual\",0.15,IF(V66=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X66=\"Documentado\",0.1,IF(X66=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z66=\"Continua\",0.15,IF(Z66=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB66=\"Con registro\",0.1,IF(AB66=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S66=\"No Aplica\",0,(U66+W66+Y66+AA66+AC66))","v":0},{"$f":"IFERROR(AVERAGEIF(S66:S69,\"Probabilidad\",AD66:AD69),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S66:S69,\"Impacto\",AD66:AD69),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S66:S69,\"No Aplica\",AD66:AD69),0)","v":0},{"$f":"IF(AI66<=20%,\"Muy Baja\",IF(AI66<=40%,\"Baja\",IF(AI66<=60%,\"Media\",IF(AI66<=80%,\"Alta\",IF(AI66<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L66-(L66*AE66)","v":0.2},{"$f":"IF(AK66<=20%,\"Leve\",IF(AK66<=40%,\"Menor\",IF(AK66<=60%,\"Moderado\",IF(AK66<=80%,\"Mayor\",IF(AK66<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N66-(N66*AF66))","v":0.4},{"$f":"AH66&AJ66","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL66,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM66=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T67=\"Preventivo\",0.35,IF(T67=\"Detectivo\",0.15,IF(T67=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V67=\"Manual\",0.15,IF(V67=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X67=\"Documentado\",0.1,IF(X67=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z67=\"Continua\",0.15,IF(Z67=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB67=\"Con registro\",0.1,IF(AB67=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S67=\"No Aplica\",0,(U67+W67+Y67+AA67+AC67))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S68=\"No Aplica\",0,(U68+W68+Y68+AA68+AC68))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K71=\"Muy Baja\",0.2,IF(K71=\"Baja\",0.4,IF(K71=\"Media\",0.6,IF(K71=\"Alta\",0.8,IF(K71=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M71=\"Leve\",0.2,IF(M71=\"Menor\",0.4,IF(M71=\"Moderado\",0.6,IF(M71=\"Mayor\",0.8,IF(M71=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K71&M71","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O71,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T71=\"Preventivo\",0.35,IF(T71=\"Detectivo\",0.15,IF(T71=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V71=\"Manual\",0.15,IF(V71=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X71=\"Documentado\",0.1,IF(X71=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z71=\"Continua\",0.15,IF(Z71=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB71=\"Con registro\",0.1,IF(AB71=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S71=\"No Aplica\",0,(U71+W71+Y71+AA71+AC71))","v":0},{"$f":"IFERROR(AVERAGEIF(S71:S74,\"Probabilidad\",AD71:AD74),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S71:S74,\"Impacto\",AD71:AD74),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S71:S74,\"No Aplica\",AD71:AD74),0)","v":0},{"$f":"IF(AI71<=20%,\"Muy Baja\",IF(AI71<=40%,\"Baja\",IF(AI71<=60%,\"Media\",IF(AI71<=80%,\"Alta\",IF(AI71<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L71-(L71*AE71)","v":0.2},{"$f":"IF(AK71<=20%,\"Leve\",IF(AK71<=40%,\"Menor\",IF(AK71<=60%,\"Moderado\",IF(AK71<=80%,\"Mayor\",IF(AK71<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N71-(N71*AF71))","v":0.4},{"$f":"AH71&AJ71","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL71,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM71=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T72=\"Preventivo\",0.35,IF(T72=\"Detectivo\",0.15,IF(T72=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V72=\"Manual\",0.15,IF(V72=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X72=\"Documentado\",0.1,IF(X72=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z72=\"Continua\",0.15,IF(Z72=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB72=\"Con registro\",0.1,IF(AB72=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S72=\"No Aplica\",0,(U72+W72+Y72+AA72+AC72))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S73=\"No Aplica\",0,(U73+W73+Y73+AA73+AC73))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K76=\"Muy Baja\",0.2,IF(K76=\"Baja\",0.4,IF(K76=\"Media\",0.6,IF(K76=\"Alta\",0.8,IF(K76=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M76=\"Leve\",0.2,IF(M76=\"Menor\",0.4,IF(M76=\"Moderado\",0.6,IF(M76=\"Mayor\",0.8,IF(M76=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K76&M76","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O76,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T76=\"Preventivo\",0.35,IF(T76=\"Detectivo\",0.15,IF(T76=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V76=\"Manual\",0.15,IF(V76=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X76=\"Documentado\",0.1,IF(X76=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z76=\"Continua\",0.15,IF(Z76=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB76=\"Con registro\",0.1,IF(AB76=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S76=\"No Aplica\",0,(U76+W76+Y76+AA76+AC76))","v":0},{"$f":"IFERROR(AVERAGEIF(S76:S79,\"Probabilidad\",AD76:AD79),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S76:S79,\"Impacto\",AD76:AD79),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S76:S79,\"No Aplica\",AD76:AD79),0)","v":0},{"$f":"IF(AI76<=20%,\"Muy Baja\",IF(AI76<=40%,\"Baja\",IF(AI76<=60%,\"Media\",IF(AI76<=80%,\"Alta\",IF(AI76<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L76-(L76*AE76)","v":0.2},{"$f":"IF(AK76<=20%,\"Leve\",IF(AK76<=40%,\"Menor\",IF(AK76<=60%,\"Moderado\",IF(AK76<=80%,\"Mayor\",IF(AK76<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N76-(N76*AF76))","v":0.4},{"$f":"AH76&AJ76","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL76,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM76=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T77=\"Preventivo\",0.35,IF(T77=\"Detectivo\",0.15,IF(T77=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V77=\"Manual\",0.15,IF(V77=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X77=\"Documentado\",0.1,IF(X77=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z77=\"Continua\",0.15,IF(Z77=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB77=\"Con registro\",0.1,IF(AB77=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S77=\"No Aplica\",0,(U77+W77+Y77+AA77+AC77))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S78=\"No Aplica\",0,(U78+W78+Y78+AA78+AC78))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K81=\"Muy Baja\",0.2,IF(K81=\"Baja\",0.4,IF(K81=\"Media\",0.6,IF(K81=\"Alta\",0.8,IF(K81=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M81=\"Leve\",0.2,IF(M81=\"Menor\",0.4,IF(M81=\"Moderado\",0.6,IF(M81=\"Mayor\",0.8,IF(M81=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K81&M81","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O81,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T81=\"Preventivo\",0.35,IF(T81=\"Detectivo\",0.15,IF(T81=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V81=\"Manual\",0.15,IF(V81=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X81=\"Documentado\",0.1,IF(X81=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z81=\"Continua\",0.15,IF(Z81=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB81=\"Con registro\",0.1,IF(AB81=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S81=\"No Aplica\",0,(U81+W81+Y81+AA81+AC81))","v":0},{"$f":"IFERROR(AVERAGEIF(S81:S84,\"Probabilidad\",AD81:AD84),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S81:S84,\"Impacto\",AD81:AD84),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S81:S84,\"No Aplica\",AD81:AD84),0)","v":0},{"$f":"IF(AI81<=20%,\"Muy Baja\",IF(AI81<=40%,\"Baja\",IF(AI81<=60%,\"Media\",IF(AI81<=80%,\"Alta\",IF(AI81<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L81-(L81*AE81)","v":0.2},{"$f":"IF(AK81<=20%,\"Leve\",IF(AK81<=40%,\"Menor\",IF(AK81<=60%,\"Moderado\",IF(AK81<=80%,\"Mayor\",IF(AK81<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N81-(N81*AF81))","v":0.4},{"$f":"AH81&AJ81","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL81,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM81=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T82=\"Preventivo\",0.35,IF(T82=\"Detectivo\",0.15,IF(T82=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V82=\"Manual\",0.15,IF(V82=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X82=\"Documentado\",0.1,IF(X82=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z82=\"Continua\",0.15,IF(Z82=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB82=\"Con registro\",0.1,IF(AB82=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S82=\"No Aplica\",0,(U82+W82+Y82+AA82+AC82))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S83=\"No Aplica\",0,(U83+W83+Y83+AA83+AC83))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
[null,"A_GESTIÓN FINANCIERA",null,null,"Reputación","Fallas en el disco duro",null,null,null,"Fallas Tecnológicas","Muy Baja",{"$f":"IF(K86=\"Muy Baja\",0.2,IF(K86=\"Baja\",0.4,IF(K86=\"Media\",0.6,IF(K86=\"Alta\",0.8,IF(K86=\"Muy Alta\",1,)))))","v":0.2},"Menor",{"$f":"IF(M86=\"Leve\",0.2,IF(M86=\"Menor\",0.4,IF(M86=\"Moderado\",0.6,IF(M86=\"Mayor\",0.8,IF(M86=\"Catastrófico\",1,)))))","v":0.4},{"$f":"K86&M86","v":"Muy BajaMenor"},{"$f":"VLOOKUP(O86,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},null,null,"No Aplica","Correctivo",{"$f":"IF(T86=\"Preventivo\",0.35,IF(T86=\"Detectivo\",0.15,IF(T86=\"Correctivo\",0.1,)))","v":0.1},"Manual",{"$f":"IF(V86=\"Manual\",0.15,IF(V86=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X86=\"Documentado\",0.1,IF(X86=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z86=\"Continua\",0.15,IF(Z86=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB86=\"Con registro\",0.1,IF(AB86=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S86=\"No Aplica\",0,(U86+W86+Y86+AA86+AC86))","v":0},{"$f":"IFERROR(AVERAGEIF(S86:S89,\"Probabilidad\",AD86:AD89),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S86:S89,\"Impacto\",AD86:AD89),0)","v":0},{"$f":"IFERROR(AVERAGEIF(S86:S89,\"No Aplica\",AD86:AD89),0)","v":0},{"$f":"IF(AI86<=20%,\"Muy Baja\",IF(AI86<=40%,\"Baja\",IF(AI86<=60%,\"Media\",IF(AI86<=80%,\"Alta\",IF(AI86<=100%,\"Muy Alta\",)))))","v":"Muy Baja"},{"$f":"L86-(L86*AE86)","v":0.2},{"$f":"IF(AK86<=20%,\"Leve\",IF(AK86<=40%,\"Menor\",IF(AK86<=60%,\"Moderado\",IF(AK86<=80%,\"Mayor\",IF(AK86<=100%,\"Catastrófico\",)))))","v":"Menor"},{"$f":"(N86-(N86*AF86))","v":0.4},{"$f":"AH86&AJ86","v":"Muy BajaMenor"},{"$f":"VLOOKUP(AL86,'BD ID COLOR'!$A$2:$B$27,2,0)","v":"BAJO"},"Aceptar",{"$f":"IF(AM86=\"BAJO\",\"No Aplica\",\"Si Aplica\")","v":"No Aplica"},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",{"$f":"IF(T87=\"Preventivo\",0.35,IF(T87=\"Detectivo\",0.15,IF(T87=\"Correctivo\",0.1,)))","v":0.35},"Manual",{"$f":"IF(V87=\"Manual\",0.15,IF(V87=\"Automático\",0.3,))","v":0.15},"Sin Documentar",{"$f":"IF(X87=\"Documentado\",0.1,IF(X87=\"Sin Documentar\",0.02,))","v":0.02},"Continua",{"$f":"IF(Z87=\"Continua\",0.15,IF(Z87=\"Aleatoria\",0.05,))","v":0.15},"Con registro",{"$f":"IF(AB87=\"Con registro\",0.1,IF(AB87=\"Sin registro\",0.02,))","v":0.1},{"$f":"IF(S87=\"No Aplica\",0,(U87+W87+Y87+AA87+AC87))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Correctivo",0.1,"Manual",0.15,"Sin Documentar",0.02,"Aleatoria",0.05,"Sin registro",0.02,{"$f":"IF(S88=\"No Aplica\",0,(U88+W88+Y88+AA88+AC88))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Aplica","Preventivo",0.35,"Automático",0.3,"Documentado",0.1,"Aleatoria",0.05,"Con registro",0.1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]

{"sheet":"Matriz de Calor (Zona)","index":1,"n_rows":68,"n_cols":16,"rows_kept":68,"cut":false,"hidden":false,"merged":[[8,4,12,4],[5,6,6,10],[1,4,2,12],[50,6,51,10],[53,4,57,4]]}
[]
[null,null,null,null,"MATRIZ DE CALOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulación Zona\nRiesgo Inherente","Formulación tipo de control"]
[null,null,"Zona de Calor",null,null,null,null,null,null,null,null,null,null,null,"Extremo","Probabilidad"]
[null,null,"Muy BajaMayor",null,null,null,null,null,null,null,null,null,null,null,"Alto","Impacto"]
[null,null,null,null,null,null,"IMPACTO",null,null,null,null,null,null,null,"Moderado","No Aplica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bajo"]
[]
[null,null,null,null,"PROBABILIDAD","Muy Alta\n100%",{"$f":"IF(C5=\"Muy AltaLeve\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"Muy AltaMenor\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"Muy AltaModerado\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"Muy AltaMayor\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"Muy AltaCatastrófico\",\"EXTREMO\",\"E\")","v":"E"},null,"Extremo"]
[null,null,null,null,null,"Alta\n80%",{"$f":"IF(C5=\"AltaLeve\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"AltaMenor\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"AltaModerado\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"AltaMayor\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"AltaCatastrófico\",\"EXTREMO\",\"E\")","v":"E"},null,"Alto"]
[null,null,null,null,null,"Media\n60%",{"$f":"IF(C5=\"MediaLeve\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"MediaMenor\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"MediaModerado\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"MediaMayor\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"MediaCatastrófico\",\"EXTREMO\",\"E\")","v":"E"},null,"Moderado"]
[null,null,null,null,null,"Baja\n40%",{"$f":"IF(C5=\"BajaLeve\",\"BAJO\",\"B\")","v":"B"},{"$f":"IF(C5=\"BajaMenor\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"BajaModerado\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"BajaMayor\",\"ALTO\",\"A\")","v":"A"},{"$f":"IF(C5=\"BajaCatastrófico\",\"EXTREMO\",\"E\")","v":"E"},null,"Bajo"]
[null,null,null,null,null,"Muy Baja\n20%",{"$f":"IF(C5=\"Muy BajaLeve\",\"BAJO\",\"B\")","v":"B"},{"$f":"IF('Matriz de Riesgo SI-IDEAM'!AL11=\"Muy BajaMenor\",\"BAJO\",\"B\")","v":"B"},{"$f":"IF(C5=\"Muy BajaModerado\",\"MODERADO\",\"M\")","v":"M"},{"$f":"IF(C5=\"Muy BajaMayor\",\"ALTO\",\"A\")","v":"ALTO"},{"$f":"IF(C5=\"Muy BajaCatastrófico\",\"EXTREMO\",\"E\")","v":"E"}]
[null,null,null,null,null,null,"Leve \n20%","Menor \n40%","Moderado 60%","Mayor\n80%","Catastrófico 100%"]
[]
[]
[]
[null,null,"Formulación (Clasificación Riesgo)","Formulación (Documentación)","Formulación (Frecuencia)","Formulación\n(Evidencia)","Formulación\nTrtamiento"]
[null,null,"Daños Físicos","Documentado","Continua","Con registro","Evitar o Eliminar"]
[null,null,"Ejecución y Administración de Procesos","Sin Documentar","Aleatoria","Sin registro","Reducir o Mitigar"]
[null,null,"Fallas Tecnológicas",null,null,null,"Tansferir o Compartir"]
[null,null,"Fraude Externo",null,null,null,"Aceptar"]
[null,null,"Fraude Interno"]
[null,null,"Relaciones Laborales"]
[null,null,"Usuarios, productos \ny prácticas organizacionales"]
[]
[null,null,"Formulación (Procesos)"]
[null,null,"E_GESTIÓN DE LA PLANEACIÓN"]
[null,null,"E_GESTIÓN DEL SGI "]
[null,null,"E_GESTIÓN DE LAS COMUNICACIONES"]
[null,null,"E_GESTIÓN DE TECNOLOGÍA DE INFORMACIÓN Y COMUNICACIONES"]
[null,null,"E_GESTIÓN DE COOPERACIÓN Y ASUNTOS INTERNACIONALES"]
[null,null,"M_GENERACIÓN DE DATOS E INFORMACIÓN HIDROMETEOROLÓGICA Y AMBIENTAL PARA LA TOMA DE DECISIONES"]
[null,null,"M_GENERACIÓN DE CONOCIMIENTO E INVESTIGACIÓN"]
[null,null,"M_SERVICIOS (Acreditación, Laboratorio, Meteorología Aeronautica, Pronóstico y Redes)"]
[null,null,"M_GESTION DEL SERVICIO AL CIUDADANO"]
[null,null,"A_GESTIÓN DE SERVICIOS ADMINISTRATIVOS"]
[null,null,"A_GESTIÓN DE ALMACÉN E INVENTARIOS"]
[null,null,"A_GESTIÓN JURIDICA Y CONTRACTUAL"]
[null,null,"A_GESTIÓN DEL DESARROLLO DEL TALENTO HUMANO"]
[null,null,"A_GESTIÓN FINANCIERA"]
[null,null,"A_GESTIÓN DOCUMENTAL"]
[null,null,"A_GESTIÓN DE CONTROL DISCIPLINARIO INTERNO"]
[null,null,"EV_EVALUACIÓN Y EL MEJORAMIENTO CONTINUO"]
[null,null,null,null,null,null,"Formulación \n(Probabilidad)","Formulación \n(Impacto)"]
[null,null,null,null,null,null,"Muy Baja","Leve"]
[null,null,null,null,null,null,"Baja","Menor"]
[null,null,null,null,null,null,"Media","Moderado"]
[null,null,null,null,null,null,"Alta","Mayor"]
[null,null,null,null,null,null,"Muy Alta","Catastrófico"]
[null,null,null,null,null,null,"IMPACTO"]
[]
[]
[null,null,null,null,"PROBABILIDAD","Muy Alta\n",{"$f":"CONCATENATE(F54,$G$59)","v":"Muy Alta\nLeve \n"},{"$f":"CONCATENATE(F54,$H$59)","v":"Muy Alta\nMenor \n"},{"$f":"CONCATENATE(F54,$I$59)","v":"Muy Alta\nModerado "},{"$f":"CONCATENATE(F54,$J$59)","v":"Muy Alta\nMayor\n"},{"$f":"CONCATENATE(F54,$K$59)","v":"Muy Alta\nCatastrófico "},null,"Extremo"]
[null,null,null,null,null,"Alta\n","Alta\nLeve \n","Alta\nMenor \n","Alta\nModerado ","Alta\nMayor\n","Alta\nCatastrófico ",null,"Alto"]
[null,null,null,null,null,"Media\n","Media\nLeve \n","Media\nMenor \n","Media\nModerado ","Media\nMayor\n","Media\nCatastrófico ",null,"Moderado"]
[null,null,null,null,null,"Baja\n","Baja\nLeve \n","Baja\nMenor \n","Baja\nModerado ","Baja\nMayor\n","Baja\nCatastrófico ",null,"Bajo"]
[null,null,null,null,null,"Muy Baja\n",{"$f":"CONCATENATE(F58,$G$59)","v":"Muy Baja\nLeve \n"},{"$f":"CONCATENATE(F58,$H$59)","v":"Muy Baja\nMenor \n"},{"$f":"CONCATENATE(F58,$I$59)","v":"Muy Baja\nModerado "},{"$f":"CONCATENATE(F58,$J$59)","v":"Muy Baja\nMayor\n"},{"$f":"CONCATENATE(F58,$K$59)","v":"Muy Baja\nCatastrófico "}]
[null,null,null,null,null,null,"Leve \n","Menor \n","Moderado ","Mayor\n","Catastrófico "]
[]
[]
[]
[null,null,null,null,"PROBABILIDAD","IMPACTO","LLAVE","ZONA DE RIESGO"]
[null,null,null,1,"Muy Baja\n","Leve \n",{"$f":"CONCATENATE(E64,F64)","v":"Muy Baja\nLeve \n"},{"$f":"VLOOKUP(G64,'BD ID COLOR'!$A$2:$B$27,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,2,"Baja\n","Leve \n",{"$f":"CONCATENATE(E65,F65)","v":"Baja\nLeve \n"},{"$f":"VLOOKUP(G65,'BD ID COLOR'!$A$2:$B$27,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,3,"Media\n","Mayor\n","Media\nMayor\n",{"$f":"VLOOKUP(G66,'BD ID COLOR'!$A$2:$B$27,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,4,"Baja\n","Leve \n","Baja\nLeve \n",{"$f":"VLOOKUP(G67,'BD ID COLOR'!$A$2:$B$27,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,5,"Media\n","Moderado ","Media\nModerado ",{"$f":"VLOOKUP(G68,'BD ID COLOR'!$A$2:$B$27,2,0)","v":{"$error":"#N/A"}}]

{"sheet":"CONTROL DE CAMBIOS","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,2,3,10],[5,2,5,4],[5,5,5,6],[5,7,5,10],[6,2,6,4],[6,5,6,6],[6,7,6,10],[7,2,7,4],[7,5,7,6],[7,7,7,10],[8,2,8,4],[8,5,8,6],[8,7,8,10],[12,2,12,4],[12,5,12,7],[12,8,12,10],[9,2,9,4],[9,5,9,6],[9,7,9,10],[11,2,11,4],[11,5,11,7],[11,8,11,10]]}
[]
[]
[]
[null,null,"CONTROL DE CAMBIOS"]
[]
[null,null,"VERSIÓN",null,null,"FECHA",null,"DESCRIPCIÓN"]
[null,null,1,null,null,"2019-04-29",null,"Creación del Documento"]
[null,null,2,null,null,"2020-07-21",null,"Eliminación de  columnas repetidas en el documento y unificación del código de identificación."]
[null,null,3,null,null,"2021-09-09",null,"Eliminación de  columnas repetidas en el documento y formulacion de etiquetado"]
[null,null,4,null,null,"2022-03-17",null,"Se agregan nuevas columnas a la herramienta, se formula ( Confidencialidad, Disponibilidad, Integridad), acorde la guia 5 de Mintic,\nSe formula el etiquetado automático de los activos de información, se calcula la criticidad del activo.\nSe dispone de un formulario que complementa la herramienta levantamiento activos de información, a este se le agregó: Hora y fecha de diligenciamiento, correo electrónico Listado Dependencias, Listado de Idiomas, Listado Contenedor del Activo, Listado de Formatos, Listado de Procesos. "]
[]
[null,null,"ELABORÓ:",null,null,"REVISÓ:\n\n\n",null,null,"APROBÓ:\n\n\n"]
[null,null,"\n\n\n\n\n\n\nGUILLERMO OTÁLORA LUNA \nOFICIAL DE SEGURIDAD ",null,null,"\n\n\n\n\n\n\nEDUARDO EMILIO RAMIREZ ACOSTA\nCOORDINADOR GRUPO DE ARQUITECTURA EMPRESARIAL Y SEGURIDAD DE LA INFORMACIÓN",null,null,"ALICIA BARÓN LEGUIZAMÓN\nJEFE OFICINA INFORMATICA"]

{"sheet":"Mapa Vulnerabilidades","index":3,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,"Tipo","Implementación","Implementación","valor"]
[null,null,null,null,null,null,null,"Preventivo",25,"Automático",25]
[null,null,null,null,"FORMULACIÓN VULNERABILIDADES",null,null,"Detectivo",15,"Manual",15]
[null,null,null,null,"Falta de capacitación y entrenamiento para las funciones asignadas",null,null,"Correctivo",10]
[null,null,null,null,"Inadecuado control de acceso lógico y/o físico a los activos de información"]
[null,null,null,null,"Errores en la información obtenida de la fuente primaria"]
[null,null,null,null,"Inexistencia de mantenimientos predictivos, preventivos y/o correctivos o no adecuados de acuerdo con lo estipulado por el fabricante."]
[null,null,null,null,"Mantenimiento relacionado con la infraestructura física, soporte eléctrico, ambiental y tecnológico"]
[null,null,null,null,"Fallas en la infraestructura de IT"]
[null,null,null,null,"Fallas en la transmisión de los datos porque la batería se descarga (panel solar), lo que genera rangos negativos y otro tipo de inconsistencias"]
[null,null,null,null,"Inadecuada ubicación de las estaciones"]
[null,null,null,null,"Se encuentra configurado un servicio FTP plano"]
[null,null,null,null,"Fallas en el disco duro"]
[null,null,null,null,"No existe gestión de vulnerabilidades técnicas"]
[null,null,null,null,"El servidor es visible desde Internet y allí se encuentra el servicio de DA"]
[null,null,null,null,"Fallas técnicas"]
[null,null,null,null,"Deficiencias en el control de acceso físico"]
[null,null,null,null,"Existencia de otras aplicaciones en el mismo servidor"]
[null,null,null,null,"Credenciales de Administración compartidas (Sistemas de Información Geográfica y Administrador Hydras)"]
[null,null,null,null,"Fallas en el suministro eléctrico"]
[null,null,null,null,"Ancho de banda deficiente"]
[null,null,null,null,"Deficiencias en el diseño del modelo de la BD y el desarrollo de la aplicación"]
[null,null,null,null,"Inadecuada gestión de cambios"]
[null,null,null,null,"Fallas en el suministro eléctrico / Falta de mantenimiento preventivo a los servidores"]
[null,null,null,null,"Deficiencias en los controles de acceso de personal externo (soporte técnico) Los proveedores\nexternos que hacen mantenimiento tienen acceso a producción"]
[null,null,null,null,"Falta de conocimiento sobre seguridad de la información"]
[null,null,null,null,"Falta de conciencia sobre la seguridad de la información"]
[null,null,null,null,"Carencia de un presupuesto para operación y mantenimiento de TI, y/o dificultad para su ejecución"]
[null,null,null,null,"Carencia de personal idóneo para el uso de tecnologías y/o software"]
[null,null,null,null,"Falta de Abastecimiento de servicios públicos básicos: energía, agua, gas, aire acondicionado\nFalta de documentación de los servicios y/o aplicaciones"]
[null,null,null,null,"Falta de políticas/normas/procedimientos de seguridad de la información"]
[null,null,null,null,"Falta de segregación de las funciones"]
[null,null,null,null,"Falta y/o inadecuada clasificación de activos de información"]
[null,null,null,null,"Inconformidad de los empleados y/o mal ambiente de trabajo"]
[null,null,null,null,"Inexistencia de respaldo y/o custodia de los activos de información"]
[null,null,null,null,"No existencia de un proceso de gestión de incidentes"]
[null,null,null,null,"Planeación de la capacidad de la plataforma inexistente o poco eficiente"]
[null,null,null,null,"Inadecuada prevención y detección de incendios"]
[null,null,null,null,"Inadecuada selección de personal para ingreso a la organización"]
[null,null,null,null,"Falta de mecanismos de monitoreo"]
[null,null,null,null,"Falta de revocación de los derechos de acceso al activo de información una vez el funcionario cambie de rol o se retire de la organización"]
[null,null,null,null,"Carencia de procedimientos adecuados de reutilización de medios y computadores"]
[null,null,null,null,"Acceso físico no autorizado"]
[null,null,null,null,"Ataques de Phishing "]
[null,null,null,null,"Falta de protección contra virus y código malicioso"]
[null,null,null,null,"Falla en la custodia de credenciales\n"]
[null,null,null,null,"Otra"]

{"sheet":"PROBABILIDAD","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,5,1,7],[4,2,4,3]]}
[null,null,null,null,null,null,null,null,null,null,"Formulación \n(Probabilidad)"]
[null,null,null,null,null,"DETERMINACIÓN DE LA PROBABILIDAD",null,null,null,null,"Muy Baja"]
[null,null,null,null,null,null,null,null,null,null,"Baja"]
[null,null,null,null,null,null,null,null,null,null,"Media"]
[null,null,null,null,null,null,null,null,null,null,"Alta"]
[null,null,null,null,null,null,"Frecuencia de la Actividad","Probabilidad",null,null,"Muy Alta"]
[null,null,null,null,null,"Muy Baja","La actividad que conlleva el riesgo se ejecuta como máximos 2 veces por año ",0.2]
[null,null,null,null,null,"Baja ","La actividad que conlleva el riesgo se ejecuta de\n3 a 24 veces por año",0.4]
[null,null,null,null,null,"Media ","La actividad que conlleva el riesgo se ejecuta de\n24 a 500 veces por año \n",0.6]
[null,null,null,null,null,"Alta ","La actividad que conlleva el riesgo se ejecuta\nmínimo 500 veces al año y máximo 5000 veces\npor año\n",0.8]
[null,null,null,null,null,"Muy Alta ","La actividad que conlleva el riesgo se ejecuta más\nde 5000 veces por año ",1]

{"sheet":"IMPACTO","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,5,1,7]]}
[null,null,null,null,null,null,null,null,null,null,"Formulación","Formulación"]
[null,null,null,null,null,"DETERMINACIÓN DE IMPACTO",null,null,null,null,"Leve","Económica"]
[null,null,null,null,null,null,null,null,null,null,"Menor","Reputación"]
[null,null,null,null,null,null,null,null,null,null,"Moderado","Económica y \nReputación"]
[null,null,null,null,null,null,null,null,null,null,"Mayor"]
[null,null,null,null,null,"Afectación Información","Afectación Económica","Reputacional","Impacto",null,"Catastrófico"]
[null,null,null,null,"Leve 20%","No existe afectación al recurso","Afectación menor a 10 SMLMV ","El riesgo afecta la imagen de algún área de la organización.",0.2]
[null,null,null,null,"Menor 40%","El evento no afecta información confidencial ni estratégica o no Importante para la \ncontinuidad del negocio","Entre 10 y 50 SMLMV ","El riesgo afecta la imagen de la entidad\ninternamente, de conocimiento general nivel interno, de junta directiva y accionistas y/o de proveedores",0.4]
[null,null,null,null,"Moderado 60%","El evento no afecta información confidencial ni estratégica o poco Importante para \nla continuidad del negocio.","Entre 50 y 100 SMLMV \n","El riesgo afecta la imagen de la entidad con algunos usuarios de relevancia frente al logro de los objetivos.",0.6]
[null,null,null,null,"Mayor 80%","El evento puede afectar información confidencial o estratégica o Importante para la \ncontinuidad del negocio.","Entre 100 y 500 SMLMV ","El riesgo afecta la imagen de la entidad con efecto publicitario sostenido a nivel de sector administrativo, nivel departamental o municipal.",0.8]
[null,null,null,null,"Catastrófico 100%","El evento afecta información confidencial o estratégica o indispensable Para \ncontinuidad del negocio","Mayor a 500 SMLMV ","El riesgo afecta la imagen de la entidad a nivel nacional, con efecto publicitario sostenido a nivel país",1]

{"sheet":"Matriz Opciones Riesgo","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,4,2,12],[5,6,6,10],[8,4,12,4]]}
[]
[null,null,null,null,"MATRIZ DE CALOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulación Zona\nRiesgo Inherente"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extremo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alto"]
[null,null,null,null,null,null,"IMPACTO",null,null,null,null,null,null,null,"Moderado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bajo"]
[]
[null,null,null,null,"PROBABILIDAD","Casi Certeza\n5","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir"]
[null,null,null,null,null,"Probable\n4","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir"]
[null,null,null,null,null,"Posible\n3","Asumir ","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir"]
[null,null,null,null,null,"Improbable\n2","Asumir ","Asumir ","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir"]
[null,null,null,null,null,"Raro\n1","Asumir ","Asumir ","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir","Evitar, reducir, Compartir, Transferir"]
[null,null,null,null,null,null,"Sin Afectación\n1","Leve\n2","Moderado \n3","Crítico\n4","Muy Crítico\n5"]

{"sheet":"BD ID COLOR","index":7,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["COMBINACIONES","ZONA"]
["Muy AltaLeve","ALTO"]
["Muy AltaMenor","ALTO"]
["Muy AltaModerado","ALTO"]
["Muy AltaMayor","ALTO"]
["Muy AltaCatastrófico","EXTREMO"]
["AltaLeve","MODERADO"]
["AltaMenor","MODERADO"]
["AltaModerado","ALTO"]
["AltaMayor","ALTO"]
["AltaCatastrófico","EXTREMO"]
["MediaLeve","MODERADO"]
["MediaMenor","MODERADO"]
["MediaModerado","MODERADO"]
["MediaMayor","ALTO"]
["MediaCatastrófico","EXTREMO"]
["BajaLeve","BAJO"]
["BajaMenor","MODERADO"]
["BajaModerado","MODERADO"]
["BajaMayor","ALTO"]
["BajaCatastrófico","EXTREMO"]
["Muy BajaLeve","BAJO"]
["Muy BajaMenor","BAJO"]
["Muy BajaModerado","MODERADO"]
["Muy BajaMayor","ALTO"]
["Muy BajaCatastrófico","EXTREMO"]

{"sheet":"CONTROLES","index":8,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"DOMINIOS"]
[null,"A.5_POLÍTICAS_DE_SEGURIDAD_DE_LA_INFORMACIÓN",null,null,null,"A.5 POLÍTICAS DE SEGURIDAD DE LA INFORMACIÓN","A.6 ORGANIZACIÓN DE LA SEGURIDAD DE LA INFORMACIÓN","A.7 SEGURIDAD DE LOS RECURSOS HUMANOS","A.8 GESTIÓN DE ACTIVOS","A.9 CONTROL DE ACCESOS","A.10 CRIPTOGRAFÍA","A.11 SEGURIDAD FÍSICA Y DEL ENTORNO","A.12 SEGURIDAD DE LAS OPERACIONES","A.13 SEGURIDAD DE LAS COMUNICACIONES","A.14 ADQUISICIÓN, DESARROLLO Y MANTENIMIENTO DE SISTEMAS ","A.15 RELACIONES CON LOS PROVEEDORES ","A.16 GESTIÓN DE INCIDENTES DE SEGURIDAD DE LA INFORMACIÓN ","A.17 ASPECTOS DE SEGURIDAD DE LA INFORMACIÓN DE LA GESTIÓN DE CONTINUIDAD DEL NEGOCIO ","A.18 CUMPLIMIENTO"]
[null,"A.6_ORGANIZACIÓN_DE_LA_SEGURIDAD_DE_LA_INFORMACIÓN",null,null,null,"A5.1.1 Políticas para la seguridad de la información","A.6.1.1 Roles y responsabilidades para la seguridad de la información ","A.7.1.1 Selección","A.8.1.1 Inventario de activos","A.9.1.1 Política de control de acceso","A.10.1.1 Política sobre el uso de controles criptográficos ","A.11.1.1 Perímetro de seguridad física","A.12.1.1 Procedimientos de operación documentados","A.13.1.1 Controles de redes","A.14.1.1 Análisis y especificación de requisitos de seguridad de la información","A.15.1.1 Política de seguridad de la información para las relaciones con proveedores","A.16.1.1 Responsabilidades y procedimientos","A.17.1.1 Planificación de la continuidad de la seguridad de la información ","A.18.1.1 Identificación de la legislación aplicable y de los requisitos contractuales"]
[null,"A.7_SEGURIDAD_DE_LOS_RECURSOS_HUMANOS",null,null,null,"A.5.1.2 Revisión de las políticas para la seguridad de la información","A.6.1.2  Separación de deberes","A.7.1.2 Términos   y   condiciones  del empleo","A.8.1.2 Propiedad de los activos","A.9.1.2 Acceso a redes y a servicios en red","A.10.1.2 Gestión de llaves","A.11.1.2 Control de accesos físicos ","A.12.1.2 Gestión de cambios","A.13.1.2 Seguridad de los servicios de red","A.14.1.2 Seguridad de servicio de las aplicaciones en redes publicas","A.15.1.2 Tratamiento de la seguridad dentro de los acuerdos con proveedores","A.16.1.2 Reporte de eventos de seguridad de la información","A.17.1.2 Implementación de la continuidad de la seguridad de la información","A.18.1.2 Derechos de propiedad intelectual"]
[null,"A.8_GESTIÓN_DE_ACTIVOS",null,null,null,null,"A.6.1.3  Contacto con las autoridades","A.7.2.1 Responsabilidades de la\ndirección","A.8.1.3 Uso aceptable de los activos","A.9.2.1 Registro  y   cancelación del registro de usuarios",null,"A.11.1.3 Seguridad  de  oficinas, recintos e instalaciones","A.12.1.3 Gestión de capacidad","A.13.1.3 Separación en las redes","A.14.1.3 Protección de transacciones de los servicios de las aplicaciones ","A.15.1.3 Cadena de suministro de tecnología de información y comunicación","A.16.1.3 Reporte de debilidades de seguridad de la información","A.17.1.3 Verificación, revisión y evaluación de la continuidad de la seguridad de la información","A.18.1.3 Protección de registros"]
[null,"A.9_CONTROL_DE_ACCESOS",null,null,null,null,"A.6.1.4  Contacto con grupos de interés especial","A.7.2.2 Toma de conciencia, educación y formación en la seguridad de la información","A.8.1.4 Devolución de activos","A.9.2.2 Suministro de acceso de usuarios",null,"A.11.1.4 Protección contra amenazas externas y ambientales","A.12.1.4 Separación  de los ambientes de desarrollo, pruebas, y operación","A.13.2.1 Políticas y procedimientos de transferencia de información","A.14.2.1 Políticas de desarrollo seguro ","A.15.2.1 Seguimiento y revisión a los servicios proveedores ","A.16.1.4 Evaluación de eventos de seguridad de la información y decisiones sobre ellos","A.17.2.1 Disponibilidad de instalaciones de procesamiento de información.","A.18.1.4 Privacidad y protección de información de datos personales"]
[null,"A.10_CRIPTOGRAFÍA",null,null,null,null,"A.6.1.5 Seguridad de la información en la gestión de proyectos","A.7.2.3 Proceso disciplinario","A.8.2.1 Clasificación de la información","A.9.2.3 Gestión de derechos de acceso privilegiado",null,"A.11.1.5 Trabajo en áreas seguras\n","A.12.2.1 Controles contra códigos maliciosos ","A.13.2.2 Acuerdos sobre transferencia de información","A.14.2.2 Procedimiento de control de cambios en sistemas ","A.15.2.2 Gestión de cambios en los\nservicios de los proveedores","A.16.1.5 Respuesta a incidentes de seguridad de la información ",null,"A.18.1.5 Reglamentación  de  controles criptográficos"]
[null,"A.11_SEGURIDAD_FÍSICA_Y_DEL_ENTORNO",null,null,null,null,"A.6.2.1 Política para dispositivos móviles","A.7.3.1 Terminación   o   cambio   de responsabilidades de empleo","A.8.2.2 Etiquetado de la información ","A.9.2.4 Gestión de  información de autenticación secreta de usuarios",null,"A.11.1.6 Áreas de despacho y carga","A.12.3.1 Respaldo de la información ","A.13.2.3 Mensajería electrónica","A.14.2.3 Revisión técnica de las aplicaciones después de cambios en la plataforma de operación ",null,"A.16.1.6 Aprendizaje obtenido de los incidentes de seguridad de la información",null,"A.18.2.1 Revisión independiente de la\nseguridad de la información"]
[null,"A.12_SEGURIDAD_DE_LAS_OPERACIONES",null,null,null,null,"A.6.2.2 Teletrabajo",null,"A.8.2.3 Manejo de activos","A.9.2.5 Revisión de los derechos de acceso de usuarios",null,"A.11.2.1 Ubicación y protección de los equipos ","A.12.4.1 Registro de eventos ","A.13.2.4 Acuerdos de confidencialidad o de no divulgación","A.14.2.4 Restricción en los cambios a los paquetes de software ",null,"A.16.1.7 Recolección de evidencia ",null,"A.18.2.2 Cumplimiento con las políticas y normas de seguridad"]
[null,"A.13_SEGURIDAD_DE_LAS_COMUNICACIONES",null,null,null,null,null,null,"A.8.3.1 Gestión de medios removibles","A.9.2.6 Retiro o ajuste de los derechos de acceso",null,"A.11.2.2 Servicios de suministro","A.12.4.2 Protección de la información de registro",null,"A.14.2.5 Principios de construcción de los sistemas seguros",null,null,null,"A.18.2.3 Revisión del cumplimiento técnico"]
[null,"A.14_ADQUISICIÓN_DESARROLLO_Y_MANTENIMIENTO_DE_SISTEMAS ",null,null,null,null,null,null,"A.8.3.2 Disposición de los medios","A.9.3.1 Uso de información de autenticación secreta",null,"A.11.2.3 Seguridad del cableado","A.12.4.3 Registros del administrador y del operador",null,"A.14.2.6 Ambiente seguro de desarrollo"]
[null,"A.15_RELACIONES_CON_LOS_PROVEEDORES ",null,null,null,null,null,null,"A.8.3.3 Transferencia de medios físicos","A.9.4.1 Restricción de acceso  a la información",null,"A.11.2.4 Mantenimiento de equipos","A.12.4.4 Sincronización de reloj",null,"A.14.2.7 Desarrollo externamente contratado"]
[null,"A.16_GESTIÓN_DE_INCIDENTES_DE_SEGURIDAD_DE_LA_INFORMACIÓN ",null,null,null,null,null,null,null,"A.9.4.2 Procedimiento de ingreso seguro",null,"A.11.2.5 Retiro de activos","A.12.5.1 Instalación  de  software   en sistemas operativos",null,"A.14.2.8 Pruebas de seguridad de sistemas"]
[null,"A.17_ASPECTOS_DE_SEGURIDAD_DE_LA_INFORMACIÓN_DE_LA_GESTIÓN_DE_CONTINUIDAD_DEL_NEGOCIO ",null,null,null,null,null,null,null,"A.9.4.3 Sistema  de gestión de contraseñas",null,"A.11.2.6 Seguridad de activos y equipos fuera de la oficina","A.12.6.1 Gestión de las vulnerabilidades técnicas",null,"A.14.2.9 Prueba de aceptación de sistemas "]
[null,"A.18_CUMPLIMIENTO",null,null,null,null,null,null,null,"A.9.4.4 Uso de programas utilitarios privilegiados",null,"A.11.2.7 Disposición segura o reutilización de equipos","A.12.6.2 Restricciones sobre la instalación de software",null,"A.14.3.1 Protección de datos de pruebas "]
[null,null,null,null,null,null,null,null,null,"A.9.4.5 Control   de   acceso   a códigos fuente de programas",null,"A.11.2.8 Equipos de usuario desatendido","A.12.7.1 Controles de auditorías de sistemas de información"]
[null,null,null,null,null,null,null,null,null,null,null,"A.11.2.9 Políticas de escritorio limpio y pantalla limpia"]