{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Control","Factor Table"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"Control","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,3,5,4]]}
[null,"Reinstatement of Part Time Service Following the Preston Ruling"]
[null,"Calculation of Member's Interest on NI Rebate"]
[]
[null,"Inputs"]
[]
[null,"Name"]
[]
[null,"Present month (mm/yyyy)",null,"2010-07-01"]
[]
[null,"Year","Interest factor","Rebate"]
[]
[null,"1978/79",{"$f":"VLOOKUP(12*YEAR(D$8)+MONTH(D$8)-23715,tab,2,FALSE)/VLOOKUP(LEFT(B12,4)*12+10-23715,tab,2,FALSE)-1","v":5.1844897959183678}]
[null,"1979/80",4.6962406015037592]
[null,"1980/81",4.1854893908281996]
[null,"1981/82",3.72613849033063]
[null,"1982/83",3.3118952760387019]
[null,"1983/84",3.0042283298097248]
[null,"1984/85",2.7046454767726162]
[null,"1985/86",2.4141505182514646]
[null,"1986/87",2.1659005432511491]
[null,"1987/88",1.9364341085271319]
[null,"1988/89",1.7399638336347198]
[null,"1989/90",1.5491251682368774]
[null,"1990/91",1.3549891202984146]
[null,"1991/92",1.1627176705680844]
[null,"1992/93",1.0005281225244258]
[null,"1993/94",0.89116325511732408]
[null,"1994/95",0.79271178419309041]
[]
[null,"Output","Total Interest (D)",{"$f":"SUMPRODUCT(D12:D28,C12:C28)","v":0}]

