{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1 - Instrucciones","2 - Identificacion Preliminar","3 - Identificacion de riesgos","4 - Planificacion y gestión","Historico","Análisis","Matriz de Riesgos","Parametros"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":"1 - Instrucciones","index":0,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,2,43,6],[9,4,9,5],[11,4,11,5],[12,4,12,5],[25,2,25,6],[28,2,28,6],[10,4,10,5],[31,2,31,6],[34,2,34,6],[37,2,37,6],[40,2,40,6]]}
[]
[]
[]
[]
[]
[]
[]
[1,"Datos Básicos del Proyecto"]
[]
[null,"Nombre de Aplicación:",null,null,"-------------------------------------------------------------------------------------------"]
[null,"VERSIÓN:",null,null,"-------------------------------------------------------------------------------------------"]
[null,"Jefe de Proyecto",null,null,"-------------------------------------------------------------------------------------------"]
[null,"Proveedor",null,null,"-------------------------------------------------------------------------------------------"]
[null,{"$f":"CONCATENATE(\"Cantidad de Riesgos Identificados: \",'Matriz de Riesgos'!K14+'Matriz de Riesgos'!K15+'Matriz de Riesgos'!K16)","v":"Cantidad de Riesgos Identificados: 0"}]
[null,{"$f":"CONCATENATE(\"Cantidad de Riesgos Alto Impacto: \",'Matriz de Riesgos'!K14)","v":"Cantidad de Riesgos Alto Impacto: 0"}]
[]
[]
[2,"Instructivo de uso"]
[]
[null,"Hojas del Excel"]
[]
[null,"1 - Instrucciones"]
[null,null,"Llenar campos de Nombre de Aplicación,  VERSIÓN, Jefe de Proyecto y Proveedor"]
[]
[null,"2 - Identificacion Preliminar"]
[null,null,"Responder a las Preguntas que apliquen a su VERSIÓN si Representa un riesgo la temática planteada a la Pregunta, responda SI. Si la respuesta fue SI indicar el impacto de la ocurrencia del riesgo identificado y redactar el texto del Riesgo identificado. De responder NO / No aplica, no hacer nada. Si se encuentra más de un riesgo por Pregunta, insertar filas debajo de la Pregunta que origina los Riesgos. Si hay un riesgo que no surja de una Pregunta ponerlo directamente en la hoja: \"3 - Identificación de Riesgos\". Si hay preguntas que no estén en el cuestionario enviar solicitud a Servicios Horizontales para evaluar su inclusión en el listado y poner su Riesgo asociado directamente en la hoja: \"3 - Identificación de Riesgos\".\nNOTA: no poner los Riesgos más de una vez."]
[]
[null,"3 - Identificacion de Riesgos"]
[null,null,"Se incorporan los Riesgos hallados a través de las Preguntas, se incorporan otros Riesgos no derivados de las Preguntas de la hoja \"2 - Identificación Preliminar\". Se asigna Categoría y SubCategoría para el Riesgo hallado (de no existir una Categoría y/o SubCategoría adecuada se plantea el caso a Servicios Horizontales para efectuar la revisión de las mismas) "]
[]
[null,"4 - Planificación y Gestión"]
[null,null,"Se marcan los Riesgos por su Id, luego se pone su Probabilidad e Impacto. Se Priorizan los Riesgos presionando el botón correspondiente. Para los Riegos que Propuestos se realiza la Gestión, el Plan de Mitigación y el Plan de Contingencia (en la hoja se completan los datos correspondientes) "]
[]
[null,"Histórico"]
[null,null,"Cada vez que se presiona el botón Generar Histórico se ingresa una nueva línea que contiene la cantidad de Riesgos por Estado"]
[]
[null,"Análisis"]
[null,null,"Gráficas que muestran los Riesgos por estado Actuales (en una) y el Histórico de los estados de los Riesgos (en la otra)."]
[]
[null,"Matriz Riesgos"]
[null,null,"Matriz de Riesgos, muestra los Riesgos por Zonas (Verde, Amarillo y Rojo)."]
[]
[null,"Parámetros"]
[null,null,"Hoja donde se muestran los distintos Parámetros que vienen por Defecto (Impacto si ocurre Riesgo Respuesta a la Pregunta, Respuestas si Representa un riesgo, Impacto del Riesgo, Estados para riesgos, Probabilidad %, Motivos para cambios de estado, Categoría y Sub-categoría)"]

