{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["PenCalc","PenNow_Results","PenNRA_Results","PenERA_Results","TermLS_Results","TermLSDiscr_Results","PenNow_Data","PenNRA_Data","PenERA_Data","TermLS_Data","TermLSDiscr_Data","Factors","Gender"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"PenCalc","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PenNow_Results","index":1,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Gender","DOB","DOE","DOC","Pensal","LWP","NRA","Comm%","ACCServ","Full Pension","Comm LS","Reduced Pension"]

{"sheet":"PenNRA_Results","index":2,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Gender","DOB","DOE","DOC","LDP","Pensal","LWP","NRA","Comm%","AccService","FullPen","CommLS","RedPen"]

{"sheet":"PenERA_Results","index":3,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EmployeeID","Ee Name","Gender ","Date of Birth","Date Joined Fund","LDP (Last Date on Payroll)","DOCalculation","Pensal","LWP","NRA","Comm%","AccServ","FullPen","CommLS","RedPen"]

{"sheet":"TermLS_Results","index":4,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Sex","DOBirth","DOEntry","DOCalculation","Pensal","LWP","AccServ","Lump Sum Payable"]

{"sheet":"TermLSDiscr_Results","index":5,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Sex","DOBirth","DOEntry","DOCalculation","Pensal","LWP","AccServ","Lump Sum Payable"]

{"sheet":"PenNow_Data","index":6,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Sex","DOB","DOE","DOC","Pensal","LWP","NRA","Comm%"]

{"sheet":"PenNRA_Data","index":7,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Sex","DOB","DOE","LDP","DOC","Pensal","LWP","NRA","Comm%"]

{"sheet":"PenERA_Data","index":8,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EmployeeID","Ee Name","Gender ","Date of Birth","Date of Entry","LDP (Last Date on Payroll)","DOC / ER Date","Pensal","LWP","NRA","Comm%"]

{"sheet":"TermLS_Data","index":9,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Gender","Date of Birth","Date of Entry","Date of Calculation","Pensal","LWP"]

{"sheet":"TermLSDiscr_Data","index":10,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["EEeID","EEeName","Gender","Date of Birth","Date of Entry","Date of Calculation","Pensal","LWP"]

{"sheet":"Factors","index":11,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,5,0,7]]}
["Age","Males","Females",null,null,"Actuarial Factor Table (Source SNCPFA - Jude Efufibe - email 8 Jan 2025"]
[45,14.170999999999999,15.06,null,null,"Age*","Male","Female"]
[46,13.971,14.898999999999999,null,null,40,0,15.792999999999999]
[47,13.760999999999999,14.731999999999999,null,null,41,0,15.664999999999999]
[48,13.544,14.558999999999999,null,null,42,0,15.513]
[49,13.319000000000001,14.38,null,null,43,0,15.367000000000001]
[50,13.086,14.195,null,null,44,14.170999999999999,15.215999999999999]
[51,12.845000000000001,14.002000000000001,null,null,45,14.170999999999999,15.06,{"$f":"G8-B2","v":0}]
[52,12.599,13.802,null,null,46,13.971,14.898999999999999,0]
[53,12.348000000000001,13.593999999999999,null,null,47,13.760999999999999,14.731999999999999,0]
[54,12.093,13.377000000000001,null,null,48,13.544,14.558999999999999,0]
[55,11.834,13.151999999999999,null,null,49,13.319000000000001,14.38,0]
[56,11.564,12.912000000000001,null,null,50,13.086,14.195,0]
[57,11.298,12.67,null,null,51,12.845000000000001,14.002000000000001,0]
[58,11.029,12.420999999999999,null,null,52,12.599,13.802,0]
[59,10.756,12.164,null,null,53,12.348000000000001,13.593999999999999,0]
[60,10.481,11.898,null,null,54,12.093,13.377000000000001,0]
[61,10.202999999999999,11.625,null,null,55,11.834,13.151999999999999,0]
[62,9.923,11.343999999999999,null,null,56,11.564,12.912000000000001,0]
[63,9.64,11.055,null,null,57,11.298,12.67,0]
[64,9.3559999999999999,10.76,null,null,58,11.029,12.420999999999999,0]
[65,9.0690000000000008,10.458,null,null,59,10.756,12.164,0]
[null,null,null,null,null,60,10.481,11.898,0]
[null,null,null,null,null,61,10.202999999999999,11.625,0]
[null,null,null,null,null,62,9.923,11.343999999999999,0]
[null,null,null,null,null,63,9.64,11.055,0]
[null,null,null,null,null,64,9.3559999999999999,10.76]
[null,null,null,null,null,65,9.0690000000000008,10.458]

{"sheet":"Gender","index":12,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Male"]
["Female"]