{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Banco de Datos","JR-DI-075 Coord. Mérito","JR-DI-076 Hoja Coord. Seg. Soc.","JR-DI-078 Ret. Prom. Años Serv.","JR-DI-079 Deuda Mes Coord.","JR-DI-081 Lista Coordinaciones","JR-80 Carta de Coordinación","Cómputo de Pensión Original","Meses"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":91,"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":"Banco de Datos","index":0,"n_rows":263,"n_cols":27,"rows_kept":263,"cut":false,"hidden":false,"merged":[[1,4,1,5],[1,12,1,15],[14,4,14,5],[14,12,14,15],[7,5,7,6],[6,5,6,6]]}
[null,"Selección de Pensionado:"]
[null,null,null,null,"Apellidos",null,"Sexo","Calle, Bloque,","Urbanización",null,null,null,"Fecha",null,null,null,"Tipo de","RHUM","RHUM","RHUM","RHUM","Años de","Retribución","Último Sueldo","Porciento","Activo"]
[null,null,"Seguro Social","Nombre","Paterno","Materno","(F o M)","Apartado, etc.","o Sector","Pueblo","País","Zip Code","Nacimiento","Ingreso","Separación","Efectividad","Pensión","DEPT1","DEPT2","DEPT3","DEPT.","Servicio","Promedio","Pensiónes IO","Actuarial","en jun-60","Mensaje de Error"]
[null,null,444444444,{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,2),\"\"))","v":"FRANCISCO"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,3),\"\"))","v":"MELENDEZ"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,4),\"\"))","v":"RIVERA"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,5),\"\"))","v":"M"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,6),\"\"))","v":"PARC. 86 A CALLE 17"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,7),\"\"))","v":"BO. MAMEYAL"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,8),\"\"))","v":"DORADO"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,9),\"\"))","v":"PR"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,10),\"\"))","v":"00646"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,11),\"\"))","v":"1937-08-21"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,12),\"\"))","v":"00:00:00"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,13),\"\"))","v":"1989-08-31"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,14),\"\"))","v":"1989-09-01"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,15),\"\"))","v":"EAS"},null,null,null,{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),0,IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,19),\"\"))","v":"530110"},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),0,IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,20),\"\"))","v":16.5},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),0,IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,21),\"\"))","v":9985.33},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),0,IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,22),\"\"))","v":0},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),0,IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,23),\"\"))","v":0},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,24),\"\"))","v":0},{"$f":"IF(ISERROR(VLOOKUP(SeguroSocial,TablaDatos,1)),\"\",IF(VLOOKUP(SeguroSocial,TablaDatos,1)=SeguroSocial,VLOOKUP(SeguroSocial,TablaDatos,25),\"\"))","v":""}]
[]
[null,"Preparación:"]
[null,null,"Preparado por:","Puesto","Fecha de preparación","Revisado por:",null,"Puesto (revisor)"]
[null,null,"María Sánchez Tirado","Analista de Beneficios",{"$f":"NOW()","v":"2025-03-26T16:05:23.650"},"Evelyn Sepúlveda Rivera",null,"Supervisor"]
[]
[null,"Cómputos:"]
[null,null,"Fecha de coordinación","Pensión básica","Coordinación básica","Coord. con aumentos","Edad-retiro"]
[null,null,{"$f":"DATE(YEAR(FechaNacimiento)+IF(YEAR(FechaNacimiento)<=1942,65,IF(AND(YEAR(FechaNacimiento)<=1959,YEAR(FechaNacimiento)>=1943),66,67)),MONTH(FechaNacimiento)+IF(YEAR(FechaNacimiento)<=1937,0,IF(OR(YEAR(FechaNacimiento)=1938,YEAR(FechaNacimiento)=1955),2,IF(OR(YEAR(FechaNacimiento)=1939,YEAR(FechaNacimiento)=1956),4,IF(OR(YEAR(FechaNacimiento)=1940,YEAR(FechaNacimiento)=1957),6,IF(OR(YEAR(FechaNacimiento)=1941,YEAR(FechaNacimiento)=1958),8,IF(YEAR(FechaNacimiento)=1942,10,0))))))+IF(YEAR(FechaNacimiento)=1959,10,0),DAY(FechaNacimiento))","v":"2002-08-21"},{"$f":"IF(SeguroSocial=\"\",\"\",MAX(PensiónBásicaEAS,PensiónBásicaMérito,PensiónBásicaIO,PensiónBásicaINO))","v":205.93},{"$f":"IF(SeguroSocial=\"\",\"\",MAX(CoordinaciónBásicaEAS,CoordinaciónBásicaMérito))","v":0},{"$f":"IF(SeguroSocial=\"\",\"\",MAX(CoordinaciónEAS,CoordinaciónMérito))","v":0},{"$f":"IF(SeguroSocial=\"\",\"\",IF(OR(FechaNacimiento=\"\",FechaSeparación=\"\"),\"FALTAN DATOS\",YEAR(FechaEfectividad)-YEAR(FechaNacimiento)-IF(MONTH(FechaEfectividad)>MONTH(FechaNacimiento),0,IF(AND(MONTH(FechaEfectividad)=MONTH(FechaNacimiento),DAY(FechaEfectividad)>=DAY(FechaNacimiento)),0,1))))","v":52}]
[]
[null,"Banco de Datos:",null,null,"Coordinaciones =",{"$f":"TotalCoordinaciones","v":4}]
[null,null,null,null,"Apellidos",null,"Sexo","Calle, Bloque,","Urbanización",null,null,null,"Fecha",null,null,null,"Tipo de","RHUM","RHUM","RHUM","RHUM","Años de","Retribución","Último Sueldo","Porciento","Activo"]
[null,0,"Seguro Social","Nombre","Paterno","Materno","(F o M)","Apartado, etc.","o Sector","Pueblo","País","Zip Code","Nacimiento","Ingreso","Separación","Efectividad","Pensión","DEPT1","DEPT2","DEPT3","DEPT.","Servicio","Promedio","Pensiónes IO","Actuarial","en jun-60","Mensaje de Error"]
[{"$f":"IF(B17=\"\",\"\",1)","v":1},{"$f":"IF(OR(B16=\"\",C17=\"\"),\"\",B16+1)","v":1},111111111,"RAMONITA","OSORIO","RODRIGUEZ","F","CALLE 1 A -19","VILLA COOPERATIVA","CAROLINA","PR","00985","1937-08-04",null,"1989-01-31","1989-02-01","M","530100","530120","530130","530130",30,11264,null,null,null,{"$f":"IF(C17=\"\",\"\",IF(AND(X17=\"\",Q17=\"IO\"),\"INDIQUE EL ÚLTIMO SUELDO\",IF(AND(Q17<>\"IO\",X17<>\"\"),\"***ERROR, NO INDIQUE ÚLTIMO SUELDO PARA PENSIONES QUE NO SON IO\",IF(OR(U17=R17,U17=S17,U17=T17),\"\",\"ERROR EN EL CÓDIGO RHUM DEPT.\"))))","v":""}]
[1,2,222222222,"CARMEN I.","SANTANA","ALVAREZ","F","45 QUEENS WAY 12",null,"FRAMINGHAM","MA","01701","1937-08-04",null,"1987-09-30","1987-10-01","M","530100","530120","530130","530120",30,10237,null,null,null,""]
[1,3,333333333,"RAMON","ROMAN","HERNANDEZ","M","RR 01 BOX 11197",null,"MANATI","PR","00674","1937-08-10",null,"1989-08-31","1989-09-01","EAS","530110","","","530110",25.5,18084,null,null,null,""]
[1,4,444444444,"FRANCISCO","MELENDEZ","RIVERA","M","PARC. 86 A CALLE 17","BO. MAMEYAL","DORADO","PR","00646","1937-08-21",null,"1989-08-31","1989-09-01","EAS","530110","","","530110",16.5,9985.33,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q39=\"M\",\"530100\",IF($Q39=\"IO\",\"530140\",IF($Q39=\"EAS\",\"530110\",IF($Q39=\"INO\",\"530150\",\"\"))))","v":""},{"$f":"IF($Q39=\"M\",\"530120\",IF($Q39=\"IO\",\"530200\",IF($Q39=\"EAS\",\"\",IF($Q39=\"INO\",\"\",\"\"))))","v":""},{"$f":"IF($Q39=\"M\",\"530130\",IF($Q39=\"IO\",\"\",IF($Q39=\"EAS\",\"\",IF($Q39=\"INO\",\"\",\"\"))))","v":""},null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
[{"$f":"IF(B73=\"\",\"\",1)","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,{"$f":"IF(C81=\"\",\"\",IF(AND(X81=\"\",Q81=\"IO\"),\"INDIQUE EL ÚLTIMO SUELDO\",IF(AND(Q81<>\"IO\",X81<>\"\"),\"***ERROR, NO INDIQUE ÚLTIMO SUELDO PARA PENSIONES QUE NO SON IO\",IF(OR(U81=R81,U81=S81,U81=T81),\"\",\"ERROR EN EL CÓDIGO RHUM DEPT.\"))))","v":""}]
[{"$f":"IF(B82=\"\",\"\",1)","v":""},{"$f":"IF(OR(B81=\"\",C82=\"\"),\"\",B81+1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Q103=\"M\",\"530100\",IF($Q103=\"IO\",\"530140\",IF($Q103=\"EAS\",\"530110\",IF($Q103=\"INO\",\"530150\",\"\"))))","v":""},{"$f":"IF($Q103=\"M\",\"530120\",IF($Q103=\"IO\",\"530200\",IF($Q103=\"EAS\",\"\",IF($Q103=\"INO\",\"\",\"\"))))","v":""},{"$f":"IF($Q103=\"M\",\"530130\",IF($Q103=\"IO\",\"\",IF($Q103=\"EAS\",\"\",IF($Q103=\"INO\",\"\",\"\"))))","v":""},null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,{"$f":"IF(C145=\"\",\"\",IF(AND(X145=\"\",Q145=\"IO\"),\"INDIQUE EL ÚLTIMO SUELDO\",IF(AND(Q145<>\"IO\",X145<>\"\"),\"***ERROR, NO INDIQUE ÚLTIMO SUELDO PARA PENSIONES QUE NO SON IO\",IF(OR(U145=R145,U145=S145,U145=T145),\"\",\"ERROR EN EL CÓDIGO RHUM DEPT.\"))))","v":""}]
[{"$f":"IF(B146=\"\",\"\",1)","v":""},{"$f":"IF(OR(B145=\"\",C146=\"\"),\"\",B145+1)","v":""},null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,{"$f":"IF($Q167=\"M\",\"530100\",IF($Q167=\"IO\",\"530140\",IF($Q167=\"EAS\",\"530110\",IF($Q167=\"INO\",\"530150\",\"\"))))","v":""},{"$f":"IF($Q167=\"M\",\"530120\",IF($Q167=\"IO\",\"530200\",IF($Q167=\"EAS\",\"\",IF($Q167=\"INO\",\"\",\"\"))))","v":""},{"$f":"IF($Q167=\"M\",\"530130\",IF($Q167=\"IO\",\"\",IF($Q167=\"EAS\",\"\",IF($Q167=\"INO\",\"\",\"\"))))","v":""},null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,{"$f":"IF(C209=\"\",\"\",IF(AND(X209=\"\",Q209=\"IO\"),\"INDIQUE EL ÚLTIMO SUELDO\",IF(AND(Q209<>\"IO\",X209<>\"\"),\"***ERROR, NO INDIQUE ÚLTIMO SUELDO PARA PENSIONES QUE NO SON IO\",IF(OR(U209=R209,U209=S209,U209=T209),\"\",\"ERROR EN EL CÓDIGO RHUM DEPT.\"))))","v":""}]
[{"$f":"IF(B210=\"\",\"\",1)","v":""},{"$f":"IF(OR(B209=\"\",C210=\"\"),\"\",B209+1)","v":""},null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,{"$f":"IF($Q231=\"M\",\"530100\",IF($Q231=\"IO\",\"530140\",IF($Q231=\"EAS\",\"530110\",IF($Q231=\"INO\",\"530150\",\"\"))))","v":""},{"$f":"IF($Q231=\"M\",\"530120\",IF($Q231=\"IO\",\"530200\",IF($Q231=\"EAS\",\"\",IF($Q231=\"INO\",\"\",\"\"))))","v":""},{"$f":"IF($Q231=\"M\",\"530130\",IF($Q231=\"IO\",\"\",IF($Q231=\"EAS\",\"\",IF($Q231=\"INO\",\"\",\"\"))))","v":""},null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
["","",null,null,null,null,null," "," "," "," "," ",null,null,null,null,null,"","","",null,null,null,null,null,null,""]
[]
[{"$f":"SUM(A17:A261)","v":4}]

{"sheet":"JR-DI-075 Coord. Mérito","index":1,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":false,"merged":[[71,4,71,21],[58,15,58,21],[57,15,57,21],[56,15,56,21],[65,5,65,6],[64,5,64,6],[63,9,63,12],[65,9,65,12],[65,18,65,21],[70,4,70,21],[68,4,68,21],[67,4,67,21],[19,14,19,17],[20,14,20,17],[55,15,55,21],[39,13,39,15],[40,13,40,15],[41,13,41,15],[52,4,52,21],[29,13,29,15],[36,13,36,15],[38,13,38,15],[31,13,31,15],[49,13,49,15],[42,13,42,15],[43,13,43,15],[38,6,38,7],[47,6,47,7],[54,4,54,11],[55,5,55,11],[56,5,56,11],[57,5,57,11],[58,5,58,11],[54,12,54,21],[60,4,60,21],[11,4,11,8],[12,4,12,10],[13,4,13,10],[14,4,14,10],[12,17,12,19],[13,17,13,19],[14,17,14,19],[12,13,12,15],[13,13,13,15],[14,13,14,15],[12,11,12,12],[13,11,13,12],[14,11,14,12],[3,4,3,21],[11,13,11,15],[11,17,11,19],[11,11,11,12],[10,13,10,15],[11,9,11,10],[9,9,9,10],[10,9,10,10],[9,4,9,8],[10,4,10,8],[1,4,1,21],[5,4,5,21],[10,11,10,12],[2,4,2,21],[10,17,10,19],[7,4,7,21],[9,11,9,21],[48,13,48,15],[16,4,16,21],[28,18,28,21],[33,13,33,15],[35,6,35,7],[34,13,34,15],[35,13,35,15],[32,13,32,15],[29,18,29,19],[30,13,30,15],[43,6,43,7],[48,6,48,7],[37,13,37,15],[44,13,44,15],[45,13,45,15],[46,13,46,15],[30,6,30,7],[37,6,37,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[63,15,63,21],[4,4,4,21],[28,1,28,3],[21,14,21,17],[29,6,29,8],[29,9,29,10],[28,5,28,10],[28,12,28,16],[26,4,26,21],[39,6,39,7],[36,6,36,7],[49,6,49,7],[44,6,44,7],[45,6,45,7],[40,6,40,7],[41,6,41,7],[42,6,42,7],[46,6,46,7],[47,13,47,15]]}
[]
[]
[null,null,null,null,"HOJA PARA COORDINACIÓN"]
[null,null,null,null,"DE LA PENSIÓN POR MÉRITO"]
[null,null,null,null,"CON EL SEGURO SOCIAL FEDERAL"]
[]
[]
[null,null,null,null,"Sección I.  Información del Pensionado y la Coordinación:"]
[]
[null,null,null,null,null,null,null,null,null,"Seguro",null,"Fecha"]
[null,null,null,null,"Nombre",null,null,null,null,"Social",null,"Nacimiento",null,"Separación",null,null,null,"Efectividad",null,null,null,"Coordinación"]
[null,null,null,null,{"$f":"IF(TipoPensión=\"M\",Nombre&\" \"&Paterno&\" \"&Materno,\"\")","v":""},null,null,null,null,{"$f":"IF(TipoPensión=\"M\",SeguroSocial,\"\")","v":""},null,{"$f":"IF(TipoPensión=\"M\",DAY(FechaNacimiento)&\"-\"&VLOOKUP(MONTH(FechaNacimiento),Meses,3)&\"-\"&YEAR(FechaNacimiento),\"\")","v":""},null,{"$f":"IF(TipoPensión=\"M\",DAY(FechaSeparación)&\"-\"&VLOOKUP(MONTH(FechaSeparación),Meses,3)&\"-\"&YEAR(FechaSeparación),\"\")","v":""},null,null,null,{"$f":"IF(TipoPensión=\"M\",DAY(FechaEfectividad)&\"-\"&VLOOKUP(MONTH(FechaEfectividad),Meses,3)&\"-\"&YEAR(FechaEfectividad),\"\")","v":""},null,null,null,{"$f":"IF(TipoPensión=\"M\",DAY(FechaCoordinación)&\"-\"&VLOOKUP(MONTH(FechaCoordinación),Meses,3)&\"-\"&YEAR(FechaCoordinación),\"\")","v":""}]
[null,null,null,null,"Dirección",null,null,null,null,null,null,"Edad al ",null,"Años de",null,null,null,"Retribución",null,null,null,"Pensión"]
[null,null,null,null,{"$f":"IF(TipoPensión=\"M\",Dirección&IF(OR(Dirección2=\"\",Dirección2=0),\"\",\" \"&Dirección2),\"\")","v":""},null,null,null,null,null,null,"Retirarse",null,"Servicio",null,null,null,"Promedio",null,null,null,"Original"]
[null,null,null,null,{"$f":"IF(TipoPensión=\"M\",Pueblo&\" \"&País&\" \"&ZipCode,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(TipoPensión=\"M\",Edad,\"\")","v":""},null,{"$f":"IF(TipoPensión=\"M\",AñosServicio,\"\")","v":""},null,null,null,{"$f":"IF(TipoPensión=\"M\",RetribuciónPromedio,\"\")","v":""},null,null,null,{"$f":"IF(TipoPensión=\"M\",IF(SeguroSocial=\"\",\"\",MAX(PensiónBásicaEAS,PensiónBásicaMérito,PensiónBásicaIO,PensiónBásicaINO)),\"\")","v":""}]
[]
[null,null,null,null,"Sección II.  Detalles del Cómputo de la Coordinación:"]
[null,null,null,null,null,"Retribución"]
[null,null,null,null,null,"Promedio",null,"%"]
[null,null,null,null,null,{"$f":"IF(TipoPensión=\"M\",IF(RetribuciónPromedio<=6600,RetribuciónPromedio,6600),0)","v":0},"X",1.4999999999999999E-2,null,{"$f":"F20*H20","v":0},null,null,{"$f":"IF(TipoPensión=\"M\",AñosServicio,0)","v":0},"=",{"$f":"TRUNC(M20*J20,2)","v":0}]
[null,null,null,null,null,{"$f":"IF(TipoPensión=\"M\",IF(RetribuciónPromedio<=6600,0,RetribuciónPromedio-6600),0)","v":0},"X",{"$f":"IF(Edad>=55,0.75,0.65)","v":0.65},null,null,null,null,null,"=",{"$f":"TRUNC(F21*H21,2)","v":0},null,null,null,null,null,null,{"$f":"SUM(O20:O21)","v":0}]
[null,null,null,null,null,null,null,null,null,"Porciento Actuarial",null,null,null,null,{"$f":"PorcientoActuarial","v":0},null,null,null,null,null,null,{"$f":"TRUNC(O22*V21,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Pensión máxima (85%)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TipoPensión=\"M\",TRUNC(RetribuciónPromedio*0.85,2),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anual",null,null,{"$f":"IF(V22>V23,V23,V21)","v":0}]
[null,null,null,null,"Pensión coordinada sin aumentos:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mensual",null,null,{"$f":"TRUNC(V24/12,2)","v":0}]
[]
[null,null,null,null,"Sección III.  Aumentos otorgados por Leyes Especiales:"]
[]
["Ley","Fecha",null,null,"Ley","Fecha",null,null,null,null,null,null,"Pensión Original",null,null,null,null,null,"Pensión Coordinada"]
["Número","Aprobada","Requisito*","Vigencia","Número","Aprobada","Requisito*",null,null,"Vigencia",null,null,"Aumentos","Total",null,null,"Total",null,"Aumentos",null,"Total","Total"]
["Ley Núm. 127",1967,null,"1967-07-01",{"$f":"IF(OR(TipoPensión<>\"M\",SeguroSocial=\"\"),\"\",IF(OR(U31<>CoordinaciónBásicaMérito,Q31<>PensiónBásicaMérito),A31,\"\"))","v":""},{"$f":"IF(OR(TipoPensión<>\"M\",SeguroSocial=\"\"),\"\",IF(OR(U31<>CoordinaciónBásicaMérito,Q31<>PensiónBásicaMérito),B31,\"\"))","v":""},{"$f":"IF(OR(TipoPensión<>\"M\",SeguroSocial=\"\"),\"\",IF(OR(U31<>CoordinaciónBásicaMérito,Q31<>PensiónBásicaMérito),C31,\"\"))","v":""},null,null,{"$f":"IF(OR(TipoPensión<>\"M\",SeguroSocial=\"\"),\"\",IF(OR(U31<>CoordinaciónBásicaMérito,Q31<>PensiónBásicaMérito),D31,\"\"))","v":""},null,null,{"$f":"IF(FechaEfectividad>D31,0,IF(TipoPensión<>\"M\",0,IF(FechaCoordinación<D31,0,30)))","v":0},{"$f":"IF(OR(U31<>CoordinaciónBásicaMérito,Q31<>PensiónBásicaMérito),Q31,0)","v":0},null,null,{"$f":"IF(TipoPensión=\"M\",PensiónBásicaMérito+M31,0)","v":0},null,{"$f":"IF(TipoPensión<>\"M\",0,IF(AND(FechaEfectividad>D31,FechaCoordinación>=D31),0,30))","v":0},null,{"$f":"CoordinaciónBásicaMérito+S31+M31","v":0},{"$f":"IF(AND(U31=CoordinaciónBásicaMérito,FechaEfectividad>D31),0,U31)","v":0}]
["Ley Núm. 49",1970,null,"1970-07-01",{"$f":"IF(OR(U32<>U31,Q32<>Q31),A32,\"\")","v":""},{"$f":"IF(OR(U32<>U31,Q32<>Q31),B32,\"\")","v":""},{"$f":"IF(OR(U32<>U31,Q32<>Q31),C32,\"\")","v":""},null,null,{"$f":"IF(OR(U32<>U31,Q32<>Q31),D32,\"\")","v":""},null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<D32,0,IF(AND(FechaEfectividad<=D32,Q31<100),IF(Q31<65,65-Q31,IF(Q31<85,Q31-85,IF(Q31<100,Q31-100))),0)),0)","v":0},{"$f":"IF(OR(U32<>U31,Q32<>Q31),Q32,\"\")","v":""},null,null,{"$f":"IF(OR(M32=\"\",M32=0),Q31,Q31+M32)","v":0},null,{"$f":"IF(TipoPensión<>\"M\",IF(FechaCoordinación>=D32,0,IF(AND(FechaEfectividad<=D32,U31<100),IF(U31<65,65-U31,IF(U31<85,U31-85,IF(U31<100,U31-100))),0)),0)","v":0},null,{"$f":"U31+S32+M32","v":0},{"$f":"IF(OR(U32<>U31,Q32<>Q31),U32,\"\")","v":""}]
["Ley Núm. 49",1971,null,"1971-07-01",{"$f":"IF(OR(U33<>U32,Q33<>Q32),A33,\"\")","v":""},{"$f":"IF(OR(U33<>U32,Q33<>Q32),B33,\"\")","v":""},{"$f":"IF(OR(U33<>U32,Q33<>Q32),C33,\"\")","v":""},null,null,{"$f":"IF(OR(U33<>U32,Q33<>Q32),D33,\"\")","v":""},null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<D33,0,IF(AND(FechaEfectividad<=D33,Q32<100),IF(Q32<80,80-Q32,IF(Q32<100,Q32-100)),0)),0)","v":0},{"$f":"IF(OR(U33<>U32,Q33<>Q32),Q33,\"\")","v":""},null,null,{"$f":"IF(OR(M33=\"\",M33=0),Q32,Q32+M33)","v":0},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaCoordinación>=D33,0,IF(AND(FechaEfectividad<=D33,U32<100),IF(U32<80,80-U32,IF(U32<100,U32-100)),0)),0)","v":0},null,{"$f":"U32+S33+M33","v":0},{"$f":"IF(OR(U33<>U32,Q33<>Q32),U33,\"\")","v":""}]
["Ley Núm. 28","1972-05-03",null,"1972-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(AND(FechaCoordinación>D34,FechaEfectividad<=D34,Q33<500),IF(Q33<100,115-Q33,IF(Q33<500,15)),0),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF(AND(FechaCoordinación<=Q34,FechaEfectividad<=Q34,U33<500),IF(U33<100,115-U33,IF(U33<500,15)),0),0)","v":0},null,0,""]
["Ley Núm. 28","1972-05-03",null,"1972-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(Q34<125,125-Q34,IF(AND(FechaEfectividad<=D35,FechaCoordinación>D35,Q34<500),10,0)),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF(U34+M35<125,125-U34+M35,IF(AND(FechaEfectividad<=D35,FechaCoordinación<=D35,U34<500),10,0)),0)","v":0},null,0,""]
["Ley Núm. 124","1973-06-08",null,"1973-07-01","","","",null,null,"",null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\",FechaEfectividad>D36,FechaCoordinación<=D36),0,IF(Edad>=65,(IF(Q35<=500,TRUNC(Q35*0.1,2),IF(Q35<=600,TRUNC((600-Q35)*0.06+50,2),IF(Q35>600,TRUNC((Q35-600)*0.02+56,2),0)))),(IF(Q35<=500,TRUNC(Q35*0.06,2),IF(Q35<=600,TRUNC((Q35-600)*0.04+35,2),0)))))","v":0},"",null,null,0,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\",FechaEfectividad>D36,FechaCoordinación>D36),0,IF(Edad>=65,(IF(U35<=500,TRUNC(U35*0.1,2),IF(U35<=600,TRUNC((600-U35)*0.06+50,2),IF(U35>600,TRUNC((U35-600)*0.02+56,2),0)))),(IF(U35<=500,TRUNC(U35*0.06,2),IF(U35<=600,TRUNC((U35-600)*0.04+35,2),0)))))","v":0},null,0,""]
["Ley Núm. 110","1974-07-08",null,"1974-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<=D37,0,IF(FechaEfectividad<=D37,50,0)),0)","v":0},"",null,null,0,null,{"$f":"IF(AND(FechaCoordinación<=D37,FechaEfectividad<=D37),50,0)","v":0},null,0,""]
["Ley Núm. 109","1979-07-16",null,"1979-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<=D38,0,IF(FechaEfectividad<=D38,IF(Q37<=155,180-Q37,25),0)),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión<>\"M\",0,IF(AND(FechaCoordinación<=D38,FechaEfectividad<=D38),IF(U37<=155,180-U37,25),0))","v":0},null,0,""]
["Ley Núm. 22","1981-07-01",null,"1979-07-01","","","",null,null,"",null,null,{"$f":"IF(FechaCoordinación<D42,0,IF(TipoPensión=\"M\",IF(Q38<180,180-Q38,0),0))","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF((U38+M39)<180,180-(U38+M39),0),0)","v":0},null,0,""]
["Ley Núm. 23","1983-09-23",null,"1983-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<=D40,0,IF(AND(FechaEfectividad<=D40,Q38<300),IF(AñosServicio>=30,25,0)+IF(AND(AñosServicio<=29,AñosServicio>=20),20,0)+IF(AñosServicio<20,15,0),0)),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF(AND(FechaCoordinación<=D40,FechaEfectividad<=D40,U38<300),IF(AñosServicio>=30,25,0)+IF(AND(AñosServicio<=29,AñosServicio>=20),20,0)+IF(AñosServicio<20,15,0),0),0)","v":0},null,0,""]
["Ley Núm. 15","1987-04-24",null,"1987-01-01","","","",null,null,"",null,null,{"$f":"IF(FechaCoordinación<D42,0,IF(TipoPensión=\"M\",IF(Q40>=200,0,200-Q40),0))","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF((U40+M41)>=200,0,200-(U40+M41)),0)","v":0},null,0,""]
["Ley Núm. 48","1988-06-29",null,"1988-07-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaCoordinación<=D42,0,IF(FechaEfectividad<=D42,IF(TipoPensión=\"M\",25,0),0)),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF(AND(FechaCoordinación<=D42,FechaEfectividad<=D42),25,0),0)","v":0},null,0,""]
["Ley Núm. 10","1992-05-21","1989-01-01","1992-01-01","","","",null,null,"",null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C43,0,IF(FechaCoordinación>D43,TRUNC(Q42*0.03,2),0)),0)","v":0},"",null,null,0,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C43,0,IF(FechaCoordinación<=D43,TRUNC(U42*0.03,2),0)),0)","v":0},null,0,""]
["Ley Núm. 207","1995-08-13","1992-01-01","1995-01-01","","","",null,null,"",null,null,0,"",null,null,0,null,0,null,0,""]
["Ley Núm. 221","1998-08-09","1995-01-01","1998-01-01","","","",null,null,"",null,null,0,"",null,null,0,null,0,null,0,""]
["Ley Núm. 40","2001-06-13","1998-01-01","2001-01-01","","","",null,null,"",null,null,0,"",null,null,0,null,0,null,0,""]
["Ley Núm. 156","2003-06-27",null,"2004-01-01",{"$f":"IF(OR(U47<>U46,Q47<>Q46),A47,\"\")","v":""},{"$f":"IF(OR(U47<>U46,Q47<>Q46),B47,\"\")","v":""},{"$f":"IF(OR(U47<>U46,Q47<>Q46),C47,\"\")","v":""},null,null,{"$f":"IF(OR(U47<>U46,Q47<>Q46),D47,\"\")","v":""},null,null,{"$f":"IF(FechaCoordinación<D48,0,IF(TipoPensión=\"M\",IF(Q46>=300,0,300-Q46),0))","v":0},{"$f":"IF(OR(U47<>U46,Q47<>Q46),Q47,\"\")","v":""},null,null,{"$f":"IF(OR(M47=\"\",M47=0),Q46,Q46+M47)","v":0},null,{"$f":"IF(TipoPensión=\"M\",IF((U46+M47)>=300,0,300-(U46+M47)),0)","v":0},null,{"$f":"U46+S47+M47","v":0},{"$f":"IF(OR(U47<>U46,Q47<>Q46),U47,\"\")","v":""}]
["Ley Núm. 157","2003-06-27","2001-01-01","2004-01-01",{"$f":"IF(OR(U48<>U47,Q48<>Q47),A48,\"\")","v":""},{"$f":"IF(OR(U48<>U47,Q48<>Q47),B48,\"\")","v":""},{"$f":"IF(OR(U48<>U47,Q48<>Q47),C48,\"\")","v":""},null,null,{"$f":"IF(OR(U48<>U47,Q48<>Q47),D48,\"\")","v":""},null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C48,0,IF(FechaCoordinación>D48,TRUNC(Q47*0.03,2),0)),0)","v":0},{"$f":"IF(OR(U48<>U47,Q48<>Q47),Q48,\"\")","v":""},null,null,{"$f":"IF(OR(M48=\"\",M48=0),Q47,Q47+M48)","v":0},null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C471,IF(FechaCoordinación<=D48,TRUNC(U47*0.03,2),0)),0)","v":0},null,{"$f":"U47+S48+M48","v":0},{"$f":"IF(OR(U48<>U47,Q48<>Q47),U48,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(OR(U49<>U48,Q49<>Q48),A49,\"\")","v":""},{"$f":"IF(OR(U49<>U48,Q49<>Q48),B49,\"\")","v":""},{"$f":"IF(OR(U49<>U48,Q49<>Q48),C49,\"\")","v":""},null,null,{"$f":"IF(OR(U49<>U48,Q49<>Q48),D49,\"\")","v":""},null,null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C49,0,IF(FechaCoordinación>D49,TRUNC(Q48*0.03,2),0)),0)","v":0},{"$f":"IF(OR(U49<>U48,Q49<>Q48),Q49,\"\")","v":""},null,null,{"$f":"IF(OR(M49=\"\",M49=0),Q48,Q48+M49)","v":0},null,{"$f":"IF(TipoPensión=\"M\",IF(FechaEfectividad>C472,IF(FechaCoordinación<=D49,TRUNC(U48*0.03,2),0)),0)","v":0},null,{"$f":"U48+S49+M49","v":0},{"$f":"IF(OR(U49<>U48,Q49<>Q48),U49,\"\")","v":""}]
[null,null,null,null,"","","",null,null,"",null,null,0,"",null,null,0,null,0,null,0,""]
[null,null,null,null,"Pensión coordinada con aumentos (si aplican):",null,null,null,null,null,null,null,{"$f":"SUM(M31:M50)","v":0},null,null,null,null,null,{"$f":"SUM(S31:S50)","v":0},null,{"$f":"U50","v":0},{"$f":"CoordinaciónMérito","v":0}]
[]
[null,null,null,null,"Sección IV. Preparación y Revisión:"]
[]
[null,null,null,null,"Preparado por:",null,null,null,null,null,null,null,"Revisado por:"]
[null,null,null,null,"Nombre:",null,null,null,null,null,null,null,"Nombre:"]
[null,null,null,null,"Firma:",null,null,null,null,null,null,null,"Firma:"]
[null,null,null,null,"Puesto:",null,null,null,null,null,null,null,"Puesto:"]
[null,null,null,null,"Fecha (día/mes/año):",null,null,null,null,null,null,null,"Fecha (día/mes/año):"]
[]
[null,null,null,null,"Sección V.  Aprobación:"]
[]
[null,null,null,null,"Verificación de:",null,null,"Aprobado por:"]
[null,null,null,null,"        Exactitud","        Otros",null,"Nombre:",null,null,null,null,null,"Firma:"]
[null,null,null,null,"        Legalidad"]
[null,null,null,null,"        Firmas","(Especifique)",null,"Puesto:",null,null,null,null,null,"Fecha (día/mes/año):"]
[]
[]
[null,null,null,null,"*  Para tener derecho al aumento de 3%, la pensión se tiene que haber aprobado por lo menos tres años antes de la vigencia de la  ley."]
[]
[null,null,null,null,"Conservación: Igual al expediente del cual forma parte."]

