{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Results","NHS FS Non Club Factors","NHS CARE Non Club Factors"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":39,"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":"Results","index":0,"n_rows":49,"n_cols":45,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,10,46,11],[39,25,43,26],[39,20,39,21],[35,22,35,23],[27,14,28,18],[3,1,4,12],[27,7,27,9],[28,2,28,3],[20,44,20,55],[22,44,22,80],[35,20,35,21],[36,20,36,21],[37,20,37,21],[5,27,5,28],[5,25,5,26],[11,16,11,17],[12,25,14,25],[12,22,12,23],[12,20,12,21],[6,20,6,23],[7,20,7,23],[7,10,7,11],[7,7,7,9],[8,7,8,9],[1,1,2,12],[48,2,48,8],[48,10,48,11],[45,2,45,8],[44,2,44,8],[36,7,36,9],[37,7,37,9],[38,7,38,9],[39,7,39,9],[40,7,40,9],[41,7,41,9],[42,7,42,9],[47,10,47,11],[47,2,47,8],[46,2,46,8],[44,10,44,11],[45,10,45,11],[32,2,32,3],[9,2,9,3],[5,7,5,9],[6,4,6,5],[7,4,7,5],[8,4,8,5],[5,10,5,11],[1,20,1,21],[2,20,2,21],[3,20,3,21],[23,4,23,5],[15,2,15,3],[14,4,14,5],[14,2,14,3],[15,4,15,5],[5,2,5,3],[6,2,6,3],[8,2,8,3],[7,2,7,3],[21,4,21,5],[18,4,18,5],[17,2,17,3],[17,4,17,5],[4,20,4,23],[11,2,12,5],[11,7,12,11],[9,7,10,11],[12,15,12,16],[15,7,15,9],[5,20,5,23],[5,4,5,5],[17,7,17,9],[18,7,18,9],[27,10,27,11],[10,2,10,5],[12,17,12,18],[26,2,26,3],[18,2,18,3],[23,2,23,3],[21,2,21,3],[13,2,13,5],[17,10,17,11],[15,10,15,11],[14,7,14,9],[13,7,13,11],[14,10,14,11],[24,2,24,4],[19,2,19,3],[19,4,19,5],[24,7,24,9],[26,7,26,9],[25,7,25,9],[26,10,26,11],[39,24,40,24],[39,27,40,27],[38,3,38,6],[39,3,39,6],[40,3,40,6],[41,3,41,6],[8,10,8,11],[26,4,26,5],[23,7,23,9],[8,20,8,23],[11,21,11,22],[32,10,32,11],[30,2,30,3],[31,2,31,3],[29,3,29,4],[28,7,28,9],[28,10,28,11],[28,4,28,5],[32,7,32,9],[31,7,31,9],[30,7,30,9],[25,10,25,11],[25,4,25,5],[22,7,22,9],[42,3,42,6],[10,20,10,23],[40,22,40,23],[41,20,41,21],[41,22,41,23],[40,20,40,21],[36,3,36,6],[37,3,37,6],[32,4,32,5],[30,10,30,11],[31,10,31,11],[34,3,35,7],[27,2,27,3],[20,2,20,3],[20,4,20,5],[36,22,36,23],[37,22,37,23],[39,22,39,23],[27,4,27,5],[30,4,30,5],[31,4,31,5],[23,10,23,11],[22,10,22,11],[18,10,18,11]]}
[]
[null,"NHS Pension Scheme(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"NHS 1995 Section",null,365,"M",{"$f":"(E16/W2)+C16","v":0},0.5,60,null,null,{"$f":"IF(Results!E6=\"NHS 1995 Section\",\"60\",IF(Results!E6=\"NHS 2008 Section\",\"65\"))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"NHS 2008 Section",null,122,"F",{"$f":"(K16/W2)+H16","v":0},0.375]
[null,"Resource Account Calculator for Unprotected Members to 31/03/2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS 2015 Section"]
[]
[null,null," Final Salary Pension Scheme",null,"Choose",null,null," Inflation Rate",null,null,1.7000000000000001E-2,null,null,null,null,{"$f":"C16+(E16/365)","v":0}]
[null,null," Name",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Results!E6=\"NHS 2008 Section\",\"60\",IF(Results!E6=\"NHS 1995 Section\",\"80\"))","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quick Ref Key"]
[null,null," Gender",null,"Choose",null,null," Age at Start of Period",null,null,{"$f":"'NHS FS Non Club Factors'!C112","v":119}]
[null,null," Date of Birth",null,null,null,null," Age at End of Period ",null,null,{"$f":"'NHS FS Non Club Factors'!C123","v":120},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"State Pension Age in Years & Months"]
[null,null," State Pension Age: Years, Months",null,0,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Final Salary Service @ 31/03/2015"]
[null,null,"Start Period - 31/03/2019",null,null,null,null,"End Period - 31/03/2020",null,null,null,null,null,null,null,null,"2016/2017",null,null,null,null,"2019/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",null,"End",null,null,"Start",null,"End",null,null,"Start adj inflation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"The actual pensionable earnings for 01/04/2015 - 31/03/2016"]
[null,null,"Final Salary Service",null,null,null,null,"Final Salary Service"]
[null,null,"Years",null,"Days",null,null,"Years",null,null,"Days",null,null,null,null,"FS","CARE","FS","CARE",null,"FS","CARE","FS","CARE","Difference",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"The actual pensionable earnings for 01/04/2016 - 31/03/2017"]
[null,null,0,null,0,null,2,{"$f":"C16","v":0},null,null,{"$f":"E16","v":0},null,8,null,"Pension",null,null,null,null,null,{"$f":"IF(E6=U2,ROUND((E22/T3)*Y2,2),ROUND((E22/T2)*Y2,2))","v":0},{"$f":"AA38","v":0},{"$f":"IF(E6=U2,ROUND((K19/T3)*Y3,2),ROUND((K19/T2)*Y3,2))","v":0},{"$f":"AA39","v":0},{"$f":"(W16+X16)-(U16+V16)","v":0},{"$f":"(U16+V16)*K6","v":0},{"$f":"(U16+V16)+Z16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"IF(E6=U2,(U16*3),0)","v":0},null,{"$f":"IF(E6=U2,(W16*3),0)","v":0},null,{"$f":"(W17+X17)-(U17+V17)","v":0},{"$f":"(U17+V17)*K6","v":0},{"$f":"(U17+V17)+Z17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"The actual pensionable earnings for 01/04/2017 - 31/03/2018"]
[null,null," 15/16 CARE Actual Earnings",null,0,null,3," 19/20 CARE Actual Earnings",null,null,0,null,9,null,"Spouse",null,null,null,null,null,{"$f":"IF(E6=U2,(U16*Z2),(U16*Z3))","v":0},{"$f":"V16*0.3375","v":0},{"$f":"IF(E6=U2,(W16*Z2),(W16*Z3))","v":0},{"$f":"X16*0.3375","v":0},{"$f":"(W18+X18)-(U18+V18)","v":0}]
[null,null," 16/17 CARE Actual Earnings ",null,0,null,4," 19/20 WTE Final Salary Link Pay",null,null,0,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"The actual pensionable earnings for 01/04/2018 - 31/03/2019"]
[null,null," 17/18 CARE Actual Earnings",null,0,null,5,null,null,null,null,null,null,null,"Factors",null,null,null,null,null,null,null,null," "]
[null,null," 18/19 CARE Actual Earnings",null,0,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"The Whole-Time Equivalent salary for 01/04/2018 - 31/03/2019 (if the member is full-time, this should match cell 6)"]
[null,null," 18/19 WTE Final Salary Link Pay",null,0,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"These cells will automatically be populated with the same service as cells 2. As members cannot accrue any further final salary service once they have transitioned in to the CARE Scheme, unless they have purchased an additional years contract. (If the member has an addtional years contract please conatct SPPA for service details)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension",null,null,null,null,null,{"$f":"'NHS FS Non Club Factors'!F113","v":17.829999999999998},{"$f":"'NHS CARE Non Club Factors'!I59","v":{"$error":"#NUM!"}},{"$f":"'NHS FS Non Club Factors'!F124","v":17.829999999999998},{"$f":"'NHS CARE Non Club Factors'!J59","v":{"$error":"#NUM!"}}]
[null,null,"Benefits (without inflation)",null,null,null,null,null,null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"'NHS FS Non Club Factors'!F114","v":0.99},null,{"$f":"'NHS FS Non Club Factors'!F125","v":0.99},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"The actual pensionable earnings for 01/04/2019 - 31/03/2020"]
[null,null," Final Salary Pension",null,{"$f":"U16","v":0},null,null," Final Salary Pension",null,null,{"$f":"W16","v":0},null,null,null,"Spouse",null,null,null,null,null,{"$f":"'NHS FS Non Club Factors'!F115","v":1.59},{"$f":"'NHS CARE Non Club Factors'!I60","v":{"$error":"#NUM!"}},{"$f":"'NHS FS Non Club Factors'!F126","v":1.59},{"$f":"'NHS CARE Non Club Factors'!J60","v":{"$error":"#NUM!"}}]
[null,null," Care Pension",null,{"$f":"V16","v":0},null,null," Care Pension",null,null,{"$f":"X16","v":0},null,null,null,"Care Adjust Factor",null,null,null,null,null,null,1,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"The Whole-Time Equivalent salary for 01/04/2019 - 31/03/2020 (if the member is full-time, this should match cell 9)"]
[null,null," Total Pension",null,{"$f":"SUM(E26:F27)","v":0},null,null," Total Pension",null,null,{"$f":"SUM(K26:L27)","v":0}]
[null,null," Lump Sum",null,{"$f":"U42","v":0},null,null," Lump Sum",null,null,{"$f":"W42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(U16)*U24","v":0},{"$f":"V16*V24","v":{"$error":"#NUM!"}},0,{"$error":"#NUM!"}]
[null,null," Final Salary CETV",null,{"$f":"U34","v":0},null,null," Final Salary CETV",null,null,{"$f":"W34","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(U17)*U25","v":0},0,0,0]
[null,null," Care CETV",null,{"$f":"V34","v":{"$error":"#NUM!"}},null,null," Care CETV",null,null,{"$f":"X34","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,{"$f":"U18*U26","v":0},{"$error":"#NUM!"},0,{"$error":"#NUM!"}]
[null,null," Total CETV",null,{"$f":"SUM(E31:F32)","v":{"$error":"#NUM!"}},null,null," Total CETV",null,null,{"$f":"SUM(K31:L32)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V30:V32)","v":{"$error":"#NUM!"}},null,{"$f":"SUM(X30:X32)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U30:U32)","v":0},{"$f":"V33*V27","v":{"$error":"#NUM!"}},{"$f":"SUM(W30:W32)","v":0},{"$f":"X33*X27","v":{"$error":"#NUM!"}},null,"Scheme Year","CARE Pension"]
[null,null,null,"Results (including inflation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15/16",{"$f":"(E18/54)*1.014","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U34+V34","v":{"$error":"#NUM!"}},null,{"$f":"W34+X34","v":{"$error":"#NUM!"}},null,null,"16/17",{"$f":"((E19/54)+AA35)*1.025","v":0}]
[null,null,null," Real Increase in Pension",null,null,null,{"$f":"(W16+X16)-AA16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U36*K6","v":{"$error":"#NUM!"}},null,null,null,null,"17/18",{"$f":"((E20/54)+AA36)*1.045","v":0}]
[null,null,null," Real Increase in Lump Sum",null,null,null,{"$f":"W17-AA17","v":0},null,null,null,null,null,null,"With Inflation",null,null,null,null,null,{"$f":"U36+U37","v":{"$error":"#NUM!"}},null,null,null,null,"18/19",{"$f":"((E21/54)+AA37)*1.039","v":0}]
[null,null,null," Accrued Pension",null,null,null,{"$f":"K28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19/20",{"$f":"((K18/54)+AA38)*1.032","v":0}]
[null,null,null," Accrued Lump Sum",null,null,null,{"$f":"W42","v":0},null,null,null,null,null,null,"CETV",null,null,null,null,null,{"$f":"U38","v":{"$error":"#NUM!"}},null,{"$f":"W36","v":{"$error":"#NUM!"}}]
[null,null,null," CETV at start of period",null,null,null,{"$f":"U38","v":{"$error":"#NUM!"}},null,null,null,null,null,null,"Pension",null,null,null,null,null,{"$f":"U16+V16","v":0},null,{"$f":"W16+X16","v":0}]
[null,null,null," CETV at end of period",null,null,null,{"$f":"K33","v":{"$error":"#NUM!"}},null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"U17+V17","v":0},null,{"$f":"W17+X17","v":0}]
[null,null,null," Real Increase in CETV",null,null,null,{"$f":"H42-H41","v":{"$error":"#NUM!"}}]
[]
[null,null,"The actual rate of pension that would be payable to the senior manager if they became entitled to it at the end of the of the financial year.",null,null,null,null,null,null,"PE",{"$f":"H39","v":0}]
[null,null,"The amount of lump sum that would be payable to the senior manager if they became entitled to it at the end of the financial year",null,null,null,null,null,null,"LSE",{"$f":"W42","v":0}]
[null,null,"The annual rate of pension, adjusted for inflation that would be payable to the senior manager if they became entitled to it at the beginning of the year",null,null,null,null,null,null,"PB",{"$f":"AA16","v":0}]
[null,null,"The amount of lump sum, adjusted for inflation, that would be payable to the senior manager if they became entitled to it at the beginning of the financial year",null,null,null,null,null,null,"LSB",{"$f":"AA17","v":0}]
[null,null,"Annual Increase to total Remuneration package",null,null,null,null,null,null,null,{"$f":"SUM((20*K45)+K46)-((20*K47)+K48)","v":0}]

{"sheet":"NHS FS Non Club Factors","index":1,"n_rows":130,"n_cols":32,"rows_kept":130,"cut":false,"hidden":true,"merged":[[128,0,128,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[121,12,121,15],[123,0,123,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[121,16,121,19],[122,0,122,1],[121,0,121,11],[110,12,110,15],[110,16,110,19],[111,0,111,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[110,0,110,11],[1,0,2,0],[1,8,2,8],[1,16,2,16],[1,24,2,24],[54,0,54,7],[54,8,54,15],[54,16,54,23],[54,24,54,30]]}
["Table TV2 – 1995 section: Males Normal Pension Age 60",null,null,null,null,null,null,null,"Table TV2 – 1995 section: Females Normal Pension Age 60",null,null,null,null,null,null,null,"Table TV3 – 2008 Section: Males Normal Pension Age 65",null,null,null,null,null,null,null,"Table TV4 – 2008 Section: Females Normal Pension Age 65 (up to age 59)"]
["Age last birthday at guarantee date","Pension Factor","Lump Sum Factor ","Surviving Partner's Pension Factor ","Male Deduction for GMP ","Deduction for NI Modification ","GMP Adj ",null,"Age last birthday at guarantee date","Pension Factor","Lump Sum Factor ","Surviving Partner's Pension Factor ","Female Deduction for GMP ","Deduction for NI Modification ","GMP Adj ",null,"Age last birthday at guarantee date","Pension Factor ","Lump Sum Factor (Choice Optants only)","Surviving Partner's Pension Factor ","Male Deduction for GMP ","Deduction for NI Modification  ","GMP Adj ",null,"Age last birthday at guarantee date","Pension Factor ","Lump Sum Factor \n(Choice Optants only) ","Surviving Partner's Pension Factor ","Female Deduction for Pre88 GMP","Female Deduction for Post88 GMP  ","Deduction for NI Modification  ","GMP Adj "]
[null,"(Factor A)","(Factor B)","(Factor C)","(Factor D)","(Factor F)","Factor",null,null,"(Factor A)","(Factor B)","(Factor C)","(Factor D)","(Factor F)",null,null,null,"(Factor A)","(Factor B)","(Factor C)","(Factor D)","(Factor E)","Factor",null,null,"(Factor A)","(Factor B)","(Factor C)","(Factor D)","(Factor †E)","(Factor E)","Factor"]
[18,7.26,0.35,0.66,3.63,5.18,0.15,null,18,7.26,0.35,0.66,3.1,5.18,0.15,null,18,6.5,0.33,0.76,3.66,4.6500000000000004,0.15,null,18,6.5,0.33,0.76,-0.67,-0.67,4.6500000000000004,3.5]
[19,7.26,0.35,0.66,3.63,5.18,0.15,null,19,7.26,0.35,0.66,3.1,5.18,0.15,null,19,6.64,0.34,0.8,3.65,4.78,0.15,null,19,6.64,0.34,0.8,-0.68,-0.68,4.78,3.5]
[20,7.26,0.35,0.66,3.63,5.18,0.15,null,20,7.26,0.35,0.66,3.1,5.18,0.15,null,20,6.78,0.35,0.82,3.64,4.91,0.15,null,20,6.78,0.35,0.82,-0.7,-0.7,4.91,3.5]
[21,7.26,0.35,0.66,3.63,5.18,0.15,null,21,7.26,0.35,0.66,3.1,5.18,0.15,null,21,6.93,0.36,0.84,3.64,5.04,0.15,null,21,6.93,0.36,0.84,-0.71,-0.71,5.04,3.5]
[22,8.93,0.41,0.84,3.63,5.18,0.15,null,22,8.93,0.41,0.84,3.1,5.18,0.15,null,22,7.07,0.36,0.86,3.63,5.18,0.15,null,22,7.07,0.36,0.86,-0.73,-0.73,5.18,3.5]
[23,9.1300000000000008,0.42,0.86,3.63,5.32,0.15,null,23,9.1300000000000008,0.42,0.86,3.09,5.32,0.15,null,23,7.22,0.37,0.88,3.63,5.32,0.15,null,23,7.22,0.37,0.88,-0.74,-0.74,5.32,3.5]
[24,9.33,0.43,0.88,3.62,5.46,0.15,null,24,9.33,0.43,0.88,3.09,5.46,0.15,null,24,7.38,0.38,0.9,3.62,5.46,0.15,null,24,7.38,0.38,0.9,-0.76,-0.76,5.46,3.5]
[25,9.5299999999999994,0.44,0.91,3.61,5.61,0.15,null,25,9.5299999999999994,0.44,0.91,3.08,5.61,0.15,null,25,7.53,0.39,0.92,3.61,5.61,0.15,null,25,7.53,0.39,0.92,-0.78,-0.78,5.61,3.5]
[26,9.74,0.45,0.93,3.61,5.77,0.15,null,26,9.74,0.45,0.93,3.08,5.77,0.15,null,26,7.69,0.4,0.94,3.61,5.77,0.15,null,26,7.69,0.4,0.94,-0.79,-0.79,5.77,3.5]
[27,9.9499999999999993,0.46,0.95,3.6,5.92,0.15,null,27,9.9499999999999993,0.46,0.95,3.07,5.92,0.15,null,27,7.85,0.41,0.96,3.6,5.92,0.15,null,27,7.85,0.41,0.96,-0.81,-0.81,5.92,3.5]
[28,10.16,0.47,0.97,3.59,6.08,0.15,null,28,10.16,0.47,0.97,3.07,6.08,0.15,null,28,8.02,0.42,0.99,3.59,6.08,0.15,null,28,8.02,0.42,0.99,-0.82,-0.82,6.08,3.5]
[29,10.38,0.49,0.99,3.59,6.25,0.15,null,29,10.38,0.49,0.99,3.06,6.25,0.15,null,29,8.19,0.43,1.01,3.59,6.25,0.15,null,29,8.19,0.43,1.01,-0.84,-0.84,6.25,3.5]
[30,10.61,0.5,1.01,3.58,6.42,0.15,null,30,10.61,0.5,1.01,3.06,6.42,0.15,null,30,8.36,0.44,1.03,3.58,6.42,0.15,null,30,8.36,0.44,1.03,-0.86,-0.86,6.42,3.5]
[31,10.84,0.51,1.04,3.58,6.6,0.15,null,31,10.84,0.51,1.04,3.05,6.6,0.15,null,31,8.5399999999999991,0.45,1.05,3.58,6.6,0.15,null,31,8.5399999999999991,0.45,1.05,-0.87,-0.87,6.6,3.5]
[32,11.08,0.52,1.06,3.57,6.78,0.15,null,32,11.08,0.52,1.06,3.04,6.78,0.15,null,32,8.7200000000000006,0.46,1.08,3.57,6.78,0.15,null,32,8.7200000000000006,0.46,1.08,-0.89,-0.89,6.78,3.5]
[33,11.32,0.53,1.08,3.56,6.96,0.15,null,33,11.32,0.53,1.08,3.04,6.96,0.15,null,33,8.91,0.47,1.1000000000000001,3.56,6.96,0.15,null,33,8.91,0.47,1.1000000000000001,-0.9,-0.9,6.96,3.5]
[34,11.57,0.55000000000000004,1.1000000000000001,3.56,7.15,0.15,null,34,11.57,0.55000000000000004,1.1000000000000001,3.03,7.15,0.15,null,34,9.1,0.49,1.1200000000000001,3.56,7.15,0.15,null,34,9.1,0.49,1.1200000000000001,-0.92,-0.92,7.15,3.5]
[35,11.82,0.56000000000000005,1.1299999999999999,3.55,7.35,0.15,null,35,11.82,0.56000000000000005,1.1299999999999999,3.03,7.35,0.15,null,35,9.2899999999999991,0.5,1.1499999999999999,3.55,7.35,0.15,null,35,9.2899999999999991,0.5,1.1499999999999999,-0.94,-0.94,7.35,3.5]
[36,12.08,0.56999999999999995,1.1499999999999999,3.55,7.55,0.15,null,36,12.08,0.56999999999999995,1.1499999999999999,3.03,7.55,0.15,null,36,9.49,0.51,1.17,3.55,7.55,0.15,null,36,9.49,0.51,1.17,-0.96,-0.96,7.55,3.5]
[37,12.34,0.59,1.17,3.54,7.76,0.15,null,37,12.34,0.59,1.17,3.02,7.76,0.15,null,37,9.6999999999999993,0.52,1.19,3.54,7.76,0.15,null,37,9.6999999999999993,0.52,1.19,-0.97,-0.97,7.76,3.5]
[38,12.62,0.6,1.19,3.54,7.97,0.15,null,38,12.62,0.6,1.19,3.02,7.97,0.15,null,38,9.9,0.53,1.21,3.54,7.97,0.15,null,38,9.9,0.53,1.21,-0.99,-0.99,7.97,3.5]
[39,12.9,0.62,1.21,3.53,8.19,0.15,null,39,12.9,0.62,1.21,3.01,8.19,0.15,null,39,10.119999999999999,0.55000000000000004,1.24,3.53,8.19,0.15,null,39,10.119999999999999,0.55000000000000004,1.24,-1.01,-1.01,8.19,3.5]
[40,13.18,0.63,1.24,3.53,8.42,0.15,null,40,13.18,0.63,1.24,3.01,8.42,0.15,null,40,10.34,0.56000000000000005,1.26,3.53,8.42,0.15,null,40,10.34,0.56000000000000005,1.26,-1.02,-1.02,8.42,3.5]
[41,13.47,0.64,1.26,3.52,8.65,0.15,null,41,13.47,0.64,1.26,3,8.65,0.15,null,41,10.56,0.56999999999999995,1.28,3.52,8.65,0.15,null,41,10.56,0.56999999999999995,1.28,-1.04,-1.04,8.65,3.5]
[42,13.77,0.66,1.28,3.52,8.9,0.15,null,42,13.77,0.66,1.28,3,8.9,0.15,null,42,10.79,0.59,1.3,3.52,8.9,0.15,null,42,10.79,0.59,1.3,-1.06,-1.06,8.9,3.5]
[43,14.08,0.68,1.3,3.52,9.14,0.15,null,43,14.08,0.68,1.3,3,9.14,0.15,null,43,11.02,0.6,1.32,3.52,9.14,0.15,null,43,11.02,0.6,1.32,-1.08,-1.08,9.14,3.5]
[44,14.4,0.69,1.32,3.51,9.4,0.15,null,44,14.4,0.69,1.32,2.99,9.4,0.15,null,44,11.26,0.62,1.34,3.51,9.4,0.15,null,44,11.26,0.62,1.34,-1.1000000000000001,-1.1000000000000001,9.4,3.5]
[45,14.72,0.71,1.34,3.51,9.66,0.15,null,45,14.72,0.71,1.34,2.99,9.66,0.15,null,45,11.51,0.63,1.37,3.51,9.66,0.15,null,45,11.51,0.63,1.37,-1.1100000000000001,-1.1100000000000001,9.66,3.5]
[46,15.05,0.73,1.36,3.5,9.93,0.15,null,46,15.05,0.73,1.36,2.98,9.93,0.15,null,46,11.76,0.64,1.39,3.5,9.93,0.15,null,46,11.76,0.64,1.39,-1.1299999999999999,-1.1299999999999999,9.93,3.5]
[47,15.39,0.74,1.38,3.5,10.210000000000001,0.15,null,47,15.39,0.74,1.38,2.98,10.210000000000001,0.15,null,47,12.02,0.66,1.41,3.5,10.210000000000001,0.15,null,47,12.02,0.66,1.41,-1.1499999999999999,-1.1499999999999999,10.210000000000001,3.5]
[48,15.74,0.76,1.4,3.5,10.49,0.15,null,48,15.74,0.76,1.4,2.98,10.49,0.15,null,48,12.29,0.68,1.43,3.5,10.49,0.15,null,48,12.29,0.68,1.43,-1.17,-1.17,10.49,3.5]
[49,16.100000000000001,0.78,1.41,3.49,10.79,0.15,null,49,16.100000000000001,0.78,1.41,2.98,10.79,0.15,null,49,12.56,0.69,1.45,3.49,10.79,0.15,null,49,12.56,0.69,1.45,-1.19,-1.19,10.79,3.5]
[50,16.47,0.8,1.43,3.49,11.09,0.15,null,50,16.47,0.8,1.43,2.97,11.09,0.15,null,50,12.84,0.71,1.46,3.49,11.09,0.15,null,50,12.84,0.71,1.46,-1.21,-1.21,11.09,3.5]
[51,16.850000000000001,0.82,1.45,3.49,11.41,0.15,null,51,16.850000000000001,0.82,1.45,2.97,11.41,0.15,null,51,13.13,0.73,1.48,3.49,11.41,0.15,null,51,13.13,0.73,1.48,-1.23,-1.23,11.41,3.5]
[52,17.239999999999998,0.84,1.47,3.48,11.73,0.15,null,52,17.239999999999998,0.84,1.47,2.97,11.73,0.15,null,52,13.42,0.74,1.5,3.48,11.73,0.15,null,52,13.42,0.74,1.5,-1.25,-1.25,11.73,3.5]
[53,17.64,0.86,1.48,3.48,12.07,0.15,null,53,17.64,0.86,1.48,2.97,12.07,0.15,null,53,13.73,0.76,1.52,3.48,12.07,0.15,null,53,13.73,0.76,1.52,-1.27,-1.27,12.07,3.5]
[54,18.05,0.88,1.5,3.48,12.42,0.15,null,54,18.05,0.88,1.5,2.97,12.42,0.15,null,54,14.04,0.78,1.53,3.48,12.42,0.15,null,54,14.04,0.78,1.53,-1.29,-1.29,12.42,3.5]
[55,18.48,0.9,1.51,3.48,12.78,0.15,null,55,18.48,0.9,1.51,2.97,12.78,0.15,null,55,14.37,0.8,1.54,3.48,12.78,0.15,null,55,14.37,0.8,1.54,-1.31,-1.31,12.78,3.5]
[56,18.920000000000002,0.92,1.52,3.48,13.16,0.15,null,56,18.920000000000002,0.92,1.52,2.97,13.16,0.15,null,56,14.7,0.82,1.56,3.48,13.16,0.15,null,56,14.7,0.82,1.56,-1.34,-1.34,13.16,3.5]
[57,19.38,0.94,1.53,3.48,13.54,0.15,null,57,19.38,0.94,1.53,2.97,13.54,0.15,null,57,15.04,0.84,1.57,3.48,13.54,0.15,null,57,15.04,0.84,1.57,-1.36,-1.36,13.54,3.5]
[58,19.850000000000001,0.97,1.54,3.48,13.95,0.15,null,58,19.850000000000001,0.97,1.54,2.97,13.95,0.15,null,58,15.4,0.86,1.58,3.48,13.95,0.15,null,58,15.4,0.86,1.58,-1.38,-1.38,13.95,3.5]
[59,20.34,0.99,1.54,3.48,14.37,0.15,null,59,20.34,0.99,1.54,3.05,14.37,0.15,null,59,15.77,0.88,1.58,3.48,14.37,0.15,null,59,15.77,0.88,1.58,-1.44,-1.44,14.37,3.5]
[60,20.34,0.99,1.54,3.48,14.37,0.15,null,60,20.34,0.99,1.54,3.05,14.37,0.15,null,60,16.149999999999999,0.9,1.59,3.49,14.8,0.15,null,60,16.149999999999999,0.9,1.59,-1.01,-3.71,14.8,3.5]
[61,20.34,0.99,1.54,3.48,14.37,0.15,null,61,20.34,0.99,1.54,3.05,14.37,0.15,null,61,16.55,0.92,1.59,3.49,15.26,0.15,null,61,16.55,0.92,1.59,-0.05,-2.82,15.26,3.5]
[62,20.34,0.99,1.54,3.48,14.37,0.15,null,62,20.34,0.99,1.54,3.05,14.37,0.15,null,62,16.96,0.94,1.59,3.5,15.73,0.15,null,62,16.96,0.94,1.59,0.95,-1.9,15.73,3.5]
[63,20.34,0.99,1.54,3.48,14.37,0.15,null,63,20.34,0.99,1.54,3.05,14.37,0.15,null,63,17.39,0.97,1.59,3.51,16.23,0.15,null,63,17.39,0.97,1.59,1.99,-0.95,16.23,3.5]
[64,20.34,0.99,1.54,3.48,14.37,0.15,null,64,20.34,0.99,1.54,3.05,14.37,0.15,null,64,17.829999999999998,0.99,1.59,3.61,16.739999999999998,0.15,null,64,17.829999999999998,0.99,1.59,3.05,0.03,16.739999999999998,3.5]
[65,20.34,0.99,1.54,3.48,14.37,0.15,null,65,20.34,0.99,1.54,3.05,14.37,0.15,null,65,17.829999999999998,0.99,1.59,3.61,16.739999999999998,0.15,null,65,17.829999999999998,0.99,1.59,3.05,0.03,16.739999999999998,3.5]
[66,20.34,0.99,1.54,3.48,14.37,0.15,null,66,20.34,0.99,1.54,3.05,14.37,0.15,null,66,17.829999999999998,0.99,1.59,3.61,16.739999999999998,0.15,null,66,17.829999999999998,0.99,1.59,3.05,0.03,16.739999999999998,3.5]
[67,20.34,0.99,1.54,3.48,14.37,0.15,null,67,20.34,0.99,1.54,3.05,14.37,0.15,null,67,17.829999999999998,0.99,1.59,3.61,16.739999999999998,0.15,null,67,17.829999999999998,0.99,1.59,3.05,0.03,16.739999999999998,3.5]
["Notes:",null,null,null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,"Notes:"]
["1. When calculating the deduction for GMP, the factor given should be applied to the sum of the GMP amount per annum in respect of service up to 5 April 1988 and 15% of the GMP amount per annum in respect of service after that date",null,null,null,null,null,null,null,"1. When calculating the deduction for GMP, the factor given should be applied to the sum of the GMP amount per annum in respect of service up to 5 April 1988 and 15% of the GMP amount per annum in respect of service after that date",null,null,null,null,null,null,null,"1. When calculating the deduction for GMP for males, the factor given should be applied to the sum of the GMP amount per annum in respect of service up to 5 April 1988 and 15% of the GMP amount per annum in respect of service after that date",null,null,null,null,null,null,null,"1. When calculating the deduction for GMP for females, the factor given should be applied to the sum of the GMP amount per annum in respect of service up to 5 April 1988 and 350% of the GMP amount per annum in respect of service after that date"]
["Table CEM60 - CETV factors for men, NPA 60, STSS",null,null,null,null,null,null,null,"Table CEF60 - CETV factors for women, NPA 60, STSS",null,null,null,null,null,null,null,"Table CEM65 - CETV factors for men, NPA 65, STSS and STPS",null,null,null,null,null,null,null,"Table CEF65a - CETV factors for women, NPA 65, ages 20 to 59, STSS and STPS"]
[]
["Age last birthday at relevant date","Gross Pension of £1 per annum","Lump Sum of £1","Surviving Partner's Pension of £1 pa","Deduction1 for GMP of £1 pa","Deduction for NI Modification of £1 pa","GMP Adj ",null,"Age last birthday at relevant date","Gross Pension of £1 per annum","Lump Sum of £1","Surviving Partner's Pension of £1 pa","Deduction1 for GMP of £1 pa","Deduction for NI Modification of £1 pa","GMP Adj ",null,"Age last birthday at relevant date","Gross Pension of £1 per annum","Lump Sum Factor","Surviving Partner's Pension of £1 pa","Deduction1 for GMP of £1 pa","Deduction for NI Modification of £1 pa","GMP Adj ",null,"Age last birthday at relevant date","Gross Pension of £1 per annum","Lump Sum Factor","Surviving Partner's Pension of £1 pa","Deduction1 for GMP of £1 pa","Female Deduction for Post88 GMP  ","Deduction for NI Modification of £1 pa","GMP Adj "]
[18,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,19]
[20,6.73,0.35,1.23,3.5,4.72,0.15,null,20,7.15,0.33,0.42,3.02,5.1100000000000003,0.15,null,20,5.22,0,1.23,3.5,4.72,0.15,null,20,5.61,0,0.42,-0.84,5.1100000000000003,5.1100000000000003,3.5]
[21,6.91,0.36,1.26,3.49,4.8499999999999996,0.15,null,21,7.33,0.34,0.43,3.01,5.25,0.15,null,21,5.35,0,1.26,3.49,4.8499999999999996,0.15,null,21,5.75,0,0.43,-0.86,5.25,5.25,3.5]
[22,7.08,0.37,1.29,3.49,4.9800000000000004,0.15,null,22,7.52,0.35,0.44,3.01,5.39,0.15,null,22,5.48,0,1.29,3.49,4.9800000000000004,0.15,null,22,5.9,0,0.44,-0.87,5.39,5.39,3.5]
[23,7.26,0.38,1.33,3.48,5.12,0.15,null,23,7.71,0.36,0.46,3.01,5.54,0.15,null,23,5.63,0,1.33,3.48,5.12,0.15,null,23,6.05,0,0.46,-0.89,5.54,5.54,3.5]
[24,7.46,0.39,1.37,3.48,5.26,0.15,null,24,7.92,0.38,0.47,3,5.69,0.15,null,24,5.77,0,1.37,3.48,5.26,0.15,null,24,6.2,0,0.47,-0.9,5.69,5.69,3.5]
[25,7.65,0.4,1.4,3.47,5.4,0.15,null,25,8.1300000000000008,0.38,0.48,3,5.85,0.15,null,25,5.91,0,1.4,3.47,5.4,0.15,null,25,6.36,0,0.48,-0.92,5.85,5.85,3.5]
[26,7.84,0.41,1.44,3.46,5.55,0.15,null,26,8.34,0.39,0.49,2.99,6.01,0.15,null,26,6.06,0,1.44,3.46,5.55,0.15,null,26,6.52,0,0.49,-0.93,6.01,6.01,3.5]
[27,8.0500000000000007,0.42,1.48,3.46,5.7,0.15,null,27,8.5500000000000007,0.42,0.5,2.99,6.18,0.15,null,27,6.22,0,1.48,3.46,5.7,0.15,null,27,6.7,0,0.5,-0.95,6.18,6.18,3.5]
[28,8.26,0.43,1.52,3.45,5.85,0.15,null,28,8.7799999999999994,0.43,0.52,2.99,6.35,0.15,null,28,6.37,0,1.52,3.45,5.85,0.15,null,28,6.87,0,0.52,-0.96,6.35,6.35,3.5]
[29,8.4700000000000006,0.44,1.56,3.45,6.01,0.15,null,29,9.01,0.44,0.53,2.98,6.53,0.15,null,29,6.53,0,1.56,3.45,6.01,0.15,null,29,7.05,0,0.53,-0.98,6.53,6.53,3.5]
[30,8.68,0.44,1.61,3.44,6.18,0.15,null,30,9.24,0.44,0.54,2.98,6.71,0.15,null,30,6.7,0,1.62,3.44,6.18,0.15,null,30,7.23,0,0.54,-0.99,6.71,6.71,3.5]
[31,8.91,0.47,1.65,3.44,6.35,0.15,null,31,9.48,0.45,0.56000000000000005,2.97,6.89,0.15,null,31,6.87,0,1.66,3.44,6.35,0.15,null,31,7.41,0,0.56000000000000005,-1.01,6.89,6.89,3.5]
[32,9.14,0.47,1.69,3.43,6.52,0.15,null,32,9.73,0.47,0.56999999999999995,2.97,7.08,0.15,null,32,7.04,0,1.7,3.43,6.52,0.15,null,32,7.6,0,0.56999999999999995,-1.02,7.08,7.08,3.5]
[33,9.3800000000000008,0.48,1.73,3.43,6.7,0.15,null,33,9.99,0.48,0.57999999999999996,2.97,7.28,0.15,null,33,7.22,0,1.73,3.43,6.7,0.15,null,33,7.8,0,0.57999999999999996,-1.04,7.28,7.28,3.5]
[34,9.6199999999999992,0.5,1.78,3.42,6.88,0.15,null,34,10.25,0.49,0.6,2.96,7.48,0.15,null,34,7.4,0,1.78,3.42,6.88,0.15,null,34,7.99,0,0.6,-1.05,7.48,7.48,3.5]
[35,9.8699999999999992,0.51,1.82,3.42,7.07,0.15,null,35,10.52,0.51,0.61,2.96,7.69,0.15,null,35,7.59,0,1.82,3.42,7.07,0.15,null,35,8.1999999999999993,0,0.61,-1.07,7.69,7.69,3.5]
[36,10.130000000000001,0.53,1.87,3.41,7.27,0.15,null,36,10.79,0.52,0.62,2.95,7.9,0.15,null,36,7.79,0,1.87,3.41,7.27,0.15,null,36,8.41,0,0.62,-1.0900000000000001,7.9,7.9,3.5]
[37,10.4,0.54,1.91,3.41,7.47,0.15,null,37,11.08,0.54,0.64,2.95,8.1199999999999992,0.15,null,37,7.99,0,1.91,3.41,7.47,0.15,null,37,8.6300000000000008,0,0.64,-1.1000000000000001,8.1199999999999992,8.1199999999999992,3.5]
[38,10.67,0.56000000000000005,1.95,3.4,7.67,0.15,null,38,11.38,0.55000000000000004,0.65,2.95,8.35,0.15,null,38,8.19,0,1.95,3.4,7.67,0.15,null,38,8.86,0,0.65,-1.1200000000000001,8.35,8.35,3.5]
[39,10.95,0.56999999999999995,2,3.4,7.89,0.15,null,39,11.67,0.56999999999999995,0.67,2.94,8.58,0.15,null,39,8.41,0,2,3.4,7.89,0.15,null,39,9.08,0,0.67,-1.1299999999999999,8.58,8.58,3.5]
[40,11.25,0.59,2.0299999999999998,3.4,8.11,0.15,null,40,11.98,0.57999999999999996,0.68,2.94,8.82,0.15,null,40,8.6199999999999992,0,2.04,3.4,8.11,0.15,null,40,9.32,0,0.68,-1.1499999999999999,8.82,8.82,3.5]
[41,11.54,0.6,2.0699999999999998,3.39,8.33,0.15,null,41,12.3,0.6,0.7,2.94,9.06,0.15,null,41,8.84,0,2.08,3.39,8.33,0.15,null,41,9.5500000000000007,0,0.7,-1.17,9.06,9.06,3.5]
[42,11.85,0.62,2.12,3.39,8.57,0.15,null,42,12.62,0.62,0.71,2.93,9.32,0.15,null,42,9.08,0,2.13,3.39,8.57,0.15,null,42,9.81,0,0.71,-1.18,9.32,9.32,3.5]
[43,12.16,0.64,2.16,3.39,8.81,0.15,null,43,12.95,0.64,0.72,2.93,9.58,0.15,null,43,9.31,0,2.16,3.39,8.81,0.15,null,43,10.06,0,0.72,-1.2,9.58,9.58,3.5]
[44,12.5,0.66,2.2000000000000002,3.39,9.06,0.15,null,44,13.3,0.65,0.74,2.93,9.84,0.15,null,44,9.56,0,2.2000000000000002,3.39,9.06,0.15,null,44,10.31,0,0.74,-1.22,9.84,9.84,3.5]
[45,12.83,0.68,2.2400000000000002,3.38,9.31,0.15,null,45,13.65,0.67,0.75,2.92,10.119999999999999,0.15,null,45,9.8000000000000007,0,2.25,3.38,9.31,0.15,null,45,10.59,0,0.75,-1.23,10.119999999999999,10.119999999999999,3.5]
[46,13.17,0.69,2.2799999999999998,3.38,9.58,0.15,null,46,14.01,0.69,0.76,2.92,10.4,0.15,null,46,10.07,0,2.29,3.38,9.58,0.15,null,46,10.86,0,0.77,-1.25,10.4,10.4,3.5]
[47,13.53,0.71,2.33,3.38,9.85,0.15,null,47,14.38,0.71,0.77,2.92,10.69,0.15,null,47,10.33,0,2.33,3.38,9.85,0.15,null,47,11.14,0,0.78,-1.27,10.69,10.69,3.5]
[48,13.89,0.73,2.38,3.38,10.119999999999999,0.15,null,48,14.76,0.73,0.79,2.91,10.99,0.15,null,48,10.6,0,2.38,3.38,10.119999999999999,0.15,null,48,11.43,0,0.8,-1.28,10.99,10.99,3.5]
[49,14.27,0.76,2.42,3.37,10.41,0.15,null,49,15.16,0.75,0.8,2.91,11.3,0.15,null,49,10.88,0,2.4300000000000002,3.37,10.41,0.15,null,49,11.73,0,0.8,-1.3,11.3,11.3,3.5]
[50,14.65,0.77,2.4700000000000002,3.37,10.71,0.15,null,50,15.56,0.77,0.82,2.91,11.62,0.15,null,50,11.17,0,2.48,3.37,10.71,0.15,null,50,12.04,0,0.82,-1.32,11.62,11.62,3.5]
[51,15.06,0.79,2.52,3.37,11.01,0.15,null,51,15.98,0.79,0.83,2.9,11.95,0.15,null,51,11.46,0,2.52,3.37,11.01,0.15,null,51,12.36,0,0.83,-1.34,11.95,11.95,3.5]
[52,15.46,0.81,2.56,3.37,11.33,0.15,null,52,16.420000000000002,0.81,0.84,2.9,12.29,0.15,null,52,11.77,0,2.57,3.37,11.33,0.15,null,52,12.68,0,0.84,-1.36,12.29,12.29,3.5]
[53,15.9,0.84,2.6,3.37,11.66,0.15,null,53,16.86,0.84,0.85,2.9,12.64,0.15,null,53,12.09,0,2.61,3.37,11.66,0.15,null,53,13.02,0,0.85,-1.37,12.64,12.64,3.5]
[54,16.34,0.86,2.65,3.37,12,0.15,null,54,17.32,0.86,0.86,2.9,13,0.15,null,54,12.42,0,2.65,3.37,12,0.15,null,54,13.36,0,0.86,-1.39,13,13,3.5]
[55,16.8,0.89,2.68,3.37,12.35,0.15,null,55,17.8,0.89,0.86,2.9,13.38,0.15,null,55,12.76,0,2.69,3.37,12.35,0.15,null,55,13.73,0,0.87,-1.41,13.38,13.38,3.5]
[56,17.28,0.91,2.72,3.38,12.72,0.15,null,56,18.28,0.91,0.87,2.9,13.77,0.15,null,56,13.11,0,2.72,3.38,12.72,0.15,null,56,14.1,0,0.88,-1.43,13.77,13.77,3.5]
[57,17.77,0.93,2.75,3.38,13.1,0.15,null,57,18.8,0.93,0.88,2.9,14.17,0.15,null,57,13.48,0,2.76,3.38,13.1,0.15,null,57,14.48,0,0.88,-1.45,14.17,14.17,3.5]
[58,18.29,0.96,2.8,3.38,13.49,0.15,null,58,19.32,0.96,0.88,2.9,14.59,0.15,null,58,13.85,0,2.81,3.38,13.49,0.15,null,58,14.88,0,0.88,-1.47,14.59,14.59,3.5]
[59,18.82,0.99,2.83,3.39,13.91,0.15,null,59,19.87,0.99,0.89,2.97,15.02,0.15,null,59,14.25,0,2.84,3.39,13.91,0.15,null,59,15.29,0,0.89,-1.53,15.02,15.02,3.5]
[60,18.82,0.99,2.83,3.39,13.91,0.15,null,60,19.87,0.99,0.89,2.97,15.02,0.15,null,60,14.656821833667143,0,2.8655397514815673,3.39,14.33,0.15,null,60,15.72,0,0.89,-1.1000000000000001,-3.72,15.47,1]
[61,18.82,0.99,2.83,3.39,13.91,0.15,null,61,19.87,0.99,0.89,2.97,15.02,0.15,null,61,15.087731342979639,0,2.9005426263636735,3.4,14.78,0.15,null,61,16.170000000000002,0,0.89,-0.14000000000000001,-2.82,15.94,1]
[62,18.82,0.99,2.83,3.39,13.91,0.15,null,62,19.87,0.99,0.89,2.97,15.02,0.15,null,62,15.537288927827673,0,2.9353987635669028,3.41,15.25,0.15,null,62,16.62,0,0.89,0.86,-1.9,16.420000000000002,1]
[63,18.82,0.99,2.83,3.39,13.91,0.15,null,63,19.87,0.99,0.89,2.97,15.02,0.15,null,63,15.995212374349942,0,2.9600061907646649,3.42,15.73,0.15,null,63,17.100000000000001,0,0.88,1.89,-0.95,16.93,1]
[64,18.82,0.99,2.83,3.39,13.91,0.15,null,64,19.87,0.99,0.89,2.97,15.02,0.15,null,64,16.481745469994721,0,2.984506987558893,3.51,16.239999999999998,0.15,null,64,17.600000000000001,0,0.88,2.95,0.03,17.46,1]
[65,18.82,0.99,2.83,3.39,13.91,0.15,null,65,19.87,0.99,0.89,2.97,15.02,0.15,null,65,16.481745469994721,0,2.984506987558893,3.51,16.239999999999998,0.15,null,65,17.600000000000001,0,0.88,2.95,0.03,17.46,1]
[66,18.82,0.99,2.83,3.39,13.91,0.15,null,66,19.87,0.99,0.89,2.97,15.02,0.15,null,66,16.481745469994721,0,2.984506987558893,3.51,16.239999999999998,0.15,null,66,17.600000000000001,0,0.88,2.95,0.03,17.46,1]
[67,18.82,0.99,2.83,3.39,13.91,0.15,null,67,19.87,0.99,0.89,2.97,15.02,0.15,null,67,16.481745469994721,0,2.984506987558893,3.51,16.239999999999998,0.15,null,67,17.600000000000001,0,0.88,2.95,0.03,17.46,1]
[]
[]
["Factors at 31/03/2018",null,null,null,null,null,null,null,null,null,null,null,"NHS",null,null,null,"STSS"]
["Age",null,{"$f":"INT((C114-C115)/365.25)","v":119},null,null,"Actual","Male","Female","Male 60","Female 60","Male 65","Female 65","Male 60","Female 60","Male 65","Female 65","Male 60","Female 60","Male 65","Female 65"]
["Gender",null,{"$f":"IF(Results!E8=\"M\", \"Male\", \"Female\")","v":"Female"},"Pension factor",null,{"$f":"IF($C$113=\"Male\",G113,H113)","v":17.829999999999998},{"$f":"IF($C$116=\"60\",I113,K113)","v":17.829999999999998},17.829999999999998,{"$f":"IF($C$118=\"NHS\",M113,Q113)","v":20.34},20.34,17.829999999999998,{"$f":"IF($C$118=\"NHS\",P113,T113)","v":17.829999999999998},{"$f":"VLOOKUP($C$112,$A$4:$G$53,2)","v":20.34},{"$f":"VLOOKUP($C$112,$I$4:$O$53,2)","v":20.34},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$112,$A$59:$G$108,2)","v":18.82},{"$f":"VLOOKUP($C$112,$I$59:$O$108,2)","v":19.87},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,2)","v":16.481745469994721},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,2)","v":17.600000000000001}]
["Relevant date",null,"2019-03-31","Lump sum factor",null,{"$f":"IF($C$113=\"Male\",G114,H114)","v":0.99},0.99,0.99,0.99,0.99,0.99,0.99,{"$f":"VLOOKUP($C$112,$A$4:$G$53,3)","v":0.99},{"$f":"VLOOKUP($C$112,$I$4:$O$53,3)","v":0.99},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,3)","v":0.99},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,3)","v":0.99},{"$f":"VLOOKUP($C$112,$A$59:$G$108,3)","v":0.99},{"$f":"VLOOKUP($C$112,$I$59:$O$108,3)","v":0.99},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,3)","v":0},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,3)","v":0}]
["DOB",null,{"$f":"Results!E9","v":"00:00:00"},"Widow(er)'s pension factor",null,1.59,1.59,1.59,1.54,1.54,1.59,1.59,{"$f":"VLOOKUP($C$112,$A$4:$G$53,4)","v":1.54},{"$f":"VLOOKUP($C$112,$I$4:$O$53,4)","v":1.54},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,4)","v":1.59},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,4)","v":1.59},{"$f":"VLOOKUP($C$112,$A$59:$G$108,4)","v":2.83},{"$f":"VLOOKUP($C$112,$I$59:$O$108,4)","v":0.89},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,4)","v":2.984506987558893},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,4)","v":0.88}]
["NRA",null,{"$f":"IF(Results!E6=\"NHS 1995 Section\",\"60\",\"65\")","v":"65"},"Pre-88 GMP factor",null,3.05,3.61,3.05,3.48,3.05,3.61,3.05,{"$f":"VLOOKUP($C$112,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$112,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,5)","v":3.05},{"$f":"VLOOKUP($C$112,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$112,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,5)","v":2.95}]
["Factors",null,2016,"Post-88 GMP factor",null,0.03,3.61,0.03,3.48,3.05,3.61,0.03,{"$f":"VLOOKUP($C$112,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$112,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,6)","v":0.03},{"$f":"VLOOKUP($C$112,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$112,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,6)","v":0.03}]
["Scheme",null,"NHS","NI Mod factor",null,16.739999999999998,16.739999999999998,16.739999999999998,14.37,14.37,16.739999999999998,16.739999999999998,{"$f":"VLOOKUP($C$112,$A$4:$G$53,6)","v":14.37},{"$f":"VLOOKUP($C$112,$I$4:$O$53,6)","v":14.37},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,6)","v":16.739999999999998},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,7)","v":16.739999999999998},{"$f":"VLOOKUP($C$112,$A$59:$G$108,6)","v":13.91},{"$f":"VLOOKUP($C$112,$I$59:$O$108,6)","v":15.02},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,6)","v":16.239999999999998},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,7)","v":17.46}]
[null,null,null,"GMP Adjustment",null,3.5,0.15,3.5,0.15,0.15,0.15,3.5,{"$f":"VLOOKUP($C$112,$A$4:$G$53,7)","v":0.15},{"$f":"VLOOKUP($C$112,$I$4:$O$53,7)","v":0.15},{"$f":"VLOOKUP($C$112,$Q$4:$W$53,7)","v":0.15},{"$f":"VLOOKUP($C$112,$Y$4:$AF$53,8)","v":3.5},{"$f":"VLOOKUP($C$112,$A$59:$G$108,7)","v":0.15},{"$f":"VLOOKUP($C$112,$I$59:$O$108,7)","v":0.15},{"$f":"VLOOKUP($C$112,$Q$59:$W$108,7)","v":0.15},{"$f":"VLOOKUP($C$112,$Y$59:$AF$108,8)","v":1}]
[]
[]
["Factor at 31/03/2019",null,null,null,null,null,null,null,null,null,null,null,"NHS",null,null,null,"STSS"]
["Age",null,{"$f":"INT((C125-C126)/365.25)","v":120},null,null,"Actual","Male","Female","Male 60","Female 60","Male 65","Female 65","Male 60","Female 60","Male 65","Female 65","Male 60","Female 60","Male 65","Female 65"]
["Gender",null,{"$f":"IF(Results!E8=\"M\", \"Male\",\"Female\")","v":"Female"},"Pension factor",null,{"$f":"IF($C$113=\"Male\",G124,H124)","v":17.829999999999998},{"$f":"IF($C$116=\"60\",I124,K124)","v":17.829999999999998},17.829999999999998,{"$f":"IF($C$118=\"NHS\",M124,Q124)","v":20.34},{"$f":"IF($C$118=\"NHS\",N124,R124)","v":20.34},{"$f":"IF($C$118=\"NHS\",O124,S124)","v":17.829999999999998},{"$f":"IF($C$118=\"NHS\",P124,T124)","v":17.829999999999998},{"$f":"VLOOKUP($C$123,$A$4:$G$53,2)","v":20.34},{"$f":"VLOOKUP($C$123,$I$4:$O$53,2)","v":20.34},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$123,$A$59:$G$108,2)","v":18.82},{"$f":"VLOOKUP($C$123,$I$59:$O$108,2)","v":19.87},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,2)","v":16.481745469994721},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,2)","v":17.600000000000001}]
["Relevant date",null,"2020-03-31","Lump sum factor",null,{"$f":"IF($C$113=\"Male\",G125,H125)","v":0.99},0.99,0.99,{"$f":"IF($C$118=\"NHS\",M125,Q125)","v":0.99},{"$f":"IF($C$118=\"NHS\",N125,R125)","v":0.99},{"$f":"IF($C$118=\"NHS\",O125,S125)","v":0.99},{"$f":"IF($C$118=\"NHS\",P125,T125)","v":0.99},{"$f":"VLOOKUP($C$123,$A$4:$G$53,3)","v":0.99},{"$f":"VLOOKUP($C$123,$I$4:$O$53,3)","v":0.99},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,3)","v":0.99},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,3)","v":0.99},{"$f":"VLOOKUP($C$123,$A$59:$G$108,3)","v":0.99},{"$f":"VLOOKUP($C$123,$I$59:$O$108,3)","v":0.99},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,3)","v":0},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,3)","v":0}]
["DOB",null,{"$f":"Results!E9","v":"00:00:00"},"Widow(er)'s pension factor",null,1.59,1.59,1.59,1.54,1.54,1.59,1.59,{"$f":"VLOOKUP($C$123,$A$4:$G$53,4)","v":1.54},{"$f":"VLOOKUP($C$123,$I$4:$O$53,4)","v":1.54},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,4)","v":1.59},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,4)","v":1.59},{"$f":"VLOOKUP($C$123,$A$59:$G$108,4)","v":2.83},{"$f":"VLOOKUP($C$123,$I$59:$O$108,4)","v":0.89},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,4)","v":2.984506987558893},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,4)","v":0.88}]
["NRA",null,{"$f":"IF(Results!E6=\"NHS 1995 Section\",\"60\",\"65\")","v":"65"},"Pre-88 GMP factor",null,3.05,3.61,3.05,3.48,3.05,3.61,3.05,{"$f":"VLOOKUP($C$123,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$123,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,5)","v":3.05},{"$f":"VLOOKUP($C$123,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$123,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,5)","v":2.95}]
["Factors",null,2016,"Post-88 GMP factor",null,0.03,3.61,0.03,3.48,3.05,3.61,0.03,{"$f":"VLOOKUP($C$123,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$123,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,6)","v":0.03},{"$f":"VLOOKUP($C$123,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$123,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,6)","v":0.03}]
["Scheme",null,"NHS","NI Mod factor",null,16.739999999999998,16.739999999999998,16.739999999999998,14.37,14.37,16.739999999999998,16.739999999999998,{"$f":"VLOOKUP($C$123,$A$4:$G$53,6)","v":14.37},{"$f":"VLOOKUP($C$123,$I$4:$O$53,6)","v":14.37},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,6)","v":16.739999999999998},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,7)","v":16.739999999999998},{"$f":"VLOOKUP($C$123,$A$59:$G$108,6)","v":13.91},{"$f":"VLOOKUP($C$123,$I$59:$O$108,6)","v":15.02},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,6)","v":16.239999999999998},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,7)","v":17.46}]
[null,null,null,"GMP Adjustment",null,3.5,0.15,3.5,0.15,0.15,0.15,3.5,{"$f":"VLOOKUP($C$123,$A$4:$G$53,7)","v":0.15},{"$f":"VLOOKUP($C$123,$I$4:$O$53,7)","v":0.15},{"$f":"VLOOKUP($C$123,$Q$4:$W$53,7)","v":0.15},{"$f":"VLOOKUP($C$123,$Y$4:$AF$53,8)","v":3.5},{"$f":"VLOOKUP($C$123,$A$59:$G$108,7)","v":0.15},{"$f":"VLOOKUP($C$123,$I$59:$O$108,7)","v":0.15},{"$f":"VLOOKUP($C$123,$Q$59:$W$108,7)","v":0.15},{"$f":"VLOOKUP($C$123,$Y$59:$AF$108,8)","v":1}]

