{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["VERA Pension Factors","VERA LS Factors","PI Data","Contents","Guidance Notes","Member Details","Age","PI Finder","Benefit Certificate","Letter","Practitioners Member Details","Practitioners Letter","Practitioners PI Finder","Practitioners Ben Certificate"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":14,"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":"VERA Pension Factors","index":0,"n_rows":59,"n_cols":28,"rows_kept":59,"cut":false,"hidden":true,"merged":[[7,0,7,12],[36,0,36,12],[7,15,7,27],[36,15,36,27]]}
[1995]
["TABLE ERF1","Updated 29/01/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE ERF1",null,"Prior to factor change"]
["NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS"]
["BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)"]
["MEMBERS OF 1995 SECTION (RELATIVE TO PENSION AGE OF 60)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEMBERS OF 1995 SECTION (RELATIVE TO PENSION AGE OF 60)"]
[]
["Age: complete months",0,1,2,3,4,5,6,7,8,9,10,11,null,null,"Age: complete months",0,1,2,3,4,5,6,7,8,9,10,11]
["PENSION FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENSION FACTORS"]
[50,0.65400000000000003,0.65600000000000003,0.65800000000000003,0.66,0.66200000000000003,0.66400000000000003,0.66600000000000004,0.66800000000000004,0.67,0.67200000000000004,0.67400000000000004,0.67700000000000005,null,null,50,0.63300000000000001,0.63500000000000001,0.63700000000000001,0.64,0.64200000000000002,0.64400000000000002,0.64600000000000002,0.64800000000000002,0.65,0.65300000000000002,0.65500000000000003,0.65700000000000003]
[51,0.67900000000000005,0.68100000000000005,0.68300000000000005,0.68500000000000005,0.68700000000000006,0.68899999999999995,0.69199999999999995,0.69399999999999995,0.69599999999999995,0.69799999999999995,0.7,0.70199999999999996,null,null,51,0.65900000000000003,0.66100000000000003,0.66400000000000003,0.66600000000000004,0.66800000000000004,0.67100000000000004,0.67300000000000004,0.67500000000000004,0.67800000000000005,0.68,0.68200000000000005,0.68500000000000005]
[52,0.70499999999999996,0.70699999999999996,0.70899999999999996,0.71199999999999997,0.71399999999999997,0.71599999999999997,0.71899999999999997,0.72099999999999997,0.72299999999999998,0.72599999999999998,0.72799999999999998,0.73,null,null,52,0.68700000000000006,0.69,0.69199999999999995,0.69499999999999995,0.69699999999999995,0.7,0.70199999999999996,0.70499999999999996,0.70699999999999996,0.71,0.71199999999999997,0.71499999999999997]
[53,0.73299999999999998,0.73499999999999999,0.73799999999999999,0.74,0.74299999999999999,0.745,0.748,0.75,0.753,0.755,0.75800000000000001,0.76,null,null,53,0.71699999999999997,0.72,0.72299999999999998,0.72499999999999998,0.72799999999999998,0.73099999999999998,0.73299999999999998,0.73599999999999999,0.73899999999999999,0.74199999999999999,0.74399999999999999,0.747]
[54,0.76300000000000001,0.76600000000000001,0.76800000000000002,0.77100000000000002,0.77400000000000002,0.77700000000000002,0.77900000000000003,0.78200000000000003,0.78500000000000003,0.78800000000000003,0.79,0.79300000000000004,null,null,54,0.75,0.753,0.75600000000000001,0.75900000000000001,0.76200000000000001,0.76500000000000001,0.76800000000000002,0.77100000000000002,0.77400000000000002,0.77700000000000002,0.78,0.78300000000000003]
[55,0.79600000000000004,0.79900000000000004,0.80200000000000005,0.80500000000000005,0.80800000000000005,0.81100000000000005,0.81399999999999995,0.81699999999999995,0.82,0.82199999999999995,0.82499999999999996,0.82799999999999996,null,null,55,0.78600000000000003,0.78900000000000003,0.79200000000000004,0.79500000000000004,0.79800000000000004,0.80100000000000005,0.80500000000000005,0.80800000000000005,0.81100000000000005,0.81399999999999995,0.81699999999999995,0.82]
[56,0.83099999999999996,0.83499999999999996,0.83799999999999997,0.84099999999999997,0.84399999999999997,0.84699999999999998,0.85,0.85399999999999998,0.85699999999999998,0.86,0.86299999999999999,0.86599999999999999,null,null,56,0.82399999999999995,0.82699999999999996,0.83,0.83399999999999996,0.83699999999999997,0.84,0.84399999999999997,0.84699999999999998,0.85,0.85399999999999998,0.85699999999999998,0.86]
[57,0.86899999999999999,0.873,0.876,0.879,0.88300000000000001,0.88600000000000001,0.89,0.89300000000000002,0.89600000000000002,0.9,0.90300000000000002,0.90700000000000003,null,null,57,0.86399999999999999,0.86699999999999999,0.871,0.875,0.878,0.88200000000000001,0.88500000000000001,0.88900000000000001,0.89200000000000002,0.89600000000000002,0.9,0.90300000000000002]
[58,0.91,0.91400000000000003,0.91700000000000004,0.92100000000000004,0.92400000000000004,0.92800000000000005,0.93200000000000005,0.93500000000000005,0.93899999999999995,0.94299999999999995,0.94599999999999995,0.95,null,null,58,0.90700000000000003,0.91100000000000003,0.91500000000000004,0.91800000000000004,0.92200000000000004,0.92600000000000005,0.93,0.93400000000000005,0.93799999999999994,0.94099999999999995,0.94499999999999995,0.94899999999999995]
[59,0.95299999999999996,0.95699999999999996,0.96099999999999997,0.96499999999999997,0.96899999999999997,0.97299999999999998,0.97699999999999998,0.98099999999999998,0.98499999999999999,0.98899999999999999,0.99299999999999999,0.996,null,null,59,0.95299999999999996,0.95699999999999996,0.96099999999999997,0.96499999999999997,0.96899999999999997,0.97299999999999998,0.97699999999999998,0.98199999999999998,0.98599999999999999,0.99,0.99399999999999999,0.998]
[]
["Notes: ","(1) these factors are applicable to use to calculate the actuarial reduction on voluntary early retirement for 1995 section members’ main scheme benefits, 1995 section members’ NPA 60 Added Years’ benefits and 1995 section members’ NPA 60 Additional Pension benefits (contracts exercised from 1 April 2011 onwards) (subject to note 5) "]
[null,"(2) benefits to be awarded are obtained by multiplying the accrued benefits (see note 3 below for Added Years’ benefits) by the relevant factor"]
[null,"(3) amount of Added Years’ benefit must first be multiplied by an appropriate proportion. This is calculated as 'period for which contributions were paid divided by period for which contributions should have been paid' "]
[null,"(4) reduced benefits to be calculated before any lump sum commutation option is exercised"]
[null,"(5) factors NOT to be used for former members with preserved benefits retiring early below age 55 – see Table ERF3"]
[]
[]
[]
[]
[]
[2008]
["TABLE ERF2","Updated 29/01/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE ERF2",null,"Prior to factor change"]
["NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS"]
["BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)"]
["MEMBERS OF 1995 or 2008 SECTION (RELATIVE TO PENSION AGE OF 65)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEMBERS OF 1995 or 2008 SECTION (RELATIVE TO PENSION AGE OF 65)"]
[]
["Age: complete months",0,1,2,3,4,5,6,7,8,9,10,11,null,null,"Age: complete months",0,1,2,3,4,5,6,7,8,9,10,11]
["PENSION FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENSION FACTORS"]
["Complete Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Years"]
[50,0.51,0.51100000000000001,0.51300000000000001,0.51500000000000001,0.51600000000000001,0.51800000000000002,0.51900000000000002,0.52100000000000002,0.52200000000000002,0.52400000000000002,0.52500000000000002,0.52700000000000002,null,null,50,0.48499999999999999,0.48599999999999999,0.48799999999999999,0.49,0.49099999999999999,0.49299999999999999,0.495,0.496,0.498,0.5,0.501,0.503]
[51,0.52800000000000002,0.53,0.53200000000000003,0.53300000000000003,0.53500000000000003,0.53700000000000003,0.53800000000000003,0.54,0.54200000000000004,0.54300000000000004,0.54500000000000004,0.54700000000000004,null,null,51,0.505,0.50600000000000001,0.50800000000000001,0.51,0.51200000000000001,0.51400000000000001,0.51500000000000001,0.51700000000000002,0.51900000000000002,0.52100000000000002,0.52200000000000002,0.52400000000000002]
[52,0.54800000000000004,0.55000000000000004,0.55200000000000005,0.55400000000000005,0.55600000000000005,0.55700000000000005,0.55900000000000005,0.56100000000000005,0.56299999999999994,0.56399999999999995,0.56599999999999995,0.56799999999999995,null,null,52,0.52600000000000002,0.52800000000000002,0.53,0.53200000000000003,0.53400000000000003,0.53600000000000003,0.53800000000000003,0.53900000000000003,0.54100000000000004,0.54300000000000004,0.54500000000000004,0.54700000000000004]
[53,0.56999999999999995,0.57199999999999995,0.57399999999999995,0.57599999999999996,0.57799999999999996,0.57999999999999996,0.58099999999999996,0.58299999999999996,0.58499999999999996,0.58699999999999997,0.58899999999999997,0.59099999999999997,null,null,53,0.54900000000000004,0.55100000000000005,0.55300000000000005,0.55500000000000005,0.55700000000000005,0.55900000000000005,0.56200000000000006,0.56399999999999995,0.56599999999999995,0.56799999999999995,0.56999999999999995,0.57199999999999995]
[54,0.59299999999999997,0.59499999999999997,0.59699999999999998,0.59899999999999998,0.60099999999999998,0.60399999999999998,0.60599999999999998,0.60799999999999998,0.61,0.61199999999999999,0.61399999999999999,0.61599999999999999,null,null,54,0.57399999999999995,0.57599999999999996,0.57899999999999996,0.58099999999999996,0.58299999999999996,0.58499999999999996,0.58799999999999997,0.59,0.59199999999999997,0.59499999999999997,0.59699999999999998,0.59899999999999998]
[55,0.61799999999999999,0.62,0.623,0.625,0.627,0.63,0.63200000000000001,0.63400000000000001,0.63600000000000001,0.63900000000000001,0.64100000000000001,0.64300000000000002,null,null,55,0.60099999999999998,0.60399999999999998,0.60599999999999998,0.60899999999999999,0.61099999999999999,0.61399999999999999,0.61599999999999999,0.61799999999999999,0.621,0.623,0.626,0.628]
[56,0.64600000000000002,0.64800000000000002,0.65,0.65300000000000002,0.65500000000000003,0.65800000000000003,0.66,0.66300000000000003,0.66500000000000004,0.66800000000000004,0.67,0.67200000000000004,null,null,56,0.63,0.63300000000000001,0.63600000000000001,0.63800000000000001,0.64100000000000001,0.64300000000000002,0.64600000000000002,0.64800000000000002,0.65100000000000002,0.65400000000000003,0.65600000000000003,0.65900000000000003]
[57,0.67500000000000004,0.67700000000000005,0.68,0.68300000000000005,0.68500000000000005,0.68799999999999994,0.69,0.69299999999999995,0.69599999999999995,0.69799999999999995,0.70099999999999996,0.70299999999999996,null,null,57,0.66100000000000003,0.66400000000000003,0.66700000000000004,0.67,0.67200000000000004,0.67500000000000004,0.67800000000000005,0.68100000000000005,0.68300000000000005,0.68600000000000005,0.68899999999999995,0.69199999999999995]
[58,0.70599999999999996,0.70899999999999996,0.71199999999999997,0.71399999999999997,0.71699999999999997,0.72,0.72299999999999998,0.72599999999999998,0.72799999999999998,0.73099999999999998,0.73399999999999999,0.73699999999999999,null,null,58,0.69399999999999995,0.69699999999999995,0.7,0.70299999999999996,0.70599999999999996,0.70899999999999996,0.71199999999999997,0.71499999999999997,0.71799999999999997,0.72099999999999997,0.72399999999999998,0.72699999999999998]
[59,0.74,0.74299999999999999,0.746,0.749,0.752,0.755,0.75800000000000001,0.76100000000000001,0.76400000000000001,0.76600000000000001,0.76900000000000002,0.77200000000000002,null,null,59,0.73,0.73299999999999998,0.73599999999999999,0.73899999999999999,0.74199999999999999,0.745,0.748,0.752,0.755,0.75800000000000001,0.76100000000000001,0.76400000000000001]
[60,0.77500000000000002,0.77900000000000003,0.78200000000000003,0.78500000000000003,0.78800000000000003,0.79200000000000004,0.79500000000000004,0.79800000000000004,0.80100000000000005,0.80400000000000005,0.80800000000000005,0.81100000000000005,null,null,60,0.76700000000000002,0.77100000000000002,0.77400000000000002,0.77700000000000002,0.78100000000000003,0.78400000000000003,0.78700000000000003,0.79100000000000004,0.79400000000000004,0.79700000000000004,0.80100000000000005,0.80400000000000005]
[61,0.81399999999999995,0.81799999999999995,0.82099999999999995,0.82499999999999996,0.82799999999999996,0.83099999999999996,0.83499999999999996,0.83799999999999997,0.84199999999999997,0.84499999999999997,0.84899999999999998,0.85199999999999998,null,null,61,0.80800000000000005,0.81100000000000005,0.81499999999999995,0.81899999999999995,0.82199999999999995,0.82599999999999996,0.82899999999999996,0.83299999999999996,0.83699999999999997,0.84,0.84399999999999997,0.84699999999999998]
[62,0.85599999999999998,0.86,0.86299999999999999,0.86699999999999999,0.871,0.875,0.878,0.88200000000000001,0.88600000000000001,0.89,0.89300000000000002,0.89700000000000002,null,null,62,0.85099999999999998,0.85499999999999998,0.85899999999999999,0.86299999999999999,0.86699999999999999,0.87,0.874,0.878,0.88200000000000001,0.88600000000000001,0.89,0.89400000000000002]
[63,0.90100000000000002,0.90500000000000003,0.90900000000000003,0.91300000000000003,0.91700000000000004,0.92100000000000004,0.92600000000000005,0.93,0.93400000000000005,0.93799999999999994,0.94199999999999995,0.94599999999999995,null,null,63,0.89800000000000002,0.90200000000000002,0.90600000000000003,0.91,0.91400000000000003,0.91900000000000004,0.92300000000000004,0.92700000000000005,0.93100000000000005,0.93500000000000005,0.94,0.94399999999999995]
[64,0.95,0.95399999999999996,0.95799999999999996,0.96299999999999997,0.96699999999999997,0.97099999999999997,0.97499999999999998,0.97899999999999998,0.98299999999999998,0.98799999999999999,0.99199999999999999,0.996,null,null,64,0.94799999999999995,0.95299999999999996,0.95699999999999996,0.96199999999999997,0.96599999999999997,0.97099999999999997,0.97499999999999998,0.98,0.98399999999999999,0.98899999999999999,0.99299999999999999,0.998]
[]
["Notes: ","(1) these factors are applicable to use for 2008 section members’ main scheme benefits, 1995 section members’ NPA 65 Added Years’ pension or 1995 or 2008 section members’ NPA 65 Additional Pension (contracts taken from 1 April 2011 onwards).  See also paragraph 1.6 of the guidance."]
[null,"(2) benefits to be awarded are obtained by multiplying the accrued benefits (for Added Years’ pension see note 3) by the relevant factor"]
[null,"(3) amount of Added Years’ benefit must first be multiplied by an appropriate proportion. This is calculated as 'period for which contributions were paid divided by period for which contributions should have been paid' "]
[null,"(4) reduced benefits to be calculated before any lump sum commutation option is exercised"]
[null,"(5) shaded figures to be used for 1995 section members only"]

{"sheet":"VERA LS Factors","index":1,"n_rows":24,"n_cols":28,"rows_kept":24,"cut":false,"hidden":true,"merged":[[7,0,7,12],[7,15,7,27]]}
[]
["TABLE ERF7","Updated 29/01/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE ERF7",null,"Prior to factor change"]
["NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS SUPERANNUATION SCHEME SCOTLAND: ACTUARIAL FACTORS"]
["BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BENEFITS PAYABLE TO THE MEMBER ON VOLUNTARY EARLY RETIREMENT (WITH ACTUARIAL REDUCTION)"]
["MEMBERS OF 1995 SECTION (RELATIVE TO PENSION AGE OF 60)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MEMBERS OF 1995 SECTION (RELATIVE TO PENSION AGE OF 60)"]
[]
["AGE: complete months",0,1,2,3,4,5,6,7,8,9,10,11,null,null,"AGE: complete months",0,1,2,3,4,5,6,7,8,9,10,11]
["LUMP SUM FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LUMP SUM FACTORS"]
["Complete Years:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complete Years:"]
[50,0.78900000000000003,0.79,0.79200000000000004,0.79400000000000004,0.79500000000000004,0.79700000000000004,0.79800000000000004,0.8,0.80100000000000005,0.80300000000000005,0.80500000000000005,0.80600000000000005,null,null,50,0.73199999999999998,0.73399999999999999,0.73599999999999999,0.73799999999999999,0.74,0.74199999999999999,0.74399999999999999,0.746,0.748,0.75,0.751,0.753]
[51,0.80800000000000005,0.80900000000000005,0.81100000000000005,0.81299999999999994,0.81399999999999995,0.81599999999999995,0.81699999999999995,0.81899999999999995,0.82099999999999995,0.82199999999999995,0.82399999999999995,0.82599999999999996,null,null,51,0.755,0.75700000000000001,0.75900000000000001,0.76100000000000001,0.76300000000000001,0.76500000000000001,0.76700000000000002,0.76900000000000002,0.77100000000000002,0.77300000000000002,0.77500000000000002,0.77700000000000002]
[52,0.82699999999999996,0.82899999999999996,0.83,0.83199999999999996,0.83399999999999996,0.83499999999999996,0.83699999999999997,0.83899999999999997,0.84,0.84199999999999997,0.84399999999999997,0.84499999999999997,null,null,52,0.77900000000000003,0.78100000000000003,0.78300000000000003,0.78500000000000003,0.78700000000000003,0.78900000000000003,0.79100000000000004,0.79300000000000004,0.79500000000000004,0.79700000000000004,0.79900000000000004,0.80100000000000005]
[53,0.84699999999999998,0.84899999999999998,0.85,0.85199999999999998,0.85399999999999998,0.85599999999999998,0.85699999999999998,0.85899999999999999,0.86099999999999999,0.86199999999999999,0.86399999999999999,0.86599999999999999,null,null,53,0.80300000000000005,0.80500000000000005,0.80800000000000005,0.81,0.81200000000000006,0.81399999999999995,0.81599999999999995,0.81799999999999995,0.82,0.82199999999999995,0.82399999999999995,0.82699999999999996]
[54,0.86699999999999999,0.86899999999999999,0.871,0.873,0.874,0.876,0.878,0.88,0.88100000000000001,0.88300000000000001,0.88500000000000001,0.88600000000000001,null,null,54,0.82899999999999996,0.83099999999999996,0.83299999999999996,0.83499999999999996,0.83699999999999997,0.84,0.84199999999999997,0.84399999999999997,0.84599999999999997,0.84799999999999998,0.85099999999999998,0.85299999999999998]
[55,0.88800000000000001,0.89,0.89200000000000002,0.89400000000000002,0.89500000000000002,0.89700000000000002,0.89900000000000002,0.90100000000000002,0.90200000000000002,0.90400000000000003,0.90600000000000003,0.90800000000000003,null,null,55,0.85499999999999998,0.85699999999999998,0.85899999999999999,0.86199999999999999,0.86399999999999999,0.86599999999999999,0.86899999999999999,0.871,0.873,0.875,0.878,0.88]
[56,0.90900000000000003,0.91100000000000003,0.91300000000000003,0.91500000000000004,0.91700000000000004,0.91900000000000004,0.92,0.92200000000000004,0.92400000000000004,0.92600000000000005,0.92800000000000005,0.93,null,null,56,0.88200000000000001,0.88500000000000001,0.88700000000000001,0.88900000000000001,0.89200000000000002,0.89400000000000002,0.89600000000000002,0.89900000000000002,0.90100000000000002,0.90300000000000002,0.90600000000000003,0.90800000000000003]
[57,0.93100000000000005,0.93300000000000005,0.93500000000000005,0.93700000000000006,0.93899999999999995,0.94099999999999995,0.94199999999999995,0.94399999999999995,0.94599999999999995,0.94799999999999995,0.95,0.95199999999999996,null,null,57,0.91,0.91300000000000003,0.91500000000000004,0.91800000000000004,0.92,0.92300000000000004,0.92500000000000004,0.92700000000000005,0.93,0.93200000000000005,0.93500000000000005,0.93700000000000006]
[58,0.95399999999999996,0.95599999999999996,0.95699999999999996,0.95899999999999996,0.96099999999999997,0.96299999999999997,0.96499999999999997,0.96699999999999997,0.96899999999999997,0.97099999999999997,0.97299999999999998,0.97499999999999998,null,null,58,0.94,0.94199999999999995,0.94499999999999995,0.94699999999999995,0.95,0.95199999999999996,0.95499999999999996,0.95699999999999996,0.96,0.96199999999999997,0.96499999999999997,0.96699999999999997]
[59,0.97699999999999998,0.97899999999999998,0.98,0.98199999999999998,0.98399999999999999,0.98599999999999999,0.98799999999999999,0.99,0.99199999999999999,0.99399999999999999,0.996,0.998,null,null,59,0.97,0.97299999999999998,0.97499999999999998,0.97799999999999998,0.98,0.98299999999999998,0.98599999999999999,0.98799999999999999,0.99099999999999999,0.99299999999999999,0.996,0.999]
[]
["Notes: ","(1) these factors are applicable to use to calculate the actuarial reduction on voluntary early retirement for 1995 section members’ main scheme lump sum benefits, 1995 section members’  NPA 60 Added Years’ lump sum benefits , 1995 section members’  NPA 60 unreduced retirement lump sum benefits and the amount of 2008 section members’ mandatory lump sum  benefits payable on voluntary early retirement (where applicable) (subject to note 4)"]
[null,"(2) benefits to be awarded are obtained by multiplying the accrued lump sum (for Added Years’ lump sum and unreduced retirement lump sums see note 3) by the relevant factor"]
[null,"(3) the amount of the Added Years’ unreduced retirement lump sum or the unreduced retirement lump sum must first be multiplied by an appropriate proportion. This is calculated as 'period for which contributions were paid divided by period for which contributions should have been paid' "]
[null,"(4) factors are NOT to be used for former members with preserved benefits retiring early below age 55 – see Table ERF9"]

{"sheet":"PI Data","index":2,"n_rows":547,"n_cols":3,"rows_kept":547,"cut":false,"hidden":true,"merged":[]}
[{"$f":"MIN($B$2:$Z$2)","v":2019}]
[{"$f":"MAX($B$2:$Z$2)","v":2020},2019,2020]
["1945-01-01",41.6404,42.348300000000002]
["1946-01-01",37.851999999999997,38.4955]
["1947-01-01",37.513500000000001,38.151200000000003]
["1948-01-01",35.127600000000001,35.724699999999999]
["1949-01-01",34.160299999999999,34.741]
["1950-01-01",33.193100000000001,33.757300000000001]
["1951-01-01",30.4041,30.920999999999999]
["1952-01-01",27.856999999999999,28.3306]
["1953-01-01",27.002600000000001,27.461600000000001]
["1954-01-01",26.518999999999998,26.969799999999999]
["1955-01-01",25.374400000000001,25.805800000000001]
["1956-01-01",24.197600000000001,24.608899999999998]
["1957-01-01",23.3431,23.74]
["1958-01-01",22.633800000000001,23.018599999999999]
["1959-01-01",22.521000000000001,22.9038]
["1960-01-01",22.295300000000001,22.674299999999999]
["1961-01-01",21.569800000000001,21.936499999999999]
["1962-01-01",20.667100000000001,21.0184]
["1963-01-01",20.280200000000001,20.6249]
["1964-01-01",19.635300000000001,19.969100000000001]
["1965-01-01",18.732600000000001,19.050999999999998]
["1966-01-01",18.023199999999999,18.329599999999999]
["1967-01-01",17.588000000000001,17.887]
["1968-01-01",16.797999999999998,17.083600000000001]
["1969-01-01",16.120999999999999,16.395]
["1969-04-02",15.8477,16.117100000000001]
["1969-10-02",15.5745,15.8393]
["1970-04-02",15.028,15.2835]
["1970-10-02",14.4815,14.7277]
["1971-04-02",13.7986,14.033099999999999]
["1971-10-02",13.1273,13.3505]
["1972-04-02",12.866199999999999,13.085000000000001]
["1972-07-02",12.5563,12.7697]
["1973-01-02",12.0672,12.2723]
["1973-07-02",11.5296,11.7256]
["1974-01-02",10.9634,11.149800000000001]
["1974-07-02",10.010300000000001,10.1805]
["1975-01-02",9.2826000000000004,9.4404000000000003]
["1975-07-02",8.1092999999999993,8.2471999999999994]
["1976-01-02",7.4017871548544001,7.5276175348608003]
["1976-07-02",6.9071540073080007,7.0245756238729999]
["1977-01-02",6.4389703465616011,6.5484328409996007]
["1977-07-02",5.8984446304159999,5.9987181878376008]
["1978-01-02",5.6777911360299997,5.7743135840954993]
["1978-07-02",5.7204743183424007,5.8177223804502001]
["1978-07-28",5.6555216496832008,5.7516655164386004]
["1978-08-28",5.5859295046912001,5.6808903049975994]
["1978-09-28",5.5209768360320002,5.6148334409859997]
["1978-10-28",5.4513846910400012,5.5440582295450005]
["1978-11-28",5.3817925460479996,5.4732830181039995]
["1978-12-28",5.3168398773887997,5.4072261540923989]
["1979-01-28",5.2472477323967999,5.3364509426513997]
["1979-02-28",5.1822950637376,5.2703940786397991]
["1979-03-28",5.112702918745601,5.1996188671988]
["1979-04-28",5.0477502500864002,5.1335620031872002]
["1979-05-28",4.9781581050944004,5.0627867917461993]
["1979-06-28",4.9085659601024005,4.9920115803052001]
["1979-07-28",4.8436132914432006,4.9259547162935995]
["1979-08-28",4.7740211464511999,4.8551795048525994]
["1979-09-28",4.709068477792,4.7891226408409988]
["1979-10-28",4.6394763328195001,4.7183474294160002]
["1979-12-09",4.5837229691632997,4.6616462585903999]
["1980-01-09",4.5319519886253996,4.6089951713951995]
["1980-02-09",4.4761986249692001,4.5522940005696002]
["1980-03-09",4.4204452613130005,4.495592829744]
["1980-04-09",4.3646918976568001,4.4388916589183998]
["1980-05-09",4.3129209171189,4.3862405717231994]
["1980-06-09",4.2571675534626996,4.3295394008975991]
["1980-07-09",4.2014141898065001,4.2728382300719989]
["1980-08-09",4.1456608261502996,4.2161370592463996]
["1980-09-09",4.0938898456124004,4.1634859720512001]
["1980-10-09",4.0381364819562,4.1067848012255999]
["1980-11-09",3.9823831183289999,4.0500836303536003]
["1980-12-08",3.9549964748414999,4.0222314139336]
["1981-01-08",3.9272446761074997,3.9940078346279999]
["1981-02-08",3.8998580326200001,3.9661556182080004]
["1981-03-08",3.8721062338859999,3.9379320389024004]
["1981-04-08",3.8447195903984999,3.9100798224824]
["1981-05-08",3.8169677916644997,3.8818562431767996]
["1981-06-08",3.7895811481770001,3.8540040267568005]
["1981-07-08",3.761829349443,3.8257804474512001]
["1981-08-08",3.7344427059554999,3.7979282310312001]
["1981-09-08",3.7066909072214997,3.7697046517255997]
["1981-10-08",3.6793042637340001,3.7418524353056002]
["1981-11-08",3.6515524649940003,3.7136288560200006]
["1981-12-07",3.6219452828453997,3.6835183517819998]
["1982-01-07",3.5923381006968,3.6534078475440004]
["1982-02-07",3.5627309185481999,3.6232973433060001]
["1982-03-07",3.5298340494942,3.5898412274860001]
["1982-04-07",3.5002268673456003,3.5597307232480002]
["1982-05-07",3.4706196851969997,3.5296202190099999]
["1982-06-07",3.4410125030484,3.499509714772]
["1982-07-07",3.4114053208997999,3.4693992105339997]
["1982-08-07",3.3817981387512002,3.4392887062960003]
["1982-09-07",3.3489012696971998,3.4058325904760003]
["1982-10-07",3.3192940875485997,3.3757220862379995]
["1982-11-07",3.2896869054153997,3.3456115820489996]
["1982-12-06",3.2801699712627999,3.335932860018]
["1983-01-06",3.2706530371101996,3.3262541379869996]
["1983-02-06",3.2611361029575998,3.3165754159559997]
["1983-03-06",3.2516191688049996,3.3068966939249997]
["1983-04-06",3.2421022346523998,3.2972179718939998]
["1983-05-06",3.2325853004997995,3.2875392498629994]
["1983-06-06",3.2198960549629998,3.2746342871549996]
["1983-07-06",3.2103791208104,3.2649555651239996]
["1983-08-06",3.2008621866577998,3.2552768430929997]
["1983-09-06",3.1913452525052,3.2455981210619997]
["1983-10-06",3.1818283183525997,3.2359193990309993]
["1983-11-06",3.1723113841500998,3.2262406770325001]
["1983-12-11",3.1602378869696999,3.2139619304024998]
["1984-01-11",3.1481643897892999,3.2016831837724999]
[{"$f":"DATE(YEAR(A113),MONTH(A113) + 1,DAY(A113))","v":"1984-02-11"},3.1330725183138002,3.1863347504850004]
["1984-03-11",3.1209990211334002,3.1740560038550001]
["1984-04-11",3.1089255239530003,3.1617772572250002]
["1984-05-11",3.0968520267726003,3.1494985105950004]
["1984-06-11",3.0817601552970997,3.1341500773074999]
["1984-07-11",3.0696866581166997,3.1218713306774997]
["1984-08-11",3.0576131609362998,3.1095925840474998]
["1984-09-11",3.0455396637558998,3.0973138374175]
["1984-10-11",3.0304477922804001,3.08196540413]
["1984-11-11",3.018374295134,3.0696866574500001]
["1984-12-10",3.0014488317968002,3.05247346124]
[{"$f":"DATE(YEAR(A124),MONTH(A124) + 1,DAY(A124))","v":"1985-01-10"},2.9845233684596,3.0352602650300002]
["1985-02-10",2.9704188156785998,3.0209159348549997]
["1985-03-10",2.9534933523413995,3.0037027386449999]
["1985-04-10",2.9365678890041997,2.9864895424349998]
["1985-05-10",2.9196424256669995,2.9692763462249996]
["1985-06-10",2.9027169623297997,2.9520631500149999]
["1985-07-10",2.8857914989925995,2.9348499538049997]
["1985-08-10",2.8716869462115997,2.92050562363]
["1985-09-10",2.8547614828743999,2.9032924274199998]
["1985-10-10",2.8378360195371997,2.8860792312100001]
["1985-11-10",2.8209105562214996,2.8688660350094999]
["1985-12-13",2.8170042508024,2.8648933223992001]
[{"$f":"DATE(YEAR(A136),MONTH(A136) + 1,DAY(A136))","v":"1986-01-13"},2.8133769671989497,2.8612043749753502]
["1986-02-13",2.8094706617798497,2.85723166236505]
["1986-03-13",2.8055643563607502,2.8532589497547503]
["1986-04-13",2.8016580509416498,2.8492862371444501]
["1986-05-13",2.7980307673381999,2.8455972897206001]
["1986-06-13",2.7941244619190999,2.8416245771103004]
["1986-07-13",2.7902181565066999,2.8376518644568001]
["1986-08-22",2.78311280174968,2.8304257186707202]
[{"$f":"DATE(YEAR(A144),MONTH(A144) + 1,DAY(A144))","v":"1986-09-22"},2.7760074469926601,2.8231995728846404]
["1986-10-22",2.7686288093603699,2.8156954984144797]
["1986-11-22",2.76152345460335,2.8084693526283999]
["1986-12-22",2.7544180998463301,2.8012432068423201]
["1987-01-22",2.7473127450893102,2.7940170610562403]
["1987-02-22",2.73993410745702,2.78651298658608]
["1987-03-22",2.7328287527404003,2.7792868408228002]
["1987-04-27",2.7236493855287001,2.7699514243709]
[{"$f":"DATE(YEAR(A152),MONTH(A152) + 1,DAY(A152))","v":"1987-05-27"},2.7144700183169999,2.7606160079189999]
["1987-06-27",2.7052906511053001,2.7512805914671001]
["1987-07-27",2.6961112838935999,2.7419451750152]
["1987-08-27",2.6869319166819001,2.7326097585632998]
["1987-09-27",2.6777525494701999,2.7232743421113996]
["1987-10-27",2.6685731822585002,2.7139389256595003]
["1987-11-27",2.6593938150467999,2.7046035092076002]
["1987-12-27",2.6502144478350997,2.6952680927557]
["1988-01-27",2.6410350806233995,2.6859326763037998]
["1988-02-27",2.6318557134117002,2.6765972598519001]
["1988-03-27",2.6226763462490998,2.6672618434328998]
["1988-04-26",2.6105412054590902,2.6549204052527102]
[{"$f":"DATE(YEAR(A164),MONTH(A164) + 1,DAY(A164))","v":"1988-05-26"},2.5984060646690796,2.6425789670725197]
["1988-06-26",2.58627092387907,2.6302375288923301]
["1988-07-26",2.5738881271545697,2.6176442246268299]
["1988-08-26",2.5617529863645601,2.6053027864466403]
["1988-09-26",2.5496178455745504,2.5929613482664502]
["1988-10-26",2.5374827047845399,2.5806199100862601]
["1988-11-26",2.5253475639945302,2.5682784719060701]
["1988-12-26",2.5129647672700299,2.5556851676405699]
["1989-01-26",2.5008296264800203,2.5433437294603802]
["1989-02-26",2.4886944856900097,2.5310022912801897]
["1989-03-26",2.4765593448964003,2.5186608530696004]
["1989-04-25",2.4620590438993304,2.5039140469596206]
[{"$f":"DATE(YEAR(A176),MONTH(A176) + 1,DAY(A176))","v":"1989-05-25"},2.4473285793943695,2.4889331645621802]
["1989-06-25",2.4328282783972996,2.4741863584521999]
["1989-07-25",2.4183279774002298,2.4594395523422201]
["1989-08-25",2.4035975128952698,2.4444586699447801]
["1989-09-25",2.3890972118981999,2.4297118638348003]
["1989-10-25",2.37459691090113,2.4149650577248205]
["1989-11-25",2.35986644639617,2.3999841753273805]
["1989-12-25",2.3453661453990997,2.3852373692173998]
["1990-01-25",2.3308658444020298,2.37049056310742]
["1990-02-25",2.3161353798970699,2.35550968070998]
["1990-03-25",2.3016350788527999,2.3407628746316997]
["1990-04-24",2.2827488036340799,2.3215555327388699]
[{"$f":"DATE(YEAR(A188),MONTH(A188) + 1,DAY(A188))","v":"1990-05-24"},2.26386252841536,2.3023481908460397]
["1990-06-24",2.2451837946825601,2.2833519186443398]
["1990-07-24",2.2262975194638397,2.2641445767515096]
["1990-08-24",2.2074112442451201,2.2449372348586798]
["1990-09-24",2.1885249690263997,2.22572989296585]
["1990-10-24",2.1696386938076802,2.2065225510730202]
["1990-11-24",2.1507524185889597,2.18731520918019]
["1990-12-24",2.1320736848561603,2.1683189369784901]
["1991-01-24",2.1131874096374399,2.1491115950856599]
["1991-02-24",2.0943011344187203,2.1299042531928301]
["1991-03-24",2.0754148591682999,2.1106969112774996]
["1991-04-22",2.0686363668328802,2.1038031845740002]
[{"$f":"DATE(YEAR(A200),MONTH(A200) + 1,DAY(A200))","v":"1991-05-22"},2.0618578744974601,2.0969094578704999]
["1991-06-22",2.0550793821620399,2.0900157311669996]
["1991-07-22",2.0481015224049903,2.0829192477957501]
["1991-08-22",2.0413230300695702,2.0760255210922498]
["1991-09-22",2.03454453773415,2.0691317943887499]
["1991-10-22",2.0277660453987298,2.0622380676852496]
["1991-11-22",2.0209875530633101,2.0553443409817498]
["1991-12-22",2.01420906072789,2.0484506142782499]
["1992-01-22",2.00723120097084,2.0413541309069996]
["1992-02-22",2.0004527086354202,2.0344604042035002]
["1992-03-22",1.9936742163212,2.0275666775336001]
["1992-04-28",1.9879010284360998,2.0216953454557998]
[{"$f":"DATE(YEAR(A212),MONTH(A212) + 1,DAY(A212))","v":"1992-05-28"},1.9821278405509999,2.0158240133779999]
["1992-06-28",1.9763546526658997,2.0099526813001996]
["1992-07-28",1.9705814647808,2.0040813492224001]
["1992-08-28",1.9648082768956998,1.9982100171445998]
["1992-09-28",1.9590350890105999,1.9923386850667999]
["1992-10-28",1.9532619011254997,1.9864673529889998]
["1992-11-28",1.9474887132404,1.9805960209111999]
["1992-12-28",1.9417155253552998,1.9747246888333998]
["1993-01-28",1.9359423374701998,1.9688533567555999]
["1993-02-28",1.9301691495850997,1.9629820246777998]
["1993-03-28",1.9243959616519999,1.9571106925542001]
["1993-04-27",1.9215604076809998,1.9542269341663498]
[{"$f":"DATE(YEAR(A224),MONTH(A224) + 1,DAY(A224))","v":"1993-05-27"},1.9187248537099997,1.9513431757784998]
["1993-06-27",1.915889299739,1.9484594173906502]
["1993-07-27",1.9130537457679999,1.9455756590028002]
["1993-08-27",1.9102181917969998,1.9426919006149499]
["1993-09-27",1.9073826378259997,1.9398081422270999]
["1993-10-27",1.904547083855,1.9369243838392503]
["1993-11-27",1.9017115298839999,1.9340406254514]
["1993-12-27",1.8988759759129998,1.9311568670635499]
["1994-01-27",1.8960404219419997,1.9282731086756999]
["1994-02-27",1.893227552402768,1.9254124203549527]
["1994-03-27",1.890369314015,1.9225055918908001]
["1994-04-26",1.8870398964364998,1.9191195742142799]
[{"$f":"DATE(YEAR(A236),MONTH(A236) + 1,DAY(A236))","v":"1994-05-26"},1.88352551121475,1.9155454444446198]
["1994-06-26",1.8801960936362498,1.9121594267680999]
["1994-07-26",1.8768666760577497,1.9087734090915798]
["1994-08-26",1.8733522908359999,1.9051992793219197]
["1994-09-26",1.8700228732574997,1.9018132616453998]
["1994-10-26",1.866693455679,1.8984272439688801]
["1994-11-26",1.8631790704572502,1.89485311419922]
["1994-12-26",1.85984965287875,1.8914670965227001]
["1995-01-26",1.8565202353002499,1.8880810788461799]
["1995-02-26",1.8530058500785,1.8845069490765201]
["1995-03-26",1.8496764324729997,1.8811209313896997]
["1995-04-24",1.8439796426906001,1.87532729618234]
[{"$f":"DATE(YEAR(A248),MONTH(A248) + 1,DAY(A248))","v":"1995-05-24"},1.8381048282274999,1.8693526098747499]
["1995-06-24",1.8324080384451,1.8635589746673902]
["1995-07-24",1.826533223982,1.8575842883597999]
["1995-08-24",1.8208364341995997,1.8517906531524397]
["1995-09-24",1.8149616197365002,1.8458159668448502]
["1995-10-24",1.8092648299540999,1.84002233163749]
["1995-11-24",1.8033900154909996,1.8340476453298997]
["1995-12-24",1.7976932257086,1.82825401012254]
["1996-01-24",1.7918184112454998,1.8222793238149499]
["1996-02-24",1.7861216214631002,1.8164856886075902]
["1996-03-24",1.7802468069670998,1.8105110022702997]
["1996-04-23",1.7772826350064301,1.8074964393869901]
[{"$f":"DATE(YEAR(A260),MONTH(A260) + 1,DAY(A260))","v":"1996-05-23"},1.7741440999892499,1.8043045492752501]
["1996-06-23",1.77117992802858,1.80128998639194]
["1996-07-23",1.7680413930113998,1.7980980962802]
["1996-08-23",1.7650772210507299,1.79508353339689]
["1996-09-23",1.7619386860335498,1.7918916432851499]
["1996-10-23",1.7589745140728799,1.7888770804018399]
["1996-11-23",1.7558359790556997,1.7856851902900999]
["1996-12-23",1.75287180709503,1.7826706274067901]
["1997-01-23",1.74973327207785,1.77947873729505]
["1997-02-23",1.7467691001171799,1.77646417441174]
["1997-03-23",1.743630565096,1.7732722843276001]
["1997-04-22",1.7385814418379999,1.7681373259752999]
[{"$f":"DATE(YEAR(A272),MONTH(A272) + 1,DAY(A272))","v":"1997-05-22"},1.73353231858,1.763002367623]
["1997-06-22",1.7284831953219999,1.7578674092706998]
["1997-07-22",1.723434072064,1.7527324509184001]
["1997-08-22",1.7183849488059999,1.7475974925660998]
["1997-09-22",1.713335825548,1.7424625342138]
["1997-10-22",1.7082867022899999,1.7373275758614999]
["1997-11-22",1.703237579032,1.7321926175092]
["1997-12-22",1.6981884557739999,1.7270576591568998]
["1998-01-22",1.693139332516,1.7219227008046001]
["1998-02-22",1.6880902092579999,1.7167877424522997]
["1998-03-22",1.6830410859959999,1.7116527841344]
["1998-04-28",1.6786377808291502,1.70717462278056]
[{"$f":"DATE(YEAR(A284),MONTH(A284) + 1,DAY(A284))","v":"1998-05-28"},1.67439756103885,1.7028623192546397]
["1998-06-28",1.669994255872,1.6983841579007999]
["1998-07-28",1.6655909507051501,1.6939059965469601]
["1998-08-28",1.6613507309148499,1.6895936930210398]
["1998-09-28",1.6569474257479999,1.6851155316672]
["1998-10-28",1.6525441205811502,1.6806373703133601]
["1998-11-28",1.6483039007908498,1.6763250667874399]
["1998-12-28",1.643900595624,1.6718469054335998]
["1999-01-28",1.6394972904571501,1.66736874407976]
["1999-02-28",1.6352570706668499,1.6630564405538397]
["1999-03-28",1.6308537654633,1.6585782792485999]
["1999-04-26",1.62940196685903,1.65710180006826]
[{"$f":"DATE(YEAR(A296),MONTH(A296) + 1,DAY(A296))","v":"1999-05-26"},1.6279501682547601,1.6556253208879201]
["1999-06-26",1.62649836965049,1.65414884170758]
["1999-07-26",1.6248852600901902,1.6525083092849802]
["1999-08-26",1.62343346148592,1.6510318301046398]
["1999-09-26",1.6219816628816501,1.6495553509243002]
["1999-10-26",1.62052986427738,1.6480788717439598]
["1999-11-26",1.6190780656731101,1.64660239256362]
["1999-12-26",1.6176262670688399,1.6451259133832798]
["2000-01-26",1.6160131575085401,1.64348538096068]
["2000-02-26",1.61456135890427,1.6420089017803399]
["2000-03-26",1.6131095602890999,1.6405324225599998]
["2000-04-25",1.6088933010318101,1.636244486896]
[{"$f":"DATE(YEAR(A308),MONTH(A308) + 1,DAY(A308))","v":"2000-05-25"},1.6045208840242502,1.6317977388]
["2000-06-25",1.6003046247669599,1.6275098031359998]
["2000-07-25",1.5959322077594,1.62306305504]
["2000-08-25",1.5917159485021102,1.618775119376]
["2000-09-25",1.5873435314945501,1.6143283712799998]
["2000-10-25",1.58312727223726,1.6100404356160001]
["2000-11-25",1.5787548552296999,1.6055936875199999]
["2000-12-25",1.5745385959724101,1.6013057518559999]
["2001-01-25",1.5701661789648502,1.5968590037600001]
["2001-02-25",1.5659499197075599,1.5925710680959997]
["2001-03-25",1.5615775027340999,1.5881243200424999]
["2001-04-24",1.55942783852188,1.5859381115390001]
[{"$f":"DATE(YEAR(A320),MONTH(A320) + 1,DAY(A320))","v":"2001-05-24"},1.55727817430966,1.5837519030355001]
["2001-06-24",1.5551285100974399,1.581565694532]
["2001-07-24",1.5528252984414901,1.5792233282782502]
["2001-08-24",1.55067563422927,1.5770371197747501]
["2001-09-24",1.5485259700170499,1.5748509112712499]
["2001-10-24",1.5463763058048301,1.5726647027677503]
["2001-11-24",1.54422664159261,1.57047849426425]
["2001-12-24",1.54207697738039,1.56829228576075]
["2002-01-24",1.5397737657244399,1.5659499195069999]
["2002-02-24",1.5376241015122201,1.5637637110035001]
["2002-03-24",1.5354744373070999,1.5615775025306999]
["2002-04-23",1.5333607065182799,1.5594278383187601]
[{"$f":"DATE(YEAR(A332),MONTH(A332) + 1,DAY(A332))","v":"2002-05-23"},1.53124697572946,1.55727817410682]
["2002-06-23",1.5291332449406398,1.5551285098948799]
["2002-07-23",1.52686853338119,1.5528252982392301]
["2002-08-23",1.5247548025923701,1.55067563402729]
["2002-09-23",1.5226410718035499,1.54852596981535]
["2002-10-23",1.5205273410147302,1.5463763056034101]
["2002-11-23",1.51841361022591,1.54422664139147]
["2002-12-23",1.5162998794370899,1.54207697717953]
["2003-01-23",1.5140351678776398,1.5397737655238799]
["2003-02-23",1.5119214370888201,1.5376241013119401]
["2003-03-23",1.5098077062976001,1.5354744371336]
["2003-04-23",1.5064297318574402,1.5320390371283399]
["2003-05-28",1.5029048889633603,1.5284542719054601]
["2003-06-28",1.4995269145232,1.5250188719001998]
["2003-07-28",1.4961489400830399,1.5215834718949399]
["2003-08-28",1.4926240971889602,1.5179987066720599]
["2003-09-28",1.4892461227488001,1.5145633066667998]
["2003-10-28",1.4858681483086402,1.51112790666154]
["2003-11-28",1.4823433054145603,1.50754314143866]
["2003-12-28",1.4789653309744,1.5041077414333996]
["2004-01-28",1.4755873565342399,1.5006723414281398]
["2004-02-28",1.4720625136401599,1.4970875762052598]
["2004-03-28",1.4686845391752998,1.493652176169]
["2004-04-27",1.4649807760309199,1.4898854490516]
["2004-05-27",1.4612770128865402,1.4861187219342002]
["2004-06-27",1.4577157021707903,1.4824968689367002]
["2004-07-27",1.4540119390264099,1.4787301418193]
["2004-08-27",1.45030817588203,1.4749634147019002]
["2004-09-27",1.4466044127376501,1.4711966875845002]
["2004-10-27",1.4429006495932699,1.4674299604670999]
["2004-11-27",1.43919688644889,1.4636632333497002]
["2004-12-27",1.43563557573314,1.4600413803522001]
["2005-01-27",1.4319318125887601,1.4562746532348003]
["2005-02-27",1.42822804944438,1.4525079261174001]
["2005-03-27",1.424524286289,1.4487411990336998]
["2005-04-26",1.4214727250135999,1.4456377612168798]
["2005-05-26",1.4182824564075001,1.4423932580447498]
["2005-06-26",1.4152308951321,1.4392898202279298]
["2005-07-26",1.4120406265260002,1.4360453170558001]
["2005-08-26",1.4089890652506001,1.4329418792389801]
["2005-09-26",1.4057987966445002,1.4296973760668501]
["2005-10-26",1.4027472353691002,1.4265939382500301]
["2005-11-26",1.3995569667629999,1.4233494350778999]
["2005-12-26",1.3965054054876,1.4202459972610799]
["2006-01-26",1.3933151368815,1.4170014940889499]
["2006-02-26",1.3902635756061001,1.4138980562721299]
["2006-03-26",1.387073307046,1.4106535531368001]
["2006-04-25",1.3830566855005,1.4065686490253999]
["2006-05-25",1.379040063955,1.4024837449140002]
["2006-06-25",1.3750234424094998,1.3983988408026]
["2006-07-25",1.3710068208640001,1.3943139366912001]
["2006-08-25",1.3669901993184999,1.3902290325797999]
["2006-09-25",1.3629735777730001,1.3861441284684002]
["2006-10-25",1.3589569562274999,1.382059224357]
["2006-11-25",1.3549403346819999,1.3779743202456001]
["2006-12-25",1.3509237131364999,1.3738894161341999]
["2007-01-25",1.346907091591,1.3698045120228002]
["2007-02-25",1.3428904700454998,1.3657196079114]
["2007-03-25",1.3388738484839999,1.3616347037502998]
["2007-04-23",1.3347502716648001,1.3574410261256602]
["2007-05-23",1.3304978330700001,1.3531162960752501]
["2007-06-23",1.3263742562508003,1.3489226184506102]
["2007-07-23",1.3221218176560001,1.3445978884002001]
["2007-08-23",1.3179982408368001,1.34040421077556]
["2007-09-23",1.3137458022420001,1.3360794807251501]
["2007-10-23",1.3096222254228,1.3318858031005101]
["2007-11-23",1.3053697868279999,1.3275610730501]
["2007-12-23",1.3012462100088,1.3233673954254601]
["2008-01-23",1.2969937714140001,1.31904266537505]
["2008-02-23",1.2928701945948002,1.3148489877504101]
["2008-03-23",1.2886177559850001,1.310524257735]
["2008-04-22",1.2834632849610601,1.3052821607040601]
["2008-05-22",1.2784315394376902,1.3001648755071902]
["2008-06-22",1.2732770684137502,1.2949227784762503]
["2008-07-22",1.26812259738981,1.2896806814453101]
["2008-08-22",1.2630908518664399,1.28456339624844]
["2008-09-22",1.2579363808424999,1.2793212992175]
["2008-10-22",1.25278190981856,1.2740792021865599]
["2008-11-22",1.24775016429519,1.26896191698969]
["2008-12-22",1.2425956932712499,1.26371981995875]
["2009-01-22",1.2374412222473099,1.2584777229278101]
["2009-02-22",1.23240947672394,1.25336043773094]
["2009-03-22",1.2272550057,1.2481183407000001]
["2009-04-28",1.2272550057,1.2481183407000001]
["2009-05-28",1.2272550057,1.2481183407000001]
["2009-06-28",1.2272550057,1.2481183407000001]
["2009-07-28",1.2272550057,1.2481183407000001]
["2009-08-28",1.2272550057,1.2481183407000001]
["2009-09-28",1.2272550057,1.2481183407000001]
["2009-10-28",1.2272550057,1.2481183407000001]
["2009-11-28",1.2272550057,1.2481183407000001]
["2009-12-28",1.2272550057,1.2481183407000001]
["2010-01-28",1.2272550057,1.2481183407000001]
["2010-02-28",1.2272550057,1.2481183407000001]
["2010-03-28",1.2272550056517,1.2481183407251999]
["2010-04-27",1.2241600851718799,1.24497080659728]
["2010-05-27",1.2210651646920601,1.2418232724693599]
["2010-06-27",1.2180892796153102,1.2387967973463601]
["2010-07-27",1.2149943591354899,1.2356492632184399]
["2010-08-27",1.2118994386556701,1.2325017290905198]
["2010-09-27",1.20880451817585,1.2293541949625999]
["2010-10-27",1.2057095976960299,1.2262066608346798]
["2010-11-27",1.2026146772162101,1.2230591267067599]
["2010-12-27",1.19963879213946,1.2200326515837598]
["2011-01-27",1.1965438716596402,1.2168851174558399]
["2011-02-27",1.1934489511798199,1.2137375833279198]
["2011-03-27",1.1903540306916001,1.2105900491596002]
["2011-04-25",1.1854885151669101,1.2056418198712102]
["2011-05-25",1.18050984811839,1.2005785154830899]
["2011-06-25",1.1756443325936998,1.1956302861946999]
["2011-07-25",1.1707788170690099,1.1906820569063101]
["2011-08-25",1.16580015002049,1.18561875251819]
["2011-09-25",1.1609346344958,1.1806705232298]
["2011-10-25",1.1560691189711101,1.17572229394141]
["2011-11-25",1.1510904519225902,1.1706589895532902]
["2011-12-25",1.1462249363978998,1.1657107602648999]
["2012-01-25",1.1413594208732099,1.1607625309765099]
["2012-02-25",1.1363807538246899,1.1556992265883901]
["2012-03-25",1.1315152382828,1.1507509972868]
["2012-04-24",1.1295223543014798,1.1487242342778798]
["2012-05-24",1.12741875454342,1.1465848733240198]
["2012-06-24",1.1254258705620999,1.1445581103150999]
["2012-07-24",1.1234329865807799,1.1425313473061798]
["2012-08-24",1.1213293868227199,1.1403919863523198]
["2012-09-24",1.1193365028413997,1.1383652233433998]
["2012-10-24",1.11734361886008,1.1363384603344802]
["2012-11-24",1.11524001910202,1.1341990993806201]
["2012-12-24",1.1132471351207001,1.1321723363717]
["2013-01-24",1.1112542511393799,1.1301455733627799]
["2013-02-24",1.1091506513813201,1.1280062124089201]
["2013-03-24",1.1071577673727999,1.1259794494090998]
["2013-04-23",1.10478605647872,1.12356741942984]
["2013-05-23",1.102306540544,1.12104575172425]
["2013-06-23",1.0999348296499201,1.11863372174499]
["2013-07-23",1.0974553137152001,1.1161120540394001]
["2013-08-23",1.0950836028211202,1.11370002406014]
["2013-09-23",1.0926040868864002,1.1111783563545501]
["2013-10-23",1.09023237599232,1.10876632637529]
["2013-11-23",1.0877528600575999,1.1062446586696999]
["2013-12-23",1.0853811491635199,1.1038326286904399]
["2014-01-23",1.0829016332288,1.1013109609848499]
["2014-02-23",1.08052992233472,1.0988989310055899]
["2014-03-23",1.0780504064,1.0963772633088]
["2014-04-22",1.0769851392000001,1.0952938865663999]
["2014-05-22",1.0759198720000001,1.094210509824]
["2014-06-22",1.0748546048000001,1.0931271330815999]
["2014-07-22",1.0737893376000001,1.0920437563392]
["2014-08-22",1.0727240704000001,1.0909603795967999]
["2014-09-22",1.0716588032000001,1.0898770028544]
["2014-10-22",1.0705935360000001,1.0887936261119999]
["2014-11-22",1.0695282688000001,1.0877102493696]
["2014-12-22",1.0684630016000001,1.0866268726271999]
["2015-01-22",1.0673977344000001,1.0855434958848]
["2015-02-22",1.0663324671999999,1.0844601191423999]
["2015-03-22",1.0652672000000001,1.0833767424]
["2015-04-27",1.0652672000000001,1.0833767424]
["2015-05-27",1.0652672000000001,1.0833767424]
["2015-06-27",1.0652672000000001,1.0833767424]
["2015-07-27",1.0652672000000001,1.0833767424]
["2015-08-27",1.0652672000000001,1.0833767424]
["2015-09-27",1.0652672000000001,1.0833767424]
["2015-10-27",1.0652672000000001,1.0833767424]
["2015-11-27",1.0652672000000001,1.0833767424]
["2015-12-27",1.0652672000000001,1.0833767424]
["2016-01-27",1.0652672000000001,1.0833767424]
["2016-02-27",1.0652672000000001,1.0833767424]
["2016-03-27",1.0652672000000001,1.0833767424]
["2016-04-26",1.0644234240000001,1.0825186222080001]
["2016-05-26",1.0634741760000002,1.081553236992]
["2016-06-26",1.0626304000000002,1.0806951168000001]
["2016-07-26",1.061786624,1.0798369966079999]
["2016-08-26",1.0608373760000001,1.0788716113920001]
["2016-09-26",1.0599936000000001,1.0780134911999999]
["2016-10-26",1.0591498240000001,1.077155371008]
["2016-11-26",1.0582005760000002,1.0761899857920001]
["2016-12-26",1.0573568,1.0753318655999999]
["2017-01-26",1.0565130240000002,1.074473745408]
["2017-02-26",1.0555637760000001,1.0735083601919999]
["2017-03-26",1.0547200000000001,1.07265024]
["2017-04-25",1.0521600000000002,1.0700467199999999]
["2017-05-25",1.0495999999999999,1.0674431999999998]
["2017-06-25",1.04704,1.06483968]
["2017-07-25",1.0444800000000001,1.0622361599999999]
["2017-08-25",1.0419200000000002,1.05963264]
["2017-09-25",1.0393599999999998,1.0570291199999997]
["2017-10-25",1.0367999999999999,1.0544255999999999]
["2017-11-25",1.03424,1.05182208]
["2017-12-25",1.0316800000000002,1.0492185599999999]
["2018-01-25",1.0291199999999998,1.0466150399999998]
["2018-02-25",1.0265599999999999,1.0440115199999997]
["2018-03-25",1.024,1.0414079999999999]
["2018-04-24",1.022,1.039374]
["2018-05-24",1.02,1.0373399999999999]
["2018-06-24",1.018,1.0353059999999998]
["2018-07-24",1.016,1.033272]
["2018-08-24",1.014,1.0312379999999999]
["2018-09-24",1.012,1.029204]
["2018-10-24",1.01,1.0271699999999999]
["2018-11-24",1.008,1.0251359999999998]
["2018-12-24",1.006,1.023102]
["2019-01-24",1.004,1.0210679999999999]
["2019-02-24",1.002,1.019034]
["2019-03-24",1,1.0169999999999999]
["2019-04-22",1,1.0156000000000001]
["2019-05-22",1,1.0142]
["2019-06-22",1,1.0127999999999999]
["2019-07-22",1,1.0113000000000001]
["2019-08-22",1,1.0099]
["2019-09-22",1,1.0085]
["2019-10-22",1,1.0071000000000001]
["2019-11-22",1,1.0057]
["2019-12-22",1,1.0043]
["2020-01-22",1,1.0027999999999999]
["2020-02-22",1,1.0014000000000001]
["2020-03-22",1,1]

{"sheet":"Contents","index":3,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,35,17],[3,1,5,3],[3,4,5,17],[6,1,25,17],[28,1,29,17],[30,1,33,17]]}
[]
[]
[]
[null,null,null,null,"NHS Superannuation Scheme (Scotland) Preserved Benefits Estimate Calculator"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]
[]
[null,"This calculator is intended for illustrative purposes only. This is not a statement of your legal entitlement.  While every care has been taken in the preparation of this ready reckoner the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides."]
[]
[]
[]
[null,"Please refer to the SPPA website for contact information or any other details of benefits available through the NHS Superannuation Scheme (Scotland)."]