{"sheet":"JR-DI-076 Hoja Coord. Seg. Soc.","index":2,"n_rows":73,"n_cols":24,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,4,72,23],[70,4,70,23],[67,5,67,6],[69,4,69,21],[0,4,0,23],[1,4,1,23],[49,9,49,11],[50,9,50,11],[58,15,58,23],[66,5,66,6],[49,15,49,16],[58,5,58,11],[59,5,59,11],[61,4,61,23],[53,4,53,23],[57,5,57,11],[56,15,56,23],[57,15,57,23],[59,15,59,23],[29,18,29,23],[30,18,30,20],[27,4,27,23],[2,4,2,23],[44,9,44,11],[62,4,62,23],[55,12,55,23],[56,5,56,11],[48,9,48,11],[34,7,34,8],[35,9,35,11],[11,12,11,13],[11,20,11,23],[13,14,13,15],[11,16,11,19],[11,14,11,15],[21,14,21,15],[16,4,16,23],[19,14,19,15],[20,14,20,15],[11,4,11,8],[11,9,11,11],[44,15,44,16],[37,15,37,16],[29,5,29,11],[30,5,30,6],[13,16,13,19],[45,7,45,8],[51,15,51,16],[43,9,43,11],[35,15,35,16],[43,15,43,16],[38,7,38,8],[39,7,39,8],[40,7,40,8],[43,7,43,8],[35,7,35,8],[36,7,36,8],[42,7,42,8],[44,7,44,8],[37,7,37,8],[42,15,42,16],[36,9,36,11],[9,9,9,11],[10,9,10,11],[39,9,39,11],[14,16,14,19],[67,20,67,23],[65,9,65,13],[59,12,59,13],[67,9,67,13],[55,4,55,11],[45,9,45,11],[46,9,46,11],[47,9,47,11],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[30,15,30,16],[30,9,30,11],[50,15,50,16],[47,15,47,16],[48,15,48,16],[45,15,45,16],[46,15,46,16],[22,14,22,15],[23,14,23,15],[33,9,33,11],[30,22,30,23],[12,20,12,23],[13,20,13,23],[14,20,14,23],[12,16,12,19],[10,16,10,19],[10,12,10,13],[10,20,10,23],[10,14,10,15],[14,14,14,15],[3,4,3,23],[41,7,41,8],[31,7,31,8],[32,7,32,8],[34,9,34,11],[42,9,42,11],[32,9,32,11],[40,9,40,11],[4,4,4,23],[29,13,29,16],[7,4,7,23],[38,9,38,11],[34,15,34,16],[9,4,9,8],[10,4,10,8],[30,7,30,8],[12,4,12,11],[13,4,13,11],[14,4,14,11],[12,12,12,13],[13,12,13,13],[14,12,14,13],[12,14,12,15],[9,12,9,23],[29,1,29,3],[31,15,31,16],[32,15,32,16],[33,15,33,16],[33,7,33,8],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[37,9,37,11],[41,9,41,11],[31,9,31,11],[36,15,36,16]]}
[]
[null,null,null,null,"HOJA PARA COORDINACIÓN DE LA PENSIÓN"]
[null,null,null,null,"CON EL SEGURO SOCIAL FEDERAL"]
[]
[]
[null,null,null,null,{"$f":"IF(TipoPensión=\"EAS\",\" √    Pensión por Edad y Años de Servicio\",\"        Pensión por Edad y Años de Servicio\")","v":" √    Pensión por Edad y Años de Servicio"},null,null,null,{"$f":"IF(TipoPensión=\"IO\",\"√  Pensión por Incapacidad Ocupacional\",\"      Pensión por Incapacidad Ocupacional\")","v":"      Pensión por Incapacidad Ocupacional"},null,null,null,null,null,null,{"$f":"IF(TipoPensión=\"INO\",\"√   Pensión por Incapacidad No Ocupacional\",\"     Pensión por Incapacidad No Ocupacional\")","v":"     Pensión por Incapacidad No Ocupacional"}]
[]
[null,null,null,null,"Sección I.  Información del Pensionado y la Coordinación:"]
[]
[null,null,null,null,null,null,null,null,null,"Seguro",null,null,"Fecha"]
[null,null,null,null,"Nombre",null,null,null,null,"Social",null,null,"Nacimiento",null,"Separación",null,"Efectividad",null,null,null,"Coordinación"]
[]
[null,null,null,null,"Dirección",null,null,null,null,null,null,null,"Edad al ",null,"Años de",null,"Retribución",null,null,null,"Pensión"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retirarse",null,"Servicio",null,"Promedio",null,null,null,"Original"]
[]
[]
[null,null,null,null,"Sección II.  Detalles del Cómputo de la Coordinación:"]
[null,null,null,null,null,"Retribución"]
[null,null,null,null,null,"Promedio",null,"%"]
[null,null,null,null,null,null,"X",0.01,{"$f":"F20*H20","v":0},null,null,"=",null,null,{"$f":"TRUNC(K20*I20,2)","v":0}]
[null,null,null,null,null,null,"X",1.4999999999999999E-2,{"$f":"F21*H21","v":0},null,null,"=",null,null,{"$f":"TRUNC(I21*K21,2)","v":0}]
[null,null,null,null,null,null,"X",1.4999999999999999E-2,{"$f":"F22*H22","v":0},null,null,null,null,null,{"$f":"TRUNC(I22*K22,2)","v":0}]
[null,null,null,null,null,null,"X",0.02,{"$f":"F23*H23","v":0},"X",null,"=",null,null,{"$f":"IF(F23=\"\",\"\",TRUNC(I23*K23,2))","v":""},null,null,null,null,null,null,null,null,{"$f":"SUM(O20:P23)","v":0}]
[null,null,null,null,null,null,"Porciento Actuarial",null,null,null,null,null,null,null,{"$f":"PorcientoActuarial","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(PorcientoActuarial>0,TRUNC(O24*X23,2),X23)","v":0}]
[null,null,null,null,null,null,"Pensión Anual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X24","v":0}]
[null,null,null,null,"Pensión coordinada sin aumentos:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mensual",null,null,null,{"$f":"ROUND(X25/12,2)","v":0}]
[]
[null,null,null,null,"Sección III.  Aumentos Otorgados por Leyes Especiales:"]
[]
["Ley","Fecha",null,null,"Ley","Fecha",null,null,null,null,null,null,null,"Pensión Original",null,null,null,null,"Pensión Coordinada"]
["Número","Aprobada","Requisito*","Vigencia","Número","Aprobada",null,"Requisito*",null,"Vigencia",null,null,null,"Aumentos",null,"Total",null,"Total","Aumentos",null,null,"Total","Total"]
["Ley Núm. 127",1967,null,"1967-07-01",{"$f":"IF(OR(TipoPensión=\"M\",SeguroSocial=\"\"),\"\",IF(OR(V32<>CoordinaciónBásicaEAS,R32<>PensiónBásicaOriginal),A32,\"\"))","v":""},{"$f":"IF(OR(TipoPensión=\"M\",SeguroSocial=\"\"),\"\",IF(OR(V32<>CoordinaciónBásicaEAS,R32<>PensiónBásicaOriginal),B32,\"\"))","v":""},null,{"$f":"IF(SeguroSocial=\"\",\"\",IF(OR(V32<>CoordinaciónBásicaEAS,R32<>PensiónBásicaOriginal),C32,\"\"))","v":""},null,{"$f":"IF(OR(TipoPensión=\"M\",SeguroSocial=\"\"),\"\",IF(OR(V32<>CoordinaciónBásicaEAS,R32<>PensiónBásicaOriginal),D32,\"\"))","v":""},null,null,null,{"$f":"IF(TipoPensión=\"M\",0,IF(FechaEfectividad>D32,0,IF(FechaCoordinación<=D32,0,IF(AñosServicio<15,15,IF(AñosServicio<20,20,IF(AñosServicio<30,25,IF(AñosServicio>=30,30)))))))","v":0},null,{"$f":"IF(OR(V32<>CoordinaciónBásicaEAS,R32<>PensiónBásicaOriginal),R32,0)","v":0},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),PensiónBásicaOriginal+N32,0)","v":205.93},null,{"$f":"IF(TipoPensión=\"M\",0,IF(FechaEfectividad>D32,0,IF(FechaCoordinación>D32,0,IF(AñosServicio<15,15,IF(AñosServicio<20,20,IF(AñosServicio<30,25,IF(AñosServicio>=30,30)))))))","v":0},null,{"$f":"CoordinaciónBásicaEAS+T32+N32","v":0},null,{"$f":"IF(AND(V32=CoordinaciónBásicaEAS,FechaEfectividad>D32),0,V32)","v":0}]
["Ley Núm. 49",1970,null,"1970-07-01",{"$f":"IF(OR(V33<>V32,R33<>R32),A33,\"\")","v":""},{"$f":"IF(OR(V33<>V32,R33<>R32),B33,\"\")","v":""},null,{"$f":"IF(OR(V33<>V32,R33<>R32),C33,\"\")","v":""},null,{"$f":"IF(OR(V33<>V32,R33<>R32),D33,\"\")","v":""},null,null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaCoordinación<=D33,0,IF(AND(FechaEfectividad<=D33,R32<100),IF(R32<65,65-R32,IF(R32<85,R32-85,IF(R32<100,R32-100))),0)),0)","v":0},null,{"$f":"IF(OR(V33<>V32,R33<>R32),R33,\"\")","v":""},null,{"$f":"IF(OR(N33=\"\",N33=0),R32,R32+N33)","v":205.93},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaCoordinación>=D33,0,IF(AND(FechaEfectividad<=D33,V32<100),IF(V32<65,65-V32,IF(V32<85,V32-85,IF(V32<100,V32-100))),0)),0)","v":0},null,{"$f":"V32+T33+N33","v":0},null,{"$f":"IF(OR(V33<>V32,R33<>R32),V33,\"\")","v":""}]
["Ley Núm. 49",1971,null,"1971-07-01",{"$f":"IF(OR(V34<>V33,R34<>R33),A34,\"\")","v":""},{"$f":"IF(OR(V34<>V33,R34<>R33),B34,\"\")","v":""},null,{"$f":"IF(OR(V34<>V33,R34<>R33),C34,\"\")","v":""},null,{"$f":"IF(OR(V34<>V33,R34<>R33),D34,\"\")","v":""},null,null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaCoordinación<D34,0,IF(AND(FechaEfectividad<=D34,R33<100),IF(R33<80,80-R33,IF(R33<100,R33-100)),0)),0)","v":0},null,{"$f":"IF(OR(V34<>V33,R34<>R33),R34,\"\")","v":""},null,{"$f":"IF(OR(N34=\"\",N34=0),R33,R33+N34)","v":205.93},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaCoordinación>=D34,0,IF(AND(FechaEfectividad<=D34,V33<100),IF(V33<80,80-V33,IF(V33<100,V33-100)),0)),0)","v":0},null,{"$f":"V33+T34+N34","v":0},null,{"$f":"IF(OR(V34<>V33,R34<>R33),V34,\"\")","v":""}]
["Ley Núm. 28","1972-05-03",null,"1972-07-01",{"$f":"IF(OR(V35<>V34,R35<>R34),A35,\"\")","v":""},{"$f":"IF(OR(V35<>V34,R35<>R34),B35,\"\")","v":""},null,{"$f":"IF(OR(V35<>V34,R35<>R34),C35,\"\")","v":""},null,{"$f":"IF(OR(V35<>V34,R35<>R34),D35,\"\")","v":""},null,null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(AND(FechaCoordinación>D35,FechaEfectividad<=D35,R34<500),IF(R34<100,115-R34,IF(R34<500,15)),0),0)","v":0},null,{"$f":"IF(OR(V35<>V34,R35<>R34),R35,\"\")","v":""},null,{"$f":"IF(OR(N35=\"\",N35=0),R34,R34+N35)","v":205.93},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(AND(FechaCoordinación<=D35,FechaEfectividad<=D35,V34<500),IF(V34<100,115-V34,IF(V34<500,15)),0),0)","v":0},null,{"$f":"V34+T35+N35","v":0},null,{"$f":"IF(OR(V35<>V34,R35<>R34),V35,\"\")","v":""}]
["Ley Núm. 28","1972-05-03",null,"1972-07-01"]
["Ley Núm. 124","1973-06-08",null,"1973-07-01"]
["Ley Núm. 110","1974-07-08",null,"1974-07-01"]
["Ley Núm. 109","1979-07-16",null,"1979-07-01"]
["Ley Núm. 22","1981-07-01",null,"1979-07-01"]
["Ley Núm. 23","1983-09-23",null,"1983-07-01"]
["Ley Núm. 15","1987-04-24",null,"1987-01-01"]
["Ley Núm. 48","1988-06-29",null,"1988-07-01"]
["Ley Núm. 10","1992-05-21","1989-01-01","1992-01-01"]
["Ley Núm. 207","1995-08-13","1992-01-01","1995-01-01"]
["Ley Núm. 221","1998-08-09","1995-01-01","1998-01-01"]
["Ley Núm. 40","2001-06-13","1998-01-01","2001-01-01"]
["Ley Núm. 156","2003-06-27",null,"2004-01-01"]
["Ley Núm. 157","2003-06-27","2001-01-01","2004-01-01"]
[null,null,null,null,{"$f":"IF(OR(V50<>V49,R50<>R49),A50,\"\")","v":""},{"$f":"IF(OR(V50<>V49,R50<>R49),B50,\"\")","v":""},null,{"$f":"IF(OR(V50<>V49,R50<>R49),C50,\"\")","v":""},null,{"$f":"IF(OR(V50<>V49,R50<>R49),D50,\"\")","v":""},null,null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaEfectividad>C50,0,IF(FechaCoordinación>D50,TRUNC(R49*0.03,2),0)),0)","v":0},null,{"$f":"IF(OR(V50<>V49,R50<>R49),R50,\"\")","v":""},null,{"$f":"IF(OR(N50=\"\",N50=0),R49,R49+N50)","v":0},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaEfectividad>C50,0,IF(FechaCoordinación<=D50,TRUNC(V49*0.03,2),0)),0)","v":0},null,{"$f":"V49+T50+N50","v":0},null,{"$f":"IF(OR(V50<>V49,R50<>R49),V50,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(OR(V51<>V50,R51<>R50),A51,\"\")","v":""},{"$f":"IF(OR(V51<>V50,R51<>R50),B51,\"\")","v":""},null,{"$f":"IF(OR(V51<>V50,R51<>R50),C51,\"\")","v":""},null,{"$f":"IF(OR(V51<>V50,R51<>R50),D51,\"\")","v":""},null,null,null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaEfectividad>C51,0,IF(FechaCoordinación>D51,TRUNC(R50*0.03,2),0)),0)","v":0},null,{"$f":"IF(OR(V51<>V50,R51<>R50),R51,\"\")","v":""},null,{"$f":"IF(OR(N51=\"\",N51=0),R50,R50+N51)","v":0},null,{"$f":"IF(OR(TipoPensión=\"EAS\",TipoPensión=\"INO\",TipoPensión=\"IO\"),IF(FechaEfectividad>C51,0,IF(FechaCoordinación<=D51,TRUNC(V50*0.03,2),0)),0)","v":0},null,{"$f":"V50+T51+N51","v":0},null,{"$f":"IF(OR(V51<>V50,R51<>R50),V51,\"\")","v":""}]
[null,null,null,null,"Pensión coordinada con aumentos (si aplican):",null,null,null,null,null,null,null,null,{"$f":"SUM(N32:N51)","v":0},null,null,null,null,null,{"$f":"SUM(T32:T51)","v":0},null,{"$f":"V51","v":0},null,{"$f":"CoordinaciónEAS","v":0}]
[]
[null,null,null,null,"Sección IV.  Preparación y Revisión:"]
[]
[null,null,null,null,"Preparado por:",null,null,null,null,null,null,null,"Revisado por:"]
[null,null,null,null,"Nombre:",null,null,null,null,null,null,null,"Nombre:"]
[null,null,null,null,"Firma:",null,null,null,null,null,null,null,"Firma:"]
[null,null,null,null,"Puesto:",null,null,null,null,null,null,null,"Puesto:"]
[null,null,null,null,"Fecha (día/mes/año):",null,null,null,null,null,null,null,"Fecha (día/mes/año):"]
[]
[]
[null,null,null,null,"Sección V.  Aprobación:"]
[]
[null,null,null,null,"Verificación de:",null,null,"Aprobado por:"]
[null,null,null,null,"        Exactitud","        Otros",null,"Nombre:",null,null,null,null,null,null,null,"Firma:"]
[null,null,null,null,"        Legalidad"]
[null,null,null,null,"        Firmas","(Especifique)",null,"Puesto:",null,null,null,null,null,null,null,"Fecha (día/mes/año):"]
[]
[]
[null,null,null,null,"*  Para tener derecho al aumento de 3%, la pensión se tiene que haber aprobado por lo menos tres años antes de la vigencia de la  ley."]
[]
[null,null,null,null,"Conservación: Igual que el expediente del cual forma parte."]