{"sheet":"NHS CARE Non Club Factors","index":2,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":true,"merged":[[2,1,3,1],[58,5,58,7],[59,5,59,7],[60,5,60,7],[61,5,61,7],[55,5,55,7],[55,8,55,9],[57,5,57,7]]}
[]
[null,"Table TV1 Member and Dependant CETV factors"]
[null,"Years to PNPA (rounded up)","Pension factor","Surviving Partner's Pension factor"]
[null,null,"(Factor A)","(Factor B)"]
[null,1,17.079999999999998,1.6]
[null,2,16.649999999999999,1.6]
[null,3,16.239999999999998,1.6]
[null,4,15.72,1.61]
[null,5,15.22,1.61]
[null,6,14.74,1.61]
[null,7,14.27,1.61]
[null,8,13.94,1.6]
[null,9,13.62,1.59]
[null,10,13.31,1.58]
[null,11,13.01,1.57]
[null,12,12.72,1.56]
[null,13,12.44,1.54]
[null,14,12.17,1.52]
[null,15,11.9,1.51]
[null,16,11.64,1.49]
[null,17,11.39,1.47]
[null,18,11.15,1.45]
[null,19,10.91,1.43]
[null,20,10.68,1.41]
[null,21,10.45,1.39]
[null,22,10.14,1.38]
[null,23,9.84,1.36]
[null,24,9.5500000000000007,1.35]
[null,25,9.27,1.33]
[null,26,9.08,1.31]
[null,27,8.89,1.29]
[null,28,8.7100000000000009,1.27]
[null,29,8.5299999999999994,1.25]
[null,30,8.35,1.22]
[null,31,8.18,1.2]
[null,32,8.01,1.18]
[null,33,7.85,1.1499999999999999]
[null,34,7.69,1.1299999999999999]
[null,35,7.53,1.1000000000000001]
[null,36,7.37,1.08]
[null,37,7.22,1.06]
[null,38,7.08,1.03]
[null,39,6.93,1.01]
[null,40,6.79,0.99]
[null,41,6.65,0.97]
[null,42,6.52,0.94]
[null,43,6.39,0.92]
[null,44,6.26,0.9]
[null,45,6.13,0.88]
[null,46,6,0.86]
[null,47,5.88,0.84]
[null,48,5.76,0.82]
[null,49,5.64,0.8]
[null,50,5.53,0.75]
[]
[null,null,null,null,null,"CARE NRA",null,null,{"$f":"(DATE(YEAR(Results!E9)+Results!E10,MONTH(Results!E9)+Results!F10,DAY(Results!E9)))","v":"00:00:00"}]
[]
[null,null,null,null,null,"Relevant Date",null,null,"2019-03-31","2020-03-31"]
[null,null,null,null,null,"Pension Factor",null,null,{"$f":"VLOOKUP($I$62,B5:C54,2)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP($J$62,B5:C54,2)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,"Partner's Factor",null,null,{"$f":"VLOOKUP($I$62,B5:D54,3)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP($J$62,B5:D54,3)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,"Age",null,null,{"$f":"Results!K8","v":119},{"$f":"Results!K9","v":120}]
[null,null,null,null,null,"Years to NPA (rounded up)",null,null,{"$f":"DATEDIF(I58, I56, \"y\")+1","v":{"$error":"#NUM!"}},{"$f":"DATEDIF(J58, I56, \"y\")+1","v":{"$error":"#NUM!"}}]