{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Annex B for publication","Annex C for publication"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"Annex B for publication","index":0,"n_rows":596,"n_cols":4,"rows_kept":596,"cut":false,"hidden":false,"merged":[]}
["MULTIPLIERS FOR PRESERVED PENSIONS AND PRESERVED LUMP SUMS"]
[]
["A pension or lump sum which (a) becomes payable on or after 10 April 2023, or"]
["(b) becomes eligible for payment of pensions increases on or after that date because of a"]
["qualifying condition is satisfied, should have the appropriate multiplier below applied to the"]
["basic pension and lump sum (if appropriate)."]
[]
[null,null,null,"Multiplier"]
[null,"Any year up to 1945",null,57.083199999999998]
[null,"During 1945",null,48.311199999999999]
[null,"During 1946",null,43.915900000000001]
[null,"During 1947",null,43.523099999999999]
[null,"During 1948",null,40.755000000000003]
[null,"During 1949",null,39.632800000000003]
[null,"During 1950",null,38.510599999999997]
[null,"During 1951",null,35.274900000000002]
[null,"During 1952",null,32.319699999999997]
[null,"During 1953",null,31.328399999999998]
[null,"During 1954",null,30.767299999999999]
[null,"During 1955",null,29.439399999999999]
[null,"During 1956",null,28.074000000000002]
[null,"During 1957",null,27.082699999999999]
[null,"During 1958",null,26.259799999999998]
[null,"During 1959",null,26.128799999999998]
[null,"During 1960",null,25.867000000000001]
[null,"During 1961",null,25.025300000000001]
[null,"During 1962",null,23.977900000000002]
[null,"During 1963",null,23.5291]
[null,"During 1964",null,22.780899999999999]
[null,"During 1965",null,21.733499999999999]
[null,"During 1966",null,20.910599999999999]
[null,"During 1967",null,20.4056]
[null,"During 1968",null,19.489100000000001]
["1969-01-01","To ","1969-04-01",18.703499999999998]
["1969-04-02","To ","1969-10-01",18.386500000000002]
["1969-10-02","To ","1970-04-01",18.069500000000001]
["1970-04-02","To ","1970-10-01",17.435500000000001]
["1970-10-02","To ","1971-04-01",16.801500000000001]
["1971-04-02","To ","1971-10-01",16.0091]
["1971-10-02","To ","1972-04-01",15.2303]
["1972-04-02","To ","1972-07-01",14.9274]
["1972-07-02","To ","1973-01-01",14.5678]
["1973-01-02","To   *","1973-07-01",14.000400000000001]
["1973-07-02","To   *","1974-01-01",13.3767]
["1974-01-02","To   *","1974-07-01",12.7197]
["1974-07-02","To   *","1975-01-01",11.614000000000001]
["1975-01-02","To   *","1975-07-01",10.7697]
["1975-07-02","To   *","1976-01-01",9.4084000000000003]
[]
["* These pensions may also be affected by the Pensions (Increase) Act 1974. The"]
["Act does not apply to lump sums and other non-recurrent payments."]
["1976-01-02","to","1976-07-01",8.5875561806016005]
["1976-07-02","to","1977-01-01",8.0136826207535012]
["1977-01-02","to","1977-07-01",7.4704957652882014]
["1977-07-02","to","1978-01-01",6.8433776305416005]
["1978-01-02","to","1978-07-01",6.5873753651655003]
["1978-07-02","to","1978-07-27",6.6368964089772007]
["1978-07-28","to","1978-08-27",6.5615382988996007]
["1978-08-28","to","1978-09-27",6.4807974666736001]
["1978-09-28","to","1978-10-27",6.4054393565960002]
["1978-10-28","to","1978-11-27",6.3246985243700014]
["1978-11-28","to","1978-12-27",6.2439576921439999]
["1978-12-28","to","1979-01-27",6.1685995820663999]
["1979-01-28","to","1979-02-27",6.0878587498404002]
["1979-02-28","to","1979-03-27",6.0125006397628002]
["1979-03-28","to","1979-04-27",5.9317598075368005]
["1979-04-28","to","1979-05-27",5.8564016974592006]
["1979-05-28","to","1979-06-27",5.7756608652332]
["1979-06-28","to","1979-07-27",5.6949200330072003]
["1979-07-28","to","1979-08-27",5.6195619229296003]
["1979-08-28","to","1979-09-27",5.5388210907035997]
["1979-09-28","to","1979-10-27",5.4634629806259998]
["1979-10-28","to","1979-12-08",5.3827221483514993]
["1979-12-09","to","1980-01-08",5.3180370753240993]
["1980-01-09","to","1980-02-08",5.2579723646557994]
["1980-02-09","to","1980-03-08",5.1932872916284003]
["1980-03-09","to","1980-04-08",5.1286022186010003]
["1980-04-09","to","1980-05-08",5.0639171455736003]
["1980-05-09","to","1980-06-08",5.0038524349052995]
["1980-06-09","to","1980-07-08",4.9391673618778995]
["1980-07-09","to","1980-08-08",4.8744822888504995]
["1980-08-09","to","1980-09-08",4.8097972158230995]
["1980-09-09","to","1980-10-08",4.7497325051547996]
["1980-10-09","to","1980-11-08",4.6850474321273996]
["1980-11-09","to","1980-12-07",4.6203623591140399]
["1980-12-08","to","1981-01-07",4.58858836526354]
["1981-01-08","to","1981-02-07",4.5563907181617003]
["1981-02-08","to","1981-03-07",4.5246167243112003]
["1981-03-08","to","1981-04-07",4.4924190772093606]
["1981-04-08","to","1981-05-07",4.4606450833588598]
["1981-05-08","to","1981-06-07",4.4284474362570201]
["1981-06-08","to","1981-07-07",4.3966734424065201]
["1981-07-08","to","1981-08-07",4.3644757953046804]
["1981-08-08","to","1981-09-07",4.3327018014541796]
["1981-09-08","to","1981-10-07",4.3005041543523399]
["1981-10-08","to","1981-11-07",4.2687301605018408]
["1981-11-08","to","1981-12-06",4.2365325133800003]
["1981-12-07","to","1982-01-06",4.2021822497579997]
["1982-01-07","to","1982-02-06",4.167831986136]
["1982-02-07","to","1982-03-06",4.1334817225139995]
["1982-03-07","to","1982-04-06",4.0953147629339997]
["1982-04-07","to","1982-05-06",4.060964499312]
["1982-05-07","to","1982-06-06",4.0266142356899994]
["1982-06-07","to","1982-07-06",3.9922639720680002]
["1982-07-07","to","1982-08-06",3.9579137084459997]
["1982-08-07","to","1982-09-06",3.923563444824]
["1982-09-07","to","1982-10-06",3.8853964852440002]
["1982-10-07","to","1982-11-06",3.8510462216219996]
["1982-11-07","to","1982-12-05",3.8166959579987001]
["1982-12-06","to","1983-01-05",3.8056544074934004]
["1983-01-06","to","1983-02-05",3.7946128569880999]
["1983-02-06","to","1983-03-05",3.7835713064828003]
["1983-03-06","to","1983-04-05",3.7725297559774997]
["1983-04-06","to","1983-05-05",3.7614882054722001]
["1983-05-06","to","1983-06-05",3.7504466549669]
["1983-06-06","to","1983-07-05",3.7357245876264997]
["1983-07-06","to","1983-08-05",3.7246830371212001]
["1983-08-06","to","1983-09-05",3.7136414866159]
["1983-09-06","to","1983-10-05",3.7025999361106003]
["1983-10-06","to","1983-11-05",3.6915583856052998]
["1983-11-06","to","1983-12-10",3.6805168350526998]
["1983-12-11","to","1984-01-10",3.6665091591818997]
["1984-01-11","to","1984-02-10",3.6525014833110996]
["1984-02-11","to","1984-03-10",3.6349918884726002]
["1984-03-11","to","1984-04-10",3.6209842126018001]
["1984-04-11","to","1984-05-10",3.606976536731]
["1984-05-11","to","1984-06-10",3.5929688608602]
["1984-06-11","to","1984-07-10",3.5754592660216997]
["1984-07-11","to","1984-08-10",3.5614515901508996]
["1984-08-11","to","1984-09-10",3.5474439142800995]
["1984-09-11","to","1984-10-10",3.5334362384092994]
["1984-10-11","to","1984-11-10",3.5159266435708001]
["1984-11-11","to","1984-12-09",3.5019189676570002]
["1984-12-10","to","1985-01-09",3.4822820388664]
["1985-01-10","to","1985-02-09",3.4626451100757998]
["1985-02-10","to","1985-03-09",3.4462810027502995]
["1985-03-10","to","1985-04-09",3.4266440739596997]
["1985-04-10","to","1985-05-09",3.4070071451690995]
["1985-05-10","to","1985-06-09",3.3873702163784998]
["1985-06-10","to","1985-07-09",3.3677332875878996]
["1985-07-10","to","1985-08-09",3.3480963587972994]
["1985-08-10","to","1985-09-09",3.3317322514718]
["1985-09-10","to","1985-10-09",3.3120953226811998]
["1985-10-10","to","1985-11-09",3.2924583938906]
["1985-11-10","to","1985-12-12",3.2728214651487]
["1985-12-13","to","1986-01-12",3.2682893681643206]
["1986-01-13","to","1986-02-12",3.2640809923931102]
["1986-02-13","to","1986-03-12",3.2595488954087299]
["1986-03-13","to","1986-04-12",3.2550167984243505]
["1986-04-13","to","1986-05-12",3.2504847014399703]
["1986-05-13","to","1986-06-12",3.2462763256687599]
["1986-06-13","to","1986-07-12",3.2417442286843805]
["1986-07-13","to","1986-08-21",3.2372121317102995]
["1986-08-22","to","1986-09-21",3.2289684965071199]
["1986-09-22","to","1986-10-21",3.2207248613039399]
["1986-10-22","to","1986-11-21",3.2121641632083295]
["1986-11-22","to","1986-12-21",3.2039205280051499]
["1986-12-22","to","1987-01-21",3.1956768928019699]
["1987-01-22","to","1987-02-21",3.1874332575987903]
["1987-02-22","to","1987-03-21",3.1788725595031795]
["1987-03-22","to","1987-04-26",3.1706289242914001]
["1987-04-27","to","1987-05-26",3.15997901907545]
["1987-05-27","to","1987-06-26",3.1493291138594999]
["1987-06-27","to","1987-07-26",3.1386792086435502]
["1987-07-27","to","1987-08-26",3.1280293034276001]
["1987-08-27","to","1987-09-26",3.11737939821165]
["1987-09-27","to","1987-10-26",3.1067294929956999]
["1987-10-27","to","1987-11-26",3.0960795877797502]
["1987-11-27","to","1987-12-26",3.0854296825638001]
["1987-12-27","to","1988-01-26",3.07477977734785]
["1988-01-27","to","1988-02-26",3.0641298721318999]
["1988-02-27","to","1988-03-26",3.0534799669159502]
["1988-03-27","to","1988-04-25",3.0428300617169999]
["1988-04-26","to","1988-05-25",3.0287508669083003]
["1988-05-26","to","1988-06-25",3.0146716720995999]
["1988-06-26","to","1988-07-25",3.0005924772909003]
["1988-07-26","to","1988-08-25",2.9862259519758996]
["1988-08-26","to","1988-09-25",2.9721467571672]
["1988-09-26","to","1988-10-25",2.9580675623585004]
["1988-10-26","to","1988-11-25",2.9439883675498]
["1988-11-26","to","1988-12-25",2.9299091727411004]
["1988-12-26","to","1989-01-25",2.9155426474260997]
["1989-01-26","to","1989-02-25",2.9014634526174001]
["1989-02-26","to","1989-03-25",2.8873842578086997]
["1989-03-26","to","1989-04-24",2.8733050629552004]
["1989-04-25","to","1989-05-24",2.8564818084044403]
["1989-05-25","to","1989-06-24",2.8393915180671598]
["1989-06-25","to","1989-07-24",2.8225682635164002]
["1989-07-25","to","1989-08-24",2.8057450089656402]
["1989-08-25","to","1989-09-24",2.7886547186283601]
["1989-09-25","to","1989-10-24",2.7718314640776001]
["1989-10-25","to","1989-11-24",2.7550082095268404]
["1989-11-25","to","1989-12-24",2.7379179191895604]
["1989-12-25","to","1990-01-24",2.7210946646387999]
["1990-01-25","to","1990-02-24",2.7042714100880398]
["1990-02-25","to","1990-03-24",2.6871811197507602]
["1990-03-25","to","1990-04-23",2.6703578651579001]
["1990-04-24","to","1990-05-23",2.6484460017016902]
["1990-05-24","to","1990-06-23",2.6265341382454799]
["1990-06-24","to","1990-07-23",2.6048630644975801]
["1990-07-24","to","1990-08-23",2.5829512010413698]
["1990-08-24","to","1990-09-23",2.5610393375851603]
["1990-09-24","to","1990-10-23",2.53912747412895]
["1990-10-24","to","1990-11-23",2.5172156106727401]
["1990-11-24","to","1990-12-23",2.4953037472165298]
["1990-12-24","to","1991-01-23",2.47363267346863]
["1991-01-24","to","1991-02-23",2.4517208100124201]
["1991-02-24","to","1991-03-23",2.4298089465562103]
["1991-03-24","to","1991-04-21",2.4078970831271995]
["1991-04-22","to","1991-05-21",2.4000326738259199]
["1991-05-22","to","1991-06-21",2.3921682645246398]
["1991-06-22","to","1991-07-21",2.3843038552233597]
["1991-07-22","to","1991-08-21",2.3762081397661601]
["1991-08-22","to","1991-09-21",2.36834373046488]
["1991-09-22","to","1991-10-21",2.3604793211635999]
["1991-10-22","to","1991-11-21",2.3526149118623199]
["1991-11-22","to","1991-12-21",2.3447505025610398]
["1991-12-22","to","1992-01-21",2.3368860932597597]
["1992-01-22","to","1992-02-21",2.3287903778025596]
["1992-02-22","to","1992-03-21",2.32092596850128]
["1992-03-22","to","1992-04-27",2.3130615591971999]
["1992-04-28","to","1992-05-27",2.3063635044891]
["1992-05-28","to","1992-06-27",2.2996654497810001]
["1992-06-28","to","1992-07-27",2.2929673950728997]
["1992-07-28","to","1992-08-27",2.2862693403648002]
["1992-08-28","to","1992-09-27",2.2795712856566999]
["1992-09-28","to","1992-10-27",2.2728732309485999]
["1992-10-28","to","1992-11-27",2.2661751762404996]
["1992-11-28","to","1992-12-27",2.2594771215324001]
["1992-12-28","to","1993-01-27",2.2527790668242997]
["1993-01-28","to","1993-02-27",2.2460810121161998]
["1993-02-28","to","1993-03-27",2.2393829574080999]
["1993-03-28","to","1993-04-26",2.2326849027247997]
["1993-04-27","to","1993-05-26",2.2293950919643999]
["1993-05-27","to","1993-06-26",2.2261052812039996]
["1993-06-27","to","1993-07-26",2.2228154704435998]
["1993-07-27","to","1993-08-26",2.2195256596832]
["1993-08-27","to","1993-09-26",2.2162358489227998]
["1993-09-27","to","1993-10-26",2.2129460381623995]
["1993-10-27","to","1993-11-26",2.2096562274020002]
["1993-11-27","to","1993-12-26",2.2063664166415999]
["1993-12-27","to","1994-01-26",2.2030766058811997]
["1994-01-27","to","1994-02-26",2.1997867951207994]
["1994-02-27","to","1994-03-26",2.196523302846483]
["1994-03-27","to","1994-04-25",2.1932071736049998]
["1994-04-26","to","1994-05-25",2.1893443821054999]
["1994-05-26","to","1994-06-25",2.1852669910782501]
["1994-06-26","to","1994-07-25",2.1814041995787501]
["1994-07-26","to","1994-08-25",2.1775414080792497]
["1994-08-26","to","1994-09-25",2.1734640170519999]
["1994-09-26","to","1994-10-25",2.1696012255524999]
["1994-10-26","to","1994-11-25",2.1657384340530004]
["1994-11-26","to","1994-12-25",2.1616610430257501]
["1994-12-26","to","1995-01-25",2.1577982515262502]
["1995-01-26","to","1995-02-25",2.1539354600267502]
["1995-02-26","to","1995-03-25",2.1498580689994999]
["1995-03-26","to","1995-04-23",2.1459952775194999]
["1995-04-24","to","1995-05-23",2.1393858599179003]
["1995-05-24","to","1995-06-23",2.13256989801625]
["1995-06-24","to","1995-07-23",2.1259604804146504]
["1995-07-24","to","1995-08-23",2.1191445185130005]
["1995-08-24","to","1995-09-23",2.1125351009114]
["1995-09-24","to","1995-10-23",2.1057191390097505]
["1995-10-24","to","1995-11-23",2.09910972140815]
["1995-11-24","to","1995-12-23",2.0922937595065001]
["1995-12-24","to","1996-01-23",2.0856843419049]
["1996-01-24","to","1996-02-23",2.0788683800032501]
["1996-02-24","to","1996-03-23",2.0722589624016505]
["1996-03-24","to","1996-04-22",2.0654430004871998]
["1996-04-23","to","1996-05-22",2.0620039670877603]
["1996-05-23","to","1996-06-22",2.0583626376060002]
["1996-06-23","to","1996-07-22",2.05492360420656]
["1996-07-23","to","1996-08-22",2.0512822747247998]
["1996-08-23","to","1996-09-22",2.04784324132536]
["1996-09-23","to","1996-10-22",2.0442019118435999]
["1996-10-23","to","1996-11-22",2.04076287844416]
["1996-11-23","to","1996-12-22",2.0371215489623999]
["1996-12-23","to","1997-01-22",2.0336825155629601]
["1997-01-23","to","1997-02-22",2.0300411860812]
["1997-02-23","to","1997-03-22",2.0266021526817601]
["1997-03-23","to","1997-04-21",2.0229608232428]
["1997-04-22","to","1997-05-21",2.0171028285808998]
["1997-05-22","to","1997-06-21",2.0112448339190001]
["1997-06-22","to","1997-07-21",2.0053868392570999]
["1997-07-22","to","1997-08-21",1.9995288445952002]
["1997-08-22","to","1997-09-21",1.9936708499333]
["1997-09-22","to","1997-10-21",1.9878128552714001]
["1997-10-22","to","1997-11-21",1.9819548606094999]
["1997-11-22","to","1997-12-21",1.9760968659476001]
["1997-12-22","to","1998-01-21",1.9702388712857]
["1998-01-22","to","1998-02-21",1.9643808766238]
["1998-02-22","to","1998-03-21",1.9585228819618998]
["1998-03-22","to","1998-04-27",1.9526648873448]
["1998-04-28","to","1998-05-27",1.9475561710697702]
["1998-05-28","to","1998-06-27",1.9426366665086299]
["1998-06-28","to","1998-07-27",1.9375279502336]
["1998-07-28","to","1998-08-27",1.9324192339585702]
["1998-08-28","to","1998-09-27",1.9274997293974299]
["1998-09-28","to","1998-10-27",1.9223910131224]
["1998-10-28","to","1998-11-27",1.9172822968473702]
["1998-11-28","to","1998-12-27",1.9123627922862299]
["1998-12-28","to","1999-01-27",1.9072540760112]
["1999-01-28","to","1999-02-27",1.9021453597361702]
["1999-02-28","to","1999-03-27",1.8972258551750298]
["1999-03-28","to","1999-04-25",1.8921171388604998]
["1999-04-26","to","1999-05-25",1.8904327615855501]
["1999-05-26","to","1999-06-25",1.8887483843106003]
["1999-06-26","to","1999-07-25",1.8870640070356501]
["1999-07-26","to","1999-08-25",1.8851924767301502]
["1999-08-26","to","1999-09-25",1.8835080994552]
["1999-09-26","to","1999-10-25",1.8818237221802503]
["1999-10-26","to","1999-11-25",1.8801393449052999]
["1999-11-26","to","1999-12-25",1.8784549676303501]
["1999-12-26","to","2000-01-25",1.8767705903553999]
["2000-01-26","to","2000-02-25",1.8748990600499003]
["2000-02-26","to","2000-03-25",1.8732146827749498]
["2000-03-26","to","2000-04-24",1.8715303054788999]
["2000-04-25","to","2000-05-24",1.8666385999369901]
["2000-05-25","to","2000-06-24",1.8615657201157503]
["2000-06-25","to","2000-07-24",1.8566740145738401]
["2000-07-25","to","2000-08-24",1.8516011347526002]
["2000-08-25","to","2000-09-24",1.8467094292106903]
["2000-09-25","to","2000-10-24",1.84163654938945]
["2000-10-25","to","2000-11-24",1.8367448438475402]
["2000-11-25","to","2000-12-24",1.8316719640262999]
["2000-12-25","to","2001-01-24",1.82678025848439]
["2001-01-25","to","2001-02-24",1.8217073786631501]
["2001-02-25","to","2001-03-24",1.8168156731212399]
["2001-03-25","to","2001-04-23",1.8117427933223997]
["2001-04-24","to","2001-05-23",1.8092487521123199]
["2001-05-24","to","2001-06-23",1.8067547109022399]
["2001-06-24","to","2001-07-23",1.8042606696921597]
["2001-07-24","to","2001-08-23",1.8015884826813602]
["2001-08-24","to","2001-09-23",1.7990944414712799]
["2001-09-24","to","2001-10-23",1.7966004002611999]
["2001-10-24","to","2001-11-23",1.7941063590511201]
["2001-11-24","to","2001-12-23",1.7916123178410399]
["2001-12-24","to","2002-01-23",1.7891182766309599]
["2002-01-24","to","2002-02-23",1.7864460896201597]
["2002-02-24","to","2002-03-23",1.7839520484100799]
["2002-03-24","to","2002-04-22",1.7814580071587998]
["2002-04-23","to","2002-05-22",1.7790056559198402]
["2002-05-23","to","2002-06-22",1.7765533046808799]
["2002-06-23","to","2002-07-22",1.7741009534419199]
["2002-07-23","to","2002-08-22",1.7714734342573202]
["2002-08-23","to","2002-09-22",1.7690210830183601]
["2002-09-23","to","2002-10-22",1.7665687317793999]
["2002-10-23","to","2002-11-22",1.7641163805404403]
["2002-11-23","to","2002-12-22",1.76166402930148]
["2002-12-23","to","2003-01-22",1.75921167806252]
["2003-01-23","to","2003-02-22",1.7565841588779199]
["2003-02-23","to","2003-03-22",1.75413180763896]
["2003-03-23","to","2003-04-27",1.7516794563984002]
["2003-04-28","to","2003-05-27",1.7477603292099602]
["2003-05-28","to","2003-06-27",1.7436708051872403]
["2003-06-28","to","2003-07-27",1.7397516779988]
["2003-07-28","to","2003-08-27",1.73583255081036]
["2003-08-28","to","2003-09-27",1.7317430267876401]
["2003-09-28","to","2003-10-27",1.7278238995992001]
["2003-10-28","to","2003-11-27",1.7239047724107601]
["2003-11-28","to","2003-12-27",1.7198152483880402]
["2003-12-28","to","2004-01-27",1.7158961211996]
["2004-01-28","to","2004-02-27",1.71197699401116]
["2004-02-28","to","2004-03-27",1.7078874699884401]
["2004-03-28","to","2004-04-26",1.7039683428371999]
["2004-04-27","to","2004-05-26",1.6996712354740799]
["2004-05-27","to","2004-06-26",1.69537412811096]
["2004-06-27","to","2004-07-26",1.6912422941079601]
["2004-07-27","to","2004-08-26",1.68694518674484]
["2004-08-27","to","2004-09-26",1.68264807938172]
["2004-09-27","to","2004-10-26",1.6783509720186001]
["2004-10-27","to","2004-11-26",1.6740538646554799]
["2004-11-27","to","2004-12-26",1.6697567572923599]
["2004-12-27","to","2005-01-26",1.6656249232893601]
["2005-01-27","to","2005-02-26",1.6613278159262401]
["2005-02-27","to","2005-03-26",1.65703070856312]
["2005-03-27","to","2005-04-25",1.6527336011523999]
["2005-04-26","to","2005-05-25",1.6491931786377598]
["2005-05-26","to","2005-06-25",1.6454918278269999]
["2005-06-26","to","2005-07-25",1.6419514053123598]
["2005-07-26","to","2005-08-25",1.6382500545015999]
["2005-08-26","to","2005-09-25",1.6347096319869601]
["2005-09-26","to","2005-10-25",1.6310082811762001]
["2005-10-26","to","2005-11-25",1.6274678586615601]
["2005-11-26","to","2005-12-25",1.6237665078507997]
["2005-12-26","to","2006-01-25",1.6202260853361599]
["2006-01-26","to","2006-02-25",1.6165247345253999]
["2006-02-26","to","2006-03-25",1.6129843120107599]
["2006-03-26","to","2006-04-24",1.6092829612412001]
["2006-04-25","to","2006-05-24",1.6046228754460998]
["2006-05-25","to","2006-06-24",1.599962789651]
["2006-06-25","to","2006-07-24",1.5953027038559]
["2006-07-25","to","2006-08-24",1.5906426180608]
["2006-08-25","to","2006-09-24",1.5859825322657]
["2006-09-25","to","2006-10-24",1.5813224464706002]
["2006-10-25","to","2006-11-24",1.5766623606754999]
["2006-11-25","to","2006-12-24",1.5720022748804001]
["2006-12-25","to","2007-01-24",1.5673421890852999]
["2007-01-25","to","2007-02-24",1.5626821032902001]
["2007-02-25","to","2007-03-24",1.5580220174950998]
["2007-03-25","to","2007-04-22",1.5533619316932998]
["2007-04-23","to","2007-05-22",1.5485777563502601]
["2007-05-23","to","2007-06-22",1.5436440755277498]
["2007-06-23","to","2007-07-22",1.5388599001847101]
["2007-07-23","to","2007-08-22",1.5339262193621999]
["2007-08-23","to","2007-09-22",1.5291420440191599]
["2007-09-23","to","2007-10-22",1.5242083631966501]
["2007-10-23","to","2007-11-22",1.5194241878536099]
["2007-11-23","to","2007-12-22",1.5144905070310997]
["2007-12-23","to","2008-01-22",1.5097063316880599]
["2008-01-23","to","2008-02-22",1.5047726508655499]
["2008-02-23","to","2008-03-22",1.4999884755225101]
["2008-03-23","to","2008-04-21",1.4950547946600001]
["2008-04-22","to","2008-05-21",1.4890745754813601]
["2008-05-22","to","2008-06-21",1.4832367424736401]
["2008-06-22","to","2008-07-21",1.4772565232950001]
["2008-07-22","to","2008-08-21",1.4712763041163603]
["2008-08-22","to","2008-09-21",1.4654384711086399]
["2008-09-22","to","2008-10-21",1.4594582519299999]
["2008-10-22","to","2008-11-21",1.4534780327513599]
["2008-11-22","to","2008-12-21",1.4476401997436401]
["2008-12-22","to","2009-01-21",1.4416599805650001]
["2009-01-22","to","2009-02-21",1.4356797613863601]
["2009-02-22","to","2009-03-21",1.4298419283786401]
["2009-03-22","to","2009-04-27",1.4238617092000001]
["2009-04-28","to","2009-05-27",1.4238617092000001]
["2009-05-28","to","2009-06-27",1.4238617092000001]
["2009-06-28","to","2009-07-27",1.4238617092000001]
["2009-07-28","to","2009-08-27",1.4238617092000001]
["2009-08-28","to","2009-09-27",1.4238617092000001]
["2009-09-28","to","2009-10-27",1.4238617092000001]
["2009-10-28","to","2009-11-27",1.4238617092000001]
["2009-11-28","to","2009-12-27",1.4238617092000001]
["2009-12-28","to","2010-01-27",1.4238617092000001]
["2010-01-28","to","2010-02-27",1.4238617092000001]
["2010-02-28","to","2010-03-27",1.4238617092000001]
["2010-03-28","to","2010-04-26",1.4238617092194998]
["2010-04-27","to","2010-05-26",1.4202709813397998]
["2010-05-27","to","2010-06-26",1.4166802534601]
["2010-06-27","to","2010-07-26",1.41322763049885]
["2010-07-27","to","2010-08-26",1.4096369026191498]
["2010-08-27","to","2010-09-26",1.4060461747394499]
["2010-09-27","to","2010-10-26",1.4024554468597501]
["2010-10-27","to","2010-11-26",1.3988647189800498]
["2010-11-27","to","2010-12-26",1.3952739911003498]
["2010-12-27","to","2011-01-26",1.3918213681390998]
["2011-01-27","to","2011-02-26",1.3882306402594]
["2011-02-27","to","2011-03-26",1.3846399123796997]
["2011-03-27","to","2011-04-24",1.3810491844868]
["2011-04-25","to","2011-05-24",1.3754042115844303]
["2011-05-25","to","2011-06-24",1.3696279602424699]
["2011-06-25","to","2011-07-24",1.3639829873400999]
["2011-07-25","to","2011-08-24",1.3583380144377299]
["2011-08-25","to","2011-09-24",1.35256176309577]
["2011-09-25","to","2011-10-24",1.3469167901934]
["2011-10-25","to","2011-11-24",1.3412718172910301]
["2011-11-25","to","2011-12-24",1.3354955659490702]
["2011-12-25","to","2012-01-24",1.3298505930466999]
["2012-01-25","to","2012-02-24",1.32420562014433]
["2012-02-25","to","2012-03-24",1.31842936880237]
["2012-03-25","to","2012-04-23",1.3127843958824001]
["2012-04-24","to","2012-05-23",1.31047225115384]
["2012-05-24","to","2012-06-23",1.30803165394036]
["2012-06-24","to","2012-07-23",1.3057195092118001]
["2012-07-24","to","2012-08-23",1.30340736448324]
["2012-08-24","to","2012-09-23",1.30096676726976]
["2012-09-24","to","2012-10-23",1.2986546225411999]
["2012-10-24","to","2012-11-23",1.2963424778126402]
["2012-11-24","to","2012-12-23",1.2939018805991602]
["2012-12-24","to","2013-01-23",1.2915897358706001]
["2013-01-24","to","2013-02-23",1.2892775911420402]
["2013-02-24","to","2013-03-23",1.2868369939285602]
["2013-03-24","to","2013-04-22",1.2845248492140999]
["2013-04-23","to","2013-05-22",1.2817731893618398]
["2013-05-23","to","2013-06-22",1.27889645406175]
["2013-06-23","to","2013-07-22",1.2761447942094899]
["2013-07-23","to","2013-08-22",1.2732680589094001]
["2013-08-23","to","2013-09-22",1.27051639905714]
["2013-09-23","to","2013-10-22",1.26763966375705]
["2013-10-23","to","2013-11-22",1.2648880039047901]
["2013-11-23","to","2013-12-22",1.2620112686046998]
["2013-12-23","to","2014-01-22",1.2592596087524399]
["2014-01-23","to","2014-02-22",1.2563828734523499]
["2014-02-23","to","2014-03-22",1.25363121360009]
["2014-03-23","to","2014-04-21",1.25075447827]
["2014-04-22","to","2014-05-21",1.2495185548724999]
["2014-05-22","to","2014-06-21",1.248282631475]
["2014-06-22","to","2014-07-21",1.2470467080774998]
["2014-07-22","to","2014-08-21",1.2458107846799999]
["2014-08-22","to","2014-09-21",1.2445748612824998]
["2014-09-22","to","2014-10-21",1.2433389378849999]
["2014-10-22","to","2014-11-21",1.2421030144874998]
["2014-11-22","to","2014-12-21",1.2408670910899999]
["2014-12-22","to","2015-01-21",1.2396311676924998]
["2015-01-22","to","2015-02-21",1.2383952442949999]
["2015-02-22","to","2015-03-21",1.2371593208974998]
["2015-03-22","to","2015-04-26",1.2359233974999999]
["2015-04-27","to","2015-05-26",1.2359233974999999]
["2015-05-27","to","2015-06-26",1.2359233974999999]
["2015-06-27","to","2015-07-26",1.2359233974999999]
["2015-07-27","to","2015-08-26",1.2359233974999999]
["2015-08-27","to","2015-09-26",1.2359233974999999]
["2015-09-27","to","2015-10-26",1.2359233974999999]
["2015-10-27","to","2015-11-26",1.2359233974999999]
["2015-11-27","to","2015-12-26",1.2359233974999999]
["2015-12-27","to","2016-01-26",1.2359233974999999]
["2016-01-27","to","2016-02-26",1.2359233974999999]
["2016-02-27","to","2016-03-26",1.2359233974999999]
["2016-03-27","to","2016-04-25",1.2359233975219999]
["2016-04-26","to","2016-05-25",1.2349444482962399]
["2016-05-26","to","2016-06-25",1.2338431304172599]
["2016-06-26","to","2016-07-25",1.2328641811915]
["2016-07-26","to","2016-08-25",1.2318852319657398]
["2016-08-26","to","2016-09-25",1.23078391408676]
["2016-09-26","to","2016-10-25",1.2298049648609997]
["2016-10-26","to","2016-11-25",1.22882601563524]
["2016-11-26","to","2016-12-25",1.2277246977562599]
["2016-12-26","to","2017-01-25",1.2267457485304998]
["2017-01-26","to","2017-02-25",1.2257667993047399]
["2017-02-26","to","2017-03-25",1.2246654814257598]
["2017-03-26","to","2017-04-24",1.2236865322070001]
["2017-04-25","to","2017-05-24",1.2207164192647502]
["2017-05-25","to","2017-06-24",1.2177463063224998]
["2017-06-25","to","2017-07-24",1.2147761933802499]
["2017-07-25","to","2017-08-24",1.211806080438]
["2017-08-25","to","2017-09-24",1.2088359674957501]
["2017-09-25","to","2017-10-24",1.2058658545534999]
["2017-10-25","to","2017-11-24",1.20289574161125]
["2017-11-25","to","2017-12-24",1.1999256286690001]
["2017-12-25","to","2018-01-24",1.19695551572675]
["2018-01-25","to","2018-02-24",1.1939854027844998]
["2018-02-25","to","2018-03-24",1.1910152898422499]
["2018-03-25","to","2018-04-23",1.1880451769344]
["2018-04-24","to","2018-05-23",1.1857247761981999]
["2018-05-24","to","2018-06-23",1.1834043754620001]
["2018-06-24","to","2018-07-23",1.1810839747258]
["2018-07-24","to","2018-08-23",1.1787635739895999]
["2018-08-24","to","2018-09-23",1.1764431732534]
["2018-09-24","to","2018-10-23",1.1741227725171999]
["2018-10-24","to","2018-11-23",1.171802371781]
["2018-11-24","to","2018-12-23",1.1694819710447999]
["2018-12-24","to","2019-01-23",1.1671615703086]
["2019-01-24","to","2019-02-23",1.1648411695723999]
["2019-02-24","to","2019-03-23",1.1625207688362]
["2019-03-24","to","2019-04-21",1.1602003681349999]
["2019-04-22","to","2019-05-21",1.1586032388180001]
["2019-05-22","to","2019-06-21",1.157006109501]
["2019-06-22","to","2019-07-21",1.155408980184]
["2019-07-22","to","2019-08-21",1.1536977702015001]
["2019-08-22","to","2019-09-21",1.1521006408845]
["2019-09-22","to","2019-10-21",1.1505035115675]
["2019-10-22","to","2019-11-21",1.1489063822505001]
["2019-11-22","to","2019-12-21",1.1473092529335001]
["2019-12-22","to","2020-01-21",1.1457121236165]
["2020-01-22","to","2020-02-21",1.1440009136339999]
["2020-02-22","to","2020-03-21",1.1424037843170001]
["2020-03-22","to","2020-04-27",1.1408066549999998]
["2020-04-28","to","2020-05-27",1.1403526025999997]
["2020-05-28","to","2020-06-27",1.1398985501999999]
["2020-06-28","to","2020-07-27",1.1394444978]
["2020-07-28","to","2020-08-27",1.1388769323000001]
["2020-08-28","to","2020-09-27",1.1384228798999998]
["2020-09-28","to","2020-10-27",1.1379688274999997]
["2020-10-28","to","2020-11-27",1.1375147750999999]
["2020-11-28","to","2020-12-27",1.1370607227]
["2020-12-28","to","2021-01-27",1.1366066703]
["2021-01-28","to","2021-02-27",1.1360391047999998]
["2021-02-28","to","2021-03-27",1.1355850523999997]
["2021-03-28","to","2021-04-26",1.1351309999999999]
["2021-04-27","to","2021-05-26",1.1322684000000001]
["2021-05-27","to","2021-06-26",1.1294058]
["2021-06-27","to","2021-07-26",1.1266533000000001]
["2021-07-27","to","2021-08-26",1.1237906999999998]
["2021-08-27","to","2021-09-26",1.1209281]
["2021-09-27","to","2021-10-26",1.1180655000000002]
["2021-10-27","to","2021-11-26",1.1152028999999999]
["2021-11-27","to","2021-12-26",1.1123403000000001]
["2021-12-27","to","2022-01-26",1.1095877999999999]
["2022-01-27","to","2022-02-26",1.1067252000000001]
["2022-02-27","to","2022-03-26",1.1038625999999998]
[{"$f":"[1]CALCULATIONS!K575","v":"2022-03-27"},"to",{"$f":"[1]CALCULATIONS!M575","v":"2022-04-25"},1.101]
[{"$f":"[1]CALCULATIONS!K576","v":"2022-04-26"},"to",{"$f":"[1]CALCULATIONS!M576","v":"2022-05-25"},1.0926]
[{"$f":"[1]CALCULATIONS!K577","v":"2022-05-26"},"to",{"$f":"[1]CALCULATIONS!M577","v":"2022-06-25"},1.0842000000000001]
[{"$f":"[1]CALCULATIONS!K578","v":"2022-06-26"},"to",{"$f":"[1]CALCULATIONS!M578","v":"2022-07-25"},1.0758000000000001]
[{"$f":"[1]CALCULATIONS!K579","v":"2022-07-26"},"to",{"$f":"[1]CALCULATIONS!M579","v":"2022-08-25"},1.0672999999999999]
[{"$f":"[1]CALCULATIONS!K580","v":"2022-08-26"},"to",{"$f":"[1]CALCULATIONS!M580","v":"2022-09-25"},1.0589]
[{"$f":"[1]CALCULATIONS!K581","v":"2022-09-26"},"to",{"$f":"[1]CALCULATIONS!M581","v":"2022-10-25"},1.0505]
[{"$f":"[1]CALCULATIONS!K582","v":"2022-10-26"},"to",{"$f":"[1]CALCULATIONS!M582","v":"2022-11-25"},1.0421]
[{"$f":"[1]CALCULATIONS!K583","v":"2022-11-26"},"to",{"$f":"[1]CALCULATIONS!M583","v":"2022-12-25"},1.0337000000000001]
[{"$f":"[1]CALCULATIONS!K584","v":"2022-12-26"},"to",{"$f":"[1]CALCULATIONS!M584","v":"2023-01-25"},1.0253000000000001]
[{"$f":"[1]CALCULATIONS!K585","v":"2023-01-26"},"to",{"$f":"[1]CALCULATIONS!M585","v":"2023-02-25"},1.0167999999999999]
[{"$f":"[1]CALCULATIONS!K586","v":"2023-02-26"},"to",{"$f":"[1]CALCULATIONS!M586","v":"2023-03-25"},1.0084]
["Note: Some pensions beginning before 2 April 1971 may receive more favourable"]
["increases under the Pensions (Increase) Acts 1920 to 1969, preserved by the"]
["Pension (Preservation of Increases) Order 1971. (This order does not apply to lump"]
["sums, for which the multipliers listed above should be used.)"]

{"sheet":"Annex C for publication","index":1,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"ANNEX C"]
[]
[null,"INCREASES IN LUMP SUMS"]
[]
[null,"A.","Deferred lump sums which become payable on or after"]
[null,null,"10 April 2023."]
[]
[null,"These are eligible for the same increase as pensions which begin on the"]
[null,"same date as the lump sum begins (See Annex B)"]
[]
[null,"B.","Deferred lump sums which became payable in the period"]
[null,null,"11 April 2022 to 10 April 2023."]
[]
[null,"(i)","If the lump sum began before 11 April 2022, it may have been"]
[null,null,"eligible for increases under the Pensions (Increase) Act 1971."]
[null,null,"These should have been paid with the lump sum at the time it"]
[null,null,"became payable. A further increase is payable on xxx according"]
[null,null,"to the table below."]
[]
[null,"(ii)","In years where there is an increase, if the lump sum began on or"]
[null,null,"after April of the previous year (in this case it would have been"]
[null,null,"11 April 2022) an increase is payable in April (10 April 2023"]
[null,null,"in this case) according to the table below."]
[]
[null,"In calculating the length of period, count complete months starting with"]
[null,"the beginning date (or 11 April 2022 if later), and then count the remaining"]
[null,"days, excluding the payable date itself – "]
[]
[null,"eg 25 May to 7 July is 1 month (25 May to 24 June) and 12 days"]
[null,"(25 June to 6 July)."]
[null,"Length of Period",null,null,null,null,null,"Percentage Increase"]
[]
[null,null,"16 days","to","1 month","15 days",null,0.84]
[null,"1 month","16 days","to","2 months","15 days",null,1.68]
[null,"2 months","16 days","to","3 months","15 days",null,2.5299999999999998]
[null,"3 months","16 days","to","4 months","15 days",null,3.37]
[null,"4 months","16 days","to","5 months","15 days",null,4.21]
[null,"5 months","16 days","to","6 months","15 days",null,5.05]
[null,"6 months","16 days","to","7 months","15 days",null,5.89]
[null,"7 months","16 days","to","8 months","15 days",null,6.73]
[null,"8 months","16 days","to","9 months","15 days",null,7.58]
[null,"9 months","16 days","to","10 months","15 days",null,8.42]
[null,"10 months","16 days","to","11 months","15 days",null,9.26]
[null,"11 months","16 days","to","12 months","15 days",null,10.1]
[null,"It is not possible for the period to exceed 11 Months 29 days"]
[null,"if correctly calculated."]