{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Change Log","Map & Key","Inputs","Time","Indexation","Calc","Profiling","Summary_Output"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":6,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"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:","PR19 Revenue adjustments feeder model"]
[null,null,"Version number:","01j - June 2018 update"]
[null,null,"Filename:",{"$f":" \"PR19 Revenue adjustments feeder model \" & D4 & \".xlsm\"","v":"PR19 Revenue adjustments feeder model 01j - June 2018 update.xlsm"}]
[null,null,"Date:","2018-06-20"]
[null,null,"Author:","Ofwat and F1F9 UK Ltd"]
[null,null,"Author contact information:","PR19@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 PR19 financial model in line"]
[null,null,null,"with Delivering Water 2020: PR19 methodology, chapter 12 (accounting for past delivery)."]
[]
[null,null,"Known limitations:","The model has been subject to internal Ofwat quality assurance."]
[]
[null,null,"Feedback:","We would welcome feedback on the PR19 revenue adjustments feeder model. Please send any feedback to the following email address"]
[null,null,null,"PR19@ofwat.gsi.gov.uk"]
[]
[]
["End of sheet"]

{"sheet":"Change Log","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Change log"]
[]
[null,"#","Issue","Change","Sheet","Row"]
[]
["2017-12-01",1,"Company noted that the Ofwat feeder model incorrectly deflates prices from 2020 year end prices to 2017-18 financial year average prices by referencing the RPI March index value in the numerator.","Corrected calculation of the deflation factor to reference CPIH March 2020 index value.","Indexation",109]
["2017-12-01",2,"Companies noted differences in item labels between the Ofwat feeder model and the business plan tables ","Item labels have been aligned with the business plan tables","Calc\nProfiling\nSummary_Output"]
["2018-06-01",3,"In response to a query a new business plan table has been created. The Ofwat feeder model has been updated to reflect the additional table Dmmy10.","Include the Dummy10 revenue adjustment.","Inputs\nCalc\nSummary_Output"]
["2018-06-01",4,"Change email address","Changed from water2020 mailbox to PR19 mailbox","Cover"]

