{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Hoja1","Hoja4","Hoja2","Hoja3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":true,"merged":[[15,0,15,2],[15,3,15,5],[15,6,15,8],[11,0,11,2],[11,6,11,8],[11,3,11,5],[16,3,16,5],[16,6,16,8],[18,0,18,2],[18,3,18,5],[18,6,18,8],[0,3,0,5],[0,6,0,8],[1,3,1,5],[1,6,1,8],[2,3,2,5],[2,6,2,8],[4,3,4,5],[4,6,4,8],[3,3,3,5],[33,0,33,2],[33,3,33,5],[6,0,6,8],[7,0,7,2],[7,3,7,5],[7,6,7,8],[8,0,8,2],[8,3,8,5],[3,6,3,8],[23,0,23,2],[23,3,23,5],[23,6,23,8],[16,0,16,2],[38,0,38,2],[38,3,38,5],[26,0,26,2],[26,3,26,5],[30,0,30,2],[30,3,30,5],[31,0,31,2],[31,3,31,5]]}
[null,null,null,"1966-12-04",null,null,"1989-01-10"]
[null,null,null,"1964-07-04",null,null,"1992-10-13"]
[null,null,null,"1963-08-28",null,null,"1986-12-12"]
[null,null,null,"1970-09-20",null,null,"1993-01-01"]
[null,null,null,"1967-02-07",null,null,"1989-01-09"]
[]
["CALCUL DE JUBILACIÓ ANTICIPADA",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(IF(A18<1,1,0),IF(B18<1,1,0),IF(C18<1,1,0)),0,1)","v":1},"cotitzat als 65"]
["DATA DE NAIXEMENT",null,null,"DATA ANTIGUITAT GUB",null,null,"TEMPS COTITZAT FORA DE GUB",null,null,null,{"$f":"IF(AND(IF(D18<1,1,0),IF(E18<1,1,0),IF(F18<1,1,0)),0,1)","v":1},"cotitzat a la edat maxima"]
["1966-12-04",null,null,"2004-01-10",null,null,0,0,0,null,{"$f":"IF(AND(IF(G18<1,1,0),IF(H18<1,1,0),IF(I18<1,1,0)),0,1)","v":0},"100 % SENCERA"]
[null,null,null,null,null,null," ",null,null,null,{"$f":"IF(AND(IF(K7<1,1,0),IF(K8<1,1,0)),0,1)","v":1},"falta per cotitzar"]
["JUBILACIÓ ORDINARIA",null,null,null,null,null,null,null,null,null,{"$f":"IF(D16<G16,0,1)","v":0},"edat maxima o 100%"]
["ALS 65 ANYS",null,null,"EDAT MAXIMA o 67 ANYS",null,null,"100 % SENCERA"]
[{"$f":"Hoja3!H2","v":65},{"$f":"Hoja3!I2","v":0},{"$f":"Hoja3!J2","v":0},{"$f":"Hoja3!H4","v":67},{"$f":"Hoja3!I4","v":0},{"$f":"Hoja3!J4","v":0},{"$f":"Hoja3!H7","v":75},{"$f":"Hoja3!I7","v":7},{"$f":"Hoja3!J7","v":6},null,{"$f":"A13&\" anys, \"&B13&\" mesos, \"&C13&\" dies\"","v":"65 anys, 0 mesos, 0 dies"},{"$f":"D13&\" anys, \"&E13&\" mesos, \"&F13&\" dies\"","v":"67 anys, 0 mesos, 0 dies"},{"$f":"G13&\" anys, \"&H13&\" mesos, \"&I13&\" dies\"","v":"75 anys, 7 mesos, 6 dies"}]
[{"$f":"Hoja3!D5","v":38},{"$f":"Hoja3!E5","v":6},{"$f":"Hoja3!F5","v":0},{"$f":"Hoja3!D9","v":38},{"$f":"Hoja3!E9","v":6},{"$f":"Hoja3!F9","v":0},{"$f":"Hoja3!D7","v":38},{"$f":"Hoja3!E7","v":6},{"$f":"Hoja3!F7","v":0}]
[{"$f":"Hoja3!K2","v":27},{"$f":"Hoja3!L2","v":10},{"$f":"Hoja3!M2","v":24},{"$f":"Hoja3!K4","v":29},{"$f":"Hoja3!L4","v":10},{"$f":"Hoja3!M4","v":24},{"$f":"Hoja3!K7","v":38},{"$f":"Hoja3!L7","v":6},{"$f":"Hoja3!M7","v":0},null,{"$f":"A15&\" anys, \"&B15&\" mesos, \"&C15&\" dies\"","v":"27 anys, 10 mesos, 24 dies"},{"$f":"D15&\" anys, \"&E15&\" mesos, \"&F15&\" dies\"","v":"29 anys, 10 mesos, 24 dies"},{"$f":"G15&\" anys, \"&H15&\" mesos, \"&I15&\" dies\"","v":"38 anys, 6 mesos, 0 dies"}]
[{"$f":"Hoja3!$G$2","v":"2031-12-04"},null,null,{"$f":"Hoja3!$G$4","v":"2033-12-04"},null,null,{"$f":"Hoja3!$G$7","v":"2042-07-10"}]
["FALTA PER COTITZAR",null,null,"FALTA PER COTITZAR",null,null,"FALTA PER COTITZAR"]
[{"$f":"Hoja3!N6","v":10},{"$f":"Hoja3!O6","v":7},{"$f":"Hoja3!P6","v":6},{"$f":"Hoja3!N8","v":8},{"$f":"Hoja3!O8","v":7},{"$f":"Hoja3!P8","v":6},{"$f":"Hoja3!N5","v":0},{"$f":"Hoja3!O5","v":0},{"$f":"Hoja3!P5","v":0},{"$f":"IF(AND(IF(K7=0,1,0),IF(K8=0,1,0)),0,1)","v":1},{"$f":"A18&\" anys, \"&B18&\" mesos, \"&C18&\" dies\"","v":"10 anys, 7 mesos, 6 dies"},{"$f":"D18&\" anys, \"&E18&\" mesos, \"&F18&\" dies\"","v":"8 anys, 7 mesos, 6 dies"},{"$f":"G18&\" anys, \"&H18&\" mesos, \"&I18&\" dies\"","v":"0 anys, 0 mesos, 0 dies"}]
["COTITZAT EFECTIU GUB",null,null,"COTITZAT EFECTIU GUB",null,null,"COTITZAT EFECTIU GUB"]
[{"$f":"Hoja3!K21","v":23},{"$f":"Hoja3!L21","v":3},{"$f":"Hoja3!M21","v":18},{"$f":"Hoja3!K19","v":25},{"$f":"Hoja3!L19","v":1},{"$f":"Hoja3!M19","v":4},{"$f":"Hoja3!K20","v":33},{"$f":"Hoja3!L20","v":6},{"$f":"Hoja3!M20","v":0},null,{"$f":"A20&\" anys, \"&B20&\" mesos, \"&C20&\" dies\"","v":"23 anys, 3 mesos, 18 dies"},{"$f":"D20&\" anys, \"&E20&\" mesos, \"&F20&\" dies\"","v":"25 anys, 1 mesos, 4 dies"},{"$f":"G20&\" anys, \"&H20&\" mesos, \"&I20&\" dies\"","v":"33 anys, 6 mesos, 0 dies"}]
["JUBILACIÓ ANTICIPADA VOLUNTÀRIA"]
[{"$f":"Hoja3!E21","v":60},{"$f":"Hoja3!F21","v":4},{"$f":"Hoja3!G21","v":24},{"$f":"Hoja3!E19","v":62},{"$f":"Hoja3!F19","v":2},{"$f":"Hoja3!G19","v":10},{"$f":"Hoja3!E20","v":70},{"$f":"Hoja3!F20","v":7},{"$f":"Hoja3!G20","v":6},null,{"$f":"A22&\" anys, \"&B22&\" mesos, \"&C22&\" dies\"","v":"60 anys, 4 mesos, 24 dies"},{"$f":"D22&\" anys, \"&E22&\" mesos, \"&F22&\" dies\"","v":"62 anys, 2 mesos, 10 dies"},{"$f":"G22&\" anys, \"&H22&\" mesos, \"&I22&\" dies\"","v":"70 anys, 7 mesos, 6 dies"}]
[{"$f":"Hoja3!N21","v":4},{"$f":"Hoja3!O21","v":7},{"$f":"Hoja3!P21","v":6},{"$f":"Hoja3!N19","v":4},{"$f":"Hoja3!O19","v":9},{"$f":"Hoja3!P19","v":20},{"$f":"Hoja3!N20","v":5},{"$f":"Hoja3!O20","v":0},{"$f":"Hoja3!P20","v":0},"AMB 100% COTITZACIÓ",{"$f":"A23&\" anys, \"&B23&\" mesos, \"&C23&\" dies\"","v":"4 anys, 7 mesos, 6 dies"},{"$f":"D23&\" anys, \"&E23&\" mesos, \"&F23&\" dies\"","v":"4 anys, 9 mesos, 20 dies"},{"$f":"G23&\" anys, \"&H23&\" mesos, \"&I23&\" dies\"","v":"5 anys, 0 mesos, 0 dies"}]
[{"$f":"Hoja3!$C$21","v":"2027-04-28"},null,null,{"$f":"Hoja3!$C$19","v":"2029-02-14"},null,null,{"$f":"Hoja3!$C$20","v":"2037-07-10"}]
[]
["JUBILACIÓ ORDINARIA"]
["ALS 65 ANYS",null,null,"ALS 67 ANYS"]
[{"$f":"Hoja3!H11","v":70},{"$f":"Hoja3!I11","v":0},{"$f":"Hoja3!J11","v":0},{"$f":"Hoja3!H12","v":72},{"$f":"Hoja3!I12","v":0},{"$f":"Hoja3!J12","v":0},null,null,null,null,{"$f":"A28&\" anys, \"&B28&\" mesos, \"&C28&\" dies\"","v":"70 anys, 0 mesos, 0 dies"},{"$f":"D28&\" anys, \"&E28&\" mesos, \"&F28&\" dies\"","v":"72 anys, 0 mesos, 0 dies"}]
[]
[{"$f":"Hoja3!K11","v":32},{"$f":"Hoja3!L11","v":10},{"$f":"Hoja3!M11","v":24},{"$f":"Hoja3!K12","v":34},{"$f":"Hoja3!L12","v":10},{"$f":"Hoja3!M12","v":24},null,null,null,null,{"$f":"A30&\" anys, \"&B30&\" mesos, \"&C30&\" dies\"","v":"32 anys, 10 mesos, 24 dies"},{"$f":"D30&\" anys, \"&E30&\" mesos, \"&F30&\" dies\"","v":"34 anys, 10 mesos, 24 dies"}]
[{"$f":"Hoja3!$A$23","v":"2036-12-04"},null,null,{"$f":"Hoja3!$A$24","v":"2038-12-04"}]
["FALTA PER COTITZAR",null,null,"FALTA PER COTITZAR"]
[{"$f":"Hoja3!N13","v":5},{"$f":"Hoja3!O13","v":7},{"$f":"Hoja3!P13","v":6},{"$f":"Hoja3!N14","v":3},{"$f":"Hoja3!O14","v":7},{"$f":"Hoja3!P14","v":6},null,null,null,{"$f":"IF(AND(IF(A33=0,1,0),IF(B33=0,1,0),IF(C33=0,1,0)),0,1)","v":1},{"$f":"A33&\" anys, \"&B33&\" mesos, \"&C33&\" dies\"","v":"5 anys, 7 mesos, 6 dies"},{"$f":"D33&\" anys, \"&E33&\" mesos, \"&F33&\" dies\"","v":"3 anys, 7 mesos, 6 dies"}]
["COTITZAT EFECTIU GUB",null,null,"COTITZAT EFECTIU GUB"]
[{"$f":"Hoja3!K23","v":27},{"$f":"Hoja3!L23","v":10},{"$f":"Hoja3!M23","v":24},{"$f":"Hoja3!K24","v":29},{"$f":"Hoja3!L24","v":10},{"$f":"Hoja3!M24","v":24},null,null,null,null,{"$f":"A35&\" anys, \"&B35&\" mesos, \"&C35&\" dies\"","v":"27 anys, 10 mesos, 24 dies"},{"$f":"D35&\" anys, \"&E35&\" mesos, \"&F35&\" dies\"","v":"29 anys, 10 mesos, 24 dies"}]
["JUBILACIÓ ANTICIPADA VOLUNTÀRIA"]
[{"$f":"Hoja3!E23","v":65},{"$f":"Hoja3!F23","v":0},{"$f":"Hoja3!G23","v":0},{"$f":"Hoja3!E24","v":67},{"$f":"Hoja3!F24","v":0},{"$f":"Hoja3!G24","v":0},null,null,null,null,{"$f":"A37&\" anys, \"&B37&\" mesos, \"&C37&\" dies\"","v":"65 anys, 0 mesos, 0 dies"},{"$f":"D37&\" anys, \"&E37&\" mesos, \"&F37&\" dies\"","v":"67 anys, 0 mesos, 0 dies"}]
[{"$f":"Hoja3!N23","v":5},{"$f":"Hoja3!O23","v":0},{"$f":"Hoja3!P23","v":0},{"$f":"Hoja3!N24","v":5},{"$f":"Hoja3!O24","v":0},{"$f":"Hoja3!P24","v":0},null,null,null,"AMB 100% COTITZACIÓ",{"$f":"A38&\" anys, \"&B38&\" mesos, \"&C38&\" dies\"","v":"5 anys, 0 mesos, 0 dies"},{"$f":"D38&\" anys, \"&E38&\" mesos, \"&F38&\" dies\"","v":"5 anys, 0 mesos, 0 dies"}]
[{"$f":"Hoja3!$C$23","v":"2031-12-04"},null,null,{"$f":"Hoja3!$C$24","v":"2033-12-04"}]

{"sheet":"Hoja4","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["cerrar Excel"]

{"sheet":"Hoja2","index":2,"n_rows":46,"n_cols":32,"rows_kept":46,"cut":false,"hidden":true,"merged":[[15,0,15,3],[0,0,0,1],[0,3,0,4],[0,7,0,9],[0,11,0,12],[14,0,14,3]]}
["EDAT DE JUBILACIÓ GENERAL",null,"ANY","AMB AQUESTS TEMPS COTITZAT",null,null,null,"EDAT DE JUBILACIÓ GENERAL",null,null,"ANY","AMB AQUESTS TEMPS COTITZAT",null,"65 ANYS",null,null,"ANTIGUITAT GUB",null,"JUBILACIÓ 65",null,"JUBILACIÓ 67",null,"JUBILACIÓ 100%",null,null,26,1,{"$f":"DATE(YEAR($S$12),MONTH($S$12),DAY($S$12))-30.4*AA1","v":"2026-11-03T14:24:00"},31,{"$f":"DATE(YEAR($U$12),MONTH($U$12),DAY($U$12)-30.4*AA1)","v":"2028-11-03"},31,{"$f":"DATE(YEAR($W$12),MONTH($W$12),DAY($W$12)-30.4*AA1)","v":"2037-06-09"}]
[65,5,2017,36,3,null,{"$f":"DATE(H2,I2,J2)","v":"2032-05-04"},{"$f":"$I$15+A2","v":2031},{"$f":"$J$15+B2","v":17},{"$f":"$K$15","v":4},2017,36,3,{"$f":"DATE(YEAR($E$15)+65,MONTH($E$15),DAY($E$15))","v":"2031-12-04"},{"$f":"DATE(YEAR(N2)-L2,MONTH(N2)-M2,DAY(N2))","v":"1995-09-04"},null,15,null,{"$f":"DATE(YEAR($E$20)-3,MONTH($E$20),DAY($E$20))","v":"2028-12-04"},18,{"$f":"DATE(YEAR($E$33)-3,MONTH($E$33),DAY($E$33))","v":"2030-12-04"},null,{"$f":"DATE(YEAR($E$42)-3,MONTH($E$42),DAY($E$42))","v":"2039-07-10"},null,null,27,2,{"$f":"DATE(YEAR($S$12),MONTH($S$12),DAY($S$12))-30.4*AA2","v":"2026-10-04T04:48:00"},32,{"$f":"DATE(YEAR($U$12),MONTH($U$12),DAY($U$12)-30.4*AA2)","v":"2028-10-04"},32,{"$f":"DATE(YEAR($W$12),MONTH($W$12),DAY($W$12)-30.4*AA2)","v":"2037-05-10"}]
[65,6,2018,36,6,null,{"$f":"DATE(H3,I3,J3)","v":"2032-06-04"},2031,{"$f":"$J$15+B3","v":18},4,2018,36,6,"2031-12-04",{"$f":"DATE(YEAR(N3)-L3,MONTH(N3)-M3,DAY(N3))","v":"1995-06-04"},null,16,null,{"$f":"DATE(YEAR($E$20),MONTH($E$20),DAY($E$20)-73.05*Q3)","v":"2028-09-21"},19.2,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q3)","v":"2030-09-22"},null,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q3)","v":"2039-04-28"},null,null,28,3,"2026-09-03T19:12:00",33,"2028-09-03",33,"2037-04-09"]
[65,8,2019,36,9,null,"2032-08-04",2031,20,4,2019,36,9,"2031-12-04","1995-03-04",null,17,null,"2028-07-10",20.399999999999999,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q4)","v":"2030-07-11"},22,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q4)","v":"2039-02-14"},null,null,29,4,"2026-08-04T09:36:00",34,"2028-08-04",34,"2037-03-10"]
[65,10,2020,37,0,null,"2032-10-04",2031,22,4,2020,37,0,"2031-12-04","1994-12-04",null,18,null,"2028-04-28",21.6,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q5)","v":"2030-04-29"},23,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q5)","v":"2038-12-03"},null,null,30,5,"2026-07-05",35,"2028-07-05",35,"2037-02-08"]
[66,0,2021,37,3,null,"2032-12-04",2032,12,4,2021,37,3,"2031-12-04","1994-09-04",null,19,null,"2028-02-15",22.8,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q6)","v":"2030-02-15"},24,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q6)","v":"2038-09-21"},null,null,31,6,"2026-06-04T14:24:00",36,"2028-06-04",36,"2037-01-08"]
[66,2,2022,37,6,null,"2033-02-04",2032,14,4,2022,37,6,"2031-12-04","1994-06-04",null,20,null,{"$f":"DATE(YEAR($E$20)-4,MONTH($E$20),DAY($E$20))","v":"2027-12-04"},24,{"$f":"DATE(YEAR($E$33)-4,MONTH($E$33),DAY($E$33))","v":"2029-12-04"},25,{"$f":"DATE(YEAR($E$42)-4,MONTH($E$42),DAY($E$42))","v":"2038-07-10"},null,null,32,7,"2026-05-05T04:48:00",37,"2028-05-05",37,"2036-12-09"]
[66,4,2023,37,9,null,"2033-04-04",2032,16,4,2023,37,9,"2031-12-04","1994-03-04",null,21,null,"2027-09-21",25.2,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q8)","v":"2029-09-21"},26,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q8)","v":"2038-04-27"},null,null,33,8,"2026-04-04T19:12:00",38,"2028-04-04",38,"2036-11-08"]
[66,6,2024,38,0,null,"2033-06-04",2032,18,4,2024,38,0,"2031-12-04","1993-12-04",null,22,null,"2027-07-10",26.4,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q9)","v":"2029-07-10"},27,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q9)","v":"2038-02-13"},null,null,34,9,"2026-03-05T09:36:00",39,"2028-03-05",39,"2036-10-09"]
[66,8,2025,38,3,null,"2033-08-04",2032,20,4,2025,38,3,"2031-12-04","1993-09-04",null,23,null,"2027-04-28",27.6,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q10)","v":"2029-04-28"},28,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q10)","v":"2037-12-02"},null,null,35,10,"2026-02-03",40,"2028-02-04",40,"2036-09-09"]
[66,10,2026,38,3,null,"2033-10-04",2032,22,4,2026,38,3,"2031-12-04","1993-09-04",null,24,null,"2027-02-14",28.4,{"$f":"DATE(YEAR($E$33),MONTH($E$33),DAY($E$33)-73.05*Q11)","v":"2029-02-14"},29,{"$f":"DATE(YEAR($E$42),MONTH($E$42),DAY($E$42)-73.05*Q11)","v":"2037-09-20"},null,null,36,11,"2026-01-03T14:24:00",41,"2028-01-04",41,"2036-08-09"]
[67,0,{"$f":"IF(GESTEP(YEAR(E31),2027),2027,\"IGUAL O MAYOR 2027\")","v":2027},38,6,null,"2033-12-04",2033,12,4,{"$f":"IF(GESTEP(I19,2027),2027,\"IGUAL O MAYOR 2027\")","v":2027},38,6,"2031-12-04","1993-06-04",null,25,null,{"$f":"DATE(YEAR($E$20)-5,MONTH($E$20),DAY($E$20))","v":"2026-12-04"},30,{"$f":"DATE(YEAR($E$33)-5,MONTH($E$33),DAY($E$33))","v":"2028-12-04"},30,{"$f":"DATE(YEAR($E$42)-5,MONTH($E$42),DAY($E$42))","v":"2037-07-10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,1,{"$f":"DATE(YEAR($E$20)-5,MONTH($E$20),DAY($E$20))","v":"2026-12-04"},31,"2028-12-04",31,"2037-07-10"]
[null,null,null,null,null,null,null,null,"ANY","MES","DIA",null,null,null,null,null,27,2,{"$f":"DATE(YEAR($E$20)-5,MONTH($E$20),DAY($E$20))","v":"2026-12-04"},32,"2028-12-04",32,"2037-07-10"]
["DATA DE NAIXEMENT",null,null,null,{"$f":"Hoja1!$A$9","v":"1966-12-04"},null,null,null,{"$f":"YEAR($E$15)","v":1966},{"$f":"MONTH($E$15)","v":12},{"$f":"DAY($E$15)","v":4},null,"1966-12-04","1964-07-04","1963-08-28",null,28,3,"2026-12-04",33,"2028-12-04",33,"2037-07-10"]
["ANTIGUITAT GUB",null,null,null,{"$f":"Hoja1!$D$9","v":"2004-01-10"},null,null,null,{"$f":"YEAR($E$16)","v":2004},{"$f":"MONTH($E$16)","v":1},{"$f":"DAY($E$16)","v":10},null,"1989-01-10","1992-10-13","1986-12-12",null,29,4,"2026-12-04",34,"2028-12-04",34,"2037-07-10"]
["TEMPS COTITZAT FORA DE GUB",null,null,null,{"$f":"DATE(YEAR($E$16)-$F$17,MONTH($E$16)-$G$17,DAY($E$16)-$H$17)","v":"2004-01-10"},{"$f":"Hoja1!G9","v":0},{"$f":"Hoja1!H9","v":0},{"$f":"Hoja1!I9","v":0},{"$f":"YEAR($E$17)","v":2004},{"$f":"MONTH($E$17)","v":1},{"$f":"DAY($E$17)","v":10},null,null,null,null,null,30,5,"2026-12-04",35,"2028-12-04",35,"2037-07-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,6,"2026-12-04",36,"2028-12-04",36,"2037-07-10"]
["DATA JUBILACIÓ ALS 65",null,null,null,{"$f":"DATE(YEAR(E15)+65,MONTH(E15),DAY(E15))","v":"2031-12-04"},{"$f":"DATEDIF(E15,E19,\"Y\")","v":65},{"$f":"DATEDIF(E15,E19,\"YM\")","v":0},{"$f":"DATEDIF(E15,E19,\"MD\")","v":0},{"$f":"YEAR(E19)","v":2031},{"$f":"MONTH(E19)","v":12},{"$f":"DAY(E19)","v":4},null,null,null,null,null,32,7,"2026-12-04",37,"2028-12-04",37,"2037-07-10"]
["COTITZACIÓ GUB ALS 65",null,null,null,{"$f":"DATE(YEAR(E15)+65,MONTH(E15),DAY(E15))","v":"2031-12-04"},{"$f":"DATEDIF(E16,E20,\"Y\")","v":27},{"$f":"DATEDIF(E16,E20,\"YM\")","v":10},{"$f":"DATEDIF(E16,E20,\"MD\")","v":24},null,null,null,null,null,null,null,null,33,8,"2026-12-04",38,"2028-12-04",38,"2037-07-10"]
["COTITZACIÓ TOTAL ALS 65",null,null,null,{"$f":"DATE(YEAR(E15)+65,MONTH(E15),DAY(E15))","v":"2031-12-04"},{"$f":"DATEDIF(E17,E21,\"Y\")","v":27},{"$f":"DATEDIF(E17,E21,\"YM\")","v":10},{"$f":"DATEDIF(E17,E21,\"MD\")","v":24},null,null,null,null,null,null,null,null,34,9,"2026-12-04",39,"2028-12-04",39,"2037-07-10"]
["JUBILACIÓ ANTICIPADA FINS A 5 ANYS",null,null,null,{"$f":"LOOKUP(F20+(G20/12)+(H20/365),T2:T25,S2:S25)","v":"2027-04-28"},{"$f":"DATEDIF(E15,E22,\"Y\")","v":60},{"$f":"DATEDIF(E15,E22,\"YM\")","v":4},{"$f":"DATEDIF(E15,E22,\"MD\")","v":24},{"$f":"DATEDIF(E22,E19,\"Y\")","v":4},{"$f":"DATEDIF(E22,E19,\"YM\")","v":7},{"$f":"DATEDIF(E22,E19,\"MD\")","v":6},null,null,null,null,null,35,10,"2026-12-04",40,"2028-12-04",40,"2037-07-10"]
["COTITZAT EFECTIU GUB",null,null,null,null,{"$f":"DATEDIF(E16,E22,\"Y\")","v":23},{"$f":"DATEDIF(E16,E22,\"YM\")","v":3},{"$f":"DATEDIF(E16,E22,\"MD\")","v":18},null,null,null,{"$f":"F23+G23/12","v":23.25},null,{"$f":"Q25-L23","v":13.25},null,null,36,11,"2026-12-04",41,"2028-12-04",41,"2037-07-10"]
[null,null,null,null,{"$f":"IF(N23<=0,IF(N23<=-1,S25,E26),S24)","v":"2026-12-04"},{"$f":"DATEDIF(E15,E24,\"Y\")","v":60},{"$f":"DATEDIF(E15,E24,\"YM\")","v":0},{"$f":"DATEDIF(E15,E24,\"MD\")","v":0},{"$f":"DATEDIF(E24,E19,\"Y\")","v":5},{"$f":"DATEDIF(E24,E19,\"YM\")","v":0},{"$f":"DATEDIF(E24,E19,\"MD\")","v":0},null,null,null,null,null,37,12,{"$f":"DATE(YEAR($S$12),MONTH($S$12),DAY($S$12))","v":"2026-12-04"},42,{"$f":"DATE(YEAR($U$12),MONTH($U$12),DAY($U$12))","v":"2028-12-04"},42,{"$f":"DATE(YEAR($W$12),MONTH($W$12),DAY($W$12))","v":"2037-07-10"}]
[null,null,null,null,null,{"$f":"DATEDIF(E16,E24,\"Y\")","v":22},{"$f":"DATEDIF(E16,E24,\"YM\")","v":10},{"$f":"DATEDIF(E16,E24,\"MD\")","v":24},null,null,null,null,null,null,null,null,{"$f":"IF(OR(YEAR(S25)<2018,YEAR(S25)=2018,YEAR(S25)=2019),\"35,5\",IF(OR(YEAR(S25)=2020,YEAR(S25)=2021,YEAR(S25)=2022),\"36\",IF(OR(YEAR(S25)=2023,YEAR(S25)=2024,YEAR(S25)=2025,YEAR(S25)=2026),\"36,5\",\"37\")))","v":"36,5"},12,{"$f":"DATE(YEAR($S$12)-1,MONTH($S$12),DAY($S$12))","v":"2025-12-04"},43,{"$f":"DATE(YEAR($U$12)-1,MONTH($U$12),DAY($U$12))","v":"2027-12-04"},42,{"$f":"DATE(YEAR($W$12)-1,MONTH($W$12),DAY($W$12))","v":"2036-07-10"}]
[null,null,null,null,{"$f":"DATE(YEAR(E16)+F26,MONTH(E16)+G26,DAY(E16))","v":"2040-07-10"},{"$f":"INT(Q25)","v":36},{"$f":"12*(Q25-INT(Q25))","v":6},0,{"$f":"F26+G26/12","v":36.5}]
["ANTIGUITAT MINIMA PELS 65 DES DEL",null,null,null,{"$f":"LOOKUP($I$19,$K$2:$K$12,$O$2:$O$12)","v":"1993-06-04"},null,null,null,{"$f":"LOOKUP($I$19,$K$2:$K$12,$L$2:$L$12)","v":38},{"$f":"LOOKUP($I$19,$K$2:$K$12,$M$2:$M$12)","v":6},0]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(DATEDIF(E27,E17,\"Y\"),0)","v":10},{"$f":"IFERROR(DATEDIF(E27,E17,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(E27,E17,\"MD\"),0)","v":6}]
["FALTA PER COTITZAR",null,null,null,null,null,null,null,{"$f":"IF($I$28<=0,0,$I$28)","v":10},{"$f":"IF(AND($I$28<=0,$J$28<=0),0,$J$28)","v":7},{"$f":"IF(AND($I$28<=0,$J$28<=0,$K$28<=0),0,$K$28)","v":6}]
[]
["DATA JUBILACIÓ, TEMPS COTITZAT, EDAT",null,null,null,{"$f":"DATE(YEAR($E$19)+$I$29,MONTH($E$19)+$J$29,DAY($E$19)+$K$29)","v":"2042-07-10"},{"$f":"DATEDIF(E17,E31,\"Y\")","v":38},{"$f":"DATEDIF(E17,E31,\"YM\")","v":6},{"$f":"DATEDIF(E17,E31,\"MD\")","v":0},{"$f":"DATEDIF(E15,E31,\"Y\")","v":75},{"$f":"DATEDIF(E15,E31,\"YM\")","v":7},{"$f":"DATEDIF(E15,E31,\"MD\")","v":6}]
[]
["DATA JUBILACIÓ, TEMPS COTITZAT, EDAT",null,null,null,{"$f":"DATE(YEAR($E$15)+I33,MONTH($E$15)+J33,DAY($E$15))","v":"2033-12-04"},{"$f":"DATEDIF(E17,E33,\"Y\")","v":29},{"$f":"DATEDIF(E17,E33,\"YM\")","v":10},{"$f":"DATEDIF(E17,E33,\"MD\")","v":24},{"$f":"LOOKUP(YEAR(E31),C2:C12,A2:A12)","v":67},{"$f":"LOOKUP(YEAR(E31),C2:C12,B2:B12)","v":0},0]
["DATA JUBILACIÓ,COTITZAT GUB ALS",null,null,null,{"$f":"$E$33","v":"2033-12-04"},{"$f":"DATEDIF(E16,E33,\"Y\")","v":29},{"$f":"DATEDIF(E16,E33,\"YM\")","v":10},{"$f":"DATEDIF(E16,E33,\"MD\")","v":24}]
["DATA JUBILACIÓ, COTITZAT TOTAL ALS , MINIM",null,null,null,{"$f":"$E$33","v":"2033-12-04"},{"$f":"DATEDIF(E17,E33,\"Y\")","v":29},{"$f":"DATEDIF(E17,E33,\"YM\")","v":10},{"$f":"DATEDIF(E17,E33,\"MD\")","v":24},{"$f":"LOOKUP(YEAR(E33),K2:K12,L2:L12)","v":38},{"$f":"LOOKUP(YEAR(E33),K2:K12,M2:M12)","v":6},0]
["JUBILACIÓ ANTICIPADA",null,null,null,{"$f":"LOOKUP(F34+(G34/12)+(H34/365),T2:T25,U2:U25)","v":"2029-02-14"},{"$f":"DATEDIF(E15,E36,\"Y\")","v":62},{"$f":"DATEDIF(E15,E36,\"YM\")","v":2},{"$f":"DATEDIF(E15,E36,\"MD\")","v":10},{"$f":"DATEDIF(E36,E33,\"Y\")","v":4},{"$f":"DATEDIF(E36,E33,\"YM\")","v":9},{"$f":"DATEDIF(E36,E33,\"MD\")","v":20}]
["COTITZAT EFECTIU GUB",null,null,null,null,{"$f":"DATEDIF(E16,E36,\"Y\")","v":25},{"$f":"DATEDIF(E16,E36,\"YM\")","v":1},{"$f":"DATEDIF(E16,E36,\"MD\")","v":4}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(DATEDIF(E17,E33,\"Y\"),0)","v":29},{"$f":"IFERROR(DATEDIF(E17,E33,\"YM\"),0)","v":10},{"$f":"IFERROR(DATEDIF(E17,E33,\"MD\"),0)","v":24}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(DATEDIF(I38,I27,\"Y\"),0)","v":0},{"$f":"IFERROR(DATEDIF(I38,I27,\"YM\"),0)","v":0},{"$f":"IFERROR(DATEDIF(I38,I27,\"MD\"),0)","v":9}]
["FALTA PER COTITZAR",null,null,null,null,null,null,null,{"$f":"IF($I$39<=0,0,$I$39)","v":0},{"$f":"IF(AND($I$39<=0,$J$39<=0),0,$J$39)","v":0},{"$f":"IF(AND($I$39<=0,$J$39<=0,$K$39<=0),0,$K$39)","v":9}]
[]
["DATA JUBILACIÓ 100%, TEMPS COTITZAT, EDAT",null,null,null,{"$f":"IF(DATE(YEAR($E$17)+F42,MONTH($E$17)+G42,DAY($E$17))<E19,E19,DATE(YEAR($E$17)+F42,MONTH($E$17)+G42,DAY($E$17)))","v":"2042-07-10"},{"$f":"LOOKUP(YEAR($E$31),$K$2:$K$12,$L$2:$L$12)","v":38},{"$f":"LOOKUP(YEAR($E$31),$K$2:$K$12,$M$2:$M$12)","v":6},0,{"$f":"DATEDIF(E15,E42,\"Y\")","v":75},{"$f":"DATEDIF(E15,E42,\"YM\")","v":7},{"$f":"DATEDIF(E15,E42,\"MD\")","v":6}]
["COTITZACIÓ TOTAL",null,null,null,null,{"$f":"DATEDIF(E17,E42,\"Y\")","v":38},{"$f":"DATEDIF(E17,E42,\"YM\")","v":6},{"$f":"DATEDIF(E17,E42,\"MD\")","v":0}]
["COTITZACIÓ GUB",null,null,null,null,{"$f":"DATEDIF(E16,E42,\"Y\")","v":38},{"$f":"DATEDIF(E16,E42,\"YM\")","v":6},{"$f":"DATEDIF(E16,E42,\"MD\")","v":0}]
["JUBILACIÓ ANTICIPADA 100%",null,null,null,{"$f":"LOOKUP(F44,T2:T25,W2:W25)","v":"2037-07-10"},null,null,null,{"$f":"DATEDIF(E15,E45,\"Y\")","v":70},{"$f":"DATEDIF(E15,E45,\"YM\")","v":7},{"$f":"DATEDIF(E15,E45,\"MD\")","v":6}]
["COTITZAT EFECTIU GUB",null,null,null,null,{"$f":"DATEDIF(E16,E45,\"Y\")","v":33},{"$f":"DATEDIF(E16,E45,\"YM\")","v":6},{"$f":"DATEDIF(E16,E45,\"MD\")","v":0}]

{"sheet":"Hoja3","index":3,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,22,0,23],[0,10,0,12],[0,13,0,15],[0,7,0,9],[32,0,32,1],[30,0,30,1],[16,7,16,9],[16,4,16,6],[0,3,0,5],[0,18,0,19],[31,3,31,5],[31,6,31,8],[31,9,31,11],[38,0,38,1],[39,0,39,1],[37,0,37,1],[33,0,33,1],[35,0,35,1]]}
[null,"any naixement","any antiguitat total","temps cotitzat fora de GUB",null,null,"jubilació","edat",null,null,"cotitzat total",null,null,"falta cotizar",null,null,null,null,"EDAT DE JUBILACIÓ GENERAL",null,"ANY","ANY","AMB AQUESTS TEMPS COTITZAT"]
["65 ANYS",{"$f":"Hoja1!$A$9","v":"1966-12-04"},{"$f":"DATE(YEAR($B$7)-$D$2,MONTH($B$7)-$E$2,DAY($B$7)-$F$2)","v":"2004-01-10"},{"$f":"Hoja1!G9","v":0},{"$f":"Hoja1!H9","v":0},{"$f":"Hoja1!I9","v":0},{"$f":"DATE(YEAR($B$2)+65,MONTH($B$2),DAY($B$2))","v":"2031-12-04"},{"$f":"DATEDIF($B$2,$G$2,\"Y\")","v":65},{"$f":"DATEDIF($B$2,$G$2,\"YM\")","v":0},{"$f":"DATEDIF($B$2,$G$2,\"MD\")","v":0},{"$f":"DATEDIF($C$2,$G$2,\"Y\")","v":27},{"$f":"DATEDIF($C$2,$G$2,\"YM\")","v":10},{"$f":"DATEDIF($C$2,$G$2,\"MD\")","v":24},{"$f":"IFERROR(DATEDIF(G2,G5,\"Y\"),0)","v":10},{"$f":"IFERROR(DATEDIF(G2,G5,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(G2,G5,\"MD\"),0)","v":6},null,{"$f":"DATE(YEAR($B$2)+S2,MONTH($B$2)+T2,DAY($B$2))","v":"2032-05-04"},65,5,2017,2017,36,3,{"$f":"DATE(YEAR($G$2)-W2,MONTH($G$2)-X2,DAY($G$2))","v":"1995-09-04"}]
["tope jubil",null,null,null,null,null,{"$f":"DATE(YEAR(B2)+LOOKUP(YEAR(G2),U2:U12,S2:S12), MONTH(B2)+LOOKUP(YEAR(G2),U2:U12,T2:T12),DAY(G2))","v":"2033-12-04"},{"$f":"DATEDIF($B$2,$G$3,\"Y\")","v":67},{"$f":"DATEDIF($B$2,$G$3,\"YM\")","v":0},{"$f":"DATEDIF($B$2,$G$3,\"MD\")","v":0},{"$f":"DATEDIF($C$2,$G$3,\"Y\")","v":29},{"$f":"DATEDIF($C$2,$G$3,\"YM\")","v":10},{"$f":"DATEDIF($C$2,$G$3,\"MD\")","v":24},{"$f":"IFERROR(DATEDIF(G3,G6,\"Y\"),0)","v":8},{"$f":"IFERROR(DATEDIF(G3,G6,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(G3,G6,\"MD\"),0)","v":6},null,{"$f":"DATE(YEAR($B$2)+S3,MONTH($B$2)+T3,DAY($B$2))","v":"2032-06-04"},65,6,2018,2018,36,6,{"$f":"DATE(YEAR($G$2)-W3,MONTH($G$2)-X3,DAY($G$2))","v":"1995-06-04"}]
["tope edat",null,{"$f":"LOOKUP(YEAR(G4),U2:U12,Y2:Y12)","v":"1993-06-04"},null,null,null,{"$f":"LOOKUP(YEAR(G3),V2:V12,R2:R12)","v":"2033-12-04"},{"$f":"DATEDIF($B$2,$G$4,\"Y\")","v":67},{"$f":"DATEDIF($B$2,$G$4,\"YM\")","v":0},{"$f":"DATEDIF($B$2,$G$4,\"MD\")","v":0},{"$f":"DATEDIF($C$2,$G$4,\"Y\")","v":29},{"$f":"DATEDIF($C$2,$G$4,\"YM\")","v":10},{"$f":"DATEDIF($C$2,$G$4,\"MD\")","v":24},{"$f":"IFERROR(DATEDIF(G4,G6,\"Y\"),0)","v":8},{"$f":"IFERROR(DATEDIF(G4,G6,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(G4,G6,\"MD\"),0)","v":6},null,"2032-08-04",65,8,2019,2019,36,9,"1995-03-04"]
["cotització sencera ALS 65",null,{"$f":"LOOKUP(YEAR(G2),U2:U12,Y2:Y12)","v":"1993-06-04"},{"$f":"LOOKUP(YEAR(G2),U2:U12,W2:W12)","v":38},{"$f":"LOOKUP(YEAR(G2),U2:U12,X2:X12)","v":6},0,{"$f":"DATE(YEAR($C$2)+K5,MONTH($C$2)+L5,DAY($C$2)+M5)","v":"2042-07-10"},{"$f":"DATEDIF($B$2,$G$5,\"Y\")","v":75},{"$f":"DATEDIF($B$2,$G$5,\"YM\")","v":7},{"$f":"DATEDIF($B$2,$G$5,\"MD\")","v":6},{"$f":"DATEDIF($C$5,$G$2,\"Y\")","v":38},{"$f":"DATEDIF($C$5,$G$2,\"YM\")","v":6},{"$f":"DATEDIF($C$5,$G$2,\"MD\")","v":0},0,0,0,null,"2032-10-04",65,10,2020,2020,37,0,"1994-12-04"]
["cotització sencera AL TOPE DE EDAT",null,null,{"$f":"LOOKUP(YEAR(G4),U2:U12,W2:W12)","v":38},{"$f":"LOOKUP(YEAR(G4),U2:U12,X2:X12)","v":6},0,{"$f":"IF(GESTEP(DATE(YEAR($C$2)+D6,MONTH($C$2)+E6,DAY($C$2)),42736),DATE(YEAR($C$2)+D6,MONTH($C$2)+E6,DAY($C$2)),42736)","v":"2042-07-10"},{"$f":"DATEDIF($B$2,$G$6,\"Y\")","v":75},{"$f":"DATEDIF($B$2,$G$6,\"YM\")","v":7},{"$f":"DATEDIF($B$2,$G$6,\"MD\")","v":6},null,null,null,{"$f":"IF(N2<=0,0,N2)","v":10},{"$f":"IF(AND(N2<=0,O2<=0),0,O2)","v":7},{"$f":"IF(AND(N2<=0,O2<=0,P2<=0),0,P2)","v":6},null,"2032-12-04",66,0,2021,2021,37,3,"1994-09-04"]
["any antiguitat gub",{"$f":"Hoja1!$D$9","v":"2004-01-10"},null,{"$f":"LOOKUP(YEAR(G6),U2:U12,W2:W12)","v":38},{"$f":"LOOKUP(YEAR(G6),U2:U12,X2:X12)","v":6},0,{"$f":"IF(GESTEP(DATE(YEAR($C$2)+D7,MONTH($C$2)+E7,DAY($C$2)),G2),DATE(YEAR($C$2)+D7,MONTH($C$2)+E7,DAY($C$2)),G2)","v":"2042-07-10"},{"$f":"DATEDIF($B$2,$G$7,\"Y\")","v":75},{"$f":"DATEDIF($B$2,$G$7,\"YM\")","v":7},{"$f":"DATEDIF($B$2,$G$7,\"MD\")","v":6},{"$f":"DATEDIF($C$2,$G$7,\"Y\")","v":38},{"$f":"DATEDIF($C$2,$G$7,\"YM\")","v":6},{"$f":"DATEDIF($C$2,$G$7,\"MD\")","v":0},{"$f":"IF(N3<=0,0,N3)","v":8},{"$f":"IF(AND(N3<=0,O3<=0),0,O3)","v":7},{"$f":"IF(AND(N3<=0,O3<=0,P3<=0),0,P3)","v":6},null,"2033-02-04",66,2,2022,2022,37,6,"1994-06-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8,7,6,null,"2033-04-04",66,4,2023,2023,37,9,"1994-03-04"]
[null,null,null,{"$f":"LOOKUP(YEAR(G3),U2:U12,W2:W12)","v":38},{"$f":"LOOKUP(YEAR(G3),U2:U12,X2:X12)","v":6},0,null,null,null,null,null,null,null,null,{"$f":"K18+L18/12","v":23.25},{"$f":"N22-O9","v":13.25},null,"2033-06-04",66,6,2024,2024,38,0,"1993-12-04"]
[{"$f":"DATE(YEAR($C$2)+D7,MONTH($C$2)+E7,DAY($C$2))","v":"2042-07-10"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2033-08-04",66,8,2025,2025,38,3,"1993-09-04"]
[{"$f":"IF(GESTEP(DATE(YEAR($C$2)+D7,MONTH($C$2)+E7,DAY($C$2)),G2),G2,DATE(YEAR($C$2)+D7,MONTH($C$2)+E7,DAY($C$2)))","v":"2031-12-04"},null,null,{"$f":"LOOKUP(YEAR(G11),$U$2:$U$12,$W$2:$W$12)","v":38},{"$f":"LOOKUP(YEAR(G11),$U$2:$U$12,$X$2:$X$12)","v":6},0,{"$f":"A23","v":"2036-12-04"},{"$f":"DATEDIF($B$2,$G$11,\"Y\")","v":70},{"$f":"DATEDIF($B$2,$G$11,\"YM\")","v":0},{"$f":"DATEDIF($B$2,$G$11,\"MD\")","v":0},{"$f":"DATEDIF($C$2,$G$11,\"Y\")","v":32},{"$f":"DATEDIF($C$2,$G$11,\"YM\")","v":10},{"$f":"DATEDIF($C$2,$G$11,\"MD\")","v":24},{"$f":"IFERROR(DATEDIF(G11,G5,\"Y\"),0)","v":5},{"$f":"IFERROR(DATEDIF(G11,G5,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(G11,G5,\"MD\"),0)","v":6},null,"2033-10-04",66,10,2026,2026,38,3,"1993-09-04"]
[{"$f":"IF(GESTEP(DATE(YEAR($C$2)+D6,MONTH($C$2)+E6,DAY($C$2)),1/1/2017),DATE(YEAR($C$2)+D6,MONTH($C$2)+E6,DAY($C$2)),1/1/2017)","v":"2042-07-10"},null,null,{"$f":"LOOKUP(YEAR(G12),$U$2:$U$12,$W$2:$W$12)","v":38},{"$f":"LOOKUP(YEAR(G12),$U$2:$U$12,$X$2:$X$12)","v":6},0,{"$f":"A24","v":"2038-12-04"},{"$f":"DATEDIF($B$2,$G$12,\"Y\")","v":72},{"$f":"DATEDIF($B$2,$G$12,\"YM\")","v":0},{"$f":"DATEDIF($B$2,$G$12,\"MD\")","v":0},{"$f":"DATEDIF($C$2,$G$12,\"Y\")","v":34},{"$f":"DATEDIF($C$2,$G$12,\"YM\")","v":10},{"$f":"DATEDIF($C$2,$G$12,\"MD\")","v":24},{"$f":"IFERROR(DATEDIF(G12,G5,\"Y\"),0)","v":3},{"$f":"IFERROR(DATEDIF(G12,G5,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(G12,G5,\"MD\"),0)","v":6},null,"2033-12-04",67,0,2027,2027,38,6,"1993-06-04"]
[{"$f":"DATE(YEAR($C$2)+D6,MONTH($C$2)+E6,DAY($C$2))","v":"2042-07-10"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N11<=0,0,N11)","v":5},{"$f":"IF(AND(N11<=0,O11<=0),0,O11)","v":7},{"$f":"IF(AND(N11<=0,O11<=0,P11<=0),0,P11)","v":6}]
["2017-01-01",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N12<=0,0,N12)","v":3},{"$f":"IF(AND(N12<=0,O12<=0),0,O12)","v":7},{"$f":"IF(AND(N12<=0,O12<=0,P12<=0),0,P12)","v":6}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANTIGUITAT GUB","JUBILACIÓ 65",null,"JUBILACIÓ 67",null,"JUBILACIÓ 100%"]
[null,"edat sense reducció","jubilacio anticipada",null,"edat",null,null,"cotitzat GUB sense reducció",null,null,"cotitzat GUB amb reducció",null,null,null,null,null,null,{"$f":"U17-S17","v":3},15,{"$f":"DATE(YEAR($G$2)-3,MONTH($G$2),DAY($G$2))","v":"2028-12-04"},18,{"$f":"DATE(YEAR($G$4)-3,MONTH($G$4),DAY($G$4))","v":"2030-12-04"},18,{"$f":"DATE(YEAR($G$7)-3,MONTH($G$7),DAY($G$7))","v":"2039-07-10"}]
["65 ANYS",{"$f":"H2&\" anys, \"&I2&\" mesos, \"&J2&\" dies\"","v":"65 anys, 0 mesos, 0 dies"},{"$f":"LOOKUP(H18+(I18/12)+(J18/365),U17:U40,T17:T40)","v":"2027-04-28"},null,{"$f":"DATEDIF($B$2,$C$18,\"Y\")","v":60},{"$f":"DATEDIF($B$2,$C$18,\"YM\")","v":4},{"$f":"DATEDIF($B$2,$C$18,\"MD\")","v":24},{"$f":"DATEDIF($B$7,$G$2,\"Y\")","v":27},{"$f":"DATEDIF($B$7,$G$2,\"YM\")","v":10},{"$f":"DATEDIF($B$7,$G$2,\"MD\")","v":24},{"$f":"DATEDIF($B$7,$C$18,\"Y\")","v":23},{"$f":"DATEDIF($B$7,$C$18,\"YM\")","v":3},{"$f":"DATEDIF($B$7,$C$18,\"MD\")","v":18},{"$f":"DATEDIF(C18,G2,\"Y\")","v":4},{"$f":"DATEDIF(C18,G2,\"YM\")","v":7},{"$f":"DATEDIF(C18,G2,\"MD\")","v":6},null,{"$f":"U18-S18","v":3.1999999999999993},16,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S18)","v":"2028-09-21"},19.2,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S18)","v":"2030-09-22"},19.2,{"$f":"DATE(YEAR($G$7),MONTH($G$7),DAY($G$7)-73.05*S18)","v":"2039-04-28"}]
["tope edat",{"$f":"H4&\" anys, \"&I4&\" mesos, \"&J4&\" dies\"","v":"67 anys, 0 mesos, 0 dies"},{"$f":"LOOKUP(H19+(I19/12)+(J19/365),U17:U40,V17:V40)","v":"2029-02-14"},null,{"$f":"DATEDIF($B$2,$C$19,\"Y\")","v":62},{"$f":"DATEDIF($B$2,$C$19,\"YM\")","v":2},{"$f":"DATEDIF($B$2,$C$19,\"MD\")","v":10},{"$f":"DATEDIF($B$7,$G$4,\"Y\")","v":29},{"$f":"DATEDIF($B$7,$G$4,\"YM\")","v":10},{"$f":"DATEDIF($B$7,$G$4,\"MD\")","v":24},{"$f":"DATEDIF($B$7,$C$19,\"Y\")","v":25},{"$f":"DATEDIF($B$7,$C$19,\"YM\")","v":1},{"$f":"DATEDIF($B$7,$C$19,\"MD\")","v":4},{"$f":"DATEDIF(C19,G4,\"Y\")","v":4},{"$f":"DATEDIF(C19,G4,\"YM\")","v":9},{"$f":"DATEDIF(C19,G4,\"MD\")","v":20},null,3.3999999999999986,17,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S19)","v":"2028-07-10"},20.399999999999999,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S19)","v":"2030-07-11"},20.399999999999999,{"$f":"DATE(YEAR($G$7),MONTH($G$7),DAY($G$7)-73.05*S19)","v":"2039-02-14"}]
["cotització sencera",{"$f":"H7&\" anys, \"&I7&\" mesos, \"&J7&\" dies\"","v":"75 anys, 7 mesos, 6 dies"},{"$f":"IF(GESTEP(LOOKUP(H18+(I18/12)+(J18/365),U17:U40,T17:T40),LOOKUP(H20+(I20/12)+(J20/365),W17:W40,X17:X40)),LOOKUP(H18+(I18/12)+(J18/365),U17:U40,T17:T40),LOOKUP(H20+(I20/12)+(J20/365),W17:W40,X17:X40))","v":"2037-07-10"},null,{"$f":"DATEDIF($B$2,$C$20,\"Y\")","v":70},{"$f":"DATEDIF($B$2,$C$20,\"YM\")","v":7},{"$f":"DATEDIF($B$2,$C$20,\"MD\")","v":6},{"$f":"DATEDIF($B$7,$G$7,\"Y\")","v":38},{"$f":"DATEDIF($B$7,$G$7,\"YM\")","v":6},{"$f":"DATEDIF($B$7,$G$7,\"MD\")","v":0},{"$f":"DATEDIF($B$7,$C$20,\"Y\")","v":33},{"$f":"DATEDIF($B$7,$C$20,\"YM\")","v":6},{"$f":"DATEDIF($B$7,$C$20,\"MD\")","v":0},{"$f":"DATEDIF(C20,G7,\"Y\")","v":5},{"$f":"DATEDIF(C20,G7,\"YM\")","v":0},{"$f":"DATEDIF(C20,G7,\"MD\")","v":0},null,3.6000000000000014,18,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S20)","v":"2028-04-28"},21.6,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S20)","v":"2030-04-29"},21.6,"2038-12-03"]
[null,"59 o 60",{"$f":"IF(P9<=0,IF(P9<=-1,T38,C22),C18)","v":"2027-04-28"},{"$f":"IF(P9<=0,IF(P9<=-1,\"T38\",\"C16\"),\"C18\")","v":"C18"},{"$f":"DATEDIF($B$2,$C$21,\"Y\")","v":60},{"$f":"DATEDIF($B$2,$C$21,\"YM\")","v":4},{"$f":"DATEDIF($B$2,$C$21,\"MD\")","v":24},null,null,null,{"$f":"DATEDIF($B$7,$C$21,\"Y\")","v":23},{"$f":"DATEDIF($B$7,$C$21,\"YM\")","v":3},{"$f":"DATEDIF($B$7,$C$21,\"MD\")","v":18},{"$f":"DATEDIF(C21,G2,\"Y\")","v":4},{"$f":"DATEDIF(C21,G2,\"YM\")","v":7},{"$f":"DATEDIF(C21,G2,\"MD\")","v":6},null,3.8000000000000007,19,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S21)","v":"2028-02-15"},22.8,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S21)","v":"2030-02-15"},22.8,"2038-09-21"]
[null,"entre 59 i 60",{"$f":"DATE(YEAR($B$7)+K22,MONTH($B$7)+L22,DAY($B$7))","v":"2040-07-10"},null,{"$f":"DATEDIF($B$2,$C$22,\"Y\")","v":73},{"$f":"DATEDIF($B$2,$C$22,\"YM\")","v":7},{"$f":"DATEDIF($B$2,$C$22,\"MD\")","v":6},null,null,null,{"$f":"INT(S38)","v":36},{"$f":"12*(S38-INT(S38))","v":6},0,{"$f":"K22+L22/12","v":36.5},null,null,null,4,20,{"$f":"DATE(YEAR($G$2)-4,MONTH($G$2),DAY($G$2))","v":"2027-12-04"},24,{"$f":"DATE(YEAR($G$4)-4,MONTH($G$4),DAY($G$4))","v":"2029-12-04"},24,{"$f":"DATE(YEAR($G$7)-4,MONTH($G$7),DAY($G$7))","v":"2038-07-10"}]
[{"$f":"DATE(YEAR(C23)+H23-K23,MONTH(C23)+I23-L23,DAY(C23)+J23-M23)","v":"2036-12-04"},null,{"$f":"$G$2","v":"2031-12-04"},null,{"$f":"H2","v":65},0,0,{"$f":"INT(((K23+L23/12+M23/365.25)+(LOOKUP(INT(K23+L23/12+M23/365.25),$S$17:$S$40,$R$17:$R$40))))","v":32},{"$f":"INT((((K23+L23/12+M23/365.25)+(LOOKUP(INT(K23+L23/12+M23/365.25),$S$17:$S$40,$R$17:$R$40)))-H23)*12)","v":10},{"$f":"INT((((((K23+L23/12+M23/365.25)+(LOOKUP(INT(K23+L23/12+M23/365.25),$S$17:$S$40,$R$17:$R$40)))-H23)*12)-I23)*30.44)","v":24},{"$f":"DATEDIF($B$7,C23,\"Y\")","v":27},{"$f":"DATEDIF($B$7,C23,\"YM\")","v":10},{"$f":"DATEDIF($B$7,C23,\"MD\")","v":24},{"$f":"DATEDIF(C23,A23,\"Y\")","v":5},{"$f":"DATEDIF(C23,A23,\"YM\")","v":0},{"$f":"DATEDIF(C23,A23,\"MD\")","v":0},null,4.1999999999999993,21,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S23)","v":"2027-09-21"},25.2,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S23)","v":"2029-09-21"},25.2,{"$f":"DATE(YEAR($G$7),MONTH($G$7),DAY($G$7)-73.05*S23)","v":"2038-04-27"}]
[{"$f":"DATE(YEAR(C24)+H24-K24,MONTH(C24)+I24-L24,DAY(C24)+J24-M24)","v":"2038-12-04"},null,{"$f":"$G$3","v":"2033-12-04"},null,67,0,0,{"$f":"INT(((K24+L24/12+M24/365.25)+(LOOKUP(INT(K24+L24/12+M24/365.25),$S$17:$S$40,$R$17:$R$40))))","v":34},{"$f":"INT((((K24+L24/12+M24/365.25)+(LOOKUP(INT(K24+L24/12+M24/365.25),$S$17:$S$40,$R$17:$R$40)))-H24)*12)","v":10},{"$f":"INT((((((K24+L24/12+M24/365.25)+(LOOKUP(INT(K24+L24/12+M24/365.25),$S$17:$S$40,$R$17:$R$40)))-H24)*12)-I24)*30.44)","v":24},{"$f":"DATEDIF($B$7,C24,\"Y\")","v":29},{"$f":"DATEDIF($B$7,C24,\"YM\")","v":10},{"$f":"DATEDIF($B$7,C24,\"MD\")","v":24},{"$f":"DATEDIF(C24,A24,\"Y\")","v":5},{"$f":"DATEDIF(C24,A24,\"YM\")","v":0},{"$f":"DATEDIF(C24,A24,\"MD\")","v":0},null,4.3999999999999986,22,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S24)","v":"2027-07-10"},26.4,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S24)","v":"2029-07-10"},26.4,{"$f":"DATE(YEAR($G$7),MONTH($G$7),DAY($G$7)-73.05*S24)","v":"2038-02-13"}]
[null,null,null,null,null,null,null,{"$f":"(K21+(L21/12)+(M21/365))+(((K21+(L21/12)+(M21/365))/100*20))","v":27.95917808219178},{"$f":"H25*365.25","v":10212.089794520547},null,{"$f":"K21+(L21/12)+(M21/365)","v":23.299315068493151},{"$f":"K25*365.25","v":8510.0748287671231},null,null,null,null,null,4.6000000000000014,23,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S25)","v":"2027-04-28"},27.6,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S25)","v":"2029-04-28"},27.6,"2037-12-02"]
[null,null,{"$f":"LOOKUP(H18+(I18/12)+(J18/365),U17:U40,T17:T40)","v":"2027-04-28"},{"$f":"DATE(YEAR(E26)+N26,MONTH(E26)+O26,DAY(E26)+P26)","v":"2031-12-04"},{"$f":"LOOKUP(H25,U17:U40,T17:T40)","v":"2027-04-28"},null,null,{"$f":"INT(I25/365.25)","v":27},{"$f":"INT((I25-(H26*365.25))/30.4)","v":11},{"$f":"I25-(H26*365.25)-(I26*30.4)","v":15.939794520547025},{"$f":"INT(L25/365.25)","v":23},{"$f":"INT((L25-(K26*365.25))/30.4)","v":3},{"$f":"L25-(K26*365.25)-L26*30.4","v":18.12482876712312},{"$f":"DATEDIF(E26,G2,\"Y\")","v":4},{"$f":"DATEDIF(E26,G2,\"YM\")","v":7},{"$f":"DATEDIF(E26,G2,\"MD\")","v":6},null,4.3999999999999986,24,{"$f":"DATE(YEAR($G$2),MONTH($G$2),DAY($G$2)-73.05*S26)","v":"2027-02-14"},28.4,{"$f":"DATE(YEAR($G$4),MONTH($G$4),DAY($G$4)-73.05*S26)","v":"2029-02-14"},28.4,"2037-09-20"]
[null,null,{"$f":"LOOKUP(H20+(I20/12)+(J20/365),W17:W40,X17:X40)","v":"2037-07-10"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,25,{"$f":"DATE(YEAR($G$2)-5,MONTH($G$2),DAY($G$2))","v":"2026-12-04"},30,{"$f":"DATE(YEAR($G$4)-5,MONTH($G$4),DAY($G$4))","v":"2028-12-04"},30,{"$f":"DATE(YEAR($G$7)-5,MONTH($G$7),DAY($G$7))","v":"2037-07-10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,26,{"$f":"DATE(YEAR($G$2)-5,MONTH($G$2),DAY($G$2))","v":"2026-12-04"},31,{"$f":"DATE(YEAR($G$4)-5,MONTH($G$4),DAY($G$4))","v":"2028-12-04"},31,{"$f":"DATE(YEAR($G$7)-5,MONTH($G$7),DAY($G$7))","v":"2037-07-10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,27,"2026-12-04",32,"2028-12-04",32,"2037-07-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,28,"2026-12-04",33,"2028-12-04",33,"2037-07-10"]
["compleix cotització ordinaria per 65",null,{"$f":"AND(N6=0,O6=0,P6=0)","v":false},null,null,null,null,null,null,null,null,null,null,null," ",null,null,5,29,"2026-12-04",34,"2028-12-04",34,"2037-07-10"]
[null,null,"DATA","COTITZACIÓ GUB",null,null,"EDAT",null,null,"FALTAN",null,null,null,null,null,null,null,5,30,"2026-12-04",35,"2028-12-04",35,"2037-07-10"]
["jubilacion ordinaria",null,{"$f":"G2","v":"2031-12-04"},{"$f":"H18","v":27},{"$f":"I18","v":10},{"$f":"J18","v":24},{"$f":"H2","v":65},0,0,{"$f":"N6","v":10},{"$f":"O6","v":7},{"$f":"P6","v":6},null,null,null,null,null,5,31,"2026-12-04",36,"2028-12-04",36,"2037-07-10"]
["jubilacion anticipada GUB",null,{"$f":"$C$21","v":"2027-04-28"},{"$f":"K21","v":23},{"$f":"L21","v":3},{"$f":"M21","v":18},{"$f":"E21","v":60},{"$f":"F21","v":4},{"$f":"G21","v":24},null,null,null,null,null,null,null,null,5,32,"2026-12-04",37,"2028-12-04",37,"2037-07-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,33,"2026-12-04",38,"2028-12-04",38,"2037-07-10"]
["si falso 3 opcions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,34,"2026-12-04",39,"2028-12-04",39,"2037-07-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,35,"2026-12-04",40,"2028-12-04",40,"2037-07-10"]
["1 - cotització sencera",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(OR(YEAR(T38)<2018,YEAR(T38)=2018,YEAR(T38)=2019),\"35,5\",IF(OR(YEAR(T38)=2020,YEAR(T38)=2021,YEAR(T38)=2022),\"36\",IF(OR(YEAR(T38)=2023,YEAR(T38)=2024,YEAR(T38)=2025,YEAR(T38)=2026),\"36,5\",\"37\")))","v":"36,5"},{"$f":"DATE(YEAR($T$27)-1,MONTH($T$27),DAY($T$27))","v":"2025-12-04"},43,{"$f":"DATE(YEAR($V$27)-1,MONTH($V$27),DAY($V$27))","v":"2027-12-04"},42,{"$f":"DATE(YEAR($X$27)-1,MONTH($X$27),DAY($X$27))","v":"2036-07-10"}]
["jubilacion ordinaria",null,{"$f":"$G$7","v":"2042-07-10"},{"$f":"H20","v":38},{"$f":"I20","v":6},{"$f":"J20","v":0},{"$f":"H5","v":75},{"$f":"I5","v":7},{"$f":"J5","v":6},{"$f":"N5","v":0},0,0,null,null,null,null,null,5,36,"2026-12-04",41,"2028-12-04",41,{"$f":"DATE(YEAR($G$7)-5,MONTH($G$7),DAY($G$7))","v":"2037-07-10"}]
["jubilacion anticipada GUB",null,{"$f":"$C$20","v":"2037-07-10"},{"$f":"K20","v":33},{"$f":"L20","v":6},{"$f":"M20","v":0},{"$f":"E20","v":70},{"$f":"F20","v":7},{"$f":"G20","v":6},{"$f":"N5","v":0},0,0,null," ",null,null,null,5,37,{"$f":"DATE(YEAR($T$27),MONTH($T$27),DAY($T$27))","v":"2026-12-04"},42,{"$f":"DATE(YEAR($V$27),MONTH($V$27),DAY($V$27))","v":"2028-12-04"},42,{"$f":"DATE(YEAR($X$27),MONTH($X$27),DAY($X$27))","v":"2037-07-10"}]
[]
["TREBALL FINS ELS 65",null,{"$f":"$G$2","v":"2031-12-04"},{"$f":"H23","v":32},{"$f":"I23","v":10},{"$f":"J23","v":24},{"$f":"E23","v":65},{"$f":"F23","v":0},{"$f":"G23","v":0},{"$f":"IFERROR(DATEDIF(C43,C39,\"Y\"),0)","v":5},{"$f":"IFERROR(DATEDIF(C43,C39,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(C43,C39,\"MD\"),0)","v":6}]
[null,null,{"$f":"DATE(YEAR(C42)-D43+D42,MONTH(C42)-E43+E42,DAY(C42)-F43+F42)","v":"2036-12-04"},{"$f":"K23","v":27},{"$f":"L23","v":10},{"$f":"M23","v":24},null,null,null,{"$f":"IF(J42<=0,0,J42)","v":5},{"$f":"IF(AND(J42<=0,K42<=0),0,K42)","v":7},{"$f":"IF(AND(J42<=0,K42<=0,L42<=0),0,L42)","v":6}]
[]
["TREBALL FINS ELS 67",null,{"$f":"$G$3","v":"2033-12-04"},{"$f":"H24","v":34},{"$f":"I24","v":10},{"$f":"J24","v":24},{"$f":"E24","v":67},{"$f":"F24","v":0},{"$f":"G24","v":0},{"$f":"IFERROR(DATEDIF(C46,C39,\"Y\"),0)","v":3},{"$f":"IFERROR(DATEDIF(C46,C39,\"YM\"),0)","v":7},{"$f":"IFERROR(DATEDIF(C46,C39,\"MD\"),0)","v":6}]
[null,null,{"$f":"DATE(YEAR(C45)-D46+D45,MONTH(C45)-E46+E45,DAY(C45)-F46+F45)","v":"2038-12-04"},{"$f":"K24","v":29},{"$f":"L24","v":10},{"$f":"M24","v":24},null,null,null,{"$f":"IF(J45<=0,0,J45)","v":3},{"$f":"IF(AND(J45<=0,K45<=0),0,K45)","v":7},{"$f":"IF(AND(J45<=0,K45<=0,L45<=0),0,L45)","v":6}]