{"sheet":"2 - Identificacion Preliminar","index":1,"n_rows":194,"n_cols":16,"rows_kept":194,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Preguntas para identificar riesgos a partir de las fuentes que los originan"]
[]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE(\"Cantidad de Riesgos Identificados: \",COUNTA(D14:D194))","v":"Cantidad de Riesgos Identificados: 1"},null,null,null,null,null,null,null,null,null,null,null,"SI",null,"Alto"]
[null,{"$f":"CONCATENATE(\"Cantidad de Riesgos Alto Impacto: \",COUNTIFS(C14:C194,\"NO\",E14:E194,\"Alto\"))","v":"Cantidad de Riesgos Alto Impacto: 0"},null,null,null,null,null,null,null,null,null,null,null,"NO",null,"Bajo"]
[null,null,"Representa un riesgo \n(SI/NO/No aplica)","Riesgos identificados","Impacto si ocurre (Alto/Bajo/No aplica)",null,null,null,null,null,null,null,null,"No aplica",null,"No aplica"]
[]
[null,"Riesgos relativos a SAS"]
[null,"La alta gerencia está comprometida con el proyecto","SI","si","Alto"]
[null,"La solución tiene claros beneficios para el SAS",null,null,{"$f":"IF(OR(C15=\"NO\",C15=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,"El proyecto está alineado a la estrategia de la Organización",null,null,""]
[null,"Está claramente definida y comunicada la estrategia a seguir con el proyecto",null,null,""]
[null,"El proyecto está directamente relacionado con alguna de las metas del SAS",null,null,""]
[null,"Se cuenta con el compromiso de las demás áreas que intervienen en el proyecto",null,null,""]
[null,"Todas las áreas involucradas en el proyecto están comprometidas a apoyar al proyecto con los recursos necesarios en los momentos oportunos",null,null,""]
[null,"Otras áreas del SAS además del área que gerencia el proyecto, poseen necesidades del mismo",null,null,""]
[null,"Otras áreas del SAS además de la que gerencia el proyecto, tienen tareas asignadas al proyecto dentro de sus actividades",null,null,""]
[null,"Las áreas que participan y no están a cargo de la gerencia del proyecto tienen definida claramente la carga y tiempos necesarios para realizar las tareas asignadas",null,null,""]
[null,null,null,null,{"$f":"IF(OR(C24=\"NO\",C24=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,"Riesgos relativos a las organizaciones participantes del proyecto",null,null,""]
[null,"Se poseen experiencias anteriores de trabajo entre las organizaciones participantes del proyecto? ¿Se conocen las lecciones aprendidas de dichas experiencias",null,null,""]
[null,"El proyecto está directamente alineado a la estrategia de SAS y las partes que intervienen",null,null,""]
[null,"Está claramente definida y comunicada la estrategia para todas las partes del proyecto",null,null,""]
[null,"La solución tiene claros beneficios percibidos por el usuario",null,null,""]
[null,"La solución a implementar en el proyecto es conocida y comprendida por la alta gerencia",null,null,""]
[null,"La alta gerencia está comprometida con el proyecto",null,null,""]
[null,"El compromiso de la alta gerencia está escrito y firmado por ambas partes",null,null,""]
[null,"Se posee certeza que el compromiso político por la alta dirección de los involucrados perdurará durante toda la ejecución del proyecto. El proyecto trasciende un período de gobierno",null,null,""]
[null,"El Resonsable Funcional comprende y comparte el uso de la metodología de trabajo planteada para el proyecto",null,null,""]
[null,"El Responsable Funcional comprende y garantiza la carga de trabajo que el proyecto le demandará. Posee las capacidades necesarias en recursos y tiempos para la ejecución del proyecto",null,null,""]
[null,"El Responsable Funcional posee las capacidades necesarias para la operación y evolución del producto del proyecto",null,null,""]
[null,"El Responsable Funcional ha comprendido la importancia de su participación en las instancias de revisión de los requerimientos, además del riesgo que implica su falta de dedicación",null,null,""]
[null,"El Responsable Funcional ha definido y comunicado claramente los roles de los actores relacionados al proyecto",null,null,""]
[null,"El proyecto involucra diferentes áreas organizacionales (áreas, departamentos, oficinas)",null,null,""]
[null,"Se tiene un área de tecnología involucrada en el proyecto",null,null,""]
[null,"Se tiene experiencia previa en herramientas similares a las que plantea este proyecto",null,null,""]
[null,"Se tiene una idea clara de lo que pretende la solución",null,null,""]
[null,null,null,null,""]
[null,"Riesgos respecto a factores tecnológicos",null,null,""]
[null,"Se posee experiencia con tecnologías similares. Se poseen las lecciones aprendidas de estas experiencias",null,null,""]
[null,"El equipo técnico posee experiencia en proyectos de este tipo",null,null,""]
[null,"La solución tiene interacción con otros sistemas claves",null,null,""]
[null,"La solución administra o debe cumplir restricciones que puedan afectar legal o económicamente",null,null,""]
[null,"Más del 60% de la solución es nueva",null,null,""]
[null,"La solución posee requerimientos estrictos de performance, seguridad o confidencialidad",null,null,""]
[null,null,null,null,""]
[null,"Riesgo relativos al proveedor de la solución",null,null,""]
[null,"El proveedores tiene conocimiento y experiencia en las tecnologías del proyecto",null,null,{"$f":"IF(OR(C53=\"NO\",C53=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,"Se posee experiencia con el proveedor. Se tiene acceso a las lecciones aprendidas de dichas experiencias",null,null,""]
[null,"El proveedor ha producido software o brindado un servicio similar al necesario al del proyecto anteriormente",null,null,""]
[null,"El equipo técnico del proveedor asignado al proyecto posee experiencia en proyectos de este tipo",null,null,""]
[null,"Se poseen experiencias anteriores de trabajo con el proveedor",null,null,""]
[null,"Las experiencias anteriores con el proveedor han sido exitosas",null,null,""]
[null,"El proveedor tiene una idea clara de lo que se pretende de la solución",null,null,""]
[null,"El proveedor participó en los requerimientos del proyecto",null,null,""]
[null,null,null,null,""]
[null,"Riesgo relativos a la gestión del proyecto ",null,null,""]
[null,"Los objetivos del proyecto están definidos",null,null,""]
[null,"El proyecto está claramente definido en todas sus etapas",null,null,""]
[null,"Están claramente definidos y comunicados los roles en el proyecto",null,null,""]
[null,"Todos los integrantes del equipo conocen claramente lo que se espera de ellos",null,null,""]
[null,"Las personas designadas al proyecto tienen las competencias adecuadas para los roles que van a desempeñar",null,null,""]
[null,"Las personas designadas al proyecto tienen experiencia relacionada a los productos o servicios que incluye el proyecto",null,null,""]
[null,"El proyecto depende de otros proyectos de la organización",null,null,""]
[null,"Se posee acceso a información relevante de los proyectos de los cuales se depende",null,null,""]
[null,"Los proyectos de los cuales se depende, poseen una correcta gestión, apoyo de la alta dirección de los organismos involucrados, presupuesto suficiente y las capacidades necesarias para su correcta ejecución",null,null,""]
[null,"El análisis de las necesidades de los usuarios es claro. Está documentado",null,null,""]
[null,"El análisis de las necesidades de los usuarios está validado y aceptado por todas las partes involucradas en el proyecto",null,null,""]
[null,"Se involucraron a los actores claves para la elaboración del cronograma tentativo",null,null,""]
[null,"Los tiempos son razonables y compatibles con los recursos de las partes involucradas",null,null,""]
[null,"El cronograma está muy apretado o se planificó utilizando colchones y tiempos pesimistas",null,null,""]
[null,"Se tiene claramente identificada la cadena crítica",null,null,""]
[null,"Las partes están de acuerdo con el cronograma",null,null,""]
[null,"El deadline para la implementación es razonable",null,null,""]
[null,"Está claramente definido el alcance y aceptado por todas las partes",null,null,""]
[null,"Se explicitan los puntos dudosos del alcance aclarando si están comprendidos o no",null,null,""]
[null,"Las tareas del cronograma cubren el 100 % del alcance",null,null,""]
[null,"Está claramente definido y aprobado por todas las partes las HBS",null,null,""]
[null,"Se incluyeron imprevistos en el presupuesto",null,null,{"$f":"IF(OR(C84=\"NO\",C84=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,"Existen costos económicos o de negocio asociados a la entrega tardía de la solución",null,null,""]
[null,"Existen costos económicos o de negocio asociados a la entrega de la solución con defectos",null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(OR(C112=\"NO\",C112=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(OR(C144=\"NO\",C144=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(OR(C176=\"NO\",C176=\"No aplica\"),\"No aplica\",\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]

{"sheet":"3 - Identificacion de riesgos","index":2,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Identificación de Riesgos - (utilizar para Análisis y Priorización)",null,null,null,"Identificacion de riesgos"]
[]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[]
[null,"ID Riesgo","Título","Descripción","Clasificación / Categoría","Causas","Consecuencias","Destinatario"]
[null,"R001","si"]
[null,"R002"]
[null,"R003"]
[null,"R004"]
[null,"R005"]
[null,"R006"]
[null,"R007"]
[null,"R008"]
[null,"R009"]
[null,"R010"]
[null,"R011"]
[null,"R012"]
[null,"R013"]
[null,"R014"]
[null,"R015"]
[null,"R016"]
[null,"R017"]
[null,"R018"]
[null,"R019"]
[null,"R020"]
[null,"R021"]
[null,"R022"]
[null,"R023"]
[null,"R024"]
[null,"R025"]
[null,"R026"]
[null,"R027"]
[null,"R028"]
[null,"R029"]
[null,"R030"]

{"sheet":"4 - Planificacion y gestión","index":3,"n_rows":3000,"n_cols":22,"rows_kept":3000,"cut":false,"hidden":false,"merged":[[9,17,9,21],[11,1,20,1],[9,13,9,16],[9,8,9,12],[9,2,9,7]]}
[]
[]
[null,null,"Planificación y gestión de riesgos"]
[]
[null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"},null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"},null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[]
[null,null,"Fecha:    ",{"$f":"TODAY()","v":"2018-03-14"}]
[]
[null,null,"Análisis",null,null,null,null,null,"Gestión",null,null,null,null,"Plan de mitigación",null,null,null,"Plan de contingencia"]
[null,null,"ID Riesgo","Título","Probabilidad (Porcentaje)","Impacto (Numerico)","Exposición (Numeric)","Zona","Prioridad","Fecha límite","Estado","Motivo","Fecha estado","Tareas","Fecha inicio","Fecha fin","Recursos","Triggers","Tareas","Fecha inicio","Fecha fin","Recursos"]
[null,"GESTION",null,{"$f":"VLOOKUP(C12,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"ROUND(E12*F12,2)","v":0},{"$f":"IF(OR(AND(F12=10,E12>0.4),AND(F12=8,E12>0.6),AND(F12=6,E12>0.8)),2,IF(OR(AND(F12=10),AND(F12=8,E12>0.2),AND(F12=6,E12>0.4),AND(F12=4,E12>0.6),AND(F12=2,E12>0.8)),1,0))","v":0},{"$f":"IF(AND(G12<>0,K12<>\"99 - CERRADO\",K12<>\"98 - RESUELTO\"),31-(G12*(H12+1)),99)","v":99},null,{"$f":"IF(OR(H12=1,H12=2),\"00 - EN GESTION\",\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP(C13,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C14,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C15,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C16,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C17,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C18,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C19,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,{"$f":"IF(OR(H19=1,H19=2),\"00 - EN GESTION\",\"\")","v":""}]
[null,null,null,{"$f":"VLOOKUP(C20,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C21,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C22,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C23,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C24,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C25,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C26,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C27,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C28,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C29,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C30,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C31,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C32,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C33,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C34,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C35,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C36,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C37,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C38,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C39,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C40,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[null,null,null,{"$f":"VLOOKUP(C41,'3 - Identificacion de riesgos'!$B$11:$G$41,2, FALSE)","v":{"$error":"#N/A"}},null,null,0,0,99,null,""]
[]
[null,null,"Estado","Cantidad"]
[null,null,"00 - EN GESTION",{"$f":"COUNTIF($K$12:$K$41,C44)","v":0}]
[null,null,"01 - ACTIVACION MITIGACION",{"$f":"COUNTIF($K$12:$K$41,C45)","v":0}]
[null,null,"02 - ACTIVACION CONTINGENCIA",{"$f":"COUNTIF($K$12:$K$41,C46)","v":0}]
[null,null,"98 - RESUELTO",{"$f":"COUNTIF($K$12:$K$41,C47)","v":0}]
[null,null,"99 - CERRADO",{"$f":"COUNTIF($K$12:$K$41,C48)","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D44:D48)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Utilizado para inicializar",null,{"$f":"IF(H3000=1,\"02 - PROPUESTO\",\"\")","v":""}]

{"sheet":"Historico","index":4,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Histórico de los riesgos"]
[]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"},null,null,null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"},null,null,null,null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[]
[]
[]
[null,"Semana",{"$f":"Parametros!$B$15","v":"00 - EN GESTION"},{"$f":"Parametros!$B$16","v":"01 - ACTIVACION MITIGACION"},{"$f":"Parametros!$B$17","v":"02 - ACTIVACION CONTINGENCIA"},{"$f":"Parametros!$B$18","v":"98 - RESUELTO"},{"$f":"Parametros!$B$19","v":"99 - CERRADO"},"Total"]
[null,"2018-02-19",4,0,0,1,0,5]
[null,"2018-02-19",0,1,0,0,0,1]
[null,"2018-02-19",1,0,0,0,0,1]
[]
[null,null,null,null,null,null,null,null,null,"Estado","Cantidad"]
[null,null,null,null,null,null,null,null,null,"00 - EN GESTION",{"$f":"COUNTIF('4 - Planificacion y gestión'!$K$12:$K$41,J16)","v":0}]
[null,null,null,null,null,null,null,null,null,"01 - ACTIVACION MITIGACION",{"$f":"COUNTIF('4 - Planificacion y gestión'!$K$12:$K$41,J17)","v":0}]
[null,null,null,null,null,null,null,null,null,"02 - ACTIVACION CONTINGENCIA",{"$f":"COUNTIF('4 - Planificacion y gestión'!$K$12:$K$41,J18)","v":0}]
[null,null,null,null,null,null,null,null,null,"98 - RESUELTO",{"$f":"COUNTIF('4 - Planificacion y gestión'!$K$12:$K$41,J19)","v":0}]
[null,null,null,null,null,null,null,null,null,"99 - CERRADO",{"$f":"COUNTIF('4 - Planificacion y gestión'!$K$12:$K$41,J20)","v":0}]
[null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(K16:K20)","v":0}]

{"sheet":"Análisis","index":5,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Análisis de la evolución de los riesgos"]
[]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[]
[null,"Situación actual de los riesgos del proyecto",null,null,null,null,null,"Fecha:",{"$f":"'4 - Planificacion y gestión'!$D$8","v":"2018-03-14"},null,"Tendencia del estado de riesgos del proyecto",null,null,null,null,null,"Fecha:",{"$f":"'4 - Planificacion y gestión'!$D$8","v":"2018-03-14"}]

{"sheet":"Matriz de Riesgos","index":6,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,1,15,1],[17,3,17,7]]}
[]
[]
[null,"Matriz de riesgos"]
[]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B10,\": \",'1 - Instrucciones'!E10)","v":"Nombre de Aplicación:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B11,\": \",'1 - Instrucciones'!E11)","v":"VERSIÓN:: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B12,\": \",'1 - Instrucciones'!E12)","v":"Jefe de Proyecto: -------------------------------------------------------------------------------------------"}]
[null,{"$f":"CONCATENATE('1 - Instrucciones'!B13,\": \",'1 - Instrucciones'!E13)","v":"Proveedor: -------------------------------------------------------------------------------------------"}]
[]
[null,"Matriz de Riesgos",null,null,null,null,null,null,null,"Fecha:",{"$f":"'4 - Planificacion y gestión'!$D$8","v":"2018-03-14"}]
[]
[null,"Impacto",10,{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,D$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C12)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,E$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C12)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,F$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C12)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,G$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C12)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,H$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C12)","v":0}]
[null,null,8,{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,D$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C13)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,E$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C13)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,F$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C13)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,G$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C13)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,H$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C13)","v":0}]
[null,null,6,{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,D$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C14)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,E$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C14)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,F$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C14)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,G$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C14)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,H$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C14)","v":0},null,"Zona Total: 3",{"$f":"F12+G12+H12+G13+H13+H14","v":0}]
[null,null,4,{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,D$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C15)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,E$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C15)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,F$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C15)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,G$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C15)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,H$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C15)","v":0},null,"Zona Total: 2",{"$f":"D12+E12+E13+F13+F14+G14+G15+H15+H16","v":0}]
[null,null,2,{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,D$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C16)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,E$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C16)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,F$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C16)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,G$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C16)","v":0},{"$f":"COUNTIFS('4 - Planificacion y gestión'!$E$12:$E$41,H$17,'4 - Planificacion y gestión'!$F$12:$F$41,$C16)","v":0},null,"Zona Total: 1",{"$f":"D13+D14+E14+D15+E15+F15+D16+E16+F16+G16","v":0}]
[null,null,null,0.2,0.4,0.6,0.8,1]
[null,null,null,"Probabilidad"]

{"sheet":"Parametros","index":7,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[[7,1,7,2],[12,3,12,4],[6,4,6,6],[7,4,7,6],[8,4,8,5],[9,4,9,5],[10,4,10,5],[59,2,64,2],[36,2,43,2],[22,1,22,3],[12,6,12,7],[44,2,51,2],[52,2,58,2]]}
[]
[]
[null,"Parámetros"]
[]
[null,"Fecha de Revisión:","2014-03-12",{"$f":"CONCATENATE(\"Próxima Revisión: \",DAY(C5+180),\"/\",MONTH(C5+180),\"/\",YEAR(C5+180))","v":"Próxima Revisión: 8/9/2014"}]
[null,"Revisado por:",null,"Aprobado por:"]
[null,null,null,null,"Impacto si ocurre Riesgo Respuesta"]
[null,"Respuestas si Representa un riesgo ",null,null,"a la Pregunta"]
[null,"Respuesta","SI",null,"Impacto",null,"Alto"]
[null,"Respuesta","NO",null,"Impacto",null,"Bajo"]
[null,"Respuesta","No aplica",null,"Impacto",null,"No aplica"]
[]
[null,null,null,"Probabilidad del Riesgo",null,null,"Impacto del Riesgo"]
[null,"Estados para riesgos",null,"Estados para riesgos","Probabilidad %",null,"Expresión","Puntuación"]
[null,"00 - EN GESTION",null,"Poco Probable",0.2,null,"Muy Bajo",2]
[null,"01 - ACTIVACION MITIGACION",null,"Probablemente no suceda",0.4,null,"Bajo",4]
[null,"02 - ACTIVACION CONTINGENCIA",null,"Probable ",0.6,null,"Moderado",6]
[null,"98 - RESUELTO",null,"Altamente Probable",0.8,null,"Alto",8]
[null,"99 - CERRADO",null,"Seguramente suceda",1,null,"Critico",10]
[]
[]
[]
[null,"Motivos para cambios de estado"]
[null,"De","A","Motivo"]
[null,"Propuesto","En gestión","Gestión"]
[null,"En gestión","Activo","Mitigación activada"]
[null,"En gestión","Activo","Contingencia activada"]
[null,"Propuesto / En gestión ","Cerrado","Rechazado (no es un riesgo)",null,"Impacto si ocurre Riesgo Respuesta"]
[null,"Activo","Cerrado","Asumido (se toman acciones correctivas si el riesgo ocurre)",null,"a la Pregunta"]
[null,"Activo","Resuelto","Mitigación finalizada ",null,"Impacto",null,"Alto"]
[null,"Activo","Resuelto","Contingencia finalizada",null,"Impacto",null,"Bajo"]
[null,"Resuelto","Activo","Mitigación no satisfactoria",null,"Impacto",null,"No aplica"]
[null,"Resuelto","Activo","Contingencia no satisfactoria"]
[null,"Resuelto","Cerrado","El riesgo ha sido mitigado / La contingencia ha sido satisfactoria"]
[]
[null,null,"Categoría","Sub-categoría"]
[null,null,"1 - Interesados","1 - Responsable Funcional"]
[null,null,null,"1 - Usuario final"]
[null,null,null,"1 - Sponsors"]
[null,null,null,"1 - Recursos humanos"]
[null,null,null,"1 - Organización"]
[null,null,null,"1 - Habilidades"]
[null,null,null,"1 - Política"]
[null,null,null,"1 - Motivación"]
[null,null,"2 - Proyecto","2 - Misión y Objetivos"]
[null,null,null,"2 - Toma de decisiones"]
[null,null,null,"2 - Características del proyecto"]
[null,null,null,"2 - Presupuesto, Costos y Cronograma"]
[null,null,null,"2 - Requerimientos"]
[null,null,null,"2 - Diseño"]
[null,null,null,"2 - Desarrollo"]
[null,null,null,"2 - Testing"]
[null,null,"3 - Tecnologia","3 - Seguridad"]
[null,null,null,"3 - Ambiente de Desarrollo y Testing"]
[null,null,null,"3 - Herramientas"]
[null,null,null,"3 - Distribución"]
[null,null,null,"3 - Soporte Técnico"]
[null,null,null,"3 - Ambiente Operativo"]
[null,null,null,"3 - Disponibilidad"]
[null,null,"4 - Entorno","4 - Legal"]
[null,null,null,"4 - Marco regulatorio"]
[null,null,null,"4 - Competencia"]
[null,null,null,"4 - Económico"]
[null,null,null,"4 - Tecnología"]
[null,null,null,"4 - Negocio"]
[]
[null,null,"Categoría"]
[null,null,"Interesados"]
[null,null,"Proyecto"]
[null,null,"Tecnologia"]
[null,null,"Entorno"]