{"sheet":"JR-DI-078 Ret. Prom. Años Serv.","index":3,"n_rows":88,"n_cols":47,"rows_kept":88,"cut":false,"hidden":false,"merged":[[6,0,6,32],[7,0,7,32],[1,0,1,32],[2,0,2,1],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,15,2,19],[2,26,2,28],[8,0,8,32],[10,0,10,32],[12,0,12,17],[12,18,12,20],[12,22,12,24],[12,31,12,32],[11,0,11,32],[9,0,9,32],[13,0,13,17],[13,18,13,20],[13,22,13,24],[13,31,13,32],[45,34,45,38],[15,0,15,32],[17,0,17,1],[17,13,17,14],[17,17,17,22],[17,26,17,28],[45,43,45,46],[46,18,46,31],[73,0,73,32],[18,0,18,1],[18,13,18,14],[44,0,44,32],[45,0,45,1],[45,18,45,31],[76,13,76,18],[76,23,76,32],[77,13,77,18],[77,23,77,32],[74,0,74,18],[74,20,74,32],[75,13,75,18],[75,23,75,32],[83,13,83,14],[84,18,84,23],[78,13,78,18],[78,23,78,32],[80,0,80,32],[82,18,82,23],[82,31,82,32]]}
["Años de Servicio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG43","v":0}]
[{"$f":"\"Servicios Acreditables: \"&AG43","v":"Servicios Acreditables: 0"}]
["Periodo",null,"Fin","Año Fiscal",null,"1er. Año",null,"Últ. Año",null,"Total Días","Días","Acum.","Días",null,"Acum.","Meses de 1er Año",null,null,null,null,null,"Suma de","Meses","Servicios","Servicios","Total Días","Meses de Últ. Año",null,null,"Suma de","Meses","Servicios","Años"]
["Desde","Hasta","1er. Año","1ro.","Últ.","De","Hasta","De","Hasta","1er Mes","1er Mes","1er. Mes","Ult. Mes",null,"Últ. Mes","1er Mes","Últ. Mes",null,"Ent.","Subtotal",null,"Meses","Acum.","1er Año","Años Ent.","Ult. Mes","Ent.","Últ. Mes","Subtotal","Meses","Acum.","Últ. Año","Servicio"]
[null,"Meses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W71","v":0}]
["Retribución Promedio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG72","v":0}]
[]
[]
[]
["HOJA PARA COMPUTAR AÑOS DE SERVICIO "]
["ACREDITABLES Y RETRIBUCIÓN PROMEDIO"]
["Sección I.  Información del Solicitante y Resultados de los Cómputos"]
["Nombre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seguro Social",null,null,null,"Años de Servicio",null,null,null,null,null,null,null,null,"Retribución Promedio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG43","v":0},null,null,null,null,null,null,null,null,{"$f":"AG72","v":0}]
[]
["Sección II.  Cómputo de Años de Servicio Acreditables (Computados por Año Fiscal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1er. Año",null,null,null,null,null,null,null,"Últ. Año"]
["Periodo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meses del 1er. Año",null,null,null,null,null,"(De 3 a 5  = .5",null,null,"Meses del Último Año",null,null,null,null,"(De 3 a 5  = .5"]
["(día/mes/año)",null,null,null,null,null,null,null,null,null,null,"Días del",null,"Días",null,null,null,"Conversión","Meses",null,"Periodo",null,null,"De 6 a 8  = .75","Años",null,"Meses","Último",null,null,"Meses","De 6 a 8  = .75"]
["Desde","Hasta",null,null,null,null,null,null,null,null,null,"Primer Mes",null,"1er. Mes","Últ. Mes",null,null,"(15 días = 1 )","Enteros",null,"Anterior",null,"Total","9 ó más = 1)","Enteros",null,"Enteros","Mes","Total",null,"Último Año","9 ó más = 1)","Total"]
["00:00:00","00:00:00",null,null,null,null,null,null,null,{"$f":"IF(OR(A21=\"\",A21=0,B21=0,B21=\"\"),0,IF(MONTH(A21)=2,IF(MOD(A21,4)=0,29,28),VLOOKUP(MONTH(A21),Meses,4)))","v":0},{"$f":"IF(OR(A21=\"\",A21=0,B21=0,B21=\"\"),0,IF(AND(DAY(A21)=1,MONTH(A21)<>MONTH(B21)),0,IF(AND(YEAR(B21)=YEAR(A21),MONTH(B21)=MONTH(A21),DAY(A21)=1),DAY(B21),IF(AND(YEAR(B21)=YEAR(A21),MONTH(B21)=MONTH(A21),DAY(A21)<>1),ABS(DAY(A21)-DAY(B21))+1,J21-DAY(A21)+1))))","v":0}]
[null,null,{"$f":"IF(D22<>E22,DATE(YEAR(A22)+IF(MONTH(A22)>6,1,0),6,30),B22)","v":"00:00:00"},{"$f":"IF(A22=\"\",\"\",IF(MONTH(A22)>6,YEAR(A22)+1,YEAR(A22)))","v":""},{"$f":"IF(B22=\"\",\"\",IF(MONTH(B22)>6,YEAR(B22)+1,YEAR(B22)))","v":""},{"$f":"IF(A22=\"\",\"\",IF(MONTH(A22)>6,YEAR(A22)+1,YEAR(A22)))","v":""},{"$f":"IF(B22=\"\",\"\",IF(MONTH(C22)>6,YEAR(C22)+1,YEAR(C22)))","v":""},{"$f":"IF(I22=\"\",0,I22-1)","v":0},{"$f":"IF(B22=\"\",\"\",IF(MONTH(B22)>6,YEAR(B22)+1,YEAR(B22)))","v":""},0,{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(AND(YEAR(B22)=YEAR(A22),MONTH(B22)=MONTH(A22),DAY(A22)=1),DAY(B22),IF(AND(YEAR(B22)=YEAR(A22),MONTH(B22)=MONTH(A22),DAY(A22)<>1),ABS(DAY(A22)-DAY(B22))+1,J22-DAY(A22)+1)))","v":0},{"$f":"IF(AND(O21=0,AND(YEAR(A22)=YEAR(B21),MONTH(A22)=MONTH(B21))),K22+DAY(B21),K22)","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22),0,IF(AND(YEAR(A22)=YEAR(B22),MONTH(A22)=MONTH(B22)),0,IF(B22=C22,DAY(B22),DAY(C22))))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(A22<=B21,\"Días repetidos\",IF(B22<=A22,\"Error 2a. fecha\",IF(K22<>L22,DAY(B21)&\" + \"&K22&\" = \"&L22,K22))))","v":0},{"$f":"IF(OR(AND(MONTH(B22)=MONTH(A23),YEAR(B22)=YEAR(A23)),AND(MONTH(A22)=MONTH(C22),YEAR(A22)=YEAR(C22))),0,M22)","v":0},{"$f":"IF(L22>=15,1,0)","v":0},{"$f":"IF(O22>=15,1,0)","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(A22<=B21,\"Error en fecha\",P22+Q22))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,AND(YEAR(A22)=YEAR(B22),MONTH(A22)=MONTH(B22))),0,VLOOKUP(MONTH(C22),Meses,5)-VLOOKUP(MONTH(A22),Meses,5)+1-IF(N22>0,1,0)-IF(O22>0,1,0))","v":0},{"$f":"R22+S22","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(A22<=B21,\"Error\",IF(AND(AD21>0,AD21<12,F22=I21),AD21,0)))","v":0},{"$f":"IF(AND(F22=F21,F22=G22),T22+V21,T22)+U22","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(A22<=B21,\"Error\",IF(F22<>F23,V22,0)))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,A22<=B21),0,IF(W22<3,0,IF(W22<=5,0.5,IF(W22<=8,0.75,IF(W22>8,1)))))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,A22<=B21),0,IF(OR(YEAR(B22)>YEAR(A22)+1,AND(YEAR(A22)<>YEAR(B22),MONTH(B22)>6)),YEAR(B22)-YEAR(A22)-IF(AND(X22>0,MONTH(A22)>6),1,0)-IF(MONTH(B22)<=6,1,0),0))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\"),0,IF(MONTH(B22)=2,IF(MOD(B22,4)=0,29,28),VLOOKUP(MONTH(B22),Meses,4)))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,AND(I21=I22,X22>0)),0,IF(OR(YEAR(B22)>YEAR(A22)+1,AND(YEAR(A22)<>YEAR(B22),OR(MONTH(B22)>6,A23=\"\")),AND(YEAR(A22)=YEAR(B22),MONTH(A22)<6,MONTH(B22)>6)),VLOOKUP(MONTH(B22),Meses,5)-1,0))","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,AND(I21=I22,X22>0)),0,IF(OR(YEAR(B22)>YEAR(A22)+1,AND(YEAR(A22)<>YEAR(B22),OR(MONTH(B22)>6,A23=\"\")),AND(YEAR(A22)=YEAR(B22),MONTH(A22)<6,MONTH(B22)>6)),IF(B22-DAY(B22)<>A23-DAY(A23),IF(DAY(B22)>=15,1,0),0),0))","v":0},{"$f":"SUM(AA22:AB22)","v":0},{"$f":"IF(AND(D22=D21,D22=E22),AC22+AD21,AC22)","v":0},{"$f":"IF(AND(D22<>D23,OR(F23<>I22,AD22=12)),AD22,0)","v":0},{"$f":"IF(OR(A22=\"\",A22=0,B22=0,B22=\"\",B22<A22,A22<=B21),0,IF(AE22<3,0,IF(AE22<=5,0.5,IF(AE22<=8,0.75,IF(AE22>8,1)))))","v":0},{"$f":"X22+Y22+AF22","v":0}]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"00:00:00","","","","",0,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["00:00:00","00:00:00",null,null,null,null,null,null,null,0,0]
["Total",null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG22:AG41)","v":0}]
[]
["Sección III.  Cómputo de la Retribución Promedio"]
["Periodo (día/mes/año)",null,null,null,null,null,null,null,null,null,null,null,null,"Sueldo","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sueldo",null,"Meses",null,null,null,null,"Total de Días","Días del","Total de Días","Días","D  í  a  s"]
["Desde","Hasta",null,null,null,null,null,null,null,null,null,null,null,"Mensual","Meses",null,null,"Días","Explicación del Cómputo",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"1er Mes","1er Año","Años Enteros","Ult. Mes","Ult. Año","del 1er Mes","1er Mes","del Ult. Mes","Ult. Mes",28,29,30,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI48:AM48)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(AO48=0,1,0))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\",AND(YEAR(A48)=YEAR(B48),MONTH(A48)=MONTH(B48))),0,IF(YEAR(A48)<>YEAR(B48),12-MONTH(A48),IF(VLOOKUP(MONTH(B48),Meses,5)>=VLOOKUP(MONTH(A48),Meses,5),VLOOKUP(MONTH(B48),Meses,5)-VLOOKUP(MONTH(A48),Meses,5)-1,12-VLOOKUP(MONTH(A48),Meses,5)-1)))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(YEAR(B48)=YEAR(A48), 0,(YEAR(B48)-YEAR(A48)-1))*12)","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(AND(YEAR(A48)=YEAR(B48),MONTH(A48)=MONTH(B48)),0,IF(AP48=DAY(B48),1,0)))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(YEAR(A48)=YEAR(B48),0,VLOOKUP(MONTH(B48),Meses,5)-1))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(MONTH(A48)=2,IF(MOD(YEAR(A48),4)=0,29,28),VLOOKUP(MONTH(A48),Meses,4)))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(AND(DAY(A48)=1,MONTH(A48)<>MONTH(B48)),0,IF(AND(YEAR(B48)=YEAR(A48),MONTH(B48)=MONTH(A48),DAY(A48)=1),DAY(B48),IF(AND(YEAR(B48)=YEAR(A48),MONTH(B48)=MONTH(A48),DAY(A48)<>1),DAY(B48)-DAY(A48)+1,AN48-DAY(A48)+1))))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(MONTH(B48)=2,IF(MOD(YEAR(B48),4)=0,29,28),VLOOKUP(MONTH(B48),Meses,4)))","v":0},{"$f":"IF(OR(A48=\"\",A48=0,B48=0,B48=\"\"),0,IF(AND(YEAR(A48)=YEAR(B48),MONTH(A48)=MONTH(B48)),0,IF(AP48=DAY(B48),0,DAY(B48))))","v":0},{"$f":"IF(AND(MOD(YEAR($AG21),4)<>0,MONTH($AG21)=2),$AN48,0)+IF(AND(MOD(YEAR($A48),4)<>0,MONTH($A48)=2),$AP48,0)","v":0},{"$f":"IF(AND(MOD(YEAR($AG21),4)=0,MONTH($AG21)=2),$AN48,0)+IF(AND(MOD(YEAR($A48),4)=0,MONTH($A48)=2),$AP48,0)","v":0},{"$f":"IF(VLOOKUP(MONTH(A48),Meses,4)=30,AO48,0)+IF(VLOOKUP(MONTH(B48),Meses,4)=30,AQ48,0)","v":0},{"$f":"IF(VLOOKUP(MONTH(A48),Meses,4)=31,AO48,0)+IF(VLOOKUP(MONTH(B48),Meses,4)=31,AQ48,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI49:AM49)","v":0},null,null,{"$f":"IF(OR(A49=\"\",B49=\"\"),\"\",AO49+AQ49)","v":""},{"$f":"IF(OR(A49=\"\",B49=\"\"),\"\",IF(O49=0,\"\",\"(\"&DOLLAR(N49,2)&\" x \"&O49&IF(O49=1,\" mes\",\" meses\")&\")\")&IF(AND(O49>0,AO49>0),\" + \",\"\")&IF(AO49=0,\"\",\"(\"&DOLLAR(N49,2)&\" x \"&AO49&\" días ÷ \"&AN49&\" días)\")&IF(AQ49>0,\" + \",\"\")&IF(AQ49=0,\"\",\"(\"&DOLLAR(N49,2)&\" x \"&AQ49&\" días ÷ \"&AP49&\" días)\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(A49=\"\",B49=\"\"),\"\",IF(O49=0,0,N49*O49)+IF(AO49=0,0,N49*AO49/AN49)+IF(AQ49=0,0,N49*AQ49/AP49))","v":""},null,0,{"$f":"IF(OR(A49=\"\",A49=0,B49=0,B49=\"\",AND(YEAR(A49)=YEAR(B49),MONTH(A49)=MONTH(B49))),0,IF(YEAR(A49)<>YEAR(B49),12-MONTH(A49),IF(MONTH(B49)>=MONTH(A49),MONTH(B49)-MONTH(A49)-1,12-MONTH(A49)-1)))","v":0},0,0,{"$f":"IF(OR(A49=\"\",A49=0,B49=0,B49=\"\"),0,IF(YEAR(A49)=YEAR(B49),0,MONTH(B49)-1))","v":0},0,{"$f":"IF(OR(A49=\"\",A49=0,B49=0,B49=\"\"),0,IF(AND(DAY(A49)=1,MONTH(A49)<>MONTH(B49)),0,IF(AND(YEAR(B49)=YEAR(A49),MONTH(B49)=MONTH(A49),DAY(A49)=1),DAY(B49),IF(AND(YEAR(B49)=YEAR(A49),MONTH(B49)=MONTH(A49),DAY(A49)<>1),DAY(B49)-DAY(A49)+1,IF(AND(DAY(A49)=1,A49-DAY(A49)<>B49-DAY(B49)),0,AN49-DAY(A49)+1)))))","v":0},0,0,{"$f":"IF(AND(MOD(YEAR(A49),4)<>0,MONTH(A49)=2),AO49,0)+IF(AND(MOD(YEAR(B49),4)<>0,MONTH(B49)=2),AQ49,0)","v":0},{"$f":"IF(AND(MOD(YEAR(A49),4)=0,MONTH(A49)=2),AO49,0)+IF(AND(MOD(YEAR(B49),4)=0,MONTH(B49)=2),AQ49,0)","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI50:AM50)","v":0},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI51:AM51)","v":0},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI53:AM53)","v":0},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Total devengado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG48:AG68)","v":0}]
["Total de meses y días",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O48:O68)","v":0},null,null,{"$f":"SUM(R48:R68)","v":0},"Total en meses",null,null,null,{"$f":"O71+(AR71/28)+(AS71/29)+(AT71/30)+(AU71/31)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN48:AN68)","v":0},0,0,0,0,0,0,0]
["Retribución Promedio (Total devengado dividido entre tres)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG70/3","v":0}]
[]
["Sección IV.  Preparación y Revisión"]
["Preparado por:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revisado por:"]
["Nombre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre:"]
["Firma:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma:"]
["Puesto:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puesto:"]
["Fecha(día/mes/año): ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha(día/mes/año): "]
[]
["Sección V. Aprobación:"]
["Verificación de:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aprobado por:"]
["        Exactitud",null,null,null,null,null,null,null,null,null,null,null,null,"        Otros",null,null,null,"Nombre:",null,null,null,null,null,null,"Firma:"]
["        Legalidad"]
["        Firmas",null,null,null,null,null,null,null,null,null,null,null,null,"(Especifique)",null,null,null,"Puesto:",null,null,null,null,null,null,"Fecha(día/mes/año): "]
[]
[]
["Conservación:  Igual que el expediente del cual forma parte."]

