{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Map & Key","Inputs","Time","Indexation","Calc"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":39,"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":"Cover","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,3,7,4]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,null,"Model name:","PR19 RCV indexation illustrated model"]
[null,null,"Version number:","Version 1"]
[null,null,"Filename:",{"$f":"SUBSTITUTE(LEFT(CELL(\"filename\"),FIND(\"]\",CELL(\"filename\"))-1),\"[\",\"\")","v":"https://ofwat.sharepoint.com/sites/rms/pr-w20/fp-rr/Modelling - PR19 feeder models/Policy and Analysis/PR19 RCV indexation illustrated model.xlsm"}]
[null,null,"Date:","2017-12-13"]
[null,null,"Author:","Robert Thorp"]
[null,null,"Author contact information:","robert.thorp@ofwat.gsi.gov.uk"]
[null,null,null,"financial.modelling@ofwat.gsi.gov.uk"]
[]
[]
[null,null,"Summary of model:","The model is designed to provide a simplified illustration of the indexation of RCV that occurs between the RCV feeder model and the PR19 financial model."]
[null,null,null,"The inputs in this model are purely illustrative. They should not be taken as a statement of policy."]
[]
[]
[]
["End of sheet"]

{"sheet":"Map & Key","index":1,"n_rows":95,"n_cols":22,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Map & Key"}]
[]
[]
["MODEL MAP"]
[]
[null,null,null,null,null,"MODEL MAP"]
[]
[null,null,null,null,null,null,null,"INPUTS",null,null,null,"CALCULATIONS",null,null,null,null,null,null,null,null,null,"DOCUMENTATION"]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"Inputs!$A$1","v":"Inputs"},null,null,null,{"$f":"Time!$A$1","v":"Time"},null,null,null,{"$f":"Calc!$A$1","v":"Calc"},null,null,null,null,null,{"$f":" $A$1","v":"Map & Key"}]
[null,null,null,null,null,null,null,"All the hardcoded inputs used in the model for calculation.",null,null,null,"The model timeline and flag calculations are done in this sheet.",null,null,null,"Calculation of RCV balance at different price bases",null,null,null,null,null,"Sheet references and model flow; Sheet tabs colours, colour coding, abbreviations, range names are mentioned in this sheet."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indexation!$A$1","v":"Indexation"}]
[null,null,null,null,null,null,null,null,null,null,null,"Key indexation calculations that appear in the RCV feeder model and PR19 financial model are repeated here."]
[]
[]
[]
[]
[]
[]
[]
["SHEET TABS"]
[]
[null,null,null,null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks & alerts"]
[null,null,null,null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,null,null,null,"Red shade",null,"Error"]
[]
[null,null,null,null,null,null,null,"Gold shade",null,"Alert"]
[]
[]
["ABBREVIATIONS"]
[]
[null,null,null,null,null,null,null,"CPIH","Consumer price index housing"]
[null,null,null,null,null,null,null,"RCV","Regulatory capital value"]
[null,null,null,null,null,null,null,"RPI","Retail price index"]
[null,null,null,null,null,null,null,"FYA","Financial Year Average"]
[null,null,null,null,null,null,null,"FYE","Financial Year Ending"]
[]
[]
["NAMES"]
[]
[null,null,null,null,null,null,null,"NO NAME RANGES PRESENT IN THE MODEL"]
[]
[]
["LIST OF MAIN FUNCTIONS USED"]
[]
[null,null,null,null,null,null,null,"SUMPRODUCT",null,"Multiplies corresponding components in the given arrays, and returns the sum of those products."]
[null,null,null,null,null,null,null,"MATCH",null,"The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range."]
[null,null,null,null,null,null,null,"INDEX",null,"Returns a value or the reference to a value from within a table or range, selected by the row and column number indexes"]
[null,null,null,null,null,null,null,"AVERAGE",null,"Returns the arithmetic mean of the arguments"]
[]
["End of sheet"]

{"sheet":"Inputs","index":2,"n_rows":146,"n_cols":21,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"FILENAME\", $A$1), LEN(CELL(\"FILENAME\", $A$1)) - SEARCH(\"]\", CELL(\"FILENAME\", $A$1)))","v":"Inputs"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[{"$f":" IF(COUNTIF(A6:A144,\"< 0\") + COUNTIF(A6:A144,\">0\") <> 0, 1, 0)","v":0},null,null,"Input references",{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[null,null,null,null,"[Used in formula range - Do not delete]"]
[]
["A: TIME"]
[]
[null,"Timeline setup"]
[]
[null,null,"Timeline start dates"]
[null,null,null,null,"1st model column start date","2012-04-01","date","Date should be the first date of the financial year"]
[]
[null,null,"Financial year inputs"]
[null,null,null,null,"First modelling column financial year#",2013,"year #","Financial model start year"]
[null,null,null,null,"Financial year end month number",3,"month #","Month of financial year end for financial model"]
[]
[null,null,"Timeline labels"]
[null,null,null,null,"Pre - forecast period","Pre-Fcst","label"]
[null,null,null,null,"Forecast period","Forecast","label"]
[null,null,null,null,"Post - forecast period","Post-Fcst","label"]
[]
[null,"Project dates"]
[]
[null,null,null,null,"Initial balance date ","2020-03-31","date"]
[null,null,null,null,"Forecast start date","2020-04-01","date"]
[null,null,null,null,"Forecast duration",5,"years"]
[null,null,null,null,"Forecast duration (text)",{"$f":" YEAR(F27) & \"-\" & TEXT(DATE(YEAR(F27) + F28, 1, 1), \"yy\")","v":"2020-25"},"years #"]
[]
[]
["B: INDEXATION"]
[]
[null,"CPIH INDEXATION"]
[]
[null,null,null,null,"Consumer Price Index for April",null,"index",null,null,95.9,98,99.6,99.9,100.6,103.2]
[null,null,null,null,"Consumer Price Index for May",null,"index",null,null,95.9,98.2,99.6,100.1,100.8,103.5]
[null,null,null,null,"Consumer Price Index for June",null,"index",null,null,95.6,98,99.8,100.1,101,{"$f":"O37+0.2","v":103.7}]
[null,null,null,null,"Consumer Price Index for July",null,"index",null,null,95.7,98,99.6,100,100.9,{"$f":"O38+0.2","v":103.9}]
[null,null,null,null,"Consumer Price Index for August",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,104.10000000000001]
[null,null,null,null,"Consumer Price Index for September",null,"index",null,null,96.4,98.7,100,100.2,101.5,104.30000000000001]
[null,null,null,null,"Consumer Price Index for October",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,104.50000000000001]
[null,null,null,null,"Consumer Price Index for November",null,"index",null,null,97,98.8,99.9,100.3,101.8,104.70000000000002]
[null,null,null,null,"Consumer Price Index for December",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,104.90000000000002]
[null,null,null,null,"Consumer Price Index for January",null,"index",null,null,97,98.7,99.2,99.9,101.8,105.10000000000002]
[null,null,null,null,"Consumer Price Index for February",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,105.30000000000003]
[null,null,null,null,"Consumer Price Index for March",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,105.50000000000003]
[]
[null,null,null,null,"CPIH: Assumed percentage increase for unpopulated monthly values",null,"%",null,null,null,null,null,null,null,null,0.02,0.02]
[]
[null,null,null,null,"Consumer Price Index for April",103.2,"index"]
[null,null,null,null,"Consumer Price Index for May",103.5,"index"]
[null,null,null,null,"Consumer Price Index for June",103.7,"index"]
[null,null,null,null,"Consumer Price Index for July",103.9,"index"]
[null,null,null,null,"Consumer Price Index for August",104.10000000000001,"index"]
[null,null,null,null,"Consumer Price Index for September",104.30000000000001,"index"]
[null,null,null,null,"Consumer Price Index for October",104.50000000000001,"index"]
[null,null,null,null,"Consumer Price Index for November",104.70000000000002,"index"]
[null,null,null,null,"Consumer Price Index for December",104.90000000000002,"index"]
[null,null,null,null,"Consumer Price Index for January",105.10000000000002,"index"]
[null,null,null,null,"Consumer Price Index for February",105.30000000000003,"index"]
[null,null,null,null,"Consumer Price Index for March",105.50000000000003,"index"]
[]
[]
[null,"RPI INDEXATION"]
[]
[null,null,null,null,"Retail Price Index for April",null,"index",null,null,242.5,249.5,255.7,258,261.39999999999998,270.60000000000002]
[null,null,null,null,"Retail Price Index for May",null,"index",null,null,242.4,250,255.9,258.5,262.10000000000002,271.7]
[null,null,null,null,"Retail Price Index for June",null,"index",null,null,241.8,249.7,256.3,258.89999999999998,263.10000000000002,{"$f":"O68+0.3","v":272}]
[null,null,null,null,"Retail Price Index for July",null,"index",null,null,242.1,249.7,256,258.60000000000002,263.39999999999998,{"$f":"O69+0.3","v":272.3}]
[null,null,null,null,"Retail Price Index for August",null,"index",null,null,243,251,257,259.8,264.39999999999998,272.60000000000002]
[null,null,null,null,"Retail Price Index for September",null,"index",null,null,244.2,251.9,257.60000000000002,259.60000000000002,264.89999999999998,272.90000000000003]
[null,null,null,null,"Retail Price Index for October",null,"index",null,null,245.6,251.9,257.7,259.5,264.8,273.20000000000005]
[null,null,null,null,"Retail Price Index for November",null,"index",null,null,245.6,252.1,257.10000000000002,259.8,265.5,273.50000000000006]
[null,null,null,null,"Retail Price Index for December",null,"index",null,null,246.8,253.4,257.5,260.60000000000002,267.10000000000002,273.80000000000007]
[null,null,null,null,"Retail Price Index for January",null,"index",null,null,245.8,252.6,255.4,258.8,265.5,274.10000000000008]
[null,null,null,null,"Retail Price Index for February",null,"index",null,null,247.6,254.2,256.7,260,268.39999999999998,274.40000000000009]
[null,null,null,null,"Retail Price Index for March",null,"index",null,null,248.7,254.8,257.10000000000002,261.10000000000002,269.3,274.7000000000001]
[]
[null,null,null,null,"RPI: Assumed percentage increase for unpopulated monthly values",null,"%",null,null,null,null,null,null,null,null,2.8000000000000001E-2,2.8000000000000001E-2]
[]
[null,"Inflation"]
[]
[null,null,null,null,"Year reference for FYA base price 1",2013,"year #"]
[null,null,null,null,"Year reference for FYA base price 2",2018,"year #"]
[null,null,null,null,"Year reference for FYE base price",2018,"year #"]
[null,null,null,null,"Year reference for FYE end price",2020,"year #"]
[]
[null,"Deflation"]
[]
[null,null,null,null,"Year reference for FYE base price",2020,"year #"]
[null,null,null,null,"Year reference for FYA end price",2018,"year #"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["C: RCV INPUTS"]
[]
[null,null,null,null,"RCV at 31 March 2020 (from PR14 FD) post adjustment",100,"£m","2012/13 FYA"]
[]
["D: NON CHANGEABLE MODEL TECHNICAL INPUTS"]
[]
[null,null,null,null,"Months per model period",12,"months"]
[]
[null,null,null,null,"Months in a year",12,"months"]
[]
[null,null,null,null,"Days in a year",365,"days"]
[]
[]
[null,null,null,null,"[Used in formula range - Do not delete]"]
[]
["End of sheet"]

{"sheet":"Time","index":3,"n_rows":111,"n_cols":21,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"FILENAME\", $A$1), LEN(CELL(\"FILENAME\", $A$1)) - SEARCH(\"]\", CELL(\"FILENAME\", $A$1)))","v":"Time"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[]
["MODEL PERIOD"]
[]
[null,"Model column counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I10 + 1","v":1},2,3,4,5,6,7,8,9,{"$f":" R10 + 1","v":10},{"$f":" S10 + 1","v":11},{"$f":" T10 + 1","v":12}]
[null,null,null,null,"Model column total",{"$f":" MAX(J10:U10)","v":12},"columns"]
[]
[null,null,null,null,{"$f":" E$10","v":"Model column counter"},0,"counter",0,0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,"1st model column flag",null,"flag",{"$f":" SUM(J14:U14)","v":1},null,{"$f":" IF(J13 = 1, 1, 0)","v":1},0,0,0,0,0,0,0,0,{"$f":" IF(S13 = 1, 1, 0)","v":0},{"$f":" IF(T13 = 1, 1, 0)","v":0},{"$f":" IF(U13 = 1, 1, 0)","v":0}]
[]
[null,"Model period beginning"]
[null,null,null,null,{"$f":" Inputs!E$13","v":"1st model column start date"},{"$f":" Inputs!F$13","v":"2012-04-01"},{"$f":" Inputs!G$13","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E$137","v":"Months per model period"},{"$f":" Inputs!F$137","v":12},{"$f":" Inputs!G$137","v":"months"}]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model period beginning",null,"date",null,null,{"$f":" IF(J19 = 1, $F17, DATE(YEAR(I20), MONTH(I20) + $F18, DAY(1)))","v":"2012-04-01"},"2013-04-01","2014-04-01","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01",{"$f":" IF(S19 = 1, $F17, DATE(YEAR(R20), MONTH(R20) + $F18, DAY(1)))","v":"2021-04-01"},{"$f":" IF(T19 = 1, $F17, DATE(YEAR(S20), MONTH(S20) + $F18, DAY(1)))","v":"2022-04-01"},{"$f":" IF(U19 = 1, $F17, DATE(YEAR(T20), MONTH(T20) + $F18, DAY(1)))","v":"2023-04-01"}]
[]
[null,"Model period ending"]
[null,null,null,null,{"$f":" Inputs!E$137","v":"Months per model period"},{"$f":" Inputs!F$137","v":12},{"$f":" Inputs!G$137","v":"months"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2012-04-01","2013-04-01","2014-04-01","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01"]
[null,null,null,null,"Model period ending",null,"date",null,null,{"$f":" DATE(YEAR(J24), MONTH(J24) + $F23, DAY(J24) - 1)","v":"2013-03-31"},"2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31",{"$f":" DATE(YEAR(S24), MONTH(S24) + $F23, DAY(S24) - 1)","v":"2022-03-31"},{"$f":" DATE(YEAR(T24), MONTH(T24) + $F23, DAY(T24) - 1)","v":"2023-03-31"},{"$f":" DATE(YEAR(U24), MONTH(U24) + $F23, DAY(U24) - 1)","v":"2024-03-31"}]
[]
[]
["FORECAST PERIOD"]
[]
[null,"Forecast start period flag"]
[null,null,null,null,{"$f":" Inputs!E$27","v":"Forecast start date"},{"$f":" Inputs!F$27","v":"2020-04-01"},{"$f":" Inputs!G$27","v":"date"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2012-04-01","2013-04-01","2014-04-01","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31"]
[null,null,null,null,"Forecast start period flag",null,"flag",{"$f":" SUM(J34:U34)","v":1},null,{"$f":" IF(AND($F31 >= J32, $F31 <= J33), 1, 0)","v":0},{"$f":" IF(AND($F31 >= K32, $F31 <= K33), 1, 0)","v":0},0,0,0,0,0,0,1,{"$f":" IF(AND($F31 >= S32, $F31 <= S33), 1, 0)","v":0},{"$f":" IF(AND($F31 >= T32, $F31 <= T33), 1, 0)","v":0},{"$f":" IF(AND($F31 >= U32, $F31 <= U33), 1, 0)","v":0}]
[]
[null,"Forecast end period flag"]
[null,null,null,null,{"$f":" Inputs!E$27","v":"Forecast start date"},{"$f":" Inputs!F$27","v":"2020-04-01"},{"$f":" Inputs!G$27","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E$28","v":"Forecast duration"},{"$f":" Inputs!F$28","v":5},{"$f":" Inputs!G$28","v":"years"}]
[null,null,null,null,"Forecast end date",{"$f":" DATE(YEAR(F37) + F38, MONTH(F37), DAY(F37) - 1)","v":"2025-03-31"},"date"]
[]
[null,null,null,null,{"$f":" E$39","v":"Forecast end date"},{"$f":" F$39","v":"2025-03-31"},{"$f":" G$39","v":"date"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2012-04-01","2013-04-01","2014-04-01","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31"]
[null,null,null,null,"Forecast end period flag",null,"flag",{"$f":" SUM(J44:U44)","v":0},null,{"$f":" IF(AND($F41 >= J42, $F41 <= J43), 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Forecast period flag"]
[null,null,null,null,{"$f":" E$34","v":"Forecast start period flag"},{"$f":" F$34","v":0},"flag",1,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,{"$f":" E$44","v":"Forecast end period flag"},{"$f":" F$44","v":0},"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Forecast period flag",null,"flag",{"$f":" SUM(J49:U49)","v":4},null,{"$f":" J47 + I49 - I48","v":0},{"$f":" K47 + J49 - J48","v":0},0,0,0,0,0,0,1,{"$f":" S47 + R49 - R48","v":1},{"$f":" T47 + S49 - S48","v":1},{"$f":" U47 + T49 - T48","v":1}]
[null,null,null,null,"Total number of forecast periods ",{"$f":" SUM(J49:U49)","v":4},"periods"]
[]
[null,"Pre-forecast period flag"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},{"$f":" F$14","v":0},"flag",1,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$34","v":"Forecast start period flag"},{"$f":" F$34","v":0},"flag",1,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"Pre-forecast period flag",null,"flag",{"$f":" SUM(J55:U55)","v":8},null,{"$f":" J53 + I55 - J54","v":1},{"$f":" K53 + J55 - K54","v":1},1,1,1,1,1,1,0,{"$f":" S53 + R55 - S54","v":0},{"$f":" T53 + S55 - T54","v":0},{"$f":" U53 + T55 - U54","v":0}]
[null,null,null,null,"Pre-forecast period flag - total",{"$f":" SUM(J55:U55)","v":8},"periods"]
[]
[null,"First post-forecast period flag"]
[null,null,null,null,{"$f":" E$44","v":"Forecast end period flag"},{"$f":" F$44","v":0},"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"First post-forecast period flag",null,"flag",{"$f":" SUM(J60:U60)","v":0},null,{"$f":" I59","v":0},{"$f":" J59","v":0},0,0,0,0,0,0,0,{"$f":" R59","v":0},{"$f":" S59","v":0},{"$f":" T59","v":0}]
[]
[null,"Post-forecast period flag"]
[null,null,null,null,{"$f":" E$60","v":"First post-forecast period flag"},0,"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Post-forecast period flag",null,"flag",{"$f":" SUM(J64:U64)","v":0},null,{"$f":" J63 + I64","v":0},{"$f":" K63 + J64","v":0},0,0,0,0,0,0,0,{"$f":" S63 + R64","v":0},{"$f":" T63 + S64","v":0},{"$f":" U63 + T64","v":0}]
[null,null,null,null,"Post-forecast period - total",{"$f":" SUM(J64:U64)","v":0},"periods"]
[]
["MODEL TIMELINE"]
[]
[]
[null,"Timeline label"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$34","v":"Forecast start period flag"},{"$f":" F$34","v":0},"flag",1,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,{"$f":" E$60","v":"First post-forecast period flag"},0,"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Timeline label counter",null,"counter",null,null,{"$f":" I74 + SUM(J71:J73)","v":1},1,1,1,1,1,1,1,2,{"$f":" R74 + SUM(S71:S73)","v":2},{"$f":" S74 + SUM(T71:T73)","v":2},{"$f":" T74 + SUM(U71:U73)","v":2}]
[]
[null,null,null,null,{"$f":" Inputs!E$20","v":"Pre - forecast period"},{"$f":" Inputs!F$20","v":"Pre-Fcst"},{"$f":" Inputs!G$20","v":"label"}]
[null,null,null,null,{"$f":" Inputs!E$21","v":"Forecast period"},{"$f":" Inputs!F$21","v":"Forecast"},{"$f":" Inputs!G$21","v":"label"}]
[null,null,null,null,{"$f":" Inputs!E$22","v":"Post - forecast period"},{"$f":" Inputs!F$22","v":"Post-Fcst"},{"$f":" Inputs!G$22","v":"label"}]
[null,null,null,null,{"$f":" E$74","v":"Timeline label counter"},0,"counter",0,0,1,1,1,1,1,1,1,1,2,2,2,2]
[null,null,null,null,"Timeline label",null,"label",null,null,{"$f":" INDEX($F76:$F78, J79)","v":"Pre-Fcst"},"Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Forecast",{"$f":" INDEX($F76:$F78, S79)","v":"Forecast"},{"$f":" INDEX($F76:$F78, T79)","v":"Forecast"},{"$f":" INDEX($F76:$F78, U79)","v":"Forecast"}]
[]
[null,"Modelling period check"]
[null,null,null,null,{"$f":" E$55","v":"Pre-forecast period flag"},{"$f":" F$55","v":0},"flag",8,0,1,1,1,1,1,1,1,1,0,0,0,0]
[null,null,null,null,{"$f":" E$49","v":"Forecast period flag"},{"$f":" F$49","v":0},"flag",4,0,0,0,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,{"$f":" E$64","v":"Post-forecast period flag"},0,"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"No. of overlapping in flags",null,"#",{"$f":" SUM(J86:U86)","v":0},null,{"$f":" MAX(0, SUM(J83:J85) - 1)","v":0},0,0,0,0,0,0,0,0,{"$f":" MAX(0, SUM(S83:S85) - 1)","v":0},{"$f":" MAX(0, SUM(T83:T85) - 1)","v":0},{"$f":" MAX(0, SUM(U83:U85) - 1)","v":0}]
[null,null,null,null,"Overlapping in periods - total",{"$f":" SUM(J86:U86)","v":0},"periods"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column total"},{"$f":" F$11","v":12},{"$f":" G$11","v":"columns"}]
[null,null,null,null,{"$f":" E$87","v":"Overlapping in periods - total"},{"$f":" F$87","v":0},{"$f":" G$87","v":"periods"}]
[null,null,null,null,{"$f":" E$56","v":"Pre-forecast period flag - total"},{"$f":" F$56","v":8},{"$f":" G$56","v":"periods"}]
[null,null,null,null,{"$f":" E$50","v":"Total number of forecast periods "},{"$f":" F$50","v":4},{"$f":" G$50","v":"periods"}]
[null,null,null,null,{"$f":" E$65","v":"Post-forecast period - total"},{"$f":" F$65","v":0},{"$f":" G$65","v":"periods"}]
[null,null,null,null,"Modelling period check",{"$f":" IF(SUM(F89:F90) - SUM(F91:F93) <> 0, 1, 0)","v":0},"check"]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":" Inputs!E$16","v":"First modelling column financial year#"},{"$f":" Inputs!F$16","v":2013},{"$f":" Inputs!G$16","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$17","v":"Financial year end month number"},{"$f":" Inputs!F$17","v":3},{"$f":" Inputs!G$17","v":"month #"}]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Financial year ending",null,"year #",null,null,{"$f":" IF(J102 = 1, $F99, IF(J101 > (DATE(I103, $F100 + 1, 1) - 1), I103 + 1, I103))","v":2013},2014,2015,2016,2017,2018,2019,2020,2021,{"$f":" IF(S102 = 1, $F99, IF(S101 > (DATE(R103, $F100 + 1, 1) - 1), R103 + 1, R103))","v":2022},{"$f":" IF(T102 = 1, $F99, IF(T101 > (DATE(S103, $F100 + 1, 1) - 1), S103 + 1, S103))","v":2023},{"$f":" IF(U102 = 1, $F99, IF(U101 > (DATE(T103, $F100 + 1, 1) - 1), T103 + 1, T103))","v":2024}]
[]
[]
["End of sheet"]
[]
[]
[null,null,null,null,{"$f":" Inputs!E$26","v":"Initial balance date "},{"$f":" Inputs!F$26","v":"2020-03-31"},{"$f":" Inputs!G$26","v":"date"}]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2013-03-31","2014-03-31","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31"]
[null,null,null,null,"Acquisition / initial balance date flag",null,"flag",{"$f":" SUM(J111:CA111)","v":1},null,{"$f":" IF(J110 = $F109, 1, 0)","v":0},0,0,0,0,0,0,1,0,0]

{"sheet":"Indexation","index":4,"n_rows":112,"n_cols":21,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Indexation"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[]
["CPIH INDEXATION"]
[]
[null,"CPIH: Index value series"]
[null,null,null,null,{"$f":" Inputs!E$36","v":"Consumer Price Index for April"},{"$f":" Inputs!F$36","v":0},{"$f":" Inputs!G$36","v":"index"},{"$f":" Inputs!H$36","v":0},{"$f":" Inputs!I$36","v":0},{"$f":" Inputs!J$36","v":95.9},{"$f":" Inputs!K$36","v":98},{"$f":" Inputs!L$36","v":99.6},{"$f":" Inputs!M$36","v":99.9},{"$f":" Inputs!N$36","v":100.6},{"$f":" Inputs!O$36","v":103.2},{"$f":" Inputs!P$36","v":0},{"$f":" Inputs!Q$36","v":0},{"$f":" Inputs!R$36","v":0},{"$f":" Inputs!S$36","v":0},{"$f":" Inputs!T$36","v":0},{"$f":" Inputs!U$36","v":0}]
[null,null,null,null,{"$f":" Inputs!E$37","v":"Consumer Price Index for May"},{"$f":" Inputs!F$37","v":0},{"$f":" Inputs!G$37","v":"index"},{"$f":" Inputs!H$37","v":0},{"$f":" Inputs!I$37","v":0},{"$f":" Inputs!J$37","v":95.9},{"$f":" Inputs!K$37","v":98.2},{"$f":" Inputs!L$37","v":99.6},{"$f":" Inputs!M$37","v":100.1},{"$f":" Inputs!N$37","v":100.8},{"$f":" Inputs!O$37","v":103.5},{"$f":" Inputs!P$37","v":0},{"$f":" Inputs!Q$37","v":0},{"$f":" Inputs!R$37","v":0},{"$f":" Inputs!S$37","v":0},{"$f":" Inputs!T$37","v":0},{"$f":" Inputs!U$37","v":0}]
[null,null,null,null,{"$f":" Inputs!E$38","v":"Consumer Price Index for June"},{"$f":" Inputs!F$38","v":0},{"$f":" Inputs!G$38","v":"index"},{"$f":" Inputs!H$38","v":0},{"$f":" Inputs!I$38","v":0},{"$f":" Inputs!J$38","v":95.6},{"$f":" Inputs!K$38","v":98},{"$f":" Inputs!L$38","v":99.8},{"$f":" Inputs!M$38","v":100.1},{"$f":" Inputs!N$38","v":101},{"$f":" Inputs!O$38","v":103.7},{"$f":" Inputs!P$38","v":0},{"$f":" Inputs!Q$38","v":0},{"$f":" Inputs!R$38","v":0},{"$f":" Inputs!S$38","v":0},{"$f":" Inputs!T$38","v":0},{"$f":" Inputs!U$38","v":0}]
[null,null,null,null,{"$f":" Inputs!E$39","v":"Consumer Price Index for July"},{"$f":" Inputs!F$39","v":0},{"$f":" Inputs!G$39","v":"index"},{"$f":" Inputs!H$39","v":0},{"$f":" Inputs!I$39","v":0},{"$f":" Inputs!J$39","v":95.7},{"$f":" Inputs!K$39","v":98},{"$f":" Inputs!L$39","v":99.6},{"$f":" Inputs!M$39","v":100},{"$f":" Inputs!N$39","v":100.9},{"$f":" Inputs!O$39","v":103.9},{"$f":" Inputs!P$39","v":0},{"$f":" Inputs!Q$39","v":0},{"$f":" Inputs!R$39","v":0},{"$f":" Inputs!S$39","v":0},{"$f":" Inputs!T$39","v":0},{"$f":" Inputs!U$39","v":0}]
[null,null,null,null,{"$f":" Inputs!E$40","v":"Consumer Price Index for August"},{"$f":" Inputs!F$40","v":0},{"$f":" Inputs!G$40","v":"index"},{"$f":" Inputs!H$40","v":0},{"$f":" Inputs!I$40","v":0},{"$f":" Inputs!J$40","v":96.1},{"$f":" Inputs!K$40","v":98.4},{"$f":" Inputs!L$40","v":99.9},{"$f":" Inputs!M$40","v":100.3},{"$f":" Inputs!N$40","v":101.2},{"$f":" Inputs!O$40","v":104.10000000000001},{"$f":" Inputs!P$40","v":0},{"$f":" Inputs!Q$40","v":0},{"$f":" Inputs!R$40","v":0},{"$f":" Inputs!S$40","v":0},{"$f":" Inputs!T$40","v":0},{"$f":" Inputs!U$40","v":0}]
[null,null,null,null,{"$f":" Inputs!E$41","v":"Consumer Price Index for September"},{"$f":" Inputs!F$41","v":0},{"$f":" Inputs!G$41","v":"index"},{"$f":" Inputs!H$41","v":0},{"$f":" Inputs!I$41","v":0},{"$f":" Inputs!J$41","v":96.4},{"$f":" Inputs!K$41","v":98.7},{"$f":" Inputs!L$41","v":100},{"$f":" Inputs!M$41","v":100.2},{"$f":" Inputs!N$41","v":101.5},{"$f":" Inputs!O$41","v":104.30000000000001},{"$f":" Inputs!P$41","v":0},{"$f":" Inputs!Q$41","v":0},{"$f":" Inputs!R$41","v":0},{"$f":" Inputs!S$41","v":0},{"$f":" Inputs!T$41","v":0},{"$f":" Inputs!U$41","v":0}]
[null,null,null,null,{"$f":" Inputs!E$42","v":"Consumer Price Index for October"},{"$f":" Inputs!F$42","v":0},{"$f":" Inputs!G$42","v":"index"},{"$f":" Inputs!H$42","v":0},{"$f":" Inputs!I$42","v":0},{"$f":" Inputs!J$42","v":96.8},{"$f":" Inputs!K$42","v":98.8},{"$f":" Inputs!L$42","v":100.1},{"$f":" Inputs!M$42","v":100.3},{"$f":" Inputs!N$42","v":101.6},{"$f":" Inputs!O$42","v":104.50000000000001},{"$f":" Inputs!P$42","v":0},{"$f":" Inputs!Q$42","v":0},{"$f":" Inputs!R$42","v":0},{"$f":" Inputs!S$42","v":0},{"$f":" Inputs!T$42","v":0},{"$f":" Inputs!U$42","v":0}]
[null,null,null,null,{"$f":" Inputs!E$43","v":"Consumer Price Index for November"},{"$f":" Inputs!F$43","v":0},{"$f":" Inputs!G$43","v":"index"},{"$f":" Inputs!H$43","v":0},{"$f":" Inputs!I$43","v":0},{"$f":" Inputs!J$43","v":97},{"$f":" Inputs!K$43","v":98.8},{"$f":" Inputs!L$43","v":99.9},{"$f":" Inputs!M$43","v":100.3},{"$f":" Inputs!N$43","v":101.8},{"$f":" Inputs!O$43","v":104.70000000000002},{"$f":" Inputs!P$43","v":0},{"$f":" Inputs!Q$43","v":0},{"$f":" Inputs!R$43","v":0},{"$f":" Inputs!S$43","v":0},{"$f":" Inputs!T$43","v":0},{"$f":" Inputs!U$43","v":0}]
[null,null,null,null,{"$f":" Inputs!E$44","v":"Consumer Price Index for December"},{"$f":" Inputs!F$44","v":0},{"$f":" Inputs!G$44","v":"index"},{"$f":" Inputs!H$44","v":0},{"$f":" Inputs!I$44","v":0},{"$f":" Inputs!J$44","v":97.3},{"$f":" Inputs!K$44","v":99.2},{"$f":" Inputs!L$44","v":99.9},{"$f":" Inputs!M$44","v":100.4},{"$f":" Inputs!N$44","v":102.2},{"$f":" Inputs!O$44","v":104.90000000000002},{"$f":" Inputs!P$44","v":0},{"$f":" Inputs!Q$44","v":0},{"$f":" Inputs!R$44","v":0},{"$f":" Inputs!S$44","v":0},{"$f":" Inputs!T$44","v":0},{"$f":" Inputs!U$44","v":0}]
[null,null,null,null,{"$f":" Inputs!E$45","v":"Consumer Price Index for January"},{"$f":" Inputs!F$45","v":0},{"$f":" Inputs!G$45","v":"index"},{"$f":" Inputs!H$45","v":0},{"$f":" Inputs!I$45","v":0},{"$f":" Inputs!J$45","v":97},{"$f":" Inputs!K$45","v":98.7},{"$f":" Inputs!L$45","v":99.2},{"$f":" Inputs!M$45","v":99.9},{"$f":" Inputs!N$45","v":101.8},{"$f":" Inputs!O$45","v":105.10000000000002},{"$f":" Inputs!P$45","v":0},{"$f":" Inputs!Q$45","v":0},{"$f":" Inputs!R$45","v":0},{"$f":" Inputs!S$45","v":0},{"$f":" Inputs!T$45","v":0},{"$f":" Inputs!U$45","v":0}]
[null,null,null,null,{"$f":" Inputs!E$46","v":"Consumer Price Index for February"},{"$f":" Inputs!F$46","v":0},{"$f":" Inputs!G$46","v":"index"},{"$f":" Inputs!H$46","v":0},{"$f":" Inputs!I$46","v":0},{"$f":" Inputs!J$46","v":97.5},{"$f":" Inputs!K$46","v":99.1},{"$f":" Inputs!L$46","v":99.5},{"$f":" Inputs!M$46","v":100.1},{"$f":" Inputs!N$46","v":102.4},{"$f":" Inputs!O$46","v":105.30000000000003},{"$f":" Inputs!P$46","v":0},{"$f":" Inputs!Q$46","v":0},{"$f":" Inputs!R$46","v":0},{"$f":" Inputs!S$46","v":0},{"$f":" Inputs!T$46","v":0},{"$f":" Inputs!U$46","v":0}]
[null,null,null,null,{"$f":" Inputs!E$47","v":"Consumer Price Index for March"},{"$f":" Inputs!F$47","v":0},{"$f":" Inputs!G$47","v":"index"},{"$f":" Inputs!H$47","v":0},{"$f":" Inputs!I$47","v":0},{"$f":" Inputs!J$47","v":97.8},{"$f":" Inputs!K$47","v":99.3},{"$f":" Inputs!L$47","v":99.6},{"$f":" Inputs!M$47","v":100.4},{"$f":" Inputs!N$47","v":102.7},{"$f":" Inputs!O$47","v":105.50000000000003},{"$f":" Inputs!P$47","v":0},{"$f":" Inputs!Q$47","v":0},{"$f":" Inputs!R$47","v":0},{"$f":" Inputs!S$47","v":0},{"$f":" Inputs!T$47","v":0},{"$f":" Inputs!U$47","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$49","v":"CPIH: Assumed percentage increase for unpopulated monthly values"},{"$f":" Inputs!F$49","v":0},{"$f":" Inputs!G$49","v":"%"},{"$f":" Inputs!H$49","v":0},{"$f":" Inputs!I$49","v":0},{"$f":" Inputs!J$49","v":0},{"$f":" Inputs!K$49","v":0},{"$f":" Inputs!L$49","v":0},{"$f":" Inputs!M$49","v":0},{"$f":" Inputs!N$49","v":0},{"$f":" Inputs!O$49","v":0},{"$f":" Inputs!P$49","v":0.02},{"$f":" Inputs!Q$49","v":0.02},{"$f":" Inputs!R$49","v":0},{"$f":" Inputs!S$49","v":0},{"$f":" Inputs!T$49","v":0},{"$f":" Inputs!U$49","v":0}]
[]
[null,null,null,null,"CPIH: April - index",null,"index",null,null,{"$f":" IF(J10 > 0, J10, I25 * (1 + J$23))","v":95.9},{"$f":" IF(K10 > 0, K10, J25 * (1 + K$23))","v":98},99.6,99.9,100.6,103.2,105.26400000000001,107.36928000000002,107.36928000000002,107.36928000000002,107.36928000000002,107.36928000000002]
[null,null,null,null,"CPIH: May - index",null,"index",null,null,{"$f":" IF(J11 > 0, J11, I26 * (1 + J$23))","v":95.9},98.2,99.6,100.1,100.8,103.5,105.57000000000001,107.68140000000001,107.68140000000001,107.68140000000001,107.68140000000001,107.68140000000001]
[null,null,null,null,"CPIH: June - index",null,"index",null,null,95.6,98,99.8,100.1,101,103.7,105.774,107.88948000000001,107.88948000000001,107.88948000000001,107.88948000000001,107.88948000000001]
[null,null,null,null,"CPIH: July - index",null,"index",null,null,95.7,98,99.6,100,100.9,103.9,105.97800000000001,108.09756000000002,108.09756000000002,108.09756000000002,108.09756000000002,108.09756000000002]
[null,null,null,null,"CPIH: August - index",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,104.10000000000001,106.18200000000002,108.30564000000003,108.30564000000003,108.30564000000003,108.30564000000003,108.30564000000003]
[null,null,null,null,"CPIH: September- index",null,"index",null,null,96.4,98.7,100,100.2,101.5,104.30000000000001,106.38600000000001,108.51372000000001,108.51372000000001,108.51372000000001,108.51372000000001,108.51372000000001]
[null,null,null,null,"CPIH: October - index",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,104.50000000000001,106.59000000000002,108.72180000000002,108.72180000000002,108.72180000000002,108.72180000000002,108.72180000000002]
[null,null,null,null,"CPIH: November - index",null,"index",null,null,97,98.8,99.9,100.3,101.8,104.70000000000002,106.79400000000003,108.92988000000003,108.92988000000003,108.92988000000003,108.92988000000003,108.92988000000003]
[null,null,null,null,"CPIH: December - index",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,104.90000000000002,106.99800000000002,109.13796000000002,109.13796000000002,109.13796000000002,109.13796000000002,109.13796000000002]
[null,null,null,null,"CPIH: January - index",null,"index",null,null,97,98.7,99.2,99.9,101.8,105.10000000000002,107.20200000000003,109.34604000000003,109.34604000000003,109.34604000000003,109.34604000000003,109.34604000000003]
[null,null,null,null,"CPIH: February - index",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,105.30000000000003,107.40600000000003,109.55412000000004,109.55412000000004,109.55412000000004,109.55412000000004,109.55412000000004]
[null,null,null,null,"CPIH: March - index",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,105.50000000000003,107.61000000000003,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004]
[]
[null,null,null,null,"CPIH: Financial year average - index",null,"index",null,null,{"$f":" AVERAGE(J25:J36)","v":96.583333333333314},98.600000000000009,99.72499999999998,100.16666666666667,101.54166666666667,104.39166666666667,106.47950000000002,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004]
[]
[]
["RPI INDEXATION"]
[]
[null,"RPI: Index value series"]
[null,null,null,null,{"$f":" Inputs!E$67","v":"Retail Price Index for April"},{"$f":" Inputs!F$67","v":0},{"$f":" Inputs!G$67","v":"index"},{"$f":" Inputs!H$67","v":0},{"$f":" Inputs!I$67","v":0},{"$f":" Inputs!J$67","v":242.5},{"$f":" Inputs!K$67","v":249.5},{"$f":" Inputs!L$67","v":255.7},{"$f":" Inputs!M$67","v":258},{"$f":" Inputs!N$67","v":261.39999999999998},{"$f":" Inputs!O$67","v":270.60000000000002},{"$f":" Inputs!P$67","v":0},{"$f":" Inputs!Q$67","v":0},{"$f":" Inputs!R$67","v":0},{"$f":" Inputs!S$67","v":0},{"$f":" Inputs!T$67","v":0},{"$f":" Inputs!U$67","v":0}]
[null,null,null,null,{"$f":" Inputs!E$68","v":"Retail Price Index for May"},{"$f":" Inputs!F$68","v":0},{"$f":" Inputs!G$68","v":"index"},{"$f":" Inputs!H$68","v":0},{"$f":" Inputs!I$68","v":0},{"$f":" Inputs!J$68","v":242.4},{"$f":" Inputs!K$68","v":250},{"$f":" Inputs!L$68","v":255.9},{"$f":" Inputs!M$68","v":258.5},{"$f":" Inputs!N$68","v":262.10000000000002},{"$f":" Inputs!O$68","v":271.7},{"$f":" Inputs!P$68","v":0},{"$f":" Inputs!Q$68","v":0},{"$f":" Inputs!R$68","v":0},{"$f":" Inputs!S$68","v":0},{"$f":" Inputs!T$68","v":0},{"$f":" Inputs!U$68","v":0}]
[null,null,null,null,{"$f":" Inputs!E$69","v":"Retail Price Index for June"},{"$f":" Inputs!F$69","v":0},{"$f":" Inputs!G$69","v":"index"},{"$f":" Inputs!H$69","v":0},{"$f":" Inputs!I$69","v":0},{"$f":" Inputs!J$69","v":241.8},{"$f":" Inputs!K$69","v":249.7},{"$f":" Inputs!L$69","v":256.3},{"$f":" Inputs!M$69","v":258.89999999999998},{"$f":" Inputs!N$69","v":263.10000000000002},{"$f":" Inputs!O$69","v":272},{"$f":" Inputs!P$69","v":0},{"$f":" Inputs!Q$69","v":0},{"$f":" Inputs!R$69","v":0},{"$f":" Inputs!S$69","v":0},{"$f":" Inputs!T$69","v":0},{"$f":" Inputs!U$69","v":0}]
[null,null,null,null,{"$f":" Inputs!E$70","v":"Retail Price Index for July"},{"$f":" Inputs!F$70","v":0},{"$f":" Inputs!G$70","v":"index"},{"$f":" Inputs!H$70","v":0},{"$f":" Inputs!I$70","v":0},{"$f":" Inputs!J$70","v":242.1},{"$f":" Inputs!K$70","v":249.7},{"$f":" Inputs!L$70","v":256},{"$f":" Inputs!M$70","v":258.60000000000002},{"$f":" Inputs!N$70","v":263.39999999999998},{"$f":" Inputs!O$70","v":272.3},{"$f":" Inputs!P$70","v":0},{"$f":" Inputs!Q$70","v":0},{"$f":" Inputs!R$70","v":0},{"$f":" Inputs!S$70","v":0},{"$f":" Inputs!T$70","v":0},{"$f":" Inputs!U$70","v":0}]
[null,null,null,null,{"$f":" Inputs!E$71","v":"Retail Price Index for August"},{"$f":" Inputs!F$71","v":0},{"$f":" Inputs!G$71","v":"index"},{"$f":" Inputs!H$71","v":0},{"$f":" Inputs!I$71","v":0},{"$f":" Inputs!J$71","v":243},{"$f":" Inputs!K$71","v":251},{"$f":" Inputs!L$71","v":257},{"$f":" Inputs!M$71","v":259.8},{"$f":" Inputs!N$71","v":264.39999999999998},{"$f":" Inputs!O$71","v":272.60000000000002},{"$f":" Inputs!P$71","v":0},{"$f":" Inputs!Q$71","v":0},{"$f":" Inputs!R$71","v":0},{"$f":" Inputs!S$71","v":0},{"$f":" Inputs!T$71","v":0},{"$f":" Inputs!U$71","v":0}]
[null,null,null,null,{"$f":" Inputs!E$72","v":"Retail Price Index for September"},{"$f":" Inputs!F$72","v":0},{"$f":" Inputs!G$72","v":"index"},{"$f":" Inputs!H$72","v":0},{"$f":" Inputs!I$72","v":0},{"$f":" Inputs!J$72","v":244.2},{"$f":" Inputs!K$72","v":251.9},{"$f":" Inputs!L$72","v":257.60000000000002},{"$f":" Inputs!M$72","v":259.60000000000002},{"$f":" Inputs!N$72","v":264.89999999999998},{"$f":" Inputs!O$72","v":272.90000000000003},{"$f":" Inputs!P$72","v":0},{"$f":" Inputs!Q$72","v":0},{"$f":" Inputs!R$72","v":0},{"$f":" Inputs!S$72","v":0},{"$f":" Inputs!T$72","v":0},{"$f":" Inputs!U$72","v":0}]
[null,null,null,null,{"$f":" Inputs!E$73","v":"Retail Price Index for October"},{"$f":" Inputs!F$73","v":0},{"$f":" Inputs!G$73","v":"index"},{"$f":" Inputs!H$73","v":0},{"$f":" Inputs!I$73","v":0},{"$f":" Inputs!J$73","v":245.6},{"$f":" Inputs!K$73","v":251.9},{"$f":" Inputs!L$73","v":257.7},{"$f":" Inputs!M$73","v":259.5},{"$f":" Inputs!N$73","v":264.8},{"$f":" Inputs!O$73","v":273.20000000000005},{"$f":" Inputs!P$73","v":0},{"$f":" Inputs!Q$73","v":0},{"$f":" Inputs!R$73","v":0},{"$f":" Inputs!S$73","v":0},{"$f":" Inputs!T$73","v":0},{"$f":" Inputs!U$73","v":0}]
[null,null,null,null,{"$f":" Inputs!E$74","v":"Retail Price Index for November"},{"$f":" Inputs!F$74","v":0},{"$f":" Inputs!G$74","v":"index"},{"$f":" Inputs!H$74","v":0},{"$f":" Inputs!I$74","v":0},{"$f":" Inputs!J$74","v":245.6},{"$f":" Inputs!K$74","v":252.1},{"$f":" Inputs!L$74","v":257.10000000000002},{"$f":" Inputs!M$74","v":259.8},{"$f":" Inputs!N$74","v":265.5},{"$f":" Inputs!O$74","v":273.50000000000006},{"$f":" Inputs!P$74","v":0},{"$f":" Inputs!Q$74","v":0},{"$f":" Inputs!R$74","v":0},{"$f":" Inputs!S$74","v":0},{"$f":" Inputs!T$74","v":0},{"$f":" Inputs!U$74","v":0}]
[null,null,null,null,{"$f":" Inputs!E$75","v":"Retail Price Index for December"},{"$f":" Inputs!F$75","v":0},{"$f":" Inputs!G$75","v":"index"},{"$f":" Inputs!H$75","v":0},{"$f":" Inputs!I$75","v":0},{"$f":" Inputs!J$75","v":246.8},{"$f":" Inputs!K$75","v":253.4},{"$f":" Inputs!L$75","v":257.5},{"$f":" Inputs!M$75","v":260.60000000000002},{"$f":" Inputs!N$75","v":267.10000000000002},{"$f":" Inputs!O$75","v":273.80000000000007},{"$f":" Inputs!P$75","v":0},{"$f":" Inputs!Q$75","v":0},{"$f":" Inputs!R$75","v":0},{"$f":" Inputs!S$75","v":0},{"$f":" Inputs!T$75","v":0},{"$f":" Inputs!U$75","v":0}]
[null,null,null,null,{"$f":" Inputs!E$76","v":"Retail Price Index for January"},{"$f":" Inputs!F$76","v":0},{"$f":" Inputs!G$76","v":"index"},{"$f":" Inputs!H$76","v":0},{"$f":" Inputs!I$76","v":0},{"$f":" Inputs!J$76","v":245.8},{"$f":" Inputs!K$76","v":252.6},{"$f":" Inputs!L$76","v":255.4},{"$f":" Inputs!M$76","v":258.8},{"$f":" Inputs!N$76","v":265.5},{"$f":" Inputs!O$76","v":274.10000000000008},{"$f":" Inputs!P$76","v":0},{"$f":" Inputs!Q$76","v":0},{"$f":" Inputs!R$76","v":0},{"$f":" Inputs!S$76","v":0},{"$f":" Inputs!T$76","v":0},{"$f":" Inputs!U$76","v":0}]
[null,null,null,null,{"$f":" Inputs!E$77","v":"Retail Price Index for February"},{"$f":" Inputs!F$77","v":0},{"$f":" Inputs!G$77","v":"index"},{"$f":" Inputs!H$77","v":0},{"$f":" Inputs!I$77","v":0},{"$f":" Inputs!J$77","v":247.6},{"$f":" Inputs!K$77","v":254.2},{"$f":" Inputs!L$77","v":256.7},{"$f":" Inputs!M$77","v":260},{"$f":" Inputs!N$77","v":268.39999999999998},{"$f":" Inputs!O$77","v":274.40000000000009},{"$f":" Inputs!P$77","v":0},{"$f":" Inputs!Q$77","v":0},{"$f":" Inputs!R$77","v":0},{"$f":" Inputs!S$77","v":0},{"$f":" Inputs!T$77","v":0},{"$f":" Inputs!U$77","v":0}]
[null,null,null,null,{"$f":" Inputs!E$78","v":"Retail Price Index for March"},{"$f":" Inputs!F$78","v":0},{"$f":" Inputs!G$78","v":"index"},{"$f":" Inputs!H$78","v":0},{"$f":" Inputs!I$78","v":0},{"$f":" Inputs!J$78","v":248.7},{"$f":" Inputs!K$78","v":254.8},{"$f":" Inputs!L$78","v":257.10000000000002},{"$f":" Inputs!M$78","v":261.10000000000002},{"$f":" Inputs!N$78","v":269.3},{"$f":" Inputs!O$78","v":274.7000000000001},{"$f":" Inputs!P$78","v":0},{"$f":" Inputs!Q$78","v":0},{"$f":" Inputs!R$78","v":0},{"$f":" Inputs!S$78","v":0},{"$f":" Inputs!T$78","v":0},{"$f":" Inputs!U$78","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$80","v":"RPI: Assumed percentage increase for unpopulated monthly values"},{"$f":" Inputs!F$80","v":0},{"$f":" Inputs!G$80","v":"%"},{"$f":" Inputs!H$80","v":0},{"$f":" Inputs!I$80","v":0},{"$f":" Inputs!J$80","v":0},{"$f":" Inputs!K$80","v":0},{"$f":" Inputs!L$80","v":0},{"$f":" Inputs!M$80","v":0},{"$f":" Inputs!N$80","v":0},{"$f":" Inputs!O$80","v":0},{"$f":" Inputs!P$80","v":2.8000000000000001E-2},{"$f":" Inputs!Q$80","v":2.8000000000000001E-2},{"$f":" Inputs!R$80","v":0},{"$f":" Inputs!S$80","v":0},{"$f":" Inputs!T$80","v":0},{"$f":" Inputs!U$80","v":0}]
[]
[null,null,null,null,"RPI: April - index",null,"index",null,null,{"$f":" IF(J44 > 0, J44, I59 * (1 + J$57))","v":242.5},{"$f":" IF(K44 > 0, K44, J59 * (1 + K$57))","v":249.5},255.7,258,261.39999999999998,270.60000000000002,278.17680000000001,285.96575040000005,285.96575040000005,285.96575040000005,285.96575040000005,285.96575040000005]
[null,null,null,null,"RPI: May - index",null,"index",null,null,{"$f":" IF(J45 > 0, J45, I60 * (1 + J$57))","v":242.4},250,255.9,258.5,262.10000000000002,271.7,279.30759999999998,287.12821279999997,287.12821279999997,287.12821279999997,287.12821279999997,287.12821279999997]
[null,null,null,null,"RPI: June - index",null,"index",null,null,{"$f":" IF(J46 > 0, J46, I61 * (1 + J$57))","v":241.8},249.7,256.3,258.89999999999998,263.10000000000002,272,279.61599999999999,287.44524799999999,287.44524799999999,287.44524799999999,287.44524799999999,287.44524799999999]
[null,null,null,null,"RPI: July - index",null,"index",null,null,{"$f":" IF(J47 > 0, J47, I62 * (1 + J$57))","v":242.1},249.7,256,258.60000000000002,263.39999999999998,272.3,279.92439999999999,287.76228320000001,287.76228320000001,287.76228320000001,287.76228320000001,287.76228320000001]
[null,null,null,null,"RPI: August - index",null,"index",null,null,{"$f":" IF(J48 > 0, J48, I63 * (1 + J$57))","v":243},251,257,259.8,264.39999999999998,272.60000000000002,280.23280000000005,288.07931840000009,288.07931840000009,288.07931840000009,288.07931840000009,288.07931840000009]
[null,null,null,null,"RPI: September- index",null,"index",null,null,{"$f":" IF(J49 > 0, J49, I64 * (1 + J$57))","v":244.2},251.9,257.60000000000002,259.60000000000002,264.89999999999998,272.90000000000003,280.54120000000006,288.39635360000005,288.39635360000005,288.39635360000005,288.39635360000005,288.39635360000005]
[null,null,null,null,"RPI: October - index",null,"index",null,null,{"$f":" IF(J50 > 0, J50, I65 * (1 + J$57))","v":245.6},251.9,257.7,259.5,264.8,273.20000000000005,280.84960000000007,288.71338880000008,288.71338880000008,288.71338880000008,288.71338880000008,288.71338880000008]
[null,null,null,null,"RPI: November - index",null,"index",null,null,{"$f":" IF(J51 > 0, J51, I66 * (1 + J$57))","v":245.6},252.1,257.10000000000002,259.8,265.5,273.50000000000006,281.15800000000007,289.0304240000001,289.0304240000001,289.0304240000001,289.0304240000001,289.0304240000001]
[null,null,null,null,"RPI: December - index",null,"index",null,null,{"$f":" IF(J52 > 0, J52, I67 * (1 + J$57))","v":246.8},253.4,257.5,260.60000000000002,267.10000000000002,273.80000000000007,281.46640000000008,289.34745920000006,289.34745920000006,289.34745920000006,289.34745920000006,289.34745920000006]
[null,null,null,null,"RPI: January - index",null,"index",null,null,{"$f":" IF(J53 > 0, J53, I68 * (1 + J$57))","v":245.8},252.6,255.4,258.8,265.5,274.10000000000008,281.77480000000008,289.66449440000008,289.66449440000008,289.66449440000008,289.66449440000008,289.66449440000008]
[null,null,null,null,"RPI: February - index",null,"index",null,null,{"$f":" IF(J54 > 0, J54, I69 * (1 + J$57))","v":247.6},254.2,256.7,260,268.39999999999998,274.40000000000009,282.08320000000009,289.9815296000001,289.9815296000001,289.9815296000001,289.9815296000001,289.9815296000001]
[null,null,null,null,"RPI: March - index",null,"index",null,null,{"$f":" IF(J55 > 0, J55, I70 * (1 + J$57))","v":248.7},254.8,257.10000000000002,261.10000000000002,269.3,274.7000000000001,282.3916000000001,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012]
[]
[null,null,null,null,"RPI: Financial year average - index",null,"index",null,null,{"$f":" AVERAGE(J59:J70)","v":244.67499999999998},251.73333333333335,256.66666666666669,259.43333333333334,264.99166666666673,272.98333333333341,280.62686666666673,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342]
[]
[]
["INFLATION"]
[]
[null,"Inflation of 2013 base prices  FYA - RPI "]
[null,null,null,null,{"$f":" Inputs!E$84","v":"Year reference for FYA base price 1"},{"$f":" Inputs!F$84","v":2013},{"$f":" Inputs!G$84","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$87","v":"Year reference for FYE end price"},{"$f":" Inputs!F$87","v":2020},{"$f":" Inputs!G$87","v":"year #"}]
[null,null,null,null,{"$f":" E$72","v":"RPI: Financial year average - index"},0,"index",0,0,244.67499999999998,251.73333333333335,256.66666666666669,259.43333333333334,264.99166666666673,272.98333333333341,280.62686666666673,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342]
[null,null,null,null,{"$f":" E$70","v":"RPI: March - index"},0,"index",0,0,248.7,254.8,257.10000000000002,261.10000000000002,269.3,274.7000000000001,282.3916000000001,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F78 & \" FYA to \" & F79 & \" FYE\"","v":"RPI inflate from 2013 FYA to 2020 FYE"},{"$f":" INDEX($J81:$U81, 1, MATCH($F79,$J$4:$U$4)) / INDEX($J80:$U80, 1, MATCH($F78,$J$4:$U$4))","v":1.186465984673547},"factor"]
[]
[null,"Inflation of 2018 base prices  FYA - RPI "]
[null,null,null,null,{"$f":" Inputs!E$85","v":"Year reference for FYA base price 2"},{"$f":" Inputs!F$85","v":2018},{"$f":" Inputs!G$85","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$87","v":"Year reference for FYE end price"},{"$f":" Inputs!F$87","v":2020},{"$f":" Inputs!G$87","v":"year #"}]
[null,null,null,null,{"$f":" E$72","v":"RPI: Financial year average - index"},0,"index",0,0,244.67499999999998,251.73333333333335,256.66666666666669,259.43333333333334,264.99166666666673,272.98333333333341,280.62686666666673,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342,288.48441893333342]
[null,null,null,null,{"$f":" E$70","v":"RPI: March - index"},0,"index",0,0,248.7,254.8,257.10000000000002,261.10000000000002,269.3,274.7000000000001,282.3916000000001,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F85 & \" FYA to \" & F86 & \" FYE\"","v":"RPI inflate from 2018 FYA to 2020 FYE"},{"$f":" INDEX($J88:$U88, 1, MATCH($F86,$J$4:$U$4)) / INDEX($J87:$U87, 1, MATCH($F85,$J$4:$U$4))","v":1.0634296286708591},"factor"]
[]
[null,"Inflation of 2018 base prices  FYE - RPI"]
[null,null,null,null,{"$f":" Inputs!E$86","v":"Year reference for FYE base price"},{"$f":" Inputs!F$86","v":2018},{"$f":" Inputs!G$86","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$87","v":"Year reference for FYE end price"},{"$f":" Inputs!F$87","v":2020},{"$f":" Inputs!G$87","v":"year #"}]
[null,null,null,null,{"$f":" E$70","v":"RPI: March - index"},0,"index",0,0,248.7,254.8,257.10000000000002,261.10000000000002,269.3,274.7000000000001,282.3916000000001,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012,290.29856480000012]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F92 & \" FYE to \" & F93 & \" FYE\"","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" INDEX($J94:$U94, 1, MATCH($F93,$J$4:$U$4)) / INDEX($J94:$U94, 1, MATCH($F92,$J$4:$U$4))","v":1.0567839999999999},"factor"]
[]
[]
["DEFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$91","v":"Year reference for FYE base price"},{"$f":" Inputs!F$91","v":2020},{"$f":" Inputs!G$91","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$92","v":"Year reference for FYA end price"},{"$f":" Inputs!F$92","v":2018},{"$f":" Inputs!G$92","v":"year #"}]
[null,null,null,null,{"$f":" E$36","v":"CPIH: March - index"},{"$f":" F$36","v":0},"index",0,0,97.8,99.3,99.6,100.4,102.7,105.50000000000003,107.61000000000003,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004]
[null,null,null,null,{"$f":" E$38","v":"CPIH: Financial year average - index"},0,"index",0,0,96.583333333333314,98.600000000000009,99.72499999999998,100.16666666666667,101.54166666666667,104.39166666666667,106.47950000000002,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004]
[null,null,null,null,{"$f":" \"CPIH deflate from \" & F100 & \" FYE to \" & F101 & \" FYA\"","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" INDEX($J103:$U103, 1, MATCH($F101,$J$4:$U$4)) / INDEX($J102:$U102, 1, MATCH($F100,$J$4:$U$4))","v":0.95107119451565869},"factor"]
[]
[null,null,null,null,{"$f":" E$36","v":"CPIH: March - index"},{"$f":" F$36","v":0},"index",0,0,97.8,99.3,99.6,100.4,102.7,105.50000000000003,107.61000000000003,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004,109.76220000000004]
[null,null,null,null,{"$f":" Time!E$111","v":"Acquisition / initial balance date flag"},{"$f":" Time!F$111","v":0},{"$f":" Time!G$111","v":"flag"},{"$f":" Time!H$111","v":1},{"$f":" Time!I$111","v":0},{"$f":" Time!J$111","v":0},{"$f":" Time!K$111","v":0},{"$f":" Time!L$111","v":0},{"$f":" Time!M$111","v":0},{"$f":" Time!N$111","v":0},{"$f":" Time!O$111","v":0},{"$f":" Time!P$111","v":0},{"$f":" Time!Q$111","v":1},{"$f":" Time!R$111","v":0},{"$f":" Time!S$111","v":0},{"$f":" Time!T$111","v":0},{"$f":" Time!U$111","v":0}]
[null,null,null,null,"CPIH year end position for initial balance",{"$f":"SUMPRODUCT(J106:U106,J107:U107)","v":109.76220000000004},"index"]
[]
[null,null,null,null,{"$f":" E$38","v":"CPIH: Financial year average - index"},0,"index",0,0,96.583333333333314,98.600000000000009,99.72499999999998,100.16666666666667,101.54166666666667,104.39166666666667,106.47950000000002,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004,108.60909000000004]
[null,null,null,null,{"$f":" Time!E$111","v":"Acquisition / initial balance date flag"},{"$f":" Time!F$111","v":0},{"$f":" Time!G$111","v":"flag"},{"$f":" Time!H$111","v":1},{"$f":" Time!I$111","v":0},{"$f":" Time!J$111","v":0},{"$f":" Time!K$111","v":0},{"$f":" Time!L$111","v":0},{"$f":" Time!M$111","v":0},{"$f":" Time!N$111","v":0},{"$f":" Time!O$111","v":0},{"$f":" Time!P$111","v":0},{"$f":" Time!Q$111","v":1},{"$f":" Time!R$111","v":0},{"$f":" Time!S$111","v":0},{"$f":" Time!T$111","v":0},{"$f":" Time!U$111","v":0}]
[null,null,null,null,"CPIH FYA position for initial balance",{"$f":"SUMPRODUCT(J110:U110,J111:U111)","v":108.60909000000004},"index"]

{"sheet":"Calc","index":5,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Calc"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[]
["Indexation calculations in RCV feeder model"]
[]
[null,"This section of the model indexes RCV in a similar fashion to the RCV feeder model."]
[null,"RCV is indexed by RPI to 31 March 2020. It is then delfated from 31 March 2020 ro 2017/18 FYA by CPIH"]
[]
[null,"RCV closing balance at 31 March 2020"]
[null,null,null,null,{"$f":" Inputs!E$133","v":"RCV at 31 March 2020 (from PR14 FD) post adjustment"},{"$f":" Inputs!F$133","v":100},{"$f":" Inputs!G$133","v":"£m"}]
[null,null,null,null,{"$f":" Indexation!E$82","v":"RPI inflate from 2013 FYA to 2020 FYE"},{"$f":" Indexation!F$82","v":1.186465984673547},{"$f":" Indexation!G$82","v":"factor"}]
[null,null,null,null,"RCV from feeder model at 31 March 2020 (post adjustment at 2020 FYE price base)",{"$f":" F13 * F$14","v":118.64659846735471},"£m"]
[]
[null,null,null,null,{"$f":" E$15","v":"RCV from feeder model at 31 March 2020 (post adjustment at 2020 FYE price base)"},{"$f":" F$15","v":118.64659846735471},"£m"]
[null,null,null,null,{"$f":" Indexation!E$104","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$104","v":0.95107119451565869},{"$f":" Indexation!G$104","v":"factor"},null,null,{"$f":"1/F18","v":1.0514459966472423}]
[null,null,null,null,"31 March 2020 RCV at 2017-18 CPIH deflated price base",{"$f":" F17 * F18","v":112.84136212956676},"£m"]
[]
["Indexation carried out in financial model"]
[]
[null,"This section of the model indexes RCV in a similar fashion to the PR19 financial model"]
[]
[null,"Average CPI(H) - base index"]
[null,null,null,null,{"$f":" Inputs!E$51","v":"Consumer Price Index for April"},{"$f":" Inputs!F$51","v":103.2},{"$f":" Inputs!G$51","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$52","v":"Consumer Price Index for May"},{"$f":" Inputs!F$52","v":103.5},{"$f":" Inputs!G$52","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$53","v":"Consumer Price Index for June"},{"$f":" Inputs!F$53","v":103.7},{"$f":" Inputs!G$53","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$54","v":"Consumer Price Index for July"},{"$f":" Inputs!F$54","v":103.9},{"$f":" Inputs!G$54","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$55","v":"Consumer Price Index for August"},{"$f":" Inputs!F$55","v":104.10000000000001},{"$f":" Inputs!G$55","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$56","v":"Consumer Price Index for September"},{"$f":" Inputs!F$56","v":104.30000000000001},{"$f":" Inputs!G$56","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$57","v":"Consumer Price Index for October"},{"$f":" Inputs!F$57","v":104.50000000000001},{"$f":" Inputs!G$57","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$58","v":"Consumer Price Index for November"},{"$f":" Inputs!F$58","v":104.70000000000002},{"$f":" Inputs!G$58","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$59","v":"Consumer Price Index for December"},{"$f":" Inputs!F$59","v":104.90000000000002},{"$f":" Inputs!G$59","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$60","v":"Consumer Price Index for January"},{"$f":" Inputs!F$60","v":105.10000000000002},{"$f":" Inputs!G$60","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$61","v":"Consumer Price Index for February"},{"$f":" Inputs!F$61","v":105.30000000000003},{"$f":" Inputs!G$61","v":"index"}]
[null,null,null,null,{"$f":" Inputs!E$62","v":"Consumer Price Index for March"},{"$f":" Inputs!F$62","v":105.50000000000003},{"$f":" Inputs!G$62","v":"index"}]
[null,null,null,null,"Average CPI(H) - base index - 2017-18",{"$f":" AVERAGE(F26:F37)","v":104.39166666666667},"index"]
[]
[null,"CPI(H): Fin year average - inflate from base year average"]
[null,null,null,null,{"$f":" E$38","v":"Average CPI(H) - base index - 2017-18"},{"$f":" F$38","v":104.39166666666667},{"$f":" G$38","v":"index"}]
[null,null,null,null,{"$f":" Indexation!E$38","v":"CPIH: Financial year average - index"},{"$f":" Indexation!F$38","v":0},{"$f":" Indexation!G$38","v":"index"},{"$f":" Indexation!H$38","v":0},{"$f":" Indexation!I$38","v":0},{"$f":" Indexation!J$38","v":96.583333333333314},{"$f":" Indexation!K$38","v":98.600000000000009},{"$f":" Indexation!L$38","v":99.72499999999998},{"$f":" Indexation!M$38","v":100.16666666666667},{"$f":" Indexation!N$38","v":101.54166666666667},{"$f":" Indexation!O$38","v":104.39166666666667},{"$f":" Indexation!P$38","v":106.47950000000002},{"$f":" Indexation!Q$38","v":108.60909000000004},{"$f":" Indexation!R$38","v":108.60909000000004},{"$f":" Indexation!S$38","v":108.60909000000004},{"$f":" Indexation!T$38","v":108.60909000000004},{"$f":" Indexation!U$38","v":108.60909000000004}]
[null,null,null,null,"CPI(H): Fin year average - inflate from base year 2017-18 average - CALC",null,"%",null,null,{"$f":" IF($F41 = 0, 0, J42 / $F41)","v":0.92520156462041969},0.94451983715175225,0.9552965594316275,0.9595274207711344,0.97269897022431551,1,1.0200000000000002,1.0404000000000004,1.0404000000000004,1.0404000000000004,1.0404000000000004,1.0404000000000004]
[]
[null,null,null,null,{"$f":" E$19","v":"31 March 2020 RCV at 2017-18 CPIH deflated price base"},{"$f":" F$19","v":112.84136212956676},{"$f":" G$19","v":"£m"}]
[null,null,null,null,{"$f":" E$43","v":"CPI(H): Fin year average - inflate from base year 2017-18 average - CALC"},{"$f":" F$43","v":0},"%",0,0,0.92520156462041969,0.94451983715175225,0.9552965594316275,0.9595274207711344,0.97269897022431551,1,1.0200000000000002,1.0404000000000004,1.0404000000000004,1.0404000000000004,1.0404000000000004,1.0404000000000004]
[null,null,null,null,{"$f":" Time!E$111","v":"Acquisition / initial balance date flag"},{"$f":" Time!F$111","v":0},{"$f":" Time!G$111","v":"flag"},{"$f":" Time!H$111","v":1},{"$f":" Time!I$111","v":0},{"$f":" Time!J$111","v":0},{"$f":" Time!K$111","v":0},{"$f":" Time!L$111","v":0},{"$f":" Time!M$111","v":0},{"$f":" Time!N$111","v":0},{"$f":" Time!O$111","v":0},{"$f":" Time!P$111","v":0},{"$f":" Time!Q$111","v":1},{"$f":" Time!R$111","v":0},{"$f":" Time!S$111","v":0},{"$f":" Time!T$111","v":0},{"$f":" Time!U$111","v":0}]
[null,null,null,null,"RCV balance at 31 March 2020 (nominal FYA prices)",null,"£m",null,null,{"$f":" $F45 *J46 *J47","v":0},{"$f":" $F45 *K46 *K47","v":0},0,0,0,0,0,{"$f":" $F45 *Q46 *Q47","v":117.4001531596013},0,0,0,0]
[]
[null,null,null,null,{"$f":" E$48","v":"RCV balance at 31 March 2020 (nominal FYA prices)"},{"$f":" F$48","v":0},"£m",0,0,0,0,0,0,0,0,0,117.4001531596013,0,0,0,0]
[null,null,null,null,"RCV opening balance in Financial model (nominal FYA prices)",{"$f":"SUM(J50:U50)","v":117.4001531596013},"£m"]
[]
["Check"]
[]
[null,"This section demonstrates that the difference between the numbers in the red boxes above is due to the difference between year end and year average CPI in 2019/20. "]
[]
[null,null,null,null,{"$f":" E$15","v":"RCV from feeder model at 31 March 2020 (post adjustment at 2020 FYE price base)"},{"$f":" F$15","v":118.64659846735471},"£m"]
[null,null,null,null,{"$f":" E$51","v":"RCV opening balance in Financial model (nominal FYA prices)"},{"$f":" F$51","v":117.4001531596013},{"$f":" G$51","v":"£m"}]
[null,null,null,null,"Difference in RCV balance between 31/3/2020 (RPI inflated) and financial model 31/3/2020 (CPIH FYA)",{"$f":"F57/F58 -1","v":1.0617067134988334E-2},"%"]
[]
[null,null,null,null,{"$f":" Indexation!E$108","v":"CPIH year end position for initial balance"},{"$f":" Indexation!F$108","v":109.76220000000004},{"$f":" Indexation!G$108","v":"index"}]
[null,null,null,null,{"$f":" Indexation!E$112","v":"CPIH FYA position for initial balance"},{"$f":" Indexation!F$112","v":108.60909000000004},{"$f":" Indexation!G$112","v":"index"}]
[null,null,null,null,"Difference between year end and financial year average CPIH for initial balance",{"$f":"F61/F62 -1","v":1.0617067134988334E-2},"%"]
[]
[null,null,null,null,{"$f":" E$59","v":"Difference in RCV balance between 31/3/2020 (RPI inflated) and financial model 31/3/2020 (CPIH FYA)"},{"$f":" F$59","v":1.0617067134988334E-2},{"$f":" G$59","v":"%"}]
[null,null,null,null,{"$f":" E$63","v":"Difference between year end and financial year average CPIH for initial balance"},{"$f":" F$63","v":1.0617067134988334E-2},{"$f":" G$63","v":"%"}]
[null,null,null,null,"Check",{"$f":"F65=F66","v":true}]