{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Datos","Funciones de datos","Funciones de transacción","Funciones de prueba","Ítems no mesurasbles","Sumário","PAR","_EAF","_HISTORICO"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":34,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Datos","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[55,2,55,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[22,3,22,5],[23,3,23,5],[24,3,24,5],[20,1,20,5],[12,2,12,5],[15,2,15,5],[21,1,21,2],[17,2,17,5],[18,2,18,5],[16,2,16,5],[21,3,21,5],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[29,1,29,5],[30,1,30,5],[27,3,27,5],[32,1,32,5],[48,2,48,5],[33,1,33,5],[47,2,47,5],[35,1,35,5],[36,1,36,5],[37,1,37,5],[46,2,46,5],[1,1,1,2],[14,1,14,5],[5,4,5,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[8,4,8,5],[3,1,3,5],[4,4,4,5],[6,2,6,5],[7,4,7,5]]}
[]
[null," \n\nHoja de Puntos de Función"]
[]
[null,"IDENTIFICACIÓN DEL CONTEO"]
[null,"Cliente","Justicia Especial para la Paz - JEP","Contrato","JEP 918-2023"]
[null,"Solicitante","Rafael Ignacio Thomas Bohórquez","Área de solicitud","DTI/SEJUD"]
[null,"Solicitud / Demanda",1326247]
[null,"Tipo de conteo","Proyecto de mejora","Método","IFPUG detallado"]
[null,"Analista responsable","Renan Ferreira Silva / KazumI Futatsugi","Fecha cont.","2024-07-01"]
[null,"Revisor/ Área","Shãmia Porto"]
[null,"Versión del conteo","Inicial - versión 1"]
[null,"Fecha de aprobación"]
[null,"Autorizador en el cliente","Rafael Ignacio Thomas Bohórquez"]
[]
[null,"RELACIÓN DE DOCUMENTOS"]
[null,"Especificación de requisitos","ERS-PUB-SAJ-SGJ.2024.1326247 - Evolución 604235 (Insights - Modificación panel consecutivos)"]
[null,"Plantilla de datos","N/A"]
[null,"Estimación preliminar","EPD-PUB-SAJ-SGJ.2024.1326247 - Evolución 604235 (Insights - Modificación panel consecutivos)"]
[null,"Otros documentos","N/A"]
[]
[null,"ÍNDICE DEL CONTEO"]
[null,"Operación",null,"Total PF"]
[null,"Inclusión",null,{"$f":"'Funciones de datos'!C8+'Funciones de transacción'!D9","v":7}]
[null,"Modificación",null,{"$f":"'Funciones de datos'!C9+'Funciones de transacción'!D10","v":0}]
[null,"Exclusión",null,{"$f":"'Funciones de datos'!C10+'Funciones de transacción'!D11","v":0}]
[null,"Funciones de prueba (FP)",null,{"$f":"'Funciones de prueba'!C10","v":0}]
[null,"Ítems no medibles",null,{"$f":"'Ítems no mesurasbles'!N28","v":0}]
[null,"TAMAÑO FUNCIONAL EN PF (IFPUG)",null,{"$f":"SUM(D23:D27)","v":7}]
[]
[null,"OBJETIVO DEL CONTEO"]
[null,"Estimar en PPF el desarrollo de modificación del panel consecutivos"]
[]
[null,"LÍMITE"]
[null,"SAJ6"]
[]
[null,"ALCANCE DEL CONTEO"]
[null,"SAJ6"]
[null,"Orientación para la nomenclatura del archivo: PPF-<ÁREA DE NEGOCIO>-<SISTEMA>.<AAAA>.<Número de la corrección> <Versión>"]

{"sheet":"Funciones de datos","index":1,"n_rows":85,"n_cols":12,"rows_kept":85,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,0,0,1],[5,0,5,3],[12,9,12,11],[12,4,13,4],[12,3,13,3],[12,7,13,7],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,5,13,5],[12,6,13,6],[11,0,11,6]]}
["RESUMEN DEL CONTEO"]
["FUNCIONES DE DATOS"]
["TIPO","CANTID."]
["Archivos de Interfaz Externos (AIE)",{"$f":"COUNTIF($B$15:$B$999,\"AIE\")","v":0}]
["Archivos Lógicos Internos (ALI) ",{"$f":"COUNTIF($B$15:$B$999,\"ALI\")","v":0}]
["TIPO"]
["TIPO","CANTID.","PF-B","PF-I"]
["Inclusión",{"$f":"COUNTIFS($C$15:$C$999,A8)","v":0},{"$f":"SUMIF(C15:C85,\"=Inclusión\",G15:G85)","v":0},{"$f":"C8*Datos!$E$23","v":0}]
["Modificación",{"$f":"COUNTIFS($C$15:$C$999,A9)","v":0},{"$f":"SUMIF(C15:C85,\"=Alteración\",G15:G85)","v":0},{"$f":"C9*Datos!$E$24","v":0}]
["Eliminación",{"$f":"COUNTIFS($C$15:$C$999,A10)","v":0},{"$f":"SUMIF(C15:C85,\"=Exclusión\",G15:G86)","v":0},{"$f":"C10*Datos!$E$25","v":0}]
[null,null,{"$f":"SUM(C8:C10)","v":0},{"$f":"SUM(D8:D10)","v":0}]
[{"$f":"CONCATENATE(\"Tamaño Funcional: \",C11)","v":"Tamaño Funcional: 0"}]
["FUNCIÓN DE DATOS","TIPO","OPER.","DET","RET","CPLX","PF","IMPLEMENTACIÓN REALIZADA (ALT.) O RET (INC.)",null,"Critérios"]
[null,null,null,null,null,null,null,null,null,"DER","ctl","C"]
[null,null,null,null,null,{"$f":"IF(L15=\"L\",\"Baja\",IF(L15=\"A\",\"Media\",IF(L15=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(OR(ISBLANK(B15),B15=\"N/A\"),\"\",IF(B15=\"ALI\",IF(L15=\"L\",7,IF(L15=\"A\",10,15)),IF(B15=\"AIE\",IF(L15=\"L\",5,IF(L15=\"A\",7,10)))))","v":""},null,null,{"$f":"IF(D15=\"1 - 19\",10,IF(D15=\"20 - 50\",35,IF(D15=\">50\",51,0)))","v":0},{"$f":"CONCATENATE(IF(B15=\"N/A\",\"\",\"\"),L15)","v":""},{"$f":"IF(OR(ISBLANK(J15),ISBLANK(E15)),IF(OR(B15=\"ALI\",B15=\"AIE\"),\"L\",IF(OR(ISBLANK(B15),B15=\"N/A\"),\"\",\"A\")),IF(B15=\"EE\",IF(E15>=3,IF(J15>=5,\"H\",\"A\"),IF(E15>=2,IF(J15>=16,\"H\",IF(J15<=4,\"L\",\"A\")),IF(J15<=15,\"L\",\"A\"))),IF(OR(B15=\"SE\",B15=\"CE\"),IF(E15>=4,IF(J15>=6,\"H\",\"A\"),IF(E15>=2,IF(J15>=20,\"H\",IF(J15<=5,\"L\",\"A\")),IF(J15<=19,\"L\",\"A\"))),IF(OR(B15=\"ALI\",B15=\"AIE\"),IF(E15>=6,IF(J15>=20,\"H\",\"A\"),IF(E15>=2,IF(J15>=51,\"H\",IF(J15<=19,\"L\",\"A\")),IF(J15<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B16),B16=\"N/A\"),\"\",IF(B16=\"ALI\",IF(L16=\"L\",7,IF(L16=\"A\",10,15)),IF(B16=\"AIE\",IF(L16=\"L\",5,IF(L16=\"A\",7,10)))))","v":""},null,null,{"$f":"IF(D16=\"1 - 19\",10,IF(D16=\"20 - 50\",35,IF(D16=\">50\",51,0)))","v":0},{"$f":"CONCATENATE(IF(B16=\"N/A\",\"\",\"\"),L16)","v":""},{"$f":"IF(OR(ISBLANK(J16),ISBLANK(E16)),IF(OR(B16=\"ALI\",B16=\"AIE\"),\"L\",IF(OR(ISBLANK(B16),B16=\"N/A\"),\"\",\"A\")),IF(B16=\"EE\",IF(E16>=3,IF(J16>=5,\"H\",\"A\"),IF(E16>=2,IF(J16>=16,\"H\",IF(J16<=4,\"L\",\"A\")),IF(J16<=15,\"L\",\"A\"))),IF(OR(B16=\"SE\",B16=\"CE\"),IF(E16>=4,IF(J16>=6,\"H\",\"A\"),IF(E16>=2,IF(J16>=20,\"H\",IF(J16<=5,\"L\",\"A\")),IF(J16<=19,\"L\",\"A\"))),IF(OR(B16=\"ALI\",B16=\"AIE\"),IF(E16>=6,IF(J16>=20,\"H\",\"A\"),IF(E16>=2,IF(J16>=51,\"H\",IF(J16<=19,\"L\",\"A\")),IF(J16<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B17),B17=\"N/A\"),\"\",IF(B17=\"ALI\",IF(L17=\"L\",7,IF(L17=\"A\",10,15)),IF(B17=\"AIE\",IF(L17=\"L\",5,IF(L17=\"A\",7,10)))))","v":""},null,null,0,"",""]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B18),B18=\"N/A\"),\"\",IF(B18=\"ALI\",IF(L18=\"L\",7,IF(L18=\"A\",10,15)),IF(B18=\"AIE\",IF(L18=\"L\",5,IF(L18=\"A\",7,10)))))","v":""},null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,{"$f":"IF(L34=\"L\",\"Baja\",IF(L34=\"A\",\"Media\",IF(L34=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(OR(ISBLANK(B34),B34=\"N/A\"),\"\",IF(B34=\"ALI\",IF(L34=\"L\",7,IF(L34=\"A\",10,15)),IF(B34=\"AIE\",IF(L34=\"L\",5,IF(L34=\"A\",7,10)))))","v":""},null,null,{"$f":"IF(D34=\"1 - 19\",10,IF(D34=\"20 - 50\",35,IF(D34=\">50\",51,0)))","v":0},{"$f":"CONCATENATE(IF(B34=\"N/A\",\"\",\"\"),L34)","v":""},{"$f":"IF(OR(ISBLANK(J34),ISBLANK(E34)),IF(OR(B34=\"ALI\",B34=\"AIE\"),\"L\",IF(OR(ISBLANK(B34),B34=\"N/A\"),\"\",\"A\")),IF(B34=\"EE\",IF(E34>=3,IF(J34>=5,\"H\",\"A\"),IF(E34>=2,IF(J34>=16,\"H\",IF(J34<=4,\"L\",\"A\")),IF(J34<=15,\"L\",\"A\"))),IF(OR(B34=\"SE\",B34=\"CE\"),IF(E34>=4,IF(J34>=6,\"H\",\"A\"),IF(E34>=2,IF(J34>=20,\"H\",IF(J34<=5,\"L\",\"A\")),IF(J34<=19,\"L\",\"A\"))),IF(OR(B34=\"ALI\",B34=\"AIE\"),IF(E34>=6,IF(J34>=20,\"H\",\"A\"),IF(E34>=2,IF(J34>=51,\"H\",IF(J34<=19,\"L\",\"A\")),IF(J34<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,{"$f":"IF(L39=\"L\",\"Baja\",IF(L39=\"A\",\"Media\",IF(L39=\"\",\"\",\"Alta\")))","v":""},"",null,null,0,"",""]
[null,null,null,null,null,{"$f":"IF(L40=\"L\",\"Baja\",IF(L40=\"A\",\"Media\",IF(L40=\"\",\"\",\"Alta\")))","v":""},"",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,{"$f":"IF(D79=\"1 - 19\",10,IF(D79=\"20 - 50\",35,IF(D79=\">50\",51,0)))","v":0},{"$f":"CONCATENATE(IF(B79=\"N/A\",\"\",\"\"),L79)","v":""},{"$f":"IF(OR(ISBLANK(J79),ISBLANK(E79)),IF(OR(B79=\"ALI\",B79=\"AIE\"),\"L\",IF(OR(ISBLANK(B79),B79=\"N/A\"),\"\",\"A\")),IF(B79=\"EE\",IF(E79>=3,IF(J79>=5,\"H\",\"A\"),IF(E79>=2,IF(J79>=16,\"H\",IF(J79<=4,\"L\",\"A\")),IF(J79<=15,\"L\",\"A\"))),IF(OR(B79=\"SE\",B79=\"CE\"),IF(E79>=4,IF(J79>=6,\"H\",\"A\"),IF(E79>=2,IF(J79>=20,\"H\",IF(J79<=5,\"L\",\"A\")),IF(J79<=19,\"L\",\"A\"))),IF(OR(B79=\"ALI\",B79=\"AIE\"),IF(E79>=6,IF(J79>=20,\"H\",\"A\"),IF(E79>=2,IF(J79>=51,\"H\",IF(J79<=19,\"L\",\"A\")),IF(J79<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"","",null,null,0,"",""]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B82),B82=\"N/A\"),\"\",IF(B82=\"ALI\",IF(L82=\"L\",7,IF(L82=\"A\",10,15)),IF(B82=\"AIE\",IF(L82=\"L\",5,IF(L82=\"A\",7,10)))))","v":""},null,null,0,"",""]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B83),B83=\"N/A\"),\"\",IF(B83=\"ALI\",IF(L83=\"L\",7,IF(L83=\"A\",10,15)),IF(B83=\"AIE\",IF(L83=\"L\",5,IF(L83=\"A\",7,10)))))","v":""},null,null,0,"",""]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B84),B84=\"N/A\"),\"\",IF(B84=\"ALI\",IF(L84=\"L\",7,IF(L84=\"A\",10,15)),IF(B84=\"AIE\",IF(L84=\"L\",5,IF(L84=\"A\",7,10)))))","v":""},null,null,0,"",""]
[null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(B85),B85=\"N/A\"),\"\",IF(B85=\"ALI\",IF(L85=\"L\",7,IF(L85=\"A\",10,15)),IF(B85=\"AIE\",IF(L85=\"L\",5,IF(L85=\"A\",7,10)))))","v":""},null,null,0,"",""]

