{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Guidance","Added pension calculator","Calcs_hide","SPD Calculations_hide","Add Pension Factors"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":203,"comments":3,"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":"Guidance","index":0,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[[98,1,98,12],[99,1,99,12],[1,2,1,9],[3,1,3,12],[95,1,95,12],[96,1,96,12],[97,1,97,12]]}
[]
[null,null,"Added pension calculator - for members of alpha"]
[]
[null,"Welcome to the Civil Service Pension alpha scheme added pension calculator"]

{"sheet":"Added pension calculator","index":1,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,1,63,12],[64,1,64,12],[19,1,19,6],[5,1,5,6],[56,1,56,12],[60,1,60,12],[61,1,61,12],[62,1,62,12],[15,4,15,7],[17,4,17,7],[53,1,53,12],[23,4,23,7],[32,1,32,3],[37,1,37,3],[27,1,27,3],[41,1,41,7],[1,2,1,9],[8,4,8,7],[10,4,10,7],[6,4,6,7],[57,1,57,12],[12,4,12,7],[3,1,3,12],[29,8,29,12],[17,1,17,3],[15,1,15,3],[12,1,12,3],[10,1,10,3],[8,1,8,3],[6,1,6,3],[25,1,25,3],[34,4,34,7],[21,4,21,7],[27,4,27,7],[29,4,29,7],[25,4,25,7],[34,1,34,3],[32,4,32,7],[29,1,29,3],[23,1,23,3],[37,4,37,9],[41,8,41,9],[47,8,47,9],[49,8,49,9],[47,1,47,7],[49,1,49,7]]}
[]
[null,null,"Added pension calculator - for members of alpha"]
[]
[null,"You can use this tool to calculate and cost your added pension."]
[]
[null,"Step 1 - About you"]
[null,"What is your name? ",null,null,null,null,null,null,{"$f":"IF(uiName=\"\",\"Enter name\",\"\")","v":"Enter name"}]
[]
[null,"What is your date of birth? ",null,null,null,null,null,null,{"$f":"IF(uiDOB=\"\",\"Enter date of birth\",\"\")","v":"Enter date of birth"},null,null,null,null,null,"uiDOB"]
[]
[null,"What is your gender? ",null,null,null,null,null,null,{"$f":"IF(uiSex=\"\",\"Enter gender\",\"\")","v":"Enter gender"},null,null,null,null,null,"uiSex"]
[]
[null,"Do you have at least 12 months' pensionable service in the alpha scheme? ",null,null,null,null,null,null,{"$f":"IF(ui_12MonthsService=\"\",\"Enter response\",\"\")","v":"Enter response"},null,null,null,null,null,"ui_12MonthsService"]
[]
[]
[null,"The date you will reach your Normal Pension Age (NPA) is: ",null,null,{"$f":"resdaySPD","v":""}]
[]
[null,"Your Normal Pension Age in the alpha scheme is: ",null,null,{"$f":"resstrSPA","v":""}]
[]
[null,"Step 2 - Your added pension options"]
[]
[null,null,null,"Previously purchased Added Pension","NA",null,null,null,"HIDDEN"]
[]
[null,{"$f":"\"When would you like your added pension contract to start? \"","v":"When would you like your added pension contract to start? "},null,null,null,null,null,null,{"$f":"IF(uiDOC=\"\",\"Enter start date.\",IF(uiDOC<=uiDOB,\"Must be after date of birth.\",\"\"))","v":"Enter start date."}]
[]
[null,"What sort of pension do you want to buy? ",null,null,null,null,null,null,{"$f":"IF(uiSelfSpouseTag=\"\",\"Enter type of pension you require\",\"\")","v":"Enter type of pension you require"}]
[]
[null,{"$f":"\"Do you want to calculate a 'pension' amount or \"&\nIF(uiPaymentOpt=\"\",\"'payment'? \",IF(uiPaymentOpt=INDEX(tabPaymentOpt,2),\"monthly 'payment's? \",IF(uiPaymentOpt=INDEX(tabPaymentOpt,1),\"single lump sum 'payment'? \",\"\")))","v":"Do you want to calculate a 'pension' amount or 'payment'? "},null,null,null,null,null,null,{"$f":"IF(uiPenPayTag=\"\",\"Enter Pension or Payment\",\"\")","v":"Enter Pension or Payment"}]
[]
[null,"How would you like to pay for your added pension? ",null,null,null,null,null,null,{"$f":"IF(uiPaymentOpt=\"\",\"Enter payment option.\",\n   IF(AND(uiPaymentOpt=\"Lump Sum\",OR(uiDOC<DATE(2016,4,1),ui_12MonthsService=\"No\")),\"You must have at least 12 months pensionable service in alpha to take out a Lump Sum, check start date.\",\"\"))","v":"Enter payment option."}]
[]
[]
[null,{"$f":"IF(uiPenPayTag=INDEX(tabTarget,2),\"How much added pension would you like to buy? \",\nIF(AND(uiPaymentOpt=INDEX(tabPaymentOpt,2),uiPenPayTag=INDEX(tabTarget,1)),\"How much would you like to pay each month? \",\nIF(AND(uiPaymentOpt=INDEX(tabPaymentOpt,1),uiPenPayTag=INDEX(tabTarget,1)),\"What lump sum payment would you like to make? \",\"\")))","v":""},null,null,0,null,null,null,{"$f":"IF(AND(O33=FALSE,uiPenPayAmt=0),\"Enter \"&uiPenPayTag&\".\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(AND(erruiPaymentOpt=\"\",erruiPenPayTag=\"\"),FALSE,TRUE)","v":true}]
[]
[null,"How many years do you want to make the monthly payments for? Or you can select NPA for an ongoing contract. ",null,null,1,null,null,null,{"$f":"IF(AND(O35=FALSE,OR(PaymentPeriod=0,PaymentPeriod=\"\")),\"Enter number of years\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(uiPaymentOpt=INDEX(tabPaymentOpt,2),FALSE,TRUE)","v":true}]
[]
[]
[null,"For more information about added pension, please refer to the Civil Service Pensions website: "]
[]
[null,"Results / Summary"]
[]
[null,{"$f":"resCombinedStatement","v":""},null,null,null,null,null,null,{"$f":"IF(bOverallError,errError,IF(OR(ISNUMBER(uiPaymentPeriod),uiPaymentPeriod=\"NPA\"),IF(uiPenPayTag=\"Pension\",resCombinedResult/PaymentPeriod,resCombinedResult),resCombinedResult))","v":"Error"}]
[]
[]
[]
[]
[null,"Added pension limit"]
[null,"Does the amount selected pass the limit check?",null,null,null,null,null,null,{"$f":"IF(uiPenPayTag=\"Pension\",IF(uiPenPayAmt<6600,\"Yes\",\"No\"),IF(I42<6600,\"Yes\",\"No\"))","v":"No"}]
[]
[null,"If you take this added pension your alpha added pension limit balance will be: ",null,null,null,null,null,null,{"$f":"IF(I42>Calcs_hide!C111,Calcs_hide!C161,IF(uiPenPayTag=\"Pension\",Calcs_hide!C111-uiPenPayAmt,IF(uiPenPayTag=\"Payment\",Calcs_hide!C111-I42,\"Error\")))","v":{"$error":"#N/A"}}]
[]
[]
[null,"Error Messages"]
[null,{"$f":"_errOverall","v":"Check inputs.  Select a gender.  Age at 1 April prior to date of contract must be greater than 17.  "}]
[]
[null,"Important Notes"]
[null,"1 The added pension calculator held on the Civil Service Pensions website uses the latest calculation factors. Factors, and therefore results may be subject to change in the future. \n2 Please note that if you do not use the most recent version of the added pension calculator then the results will not be valid. The latest version of this calculator is held on the Civil Service Pensions website: www.civilservicepensionscheme.org.uk\n3 The cost shown is the gross amount.  You will normally get income tax relief on these contributions.  If you make your payment through payroll the tax relief will be applied automatically.  If you make a lump sum purchase by cheque you will have to claim tax relief from HM Revenue & Customs.\n4 If you have chosen added pension for self and dependants, this will provide a dependants' pension (paid after your death to a surviving wife, husband, civil partner or nominated partner) of 3/8 of your added pension.\n5 In most circumstances your added pension will come into payment at the same time as your alpha pension.  If you draw your pension before Normal Pension Age (NPA) it will be reduced for early payment.  If you carry on working beyond NPA, your pension will be adjusted for late payment.\n6 Added pension will be adjusted in line with prices.  The current value of your added pension (including any adjustment for late payment) will be shown on the alpha benefit statement which you will be sent each year.\n7 The figures shown are an illustration of the current cost of buying added pension.  \n8 If you have selected monthly contributions, the calculator assumes that these start from the date that your contract starts and run for a complete number of years. You can request to cancel your monthly contributions at any time, but you must continue to make your contributions until the end of the scheme year (31 March). Lump Sum purchases are assumed to be made at the contract start date.  You cannot buy added pension by lump sum in your first 12 months of alpha scheme membership."]
[null,"9 Your total pension contributions (not just added pension) in any year cannot be more than your salary.\n10 If you increase your pension savings in any year over the Annual Allowance set by HM Revenue & Customs, you may incur a tax charge.  For more information, including examples, see the HM Revenue & Customs website, www.hmrc.gov.uk.\n11 If you want to purchase added pension, the application form will be available on the Civil Service Pensions website at the end of March 2015.\n12 This is a calculated value at today's rates.  The State Pension age used is based on legislation at 17/02/2015.                                                                               13. The Added Pension Limit it based on the amount of Added Pension calculated above, it does not take account of any Added Pension you might have purchased in previous scheme years.\nDisclaimer: Every effort has been made to make this tool as accurate as possible, but in the event of any differences, the regulations will apply. This tool is based on the alpha regulations current at the time of publication and there is no guarantee that any part of the regulations will not change in the future. You should not take anything in this tool as financial advice. You might want to consider contacting an Independent Financial Adviser (IFA) to discuss your retirement planning. You can find tips on finding an IFA by visiting the Financial Conduct Authority website, www.fca.org.uk                                                                      \n\n\n"]
[]
[null,"Audit"]
[null,{"$f":"msgPrint","v":"10:58,  17 Nov 2023 .  "}]
[null,{"$f":"msgFileName","v":"Filename : \\\\MCCLPRDFSSM385\\XDrive\\Systems Support\\Application Team\\Calculators 2023 Updates\\2023 Updated\\AP_Calc\\Jon Hargreaves - AT\\for locking and returning\\AP Calcs\\[Alpha added pension calculator 2024.xlsm"}]
[null,{"$f":"msgVersionNumber","v":"Version number : 1.00.  "}]
[null,{"$f":"msgExpiration","v":"Tool expires on 01/04/2099.  "}]
[null,{"$f":"msgPDFSaveLocation","v":"PDF saved to : TBC"}]

