{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Cover","Adjustments log","F_Inputs","InpOverride","Time","Dashboards-->","Dashboard - WR + WN","Dashboard - WWN","Calc-->","Dashboard Calcs","Ex-ante allowances","Cost profiling","Outputs-->","F_Outputs","Integrity checks-->","Check","Track"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,"Model name:","Cost sharing and total costs model"]
[null,"Version number:","3d"]
[null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"PR19FM008 Cost_sharing__total_costs v3d_SWB_FD_signedoff.xlsm"}]
[null,"Date:","2019-11-28"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Summary of model:","This model is used to apply cost sharing to expenditure for water resources, water network and wastewater network. "]
[null,null,"Profiling is applied in the model with using the assumption from the PR19 opex/capex split model. "]
[null,null,"Adjustments for operating leases are applied as they are not taken into account in the cost assessment models"]
[]
[null,"Error check status",{"$f":"Check!C$8","v":0}]
[null,"Track changes status",{"$f":"Check!$F$20","v":36}]
[]
[]
[null,"Instructions"]
[null,"Track ","To store Track in the Track sheet, follow the steps mentioned below:"]
[]
[null,"Using Macro","Please follow the steps mentioned below for storing Track using a macro:"]
[]
[null,"Step 1 - ","Go to the Track sheet and press \"Store Outputs\" button to save the track for new case"]
[null,null,{"$f":"Track!$E$3","v":"Store Track"}]
[]
[null,"Step 2 - ","A dialog box \"Enter the label for the new track column\" will appear, type the new track label (For ex: version name like \"01A\"), the label will appear in row 5."]
[]
[null,"Step 3 - ","A new dialog box \"Enter the comment for the new track\" will appear, write the brief description of the change done in the model. The description will be updated in row 62."]
[]
[null,"Step 4 - ","Press enter, a new track column will appear before the last stored track:"]
[]
[null,"Step 5 - ","Review the difference between stored cases and active case (col H) by selecting the stored case in cell H5."]
[null,null,{"$f":"Track!$F$5","v":"Nil inputs"}]
[]
[null,"Manual Steps Macro","Please follow the steps mentioned below for storing Track manually:"]
[]
[null,"Step 1 - ","Go to last stored column of 'Track' sheet"]
[null,null,"Select the column by pressing Ctrl + Spacebar and Copy (Ctrl + C). Then insert a new column after the last stored column by pressing Alt, I, E"]
[]
[null,"Step 2 - ","Select the newly inserted column (Ctrl + Spacebar) and delete the previously stored values from this column by pressing Delete button"]
[]
[null,"Step 3 - ","Go to active track column (H column)"]
[null,null,{"$f":"Track!$F$5","v":"Nil inputs"}]
[null,null,"Select the range from H6 till 'do not delete row - range end' row and Copy (Ctrl + C)"]
[]
[null,"Step 4 - ","Paste the selected values (Alt E, S, V) in newly inserted column"]
[]
[null,"Step 5 - ","Update 'New track name' in row 5 of newly inserted column. Then select 'New track name' from the dropdown list present in H5."]
[]
[null,"Step 6 - ","Review the difference between stored cases and active case (col H) by selecting the stored case in cell H5."]
[null,null,{"$f":"Track!$F$5","v":"Nil inputs"}]

{"sheet":"Adjustments log","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Adjustments log"]
[]
[]
[null,"Run"]
[null,"Type"]
[null,"Stage"]
[]
[]
[null,"#","Description","Location","Link"]

{"sheet":"F_Inputs","index":2,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,"Pr19CostSharIn5"]
["Acronym","Reference","Item description","Unit","Model","2020-21","2021-22","2022-23","2023-24","2024-25"]
[]
["SWB","C_WRTOTEXFM_CS_PR19CA004","Final cost allowance for cost sharing for Water Resources","£m","Price Review 2019",14.790490043757099,14.790490043757099,14.790490043757099,14.790490043757099,14.790490043757099]
["SWB","C_WNTOTEXFM_CS_PR19CA004","Final cost allowance for cost sharing for Network Plus Water","£m","Price Review 2019",170.844604212993,170.844604212993,170.844604212993,170.844604212993,170.844604212993]
["SWB","PR19_WR_CAPEX_CS","Water resources company view of capex - for cost sharing model","£m","Price Review 2019",5.4829999999999997,6.0410000000000004,4.95,3.7749999999999999,3.4649999999999999]
["SWB","PR19_WN_CAPEX_CS","Water network company view of capex - for cost sharing model","£m","Price Review 2019",68.813000000000002,83.796000000000006,103.568,95.088999999999999,89.400999999999996]
["SWB","PR19_WR_OPEX_CS","Water resources company view of opex - for cost sharing model","£m","Price Review 2019",11.085000000000001,11.148999999999999,11.166,11.199,11.242000000000001]
["SWB","PR19_WN_OPEX_CS","Water network company view of opex - for cost sharing model","£m","Price Review 2019",79.278999999999996,79.605999999999995,79.356999999999999,78.55,78.241]
["SWB","C_WWNTOTEXFM_CS_PR19CA008","Efficient totex for cost sharing network plus wastewater £m","£m","Price Review 2019",166.404949969841,166.404949969841,166.404949969841,166.404949969841,166.404949969841]
["SWB","PR19_WWN_OPEX_CS","Wastewater network company view of opex - for cost sharing model","£m","Price Review 2019",80.498999999999995,80.117999999999995,79.534999999999997,77.992000000000004,77.099000000000004]
["SWB","PR19_BR_OPEX_CS","Bio resources company view of opex - for cost sharing model","£m","Price Review 2019",14.304,14.456,14.433,14.448,14.513]
["SWB","PR19_WWN_CAPEX_CS","Wastewater network company view of capex - for cost sharing model","£m","Price Review 2019",111.44499999999999,108.18,92.908000000000001,93.126999999999995,81.194000000000003]
["SWB","PR19_BR_CAPEX_CS","Bio resources company view of capex - for cost sharing model","£m","Price Review 2019",5.4359999999999999,5.6870000000000003,6.375,6.03,5.4409999999999998]
["SWB","C_BRTOTEXFM_CS_PR19CA008","Efficient totex for cost sharing bioresources £m","£m","Price Review 2019",18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901]
["SWB","C_DUMMYTOTEXFM_CS_PR19CA008","Final cost allowance for cost sharing for WWW Dummy £m","£m","Price Review 2019",0,0,0,0,0]
["SWB","PR19_DMMY_OPEX_CS","Dummy company view of opex - for cost sharing model","£m","Price Review 2019",0,0,0,0,0]
["SWB","PR19_DMMY_CAPEX_CS","Dummy company view of capex - for cost sharing model","£m","Price Review 2019",0,0,0,0,0]
["SWB","C_WROTHER_EXCPDR_PR19CA004","WR - Other costs not subject to cost sharing excl PDR","£m","Price Review 2019",0.19650000000000001,0.19650000000000001,0.19650000000000001,0.19650000000000001,0.19650000000000001]
["SWB","C_WNOTHER_EXCPDR_PR19CA004","WN - Other costs not subject to cost sharing excl PDR","£m","Price Review 2019",1.6127779656032,1.6127779656032,1.6127779656032,1.6127779656032,1.6127779656032]
["SWB","C_WWNOTHER_EXCPDR_PR19CA008","WWN - Other costs not subject to cost sharing excl PDR","£m","Price Review 2019",1.5558498468448301,1.5558498468448301,1.5558498468448301,1.5558498468448301,1.5558498468448301]
["SWB","C_BROTHER_EXCPDR_PR19CA008","BR - Other costs not subject to cost sharing excl PDR","£m","Price Review 2019",0,0,0,0,0]
["SWB","C_DMYOTHER_EXCPDR_PR19CA008","DMMY - Other costs not subject to cost sharing excl PDR","£m","Price Review 2019"]
["SWB","C_OP_LEASE_ADJ_WR_PR19","Opex lease adjustment - WR - Real","£m","Price Review 2019",0,0,0,0,0]
["SWB","C_OP_LEASE_ADJ_WN_PR19","Opex lease adjustment - WN - Real","£m","Price Review 2019",-0.76605533226703304,-0.699247294979923,-0.65409508498250901,-0.62260270979230903,-0.59064959370929004]
["SWB","C_OP_LEASE_ADJ_WWN_PR19","Opex lease adjustment - WWN - Real","£m","Price Review 2019",-0.757261329728253,-0.69355464400315303,-0.64948878156713896,-0.61812998917598505,-0.58891238902190901]
["SWB","C_OP_LEASE_ADJ_BR_PR19","Opex lease adjustment - BR - Real","£m","Price Review 2019",0,0,0,0,0]
["SWB","C_OP_LEASE_ADJ_DMMY_PR19","Opex lease adjustment - DMMY - Real","£m","Price Review 2019",0,0,0,0,0]
["SWB","C_CAPEX_SPLIT_WR_PR19CA091","Capex split for cost sharing - WR","%","Price Review 2019",6.0206900088681403E-2,6.7608348788400802E-2,5.6088066870347002E-2,4.3091090183772399E-2,3.51274103409236E-2]
["SWB","C_OPEX_SPLIT_WR_PR19CA091","Opex split for cost sharing - WR","%","Price Review 2019",0.14650553256909199,0.14732690783643601,0.14755123839056,0.14796354029450201,0.14853096463728499]
["SWB","C_CAPEX_SPLIT_WN_PR19CA091","Capex split for cost sharing - WN","%","Price Review 2019",7.8906221312502897E-2,9.4446052042378797E-2,0.113327239902731,0.105547430139538,0.100574393664634]
["SWB","C_OPEX_SPLIT_WN_PR19CA091","Opex split for cost sharing - WN","%","Price Review 2019",0.102360417139246,0.102522050468316,0.101673548964828,0.100567031525459,0.10007561484036499]
["SWB","C_CAPEX_SPLIT_WWN_PR19CA091","Capex split for cost sharing - WWN","%","Price Review 2019",0.12218989299973999,0.11901930778764799,0.102488078046585,0.103062966645073,9.0998055100723702E-2]
["SWB","C_OPEX_SPLIT_WWN_PR19CA091","Opex split for cost sharing - WWN","%","Price Review 2019",9.4110612596142104E-2,9.3698069343610399E-2,9.3018765008116802E-2,9.1223978172373099E-2,9.0190274299986703E-2]
["SWB","C_CAPEX_SPLIT_BR_PR19CA091","Capex split for cost sharing - BR","%","Price Review 2019",4.8025725802973901E-2,4.9214914951125503E-2,5.2474157594849802E-2,5.0837664421742201E-2,4.8052767625295499E-2]
["SWB","C_OPEX_SPLIT_BR_PR19CA091","Opex split for cost sharing - BR","%","Price Review 2019",0.14895780284361901,0.150541517068634,0.15030187610037499,0.15045816368837001,0.15113540990301499]
["SWB","C_CAPEX_SPLIT_DMMY_PR19CA091","Capex split for cost sharing - DMMY","%","Price Review 2019",0,0,0,0,0]
["SWB","C_OPEX_SPLIT_DMMY_PR19CA091","Opex split for cost sharing - DMMY","%","Price Review 2019",0,0,0,0,0]

{"sheet":"InpOverride","index":3,"n_rows":223,"n_cols":20,"rows_kept":223,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"InpOverride"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks",null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6}]
[]
["TIME"]
[]
[null,null,null,null,"First date of time ruler","2019-04-01","date"]
[]
[null,null,null,null,"Last Pre Forecast Date","2020-03-31","date"]
[]
[null,null,null,null,"Acquisition date (midnight)","2020-03-31","date"]
[null,null,null,null,"Length of forecast period",5,"years"]
[null,null,null,null,"Last forecast date",{"$f":"DATE(YEAR(F14)+F15,MONTH(F14),DAY(F14))","v":"2025-03-31"},"date"]
[]
[]
[null,null,null,null,"Operation Start Date (midnight)","2021-03-31","date"]
[null,null,null,null,"Operation Finish Date (midnight)","2025-03-31","date"]
[null,null,null,null,"First Modelling Column Financial Year Number",2020,"year"]
[null,null,null,null,"Financial Year End Month Number",3,"month #"]
[]
[]
["TOTEX INPUTS"]
[]
[null,null,"Water Resources"]
[null,null,null,null,{"$f":"F_Inputs!C$4","v":"Final cost allowance for cost sharing for Water Resources"},null,{"$f":"F_Inputs!D$4","v":"£m"},{"$f":"SUM(J28:P28)","v":73.952450218785501},null,null,{"$f":"F_Inputs!F$4","v":14.790490043757099},{"$f":"F_Inputs!G$4","v":14.790490043757099},{"$f":"F_Inputs!H$4","v":14.790490043757099},{"$f":"F_Inputs!I$4","v":14.790490043757099},{"$f":"F_Inputs!J$4","v":14.790490043757099}]
[]
[null,null,null,null,{"$f":"F_Inputs!C$6","v":"Water resources company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D$6","v":"£m"},{"$f":"SUM(J30:P30)","v":23.713999999999999},null,null,{"$f":"F_Inputs!F$6","v":5.4829999999999997},{"$f":"F_Inputs!G$6","v":6.0410000000000004},{"$f":"F_Inputs!H$6","v":4.95},{"$f":"F_Inputs!I$6","v":3.7749999999999999},{"$f":"F_Inputs!J$6","v":3.4649999999999999}]
[null,null,null,null,{"$f":"F_Inputs!C$8","v":"Water resources company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D$8","v":"£m"},55.841000000000008,null,null,{"$f":"F_Inputs!F$8","v":11.085000000000001},{"$f":"F_Inputs!G$8","v":11.148999999999999},{"$f":"F_Inputs!H$8","v":11.166},{"$f":"F_Inputs!I$8","v":11.199},{"$f":"F_Inputs!J$8","v":11.242000000000001}]
[null,null,null,null,{"$f":"F_Inputs!C$19","v":"WR - Other costs not subject to cost sharing excl PDR"},null,{"$f":"F_Inputs!D$19","v":"£m"},{"$f":"SUM(J32:P32)","v":0.98250000000000004},null,null,{"$f":"F_Inputs!F$19","v":0.19650000000000001},{"$f":"F_Inputs!G$19","v":0.19650000000000001},{"$f":"F_Inputs!H$19","v":0.19650000000000001},{"$f":"F_Inputs!I$19","v":0.19650000000000001},{"$f":"F_Inputs!J$19","v":0.19650000000000001}]
[]
[null,null,null,null,"WR operating lease adjustment",null,"£m",{"$f":" SUM(K34:O34)","v":0},null,null,{"$f":"F_Inputs!F24","v":0},{"$f":"F_Inputs!G24","v":0},{"$f":"F_Inputs!H24","v":0},{"$f":"F_Inputs!I24","v":0},{"$f":"F_Inputs!J24","v":0}]
[]
[null,null,"Water Network"]
[null,null,null,null,{"$f":"F_Inputs!C$5","v":"Final cost allowance for cost sharing for Network Plus Water"},null,{"$f":"F_Inputs!D$5","v":"£m"},854.223021064965,null,null,{"$f":"F_Inputs!F$5","v":170.844604212993},{"$f":"F_Inputs!G$5","v":170.844604212993},{"$f":"F_Inputs!H$5","v":170.844604212993},{"$f":"F_Inputs!I$5","v":170.844604212993},{"$f":"F_Inputs!J$5","v":170.844604212993}]
[]
[null,null,null,null,{"$f":"F_Inputs!C$7","v":"Water network company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D$7","v":"£m"},440.66700000000003,null,null,{"$f":"F_Inputs!F$7","v":68.813000000000002},{"$f":"F_Inputs!G$7","v":83.796000000000006},{"$f":"F_Inputs!H$7","v":103.568},{"$f":"F_Inputs!I$7","v":95.088999999999999},{"$f":"F_Inputs!J$7","v":89.400999999999996}]
[null,null,null,null,{"$f":"F_Inputs!C$9","v":"Water network company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D$9","v":"£m"},395.03299999999996,null,null,{"$f":"F_Inputs!F$9","v":79.278999999999996},{"$f":"F_Inputs!G$9","v":79.605999999999995},{"$f":"F_Inputs!H$9","v":79.356999999999999},{"$f":"F_Inputs!I$9","v":78.55},{"$f":"F_Inputs!J$9","v":78.241}]
[null,null,null,null,{"$f":"F_Inputs!C$20","v":"WN - Other costs not subject to cost sharing excl PDR"},null,{"$f":"F_Inputs!D$20","v":"£m"},8.0638898280160003,null,null,{"$f":"F_Inputs!F$20","v":1.6127779656032},{"$f":"F_Inputs!G$20","v":1.6127779656032},{"$f":"F_Inputs!H$20","v":1.6127779656032},{"$f":"F_Inputs!I$20","v":1.6127779656032},{"$f":"F_Inputs!J$20","v":1.6127779656032}]
[]
[null,null,null,null,"WN operating lease adjustment",null,"£m",{"$f":" SUM(K43:O43)","v":-3.3326500157310641},null,null,{"$f":"F_Inputs!F25","v":-0.76605533226703304},{"$f":"F_Inputs!G25","v":-0.699247294979923},{"$f":"F_Inputs!H25","v":-0.65409508498250901},{"$f":"F_Inputs!I25","v":-0.62260270979230903},{"$f":"F_Inputs!J25","v":-0.59064959370929004}]
[]
[null,null,"Water"]
[null,null,null,null,{"$f":"F_Inputs!C6","v":"Water resources company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D6","v":"£m"},23.713999999999999,null,null,{"$f":"F_Inputs!F6","v":5.4829999999999997},{"$f":"F_Inputs!G6","v":6.0410000000000004},{"$f":"F_Inputs!H6","v":4.95},{"$f":"F_Inputs!I6","v":3.7749999999999999},{"$f":"F_Inputs!J6","v":3.4649999999999999}]
[null,null,null,null,{"$f":"F_Inputs!C7","v":"Water network company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D7","v":"£m"},440.66700000000003,null,null,{"$f":"F_Inputs!F7","v":68.813000000000002},{"$f":"F_Inputs!G7","v":83.796000000000006},{"$f":"F_Inputs!H7","v":103.568},{"$f":"F_Inputs!I7","v":95.088999999999999},{"$f":"F_Inputs!J7","v":89.400999999999996}]
[null,null,null,null,{"$f":"F_Inputs!C8","v":"Water resources company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D8","v":"£m"},55.841000000000008,null,null,{"$f":"F_Inputs!F8","v":11.085000000000001},{"$f":"F_Inputs!G8","v":11.148999999999999},{"$f":"F_Inputs!H8","v":11.166},{"$f":"F_Inputs!I8","v":11.199},{"$f":"F_Inputs!J8","v":11.242000000000001}]
[null,null,null,null,{"$f":"F_Inputs!C9","v":"Water network company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D9","v":"£m"},395.03299999999996,null,null,{"$f":"F_Inputs!F9","v":79.278999999999996},{"$f":"F_Inputs!G9","v":79.605999999999995},{"$f":"F_Inputs!H9","v":79.356999999999999},{"$f":"F_Inputs!I9","v":78.55},{"$f":"F_Inputs!J9","v":78.241}]
[null,null,null,null,"Total gross capital expenditure - Water",{"$f":" SUM(H46:H49)","v":915.25499999999988}]
[]
[null,null,"Wastewater Network"]
[null,null,null,null,{"$f":"F_Inputs!C$10","v":"Efficient totex for cost sharing network plus wastewater £m"},null,{"$f":"F_Inputs!D$10","v":"£m"},832.02474984920502,null,null,{"$f":"F_Inputs!F$10","v":166.404949969841},{"$f":"F_Inputs!G$10","v":166.404949969841},{"$f":"F_Inputs!H$10","v":166.404949969841},{"$f":"F_Inputs!I$10","v":166.404949969841},{"$f":"F_Inputs!J$10","v":166.404949969841}]
[]
[null,null,null,null,{"$f":"F_Inputs!C$13","v":"Wastewater network company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D$13","v":"£m"},486.85400000000004,null,null,{"$f":"F_Inputs!F$13","v":111.44499999999999},{"$f":"F_Inputs!G$13","v":108.18},{"$f":"F_Inputs!H$13","v":92.908000000000001},{"$f":"F_Inputs!I$13","v":93.126999999999995},{"$f":"F_Inputs!J$13","v":81.194000000000003}]
[null,null,null,null,{"$f":"F_Inputs!C$11","v":"Wastewater network company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D$11","v":"£m"},395.24299999999999,null,null,{"$f":"F_Inputs!F$11","v":80.498999999999995},{"$f":"F_Inputs!G$11","v":80.117999999999995},{"$f":"F_Inputs!H$11","v":79.534999999999997},{"$f":"F_Inputs!I$11","v":77.992000000000004},{"$f":"F_Inputs!J$11","v":77.099000000000004}]
[null,null,null,null,{"$f":"F_Inputs!C$21","v":"WWN - Other costs not subject to cost sharing excl PDR"},null,{"$f":"F_Inputs!D$21","v":"£m"},7.7792492342241504,null,null,{"$f":"F_Inputs!F$21","v":1.5558498468448301},{"$f":"F_Inputs!G$21","v":1.5558498468448301},{"$f":"F_Inputs!H$21","v":1.5558498468448301},{"$f":"F_Inputs!I$21","v":1.5558498468448301},{"$f":"F_Inputs!J$21","v":1.5558498468448301}]
[]
[null,null,null,null,"WWN operating lease adjustment",null,"£m",{"$f":" SUM(K59:O59)","v":-3.3073471334964393},null,null,{"$f":"F_Inputs!F26","v":-0.757261329728253},{"$f":"F_Inputs!G26","v":-0.69355464400315303},{"$f":"F_Inputs!H26","v":-0.64948878156713896},{"$f":"F_Inputs!I26","v":-0.61812998917598505},{"$f":"F_Inputs!J26","v":-0.58891238902190901}]
[]
[]
[null,null,"Bioresources"]
[null,null,null,null,{"$f":"F_Inputs!C$15","v":"Efficient totex for cost sharing bioresources £m"},null,{"$f":"F_Inputs!D$15","v":"£m"},92.876588685309514,null,null,{"$f":"F_Inputs!F$15","v":18.575317737061901},{"$f":"F_Inputs!G$15","v":18.575317737061901},{"$f":"F_Inputs!H$15","v":18.575317737061901},{"$f":"F_Inputs!I$15","v":18.575317737061901},{"$f":"F_Inputs!J$15","v":18.575317737061901}]
[]
[null,null,null,null,{"$f":"F_Inputs!C$14","v":"Bio resources company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D$14","v":"£m"},28.969000000000001,null,null,{"$f":"F_Inputs!F$14","v":5.4359999999999999},{"$f":"F_Inputs!G$14","v":5.6870000000000003},{"$f":"F_Inputs!H$14","v":6.375},{"$f":"F_Inputs!I$14","v":6.03},{"$f":"F_Inputs!J$14","v":5.4409999999999998}]
[null,null,null,null,{"$f":"F_Inputs!C$12","v":"Bio resources company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D$12","v":"£m"},72.153999999999996,null,null,{"$f":"F_Inputs!F$12","v":14.304},{"$f":"F_Inputs!G$12","v":14.456},{"$f":"F_Inputs!H$12","v":14.433},{"$f":"F_Inputs!I$12","v":14.448},{"$f":"F_Inputs!J$12","v":14.513}]
[null,null,null,null,{"$f":"F_Inputs!C$22","v":"BR - Other costs not subject to cost sharing excl PDR"},null,{"$f":"F_Inputs!D$22","v":"£m"},0,null,null,{"$f":"F_Inputs!F$22","v":0},{"$f":"F_Inputs!G$22","v":0},{"$f":"F_Inputs!H$22","v":0},{"$f":"F_Inputs!I$22","v":0},{"$f":"F_Inputs!J$22","v":0}]
[]
[null,null,null,null,"BR operating lease adjustment",null,"£m",{"$f":" SUM(K69:O69)","v":0},null,null,{"$f":"F_Inputs!F27","v":0},{"$f":"F_Inputs!G27","v":0},{"$f":"F_Inputs!H27","v":0},{"$f":"F_Inputs!I27","v":0},{"$f":"F_Inputs!J27","v":0}]
[]
[]
[null,null,"Dummy"]
[null,null,null,null,{"$f":"F_Inputs!C$16","v":"Final cost allowance for cost sharing for WWW Dummy £m"},null,{"$f":"F_Inputs!D$16","v":"£m"},{"$f":"SUM(J73:P73)","v":0},null,null,{"$f":"F_Inputs!F$16","v":0},{"$f":"F_Inputs!G$16","v":0},{"$f":"F_Inputs!H$16","v":0},{"$f":"F_Inputs!I$16","v":0},{"$f":"F_Inputs!J$16","v":0}]
[]
[null,null,null,null,{"$f":"F_Inputs!C$17","v":"Dummy company view of opex - for cost sharing model"},null,{"$f":"F_Inputs!D$17","v":"£m"},0,null,null,{"$f":"F_Inputs!F$17","v":0},{"$f":"F_Inputs!G$17","v":0},{"$f":"F_Inputs!H$17","v":0},{"$f":"F_Inputs!I$17","v":0},{"$f":"F_Inputs!J$17","v":0}]
[null,null,null,null,{"$f":"F_Inputs!C$18","v":"Dummy company view of capex - for cost sharing model"},null,{"$f":"F_Inputs!D$18","v":"£m"},0,null,null,{"$f":"F_Inputs!F$18","v":0},{"$f":"F_Inputs!G$18","v":0},{"$f":"F_Inputs!H$18","v":0},{"$f":"F_Inputs!I$18","v":0},{"$f":"F_Inputs!J$18","v":0}]
[null,null,null,null,{"$f":"F_Inputs!C$23","v":"DMMY - Other costs not subject to cost sharing excl PDR"},null,{"$f":"F_Inputs!D$23","v":"£m"},0,null,null,{"$f":"F_Inputs!F$23","v":0},{"$f":"F_Inputs!G$23","v":0},{"$f":"F_Inputs!H$23","v":0},{"$f":"F_Inputs!I$23","v":0},{"$f":"F_Inputs!J$23","v":0}]
[]
[null,null,null,null,"DMMY operating lease adjustment",null,"£m",{"$f":" SUM(K79:O79)","v":0},null,null,{"$f":"F_Inputs!F28","v":0},{"$f":"F_Inputs!G28","v":0},{"$f":"F_Inputs!H28","v":0},{"$f":"F_Inputs!I28","v":0},{"$f":"F_Inputs!J28","v":0}]
[]
[]
["TOTAL COST ALLOWANCE INCLUDING EX-ANTE COST SHARING - OVERRIDES"]
[]
[null,null,null,null,"Cost allowance override switch - Water",3,"1 = model calculated, 2 = Override, 3 = Off"]
[]
[null,null,null,null,"Water resources - total cost allowance including ex-ante cost sharing - Override",null,"£m"]
[]
[null,null,null,null,"Water network - total cost allowance including ex-ante cost sharing - Override",null,"£m"]
[]
[null,null,null,null,"Cost allowance override switch - Waste",3,"1 = model calculated, 2 = Override, 3 = Off"]
[]
[null,null,null,null,"Wastewater network - total cost allowance including ex-ante cost sharing - Override",null,"£m"]
[]
[]
["TOTEX PROFILING "]
[]
[null,"TOTEX PROFILING INPUTS"]
[]
[null,null,null,"Water Resources"]
[null,null,null,null,"Capex profile - WR",null,"%",{"$f":"SUM(I100:P100)","v":0.26212181627212522},null,0,{"$f":"F_Inputs!F29","v":6.0206900088681403E-2},{"$f":"F_Inputs!G29","v":6.7608348788400802E-2},{"$f":"F_Inputs!H29","v":5.6088066870347002E-2},{"$f":"F_Inputs!I29","v":4.3091090183772399E-2},{"$f":"F_Inputs!J29","v":3.51274103409236E-2},0]
[null,null,null,null,"Opex profile - WR",null,"%",{"$f":"SUM(I101:P101)","v":0.73787818372787506},null,0,{"$f":"F_Inputs!F30","v":0.14650553256909199},{"$f":"F_Inputs!G30","v":0.14732690783643601},{"$f":"F_Inputs!H30","v":0.14755123839056},{"$f":"F_Inputs!I30","v":0.14796354029450201},{"$f":"F_Inputs!J30","v":0.14853096463728499},0]
[]
[null,null,null,"Water Network"]
[null,null,null,null,"Capex profile - WN",null,"%",{"$f":"SUM(I104:P104)","v":0.49280133706178464},null,0,{"$f":"F_Inputs!F31","v":7.8906221312502897E-2},{"$f":"F_Inputs!G31","v":9.4446052042378797E-2},{"$f":"F_Inputs!H31","v":0.113327239902731},{"$f":"F_Inputs!I31","v":0.105547430139538},{"$f":"F_Inputs!J31","v":0.100574393664634},0]
[null,null,null,null,"Opex profile - WN",null,"%",{"$f":"SUM(I105:P105)","v":0.50719866293821403},null,0,{"$f":"F_Inputs!F32","v":0.102360417139246},{"$f":"F_Inputs!G32","v":0.102522050468316},{"$f":"F_Inputs!H32","v":0.101673548964828},{"$f":"F_Inputs!I32","v":0.100567031525459},{"$f":"F_Inputs!J32","v":0.10007561484036499},0]
[]
[null,null,null,"Wastewater Network"]
[null,null,null,null,"Capex profile - WWN",null,"%",{"$f":"SUM(I108:P108)","v":0.5377583005797697},null,0,{"$f":"F_Inputs!F33","v":0.12218989299973999},{"$f":"F_Inputs!G33","v":0.11901930778764799},{"$f":"F_Inputs!H33","v":0.102488078046585},{"$f":"F_Inputs!I33","v":0.103062966645073},{"$f":"F_Inputs!J33","v":9.0998055100723702E-2},0]
[null,null,null,null,"Opex profile - WNN",null,"%",{"$f":"SUM(I109:P109)","v":0.46224169942022914},null,0,{"$f":"F_Inputs!F34","v":9.4110612596142104E-2},{"$f":"F_Inputs!G34","v":9.3698069343610399E-2},{"$f":"F_Inputs!H34","v":9.3018765008116802E-2},{"$f":"F_Inputs!I34","v":9.1223978172373099E-2},{"$f":"F_Inputs!J34","v":9.0190274299986703E-2},0]
[]
[null,null,null,"Bioresources"]
[null,null,null,null,"Capex profile - BR",null,"%",{"$f":"SUM(I112:P112)","v":0.24860523039598692},null,0,{"$f":"F_Inputs!F35","v":4.8025725802973901E-2},{"$f":"F_Inputs!G35","v":4.9214914951125503E-2},{"$f":"F_Inputs!H35","v":5.2474157594849802E-2},{"$f":"F_Inputs!I35","v":5.0837664421742201E-2},{"$f":"F_Inputs!J35","v":4.8052767625295499E-2},0]
[null,null,null,null,"Opex profile - BR",null,"%",{"$f":"SUM(I113:P113)","v":0.75139476960401297},null,0,{"$f":"F_Inputs!F36","v":0.14895780284361901},{"$f":"F_Inputs!G36","v":0.150541517068634},{"$f":"F_Inputs!H36","v":0.15030187610037499},{"$f":"F_Inputs!I36","v":0.15045816368837001},{"$f":"F_Inputs!J36","v":0.15113540990301499},0]
[]
[null,null,null,"Dummy Control"]
[null,null,null,null,"Capex profile - DMMY",null,"%",{"$f":"SUM(I116:P116)","v":0},null,0,{"$f":"F_Inputs!F37","v":0},{"$f":"F_Inputs!G37","v":0},{"$f":"F_Inputs!H37","v":0},{"$f":"F_Inputs!I37","v":0},{"$f":"F_Inputs!J37","v":0},0]
[null,null,null,null,"Opex profile - DMMY",null,"%",{"$f":"SUM(I117:P117)","v":0},null,0,{"$f":"F_Inputs!F38","v":0},{"$f":"F_Inputs!G38","v":0},{"$f":"F_Inputs!H38","v":0},{"$f":"F_Inputs!I38","v":0},{"$f":"F_Inputs!J38","v":0},0]
[]
[]
[null,"TOTEX PROFILING OVERRIDES"]
[null,null,null,null,"Allowed capex and opex override switch - WR",1,"2 = Override, 1 = Calculated in opex/capex model"]
[null,null,null,null,"Override capex - water resources ",null,"£m"]
[null,null,null,null,"Override opex - water resources",null,"£m"]
[]
[null,null,null,null,"Allowed capex and opex override switch - WN",1,"2 = Override, 1 = Calculated in opex/capex model"]
[null,null,null,null,"Override capex - water network ",null,"£m"]
[null,null,null,null,"Override opex - water network ",null,"£m"]
[]
[null,null,null,null,"Allowed capex and opex override switch - WWN",1,"2 = Override, 1 = Calculated in opex/capex model"]
[null,null,null,null,"Override capex - Wastewater network ",null,"£m"]
[null,null,null,null,"Override opex - Wastewater network ",null,"£m"]
[]
[null,null,null,null,"Allowed capex and opex override switch - BIO",1,"2 = Override, 1 = Calculated in opex/capex model"]
[null,null,null,null,"Override capex - Bioresources ",null,"£m"]
[null,null,null,null,"Override opex - Bioresources ",null,"£m"]
[]
[null,null,null,null,"Allowed capex and opex override switch - DMMY",1,"2 = Override, 1 = Calculated in opex/capex model"]
[null,null,null,null,"Override capex - Dummy ",null,"£m"]
[null,null,null,null,"Override opex - Dummy ",null,"£m"]
[]
["COST SHARING CALCULATION INPUTS"]
[]
[null,null,"IAP Classification"]
[null,null,null,null,"Company IAP classification","Not Significant Scrutiny","text"]
[]
[null,null,null,null,"Cost sharing rates Fast track overrides",1,"1 = Fast Track company, 0 = Non SS/ST company"]
[null,null,null,null,"Fast track Cost sharing Override rates",0.5,"%"]
[]
[null,null,null,null,"Outperform"]
[]
[null,null,"Parameter - Ranges",null,"less than or equal 80%"]
[null,null,null,null,"   Parameter(s)  1",0.8,"%"]
[null,null,null,null,"greater than 80% and less than or equal to 90% "]
[null,null,null,null,"   Parameter 2",0.8,"%"]
[null,null,null,null,"   Parameter 3",0.9,"%"]
[null,null,null,null,"   Parameter 4"]
[null,null,null,null,"greater than 90% and less than or equal to 110% "]
[null,null,null,null,"   Parameter 4",0.9,"%"]
[null,null,null,null,"   Parameter 5",1.1000000000000001,"%"]
[null,null,null,null,"   Parameter 6"]
[null,null,null,null,"greater than 110% and less than or equal to 120% "]
[null,null,null,null,"   Parameter 7",1.1000000000000001,"%"]
[null,null,null,null,"   Parameter 8",1.2,"%"]
[null,null,null,null,"   Parameter 9"]
[null,null,null,null,"greater than120%"]
[null,null,null,null,"  Parameter 10",1.2,"%"]
[]
[null,null,null,null,"Underperform"]
[null,null,null,null,"less than or equal to a 100%"]
[null,null,null,null,"  Parameter 11",1,"%"]
[]
[]
[]
[null,null,null,null,"   Parameter(s)  1",0.65,"%"]
[null,null,"Parameter - Coefficients",null,"greater than 80% and less than or equal to 90% "]
[null,null,null,null,"   Parameter 2",0.65,"%"]
[null,null,null,null,"   Parameter 3",0.5,"%"]
[null,null,null,null,"   Parameter 4",0.8,"%"]
[null,null,null,null,"greater than 90% and less than or equal to 110% "]
[null,null,null,null,"   Parameter 4",0.6,"%"]
[null,null,null,null,"   Parameter 5",1,"%"]
[null,null,null,null,"   Parameter 6",0.9,"%"]
[null,null,null,null,"greater than 110% and less than or equal to 120% "]
[null,null,null,null,"   Parameter 7",0.4,"%"]
[null,null,null,null,"   Parameter 8",1,"%"]
[null,null,null,null,"   Parameter 9",1.1000000000000001,"%"]
[null,null,null,null,"greater than120%"]
[null,null,null,null,"  Parameter 10",0.3,"%"]
[]
[null,null,null,null,"Underperform"]
[null,null,null,null,"less than or equal to a 100%"]
[null,null,null,null,"  Parameter 11",0.5,"%"]
[]
[null,null,null,null,"Inputs for significant scrutiny cost sharing rates"]
[null,null,null,null,"Outperform"]
[null,null,null,null,"  Cost sharing rate",0.25,"%"]
[]
[null,null,null,null,"Underperform"]
[null,null,null,null,"  Cost Sharing rate",0.75,"%"]
[]
[]
[null,null,null,null,"The inputs below in lines 154 and 156 do not relate to the years/period in the time bar above."]
[null,null,null,null,"Business plan totex",null,"%",null,null,0.75,0.8,0.85,0.9,0.95,1,1.05,1.1000000000000001,1.1499999999999999,1.2,1.25]
[]
[null,null,null,null,"Ofwat totex baseline",null,"%",null,null,1,1,1,1,1,1,1,1,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NON CHANGEABLE INPUTS"]
[null,null,null,null,"Model Check Tolerance Level",1E-4,"tolerance"]
[null,"Model Tolerance"]
[null,null,null,null,"Model Track Tolerance Level",1E-3,"tolerance"]
[]
[]
[]
["END OF SHEET"]

{"sheet":"Time","index":4,"n_rows":104,"n_cols":20,"rows_kept":104,"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$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"},{"$f":"Time!Q$22","v":"2026-04-01"},{"$f":"Time!R$22","v":"2027-04-01"},{"$f":"Time!S$22","v":"2028-04-01"},{"$f":"Time!T$22","v":"2029-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"},{"$f":"Time!Q$23","v":"2027-03-31"},{"$f":"Time!R$23","v":"2028-03-31"},{"$f":"Time!S$23","v":"2029-03-31"},{"$f":"Time!T$23","v":"2030-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks",null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"},{"$f":"Time!Q$59","v":"Post-Fcst"},{"$f":"Time!R$59","v":"Post-Fcst"},{"$f":"Time!S$59","v":"Post-Fcst"},{"$f":"Time!T$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026},{"$f":"Time!Q$101","v":2027},{"$f":"Time!R$101","v":2028},{"$f":"Time!S$101","v":2029},{"$f":"Time!T$101","v":2030}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7},{"$f":"Time!Q$11","v":8},{"$f":"Time!R$11","v":9},{"$f":"Time!S$11","v":10},{"$f":"Time!T$11","v":11}]
[]
["MODEL PERIOD"]
[]
[null,"Model Column Counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I11 + 1","v":1},{"$f":" J11 + 1","v":2},3,4,5,6,7,{"$f":" P11 + 1","v":8},{"$f":" Q11 + 1","v":9},{"$f":" R11 + 1","v":10},{"$f":" S11 + 1","v":11}]
[null,null,null,null,"Model Column Total",{"$f":" MAX(J11:BU11)","v":11},"column"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column counter"},0,"counter",0,0,1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM(J15:BU15)","v":1},null,{"$f":" IF( J14 = 1, 1, 0)","v":1},0,0,0,0,0,0,{"$f":" IF( Q14 = 1, 1, 0)","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" InpOverride!E$10","v":"First date of time ruler"},{"$f":" InpOverride!F$10","v":"2019-04-01"},{"$f":" InpOverride!G$10","v":"date"}]
[null,null,null,null,"First model period BEG",{"$f":" DATE(YEAR(F17), MONTH(F17), 1)","v":"2019-04-01"},"month"]
[]
[null,null,null,null,{"$f":" E$18","v":"First model period BEG"},{"$f":" F$18","v":"2019-04-01"},{"$f":" G$18","v":"month"}]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model Period BEG",null,"date",null,null,{"$f":" IF( J21 = 1, $F20, I23 + 1)","v":"2019-04-01"},"2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01",{"$f":" IF( Q21 = 1, $F20, P23 + 1)","v":"2026-04-01"},{"$f":" IF( R21 = 1, $F20, Q23 + 1)","v":"2027-04-01"},{"$f":" IF( S21 = 1, $F20, R23 + 1)","v":"2028-04-01"},{"$f":" IF( T21 = 1, $F20, S23 + 1)","v":"2029-04-01"}]
[null,null,null,null,"Model Period END",null,"date",null,null,{"$f":" DATE(YEAR(J22), MONTH(J22) + 12, DAY(1) - 1)","v":"2020-03-31"},"2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31",{"$f":" DATE(YEAR(Q22), MONTH(Q22) + 12, DAY(1) - 1)","v":"2027-03-31"},"2028-03-31","2029-03-31","2030-03-31"]
[]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,"less",{"$f":" E$22","v":"Model Period BEG"},"00:00:00","date","00:00:00","00:00:00","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","2028-04-01","2029-04-01"]
[null,null,null,null,"Days in Model Period",null,"days",{"$f":" SUM(J27:BU27)","v":4018},null,{"$f":" J25 - J26 + 1","v":366},365,365,365,366,365,365,{"$f":" Q25 - Q26 + 1","v":365},366,365,365]
[]
[]
["PRE FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" InpOverride!E$12","v":"Last Pre Forecast Date"},{"$f":" InpOverride!F$12","v":"2020-03-31"},{"$f":" InpOverride!G$12","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,null,"Last Pre Forecast Flag",null,"flag",{"$f":" SUM(J34:BU34)","v":1},null,{"$f":" IF(J33 = $F32, 1, 0)","v":1},0,0,0,0,0,0,{"$f":" IF(Q33 = $F32, 1, 0)","v":0},0,0,0]
[null,null,null,null,"Pre Forecast Period Flag",null,"flag",{"$f":" SUM(J35:BU35)","v":1},null,{"$f":" IF($F32 >= J33, 1, 0)","v":1},{"$f":" IF($F32 >= K33, 1, 0)","v":0},0,0,0,0,0,{"$f":" IF($F32 >= Q33, 1, 0)","v":0},0,0,0]
[null,null,null,null,"Pre Forecast Period Total",{"$f":" SUM(J35:BU35)","v":1},"columns"]
[]
[null,null,null,null,{"$f":" InpOverride!E$14","v":"Acquisition date (midnight)"},{"$f":" InpOverride!F$14","v":"2020-03-31"},{"$f":" InpOverride!G$14","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,null,"Acquisition / initial balance date flag",null,"flag",{"$f":" SUM(J40:BU40)","v":1},null,{"$f":" IF(J39 = $F38, 1, 0)","v":1},0,0,0,0,0,0,{"$f":" IF(Q39 = $F38, 1, 0)","v":0},0,0,0]
[]
[]
["FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$34","v":"Last Pre Forecast Flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"1st Forecast Period Flag",null,"flag",{"$f":" SUM(J46:BU46)","v":1},null,{"$f":" I45","v":0},1,0,0,0,0,0,{"$f":" P45","v":0},{"$f":" Q45","v":0},{"$f":" R45","v":0},{"$f":" S45","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$16","v":"Last forecast date"},{"$f":"InpOverride!F$16","v":"2025-03-31"},{"$f":"InpOverride!G$16","v":"date"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,null,"Last Forecast Period Flag",null,"flag",{"$f":" SUM(J50:BU50)","v":1},null,{"$f":" IF(AND($F48 > I49, $F48 <= J49), 1, 0)","v":0},0,0,0,0,1,0,{"$f":" IF(AND($F48 > P49, $F48 <= Q49), 1, 0)","v":0},{"$f":" IF(AND($F48 > Q49, $F48 <= R49), 1, 0)","v":0},{"$f":" IF(AND($F48 > R49, $F48 <= S49), 1, 0)","v":0},{"$f":" IF(AND($F48 > S49, $F48 <= T49), 1, 0)","v":0}]
[]
[null,null,null,null,{"$f":" E$46","v":"1st Forecast Period Flag"},0,"flag",1,0,0,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$50","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,1,0,0,0,0,0]
[null,null,null,null,"Forecast Period Flag",null,"flag",{"$f":" SUM(J54:BU54)","v":5},null,{"$f":" J52 - I53 + I54","v":0},1,1,1,1,1,0,{"$f":" Q52 - P53 + P54","v":0},{"$f":" R52 - Q53 + Q54","v":0},{"$f":" S52 - R53 + R54","v":0},{"$f":" T52 - S53 + S54","v":0}]
[null,null,null,null,"Forecast Period Total ",{"$f":" SUM(J54:BU54)","v":5},"columns"]
[]
[null,null,null,null,{"$f":" E$35","v":"Pre Forecast Period Flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$54","v":"Forecast Period Flag"},0,"flag",5,0,0,1,1,1,1,1,0,0,0,0,0]
[null,null,null,null,"Pre Forecast vs Forecast",null,"flag",null,null,{"$f":" IF(J57 = 1, \"Pre Fcst\", IF(J58 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Pre Fcst"},"Forecast","Forecast","Forecast","Forecast","Forecast","Post-Fcst",{"$f":" IF(Q57 = 1, \"Pre Fcst\", IF(Q58 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Post-Fcst"},"Post-Fcst","Post-Fcst","Post-Fcst"]
[]
[]
["POST FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$50","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,1,0,0,0,0,0]
[null,null,null,null,"1st Post Last Forecast Period Flag",null,"flag",{"$f":" SUM(J65:BU65)","v":1},null,{"$f":" I64","v":0},0,0,0,0,0,1,{"$f":" P64","v":0},{"$f":" Q64","v":0},{"$f":" R64","v":0},{"$f":" S64","v":0}]
[]
[null,null,null,null,{"$f":" E$65","v":"1st Post Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"Post Forecast Period Flag",null,"flag",{"$f":" SUM(J68:BU68)","v":5},null,{"$f":" I68 + J67","v":0},0,0,0,0,0,1,{"$f":" P68 + Q67","v":1},{"$f":" Q68 + R67","v":1},{"$f":" R68 + S67","v":1},{"$f":" S68 + T67","v":1}]
[null,null,null,null,"Post Forecast Period Total",{"$f":" SUM(J68:BU68)","v":5},"columns"]
[]
[]
["MODELLING PERIOD CHECK"]
[]
[null,null,null,null,{"$f":" E$12","v":"Model Column Total"},{"$f":" F$12","v":11},{"$f":" G$12","v":"column"}]
[null,null,null,"less",{"$f":" E$36","v":"Pre Forecast Period Total"},{"$f":" F$36","v":1},{"$f":" G$36","v":"columns"}]
[null,null,null,"less",{"$f":" E$55","v":"Forecast Period Total "},{"$f":" F$55","v":5},{"$f":" G$55","v":"columns"}]
[null,null,null,"less",{"$f":" E$69","v":"Post Forecast Period Total"},{"$f":" F$69","v":5},{"$f":" G$69","v":"columns"}]
[null,null,null,null,"Modelling Period Check",{"$f":" IF(F74 - SUM(F75:F77) <> 0, 1, 0)","v":0},"check"]
[]
[]
["PARTIAL PERIOD FLAG (PPF)"]
[null,null,"This is an example of a part period flag. It is not currently used."]
[null,"Operation Partial Period Flag (PPF)"]
[null,null,null,null,{"$f":" E$18","v":"First model period BEG"},{"$f":" F$18","v":"2019-04-01"},{"$f":" G$18","v":"month"}]
[null,null,null,null,{"$f":"InpOverride!E$20","v":"Operation Finish Date (midnight)"},{"$f":"InpOverride!F$20","v":"2025-03-31"},{"$f":"InpOverride!G$20","v":"date"}]
[null,null,null,null,{"$f":" E$22","v":"Model Period BEG"},"00:00:00","date","00:00:00","00:00:00","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","2028-04-01","2029-04-01"]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,null,"Days in Operation Period",null,"days",{"$f":" SUM(J88:BU88)","v":2192},null,{"$f":" MAX(0, (MIN($F85, J87) - MAX($F84, J86) + 1))","v":366},365,365,365,366,365,0,{"$f":" MAX(0, (MIN($F85, Q87) - MAX($F84, Q86) + 1))","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" E$88","v":"Days in Operation Period"},0,"days",2192,0,366,365,365,365,366,365,0,0,0,0,0]
[null,null,null,null,{"$f":" E$27","v":"Days in Model Period"},0,"days",4018,0,366,365,365,365,366,365,365,365,366,365,365]
[null,null,null,null,"Operation Period PPF",null,"factor",{"$f":" SUM(J92:BU92)","v":6},null,{"$f":" J90 / J91","v":1},1,1,1,1,1,0,{"$f":" Q90 / Q91","v":0},0,0,0]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"InpOverride!E21","v":"First Modelling Column Financial Year Number"},{"$f":"InpOverride!F21","v":2020},{"$f":"InpOverride!G21","v":"year"}]
[null,null,null,null,{"$f":"InpOverride!E22","v":"Financial Year End Month Number"},{"$f":"InpOverride!F22","v":3},{"$f":"InpOverride!G22","v":"month #"}]
[null,null,null,null,{"$f":" E$23","v":"Model Period END"},"00:00:00","date","00:00:00","00:00:00","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","2029-03-31","2030-03-31"]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Financial Year Ending",null,"year #",null,null,{"$f":" IF(J100 = 1, $F97, IF(J99 > (DATE(I101, $F98 + 1, 1) - 1), I101 + 1, I101))","v":2020},{"$f":" IF(K100 = 1, $F97, IF(K99 > (DATE(J101, $F98 + 1, 1) - 1), J101 + 1, J101))","v":2021},2022,2023,2024,2025,2026,{"$f":" IF(Q100 = 1, $F97, IF(Q99 > (DATE(P101, $F98 + 1, 1) - 1), P101 + 1, P101))","v":2027},{"$f":" IF(R100 = 1, $F97, IF(R99 > (DATE(Q101, $F98 + 1, 1) - 1), Q101 + 1, Q101))","v":2028},{"$f":" IF(S100 = 1, $F97, IF(S99 > (DATE(R101, $F98 + 1, 1) - 1), R101 + 1, R101))","v":2029},{"$f":" IF(T100 = 1, $F97, IF(T99 > (DATE(S101, $F98 + 1, 1) - 1), S101 + 1, S101))","v":2030}]
[]
[]
["END OF SHEET"]

{"sheet":"Dashboards-->","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Dashboard - WR + WN","index":6,"n_rows":84,"n_cols":17,"rows_kept":84,"cut":false,"hidden":false,"merged":[[44,5,45,16],[67,5,68,16]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Dashboard - WR + WN"}]
[]
[]
[null,"Modeller's Inputs",null,null,null,null,null,"Key user inputs for incentive payment / penalty example"]
[null,"These inputs are set and should not be changed.",null,null,null,null,null,"These inputs allow the user to test totex over/under spend impacts."]
[]
[null,"Inputs for exceptional, fast track and slow track cost sharing rates",null,null,null,null,null,"Company's forecast totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F66+'Ex-ante allowances'!F13","v":915.25500000000011},"£m"]
[]
[null,"Outperform","Coefficient",null,null,"Range",null,"Ofwat baseline efficient totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F70+'Ex-ante allowances'!F17","v":924.84282126801952},"£m"]
[null,"less than or equal 80%"]
[null,"   Parameter(s)  1",{"$f":"InpOverride!F174","v":0.65},"%",null,{"$f":"InpOverride!F152","v":0.8},null,"Company outturn totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F74+'Ex-ante allowances'!F21","v":915.25500000000011},"£m"]
[null,"greater than 80% and less than or equal to 90% "]
[null,"   Parameter 2",{"$f":"InpOverride!F176","v":0.65},"%",null,{"$f":"InpOverride!F154","v":0.8},null,"Company IAP classification",null,null,null,null,null,{"$f":"InpOverride!F144","v":"Not Significant Scrutiny"},"Text"]
[null,"   Parameter 3",{"$f":"InpOverride!F177","v":0.5},"%",null,{"$f":"InpOverride!F155","v":0.9}]
[null,"   Parameter 4",{"$f":"InpOverride!F178","v":0.8},"%"]
[null,"greater than 90% and less than or equal to 110% "]
[null,"   Parameter 4",{"$f":"InpOverride!F180","v":0.6},"%",null,{"$f":"InpOverride!F158","v":0.9},null,null,null,null,null,null,null,{"$f":"N9*0.9","v":832.35853914121753}]
[null,"   Parameter 5",{"$f":"InpOverride!F181","v":1},"%",null,{"$f":"InpOverride!F159","v":1.1000000000000001}]
[null,"   Parameter 6",{"$f":"InpOverride!F182","v":0.9},"%"]
[null,"greater than 110% and less than or equal to 120% "]
[null,"   Parameter 7",{"$f":"InpOverride!F184","v":0.4},"%",null,{"$f":"InpOverride!F162","v":1.1000000000000001}]
[null,"   Parameter 8",{"$f":"InpOverride!F185","v":1},"%",null,{"$f":"InpOverride!F163","v":1.2}]
[null,"   Parameter 9",{"$f":"InpOverride!F186","v":1.1000000000000001},"%"]
[null,"greater than120%"]
[null,"  Parameter 10",{"$f":"InpOverride!F188","v":0.3},"%",null,{"$f":"InpOverride!F166","v":1.2}]
[]
[null,"Underperform"]
[null,"less than or equal to a 100%"]
[null,"  Parameter 11",{"$f":"InpOverride!F192","v":0.5},"%",null,{"$f":"InpOverride!F170","v":1}]
[]
[null,"Inputs for significant scrutiny cost sharing rates"]
[null,"Outperform"]
[]
[null,"  Cost sharing rate",{"$f":"InpOverride!F196","v":0.25},"%"]
[]
[null,"Underperform"]
[]
[null,"  Cost Sharing rate",{"$f":"InpOverride!F199","v":0.75},"%"]
[]
[]
[]
[null,"Cost sharing scheme for PR19 - final calibration for exceptional, fast track and slow track business plans"]
[]
[]
[null,null,null,null,null,"Table 1:  the incentive payment or penalty (as a % of ofwat totex baseline) for given cost sharing rates for different value of outturn expenditure for exceptional, fast track and slow track business plans. This is applicable to the water network plus, water resources and wastewater network plus price controls. "]
[]
[null,"Example",null,null,null,"Business plan totex %",{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,"Company forecast Totex",{"$f":"N7","v":915.25500000000011},"£m",null,"Ofwat totex baseline %",{"$f":"InpOverride!J$205","v":1},{"$f":"InpOverride!K$205","v":1},{"$f":"InpOverride!L$205","v":1},{"$f":"InpOverride!M$205","v":1},{"$f":"InpOverride!N$205","v":1},{"$f":"InpOverride!O$205","v":1},{"$f":"InpOverride!P$205","v":1},{"$f":"InpOverride!Q$205","v":1},{"$f":"InpOverride!R$205","v":1},{"$f":"InpOverride!S$205","v":1},{"$f":"InpOverride!T$205","v":1}]
[null,"Ofwat forecast of efficient Totex",{"$f":"N9","v":924.84282126801952},"£m",null,"Cost sharing rate (outperform)",{"$f":"'Dashboard Calcs'!J71","v":0.65},{"$f":"'Dashboard Calcs'!K71","v":0.65},{"$f":"'Dashboard Calcs'!L71","v":0.625},{"$f":"'Dashboard Calcs'!M71","v":0.60000000000000009},{"$f":"'Dashboard Calcs'!N71","v":0.55000000000000004},{"$f":"'Dashboard Calcs'!O71","v":0.5},{"$f":"'Dashboard Calcs'!P71","v":0.44999999999999996},{"$f":"'Dashboard Calcs'!Q71","v":0.39999999999999991},{"$f":"'Dashboard Calcs'!R71","v":0.3500000000000002},{"$f":"'Dashboard Calcs'!S71","v":0.30000000000000016},{"$f":"'Dashboard Calcs'!T71","v":0.3}]
[null,"Ratio company's forecast: Ofwat baseline",{"$f":"(C48/C49)","v":0.98963302623155591},"%",null,"Cost sharing rate (underperform)",{"$f":"'Dashboard Calcs'!J91","v":0.5},{"$f":"'Dashboard Calcs'!K91","v":0.5},{"$f":"'Dashboard Calcs'!L91","v":0.5},{"$f":"'Dashboard Calcs'!M91","v":0.5},{"$f":"'Dashboard Calcs'!N91","v":0.5},{"$f":"'Dashboard Calcs'!O91","v":0.5},{"$f":"'Dashboard Calcs'!P91","v":0.55000000000000004},{"$f":"'Dashboard Calcs'!Q91","v":0.60000000000000009},{"$f":"'Dashboard Calcs'!R91","v":0.6499999999999998},{"$f":"'Dashboard Calcs'!S91","v":0.69999999999999984},{"$f":"'Dashboard Calcs'!T91","v":0.7}]
[null,"Cost sharing rate for outperform",{"$f":"'Dashboard Calcs'!F169","v":0.5},"%",null,"Actual expenditure: baseline","Total incentive payment or penalty to company (payment as a % of ofwat totex baseline)"]
[null,"Cost sharing rate for underperform",{"$f":"'Dashboard Calcs'!F189","v":0.5},"%",null,{"$f":"InpOverride!K$203","v":0.8},{"$f":" IF($F52 < G$48, G$49, G$50) * (G$48 - $F52)","v":0.12999999999999998},{"$f":" IF($F52 < H$48, H$49, H$50) * (H$48 - $F52)","v":0.12999999999999998},0.12499999999999997,0.12,0.10999999999999999,9.9999999999999978E-2,8.9999999999999969E-2,7.999999999999996E-2,7.0000000000000021E-2,6.0000000000000019E-2,5.9999999999999984E-2]
[null,"Company outturn expenditure",{"$f":"N11","v":915.25500000000011},"£m",null,{"$f":"InpOverride!L$203","v":0.85},{"$f":" IF($F53 < G$48, G$49, G$50) * (G$48 - $F53)","v":9.7500000000000017E-2},9.7500000000000017E-2,9.3750000000000014E-2,9.0000000000000024E-2,8.2500000000000018E-2,7.5000000000000011E-2,6.7500000000000004E-2,0.06,5.250000000000004E-2,4.5000000000000033E-2,4.5000000000000005E-2]
[null,"Incentive payment (+) or penalty (-)",{"$f":"IF((C53<C49),C51,C52)*(C49-C53)","v":4.7939106340097055},"£m",null,{"$f":"InpOverride!M$203","v":0.9},6.4999999999999988E-2,6.4999999999999988E-2,6.2499999999999986E-2,0.06,5.4999999999999993E-2,4.9999999999999989E-2,4.4999999999999984E-2,3.999999999999998E-2,3.500000000000001E-2,3.0000000000000009E-2,2.9999999999999992E-2]
[null,"Ex-ante allowance above Ofwat forecast",{"$f":"C48+C54-C49","v":-4.7939106340096487},"£m",null,{"$f":"InpOverride!N$203","v":0.95},3.2500000000000029E-2,3.2500000000000029E-2,{"$f":" IF($F55 < I$48, I$49, I$50) * (I$48 - $F55)","v":3.1250000000000028E-2},3.000000000000003E-2,2.7500000000000028E-2,2.5000000000000022E-2,2.2500000000000017E-2,2.0000000000000014E-2,1.7500000000000026E-2,1.500000000000002E-2,1.5000000000000013E-2]
[null,null,null,null,null,{"$f":"InpOverride!O$203","v":1},0,0,{"$f":" IF($F56 < I$48, I$49, I$50) * (I$48 - $F56)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"InpOverride!P$203","v":1.05},-2.5000000000000022E-2,-2.5000000000000022E-2,{"$f":" IF($F57 < I$48, I$49, I$50) * (I$48 - $F57)","v":-2.5000000000000022E-2},-2.5000000000000022E-2,-2.5000000000000022E-2,-2.5000000000000022E-2,-2.7500000000000028E-2,-3.000000000000003E-2,-3.2500000000000022E-2,-3.5000000000000024E-2,-3.5000000000000031E-2]
[null,null,null,null,null,{"$f":"InpOverride!Q$203","v":1.1000000000000001},-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.5000000000000056E-2,-6.000000000000006E-2,-6.5000000000000044E-2,-7.0000000000000048E-2,-7.0000000000000062E-2]
[null,null,null,null,null,{"$f":"InpOverride!R$203","v":1.1499999999999999},-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-8.2499999999999962E-2,-8.9999999999999955E-2,-9.7499999999999906E-2,-0.10499999999999991,-0.10499999999999993]
[null,null,null,null,null,{"$f":"InpOverride!S$203","v":1.2},-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-0.10999999999999999,-0.12,-0.12999999999999992,-0.13999999999999993,-0.13999999999999996]
[null,null,null,null,null,"Note: values shaded in blue represent the maximum reward that can be obtained for a given actual expenditure: baseline ratio"]
[]
[]
[]
[null,"Cost sharing scheme for PR19 - final calibration for significant scrutiny business plans"]
[]
[]
[null,null,null,null,null,"Table 2:  the incentive payment or penalty (as a % of ofwat totex baseline) for given cost sharing rates for different value of outturn expenditure for significant scrutiny business plans. This is applicable to the water network plus, water resources and wastewater network plus price controls. "]
[]
[null,"Example",null,null,null,"Business plan totex",{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,"Company forecast Totex",{"$f":"N7","v":915.25500000000011},"£m",null,"Ofwat totex baseline",{"$f":"InpOverride!J$205","v":1},{"$f":"InpOverride!K$205","v":1},{"$f":"InpOverride!L$205","v":1},{"$f":"InpOverride!M$205","v":1},{"$f":"InpOverride!N$205","v":1},{"$f":"InpOverride!O$205","v":1},{"$f":"InpOverride!P$205","v":1},{"$f":"InpOverride!Q$205","v":1},{"$f":"InpOverride!R$205","v":1},{"$f":"InpOverride!S$205","v":1},{"$f":"InpOverride!T$205","v":1}]
[null,"Ofwat forecast of efficient Totex",{"$f":"N9","v":924.84282126801952},"£m",null,"Cost sharing rate (outperform)",{"$f":"$C34","v":0.25},{"$f":"$C34","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[null,"Ratio company's forecast: Ofwat baseline",{"$f":"(C71/C72)","v":0.98963302623155591},"%",null,"Cost sharing rate (underperform)",{"$f":"$C38","v":0.75},0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
[null,"Cost sharing rate for outperform",{"$f":"C34","v":0.25},"%",null,"Actual expenditure: baseline","Total incentive payment or penalty to company (payment as a % of ofwat totex baseline)"]
[null,"Cost sharing rate for underperform",{"$f":"C38","v":0.75},"%",null,{"$f":"InpOverride!K$203","v":0.8},{"$f":" IF($F75 < G$71, G$72, G$73) * (G$71 - $F75)","v":4.9999999999999989E-2},{"$f":" IF($F75 < H$71, H$72, H$73) * (H$71 - $F75)","v":4.9999999999999989E-2},4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2]
[null,"Company outturn expenditure",{"$f":"N11","v":915.25500000000011},"£m",null,{"$f":"InpOverride!L$203","v":0.85},{"$f":" IF($F76 < G$71, G$72, G$73) * (G$71 - $F76)","v":3.7500000000000006E-2},3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2]
[null,"Incentive payment (+) or penalty (-)",{"$f":"IF((C76<C72),C74,C75)*(C72-C76)","v":2.3969553170048528},"£m",null,{"$f":"InpOverride!M$203","v":0.9},2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2]
[null,"Ex-ante allowance above Ofwat forecast",{"$f":"C71+C77-C72","v":-7.1908659510145299},"£m",null,{"$f":"InpOverride!N$203","v":0.95},1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2]
[null,null,null,null,null,{"$f":"InpOverride!O$203","v":1},0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"C77-C54","v":-2.3969553170048528},null,null,{"$f":"InpOverride!P$203","v":1.05},-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2]
[null,null,null,null,null,{"$f":"InpOverride!Q$203","v":1.1000000000000001},-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2]
[null,null,null,null,null,{"$f":"InpOverride!R$203","v":1.1499999999999999},-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993]
[null,null,null,null,null,{"$f":"InpOverride!S$203","v":1.2},-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997]
[null,null,null,null,null,"Note: values shaded in blue represent the maximum reward that can be obtained for a given actual expenditure: baseline ratio"]

{"sheet":"Dashboard - WWN","index":7,"n_rows":84,"n_cols":17,"rows_kept":84,"cut":false,"hidden":false,"merged":[[44,5,45,16],[67,5,68,16]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Dashboard - WWN"}]
[]
[]
[null,"Modeller's Inputs",null,null,null,null,null,"Key user inputs for incentive payment / penalty example"]
[null,"These inputs are set and should not be changed.",null,null,null,null,null,"These inputs allow the user to test totex over/under spend impacts."]
[]
[null,"Inputs for exceptional, fast track and slow track cost sharing rates",null,null,null,null,null,"Company's forecast totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F123","v":882.09699999999998},"£m"]
[]
[null,"Outperform","Coefficient",null,null,"Range",null,"Ofwat baseline efficient totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F127","v":828.71740271570854},"£m"]
[null,"less than or equal 80%"]
[null,"   Parameter(s)  1",{"$f":"InpOverride!F174","v":0.65},"%",null,{"$f":"InpOverride!F152","v":0.8},null,"Company outturn totex of relevant control(s)",null,null,null,null,null,{"$f":"'Ex-ante allowances'!F131","v":882.09699999999998},"£m"]
[null,"greater than 80% and less than or equal to 90% "]
[null,"   Parameter 2",{"$f":"InpOverride!F176","v":0.65},"%",null,{"$f":"InpOverride!F154","v":0.8},null,"Company IAP classification",null,null,null,null,null,{"$f":"InpOverride!F144","v":"Not Significant Scrutiny"},"Text"]
[null,"   Parameter 3",{"$f":"InpOverride!F177","v":0.5},"%",null,{"$f":"InpOverride!F155","v":0.9}]
[null,"   Parameter 4",{"$f":"InpOverride!F178","v":0.8},"%"]
[null,"greater than 90% and less than or equal to 110% "]
[null,"   Parameter 4",{"$f":"InpOverride!F180","v":0.6},"%",null,{"$f":"InpOverride!F158","v":0.9}]
[null,"   Parameter 5",{"$f":"InpOverride!F181","v":1},"%",null,{"$f":"InpOverride!F159","v":1.1000000000000001}]
[null,"   Parameter 6",{"$f":"InpOverride!F182","v":0.9},"%"]
[null,"greater than 110% and less than or equal to 120% "]
[null,"   Parameter 7",{"$f":"InpOverride!F184","v":0.4},"%",null,{"$f":"InpOverride!F162","v":1.1000000000000001}]
[null,"   Parameter 8",{"$f":"InpOverride!F185","v":1},"%",null,{"$f":"InpOverride!F163","v":1.2}]
[null,"   Parameter 9",{"$f":"InpOverride!F186","v":1.1000000000000001},"%"]
[null,"greater than120%"]
[null,"  Parameter 10",{"$f":"InpOverride!F188","v":0.3},"%",null,{"$f":"InpOverride!F166","v":1.2}]
[]
[null,"Underperform"]
[null,"less than or equal to a 100%"]
[null,"  Parameter 11",{"$f":"InpOverride!F192","v":0.5},"%",null,{"$f":"InpOverride!F170","v":1}]
[]
[null,"Inputs for significant scrutiny cost sharing rates"]
[null,"Outperform"]
[]
[null,"  Cost sharing rate",{"$f":"InpOverride!F196","v":0.25},"%"]
[]
[null,"Underperform"]
[]
[null,"  Cost Sharing rate",{"$f":"InpOverride!F199","v":0.75},"%"]
[]
[]
[]
[null,"Cost sharing scheme for PR19 - final calibration for exceptional, fast track and slow track business plans"]
[]
[]
[null,null,null,null,null,"Table 1:  the incentive payment or penalty (as a % of ofwat totex baseline) for given cost sharing rates for different value of outturn expenditure for exceptional, fast track and slow track business plans. This is applicable to the water network plus, water resources and wastewater network plus price controls. "]
[]
[null,"Example",null,null,null,"Business plan totex %",{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,"Company forecast Totex",{"$f":"N7","v":882.09699999999998},"£m",null,"Ofwat totex baseline %",{"$f":"InpOverride!J$205","v":1},{"$f":"InpOverride!K$205","v":1},{"$f":"InpOverride!L$205","v":1},{"$f":"InpOverride!M$205","v":1},{"$f":"InpOverride!N$205","v":1},{"$f":"InpOverride!O$205","v":1},{"$f":"InpOverride!P$205","v":1},{"$f":"InpOverride!Q$205","v":1},{"$f":"InpOverride!R$205","v":1},{"$f":"InpOverride!S$205","v":1},{"$f":"InpOverride!T$205","v":1}]
[null,"Ofwat forecast of efficient Totex",{"$f":"N9","v":828.71740271570854},"£m",null,"Cost sharing rate (outperform)",{"$f":"'Dashboard Calcs'!J71","v":0.65},{"$f":"'Dashboard Calcs'!K71","v":0.65},{"$f":"'Dashboard Calcs'!L71","v":0.625},{"$f":"'Dashboard Calcs'!M71","v":0.60000000000000009},{"$f":"'Dashboard Calcs'!N71","v":0.55000000000000004},{"$f":"'Dashboard Calcs'!O71","v":0.5},{"$f":"'Dashboard Calcs'!P71","v":0.44999999999999996},{"$f":"'Dashboard Calcs'!Q71","v":0.39999999999999991},{"$f":"'Dashboard Calcs'!R71","v":0.3500000000000002},{"$f":"'Dashboard Calcs'!S71","v":0.30000000000000016},{"$f":"'Dashboard Calcs'!T71","v":0.3}]
[null,"Ratio company's forecast: Ofwat baseline",{"$f":"(C48/C49)","v":1.0644123040126421},"%",null,"Cost sharing rate (underperform)",{"$f":"'Dashboard Calcs'!J91","v":0.5},{"$f":"'Dashboard Calcs'!K91","v":0.5},{"$f":"'Dashboard Calcs'!L91","v":0.5},{"$f":"'Dashboard Calcs'!M91","v":0.5},{"$f":"'Dashboard Calcs'!N91","v":0.5},{"$f":"'Dashboard Calcs'!O91","v":0.5},{"$f":"'Dashboard Calcs'!P91","v":0.55000000000000004},{"$f":"'Dashboard Calcs'!Q91","v":0.60000000000000009},{"$f":"'Dashboard Calcs'!R91","v":0.6499999999999998},{"$f":"'Dashboard Calcs'!S91","v":0.69999999999999984},{"$f":"'Dashboard Calcs'!T91","v":0.7}]
[null,"Cost sharing rate for outperform",{"$f":"'Dashboard Calcs'!F262","v":0.5},"%",null,"Actual expenditure: baseline","Total incentive payment or penalty to company (payment as a % of ofwat totex baseline)"]
[null,"Cost sharing rate for underperform",{"$f":"'Dashboard Calcs'!F282","v":0.5},"%",null,{"$f":"InpOverride!K$203","v":0.8},{"$f":" IF($F52 < G$48, G$49, G$50) * (G$48 - $F52)","v":0.12999999999999998},{"$f":" IF($F52 < H$48, H$49, H$50) * (H$48 - $F52)","v":0.12999999999999998},0.12499999999999997,0.12,0.10999999999999999,9.9999999999999978E-2,8.9999999999999969E-2,7.999999999999996E-2,7.0000000000000021E-2,6.0000000000000019E-2,5.9999999999999984E-2]
[null,"Company outturn expenditure",{"$f":"N11","v":882.09699999999998},"£m",null,{"$f":"InpOverride!L$203","v":0.85},{"$f":" IF($F53 < G$48, G$49, G$50) * (G$48 - $F53)","v":9.7500000000000017E-2},9.7500000000000017E-2,9.3750000000000014E-2,9.0000000000000024E-2,8.2500000000000018E-2,7.5000000000000011E-2,6.7500000000000004E-2,0.06,5.250000000000004E-2,4.5000000000000033E-2,4.5000000000000005E-2]
[null,"Incentive payment (+) or penalty (-)",{"$f":"IF((C53<C49),C51,C52)*(C49-C53)","v":-26.689798642145718},"£m",null,{"$f":"InpOverride!M$203","v":0.9},6.4999999999999988E-2,6.4999999999999988E-2,6.2499999999999986E-2,0.06,5.4999999999999993E-2,4.9999999999999989E-2,4.4999999999999984E-2,3.999999999999998E-2,3.500000000000001E-2,3.0000000000000009E-2,2.9999999999999992E-2]
[null,"Ex-ante allowance above Ofwat forecast",{"$f":"C48+C54-C49","v":26.689798642145774},"£m",null,{"$f":"InpOverride!N$203","v":0.95},3.2500000000000029E-2,3.2500000000000029E-2,3.1250000000000028E-2,3.000000000000003E-2,2.7500000000000028E-2,2.5000000000000022E-2,2.2500000000000017E-2,2.0000000000000014E-2,1.7500000000000026E-2,1.500000000000002E-2,1.5000000000000013E-2]
[null,null,null,null,null,{"$f":"InpOverride!O$203","v":1},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"InpOverride!P$203","v":1.05},-2.5000000000000022E-2,-2.5000000000000022E-2,-2.5000000000000022E-2,-2.5000000000000022E-2,-2.5000000000000022E-2,-2.5000000000000022E-2,-2.7500000000000028E-2,-3.000000000000003E-2,-3.2500000000000022E-2,-3.5000000000000024E-2,-3.5000000000000031E-2]
[null,null,null,null,null,{"$f":"InpOverride!Q$203","v":1.1000000000000001},-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.0000000000000044E-2,-5.5000000000000056E-2,-6.000000000000006E-2,-6.5000000000000044E-2,-7.0000000000000048E-2,-7.0000000000000062E-2]
[null,null,null,null,null,{"$f":"InpOverride!R$203","v":1.1499999999999999},-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-7.4999999999999956E-2,-8.2499999999999962E-2,-8.9999999999999955E-2,-9.7499999999999906E-2,-0.10499999999999991,-0.10499999999999993]
[null,null,null,null,null,{"$f":"InpOverride!S$203","v":1.2},-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-9.9999999999999978E-2,-0.10999999999999999,-0.12,-0.12999999999999992,-0.13999999999999993,-0.13999999999999996]
[null,null,null,null,null,"Note: values shaded in blue represent the maximum reward that can be obtained for a given actual expenditure: baseline ratio"]
[]
[]
[]
[null,"Cost sharing scheme for PR19 - final calibration for significant scrutiny business plans"]
[]
[]
[null,null,null,null,null,"Table 2:  the incentive payment or penalty (as a % of ofwat totex baseline) for given cost sharing rates for different value of outturn expenditure for significant scrutiny business plans. This is applicable to the water network plus, water resources and wastewater network plus price controls. "]
[]
[null,"Example",null,null,null,"Business plan totex",{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,"Company forecast Totex",{"$f":"N7","v":882.09699999999998},"£m",null,"Ofwat totex baseline",{"$f":"InpOverride!J$205","v":1},{"$f":"InpOverride!K$205","v":1},{"$f":"InpOverride!L$205","v":1},{"$f":"InpOverride!M$205","v":1},{"$f":"InpOverride!N$205","v":1},{"$f":"InpOverride!O$205","v":1},{"$f":"InpOverride!P$205","v":1},{"$f":"InpOverride!Q$205","v":1},{"$f":"InpOverride!R$205","v":1},{"$f":"InpOverride!S$205","v":1},{"$f":"InpOverride!T$205","v":1}]
[null,"Ofwat forecast of efficient Totex",{"$f":"N9","v":828.71740271570854},"£m",null,"Cost sharing rate (outperform)",{"$f":"$C34","v":0.25},{"$f":"$C34","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[null,"Ratio company's forecast: Ofwat baseline",{"$f":"(C71/C72)","v":1.0644123040126421},"%",null,"Cost sharing rate (underperform)",{"$f":"$C38","v":0.75},0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]
[null,"Cost sharing rate for outperform",{"$f":"C34","v":0.25},"%",null,"Actual expenditure: baseline","Total incentive payment or penalty to company (payment as a % of ofwat totex baseline)"]
[null,"Cost sharing rate for underperform",{"$f":"C38","v":0.75},"%",null,{"$f":"InpOverride!K$203","v":0.8},{"$f":" IF($F75 < G$71, G$72, G$73) * (G$71 - $F75)","v":4.9999999999999989E-2},{"$f":" IF($F75 < H$71, H$72, H$73) * (H$71 - $F75)","v":4.9999999999999989E-2},4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2,4.9999999999999989E-2]
[null,"Company outturn expenditure",{"$f":"N11","v":882.09699999999998},"£m",null,{"$f":"InpOverride!L$203","v":0.85},{"$f":" IF($F76 < G$71, G$72, G$73) * (G$71 - $F76)","v":3.7500000000000006E-2},3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2,3.7500000000000006E-2]
[null,"Incentive payment (+) or penalty (-)",{"$f":"IF((C76<C72),C74,C75)*(C72-C76)","v":-40.034697963218576},"£m",null,{"$f":"InpOverride!M$203","v":0.9},2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2,2.4999999999999994E-2]
[null,"Ex-ante allowance above Ofwat forecast",{"$f":"C71+C77-C72","v":13.34489932107283},"£m",null,{"$f":"InpOverride!N$203","v":0.95},1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2,1.2500000000000011E-2]
[null,null,null,null,null,{"$f":"InpOverride!O$203","v":1},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"InpOverride!P$203","v":1.05},-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2,-3.7500000000000033E-2]
[null,null,null,null,null,{"$f":"InpOverride!Q$203","v":1.1000000000000001},-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2,-7.5000000000000067E-2]
[null,null,null,null,null,{"$f":"InpOverride!R$203","v":1.1499999999999999},-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993,-0.11249999999999993]
[null,null,null,null,null,{"$f":"InpOverride!S$203","v":1.2},-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997,-0.14999999999999997]
[null,null,null,null,null,"Note: values shaded in blue represent the maximum reward that can be obtained for a given actual expenditure: baseline ratio"]

{"sheet":"Calc-->","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Dashboard Calcs","index":9,"n_rows":284,"n_cols":20,"rows_kept":284,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Dashboard Calcs"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks"]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks"]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total"]
[]
["CALCULATION"]
[]
[null,"Outperformance flags"]
[]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$152 & \" - Range\"","v":"   Parameter(s)  1 - Range"},{"$f":"InpOverride!F$152","v":0.8},{"$f":"InpOverride!G$152","v":"%"}]
[null,null,null,null,"Outperformance flag: less than or equal 80%",null,"Flag",null,null,{"$f":" IF(J12<=$F13,1,0)","v":1},1,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$154 & \" - Range\"","v":"   Parameter 2 - Range"},{"$f":"InpOverride!F$154","v":0.8},{"$f":"InpOverride!G$154","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$155 & \" - Range\"","v":"   Parameter 3 - Range"},{"$f":"InpOverride!F$155","v":0.9},{"$f":"InpOverride!G$155","v":"%"}]
[null,null,null,null,"Outperformance flag: greater than 80% and less than or equal to 90% ",null,"Flag",null,null,{"$f":" IF(AND(J16>$F17,J16<=$F18),1,0)","v":0},0,1,1,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$158 & \" - Range\"","v":"   Parameter 4 - Range"},{"$f":"InpOverride!F$158","v":0.9},{"$f":"InpOverride!G$158","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$159 & \" - Range\"","v":"   Parameter 5 - Range"},{"$f":"InpOverride!F$159","v":1.1000000000000001},{"$f":"InpOverride!G$159","v":"%"}]
[null,null,null,null,"Outperformance flag: greater than 90% and less than or equal to 110% ",null,"Flag",null,null,{"$f":" IF(AND(J21>$F22,J21<=$F23),1,0)","v":0},0,0,0,1,1,1,1,0,0,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$162 & \" - Range\"","v":"   Parameter 7 - Range"},{"$f":"InpOverride!F$162","v":1.1000000000000001},{"$f":"InpOverride!G$162","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$163 & \" - Range\"","v":"   Parameter 8 - Range"},{"$f":"InpOverride!F$163","v":1.2},{"$f":"InpOverride!G$163","v":"%"}]
[null,null,null,null,"Outperformance flag: greater than 110% and less than or equal to 120% ",null,"Flag",null,null,{"$f":" IF(AND(J26>$F27,J26<=$F28),1,0)","v":0},0,0,0,0,0,0,0,1,1,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$166 & \" - Range\"","v":"  Parameter 10 - Range"},{"$f":"InpOverride!F$166","v":1.2},{"$f":"InpOverride!G$166","v":"%"}]
[null,null,null,null,"Outperformance flag: greater than120%",null,"Flag",null,null,{"$f":"IF(J31>$F32,1,0)","v":0},0,0,0,0,0,0,0,0,0,1]
[]
[null,"Outperformance percentages"]
[]
[null,null,null,null,{"$f":" E$14","v":"Outperformance flag: less than or equal 80%"},0,"Flag",0,0,1,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InpOverride!E$174 &\" - Coefficient\"","v":"   Parameter(s)  1 - Coefficient"},{"$f":"InpOverride!F$174","v":0.65},{"$f":"InpOverride!G$174","v":"%"}]
[null,null,null,null,"Outperformance: less than or equal 80%",null,null,null,null,{"$f":"J37 * $F38","v":0.65},0.65,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$19","v":"Outperformance flag: greater than 80% and less than or equal to 90% "},0,"Flag",0,0,0,0,1,1,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InpOverride!E$176 &\" - Coefficient\"","v":"   Parameter 2 - Coefficient"},{"$f":"InpOverride!F$176","v":0.65},{"$f":"InpOverride!G$176","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$177 &\" - Coefficient\"","v":"   Parameter 3 - Coefficient"},{"$f":"InpOverride!F$177","v":0.5},{"$f":"InpOverride!G$177","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$178 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$178","v":0.8},{"$f":"InpOverride!G$178","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,"Outperformance: greater than 80% and less than or equal to 90% ",null,null,null,null,{"$f":" J41 * ($F42 - $F43 * (J45 - $F44))","v":0},0,0.625,0.60000000000000009,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$24","v":"Outperformance flag: greater than 90% and less than or equal to 110% "},0,"Flag",0,0,0,0,0,0,1,1,1,1,0,0,0]
[null,null,null,null,{"$f":" InpOverride!E$180 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$180","v":0.6},{"$f":"InpOverride!G$180","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$181 &\" - Coefficient\"","v":"   Parameter 5 - Coefficient"},{"$f":"InpOverride!F$181","v":1},{"$f":"InpOverride!G$181","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$182 &\" - Coefficient\"","v":"   Parameter 6 - Coefficient"},{"$f":"InpOverride!F$182","v":0.9},{"$f":"InpOverride!G$182","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,"Outperformance: greater than 90% and less than or equal to 110% ",null,null,null,null,{"$f":" J48 * ($F49 - $F50 * (J52 - $F51))","v":0},0,0,0,0.55000000000000004,0.5,0.44999999999999996,0.39999999999999991,0,0,0]
[]
[null,null,null,null,{"$f":" E$29","v":"Outperformance flag: greater than 110% and less than or equal to 120% "},0,"Flag",0,0,0,0,0,0,0,0,0,0,1,1,0]
[null,null,null,null,{"$f":" InpOverride!E$184 &\" - Coefficient\"","v":"   Parameter 7 - Coefficient"},{"$f":"InpOverride!F$184","v":0.4},{"$f":"InpOverride!G$184","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$185 &\" - Coefficient\"","v":"   Parameter 8 - Coefficient"},{"$f":"InpOverride!F$185","v":1},{"$f":"InpOverride!G$185","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$186 &\" - Coefficient\"","v":"   Parameter 9 - Coefficient"},{"$f":"InpOverride!F$186","v":1.1000000000000001},{"$f":"InpOverride!G$186","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,"Outperformance: greater than 110% and less than or equal to 120% ",null,null,null,null,{"$f":" J55 * ($F56 - $F57 * (J59 - $F58))","v":0},0,0,0,0,0,0,0,{"$f":" R55 * ($F56 - $F57 * (R59 - $F58))","v":0.3500000000000002},{"$f":" S55 * ($F56 - $F57 * (S59 - $F58))","v":0.30000000000000016},0]
[]
[null,null,null,null,{"$f":" E$33","v":"Outperformance flag: greater than120%"},0,"Flag",0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,null,null,{"$f":" InpOverride!E$188 &\" - Coefficient\"","v":"  Parameter 10 - Coefficient"},{"$f":"InpOverride!F$188","v":0.3},{"$f":"InpOverride!G$188","v":"%"}]
[null,null,null,null,"Outperformance: greater than120%",null,null,null,null,{"$f":"J62*$F63","v":0},0,0,0,0,0,0,0,0,0,0.3]
[]
[null,null,null,null,{"$f":" E$39","v":"Outperformance: less than or equal 80%"},0,0,0,0,0.65,0.65,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$46","v":"Outperformance: greater than 80% and less than or equal to 90% "},0,0,0,0,0,0,0.625,0.60000000000000009,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$53","v":"Outperformance: greater than 90% and less than or equal to 110% "},0,0,0,0,0,0,0,0,0.55000000000000004,0.5,0.44999999999999996,0.39999999999999991,0,0,0]
[null,null,null,null,{"$f":" E$60","v":"Outperformance: greater than 110% and less than or equal to 120% "},0,0,0,0,0,0,0,0,0,0,0,0,0.3500000000000002,0.30000000000000016,0]
[null,null,null,null,{"$f":" E$64","v":"Outperformance: greater than120%"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.3]
[null,null,null,null,"Outperformance summary sharing rates",null,null,null,null,{"$f":"SUM(J66:J70)","v":0.65},0.65,0.625,0.60000000000000009,0.55000000000000004,0.5,0.44999999999999996,0.39999999999999991,0.3500000000000002,0.30000000000000016,0.3]
[]
[null,"Underperformance calculations"]
[null,null,null,null,{"$f":"InpOverride!E$203","v":"Business plan totex"},{"$f":"InpOverride!F$203","v":0},{"$f":"InpOverride!G$203","v":"%"},{"$f":"InpOverride!H$203","v":0},{"$f":"InpOverride!I$203","v":0},{"$f":"InpOverride!J$203","v":0.75},{"$f":"InpOverride!K$203","v":0.8},{"$f":"InpOverride!L$203","v":0.85},{"$f":"InpOverride!M$203","v":0.9},{"$f":"InpOverride!N$203","v":0.95},{"$f":"InpOverride!O$203","v":1},{"$f":"InpOverride!P$203","v":1.05},{"$f":"InpOverride!Q$203","v":1.1000000000000001},{"$f":"InpOverride!R$203","v":1.1499999999999999},{"$f":"InpOverride!S$203","v":1.2},{"$f":"InpOverride!T$203","v":1.25}]
[null,null,null,null,{"$f":"InpOverride!E$170 & \" - Range\"","v":"  Parameter 11 - Range"},{"$f":"InpOverride!F$170","v":1},{"$f":"InpOverride!G$170","v":"%"}]
[null,null,null,null,"Underperformance: less than or equal to 100% flag",null,null,null,null,{"$f":"IF(J74<=$F75,1,0)","v":1},1,1,1,1,1,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$76","v":"Underperformance: less than or equal to 100% flag"},0,0,0,0,1,1,1,1,1,1,0,0,0,0,0]
[null,null,null,null,{"$f":" InpOverride!E$192 &\" - Coefficient\"","v":"  Parameter 11 - Coefficient"},{"$f":"InpOverride!F$192","v":0.5},{"$f":"InpOverride!G$192","v":"%"}]
[null,null,null,null,"Underperformance: totex sharing rate less than to equal to 100%",null,null,null,null,{"$f":" J78 * $F79","v":0.5},0.5,0.5,0.5,0.5,0.5,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$76","v":"Underperformance: less than or equal to 100% flag"},0,0,0,0,1,1,1,1,1,1,0,0,0,0,0]
[null,null,null,null,"Underperformance: greater than a 100% flag",null,null,null,null,{"$f":" 1 - J82","v":0},0,0,0,0,0,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" E$83","v":"Underperformance: greater than a 100% flag"},0,0,0,0,0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$71","v":"Outperformance summary sharing rates"},0,0,0,0,0.65,0.65,0.625,0.60000000000000009,0.55000000000000004,0.5,0.44999999999999996,0.39999999999999991,0.3500000000000002,0.30000000000000016,0.3]
[null,null,null,null,"Underperformance: totex sharing rate greater than a 100%",null,null,null,null,{"$f":" J85 * (1 - J86)","v":0},0,0,0,0,0,0.55000000000000004,0.60000000000000009,0.6499999999999998,0.69999999999999984,0.7]
[]
[null,null,null,null,{"$f":" E$80","v":"Underperformance: totex sharing rate less than to equal to 100%"},0,0,0,0,0.5,0.5,0.5,0.5,0.5,0.5,0,0,0,0,0]
[null,null,null,null,{"$f":" E$87","v":"Underperformance: totex sharing rate greater than a 100%"},0,0,0,0,0,0,0,0,0,0,0.55000000000000004,0.60000000000000009,0.6499999999999998,0.69999999999999984,0.7]
[null,null,null,null,"Underperformance summary sharing rates",null,null,null,null,{"$f":"SUM(J89:J90)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.55000000000000004,0.60000000000000009,0.6499999999999998,0.69999999999999984,0.7]
[]
["WATER RESOURCES AND WATER NETWORK PLUS"]
[]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F$70","v":850.89037104923398},{"$f":"'Ex-ante allowances'!G$70","v":"£m"}]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F$17","v":73.952450218785501},{"$f":"'Ex-ante allowances'!G$17","v":"£m"}]
[null,null,null,null,"Water - Ofwat Baseline Total Gross Totex - Real",{"$f":"SUM(F95:F96)","v":924.84282126801952},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$50","v":"Total gross capital expenditure - Water"},{"$f":"InpOverride!F$50","v":915.25499999999988},{"$f":"InpOverride!G$50","v":0}]
[null,null,null,null,{"$f":" E$97","v":"Water - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$97","v":924.84282126801952},"£m"]
[null,null,null,null,"Example: totex ratio company's forecast: Ofwat baseline",{"$f":"F99/F100","v":0.98963302623155569},"%"]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},{"$f":"G$101","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$152 & \" - Range\"","v":"   Parameter(s)  1 - Range"},{"$f":"InpOverride!F$152","v":0.8},{"$f":"InpOverride!G$152","v":"%"}]
[null,null,null,null,"Example Outperformance flag: less than or equal 80%",{"$f":" IF(F103<=$F104,1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,{"$f":"InpOverride!E$154 & \" - Range\"","v":"   Parameter 2 - Range"},{"$f":"InpOverride!F$154","v":0.8},{"$f":"InpOverride!G$154","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$155 & \" - Range\"","v":"   Parameter 3 - Range"},{"$f":"InpOverride!F$155","v":0.9},{"$f":"InpOverride!G$155","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 80% and less than or equal to 90% ",{"$f":" IF(AND(F107>$F108,F107<=$F109),1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,{"$f":"InpOverride!E$158 & \" - Range\"","v":"   Parameter 4 - Range"},{"$f":"InpOverride!F$158","v":0.9},{"$f":"InpOverride!G$158","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$159 & \" - Range\"","v":"   Parameter 5 - Range"},{"$f":"InpOverride!F$159","v":1.1000000000000001},{"$f":"InpOverride!G$159","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 90% and less than or equal to 110% ",{"$f":" IF(AND(F112>$F113,F112<=$F114),1,0)","v":1},"Flag"]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,{"$f":"InpOverride!E$162 & \" - Range\"","v":"   Parameter 7 - Range"},{"$f":"InpOverride!F$162","v":1.1000000000000001},{"$f":"InpOverride!G$162","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$163 & \" - Range\"","v":"   Parameter 8 - Range"},{"$f":"InpOverride!F$163","v":1.2},{"$f":"InpOverride!G$163","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 110% and less than or equal to 120% ",{"$f":" IF(AND(F117>$F118,F117<=$F119),1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,{"$f":"InpOverride!E$166 & \" - Range\"","v":"  Parameter 10 - Range"},{"$f":"InpOverride!F$166","v":1.2},{"$f":"InpOverride!G$166","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than120%",{"$f":"IF(F122>$F123,1,0)","v":0},"Flag"]
[]
[]
[null,null,null,null,{"$f":"E$105","v":"Example Outperformance flag: less than or equal 80%"},{"$f":"F$105","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$174 &\" - Coefficient\"","v":"   Parameter(s)  1 - Coefficient"},{"$f":"InpOverride!F$174","v":0.65},{"$f":"InpOverride!G$174","v":"%"}]
[null,null,null,null,"Example outperformance: less than or equal 80%",{"$f":"F127 * $F128","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$110","v":"Example Outperformance flag: greater than 80% and less than or equal to 90% "},{"$f":"F$110","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$176 &\" - Coefficient\"","v":"   Parameter 2 - Coefficient"},{"$f":"InpOverride!F$176","v":0.65},{"$f":"InpOverride!G$176","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$177 &\" - Coefficient\"","v":"   Parameter 3 - Coefficient"},{"$f":"InpOverride!F$177","v":0.5},{"$f":"InpOverride!G$177","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$178 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$178","v":0.8},{"$f":"InpOverride!G$178","v":"%"}]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,"Example outperformance: greater than 80% and less than or equal to 90% ",{"$f":" F131 * ($F132 - $F133 * (F135 - $F134))","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$115","v":"Example Outperformance flag: greater than 90% and less than or equal to 110% "},{"$f":"F$115","v":1},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$180 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$180","v":0.6},{"$f":"InpOverride!G$180","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$181 &\" - Coefficient\"","v":"   Parameter 5 - Coefficient"},{"$f":"InpOverride!F$181","v":1},{"$f":"InpOverride!G$181","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$182 &\" - Coefficient\"","v":"   Parameter 6 - Coefficient"},{"$f":"InpOverride!F$182","v":0.9},{"$f":"InpOverride!G$182","v":"%"}]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,"Example outperformance: greater than 90% and less than or equal to 110% ",{"$f":" F138 * ($F139 - $F140 * (F142 - $F141))","v":0.51036697376844431},"%"]
[]
[null,null,null,null,{"$f":"E$120","v":"Example Outperformance flag: greater than 110% and less than or equal to 120% "},{"$f":"F$120","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$184 &\" - Coefficient\"","v":"   Parameter 7 - Coefficient"},{"$f":"InpOverride!F$184","v":0.4},{"$f":"InpOverride!G$184","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$185 &\" - Coefficient\"","v":"   Parameter 8 - Coefficient"},{"$f":"InpOverride!F$185","v":1},{"$f":"InpOverride!G$185","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$186 &\" - Coefficient\"","v":"   Parameter 9 - Coefficient"},{"$f":"InpOverride!F$186","v":1.1000000000000001},{"$f":"InpOverride!G$186","v":"%"}]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},{"$f":"G$101","v":"%"}]
[null,null,null,null,"Example outperformance: greater than 110% and less than or equal to 120% ",{"$f":" F145 * ($F146 - $F147 * (F149 - $F148))","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$124","v":"Example Outperformance flag: greater than120%"},{"$f":"F$124","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$188 &\" - Coefficient\"","v":"  Parameter 10 - Coefficient"},{"$f":"InpOverride!F$188","v":0.3},{"$f":"InpOverride!G$188","v":"%"}]
[null,null,null,null,"Example outperformance: greater than120%",{"$f":"F152*$F153","v":0},"%"]
[]
[]
[null,null,null,null,{"$f":"E$129","v":"Example outperformance: less than or equal 80%"},{"$f":"F$129","v":0},"%"]
[null,null,null,null,{"$f":"E$136","v":"Example outperformance: greater than 80% and less than or equal to 90% "},{"$f":"F$136","v":0},"%"]
[null,null,null,null,{"$f":"E$143","v":"Example outperformance: greater than 90% and less than or equal to 110% "},{"$f":"F$143","v":0.51036697376844431},"%"]
[null,null,null,null,{"$f":"E$150","v":"Example outperformance: greater than 110% and less than or equal to 120% "},{"$f":"F$150","v":0},"%"]
[null,null,null,null,{"$f":"E$154","v":"Example outperformance: greater than120%"},{"$f":"F$154","v":0},"%"]
[null,null,null,null,"Actual outperformance cost sharing rate for example",{"$f":"SUM(F157:F161)","v":0.51036697376844431},"%"]
[]
[null,null,null,null,{"$f":"InpOverride!E146","v":"Cost sharing rates Fast track overrides"},{"$f":"InpOverride!F146","v":1},{"$f":"InpOverride!G146","v":"1 = Fast Track company, 0 = Non SS/ST company"}]
[null,null,null,null,{"$f":"InpOverride!E147","v":"Fast track Cost sharing Override rates"},{"$f":"InpOverride!F147","v":0.5},{"$f":"InpOverride!G147","v":"%"}]
[null,null,null,null,{"$f":"E162","v":"Actual outperformance cost sharing rate for example"},{"$f":"F162","v":0.51036697376844431},{"$f":"G162","v":"%"}]
[null,null,null,null,"Outperformance cost sharing rate",{"$f":" IF(F164 = 1, F165, F166)","v":0.5},"%"]
[]
[null,null,null,null,{"$f":"E167","v":"Outperformance cost sharing rate"},{"$f":"F167","v":0.5},{"$f":"G167","v":"%"}]
[]
[]
[null,null,null,null,{"$f":"E$101","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$101","v":0.98963302623155569},"%"]
[null,null,null,null,{"$f":"InpOverride!E$170 & \" - Range\"","v":"  Parameter 11 - Range"},{"$f":"InpOverride!F$170","v":1},{"$f":"InpOverride!G$170","v":"%"}]
[null,null,null,null,"Example underperformance: less than or equal to 100% flag",{"$f":"IF(F172<=$F173,1,0)","v":1},"Flag"]
[]
[null,null,null,null,{"$f":"E$174","v":"Example underperformance: less than or equal to 100% flag"},{"$f":"F$174","v":1},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$192 &\" - Coefficient\"","v":"  Parameter 11 - Coefficient"},{"$f":"InpOverride!F$192","v":0.5},{"$f":"InpOverride!G$192","v":"%"}]
[null,null,null,null,"Example underperformance: totex sharing rate less than to equal to 100%",{"$f":" F176 * $F177","v":0.5},"%"]
[]
[null,null,null,null,{"$f":"E$176","v":"Example underperformance: less than or equal to 100% flag"},{"$f":"F$176","v":1},"Flag"]
[null,null,null,null,"Example underperformance: greater than a 100% flag",{"$f":" 1 - F180","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$181","v":"Example underperformance: greater than a 100% flag"},{"$f":"F$181","v":0},"Flag"]
[null,null,null,null,{"$f":"E$169","v":"Outperformance cost sharing rate"},{"$f":"F$169","v":0.5},"%"]
[null,null,null,null,"Example underperformance: totex sharing rate greater than a 100%",{"$f":" F183 * (1 - F184)","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$178","v":"Example underperformance: totex sharing rate less than to equal to 100%"},{"$f":"F$178","v":0.5},"%"]
[null,null,null,null,{"$f":"E$185","v":"Example underperformance: totex sharing rate greater than a 100%"},{"$f":"F$185","v":0},"%"]
[null,null,null,null,"Example underperformance summary sharing rates",{"$f":"SUM(F187:F188)","v":0.5},"%"]
[]
["WASTEWATER NETWORK PLUS"]
[]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$123","v":"Wastewater Network - Total Expenditure"},{"$f":"'Ex-ante allowances'!F$123","v":882.09699999999998},{"$f":"'Ex-ante allowances'!G$123","v":"£m"}]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F$127","v":828.71740271570854},{"$f":"'Ex-ante allowances'!G$127","v":"£m"}]
[null,null,null,null,"Example: totex ratio company's forecast: Ofwat baseline",{"$f":"IF(F194 = 0,0, F193/F194)","v":1.0644123040126421},"%"]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},{"$f":"G$195","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$152 & \" - Range\"","v":"   Parameter(s)  1 - Range"},{"$f":"InpOverride!F$152","v":0.8},{"$f":"InpOverride!G$152","v":"%"}]
[null,null,null,null,"Example Outperformance flag: less than or equal 80%",{"$f":" IF(F197<=$F198,1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$154 & \" - Range\"","v":"   Parameter 2 - Range"},{"$f":"InpOverride!F$154","v":0.8},{"$f":"InpOverride!G$154","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$155 & \" - Range\"","v":"   Parameter 3 - Range"},{"$f":"InpOverride!F$155","v":0.9},{"$f":"InpOverride!G$155","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 80% and less than or equal to 90% ",{"$f":" IF(AND(F201>$F202,F201<=$F203),1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$158 & \" - Range\"","v":"   Parameter 4 - Range"},{"$f":"InpOverride!F$158","v":0.9},{"$f":"InpOverride!G$158","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$159 & \" - Range\"","v":"   Parameter 5 - Range"},{"$f":"InpOverride!F$159","v":1.1000000000000001},{"$f":"InpOverride!G$159","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 90% and less than or equal to 110% ",{"$f":" IF(AND(F206>$F207,F206<=$F208),1,0)","v":1},"Flag"]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$162 & \" - Range\"","v":"   Parameter 7 - Range"},{"$f":"InpOverride!F$162","v":1.1000000000000001},{"$f":"InpOverride!G$162","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$163 & \" - Range\"","v":"   Parameter 8 - Range"},{"$f":"InpOverride!F$163","v":1.2},{"$f":"InpOverride!G$163","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than 110% and less than or equal to 120% ",{"$f":" IF(AND(F211>$F212,F211<=$F213),1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$166 & \" - Range\"","v":"  Parameter 10 - Range"},{"$f":"InpOverride!F$166","v":1.2},{"$f":"InpOverride!G$166","v":"%"}]
[null,null,null,null,"Example Outperformance flag: greater than120%",{"$f":"IF(F216>$F217,1,0)","v":0},"Flag"]
[]
[]
[null,null,null,null,{"$f":"E$199","v":"Example Outperformance flag: less than or equal 80%"},{"$f":"F$199","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$174 &\" - Coefficient\"","v":"   Parameter(s)  1 - Coefficient"},{"$f":"InpOverride!F$174","v":0.65},{"$f":"InpOverride!G$174","v":"%"}]
[null,null,null,null,"Example outperformance: less than or equal 80%",{"$f":"F221 * $F222","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$204","v":"Example Outperformance flag: greater than 80% and less than or equal to 90% "},{"$f":"F$204","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$176 &\" - Coefficient\"","v":"   Parameter 2 - Coefficient"},{"$f":"InpOverride!F$176","v":0.65},{"$f":"InpOverride!G$176","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$177 &\" - Coefficient\"","v":"   Parameter 3 - Coefficient"},{"$f":"InpOverride!F$177","v":0.5},{"$f":"InpOverride!G$177","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$178 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$178","v":0.8},{"$f":"InpOverride!G$178","v":"%"}]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,"Example outperformance: greater than 80% and less than or equal to 90% ",{"$f":" F225 * ($F226 - $F227 * (F229 - $F228))","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$209","v":"Example Outperformance flag: greater than 90% and less than or equal to 110% "},{"$f":"F$209","v":1},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$180 &\" - Coefficient\"","v":"   Parameter 4 - Coefficient"},{"$f":"InpOverride!F$180","v":0.6},{"$f":"InpOverride!G$180","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$181 &\" - Coefficient\"","v":"   Parameter 5 - Coefficient"},{"$f":"InpOverride!F$181","v":1},{"$f":"InpOverride!G$181","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$182 &\" - Coefficient\"","v":"   Parameter 6 - Coefficient"},{"$f":"InpOverride!F$182","v":0.9},{"$f":"InpOverride!G$182","v":"%"}]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,"Example outperformance: greater than 90% and less than or equal to 110% ",{"$f":" F232 * ($F233 - $F234 * (F236 - $F235))","v":0.43558769598735791},"%"]
[]
[null,null,null,null,{"$f":"E$214","v":"Example Outperformance flag: greater than 110% and less than or equal to 120% "},{"$f":"F$214","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$184 &\" - Coefficient\"","v":"   Parameter 7 - Coefficient"},{"$f":"InpOverride!F$184","v":0.4},{"$f":"InpOverride!G$184","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$185 &\" - Coefficient\"","v":"   Parameter 8 - Coefficient"},{"$f":"InpOverride!F$185","v":1},{"$f":"InpOverride!G$185","v":"%"}]
[null,null,null,null,{"$f":" InpOverride!E$186 &\" - Coefficient\"","v":"   Parameter 9 - Coefficient"},{"$f":"InpOverride!F$186","v":1.1000000000000001},{"$f":"InpOverride!G$186","v":"%"}]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,"Example outperformance: greater than 110% and less than or equal to 120% ",{"$f":" F239 * ($F240 - $F241 * (F243 - $F242))","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$218","v":"Example Outperformance flag: greater than120%"},{"$f":"F$218","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$188 &\" - Coefficient\"","v":"  Parameter 10 - Coefficient"},{"$f":"InpOverride!F$188","v":0.3},{"$f":"InpOverride!G$188","v":"%"}]
[null,null,null,null,"Example outperformance: greater than120%",{"$f":"F246*$F247","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$223","v":"Example outperformance: less than or equal 80%"},{"$f":"F$223","v":0},"%"]
[null,null,null,null,{"$f":"E$230","v":"Example outperformance: greater than 80% and less than or equal to 90% "},{"$f":"F$230","v":0},"%"]
[null,null,null,null,{"$f":"E$237","v":"Example outperformance: greater than 90% and less than or equal to 110% "},{"$f":"F$237","v":0.43558769598735791},"%"]
[null,null,null,null,{"$f":"E$244","v":"Example outperformance: greater than 110% and less than or equal to 120% "},{"$f":"F$244","v":0},"%"]
[null,null,null,null,{"$f":"E$248","v":"Example outperformance: greater than120%"},{"$f":"F$248","v":0},"%"]
[null,null,null,null,"Actual outperformance cost sharing rate for example",{"$f":"SUM(F250:F254)","v":0.43558769598735791},"%"]
[]
[null,null,null,null,{"$f":"InpOverride!E146","v":"Cost sharing rates Fast track overrides"},{"$f":"InpOverride!F146","v":1},{"$f":"InpOverride!G146","v":"1 = Fast Track company, 0 = Non SS/ST company"}]
[null,null,null,null,{"$f":"InpOverride!E147","v":"Fast track Cost sharing Override rates"},{"$f":"InpOverride!F147","v":0.5},{"$f":"InpOverride!G147","v":"%"}]
[null,null,null,null,{"$f":"E255","v":"Actual outperformance cost sharing rate for example"},{"$f":"F255","v":0.43558769598735791},{"$f":"G255","v":"%"}]
[null,null,null,null,"Outperformance cost sharing rate",{"$f":" IF(F257 = 1, F258, F259)","v":0.5},"%"]
[]
[null,null,null,null,{"$f":"E260","v":"Outperformance cost sharing rate"},{"$f":"F260","v":0.5},"%"]
[]
[]
[null,null,null,null,{"$f":"E$195","v":"Example: totex ratio company's forecast: Ofwat baseline"},{"$f":"F$195","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$170 & \" - Range\"","v":"  Parameter 11 - Range"},{"$f":"InpOverride!F$170","v":1},{"$f":"InpOverride!G$170","v":"%"}]
[null,null,null,null,"Example underperformance: less than or equal to 100% flag",{"$f":"IF(F265<=$F266,1,0)","v":0},"Flag"]
[]
[null,null,null,null,{"$f":"E$267","v":"Example underperformance: less than or equal to 100% flag"},{"$f":"F$267","v":0},"Flag"]
[null,null,null,null,{"$f":" InpOverride!E$192 &\" - Coefficient\"","v":"  Parameter 11 - Coefficient"},{"$f":"InpOverride!F$192","v":0.5},{"$f":"InpOverride!G$192","v":"%"}]
[null,null,null,null,"Example underperformance: totex sharing rate less than to equal to 100%",{"$f":" F269 * $F270","v":0},"%"]
[]
[null,null,null,null,{"$f":"E$269","v":"Example underperformance: less than or equal to 100% flag"},{"$f":"F$269","v":0},"Flag"]
[null,null,null,null,"Example underperformance: greater than a 100% flag",{"$f":" 1 - F273","v":1},"Flag"]
[]
[null,null,null,null,{"$f":"E$274","v":"Example underperformance: greater than a 100% flag"},{"$f":"F$274","v":1},"Flag"]
[null,null,null,null,{"$f":"E$262","v":"Outperformance cost sharing rate"},{"$f":"F$262","v":0.5},"%"]
[null,null,null,null,"Example underperformance: totex sharing rate greater than a 100%",{"$f":" F276 * (1 - F277)","v":0.5},"%"]
[]
[null,null,null,null,{"$f":"E$271","v":"Example underperformance: totex sharing rate less than to equal to 100%"},{"$f":"F$271","v":0},"%"]
[null,null,null,null,{"$f":"E$278","v":"Example underperformance: totex sharing rate greater than a 100%"},{"$f":"F$278","v":0.5},"%"]
[null,null,null,null,"Example underperformance summary sharing rates",{"$f":"SUM(F280:F281)","v":0.5},"%"]
[]
["END OF SHEET"]

