{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["AppForm","Calculator","Codes","Factors","LumpSumPrint1","RegularContsPrint1","GuidanceNotes"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"AppForm","index":0,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[45,3,45,8],[56,3,56,10],[28,5,28,6],[29,5,29,6],[31,1,31,15],[33,1,33,15],[37,1,37,15],[43,4,43,5],[46,6,46,14],[51,2,52,4],[51,1,52,1],[17,6,17,14],[17,1,17,2],[19,1,19,2],[26,1,26,15],[27,5,27,6],[25,1,25,15],[9,6,9,14],[10,7,10,14],[11,1,11,4],[13,6,13,14],[15,6,15,14],[15,1,15,2],[9,1,9,4],[8,6,8,14],[5,1,5,4],[1,1,1,15],[4,1,4,2],[7,1,7,4],[7,6,7,14]]}
[]
[null,"APPLICATION FORM FOR ADDED PENSION"]
[]
[null,"SECTION 1 - PERSONAL DETAILS"]
[null,"National Insurance No"]
[null,{"$f":"Calculator!D14","v":0}]
[null,"Surname",null,null,null,null,"Contact Address"]
[null,{"$f":"Calculator!D4","v":0},null,null,null,null,{"$f":"Calculator!D7","v":0}]
[null,"Former surname (if applicable)",null,null,null,null,{"$f":"Calculator!D8","v":0}]
[null,{"$f":"Calculator!D5","v":0},null,null,null,null,{"$f":"Calculator!D9","v":0}]
[null,"Forenames (in full)",null,null,null,null,"Postcode",{"$f":"Calculator!D10","v":0}]
[null,{"$f":"Calculator!D6","v":0}]
[null,"Title",null,null,null,null,"Home telephone number (including STD code)"]
[null,{"$f":"Calculator!G4","v":0},null,null,null,null,{"$f":"Calculator!D11","v":0}]
[null,"If other, please specify",null,null,null,null,"Mobile telephone number"]
[null,{"$f":"IF(Calculator!G4=\"Other\",Calculator!H6,\"N/A\")","v":"N/A"},null,null,null,null,{"$f":"Calculator!D12","v":0}]
[null,"Date of birth",null,null,null,null,"Email address"]
[null,{"$f":"Calculator!D15","v":"00:00:00"},null,null,null,null,{"$f":"Calculator!D13","v":0}]
[null,"Gender"]
[null,{"$f":"Calculator!D16","v":0}]
[]
[]
[null,"SECTION 2 - OPTIONS"]
[null,{"$f":"\"Maximum limit is £\"&Codes!F33&\" added pension for tax year 2017/2018\"","v":"Maximum limit is £6500 added pension for tax year 2017/2018"}]
[null,"Option 1 - Lump Sum Payment"]
[null,"Payment by LS is available to those who have been in a continuous period of pensionable service for at least 12 month"]
[]
[null,"I wish to purchase added pension of:",null,null,null,{"$f":"IF(Calculator!J5<>\"Lump Sum\",\"N/A\",Calculator!D28)","v":"N/A"}]
[null,"By single payment of:",null,null,null,{"$f":"IF(Calculator!J5<>\"Lump Sum\",\"N/A\",Calculator!D26)","v":"N/A"}]
[null,"Calculation date:",null,null,null,{"$f":"IF(Calculator!J5<>\"Lump Sum\",\"N/A\",Codes!F4)","v":"N/A"}]
[]
[null,"Payment must be received within 1 month of the stated calculation date for the estimate to be valid."]
[]
[null,"Please return the completed form to: Police and Fire Team, SPPA , 7 Tweedside Park, Tweedbank, Galashiels, TD1 3TE along with the estimate. Please DO NOT send payment at this time."]
[]
[]
[null,"Option 2 - Monthly Contributions"]
[null,"Please return the completed form to: Police and Fire Team, SPPA , 7 Tweedside Park, Tweedbank, Galashiels, TD1 3TE along with the estimate. The SPPA will review the application and then contact your Payroll team to arrange payment of additional contributions."]
[null,"I wish to pay the monthly instalments shown in the attached schedule. I understand that if"]
[null,"the application is processed after this start date my monthly contributions or final Additional"]
[null,"Pension amount will be adjusted."]
[null,{"$f":"IF(Calculator!D36=Codes!A8,\"I wish to pay monthly contributions of £\"&Calculator!D40&\" as shown in the attached estimate\",IF(Calculator!D36=Codes!A9,\"I wish to pay monthly contributions worth \"&Calculator!G38&\"% of my salary as shown in the attached estimate\"))","v":false}]
[]
[null,"From",{"$f":"IF(Calculator!J5<>\"Regular Contributions\",\"\",Codes!I3)","v":""},"To",{"$f":"IF(Calculator!J5<>\"Regular Contributions\",\"\",Codes!I7)","v":""}]
[]
[null,"Pay reference Number"]
[]
[]
[]
[null,"SECTION 3 - DECLARATION"]
[]
[null,"Signed"]
[null,null,null,null,null,null,"Date",null,null,"/",null,null,"/"]