{"sheet":"Map & Key","index":2,"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":3,"n_rows":165,"n_cols":22,"rows_kept":165,"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:A165,\"< 0\") + COUNTIF(A6:A165,\">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,{"$f":"[1]Inputs!P35","v":105.75420000000001},{"$f":"[1]Inputs!Q35","v":107.9750382},{"$f":"[1]Inputs!R35","v":110.21552024265},{"$f":"[1]Inputs!S35","v":112.44738452756367},{"$f":"[1]Inputs!T35","v":114.69633221811495},{"$f":"[1]Inputs!U35","v":116.99025886247725},{"$f":"[1]Inputs!V35","v":119.33006403972679}]
[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,{"$f":"[1]Inputs!P36","v":106.06162500000001},{"$f":"[1]Inputs!Q36","v":108.28891912499999},{"$f":"[1]Inputs!R36","v":110.53591419684375},{"$f":"[1]Inputs!S36","v":112.77426645932985},{"$f":"[1]Inputs!T36","v":115.02975178851645},{"$f":"[1]Inputs!U36","v":117.33034682428678},{"$f":"[1]Inputs!V36","v":119.67695376077252}]
[null,null,null,null,"Consumer Price Index for June",null,"index",null,null,95.6,98,99.8,100.1,101,103.5,{"$f":"[1]Inputs!P37","v":106.06162500000001},{"$f":"[1]Inputs!Q37","v":108.28891912499999},{"$f":"[1]Inputs!R37","v":110.53591419684375},{"$f":"[1]Inputs!S37","v":112.77426645932985},{"$f":"[1]Inputs!T37","v":115.02975178851645},{"$f":"[1]Inputs!U37","v":117.33034682428678},{"$f":"[1]Inputs!V37","v":119.67695376077252}]
[null,null,null,null,"Consumer Price Index for July",null,"index",null,null,95.7,98,99.6,100,100.9,103.5,{"$f":"[1]Inputs!P38","v":106.06162500000001},{"$f":"[1]Inputs!Q38","v":108.28891912499999},{"$f":"[1]Inputs!R38","v":110.53591419684375},{"$f":"[1]Inputs!S38","v":112.77426645932985},{"$f":"[1]Inputs!T38","v":115.02975178851645},{"$f":"[1]Inputs!U38","v":117.33034682428678},{"$f":"[1]Inputs!V38","v":119.67695376077252}]
[null,null,null,null,"Consumer Price Index for August",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,104,{"$f":"[1]Inputs!P39","v":106.57400000000001},{"$f":"[1]Inputs!Q39","v":108.812054},{"$f":"[1]Inputs!R39","v":111.06990412050001},{"$f":"[1]Inputs!S39","v":113.31906967894015},{"$f":"[1]Inputs!T39","v":115.58545107251896},{"$f":"[1]Inputs!U39","v":117.89716009396935},{"$f":"[1]Inputs!V39","v":120.25510329584874}]
[null,null,null,null,"Consumer Price Index for September",null,"index",null,null,96.4,98.7,100,100.2,101.5,104.3,{"$f":"[1]Inputs!P40","v":106.88142500000001},{"$f":"[1]Inputs!Q40","v":109.125934925},{"$f":"[1]Inputs!R40","v":111.39029807469375},{"$f":"[1]Inputs!S40","v":113.64595161070631},{"$f":"[1]Inputs!T40","v":115.91887064292044},{"$f":"[1]Inputs!U40","v":118.23724805577885},{"$f":"[1]Inputs!V40","v":120.60199301689443}]
[null,null,null,null,"Consumer Price Index for October",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,104.4,{"$f":"[1]Inputs!P41","v":106.98390000000001},{"$f":"[1]Inputs!Q41","v":109.2305619},{"$f":"[1]Inputs!R41","v":111.497096059425},{"$f":"[1]Inputs!S41","v":113.75491225462837},{"$f":"[1]Inputs!T41","v":116.03001049972093},{"$f":"[1]Inputs!U41","v":118.35061070971535},{"$f":"[1]Inputs!V41","v":120.71762292390966}]
[null,null,null,null,"Consumer Price Index for November",null,"index",null,null,97,98.8,99.9,100.3,101.8,104.7,{"$f":"[1]Inputs!P42","v":107.29132500000001},{"$f":"[1]Inputs!Q42","v":109.544442825},{"$f":"[1]Inputs!R42","v":111.81749001361877},{"$f":"[1]Inputs!S42","v":114.08179418639456},{"$f":"[1]Inputs!T42","v":116.36343007012245},{"$f":"[1]Inputs!U42","v":118.6906986715249},{"$f":"[1]Inputs!V42","v":121.0645126449554}]
[null,null,null,null,"Consumer Price Index for December",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,105,{"$f":"[1]Inputs!P43","v":107.59875000000001},{"$f":"[1]Inputs!Q43","v":109.85832375},{"$f":"[1]Inputs!R43","v":112.1378839678125},{"$f":"[1]Inputs!S43","v":114.40867611816071},{"$f":"[1]Inputs!T43","v":116.69684964052394},{"$f":"[1]Inputs!U43","v":119.03078663333442},{"$f":"[1]Inputs!V43","v":121.4114023660011}]
[null,null,null,null,"Consumer Price Index for January",null,"index",null,null,97,98.7,99.2,99.9,101.8,104.5,{"$f":"[1]Inputs!P44","v":107.086375},{"$f":"[1]Inputs!Q44","v":109.335188875},{"$f":"[1]Inputs!R44","v":111.60389404415625},{"$f":"[1]Inputs!S44","v":113.86387289855043},{"$f":"[1]Inputs!T44","v":116.14115035652144},{"$f":"[1]Inputs!U44","v":118.46397336365186},{"$f":"[1]Inputs!V44","v":120.83325283092491}]
[null,null,null,null,"Consumer Price Index for February",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,104.9,{"$f":"[1]Inputs!P45","v":107.49627500000001},{"$f":"[1]Inputs!Q45","v":109.75369677500001},{"$f":"[1]Inputs!R45","v":112.03108598308127},{"$f":"[1]Inputs!S45","v":114.29971547423868},{"$f":"[1]Inputs!T45","v":116.58570978372346},{"$f":"[1]Inputs!U45","v":118.91742397939792},{"$f":"[1]Inputs!V45","v":121.29577245898588}]
[null,null,null,null,"Consumer Price Index for March",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,105.1,{"$f":"[1]Inputs!P46","v":107.70122499999999},{"$f":"[1]Inputs!Q46","v":109.96295072499998},{"$f":"[1]Inputs!R46","v":112.24468195254374},{"$f":"[1]Inputs!S46","v":114.51763676208276},{"$f":"[1]Inputs!T46","v":116.80798949732441},{"$f":"[1]Inputs!U46","v":119.14414928727091},{"$f":"[1]Inputs!V46","v":121.52703227301633}]
[]
[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,{"$f":"[1]Inputs!P52","v":279.73275000000001},{"$f":"[1]Inputs!Q52","v":288.12473249999999},{"$f":"[1]Inputs!R52","v":296.84050565812504},{"$f":"[1]Inputs!S52","v":306.04256133352692},{"$f":"[1]Inputs!T52","v":315.22383817353273},{"$f":"[1]Inputs!U52","v":324.6805533187387},{"$f":"[1]Inputs!V52","v":334.4209699183009}]
[null,null,null,null,"Retail Price Index for May",null,"index",null,null,242.4,250,255.9,258.5,262.10000000000002,271.7,{"$f":"[1]Inputs!P53","v":280.86987499999998},{"$f":"[1]Inputs!Q53","v":289.29597124999998},{"$f":"[1]Inputs!R53","v":298.04717438031253},{"$f":"[1]Inputs!S53","v":307.28663678610218},{"$f":"[1]Inputs!T53","v":316.50523588968525},{"$f":"[1]Inputs!U53","v":326.00039296637584},{"$f":"[1]Inputs!V53","v":335.7804047553671}]
[null,null,null,null,"Retail Price Index for June",null,"index",null,null,241.8,249.7,256.3,258.89999999999998,263.10000000000002,272.3,{"$f":"[1]Inputs!P54","v":281.49012499999998},{"$f":"[1]Inputs!Q54","v":289.93482875000001},{"$f":"[1]Inputs!R54","v":298.70535731968755},{"$f":"[1]Inputs!S54","v":307.96522339659782},{"$f":"[1]Inputs!T54","v":317.20418009849578},{"$f":"[1]Inputs!U54","v":326.72030550145064},{"$f":"[1]Inputs!V54","v":336.52191466649418}]
[null,null,null,null,"Retail Price Index for July",null,"index",null,null,242.1,249.7,256,258.60000000000002,263.39999999999998,272.89999999999998,{"$f":"[1]Inputs!P55","v":282.11037499999998},{"$f":"[1]Inputs!Q55","v":290.57368624999998},{"$f":"[1]Inputs!R55","v":299.36354025906252},{"$f":"[1]Inputs!S55","v":308.64381000709341},{"$f":"[1]Inputs!T55","v":317.9031243073062},{"$f":"[1]Inputs!U55","v":327.44021803652538},{"$f":"[1]Inputs!V55","v":337.26342457762115}]
[null,null,null,null,"Retail Price Index for August",null,"index",null,null,243,251,257,259.8,264.39999999999998,274.7,{"$f":"[1]Inputs!P56","v":283.97112499999997},{"$f":"[1]Inputs!Q56","v":292.49025874999995},{"$f":"[1]Inputs!R56","v":301.33808907718748},{"$f":"[1]Inputs!S56","v":310.67956983858028},{"$f":"[1]Inputs!T56","v":319.99995693373768},{"$f":"[1]Inputs!U56","v":329.59995564174983},{"$f":"[1]Inputs!V56","v":339.48795431100234}]
[null,null,null,null,"Retail Price Index for September",null,"index",null,null,244.2,251.9,257.60000000000002,259.60000000000002,264.89999999999998,275.10000000000002,{"$f":"[1]Inputs!P57","v":284.38462500000003},{"$f":"[1]Inputs!Q57","v":292.91616375000001},{"$f":"[1]Inputs!R57","v":301.77687770343755},{"$f":"[1]Inputs!S57","v":311.1319609122441},{"$f":"[1]Inputs!T57","v":320.46591973961142},{"$f":"[1]Inputs!U57","v":330.07989733179977},{"$f":"[1]Inputs!V57","v":339.98229425175379}]
[null,null,null,null,"Retail Price Index for October",null,"index",null,null,245.6,251.9,257.7,259.5,264.8,275.3,{"$f":"[1]Inputs!P58","v":284.59137499999997},{"$f":"[1]Inputs!Q58","v":293.12911624999998},{"$f":"[1]Inputs!R58","v":301.9962720165625},{"$f":"[1]Inputs!S58","v":311.35815644907592},{"$f":"[1]Inputs!T58","v":320.69890114254821},{"$f":"[1]Inputs!U58","v":330.31986817682468},{"$f":"[1]Inputs!V58","v":340.22946422212942}]
[null,null,null,null,"Retail Price Index for November",null,"index",null,null,245.6,252.1,257.10000000000002,259.8,265.5,275.8,{"$f":"[1]Inputs!P59","v":285.10825},{"$f":"[1]Inputs!Q59","v":293.6614975},{"$f":"[1]Inputs!R59","v":302.54475779937502},{"$f":"[1]Inputs!S59","v":311.92364529115559},{"$f":"[1]Inputs!T59","v":321.28135464989026},{"$f":"[1]Inputs!U59","v":330.91979528938697},{"$f":"[1]Inputs!V59","v":340.8473891480686}]
[null,null,null,null,"Retail Price Index for December",null,"index",null,null,246.8,253.4,257.5,260.60000000000002,267.10000000000002,278.10000000000002,{"$f":"[1]Inputs!P60","v":287.48587500000002},{"$f":"[1]Inputs!Q60","v":296.11045125000004},{"$f":"[1]Inputs!R60","v":305.06779240031256},{"$f":"[1]Inputs!S60","v":314.5248939647222},{"$f":"[1]Inputs!T60","v":323.96064078366385},{"$f":"[1]Inputs!U60","v":333.67946000717376},{"$f":"[1]Inputs!V60","v":343.68984380738897}]
[null,null,null,null,"Retail Price Index for January",null,"index",null,null,245.8,252.6,255.4,258.8,265.5,276,{"$f":"[1]Inputs!P61","v":285.315},{"$f":"[1]Inputs!Q61","v":293.87445000000002},{"$f":"[1]Inputs!R61","v":302.76415211250008},{"$f":"[1]Inputs!S61","v":312.14984082798759},{"$f":"[1]Inputs!T61","v":321.51433605282722},{"$f":"[1]Inputs!U61","v":331.15976613441205},{"$f":"[1]Inputs!V61","v":341.09455911844441}]
[null,null,null,null,"Retail Price Index for February",null,"index",null,null,247.6,254.2,256.7,260,268.39999999999998,278.10000000000002,{"$f":"[1]Inputs!P62","v":287.48587500000002},{"$f":"[1]Inputs!Q62","v":296.11045125000004},{"$f":"[1]Inputs!R62","v":305.06779240031256},{"$f":"[1]Inputs!S62","v":314.5248939647222},{"$f":"[1]Inputs!T62","v":323.96064078366385},{"$f":"[1]Inputs!U62","v":333.67946000717376},{"$f":"[1]Inputs!V62","v":343.68984380738897}]
[null,null,null,null,"Retail Price Index for March",null,"index",null,null,248.7,254.8,257.10000000000002,261.10000000000002,269.3,278.3,{"$f":"[1]Inputs!P63","v":287.69262500000002},{"$f":"[1]Inputs!Q63","v":296.32340375000001},{"$f":"[1]Inputs!R63","v":305.28718671343756},{"$f":"[1]Inputs!S63","v":314.75108950155408},{"$f":"[1]Inputs!T63","v":324.19362218660069},{"$f":"[1]Inputs!U63","v":333.91943085219873},{"$f":"[1]Inputs!V63","v":343.93701377776472}]
[]
[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,"Water resources"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water resources",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water resources",0,"£m","2012/13 FYA"]
[null,null,null,null,"Total value of export incentive to be paid to water resources at PR19",0,"£m","2017/18 FYA"]
[null,null,null,null,"Total value of import incentive - water resources",0,"£m","2017/18 FYA"]
[]
[null,null,null,"Water network plus"]
[null,null,null,null,"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Water network plus",{"$f":"[2]App25!$M$7","v":-5.4571112234032597E-2},"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water network plus",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water network plus",{"$f":"[2]App27!$M$36","v":2.920535299999949},"£m","2012/13 FYA"]
[null,null,null,null,"Water: revenue adjustment from totex menu model",{"$f":"'[3]Totex menu adjustments'!$P$11","v":-0.31513026964971541},"£m","2012/13 FYA"]
[null,null,null,null,"Total value of export incentive to be paid to water network plus at PR19",0,"£m","2017/18 FYA"]
[null,null,null,null,"Total value of import incentive - water network plus",0,"£m","2017/18 FYA"]
[null,null,null,null,"WRFIM total reward / (penalty) at end of AMP6 ~ Water",{"$f":"'[4]WFRIM adjustments'!$P$10","v":-1.9120466858445233},"£m","November 2018/2019"]
[]
[null,"Wastewater services"]
[]
[null,null,null,"Bioresources"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Bioresources",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Bioresources",0,"£m","2012/13 FYA"]
[]
[null,null,null,"Wastewater network plus"]
[null,null,null,null,"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Wastewater network plus",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Wastewater network plus",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Wastewater network plus",0,"£m","2012/13 FYA"]
[null,null,null,null,"Wastewater: revenue adjustment from totex menu model",0,"£m","2012/13 FYA"]
[null,null,null,null,"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater",0,"£m","November 2018/2019"]
[]
[null,null,null,"Dummy control"]
[null,null,null,null,"Dummy: revenue adjustment from totex menu model",0,"£m","2012/13 FYA"]
[]
[null,"Residential retail"]
[]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Residential retail",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Residential retail",0,"£m","2012/13 FYA"]
[null,null,null,null,"Residential retail revenue adjustment at end of AMP6",{"$f":"[5]Calcs!$P$94","v":1.0572026731671273},"£m","2019/20 FYE"]
[null,null,null,null,"SIM forecast revenue adjustment",{"$f":"'[6]SSW PR 19 assumptions'!$L$49","v":2.3875857721170477},"£m","2017/18 FYA"]
[]
[null,"Business retail",null,null,null,{"$f":"[5]Calcs!$P$94","v":1.0572026731671273}]
[]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Business retail",0,"£m","2012/13 FYA"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Business retail",0,"£m","2012/13 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",3.3000000000000002E-2,"%"]
[null,null,null,null,"Discount rate - Water network plus",3.3000000000000002E-2,"%"]
[null,null,null,null,"Discount rate - Bioresources",0,"%"]
[null,null,null,null,"Discount rate - Wastewater network plus",0,"%"]
[null,null,null,null,"Discount rate - Dummy control",0,"%"]
[null,null,null,null,"Discount rate - Residential retail",3.3000000000000002E-2,"%"]
[null,null,null,null,"Discount rate - Business retail",0,"%"]
[]
[null,null,null,null,"Number of years to profile over",5,"#"]
[]
[null,"Profile selector"]
[]
[null,null,null,null,"Water resources revenue adjustment selector",0,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Water network plus revenue adjustment selector",2,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Bioesources revenue adjustment selector",0,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Wastewater network plus revenue adjustment selector",0,"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"]
[null,null,null,null,"Dummy control revenue adjustment selector",0,"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"]
[null,null,null,null,"Business retail revenue adjustment selector",0,"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":4,"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$158","v":"Months per model period"},{"$f":" Inputs!F$158","v":12},{"$f":" Inputs!G$158","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$158","v":"Months per model period"},{"$f":" Inputs!F$158","v":12},{"$f":" Inputs!G$158","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":5,"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":105.75420000000001},{"$f":" Inputs!Q$35","v":107.9750382},{"$f":" Inputs!R$35","v":110.21552024265},{"$f":" Inputs!S$35","v":112.44738452756367},{"$f":" Inputs!T$35","v":114.69633221811495},{"$f":" Inputs!U$35","v":116.99025886247725},{"$f":" Inputs!V$35","v":119.33006403972679}]
[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":106.06162500000001},{"$f":" Inputs!Q$36","v":108.28891912499999},{"$f":" Inputs!R$36","v":110.53591419684375},{"$f":" Inputs!S$36","v":112.77426645932985},{"$f":" Inputs!T$36","v":115.02975178851645},{"$f":" Inputs!U$36","v":117.33034682428678},{"$f":" Inputs!V$36","v":119.67695376077252}]
[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":103.5},{"$f":" Inputs!P$37","v":106.06162500000001},{"$f":" Inputs!Q$37","v":108.28891912499999},{"$f":" Inputs!R$37","v":110.53591419684375},{"$f":" Inputs!S$37","v":112.77426645932985},{"$f":" Inputs!T$37","v":115.02975178851645},{"$f":" Inputs!U$37","v":117.33034682428678},{"$f":" Inputs!V$37","v":119.67695376077252}]
[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":103.5},{"$f":" Inputs!P$38","v":106.06162500000001},{"$f":" Inputs!Q$38","v":108.28891912499999},{"$f":" Inputs!R$38","v":110.53591419684375},{"$f":" Inputs!S$38","v":112.77426645932985},{"$f":" Inputs!T$38","v":115.02975178851645},{"$f":" Inputs!U$38","v":117.33034682428678},{"$f":" Inputs!V$38","v":119.67695376077252}]
[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":104},{"$f":" Inputs!P$39","v":106.57400000000001},{"$f":" Inputs!Q$39","v":108.812054},{"$f":" Inputs!R$39","v":111.06990412050001},{"$f":" Inputs!S$39","v":113.31906967894015},{"$f":" Inputs!T$39","v":115.58545107251896},{"$f":" Inputs!U$39","v":117.89716009396935},{"$f":" Inputs!V$39","v":120.25510329584874}]
[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":104.3},{"$f":" Inputs!P$40","v":106.88142500000001},{"$f":" Inputs!Q$40","v":109.125934925},{"$f":" Inputs!R$40","v":111.39029807469375},{"$f":" Inputs!S$40","v":113.64595161070631},{"$f":" Inputs!T$40","v":115.91887064292044},{"$f":" Inputs!U$40","v":118.23724805577885},{"$f":" Inputs!V$40","v":120.60199301689443}]
[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":104.4},{"$f":" Inputs!P$41","v":106.98390000000001},{"$f":" Inputs!Q$41","v":109.2305619},{"$f":" Inputs!R$41","v":111.497096059425},{"$f":" Inputs!S$41","v":113.75491225462837},{"$f":" Inputs!T$41","v":116.03001049972093},{"$f":" Inputs!U$41","v":118.35061070971535},{"$f":" Inputs!V$41","v":120.71762292390966}]
[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":104.7},{"$f":" Inputs!P$42","v":107.29132500000001},{"$f":" Inputs!Q$42","v":109.544442825},{"$f":" Inputs!R$42","v":111.81749001361877},{"$f":" Inputs!S$42","v":114.08179418639456},{"$f":" Inputs!T$42","v":116.36343007012245},{"$f":" Inputs!U$42","v":118.6906986715249},{"$f":" Inputs!V$42","v":121.0645126449554}]
[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":105},{"$f":" Inputs!P$43","v":107.59875000000001},{"$f":" Inputs!Q$43","v":109.85832375},{"$f":" Inputs!R$43","v":112.1378839678125},{"$f":" Inputs!S$43","v":114.40867611816071},{"$f":" Inputs!T$43","v":116.69684964052394},{"$f":" Inputs!U$43","v":119.03078663333442},{"$f":" Inputs!V$43","v":121.4114023660011}]
[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":104.5},{"$f":" Inputs!P$44","v":107.086375},{"$f":" Inputs!Q$44","v":109.335188875},{"$f":" Inputs!R$44","v":111.60389404415625},{"$f":" Inputs!S$44","v":113.86387289855043},{"$f":" Inputs!T$44","v":116.14115035652144},{"$f":" Inputs!U$44","v":118.46397336365186},{"$f":" Inputs!V$44","v":120.83325283092491}]
[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":104.9},{"$f":" Inputs!P$45","v":107.49627500000001},{"$f":" Inputs!Q$45","v":109.75369677500001},{"$f":" Inputs!R$45","v":112.03108598308127},{"$f":" Inputs!S$45","v":114.29971547423868},{"$f":" Inputs!T$45","v":116.58570978372346},{"$f":" Inputs!U$45","v":118.91742397939792},{"$f":" Inputs!V$45","v":121.29577245898588}]
[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":105.1},{"$f":" Inputs!P$46","v":107.70122499999999},{"$f":" Inputs!Q$46","v":109.96295072499998},{"$f":" Inputs!R$46","v":112.24468195254374},{"$f":" Inputs!S$46","v":114.51763676208276},{"$f":" Inputs!T$46","v":116.80798949732441},{"$f":" Inputs!U$46","v":119.14414928727091},{"$f":" Inputs!V$46","v":121.52703227301633}]
[]
[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,105.75420000000001,{"$f":" IF(Q10 > 0, Q10, P25 * (1 + Q$23))","v":107.9750382},{"$f":" IF(R10 > 0, R10, Q25 * (1 + R$23))","v":110.21552024265},{"$f":" IF(S10 > 0, S10, R25 * (1 + S$23))","v":112.44738452756367},{"$f":" IF(T10 > 0, T10, S25 * (1 + T$23))","v":114.69633221811495},{"$f":" IF(U10 > 0, U10, T25 * (1 + U$23))","v":116.99025886247725},{"$f":" IF(V10 > 0, V10, U25 * (1 + V$23))","v":119.33006403972679}]
[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,106.06162500000001,108.28891912499999,110.53591419684375,112.77426645932985,115.02975178851645,117.33034682428678,119.67695376077252]
[null,null,null,null,"CPIH: June - index",null,"index",null,null,95.6,98,99.8,100.1,101,103.5,106.06162500000001,108.28891912499999,110.53591419684375,112.77426645932985,115.02975178851645,117.33034682428678,119.67695376077252]
[null,null,null,null,"CPIH: July - index",null,"index",null,null,95.7,98,99.6,100,100.9,103.5,106.06162500000001,108.28891912499999,110.53591419684375,112.77426645932985,115.02975178851645,117.33034682428678,119.67695376077252]
[null,null,null,null,"CPIH: August - index",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,104,106.57400000000001,108.812054,111.06990412050001,113.31906967894015,115.58545107251896,117.89716009396935,120.25510329584874]
[null,null,null,null,"CPIH: September- index",null,"index",null,null,96.4,98.7,100,100.2,101.5,104.3,106.88142500000001,109.125934925,111.39029807469375,113.64595161070631,115.91887064292044,118.23724805577885,120.60199301689443]
[null,null,null,null,"CPIH: October - index",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,104.4,106.98390000000001,109.2305619,111.497096059425,113.75491225462837,116.03001049972093,118.35061070971535,120.71762292390966]
[null,null,null,null,"CPIH: November - index",null,"index",null,null,97,98.8,99.9,100.3,101.8,104.7,107.29132500000001,109.544442825,111.81749001361877,114.08179418639456,116.36343007012245,118.6906986715249,121.0645126449554]
[null,null,null,null,"CPIH: December - index",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,105,107.59875000000001,109.85832375,112.1378839678125,114.40867611816071,116.69684964052394,119.03078663333442,121.4114023660011]
[null,null,null,null,"CPIH: January - index",null,"index",null,null,97,98.7,99.2,99.9,101.8,104.5,107.086375,109.335188875,111.60389404415625,113.86387289855043,116.14115035652144,118.46397336365186,120.83325283092491]
[null,null,null,null,"CPIH: February - index",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,104.9,107.49627500000001,109.75369677500001,112.03108598308127,114.29971547423868,116.58570978372346,118.91742397939792,121.29577245898588]
[null,null,null,null,"CPIH: March - index",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,105.1,107.70122499999999,109.96295072499998,112.24468195254374,114.51763676208276,116.80798949732441,119.14414928727091,121.52703227301633]
[]
[null,null,null,null,"CPIH: Financial year average - index",null,"index",null,null,{"$f":" AVERAGE(J25:J36)","v":96.583333333333314},98.600000000000009,99.72499999999998,100.16666666666667,101.54166666666667,104.21666666666665,106.79602916666668,{"$f":" AVERAGE(Q25:Q36)","v":109.03874577916666},111.30129975408437,113.55515107410459,115.82625409558666,118.14277917749843,120.50563476104843]
[]
[]
["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":279.73275000000001},{"$f":" Inputs!Q$52","v":288.12473249999999},{"$f":" Inputs!R$52","v":296.84050565812504},{"$f":" Inputs!S$52","v":306.04256133352692},{"$f":" Inputs!T$52","v":315.22383817353273},{"$f":" Inputs!U$52","v":324.6805533187387},{"$f":" Inputs!V$52","v":334.4209699183009}]
[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":280.86987499999998},{"$f":" Inputs!Q$53","v":289.29597124999998},{"$f":" Inputs!R$53","v":298.04717438031253},{"$f":" Inputs!S$53","v":307.28663678610218},{"$f":" Inputs!T$53","v":316.50523588968525},{"$f":" Inputs!U$53","v":326.00039296637584},{"$f":" Inputs!V$53","v":335.7804047553671}]
[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":272.3},{"$f":" Inputs!P$54","v":281.49012499999998},{"$f":" Inputs!Q$54","v":289.93482875000001},{"$f":" Inputs!R$54","v":298.70535731968755},{"$f":" Inputs!S$54","v":307.96522339659782},{"$f":" Inputs!T$54","v":317.20418009849578},{"$f":" Inputs!U$54","v":326.72030550145064},{"$f":" Inputs!V$54","v":336.52191466649418}]
[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":272.89999999999998},{"$f":" Inputs!P$55","v":282.11037499999998},{"$f":" Inputs!Q$55","v":290.57368624999998},{"$f":" Inputs!R$55","v":299.36354025906252},{"$f":" Inputs!S$55","v":308.64381000709341},{"$f":" Inputs!T$55","v":317.9031243073062},{"$f":" Inputs!U$55","v":327.44021803652538},{"$f":" Inputs!V$55","v":337.26342457762115}]
[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":274.7},{"$f":" Inputs!P$56","v":283.97112499999997},{"$f":" Inputs!Q$56","v":292.49025874999995},{"$f":" Inputs!R$56","v":301.33808907718748},{"$f":" Inputs!S$56","v":310.67956983858028},{"$f":" Inputs!T$56","v":319.99995693373768},{"$f":" Inputs!U$56","v":329.59995564174983},{"$f":" Inputs!V$56","v":339.48795431100234}]
[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":275.10000000000002},{"$f":" Inputs!P$57","v":284.38462500000003},{"$f":" Inputs!Q$57","v":292.91616375000001},{"$f":" Inputs!R$57","v":301.77687770343755},{"$f":" Inputs!S$57","v":311.1319609122441},{"$f":" Inputs!T$57","v":320.46591973961142},{"$f":" Inputs!U$57","v":330.07989733179977},{"$f":" Inputs!V$57","v":339.98229425175379}]
[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":275.3},{"$f":" Inputs!P$58","v":284.59137499999997},{"$f":" Inputs!Q$58","v":293.12911624999998},{"$f":" Inputs!R$58","v":301.9962720165625},{"$f":" Inputs!S$58","v":311.35815644907592},{"$f":" Inputs!T$58","v":320.69890114254821},{"$f":" Inputs!U$58","v":330.31986817682468},{"$f":" Inputs!V$58","v":340.22946422212942}]
[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":275.8},{"$f":" Inputs!P$59","v":285.10825},{"$f":" Inputs!Q$59","v":293.6614975},{"$f":" Inputs!R$59","v":302.54475779937502},{"$f":" Inputs!S$59","v":311.92364529115559},{"$f":" Inputs!T$59","v":321.28135464989026},{"$f":" Inputs!U$59","v":330.91979528938697},{"$f":" Inputs!V$59","v":340.8473891480686}]
[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":278.10000000000002},{"$f":" Inputs!P$60","v":287.48587500000002},{"$f":" Inputs!Q$60","v":296.11045125000004},{"$f":" Inputs!R$60","v":305.06779240031256},{"$f":" Inputs!S$60","v":314.5248939647222},{"$f":" Inputs!T$60","v":323.96064078366385},{"$f":" Inputs!U$60","v":333.67946000717376},{"$f":" Inputs!V$60","v":343.68984380738897}]
[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":276},{"$f":" Inputs!P$61","v":285.315},{"$f":" Inputs!Q$61","v":293.87445000000002},{"$f":" Inputs!R$61","v":302.76415211250008},{"$f":" Inputs!S$61","v":312.14984082798759},{"$f":" Inputs!T$61","v":321.51433605282722},{"$f":" Inputs!U$61","v":331.15976613441205},{"$f":" Inputs!V$61","v":341.09455911844441}]
[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":278.10000000000002},{"$f":" Inputs!P$62","v":287.48587500000002},{"$f":" Inputs!Q$62","v":296.11045125000004},{"$f":" Inputs!R$62","v":305.06779240031256},{"$f":" Inputs!S$62","v":314.5248939647222},{"$f":" Inputs!T$62","v":323.96064078366385},{"$f":" Inputs!U$62","v":333.67946000717376},{"$f":" Inputs!V$62","v":343.68984380738897}]
[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":278.3},{"$f":" Inputs!P$63","v":287.69262500000002},{"$f":" Inputs!Q$63","v":296.32340375000001},{"$f":" Inputs!R$63","v":305.28718671343756},{"$f":" Inputs!S$63","v":314.75108950155408},{"$f":" Inputs!T$63","v":324.19362218660069},{"$f":" Inputs!U$63","v":333.91943085219873},{"$f":" Inputs!V$63","v":343.93701377776472}]
[]
[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,279.73275000000001,{"$f":" IF(Q44 > 0, Q44, P59 * (1 + Q$57))","v":288.12473249999999},{"$f":" IF(R44 > 0, R44, Q59 * (1 + R$57))","v":296.84050565812504},{"$f":" IF(S44 > 0, S44, R59 * (1 + S$57))","v":306.04256133352692},{"$f":" IF(T44 > 0, T44, S59 * (1 + T$57))","v":315.22383817353273},{"$f":" IF(U44 > 0, U44, T59 * (1 + U$57))","v":324.6805533187387},{"$f":" IF(V44 > 0, V44, U59 * (1 + V$57))","v":334.4209699183009}]
[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,280.86987499999998,289.29597124999998,298.04717438031253,307.28663678610218,316.50523588968525,326.00039296637584,335.7804047553671]
[null,null,null,null,"RPI: June - index",null,"index",null,null,{"$f":" IF(J46 > 0, J46, I61 * (1 + J$57))","v":241.8},249.7,256.3,258.89999999999998,263.10000000000002,272.3,281.49012499999998,289.93482875000001,298.70535731968755,307.96522339659782,317.20418009849578,326.72030550145064,336.52191466649418]
[null,null,null,null,"RPI: July - index",null,"index",null,null,{"$f":" IF(J47 > 0, J47, I62 * (1 + J$57))","v":242.1},249.7,256,258.60000000000002,263.39999999999998,272.89999999999998,282.11037499999998,290.57368624999998,299.36354025906252,308.64381000709341,317.9031243073062,327.44021803652538,337.26342457762115]
[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,274.7,283.97112499999997,292.49025874999995,301.33808907718748,310.67956983858028,319.99995693373768,329.59995564174983,339.48795431100234]
[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,275.10000000000002,284.38462500000003,292.91616375000001,301.77687770343755,311.1319609122441,320.46591973961142,330.07989733179977,339.98229425175379]
[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,275.3,284.59137499999997,293.12911624999998,301.9962720165625,311.35815644907592,320.69890114254821,330.31986817682468,340.22946422212942]
[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,275.8,285.10825,293.6614975,302.54475779937502,311.92364529115559,321.28135464989026,330.91979528938697,340.8473891480686]
[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,278.10000000000002,287.48587500000002,296.11045125000004,305.06779240031256,314.5248939647222,323.96064078366385,333.67946000717376,343.68984380738897]
[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,276,285.315,293.87445000000002,302.76415211250008,312.14984082798759,321.51433605282722,331.15976613441205,341.09455911844441]
[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,278.10000000000002,287.48587500000002,296.11045125000004,305.06779240031256,314.5248939647222,323.96064078366385,333.67946000717376,343.68984380738897]
[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,278.3,287.69262500000002,296.32340375000001,305.28718671343756,314.75108950155408,324.19362218660069,333.91943085219873,343.93701377776472]
[]
[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,274.90833333333336,284.1864895833333,{"$f":" AVERAGE(Q59:Q70)","v":292.71208427083337},301.56662482002611,310.91519018944683,320.24264589513018,329.8499252719842,339.74542303014374]
[]
[]
["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,274.90833333333336,284.1864895833333,292.71208427083337,301.56662482002611,310.91519018944683,320.24264589513018,329.8499252719842,339.74542303014374]
[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,278.3,287.69262500000002,296.32340375000001,305.28718671343756,314.75108950155408,324.19362218660069,333.91943085219873,343.93701377776472]
[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.2110898283437215},"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,274.90833333333336,284.1864895833333,292.71208427083337,301.56662482002611,310.91519018944683,320.24264589513018,329.8499252719842,339.74542303014374]
[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,278.3,287.69262500000002,296.32340375000001,305.28718671343756,314.75108950155408,324.19362218660069,333.91943085219873,343.93701377776472]
[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.0778989496498832},"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,278.3,287.69262500000002,296.32340375000001,305.28718671343756,314.75108950155408,324.19362218660069,333.91943085219873,343.93701377776472]
[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,275.8,285.10825,293.6614975,302.54475779937502,311.92364529115559,321.28135464989026,330.91979528938697,340.8473891480686]
[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,278.3,287.69262500000002,296.32340375000001,305.28718671343756,314.75108950155408,324.19362218660069,333.91943085219873,343.93701377776472]
[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.039336475707034},"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$36","v":"CPIH: March - index"},{"$f":" F$36","v":0},"index",0,0,97.8,99.3,99.6,100.4,102.7,105.1,107.70122499999999,109.96295072499998,112.24468195254374,114.51763676208276,116.80798949732441,119.14414928727091,121.52703227301633]
[null,null,null,null,{"$f":" E$38","v":"CPIH: Financial year average - index"},0,"index",0,0,96.583333333333314,98.600000000000009,99.72499999999998,100.16666666666667,101.54166666666667,104.21666666666665,106.79602916666668,109.03874577916666,111.30129975408437,113.55515107410459,115.82625409558666,118.14277917749843,120.50563476104843]
[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.94774345340455735},"factor"]

{"sheet":"Calc","index":6,"n_rows":220,"n_cols":22,"rows_kept":220,"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,"Water resources"]
[null,null,null,null,{"$f":" Inputs!E$86","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water resources"},{"$f":" Inputs!F$86","v":0},{"$f":" Inputs!G$86","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$87","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water resources"},{"$f":" Inputs!F$87","v":0},{"$f":" Inputs!G$87","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E10 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F10 * F$13","v":0},"£m"]
[null,null,null,null,{"$f":" E11 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F11 * F$13","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Inputs!E$88","v":"Total value of export incentive to be paid to water resources at PR19"},{"$f":" Inputs!F$88","v":0},{"$f":" Inputs!G$88","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$89","v":"Total value of import incentive - water resources"},{"$f":" Inputs!F$89","v":0},{"$f":" Inputs!G$89","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.0778989496498832},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,"Water trading total value of export incentive ~ Water resources at 2020 FYE price base",{"$f":" F18 * F$21","v":0},"£m"]
[null,null,null,null,"Water trading total value of import incentive ~ Water resources  at 2020 FYE price base",{"$f":" F19 * F$21","v":0},"£m"]
[]
[null,"Water network plus"]
[null,null,null,null,{"$f":" Inputs!E$92","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Water network plus"},{"$f":" Inputs!F$92","v":-5.4571112234032597E-2},{"$f":" Inputs!G$92","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$93","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water network plus"},{"$f":" Inputs!F$93","v":0},{"$f":" Inputs!G$93","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$94","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water network plus"},{"$f":" Inputs!F$94","v":2.920535299999949},{"$f":" Inputs!G$94","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$95","v":"Water: revenue adjustment from totex menu model"},{"$f":" Inputs!F$95","v":-0.31513026964971541},{"$f":" Inputs!G$95","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E27 & \" at 2020 FYE price base\"","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Water network plus at 2020 FYE price base"},{"$f":" F27 * F$32","v":-6.6090518948040494E-2},"£m"]
[null,null,null,null,{"$f":" E28 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F28 * F$32","v":0},"£m"]
[null,null,null,null,{"$f":" E29 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F29 * F$32","v":3.5370305951487175},"£m"]
[null,null,null,null,{"$f":" \"Totex menu revenue adjustment ~ Water network plus \" & \" at 2020 FYE price base\"","v":"Totex menu revenue adjustment ~ Water network plus  at 2020 FYE price base"},{"$f":" F30 * F$32","v":-0.38165106417598449},"£m"]
[]
[null,null,null,null,{"$f":" Inputs!E$96","v":"Total value of export incentive to be paid to water network plus at PR19"},{"$f":" Inputs!F$96","v":0},{"$f":" Inputs!G$96","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$97","v":"Total value of import incentive - water network plus"},{"$f":" Inputs!F$97","v":0},{"$f":" Inputs!G$97","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$98","v":"WRFIM total reward / (penalty) at end of AMP6 ~ Water"},{"$f":" Inputs!F$98","v":-1.9120466858445233},{"$f":" Inputs!G$98","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.0778989496498832},{"$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.039336475707034},{"$f":" Indexation!G$102","v":"factor"}]
[]
[null,null,null,null,"Water trading total value of export incentive - Water network plus at 2020 FYE price base",{"$f":" F39 * F$43","v":0},"£m"]
[null,null,null,null,"Water trading total value of import incentive - Water network plus at 2020 FYE price base",{"$f":" F40 * F$43","v":0},"£m"]
[null,null,null,null,"WRFIM total reward / (penalty) at the end of AMP6 ~ Water network plus at 2020 FYE price base",{"$f":" F41 * F$44","v":-1.9872598638529613},"£m"]
[]
[]
["WASTEWATER SERVICES INPUTS INFLATION"]
[]
[null,"Bioresources"]
[null,null,null,null,{"$f":" Inputs!E$103","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Bioresources"},{"$f":" Inputs!F$103","v":0},{"$f":" Inputs!G$103","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$104","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Bioresources"},{"$f":" Inputs!F$104","v":0},{"$f":" Inputs!G$104","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E54 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Bioresources at 2020 FYE price base"},{"$f":" F54 * F$57","v":0},"£m"]
[null,null,null,null,{"$f":" E55 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Bioresources at 2020 FYE price base"},{"$f":" F55 * F$57","v":0},"£m"]
[]
[null,"Wastewater network plus"]
[null,null,null,null,{"$f":" Inputs!E$107","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Wastewater network plus"},{"$f":" Inputs!F$107","v":0},{"$f":" Inputs!G$107","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$108","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Wastewater network plus"},{"$f":" Inputs!F$108","v":0},{"$f":" Inputs!G$108","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$109","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Wastewater network plus"},{"$f":" Inputs!F$109","v":0},{"$f":" Inputs!G$109","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$110","v":"Wastewater: revenue adjustment from totex menu model"},{"$f":" Inputs!F$110","v":0},{"$f":" Inputs!G$110","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E63 & \" at 2020 FYE price base\"","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F63 * F$68","v":0},"£m"]
[null,null,null,null,{"$f":" E64 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F64 * F$68","v":0},"£m"]
[null,null,null,null,{"$f":" E65 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F65 * F$68","v":0},"£m"]
[null,null,null,null,{"$f":" E66 & \" at 2020 FYE price base\"","v":"Wastewater: revenue adjustment from totex menu model at 2020 FYE price base"},{"$f":" F66 * F$68","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Inputs!E$111","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater"},{"$f":" Inputs!F$111","v":0},{"$f":" Inputs!G$111","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.039336475707034},{"$f":" Indexation!G$102","v":"factor"}]
[]
[null,null,null,null,"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater network plus at 2020 FYE price base",{"$f":" F75 * F76","v":0},"£m"]
[]
[null,"Dummy control"]
[null,null,null,null,{"$f":" Inputs!E$114","v":"Dummy: revenue adjustment from totex menu model"},{"$f":" Inputs!F$114","v":0},{"$f":" Inputs!G$114","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E81 & \" at 2020 FYE price base\"","v":"Dummy: revenue adjustment from totex menu model at 2020 FYE price base"},{"$f":" F81 * F$83","v":0},"£m"]
[]
[]
[]
["RESIDENTIAL RETAIL INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$118","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Residential retail"},{"$f":" Inputs!F$118","v":0},{"$f":" Inputs!G$118","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$119","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Residential retail"},{"$f":" Inputs!F$119","v":0},{"$f":" Inputs!G$119","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$120","v":"Residential retail revenue adjustment at end of AMP6"},{"$f":" Inputs!F$120","v":1.0572026731671273},{"$f":" Inputs!G$120","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$121","v":"SIM forecast revenue adjustment"},{"$f":" Inputs!F$121","v":2.3875857721170477},{"$f":" Inputs!G$121","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[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.0778989496498832},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,{"$f":" E91 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Residential retail at 2020 FYE price base"},{"$f":" F91 * F$96","v":0},"£m"]
[null,null,null,null,"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Residential retail at 2020 FYE price base",{"$f":" F92 * F$96","v":0},"£m"]
[null,null,null,null,{"$f":" E93 & \" at 2020 FYE price base\"","v":"Residential retail revenue adjustment at end of AMP6 at 2020 FYE price base"},{"$f":" F93 * F97","v":1.0572026731671273},"£m"]
[null,null,null,null,{"$f":" E94 & \" at 2020 FYE price base\"","v":"SIM forecast revenue adjustment at 2020 FYE price base"},{"$f":" F94 * F98","v":2.5735761959639709},"£m"]
[]
[]
["BUSINESS RETAIL INPUTS INFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$125","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Business retail"},{"$f":" Inputs!F$125","v":0},{"$f":" Inputs!G$125","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$126","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Business retail"},{"$f":" Inputs!F$126","v":0},{"$f":" Inputs!G$126","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.2110898283437215},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E108 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Business retail at 2020 FYE price base"},{"$f":" F108 * F$111","v":0},"£m"]
[null,null,null,null,{"$f":" E109 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Business retail at 2020 FYE price base"},{"$f":" F109 * F$111","v":0},"£m"]
[]
[]
["PR14 REVENUE RECONCILIATION ADJUSTMENTS EXPRESSED IN 2017-18 FYA CPIH DEFLATED PRICE BASE"]
[]
[null,null,null,null,{"$f":" E$15","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$15","v":0},"£m"]
[null,null,null,null,{"$f":" E$16","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$16","v":0},"£m"]
[null,null,null,null,{"$f":" E$23","v":"Water trading total value of export incentive ~ Water resources at 2020 FYE price base"},{"$f":" F$23","v":0},"£m"]
[null,null,null,null,{"$f":" E$24","v":"Water trading total value of import incentive ~ Water resources  at 2020 FYE price base"},{"$f":" F$24","v":0},"£m"]
[null,null,null,null,{"$f":" E$34","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Water network plus at 2020 FYE price base"},{"$f":" F$34","v":-6.6090518948040494E-2},"£m"]
[null,null,null,null,{"$f":" E$35","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$35","v":0},"£m"]
[null,null,null,null,{"$f":" E$36","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$36","v":3.5370305951487175},"£m"]
[null,null,null,null,{"$f":" E$37","v":"Totex menu revenue adjustment ~ Water network plus  at 2020 FYE price base"},{"$f":" F$37","v":-0.38165106417598449},"£m"]
[null,null,null,null,{"$f":" E$46","v":"Water trading total value of export incentive - Water network plus at 2020 FYE price base"},{"$f":" F$46","v":0},"£m"]
[null,null,null,null,{"$f":" E$47","v":"Water trading total value of import incentive - Water network plus at 2020 FYE price base"},{"$f":" F$47","v":0},"£m"]
[null,null,null,null,{"$f":" E$48","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Water network plus at 2020 FYE price base"},{"$f":" F$48","v":-1.9872598638529613},"£m"]
[null,null,null,null,{"$f":" E$59","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Bioresources at 2020 FYE price base"},{"$f":" F$59","v":0},"£m"]
[null,null,null,null,{"$f":" E$60","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Bioresources at 2020 FYE price base"},{"$f":" F$60","v":0},"£m"]
[null,null,null,null,{"$f":" E$70","v":"Further 2010-15 reconciliation total adjustment carry forward to PR19 ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F$70","v":0},"£m"]
[null,null,null,null,{"$f":" E$71","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F$71","v":0},"£m"]
[null,null,null,null,{"$f":" E$72","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F$72","v":0},"£m"]
[null,null,null,null,{"$f":" E$73","v":"Wastewater: revenue adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$73","v":0},"£m"]
[null,null,null,null,{"$f":" E$78","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F$78","v":0},"£m"]
[null,null,null,null,{"$f":"E$85","v":"Dummy: revenue adjustment from totex menu model at 2020 FYE price base"},{"$f":"F$85","v":0},"£m"]
[null,null,null,null,{"$f":" E$100","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Residential retail at 2020 FYE price base"},{"$f":" F$100","v":0},"£m"]
[null,null,null,null,{"$f":" E$101","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Residential retail at 2020 FYE price base"},{"$f":" F$101","v":0},"£m"]
[null,null,null,null,{"$f":" E$102","v":"Residential retail revenue adjustment at end of AMP6 at 2020 FYE price base"},{"$f":" F$102","v":1.0572026731671273},"£m"]
[null,null,null,null,{"$f":" E$103","v":"SIM forecast revenue adjustment at 2020 FYE price base"},{"$f":" F$103","v":2.5735761959639709},"£m"]
[null,null,null,null,{"$f":" E$113","v":"Net performance payment / (penalty) applied to revenue for in-period ODI adjustments ~ Business retail at 2020 FYE price base"},{"$f":" F$113","v":0},"£m"]
[null,null,null,null,{"$f":" E$114","v":"Net performance payment / (penalty) applied to revenue for end of period ODI adjustments ~ Business retail at 2020 FYE price base"},{"$f":" F$114","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.94774345340455735},{"$f":" Indexation!G$111","v":"factor"}]
[]
[null,null,null,null,"ODI in-period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base",{"$f":" F119 * F$145","v":0},"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Water trading total value of export incentive ~ Water resources at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Water trading total value of import incentive ~ Water resources  at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Water network plus at 2017-18 FYA CPIH deflated price base",-6.2636856665115231E-2,"£m"]
[null,null,null,null,"ODI in-period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base",3.3521975910438222,"£m"]
[null,null,null,null,"Water: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base",-0.36170729755767189,"£m"]
[null,null,null,null,"Water trading total value of export incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Water trading total value of import incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"WRFIM total reward / (penalty) at the end of AMP6 ~ Water network plus at 2017-18 FYA CPIH deflated price base",-1.8834125261802759,"£m"]
[null,null,null,null,"ODI in-period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI in-period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Wastewater: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Dummy: revenue adjustment from totex menu model at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI in-period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"Residential retail revenue adjustment at 2017-18 FYA CPIH deflated price base",1.0019569124159429,"£m"]
[null,null,null,null,"SIM forecast revenue adjustment at 2017-18 FYA CPIH deflated price base",2.4390899915626578,"£m"]
[null,null,null,null,"ODI in-period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base",0,"£m"]
[null,null,null,null,"ODI end of period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base",0,"£m"]
[]
[]
["SUBTOTALS AS PER PRICE CONTROL FOR REVENUE ADJUSTMENTS 2017-18 FYA CPIH DEFLATED PRICE BASE"]
[]
[null,"Water resources revenue adjustment"]
[null,null,null,null,{"$f":"E$147","v":"ODI in-period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":"F$147","v":0},"£m"]
[null,null,null,null,{"$f":"E$148","v":"ODI end of period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":"F$148","v":0},"£m"]
[null,null,null,null,{"$f":"E$149","v":"Water trading total value of export incentive ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":"F$149","v":0},"£m"]
[null,null,null,null,{"$f":"E$150","v":"Water trading total value of import incentive ~ Water resources  at 2017-18 FYA CPIH deflated price base"},{"$f":"F$150","v":0},"£m"]
[null,null,null,null,"Water resources revenue adjustment",{"$f":" SUM(F177:F180)","v":0},"£m"]
[]
[null,"Water network plus revenue adjustment"]
[null,null,null,null,{"$f":" E$151","v":"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$151","v":-6.2636856665115231E-2},"£m"]
[null,null,null,null,{"$f":" E$152","v":"ODI in-period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$152","v":0},"£m"]
[null,null,null,null,{"$f":" E$153","v":"ODI end of period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$153","v":3.3521975910438222},"£m"]
[null,null,null,null,{"$f":" E$154","v":"Water: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" F$154","v":-0.36170729755767189},"£m"]
[null,null,null,null,{"$f":" E$155","v":"Water trading total value of export incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$155","v":0},"£m"]
[null,null,null,null,{"$f":" E$156","v":"Water trading total value of import incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$156","v":0},"£m"]
[null,null,null,null,{"$f":" E$157","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$157","v":-1.8834125261802759},"£m"]
[null,null,null,null,"Water network plus revenue adjustment",{"$f":" SUM(F184:F190)","v":1.0444409106407593},"£m"]
[]
[null,"Bioresources revenue adjustment"]
[null,null,null,null,{"$f":"E$158","v":"ODI in-period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base"},{"$f":"F$158","v":0},"£m"]
[null,null,null,null,{"$f":"E$159","v":"ODI end of period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base"},{"$f":"F$159","v":0},"£m"]
[null,null,null,null,"Bioresources revenue adjustment",{"$f":" SUM(F194:F195)","v":0},"£m"]
[]
[null,"Wastewater network plus revenue adjustment"]
[null,null,null,null,{"$f":" E$160","v":"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$160","v":0},"£m"]
[null,null,null,null,{"$f":" E$163","v":"Wastewater: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" F$163","v":0},"£m"]
[null,null,null,null,{"$f":" E$161","v":"ODI in-period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$161","v":0},"£m"]
[null,null,null,null,{"$f":" E$162","v":"ODI end of period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$162","v":0},"£m"]
[null,null,null,null,{"$f":" E$164","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" F$164","v":0},"£m"]
[null,null,null,null,"Wastewater network plus revenue adjustment",{"$f":" SUM(F199:F203)","v":0},"£m"]
[]
[null,"Dummy revenue adjustment"]
[null,null,null,null,{"$f":"E$165","v":"Dummy: revenue adjustment from totex menu model at 2017-18 FYA CPIH deflated price base"},{"$f":"F$165","v":0},"£m"]
[null,null,null,null,"Dummy control revenue adjustment",{"$f":" SUM(F207:F207)","v":0},"£m"]
[]
[null,"Residential retail revenue adjustment"]
[null,null,null,null,{"$f":" E$166","v":"ODI in-period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base"},{"$f":" F$166","v":0},"£m"]
[null,null,null,null,{"$f":" E$167","v":"ODI end of period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base"},{"$f":" F$167","v":0},"£m"]
[null,null,null,null,{"$f":" E$168","v":"Residential retail revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" F$168","v":1.0019569124159429},"£m"]
[null,null,null,null,{"$f":" E$169","v":"SIM forecast revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" F$169","v":2.4390899915626578},"£m"]
[null,null,null,null,"Residential retail revenue adjustment",{"$f":" SUM(F211:F214)","v":3.4410469039786005},"£m"]
[]
[null,"Business retail revenue adjustment"]
[null,null,null,null,{"$f":" E$170","v":"ODI in-period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base"},{"$f":" F$170","v":0}]
[null,null,null,null,{"$f":" E$171","v":"ODI end of period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base"},{"$f":" F$171","v":0}]
[null,null,null,null,"Business retail revenue adjustment",{"$f":" SUM(F218:F219)","v":0},"£m"]

{"sheet":"Profiling","index":7,"n_rows":247,"n_cols":22,"rows_kept":247,"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$133","v":"PV base date"},{"$f":" Inputs!F$133","v":"2021-03-31"},{"$f":" Inputs!G$133","v":"date"}]
[null,null,null,null,{"$f":" Inputs!E$162","v":"Days in a year"},{"$f":" Inputs!F$162","v":365},{"$f":" Inputs!G$162","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},{"$f":" IF(R11 < $F9, 0, (R11 - $F9) / $F10) * R12","v":0},{"$f":" IF(S11 < $F9, 0, (S11 - $F9) / $F10) * S12","v":1},2,3.0027397260273974,4.0027397260273974]
[]
[null,null,null,null,{"$f":" Inputs!E$135","v":"Discount rate - Water resources"},{"$f":" Inputs!F$135","v":3.3000000000000002E-2},{"$f":" Inputs!G$135","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$136","v":"Discount rate - Water network plus"},{"$f":" Inputs!F$136","v":3.3000000000000002E-2},{"$f":" Inputs!G$136","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$137","v":"Discount rate - Bioresources"},{"$f":" Inputs!F$137","v":0},{"$f":" Inputs!G$137","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$138","v":"Discount rate - Wastewater network plus"},{"$f":" Inputs!F$138","v":0},{"$f":" Inputs!G$138","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$139","v":"Discount rate - Dummy control"},{"$f":" Inputs!F$139","v":0},{"$f":" Inputs!G$139","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$140","v":"Discount rate - Residential retail"},{"$f":" Inputs!F$140","v":3.3000000000000002E-2},{"$f":" Inputs!G$140","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$141","v":"Discount rate - Business retail"},{"$f":" Inputs!F$141","v":0},{"$f":" Inputs!G$141","v":"%"}]
[]
[null,null,null,null,{"$f":" Inputs!E$133","v":"PV base date"},{"$f":" Inputs!F$133","v":"2021-03-31"},{"$f":" Inputs!G$133","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(J28:V28)","v":4.6904266708184057},null,{"$f":" IF(J$25 < $F$23, 0, 1 / ( 1 + $F15) ^ J$26)","v":0},{"$f":" IF(K$25 < $F$23, 0, 1 / ( 1 + $F15) ^ K$26)","v":0},0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,"PV discount factor - Water network",null,"factor",{"$f":" SUM(J29:V29)","v":4.6904266708184057},null,{"$f":" IF(J$25 < $F$23, 0, 1 / ( 1 + $F16) ^ J$26)","v":0},{"$f":" IF(K$25 < $F$23, 0, 1 / ( 1 + $F16) ^ K$26)","v":0},0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,"PV discount factor - Bioresources",null,"factor",5,null,{"$f":" IF(J$25 < $F$23, 0, 1 / ( 1 + $F17) ^ J$26)","v":0},{"$f":" IF(K$25 < $F$23, 0, 1 / ( 1 + $F17) ^ K$26)","v":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$25 < $F$23, 0, 1 / ( 1 + $F18) ^ J$26)","v":0},0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"PV discount factor - Dummy control",null,"factor",{"$f":" SUM(J32:V32)","v":5},null,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"PV discount factor - Residential retail",null,"factor",4.6904266708184057,null,{"$f":" IF(J$25 < $F$23, 0, 1 / ( 1 + $F20) ^ J$26)","v":0},0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,"PV discount factor - Business retail",null,"factor",5,null,{"$f":" IF(J$25 < $F$23, 0, 1 / ( 1 + $F21) ^ J$26)","v":0},0,0,0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Water resources"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$29","v":"PV discount factor - Water network"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$30","v":"PV discount factor - Bioresources"},{"$f":" F$30","v":0},"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$31","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$32","v":"PV discount factor - Dummy control"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$33","v":"PV discount factor - Residential retail"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$34","v":"PV discount factor - Business retail"},{"$f":" F$34","v":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(J36:V36)","v":4.6904266708184057},"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Water network",4.6904266708184057,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Bioresources",5,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Wastewater network",5,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Dummy control",5,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Residential retail",4.6904266708184057,"factor"]
[null,null,null,null,"Equivalent Annual Cost (EAC) factor - Business retail",5,"factor"]
[]
[]
["PROFILES"]
[]
[null,"Profile 0 - Apply in first year"]
[null,null,null,null,{"$f":" Inputs!E$133","v":"PV base date"},{"$f":" Inputs!F$133","v":"2021-03-31"},{"$f":" Inputs!G$133","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$28","v":"PV discount factor - Water resources"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$29","v":"PV discount factor - Water network"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$30","v":"PV discount factor - Bioresources"},{"$f":" F$30","v":0},"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$31","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$32","v":"PV discount factor - Dummy control"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$33","v":"PV discount factor - Residential retail"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$34","v":"PV discount factor - Business retail"},{"$f":" F$34","v":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$57 = J$59, J61, 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$57 = J$59, J62, 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 - Bioresources",null,"factor",null,null,{"$f":" IF($F$57 = J$59, J63, 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$57 = J$59, J64, 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 - Dummy control",null,"factor",null,null,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$57 = J$59, J66, 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 - Business retail",null,"factor",null,null,{"$f":" IF($F$57 = J$59, J67, 0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0]
[]
[null,null,null,null,{"$f":" Calc!E$181","v":"Water resources revenue adjustment"},{"$f":" Calc!F$181","v":0},{"$f":" Calc!G$181","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$191","v":"Water network plus revenue adjustment"},{"$f":" Calc!F$191","v":1.0444409106407593},{"$f":" Calc!G$191","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$196","v":"Bioresources revenue adjustment"},{"$f":" Calc!F$196","v":0},{"$f":" Calc!G$196","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$204","v":"Wastewater network plus revenue adjustment"},{"$f":" Calc!F$204","v":0},{"$f":" Calc!G$204","v":"£m"}]
[null,null,null,null,{"$f":"Calc!E$208","v":"Dummy control revenue adjustment"},{"$f":"Calc!F$208","v":0},{"$f":"Calc!G$208","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$215","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$215","v":3.4410469039786005},{"$f":" Calc!G$215","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$220","v":"Business retail revenue adjustment"},{"$f":" Calc!F$220","v":0},{"$f":" Calc!G$220","v":"£m"}]
[]
[null,null,null,null,{"$f":" E$69","v":"PV discount factor at base date - Water resources"},0,{"$f":" G$69","v":"factor"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$70","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$71","v":"PV discount factor at base date - Bioresources"},{"$f":" F$71","v":0},"factor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$72","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$73","v":"PV discount factor at base date - Dummy control"},0,"factor",0,0,0,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,{"$f":" E$74","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,{"$f":" E$75","v":"PV discount factor at base date - Business retail"},{"$f":" F$75","v":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(J93:V93)","v":0},null,{"$f":" $F77 * J85","v":0},{"$f":" $F77 * K85","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",1.0444409106407593,null,{"$f":" $F78 * J86","v":0},{"$f":" $F78 * K86","v":0},0,0,0,0,0,0,1.0444409106407593,0,0,0,0]
[null,null,null,null,"Bioresources revenue adjustment applied in first year",null,"£m",0,null,{"$f":" $F79 * J87","v":0},{"$f":" $F79 * K87","v":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":" $F80 * J88","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment applied in first year",null,"£m",{"$f":" SUM(J97:V97)","v":0},null,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",3.4410469039786005,null,{"$f":" $F82 * J90","v":0},0,0,0,0,0,0,0,3.4410469039786005,0,0,0,0]
[null,null,null,null,"Business retail revenue adjustment applied in first year",null,"£m",0,null,{"$f":" $F83 * J91","v":0},{"$f":" $F83 * K91","v":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$181","v":"Water resources revenue adjustment"},{"$f":" Calc!F$181","v":0},{"$f":" Calc!G$181","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$191","v":"Water network plus revenue adjustment"},{"$f":" Calc!F$191","v":1.0444409106407593},{"$f":" Calc!G$191","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$196","v":"Bioresources revenue adjustment"},{"$f":" Calc!F$196","v":0},{"$f":" Calc!G$196","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$204","v":"Wastewater network plus revenue adjustment"},{"$f":" Calc!F$204","v":0},{"$f":" Calc!G$204","v":"£m"}]
[null,null,null,null,{"$f":"Calc!E$208","v":"Dummy control revenue adjustment"},{"$f":"Calc!F$208","v":0},{"$f":"Calc!G$208","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$215","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$215","v":3.4410469039786005},{"$f":" Calc!G$215","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$220","v":"Business retail revenue adjustment"},{"$f":" Calc!F$220","v":0},{"$f":" Calc!G$220","v":"£m"}]
[]
[null,null,null,null,{"$f":" E$45","v":"Equivalent Annual Cost (EAC) factor - Water resources"},4.6904266708184057,"factor"]
[null,null,null,null,{"$f":" E$46","v":"Equivalent Annual Cost (EAC) factor - Water network"},4.6904266708184057,"factor"]
[null,null,null,null,{"$f":" E$47","v":"Equivalent Annual Cost (EAC) factor - Bioresources"},{"$f":" F$47","v":5},"factor"]
[null,null,null,null,{"$f":" E$48","v":"Equivalent Annual Cost (EAC) factor - Wastewater network"},{"$f":" F$48","v":5},{"$f":" G$48","v":"factor"}]
[null,null,null,null,{"$f":" E$49","v":"Equivalent Annual Cost (EAC) factor - Dummy control"},{"$f":" F$49","v":5},"factor"]
[null,null,null,null,{"$f":" E$50","v":"Equivalent Annual Cost (EAC) factor - Residential retail"},4.6904266708184057,"factor"]
[null,null,null,null,{"$f":" E$51","v":"Equivalent Annual Cost (EAC) factor - Business retail"},{"$f":" F$51","v":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(J120:V120)","v":0},null,{"$f":" ($F102 / $F110) * J$118","v":0},{"$f":" ($F102 / $F110) * K$118","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",1.1133751617297118,null,{"$f":" ($F103 / $F111) * J$118","v":0},{"$f":" ($F103 / $F111) * K$118","v":0},0,0,0,0,0,0,0.22267503234594238,0.22267503234594238,0.22267503234594238,0.22267503234594238,0.22267503234594238]
[null,null,null,null,"Bioresources revenue adjustment - EAC factor adjusted",null,"£m",0,null,{"$f":" ($F104 / $F112) * J$118","v":0},{"$f":" ($F104 / $F112) * K$118","v":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",0,null,{"$f":" ($F105 / $F113) * J$118","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment - EAC factor adjusted",null,"£m",{"$f":" SUM(J124:V124)","v":0},null,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",3.6681597917169784,null,{"$f":" ($F107 / $F115) * J$118","v":0},0,0,0,0,0,0,0,0.73363195834339567,0.73363195834339567,0.73363195834339567,0.73363195834339567,0.73363195834339567]
[null,null,null,null,"Business retail revenue adjustment - EAC factor adjusted",null,"£m",0,null,{"$f":" ($F108 / $F116) * J$118","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$120","v":"Water resources revenue adjustment - EAC factor adjusted"},0,{"$f":" G$120","v":"£m"},{"$f":" H$120","v":0},{"$f":" I$120","v":0},{"$f":" J$120","v":0},{"$f":" K$120","v":0},{"$f":" L$120","v":0},{"$f":" M$120","v":0},{"$f":" N$120","v":0},{"$f":" O$120","v":0},{"$f":" P$120","v":0},{"$f":" Q$120","v":0},{"$f":" R$120","v":0},{"$f":" S$120","v":0},{"$f":" T$120","v":0},{"$f":" U$120","v":0},{"$f":" V$120","v":0}]
[null,null,null,null,{"$f":" E$121","v":"Water network revenue adjustment - EAC factor adjusted"},0,{"$f":" G$121","v":"£m"},{"$f":" H$121","v":1.1133751617297118},{"$f":" I$121","v":0},{"$f":" J$121","v":0},{"$f":" K$121","v":0},{"$f":" L$121","v":0},{"$f":" M$121","v":0},{"$f":" N$121","v":0},{"$f":" O$121","v":0},{"$f":" P$121","v":0},{"$f":" Q$121","v":0},{"$f":" R$121","v":0.22267503234594238},{"$f":" S$121","v":0.22267503234594238},{"$f":" T$121","v":0.22267503234594238},{"$f":" U$121","v":0.22267503234594238},{"$f":" V$121","v":0.22267503234594238}]
[null,null,null,null,{"$f":" E$122","v":"Bioresources revenue adjustment - EAC factor adjusted"},{"$f":" F$122","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$123","v":"Wastewater network revenue adjustment - EAC factor adjusted"},{"$f":" F$123","v":0},{"$f":" G$123","v":"£m"},{"$f":" H$123","v":0},{"$f":" I$123","v":0},{"$f":" J$123","v":0},{"$f":" K$123","v":0},{"$f":" L$123","v":0},{"$f":" M$123","v":0},{"$f":" N$123","v":0},{"$f":" O$123","v":0},{"$f":" P$123","v":0},{"$f":" Q$123","v":0},{"$f":" R$123","v":0},{"$f":" S$123","v":0},{"$f":" T$123","v":0},{"$f":" U$123","v":0},{"$f":" V$123","v":0}]
[null,null,null,null,{"$f":" E$124","v":"Dummy control revenue adjustment - EAC factor adjusted"},{"$f":" F$124","v":0},{"$f":" G$124","v":"£m"},{"$f":" H$124","v":0},{"$f":" I$124","v":0},{"$f":" J$124","v":0},{"$f":" K$124","v":0},{"$f":" L$124","v":0},{"$f":" M$124","v":0},{"$f":" N$124","v":0},{"$f":" O$124","v":0},{"$f":" P$124","v":0},{"$f":" Q$124","v":0},{"$f":" R$124","v":0},{"$f":" S$124","v":0},{"$f":" T$124","v":0},{"$f":" U$124","v":0},{"$f":" V$124","v":0}]
[null,null,null,null,{"$f":" E$125","v":"Residential retail revenue adjustment - EAC factor adjusted"},0,{"$f":" G$125","v":"£m"},{"$f":" H$125","v":3.6681597917169784},{"$f":" I$125","v":0},{"$f":" J$125","v":0},{"$f":" K$125","v":0},{"$f":" L$125","v":0},{"$f":" M$125","v":0},{"$f":" N$125","v":0},{"$f":" O$125","v":0},{"$f":" P$125","v":0},{"$f":" Q$125","v":0},{"$f":" R$125","v":0.73363195834339567},{"$f":" S$125","v":0.73363195834339567},{"$f":" T$125","v":0.73363195834339567},{"$f":" U$125","v":0.73363195834339567},{"$f":" V$125","v":0.73363195834339567}]
[null,null,null,null,{"$f":" E$126","v":"Business retail revenue adjustment - EAC factor adjusted"},{"$f":" F$126","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Water resources"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$29","v":"PV discount factor - Water network"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$30","v":"PV discount factor - Bioresources"},{"$f":" F$30","v":0},"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$31","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$32","v":"PV discount factor - Dummy control"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$33","v":"PV discount factor - Residential retail"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$34","v":"PV discount factor - Business retail"},{"$f":" F$34","v":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(J144:V144)","v":0},null,{"$f":" J128 * J136","v":0},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",1.0444409106407593,null,{"$f":" J129 * J137","v":0},0,0,0,0,0,0,0,0.22267503234594238,0.21556150275502653,0.20867522047921255,0.20199095778533049,0.19553819727524732]
[null,null,null,null,"Bioresources revenue adjustment - Constant annuity 2015-20",null,"£m",0,null,{"$f":" J130 * J138","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":" J131 * J139","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment - Constant annuity 2015-20",null,"£m",{"$f":" SUM(J148:V148)","v":0},null,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",3.4410469039786,null,{"$f":" J133 * J141","v":0},0,0,0,0,0,0,0,0.73363195834339567,0.71019550662477804,0.68750775084683269,0.66548557494982419,0.64422611321376977]
[null,null,null,null,"Business retail revenue adjustment - Constant annuity 2015-20",null,"£m",0,null,{"$f":" J134 * J142","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$181","v":"Water resources revenue adjustment"},{"$f":" Calc!F$181","v":0},{"$f":" Calc!G$181","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$191","v":"Water network plus revenue adjustment"},{"$f":" Calc!F$191","v":1.0444409106407593},{"$f":" Calc!G$191","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$196","v":"Bioresources revenue adjustment"},{"$f":" Calc!F$196","v":0},{"$f":" Calc!G$196","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$204","v":"Wastewater network plus revenue adjustment"},{"$f":" Calc!F$204","v":0},{"$f":" Calc!G$204","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$208","v":"Dummy control revenue adjustment"},{"$f":" Calc!F$208","v":0},{"$f":" Calc!G$208","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$215","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$215","v":3.4410469039786005},{"$f":" Calc!G$215","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$220","v":"Business retail revenue adjustment"},{"$f":" Calc!F$220","v":0},{"$f":" Calc!G$220","v":"£m"}]
[]
[null,null,null,null,{"$f":" Inputs!E$135","v":"Discount rate - Water resources"},{"$f":" Inputs!F$135","v":3.3000000000000002E-2},{"$f":" Inputs!G$135","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$136","v":"Discount rate - Water network plus"},{"$f":" Inputs!F$136","v":3.3000000000000002E-2},{"$f":" Inputs!G$136","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$137","v":"Discount rate - Bioresources"},{"$f":" Inputs!F$137","v":0},{"$f":" Inputs!G$137","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$138","v":"Discount rate - Wastewater network plus"},{"$f":" Inputs!F$138","v":0},{"$f":" Inputs!G$138","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$139","v":"Discount rate - Dummy control"},{"$f":" Inputs!F$139","v":0},{"$f":" Inputs!G$139","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$140","v":"Discount rate - Residential retail"},{"$f":" Inputs!F$140","v":3.3000000000000002E-2},{"$f":" Inputs!G$140","v":"%"}]
[null,null,null,null,{"$f":" Inputs!E$141","v":"Discount rate - Business retail"},{"$f":" Inputs!F$141","v":0},{"$f":" Inputs!G$141","v":"%"}]
[]
[null,null,null,null,{"$f":" Inputs!E$143","v":"Number of years to profile over"},{"$f":" Inputs!F$143","v":5},{"$f":" Inputs!G$143","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(J174:V174)","v":0},null,{"$f":" IF(J$171 + 1 <= $F$169 + 0.005, $F153 / $F$169, 0) * J$172 * (1 + $F161) ^ J$171","v":0},{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F153 / $F$169, 0) * K$172 * (1 + $F161) ^ K$171","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - NPV adjusted",null,"£m",1.1157282260570489,null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F154 / $F$169, 0) * K$172 * (1 + $F162) ^ K$171","v":0},0,0,0,0,0,0,0.20888818212815186,{"$f":" IF(S$171 + 1 <= $F$169 + 0.005, $F154 / $F$169, 0) * S$172 * (1 + $F162) ^ S$171","v":0.21578149213838085},0.22290228137894738,0.23027853930721542,0.23787773110435351]
[null,null,null,null,"Bioresources revenue adjustment - NPV adjusted",null,"£m",0,null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F155 / $F$169, 0) * K$172 * (1 + $F163) ^ K$171","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - NPV adjusted",null,"£m",0,null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F156 / $F$169, 0) * K$172 * (1 + $F164) ^ K$171","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment - NPV adjusted",null,"£m",{"$f":" SUM(J178:V178)","v":0},null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F157 / $F$169, 0) * K$172 * (1 + $F165) ^ K$171","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - NPV adjusted",null,"£m",3.6759122692731077,null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F158 / $F$169, 0) * K$172 * (1 + $F166) ^ K$171","v":0},0,0,0,0,0,0,0.68820938079572014,0.7109202903619789,0.73438065994392399,0.7586827044621175,0.78371923370936747]
[null,null,null,null,"Business retail revenue adjustment - NPV adjusted",null,"£m",0,null,0,{"$f":" IF(K$171 + 1 <= $F$169 + 0.005, $F159 / $F$169, 0) * K$172 * (1 + $F167) ^ K$171","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$174","v":"Water resources revenue adjustment - NPV adjusted"},0,{"$f":" G$174","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$175","v":"Water network revenue adjustment - NPV adjusted"},0,{"$f":" G$175","v":"£m"},1.1157282260570489,0,0,0,0,0,0,0,0,0,{"$f":" R$175","v":0.20888818212815186},{"$f":" S$175","v":0.21578149213838085},0.22290228137894738,0.23027853930721542,0.23787773110435351]
[null,null,null,null,{"$f":" E$176","v":"Bioresources revenue adjustment - NPV adjusted"},{"$f":" F$176","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$177","v":"Wastewater network revenue adjustment - NPV adjusted"},{"$f":" F$177","v":0},{"$f":" G$177","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$178","v":"Dummy control revenue adjustment - NPV adjusted"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$179","v":"Residential retail revenue adjustment - NPV adjusted"},0,{"$f":" G$179","v":"£m"},3.6759122692731077,0,0,0,0,0,0,0,0,0,0.68820938079572014,0.7109202903619789,0.73438065994392399,0.7586827044621175,0.78371923370936747]
[null,null,null,null,{"$f":" E$180","v":"Business retail revenue adjustment - NPV adjusted"},{"$f":" F$180","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$28","v":"PV discount factor - Water resources"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$29","v":"PV discount factor - Water network"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$30","v":"PV discount factor - Bioresources"},{"$f":" F$30","v":0},"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$31","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$32","v":"PV discount factor - Dummy control"},0,"factor",5,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$33","v":"PV discount factor - Residential retail"},0,"factor",4.6904266708184057,0,0,0,0,0,0,0,0,0,1,0.96805421103581812,0.93712895550418029,0.90711093945872823,0.87813256481967883]
[null,null,null,null,{"$f":" E$34","v":"PV discount factor - Business retail"},{"$f":" F$34","v":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(J198:V198)","v":0},null,{"$f":" J182 * J190","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment - Even allocation - NPV neutral",null,"£m",1.0444409106407593,null,{"$f":" J183 * J191","v":0},0,0,0,0,0,0,0,0.20888818212815186,0.20888818212815186,0.20888818212815186,0.20888818212815186,0.20888818212815183]
[null,null,null,null,"Bioresources revenue adjustment - Even allocation - NPV neutral",null,"£m",0,null,{"$f":" J184 * J192","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment - Even allocation - NPV neutral",null,"£m",0,null,{"$f":" J185 * J193","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment - Even allocation - NPV neutral",null,"£m",{"$f":" SUM(J202:V202)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment - Even allocation - NPV neutral",null,"£m",3.4410469039786005,null,{"$f":" J187 * J195","v":0},0,0,0,0,0,0,0,0.68820938079572014,0.68820938079572025,0.68820938079572014,0.68820938079572003,0.68820938079572014]
[null,null,null,null,"Business retail revenue adjustment - Even allocation - NPV neutral",null,"£m",0,null,{"$f":" J188 * J196","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["PROFILES SELECTION"]
[]
[null,null,null,null,{"$f":" Inputs!E$147","v":"Water resources revenue adjustment selector"},{"$f":" Inputs!F$147","v":0},{"$f":" Inputs!G$147","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$148","v":"Water network plus revenue adjustment selector"},{"$f":" Inputs!F$148","v":2},{"$f":" Inputs!G$148","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$149","v":"Bioesources revenue adjustment selector"},{"$f":" Inputs!F$149","v":0},{"$f":" Inputs!G$149","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$150","v":"Wastewater network plus revenue adjustment selector"},{"$f":" Inputs!F$150","v":0},{"$f":" Inputs!G$150","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$151","v":"Dummy control revenue adjustment selector"},{"$f":" Inputs!F$151","v":0},{"$f":" Inputs!G$151","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$152","v":"Residential retail revenue adjustment selector"},{"$f":" Inputs!F$152","v":2},{"$f":" Inputs!G$152","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[null,null,null,null,{"$f":" Inputs!E$153","v":"Business retail revenue adjustment selector"},{"$f":" Inputs!F$153","v":0},{"$f":" Inputs!G$153","v":"0 = Apply in first year, 1 = Constant annuity 2020-25, 2 = Even allocation - NPV neutral"}]
[]
[null,null,null,null,{"$f":" E$93","v":"Water resources revenue adjustment applied in first year"},0,{"$f":" G$93","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$94","v":"Water network revenue adjustment applied in first year"},0,{"$f":" G$94","v":"£m"},1.0444409106407593,0,0,0,0,0,0,0,0,0,1.0444409106407593,0,0,0,0]
[null,null,null,null,{"$f":" E$95","v":"Bioresources revenue adjustment applied in first year"},{"$f":" F$95","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$96","v":"Wastewater network revenue adjustment applied in first year"},0,{"$f":" G$96","v":"£m"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$97","v":"Dummy control revenue adjustment applied in first year"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$98","v":"Residential retail revenue adjustment applied in first year"},0,{"$f":" G$98","v":"£m"},3.4410469039786005,0,0,0,0,0,0,0,0,0,3.4410469039786005,0,0,0,0]
[null,null,null,null,{"$f":" E$99","v":"Business retail revenue adjustment applied in first year"},{"$f":" F$99","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$128","v":"Water resources revenue adjustment - EAC factor adjusted"},{"$f":" F$128","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$129","v":"Water network revenue adjustment - EAC factor adjusted"},{"$f":" F$129","v":0},"£m",1.1133751617297118,0,0,0,0,0,0,0,0,0,0.22267503234594238,0.22267503234594238,0.22267503234594238,0.22267503234594238,0.22267503234594238]
[null,null,null,null,{"$f":" E$130","v":"Bioresources revenue adjustment - EAC factor adjusted"},{"$f":" F$130","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$131","v":"Wastewater network revenue adjustment - EAC factor adjusted"},{"$f":" F$131","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$132","v":"Dummy control revenue adjustment - EAC factor adjusted"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$133","v":"Residential retail revenue adjustment - EAC factor adjusted"},{"$f":" F$133","v":0},"£m",3.6681597917169784,0,0,0,0,0,0,0,0,0,0.73363195834339567,0.73363195834339567,0.73363195834339567,0.73363195834339567,0.73363195834339567]
[null,null,null,null,{"$f":" E$134","v":"Business retail revenue adjustment - EAC factor adjusted"},{"$f":" F$134","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$182","v":"Water resources revenue adjustment - NPV adjusted"},{"$f":" F$182","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$183","v":"Water network revenue adjustment - NPV adjusted"},{"$f":" F$183","v":0},"£m",1.1157282260570489,0,0,0,0,0,0,0,0,0,{"$f":" R$183","v":0.20888818212815186},0.21578149213838085,0.22290228137894738,0.23027853930721542,0.23787773110435351]
[null,null,null,null,{"$f":" E$184","v":"Bioresources revenue adjustment - NPV adjusted"},{"$f":" F$184","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$185","v":"Wastewater network revenue adjustment - NPV adjusted"},{"$f":" F$185","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$186","v":"Dummy control revenue adjustment - NPV adjusted"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$187","v":"Residential retail revenue adjustment - NPV adjusted"},{"$f":" F$187","v":0},"£m",3.6759122692731077,0,0,0,0,0,0,0,0,0,0.68820938079572014,0.7109202903619789,0.73438065994392399,0.7586827044621175,0.78371923370936747]
[null,null,null,null,{"$f":" E$188","v":"Business retail revenue adjustment - NPV adjusted"},{"$f":" F$188","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Water resources revenue adjustment active",null,"£m",{"$f":" SUM(J241:V241)","v":0},null,{"$f":" IF($F209 = 0, J217, IF($F209 = 1, J225, J233))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water network revenue adjustment active",null,"£m",{"$f":" SUM(J242:V242)","v":1.1157282260570489},null,{"$f":" IF($F210 = 0, J218, IF($F210 = 1, J226, J234))","v":0},0,0,0,0,0,0,0,{"$f":" IF($F210 = 0, R218, IF($F210 = 1, R226, R234))","v":0.20888818212815186},0.21578149213838085,0.22290228137894738,0.23027853930721542,0.23787773110435351]
[null,null,null,null,"Bioresources revenue adjustment active",null,"£m",0,null,{"$f":" IF($F211 = 0, J219, IF($F211 = 1, J227, J235))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Wastewater network revenue adjustment active",null,"£m",0,null,{"$f":" IF($F212 = 0, J220, IF($F212 = 1, J228, J236))","v":0},0,0,0,0,0,0,{"$f":" IF($F212 = 0, Q220, IF($F212 = 1, Q228, Q236))","v":0},0,0,0,0,0]
[null,null,null,null,"Dummy control revenue adjustment active",null,"£m",{"$f":" SUM(J245:V245)","v":0},null,{"$f":" IF($F213 = 0, J221, IF($F213 = 1, J229, J237))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Residential retail revenue adjustment active",null,"£m",3.6759122692731077,null,{"$f":" IF($F214 = 0, J222, IF($F214 = 1, J230, J238))","v":0},{"$f":" IF($F214 = 0, K222, IF($F214 = 1, K230, K238))","v":0},0,0,0,0,0,0,0.68820938079572014,0.7109202903619789,0.73438065994392399,0.7586827044621175,0.78371923370936747]
[null,null,null,null,"Business retail revenue adjustment active",null,"£m",0,null,{"$f":" IF($F215 = 0, J223, IF($F215 = 1, J231, J239))","v":0},{"$f":" IF($F215 = 0, K223, IF($F215 = 1, K231, K239))","v":0},0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Summary_Output","index":8,"n_rows":75,"n_cols":22,"rows_kept":75,"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}]
[]
["PR14 REVENUE RECONCILIATION ADJUSTMENTS EXPRESSED IN 2017/18 FYA CPIH DEFLATED PRICE BASE BY TABLE"]
[]
[null,"Table App25"]
[null,null,null,null,{"$f":" Calc!E$151","v":"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$151","v":-6.2636856665115231E-2},{"$f":" Calc!G$151","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$160","v":"Further 2010-15 reconciliation total adjustment revenue carry forward to PR19 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$160","v":0},{"$f":" Calc!G$160","v":"£m"}]
[]
[null,"Table App27"]
[null,null,null,null,{"$f":" Calc!E$147","v":"ODI in-period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$147","v":0},{"$f":" Calc!G$147","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$152","v":"ODI in-period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$152","v":0},{"$f":" Calc!G$152","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$158","v":"ODI in-period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$158","v":0},{"$f":" Calc!G$158","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$161","v":"ODI in-period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$161","v":0},{"$f":" Calc!G$161","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$166","v":"ODI in-period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$166","v":0},{"$f":" Calc!G$166","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$170","v":"ODI in-period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$170","v":0},{"$f":" Calc!G$170","v":"£m"}]
[]
[null,null,null,null,{"$f":" Calc!E$148","v":"ODI end of period revenue adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$148","v":0},{"$f":" Calc!G$148","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$153","v":"ODI end of period revenue adjustment ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$153","v":3.3521975910438222},{"$f":" Calc!G$153","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$159","v":"ODI end of period revenue adjustment ~ Bioresources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$159","v":0},{"$f":" Calc!G$159","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$162","v":"ODI end of period revenue adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$162","v":0},{"$f":" Calc!G$162","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$167","v":"ODI end of period revenue adjustment ~ Residential retail at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$167","v":0},{"$f":" Calc!G$167","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$171","v":"ODI end of period revenue adjustment ~ Business retail at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$171","v":0},{"$f":" Calc!G$171","v":"£m"}]
[]
[null,"Table WS13"]
[null,null,null,null,{"$f":" Calc!E$157","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$157","v":-1.8834125261802759},{"$f":" Calc!G$157","v":"£m"}]
[]
[null,"Table WS15"]
[null,null,null,null,{"$f":" Calc!E$154","v":"Water: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$154","v":-0.36170729755767189},{"$f":" Calc!G$154","v":"£m"}]
[]
[null,"Table WS17"]
[null,null,null,null,{"$f":" Calc!E$149","v":"Water trading total value of export incentive ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$149","v":0},{"$f":" Calc!G$149","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$155","v":"Water trading total value of export incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$155","v":0},{"$f":" Calc!G$155","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$150","v":"Water trading total value of import incentive ~ Water resources  at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$150","v":0},{"$f":" Calc!G$150","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$156","v":"Water trading total value of import incentive ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$156","v":0},{"$f":" Calc!G$156","v":"£m"}]
[]
[null,"Table WWS13"]
[null,null,null,null,{"$f":" Calc!E$164","v":"WRFIM total reward / (penalty) at the end of AMP6 ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$164","v":0},{"$f":" Calc!G$164","v":"£m"}]
[]
[null,"Table WWS15"]
[null,null,null,null,{"$f":" Calc!E$163","v":"Wastewater: Totex menu revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$163","v":0},{"$f":" Calc!G$163","v":"£m"}]
[]
[null,"Table Dmmy10"]
[null,null,null,null,{"$f":" Calc!E$165","v":"Dummy: revenue adjustment from totex menu model at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$165","v":0},{"$f":" Calc!G$165","v":"£m"}]
[]
[null,"Table R9"]
[null,null,null,null,{"$f":" Calc!E$168","v":"Residential retail revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$168","v":1.0019569124159429},{"$f":" Calc!G$168","v":"£m"}]
[]
[null,"Table R10"]
[null,null,null,null,{"$f":" Calc!E$169","v":"SIM forecast revenue adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$169","v":2.4390899915626578},{"$f":" Calc!G$169","v":"£m"}]
[]
[]
["SUBTOTALS AS PER PRICE CONTROL FOR REVENUE ADJUSTMENTS"]
[]
[null,null,null,null,{"$f":" Calc!E$181","v":"Water resources revenue adjustment"},{"$f":" Calc!F$181","v":0},{"$f":" Calc!G$181","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$191","v":"Water network plus revenue adjustment"},{"$f":" Calc!F$191","v":1.0444409106407593},{"$f":" Calc!G$191","v":"£m"}]
[null,null,null,null,{"$f":"Calc!E196","v":"Bioresources revenue adjustment"},{"$f":"Calc!F196","v":0},{"$f":"Calc!G196","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$204","v":"Wastewater network plus revenue adjustment"},{"$f":" Calc!F$204","v":0},{"$f":" Calc!G$204","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$208","v":"Dummy control revenue adjustment"},{"$f":" Calc!F$208","v":0},{"$f":" Calc!G$208","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$215","v":"Residential retail revenue adjustment"},{"$f":" Calc!F$215","v":3.4410469039786005},{"$f":" Calc!G$215","v":"£m"}]
[null,null,null,null,{"$f":" Calc!E$220","v":"Business retail revenue adjustment"},{"$f":" Calc!F$220","v":0},{"$f":" Calc!G$220","v":"£m"}]
[]
[]
["PROFILES SELECTED"]
[]
[null,null,null,null,{"$f":" Profiling!E$241","v":"Water resources revenue adjustment active"},{"$f":" Profiling!F$241","v":0},{"$f":" Profiling!G$241","v":"£m"},{"$f":" Profiling!H$241","v":0},{"$f":" Profiling!I$241","v":0},{"$f":" Profiling!J$241","v":0},{"$f":" Profiling!K$241","v":0},{"$f":" Profiling!L$241","v":0},{"$f":" Profiling!M$241","v":0},{"$f":" Profiling!N$241","v":0},{"$f":" Profiling!O$241","v":0},{"$f":" Profiling!P$241","v":0},{"$f":" Profiling!Q$241","v":0},{"$f":" Profiling!R$241","v":0},{"$f":" Profiling!S$241","v":0},{"$f":" Profiling!T$241","v":0},{"$f":" Profiling!U$241","v":0},{"$f":" Profiling!V$241","v":0}]
[null,null,null,null,{"$f":" Profiling!E$242","v":"Water network revenue adjustment active"},{"$f":" Profiling!F$242","v":0},{"$f":" Profiling!G$242","v":"£m"},{"$f":" Profiling!H$242","v":1.1157282260570489},{"$f":" Profiling!I$242","v":0},{"$f":" Profiling!J$242","v":0},{"$f":" Profiling!K$242","v":0},{"$f":" Profiling!L$242","v":0},{"$f":" Profiling!M$242","v":0},{"$f":" Profiling!N$242","v":0},{"$f":" Profiling!O$242","v":0},{"$f":" Profiling!P$242","v":0},{"$f":" Profiling!Q$242","v":0},{"$f":" Profiling!R$242","v":0.20888818212815186},{"$f":" Profiling!S$242","v":0.21578149213838085},{"$f":" Profiling!T$242","v":0.22290228137894738},{"$f":" Profiling!U$242","v":0.23027853930721542},{"$f":" Profiling!V$242","v":0.23787773110435351}]
[null,null,null,null,{"$f":" Profiling!E$243","v":"Bioresources revenue adjustment active"},{"$f":" Profiling!F$243","v":0},{"$f":" Profiling!G$243","v":"£m"},{"$f":" Profiling!H$243","v":0},{"$f":" Profiling!I$243","v":0},{"$f":" Profiling!J$243","v":0},{"$f":" Profiling!K$243","v":0},{"$f":" Profiling!L$243","v":0},{"$f":" Profiling!M$243","v":0},{"$f":" Profiling!N$243","v":0},{"$f":" Profiling!O$243","v":0},{"$f":" Profiling!P$243","v":0},{"$f":" Profiling!Q$243","v":0},{"$f":" Profiling!R$243","v":0},{"$f":" Profiling!S$243","v":0},{"$f":" Profiling!T$243","v":0},{"$f":" Profiling!U$243","v":0},{"$f":" Profiling!V$243","v":0}]
[null,null,null,null,{"$f":" Profiling!E$244","v":"Wastewater network revenue adjustment active"},{"$f":" Profiling!F$244","v":0},{"$f":" Profiling!G$244","v":"£m"},{"$f":" Profiling!H$244","v":0},{"$f":" Profiling!I$244","v":0},{"$f":" Profiling!J$244","v":0},{"$f":" Profiling!K$244","v":0},{"$f":" Profiling!L$244","v":0},{"$f":" Profiling!M$244","v":0},{"$f":" Profiling!N$244","v":0},{"$f":" Profiling!O$244","v":0},{"$f":" Profiling!P$244","v":0},{"$f":" Profiling!Q$244","v":0},{"$f":" Profiling!R$244","v":0},{"$f":" Profiling!S$244","v":0},{"$f":" Profiling!T$244","v":0},{"$f":" Profiling!U$244","v":0},{"$f":" Profiling!V$244","v":0}]
[null,null,null,null,{"$f":" Profiling!E$245","v":"Dummy control revenue adjustment active"},{"$f":" Profiling!F$245","v":0},{"$f":" Profiling!G$245","v":"£m"},{"$f":" Profiling!H$245","v":0},{"$f":" Profiling!I$245","v":0},{"$f":" Profiling!J$245","v":0},{"$f":" Profiling!K$245","v":0},{"$f":" Profiling!L$245","v":0},{"$f":" Profiling!M$245","v":0},{"$f":" Profiling!N$245","v":0},{"$f":" Profiling!O$245","v":0},{"$f":" Profiling!P$245","v":0},{"$f":" Profiling!Q$245","v":0},{"$f":" Profiling!R$245","v":0},{"$f":" Profiling!S$245","v":0},{"$f":" Profiling!T$245","v":0},{"$f":" Profiling!U$245","v":0},{"$f":" Profiling!V$245","v":0}]
[null,null,null,null,{"$f":" Profiling!E$246","v":"Residential retail revenue adjustment active"},{"$f":" Profiling!F$246","v":0},{"$f":" Profiling!G$246","v":"£m"},{"$f":" Profiling!H$246","v":3.6759122692731077},{"$f":" Profiling!I$246","v":0},{"$f":" Profiling!J$246","v":0},{"$f":" Profiling!K$246","v":0},{"$f":" Profiling!L$246","v":0},{"$f":" Profiling!M$246","v":0},{"$f":" Profiling!N$246","v":0},{"$f":" Profiling!O$246","v":0},{"$f":" Profiling!P$246","v":0},{"$f":" Profiling!Q$246","v":0},{"$f":" Profiling!R$246","v":0.68820938079572014},{"$f":" Profiling!S$246","v":0.7109202903619789},{"$f":" Profiling!T$246","v":0.73438065994392399},{"$f":" Profiling!U$246","v":0.7586827044621175},{"$f":" Profiling!V$246","v":0.78371923370936747}]
[null,null,null,null,{"$f":" Profiling!E$247","v":"Business retail revenue adjustment active"},{"$f":" Profiling!F$247","v":0},{"$f":" Profiling!G$247","v":"£m"},{"$f":" Profiling!H$247","v":0},{"$f":" Profiling!I$247","v":0},{"$f":" Profiling!J$247","v":0},{"$f":" Profiling!K$247","v":0},{"$f":" Profiling!L$247","v":0},{"$f":" Profiling!M$247","v":0},{"$f":" Profiling!N$247","v":0},{"$f":" Profiling!O$247","v":0},{"$f":" Profiling!P$247","v":0},{"$f":" Profiling!Q$247","v":0},{"$f":" Profiling!R$247","v":0},{"$f":" Profiling!S$247","v":0},{"$f":" Profiling!T$247","v":0},{"$f":" Profiling!U$247","v":0},{"$f":" Profiling!V$247","v":0}]