{"sheet":"JR-DI-079 Deuda Mes Coord.","index":4,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,4],[37,0,37,12],[10,0,10,12],[15,0,15,12],[24,0,24,12],[30,0,30,12],[35,7,35,12],[33,4,33,5],[35,4,35,5],[18,0,18,2],[19,0,19,2],[33,8,33,11],[34,1,34,2],[35,1,35,2],[28,6,28,12],[29,6,29,12],[13,0,13,2],[1,0,1,12],[2,0,2,12],[17,0,17,2],[3,0,3,12],[16,3,16,4],[16,8,16,11],[14,0,14,2],[6,0,6,12],[16,6,16,7],[17,6,17,7],[13,6,13,12],[12,0,12,4],[13,3,13,5],[14,3,14,5],[11,5,11,12],[12,5,12,12],[14,6,14,12],[20,0,20,2],[34,6,35,6],[36,7,36,12],[7,0,7,12],[19,6,19,7],[26,1,26,4],[27,1,27,4],[16,0,16,2],[18,6,18,7],[26,6,26,12],[27,6,27,12],[21,0,21,2],[25,0,25,4],[28,1,28,4],[29,1,29,4]]}
[]
["HOJA DE CÓMPUTO DE DEUDA AL PENSIONADO"]
["EN EL MES DE LA COORDINACIÓN"]
[]
[]
[]
[]
[]
[]
[]
["Sección I.  Información del Pensionado y la Coordinación:"]
["Nombre",null,null,null,null,"Seguro Social"]
[]
["Tipo de Pensión",null,null,"Fecha de Efectividad",null,null,"Fecha de la Coordinación"]
[]
["Sección II.  Detalles del Cómputo:"]
[null,null,null,"Periodo",null,"Pensión",null,null,"D  í  a  s",null,null,null,"Pensión"]
["Descripción",null,null,"Desde","Hasta","Mensual","Fórmula",null,28,29,30,31,"Total"]
["Pensión antes de la coordinación"]
["Pensión coordinada"]
["Pensión que le Corresponde"]
["Pensión Pagada por Nómina",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F20","v":0}]
["Cantidad Adeudada al Pensionado",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SeguroSocial=\"\",\"\",M21-M22)","v":0}]
[]
["Sección III.  Preparación y Revisión:"]
["Preparado por:",null,null,null,null,"Revisado por:"]
["Nombre:",null,null,null,null,"Nombre:"]
["Firma:",null,null,null,null,"Firma:"]
["Puesto:",null,null,null,null,"Puesto:"]
["Fecha (día/mes/año):",null,null,null,null,"Fecha (día/mes/año):"]
["Sección IV.  Aprobación:"]
["Verificación de:",null,null,"Aprobado por:"]
[]
["        Exactitud","        Otros",null,"Nombre:",null,null,"Firma:"]
["        Legalidad",null,null,null,null,null,"Fecha:"]
["        Firmas","(Especifique)",null,"Puesto:"]
[null,null,null,null,null,null,null," (día/mes/año)"]
[]
["Conservación:  Igual que el expediente del cual forma parte."]

