{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover","Change Log","Map & Key","F_Inputs","Inputs","Time","Indexation","Calc","Summary_Output","F_Outputs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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 RCV adjustments feeder model"]
[null,null,"Version number:","01s - July 2018 update"]
[null,null,"Filename:",{"$f":" \"PR19 RCV adjustments feeder model \" & D4 & \".xlsm\"","v":"PR19 RCV adjustments feeder model 01s - July 2018 update.xlsm"}]
[null,null,"Date:","2018-07-04"]
[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 RCV adjustment outputs from the PR09 and PR14 reconciliations and convert them for use in the PR19 financial model in"]
[null,null,null,"line 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 RCV 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":13,"n_cols":6,"rows_kept":13,"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",102]
["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\nSummary_Output"]
["2017-12-01",3,"Some business plan tables require RCV items in 2017-18 FYE (financial year end) CPIH deflated price base.  ","Add 2017-18 FYE CPIH deflation factor","Indexation",105]
["2017-12-01",4,"Some business plan tables require RCV items in 2017-18 FYE (financial year end) CPIH deflated price base.  ","Add the 2017-18 FYE CPIH deflated items to the Calc and Summary_Output sheet","Calc\nSummary_Output"]
["2018-06-01",5,"Line descriptions for the CIS RCV inflation correction items are not consistent with business plan tables.","Item labels have been aligned with the business plan tables App8 and App25.","Inputs\nCalc\nSummary_Output"]
["2018-06-01",6,"IN 18/09 Guidance for reporting operating leases in PR19 business plans.\nThe RCV adjustment calculated for each wholesale control in business plan table App33 flows to business plan table App8. The RCV adjustments feeder model has been updated to reflect the revisions to table App8.","Include the new IFRS16 related RCV adjustments in the calculation of the opening balances for the 2020 RCV RPI inflated and 2020 RCV CPIH inflated RCV.","Inputs\nIndexation\nCalc\nSummary_Output"]
["2018-06-01",7,"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 Dmmy10 RCV adjustment in the calculation of the opening balances for the dummy price control 2020 RCV RPI inflated and 2020 RCV CPIH inflated RCV.","Inputs\nCalc\nSummary_Output"]
["2018-06-01",8,"Change email address","Changed from water2020 mailbox to PR19 mailbox","Cover"]
["2018-07-01",9,"In response to a query the Ofwat feeder model has been updated to reflect additional block for the dummy control in table App9 and an additional line for the dummy control in table App8.","Include the additional RCV adjustments for the dummy control in the calculation of the opening balances for the dummy price control 2020 RCV RPI inflated and 2020 RCV CPIH inflated RCV.","Inputs\nCalc\nSummary_Output"]

{"sheet":"Map & Key","index":2,"n_rows":121,"n_cols":22,"rows_kept":121,"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."]
[]
[]
[]
[]
["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":"F_Inputs","index":3,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19PD010_IN"]
["Acronym","Reference","Item description","Unit","Model","Price Review 2019"]
[]
[null,null,null,null,null,"PR19 RUN 1: early view of past delivery"]
[null,null,null,null,null,"Latest"]
[null,null,null,null,null,"2011-12","2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2015-20","2014-20","PR19 application"]
["ANH","BB3905AL","Consumer Price Index (with housing) for April","nr","Price Review 2019",93.3,95.9,98,99.6,99.9,100.6,103.2,105.6768,107.89601279999999,110.05393305600001]
["ANH","BB3905MY","Consumer Price Index (with housing) for May","nr","Price Review 2019",93.5,95.9,98.2,99.6,100.1,100.8,103.5,105.98399999999999,108.209664,110.37385728]
["ANH","BB3905JN","Consumer Price Index (with housing) for June","nr","Price Review 2019",93.5,95.6,98,99.8,100.1,101,103.5,105.98399999999999,108.209664,110.37385728]
["ANH","BB3905JL","Consumer Price Index (with housing) for July","nr","Price Review 2019",93.5,95.7,98,99.6,100,100.9,103.5,105.98399999999999,108.209664,110.37385728]
["ANH","BB3905AT","Consumer Price Index (with housing) for August","nr","Price Review 2019",93.9,96.1,98.4,99.9,100.3,101.2,104,106.496,108.732416,110.90706432]
["ANH","BB3905SR","Consumer Price Index (with housing) for September","nr","Price Review 2019",94.5,96.4,98.7,100,100.2,101.5,104.3,106.8032,109.0460672,111.22698854399999]
["ANH","BB3905OR","Consumer Price Index (with housing) for October","nr","Price Review 2019",94.5,96.8,98.8,100.1,100.3,101.6,104.4,106.90560000000001,109.1506176,111.333629952]
["ANH","BB3905NR","Consumer Price Index (with housing) for November","nr","Price Review 2019",94.7,97,98.8,99.9,100.3,101.8,104.7,107.2128,109.4642688,111.653554176]
["ANH","BB3905DR","Consumer Price Index (with housing) for December","nr","Price Review 2019",95,97.3,99.2,99.9,100.4,102.2,105,107.52,109.77791999999999,111.9734784]
["ANH","BB3905JY","Consumer Price Index (with housing) for January","nr","Price Review 2019",94.7,97,98.7,99.2,99.9,101.8,104.5,107.008,109.255168,111.44027136]
["ANH","BB3905FY","Consumer Price Index (with housing) for February","nr","Price Review 2019",95.2,97.5,99.1,99.5,100.1,102.4,104.9,107.41759999999999,109.6733696,111.866836992]
["ANH","BB3905MH","Consumer Price Index (with housing) for March","nr","Price Review 2019",95.4,97.8,99.3,99.6,100.4,102.7,105.1,107.6224,109.8824704,112.08011980800001]
["ANH","BB3805AL","Retail Price Index for April","nr","Price Review 2019",234.4,242.5,249.5,255.7,258,261.39999999999998,270.60000000000002,279.80040000000002,288.4742124,297.12843877199998]
["ANH","BB3805MY","Retail Price Index for May","nr","Price Review 2019",235.2,242.4,250,255.9,258.5,262.10000000000002,271.7,280.93779999999998,289.64687179999999,298.33627795400002]
["ANH","BB3805JN","Retail Price Index for June","nr","Price Review 2019",235.2,241.8,249.7,256.3,258.89999999999998,263.10000000000002,272.3,281.5582,290.28650420000002,298.995099326]
["ANH","BB3805JL","Retail Price Index for July","nr","Price Review 2019",234.7,242.1,249.7,256,258.60000000000002,263.39999999999998,272.89999999999998,282.17860000000002,290.92613660000001,299.65392069799998]
["ANH","BB3805AT","Retail Price Index for August","nr","Price Review 2019",236.1,243,251,257,259.8,264.39999999999998,274.7,284.03980000000001,292.84503380000001,301.63038481400002]
["ANH","BB3805SR","Retail Price Index for September","nr","Price Review 2019",237.9,244.2,251.9,257.60000000000002,259.60000000000002,264.89999999999998,275.10000000000002,284.45339999999999,293.27145539999998,302.06959906200001]
["ANH","BB3805OR","Retail Price Index for October","nr","Price Review 2019",238,245.6,251.9,257.7,259.5,264.8,275.3,284.66019999999997,293.48466619999999,302.289206186]
["ANH","BB3805NR","Retail Price Index for November","nr","Price Review 2019",238.5,245.6,252.1,257.10000000000002,259.8,265.5,275.8,285.17720000000003,294.0176932,302.83822399600001]
["ANH","BB3805DR","Retail Price Index for December","nr","Price Review 2019",239.4,246.8,253.4,257.5,260.60000000000002,267.10000000000002,278.10000000000002,287.55540000000002,296.4696174,305.36370592200001]
["ANH","BB3805JY","Retail Price Index for January","nr","Price Review 2019",238,245.8,252.6,255.4,258.8,265.5,276,285.38400000000001,294.23090400000001,303.05783112]
["ANH","BB3805FY","Retail Price Index for February","nr","Price Review 2019",239.9,247.6,254.2,256.7,260,268.39999999999998,278.10000000000002,287.55540000000002,296.4696174,305.36370592200001]
["ANH","BB3805MH","Retail Price Index for March","nr","Price Review 2019",240.8,248.7,254.8,257.10000000000002,261.10000000000002,269.3,278.3,287.76220000000001,296.68282820000002,305.583313046]
["ANH","APP8001W","RCV year end balances - Water RCV closing balance at 31 March 2020 - Wholesale water closing RCV at 31 March 2020 in 2012-13 prices (from PR14 FD)","£m","Price Review 2019"]
["ANH","C00572_L021","Water - Total Adjustment RCV carry forward to PR19","£m","Price Review 2019",null,null,null,null,null,null,null,null,null,null,-24.537663716038399]
["ANH","APP25001","Further 2010-15 reconciliation adjustments - Water ~ CIS RCV inflation correction","£m","Price Review 2019",null,null,null,null,null,null,null,null,null,null,-50.617858314809197]
["ANH","C_APP27029_PD002","Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources","£m","Price Review 2019",null,null,null,null,0,0,0,0,0,null,null,null,0]
["ANH","C_APP27030_PD002","Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus","£m","Price Review 2019",null,null,null,null,0,0,0,0,0,null,null,null,0]
["ANH","C_WS15025_PR19PD006","Water: RCV adjustment from totex menu model","£m","Price Review 2019",null,null,null,null,null,null,null,null,-6.70997690351843]
["ANH","APP8009W","RCV year end balances - Water RCV closing balance at 31 March 2020 - Water ~ Other adjustment to wholesale RCV","£m","Price Review 2019"]
["ANH","C_A7010W_PR19PD003","NPV effect of 50% of proceeds from disposals of interest in land","£m","Price Review 2019",null,null,null,null,null,null,null,null,-0.81388923564452698]
["ANH","WS12019WR","RCV ~ 31 March 2020 ( % of total wholesale water) - Water resources","%","Price Review 2019"]
["ANH","APP33021WR","Water resources - RCV adjustment","£m","Price Review 2019"]
["ANH","APP33021WNP","Water network plus - RCV adjustment","£m","Price Review 2019"]
["ANH","APP8001WW","RCV year end balances - Wastewater RCV closing balance at 31 March 2020 - Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD)","£m","Price Review 2019"]
["ANH","C00579_L021","Wastewater - Total Adjustment RCV carry forward to PR19","£m","Price Review 2019",null,null,null,null,null,null,null,null,null,null,-2.1581027567334399]
["ANH","APP25002","Further 2010-15 reconciliation adjustments - Wastewater ~ CIS RCV inflation correction","£m","Price Review 2019",null,null,null,null,null,null,null,null,null,null,-64.969383551380105]
["ANH","C_APP27031_PD002","Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus","£m","Price Review 2019",null,null,null,null,0,0,0,0,0,null,null,null,0]
["ANH","C_WWS15020_PR19PD006","Wastewater: RCV adjustment from totex menu model","£m","Price Review 2019",null,null,null,null,null,null,null,null,-131.30368479747401]
["ANH","APP8009WW","RCV year end balances - Wastewater RCV closing balance at 31 March 2020 - Wastewater ~ Other adjustment to wholesale RCV","£m","Price Review 2019"]
["ANH","C_A7010WW_PR19PD003","NPV effect of 50% of proceeds from disposals of interest in land","£m","Price Review 2019",null,null,null,null,null,null,null,null,-3.9736983822040299]
["ANH","WWS12016BIO","RCV split 31 March 2020 - RCV (prior to midnight adjustments) - Bioresources","£m","Price Review 2019"]
["ANH","APP33021BIO","Bioresources - RCV adjustment","£m","Price Review 2019"]
["ANH","APP33021WWNP","Wastewater network plus - RCV adjustment","£m","Price Review 2019"]
["ANH","RCV1011DMMY","RCV year end balances - Dummy RCV - Dummy RCV (prior to midnight adjustments) 31 March 2020","£m","Price Review 2019"]
["ANH","C_APP27032_PD002","Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway","£m","Price Review 2019",null,null,null,null,0,0,0,0,0,null,null,null,0]
["ANH","C_WWS15020_DMMY_PR19PD006","Wastewater: RCV adjustment from totex menu model (TTT)","£m","Price Review 2019"]
["ANH","APP8009DMMY","RCV year end balances - Dummy RCV - Dummy ~ Other adjustment to wholesale RCV","£m","Price Review 2019"]
["ANH","APP33021DMMY","Dummy - RCV adjustment","£m","Price Review 2019"]

{"sheet":"Inputs","index":4,"n_rows":140,"n_cols":21,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"FILENAME\", $A$1), LEN(CELL(\"FILENAME\", $A$1)) - SEARCH(\"]\", CELL(\"FILENAME\", $A$1)))","v":"Inputs"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[{"$f":" IF(COUNTIF(A6:A140,\"< 0\") + COUNTIF(A6:A140,\">0\") <> 0, 1, 0)","v":0},null,null,"Input references",{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[null,null,null,null,"[Used in formula range - Do not delete]"]
[]
["A: TIME"]
[]
[null,"Timeline setup"]
[]
[null,null,"Timeline start dates"]
["C001",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"]
["C002",null,null,null,"First modelling column financial year#",2013,"year #","Financial model start year"]
["C003",null,null,null,"Financial year end month number",3,"month #","Month of financial year end for financial model"]
[]
[null,null,"Timeline labels"]
["C004",null,null,null,"Pre - forecast period","Pre-Fcst","label"]
["C005",null,null,null,"Forecast period","Forecast","label"]
["C006",null,null,null,"Post - forecast period","Post-Fcst","label"]
[]
[null,"Project dates"]
[]
["C007",null,null,null,"Forecast start date","2020-04-01","date"]
["C008",null,null,null,"Forecast duration",5,"years"]
["C009",null,null,null,"Forecast duration (text)",{"$f":" YEAR(F26) & \"-\" & TEXT(DATE(YEAR(F26) + F27, 1, 1), \"yy\")","v":"2020-25"},"years #"]
[]
[]
["B: INDEXATION"]
[]
[null,"CPIH INDEXATION"]
[]
[{"$f":"F_Inputs!B7","v":"BB3905AL"},null,null,null,"Consumer Price Index for April",null,"index",null,null,{"$f":"F_Inputs!G7","v":95.9},{"$f":"F_Inputs!H7","v":98},{"$f":"F_Inputs!I7","v":99.6},{"$f":"F_Inputs!J7","v":99.9},{"$f":"F_Inputs!K7","v":100.6},{"$f":"F_Inputs!L7","v":103.2},{"$f":"F_Inputs!M7","v":105.6768},{"$f":"F_Inputs!N7","v":107.89601279999999}]
[{"$f":"F_Inputs!B8","v":"BB3905MY"},null,null,null,"Consumer Price Index for May",null,"index",null,null,{"$f":"F_Inputs!G8","v":95.9},{"$f":"F_Inputs!H8","v":98.2},{"$f":"F_Inputs!I8","v":99.6},{"$f":"F_Inputs!J8","v":100.1},{"$f":"F_Inputs!K8","v":100.8},{"$f":"F_Inputs!L8","v":103.5},{"$f":"F_Inputs!M8","v":105.98399999999999},{"$f":"F_Inputs!N8","v":108.209664}]
[{"$f":"F_Inputs!B9","v":"BB3905JN"},null,null,null,"Consumer Price Index for June",null,"index",null,null,{"$f":"F_Inputs!G9","v":95.6},{"$f":"F_Inputs!H9","v":98},{"$f":"F_Inputs!I9","v":99.8},{"$f":"F_Inputs!J9","v":100.1},{"$f":"F_Inputs!K9","v":101},{"$f":"F_Inputs!L9","v":103.5},{"$f":"F_Inputs!M9","v":105.98399999999999},{"$f":"F_Inputs!N9","v":108.209664}]
[{"$f":"F_Inputs!B10","v":"BB3905JL"},null,null,null,"Consumer Price Index for July",null,"index",null,null,{"$f":"F_Inputs!G10","v":95.7},{"$f":"F_Inputs!H10","v":98},{"$f":"F_Inputs!I10","v":99.6},{"$f":"F_Inputs!J10","v":100},{"$f":"F_Inputs!K10","v":100.9},{"$f":"F_Inputs!L10","v":103.5},{"$f":"F_Inputs!M10","v":105.98399999999999},{"$f":"F_Inputs!N10","v":108.209664}]
[{"$f":"F_Inputs!B11","v":"BB3905AT"},null,null,null,"Consumer Price Index for August",null,"index",null,null,{"$f":"F_Inputs!G11","v":96.1},{"$f":"F_Inputs!H11","v":98.4},{"$f":"F_Inputs!I11","v":99.9},{"$f":"F_Inputs!J11","v":100.3},{"$f":"F_Inputs!K11","v":101.2},{"$f":"F_Inputs!L11","v":104},{"$f":"F_Inputs!M11","v":106.496},{"$f":"F_Inputs!N11","v":108.732416}]
[{"$f":"F_Inputs!B12","v":"BB3905SR"},null,null,null,"Consumer Price Index for September",null,"index",null,null,{"$f":"F_Inputs!G12","v":96.4},{"$f":"F_Inputs!H12","v":98.7},{"$f":"F_Inputs!I12","v":100},{"$f":"F_Inputs!J12","v":100.2},{"$f":"F_Inputs!K12","v":101.5},{"$f":"F_Inputs!L12","v":104.3},{"$f":"F_Inputs!M12","v":106.8032},{"$f":"F_Inputs!N12","v":109.0460672}]
[{"$f":"F_Inputs!B13","v":"BB3905OR"},null,null,null,"Consumer Price Index for October",null,"index",null,null,{"$f":"F_Inputs!G13","v":96.8},{"$f":"F_Inputs!H13","v":98.8},{"$f":"F_Inputs!I13","v":100.1},{"$f":"F_Inputs!J13","v":100.3},{"$f":"F_Inputs!K13","v":101.6},{"$f":"F_Inputs!L13","v":104.4},{"$f":"F_Inputs!M13","v":106.90560000000001},{"$f":"F_Inputs!N13","v":109.1506176}]
[{"$f":"F_Inputs!B14","v":"BB3905NR"},null,null,null,"Consumer Price Index for November",null,"index",null,null,{"$f":"F_Inputs!G14","v":97},{"$f":"F_Inputs!H14","v":98.8},{"$f":"F_Inputs!I14","v":99.9},{"$f":"F_Inputs!J14","v":100.3},{"$f":"F_Inputs!K14","v":101.8},{"$f":"F_Inputs!L14","v":104.7},{"$f":"F_Inputs!M14","v":107.2128},{"$f":"F_Inputs!N14","v":109.4642688}]
[{"$f":"F_Inputs!B15","v":"BB3905DR"},null,null,null,"Consumer Price Index for December",null,"index",null,null,{"$f":"F_Inputs!G15","v":97.3},{"$f":"F_Inputs!H15","v":99.2},{"$f":"F_Inputs!I15","v":99.9},{"$f":"F_Inputs!J15","v":100.4},{"$f":"F_Inputs!K15","v":102.2},{"$f":"F_Inputs!L15","v":105},{"$f":"F_Inputs!M15","v":107.52},{"$f":"F_Inputs!N15","v":109.77791999999999}]
[{"$f":"F_Inputs!B16","v":"BB3905JY"},null,null,null,"Consumer Price Index for January",null,"index",null,null,{"$f":"F_Inputs!G16","v":97},{"$f":"F_Inputs!H16","v":98.7},{"$f":"F_Inputs!I16","v":99.2},{"$f":"F_Inputs!J16","v":99.9},{"$f":"F_Inputs!K16","v":101.8},{"$f":"F_Inputs!L16","v":104.5},{"$f":"F_Inputs!M16","v":107.008},{"$f":"F_Inputs!N16","v":109.255168}]
[{"$f":"F_Inputs!B17","v":"BB3905FY"},null,null,null,"Consumer Price Index for February",null,"index",null,null,{"$f":"F_Inputs!G17","v":97.5},{"$f":"F_Inputs!H17","v":99.1},{"$f":"F_Inputs!I17","v":99.5},{"$f":"F_Inputs!J17","v":100.1},{"$f":"F_Inputs!K17","v":102.4},{"$f":"F_Inputs!L17","v":104.9},{"$f":"F_Inputs!M17","v":107.41759999999999},{"$f":"F_Inputs!N17","v":109.6733696}]
[{"$f":"F_Inputs!B18","v":"BB3905MH"},null,null,null,"Consumer Price Index for March",null,"index",null,null,{"$f":"F_Inputs!G18","v":97.8},{"$f":"F_Inputs!H18","v":99.3},{"$f":"F_Inputs!I18","v":99.6},{"$f":"F_Inputs!J18","v":100.4},{"$f":"F_Inputs!K18","v":102.7},{"$f":"F_Inputs!L18","v":105.1},{"$f":"F_Inputs!M18","v":107.6224},{"$f":"F_Inputs!N18","v":109.8824704}]
[]
[null,null,null,null,"CPIH: Assumed percentage increase for unpopulated monthly values",null,"%"]
[]
[null,"RPI INDEXATION"]
[]
[{"$f":"F_Inputs!B19","v":"BB3805AL"},null,null,null,"Retail Price Index for April",null,"index",null,null,{"$f":"F_Inputs!G19","v":242.5},{"$f":"F_Inputs!H19","v":249.5},{"$f":"F_Inputs!I19","v":255.7},{"$f":"F_Inputs!J19","v":258},{"$f":"F_Inputs!K19","v":261.39999999999998},{"$f":"F_Inputs!L19","v":270.60000000000002},{"$f":"F_Inputs!M19","v":279.80040000000002},{"$f":"F_Inputs!N19","v":288.4742124}]
[{"$f":"F_Inputs!B20","v":"BB3805MY"},null,null,null,"Retail Price Index for May",null,"index",null,null,{"$f":"F_Inputs!G20","v":242.4},{"$f":"F_Inputs!H20","v":250},{"$f":"F_Inputs!I20","v":255.9},{"$f":"F_Inputs!J20","v":258.5},{"$f":"F_Inputs!K20","v":262.10000000000002},{"$f":"F_Inputs!L20","v":271.7},{"$f":"F_Inputs!M20","v":280.93779999999998},{"$f":"F_Inputs!N20","v":289.64687179999999}]
[{"$f":"F_Inputs!B21","v":"BB3805JN"},null,null,null,"Retail Price Index for June",null,"index",null,null,{"$f":"F_Inputs!G21","v":241.8},{"$f":"F_Inputs!H21","v":249.7},{"$f":"F_Inputs!I21","v":256.3},{"$f":"F_Inputs!J21","v":258.89999999999998},{"$f":"F_Inputs!K21","v":263.10000000000002},{"$f":"F_Inputs!L21","v":272.3},{"$f":"F_Inputs!M21","v":281.5582},{"$f":"F_Inputs!N21","v":290.28650420000002}]
[{"$f":"F_Inputs!B22","v":"BB3805JL"},null,null,null,"Retail Price Index for July",null,"index",null,null,{"$f":"F_Inputs!G22","v":242.1},{"$f":"F_Inputs!H22","v":249.7},{"$f":"F_Inputs!I22","v":256},{"$f":"F_Inputs!J22","v":258.60000000000002},{"$f":"F_Inputs!K22","v":263.39999999999998},{"$f":"F_Inputs!L22","v":272.89999999999998},{"$f":"F_Inputs!M22","v":282.17860000000002},{"$f":"F_Inputs!N22","v":290.92613660000001}]
[{"$f":"F_Inputs!B23","v":"BB3805AT"},null,null,null,"Retail Price Index for August",null,"index",null,null,{"$f":"F_Inputs!G23","v":243},{"$f":"F_Inputs!H23","v":251},{"$f":"F_Inputs!I23","v":257},{"$f":"F_Inputs!J23","v":259.8},{"$f":"F_Inputs!K23","v":264.39999999999998},{"$f":"F_Inputs!L23","v":274.7},{"$f":"F_Inputs!M23","v":284.03980000000001},{"$f":"F_Inputs!N23","v":292.84503380000001}]
[{"$f":"F_Inputs!B24","v":"BB3805SR"},null,null,null,"Retail Price Index for September",null,"index",null,null,{"$f":"F_Inputs!G24","v":244.2},{"$f":"F_Inputs!H24","v":251.9},{"$f":"F_Inputs!I24","v":257.60000000000002},{"$f":"F_Inputs!J24","v":259.60000000000002},{"$f":"F_Inputs!K24","v":264.89999999999998},{"$f":"F_Inputs!L24","v":275.10000000000002},{"$f":"F_Inputs!M24","v":284.45339999999999},{"$f":"F_Inputs!N24","v":293.27145539999998}]
[{"$f":"F_Inputs!B25","v":"BB3805OR"},null,null,null,"Retail Price Index for October",null,"index",null,null,{"$f":"F_Inputs!G25","v":245.6},{"$f":"F_Inputs!H25","v":251.9},{"$f":"F_Inputs!I25","v":257.7},{"$f":"F_Inputs!J25","v":259.5},{"$f":"F_Inputs!K25","v":264.8},{"$f":"F_Inputs!L25","v":275.3},{"$f":"F_Inputs!M25","v":284.66019999999997},{"$f":"F_Inputs!N25","v":293.48466619999999}]
[{"$f":"F_Inputs!B26","v":"BB3805NR"},null,null,null,"Retail Price Index for November",null,"index",null,null,{"$f":"F_Inputs!G26","v":245.6},{"$f":"F_Inputs!H26","v":252.1},{"$f":"F_Inputs!I26","v":257.10000000000002},{"$f":"F_Inputs!J26","v":259.8},{"$f":"F_Inputs!K26","v":265.5},{"$f":"F_Inputs!L26","v":275.8},{"$f":"F_Inputs!M26","v":285.17720000000003},{"$f":"F_Inputs!N26","v":294.0176932}]
[{"$f":"F_Inputs!B27","v":"BB3805DR"},null,null,null,"Retail Price Index for December",null,"index",null,null,{"$f":"F_Inputs!G27","v":246.8},{"$f":"F_Inputs!H27","v":253.4},{"$f":"F_Inputs!I27","v":257.5},{"$f":"F_Inputs!J27","v":260.60000000000002},{"$f":"F_Inputs!K27","v":267.10000000000002},{"$f":"F_Inputs!L27","v":278.10000000000002},{"$f":"F_Inputs!M27","v":287.55540000000002},{"$f":"F_Inputs!N27","v":296.4696174}]
[{"$f":"F_Inputs!B28","v":"BB3805JY"},null,null,null,"Retail Price Index for January",null,"index",null,null,{"$f":"F_Inputs!G28","v":245.8},{"$f":"F_Inputs!H28","v":252.6},{"$f":"F_Inputs!I28","v":255.4},{"$f":"F_Inputs!J28","v":258.8},{"$f":"F_Inputs!K28","v":265.5},{"$f":"F_Inputs!L28","v":276},{"$f":"F_Inputs!M28","v":285.38400000000001},{"$f":"F_Inputs!N28","v":294.23090400000001}]
[{"$f":"F_Inputs!B29","v":"BB3805FY"},null,null,null,"Retail Price Index for February",null,"index",null,null,{"$f":"F_Inputs!G29","v":247.6},{"$f":"F_Inputs!H29","v":254.2},{"$f":"F_Inputs!I29","v":256.7},{"$f":"F_Inputs!J29","v":260},{"$f":"F_Inputs!K29","v":268.39999999999998},{"$f":"F_Inputs!L29","v":278.10000000000002},{"$f":"F_Inputs!M29","v":287.55540000000002},{"$f":"F_Inputs!N29","v":296.4696174}]
[{"$f":"F_Inputs!B30","v":"BB3805MH"},null,null,null,"Retail Price Index for March",null,"index",null,null,{"$f":"F_Inputs!G30","v":248.7},{"$f":"F_Inputs!H30","v":254.8},{"$f":"F_Inputs!I30","v":257.10000000000002},{"$f":"F_Inputs!J30","v":261.10000000000002},{"$f":"F_Inputs!K30","v":269.3},{"$f":"F_Inputs!L30","v":278.3},{"$f":"F_Inputs!M30","v":287.76220000000001},{"$f":"F_Inputs!N30","v":296.68282820000002}]
[]
[null,null,null,null,"RPI: Assumed percentage increase for unpopulated monthly values",null,"%"]
[]
[null,"Inflation"]
[]
["C010",null,null,null,"Year reference for FYA base price 1",2013,"year #"]
["C011",null,null,null,"Year reference for FYA base price 2",2018,"year #"]
["C012",null,null,null,"Year reference for FYE base price",2018,"year #"]
["C013",null,null,null,"Year reference for FYE end price",2020,"year #"]
[]
[null,"Deflation"]
[]
["C014",null,null,null,"Year reference for FYE base price",2020,"year #"]
["C015",null,null,null,"Year reference for FYA end price",2018,"year #"]
["C016",null,null,null,"Year reference for FYE base price - IFRS 16",2018,"year #"]
[]
[]
["C: RCV INPUTS"]
[]
[null,"Water services"]
[]
[{"$f":"F_Inputs!B31","v":"APP8001W"},null,null,null,"Wholesale water closing RCV at 31 March 2020 (from PR14 FD)",{"$f":"F_Inputs!N31","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B32","v":"C00572_L021"},null,null,null,"Water ~ Total Adjustment RCV carry forward to PR19",{"$f":"F_Inputs!P32","v":-24.537663716038399},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B33","v":"APP25001"},null,null,null,"Water ~ CIS RCV inflation correction",{"$f":"F_Inputs!P33","v":-50.617858314809197},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B34","v":"C_APP27029_PD002"},null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources",{"$f":"F_Inputs!R34","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B35","v":"C_APP27030_PD002"},null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus",{"$f":"F_Inputs!R35","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B36","v":"C_WS15025_PR19PD006"},null,null,null,"Water: RCV adjustment from totex menu model",{"$f":"F_Inputs!N36","v":-6.70997690351843},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B37","v":"APP8009W"},null,null,null,"Water ~ Other adjustment to wholesale RCV",{"$f":"F_Inputs!N37","v":0},"£m","2017/18 FYE"]
[{"$f":"F_Inputs!B38","v":"C_A7010W_PR19PD003"},null,null,null,"Water ~ NPV effect of 50% of proceeds from disposals of interest in land",{"$f":"F_Inputs!N38","v":-0.81388923564452698},"£m","2017/18 FYA"]
[]
[null,null,null,null,"% of RCV to index by RPI - water services",0.5,"%"]
[]
[{"$f":"F_Inputs!B39","v":"WS12019WR"},null,null,null,"Water resources % of total wholesale water RCV ~ 31 March 2020",{"$f":"F_Inputs!N39","v":0},"%"]
[null,null,null,null,"Water network plus % of total wholesale water RCV ~ 31 March 2020",{"$f":"1-F96","v":1},"%"]
[]
[{"$f":"F_Inputs!B40","v":"APP33021WR"},null,null,null,"Water resources IFRS16 RCV adjustment",{"$f":"F_Inputs!N40","v":0},"£m","2017/18 FYE"]
[{"$f":"F_Inputs!B41","v":"APP33021WNP"},null,null,null,"Water network plus IFRS16 RCV adjustment",{"$f":"F_Inputs!N41","v":0},"£m","2017/18 FYE"]
[]
[null,"Wastewater services"]
[]
[{"$f":"F_Inputs!B42","v":"APP8001WW"},null,null,null,"Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD)",{"$f":"F_Inputs!N42","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B43","v":"C00579_L021"},null,null,null,"Wastewater ~ Total Adjustment RCV carry forward to PR19",{"$f":"F_Inputs!P43","v":-2.1581027567334399},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B44","v":"APP25002"},null,null,null,"Wastewater ~ CIS RCV inflation correction",{"$f":"F_Inputs!P44","v":-64.969383551380105},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B45","v":"C_APP27031_PD002"},null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus",{"$f":"F_Inputs!R45","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B46","v":"C_WWS15020_PR19PD006"},null,null,null,"Wastewater: RCV adjustment from totex menu model",{"$f":"F_Inputs!N46","v":-131.30368479747401},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B47","v":"APP8009WW"},null,null,null,"Wastewater ~ Other adjustment to wholesale RCV",{"$f":"F_Inputs!N47","v":0},"£m","2017/18 FYE"]
[{"$f":"F_Inputs!B48","v":"C_A7010WW_PR19PD003"},null,null,null,"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land",{"$f":"F_Inputs!N48","v":-3.9736983822040299},"£m","2017/18 FYA"]
[]
[null,null,null,null,"% of RCV to index by RPI - wastewater services",0.5,"%"]
[]
[{"$f":"F_Inputs!B49","v":"WWS12016BIO"},null,null,null,"Bioresources RCV (prior to midnight adjustments) 31 March 2020",{"$f":"F_Inputs!N49","v":0},"£m","2017/18 FYE"]
[]
[{"$f":"F_Inputs!B50","v":"APP33021BIO"},null,null,null,"Bioresources IFRS16 RCV adjustment",{"$f":"F_Inputs!N50","v":0},"£m","2017/18 FYE"]
[{"$f":"F_Inputs!B51","v":"APP33021WWNP"},null,null,null,"Wastewater network plus IFRS16 RCV adjustment",{"$f":"F_Inputs!N51","v":0},"£m","2017/18 FYE"]
[]
[null,"Dummy RCV"]
[]
[{"$f":"F_Inputs!B52","v":"RCV1011DMMY"},null,null,null,"Dummy RCV (prior to midnight adjustments) 31 March 2020",{"$f":"F_Inputs!N52","v":0},"£m","2017/18 FYE"]
[{"$f":"F_Inputs!B53","v":"C_APP27032_PD002"},null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway",{"$f":"F_Inputs!R53","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B55","v":"APP8009DMMY"},null,null,null,"Dummy: RCV adjustment from totex menu model",{"$f":"F_Inputs!N54","v":0},"£m","2012/13 FYA"]
[{"$f":"F_Inputs!B56","v":"APP33021DMMY"},null,null,null,"Dummy ~ Other adjustment to wholesale RCV",{"$f":"F_Inputs!N55","v":0},"£m","2017/18 FYE"]
["Manual input if required",null,null,null,"Dummy: NPV effect of 100% of proceeds from disposals of interest in land",null,"£m","2017/18 FYA"]
[null,null,null,null,"% of RCV to index by RPI - dummy",0.5,"%"]
[]
[{"$f":"F_Inputs!B57","v":0},null,null,null,"Dummy IFRS16 RCV adjustment",{"$f":"F_Inputs!N56","v":0},"£m","2017/18 FYE"]
[]
[]
["D: NON CHANGEABLE MODEL TECHNICAL INPUTS"]
[]
["C017",null,null,null,"Months per model period",12,"months"]
[]
["C018",null,null,null,"Months in a year",12,"months"]
[]
["C019",null,null,null,"Days in a year",365,"days"]
[]
[]
[null,null,null,null,"[Used in formula range - Do not delete]"]

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

{"sheet":"Indexation","index":6,"n_rows":107,"n_cols":21,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Indexation"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[]
["CPIH INDEXATION"]
[]
[null,"CPIH: Index value series"]
[null,null,null,null,{"$f":" Inputs!E$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.6768},{"$f":" Inputs!Q$35","v":107.89601279999999},{"$f":" Inputs!R$35","v":0},{"$f":" Inputs!S$35","v":0},{"$f":" Inputs!T$35","v":0},{"$f":" Inputs!U$35","v":0}]
[null,null,null,null,{"$f":" Inputs!E$36","v":"Consumer Price Index for May"},{"$f":" Inputs!F$36","v":0},{"$f":" Inputs!G$36","v":"index"},{"$f":" Inputs!H$36","v":0},{"$f":" Inputs!I$36","v":0},{"$f":" Inputs!J$36","v":95.9},{"$f":" Inputs!K$36","v":98.2},{"$f":" Inputs!L$36","v":99.6},{"$f":" Inputs!M$36","v":100.1},{"$f":" Inputs!N$36","v":100.8},{"$f":" Inputs!O$36","v":103.5},{"$f":" Inputs!P$36","v":105.98399999999999},{"$f":" Inputs!Q$36","v":108.209664},{"$f":" Inputs!R$36","v":0},{"$f":" Inputs!S$36","v":0},{"$f":" Inputs!T$36","v":0},{"$f":" Inputs!U$36","v":0}]
[null,null,null,null,{"$f":" Inputs!E$37","v":"Consumer Price Index for 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":105.98399999999999},{"$f":" Inputs!Q$37","v":108.209664},{"$f":" Inputs!R$37","v":0},{"$f":" Inputs!S$37","v":0},{"$f":" Inputs!T$37","v":0},{"$f":" Inputs!U$37","v":0}]
[null,null,null,null,{"$f":" Inputs!E$38","v":"Consumer Price Index for 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":105.98399999999999},{"$f":" Inputs!Q$38","v":108.209664},{"$f":" Inputs!R$38","v":0},{"$f":" Inputs!S$38","v":0},{"$f":" Inputs!T$38","v":0},{"$f":" Inputs!U$38","v":0}]
[null,null,null,null,{"$f":" Inputs!E$39","v":"Consumer Price Index for 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.496},{"$f":" Inputs!Q$39","v":108.732416},{"$f":" Inputs!R$39","v":0},{"$f":" Inputs!S$39","v":0},{"$f":" Inputs!T$39","v":0},{"$f":" Inputs!U$39","v":0}]
[null,null,null,null,{"$f":" Inputs!E$40","v":"Consumer Price Index for 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.8032},{"$f":" Inputs!Q$40","v":109.0460672},{"$f":" Inputs!R$40","v":0},{"$f":" Inputs!S$40","v":0},{"$f":" Inputs!T$40","v":0},{"$f":" Inputs!U$40","v":0}]
[null,null,null,null,{"$f":" Inputs!E$41","v":"Consumer Price Index for 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.90560000000001},{"$f":" Inputs!Q$41","v":109.1506176},{"$f":" Inputs!R$41","v":0},{"$f":" Inputs!S$41","v":0},{"$f":" Inputs!T$41","v":0},{"$f":" Inputs!U$41","v":0}]
[null,null,null,null,{"$f":" Inputs!E$42","v":"Consumer Price Index for 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.2128},{"$f":" Inputs!Q$42","v":109.4642688},{"$f":" Inputs!R$42","v":0},{"$f":" Inputs!S$42","v":0},{"$f":" Inputs!T$42","v":0},{"$f":" Inputs!U$42","v":0}]
[null,null,null,null,{"$f":" Inputs!E$43","v":"Consumer Price Index for 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.52},{"$f":" Inputs!Q$43","v":109.77791999999999},{"$f":" Inputs!R$43","v":0},{"$f":" Inputs!S$43","v":0},{"$f":" Inputs!T$43","v":0},{"$f":" Inputs!U$43","v":0}]
[null,null,null,null,{"$f":" Inputs!E$44","v":"Consumer Price Index for 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.008},{"$f":" Inputs!Q$44","v":109.255168},{"$f":" Inputs!R$44","v":0},{"$f":" Inputs!S$44","v":0},{"$f":" Inputs!T$44","v":0},{"$f":" Inputs!U$44","v":0}]
[null,null,null,null,{"$f":" Inputs!E$45","v":"Consumer Price Index for 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.41759999999999},{"$f":" Inputs!Q$45","v":109.6733696},{"$f":" Inputs!R$45","v":0},{"$f":" Inputs!S$45","v":0},{"$f":" Inputs!T$45","v":0},{"$f":" Inputs!U$45","v":0}]
[null,null,null,null,{"$f":" Inputs!E$46","v":"Consumer Price Index for 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.6224},{"$f":" Inputs!Q$46","v":109.8824704},{"$f":" Inputs!R$46","v":0},{"$f":" Inputs!S$46","v":0},{"$f":" Inputs!T$46","v":0},{"$f":" Inputs!U$46","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$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}]
[]
[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.6768,107.89601279999999,107.89601279999999,107.89601279999999,107.89601279999999,107.89601279999999]
[null,null,null,null,"CPIH: May - index",null,"index",null,null,{"$f":" IF(J11 > 0, J11, I26 * (1 + J$23))","v":95.9},98.2,99.6,100.1,100.8,103.5,105.98399999999999,108.209664,108.209664,108.209664,108.209664,108.209664]
[null,null,null,null,"CPIH: June - index",null,"index",null,null,95.6,98,99.8,100.1,101,103.5,105.98399999999999,108.209664,108.209664,108.209664,108.209664,108.209664]
[null,null,null,null,"CPIH: July - index",null,"index",null,null,95.7,98,99.6,100,100.9,103.5,105.98399999999999,108.209664,108.209664,108.209664,108.209664,108.209664]
[null,null,null,null,"CPIH: August - index",null,"index",null,null,96.1,98.4,99.9,100.3,101.2,104,106.496,108.732416,108.732416,108.732416,108.732416,108.732416]
[null,null,null,null,"CPIH: September- index",null,"index",null,null,96.4,98.7,100,100.2,101.5,104.3,106.8032,109.0460672,109.0460672,109.0460672,109.0460672,109.0460672]
[null,null,null,null,"CPIH: October - index",null,"index",null,null,96.8,98.8,100.1,100.3,101.6,104.4,106.90560000000001,109.1506176,109.1506176,109.1506176,109.1506176,109.1506176]
[null,null,null,null,"CPIH: November - index",null,"index",null,null,97,98.8,99.9,100.3,101.8,104.7,107.2128,109.4642688,109.4642688,109.4642688,109.4642688,109.4642688]
[null,null,null,null,"CPIH: December - index",null,"index",null,null,97.3,99.2,99.9,100.4,102.2,105,107.52,109.77791999999999,109.77791999999999,109.77791999999999,109.77791999999999,109.77791999999999]
[null,null,null,null,"CPIH: January - index",null,"index",null,null,97,98.7,99.2,99.9,101.8,104.5,107.008,109.255168,109.255168,109.255168,109.255168,109.255168]
[null,null,null,null,"CPIH: February - index",null,"index",null,null,97.5,99.1,99.5,100.1,102.4,104.9,107.41759999999999,109.6733696,109.6733696,109.6733696,109.6733696,109.6733696]
[null,null,null,null,"CPIH: March - index",null,"index",null,null,97.8,99.3,99.6,100.4,102.7,105.1,107.6224,109.8824704,109.8824704,109.8824704,109.8824704,109.8824704]
[]
[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.71786666666667,108.95894186666668,108.95894186666668,108.95894186666668,108.95894186666668,108.95894186666668]
[]
[]
["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.80040000000002},{"$f":" Inputs!Q$52","v":288.4742124},{"$f":" Inputs!R$52","v":0},{"$f":" Inputs!S$52","v":0},{"$f":" Inputs!T$52","v":0},{"$f":" Inputs!U$52","v":0}]
[null,null,null,null,{"$f":" Inputs!E$53","v":"Retail Price Index for May"},{"$f":" Inputs!F$53","v":0},{"$f":" Inputs!G$53","v":"index"},{"$f":" Inputs!H$53","v":0},{"$f":" Inputs!I$53","v":0},{"$f":" Inputs!J$53","v":242.4},{"$f":" Inputs!K$53","v":250},{"$f":" Inputs!L$53","v":255.9},{"$f":" Inputs!M$53","v":258.5},{"$f":" Inputs!N$53","v":262.10000000000002},{"$f":" Inputs!O$53","v":271.7},{"$f":" Inputs!P$53","v":280.93779999999998},{"$f":" Inputs!Q$53","v":289.64687179999999},{"$f":" Inputs!R$53","v":0},{"$f":" Inputs!S$53","v":0},{"$f":" Inputs!T$53","v":0},{"$f":" Inputs!U$53","v":0}]
[null,null,null,null,{"$f":" Inputs!E$54","v":"Retail Price Index for June"},{"$f":" Inputs!F$54","v":0},{"$f":" Inputs!G$54","v":"index"},{"$f":" Inputs!H$54","v":0},{"$f":" Inputs!I$54","v":0},{"$f":" Inputs!J$54","v":241.8},{"$f":" Inputs!K$54","v":249.7},{"$f":" Inputs!L$54","v":256.3},{"$f":" Inputs!M$54","v":258.89999999999998},{"$f":" Inputs!N$54","v":263.10000000000002},{"$f":" Inputs!O$54","v":272.3},{"$f":" Inputs!P$54","v":281.5582},{"$f":" Inputs!Q$54","v":290.28650420000002},{"$f":" Inputs!R$54","v":0},{"$f":" Inputs!S$54","v":0},{"$f":" Inputs!T$54","v":0},{"$f":" Inputs!U$54","v":0}]
[null,null,null,null,{"$f":" Inputs!E$55","v":"Retail Price Index for July"},{"$f":" Inputs!F$55","v":0},{"$f":" Inputs!G$55","v":"index"},{"$f":" Inputs!H$55","v":0},{"$f":" Inputs!I$55","v":0},{"$f":" Inputs!J$55","v":242.1},{"$f":" Inputs!K$55","v":249.7},{"$f":" Inputs!L$55","v":256},{"$f":" Inputs!M$55","v":258.60000000000002},{"$f":" Inputs!N$55","v":263.39999999999998},{"$f":" Inputs!O$55","v":272.89999999999998},{"$f":" Inputs!P$55","v":282.17860000000002},{"$f":" Inputs!Q$55","v":290.92613660000001},{"$f":" Inputs!R$55","v":0},{"$f":" Inputs!S$55","v":0},{"$f":" Inputs!T$55","v":0},{"$f":" Inputs!U$55","v":0}]
[null,null,null,null,{"$f":" Inputs!E$56","v":"Retail Price Index for August"},{"$f":" Inputs!F$56","v":0},{"$f":" Inputs!G$56","v":"index"},{"$f":" Inputs!H$56","v":0},{"$f":" Inputs!I$56","v":0},{"$f":" Inputs!J$56","v":243},{"$f":" Inputs!K$56","v":251},{"$f":" Inputs!L$56","v":257},{"$f":" Inputs!M$56","v":259.8},{"$f":" Inputs!N$56","v":264.39999999999998},{"$f":" Inputs!O$56","v":274.7},{"$f":" Inputs!P$56","v":284.03980000000001},{"$f":" Inputs!Q$56","v":292.84503380000001},{"$f":" Inputs!R$56","v":0},{"$f":" Inputs!S$56","v":0},{"$f":" Inputs!T$56","v":0},{"$f":" Inputs!U$56","v":0}]
[null,null,null,null,{"$f":" Inputs!E$57","v":"Retail Price Index for September"},{"$f":" Inputs!F$57","v":0},{"$f":" Inputs!G$57","v":"index"},{"$f":" Inputs!H$57","v":0},{"$f":" Inputs!I$57","v":0},{"$f":" Inputs!J$57","v":244.2},{"$f":" Inputs!K$57","v":251.9},{"$f":" Inputs!L$57","v":257.60000000000002},{"$f":" Inputs!M$57","v":259.60000000000002},{"$f":" Inputs!N$57","v":264.89999999999998},{"$f":" Inputs!O$57","v":275.10000000000002},{"$f":" Inputs!P$57","v":284.45339999999999},{"$f":" Inputs!Q$57","v":293.27145539999998},{"$f":" Inputs!R$57","v":0},{"$f":" Inputs!S$57","v":0},{"$f":" Inputs!T$57","v":0},{"$f":" Inputs!U$57","v":0}]
[null,null,null,null,{"$f":" Inputs!E$58","v":"Retail Price Index for October"},{"$f":" Inputs!F$58","v":0},{"$f":" Inputs!G$58","v":"index"},{"$f":" Inputs!H$58","v":0},{"$f":" Inputs!I$58","v":0},{"$f":" Inputs!J$58","v":245.6},{"$f":" Inputs!K$58","v":251.9},{"$f":" Inputs!L$58","v":257.7},{"$f":" Inputs!M$58","v":259.5},{"$f":" Inputs!N$58","v":264.8},{"$f":" Inputs!O$58","v":275.3},{"$f":" Inputs!P$58","v":284.66019999999997},{"$f":" Inputs!Q$58","v":293.48466619999999},{"$f":" Inputs!R$58","v":0},{"$f":" Inputs!S$58","v":0},{"$f":" Inputs!T$58","v":0},{"$f":" Inputs!U$58","v":0}]
[null,null,null,null,{"$f":" Inputs!E$59","v":"Retail Price Index for November"},{"$f":" Inputs!F$59","v":0},{"$f":" Inputs!G$59","v":"index"},{"$f":" Inputs!H$59","v":0},{"$f":" Inputs!I$59","v":0},{"$f":" Inputs!J$59","v":245.6},{"$f":" Inputs!K$59","v":252.1},{"$f":" Inputs!L$59","v":257.10000000000002},{"$f":" Inputs!M$59","v":259.8},{"$f":" Inputs!N$59","v":265.5},{"$f":" Inputs!O$59","v":275.8},{"$f":" Inputs!P$59","v":285.17720000000003},{"$f":" Inputs!Q$59","v":294.0176932},{"$f":" Inputs!R$59","v":0},{"$f":" Inputs!S$59","v":0},{"$f":" Inputs!T$59","v":0},{"$f":" Inputs!U$59","v":0}]
[null,null,null,null,{"$f":" Inputs!E$60","v":"Retail Price Index for December"},{"$f":" Inputs!F$60","v":0},{"$f":" Inputs!G$60","v":"index"},{"$f":" Inputs!H$60","v":0},{"$f":" Inputs!I$60","v":0},{"$f":" Inputs!J$60","v":246.8},{"$f":" Inputs!K$60","v":253.4},{"$f":" Inputs!L$60","v":257.5},{"$f":" Inputs!M$60","v":260.60000000000002},{"$f":" Inputs!N$60","v":267.10000000000002},{"$f":" Inputs!O$60","v":278.10000000000002},{"$f":" Inputs!P$60","v":287.55540000000002},{"$f":" Inputs!Q$60","v":296.4696174},{"$f":" Inputs!R$60","v":0},{"$f":" Inputs!S$60","v":0},{"$f":" Inputs!T$60","v":0},{"$f":" Inputs!U$60","v":0}]
[null,null,null,null,{"$f":" Inputs!E$61","v":"Retail Price Index for January"},{"$f":" Inputs!F$61","v":0},{"$f":" Inputs!G$61","v":"index"},{"$f":" Inputs!H$61","v":0},{"$f":" Inputs!I$61","v":0},{"$f":" Inputs!J$61","v":245.8},{"$f":" Inputs!K$61","v":252.6},{"$f":" Inputs!L$61","v":255.4},{"$f":" Inputs!M$61","v":258.8},{"$f":" Inputs!N$61","v":265.5},{"$f":" Inputs!O$61","v":276},{"$f":" Inputs!P$61","v":285.38400000000001},{"$f":" Inputs!Q$61","v":294.23090400000001},{"$f":" Inputs!R$61","v":0},{"$f":" Inputs!S$61","v":0},{"$f":" Inputs!T$61","v":0},{"$f":" Inputs!U$61","v":0}]
[null,null,null,null,{"$f":" Inputs!E$62","v":"Retail Price Index for February"},{"$f":" Inputs!F$62","v":0},{"$f":" Inputs!G$62","v":"index"},{"$f":" Inputs!H$62","v":0},{"$f":" Inputs!I$62","v":0},{"$f":" Inputs!J$62","v":247.6},{"$f":" Inputs!K$62","v":254.2},{"$f":" Inputs!L$62","v":256.7},{"$f":" Inputs!M$62","v":260},{"$f":" Inputs!N$62","v":268.39999999999998},{"$f":" Inputs!O$62","v":278.10000000000002},{"$f":" Inputs!P$62","v":287.55540000000002},{"$f":" Inputs!Q$62","v":296.4696174},{"$f":" Inputs!R$62","v":0},{"$f":" Inputs!S$62","v":0},{"$f":" Inputs!T$62","v":0},{"$f":" Inputs!U$62","v":0}]
[null,null,null,null,{"$f":" Inputs!E$63","v":"Retail Price Index for March"},{"$f":" Inputs!F$63","v":0},{"$f":" Inputs!G$63","v":"index"},{"$f":" Inputs!H$63","v":0},{"$f":" Inputs!I$63","v":0},{"$f":" Inputs!J$63","v":248.7},{"$f":" Inputs!K$63","v":254.8},{"$f":" Inputs!L$63","v":257.10000000000002},{"$f":" Inputs!M$63","v":261.10000000000002},{"$f":" Inputs!N$63","v":269.3},{"$f":" Inputs!O$63","v":278.3},{"$f":" Inputs!P$63","v":287.76220000000001},{"$f":" Inputs!Q$63","v":296.68282820000002},{"$f":" Inputs!R$63","v":0},{"$f":" Inputs!S$63","v":0},{"$f":" Inputs!T$63","v":0},{"$f":" Inputs!U$63","v":0}]
[]
[null,null,null,null,{"$f":" Inputs!E$65","v":"RPI: Assumed percentage increase for unpopulated monthly values"},{"$f":" Inputs!F$65","v":0},{"$f":" Inputs!G$65","v":"%"},{"$f":" Inputs!H$65","v":0},{"$f":" Inputs!I$65","v":0},{"$f":" Inputs!J$65","v":0},{"$f":" Inputs!K$65","v":0},{"$f":" Inputs!L$65","v":0},{"$f":" Inputs!M$65","v":0},{"$f":" Inputs!N$65","v":0},{"$f":" Inputs!O$65","v":0},{"$f":" Inputs!P$65","v":0},{"$f":" Inputs!Q$65","v":0},{"$f":" Inputs!R$65","v":0},{"$f":" Inputs!S$65","v":0},{"$f":" Inputs!T$65","v":0},{"$f":" Inputs!U$65","v":0}]
[]
[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.80040000000002,288.4742124,288.4742124,288.4742124,288.4742124,288.4742124]
[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.93779999999998,289.64687179999999,289.64687179999999,289.64687179999999,289.64687179999999,289.64687179999999]
[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.5582,290.28650420000002,290.28650420000002,290.28650420000002,290.28650420000002,290.28650420000002]
[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.17860000000002,290.92613660000001,290.92613660000001,290.92613660000001,290.92613660000001,290.92613660000001]
[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,284.03980000000001,292.84503380000001,292.84503380000001,292.84503380000001,292.84503380000001,292.84503380000001]
[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.45339999999999,293.27145539999998,293.27145539999998,293.27145539999998,293.27145539999998,293.27145539999998]
[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.66019999999997,293.48466619999999,293.48466619999999,293.48466619999999,293.48466619999999,293.48466619999999]
[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.17720000000003,294.0176932,294.0176932,294.0176932,294.0176932,294.0176932]
[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.55540000000002,296.4696174,296.4696174,296.4696174,296.4696174,296.4696174]
[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.38400000000001,294.23090400000001,294.23090400000001,294.23090400000001,294.23090400000001,294.23090400000001]
[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.55540000000002,296.4696174,296.4696174,296.4696174,296.4696174,296.4696174]
[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.76220000000001,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002]
[]
[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.25521666666668,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334]
[]
[]
["INFLATION"]
[]
[null,"Inflation of 2013 base prices  FYA - 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$72","v":"Year reference for FYE end price"},{"$f":" Inputs!F$72","v":2020},{"$f":" Inputs!G$72","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.25521666666668,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334]
[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.76220000000001,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F78 & \" FYA to \" & F79 & \" FYE\"","v":"RPI inflate from 2013 FYA to 2020 FYE"},{"$f":" INDEX($J81:$U81, 1, MATCH($F79,$J$4:$U$4)) / INDEX($J80:$U80, 1, MATCH($F78,$J$4:$U$4))","v":1.2125588155716769},"factor"]
[]
[null,"Inflation of 2018 base prices  FYA - 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$72","v":"Year reference for FYE end price"},{"$f":" Inputs!F$72","v":2020},{"$f":" Inputs!G$72","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.25521666666668,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334,293.06712838333334]
[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.76220000000001,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F85 & \" FYA to \" & F86 & \" FYE\"","v":"RPI inflate from 2018 FYA to 2020 FYE"},{"$f":" INDEX($J88:$U88, 1, MATCH($F86,$J$4:$U$4)) / INDEX($J87:$U87, 1, MATCH($F85,$J$4:$U$4))","v":1.0792063834611536},"factor"]
[]
[null,"Inflation of 2018 base prices  FYE - RPI"]
[null,null,null,null,{"$f":" Inputs!E$71","v":"Year reference for FYE base price"},{"$f":" Inputs!F$71","v":2018},{"$f":" Inputs!G$71","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$72","v":"Year reference for FYE end price"},{"$f":" Inputs!F$72","v":2020},{"$f":" Inputs!G$72","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.76220000000001,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002,296.68282820000002]
[null,null,null,null,{"$f":" \"RPI inflate from \" & F92 & \" FYE to \" & F93 & \" FYE\"","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" INDEX($J94:$U94, 1, MATCH($F93,$J$4:$U$4)) / INDEX($J94:$U94, 1, MATCH($F92,$J$4:$U$4))","v":1.0660540000000001},"factor"]
[]
[]
["DEFLATION"]
[]
[null,null,null,null,{"$f":" Inputs!E$76","v":"Year reference for FYE base price"},{"$f":" Inputs!F$76","v":2020},{"$f":" Inputs!G$76","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$77","v":"Year reference for FYA end price"},{"$f":" Inputs!F$77","v":2018},{"$f":" Inputs!G$77","v":"year #"}]
[null,null,null,null,{"$f":" Inputs!E$78","v":"Year reference for FYE base price - IFRS 16"},{"$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.6224,109.8824704,109.8824704,109.8824704,109.8824704,109.8824704]
[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.71786666666667,108.95894186666668,108.95894186666668,108.95894186666668,108.95894186666668,108.95894186666668]
[null,null,null,null,{"$f":" \"CPIH deflate from \" & F100 & \" FYE to \" & F101 & \" FYA\"","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" INDEX($J104:$U104, 1, MATCH($F101,$J$4:$U$4)) / INDEX($J103:$U103, 1, MATCH($F100,$J$4:$U$4))","v":0.94843760144171874},"factor"]
[null,null,null,null,{"$f":" \"CPIH deflate from \" & F100 & \" FYE to \" & F101 & \" FYE\"","v":"CPIH deflate from 2020 FYE to 2018 FYE"},{"$f":" INDEX($J103:$U103, 1, MATCH($F101,$J$4:$U$4)) / INDEX($J103:$U103, 1, MATCH($F100,$J$4:$U$4))","v":0.95647649363369236},"factor"]
[null,null,null,null,"CPIH deflate from 2018 FYE to 2018 FYA - IFRS 16",{"$f":" INDEX($J104:$U104, 1, MATCH($F101,$J$4:$U$4)) / INDEX($J103:$U103, 1, MATCH($F102,$J$4:$U$4))","v":0.99159530605772273},"factor"]

{"sheet":"Calc","index":7,"n_rows":436,"n_cols":21,"rows_kept":436,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Calc"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2013-03-31"},{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$80","v":"Pre-Fcst"},{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$103","v":2013},{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12}]
[]
["WATER SERVICES"]
[]
[null,"Water RCV closing balance at 31 March 2020"]
[{"$f":" Inputs!A$85","v":"APP8001W"},null,null,null,{"$f":" Inputs!E$85","v":"Wholesale water closing RCV at 31 March 2020 (from PR14 FD)"},{"$f":" Inputs!F$85","v":0},{"$f":" Inputs!G$85","v":"£m"}]
[{"$f":" Inputs!A$86","v":"C00572_L021"},null,null,null,{"$f":" Inputs!E$86","v":"Water ~ Total Adjustment RCV carry forward to PR19"},{"$f":" Inputs!F$86","v":-24.537663716038399},{"$f":" Inputs!G$86","v":"£m"}]
[{"$f":" Inputs!A$87","v":"APP25001"},null,null,null,{"$f":" Inputs!E$87","v":"Water ~ CIS RCV inflation correction"},{"$f":" Inputs!F$87","v":-50.617858314809197},{"$f":" Inputs!G$87","v":"£m"}]
[{"$f":" Inputs!A$88","v":"C_APP27029_PD002"},null,null,null,{"$f":" Inputs!E$88","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources"},{"$f":" Inputs!F$88","v":0},{"$f":" Inputs!G$88","v":"£m"}]
[{"$f":" Inputs!A$89","v":"C_APP27030_PD002"},null,null,null,{"$f":" Inputs!E$89","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus"},{"$f":" Inputs!F$89","v":0},{"$f":" Inputs!G$89","v":"£m"}]
[{"$f":" Inputs!A$90","v":"C_WS15025_PR19PD006"},null,null,null,{"$f":" Inputs!E$90","v":"Water: RCV adjustment from totex menu model"},{"$f":" Inputs!F$90","v":-6.70997690351843},{"$f":" Inputs!G$90","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$82","v":"RPI inflate from 2013 FYA to 2020 FYE"},{"$f":" Indexation!F$82","v":1.2125588155716769},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E10 & \" at 2020 FYE price base\"","v":"Wholesale water closing RCV at 31 March 2020 (from PR14 FD) at 2020 FYE price base"},{"$f":" F10 * F$17","v":0},"£m"]
[null,null,null,null,"Water ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base",-29.753360452415631,"£m"]
[null,null,null,null,"Water ~ CIS RCV inflation correction at 2020 FYE price base",-61.377130324979994,"£m"]
[null,null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base",0,"£m"]
[null,null,null,null,"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base",0,"£m"]
[null,null,null,null,"Water: RCV adjustment from totex menu model at 2020 FYE price base",-8.1362416466436152,"£m"]
[]
[{"$f":" Inputs!A$91","v":"APP8009W"},null,null,null,{"$f":" Inputs!E$91","v":"Water ~ Other adjustment to wholesale RCV"},{"$f":" Inputs!F$91","v":0},{"$f":" Inputs!G$91","v":"£m"}]
[{"$f":" Inputs!A$92","v":"C_A7010W_PR19PD003"},null,null,null,{"$f":" Inputs!E$92","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land"},{"$f":" Inputs!F$92","v":-0.81388923564452698},{"$f":" Inputs!G$92","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$95","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" Indexation!F$95","v":1.0660540000000001},{"$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.0792063834611536},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,{"$f":" E26 & \" at 2020 FYE price base\"","v":"Water ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":" F26 * F29","v":0},"£m"]
[null,null,null,null,{"$f":" E27 & \" at 2020 FYE price base\"","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F27 * F30","v":-0.87835445853789262},"£m"]
[]
[null,null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[null,null,null,null,{"$f":" E$19","v":"Wholesale water closing RCV at 31 March 2020 (from PR14 FD) at 2020 FYE price base"},{"$f":" F$19","v":0},"£m"]
[null,null,null,null,{"$f":" E$20","v":"Water ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},{"$f":" F$20","v":-29.753360452415631},"£m"]
[null,null,null,null,{"$f":" E$21","v":"Water ~ CIS RCV inflation correction at 2020 FYE price base"},{"$f":" F$21","v":-61.377130324979994},"£m"]
[null,null,null,null,{"$f":" E$33","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F$33","v":-0.87835445853789262},"£m"]
[null,null,null,null,{"$f":" E$22","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$22","v":0},"£m"]
[null,null,null,null,{"$f":" E$23","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$23","v":0},"£m"]
[null,null,null,null,{"$f":" E$24","v":"Water: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$24","v":-8.1362416466436152},"£m"]
[null,null,null,null,{"$f":" E$32","v":"Water ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":" F$32","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$106","v":"CPIH deflate from 2020 FYE to 2018 FYE"},{"$f":" Indexation!F$106","v":0.95647649363369236},{"$f":" Indexation!G$106","v":"factor"}]
[]
["C_APP8002W",null,null,null,"Wholesale water closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base ",{"$f":" F36 * F$45","v":0},"£m"]
["C_APP8003W",null,null,null,"Water ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base",-28.458389879345873,"£m"]
["C_APP8004W",null,null,null,"Water ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base",-58.705782402535036,"£m"]
["C_APP8005W",null,null,null,"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base",-0.84012539266984398,"£m"]
["C_APP8006W",null,null,null,"Water ~ ODI RCV adjustment allocated to Water resources at 2017-18 FYE CPIH deflated price base",0,"£m"]
["C_APP8007W",null,null,null,"Water ~ ODI RCV adjustment allocated to Water network plus at 2017-18 FYE CPIH deflated price base",0,"£m"]
["C_APP8008W",null,null,null,"Water ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base",-7.7821238815381042,"£m"]
["C_APP8009W",null,null,null,"Water ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base",0,"£m"]
["C_APP8010W",null,null,null,"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base",{"$f":"SUM(F47:F54)","v":-95.786421556088854},"£m"]
[]
[null,null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[null,null,null,null,{"$f":" E$20","v":"Water ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},{"$f":" F$20","v":-29.753360452415631},"£m"]
[null,null,null,null,{"$f":" E$21","v":"Water ~ CIS RCV inflation correction at 2020 FYE price base"},{"$f":" F$21","v":-61.377130324979994},"£m"]
[null,null,null,null,{"$f":" E$33","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F$33","v":-0.87835445853789262},"£m"]
[null,null,null,null,{"$f":" E$22","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$22","v":0},"£m"]
[null,null,null,null,{"$f":" E$23","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$23","v":0},"£m"]
[null,null,null,null,{"$f":" E$24","v":"Water: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$24","v":-8.1362416466436152},"£m"]
[null,null,null,null,{"$f":" E$32","v":"Water ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":" F$32","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
["C_APP25003",null,null,null,"Water ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base",{"$f":" F58 * F$66","v":-28.219205822319971},"£m"]
["C_APP25007",null,null,null,"Water ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base",-58.212378268799803,"£m"]
["C_A7011W",null,null,null,"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base",-0.83306439587131842,"£m"]
["C_APP27048",null,null,null,"ODI end of period RCV adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base",0,"£m"]
["C_APP27049",null,null,null,"ODI end of period RCV adjustment  ~ Water network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
["C_WS15027",null,null,null,"Water: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base",-7.7167175120928908,"£m"]
["C030",null,null,null,"Water ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base",0,"£m"]
[]
[null,null,"IFRS16 RCV adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[{"$f":" Inputs!A$99","v":"APP33021WR"},null,null,null,{"$f":" Inputs!E$99","v":"Water resources IFRS16 RCV adjustment"},{"$f":" Inputs!F$99","v":0},{"$f":" Inputs!G$99","v":"£m"}]
[{"$f":" Inputs!A$100","v":"APP33021WNP"},null,null,null,{"$f":" Inputs!E$100","v":"Water network plus IFRS16 RCV adjustment"},{"$f":" Inputs!F$100","v":0},{"$f":" Inputs!G$100","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$107","v":"CPIH deflate from 2018 FYE to 2018 FYA - IFRS 16"},{"$f":" Indexation!F$107","v":0.99159530605772273},{"$f":" Indexation!G$107","v":"factor"}]
[]
["C_APP8022WR",null,null,null,"Water resources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F77 * F$80","v":0},"£m"]
["C_APP8022WN",null,null,null,"Water network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F78 * F$80","v":0},"£m"]
[]
[null,"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base"]
[null,null,null,null,{"$f":" E$19","v":"Wholesale water closing RCV at 31 March 2020 (from PR14 FD) at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$20","v":"Water ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},{"$f":" F$20","v":-29.753360452415631},{"$f":" G$20","v":"£m"}]
[null,null,null,null,{"$f":" E$21","v":"Water ~ CIS RCV inflation correction at 2020 FYE price base"},{"$f":" F$21","v":-61.377130324979994},{"$f":" G$21","v":"£m"}]
[null,null,null,null,{"$f":" E$22","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$22","v":0},{"$f":" G$22","v":"£m"}]
[null,null,null,null,{"$f":" E$23","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$23","v":0},"£m"]
[null,null,null,null,{"$f":" E$24","v":"Water: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$24","v":-8.1362416466436152},{"$f":" G$24","v":"£m"}]
[null,null,null,null,{"$f":" E$32","v":"Water ~ Other adjustment to wholesale RCV at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$33","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F$33","v":-0.87835445853789262},{"$f":" G$33","v":"£m"}]
[null,null,null,null,"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base",{"$f":"SUM(F86:F93)","v":-100.14508688257713},"£m"]
[]
[null,"Water resources"]
[null,null,null,null,{"$f":" E$94","v":"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base"},-100.14508688257713,"£m"]
[{"$f":" Inputs!A$96","v":"WS12019WR"},null,null,null,{"$f":" Inputs!E$96","v":"Water resources % of total wholesale water RCV ~ 31 March 2020"},{"$f":" Inputs!F$96","v":0},{"$f":" Inputs!G$96","v":"%"}]
[null,null,null,null,{"$f":" E$89","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$89","v":0},"£m"]
[null,null,null,null,{"$f":" E$90","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$90","v":0},"£m"]
[null,null,null,null,"Water resources opening RCV at 2020 FYE price base",{"$f":" (F97 - F99 - F100) * F98 + F99","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$101","v":"Water resources opening RCV at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water resources RPI linked RCV at 2020 FYE price base",{"$f":" F103 * F104","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$101","v":"Water resources opening RCV at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water resources CPIH linked RCV at 2020 FYE price base",{"$f":" F107 * (1 - F108)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$105","v":"Water resources RPI linked RCV at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$109","v":"Water resources CPIH linked RCV at 2020 FYE price base"},0,"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
[null,null,null,null,"Water resources 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F111 * F$114","v":0},"£m"]
[null,null,null,null,"Water resources 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F112 * F$114","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E82","v":"Water resources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F82","v":0},{"$f":"G82","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water resources IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F119 * F120","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E82","v":"Water resources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F82","v":0},{"$f":"G82","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water resources IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F123 * (1 - F124)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E116","v":"Water resources 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F116","v":0},"£m"]
[null,null,null,null,{"$f":"E121","v":"Water resources IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F121","v":0},"£m"]
["C_APP8014WR",null,null,null,"Water resources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F127 + F128","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E117","v":"Water resources 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F117","v":0},{"$f":"G117","v":"£m"}]
[null,null,null,null,{"$f":"E125","v":"Water resources IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F125","v":0},"£m"]
["C_APP8016WR",null,null,null,"Water resources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F131 + F132","v":0},"£m"]
[]
[null,"Water network plus"]
[null,null,null,null,{"$f":" E$94","v":"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base"},-100.14508688257713,"£m"]
[null,null,null,null,{"$f":" Inputs!E$97","v":"Water network plus % of total wholesale water RCV ~ 31 March 2020"},{"$f":" Inputs!F$97","v":1},{"$f":" Inputs!G$97","v":"%"}]
[null,null,null,null,{"$f":" E$89","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water resources at 2020 FYE price base"},{"$f":" F$89","v":0},"£m"]
[null,null,null,null,{"$f":" E$90","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Water network plus at 2020 FYE price base"},{"$f":" F$90","v":0},"£m"]
[null,null,null,null,"Water network plus opening RCV at 2020 FYE price base",{"$f":" (F136 - F138 - F139) * F137 + F139","v":-100.14508688257713},"£m"]
[]
[null,null,null,null,{"$f":" E$140","v":"Water network plus opening RCV at 2020 FYE price base"},-100.14508688257713,"£m"]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water network plus RPI linked RCV at 2020 FYE price base",{"$f":" F142 * F143","v":-50.072543441288566},"£m"]
[]
[null,null,null,null,{"$f":" E$140","v":"Water network plus opening RCV at 2020 FYE price base"},-100.14508688257713,"£m"]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water network plus CPIH linked RCV at 2020 FYE price base",{"$f":" F146 * (1 - F147)","v":-50.072543441288566},"£m"]
[]
[null,null,null,null,{"$f":" E$144","v":"Water network plus RPI linked RCV at 2020 FYE price base"},{"$f":" F$144","v":-50.072543441288566},"£m"]
[null,null,null,null,{"$f":" E$148","v":"Water network plus CPIH linked RCV at 2020 FYE price base"},-50.072543441288566,"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
[null,null,null,null,"Water network plus RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F150 * F$153","v":-47.490682999541995},"£m"]
[null,null,null,null,"Water network plus RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F151 * F$153","v":-47.490682999541995},"£m"]
[]
[null,null,null,null,{"$f":"E83","v":"Water network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F83","v":0},{"$f":"G83","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water network plus IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F158 * F159","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E83","v":"Water network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F83","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$94","v":"% of RCV to index by RPI - water services"},{"$f":" Inputs!F$94","v":0.5},{"$f":" Inputs!G$94","v":"%"}]
[null,null,null,null,"Water network plus IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F162 * (1 - F163)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E155","v":"Water network plus RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F155","v":-47.490682999541995},"£m"]
[null,null,null,null,{"$f":"E160","v":"Water network plus IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F160","v":0},"£m"]
["C_APP8014WN",null,null,null,"Water network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F166 + F167","v":-47.490682999541995},"£m"]
[]
[null,null,null,null,{"$f":"E156","v":"Water network plus RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F156","v":-47.490682999541995},"£m"]
[null,null,null,null,{"$f":"E164","v":"Water network plus IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F164","v":0},"£m"]
["C_APP8016WN",null,null,null,"Water network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F170 + F171","v":-47.490682999541995},"£m"]
[]
[]
["WASTEWATER SERVICES"]
[]
[null,"Wastewater RCV closing balance at 31 March 2020"]
[{"$f":" Inputs!A$104","v":"APP8001WW"},null,null,null,{"$f":" Inputs!E$104","v":"Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD)"},{"$f":" Inputs!F$104","v":0},{"$f":" Inputs!G$104","v":"£m"}]
[{"$f":" Inputs!A$105","v":"C00579_L021"},null,null,null,{"$f":" Inputs!E$105","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19"},{"$f":" Inputs!F$105","v":-2.1581027567334399},{"$f":" Inputs!G$105","v":"£m"}]
[{"$f":" Inputs!A$106","v":"APP25002"},null,null,null,{"$f":" Inputs!E$106","v":"Wastewater ~ CIS RCV inflation correction"},{"$f":" Inputs!F$106","v":-64.969383551380105},{"$f":" Inputs!G$106","v":"£m"}]
[{"$f":" Inputs!A$107","v":"C_APP27031_PD002"},null,null,null,{"$f":" Inputs!E$107","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus"},{"$f":" Inputs!F$107","v":0},{"$f":" Inputs!G$107","v":"£m"}]
[{"$f":" Inputs!A$108","v":"C_WWS15020_PR19PD006"},null,null,null,{"$f":" Inputs!E$108","v":"Wastewater: RCV adjustment from totex menu model"},{"$f":" Inputs!F$108","v":-131.30368479747401},{"$f":" Inputs!G$108","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.2125588155716769},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E178 & \" at 2020 FYE price base\"","v":"Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD) at 2020 FYE price base"},{"$f":" F178 * F$184","v":0},"£m"]
[null,null,null,null,{"$f":" E179 & \" at 2020 FYE price base\"","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},{"$f":" F179 * F$184","v":-2.6168265225866705},"£m"]
[null,null,null,null,{"$f":" E180 & \" at 2020 FYE price base\"","v":"Wastewater ~ CIS RCV inflation correction at 2020 FYE price base"},{"$f":" F180 * F$184","v":-78.77919876748345},"£m"]
[null,null,null,null,{"$f":" E181 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},{"$f":" F181 * F$184","v":0},"£m"]
[null,null,null,null,{"$f":" E182 & \" at 2020 FYE price base\"","v":"Wastewater: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F182 * F$184","v":-159.21344051822189},"£m"]
[]
[{"$f":" Inputs!A$114","v":"WWS12016BIO"},null,null,null,{"$f":" Inputs!E$114","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020"},{"$f":" Inputs!F$114","v":0},{"$f":" Inputs!G$114","v":"£m"}]
[{"$f":" Inputs!A$109","v":"APP8009WW"},null,null,null,{"$f":" Inputs!E$109","v":"Wastewater ~ Other adjustment to wholesale RCV"},{"$f":" Inputs!F$109","v":0},{"$f":" Inputs!G$109","v":"£m"}]
[{"$f":" Inputs!A$110","v":"C_A7010WW_PR19PD003"},null,null,null,{"$f":" Inputs!E$110","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land"},{"$f":" Inputs!F$110","v":-3.9736983822040299},{"$f":" Inputs!G$110","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$95","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" Indexation!F$95","v":1.0660540000000001},{"$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.0792063834611536},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,{"$f":" E192 & \" at 2020 FYE price base\"","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F192 * F196","v":0},"£m"]
[null,null,null,null,{"$f":" E193 & \" at 2020 FYE price base\"","v":"Wastewater ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":" F193 * F196","v":0},"£m"]
[null,null,null,null,{"$f":" E194 & \" at 2020 FYE price base\"","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F194 * F197","v":-4.2884406600238485},"£m"]
[]
[null,null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[null,null,null,null,{"$f":" E$186","v":"Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD) at 2020 FYE price base"},{"$f":" F$186","v":0},"£m"]
[null,null,null,null,{"$f":" E$187","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},-2.6168265225866705,"£m"]
[null,null,null,null,{"$f":" E$188","v":"Wastewater ~ CIS RCV inflation correction at 2020 FYE price base"},-78.77919876748345,"£m"]
[null,null,null,null,{"$f":" E$201","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},-4.2884406600238485,"£m"]
[null,null,null,null,{"$f":" E$189","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$190","v":"Wastewater: RCV adjustment from totex menu model at 2020 FYE price base"},-159.21344051822189,"£m"]
[null,null,null,null,{"$f":" E$200","v":"Wastewater ~ Other adjustment to wholesale RCV at 2020 FYE price base"},0,"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$106","v":"CPIH deflate from 2020 FYE to 2018 FYE"},{"$f":" Indexation!F$106","v":0.95647649363369236},{"$f":" Indexation!G$106","v":"factor"}]
[]
["C_APP8002WW",null,null,null,"Wholesale wastewater closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base ",{"$f":" F204 * F$212","v":0},"£m"]
["C_APP8003WW",null,null,null,"Wastewater ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base",-2.5029330567713468,"£m"]
["C_APP8004WW",null,null,null,"Wastewater ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base",-75.350451808394268,"£m"]
["C_APP8005WW",null,null,null,"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base",-4.1017926856557683,"£m"]
["C_APP8006WW",null,null,null,"Wastewater ~ ODI RCV adjustment allocated to Wastewater network plus at 2017-18 FYE CPIH deflated price base",0,"£m"]
["C_APP8008WW",null,null,null,"Wastewater ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base",-152.2839133262253,"£m"]
["C_APP8009WW",null,null,null,"Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base",0,"£m"]
["C_APP8010WW",null,null,null,"Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base",{"$f":"SUM(F214:F220)","v":-234.23909087704669},"£m"]
[]
[null,null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[null,null,null,null,{"$f":" E$187","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},-2.6168265225866705,"£m"]
[null,null,null,null,{"$f":" E$188","v":"Wastewater ~ CIS RCV inflation correction at 2020 FYE price base"},-78.77919876748345,"£m"]
[null,null,null,null,{"$f":" E$201","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},-4.2884406600238485,"£m"]
[null,null,null,null,{"$f":" E$189","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$190","v":"Wastewater: RCV adjustment from totex menu model at 2020 FYE price base"},-159.21344051822189,"£m"]
[null,null,null,null,{"$f":" E$200","v":"Wastewater ~ Other adjustment to wholesale RCV at 2020 FYE price base"},0,"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
["C_APP25005",null,null,null,"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base",{"$f":" F224 * F$231","v":-2.4818966704711753},"£m"]
["C_APP25008",null,null,null,"Wastewater ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base",-74.717154322532409,"£m"]
["C_A7011WW",null,null,null,"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base",-4.0673183735181597,"£m"]
["C_APP27050",null,null,null,"ODI end of period RCV adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base",0,"£m"]
["C_WWS15022",null,null,null,"Wastewater: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base",-151.00401364238613,"£m"]
["C040",null,null,null,"Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base",0,"£m"]
[]
[null,null,null,null,{"$f":"E199","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":"F199","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
["C_RCV1011BIO_FYA",null,null,null,"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYA CPIH deflated price base",{"$f":" F240 * F$242","v":0},"£m"]
[]
[null,null,"IFRS16 RCV adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[{"$f":" Inputs!A$116","v":"APP33021BIO"},null,null,null,{"$f":" Inputs!E$116","v":"Bioresources IFRS16 RCV adjustment"},{"$f":" Inputs!F$116","v":0},{"$f":" Inputs!G$116","v":"£m"}]
[{"$f":" Inputs!A$117","v":"APP33021WWNP"},null,null,null,{"$f":" Inputs!E$117","v":"Wastewater network plus IFRS16 RCV adjustment"},{"$f":" Inputs!F$117","v":0},{"$f":" Inputs!G$117","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$107","v":"CPIH deflate from 2018 FYE to 2018 FYA - IFRS 16"},{"$f":" Indexation!F$107","v":0.99159530605772273},{"$f":" Indexation!G$107","v":"factor"}]
[]
["C_APP8022BIO",null,null,null,"Bioresources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F247 * F$250","v":0},"£m"]
["C_APP8022WWN",null,null,null,"Wastewater network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F248 * F$250","v":0},"£m"]
[]
[null,"Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base"]
[null,null,null,null,{"$f":" E$186","v":"Wholesale wastewater closing RCV at 31 March 2020 in 2012-13 prices (PR14 FD) at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$187","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2020 FYE price base"},-2.6168265225866705,"£m"]
[null,null,null,null,{"$f":" E$188","v":"Wastewater ~ CIS RCV inflation correction at 2020 FYE price base"},-78.77919876748345,"£m"]
[null,null,null,null,{"$f":" E$189","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Wastewater network plus at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$190","v":"Wastewater: RCV adjustment from totex menu model at 2020 FYE price base"},-159.21344051822189,"£m"]
[null,null,null,null,{"$f":" E$200","v":"Wastewater ~ Other adjustment to wholesale RCV at 2020 FYE price base"},0,"£m"]
[null,null,null,null,{"$f":" E$201","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2020 FYE price base"},-4.2884406600238485,"£m"]
[null,null,null,null,"Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base",{"$f":"SUM(F256:F262)","v":-244.89790646831585},"£m"]
[]
[null,"Wastewater network plus"]
[null,null,null,null,{"$f":" E$263","v":"Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2020 FYE price base"},-244.89790646831585,"£m"]
[null,null,null,"less",{"$f":" E$199","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F$199","v":0},"£m"]
[null,null,null,null,"Wastewater network plus opening RCV at 2020 FYE price base",{"$f":" F266 - F267","v":-244.89790646831585},"£m"]
[]
[null,null,null,null,{"$f":" E$268","v":"Wastewater network plus opening RCV at 2020 FYE price base"},-244.89790646831585,"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Wastewater network plus RPI linked RCV at 2020 FYE price base",{"$f":" F270 * F271","v":-122.44895323415793},"£m"]
[]
[null,null,null,null,{"$f":" E$268","v":"Wastewater network plus opening RCV at 2020 FYE price base"},-244.89790646831585,"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Wastewater network plus CPIH linked RCV at 2020 FYE price base",{"$f":" F274 * (1 - F275)","v":-122.44895323415793},"£m"]
[]
[null,null,null,null,{"$f":" E$272","v":"Wastewater network plus RPI linked RCV at 2020 FYE price base"},-122.44895323415793,"£m"]
[null,null,null,null,{"$f":" E$276","v":"Wastewater network plus CPIH linked RCV at 2020 FYE price base"},-122.44895323415793,"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
[null,null,null,null,"Wastewater network plus RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F278 * F$281","v":-116.13519150445393},{"$f":" G$272","v":"£m"}]
[null,null,null,null,"Wastewater network plus RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F279 * F$281","v":-116.13519150445393},{"$f":" G$276","v":"£m"}]
[]
[null,null,null,null,{"$f":"E253","v":"Wastewater network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F253","v":0},{"$f":"G253","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Wastewater network plus IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F286 * F287","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E253","v":"Wastewater network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F253","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Wastewater network plus IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F290 * (1 - F291)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E283","v":"Wastewater network plus RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F283","v":-116.13519150445393},"£m"]
[null,null,null,null,{"$f":"E288","v":"Wastewater network plus IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F288","v":0},"£m"]
["C_APP8014WWN",null,null,null,"Wastewater network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F294 + F295","v":-116.13519150445393},"£m"]
[]
[null,null,null,null,{"$f":"E284","v":"Wastewater network plus RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F284","v":-116.13519150445393},"£m"]
[null,null,null,null,{"$f":"E292","v":"Wastewater network plus IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F292","v":0},"£m"]
["C_APP8016WWN",null,null,null,"Wastewater network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F298 + F299","v":-116.13519150445393},"£m"]
[]
[null,"Bioresources"]
[null,null,null,null,{"$f":" E$199","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F$199","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Bioresources RPI linked RCV at 2020 FYE price base",{"$f":" F303 * F304","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$199","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F$199","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Bioresources CPIH linked RCV at 2020 FYE price base",{"$f":" F307 * (1 - F308)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$305","v":"Bioresources RPI linked RCV at 2020 FYE price base"},{"$f":" F$305","v":0},"£m"]
[null,null,null,null,{"$f":" E$309","v":"Bioresources CPIH linked RCV at 2020 FYE price base"},{"$f":" F$309","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
[null,null,null,null,"Bioresources 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F311 * F$314","v":0},{"$f":" G$305","v":"£m"}]
[null,null,null,null,"Bioresources 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F312 * F$314","v":0},{"$f":" G$309","v":"£m"}]
[]
[null,null,null,null,{"$f":"E252","v":"Bioresources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F252","v":0},{"$f":"G252","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Bioresources IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F319 * F320","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E252","v":"Bioresources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F252","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$112","v":"% of RCV to index by RPI - wastewater services"},{"$f":" Inputs!F$112","v":0.5},{"$f":" Inputs!G$112","v":"%"}]
[null,null,null,null,"Bioresources IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F323 * (1 - F324)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E316","v":"Bioresources 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F316","v":0},"£m"]
[null,null,null,null,{"$f":"E321","v":"Bioresources IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F321","v":0},"£m"]
["C_APP8014BIO",null,null,null,"Bioresources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F327 + F328","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E317","v":"Bioresources 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F317","v":0},"£m"]
[null,null,null,null,{"$f":"E325","v":"Bioresources IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F325","v":0},"£m"]
["C_APP8016BIO",null,null,null,"Bioresources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F331 + F332","v":0},"£m"]
[]
[]
["DUMMY PRICE CONTROL"]
[]
[null,"Dummy RCV closing balance at 31 March 2020"]
[{"$f":"Inputs!A$121","v":"RCV1011DMMY"},null,null,null,{"$f":"Inputs!E$121","v":"Dummy RCV (prior to midnight adjustments) 31 March 2020"},{"$f":"Inputs!F$121","v":0},{"$f":"Inputs!G$121","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$95","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" Indexation!F$95","v":1.0660540000000001},{"$f":" Indexation!G$95","v":"factor"}]
[]
[null,null,null,null,{"$f":" E339 & \" at 2020 FYE price base\"","v":"Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F339 * F341","v":0},"£m"]
[]
[{"$f":" Inputs!A$122","v":"C_APP27032_PD002"},null,null,null,{"$f":" Inputs!E$122","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway"},{"$f":" Inputs!F$122","v":0},{"$f":" Inputs!G$122","v":"£m"}]
[{"$f":"Inputs!A$123","v":"APP8009DMMY"},null,null,null,{"$f":"Inputs!E$123","v":"Dummy: RCV adjustment from totex menu model"},{"$f":"Inputs!F$123","v":0},{"$f":"Inputs!G$123","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.2125588155716769},{"$f":" Indexation!G$82","v":"factor"}]
[]
[null,null,null,null,{"$f":" E345 & \" at 2020 FYE price base\"","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway at 2020 FYE price base"},{"$f":" F345 * F$348","v":0},"£m"]
[null,null,null,null,{"$f":" E346 & \" at 2020 FYE price base\"","v":"Dummy: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F346 * F$348","v":0},"£m"]
[]
[{"$f":"Inputs!A$124","v":"APP33021DMMY"},null,null,null,{"$f":"Inputs!E$124","v":"Dummy ~ Other adjustment to wholesale RCV"},{"$f":"Inputs!F$124","v":0},{"$f":"Inputs!G$124","v":"£m"}]
[{"$f":"Inputs!A$125","v":"Manual input if required"},null,null,null,{"$f":"Inputs!E$125","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land"},{"$f":"Inputs!F$125","v":0},{"$f":"Inputs!G$125","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$95","v":"RPI inflate from 2018 FYE to 2020 FYE"},{"$f":" Indexation!F$95","v":1.0660540000000001},{"$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.0792063834611536},{"$f":" Indexation!G$89","v":"factor"}]
[]
[null,null,null,null,{"$f":" E353 & \" at 2020 FYE price base\"","v":"Dummy ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":" F353 * F356","v":0},"£m"]
[null,null,null,null,{"$f":" E354 & \" at 2020 FYE price base\"","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":" F354 * F357","v":0},"£m"]
[]
[null,null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[null,null,null,null,{"$f":" E$343","v":"Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":" F$343","v":0},"£m"]
[null,null,null,null,{"$f":" E$350","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway at 2020 FYE price base"},{"$f":" F$350","v":0},{"$f":" G$350","v":"£m"}]
[null,null,null,null,{"$f":"E$351","v":"Dummy: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":"F$351","v":0},"£m"]
[null,null,null,null,{"$f":"E$359","v":"Dummy ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":"F$359","v":0},"£m"]
[null,null,null,null,{"$f":"E$360","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":"F$360","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$106","v":"CPIH deflate from 2020 FYE to 2018 FYE"},{"$f":" Indexation!F$106","v":0.95647649363369236},{"$f":" Indexation!G$106","v":"factor"}]
[]
["C_APP8002DMMY",null,null,null,"Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYE CPIH deflated price base",{"$f":" F363 * F$369","v":0},"£m"]
["C_APP8006DMMY",null,null,null,"ODI end of period RCV adjustment allocated to dummy at 2017-18 FYE CPIH deflated price base",{"$f":" F364 * F$369","v":0},"£m"]
["C_APP8008DMMY",null,null,null,"Dummy ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base",{"$f":" F365 * F$369","v":0},"£m"]
["C_APP8005DMMY",null,null,null,"Dummy ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base",{"$f":" F366 * F$369","v":0},"£m"]
["C_APP8009DMMY",null,null,null,"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base",{"$f":" F367 * F$369","v":0},"£m"]
["C_APP8010DMMY",null,null,null,"Total dummy RCV at 31 March 2020 post midnight adjustments at 2017-18 FYE CPIH deflated price base",{"$f":"SUM(F371:F375)","v":0},"£m"]
[]
[null,null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[null,null,null,null,{"$f":" E$350","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway at 2020 FYE price base"},{"$f":" F$350","v":0},{"$f":" G$350","v":"£m"}]
[null,null,null,null,{"$f":" E$351","v":"Dummy: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$351","v":0},"£m"]
[null,null,null,null,{"$f":"E$359","v":"Dummy ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":"F$359","v":0},"£m"]
[null,null,null,null,{"$f":"E$360","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":"F$360","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
["C_APP27051",null,null,null,"ODI end of period RCV adjustment  ~ Thames Tideway at 2017-18 FYA CPIH deflated price base",{"$f":" F379 * F$384","v":0},"£m"]
["C_WWS15022DMMY",null,null,null,"Dummy ~ Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F380 * F$384","v":0},"£m"]
[null,null,null,null,"Dummy ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F381 * F$384","v":0},"£m"]
["C_A7011DMMY",null,null,null,"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base",{"$f":" F382 * F$384","v":0},"£m"]
[]
[null,null,"IFRS16 RCV adjustments expressed in 2017-18 FYA CPIH deflated price base"]
[{"$f":" Inputs!A$128","v":0},null,null,null,{"$f":" Inputs!E$128","v":"Dummy IFRS16 RCV adjustment"},{"$f":" Inputs!F$128","v":0},{"$f":" Inputs!G$128","v":"£m"}]
[]
[null,null,null,null,{"$f":" Indexation!E$107","v":"CPIH deflate from 2018 FYE to 2018 FYA - IFRS 16"},{"$f":" Indexation!F$107","v":0.99159530605772273},{"$f":" Indexation!G$107","v":"factor"}]
[]
["C_APP8022DMMY",null,null,null,"Dummy IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base",{"$f":" F392 * F$394","v":0},"£m"]
[]
[null,"Total dummy RCV at 31 March 2020 post midnight adjustments at 2020 FYE price base"]
[null,null,null,null,{"$f":"E$343","v":"Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2020 FYE price base"},{"$f":"F$343","v":0},{"$f":"G$343","v":"£m"}]
[null,null,null,null,{"$f":" E$350","v":"Net performance payment / (penalty) applied to RCV for end of period ODI adjustments ~ Thames Tideway at 2020 FYE price base"},{"$f":" F$350","v":0},{"$f":" G$350","v":"£m"}]
[null,null,null,null,{"$f":" E$351","v":"Dummy: RCV adjustment from totex menu model at 2020 FYE price base"},{"$f":" F$351","v":0},"£m"]
[null,null,null,null,{"$f":"E$359","v":"Dummy ~ Other adjustment to wholesale RCV at 2020 FYE price base"},{"$f":"F$359","v":0},"£m"]
[null,null,null,null,{"$f":"E$360","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2020 FYE price base"},{"$f":"F$360","v":0},"£m"]
[null,null,null,null,"Total dummy RCV at 31 March 2020 post midnight adjustments at 2020 FYE price base",{"$f":"SUM(F399:F403)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$404","v":"Total dummy RCV at 31 March 2020 post midnight adjustments at 2020 FYE price base"},{"$f":"F$404","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$126","v":"% of RCV to index by RPI - dummy"},{"$f":" Inputs!F$126","v":0.5},{"$f":" Inputs!G$126","v":"%"}]
[null,null,null,null,"Dummy RPI linked RCV at 2020 FYE price base",{"$f":" F406 * F407","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$404","v":"Total dummy RCV at 31 March 2020 post midnight adjustments at 2020 FYE price base"},{"$f":"F$404","v":0},"£m"]
[null,null,null,null,{"$f":" Inputs!E$126","v":"% of RCV to index by RPI - dummy"},{"$f":" Inputs!F$126","v":0.5},{"$f":" Inputs!G$126","v":"%"}]
[null,null,null,null,"Dummy CPIH linked RCV at 2020 FYE price base",{"$f":" F410 * (1 - F411)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$408","v":"Dummy RPI linked RCV at 2020 FYE price base"},{"$f":" F$408","v":0},"£m"]
[null,null,null,null,{"$f":" E$412","v":"Dummy CPIH linked RCV at 2020 FYE price base"},{"$f":" F$412","v":0},"£m"]
[]
[null,null,null,null,{"$f":" Indexation!E$105","v":"CPIH deflate from 2020 FYE to 2018 FYA"},{"$f":" Indexation!F$105","v":0.94843760144171874},{"$f":" Indexation!G$105","v":"factor"}]
[]
[null,null,null,null,"Dummy 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F414 * F$417","v":0},"£m"]
[null,null,null,null,"Dummy 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base",{"$f":" F415 * F$417","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E396","v":"Dummy IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F396","v":0},{"$f":"G396","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$126","v":"% of RCV to index by RPI - dummy"},{"$f":" Inputs!F$126","v":0.5},{"$f":" Inputs!G$126","v":"%"}]
[null,null,null,null,"Dummy IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F422 * F423","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E396","v":"Dummy IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"F396","v":0},{"$f":"G396","v":"£m"}]
[null,null,null,null,{"$f":" Inputs!E$126","v":"% of RCV to index by RPI - dummy"},{"$f":" Inputs!F$126","v":0.5},{"$f":" Inputs!G$126","v":"%"}]
[null,null,null,null,"Dummy IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base",{"$f":" F426 * (1 - F427)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E419","v":"Dummy 2020 RCV RPI inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F419","v":0},"£m"]
[null,null,null,null,{"$f":"E424","v":"Dummy IFRS16 adjustment RPI inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F424","v":0},"£m"]
["C_APP8014DMMY",null,null,null,"Dummy 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F430 + F431","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E420","v":"Dummy 2020 RCV CPIH inflated ~ 1 April (opening balance excluding IFRS16 adjustment) at 2017-18 CPIH deflated price base"},{"$f":"F420","v":0},"£m"]
[null,null,null,null,{"$f":"E428","v":"Dummy IFRS16 adjustment CPIH inflated RCV at 2017-18 FYA CPIH deflated price base"},{"$f":"F428","v":0},"£m"]
["C_APP8016DMMY",null,null,null,"Dummy 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base",{"$f":" F434 + F435","v":0},"£m"]

{"sheet":"Summary_Output","index":8,"n_rows":103,"n_cols":21,"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":"Summary_Output"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,null,{"$f":" Time!K$25","v":"2014-03-31"},{"$f":" Time!L$25","v":"2015-03-31"},{"$f":" Time!M$25","v":"2016-03-31"},{"$f":" Time!N$25","v":"2017-03-31"},{"$f":" Time!O$25","v":"2018-03-31"},{"$f":" Time!P$25","v":"2019-03-31"},{"$f":" Time!Q$25","v":"2020-03-31"},{"$f":" Time!R$25","v":"2021-03-31"},{"$f":" Time!S$25","v":"2022-03-31"},{"$f":" Time!T$25","v":"2023-03-31"},{"$f":" Time!U$25","v":"2024-03-31"}]
[null,null,null,null,{"$f":" Time!E$80","v":"Timeline label"},null,null,null,null,null,{"$f":" Time!K$80","v":"Pre-Fcst"},{"$f":" Time!L$80","v":"Pre-Fcst"},{"$f":" Time!M$80","v":"Pre-Fcst"},{"$f":" Time!N$80","v":"Pre-Fcst"},{"$f":" Time!O$80","v":"Pre-Fcst"},{"$f":" Time!P$80","v":"Pre-Fcst"},{"$f":" Time!Q$80","v":"Pre-Fcst"},{"$f":" Time!R$80","v":"Forecast"},{"$f":" Time!S$80","v":"Forecast"},{"$f":" Time!T$80","v":"Forecast"},{"$f":" Time!U$80","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$103","v":"Financial year ending"},null,null,null,null,null,{"$f":" Time!K$103","v":2014},{"$f":" Time!L$103","v":2015},{"$f":" Time!M$103","v":2016},{"$f":" Time!N$103","v":2017},{"$f":" Time!O$103","v":2018},{"$f":" Time!P$103","v":2019},{"$f":" Time!Q$103","v":2020},{"$f":" Time!R$103","v":2021},{"$f":" Time!S$103","v":2022},{"$f":" Time!T$103","v":2023},{"$f":" Time!U$103","v":2024}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit",null,null,null,{"$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}]
[]
["WATER SERVICES"]
[]
[null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[{"$f":" Calc!A$47","v":"C_APP8002W"},null,null,null,{"$f":" Calc!E$47","v":"Wholesale water closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base "},{"$f":" Calc!F$47","v":0},{"$f":" Calc!G$47","v":"£m"}]
[{"$f":" Calc!A$48","v":"C_APP8003W"},null,null,null,{"$f":" Calc!E$48","v":"Water ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$48","v":-28.458389879345873},{"$f":" Calc!G$48","v":"£m"}]
[{"$f":" Calc!A$49","v":"C_APP8004W"},null,null,null,{"$f":" Calc!E$49","v":"Water ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$49","v":-58.705782402535036},{"$f":" Calc!G$49","v":"£m"}]
[{"$f":" Calc!A$50","v":"C_APP8005W"},null,null,null,{"$f":" Calc!E$50","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$50","v":-0.84012539266984398},{"$f":" Calc!G$50","v":"£m"}]
[{"$f":" Calc!A$51","v":"C_APP8006W"},null,null,null,{"$f":" Calc!E$51","v":"Water ~ ODI RCV adjustment allocated to Water resources at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$51","v":0},{"$f":" Calc!G$51","v":"£m"}]
[{"$f":" Calc!A$52","v":"C_APP8007W"},null,null,null,{"$f":" Calc!E$52","v":"Water ~ ODI RCV adjustment allocated to Water network plus at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$52","v":0},{"$f":" Calc!G$52","v":"£m"}]
[{"$f":" Calc!A$53","v":"C_APP8008W"},null,null,null,{"$f":" Calc!E$53","v":"Water ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$53","v":-7.7821238815381042},{"$f":" Calc!G$53","v":"£m"}]
[{"$f":" Calc!A$54","v":"C_APP8009W"},null,null,null,{"$f":" Calc!E$54","v":"Water ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$54","v":0},{"$f":" Calc!G$54","v":"£m"}]
[{"$f":" Calc!A$55","v":"C_APP8010W"},null,null,null,{"$f":" Calc!E$55","v":"Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$55","v":-95.786421556088854},{"$f":" Calc!G$55","v":"£m"}]
[]
[null,"Values expressed in 2017-18 FYA CPIH deflated price base on table App8"]
[{"$f":"Calc!A$82","v":"C_APP8022WR"},null,null,null,{"$f":"Calc!E$82","v":"Water resources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$82","v":0},{"$f":"Calc!G$82","v":"£m"}]
[{"$f":" Calc!A$129","v":"C_APP8014WR"},null,null,null,{"$f":" Calc!E$129","v":"Water resources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$129","v":0},{"$f":" Calc!G$129","v":"£m"}]
[{"$f":" Calc!A$133","v":"C_APP8016WR"},null,null,null,{"$f":" Calc!E$133","v":"Water resources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$133","v":0},{"$f":" Calc!G$133","v":"£m"}]
[]
[{"$f":"Calc!A$83","v":"C_APP8022WN"},null,null,null,{"$f":"Calc!E$83","v":"Water network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$83","v":0},{"$f":"Calc!G$83","v":"£m"}]
[{"$f":" Calc!A$168","v":"C_APP8014WN"},null,null,null,{"$f":" Calc!E$168","v":"Water network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$168","v":-47.490682999541995},{"$f":" Calc!G$168","v":"£m"}]
[{"$f":" Calc!A$172","v":"C_APP8016WN"},null,null,null,{"$f":" Calc!E$172","v":"Water network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$172","v":-47.490682999541995},{"$f":" Calc!G$172","v":"£m"}]
[]
[]
[null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base by table"]
[null,null,"Table App9"]
[{"$f":" Calc!A$70","v":"C_A7011W"},null,null,null,{"$f":" Calc!E$70","v":"Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$70","v":-0.83306439587131842},{"$f":" Calc!G$70","v":"£m"}]
[null,null,"Table App25"]
[{"$f":" Calc!A$68","v":"C_APP25003"},null,null,null,{"$f":" Calc!E$68","v":"Water ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$68","v":-28.219205822319971},{"$f":" Calc!G$68","v":"£m"}]
[{"$f":" Calc!A$69","v":"C_APP25007"},null,null,null,{"$f":" Calc!E$69","v":"Water ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$69","v":-58.212378268799803},{"$f":" Calc!G$69","v":"£m"}]
[null,null,"Table App27"]
[{"$f":" Calc!A$71","v":"C_APP27048"},null,null,null,{"$f":" Calc!E$71","v":"ODI end of period RCV adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$71","v":0},{"$f":" Calc!G$71","v":"£m"}]
[{"$f":" Calc!A$72","v":"C_APP27049"},null,null,null,{"$f":" Calc!E$72","v":"ODI end of period RCV adjustment  ~ Water network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$72","v":0},{"$f":" Calc!G$72","v":"£m"}]
[null,null,"Table WS15"]
[{"$f":" Calc!A$73","v":"C_WS15027"},null,null,null,{"$f":" Calc!E$73","v":"Water: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$73","v":-7.7167175120928908},{"$f":" Calc!G$73","v":"£m"}]
[null,null,"No table"]
[{"$f":" Calc!A$74","v":"C030"},null,null,null,{"$f":" Calc!E$74","v":"Water ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$74","v":0},{"$f":" Calc!G$74","v":"£m"}]
[]
[]
["WASTEWATER SERVICES"]
[]
[null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[{"$f":" Calc!A$214","v":"C_APP8002WW"},null,null,null,{"$f":" Calc!E$214","v":"Wholesale wastewater closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base "},{"$f":" Calc!F$214","v":0},{"$f":" Calc!G$214","v":"£m"}]
[{"$f":" Calc!A$215","v":"C_APP8003WW"},null,null,null,{"$f":" Calc!E$215","v":"Wastewater ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$215","v":-2.5029330567713468},{"$f":" Calc!G$215","v":"£m"}]
[{"$f":" Calc!A$216","v":"C_APP8004WW"},null,null,null,{"$f":" Calc!E$216","v":"Wastewater ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$216","v":-75.350451808394268},{"$f":" Calc!G$216","v":"£m"}]
[{"$f":" Calc!A$217","v":"C_APP8005WW"},null,null,null,{"$f":" Calc!E$217","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$217","v":-4.1017926856557683},{"$f":" Calc!G$217","v":"£m"}]
[{"$f":" Calc!A$218","v":"C_APP8006WW"},null,null,null,{"$f":" Calc!E$218","v":"Wastewater ~ ODI RCV adjustment allocated to Wastewater network plus at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$218","v":0},{"$f":" Calc!G$218","v":"£m"}]
[{"$f":" Calc!A$219","v":"C_APP8008WW"},null,null,null,{"$f":" Calc!E$219","v":"Wastewater ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$219","v":-152.2839133262253},{"$f":" Calc!G$219","v":"£m"}]
[{"$f":" Calc!A$220","v":"C_APP8009WW"},null,null,null,{"$f":" Calc!E$220","v":"Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$220","v":0},{"$f":" Calc!G$220","v":"£m"}]
[{"$f":" Calc!A$221","v":"C_APP8010WW"},null,null,null,{"$f":" Calc!E$221","v":"Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$221","v":-234.23909087704669},{"$f":" Calc!G$221","v":"£m"}]
[]
[null,"Values expressed in 2017-18 FYA CPIH deflated price base on table App8"]
[{"$f":"Calc!A$244","v":"C_RCV1011BIO_FYA"},null,null,null,{"$f":"Calc!E$244","v":"Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$244","v":0},{"$f":"Calc!G$244","v":"£m"}]
[{"$f":"Calc!A$253","v":"C_APP8022WWN"},null,null,null,{"$f":"Calc!E$253","v":"Wastewater network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$253","v":0},{"$f":"Calc!G$253","v":"£m"}]
[{"$f":" Calc!A$296","v":"C_APP8014WWN"},null,null,null,{"$f":" Calc!E$296","v":"Wastewater network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$296","v":-116.13519150445393},{"$f":" Calc!G$296","v":"£m"}]
[{"$f":" Calc!A$300","v":"C_APP8016WWN"},null,null,null,{"$f":" Calc!E$300","v":"Wastewater network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$300","v":-116.13519150445393},{"$f":" Calc!G$300","v":"£m"}]
[]
[{"$f":"Calc!A$252","v":"C_APP8022BIO"},null,null,null,{"$f":"Calc!E$252","v":"Bioresources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$252","v":0},{"$f":"Calc!G$252","v":"£m"}]
[{"$f":" Calc!A$329","v":"C_APP8014BIO"},null,null,null,{"$f":" Calc!E$329","v":"Bioresources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$329","v":0},{"$f":" Calc!G$329","v":"£m"}]
[{"$f":" Calc!A$333","v":"C_APP8016BIO"},null,null,null,{"$f":" Calc!E$333","v":"Bioresources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$333","v":0},{"$f":" Calc!G$333","v":"£m"}]
[]
[]
[null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base by table"]
[null,null,"Table App9"]
[{"$f":" Calc!A$235","v":"C_A7011WW"},null,null,null,{"$f":" Calc!E$235","v":"Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$235","v":-4.0673183735181597},{"$f":" Calc!G$235","v":"£m"}]
[null,null,"Table App25"]
[{"$f":" Calc!A$233","v":"C_APP25005"},null,null,null,{"$f":" Calc!E$233","v":"Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$233","v":-2.4818966704711753},{"$f":" Calc!G$233","v":"£m"}]
[{"$f":" Calc!A$234","v":"C_APP25008"},null,null,null,{"$f":" Calc!E$234","v":"Wastewater ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$234","v":-74.717154322532409},{"$f":" Calc!G$234","v":"£m"}]
[null,null,"Table App27"]
[{"$f":" Calc!A$236","v":"C_APP27050"},null,null,null,{"$f":" Calc!E$236","v":"ODI end of period RCV adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$236","v":0},{"$f":" Calc!G$236","v":"£m"}]
[null,null,"Table WWS15"]
[{"$f":" Calc!A$237","v":"C_WWS15022"},null,null,null,{"$f":" Calc!E$237","v":"Wastewater: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$237","v":-151.00401364238613},{"$f":" Calc!G$237","v":"£m"}]
[null,null,"No table"]
[{"$f":" Calc!A$238","v":"C040"},null,null,null,{"$f":" Calc!E$238","v":"Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$238","v":0},{"$f":" Calc!G$238","v":"£m"}]
[]
[]
["DUMMY"]
[]
[null,"Values expressed in 2017-18 FYE CPIH deflated price base for table App8"]
[{"$f":" Calc!A$371","v":"C_APP8002DMMY"},null,null,null,{"$f":" Calc!E$371","v":"Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$371","v":0},{"$f":" Calc!G$371","v":"£m"}]
[{"$f":" Calc!A$372","v":"C_APP8006DMMY"},null,null,null,{"$f":" Calc!E$372","v":"ODI end of period RCV adjustment allocated to dummy at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$372","v":0},{"$f":" Calc!G$372","v":"£m"}]
[{"$f":" Calc!A$373","v":"C_APP8008DMMY"},null,null,null,{"$f":" Calc!E$373","v":"Dummy ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base"},{"$f":" Calc!F$373","v":0},{"$f":" Calc!G$373","v":"£m"}]
[{"$f":"Calc!A$375","v":"C_APP8009DMMY"},null,null,null,{"$f":"Calc!E$375","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base"},{"$f":"Calc!F$375","v":0},{"$f":"Calc!G$375","v":"£m"}]
[{"$f":"Calc!A$374","v":"C_APP8005DMMY"},null,null,null,{"$f":"Calc!E$374","v":"Dummy ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base"},{"$f":"Calc!F$374","v":0},{"$f":"Calc!G$374","v":"£m"}]
[{"$f":"Calc!A$376","v":"C_APP8010DMMY"},null,null,null,{"$f":"Calc!E$376","v":"Total dummy RCV at 31 March 2020 post midnight adjustments at 2017-18 FYE CPIH deflated price base"},{"$f":"Calc!F$376","v":0},{"$f":"Calc!G$376","v":"£m"}]
[]
[null,"Values expressed in 2017-18 FYA CPIH deflated price base on table App8"]
[{"$f":"Calc!A$396","v":"C_APP8022DMMY"},null,null,null,{"$f":"Calc!E$396","v":"Dummy IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$396","v":0},{"$f":"Calc!G$396","v":"£m"}]
[{"$f":" Calc!A$432","v":"C_APP8014DMMY"},null,null,null,{"$f":" Calc!E$432","v":"Dummy 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$432","v":0},{"$f":" Calc!G$432","v":"£m"}]
[{"$f":" Calc!A$436","v":"C_APP8016DMMY"},null,null,null,{"$f":" Calc!E$436","v":"Dummy 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base"},{"$f":" Calc!F$436","v":0},{"$f":" Calc!G$436","v":"£m"}]
[]
[null,"PR14 reconciliation adjustments expressed in 2017-18 FYA CPIH deflated price base by table"]
[null,null,"Table App9"]
[{"$f":"Calc!A$389","v":"C_A7011DMMY"},null,null,null,{"$f":"Calc!E$389","v":"Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base"},{"$f":"Calc!F$389","v":0},{"$f":"Calc!G$389","v":"£m"}]
[null,null,"Table App27"]
[{"$f":" Calc!A$386","v":"C_APP27051"},null,null,null,{"$f":" Calc!E$386","v":"ODI end of period RCV adjustment  ~ Thames Tideway at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$386","v":0},{"$f":" Calc!G$386","v":"£m"}]
[null,null,"Table Dmmy10"]
[{"$f":" Calc!A$387","v":"C_WWS15022DMMY"},null,null,null,{"$f":" Calc!E$387","v":"Dummy ~ Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base"},{"$f":" Calc!F$387","v":0},{"$f":" Calc!G$387","v":"£m"}]

{"sheet":"F_Outputs","index":9,"n_rows":82,"n_cols":8,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19PD010"]
["Acronym","Reference","Item description","Unit","Model","2019-20","2020-21","PR19 application"]
[]
[null,"C001_PR19PD010","1st model column start date","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$13","v":41000}]
[null,"C002_PR19PD010","First modelling column financial year#","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$16","v":2013}]
[null,"C003_PR19PD010","Financial year end month number","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$17","v":3}]
[null,"C004_PR19PD010","Pre - forecast period","Text","Price Review 2019",null,null,{"$f":"Inputs!$F$20","v":"Pre-Fcst"}]
[null,"C005_PR19PD010","Forecast period","Text","Price Review 2019",null,null,{"$f":"Inputs!$F$21","v":"Forecast"}]
[null,"C006_PR19PD010","Post - forecast period","Text","Price Review 2019",null,null,{"$f":"Inputs!$F$22","v":"Post-Fcst"}]
[null,"C007_PR19PD010","Forecast start date","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$26","v":43922}]
[null,"C008_PR19PD010","Forecast duration","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$27","v":5}]
[null,"C009_PR19PD010","Forecast duration (text)","Text","Price Review 2019",null,null,{"$f":"Inputs!$F$28","v":"2020-25"}]
[null,"C010_PR19PD010","Inflation: Year reference for FYA base price 1","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$69","v":2013}]
[null,"C011_PR19PD010","Inflation: Year reference for FYA base price 2","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$70","v":2018}]
[null,"C012_PR19PD010","Inflation: Year reference for FYE base price","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$71","v":2018}]
[null,"C013_PR19PD010","Inflation: Year reference for FYE end price","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$72","v":2020}]
[null,"C014_PR19PD010","Deflation: Year reference for FYE base price","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$76","v":2020}]
[null,"C015_PR19PD010","Deflation: Year reference for FYA end price","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$77","v":2018}]
[null,"C016_PR19PD010","Deflation: Year reference for FYE base price - IFRS 16","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$78","v":2018}]
[null,"C017_PR19PD010","Months per model period","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$133","v":12}]
[null,"C018_PR19PD010","Months in a year","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$135","v":12}]
[null,"C019_PR19PD010","Days in a year","nr","Price Review 2019",null,null,{"$f":"Inputs!$F$137","v":365}]
[null,"C020_PR19PD010","% of RCV to index by RPI - water services","%","Price Review 2019",null,null,{"$f":"Inputs!$F94","v":0.5}]
[null,"C021_PR19PD010","% of RCV to index by RPI - wastewater services","%","Price Review 2019",null,null,{"$f":"Inputs!$F112","v":0.5}]
[null,"C022_PR19PD010","% of RCV to index by RPI - dummy","%","Price Review 2019",null,null,{"$f":"Inputs!$F126","v":0.5}]
[null,"C_APP8002W_PR19PD010","Wholesale water closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base ","£m","Price Review 2019",{"$f":"Summary_Output!$F10","v":0}]
[null,"C_APP8003W_PR19PD010","Water ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F11","v":-28.458389879345873}]
[null,"C_APP8004W_PR19PD010","Water ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F12","v":-58.705782402535036}]
[null,"C_APP8005W_PR19PD010","Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F13","v":-0.84012539266984398}]
[null,"C_APP8006W_PR19PD010","Water ~ ODI RCV adjustment allocated to Water resources at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F14","v":0}]
[null,"C_APP8007W_PR19PD010","Water ~ ODI RCV adjustment allocated to Water network plus at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F15","v":0}]
[null,"C_APP8008W_PR19PD010","Water ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F16","v":-7.7821238815381042}]
[null,"C_APP8009W_PR19PD010","Water ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F17","v":0}]
[null,"C_APP8010W_PR19PD010","Total wholesale water RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F18","v":-95.786421556088854}]
[null,"C_APP8022WR_PR19PD010","Water resources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F21","v":0}]
[null,"C_APP8014WR_PR19PD010","Water resources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F22","v":0}]
[null,"C_APP8016WR_PR19PD010","Water resources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F23","v":0}]
[null,"C_APP8022WN_PR19PD010","Water network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F25","v":0}]
[null,"C_APP8014WN_PR19PD010","Water network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F26","v":-47.490682999541995}]
[null,"C_APP8016WN_PR19PD010","Water network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F27","v":-47.490682999541995}]
[null,"C_A7011W_PR19PD010","Water ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F32","v":-0.83306439587131842}]
[null,"C_APP25003_PR19PD010","Water ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F34","v":-28.219205822319971}]
[null,"C_APP25007_PR19PD010","Water ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F35","v":-58.212378268799803}]
[null,"C_APP27048_PR19PD010","ODI end of period RCV adjustment ~ Water resources at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F37","v":0}]
[null,"C_APP27049_PR19PD010","ODI end of period RCV adjustment  ~ Water network plus at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F38","v":0}]
[null,"C_WS15027_PR19PD010","Water: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F40","v":-7.7167175120928908}]
[null,"C030_PR19PD010","Water ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F42","v":0}]
[null,"C_APP8002WW_PR19PD010","Wholesale wastewater closing RCV at 31 March 2020 before midnight adjustments at 2017-18 FYE CPIH deflated price base ","£m","Price Review 2019",{"$f":"Summary_Output!$F48","v":0}]
[null,"C_APP8003WW_PR19PD010","Wastewater ~ Total adjustment RCV carry forward to PR19 at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F49","v":-2.5029330567713468}]
[null,"C_APP8004WW_PR19PD010","Wastewater ~ CIS RCV inflation correction at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F50","v":-75.350451808394268}]
[null,"C_APP8005WW_PR19PD010","Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F51","v":-4.1017926856557683}]
[null,"C_APP8006WW_PR19PD010","Wastewater ~ ODI RCV adjustment allocated to Wastewater network plus at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F52","v":0}]
[null,"C_APP8008WW_PR19PD010","Wastewater ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F53","v":-152.2839133262253}]
[null,"C_APP8009WW_PR19PD010","Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F54","v":0}]
[null,"C_APP8010WW_PR19PD010","Total wholesale wastewater RCV at 31 March 2020 post midnight adjustments before allocation to price control units at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F55","v":-234.23909087704669}]
[null,"C_RCV1011BIO_FYA_PR19PD010","Bioresources RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F58","v":0}]
[null,"C_APP8022WWN_PR19PD010","Wastewater network plus IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F59","v":0}]
[null,"C_APP8014WWN_PR19PD010","Wastewater network plus RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F60","v":-116.13519150445393}]
[null,"C_APP8016WWN_PR19PD010","Wastewater network plus RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F61","v":-116.13519150445393}]
[null,"C_APP8022BIO_PR19PD010","Bioresources IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F63","v":0}]
[null,"C_APP8014BIO_PR19PD010","Bioresources 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F64","v":0}]
[null,"C_APP8016BIO_PR19PD010","Bioresources 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F65","v":0}]
[null,"C_A7011WW_PR19PD010","Wastewater ~ NPV effect of 50% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F70","v":-4.0673183735181597}]
[null,"C_APP25005_PR19PD010","Wastewater ~ Total Adjustment RCV carry forward to PR19 at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F72","v":-2.4818966704711753}]
[null,"C_APP25008_PR19PD010","Wastewater ~ CIS RCV inflation correction at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F73","v":-74.717154322532409}]
[null,"C_APP27050_PR19PD010","ODI end of period RCV adjustment ~ Wastewater network plus at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F75","v":0}]
[null,"C_WWS15022_PR19PD010","Wastewater: Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F77","v":-151.00401364238613}]
[null,"C040_PR19PD010","Wastewater ~ Other adjustment to wholesale RCV at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F79","v":0}]
[null,"C_APP8002DMMY_PR19PD010","Dummy RCV (prior to midnight adjustments) 31 March 2020 at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F85","v":0}]
[null,"C_APP8006DMMY_PR19PD010","ODI end of period RCV adjustment allocated to dummy at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F86","v":0}]
[null,"C_APP8008DMMY_PR19PD010","Dummy ~ Totex menu RCV adjustment at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F87","v":0}]
[null,"C_APP8009DMMY_PR19PD010","Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F88","v":0}]
[null,"C_APP8005DMMY_PR19PD010","Dummy ~ Other adjustment to wholesale RCV at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F89","v":0}]
[null,"C_APP8010DMMY_PR19PD010","Total dummy RCV at 31 March 2020 post midnight adjustments at 2017-18 FYE CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F90","v":0}]
[null,"C_APP8022DMMY_PR19PD010","Dummy IFRS16 RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F93","v":0}]
[null,"C_APP8014DMMY_PR19PD010","Dummy 2020 RCV RPI inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F94","v":0}]
[null,"C_APP8016DMMY_PR19PD010","Dummy 2020 RCV CPIH inflated ~ 1 April (opening balance) at 2017-18 CPIH deflated price base","£m","Price Review 2019",null,{"$f":"Summary_Output!$F95","v":0}]
[null,"C_A7011DMMY_PR19PD010","Dummy: NPV effect of 100% of proceeds from disposals of interest in land at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F99","v":0}]
[null,"C_APP27051_PR19PD010","ODI end of period RCV adjustment  ~ Thames Tideway at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F101","v":0}]
[null,"C_WWS15022DMMY_PR19PD010","Dummy ~ Totex menu RCV adjustment at 2017-18 FYA CPIH deflated price base","£m","Price Review 2019",{"$f":"Summary_Output!$F103","v":0}]
[null,"PR19QA_D0010_OUT_1","Date & Time for Model PR19D010 PR14 RCV adjustments","Text","Price Review 2019",{"$f":"NOW()","v":"2019-02-05T17:00:27.670"},"2019-02-05T17:00:27.670","2019-02-05T17:00:27.670"]
[null,"PR19QA_D0010_OUT_2","Name & Path of Model PR19D010 PR14 RCV adjustments","Text","Price Review 2019",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"Revenue adjustments feeder model_ANH_IAP.xlsm"},"Revenue adjustments feeder model_ANH_IAP.xlsm","Revenue adjustments feeder model_ANH_IAP.xlsm"]