{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Practitioner","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Practitioner","index":0,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,2],[1,1,1,7]]}
["Buy back cost calculator - Practitioner"]
[null,"Scheme year"]
[null,"2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
["Dates employed during scheme year                 From","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01","2021-04-01"]
["to       ","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31"]
["Buy back period (number of whole months)",0,0,0,0,0,0,0]
["Total practitioner earnings in scheme year",0,0,0,0,0,0,0]
["Self-employed","No","No","No","No","No","No","No"]
[]
["Tax relief applied",{"$f":"IF(B8=\"No\",IF(B7<=Sheet2!$K$2,Sheet2!$K$1,IF(B7<=Sheet2!$L$2,Sheet2!$L$1,IF(B7<=Sheet2!$M$2,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(C8=\"No\",IF(C7<=Sheet2!$K$3,Sheet2!$K$1,IF(C7<=Sheet2!$L$3,Sheet2!$L$1,IF(C7<=Sheet2!$M$3,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(D8=\"No\",IF(D7<=Sheet2!$K$4,Sheet2!$K$1,IF(D7<=Sheet2!$L$4,Sheet2!$L$1,IF(D7<=Sheet2!$M$4,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(E8=\"No\",IF(E7<=Sheet2!$K$5,Sheet2!$K$1,IF(E7<=Sheet2!$L$5,Sheet2!$L$1,IF(E7<=Sheet2!$M$5,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(F8=\"No\",IF(F7<=Sheet2!$K$6,Sheet2!$K$1,IF(F7<=Sheet2!$L$6,Sheet2!$L$1,IF(F7<=Sheet2!$M$6,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(G8=\"No\",IF(G7<=Sheet2!$K$7,Sheet2!$K$1,IF(G7<=Sheet2!$L$7,Sheet2!$L$1,IF(G7<=Sheet2!$M$7,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0},{"$f":"IF(H8=\"No\",IF(H7<=Sheet2!$K$8,Sheet2!$K$1,IF(H7<=Sheet2!$L$8,Sheet2!$L$1,IF(H7<=Sheet2!$M$8,Sheet2!$M$1,Sheet2!$N$1))),0)","v":0}]
["Worked pays",{"$f":"IF(B4<=B5,B5-B4,\"Error\")","v":365},{"$f":"IF(C4<=C5,(C5-C4)+1,\"Error\")","v":365},365,365,366,365,365]
["Monthly pay ",{"$f":"B7*(365/B11)/12","v":0},0,0,0,0,0,0]
["Contribution rate",{"$f":"IF(B7<Sheet2!$E$3,Sheet2!$G$2,IF(B7<Sheet2!$E$4,Sheet2!$G$3,IF(B7<Sheet2!$E$5,Sheet2!$G$4,IF(B7<Sheet2!$E$6,Sheet2!$G$5,IF(B7<Sheet2!$E$7,Sheet2!$G$6,IF(B7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(C7<Sheet2!$E$3,Sheet2!$G$2,IF(C7<Sheet2!$E$4,Sheet2!$G$3,IF(C7<Sheet2!$E$5,Sheet2!$G$4,IF(C7<Sheet2!$E$6,Sheet2!$G$5,IF(C7<Sheet2!$E$7,Sheet2!$G$6,IF(C7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(D7<Sheet2!$E$3,Sheet2!$G$2,IF(D7<Sheet2!$E$4,Sheet2!$G$3,IF(D7<Sheet2!$E$5,Sheet2!$G$4,IF(D7<Sheet2!$E$6,Sheet2!$G$5,IF(D7<Sheet2!$E$7,Sheet2!$G$6,IF(D7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(E7<Sheet2!$E$3,Sheet2!$G$2,IF(E7<Sheet2!$E$4,Sheet2!$G$3,IF(E7<Sheet2!$E$5,Sheet2!$G$4,IF(E7<Sheet2!$E$6,Sheet2!$G$5,IF(E7<Sheet2!$E$7,Sheet2!$G$6,IF(E7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(F7<Sheet2!$E$3,Sheet2!$G$2,IF(F7<Sheet2!$E$4,Sheet2!$G$3,IF(F7<Sheet2!$E$5,Sheet2!$G$4,IF(F7<Sheet2!$E$6,Sheet2!$G$5,IF(F7<Sheet2!$E$7,Sheet2!$G$6,IF(F7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(G7<Sheet2!$E$3,Sheet2!$G$2,IF(G7<Sheet2!$E$4,Sheet2!$G$3,IF(G7<Sheet2!$E$5,Sheet2!$G$4,IF(G7<Sheet2!$E$6,Sheet2!$G$5,IF(G7<Sheet2!$E$7,Sheet2!$G$6,IF(G7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(H7<Sheet2!$E$3,Sheet2!$G$2,IF(H7<Sheet2!$E$4,Sheet2!$G$3,IF(H7<Sheet2!$E$5,Sheet2!$G$4,IF(H7<Sheet2!$E$6,Sheet2!$G$5,IF(H7<Sheet2!$E$7,Sheet2!$G$6,IF(H7<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05}]
["Date check",{"$f":"IF(B6*30>B11,\"Error\",\"\")","v":""},{"$f":"IF(C6*30>C11,\"Error\",\"\")","v":""},"","","","",""]
[null,{"$f":"EDATE(B4,B6)-1","v":"2015-03-31"},{"$f":"EDATE(C4,C6)-1","v":"2016-03-31"},"2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31"]
["Mid point from scheme year employed",{"$f":"IF(B6<12,(B15-B4)/2+B4,(B5-B4)/2+B4)","v":"2015-03-31T12:00:00"},{"$f":"IF(C6<12,(C15-C4)/2+C4,(C5-C4)/2+C4)","v":"2016-03-31T12:00:00"},"2017-03-31T12:00:00","2018-03-31T12:00:00","2019-03-31T12:00:00","2020-03-31T12:00:00","2021-03-31T12:00:00"]
["Average interest rate from mid point",{"$f":"Sheet1!D21","v":1.1524875957407945},{"$f":"Sheet1!F21","v":1.139939630037631},{"$f":"Sheet1!H21","v":1.1302869376490379},{"$f":"Sheet1!J21","v":1.121424527137816},{"$f":"Sheet1!L21","v":1.1106051294239003},{"$f":"Sheet1!N21","v":1.0995865721712017},{"$f":"Sheet1!P21","v":1.0919236368541037}]
["Days interest",{"$f":"_xlfn.DAYS(Sheet2!$X$1,B16)","v":3655},{"$f":"_xlfn.DAYS(Sheet2!$X$1,C16)","v":3289},{"$f":"_xlfn.DAYS(Sheet2!$X$1,D16)","v":2924},{"$f":"_xlfn.DAYS(Sheet2!$X$1,E16)","v":2559},{"$f":"_xlfn.DAYS(Sheet2!$X$1,F16)","v":2194},{"$f":"_xlfn.DAYS(Sheet2!$X$1,G16)","v":1828},{"$f":"_xlfn.DAYS(Sheet2!$X$1,H16)","v":1463}]
[]
["Gross underpayment",{"$f":"B12*B6*B13","v":0},0,0,0,0,0,0]
[]
["Total pensionable pay - Gross overpayment",{"$f":"B7-B20","v":0},0,0,0,0,0,0]
["Lower tax rate",{"$f":"IF(B22<=Sheet2!$K$2,Sheet2!$K$1,IF(B22<=Sheet2!$L$2,Sheet2!$L$1,IF(B22<=Sheet2!$M$2,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(C22<=Sheet2!$K$3,Sheet2!$K$1,IF(C22<=Sheet2!$L$3,Sheet2!$L$1,IF(C22<=Sheet2!$M$3,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(D22<=Sheet2!$K$4,Sheet2!$K$1,IF(D22<=Sheet2!$L$4,Sheet2!$L$1,IF(D22<=Sheet2!$M$4,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(E22<=Sheet2!$K$5,Sheet2!$K$1,IF(E22<=Sheet2!$L$5,Sheet2!$L$1,IF(E22<=Sheet2!$M$5,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(F22<=Sheet2!$K$6,Sheet2!$K$1,IF(F22<=Sheet2!$L$6,Sheet2!$L$1,IF(F22<=Sheet2!$M$6,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(G22<=Sheet2!$K$7,Sheet2!$K$1,IF(G22<=Sheet2!$L$7,Sheet2!$L$1,IF(G22<=Sheet2!$M$7,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(H22<=Sheet2!$K$8,Sheet2!$K$1,IF(H22<=Sheet2!$L$8,Sheet2!$L$1,IF(H22<=Sheet2!$M$8,Sheet2!$M$1,Sheet2!$N$1)))","v":0}]
["Amount at higher rate",{"$f":"IF(B10=B23,B20,IF(B7<=Sheet2!$K$2,B20,IF(B7<=Sheet2!$L$2,B7-Sheet2!$K$2,IF(B7<=Sheet2!$M$2,B7-Sheet2!$L$2,B7-Sheet2!$M$2))))","v":0},{"$f":"IF(C10=C23,C20,IF(C7<=Sheet2!$K$3,C20,IF(C7<=Sheet2!$L$3,C7-Sheet2!$K$3,IF(C7<=Sheet2!$M$3,C7-Sheet2!$L$3,C7-Sheet2!$M$3))))","v":0},{"$f":"IF(D10=D23,D20,IF(D7<=Sheet2!$K$4,D20,IF(D7<=Sheet2!$L$4,D7-Sheet2!$K$4,IF(D7<=Sheet2!$M$4,D7-Sheet2!$L$4,D7-Sheet2!$M$4))))","v":0},{"$f":"IF(E10=E23,E20,IF(E7<=Sheet2!$K$5,E20,IF(E7<=Sheet2!$L$5,E7-Sheet2!$K$5,IF(E7<=Sheet2!$M$5,E7-Sheet2!$L$5,E7-Sheet2!$M$5))))","v":0},{"$f":"IF(F10=F23,F20,IF(F7<=Sheet2!$K$6,F20,IF(F7<=Sheet2!$L$6,F7-Sheet2!$K$6,IF(F7<=Sheet2!$M$6,F7-Sheet2!$L$6,F7-Sheet2!$M$6))))","v":0},{"$f":"IF(G10=G23,G20,IF(G7<=Sheet2!$K$7,G20,IF(G7<=Sheet2!$L$7,G7-Sheet2!$K$7,IF(G7<=Sheet2!$M$7,G7-Sheet2!$L$7,G7-Sheet2!$M$7))))","v":0},{"$f":"IF(H10=H23,H20,IF(H7<=Sheet2!$K$8,H20,IF(H7<=Sheet2!$L$8,H7-Sheet2!$K$8,IF(H7<=Sheet2!$M$8,H7-Sheet2!$L$8,H7-Sheet2!$M$8))))","v":0}]
["Amount at lower rate",{"$f":"B20-B24","v":0},0,0,0,0,0,0]
["Tax",{"$f":"IF(B8=\"No\",(B24*B10)+(B25*B23),0)","v":0},{"$f":"IF(C8=\"No\",(C24*C10)+(C25*C23),0)","v":0},0,0,0,0,0]
["Net underpayment",{"$f":"B20-B26","v":0},0,0,0,0,0,0]
["Interest",{"$f":"B27*(B17-1)","v":0},{"$f":"C27*(C17-1)","v":0},0,0,0,0,0]
["Employer contribution",{"$f":"B12*B6*Sheet2!$P$2","v":0},{"$f":"C12*C6*Sheet2!$P$2","v":0},{"$f":"D12*D6*Sheet2!$P$2","v":0},{"$f":"E12*E6*Sheet2!$P$2","v":0},{"$f":"F12*F6*Sheet2!$P$2","v":0},{"$f":"G12*G6*Sheet2!$P$2","v":0},{"$f":"H12*H6*Sheet2!$P$2","v":0}]
[]
[null,"Net cost to buy back opted out service",{"$f":"SUM(B27:H27)","v":0}]
[null,"Interest",{"$f":"SUM(B28:H28)","v":0}]
[null,"Total",{"$f":"C31+C32","v":0}]
[null,{"$f":"IF(OR($B$7>250000,$C$7>250000,$D$7>250000,$E$7>250000,$F$7>250000,$G$7>250000,$H$7>250000,$I$7>250000),\"Warning:\",\"\")","v":""},{"$f":"IF(OR($B$7>250000,$C$7>250000,$D$7>250000,$E$7>250000,$F$7>250000,$G$7>250000,$H$7>250000,$I$7>250000),\"Total Pensionable Pay exceeds £250,000\",\"\")","v":""}]
[null,{"$f":"IF(C35=\"\",\"\",\"Error:\")","v":""},{"$f":"IF(OR(B11=\"Error\",C11=\"Error\",D11=\"Error\",E11=\"Error\",F11=\"Error\",G11=\"Error\",H11=\"Error\"),\"Employed from date can not be later than employed to date\",IF(OR(B14=\"Error\",C14=\"Error\",D14=\"Error\",E14=\"Error\",F14=\"Error\",G14=\"Error\",H14=\"Error\"),\"Cant buy back more service then employed during the year\",\"\"))","v":""}]
["Annualised pay ",{"$f":"B7*(365/B11)","v":0},0,0,0,0,0,0]
["Contribution rate",{"$f":"IF(B36<Sheet2!$E$3,Sheet2!$G$2,IF(B36<Sheet2!$E$4,Sheet2!$G$3,IF(B36<Sheet2!$E$5,Sheet2!$G$4,IF(B36<Sheet2!$E$6,Sheet2!$G$5,IF(B36<Sheet2!$E$7,Sheet2!$G$6,IF(B36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(C36<Sheet2!$E$3,Sheet2!$G$2,IF(C36<Sheet2!$E$4,Sheet2!$G$3,IF(C36<Sheet2!$E$5,Sheet2!$G$4,IF(C36<Sheet2!$E$6,Sheet2!$G$5,IF(C36<Sheet2!$E$7,Sheet2!$G$6,IF(C36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(D36<Sheet2!$E$3,Sheet2!$G$2,IF(D36<Sheet2!$E$4,Sheet2!$G$3,IF(D36<Sheet2!$E$5,Sheet2!$G$4,IF(D36<Sheet2!$E$6,Sheet2!$G$5,IF(D36<Sheet2!$E$7,Sheet2!$G$6,IF(D36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(E36<Sheet2!$E$3,Sheet2!$G$2,IF(E36<Sheet2!$E$4,Sheet2!$G$3,IF(E36<Sheet2!$E$5,Sheet2!$G$4,IF(E36<Sheet2!$E$6,Sheet2!$G$5,IF(E36<Sheet2!$E$7,Sheet2!$G$6,IF(E36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(F36<Sheet2!$E$3,Sheet2!$G$2,IF(F36<Sheet2!$E$4,Sheet2!$G$3,IF(F36<Sheet2!$E$5,Sheet2!$G$4,IF(F36<Sheet2!$E$6,Sheet2!$G$5,IF(F36<Sheet2!$E$7,Sheet2!$G$6,IF(F36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(G36<Sheet2!$E$3,Sheet2!$G$2,IF(G36<Sheet2!$E$4,Sheet2!$G$3,IF(G36<Sheet2!$E$5,Sheet2!$G$4,IF(G36<Sheet2!$E$6,Sheet2!$G$5,IF(G36<Sheet2!$E$7,Sheet2!$G$6,IF(G36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05},{"$f":"IF(H36<Sheet2!$E$3,Sheet2!$G$2,IF(H36<Sheet2!$E$4,Sheet2!$G$3,IF(H36<Sheet2!$E$5,Sheet2!$G$4,IF(H36<Sheet2!$E$6,Sheet2!$G$5,IF(H36<Sheet2!$E$7,Sheet2!$G$6,IF(H36<Sheet2!$E$8,Sheet2!$G$7,Sheet2!$G$8))))))","v":0.05}]
[]
["Gross underpayment",{"$f":"B12*B6*B37","v":0},{"$f":"C12*C6*C37","v":0},0,0,0,0,0]
[]
["Total pensionable pay - Gross overpayment",{"$f":"B7-B39","v":0},{"$f":"C7-C39","v":0},0,0,0,0,0]
["Lower tax rate",{"$f":"IF(B41<=Sheet2!$K$2,Sheet2!$K$1,IF(B41<=Sheet2!$L$2,Sheet2!$L$1,IF(B41<=Sheet2!$M$2,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(C41<=Sheet2!$K$3,Sheet2!$K$1,IF(C41<=Sheet2!$L$3,Sheet2!$L$1,IF(C41<=Sheet2!$M$3,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(D41<=Sheet2!$K$4,Sheet2!$K$1,IF(D41<=Sheet2!$L$4,Sheet2!$L$1,IF(D41<=Sheet2!$M$4,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(E41<=Sheet2!$K$5,Sheet2!$K$1,IF(E41<=Sheet2!$L$5,Sheet2!$L$1,IF(E41<=Sheet2!$M$5,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(F41<=Sheet2!$K$6,Sheet2!$K$1,IF(F41<=Sheet2!$L$6,Sheet2!$L$1,IF(F41<=Sheet2!$M$6,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(G41<=Sheet2!$K$7,Sheet2!$K$1,IF(G41<=Sheet2!$L$7,Sheet2!$L$1,IF(G41<=Sheet2!$M$7,Sheet2!$M$1,Sheet2!$N$1)))","v":0},{"$f":"IF(H41<=Sheet2!$K$8,Sheet2!$K$1,IF(H41<=Sheet2!$L$8,Sheet2!$L$1,IF(H41<=Sheet2!$M$8,Sheet2!$M$1,Sheet2!$N$1)))","v":0}]
["Amount at higher rate",{"$f":"IF(B10=B42,B39,IF(B7<=Sheet2!$K$2,B39,IF(B7<=Sheet2!$L$2,B7-Sheet2!$K$2,IF(B7<=Sheet2!$M$2,B7-Sheet2!$L$2,B7-Sheet2!$M$2))))","v":0},{"$f":"IF(C10=C42,C39,IF(C7<=Sheet2!$K$3,C39,IF(C7<=Sheet2!$L$3,C7-Sheet2!$K$3,IF(C7<=Sheet2!$M$3,C7-Sheet2!$L$3,C7-Sheet2!$M$3))))","v":0},{"$f":"IF(D10=D42,D39,IF(D7<=Sheet2!$K$4,D39,IF(D7<=Sheet2!$L$4,D7-Sheet2!$K$4,IF(D7<=Sheet2!$M$4,D7-Sheet2!$L$4,D7-Sheet2!$M$4))))","v":0},{"$f":"IF(E10=E42,E39,IF(E7<=Sheet2!$K$5,E39,IF(E7<=Sheet2!$L$5,E7-Sheet2!$K$5,IF(E7<=Sheet2!$M$5,E7-Sheet2!$L$5,E7-Sheet2!$M$5))))","v":0},{"$f":"IF(F10=F42,F39,IF(F7<=Sheet2!$K$6,F39,IF(F7<=Sheet2!$L$6,F7-Sheet2!$K$6,IF(F7<=Sheet2!$M$6,F7-Sheet2!$L$6,F7-Sheet2!$M$6))))","v":0},{"$f":"IF(G10=G42,G39,IF(G7<=Sheet2!$K$7,G39,IF(G7<=Sheet2!$L$7,G7-Sheet2!$K$7,IF(G7<=Sheet2!$M$7,G7-Sheet2!$L$7,G7-Sheet2!$M$7))))","v":0},{"$f":"IF(H10=H42,H39,IF(H7<=Sheet2!$K$8,H39,IF(H7<=Sheet2!$L$8,H7-Sheet2!$K$8,IF(H7<=Sheet2!$M$8,H7-Sheet2!$L$8,H7-Sheet2!$M$8))))","v":0}]
["Amount at lower rate",{"$f":"B39-B43","v":0},0,0,0,0,0,0]
["Tax",{"$f":"IF(B8=\"No\",(B43*B10)+(B44*B42),0)","v":0},{"$f":"IF(C8=\"No\",(C43*C10)+(C44*C42),0)","v":0},{"$f":"IF(D8=\"No\",(D43*D10)+(D44*D42),0)","v":0},0,0,0,0]
["Net underpayment",{"$f":"B39-B45","v":0},0,0,0,0,0,0]
[]
["Additional underpayment if choose Reformed Scheme at retirement",{"$f":"B46-B27","v":0},{"$f":"C46-C27","v":0},0,0,0,0,0]
[]
["Additional cost if choose Reformed 2015 Scheme at retirement   ",null,null,{"$f":"SUM(B48:H48)","v":0},"Interest will be added to this amount until the amount is repaid"]

{"sheet":"Sheet1","index":1,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Effective from","NS&I Rate","2015/16 Days","2015/16 Rate","2016/17 Days","2016/17 Rate","2017/18 Days","2017/18 Rate","2018/19 Days","2018/19 Rate","2019/20 Days","2019/20 Rate","2020/21 Days","2020/21 Rate","2021/22 Days","2021/22 Rate",{"$f":"TODAY()","v":"2025-03-05"},{"$f":"Q1+28","v":"2025-04-02"}]
["2025-03-05",1.0329999999999999,{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(C2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(E2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(G2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(I2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(K2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(M2/365.25)","v":1.0024920289732211},{"$f":"$R$1-$A$2","v":28},{"$f":"B2^(O2/365.25)","v":1.0024920289732211}]
["2024-12-20",1.0349999999999999,{"$f":"$A2-$A3","v":75},{"$f":"B3^(C3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(E3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(G3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(I3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(K3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(M3/365.25)","v":1.0070889565234933},{"$f":"$A2-$A3","v":75},{"$f":"B3^(O3/365.25)","v":1.0070889565234933}]
["2024-11-20",1.0375000000000001,30,1.0030283110564349,30,1.0030283110564349,30,1.0030283110564349,30,1.0030283110564349,30,1.0030283110564349,30,1.0030283110564349,30,1.0030283110564349]
["2024-05-23",1.04,181,1.0196259693476684,181,1.0196259693476684,181,1.0196259693476684,181,1.0196259693476684,181,1.0196259693476684,181,1.0196259693476684,181,1.0196259693476684]
["2023-08-18",1.0365,{"$f":"$A5-$A6","v":279},{"$f":"B6^(C6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(E6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(G6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(I6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(K6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(M6/365.25)","v":1.0277625204493888},{"$f":"$A5-$A6","v":279},{"$f":"B6^(O6/365.25)","v":1.0277625204493888}]
["2023-06-13",1.034,{"$f":"$A6-$A7","v":66},{"$f":"B7^(C7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(E7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(G7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(I7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(K7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(M7/365.25)","v":1.0060598895381661},66,{"$f":"B7^(O7/365.25)","v":1.0060598895381661}]
["2023-02-14",1.0285,119,1.0091976055734242,119,1.0091976055734242,119,1.0091976055734242,119,1.0091976055734242,119,1.0091976055734242,119,1.0091976055734242,119,1.0091976055734242]
["2023-01-24",1.026,21,1.0014768531485094,21,1.0014768531485094,21,1.0014768531485094,21,1.0014768531485094,21,1.0014768531485094,21,1.0014768531485094,21,1.0014768531485094]
["2022-12-13",1.0229999999999999,42,1.0026182291273764,42,1.0026182291273764,42,1.0026182291273764,42,1.0026182291273764,42,1.0026182291273764,42,1.0026182291273764,42,1.0026182291273764]
["2022-10-25",1.018,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339,{"$f":"$A10-$A11","v":49},1.0023961749099339]
["2022-07-21",1.012,{"$f":"IF(Practitioner!$B$16<A11,IF(Practitioner!$B$16>A12,A11-Practitioner!$B$16,A11-A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$C$16<$A11,IF(Practitioner!$C$16>$A12,$A11-Practitioner!$C$16,$A11-$A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$D$16<$A11,IF(Practitioner!$D$16>$A12,$A11-Practitioner!$D$16,$A11-$A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$E$16<$A11,IF(Practitioner!$E$16>$A12,$A11-Practitioner!$E$16,$A11-$A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$F$16<$A11,IF(Practitioner!$F$16>$A12,$A11-Practitioner!$F$16,$A11-$A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$G$16<$A11,IF(Practitioner!$G$16>$A12,$A11-Practitioner!$G$16,$A11-$A12),0)","v":96},1.0031401500991282,{"$f":"IF(Practitioner!$H$16<$A11,IF(Practitioner!$H$16>$A12,$A11-Practitioner!$H$16,$A11-$A12),0)","v":96},1.0031401500991282]
["2022-02-10",1.0049999999999999,{"$f":"IF(Practitioner!$B$16<A12,IF(Practitioner!$B$16>A13,A12-Practitioner!$B$16,A12-A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$C$16<$A12,IF(Practitioner!$C$16>$A13,$A12-Practitioner!$C$16,$A12-$A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$D$16<$A12,IF(Practitioner!$D$16>$A13,$A12-Practitioner!$D$16,$A12-$A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$E$16<$A12,IF(Practitioner!$E$16>$A13,$A12-Practitioner!$E$16,$A12-$A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$F$16<$A12,IF(Practitioner!$F$16>$A13,$A12-Practitioner!$F$16,$A12-$A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$G$16<$A12,IF(Practitioner!$G$16>$A13,$A12-Practitioner!$G$16,$A12-$A13),0)","v":161},1.0022008966820313,{"$f":"IF(Practitioner!$H$16<$A12,IF(Practitioner!$H$16>$A13,$A12-Practitioner!$H$16,$A12-$A13),0)","v":161},1.0022008966820313]
["2021-12-29",1.0035000000000001,{"$f":"IF(Practitioner!$B$16<A13,IF(Practitioner!$B$16>A14,A13-Practitioner!$B$16,A13-A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$C$16<$A13,IF(Practitioner!$C$16>$A14,$A13-Practitioner!$C$16,$A13-$A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$D$16<$A13,IF(Practitioner!$D$16>$A14,$A13-Practitioner!$D$16,$A13-$A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$E$16<$A13,IF(Practitioner!$E$16>$A14,$A13-Practitioner!$E$16,$A13-$A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$F$16<$A13,IF(Practitioner!$F$16>$A14,$A13-Practitioner!$F$16,$A13-$A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$G$16<$A13,IF(Practitioner!$G$16>$A14,$A13-Practitioner!$G$16,$A13-$A14),0)","v":43},1.0004114117467395,{"$f":"IF(Practitioner!$H$16<$A13,IF(Practitioner!$H$16>$A14,$A13-Practitioner!$H$16,$A13-$A14),0)","v":43},1.0004114117467395]
["2020-11-24",1.0015000000000001,{"$f":"IF(Practitioner!$B$16<A14,IF(Practitioner!$B$16>A15,A14-Practitioner!$B$16,A14-A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$C$16<$A14,IF(Practitioner!$C$16>$A15,$A14-Practitioner!$C$16,$A14-$A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$D$16<$A14,IF(Practitioner!$D$16>$A15,$A14-Practitioner!$D$16,$A14-$A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$E$16<$A14,IF(Practitioner!$E$16>$A15,$A14-Practitioner!$E$16,$A14-$A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$F$16<$A14,IF(Practitioner!$F$16>$A15,$A14-Practitioner!$F$16,$A14-$A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$G$16<$A14,IF(Practitioner!$G$16>$A15,$A14-Practitioner!$G$16,$A14-$A15),0)","v":400},1.0016428276352789,{"$f":"IF(Practitioner!$H$16<$A14,IF(Practitioner!$H$16>$A15,$A14-Practitioner!$H$16,$A14-$A15),0)","v":272.5},1.001118883508872]
["2018-10-01",1.01,{"$f":"IF(Practitioner!$B$16<A15,IF(Practitioner!$B$16>A16,A15-Practitioner!$B$16,A15-A16),0)","v":785},1.0216156851265583,{"$f":"IF(Practitioner!$C$16<$A15,IF(Practitioner!$C$16>$A16,$A15-Practitioner!$C$16,$A15-$A16),0)","v":785},1.0216156851265583,{"$f":"IF(Practitioner!$D$16<$A15,IF(Practitioner!$D$16>$A16,$A15-Practitioner!$D$16,$A15-$A16),0)","v":785},1.0216156851265583,{"$f":"IF(Practitioner!$E$16<$A15,IF(Practitioner!$E$16>$A16,$A15-Practitioner!$E$16,$A15-$A16),0)","v":785},1.0216156851265583,{"$f":"IF(Practitioner!$F$16<$A15,IF(Practitioner!$F$16>$A16,$A15-Practitioner!$F$16,$A15-$A16),0)","v":603.5},1.0165767562033723,{"$f":"IF(Practitioner!$G$16<$A15,IF(Practitioner!$G$16>$A16,$A15-Practitioner!$G$16,$A15-$A16),0)","v":237.5},1.0064910750794251,{"$f":"IF(Practitioner!$H$16<$A15,IF(Practitioner!$H$16>$A16,$A15-Practitioner!$H$16,$A15-$A16),0)","v":0},1]
["2017-12-01",1.0095000000000001,{"$f":"IF(Practitioner!$B$16<A16,IF(Practitioner!$B$16>A17,A16-Practitioner!$B$16,A16-A17),0)","v":304},1.0079006380429596,{"$f":"IF(Practitioner!$C$16<$A16,IF(Practitioner!$C$16>$A17,$A16-Practitioner!$C$16,$A16-$A17),0)","v":304},1.0079006380429596,{"$f":"IF(Practitioner!$D$16<$A16,IF(Practitioner!$D$16>$A17,$A16-Practitioner!$D$16,$A16-$A17),0)","v":304},1.0079006380429596,{"$f":"IF(Practitioner!$E$16<$A16,IF(Practitioner!$E$16>$A17,$A16-Practitioner!$E$16,$A16-$A17),0)","v":183.5},1.0047615305775157,{"$f":"IF(Practitioner!$F$16<$A16,IF(Practitioner!$F$16>$A17,$A16-Practitioner!$F$16,$A16-$A17),0)","v":0},1,{"$f":"IF(Practitioner!$G$16<$A16,IF(Practitioner!$G$16>$A17,$A16-Practitioner!$G$16,$A16-$A17),0)","v":0},1,{"$f":"IF(Practitioner!$H$16<$A16,IF(Practitioner!$H$16>$A17,$A16-Practitioner!$H$16,$A16-$A17),0)","v":0},1]
["2017-05-01",1.0069999999999999,{"$f":"IF(Practitioner!$B$16<A17,IF(Practitioner!$B$16>A18,A17-Practitioner!$B$16,A17-A18),0)","v":214},1.0040953757911364,{"$f":"IF(Practitioner!$C$16<$A17,IF(Practitioner!$C$16>$A18,$A17-Practitioner!$C$16,$A17-$A18),0)","v":214},1.0040953757911364,{"$f":"IF(Practitioner!$D$16<$A17,IF(Practitioner!$D$16>$A18,$A17-Practitioner!$D$16,$A17-$A18),0)","v":214},1.0040953757911364,{"$f":"IF(Practitioner!$E$16<$A17,IF(Practitioner!$E$16>$A18,$A17-Practitioner!$E$16,$A17-$A18),0)","v":0},1,{"$f":"IF(Practitioner!$F$16<$A17,IF(Practitioner!$F$16>$A18,$A17-Practitioner!$F$16,$A17-$A18),0)","v":0},1,{"$f":"IF(Practitioner!$G$16<$A17,IF(Practitioner!$G$16>$A18,$A17-Practitioner!$G$16,$A17-$A18),0)","v":0},1,{"$f":"IF(Practitioner!$H$16<$A17,IF(Practitioner!$H$16>$A18,$A17-Practitioner!$H$16,$A17-$A18),0)","v":0},1]
["2016-06-06",1.008,{"$f":"IF(Practitioner!$B$16<A18,IF(Practitioner!$B$16>A19,A18-Practitioner!$B$16,A18-A19),0)","v":329},1.0072031709149722,{"$f":"IF(Practitioner!$C$16<$A18,IF(Practitioner!$C$16>$A19,$A18-Practitioner!$C$16,$A18-$A19),0)","v":329},1.0072031709149722,{"$f":"IF(Practitioner!$D$16<$A18,IF(Practitioner!$D$16>$A19,$A18-Practitioner!$D$16,$A18-$A19),0)","v":30.5},1.0006655990289441,{"$f":"IF(Practitioner!$E$16<$A18,IF(Practitioner!$E$16>$A19,$A18-Practitioner!$E$16,$A18-$A19),0)","v":0},1,{"$f":"IF(Practitioner!$F$16<$A18,IF(Practitioner!$F$16>$A19,$A18-Practitioner!$F$16,$A18-$A19),0)","v":0},1,{"$f":"IF(Practitioner!$G$16<$A18,IF(Practitioner!$G$16>$A19,$A18-Practitioner!$G$16,$A18-$A19),0)","v":0},1,{"$f":"IF(Practitioner!$H$16<$A18,IF(Practitioner!$H$16>$A19,$A18-Practitioner!$H$16,$A18-$A19),0)","v":0},1]
["2015-04-01",1.0109999999999999,{"$f":"IF(Practitioner!$B$16<A19,IF(Practitioner!$B$16>A20,A19-Practitioner!$B$16,A19-A20),0)","v":432},1.0130233050034256,{"$f":"IF(Practitioner!$C$16<$A19,IF(Practitioner!$C$16>$A20,$A19-Practitioner!$C$16,$A19-$A20),0)","v":66.5},1.001993787866178,{"$f":"IF(Practitioner!$D$16<$A19,IF(Practitioner!$D$16>$A20,$A19-Practitioner!$D$16,$A19-$A20),0)","v":0},1,{"$f":"IF(Practitioner!$E$16<$A19,IF(Practitioner!$E$16>$A20,$A19-Practitioner!$E$16,$A19-$A20),0)","v":0},1,{"$f":"IF(Practitioner!$F$16<$A19,IF(Practitioner!$F$16>$A20,$A19-Practitioner!$F$16,$A19-$A20),0)","v":0},1,{"$f":"IF(Practitioner!$G$16<$A19,IF(Practitioner!$G$16>$A20,$A19-Practitioner!$G$16,$A19-$A20),0)","v":0},1,{"$f":"IF(Practitioner!$H$16<$A19,IF(Practitioner!$H$16>$A20,$A19-Practitioner!$H$16,$A19-$A20),0)","v":0},1]
[null,null,null,{"$f":"D2*D3*D4*D5*D6*D7*D8*D9*D10*D11*D12*D13*D14*D15*D16*D17*D18*D19*D20","v":1.1524875957407945},null,{"$f":"F2*F3*F4*F5*F6*F7*F8*F9*F10*F11*F12*F13*F14*F15*F16*F17*F18*F19*F20","v":1.139939630037631},null,1.1302869376490379,null,1.121424527137816,null,1.1106051294239003,null,1.0995865721712017,null,1.0919236368541037]

{"sheet":"Sheet2","index":2,"n_rows":16,"n_cols":25,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Whole",0,null,"Tier","Lower Pay ","Upper Pay","Rate",null,null,null,0,0.2,0.4,0.45,null,"Employer Rate",null,null,"Effective from","NS&I Rate",null,null,{"$f":"TODAY()","v":"2025-03-05"},{"$f":"W1+28","v":"2025-04-02"},"No"]
["Part",1,null,1,0,15431.99,0.05,null,null,"2015/16",10600,42385,150000,null,null,0.14380000000000001,null,null,"2023-08-18",3.6499999999999998E-2,{"$f":"W1-S2","v":565},null,null,null,"Yes"]
[null,2,null,2,15432,21477.99,5.6000000000000001E-2,null,null,"2016/17",11000,43000,150000,null,null,0.20599999999999999,null,null,"2023-06-13",3.4000000000000002E-2,{"$f":"S2-S3","v":66}]
[null,3,null,3,21478,26823.99,7.0999999999999994E-2,null,null,"2017/18",11500,45000,150000,null,null,null,null,null,"2023-02-14",2.8500000000000001E-2,{"$f":"S3-S4","v":119}]
[null,4,null,4,26824,47846,9.2999999999999999E-2,null,null,"2018/19",11850,46350,150000,null,null,null,null,null,"2023-01-24",2.5999999999999999E-2,21]
[null,5,null,5,47846,70630.990000000005,0.125,null,null,"2019/20",12500,50000,150000,null,null,null,null,null,"2022-12-13",2.3E-2,42]
[null,6,null,6,70631,111376.99,0.13500000000000001,null,null,"2020/21",12500,50000,150000,null,null,null,null,null,"2022-10-25",1.7999999999999999E-2,49]
[null,7,null,7,111377,999999,0.14499999999999999,null,null,"2021/22",12570,50270,150000,null,null,null,null,null,"2022-07-21",1.2E-2,96]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-10",5.0000000000000001E-3,161,{"$f":"(($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$9)","v":2.735388739946381E-2}]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-29",3.5000000000000001E-3,43,{"$f":"(($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$10)","v":2.647117039586919E-2}]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-24",1.5E-3,400,{"$f":"(($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$11)","v":2.0076504481434058E-2}]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01",0.01,785,{"$f":"(($T$12*$U$12)+($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$12)","v":1.6706220707285897E-2}]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01",9.4999999999999998E-3,304,{"$f":"(($T$13*$U$13)+($T$12*$U$12)+($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$13)","v":1.5879856657864955E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01",7.0000000000000001E-3,214,{"$f":"(($T$14*$U$14)+($T$13*$U$13)+($T$12*$U$12)+($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$14)","v":1.5216579406631764E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-06",8.0000000000000002E-3,329,{"$f":"(($T$15*$U$15)+($T$14*$U$14)+($T$13*$U$13)+($T$12*$U$12)+($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$15)","v":1.4473231058234191E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01",1.0999999999999999E-2,432,{"$f":"(($T$16*$U$16)+($T$15*$U$15)+($T$14*$U$14)+($T$13*$U$13)+($T$12*$U$12)+($T$11*$U$11)+($T$10*$U$10)+($T$9*$U$9)+($T$8*$U$8)+($T$7*$U$7)+($T$6*$U$6)+($T$5*$U$5)+($T$4*$U$4)+($T$3*$U$3)+($T$2*$U$2))/SUM($U$2:$U$16)","v":1.4059431880860453E-2}]