{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Map & Key","Inputs","Time","Indexation","Calc","Profiling","Summary_Output"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":5,"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":20,"n_cols":4,"rows_kept":20,"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:","Draft PR19 Revenue adjustments feeder model"]
[null,null,"Version number:","01h"]
[null,null,"Filename:",{"$f":" \"PR19 Revenue adjustments feeder model \" & D4 & \".xlsm\"","v":"PR19 Revenue adjustments feeder model 01h.xlsm"}]
[null,null,"Date:","2017-07-19"]
[null,null,"Author:","Ofwat and F1F9 UK Ltd"]
[null,null,"Author contact information:","financial.modelling@ofwat.gsi.gov.uk"]
[]
[]
[null,null,"Summary of model:","The model is designed to take the revenue adjustment outputs from the PR09 and PR14 reconciliations and convert them for use in the financial model in line with"]
[null,null,null,"the proposals set out in the accounting for past delivery chapter of the PR19 methodology consultation document."]
[]
[null,null,"Known limitations:","The model has been subject to internal Ofwat quality assurance. Further quality assurance will be performed on the model."]
[]
[null,null,"Feedback:","We would welcome feedback on this draft of the PR19 Revenue adjustments feeder model. Please send any feedback to the following email address by 30 August 2017."]
[null,null,null,"water2020@ofwat.gsi.gov.uk"]
[]
[]
["End of sheet"]