{"sheet":"Guidance Notes","index":4,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":true,"merged":[[0,1,2,14],[42,1,45,14],[46,1,46,14],[47,1,49,14],[40,1,41,14],[4,1,37,14]]}
[null,"Guidance Notes"]
[]
[]
[]
[null,"Understanding your results\n\nThis calculator is solely for guidance purposes and is an estimate only.  It is not a statement of your legal entitlement and is not intended to provide you with financial advice.  While every care has been taken in the preparation of this calculator the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides.  If you require financial advice, you should contact an authorised independent financial adviser.  \n\nAs you are no longer in pensionable employment, your basic retirement benefits should remain unchanged.  These will be index linked in line with inflation.  Please note, this calculator is only for 1995 or 2008 members.  \n\nYou should have received a preserved letter detailing the breakdown of your deferred retirement benefits.  You will need this information to allow you to project a current estimate of your benefits.  Please note that if your pension breakdown may not provide you with your deemed date which is used to calculate how much pension increase you may be entitled to.  If this is the case the calculator will assume this date is the day after your last day worked (final year).  If your pensionable salary used is your second or third last year this may underinflate the pension increase you are entitled to.  Alternatively you can contact the Agency and request your deemed date.\n\nIf your date of leaving is after 30 March 2000, you may claim your benefits prior to your Normal Pension Age (NPA) if you wish but this will be subject to a reduction as it will be paid early.  If you are aged 55 or over the calculator will allow you to estimate your retirement benefits to include the VERA reduction.  If you simply wish to have a current estimate of your deferred benefits please state \"No\" when prompted.\n\nTo calculate your estimated benefits, you need to complete the necessary information under \"Member Details\".  Once  you have completed all the relevant information your estimated benefits will be shown on the \"Benefit Certificate\" and \"Letter\".  If you do not complete all of the necessary information your estimate will not work.  \n\nEach page allows you to go back to previous stages if you wish by simply clicking on the relevant box to where you wish to go.\n\nPractitioners\n\nIf you are a Practitioner, please use the \"Practitioners Member Details\" as your preserved benefits are calculated differently.    Once  you have completed all the relevant information your estimated benefits will be shown on the \"Practitioners Benefit Certificate\" and \"Practitioners Letter\".  If you do not complete all of the necessary information your estimate will not work.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]
[]
[null,"This calculator is intended for illustrative purposes only. This is not a statement of your legal entitlement.  While every care has been taken in the preparation of this ready reckoner the Scottish Public Pensions Agency will accept no responsibility for the accuracy of the information it provides."]
[]
[]
[]
[]
[null,"Please refer to the SPPA website for contact information or any other details of benefits available through the NHS Superannuation Scheme (Scotland)."]

{"sheet":"Member Details","index":5,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,5,3,18],[11,8,11,9],[11,10,11,13],[19,10,19,11],[19,12,19,13],[5,9,5,14],[13,8,13,9],[13,10,13,13],[7,12,7,13],[9,10,9,13],[15,10,15,13],[7,8,7,9],[9,7,9,9],[15,7,15,9],[37,8,37,9],[37,10,37,13],[17,8,17,9],[17,10,17,13],[20,7,20,9],[34,8,34,9],[35,8,35,9],[31,10,31,13],[32,10,32,13],[33,10,33,13],[34,10,34,13],[35,10,35,13],[31,8,31,9],[32,8,32,9],[33,8,33,9],[29,8,29,15],[1,2,3,4],[8,2,8,4],[9,2,9,4],[14,2,14,4],[15,2,15,4],[24,16,24,17],[24,14,24,15],[17,2,17,4],[22,10,22,13],[20,10,20,11],[24,10,24,13],[20,12,20,13],[22,6,22,9]]}
[]
[null,null,null,null,null,"NHS Superannuation Scheme (Scotland) Preserved Benefits Estimate Calculator"]
[]
[]
[]
[null,null,null,null,"Member Details",null,null,null,null,"PLEASE COMPLETE ALL NECESSARY DATA"]
[]
[null,null,null,null,null,null,null,null,"Members Name  ",null,null,null,null,null,null,"Eg: Mr | J | Smith"]
[]
[null,null,null,null,null,null,null,"Superannuation Number  "]
[]
[null,null,null,null,null,null,null,null,"Date of Birth  ",null,null,null,null,null,null,null,null,null,null,{"$f":"DATEDIF(K12,NOW(),\"Y\")","v":120},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,"Scheme  ",null,null,null,null,null,null,null,null,null,1995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008]
[null,null," ",null,null,null,null,"Last Day Worked in NHS ",null,null,null,null,null,null,null,null,{"$f":"IF(R16>=S16,\"VERA\",\"AGE\")","v":"AGE"},{"$f":"K16","v":0},36616]
[]
[null,null," ",null,null,null,null,null,"Pensionable Salary  "]
[]
[null,null,null,null,null,null,null,null,null,null,"Years",null,"Days"]
[null,null,null,null,null,null,null,"Total Reckonable Service  "]
[]
[null,null,null,null,null,null,"Deemed Date for Pension Increase  ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K23=\"\",K16+1,\"\")","v":"1900-01-01"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(T12>=55,\"Are you looking for a Retirement Estimate?  \",\"\")","v":"Are you looking for a Retirement Estimate?  "},null,null,null,null,{"$f":"IF(K25=\"Yes\",\"Retirement Date  \",\"\")","v":""},null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Additional Information if Letter and Certificate Required"]
[]
[null,null,null,null,null,null,null,null,"Address Line 1  "]
[null,null,null,null,null,null,null,null,"Address Line 2  "]
[null,null,null,null,null,null,null,null,"Address Line 3  "]
[null,null,null,null,null,null,null,null,"Address Line 4  "]
[null,null,null,null,null,null,null,null,"Post Code  "]
[]
[null,null,null,null,null,null,null,null,"NI Number  "]

{"sheet":"Age","index":6,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Period Calculator V 1.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,365,31,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,334,59,28]
[null,null,null,"dd","mm","yyyy",null,null,null,null,null,null,null,null,null,null,3,306,90,31]
[null,null,"Date From :",{"$f":"DAY(M15)","v":0},{"$f":"MONTH(M15)","v":1},{"$f":"YEAR(M15)","v":1900},{"$f":"IF(AA9>0,AA9,0)","v":43967},"Days",null,null,null,null,null,null,null,null,4,275,120,30,{"$f":"D7","v":0},{"$f":"IF(E7>0,VLOOKUP($E$7,Table50,2),0)","v":365},{"$f":"F7","v":1900},{"$f":"IF(E7>0,VLOOKUP($E$7,Table50,4),0)","v":31},{"$f":"(V7+1)-U7","v":366},{"$f":"(W7*365)-Y7","v":693134},{"$f":"Y7+Z7","v":693500}]
[null,null,"Date To :",{"$f":"DAY(M16)","v":15},{"$f":"MONTH(M16)","v":6},{"$f":"YEAR(M16)","v":2020},{"$f":"IF(G7>0,G7/365,0)","v":120.45753424657535},"Years",{"$f":"((F8-F7)*12)+(E8-E7)","v":1445},"Months",null,null,null,null,null,null,5,245,151,31,{"$f":"D8","v":15},{"$f":"IF(E8>0,VLOOKUP($E$8,Table50,3),0)","v":181},{"$f":"F8","v":2020},{"$f":"IF(E8>0,VLOOKUP($E$8,Table50,4),0)","v":30},{"$f":"(V8-X8)+U8","v":166},{"$f":"((W8*365)-365)+Y8","v":737101},{"$f":"Z8+Y7","v":737467}]
[null,null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,6,214,181,30,null,null,null,null,null,null,{"$f":"AA8-AA7","v":43967}]
[null,null,"Duration :",{"$f":"TRUNC(G8)","v":120},"Years",{"$f":"(G8-D10)*365","v":167.0000000000025},"Days",null,null,null,null,null,null,null,null,null,7,184,212,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,153,243,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,122,273,30]
[null,null,"Approximation :",{"$f":"D10","v":120},"Years",{"$f":"DATEDIF(M15,M16,\"YM\")","v":5},"Months",null,null,null,null,null,null,null,null,null,10,92,304,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,61,334,30]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Member Details'!K12=\"\",'Practitioners Member Details'!K12<>\"\"),'Practitioners Member Details'!K12,'Member Details'!K12)","v":"00:00:00"},null,null,null,12,31,365,31]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Member Details'!Q25<>\"\",'Member Details'!Q25,IF('Practitioners Member Details'!Q22<>\"\",'Practitioners Member Details'!Q22,NOW()))","v":"2020-06-15T11:11:08.860"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Year",{"$f":"DATEDIF(M15,M16,\"Y\")","v":120}]
[null,null,null,null,null,null,null,null,null,null,null,"Months",{"$f":"DATEDIF(M15,M16,\"YM\")","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,"Days",{"$f":"DATEDIF(M15,M16,\"MD\")","v":15}]

{"sheet":"PI Finder","index":7,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,"yyyy","PI Date"]
[null,null,"Select PI table:",null,null,{"$f":"IF(AND('Member Details'!K25=\"Yes\",'Member Details'!Q25<G3),2019,2020)","v":2020},43927]
[]
[null,null,null,null,null,"dd/mm/yyyy"]
[null,null,"Enter date for PI:",null,null,{"$f":"IF('Member Details'!K23=\"\",'Member Details'!S23,'Member Details'!K23)","v":"1900-01-01"}]
[]
[]
[null,null,"PI for this date is:",null,null,{"$f":"IF(F6=0/1/1900,1,VLOOKUP(F6,'PI Data'!$A$3:$AZ$998,F3 - 'PI Data'!$A$1 + 2))","v":{"$error":"#N/A"}}]

{"sheet":"Benefit Certificate","index":8,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":true,"merged":[[10,0,10,1],[10,2,10,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,2,4,3],[5,2,5,3],[6,0,6,4],[7,0,7,2],[7,3,7,4],[9,0,9,2],[9,3,9,4],[11,0,11,1],[11,2,11,3],[12,0,12,1],[13,0,13,1],[13,3,13,4],[15,0,15,1],[15,3,15,4],[26,0,26,1],[26,3,26,4],[17,0,17,4],[18,0,18,2],[18,3,18,4],[20,0,20,2],[20,3,20,4],[21,0,21,1],[22,0,22,1],[22,2,22,3],[24,0,24,2],[24,3,24,4],[23,0,23,4],[25,0,25,4],[28,0,28,4],[29,0,29,2],[29,3,29,4],[30,0,30,2],[30,3,30,4],[34,0,34,2],[34,3,34,4],[31,0,31,2],[31,3,31,4],[32,0,32,2],[32,3,32,4],[33,0,33,2],[33,3,33,4]]}
[{"$f":"IF('Member Details'!K14=1995,\"NHS 1995 Section\",\"NHS 2008 Section\")","v":"NHS 2008 Section"}]
["Estimated Retirement Benefits from Deferred Status"]
[{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\"),\"with Actuarial Reduced Pension\",\"\")","v":""}]
[{"$f":"IF('Member Details'!Q25<>\"\",'Member Details'!Q25,NOW())","v":"2020-06-15T11:11:08.860"}]
["Name:",{"$f":"'Member Details'!K8&\" \"&'Member Details'!L8&\" \"&'Member Details'!M8","v":"  "},"Last day of Service:",null,{"$f":"'Member Details'!K16","v":"00:00:00"}]
["NI Number:",{"$f":"'Member Details'!K38","v":0},"Reference:",null,{"$f":"'Member Details'!K10","v":0}]
["Annual Pension"]
["Pensionable Service"]
[]
[{"$f":"IF('Member Details'!K14=1995,'Member Details'!K21&\" Years \"& 'Member Details'!M21&\" Days x 1/80th of £\"&'Member Details'!K18,'Member Details'!K21&\" Years \"& 'Member Details'!M21&\" Days x 1/60th of £\"&'Member Details'!K18)","v":" Years  Days x 1/60th of £"},null,null,{"$f":"IF('Member Details'!K14=1995,(('Member Details'!M21/365)+'Member Details'!K21)*'Member Details'!K18/80,(('Member Details'!M21/365)+'Member Details'!K21)*'Member Details'!K18/60)","v":0}]
[null,null,null,null,null,null,null,null,"VERA 1995",null,"VERA 2008"]
[{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\"),\"Less early retirement reduction (\"&G12&\"%)\",\" \")","v":" "},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),\"£\" & ROUND(D10,2) & \" x \" & I12,IF(AND('Member Details'!Q16=\"VERA\",Age!M18<65,'Member Details'!K25=\"Yes\",'Member Details'!K14=2008),\"£\" & ROUND(D10,2) & \" x \" & K12,\" \"))","v":" "},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),D10*I12,IF(AND('Member Details'!Q16=\"VERA\",Age!M18<65,'Member Details'!K25=\"Yes\",'Member Details'!K14=2008),D10*K12,0))","v":0},{"$f":"IF(AND('Member Details'!K14=1995,I12<>\"\"),((1-I12)*100),IF(AND('Member Details'!K14=2008,K12<>\"\"),((1-K12)*100),\"\"))","v":""},{"$f":"IF(F12<>\"\",ROUND(F12,2),\"\")","v":""},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),IF('Member Details'!Q25>=43402,VLOOKUP(Age!M18,'VERA Pension Factors'!A7:M18,MATCH(Age!M19,'VERA Pension Factors'!A7:M7,0),FALSE),VLOOKUP(Age!M18,'VERA Pension Factors'!P7:AB18,MATCH(Age!M19,'VERA Pension Factors'!P7:AB7,0),FALSE)),\"\")","v":""},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<65,'Member Details'!K25=\"Yes\",'Member Details'!K14=2008),IF('Member Details'!Q25>=43402,VLOOKUP(Age!M18,'VERA Pension Factors'!A44:M53,MATCH(Age!M19,'VERA Pension Factors'!A36:M36,0),FALSE),VLOOKUP(Age!M18,'VERA Pension Factors'!P44:AB53,MATCH(Age!M19,'VERA Pension Factors'!P36:AB36,0),FALSE)),\"\")","v":""}]
[]
[{"$f":"IF('PI Finder'!F9>1,\"Plus Pension Increase\" &\" (\"&F14&\")\",\" \")","v":{"$error":"#N/A"}},null,null,{"$f":"IF('PI Finder'!F9>1,IF(E12<>0,(E12*F14)-E12,(D10*F14)-D10),0)","v":{"$error":"#N/A"}},null,{"$f":"IF('PI Finder'!F9>1,ROUND('PI Finder'!F9,4),0)","v":{"$error":"#N/A"}}]
[]
["Estimated Annual Pension",null,null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\"),SUM(E12+D14),SUM(D10+D14))","v":{"$error":"#N/A"}}]
[]
["Lump Sum"]
[{"$f":"IF('Member Details'!K14=1995,\"Pensionable Service\",\"\")","v":""}]
[]
[{"$f":"IF('Member Details'!K14=1995,'Member Details'!K21&\" Years \"& 'Member Details'!M21&\" Days x 3/80th of £\"&'Member Details'!K18,\"\")","v":""},null,null,{"$f":"IF('Member Details'!K14=1995,(('Member Details'!M21/365)+'Member Details'!K21)*'Member Details'!K18*3/80,0)","v":0}]
[{"$f":"IF('Member Details'!K14=2008,\"No Automatic Lump Sum given.\",\"\")","v":""},null,null,null,null,null,null,null,"VERA LS"]
[{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),\"Less early retirement reduction (\"&G23&\"%)\",\" \")","v":" "},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),\"£\" & ROUND(D21,2) & \" x \" & I23,\" \")","v":" "},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),ROUND('Benefit Certificate'!D21,2)*'Benefit Certificate'!I23,0)","v":0},{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K14=1995),(1-'Benefit Certificate'!I23)*100,\"\")","v":""},{"$f":"IF(F23<>\"\",ROUND(F23,2),\"\")","v":""},null,{"$f":"IF(AND('Member Details'!Q16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\",'Member Details'!K14=1995),IF('Member Details'!Q25>=43402,VLOOKUP(Age!M18,'VERA LS Factors'!A7:M19,MATCH(Age!M19,'VERA LS Factors'!A7:M7,0),FALSE),VLOOKUP(Age!M18,'VERA LS Factors'!P7:AB19,MATCH(Age!M19,'VERA LS Factors'!P7:AB7,0),FALSE)),\"\")","v":""}]
[{"$f":"IF('Member Details'!K14=2008,\"You may wish to give up part of your pension to receive a tax free Lump Sum.\",\"\")","v":""}]
[{"$f":"IF(AND('PI Finder'!F9>1,'Member Details'!K14=1995),\"Plus Pension Increase\" &\" (\"&F25&\")\",\" \")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(AND('PI Finder'!F9>1,'Member Details'!K14=1995),IF(E23<>0,(E23*F25)-E23,(D21*F25)-D21),0)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND('PI Finder'!F9>1,'Member Details'!K14=1995),ROUND('PI Finder'!F9,4),0)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Member Details'!K14=2008,\"The maximum allowed by HM Revenue & Customs is 25% of your Fund Value.\",\"\")","v":""}]
[{"$f":"IF('Member Details'!K14=1995,\"Estimated Lump Sum\",\"\")","v":""},null,null,{"$f":"IF(AND('Member Details'!O16=\"VERA\",Age!M18<60,'Member Details'!K25=\"Yes\"),SUM(E23+D25),SUM(D21+D25))","v":{"$error":"#N/A"}}]
[]
["HMRC Lifetime Allowance (LTA)"]
[]
["Lifetime Allowance",null,null,{"$f":"IF('PI Finder'!F3=2018,1030000,1055000)","v":1055000}]
["Value of Crystallised Benefits",null,null,{"$f":"(D16*20)+D27","v":{"$error":"#N/A"}}]
["Percentage of LTA Used (%)",null,null,{"$f":"(D32/D31)*100","v":{"$error":"#N/A"}}]
["Value of LTA Unused",null,null,{"$f":"IF(D31-D32<0,0,D31-D32)","v":{"$error":"#N/A"}}]
["Percentage of LTA Unused (%)",null,null,{"$f":"IF(100-D33<0,0,100-D33)","v":{"$error":"#N/A"}}]

