{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Results","Teachers Non Club Factors","STPS STSS Non Club Factors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":49,"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":52,"n_cols":44,"rows_kept":52,"cut":false,"hidden":false,"merged":[[11,16,11,17],[35,1,35,2],[38,21,38,22],[30,13,31,17],[30,6,30,8],[31,1,31,2],[42,19,42,20],[42,21,42,22],[38,19,38,20],[39,19,39,20],[40,19,40,20],[35,3,35,4],[33,9,33,10],[34,9,34,10],[37,2,38,6],[30,1,30,2],[16,9,16,10],[14,9,14,10],[13,6,13,8],[12,6,12,10],[13,9,13,10],[27,1,27,3],[18,1,18,2],[17,1,17,2],[42,26,42,27],[10,20,10,21],[35,9,35,10],[33,1,33,2],[34,1,34,2],[32,2,32,3],[31,6,31,8],[31,9,31,10],[31,3,31,4],[35,6,35,8],[34,6,34,8],[33,6,33,8],[28,9,28,10],[19,3,19,4],[19,1,19,2],[17,6,17,8],[17,9,17,10],[21,3,21,4],[21,1,21,2],[42,2,42,5],[30,9,30,10],[30,3,30,4],[33,3,33,4],[34,3,34,4],[40,26,40,27],[41,2,41,5],[39,21,39,22],[40,21,40,22],[29,1,29,2],[18,3,18,4],[27,6,27,8],[18,9,18,10],[20,1,20,2],[20,3,20,4],[26,1,26,2],[24,1,24,2],[12,1,12,4],[29,6,29,8],[28,6,28,8],[29,9,29,10],[29,3,29,4],[26,6,26,8],[28,3,28,4],[25,6,25,8],[26,9,26,10],[25,9,25,10],[22,1,22,2],[22,3,22,4],[4,9,4,10],[6,9,6,10],[6,6,6,8],[7,6,7,8],[9,1,9,4],[7,19,7,22],[7,9,7,10],[9,19,9,22],[6,19,6,22],[44,19,44,20],[44,21,44,22],[43,19,43,20],[0,19,0,20],[1,19,1,20],[2,19,2,20],[26,3,26,4],[14,1,14,2],[13,3,13,4],[13,1,13,2],[14,3,14,4],[4,1,4,2],[5,1,5,2],[7,1,7,2],[6,1,6,2],[24,3,24,4],[17,3,17,4],[16,1,16,2],[16,3,16,4],[2,0,3,11],[3,19,3,22],[10,1,11,4],[10,6,11,10],[43,21,43,22],[17,43,17,54],[24,43,24,79],[0,0,1,11],[23,3,23,4],[23,1,23,2],[11,14,11,15],[16,6,16,8],[18,6,18,8],[4,26,4,27],[14,6,14,8],[4,19,4,22],[4,3,4,4],[4,24,4,25],[10,15,10,16],[8,1,8,2],[4,6,4,8],[5,3,5,4],[11,24,13,24],[11,21,11,22],[11,19,11,20],[6,3,6,4],[7,3,7,4],[5,19,5,22],[8,6,9,10],[51,1,51,7],[51,9,51,10],[48,1,48,7],[47,1,47,7],[39,6,39,8],[40,6,40,8],[41,6,41,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[45,6,45,8],[50,9,50,10],[50,1,50,7],[49,1,49,7],[47,9,47,10],[48,9,48,10],[49,9,49,10],[39,2,39,5],[40,2,40,5],[43,2,43,5],[44,2,44,5],[45,2,45,5]]}
["Teachers Pension Scheme(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"NRA60",null,365,"M",{"$f":"(D15/V1)+B15","v":0},0.5,60,null,null,{"$f":"IF(Results!D5=\"NHS 1995 Section\",\"60\",IF(Results!D5=\"NHS 2008 Section\",\"65\"))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"NRA65",null,122,"F",{"$f":"(J15/V1)+G15","v":0},0.375]
["Resource Account Calculator for Unprotected Members to 31/07/2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS 2015 Section"]
[]
[null," Final Salary Pension Scheme",null,"Choose",null,null," Inflation Rate",null,null,0.10100000000000001,null,null,null,null,{"$f":"B15+(D15/365)","v":0}]
[null," Name",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Results!D5=\"NHS 2008 Section\",\"60\",IF(Results!D5=\"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," Gender",null,"Choose",null,null," Age at Start of Period",null,null,{"$f":"'Teachers Non Club Factors'!C111","v":122}]
[null," Date of Birth",null,null,null,null," Age at End of Period ",null,null,{"$f":"'Teachers Non Club Factors'!C122","v":123},null,null,null,null,null,null,null,null,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," 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,2,"Final Salary Service @ 31/03/2015"]
[null,"Start of Period - 31/07/2022",null,null,null,null,"End of Period - 31/07/2023",null,null,null,null,null,null,null,null,"2016/2017",null,null,null,null,"2022/2023"]
[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,"Final Salary Service",null,null,null,null,"Final Salary Service"]
[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,0,null,0,null,2,{"$f":"B15","v":0},null,null,{"$f":"D15","v":0},null,8,null,"Pension",null,null,null,null,null,{"$f":"IF(D5=T1,ROUND((D25/S2)*X1,2),ROUND((D25/S1)*X1,2))","v":0},{"$f":"AA45","v":0},{"$f":"IF(D5=T1,ROUND((J19/S2)*X2,2),ROUND((J19/S1)*X2,2))","v":0},{"$f":"AA46","v":0},{"$f":"(V15+W15)-(T15+U15)","v":0},{"$f":"(T15+U15)*J5","v":0},{"$f":"(T15+U15)+Y15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"IF(D5=T1,(T15*3),0)","v":0},null,{"$f":"IF(D5=T1,(V15*3),0)","v":0},null,{"$f":"(V16+W16)-(T16+U16)","v":0},{"$f":"(T16+U16)*J5","v":0},{"$f":"(T16+U16)+Y16","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,"CARE Earnings April 15 - March 16",null,0,null,3,"CARE Earnings August 22 - March 23",null,null,0,null,9,null,"Spouse",null,null,null,null,null,{"$f":"IF(D5=T1,(T15*Y1),(T15*Y2))","v":0},{"$f":"U15*0.375","v":0},{"$f":"IF(D5=T1,(V15*Y1),(V15*Y2))","v":0},{"$f":"W15*0.375","v":0},{"$f":"(V17+W17)-(T17+U17)","v":0}]
[null,"CARE Earnings April 16 - March 17",null,0,null,4,"CARE Earnings April 23 - July 23",null,null,0,null,10,null,null,null,null,null,null,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 Whole-Time Equivalent salary for 01/04/2017 - 31/03/2018 (if the member is full-time, this should match cell 5)"]
[null,"CARE Earnings April 17 - March 18",null,0,null,5,"FS Link Pensionable Pay @ 31/07/23",null,null,0,null,11,null,"Factors",null,null,null,null,null,null,null,null," "]
[null,"CARE Earnings April 18 - March 19",null,0,null,6]
[null,"CARE Earnings April 19 - March 20",null,0]
[null,"CARE Earnings April 20 - March 21",null,0]
[null,"CARE Earnings April 21 - March 22",null,0]
[null,"CARE Earnings April 22 - July 22",null,0]
[null,"FS Link Pensionable Pay @ 31/07/22",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,7,"These cells will automatically be populated with the same service as cells 2. As members cannot acrue 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,"Pension",null,null,null,null,null,{"$f":"'Teachers Non Club Factors'!F112","v":17.77},{"$f":"'STPS STSS Non Club Factors'!D11","v":false},{"$f":"'Teachers Non Club Factors'!F123","v":17.77},{"$f":"'STPS STSS Non Club Factors'!BB26","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"The actual pensionable earnings for 01/04/2018 - 31/03/2018"]
[null,"Benefits (without inflation)",null,null,null,null,null,null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"'Teachers Non Club Factors'!F113","v":0},null,{"$f":"'Teachers Non Club Factors'!F124","v":0}]
[null," Final Salary Pension",null,{"$f":"T15","v":0},null,null," Final Salary Pension",null,null,{"$f":"V15","v":0},null,null,null,"Spouse",null,null,null,null,null,{"$f":"'Teachers Non Club Factors'!F114","v":1.55},{"$f":"'STPS STSS Non Club Factors'!D13","v":false},{"$f":"'Teachers Non Club Factors'!F125","v":1.55},{"$f":"'STPS STSS Non Club Factors'!BB28","v":false},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"The Whole-Time Equivalent salary for 01/04/2018 - 31/03/2019 (if the member is full-time, this should match cell 8)"]
[null," Care Pension",null,{"$f":"U15","v":0},null,null," Care Pension",null,null,{"$f":"W15","v":0},null,null,null,"Care Adjust Factor",null,null,null,null,null,null,1,null,1]
[null," Total Pension",null,{"$f":"SUM(D29:E30)","v":0},null,null," Total Pension",null,null,{"$f":"SUM(J29:K30)","v":0}]
[null," Lump Sum",null,{"$f":"T45","v":0},null,null," Lump Sum",null,null,{"$f":"V45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(T15)*T27","v":0},{"$f":"U15*U27","v":0},0,0]
[null," Final Salary CETV",null,{"$f":"T37","v":0},null,null," Final Salary CETV",null,null,{"$f":"V37","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(T16)*T28","v":0},0,0,0]
[null," Care CETV",null,{"$f":"U37","v":0},null,null," Care CETV",null,null,{"$f":"W37","v":0},null,null,null,null,null,null,null,null,null,{"$f":"T17*T29","v":0},0,0,0]
[null," Total CETV",null,{"$f":"SUM(D34:E35)","v":0},null,null," Total CETV",null,null,{"$f":"SUM(J34:K35)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U33:U35)","v":0},null,{"$f":"SUM(W33:W35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T33:T35)","v":0},{"$f":"U36*U30","v":0},{"$f":"SUM(V33:V35)","v":0},{"$f":"W36*W30","v":0},null,"Scheme Year","CARE Pension"]
[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":"(D17/57)*1.015","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T37+U37","v":0},null,{"$f":"V37+W37","v":0},null,null,"16/17",{"$f":"((D18/57)+Z38)*1.026","v":0}]
[null,null," Real Increase in Pension",null,null,null,{"$f":"(V15+W15)-Z15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T39*J5","v":0},null,null,null,null,"17/18",{"$f":"((D19/57)+Z39)*1.046","v":0}]
[null,null," Real Increase in Lump Sum",null,null,null,{"$f":"V16-Z16","v":0},null,null,null,null,null,null,"With Inflation",null,null,null,null,null,{"$f":"T39+T40","v":0},null,null,null,null,"18/19",{"$f":"((D20/57)+Z40)*1.04","v":0}]
[null,null," Accrued Pension",null,null,null,{"$f":"J31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19/20",{"$f":"((D21/57)+Z41)*1.033","v":0}]
[null,null," Accrued Lump Sum",null,null,null,{"$f":"V45","v":0},null,null,null,null,null,null,"CETV",null,null,null,null,null,{"$f":"T41","v":0},null,{"$f":"V39","v":0},null,null,"20/21",{"$f":"((D22/57)+Z42)*1.021","v":0},"Part Years"]
[null,null," CETV at start of period",null,null,null,{"$f":"T41","v":0},null,null,null,null,null,null,"Pension",null,null,null,null,null,{"$f":"T15+U15","v":0},null,{"$f":"V15+W15","v":0},null,null,"21/22",{"$f":"((D23/57)+Z43)*1.047","v":0},"Apr - Jul","Aug - Mar"]
[null,null," CETV at end of period",null,null,null,{"$f":"J36","v":0},null,null,null,null,null,null,"Lump Sum",null,null,null,null,null,{"$f":"T16+U16","v":0},null,{"$f":"V16+W16","v":0},null,null,"22/23",{"$f":"(((D24+J17)/57)+Z44)*1.117","v":0},{"$f":"((D24/57)+Z44)*1.117","v":0},{"$f":"(((J18+D24)/57)+Z44)*1.117","v":0}]
[null,null," Real Increase in CETV",null,null,null,{"$f":"G45-G44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23/24",{"$f":"(J18/57)+Z45","v":0},{"$f":"((J18/57)+Z45)","v":0},0]
[]
[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":"G42","v":0}]
[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":"V45","v":0}]
[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":"Z15","v":0}]
[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":"Z16","v":0}]
[null,"Annual Increase to total Remuneration package",null,null,null,null,null,null,null,{"$f":"SUM((20*J48)+J49)-((20*J50)+J51)","v":0}]

{"sheet":"Teachers Non Club Factors","index":1,"n_rows":129,"n_cols":32,"rows_kept":129,"cut":false,"hidden":true,"merged":[[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],[120,16,120,19],[121,0,121,1],[120,0,120,11],[109,12,109,15],[109,16,109,19],[110,0,110,1],[111,0,111,1],[112,0,112,1],[113,0,113,1],[109,0,109,11],[127,0,127,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[120,12,120,15],[122,0,122,1],[123,0,123,1],[124,0,124,1],[125,0,125,1],[126,0,126,1]]}
["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,8.56,0.39,0.76,3.5,4.72,0.15,null,20,8.56,0.39,0.76,3.02,5.1100000000000003,0.15,null,20,6.76,0,0.78,3.5,4.72,0.15,null,20,6.76,0,0.78,-0.84,-0.84,5.1100000000000003,3.5]
[21,8.75,0.4,0.78,3.49,4.8499999999999996,0.15,null,21,8.75,0.4,0.78,3.01,5.25,0.15,null,21,6.91,0,0.79,3.49,4.8499999999999996,0.15,null,21,6.91,0,0.79,-0.86,-0.86,5.25,3.5]
[22,8.94,0.41,0.8,3.49,4.9800000000000004,0.15,null,22,8.94,0.41,0.8,3.01,5.39,0.15,null,22,7.05,0,0.81,3.49,4.9800000000000004,0.15,null,22,7.05,0,0.81,-0.87,-0.87,5.39,3.5]
[23,9.1300000000000008,0.42,0.82,3.48,5.12,0.15,null,23,9.1300000000000008,0.42,0.82,3.01,5.54,0.15,null,23,7.21,0,0.83,3.48,5.12,0.15,null,23,7.21,0,0.83,-0.89,-0.89,5.54,3.5]
[24,9.33,0.43,0.84,3.48,5.26,0.15,null,24,9.33,0.43,0.84,3,5.69,0.15,null,24,7.36,0,0.85,3.48,5.26,0.15,null,24,7.36,0,0.85,-0.9,-0.9,5.69,3.5]
[25,9.5399999999999991,0.44,0.86,3.47,5.4,0.15,null,25,9.5399999999999991,0.44,0.86,3,5.85,0.15,null,25,7.52,0,0.87,3.47,5.4,0.15,null,25,7.52,0,0.87,-0.92,-0.92,5.85,3.5]
[26,9.75,0.45,0.88,3.46,5.55,0.15,null,26,9.75,0.45,0.88,2.99,6.01,0.15,null,26,7.68,0,0.89,3.46,5.55,0.15,null,26,7.68,0,0.89,-0.93,-0.93,6.01,3.5]
[27,9.9600000000000009,0.46,0.89,3.46,5.7,0.15,null,27,9.9600000000000009,0.46,0.89,2.99,6.18,0.15,null,27,7.84,0,0.91,3.46,5.7,0.15,null,27,7.84,0,0.91,-0.95,-0.95,6.18,3.5]
[28,10.18,0.47,0.91,3.45,5.85,0.15,null,28,10.18,0.47,0.91,2.99,6.35,0.15,null,28,8.01,0,0.93,3.45,5.85,0.15,null,28,8.01,0,0.93,-0.96,-0.96,6.35,3.5]
[29,10.4,0.49,0.93,3.45,6.01,0.15,null,29,10.4,0.49,0.93,2.98,6.53,0.15,null,29,8.18,0,0.95,3.45,6.01,0.15,null,29,8.18,0,0.95,-0.98,-0.98,6.53,3.5]
[30,10.63,0.5,0.96,3.44,6.18,0.15,null,30,10.63,0.5,0.96,2.98,6.71,0.15,null,30,8.36,0,0.97,3.44,6.18,0.15,null,30,8.36,0,0.97,-0.99,-0.99,6.71,3.5]
[31,10.87,0.51,0.98,3.44,6.35,0.15,null,31,10.87,0.51,0.98,2.97,6.89,0.15,null,31,8.5399999999999991,0,0.99,3.44,6.35,0.15,null,31,8.5399999999999991,0,0.99,-1.01,-1.01,6.89,3.5]
[32,11.1,0.52,1,3.43,6.52,0.15,null,32,11.1,0.52,1,2.97,7.08,0.15,null,32,8.7200000000000006,0,1.02,3.43,6.52,0.15,null,32,8.7200000000000006,0,1.02,-1.02,-1.02,7.08,3.5]
[33,11.35,0.53,1.02,3.43,6.7,0.15,null,33,11.35,0.53,1.02,2.97,7.28,0.15,null,33,8.91,0,1.04,3.43,6.7,0.15,null,33,8.91,0,1.04,-1.04,-1.04,7.28,3.5]
[34,11.6,0.55000000000000004,1.04,3.42,6.88,0.15,null,34,11.6,0.55000000000000004,1.04,2.96,7.48,0.15,null,34,9.1,0,1.06,3.42,6.88,0.15,null,34,9.1,0,1.06,-1.05,-1.05,7.48,3.5]
[35,11.85,0.56000000000000005,1.06,3.42,7.07,0.15,null,35,11.85,0.56000000000000005,1.06,2.96,7.69,0.15,null,35,9.2899999999999991,0,1.08,3.42,7.07,0.15,null,35,9.2899999999999991,0,1.08,-1.07,-1.07,7.69,3.5]
[36,12.12,0.56999999999999995,1.08,3.41,7.27,0.15,null,36,12.12,0.56999999999999995,1.08,2.95,7.9,0.15,null,36,9.49,0,1.1000000000000001,3.41,7.27,0.15,null,36,9.49,0,1.1000000000000001,-1.0900000000000001,-1.0900000000000001,7.9,3.5]
[37,12.38,0.59,1.1000000000000001,3.41,7.47,0.15,null,37,12.38,0.59,1.1000000000000001,2.95,8.1199999999999992,0.15,null,37,9.6999999999999993,0,1.1200000000000001,3.41,7.47,0.15,null,37,9.6999999999999993,0,1.1200000000000001,-1.1000000000000001,-1.1000000000000001,8.1199999999999992,3.5]
[38,12.66,0.6,1.1200000000000001,3.4,7.67,0.15,null,38,12.66,0.6,1.1200000000000001,2.95,8.35,0.15,null,38,9.91,0,1.1399999999999999,3.4,7.67,0.15,null,38,9.91,0,1.1399999999999999,-1.1200000000000001,-1.1200000000000001,8.35,3.5]
[39,12.94,0.62,1.1399999999999999,3.4,7.89,0.15,null,39,12.94,0.62,1.1399999999999999,2.94,8.58,0.15,null,39,10.119999999999999,0,1.17,3.4,7.89,0.15,null,39,10.119999999999999,0,1.17,-1.1299999999999999,-1.1299999999999999,8.58,3.5]
[40,13.23,0.63,1.1599999999999999,3.4,8.11,0.15,null,40,13.23,0.63,1.1599999999999999,2.94,8.82,0.15,null,40,10.34,0,1.19,3.4,8.11,0.15,null,40,10.34,0,1.19,-1.1499999999999999,-1.1499999999999999,8.82,3.5]
[41,13.52,0.64,1.18,3.39,8.33,0.15,null,41,13.52,0.64,1.18,2.94,9.06,0.15,null,41,10.57,0,1.21,3.39,8.33,0.15,null,41,10.57,0,1.21,-1.17,-1.17,9.06,3.5]
[42,13.82,0.66,1.2,3.39,8.57,0.15,null,42,13.82,0.66,1.2,2.93,9.32,0.15,null,42,10.8,0,1.23,3.39,8.57,0.15,null,42,10.8,0,1.23,-1.18,-1.18,9.32,3.5]
[43,14.13,0.68,1.22,3.39,8.81,0.15,null,43,14.13,0.68,1.22,2.93,9.58,0.15,null,43,11.03,0,1.25,3.39,8.81,0.15,null,43,11.03,0,1.25,-1.2,-1.2,9.58,3.5]
[44,14.45,0.69,1.24,3.39,9.06,0.15,null,44,14.45,0.69,1.24,2.93,9.84,0.15,null,44,11.27,0,1.27,3.39,9.06,0.15,null,44,11.27,0,1.27,-1.22,-1.22,9.84,3.5]
[45,14.77,0.71,1.26,3.38,9.31,0.15,null,45,14.77,0.71,1.26,2.92,10.119999999999999,0.15,null,45,11.52,0,1.29,3.38,9.31,0.15,null,45,11.52,0,1.29,-1.23,-1.23,10.119999999999999,3.5]
[46,15.1,0.73,1.28,3.38,9.58,0.15,null,46,15.1,0.73,1.28,2.92,10.4,0.15,null,46,11.77,0,1.31,3.38,9.58,0.15,null,46,11.77,0,1.31,-1.25,-1.25,10.4,3.5]
[47,15.44,0.74,1.3,3.38,9.85,0.15,null,47,15.44,0.74,1.3,2.92,10.69,0.15,null,47,12.03,0,1.33,3.38,9.85,0.15,null,47,12.03,0,1.33,-1.27,-1.27,10.69,3.5]
[48,15.79,0.76,1.32,3.38,10.119999999999999,0.15,null,48,15.79,0.76,1.32,2.91,10.99,0.15,null,48,12.29,0,1.35,3.38,10.119999999999999,0.15,null,48,12.29,0,1.35,-1.28,-1.28,10.99,3.5]
[49,16.149999999999999,0.78,1.34,3.37,10.41,0.15,null,49,16.149999999999999,0.78,1.34,2.91,11.3,0.15,null,49,12.57,0,1.38,3.37,10.41,0.15,null,49,12.57,0,1.38,-1.3,-1.3,11.3,3.5]
[50,16.52,0.8,1.36,3.37,10.71,0.15,null,50,16.52,0.8,1.36,2.91,11.62,0.15,null,50,12.84,0,1.4,3.37,10.71,0.15,null,50,12.84,0,1.4,-1.32,-1.32,11.62,3.5]
[51,16.89,0.82,1.38,3.37,11.01,0.15,null,51,16.89,0.82,1.38,2.9,11.95,0.15,null,51,13.13,0,1.41,3.37,11.01,0.15,null,51,13.13,0,1.41,-1.34,-1.34,11.95,3.5]
[52,17.28,0.84,1.4,3.37,11.33,0.15,null,52,17.28,0.84,1.4,2.9,12.29,0.15,null,52,13.42,0,1.43,3.37,11.33,0.15,null,52,13.42,0,1.43,-1.36,-1.36,12.29,3.5]
[53,17.68,0.86,1.42,3.37,11.66,0.15,null,53,17.68,0.86,1.42,2.9,12.64,0.15,null,53,13.72,0,1.45,3.37,11.66,0.15,null,53,13.72,0,1.45,-1.37,-1.37,12.64,3.5]
[54,18.09,0.88,1.43,3.37,12,0.15,null,54,18.09,0.88,1.43,2.9,13,0.15,null,54,14.04,0,1.47,3.37,12,0.15,null,54,14.04,0,1.47,-1.39,-1.39,13,3.5]
[55,18.510000000000002,0.9,1.45,3.37,12.35,0.15,null,55,18.510000000000002,0.9,1.45,2.9,13.38,0.15,null,55,14.36,0,1.48,3.37,12.35,0.15,null,55,14.36,0,1.48,-1.41,-1.41,13.38,3.5]
[56,18.95,0.92,1.46,3.38,12.72,0.15,null,56,18.95,0.92,1.46,2.9,13.77,0.15,null,56,14.68,0,1.5,3.38,12.72,0.15,null,56,14.68,0,1.5,-1.43,-1.43,13.77,3.5]
[57,19.399999999999999,0.94,1.47,3.38,13.1,0.15,null,57,19.399999999999999,0.94,1.47,2.9,14.17,0.15,null,57,15.03,0,1.51,3.38,13.1,0.15,null,57,15.03,0,1.51,-1.45,-1.45,14.17,3.5]
[58,19.87,0.97,1.48,3.38,13.49,0.15,null,58,19.87,0.97,1.48,2.9,14.59,0.15,null,58,15.38,0,1.52,3.38,13.49,0.15,null,58,15.38,0,1.52,-1.47,-1.47,14.59,3.5]
[59,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,59,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,59,15.74,0,1.53,3.39,13.91,0.15,null,59,15.74,0,1.53,-1.53,-1.53,15.02,3.5]
[60,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,60,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,60,16.12,0,1.54,3.39,14.33,0.15,null,60,16.12,0,1.54,-1.1000000000000001,-3.72,15.47,1]
[61,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,61,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,61,16.5,0,1.54,3.4,14.78,0.15,null,61,16.5,0,1.54,-0.14000000000000001,-2.82,15.94,1]
[62,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,62,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,62,16.91,0,1.55,3.41,15.25,0.15,null,62,16.91,0,1.55,0.86,-1.9,16.420000000000002,1]
[63,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,63,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,63,17.329999999999998,0,1.55,3.42,15.73,0.15,null,63,17.329999999999998,0,1.55,1.89,-0.95,16.93,1]
[64,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,64,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,64,17.77,0,1.55,3.51,16.239999999999998,0.15,null,64,17.77,0,1.55,2.95,0.03,17.46,1]
[65,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,65,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,65,17.77,0,1.55,3.51,16.239999999999998,0.15,null,65,17.77,0,1.55,2.95,0.03,17.46,1]
[66,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,66,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,66,17.77,0,1.55,3.51,16.239999999999998,0.15,null,66,17.77,0,1.55,2.95,0.03,17.46,1]
[67,20.350000000000001,0.99,1.49,3.39,13.91,0.15,null,67,20.350000000000001,0.99,1.49,2.97,15.02,0.15,null,67,17.77,0,1.55,3.51,16.239999999999998,0.15,null,67,17.77,0,1.55,2.95,0.03,17.46,1]
[]
["Factors at 31/07/2019",null,null,null,null,null,null,null,null,null,null,null,"NHS",null,null,null,"STSS"]
["Age",null,{"$f":"INT((C113-C114)/365.25)","v":122},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!D7=\"M\", \"Male\",\"Female\")","v":"Female"},"Pension factor",null,{"$f":"IF($C$112=\"Male\",G112,H112)","v":17.77},{"$f":"IF($C$115=\"60\",I112,K112)","v":17.77},17.77,{"$f":"IF($C$117=\"NHS\",M112,Q112)","v":20.350000000000001},20.350000000000001,17.77,17.77,{"$f":"VLOOKUP($C$111,$A$4:$G$53,2)","v":20.34},{"$f":"VLOOKUP($C$111,$I$4:$O$53,2)","v":20.34},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$111,$A$59:$G$108,2)","v":20.350000000000001},{"$f":"VLOOKUP($C$111,$I$59:$O$108,2)","v":20.350000000000001},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,2)","v":17.77},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,2)","v":17.77}]
["Relevant date",null,"2022-07-31","Lump sum factor",null,{"$f":"IF($C$112=\"Male\",G113,H113)","v":0},0,0,0.99,0.99,0,0,{"$f":"VLOOKUP($C$111,$A$4:$G$53,3)","v":0.99},{"$f":"VLOOKUP($C$111,$I$4:$O$53,3)","v":0.99},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,3)","v":0.99},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,3)","v":0.99},{"$f":"VLOOKUP($C$111,$A$59:$G$108,3)","v":0.99},{"$f":"VLOOKUP($C$111,$I$59:$O$108,3)","v":0.99},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,3)","v":0},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,3)","v":0}]
["DOB",null,{"$f":"Results!D8","v":"00:00:00"},"Widow(er)'s pension factor",null,1.55,1.55,1.55,1.49,1.49,1.55,1.55,{"$f":"VLOOKUP($C$111,$A$4:$G$53,4)","v":1.54},{"$f":"VLOOKUP($C$111,$I$4:$O$53,4)","v":1.54},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,4)","v":1.59},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,4)","v":1.59},{"$f":"VLOOKUP($C$111,$A$59:$G$108,4)","v":1.49},{"$f":"VLOOKUP($C$111,$I$59:$O$108,4)","v":1.49},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,4)","v":1.55},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,4)","v":1.55}]
["NRA",null,{"$f":"IF(Results!D5=\"NRA60\",\"60\",\"65\")","v":"65"},"Pre-88 GMP factor",null,2.95,3.51,2.95,3.39,2.97,3.51,2.95,{"$f":"VLOOKUP($C$111,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$111,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,5)","v":3.05},{"$f":"VLOOKUP($C$111,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$111,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,5)","v":2.95}]
["Factors",null,2018,"Post-88 GMP factor",null,0.03,3.51,0.03,3.39,2.97,3.51,0.03,{"$f":"VLOOKUP($C$111,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$111,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,6)","v":0.03},{"$f":"VLOOKUP($C$111,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$111,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,6)","v":0.03}]
["Scheme",null,"STSS","NI Mod factor",null,17.46,16.239999999999998,17.46,13.91,15.02,16.239999999999998,17.46,{"$f":"VLOOKUP($C$111,$A$4:$G$53,6)","v":14.37},{"$f":"VLOOKUP($C$111,$I$4:$O$53,6)","v":14.37},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,6)","v":16.739999999999998},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,7)","v":16.739999999999998},{"$f":"VLOOKUP($C$111,$A$59:$G$108,6)","v":13.91},{"$f":"VLOOKUP($C$111,$I$59:$O$108,6)","v":15.02},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,6)","v":16.239999999999998},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,7)","v":17.46}]
[null,null,null,"GMP Adjustment",null,1,0.15,1,0.15,0.15,0.15,1,{"$f":"VLOOKUP($C$111,$A$4:$G$53,7)","v":0.15},{"$f":"VLOOKUP($C$111,$I$4:$O$53,7)","v":0.15},{"$f":"VLOOKUP($C$111,$Q$4:$W$53,7)","v":0.15},{"$f":"VLOOKUP($C$111,$Y$4:$AF$53,8)","v":3.5},{"$f":"VLOOKUP($C$111,$A$59:$G$108,7)","v":0.15},{"$f":"VLOOKUP($C$111,$I$59:$O$108,7)","v":0.15},{"$f":"VLOOKUP($C$111,$Q$59:$W$108,7)","v":0.15},{"$f":"VLOOKUP($C$111,$Y$59:$AF$108,8)","v":1}]
[]
[]
["Factor at 31/07/2020",null,null,null,null,null,null,null,null,null,null,null,"NHS",null,null,null,"STSS"]
["Age",null,{"$f":"INT((C124-C125)/365.25)","v":123},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!D7=\"M\", \"Male\",\"Female\")","v":"Female"},"Pension factor",null,{"$f":"IF($C$112=\"Male\",G123,H123)","v":17.77},{"$f":"IF($C$115=\"60\",I123,K123)","v":17.77},17.77,{"$f":"IF($C$117=\"NHS\",M123,Q123)","v":20.350000000000001},{"$f":"IF($C$117=\"NHS\",N123,R123)","v":20.350000000000001},{"$f":"IF($C$117=\"NHS\",O123,S123)","v":17.77},{"$f":"IF($C$117=\"NHS\",P123,T123)","v":17.77},{"$f":"VLOOKUP($C$122,$A$4:$G$53,2)","v":20.34},{"$f":"VLOOKUP($C$122,$I$4:$O$53,2)","v":20.34},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,2)","v":17.829999999999998},{"$f":"VLOOKUP($C$122,$A$59:$G$108,2)","v":20.350000000000001},{"$f":"VLOOKUP($C$122,$I$59:$O$108,2)","v":20.350000000000001},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,2)","v":17.77},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,2)","v":17.77}]
["Relevant date",null,"2023-07-31","Lump sum factor",null,{"$f":"IF($C$112=\"Male\",G124,H124)","v":0},0,0,{"$f":"IF($C$117=\"NHS\",M124,Q124)","v":0.99},{"$f":"IF($C$117=\"NHS\",N124,R124)","v":0.99},{"$f":"IF($C$117=\"NHS\",O124,S124)","v":0},{"$f":"IF($C$117=\"NHS\",P124,T124)","v":0},{"$f":"VLOOKUP($C$122,$A$4:$G$53,3)","v":0.99},{"$f":"VLOOKUP($C$122,$I$4:$O$53,3)","v":0.99},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,3)","v":0.99},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,3)","v":0.99},{"$f":"VLOOKUP($C$122,$A$59:$G$108,3)","v":0.99},{"$f":"VLOOKUP($C$122,$I$59:$O$108,3)","v":0.99},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,3)","v":0},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,3)","v":0}]
["DOB",null,{"$f":"Results!D8","v":"00:00:00"},"Widow(er)'s pension factor",null,1.55,1.55,1.55,1.49,1.49,1.55,1.55,{"$f":"VLOOKUP($C$122,$A$4:$G$53,4)","v":1.54},{"$f":"VLOOKUP($C$122,$I$4:$O$53,4)","v":1.54},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,4)","v":1.59},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,4)","v":1.59},{"$f":"VLOOKUP($C$122,$A$59:$G$108,4)","v":1.49},{"$f":"VLOOKUP($C$122,$I$59:$O$108,4)","v":1.49},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,4)","v":1.55},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,4)","v":1.55}]
["NRA",null,{"$f":"IF(Results!D5=\"NRA60\",\"60\",\"65\")","v":"65"},"Pre-88 GMP factor",null,2.95,3.51,2.95,3.39,2.97,3.51,2.95,{"$f":"VLOOKUP($C$122,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$122,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,5)","v":3.05},{"$f":"VLOOKUP($C$122,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$122,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,5)","v":2.95}]
["Factors",null,2018,"Post-88 GMP factor",null,0.03,3.51,0.03,3.39,2.97,3.51,0.03,{"$f":"VLOOKUP($C$122,$A$4:$G$53,5)","v":3.48},{"$f":"VLOOKUP($C$122,$I$4:$O$53,5)","v":3.05},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,5)","v":3.61},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,6)","v":0.03},{"$f":"VLOOKUP($C$122,$A$59:$G$108,5)","v":3.39},{"$f":"VLOOKUP($C$122,$I$59:$O$108,5)","v":2.97},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,5)","v":3.51},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,6)","v":0.03}]
["Scheme",null,"STSS","NI Mod factor",null,17.46,16.239999999999998,17.46,13.91,15.02,16.239999999999998,17.46,{"$f":"VLOOKUP($C$122,$A$4:$G$53,6)","v":14.37},{"$f":"VLOOKUP($C$122,$I$4:$O$53,6)","v":14.37},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,6)","v":16.739999999999998},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,7)","v":16.739999999999998},{"$f":"VLOOKUP($C$122,$A$59:$G$108,6)","v":13.91},{"$f":"VLOOKUP($C$122,$I$59:$O$108,6)","v":15.02},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,6)","v":16.239999999999998},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,7)","v":17.46}]
[null,null,null,"GMP Adjustment",null,1,0.15,1,0.15,0.15,0.15,1,{"$f":"VLOOKUP($C$122,$A$4:$G$53,7)","v":0.15},{"$f":"VLOOKUP($C$122,$I$4:$O$53,7)","v":0.15},{"$f":"VLOOKUP($C$122,$Q$4:$W$53,7)","v":0.15},{"$f":"VLOOKUP($C$122,$Y$4:$AF$53,8)","v":3.5},{"$f":"VLOOKUP($C$122,$A$59:$G$108,7)","v":0.15},{"$f":"VLOOKUP($C$122,$I$59:$O$108,7)","v":0.15},{"$f":"VLOOKUP($C$122,$Q$59:$W$108,7)","v":0.15},{"$f":"VLOOKUP($C$122,$Y$59:$AF$108,8)","v":1}]