{"sheet":"Calcs_hide","index":2,"n_rows":242,"n_cols":32,"rows_kept":242,"cut":false,"hidden":true,"merged":[[3,2,3,6],[4,2,4,6],[19,1,19,4],[20,1,20,4],[6,2,6,6],[11,2,11,6],[9,2,9,6],[7,2,7,6]]}
[null,null,{"$f":"strToolName","v":"Added Pension"}]
[]
[]
[null,"Description","This sheet is intended to be used by for calculation testing only.  It is not designed to be used by administration staff nor exposed to public users\nAdded pension Factors, based on GAD advice in documents 'EPAAndEEPASpecification working document v4 21112014.pdf', 'Copy of epa headroom factors 21112014.xlsx'"]
[null,"Schemes","Alpha only"]
[]
[null,"Assumptions/exclusions","The tool does not allow user to enter existing added pension or EPA, this is in the calculations and can be implemented for pot 1/4/2016 calculations but not in the UI."]
[null,null,"If member breaches 100% of headroom check a warning is displayed wrt added pension"]
[null,null,"This version of the tool is restricted to Date of Calcs 1/4/2015 - 31/3/2016"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Instructions\"","v":"Added Pension - Instructions"}]
[null,null,null,null,null,"Key to cell colours:"]
[null,null,null,null,null,"Data from data sheet (yellow)"]
[null,"How to use this EPA Testing Tool",null,null,null,"Work Variable (orange)"]
[null,"Complete data on the inputs sheet",null,null,null,"Output (green)"]
[null,null,null,null,null,"Messages (pink)"]
[null,null,null,null,null,"System Tables Values (blue)"]
[null,null,null,null,null,"System Variable (dark green)"]
[null,null,null,null,null,"Error In Cell (red)"]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - System Variables\"","v":"Added Pension - System Variables"}]
[]
[]
[]
[null,"Version Number",1,"VersionNumber"]
[null,"Security Classification","Unclassified","SecurityClassification"]
[null,"Tool Name","Added Pension","strToolName"]
[null,"Today's Date",{"$f":"TODAY()","v":"2023-11-17"},"dayToday"]
[null,"Tool Expiry Date","2099-04-01","dayExpiry"]
[null,"Minimum Date of Calculation","2015-04-01","dayMinDOC"]
[null,"Maximum Date of Calculation","2016-04-01","dayMaxDOC"]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Version Control\"","v":"Added Pension - Version Control"}]
[]
[]
[null,"Version Number, tabVersionNumber","Work Carried out","By","Date","Checked by","Date","NOTES"]
[null,0.09,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-08"]
[null,0.13,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-10"]
[null,0.14000000000000001,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-13"]
[null,0.15,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-14"]
[null,0.16,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-15"]
[null,0.17,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-16"]
[null,0.18,"See 'Added pension verison control document V0.18 16022015.docx'","See 'Added pension verison control document V0.18 16022015.docx'","2015-02-16"]
[null,1,"See 'Added pension verison control document V1.0.0 17022015.docx'","See 'Added pension verison control document V1.0.0 17022015.docx'","2015-02-17"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Inputs\"","v":"Added Pension - Inputs"}]
[]
[null," Employee Details"]
[null,"Date of Birth",{"$f":"uiDOB","v":"00:00:00"},"DoB"]
[null,"Sex",{"$f":"uiSex","v":0},"Gender"]
[null,"Do you have 12 months pensionable service in the alpha scheme?",{"$f":"ui_12MonthsService","v":0},"_12MonthsService"]
[]
[null,"Added Pension Specific"]
[null,"Date of Added Pension Contract Start",{"$f":"uiDOC","v":"00:00:00"},"DoC"]
[null,"Pension amount/Payment amount desired",{"$f":"uiPenPayTag","v":"00:00:00"},"PenPayTag"]
[null,"Payment Option",{"$f":"uiPaymentOpt","v":"00:00:00"},"PaymentOpt"]
[null,"Payment period years",{"$f":"IF(uiPaymentPeriod=\"NPA\",MAX(tabAllowablePeriods),uiPaymentPeriod)","v":1},"PaymentPeriod","<NPA"]
[null,"Self-Only/including Spouse's",{"$f":"uiSelfSpouseTag","v":"00:00:00"},"SelfSpouseTag"]
[null,"Pension or Lump Sum Payment or Monthly Payment amount",{"$f":"uiPenPayAmt","v":0},"PenPayAmt"]
[]
[null,"Previous AP Details - not required for this tool as this tool only deals with the 2015-2016 period."]
[null,"Previously purchased Added Pension",0,"PrevAddPen","Not used in this version as this applies to previous alpha pension"]
[null,"Previous EPA Details - not required for this tool as this tool only deals with the 2015-2016 period."]
[null,"Previous EPA Details","Date Contract Started","Date Contract Ended","% of Headroom"]
[null,"EPA1","1900-01-01","1900-01-01",0,"EPA1SDate","EPA1EDate"]
[null,"EPA2","1900-01-01","1900-01-01",0,"EPA2SDate","EPA2EDate"]
[null,"EPA3","1900-01-01","1900-01-01",0,"EPA3SDate","EPA3EDate"]
[null,null,null,null,"All 0%"]
[null,null,"%of headroom"]
[null,"Current EPA details",0,"CurrEPApc"]
[]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Calculations\"","v":"Added Pension - Calculations"}]
[]
[]
[null,"Eligibility based on date"]
[]
[null,"Current Scheme Year, start date based on today",{"$f":"(YEAR(DoC)+IF(MONTH(DoC)<4,-1,0))","v":1899},"StartDOCSY"]
[]
[]
[null,"Time Period Calculations"]
[null,"Age last birthday",{"$f":"IF(DATE(1980,MONTH(DoC),DAY(DoC))>=DATE(1980,MONTH(DoB),DAY(DoB)),0,-1)+YEAR(DoC)-YEAR(DoB)","v":0},"Age",null,null,null,null,null,null,null,"Periodical Payments Table"]
[null,"NPA Date",{"$f":"resdaySPD","v":""},"NPAdate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perioidcal Calcualtions"]
[null,"NPA (complete months)",{"$f":"IFERROR('SPD Calculations_hide'!resdSPA_CYM,0)","v":0},"NPA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per month before Adjustment ",{"$f":"(PenPayAmt/PeriodicalRate)/12","v":{"$error":"#DIV/0!"}},"CostPerMonthBeforeAdj"]
[null,"NPA (complete years)",{"$f":"ROUNDDOWN(NPA,0)","v":0},"NPACompyrs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O109/N109+1","v":1.0005261731498887},null,null,null,null,null,null,null,null,null,null,"Total Pension at NPA based on CostPerMonthBeforeAdj",{"$f":"SUM(AB109:AB158)","v":{"$error":"#DIV/0!"}},"totPenNRABeforeAdj"]
[null,"NPA round up",{"$f":"ROUNDUP(NPA,0)","v":0},"NPArdup",null,null,null,null,null,null,null,"Cumulative Periodical Rate : ",{"$f":"MAX(Z109:Z159)","v":0},"PeriodicalRate",null,null,null,null,null,null,null,null,null,null,null,null,"Total Pension at Calc Date based on CostPerMonthBeforeAdj (discounted)",{"$f":"totPenNRABeforeAdj/X109","v":{"$error":"#DIV/0!"}},"totPenCalcDateBeforeAdj"]
[null,"NPA round down",{"$f":"ROUNDDOWN(NPA,0)","v":0},"NPArddwn",null,null,null,null,null,null,null,"Adj Cumulative Periodical Rate",{"$f":"MAX(AF109:AF158)","v":{"$error":"#VALUE!"}},"AdjPeriodicalRate",null,null,null,null,null,null,null,null,null,null,null,null,"Cost per month after discounting adjustment",{"$f":"(uiPenPayAmt * NPAFac*RevFac)/12","v":{"$error":"#REF!"}},"MonthlyCost"]
[null,"Interpolation Months",{"$f":"(NPA-NPACompyrs)*12","v":0},"InterpMths",null,null,null,null,null,null,null,"tabPeriodicalRates"]
[null,"Max 1 Aprils to NPA",{"$f":"YEAR(NPAdate)-YEAR(DoC)+IF(MONTH(DoC)<4,1,0)+IF(MONTH(NPAdate)<4,-1,0)+IF(AND(DAY(NPAdate)=1,MONTH(NPAdate)=4),-1,0)","v":{"$error":"#VALUE!"}},"NPAAprils",null,null,null,null,null,null,null,"Start Of Scheme Year, based on DOC","End of Scheme Year","Start of period","End Of Period","Fraction of year, actual days","Age at start of scheme year","NPA Aprils","NPA round up Table","NPA round down Table","NPA round up Factor","NPA round down Factor","NPA Factor","NPA Revaluation Factor","Added pension ratio [P(1)]","Cum Yearly Pension","Amount of pension bought in scheme year based on Cost per month Before Adjustement","Pension bought in period revalued to NPA",null,null,"Adjusted Ap Ratio","Adjusted Cum Ratio"]
[null,"Period End Date",{"$f":"IF(PaymentPeriod=\"NPA\",NPAdate,DATE(YEAR(DoC)+PaymentPeriod,MONTH(DoC),DAY(DoC)))-1","v":"1900-12-30"},"PeriodDate",null,null,null,null,null,null,null,{"$f":"DATE(StartDOCSY,4,1)","v":"3799-04-01"},{"$f":"DATE(YEAR(L109)+1,3,31)","v":"3800-03-31"},{"$f":"MAX(L109,DoC)","v":"3799-04-01"},{"$f":"MIN(M109,PeriodDate)","v":"1900-12-30"},{"$f":"IF(N109=DoC,1,0)","v":0},{"$f":"IF(DATE(1980,MONTH(L109),DAY(L109))>=DATE(1980,MONTH(DoB),DAY(DoB)),0,-1)+YEAR(L109)-YEAR(DoB)","v":1899},{"$f":"MAX(YEAR(NPAdate)-YEAR(N109)+IF(MONTH(N109)<4,1,0)+IF(MONTH(NPAdate)<4,-1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(\"ADDPENNPA\",NPArdup,IF(PaymentOpt=INDEX(tabPaymentOpt,1),\"\",\"C\"),\"TAB\")","v":"ADDPENNPA0CTAB"},{"$f":"CONCATENATE(\"ADDPENNPA\",NPACompyrs,IF(PaymentOpt=INDEX(tabPaymentOpt,1),\"\",\"C\"),\"TAB\")","v":"ADDPENNPA0CTAB"},{"$f":"VLOOKUP(Q109,INDIRECT(S109,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Q109,INDIRECT(NPArddwntable,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},{"$f":"V109","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(R109,ADDPENREVTAB,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(P109>0,P109/(W109*X109),0)","v":0},{"$f":"Y109","v":0},{"$f":"CostPerMonthBeforeAdj*12*Y109","v":{"$error":"#DIV/0!"}},{"$f":"AA109*X109","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y109*X109/$X$109","v":{"$error":"#VALUE!"}},{"$f":"AE109","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Periodic",{"$f":"VLOOKUP(IF(MONTH(DoC)<4,YEAR(DoC)-1,YEAR(DoC)),ADDPENLIMTAB,2)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"M109+1","v":"3800-04-01"},{"$f":"DATE(YEAR(L110)+1,3,31)","v":"3801-03-31"},"3800-04-01","1900-12-30",0,1900,{"$error":"#VALUE!"},{"$f":"S109","v":"ADDPENNPA0CTAB"},{"$f":"T109","v":"ADDPENNPA0CTAB"},{"$f":"VLOOKUP(Q110,INDIRECT(S110,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"V110","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},0,{"$f":"Z109+Y110","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"Y110*X110/$X$109","v":{"$error":"#VALUE!"}},{"$f":"AE110+AF109","v":{"$error":"#VALUE!"}}]
[null,"Added Pension Limit",{"$f":"F111","v":{"$error":"#N/A"}},"AddPenLim","Lump Sum",{"$f":"VLOOKUP(IF(MONTH(DoC)<4,YEAR(DoC)-1,YEAR(DoC)),ADDPENLIMTABLump,2)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"M110+1","v":"3801-04-01"},"3802-03-31","3801-04-01","1900-12-30",0,1901,{"$error":"#VALUE!"},{"$f":"S110","v":"ADDPENNPA0CTAB"},{"$f":"T110","v":"ADDPENNPA0CTAB"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z110+Y111","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$f":"Y111*X111/$X$109","v":{"$error":"#VALUE!"}},{"$f":"AF110+AE111","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"C111","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,"3802-04-01","3803-03-31","3802-04-01","1900-12-30",0,1902,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$f":"AF111+AE112","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"IF(MONTH(C71)<=3,1,0)","v":1},{"$f":"DATE(YEAR(C71)+1-C113,4,1)","v":"1900-04-01"},null,null,null,null,null,null,null,"3803-04-01","3804-03-31","3803-04-01","1900-12-30",0,1903,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z112+Y113","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Lump Sum",{"$f":"IF(MONTH(C66)<=3,0,1)","v":0},null,null,null,null,null,null,null,null,"3804-04-01","3805-03-31","3804-04-01","1900-12-30",0,1904,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z113+Y114","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Lump Sum Lookup Tables ",null,null,null,null,null,null,null,null,null,"3805-04-01","3806-03-31","3805-04-01","1900-12-30",0,1905,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z114+Y115","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA round up Table",{"$f":"CONCATENATE(\"ADDPENNPA\",NPArdup,IF(PaymentOpt=INDEX(tabPaymentOpt,1),\"\",\"C\"),\"TAB\")","v":"ADDPENNPA0CTAB"},"NPArduptable",null,null,null,null,null,null,null,"3806-04-01","3807-03-31","3806-04-01","1900-12-30",0,1906,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA round down Table",{"$f":"CONCATENATE(\"ADDPENNPA\",NPACompyrs,IF(PaymentOpt=INDEX(tabPaymentOpt,1),\"\",\"C\"),\"TAB\")","v":"ADDPENNPA0CTAB"},"NPArddwntable",null,null,null,null,null,null,null,"3807-04-01","3808-03-31","3807-04-01","1900-12-30",0,1907,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3808-04-01","3809-03-31","3808-04-01","1900-12-30",0,1908,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Lump Sum Factor Lookups",null,null,null,null,null,null,null,null,null,"3809-04-01","3810-03-31","3809-04-01","1900-12-30",0,1909,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA round up Factor",{"$f":"VLOOKUP(Age,INDIRECT(NPArduptable,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},"NPArdupFac",null,null,null,null,null,null,null,"3810-04-01","3811-03-31","3810-04-01","1900-12-30",0,1910,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA round down Factor",{"$f":"VLOOKUP(Age,INDIRECT(NPArddwntable,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},"NPArddwnFac",null,null,null,null,null,null,null,"3811-04-01","3812-03-31","3811-04-01","1900-12-30",0,1911,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA Factor",{"$f":"NPArdupFac*(InterpMths/12)+((12-InterpMths)/12)*NPArddwnFac","v":{"$error":"#REF!"}},"NPAFac",null,null,null,null,null,null,null,"3812-04-01","3813-03-31","3812-04-01","1900-12-30",0,1912,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"NPA Revaluation Factor",{"$f":"VLOOKUP(NPAAprils,ADDPENREVTAB,2)","v":{"$error":"#VALUE!"}},"RevFac",null,null,null,null,null,null,null,"3813-04-01","3814-03-31","3813-04-01","1900-12-30",0,1913,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3814-04-01","3815-03-31","3814-04-01","1900-12-30",0,1914,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3815-04-01","3816-03-31","3815-04-01","1900-12-30",0,1915,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Previous EPA Calcs - not required for this tool as this tool only deals with the 2015-2016 period.","Months Paid","Months to NPA","Headroom used",null,null,null,null,null,null,"3816-04-01","3817-03-31","3816-04-01","1900-12-30",0,1916,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"EPA1",{"$f":"((YEAR(EPA1EDate)-YEAR(EPA1SDate)-IF(OR(MONTH(EPA1EDate)<MONTH(EPA1SDate),AND(MONTH(EPA1SDate)=MONTH(EPA1EDate),DAY(EPA1EDate)<DAY(EPA1SDate))),1,0))*12)+(IF(MONTH(EPA1EDate)>MONTH(EPA1SDate),MONTH(EPA1EDate)-MONTH(EPA1SDate),IF(MONTH(EPA1EDate)<MONTH(EPA1SDate),MONTH(EPA1EDate)-MONTH(EPA1SDate)+12,IF(DAY(EPA1EDate)<DAY(EPA1SDate),11,0))))-IF(MONTH(EPA1EDate)=MONTH(EPA1SDate),0,IF(DAY(EPA1EDate)<DAY(EPA1SDate),1,0))","v":0},{"$f":"((YEAR(NPAdate)-YEAR(EPA1SDate)-IF(OR(MONTH(NPAdate)<MONTH(EPA1SDate),AND(MONTH(EPA1SDate)=MONTH(NPAdate),DAY(NPAdate)<DAY(EPA1SDate))),1,0))*12)+(IF(MONTH(NPAdate)>MONTH(EPA1SDate),MONTH(NPAdate)-MONTH(EPA1SDate),IF(MONTH(NPAdate)<MONTH(EPA1SDate),MONTH(NPAdate)-MONTH(EPA1SDate)+12,IF(DAY(NPAdate)<DAY(EPA1SDate),11,0))))-IF(MONTH(NPAdate)=MONTH(EPA1SDate),0,IF(DAY(NPAdate)<DAY(EPA1SDate),1,0))","v":{"$error":"#VALUE!"}},{"$f":"(EPA1MthsPd/EPA1MthsNPA)*EPA1pc","v":{"$error":"#VALUE!"}},"EPA1MthsPd","EPA1MthsNPA","EPA1Hroom",null,null,null,"3817-04-01","3818-03-31","3817-04-01","1900-12-30",0,1917,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"EPA2",{"$f":"((YEAR(EPA2EDate)-YEAR(EPA2SDate)-IF(OR(MONTH(EPA2EDate)<MONTH(EPA2SDate),AND(MONTH(EPA2SDate)=MONTH(EPA2EDate),DAY(EPA2EDate)<DAY(EPA2SDate))),1,0))*12)+(IF(MONTH(EPA2EDate)>MONTH(EPA2SDate),MONTH(EPA2EDate)-MONTH(EPA2SDate),IF(MONTH(EPA2EDate)<MONTH(EPA2SDate),MONTH(EPA2EDate)-MONTH(EPA2SDate)+12,IF(DAY(EPA2EDate)<DAY(EPA2SDate),11,0))))-IF(MONTH(EPA2EDate)=MONTH(EPA2SDate),0,IF(DAY(EPA2EDate)<DAY(EPA2SDate),1,0))","v":0},{"$f":"((YEAR(NPAdate)-YEAR(EPA2SDate)-IF(OR(MONTH(NPAdate)<MONTH(EPA2SDate),AND(MONTH(EPA2SDate)=MONTH(NPAdate),DAY(NPAdate)<DAY(EPA2SDate))),1,0))*12)+(IF(MONTH(NPAdate)>MONTH(EPA2SDate),MONTH(NPAdate)-MONTH(EPA2SDate),IF(MONTH(NPAdate)<MONTH(EPA2SDate),MONTH(NPAdate)-MONTH(EPA2SDate)+12,IF(DAY(NPAdate)<DAY(EPA2SDate),11,0))))-IF(MONTH(NPAdate)=MONTH(EPA2SDate),0,IF(DAY(NPAdate)<DAY(EPA2SDate),1,0))","v":{"$error":"#VALUE!"}},{"$f":"(EPA2MthsPd/EPA2MthsNPA)*EPA2pc","v":{"$error":"#VALUE!"}},"EPA2MthsPd","EPA2MthsNPA","EPA2Hroom",null,null,null,"3818-04-01","3819-03-31","3818-04-01","1900-12-30",0,1918,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"EPA3",{"$f":"((YEAR(EPA3EDate)-YEAR(EPA3SDate)-IF(OR(MONTH(EPA3EDate)<MONTH(EPA3SDate),AND(MONTH(EPA3SDate)=MONTH(EPA3EDate),DAY(EPA3EDate)<DAY(EPA3SDate))),1,0))*12)+(IF(MONTH(EPA3EDate)>MONTH(EPA3SDate),MONTH(EPA3EDate)-MONTH(EPA3SDate),IF(MONTH(EPA3EDate)<MONTH(EPA3SDate),MONTH(EPA3EDate)-MONTH(EPA3SDate)+12,IF(DAY(EPA3EDate)<DAY(EPA3SDate),11,0))))-IF(MONTH(EPA3EDate)=MONTH(EPA3SDate),0,IF(DAY(EPA3EDate)<DAY(EPA3SDate),1,0))","v":0},{"$f":"((YEAR(NPAdate)-YEAR(EPA3SDate)-IF(OR(MONTH(NPAdate)<MONTH(EPA3SDate),AND(MONTH(EPA3SDate)=MONTH(NPAdate),DAY(NPAdate)<DAY(EPA3SDate))),1,0))*12)+(IF(MONTH(NPAdate)>MONTH(EPA3SDate),MONTH(NPAdate)-MONTH(EPA3SDate),IF(MONTH(NPAdate)<MONTH(EPA3SDate),MONTH(NPAdate)-MONTH(EPA3SDate)+12,IF(DAY(NPAdate)<DAY(EPA3SDate),11,0))))-IF(MONTH(NPAdate)=MONTH(EPA3SDate),0,IF(DAY(NPAdate)<DAY(EPA3SDate),1,0))","v":{"$error":"#VALUE!"}},{"$f":"(EPA3MthsPd/EPA3MthsNPA)*EPA3pc","v":{"$error":"#VALUE!"}},"EPA3MthsPd","EPA3MthsNPA","EPA3Hroom",null,null,null,"3819-04-01","3820-03-31","3819-04-01","1900-12-30",0,1919,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3820-04-01","3821-03-31","3820-04-01","1900-12-30",0,1920,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3821-04-01","3822-03-31","3821-04-01","1900-12-30",0,1921,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3822-04-01","3823-03-31","3822-04-01","1900-12-30",0,1922,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Headroom Calcs",null,null,null,null,null,null,null,null,null,"3823-04-01","3824-03-31","3823-04-01","1900-12-30",0,1923,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"This section is used to check all existing EPA or alpha added pension benefits.",null,null,null,null,null,null,null,null,null,"3824-04-01","3825-03-31","3824-04-01","1900-12-30",0,1924,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"EPA Headroom used",{"$f":"(EPA1Hroom+EPA2Hroom+EPA3Hroom+CurrEPApc)*C122","v":{"$error":"#VALUE!"}},"EPAHroomused",null,null,null,null,null,null,null,"3825-04-01","3826-03-31","3825-04-01","1900-12-30",0,1925,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Add Pension Headroom used",{"$f":"PrevAddPen","v":0},"AddPenHroomused",null,null,null,null,null,null,null,"3826-04-01","3827-03-31","3826-04-01","1900-12-30",0,1926,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Headroom Remaining",{"$f":"C112-EPAHroomused-AddPenHroomused","v":{"$error":"#N/A"}},"Hroomleft",null,null,null,null,null,null,null,"3827-04-01","3828-03-31","3827-04-01",{"$f":"MIN(M137,PeriodDate)","v":"1900-12-30"},0,1927,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Headroom breach?",{"$f":"IF(Hroomleft>0,\"N\",\"Y\")","v":{"$error":"#N/A"}},"Hroomtag",null,null,null,null,null,null,null,"3828-04-01","3829-03-31","3828-04-01","1900-12-30",0,1928,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3829-04-01","3830-03-31","3829-04-01","1900-12-30",0,1929,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Added Pension Calcs",null,null,null,null,null,null,null,null,null,"3830-04-01","3831-03-31","3830-04-01","1900-12-30",0,1930,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,{"$f":"IF(PenPayTag=INDEX(tabTarget,1),\n\"Target Payment of \"&PenPayAmt&IF(PaymentOpt=INDEX(tabPaymentOpt,2),\" per month\",\"as a lump sum\")& \" will pay a pension of\",\n\"Targetted Pension of \"&PenPayAmt&\" will cost - \"&IF(PaymentOpt=INDEX(tabPaymentOpt,2),\"per month \",\"as a lump sum\"))","v":"Targetted Pension of 0 will cost - as a lump sum"},{"$f":"IF(PenPayTag=INDEX(tabTarget,1),\nIF(PaymentOpt=INDEX(tabPaymentOpt,2),PenPayAmt*12/(NPAFac*RevFac),PenPayAmt/(NPAFac*RevFac)),\nIF(PaymentOpt=INDEX(tabPaymentOpt,2),MonthlyCost,PenPayAmt*(NPAFac*RevFac)))","v":{"$error":"#REF!"}},"AddPenRes","Yearly (No Longer Yearly) LKerwin 24/02/17",null,null,null,null,null,null,"3831-04-01","3832-03-31",{"$f":"MAX(L141,DoC)","v":"3831-04-01"},{"$f":"MIN(M141,PeriodDate)","v":"1900-12-30"},{"$f":"IF(N141=DoC,1,0)","v":0},{"$f":"IF(DATE(1980,MONTH(L141),DAY(L141))>=DATE(1980,MONTH(DoB),DAY(DoB)),0,-1)+YEAR(L141)-YEAR(DoB)","v":1931},{"$f":"MAX(YEAR(NPAdate)-YEAR(N141)+IF(MONTH(N141)<4,1,0)+IF(MONTH(NPAdate)<4,-1,0),0)","v":{"$error":"#VALUE!"}},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$f":"VLOOKUP(Q141,INDIRECT(S141,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(Q141,INDIRECT(NPArddwntable,0),IF(SelfSpouseTag=INDEX(tabSelfSpouse,1),IF(Gender=INDEX(tabSex,1),2,3),4))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"VLOOKUP(R141,ADDPENREVTAB,2)","v":{"$error":"#VALUE!"}},{"$f":"IF(P141>0,P141/(W141*X141),0)","v":0},0,{"$f":"CostPerMonthBeforeAdj*12*Y141","v":{"$error":"#DIV/0!"}},{"$f":"AA141*X141","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Headroom Pass?",{"$f":"IFERROR(IF(Hroomleft>=IF(PenPayTag=INDEX(tabTarget,1),AddPenRes,PenPayAmt),\"Yes\",\"No\"),\"Yes\")","v":"Yes"},"HroomPass",null,null,null,null,null,null,null,"3832-04-01","3833-03-31","3832-04-01","1900-12-30",0,1932,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Added Pension bought",{"$f":"IF(PenPayTag=INDEX(tabTarget,1),IF(PaymentOpt=INDEX(tabPaymentOpt,2),PenPayAmt*12/(NPAFac*RevFac),PenPayAmt/(NPAFac*RevFac)),PenPayAmt)","v":0},"AddPenbought",null,null,null,null,null,null,null,"3833-04-01","3834-03-31","3833-04-01","1900-12-30",0,1933,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3834-04-01","3835-03-31","3834-04-01","1900-12-30",0,1934,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"For info:",null,null,null,null,null,null,null,null,null,"3835-04-01","3836-03-31","3835-04-01","1900-12-30",0,1935,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Lump Sum Paid",{"$f":"IF(PaymentOpt=INDEX(tabPaymentOpt,1),IF(PenPayTag=INDEX(tabTarget,1),PenPayAmt,AddPenRes),0)","v":0},"LSPaid",null,null,null,null,null,null,null,"3836-04-01","3837-03-31","3836-04-01","1900-12-30",0,1936,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Monthly Payment",{"$f":"IF(PaymentOpt=INDEX(tabPaymentOpt,1),0,IF(PenPayTag=INDEX(tabTarget,1),PenPayAmt,AddPenRes))","v":{"$error":"#REF!"}},"MthPayment",null,null,null,null,null,null,null,"3837-04-01","3838-03-31","3837-04-01","1900-12-30",0,1937,{"$error":"#VALUE!"},{"$f":"S146","v":"ADDPENNPA0CTAB"},{"$f":"T146","v":"ADDPENNPA0CTAB"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z146+Y147","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3838-04-01","3839-03-31","3838-04-01","1900-12-30",0,1938,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3839-04-01","3840-03-31","3839-04-01","1900-12-30",0,1939,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3840-04-01","3841-03-31","3840-04-01","1900-12-30",0,1940,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3841-04-01","3842-03-31","3841-04-01","1900-12-30",0,1941,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3842-04-01","3843-03-31","3842-04-01","1900-12-30",0,1942,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3843-04-01","3844-03-31","3843-04-01","1900-12-30",0,1943,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3844-04-01","3845-03-31","3844-04-01","1900-12-30",0,1944,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3845-04-01","3846-03-31","3845-04-01","1900-12-30",0,1945,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3846-04-01","3847-03-31","3846-04-01","1900-12-30",0,1946,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"3847-04-01","3848-03-31","3847-04-01","1900-12-30",0,1947,{"$error":"#VALUE!"},"ADDPENNPA0CTAB","ADDPENNPA0CTAB",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$f":"strToolName&\" - Results\"","v":"Added Pension - Results"},null,null,null,null,null,null,null,null,{"$f":"M157+1","v":"3848-04-01"},{"$f":"DATE(YEAR(L158)+1,3,31)","v":"3849-03-31"},"3848-04-01","1900-12-30",0,1948,{"$error":"#VALUE!"},{"$f":"S157","v":"ADDPENNPA0CTAB"},{"$f":"T157","v":"ADDPENNPA0CTAB"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#VALUE!"},0,{"$f":"Z157+Y158","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[null,"Headroom Remaining",{"$f":"IF(Hroomleft-AddPenbought < 0,0,Hroomleft-AddPenbought)","v":{"$error":"#N/A"}},"HroomleftPostNewAP"]
[]
[null,"Combined statement"]
[null,{"$f":"IF(AND(PenPayTag=INDEX(tabTarget,1),PaymentOpt=INDEX(tabPaymentOpt,1)),\"You have chosen to calculate a lump sum payment of \"&TEXT(PenPayAmt,\"£* #,##0.00\")&\" this will purchase an annual \"&LOWER(SelfSpouseTag)&\" added pension of: \",\"\")&\nIF(AND(PenPayTag=INDEX(tabTarget,1),PaymentOpt=INDEX(tabPaymentOpt,2)),\"You have chosen to calculate a monthly payment of \"&TEXT(PenPayAmt,\"£* #,##0.00\")&\n               IF(PaymentPeriod<>\"NPA\",\" per month until the end of the scheme year, this will purchase an annual \"&LOWER(SelfSpouseTag)&\" added pension of: \",\n                                                                          \" per month to your Normal Pension Age, this will purchase a \"&LOWER(SelfSpouseTag)&\" added pension of: \"),\"\")&\nIF(AND(PenPayTag=INDEX(tabTarget,2),PaymentOpt=INDEX(tabPaymentOpt,1)),\"You have chosen to calculate an annual \"&LOWER(SelfSpouseTag)&\" added pension of \"&TEXT(PenPayAmt,\"£* #,##0.00\")&\" (at calculation date)  payable with a lump sum, the lump sum required for this is: \",\"\")&\nIF(AND(PenPayTag=INDEX(tabTarget,2),PaymentOpt=INDEX(tabPaymentOpt,2)),\"You have chosen to calculate an annual \"&LOWER(SelfSpouseTag)&\" added pension of \"&TEXT(PenPayAmt,\"£* #,##0.00\")&\n             IF(PaymentPeriod<>\"NPA\",\" (at calculation date) payable with monthly payments until the end of the scheme year. The monthly amount payable to achieve this is: \",\n                                                                      \" (at calculation date) payable with monthly payments to your Normal Pension Age, the monthly amount payable to achieve this is: \"),\"\")","v":""},{"$f":"AddPenRes","v":{"$error":"#REF!"}},"resCombinedStatement, resCombinedResult"]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Errors and Messages\"","v":"Added Pension - Errors and Messages"}]
[]
[]
[null,"Errors"]
[null,{"$f":"IF(bVersionError,\"Check version number.  \",\"\")","v":""},null,null,null,null,null,null,"_errVersion"]
[null,{"$f":"IF(bExpiryError,\"Tool expired on \"&TEXT(dayExpiry,\"dd/mm/yyyy\")&\" please contact MyCSP for a new copy.  \",\"\")","v":""},null,null,null,null,null,null,"_errExpiration"]
[null,{"$f":"IF(bSexError,\"Select a gender.  \",\"\")","v":"Select a gender.  "},null,null,null,null,null,null,"_errSex"]
[null,{"$f":"IF(bAgeLTNPA,\"Age greater than NPA.  \",\"\")","v":""},null,null,null,null,null,null,"errAgeLTNPA"]
[null,{"$f":"IF(bUIError,\"Check inputs.  \",\"\")","v":"Check inputs.  "},null,null,null,null,null,null,"errUIError"]
[null,{"$f":"IF(bHroomFail,\"You have selected an added pension that exceeds the limit of \"&TEXT(AddPenLim,\"£#,##\")&\".  If you are buying added pension using a compensation payment when leaving under Voluntary Exit, Voluntary Redundancy or Compulsory Redundancy terms then the limit doesn't apply to you. Please contact MyCSP for an estimate. \",\"\")","v":""},null,null,null,null,null,null,"errHroomFail"]
[]
[null,{"$f":"IF(bAgeLT17,\"Age at 1 April prior to date of contract must be greater than 17.  \",\"\")","v":"Age at 1 April prior to date of contract must be greater than 17.  "},null,null,null,null,null,null,"errAgeLT17"]
[]
[null,{"$f":"IF(bOverallError,errUIError&_errVersion&_errExpiration&_errSex&errAgeLTNPA&errAgeLT17&errHroomFail,msgNoErrors)","v":"Check inputs.  Select a gender.  Age at 1 April prior to date of contract must be greater than 17.  "},null,null,null,null,null,null,"_errOverall"]
[]
[null,"Messages"]
[null,"File not in correct location or filename incorrect, use correct version.  ",null,null,null,null,null,null,"_errLocation"]
[null,{"$f":"\"Security Classification: \"&SecurityClassification&\".  \"","v":"Security Classification: Unclassified.  "},null,null,null,null,null,null,"msgSecurityClassification"]
[null,{"$f":"\"\" &TEXT(NOW(),\"hh:mm,  dd mmm yyyy \")&\".  \"","v":"10:58,  17 Nov 2023 .  "},null,null,null,null,null,null,"msgPrint"]
[null,{"$f":"\"Version number : \"&(TEXT(VersionNumber,\"0.00\"))&\".  \"","v":"Version number : 1.00.  "},null,null,null,null,null,null,"msgVersionNumber"]
[null,{"$f":"\"Filename : \"&LEFT(CELL(\"filename\",strToolName),FIND(\"]\",CELL(\"filename\",strToolName))-1)","v":"Filename : \\\\MCCLPRDFSSM385\\XDrive\\Systems Support\\Application Team\\Calculators 2023 Updates\\2023 Updated\\AP_Calc\\Jon Hargreaves - AT\\for locking and returning\\AP Calcs\\[Alpha added pension calculator 2024.xlsm"},null,null,null,null,null,null,"msgFileName"]
[null,"PDF saved to : TBC",null,null,null,null,null,null,"msgPDFSaveLocation"]
[null,"You must complete this field",null,null,null,null,null,null,"msgCompulsoryField"]
[null,{"$f":"\"Tool expires on \"&TEXT(dayExpiry,\"dd/mm/yyyy\")&\".  \"","v":"Tool expires on 01/04/2099.  "},null,null,null,null,null,null,"msgExpiration"]
[null,"Error",null,null,null,null,null,null,"errError"]
[{"$f":"IF(bVersionError,\"Check Version Number.  \",\"\")","v":""},{"$f":"\"Table value not found\"","v":"Table value not found"},null,null,null,null,null,null,"errTableValueNotFound"]
[null,{"$f":"\"Error\"","v":"Error"},null,null,null,null,null,null,"_errOverallShort"]
[null,{"$f":"IF(ISERROR(EPAValuepc),\"\",IF(AND(bOverallError=FALSE,EPAValuepc>=1),\"If you take this EPA contract you will not be able to purchased added pension, see you employer for more details.\",\"\"))","v":""}]
[null,"No errors found",null,null,null,null,null,null,"msgNoErrors"]
[]
[]
[null,null,{"$f":"strToolName&\" - Tables\"","v":"Added Pension - Tables"}]
[]
[]
[null,"Tables used in calculations/sheets"]
[]
[null,"tabYesNo"]
[null,"Yes/No"]
[null,"Yes"]
[null,"No"]
[]
[null,"tabSex",null,"tabTarget"]
[null,"Sex",null,"Type of target, target a monthly/lumpsum PAYMENT or target PENSION"]
[null,"Male",null,"Payment"]
[null,"Female",null,"Pension"]
[]
[null,"tabSelfSpouse"]
[null,"Type of pension"]
[null,"Self"]
[null,"Self and dependants"]
[]
[null,"tabPaymentOpt"]
[null,"Type of payment"]
[null,{"$f":"IFERROR(IF(AND(_12MonthsService=\"Yes\",DoC>=DATE(2016,4,1)),\"Lump Sum\",\"\"),\"\")","v":""}]
[null,"Monthly"]
[]
[]
[]
[]
[null,null,{"$f":"strToolName&\" - Error Checking\"","v":"Added Pension - Error Checking"}]
[]
[]
[]
[]
[]
[null,"Error Checking"]
[]
[null,"AddedPensionFail",{"$f":"IFERROR(IF(HroomPass=\"No\",TRUE,FALSE),TRUE)","v":false},"bHroomFail"]
[null,"UI Error",{"$f":"IF(AND(erruiName=\"\",erruiDOB=\"\",erruiSex=\"\",erruiDOC=\"\",erruiPaymentOpt=\"\",erruiSelfSpouseTag=\"\",erruiPenPayTag=\"\",erruiPenPayAmt=\"\",errPaymentPeriod=\"\",errui_12MonthsService=\"\"),FALSE,TRUE)","v":true},"bUIError"]
[null,"Member Age < 17",{"$f":"IF(AND(uiDOC>=0,Age<17),TRUE,FALSE)","v":true},"bAgeLT17"]
[null,"Member Age < NPA",{"$f":"IF(AND(DoC>0,Age>=NPA),FALSE,FALSE)","v":false},"bAgeLTNPA"]
[null,"Expiration error",{"$f":"IF(dayExpiry<dayToday,TRUE,FALSE)","v":false},"bExpiryError"]
[null,"Sex Error (FALSE=OK)",{"$f":"'SPD Calculations_hide'!bSPDSexError","v":true},"bSexError"]
[null,"Version (FALSE=OK)",{"$f":"IF(MAX(tabVersionNumber)<>VersionNumber,TRUE,FALSE)","v":false},"bVersionError"]
[null,"Overall Error (FALSE=OK)",{"$f":"IF(OR(bHroomFail,bUIError,bAgeLT17,bAgeLTNPA,bExpiryError,bSexError,bVersionError),TRUE,FALSE)","v":true},"bOverallError"]

{"sheet":"SPD Calculations_hide","index":3,"n_rows":222,"n_cols":19,"rows_kept":222,"cut":false,"hidden":true,"merged":[[33,1,33,2],[1,2,1,6],[19,4,19,12],[20,4,20,12],[21,4,21,12],[22,4,22,15],[32,3,32,5]]}
[null,null,"SPD"]
[null,"Description","Calculates state pension date, state pension Age in Y, YM and age as string based on In force policy.  This is a MyCSP administration tool and is not for public use.  This page can be used in it's entirety as an SPA tool in other calculation  tools, however these must be kept up to date if this tool changes."]
[]
[]
[null,null,{"$f":"C1&\" -  Inputs\"","v":"SPD -  Inputs"}]
[]
[]
[null,"Inputs"]
[]
[null,"Date of Birth",{"$f":"DATE(YEAR(DoB), MONTH(DoB),DAY(DoB))","v":"00:00:00"},"dayDOB"]
[]
[null,"Sex",{"$f":"Gender","v":0},"strSex","Assume always Male as females will not have DOB < 5/12/53 in alpha"]
[]
[]
[null,null,{"$f":"C1&\" - Results\"","v":"SPD - Results"}]
[]
[]
[null,"Results",null,null,"Audit"]
[]
[null,"State Pension Age as string as per .Gov site",{"$f":"IFERROR(IF(OR(ISERROR(strSPA),bSPDOverallError),_errSPDOverall,strSPA),\"\")","v":""},"resstrSPA",{"$f":"msgPrint","v":"Calculation Date :10:58,  17 Nov 2023 .  "}]
[null,"State Pension  Date",{"$f":"IFERROR(IF(OR(bSPDOverallError,daySPD=0),_errSPDOverall,daySPD),\"\")","v":""},"resdaySPD"]
[null,"State Pension Age In Complete Years (YY)",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPA_CY)","v":{"$error":"#NAME?"}},"resdSPA_CY"]
[null,"State Pension Age In Complete Years and Months (YY+MM/12)",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPA_CYM)","v":{"$error":"#NAME?"}},"resdSPA_CYM","This SPA tool is based on the following in force Pensions Acts  95, 2007, 2011, 2014."]
[null,"SPA  in decimal",{"$f":"IF(bSPDOverallError,_errSPDOverall,dSPAdec)","v":{"$error":"#NAME?"}},"resdSPAdec"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,{"$f":"C1&\" - Calculations\"","v":"SPD - Calculations"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\nIF(DAY(DATE(YEAR(I29+0)-YEAR(dayDOB),MONTH(I29+0)-MONTH(dayDOB)+1,DAY(I29+0)-DAY(dayDOB)+1))-1=0,\n    0,\n     DAY(DATE(YEAR(I29+0)-YEAR(dayDOB),MONTH(I29+0)-MONTH(dayDOB)+1,DAY(I29+0)-DAY(dayDOB)+1))-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"daySPD","dSPA_CY","dSPA_CYM","strSPA","dSPAdec"]
[null,"The data in this table (columns B to F) has been taken from the inforce pension acts.  For more information about the source of data refer to the MyCSP SPA Calculator Tool sheet 'BackgroundStats'.",null,null,null,null,null,null,null,null,null,null,"Results lookups : ",null,{"$f":"MAX(O35:O182)","v":"00:00:00"},{"$f":"MAX(P35:P182)","v":0},{"$f":"MAX(Q35:Q182)","v":0},{"$f":"VLOOKUP(dSPA_CYM,Q35:R123,2,0)","v":{"$error":"#N/A"}},{"$f":"MAX(S35:S182)","v":0}]
[]
[null,null,null,"SPA is either defined as to an Age or Date, If age known complete age, if date known complete date.  All Ages YY+MM, where MM is m/12",null,null,null,"Intermediate Calculations",null,null,null,null,null,null,"Lookups"]
[null,"Period within which DOB falls",null,"Day pensionable age attained","Males SPA","Females SPA",null,"Use Date Or Age","State Pension Date (Calc)","SPA Year","SPA Month","SPA Day","SPA as string",null,"SPD Lookup","SPA Lookup Complete Years","SPA Lookup Complete Years And Months","SPA as String Lookup","SPA as decimal"]
[null,"1900-01-01","1950-04-05",null,65,60,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E35=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F35=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"N/A"},{"$f":"IF(H35=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E35,F35)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E35-INT(E35))*12,(F35-INT(F35))*12)),DAY(dayDOB)),D35)","v":"00:00:00"},{"$f":"YEAR(DATE(YEAR(I35+0)-YEAR(dayDOB),MONTH(I35+0)-MONTH(dayDOB)+1,DAY(I35+0)-DAY(dayDOB)+1))-1900","v":0},{"$f":"MONTH(DATE(YEAR(I35+0)-YEAR(dayDOB),MONTH(I35+0)-MONTH(dayDOB)+1,DAY(I35+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I35-DATE(YEAR(dayDOB)+J35,MONTH(dayDOB)+K35,DAY(dayDOB))-0","v":0},{"$f":"J35&\" Years \"&K35\n&\" Months \"&L35&\" Days\"","v":"0 Years 0 Months 0 Days"},null,{"$f":"IF(AND(dayDOB>=B35,dayDOB<=C35),I35,\"\")","v":""},{"$f":"IF(O35<>\"\",J35,\"\")","v":""},{"$f":"IF(O35<>\"\",J35+K35/12,\"\")","v":""},{"$f":"IF(P35<>\"\",M35,\"\")","v":""},{"$f":"IF(O35<>\"\",Q35+(L35/365),\"\")","v":""}]
[null,"1950-04-06","1950-05-05","2010-05-06",65,null,null,"N/A","2010-05-06",110,4,6,"110 Years 4 Months 6 Days",null,"","","","",{"$f":"IF(O36<>\"\",Q36+(L36/365),\"\")","v":""}]
[null,"1950-05-06","1950-06-05","2010-07-06",65,null,null,"N/A","2010-07-06",110,6,6,"110 Years 6 Months 6 Days",null,"","","","",""]
[null,"1950-06-06","1950-07-05","2010-09-06",65,null,null,"N/A","2010-09-06",110,8,6,"110 Years 8 Months 6 Days",null,"","","","",""]
[null,"1950-07-06","1950-08-05","2010-11-06",65,null,null,"N/A","2010-11-06",110,10,6,"110 Years 10 Months 6 Days",null,"","","","",""]
[null,"1950-08-06","1950-09-05","2011-01-06",65,null,null,"N/A","2011-01-06",111,0,6,"111 Years 0 Months 6 Days",null,"","","","",""]
[null,"1950-09-06","1950-10-05","2011-03-06",65,null,null,"N/A","2011-03-06",111,2,6,"111 Years 2 Months 6 Days",null,"","","","",""]
[null,"1950-10-06","1950-11-05","2011-05-06",65,null,null,"N/A","2011-05-06",111,4,6,"111 Years 4 Months 6 Days",null,"","","","",""]
[null,"1950-11-06","1950-12-05","2011-07-06",65,null,null,"N/A","2011-07-06",111,6,6,"111 Years 6 Months 6 Days",null,"","","","",""]
[null,"1950-12-06","1951-01-05","2011-09-06",65,null,null,"N/A","2011-09-06",111,8,6,"111 Years 8 Months 6 Days",null,"","","","",""]
[null,"1951-01-06","1951-02-05","2011-11-06",65,null,null,"N/A","2011-11-06",111,10,6,"111 Years 10 Months 6 Days",null,"","","","",""]
[null,"1951-02-06","1951-03-05","2012-01-06",65,null,null,"N/A","2012-01-06",112,0,6,"112 Years 0 Months 6 Days",null,"","","","",""]
[null,"1951-03-06","1951-04-05","2012-03-06",65,null,null,"N/A","2012-03-06",112,2,6,"112 Years 2 Months 6 Days",null,"","","","",""]
[null,"1951-04-06","1951-05-05","2012-05-06",65,null,null,"N/A","2012-05-06",112,4,6,"112 Years 4 Months 6 Days",null,"","","","",""]
[null,"1951-05-06","1951-06-05","2012-07-06",65,null,null,"N/A","2012-07-06",112,6,6,"112 Years 6 Months 6 Days",null,"","","","",""]
[null,"1951-06-06","1951-07-05","2012-09-06",65,null,null,"N/A","2012-09-06",112,8,6,"112 Years 8 Months 6 Days",null,"","","","",""]
[null,"1951-07-06","1951-08-05","2012-11-06",65,null,null,"N/A","2012-11-06",112,10,6,"112 Years 10 Months 6 Days",null,"","","","",""]
[null,"1951-08-06","1951-09-05","2013-01-06",65,null,null,"N/A","2013-01-06",113,0,6,"113 Years 0 Months 6 Days",null,"","","","",""]
[null,"1951-09-06","1951-10-05","2013-03-06",65,null,null,"N/A","2013-03-06",113,2,6,"113 Years 2 Months 6 Days",null,"","","","",""]
[null,"1951-10-06","1951-11-05","2013-05-06",65,null,null,"N/A","2013-05-06",113,4,6,"113 Years 4 Months 6 Days",null,"","","","",""]
[null,"1951-11-06","1951-12-05","2013-07-06",65,null,null,"N/A","2013-07-06",113,6,6,"113 Years 6 Months 6 Days",null,"","","","",""]
[null,"1951-12-06","1952-01-05","2013-09-06",65,null,null,"N/A","2013-09-06",113,8,6,"113 Years 8 Months 6 Days",null,"","","","",""]
[null,"1952-01-06","1952-02-05","2013-11-06",65,null,null,"N/A","2013-11-06",113,10,6,"113 Years 10 Months 6 Days",null,"","","","",""]
[null,"1952-02-06","1952-03-05","2014-01-06",65,null,null,"N/A","2014-01-06",114,0,6,"114 Years 0 Months 6 Days",null,"","","","",""]
[null,"1952-03-06","1952-04-05","2014-03-06",65,null,null,"N/A","2014-03-06",114,2,6,"114 Years 2 Months 6 Days",null,"","","","",""]
[null,"1952-04-06","1952-05-05","2014-05-06",65,null,null,"N/A","2014-05-06",114,4,6,"114 Years 4 Months 6 Days",null,"","","","",""]
[null,"1952-05-06","1952-06-05","2014-07-06",65,null,null,"N/A","2014-07-06",114,6,6,"114 Years 6 Months 6 Days",null,"","","","",""]
[null,"1952-06-06","1952-07-05","2014-09-06",65,null,null,"N/A","2014-09-06",114,8,6,"114 Years 8 Months 6 Days",null,"","","","",""]
[null,"1952-07-06","1952-08-05","2014-11-06",65,null,null,"N/A","2014-11-06",114,10,6,"114 Years 10 Months 6 Days",null,"","","","",""]
[null,"1952-08-06","1952-09-05","2015-01-06",65,null,null,"N/A","2015-01-06",115,0,6,"115 Years 0 Months 6 Days",null,"","","","",""]
[null,"1952-09-06","1952-10-05","2015-03-06",65,null,null,"N/A","2015-03-06",115,2,6,"115 Years 2 Months 6 Days",null,"","","","",""]
[null,"1952-10-06","1952-11-05","2015-05-06",65,null,null,"N/A","2015-05-06",115,4,6,"115 Years 4 Months 6 Days",null,"","","","",""]
[null,"1952-11-06","1952-12-05","2015-07-06",65,null,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E67=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F67=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"N/A"},{"$f":"IF(H67=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E67,F67)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E67-INT(E67))*12,(F67-INT(F67))*12)),DAY(dayDOB)),D67)","v":"2015-07-06"},{"$f":"YEAR(DATE(YEAR(I67+0)-YEAR(dayDOB),MONTH(I67+0)-MONTH(dayDOB)+1,DAY(I67+0)-DAY(dayDOB)+1))-1900","v":115},{"$f":"MONTH(DATE(YEAR(I67+0)-YEAR(dayDOB),MONTH(I67+0)-MONTH(dayDOB)+1,DAY(I67+0)-DAY(dayDOB)+1))-1","v":6},{"$f":"I67-DATE(YEAR(dayDOB)+J67,MONTH(dayDOB)+K67,DAY(dayDOB))-0","v":6},"115 Years 6 Months 6 Days",null,{"$f":"IF(AND(dayDOB>=B67,dayDOB<=C67),I67,\"\")","v":""},"","","",""]
[null,"1952-12-06","1953-01-05","2015-09-06",65,null,null,"N/A","2015-09-06",115,8,6,"115 Years 8 Months 6 Days",null,"","","","",""]
[null,"1953-01-06","1953-02-05","2015-11-06",65,null,null,"N/A","2015-11-06",115,10,6,"115 Years 10 Months 6 Days",null,"","","","",""]
[null,"1953-02-06","1953-03-05","2016-01-06",65,null,null,"N/A","2016-01-06",116,0,6,"116 Years 0 Months 6 Days",null,"","","","",""]
[null,"1953-03-06","1953-04-05","2016-03-06",65,null,null,"N/A","2016-03-06",116,2,6,"116 Years 2 Months 6 Days",null,"","","","",""]
[null,"1953-04-06","1953-05-05","2016-07-06",65,null,null,"N/A","2016-07-06",116,6,6,"116 Years 6 Months 6 Days",null,"","","","",""]
[null,"1953-05-06","1953-06-05","2016-11-06",65,null,null,"N/A","2016-11-06",116,10,6,"116 Years 10 Months 6 Days",null,"","","","",""]
[null,"1953-06-06","1953-07-05","2017-03-06",65,null,null,"N/A","2017-03-06",117,2,6,"117 Years 2 Months 6 Days",null,"","","","",""]
[null,"1953-07-06","1953-08-05","2017-07-06",65,null,null,"N/A","2017-07-06",117,6,6,"117 Years 6 Months 6 Days",null,"","","","",""]
[null,"1953-08-06","1953-09-05","2017-11-06",65,null,null,"N/A","2017-11-06",117,10,6,"117 Years 10 Months 6 Days",null,"","","","",""]
[null,"1953-09-06","1953-10-05","2018-03-06",65,null,null,"N/A","2018-03-06",118,2,6,"118 Years 2 Months 6 Days",null,"","","","",""]
[null,"1953-10-06","1953-11-05","2018-07-06",65,null,null,"N/A","2018-07-06",118,6,6,"118 Years 6 Months 6 Days",null,"","","","",""]
[null,"1953-11-06","1953-12-05","2018-11-06",65,null,"XXX","N/A","2018-11-06",118,10,6,"118 Years 10 Months 6 Days",null,"","","","",""]
[null,"1953-12-06","1954-01-05","2019-03-06",null,null,null,"N/A","2019-03-06",119,2,6,"119 Years 2 Months 6 Days",null,"","","","",""]
[null,"1954-01-06","1954-02-05","2019-05-06",null,null,null,"N/A","2019-05-06",119,4,6,"119 Years 4 Months 6 Days",null,"","","","",""]
[null,"1954-02-06","1954-03-05","2019-07-06",null,null,null,"N/A","2019-07-06",119,6,6,"119 Years 6 Months 6 Days",null,"","","","",""]
[null,"1954-03-06","1954-04-05","2019-09-06",null,null,null,"N/A","2019-09-06",119,8,6,"119 Years 8 Months 6 Days",null,"","","","",""]
[null,"1954-04-06","1954-05-05","2019-11-06",null,null,null,"N/A","2019-11-06",119,10,6,"119 Years 10 Months 6 Days",null,"","","","",""]
[null,"1954-05-06","1954-06-05","2020-01-06",null,null,null,"N/A","2020-01-06",120,0,6,"120 Years 0 Months 6 Days",null,"","","","",""]
[null,"1954-06-06","1954-07-05","2020-03-06",null,null,null,"N/A","2020-03-06",120,2,6,"120 Years 2 Months 6 Days",null,"","","","",""]
[null,"1954-07-06","1954-08-05","2020-05-06",null,null,null,"N/A","2020-05-06",120,4,6,"120 Years 4 Months 6 Days",null,"","","","",""]
[null,"1954-08-06","1954-09-05","2020-07-06",null,null,null,"N/A","2020-07-06",120,6,6,"120 Years 6 Months 6 Days",null,"","","","",""]
[null,"1954-09-06","1954-10-05","2020-09-06",null,null,null,"N/A","2020-09-06",120,8,6,"120 Years 8 Months 6 Days",null,"","","","",""]
[null,"1954-10-06","1960-04-05",null,66,66,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-04-06","1960-05-05",null,66.083333333333329,66.083333333333329,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-05-06","1960-06-05",null,66.166666666666671,66.166666666666671,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-06-06","1960-07-05",null,66.25,66.25,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-07-06","1960-07-30",null,66.3333333333333,66.333333333333329,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-07-31","1960-07-31","2026-11-30",null,null,null,"N/A","2026-11-30",66,4,0,"66 Years 4 Months 0 Days",null,"","","","",""]
[null,"1960-08-01","1960-08-05",null,66.333333333333329,66.333333333333329,null,"N/A","00:00:00",{"$f":"YEAR(DATE(YEAR(I96+0)-YEAR(dayDOB),MONTH(I96+0)-MONTH(dayDOB)+1,DAY(I96+0)-DAY(dayDOB)+1))-1900","v":0},{"$f":"MONTH(DATE(YEAR(I96+0)-YEAR(dayDOB),MONTH(I96+0)-MONTH(dayDOB)+1,DAY(I96+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I96-DATE(YEAR(dayDOB)+J96,MONTH(dayDOB)+K96,DAY(dayDOB))-0","v":0},"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-08-06","1960-09-05",null,66.416666666666671,66.416666666666671,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-09-06","1960-10-05",null,66.5,66.5,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-10-06","1960-11-05",null,66.583333333333329,66.583333333333329,null,{"$f":"IF(LEFT(LOWER(strSEX))=\"m\",IF(E99=\"\",\"Date\",\"Age\"), IF(LEFT(LOWER(strSEX))=\"f\",IF(F99=\"\",\"Date\",\"Age\"),\"N/A\"))","v":"N/A"},{"$f":"IF(H99=\"Age\",DATE(YEAR(dayDOB)+INT(IF(strSEX=\"Male\",E99,F99)),MONTH(dayDOB)+(IF(strSEX=\"Male\",(E99-INT(E99))*12,(F99-INT(F99))*12)),DAY(dayDOB)),D99)","v":"00:00:00"},0,0,0,{"$f":"J99&\" Years \"&K99\n&\" Months \"&L99&\" Days\"","v":"0 Years 0 Months 0 Days"},null,{"$f":"IF(AND(dayDOB>=B99,dayDOB<=C99),I99,\"\")","v":""},{"$f":"IF(O99<>\"\",J99,\"\")","v":""},{"$f":"IF(O99<>\"\",J99+K99/12,\"\")","v":""},{"$f":"IF(P99<>\"\",M99,\"\")","v":""},""]
[null,"1960-11-06","1960-12-05",null,66.666666666666671,66.666666666666671,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",{"$f":"IF(O100<>\"\",Q100+(L100/365),\"\")","v":""}]
[null,"1960-12-06","1960-12-30",null,66.75,66.75,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1960-12-31","1960-12-31","2027-09-30",null,null,null,"N/A","2027-09-30",66,9,0,"66 Years 9 Months 0 Days",null,"","","","",""]
[null,"1961-01-01","1961-01-05",null,66.75,66.75,null,"N/A","00:00:00",{"$f":"YEAR(DATE(YEAR(I103+0)-YEAR(dayDOB),MONTH(I103+0)-MONTH(dayDOB)+1,DAY(I103+0)-DAY(dayDOB)+1))-1900","v":0},{"$f":"MONTH(DATE(YEAR(I103+0)-YEAR(dayDOB),MONTH(I103+0)-MONTH(dayDOB)+1,DAY(I103+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I103-DATE(YEAR(dayDOB)+J103,MONTH(dayDOB)+K103,DAY(dayDOB))-0","v":0},"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-01-06","1961-01-30",null,66.833333333333329,66.833333333333329,null,"N/A","00:00:00",{"$f":"YEAR(DATE(YEAR(I104+0)-YEAR(dayDOB),MONTH(I104+0)-MONTH(dayDOB)+1,DAY(I104+0)-DAY(dayDOB)+1))-1900","v":0},{"$f":"MONTH(DATE(YEAR(I104+0)-YEAR(dayDOB),MONTH(I104+0)-MONTH(dayDOB)+1,DAY(I104+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I104-DATE(YEAR(dayDOB)+J104,MONTH(dayDOB)+K104,DAY(dayDOB))-0","v":0},"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-01-31","1961-01-31","2027-11-30",null,null,null,"N/A","2027-11-30",66,10,0,"66 Years 10 Months 0 Days",null,"","","","",""]
[null,"1961-02-01","1961-02-05",null,66.833333333333329,66.833333333333329,null,"N/A","00:00:00",{"$f":"YEAR(DATE(YEAR(I106+0)-YEAR(dayDOB),MONTH(I106+0)-MONTH(dayDOB)+1,DAY(I106+0)-DAY(dayDOB)+1))-1900","v":0},{"$f":"MONTH(DATE(YEAR(I106+0)-YEAR(dayDOB),MONTH(I106+0)-MONTH(dayDOB)+1,DAY(I106+0)-DAY(dayDOB)+1))-1","v":0},{"$f":"I106-DATE(YEAR(dayDOB)+J106,MONTH(dayDOB)+K106,DAY(dayDOB))-0","v":0},"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-02-06","1961-03-05",null,66.916666666666671,66.916666666666671,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-03-06","1961-04-05",null,67,67,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1961-04-06","1969-04-05",null,67,67,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1969-04-06","1977-04-05",null,67,67,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[null,"1977-04-06","1977-05-05","2044-05-06",null,null,null,"N/A","2044-05-06",144,4,6,"144 Years 4 Months 6 Days",null,"","","","",""]
[null,"1977-05-06","1977-06-05","2044-07-06",null,null,null,"N/A","2044-07-06",144,6,6,"144 Years 6 Months 6 Days",null,"","","","",""]
[null,"1977-06-06","1977-07-05","2044-09-06",null,null,null,"N/A","2044-09-06",144,8,6,"144 Years 8 Months 6 Days",null,"","","","",""]
[null,"1977-07-06","1977-08-05","2044-11-06",null,null,null,"N/A","2044-11-06",144,10,6,"144 Years 10 Months 6 Days",null,"","","","",""]
[null,"1977-08-06","1977-09-05","2045-01-06",null,null,null,"N/A","2045-01-06",145,0,6,"145 Years 0 Months 6 Days",null,"","","","",""]
[null,"1977-09-06","1977-10-05","2045-03-06",null,null,null,"N/A","2045-03-06",145,2,6,"145 Years 2 Months 6 Days",null,"","","","",""]
[null,"1977-10-06","1977-11-05","2045-05-06",null,null,null,"N/A","2045-05-06",145,4,6,"145 Years 4 Months 6 Days",null,"","","","",""]
[null,"1977-11-06","1977-12-05","2045-07-06",null,null,null,"N/A","2045-07-06",145,6,6,"145 Years 6 Months 6 Days",null,"","","","",""]
[null,"1977-12-06","1978-01-05","2045-09-06",null,null,null,"N/A","2045-09-06",145,8,6,"145 Years 8 Months 6 Days",null,"","","","",""]
[null,"1978-01-06","1978-02-05","2045-11-06",null,null,null,"N/A","2045-11-06",145,10,6,"145 Years 10 Months 6 Days",null,"","","","",""]
[null,"1978-02-06","1978-03-05","2046-01-06",null,null,null,"N/A","2046-01-06",146,0,6,"146 Years 0 Months 6 Days",null,"","","","",""]
[null,"1978-03-06","1978-04-05","2046-03-06",null,null,null,"N/A","2046-03-06",146,2,6,"146 Years 2 Months 6 Days",null,"","","","",""]
[null,"1978-04-06","2999-12-31",null,68,68,null,"N/A","00:00:00",0,0,0,"0 Years 0 Months 0 Days",null,"","","","",""]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(H126=\"Age\",DATE(YEAR(dayDOB)+IF(strSEX=\"Male\",E126,F126),MONTH(dayDOB),DAY(dayDOB)),D126)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H158=\"Age\",DATE(YEAR(dayDOB)+IF(strSEX=\"Male\",E158,F158),MONTH(dayDOB),DAY(dayDOB)),D158)","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SPD - Errors and Messages"]
[]
[]
[null,"Error and other messages"]
[null,"General"]
[null,{"$f":"IF(bSPDOverallError,\"SPA ERROR :\"&errSex,\"\")","v":{"$error":"#NAME?"}},null,null,null,null,null,null,"_errSPDOverall"]
[null,{"$f":"\"Calculation Date :\" &TEXT(NOW(),\"hh:mm,  dd mmm yyyy \")&\".  \"","v":"Calculation Date :10:58,  17 Nov 2023 .  "},null,null,null,null,null,null,"msgPrint"]
[null,{"$f":"IF(bSPDSexError,\"Sex Incorrect\",\"\")","v":"Sex Incorrect"},null,null,null,null,null,null,"_errSex"]
[]
[]
[null,null,{"$f":"$C$1&\" - Error Checking\"","v":"SPD - Error Checking"}]
[]
[]
[null,"Error Checking"]
[]
[null,"Sex Error (FALSE=OK)",{"$f":"IF(OR(LEFT(LOWER(strSEX))=\"m\",LEFT(LOWER(strSEX))=\"f\"),FALSE,TRUE)","v":true},"bSPDSexError"]
[null,"Overall Error (FALSE=OK)",{"$f":"IF(OR(bSPDSexError),TRUE,FALSE)","v":true},"bSPDOverallError"]

{"sheet":"Add Pension Factors","index":4,"n_rows":154,"n_cols":26,"rows_kept":154,"cut":false,"hidden":true,"merged":[[76,21,76,23],[76,10,78,10],[76,11,76,13],[76,15,78,15],[76,16,76,18],[76,20,78,20],[10,1,12,1],[10,2,10,4],[10,6,12,6],[10,7,10,9],[76,5,78,5],[76,6,76,8],[10,11,12,11],[10,12,10,14],[10,16,12,16],[10,17,10,19],[3,2,3,6],[4,2,4,6]]}
[null,null,{"$f":"strToolName&\" - Additional Pension Factors\"","v":"Added Pension - Additional Pension Factors"}]
[]
[]
[null,"Description","Added pension Factors, based on GAD advice in documents 'EPAAndEEPASpecification working document v4 21112014.pdf', 'Copy of epa headroom factors 21112014.xlsx'"]
[null,"Schemes","Alpha only"]
[]
[]
[]
[]
[null,"Added Pension Lump Sum Factor - NPA 65",null,null,null,null,"Added Pension Lump Sum Factor - NPA 66",null,null,null,null,"Added Pension Lump Sum Factor - NPA 67",null,null,null,null,"Added Pension Lump Sum Factor - NPA 68",null,null,null,null,"Revaluation Factors"]
[null,"Age","Lump Sum",null,null,null,"Age","Lump Sum",null,null,null,"Age","Lump Sum",null,null,null,"Age","Lump Sum",null,null,null,"Number of 1 Aprils","Revaluation Factor"]
[null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,0,1]
[null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,1,1.02]
[null,16,3.54,3.54,3.84,null,16,3.33,3.33,3.62,null,16,3.13,3.13,3.41,null,16,2.93,2.93,3.21,null,2,1.04]
[null,17,3.67,3.67,3.98,null,17,3.45,3.45,3.75,null,17,3.23,3.23,3.54,null,17,3.04,3.04,3.33,null,3,1.06]
[null,18,3.79,3.79,4.13,null,18,3.56,3.56,3.9,null,18,3.35,3.35,3.67,null,18,3.14,3.14,3.46,null,4,1.08]
[null,19,3.93,3.93,4.29,null,19,3.69,3.69,4.04,null,19,3.46,3.46,3.81,null,19,3.25,3.25,3.59,null,5,1.1000000000000001]
[null,20,4.0599999999999996,4.0599999999999996,4.43,null,20,3.82,3.82,4.18,null,20,3.58,3.58,3.94,null,20,3.36,3.36,3.72,null,6,1.1299999999999999]
[null,21,4.2,4.2,4.59,null,21,3.95,3.95,4.33,null,21,3.71,3.71,4.08,null,21,3.48,3.48,3.84,null,7,1.1499999999999999]
[null,22,4.3499999999999996,4.3499999999999996,4.75,null,22,4.08,4.08,4.4800000000000004,null,22,3.83,3.83,4.22,null,22,3.6,3.6,3.98,null,8,1.17]
[null,23,4.5,4.5,4.91,null,23,4.2300000000000004,4.2300000000000004,4.63,null,23,3.97,3.97,4.37,null,23,3.72,3.72,4.1100000000000003,null,9,1.2]
[null,24,4.66,4.66,5.08,null,24,4.37,4.37,4.79,null,24,4.0999999999999996,4.0999999999999996,4.5199999999999996,null,24,3.85,3.85,4.26,null,10,1.22]
[null,25,4.82,4.82,5.26,null,25,4.5199999999999996,4.5199999999999996,4.96,null,25,4.24,4.24,4.67,null,25,3.98,3.98,4.4000000000000004,null,11,1.24]
[null,26,4.9800000000000004,4.9800000000000004,5.44,null,26,4.68,4.68,5.13,null,26,4.3899999999999997,4.3899999999999997,4.83,null,26,4.12,4.12,4.55,null,12,1.27]
[null,27,5.16,5.16,5.63,null,27,4.84,4.84,5.31,null,27,4.54,4.54,5,null,27,4.26,4.26,4.71,null,13,1.29]
[null,28,5.34,5.34,5.83,null,28,5.01,5.01,5.49,null,28,4.7,4.7,5.17,null,28,4.41,4.41,4.87,null,14,1.32]
[null,29,5.52,5.52,6.03,null,29,5.18,5.18,5.68,null,29,4.8600000000000003,4.8600000000000003,5.35,null,29,4.5599999999999996,4.5599999999999996,5.04,null,15,1.35]
[null,30,5.71,5.71,6.24,null,30,5.36,5.36,5.88,null,30,5.03,5.03,5.54,null,30,4.71,4.71,5.21,null,16,1.37]
[null,31,5.91,5.91,6.45,null,31,5.55,5.55,6.08,null,31,5.2,5.2,5.73,null,31,4.88,4.88,5.39,null,17,1.4]
[null,32,6.11,6.11,6.68,null,32,5.74,5.74,6.29,null,32,5.38,5.38,5.92,null,32,5.04,5.04,5.58,null,18,1.43]
[null,33,6.32,6.32,6.91,null,33,5.93,5.93,6.5,null,33,5.56,5.56,6.13,null,33,5.21,5.21,5.77,null,19,1.46]
[null,34,6.54,6.54,7.14,null,34,6.14,6.14,6.73,null,34,5.75,5.75,6.33,null,34,5.39,5.39,5.96,null,20,1.49]
[null,35,6.76,6.76,7.39,null,35,6.34,6.34,6.96,null,35,5.95,5.95,6.55,null,35,5.57,5.57,6.16,null,21,1.52]
[null,36,6.99,6.99,7.64,null,36,6.56,6.56,7.19,null,36,6.15,6.15,6.77,null,36,5.76,5.76,6.37,null,22,1.55]
[null,37,7.23,7.23,7.9,null,37,6.78,6.78,7.44,null,37,6.36,6.36,7,null,37,5.95,5.95,6.59,null,23,1.58]
[null,38,7.48,7.48,8.17,null,38,7.01,7.01,7.69,null,38,6.57,6.57,7.24,null,38,6.15,6.15,6.81,null,24,1.61]
[null,39,7.73,7.73,8.44,null,39,7.25,7.25,7.95,null,39,6.79,6.79,7.48,null,39,6.36,6.36,7.03,null,25,1.64]
[null,40,8,8,8.73,null,40,7.5,7.5,8.2200000000000006,null,40,7.02,7.02,7.73,null,40,6.57,6.57,7.27,null,26,1.67]
[null,41,8.27,8.27,9.0299999999999994,null,41,7.75,7.75,8.49,null,41,7.26,7.26,7.99,null,41,6.79,6.79,7.51,null,27,1.71]
[null,42,8.5500000000000007,8.5500000000000007,9.33,null,42,8.01,8.01,8.7799999999999994,null,42,7.5,7.5,8.26,null,42,7.02,7.02,7.76,null,28,1.74]
[null,43,8.84,8.84,9.65,null,43,8.2799999999999994,8.2799999999999994,9.08,null,43,7.75,7.75,8.5299999999999994,null,43,7.26,7.26,8.02,null,29,1.78]
[null,44,9.14,9.14,9.9700000000000006,null,44,8.56,8.56,9.3800000000000008,null,44,8.02,8.02,8.82,null,44,7.5,7.5,8.2899999999999991,null,30,1.81]
[null,45,9.4499999999999993,9.4499999999999993,10.31,null,45,8.85,8.85,9.6999999999999993,null,45,8.2799999999999994,8.2799999999999994,9.11,null,45,7.75,7.75,8.56,null,31,1.85]
[null,46,9.77,9.77,10.66,null,46,9.15,9.15,10.02,null,46,8.56,8.56,9.42,null,46,8.01,8.01,8.85,null,32,1.88]
[null,47,10.1,10.1,11.02,null,47,9.4600000000000009,9.4600000000000009,10.36,null,47,8.85,8.85,9.73,null,47,8.27,8.27,9.14,null,33,1.92]
[null,48,10.44,10.44,11.39,null,48,9.7799999999999994,9.7799999999999994,10.7,null,48,9.14,9.14,10.050000000000001,null,48,8.5500000000000007,8.5500000000000007,9.44,null,34,1.96]
[null,49,10.8,10.8,11.77,null,49,10.1,10.1,11.06,null,49,9.4499999999999993,9.4499999999999993,10.39,null,49,8.83,8.83,9.75,null,35,2]
[null,50,11.16,11.16,12.16,null,50,10.44,10.44,11.43,null,50,9.76,9.76,10.73,null,50,9.1199999999999992,9.1199999999999992,10.07,null,36,2.04]
[null,51,11.54,11.54,12.57,null,51,10.8,10.8,11.81,null,51,10.09,10.09,11.08,null,51,9.42,9.42,10.4,null,37,2.08]
[null,52,11.93,11.93,12.99,null,52,11.16,11.16,12.2,null,52,10.43,10.43,11.45,null,52,9.73,9.73,10.74,null,38,2.12]
[null,53,12.34,12.34,13.43,null,53,11.53,11.53,12.61,null,53,10.77,10.77,11.83,null,53,10.06,10.06,11.09,null,39,2.16]
[null,54,12.76,12.76,13.88,null,54,11.92,11.92,13.03,null,54,11.13,11.13,12.21,null,54,10.39,10.39,11.45,null,40,2.21]
[null,55,13.19,13.19,14.35,null,55,12.33,12.33,13.46,null,55,11.51,11.51,12.62,null,55,10.73,10.73,11.82,null,41,2.25]
[null,56,13.65,13.65,14.83,null,56,12.75,12.75,13.91,null,56,11.89,11.89,13.03,null,56,11.09,11.09,12.21,null,42,2.2999999999999998]
[null,57,14.12,14.12,15.34,null,57,13.18,13.18,14.38,null,57,12.3,12.3,13.47,null,57,11.46,11.46,12.61,null,43,2.34]
[null,58,14.61,14.61,15.86,null,58,13.64,13.64,14.86,null,58,12.71,12.71,13.91,null,58,11.84,11.84,13.02,null,44,2.39]
[null,59,15.12,15.12,16.399999999999999,null,59,14.11,14.11,15.36,null,59,13.15,13.15,14.38,null,59,12.24,12.24,13.45,null,45,2.44]
[null,60,15.66,15.66,16.97,null,60,14.6,14.6,15.89,null,60,13.6,13.6,14.86,null,60,12.66,12.66,13.89,null,46,2.4900000000000002]
[null,61,16.22,16.22,17.57,null,61,15.12,15.12,16.440000000000001,null,61,14.08,14.08,15.37,null,61,13.09,13.09,14.36,null,47,2.54]
[null,62,16.809999999999999,16.809999999999999,18.190000000000001,null,62,15.66,15.66,17.010000000000002,null,62,14.57,14.57,15.9,null,62,13.55,13.55,14.84,null,48,2.59]
[null,63,17.440000000000001,17.440000000000001,18.84,null,63,16.23,16.23,17.61,null,63,15.1,15.1,16.45,null,63,14.03,14.03,15.35,null,49,2.64]
[null,64,18.09,18.09,19.53,null,64,16.84,16.84,18.25,null,64,15.65,15.65,17.03,null,64,14.53,14.53,15.89,null,50,2.69]
[null,65,18.12,18.12,19.579999999999998,null,65,17.48,17.48,18.920000000000002,null,65,16.239999999999998,16.239999999999998,17.649999999999999,null,65,15.07,15.07,16.45]
[null,66,17.5,17.5,18.95,null,66,17.5,17.5,18.95,null,66,16.86,16.86,18.3,null,66,15.63,15.63,17.05]
[null,67,16.87,16.87,18.32,null,67,16.87,16.87,18.32,null,67,16.87,16.87,18.32,null,67,16.239999999999998,16.239999999999998,17.68]
[null,68,16.239999999999998,16.239999999999998,17.690000000000001,null,68,16.239999999999998,16.239999999999998,17.690000000000001,null,68,16.239999999999998,16.239999999999998,17.690000000000001,null,68,16.239999999999998,16.239999999999998,17.690000000000001]
[null,69,15.61,15.61,17.059999999999999,null,69,15.61,15.61,17.059999999999999,null,69,15.61,15.61,17.059999999999999,null,69,15.61,15.61,17.059999999999999]
[null,70,14.99,14.99,16.43,null,70,14.99,14.99,16.43,null,70,14.99,14.99,16.43,null,70,14.99,14.99,16.43]
[null,71,14.37,14.37,15.8,null,71,14.37,14.37,15.8,null,71,14.37,14.37,15.8,null,71,14.37,14.37,15.8]
[null,72,13.76,13.76,15.18,null,72,13.76,13.76,15.18,null,72,13.76,13.76,15.18,null,72,13.76,13.76,15.18]
[null,73,13.15,13.15,14.56,null,73,13.15,13.15,14.56,null,73,13.15,13.15,14.56,null,73,13.15,13.15,14.56]
[null,74,12.56,12.56,13.95,null,74,12.56,12.56,13.95,null,74,12.56,12.56,13.95,null,74,12.56,12.56,13.95]
[null,75,12.26,12.26,13.65,null,75,12.26,12.26,13.65,null,75,12.26,12.26,13.65,null,75,12.26,12.26,13.65]
[]
[null,"ADDPENLIMTAB",null,null,null,"Periodical NPA65",null,null,null,null,"Periodical NPA66",null,null,null,null,"Periodical NPA67",null,null,null,null,"Periodical NPA68",null,null,null,null,"tabAllowablePeriods"]
[null,"Added Pension Limits Periodic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allowable Periods or payment"]
[null,2015,6500,null,null,"Age","Periodical Contribution",null,null,null,"Age","Periodical Contribution",null,null,null,"Age","Periodical Contribution",null,null,null,"Age","Periodical Contribution",null,null,null,1]
[null,2016,6500,null,null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,null,"Male","Female","Unisex",null,{"$f":"IFERROR(\n     IF(Z77+1<=NPAAprils,Z77+1,IF(Z77+1<=NPAAprils+1,\"NPA\",\"\")),\"\")","v":""}]
[null,2017,6600,null,null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,null,"Member's pension factor","Member's pension factor","Member + spouse ",null,""]
[null,2018,6800,null,null,16,3.61,3.61,3.92,null,16,3.4,3.4,3.69,null,16,3.19,3.19,3.48,null,16,2.99,2.99,3.27,null,""]
[null,2019,7000,null,null,17,3.74,3.74,4.0599999999999996,null,17,3.52,3.52,3.82,null,17,3.29,3.29,3.61,null,17,3.1,3.1,3.4,null,""]
[null,2020,7200,null,null,18,3.87,3.87,4.21,null,18,3.63,3.63,3.98,null,18,3.42,3.42,3.74,null,18,3.2,3.2,3.53,null,""]
[null,2021,7300,null,null,19,4.01,4.01,4.38,null,19,3.76,3.76,4.12,null,19,3.53,3.53,3.89,null,19,3.31,3.31,3.66,null,""]
[null,2022,7600,null,null,20,4.1399999999999997,4.1399999999999997,4.5199999999999996,null,20,3.9,3.9,4.26,null,20,3.65,3.65,4.0199999999999996,null,20,3.43,3.43,3.79,null,""]
[null,2023,8400,null,null,21,4.28,4.28,4.68,null,21,4.03,4.03,4.42,null,21,3.78,3.78,4.16,null,21,3.55,3.55,3.92,null,""]
[null,2024,9000,null,null,22,4.4400000000000004,4.4400000000000004,4.84,null,22,4.16,4.16,4.57,null,22,3.91,3.91,4.3,null,22,3.67,3.67,4.0599999999999996,null,""]
[null,2025,9000,null,null,23,4.59,4.59,5.01,null,23,4.3099999999999996,4.3099999999999996,4.72,null,23,4.05,4.05,4.46,null,23,3.79,3.79,4.1900000000000004,null,""]
[null,2026,9000,null,null,24,4.75,4.75,5.18,null,24,4.46,4.46,4.8899999999999997,null,24,4.18,4.18,4.6100000000000003,null,24,3.93,3.93,4.3499999999999996,null,""]
[null,2027,9000,null,null,25,4.92,4.92,5.37,null,25,4.6100000000000003,4.6100000000000003,5.0599999999999996,null,25,4.32,4.32,4.76,null,25,4.0599999999999996,4.0599999999999996,4.49,null,""]
[null,2028,9000,null,null,26,5.08,5.08,5.55,null,26,4.7699999999999996,4.7699999999999996,5.23,null,26,4.4800000000000004,4.4800000000000004,4.93,null,26,4.2,4.2,4.6399999999999997,null,""]
[null,2029,9000,null,null,27,5.26,5.26,5.74,null,27,4.9400000000000004,4.9400000000000004,5.42,null,27,4.63,4.63,5.0999999999999996,null,27,4.3499999999999996,4.3499999999999996,4.8,null,""]
[null,2030,9000,null,null,28,5.45,5.45,5.95,null,28,5.1100000000000003,5.1100000000000003,5.6,null,28,4.79,4.79,5.27,null,28,4.5,4.5,4.97,null,""]
[null,2031,9000,null,null,29,5.63,5.63,6.15,null,29,5.28,5.28,5.79,null,29,4.96,4.96,5.46,null,29,4.6500000000000004,4.6500000000000004,5.14,null,""]
[null,2032,9000,null,null,30,5.82,5.82,6.36,null,30,5.47,5.47,6,null,30,5.13,5.13,5.65,null,30,4.8,4.8,5.31,null,""]
[null,2033,9000,null,null,31,6.03,6.03,6.58,null,31,5.66,5.66,6.2,null,31,5.3,5.3,5.84,null,31,4.9800000000000004,4.9800000000000004,5.5,null,""]
[null,2034,9000,null,null,32,6.23,6.23,6.81,null,32,5.85,5.85,6.42,null,32,5.49,5.49,6.04,null,32,5.14,5.14,5.69,null,""]
[null,2035,9000,null,null,33,6.45,6.45,7.05,null,33,6.05,6.05,6.63,null,33,5.67,5.67,6.25,null,33,5.31,5.31,5.89,null,""]
[null,2036,9000,null,null,34,6.67,6.67,7.28,null,34,6.26,6.26,6.86,null,34,5.86,5.86,6.46,null,34,5.5,5.5,6.08,null,""]
[null,2037,9000,null,null,35,6.9,6.9,7.54,null,35,6.47,6.47,7.1,null,35,6.07,6.07,6.68,null,35,5.68,5.68,6.28,null,""]
[null,2038,9000,null,null,36,7.13,7.13,7.79,null,36,6.69,6.69,7.33,null,36,6.27,6.27,6.91,null,36,5.88,5.88,6.5,null,""]
[null,2039,9000,null,null,37,7.37,7.37,8.06,null,37,6.92,6.92,7.59,null,37,6.49,6.49,7.14,null,37,6.07,6.07,6.72,null,""]
[null,2040,9000,null,null,38,7.63,7.63,8.33,null,38,7.15,7.15,7.84,null,38,6.7,6.7,7.38,null,38,6.27,6.27,6.95,null,""]
[null,2041,9000,null,null,39,7.88,7.88,8.61,null,39,7.39,7.39,8.11,null,39,6.93,6.93,7.63,null,39,6.49,6.49,7.17,null,""]
[null,2042,9000,null,null,40,8.16,8.16,8.9,null,40,7.65,7.65,8.3800000000000008,null,40,7.16,7.16,7.88,null,40,6.7,6.7,7.42,null,""]
[null,2043,9000,null,null,41,8.44,8.44,9.2100000000000009,null,41,7.9,7.9,8.66,null,41,7.41,7.41,8.15,null,41,6.93,6.93,7.66,null,""]
[null,2044,9000,null,null,42,8.7200000000000006,8.7200000000000006,9.52,null,42,8.17,8.17,8.9600000000000009,null,42,7.65,7.65,8.43,null,42,7.16,7.16,7.92,null,""]
[null,2045,9000,null,null,43,9.02,9.02,9.84,null,43,8.4499999999999993,8.4499999999999993,9.26,null,43,7.9,7.9,8.6999999999999993,null,43,7.41,7.41,8.18,null,""]
[null,2046,9000,null,null,44,9.32,9.32,10.17,null,44,8.73,8.73,9.57,null,44,8.18,8.18,9,null,44,7.65,7.65,8.4600000000000009,null,""]
[null,2047,9000,null,null,45,9.64,9.64,10.52,null,45,9.0299999999999994,9.0299999999999994,9.89,null,45,8.4499999999999993,8.4499999999999993,9.2899999999999991,null,45,7.9,7.9,8.73,null,""]
[null,2048,9000,null,null,46,9.9700000000000006,9.9700000000000006,10.87,null,46,9.33,9.33,10.220000000000001,null,46,8.73,8.73,9.61,null,46,8.17,8.17,9.0299999999999994,null,{"$f":"IFERROR(\n     IF(Z109+1<=NPAAprils,Z109+1,IF(Z109+1<=NPAAprils+1,\"NPA\",\"\")),\"\")","v":""}]
[null,2049,9000,null,null,47,10.3,10.3,11.24,null,47,9.65,9.65,10.57,null,47,9.0299999999999994,9.0299999999999994,9.92,null,47,8.44,8.44,9.32,null,""]
[null,2050,9000,null,null,48,10.65,10.65,11.62,null,48,9.98,9.98,10.91,null,48,9.32,9.32,10.25,null,48,8.7200000000000006,8.7200000000000006,9.6300000000000008,null,""]
[null,2051,9000,null,null,49,11.02,11.02,12.01,null,49,10.3,10.3,11.28,null,49,9.64,9.64,10.6,null,49,9.01,9.01,9.94,null,""]
[null,2052,9000,null,null,50,11.38,11.38,12.4,null,50,10.65,10.65,11.66,null,50,9.9600000000000009,9.9600000000000009,10.94,null,50,9.3000000000000007,9.3000000000000007,10.27,null,""]
[null,null,null,null,null,51,11.77,11.77,12.82,null,51,11.02,11.02,12.05,null,51,10.29,10.29,11.3,null,51,9.61,9.61,10.61,null,""]
[null,"Added Pension Limits Lump",null,null,null,52,12.17,12.17,13.25,null,52,11.38,11.38,12.44,null,52,10.64,10.64,11.68,null,52,9.92,9.92,10.95,null,""]
[null,2015,6500,null,null,53,12.59,12.59,13.7,null,53,11.76,11.76,12.86,null,53,10.99,10.99,12.07,null,53,10.26,10.26,11.31,null,""]
[null,2016,6500,null,null,54,13.02,13.02,14.16,null,54,12.16,12.16,13.29,null,54,11.35,11.35,12.45,null,54,10.6,10.6,11.68,null,""]
[null,2017,6600,null,null,55,13.45,13.45,14.64,null,55,12.58,12.58,13.73,null,55,11.74,11.74,12.87,null,55,10.94,10.94,12.06,null,""]
[null,2018,6800,null,null,56,13.92,13.92,15.13,null,56,13,13,14.19,null,56,12.13,12.13,13.29,null,56,11.31,11.31,12.45,null,""]
[null,2019,7000,null,null,57,14.4,14.4,15.65,null,57,13.44,13.44,14.67,null,57,12.55,12.55,13.74,null,57,11.69,11.69,12.86,null,""]
[null,2020,7200,null,null,58,14.9,14.9,16.18,null,58,13.91,13.91,15.16,null,58,12.96,12.96,14.19,null,58,12.08,12.08,13.28,null,""]
[null,2021,7000,null,null,59,15.42,15.42,16.73,null,59,14.39,14.39,15.67,null,59,13.41,13.41,14.67,null,59,12.48,12.48,13.72,null,""]
[null,2022,7300,null,null,60,15.97,15.97,17.309999999999999,null,60,14.89,14.89,16.21,null,60,13.87,13.87,15.16,null,60,12.91,12.91,14.17,null,""]
[null,2023,8400,null,null,61,16.54,16.54,17.920000000000002,null,61,15.42,15.42,16.77,null,61,14.36,14.36,15.68,null,61,13.35,13.35,14.65,null,""]
[null,2024,9000,null,null,62,17.149999999999999,17.149999999999999,18.55,null,62,15.97,15.97,17.350000000000001,null,62,14.86,14.86,16.22,null,62,13.82,13.82,15.14,null,""]
[null,2025,9000,null,null,63,17.79,17.79,19.22,null,63,16.55,16.55,17.96,null,63,15.4,15.4,16.78,null,63,14.31,14.31,15.66,null,""]
[null,2026,9000,null,null,64,18.45,18.45,19.920000000000002,null,64,17.18,17.18,18.61,null,64,15.96,15.96,17.37,null,64,14.82,14.82,16.21,null,""]
[null,2027,9000,null,null,65,18.48,18.48,19.97,null,65,17.829999999999998,17.829999999999998,19.3,null,65,16.559999999999999,16.559999999999999,18,null,65,15.37,15.37,16.78]
[null,2028,9000,null,null,66,17.850000000000001,17.850000000000001,19.329999999999998,null,66,17.850000000000001,17.850000000000001,19.329999999999998,null,66,17.2,17.2,18.670000000000002,null,66,15.94,15.94,17.39]
[null,2029,9000,null,null,67,17.21,17.21,18.690000000000001,null,67,17.21,17.21,18.690000000000001,null,67,17.21,17.21,18.690000000000001,null,67,16.559999999999999,16.559999999999999,18.03]
[null,2030,9000,null,null,68,16.559999999999999,16.559999999999999,18.04,null,68,16.559999999999999,16.559999999999999,18.04,null,68,16.559999999999999,16.559999999999999,18.04,null,68,16.559999999999999,16.559999999999999,18.04]
[null,2031,9000,null,null,69,15.92,15.92,17.399999999999999,null,69,15.92,15.92,17.399999999999999,null,69,15.92,15.92,17.399999999999999,null,69,15.92,15.92,17.399999999999999]
[null,2032,9000,null,null,70,15.29,15.29,16.760000000000002,null,70,15.29,15.29,16.760000000000002,null,70,15.29,15.29,16.760000000000002,null,70,15.29,15.29,16.760000000000002]
[null,2033,9000,null,null,71,14.66,14.66,16.12,null,71,14.66,14.66,16.12,null,71,14.66,14.66,16.12,null,71,14.66,14.66,16.12]
[null,2034,9000,null,null,72,14.04,14.04,15.48,null,72,14.04,14.04,15.48,null,72,14.04,14.04,15.48,null,72,14.04,14.04,15.48]
[null,2035,9000,null,null,73,13.41,13.41,14.85,null,73,13.41,13.41,14.85,null,73,13.41,13.41,14.85,null,73,13.41,13.41,14.85]
[null,2036,9000,null,null,74,12.81,12.81,14.23,null,74,12.81,12.81,14.23,null,74,12.81,12.81,14.23,null,74,12.81,12.81,14.23]
[null,2037,9000,null,null,75,12.51,12.51,13.92,null,75,12.51,12.51,13.92,null,75,12.51,12.51,13.92,null,75,12.51,12.51,13.92]
[null,2038,9000,null,null,null,null,null,null,null,null,"ADDPENNPA66CTAB"]
[null,2039,9000]
[null,2040,9000]
[null,2041,9000]
[null,2042,9000]
[null,2043,9000]
[null,2044,9000]
[null,2045,9000]
[null,2046,9000]
[null,2047,9000]
[null,2048,9000]
[null,2049,9000]
[null,2050,9000]
[null,2051,9000]
[null,2052,9000]