{"sheet":"JR-DI-081 Lista Coordinaciones","index":5,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,2,16,2],[15,5,15,6],[0,0,0,7],[1,0,1,7],[4,0,4,7],[2,0,2,7],[3,0,3,7]]}
[]
[]
[]
["LISTA DE"]
["PENSIONES COORDINADAS"]
[]
[null,null,"Subtotales por Tipo de Pensión","Pensionados","Código",null,null,"Deuda"]
[null,null,"Mérito",{"$f":"COUNTIF($E$19:$E$220,E8)","v":0},530100,null,null,{"$f":"SUMIF($E$19:$E$220,E8,$H$19:$H$220)","v":0},null,"Seguro Social","Nombre","Coordinación","DEPT.","Sin Coordinar","Coordinada","a Pagar"]
[null,null,"Diferida (Edad y Años de Servicio)",{"$f":"COUNTIF($E$19:$E$220,E9)","v":0},530110,null,null,{"$f":"SUMIF($E$19:$E$220,E9,$H$19:$H$220)","v":0},5,{"$f":"VLOOKUP(Contador,BancoDatos,2)","v":444444444},{"$f":"TRIM(Nombre&\" \"&Paterno&\" \"&Materno)","v":"FRANCISCO MELENDEZ RIVERA"},{"$f":"FechaCoordinación","v":"2002-08-21"},{"$f":"RHUMCod","v":"530110"},{"$f":"ROUND(MAX(PensiónMérito,PensiónEAS_INO_IO),2)","v":0},{"$f":"ROUND(PensiónCoordFinal,2)","v":0},{"$f":"ROUND(DeudaAPensionado,2)","v":0}]
[null,null,"Mérito",0,530120,null,null,0]
[null,null,"Mérito",0,530130,null,null,0]
[null,null,"Incapacidad Ocupacional (Ley 447)",0,530140,null,null,0]
[null,null,"Incapacidad No Ocupacional",0,530150,null,null,0]
[null,null,"Incapacidad Ocupacional (Ley 127)",0,530200,null,null,0]
[null,"Total",{"$f":"IF(H15<>J15,\"ERROR DE TOTALES\",\"\")","v":""},{"$f":"SUM(D8:D14)","v":0},null,null,null,{"$f":"SUM(H8:H14)","v":0},null,{"$f":"SUM(H19:H220)","v":0}]
[null,"Seguro","Nombre","Fecha de","RHUM","Pensión",null,"Deuda a"]
[null,"Social",null,"Coordinación","DEPT.","Sin Coordinar","Coordinada","Pensionado"]