{"sheet":"Letter","index":9,"n_rows":103,"n_cols":8,"rows_kept":103,"cut":false,"hidden":true,"merged":[[11,0,11,2],[30,2,30,3],[11,6,11,7],[30,6,30,7],[26,2,26,3],[27,2,27,3],[25,4,25,5],[26,4,26,5],[16,6,16,7],[22,0,23,7],[30,0,30,1],[12,0,12,2],[30,4,30,5],[18,0,18,3],[25,6,25,7],[26,6,26,7],[74,0,81,8],[102,0,109,8],[61,0,72,8],[82,0,101,8],[31,14,31,15],[32,0,32,7],[50,0,50,3],[33,0,33,1],[33,2,33,3],[33,4,33,5],[33,6,33,7],[38,0,42,7],[35,0,37,7],[43,0,44,7],[31,12,31,13],[27,6,27,7],[27,4,27,5],[12,6,12,7],[29,0,29,7],[20,0,20,7],[25,0,25,1],[26,0,26,1],[27,0,27,1],[25,2,25,3],[4,6,4,7],[5,6,5,7],[6,6,6,7],[10,0,10,2],[9,0,9,2],[8,0,8,2],[10,6,10,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"7 Tweedside Park"]
[null,null,null,null,null,null,"Tweedbank"]
[null,null,null,null,null,null,"Galashiels"]
[null,null,null,null,null,null,null,"TD1 3TE"]
[{"$f":"'Member Details'!K8&\" \"&'Member Details'!L8&\" \"&'Member Details'!M8","v":"  "},null,null,null,null,null,null,"www.pensions.gov.scot"]
[{"$f":"'Member Details'!K32","v":0}]
[{"$f":"'Member Details'!K33","v":0},null,null,null,null,null,"Tel:   01896 893000"]
[{"$f":"'Member Details'!K34","v":0},null,null,null,null,null,"Fax:  01896 893214"]
[{"$f":"'Member Details'!K35","v":0},null,null,null,null,null,"nhsawards@gov.scot"]
[{"$f":"'Member Details'!K36","v":0}]
[null,null,null,null,null,null,"Our ref: ",{"$f":"'Member Details'!K10","v":0}]
[null,null,null,null,null,null,"Letter Ref: ","Pres v1.0"]
[null,null,null,null,null,null,{"$f":"NOW()","v":"2020-06-15T11:11:08.870"}]
[]
[{"$f":"\"Dear \"&'Member Details'!K8&\" \"&'Member Details'!M8","v":"Dear  "}]
[]
["National Health Service Superannuation Scheme (Scotland)"]
[]
["In accordance with your request please find enclosed an estimate of your retirement benefits.  You should read the notes for further explanatory information."]
[]
[]
["Name",null,{"$f":"'Member Details'!L8&\" \"&'Member Details'!M8","v":" "},null,"National Insurance No",null,{"$f":"'Member Details'!K38","v":0}]
["Date of Birth  ",null,{"$f":"'Member Details'!K12","v":"00:00:00"},null,"Superannuation No",null,{"$f":"'Member Details'!K10","v":0}]
["Normal Retirement Date",null,{"$f":"IF('Member Details'!K14=1995,DATE(YEAR('Member Details'!K12)+60,MONTH('Member Details'!K12),DAY('Member Details'!K12)),DATE(YEAR('Member Details'!K12)+65,MONTH('Member Details'!K12),DAY('Member Details'!K12)))","v":"1964-12-31"},null,"Normal Pension Age",null,{"$f":"IF('Member Details'!K14=1995,60,65)","v":65}]
[]
[{"$f":"\"Service/Salary Details at Last Date of Pensionable Service (\"&TEXT('Member Details'!K16,\"dd/mm/yyyy\")&\")\"","v":"Service/Salary Details at Last Date of Pensionable Service (00/01/1900)"}]
["Pensionable Service",null,{"$f":"'Member Details'!K21&\" Years \"&'Member Details'!M21&\" Days\"","v":" Years  Days"},null,"Pensionable Salary",null,{"$f":"'Member Details'!K18","v":0}]
[]
[{"$f":"IF('Member Details'!Q25<>\"\",\"Estimated Current Retirement Benefits (\"&TEXT('Member Details'!Q25,\"dd/mm/yyyy\")&\")\",\"Estimated Current Retirement Benefits (\"&TEXT(Letter!G17,\"dd/mm/yyyy\")&\")\")","v":"Estimated Current Retirement Benefits (15/06/2020)"}]
["Pension",null,{"$f":"'Benefit Certificate'!D16","v":{"$error":"#N/A"}},null,"Lump Sum",null,{"$f":"IF('Member Details'!K14=1995,ROUND('Benefit Certificate'!D27,2),\"No Automatic Lump Sum\")","v":"No Automatic Lump Sum"}]
[]
["As you are no longer in pensionable employment, your basic retirement benefits should remain unchanged.  These will be index linked in line with inflation until retirement.  "]
[]
[]
["This is not a statement of your legal entitlement and is intended for illustrative purposes only.  Exact figures for retirement benefits cannot be given until an application for retirement benefits has been made in accordance with the scheme rules.  Scottish Public Pensions Agency will accept no responsibility for the accuracy of this information."]
[]
[]
[]
[]
["If you require any further information please do not hesitate to contact the Agency at the above address."]
[]
[]
["Yours sincerely"]
[]
[]
[]
["SPPA Customer Services"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pensionable Salary\n\nFor members of the 1995 section of the NHS Superannuation Scheme (Scotland) the pensionable salary used to calculate scheme benefits on retirement is the best of the last 3 years, this means the pensionable salary taken back 365 days from the date of retirement as supplied by your employer.\n\nFor members of the 2008 section of the NHS Superannuation Scheme (Scotland) the salary used in calculating your retirement benefits is calculated as the average of the best consecutive 3 years’ revalued salaries in the last 10 years.\n\nFor the purposes of this illustration your salary information has been based on your preserved pensionable salary.  If you were part-time, this will be based on the full time equivalent salary rate.  We would emphasise that while every effort has been made to ensure the accuracy of your pensionable salary it is not until you retire that an accurate calculation can be made.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pensionable Service\n\nThis is the period of employment that is taken into account when working out pension benefits. The figure quoted is your pensionable service to your last day worked. It will include any service you have already transferred into the scheme from another pension scheme.  Please note that part-time service is converted to the equivalent full time service.  For example, if you worked 18.75 hours per week instead of 37.5 for a full time employment then you would accrue 183 days service instead of 365 for each year.  No projected service has been added as you have left pensionable employment.\n"]
[]
[]
[]
[]
[]
[]
[]
["Estimated Current Benefits\n\n1995 Member\n\nIf you are a 1995 section member, your annual pension has been calculated using the following formula:\n\nPension:       Pensionable Service x Pensionable Salary x 1/80th\nLump Sum:   Pensionable Service x Pensionable Salary x 3/80th\n\nIf you worked after 30 March 2000, you may take you benefits prior to Normal Pension Age (NPA) of 60.  Any benefits payable prior to NPA will normally be subject to an actuarial reduction to allow for the benefits being paid earlier.\n\n2008 Member\n\nIf you are a 2008 section member, your annual pension has been calculated using the following formula:\n\nPension:       Pensionable Service x Pensionable Salary x 1/60th\nLump Sum:   No Automatic Lump Sum\n\nAny benefits payable prior to NPA of 65 will normally be subject to an actuarial reduction to allow for the benefits being paid earlier.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Increasing your Tax Free Lump Sum\n\nThere is the provision to give up an amount of pension in exchange for an additional lump sum up to the maximum allowed by HM Revenue & Customs of 25% of the fund value.  There is a Commutation Calculator on our website that can be used to project estimated values.  The factor for converting your pension into lump sum is 12:1 which means that for every £1 of pension you give up, you will get £12 added to your lump sum."]

{"sheet":"Practitioners Member Details","index":10,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":true,"merged":[[32,8,32,9],[32,10,32,13],[34,8,34,9],[34,10,34,13],[19,10,19,13],[19,7,19,9],[29,8,29,9],[29,10,29,13],[30,8,30,9],[30,10,30,13],[31,8,31,9],[31,10,31,13],[21,10,21,13],[21,14,21,15],[21,16,21,17],[26,8,26,15],[28,8,28,9],[28,10,28,13],[14,2,14,4],[15,2,15,4],[15,10,15,13],[17,2,17,4],[17,10,17,13],[17,7,17,9],[15,7,15,9],[13,8,13,9],[13,10,13,13],[1,2,3,4],[1,5,3,18],[5,9,5,14],[7,8,7,9],[7,12,7,13],[8,2,8,4],[9,2,9,4],[9,10,9,13],[11,8,11,9],[11,10,11,13],[9,7,9,9]]}
[]
[null,null,null,null,null,"NHS Superannuation Scheme (Scotland) Preserved Benefits Estimate Calculator"]
[]
[]
[]
[null,null,null,null,"Practitioner Member Details",null,null,null,null,"PLEASE COMPLETE ALL NECESSARY DATA"]
[]
[null,null,null,null,null,null,null,null,"Members Name  ",null,null,null,null,null,null,"Eg: Mr | J | Smith"]
[]
[null,null,null,null,null,null,null,"Superannuation Number  "]
[]
[null,null,null,null,null,null,null,null,"Date of Birth  ",null,null,null,null,null,null,null,null,null,null,{"$f":"DATEDIF(K12,NOW(),\"Y\")","v":120},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,"Scheme  ",null,null,null,null,null,null,null,null,null,1995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008]
[null,null," ",null,null,null,null,"Last Day Worked in NHS  ",null,null,null,null,null,null,null,{"$f":"K16+1","v":"1900-01-01"},{"$f":"IF(R16>=S16,\"VERA\",\"AGE\")","v":"AGE"},{"$f":"K16","v":0},36616]
[]
[null,null," ",null,null,null,null,"Deferred Basic Pension  "]
[]
[null,null,null,null,null,null,null,{"$f":"IF(K14=2008,\"\",\"Deferred Basic Lump Sum  \")","v":"Deferred Basic Lump Sum  "}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(T12>=55,\"Are you looking for a Retirement Estimate?  \",\"\")","v":"Are you looking for a Retirement Estimate?  "},null,null,null,null,{"$f":"IF(K22=\"Yes\",\"Retirement Date  \",\"\")","v":""},null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Additional Information if Letter and Certificate Required"]
[]
[null,null,null,null,null,null,null,null,"Address Line 1  "]
[null,null,null,null,null,null,null,null,"Address Line 2  "]
[null,null,null,null,null,null,null,null,"Address Line 3  "]
[null,null,null,null,null,null,null,null,"Address Line 4  "]
[null,null,null,null,null,null,null,null,"Post Code  "]
[]
[null,null,null,null,null,null,null,null,"NI Number  "]

{"sheet":"Practitioners Letter","index":11,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":true,"merged":[[9,0,9,2],[20,0,20,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[8,0,8,2],[10,0,10,2],[10,6,10,7],[11,0,11,2],[11,6,11,7],[12,0,12,2],[12,6,12,7],[16,6,16,7],[18,0,18,3],[13,0,13,2],[14,0,14,2],[22,0,23,7],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[27,0,27,1],[27,2,27,3],[27,4,27,5],[27,6,27,7],[28,14,28,15],[29,0,29,7],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[28,12,28,13],[86,0,108,8],[110,0,113,8],[65,0,85,8],[32,0,34,7],[35,0,39,7],[40,0,41,7],[49,0,49,3]]}
[]
[]
[]
[]
[null,null,null,null,null,null,"7 Tweedside Park"]
[null,null,null,null,null,null,"Tweedbank"]
[null,null,null,null,null,null,"Galashiels"]
[null,null,null,null,null,null,null,"TD1 3TE"]
[{"$f":"'Practitioners Member Details'!K8&\" \"&'Practitioners Member Details'!L8&\" \"&'Practitioners Member Details'!M8","v":"  "},null,null,null,null,null,null,"www.pensions.gov.scot"]
[{"$f":"'Practitioners Member Details'!K29","v":0}]
[{"$f":"'Practitioners Member Details'!K30","v":0},null,null,null,null,null,"Tel:   01896 893000"]
[{"$f":"'Practitioners Member Details'!K31","v":0},null,null,null,null,null,"Fax:  01896 893214"]
[{"$f":"'Practitioners Member Details'!K32","v":0},null,null,null,null,null,"nhspractitioner@gov.scot"]
[{"$f":"'Practitioners Member Details'!K33","v":0}]
[null,null,null,null,null,null,"Our ref: ",{"$f":"'Practitioners Member Details'!K10","v":0}]
[null,null,null,null,null,null,"Letter Ref: ","Pres v1.0"]
[null,null,null,null,null,null,{"$f":"NOW()","v":"2020-06-15T11:11:08.860"}]
[]
[{"$f":"\"Dear \"&'Practitioners Member Details'!K8&\" \"&'Practitioners Member Details'!M8","v":"Dear  "}]
[]
["National Health Service Superannuation Scheme (Scotland)"]
[]
["In accordance with your request please find enclosed an estimate of your retirement benefits.  You should read the notes for further explanatory information."]
[]
[]
["Name",null,{"$f":"'Practitioners Member Details'!L8&\" \"&'Practitioners Member Details'!M8","v":" "},null,"National Insurance No",null,{"$f":"'Practitioners Member Details'!K35","v":0}]
["Date of Birth",null,{"$f":"'Practitioners Member Details'!K12","v":"00:00:00"},null,"Superannuation No",null,{"$f":"'Practitioners Member Details'!K10","v":0}]
["Normal Retirement Date",null,{"$f":"IF('Practitioners Member Details'!K14=1995,DATE(YEAR('Practitioners Member Details'!K12)+60,MONTH('Practitioners Member Details'!K12),DAY('Practitioners Member Details'!K12)),DATE(YEAR('Practitioners Member Details'!K12)+65,MONTH('Practitioners Member Details'!K12),DAY('Practitioners Member Details'!K12)))","v":"1964-12-31"},null,"Normal Pension Age",null,{"$f":"IF('Practitioners Member Details'!K14=1995,60,65)","v":65}]
[]
[{"$f":"IF('Practitioners Member Details'!Q22<>\"\",\"Estimated Current Retirement Benefits (\"&TEXT('Practitioners Member Details'!Q22,\"dd/mm/yyyy\")&\")\",\"Estimated Current Retirement Benefits (\"&TEXT(G17,\"dd/mm/yyyy\")&\")\")","v":"Estimated Current Retirement Benefits (15/06/2020)"}]
["Pension",null,{"$f":"'Practitioners Ben Certificate'!D16","v":{"$error":"#N/A"}},null,"Lump Sum",null,{"$f":"IF('Practitioners Member Details'!K14=1995,ROUND('Practitioners Ben Certificate'!D27,2),\"No Automatic Lump Sum\")","v":"No Automatic Lump Sum"}]
[]
["As you are no longer in pensionable employment, your basic retirement benefits should remain unchanged.  These will be index linked in line with inflation until retirement.  "]
[]
[]
["This is not a statement of your legal entitlement and is intended for illustrative purposes only.  Exact figures for retirement benefits cannot be given until an application for retirement benefits has been made in accordance with the scheme rules.  Scottish Public Pensions Agency will accept no responsibility for the accuracy of this information."]
[]
[]
[]
[]
["If you require any further information please do not hesitate to contact the Agency at the above address."]
[]
[]
["Yours sincerely"]
[]
[]
[]
[]
[]
["NHS Practitioners Team"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Notes\n\nPension benefits for service as a practitioner are based on pensionable remuneration earned in each financial year which is then uprated by factors to a current value at the date of ceasing to pay contributions and added together to give the Total Uprated Superannable Remuneration (TUSR).\n\nThe pension in the 1995 Section of the Scheme is calculated at 1.4% of the TUSR and the tax free lump sum as 4.2% of the TUSR.\n\nIn the 2008 Section the pension is calculated at 1.87% of the TUSR.  There is no automatic tax free lump sum however there is provision to give up an amount of pension in exchange for a tax free lump sum.  Further information is provided below.\n\nPension benefits for non-practitioner earnings are based on an accrual rate of 1/80th for the 1995 section and 1/60th for the 2008 section.\n\nPension flexibilities for practitioners have been applied but these cannot be fully tested until retirement when the highest possible benefits will be paid.\n\nAny service purchased as the result of an added years contract has been included in the estimate as a proportional credit.\n\nPractitioner earnings and the Consumer Price Index rates are not available in advance therefore SPPA do not provide projections of benefits."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Increasing your Tax Free Lump Sum\n\nThere is the provision to give up an amount of pension in exchange for an additional lump sum up to the maximum allowed by HM Revenue & Customs of 25% of the fund value.  There is a Commutation Calculator on our website that can be used to project estimated values.  The factor for converting your pension into lump sum is 12:1 which means that for every £1 of pension you give up, you will get £12 added to your lump sum."]

{"sheet":"Practitioners PI Finder","index":12,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,"yyyy","PI Date"]
[null,null,"Select PI table:",null,null,{"$f":"IF(AND('Practitioners Member Details'!K25=\"Yes\",'Practitioners Member Details'!Q25<G3),2019,2020)","v":2020},43927]
[]
[null,null,null,null,null,"dd/mm/yyyy"]
[null,null,"Enter date for PI:",null,null,{"$f":"'Practitioners Member Details'!P16","v":"1900-01-01"}]
[]
[]
[null,null,"PI for this date is:",null,null,{"$f":"IF(F6=0/1/1900,1,VLOOKUP(F6,'PI Data'!$A$3:$AZ$998,F3 - 'PI Data'!$A$1 + 2))","v":{"$error":"#N/A"}}]

{"sheet":"Practitioners Ben Certificate","index":13,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":true,"merged":[[34,0,34,2],[34,3,34,4],[31,0,31,2],[31,3,31,4],[32,0,32,2],[32,3,32,4],[33,0,33,2],[33,3,33,4],[30,0,30,2],[30,3,30,4],[22,0,22,1],[22,2,22,3],[23,0,23,4],[24,0,24,2],[24,3,24,4],[25,0,25,4],[26,0,26,1],[26,3,26,4],[28,0,28,4],[29,0,29,2],[29,3,29,4],[21,0,21,1],[11,0,11,1],[11,2,11,3],[12,0,12,1],[13,0,13,1],[13,3,13,4],[15,0,15,1],[15,3,15,4],[17,0,17,4],[18,0,18,2],[18,3,18,4],[20,0,20,2],[20,3,20,4],[10,0,10,1],[10,2,10,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,2,4,3],[5,2,5,3],[6,0,6,4],[7,0,7,2],[7,3,7,4],[9,0,9,2],[9,3,9,4]]}
[{"$f":"IF('Practitioners Member Details'!K14=1995,\"NHS 1995 Section\",\"NHS 2008 Section\")","v":"NHS 2008 Section"}]
["Estimated Retirement Benefits from Deferred Status"]
[{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K23=\"Yes\"),\"with Actuarial Reduced Pension\",\"\")","v":""}]
[{"$f":"IF('Practitioners Member Details'!Q23<>\"\",'Practitioners Member Details'!Q23,NOW())","v":"2020-06-15T11:11:08.860"}]
["Name:",{"$f":"'Practitioners Member Details'!K8&\" \"&'Practitioners Member Details'!L8&\" \"&'Practitioners Member Details'!M8","v":"  "},"Last day of Service:",null,{"$f":"'Practitioners Member Details'!K16","v":"00:00:00"}]
["NI Number:",{"$f":"'Practitioners Member Details'!K35","v":0},"Reference:",null,{"$f":"'Practitioners Member Details'!K10","v":0}]
["Annual Pension"]
[]
[]
["Deferred Basic Total Pension",null,null,{"$f":"'Practitioners Member Details'!K18","v":0}]
[null,null,null,null,null,null,null,null,"VERA 1995",null,"VERA 2008"]
[{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\"),\"Less early retirement reduction (\"&G12&\"%)\",\" \")","v":" "},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K23=\"Yes\",'Practitioners Member Details'!K14=1995),\"£\" & ROUND(D10,2) & \" x \" & I12,IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<65,'Practitioners Member Details'!K23=\"Yes\",'Practitioners Member Details'!K14=2008),\"£\" & ROUND(D10,2) & \" x \" & K12,\" \"))","v":" "},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=1995),D10*I12,IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<65,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=2008),D10*K12,0))","v":0},{"$f":"IF(AND('Practitioners Member Details'!K14=1995,I12<>\"\"),((1-I12)*100),IF(AND('Practitioners Member Details'!K14=2008,K12<>\"\"),((1-K12)*100),\"\"))","v":""},{"$f":"IF(F12<>\"\",ROUND(F12,2),\"\")","v":""},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=1995),IF('Practitioners Member Details'!Q22>=43402,VLOOKUP(Age!M18,'VERA Pension Factors'!A7:M18,MATCH(Age!M19,'VERA Pension Factors'!A7:M7,0),FALSE),VLOOKUP(Age!M18,'VERA Pension Factors'!P7:AB18,MATCH(Age!M19,'VERA Pension Factors'!P7:AB7,0),FALSE)),\"\")","v":""},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<65,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=2008),IF('Practitioners Member Details'!Q22>=43402,VLOOKUP(Age!M18,'VERA Pension Factors'!A44:M53,MATCH(Age!M19,'VERA Pension Factors'!A36:M36,0),FALSE),VLOOKUP(Age!M18,'VERA Pension Factors'!P44:AB53,MATCH(Age!M19,'VERA Pension Factors'!P36:AB36,0),FALSE)),\"\")","v":""}]
[]
[{"$f":"IF('Practitioners PI Finder'!F9>1,\"Plus Pension Increase\" &\" (\"&F14&\")\",\" \")","v":{"$error":"#N/A"}},null,null,{"$f":"IF('Practitioners PI Finder'!F9>1,IF(E12<>0,(E12*F14)-E12,(D10*F14)-D10),0)","v":{"$error":"#N/A"}},null,{"$f":"IF('Practitioners PI Finder'!F9>1,ROUND('Practitioners PI Finder'!F9,4),0)","v":{"$error":"#N/A"}}]
[]
["Estimated Annual Pension",null,null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\"),SUM(E12+D14),SUM(D10+D14))","v":{"$error":"#N/A"}}]
[]
["Lump Sum"]
[]
[]
["Deferred Basic Lump Sum",null,null,{"$f":"'Practitioners Member Details'!K20","v":0}]
[{"$f":"IF('Practitioners Member Details'!K14=2008,\"No Automatic Lump Sum given.\",\"\")","v":""},null,null,null,null,null,null,null,"VERA LS"]
[{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=1995),\"Less early retirement reduction (\"&G23&\"%)\",\" \")","v":" "},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K23=\"Yes\",'Practitioners Member Details'!K14=1995),\"£\" & ROUND(D21,2) & \" x \" & I23,\" \")","v":" "},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=1995),ROUND('Practitioners Ben Certificate'!D21,2)*'Practitioners Ben Certificate'!I23,0)","v":0},{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K14=1995),(1-'Practitioners Ben Certificate'!I23)*100,\"\")","v":""},{"$f":"IF(F23<>\"\",ROUND(F23,2),\"\")","v":""},null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\",'Practitioners Member Details'!K14=1995),IF('Practitioners Member Details'!Q22>=43402,VLOOKUP(Age!M18,'VERA LS Factors'!A7:M19,MATCH(Age!M19,'VERA LS Factors'!A7:M7,0),FALSE),VLOOKUP(Age!M18,'VERA LS Factors'!P7:AB19,MATCH(Age!M19,'VERA LS Factors'!P7:AB7,0),FALSE)),\"\")","v":""}]
[{"$f":"IF('Practitioners Member Details'!K14=2008,\"You may wish to give up part of your pension to receive a tax free Lump Sum.\",\"\")","v":""}]
[{"$f":"IF(AND('Practitioners PI Finder'!F9>1,'Practitioners Member Details'!K14=1995),\"Plus Pension Increase\" &\" (\"&F25&\")\",\" \")","v":{"$error":"#N/A"}},null,null,{"$f":"IF(AND('Practitioners PI Finder'!F9>1,'Practitioners Member Details'!K14=1995),IF(E23<>0,(E23*F25)-E23,(D21*F25)-D21),0)","v":{"$error":"#N/A"}},null,{"$f":"IF(AND('Practitioners PI Finder'!F9>1,'Practitioners Member Details'!K14=1995),ROUND('Practitioners PI Finder'!F9,4),0)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Practitioners Member Details'!K14=2008,\"The maximum allowed by HM Revenue & Customs is 25% of your Fund Value.\",\"\")","v":""}]
[{"$f":"IF('Practitioners Member Details'!K14=1995,\"Estimated Lump Sum\",\"\")","v":""},null,null,{"$f":"IF(AND('Practitioners Member Details'!Q16=\"VERA\",Age!M18<60,'Practitioners Member Details'!K22=\"Yes\"),SUM(E23+D25),SUM(D21+D25))","v":{"$error":"#N/A"}}]
[]
["HMRC Lifetime Allowance (LTA)"]
[]
["Lifetime Allowance",null,null,{"$f":"IF('Practitioners PI Finder'!F3=2018,1030000,1055000)","v":1055000}]
["Value of Crystallised Benefits",null,null,{"$f":"(D16*20)+D27","v":{"$error":"#N/A"}},null,null,"Tax Charge Message"]
["Percentage of LTA Used (%)",null,null,{"$f":"(D32/D31)*100","v":{"$error":"#N/A"}}]
["Value of LTA Unused",null,null,{"$f":"IF(D31-D32<0,0,D31-D32)","v":{"$error":"#N/A"}}]
["Percentage of LTA Unused (%)",null,null,{"$f":"IF(100-D33<0,0,100-D33)","v":{"$error":"#N/A"}}]