{"sheet":"Factor Table","index":1,"n_rows":584,"n_cols":4,"rows_kept":584,"cut":false,"hidden":true,"merged":[]}
[{"$f":"CELL(\"filename\")","v":"\\\\gad-ast\\AST\\PSPS\\Preston\\Rebate Models\\2024\\July\\[Employee NIC Rebate June 2024.xlsm]Control"}]
[]
[]
["Year","Month","Month No","Interest Index"]
[null,null,0,1]
[{"$f":"ROUNDDOWN((C6+2)/12,0)+1976","v":1976},{"$f":"MOD(C6+2,12)+1","v":4},1,1000]
[{"$f":"ROUNDDOWN((C7+2)/12,0)+1976","v":1976},{"$f":"MOD(C7+2,12)+1","v":5},{"$f":"C6+1","v":2},1006]
[1976,6,{"$f":"C7+1","v":3},1012]
[1976,7,4,1019]
[1976,8,5,1025]
[1976,9,6,1031]
[1976,10,7,1038]
[1976,11,8,1044]
[1976,12,9,1051]
[1977,1,10,1058]
[1977,2,11,1065]
[1977,3,12,1073]
[1977,4,13,1080]
[1977,5,14,1088]
[1977,6,15,1095]
[1977,7,16,1103]
[1977,8,17,1111]
[1977,9,18,1119]
[1977,10,19,1127]
[1977,11,20,1135]
[1977,12,21,1143]
[1978,1,22,1151]
[1978,2,23,1158]
[1978,3,24,1167]
[1978,4,25,1175]
[1978,5,26,1183]
[1978,6,27,1191]
[1978,7,28,1200]
[1978,8,29,1208]
[1978,9,30,1217]
[1978,10,31,1225]
[1978,11,32,1234]
[1978,12,33,1243]
[1979,1,34,1252]
[1979,2,35,1259]
[1979,3,36,1268]
[1979,4,37,1277]
[1979,5,38,1285]
[1979,6,39,1294]
[1979,7,40,1303]
[1979,8,41,1312]
[1979,9,42,1321]
[1979,10,43,1330]
[1979,11,44,1339]
[1979,12,45,1348]
[1980,1,46,1357]
[1980,2,47,1368]
[1980,3,48,1379]
[1980,4,49,1390]
[1980,5,50,1402]
[1980,6,51,1413]
[1980,7,52,1425]
[1980,8,53,1437]
[1980,9,54,1449]
[1980,10,55,1461]
[1980,11,56,1473]
[1980,12,57,1485]
[1981,1,58,1498]
[1981,2,59,1509]
[1981,3,60,1521]
[1981,4,61,1534]
[1981,5,62,1546]
[1981,6,63,1557]
[1981,7,64,1568]
[1981,8,65,1580]
[{"$f":"ROUNDDOWN((C71+2)/12,0)+1976","v":1981},{"$f":"MOD(C71+2,12)+1","v":9},66,1591]
[1981,10,{"$f":"C71+1","v":67},1603]
[1981,11,68,1615]
[1981,12,69,1629]
[1982,1,70,1643]
[1982,2,71,1656]
[1982,3,72,1670]
[1982,4,73,1683]
[1982,5,74,1695]
[1982,6,75,1707]
[1982,7,76,1719]
[1982,8,77,1732]
[1982,9,78,1744]
[1982,10,79,1757]
[1982,11,80,1768]
[1982,12,81,1779]
[1983,1,82,1790]
[1983,2,83,1800]
[1983,3,84,1811]
[1983,4,85,1822]
[1983,5,86,1833]
[1983,6,87,1844]
[1983,7,88,1855]
[1983,8,89,1867]
[1983,9,90,1880]
[1983,10,91,1892]
[1983,11,92,1905]
[1983,12,93,1918]
[1984,1,94,1931]
[1984,2,95,1943]
[1984,3,96,1956]
[1984,4,97,1967]
[1984,5,98,1979]
[1984,6,99,1990]
[1984,7,100,2002]
[1984,8,101,2016]
[1984,9,102,2031]
[1984,10,103,2045]
[1984,11,104,2058]
[1984,12,105,2071]
[1985,1,106,2085]
[1985,2,107,2098]
[1985,3,108,2113]
[1985,4,109,2128]
[1985,5,110,2143]
[1985,6,111,2158]
[1985,7,112,2174]
[1985,8,113,2189]
[1985,9,114,2204]
[1985,10,115,2219]
[1985,11,116,2232]
[1985,12,117,2247]
[1986,1,118,2261]
[1986,2,119,2274]
[1986,3,120,2289]
[1986,4,121,2303]
[1986,5,122,2318]
[1986,6,123,2333]
[1986,7,124,2348]
[1986,8,125,2363]
[1986,9,126,2377]
[1986,10,127,2393]
[1986,11,128,2409]
[1986,12,129,2426]
[{"$f":"ROUNDDOWN((C135+2)/12,0)+1976","v":1987},{"$f":"MOD(C135+2,12)+1","v":1},130,2443]
[1987,2,{"$f":"C135+1","v":131},2459]
[1987,3,132,2476]
[1987,4,133,2494]
[1987,5,134,2508]
[1987,6,135,2522]
[1987,7,136,2536]
[1987,8,137,2551]
[1987,9,138,2565]
[1987,10,139,2580]
[1987,11,140,2594]
[1987,12,141,2609]
[1988,1,142,2624]
[1988,2,143,2639]
[1988,3,144,2654]
[1988,4,145,2668]
[1988,5,146,2684]
[1988,6,147,2699]
[1988,7,148,2715]
[1988,8,149,2731]
[1988,9,150,2748]
[1988,10,151,2765]
[1988,11,152,2781]
[1988,12,153,2798]
[1989,1,154,2815]
[1989,2,155,2831]
[1989,3,156,2849]
[1989,4,157,2865]
[1989,5,158,2883]
[1989,6,159,2900]
[1989,7,160,2918]
[1989,8,161,2936]
[1989,9,162,2954]
[1989,10,163,2972]
[1989,11,164,2990]
[1989,12,165,3008]
[1990,1,166,3026]
[1990,2,167,3043]
[1990,3,168,3062]
[1990,4,169,3080]
[1990,5,170,3099]
[1990,6,171,3120]
[1990,7,172,3144]
[1990,8,173,3168]
[1990,9,174,3192]
[1990,10,175,3217]
[1990,11,176,3241]
[1990,12,177,3266]
[1991,1,178,3291]
[1991,2,179,3314]
[1991,3,180,3340]
[1991,4,181,3362]
[1991,5,182,3385]
[1991,6,183,3408]
[1991,7,184,3432]
[1991,8,185,3456]
[1991,9,186,3479]
[1991,10,187,3503]
[1991,11,188,3527]
[1991,12,189,3551]
[1992,1,190,3576]
[1992,2,191,3599]
[1992,3,192,3624]
[1992,4,193,3648]
[{"$f":"ROUNDDOWN((C199+2)/12,0)+1976","v":1992},{"$f":"MOD(C199+2,12)+1","v":5},194,3673]
[1992,6,{"$f":"C199+1","v":195},3696]
[1992,7,196,3720]
[1992,8,197,3744]
[1992,9,198,3766]
[1992,10,199,3787]
[1992,11,200,3806]
[1992,12,201,3824]
[1993,1,202,3842]
[1993,2,203,3858]
[1993,3,204,3877]
[1993,4,205,3895]
[1993,5,206,3913]
[1993,6,207,3931]
[1993,7,208,3950]
[1993,8,209,3969]
[1993,9,210,3987]
[1993,10,211,4006]
[1993,11,212,4024]
[1993,12,213,4043]
[1994,1,214,4061]
[1994,2,215,4077]
[1994,3,216,4096]
[1994,4,217,4113]
[1994,5,218,4132]
[1994,6,219,4150]
[1994,7,220,4168]
[1994,8,221,4187]
[1994,9,222,4206]
[1994,10,223,4226]
[1994,11,224,4246]
[1994,12,225,4266]
[1995,1,226,4287]
[1995,2,227,4306]
[1995,3,228,4326]
[1995,4,229,4347]
[1995,5,230,4368]
[1995,6,231,4388]
[1995,7,232,4409]
[1995,8,233,4431]
[1995,9,234,4451]
[1995,10,235,4473]
[1995,11,236,4494]
[1995,12,237,4516]
[1996,1,238,4537]
[1996,2,239,4556]
[1996,3,240,4576]
[1996,4,241,4596]
[1996,5,242,4616]
[1996,6,243,4636]
[1996,7,244,4657]
[1996,8,245,4677]
[1996,9,246,4697]
[1996,10,247,4718]
[1996,11,248,4738]
[1996,12,249,4759]
[1997,1,250,4780]
[1997,2,251,4800]
[1997,3,252,4821]
[1997,4,253,4841]
[1997,5,254,4863]
[1997,6,255,4884]
[1997,7,256,4905]
[1997,8,257,4927]
[{"$f":"ROUNDDOWN((C263+2)/12,0)+1976","v":1997},{"$f":"MOD(C263+2,12)+1","v":9},258,4948]
[1997,10,{"$f":"C263+1","v":259},4970]
[1997,11,260,4992]
[1997,12,261,5014]
[1998,1,262,5035]
[1998,2,263,5054]
[1998,3,264,5075]
[1998,4,265,5094]
[1998,5,266,5115]
[1998,6,267,5134]
[1998,7,268,5155]
[1998,8,269,5175]
[1998,9,270,5195]
[1998,10,271,5214]
[1998,11,272,5231]
[1998,12,273,5248]
[1999,1,274,5264]
[1999,2,275,5277]
[1999,3,276,5292]
[1999,4,277,5307]
[1999,5,278,5322]
[1999,6,279,5338]
[1999,7,280,5355]
[1999,8,281,5372]
[1999,9,282,5389]
[1999,10,283,5408]
[1999,11,284,5426]
[1999,12,285,5446]
[2000,1,286,5465]
[2000,2,287,5484]
[2000,3,288,5505]
[2000,4,289,5525]
[2000,5,290,5546]
[2000,6,291,5565]
[2000,7,292,5584]
[2000,8,293,5604]
[2000,9,294,5623]
[2000,10,295,5642]
[2000,11,296,5661]
[2000,12,297,5679]
[2001,1,298,5697]
[2001,2,299,5712]
[2001,3,300,5729]
[2001,4,301,5745]
[2001,5,302,5763]
[2001,6,303,5780]
[2001,7,304,5798]
[2001,8,305,5816]
[2001,9,306,5833]
[2001,10,307,5851]
[2001,11,308,5867]
[2001,12,309,5883]
[2002,1,310,5899]
[2002,2,311,5915]
[2002,3,312,5932]
[2002,4,313,5948]
[2002,5,314,5966]
[2002,6,315,5982]
[2002,7,316,5999]
[2002,8,317,6016]
[2002,9,318,6031]
[2002,10,319,6046]
[2002,11,320,6060]
[2002,12,321,6076]
[{"$f":"ROUNDDOWN((C327+2)/12,0)+1976","v":2003},{"$f":"MOD(C327+2,12)+1","v":1},322,6091]
[2003,2,{"$f":"C327+1","v":323},6104]
[2003,3,324,6118]
[2003,4,325,6131]
[2003,5,326,6145]
[2003,6,327,6159]
[2003,7,328,6172]
[2003,8,329,6185]
[2003,9,330,6199]
[2003,10,331,6215]
[2003,11,332,6231]
[2003,12,333,6248]
[2004,1,334,6266]
[2004,2,335,6283]
[2004,3,336,6300]
[2004,4,337,6316]
[2004,5,338,6333]
[2004,6,339,6351]
[2004,7,340,6370]
[2004,8,341,6389]
[2004,9,342,6407]
[2004,10,343,6426]
[2004,11,344,6444]
[2004,12,345,6460]
[2005,1,346,6477]
[2005,2,347,6492]
[2005,3,348,6508]
[2005,4,349,6524]
[2005,5,350,6541]
[2005,6,351,6557]
[2005,7,352,6574]
[2005,8,353,6589]
[2005,9,354,6605]
[2005,10,355,6620]
[2005,11,356,6636]
[2005,12,357,6652]
[2006,1,358,6668]
[2006,2,359,6683]
[2006,3,360,6699]
[2006,4,361,6716]
[2006,5,362,6733]
[2006,6,363,6751]
[2006,7,364,6769]
[2006,8,365,6787]
[2006,9,366,6804.34]
[2006,10,367,6823]
[2006,11,368,6840]
[2006,12,369,6859]
[2007,1,370,6877]
[2007,2,371,6895]
[2007,3,372,6915]
[2007,4,373,6935]
[2007,5,374,6955]
[2007,6,375,6975]
[2007,7,376,6998]
[2007,8,377,7020]
[2007,9,378,7042]
[2007,10,379,7065]
[2007,11,380,7085]
[2007,12,381,7103]
[2008,1,382,7122]
[2008,2,383,7139]
[2008,3,384,7157]
[2008,4,385,7172]
[{"$f":"ROUNDDOWN((C391+2)/12,0)+1976","v":2008},{"$f":"MOD(C391+2,12)+1","v":5},386,7189]
[2008,6,{"$f":"C391+1","v":387},7206]
[2008,7,388,7227]
[2008,8,389,7248]
[2008,9,390,7268]
[2008,10,391,7286]
[2008,11,392,7304]
[2008,12,393,7322]
[2009,1,394,7340]
[2009,2,395,7353]
[2009,3,396,7365]
[2009,4,397,7376]
[2009,5,398,7388]
[2009,6,399,7399]
[2009,7,400,7411]
[2009,8,401,7423]
[2009,9,402,7437]
[2009,10,403,7451]
[2009,11,404,7464]
[2009,12,405,7478]
[2010,1,406,7493]
[2010,2,407,7505]
[2010,3,408,7520]
[2010,4,409,7533]
[2010,5,410,7548]
[2010,6,411,7561]
[2010,7,412,7576]
[2010,8,413,7590]
[2010,9,414,7604]
[2010,10,415,7618]
[2010,11,416,7632]
[2010,12,417,7647]
[2011,{"$f":"MOD(C423+2,12)+1","v":1},418,7661]
[2011,{"$f":"MOD(C424+2,12)+1","v":2},419,7674]
[2011,{"$f":"MOD(C425+2,12)+1","v":3},420,7689]
[2011,4,421,7703]
[2011,5,422,7717]
[2011,6,423,7731]
[2011,7,424,7746]
[2011,8,425,7761]
[2011,9,426,7775]
[2011,10,427,7790]
[2011,11,428,7804]
[2011,12,429,7819]
[2012,{"$f":"MOD(C435+2,12)+1","v":1},430,7833]
[2012,{"$f":"MOD(C436+2,12)+1","v":2},431,7847]
[2012,{"$f":"MOD(C437+2,12)+1","v":3},432,7862]
[2012,4,433,7876]
[2012,5,434,7891]
[2012,6,435,7906]
[2012,7,436,7921]
[2012,8,437,7936]
[2012,9,438,7950]
[2012,10,439,7965]
[2012,11,440,7980]
[2012,12,441,7995]
[2013,1,442,8010]
[{"$f":"ROUNDDOWN((C448+2)/12,0)+1976","v":2013},2,443,8022]
[2013,3,444,8032]
[2013,4,445,8044]
[2013,5,446,8056]
[2013,6,447,8067]
[2013,7,448,8078]
[2013,8,449,8089]
[2013,9,450,8099]
[2013,10,{"$f":"C455+1","v":451},8110]
[2013,11,452,8121]
[2013,12,453,8132]
[2014,1,454,8143]
[2014,2,455,8153]
[2014,3,456,8164]
[2014,4,457,8174]
[2014,5,458,8185]
[2014,6,459,8196]
[2014,7,460,8207]
[2014,8,461,8218]
[2014,9,462,8229]
[2014,10,463,8240]
[2014,11,464,8251]
[2014,12,465,8262]
[2015,1,466,8273]
[2015,2,467,8283]
[2015,3,468,8294]
[2015,4,469,8305]
[2015,5,470,8316]
[2015,6,471,8327]
[2015,7,472,8338]
[2015,8,473,8350]
[2015,9,474,8360]
[2015,10,475,8372]
[2015,11,476,8383]
[2015,12,477,8394]
[2016,1,478,8405]
[2016,2,479,8416]
[2016,3,480,8427]
[2016,4,481,8438]
[2016,5,482,8450]
[2016,6,483,8461]
[2016,7,484,8472]
[2016,8,485,8483]
[2016,9,486,8495]
[2016,10,487,8506]
[2016,11,488,8517]
[2016,12,489,8529]
[2017,1,490,8540]
[2017,2,491,8550]
[2017,3,492,8562]
[2017,4,493,8573]
[2017,5,494,8585]
[2017,6,495,8595.89]
[2017,7,496,8607]
[2017,8,497,8619]
[2017,9,498,8630.33]
[2017,10,499,8641.9599999999991]
[2017,11,500,8655.3346611130146]
[2017,12,501,8671]
[2018,1,502,8687]
[2018,2,503,8701]
[2018,3,504,8717]
[2018,4,505,8732]
[2018,5,506,8748]
[2018,6,507,8763]
[2018,7,508,8779]
[2018,8,509,8795]
[2018,9,510,8810]
[2018,10,511,8826]
[2018,11,512,8841]
[2018,12,513,8857]
[2019,1,514,8873]
[2019,2,{"$f":"C519+1","v":515},8888]
[2019,3,516,8904]
[2019,4,517,8919]
[2019,5,518,8936]
[2019,6,519,8951]
[2019,7,520,8967]
[2019,8,521,8984]
[2019,9,522,8997]
[2019,10,523,9012]
[2019,11,524,9026]
[2019,12,525,9040]
[2020,1,526,9055]
[2020,2,527,9068]
[2020,3,528,9083]
[2020,4,529,9097]
[2020,5,530,9111]
[2020,6,531,9125]
[2020,7,532,9140]
[2020,8,533,9155]
[2020,9,534,9169]
[2020,10,535,9183]
[2020,11,536,9198]
[2020,12,537,9191.0300000000007]
[2021,1,538,9195]
[2021,2,539,9198]
[2021,3,540,9202]
[2021,4,541,9206]
[2021,5,542,9210]
[2021,6,543,9214]
[2021,7,544,9218]
[2021,8,545,9222]
[2021,9,546,9225]
[2021,10,547,9229]
[2021,11,548,9233]
[2021,12,549,9237]
[2022,1,550,9241]
[2022,2,551,9244]
[2022,3,552,9248]
[2022,4,553,9252]
[2022,5,554,9256]
[2022,6,555,9260]
[2022,7,556,9264]
[2022,8,557,9283]
[2022,9,558,9301]
[2022,10,559,9320]
[2022,11,560,9339]
[2022,12,561,9367]
[2023,1,562,9394]
[2023,2,563,9423]
[2023,3,564,9455]
[2023,4,565,9486]
[2023,5,566,9518]
[2023,6,567,9549]
[2023,7,568,9581]
[2023,8,569,9613]
[2023,9,570,9645]
[2023,10,571,9677]
[2023,11,572,9709]
[2023,12,573,9742]
[2024,1,574,9775]
[2024,2,575,9805]
[2024,3,576,9839]
[2024,4,577,9870]
[2024,5,578,9902]
[2024,6,579,9933]