{"sheet":"Map & Key","index":1,"n_rows":124,"n_cols":22,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Map & Key"}]
[]
["GENERIC MODEL DESIGN"]
[]
[null,null,null,null,null,"ABOVE BONNET - USER INTERFACE"]
[]
[]
[null,null,null,null,null,null,null,"Inputs",null,null,null,null,null,null,null,"Output Summary"]
[]
[]
[]
[]
[null,null,null,null,null,"BELOW BONNET - CALCULATION ENGINE"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Input Transition",null,null,null,"Calculations",null,null,null,"Detailed Outputs"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Note: FAST strictly applicable below the bonnet"]
[]
[]
["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":"Summary_Output!$A$1","v":"Summary_Output"},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,"A summary of links of major output of this model.",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,"All the indexation related calculations are done in this sheet."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calc!$A$1","v":"Calc"}]
[null,null,null,null,null,null,null,null,null,null,null,"All the price regulations related calculations are done in this sheet."]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Profiling!$A$1","v":"Profiling"}]
[null,null,null,null,null,null,null,null,null,null,null,"All the profiling of revenue inputs related calculations are done in this sheet."]
[]
[]
[]
[]
["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,"BR","Bio resources"]
[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,"WR","Water resources"]
[null,null,null,null,null,null,null,"WN","Water network"]
[null,null,null,null,null,null,null,"WWN","Wastewater network"]
[]
[]
["NAMES"]
[]
[null,null,null,null,null,null,null,"NO NAME RANGES PRESENT IN THE MODEL"]
[]
[]
["LIST OF 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"]
[]
[]
["End of sheet"]

{"sheet":"Inputs","index":2,"n_rows":139,"n_cols":22,"rows_kept":139,"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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[{"$f":" IF(COUNTIF(A6:A139,\"< 0\") + COUNTIF(A6:A139,\">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},{"$f":" Time!V$10","v":13}]
[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,"Forecast start date","2020-04-01","date"]
[null,null,null,null,"Forecast duration",5,"years"]
[null,null,null,null,"Forecast duration (text)",{"$f":" YEAR(F26) & \"-\" & TEXT(DATE(YEAR(F26) + F27, 1, 1), \"yy\")","v":"2020-25"},"years #","For info. only"]
[]
[]
["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]
[null,null,null,null,"Consumer Price Index for July",null,"index",null,null,95.7,98,99.6,100,100.9]
[null,null,null,null,"Consumer Price Index for August",null,"index",null,null,96.1,98.4,99.9,100.3,101.2]
[null,null,null,null,"Consumer Price Index for September",null,"index",null,null,96.4,98.7,100,100.2,101.5]
[null,null,null,null,"Consumer Price Index for October",null,"index",null,null,96.8,98.8,100.1,100.3,101.6]
[null,null,null,null,"Consumer Price Index for November",null,"index",null,null,97,98.8,99.9,100.3,101.8]
[null,null,null,null,"Consumer Price Index for December",null,"index",null,null,97.3,99.2,99.9,100.4,102.2]
[null,null,null,null,"Consumer Price Index for January",null,"index",null,null,97,98.7,99.2,99.9,101.8]
[null,null,null,null,"Consumer Price Index for February",null,"index",null,null,97.5,99.1,99.5,100.1,102.4]
[null,null,null,null,"Consumer Price Index for March",null,"index",null,null,97.8,99.3,99.6,100.4,102.7]
[]
[null,null,null,null,"CPIH: Assumed percentage increase for unpopulated monthly values",null,"%"]
[]
[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]
[null,null,null,null,"Retail Price Index for July",null,"index",null,null,242.1,249.7,256,258.60000000000002,263.39999999999998]
[null,null,null,null,"Retail Price Index for August",null,"index",null,null,243,251,257,259.8,264.39999999999998]
[null,null,null,null,"Retail Price Index for September",null,"index",null,null,244.2,251.9,257.60000000000002,259.60000000000002,264.89999999999998]
[null,null,null,null,"Retail Price Index for October",null,"index",null,null,245.6,251.9,257.7,259.5,264.8]
[null,null,null,null,"Retail Price Index for November",null,"index",null,null,245.6,252.1,257.10000000000002,259.8,265.5]
[null,null,null,null,"Retail Price Index for December",null,"index",null,null,246.8,253.4,257.5,260.60000000000002,267.10000000000002]
[null,null,null,null,"Retail Price Index for January",null,"index",null,null,245.8,252.6,255.4,258.8,265.5]
[null,null,null,null,"Retail Price Index for February",null,"index",null,null,247.6,254.2,256.7,260,268.39999999999998]
[null,null,null,null,"Retail Price Index for March",null,"index",null,null,248.7,254.8,257.10000000000002,261.10000000000002,269.3]
[]
[null,null,null,null,"RPI: Assumed percentage increase for unpopulated monthly values",null,"%"]
[]
[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 1",2020,"year #"]
[null,null,null,null,"Year reference for FYE base price 2",2019,"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: REVENUE INPUTS"]
[]
[null,"Water services"]
[]
[null,null,null,null,"Water trading - water services",null,"£m","2017/18 FYA"]
[]
[null,null,null,"Water network + "]
[null,null,null,null,"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network",null,"£m","2012/13 FYA"]
[null,null,null,null,"ODI - Water network",null,"£m","2012/13 FYA"]
[null,null,null,null,"Totex - Water network",null,"£m","2012/13 FYA"]
[null,null,null,null,"Water trading - Water network",null,"£m","2017/18 FYA"]
[null,null,null,null,"WRFIM - Water network",null,"£m","November 2018/2019"]
[]
[null,"Wastewater network +"]
[]
[null,null,null,null,"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network",null,"£m","2012/13 FYA"]
[null,null,null,null,"ODI - Wastewater network",null,"£m","2012/13 FYA"]
[null,null,null,null,"Totex - Wastewater network",null,"£m","2012/13 FYA"]
[null,null,null,null,"WRFIM - Wastewater network",null,"£m","November 2018/2019"]
[]
[]
[null,"Residential retail"]
[]
[null,null,null,null,"Residential retail revenue",null,"£m","2019/20 FYE"]
[null,null,null,null,"Residential retail - SIM",null,"£m","2017/18 FYA"]
[]
[]
[]
["D: PROFILING INPUTS"]
[]
[null,"Discounting"]
[]
[null,null,null,null,"PV base date","2021-03-31","date"]
[]
[null,null,null,null,"Discount rate - Water resources",null,"%"]
[null,null,null,null,"Discount rate - Water network",null,"%"]
[null,null,null,null,"Discount rate - Wastewater network",null,"%"]
[null,null,null,null,"Discount rate - Residential retail",null,"%"]
[]
[null,null,null,null,"Number of years to profile over",null,"#"]
[]
[null,"Profile selector"]
[]
[null,null,null,null,"Water resources revenue adjustment selector",2,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Water network revenue adjustment selector",2,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Wastewater network revenue adjustment selector",2,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Residential retail revenue adjustment selector",2,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[]
[]
["E: 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]"]

{"sheet":"Time","index":3,"n_rows":103,"n_cols":22,"rows_kept":103,"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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[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},{"$f":" Time!V$10","v":13}]
[]
["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,{"$f":" P10 + 1","v":8},{"$f":" Q10 + 1","v":9},{"$f":" R10 + 1","v":10},{"$f":" S10 + 1","v":11},{"$f":" T10 + 1","v":12},{"$f":" U10 + 1","v":13}]
[null,null,null,null,"Model column total",{"$f":" MAX(J10:V10)","v":13},"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,13]
[null,null,null,null,"1st model column flag",null,"flag",{"$f":" SUM(J14:V14)","v":1},null,{"$f":" IF(J13 = 1, 1, 0)","v":1},0,0,0,0,0,0,{"$f":" IF(Q13 = 1, 1, 0)","v":0},0,0,0,0,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$132","v":"Months per model period"},{"$f":" Inputs!F$132","v":12},{"$f":" Inputs!G$132","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,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",{"$f":" IF(Q19 = 1, $F17, DATE(YEAR(P20), MONTH(P20) + $F18, DAY(1)))","v":"2019-04-01"},{"$f":" IF(R19 = 1, $F17, DATE(YEAR(Q20), MONTH(Q20) + $F18, DAY(1)))","v":"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"},{"$f":" IF(V19 = 1, $F17, DATE(YEAR(U20), MONTH(U20) + $F18, DAY(1)))","v":"2024-04-01"}]
[]
[null,"Model period ending"]
[null,null,null,null,{"$f":" Inputs!E$132","v":"Months per model period"},{"$f":" Inputs!F$132","v":12},{"$f":" Inputs!G$132","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","2024-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",{"$f":" DATE(YEAR(Q24), MONTH(Q24) + $F23, DAY(Q24) - 1)","v":"2020-03-31"},"2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[]
[]
["FORECAST PERIOD"]
[]
[null,"Forecast start period flag"]
[null,null,null,null,{"$f":" Inputs!E$26","v":"Forecast start date"},{"$f":" Inputs!F$26","v":"2020-04-01"},{"$f":" Inputs!G$26","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","2024-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","2025-03-31"]
[null,null,null,null,"Forecast start period flag",null,"flag",{"$f":" SUM(J34:V34)","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,{"$f":" IF(AND($F31 >= Q32, $F31 <= Q33), 1, 0)","v":0},1,0,0,0,0]
[]
[null,"Forecast end period flag"]
[null,null,null,null,{"$f":" Inputs!E$26","v":"Forecast start date"},{"$f":" Inputs!F$26","v":"2020-04-01"},{"$f":" Inputs!G$26","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E$27","v":"Forecast duration"},{"$f":" Inputs!F$27","v":5},{"$f":" Inputs!G$27","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","2024-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","2025-03-31"]
[null,null,null,null,"Forecast end period flag",null,"flag",{"$f":" SUM(J44:V44)","v":1},null,{"$f":" IF(AND($F41 >= J42, $F41 <= J43), 1, 0)","v":0},0,0,0,0,0,0,{"$f":" IF(AND($F41 >= Q42, $F41 <= Q43), 1, 0)","v":0},0,0,0,0,1]
[]
[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,0]
[null,null,null,null,{"$f":" E$44","v":"Forecast end period flag"},{"$f":" F$44","v":0},"flag",1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,null,"Forecast period flag",null,"flag",{"$f":" SUM(J49:V49)","v":5},null,{"$f":" J47 + I49 - I48","v":0},{"$f":" K47 + J49 - J48","v":0},0,0,0,0,0,{"$f":" Q47 + P49 - P48","v":0},{"$f":" R47 + Q49 - Q48","v":1},{"$f":" S47 + R49 - R48","v":1},{"$f":" T47 + S49 - S48","v":1},{"$f":" U47 + T49 - T48","v":1},{"$f":" V47 + U49 - U48","v":1}]
[null,null,null,null,"Total number of forecast periods ",{"$f":" SUM(J49:V49)","v":5},"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,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,0]
[null,null,null,null,"Pre-forecast period flag",null,"flag",{"$f":" SUM(J55:V55)","v":8},null,{"$f":" J53 + I55 - J54","v":1},{"$f":" K53 + J55 - K54","v":1},1,1,1,1,1,{"$f":" Q53 + P55 - Q54","v":1},{"$f":" R53 + Q55 - R54","v":0},{"$f":" S53 + R55 - S54","v":0},{"$f":" T53 + S55 - T54","v":0},{"$f":" U53 + T55 - U54","v":0},{"$f":" V53 + U55 - V54","v":0}]
[null,null,null,null,"Pre-forecast period flag - total",{"$f":" SUM(J55:V55)","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",1,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,null,"First post-forecast period flag",null,"flag",{"$f":" SUM(J60:V60)","v":0},null,{"$f":" I59","v":0},{"$f":" J59","v":0},0,0,0,0,0,{"$f":" P59","v":0},{"$f":" Q59","v":0},{"$f":" R59","v":0},{"$f":" S59","v":0},{"$f":" T59","v":0},{"$f":" U59","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,0]
[null,null,null,null,"Post-forecast period flag",null,"flag",{"$f":" SUM(J64:V64)","v":0},null,{"$f":" J63 + I64","v":0},{"$f":" K63 + J64","v":0},0,0,0,0,0,{"$f":" Q63 + P64","v":0},{"$f":" R63 + Q64","v":0},{"$f":" S63 + R64","v":0},{"$f":" T63 + S64","v":0},{"$f":" U63 + T64","v":0},{"$f":" V63 + U64","v":0}]
[null,null,null,null,"Post-forecast period - total",{"$f":" SUM(J64:V64)","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,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,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,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,{"$f":" P74 + SUM(Q71:Q73)","v":1},{"$f":" Q74 + SUM(R71:R73)","v":2},{"$f":" R74 + SUM(S71:S73)","v":2},{"$f":" S74 + SUM(T71:T73)","v":2},{"$f":" T74 + SUM(U71:U73)","v":2},{"$f":" U74 + SUM(V71:V73)","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,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",{"$f":" INDEX($F76:$F78, Q79)","v":"Pre-Fcst"},"Forecast","Forecast","Forecast","Forecast","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,0]
[null,null,null,null,{"$f":" E$49","v":"Forecast period flag"},{"$f":" F$49","v":0},"flag",5,0,0,0,0,0,0,0,0,0,1,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,0]
[null,null,null,null,"No. of overlapping in flags",null,"#",{"$f":" SUM(J86:V86)","v":0},null,{"$f":" MAX(0, SUM(J83:J85) - 1)","v":0},0,0,0,0,0,0,{"$f":" MAX(0, SUM(Q83:Q85) - 1)","v":0},0,0,0,0,0]
[null,null,null,null,"Overlapping in periods - total",{"$f":" SUM(J86:V86)","v":0},"periods"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column total"},{"$f":" F$11","v":13},{"$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":5},{"$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","2025-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,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,{"$f":" IF(Q102 = 1, $F99, IF(Q101 > (DATE(P103, $F100 + 1, 1) - 1), P103 + 1, P103))","v":2020},{"$f":" IF(R102 = 1, $F99, IF(R101 > (DATE(Q103, $F100 + 1, 1) - 1), Q103 + 1, Q103))","v":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},{"$f":" IF(V102 = 1, $F99, IF(V101 > (DATE(U103, $F100 + 1, 1) - 1), U103 + 1, U103))","v":2025}]

{"sheet":"Indexation","index":4,"n_rows":111,"n_cols":22,"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":"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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[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},{"$f":" Time!V$10","v":13}]
[]
["CPIH INDEXATION"]
[]
[null,"CPIH: Index value series"]
[null,null,null,null,{"$f":" Inputs!E$35","v":"Consumer Price Index for April"},{"$f":" Inputs!F$35","v":0},{"$f":" Inputs!G$35","v":"index"},{"$f":" Inputs!H$35","v":0},{"$f":" Inputs!I$35","v":0},{"$f":" Inputs!J$35","v":95.9},{"$f":" Inputs!K$35","v":98},{"$f":" Inputs!L$35","v":99.6},{"$f":" Inputs!M$35","v":99.9},{"$f":" Inputs!N$35","v":100.6},{"$f":" Inputs!O$35","v":103.2},{"$f":" Inputs!P$35","v":0},{"$f":" Inputs!Q$35","v":0},{"$f":" Inputs!R$35","v":0},{"$f":" Inputs!S$35","v":0},{"$f":" Inputs!T$35","v":0},{"$f":" Inputs!U$35","v":0},{"$f":" Inputs!V$35","v":0}]
[null,null,null,null,{"$f":" Inputs!E$36","v":"Consumer Price Index for May"},{"$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.2},{"$f":" Inputs!L$36","v":99.6},{"$f":" Inputs!M$36","v":100.1},{"$f":" Inputs!N$36","v":100.8},{"$f":" Inputs!O$36","v":103.5},{"$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},{"$f":" Inputs!V$36","v":0}]
[null,null,null,null,{"$f":" Inputs!E$37","v":"Consumer Price Index for June"},{"$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.6},{"$f":" Inputs!K$37","v":98},{"$f":" Inputs!L$37","v":99.8},{"$f":" Inputs!M$37","v":100.1},{"$f":" Inputs!N$37","v":101},{"$f":" Inputs!O$37","v":0},{"$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},{"$f":" Inputs!V$37","v":0}]
[null,null,null,null,{"$f":" Inputs!E$38","v":"Consumer Price Index for July"},{"$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.7},{"$f":" Inputs!K$38","v":98},{"$f":" Inputs!L$38","v":99.6},{"$f":" Inputs!M$38","v":100},{"$f":" Inputs!N$38","v":100.9},{"$f":" Inputs!O$38","v":0},{"$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},{"$f":" Inputs!V$38","v":0}]
[null,null,null,null,{"$f":" Inputs!E$39","v":"Consumer Price Index for August"},{"$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":96.1},{"$f":" Inputs!K$39","v":98.4},{"$f":" Inputs!L$39","v":99.9},{"$f":" Inputs!M$39","v":100.3},{"$f":" Inputs!N$39","v":101.2},{"$f":" Inputs!O$39","v":0},{"$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},{"$f":" Inputs!V$39","v":0}]
[null,null,null,null,{"$f":" Inputs!E$40","v":"Consumer Price Index for September"},{"$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.4},{"$f":" Inputs!K$40","v":98.7},{"$f":" Inputs!L$40","v":100},{"$f":" Inputs!M$40","v":100.2},{"$f":" Inputs!N$40","v":101.5},{"$f":" Inputs!O$40","v":0},{"$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},{"$f":" Inputs!V$40","v":0}]
[null,null,null,null,{"$f":" Inputs!E$41","v":"Consumer Price Index for October"},{"$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.8},{"$f":" Inputs!K$41","v":98.8},{"$f":" Inputs!L$41","v":100.1},{"$f":" Inputs!M$41","v":100.3},{"$f":" Inputs!N$41","v":101.6},{"$f":" Inputs!O$41","v":0},{"$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},{"$f":" Inputs!V$41","v":0}]
[null,null,null,null,{"$f":" Inputs!E$42","v":"Consumer Price Index for November"},{"$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":97},{"$f":" Inputs!K$42","v":98.8},{"$f":" Inputs!L$42","v":99.9},{"$f":" Inputs!M$42","v":100.3},{"$f":" Inputs!N$42","v":101.8},{"$f":" Inputs!O$42","v":0},{"$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},{"$f":" Inputs!V$42","v":0}]
[null,null,null,null,{"$f":" Inputs!E$43","v":"Consumer Price Index for December"},{"$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.3},{"$f":" Inputs!K$43","v":99.2},{"$f":" Inputs!L$43","v":99.9},{"$f":" Inputs!M$43","v":100.4},{"$f":" Inputs!N$43","v":102.2},{"$f":" Inputs!O$43","v":0},{"$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},{"$f":" Inputs!V$43","v":0}]
[null,null,null,null,{"$f":" Inputs!E$44","v":"Consumer Price Index for January"},{"$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},{"$f":" Inputs!K$44","v":98.7},{"$f":" Inputs!L$44","v":99.2},{"$f":" Inputs!M$44","v":99.9},{"$f":" Inputs!N$44","v":101.8},{"$f":" Inputs!O$44","v":0},{"$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},{"$f":" Inputs!V$44","v":0}]
[null,null,null,null,{"$f":" Inputs!E$45","v":"Consumer Price Index for February"},{"$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.5},{"$f":" Inputs!K$45","v":99.1},{"$f":" Inputs!L$45","v":99.5},{"$f":" Inputs!M$45","v":100.1},{"$f":" Inputs!N$45","v":102.4},{"$f":" Inputs!O$45","v":0},{"$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},{"$f":" Inputs!V$45","v":0}]
[null,null,null,null,{"$f":" Inputs!E$46","v":"Consumer Price Index for March"},{"$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.8},{"$f":" Inputs!K$46","v":99.3},{"$f":" Inputs!L$46","v":99.6},{"$f":" Inputs!M$46","v":100.4},{"$f":" Inputs!N$46","v":102.7},{"$f":" Inputs!O$46","v":0},{"$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},{"$f":" Inputs!V$46","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$48","v":"CPIH: Assumed percentage increase for unpopulated monthly values"},{"$f":" Inputs!F$48","v":0},{"$f":" Inputs!G$48","v":"%"},{"$f":" Inputs!H$48","v":0},{"$f":" Inputs!I$48","v":0},{"$f":" Inputs!J$48","v":0},{"$f":" Inputs!K$48","v":0},{"$f":" Inputs!L$48","v":0},{"$f":" Inputs!M$48","v":0},{"$f":" Inputs!N$48","v":0},{"$f":" Inputs!O$48","v":0},{"$f":" Inputs!P$48","v":0},{"$f":" Inputs!Q$48","v":0},{"$f":" Inputs!R$48","v":0},{"$f":" Inputs!S$48","v":0},{"$f":" Inputs!T$48","v":0},{"$f":" Inputs!U$48","v":0},{"$f":" Inputs!V$48","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,103.2,{"$f":" IF(Q10 > 0, Q10, P25 * (1 + Q$23))","v":103.2},{"$f":" IF(R10 > 0, R10, Q25 * (1 + R$23))","v":103.2},{"$f":" IF(S10 > 0, S10, R25 * (1 + S$23))","v":103.2},{"$f":" IF(T10 > 0, T10, S25 * (1 + T$23))","v":103.2},{"$f":" IF(U10 > 0, U10, T25 * (1 + U$23))","v":103.2},{"$f":" IF(V10 > 0, V10, U25 * (1 + V$23))","v":103.2}]
[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,103.5,103.5,103.5,103.5,103.5,103.5,103.5]
[null,null,null,null,"CPIH: June - index",null,"index",null,null,95.6,98,99.8,100.1,101,101,101,101,101,101,101,101,101]
[null,null,null,null,"CPIH: July - index",null,"index",null,null,95.7,98,99.6,100,100.9,100.9,100.9,100.9,100.9,100.9,100.9,100.9,100.9]
[null,null,null,null,"CPIH: August - index",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,101.2,101.2,101.2,101.2,101.2,101.2,101.2,101.2]
[null,null,null,null,"CPIH: September- index",null,"index",null,null,96.4,98.7,100,100.2,101.5,101.5,101.5,101.5,101.5,101.5,101.5,101.5,101.5]
[null,null,null,null,"CPIH: October - index",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,101.6,101.6,101.6,101.6,101.6,101.6,101.6,101.6]
[null,null,null,null,"CPIH: November - index",null,"index",null,null,97,98.8,99.9,100.3,101.8,101.8,101.8,101.8,101.8,101.8,101.8,101.8,101.8]
[null,null,null,null,"CPIH: December - index",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,102.2,102.2,102.2,102.2,102.2,102.2,102.2,102.2]
[null,null,null,null,"CPIH: January - index",null,"index",null,null,97,98.7,99.2,99.9,101.8,101.8,101.8,101.8,101.8,101.8,101.8,101.8,101.8]
[null,null,null,null,"CPIH: February - index",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,102.4,102.4,102.4,102.4,102.4,102.4,102.4,102.4]
[null,null,null,null,"CPIH: March - index",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,102.7,102.7,102.7,102.7,102.7,102.7,102.7,102.7]
[]
[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,101.98333333333333,101.98333333333333,{"$f":" AVERAGE(Q25:Q36)","v":101.98333333333333},101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333]
[]
[]
["RPI INDEXATION"]
[]
[null,"RPI: Index value series"]
[null,null,null,null,{"$f":" Inputs!E$52","v":"Retail Price Index for April"},{"$f":" Inputs!F$52","v":0},{"$f":" Inputs!G$52","v":"index"},{"$f":" Inputs!H$52","v":0},{"$f":" Inputs!I$52","v":0},{"$f":" Inputs!J$52","v":242.5},{"$f":" Inputs!K$52","v":249.5},{"$f":" Inputs!L$52","v":255.7},{"$f":" Inputs!M$52","v":258},{"$f":" Inputs!N$52","v":261.39999999999998},{"$f":" Inputs!O$52","v":270.60000000000002},{"$f":" Inputs!P$52","v":0},{"$f":" Inputs!Q$52","v":0},{"$f":" Inputs!R$52","v":0},{"$f":" Inputs!S$52","v":0},{"$f":" Inputs!T$52","v":0},{"$f":" Inputs!U$52","v":0},{"$f":" Inputs!V$52","v":0}]
[null,null,null,null,{"$f":" Inputs!E$53","v":"Retail Price Index for May"},{"$f":" Inputs!F$53","v":0},{"$f":" Inputs!G$53","v":"index"},{"$f":" Inputs!H$53","v":0},{"$f":" Inputs!I$53","v":0},{"$f":" Inputs!J$53","v":242.4},{"$f":" Inputs!K$53","v":250},{"$f":" Inputs!L$53","v":255.9},{"$f":" Inputs!M$53","v":258.5},{"$f":" Inputs!N$53","v":262.10000000000002},{"$f":" Inputs!O$53","v":271.7},{"$f":" Inputs!P$53","v":0},{"$f":" Inputs!Q$53","v":0},{"$f":" Inputs!R$53","v":0},{"$f":" Inputs!S$53","v":0},{"$f":" Inputs!T$53","v":0},{"$f":" Inputs!U$53","v":0},{"$f":" Inputs!V$53","v":0}]
[null,null,null,null,{"$f":" Inputs!E$54","v":"Retail Price Index for June"},{"$f":" Inputs!F$54","v":0},{"$f":" Inputs!G$54","v":"index"},{"$f":" Inputs!H$54","v":0},{"$f":" Inputs!I$54","v":0},{"$f":" Inputs!J$54","v":241.8},{"$f":" Inputs!K$54","v":249.7},{"$f":" Inputs!L$54","v":256.3},{"$f":" Inputs!M$54","v":258.89999999999998},{"$f":" Inputs!N$54","v":263.10000000000002},{"$f":" Inputs!O$54","v":0},{"$f":" Inputs!P$54","v":0},{"$f":" Inputs!Q$54","v":0},{"$f":" Inputs!R$54","v":0},{"$f":" Inputs!S$54","v":0},{"$f":" Inputs!T$54","v":0},{"$f":" Inputs!U$54","v":0},{"$f":" Inputs!V$54","v":0}]
[null,null,null,null,{"$f":" Inputs!E$55","v":"Retail Price Index for July"},{"$f":" Inputs!F$55","v":0},{"$f":" Inputs!G$55","v":"index"},{"$f":" Inputs!H$55","v":0},{"$f":" Inputs!I$55","v":0},{"$f":" Inputs!J$55","v":242.1},{"$f":" Inputs!K$55","v":249.7},{"$f":" Inputs!L$55","v":256},{"$f":" Inputs!M$55","v":258.60000000000002},{"$f":" Inputs!N$55","v":263.39999999999998},{"$f":" Inputs!O$55","v":0},{"$f":" Inputs!P$55","v":0},{"$f":" Inputs!Q$55","v":0},{"$f":" Inputs!R$55","v":0},{"$f":" Inputs!S$55","v":0},{"$f":" Inputs!T$55","v":0},{"$f":" Inputs!U$55","v":0},{"$f":" Inputs!V$55","v":0}]
[null,null,null,null,{"$f":" Inputs!E$56","v":"Retail Price Index for August"},{"$f":" Inputs!F$56","v":0},{"$f":" Inputs!G$56","v":"index"},{"$f":" Inputs!H$56","v":0},{"$f":" Inputs!I$56","v":0},{"$f":" Inputs!J$56","v":243},{"$f":" Inputs!K$56","v":251},{"$f":" Inputs!L$56","v":257},{"$f":" Inputs!M$56","v":259.8},{"$f":" Inputs!N$56","v":264.39999999999998},{"$f":" Inputs!O$56","v":0},{"$f":" Inputs!P$56","v":0},{"$f":" Inputs!Q$56","v":0},{"$f":" Inputs!R$56","v":0},{"$f":" Inputs!S$56","v":0},{"$f":" Inputs!T$56","v":0},{"$f":" Inputs!U$56","v":0},{"$f":" Inputs!V$56","v":0}]
[null,null,null,null,{"$f":" Inputs!E$57","v":"Retail Price Index for September"},{"$f":" Inputs!F$57","v":0},{"$f":" Inputs!G$57","v":"index"},{"$f":" Inputs!H$57","v":0},{"$f":" Inputs!I$57","v":0},{"$f":" Inputs!J$57","v":244.2},{"$f":" Inputs!K$57","v":251.9},{"$f":" Inputs!L$57","v":257.60000000000002},{"$f":" Inputs!M$57","v":259.60000000000002},{"$f":" Inputs!N$57","v":264.89999999999998},{"$f":" Inputs!O$57","v":0},{"$f":" Inputs!P$57","v":0},{"$f":" Inputs!Q$57","v":0},{"$f":" Inputs!R$57","v":0},{"$f":" Inputs!S$57","v":0},{"$f":" Inputs!T$57","v":0},{"$f":" Inputs!U$57","v":0},{"$f":" Inputs!V$57","v":0}]
[null,null,null,null,{"$f":" Inputs!E$58","v":"Retail Price Index for October"},{"$f":" Inputs!F$58","v":0},{"$f":" Inputs!G$58","v":"index"},{"$f":" Inputs!H$58","v":0},{"$f":" Inputs!I$58","v":0},{"$f":" Inputs!J$58","v":245.6},{"$f":" Inputs!K$58","v":251.9},{"$f":" Inputs!L$58","v":257.7},{"$f":" Inputs!M$58","v":259.5},{"$f":" Inputs!N$58","v":264.8},{"$f":" Inputs!O$58","v":0},{"$f":" Inputs!P$58","v":0},{"$f":" Inputs!Q$58","v":0},{"$f":" Inputs!R$58","v":0},{"$f":" Inputs!S$58","v":0},{"$f":" Inputs!T$58","v":0},{"$f":" Inputs!U$58","v":0},{"$f":" Inputs!V$58","v":0}]
[null,null,null,null,{"$f":" Inputs!E$59","v":"Retail Price Index for November"},{"$f":" Inputs!F$59","v":0},{"$f":" Inputs!G$59","v":"index"},{"$f":" Inputs!H$59","v":0},{"$f":" Inputs!I$59","v":0},{"$f":" Inputs!J$59","v":245.6},{"$f":" Inputs!K$59","v":252.1},{"$f":" Inputs!L$59","v":257.10000000000002},{"$f":" Inputs!M$59","v":259.8},{"$f":" Inputs!N$59","v":265.5},{"$f":" Inputs!O$59","v":0},{"$f":" Inputs!P$59","v":0},{"$f":" Inputs!Q$59","v":0},{"$f":" Inputs!R$59","v":0},{"$f":" Inputs!S$59","v":0},{"$f":" Inputs!T$59","v":0},{"$f":" Inputs!U$59","v":0},{"$f":" Inputs!V$59","v":0}]
[null,null,null,null,{"$f":" Inputs!E$60","v":"Retail Price Index for December"},{"$f":" Inputs!F$60","v":0},{"$f":" Inputs!G$60","v":"index"},{"$f":" Inputs!H$60","v":0},{"$f":" Inputs!I$60","v":0},{"$f":" Inputs!J$60","v":246.8},{"$f":" Inputs!K$60","v":253.4},{"$f":" Inputs!L$60","v":257.5},{"$f":" Inputs!M$60","v":260.60000000000002},{"$f":" Inputs!N$60","v":267.10000000000002},{"$f":" Inputs!O$60","v":0},{"$f":" Inputs!P$60","v":0},{"$f":" Inputs!Q$60","v":0},{"$f":" Inputs!R$60","v":0},{"$f":" Inputs!S$60","v":0},{"$f":" Inputs!T$60","v":0},{"$f":" Inputs!U$60","v":0},{"$f":" Inputs!V$60","v":0}]
[null,null,null,null,{"$f":" Inputs!E$61","v":"Retail Price Index for January"},{"$f":" Inputs!F$61","v":0},{"$f":" Inputs!G$61","v":"index"},{"$f":" Inputs!H$61","v":0},{"$f":" Inputs!I$61","v":0},{"$f":" Inputs!J$61","v":245.8},{"$f":" Inputs!K$61","v":252.6},{"$f":" Inputs!L$61","v":255.4},{"$f":" Inputs!M$61","v":258.8},{"$f":" Inputs!N$61","v":265.5},{"$f":" Inputs!O$61","v":0},{"$f":" Inputs!P$61","v":0},{"$f":" Inputs!Q$61","v":0},{"$f":" Inputs!R$61","v":0},{"$f":" Inputs!S$61","v":0},{"$f":" Inputs!T$61","v":0},{"$f":" Inputs!U$61","v":0},{"$f":" Inputs!V$61","v":0}]
[null,null,null,null,{"$f":" Inputs!E$62","v":"Retail Price Index for February"},{"$f":" Inputs!F$62","v":0},{"$f":" Inputs!G$62","v":"index"},{"$f":" Inputs!H$62","v":0},{"$f":" Inputs!I$62","v":0},{"$f":" Inputs!J$62","v":247.6},{"$f":" Inputs!K$62","v":254.2},{"$f":" Inputs!L$62","v":256.7},{"$f":" Inputs!M$62","v":260},{"$f":" Inputs!N$62","v":268.39999999999998},{"$f":" Inputs!O$62","v":0},{"$f":" Inputs!P$62","v":0},{"$f":" Inputs!Q$62","v":0},{"$f":" Inputs!R$62","v":0},{"$f":" Inputs!S$62","v":0},{"$f":" Inputs!T$62","v":0},{"$f":" Inputs!U$62","v":0},{"$f":" Inputs!V$62","v":0}]
[null,null,null,null,{"$f":" Inputs!E$63","v":"Retail Price Index for March"},{"$f":" Inputs!F$63","v":0},{"$f":" Inputs!G$63","v":"index"},{"$f":" Inputs!H$63","v":0},{"$f":" Inputs!I$63","v":0},{"$f":" Inputs!J$63","v":248.7},{"$f":" Inputs!K$63","v":254.8},{"$f":" Inputs!L$63","v":257.10000000000002},{"$f":" Inputs!M$63","v":261.10000000000002},{"$f":" Inputs!N$63","v":269.3},{"$f":" Inputs!O$63","v":0},{"$f":" Inputs!P$63","v":0},{"$f":" Inputs!Q$63","v":0},{"$f":" Inputs!R$63","v":0},{"$f":" Inputs!S$63","v":0},{"$f":" Inputs!T$63","v":0},{"$f":" Inputs!U$63","v":0},{"$f":" Inputs!V$63","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$65","v":"RPI: Assumed percentage increase for unpopulated monthly values"},{"$f":" Inputs!F$65","v":0},{"$f":" Inputs!G$65","v":"%"},{"$f":" Inputs!H$65","v":0},{"$f":" Inputs!I$65","v":0},{"$f":" Inputs!J$65","v":0},{"$f":" Inputs!K$65","v":0},{"$f":" Inputs!L$65","v":0},{"$f":" Inputs!M$65","v":0},{"$f":" Inputs!N$65","v":0},{"$f":" Inputs!O$65","v":0},{"$f":" Inputs!P$65","v":0},{"$f":" Inputs!Q$65","v":0},{"$f":" Inputs!R$65","v":0},{"$f":" Inputs!S$65","v":0},{"$f":" Inputs!T$65","v":0},{"$f":" Inputs!U$65","v":0},{"$f":" Inputs!V$65","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,270.60000000000002,{"$f":" IF(Q44 > 0, Q44, P59 * (1 + Q$57))","v":270.60000000000002},{"$f":" IF(R44 > 0, R44, Q59 * (1 + R$57))","v":270.60000000000002},{"$f":" IF(S44 > 0, S44, R59 * (1 + S$57))","v":270.60000000000002},{"$f":" IF(T44 > 0, T44, S59 * (1 + T$57))","v":270.60000000000002},{"$f":" IF(U44 > 0, U44, T59 * (1 + U$57))","v":270.60000000000002},{"$f":" IF(V44 > 0, V44, U59 * (1 + V$57))","v":270.60000000000002}]
[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,271.7,271.7,271.7,271.7,271.7,271.7,271.7]
[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,263.10000000000002,263.10000000000002,263.10000000000002,263.10000000000002,263.10000000000002,263.10000000000002,263.10000000000002,263.10000000000002]
[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,263.39999999999998,263.39999999999998,263.39999999999998,263.39999999999998,263.39999999999998,263.39999999999998,263.39999999999998,263.39999999999998]
[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,264.39999999999998,264.39999999999998,264.39999999999998,264.39999999999998,264.39999999999998,264.39999999999998,264.39999999999998,264.39999999999998]
[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,264.89999999999998,264.89999999999998,264.89999999999998,264.89999999999998,264.89999999999998,264.89999999999998,264.89999999999998,264.89999999999998]
[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,264.8,264.8,264.8,264.8,264.8,264.8,264.8,264.8]
[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,265.5,265.5,265.5,265.5,265.5,265.5,265.5,265.5]
[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,267.10000000000002,267.10000000000002,267.10000000000002,267.10000000000002,267.10000000000002,267.10000000000002,267.10000000000002,267.10000000000002]
[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,265.5,265.5,265.5,265.5,265.5,265.5,265.5,265.5]
[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,268.39999999999998,268.39999999999998,268.39999999999998,268.39999999999998,268.39999999999998,268.39999999999998,268.39999999999998,268.39999999999998]
[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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[]
[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,266.55833333333334,266.55833333333334,{"$f":" AVERAGE(Q59:Q70)","v":266.55833333333334},266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334]
[]
[]
["INFLATION"]
[]
[null,{"$f":" \"Inflation from \" & F78 & \" FYA to \" & F79 & \" FYE - RPI\"","v":"Inflation from 2013 FYA to 2020 FYE - RPI"}]
[null,null,null,null,{"$f":" Inputs!E$69","v":"Year reference for FYA base price 1"},{"$f":" Inputs!F$69","v":2013},{"$f":" Inputs!G$69","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$73","v":"Year reference for FYE end price"},{"$f":" Inputs!F$73","v":2020},{"$f":" Inputs!G$73","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,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334]
[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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[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:$V81, 1, MATCH($F79,$J$4:$V$4)) / INDEX($J80:$V80, 1, MATCH($F78,$J$4:$V$4))","v":1.1006437110452643},"factor"]
[]
[null,{"$f":" \"Inflation from \" & F85 & \" FYA to \" & F86 & \" FYE - RPI\"","v":"Inflation from 2018 FYA to 2020 FYE - RPI"}]
[null,null,null,null,{"$f":" Inputs!E$70","v":"Year reference for FYA base price 2"},{"$f":" Inputs!F$70","v":2018},{"$f":" Inputs!G$70","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$73","v":"Year reference for FYE end price"},{"$f":" Inputs!F$73","v":2020},{"$f":" Inputs!G$73","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,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334,266.55833333333334]
[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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[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:$V88, 1, MATCH($F86,$J$4:$V$4)) / INDEX($J87:$V87, 1, MATCH($F85,$J$4:$V$4))","v":1.01028542845531},"factor"]
[]
[null,{"$f":" \"Inflation from \" & F92 & \" FYE to \" & F93 & \" FYE - RPI\"","v":"Inflation from 2020 FYE to 2020 FYE - RPI"}]
[null,null,null,null,{"$f":" Inputs!E$71","v":"Year reference for FYE base price 1"},{"$f":" Inputs!F$71","v":2020},{"$f":" Inputs!G$71","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$73","v":"Year reference for FYE end price"},{"$f":" Inputs!F$73","v":2020},{"$f":" Inputs!G$73","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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F92 & \" FYE to \" & F93 & \" FYE\"","v":"RPI inflate from 2020 FYE to 2020 FYE"},{"$f":" INDEX($J94:$V94, 1, MATCH($F93,$J$4:$V$4)) / INDEX($J94:$V94, 1, MATCH($F92,$J$4:$V$4))","v":1},"factor"]
[]
[null,{"$f":" \"Inflation from November \" & F98 & \" FYE to \" & F99 & \" FYE - RPI\"","v":"Inflation from November 2019 FYE to 2020 FYE - RPI"}]
[null,null,null,null,{"$f":" Inputs!E$72","v":"Year reference for FYE base price 2"},{"$f":" Inputs!F$72","v":2019},{"$f":" Inputs!G$72","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$73","v":"Year reference for FYE end price"},{"$f":" Inputs!F$73","v":2020},{"$f":" Inputs!G$73","v":"year #"}]
[null,null,null,null,{"$f":" E$66","v":"RPI: November - index"},0,"index",0,0,245.6,252.1,257.10000000000002,259.8,265.5,265.5,265.5,265.5,265.5,265.5,265.5,265.5,265.5]
[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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[null,null,null,null,{"$f":" \"RPI inflate from November \" & F98 & \" FYE to \" & F99 & \" FYE\"","v":"RPI inflate from November 2019 FYE to 2020 FYE"},{"$f":" INDEX($J101:$V101, 1, MATCH($F99,$J$4:$V$4)) / INDEX($J100:$V100, 1, MATCH($F98,$J$4:$V$4))","v":1.0143126177024482},"factor"]
[]
[]
["DEFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$77","v":"Year reference for FYE base price"},{"$f":" Inputs!F$77","v":2020},{"$f":" Inputs!G$77","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$78","v":"Year reference for FYA end price"},{"$f":" Inputs!F$78","v":2018},{"$f":" Inputs!G$78","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,269.3,269.3,269.3,269.3,269.3,269.3,269.3,269.3]
[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,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333,101.98333333333333]
[null,null,null,null,{"$f":" \"CPIH deflate from \" & F107 & \" FYE to \" & F108 & \" FYA\"","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" INDEX($J110:$V110, 1, MATCH($F108,$J$4:$V$4)) / INDEX($J109:$V109, 1, MATCH($F107,$J$4:$V$4))","v":0.37869785864587202},"factor"]

{"sheet":"Calc","index":5,"n_rows":125,"n_cols":22,"rows_kept":125,"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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[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},{"$f":" Time!V$10","v":13}]
[]
["WATER SERVICES INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$85","v":"Water trading - water services"},{"$f":" Inputs!F$85","v":0},{"$f":" Inputs!G$85","v":"£m"}]
[null,null,null,null,{"$f":" Indexation!E$89","v":"RPI inflate from 2018 FYA to 2020 FYE"},{"$f":" Indexation!F$89","v":1.01028542845531},{"$f":" Indexation!G$89","v":"factor"}]
[null,null,null,null,"Water trading at 2020 FYE price base",{"$f":" F9 * F10","v":0},"£m"]
[]
[null,"Water network + "]
[null,null,null,null,{"$f":" Inputs!E$91","v":"Water trading - Water network"},{"$f":" Inputs!F$91","v":0},{"$f":" Inputs!G$91","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$92","v":"WRFIM - Water network"},{"$f":" Inputs!F$92","v":0},{"$f":" Inputs!G$92","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$89","v":"RPI inflate from 2018 FYA to 2020 FYE"},{"$f":" Indexation!F$89","v":1.01028542845531},{"$f":" Indexation!G$89","v":"factor"}]
[null,null,null,null,{"$f":" Indexation!E$102","v":"RPI inflate from November 2019 FYE to 2020 FYE"},{"$f":" Indexation!F$102","v":1.0143126177024482},{"$f":" Indexation!G$102","v":"factor"}]
[]
[null,null,null,null,"Water trading - Water network at 2020 FYE price base",{"$f":" F14 * F17","v":0},"£m"]
[null,null,null,null,"WRFIM - Water network at 2020 FYE price base",{"$f":" F15 * F18","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Inputs!E$88","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network"},{"$f":" Inputs!F$88","v":0},{"$f":" Inputs!G$88","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$89","v":"ODI - Water network"},{"$f":" Inputs!F$89","v":0},{"$f":" Inputs!G$89","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$90","v":"Totex - Water network"},{"$f":" Inputs!F$90","v":0},{"$f":" Inputs!G$90","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.1006437110452643},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E23 & \" at 2020 FYE price base\"","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2020 FYE price base"},{"$f":" F23 * F$27","v":0},"£m"]
[null,null,null,null,{"$f":" E24 & \" at 2020 FYE price base\"","v":"ODI - Water network at 2020 FYE price base"},{"$f":" F24 * F$27","v":0},"£m"]
[null,null,null,null,{"$f":" E25 & \" at 2020 FYE price base\"","v":"Totex - Water network at 2020 FYE price base"},{"$f":" F25 * F$27","v":0},"£m"]
[]
[null,"Water resources"]
[null,null,null,null,{"$f":" E$11","v":"Water trading at 2020 FYE price base"},{"$f":" F$11","v":0},"£m"]
[null,null,null,"less",{"$f":" E$20","v":"Water trading - Water network at 2020 FYE price base"},{"$f":" F$20","v":0},"£m"]
[null,null,null,null,"Water trading - Water resources at 2020 FYE price base",{"$f":" F34 - F35","v":0},"£m"]
[]
[]
["WASTEWATER NETWORK + INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$96","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network"},{"$f":" Inputs!F$96","v":0},{"$f":" Inputs!G$96","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$97","v":"ODI - Wastewater network"},{"$f":" Inputs!F$97","v":0},{"$f":" Inputs!G$97","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$98","v":"Totex - Wastewater network"},{"$f":" Inputs!F$98","v":0},{"$f":" Inputs!G$98","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.1006437110452643},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E41 & \" at 2020 FYE price base\"","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2020 FYE price base"},{"$f":" F41 * F$45","v":0},"£m"]
[null,null,null,null,{"$f":" E42 & \" at 2020 FYE price base\"","v":"ODI - Wastewater network at 2020 FYE price base"},{"$f":" F42 * F$45","v":0},"£m"]
[null,null,null,null,{"$f":" E43 & \" at 2020 FYE price base\"","v":"Totex - Wastewater network at 2020 FYE price base"},0,"£m"]
[]
[null,null,null,null,{"$f":" Inputs!E$99","v":"WRFIM - Wastewater network"},{"$f":" Inputs!F$99","v":0},{"$f":" Inputs!G$99","v":"£m"}]
[null,null,null,null,{"$f":" Indexation!E$102","v":"RPI inflate from November 2019 FYE to 2020 FYE"},{"$f":" Indexation!F$102","v":1.0143126177024482},{"$f":" Indexation!G$102","v":"factor"}]
[null,null,null,null,"WRFIM - Wastewater network at 2020 FYE price base",{"$f":" F51 * F52","v":0},"£m"]
[]
[]
["RESIDENTIAL RETAIL INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$104","v":"Residential retail revenue"},{"$f":" Inputs!F$104","v":0},{"$f":" Inputs!G$104","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$105","v":"Residential retail - SIM"},{"$f":" Inputs!F$105","v":0},{"$f":" Inputs!G$105","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$95","v":"RPI inflate from 2020 FYE to 2020 FYE"},{"$f":" Indexation!F$95","v":1},{"$f":" Indexation!G$95","v":"factor"}]
[null,null,null,null,{"$f":" Indexation!E$89","v":"RPI inflate from 2018 FYA to 2020 FYE"},{"$f":" Indexation!F$89","v":1.01028542845531},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,{"$f":" E58 & \" at 2020 FYE price base\"","v":"Residential retail revenue at 2020 FYE price base"},{"$f":" F58 * F61","v":0},"£m"]
[null,null,null,null,{"$f":" E59 & \" at 2020 FYE price base\"","v":"Residential retail - SIM at 2020 FYE price base"},{"$f":" F59 * F62","v":0},"£m"]
[]
[]
["PR14 REVENUE RECONCILIATION ADJUSTMENTS EXPRESSED IN 2017/18 FYA CPIH DEFLATED PRICE BASE"]
[]
[null,null,null,null,{"$f":" E$11","v":"Water trading at 2020 FYE price base"},{"$f":" F$11","v":0},"£m"]
[null,null,null,null,{"$f":" E$20","v":"Water trading - Water network at 2020 FYE price base"},{"$f":" F$20","v":0},"£m"]
[null,null,null,null,{"$f":" E$21","v":"WRFIM - Water network at 2020 FYE price base"},{"$f":" F$21","v":0},"£m"]
[null,null,null,null,{"$f":" E$29","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2020 FYE price base"},{"$f":" F$29","v":0},"£m"]
[null,null,null,null,{"$f":" E$30","v":"ODI - Water network at 2020 FYE price base"},{"$f":" F$30","v":0},"£m"]
[null,null,null,null,{"$f":" E$31","v":"Totex - Water network at 2020 FYE price base"},{"$f":" F$31","v":0},"£m"]
[null,null,null,null,{"$f":" E$36","v":"Water trading - Water resources at 2020 FYE price base"},{"$f":" F$36","v":0},"£m"]
[null,null,null,null,{"$f":" E$47","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2020 FYE price base"},{"$f":" F$47","v":0},"£m"]
[null,null,null,null,{"$f":" E$48","v":"ODI - Wastewater network at 2020 FYE price base"},{"$f":" F$48","v":0},"£m"]
[null,null,null,null,{"$f":" E$49","v":"Totex - Wastewater network at 2020 FYE price base"},{"$f":" F$49","v":0},"£m"]
[null,null,null,null,{"$f":" E$53","v":"WRFIM - Wastewater network at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$64","v":"Residential retail revenue at 2020 FYE price base"},{"$f":" F$64","v":0},"£m"]
[null,null,null,null,{"$f":" E$65","v":"Residential retail - SIM at 2020 FYE price base"},{"$f":" F$65","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$111","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$111","v":0.37869785864587202},{"$f":" Indexation!G$111","v":"factor"}]
[]
[null,null,null,null,"Water trading at 2017/18 FYA CPIH deflated price base",{"$f":" F70 * F$84","v":0},"£m"]
[null,null,null,null,"Water trading - Water network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"WRFIM at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI - Water network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Totex - Water network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Water trading - Water resources at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI - Wastewater network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Totex - Wastewater network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"WRFIM - Wastewater network at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Residential retail revenue at 2017/18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Residential retail - SIM at 2017/18 FYA CPIH deflated price base",0,"£m"]
[]
[]
["SUBTOTALS AS PER PRICE CONTROL FOR REVENUE ADJUSTMENTS 2017/18 FYA CPIH DEFLATED"]
[]
[null,"Water resources revenue adjustment"]
[null,null,null,null,{"$f":" E$92","v":"Water trading - Water resources at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,"Water resources revenue adjustment",{"$f":" SUM(F104)","v":0},"£m"]
[]
[null,"Water network + : revenue adjustment"]
[null,null,null,null,{"$f":" E$87","v":"Water trading - Water network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$88","v":"WRFIM at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$89","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$90","v":"ODI - Water network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$91","v":"Totex - Water network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,"Water network + : revenue adjustment",{"$f":" SUM(F108:F112)","v":0},"£m"]
[]
[null,"Wastewater network + : revenue adjustment"]
[null,null,null,null,{"$f":" E$93","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$94","v":"ODI - Wastewater network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$95","v":"Totex - Wastewater network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$96","v":"WRFIM - Wastewater network at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,"Wastewater network + : revenue adjustment",{"$f":" SUM(F116:F119)","v":0},"£m"]
[]
[null,"Residential retail revenue adjustment"]
[null,null,null,null,{"$f":" E$97","v":"Residential retail revenue at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,{"$f":" E$98","v":"Residential retail - SIM at 2017/18 FYA CPIH deflated price base"},0,"£m"]
[null,null,null,null,"Residential retail revenue adjustment",{"$f":" SUM(F123:F124)","v":0},"£m"]

{"sheet":"Profiling","index":6,"n_rows":168,"n_cols":22,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Profiling"}]
[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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[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},{"$f":" Time!V$10","v":13}]
[]
["DISCOUNT RATE FOR 2021-25"]
[]
[null,null,null,null,{"$f":" Inputs!E$113","v":"PV base date"},{"$f":" Inputs!F$113","v":"2021-03-31"},{"$f":" Inputs!G$113","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E$136","v":"Days in a year"},{"$f":" Inputs!F$136","v":365},{"$f":" Inputs!G$136","v":"days"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Time!F$25","v":"00:00:00"},{"$f":" Time!G$25","v":"date"},{"$f":" Time!H$25","v":"00:00:00"},{"$f":" Time!I$25","v":"00:00:00"},{"$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"},{"$f":" Time!V$25","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$49","v":"Forecast period flag"},{"$f":" Time!F$49","v":0},{"$f":" Time!G$49","v":"flag"},{"$f":" Time!H$49","v":5},{"$f":" Time!I$49","v":0},{"$f":" Time!J$49","v":0},{"$f":" Time!K$49","v":0},{"$f":" Time!L$49","v":0},{"$f":" Time!M$49","v":0},{"$f":" Time!N$49","v":0},{"$f":" Time!O$49","v":0},{"$f":" Time!P$49","v":0},{"$f":" Time!Q$49","v":0},{"$f":" Time!R$49","v":1},{"$f":" Time!S$49","v":1},{"$f":" Time!T$49","v":1},{"$f":" Time!U$49","v":1},{"$f":" Time!V$49","v":1}]
[null,null,null,null,"Years from valuation date",null,"years",null,null,{"$f":" IF(J11 < $F9, 0, (J11 - $F9) / $F10) * J12","v":0},0,0,0,0,0,0,{"$f":" IF(Q11 < $F9, 0, (Q11 - $F9) / $F10) * Q12","v":0},0,1,2,3.0027397260273974,4.0027397260273974]
[]
[null,null,null,null,{"$f":" Inputs!E$115","v":"Discount rate - Water resources"},{"$f":" Inputs!F$115","v":0},{"$f":" Inputs!G$115","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$116","v":"Discount rate - Water network"},{"$f":" Inputs!F$116","v":0},{"$f":" Inputs!G$116","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$117","v":"Discount rate - Wastewater network"},{"$f":" Inputs!F$117","v":0},{"$f":" Inputs!G$117","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$118","v":"Discount rate - Residential retail"},{"$f":" Inputs!F$118","v":0},{"$f":" Inputs!G$118","v":"%"}]
[]
[null,null,null,null,{"$f":" Inputs!E$113","v":"PV base date"},{"$f":" Inputs!F$113","v":"2021-03-31"},{"$f":" Inputs!G$113","v":"date"}]
[]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Time!F$25","v":"00:00:00"},{"$f":" Time!G$25","v":"date"},{"$f":" Time!H$25","v":"00:00:00"},{"$f":" Time!I$25","v":"00:00:00"},{"$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"},{"$f":" Time!V$25","v":"2025-03-31"}]
[null,null,null,null,{"$f":" E$13","v":"Years from valuation date"},0,"years",0,0,0,0,0,0,0,0,0,0,0,1,2,3.0027397260273974,4.0027397260273974]
[]
[null,null,null,null,"PV discount factor - Water resources",null,"factor",{"$f":" SUM(J25:V25)","v":5},null,{"$f":" IF(J$22 < $F$20, 0, 1 / ( 1 + $F15) ^ J$23)","v":0},{"$f":" IF(K$22 < $F$20, 0, 1 / ( 1 + $F15) ^ K$23)","v":0},0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"PV discount factor - Water network",null,"factor",{"$f":" SUM(J26:V26)","v":5},null,{"$f":" IF(J$22 < $F$20, 0, 1 / ( 1 + $F16) ^ J$23)","v":0},0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"PV discount factor - Wastewater network",null,"factor",5,null,{"$f":" IF(J$22 < $F$20, 0, 1 / ( 1 + $F17) ^ J$23)","v":0},0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"PV discount factor - Residential revenue",null,"factor",5,null,{"$f":" IF(J$22 < $F$20, 0, 1 / ( 1 + $F18) ^ J$23)","v":0},0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" E$25","v":"PV discount factor - Water resources"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$26","v":"PV discount factor - Water network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$27","v":"PV discount factor - Wastewater network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Residential revenue"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Water resources",{"$f":" SUM(J30:V30)","v":5},"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Water network",{"$f":" SUM(J31:V31)","v":5},"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Wastewater network",5,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Residential revenue",5,"factor"]
[]
[]
["PROFILES"]
[]
[null,"Profile 0 - Apply in first year"]
[null,null,null,null,{"$f":" Inputs!E$113","v":"PV base date"},{"$f":" Inputs!F$113","v":"2021-03-31"},{"$f":" Inputs!G$113","v":"date"}]
[]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Time!F$25","v":"00:00:00"},{"$f":" Time!G$25","v":"date"},{"$f":" Time!H$25","v":"00:00:00"},{"$f":" Time!I$25","v":"00:00:00"},{"$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"},{"$f":" Time!V$25","v":"2025-03-31"}]
[]
[null,null,null,null,{"$f":" E$25","v":"PV discount factor - Water resources"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$26","v":"PV discount factor - Water network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$27","v":"PV discount factor - Wastewater network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Residential revenue"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,"PV discount factor at base date - Water resources",null,"factor",null,null,{"$f":" IF($F$44 = J$46, J48, 0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"PV discount factor at base date - Water network",null,"factor",null,null,{"$f":" IF($F$44 = J$46, J49, 0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"PV discount factor at base date - Wastewater network",null,"factor",null,null,{"$f":" IF($F$44 = J$46, J50, 0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"PV discount factor at base date - Residential retail",null,"factor",null,null,{"$f":" IF($F$44 = J$46, J51, 0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0]
[]
[null,null,null,null,{"$f":" Calc!E$105","v":"Water resources revenue adjustment"},{"$f":" Calc!F$105","v":0},{"$f":" Calc!G$105","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$113","v":"Water network + : revenue adjustment"},{"$f":" Calc!F$113","v":0},{"$f":" Calc!G$113","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$120","v":"Wastewater network + : revenue adjustment"},{"$f":" Calc!F$120","v":0},{"$f":" Calc!G$120","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$125","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$125","v":0},{"$f":" Calc!G$125","v":"£m"}]
[]
[null,null,null,null,{"$f":" E$53","v":"PV discount factor at base date - Water resources"},0,{"$f":" G$53","v":"factor"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$54","v":"PV discount factor at base date - Water network"},0,"factor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$55","v":"PV discount factor at base date - Wastewater network"},0,"factor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$56","v":"PV discount factor at base date - Residential retail"},0,"factor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[]
[null,null,null,null,"Water resources revenue adjustment applied in first year",null,"£m",{"$f":" SUM(J68:V68)","v":0},null,{"$f":" $F58 * J63","v":0},{"$f":" $F58 * K63","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment applied in first year",null,"£m",0,null,{"$f":" $F59 * J64","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment applied in first year",null,"£m",0,null,{"$f":" $F60 * J65","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment applied in first year",null,"£m",0,null,{"$f":" $F61 * J66","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Profile 1 - Constant annuity 2020-25"]
[null,null,null,null,{"$f":" Calc!E$105","v":"Water resources revenue adjustment"},{"$f":" Calc!F$105","v":0},{"$f":" Calc!G$105","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$113","v":"Water network + : revenue adjustment"},{"$f":" Calc!F$113","v":0},{"$f":" Calc!G$113","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$120","v":"Wastewater network + : revenue adjustment"},{"$f":" Calc!F$120","v":0},{"$f":" Calc!G$120","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$125","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$125","v":0},{"$f":" Calc!G$125","v":"£m"}]
[]
[null,null,null,null,{"$f":" E$35","v":"Equivalent Annual Cost (EAC) factor - Water resources"},5,"factor"]
[null,null,null,null,{"$f":" E$36","v":"Equivalent Annual Cost (EAC) factor - Water network"},5,"factor"]
[null,null,null,null,{"$f":" E$37","v":"Equivalent Annual Cost (EAC) factor - Wastewater network"},5,"factor"]
[null,null,null,null,{"$f":" E$38","v":"Equivalent Annual Cost (EAC) factor - Residential revenue"},5,"factor"]
[]
[null,null,null,null,{"$f":" Time!E$49","v":"Forecast period flag"},{"$f":" Time!F$49","v":0},{"$f":" Time!G$49","v":"flag"},{"$f":" Time!H$49","v":5},{"$f":" Time!I$49","v":0},{"$f":" Time!J$49","v":0},{"$f":" Time!K$49","v":0},{"$f":" Time!L$49","v":0},{"$f":" Time!M$49","v":0},{"$f":" Time!N$49","v":0},{"$f":" Time!O$49","v":0},{"$f":" Time!P$49","v":0},{"$f":" Time!Q$49","v":0},{"$f":" Time!R$49","v":1},{"$f":" Time!S$49","v":1},{"$f":" Time!T$49","v":1},{"$f":" Time!U$49","v":1},{"$f":" Time!V$49","v":1}]
[]
[null,null,null,null,"Water resources revenue adjustment - EAC factor adjusted",null,"£m",{"$f":" SUM(J86:V86)","v":0},null,{"$f":" ($F74 / $F79) * J$84","v":0},{"$f":" ($F74 / $F79) * K$84","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - EAC factor adjusted",null,"£m",{"$f":" SUM(J87:V87)","v":0},null,{"$f":" ($F75 / $F80) * J$84","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - EAC factor adjusted",null,"£m",{"$f":" SUM(J88:V88)","v":0},null,{"$f":" ($F76 / $F81) * J$84","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - EAC factor adjusted",null,"£m",{"$f":" SUM(J89:V89)","v":0},null,{"$f":" ($F77 / $F82) * J$84","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$86","v":"Water resources revenue adjustment - EAC factor adjusted"},0,{"$f":" G$86","v":"£m"},{"$f":" H$86","v":0},{"$f":" I$86","v":0},{"$f":" J$86","v":0},{"$f":" K$86","v":0},{"$f":" L$86","v":0},{"$f":" M$86","v":0},{"$f":" N$86","v":0},{"$f":" O$86","v":0},{"$f":" P$86","v":0},{"$f":" Q$86","v":0},{"$f":" R$86","v":0},{"$f":" S$86","v":0},{"$f":" T$86","v":0},{"$f":" U$86","v":0},{"$f":" V$86","v":0}]
[null,null,null,null,{"$f":" E$87","v":"Water network revenue adjustment - EAC factor adjusted"},0,{"$f":" G$87","v":"£m"},{"$f":" H$87","v":0},{"$f":" I$87","v":0},{"$f":" J$87","v":0},{"$f":" K$87","v":0},{"$f":" L$87","v":0},{"$f":" M$87","v":0},{"$f":" N$87","v":0},{"$f":" O$87","v":0},{"$f":" P$87","v":0},{"$f":" Q$87","v":0},{"$f":" R$87","v":0},{"$f":" S$87","v":0},{"$f":" T$87","v":0},{"$f":" U$87","v":0},{"$f":" V$87","v":0}]
[null,null,null,null,{"$f":" E$88","v":"Wastewater network revenue adjustment - EAC factor adjusted"},0,{"$f":" G$88","v":"£m"},{"$f":" H$88","v":0},{"$f":" I$88","v":0},{"$f":" J$88","v":0},{"$f":" K$88","v":0},{"$f":" L$88","v":0},{"$f":" M$88","v":0},{"$f":" N$88","v":0},{"$f":" O$88","v":0},{"$f":" P$88","v":0},{"$f":" Q$88","v":0},{"$f":" R$88","v":0},{"$f":" S$88","v":0},{"$f":" T$88","v":0},{"$f":" U$88","v":0},{"$f":" V$88","v":0}]
[null,null,null,null,{"$f":" E$89","v":"Residential retail revenue adjustment - EAC factor adjusted"},0,{"$f":" G$89","v":"£m"},{"$f":" H$89","v":0},{"$f":" I$89","v":0},{"$f":" J$89","v":0},{"$f":" K$89","v":0},{"$f":" L$89","v":0},{"$f":" M$89","v":0},{"$f":" N$89","v":0},{"$f":" O$89","v":0},{"$f":" P$89","v":0},{"$f":" Q$89","v":0},{"$f":" R$89","v":0},{"$f":" S$89","v":0},{"$f":" T$89","v":0},{"$f":" U$89","v":0},{"$f":" V$89","v":0}]
[]
[null,null,null,null,{"$f":" E$25","v":"PV discount factor - Water resources"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$26","v":"PV discount factor - Water network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$27","v":"PV discount factor - Wastewater network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Residential revenue"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,"Water resources revenue adjustment - Constant annuity 2015-20",null,"£m",{"$f":" SUM(J101:V101)","v":0},null,{"$f":" J91 * J96","v":0},{"$f":" K91 * K96","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - Constant annuity 2015-20",null,"£m",0,null,{"$f":" J92 * J97","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - Constant annuity 2015-20",null,"£m",0,null,{"$f":" J93 * J98","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - Constant annuity 2015-20",null,"£m",0,null,{"$f":" J94 * J99","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Profile 2 - Even allocation - NPV neutral"]
[null,null,null,null,{"$f":" Calc!E$105","v":"Water resources revenue adjustment"},{"$f":" Calc!F$105","v":0},{"$f":" Calc!G$105","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$113","v":"Water network + : revenue adjustment"},{"$f":" Calc!F$113","v":0},{"$f":" Calc!G$113","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$120","v":"Wastewater network + : revenue adjustment"},{"$f":" Calc!F$120","v":0},{"$f":" Calc!G$120","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$125","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$125","v":0},{"$f":" Calc!G$125","v":"£m"}]
[]
[null,null,null,null,{"$f":" Inputs!E$115","v":"Discount rate - Water resources"},{"$f":" Inputs!F$115","v":0},{"$f":" Inputs!G$115","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$116","v":"Discount rate - Water network"},{"$f":" Inputs!F$116","v":0},{"$f":" Inputs!G$116","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$117","v":"Discount rate - Wastewater network"},{"$f":" Inputs!F$117","v":0},{"$f":" Inputs!G$117","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$118","v":"Discount rate - Residential retail"},{"$f":" Inputs!F$118","v":0},{"$f":" Inputs!G$118","v":"%"}]
[]
[null,null,null,null,{"$f":" Inputs!E$120","v":"Number of years to profile over"},{"$f":" Inputs!F$120","v":0},{"$f":" Inputs!G$120","v":"#"}]
[]
[null,null,null,null,{"$f":" E$13","v":"Years from valuation date"},0,{"$f":" G$13","v":"years"},0,0,0,0,0,0,0,0,0,0,0,1,2,3.0027397260273974,4.0027397260273974]
[null,null,null,null,{"$f":" Time!E$49","v":"Forecast period flag"},{"$f":" Time!F$49","v":0},{"$f":" Time!G$49","v":"flag"},{"$f":" Time!H$49","v":5},{"$f":" Time!I$49","v":0},{"$f":" Time!J$49","v":0},{"$f":" Time!K$49","v":0},{"$f":" Time!L$49","v":0},{"$f":" Time!M$49","v":0},{"$f":" Time!N$49","v":0},{"$f":" Time!O$49","v":0},{"$f":" Time!P$49","v":0},{"$f":" Time!Q$49","v":0},{"$f":" Time!R$49","v":1},{"$f":" Time!S$49","v":1},{"$f":" Time!T$49","v":1},{"$f":" Time!U$49","v":1},{"$f":" Time!V$49","v":1}]
[]
[null,null,null,null,"Water resources revenue adjustment - NPV adjusted",null,"£m",{"$f":" SUM(J122:V122)","v":{"$error":"#DIV/0!"}},null,{"$f":" IF(J$119 + 1 <= $F$117 + 1, $F107 / $F$117, 0) * J$120 * (1 + $F112) ^ J$119","v":{"$error":"#DIV/0!"}},{"$f":" IF(K$119 + 1 <= $F$117 + 1, $F107 / $F$117, 0) * K$120 * (1 + $F112) ^ K$119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - NPV adjusted",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF(J$119 + 1 <= $F$117 + 1, $F108 / $F$117, 0) * J$120 * (1 + $F113) ^ J$119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - NPV adjusted",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF(J$119 + 1 <= $F$117 + 1, $F109 / $F$117, 0) * J$120 * (1 + $F114) ^ J$119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - NPV adjusted",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF(J$119 + 1 <= $F$117 + 1, $F110 / $F$117, 0) * J$120 * (1 + $F115) ^ J$119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[]
[null,null,null,null,{"$f":" E$122","v":"Water resources revenue adjustment - NPV adjusted"},0,{"$f":" G$122","v":"£m"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$123","v":"Water network revenue adjustment - NPV adjusted"},0,{"$f":" G$123","v":"£m"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$124","v":"Wastewater network revenue adjustment - NPV adjusted"},0,{"$f":" G$124","v":"£m"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$125","v":"Residential retail revenue adjustment - NPV adjusted"},0,{"$f":" G$125","v":"£m"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[]
[null,null,null,null,{"$f":" E$25","v":"PV discount factor - Water resources"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$26","v":"PV discount factor - Water network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$27","v":"PV discount factor - Wastewater network"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Residential revenue"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,"Water resources revenue adjustment - Even allocation - NPV neutral",null,"£m",{"$f":" SUM(J137:V137)","v":{"$error":"#DIV/0!"}},null,{"$f":" J127 * J132","v":{"$error":"#DIV/0!"}},{"$f":" K127 * K132","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - Even allocation - NPV neutral",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" J128 * J133","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - Even allocation - NPV neutral",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" J129 * J134","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - Even allocation - NPV neutral",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" J130 * J135","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[]
[]
["PROFILES SELECTION"]
[]
[null,null,null,null,{"$f":" Inputs!E$124","v":"Water resources revenue adjustment selector"},{"$f":" Inputs!F$124","v":2},{"$f":" Inputs!G$124","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$125","v":"Water network revenue adjustment selector"},{"$f":" Inputs!F$125","v":2},{"$f":" Inputs!G$125","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$126","v":"Wastewater network revenue adjustment selector"},{"$f":" Inputs!F$126","v":2},{"$f":" Inputs!G$126","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$127","v":"Residential retail revenue adjustment selector"},{"$f":" Inputs!F$127","v":2},{"$f":" Inputs!G$127","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[]
[null,null,null,null,{"$f":" E$68","v":"Water resources revenue adjustment applied in first year"},0,{"$f":" G$68","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$69","v":"Water network revenue adjustment applied in first year"},0,{"$f":" G$69","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$70","v":"Wastewater network revenue adjustment applied in first year"},0,{"$f":" G$70","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$71","v":"Residential retail revenue adjustment applied in first year"},0,{"$f":" G$71","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$91","v":"Water resources revenue adjustment - EAC factor adjusted"},{"$f":" F$91","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$92","v":"Water network revenue adjustment - EAC factor adjusted"},{"$f":" F$92","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$93","v":"Wastewater network revenue adjustment - EAC factor adjusted"},{"$f":" F$93","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$94","v":"Residential retail revenue adjustment - EAC factor adjusted"},{"$f":" F$94","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$127","v":"Water resources revenue adjustment - NPV adjusted"},{"$f":" F$127","v":0},"£m",{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$128","v":"Water network revenue adjustment - NPV adjusted"},{"$f":" F$128","v":0},"£m",{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$129","v":"Wastewater network revenue adjustment - NPV adjusted"},{"$f":" F$129","v":0},"£m",{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,{"$f":" E$130","v":"Residential retail revenue adjustment - NPV adjusted"},{"$f":" F$130","v":0},"£m",{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0,0]
[]
[null,null,null,null,"Water resources revenue adjustment active",null,"£m",{"$f":" SUM(J165:V165)","v":{"$error":"#DIV/0!"}},null,{"$f":" IF($F145 = 0, J150, IF($F145 = 1, J155, J160))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":" IF($F145 = 0, Q150, IF($F145 = 1, Q155, Q160))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Water network revenue adjustment active",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF($F146 = 0, J151, IF($F146 = 1, J156, J161))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":" IF($F146 = 0, Q151, IF($F146 = 1, Q156, Q161))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment active",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF($F147 = 0, J152, IF($F147 = 1, J157, J162))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":" IF($F147 = 0, Q152, IF($F147 = 1, Q157, Q162))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment active",null,"£m",{"$error":"#DIV/0!"},null,{"$f":" IF($F148 = 0, J153, IF($F148 = 1, J158, J163))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":" IF($F148 = 0, Q153, IF($F148 = 1, Q158, Q163))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},0,0,0,0]

{"sheet":"Summary_Output","index":7,"n_rows":66,"n_cols":22,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Summary_Output"}]
[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"},{"$f":" Time!V$25","v":"2025-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"},{"$f":" Time!V$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":" Time!V$103","v":2025}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit",null,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},{"$f":" Time!V$10","v":13}]
[]
["WATER SERVICES INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Calc!E$11","v":"Water trading at 2020 FYE price base"},{"$f":" Calc!F$11","v":0},{"$f":" Calc!G$11","v":"£m"}]
[]
[null,"Water network +"]
[null,null,null,null,{"$f":" Calc!E$20","v":"Water trading - Water network at 2020 FYE price base"},{"$f":" Calc!F$20","v":0},{"$f":" Calc!G$20","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$21","v":"WRFIM - Water network at 2020 FYE price base"},{"$f":" Calc!F$21","v":0},{"$f":" Calc!G$21","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$29","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2020 FYE price base"},{"$f":" Calc!F$29","v":0},{"$f":" Calc!G$29","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$30","v":"ODI - Water network at 2020 FYE price base"},{"$f":" Calc!F$30","v":0},{"$f":" Calc!G$30","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$31","v":"Totex - Water network at 2020 FYE price base"},{"$f":" Calc!F$31","v":0},{"$f":" Calc!G$31","v":"£m"}]
[]
[null,"Water resources"]
[null,null,null,null,{"$f":" Calc!E$36","v":"Water trading - Water resources at 2020 FYE price base"},{"$f":" Calc!F$36","v":0},{"$f":" Calc!G$36","v":"£m"}]
[]
[]
["WASTEWATER NETWORK + : INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Calc!E$47","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2020 FYE price base"},{"$f":" Calc!F$47","v":0},{"$f":" Calc!G$47","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$48","v":"ODI - Wastewater network at 2020 FYE price base"},{"$f":" Calc!F$48","v":0},{"$f":" Calc!G$48","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$49","v":"Totex - Wastewater network at 2020 FYE price base"},{"$f":" Calc!F$49","v":0},{"$f":" Calc!G$49","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$53","v":"WRFIM - Wastewater network at 2020 FYE price base"},{"$f":" Calc!F$53","v":0},{"$f":" Calc!G$53","v":"£m"}]
[]
[]
["RESIDENTIAL RETAIL INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Calc!E$64","v":"Residential retail revenue at 2020 FYE price base"},{"$f":" Calc!F$64","v":0},{"$f":" Calc!G$64","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$65","v":"Residential retail - SIM at 2020 FYE price base"},{"$f":" Calc!F$65","v":0},{"$f":" Calc!G$65","v":"£m"}]
[]
[]
["PR14 REVENUE RECONCILIATION ADJUSTMENTS EXPRESSED IN 2017/18 FYA CPIH DEFLATED PRICE BASE"]
[]
[null,null,null,null,{"$f":" Calc!E$86","v":"Water trading at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$86","v":0},{"$f":" Calc!G$86","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$87","v":"Water trading - Water network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$87","v":0},{"$f":" Calc!G$87","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$88","v":"WRFIM at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$88","v":0},{"$f":" Calc!G$88","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$89","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Water network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$89","v":0},{"$f":" Calc!G$89","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$90","v":"ODI - Water network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$90","v":0},{"$f":" Calc!G$90","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$91","v":"Totex - Water network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$91","v":0},{"$f":" Calc!G$91","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$92","v":"Water trading - Water resources at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$92","v":0},{"$f":" Calc!G$92","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$93","v":"Final 2010-15 reconciliation - PR09 Legacy blind year adjustments - Wastewater network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$93","v":0},{"$f":" Calc!G$93","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$94","v":"ODI - Wastewater network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$94","v":0},{"$f":" Calc!G$94","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$95","v":"Totex - Wastewater network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$95","v":0},{"$f":" Calc!G$95","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$96","v":"WRFIM - Wastewater network at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$96","v":0},{"$f":" Calc!G$96","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$97","v":"Residential retail revenue at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$97","v":0},{"$f":" Calc!G$97","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$98","v":"Residential retail - SIM at 2017/18 FYA CPIH deflated price base"},{"$f":" Calc!F$98","v":0},{"$f":" Calc!G$98","v":"£m"}]
[]
[]
["SUBTOTALS AS PER PRICE CONTROL FOR REVENUE ADJUSTMENTS"]
[]
[null,null,null,null,{"$f":" Calc!E$105","v":"Water resources revenue adjustment"},{"$f":" Calc!F$105","v":0},{"$f":" Calc!G$105","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$113","v":"Water network + : revenue adjustment"},{"$f":" Calc!F$113","v":0},{"$f":" Calc!G$113","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$120","v":"Wastewater network + : revenue adjustment"},{"$f":" Calc!F$120","v":0},{"$f":" Calc!G$120","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$125","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$125","v":0},{"$f":" Calc!G$125","v":"£m"}]
[]
[]
["PROFILES SELECTED"]
[]
[null,null,null,null,{"$f":" Profiling!E$165","v":"Water resources revenue adjustment active"},{"$f":" Profiling!F$165","v":0},{"$f":" Profiling!G$165","v":"£m"},{"$f":" Profiling!H$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!I$165","v":0},{"$f":" Profiling!J$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!K$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!L$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!M$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!N$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!O$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!P$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!Q$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!R$165","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!S$165","v":0},{"$f":" Profiling!T$165","v":0},{"$f":" Profiling!U$165","v":0},{"$f":" Profiling!V$165","v":0}]
[null,null,null,null,{"$f":" Profiling!E$166","v":"Water network revenue adjustment active"},{"$f":" Profiling!F$166","v":0},{"$f":" Profiling!G$166","v":"£m"},{"$f":" Profiling!H$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!I$166","v":0},{"$f":" Profiling!J$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!K$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!L$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!M$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!N$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!O$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!P$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!Q$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!R$166","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!S$166","v":0},{"$f":" Profiling!T$166","v":0},{"$f":" Profiling!U$166","v":0},{"$f":" Profiling!V$166","v":0}]
[null,null,null,null,{"$f":" Profiling!E$167","v":"Wastewater network revenue adjustment active"},{"$f":" Profiling!F$167","v":0},{"$f":" Profiling!G$167","v":"£m"},{"$f":" Profiling!H$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!I$167","v":0},{"$f":" Profiling!J$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!K$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!L$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!M$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!N$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!O$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!P$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!Q$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!R$167","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!S$167","v":0},{"$f":" Profiling!T$167","v":0},{"$f":" Profiling!U$167","v":0},{"$f":" Profiling!V$167","v":0}]
[null,null,null,null,{"$f":" Profiling!E$168","v":"Residential retail revenue adjustment active"},{"$f":" Profiling!F$168","v":0},{"$f":" Profiling!G$168","v":"£m"},{"$f":" Profiling!H$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!I$168","v":0},{"$f":" Profiling!J$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!K$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!L$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!M$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!N$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!O$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!P$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!Q$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!R$168","v":{"$error":"#DIV/0!"}},{"$f":" Profiling!S$168","v":0},{"$f":" Profiling!T$168","v":0},{"$f":" Profiling!U$168","v":0},{"$f":" Profiling!V$168","v":0}]