{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Validación POECATA IV","Notas"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Validación POECATA IV","index":0,"n_rows":275,"n_cols":59,"rows_kept":275,"cut":false,"hidden":false,"merged":[[2,1,2,15],[20,12,28,15],[12,2,12,14],[8,2,8,14],[7,2,7,14],[6,2,6,14],[9,2,9,14],[4,2,5,14],[20,6,21,6],[23,2,23,3],[24,2,24,3],[25,2,25,3],[28,2,28,3],[20,2,21,2],[27,2,27,3],[27,4,27,11],[20,3,21,3],[20,10,21,10],[20,5,21,5]]}
[null,null,null,"2017-01-01",{"$f":"EDATE(D1,1)","v":"2017-02-01"},{"$f":"EDATE(E1,1)","v":"2017-03-01"},"2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01",null,"1900-01-31","1900-02-28","1900-03-28","1900-04-28","1900-05-28","1900-06-28","1900-07-28","1900-08-28","1900-09-28","1900-10-28","1900-11-28","1900-12-28","1901-01-28","1901-02-28","1901-03-28","1901-04-28","1901-05-28","1901-06-28","1901-07-28","1901-08-28","1901-09-28","1901-10-28","1901-11-28","1901-12-28","1902-01-28","1902-02-28","1902-03-28","1902-04-28","1902-05-28","1902-06-28","1902-07-28","1902-08-28","1902-09-28","1902-10-28","1902-11-28","1902-12-28","1903-01-28","1903-02-28","1903-03-28","1903-04-28","1903-05-28"]
[null,null,{"$f":"SUM(D2:BG2)","v":0},{"$f":"IF(TRIM(D15)<>\"\", 1, 0)","v":0},{"$f":"IF(TRIM(E15)<>\"\", 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(TRIM(D16)<>\"\", 1, 0)","v":0},{"$f":"IF(TRIM(E16)<>\"\", 1, 0)","v":0},null,0,0,0,0,0,0,0,0,0,{"$f":"IF(TRIM(D17)<>\"\", 1, 0)","v":0},{"$f":"IF(TRIM(E17)<>\"\", 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(TRIM(D18)<>\"\", 1, 0)","v":0},{"$f":"IF(TRIM(E18)<>\"\", 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(TRIM(D19)<>\"\", 1, 0)","v":0},{"$f":"IF( TRIM(E19)<>\"\",\n        IF(H22=\"\",    1,    IF( AND(H22>=DATE(2021,1,31),L22<=DATE(2021,2,21)),    0,   1)  ),\n        0)","v":0},{"$f":"IF(TRIM(F19)<>\"\", 1, 0)","v":0},0,0,{"$f":"IF( TRIM(I19)<>\"\",\n         IF(L22=\"\",    1,    IF( AND(L22>=DATE(2021,5,29),L22<=DATE(2021,6,21)),    0,   1)  ),\n         0)","v":0},{"$f":"IF( TRIM(J19)<>\"\",\n         IF($L$22=\"\",    1,    IF( $L$22<BF1,    0,   1)  ),\n         0)","v":0},{"$f":"IF( TRIM(K19)<>\"\",\n         IF($L$22=\"\",    1,    IF( $L$22<BG1,    0,   1)  ),\n         0)","v":0}]
[null,"HERRAMIENTA PARA VALIDAR EL ACCESO A LAS PRESTACIONES POECATA IV"]
[]
[null,null,"INSTRUCCIONES (habilitar las MACROS y seguir los pasos siguientes hasta que desaparezca el sombreado rosado)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P7:P10)","v":0}]
[null,null,"Marcar con una X, en el cuadro \"VIDA LABORAL\", los meses en que haya cotizaciones al CATA (y que no hayan sido computadas para reconocer una prestación de cese de actividad ordinaria previa)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$2>=12,1,0)","v":0}]
[null,null,"Informar si ha sido beneficiario de POECATA II y III",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF( AND( OR(UPPER($D$21)=\"SI\", UPPER($D$21)=\"NO\" ), OR(UPPER($G$21)=\"SI\", UPPER($G$21)=\"NO\") ), 1, 0)","v":0}]
[null,null,"Informar fechas de cobro de POECATA III",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF( OR(UPPER($G$21)=\"NO\", AND(UPPER($G$21)=\"SI\", TRIM($H$22)<>\"\", TRIM($I$22)<>\"\",$H$22<=$I$22)), 1, 0)","v":0}]
[null,null,"Informar fechas de solicitud de POECATA IV",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF( TRIM($L$22)<>\"\", 1, 0)","v":0}]
[]
[]
[null,null,"VIDA LABORAL"]
[null,null,"Cotizaciones\nCATA","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE"]
[null,null,2017]
[null,null,2018]
[null,null,2019]
[null,null,2020]
[null,null,2021]
[]
[null,null,"POECATA II",null,null,"POECATA III",null,"Desde","Hasta",null,"POECATA IV","Solicitud"]
[]
[]
[null,null,"CÁLCULOS",null,"Cotizaciones\nTOTALES","Consumidas\nx POECATA II","Consumidas\nx POECATA III","Cotizaciones\nDISPONIBLES","¿12 meses CATA\nprevios?","¿Derecho a prestación?","Duración de la prestación","Fecha fin prestación"]
[null,null,{"$f":"\"Acceso DIRECTO\"","v":"Acceso DIRECTO"},null,{"$f":"IF(P6<4, \"\",  C2)","v":""},{"$f":"IF(P6<4, \"\", IF(D21=\"SI\",-12,0))","v":""},{"$f":"IF(P6<4, \"\", IF(G21=\"SI\",-12,0))","v":""},{"$f":"IF(P6<4, \"\", E25+F25+G25)","v":""},{"$f":"IF(P6<4, \"\", IF( SUM( OFFSET(AS2,0,MONTH(L22)-6):OFFSET(BD2,0,MONTH(L22)-6 ) )<12, \"NO\", \"SI\"))","v":""},{"$f":"IF(P6<4, \"\", IF(AND(H25>=12,I25=\"SI\"),\"SI\",\"NO\"))","v":""},{"$f":"IF(P6<4, \"\", IF(J25=\"NO\", 0, IF(H25>=48, 24,     IF(H25>=43, 16,     IF(H25>=36, 12,       IF(H25>=30, 10,       IF(H25>=24, 8,       IF(H25>=18, 6,       IF(H25>=12, 4, 0)))))))))","v":""},{"$f":"IF(P6<4, \"\", IF(K25=0, \"-\",  IF(EDATE(IF(L22<=DATE(2021,6,21), DATE(2021,6,1),L22), K25)>DATE(2021,9,30),  DATE(2021,9,30),   EDATE(IF(L22<=DATE(2021,6,21), DATE(2021,6,1),L22), K25) ) ))","v":""}]
[null,null,"Acceso por PRÓRROGA",null,{"$f":"IF(OR(P6<4, G21=\"NO\", AND(I22<>DATE(2021,5,30),I22<>DATE(2021,5,31))), \"\", SUM( OFFSET(D2:AZ2,0,MONTH(H22)-2) ))","v":""},{"$f":"IF(E26=\"\", \"\", IF(D21=\"SI\",-12,0))","v":""},{"$f":"IF(E26=\"\", \"\", \"-\")","v":""},{"$f":"IF(E26=\"\", \"\", E26+F26)","v":""},{"$f":"IF(E26=\"\", \"\", \"-\")","v":""},{"$f":"IF(E26=\"\", \"\", IF(H26>=12,\"SI\",\"NO\"))","v":""},{"$f":"IF(E26=\"\", \"\", IF(H26>=48, 24,     IF(H26>=43, 16,     IF(H26>=36, 12,       IF(H26>=30, 10,       IF(H26>=24, 8,       IF(H26>=18, 6,       IF(H26>=12, 4, 0))))))))","v":""},{"$f":"IF(E26=\"\", \"\", IF(K26=0, \"-\",  EDATE(IF(H22<=DATE(2021,2,21), DATE(2021,2,1),H22+1), K26)-1 ))","v":""}]
[]
[null,null,"Resultado:",null,{"$f":"IF(P6<4, \"\",\n  IF( AND(J25=\"SI\", J26<>\"SI\", SUM( OFFSET(AS2,0,MONTH(L22)-6):OFFSET(BD2,0,MONTH(L22)-6 ) )<12), \"NO CUMPLE (no tiene 12 meses cotinuados cotizados previos a \" & TEXT(L22, \"dd mmmm aaaa)\"),\n\n  IF( AND(J25=\"SI\", COUNTIF(G17:L17,\"<>\"&\"\")=0), \"ACCESO DIRECTO (verificar que tuviera actividad entre abril y septiembre de 2019)\",\n  IF( J25=\"SI\", \"ACCESO DIRECTO (tiene cotizaciones suficientes a: \" & TEXT(L22, \"dd mmmm aaaa)\"),\n\n  IF( AND( OR(I22=DATE(2021,5,30),I22=DATE(2021,5,31)), AND(L26>=DATE(2021,6,1),L26<>\"-\", L26<>\"\")),\n           \"ACCESO POR PRORROGA de POECATA III\" & IF( COUNTIF(G17:L17,\"<>\"&\"\")=0, \"(verificar que tuviera actividad entre abril y septiembre de 2019)\", \".\" ),\n           \"NO CUMPLE (no tiene cotizaciones suficientes)\")))))","v":""}]
[null,null,"versión 2.50"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FM",null,null,null,null,"FRATERNIDAD-MUPRESPA"]

{"sheet":"Notas","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}