{"sheet":"JR-80 Carta de Coordinación","index":6,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[12,0,15,0],[17,0,21,0],[26,0,27,0],[32,0,34,0],[29,0,30,0],[23,0,24,0]]}
[{"$f":"DAY(FechaPreparado)&\" de \"&VLOOKUP(MONTH(FechaPreparado),Meses,2)&\" de \"&YEAR(FechaPreparado)","v":"26 de marzo de 2025"}]
[]
[]
[{"$f":"IF(SeguroSocial=\"\",\"Nombre\",Nombre&\" \"&Paterno&\" \"&Materno)","v":"FRANCISCO MELENDEZ RIVERA"}]
[{"$f":"IF(SeguroSocial=\"\",\"Dirección\",Dirección)","v":"PARC. 86 A CALLE 17"}]
[{"$f":"IF(SeguroSocial=\"\",\"Dirección2\",IF(LEN(Dirección2)>1,Dirección2,Pueblo&\", \"&País&\"  \"&ZipCode))","v":"BO. MAMEYAL"}]
[{"$f":"IF(SeguroSocial=\"\",\"Pueblo, País y Zip Code\",IF(Dirección2>1,Pueblo&\", \"&País&\"  \"&ZipCode,\"\"))","v":"DORADO, PR  00646"},null,4,{"$f":"IF(Contador2=\"\",\"\",VLOOKUP(Contador2,BancoDatos,2))","v":444444444}]
[]
[{"$f":"IF(SeguroSocial=\"\",\"Seguro Social: ___-__-____\",\"Seguro Social: \"&TEXT(SeguroSocial,\"0##-##-####\"))","v":"Seguro Social: 444-44-4444"}]
[]
[{"$f":"IF(SeguroSocial=\"\",\"Estimado(a) señor(a) ________:\",IF(Sexo=\"F\",\"Estimada señora\",\"Estimado señor\")&\" \"&PROPER(Paterno)&\" \"&PROPER(Materno)&\":\")","v":"Estimado señor Melendez Rivera:"}]
[]
[{"$f":"\"Conforme a nuestros registros, el \"&IF(SeguroSocial=\"\",\"_____\",DAY(FechaCoordinación))&\" de \"&IF(SeguroSocial=\"\",\"_____\",VLOOKUP(MONTH(FechaCoordinación),Meses,2))&\" de \"&IF(SeguroSocial=\"\",\"_____\",YEAR(FechaCoordinación))&\", su pensión será recomputada al estar plenamente asegurado bajo el Seguro Social Federal.\"&\"  A partir de dicha fecha su pensión mensual será de \"&IF(SeguroSocial=\"\",\"$_____\",TEXT(MAX(CoordinaciónEAS,CoordinaciónMérito),\"$#,###.00\"))&\".  Si por alguna razón, no cualificara para recibir los beneficios del Seguro Social Federal\"&\" deberá someternos evidencia.\"","v":"Conforme a nuestros registros, el 21 de agosto de 2002, su pensión será recomputada al estar plenamente asegurado bajo el Seguro Social Federal.  A partir de dicha fecha su pensión mensual será de $.00.  Si por alguna razón, no cualificara para recibir los beneficios del Seguro Social Federal deberá someternos evidencia."}]
[]
[]
[]
[]
["Este recómputo de su pensión se debe a que cuando ingresó al Gobierno seleccionó el Plan Coordinado.  Esto implica que sus aportaciones al Sistema de Retiro fueron menores que las que hubiera hecho si se acogía al Plan de Completa Suplementación.  Por otra parte, al seleccionar este plan aceptó la condición de que su pensión sería reducida cuando estuviera plenamente asegurado bajo el Seguro Social Federal."]
[]
[]
[]
[]
[]
["No obstante, puede optar por cambiar al Plan de Completa Suplementación; para ello deberá cumplir con lo siguiente:"]
[]
[]
["Solicitar por escrito el cambio de plan de retiro y los costos envueltos en el mismo mediante el formulario provisto por la Agencia."]
[]
[]
["Pagar el costo (cantidad que dejó de aportar por seleccionar el Plan de Retiro Coordinado) y los intereses correspondiente."]
[]
[]
["Si realiza los pagos para cubrir estos costos antes de la fecha de su ajuste, su pensión no será reducida.  Si salda posterior a la fecha del ajuste, su pensión será recomputada al día primero del mes siguiente.  En estos casos, no se reembolsarán las cantidades correspondientes a los ajustes de meses anteriores."]
[]
[]
[]
["Cordialmente,"]
[]
[]
[{"$f":"PuestoRevisor","v":"Supervisor"}]
["Sección de Cómputos"]
["Área de Servicios al Pensionado"]