{"sheet":"STPS STSS Non Club Factors","index":2,"n_rows":147,"n_cols":70,"rows_kept":147,"cut":false,"hidden":true,"merged":[[0,33,0,39],[0,42,0,48],[16,58,16,59],[16,60,16,61],[16,64,16,65],[11,34,11,36],[11,37,11,38],[11,43,11,45],[16,66,16,67],[16,68,16,69],[13,46,13,47],[14,46,14,47],[5,50,5,51],[11,46,11,47],[1,8,1,9],[1,10,1,11],[1,14,1,15],[1,16,1,17],[1,18,1,19],[1,22,1,23],[2,43,2,44],[2,22,2,23],[2,34,2,35],[2,50,3,58],[3,22,3,23],[4,22,4,23],[6,50,6,51],[7,50,7,51],[8,50,8,51],[8,52,9,58],[17,18,19,18],[13,37,13,38],[14,37,14,38],[16,19,16,25],[17,0,19,0],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,18,6],[17,7,19,7],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[17,13,18,15],[17,16,19,16],[17,34,19,34],[17,36,19,36],[17,19,19,19],[17,20,19,20],[17,21,19,21],[17,22,18,24],[17,25,19,25],[17,27,19,27],[81,0,83,0],[81,1,83,1],[81,2,83,2],[81,3,83,3],[81,4,82,6],[81,13,82,15],[17,46,18,46],[17,47,18,47],[17,48,18,48],[17,49,18,49],[80,19,80,25],[17,37,19,37],[17,38,19,38],[17,39,19,39],[17,40,18,42],[17,43,19,43],[17,45,19,45],[17,28,19,28],[17,29,19,29],[17,30,19,30],[17,31,18,33],[81,7,83,7],[81,9,83,9],[81,10,83,10],[81,11,83,11],[81,12,83,12],[81,31,82,33],[81,16,83,16],[81,18,83,18],[81,19,83,19],[81,20,83,20],[81,21,83,21],[81,22,82,24],[81,25,83,25],[81,27,83,27],[81,28,83,28],[81,29,83,29],[81,30,83,30],[81,43,83,43],[81,34,83,34],[81,36,83,36],[81,37,83,37],[81,38,83,38],[81,39,83,39],[81,40,82,42]]}
[]
[null,"Age",null,{"$f":"INT((D4-D6)/365.25)","v":122},null,null,null,"Actual",2015,null,60,null,65,null,66,null,67,null,68,null,null,{"$f":"VLOOKUP(D9,AT21:AX76,2)","v":1.0129999999999999},"CPI + 1.25% pa"]
[null,"Gender",null,{"$f":"IF(Results!D7=\"M\", \"Male\",\"Female\")","v":"Female"},null,null,null,null,"Male","Female","Male 60","Female 60","Male 65","Female 65","Male ","Female ","Male ","Female ","Male ","Female ",null,{"$f":"VLOOKUP(D9,AT21:AX76,3)","v":1.0149999999999999},"CPI + 1.5% pa",null,null,"Male",null,60,65,66,67,68,null,null,"Inputs",null,null,null,null,null,null,null,null,"Inputs",null,null,null,null,null,null,"Interpolation formula"]
[null,"Relevant date",null,"2022-07-31",null,"Pension factor",null,{"$f":"IF(($D$3=\"Male\"),I4,J4)","v":false},{"$f":"IF($D$7=60,K4,IF($D$7=65,M4,IF($D$7=66,O4,IF($D$7=67,Q4,IF($D$7=68,S4)))))","v":false},false,{"$f":"VLOOKUP($D$2,a,2)","v":20.350000000000001},{"$f":"VLOOKUP($D$2,b,2)","v":20.350000000000001},{"$f":"VLOOKUP($D$2,e,2)","v":17.77},{"$f":"VLOOKUP($D$2,f,2)","v":17.77},{"$f":"VLOOKUP($D$2,g,2)","v":17.23},{"$f":"VLOOKUP($D$2,h,2)","v":17.23},{"$f":"VLOOKUP($D$2,j,2)","v":16.68},{"$f":"VLOOKUP($D$2,k,2)","v":16.68},{"$f":"VLOOKUP($D$2,q,2)","v":0},{"$f":"VLOOKUP($D$2,w,2)","v":16.12},null,{"$f":"VLOOKUP(D9,AT21:AX76,4)","v":1.016},"CPI + 1.6% pa",null,null,"Pension factor",null,{"$f":"VLOOKUP($D$2,a,2)","v":20.350000000000001},{"$f":"VLOOKUP($D$2,e,2)","v":17.77},{"$f":"VLOOKUP($D$2,g,2)","v":17.23},{"$f":"VLOOKUP($D$2,j,2)","v":16.68},{"$f":"VLOOKUP($D$2,q,2)","v":0},null,null,"DOB:",{"$f":"D6","v":"00:00:00"},null,null,null,null,null,null,null,"DOB:",{"$f":"Results!D8","v":"00:00:00"}]
[null,"NPA",null,{"$f":"IF(Results!D5=\"NRA60\",\"60\",\"65\")","v":"65"},null,"Lump sum factor",null,{"$f":"IF(($D$3=\"Male\"),I5,J5)","v":false},false,false,{"$f":"VLOOKUP($D$2,a,3)","v":0.99},{"$f":"VLOOKUP($D$2,b,3)","v":0.99},{"$f":"VLOOKUP($D$2,e,3)","v":0.99},{"$f":"VLOOKUP($D$2,f,3)","v":0.99},{"$f":"VLOOKUP($D$2,g,3)","v":0.99},{"$f":"VLOOKUP($D$2,h,3)","v":0.99},{"$f":"VLOOKUP($D$2,j,3)","v":0.99},{"$f":"VLOOKUP($D$2,f,3)","v":0.99},{"$f":"VLOOKUP($D$2,q,3)","v":0},{"$f":"VLOOKUP($D$2,w,3)","v":0.99},null,{"$f":"VLOOKUP(D9,AT21:AX76,5)","v":1.028},"Earnings",null,null,"Lump sum factor",null,{"$f":"VLOOKUP($D$2,a,3)","v":0.99},{"$f":"VLOOKUP($D$2,e,3)","v":0.99},{"$f":"VLOOKUP($D$2,g,3)","v":0.99},{"$f":"VLOOKUP($D$2,j,3)","v":0.99},{"$f":"VLOOKUP($D$2,q,3)","v":0},null,null,"Relevant date:",{"$f":"D4","v":"2022-07-31"},null,null,null,null,null,null,null,"Relevant date:",{"$f":"BB19","v":"2023-07-31"},null,null,null,null,null,null,"Fp(NPA67,2months =","Fp(NPA67)","+","{ 2 / 12","x","[Fp(NPA68)","-","Fp(NPA67)]}"]
[null,"DOB",null,{"$f":"Results!D8","v":"00:00:00"},null,"Widow(er)'s pension factor",null,false,false,false,{"$f":"VLOOKUP($D$2,a,4)","v":1.49},{"$f":"VLOOKUP($D$2,b,4)","v":1.49},{"$f":"VLOOKUP($D$2,e,4)","v":1.55},{"$f":"VLOOKUP($D$2,f,4)","v":1.55},{"$f":"VLOOKUP($D$2,g,4)","v":1.56},{"$f":"VLOOKUP($D$2,h,4)","v":1.56},{"$f":"VLOOKUP($D$2,j,4)","v":1.56},{"$f":"VLOOKUP($D$2,f,4)","v":1.55},{"$f":"VLOOKUP($D$2,q,4)","v":0},{"$f":"VLOOKUP($D$2,w,4)","v":1.57},null,null,null,null,null,"Widow(er)'s pension factor",null,{"$f":"VLOOKUP($D$2,a,4)","v":1.49},{"$f":"VLOOKUP($D$2,e,4)","v":1.55},{"$f":"VLOOKUP($D$2,g,4)","v":1.56},{"$f":"VLOOKUP($D$2,j,4)","v":1.56},{"$f":"VLOOKUP($D$2,q,4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,8.19,"+","{ 2 / 12","x","[7.72","-","8.19]}"]
[null,"NRA",null,{"$f":"Results!D9","v":0},{"$f":"D7+1","v":1},"Pre-88 GMP factor",null,false,false,false,{"$f":"VLOOKUP($D$2,a,5)","v":3.39},{"$f":"VLOOKUP($D$2,b,5)","v":2.97},{"$f":"VLOOKUP($D$2,e,5)","v":3.51},{"$f":"VLOOKUP($D$2,f,5)","v":2.95},{"$f":"VLOOKUP($D$2,g,5)","v":2.9},{"$f":"VLOOKUP($D$2,h,5)","v":2.78},{"$f":"VLOOKUP($D$2,j,5)","v":2.73},{"$f":"VLOOKUP($D$2,f,5)","v":2.95},{"$f":"VLOOKUP($D$2,q,5)","v":0},{"$f":"VLOOKUP($D$2,w,5)","v":2.4500000000000002},null,null,null,null,null,"Pre-88 GMP factor",null,{"$f":"VLOOKUP($D$2,a,5)","v":3.39},{"$f":"VLOOKUP($D$2,e,5)","v":3.51},{"$f":"VLOOKUP($D$2,g,5)","v":2.9},{"$f":"VLOOKUP($D$2,j,5)","v":2.73},{"$f":"VLOOKUP($D$2,q,5)","v":0},null,null,"Relevant Age ",{"$f":"Results!J7","v":122},null,null,null,null,null,null,null,"Relevant Age ",{"$f":"Results!J8","v":123},null,null,null,null,null,"=",null,8.19,"+","{ 2 / 12","x","-0.47}"]
[null,"Factors",null,2018,null,"Post-88 GMP factor",null,false,false,false,{"$f":"VLOOKUP($D$2,a,6)","v":3.39},{"$f":"VLOOKUP($D$2,b,6)","v":2.97},{"$f":"VLOOKUP($D$2,e,6)","v":3.51},{"$f":"VLOOKUP($D$2,f,6)","v":0.03},{"$f":"VLOOKUP($D$2,g,6)","v":0},{"$f":"VLOOKUP($D$2,h,6)","v":0},{"$f":"VLOOKUP($D$2,j,6)","v":-0.02},{"$f":"VLOOKUP($D$2,f,6)","v":0.03},{"$f":"VLOOKUP($D$2,q,6)","v":0},{"$f":"VLOOKUP($D$2,w,6)","v":-0.05},null,null,null,null,null,"Post-88 GMP factor",null,{"$f":"VLOOKUP($D$2,a,6)","v":3.39},{"$f":"VLOOKUP($D$2,e,6)","v":3.51},{"$f":"VLOOKUP($D$2,g,6)","v":0},{"$f":"VLOOKUP($D$2,j,6)","v":-0.02},{"$f":"VLOOKUP($D$2,q,6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",null,8.19,"+",-7.8333333333333283E-2]
[null,"Years to NPA",null,null,null,"NI Mod factor",null,false,false,false,{"$f":"VLOOKUP($D$2,a,8)","v":13.91},{"$f":"VLOOKUP($D$2,b,8)","v":15.02},{"$f":"VLOOKUP($D$2,e,8)","v":16.239999999999998},{"$f":"VLOOKUP($D$2,f,8)","v":17.46},{"$f":"VLOOKUP($D$2,g,8)","v":16.260000000000002},{"$f":"VLOOKUP($D$2,h,8)","v":17.5},{"$f":"VLOOKUP($D$2,j,8)","v":15.79},{"$f":"VLOOKUP($D$2,f,8)","v":17.46},{"$f":"VLOOKUP($D$2,q,8)","v":0},{"$f":"VLOOKUP($D$2,w,8)","v":16.57},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years","Months",null,null,null,null,null,null,null,"Years","Months",null,null,null,null,"=",null,8.1116666666666699]
[null,"Revaluation","CPI + 1.6%",{"$f":"IF($C$10=\"CPI + 1.25%\",V2,IF($C$10=\"CPI + 1.5%\",V3,IF($C$10=\"CPI + 1.6%\",V4,IF($C$10=\"Earnings\",V5))))","v":1.016},null,"GMP Adjustment",null,false,false,false,{"$f":"VLOOKUP($D$2,a,7)","v":0.15},{"$f":"VLOOKUP($D$2,b,7)","v":0.15},{"$f":"VLOOKUP($D$2,e,7)","v":0.15},{"$f":"VLOOKUP($D$2,f,7)","v":3.5},{"$f":"VLOOKUP($D$2,g,7)","v":-0.1},{"$f":"VLOOKUP($D$2,h,7)","v":2},{"$f":"VLOOKUP($D$2,j,7)","v":-0.8},{"$f":"VLOOKUP($D$2,f,7)","v":3.5},{"$f":"VLOOKUP($D$2,q,7)","v":0},{"$f":"VLOOKUP($D$2,w,7)","v":1.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPA:",{"$f":"Results!D9","v":0},{"$f":"Results!E9","v":0},null,null,null,null,null,null,"SPA:",{"$f":"Results!D9","v":0},{"$f":"Results!E9","v":0}]
[null,"Interpolated factor",null,{"$f":"IF(Results!E9>0,AL14,H4)","v":false},null,"Pension factor",null,{"$f":"IF(($D$3=\"Male\"),I11,J11)","v":false},{"$f":"IF($D$7=60,K11,IF($D$7=65,M11,IF($D$7=66,O11,IF($D$7=67,Q11,IF($D$7=68,S11)))))","v":false},false,{"$f":"M4","v":17.77},17.77,17.23,17.23,16.68,16.68,0,{"$f":"T4","v":16.12},null,null,null,null,null,null,null,"Female",null,60,65,66,67,68]
[null,null,null,0,null,"Lump sum factor",null,false,false,false,0.99,0.99,0.99,0.99,0.99,0.99,0,0.99,null,null,null,null,null,null,null,"Pension factor",null,{"$f":"VLOOKUP($D$2,b,2)","v":20.350000000000001},{"$f":"VLOOKUP($D$2,f,2)","v":17.77},{"$f":"VLOOKUP($D$2,h,2)","v":17.23},{"$f":"VLOOKUP($D$2,k,2)","v":16.68},{"$f":"VLOOKUP($D$2,w,2)","v":16.12},null,null,"Relevant factors table",null,null,"Interpolated ",null,null,null,null,null,"Relevant factors table",null,null,"Interpolated "]
[null,null,null,{"$f":"IF(Results!E9>0,AL15,H6)","v":false},null,"Widow(er)'s pension factor",null,false,false,false,1.55,1.55,1.56,1.56,1.56,1.55,0,1.57,null,null,null,null,null,null,null,"Lump sum factor",null,{"$f":"VLOOKUP($D$2,b,3)","v":0.99},{"$f":"VLOOKUP($D$2,f,3)","v":0.99},{"$f":"VLOOKUP($D$2,h,3)","v":0.99},{"$f":"VLOOKUP($D$2,k,3)","v":0.99},{"$f":"VLOOKUP($D$2,w,3)","v":0.99},null,null,"NPA",{"$f":"D7","v":0},{"$f":"E7","v":1},{"$f":"Results!D9","v":0},{"$f":"Results!E9","v":0},null,{"$f":"AK10/12","v":0},{"$f":"AK10/12","v":0},null,"NPA",{"$f":"D7","v":0},{"$f":"E7","v":1},{"$f":"Results!D9","v":0},{"$f":"Results!E9","v":0},null,{"$f":"AT10/12","v":0},{"$f":"AT10/12","v":0}]
[null,null,null,null,null,"Pre-88 GMP factor",null,{"$f":"IF(($D$3=\"Male\"),I14,J14)","v":false},{"$f":"IF($D$7=60,K14,IF($D$7=65,M14,IF($D$7=66,O14,IF($D$7=67,Q14,IF($D$7=68,S15)))))","v":false},{"$f":"IF($D$7=60,L14,IF($D$7=65,N14,IF($D$7=66,P14,IF($D$7=67,R14,IF($D$7=68,T15)))))","v":false},3.51,2.95,2.9,2.78,2.73,2.95,0,2.4500000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fp",{"$f":"H4","v":false},{"$f":"H11","v":false},{"$f":"AJ14+AO15","v":0},null,null,{"$f":"AK14-AJ14","v":0},{"$f":"AK15-AJ15","v":0},null,"Fp",{"$f":"BF19","v":false},{"$f":"BF26","v":false},{"$f":"AS14+AX15","v":0},null,null,{"$f":"AT14-AS14","v":0},{"$f":"AT15-AS15","v":0}]
[null,null,null,null,null,"Post-88 GMP factor",null,{"$f":"IF(($D$3=\"Male\"),I15,J15)","v":false},{"$f":"IF($D$7=60,K15,IF($D$7=65,M15,IF($D$7=66,O15,IF($D$7=67,Q15,IF($D$7=68,S16)))))","v":false},{"$f":"IF($D$7=60,L15,IF($D$7=65,N15,IF($D$7=66,P15,IF($D$7=67,R15,IF($D$7=68,T16)))))","v":false},3.51,0.03,0,0,-0.02,0.03,0,-0.05,null,null,null,null,null,null,null,"Widow(er)'s pension factor",null,{"$f":"VLOOKUP($D$2,b,4)","v":1.49},{"$f":"VLOOKUP($D$2,f,4)","v":1.55},{"$f":"VLOOKUP($D$2,h,4)","v":1.56},{"$f":"VLOOKUP($D$2,k,4)","v":1.56},{"$f":"VLOOKUP($D$2,w,4)","v":1.57},null,null,"Wid",{"$f":"H6","v":false},{"$f":"H13","v":false},{"$f":"AP15+AJ15","v":0},null,null,{"$f":"AO13*AO14","v":0},{"$f":"AP13*AP14","v":0},null,"Wid",{"$f":"BF21","v":false},{"$f":"BF28","v":false},{"$f":"AY15+AS15","v":0},null,null,{"$f":"AX13*AX14","v":0},{"$f":"AY13*AY14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post-88 GMP factor",null,{"$f":"VLOOKUP($D$2,b,6)","v":2.97},{"$f":"VLOOKUP($D$2,f,6)","v":0.03},{"$f":"VLOOKUP($D$2,h,6)","v":0},{"$f":"VLOOKUP($D$2,k,6)","v":-0.02},{"$f":"VLOOKUP($D$2,w,6)","v":-0.05}]
["SCAPE 2018","Non-Club factors for males with a pension age of 60",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for males with a pension age of 65",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for males with a pension age of 66",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for males with a pension age of 67",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club Factors for males with a pension age of 68",null,null,null,null,null,null,null,null,null,null,null,null,null,"Age",null,{"$f":"INT((BB19-BB21)/365.25)","v":123},null,null,null,"Actual",2015,null,60,null,65,null,66,null,67,null,68]
["Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Complete Years to NPA","Adjustment Factor","Adjustment Factor","Adjustment Factor","Adjustment Factor",null,"Gender",null,{"$f":"IF(Results!D7=\"M\", \"Male\",\"Female\")","v":"Female"},null,null,null,null,"Male","Female","Male 60","Female 60","Male 65","Female 65","Male ","Female ","Male ","Female ","Male ","Female "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relevant date",null,"2023-07-31",null,"Pension factor",null,{"$f":"IF(($D$3=\"Male\"),BG19,BH19)","v":false},{"$f":"IF($D$7=60,BI19,IF($D$7=65,BK19,IF($D$7=66,BM19,IF($D$7=67,BO19,IF($D$7=68,BQ19)))))","v":false},{"$f":"IF($D$7=60,BJ19,IF($D$7=65,BL19,IF($D$7=66,BN19,IF($D$7=67,BP19,IF($D$7=68,BR19)))))","v":false},{"$f":"VLOOKUP(BB17,a,2)","v":20.350000000000001},{"$f":"VLOOKUP(BB17,b,2)","v":20.350000000000001},{"$f":"VLOOKUP(BB17,e,2)","v":17.77},{"$f":"VLOOKUP(BB17,f,2)","v":17.77},{"$f":"VLOOKUP(BB17,g,2)","v":17.23},{"$f":"VLOOKUP(BB17,h,2)","v":17.23},{"$f":"VLOOKUP(BB17,j,2)","v":16.68},{"$f":"VLOOKUP(BB17,k,2)","v":16.68},{"$f":"VLOOKUP(BB17,q,2)","v":0},{"$f":"VLOOKUP(BB17,w,2)","v":16.12}]
[null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,"CPI + 1.25% pa","CPI + 1.5% pa","CPI + 1.6% pa","Earnings",null,"NPA",null,{"$f":"IF(Results!D5=\"NRA60\",\"60\",\"65\")","v":"65"},null,"Lump sum factor",null,{"$f":"IF(($D$3=\"Male\"),BG20,BH20)","v":false},{"$f":"IF($D$7=60,BI20,IF($D$7=65,BK20,IF($D$7=66,BM20,IF($D$7=67,BO20,IF($D$7=68,BQ20)))))","v":false},{"$f":"IF($D$7=60,BJ20,IF($D$7=65,BL20,IF($D$7=66,BN20,IF($D$7=67,BP20,IF($D$7=68,BR20)))))","v":false},{"$f":"VLOOKUP(BB17,a,3)","v":0.99},{"$f":"VLOOKUP(BB17,b,3)","v":0.99},{"$f":"VLOOKUP(BB17,e,3)","v":0.99},{"$f":"VLOOKUP(BB17,f,3)","v":0.99},{"$f":"VLOOKUP(BB17,g,3)","v":0.99},{"$f":"VLOOKUP(BB17,h,3)","v":0.99},{"$f":"VLOOKUP(BB17,j,3)","v":0.99},{"$f":"VLOOKUP(BB17,f,3)","v":0.99},{"$f":"VLOOKUP(BB17,q,3)","v":0},{"$f":"VLOOKUP(BB17,w,3)","v":0.99}]
[16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0,null,0,1.0129999999999999,1.0149999999999999,1.016,1.028,null,"DOB",null,{"$f":"Results!D8","v":"00:00:00"},null,"Widow(er)'s pension factor",null,false,false,false,{"$f":"VLOOKUP(BB17,a,4)","v":1.49},{"$f":"VLOOKUP(BB17,b,4)","v":1.49},{"$f":"VLOOKUP(BB17,e,4)","v":1.55},{"$f":"VLOOKUP(BB17,f,4)","v":1.55},{"$f":"VLOOKUP(BB17,g,4)","v":1.56},{"$f":"VLOOKUP(BB17,h,4)","v":1.56},{"$f":"VLOOKUP(BB17,j,4)","v":1.56},{"$f":"VLOOKUP(BB17,f,4)","v":1.55},{"$f":"VLOOKUP(BB17,q,4)","v":0},{"$f":"VLOOKUP(BB17,w,4)","v":1.57}]
[17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0,null,1,1.0169999999999999,1.02,1.022,1.0369999999999999,null,"NRA",null,{"$f":"Results!D9","v":0},{"$f":"BB22+1","v":1},"Pre-88 GMP factor",null,false,false,false,{"$f":"VLOOKUP(BB17,a,5)","v":3.39},{"$f":"VLOOKUP(BB17,b,5)","v":2.97},{"$f":"VLOOKUP(BB17,e,5)","v":3.51},{"$f":"VLOOKUP(BB17,f,5)","v":2.95},{"$f":"VLOOKUP(BB17,g,5)","v":2.9},{"$f":"VLOOKUP(BB17,h,5)","v":2.78},{"$f":"VLOOKUP(BB17,j,5)","v":2.73},{"$f":"VLOOKUP(BB17,f,5)","v":2.95},{"$f":"VLOOKUP(BB17,q,5)","v":0},{"$f":"VLOOKUP(BB17,w,5)","v":2.4500000000000002}]
[18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0,null,2,1.022,1.026,1.028,1.0489999999999999,null,"Factors",null,2018,null,"Post-88 GMP factor",null,false,false,false,{"$f":"VLOOKUP(BB17,a,6)","v":3.39},{"$f":"VLOOKUP(BB17,b,6)","v":2.97},{"$f":"VLOOKUP(BB17,e,6)","v":3.51},{"$f":"VLOOKUP(BB17,f,6)","v":0.03},{"$f":"VLOOKUP(BB17,g,6)","v":0},{"$f":"VLOOKUP(BB17,h,6)","v":0},{"$f":"VLOOKUP(BB17,j,6)","v":-0.02},{"$f":"VLOOKUP(BB17,f,6)","v":0.03},{"$f":"VLOOKUP(BB17,q,6)","v":0},{"$f":"VLOOKUP(BB17,w,6)","v":-0.05}]
[19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0,null,3,1.0269999999999999,1.0329999999999999,1.0349999999999999,1.0609999999999999,null,"Years to NPA",null,null,null,"NI Mod factor",null,false,false,false,{"$f":"VLOOKUP(BB17,a,8)","v":13.91},{"$f":"VLOOKUP(BB17,b,8)","v":15.02},{"$f":"VLOOKUP(BB17,e,8)","v":16.239999999999998},{"$f":"VLOOKUP(BB17,f,8)","v":17.46},{"$f":"VLOOKUP(BB17,g,8)","v":16.260000000000002},{"$f":"VLOOKUP(BB17,h,8)","v":17.5},{"$f":"VLOOKUP(BB17,j,8)","v":15.79},{"$f":"VLOOKUP(BB17,f,8)","v":17.46},{"$f":"VLOOKUP(BB17,q,8)","v":0},{"$f":"VLOOKUP(BB17,w,8)","v":16.57}]
[20,8.56,0.39,0.76,3.5,3.5,0.15,4.72,null,20,6.76,0.28000000000000003,0.78,3.5,3.5,0.15,4.72,null,20,6.43,0.27,0.78,2.4900000000000002,2.4900000000000002,-0.1,4.72,null,20,6.11,0.26,0.78,1.53,1.53,-0.8,4.72,null,20,5.79,0.25,0.79,0.59,0.59,-4.5,4.72,null,4,1.0329999999999999,1.04,1.0429999999999999,1.0740000000000001,null,"Revaluation","CPI + 1.6%",{"$f":"D10","v":1.016},null,"GMP Adjustment",null,false,false,false,{"$f":"VLOOKUP(BB17,a,7)","v":0.15},{"$f":"VLOOKUP(BB17,b,7)","v":0.15},{"$f":"VLOOKUP(BB17,e,7)","v":0.15},{"$f":"VLOOKUP(BB17,f,7)","v":3.5},{"$f":"VLOOKUP(BB17,g,7)","v":-0.1},{"$f":"VLOOKUP(BB17,h,7)","v":2},{"$f":"VLOOKUP(BB17,j,7)","v":-0.8},{"$f":"VLOOKUP(BB17,f,7)","v":3.5},{"$f":"VLOOKUP(BB17,q,7)","v":0},{"$f":"VLOOKUP(BB17,w,7)","v":1.5}]
[21,8.75,0.4,0.78,3.49,3.49,0.15,4.8499999999999996,null,21,6.91,0.28000000000000003,0.79,3.49,3.49,0.15,4.8499999999999996,null,21,6.57,0.28000000000000003,0.8,2.4900000000000002,2.4900000000000002,-0.1,4.8499999999999996,null,21,6.24,0.27,0.8,1.52,1.52,-0.8,4.8499999999999996,null,21,5.91,0.26,0.81,0.57999999999999996,0.57999999999999996,-4.5,4.8499999999999996,null,5,1.0389999999999999,1.0469999999999999,1.05,1.0880000000000001,null,"Interpolated factor",null,{"$f":"IF(Results!E9>0,AU14,BF19)","v":false},null,"Pension factor",null,{"$f":"IF(($D$3=\"Male\"),BG26,BH26)","v":false},{"$f":"IF($D$7=60,BI26,IF($D$7=65,BK26,IF($D$7=66,BM26,IF($D$7=67,BO26,IF($D$7=68,BQ26)))))","v":false},false,{"$f":"BK19","v":17.77},{"$f":"BL19","v":17.77},{"$f":"BM19","v":17.23},{"$f":"BN19","v":17.23},{"$f":"BO19","v":16.68},{"$f":"BP19","v":16.68},{"$f":"BQ19","v":0},{"$f":"BR19","v":16.12}]
[22,8.94,0.41,0.8,3.49,3.49,0.15,4.9800000000000004,null,22,7.05,0.28999999999999998,0.81,3.49,3.49,0.15,4.9800000000000004,null,22,6.71,0.28000000000000003,0.82,2.48,2.48,-0.1,4.9800000000000004,null,22,6.37,0.28000000000000003,0.82,1.51,1.51,-0.8,4.9800000000000004,null,22,6.04,0.27,0.82,0.56999999999999995,0.56999999999999995,-4.5,4.9800000000000004,null,6,1.0449999999999999,1.054,1.0580000000000001,1.101,null,null,null,0,null,"Lump sum factor",null,{"$f":"IF(($D$3=\"Male\"),BG27,BH27)","v":false},{"$f":"IF($D$7=60,BI27,IF($D$7=65,BK27,IF($D$7=66,BM27,IF($D$7=67,BO27,IF($D$7=68,BQ27)))))","v":false},false,{"$f":"BK20","v":0.99},0.99,{"$f":"BM20","v":0.99},0.99,0.99,0.99,{"$f":"BQ20","v":0},{"$f":"BR20","v":0.99}]
[23,9.1300000000000008,0.42,0.82,3.48,3.48,0.15,5.12,null,23,7.21,0.3,0.83,3.48,3.48,0.15,5.12,null,23,6.85,0.28999999999999998,0.84,2.4700000000000002,2.4700000000000002,-0.1,5.12,null,23,6.5,0.28999999999999998,0.84,1.5,1.5,-0.8,5.12,null,23,6.16,0.28000000000000003,0.84,0.56000000000000005,0.56000000000000005,-4.5,5.12,null,7,1.0509999999999999,1.0620000000000001,1.0660000000000001,1.115,null,null,null,{"$f":"IF(Results!E9>0,AU15,BF21)","v":false},null,"Widow(er)'s pension factor",null,false,false,false,1.55,1.55,1.56,1.56,{"$f":"BO21","v":1.56},1.55,0,1.57]
[24,9.33,0.43,0.84,3.48,3.48,0.15,5.26,null,24,7.36,0.31,0.85,3.48,3.48,0.15,5.26,null,24,6.99,0.3,0.85,2.46,2.46,-0.1,5.26,null,24,6.64,0.28999999999999998,0.86,1.49,1.49,-0.8,5.26,null,24,6.29,0.28999999999999998,0.86,0.55000000000000004,0.55000000000000004,-4.5,5.26,null,8,1.0569999999999999,1.069,1.0740000000000001,1.1299999999999999,null,null,null,null,null,"Pre-88 GMP factor",null,{"$f":"IF(($D$3=\"Male\"),BG29,BH29)","v":false},{"$f":"IF($D$7=60,BI29,IF($D$7=65,BK29,IF($D$7=66,BM29,IF($D$7=67,BO29,IF($D$7=68,BQ30)))))","v":false},{"$f":"IF($D$7=60,BJ29,IF($D$7=65,BL29,IF($D$7=66,BN29,IF($D$7=67,BP29,IF($D$7=68,BR30)))))","v":false},3.51,2.95,2.9,2.78,2.73,2.95,0,2.4500000000000002]
[25,9.5399999999999991,0.44,0.86,3.47,3.47,0.15,5.4,null,25,7.52,0.32,0.87,3.47,3.47,0.15,5.4,null,25,7.14,0.31,0.87,2.46,2.46,-0.1,5.4,null,25,6.78,0.3,0.88,1.48,1.48,-0.8,5.4,null,25,6.43,0.28999999999999998,0.88,0.54,0.54,-4.5,5.4,null,9,1.0640000000000001,1.077,1.0820000000000001,1.145,null,null,null,null,null,"Post-88 GMP factor",null,{"$f":"IF(($D$3=\"Male\"),BG30,BH30)","v":false},{"$f":"IF($D$7=60,BI30,IF($D$7=65,BK30,IF($D$7=66,BM30,IF($D$7=67,BO30,IF($D$7=68,BQ31)))))","v":false},{"$f":"IF($D$7=60,BJ30,IF($D$7=65,BL30,IF($D$7=66,BN30,IF($D$7=67,BP30,IF($D$7=68,BR31)))))","v":false},3.51,0.03,0,0,-0.02,0.03,0,-0.05]
[26,9.75,0.45,0.88,3.46,3.46,0.15,5.55,null,26,7.68,0.33,0.89,3.46,3.46,0.15,5.55,null,26,7.3,0.32,0.89,2.4500000000000002,2.4500000000000002,-0.1,5.55,null,26,6.92,0.31,0.9,1.47,1.47,-0.8,5.55,null,26,6.56,0.3,0.9,0.52,0.52,-4.5,5.55,null,10,1.07,1.0840000000000001,1.0900000000000001,1.1599999999999999]
[27,9.9600000000000009,0.46,0.89,3.46,3.46,0.15,5.7,null,27,7.84,0.34,0.91,3.46,3.46,0.15,5.7,null,27,7.45,0.33,0.92,2.44,2.44,-0.1,5.7,null,27,7.07,0.32,0.92,1.46,1.46,-0.8,5.7,null,27,6.7,0.31,0.93,0.51,0.51,-4.5,5.7,null,11,1.0760000000000001,1.0920000000000001,1.099,1.175]
[28,10.18,0.47,0.91,3.45,3.45,0.15,5.85,null,28,8.01,0.35,0.93,3.45,3.45,0.15,5.85,null,28,7.61,0.34,0.94,2.4300000000000002,2.4300000000000002,-0.1,5.85,null,28,7.22,0.33,0.94,1.45,1.45,-0.8,5.85,null,28,6.84,0.32,0.95,0.5,0.5,-4.5,5.85,null,12,1.083,1.1000000000000001,1.107,1.1910000000000001]
[29,10.4,0.49,0.93,3.45,3.45,0.15,6.01,null,29,8.18,0.36,0.95,3.45,3.45,0.15,6.01,null,29,7.77,0.35,0.96,2.42,2.42,-0.1,6.01,null,29,7.37,0.34,0.96,1.44,1.44,-0.8,6.01,null,29,6.98,0.33,0.97,0.49,0.49,-4.5,6.01,null,13,1.0900000000000001,1.1080000000000001,1.1160000000000001,1.2070000000000001]
[30,10.63,0.5,0.96,3.44,3.44,0.15,6.18,null,30,8.36,0.37,0.97,3.44,3.44,0.15,6.18,null,30,7.94,0.36,0.98,2.42,2.42,-0.1,6.18,null,30,7.53,0.35,0.98,1.43,1.43,-0.8,6.18,null,30,7.13,0.34,0.99,0.48,0.48,-4.5,6.18,null,14,1.0960000000000001,1.1160000000000001,1.125,1.2230000000000001]
[31,10.87,0.51,0.98,3.44,3.44,0.15,6.35,null,31,8.5399999999999991,0.38,0.99,3.44,3.44,0.15,6.35,null,31,8.11,0.37,1,2.41,2.41,-0.1,6.35,null,31,7.69,0.36,1,1.42,1.42,-0.8,6.35,null,31,7.28,0.35,1.01,0.46,0.46,-4.5,6.35,null,15,1.103,1.125,1.133,1.2390000000000001]
[32,11.1,0.52,1,3.43,3.43,0.15,6.52,null,32,8.7200000000000006,0.39,1.02,3.43,3.43,0.15,6.52,null,32,8.2799999999999994,0.38,1.02,2.4,2.4,-0.1,6.52,null,32,7.85,0.37,1.03,1.41,1.41,-0.8,6.52,null,32,7.44,0.36,1.03,0.45,0.45,-4.5,6.52,null,16,1.109,1.133,1.1419999999999999,1.256]
[33,11.35,0.53,1.02,3.43,3.43,0.15,6.7,null,33,8.91,0.4,1.04,3.43,3.43,0.15,6.7,null,33,8.4600000000000009,0.39,1.04,2.39,2.39,-0.1,6.7,null,33,8.02,0.38,1.05,1.4,1.4,-0.8,6.7,null,33,7.59,0.37,1.05,0.44,0.44,-4.5,6.7,null,17,1.1160000000000001,1.141,1.151,1.272]
[34,11.6,0.55000000000000004,1.04,3.42,3.42,0.15,6.88,null,34,9.1,0.41,1.06,3.42,3.42,0.15,6.88,null,34,8.64,0.4,1.06,2.39,2.39,-0.1,6.88,null,34,8.19,0.39,1.07,1.39,1.39,-0.8,6.88,null,34,7.75,0.38,1.08,0.43,0.43,-4.5,6.88,null,18,1.123,1.149,1.1599999999999999,1.2889999999999999]
[35,11.85,0.56000000000000005,1.06,3.42,3.42,0.15,7.07,null,35,9.2899999999999991,0.43,1.08,3.42,3.42,0.15,7.07,null,35,8.82,0.42,1.0900000000000001,2.38,2.38,-0.1,7.07,null,35,8.36,0.4,1.0900000000000001,1.38,1.38,-0.8,7.07,null,35,7.92,0.39,1.1000000000000001,0.42,0.42,-4.5,7.07,null,19,1.1299999999999999,1.1579999999999999,1.169,1.3069999999999999]
[36,12.12,0.56999999999999995,1.08,3.41,3.41,0.15,7.27,null,36,9.49,0.44,1.1000000000000001,3.41,3.41,0.15,7.27,null,36,9.01,0.43,1.1100000000000001,2.37,2.37,-0.1,7.27,null,36,8.5399999999999991,0.42,1.1100000000000001,1.37,1.37,-0.8,7.27,null,36,8.08,0.4,1.1200000000000001,0.4,0.4,-4.5,7.27,null,20,1.137,1.1659999999999999,1.1779999999999999,1.3240000000000001]
[37,12.38,0.59,1.1000000000000001,3.41,3.41,0.15,7.47,null,37,9.6999999999999993,0.45,1.1200000000000001,3.41,3.41,0.15,7.47,null,37,9.1999999999999993,0.44,1.1299999999999999,2.37,2.37,-0.1,7.47,null,37,8.7200000000000006,0.43,1.1299999999999999,1.36,1.36,-0.8,7.47,null,37,8.25,0.42,1.1399999999999999,0.39,0.39,-4.5,7.47,null,21,1.1439999999999999,1.175,1.1870000000000001,1.3420000000000001]
[38,12.66,0.6,1.1200000000000001,3.4,3.4,0.15,7.67,null,38,9.91,0.47,1.1399999999999999,3.4,3.4,0.15,7.67,null,38,9.4,0.45,1.1499999999999999,2.36,2.36,-0.1,7.67,null,38,8.91,0.44,1.1599999999999999,1.35,1.35,-0.8,7.67,null,38,8.43,0.43,1.1599999999999999,0.38,0.38,-4.5,7.67,null,22,1.1499999999999999,1.1830000000000001,1.196,1.36]
[39,12.94,0.62,1.1399999999999999,3.4,3.4,0.15,7.89,null,39,10.119999999999999,0.48,1.17,3.4,3.4,0.15,7.89,null,39,9.6,0.47,1.17,2.35,2.35,-0.1,7.89,null,39,9.1,0.45,1.18,1.34,1.34,-0.8,7.89,null,39,8.61,0.44,1.19,0.37,0.37,-4.5,7.89,null,23,1.157,1.1919999999999999,1.206,1.3779999999999999]
[40,13.23,0.63,1.1599999999999999,3.4,3.4,0.15,8.11,null,40,10.34,0.49,1.19,3.4,3.4,0.15,8.11,null,40,9.81,0.48,1.19,2.35,2.35,-0.1,8.11,null,40,9.2899999999999991,0.47,1.2,1.33,1.33,-0.8,8.11,null,40,8.7899999999999991,0.45,1.21,0.36,0.36,-4.5,8.11,null,24,1.1639999999999999,1.2,1.2150000000000001,1.3959999999999999]
[41,13.52,0.64,1.18,3.39,3.39,0.15,8.33,null,41,10.57,0.51,1.21,3.39,3.39,0.15,8.33,null,41,10.02,0.49,1.21,2.34,2.34,-0.1,8.33,null,41,9.49,0.48,1.22,1.32,1.32,-0.8,8.33,null,41,8.98,0.47,1.23,0.34,0.34,-4.5,8.33,null,25,1.1719999999999999,1.2090000000000001,1.224,1.415]
[42,13.82,0.66,1.2,3.39,3.39,0.15,8.57,null,42,10.8,0.52,1.23,3.39,3.39,0.15,8.57,null,42,10.24,0.51,1.24,2.33,2.33,-0.1,8.57,null,42,9.6999999999999993,0.49,1.24,1.31,1.31,-0.8,8.57,null,42,9.17,0.48,1.25,0.33,0.33,-4.5,8.57,null,26,1.179,1.218,1.234,1.4339999999999999]
[43,14.13,0.68,1.22,3.39,3.39,0.15,8.81,null,43,11.03,0.54,1.25,3.39,3.39,0.15,8.81,null,43,10.46,0.52,1.26,2.33,2.33,-0.1,8.81,null,43,9.91,0.51,1.26,1.3,1.3,-0.8,8.81,null,43,9.3699999999999992,0.49,1.27,0.32,0.32,-4.5,8.81,null,27,1.1859999999999999,1.2270000000000001,1.2430000000000001,1.4530000000000001]
[44,14.45,0.69,1.24,3.39,3.39,0.15,9.06,null,44,11.27,0.55000000000000004,1.27,3.39,3.39,0.15,9.06,null,44,10.69,0.54,1.28,2.3199999999999998,2.3199999999999998,-0.1,9.06,null,44,10.119999999999999,0.52,1.29,1.29,1.29,-0.8,9.06,null,44,9.57,0.51,1.29,0.31,0.31,-4.5,9.06,null,28,1.1930000000000001,1.236,1.2529999999999999,1.472]
[45,14.77,0.71,1.26,3.38,3.38,0.15,9.31,null,45,11.52,0.56999999999999995,1.29,3.38,3.38,0.15,9.31,null,45,10.92,0.55000000000000004,1.3,2.31,2.31,-0.1,9.31,null,45,10.34,0.54,1.31,1.29,1.29,-0.8,9.31,null,45,9.77,0.52,1.32,0.3,0.3,-4.5,9.31,null,29,1.2,1.2450000000000001,1.2629999999999999,1.492]
[46,15.1,0.73,1.28,3.38,3.38,0.15,9.58,null,46,11.77,0.59,1.31,3.38,3.38,0.15,9.58,null,46,11.16,0.56999999999999995,1.32,2.31,2.31,-0.1,9.58,null,46,10.56,0.55000000000000004,1.33,1.28,1.28,-0.8,9.58,null,46,9.98,0.54,1.34,0.28000000000000003,0.28000000000000003,-4.5,9.58,null,30,1.2070000000000001,1.254,1.2729999999999999,1.512]
[47,15.44,0.74,1.3,3.38,3.38,0.15,9.85,null,47,12.03,0.6,1.33,3.38,3.38,0.15,9.85,null,47,11.4,0.59,1.34,2.2999999999999998,2.2999999999999998,-0.1,9.85,null,47,10.79,0.56999999999999995,1.35,1.27,1.27,-0.8,9.85,null,47,10.199999999999999,0.55000000000000004,1.36,0.27,0.27,-4.5,9.85,null,31,1.2150000000000001,1.2629999999999999,1.2829999999999999,1.532]
[48,15.79,0.76,1.32,3.38,3.38,0.15,10.119999999999999,null,48,12.29,0.62,1.35,3.38,3.38,0.15,10.119999999999999,null,48,11.65,0.6,1.36,2.2999999999999998,2.2999999999999998,-0.1,10.119999999999999,null,48,11.02,0.59,1.37,1.26,1.26,-0.8,10.119999999999999,null,48,10.42,0.56999999999999995,1.38,0.26,0.26,-4.5,10.119999999999999,null,32,1.222,1.272,1.292,1.552]
[49,16.149999999999999,0.78,1.34,3.37,3.37,0.15,10.41,null,49,12.57,0.64,1.38,3.37,3.37,0.15,10.41,null,49,11.91,0.62,1.38,2.29,2.29,-0.1,10.41,null,49,11.26,0.6,1.39,1.25,1.25,-0.8,10.41,null,49,10.64,0.59,1.4,0.25,0.25,-4.5,10.41,null,33,1.23,1.2809999999999999,1.3029999999999999,1.573]
[50,16.52,0.8,1.36,3.37,3.37,0.15,10.71,null,50,12.84,0.66,1.4,3.37,3.37,0.15,10.71,null,50,12.17,0.64,1.4,2.29,2.29,-0.1,10.71,null,50,11.51,0.62,1.41,1.24,1.24,-0.8,10.71,null,50,10.87,0.6,1.42,0.23,0.23,-4.5,10.71,null,34,1.2370000000000001,1.2909999999999999,1.3129999999999999,1.5940000000000001]
[51,16.89,0.82,1.38,3.37,3.37,0.15,11.01,null,51,13.13,0.68,1.41,3.37,3.37,0.15,11.01,null,51,12.44,0.66,1.42,2.2799999999999998,2.2799999999999998,-0.1,11.01,null,51,11.76,0.64,1.43,1.23,1.23,-0.8,11.01,null,51,11.11,0.62,1.44,0.22,0.22,-4.5,11.01,null,35,1.2450000000000001,1.3,1.323,1.615]
[52,17.28,0.84,1.4,3.37,3.37,0.15,11.33,null,52,13.42,0.7,1.43,3.37,3.37,0.15,11.33,null,52,12.71,0.68,1.44,2.2799999999999998,2.2799999999999998,-0.1,11.33,null,52,12.02,0.66,1.45,1.22,1.22,-0.8,11.33,null,52,11.35,0.64,1.46,0.21,0.21,-4.5,11.33,null,36,1.252,1.3089999999999999,1.333,1.637]
[53,17.68,0.86,1.42,3.37,3.37,0.15,11.66,null,53,13.72,0.72,1.45,3.37,3.37,0.15,11.66,null,53,13,0.7,1.46,2.27,2.27,-0.1,11.66,null,53,12.29,0.68,1.47,1.21,1.21,-0.8,11.66,null,53,11.6,0.66,1.48,0.19,0.19,-4.5,11.66,null,37,1.26,1.319,1.343,1.659]
[54,18.09,0.88,1.43,3.37,3.37,0.15,12,null,54,14.04,0.74,1.47,3.37,3.37,0.15,12,null,54,13.29,0.72,1.48,2.27,2.27,-0.1,12,null,54,12.56,0.7,1.49,1.2,1.2,-0.8,12,null,54,11.86,0.68,1.5,0.18,0.18,-4.5,12,null,38,1.2669999999999999,1.329,1.3540000000000001,1.681]
[55,18.510000000000002,0.9,1.45,3.37,3.37,0.15,12.35,null,55,14.36,0.76,1.48,3.37,3.37,0.15,12.35,null,55,13.59,0.74,1.49,2.2599999999999998,2.2599999999999998,-0.1,12.35,null,55,12.85,0.72,1.5,1.2,1.2,-0.8,12.35,null,55,12.12,0.7,1.51,0.17,0.17,-4.5,12.35,null,39,1.2749999999999999,1.3380000000000001,1.3640000000000001,1.7030000000000001]
[56,18.95,0.92,1.46,3.38,3.38,0.15,12.72,null,56,14.68,0.78,1.5,3.38,3.38,0.15,12.72,null,56,13.9,0.76,1.51,2.2599999999999998,2.2599999999999998,-0.1,12.72,null,56,13.14,0.74,1.52,1.19,1.19,-0.8,12.72,null,56,12.4,0.72,1.53,0.16,0.16,-4.5,12.72,null,40,1.2829999999999999,1.3480000000000001,1.375,1.726]
[57,19.399999999999999,0.94,1.47,3.38,3.38,0.15,13.1,null,57,15.03,0.8,1.51,3.38,3.38,0.15,13.1,null,57,14.22,0.78,1.52,2.2599999999999998,2.2599999999999998,-0.1,13.1,null,57,13.44,0.76,1.53,1.18,1.18,-0.8,13.1,null,57,12.68,0.74,1.54,0.14000000000000001,0.14000000000000001,-4.5,13.1,null,41,1.29,1.3580000000000001,1.3859999999999999,1.7490000000000001]
[58,19.87,0.97,1.48,3.38,3.38,0.15,13.49,null,58,15.38,0.83,1.52,3.38,3.38,0.15,13.49,null,58,14.55,0.8,1.53,2.25,2.25,-0.1,13.49,null,58,13.75,0.78,1.54,1.17,1.17,-0.8,13.49,null,58,12.97,0.76,1.55,0.13,0.13,-4.5,13.49,null,42,1.298,1.3680000000000001,1.3959999999999999,1.772]
[59,20.350000000000001,0.99,1.49,3.39,3.39,0.15,13.91,null,59,15.74,0.85,1.53,3.39,3.39,0.15,13.91,null,59,14.89,0.83,1.54,2.25,2.25,-0.1,13.91,null,59,14.07,0.8,1.55,1.1599999999999999,1.1599999999999999,-0.8,13.91,null,59,13.27,0.78,1.56,0.12,0.12,-4.5,13.91,null,43,1.306,1.3779999999999999,1.407,1.796]
[60,0,1,0,0,0,0,0,null,60,16.12,0.88,1.54,3.39,3.39,0.15,14.33,null,60,15.25,0.85,1.55,2.25,2.25,-0.1,14.33,null,60,14.4,0.83,1.56,1.1599999999999999,1.1599999999999999,-0.8,14.33,null,60,13.58,0.8,1.57,0.1,0.1,-4.5,14.33,null,44,1.3140000000000001,1.3879999999999999,1.4179999999999999,1.82]
[61,0,1,0,0,0,0,0,null,61,16.5,0.9,1.54,3.4,3.4,0.15,14.78,null,61,15.61,0.88,1.55,2.25,2.25,-0.1,14.78,null,61,14.74,0.85,1.57,1.1499999999999999,1.1499999999999999,-0.8,14.78,null,61,13.9,0.83,1.58,0.09,0.09,-4.5,14.78,null,45,1.3220000000000001,1.3979999999999999,1.42,1.8440000000000001]
[62,0,1,0,0,0,0,0,null,62,16.91,0.93,1.55,3.41,3.41,0.15,15.25,null,62,15.99,0.9,1.56,2.25,2.25,-0.1,15.25,null,62,15.1,0.88,1.57,1.1399999999999999,1.1399999999999999,-0.8,15.25,null,62,14.23,0.85,1.58,7.0000000000000007E-2,7.0000000000000007E-2,-4.5,15.25,null,46,1.33,1.4079999999999999,1.44,1.869]
[63,0,1,0,0,0,0,0,null,63,17.329999999999998,0.96,1.55,3.42,3.42,0.15,15.73,null,63,16.39,0.93,1.56,2.25,2.25,-0.1,15.73,null,63,15.47,0.9,1.57,1.1299999999999999,1.1299999999999999,-0.8,15.73,null,63,14.58,0.88,1.58,0.06,0.06,-4.5,15.73,null,47,1.3380000000000001,1.4179999999999999,1.4510000000000001,1.8939999999999999]
[64,0,1,0,0,0,0,0,null,64,17.77,0.99,1.55,3.51,3.51,0.15,16.239999999999998,null,64,16.8,0.96,1.56,2.31,2.31,-0.1,16.239999999999998,null,64,15.86,0.93,1.57,1.1499999999999999,1.1499999999999999,-0.8,16.239999999999998,null,64,14.94,0.9,1.58,0.05,0.05,-4.5,16.239999999999998,null,48,1.3460000000000001,1.4279999999999999,1.4630000000000001,1.919]
[65,0,1,0,0,0,0,0,null,65,0,0,0,0,0,0,0,null,65,17.23,0.99,1.56,2.9,0,-0.1,16.260000000000002,null,65,16.260000000000002,0.96,1.57,1.69,-1,-0.8,16.260000000000002,null,65,15.32,0.93,1.58,0.53,-1.96,-4.5,16.260000000000002,null,49,1.3540000000000001,1.4390000000000001,1.474,1.944]
[66,0,1,0,0,0,0,0,null,66,0,0,0,0,0,0,0,null,66,0,0,0,0,0,0,0,null,66,16.68,0.99,1.56,2.73,-0.02,-0.8,15.79,null,66,15.71,0.96,1.58,1.53,-1.02,-4.5,15.79,null,50,1.363,1.4490000000000001,1.4850000000000001,1.97]
[67,0,1,0,0,0,0,0,null,67,0,0,0,0,0,0,0,null,67,0,0,0,0,0,0,0,null,67,0,0,0,0,0,0,0,null,67,16.12,0.99,1.57,2.57,-0.05,-4.5,15.3,null,51,1.371,1.46,1.4970000000000001,1.9970000000000001]
[68,0,1,0,0,0,0,0,null,68,0,0,0,0,0,0,0,null,68,0,0,0,0,0,0,0,null,68,0,0,0,0,0,0,0,null,68,0,0,0,0,0,0,0,null,52,1.379,1.47,1.5089999999999999,2.0230000000000001]
[69,0,1,0,0,0,0,0,null,69,0,0,0,0,0,0,0,null,69,0,0,0,0,0,0,0,null,69,0,0,0,0,0,0,0,null,69,0,0,0,0,0,0,0,null,53,1.3879999999999999,1.4810000000000001,1.52,2.0499999999999998]
[70,0,1,0,0,0,0,0,null,70,0,0,0,0,0,0,0,null,70,0,0,0,0,0,0,0,null,70,0,0,0,0,0,0,0,null,70,0,0,0,0,0,0,0,null,54,1.3959999999999999,1.492,1.532,2.0779999999999998]
[71,0,1,0,0,0,0,0,null,71,0,0,0,0,0,0,0,null,71,0,0,0,0,0,0,0,null,71,0,0,0,0,0,0,0,null,71,0,0,0,0,0,0,0,null,55,1.4039999999999999,1.5029999999999999,1.544,2.105]
[72,0,1,0,0,0,0,0,null,72,0,0,0,0,0,0,0,null,72,0,0,0,0,0,0,0,null,72,0,0,0,0,0,0,0,null,72,0,0,0,0,0,0,0]
[73,0,1,0,0,0,0,0,null,73,0,0,0,0,0,0,0,null,73,0,0,0,0,0,0,0,null,73,0,0,0,0,0,0,0,null,73,0,0,0,0,0,0,0]
[74,0,1,0,0,0,0,0,null,74,0,0,0,0,0,0,0,null,74,0,0,0,0,0,0,0,null,74,0,0,0,0,0,0,0,null,74,0,0,0,0,0,0,0]
[]
["SCAPE 2018","Non-Club factors for females with a pension age of 60",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for females with a pension age of 65",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for females with a pension age of 66",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for females with a pension age of 67",null,null,null,null,null,null,null,"SCAPE 2018","Non-Club factors for females with a pension age of 68"]
["Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widower’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widow’s pension2 of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widower’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widower’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa",null,"Age last birthday at guarantee date","Gross pension of £1 per annum","Lump sum of £1","Widower’s pension of £1 per annum","Deduction for GMP of £1 per annum",null,null,"Deduction for NI modification of £1 pa"]
[]
[null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj.",null,null,null,null,null,null,"Pre-88 factor","Post-88 factor","Post-88 adj."]
[16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0,null,16,4.3499999999999996,0.23,0.66,-1.26,-1.26,2,4.5999999999999996,null,16,0,0,0,0,0,0,0,null,16,0,0,0,0,0,0,0]
[17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0,null,17,4.4800000000000004,0.24,0.68,-1.28,-1.28,2,4.72,null,17,0,0,0,0,0,0,0,null,17,0,0,0,0,0,0,0]
[18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0,null,18,4.6100000000000003,0.25,0.7,-1.3,-1.3,2,4.84,null,18,0,0,0,0,0,0,0,null,18,0,0,0,0,0,0,0]
[19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0,null,19,4.7300000000000004,0.26,0.72,-1.32,-1.32,2,4.9800000000000004,null,19,0,0,0,0,0,0,0,null,19,0,0,0,0,0,0,0]
[20,8.56,0.39,0.76,3.02,3.02,0.15,5.1100000000000003,null,20,6.76,0.27,0.78,-0.84,-0.84,3.5,5.1100000000000003,null,20,6.43,0.27,0.78,-1.75,-1.75,2,5.1100000000000003,null,20,6.11,0.26,0.78,-2.62,-2.62,1.7,5.1100000000000003,null,20,5.79,0.25,0.79,-3.47,-3.47,1.5,5.1100000000000003]
[21,8.75,0.4,0.78,3.01,3.01,0.15,5.25,null,21,6.91,0.28000000000000003,0.79,-0.86,-0.86,3.5,5.25,null,21,6.57,0.27,0.8,-1.76,-1.76,2,5.25,null,21,6.24,0.27,0.8,-2.64,-2.64,1.7,5.25,null,21,5.91,0.26,0.81,-3.49,-3.49,1.5,5.25]
[22,8.94,0.41,0.8,3.01,3.01,0.15,5.39,null,22,7.05,0.28999999999999998,0.81,-0.87,-0.87,3.5,5.39,null,22,6.71,0.28000000000000003,0.82,-1.78,-1.78,2,5.39,null,22,6.37,0.28000000000000003,0.82,-2.66,-2.66,1.7,5.39,null,22,6.04,0.27,0.82,-3.51,-3.51,1.5,5.39]
[23,9.1300000000000008,0.42,0.82,3.01,3.01,0.15,5.54,null,23,7.21,0.3,0.83,-0.89,-0.89,3.5,5.54,null,23,6.85,0.28999999999999998,0.84,-1.8,-1.8,2,5.54,null,23,6.5,0.28000000000000003,0.84,-2.68,-2.68,1.7,5.54,null,23,6.16,0.28000000000000003,0.84,-3.53,-3.53,1.5,5.54]
[24,9.33,0.43,0.84,3,3,0.15,5.69,null,24,7.36,0.31,0.85,-0.9,-0.9,3.5,5.69,null,24,6.99,0.3,0.85,-1.82,-1.82,2,5.69,null,24,6.64,0.28999999999999998,0.86,-2.7,-2.7,1.7,5.69,null,24,6.29,0.28000000000000003,0.86,-3.55,-3.55,1.5,5.69]
[25,9.5399999999999991,0.44,0.86,3,3,0.15,5.85,null,25,7.52,0.32,0.87,-0.92,-0.92,3.5,5.85,null,25,7.14,0.31,0.87,-1.83,-1.83,2,5.85,null,25,6.78,0.3,0.88,-2.72,-2.72,1.7,5.85,null,25,6.43,0.28999999999999998,0.88,-3.57,-3.57,1.5,5.85]
[26,9.75,0.45,0.88,2.99,2.99,0.15,6.01,null,26,7.68,0.33,0.89,-0.93,-0.93,3.5,6.01,null,26,7.3,0.32,0.89,-1.85,-1.85,2,6.01,null,26,6.92,0.31,0.9,-2.74,-2.74,1.7,6.01,null,26,6.56,0.3,0.9,-3.59,-3.59,1.5,6.01]
[27,9.9600000000000009,0.46,0.89,2.99,2.99,0.15,6.18,null,27,7.84,0.34,0.91,-0.95,-0.95,3.5,6.18,null,27,7.45,0.33,0.92,-1.87,-1.87,2,6.18,null,27,7.07,0.32,0.92,-2.76,-2.76,1.7,6.18,null,27,6.7,0.31,0.93,-3.61,-3.61,1.5,6.18]
[28,10.18,0.47,0.91,2.99,2.99,0.15,6.35,null,28,8.01,0.35,0.93,-0.96,-0.96,3.5,6.35,null,28,7.61,0.34,0.94,-1.89,-1.89,2,6.35,null,28,7.22,0.33,0.94,-2.78,-2.78,1.7,6.35,null,28,6.84,0.32,0.95,-3.64,-3.64,1.5,6.35]
[29,10.4,0.49,0.93,2.98,2.98,0.15,6.53,null,29,8.18,0.36,0.95,-0.98,-0.98,3.5,6.53,null,29,7.77,0.35,0.96,-1.9,-1.9,2,6.53,null,29,7.37,0.34,0.96,-2.8,-2.8,1.7,6.53,null,29,6.98,0.33,0.97,-3.66,-3.66,1.5,6.53]
[30,10.63,0.5,0.96,2.98,2.98,0.15,6.71,null,30,8.36,0.37,0.97,-0.99,-0.99,3.5,6.71,null,30,7.94,0.36,0.98,-1.92,-1.92,2,6.71,null,30,7.53,0.35,0.98,-2.82,-2.82,1.7,6.71,null,30,7.13,0.34,0.99,-3.68,-3.68,1.5,6.71]
[31,10.87,0.51,0.98,2.97,2.97,0.15,6.89,null,31,8.5399999999999991,0.38,0.99,-1.01,-1.01,3.5,6.89,null,31,8.11,0.37,1,-1.94,-1.94,2,6.89,null,31,7.69,0.36,1,-2.84,-2.84,1.7,6.89,null,31,7.28,0.35,1.01,-3.7,-3.7,1.5,6.89]
[32,11.1,0.52,1,2.97,2.97,0.15,7.08,null,32,8.7200000000000006,0.39,1.02,-1.02,-1.02,3.5,7.08,null,32,8.2799999999999994,0.38,1.02,-1.96,-1.96,2,7.08,null,32,7.85,0.37,1.03,-2.86,-2.86,1.7,7.08,null,32,7.44,0.36,1.03,-3.72,-3.72,1.5,7.08]
[33,11.35,0.53,1.02,2.97,2.97,0.15,7.28,null,33,8.91,0.4,1.04,-1.04,-1.04,3.5,7.28,null,33,8.4600000000000009,0.39,1.04,-1.97,-1.97,2,7.28,null,33,8.02,0.38,1.05,-2.88,-2.88,1.7,7.28,null,33,7.59,0.37,1.05,-3.75,-3.75,1.5,7.28]
[34,11.6,0.55000000000000004,1.04,2.96,2.96,0.15,7.48,null,34,9.1,0.41,1.06,-1.05,-1.05,3.5,7.48,null,34,8.64,0.4,1.06,-1.99,-1.99,2,7.48,null,34,8.19,0.39,1.07,-2.9,-2.9,1.7,7.48,null,34,7.75,0.38,1.08,-3.77,-3.77,1.5,7.48]
[35,11.85,0.56000000000000005,1.06,2.96,2.96,0.15,7.69,null,35,9.2899999999999991,0.43,1.08,-1.07,-1.07,3.5,7.69,null,35,8.82,0.41,1.0900000000000001,-2.0099999999999998,-2.0099999999999998,2,7.69,null,35,8.36,0.4,1.0900000000000001,-2.92,-2.92,1.7,7.69,null,35,7.92,0.39,1.1000000000000001,-3.79,-3.79,1.5,7.69]
[36,12.12,0.56999999999999995,1.08,2.95,2.95,0.15,7.9,null,36,9.49,0.44,1.1000000000000001,-1.0900000000000001,-1.0900000000000001,3.5,7.9,null,36,9.01,0.43,1.1100000000000001,-2.0299999999999998,-2.0299999999999998,2,7.9,null,36,8.5399999999999991,0.41,1.1100000000000001,-2.94,-2.94,1.7,7.9,null,36,8.08,0.4,1.1200000000000001,-3.81,-3.81,1.5,7.9]
[37,12.38,0.59,1.1000000000000001,2.95,2.95,0.15,8.1199999999999992,null,37,9.6999999999999993,0.45,1.1200000000000001,-1.1000000000000001,-1.1000000000000001,3.5,8.1199999999999992,null,37,9.1999999999999993,0.44,1.1299999999999999,-2.0499999999999998,-2.0499999999999998,2,8.1199999999999992,null,37,8.7200000000000006,0.43,1.1299999999999999,-2.96,-2.96,1.7,8.1199999999999992,null,37,8.25,0.42,1.1399999999999999,-3.84,-3.84,1.5,8.1199999999999992]
[38,12.66,0.6,1.1200000000000001,2.95,2.95,0.15,8.35,null,38,9.91,0.46,1.1399999999999999,-1.1200000000000001,-1.1200000000000001,3.5,8.35,null,38,9.4,0.45,1.1499999999999999,-2.06,-2.06,2,8.35,null,38,8.91,0.44,1.1599999999999999,-2.98,-2.98,1.7,8.35,null,38,8.43,0.43,1.1599999999999999,-3.86,-3.86,1.5,8.35]
[39,12.94,0.62,1.1399999999999999,2.94,2.94,0.15,8.58,null,39,10.119999999999999,0.48,1.17,-1.1299999999999999,-1.1299999999999999,3.5,8.58,null,39,9.6,0.46,1.17,-2.08,-2.08,2,8.58,null,39,9.1,0.45,1.18,-3,-3,1.7,8.58,null,39,8.61,0.44,1.19,-3.88,-3.88,1.5,8.58]
[40,13.23,0.63,1.1599999999999999,2.94,2.94,0.15,8.82,null,40,10.34,0.49,1.19,-1.1499999999999999,-1.1499999999999999,3.5,8.82,null,40,9.81,0.48,1.19,-2.1,-2.1,2,8.82,null,40,9.2899999999999991,0.47,1.2,-3.02,-3.02,1.7,8.82,null,40,8.7899999999999991,0.45,1.21,-3.9,-3.9,1.5,8.82]
[41,13.52,0.64,1.18,2.94,2.94,0.15,9.06,null,41,10.57,0.51,1.21,-1.17,-1.17,3.5,9.06,null,41,10.02,0.49,1.21,-2.12,-2.12,2,9.06,null,41,9.49,0.48,1.22,-3.04,-3.04,1.7,9.06,null,41,8.98,0.47,1.23,-3.93,-3.93,1.5,9.06]
[42,13.82,0.66,1.2,2.93,2.93,0.15,9.32,null,42,10.8,0.52,1.23,-1.18,-1.18,3.5,9.32,null,42,10.24,0.51,1.24,-2.14,-2.14,2,9.32,null,42,9.6999999999999993,0.49,1.24,-3.06,-3.06,1.7,9.32,null,42,9.17,0.48,1.25,-3.95,-3.95,1.5,9.32]
[43,14.13,0.68,1.22,2.93,2.93,0.15,9.58,null,43,11.03,0.54,1.25,-1.2,-1.2,3.5,9.58,null,43,10.46,0.52,1.26,-2.16,-2.16,2,9.58,null,43,9.91,0.51,1.26,-3.08,-3.08,1.7,9.58,null,43,9.3699999999999992,0.49,1.27,-3.98,-3.98,1.5,9.58]
[44,14.45,0.69,1.24,2.93,2.93,0.15,9.84,null,44,11.27,0.55000000000000004,1.27,-1.22,-1.22,3.5,9.84,null,44,10.69,0.54,1.28,-2.1800000000000002,-2.1800000000000002,2,9.84,null,44,10.119999999999999,0.52,1.29,-3.11,-3.11,1.7,9.84,null,44,9.57,0.51,1.29,-4,-4,1.5,9.84]
[45,14.77,0.71,1.26,2.92,2.92,0.15,10.119999999999999,null,45,11.52,0.56999999999999995,1.29,-1.23,-1.23,3.5,10.119999999999999,null,45,10.92,0.55000000000000004,1.3,-2.2000000000000002,-2.2000000000000002,2,10.119999999999999,null,45,10.34,0.54,1.31,-3.13,-3.13,1.7,10.119999999999999,null,45,9.77,0.52,1.32,-4.0199999999999996,-4.0199999999999996,1.5,10.119999999999999]
[46,15.1,0.73,1.28,2.92,2.92,0.15,10.4,null,46,11.77,0.59,1.31,-1.25,-1.25,3.5,10.4,null,46,11.16,0.56999999999999995,1.32,-2.2200000000000002,-2.2200000000000002,2,10.4,null,46,10.56,0.55000000000000004,1.33,-3.15,-3.15,1.7,10.4,null,46,9.98,0.54,1.34,-4.05,-4.05,1.5,10.4]
[47,15.44,0.74,1.3,2.92,2.92,0.15,10.69,null,47,12.03,0.6,1.33,-1.27,-1.27,3.5,10.69,null,47,11.4,0.59,1.34,-2.2400000000000002,-2.2400000000000002,2,10.69,null,47,10.79,0.56999999999999995,1.35,-3.17,-3.17,1.7,10.69,null,47,10.199999999999999,0.55000000000000004,1.36,-4.07,-4.07,1.5,10.69]
[48,15.79,0.76,1.32,2.91,2.91,0.15,10.99,null,48,12.29,0.62,1.35,-1.28,-1.28,3.5,10.99,null,48,11.65,0.6,1.36,-2.2599999999999998,-2.2599999999999998,2,10.99,null,48,11.02,0.59,1.37,-3.2,-3.2,1.7,10.99,null,48,10.42,0.56999999999999995,1.38,-4.0999999999999996,-4.0999999999999996,1.5,10.99]
[49,16.149999999999999,0.78,1.34,2.91,2.91,0.15,11.3,null,49,12.57,0.64,1.38,-1.3,-1.3,3.5,11.3,null,49,11.91,0.62,1.38,-2.2799999999999998,-2.2799999999999998,2,11.3,null,49,11.26,0.6,1.39,-3.22,-3.22,1.7,11.3,null,49,10.64,0.59,1.4,-4.12,-4.12,1.5,11.3]
[50,16.52,0.8,1.36,2.91,2.91,0.15,11.62,null,50,12.84,0.66,1.4,-1.32,-1.32,3.5,11.62,null,50,12.17,0.64,1.4,-2.2999999999999998,-2.2999999999999998,2,11.62,null,50,11.51,0.62,1.41,-3.24,-3.24,1.7,11.62,null,50,10.87,0.6,1.42,-4.1500000000000004,-4.1500000000000004,1.5,11.62]
[51,16.89,0.82,1.38,2.9,2.9,0.15,11.95,null,51,13.13,0.68,1.41,-1.34,-1.34,3.5,11.95,null,51,12.44,0.66,1.42,-2.3199999999999998,-2.3199999999999998,2,11.95,null,51,11.76,0.64,1.43,-3.27,-3.27,1.7,11.95,null,51,11.11,0.62,1.44,-4.18,-4.18,1.5,11.95]
[52,17.28,0.84,1.4,2.9,2.9,0.15,12.29,null,52,13.42,0.7,1.43,-1.36,-1.36,3.5,12.29,null,52,12.71,0.68,1.44,-2.34,-2.34,2,12.29,null,52,12.02,0.66,1.45,-3.29,-3.29,1.7,12.29,null,52,11.35,0.64,1.46,-4.21,-4.21,1.5,12.29]
[53,17.68,0.86,1.42,2.9,2.9,0.15,12.64,null,53,13.72,0.72,1.45,-1.37,-1.37,3.5,12.64,null,53,13,0.7,1.46,-2.36,-2.36,2,12.64,null,53,12.29,0.68,1.47,-3.32,-3.32,1.7,12.64,null,53,11.6,0.66,1.48,-4.2300000000000004,-4.2300000000000004,1.5,12.64]
[54,18.09,0.88,1.43,2.9,2.9,0.15,13,null,54,14.04,0.74,1.47,-1.39,-1.39,3.5,13,null,54,13.29,0.72,1.48,-2.39,-2.39,2,13,null,54,12.56,0.7,1.49,-3.34,-3.34,1.7,13,null,54,11.86,0.68,1.5,-4.26,-4.26,1.5,13]
[55,18.510000000000002,0.9,1.45,2.9,2.9,0.15,13.38,null,55,14.36,0.76,1.48,-1.41,-1.41,3.5,13.38,null,55,13.59,0.74,1.49,-2.41,-2.41,2,13.38,null,55,12.85,0.72,1.5,-3.37,-3.37,1.7,13.38,null,55,12.12,0.7,1.51,-4.29,-4.29,1.5,13.38]
[56,18.95,0.92,1.46,2.9,2.9,0.15,13.77,null,56,14.68,0.78,1.5,-1.43,-1.43,3.5,13.77,null,56,13.9,0.76,1.51,-2.4300000000000002,-2.4300000000000002,2,13.77,null,56,13.14,0.74,1.52,-3.4,-3.4,1.7,13.77,null,56,12.4,0.72,1.53,-4.32,-4.32,1.5,13.77]
[57,19.399999999999999,0.94,1.47,2.9,2.9,0.15,14.17,null,57,15.03,0.8,1.51,-1.45,-1.45,3.5,14.17,null,57,14.22,0.78,1.52,-2.46,-2.46,2,14.17,null,57,13.44,0.76,1.53,-3.42,-3.42,1.7,14.17,null,57,12.68,0.74,1.54,-4.3600000000000003,-4.3600000000000003,1.5,14.17]
[58,19.87,0.97,1.48,2.9,2.9,0.15,14.59,null,58,15.38,0.83,1.52,-1.47,-1.47,3.5,14.59,null,58,14.55,0.8,1.53,-2.48,-2.48,2,14.59,null,58,13.75,0.78,1.54,-3.45,-3.45,1.7,14.59,null,58,12.97,0.76,1.55,-4.3899999999999997,-4.3899999999999997,1.5,14.59]
[59,20.350000000000001,0.99,1.49,2.97,2.97,0.15,15.02,null,59,15.74,0.85,1.53,-1.53,-1.53,3.5,15.02,null,59,14.89,0.83,1.54,-2.57,-2.57,2,15.02,null,59,14.07,0.8,1.55,-3.57,-3.57,1.7,15.02,null,59,13.27,0.78,1.56,-4.53,-4.53,1.5,15.02]
[60,0,0,0,0,0,0,0,null,60,16.12,0.88,1.54,-1.1000000000000001,-3.72,3.5,15.47,null,60,15.25,0.85,1.55,-2.1800000000000002,-4.5999999999999996,2,15.47,null,60,14.4,0.83,1.56,-3.22,-5.45,1.7,15.47,null,60,13.58,0.8,1.57,-4.2300000000000004,-6.28,1.5,15.47]
[61,0,0,0,0,0,0,0,null,61,16.5,0.9,1.54,-0.14000000000000001,-2.82,3.5,15.94,null,61,15.61,0.88,1.55,-1.25,-3.74,2,15.94,null,61,14.74,0.85,1.57,-2.33,-4.62,1.7,15.94,null,61,13.9,0.83,1.58,-3.36,-5.47,1.5,15.94]
[62,0,0,0,0,0,0,0,null,62,16.91,0.93,1.55,0.86,-1.9,3.5,16.420000000000002,null,62,15.99,0.9,1.56,-0.28999999999999998,-2.85,2,16.420000000000002,null,62,15.1,0.88,1.57,-1.4,-3.76,1.7,16.420000000000002,null,62,14.23,0.85,1.58,-2.4700000000000002,-4.6399999999999997,1.5,16.420000000000002]
[63,0,0,0,0,0,0,0,null,63,17.329999999999998,0.96,1.55,1.89,-0.95,3.5,16.93,null,63,16.39,0.93,1.56,0.7,-1.93,2,16.93,null,63,15.47,0.9,1.57,-0.45,-2.87,1.7,16.93,null,63,14.58,0.88,1.58,-1.55,-3.78,1.5,16.93]
[64,0,0,0,0,0,0,0,null,64,17.77,0.99,1.55,2.95,0.03,3.5,17.46,null,64,16.8,0.96,1.56,1.72,-0.98,2,17.46,null,64,15.86,0.93,1.57,0.54,-1.95,1.7,17.46,null,64,14.94,0.9,1.58,-0.6,-2.89,1.5,17.46]
[60,0,0,0,0,0,0,0,null,65,0,0,0,0,0,0,0,null,65,17.23,0.99,1.56,2.78,0,2,17.5,null,65,16.260000000000002,0.96,1.57,1.56,-1,1.7,17.5,null,65,15.32,0.93,1.58,0.38,-1.97,1.5,17.5]
[61,0,0,0,0,0,0,0,null,66,0,0,0,0,0,0,0,null,66,17.09,1,1.54,3.34,3.34,0.15,17.170000000000002,null,66,16.68,0.99,1.56,2.62,-0.02,1.7,17.04,null,66,15.71,0.96,1.58,1.4,-1.03,1.5,17.04]
[62,0,0,0,0,0,0,0,null,67,0,0,0,0,0,0,0,null,67,16.63,1,1.53,3.18,3.18,0.15,16.71,null,67,0,0,0,0,0,0,0,null,67,16.12,0.99,1.57,2.4500000000000002,-0.05,1.5,16.57]
[63,0,0,0,0,0,0,0,null,68,0,0,0,0,0,0,0,null,68,16.16,1,1.51,3.01,3.01,0.15,16.25,null,68,0,0,0,0,0,0,0,null,68,0,0,0,0,0,0,0]
[64,0,0,0,0,0,0,0,null,69,0,0,0,0,0,0,0,null,69,15.68,1,1.48,2.85,2.85,0.15,15.78,null,69,0,0,0,0,0,0,0,null,69,0,0,0,0,0,0,0]
[65,0,0,0,0,0,0,0,null,70,0,0,0,0,0,0,0,null,70,15.19,1,1.46,2.68,2.68,0.15,15.3,null,70,0,0,0,0,0,0,0,null,70,0,0,0,0,0,0,0]
[66,0,0,0,0,0,0,0,null,71,0,0,0,0,0,0,0,null,71,14.7,1,1.42,2.5299999999999998,2.5299999999999998,0.15,14.82,null,71,0,0,0,0,0,0,0,null,71,0,0,0,0,0,0,0]
[67,0,0,0,0,0,0,0,null,72,0,0,0,0,0,0,0,null,72,14.2,1,1.39,2.37,2.37,0.15,14.34,null,72,0,0,0,0,0,0,0,null,72,0,0,0,0,0,0,0]
[68,0,0,0,0,0,0,0,null,73,0,0,0,0,0,0,0,null,73,13.69,1,1.34,2.2200000000000002,2.2200000000000002,0.15,13.85,null,73,0,0,0,0,0,0,0,null,73,0,0,0,0,0,0,0]
[69,0,0,0,0,0,0,0,null,74,0,0,0,0,0,0,0,null,74,13.18,1,1.29,2.0699999999999998,2.0699999999999998,0.15,13.36,null,74,0,0,0,0,0,0,0,null,74,0,0,0,0,0,0,0]
[70,0,0,0,0,0,0,0]
[71,0,0,0,0,0,0,0]
[72,0,0,0,0,0,0,0]
[73,0,0,0,0,0,0,0]