{"sheet":"Calculator","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,6],[14,6,17,7],[55,2,55,7],[42,2,42,3],[3,3,3,4],[4,3,4,4],[37,4,37,5],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4]]}
[]
[null,"Police 2015 Additional Pension Benefit Cost Calculator"]
[null,null,"Member Details"]
[null,null,"Surname",null,null,"Title",null,null,null,null,"Mr","Male"]
[null,null,"Former Surname (if applicable)",null,null,null,null,null,null,null,"Dr","Female"]
[null,null,"Forenames (in full)",null,null,null,"Please specify",null,null,null,"Ms"]
[null,null,"Contact Address",null,null,null,null,null,null,null,"Mrs"]
[null,null,null,null,null,null,null,null,null,null,"Miss"]
[null,null,null,null,null,null,null,null,null,null,"Other"]
[null,null,"Postcode"]
[null,null,"Home telephone number"]
[null,null,"Mobile telephone number"]
[null,null,"Email address"]
[null,null,"National insurance number"]
[null,null,"Date of Birth ",null,null,null,{"$f":"IF(Codes!P21=60, \"You may only pay by lump sum. You must be 2 years from NPA to pay by monthly contributions\",\"\")","v":""},null,null,null,"Earliest DOB",{"$f":"Codes!B17","v":"1960-01-24"},"Latest DOB",{"$f":"Codes!B18","v":"2002-01-23T12:00:00"}]
[null,null,"Gender"]
[]
[null,null,"How would you like to pay for you additional pension? "]
[]
[]
[null,null,"Type of additional pension "]
[]
[null,null,"Lump Sum Payments"]
[null,null,"Statement date (if blank, will use today's date) ",null,"i",null,null,null,null,null,"Earliest calc date",{"$f":"Codes!F23","v":"2015-04-01"},"Latest calc date",{"$f":"Codes!F24","v":"1959-12-30"}]
[]
[null,null,"Lump sum payment amount ",null,null,null,null,null,null,null,"Minimum paymeent",0,"Maximum payment",{"$f":"Codes!F32","v":0}]
[]
[null,null,"It will buy me this much additional pension per year:-",{"$f":"IF(OR(D26=\"\",ISERROR(Codes!F14)),\"\",Codes!F14)","v":""}]
[]
[null,null,"Periodic Payments"]
[]
[null,null,"Start date of periodic payments (if blank, will use today's date)",null,"i",null,null,null,null,null,"Earliest start date",{"$f":"Codes!I72","v":"2015-04-01"},"Latest start date",{"$f":"Codes!I73","v":"1959-03-31"}]
[]
[null,null,{"$f":"\"End date of periodic payments (if blank, will quote to end of scheme year 31 March \"&YEAR(Codes!I5)&\")\"","v":"End date of periodic payments (if blank, will quote to end of scheme year 31 March 2020)"},null,null,null,null,null,null,null,"Earliest end date",{"$f":"Codes!I69","v":"1959-03-31"},"latest end date",{"$f":"Codes!I70","v":"1959-12-31"}]
[]
[null,null,"Would you like to pay a regular fixed sum or a percentage of your salary?",null,"i"]
[]
[null,null,"Salary",null,"Percentage to pay"]
[]
[null,null,"What level of monthly contributions would you like to pay?"]
[]
[null,null,"Monthly contribution based on current salary",{"$f":"IF(D36=Codes!A9,(Calculator!D38*(Calculator!G38/100))/12,IF(Calculator!D36=Codes!A8,Calculator!D40,\"\"))","v":""},null,null,null,null,null,null,"Smallest contribution",null,"Largest contribution"]
[null,null,{"$f":"IF(OR(D45=\"\",D45<=6500),\"\",\"*Your added pension balance must not increase by more than £6500 in a scheme year. Please review your contribution period or monthly contribution amount.\")","v":""}]
[null,null,{"$f":"\"In \"&YEAR(Codes!I5)-1&\"/\"&YEAR(Codes!I5)&\" the monthly payments will buy this much additional pension\"","v":"In 2019/2020 the monthly payments will buy this much additional pension"},{"$f":"IF(OR(D42=\"\",ISERROR(Codes!S21)),\"\",Codes!S21)","v":""}]
[null,null,"Over the contribution period this much will be added to the additional pension balance",{"$f":"IF(OR(D42=\"\",ISERROR(RegularContsPrint1!E68)),\"\",RegularContsPrint1!E68)","v":""}]

{"sheet":"Codes","index":2,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":true,"merged":[[9,3,14,3],[2,4,2,5],[9,6,14,6]]}
["Drop-down options","User data",null,null,null,"Lump Sum",null,"Monthly conts"]
["Self only AP","DOB",{"$f":"Calculator!D15","v":"00:00:00"}]
["All beneficieries AP","Gender",{"$f":"Calculator!D16","v":0},null,"Calculating X",null,null,"Start date of periodic payments",{"$f":"IF(Calculator!D32=\"\",TODAY(),Calculator!D32)","v":"2020-01-23"}]
[null,"Form of AP",{"$f":"Calculator!D21","v":0},null,"Calculation date (today if blank)",{"$f":"IF(Calculator!D24=\"\",TODAY(),Calculator!D24)","v":"2020-01-23"},null,"31 March that yr",{"$f":"DATE(YEAR(I3),3,31)","v":"2020-03-31"}]
["Male",null,null,null,"1 April that year",{"$f":"DATE(YEAR(F4),4,1)","v":"2020-04-01"},null,"End of scheme year",{"$f":"IF(I4<I3,DATE(YEAR(I4)+1,3,31),DATE(YEAR(I4),3,31))","v":"2020-03-31"}]
["Female","Normal retirement date",{"$f":"DATE(YEAR(Calculator!D15)+60,MONTH(Calculator!D15),DAY(Calculator!D15))","v":"1959-12-31"},null,"Start of scheme year",{"$f":"IF(F5<F4,DATE(YEAR(F5),4,1),DATE(YEAR(F5)-1,4,1))","v":"2019-04-01"}]
[null,"31 March that yr",{"$f":"DATE(YEAR(C6),3,31)","v":"1959-03-31"},null,"Age at start of scheme year X=",{"$f":"DATEDIF(Calculator!$D$15,Codes!F6,\"y\")","v":119},null,"Contributions end date",{"$f":"IF(Calculator!$D$34=\"\",$I$5,Calculator!$D$34)","v":"2020-03-31"}]
["Fixed amount","31 March before NPA",{"$f":"IF(C7>C6,DATE(YEAR(C7)-1,3,31),DATE(YEAR(C7),3,31))","v":"1959-03-31"},null,null,null,null,"31 March that yr",{"$f":"DATE(YEAR(I7),3,31)","v":"2020-03-31"}]
["Percentage of salary","1 April before NPA",{"$f":"IF(Calculator!D15=\"\",\"\",C8+1)","v":""},null,"F= ",{"$f":"IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(F7,Factors!$A$10:C$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(F7,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(F7,Factors!$E$10:$F$49,2,FALSE))))","v":false},null,"End of scheme year",{"$f":"IF(I8<I7,DATE(YEAR(I8)+1,3,31),DATE(YEAR(I8),3,31))","v":"2020-03-31"}]
[null,"Current age",{"$f":"IF(Calculator!D15=\"\",0,ROUNDDOWN((TODAY()-Calculator!D15)/365.25,0))","v":0}]
[null,null,null,null,"How much additional pension will this lump sum by me?",null,null,"1 April start year",{"$f":"DATE(YEAR(I3),4,1)","v":"2020-04-01"}," "]
[null,null,null,null,"Lump sum payment=",{"$f":"Calculator!D26","v":0},null,"Start of scheme year",{"$f":"IF(OR(I11<I3,I11=I3),DATE(YEAR(I11),4,1),DATE(YEAR(I11)-1,4,1))","v":"2019-04-01"}]
["x=","Members age last birthday at start of scheme year",null,null,"AP credit = ","LS/F",null,"Year 1 X=",{"$f":"DATEDIF(Calculator!$D$15,Codes!I12,\"y\")","v":119}]
["F= ","Added pension factor at age x",null,null,"=",{"$f":"F12/F9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(I7),MONTH(I7),DAY(I3))","v":"2020-03-23"}]
["data limits",null,null,null,"How much will it cost me to buy this much AP credit?",null,null,"Last payment month (apr=4)",{"$f":"IF(I15>I7,MONTH(I15)-1,MONTH(I15))","v":3}]
["Earliest DOB (60 years ago tomorrow)",{"$f":"TODAY()-(60*365.25)+1","v":"1960-01-24"},null,null,"AP Credit",{"$f":"F14","v":{"$error":"#DIV/0!"}},null,"Last payment month (apr=1)",{"$f":"IF(OR(I16=0,I16=1,I16=2,I16=3),I16+9,I16-3)","v":12}]
["latest DOB (18 years ago today)",{"$f":"TODAY()-(18*365.25)+1","v":"2002-01-23T12:00:00"},null,null,"Lump sum payment =","AP credit x F",null,"First payment month (apr=4)",{"$f":"MONTH(I3)","v":1}]
[null,null,null,null,"=",{"$f":"F17*F9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Year","First payment month (April = 1)","Last payment month (march = 3)","Last payment month (march = 12)","Start of scheme year","End of scheme year","No of monthly payments","x","F","Payments over scheme year","AP Credit = payments over year / F"]
["Drop down lists",null,null,null,"Lump Sum data limits",null,null,{"$f":"YEAR(Codes!I5)-1&\" / \"&YEAR(Codes!I5)","v":"2019 / 2020"},1,{"$f":"IF(OR(I18=1,I18=2,I18=3),I18+9,I18-3)","v":10},{"$f":"IF(OR(H21=\"\",H22=\"\"),\"\",IF(N21<=I$7,3,MONTH(I$7)))","v":""},{"$f":"IF(H21=\"\",\"\",IF(H22=\"\",I$17,IF(OR(K21=1,K21=2,K21=3),K21+9,K21-3)))","v":12},{"$f":"DATE(YEAR(N21)-1,4,1)","v":"2019-04-01"},{"$f":"I5","v":"2020-03-31"},{"$f":"IF(H21=\"\",\"\",L21-J21+1)","v":3},{"$f":"IF(Calculator!$D$15=\"\",0,I13)","v":0},{"$f":"IF(P21>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P21,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P21,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P21,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H21=\"\",\"\",Calculator!$D$42*O21)","v":{"$error":"#VALUE!"}},{"$f":"IF(H21=\"\",\"\",R21/Q21)","v":{"$error":"#VALUE!"}}]
["Male",null,null,null,null,null,null,{"$f":"IF(M22<>\"\",YEAR(Codes!$I$5)+(I22-2)&\" / \"&YEAR(Codes!$I$5)+(I22-1),\"\")","v":""},{"$f":"IF(M22=\"\",\"\",I21+1)","v":""},{"$f":"IF(H22=\"\",\"\",1)","v":""},"","",{"$f":"IF(M21=\"\",\"\",IF(DATE(YEAR(M21)+1,4,1)<I$7,DATE(YEAR(M21)+1,4,1),\"\"))","v":""},{"$f":"IF(H22=\"\",\"\",IF(DATE(YEAR(N21)+1,3,31)<=I$9,DATE(YEAR(N21)+1,3,31),\"\"))","v":""},"",{"$f":"IF(H22=\"\",\"\",P21+1)","v":""},{"$f":"IF(P22>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P22,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P22,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P22,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H22=\"\",\"\",Calculator!$D$42*O22)","v":""},{"$f":"IF(H22=\"\",\"\",R22/Q22)","v":""}]
["Female",null,null,null,"Earliest calc date allowed",{"$f":"IF(F30>F28,F30,F28)","v":"2015-04-01"},null,{"$f":"IF(M23<>\"\",YEAR(Codes!$I$5)+(I23-2)&\" / \"&YEAR(Codes!$I$5)+(I23-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P23>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P23,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P23,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P23,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H23=\"\",\"\",Calculator!$D$42*O23)","v":""},{"$f":"IF(H23=\"\",\"\",R23/Q23)","v":""}]
[null,null,null,null,"Latest calc date allowed",{"$f":"F29","v":"1959-12-30"},null,{"$f":"IF(M24<>\"\",YEAR(Codes!$I$5)+(I24-2)&\" / \"&YEAR(Codes!$I$5)+(I24-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P24>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P24,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P24,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P24,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H24=\"\",\"\",Calculator!$D$42*O24)","v":""},""]
["Mr",null,null,null,null,null,null,{"$f":"IF(M25<>\"\",YEAR(Codes!$I$5)+(I25-2)&\" / \"&YEAR(Codes!$I$5)+(I25-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P25>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P25,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P25,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P25,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H25=\"\",\"\",Calculator!$D$42*O25)","v":""},""]
["Dr",null,null,null,"today",{"$f":"TODAY()","v":"2020-01-23"},null,{"$f":"IF(M26<>\"\",YEAR(Codes!$I$5)+(I26-2)&\" / \"&YEAR(Codes!$I$5)+(I26-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P26>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P26,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P26,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P26,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H26=\"\",\"\",Calculator!$D$42*O26)","v":""},""]
["Ms",null,null,null,"10 years from today",{"$f":"DATE(YEAR(F26)+10,MONTH(F26),DAY(F26))","v":"2030-01-23"},null,{"$f":"IF(M27<>\"\",YEAR(Codes!$I$5)+(I27-2)&\" / \"&YEAR(Codes!$I$5)+(I27-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P27>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P27,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P27,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P27,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H27=\"\",\"\",Calculator!$D$42*O27)","v":""},""]
["Mrs",null,null,null,"Date members is 18",{"$f":"DATE(YEAR(Calculator!D15)+18,MONTH(Calculator!D15),DAY(Calculator!D15))","v":"1917-12-31"},null,{"$f":"IF(M28<>\"\",YEAR(Codes!$I$5)+(I28-2)&\" / \"&YEAR(Codes!$I$5)+(I28-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P28>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P28,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P28,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P28,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H28=\"\",\"\",Calculator!$D$42*O28)","v":""},""]
["Miss",null,null,null,"Day before member is 60",{"$f":"DATE(YEAR(Calculator!D15)+60,MONTH(Calculator!D15),DAY(Calculator!D15)-1)","v":"1959-12-30"},null,{"$f":"IF(M29<>\"\",YEAR(Codes!$I$5)+(I29-2)&\" / \"&YEAR(Codes!$I$5)+(I29-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P29>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P29,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P29,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P29,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H29=\"\",\"\",Calculator!$D$42*O29)","v":""},""]
["Other",null,null,null,"Scheme start date","2015-04-01",null,{"$f":"IF(M30<>\"\",YEAR(Codes!$I$5)+(I30-2)&\" / \"&YEAR(Codes!$I$5)+(I30-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P30>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P30,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P30,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P30,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H30=\"\",\"\",Calculator!$D$42*O30)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M31<>\"\",YEAR(Codes!$I$5)+(I31-2)&\" / \"&YEAR(Codes!$I$5)+(I31-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P31>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P31,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P31,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P31,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H31=\"\",\"\",Calculator!$D$42*O31)","v":""},""]
[null,null,null,null,"Maximum payment",{"$f":"IF(ISERROR(F9),\"\",6500*F9)","v":0},null,{"$f":"IF(M32<>\"\",YEAR(Codes!$I$5)+(I32-2)&\" / \"&YEAR(Codes!$I$5)+(I32-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P32>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P32,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P32,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P32,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H32=\"\",\"\",Calculator!$D$42*O32)","v":""},""]
[null,null,null,null,"Maximum AP",6500,null,{"$f":"IF(M33<>\"\",YEAR(Codes!$I$5)+(I33-2)&\" / \"&YEAR(Codes!$I$5)+(I33-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P33>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P33,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P33,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P33,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H33=\"\",\"\",Calculator!$D$42*O33)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M34<>\"\",YEAR(Codes!$I$5)+(I34-2)&\" / \"&YEAR(Codes!$I$5)+(I34-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P34>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P34,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P34,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P34,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H34=\"\",\"\",Calculator!$D$42*O34)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M35<>\"\",YEAR(Codes!$I$5)+(I35-2)&\" / \"&YEAR(Codes!$I$5)+(I35-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P35>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P35,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P35,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P35,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H35=\"\",\"\",Calculator!$D$42*O35)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M36<>\"\",YEAR(Codes!$I$5)+(I36-2)&\" / \"&YEAR(Codes!$I$5)+(I36-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P36>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P36,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P36,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P36,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H36=\"\",\"\",Calculator!$D$42*O36)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M37<>\"\",YEAR(Codes!$I$5)+(I37-2)&\" / \"&YEAR(Codes!$I$5)+(I37-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P37>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P37,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P37,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P37,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H37=\"\",\"\",Calculator!$D$42*O37)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M38<>\"\",YEAR(Codes!$I$5)+(I38-2)&\" / \"&YEAR(Codes!$I$5)+(I38-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P38>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P38,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P38,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P38,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H38=\"\",\"\",Calculator!$D$42*O38)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M39<>\"\",YEAR(Codes!$I$5)+(I39-2)&\" / \"&YEAR(Codes!$I$5)+(I39-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P39>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P39,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P39,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P39,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H39=\"\",\"\",Calculator!$D$42*O39)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M40<>\"\",YEAR(Codes!$I$5)+(I40-2)&\" / \"&YEAR(Codes!$I$5)+(I40-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P40>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P40,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P40,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P40,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H40=\"\",\"\",Calculator!$D$42*O40)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M41<>\"\",YEAR(Codes!$I$5)+(I41-2)&\" / \"&YEAR(Codes!$I$5)+(I41-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P41>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P41,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P41,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P41,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H41=\"\",\"\",Calculator!$D$42*O41)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M42<>\"\",YEAR(Codes!$I$5)+(I42-2)&\" / \"&YEAR(Codes!$I$5)+(I42-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P42>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P42,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P42,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P42,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H42=\"\",\"\",Calculator!$D$42*O42)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M43<>\"\",YEAR(Codes!$I$5)+(I43-2)&\" / \"&YEAR(Codes!$I$5)+(I43-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P43>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P43,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P43,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P43,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H43=\"\",\"\",Calculator!$D$42*O43)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M44<>\"\",YEAR(Codes!$I$5)+(I44-2)&\" / \"&YEAR(Codes!$I$5)+(I44-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P44>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P44,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P44,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P44,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H44=\"\",\"\",Calculator!$D$42*O44)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M45<>\"\",YEAR(Codes!$I$5)+(I45-2)&\" / \"&YEAR(Codes!$I$5)+(I45-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P45>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P45,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P45,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P45,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H45=\"\",\"\",Calculator!$D$42*O45)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M46<>\"\",YEAR(Codes!$I$5)+(I46-2)&\" / \"&YEAR(Codes!$I$5)+(I46-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P46>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P46,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P46,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P46,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H46=\"\",\"\",Calculator!$D$42*O46)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M47<>\"\",YEAR(Codes!$I$5)+(I47-2)&\" / \"&YEAR(Codes!$I$5)+(I47-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P47>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P47,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P47,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P47,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H47=\"\",\"\",Calculator!$D$42*O47)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M48<>\"\",YEAR(Codes!$I$5)+(I48-2)&\" / \"&YEAR(Codes!$I$5)+(I48-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P48>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P48,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P48,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P48,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H48=\"\",\"\",Calculator!$D$42*O48)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M49<>\"\",YEAR(Codes!$I$5)+(I49-2)&\" / \"&YEAR(Codes!$I$5)+(I49-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P49>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P49,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P49,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P49,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H49=\"\",\"\",Calculator!$D$42*O49)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M50<>\"\",YEAR(Codes!$I$5)+(I50-2)&\" / \"&YEAR(Codes!$I$5)+(I50-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P50>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P50,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P50,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P50,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H50=\"\",\"\",Calculator!$D$42*O50)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M51<>\"\",YEAR(Codes!$I$5)+(I51-2)&\" / \"&YEAR(Codes!$I$5)+(I51-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P51>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P51,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P51,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P51,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H51=\"\",\"\",Calculator!$D$42*O51)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M52<>\"\",YEAR(Codes!$I$5)+(I52-2)&\" / \"&YEAR(Codes!$I$5)+(I52-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P52>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P52,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P52,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P52,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H52=\"\",\"\",Calculator!$D$42*O52)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M53<>\"\",YEAR(Codes!$I$5)+(I53-2)&\" / \"&YEAR(Codes!$I$5)+(I53-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P53>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P53,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P53,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P53,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H53=\"\",\"\",Calculator!$D$42*O53)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M54<>\"\",YEAR(Codes!$I$5)+(I54-2)&\" / \"&YEAR(Codes!$I$5)+(I54-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P54>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P54,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P54,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P54,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H54=\"\",\"\",Calculator!$D$42*O54)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M55<>\"\",YEAR(Codes!$I$5)+(I55-2)&\" / \"&YEAR(Codes!$I$5)+(I55-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P55>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P55,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P55,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P55,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H55=\"\",\"\",Calculator!$D$42*O55)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M56<>\"\",YEAR(Codes!$I$5)+(I56-2)&\" / \"&YEAR(Codes!$I$5)+(I56-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P56>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P56,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P56,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P56,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H56=\"\",\"\",Calculator!$D$42*O56)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M57<>\"\",YEAR(Codes!$I$5)+(I57-2)&\" / \"&YEAR(Codes!$I$5)+(I57-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P57>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P57,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P57,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P57,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H57=\"\",\"\",Calculator!$D$42*O57)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M58<>\"\",YEAR(Codes!$I$5)+(I58-2)&\" / \"&YEAR(Codes!$I$5)+(I58-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P58>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P58,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P58,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P58,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H58=\"\",\"\",Calculator!$D$42*O58)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M59<>\"\",YEAR(Codes!$I$5)+(I59-2)&\" / \"&YEAR(Codes!$I$5)+(I59-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P59>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P59,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P59,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P59,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H59=\"\",\"\",Calculator!$D$42*O59)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M60<>\"\",YEAR(Codes!$I$5)+(I60-2)&\" / \"&YEAR(Codes!$I$5)+(I60-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P60>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P60,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P60,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P60,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H60=\"\",\"\",Calculator!$D$42*O60)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M61<>\"\",YEAR(Codes!$I$5)+(I61-2)&\" / \"&YEAR(Codes!$I$5)+(I61-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P61>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P61,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P61,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P61,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H61=\"\",\"\",Calculator!$D$42*O61)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M62<>\"\",YEAR(Codes!$I$5)+(I62-2)&\" / \"&YEAR(Codes!$I$5)+(I62-1),\"\")","v":""},"","","","","","","","",{"$f":"IF(P62>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P62,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P62,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P62,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H62=\"\",\"\",Calculator!$D$42*O62)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M63<>\"\",YEAR(Codes!$I$5)+(I63-2)&\" / \"&YEAR(Codes!$I$5)+(I63-1),\"\")","v":""},"","",{"$f":"IF(H63=\"\",\"\",IF(N63<=I$7,3,MONTH(I$7)))","v":""},{"$f":"IF(H63=\"\",\"\",IF(H64=\"\",J48,IF(OR(K63=1,K63=2,K63=3),K63+9,K63-3)))","v":""},"","","","",{"$f":"IF(P63>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P63,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P63,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P63,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H63=\"\",\"\",Calculator!$D$42*O63)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M64<>\"\",YEAR(Codes!$I$5)+(I64-2)&\" / \"&YEAR(Codes!$I$5)+(I64-1),\"\")","v":""},"","",{"$f":"IF(H64=\"\",\"\",IF(N64<=I$7,3,MONTH(I$7)))","v":""},{"$f":"IF(H64=\"\",\"\",IF(H65=\"\",J49,IF(OR(K64=1,K64=2,K64=3),K64+9,K64-3)))","v":""},"","","","",{"$f":"IF(P64>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P64,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P64,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P64,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H64=\"\",\"\",Calculator!$D$42*O64)","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IF(M65<>\"\",YEAR(Codes!$I$5)+(I65-2)&\" / \"&YEAR(Codes!$I$5)+(I65-1),\"\")","v":""},"","",{"$f":"IF(H65=\"\",\"\",IF(N65<=I$7,3,MONTH(I$7)))","v":""},{"$f":"IF(H65=\"\",\"\",IF(H66=\"\",J50,IF(OR(K65=1,K65=2,K65=3),K65+9,K65-3)))","v":""},"","","","",{"$f":"IF(P65>59,\"\",IF(AND($C$4=$A$2,$C$3=$A$5),VLOOKUP(P65,Factors!$A$10:D$49,2,FALSE),IF(AND($C$4=$A$2,$C$3=$A$6),VLOOKUP(P65,Factors!$A$10:$C$49,3,FALSE),IF($C$4=$A$3,VLOOKUP(P65,Factors!$E$10:$F$49,2,FALSE),\"\"))))","v":""},{"$f":"IF(H65=\"\",\"\",Calculator!$D$42*O65)","v":""},""]
[]
[null,null,null,null,null,null,null,"Monthly contributions data limits"]
[]
[null,null,null,null,null,null,null,"Earliest contribution end date",{"$f":"IF(($I$3+1)>=I73,I73,$I$3+1)","v":"1959-03-31"}]
[null,null,null,null,null,null,null,"Latest contributions end date",{"$f":"DATE(YEAR(Calculator!D15)+60,MONTH(Calculator!D15),DAY(Calculator!D15))","v":"1959-12-31"}]
[]
[null,null,null,null,null,null,null,"Earliest start date allowed",{"$f":"IF(I79>I77,I79,I77)","v":"2015-04-01"}]
[null,null,null,null,null,null,null,"Latest start date allowed",{"$f":"$C$8","v":"1959-03-31"}]
[]
[null,null,null,null,null,null,null,"today",{"$f":"TODAY()","v":"2020-01-23"}]
[null,null,null,null,null,null,null,"10 years from today",{"$f":"DATE(YEAR(I75)+10,MONTH(I75),DAY(I75))","v":"2030-01-23"}]
[null,null,null,null,null,null,null,"Date members is 18",{"$f":"DATE(YEAR(Calculator!D15)+18,MONTH(Calculator!D15),DAY(Calculator!D15))","v":"1917-12-31"}]
[null,null,null,null,null,null,null,"Day before member is 60",{"$f":"I70-1","v":"1959-12-30"}]
[null,null,null,null,null,null,null,"Scheme start date","2015-04-01"]

{"sheet":"Factors","index":3,"n_rows":49,"n_cols":6,"rows_kept":49,"cut":false,"hidden":true,"merged":[[6,0,7,0],[6,1,6,2],[7,1,7,2],[6,4,7,4]]}
["Government Actuary's Department"]
["Police Pension Scheme (Scotland) 2015 – Purchase of added pension"]
["Published 3 March 2015 by Samantha Watts"]
[]
["Table S-AP: Factors for self only AP",null,null,null,"Table B-AP: Factors for all beneficiaries AP"]
[]
["Age last birthday at start of scheme year","Added Pension",null,null,"Age last birthday at start of scheme year","Added Pension"]
[null,"Self only ",null,null,null,"All beneficiaries"]
[null,"Male","Female",null,null,"Male and Female"]
[20,8.5299999999999994,9.41,null,20,9.6999999999999993]
[21,8.7200000000000006,9.61,null,21,9.91]
[22,8.91,9.82,null,22,10.130000000000001]
[23,9.1,10.039999999999999,null,23,10.35]
[24,9.3000000000000007,10.26,null,24,10.58]
[25,9.5,10.48,null,25,10.81]
[26,9.7100000000000009,10.7,null,26,11.04]
[27,9.92,10.92,null,27,11.28]
[28,10.130000000000001,11.15,null,28,11.52]
[29,10.35,11.37,null,29,11.77]
[30,10.58,11.6,null,30,12.02]
[31,10.81,11.83,null,31,12.27]
[32,11.03,12.07,null,32,12.53]
[33,11.27,12.31,null,33,12.78]
[34,11.5,12.55,null,34,13.05]
[35,11.74,12.79,null,35,13.31]
[36,11.99,13.04,null,36,13.58]
[37,12.23,13.3,null,37,13.86]
[38,12.48,13.55,null,38,14.14]
[39,12.74,13.81,null,39,14.42]
[40,13,14.06,null,40,14.7]
[41,13.27,14.31,null,41,14.99]
[42,13.53,14.56,null,42,15.28]
[43,13.8,14.81,null,43,15.56]
[44,14.06,15.05,null,44,15.85]
[45,14.33,15.3,null,45,16.13]
[46,14.6,15.55,null,46,16.41]
[47,14.87,15.8,null,47,16.7]
[48,15.15,16.059999999999999,null,48,16.989999999999998]
[49,15.43,16.32,null,49,17.29]
[50,15.72,16.59,null,50,17.600000000000001]
[51,16.010000000000002,16.88,null,51,17.91]
[52,16.32,17.18,null,52,18.23]
[53,16.64,17.489999999999998,null,53,18.57]
[54,16.98,17.82,null,54,18.920000000000002]
[55,17.329999999999998,18.170000000000002,null,55,19.29]
[56,17.7,18.55,null,56,19.68]
[57,18.100000000000001,18.95,null,57,20.100000000000001]
[58,18.52,19.39,null,58,20.53]
[59,18.96,19.850000000000001,null,59,21]

{"sheet":"LumpSumPrint1","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":true,"merged":[[3,2,3,3]]}
[]
[]
[]
[null,null,"Illustration of Addition Pension benefit cost"]
[null,null,{"$f":"Calculator!C3","v":"Member Details"}]
[null,null,"Date of Birth:",{"$f":"IF(Calculator!D15=\"\",\"\",Calculator!D15)","v":""}]
[null,null,"NPA:",{"$f":"IF(Calculator!D15=\"\",\"\",Codes!C6)","v":""}]
[null,null,"Quotation date:",{"$f":"Codes!F4","v":"2020-01-23"}]
[]
[null,null,"Calculation"]
[null,null," Lump sum payment amount (LS) =",{"$f":"IF(Calculator!D26=\"\",\"\",Calculator!D26)","v":""}]
[null,null,"Age (last brithday) at start of scheme year =",{"$f":"IF(Calculator!D15=\"\",\"\",Codes!F7)","v":""}]
[null,null," Relevant factor F=",{"$f":"IF(OR(Calculator!D16=\"\",Calculator!D21=\"\"),\"\",Codes!F9)","v":""}]
[]
[null,null,"Additional pension amount =","Lump sum / relevant factor"]
[null,null," =",{"$f":"Calculator!D28","v":""}]
[null,null,"Results"]
[null,null,{"$f":"Calculator!C26","v":"Lump sum payment amount "},{"$f":"Calculator!D26","v":0}]
[null,null,{"$f":"Calculator!C28","v":"It will buy me this much additional pension per year:-"},{"$f":"Calculator!D28","v":""}]

{"sheet":"RegularContsPrint1","index":5,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":true,"merged":[[21,2,21,5],[66,2,66,4],[71,2,71,5],[16,2,16,3],[17,2,17,3],[16,4,16,5],[19,2,19,3],[9,2,9,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[3,2,3,5],[8,2,8,3],[5,2,5,3],[6,2,6,3],[7,2,7,3]]}
[]
[]
[]
[null,null,"Illustration of Addition Pension benefit - Input Details and Summary"]
[null,null,{"$f":"Calculator!C3","v":"Member Details"}]
[null,null,"Date of Birth:",null,{"$f":"Calculator!D15","v":"00:00:00"}]
[null,null,"NPA:",null,{"$f":"Codes!C6","v":"1959-12-31"}]
[null,null,"Start date of periodic payments:",null,{"$f":"Codes!I3","v":"2020-01-23"}]
[null,null,"End date of periodic payments:",null,{"$f":"Codes!I7","v":"2020-03-31"}]
[null,null,"Payment type: ",null,{"$f":"Calculator!D36","v":"00:00:00"}]
[]
[null,null,"Calculation"]
[null,null,"Monthly Contributions =",null,{"$f":"Calculator!D42","v":""}]
[null,null,"Total contributions for first year =",null,{"$f":"Codes!R21","v":{"$error":"#VALUE!"}}]
[null,null,"Age last brithday at start of scheme year =",null,{"$f":"Codes!P21","v":0}]
[null,null," Relevant factor F =",null,{"$f":"Codes!Q21","v":""}]
[null,null,"Amount of additional pension purchased =",null,"Payments over scheme year / F"]
[null,null,"=",null,{"$f":"Codes!S21","v":{"$error":"#VALUE!"}}]
[null,null,"Results"]
[null,null,{"$f":"IF(Calculator!D36=\"Percentage of salary\",\"Initial monthly contribution amount based on \"&Calculator!G38&\"% of £\"&Calculator!D38&\" salary:\",\"Monthly contribution amount:\")","v":"Monthly contribution amount:"},null,{"$f":"Calculator!D42","v":""}]
[null,null,null,"Total additional pension per year payable from age 60:",{"$f":"IF(OR(ISERROR(E24),E24=\"\"),\"\",SUM(E24:E66))","v":{"$error":"#VALUE!"}}]
[null,null,"Illustration of Addition Pension benefit - Payments and Balance"]
[null,null,"Contribution period","Number of payments in year","Amount added to balance","Total AP balance"]
[null,null,{"$f":"Codes!H21","v":"2019 / 2020"},{"$f":"Codes!O21","v":3},{"$f":"Codes!S21","v":{"$error":"#VALUE!"}},{"$f":"IF(E24=\"\",\"\",E24)","v":{"$error":"#VALUE!"}}]
[null,null,{"$f":"Codes!H22","v":""},{"$f":"Codes!O22","v":""},{"$f":"Codes!S22","v":""},{"$f":"IF(E25=\"\",\"\",E25+F24)","v":""}]
[null,null,{"$f":"Codes!H23","v":""},{"$f":"Codes!O23","v":""},{"$f":"Codes!S23","v":""},{"$f":"IF(E26=\"\",\"\",E26+F25)","v":""}]
[null,null,{"$f":"Codes!H24","v":""},{"$f":"Codes!O24","v":""},{"$f":"Codes!S24","v":""},{"$f":"IF(E27=\"\",\"\",E27+F26)","v":""}]
[null,null,{"$f":"Codes!H25","v":""},{"$f":"Codes!O25","v":""},{"$f":"Codes!S25","v":""},{"$f":"IF(E28=\"\",\"\",E28+F27)","v":""}]
[null,null,{"$f":"Codes!H26","v":""},{"$f":"Codes!O26","v":""},{"$f":"Codes!S26","v":""},{"$f":"IF(E29=\"\",\"\",E29+F28)","v":""}]
[null,null,{"$f":"Codes!H27","v":""},{"$f":"Codes!O27","v":""},{"$f":"Codes!S27","v":""},{"$f":"IF(E30=\"\",\"\",E30+F29)","v":""}]
[null,null,{"$f":"Codes!H28","v":""},{"$f":"Codes!O28","v":""},{"$f":"Codes!S28","v":""},""]
[null,null,{"$f":"Codes!H29","v":""},{"$f":"Codes!O29","v":""},{"$f":"Codes!S29","v":""},""]
[null,null,{"$f":"Codes!H30","v":""},{"$f":"Codes!O30","v":""},{"$f":"Codes!S30","v":""},""]
[null,null,{"$f":"Codes!H31","v":""},{"$f":"Codes!O31","v":""},{"$f":"Codes!S31","v":""},""]
[null,null,{"$f":"Codes!H32","v":""},{"$f":"Codes!O32","v":""},{"$f":"Codes!S32","v":""},""]
[null,null,{"$f":"Codes!H33","v":""},{"$f":"Codes!O33","v":""},{"$f":"Codes!S33","v":""},""]
[null,null,{"$f":"Codes!H34","v":""},{"$f":"Codes!O34","v":""},{"$f":"Codes!S34","v":""},""]
[null,null,{"$f":"Codes!H35","v":""},{"$f":"Codes!O35","v":""},{"$f":"Codes!S35","v":""},""]
[null,null,{"$f":"Codes!H36","v":""},{"$f":"Codes!O36","v":""},{"$f":"Codes!S36","v":""},""]
[null,null,{"$f":"Codes!H37","v":""},{"$f":"Codes!O37","v":""},{"$f":"Codes!S37","v":""},""]
[null,null,{"$f":"Codes!H38","v":""},{"$f":"Codes!O38","v":""},{"$f":"Codes!S38","v":""},""]
[null,null,{"$f":"Codes!H39","v":""},{"$f":"Codes!O39","v":""},{"$f":"Codes!S39","v":""},""]
[null,null,{"$f":"Codes!H40","v":""},{"$f":"Codes!O40","v":""},{"$f":"Codes!S40","v":""},""]
[null,null,{"$f":"Codes!H41","v":""},{"$f":"Codes!O41","v":""},{"$f":"Codes!S41","v":""},""]
[null,null,{"$f":"Codes!H42","v":""},{"$f":"Codes!O42","v":""},{"$f":"Codes!S42","v":""},{"$f":"IF(E45=\"\",\"\",E45+F44)","v":""}]
[null,null,{"$f":"Codes!H43","v":""},{"$f":"Codes!O43","v":""},{"$f":"Codes!S43","v":""},""]
[null,null,{"$f":"Codes!H44","v":""},{"$f":"Codes!O44","v":""},{"$f":"Codes!S44","v":""},""]
[null,null,{"$f":"Codes!H45","v":""},{"$f":"Codes!O45","v":""},{"$f":"Codes!S45","v":""},""]
[null,null,{"$f":"Codes!H46","v":""},{"$f":"Codes!O46","v":""},{"$f":"Codes!S46","v":""},""]
[null,null,{"$f":"Codes!H47","v":""},{"$f":"Codes!O47","v":""},{"$f":"Codes!S47","v":""},""]
[null,null,{"$f":"Codes!H48","v":""},{"$f":"Codes!O48","v":""},{"$f":"Codes!S48","v":""},""]
[null,null,{"$f":"Codes!H49","v":""},{"$f":"Codes!O49","v":""},{"$f":"Codes!S49","v":""},""]
[null,null,{"$f":"Codes!H50","v":""},{"$f":"Codes!O50","v":""},{"$f":"Codes!S50","v":""},""]
[null,null,{"$f":"Codes!H51","v":""},{"$f":"Codes!O51","v":""},{"$f":"Codes!S51","v":""},""]
[null,null,{"$f":"Codes!H52","v":""},{"$f":"Codes!O52","v":""},{"$f":"Codes!S52","v":""},""]
[null,null,{"$f":"Codes!H53","v":""},{"$f":"Codes!O53","v":""},{"$f":"Codes!S53","v":""},""]
[null,null,{"$f":"Codes!H54","v":""},{"$f":"Codes!O54","v":""},{"$f":"Codes!S54","v":""},""]
[null,null,{"$f":"Codes!H55","v":""},{"$f":"Codes!O55","v":""},{"$f":"Codes!S55","v":""},""]
[null,null,{"$f":"Codes!H56","v":""},{"$f":"Codes!O56","v":""},{"$f":"Codes!S56","v":""},""]
[null,null,{"$f":"Codes!H57","v":""},{"$f":"Codes!O57","v":""},{"$f":"Codes!S57","v":""},""]
[null,null,{"$f":"Codes!H58","v":""},{"$f":"Codes!O58","v":""},{"$f":"Codes!S58","v":""},""]
[null,null,{"$f":"Codes!H59","v":""},{"$f":"Codes!O59","v":""},{"$f":"Codes!S59","v":""},""]
[null,null,{"$f":"Codes!H60","v":""},{"$f":"Codes!O60","v":""},{"$f":"Codes!S60","v":""},""]
[null,null,{"$f":"Codes!H61","v":""},{"$f":"Codes!O61","v":""},{"$f":"Codes!S61","v":""},{"$f":"IF(E64=\"\",\"\",E64+F63)","v":""}]
[null,null,{"$f":"Codes!H62","v":""},{"$f":"Codes!O62","v":""},{"$f":"Codes!S62","v":""},{"$f":"IF(E65=\"\",\"\",E65+F64)","v":""}]
[null,null,{"$f":"Codes!H63","v":""},{"$f":"Codes!O63","v":""},{"$f":"Codes!S63","v":""},{"$f":"IF(E66=\"\",\"\",E66+F65)","v":""}]
[null,null,{"$f":"Calculator!C43","v":""}]
[null,null,null,"Total additional pension per year payable from age 60:-",{"$f":"IF(OR(ISERROR(E24),E24=\"\"),\"\",SUM(E24:E66))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,null,"Note:\nThis calculator can provide an estimate at todays prices from the contributions start date. However please note that amounts will be calculated each year and the factors may change in the future affecting the accuracy of the estimate. If you have elected to pay a percentage of your salary the contribution amount may vary but will remain constant for the purpose of this quote.\n\nYour addition pension balance will be revalued annually to maintain it's purchasing power. If you retire before Normal Pension Age then your additional pension purchase (as well as your pension) will be subject to early retirement factors."]

{"sheet":"GuidanceNotes","index":6,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Additional Pension (AP) guidance notes"]
[null,"Disclaimer:\nThis calculation is intended for illustration purposes only. This is not a statement of you legal entitlement. While every care has been taken in the preperation of this calculator the Scottish Public Pension Agency will accept no responsibility for the accuracy of the information it provides.\n\nPlease refer to pages on the SPPA website for points of contact and other benefits available."]
[null,"Using the calculator\nYou must be a contributing member of the Police Pension Scheme (Scotland).\n\nAP benefits will be paid with your scheme retirement benefits and will be index linked.\n\nThe cost of purchasing AP depends on your age, your Normal Pension Age (NPA) and the amount of AP you wish to receive.\n\nCurrently the maximum AP allowed is £6500, however this is subject to change and will be reviewed annually. \n\nYou can choose to purchase self only AP to increase your own retirement benefits only, or all beneficiaries AP which will also provide 50% of the AP to your surviving dependants."]
[null,"There are two ways you can pay for AP. You can pay by having regular deductions taken from your monthly salary or by paying a one off lump sum. If you elect to pay a percentage of your salary the contribution amount may vary but will remain constant for the purpose of this quote.\n\nYour addition pension balance will be revalued annually to maintain its purchasing power. If you retire before Normal Pension Age then your additional pension purchase (as well as your pension) will be subject to early retirement factors."]
[null,"Limitations\nThis calculator can provide an estimate, at todays prices, up to your retirement date. However please note that amounts will be calculated each year and the factors may change in the future affecting the accuracy of the estimate. "]
[]
[null,"Last updated 22/09/2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"G"]