{"sheet":"Cómputo de Pensión Original","index":7,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[2,13,2,22],[2,1,2,10],[17,0,17,11],[30,0,30,11],[33,4,33,6],[43,3,43,4],[43,6,43,9],[42,3,42,4],[40,0,40,11],[1,1,1,10],[0,0,1,0],[5,0,5,11],[7,0,7,11]]}
["Rev.  OA     mjf/jlm                                                                                                                                            19-sep-2000"]
[null,"Estado Libre Asociado de Puerto Rico"]
[null,"ADMINISTRACIÓN DE LOS SISTEMAS DE RETIRO",null,null,null,null,null,null,null,null,null,null,null,"Gobierno de Puerto Rico"]
[]
[]
["HOJA DE CÓMPUTO DE LAS PENSIONES BÁSICAS"]
[]
["Cómputo de la Pensión por Mérito"]
[null,"Retribución"]
[null,"Promedio",null,"%"]
[null,{"$f":"IF(TipoPensión<>\"M\",0,IF(Edad<55,RetribuciónPromedio,0))","v":0},"X",0.65,null,null,null,"=","$",{"$f":"IF(TipoPensión<>\"M\",0,IF(Edad<55,TRUNC(B11*D11,2),0))","v":0}]
[null,{"$f":"IF(TipoPensión<>\"M\",0,IF(Edad>=55,RetribuciónPromedio,0))","v":0},"X",0.75,null,null,null,"=","$",{"$f":"IF(TipoPensión<>\"M\",0,IF(Edad>=55,TRUNC(B12*D12,2),0))","v":0},"$",{"$f":"SUM(J11:J12)","v":0}]
[null,null,null,null,"Máximo","(85% de la retribución promedio)",null,null,null,null,null,{"$f":"IF(TipoPensión<>\"M\",0,TRUNC(RetribuciónPromedio*0.85,2))","v":0}]
[null,null,null,null,"Pensión anual",null,null,null,null,null,"$",{"$f":"IF(L12>L13,L13,L12)","v":0}]
[null,null,null,null,null,null,null,null,null,"Anual","$",{"$f":"L14","v":0}]
[null,null,null,null,null,null,null,null,null,"Mensual","$",{"$f":"TRUNC(L15/12,2)","v":0}]
[]
["Cómputo de la Pensión por edad y años de servicio"]
[null,"Retribución",null,null,null,null,"Años de"]
[null,"Promedio",null,"%",null,null,"Servicio"]
[null,{"$f":"IF(TipoPensión=\"EAS\",RetribuciónPromedio,0)","v":9985.33},"X",1.4999999999999999E-2,{"$f":"IF(TipoPensión<>\"EAS\",0,TRUNC(B21*D21,2))","v":149.77000000000001},"X",{"$f":"IF(TipoPensión<>\"EAS\",0,IF(AñosServicio>20,20,AñosServicio))","v":16.5},"=","$",{"$f":"IF(B21=0,0,TRUNC(E21*G21,2))","v":2471.1999999999998}]
[null,{"$f":"IF(TipoPensión<>\"EAS\",0,IF(AñosServicio>20,RetribuciónPromedio,0))","v":0},"X",0.02,{"$f":"IF(B22=0,0,TRUNC(B22*D22,2))","v":0},"X",{"$f":"IF(TipoPensión<>\"EAS\",0,IF(AñosServicio>20,AñosServicio-20,\"\"))","v":""},"=",null,{"$f":"IF(B22=0,0,TRUNC(E22*G22,2))","v":0},"$",{"$f":"SUM(J21:J22)","v":2471.1999999999998}]
[null,null,null,null,"Mínimo de pensión de 30% de la retrib. Promedio"]
[null,null,null,null,"para los participantes acogidos al 30-jun-60",null,null,null,null,null,null,{"$f":"IF(Mínimo30<>0,IF(TipoPensión=\"EAS\",TRUNC(RetribuciónPromedio*0.3,2),0),0)","v":0}]
[null,null,null,null,"Pensión mínima mensual",null,null,null,"$",0,null,{"$f":"IF(TipoPensión<>\"EAS\",0,TRUNC(J25*12,2))","v":0}]
[null,null,null,null,"Máximo","(75% de la retribución promedio)",null,null,null,null,null,{"$f":"IF(TipoPensión<>\"EAS\",0,TRUNC(RetribuciónPromedio*0.75,2))","v":7488.99}]
[null,null,null,null,"Pensión anual",null,null,null,null,null,"$",{"$f":"IF(L22<L26,L22,L26)","v":2471.1999999999998}]
[null,null,null,null,"Porciento actuarial",null,null,null,null,{"$f":"PorcientoActuarial","v":0},null,{"$f":"IF(PorcientoActuarial=0,L27,TRUNC(L27*J28,2))","v":2471.1999999999998}]
[null,null,null,null,"Pensión mensual",null,null,null,null,null,null,{"$f":"TRUNC(L28/12,2)","v":205.93}]
[]
["Cómputo de la Pensión por incapacidad no ocupacional"]
[null,"Retribución",null,null,null,null,"Años de"]
[null,"Promedio",null,"%",null,null,"Servicio"]
[null,{"$f":"IF(TipoPensión<>\"INO\",0,RetribuciónPromedio)","v":0},"X",0.3,"(Primeros 10 años)",null,null,"=","$",{"$f":"IF(TipoPensión<>\"INO\",0,TRUNC(B34*D34,2))","v":0}]
[null,{"$f":"IF(TipoPensión<>\"INO\",0,IF(AñosServicio>10,RetribuciónPromedio,0))","v":0},"X",0.01,{"$f":"IF(B35=0,0,B35*D35)","v":0},"X",{"$f":"IF(TipoPensión<>\"INO\",0,IF(AñosServicio>10,AñosServicio-10,0))","v":0},"=",null,{"$f":"IF(B35=0,0,TRUNC(E35*G35,2))","v":0},"$",{"$f":"SUM(J34:J35)","v":0}]
[null,null,null,null,"Máximo","(75% de la retribución promedio)",null,null,null,null,null,{"$f":"IF(TipoPensión=\"INO\",TRUNC(RetribuciónPromedio*0.5,2),0)","v":0}]
[null,null,null,null,"Pensión anual",null,null,null,null,null,"$",{"$f":"IF(L35>L36,L36,L35)","v":0}]
[null,null,null,null,null,null,null,null,null,"Anual","$",{"$f":"IF(PorcientoActuarial=0,L37,TRUNC(L37*J38,2))","v":0}]
[null,null,null,null,null,null,null,null,null,"Mensual","$",{"$f":"TRUNC(L38/12,2)","v":0}]
[]
["Cómputo de la Pensión por Incapacidad Ocupacional:"]
[null,"Retribución"]
[null,"Promedio",null,"%"]
[null,{"$f":"IF(TipoPensión=\"IO\",UltSalario,0)","v":0},"X",{"$f":"IF(FechaIngreso<DATE(1990,4,1),0.5,0.4)","v":0.5},null,"=",{"$f":"IF(TipoPensión<>\"IO\",0,TRUNC(B44*D44,2))","v":0},null,null,null,"$",{"$f":"IF(TipoPensión=\"IO\",G44*12,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"$",{"$f":"TRUNC(L44/12,2)","v":0}]

{"sheet":"Meses","index":8,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Mes","Abreviación","Días","Orden"]
[1,"enero","ene",31,7]
[2,"febrero","feb",28,8]
[3,"marzo","mar",31,9]
[4,"abril","abr",30,10]
[5,"mayo","may",31,11]
[6,"junio","jun",30,12]
[7,"julio","jul",31,1]
[8,"agosto","ago",31,2]
[9,"septiembre","sep",30,3]
[10,"octubre","oct",31,4]
[11,"noviembre","nov",30,5]
[12,"diciembre","dic",31,6]
[]
[null,"Quincenas"]
[null,"Primera","Segunda"]
[1,1,2]
[2,3,4]
[3,5,6]
[4,7,8]
[5,9,10]
[6,11,12]
[7,13,14]
[8,15,16]
[9,17,18]
[10,19,20]
[11,21,22]
[12,23,24]