{"sheet":"Ex-ante allowances","index":10,"n_rows":173,"n_cols":16,"rows_kept":173,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Ex-ante allowances"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks",null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
["EX-ANTE ALLOWANCES"]
[]
[null,"Water Resources"]
[null,null,null,null,{"$f":"InpOverride!E$30","v":"Water resources company view of capex - for cost sharing model"},{"$f":"InpOverride!F$30","v":0},{"$f":"InpOverride!G$30","v":"£m"},{"$f":"InpOverride!H$30","v":23.713999999999999},{"$f":"InpOverride!I$30","v":0},{"$f":"InpOverride!J$30","v":0},{"$f":"InpOverride!K$30","v":5.4829999999999997},{"$f":"InpOverride!L$30","v":6.0410000000000004},{"$f":"InpOverride!M$30","v":4.95},{"$f":"InpOverride!N$30","v":3.7749999999999999},{"$f":"InpOverride!O$30","v":3.4649999999999999},{"$f":"InpOverride!P$30","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$31","v":"Water resources company view of opex - for cost sharing model"},{"$f":"InpOverride!F$31","v":0},{"$f":"InpOverride!G$31","v":"£m"},{"$f":"InpOverride!H$31","v":55.841000000000008},{"$f":"InpOverride!I$31","v":0},{"$f":"InpOverride!J$31","v":0},{"$f":"InpOverride!K$31","v":11.085000000000001},{"$f":"InpOverride!L$31","v":11.148999999999999},{"$f":"InpOverride!M$31","v":11.166},{"$f":"InpOverride!N$31","v":11.199},{"$f":"InpOverride!O$31","v":11.242000000000001},{"$f":"InpOverride!P$31","v":0}]
[null,null,null,null,"Water Resources - Total Expenditure",{"$f":"SUM(H11:H12)","v":79.555000000000007},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$28","v":"Final cost allowance for cost sharing for Water Resources"},{"$f":"InpOverride!F$28","v":0},{"$f":"InpOverride!G$28","v":"£m"},{"$f":"InpOverride!H$28","v":73.952450218785501},{"$f":"InpOverride!I$28","v":0},{"$f":"InpOverride!J$28","v":0},{"$f":"InpOverride!K$28","v":14.790490043757099},{"$f":"InpOverride!L$28","v":14.790490043757099},{"$f":"InpOverride!M$28","v":14.790490043757099},{"$f":"InpOverride!N$28","v":14.790490043757099},{"$f":"InpOverride!O$28","v":14.790490043757099},{"$f":"InpOverride!P$28","v":0}]
[null,null,null,null,{"$f":"InpOverride!E34","v":"WR operating lease adjustment"},{"$f":"InpOverride!F34","v":0},{"$f":"InpOverride!G34","v":"£m"},{"$f":"InpOverride!H34","v":0},{"$f":"InpOverride!I34","v":0},{"$f":"InpOverride!J34","v":0},{"$f":"InpOverride!K34","v":0},{"$f":"InpOverride!L34","v":0},{"$f":"InpOverride!M34","v":0},{"$f":"InpOverride!N34","v":0},{"$f":"InpOverride!O34","v":0},{"$f":"InpOverride!P34","v":0}]
[null,null,null,null,"Water Resources - Ofwat Baseline Total Gross Totex - Real",{"$f":"SUM($H$15:$H$16)","v":73.952450218785501},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$30","v":"Water resources company view of capex - for cost sharing model"},null,"£m",{"$f":"SUM(K19:O19)","v":23.713999999999999},null,{"$f":"InpOverride!J$30","v":0},{"$f":"InpOverride!K$30","v":5.4829999999999997},{"$f":"InpOverride!L$30","v":6.0410000000000004},{"$f":"InpOverride!M$30","v":4.95},{"$f":"InpOverride!N$30","v":3.7749999999999999},{"$f":"InpOverride!O$30","v":3.4649999999999999},{"$f":"InpOverride!P$30","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$31","v":"Water resources company view of opex - for cost sharing model"},null,"£m",{"$f":"SUM(K20:O20)","v":55.841000000000008},null,{"$f":"InpOverride!J$31","v":0},{"$f":"InpOverride!K$31","v":11.085000000000001},{"$f":"InpOverride!L$31","v":11.148999999999999},{"$f":"InpOverride!M$31","v":11.166},{"$f":"InpOverride!N$31","v":11.199},{"$f":"InpOverride!O$31","v":11.242000000000001},{"$f":"InpOverride!P$31","v":0}]
[null,null,null,null,"[Company outturn totex - Water Resources]",{"$f":"SUM(H19:H20)","v":79.555000000000007},"£m"]
[]
[null,null,null,"Ex-ante allowance"]
[null,null,null,null,{"$f":" E$13","v":"Water Resources - Total Expenditure"},{"$f":" F$13","v":79.555000000000007},{"$f":" G$13","v":"£m"}]
[null,null,null,null,{"$f":" E$17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$17","v":73.952450218785501},{"$f":" G$17","v":"£m"}]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"(F24/F25)","v":1.0757588121102084},"%"]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$169","v":"Outperformance cost sharing rate"},{"$f":"'Dashboard Calcs'!F$169","v":0.5},{"$f":"'Dashboard Calcs'!G$169","v":"%"}]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$189","v":"Example underperformance summary sharing rates"},{"$f":"'Dashboard Calcs'!F$189","v":0.5},{"$f":"'Dashboard Calcs'!G$189","v":"%"}]
[null,null,null,null,{"$f":" E$21","v":"[Company outturn totex - Water Resources]"},{"$f":" F$21","v":79.555000000000007},{"$f":" G$21","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-)",{"$f":"IF(( F29 < F25), F27, F28) * (F25 - F29)","v":-2.8012748906072531},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast",{"$f":"F24+F30-F25","v":2.801274890607246},"£m"]
[]
[null,null,null,"Ex-ante allowance - significant scrutiny"]
[null,null,null,null,{"$f":" E$13","v":"Water Resources - Total Expenditure"},{"$f":" F$13","v":79.555000000000007},{"$f":" G$13","v":"£m"}]
[null,null,null,null,{"$f":" E$17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$17","v":73.952450218785501},"£m"]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"(F34/F35)","v":1.0757588121102084},"%"]
[null,null,null,null,{"$f":"InpOverride!E$196","v":"  Cost sharing rate"},{"$f":"InpOverride!F$196","v":0.25},{"$f":"InpOverride!G$196","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$199","v":"  Cost Sharing rate"},{"$f":"InpOverride!F$199","v":0.75},{"$f":"InpOverride!G$199","v":"%"}]
[null,null,null,null,{"$f":" E$21","v":"[Company outturn totex - Water Resources]"},{"$f":" F$21","v":79.555000000000007},{"$f":" G$21","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-) - significant scrutiny",{"$f":"IF(( F39 < F35), F37, F38) * (F35 - F39)","v":-4.2019123359108796},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - significant scrutiny",{"$f":"F34+F40-F35","v":1.4006374453036301},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$144","v":"Company IAP classification"},{"$f":"InpOverride!F$144","v":"Not Significant Scrutiny"},{"$f":"InpOverride!G$144","v":"text"}]
[null,null,null,null,{"$f":"E$31","v":"Ex-ante allowance above Ofwat forecast"},{"$f":"F$31","v":2.801274890607246},{"$f":"G$31","v":"£m"}]
[null,null,null,null,{"$f":"E$41","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny"},{"$f":"F$41","v":1.4006374453036301},{"$f":"G$41","v":"£m"}]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast ",{"$f":" IF(F43 = \"Not Significant Scrutiny\",F44, F45)","v":2.801274890607246},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$84","v":"Cost allowance override switch - Water"},{"$f":"InpOverride!F$84","v":3},{"$f":"InpOverride!G$84","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":"E$46","v":"Ex-ante allowance above Ofwat forecast "},{"$f":"F$46","v":2.801274890607246},{"$f":"G$46","v":"£m"}]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - Active",{"$f":" IF(F48 = 3, 0, F49)","v":0},"£m"]
[]
[null,null,null,"Total Cost allowance"]
[null,null,null,null,{"$f":"E$17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":"F$17","v":73.952450218785501},"£m"]
[null,null,null,null,{"$f":"E$46","v":"Ex-ante allowance above Ofwat forecast "},{"$f":"F$46","v":2.801274890607246},{"$f":"G$46","v":"£m"}]
[null,null,null,null,"Water resources - total cost allowance including ex-ante cost sharing",{"$f":"F53 + F54","v":76.753725109392747},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$84","v":"Cost allowance override switch - Water"},{"$f":"InpOverride!F$84","v":3},{"$f":"InpOverride!G$84","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":" E$55","v":"Water resources - total cost allowance including ex-ante cost sharing"},{"$f":" F$55","v":76.753725109392747},"£m"]
[null,null,null,null,{"$f":"InpOverride!E$86","v":"Water resources - total cost allowance including ex-ante cost sharing - Override"},{"$f":"InpOverride!F$86","v":0},{"$f":"InpOverride!G$86","v":"£m"}]
[null,null,null,null,{"$f":" E$17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$17","v":73.952450218785501},"£m"]
[null,null,null,null,"Water resources - total cost allowance including ex-ante cost sharing - active",{"$f":"CHOOSE($F$57,F58,F59,F60)","v":73.952450218785501},"£m"]
[]
[null,"Water Network"]
[null,null,null,null,{"$f":"InpOverride!E$39","v":"Water network company view of capex - for cost sharing model"},{"$f":"InpOverride!F$39","v":0},{"$f":"InpOverride!G$39","v":"£m"},{"$f":"InpOverride!H$39","v":440.66700000000003},{"$f":"InpOverride!I$39","v":0},{"$f":"InpOverride!J$39","v":0},{"$f":"InpOverride!K$39","v":68.813000000000002},{"$f":"InpOverride!L$39","v":83.796000000000006},{"$f":"InpOverride!M$39","v":103.568},{"$f":"InpOverride!N$39","v":95.088999999999999},{"$f":"InpOverride!O$39","v":89.400999999999996},{"$f":"InpOverride!P$39","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$40","v":"Water network company view of opex - for cost sharing model"},{"$f":"InpOverride!F$40","v":0},{"$f":"InpOverride!G$40","v":"£m"},{"$f":"InpOverride!H$40","v":395.03299999999996},{"$f":"InpOverride!I$40","v":0},{"$f":"InpOverride!J$40","v":0},{"$f":"InpOverride!K$40","v":79.278999999999996},{"$f":"InpOverride!L$40","v":79.605999999999995},{"$f":"InpOverride!M$40","v":79.356999999999999},{"$f":"InpOverride!N$40","v":78.55},{"$f":"InpOverride!O$40","v":78.241},{"$f":"InpOverride!P$40","v":0}]
[null,null,null,null,"Water Network - Total Expenditure",{"$f":"SUM(H64:H65)","v":835.7},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$37","v":"Final cost allowance for cost sharing for Network Plus Water"},{"$f":"InpOverride!F$37","v":0},{"$f":"InpOverride!G$37","v":"£m"},{"$f":"InpOverride!H$37","v":854.223021064965},{"$f":"InpOverride!I$37","v":0},{"$f":"InpOverride!J$37","v":0},{"$f":"InpOverride!K$37","v":170.844604212993},{"$f":"InpOverride!L$37","v":170.844604212993},{"$f":"InpOverride!M$37","v":170.844604212993},{"$f":"InpOverride!N$37","v":170.844604212993},{"$f":"InpOverride!O$37","v":170.844604212993},{"$f":"InpOverride!P$37","v":0}]
[null,null,null,null,{"$f":"InpOverride!E43","v":"WN operating lease adjustment"},{"$f":"InpOverride!F43","v":0},{"$f":"InpOverride!G43","v":"£m"},{"$f":"InpOverride!H43","v":-3.3326500157310641},{"$f":"InpOverride!I43","v":0},{"$f":"InpOverride!J43","v":0},{"$f":"InpOverride!K43","v":-0.76605533226703304},{"$f":"InpOverride!L43","v":-0.699247294979923},{"$f":"InpOverride!M43","v":-0.65409508498250901},{"$f":"InpOverride!N43","v":-0.62260270979230903},{"$f":"InpOverride!O43","v":-0.59064959370929004},{"$f":"InpOverride!P43","v":0}]
[null,null,null,null,"Water Network - Ofwat Baseline Total Gross Totex - Real",{"$f":"SUM($H$68:$H$69)","v":850.89037104923398},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$39","v":"Water network company view of capex - for cost sharing model"},{"$f":"InpOverride!F$39","v":0},{"$f":"InpOverride!G$39","v":"£m"},{"$f":"InpOverride!H$39","v":440.66700000000003},{"$f":"InpOverride!I$39","v":0},{"$f":"InpOverride!J$39","v":0},{"$f":"InpOverride!K$39","v":68.813000000000002},{"$f":"InpOverride!L$39","v":83.796000000000006},{"$f":"InpOverride!M$39","v":103.568},{"$f":"InpOverride!N$39","v":95.088999999999999},{"$f":"InpOverride!O$39","v":89.400999999999996},{"$f":"InpOverride!P$39","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$40","v":"Water network company view of opex - for cost sharing model"},{"$f":"InpOverride!F$40","v":0},{"$f":"InpOverride!G$40","v":"£m"},{"$f":"InpOverride!H$40","v":395.03299999999996},{"$f":"InpOverride!I$40","v":0},{"$f":"InpOverride!J$40","v":0},{"$f":"InpOverride!K$40","v":79.278999999999996},{"$f":"InpOverride!L$40","v":79.605999999999995},{"$f":"InpOverride!M$40","v":79.356999999999999},{"$f":"InpOverride!N$40","v":78.55},{"$f":"InpOverride!O$40","v":78.241},{"$f":"InpOverride!P$40","v":0}]
[null,null,null,null,"[Company outturn totex - Water Network]",{"$f":"SUM(H72:H73)","v":835.7},"£m"]
[]
[null,null,null,null,{"$f":"E$21","v":"[Company outturn totex - Water Resources]"},{"$f":"F$21","v":79.555000000000007},{"$f":"G$21","v":"£m"}]
[null,null,null,null,{"$f":"E$74","v":"[Company outturn totex - Water Network]"},{"$f":"F$74","v":835.7},{"$f":"G$74","v":"£m"}]
[null,null,null,null,"Company outturn totex of - Water",{"$f":" SUM(F76:F77)","v":915.25500000000011},"£m"]
[]
[null,null,null,"Ex-ante allowance"]
[null,null,null,null,{"$f":" E$66","v":"Water Network - Total Expenditure"},{"$f":" F$66","v":835.7},{"$f":" G$66","v":"£m"}]
[null,null,null,null,{"$f":" E$70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$70","v":850.89037104923398},{"$f":" G$70","v":"£m"}]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"(F81/F82)","v":0.98214767546317083},"%"]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$169","v":"Outperformance cost sharing rate"},{"$f":"'Dashboard Calcs'!F$169","v":0.5},{"$f":"'Dashboard Calcs'!G$169","v":"%"}]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$189","v":"Example underperformance summary sharing rates"},{"$f":"'Dashboard Calcs'!F$189","v":0.5},{"$f":"'Dashboard Calcs'!G$189","v":"%"}]
[null,null,null,null,{"$f":" E$74","v":"[Company outturn totex - Water Network]"},{"$f":" F$74","v":835.7},{"$f":" G$74","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-) - Water Network",{"$f":"IF(( F86 < F82), F84, F85) * (F82 - F86)","v":7.5951855246169657},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - Water Network",{"$f":"F81+F87-F82","v":-7.5951855246170226},"£m"]
[]
[null,null,null,"Ex-ante allowance - significant scrutiny"]
[null,null,null,null,{"$f":" E$66","v":"Water Network - Total Expenditure"},{"$f":" F$66","v":835.7},{"$f":" G$66","v":"£m"}]
[null,null,null,null,{"$f":" E$70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$70","v":850.89037104923398},{"$f":" G$70","v":"£m"}]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"(F91/F92)","v":0.98214767546317083},"%"]
[null,null,null,null,{"$f":"InpOverride!E$196","v":"  Cost sharing rate"},{"$f":"InpOverride!F$196","v":0.25},{"$f":"InpOverride!G$196","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$199","v":"  Cost Sharing rate"},{"$f":"InpOverride!F$199","v":0.75},{"$f":"InpOverride!G$199","v":"%"}]
[null,null,null,null,{"$f":" E$74","v":"[Company outturn totex - Water Network]"},{"$f":" F$74","v":835.7},{"$f":" G$74","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-) - significant scrutiny - Water Network",{"$f":"IF(( F96 < F92), F94, F95) * (F92 - F96)","v":3.7975927623084829},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - significant scrutiny - Water Network",{"$f":"F91+F97-F92","v":-11.392778286925477},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$144","v":"Company IAP classification"},{"$f":"InpOverride!F$144","v":"Not Significant Scrutiny"},{"$f":"InpOverride!G$144","v":"text"}]
[null,null,null,null,{"$f":"E$88","v":"Ex-ante allowance above Ofwat forecast - Water Network"},{"$f":"F$88","v":-7.5951855246170226},{"$f":"G$88","v":"£m"}]
[null,null,null,null,{"$f":"E$98","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny - Water Network"},{"$f":"F$98","v":-11.392778286925477},{"$f":"G$98","v":"£m"}]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - Water Network",{"$f":" IF(F100 = \"Not Significant Scrutiny\",F101, F102)","v":-7.5951855246170226},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$84","v":"Cost allowance override switch - Water"},{"$f":"InpOverride!F$84","v":3},{"$f":"InpOverride!G$84","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":"E$103","v":"Ex-ante allowance above Ofwat forecast - Water Network"},{"$f":"F$103","v":-7.5951855246170226},{"$f":"G$103","v":"£m"}]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - Active - Water Network",{"$f":" IF(F105 = 3, 0, F106)","v":0},"£m"]
[]
[null,null,null,"Total Cost allowance"]
[null,null,null,null,{"$f":"E$70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"F$70","v":850.89037104923398},{"$f":"G$70","v":"£m"}]
[null,null,null,null,{"$f":"E$103","v":"Ex-ante allowance above Ofwat forecast - Water Network"},-7.5951855246170226,"£m"]
[null,null,null,null,"Water network - total cost allowance including ex-ante cost sharing",{"$f":"F110 + F111","v":843.29518552461695},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$84","v":"Cost allowance override switch - Water"},{"$f":"InpOverride!F$84","v":3},{"$f":"InpOverride!G$84","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":" E$112","v":"Water network - total cost allowance including ex-ante cost sharing"},{"$f":" F$112","v":843.29518552461695},{"$f":" G$112","v":"£m"}]
[null,null,null,null,{"$f":"InpOverride!E$88","v":"Water network - total cost allowance including ex-ante cost sharing - Override"},{"$f":"InpOverride!F$88","v":0},{"$f":"InpOverride!G$88","v":"£m"}]
[null,null,null,null,{"$f":" E$70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$70","v":850.89037104923398},{"$f":" G$70","v":"£m"}]
[null,null,null,null,"Water network - total cost allowance including ex-ante cost sharing - active",{"$f":"CHOOSE($F$114,F115,F116,F117)","v":850.89037104923398},"£m"]
[]
[null,"WasteWater Network"]
[null,null,null,null,{"$f":"InpOverride!E$56","v":"Wastewater network company view of opex - for cost sharing model"},{"$f":"InpOverride!F$56","v":0},{"$f":"InpOverride!G$56","v":"£m"},{"$f":"InpOverride!H$56","v":395.24299999999999},{"$f":"InpOverride!I$56","v":0},{"$f":"InpOverride!J$56","v":0},{"$f":"InpOverride!K$56","v":80.498999999999995},{"$f":"InpOverride!L$56","v":80.117999999999995},{"$f":"InpOverride!M$56","v":79.534999999999997},{"$f":"InpOverride!N$56","v":77.992000000000004},{"$f":"InpOverride!O$56","v":77.099000000000004},{"$f":"InpOverride!P$56","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$55","v":"Wastewater network company view of capex - for cost sharing model"},{"$f":"InpOverride!F$55","v":0},{"$f":"InpOverride!G$55","v":"£m"},{"$f":"InpOverride!H$55","v":486.85400000000004},{"$f":"InpOverride!I$55","v":0},{"$f":"InpOverride!J$55","v":0},{"$f":"InpOverride!K$55","v":111.44499999999999},{"$f":"InpOverride!L$55","v":108.18},{"$f":"InpOverride!M$55","v":92.908000000000001},{"$f":"InpOverride!N$55","v":93.126999999999995},{"$f":"InpOverride!O$55","v":81.194000000000003},{"$f":"InpOverride!P$55","v":0}]
[null,null,null,null,"Wastewater Network - Total Expenditure",{"$f":"SUM(H121:H122)","v":882.09699999999998},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$53","v":"Efficient totex for cost sharing network plus wastewater £m"},{"$f":"InpOverride!F$53","v":0},{"$f":"InpOverride!G$53","v":"£m"},{"$f":"InpOverride!H$53","v":832.02474984920502},{"$f":"InpOverride!I$53","v":0},{"$f":"InpOverride!J$53","v":0},{"$f":"InpOverride!K$53","v":166.404949969841},{"$f":"InpOverride!L$53","v":166.404949969841},{"$f":"InpOverride!M$53","v":166.404949969841},{"$f":"InpOverride!N$53","v":166.404949969841},{"$f":"InpOverride!O$53","v":166.404949969841},{"$f":"InpOverride!P$53","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$59","v":"WWN operating lease adjustment"},{"$f":"InpOverride!F$59","v":0},{"$f":"InpOverride!G$59","v":"£m"},{"$f":"InpOverride!H$59","v":-3.3073471334964393},{"$f":"InpOverride!I$59","v":0},{"$f":"InpOverride!J$59","v":0},{"$f":"InpOverride!K$59","v":-0.757261329728253},{"$f":"InpOverride!L$59","v":-0.69355464400315303},{"$f":"InpOverride!M$59","v":-0.64948878156713896},{"$f":"InpOverride!N$59","v":-0.61812998917598505},{"$f":"InpOverride!O$59","v":-0.58891238902190901},{"$f":"InpOverride!P$59","v":0}]
[null,null,null,null,"Wastewater Network - Ofwat Baseline Total Gross Totex - Real",{"$f":" SUM($H$125:$H$126)","v":828.71740271570854},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$56","v":"Wastewater network company view of opex - for cost sharing model"},{"$f":"InpOverride!F$56","v":0},{"$f":"InpOverride!G$56","v":"£m"},{"$f":"InpOverride!H$56","v":395.24299999999999},{"$f":"InpOverride!I$56","v":0},{"$f":"InpOverride!J$56","v":0},{"$f":"InpOverride!K$56","v":80.498999999999995},{"$f":"InpOverride!L$56","v":80.117999999999995},{"$f":"InpOverride!M$56","v":79.534999999999997},{"$f":"InpOverride!N$56","v":77.992000000000004},{"$f":"InpOverride!O$56","v":77.099000000000004},{"$f":"InpOverride!P$56","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$55","v":"Wastewater network company view of capex - for cost sharing model"},{"$f":"InpOverride!F$55","v":0},{"$f":"InpOverride!G$55","v":"£m"},{"$f":"InpOverride!H$55","v":486.85400000000004},{"$f":"InpOverride!I$55","v":0},{"$f":"InpOverride!J$55","v":0},{"$f":"InpOverride!K$55","v":111.44499999999999},{"$f":"InpOverride!L$55","v":108.18},{"$f":"InpOverride!M$55","v":92.908000000000001},{"$f":"InpOverride!N$55","v":93.126999999999995},{"$f":"InpOverride!O$55","v":81.194000000000003},{"$f":"InpOverride!P$55","v":0}]
[null,null,null,null,"[Company outturn totex of - Wastewater Network]",{"$f":"SUM(H129:H130)","v":882.09699999999998},"£m"]
[]
[null,null,null,"Ex-ante allowance"]
[null,null,null,null,{"$f":" E$123","v":"Wastewater Network - Total Expenditure"},{"$f":" F$123","v":882.09699999999998},{"$f":" G$123","v":"£m"}]
[null,null,null,null,{"$f":" E$127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$127","v":828.71740271570854},{"$f":" G$127","v":"£m"}]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"IF(F135=0, 0, (F134/F135))","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$262","v":"Outperformance cost sharing rate"},{"$f":"'Dashboard Calcs'!F$262","v":0.5},{"$f":"'Dashboard Calcs'!G$262","v":"%"}]
[null,null,null,null,{"$f":"'Dashboard Calcs'!E$282","v":"Example underperformance summary sharing rates"},{"$f":"'Dashboard Calcs'!F$282","v":0.5},{"$f":"'Dashboard Calcs'!G$282","v":"%"}]
[null,null,null,null,{"$f":" E$131","v":"[Company outturn totex of - Wastewater Network]"},{"$f":" F$131","v":882.09699999999998},{"$f":" G$131","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-) - Wastewater Network",{"$f":"IF(( F139 < F135), F137, F138) * (F135 - F139)","v":-26.689798642145718},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - Wastewater Network",{"$f":"F134+F140-F135","v":26.689798642145774},"£m"]
[]
[null,null,null,"Ex-ante allowance - significant scrutiny"]
[null,null,null,null,{"$f":" E$123","v":"Wastewater Network - Total Expenditure"},{"$f":" F$123","v":882.09699999999998},{"$f":" G$123","v":"£m"}]
[null,null,null,null,{"$f":" E$127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$127","v":828.71740271570854},{"$f":" G$127","v":"£m"}]
[null,null,null,null,"Ratio company's forecast: Ofwat baseline",{"$f":"(F144/F145)","v":1.0644123040126421},"%"]
[null,null,null,null,{"$f":"InpOverride!E$196","v":"  Cost sharing rate"},{"$f":"InpOverride!F$196","v":0.25},{"$f":"InpOverride!G$196","v":"%"}]
[null,null,null,null,{"$f":"InpOverride!E$199","v":"  Cost Sharing rate"},{"$f":"InpOverride!F$199","v":0.75},{"$f":"InpOverride!G$199","v":"%"}]
[null,null,null,null,{"$f":" E$131","v":"[Company outturn totex of - Wastewater Network]"},{"$f":" F$131","v":882.09699999999998},{"$f":" G$131","v":"£m"}]
[null,null,null,null,"Incentive payment (+) or penalty (-) - significant scrutiny - Wastewater Network",{"$f":"IF(( F149 < F145), F147, F148) * (F145 - F149)","v":-40.034697963218576},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast - significant scrutiny - Wastewater Network",{"$f":"F144+F150-F145","v":13.34489932107283},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$144","v":"Company IAP classification"},{"$f":"InpOverride!F$144","v":"Not Significant Scrutiny"},{"$f":"InpOverride!G$144","v":"text"}]
[null,null,null,null,{"$f":"E$141","v":"Ex-ante allowance above Ofwat forecast - Wastewater Network"},{"$f":"F$141","v":26.689798642145774},{"$f":"G$141","v":"£m"}]
[null,null,null,null,{"$f":"E$151","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny - Wastewater Network"},{"$f":"F$151","v":13.34489932107283},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast- Wastewater Network",{"$f":" IF(F153 = \"Not Significant Scrutiny\",F154, F155)","v":26.689798642145774},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$90","v":"Cost allowance override switch - Waste"},{"$f":"InpOverride!F$90","v":3},{"$f":"InpOverride!G$90","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":"E$156","v":"Ex-ante allowance above Ofwat forecast- Wastewater Network"},{"$f":"F$156","v":26.689798642145774},"£m"]
[null,null,null,null,"Ex-ante allowance above Ofwat forecast- Wastewater Network - Active",{"$f":" IF(F158 = 3, 0, F159)","v":0},"£m"]
[]
[null,null,null,"Total Cost allowance"]
[null,null,null,null,{"$f":"E$127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"F$127","v":828.71740271570854},{"$f":"G$127","v":"£m"}]
[null,null,null,null,{"$f":"E$156","v":"Ex-ante allowance above Ofwat forecast- Wastewater Network"},{"$f":"F$156","v":26.689798642145774},"£m"]
[null,null,null,null,"Wastewater Network - total cost allowance including ex-ante cost sharing",{"$f":"F163 + F164","v":855.40720135785432},"£m"]
[]
[null,null,null,null,{"$f":"InpOverride!E$90","v":"Cost allowance override switch - Waste"},{"$f":"InpOverride!F$90","v":3},{"$f":"InpOverride!G$90","v":"1 = model calculated, 2 = Override, 3 = Off"}]
[null,null,null,null,{"$f":" E$165","v":"Wastewater Network - total cost allowance including ex-ante cost sharing"},{"$f":" F$165","v":855.40720135785432},"£m"]
[null,null,null,null,{"$f":"InpOverride!E$92","v":"Wastewater network - total cost allowance including ex-ante cost sharing - Override"},{"$f":"InpOverride!F$92","v":0},{"$f":"InpOverride!G$92","v":"£m"}]
[null,null,null,null,{"$f":" E$127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":" F$127","v":828.71740271570854},{"$f":" G$127","v":"£m"}]
[null,null,null,null,"Wastewater Network - total cost allowance including ex-ante cost sharing - active",{"$f":"CHOOSE($F$167,F168,F169,F170)","v":828.71740271570854},"£m"]
[]
["END OF SHEET"]

{"sheet":"Cost profiling","index":11,"n_rows":176,"n_cols":16,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cost profiling"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks",null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
["FIVE YEAR PROFILING"]
[]
[null,"Water resources"]
[null,null,null,null,{"$f":"InpOverride!E$121","v":"Allowed capex and opex override switch - WR"},{"$f":"InpOverride!F$121","v":1},{"$f":"InpOverride!G$121","v":"2 = Override, 1 = Calculated in opex/capex model"}]
[null,null,null,null,{"$f":"InpOverride!E$100","v":"Capex profile - WR"},{"$f":"InpOverride!F$100","v":0},{"$f":"InpOverride!G$100","v":"%"},{"$f":"InpOverride!H$100","v":0.26212181627212522},{"$f":"InpOverride!I$100","v":0},{"$f":"InpOverride!J$100","v":0},{"$f":"InpOverride!K$100","v":6.0206900088681403E-2},{"$f":"InpOverride!L$100","v":6.7608348788400802E-2},{"$f":"InpOverride!M$100","v":5.6088066870347002E-2},{"$f":"InpOverride!N$100","v":4.3091090183772399E-2},{"$f":"InpOverride!O$100","v":3.51274103409236E-2},{"$f":"InpOverride!P$100","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$101","v":"Opex profile - WR"},{"$f":"InpOverride!F$101","v":0},{"$f":"InpOverride!G$101","v":"%"},{"$f":"InpOverride!H$101","v":0.73787818372787506},{"$f":"InpOverride!I$101","v":0},{"$f":"InpOverride!J$101","v":0},{"$f":"InpOverride!K$101","v":0.14650553256909199},{"$f":"InpOverride!L$101","v":0.14732690783643601},{"$f":"InpOverride!M$101","v":0.14755123839056},{"$f":"InpOverride!N$101","v":0.14796354029450201},{"$f":"InpOverride!O$101","v":0.14853096463728499},{"$f":"InpOverride!P$101","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$122","v":"Override capex - water resources "},{"$f":"InpOverride!F$122","v":0},{"$f":"InpOverride!G$122","v":"£m"},{"$f":"InpOverride!H$122","v":0},{"$f":"InpOverride!I$122","v":0},{"$f":"InpOverride!J$122","v":0},{"$f":"InpOverride!K$122","v":0},{"$f":"InpOverride!L$122","v":0},{"$f":"InpOverride!M$122","v":0},{"$f":"InpOverride!N$122","v":0},{"$f":"InpOverride!O$122","v":0},{"$f":"InpOverride!P$122","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$123","v":"Override opex - water resources"},{"$f":"InpOverride!F$123","v":0},{"$f":"InpOverride!G$123","v":"£m"},{"$f":"InpOverride!H$123","v":0},{"$f":"InpOverride!I$123","v":0},{"$f":"InpOverride!J$123","v":0},{"$f":"InpOverride!K$123","v":0},{"$f":"InpOverride!L$123","v":0},{"$f":"InpOverride!M$123","v":0},{"$f":"InpOverride!N$123","v":0},{"$f":"InpOverride!O$123","v":0},{"$f":"InpOverride!P$123","v":0}]
[]
[null,null,null,null,"Water resources - Capex - Active",null,"£m",{"$f":"SUM(J18:P18)","v":0.26212181627212522},null,{"$f":"CHOOSE($F$11,J12,J15)","v":0},{"$f":"CHOOSE($F$11,K12,K15)","v":6.0206900088681403E-2},{"$f":"CHOOSE($F$11,L12,L15)","v":6.7608348788400802E-2},{"$f":"CHOOSE($F$11,M12,M15)","v":5.6088066870347002E-2},4.3091090183772399E-2,3.51274103409236E-2,0]
[null,null,null,null,"Water resources - Opex - Active",null,"£m",{"$f":"SUM(J19:P19)","v":0.73787818372787506},null,{"$f":"CHOOSE($F$11,J13,J16)","v":0},0.14650553256909199,0.14732690783643601,0.14755123839056,0.14796354029450201,0.14853096463728499,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$32","v":"WR - Other costs not subject to cost sharing excl PDR"},{"$f":"InpOverride!F$32","v":0},{"$f":"InpOverride!G$32","v":"£m"},{"$f":"InpOverride!H$32","v":0.98250000000000004},{"$f":"InpOverride!I$32","v":0},{"$f":"InpOverride!J$32","v":0},{"$f":"InpOverride!K$32","v":0.19650000000000001},{"$f":"InpOverride!L$32","v":0.19650000000000001},{"$f":"InpOverride!M$32","v":0.19650000000000001},{"$f":"InpOverride!N$32","v":0.19650000000000001},{"$f":"InpOverride!O$32","v":0.19650000000000001},{"$f":"InpOverride!P$32","v":0}]
[null,null,null,null,"Water resources - Other costs not subject to cost sharing excl PDR",{"$f":" H$21","v":0.98250000000000004},"£m"]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$61","v":"Water resources - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F$61","v":73.952450218785501},{"$f":"'Ex-ante allowances'!G$61","v":"£m"}]
[null,null,null,null,"Water resources - total cost allowance including ex-ante cost sharing and third party costs",{"$f":" SUM(F22:F23)","v":74.934950218785502},"£m"]
[]
[null,null,null,null,{"$f":"E$24","v":"Water resources - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":"F$24","v":74.934950218785502},"£m"]
[null,null,null,null,{"$f":" E$18","v":"Water resources - Capex - Active"},0,"£m",0.26212181627212522,0,0,{"$f":" K$18","v":6.0206900088681403E-2},{"$f":" L$18","v":6.7608348788400802E-2},5.6088066870347002E-2,4.3091090183772399E-2,3.51274103409236E-2,0]
[null,null,null,null,{"$f":" E$19","v":"Water resources - Opex - Active"},{"$f":" F$19","v":0},"£m",0.73787818372787506,0,0,0.14650553256909199,0.14732690783643601,0.14755123839056,0.14796354029450201,0.14853096463728499,0]
[null,null,null,null,{"$f":"Time!E$54","v":"Forecast Period Flag"},{"$f":"Time!F$54","v":0},{"$f":"Time!G$54","v":"flag"},{"$f":"Time!H$54","v":5},{"$f":"Time!I$54","v":0},{"$f":"Time!J$54","v":0},{"$f":"Time!K$54","v":1},{"$f":"Time!L$54","v":1},{"$f":"Time!M$54","v":1},{"$f":"Time!N$54","v":1},{"$f":"Time!O$54","v":1},{"$f":"Time!P$54","v":0}]
[null,null,null,null,"Water resources - profiled total capex",null,"£m",{"$f":"SUM(J30:P30)","v":19.642085253609345},null,{"$f":"($F$26 * J27 / SUM($K$27:$O$28)) * J$29","v":0},{"$f":"($F$26 * K27 / SUM($K$27:$O$28)) * K$29","v":4.5116010609727333},{"$f":"($F$26 * L27 / SUM($K$27:$O$28)) * L$29","v":5.0662282508331016},4.2029564987973647,3.2290286977941811,2.6322707452119611,0]
[null,null,null,null,"Water resources - profiled total opex",null,"£m",55.292864965176172,null,{"$f":"($F$26 * J28 / SUM($K$27:$O$28)) * J$29","v":0},{"$f":"($F$26 * K28 / SUM($K$27:$O$28)) * K$29","v":10.978384789841567},11.039934504610931,11.056744703516767,11.087640526163771,11.13016044104314,0]
[]
[null,null,null,null,{"$f":" E$30","v":"Water resources - profiled total capex"},0,"£m",19.642085253609345,0,0,4.5116010609727333,5.0662282508331016,4.2029564987973647,3.2290286977941811,2.6322707452119611,0]
[null,null,null,null,{"$f":" E$31","v":"Water resources - profiled total opex"},{"$f":" F$31","v":0},"£m",55.292864965176172,0,0,10.978384789841567,11.039934504610931,11.056744703516767,11.087640526163771,11.13016044104314,0]
[null,null,null,null,"Water resources - profiled total expenditure",null,"£m",{"$f":" SUM(J35:P35)","v":74.934950218785517},null,{"$f":"SUM(J33:J34)","v":0},{"$f":"SUM(K33:K34)","v":15.4899858508143},16.106162755444032,15.259701202314131,14.316669223957952,13.762431186255101,0]
[null,null,null,null,"Water resources - profiled total expenditure including ex-ante cost sharing",{"$f":"SUM(K30:O31)","v":74.934950218785517},"£m"]
[]
[null,null,null,null,{"$f":"E$24","v":"Water resources - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":"F$24","v":74.934950218785502},{"$f":"G$24","v":"£m"}]
[null,null,null,null,{"$f":" E$36","v":"Water resources - profiled total expenditure including ex-ante cost sharing"},{"$f":" F$36","v":74.934950218785517},"£m"]
[null,null,null,null,"Water resources - profiled total expenditure check",{"$f":"IF(ABS(F38-F39) > ChK_Tol, 1, 0)","v":0},"check"]
[]
[null,"Water Network"]
[null,null,null,null,{"$f":"InpOverride!E$125","v":"Allowed capex and opex override switch - WN"},{"$f":"InpOverride!F$125","v":1},{"$f":"InpOverride!G$125","v":"2 = Override, 1 = Calculated in opex/capex model"}]
[null,null,null,null,{"$f":"InpOverride!E$104","v":"Capex profile - WN"},{"$f":"InpOverride!F$104","v":0},{"$f":"InpOverride!G$104","v":"%"},{"$f":"InpOverride!H$104","v":0.49280133706178464},{"$f":"InpOverride!I$104","v":0},{"$f":"InpOverride!J$104","v":0},{"$f":"InpOverride!K$104","v":7.8906221312502897E-2},{"$f":"InpOverride!L$104","v":9.4446052042378797E-2},{"$f":"InpOverride!M$104","v":0.113327239902731},{"$f":"InpOverride!N$104","v":0.105547430139538},{"$f":"InpOverride!O$104","v":0.100574393664634},{"$f":"InpOverride!P$104","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$105","v":"Opex profile - WN"},{"$f":"InpOverride!F$105","v":0},{"$f":"InpOverride!G$105","v":"%"},{"$f":"InpOverride!H$105","v":0.50719866293821403},{"$f":"InpOverride!I$105","v":0},{"$f":"InpOverride!J$105","v":0},{"$f":"InpOverride!K$105","v":0.102360417139246},{"$f":"InpOverride!L$105","v":0.102522050468316},{"$f":"InpOverride!M$105","v":0.101673548964828},{"$f":"InpOverride!N$105","v":0.100567031525459},{"$f":"InpOverride!O$105","v":0.10007561484036499},{"$f":"InpOverride!P$105","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$126","v":"Override capex - water network "},{"$f":"InpOverride!F$126","v":0},{"$f":"InpOverride!G$126","v":"£m"},{"$f":"InpOverride!H$126","v":0},{"$f":"InpOverride!I$126","v":0},{"$f":"InpOverride!J$126","v":0},{"$f":"InpOverride!K$126","v":0},{"$f":"InpOverride!L$126","v":0},{"$f":"InpOverride!M$126","v":0},{"$f":"InpOverride!N$126","v":0},{"$f":"InpOverride!O$126","v":0},{"$f":"InpOverride!P$126","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$127","v":"Override opex - water network "},{"$f":"InpOverride!F$127","v":0},{"$f":"InpOverride!G$127","v":"£m"},{"$f":"InpOverride!H$127","v":0},{"$f":"InpOverride!I$127","v":0},{"$f":"InpOverride!J$127","v":0},{"$f":"InpOverride!K$127","v":0},{"$f":"InpOverride!L$127","v":0},{"$f":"InpOverride!M$127","v":0},{"$f":"InpOverride!N$127","v":0},{"$f":"InpOverride!O$127","v":0},{"$f":"InpOverride!P$127","v":0}]
[]
[null,null,null,null,"Water network - Capex - Active",null,"£m",{"$f":"SUM(J50:P50)","v":0.49280133706178464},null,{"$f":"CHOOSE($F$43,J44,J47)","v":0},{"$f":"CHOOSE($F$43,K44,K47)","v":7.8906221312502897E-2},9.4446052042378797E-2,0.113327239902731,0.105547430139538,0.100574393664634,0]
[null,null,null,null,"Water network - Opex - Active",null,"£m",{"$f":"SUM(J51:P51)","v":0.50719866293821403},null,{"$f":"CHOOSE($F$43,J45,J48)","v":0},0.102360417139246,0.102522050468316,0.101673548964828,0.100567031525459,0.10007561484036499,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$41","v":"WN - Other costs not subject to cost sharing excl PDR"},{"$f":"InpOverride!F$41","v":0},{"$f":"InpOverride!G$41","v":"£m"},{"$f":"InpOverride!H$41","v":8.0638898280160003},{"$f":"InpOverride!I$41","v":0},{"$f":"InpOverride!J$41","v":0},{"$f":"InpOverride!K$41","v":1.6127779656032},{"$f":"InpOverride!L$41","v":1.6127779656032},{"$f":"InpOverride!M$41","v":1.6127779656032},{"$f":"InpOverride!N$41","v":1.6127779656032},{"$f":"InpOverride!O$41","v":1.6127779656032},{"$f":"InpOverride!P$41","v":0}]
[null,null,null,null,"Water network - Other costs not subject to cost sharing excl PDR",{"$f":" H$53","v":8.0638898280160003},"£m"]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$118","v":"Water network - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F$118","v":850.89037104923398},{"$f":"'Ex-ante allowances'!G$118","v":"£m"}]
[null,null,null,null,"Water network - total cost allowance including ex-ante cost sharing and third party costs",{"$f":" SUM(F54:F55)","v":858.95426087725002},"£m"]
[]
[null,null,null,null,{"$f":"E$56","v":"Water network - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":"F$56","v":858.95426087725002},"£m"]
[null,null,null,null,{"$f":" E$50","v":"Water network - Capex - Active"},{"$f":" F$50","v":0},"£m",0.49280133706178464,0,0,{"$f":" K$50","v":7.8906221312502897E-2},{"$f":" L$50","v":9.4446052042378797E-2},0.113327239902731,0.105547430139538,0.100574393664634,0]
[null,null,null,null,{"$f":" E$51","v":"Water network - Opex - Active"},{"$f":" F$51","v":0},"£m",0.50719866293821403,0,0,0.102360417139246,0.102522050468316,0.101673548964828,0.100567031525459,0.10007561484036499,0]
[null,null,null,null,{"$f":"Time!E$54","v":"Forecast Period Flag"},{"$f":"Time!F$54","v":0},{"$f":"Time!G$54","v":"flag"},{"$f":"Time!H$54","v":5},{"$f":"Time!I$54","v":0},{"$f":"Time!J$54","v":0},{"$f":"Time!K$54","v":1},{"$f":"Time!L$54","v":1},{"$f":"Time!M$54","v":1},{"$f":"Time!N$54","v":1},{"$f":"Time!O$54","v":1},{"$f":"Time!P$54","v":0}]
[null,null,null,null,"Water network - profiled total capex",null,"£m",{"$f":"SUM(J62:P62)","v":423.29380823522638},null,{"$f":"($F58 * J59 / SUM($K$59:$O$60)) * J$61","v":0},{"$f":"($F58 * K59 / SUM($K$59:$O$60)) * K$61","v":67.776835006097727},81.124838824835876,97.342915587909232,90.660414843000169,86.388803973383389,0]
[null,null,null,null,"Water network - profiled total opex",null,"£m",435.66045264202364,null,{"$f":"($F58 * J60 / SUM($K$59:$O$60)) * J$61","v":0},{"$f":"($F58 * K60 / SUM($K$59:$O$60)) * K$61","v":87.922916446928156},{"$f":"($F58 * L60 / SUM($K$59:$O$60)) * L$61","v":88.061752083632612},87.33292810185084,86.382480232569847,85.960375777042174,0]
[]
[null,null,null,null,{"$f":" E$62","v":"Water network - profiled total capex"},{"$f":" F$62","v":0},"£m",423.29380823522638,0,0,{"$f":" K$62","v":67.776835006097727},81.124838824835876,97.342915587909232,90.660414843000169,86.388803973383389,0]
[null,null,null,null,{"$f":" E$63","v":"Water network - profiled total opex"},{"$f":" F$63","v":0},"£m",435.66045264202364,0,0,87.922916446928156,88.061752083632612,87.33292810185084,86.382480232569847,85.960375777042174,0]
[null,null,null,null,"Water network - profiled total expenditure",null,"£m",{"$f":" SUM(J67:P67)","v":858.95426087724991},null,{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":155.6997514530259},{"$f":"SUM(L65:L66)","v":169.18659090846847},{"$f":"SUM(M65:M66)","v":184.67584368976009},{"$f":"SUM(N65:N66)","v":177.04289507557002},{"$f":"SUM(O65:O66)","v":172.34917975042555},{"$f":"SUM(P65:P66)","v":0}]
[null,null,null,null,"Water network - profiled total expenditure including ex-ante cost sharing",{"$f":"H67","v":858.95426087724991},"£m"]
[]
[null,null,null,null,{"$f":"E$56","v":"Water network - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":"F$56","v":858.95426087725002},"£m"]
[null,null,null,null,{"$f":"E$68","v":"Water network - profiled total expenditure including ex-ante cost sharing"},{"$f":"F$68","v":858.95426087724991},"£m"]
[null,null,null,null,"Water network - profiled total expenditure check",{"$f":"IF(ABS(F70-F71) > ChK_Tol, 1, 0)","v":0},"check"]
[]
[null,"Wastewater Network"]
[null,null,null,null,{"$f":"InpOverride!E$129","v":"Allowed capex and opex override switch - WWN"},{"$f":"InpOverride!F$129","v":1},{"$f":"InpOverride!G$129","v":"2 = Override, 1 = Calculated in opex/capex model"}]
[null,null,null,null,{"$f":"InpOverride!E$108","v":"Capex profile - WWN"},{"$f":"InpOverride!F$108","v":0},{"$f":"InpOverride!G$108","v":"%"},{"$f":"InpOverride!H$108","v":0.5377583005797697},{"$f":"InpOverride!I$108","v":0},{"$f":"InpOverride!J$108","v":0},{"$f":"InpOverride!K$108","v":0.12218989299973999},{"$f":"InpOverride!L$108","v":0.11901930778764799},{"$f":"InpOverride!M$108","v":0.102488078046585},{"$f":"InpOverride!N$108","v":0.103062966645073},{"$f":"InpOverride!O$108","v":9.0998055100723702E-2},{"$f":"InpOverride!P$108","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$109","v":"Opex profile - WNN"},{"$f":"InpOverride!F$109","v":0},{"$f":"InpOverride!G$109","v":"%"},{"$f":"InpOverride!H$109","v":0.46224169942022914},{"$f":"InpOverride!I$109","v":0},{"$f":"InpOverride!J$109","v":0},{"$f":"InpOverride!K$109","v":9.4110612596142104E-2},{"$f":"InpOverride!L$109","v":9.3698069343610399E-2},{"$f":"InpOverride!M$109","v":9.3018765008116802E-2},{"$f":"InpOverride!N$109","v":9.1223978172373099E-2},{"$f":"InpOverride!O$109","v":9.0190274299986703E-2},{"$f":"InpOverride!P$109","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$130","v":"Override capex - Wastewater network "},{"$f":"InpOverride!F$130","v":0},{"$f":"InpOverride!G$130","v":"£m"},{"$f":"InpOverride!H$130","v":0},{"$f":"InpOverride!I$130","v":0},{"$f":"InpOverride!J$130","v":0},{"$f":"InpOverride!K$130","v":0},{"$f":"InpOverride!L$130","v":0},{"$f":"InpOverride!M$130","v":0},{"$f":"InpOverride!N$130","v":0},{"$f":"InpOverride!O$130","v":0},{"$f":"InpOverride!P$130","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$131","v":"Override opex - Wastewater network "},{"$f":"InpOverride!F$131","v":0},{"$f":"InpOverride!G$131","v":"£m"},{"$f":"InpOverride!H$131","v":0},{"$f":"InpOverride!I$131","v":0},{"$f":"InpOverride!J$131","v":0},{"$f":"InpOverride!K$131","v":0},{"$f":"InpOverride!L$131","v":0},{"$f":"InpOverride!M$131","v":0},{"$f":"InpOverride!N$131","v":0},{"$f":"InpOverride!O$131","v":0},{"$f":"InpOverride!P$131","v":0}]
[]
[null,null,null,null,"Wastewater network - Capex - Active",null,"£m",{"$f":"SUM(J82:P82)","v":0.5377583005797697},null,{"$f":"CHOOSE($F$75,J76,J79)","v":0},{"$f":"CHOOSE($F$75,K76,K79)","v":0.12218989299973999},0.11901930778764799,0.102488078046585,0.103062966645073,9.0998055100723702E-2,0]
[null,null,null,null,"Wastewater network - Opex - Active",null,"£m",{"$f":"SUM(J83:P83)","v":0.46224169942022914},null,{"$f":"CHOOSE($F$75,J77,J80)","v":0},9.4110612596142104E-2,9.3698069343610399E-2,9.3018765008116802E-2,9.1223978172373099E-2,9.0190274299986703E-2,0]
[]
[null,null,null,null,{"$f":"InpOverride!E57","v":"WWN - Other costs not subject to cost sharing excl PDR"},{"$f":"InpOverride!F57","v":0},{"$f":"InpOverride!G57","v":"£m"},{"$f":"InpOverride!H57","v":7.7792492342241504},{"$f":"InpOverride!I57","v":0},{"$f":"InpOverride!J57","v":0},{"$f":"InpOverride!K57","v":1.5558498468448301},{"$f":"InpOverride!L57","v":1.5558498468448301},{"$f":"InpOverride!M57","v":1.5558498468448301},{"$f":"InpOverride!N57","v":1.5558498468448301},{"$f":"InpOverride!O57","v":1.5558498468448301},{"$f":"InpOverride!P57","v":0}]
[null,null,null,null,"Water network - Other costs not subject to cost sharing excl PDR",{"$f":" H$85","v":7.7792492342241504},"£m"]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E$171","v":"Wastewater Network - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F$171","v":828.71740271570854},{"$f":"'Ex-ante allowances'!G$171","v":"£m"}]
[null,null,null,null,"Wastewater network - total cost allowance including ex-ante cost sharing and third party costs",{"$f":" SUM(F86:F87)","v":836.4966519499327},"£m"]
[]
[null,null,null,null,{"$f":" E$88","v":"Wastewater network - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":" F$88","v":836.4966519499327},{"$f":" G$88","v":"£m"}]
[null,null,null,null,{"$f":" E$82","v":"Wastewater network - Capex - Active"},{"$f":" F$82","v":0},"£m",0.5377583005797697,0,0,0.12218989299973999,0.11901930778764799,0.102488078046585,0.103062966645073,9.0998055100723702E-2,0]
[null,null,null,null,{"$f":" E$83","v":"Wastewater network - Opex - Active"},{"$f":" F$83","v":0},"£m",0.46224169942022914,0,0,9.4110612596142104E-2,9.3698069343610399E-2,9.3018765008116802E-2,9.1223978172373099E-2,9.0190274299986703E-2,0]
[null,null,null,null,{"$f":"Time!E$54","v":"Forecast Period Flag"},{"$f":"Time!F$54","v":0},{"$f":"Time!G$54","v":"flag"},{"$f":"Time!H$54","v":5},{"$f":"Time!I$54","v":0},{"$f":"Time!J$54","v":0},{"$f":"Time!K$54","v":1},{"$f":"Time!L$54","v":1},{"$f":"Time!M$54","v":1},{"$f":"Time!N$54","v":1},{"$f":"Time!O$54","v":1},{"$f":"Time!P$54","v":0}]
[null,null,null,null,"Wastewater network - profiled total capex",null,"£m",{"$f":"SUM(J94:P94)","v":449.83301799326347},null,{"$f":"IF($F$90 = 0, 0,($F90 * J91 / SUM($K$91:$O$92)) * J$93)","v":0},{"$f":"IF($F$90 = 0, 0,($F90 * K91 / SUM($K$91:$O$92)) * K$93)","v":102.21143639640316},{"$f":"IF($F$90 = 0, 0,($F90 * L91 / SUM($K$91:$O$92)) * L$93)","v":99.559252481766222},85.730934150751864,86.211826538631271,76.119568425710966,0]
[null,null,null,null,"Wastewater network - profiled total opex",null,"£m",{"$f":"SUM(J95:P95)","v":386.66363395666929},null,{"$f":"IF($F$90 = 0, 0,($F90 * J92 / SUM($K$91:$O$92)) * J$93)","v":0},{"$f":"IF($F$90 = 0, 0,($F90 * K92 / SUM($K$91:$O$92)) * K$93)","v":78.723212349630131},{"$f":"IF($F$90 = 0, 0,($F90 * L92 / SUM($K$91:$O$92)) * L$93)","v":78.378121300102819},77.809885497807358,76.308552318743935,75.44386249038503,0]
[]
[null,null,null,null,{"$f":" E$94","v":"Wastewater network - profiled total capex"},0,"£m",{"$f":" H$94","v":449.83301799326347},0,0,{"$f":" K$94","v":102.21143639640316},{"$f":" L$94","v":99.559252481766222},85.730934150751864,86.211826538631271,76.119568425710966,0]
[null,null,null,null,{"$f":" E$95","v":"Wastewater network - profiled total opex"},0,"£m",386.66363395666929,0,0,{"$f":" K$95","v":78.723212349630131},{"$f":" L$95","v":78.378121300102819},77.809885497807358,76.308552318743935,75.44386249038503,0]
[null,null,null,null,"Wastewater network - profiled total expenditure",null,"£m",{"$f":" SUM(J99:P99)","v":836.49665194993281},null,{"$f":"SUM(J97:J98)","v":0},{"$f":"SUM(K97:K98)","v":180.9346487460333},{"$f":"SUM(L97:L98)","v":177.93737378186904},{"$f":"SUM(M97:M98)","v":163.54081964855922},{"$f":"SUM(N97:N98)","v":162.52037885737519},{"$f":"SUM(O97:O98)","v":151.563430916096},{"$f":"SUM(P97:P98)","v":0}]
[null,null,null,null,"Wastewater network - profiled total expenditure including ex-ante cost sharing",{"$f":"H99","v":836.49665194993281},"£m"]
[]
[null,null,null,null,{"$f":" E$88","v":"Wastewater network - total cost allowance including ex-ante cost sharing and third party costs"},{"$f":" F$88","v":836.4966519499327},{"$f":" G$88","v":"£m"}]
[null,null,null,null,{"$f":"E$100","v":"Wastewater network - profiled total expenditure including ex-ante cost sharing"},{"$f":"F$100","v":836.49665194993281},{"$f":"G$100","v":"£m"}]
[null,null,null,null,"Wastewater network - profiled total expenditure check",{"$f":"IF(ABS(F102-F103) > ChK_Tol, 1, 0)","v":0},"check"]
[]
[null,"Bioresources"]
[null,null,null,null,{"$f":"InpOverride!E$133","v":"Allowed capex and opex override switch - BIO"},{"$f":"InpOverride!F$133","v":1},{"$f":"InpOverride!G$133","v":"2 = Override, 1 = Calculated in opex/capex model"}]
[null,null,null,null,{"$f":"InpOverride!E$112","v":"Capex profile - BR"},{"$f":"InpOverride!F$112","v":0},{"$f":"InpOverride!G$112","v":"%"},{"$f":"InpOverride!H$112","v":0.24860523039598692},{"$f":"InpOverride!I$112","v":0},{"$f":"InpOverride!J$112","v":0},{"$f":"InpOverride!K$112","v":4.8025725802973901E-2},{"$f":"InpOverride!L$112","v":4.9214914951125503E-2},{"$f":"InpOverride!M$112","v":5.2474157594849802E-2},{"$f":"InpOverride!N$112","v":5.0837664421742201E-2},{"$f":"InpOverride!O$112","v":4.8052767625295499E-2},{"$f":"InpOverride!P$112","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$113","v":"Opex profile - BR"},{"$f":"InpOverride!F$113","v":0},{"$f":"InpOverride!G$113","v":"%"},{"$f":"InpOverride!H$113","v":0.75139476960401297},{"$f":"InpOverride!I$113","v":0},{"$f":"InpOverride!J$113","v":0},{"$f":"InpOverride!K$113","v":0.14895780284361901},{"$f":"InpOverride!L$113","v":0.150541517068634},{"$f":"InpOverride!M$113","v":0.15030187610037499},{"$f":"InpOverride!N$113","v":0.15045816368837001},{"$f":"InpOverride!O$113","v":0.15113540990301499},{"$f":"InpOverride!P$113","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$134","v":"Override capex - Bioresources "},{"$f":"InpOverride!F$134","v":0},{"$f":"InpOverride!G$134","v":"£m"},{"$f":"InpOverride!H$134","v":0},{"$f":"InpOverride!I$134","v":0},{"$f":"InpOverride!J$134","v":0},{"$f":"InpOverride!K$134","v":0},{"$f":"InpOverride!L$134","v":0},{"$f":"InpOverride!M$134","v":0},{"$f":"InpOverride!N$134","v":0},{"$f":"InpOverride!O$134","v":0},{"$f":"InpOverride!P$134","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$135","v":"Override opex - Bioresources "},{"$f":"InpOverride!F$135","v":0},{"$f":"InpOverride!G$135","v":"£m"},{"$f":"InpOverride!H$135","v":0},{"$f":"InpOverride!I$135","v":0},{"$f":"InpOverride!J$135","v":0},{"$f":"InpOverride!K$135","v":0},{"$f":"InpOverride!L$135","v":0},{"$f":"InpOverride!M$135","v":0},{"$f":"InpOverride!N$135","v":0},{"$f":"InpOverride!O$135","v":0},{"$f":"InpOverride!P$135","v":0}]
[]
[null,null,null,null,"Bioresources - Capex - Active",null,"£m",{"$f":"SUM(J114:P114)","v":0.24860523039598692},null,{"$f":"CHOOSE($F$107,J108,J111)","v":0},{"$f":"CHOOSE($F$107,K108,K111)","v":4.8025725802973901E-2},4.9214914951125503E-2,5.2474157594849802E-2,5.0837664421742201E-2,4.8052767625295499E-2,0]
[null,null,null,null,"Bioresources - Opex - Active",null,"£m",{"$f":"SUM(J115:P115)","v":0.75139476960401297},null,{"$f":"CHOOSE($F$107,J109,J112)","v":0},0.14895780284361901,0.150541517068634,0.15030187610037499,0.15045816368837001,0.15113540990301499,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$63","v":"Efficient totex for cost sharing bioresources £m"},{"$f":"InpOverride!F$63","v":0},{"$f":"InpOverride!G$63","v":"£m"},{"$f":"InpOverride!H$63","v":92.876588685309514},{"$f":"InpOverride!I$63","v":0},{"$f":"InpOverride!J$63","v":0},{"$f":"InpOverride!K$63","v":18.575317737061901},{"$f":"InpOverride!L$63","v":18.575317737061901},{"$f":"InpOverride!M$63","v":18.575317737061901},{"$f":"InpOverride!N$63","v":18.575317737061901},{"$f":"InpOverride!O$63","v":18.575317737061901},{"$f":"InpOverride!P$63","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$67","v":"BR - Other costs not subject to cost sharing excl PDR"},{"$f":"InpOverride!F$67","v":0},{"$f":"InpOverride!G$67","v":"£m"},{"$f":"InpOverride!H$67","v":0},{"$f":"InpOverride!I$67","v":0},{"$f":"InpOverride!J$67","v":0},{"$f":"InpOverride!K$67","v":0},{"$f":"InpOverride!L$67","v":0},{"$f":"InpOverride!M$67","v":0},{"$f":"InpOverride!N$67","v":0},{"$f":"InpOverride!O$67","v":0},{"$f":"InpOverride!P$67","v":0}]
[null,null,null,null,"Bioresources - Ofwat Baseline Total Gross Totex including third party costs - Real",null,"£m",{"$f":"SUM(J119:P119)","v":92.876588685309514},null,{"$f":"SUM(J117:J118)","v":0},18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901,0]
[]
[null,null,null,null,{"$f":"E$119","v":"Bioresources - Ofwat Baseline Total Gross Totex including third party costs - Real"},{"$f":"F$119","v":0},"£m",92.876588685309514,0,0,18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901,18.575317737061901,0]
[null,null,null,null,{"$f":"InpOverride!E69","v":"BR operating lease adjustment"},{"$f":"InpOverride!F69","v":0},{"$f":"InpOverride!G69","v":"£m"},{"$f":"InpOverride!H69","v":0},{"$f":"InpOverride!I69","v":0},{"$f":"InpOverride!J69","v":0},{"$f":"InpOverride!K69","v":0},{"$f":"InpOverride!L69","v":0},{"$f":"InpOverride!M69","v":0},{"$f":"InpOverride!N69","v":0},{"$f":"InpOverride!O69","v":0},{"$f":"InpOverride!P69","v":0}]
[null,null,null,null,"Bioresources - Ofwat Baseline Total Gross Totex inc 3rd party and operating lease adj- Real",{"$f":" SUM($H$121:$H$122)","v":92.876588685309514},"£m"]
[]
[null,null,null,null,{"$f":"E$123","v":"Bioresources - Ofwat Baseline Total Gross Totex inc 3rd party and operating lease adj- Real"},{"$f":"F$123","v":92.876588685309514},{"$f":"G$123","v":"£m"}]
[null,null,null,null,{"$f":" E$114","v":"Bioresources - Capex - Active"},{"$f":" F$114","v":0},"£m",0.24860523039598692,0,{"$f":" J$114","v":0},{"$f":" K$114","v":4.8025725802973901E-2},{"$f":" L$114","v":4.9214914951125503E-2},5.2474157594849802E-2,5.0837664421742201E-2,4.8052767625295499E-2,0]
[null,null,null,null,{"$f":" E$115","v":"Bioresources - Opex - Active"},{"$f":" F$115","v":0},"£m",0.75139476960401297,0,{"$f":" J$115","v":0},{"$f":" K$115","v":0.14895780284361901},0.150541517068634,0.15030187610037499,0.15045816368837001,0.15113540990301499,0]
[null,null,null,null,{"$f":"Time!E$54","v":"Forecast Period Flag"},{"$f":"Time!F$54","v":0},{"$f":"Time!G$54","v":"flag"},{"$f":"Time!H$54","v":5},{"$f":"Time!I$54","v":0},{"$f":"Time!J$54","v":0},{"$f":"Time!K$54","v":1},{"$f":"Time!L$54","v":1},{"$f":"Time!M$54","v":1},{"$f":"Time!N$54","v":1},{"$f":"Time!O$54","v":1},{"$f":"Time!P$54","v":0}]
[null,null,null,null,"Bioresources - profiled total capex",null,"£m",{"$f":"SUM(J129:P129)","v":23.089605728504687},null,{"$f":"IF($F$125 = 0, 0,($F125 * J126 / SUM($K$126:$O$127)) * J$128)","v":0},{"$f":"IF($F$125 = 0, 0,($F125 * K126 / SUM($K$126:$O$127)) * K$128)","v":4.4604655817162637},{"$f":"IF($F$125 = 0, 0,($F125 * L126 / SUM($K$126:$O$127)) * L$128)","v":4.5709134130981735},4.8736207515449763,4.7216288482199449,4.4629771339253281,0]
[null,null,null,null,"Bioresources - profiled total opex",null,"£m",69.786982956804835,null,{"$f":"IF($F$125 = 0, 0,($F125 * J127 / SUM($K$126:$O$127)) * J$128)","v":0},{"$f":"IF($F$125 = 0, 0,($F125 * K127 / SUM($K$126:$O$127)) * K$128)","v":13.834692586174233},13.981782560846023,13.959525525204882,13.974040983231713,14.03694130134798,0]
[]
[null,null,null,null,{"$f":" E$129","v":"Bioresources - profiled total capex"},0,"£m",23.089605728504687,0,{"$f":" J$129","v":0},4.4604655817162637,4.5709134130981735,4.8736207515449763,4.7216288482199449,4.4629771339253281,0]
[null,null,null,null,{"$f":" E$130","v":"Bioresources - profiled total opex"},0,"£m",69.786982956804835,0,{"$f":" J$130","v":0},{"$f":" K$130","v":13.834692586174233},13.981782560846023,13.959525525204882,13.974040983231713,14.03694130134798,0]
[null,null,null,null,"Bioresources - profiled total expenditure",null,"£m",{"$f":" SUM(J134:P134)","v":92.876588685309514},null,{"$f":"SUM(J132:J133)","v":0},{"$f":"SUM(K132:K133)","v":18.295158167890499},{"$f":"SUM(L132:L133)","v":18.552695973944196},{"$f":"SUM(M132:M133)","v":18.833146276749858},{"$f":"SUM(N132:N133)","v":18.69566983145166},{"$f":"SUM(O132:O133)","v":18.499918435273308},{"$f":"SUM(P132:P133)","v":0}]
[null,null,null,null,"Bioresources - profiled total expenditure including ex-ante cost sharing",{"$f":"H134","v":92.876588685309514},"£m"]
[]
[null,null,null,null,{"$f":"E$123","v":"Bioresources - Ofwat Baseline Total Gross Totex inc 3rd party and operating lease adj- Real"},{"$f":"F$123","v":92.876588685309514},{"$f":"G$123","v":"£m"}]
[null,null,null,null,{"$f":"E$135","v":"Bioresources - profiled total expenditure including ex-ante cost sharing"},{"$f":"F$135","v":92.876588685309514},{"$f":"G$135","v":"£m"}]
[null,null,null,null,"Bioresources - profiled total expenditure check",{"$f":"IF(ABS(F137-F138) > ChK_Tol, 1, 0)","v":0},"check"]
[]
[null,"Dummy control"]
[null,null,null,null,{"$f":"InpOverride!E$137","v":"Allowed capex and opex override switch - DMMY"},{"$f":"InpOverride!F$137","v":1},{"$f":"InpOverride!G$137","v":"2 = Override, 1 = Calculated in opex/capex model"}]
[null,null,null,null,{"$f":"InpOverride!E116","v":"Capex profile - DMMY"},{"$f":"InpOverride!F116","v":0},{"$f":"InpOverride!G116","v":"%"},{"$f":"InpOverride!H116","v":0},{"$f":"InpOverride!I116","v":0},{"$f":"InpOverride!J116","v":0},{"$f":"InpOverride!K116","v":0},{"$f":"InpOverride!L116","v":0},{"$f":"InpOverride!M116","v":0},{"$f":"InpOverride!N116","v":0},{"$f":"InpOverride!O116","v":0},{"$f":"InpOverride!P116","v":0}]
[null,null,null,null,{"$f":"InpOverride!E117","v":"Opex profile - DMMY"},{"$f":"InpOverride!F117","v":0},{"$f":"InpOverride!G117","v":"%"},{"$f":"InpOverride!H117","v":0},{"$f":"InpOverride!I117","v":0},{"$f":"InpOverride!J117","v":0},{"$f":"InpOverride!K117","v":0},{"$f":"InpOverride!L117","v":0},{"$f":"InpOverride!M117","v":0},{"$f":"InpOverride!N117","v":0},{"$f":"InpOverride!O117","v":0},{"$f":"InpOverride!P117","v":0}]
[]
[null,null,null,null,{"$f":"InpOverride!E$138","v":"Override capex - Dummy "},{"$f":"InpOverride!F$138","v":0},{"$f":"InpOverride!G$138","v":"£m"},{"$f":"InpOverride!H$138","v":0},{"$f":"InpOverride!I$138","v":0},{"$f":"InpOverride!J$138","v":0},{"$f":"InpOverride!K$138","v":0},{"$f":"InpOverride!L$138","v":0},{"$f":"InpOverride!M$138","v":0},{"$f":"InpOverride!N$138","v":0},{"$f":"InpOverride!O$138","v":0},{"$f":"InpOverride!P$138","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$139","v":"Override opex - Dummy "},{"$f":"InpOverride!F$139","v":0},{"$f":"InpOverride!G$139","v":"£m"},{"$f":"InpOverride!H$139","v":0},{"$f":"InpOverride!I$139","v":0},{"$f":"InpOverride!J$139","v":0},{"$f":"InpOverride!K$139","v":0},{"$f":"InpOverride!L$139","v":0},{"$f":"InpOverride!M$139","v":0},{"$f":"InpOverride!N$139","v":0},{"$f":"InpOverride!O$139","v":0},{"$f":"InpOverride!P$139","v":0}]
[]
[null,null,null,null,"Dummy - Capex - Active",null,"£m",{"$f":"SUM(J149:P149)","v":0},null,{"$f":"CHOOSE($F$142,J143,J146)","v":0},{"$f":"CHOOSE($F$142,K143,K146)","v":0},0,0,0,0,0]
[null,null,null,null,"Dummy - Opex - Active",null,"£m",{"$f":"SUM(J150:P150)","v":0},null,{"$f":"CHOOSE($F$142,J144,J147)","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"InpOverride!E$73","v":"Final cost allowance for cost sharing for WWW Dummy £m"},{"$f":"InpOverride!F$73","v":0},{"$f":"InpOverride!G$73","v":"£m"},{"$f":"InpOverride!H$73","v":0},{"$f":"InpOverride!I$73","v":0},{"$f":"InpOverride!J$73","v":0},{"$f":"InpOverride!K$73","v":0},{"$f":"InpOverride!L$73","v":0},{"$f":"InpOverride!M$73","v":0},{"$f":"InpOverride!N$73","v":0},{"$f":"InpOverride!O$73","v":0},{"$f":"InpOverride!P$73","v":0}]
[null,null,null,null,{"$f":"InpOverride!E$77","v":"DMMY - Other costs not subject to cost sharing excl PDR"},{"$f":"InpOverride!F$77","v":0},{"$f":"InpOverride!G$77","v":"£m"},{"$f":"InpOverride!H$77","v":0},{"$f":"InpOverride!I$77","v":0},{"$f":"InpOverride!J$77","v":0},{"$f":"InpOverride!K$77","v":0},{"$f":"InpOverride!L$77","v":0},{"$f":"InpOverride!M$77","v":0},{"$f":"InpOverride!N$77","v":0},{"$f":"InpOverride!O$77","v":0},{"$f":"InpOverride!P$77","v":0}]
[null,null,null,null,"Dummy - Ofwat Baseline Total Gross Totex including third party costs - Real",null,"£m",{"$f":"SUM(J154:P154)","v":0},null,{"$f":"SUM(J152:J153)","v":0},{"$f":"SUM(K152:K153)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":"E$154","v":"Dummy - Ofwat Baseline Total Gross Totex including third party costs - Real"},{"$f":"F$154","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"InpOverride!E79","v":"DMMY operating lease adjustment"},{"$f":"InpOverride!F79","v":0},{"$f":"InpOverride!G79","v":"£m"},{"$f":"InpOverride!H79","v":0},{"$f":"InpOverride!I79","v":0},{"$f":"InpOverride!J79","v":0},{"$f":"InpOverride!K79","v":0},{"$f":"InpOverride!L79","v":0},{"$f":"InpOverride!M79","v":0},{"$f":"InpOverride!N79","v":0},{"$f":"InpOverride!O79","v":0},{"$f":"InpOverride!P79","v":0}]
[null,null,null,null,"Dummy - Ofwat Baseline Total Gross Totex - Real",{"$f":"SUM($H$156:$H$157)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$158","v":"Dummy - Ofwat Baseline Total Gross Totex - Real"},{"$f":"F$158","v":0},{"$f":"G$158","v":"£m"}]
[null,null,null,null,{"$f":" E$149","v":"Dummy - Capex - Active"},{"$f":" F$149","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$150","v":"Dummy - Opex - Active"},{"$f":" F$150","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"Time!E$54","v":"Forecast Period Flag"},{"$f":"Time!F$54","v":0},{"$f":"Time!G$54","v":"flag"},{"$f":"Time!H$54","v":5},{"$f":"Time!I$54","v":0},{"$f":"Time!J$54","v":0},{"$f":"Time!K$54","v":1},{"$f":"Time!L$54","v":1},{"$f":"Time!M$54","v":1},{"$f":"Time!N$54","v":1},{"$f":"Time!O$54","v":1},{"$f":"Time!P$54","v":0}]
[null,null,null,null,"Dummy - profiled total capex",null,"£m",{"$f":"SUM(J164:P164)","v":0},null,{"$f":"IF($F160 = 0, 0,($F160 * J161 / SUM($K$161:$O$162))) *J$163","v":0},{"$f":"IF($F160 = 0, 0,($F160 * K161 / SUM($K$161:$O$162))) *K$163","v":0},0,0,0,0,0]
[null,null,null,null,"Dummy - profiled total opex",null,"£m",0,null,{"$f":"IF($F$160 = 0, 0,($F160 * J162 / SUM($K$161:$O$162))) *J$163","v":0},{"$f":"IF($F$160 = 0, 0,($F160 * K162 / SUM($K$161:$O$162))) *K$163","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$164","v":"Dummy - profiled total capex"},0,"£m",0,0,0,{"$f":" K$164","v":0},0,0,0,0,0]
[null,null,null,null,{"$f":" E$165","v":"Dummy - profiled total opex"},0,"£m",0,0,0,{"$f":" K$165","v":0},0,0,0,0,0]
[null,null,null,null,"Dummy - profiled total expenditure",null,"£m",{"$f":" SUM(J169:P169)","v":0},null,{"$f":"SUM(J167:J168)","v":0},{"$f":"SUM(K167:K168)","v":0},{"$f":"SUM(L167:L168)","v":0},0,0,0,0]
[null,null,null,null,"Dummy - profiled total expenditure including ex-ante cost sharing",{"$f":"H169","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$158","v":"Dummy - Ofwat Baseline Total Gross Totex - Real"},{"$f":"F$158","v":0},{"$f":"G$158","v":"£m"}]
[null,null,null,null,{"$f":"E$170","v":"Dummy - profiled total expenditure including ex-ante cost sharing"},{"$f":"F$170","v":0},{"$f":"G$170","v":"£m"}]
[null,null,null,null,"Dummy - profiled total expenditure check",{"$f":"IF(ABS(F172-F173) > ChK_Tol, 1, 0)","v":0},"check"]
[]
["END OF SHEET"]

{"sheet":"Outputs-->","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"F_Outputs","index":13,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19CostSharOut2"]
["Acronym","Reference","Item description","Unit","Model","2020-21","2021-22","2022-23","2023-24","2024-25","2020-25"]
[]
[null,"C_WR_PR19FM008","Final cost allowance for Water Resources - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K35","v":15.4899858508143},{"$f":"'Cost profiling'!L35","v":16.106162755444032},{"$f":"'Cost profiling'!M35","v":15.259701202314131},{"$f":"'Cost profiling'!N35","v":14.316669223957952},{"$f":"'Cost profiling'!O35","v":13.762431186255101}]
[null,"C_NPW_PR19FM008","Final cost allowance for Network Plus Water - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K67","v":155.6997514530259},{"$f":"'Cost profiling'!L67","v":169.18659090846847},{"$f":"'Cost profiling'!M67","v":184.67584368976009},{"$f":"'Cost profiling'!N67","v":177.04289507557002},{"$f":"'Cost profiling'!O67","v":172.34917975042555}]
[null,"C_WW_PR19FM008","Final cost allowance for Wholesale Water - including cost sharing","£m","Price Review 2019",{"$f":"F5+F4","v":171.18973730384019},{"$f":"G5+G4","v":185.29275366391249},199.9355448920742,191.35956429952796,186.11161093668065]
[null,"C_WROPEXFM_PR19FM008","WR - Total gross operational expenditure -real - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K31","v":10.978384789841567},{"$f":"'Cost profiling'!L31","v":11.039934504610931},{"$f":"'Cost profiling'!M31","v":11.056744703516767},{"$f":"'Cost profiling'!N31","v":11.087640526163771},{"$f":"'Cost profiling'!O31","v":11.13016044104314}]
[null,"C_WRCAPEXFM_PR19FM008","WR - Total gross capital expenditure - real (including g&c) - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K30","v":4.5116010609727333},{"$f":"'Cost profiling'!L30","v":5.0662282508331016},{"$f":"'Cost profiling'!M30","v":4.2029564987973647},{"$f":"'Cost profiling'!N30","v":3.2290286977941811},{"$f":"'Cost profiling'!O30","v":2.6322707452119611}]
[null,"C_WRTOTEXFM_PR19FM008","WR - Total gross totex - real - including cost sharing","£m","Price Review 2019",{"$f":"F8+F7","v":15.4899858508143},{"$f":"G8+G7","v":16.106162755444032},15.259701202314131,14.316669223957952,13.762431186255101]
[null,"C_WNOPEXFM_PR19FM008","WN - Total gross operational expenditure -real - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K63","v":87.922916446928156},{"$f":"'Cost profiling'!L63","v":88.061752083632612},{"$f":"'Cost profiling'!M63","v":87.33292810185084},{"$f":"'Cost profiling'!N63","v":86.382480232569847},{"$f":"'Cost profiling'!O63","v":85.960375777042174}]
[null,"C_WNCAPEXFM_PR19FM008","WN - Total gross capital expenditure - real - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K62","v":67.776835006097727},{"$f":"'Cost profiling'!L62","v":81.124838824835876},{"$f":"'Cost profiling'!M62","v":97.342915587909232},{"$f":"'Cost profiling'!N62","v":90.660414843000169},{"$f":"'Cost profiling'!O62","v":86.388803973383389}]
[null,"C_WNTOTEXFM_PR19FM008","WN - Total gross totex - real (including g&c) - including cost sharing","£m","Price Review 2019",{"$f":"F11+F10","v":155.6997514530259},{"$f":"G11+G10","v":169.18659090846847},184.67584368976009,177.04289507557002,172.34917975042555]
[null,"C_WWN_PR19FM008","Final cost allowance for Network Plus Wastewater - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K99","v":180.9346487460333},{"$f":"'Cost profiling'!L99","v":177.93737378186904},{"$f":"'Cost profiling'!M99","v":163.54081964855922},{"$f":"'Cost profiling'!N99","v":162.52037885737519},{"$f":"'Cost profiling'!O99","v":151.563430916096}]
[null,"C_WWNOPEXFM_PR19FM008","WWN - Total gross operational expenditure - real - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K98","v":78.723212349630131},{"$f":"'Cost profiling'!L98","v":78.378121300102819},{"$f":"'Cost profiling'!M98","v":77.809885497807358},{"$f":"'Cost profiling'!N98","v":76.308552318743935},{"$f":"'Cost profiling'!O98","v":75.44386249038503}]
[null,"C_WWNCAPEXFM_PR19FM008","WWN - Total gross capital expenditure - real - including cost sharing","£m","Price Review 2019",{"$f":"'Cost profiling'!K97","v":102.21143639640316},{"$f":"'Cost profiling'!L97","v":99.559252481766222},{"$f":"'Cost profiling'!M97","v":85.730934150751864},{"$f":"'Cost profiling'!N97","v":86.211826538631271},{"$f":"'Cost profiling'!O97","v":76.119568425710966}]
[null,"C_BROPEXFM_PR19FM008","BIO - Total gross operational expenditure -real","£m","Price Review 2019",{"$f":"'Cost profiling'!K130","v":13.834692586174233},{"$f":"'Cost profiling'!L130","v":13.981782560846023},{"$f":"'Cost profiling'!M130","v":13.959525525204882},{"$f":"'Cost profiling'!N130","v":13.974040983231713},{"$f":"'Cost profiling'!O130","v":14.03694130134798}]
[null,"C_BRCAPEXFM_PR19FM008","BIO - Total gross capital expenditure - real (including g&c)","£m","Price Review 2019",{"$f":"'Cost profiling'!K129","v":4.4604655817162637},{"$f":"'Cost profiling'!L129","v":4.5709134130981735},{"$f":"'Cost profiling'!M129","v":4.8736207515449763},{"$f":"'Cost profiling'!N129","v":4.7216288482199449},{"$f":"'Cost profiling'!O129","v":4.4629771339253281}]
[null,"C_BRTOTEXFM_PR19FM008","BIO - Total gross totex - real","£m","Price Review 2019",{"$f":"'Cost profiling'!K134","v":18.295158167890499},{"$f":"'Cost profiling'!L134","v":18.552695973944196},{"$f":"'Cost profiling'!M134","v":18.833146276749858},{"$f":"'Cost profiling'!N134","v":18.69566983145166},{"$f":"'Cost profiling'!O134","v":18.499918435273308}]
[null,"C_DUMMYOPEXFM_PR19FM008","Dummy - profiled total opex","£m","Price Review 2019",{"$f":"'Cost profiling'!K165","v":0},{"$f":"'Cost profiling'!L165","v":0},{"$f":"'Cost profiling'!M165","v":0},{"$f":"'Cost profiling'!N165","v":0},{"$f":"'Cost profiling'!O165","v":0}]
[null,"C_DUMMYCAPEXFM_PR19FM008","Dummy - profiled total capex","£m","Price Review 2019",{"$f":"'Cost profiling'!K164","v":0},{"$f":"'Cost profiling'!L164","v":0},{"$f":"'Cost profiling'!M164","v":0},{"$f":"'Cost profiling'!N164","v":0},{"$f":"'Cost profiling'!O164","v":0}]
[null,"C_DUMMYTOTEXFM_PR19FM008","Dummy - profiled total expenditure","£m","Price Review 2019",{"$f":"'Cost profiling'!K169","v":0},{"$f":"'Cost profiling'!L169","v":0},{"$f":"'Cost profiling'!M169","v":0},{"$f":"'Cost profiling'!N169","v":0},{"$f":"'Cost profiling'!O169","v":0}]
[null,"C_WR_CS_EXANTE_001",{"$f":" 'Ex-ante allowances'!$E$46 & \" - Water Resources\"","v":"Ex-ante allowance above Ofwat forecast  - Water Resources"},"£m","Price Review 2019",null,null,null,null,null,{"$f":" 'Ex-ante allowances'!$F$50","v":0}]
[null,"C_WN_CS_EXANTE_001",{"$f":" 'Ex-ante allowances'!$E$103","v":"Ex-ante allowance above Ofwat forecast - Water Network"},"£m","Price Review 2019",null,null,null,null,null,{"$f":" 'Ex-ante allowances'!$F$107","v":0}]
[null,"C_WWN_CS_EXANTE_001",{"$f":" 'Ex-ante allowances'!$E$156","v":"Ex-ante allowance above Ofwat forecast- Wastewater Network"},"£m","Price Review 2019",null,null,null,null,null,{"$f":" 'Ex-ante allowances'!$F$160","v":0}]
[null,"C_WR_WN_OUTPERFORM_001",{"$f":"'Dashboard - WR + WN'!B51","v":"Cost sharing rate for outperform"},{"$f":"'Dashboard - WR + WN'!D51","v":"%"},"Price Review 2019",null,null,null,null,null,{"$f":"'Dashboard - WR + WN'!C51","v":0.5}]
[null,"C_WR_WN_UNDERPERFORM_001",{"$f":"'Dashboard - WR + WN'!B52","v":"Cost sharing rate for underperform"},{"$f":"'Dashboard - WR + WN'!D52","v":"%"},"Price Review 2019",null,null,null,null,null,{"$f":"'Dashboard - WR + WN'!C52","v":0.5}]
[null,"C_WWN_OUTPERFORM_001",{"$f":"'Dashboard - WWN'!B51","v":"Cost sharing rate for outperform"},"%","Price Review 2019",null,null,null,null,null,{"$f":"'Dashboard - WWN'!C51","v":0.5}]
[null,"C_WWN_UNDERPERFORM_001",{"$f":"'Dashboard - WWN'!B52","v":"Cost sharing rate for underperform"},"%","Price Review 2019",null,null,null,null,null,{"$f":"'Dashboard - WWN'!C52","v":0.5}]
[null,"TC_PR19FM008_QA1","Cost sharing model time stamp","text","Price Review 2019",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]12/12/2019 15:49:49"},{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]12/12/2019 15:49:49"},{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]12/12/2019 15:49:49"},"[…]12/12/2019 15:49:49","[…]12/12/2019 15:49:49"]
[null,"TC_PR19FM008_QA2","Cost sharing model date stamp","text","Price Review 2019",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]12/12/2019 15:49:49"},"[…]12/12/2019 15:49:49","[…]12/12/2019 15:49:49","[…]12/12/2019 15:49:49","[…]12/12/2019 15:49:49"]

{"sheet":"Integrity checks-->","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Check","index":15,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Check"}]
[null,null,null,null,{"$f":"Time!E$22","v":"Model Period BEG"},null,null,null,null,{"$f":"Time!J$22","v":"2019-04-01"},{"$f":"Time!K$22","v":"2020-04-01"},{"$f":"Time!L$22","v":"2021-04-01"},{"$f":"Time!M$22","v":"2022-04-01"},{"$f":"Time!N$22","v":"2023-04-01"},{"$f":"Time!O$22","v":"2024-04-01"},{"$f":"Time!P$22","v":"2025-04-01"}]
[null,null,null,null,{"$f":"Time!E$23","v":"Model Period END"},{"$f":"Check!F$8","v":0},"Error chks",null,null,{"$f":"Time!J$23","v":"2020-03-31"},{"$f":"Time!K$23","v":"2021-03-31"},{"$f":"Time!L$23","v":"2022-03-31"},{"$f":"Time!M$23","v":"2023-03-31"},{"$f":"Time!N$23","v":"2024-03-31"},{"$f":"Time!O$23","v":"2025-03-31"},{"$f":"Time!P$23","v":"2026-03-31"}]
[null,null,null,null,{"$f":"Time!E$59","v":"Pre Forecast vs Forecast"},{"$f":"Check!$F$20","v":36},"Track checks",null,null,{"$f":"Time!J$59","v":"Pre Fcst"},{"$f":"Time!K$59","v":"Forecast"},{"$f":"Time!L$59","v":"Forecast"},{"$f":"Time!M$59","v":"Forecast"},{"$f":"Time!N$59","v":"Forecast"},{"$f":"Time!O$59","v":"Forecast"},{"$f":"Time!P$59","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E$101","v":"Financial Year Ending"},null,null,null,null,{"$f":"Time!J$101","v":2020},{"$f":"Time!K$101","v":2021},{"$f":"Time!L$101","v":2022},{"$f":"Time!M$101","v":2023},{"$f":"Time!N$101","v":2024},{"$f":"Time!O$101","v":2025},{"$f":"Time!P$101","v":2026}]
[null,null,null,null,{"$f":"Time!E$11","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":"Time!J$11","v":1},{"$f":"Time!K$11","v":2},{"$f":"Time!L$11","v":3},{"$f":"Time!M$11","v":4},{"$f":"Time!N$11","v":5},{"$f":"Time!O$11","v":6},{"$f":"Time!P$11","v":7}]
[]
[null,null,null,null,"Total error checks",{"$f":" SUM(F10:F18)","v":0},"check"]
[]
["[Do not delete]"]
[]
[null,null,null,null,{"$f":"'Cost profiling'!E40","v":"Water resources - profiled total expenditure check"},{"$f":"'Cost profiling'!F40","v":0},{"$f":"'Cost profiling'!G40","v":"check"}]
[null,null,null,null,{"$f":"'Cost profiling'!E72","v":"Water network - profiled total expenditure check"},{"$f":"'Cost profiling'!F72","v":0},{"$f":"'Cost profiling'!G72","v":"check"}]
[null,null,null,null,{"$f":"'Cost profiling'!E104","v":"Wastewater network - profiled total expenditure check"},{"$f":"'Cost profiling'!F104","v":0},{"$f":"'Cost profiling'!G104","v":"check"}]
[null,null,null,null,{"$f":"'Cost profiling'!E139","v":"Bioresources - profiled total expenditure check"},{"$f":"'Cost profiling'!F139","v":0},{"$f":"'Cost profiling'!G139","v":"check"}]
[null,null,null,null,{"$f":"'Cost profiling'!E174","v":"Dummy - profiled total expenditure check"},{"$f":"'Cost profiling'!F174","v":0},{"$f":"'Cost profiling'!G174","v":"check"}]
[]
["[Do not delete]"]
[]
[null,null,null,null,"Total track changes",{"$f":"Track!I$2","v":36},"check"]
[]
["END OF SHEET"]

{"sheet":"Track","index":16,"n_rows":66,"n_cols":13,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Track"},null,null,null,null,null,null,null,null,null,null,"do not del col"]
[null,null,null,null,null,{"$f":"Check!F$8","v":0},"Error chks",null,{"$f":" SUM(I6:I60)","v":36}]
[null,null,null,null,"Store Track",{"$f":"Check!$F$20","v":36},"Track checks"]
[]
[null,null,null,null,null,"Nil inputs",null,null,{"$f":" MATCH($F$5, L5:AE5, 0)","v":2},null,null,null,"Nil inputs"]
[null,null,null,null,"[do not delete row]"]
["INPUTS"]
[null,null,null,null,null,null,null,null,{"$f":" IF(ABS(J8) > Trk_Tol, 1, 0)","v":0},{"$f":" F8 - INDEX(L8:BT8, $I$5)","v":0},{"$f":" IF(ABS(J8) > Trk_Tol, IF(INDEX(L8:BT8, $I$5) = 0, 0, F8 / INDEX(L8:BT8, $I$5) - 1), 0)","v":0}]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E13","v":"Water Resources - Total Expenditure"},{"$f":"'Ex-ante allowances'!F13","v":79.555000000000007},{"$f":"'Ex-ante allowances'!G13","v":"£m"},null,1,79.555000000000007,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E17","v":"Water Resources - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F17","v":73.952450218785501},{"$f":"'Ex-ante allowances'!G17","v":"£m"},null,1,73.952450218785501,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E21","v":"[Company outturn totex - Water Resources]"},{"$f":"'Ex-ante allowances'!F21","v":79.555000000000007},{"$f":"'Ex-ante allowances'!G21","v":"£m"},null,1,79.555000000000007,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E30","v":"Incentive payment (+) or penalty (-)"},{"$f":"'Ex-ante allowances'!F30","v":-2.8012748906072531},{"$f":"'Ex-ante allowances'!G30","v":"£m"},null,1,-2.8012748906072531,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E31","v":"Ex-ante allowance above Ofwat forecast"},{"$f":"'Ex-ante allowances'!F31","v":2.801274890607246},{"$f":"'Ex-ante allowances'!G31","v":"£m"},null,1,2.801274890607246,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E40","v":"Incentive payment (+) or penalty (-) - significant scrutiny"},{"$f":"'Ex-ante allowances'!F40","v":-4.2019123359108796},{"$f":"'Ex-ante allowances'!G40","v":"£m"},null,1,-4.2019123359108796,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E41","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny"},{"$f":"'Ex-ante allowances'!F41","v":1.4006374453036301},{"$f":"'Ex-ante allowances'!G41","v":"£m"},null,1,1.4006374453036301,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E61","v":"Water resources - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F61","v":73.952450218785501},{"$f":"'Ex-ante allowances'!G61","v":"£m"},null,1,73.952450218785501,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$30","v":"Water resources - profiled total capex"},{"$f":"'Cost profiling'!H$30","v":19.642085253609345},{"$f":"'Cost profiling'!G$30","v":"£m"},null,1,19.642085253609345,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$31","v":"Water resources - profiled total opex"},{"$f":"'Cost profiling'!H$31","v":55.292864965176172},{"$f":"'Cost profiling'!G$31","v":"£m"},null,1,55.292864965176172,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$35","v":"Water resources - profiled total expenditure"},{"$f":"'Cost profiling'!H$35","v":74.934950218785517},{"$f":"'Cost profiling'!G$35","v":"£m"},null,1,74.934950218785517,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E66","v":"Water Network - Total Expenditure"},{"$f":"'Ex-ante allowances'!F66","v":835.7},{"$f":"'Ex-ante allowances'!G66","v":"£m"},null,1,835.7,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E70","v":"Water Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F70","v":850.89037104923398},{"$f":"'Ex-ante allowances'!G70","v":"£m"},null,1,850.89037104923398,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E74","v":"[Company outturn totex - Water Network]"},{"$f":"'Ex-ante allowances'!F74","v":835.7},{"$f":"'Ex-ante allowances'!G74","v":"£m"},null,1,835.7,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E87","v":"Incentive payment (+) or penalty (-) - Water Network"},{"$f":"'Ex-ante allowances'!F87","v":7.5951855246169657},{"$f":"'Ex-ante allowances'!G87","v":"£m"},null,1,7.5951855246169657,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E88","v":"Ex-ante allowance above Ofwat forecast - Water Network"},{"$f":"'Ex-ante allowances'!F88","v":-7.5951855246170226},{"$f":"'Ex-ante allowances'!G88","v":"£m"},null,1,-7.5951855246170226,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E97","v":"Incentive payment (+) or penalty (-) - significant scrutiny - Water Network"},{"$f":"'Ex-ante allowances'!F97","v":3.7975927623084829},{"$f":"'Ex-ante allowances'!G97","v":"£m"},null,1,3.7975927623084829,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E98","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny - Water Network"},{"$f":"'Ex-ante allowances'!F98","v":-11.392778286925477},{"$f":"'Ex-ante allowances'!G98","v":"£m"},null,1,-11.392778286925477,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E118","v":"Water network - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F118","v":850.89037104923398},{"$f":"'Ex-ante allowances'!G118","v":"£m"},null,1,850.89037104923398,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$62","v":"Water network - profiled total capex"},{"$f":"'Cost profiling'!H$62","v":423.29380823522638},{"$f":"'Cost profiling'!G$62","v":"£m"},null,1,423.29380823522638,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$63","v":"Water network - profiled total opex"},{"$f":"'Cost profiling'!H$63","v":435.66045264202364},{"$f":"'Cost profiling'!G$63","v":"£m"},null,1,435.66045264202364,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$67","v":"Water network - profiled total expenditure"},{"$f":"'Cost profiling'!H$67","v":858.95426087724991},{"$f":"'Cost profiling'!G$67","v":"£m"},null,1,858.95426087724991,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E123","v":"Wastewater Network - Total Expenditure"},{"$f":"'Ex-ante allowances'!F123","v":882.09699999999998},{"$f":"'Ex-ante allowances'!G123","v":"£m"},null,1,882.09699999999998,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E127","v":"Wastewater Network - Ofwat Baseline Total Gross Totex - Real"},{"$f":"'Ex-ante allowances'!F127","v":828.71740271570854},{"$f":"'Ex-ante allowances'!G127","v":"£m"},null,1,828.71740271570854,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E131","v":"[Company outturn totex of - Wastewater Network]"},{"$f":"'Ex-ante allowances'!F131","v":882.09699999999998},{"$f":"'Ex-ante allowances'!G131","v":"£m"},null,1,882.09699999999998,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E140","v":"Incentive payment (+) or penalty (-) - Wastewater Network"},{"$f":"'Ex-ante allowances'!F140","v":-26.689798642145718},{"$f":"'Ex-ante allowances'!G140","v":"£m"},null,1,-26.689798642145718,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E141","v":"Ex-ante allowance above Ofwat forecast - Wastewater Network"},{"$f":"'Ex-ante allowances'!F141","v":26.689798642145774},{"$f":"'Ex-ante allowances'!G141","v":"£m"},null,1,26.689798642145774,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E150","v":"Incentive payment (+) or penalty (-) - significant scrutiny - Wastewater Network"},{"$f":"'Ex-ante allowances'!F150","v":-40.034697963218576},{"$f":"'Ex-ante allowances'!G150","v":"£m"},null,1,-40.034697963218576,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E151","v":"Ex-ante allowance above Ofwat forecast - significant scrutiny - Wastewater Network"},{"$f":"'Ex-ante allowances'!F151","v":13.34489932107283},{"$f":"'Ex-ante allowances'!G151","v":"£m"},null,1,13.34489932107283,0]
[null,null,null,null,{"$f":"'Ex-ante allowances'!E171","v":"Wastewater Network - total cost allowance including ex-ante cost sharing - active"},{"$f":"'Ex-ante allowances'!F171","v":828.71740271570854},{"$f":"'Ex-ante allowances'!G171","v":"£m"},null,1,828.71740271570854,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$94","v":"Wastewater network - profiled total capex"},{"$f":"'Cost profiling'!H94","v":449.83301799326347},{"$f":"'Cost profiling'!G94","v":"£m"},null,1,449.83301799326347,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$95","v":"Wastewater network - profiled total opex"},{"$f":"'Cost profiling'!H95","v":386.66363395666929},{"$f":"'Cost profiling'!G95","v":"£m"},null,1,386.66363395666929,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$99","v":"Wastewater network - profiled total expenditure"},{"$f":"'Cost profiling'!H99","v":836.49665194993281},{"$f":"'Cost profiling'!G99","v":"£m"},null,1,836.49665194993281,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$129","v":"Bioresources - profiled total capex"},{"$f":"'Cost profiling'!H129","v":23.089605728504687},{"$f":"'Cost profiling'!G129","v":"£m"},null,1,23.089605728504687,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$130","v":"Bioresources - profiled total opex"},{"$f":"'Cost profiling'!H130","v":69.786982956804835},{"$f":"'Cost profiling'!G130","v":"£m"},null,1,69.786982956804835,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$134","v":"Bioresources - profiled total expenditure"},{"$f":"'Cost profiling'!H134","v":92.876588685309514},{"$f":"'Cost profiling'!G134","v":"£m"},null,1,92.876588685309514,0]
[null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$164","v":"Dummy - profiled total capex"},{"$f":"'Cost profiling'!H164","v":0},{"$f":"'Cost profiling'!G164","v":"£m"},null,0,0,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$165","v":"Dummy - profiled total opex"},{"$f":"'Cost profiling'!H165","v":0},{"$f":"'Cost profiling'!G165","v":"£m"},null,0,0,0]
[null,null,null,null,{"$f":"'Cost profiling'!E$169","v":"Dummy - profiled total expenditure"},{"$f":"'Cost profiling'!H169","v":0},{"$f":"'Cost profiling'!G169","v":"£m"},null,0,0,0]
[null,null,null,null,null,null,null,null,0,0,0]
["INFO ONLY"]
[]
[null,null,null,null,"Date",{"$f":" TODAY()","v":"2019-12-12"}]
[null,null,null,null,"Time",{"$f":" NOW()","v":43811.659596759258}]
[null,null,null,null,"File",{"$f":" MID(CELL(\"filename\",$A$1), SEARCH(\"[\", CELL(\"filename\",$A$1)) + 1, SEARCH(\"]\", CELL(\"filename\",$A$1)) - SEARCH(\"[\", CELL(\"filename\",$A$1)) - 1)","v":"PR19FM008 Cost_sharing__total_costs v3d_SWB_FD_signedoff.xlsm"}]
[]
[null,null,null,null,"[do not delete row]",null,null,null,"range end"]
[]
[null,null,null,null,"Comment: Key input and logic changes",null,null,null,null,null,null,null,"Nil inputs"]
[null,null,null,null,"Comment: Key result changes"]
[]
[]
["End of sheet"]