{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Map & Key","InpActive","Time","Indices and K factor","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":"Updated RFI illustrative model - 18 July 2019"}]
[null,null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"Updated RFI illustrative model - 18 July 2019.xlsm"}]
[null,null,"Date:","2019-07-18"]
[null,null,"Author:","Ofwat"]
[null,null,"Author contact information:","pr19@ofwat.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 further refinements to it in due course."]
[null,null,null,"Rulebook",null,"We will publish a PR19 Reconcilation Rulebook in due course. "]
[null,null,null,"Licence changes",null,"As noted in our Final Methodology document, we are consulting on a licence modification that would enable 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 addresses."]
[null,null,null,"pr19@ofwat.gov.uk   Asen.Velyov@ofwat.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":" 'Indices and K factor'!A$1","v":"Indices and K factor"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"All the indexation related and K Factor 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":134,"n_cols":23,"rows_kept":134,"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(J34:W34)","v":100},null,100]
[]
[null,null,null,null,"CPIH: Forecast Annual Increase",null,"%"]
[]
[null,null,null,null,"CPIH Index Nov - forecast",null,"index",{"$f":"SUM(J38:W38)","v":1400},null,{"$f":" IF( J34>0, J34, I40 * ( 1 + $F$36 ) )","v":100},{"$f":" IF( K34>0, K34, J38 * ( 1 + $F$36 ) )","v":100},{"$f":" IF( L34>0, L34, K38 * ( 1 + $F$36 ) )","v":100},100,100,100,100,100,100,100,100,100,100,100]
[]
[null,null,null,null,"CPIH Index Nov (prior year) - forecast ",null,"index",{"$f":"SUM(J40:W40)","v":1300},null,null,{"$f":"J38","v":100},{"$f":"K38","v":100},100,100,100,100,100,100,100,100,100,100,100]
[]
[]
[]
[]
["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 - 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 - Water-N+ ",null,"£m",{"$f":"SUM(J93:W93)","v":0}]
[]
[null,null,null,null,"Proportion of penalty allocated to Water-N+",null,"%"]
[]
[null,"WFRIM 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(J101:W101)","v":0}]
[]
[null,null,null,null,"Blind year profiling factor - Water-N+ - Validation",{"$f":"IF(H101>100%, 1, 0)","v":0},"Check"]
[]
[]
[]
["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(J113:W113)","v":0}]
[]
[null,null,null,null,"Actual Revenue  - WW-N+ ",null,"£m",{"$f":"SUM(J115:W115)","v":0}]
[]
[null,"WFRIM 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(J121:W121)","v":0}]
[]
[null,null,null,null,"Blind year profiling factor - WW-N+ - Validation",{"$f":"IF(H121>100%, 1, 0)","v":0},"Check"]
[]
[]
[]
["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$129","v":"Months per model period"},{"$f":" InpActive!F$129","v":12},{"$f":" InpActive!G$129","v":"months"},{"$f":" InpActive!H$129","v":0},{"$f":" InpActive!I$129","v":0},{"$f":" InpActive!J$129","v":0},{"$f":" InpActive!K$129","v":0},{"$f":" InpActive!L$129","v":0},{"$f":" InpActive!M$129","v":0},{"$f":" InpActive!N$129","v":0},{"$f":" InpActive!O$129","v":0},{"$f":" InpActive!P$129","v":0},{"$f":" InpActive!Q$129","v":0},{"$f":" InpActive!R$129","v":0},{"$f":" InpActive!S$129","v":0},{"$f":" InpActive!T$129","v":0},{"$f":" InpActive!U$129","v":0},{"$f":" InpActive!V$129","v":0},{"$f":" InpActive!W$129","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$129","v":"Months per model period"},{"$f":" InpActive!F$129","v":12},{"$f":" InpActive!G$129","v":"months"},{"$f":" InpActive!H$129","v":0},{"$f":" InpActive!I$129","v":0},{"$f":" InpActive!J$129","v":0},{"$f":" InpActive!K$129","v":0},{"$f":" InpActive!L$129","v":0},{"$f":" InpActive!M$129","v":0},{"$f":" InpActive!N$129","v":0},{"$f":" InpActive!O$129","v":0},{"$f":" InpActive!P$129","v":0},{"$f":" InpActive!Q$129","v":0},{"$f":" InpActive!R$129","v":0},{"$f":" InpActive!S$129","v":0},{"$f":" InpActive!T$129","v":0},{"$f":" InpActive!U$129","v":0},{"$f":" InpActive!V$129","v":0},{"$f":" InpActive!W$129","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$31","v":"2017/18 indexation modelling column financial year#"},{"$f":" InpActive!F$31","v":"2017-04-01"},{"$f":" InpActive!G$31","v":"year #"},{"$f":" InpActive!H$31","v":"Financial model start year"},{"$f":" InpActive!I$31","v":"00:00:00"},{"$f":" InpActive!J$31","v":"00:00:00"},{"$f":" InpActive!K$31","v":"00:00:00"},{"$f":" InpActive!L$31","v":"00:00:00"},{"$f":" InpActive!M$31","v":"00:00:00"},{"$f":" InpActive!N$31","v":"00:00:00"},{"$f":" InpActive!O$31","v":"00:00:00"},{"$f":" InpActive!P$31","v":"00:00:00"},{"$f":" InpActive!Q$31","v":"00:00:00"},{"$f":" InpActive!R$31","v":"00:00:00"},{"$f":" InpActive!S$31","v":"00:00:00"},{"$f":" InpActive!T$31","v":"00:00:00"},{"$f":" InpActive!U$31","v":"00:00:00"},{"$f":" InpActive!V$31","v":"00:00:00"},{"$f":" InpActive!W$31","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",{"$f":" J$20","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","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,1,0,0,0,0,0,0,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":"Indices and K factor","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":"Indices and K factor"}]
[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,"CPIH: Nov % increase"]
[null,null,null,null,{"$f":" InpActive!E$40","v":"CPIH Index Nov (prior year) - forecast "},{"$f":" InpActive!F$40","v":0},{"$f":" InpActive!G$40","v":"index"},{"$f":" InpActive!H$40","v":1300},{"$f":" InpActive!I$40","v":0},{"$f":" InpActive!J$40","v":0},{"$f":" InpActive!K$40","v":100},{"$f":" InpActive!L$40","v":100},{"$f":" InpActive!M$40","v":100},{"$f":" InpActive!N$40","v":100},{"$f":" InpActive!O$40","v":100},{"$f":" InpActive!P$40","v":100},{"$f":" InpActive!Q$40","v":100},{"$f":" InpActive!R$40","v":100},{"$f":" InpActive!S$40","v":100},{"$f":" InpActive!T$40","v":100},{"$f":" InpActive!U$40","v":100},{"$f":" InpActive!V$40","v":100},{"$f":" InpActive!W$40","v":100}]
[null,null,null,null,"CPIH: Nov % increase (prior year) - CALC",null,"%",null,null,{"$f":" IF(I10 = 0, 0, J10 / I10)","v":0},{"$f":" IF(J10 = 0, 0, K10 / J10)","v":0},{"$f":" IF(K10 = 0, 0, L10 / K10)","v":1},1,1,1,{"$f":" IF(O10 = 0, 0, P10 / O10)","v":1},1,1,1,1,1,1,1]
[]
[null,"CPIH: Nov - Nov index inflating from 2019/20"]
[null,null,null,null,{"$f":" InpActive!E$40","v":"CPIH Index Nov (prior year) - forecast "},{"$f":" InpActive!F$40","v":0},{"$f":" InpActive!G$40","v":"index"},{"$f":" InpActive!H$40","v":1300},{"$f":" InpActive!I$40","v":0},{"$f":" InpActive!J$40","v":0},{"$f":" InpActive!K$40","v":100},{"$f":" InpActive!L$40","v":100},{"$f":" InpActive!M$40","v":100},{"$f":" InpActive!N$40","v":100},{"$f":" InpActive!O$40","v":100},{"$f":" InpActive!P$40","v":100},{"$f":" InpActive!Q$40","v":100},{"$f":" InpActive!R$40","v":100},{"$f":" InpActive!S$40","v":100},{"$f":" InpActive!T$40","v":100},{"$f":" InpActive!U$40","v":100},{"$f":" InpActive!V$40","v":100},{"$f":" InpActive!W$40","v":100}]
[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":100},null,{"$f":" J14 * J15","v":0},{"$f":" K14 * K15","v":0},0,0,0,{"$f":" O14 * O15","v":100},0,0,0,0,0,0,0,0]
[null,null,null,null,"CPIH Forecast period base inflation",{"$f":"SUM(J16:W16)","v":100}]
[]
[null,null,null,null,{"$f":" E$17","v":"CPIH Forecast period base inflation"},{"$f":" F$17","v":100},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 (prior year) - forecast "},{"$f":" F$10","v":0},"index",1300,0,0,100,100,100,100,100,100,100,100,100,100,100,100,100]
[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,{"$f":" IF($F19 = 0, 0, (P20 / $F$19) * P21)","v":1},{"$f":" IF($F19 = 0, 0, (Q20 / $F$19) * Q21)","v":1},1,1,1,0,0,0]
[]
[null,"Revenue indexation"]
[null,null,null,null,{"$f":" E$11","v":"CPIH: Nov % increase (prior year) - CALC"},0,"%",0,0,0,0,{"$f":" L$11","v":1},1,1,1,{"$f":" P$11","v":1},1,1,1,1,1,1,1]
[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,{"$f":" IF(P25 = 0, 0, (P25 - 1))","v":0},0,0,0,0,0,0,0]
[]
[null,"Water Resources"]
[null,null,null,null,{"$f":" InpActive!E$131","v":"Unit conversion to percentage"},{"$f":" InpActive!F$131","v":100},{"$f":" InpActive!G$131","v":"#"},{"$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":" 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,{"$f":"P$31","v":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,{"$f":" P$26","v":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,{"$f":" (1 + P33 + P34) * P35","v":1},1,1,1,1,0,0,0]
[]
[null,"Water Network-Plus"]
[null,null,null,null,{"$f":" InpActive!E$131","v":"Unit conversion to percentage"},{"$f":" InpActive!F$131","v":100},{"$f":" InpActive!G$131","v":"#"},{"$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":" 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$131","v":"Unit conversion to percentage"},{"$f":" InpActive!F$131","v":100},{"$f":" InpActive!G$131","v":"#"},{"$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":" InpActive!E$113","v":"K - WW-N+"},{"$f":" InpActive!F$113","v":0},{"$f":" InpActive!G$113","v":"#"},{"$f":" InpActive!H$113","v":0},{"$f":" InpActive!I$113","v":0},{"$f":" InpActive!J$113","v":0},{"$f":" InpActive!K$113","v":0},{"$f":" InpActive!L$113","v":0},{"$f":" InpActive!M$113","v":0},{"$f":" InpActive!N$113","v":0},{"$f":" InpActive!O$113","v":0},{"$f":" InpActive!P$113","v":0},{"$f":" InpActive!Q$113","v":0},{"$f":" InpActive!R$113","v":0},{"$f":" InpActive!S$113","v":0},{"$f":" InpActive!T$113","v":0},{"$f":" InpActive!U$113","v":0},{"$f":" InpActive!V$113","v":0},{"$f":" InpActive!W$113","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,{"$f":" P$26","v":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,{"$f":" (1 + P53 + P54) * P55","v":1},1,1,1,1,0,0,0]
[]
["End of sheet"]

{"sheet":"Wholesale Water","index":5,"n_rows":238,"n_cols":23,"rows_kept":238,"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 - 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 - 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 - 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]
[]
["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":" 'Indices and K factor'!E$36","v":"Revenue indexation - Water Res"},{"$f":" 'Indices and K factor'!F$36","v":0},{"$f":" 'Indices and K factor'!G$36","v":"factor"},{"$f":" 'Indices and K factor'!H$36","v":0},{"$f":" 'Indices and K factor'!I$36","v":0},{"$f":" 'Indices and K factor'!J$36","v":0},{"$f":" 'Indices and K factor'!K$36","v":0},{"$f":" 'Indices and K factor'!L$36","v":0},{"$f":" 'Indices and K factor'!M$36","v":0},{"$f":" 'Indices and K factor'!N$36","v":0},{"$f":" 'Indices and K factor'!O$36","v":0},{"$f":" 'Indices and K factor'!P$36","v":1},{"$f":" 'Indices and K factor'!Q$36","v":1},{"$f":" 'Indices and K factor'!R$36","v":1},{"$f":" 'Indices and K factor'!S$36","v":1},{"$f":" 'Indices and K factor'!T$36","v":1},{"$f":" 'Indices and K factor'!U$36","v":0},{"$f":" 'Indices and K factor'!V$36","v":0},{"$f":" 'Indices and K factor'!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(J19:W19)","v":0},null,{"$f":" IF(J18 = 1, $F16, I19 * J17)","v":0},{"$f":" IF(K18 = 1, $F16, J19 * K17)","v":0},0,0,0,0,{"$f":" IF(P18 = 1, $F16, O19 * P17)","v":0},{"$f":" IF(Q18 = 1, $F16, P19 * Q17)","v":0},{"$f":" IF(R18 = 1, $F16, Q19 * R17)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$19","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(J23:W23)","v":0},null,{"$f":" IF(J22 = 1, J21, 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Allowed Revenue: Water Network-plus"]
[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":" 'Indices and K factor'!E$46","v":"Revenue indexation - Water-N+"},{"$f":" 'Indices and K factor'!F$46","v":0},{"$f":" 'Indices and K factor'!G$46","v":"factor"},{"$f":" 'Indices and K factor'!H$46","v":0},{"$f":" 'Indices and K factor'!I$46","v":0},{"$f":" 'Indices and K factor'!J$46","v":0},{"$f":" 'Indices and K factor'!K$46","v":0},{"$f":" 'Indices and K factor'!L$46","v":0},{"$f":" 'Indices and K factor'!M$46","v":0},{"$f":" 'Indices and K factor'!N$46","v":0},{"$f":" 'Indices and K factor'!O$46","v":0},{"$f":" 'Indices and K factor'!P$46","v":1},{"$f":" 'Indices and K factor'!Q$46","v":1},{"$f":" 'Indices and K factor'!R$46","v":1},{"$f":" 'Indices and K factor'!S$46","v":1},{"$f":" 'Indices and K factor'!T$46","v":1},{"$f":" 'Indices and K factor'!U$46","v":0},{"$f":" 'Indices and K factor'!V$46","v":0},{"$f":" 'Indices and K factor'!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(J29:W29)","v":0},null,{"$f":" IF(J28 = 1, $F26, I29 * J27)","v":0},0,0,0,0,0,{"$f":" IF(P28 = 1, $F26, O29 * P27)","v":0},0,0,0,0,{"$f":" IF(U28 = 1, $F26, T29 * U27)","v":0},0,0]
[]
[null,null,null,null,{"$f":" E$29","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(J33:W33)","v":0},null,{"$f":" IF(J32 = 1, J31, 0)","v":0},0,{"$f":" IF(L32 = 1, L31, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":" IF(U32 = 1, U31, 0)","v":0},0,0]
[]
["BLIND YEAR ADJUSTMENT"]
[]
[null,"Blind year adjustment"]
[null,null,null,null,{"$f":" InpActive!E$99","v":"Blind year adjustment for year 2019/2020 - Water-N+ (base year 2019/2020)"},{"$f":" InpActive!F$99","v":0},{"$f":" InpActive!G$99","v":"£m"},{"$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,{"$f":"InpActive!E$101","v":"Blind year profiling factor - Water-N+"},{"$f":"InpActive!F$101","v":0},{"$f":"InpActive!G$101","v":"%"},{"$f":"InpActive!H$101","v":0},{"$f":"InpActive!I$101","v":0},{"$f":"InpActive!J$101","v":0},{"$f":"InpActive!K$101","v":0},{"$f":"InpActive!L$101","v":0},{"$f":"InpActive!M$101","v":0},{"$f":"InpActive!N$101","v":0},{"$f":"InpActive!O$101","v":0},{"$f":"InpActive!P$101","v":0},{"$f":"InpActive!Q$101","v":0},{"$f":"InpActive!R$101","v":0},{"$f":"InpActive!S$101","v":0},{"$f":"InpActive!T$101","v":0},{"$f":"InpActive!U$101","v":0},{"$f":"InpActive!V$101","v":0},{"$f":"InpActive!W$101","v":0}]
[null,null,null,null,"Blind year adjustment (profiled) - Water-N+ (base year 2019/20)",null,"£m",{"$f":" SUM(J40:W40)","v":0},null,{"$f":"J39*$F$38","v":0},0,0,0,0,0,0,0,0,0,{"$f":"T39*$F$38","v":0},{"$f":"U39*$F$38","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$40","v":"Blind year adjustment (profiled) - Water-N+ (base year 2019/20)"},0,"£m",{"$f":"H$40","v":0},{"$f":"I$40","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":"J43*(1 + $F$42)^J44","v":0},0,0,0,0,0,0,{"$f":"Q43*(1 + $F$42)^Q44","v":0},{"$f":"R43*(1 + $F$42)^R44","v":0},{"$f":"S43*(1 + $F$42)^S44","v":0},0,0,0,0]
[]
[null,null,null,null,{"$f":"'Indices and K factor'!E$22","v":"CPIH: Nov - Nov index inflating from 2019/20"},{"$f":"'Indices and K factor'!F$22","v":0},{"$f":"'Indices and K factor'!G$22","v":"index"},{"$f":"'Indices and K factor'!H$22","v":0},{"$f":"'Indices and K factor'!I$22","v":0},{"$f":"'Indices and K factor'!J$22","v":0},{"$f":"'Indices and K factor'!K$22","v":0},{"$f":"'Indices and K factor'!L$22","v":0},{"$f":"'Indices and K factor'!M$22","v":0},{"$f":"'Indices and K factor'!N$22","v":0},{"$f":"'Indices and K factor'!O$22","v":0},{"$f":"'Indices and K factor'!P$22","v":1},{"$f":"'Indices and K factor'!Q$22","v":1},{"$f":"'Indices and K factor'!R$22","v":1},{"$f":"'Indices and K factor'!S$22","v":1},{"$f":"'Indices and K factor'!T$22","v":1},{"$f":"'Indices and K factor'!U$22","v":0},{"$f":"'Indices and K factor'!V$22","v":0},{"$f":"'Indices and K factor'!W$22","v":0}]
[null,null,null,null,{"$f":"E$45","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 and inflation adjustment - Water-N+ ",null,"£m",{"$f":" SUM(J49:W49)","v":0},null,{"$f":" J47 * J48","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U47 * U48","v":0},0,0]
[]
["REVENUE CORRECTION"]
[]
[null,"Main revenue over / under recovery: Water-N+ (Including profiled Blind year adjustment)"]
[null,null,null,null,{"$f":" E$33","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$49","v":"Blind year (profiled) inc. financing rate and inflation 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$170","v":"AMP7 forecasting incentive adjustment including over / under recovery true up - Water-N+"},{"$f":" F$170","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 - Water-N+",null,"£m",{"$f":" SUM(J57:W57)","v":0},null,{"$f":" SUM(J54:J56)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$57","v":"Adjusted allowed revenue - Water-N+"},{"$f":" F$57","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":"InpActive!E$93","v":"Actual Revenue - 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,"Revenue Imbalance - Water-N+",null,"£m",{"$f":" SUM(J61:W61)","v":0},null,{"$f":"J59-J60","v":0},{"$f":"K59-K60","v":0},0,0,0,0,0,0,{"$f":"R59-R60","v":0},{"$f":"S59-S60","v":0},0,0,{"$f":"V59-V60","v":0},{"$f":"W59-W60","v":0}]
[]
[null,"Main revenue over / under recovery: Water resources"]
[null,null,null,null,{"$f":"E$23","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$176","v":"AMP7 forecasting incentive adjustment including over / under recovery true up - Water Res"},{"$f":" F$176","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 - Water Res",null,"£m",{"$f":" SUM( J66:W66)","v":0},null,{"$f":" SUM( J64:J65 )","v":0},{"$f":" SUM( K64:K65 )","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$66","v":"Adjusted allowed revenue - Water Res"},{"$f":" F$66","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":"InpActive!E$81","v":"Actual Revenue - 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,"Revenue Imbalance - Water Res",null,"£m",{"$f":" SUM(J70:W70)","v":0},null,{"$f":"J68-J69","v":0},{"$f":"K68-K69","v":0},0,0,0,0,0,0,{"$f":"R68-R69","v":0},{"$f":"S68-S69","v":0},0,0,{"$f":"V68-V69","v":0},{"$f":"W68-W69","v":0}]
[]
[null,"Total revenue imbalance (Water-N+ and Water Res)"]
[null,null,null,null,{"$f":" E$61","v":"Revenue Imbalance - Water-N+"},{"$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,null,{"$f":" E$70","v":"Revenue Imbalance - Water Res"},{"$f":" F$70","v":0},"£m",0,0,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(J75:W75)","v":0},null,{"$f":" J73 + J74","v":0},{"$f":" K73 + K74","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total adjusted allowed revenue - Wholesale Water"]
[null,null,null,null,{"$f":" E$57","v":"Adjusted allowed revenue - Water-N+"},{"$f":" F$57","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$66","v":"Adjusted allowed revenue - Water Res"},{"$f":" F$66","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Adjusted allowed revenue - Wholesale Water",null,"£m",{"$f":" SUM(J80:W80)","v":0},null,{"$f":" J78 + J79","v":0},{"$f":" K78 + K79","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Main revenue adjustment Water-N+"]
[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$73","v":"Revenue Imbalance - Water-N+"},{"$f":"F$73","v":0},{"$f":"G$73","v":"£m"},0,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,"Main revenue adjustment - with financing adjustment - Water-N+",null,"£m",{"$f":" SUM(J87:W87)","v":0},null,{"$f":" IF(J86 <= $F83 + 1,  J85 * (1 + $F84) * (1 + $F84), 0)","v":0},{"$f":" IF(K86 <= $F83 + 1,  K85 * (1 + $F84) * (1 + $F84), 0)","v":0},0,0,0,0,{"$f":" IF(P86 <= $F83 + 1,  P85 * (1 + $F84) * (1 + $F84), 0)","v":0},0,{"$f":" IF(R86 <= $F83 + 1,  R85 * (1 + $F84) * (1 + $F84), 0)","v":0},{"$f":" IF(S86 <= $F83 + 1,  S85 * (1 + $F84) * (1 + $F84), 0)","v":0},{"$f":" IF(T86 <= $F83 + 1,  T85 * (1 + $F84) * (1 + $F84), 0)","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$87","v":"Main revenue adjustment - with financing 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,"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Water-N+",null,"£m",{"$f":" SUM(J91:W91)","v":0},null,{"$f":" J90 * K89 * L89","v":0},0,0,0,0,0,{"$f":" P90 * Q89 * R89","v":0},0,0,0,0,{"$f":" U90 * V89 * W89","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$91","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - 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$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 - Water-N+",null,"£m",{"$f":" SUM(J96:W96)","v":0},null,{"$f":" SUMIF($J95:$W95, J95 - $F93, $J94:$W94)","v":0},0,0,0,0,0,{"$f":" SUMIF($J95:$W95, P95 - $F93, $J94:$W94)","v":0},0,{"$f":" SUMIF($J95:$W95, R95 - $F93, $J94:$W94)","v":0},0,0,0,0,0]
[]
[null,"Main revenue adjustment Water Res"]
[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$74","v":"Revenue Imbalance - Water Res"},{"$f":"F$74","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$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 - Water Res",null,"£m",{"$f":" SUM(J103:W103)","v":0},null,{"$f":" IF(J102 <= $F99 + 1,  J101 * (1 + $F100) * (1 + $F100), 0)","v":0},0,0,0,0,0,{"$f":" IF(P102 <= $F99 + 1,  P101 * (1 + $F100) * (1 + $F100), 0)","v":0},{"$f":" IF(Q102 <= $F99 + 1,  Q101 * (1 + $F100) * (1 + $F100), 0)","v":0},{"$f":" IF(R102 <= $F99 + 1,  R101 * (1 + $F100) * (1 + $F100), 0)","v":0},{"$f":" IF(S102 <= $F99 + 1,  S101 * (1 + $F100) * (1 + $F100), 0)","v":0},{"$f":" IF(T102 <= $F99 + 1,  T101 * (1 + $F100) * (1 + $F100), 0)","v":0},{"$f":" IF(U102 <= $F99 + 1,  U101 * (1 + $F100) * (1 + $F100), 0)","v":0},0,0]
[]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$103","v":"Main revenue adjustment - with financing adjustment - Water Res"},{"$f":" F$103","v":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 - Water Res",null,"£m",{"$f":" SUM(J107:W107)","v":0},null,{"$f":" J106 * K105 * L105","v":0},{"$f":" K106 * L105 * M105","v":0},{"$f":" L106 * M105 * N105","v":0},{"$f":" M106 * N105 * O105","v":0},{"$f":" N106 * O105 * P105","v":0},{"$f":" O106 * P105 * Q105","v":0},{"$f":" P106 * Q105 * R105","v":0},{"$f":" Q106 * R105 * S105","v":0},{"$f":" R106 * S105 * T105","v":0},{"$f":" S106 * T105 * U105","v":0},{"$f":" T106 * U105 * V105","v":0},{"$f":" U106 * V105 * W105","v":0},{"$f":" V106 * W105 * X105","v":0},{"$f":" W106 * X105 * Y105","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$107","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Water Res"},{"$f":" F$107","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$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 - Water Res",null,"£m",{"$f":" SUM(J112:W112)","v":0},null,{"$f":" SUMIF($J111:$W111, J111 - $F109, $J110:$W110)","v":0},0,0,0,0,0,{"$f":" SUMIF($J111:$W111, P111 - $F109, $J110:$W110)","v":0},{"$f":" SUMIF($J111:$W111, Q111 - $F109, $J110:$W110)","v":0},{"$f":" SUMIF($J111:$W111, R111 - $F109, $J110:$W110)","v":0},{"$f":" SUMIF($J111:$W111, S111 - $F109, $J110:$W110)","v":0},0,0,0,0]
[]
["PENALTY CALCULATION"]
[]
[null,"Main revenue over /  under recovery: Non-developer services"]
[null,null,null,null,{"$f":" E$80","v":"Adjusted allowed revenue - Wholesale Water"},{"$f":" F$80","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$11","v":"Actual Revenue - 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,"Revenue Imbalance - Wholesale Water",null,"£m",{"$f":" SUM(J119:W119)","v":0},null,{"$f":" J117 - J118","v":0},{"$f":" K117 - K118","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Penalty calculation"]
[null,null,null,null,{"$f":" E$11","v":"Actual Revenue - 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":" E$80","v":"Adjusted allowed revenue - Wholesale Water"},{"$f":" F$80","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Forecast error - Wholesale Water",null,"%",null,null,{"$f":" IF(J123 = 0, 0, ABS(J122 - J123) / J123)","v":0},0,0,0,0,0,{"$f":" IF(P123 = 0, 0, ABS(P122 - P123) / P123)","v":0},0,0,0,0,{"$f":" IF(U123 = 0, 0, ABS(U122 - U123) / U123)","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$124","v":"Forecast error - Wholesale Water"},0,"%",0,0,{"$f":" J$124","v":0},0,0,0,0,0,{"$f":" P$124","v":0},0,0,0,0,{"$f":" U$124","v":0},0,0]
[null,null,null,null,"Penalty applicable flag",null,"flag",null,null,{"$f":" IF(J127 > $F126, 1, 0)","v":0},0,0,0,0,0,{"$f":" IF(P127 > $F126, 1, 0)","v":0},0,0,0,0,{"$f":" IF(U127 > $F126, 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$124","v":"Forecast error - Wholesale Water"},0,"%",0,0,0,0,0,0,0,0,{"$f":" P$124","v":0},0,0,0,0,{"$f":" U$124","v":0},0,0]
[null,null,null,null,{"$f":" E$128","v":"Penalty applicable flag"},0,"flag",0,0,0,0,0,0,0,0,{"$f":" P$128","v":0},0,0,0,0,{"$f":" U$128","v":0},0,0]
[null,null,null,null,"Error magnitude - Wholesale Water",null,"factor",null,null,{"$f":" IF(J133 = 1, (J132 - $F130) / ($F131 - $F130), 0)","v":0},0,0,{"$f":" IF(M133 = 1, (M132 - $F130) / ($F131 - $F130), 0)","v":0},0,0,{"$f":" IF(P133 = 1, (P132 - $F130) / ($F131 - $F130), 0)","v":0},0,0,0,0,{"$f":" IF(U133 = 1, (U132 - $F130) / ($F131 - $F130), 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$134","v":"Error magnitude - Wholesale Water"},0,"factor",0,0,0,0,0,0,0,0,{"$f":" P$134","v":0},0,0,0,0,{"$f":" U$134","v":0},0,0]
[null,null,null,null,"Penalty rate magnitude - Wholesale Water",null,"%",null,null,{"$f":" $F136 * MIN(1, J137)","v":0},0,0,0,0,0,{"$f":" $F136 * MIN(1, P137)","v":0},0,{"$f":" $F136 * MIN(1, R137)","v":0},0,0,{"$f":" $F136 * MIN(1, U137)","v":0},0,{"$f":" $F136 * MIN(1, W137)","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$11","v":"Actual Revenue - 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":" E$80","v":"Adjusted allowed revenue - Wholesale Water"},{"$f":" F$80","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$138","v":"Penalty rate magnitude - Wholesale Water"},0,"%",0,0,0,0,0,0,0,0,{"$f":" P$138","v":0},0,0,0,0,{"$f":" U$138","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(J145:W145)","v":0},null,{"$f":"  IF(J144=1, J143 * ABS(J141 - J142), 0 )","v":0},0,0,0,0,0,{"$f":"  IF(P144=1, P143 * ABS(P141 - P142), 0 )","v":0},{"$f":"  IF(Q144=1, Q143 * ABS(Q141 - Q142), 0 )","v":0},0,0,0,0,{"$f":"  IF(V144=1, V143 * ABS(V141 - V142), 0 )","v":0},0]
[null,null,null,null,{"$f":" LEFT(E145, LEN(E145) - 4)","v":"Penalty adjustment - Wholesale Water"},null,"£m",{"$f":" SUM(J146:W146)","v":0},null,{"$f":" -1 * J145","v":0},0,0,0,0,0,{"$f":" -1 * P145","v":0},0,0,0,0,{"$f":" -1 * U145","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$146","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,{"$f":" P$146","v":0},0,0,0,0,{"$f":" U$146","v":0},0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment - Wholesale Water",null,"£m",{"$f":" SUM(J150:W150)","v":0},null,{"$f":" J149 * (1 + $F148)","v":0},0,0,0,0,0,{"$f":" P149 * (1 + $F148)","v":0},0,0,0,0,{"$f":" U149 * (1 + $F148)","v":0},0,0]
[]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$150","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$150","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(J155:W155)","v":0},null,{"$f":"IF(J154=1,J153*K152*L152,0)","v":0},{"$f":"IF(K154=1,K153*L152*M152,0)","v":0},0,{"$f":"IF(M154=1,M153*N152*O152,0)","v":0},0,0,{"$f":"IF(P154=1,P153*Q152*R152,0)","v":0},{"$f":"IF(Q154=1,Q153*R152*S152,0)","v":0},{"$f":"IF(R154=1,R153*S152*T152,0)","v":0},0,{"$f":"IF(T154=1,T153*U152*V152,0)","v":0},{"$f":"IF(U154=1,U153*V152*W152,0)","v":0}]
[]
[null,"Allocation of the penalty adjustment to Water-N+ and Water Res controls"]
[null,null,null,null,{"$f":" E$154","v":"Forecast period flag"},{"$f":" F$154","v":0},"flag",5,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0]
[null,null,null,null,{"$f":" InpActive!E95","v":"Proportion of penalty allocated to Water-N+"},null,{"$f":" InpActive!G95","v":"%"},{"$f":" InpActive!H95","v":0},{"$f":" InpActive!I95","v":0},{"$f":" InpActive!J95","v":0},{"$f":" InpActive!K95","v":0},{"$f":" InpActive!L95","v":0},{"$f":" InpActive!M95","v":0},{"$f":" InpActive!N95","v":0},{"$f":" InpActive!O95","v":0},{"$f":" InpActive!P95","v":0},{"$f":" InpActive!Q95","v":0},{"$f":" InpActive!R95","v":0},{"$f":" InpActive!S95","v":0},{"$f":" InpActive!T95","v":0},{"$f":" InpActive!U95","v":0},{"$f":" InpActive!V95","v":0},{"$f":" InpActive!W95","v":0}]
[null,null,null,null,"Proportion of penalty allocated to Water Res",null,"%",null,null,{"$f":" IF( J158 = 1, 1 - J159, 0 )","v":0},{"$f":" IF( K158 = 1, 1 - K159, 0 )","v":0},0,0,0,0,1,1,1,1,1,0,0,0]
[]
[null,null,null,null,{"$f":" E$155","v":"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Wholesale Water"},{"$f":" F$155","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Water-N+",null,"£m",null,null,{"$f":" J$159 * J$162","v":0},{"$f":" K$159 * K$162","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Water Res",null,"£m",null,null,{"$f":" J$160 * J$162","v":0},{"$f":" K$160 * K$162","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"AMP7 forecasting incentive adjustment including over / under recovery true up - Water-N+"]
[null,null,null,null,{"$f":" E$91","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Water-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$91","v":0},0,0]
[null,null,null,null,{"$f":" E$163","v":"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Water-N+"},{"$f":" F$163","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$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,"AMP7 forecasting incentive adjustment including over / under recovery true up - Water-N+","2 PD LK BCK","£m",{"$f":" SUM(J170:W170)","v":0},null,null,{"$f":" ( I167 + I168 ) * K169","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"AMP7 forecasting incentive adjustment including over / under recovery true up - Water Res"]
[null,null,null,null,{"$f":" E$110","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - Water Res"},{"$f":" F$110","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$164","v":"Penalty adjustment - with financing adjustment & 2 year lag of inflation - Water Res"},{"$f":" F$164","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$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,"AMP7 forecasting incentive adjustment including over / under recovery true up - Water Res","2 PD LK BCK","£m",{"$f":" SUM(J176:W176)","v":0},null,null,{"$f":" ( I173 + I174 ) * K175","v":0},0,0,0,0,0,0,0,0,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$124","v":"Forecast error - Wholesale Water"},{"$f":"F$124","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"U$124","v":0},0,0]
[null,null,null,null,"Performance variance level alert",{"$f":" IF(SUM(J181:W181) > 0, 1, 0)","v":0},"alert",null,null,{"$f":" IF(ABS(J180) > $F179, 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(ABS(U180) > $F179, 1, 0)","v":0},0,0]
[]
[]
["APPLICATION OF ADJUSTMENTS IN LAST TWO YEARS AT THE END OF AMP7"]
[]
[null,"Year 4 - One year of CPIH and financing costs adjustments applied - Water-N+"]
[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":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$61","v":"Revenue Imbalance - Water-N+"},{"$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,null,{"$f":" E$146","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$146","v":0},0,0]
[null,null,null,null,{"$f":" E$159","v":"Proportion of penalty allocated to Water-N+"},{"$f":" F$159","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Penalty adjustment - Water-N+",null,"£m",null,null,{"$f":" J190 * J191","v":0},{"$f":" K190 * K191","v":0},0,0,0,0,0,0,0,0,0,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 AMP7 - Water-N+",null,"£m",{"$f":" SUM(J195:W195)","v":0},null,{"$f":" IF(J193 = 1, I189 * J188 * (1 + $F187), 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 AMP7 - Water-N+",null,"£m",{"$f":" SUM(J196:W196)","v":0},null,{"$f":" J193 * ( I192 * J188 * (1 + $F187) )","v":0},{"$f":" K193 * ( J192 * K188 * (1 + $F187) )","v":0},{"$f":" L193 * ( K192 * L188 * (1 + $F187) )","v":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 AMP7 - Water-N+",null,"£m",{"$f":" SUM(J197:W197)","v":0},null,{"$f":" SUM(J195:J196)","v":0},0,0,0,0,0,0,0,0,0,{"$f":" SUM(T195:T196)","v":0},0,0,0]
[]
[null,"Year 4 - One year of CPIH and financing costs adjustments applied - Water Res"]
[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":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$70","v":"Revenue Imbalance - Water Res"},{"$f":" F$70","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$146","v":"Penalty 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,{"$f":" E$160","v":"Proportion of penalty allocated to Water Res"},{"$f":" F$160","v":0},"%",0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0]
[null,null,null,null,"Penalty adjustment - Water Res",null,"£m",null,null,{"$f":" J203 * J204","v":0},{"$f":" K203 * K204","v":0},{"$f":" L203 * L204","v":0},{"$f":" M203 * M204","v":0},{"$f":" N203 * N204","v":0},{"$f":" O203 * O204","v":0},{"$f":" P203 * P204","v":0},{"$f":" Q203 * Q204","v":0},{"$f":" R203 * R204","v":0},{"$f":" S203 * S204","v":0},{"$f":" T203 * T204","v":0},{"$f":" U203 * U204","v":0},{"$f":" V203 * V204","v":0},{"$f":" W203 * W204","v":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 AMP7 - Water Res",null,"£m",{"$f":" SUM(J208:W208)","v":0},null,{"$f":" IF(J206 = 1, I202 * J201 * (1 + $F200), 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 AMP7 - Water Res",null,"£m",{"$f":" SUM(J209:W209)","v":0},null,{"$f":" J206 * ( I205 * J201 * (1 + $F200) )","v":0},{"$f":" K206 * ( J205 * K201 * (1 + $F200) )","v":0},{"$f":" L206 * ( K205 * L201 * (1 + $F200) )","v":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 AMP7 - Water Res",null,"£m",{"$f":" SUM(J210:W210)","v":0},null,{"$f":" SUM(J208:J209)","v":0},0,0,0,0,0,0,0,0,0,{"$f":" SUM(T208:T209)","v":0},{"$f":" SUM(U208:U209)","v":0},0,0]
[]
[null,"Year 5 - No CPIH and financing costs adjustments applied - Water-N+"]
[null,null,null,null,{"$f":" E$61","v":"Revenue Imbalance - Water-N+"},{"$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,null,{"$f":" E$146","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$146","v":0},{"$f":" U$146","v":0},0,0]
[null,null,null,null,{"$f":" E$159","v":"Proportion of penalty allocated to Water-N+"},{"$f":" F$159","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Penalty adjustment - Water-N+",null,"£m",null,null,{"$f":" J214 * J215","v":0},{"$f":" K214 * K215","v":0},{"$f":" L214 * L215","v":0},{"$f":" M214 * M215","v":0},{"$f":" N214 * N215","v":0},{"$f":" O214 * O215","v":0},{"$f":" P214 * P215","v":0},{"$f":" Q214 * Q215","v":0},{"$f":" R214 * R215","v":0},{"$f":" S214 * S215","v":0},{"$f":" T214 * T215","v":0},{"$f":" U214 * U215","v":0},{"$f":" V214 * V215","v":0},{"$f":" W214 * W215","v":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 AMP7 - Water-N+",null,"£m",{"$f":" SUM(J218:W218)","v":0},null,{"$f":" ( J213 + J216 ) * J217","v":0},0,0,0,0,0,0,0,0,0,{"$f":" ( T213 + T216 ) * T217","v":0},0,0,0]
[]
[null,"Year 5 - No CPIH and financing costs adjustments applied - Water Res"]
[null,null,null,null,{"$f":" E$70","v":"Revenue Imbalance - Water Res"},{"$f":" F$70","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$146","v":"Penalty adjustment - Wholesale Water"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" T$146","v":0},{"$f":" U$146","v":0},0,0]
[null,null,null,null,{"$f":" E$160","v":"Proportion of penalty allocated to Water Res"},{"$f":" F$160","v":0},"%",0,0,0,0,0,0,0,0,1,1,1,1,1,0,0,0]
[null,null,null,null,"Penalty adjustment - Water Res",null,"£m",null,null,{"$f":" J222 * J223","v":0},{"$f":" K222 * K223","v":0},{"$f":" L222 * L223","v":0},{"$f":" M222 * M223","v":0},{"$f":" N222 * N223","v":0},{"$f":" O222 * O223","v":0},{"$f":" P222 * P223","v":0},{"$f":" Q222 * Q223","v":0},{"$f":" R222 * R223","v":0},{"$f":" S222 * S223","v":0},{"$f":" T222 * T223","v":0},{"$f":" U222 * U223","v":0},{"$f":" V222 * V223","v":0},{"$f":" W222 * W223","v":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 AMP7 - Water Res",null,"£m",{"$f":" SUM(J226:W226)","v":0},null,{"$f":" ( J221 + J224 ) * J225","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total reward / (penalty) at the end of AMP7"]
[null,null,null,null,{"$f":" E$197","v":"Value of year 4 RFI adjustments at the end of AMP7 - Water-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$197","v":0},0,0]
[null,null,null,null,{"$f":" E$210","v":"Value of year 4 RFI adjustments at the end of AMP7 - Water Res"},{"$f":" F$210","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$218","v":"Value of year 5 RFI adjustments at the end of AMP7 - Water-N+"},{"$f":" F$218","v":0},{"$f":" G$218","v":"£m"},{"$f":" H$218","v":0},{"$f":" I$218","v":0},{"$f":" J$218","v":0},{"$f":" K$218","v":0},{"$f":" L$218","v":0},{"$f":" M$218","v":0},{"$f":" N$218","v":0},{"$f":" O$218","v":0},{"$f":" P$218","v":0},{"$f":" Q$218","v":0},{"$f":" R$218","v":0},{"$f":" S$218","v":0},{"$f":" T$218","v":0},{"$f":" U$218","v":0},0,0]
[null,null,null,null,{"$f":" E$226","v":"Value of year 5 RFI adjustments at the end of AMP7 - Water Res"},{"$f":" F$226","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Total reward / (penalty) at the end of AMP7 - Water-N+",null,"£m",{"$f":" SUM(J235:W235)","v":0},null,{"$f":" J229 + J232","v":0},{"$f":" K229 + K232","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total reward / (penalty) at the end of AMP7 - Water Res",null,"£m",{"$f":" SUM(J236:W236)","v":0},null,{"$f":" J230 + J233","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["End of sheet"]

{"sheet":"Wastewater Network-Plus","index":6,"n_rows":146,"n_cols":23,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"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 RECOVERED"]
[]
[null,"Revenue Recovered: WW-N+"]
[null,null,null,null,{"$f":" InpActive!E$115","v":"Actual Revenue  - WW-N+ "},{"$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}]
[]
["ALLOWED REVENUE"]
[]
[null,"Allowed Revenue: Wastewater Network-plus"]
[null,null,null,null,{"$f":" InpActive!E$111","v":"Allowed revenue - WW-N+ (base year 2019/2020)"},{"$f":" InpActive!F$111","v":0},{"$f":" InpActive!G$111","v":"£m"},{"$f":" InpActive!H$111","v":0},{"$f":" InpActive!I$111","v":0},{"$f":" InpActive!J$111","v":0},{"$f":" InpActive!K$111","v":0},{"$f":" InpActive!L$111","v":0},{"$f":" InpActive!M$111","v":0},{"$f":" InpActive!N$111","v":0},{"$f":" InpActive!O$111","v":0},{"$f":" InpActive!P$111","v":0},{"$f":" InpActive!Q$111","v":0},{"$f":" InpActive!R$111","v":0},{"$f":" InpActive!S$111","v":0},{"$f":" InpActive!T$111","v":0},{"$f":" InpActive!U$111","v":0},{"$f":" InpActive!V$111","v":0},{"$f":" InpActive!W$111","v":0}]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$56","v":"Revenue indexation - WW-N+"},{"$f":" 'Indices and K factor'!F$56","v":0},{"$f":" 'Indices and K factor'!G$56","v":"factor"},{"$f":" 'Indices and K factor'!H$56","v":0},{"$f":" 'Indices and K factor'!I$56","v":0},{"$f":" 'Indices and K factor'!J$56","v":0},{"$f":" 'Indices and K factor'!K$56","v":0},{"$f":" 'Indices and K factor'!L$56","v":0},{"$f":" 'Indices and K factor'!M$56","v":0},{"$f":" 'Indices and K factor'!N$56","v":0},{"$f":" 'Indices and K factor'!O$56","v":0},{"$f":" 'Indices and K factor'!P$56","v":1},{"$f":" 'Indices and K factor'!Q$56","v":1},{"$f":" 'Indices and K factor'!R$56","v":1},{"$f":" 'Indices and K factor'!S$56","v":1},{"$f":" 'Indices and K factor'!T$56","v":1},{"$f":" 'Indices and K factor'!U$56","v":0},{"$f":" 'Indices and K factor'!V$56","v":0},{"$f":" 'Indices and K factor'!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(J18:W18)","v":0},null,{"$f":" IF(J17 = 1, $F15, I18 * J16)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U17 = 1, $F15, T18 * U16)","v":0},0,0]
[]
[null,null,null,null,{"$f":" E$18","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$18","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(J22:W22)","v":0},null,{"$f":" IF(J21 = 1, J20, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U21 = 1, U20, 0)","v":0},0,0]
[]
["BLIND YEAR ADJUSTMENT"]
[]
[null,"Blind year adjustment"]
[null,null,null,null,{"$f":" InpActive!E$119","v":"Blind year adjustment for year 2019/2020 - WW-N+ (base year 2019/2020)"},{"$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,{"$f":"InpActive!E$121","v":"Blind year profiling factor - WW-N+ "},{"$f":"InpActive!F$121","v":0},{"$f":"InpActive!G$121","v":"%"},{"$f":"InpActive!H$121","v":0},{"$f":"InpActive!I$121","v":0},{"$f":"InpActive!J$121","v":0},{"$f":"InpActive!K$121","v":0},{"$f":"InpActive!L$121","v":0},{"$f":"InpActive!M$121","v":0},{"$f":"InpActive!N$121","v":0},{"$f":"InpActive!O$121","v":0},{"$f":"InpActive!P$121","v":0},{"$f":"InpActive!Q$121","v":0},{"$f":"InpActive!R$121","v":0},{"$f":"InpActive!S$121","v":0},{"$f":"InpActive!T$121","v":0},{"$f":"InpActive!U$121","v":0},{"$f":"InpActive!V$121","v":0},{"$f":"InpActive!W$121","v":0}]
[null,null,null,null,"Blind year adjustment (profiled) - WW-N+ (base year 2019/20)",null,"£m",{"$f":" SUM(J29:W29)","v":0},null,{"$f":"J28*$F$27","v":0},0,0,0,0,0,0,0,0,0,{"$f":"T28*$F$27","v":0},{"$f":"U28*$F$27","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$29","v":"Blind year adjustment (profiled) - WW-N+ (base year 2019/20)"},{"$f":"F$29","v":0},"£m",0,0,{"$f":"J$29","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":"J32*(1 + $F$31)^J33","v":0},{"$f":"K32*(1 + $F$31)^K33","v":0},0,0,0,0,0,{"$f":"Q32*(1 + $F$31)^Q33","v":0},{"$f":"R32*(1 + $F$31)^R33","v":0},{"$f":"S32*(1 + $F$31)^S33","v":0},0,0,0,0]
[]
[null,null,null,null,{"$f":"'Indices and K factor'!E$22","v":"CPIH: Nov - Nov index inflating from 2019/20"},{"$f":"'Indices and K factor'!F$22","v":0},{"$f":"'Indices and K factor'!G$22","v":"index"},{"$f":"'Indices and K factor'!H$22","v":0},{"$f":"'Indices and K factor'!I$22","v":0},{"$f":"'Indices and K factor'!J$22","v":0},{"$f":"'Indices and K factor'!K$22","v":0},{"$f":"'Indices and K factor'!L$22","v":0},{"$f":"'Indices and K factor'!M$22","v":0},{"$f":"'Indices and K factor'!N$22","v":0},{"$f":"'Indices and K factor'!O$22","v":0},{"$f":"'Indices and K factor'!P$22","v":1},{"$f":"'Indices and K factor'!Q$22","v":1},{"$f":"'Indices and K factor'!R$22","v":1},{"$f":"'Indices and K factor'!S$22","v":1},{"$f":"'Indices and K factor'!T$22","v":1},{"$f":"'Indices and K factor'!U$22","v":0},{"$f":"'Indices and K factor'!V$22","v":0},{"$f":"'Indices and K factor'!W$22","v":0}]
[null,null,null,null,{"$f":"E$34","v":"Blind year (profiled) inc. financing rate adjustment - WW-N+ (base year 2019/2020)"},{"$f":"F$34","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 and inflation adjustment - WW-N+",null,"£m",{"$f":" SUM(J38:W38)","v":0},null,{"$f":" J36 * J37","v":0},{"$f":" K36 * K37","v":0},{"$f":" L36 * L37","v":0},0,0,0,{"$f":" P36 * P37","v":0},0,0,0,0,{"$f":" U36 * U37","v":0},0,0]
[]
["REVENUE CORRECTION"]
[]
[null,"Main revenue over /  under recovery"]
[null,null,null,null,{"$f":" E$22","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$38","v":"Blind year (profiled) inc. financing rate and inflation adjustment - WW-N+"},0,"£m",0,0,{"$f":" J$38","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$114","v":"AMP7 forecasting incentive adjustment including over / under recovery true up"},{"$f":" F$114","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+",null,"£m",{"$f":" SUM(J46:W46)","v":0},null,{"$f":" SUM(J43:J45)","v":0},{"$f":" SUM(K43:K45)","v":0},{"$f":" SUM(L43:L45)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$46","v":"Adjusted allowed revenue - WW-N+"},0,"£m",0,0,0,{"$f":" K$46","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" InpActive!E$115","v":"Actual Revenue  - WW-N+ "},{"$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,"Revenue Imbalance  - WW-N+ ",null,"£m",{"$f":" SUM(J50:W50)","v":0},null,{"$f":"J48-J49","v":0},{"$f":"K48-K49","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$50","v":"Revenue Imbalance  - WW-N+ "},{"$f":"F$50","v":0},"£m",0,0,0,0,0,0,0,0,0,{"$f":"Q$50","v":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(J57:W57)","v":0},null,{"$f":" IF(J56 =1,  J55 * (1 + $F54) * (1 + $F54), 0)","v":0},0,0,0,0,0,{"$f":" IF(P56 =1,  P55 * (1 + $F54) * (1 + $F54), 0)","v":0},{"$f":" IF(Q56 =1,  Q55 * (1 + $F54) * (1 + $F54), 0)","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$57","v":"Main revenue adjustment - with financing adjustment - WW-N+"},{"$f":" F$57","v":0},{"$f":" G$57","v":"£m"},{"$f":" H$57","v":0},{"$f":" I$57","v":0},{"$f":" J$57","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(J61:W61)","v":0},null,{"$f":" J60 * K59 * L59","v":0},0,0,0,0,0,{"$f":" P60 * Q59 * R59","v":0},{"$f":" Q60 * R59 * S59","v":0},0,0,0,{"$f":" U60 * V59 * W59","v":0},{"$f":" V60 * W59 * X59","v":0},{"$f":" W60 * X59 * Y59","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$61","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - WW-N+"},{"$f":" F$61","v":0},{"$f":" G$61","v":"£m"},{"$f":" H$61","v":0},{"$f":" I$61","v":0},{"$f":" J$61","v":0},0,0,0,0,0,0,{"$f":" Q$61","v":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(J66:W66)","v":0},null,{"$f":" SUMIF($J65:$W65, J65 - $F63, $J64:$W64)","v":0},0,0,0,0,0,0,{"$f":" SUMIF($J65:$W65, Q65 - $F63, $J64:$W64)","v":0},0,0,0,0,0,0]
[]
["PENALTY CALCULATION"]
[]
[null,"Main revenue over /  under recovery"]
[null,null,null,null,{"$f":"E$46","v":"Adjusted allowed revenue - WW-N+"},{"$f":"F$46","v":0},"£m",0,0,0,0,0,0,0,{"$f":"O$46","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InpActive!E$115","v":"Actual Revenue  - WW-N+ "},{"$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,"Revenue Imbalance - WW-N+",null,"£m",{"$f":" SUM(J73:W73)","v":0},null,{"$f":" J71 - J72","v":0},{"$f":" K71 - K72","v":0},0,0,0,{"$f":" O71 - O72","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Penalty calculation"]
[null,null,null,null,{"$f":" InpActive!E$115","v":"Actual Revenue  - WW-N+ "},{"$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":"E$46","v":"Adjusted allowed revenue - WW-N+"},{"$f":"F$46","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Forecast error - WW-N+",null,"%",null,null,{"$f":" IF(J77 = 0, 0, ABS(J76 - J77) / J77)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U77 = 0, 0, ABS(U76 - U77) / U77)","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$78","v":"Forecast error - WW-N+"},{"$f":" F$78","v":0},"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$78","v":0},0,0]
[null,null,null,null,"Penalty applicable - WW-N+",null,"flag",null,null,{"$f":" IF(J81 > $F80, 1, 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U81 > $F80, 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$78","v":"Forecast error - WW-N+"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$78","v":0},0,0]
[null,null,null,null,{"$f":" E$82","v":"Penalty applicable - WW-N+"},0,"flag",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$82","v":0},0,0]
[null,null,null,null,"Error magnitude - WW-N+",null,"factor",null,null,{"$f":" IF(J87 = 1, (J86 - $F84) / ($F85 - $F84), 0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" IF(U87 = 1, (U86 - $F84) / ($F85 - $F84), 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$88","v":"Error magnitude - WW-N+"},0,"factor",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$88","v":0},0,0]
[null,null,null,null,"Penalty rate magnitude - WW-N+",null,"%",null,null,{"$f":" $F90 * MIN(1, J91)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" $F90 * MIN(1, U91)","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":" InpActive!E$115","v":"Actual Revenue  - WW-N+ "},{"$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":"E$46","v":"Adjusted allowed revenue - WW-N+"},{"$f":"F$46","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$92","v":"Penalty rate magnitude - WW-N+"},0,"%",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$92","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(J99:W99)","v":0},null,{"$f":"  IF(J98=1, J97 * ABS(J95 - J96), 0 )","v":0},0,0,0,0,0,{"$f":"  IF(P98=1, P97 * ABS(P95 - P96), 0 )","v":0},{"$f":"  IF(Q98=1, Q97 * ABS(Q95 - Q96), 0 )","v":0},0,0,0,0,0,0]
[null,null,null,null,{"$f":" LEFT(E99, LEN(E99) - 4)","v":"Penalty adjustment - WW-N+"},null,"£m",{"$f":" SUM(J100:W100)","v":0},null,{"$f":" -1 * J99","v":0},0,0,0,0,0,{"$f":" -1 * P99","v":0},0,0,0,0,{"$f":" -1 * U99","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$100","v":"Penalty adjustment - WW-N+"},{"$f":" F$100","v":0},{"$f":" G$100","v":"£m"},{"$f":" H$100","v":0},{"$f":" I$100","v":0},{"$f":" J$100","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" U$100","v":0},0,0]
[null,null,null,null,"Penalty adjustment - with financing adjustment - WW-N+",null,"£m",{"$f":" SUM(J104:W104)","v":0},null,{"$f":" J103 * (1 + $F102)","v":0},0,0,0,0,0,{"$f":" P103 * (1 + $F102)","v":0},0,0,0,0,{"$f":" U103 * (1 + $F102)","v":0},0,0]
[]
[null,null,null,null,{"$f":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":" E$104","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$104","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(J109:W109)","v":0},null,{"$f":"IF(J108=1,J107*K106*L106,0)","v":0},{"$f":"IF(K108=1,K107*L106*M106,0)","v":0},0,{"$f":"IF(M108=1,M107*N106*O106,0)","v":0},0,0,{"$f":"IF(P108=1,P107*Q106*R106,0)","v":0},{"$f":"IF(Q108=1,Q107*R106*S106,0)","v":0},{"$f":"IF(R108=1,R107*S106*T106,0)","v":0},0,{"$f":"IF(T108=1,T107*U106*V106,0)","v":0},{"$f":"IF(U108=1,U107*V106*W106,0)","v":0}]
[]
[null,null,null,null,{"$f":" E$61","v":"Main revenue adjustment - with financing adjustment & 2 year lag of inflation - WW-N+"},{"$f":" F$61","v":0},{"$f":" G$61","v":"£m"},{"$f":" H$61","v":0},{"$f":" I$61","v":0},{"$f":" J$61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$109","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$109","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,"AMP7 forecasting incentive adjustment including over / under recovery true up","2 PD LK BCK","£m",{"$f":" SUM(J114:W114)","v":0},null,null,{"$f":" ( I111 + I112 ) * K113","v":0},{"$f":" ( J111 + J112 ) * L113","v":0},0,0,0,{"$f":" ( N111 + N112 ) * P113","v":0},{"$f":" ( O111 + O112 ) * Q113","v":0},0,0,{"$f":" ( R111 + R112 ) * T113","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$78","v":"Forecast error - WW-N+"},{"$f":"F$78","v":0},{"$f":"G$78","v":"%"},{"$f":"H$78","v":0},{"$f":"I$78","v":0},{"$f":"J$78","v":0},0,0,0,0,0,0,{"$f":"Q$78","v":0},0,0,0,0,0,0]
[null,null,null,null,"Performance variance level alert - WW-N+",{"$f":" IF(SUM(J119:W119) > 0, 1, 0)","v":0},"alert",null,null,{"$f":" IF(ABS(J118) > $F117, 1, 0)","v":0},0,0,0,0,0,0,{"$f":" IF(ABS(Q118) > $F117, 1, 0)","v":0},0,0,0,{"$f":" IF(ABS(U118) > $F117, 1, 0)","v":0},0,0]
[]
[]
["APPLICATION OF ADJUSTMENTS IN LAST TWO YEARS AT THE END OF AMP7"]
[]
[null,"Year 4 - 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":" 'Indices and K factor'!E$11","v":"CPIH: Nov % increase (prior year) - CALC"},{"$f":" 'Indices and K factor'!F$11","v":0},{"$f":" 'Indices and K factor'!G$11","v":"%"},{"$f":" 'Indices and K factor'!H$11","v":0},{"$f":" 'Indices and K factor'!I$11","v":0},{"$f":" 'Indices and K factor'!J$11","v":0},{"$f":" 'Indices and K factor'!K$11","v":0},{"$f":" 'Indices and K factor'!L$11","v":1},{"$f":" 'Indices and K factor'!M$11","v":1},{"$f":" 'Indices and K factor'!N$11","v":1},{"$f":" 'Indices and K factor'!O$11","v":1},{"$f":" 'Indices and K factor'!P$11","v":1},{"$f":" 'Indices and K factor'!Q$11","v":1},{"$f":" 'Indices and K factor'!R$11","v":1},{"$f":" 'Indices and K factor'!S$11","v":1},{"$f":" 'Indices and K factor'!T$11","v":1},{"$f":" 'Indices and K factor'!U$11","v":1},{"$f":" 'Indices and K factor'!V$11","v":1},{"$f":" 'Indices and K factor'!W$11","v":1}]
[null,null,null,null,{"$f":"E$50","v":"Revenue Imbalance  - WW-N+ "},0,"£m",0,0,0,{"$f":"K$50","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$100","v":"Penalty adjustment - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$100","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 AMP7 - WW",null,"£m",{"$f":" SUM(J130:W130)","v":0},null,{"$f":" IF(J129 = 1, I127 * J126 * (1 + $F125), 0)","v":0},{"$f":" IF(K129 = 1, J127 * K126 * (1 + $F125), 0)","v":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 AMP7 - WW",null,"£m",{"$f":" SUM(J131:W131)","v":0},null,{"$f":" J129 * ( I128 * J126 * (1 + $F125))","v":0},{"$f":" K129 * ( J128 * K126 * (1 + $F125))","v":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 AMP7 - WW",null,"£m",{"$f":" SUM(J132:W132)","v":0},null,{"$f":" SUM(J130:J131)","v":0},{"$f":" SUM(K130:K131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Year 5 - No CPIH and financing costs adjustments applied"]
[null,null,null,null,{"$f":"E$50","v":"Revenue Imbalance  - WW-N+ "},0,"£m",0,0,0,{"$f":"K$50","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$100","v":"Penalty adjustment - WW-N+"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$100","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 AMP7 - WW",null,"£m",{"$f":" SUM(J138:W138)","v":0},null,{"$f":"SUM(J135:J136) * J137","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$132","v":"Value of year 4 RFI adjustments at the end of AMP7 - WW"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$132","v":0},0,0]
[null,null,null,null,{"$f":" E$138","v":"Value of year 5 RFI adjustments at the end of AMP7 - WW"},0,"£m",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":" U$138","v":0},0,0]
[null,null,null,null,"Total reward / (penalty) at the end of AMP7 - WW",null,"£m",{"$f":" SUM(J143:W143)","v":0},null,{"$f":" SUM(J141:J142)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":" SUM(U141:U142)","v":0},0,0]
[]
[]
["End of sheet"]

{"sheet":"Output","index":7,"n_rows":15,"n_cols":23,"rows_kept":15,"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 AMP7"]
[]
[null,null,null,null,{"$f":" 'Wholesale Water'!E$235","v":"Total reward / (penalty) at the end of AMP7 - Water-N+"},{"$f":" 'Wholesale Water'!F$235","v":0},{"$f":" 'Wholesale Water'!G$235","v":"£m"},{"$f":" 'Wholesale Water'!H$235","v":0},{"$f":" 'Wholesale Water'!I$235","v":0},{"$f":" 'Wholesale Water'!J$235","v":0},{"$f":" 'Wholesale Water'!K$235","v":0},{"$f":" 'Wholesale Water'!L$235","v":0},{"$f":" 'Wholesale Water'!M$235","v":0},{"$f":" 'Wholesale Water'!N$235","v":0},{"$f":" 'Wholesale Water'!O$235","v":0},{"$f":" 'Wholesale Water'!P$235","v":0},{"$f":" 'Wholesale Water'!Q$235","v":0},{"$f":" 'Wholesale Water'!R$235","v":0},{"$f":" 'Wholesale Water'!S$235","v":0},{"$f":" 'Wholesale Water'!T$235","v":0},{"$f":" 'Wholesale Water'!U$235","v":0},{"$f":" 'Wholesale Water'!V$235","v":0},{"$f":" 'Wholesale Water'!W$235","v":0}]
[]
[null,null,null,null,{"$f":" 'Wholesale Water'!E$236","v":"Total reward / (penalty) at the end of AMP7 - Water Res"},{"$f":" 'Wholesale Water'!F$236","v":0},{"$f":" 'Wholesale Water'!G$236","v":"£m"},{"$f":" 'Wholesale Water'!H$236","v":0},{"$f":" 'Wholesale Water'!I$236","v":0},{"$f":" 'Wholesale Water'!J$236","v":0},{"$f":" 'Wholesale Water'!K$236","v":0},{"$f":" 'Wholesale Water'!L$236","v":0},{"$f":" 'Wholesale Water'!M$236","v":0},{"$f":" 'Wholesale Water'!N$236","v":0},{"$f":" 'Wholesale Water'!O$236","v":0},{"$f":" 'Wholesale Water'!P$236","v":0},{"$f":" 'Wholesale Water'!Q$236","v":0},{"$f":" 'Wholesale Water'!R$236","v":0},{"$f":" 'Wholesale Water'!S$236","v":0},{"$f":" 'Wholesale Water'!T$236","v":0},{"$f":" 'Wholesale Water'!U$236","v":0},{"$f":" 'Wholesale Water'!V$236","v":0},{"$f":" 'Wholesale Water'!W$236","v":0}]
[]
[null,null,null,null,{"$f":" 'Wastewater Network-Plus'!E$143","v":"Total reward / (penalty) at the end of AMP7 - WW"},{"$f":" 'Wastewater Network-Plus'!F$143","v":0},{"$f":" 'Wastewater Network-Plus'!G$143","v":"£m"},{"$f":" 'Wastewater Network-Plus'!H$143","v":0},{"$f":" 'Wastewater Network-Plus'!I$143","v":0},{"$f":" 'Wastewater Network-Plus'!J$143","v":0},{"$f":" 'Wastewater Network-Plus'!K$143","v":0},{"$f":" 'Wastewater Network-Plus'!L$143","v":0},{"$f":" 'Wastewater Network-Plus'!M$143","v":0},{"$f":" 'Wastewater Network-Plus'!N$143","v":0},{"$f":" 'Wastewater Network-Plus'!O$143","v":0},{"$f":" 'Wastewater Network-Plus'!P$143","v":0},{"$f":" 'Wastewater Network-Plus'!Q$143","v":0},{"$f":" 'Wastewater Network-Plus'!R$143","v":0},{"$f":" 'Wastewater Network-Plus'!S$143","v":0},{"$f":" 'Wastewater Network-Plus'!T$143","v":0},{"$f":" 'Wastewater Network-Plus'!U$143","v":0},{"$f":" 'Wastewater Network-Plus'!V$143","v":0},{"$f":" 'Wastewater Network-Plus'!W$143","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$103","v":"Blind year profiling factor - Water-N+ - Validation"},{"$f":" InpActive!F$103","v":0},{"$f":" InpActive!G$103","v":"Check"}]
[null,null,null,null,{"$f":" InpActive!E$123","v":"Blind year profiling factor - WW-N+ - Validation"},{"$f":" InpActive!F$123","v":0},{"$f":" InpActive!G$123","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$181","v":"Performance variance level alert"},{"$f":" 'Wholesale Water'!F$181","v":0},{"$f":" 'Wholesale Water'!G$181","v":"alert"}]
[null,null,null,null,{"$f":" 'Wastewater Network-Plus'!E$119","v":"Performance variance level alert - WW-N+"},{"$f":" 'Wastewater Network-Plus'!F$119","v":0},{"$f":" 'Wastewater Network-Plus'!G$119","v":"alert"}]
[]
[null,null,null,null,"[do not delete this row]","[range ends]"]
[]
["End of sheet"]