{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Map & Key","InpActive","Time","Index","Wholesale Water","Wastewater Network-Plus","Output","Checks"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":54,"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":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,3,17,4],[18,3,18,4],[19,3,19,4]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,null,"Model name:","PR19 Revenue Forecasting Incentive Model"]
[null,null,"Version number:",{"$f":" LEFT(D5, FIND(\".\", D5, 1) - 1)","v":"PR19 Revenue Forecasting Incentive Reconciliation Model To publish"}]
[null,null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"PR19 Revenue Forecasting Incentive Reconciliation Model To publish.xlsm"}]
[null,null,"Date:","2018-06-08"]
[null,null,"Author:","Ofwat"]
[null,null,"Author contact information:","pr19@ofwat.gsi.gov.uk"]
[]
[]
[null,null,"Summary of model:","This  illustrative model is designed to show how the Revenue Forecasting Incentive could work over the Pr19 period. "]
[null,null,null,"NB - Prices are nominal prices, unless otherwise stated. "]
[null,null,null,"Follow links >>","Pr19 Final Methodology"]
[]
[null,null,"Known limitations:"]
[]
[null,null,null,"Issue",null,"Details","Model link"]
[null,null,null,"Illustrative Model",null,"This is an initial, illustrative model. We may make refinements to it in due course."]
[null,null,null,"Rulebook",null,"We will update our Revenue Reconcilation Rulebook in due course as appropriate. "]
[null,null,null,"Licence changes",null,"As noted in our Final Methodology document, in due course we will propose a licence modification related to the Revenue Forecasting Incentive. "]
[]
[]
[null,null,"Quality Assurance","The model has been subject to internal Ofwat quality assurance. "]
[]
[]
[]
[]
[null,null,"Feedback:","We would welcome feedback on this model. Please send any feedback to the following email address."]
[null,null,null,"pr19@ofwat.gsi.gov.uk"]
[]
[null,null,"Checks"]
[null,null,null,{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"}]
[null,null,null,{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"}]
[]
["End of sheet"]

{"sheet":"Map & Key","index":1,"n_rows":115,"n_cols":25,"rows_kept":115,"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,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,null,"Calculations",null,null,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,null,null,null,null,null,null,null,null,null,"DOCUMENTATION AND QUALITY CONTROL"]
[]
[null,null,null,null,null,null,null,"INPUTS",null,null,null,null,"CALCULATIONS",null,null,null,null,null,"OUTPUT SUMMARY",null,null,null,null,null,"DOCUMENTATION"]
[]
[]
[null,null,null,null,null,null,null,{"$f":" InpActive!A$1","v":"InpActive"},null,null,null,null,{"$f":" Time!A$1","v":"Time"},null,null,null,null,null,{"$f":" Output!$A$1","v":"Output"},null,null,null,null,null,{"$f":" 'Map & Key'!$A$1","v":"Map & Key"}]
[null,null,null,null,null,null,null,"All the inputs in the respective sheets are brought to this sheet.",null,null,null,null,"The model timeline and flag calculations are done in this sheet.",null,null,null,null,null,"All the outputs in the respective sheets are brought to this sheet.",null,null,null,null,null,"Sheet references and model flow; Sheet tabs color, color coding, abbreviations, range names are mentioned in this sheet."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" Index!A$1","v":"Index"}]
[null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Cover!A1","v":"Cover"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Wholesale Water'!$A$1","v":"Wholesale Water"},null,null,null,null,null,null,null,null,null,null,null,"Overview of model"]
[null,null,null,null,null,null,null,null,null,null,null,null,"All the 'Wholesale Water' related calculations are done in this sheet."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" 'Wastewater Network-Plus'!$A$1","v":"Wastewater Network-Plus"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"All the 'Wholesale Wastewater' 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 color (default Excel tab color)",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 color 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,null,null,null,null,null,null,"Dark Grey shade ",null,"Cell intentially left blank"]
[]
[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,"£m","Great Britain Pound in millions"]
[null,null,null,null,null,null,null,"CALC","Calculation"]
[null,null,null,null,null,null,null,"m","Million"]
[null,null,null,null,null,null,null,"na","Not available / applicable"]
[null,null,null,null,null,null,null,"#","Number"]
[null,null,null,null,null,null,null,"POS","Positive"]
[null,null,null,null,null,null,null,"WaSC","Water and Sewerage company"]
[null,null,null,null,null,null,null,"WoC","Water only company"]
[null,null,null,null,null,null,null,"W","Water"]
[null,null,null,null,null,null,null,"WW","Waste water"]
[]
["End of sheet"]

{"sheet":"InpActive","index":2,"n_rows":144,"n_cols":23,"rows_kept":144,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"FILENAME\", $A$1), LEN(CELL(\"FILENAME\", $A$1)) - SEARCH(\"]\", CELL(\"FILENAME\", $A$1)))","v":"InpActive"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["A: TIME"]
[]
[null,"Timeline setup"]
[]
[null,null,"Timeline start dates"]
[null,null,null,null,"1st model column start date","2014-04-01","date","Date should be the first date of the financial year"]
[]
[null,null,"Financial year inputs"]
[null,null,null,null,"First modelling column financial year#",2015,"year #","Financial model start year"]
[null,null,null,null,"Financial year end month number",3,"month #","Month of financial year end for financial model"]
[]
[null,null,"Timeline labels"]
[null,null,null,null,"Pre - forecast period","Pre-Fcst","label"]
[null,null,null,null,"Forecast period","Forecast","label"]
[null,null,null,null,"Post - forecast period","Post-Fcst","label"]
[]
[null,"Project dates"]
[]
[null,null,null,null,"Forecast start date","2020-04-01","date"]
[null,null,null,null,"Forecast duration",5,"years #"]
[null,null,null,null,"Forecast duration (text)","2020-25","years #","For Info only"]
[]
[]
["B: INDEXATION"]
[]
[null,null,null,null,"2017/18 indexation modelling column financial year#","2017-04-01","year #","Financial model start year"]
[]
[null,"CPIH (all changes are from November to November)"]
[null,null,null,null,"CPIH Index Nov - actual",null,"index",{"$f":"SUM(J35:W35)","v":0}]
[]
[null,null,null,null,"CPIH: Forecast Annual Increase",null,"%"]
[]
[null,null,null,null,"CPIH Index Nov - forecast",null,null,{"$f":"SUM(J39:W39)","v":0},null,{"$f":"IF(J35>0,J35,I39*(1+$F$37))","v":0},{"$f":"IF(K35>0,K35,J39*(1+$F$37))","v":0},{"$f":"IF(L35>0,L35,K39*(1+$F$37))","v":0},{"$f":"IF(M35>0,M35,L39*(1+$F$37))","v":0},{"$f":"IF(N35>0,N35,M39*(1+$F$37))","v":0},{"$f":"IF(O35>0,O35,N39*(1+$F$37))","v":0},{"$f":"IF(P35>0,P35,O39*(1+$F$37))","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,"CPIH Index Nov (from 2017/18) -  override",null,"index",{"$f":"SUM(J41:W41)","v":0}]
[]
[null,null,null,null,"CPIH Index Nov (from 2017/18)",null,"index",{"$f":"SUM(J43:W43)","v":0},null,{"$f":"IF(J41=\"\",J39,J41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["C: MODEL PARAMETERS"]
[]
[null,null,null,null,"Company Name",null,"name","For Info only"]
[]
[null,null,null,null,"Company Type","WaSC","name","For Info only"]
[]
[]
["D: GENERAL PARAMETERS"]
[]
[null,"RFI Parameters"]
[]
[null,null,"Penalty rate scaling"]
[]
[null,null,null,null,"Minimum threshold (+/-)",0.02,"%"]
[]
[null,null,null,null,"Maximum threshold (+/-)",0.03,"%"]
[]
[null,null,null,null,"Penalty rate (+/-)",0.03,"%"]
[]
[null,null,null,null,"Discount rate",null,"%"]
[]
[null,null,null,null,"Threshold for additional variance analyses (+/-)",0.06,"%"]
[]
[null,null,"RCM adjustment"]
[]
[null,null,null,null,"Timing delay",2,"years"]
[]
[]
["E: WATER RESOURCES (Water Res)"]
[]
[null,"Revenue"]
[]
[null,null,null,null,"Allowed revenue - Water Res (base year 2019/2020)",null,"£m"]
[]
[null,null,null,null,"K - Water Res",null,"#",{"$f":"SUM(J79:W79)","v":0}]
[]
[null,null,null,null,"Actual Revenue (to be completed at the end of PR24) - Water Res ",null,"£m",{"$f":"SUM(J81:W81)","v":0}]
[]
[]
[]
["F: WATER NETWORK-PLUS (Water-N+)"]
[]
[null,"Revenue"]
[]
[null,null,null,null,"Allowed revenue - Water-N+ (base year 2019/2020)",null,"£m"]
[]
[null,null,null,null,"K - Water-N+",null,"#",{"$f":"SUM(J91:W91)","v":0}]
[]
[null,null,null,null,"Actual Revenue (to be completed at the end of PR24) - Water-N+ ",null,"£m",{"$f":"SUM(J93:W93)","v":0}]
[]
[null,"RCM adjustment"]
[]
[null,null,null,null,"Blind year adjustment for year 2019/2020 - Water-N+ (base year 2019/2020)",null,"£m"]
[]
[null,null,null,null,"Blind year profiling factor - Water-N+",null,"%",{"$f":"SUM(J99:W99)","v":0}]
[]
[null,null,null,null,"Blind year profiling factor - Water-N+ - Validation",{"$f":"IF(H99>100%, 1, 0)","v":0},"Check"]
[]
[null,"Developer services adjustment (inputs should be consistent with 2E.7 of the APR)"]
[]
[null,null,null,null,"Allowed revenue: developer services - Water-N+ (base year 2017/2018)",null,"£m",{"$f":"SUM(J105:W105)","v":0}]
[]
[null,null,null,null,"Actual revenue: developer services - Water-N+ ",null,"£m",{"$f":"SUM(J107:W107)","v":0}]
[]
[]
[]
["G: WASTEWATER NETWORK-PLUS (WW-N+)"]
[]
[null,"Revenue"]
[]
[null,null,null,null,"Allowed revenue - WW-N+ (base year 2019/2020)",null,"£m"]
[]
[null,null,null,null,"K - WW-N+",null,"#",{"$f":"SUM(J117:W117)","v":0}]
[]
[null,null,null,null,"Actual Revenue (to be completed post PR24) - WW-N+ ",null,"£m",{"$f":"SUM(J119:W119)","v":0}]
[]
[null,"RCM adjustment"]
[]
[null,null,null,null,"Blind year adjustment for year 2019/2020 - WW-N+ (base year 2019/2020)",null,"£m"]
[]
[null,null,null,null,"Blind year profiling factor - WW-N+ ",null,"%",{"$f":"SUM(J125:W125)","v":0}]
[]
[null,null,null,null,"Blind year profiling factor - WW-N+ - Validation",{"$f":"IF(H125>100%, 1, 0)","v":0},"Check"]
[]
[null,"Developer services adjustment (inputs should be consistent with 2E.7 of the APR)"]
[]
[null,null,null,null,"Allowed revenue: developer services - WW-N+ (base year 2017/2018)",null,"£m",{"$f":"SUM(J131:W131)","v":0}]
[]
[null,null,null,null,"Actual revenue: developer services - WW-N+ ",null,"£m",{"$f":"SUM(J133:W133)","v":0}]
[]
[]
[]
["H: NON CHANGEABLE MODEL TECHNICAL INPUTS"]
[]
[null,null,null,null,"Months per model period",12,"months"]
[]
[null,null,null,null,"Unit conversion to percentage",100,"#"]
[]
[]
["End of sheet"]

{"sheet":"Time","index":3,"n_rows":133,"n_cols":23,"rows_kept":133,"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"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["MODEL PERIOD"]
[]
[null,"Model column counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I10 + 1","v":1},{"$f":" J10 + 1","v":2},{"$f":" K10 + 1","v":3},{"$f":" L10 + 1","v":4},{"$f":" M10 + 1","v":5},{"$f":" N10 + 1","v":6},{"$f":" O10 + 1","v":7},{"$f":" P10 + 1","v":8},{"$f":" Q10 + 1","v":9},{"$f":" R10 + 1","v":10},{"$f":" S10 + 1","v":11},12,13,14]
[null,null,null,null,"Model column total",{"$f":" MAX(J10:W10)","v":14},"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,{"$f":" T$10","v":11},12,13,14]
[null,null,null,null,"1st model column flag",null,"flag",{"$f":" SUM(J14:W14)","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},0,0,0]
[]
[null,"Model period beginning"]
[null,null,null,null,{"$f":" InpActive!E$12","v":"1st model column start date"},{"$f":" InpActive!F$12","v":"2014-04-01"},{"$f":" InpActive!G$12","v":"date"},{"$f":" InpActive!H$12","v":"Date should be the first date of the financial year"},{"$f":" InpActive!I$12","v":"00:00:00"},{"$f":" InpActive!J$12","v":"00:00:00"},{"$f":" InpActive!K$12","v":"00:00:00"},{"$f":" InpActive!L$12","v":"00:00:00"},{"$f":" InpActive!M$12","v":"00:00:00"},{"$f":" InpActive!N$12","v":"00:00:00"},{"$f":" InpActive!O$12","v":"00:00:00"},{"$f":" InpActive!P$12","v":"00:00:00"},{"$f":" InpActive!Q$12","v":"00:00:00"},{"$f":" InpActive!R$12","v":"00:00:00"},{"$f":" InpActive!S$12","v":"00:00:00"},{"$f":" InpActive!T$12","v":"00:00:00"},{"$f":" InpActive!U$12","v":"00:00:00"},{"$f":" InpActive!V$12","v":"00:00:00"},{"$f":" InpActive!W$12","v":"00:00:00"}]
[null,null,null,null,{"$f":" InpActive!E$139","v":"Months per model period"},{"$f":" InpActive!F$139","v":12},{"$f":" InpActive!G$139","v":"months"},{"$f":" InpActive!H$139","v":0},{"$f":" InpActive!I$139","v":0},{"$f":" InpActive!J$139","v":0},{"$f":" InpActive!K$139","v":0},{"$f":" InpActive!L$139","v":0},{"$f":" InpActive!M$139","v":0},{"$f":" InpActive!N$139","v":0},{"$f":" InpActive!O$139","v":0},{"$f":" InpActive!P$139","v":0},{"$f":" InpActive!Q$139","v":0},{"$f":" InpActive!R$139","v":0},{"$f":" InpActive!S$139","v":0},{"$f":" InpActive!T$139","v":0},{"$f":" InpActive!U$139","v":0},{"$f":" InpActive!V$139","v":0},{"$f":" InpActive!W$139","v":0}]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,{"$f":" J$14","v":1},0,0,0,0,0,0,0,0,0,{"$f":" T$14","v":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":"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",{"$f":" IF(S19 = 1, $F17, DATE(YEAR(R20), MONTH(R20) + $F18, DAY(1)))","v":"2023-04-01"},{"$f":" IF(T19 = 1, $F17, DATE(YEAR(S20), MONTH(S20) + $F18, DAY(1)))","v":"2024-04-01"},"2025-04-01","2026-04-01","2027-04-01"]
[]
[null,"Model period ending"]
[null,null,null,null,{"$f":" InpActive!E$139","v":"Months per model period"},{"$f":" InpActive!F$139","v":12},{"$f":" InpActive!G$139","v":"months"},{"$f":" InpActive!H$139","v":0},{"$f":" InpActive!I$139","v":0},{"$f":" InpActive!J$139","v":0},{"$f":" InpActive!K$139","v":0},{"$f":" InpActive!L$139","v":0},{"$f":" InpActive!M$139","v":0},{"$f":" InpActive!N$139","v":0},{"$f":" InpActive!O$139","v":0},{"$f":" InpActive!P$139","v":0},{"$f":" InpActive!Q$139","v":0},{"$f":" InpActive!R$139","v":0},{"$f":" InpActive!S$139","v":0},{"$f":" InpActive!T$139","v":0},{"$f":" InpActive!U$139","v":0},{"$f":" InpActive!V$139","v":0},{"$f":" InpActive!W$139","v":0}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$20","v":"2024-04-01"},"2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,"Model period ending",null,"date",null,null,{"$f":" DATE(YEAR(J24), MONTH(J24) + $F23, DAY(J24) - 1)","v":"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",{"$f":" DATE(YEAR(S24), MONTH(S24) + $F23, DAY(S24) - 1)","v":"2024-03-31"},{"$f":" DATE(YEAR(T24), MONTH(T24) + $F23, DAY(T24) - 1)","v":"2025-03-31"},"2026-03-31","2027-03-31","2028-03-31"]
[]
[]
[null,"2017/18 indexation start period flag"]
[null,null,null,null,{"$f":" InpActive!E$32","v":"2017/18 indexation modelling column financial year#"},{"$f":" InpActive!F$32","v":"2017-04-01"},{"$f":" InpActive!G$32","v":"year #"},{"$f":" InpActive!H$32","v":"Financial model start year"},{"$f":" InpActive!I$32","v":"00:00:00"},{"$f":" InpActive!J$32","v":"00:00:00"},{"$f":" InpActive!K$32","v":"00:00:00"},{"$f":" InpActive!L$32","v":"00:00:00"},{"$f":" InpActive!M$32","v":"00:00:00"},{"$f":" InpActive!N$32","v":"00:00:00"},{"$f":" InpActive!O$32","v":"00:00:00"},{"$f":" InpActive!P$32","v":"00:00:00"},{"$f":" InpActive!Q$32","v":"00:00:00"},{"$f":" InpActive!R$32","v":"00:00:00"},{"$f":" InpActive!S$32","v":"00:00:00"},{"$f":" InpActive!T$32","v":"00:00:00"},{"$f":" InpActive!U$32","v":"00:00:00"},{"$f":" InpActive!V$32","v":"00:00:00"},{"$f":" InpActive!W$32","v":"00:00:00"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2014-04-01","2015-04-01","2016-04-01","2017-04-01","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2015-03-31","2016-03-31","2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"2017/18 indexation period flag",null,"flag",{"$f":" SUM(J32:W32)","v":1},null,{"$f":" IF(AND($F29 >= J30, $F29 <= J31), 1, 0)","v":0},{"$f":" IF(AND($F29 >= K30, $F29 <= K31), 1, 0)","v":0},0,{"$f":" IF(AND($F29 >= M30, $F29 <= M31), 1, 0)","v":1},0,0,{"$f":" IF(AND($F29 >= P30, $F29 <= P31), 1, 0)","v":0},{"$f":" IF(AND($F29 >= Q30, $F29 <= Q31), 1, 0)","v":0},0,{"$f":" IF(AND($F29 >= S30, $F29 <= S31), 1, 0)","v":0},{"$f":" IF(AND($F29 >= T30, $F29 <= T31), 1, 0)","v":0},0,0,0]
[]
[]
[]
[]
[]
["FORECAST PERIOD"]
[]
[null,"Forecast start period flag"]
[null,null,null,null,{"$f":" InpActive!E$25","v":"Forecast start date"},{"$f":" InpActive!F$25","v":"2020-04-01"},{"$f":" InpActive!G$25","v":"date"},{"$f":" InpActive!H$25","v":"00:00:00"},{"$f":" InpActive!I$25","v":"00:00:00"},{"$f":" InpActive!J$25","v":"00:00:00"},{"$f":" InpActive!K$25","v":"00:00:00"},{"$f":" InpActive!L$25","v":"00:00:00"},{"$f":" InpActive!M$25","v":"00:00:00"},{"$f":" InpActive!N$25","v":"00:00:00"},{"$f":" InpActive!O$25","v":"00:00:00"},{"$f":" InpActive!P$25","v":"00:00:00"},{"$f":" InpActive!Q$25","v":"00:00:00"},{"$f":" InpActive!R$25","v":"00:00:00"},{"$f":" InpActive!S$25","v":"00:00:00"},{"$f":" InpActive!T$25","v":"00:00:00"},{"$f":" InpActive!U$25","v":"00:00:00"},{"$f":" InpActive!V$25","v":"00:00:00"},{"$f":" InpActive!W$25","v":"00:00:00"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$20","v":"2024-04-01"},"2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$25","v":"2025-03-31"},"2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"Forecast start period flag",null,"flag",{"$f":" SUM(J44:W44)","v":1},null,{"$f":" IF(AND($F41 >= J42, $F41 <= J43), 1, 0)","v":0},{"$f":" IF(AND($F41 >= K42, $F41 <= K43), 1, 0)","v":0},0,0,0,0,{"$f":" IF(AND($F41 >= P42, $F41 <= P43), 1, 0)","v":1},0,0,{"$f":" IF(AND($F41 >= S42, $F41 <= S43), 1, 0)","v":0},{"$f":" IF(AND($F41 >= T42, $F41 <= T43), 1, 0)","v":0},0,0,0]
[]
[null,"Forecast end period flag"]
[null,null,null,null,{"$f":" InpActive!E$25","v":"Forecast start date"},{"$f":" InpActive!F$25","v":"2020-04-01"},{"$f":" InpActive!G$25","v":"date"},{"$f":" InpActive!H$25","v":"00:00:00"},{"$f":" InpActive!I$25","v":"00:00:00"},{"$f":" InpActive!J$25","v":"00:00:00"},{"$f":" InpActive!K$25","v":"00:00:00"},{"$f":" InpActive!L$25","v":"00:00:00"},{"$f":" InpActive!M$25","v":"00:00:00"},{"$f":" InpActive!N$25","v":"00:00:00"},{"$f":" InpActive!O$25","v":"00:00:00"},{"$f":" InpActive!P$25","v":"00:00:00"},{"$f":" InpActive!Q$25","v":"00:00:00"},{"$f":" InpActive!R$25","v":"00:00:00"},{"$f":" InpActive!S$25","v":"00:00:00"},{"$f":" InpActive!T$25","v":"00:00:00"},{"$f":" InpActive!U$25","v":"00:00:00"},{"$f":" InpActive!V$25","v":"00:00:00"},{"$f":" InpActive!W$25","v":"00:00:00"}]
[null,null,null,null,{"$f":" InpActive!E$26","v":"Forecast duration"},{"$f":" InpActive!F$26","v":5},{"$f":" InpActive!G$26","v":"years #"},{"$f":" InpActive!H$26","v":0},{"$f":" InpActive!I$26","v":0},{"$f":" InpActive!J$26","v":0},{"$f":" InpActive!K$26","v":0},{"$f":" InpActive!L$26","v":0},{"$f":" InpActive!M$26","v":0},{"$f":" InpActive!N$26","v":0},{"$f":" InpActive!O$26","v":0},{"$f":" InpActive!P$26","v":0},{"$f":" InpActive!Q$26","v":0},{"$f":" InpActive!R$26","v":0},{"$f":" InpActive!S$26","v":0},{"$f":" InpActive!T$26","v":0},{"$f":" InpActive!U$26","v":0},{"$f":" InpActive!V$26","v":0},{"$f":" InpActive!W$26","v":0}]
[null,null,null,null,"Forecast end date",{"$f":" DATE(YEAR(F47) + F48, MONTH(F47), DAY(F47) - 1)","v":"2025-03-31"},"date"]
[]
[null,null,null,null,{"$f":" E$49","v":"Forecast end date"},{"$f":" F$49","v":"2025-03-31"},{"$f":" G$49","v":"date"},{"$f":" H$49","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$20","v":"2024-04-01"},"2025-04-01","2026-04-01","2027-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$25","v":"2025-03-31"},"2026-03-31","2027-03-31","2028-03-31"]
[null,null,null,null,"Forecast end period flag",null,"flag",{"$f":" SUM(J54:W54)","v":1},null,{"$f":" IF(AND($F51 >= J52, $F51 <= J53), 1, 0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":" IF(AND($F51 >= T52, $F51 <= T53), 1, 0)","v":1},0,0,0]
[]
[null,"Forecast period flag"]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},"flag",1,0,{"$f":" J$44","v":0},0,0,0,0,0,1,0,0,0,{"$f":" T$44","v":0},0,0,0]
[null,null,null,null,{"$f":" E$54","v":"Forecast end period flag"},{"$f":" F$54","v":0},"flag",1,0,{"$f":" J$54","v":0},0,0,0,0,0,0,0,0,0,{"$f":" T$54","v":1},0,0,0]
[null,null,null,null,"Forecast period flag",null,"flag",{"$f":" SUM(J59:W59)","v":5},null,{"$f":" J57 + I59 - I58","v":0},{"$f":" K57 + J59 - J58","v":0},0,0,0,0,1,1,1,{"$f":" S57 + R59 - R58","v":1},{"$f":" T57 + S59 - S58","v":1},0,0,0]
[null,null,null,null,"Total number of forecast periods ",{"$f":" SUM(J59:W59)","v":5},"periods"]
[]
[null,"Forecast period counter"]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},{"$f":" G$44","v":"flag"},1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$59","v":"Forecast period flag"},0,"flag",5,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0]
[null,null,null,null,{"$f":" E$54","v":"Forecast end period flag"},{"$f":" F$54","v":0},{"$f":" G$54","v":"flag"},1,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"Forecast period counter",null,"counter",null,null,{"$f":" IF(J63 = 1, 1, I66 + J64 - I65) * J64","v":0},0,0,0,0,0,1,2,3,4,5,0,0,0]
[]
[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,{"$f":" J$14","v":1},0,0,0,0,0,0,0,0,0,{"$f":" T$14","v":0},0,0,0]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},"flag",1,0,{"$f":" J$44","v":0},0,0,0,0,0,1,0,0,0,{"$f":" T$44","v":0},0,0,0]
[null,null,null,null,"Pre-forecast period flag",null,"flag",{"$f":" SUM(J71:W71)","v":6},null,{"$f":" J69 + I71 - J70","v":1},{"$f":" K69 + J71 - K70","v":1},1,1,1,1,0,0,0,{"$f":" S69 + R71 - S70","v":0},{"$f":" T69 + S71 - T70","v":0},0,0,0]
[null,null,null,null,"Pre-forecast period flag - total",{"$f":" SUM(J71:W71)","v":6},"periods"]
[]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},"flag",1,0,{"$f":" J$44","v":0},0,0,0,0,0,1,0,0,0,{"$f":" T$44","v":0},0,0,0]
[null,null,null,null,"Last pre-forecast period flag",null,"flag",{"$f":" SUM(J75:W75)","v":1},null,{"$f":" K74","v":0},{"$f":" L74","v":0},0,0,0,1,0,0,{"$f":" S74","v":0},0,0,0,0,0]
[]
[null,"First post-forecast period flag"]
[null,null,null,null,{"$f":" E$54","v":"Forecast end period flag"},{"$f":" F$54","v":0},"flag",1,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$54","v":1},0,0,0]
[null,null,null,null,"First post-forecast period flag",null,"flag",{"$f":" SUM(J79:W79)","v":1},null,{"$f":" I78","v":0},{"$f":" J78","v":0},0,0,0,0,0,0,0,{"$f":" R78","v":0},{"$f":" S78","v":0},1,0,0]
[]
[null,"Post-forecast period flag"]
[null,null,null,null,{"$f":" E$79","v":"First post-forecast period flag"},0,"flag",1,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$79","v":0},1,0,0]
[null,null,null,null,"Post-forecast period flag",null,"flag",{"$f":" SUM(J83:W83)","v":3},null,{"$f":" J82 + I83","v":0},{"$f":" K82 + J83","v":0},0,0,0,0,0,0,0,{"$f":" S82 + R83","v":0},{"$f":" T82 + S83","v":0},1,1,1]
[null,null,null,null,"Post-forecast period - total",{"$f":" SUM(J83:W83)","v":3},"periods"]
[]
[null,"Model period flag"]
[null,null,null,null,{"$f":" E$59","v":"Forecast period flag"},{"$f":" F$59","v":0},"flag",5,0,{"$f":" J$59","v":0},0,0,0,0,0,1,1,1,1,{"$f":" T$59","v":1},0,0,0]
[null,null,null,null,{"$f":" E$71","v":"Pre-forecast period flag"},{"$f":" F$71","v":0},"flag",6,0,{"$f":" J$71","v":1},1,1,1,1,1,0,0,0,0,{"$f":" T$71","v":0},0,0,0]
[null,null,null,null,"Model period flag",null,"flag",{"$f":" SUM(J89:W89)","v":11},null,{"$f":" MAX(J87:J88)","v":1},{"$f":" MAX(K87:K88)","v":1},1,1,1,1,1,1,1,1,{"$f":" MAX(T87:T88)","v":1},0,0,0]
[]
[null,"Forecast year"]
[null,null,null,null,{"$f":" E$131","v":"Financial year ending"},{"$f":" F$131","v":0},"year #",0,0,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,{"$f":" T$131","v":2025},2026,2027,2028]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},"flag",1,0,0,0,0,0,0,0,1,0,0,0,{"$f":" T$44","v":0},0,0,0]
[null,null,null,null,"Forecast year 1",{"$f":" SUMPRODUCT(J93:W93, J92:W92)","v":2021},"year #"]
[]
[]
["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,{"$f":" T$14","v":0},0,0,0]
[null,null,null,null,{"$f":" E$44","v":"Forecast start period flag"},{"$f":" F$44","v":0},"flag",1,0,{"$f":" J$44","v":0},0,0,0,0,0,1,0,0,0,{"$f":" T$44","v":0},0,0,0]
[null,null,null,null,{"$f":" E$79","v":"First post-forecast period flag"},0,"flag",1,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$79","v":0},1,0,0]
[null,null,null,null,"Timeline label counter",null,"counter",null,null,{"$f":" I103 + SUM(J100:J102)","v":1},1,1,1,1,1,2,2,2,{"$f":" R103 + SUM(S100:S102)","v":2},{"$f":" S103 + SUM(T100:T102)","v":2},3,3,3]
[]
[null,null,null,null,{"$f":" InpActive!E$19","v":"Pre - forecast period"},{"$f":" InpActive!F$19","v":"Pre-Fcst"},{"$f":" InpActive!G$19","v":"label"},{"$f":" InpActive!H$19","v":0},{"$f":" InpActive!I$19","v":0},{"$f":" InpActive!J$19","v":0},{"$f":" InpActive!K$19","v":0},{"$f":" InpActive!L$19","v":0},{"$f":" InpActive!M$19","v":0},{"$f":" InpActive!N$19","v":0},{"$f":" InpActive!O$19","v":0},{"$f":" InpActive!P$19","v":0},{"$f":" InpActive!Q$19","v":0},{"$f":" InpActive!R$19","v":0},{"$f":" InpActive!S$19","v":0},{"$f":" InpActive!T$19","v":0},{"$f":" InpActive!U$19","v":0},{"$f":" InpActive!V$19","v":0},{"$f":" InpActive!W$19","v":0}]
[null,null,null,null,{"$f":" InpActive!E$20","v":"Forecast period"},{"$f":" InpActive!F$20","v":"Forecast"},{"$f":" InpActive!G$20","v":"label"},{"$f":" InpActive!H$20","v":0},{"$f":" InpActive!I$20","v":0},{"$f":" InpActive!J$20","v":0},{"$f":" InpActive!K$20","v":0},{"$f":" InpActive!L$20","v":0},{"$f":" InpActive!M$20","v":0},{"$f":" InpActive!N$20","v":0},{"$f":" InpActive!O$20","v":0},{"$f":" InpActive!P$20","v":0},{"$f":" InpActive!Q$20","v":0},{"$f":" InpActive!R$20","v":0},{"$f":" InpActive!S$20","v":0},{"$f":" InpActive!T$20","v":0},{"$f":" InpActive!U$20","v":0},{"$f":" InpActive!V$20","v":0},{"$f":" InpActive!W$20","v":0}]
[null,null,null,null,{"$f":" InpActive!E$21","v":"Post - forecast period"},{"$f":" InpActive!F$21","v":"Post-Fcst"},{"$f":" InpActive!G$21","v":"label"},{"$f":" InpActive!H$21","v":0},{"$f":" InpActive!I$21","v":0},{"$f":" InpActive!J$21","v":0},{"$f":" InpActive!K$21","v":0},{"$f":" InpActive!L$21","v":0},{"$f":" InpActive!M$21","v":0},{"$f":" InpActive!N$21","v":0},{"$f":" InpActive!O$21","v":0},{"$f":" InpActive!P$21","v":0},{"$f":" InpActive!Q$21","v":0},{"$f":" InpActive!R$21","v":0},{"$f":" InpActive!S$21","v":0},{"$f":" InpActive!T$21","v":0},{"$f":" InpActive!U$21","v":0},{"$f":" InpActive!V$21","v":0},{"$f":" InpActive!W$21","v":0}]
[null,null,null,null,{"$f":" E$103","v":"Timeline label counter"},0,"counter",0,0,1,1,1,1,1,1,2,2,2,2,{"$f":" T$103","v":2},3,3,3]
[null,null,null,null,"Timeline label",null,"label",null,null,{"$f":" INDEX($F105:$F107, J108)","v":"Pre-Fcst"},"Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Pre-Fcst","Forecast","Forecast","Forecast",{"$f":" INDEX($F105:$F107, S108)","v":"Forecast"},{"$f":" INDEX($F105:$F107, T108)","v":"Forecast"},"Post-Fcst","Post-Fcst","Post-Fcst"]
[]
[null,"Modelling period check"]
[null,null,null,null,{"$f":" E$71","v":"Pre-forecast period flag"},{"$f":" F$71","v":0},"flag",6,0,{"$f":" J$71","v":1},1,1,1,1,1,0,0,0,0,{"$f":" T$71","v":0},0,0,0]
[null,null,null,null,{"$f":" E$59","v":"Forecast period flag"},{"$f":" F$59","v":0},"flag",5,0,{"$f":" J$59","v":0},0,0,0,0,0,1,1,1,1,{"$f":" T$59","v":1},0,0,0]
[null,null,null,null,{"$f":" E$83","v":"Post-forecast period flag"},0,"flag",3,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$83","v":0},1,1,1]
[null,null,null,null,"No. of overlapping in flags",null,"#",{"$f":" SUM(J115:W115)","v":0},null,{"$f":" MAX(0, SUM(J112:J114) - 1)","v":0},0,0,0,0,0,0,0,0,{"$f":" MAX(0, SUM(S112:S114) - 1)","v":0},{"$f":" MAX(0, SUM(T112:T114) - 1)","v":0},0,0,0]
[null,null,null,null,"Overlapping in periods - total",{"$f":" SUM(J115:W115)","v":0},"periods"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column total"},{"$f":" F$11","v":14},{"$f":" G$11","v":"columns"},{"$f":" H$11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$116","v":"Overlapping in periods - total"},{"$f":" F$116","v":0},{"$f":" G$116","v":"periods"},{"$f":" H$116","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$72","v":"Pre-forecast period flag - total"},{"$f":" F$72","v":6},{"$f":" G$72","v":"periods"},{"$f":" H$72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$60","v":"Total number of forecast periods "},{"$f":" F$60","v":5},{"$f":" G$60","v":"periods"},{"$f":" H$60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$84","v":"Post-forecast period - total"},{"$f":" F$84","v":3},{"$f":" G$84","v":"periods"},{"$f":" H$84","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Modelling period check",{"$f":" IF(SUM(F118:F119) - SUM(F120:F122) <> 0, 1, 0)","v":0},"check"]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":" InpActive!E$15","v":"First modelling column financial year#"},{"$f":" InpActive!F$15","v":2015},{"$f":" InpActive!G$15","v":"year #"},{"$f":" InpActive!H$15","v":"Financial model start year"},{"$f":" InpActive!I$15","v":0},{"$f":" InpActive!J$15","v":0},{"$f":" InpActive!K$15","v":0},{"$f":" InpActive!L$15","v":0},{"$f":" InpActive!M$15","v":0},{"$f":" InpActive!N$15","v":0},{"$f":" InpActive!O$15","v":0},{"$f":" InpActive!P$15","v":0},{"$f":" InpActive!Q$15","v":0},{"$f":" InpActive!R$15","v":0},{"$f":" InpActive!S$15","v":0},{"$f":" InpActive!T$15","v":0},{"$f":" InpActive!U$15","v":0},{"$f":" InpActive!V$15","v":0},{"$f":" InpActive!W$15","v":0}]
[null,null,null,null,{"$f":" InpActive!E$16","v":"Financial year end month number"},{"$f":" InpActive!F$16","v":3},{"$f":" InpActive!G$16","v":"month #"},{"$f":" InpActive!H$16","v":"Month of financial year end for financial model"},{"$f":" InpActive!I$16","v":0},{"$f":" InpActive!J$16","v":0},{"$f":" InpActive!K$16","v":0},{"$f":" InpActive!L$16","v":0},{"$f":" InpActive!M$16","v":0},{"$f":" InpActive!N$16","v":0},{"$f":" InpActive!O$16","v":0},{"$f":" InpActive!P$16","v":0},{"$f":" InpActive!Q$16","v":0},{"$f":" InpActive!R$16","v":0},{"$f":" InpActive!S$16","v":0},{"$f":" InpActive!T$16","v":0},{"$f":" InpActive!U$16","v":0},{"$f":" InpActive!V$16","v":0},{"$f":" InpActive!W$16","v":0}]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","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",{"$f":" T$25","v":"2025-03-31"},"2026-03-31","2027-03-31","2028-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,{"$f":" T$14","v":0},0,0,0]
[null,null,null,null,"Financial year ending",null,"year #",null,null,{"$f":" IF(J130 = 1, $F127, IF(J129 > (DATE(I131, $F128 + 1, 1) - 1), I131 + 1, I131))","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,{"$f":" IF(S130 = 1, $F127, IF(S129 > (DATE(R131, $F128 + 1, 1) - 1), R131 + 1, R131))","v":2024},{"$f":" IF(T130 = 1, $F127, IF(T129 > (DATE(S131, $F128 + 1, 1) - 1), S131 + 1, S131))","v":2025},2026,2027,2028]
[]
["End of sheet"]

{"sheet":"Index","index":4,"n_rows":58,"n_cols":23,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Index"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["CPIH INDEXATION"]
[]
[null,"CPI(H): Nov % increase"]
[null,null,null,null,{"$f":"InpActive!E$43","v":"CPIH Index Nov (from 2017/18)"},{"$f":"InpActive!F$43","v":0},{"$f":"InpActive!G$43","v":"index"},{"$f":"InpActive!H$43","v":0},{"$f":"InpActive!I$43","v":0},{"$f":"InpActive!J$43","v":0},{"$f":"InpActive!K$43","v":0},{"$f":"InpActive!L$43","v":0},{"$f":"InpActive!M$43","v":0},{"$f":"InpActive!N$43","v":0},{"$f":"InpActive!O$43","v":0},{"$f":"InpActive!P$43","v":0},{"$f":"InpActive!Q$43","v":0},{"$f":"InpActive!R$43","v":0},{"$f":"InpActive!S$43","v":0},{"$f":"InpActive!T$43","v":0},{"$f":"InpActive!U$43","v":0},{"$f":"InpActive!V$43","v":0},{"$f":"InpActive!W$43","v":0}]
[null,null,null,null,"CPIH: Nov % increase - CALC",null,"%",null,null,{"$f":" IF(I10 = 0, 0, J10 / I10)","v":0},0,0,0,0,0,{"$f":" IF(O10 = 0, 0, P10 / O10)","v":0},0,0,0,0,0,0,0]
[]
[null,"CPIH: Nov - Nov index inflating from 2019/20"]
[null,null,null,null,{"$f":"InpActive!E$43","v":"CPIH Index Nov (from 2017/18)"},{"$f":"InpActive!F$43","v":0},{"$f":"InpActive!G$43","v":"index"},{"$f":"InpActive!H$43","v":0},{"$f":"InpActive!I$43","v":0},{"$f":"InpActive!J$43","v":0},{"$f":"InpActive!K$43","v":0},{"$f":"InpActive!L$43","v":0},{"$f":"InpActive!M$43","v":0},{"$f":"InpActive!N$43","v":0},{"$f":"InpActive!O$43","v":0},{"$f":"InpActive!P$43","v":0},{"$f":"InpActive!Q$43","v":0},{"$f":"InpActive!R$43","v":0},{"$f":"InpActive!S$43","v":0},{"$f":"InpActive!T$43","v":0},{"$f":"InpActive!U$43","v":0},{"$f":"InpActive!V$43","v":0},{"$f":"InpActive!W$43","v":0}]
[null,null,null,null,{"$f":" Time!E$75","v":"Last pre-forecast period flag"},{"$f":" Time!F$75","v":0},{"$f":" Time!G$75","v":"flag"},{"$f":" Time!H$75","v":1},{"$f":" Time!I$75","v":0},{"$f":" Time!J$75","v":0},{"$f":" Time!K$75","v":0},{"$f":" Time!L$75","v":0},{"$f":" Time!M$75","v":0},{"$f":" Time!N$75","v":0},{"$f":" Time!O$75","v":1},{"$f":" Time!P$75","v":0},{"$f":" Time!Q$75","v":0},{"$f":" Time!R$75","v":0},{"$f":" Time!S$75","v":0},{"$f":" Time!T$75","v":0},{"$f":" Time!U$75","v":0},{"$f":" Time!V$75","v":0},{"$f":" Time!W$75","v":0}]
[null,null,null,null,"CPIH Nov 2019/20 ",null,"Index",{"$f":"SUM(J16:W16)","v":0},null,{"$f":" J14 * J15","v":0},{"$f":" K14 * K15","v":0},0,0,0,{"$f":" O14 * O15","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"CPIH Forcast period base inflation",{"$f":"SUM(J16:W16)","v":0}]
[]
[null,null,null,null,{"$f":" E$17","v":"CPIH Forcast period base inflation"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$10","v":"CPIH Index Nov (from 2017/18)"},{"$f":" F$10","v":0},"index",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$64","v":"Forecast period flag"},{"$f":" Time!F$64","v":0},{"$f":" Time!G$64","v":"flag"},{"$f":" Time!H$64","v":5},{"$f":" Time!I$64","v":0},{"$f":" Time!J$64","v":0},{"$f":" Time!K$64","v":0},{"$f":" Time!L$64","v":0},{"$f":" Time!M$64","v":0},{"$f":" Time!N$64","v":0},{"$f":" Time!O$64","v":0},{"$f":" Time!P$64","v":1},{"$f":" Time!Q$64","v":1},{"$f":" Time!R$64","v":1},{"$f":" Time!S$64","v":1},{"$f":" Time!T$64","v":1},{"$f":" Time!U$64","v":0},{"$f":" Time!V$64","v":0},{"$f":" Time!W$64","v":0}]
[null,null,null,null,"CPIH: Nov - Nov index inflating from 2019/20",null,"index",null,null,{"$f":" IF($F19 = 0, 0, (J20 / $F$19) * J21)","v":0},{"$f":" IF($F19 = 0, 0, (K20 / $F$19) * K21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Revenue indexation"]
[null,null,null,null,{"$f":" E$11","v":"CPIH: Nov % increase - CALC"},0,"%",0,0,0,0,0,0,0,0,{"$f":" P$11","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Actual CPIH: Nov - Nov increase from base year",null,"%",null,null,{"$f":" IF(J25 = 0, 0, (J25 - 1))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Water Resources"]
[null,null,null,null,{"$f":" InpActive!E$141","v":"Unit conversion to percentage"},{"$f":" InpActive!F$141","v":100},{"$f":" InpActive!G$141","v":"#"},{"$f":" InpActive!H$141","v":0},{"$f":" InpActive!I$141","v":0},{"$f":" InpActive!J$141","v":0},{"$f":" InpActive!K$141","v":0},{"$f":" InpActive!L$141","v":0},{"$f":" InpActive!M$141","v":0},{"$f":" InpActive!N$141","v":0},{"$f":" InpActive!O$141","v":0},{"$f":" InpActive!P$141","v":0},{"$f":" InpActive!Q$141","v":0},{"$f":" InpActive!R$141","v":0},{"$f":" InpActive!S$141","v":0},{"$f":" InpActive!T$141","v":0},{"$f":" InpActive!U$141","v":0},{"$f":" InpActive!V$141","v":0},{"$f":" InpActive!W$141","v":0}]
[null,null,null,null,{"$f":" InpActive!E79","v":"K - Water Res"},{"$f":" InpActive!F79","v":0},{"$f":" InpActive!G79","v":"#"},{"$f":" InpActive!H79","v":0},{"$f":" InpActive!I79","v":0},{"$f":" InpActive!J79","v":0},{"$f":" InpActive!K79","v":0},{"$f":" InpActive!L79","v":0},{"$f":" InpActive!M79","v":0},{"$f":" InpActive!N79","v":0},{"$f":" InpActive!O79","v":0},{"$f":" InpActive!P79","v":0},{"$f":" InpActive!Q79","v":0},{"$f":" InpActive!R79","v":0},{"$f":" InpActive!S79","v":0},{"$f":" InpActive!T79","v":0},{"$f":" InpActive!U79","v":0},{"$f":" InpActive!V79","v":0},{"$f":" InpActive!W79","v":0}]
[null,null,null,null,"K - Water Res percentage",null,"%",null,null,{"$f":" IF($F29 = 0, 0, J30 / $F29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$31","v":"K - Water Res percentage"},{"$f":"F$31","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Actual CPIH: Nov - Nov increase from base year"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Revenue indexation - Water Res",null,"factor",null,null,{"$f":" (1 + J33 + J34) * J35","v":0},0,0,0,0,0,1,1,1,1,1,0,0,0]
[]
[null,"Water Network-Plus"]
[null,null,null,null,{"$f":" InpActive!E$141","v":"Unit conversion to percentage"},{"$f":" InpActive!F$141","v":100},{"$f":" InpActive!G$141","v":"#"},{"$f":" InpActive!H$141","v":0},{"$f":" InpActive!I$141","v":0},{"$f":" InpActive!J$141","v":0},{"$f":" InpActive!K$141","v":0},{"$f":" InpActive!L$141","v":0},{"$f":" InpActive!M$141","v":0},{"$f":" InpActive!N$141","v":0},{"$f":" InpActive!O$141","v":0},{"$f":" InpActive!P$141","v":0},{"$f":" InpActive!Q$141","v":0},{"$f":" InpActive!R$141","v":0},{"$f":" InpActive!S$141","v":0},{"$f":" InpActive!T$141","v":0},{"$f":" InpActive!U$141","v":0},{"$f":" InpActive!V$141","v":0},{"$f":" InpActive!W$141","v":0}]
[null,null,null,null,{"$f":" InpActive!E$91","v":"K - Water-N+"},{"$f":" InpActive!F$91","v":0},{"$f":" InpActive!G$91","v":"#"},{"$f":" InpActive!H$91","v":0},{"$f":" InpActive!I$91","v":0},{"$f":" InpActive!J$91","v":0},{"$f":" InpActive!K$91","v":0},{"$f":" InpActive!L$91","v":0},{"$f":" InpActive!M$91","v":0},{"$f":" InpActive!N$91","v":0},{"$f":" InpActive!O$91","v":0},{"$f":" InpActive!P$91","v":0},{"$f":" InpActive!Q$91","v":0},{"$f":" InpActive!R$91","v":0},{"$f":" InpActive!S$91","v":0},{"$f":" InpActive!T$91","v":0},{"$f":" InpActive!U$91","v":0},{"$f":" InpActive!V$91","v":0},{"$f":" InpActive!W$91","v":0}]
[null,null,null,null,"K - Water-N+ percentage",null,"%",null,null,{"$f":" IF($F39 = 0, 0, J40 / $F39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$41","v":"K - Water-N+ percentage"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Actual CPIH: Nov - Nov increase from base year"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Revenue indexation - Water-N+",null,"factor",null,null,{"$f":" (1 + J43 + J44) * J45","v":0},0,0,0,0,0,{"$f":" (1 + P43 + P44) * P45","v":1},1,1,1,1,0,0,0]
[]
[null,"Wastewater Network-Plus"]
[null,null,null,null,{"$f":" InpActive!E$141","v":"Unit conversion to percentage"},{"$f":" InpActive!F$141","v":100},{"$f":" InpActive!G$141","v":"#"},{"$f":" InpActive!H$141","v":0},{"$f":" InpActive!I$141","v":0},{"$f":" InpActive!J$141","v":0},{"$f":" InpActive!K$141","v":0},{"$f":" InpActive!L$141","v":0},{"$f":" InpActive!M$141","v":0},{"$f":" InpActive!N$141","v":0},{"$f":" InpActive!O$141","v":0},{"$f":" InpActive!P$141","v":0},{"$f":" InpActive!Q$141","v":0},{"$f":" InpActive!R$141","v":0},{"$f":" InpActive!S$141","v":0},{"$f":" InpActive!T$141","v":0},{"$f":" InpActive!U$141","v":0},{"$f":" InpActive!V$141","v":0},{"$f":" InpActive!W$141","v":0}]
[null,null,null,null,{"$f":" InpActive!E$117","v":"K - WW-N+"},{"$f":" InpActive!F$117","v":0},{"$f":" InpActive!G$117","v":"#"},{"$f":" InpActive!H$117","v":0},{"$f":" InpActive!I$117","v":0},{"$f":" InpActive!J$117","v":0},{"$f":" InpActive!K$117","v":0},{"$f":" InpActive!L$117","v":0},{"$f":" InpActive!M$117","v":0},{"$f":" InpActive!N$117","v":0},{"$f":" InpActive!O$117","v":0},{"$f":" InpActive!P$117","v":0},{"$f":" InpActive!Q$117","v":0},{"$f":" InpActive!R$117","v":0},{"$f":" InpActive!S$117","v":0},{"$f":" InpActive!T$117","v":0},{"$f":" InpActive!U$117","v":0},{"$f":" InpActive!V$117","v":0},{"$f":" InpActive!W$117","v":0}]
[null,null,null,null,"K - WW-N+ percentage",null,"%",null,null,{"$f":" IF($F49 = 0, 0, J50 / $F49)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$51","v":"K - WW-N+ percentage"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Actual CPIH: Nov - Nov increase from base year"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Revenue indexation - WW-N+",null,"factor",null,null,{"$f":" (1 + J53 + J54) * J55","v":0},0,0,0,0,0,1,1,1,1,1,0,0,0]
[]
["End of sheet"]

{"sheet":"Wholesale Water","index":5,"n_rows":180,"n_cols":23,"rows_kept":180,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Wholesale Water"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["REVENUE RECOVERED"]
[]
[null,null,null,null,{"$f":" InpActive!E$93","v":"Actual Revenue (to be completed at the end of PR24) - Water-N+ "},{"$f":" InpActive!F$93","v":0},{"$f":" InpActive!G$93","v":"£m"},{"$f":" InpActive!H$93","v":0},{"$f":" InpActive!I$93","v":0},{"$f":" InpActive!J$93","v":0},{"$f":" InpActive!K$93","v":0},{"$f":" InpActive!L$93","v":0},{"$f":" InpActive!M$93","v":0},{"$f":" InpActive!N$93","v":0},{"$f":" InpActive!O$93","v":0},{"$f":" InpActive!P$93","v":0},{"$f":" InpActive!Q$93","v":0},{"$f":" InpActive!R$93","v":0},{"$f":" InpActive!S$93","v":0},{"$f":" InpActive!T$93","v":0},{"$f":" InpActive!U$93","v":0},{"$f":" InpActive!V$93","v":0},{"$f":" InpActive!W$93","v":0}]
[null,null,null,null,{"$f":"InpActive!E$81","v":"Actual Revenue (to be completed at the end of PR24) - Water Res "},{"$f":"InpActive!F$81","v":0},{"$f":"InpActive!G$81","v":"£m"},{"$f":"InpActive!H$81","v":0},{"$f":"InpActive!I$81","v":0},{"$f":"InpActive!J$81","v":0},{"$f":"InpActive!K$81","v":0},{"$f":"InpActive!L$81","v":0},{"$f":"InpActive!M$81","v":0},{"$f":"InpActive!N$81","v":0},{"$f":"InpActive!O$81","v":0},{"$f":"InpActive!P$81","v":0},{"$f":"InpActive!Q$81","v":0},{"$f":"InpActive!R$81","v":0},{"$f":"InpActive!S$81","v":0},{"$f":"InpActive!T$81","v":0},{"$f":"InpActive!U$81","v":0},{"$f":"InpActive!V$81","v":0},{"$f":"InpActive!W$81","v":0}]
[null,null,null,null,"Actual Revenue (to be calculated at the end of PR24) - Wholesale Water",null,"£m",{"$f":" SUM(J11:W11)","v":0},null,{"$f":"SUM(J9:J10)","v":0},{"$f":"SUM(K9:K10)","v":0},{"$f":"SUM(L9:L10)","v":0},0,0,0,{"$f":"SUM(P9:P10)","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$11","v":"Actual Revenue (to be calculated at the end of PR24) - Wholesale Water"},{"$f":"F$11","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"InpActive!E107","v":"Actual revenue: developer services - Water-N+ "},{"$f":"InpActive!F107","v":0},{"$f":"InpActive!G107","v":"£m"},{"$f":"InpActive!H107","v":0},{"$f":"InpActive!I107","v":0},{"$f":"InpActive!J107","v":0},{"$f":"InpActive!K107","v":0},{"$f":"InpActive!L107","v":0},{"$f":"InpActive!M107","v":0},{"$f":"InpActive!N107","v":0},{"$f":"InpActive!O107","v":0},{"$f":"InpActive!P107","v":0},{"$f":"InpActive!Q107","v":0},{"$f":"InpActive!R107","v":0},{"$f":"InpActive!S107","v":0},{"$f":"InpActive!T107","v":0},{"$f":"InpActive!U107","v":0},{"$f":"InpActive!V107","v":0},{"$f":"InpActive!W107","v":0}]
[null,null,null,null,"ND: Actual Revenue (to be calculated at the end of PR24) - Wholesale Water",null,"£m",{"$f":" SUM(J15:W15)","v":0},null,{"$f":"J13-J14","v":0},{"$f":"K13-K14","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["ALLOWED REVENUE"]
[]
[null,"Allowed Revenue: Water Resources"]
[null,null,null,null,{"$f":"InpActive!E$77","v":"Allowed revenue - Water Res (base year 2019/2020)"},{"$f":"InpActive!F$77","v":0},{"$f":"InpActive!G$77","v":"£m"},{"$f":"InpActive!H$77","v":0},{"$f":"InpActive!I$77","v":0},{"$f":"InpActive!J$77","v":0},{"$f":"InpActive!K$77","v":0},{"$f":"InpActive!L$77","v":0},{"$f":"InpActive!M$77","v":0},{"$f":"InpActive!N$77","v":0},{"$f":"InpActive!O$77","v":0},{"$f":"InpActive!P$77","v":0},{"$f":"InpActive!Q$77","v":0},{"$f":"InpActive!R$77","v":0},{"$f":"InpActive!S$77","v":0},{"$f":"InpActive!T$77","v":0},{"$f":"InpActive!U$77","v":0},{"$f":"InpActive!V$77","v":0},{"$f":"InpActive!W$77","v":0}]
[null,null,null,null,{"$f":" Index!E$36","v":"Revenue indexation - Water Res"},{"$f":" Index!F$36","v":0},{"$f":" Index!G$36","v":"factor"},{"$f":" Index!H$36","v":0},{"$f":" Index!I$36","v":0},{"$f":" Index!J$36","v":0},{"$f":" Index!K$36","v":0},{"$f":" Index!L$36","v":0},{"$f":" Index!M$36","v":0},{"$f":" Index!N$36","v":0},{"$f":" Index!O$36","v":0},{"$f":" Index!P$36","v":1},{"$f":" Index!Q$36","v":1},{"$f":" Index!R$36","v":1},{"$f":" Index!S$36","v":1},{"$f":" Index!T$36","v":1},{"$f":" Index!U$36","v":0},{"$f":" Index!V$36","v":0},{"$f":" Index!W$36","v":0}]
[null,null,null,null,{"$f":" Time!E$75","v":"Last pre-forecast period flag"},{"$f":" Time!F$75","v":0},{"$f":" Time!G$75","v":"flag"},{"$f":" Time!H$75","v":1},{"$f":" Time!I$75","v":0},{"$f":" Time!J$75","v":0},{"$f":" Time!K$75","v":0},{"$f":" Time!L$75","v":0},{"$f":" Time!M$75","v":0},{"$f":" Time!N$75","v":0},{"$f":" Time!O$75","v":1},{"$f":" Time!P$75","v":0},{"$f":" Time!Q$75","v":0},{"$f":" Time!R$75","v":0},{"$f":" Time!S$75","v":0},{"$f":" Time!T$75","v":0},{"$f":" Time!U$75","v":0},{"$f":" Time!V$75","v":0},{"$f":" Time!W$75","v":0}]
[null,null,null,null,"Allowed revenue - Water Res ",null,"£m",{"$f":" SUM(J24:W24)","v":0},null,{"$f":" IF(J23 = 1, $F21, I24 * J22)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$24","v":"Allowed revenue - Water Res "},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Allowed revenue from FD - Water Res ",null,"£m",{"$f":" SUM(J28:W28)","v":0},null,{"$f":" IF(J27 = 1, J26, 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Allowed Revenue: Water Network-plus (including developer services)"]
[null,null,null,null,{"$f":" InpActive!E$89","v":"Allowed revenue - Water-N+ (base year 2019/2020)"},{"$f":" InpActive!F$89","v":0},{"$f":" InpActive!G$89","v":"£m"},{"$f":" InpActive!H$89","v":0},{"$f":" InpActive!I$89","v":0},{"$f":" InpActive!J$89","v":0},{"$f":" InpActive!K$89","v":0},{"$f":" InpActive!L$89","v":0},{"$f":" InpActive!M$89","v":0},{"$f":" InpActive!N$89","v":0},{"$f":" InpActive!O$89","v":0},{"$f":" InpActive!P$89","v":0},{"$f":" InpActive!Q$89","v":0},{"$f":" InpActive!R$89","v":0},{"$f":" InpActive!S$89","v":0},{"$f":" InpActive!T$89","v":0},{"$f":" InpActive!U$89","v":0},{"$f":" InpActive!V$89","v":0},{"$f":" InpActive!W$89","v":0}]
[null,null,null,null,{"$f":" Index!E$46","v":"Revenue indexation - Water-N+"},{"$f":" Index!F$46","v":0},{"$f":" Index!G$46","v":"factor"},{"$f":" Index!H$46","v":0},{"$f":" Index!I$46","v":0},{"$f":" Index!J$46","v":0},{"$f":" Index!K$46","v":0},{"$f":" Index!L$46","v":0},{"$f":" Index!M$46","v":0},{"$f":" Index!N$46","v":0},{"$f":" Index!O$46","v":0},{"$f":" Index!P$46","v":1},{"$f":" Index!Q$46","v":1},{"$f":" Index!R$46","v":1},{"$f":" Index!S$46","v":1},{"$f":" Index!T$46","v":1},{"$f":" Index!U$46","v":0},{"$f":" Index!V$46","v":0},{"$f":" Index!W$46","v":0}]
[null,null,null,null,{"$f":" Time!E$75","v":"Last pre-forecast period flag"},{"$f":" Time!F$75","v":0},{"$f":" Time!G$75","v":"flag"},{"$f":" Time!H$75","v":1},{"$f":" Time!I$75","v":0},{"$f":" Time!J$75","v":0},{"$f":" Time!K$75","v":0},{"$f":" Time!L$75","v":0},{"$f":" Time!M$75","v":0},{"$f":" Time!N$75","v":0},{"$f":" Time!O$75","v":1},{"$f":" Time!P$75","v":0},{"$f":" Time!Q$75","v":0},{"$f":" Time!R$75","v":0},{"$f":" Time!S$75","v":0},{"$f":" Time!T$75","v":0},{"$f":" Time!U$75","v":0},{"$f":" Time!V$75","v":0},{"$f":" Time!W$75","v":0}]
[null,null,null,null,"Allowed revenue - Water-N+ ",null,"£m",{"$f":" SUM(J34:W34)","v":0},null,{"$f":" IF(J33 = 1, $F31, I34 * J32)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U33 = 1, $F31, T34 * U32)","v":0},0,0]
[]
[null,null,null,null,{"$f":" E$34","v":"Allowed revenue - Water-N+ "},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Allowed revenue from FD - Water-N+ ",null,"£m",{"$f":" SUM(J38:W38)","v":0},null,{"$f":" IF(J37 = 1, J36, 0)","v":0},0,{"$f":" IF(L37 = 1, L36, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":" IF(U37 = 1, U36, 0)","v":0},0,0]
[]
[null,"Allowed Revenue: Developer Services"]
[null,null,null,null,{"$f":"Index!E$10","v":"CPIH Index Nov (from 2017/18)"},{"$f":"Index!F$10","v":0},{"$f":"Index!G$10","v":"index"},{"$f":"Index!H$10","v":0},{"$f":"Index!I$10","v":0},{"$f":"Index!J$10","v":0},{"$f":"Index!K$10","v":0},{"$f":"Index!L$10","v":0},{"$f":"Index!M$10","v":0},{"$f":"Index!N$10","v":0},{"$f":"Index!O$10","v":0},{"$f":"Index!P$10","v":0},{"$f":"Index!Q$10","v":0},{"$f":"Index!R$10","v":0},{"$f":"Index!S$10","v":0},{"$f":"Index!T$10","v":0},{"$f":"Index!U$10","v":0},{"$f":"Index!V$10","v":0},{"$f":"Index!W$10","v":0}]
[null,null,null,null,{"$f":" Time!E$32","v":"2017/18 indexation period flag"},{"$f":" Time!F$32","v":0},{"$f":" Time!G$32","v":"flag"},{"$f":" Time!H$32","v":1},{"$f":" Time!I$32","v":0},{"$f":" Time!J$32","v":0},{"$f":" Time!K$32","v":0},{"$f":" Time!L$32","v":0},{"$f":" Time!M$32","v":1},{"$f":" Time!N$32","v":0},{"$f":" Time!O$32","v":0},{"$f":" Time!P$32","v":0},{"$f":" Time!Q$32","v":0},{"$f":" Time!R$32","v":0},{"$f":" Time!S$32","v":0},{"$f":" Time!T$32","v":0},{"$f":" Time!U$32","v":0},{"$f":" Time!V$32","v":0},{"$f":" Time!W$32","v":0}]
[null,null,null,null,"CPIH Index from 2017/18 base",null,null,null,null,{"$f":" J41 * J42","v":0},{"$f":" K41 * K42","v":0},0,0,0,0,0,{"$f":" Q41 * Q42","v":0},0,0,0,0,0,0]
[null,null,null,null,"CPIH Index from 2017/18 ",{"$f":" SUM(J43:W43)","v":0}]
[]
[null,null,null,null,{"$f":"E$44","v":"CPIH Index from 2017/18 "},{"$f":"F$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"InpActive!E$105","v":"Allowed revenue: developer services - Water-N+ (base year 2017/2018)"},{"$f":"InpActive!F$105","v":0},{"$f":"InpActive!G$105","v":"£m"},{"$f":"InpActive!H$105","v":0},{"$f":"InpActive!I$105","v":0},{"$f":"InpActive!J$105","v":0},{"$f":"InpActive!K$105","v":0},{"$f":"InpActive!L$105","v":0},{"$f":"InpActive!M$105","v":0},{"$f":"InpActive!N$105","v":0},{"$f":"InpActive!O$105","v":0},{"$f":"InpActive!P$105","v":0},{"$f":"InpActive!Q$105","v":0},{"$f":"InpActive!R$105","v":0},{"$f":"InpActive!S$105","v":0},{"$f":"InpActive!T$105","v":0},{"$f":"InpActive!U$105","v":0},{"$f":"InpActive!V$105","v":0},{"$f":"InpActive!W$105","v":0}]
[null,null,null,null,{"$f":"Index!E$10","v":"CPIH Index Nov (from 2017/18)"},{"$f":"Index!F$10","v":0},{"$f":"Index!G$10","v":"index"},{"$f":"Index!H$10","v":0},{"$f":"Index!I$10","v":0},{"$f":"Index!J$10","v":0},{"$f":"Index!K$10","v":0},{"$f":"Index!L$10","v":0},{"$f":"Index!M$10","v":0},{"$f":"Index!N$10","v":0},{"$f":"Index!O$10","v":0},{"$f":"Index!P$10","v":0},{"$f":"Index!Q$10","v":0},{"$f":"Index!R$10","v":0},{"$f":"Index!S$10","v":0},{"$f":"Index!T$10","v":0},{"$f":"Index!U$10","v":0},{"$f":"Index!V$10","v":0},{"$f":"Index!W$10","v":0}]
[null,null,null,null,{"$f":"Time!E$59","v":"Forecast period flag"},{"$f":"Time!F$59","v":0},{"$f":"Time!G$59","v":"flag"},{"$f":"Time!H$59","v":5},{"$f":"Time!I$59","v":0},{"$f":"Time!J$59","v":0},{"$f":"Time!K$59","v":0},{"$f":"Time!L$59","v":0},{"$f":"Time!M$59","v":0},{"$f":"Time!N$59","v":0},{"$f":"Time!O$59","v":0},{"$f":"Time!P$59","v":1},{"$f":"Time!Q$59","v":1},{"$f":"Time!R$59","v":1},{"$f":"Time!S$59","v":1},{"$f":"Time!T$59","v":1},{"$f":"Time!U$59","v":0},{"$f":"Time!V$59","v":0},{"$f":"Time!W$59","v":0}]
[null,null,null,null,"Notional Allowed revenue: developer services - Water-N+ ",null,"£m",{"$f":" SUM(J50:W50)","v":0},null,{"$f":" IF($F46 = 0, 0, J49 * J47 * (J48 / $F$46 ))","v":0},{"$f":" IF($F46 = 0, 0, K49 * K47 * (K48 / $F$46 ))","v":0},0,0,0,0,0,{"$f":" IF($F46 = 0, 0, Q49 * Q47 * (Q48 / $F$46 ))","v":0},0,0,0,0,0,{"$f":" IF($F46 = 0, 0, W49 * W47 * (W48 / $F$46 ))","v":0}]
[]
["BLIND YEAR ADJUSTMENT"]
[]
[null,"Blind year adjustment"]
[null,null,null,null,{"$f":" InpActive!E$97","v":"Blind year adjustment for year 2019/2020 - Water-N+ (base year 2019/2020)"},{"$f":" InpActive!F$97","v":0},{"$f":" InpActive!G$97","v":"£m"},{"$f":" InpActive!H$97","v":0},{"$f":" InpActive!I$97","v":0},{"$f":" InpActive!J$97","v":0},{"$f":" InpActive!K$97","v":0},{"$f":" InpActive!L$97","v":0},{"$f":" InpActive!M$97","v":0},{"$f":" InpActive!N$97","v":0},{"$f":" InpActive!O$97","v":0},{"$f":" InpActive!P$97","v":0},{"$f":" InpActive!Q$97","v":0},{"$f":" InpActive!R$97","v":0},{"$f":" InpActive!S$97","v":0},{"$f":" InpActive!T$97","v":0},{"$f":" InpActive!U$97","v":0},{"$f":" InpActive!V$97","v":0},{"$f":" InpActive!W$97","v":0}]
[null,null,null,null,{"$f":"InpActive!E$99","v":"Blind year profiling factor - Water-N+"},{"$f":"InpActive!F$99","v":0},{"$f":"InpActive!G$99","v":"%"},{"$f":"InpActive!H$99","v":0},{"$f":"InpActive!I$99","v":0},{"$f":"InpActive!J$99","v":0},{"$f":"InpActive!K$99","v":0},{"$f":"InpActive!L$99","v":0},{"$f":"InpActive!M$99","v":0},{"$f":"InpActive!N$99","v":0},{"$f":"InpActive!O$99","v":0},{"$f":"InpActive!P$99","v":0},{"$f":"InpActive!Q$99","v":0},{"$f":"InpActive!R$99","v":0},{"$f":"InpActive!S$99","v":0},{"$f":"InpActive!T$99","v":0},{"$f":"InpActive!U$99","v":0},{"$f":"InpActive!V$99","v":0},{"$f":"InpActive!W$99","v":0}]
[null,null,null,null,"Blind year adjustment (profiled) - Water-N+ (base year 2019/20)",null,null,{"$f":" SUM(J57:W57)","v":0},null,{"$f":"J56*$F$55","v":0},0,0,0,0,0,0,0,0,0,{"$f":"T56*$F$55","v":0},{"$f":"U56*$F$55","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":"E$57","v":"Blind year adjustment (profiled) - Water-N+ (base year 2019/20)"},0,0,{"$f":"H$57","v":0},{"$f":"I$57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$66","v":"Forecast period counter"},{"$f":" Time!F$66","v":0},{"$f":" Time!G$66","v":"counter"},{"$f":" Time!H$66","v":0},{"$f":" Time!I$66","v":0},{"$f":" Time!J$66","v":0},{"$f":" Time!K$66","v":0},{"$f":" Time!L$66","v":0},{"$f":" Time!M$66","v":0},{"$f":" Time!N$66","v":0},{"$f":" Time!O$66","v":0},{"$f":" Time!P$66","v":1},{"$f":" Time!Q$66","v":2},{"$f":" Time!R$66","v":3},{"$f":" Time!S$66","v":4},{"$f":" Time!T$66","v":5},{"$f":" Time!U$66","v":0},{"$f":" Time!V$66","v":0},{"$f":" Time!W$66","v":0}]
[null,null,null,null,"Blind year (profiled) inc. financing rate adjustment - Water-N+ (base year 2019/2020)",null,"£m",null,null,{"$f":"J60*(1 + $F$59)^J61","v":0},0,0,0,0,0,0,{"$f":"Q60*(1 + $F$59)^Q61","v":0},{"$f":"R60*(1 + $F$59)^R61","v":0},{"$f":"S60*(1 + $F$59)^S61","v":0},0,0,0,0]
[]
[null,null,null,null,{"$f":"Index!E$22","v":"CPIH: Nov - Nov index inflating from 2019/20"},{"$f":"Index!F$22","v":0},{"$f":"Index!G$22","v":"index"},{"$f":"Index!H$22","v":0},{"$f":"Index!I$22","v":0},{"$f":"Index!J$22","v":0},{"$f":"Index!K$22","v":0},{"$f":"Index!L$22","v":0},{"$f":"Index!M$22","v":0},{"$f":"Index!N$22","v":0},{"$f":"Index!O$22","v":0},{"$f":"Index!P$22","v":0},{"$f":"Index!Q$22","v":0},{"$f":"Index!R$22","v":0},{"$f":"Index!S$22","v":0},{"$f":"Index!T$22","v":0},{"$f":"Index!U$22","v":0},{"$f":"Index!V$22","v":0},{"$f":"Index!W$22","v":0}]
[null,null,null,null,{"$f":"E$62","v":"Blind year (profiled) inc. financing rate adjustment - Water-N+ (base year 2019/2020)"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Blind year (profiled) inc. financing rate adjustment - Water-N+ ",null,"£m",{"$f":" SUM(J66:W66)","v":0},null,{"$f":" J64 * J65","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U64 * U65","v":0},0,0]
[]
["REVENUE CORRECTION"]
[]
[null,"Main revenue over /  under recovery: All (Including Developer Services)"]
[null,null,null,null,{"$f":" E$38","v":"Allowed revenue from FD - Water-N+ "},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$66","v":"Blind year (profiled) inc. financing rate adjustment - Water-N+ "},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$28","v":"Allowed revenue from FD - Water Res "},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$147","v":"AMP6 forecasting incentive adjustment including over / under recovery true up - Wholesale Water"},{"$f":" F$147","v":"2 PD LK BCK"},{"$f":" G$147","v":"£m"},{"$f":" H$147","v":0},{"$f":" I$147","v":0},{"$f":" J$147","v":0},0,0,0,0,0,0,0,{"$f":" R$147","v":0},0,0,0,0,0]
[null,null,null,null,"Adjusted allowed revenue - Wholesale Water (AR) ",null,"£m",{"$f":" SUM(J75:W75)","v":0},null,{"$f":" SUM(J71:J74)","v":0},0,0,0,0,0,{"$f":" SUM(P71:P74)","v":0},{"$f":" SUM(Q71:Q74)","v":0},{"$f":" SUM(R71:R74)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$75","v":"Adjusted allowed revenue - Wholesale Water (AR) "},0,"£m",0,0,0,{"$f":"K$75","v":0},{"$f":"L$75","v":0},0,{"$f":"N$75","v":0},0,{"$f":"P$75","v":0},0,{"$f":"R$75","v":0},0,{"$f":"T$75","v":0},0,{"$f":"V$75","v":0},0]
[null,null,null,"less",{"$f":"E$11","v":"Actual Revenue (to be calculated at the end of PR24) - Wholesale Water"},{"$f":"F$11","v":0},{"$f":"G$11","v":"£m"},{"$f":"H$11","v":0},{"$f":"I$11","v":0},{"$f":"J$11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Revenue Imbalance - Wholesale Water ",null,"£m",{"$f":" SUM(J79:W79)","v":0},null,{"$f":"J77-J78","v":0},{"$f":"K77-K78","v":0},0,0,0,0,0,0,{"$f":"R77-R78","v":0},0,0,0,{"$f":"V77-V78","v":0},{"$f":"W77-W78","v":0}]
[]
[null,"Main revenue adjustment"]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":"E$79","v":"Revenue Imbalance - Wholesale Water "},{"$f":"F$79","v":0},"£m",0,0,0,0,0,0,0,0,0,0,{"$f":"R$79","v":0},0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$66","v":"Forecast period counter"},{"$f":" Time!F$66","v":0},{"$f":" Time!G$66","v":"counter"},{"$f":" Time!H$66","v":0},{"$f":" Time!I$66","v":0},{"$f":" Time!J$66","v":0},{"$f":" Time!K$66","v":0},{"$f":" Time!L$66","v":0},{"$f":" Time!M$66","v":0},{"$f":" Time!N$66","v":0},{"$f":" Time!O$66","v":0},{"$f":" Time!P$66","v":1},{"$f":" Time!Q$66","v":2},{"$f":" Time!R$66","v":3},{"$f":" Time!S$66","v":4},{"$f":" Time!T$66","v":5},{"$f":" Time!U$66","v":0},{"$f":" Time!V$66","v":0},{"$f":" Time!W$66","v":0}]
[null,null,null,null,"Main revenue adjustment - with financing adjustment - Wholesale Water",null,"£m",{"$f":" SUM(J86:W86)","v":0},null,{"$f":" IF(J85 <= $F82 + 1,  J84 * (1 + $F83) * (1 + $F83), 0)","v":0},0,0,0,0,0,{"$f":" IF(P85 <= $F82 + 1,  P84 * (1 + $F83) * (1 + $F83), 0)","v":0},0,{"$f":" IF(R85 <= $F82 + 1,  R84 * (1 + $F83) * (1 + $F83), 0)","v":0},{"$f":" IF(S85 <= $F82 + 1,  S84 * (1 + $F83) * (1 + $F83), 0)","v":0},{"$f":" IF(T85 <= $F82 + 1,  T84 * (1 + $F83) * (1 + $F83), 0)","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":" E$86","v":"Main revenue adjustment - with financing adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water",null,"£m",{"$f":" SUM(J90:W90)","v":0},null,{"$f":" J89 * K88 * L88","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U89 * V88 * W88","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":" E$90","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},{"$f":" Time!F$131","v":0},{"$f":" Time!G$131","v":"year #"},{"$f":" Time!H$131","v":0},{"$f":" Time!I$131","v":0},{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,"Main revenue adjustment - as incurred - Wholesale Water",null,"£m",{"$f":" SUM(J95:W95)","v":0},null,{"$f":" SUMIF($J94:$W94, J94 - $F92, $J93:$W93)","v":0},0,0,0,0,0,{"$f":" SUMIF($J94:$W94, P94 - $F92, $J93:$W93)","v":0},0,{"$f":" SUMIF($J94:$W94, R94 - $F92, $J93:$W93)","v":0},0,0,0,0,0]
[]
["PENALTY CALCULATION"]
[]
[null,"Main revenue over /  under recovery: Non-developer services"]
[null,null,null,null,{"$f":"E$75","v":"Adjusted allowed revenue - Wholesale Water (AR) "},{"$f":"F$75","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":"E$50","v":"Notional Allowed revenue: developer services - Water-N+ "},{"$f":"F$50","v":0},"£m",0,0,0,0,0,0,0,0,{"$f":"P$50","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"ND: Adjusted allowed revenue - Wholesale Water (AR)",null,"£m",{"$f":" SUM(J102:W102)","v":0},null,{"$f":"J100-J101","v":0},{"$f":"K100-K101","v":0},0,0,0,0,0,0,{"$f":"R100-R101","v":0},0,0,0,0,{"$f":"W100-W101","v":0}]
[]
[null,null,null,null,{"$f":"E$15","v":"ND: Actual Revenue (to be calculated at the end of PR24) - Wholesale Water"},0,"£m",0,0,0,{"$f":"K$15","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" E$102","v":"ND: Adjusted allowed revenue - Wholesale Water (AR)"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" W$102","v":0}]
[null,null,null,null,"ND: Revenue Imbalance - Wholesale Water",null,"£m",{"$f":" SUM(J106:W106)","v":0},null,{"$f":" J104 - J105","v":0},0,0,0,0,0,{"$f":" P104 - P105","v":0},{"$f":" Q104 - Q105","v":0},{"$f":" R104 - R105","v":0},{"$f":" S104 - S105","v":0},{"$f":" T104 - T105","v":0},{"$f":" U104 - U105","v":0},0,{"$f":" W104 - W105","v":0}]
[]
[null,"Penalty calculation"]
[null,null,null,null,{"$f":"E$15","v":"ND: Actual Revenue (to be calculated at the end of PR24) - Wholesale Water"},{"$f":"F$15","v":0},{"$f":"G$15","v":"£m"},{"$f":"H$15","v":0},{"$f":"I$15","v":0},{"$f":"J$15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$102","v":"ND: Adjusted allowed revenue - Wholesale Water (AR)"},0,"£m",0,0,0,0,0,0,0,0,{"$f":" P$102","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"ND: Forecast error - Wholesale Water",null,"%",null,null,{"$f":" IF(J110 = 0, 0, ABS(J109 - J110) / J110)","v":0},0,0,0,0,0,{"$f":" IF(P110 = 0, 0, ABS(P109 - P110) / P110)","v":0},0,0,0,0,{"$f":" IF(U110 = 0, 0, ABS(U109 - U110) / U110)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$58","v":"Minimum threshold (+/-)"},{"$f":" InpActive!F$58","v":0.02},{"$f":" InpActive!G$58","v":"%"},{"$f":" InpActive!H$58","v":0},{"$f":" InpActive!I$58","v":0},{"$f":" InpActive!J$58","v":0},{"$f":" InpActive!K$58","v":0},{"$f":" InpActive!L$58","v":0},{"$f":" InpActive!M$58","v":0},{"$f":" InpActive!N$58","v":0},{"$f":" InpActive!O$58","v":0},{"$f":" InpActive!P$58","v":0},{"$f":" InpActive!Q$58","v":0},{"$f":" InpActive!R$58","v":0},{"$f":" InpActive!S$58","v":0},{"$f":" InpActive!T$58","v":0},{"$f":" InpActive!U$58","v":0},{"$f":" InpActive!V$58","v":0},{"$f":" InpActive!W$58","v":0}]
[null,null,null,null,{"$f":" E$111","v":"ND: Forecast error - Wholesale Water"},0,"%",0,0,{"$f":" J$111","v":0},0,0,0,0,0,{"$f":" P$111","v":0},0,0,0,0,{"$f":" U$111","v":0},0,0]
[null,null,null,null,"Penalty applicable flag",null,"flag",null,null,{"$f":" IF(J114 > $F113, 1, 0)","v":0},0,0,0,0,0,{"$f":" IF(P114 > $F113, 1, 0)","v":0},0,0,0,0,{"$f":" IF(U114 > $F113, 1, 0)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$58","v":"Minimum threshold (+/-)"},{"$f":" InpActive!F$58","v":0.02},{"$f":" InpActive!G$58","v":"%"},{"$f":" InpActive!H$58","v":0},{"$f":" InpActive!I$58","v":0},{"$f":" InpActive!J$58","v":0},{"$f":" InpActive!K$58","v":0},{"$f":" InpActive!L$58","v":0},{"$f":" InpActive!M$58","v":0},{"$f":" InpActive!N$58","v":0},{"$f":" InpActive!O$58","v":0},{"$f":" InpActive!P$58","v":0},{"$f":" InpActive!Q$58","v":0},{"$f":" InpActive!R$58","v":0},{"$f":" InpActive!S$58","v":0},{"$f":" InpActive!T$58","v":0},{"$f":" InpActive!U$58","v":0},{"$f":" InpActive!V$58","v":0},{"$f":" InpActive!W$58","v":0}]
[null,null,null,null,{"$f":" InpActive!E$60","v":"Maximum threshold (+/-)"},{"$f":" InpActive!F$60","v":0.03},{"$f":" InpActive!G$60","v":"%"},{"$f":" InpActive!H$60","v":0},{"$f":" InpActive!I$60","v":0},{"$f":" InpActive!J$60","v":0},{"$f":" InpActive!K$60","v":0},{"$f":" InpActive!L$60","v":0},{"$f":" InpActive!M$60","v":0},{"$f":" InpActive!N$60","v":0},{"$f":" InpActive!O$60","v":0},{"$f":" InpActive!P$60","v":0},{"$f":" InpActive!Q$60","v":0},{"$f":" InpActive!R$60","v":0},{"$f":" InpActive!S$60","v":0},{"$f":" InpActive!T$60","v":0},{"$f":" InpActive!U$60","v":0},{"$f":" InpActive!V$60","v":0},{"$f":" InpActive!W$60","v":0}]
[null,null,null,null,{"$f":" E$111","v":"ND: Forecast error - Wholesale Water"},0,"%",0,0,0,0,0,0,0,0,{"$f":" P$111","v":0},0,0,0,0,{"$f":" U$111","v":0},0,0]
[null,null,null,null,{"$f":" E$115","v":"Penalty applicable flag"},0,"flag",0,0,0,0,0,0,0,0,{"$f":" P$115","v":0},0,0,0,0,{"$f":" U$115","v":0},0,0]
[null,null,null,null,"Error magnitude - Wholesale Water",null,"factor",null,null,{"$f":" IF(J120 = 1, (J119 - $F117) / ($F118 - $F117), 0)","v":0},0,0,{"$f":" IF(M120 = 1, (M119 - $F117) / ($F118 - $F117), 0)","v":0},0,0,{"$f":" IF(P120 = 1, (P119 - $F117) / ($F118 - $F117), 0)","v":0},0,0,0,0,{"$f":" IF(U120 = 1, (U119 - $F117) / ($F118 - $F117), 0)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$62","v":"Penalty rate (+/-)"},{"$f":" InpActive!F$62","v":0.03},{"$f":" InpActive!G$62","v":"%"},{"$f":" InpActive!H$62","v":0},{"$f":" InpActive!I$62","v":0},{"$f":" InpActive!J$62","v":0},{"$f":" InpActive!K$62","v":0},{"$f":" InpActive!L$62","v":0},{"$f":" InpActive!M$62","v":0},{"$f":" InpActive!N$62","v":0},{"$f":" InpActive!O$62","v":0},{"$f":" InpActive!P$62","v":0},{"$f":" InpActive!Q$62","v":0},{"$f":" InpActive!R$62","v":0},{"$f":" InpActive!S$62","v":0},{"$f":" InpActive!T$62","v":0},{"$f":" InpActive!U$62","v":0},{"$f":" InpActive!V$62","v":0},{"$f":" InpActive!W$62","v":0}]
[null,null,null,null,{"$f":" E$121","v":"Error magnitude - Wholesale Water"},0,"factor",0,0,0,0,0,0,0,0,{"$f":" P$121","v":0},0,0,0,0,{"$f":" U$121","v":0},0,0]
[null,null,null,null,"Penalty rate magnitude - Wholesale Water",null,"%",null,null,{"$f":" $F123 * MIN(1, J124)","v":0},0,0,0,0,0,{"$f":" $F123 * MIN(1, P124)","v":0},0,{"$f":" $F123 * MIN(1, R124)","v":0},0,0,{"$f":" $F123 * MIN(1, U124)","v":0},0,{"$f":" $F123 * MIN(1, W124)","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":"E$15","v":"ND: Actual Revenue (to be calculated at the end of PR24) - Wholesale Water"},{"$f":"F$15","v":0},{"$f":"G$15","v":"£m"},{"$f":"H$15","v":0},{"$f":"I$15","v":0},{"$f":"J$15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$102","v":"ND: Adjusted allowed revenue - Wholesale Water (AR)"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$125","v":"Penalty rate magnitude - Wholesale Water"},0,"%",0,0,0,0,0,0,0,0,{"$f":" P$125","v":0},0,0,0,0,{"$f":" U$125","v":0},0,0]
[null,null,null,null,{"$f":"Time!E59","v":"Forecast period flag"},{"$f":"Time!F59","v":0},{"$f":"Time!G59","v":"flag"},{"$f":"Time!H59","v":5},{"$f":"Time!I59","v":0},{"$f":"Time!J59","v":0},{"$f":"Time!K59","v":0},{"$f":"Time!L59","v":0},{"$f":"Time!M59","v":0},{"$f":"Time!N59","v":0},{"$f":"Time!O59","v":0},{"$f":"Time!P59","v":1},{"$f":"Time!Q59","v":1},{"$f":"Time!R59","v":1},{"$f":"Time!S59","v":1},{"$f":"Time!T59","v":1},{"$f":"Time!U59","v":0},{"$f":"Time!V59","v":0},{"$f":"Time!W59","v":0}]
[null,null,null,null,"Penalty adjustment - Wholesale Water POS",null,"£m",{"$f":" SUM(J132:W132)","v":0},null,{"$f":"  IF(J131=1, J130 * ABS(J128 - J129), 0 )","v":0},0,0,0,0,0,{"$f":"  IF(P131=1, P130 * ABS(P128 - P129), 0 )","v":0},{"$f":"  IF(Q131=1, Q130 * ABS(Q128 - Q129), 0 )","v":0},0,0,0,0,{"$f":"  IF(V131=1, V130 * ABS(V128 - V129), 0 )","v":0},0]
[null,null,null,null,{"$f":" LEFT(E132, LEN(E132) - 4)","v":"Penalty adjustment - Wholesale Water"},null,"£m",{"$f":" SUM(J133:W133)","v":0},null,{"$f":" -1 * J132","v":0},0,0,0,0,0,{"$f":" -1 * P132","v":0},0,0,0,0,{"$f":" -1 * U132","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":" E$133","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,{"$f":" P$133","v":0},0,0,0,0,{"$f":" U$133","v":0},0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment - Wholesale Water",null,"£m",{"$f":" SUM(J137:W137)","v":0},null,{"$f":" J136 * (1 + $F135)","v":0},0,0,0,0,0,{"$f":" P136 * (1 + $F135)","v":0},0,0,0,0,{"$f":" U136 * (1 + $F135)","v":0},0,0]
[]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":" E$137","v":"Penalty adjustment - with financing adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$137","v":0},0,0]
[null,null,null,null,{"$f":"Time!E87","v":"Forecast period flag"},{"$f":"Time!F87","v":0},{"$f":"Time!G87","v":"flag"},{"$f":"Time!H87","v":5},{"$f":"Time!I87","v":0},{"$f":"Time!J87","v":0},{"$f":"Time!K87","v":0},{"$f":"Time!L87","v":0},{"$f":"Time!M87","v":0},{"$f":"Time!N87","v":0},{"$f":"Time!O87","v":0},{"$f":"Time!P87","v":1},{"$f":"Time!Q87","v":1},{"$f":"Time!R87","v":1},{"$f":"Time!S87","v":1},{"$f":"Time!T87","v":1},{"$f":"Time!U87","v":0},{"$f":"Time!V87","v":0},{"$f":"Time!W87","v":0}]
[null,null,null,null,"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water",null,"£m",{"$f":" SUM(J142:W142)","v":0},null,{"$f":"IF(J141=1,J140*K139*L139,0)","v":0},{"$f":"IF(K141=1,K140*L139*M139,0)","v":0},0,{"$f":"IF(M141=1,M140*N139*O139,0)","v":0},0,0,{"$f":"IF(P141=1,P140*Q139*R139,0)","v":0},{"$f":"IF(Q141=1,Q140*R139*S139,0)","v":0},{"$f":"IF(R141=1,R140*S139*T139,0)","v":0},0,{"$f":"IF(T141=1,T140*U139*V139,0)","v":0},{"$f":"IF(U141=1,U140*V139*W139,0)","v":0}]
[]
[null,null,null,null,{"$f":" E$90","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$90","v":0},0,0]
[null,null,null,null,{"$f":" E$142","v":"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,{"$f":" P$142","v":0},0,0,0,0,{"$f":" U$142","v":0},{"$f":" V$142","v":0},0]
[null,null,null,null,{"$f":"Time!E$64","v":"Forecast period flag"},{"$f":"Time!F$64","v":0},{"$f":"Time!G$64","v":"flag"},{"$f":"Time!H$64","v":5},{"$f":"Time!I$64","v":0},{"$f":"Time!J$64","v":0},{"$f":"Time!K$64","v":0},{"$f":"Time!L$64","v":0},{"$f":"Time!M$64","v":0},{"$f":"Time!N$64","v":0},{"$f":"Time!O$64","v":0},{"$f":"Time!P$64","v":1},{"$f":"Time!Q$64","v":1},{"$f":"Time!R$64","v":1},{"$f":"Time!S$64","v":1},{"$f":"Time!T$64","v":1},{"$f":"Time!U$64","v":0},{"$f":"Time!V$64","v":0},{"$f":"Time!W$64","v":0}]
[null,null,null,null,"AMP6 forecasting incentive adjustment including over / under recovery true up - Wholesale Water","2 PD LK BCK","£m",{"$f":" SUM(J147:W147)","v":0},null,null,{"$f":" ( I144 + I145 ) * K146","v":0},{"$f":" ( J144 + J145 ) * L146","v":0},{"$f":" ( K144 + K145 ) * M146","v":0},{"$f":" ( L144 + L145 ) * N146","v":0},0,{"$f":" ( N144 + N145 ) * P146","v":0},{"$f":" ( O144 + O145 ) * Q146","v":0},{"$f":" ( P144 + P145 ) * R146","v":0},0,0,{"$f":" ( S144 + S145 ) * U146","v":0},0,{"$f":" ( U144 + U145 ) * W146","v":0}]
[]
[null,"Performance variance level check"]
[null,null,null,null,{"$f":" InpActive!E$66","v":"Threshold for additional variance analyses (+/-)"},{"$f":" InpActive!F$66","v":0.06},{"$f":" InpActive!G$66","v":"%"},{"$f":" InpActive!H$66","v":0},{"$f":" InpActive!I$66","v":0},{"$f":" InpActive!J$66","v":0},{"$f":" InpActive!K$66","v":0},{"$f":" InpActive!L$66","v":0},{"$f":" InpActive!M$66","v":0},{"$f":" InpActive!N$66","v":0},{"$f":" InpActive!O$66","v":0},{"$f":" InpActive!P$66","v":0},{"$f":" InpActive!Q$66","v":0},{"$f":" InpActive!R$66","v":0},{"$f":" InpActive!S$66","v":0},{"$f":" InpActive!T$66","v":0},{"$f":" InpActive!U$66","v":0},{"$f":" InpActive!V$66","v":0},{"$f":" InpActive!W$66","v":0}]
[null,null,null,null,{"$f":"E$111","v":"ND: Forecast error - Wholesale Water"},{"$f":"F$111","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U$111","v":0},0,0]
[null,null,null,null,"Performance variance level alert",{"$f":" IF(SUM(J152:W152) > 0, 1, 0)","v":0},"alert",null,null,{"$f":" IF(ABS(J151) > $F150, 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(ABS(U151) > $F150, 1, 0)","v":0},0,0]
[]
[]
["APPLICATION OF PENALTY"]
[]
[null,"One year of CPIH and financing costs adjustments applied"]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":"E$79","v":"Revenue Imbalance - Wholesale Water "},0,"£m",0,0,0,{"$f":"K$79","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$133","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$133","v":0},0,0]
[null,null,null,null,{"$f":" Time!E$54","v":"Forecast end period flag"},{"$f":" Time!F$54","v":0},{"$f":" Time!G$54","v":"flag"},{"$f":" Time!H$54","v":1},{"$f":" Time!I$54","v":0},{"$f":" Time!J$54","v":0},{"$f":" Time!K$54","v":0},{"$f":" Time!L$54","v":0},{"$f":" Time!M$54","v":0},{"$f":" Time!N$54","v":0},{"$f":" Time!O$54","v":0},{"$f":" Time!P$54","v":0},{"$f":" Time!Q$54","v":0},{"$f":" Time!R$54","v":0},{"$f":" Time!S$54","v":0},{"$f":" Time!T$54","v":1},{"$f":" Time!U$54","v":0},{"$f":" Time!V$54","v":0},{"$f":" Time!W$54","v":0}]
[]
[null,null,null,null,"Value of year 4 main revenue adjustment at the end of AMP6 - Wholesale Water",null,"£m",{"$f":" SUM(J164:W164)","v":0},null,{"$f":" IF(J162 = 1, I160 * J159 * (1 + $F158), 0)","v":0},{"$f":" IF(K162 = 1, J160 * K159 * (1 + $F158), 0)","v":0},0,0,0,0,0,0,0,0,{"$f":" IF(T162 = 1, S160 * T159 * (1 + $F158), 0)","v":0},0,0,0]
[null,null,null,null,"Value of year 4 penalty adjustment at the end of AMP6 - Wholesale Water",null,"£m",{"$f":" SUM(J165:W165)","v":0},null,{"$f":" J162 * ( I161 * J159 * (1 + $F158) )","v":0},{"$f":" K162 * ( J161 * K159 * (1 + $F158) )","v":0},0,0,0,0,0,0,0,0,{"$f":" T162 * ( S161 * T159 * (1 + $F158) )","v":0},0,0,0]
[null,null,null,null,"Value of year 4 WRFIM adjustments at the end of AMP6 - Wholesale Water",null,"£m",{"$f":" SUM(J166:W166)","v":0},null,{"$f":" SUM(J164:J165)","v":0},0,0,0,0,0,0,0,0,0,{"$f":" SUM(T164:T165)","v":0},0,0,0]
[]
[null,"No CPIH and financing costs adjustments applied"]
[null,null,null,null,{"$f":"E$79","v":"Revenue Imbalance - Wholesale Water "},0,"£m",0,0,0,{"$f":"K$79","v":0},0,0,0,0,0,0,0,0,{"$f":"T$79","v":0},0,0,0]
[null,null,null,null,{"$f":" E$133","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$133","v":0},{"$f":" U$133","v":0},0,0]
[null,null,null,null,{"$f":" Time!E$54","v":"Forecast end period flag"},{"$f":" Time!F$54","v":0},{"$f":" Time!G$54","v":"flag"},{"$f":" Time!H$54","v":1},{"$f":" Time!I$54","v":0},{"$f":" Time!J$54","v":0},{"$f":" Time!K$54","v":0},{"$f":" Time!L$54","v":0},{"$f":" Time!M$54","v":0},{"$f":" Time!N$54","v":0},{"$f":" Time!O$54","v":0},{"$f":" Time!P$54","v":0},{"$f":" Time!Q$54","v":0},{"$f":" Time!R$54","v":0},{"$f":" Time!S$54","v":0},{"$f":" Time!T$54","v":1},{"$f":" Time!U$54","v":0},{"$f":" Time!V$54","v":0},{"$f":" Time!W$54","v":0}]
[null,null,null,null,"Value of year 5 WRFIM adjustments at the end of AMP6 - Wholesale Water",null,"£m",{"$f":" SUM(J172:W172)","v":0},null,{"$f":"SUM(J169:J170) * J171","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total reward / (penalty) at the end of AMP6"]
[null,null,null,null,{"$f":" E$166","v":"Value of year 4 WRFIM adjustments at the end of AMP6 - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$166","v":0},0,0]
[null,null,null,null,{"$f":" E$172","v":"Value of year 5 WRFIM adjustments at the end of AMP6 - Wholesale Water"},{"$f":" F$172","v":0},{"$f":" G$172","v":"£m"},{"$f":" H$172","v":0},{"$f":" I$172","v":0},{"$f":" J$172","v":0},{"$f":" K$172","v":0},{"$f":" L$172","v":0},{"$f":" M$172","v":0},{"$f":" N$172","v":0},{"$f":" O$172","v":0},{"$f":" P$172","v":0},{"$f":" Q$172","v":0},{"$f":" R$172","v":0},{"$f":" S$172","v":0},{"$f":" T$172","v":0},{"$f":" U$172","v":0},0,0]
[null,null,null,null,"Total reward / (penalty) at the end of AMP6 - Wholesale Water",null,"£m",{"$f":" SUM(J177:W177)","v":0},null,{"$f":" SUM(J175:J176)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" SUM(U175:U176)","v":0},0,0]
[]
[]
["End of sheet"]

{"sheet":"Wastewater Network-Plus","index":6,"n_rows":165,"n_cols":23,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Wastewater Network-Plus"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["REVENUE RECOVERD"]
[]
[null,"Revenue Recovered: Non-Developer Services"]
[null,null,null,null,{"$f":" InpActive!E$119","v":"Actual Revenue (to be completed post PR24) - WW-N+ "},{"$f":" InpActive!F$119","v":0},{"$f":" InpActive!G$119","v":"£m"},{"$f":" InpActive!H$119","v":0},{"$f":" InpActive!I$119","v":0},{"$f":" InpActive!J$119","v":0},{"$f":" InpActive!K$119","v":0},{"$f":" InpActive!L$119","v":0},{"$f":" InpActive!M$119","v":0},{"$f":" InpActive!N$119","v":0},{"$f":" InpActive!O$119","v":0},{"$f":" InpActive!P$119","v":0},{"$f":" InpActive!Q$119","v":0},{"$f":" InpActive!R$119","v":0},{"$f":" InpActive!S$119","v":0},{"$f":" InpActive!T$119","v":0},{"$f":" InpActive!U$119","v":0},{"$f":" InpActive!V$119","v":0},{"$f":" InpActive!W$119","v":0}]
[null,null,null,"less",{"$f":"InpActive!E$133","v":"Actual revenue: developer services - WW-N+ "},{"$f":"InpActive!F$133","v":0},{"$f":"InpActive!G$133","v":"£m"},{"$f":"InpActive!H$133","v":0},{"$f":"InpActive!I$133","v":0},{"$f":"InpActive!J$133","v":0},{"$f":"InpActive!K$133","v":0},{"$f":"InpActive!L$133","v":0},{"$f":"InpActive!M$133","v":0},{"$f":"InpActive!N$133","v":0},{"$f":"InpActive!O$133","v":0},{"$f":"InpActive!P$133","v":0},{"$f":"InpActive!Q$133","v":0},{"$f":"InpActive!R$133","v":0},{"$f":"InpActive!S$133","v":0},{"$f":"InpActive!T$133","v":0},{"$f":"InpActive!U$133","v":0},{"$f":"InpActive!V$133","v":0},{"$f":"InpActive!W$133","v":0}]
[null,null,null,null,"ND: Actual Revenue (to be completed post PR24) - WW-N+",null,"£m",{"$f":" SUM(J12:W12)","v":0},null,{"$f":"J10-J11","v":0},{"$f":"K10-K11","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
["ALLOWED REVENUE"]
[]
[null,"Allowed Revenue: All (including developer services)"]
[null,null,null,null,{"$f":" InpActive!E$115","v":"Allowed revenue - WW-N+ (base year 2019/2020)"},{"$f":" InpActive!F$115","v":0},{"$f":" InpActive!G$115","v":"£m"},{"$f":" InpActive!H$115","v":0},{"$f":" InpActive!I$115","v":0},{"$f":" InpActive!J$115","v":0},{"$f":" InpActive!K$115","v":0},{"$f":" InpActive!L$115","v":0},{"$f":" InpActive!M$115","v":0},{"$f":" InpActive!N$115","v":0},{"$f":" InpActive!O$115","v":0},{"$f":" InpActive!P$115","v":0},{"$f":" InpActive!Q$115","v":0},{"$f":" InpActive!R$115","v":0},{"$f":" InpActive!S$115","v":0},{"$f":" InpActive!T$115","v":0},{"$f":" InpActive!U$115","v":0},{"$f":" InpActive!V$115","v":0},{"$f":" InpActive!W$115","v":0}]
[null,null,null,null,{"$f":" Index!E$56","v":"Revenue indexation - WW-N+"},{"$f":" Index!F$56","v":0},{"$f":" Index!G$56","v":"factor"},{"$f":" Index!H$56","v":0},{"$f":" Index!I$56","v":0},{"$f":" Index!J$56","v":0},{"$f":" Index!K$56","v":0},{"$f":" Index!L$56","v":0},{"$f":" Index!M$56","v":0},{"$f":" Index!N$56","v":0},{"$f":" Index!O$56","v":0},{"$f":" Index!P$56","v":1},{"$f":" Index!Q$56","v":1},{"$f":" Index!R$56","v":1},{"$f":" Index!S$56","v":1},{"$f":" Index!T$56","v":1},{"$f":" Index!U$56","v":0},{"$f":" Index!V$56","v":0},{"$f":" Index!W$56","v":0}]
[null,null,null,null,{"$f":" Time!E$75","v":"Last pre-forecast period flag"},{"$f":" Time!F$75","v":0},{"$f":" Time!G$75","v":"flag"},{"$f":" Time!H$75","v":1},{"$f":" Time!I$75","v":0},{"$f":" Time!J$75","v":0},{"$f":" Time!K$75","v":0},{"$f":" Time!L$75","v":0},{"$f":" Time!M$75","v":0},{"$f":" Time!N$75","v":0},{"$f":" Time!O$75","v":1},{"$f":" Time!P$75","v":0},{"$f":" Time!Q$75","v":0},{"$f":" Time!R$75","v":0},{"$f":" Time!S$75","v":0},{"$f":" Time!T$75","v":0},{"$f":" Time!U$75","v":0},{"$f":" Time!V$75","v":0},{"$f":" Time!W$75","v":0}]
[null,null,null,null,"Allowed revenue - WW-N+ (base year 2019/2020)",null,"£m",{"$f":" SUM(J20:W20)","v":0},null,{"$f":" IF(J19 = 1, $F17, I20 * J18)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U19 = 1, $F17, T20 * U18)","v":0},0,0]
[]
[null,null,null,null,{"$f":" E$20","v":"Allowed revenue - WW-N+ (base year 2019/2020)"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$20","v":0},0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Allowed revenue from FD - WW-N+",null,"£m",{"$f":" SUM(J24:W24)","v":0},null,{"$f":" IF(J23 = 1, J22, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U23 = 1, U22, 0)","v":0},0,0]
[]
[null,"Allowed Revenue: Developer Services"]
[null,null,null,null,{"$f":"Index!E$10","v":"CPIH Index Nov (from 2017/18)"},{"$f":"Index!F$10","v":0},{"$f":"Index!G$10","v":"index"},{"$f":"Index!H$10","v":0},{"$f":"Index!I$10","v":0},{"$f":"Index!J$10","v":0},{"$f":"Index!K$10","v":0},{"$f":"Index!L$10","v":0},{"$f":"Index!M$10","v":0},{"$f":"Index!N$10","v":0},{"$f":"Index!O$10","v":0},{"$f":"Index!P$10","v":0},{"$f":"Index!Q$10","v":0},{"$f":"Index!R$10","v":0},{"$f":"Index!S$10","v":0},{"$f":"Index!T$10","v":0},{"$f":"Index!U$10","v":0},{"$f":"Index!V$10","v":0},{"$f":"Index!W$10","v":0}]
[null,null,null,null,{"$f":" Time!E$32","v":"2017/18 indexation period flag"},{"$f":" Time!F$32","v":0},{"$f":" Time!G$32","v":"flag"},{"$f":" Time!H$32","v":1},{"$f":" Time!I$32","v":0},{"$f":" Time!J$32","v":0},{"$f":" Time!K$32","v":0},{"$f":" Time!L$32","v":0},{"$f":" Time!M$32","v":1},{"$f":" Time!N$32","v":0},{"$f":" Time!O$32","v":0},{"$f":" Time!P$32","v":0},{"$f":" Time!Q$32","v":0},{"$f":" Time!R$32","v":0},{"$f":" Time!S$32","v":0},{"$f":" Time!T$32","v":0},{"$f":" Time!U$32","v":0},{"$f":" Time!V$32","v":0},{"$f":" Time!W$32","v":0}]
[null,null,null,null,"CPIH Index from 2017/18 base",null,null,null,null,{"$f":" J27 * J28","v":0},{"$f":" K27 * K28","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"CPIH Index from 2017/18 ",{"$f":" SUM(J29:W29)","v":0}]
[]
[null,null,null,null,{"$f":" E$30","v":"CPIH Index from 2017/18 "},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"InpActive!E$131","v":"Allowed revenue: developer services - WW-N+ (base year 2017/2018)"},{"$f":"InpActive!F$131","v":0},{"$f":"InpActive!G$131","v":"£m"},{"$f":"InpActive!H$131","v":0},{"$f":"InpActive!I$131","v":0},{"$f":"InpActive!J$131","v":0},{"$f":"InpActive!K$131","v":0},{"$f":"InpActive!L$131","v":0},{"$f":"InpActive!M$131","v":0},{"$f":"InpActive!N$131","v":0},{"$f":"InpActive!O$131","v":0},{"$f":"InpActive!P$131","v":0},{"$f":"InpActive!Q$131","v":0},{"$f":"InpActive!R$131","v":0},{"$f":"InpActive!S$131","v":0},{"$f":"InpActive!T$131","v":0},{"$f":"InpActive!U$131","v":0},{"$f":"InpActive!V$131","v":0},{"$f":"InpActive!W$131","v":0}]
[null,null,null,null,{"$f":"Index!E$10","v":"CPIH Index Nov (from 2017/18)"},{"$f":"Index!F$10","v":0},{"$f":"Index!G$10","v":"index"},{"$f":"Index!H$10","v":0},{"$f":"Index!I$10","v":0},{"$f":"Index!J$10","v":0},{"$f":"Index!K$10","v":0},{"$f":"Index!L$10","v":0},{"$f":"Index!M$10","v":0},{"$f":"Index!N$10","v":0},{"$f":"Index!O$10","v":0},{"$f":"Index!P$10","v":0},{"$f":"Index!Q$10","v":0},{"$f":"Index!R$10","v":0},{"$f":"Index!S$10","v":0},{"$f":"Index!T$10","v":0},{"$f":"Index!U$10","v":0},{"$f":"Index!V$10","v":0},{"$f":"Index!W$10","v":0}]
[null,null,null,null,{"$f":"Time!E$59","v":"Forecast period flag"},{"$f":"Time!F$59","v":0},{"$f":"Time!G$59","v":"flag"},{"$f":"Time!H$59","v":5},{"$f":"Time!I$59","v":0},{"$f":"Time!J$59","v":0},{"$f":"Time!K$59","v":0},{"$f":"Time!L$59","v":0},{"$f":"Time!M$59","v":0},{"$f":"Time!N$59","v":0},{"$f":"Time!O$59","v":0},{"$f":"Time!P$59","v":1},{"$f":"Time!Q$59","v":1},{"$f":"Time!R$59","v":1},{"$f":"Time!S$59","v":1},{"$f":"Time!T$59","v":1},{"$f":"Time!U$59","v":0},{"$f":"Time!V$59","v":0},{"$f":"Time!W$59","v":0}]
[null,null,null,null,"Notional allowed revenue from FD - WW-N+ ",null,"£m",{"$f":" SUM(J36:W36)","v":0},null,{"$f":" IF($F32 = 0, 0, J35 * J33 * (J34 / $F$32 ))","v":0},{"$f":" IF($F32 = 0, 0, K35 * K33 * (K34 / $F$32 ))","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["BLIND YEAR ADJUSTMENT"]
[]
[null,"Blind year adjustment"]
[null,null,null,null,{"$f":" InpActive!E$123","v":"Blind year adjustment for year 2019/2020 - WW-N+ (base year 2019/2020)"},{"$f":" InpActive!F$123","v":0},{"$f":" InpActive!G$123","v":"£m"},{"$f":" InpActive!H$123","v":0},{"$f":" InpActive!I$123","v":0},{"$f":" InpActive!J$123","v":0},{"$f":" InpActive!K$123","v":0},{"$f":" InpActive!L$123","v":0},{"$f":" InpActive!M$123","v":0},{"$f":" InpActive!N$123","v":0},{"$f":" InpActive!O$123","v":0},{"$f":" InpActive!P$123","v":0},{"$f":" InpActive!Q$123","v":0},{"$f":" InpActive!R$123","v":0},{"$f":" InpActive!S$123","v":0},{"$f":" InpActive!T$123","v":0},{"$f":" InpActive!U$123","v":0},{"$f":" InpActive!V$123","v":0},{"$f":" InpActive!W$123","v":0}]
[null,null,null,null,{"$f":"InpActive!E$125","v":"Blind year profiling factor - WW-N+ "},{"$f":"InpActive!F$125","v":0},{"$f":"InpActive!G$125","v":"%"},{"$f":"InpActive!H$125","v":0},{"$f":"InpActive!I$125","v":0},{"$f":"InpActive!J$125","v":0},{"$f":"InpActive!K$125","v":0},{"$f":"InpActive!L$125","v":0},{"$f":"InpActive!M$125","v":0},{"$f":"InpActive!N$125","v":0},{"$f":"InpActive!O$125","v":0},{"$f":"InpActive!P$125","v":0},{"$f":"InpActive!Q$125","v":0},{"$f":"InpActive!R$125","v":0},{"$f":"InpActive!S$125","v":0},{"$f":"InpActive!T$125","v":0},{"$f":"InpActive!U$125","v":0},{"$f":"InpActive!V$125","v":0},{"$f":"InpActive!W$125","v":0}]
[null,null,null,null,"Blind year adjustment (profiled) - WW-N+ (base year 2019/20)",null,null,{"$f":" SUM(J44:W44)","v":0},null,{"$f":"J43*$F$42","v":0},0,0,0,0,0,0,0,0,0,{"$f":"T43*$F$42","v":0},{"$f":"U43*$F$42","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":"E$44","v":"Blind year adjustment (profiled) - WW-N+ (base year 2019/20)"},{"$f":"F$44","v":0},0,0,0,{"$f":"J$44","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$66","v":"Forecast period counter"},{"$f":" Time!F$66","v":0},{"$f":" Time!G$66","v":"counter"},{"$f":" Time!H$66","v":0},{"$f":" Time!I$66","v":0},{"$f":" Time!J$66","v":0},{"$f":" Time!K$66","v":0},{"$f":" Time!L$66","v":0},{"$f":" Time!M$66","v":0},{"$f":" Time!N$66","v":0},{"$f":" Time!O$66","v":0},{"$f":" Time!P$66","v":1},{"$f":" Time!Q$66","v":2},{"$f":" Time!R$66","v":3},{"$f":" Time!S$66","v":4},{"$f":" Time!T$66","v":5},{"$f":" Time!U$66","v":0},{"$f":" Time!V$66","v":0},{"$f":" Time!W$66","v":0}]
[null,null,null,null,"Blind year (profiled) inc. financing rate adjustment - WW-N+ (base year 2019/2020)",null,"£m",null,null,{"$f":"J47*(1 + $F$46)^J48","v":0},{"$f":"K47*(1 + $F$46)^K48","v":0},0,0,0,0,0,{"$f":"Q47*(1 + $F$46)^Q48","v":0},{"$f":"R47*(1 + $F$46)^R48","v":0},{"$f":"S47*(1 + $F$46)^S48","v":0},0,0,0,0]
[]
[null,null,null,null,{"$f":"Index!E$22","v":"CPIH: Nov - Nov index inflating from 2019/20"},{"$f":"Index!F$22","v":0},{"$f":"Index!G$22","v":"index"},{"$f":"Index!H$22","v":0},{"$f":"Index!I$22","v":0},{"$f":"Index!J$22","v":0},{"$f":"Index!K$22","v":0},{"$f":"Index!L$22","v":0},{"$f":"Index!M$22","v":0},{"$f":"Index!N$22","v":0},{"$f":"Index!O$22","v":0},{"$f":"Index!P$22","v":0},{"$f":"Index!Q$22","v":0},{"$f":"Index!R$22","v":0},{"$f":"Index!S$22","v":0},{"$f":"Index!T$22","v":0},{"$f":"Index!U$22","v":0},{"$f":"Index!V$22","v":0},{"$f":"Index!W$22","v":0}]
[null,null,null,null,{"$f":"E$49","v":"Blind year (profiled) inc. financing rate adjustment - WW-N+ (base year 2019/2020)"},{"$f":"F$49","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Blind year (profiled) inc. financing rate adjustment - WW-N+",null,"£m",{"$f":" SUM(J53:W53)","v":0},null,{"$f":" J51 * J52","v":0},{"$f":" K51 * K52","v":0},0,0,0,0,0,0,0,0,0,{"$f":" U51 * U52","v":0},0,0]
[]
["REVENUE CORRECTION"]
[]
[null,"Main revenue over /  under recovery: All (Including Developer Services)"]
[null,null,null,null,{"$f":" E$24","v":"Allowed revenue from FD - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$53","v":"Blind year (profiled) inc. financing rate adjustment - WW-N+"},0,"£m",0,0,{"$f":" J$53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$133","v":"AMP6 forecasting incentive adjustment including over / under recovery true up"},{"$f":" F$133","v":"2 PD LK BCK"},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Adjusted allowed revenue - WW-N+ (AR)",null,"£m",{"$f":" SUM(J61:W61)","v":0},null,{"$f":" SUM(J58:J60)","v":0},{"$f":" SUM(K58:K60)","v":0},{"$f":" SUM(L58:L60)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$61","v":"Adjusted allowed revenue - WW-N+ (AR)"},0,"£m",0,0,0,{"$f":" K$61","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" InpActive!E$119","v":"Actual Revenue (to be completed post PR24) - WW-N+ "},{"$f":" InpActive!F$119","v":0},{"$f":" InpActive!G$119","v":"£m"},{"$f":" InpActive!H$119","v":0},{"$f":" InpActive!I$119","v":0},{"$f":" InpActive!J$119","v":0},{"$f":" InpActive!K$119","v":0},{"$f":" InpActive!L$119","v":0},{"$f":" InpActive!M$119","v":0},{"$f":" InpActive!N$119","v":0},{"$f":" InpActive!O$119","v":0},{"$f":" InpActive!P$119","v":0},{"$f":" InpActive!Q$119","v":0},{"$f":" InpActive!R$119","v":0},{"$f":" InpActive!S$119","v":0},{"$f":" InpActive!T$119","v":0},{"$f":" InpActive!U$119","v":0},{"$f":" InpActive!V$119","v":0},{"$f":" InpActive!W$119","v":0}]
[null,null,null,null,"Revenue Imbalance  - WW-N+ ",null,"£m",{"$f":" SUM(J65:W65)","v":0},null,{"$f":"J63-J64","v":0},{"$f":"K63-K64","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Main revenue adjustment"]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":"E$65","v":"Revenue Imbalance  - WW-N+ "},{"$f":"F$65","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period flag"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"flag"},{"$f":" Time!H$59","v":5},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":0},{"$f":" Time!O$59","v":0},{"$f":" Time!P$59","v":1},{"$f":" Time!Q$59","v":1},{"$f":" Time!R$59","v":1},{"$f":" Time!S$59","v":1},{"$f":" Time!T$59","v":1},{"$f":" Time!U$59","v":0},{"$f":" Time!V$59","v":0},{"$f":" Time!W$59","v":0}]
[null,null,null,null,"Main revenue adjustment - with financing adjustment - WW-N+",null,"£m",{"$f":" SUM(J72:W72)","v":0},null,{"$f":" IF(J71 =1,  J70 * (1 + $F69) * (1 + $F69), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":" E$72","v":"Main revenue adjustment - with financing adjustment - WW-N+"},{"$f":" F$72","v":0},{"$f":" G$72","v":"£m"},{"$f":" H$72","v":0},{"$f":" I$72","v":0},{"$f":" J$72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - WW-N+",null,"£m",{"$f":" SUM(J76:W76)","v":0},null,{"$f":" J75 * K74 * L74","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U75 * V74 * W74","v":0},{"$f":" V75 * W74 * X74","v":0},{"$f":" W75 * X74 * Y74","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":" E$76","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - WW-N+"},{"$f":" F$76","v":0},{"$f":" G$76","v":"£m"},{"$f":" H$76","v":0},{"$f":" I$76","v":0},{"$f":" J$76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},{"$f":" Time!F$131","v":0},{"$f":" Time!G$131","v":"year #"},{"$f":" Time!H$131","v":0},{"$f":" Time!I$131","v":0},{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,"Main revenue adjustment - as incurred - WW-N+",null,"£m",{"$f":" SUM(J81:W81)","v":0},null,{"$f":" SUMIF($J80:$W80, J80 - $F78, $J79:$W79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["PENALTY CALCULATION"]
[]
[null,"Main revenue over /  under recovery: Non-Developer Services"]
[null,null,null,null,{"$f":"E$61","v":"Adjusted allowed revenue - WW-N+ (AR)"},{"$f":"F$61","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":"E$36","v":"Notional allowed revenue from FD - WW-N+ "},{"$f":"F$36","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"ND: Adjusted allowed revenue - WW-N+ (AR)",null,"£m",{"$f":" SUM(J88:W88)","v":0},null,{"$f":"J86-J87","v":0},{"$f":"K86-K87","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$12","v":"ND: Actual Revenue (to be completed post PR24) - WW-N+"},{"$f":"F$12","v":0},{"$f":"G$12","v":"£m"},{"$f":"H$12","v":0},{"$f":"I$12","v":0},{"$f":"J$12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" E$88","v":"ND: Adjusted allowed revenue - WW-N+ (AR)"},{"$f":" F$88","v":0},{"$f":" G$88","v":"£m"},{"$f":" H$88","v":0},{"$f":" I$88","v":0},{"$f":" J$88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"ND: Revenue Imbalance - WW-N+",null,"£m",{"$f":" SUM(J92:W92)","v":0},null,{"$f":" J90 - J91","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U90 - U91","v":0},0,0]
[]
[null,"Penalty calculation"]
[null,null,null,null,{"$f":"E$12","v":"ND: Actual Revenue (to be completed post PR24) - WW-N+"},{"$f":"F$12","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$88","v":"ND: Adjusted allowed revenue - WW-N+ (AR)"},{"$f":" F$88","v":0},{"$f":" G$88","v":"£m"},{"$f":" H$88","v":0},{"$f":" I$88","v":0},{"$f":" J$88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"ND: Forecast error - WW-N+",null,"%",null,null,{"$f":" IF(J96 = 0, 0, ABS(J95 - J96) / J96)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U96 = 0, 0, ABS(U95 - U96) / U96)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$58","v":"Minimum threshold (+/-)"},{"$f":" InpActive!F$58","v":0.02},{"$f":" InpActive!G$58","v":"%"},{"$f":" InpActive!H$58","v":0},{"$f":" InpActive!I$58","v":0},{"$f":" InpActive!J$58","v":0},{"$f":" InpActive!K$58","v":0},{"$f":" InpActive!L$58","v":0},{"$f":" InpActive!M$58","v":0},{"$f":" InpActive!N$58","v":0},{"$f":" InpActive!O$58","v":0},{"$f":" InpActive!P$58","v":0},{"$f":" InpActive!Q$58","v":0},{"$f":" InpActive!R$58","v":0},{"$f":" InpActive!S$58","v":0},{"$f":" InpActive!T$58","v":0},{"$f":" InpActive!U$58","v":0},{"$f":" InpActive!V$58","v":0},{"$f":" InpActive!W$58","v":0}]
[null,null,null,null,{"$f":" E$97","v":"ND: Forecast error - WW-N+"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$97","v":0},0,0]
[null,null,null,null,"Penalty applicable - WW-N+",null,"flag",null,null,{"$f":" IF(J100 > $F99, 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U100 > $F99, 1, 0)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$58","v":"Minimum threshold (+/-)"},{"$f":" InpActive!F$58","v":0.02},{"$f":" InpActive!G$58","v":"%"},{"$f":" InpActive!H$58","v":0},{"$f":" InpActive!I$58","v":0},{"$f":" InpActive!J$58","v":0},{"$f":" InpActive!K$58","v":0},{"$f":" InpActive!L$58","v":0},{"$f":" InpActive!M$58","v":0},{"$f":" InpActive!N$58","v":0},{"$f":" InpActive!O$58","v":0},{"$f":" InpActive!P$58","v":0},{"$f":" InpActive!Q$58","v":0},{"$f":" InpActive!R$58","v":0},{"$f":" InpActive!S$58","v":0},{"$f":" InpActive!T$58","v":0},{"$f":" InpActive!U$58","v":0},{"$f":" InpActive!V$58","v":0},{"$f":" InpActive!W$58","v":0}]
[null,null,null,null,{"$f":" InpActive!E$60","v":"Maximum threshold (+/-)"},{"$f":" InpActive!F$60","v":0.03},{"$f":" InpActive!G$60","v":"%"},{"$f":" InpActive!H$60","v":0},{"$f":" InpActive!I$60","v":0},{"$f":" InpActive!J$60","v":0},{"$f":" InpActive!K$60","v":0},{"$f":" InpActive!L$60","v":0},{"$f":" InpActive!M$60","v":0},{"$f":" InpActive!N$60","v":0},{"$f":" InpActive!O$60","v":0},{"$f":" InpActive!P$60","v":0},{"$f":" InpActive!Q$60","v":0},{"$f":" InpActive!R$60","v":0},{"$f":" InpActive!S$60","v":0},{"$f":" InpActive!T$60","v":0},{"$f":" InpActive!U$60","v":0},{"$f":" InpActive!V$60","v":0},{"$f":" InpActive!W$60","v":0}]
[null,null,null,null,{"$f":" E$97","v":"ND: Forecast error - WW-N+"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$97","v":0},0,0]
[null,null,null,null,{"$f":" E$101","v":"Penalty applicable - WW-N+"},0,"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$101","v":0},0,0]
[null,null,null,null,"Error magnitude - WW-N+",null,"factor",null,null,{"$f":" IF(J106 = 1, (J105 - $F103) / ($F104 - $F103), 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U106 = 1, (U105 - $F103) / ($F104 - $F103), 0)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$62","v":"Penalty rate (+/-)"},{"$f":" InpActive!F$62","v":0.03},{"$f":" InpActive!G$62","v":"%"},{"$f":" InpActive!H$62","v":0},{"$f":" InpActive!I$62","v":0},{"$f":" InpActive!J$62","v":0},{"$f":" InpActive!K$62","v":0},{"$f":" InpActive!L$62","v":0},{"$f":" InpActive!M$62","v":0},{"$f":" InpActive!N$62","v":0},{"$f":" InpActive!O$62","v":0},{"$f":" InpActive!P$62","v":0},{"$f":" InpActive!Q$62","v":0},{"$f":" InpActive!R$62","v":0},{"$f":" InpActive!S$62","v":0},{"$f":" InpActive!T$62","v":0},{"$f":" InpActive!U$62","v":0},{"$f":" InpActive!V$62","v":0},{"$f":" InpActive!W$62","v":0}]
[null,null,null,null,{"$f":" E$107","v":"Error magnitude - WW-N+"},0,"factor",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$107","v":0},0,0]
[null,null,null,null,"Penalty rate magnitude - WW-N+",null,"%",null,null,{"$f":" $F109 * MIN(1, J110)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" $F109 * MIN(1, U110)","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$70","v":"Timing delay"},{"$f":" InpActive!F$70","v":2},{"$f":" InpActive!G$70","v":"years"},{"$f":" InpActive!H$70","v":0},{"$f":" InpActive!I$70","v":0},{"$f":" InpActive!J$70","v":0},{"$f":" InpActive!K$70","v":0},{"$f":" InpActive!L$70","v":0},{"$f":" InpActive!M$70","v":0},{"$f":" InpActive!N$70","v":0},{"$f":" InpActive!O$70","v":0},{"$f":" InpActive!P$70","v":0},{"$f":" InpActive!Q$70","v":0},{"$f":" InpActive!R$70","v":0},{"$f":" InpActive!S$70","v":0},{"$f":" InpActive!T$70","v":0},{"$f":" InpActive!U$70","v":0},{"$f":" InpActive!V$70","v":0},{"$f":" InpActive!W$70","v":0}]
[null,null,null,null,{"$f":"E$12","v":"ND: Actual Revenue (to be completed post PR24) - WW-N+"},{"$f":"F$12","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$88","v":"ND: Adjusted allowed revenue - WW-N+ (AR)"},{"$f":" F$88","v":0},{"$f":" G$88","v":"£m"},{"$f":" H$88","v":0},{"$f":" I$88","v":0},{"$f":" J$88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$111","v":"Penalty rate magnitude - WW-N+"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$111","v":0},0,0]
[null,null,null,null,{"$f":"Time!E$59","v":"Forecast period flag"},{"$f":"Time!F$59","v":0},{"$f":"Time!G$59","v":"flag"},{"$f":"Time!H$59","v":5},{"$f":"Time!I$59","v":0},{"$f":"Time!J$59","v":0},{"$f":"Time!K$59","v":0},{"$f":"Time!L$59","v":0},{"$f":"Time!M$59","v":0},{"$f":"Time!N$59","v":0},{"$f":"Time!O$59","v":0},{"$f":"Time!P$59","v":1},{"$f":"Time!Q$59","v":1},{"$f":"Time!R$59","v":1},{"$f":"Time!S$59","v":1},{"$f":"Time!T$59","v":1},{"$f":"Time!U$59","v":0},{"$f":"Time!V$59","v":0},{"$f":"Time!W$59","v":0}]
[null,null,null,null,"Penalty adjustment - WW-N+ POS",null,"£m",{"$f":" SUM(J118:W118)","v":0},null,{"$f":"  IF(J117=1, J116 * ABS(J114 - J115), 0 )","v":0},0,0,0,0,0,{"$f":"  IF(P117=1, P116 * ABS(P114 - P115), 0 )","v":0},{"$f":"  IF(Q117=1, Q116 * ABS(Q114 - Q115), 0 )","v":0},0,0,0,0,0,0]
[null,null,null,null,{"$f":" LEFT(E118, LEN(E118) - 4)","v":"Penalty adjustment - WW-N+"},null,"£m",{"$f":" SUM(J119:W119)","v":0},null,{"$f":" -1 * J118","v":0},0,0,0,0,0,{"$f":" -1 * P118","v":0},0,0,0,0,{"$f":" -1 * U118","v":0},0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":" E$119","v":"Penalty adjustment - WW-N+"},{"$f":" F$119","v":0},{"$f":" G$119","v":"£m"},{"$f":" H$119","v":0},{"$f":" I$119","v":0},{"$f":" J$119","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U$119","v":0},0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment - WW-N+",null,"£m",{"$f":" SUM(J123:W123)","v":0},null,{"$f":" J122 * (1 + $F121)","v":0},0,0,0,0,0,{"$f":" P122 * (1 + $F121)","v":0},0,0,0,0,{"$f":" U122 * (1 + $F121)","v":0},0,0]
[]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":" E$123","v":"Penalty adjustment - with financing adjustment - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$123","v":0},0,0]
[null,null,null,null,{"$f":"Time!E$87","v":"Forecast period flag"},{"$f":"Time!F$87","v":0},{"$f":"Time!G$87","v":"flag"},{"$f":"Time!H$87","v":5},{"$f":"Time!I$87","v":0},{"$f":"Time!J$87","v":0},{"$f":"Time!K$87","v":0},{"$f":"Time!L$87","v":0},{"$f":"Time!M$87","v":0},{"$f":"Time!N$87","v":0},{"$f":"Time!O$87","v":0},{"$f":"Time!P$87","v":1},{"$f":"Time!Q$87","v":1},{"$f":"Time!R$87","v":1},{"$f":"Time!S$87","v":1},{"$f":"Time!T$87","v":1},{"$f":"Time!U$87","v":0},{"$f":"Time!V$87","v":0},{"$f":"Time!W$87","v":0}]
[null,null,null,null,"Penalty adjustment - with financing adjustment & 2 year lag of inflation - WW-N+",null,"£m",{"$f":" SUM(J128:W128)","v":0},null,{"$f":"IF(J127=1,J126*K125*L125,0)","v":0},{"$f":"IF(K127=1,K126*L125*M125,0)","v":0},0,{"$f":"IF(M127=1,M126*N125*O125,0)","v":0},0,0,{"$f":"IF(P127=1,P126*Q125*R125,0)","v":0},{"$f":"IF(Q127=1,Q126*R125*S125,0)","v":0},{"$f":"IF(R127=1,R126*S125*T125,0)","v":0},0,{"$f":"IF(T127=1,T126*U125*V125,0)","v":0},{"$f":"IF(U127=1,U126*V125*W125,0)","v":0}]
[]
[null,null,null,null,{"$f":" E$76","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - WW-N+"},{"$f":" F$76","v":0},{"$f":" G$76","v":"£m"},{"$f":" H$76","v":0},{"$f":" I$76","v":0},{"$f":" J$76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$128","v":"Penalty adjustment - with financing adjustment & 2 year lag of inflation - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$128","v":0},0,0]
[null,null,null,null,{"$f":"Time!E$64","v":"Forecast period flag"},{"$f":"Time!F$64","v":0},{"$f":"Time!G$64","v":"flag"},{"$f":"Time!H$64","v":5},{"$f":"Time!I$64","v":0},{"$f":"Time!J$64","v":0},{"$f":"Time!K$64","v":0},{"$f":"Time!L$64","v":0},{"$f":"Time!M$64","v":0},{"$f":"Time!N$64","v":0},{"$f":"Time!O$64","v":0},{"$f":"Time!P$64","v":1},{"$f":"Time!Q$64","v":1},{"$f":"Time!R$64","v":1},{"$f":"Time!S$64","v":1},{"$f":"Time!T$64","v":1},{"$f":"Time!U$64","v":0},{"$f":"Time!V$64","v":0},{"$f":"Time!W$64","v":0}]
[null,null,null,null,"AMP6 forecasting incentive adjustment including over / under recovery true up","2 PD LK BCK","£m",{"$f":" SUM(J133:W133)","v":0},null,null,{"$f":" ( I130 + I131 ) * K132","v":0},{"$f":" ( J130 + J131 ) * L132","v":0},0,0,0,{"$f":" ( N130 + N131 ) * P132","v":0},{"$f":" ( O130 + O131 ) * Q132","v":0},0,0,{"$f":" ( R130 + R131 ) * T132","v":0},0,0,0]
[]
[null,"Performance variance level check"]
[null,null,null,null,{"$f":" InpActive!E$66","v":"Threshold for additional variance analyses (+/-)"},{"$f":" InpActive!F$66","v":0.06},{"$f":" InpActive!G$66","v":"%"},{"$f":" InpActive!H$66","v":0},{"$f":" InpActive!I$66","v":0},{"$f":" InpActive!J$66","v":0},{"$f":" InpActive!K$66","v":0},{"$f":" InpActive!L$66","v":0},{"$f":" InpActive!M$66","v":0},{"$f":" InpActive!N$66","v":0},{"$f":" InpActive!O$66","v":0},{"$f":" InpActive!P$66","v":0},{"$f":" InpActive!Q$66","v":0},{"$f":" InpActive!R$66","v":0},{"$f":" InpActive!S$66","v":0},{"$f":" InpActive!T$66","v":0},{"$f":" InpActive!U$66","v":0},{"$f":" InpActive!V$66","v":0},{"$f":" InpActive!W$66","v":0}]
[null,null,null,null,{"$f":"E$97","v":"ND: Forecast error - WW-N+"},{"$f":"F$97","v":0},{"$f":"G$97","v":"%"},{"$f":"H$97","v":0},{"$f":"I$97","v":0},{"$f":"J$97","v":0},0,0,0,0,0,0,{"$f":"Q$97","v":0},0,0,0,0,0,0]
[null,null,null,null,"Performance variance level alert - WW-N+",{"$f":" IF(SUM(J138:W138) > 0, 1, 0)","v":0},"alert",null,null,{"$f":" IF(ABS(J137) > $F136, 1, 0)","v":0},0,0,0,0,0,0,{"$f":" IF(ABS(Q137) > $F136, 1, 0)","v":0},0,0,0,{"$f":" IF(ABS(U137) > $F136, 1, 0)","v":0},0,0]
[]
[]
["APPLICATION OF PENALTY"]
[]
[null,"One year of CPIH and financing costs adjustments applied"]
[null,null,null,null,{"$f":" InpActive!E$64","v":"Discount rate"},{"$f":" InpActive!F$64","v":0},{"$f":" InpActive!G$64","v":"%"},{"$f":" InpActive!H$64","v":0},{"$f":" InpActive!I$64","v":0},{"$f":" InpActive!J$64","v":0},{"$f":" InpActive!K$64","v":0},{"$f":" InpActive!L$64","v":0},{"$f":" InpActive!M$64","v":0},{"$f":" InpActive!N$64","v":0},{"$f":" InpActive!O$64","v":0},{"$f":" InpActive!P$64","v":0},{"$f":" InpActive!Q$64","v":0},{"$f":" InpActive!R$64","v":0},{"$f":" InpActive!S$64","v":0},{"$f":" InpActive!T$64","v":0},{"$f":" InpActive!U$64","v":0},{"$f":" InpActive!V$64","v":0},{"$f":" InpActive!W$64","v":0}]
[null,null,null,null,{"$f":" Index!E$11","v":"CPIH: Nov % increase - CALC"},{"$f":" Index!F$11","v":0},{"$f":" Index!G$11","v":"%"},{"$f":" Index!H$11","v":0},{"$f":" Index!I$11","v":0},{"$f":" Index!J$11","v":0},{"$f":" Index!K$11","v":0},{"$f":" Index!L$11","v":0},{"$f":" Index!M$11","v":0},{"$f":" Index!N$11","v":0},{"$f":" Index!O$11","v":0},{"$f":" Index!P$11","v":0},{"$f":" Index!Q$11","v":0},{"$f":" Index!R$11","v":0},{"$f":" Index!S$11","v":0},{"$f":" Index!T$11","v":0},{"$f":" Index!U$11","v":0},{"$f":" Index!V$11","v":0},{"$f":" Index!W$11","v":0}]
[null,null,null,null,{"$f":"E$65","v":"Revenue Imbalance  - WW-N+ "},0,"£m",0,0,0,{"$f":"K$65","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$119","v":"Penalty adjustment - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$119","v":0},0,0]
[null,null,null,null,{"$f":" Time!E$54","v":"Forecast end period flag"},{"$f":" Time!F$54","v":0},{"$f":" Time!G$54","v":"flag"},{"$f":" Time!H$54","v":1},{"$f":" Time!I$54","v":0},{"$f":" Time!J$54","v":0},{"$f":" Time!K$54","v":0},{"$f":" Time!L$54","v":0},{"$f":" Time!M$54","v":0},{"$f":" Time!N$54","v":0},{"$f":" Time!O$54","v":0},{"$f":" Time!P$54","v":0},{"$f":" Time!Q$54","v":0},{"$f":" Time!R$54","v":0},{"$f":" Time!S$54","v":0},{"$f":" Time!T$54","v":1},{"$f":" Time!U$54","v":0},{"$f":" Time!V$54","v":0},{"$f":" Time!W$54","v":0}]
[null,null,null,null,"Value of year 4 main revenue adjustment at the end of AMP6 - WW",null,"£m",{"$f":" SUM(J149:W149)","v":0},null,{"$f":" IF(J148 = 1, I146 * J145 * (1 + $F144), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Value of year 4 penalty adjustment at the end of AMP6 - WW",null,"£m",{"$f":" SUM(J150:W150)","v":0},null,{"$f":" J148 * ( I147 * J145 * (1 + $F144))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Value of year 4 RFI adjustments at the end of AMP6 - WW",null,"£m",{"$f":" SUM(J151:W151)","v":0},null,{"$f":" SUM(J149:J150)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"No CPIH and financing costs adjustments applied"]
[null,null,null,null,{"$f":"E$65","v":"Revenue Imbalance  - WW-N+ "},0,"£m",0,0,0,{"$f":"K$65","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$119","v":"Penalty adjustment - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$119","v":0},0,0]
[null,null,null,null,{"$f":" Time!E$54","v":"Forecast end period flag"},{"$f":" Time!F$54","v":0},{"$f":" Time!G$54","v":"flag"},{"$f":" Time!H$54","v":1},{"$f":" Time!I$54","v":0},{"$f":" Time!J$54","v":0},{"$f":" Time!K$54","v":0},{"$f":" Time!L$54","v":0},{"$f":" Time!M$54","v":0},{"$f":" Time!N$54","v":0},{"$f":" Time!O$54","v":0},{"$f":" Time!P$54","v":0},{"$f":" Time!Q$54","v":0},{"$f":" Time!R$54","v":0},{"$f":" Time!S$54","v":0},{"$f":" Time!T$54","v":1},{"$f":" Time!U$54","v":0},{"$f":" Time!V$54","v":0},{"$f":" Time!W$54","v":0}]
[null,null,null,null,"Value of year 5 RFI adjustments at the end of AMP6 - WW",null,"£m",{"$f":" SUM(J157:W157)","v":0},null,{"$f":"SUM(J154:J155) * J156","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total reward / (penalty) at the end of AMP6"]
[null,null,null,null,{"$f":" E$151","v":"Value of year 4 RFI adjustments at the end of AMP6 - WW"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$151","v":0},0,0]
[null,null,null,null,{"$f":" E$157","v":"Value of year 5 RFI adjustments at the end of AMP6 - WW"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$157","v":0},0,0]
[null,null,null,null,"Total reward / (penalty) at the end of AMP6 - WW",null,"£m",{"$f":" SUM(J162:W162)","v":0},null,{"$f":" SUM(J160:J161)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" SUM(U160:U161)","v":0},0,0]
[]
[]
["End of sheet"]

{"sheet":"Output","index":7,"n_rows":13,"n_cols":23,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Output"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" Checks!F$9","v":0},{"$f":" Checks!G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" Checks!F$23","v":0},{"$f":" Checks!G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["RFI ADJUSTMENT AT THE END OF AMP6"]
[]
[null,null,null,null,{"$f":" 'Wholesale Water'!E$177","v":"Total reward / (penalty) at the end of AMP6 - Wholesale Water"},{"$f":" 'Wholesale Water'!F$177","v":0},{"$f":" 'Wholesale Water'!G$177","v":"£m"},{"$f":" 'Wholesale Water'!H$177","v":0},{"$f":" 'Wholesale Water'!I$177","v":0},{"$f":" 'Wholesale Water'!J$177","v":0},{"$f":" 'Wholesale Water'!K$177","v":0},{"$f":" 'Wholesale Water'!L$177","v":0},{"$f":" 'Wholesale Water'!M$177","v":0},{"$f":" 'Wholesale Water'!N$177","v":0},{"$f":" 'Wholesale Water'!O$177","v":0},{"$f":" 'Wholesale Water'!P$177","v":0},{"$f":" 'Wholesale Water'!Q$177","v":0},{"$f":" 'Wholesale Water'!R$177","v":0},{"$f":" 'Wholesale Water'!S$177","v":0},{"$f":" 'Wholesale Water'!T$177","v":0},{"$f":" 'Wholesale Water'!U$177","v":0},{"$f":" 'Wholesale Water'!V$177","v":0},{"$f":" 'Wholesale Water'!W$177","v":0}]
[]
[null,null,null,null,{"$f":" 'Wastewater Network-Plus'!E$162","v":"Total reward / (penalty) at the end of AMP6 - WW"},{"$f":" 'Wastewater Network-Plus'!F$162","v":0},{"$f":" 'Wastewater Network-Plus'!G$162","v":"£m"},{"$f":" 'Wastewater Network-Plus'!H$162","v":0},{"$f":" 'Wastewater Network-Plus'!I$162","v":0},{"$f":" 'Wastewater Network-Plus'!J$162","v":0},{"$f":" 'Wastewater Network-Plus'!K$162","v":0},{"$f":" 'Wastewater Network-Plus'!L$162","v":0},{"$f":" 'Wastewater Network-Plus'!M$162","v":0},{"$f":" 'Wastewater Network-Plus'!N$162","v":0},{"$f":" 'Wastewater Network-Plus'!O$162","v":0},{"$f":" 'Wastewater Network-Plus'!P$162","v":0},{"$f":" 'Wastewater Network-Plus'!Q$162","v":0},{"$f":" 'Wastewater Network-Plus'!R$162","v":0},{"$f":" 'Wastewater Network-Plus'!S$162","v":0},{"$f":" 'Wastewater Network-Plus'!T$162","v":0},{"$f":" 'Wastewater Network-Plus'!U$162","v":0},{"$f":" 'Wastewater Network-Plus'!V$162","v":0},{"$f":" 'Wastewater Network-Plus'!W$162","v":0}]
[]
["End of sheet"]

{"sheet":"Checks","index":8,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Checks"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},{"$f":" F$9","v":0},{"$f":" G$9","v":"Checks"},null,null,{"$f":" Time!J$25","v":"2015-03-31"},{"$f":" Time!K$25","v":"2016-03-31"},{"$f":" Time!L$25","v":"2017-03-31"},{"$f":" Time!M$25","v":"2018-03-31"},{"$f":" Time!N$25","v":"2019-03-31"},{"$f":" Time!O$25","v":"2020-03-31"},{"$f":" Time!P$25","v":"2021-03-31"},{"$f":" Time!Q$25","v":"2022-03-31"},{"$f":" Time!R$25","v":"2023-03-31"},{"$f":" Time!S$25","v":"2024-03-31"},{"$f":" Time!T$25","v":"2025-03-31"},{"$f":" Time!U$25","v":"2026-03-31"},{"$f":" Time!V$25","v":"2027-03-31"},{"$f":" Time!W$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":" Time!E$109","v":"Timeline label"},{"$f":" F$23","v":0},{"$f":" G$23","v":"Alerts"},null,null,{"$f":" Time!J$109","v":"Pre-Fcst"},{"$f":" Time!K$109","v":"Pre-Fcst"},{"$f":" Time!L$109","v":"Pre-Fcst"},{"$f":" Time!M$109","v":"Pre-Fcst"},{"$f":" Time!N$109","v":"Pre-Fcst"},{"$f":" Time!O$109","v":"Pre-Fcst"},{"$f":" Time!P$109","v":"Forecast"},{"$f":" Time!Q$109","v":"Forecast"},{"$f":" Time!R$109","v":"Forecast"},{"$f":" Time!S$109","v":"Forecast"},{"$f":" Time!T$109","v":"Forecast"},{"$f":" Time!U$109","v":"Post-Fcst"},{"$f":" Time!V$109","v":"Post-Fcst"},{"$f":" Time!W$109","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$131","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$131","v":2015},{"$f":" Time!K$131","v":2016},{"$f":" Time!L$131","v":2017},{"$f":" Time!M$131","v":2018},{"$f":" Time!N$131","v":2019},{"$f":" Time!O$131","v":2020},{"$f":" Time!P$131","v":2021},{"$f":" Time!Q$131","v":2022},{"$f":" Time!R$131","v":2023},{"$f":" Time!S$131","v":2024},{"$f":" Time!T$131","v":2025},{"$f":" Time!U$131","v":2026},{"$f":" Time!V$131","v":2027},{"$f":" Time!W$131","v":2028}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11},{"$f":" Time!U$10","v":12},{"$f":" Time!V$10","v":13},{"$f":" Time!W$10","v":14}]
[]
["CHECK SUMMARY"]
[]
[null,null,null,null,"Total Checks",{"$f":" SUM(F11:F19)","v":0},"Checks"]
[]
[null,null,null,null,"[do not delete this row]","[range start]"]
[]
[null,null,null,null,{"$f":" InpActive!E$101","v":"Blind year profiling factor - Water-N+ - Validation"},{"$f":" InpActive!F$101","v":0},{"$f":" InpActive!G$101","v":"Check"}]
[null,null,null,null,{"$f":" InpActive!E$127","v":"Blind year profiling factor - WW-N+ - Validation"},{"$f":" InpActive!F$127","v":0},{"$f":" InpActive!G$127","v":"Check"}]
[null,null,null,null,{"$f":"Time!E$123","v":"Modelling period check"},{"$f":"Time!F$123","v":0},{"$f":"Time!G$123","v":"check"}]
[]
[]
[]
[null,null,null,null,"[do not delete this row]","[range ends]"]
[]
["Alert Summary"]
[]
[null,null,null,null,"Total Alerts",{"$f":" SUM(F25:F30)","v":0},"Alerts"]
[]
[null,null,null,null,"[do not delete this row]","[range start]"]
[]
[null,null,null,null,{"$f":" 'Wholesale Water'!E$152","v":"Performance variance level alert"},{"$f":" 'Wholesale Water'!F$152","v":0},{"$f":" 'Wholesale Water'!G$152","v":"alert"}]
[null,null,null,null,{"$f":" 'Wastewater Network-Plus'!E$138","v":"Performance variance level alert - WW-N+"},{"$f":" 'Wastewater Network-Plus'!F$138","v":0},{"$f":" 'Wastewater Network-Plus'!G$138","v":"alert"}]
[]
[null,null,null,null,"[do not delete this row]","[range ends]"]
[]
["End of sheet"]