{"sheet":"Funciones de transacción","index":2,"n_rows":333,"n_cols":15,"rows_kept":333,"cut":false,"hidden":false,"merged":[[15,6,15,9],[13,8,14,8],[13,9,14,9],[1,1,1,2],[12,1,12,7],[0,1,0,2],[13,12,13,14],[6,1,6,4],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,6,14,6],[13,7,14,7],[13,4,14,4],[13,5,14,5],[13,10,14,10]]}
[null,"RESUMEN DEL CONTEO"]
[null,"FUNCIONES DE TRANSACCIÓN"]
[null,"TIPO","CANTID."]
[null,"Entradas Externas (EE)",{"$f":"COUNTIF($C$17:$C$1008,B4)","v":0}]
[null,"Consultas Externas (CE)",{"$f":"COUNTIF($C$17:$C$1008,B5)","v":0}]
[null,"Salidas Externas (SE)",{"$f":"COUNTIF($C$17:$C$1008,B6)","v":0}]
[null,"TIPO"]
[null,"TIPO","QTDE","PF - B","PF - I"]
[null,"Inclusión",{"$f":"COUNTIFS($D$17:$D$1008,B9)","v":1},{"$f":"SUMIF(D16:D333,\"=Inclusión\",H16:H316)","v":7},{"$f":"D9*Datos!$E$23","v":0}]
[null,"Alteración",{"$f":"COUNTIFS($D$17:$D$1008,B10)","v":0},{"$f":"SUMIF(D16:D333,\"=Alteración\",H16:H19)","v":0},{"$f":"D10*Datos!$E$24","v":0}]
[null,"Exclusión",{"$f":"COUNTIFS($D$17:$D$1008,B11)","v":0},{"$f":"SUMIF(D16:D333,\"=Exclusión\",H16:H29)","v":0},{"$f":"D11*Datos!$E$25","v":0}]
[null,null,null,{"$f":"SUM(D9:D11)","v":7},{"$f":"SUM(E9:E11)","v":0}]
[null,{"$f":"CONCATENATE(\"Tamaño Funcional: \",D12)","v":"Tamaño Funcional: 7"}]
[null,"PROCESO PRINCIPAL","TIPO","OPER.","DER","FTR","CPLX","PF","FUNCIONES DE DATOS (FTR)","REQUISITOS/ OBSERVACIONES/ JUSTIFICACIÓN","DERs envolvidos",null,"Critérios"]
[" [ LOCALIZAÇÃO ]",null,null,null,null,null,null,null,null,null,"Função de dados envolvidas",null,"DER","ctl","C"]
["CANAL PRINCIPAL - MENU",null,null,null,null,null,{"$f":"IF(O16=\"L\",\"Baja\",IF(O16=\"A\",\"Media\",IF(O16=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(ISBLANK(C16),\"\",IF(C16=\"SE\",IF(O16=\"L\",4,IF(O16=\"A\",5,7)),IF(OR(C16=\"EE\",C16=\"CE\",C16=\"CO\"),IF(O16=\"L\",3,IF(O16=\"A\",4,6)))))","v":""},null,null,null,null,null,{"$f":"CONCATENATE(C16,O16)","v":""},{"$f":"IF(OR(ISBLANK(M16),ISBLANK(F16)),IF(OR(C16=\"ALI\",C16=\"AIE\"),\"L\",IF(ISBLANK(C16),\"\",\"A\")),IF(C16=\"EE\",IF(F16>=3,IF(M16>=5,\"H\",\"A\"),IF(F16>=2,IF(M16>=16,\"H\",IF(M16<=4,\"L\",\"A\")),IF(M16<=15,\"L\",\"A\"))),IF(OR(C16=\"SE\",C16=\"CE\"),IF(F16>=4,IF(M16>=6,\"H\",\"A\"),IF(F16>=2,IF(M16>=20,\"H\",IF(M16<=5,\"L\",\"A\")),IF(M16<=19,\"L\",\"A\"))),IF(OR(C16=\"ALI\",C16=\"AIE\"),IF(F16>=6,IF(M16>=20,\"H\",\"A\"),IF(F16>=2,IF(M16>=51,\"H\",IF(M16<=19,\"L\",\"A\")),IF(M16<=50,\"L\",\"A\")))))))","v":""}]
[null,"Exhibir Panel Consecutivos Magistratura","SE","Inclusión",">19",6,{"$f":"IF(AND(C17<>\"N/A\",C17<>\"\"),IF(O17=\"L\",\"Baja\",IF(O17=\"A\",\"Media\",IF(O17=\"\",\"\",\"Alta\"))),\"\")","v":"Alta"},{"$f":"IF(OR(ISBLANK(C17),C17=\"N/A\"),\"\",IF(C17=\"SE\",IF(O17=\"L\",4,IF(O17=\"A\",5,7)),IF(OR(C17=\"EE\",C17=\"CE\",C17=\"CO\"),IF(O17=\"L\",3,IF(O17=\"A\",4,6)))))","v":7},"Consecutivo, Documentos, Proceso, Órgano Judicial, Reparto y Clase","Exhibir panel de Consecutivos Magistratura\n\nEl objectivo es presentar todos los consecutivos generados en el sistema, ya sea por el editor de documentos o generador de consecutivos, sean consecutivos vinculados a documentos o no, de tipo judicial o administrativo.   \n\nLa consulta se modificará para tener en cuenta los requisitos. Aunque la parte visual del panel, así como los nombres y el orden de los campos del tablero, los gráficos, los filtros disponibles y la estructura del panel permanezcan inalterados al interno deberá adecuarse a nueva consulta.",null,null,{"$f":"IF(OR(E17=\"1 - 4\",E17=\"1 - 5\"),3,IF(OR(E17=\"5 - 15\",E17=\"6 - 19\"),10,IF(OR(E17=\">15\",E17=\">19\"),20,10)))","v":20},{"$f":"CONCATENATE(C17,O17)","v":"SEH"},{"$f":"IF(OR(ISBLANK(M17),ISBLANK(F17)),IF(OR(C17=\"ALI\",C17=\"AIE\"),\"L\",IF(ISBLANK(C17),\"\",\"A\")),IF(C17=\"EE\",IF(F17>=3,IF(M17>=5,\"H\",\"A\"),IF(F17>=2,IF(M17>=16,\"H\",IF(M17<=4,\"L\",\"A\")),IF(M17<=15,\"L\",\"A\"))),IF(OR(C17=\"SE\",C17=\"CE\"),IF(F17>=4,IF(M17>=6,\"H\",\"A\"),IF(F17>=2,IF(M17>=20,\"H\",IF(M17<=5,\"L\",\"A\")),IF(M17<=19,\"L\",\"A\"))),IF(OR(C17=\"ALI\",C17=\"AIE\"),IF(F17>=6,IF(M17>=20,\"H\",\"A\"),IF(F17>=2,IF(M17>=51,\"H\",IF(M17<=19,\"L\",\"A\")),IF(M17<=50,\"L\",\"A\")))))))","v":"H"}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C18),C18=\"N/A\"),\"\",IF(C18=\"SE\",IF(O18=\"L\",4,IF(O18=\"A\",5,7)),IF(OR(C18=\"EE\",C18=\"CE\",C18=\"CO\"),IF(O18=\"L\",3,IF(O18=\"A\",4,6)))))","v":""},null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C21),C21=\"N/A\"),\"\",IF(C21=\"SE\",IF(O21=\"L\",4,IF(O21=\"A\",5,7)),IF(OR(C21=\"EE\",C21=\"CE\",C21=\"CO\"),IF(O21=\"L\",3,IF(O21=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E21=\"1 - 4\",E21=\"1 - 5\"),3,IF(OR(E21=\"5 - 15\",E21=\"6 - 19\"),10,IF(OR(E21=\">15\",E21=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C21,O21)","v":""},{"$f":"IF(OR(ISBLANK(M21),ISBLANK(F21)),IF(OR(C21=\"ALI\",C21=\"AIE\"),\"L\",IF(ISBLANK(C21),\"\",\"A\")),IF(C21=\"EE\",IF(F21>=3,IF(M21>=5,\"H\",\"A\"),IF(F21>=2,IF(M21>=16,\"H\",IF(M21<=4,\"L\",\"A\")),IF(M21<=15,\"L\",\"A\"))),IF(OR(C21=\"SE\",C21=\"CE\"),IF(F21>=4,IF(M21>=6,\"H\",\"A\"),IF(F21>=2,IF(M21>=20,\"H\",IF(M21<=5,\"L\",\"A\")),IF(M21<=19,\"L\",\"A\"))),IF(OR(C21=\"ALI\",C21=\"AIE\"),IF(F21>=6,IF(M21>=20,\"H\",\"A\"),IF(F21>=2,IF(M21>=51,\"H\",IF(M21<=19,\"L\",\"A\")),IF(M21<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,{"$f":"IF(OR(E22=\"1 - 4\",E22=\"1 - 5\"),3,IF(OR(E22=\"5 - 15\",E22=\"6 - 19\"),10,IF(OR(E22=\">15\",E22=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C22,O22)","v":""},{"$f":"IF(OR(ISBLANK(M22),ISBLANK(F22)),IF(OR(C22=\"ALI\",C22=\"AIE\"),\"L\",IF(ISBLANK(C22),\"\",\"A\")),IF(C22=\"EE\",IF(F22>=3,IF(M22>=5,\"H\",\"A\"),IF(F22>=2,IF(M22>=16,\"H\",IF(M22<=4,\"L\",\"A\")),IF(M22<=15,\"L\",\"A\"))),IF(OR(C22=\"SE\",C22=\"CE\"),IF(F22>=4,IF(M22>=6,\"H\",\"A\"),IF(F22>=2,IF(M22>=20,\"H\",IF(M22<=5,\"L\",\"A\")),IF(M22<=19,\"L\",\"A\"))),IF(OR(C22=\"ALI\",C22=\"AIE\"),IF(F22>=6,IF(M22>=20,\"H\",\"A\"),IF(F22>=2,IF(M22>=51,\"H\",IF(M22<=19,\"L\",\"A\")),IF(M22<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C24),C24=\"N/A\"),\"\",IF(C24=\"SE\",IF(O24=\"L\",4,IF(O24=\"A\",5,7)),IF(OR(C24=\"EE\",C24=\"CE\",C24=\"CO\"),IF(O24=\"L\",3,IF(O24=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E24=\"1 - 4\",E24=\"1 - 5\"),3,IF(OR(E24=\"5 - 15\",E24=\"6 - 19\"),10,IF(OR(E24=\">15\",E24=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C24,O24)","v":""},{"$f":"IF(OR(ISBLANK(M24),ISBLANK(F24)),IF(OR(C24=\"ALI\",C24=\"AIE\"),\"L\",IF(ISBLANK(C24),\"\",\"A\")),IF(C24=\"EE\",IF(F24>=3,IF(M24>=5,\"H\",\"A\"),IF(F24>=2,IF(M24>=16,\"H\",IF(M24<=4,\"L\",\"A\")),IF(M24<=15,\"L\",\"A\"))),IF(OR(C24=\"SE\",C24=\"CE\"),IF(F24>=4,IF(M24>=6,\"H\",\"A\"),IF(F24>=2,IF(M24>=20,\"H\",IF(M24<=5,\"L\",\"A\")),IF(M24<=19,\"L\",\"A\"))),IF(OR(C24=\"ALI\",C24=\"AIE\"),IF(F24>=6,IF(M24>=20,\"H\",\"A\"),IF(F24>=2,IF(M24>=51,\"H\",IF(M24<=19,\"L\",\"A\")),IF(M24<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C25),C25=\"N/A\"),\"\",IF(C25=\"SE\",IF(O25=\"L\",4,IF(O25=\"A\",5,7)),IF(OR(C25=\"EE\",C25=\"CE\",C25=\"CO\"),IF(O25=\"L\",3,IF(O25=\"A\",4,6)))))","v":""},null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C31<>\"N/A\",C31<>\"\"),IF(O31=\"L\",\"Baja\",IF(O31=\"A\",\"Media\",IF(O31=\"\",\"\",\"Alta\"))),\"\")","v":""},"",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C32<>\"N/A\",C32<>\"\"),IF(O32=\"L\",\"Baja\",IF(O32=\"A\",\"Media\",IF(O32=\"\",\"\",\"Alta\"))),\"\")","v":""},"",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C36),C36=\"N/A\"),\"\",IF(C36=\"SE\",IF(O36=\"L\",4,IF(O36=\"A\",5,7)),IF(OR(C36=\"EE\",C36=\"CE\",C36=\"CO\"),IF(O36=\"L\",3,IF(O36=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E36=\"1 - 4\",E36=\"1 - 5\"),3,IF(OR(E36=\"5 - 15\",E36=\"6 - 19\"),10,IF(OR(E36=\">15\",E36=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C36,O36)","v":""},{"$f":"IF(OR(ISBLANK(M36),ISBLANK(F36)),IF(OR(C36=\"ALI\",C36=\"AIE\"),\"L\",IF(ISBLANK(C36),\"\",\"A\")),IF(C36=\"EE\",IF(F36>=3,IF(M36>=5,\"H\",\"A\"),IF(F36>=2,IF(M36>=16,\"H\",IF(M36<=4,\"L\",\"A\")),IF(M36<=15,\"L\",\"A\"))),IF(OR(C36=\"SE\",C36=\"CE\"),IF(F36>=4,IF(M36>=6,\"H\",\"A\"),IF(F36>=2,IF(M36>=20,\"H\",IF(M36<=5,\"L\",\"A\")),IF(M36<=19,\"L\",\"A\"))),IF(OR(C36=\"ALI\",C36=\"AIE\"),IF(F36>=6,IF(M36>=20,\"H\",\"A\"),IF(F36>=2,IF(M36>=51,\"H\",IF(M36<=19,\"L\",\"A\")),IF(M36<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C37),C37=\"N/A\"),\"\",IF(C37=\"SE\",IF(O37=\"L\",4,IF(O37=\"A\",5,7)),IF(OR(C37=\"EE\",C37=\"CE\",C37=\"CO\"),IF(O37=\"L\",3,IF(O37=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E37=\"1 - 4\",E37=\"1 - 5\"),3,IF(OR(E37=\"5 - 15\",E37=\"6 - 19\"),10,IF(OR(E37=\">15\",E37=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C37,O37)","v":""},{"$f":"IF(OR(ISBLANK(M37),ISBLANK(F37)),IF(OR(C37=\"ALI\",C37=\"AIE\"),\"L\",IF(ISBLANK(C37),\"\",\"A\")),IF(C37=\"EE\",IF(F37>=3,IF(M37>=5,\"H\",\"A\"),IF(F37>=2,IF(M37>=16,\"H\",IF(M37<=4,\"L\",\"A\")),IF(M37<=15,\"L\",\"A\"))),IF(OR(C37=\"SE\",C37=\"CE\"),IF(F37>=4,IF(M37>=6,\"H\",\"A\"),IF(F37>=2,IF(M37>=20,\"H\",IF(M37<=5,\"L\",\"A\")),IF(M37<=19,\"L\",\"A\"))),IF(OR(C37=\"ALI\",C37=\"AIE\"),IF(F37>=6,IF(M37>=20,\"H\",\"A\"),IF(F37>=2,IF(M37>=51,\"H\",IF(M37<=19,\"L\",\"A\")),IF(M37<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C39),C39=\"N/A\"),\"\",IF(C39=\"SE\",IF(O39=\"L\",4,IF(O39=\"A\",5,7)),IF(OR(C39=\"EE\",C39=\"CE\",C39=\"CO\"),IF(O39=\"L\",3,IF(O39=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E39=\"1 - 4\",E39=\"1 - 5\"),3,IF(OR(E39=\"5 - 15\",E39=\"6 - 19\"),10,IF(OR(E39=\">15\",E39=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C39,O39)","v":""},{"$f":"IF(OR(ISBLANK(M39),ISBLANK(F39)),IF(OR(C39=\"ALI\",C39=\"AIE\"),\"L\",IF(ISBLANK(C39),\"\",\"A\")),IF(C39=\"EE\",IF(F39>=3,IF(M39>=5,\"H\",\"A\"),IF(F39>=2,IF(M39>=16,\"H\",IF(M39<=4,\"L\",\"A\")),IF(M39<=15,\"L\",\"A\"))),IF(OR(C39=\"SE\",C39=\"CE\"),IF(F39>=4,IF(M39>=6,\"H\",\"A\"),IF(F39>=2,IF(M39>=20,\"H\",IF(M39<=5,\"L\",\"A\")),IF(M39<=19,\"L\",\"A\"))),IF(OR(C39=\"ALI\",C39=\"AIE\"),IF(F39>=6,IF(M39>=20,\"H\",\"A\"),IF(F39>=2,IF(M39>=51,\"H\",IF(M39<=19,\"L\",\"A\")),IF(M39<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C40),C40=\"N/A\"),\"\",IF(C40=\"SE\",IF(O40=\"L\",4,IF(O40=\"A\",5,7)),IF(OR(C40=\"EE\",C40=\"CE\",C40=\"CO\"),IF(O40=\"L\",3,IF(O40=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E40=\"1 - 4\",E40=\"1 - 5\"),3,IF(OR(E40=\"5 - 15\",E40=\"6 - 19\"),10,IF(OR(E40=\">15\",E40=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C40,O40)","v":""},{"$f":"IF(OR(ISBLANK(M40),ISBLANK(F40)),IF(OR(C40=\"ALI\",C40=\"AIE\"),\"L\",IF(ISBLANK(C40),\"\",\"A\")),IF(C40=\"EE\",IF(F40>=3,IF(M40>=5,\"H\",\"A\"),IF(F40>=2,IF(M40>=16,\"H\",IF(M40<=4,\"L\",\"A\")),IF(M40<=15,\"L\",\"A\"))),IF(OR(C40=\"SE\",C40=\"CE\"),IF(F40>=4,IF(M40>=6,\"H\",\"A\"),IF(F40>=2,IF(M40>=20,\"H\",IF(M40<=5,\"L\",\"A\")),IF(M40<=19,\"L\",\"A\"))),IF(OR(C40=\"ALI\",C40=\"AIE\"),IF(F40>=6,IF(M40>=20,\"H\",\"A\"),IF(F40>=2,IF(M40>=51,\"H\",IF(M40<=19,\"L\",\"A\")),IF(M40<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C42),C42=\"N/A\"),\"\",IF(C42=\"SE\",IF(O42=\"L\",4,IF(O42=\"A\",5,7)),IF(OR(C42=\"EE\",C42=\"CE\",C42=\"CO\"),IF(O42=\"L\",3,IF(O42=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E42=\"1 - 4\",E42=\"1 - 5\"),3,IF(OR(E42=\"5 - 15\",E42=\"6 - 19\"),10,IF(OR(E42=\">15\",E42=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C42,O42)","v":""},{"$f":"IF(OR(ISBLANK(M42),ISBLANK(F42)),IF(OR(C42=\"ALI\",C42=\"AIE\"),\"L\",IF(ISBLANK(C42),\"\",\"A\")),IF(C42=\"EE\",IF(F42>=3,IF(M42>=5,\"H\",\"A\"),IF(F42>=2,IF(M42>=16,\"H\",IF(M42<=4,\"L\",\"A\")),IF(M42<=15,\"L\",\"A\"))),IF(OR(C42=\"SE\",C42=\"CE\"),IF(F42>=4,IF(M42>=6,\"H\",\"A\"),IF(F42>=2,IF(M42>=20,\"H\",IF(M42<=5,\"L\",\"A\")),IF(M42<=19,\"L\",\"A\"))),IF(OR(C42=\"ALI\",C42=\"AIE\"),IF(F42>=6,IF(M42>=20,\"H\",\"A\"),IF(F42>=2,IF(M42>=51,\"H\",IF(M42<=19,\"L\",\"A\")),IF(M42<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C46),C46=\"N/A\"),\"\",IF(C46=\"SE\",IF(O46=\"L\",4,IF(O46=\"A\",5,7)),IF(OR(C46=\"EE\",C46=\"CE\",C46=\"CO\"),IF(O46=\"L\",3,IF(O46=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E46=\"1 - 4\",E46=\"1 - 5\"),3,IF(OR(E46=\"5 - 15\",E46=\"6 - 19\"),10,IF(OR(E46=\">15\",E46=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C46,O46)","v":""},{"$f":"IF(OR(ISBLANK(M46),ISBLANK(F46)),IF(OR(C46=\"ALI\",C46=\"AIE\"),\"L\",IF(ISBLANK(C46),\"\",\"A\")),IF(C46=\"EE\",IF(F46>=3,IF(M46>=5,\"H\",\"A\"),IF(F46>=2,IF(M46>=16,\"H\",IF(M46<=4,\"L\",\"A\")),IF(M46<=15,\"L\",\"A\"))),IF(OR(C46=\"SE\",C46=\"CE\"),IF(F46>=4,IF(M46>=6,\"H\",\"A\"),IF(F46>=2,IF(M46>=20,\"H\",IF(M46<=5,\"L\",\"A\")),IF(M46<=19,\"L\",\"A\"))),IF(OR(C46=\"ALI\",C46=\"AIE\"),IF(F46>=6,IF(M46>=20,\"H\",\"A\"),IF(F46>=2,IF(M46>=51,\"H\",IF(M46<=19,\"L\",\"A\")),IF(M46<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C52),C52=\"N/A\"),\"\",IF(C52=\"SE\",IF(O52=\"L\",4,IF(O52=\"A\",5,7)),IF(OR(C52=\"EE\",C52=\"CE\",C52=\"CO\"),IF(O52=\"L\",3,IF(O52=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E52=\"1 - 4\",E52=\"1 - 5\"),3,IF(OR(E52=\"5 - 15\",E52=\"6 - 19\"),10,IF(OR(E52=\">15\",E52=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C52,O52)","v":""},{"$f":"IF(OR(ISBLANK(M52),ISBLANK(F52)),IF(OR(C52=\"ALI\",C52=\"AIE\"),\"L\",IF(ISBLANK(C52),\"\",\"A\")),IF(C52=\"EE\",IF(F52>=3,IF(M52>=5,\"H\",\"A\"),IF(F52>=2,IF(M52>=16,\"H\",IF(M52<=4,\"L\",\"A\")),IF(M52<=15,\"L\",\"A\"))),IF(OR(C52=\"SE\",C52=\"CE\"),IF(F52>=4,IF(M52>=6,\"H\",\"A\"),IF(F52>=2,IF(M52>=20,\"H\",IF(M52<=5,\"L\",\"A\")),IF(M52<=19,\"L\",\"A\"))),IF(OR(C52=\"ALI\",C52=\"AIE\"),IF(F52>=6,IF(M52>=20,\"H\",\"A\"),IF(F52>=2,IF(M52>=51,\"H\",IF(M52<=19,\"L\",\"A\")),IF(M52<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C53),C53=\"N/A\"),\"\",IF(C53=\"SE\",IF(O53=\"L\",4,IF(O53=\"A\",5,7)),IF(OR(C53=\"EE\",C53=\"CE\",C53=\"CO\"),IF(O53=\"L\",3,IF(O53=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E53=\"1 - 4\",E53=\"1 - 5\"),3,IF(OR(E53=\"5 - 15\",E53=\"6 - 19\"),10,IF(OR(E53=\">15\",E53=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C53,O53)","v":""},{"$f":"IF(OR(ISBLANK(M53),ISBLANK(F53)),IF(OR(C53=\"ALI\",C53=\"AIE\"),\"L\",IF(ISBLANK(C53),\"\",\"A\")),IF(C53=\"EE\",IF(F53>=3,IF(M53>=5,\"H\",\"A\"),IF(F53>=2,IF(M53>=16,\"H\",IF(M53<=4,\"L\",\"A\")),IF(M53<=15,\"L\",\"A\"))),IF(OR(C53=\"SE\",C53=\"CE\"),IF(F53>=4,IF(M53>=6,\"H\",\"A\"),IF(F53>=2,IF(M53>=20,\"H\",IF(M53<=5,\"L\",\"A\")),IF(M53<=19,\"L\",\"A\"))),IF(OR(C53=\"ALI\",C53=\"AIE\"),IF(F53>=6,IF(M53>=20,\"H\",\"A\"),IF(F53>=2,IF(M53>=51,\"H\",IF(M53<=19,\"L\",\"A\")),IF(M53<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C56),C56=\"N/A\"),\"\",IF(C56=\"SE\",IF(O56=\"L\",4,IF(O56=\"A\",5,7)),IF(OR(C56=\"EE\",C56=\"CE\",C56=\"CO\"),IF(O56=\"L\",3,IF(O56=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E56=\"1 - 4\",E56=\"1 - 5\"),3,IF(OR(E56=\"5 - 15\",E56=\"6 - 19\"),10,IF(OR(E56=\">15\",E56=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C56,O56)","v":""},{"$f":"IF(OR(ISBLANK(M56),ISBLANK(F56)),IF(OR(C56=\"ALI\",C56=\"AIE\"),\"L\",IF(ISBLANK(C56),\"\",\"A\")),IF(C56=\"EE\",IF(F56>=3,IF(M56>=5,\"H\",\"A\"),IF(F56>=2,IF(M56>=16,\"H\",IF(M56<=4,\"L\",\"A\")),IF(M56<=15,\"L\",\"A\"))),IF(OR(C56=\"SE\",C56=\"CE\"),IF(F56>=4,IF(M56>=6,\"H\",\"A\"),IF(F56>=2,IF(M56>=20,\"H\",IF(M56<=5,\"L\",\"A\")),IF(M56<=19,\"L\",\"A\"))),IF(OR(C56=\"ALI\",C56=\"AIE\"),IF(F56>=6,IF(M56>=20,\"H\",\"A\"),IF(F56>=2,IF(M56>=51,\"H\",IF(M56<=19,\"L\",\"A\")),IF(M56<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C57),C57=\"N/A\"),\"\",IF(C57=\"SE\",IF(O57=\"L\",4,IF(O57=\"A\",5,7)),IF(OR(C57=\"EE\",C57=\"CE\",C57=\"CO\"),IF(O57=\"L\",3,IF(O57=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E57=\"1 - 4\",E57=\"1 - 5\"),3,IF(OR(E57=\"5 - 15\",E57=\"6 - 19\"),10,IF(OR(E57=\">15\",E57=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C57,O57)","v":""},{"$f":"IF(OR(ISBLANK(M57),ISBLANK(F57)),IF(OR(C57=\"ALI\",C57=\"AIE\"),\"L\",IF(ISBLANK(C57),\"\",\"A\")),IF(C57=\"EE\",IF(F57>=3,IF(M57>=5,\"H\",\"A\"),IF(F57>=2,IF(M57>=16,\"H\",IF(M57<=4,\"L\",\"A\")),IF(M57<=15,\"L\",\"A\"))),IF(OR(C57=\"SE\",C57=\"CE\"),IF(F57>=4,IF(M57>=6,\"H\",\"A\"),IF(F57>=2,IF(M57>=20,\"H\",IF(M57<=5,\"L\",\"A\")),IF(M57<=19,\"L\",\"A\"))),IF(OR(C57=\"ALI\",C57=\"AIE\"),IF(F57>=6,IF(M57>=20,\"H\",\"A\"),IF(F57>=2,IF(M57>=51,\"H\",IF(M57<=19,\"L\",\"A\")),IF(M57<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C82),C82=\"N/A\"),\"\",IF(C82=\"SE\",IF(O82=\"L\",4,IF(O82=\"A\",5,7)),IF(OR(C82=\"EE\",C82=\"CE\",C82=\"CO\"),IF(O82=\"L\",3,IF(O82=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E82=\"1 - 4\",E82=\"1 - 5\"),3,IF(OR(E82=\"5 - 15\",E82=\"6 - 19\"),10,IF(OR(E82=\">15\",E82=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C82,O82)","v":""},{"$f":"IF(OR(ISBLANK(M82),ISBLANK(F82)),IF(OR(C82=\"ALI\",C82=\"AIE\"),\"L\",IF(ISBLANK(C82),\"\",\"A\")),IF(C82=\"EE\",IF(F82>=3,IF(M82>=5,\"H\",\"A\"),IF(F82>=2,IF(M82>=16,\"H\",IF(M82<=4,\"L\",\"A\")),IF(M82<=15,\"L\",\"A\"))),IF(OR(C82=\"SE\",C82=\"CE\"),IF(F82>=4,IF(M82>=6,\"H\",\"A\"),IF(F82>=2,IF(M82>=20,\"H\",IF(M82<=5,\"L\",\"A\")),IF(M82<=19,\"L\",\"A\"))),IF(OR(C82=\"ALI\",C82=\"AIE\"),IF(F82>=6,IF(M82>=20,\"H\",\"A\"),IF(F82>=2,IF(M82>=51,\"H\",IF(M82<=19,\"L\",\"A\")),IF(M82<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C96<>\"N/A\",C96<>\"\"),IF(O96=\"L\",\"Baja\",IF(O96=\"A\",\"Media\",IF(O96=\"\",\"\",\"Alta\"))),\"\")","v":""},{"$f":"IF(OR(ISBLANK(C96),C96=\"N/A\"),\"\",IF(C96=\"SE\",IF(O96=\"L\",4,IF(O96=\"A\",5,7)),IF(OR(C96=\"EE\",C96=\"CE\",C96=\"CO\"),IF(O96=\"L\",3,IF(O96=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E96=\"1 - 4\",E96=\"1 - 5\"),3,IF(OR(E96=\"5 - 15\",E96=\"6 - 19\"),10,IF(OR(E96=\">15\",E96=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C96,O96)","v":""},{"$f":"IF(OR(ISBLANK(M96),ISBLANK(F96)),IF(OR(C96=\"ALI\",C96=\"AIE\"),\"L\",IF(ISBLANK(C96),\"\",\"A\")),IF(C96=\"EE\",IF(F96>=3,IF(M96>=5,\"H\",\"A\"),IF(F96>=2,IF(M96>=16,\"H\",IF(M96<=4,\"L\",\"A\")),IF(M96<=15,\"L\",\"A\"))),IF(OR(C96=\"SE\",C96=\"CE\"),IF(F96>=4,IF(M96>=6,\"H\",\"A\"),IF(F96>=2,IF(M96>=20,\"H\",IF(M96<=5,\"L\",\"A\")),IF(M96<=19,\"L\",\"A\"))),IF(OR(C96=\"ALI\",C96=\"AIE\"),IF(F96>=6,IF(M96>=20,\"H\",\"A\"),IF(F96>=2,IF(M96>=51,\"H\",IF(M96<=19,\"L\",\"A\")),IF(M96<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C104),C104=\"N/A\"),\"\",IF(C104=\"SE\",IF(O104=\"L\",4,IF(O104=\"A\",5,7)),IF(OR(C104=\"EE\",C104=\"CE\",C104=\"CO\"),IF(O104=\"L\",3,IF(O104=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E104=\"1 - 4\",E104=\"1 - 5\"),3,IF(OR(E104=\"5 - 15\",E104=\"6 - 19\"),10,IF(OR(E104=\">15\",E104=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C104,O104)","v":""},{"$f":"IF(OR(ISBLANK(M104),ISBLANK(F104)),IF(OR(C104=\"ALI\",C104=\"AIE\"),\"L\",IF(ISBLANK(C104),\"\",\"A\")),IF(C104=\"EE\",IF(F104>=3,IF(M104>=5,\"H\",\"A\"),IF(F104>=2,IF(M104>=16,\"H\",IF(M104<=4,\"L\",\"A\")),IF(M104<=15,\"L\",\"A\"))),IF(OR(C104=\"SE\",C104=\"CE\"),IF(F104>=4,IF(M104>=6,\"H\",\"A\"),IF(F104>=2,IF(M104>=20,\"H\",IF(M104<=5,\"L\",\"A\")),IF(M104<=19,\"L\",\"A\"))),IF(OR(C104=\"ALI\",C104=\"AIE\"),IF(F104>=6,IF(M104>=20,\"H\",\"A\"),IF(F104>=2,IF(M104>=51,\"H\",IF(M104<=19,\"L\",\"A\")),IF(M104<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C135),C135=\"N/A\"),\"\",IF(C135=\"SE\",IF(O135=\"L\",4,IF(O135=\"A\",5,7)),IF(OR(C135=\"EE\",C135=\"CE\",C135=\"CO\"),IF(O135=\"L\",3,IF(O135=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E135=\"1 - 4\",E135=\"1 - 5\"),3,IF(OR(E135=\"5 - 15\",E135=\"6 - 19\"),10,IF(OR(E135=\">15\",E135=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C135,O135)","v":""},{"$f":"IF(OR(ISBLANK(M135),ISBLANK(F135)),IF(OR(C135=\"ALI\",C135=\"AIE\"),\"L\",IF(ISBLANK(C135),\"\",\"A\")),IF(C135=\"EE\",IF(F135>=3,IF(M135>=5,\"H\",\"A\"),IF(F135>=2,IF(M135>=16,\"H\",IF(M135<=4,\"L\",\"A\")),IF(M135<=15,\"L\",\"A\"))),IF(OR(C135=\"SE\",C135=\"CE\"),IF(F135>=4,IF(M135>=6,\"H\",\"A\"),IF(F135>=2,IF(M135>=20,\"H\",IF(M135<=5,\"L\",\"A\")),IF(M135<=19,\"L\",\"A\"))),IF(OR(C135=\"ALI\",C135=\"AIE\"),IF(F135>=6,IF(M135>=20,\"H\",\"A\"),IF(F135>=2,IF(M135>=51,\"H\",IF(M135<=19,\"L\",\"A\")),IF(M135<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C136),C136=\"N/A\"),\"\",IF(C136=\"SE\",IF(O136=\"L\",4,IF(O136=\"A\",5,7)),IF(OR(C136=\"EE\",C136=\"CE\",C136=\"CO\"),IF(O136=\"L\",3,IF(O136=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E136=\"1 - 4\",E136=\"1 - 5\"),3,IF(OR(E136=\"5 - 15\",E136=\"6 - 19\"),10,IF(OR(E136=\">15\",E136=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C136,O136)","v":""},{"$f":"IF(OR(ISBLANK(M136),ISBLANK(F136)),IF(OR(C136=\"ALI\",C136=\"AIE\"),\"L\",IF(ISBLANK(C136),\"\",\"A\")),IF(C136=\"EE\",IF(F136>=3,IF(M136>=5,\"H\",\"A\"),IF(F136>=2,IF(M136>=16,\"H\",IF(M136<=4,\"L\",\"A\")),IF(M136<=15,\"L\",\"A\"))),IF(OR(C136=\"SE\",C136=\"CE\"),IF(F136>=4,IF(M136>=6,\"H\",\"A\"),IF(F136>=2,IF(M136>=20,\"H\",IF(M136<=5,\"L\",\"A\")),IF(M136<=19,\"L\",\"A\"))),IF(OR(C136=\"ALI\",C136=\"AIE\"),IF(F136>=6,IF(M136>=20,\"H\",\"A\"),IF(F136>=2,IF(M136>=51,\"H\",IF(M136<=19,\"L\",\"A\")),IF(M136<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C139),C139=\"N/A\"),\"\",IF(C139=\"SE\",IF(O139=\"L\",4,IF(O139=\"A\",5,7)),IF(OR(C139=\"EE\",C139=\"CE\",C139=\"CO\"),IF(O139=\"L\",3,IF(O139=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E139=\"1 - 4\",E139=\"1 - 5\"),3,IF(OR(E139=\"5 - 15\",E139=\"6 - 19\"),10,IF(OR(E139=\">15\",E139=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C139,O139)","v":""},{"$f":"IF(OR(ISBLANK(M139),ISBLANK(F139)),IF(OR(C139=\"ALI\",C139=\"AIE\"),\"L\",IF(ISBLANK(C139),\"\",\"A\")),IF(C139=\"EE\",IF(F139>=3,IF(M139>=5,\"H\",\"A\"),IF(F139>=2,IF(M139>=16,\"H\",IF(M139<=4,\"L\",\"A\")),IF(M139<=15,\"L\",\"A\"))),IF(OR(C139=\"SE\",C139=\"CE\"),IF(F139>=4,IF(M139>=6,\"H\",\"A\"),IF(F139>=2,IF(M139>=20,\"H\",IF(M139<=5,\"L\",\"A\")),IF(M139<=19,\"L\",\"A\"))),IF(OR(C139=\"ALI\",C139=\"AIE\"),IF(F139>=6,IF(M139>=20,\"H\",\"A\"),IF(F139>=2,IF(M139>=51,\"H\",IF(M139<=19,\"L\",\"A\")),IF(M139<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C140),C140=\"N/A\"),\"\",IF(C140=\"SE\",IF(O140=\"L\",4,IF(O140=\"A\",5,7)),IF(OR(C140=\"EE\",C140=\"CE\",C140=\"CO\"),IF(O140=\"L\",3,IF(O140=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E140=\"1 - 4\",E140=\"1 - 5\"),3,IF(OR(E140=\"5 - 15\",E140=\"6 - 19\"),10,IF(OR(E140=\">15\",E140=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C140,O140)","v":""},{"$f":"IF(OR(ISBLANK(M140),ISBLANK(F140)),IF(OR(C140=\"ALI\",C140=\"AIE\"),\"L\",IF(ISBLANK(C140),\"\",\"A\")),IF(C140=\"EE\",IF(F140>=3,IF(M140>=5,\"H\",\"A\"),IF(F140>=2,IF(M140>=16,\"H\",IF(M140<=4,\"L\",\"A\")),IF(M140<=15,\"L\",\"A\"))),IF(OR(C140=\"SE\",C140=\"CE\"),IF(F140>=4,IF(M140>=6,\"H\",\"A\"),IF(F140>=2,IF(M140>=20,\"H\",IF(M140<=5,\"L\",\"A\")),IF(M140<=19,\"L\",\"A\"))),IF(OR(C140=\"ALI\",C140=\"AIE\"),IF(F140>=6,IF(M140>=20,\"H\",\"A\"),IF(F140>=2,IF(M140>=51,\"H\",IF(M140<=19,\"L\",\"A\")),IF(M140<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C154),C154=\"N/A\"),\"\",IF(C154=\"SE\",IF(O154=\"L\",4,IF(O154=\"A\",5,7)),IF(OR(C154=\"EE\",C154=\"CE\",C154=\"CO\"),IF(O154=\"L\",3,IF(O154=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E154=\"1 - 4\",E154=\"1 - 5\"),3,IF(OR(E154=\"5 - 15\",E154=\"6 - 19\"),10,IF(OR(E154=\">15\",E154=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C154,O154)","v":""},{"$f":"IF(OR(ISBLANK(M154),ISBLANK(F154)),IF(OR(C154=\"ALI\",C154=\"AIE\"),\"L\",IF(ISBLANK(C154),\"\",\"A\")),IF(C154=\"EE\",IF(F154>=3,IF(M154>=5,\"H\",\"A\"),IF(F154>=2,IF(M154>=16,\"H\",IF(M154<=4,\"L\",\"A\")),IF(M154<=15,\"L\",\"A\"))),IF(OR(C154=\"SE\",C154=\"CE\"),IF(F154>=4,IF(M154>=6,\"H\",\"A\"),IF(F154>=2,IF(M154>=20,\"H\",IF(M154<=5,\"L\",\"A\")),IF(M154<=19,\"L\",\"A\"))),IF(OR(C154=\"ALI\",C154=\"AIE\"),IF(F154>=6,IF(M154>=20,\"H\",\"A\"),IF(F154>=2,IF(M154>=51,\"H\",IF(M154<=19,\"L\",\"A\")),IF(M154<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C160<>\"N/A\",C160<>\"\"),IF(O160=\"L\",\"Baja\",IF(O160=\"A\",\"Media\",IF(O160=\"\",\"\",\"Alta\"))),\"\")","v":""},"",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C218),C218=\"N/A\"),\"\",IF(C218=\"SE\",IF(O218=\"L\",4,IF(O218=\"A\",5,7)),IF(OR(C218=\"EE\",C218=\"CE\",C218=\"CO\"),IF(O218=\"L\",3,IF(O218=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E218=\"1 - 4\",E218=\"1 - 5\"),3,IF(OR(E218=\"5 - 15\",E218=\"6 - 19\"),10,IF(OR(E218=\">15\",E218=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C218,O218)","v":""},{"$f":"IF(OR(ISBLANK(M218),ISBLANK(F218)),IF(OR(C218=\"ALI\",C218=\"AIE\"),\"L\",IF(ISBLANK(C218),\"\",\"A\")),IF(C218=\"EE\",IF(F218>=3,IF(M218>=5,\"H\",\"A\"),IF(F218>=2,IF(M218>=16,\"H\",IF(M218<=4,\"L\",\"A\")),IF(M218<=15,\"L\",\"A\"))),IF(OR(C218=\"SE\",C218=\"CE\"),IF(F218>=4,IF(M218>=6,\"H\",\"A\"),IF(F218>=2,IF(M218>=20,\"H\",IF(M218<=5,\"L\",\"A\")),IF(M218<=19,\"L\",\"A\"))),IF(OR(C218=\"ALI\",C218=\"AIE\"),IF(F218>=6,IF(M218>=20,\"H\",\"A\"),IF(F218>=2,IF(M218>=51,\"H\",IF(M218<=19,\"L\",\"A\")),IF(M218<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C224<>\"N/A\",C224<>\"\"),IF(O224=\"L\",\"Baja\",IF(O224=\"A\",\"Media\",IF(O224=\"\",\"\",\"Alta\"))),\"\")","v":""},"",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"",{"$f":"IF(OR(ISBLANK(C282),C282=\"N/A\"),\"\",IF(C282=\"SE\",IF(O282=\"L\",4,IF(O282=\"A\",5,7)),IF(OR(C282=\"EE\",C282=\"CE\",C282=\"CO\"),IF(O282=\"L\",3,IF(O282=\"A\",4,6)))))","v":""},null,null,null,null,{"$f":"IF(OR(E282=\"1 - 4\",E282=\"1 - 5\"),3,IF(OR(E282=\"5 - 15\",E282=\"6 - 19\"),10,IF(OR(E282=\">15\",E282=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(C282,O282)","v":""},{"$f":"IF(OR(ISBLANK(M282),ISBLANK(F282)),IF(OR(C282=\"ALI\",C282=\"AIE\"),\"L\",IF(ISBLANK(C282),\"\",\"A\")),IF(C282=\"EE\",IF(F282>=3,IF(M282>=5,\"H\",\"A\"),IF(F282>=2,IF(M282>=16,\"H\",IF(M282<=4,\"L\",\"A\")),IF(M282<=15,\"L\",\"A\"))),IF(OR(C282=\"SE\",C282=\"CE\"),IF(F282>=4,IF(M282>=6,\"H\",\"A\"),IF(F282>=2,IF(M282>=20,\"H\",IF(M282<=5,\"L\",\"A\")),IF(M282<=19,\"L\",\"A\"))),IF(OR(C282=\"ALI\",C282=\"AIE\"),IF(F282>=6,IF(M282>=20,\"H\",\"A\"),IF(F282>=2,IF(M282>=51,\"H\",IF(M282<=19,\"L\",\"A\")),IF(M282<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,{"$f":"IF(AND(C288<>\"N/A\",C288<>\"\"),IF(O288=\"L\",\"Baja\",IF(O288=\"A\",\"Media\",IF(O288=\"\",\"\",\"Alta\"))),\"\")","v":""},"",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]
[null,null,null,null,null,null,"","",null,null,null,null,10,"",""]

{"sheet":"Funciones de prueba","index":3,"n_rows":143,"n_cols":12,"rows_kept":143,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1],[11,9,11,11],[6,0,6,3],[11,4,12,4],[11,5,12,5],[11,2,12,2],[11,3,12,3],[11,0,12,0],[11,1,12,1],[11,6,12,6],[11,7,12,7]]}
["RESUMEN DEL CONTEO"]
["FUNCIONES DE TRANSACCIÓN"]
["TIPO","CANTID."]
["Entradas Externas (EE)",{"$f":"COUNTIF($B$14:$B$1000,A4)","v":0}]
["Consultas Externas (CE)",{"$f":"COUNTIF($B$14:$B$1000,A5)","v":0}]
["Salidas Externas (SE)",{"$f":"COUNTIF($B$14:$B$1000,A6)","v":0}]
["TIPO"]
["TIPO","CANTID.","PF-B","PF-I"]
["Puntos de función de prueba",{"$f":"COUNTA(B14:B138)","v":0},{"$f":"SUM(F14:F138)","v":0},{"$f":"C9*Datos!$E$26","v":0}]
[null,null,{"$f":"SUM(C9:C9)","v":0}]
[{"$f":"CONCATENATE(\"PF Inalterado: \",C10)","v":"PF Inalterado: 0"},{"$f":"CONCATENATE(\"PF Impacto: \",SUM(D9))","v":"PF Impacto: 0"}]
["PROCESO PRINCIPAL","TIPO","DER","ALR","CPLX","PF","Funciones de datos involucradas (ALR)","Requisito/observación/justificación",null,"Critérios"]
[null,null,null,null,null,null,null,null,null,"DER","ctl","C"]
[null,null,null,null,{"$f":"IF(L14=\"L\",\"Baja\",IF(L14=\"A\",\"Media\",IF(L14=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(ISBLANK(B14),\"\",IF(B14=\"SE\",IF(L14=\"L\",4,IF(L14=\"A\",5,7)),IF(OR(B14=\"EE\",B14=\"CE\",B14=\"CO\"),IF(L14=\"L\",3,IF(L14=\"A\",4,6)))))","v":""},null,null,null,{"$f":"IF(OR(C14=\"1 - 4\",C14=\"1 - 5\"),3,IF(OR(C14=\"5 - 15\",C14=\"6 - 19\"),10,IF(OR(C14=\">15\",C14=\">19\"),20,10)))","v":10},{"$f":"CONCATENATE(B14,L14)","v":""},{"$f":"IF(OR(ISBLANK(J14),ISBLANK(D14)),IF(OR(B14=\"ALI\",B14=\"AIE\"),\"L\",IF(ISBLANK(B14),\"\",\"A\")),IF(B14=\"EE\",IF(D14>=3,IF(J14>=5,\"H\",\"A\"),IF(D14>=2,IF(J14>=16,\"H\",IF(J14<=4,\"L\",\"A\")),IF(J14<=15,\"L\",\"A\"))),IF(OR(B14=\"SE\",B14=\"CE\"),IF(D14>=4,IF(J14>=6,\"H\",\"A\"),IF(D14>=2,IF(J14>=20,\"H\",IF(J14<=5,\"L\",\"A\")),IF(J14<=19,\"L\",\"A\"))),IF(OR(B14=\"ALI\",B14=\"AIE\"),IF(D14>=6,IF(J14>=20,\"H\",\"A\"),IF(D14>=2,IF(J14>=51,\"H\",IF(J14<=19,\"L\",\"A\")),IF(J14<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,{"$f":"IF(L15=\"L\",\"Baja\",IF(L15=\"A\",\"Media\",IF(L15=\"\",\"\",\"Alta\")))","v":""},"",null,null,null,{"$f":"IF(OR(C15=\"1 - 4\",C15=\"1 - 5\"),3,IF(OR(C15=\"5 - 15\",C15=\"6 - 19\"),10,IF(OR(C15=\">15\",C15=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C16=\"1 - 4\",C16=\"1 - 5\"),3,IF(OR(C16=\"5 - 15\",C16=\"6 - 19\"),10,IF(OR(C16=\">15\",C16=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C17=\"1 - 4\",C17=\"1 - 5\"),3,IF(OR(C17=\"5 - 15\",C17=\"6 - 19\"),10,IF(OR(C17=\">15\",C17=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C19=\"1 - 4\",C19=\"1 - 5\"),3,IF(OR(C19=\"5 - 15\",C19=\"6 - 19\"),10,IF(OR(C19=\">15\",C19=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"",{"$f":"IF(ISBLANK(B46),\"\",IF(B46=\"SE\",IF(L46=\"L\",4,IF(L46=\"A\",5,7)),IF(OR(B46=\"EE\",B46=\"CE\",B46=\"CO\"),IF(L46=\"L\",3,IF(L46=\"A\",4,6)))))","v":""},null,null,null,10,{"$f":"CONCATENATE(B46,L46)","v":""},{"$f":"IF(OR(ISBLANK(J46),ISBLANK(D46)),IF(OR(B46=\"ALI\",B46=\"AIE\"),\"L\",IF(ISBLANK(B46),\"\",\"A\")),IF(B46=\"EE\",IF(D46>=3,IF(J46>=5,\"H\",\"A\"),IF(D46>=2,IF(J46>=16,\"H\",IF(J46<=4,\"L\",\"A\")),IF(J46<=15,\"L\",\"A\"))),IF(OR(B46=\"SE\",B46=\"CE\"),IF(D46>=4,IF(J46>=6,\"H\",\"A\"),IF(D46>=2,IF(J46>=20,\"H\",IF(J46<=5,\"L\",\"A\")),IF(J46<=19,\"L\",\"A\"))),IF(OR(B46=\"ALI\",B46=\"AIE\"),IF(D46>=6,IF(J46>=20,\"H\",\"A\"),IF(D46>=2,IF(J46>=51,\"H\",IF(J46<=19,\"L\",\"A\")),IF(J46<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C51=\"1 - 4\",C51=\"1 - 5\"),3,IF(OR(C51=\"5 - 15\",C51=\"6 - 19\"),10,IF(OR(C51=\">15\",C51=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"",{"$f":"IF(ISBLANK(B78),\"\",IF(B78=\"SE\",IF(L78=\"L\",4,IF(L78=\"A\",5,7)),IF(OR(B78=\"EE\",B78=\"CE\",B78=\"CO\"),IF(L78=\"L\",3,IF(L78=\"A\",4,6)))))","v":""},null,null,null,10,{"$f":"CONCATENATE(B78,L78)","v":""},{"$f":"IF(OR(ISBLANK(J78),ISBLANK(D78)),IF(OR(B78=\"ALI\",B78=\"AIE\"),\"L\",IF(ISBLANK(B78),\"\",\"A\")),IF(B78=\"EE\",IF(D78>=3,IF(J78>=5,\"H\",\"A\"),IF(D78>=2,IF(J78>=16,\"H\",IF(J78<=4,\"L\",\"A\")),IF(J78<=15,\"L\",\"A\"))),IF(OR(B78=\"SE\",B78=\"CE\"),IF(D78>=4,IF(J78>=6,\"H\",\"A\"),IF(D78>=2,IF(J78>=20,\"H\",IF(J78<=5,\"L\",\"A\")),IF(J78<=19,\"L\",\"A\"))),IF(OR(B78=\"ALI\",B78=\"AIE\"),IF(D78>=6,IF(J78>=20,\"H\",\"A\"),IF(D78>=2,IF(J78>=51,\"H\",IF(J78<=19,\"L\",\"A\")),IF(J78<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,{"$f":"IF(L79=\"L\",\"Baja\",IF(L79=\"A\",\"Media\",IF(L79=\"\",\"\",\"Alta\")))","v":""},"",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C83=\"1 - 4\",C83=\"1 - 5\"),3,IF(OR(C83=\"5 - 15\",C83=\"6 - 19\"),10,IF(OR(C83=\">15\",C83=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"",{"$f":"IF(ISBLANK(B110),\"\",IF(B110=\"SE\",IF(L110=\"L\",4,IF(L110=\"A\",5,7)),IF(OR(B110=\"EE\",B110=\"CE\",B110=\"CO\"),IF(L110=\"L\",3,IF(L110=\"A\",4,6)))))","v":""},null,null,null,10,{"$f":"CONCATENATE(B110,L110)","v":""},{"$f":"IF(OR(ISBLANK(J110),ISBLANK(D110)),IF(OR(B110=\"ALI\",B110=\"AIE\"),\"L\",IF(ISBLANK(B110),\"\",\"A\")),IF(B110=\"EE\",IF(D110>=3,IF(J110>=5,\"H\",\"A\"),IF(D110>=2,IF(J110>=16,\"H\",IF(J110<=4,\"L\",\"A\")),IF(J110<=15,\"L\",\"A\"))),IF(OR(B110=\"SE\",B110=\"CE\"),IF(D110>=4,IF(J110>=6,\"H\",\"A\"),IF(D110>=2,IF(J110>=20,\"H\",IF(J110<=5,\"L\",\"A\")),IF(J110<=19,\"L\",\"A\"))),IF(OR(B110=\"ALI\",B110=\"AIE\"),IF(D110>=6,IF(J110>=20,\"H\",\"A\"),IF(D110>=2,IF(J110>=51,\"H\",IF(J110<=19,\"L\",\"A\")),IF(J110<=50,\"L\",\"A\")))))))","v":""}]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,{"$f":"IF(OR(C115=\"1 - 4\",C115=\"1 - 5\"),3,IF(OR(C115=\"5 - 15\",C115=\"6 - 19\"),10,IF(OR(C115=\">15\",C115=\">19\"),20,10)))","v":10},"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[null,null,null,null,"","",null,null,null,10,"",""]
[]
["Tipo"]
["CE",{"$f":"IF(#REF!=\"L\",\"Baixa\",IF(#REF!=\"A\",\"Média\",IF(#REF!=\"\",\"\",\"Alta\")))","v":{"$error":"#REF!"}}]
["SE",{"$f":"IF(#REF!=\"L\",\"Baixa\",IF(#REF!=\"A\",\"Média\",IF(#REF!=\"\",\"\",\"Alta\")))","v":{"$error":"#REF!"}}]
["EE",{"$f":"IF(#REF!=\"L\",\"Baixa\",IF(#REF!=\"A\",\"Média\",IF(#REF!=\"\",\"\",\"Alta\")))","v":{"$error":"#REF!"}}]

{"sheet":"Ítems no mesurasbles","index":4,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":true,"merged":[[27,0,27,12],[31,0,31,4],[32,3,32,4]]}
[]
["ARTEFACTO","DESCRIPCIÓN","CLASIFICACIÓN DEL ÍTEM NO MESURABLE",null,"TIPO DE FUNCIÓN\n (si procede)","DET","FTR","ctl","C","CPLX","PF","CANTID.","FACTOR","TOTAL"]
[null,null,null,{"$f":"IF(C3<>\"\",VLOOKUP(C3,$A$34:N53,5,FALSE),\"\")","v":""},null,null,null,{"$f":"CONCATENATE(E3,I3)","v":""},{"$f":"IF(OR(ISBLANK(F3),ISBLANK(G3)),IF(OR(E3=\"ALI\",E3=\"AIE\"),\"L\",IF(ISBLANK(E3),\"\",\"A\")),IF(E3=\"EE\",IF(G3>=3,IF(F3>=5,\"H\",\"A\"),IF(G3>=2,IF(F3>=16,\"H\",IF(F3<=4,\"L\",\"A\")),IF(F3<=15,\"L\",\"A\"))),IF(OR(E3=\"SE\",E3=\"CE\"),IF(G3>=4,IF(F3>=6,\"H\",\"A\"),IF(G3>=2,IF(F3>=20,\"H\",IF(F3<=5,\"L\",\"A\")),IF(F3<=19,\"L\",\"A\"))),IF(OR(E3=\"ALI\",E3=\"AIE\"),IF(G3>=6,IF(F3>=20,\"H\",\"A\"),IF(G3>=2,IF(F3>=51,\"H\",IF(F3<=19,\"L\",\"A\")),IF(F3<=50,\"L\",\"A\")))))))","v":""},{"$f":"IF(I3=\"L\",\"Baja\",IF(I3=\"A\",\"Media\",IF(I3=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(ISBLANK(E3),\"\",IF(E3=\"ALI\",IF(I3=\"L\",7,IF(I3=\"A\",10,15)),IF(E3=\"AIE\",IF(I3=\"L\",5,IF(I3=\"A\",7,10)),IF(E3=\"SE\",IF(I3=\"L\",4,IF(I3=\"A\",5,7)),IF(OR(E3=\"EE\",E3=\"CE\"),IF(I3=\"L\",3,IF(I3=\"A\",4,6)))))))","v":""},null,{"$f":"IF(C3=\"\",\"\",VLOOKUP(C3,A$34:K$53,2,0))","v":""},{"$f":"IF(OR(C3=\"\",AND(K3=\"\",L3=\"\")),\"\",IF(D3=\"Quantidade\",L3*M3,IF(D3=\"Contado\",K3*M3,IF(ISBLANK(D3),\"\"))))","v":""}]
[null,null,null,{"$f":"IF(C4<>\"\",VLOOKUP(C4,$A$34:N54,5,FALSE),\"\")","v":""},null,null,null,{"$f":"CONCATENATE(E4,I4)","v":""},{"$f":"IF(OR(ISBLANK(F4),ISBLANK(G4)),IF(OR(E4=\"ALI\",E4=\"AIE\"),\"L\",IF(ISBLANK(E4),\"\",\"A\")),IF(E4=\"EE\",IF(G4>=3,IF(F4>=5,\"H\",\"A\"),IF(G4>=2,IF(F4>=16,\"H\",IF(F4<=4,\"L\",\"A\")),IF(F4<=15,\"L\",\"A\"))),IF(OR(E4=\"SE\",E4=\"CE\"),IF(G4>=4,IF(F4>=6,\"H\",\"A\"),IF(G4>=2,IF(F4>=20,\"H\",IF(F4<=5,\"L\",\"A\")),IF(F4<=19,\"L\",\"A\"))),IF(OR(E4=\"ALI\",E4=\"AIE\"),IF(G4>=6,IF(F4>=20,\"H\",\"A\"),IF(G4>=2,IF(F4>=51,\"H\",IF(F4<=19,\"L\",\"A\")),IF(F4<=50,\"L\",\"A\")))))))","v":""},{"$f":"IF(I4=\"L\",\"Baja\",IF(I4=\"A\",\"Media\",IF(I4=\"\",\"\",\"Alta\")))","v":""},{"$f":"IF(ISBLANK(E4),\"\",IF(E4=\"ALI\",IF(I4=\"L\",7,IF(I4=\"A\",10,15)),IF(E4=\"AIE\",IF(I4=\"L\",5,IF(I4=\"A\",7,10)),IF(E4=\"SE\",IF(I4=\"L\",4,IF(I4=\"A\",5,7)),IF(OR(E4=\"EE\",E4=\"CE\"),IF(I4=\"L\",3,IF(I4=\"A\",4,6)))))))","v":""},null,{"$f":"IF(C4=\"\",\"\",VLOOKUP(C4,A$34:K$53,2,0))","v":""},{"$f":"IF(OR(C4=\"\",AND(K4=\"\",L4=\"\")),\"\",IF(D4=\"Quantidade\",L4*M4,IF(D4=\"Contado\",K4*M4,IF(ISBLANK(D4),\"\"))))","v":""}]
[null,null,null,{"$f":"IF(C5<>\"\",VLOOKUP(C5,$A$34:N55,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",{"$f":"IF(OR(C5=\"\",AND(K5=\"\",L5=\"\")),\"\",IF(D5=\"Quantidade\",L5*M5,IF(D5=\"Contado\",K5*M5,IF(ISBLANK(D5),\"\"))))","v":""}]
[null,null,null,{"$f":"IF(C6<>\"\",VLOOKUP(C6,$A$34:N56,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C7<>\"\",VLOOKUP(C7,$A$34:N57,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C8<>\"\",VLOOKUP(C8,$A$34:N58,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C9<>\"\",VLOOKUP(C9,$A$34:N59,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C10<>\"\",VLOOKUP(C10,$A$34:N60,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C11<>\"\",VLOOKUP(C11,$A$34:N61,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C12<>\"\",VLOOKUP(C12,$A$34:N62,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C13<>\"\",VLOOKUP(C13,$A$34:N63,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C14<>\"\",VLOOKUP(C14,$A$34:N64,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C15<>\"\",VLOOKUP(C15,$A$34:N65,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C16<>\"\",VLOOKUP(C16,$A$34:N66,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C17<>\"\",VLOOKUP(C17,$A$34:N67,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C18<>\"\",VLOOKUP(C18,$A$34:N68,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C19<>\"\",VLOOKUP(C19,$A$34:N69,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C20<>\"\",VLOOKUP(C20,$A$34:N70,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C21<>\"\",VLOOKUP(C21,$A$34:N71,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C22<>\"\",VLOOKUP(C22,$A$34:N72,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C23<>\"\",VLOOKUP(C23,$A$34:N73,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C24<>\"\",VLOOKUP(C24,$A$34:N74,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C25<>\"\",VLOOKUP(C25,$A$34:N75,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C26<>\"\",VLOOKUP(C26,$A$34:N76,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
[null,null,null,{"$f":"IF(C27<>\"\",VLOOKUP(C27,$A$34:N77,5,FALSE),\"\")","v":""},null,null,null,"","","","",null,"",""]
["TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:N27)","v":0}]
[]
[]
[]
["TABLA DE REFERENCIA PARA INM"]
["BASE DE CÁLCULO","FACTOR DE EQUIVALENCIA","DESCRIPCIÓN DE LA CLASIFICACIÓN DEL ÍTEM NO MEDIBLE","REF. EN SISP"]
["1 - Mantenimiento de la interfaz (cosmética)",0.6,"Demandas de cambios de interfaz, por ejemplo: tipo de letra, colores de pantalla, logotipos, cambio de botones en pantalla, cambio de posición de campos o texto en pantalla. Ejemplos:\n \n- Cambios de texto en mensajes de error, validación, advertencia, alerta, confirmación de registro o finalización de procesamiento.  \n- Cambio en texto estático de correo electrónico enviado al usuario en una función de registro.   \n- Cambio de título de un informe.  \n- Cambio de etiquetas de una pantalla de consulta/registro.  \n- Inclusión de ítems de menú/acceso directo incluido/modificado de funciones existentes.  \n- Inclusión/modificación/eliminación de datos en lista y tablas físicas de apoyo que no tienen función administrativa.\n- Cambio de soporte estático de funcionalidad.","4.7","Cantidad"]
["2 - Adaptación de funcionalidades sin cambiar los Requisitos Funcionales (adaptativa)",0.5,"Demandas de mantenimiento adaptativo asociadas a solicitudes que impliquen aspectos no funcionales, sin cambios en los requisitos funcionales. Ejemplos:  \n\n- Aumentar la cantidad de líneas por página en un informe.  \n- Insertar paginación en un informe.  \n- Limitar la cantidad de renglones por página en una consulta existente.  \n- Permitir múltiples eliminaciones en una funcionalidad que antes solo permitía la eliminación de un ítem.  \n- Adaptación de una funcionalidad para hacer posible la llamada por un servicio web u otro tipo de integración con otros sistemas.  \n- Replicación de funcionalidad: llamar una consulta existente en otra pantalla de la aplicación.  \n- Cambio en la aplicación para adaptación a los cambios realizados en la interfaz con rutinas de integración con otros softwares, por ejemplo, cambio en subrutinas llamadas por este software.  \n- Modificar el servidor a ser accedido en una funcionalidad de descarga de archivo.  \n","4.8","Contado"]
["3 - Averiguación especial - Base de datos (actualización de datos sin consulta previa)",1,"Actualización de los datos directamente sin previa consulta","4.9.1 (a)","Contado"]
["4 - Averiguación especial - Base de datos (consulta previa sin actualización)",1,"Consulta previa para la posterior manipulación de datos","4.9.1 (b)","Contado"]
["5 - Averiguación especial - Base de datos (actualización de datos con consulta previa)",0.6,"Actualización de los datos tras la elaboración de informes de extracción/consulta de datos","4.9.1 (c)","Contado"]
["6 - Averiguación especial – Generación de informes",1,"Generar informe mediante script directo de la base para reutilización","4.9.2","Contado"]
["7 - Averiguación especial - Reejecución",0.1,"Actualización o consulta a BD a través de secuencias de comandos que ya se han utilizado anteriormente","4.9.3","Contado"]
["8 - Actualización de datos (registro único)",0.1,"Actualización interactiva en un solo registro con 1 (uno) o más datos implicados","4.10","Contado"]
["9 - Desarrollo, mantenimiento y publicación de páginas estáticas de Intranet, Internet o Portal",0.6,"Soporte en las páginas estáticas de intranet, Internet o portal:\n\n- Actualización de menú estático de páginas HTML\n - Actualización de páginas estáticas HTML\n - Actualización de textos en páginas estáticas HTML\n - Actualización de banners estáticos en HTML","4.11","Cantidad"]
["10 - Componente interno reusable",0.5,"Mantenimiento en componentes específicos de una aplicación reutilizados por varias características de la aplicación. Este componente se considerará como un proceso principal independiente y se contará como una funcionalidad. Ejemplo:\n• Cambio en el tema de un menú de un sistema en PHP que aparece en todas las pantallas de la aplicación. El conteo se puede realizar considerando el componente “Presentar menú”.","4.15","Contado"]
["11 - Componente interno reutilizable en archivo",0.6,"De forma complementaria al ítem 12, hay casos en los que se realizan los mantenimientos de los valores de los elementos de configuración que afectan el comportamiento o la presentación del sistema en general, como páginas de estilos (archivos CSS de sistemas web), archivos con mensajes de error, archivos de configuración del sistema y archivos de internacionalización (factor fijo).","4.15","Cantidad"]
["12 - Inclusión de tabla code table",1,"CODEDATA : inclusión de tabla code table","-","Cantidad"]
["13 - Cambio de tabla code table",0.6,"CODEDATA : cambio de tabla code table","-","Cantidad"]
["14 - Cambio de contenido de tabla code table",0.1,"CODEDATA : cambio de contenido de tabla code table","-","Cantidad"]
["15 - Eliminación de tabla code table",0.4,"CODEDATA : eliminación de tabla code table","-","Cantidad"]
["16 - Inclusión de funcionalidad code table",0.3,"CODEDATA - inclusión de la funcionalidad code table","-","Cantidad"]
["17 - Cambio de funcionalidad code table",0.2,"CODEDATA : cambio de funcionalidad code table","-","Cantidad"]
["18 - Eliminación de funcionalidad code table",0.1,"CODEDATA : eliminación de la funcionalidad code table","-","Cantidad"]
["19 - Parámetros ajustados",0.1,"Parámetros ajustados que no modifican el comportamiento funcional y que no modifican la lógica de procesamiento (se mantienen las reglas involucradas)","-","Cantidad"]
["20 - Inclusión del registro del windows",1,"Inclusión de registro del windows: cuando el usuario solicite el almacenamiento del registro de transacciones en el propio entorno operativo","-","Cantidad"]
[]
[]
[]
[]
["ALI"]
["AIE"]
["EE"]
["CE"]
["SE"]

{"sheet":"Sumário","index":5,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":true,"merged":[[3,0,4,1],[3,2,4,5],[3,6,4,6],[3,7,4,7],[0,0,2,7]]}
["Sumário da Contagem"]
[]
[]
["Tipo de Função",null,"Complexidade Funcional",null,null,null,"Total por Complexidade"]
[]
[]
[null,"EE",{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"EE\",'Funciones de transacción'!$G$17:$G$1008,E7)","v":0},null,"Baixa","x 3",{"$f":"C7*3","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"EE\",'Funciones de transacción'!$G$17:$G$1008,E8)","v":0},null,"Média","x 4",{"$f":"C8*4","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"EE\",'Funciones de transacción'!$G$17:$G$1008,E9)","v":0},null,"Alta","x 6",{"$f":"C9*6","v":0}]
[]
[null,"Qnt. EE",{"$f":"SUM(C7:C9)","v":0},null,null,"Total PF ",{"$f":"SUM(G7:G9)","v":0}]
[]
[]
[null,"SE",{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"SE\",'Funciones de transacción'!$G$17:$G$1008,E14)","v":0},null,"Baixa","x 4",{"$f":"C14*4","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"SE\",'Funciones de transacción'!$G$17:$G$1008,E15)","v":0},null,"Média","x 5",{"$f":"C15*5","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"SE\",'Funciones de transacción'!$G$17:$G$1008,E16)","v":1},null,"Alta","x 7",{"$f":"C16*7","v":7}]
[]
[null,"Qnt. SE",{"$f":"SUM(C14:C16)","v":1},null,null,"Total PF",{"$f":"SUM(G14:G16)","v":7}]
[]
[]
[null,"CE",{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"CE\",'Funciones de transacción'!$G$17:$G$1008,E21)","v":0},null,"Baixa","x 3",{"$f":"C21*3","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"CE\",'Funciones de transacción'!$G$17:$G$1008,E22)","v":0},null,"Média","x 4",{"$f":"C22*4","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de transacción'!$C$17:$C$1008,\"CE\",'Funciones de transacción'!$G$17:$G$1008,E23)","v":0},null,"Alta","x 6",{"$f":"C23*6","v":0}]
[]
[null,"Qnt. CE",{"$f":"SUM(C21:C23)","v":0},null,null,"Total PF",{"$f":"SUM(G21:G23)","v":0}]
[]
[]
[null,"ALI",{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"ALI\",'Funciones de datos'!$F$15:$F$999,E28)","v":0},null,"Baixa","x 7",{"$f":"C28*7","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"ALI\",'Funciones de datos'!$F$15:$F$999,E29)","v":0},null,"Média","x 10",{"$f":"C29*10","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"ALI\",'Funciones de datos'!$F$15:$F$999,E30)","v":0},null,"Alta","x 15",{"$f":"C30*15","v":0}]
[]
[null,"Qnt. ALI",{"$f":"SUM(C28:C30)","v":0},null,null,"Total PF",{"$f":"SUM(G28:G30)","v":0}]
[]
[]
[null,"AIE",{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"AIE\",'Funciones de datos'!$F$15:$F$999,E35)","v":0},null,"Baixa","x 5",{"$f":"C35*5","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"AIE\",'Funciones de datos'!$F$15:$F$999,E36)","v":0},null,"Média","x 7",{"$f":"C36*7","v":0}]
[null,null,{"$f":"COUNTIFS('Funciones de datos'!$B$15:$B$999,\"AIE\",'Funciones de datos'!$F$15:$F$999,E37)","v":0},null,"Alta","x 10",{"$f":"C37*10","v":0}]
[]
[null,"Qnt. AIE",{"$f":"SUM(C35:C37)","v":0},null,null,"Total PF",{"$f":"SUM(G35:G37)","v":0}]
[]
[]
[null,null,"TOTAL SISP",null,"TOTAL IFPUG"]
[null,null,{"$f":"\"\"&SUM(E39,E32,E25,E18,E11)","v":"0"},null,{"$f":"\"\"&SUM(G39,G32,G25,G18,G11)","v":"7"}]

{"sheet":"PAR","index":6,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":true,"merged":[[2,26,8,26],[2,27,8,27],[1,6,1,8],[16,0,16,2],[10,0,10,2],[5,0,5,2],[2,23,8,23],[2,24,8,24],[2,25,8,25]]}
["EE","CE","SE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage Effort by Lifecycle Phase"]
["1 - 4","1 - 5","1 - 5",null,"PF",{"$f":"IF(Datos!F28<>0,Datos!F28,\"\")","v":""},"ou",null,null,"SLOC ref.",{"$f":"_EAF!B7","v":53},"Java/ Sistemas de alta complex."]
["5 - 15","6 - 19","6 - 19",null,"SLOC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Architectural\nDesign","Software Design ","Implementation \n","Integration Testing ","Total Effort by\nActivity"]
[">15",">19",">19",null,"SIZE",{"$f":"IF(F2<>\"\",(F2*K2)/1000,F3/1000)","v":0}]
[null,null,null,null,"EAF",{"$f":"_EAF!B11","v":0}]
["Lista de Tipos de FD",null,null,null,"HM",{"$f":"_EAF!B2","v":152}]
["ALI"]
["AIE",null,null,null,"A",{"$f":"_EAF!B3","v":1.6316999999999999}]
["N/A",null,null,null,"B",{"$f":"_EAF!B4","v":0.91},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Activity"]
[null,null,null,null,"C",{"$f":"_EAF!B5","v":3.67},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Management",1.2200000000000001E-2,2.0500000000000001E-2,5.6099999999999997E-2,0,8.8900000000000007E-2]
["Lista de Tipos de FT",null,null,null,"D",{"$f":"_EAF!B6","v":0.28000000000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirements Engineering ",1.2200000000000001E-2,1.9400000000000001E-2,3.7100000000000001E-2,0,6.8699999999999997E-2]
["EE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Engineering",1.2200000000000001E-2,2.3300000000000001E-2,7.7799999999999994E-2,5.1799999999999999E-2,0.16520000000000001]
["CE",null,null,null,"Idealmente, deve-se calibrar A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Software Engineering",6.4399999999999999E-2,8.8499999999999995E-2,0.36940000000000001,3.56E-2,0.55789999999999995]
["SE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Support",1.2999999999999999E-2,1.6199999999999999E-2,7.4300000000000005E-2,1.5800000000000002E-2,0.1193]
["N/A",null,null,null,"PM =","A","* ","(Size","^","E)","* ","Produtório (i=1 até n, EM(i))",null,null,"TDEV =","C","*","PM","^","F",null,null,"Total Effort by Phase",0.1142,0.16789999999999999,0.61480000000000001,0.1031,1]
[null,null,null,null,{"$f":"F16*H16^J17*L16","v":0},{"$f":"_A","v":1.6316999999999999},null,{"$f":"F4","v":0},null,"E = B + 0,01 * SOMA_ESC",null,{"$f":"_EAF","v":0},null,null,{"$f":"P16*(R16^T17)","v":0},{"$f":"_C","v":3.67},null,{"$f":"_PM","v":0},null,"F = D + 0,2 * (E - B)",null,null,"Management",{"$f":"_EFFORT*1.22%","v":0},{"$f":"_EFFORT*0.0205","v":0},{"$f":"_EFFORT*0.0561","v":0},{"$f":"_EFFORT*0","v":0},{"$f":"_EFFORT*0.0889","v":0}]
["Lista de Tipos de Operação",null,null,null,"Pessoas/Mês",null,null,null,null,{"$f":"_B+0.01*_FESCALA","v":1.0996999999999999},null,null,null,null,"Meses",null,null,null,null,{"$f":"_D+0.2*(_E-_B)","v":0.31794},null,null,"Requirements Engineering ",{"$f":"_EFFORT*0.0122","v":0},{"$f":"_EFFORT*0.0194","v":0},{"$f":"_EFFORT*0.0371","v":0},{"$f":"_EFFORT*0","v":0},{"$f":"_EFFORT*0.0687","v":0}]
["Inclusión",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test Engineering",{"$f":"_EFFORT*0.0122","v":0},{"$f":"_EFFORT*0.0233","v":0},{"$f":"_EFFORT*0.0778","v":0},{"$f":"_EFFORT*0.0518","v":0},{"$f":"_EFFORT*0.1652","v":0}]
["Alteración",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Software Engineering",{"$f":"_EFFORT*0.0644","v":0},{"$f":"_EFFORT*0.0885","v":0},{"$f":"_EFFORT*0.3694","v":0},{"$f":"_EFFORT*0.0356","v":0},{"$f":"_EFFORT*0.5579","v":0}]
["Exclusión",null,null,null,"EFFORT = ","PM","*","HM",null,null,"PROD = ","EFFORT /","TAM",null,"P = ","PM","/","TDEV",null,null,null,null,"Support",{"$f":"_EFFORT*0.013","v":0},{"$f":"_EFFORT*0.0162","v":0},{"$f":"_EFFORT*0.0743","v":0},{"$f":"_EFFORT*0.0158","v":0},{"$f":"_EFFORT*0.1193","v":0}]
[null,null,null,null,{"$f":"F21*H21","v":0},{"$f":"_PM","v":0},null,{"$f":"_HM","v":152},null,null,{"$f":"L21/M21","v":{"$error":"#DIV/0!"}},{"$f":"_EFFORT","v":0},{"$f":"IF(F2<>\"\",F2,0)","v":0},null,{"$f":"P21/R21","v":{"$error":"#DIV/0!"}},{"$f":"_PM","v":0},null,{"$f":"_TDEV","v":0},null,null,null,null,"Total Effort by Phase",{"$f":"_EFFORT*0.1142","v":0},{"$f":"_EFFORT*0.1679","v":0},{"$f":"_EFFORT*0.6148","v":0},{"$f":"_EFFORT*0.1031","v":0},{"$f":"_EFFORT*1","v":0}]
[null,null,null,null,"Horas",null,null,null,null,null,"Horas/PF",null,null,null,"Pessoas"]

{"sheet":"_EAF","index":7,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
["HM",152,"Padrão"]
["A",1.6316999999999999,"(Java/Oracle - Benchmarking, Padrão é 2,94)"]
["B",0.91,"Padrão"]
["C",3.67,"Padrão"]
["D",0.28000000000000003,"Padrão"]
["SLOC Ref. Ling.",53,"Ref. Java (Backfiring) é 53, média em sist. alta complex. é 100 (como bancos, por exemplo)"]
["Fatores de Escala",18.97,"Valor nominal é 18,97"]
[]
[]
["EAF"]
[{"$f":"IF(B11<>\"\",\"Esf. Est Padrão.\",\"\")","v":""},{"$f":"IF(B11<>\"\",Datos!#REF!,\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"Esf. Est CII.\",\"\")","v":""},{"$f":"IF(B11<>\"\",_EFFORT,\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"Desvio.\",\"\")","v":""},{"$f":"IF(B11<>\"\",(_EFFORT/Datos!#REF!)-1,\"\")","v":""}]
[]
[{"$f":"IF(B11<>\"\",\"PM\",\"\")","v":""},{"$f":"IF(B11<>\"\",_PM,\"\")","v":""},{"$f":"IF(B11<>\"\",\"Pessoas-Mês\",\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"EFFORT\",\"\")","v":""},{"$f":"IF(B11<>\"\",_EFFORT,\"\")","v":""},{"$f":"IF(B11<>\"\",\"Esforço\",\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"PROD\",\"\")","v":""},{"$f":"IF(B11<>\"\",B17/Datos!F28,\"\")","v":""},{"$f":"IF(B11<>\"\",\"Horas/PF\",\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"TDEV\",\"\")","v":""},{"$f":"IF(B11<>\"\",_TDEV,\"\")","v":""},{"$f":"IF(B11<>\"\",\"Meses\",\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"P\",\"\")","v":""},{"$f":"IF(B11<>\"\",PAR!O21,\"\")","v":""},{"$f":"IF(B11<>\"\",\"Pessoal p/ Alocação/Mês\",\"\")","v":""}]
[]
[{"$f":"IF(B11<>\"\",\"Fase: Pré-Implementação (Análise e Proj.)\",\"\")","v":""},{"$f":"IF(B13<>\"\",SUM(PAR!X21:Y21),\"\")","v":""},{"$f":"IF(B22<>\"\",B22/$B$25,\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"Fase: Codificação\",\"\")","v":""},{"$f":"IF(B13<>\"\",PAR!Z21,\"\")","v":""},{"$f":"IF(B23<>\"\",B23/$B$25,\"\")","v":""}]
[{"$f":"IF(B11<>\"\",\"Fase: Testes, Homol. e Implant.\",\"\")","v":""},{"$f":"IF(B13<>\"\",PAR!AA21,\"\")","v":""},{"$f":"IF(B24<>\"\",B24/$B$25,\"\")","v":""}]
[null,{"$f":"IF(B13<>\"\",B13,\"\")","v":""},{"$f":"IF(B24<>\"\",100%,\"\")","v":""}]

{"sheet":"_HISTORICO","index":8,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[[6,0,6,1],[14,0,14,1],[15,0,15,3],[8,0,8,4],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["Versão","Descrição","Responsável"]
["1.00","Criação do documento","Softplan"]