{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Documentation-->","Style Guide","ToC","Inputs-->","InpActive","Calc-->","Index","Time","Cost sharing Calculations","Outputs-->","Outputs","Integrity checks-->","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Cover"]
[]
["Workbook title:","Cost sharing & total costs reconciliation"]
["Version:","2n"]
["Filename:","PR19FM009 Cost_sharing_&_total_costs v2n Reconciliations_February_2020.xlsm"]
["Date:","2020-02-26"]
["Author:","Ofwat"]
["Author contact information:","PR19Reconciliationrulebook@ofwat.gov.uk"]
[]
[]
["Summary of workbook:","The cost sharing reconciliation model calculates any adjustment for underperformance or outperformance against forecast totex at the PR19 final determinations. "]
[null,"Separate adjustments are made for wage growth, net totex and business rates and abstraction charges. "]
[null,"The price base of the model is 2017-18 FYA CPIH with time value of money adjustments to 2024-25 present values using "]
[null,"the FD wholesale WACC deflated for long-term CPIH."]
[]
["Known limitations:","This model is subject to consultation and consequently may be subject to further changes."]
[]
["Instructions:","[Any user guidance required. Insert additional rows if needed.]"]
[]
["Amendments:","This is the first published version"]
[]
["References:","Totex allowances made in the final determinations"]
[null,"PAYG rates from the final determinations"]
[null,"OBR Forecast wage growth from the final determinations"]
[null,"WACC from the final determinations"]
[null,"Cost sharing rates and ex ante allowances from frinal determinations"]
[null,"ASHE Gross Hourly Wage index"]
[null,"Actual CPIH index published by the ONS"]
[]
["Error Checks:","Total error check status"]
[null,{"$f":"Check!$F$8","v":0}]
[]
["Feedback:","We would welcome feedback on this workbook. Please send any feedback to the following email address:"]
[null,"PR19Reconciliationrulebook@ofwat.gov.uk"]
[]
[]
["END OF SHEET"]

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

{"sheet":"Style Guide","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Style Guide"}]
[]
["SHEET TABS"]
[]
[null,null,null,null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade with grey stripe",null,"Inputs that are not expected to be changed"]
[]
[null,null,null,null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks"]
[null,null,null,null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,null,null,null,"Red shade",null,"Error"]
[]
["End of sheet"]

{"sheet":"ToC","index":3,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"ToC"}]
[]
[null,"ASSUMPTIONS",null,"INPUTS",null,"CALCULATIONS",null,"OUTPUTS",null,"Quality Control"]
[]
[null,{"$f":"Cover!A1","v":"Cover"},null,{"$f":"InpActive!A1","v":"InpActive"},null,{"$f":"Index!A1","v":"Index"},null,{"$f":"Outputs!A1","v":"Outputs"},null,{"$f":"Check!A1","v":"Check"}]
[null,"Model documentation sheet",null,"Inputs sheet",null,"All the indexation related calculations are done in this sheet.",null,"Main ouput sheet showing total cost sharing adjustments",null,"Contains all the model integrity checks and alerts"]
[]
[null,{"$f":"'Style Guide'!A1","v":"Style Guide"},null,null,null,{"$f":"Time!A1","v":"Time"}]
[null,"Explanation of different formatting types",null,null,null,"The model timeline and flag calculations are done in this sheet."]
[]
[null,{"$f":"A1","v":"ToC"},null,null,null,{"$f":"'Cost sharing Calculations'!A1","v":"Cost sharing Calculations"}]
[null,"Table of contents",null,null,null,"Calculates the cost sharing adjustments to be made at PR24"]
[]
[]
[]
[]
[]
["End of sheet"]

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

{"sheet":"InpActive","index":5,"n_rows":187,"n_cols":16,"rows_kept":187,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"InpActive"}]
[null,null,null,null,{"$f":"Time!E$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"},null,null,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}]
[]
["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,"Water Resources"]
[null,null,"Wage adjustment"]
[null,null,null,"2017/18 CPIH","Base Costs - WR - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Metering (excluding new connections) for meters requested by optants, customers and businesses - WR - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","WINEP / NEP ~ In-the-Round - WR - Real",null,"£m"]
[]
[null,null,null,null,"Opex split profile - WR ",null,"%"]
[null,null,null,null,"Capex Split Profile - WR",null,"%"]
[]
[null,null,null,null,"Business Rates & Abstraction Charges forecast profile - WR",null,"%"]
[]
[null,null,"Net totex for cost sharing reconcilation"]
[null,null,null,"2017/18 CPIH","Net totex for cost sharing reconciliation - WR - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Net totex available for cost sharing - WR - Real",null,"£m"]
[]
[null,null,"Business Rates and Abstraction"]
[null,null,null,"2017/18 CPIH","Business rates - Forecast - WR - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Forecast - WR - Real",null,"£m"]
[]
[null,null,null,"2017/18 CPIH","Business rates - Actual - WR - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Actual - WR - Real",null,"£m"]
[]
[null,null,null,null,"Weighted average PAYG rate - WR",null,"%"]
[]
[null,null,null,"2017/18 CPIH","Ex-ante allowance above Ofwat forecast  - Water Resources - Real",null,"£m"]
[]
[]
[null,"Water Network"]
[null,null,"Wage adjustment"]
[null,null,null,"2017/18 CPIH","Base Costs - WN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Metering (excluding new connections) for meters requested by optants, customers and businesses - WN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","WINEP / NEP ~ In-the-Round - WN - Real",null,"£m"]
[]
[null,null,null,null,"Opex split profile - WN",null,"%"]
[null,null,null,null,"Capex Split Profile - WN",null,"%"]
[]
[null,null,null,null,"Business Rates & Abstraction Charges forecast profile - WN",null,"%"]
[]
[null,null,"Net totex for cost sharing reconcilation"]
[null,null,null,"2017/18 CPIH","Net totex for cost sharing reconciliation - WN  - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Net totex available for cost sharing - WN  - Real",null,"£m"]
[]
[null,null,"Business Rates and Abstraction"]
[null,null,null,"2017/18 CPIH","Business rates - Forecast - WN  - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Forecast - WN - Real",null,"£m"]
[]
[null,null,null,"2017/18 CPIH","Business rates - Actual - WN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Actual - WN - Real",null,"£m"]
[]
[null,null,null,null,"Weighted average PAYG rate - WN",null,"%"]
[]
[null,null,null,"2017/18 CPIH","Ex-ante allowance above Ofwat forecast  - Water Network - Real",null,"£m"]
[]
[]
[null,"Wastewater Network"]
[null,null,"Wage adjustment"]
[null,null,null,"2017/18 CPIH","Base Costs - WWN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Metering (excluding new connections) for meters requested by optants, customers and businesses - WWN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","WINEP / NEP ~ In-the-Round - WWN - Real",null,"£m"]
[]
[null,null,null,null,"Opex split profile - WWN",null,"%"]
[null,null,null,null,"Capex Split Profile - WWN",null,"%"]
[]
[null,null,null,null,"Business Rates & Abstraction Charges forecast profile - WWN",null,"%"]
[]
[null,null,"Net totex for cost sharing reconcilation"]
[null,null,null,"2017/18 CPIH","Net totex for cost sharing reconciliation - WWN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Net totex available for cost sharing - WWN - Real",null,"£m"]
[]
[null,null,"Business Rates and Abstraction"]
[null,null,null,"2017/18 CPIH","Business rates - Forecast - WWN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Forecast - WWN - Real",null,"£m"]
[]
[null,null,null,"2017/18 CPIH","Business rates - Actual - WWN - Real",null,"£m"]
[null,null,null,"2017/18 CPIH","Abstraction charges - Actual - WWN - Real",null,"£m"]
[]
[null,null,null,null,"Weighted average PAYG rate - WWN",null,"%"]
[]
[null,null,null,"2017/18 CPIH","Ex-ante allowance above Ofwat forecast  - Wastewater Network - Real",null,"£m"]
[]
[]
[]
["INFLATION"]
[]
[null,null,null,"Base Year"]
[null,null,null,null,"Consumer Price Index (with housing) for April",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for May",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for June",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for July",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for August",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for September",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for October",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for November",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for December",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for January",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for February",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for March",null,"Index"]
[]
[null,null,null,"Period"]
[null,null,null,null,"Consumer Price Index (with housing) for April",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for May",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for June",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for July",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for August",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for September",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for October",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for November",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for December",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for January",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for February",null,"Index"]
[null,null,null,null,"Consumer Price Index (with housing) for March",null,"Index"]
[]
[]
["WAGE GROWTH"]
[]
[null,null,null,"Wage Growth "]
[null,null,null,null,"OBR Forecast wage growth for PR19 FD",null,"%",null,null,0.01,1.0999999999999999E-2,1.0999999999999999E-2,1.2E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[null,null,null,null,"ASHE Gross Hourly Wage All - Nominal",null,"£ / hour"]
[]
[null,null,null,"Percentage totex linked to wage growth"]
[null,null,null,null,"Percentage totex linked to wage growth - WR",0.38600000000000001,"%"]
[]
[null,null,null,null,"Percentage totex linked to wage growth - WN",0.38600000000000001,"%"]
[]
[null,null,null,null,"Percentage totex linked to wage growth - WWN",0.38600000000000001,"%"]
[]
[]
["COST SHARING INPUTS"]
[]
[null,null,null,"Totex cost sharing rates"]
[null,null,null,null,"Outperformance Rate - WR",null,"%"]
[null,null,null,null,"Underperformance Rate - WR",null,"%"]
[]
[null,null,null,null,"Outperformance Rate - WN",null,"%"]
[null,null,null,null,"Underperformance Rate - WN",null,"%"]
[]
[null,null,null,null,"Outperformance Rate - WWN",null,"%"]
[null,null,null,null,"Underperformance Rate - WWN",null,"%"]
[]
[null,null,null,"Abstraction and Business rate cost sharing rates"]
[null,null,null,null,"Cost sharing rates Abstraction and Business rates - Overperformance",null,"%"]
[null,null,null,null,"Cost sharing rates Abstraction and Business rates - Underperformance",null,"%"]
[]
[]
["FINANCING INPUTS"]
[]
[null,"Model Tolerance"]
[null,null,null,null,"Financing cost index",null,"Index",null,null,null,4,3,2,1,0]
[]
[null,null,null,null,"WACC - WR",null,"%"]
[null,null,null,null,"WACC - WN",null,"%"]
[null,null,null,null,"WACC - WWN",null,"%"]
[]
["NON CHANGEABLE INPUTS"]
[]
[null,"Model Tolerance"]
[null,null,null,null,"Model Check Tolerance Level",1E-4,"tolerance"]
[]
[null,null,null,null,"Model Track Tolerance Level",1E-3,"tolerance"]
[]
["END OF SHEET"]

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

{"sheet":"Index","index":7,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Index"}]
[null,null,null,null,{"$f":"Time!E$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"},null,null,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}]
[]
["CPI(H) INDEXATION"]
[]
[null,null,"Average CPI(H) - base index"]
[null,null,null,null,{"$f":" InpActive!E112","v":"Consumer Price Index (with housing) for April"},{"$f":" InpActive!F112","v":0},{"$f":" InpActive!G112","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E113","v":"Consumer Price Index (with housing) for May"},{"$f":" InpActive!F113","v":0},{"$f":" InpActive!G113","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E114","v":"Consumer Price Index (with housing) for June"},{"$f":" InpActive!F114","v":0},{"$f":" InpActive!G114","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E115","v":"Consumer Price Index (with housing) for July"},{"$f":" InpActive!F115","v":0},{"$f":" InpActive!G115","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E116","v":"Consumer Price Index (with housing) for August"},{"$f":" InpActive!F116","v":0},{"$f":" InpActive!G116","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E117","v":"Consumer Price Index (with housing) for September"},{"$f":" InpActive!F117","v":0},{"$f":" InpActive!G117","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E118","v":"Consumer Price Index (with housing) for October"},{"$f":" InpActive!F118","v":0},{"$f":" InpActive!G118","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E119","v":"Consumer Price Index (with housing) for November"},{"$f":" InpActive!F119","v":0},{"$f":" InpActive!G119","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E120","v":"Consumer Price Index (with housing) for December"},{"$f":" InpActive!F120","v":0},{"$f":" InpActive!G120","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E121","v":"Consumer Price Index (with housing) for January"},{"$f":" InpActive!F121","v":0},{"$f":" InpActive!G121","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E122","v":"Consumer Price Index (with housing) for February"},{"$f":" InpActive!F122","v":0},{"$f":" InpActive!G122","v":"Index"}]
[null,null,null,null,{"$f":" InpActive!E123","v":"Consumer Price Index (with housing) for March"},{"$f":" InpActive!F123","v":0},{"$f":" InpActive!G123","v":"Index"}]
[null,null,null,null,"CPIH 2017/18 FYA - Base Year",{"$f":" AVERAGE(F11:F22)","v":0},"Index"]
[]
[null,null,"CPI(H): Financial year average - index"]
[null,null,null,null,{"$f":" InpActive!E126","v":"Consumer Price Index (with housing) for April"},{"$f":" InpActive!F126","v":0},{"$f":" InpActive!G126","v":"Index"},{"$f":" InpActive!H126","v":0},{"$f":" InpActive!I126","v":0},{"$f":" InpActive!J126","v":0},{"$f":" InpActive!K126","v":0},{"$f":" InpActive!L126","v":0},{"$f":" InpActive!M126","v":0},{"$f":" InpActive!N126","v":0},{"$f":" InpActive!O126","v":0},{"$f":" InpActive!P126","v":0}]
[null,null,null,null,{"$f":" InpActive!E127","v":"Consumer Price Index (with housing) for May"},{"$f":" InpActive!F127","v":0},{"$f":" InpActive!G127","v":"Index"},{"$f":" InpActive!H127","v":0},{"$f":" InpActive!I127","v":0},{"$f":" InpActive!J127","v":0},{"$f":" InpActive!K127","v":0},{"$f":" InpActive!L127","v":0},{"$f":" InpActive!M127","v":0},{"$f":" InpActive!N127","v":0},{"$f":" InpActive!O127","v":0},{"$f":" InpActive!P127","v":0}]
[null,null,null,null,{"$f":" InpActive!E128","v":"Consumer Price Index (with housing) for June"},{"$f":" InpActive!F128","v":0},{"$f":" InpActive!G128","v":"Index"},{"$f":" InpActive!H128","v":0},{"$f":" InpActive!I128","v":0},{"$f":" InpActive!J128","v":0},{"$f":" InpActive!K128","v":0},{"$f":" InpActive!L128","v":0},{"$f":" InpActive!M128","v":0},{"$f":" InpActive!N128","v":0},{"$f":" InpActive!O128","v":0},{"$f":" InpActive!P128","v":0}]
[null,null,null,null,{"$f":" InpActive!E129","v":"Consumer Price Index (with housing) for July"},{"$f":" InpActive!F129","v":0},{"$f":" InpActive!G129","v":"Index"},{"$f":" InpActive!H129","v":0},{"$f":" InpActive!I129","v":0},{"$f":" InpActive!J129","v":0},{"$f":" InpActive!K129","v":0},{"$f":" InpActive!L129","v":0},{"$f":" InpActive!M129","v":0},{"$f":" InpActive!N129","v":0},{"$f":" InpActive!O129","v":0},{"$f":" InpActive!P129","v":0}]
[null,null,null,null,{"$f":" InpActive!E130","v":"Consumer Price Index (with housing) for August"},{"$f":" InpActive!F130","v":0},{"$f":" InpActive!G130","v":"Index"},{"$f":" InpActive!H130","v":0},{"$f":" InpActive!I130","v":0},{"$f":" InpActive!J130","v":0},{"$f":" InpActive!K130","v":0},{"$f":" InpActive!L130","v":0},{"$f":" InpActive!M130","v":0},{"$f":" InpActive!N130","v":0},{"$f":" InpActive!O130","v":0},{"$f":" InpActive!P130","v":0}]
[null,null,null,null,{"$f":" InpActive!E131","v":"Consumer Price Index (with housing) for September"},{"$f":" InpActive!F131","v":0},{"$f":" InpActive!G131","v":"Index"},{"$f":" InpActive!H131","v":0},{"$f":" InpActive!I131","v":0},{"$f":" InpActive!J131","v":0},{"$f":" InpActive!K131","v":0},{"$f":" InpActive!L131","v":0},{"$f":" InpActive!M131","v":0},{"$f":" InpActive!N131","v":0},{"$f":" InpActive!O131","v":0},{"$f":" InpActive!P131","v":0}]
[null,null,null,null,{"$f":" InpActive!E132","v":"Consumer Price Index (with housing) for October"},{"$f":" InpActive!F132","v":0},{"$f":" InpActive!G132","v":"Index"},{"$f":" InpActive!H132","v":0},{"$f":" InpActive!I132","v":0},{"$f":" InpActive!J132","v":0},{"$f":" InpActive!K132","v":0},{"$f":" InpActive!L132","v":0},{"$f":" InpActive!M132","v":0},{"$f":" InpActive!N132","v":0},{"$f":" InpActive!O132","v":0},{"$f":" InpActive!P132","v":0}]
[null,null,null,null,{"$f":" InpActive!E133","v":"Consumer Price Index (with housing) for November"},{"$f":" InpActive!F133","v":0},{"$f":" InpActive!G133","v":"Index"},{"$f":" InpActive!H133","v":0},{"$f":" InpActive!I133","v":0},{"$f":" InpActive!J133","v":0},{"$f":" InpActive!K133","v":0},{"$f":" InpActive!L133","v":0},{"$f":" InpActive!M133","v":0},{"$f":" InpActive!N133","v":0},{"$f":" InpActive!O133","v":0},{"$f":" InpActive!P133","v":0}]
[null,null,null,null,{"$f":" InpActive!E134","v":"Consumer Price Index (with housing) for December"},{"$f":" InpActive!F134","v":0},{"$f":" InpActive!G134","v":"Index"},{"$f":" InpActive!H134","v":0},{"$f":" InpActive!I134","v":0},{"$f":" InpActive!J134","v":0},{"$f":" InpActive!K134","v":0},{"$f":" InpActive!L134","v":0},{"$f":" InpActive!M134","v":0},{"$f":" InpActive!N134","v":0},{"$f":" InpActive!O134","v":0},{"$f":" InpActive!P134","v":0}]
[null,null,null,null,{"$f":" InpActive!E135","v":"Consumer Price Index (with housing) for January"},{"$f":" InpActive!F135","v":0},{"$f":" InpActive!G135","v":"Index"},{"$f":" InpActive!H135","v":0},{"$f":" InpActive!I135","v":0},{"$f":" InpActive!J135","v":0},{"$f":" InpActive!K135","v":0},{"$f":" InpActive!L135","v":0},{"$f":" InpActive!M135","v":0},{"$f":" InpActive!N135","v":0},{"$f":" InpActive!O135","v":0},{"$f":" InpActive!P135","v":0}]
[null,null,null,null,{"$f":" InpActive!E136","v":"Consumer Price Index (with housing) for February"},{"$f":" InpActive!F136","v":0},{"$f":" InpActive!G136","v":"Index"},{"$f":" InpActive!H136","v":0},{"$f":" InpActive!I136","v":0},{"$f":" InpActive!J136","v":0},{"$f":" InpActive!K136","v":0},{"$f":" InpActive!L136","v":0},{"$f":" InpActive!M136","v":0},{"$f":" InpActive!N136","v":0},{"$f":" InpActive!O136","v":0},{"$f":" InpActive!P136","v":0}]
[null,null,null,null,{"$f":" InpActive!E137","v":"Consumer Price Index (with housing) for March"},{"$f":" InpActive!F137","v":0},{"$f":" InpActive!G137","v":"Index"},{"$f":" InpActive!H137","v":0},{"$f":" InpActive!I137","v":0},{"$f":" InpActive!J137","v":0},{"$f":" InpActive!K137","v":0},{"$f":" InpActive!L137","v":0},{"$f":" InpActive!M137","v":0},{"$f":" InpActive!N137","v":0},{"$f":" InpActive!O137","v":0},{"$f":" InpActive!P137","v":0}]
[null,null,null,null,"CPIH 2017/18 FYA - Period",null,"Index",null,null,{"$f":" AVERAGE(J26:J37)","v":0},{"$f":" AVERAGE(K26:K37)","v":0},0,0,0,0,0]
[]
[null,null,null,"CPI(H): Fin year average - inflate from base year average"]
[null,null,null,null,{"$f":" E$23","v":"CPIH 2017/18 FYA - Base Year"},{"$f":" F$23","v":0},"Index"]
[null,null,null,null,{"$f":" E$38","v":"CPIH 2017/18 FYA - Period"},{"$f":" F$38","v":0},"Index",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"CPI(H): Fin year average - inflate from base year 2017-18 average - CALC",null,"%",null,null,{"$f":" IF($F41 = 0, 0, J42 / $F41)","v":0},{"$f":" IF($F41 = 0, 0, K42 / $F41)","v":0},0,0,0,0,0]
[]
["END OF SHEET"]

{"sheet":"Time","index":8,"n_rows":104,"n_cols":16,"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"}]
[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"},null,null,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}]
[]
["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},{"$f":" K11 + 1","v":3},4,5,6,{"$f":" O11 + 1","v":7}]
[null,null,null,null,"Model Column Total",{"$f":" MAX(J11:P11)","v":7},"column"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column counter"},0,"counter",0,0,1,2,3,4,5,6,7]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM(J15:P15)","v":1},null,{"$f":" IF( J14 = 1, 1, 0)","v":1},{"$f":" IF( K14 = 1, 1, 0)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$10","v":"First date of time ruler"},{"$f":" InpActive!F$10","v":"2019-04-01"},{"$f":" InpActive!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]
[null,null,null,null,"Model Period BEG",null,"date",null,null,{"$f":" IF( J21 = 1, $F20, I23 + 1)","v":"2019-04-01"},{"$f":" IF( K21 = 1, $F20, J23 + 1)","v":"2020-04-01"},"2021-04-01","2022-04-01","2023-04-01","2024-04-01",{"$f":" IF( P21 = 1, $F20, O23 + 1)","v":"2025-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"]
[]
[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"]
[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"]
[null,null,null,null,"Days in Model Period",null,"days",{"$f":" SUM(J27:P27)","v":2557},null,{"$f":" J25 - J26 + 1","v":366},365,365,365,366,365,365]
[]
[]
["PRE FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" InpActive!E$12","v":"Last Pre Forecast Date"},{"$f":" InpActive!F$12","v":"2020-03-31"},{"$f":" InpActive!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"]
[null,null,null,null,"Last Pre Forecast Flag",null,"flag",{"$f":" SUM(J34:P34)","v":1},null,{"$f":" IF(J33 = $F32, 1, 0)","v":1},0,0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Flag",null,"flag",{"$f":" SUM(J35:P35)","v":1},null,{"$f":" IF($F32 >= J33, 1, 0)","v":1},{"$f":" IF($F32 >= K33, 1, 0)","v":0},0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Total",{"$f":" SUM(J35:P35)","v":1},"columns"]
[]
[null,null,null,null,{"$f":" InpActive!E$14","v":"Acquisition date (midnight)"},{"$f":" InpActive!F$14","v":"2020-03-31"},{"$f":" InpActive!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"]
[null,null,null,null,"Acquisition / initial balance date flag",null,"flag",{"$f":" SUM(J40:P40)","v":1},null,{"$f":" IF(J39 = $F38, 1, 0)","v":1},0,0,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]
[null,null,null,null,"1st Forecast Period Flag",null,"flag",{"$f":" SUM(J46:P46)","v":1},null,{"$f":" I45","v":0},{"$f":" J45","v":1},0,0,0,0,{"$f":" O45","v":0}]
[]
[null,null,null,null,{"$f":"InpActive!E$16","v":"Last forecast date"},{"$f":"InpActive!F$16","v":"2025-03-31"},{"$f":"InpActive!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"]
[null,null,null,null,"Last Forecast Period Flag",null,"flag",{"$f":" SUM(J50:P50)","v":1},null,{"$f":" IF(AND($F48 > I49, $F48 <= J49), 1, 0)","v":0},{"$f":" IF(AND($F48 > J49, $F48 <= K49), 1, 0)","v":0},0,0,0,1,{"$f":" IF(AND($F48 > O49, $F48 <= P49), 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]
[null,null,null,null,{"$f":" E$50","v":"Last Forecast Period Flag"},0,"flag",1,0,0,0,0,0,0,1,0]
[null,null,null,null,"Forecast Period Flag",null,"flag",{"$f":" SUM(J54:P54)","v":5},null,{"$f":" J52 - I53 + I54","v":0},{"$f":" K52 - J53 + J54","v":1},1,1,1,1,{"$f":" P52 - O53 + O54","v":0}]
[null,null,null,null,"Forecast Period Total ",{"$f":" SUM(J54:P54)","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]
[null,null,null,null,{"$f":" E$54","v":"Forecast Period Flag"},0,"flag",5,0,0,1,1,1,1,1,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"]
[]
[]
["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]
[null,null,null,null,"1st Post Last Forecast Period Flag",null,"flag",{"$f":" SUM(J65:P65)","v":1},null,{"$f":" I64","v":0},{"$f":" J64","v":0},0,0,0,0,{"$f":" O64","v":1}]
[]
[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]
[null,null,null,null,"Post Forecast Period Flag",null,"flag",{"$f":" SUM(J68:P68)","v":1},null,{"$f":" I68 + J67","v":0},{"$f":" J68 + K67","v":0},0,0,0,0,{"$f":" O68 + P67","v":1}]
[null,null,null,null,"Post Forecast Period Total",{"$f":" SUM(J68:P68)","v":1},"columns"]
[]
[]
["MODELLING PERIOD CHECK"]
[]
[null,null,null,null,{"$f":" E$12","v":"Model Column Total"},{"$f":" F$12","v":7},{"$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":1},{"$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":"InpActive!E$20","v":"Operation Finish Date (midnight)"},{"$f":"InpActive!F$20","v":"2025-03-31"},{"$f":"InpActive!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"]
[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"]
[null,null,null,null,"Days in Operation Period",null,"days",{"$f":" SUM(J88:P88)","v":2192},null,{"$f":" MAX(0, (MIN($F85, J87) - MAX($F84, J86) + 1))","v":366},365,365,365,366,365,0]
[]
[null,null,null,null,{"$f":" E$88","v":"Days in Operation Period"},0,"days",2192,0,366,365,365,365,366,365,0]
[null,null,null,null,{"$f":" E$27","v":"Days in Model Period"},0,"days",2557,0,366,365,365,365,366,365,365]
[null,null,null,null,"Operation Period PPF",null,"factor",{"$f":" SUM(J92:P92)","v":6},null,{"$f":" J90 / J91","v":1},1,1,1,1,1,0]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"InpActive!E21","v":"First Modelling Column Financial Year Number"},{"$f":"InpActive!F21","v":2020},{"$f":"InpActive!G21","v":"year"}]
[null,null,null,null,{"$f":"InpActive!E22","v":"Financial Year End Month Number"},{"$f":"InpActive!F22","v":3},{"$f":"InpActive!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"]
[null,null,null,null,{"$f":" E$15","v":"First model column flag"},0,"flag",1,0,1,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,{"$f":" IF(P100 = 1, $F97, IF(P99 > (DATE(O101, $F98 + 1, 1) - 1), O101 + 1, O101))","v":2026}]
[]
[]
["END OF SHEET"]

{"sheet":"Cost sharing Calculations","index":9,"n_rows":566,"n_cols":16,"rows_kept":566,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cost sharing Calculations"}]
[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"},null,null,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}]
[]
["WAGE GROWTH ADJUSTER"]
[]
[null,null,"Cumulative actual real wage growth"]
[null,null,null,null,{"$f":"InpActive!E144","v":"ASHE Gross Hourly Wage All - Nominal"},{"$f":"InpActive!F144","v":0},{"$f":"InpActive!G144","v":"£ / hour"},{"$f":"InpActive!H144","v":0},{"$f":"InpActive!I144","v":0},{"$f":"InpActive!J144","v":0},{"$f":"InpActive!K144","v":0},{"$f":"InpActive!L144","v":0},{"$f":"InpActive!M144","v":0},{"$f":"InpActive!N144","v":0},{"$f":"InpActive!O144","v":0},{"$f":"InpActive!P144","v":0}]
[null,null,null,null,{"$f":"Index!E$43","v":"CPI(H): Fin year average - inflate from base year 2017-18 average - CALC"},{"$f":"Index!F$43","v":0},{"$f":"Index!G$43","v":"%"},{"$f":"Index!H$43","v":0},{"$f":"Index!I$43","v":0},{"$f":"Index!J$43","v":0},{"$f":"Index!K$43","v":0},{"$f":"Index!L$43","v":0},{"$f":"Index!M$43","v":0},{"$f":"Index!N$43","v":0},{"$f":"Index!O$43","v":0},{"$f":"Index!P$43","v":0}]
[null,null,null,null,"ASHE GROSS HOURLY WAGE ALL - Real",null,"£ / hour",null,null,{"$f":" IF( J11 = 0, 0, J11 / J12)","v":0},{"$f":" IF( K11 = 0, 0, K11 / K12)","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$13","v":"ASHE GROSS HOURLY WAGE ALL - Real"},{"$f":" F$13","v":0},"£ / hour",0,0,0,0,0,0,0,{"$f":" O$13","v":0},0]
[null,null,null,null,"ASHE GROSS HOURLY WAGE ALL - Cumulative growth - Real",null,"%",null,null,{"$f":" IF( J15 = 0, 0, J15 / $J$15)","v":0},0,0,0,0,0,0]
[]
[null,null,"Real adjustment factor for wage growth "]
[null,null,null,null,{"$f":"InpActive!E143","v":"OBR Forecast wage growth for PR19 FD"},{"$f":"InpActive!F143","v":0},{"$f":"InpActive!G143","v":"%"},{"$f":"InpActive!H143","v":0},{"$f":"InpActive!I143","v":0},{"$f":"InpActive!J143","v":0.01},{"$f":"InpActive!K143","v":1.0999999999999999E-2},{"$f":"InpActive!L143","v":1.0999999999999999E-2},{"$f":"InpActive!M143","v":1.2E-2},{"$f":"InpActive!N143","v":1.2999999999999999E-2},{"$f":"InpActive!O143","v":1.2999999999999999E-2},{"$f":"InpActive!P143","v":0}]
[null,null,null,null,{"$f":"Time!E45","v":"Last Pre Forecast Flag"},{"$f":"Time!F45","v":0},{"$f":"Time!G45","v":"flag"},{"$f":"Time!H45","v":1},{"$f":"Time!I45","v":0},{"$f":"Time!J45","v":1},{"$f":"Time!K45","v":0},{"$f":"Time!L45","v":0},{"$f":"Time!M45","v":0},{"$f":"Time!N45","v":0},{"$f":"Time!O45","v":0},{"$f":"Time!P45","v":0}]
[null,null,null,null,"Forecast wage growth for adjuster",null,"%",null,null,{"$f":" IF(J20 = 1, 1, I21 * (J19 + 1))","v":1},{"$f":" IF(K20 = 1, 1, J21 * (K19 + 1))","v":1.0109999999999999},1.0221209999999998,1.0343864519999999,1.0478334758759997,1.0614553110623877,1.0614553110623877]
[]
[null,null,null,null,{"$f":" E$16","v":"ASHE GROSS HOURLY WAGE ALL - Cumulative growth - Real"},0,"%",0,0,{"$f":" J$16","v":0},{"$f":" K$16","v":0},{"$f":" L$16","v":0},0,0,0,0]
[null,null,null,null,{"$f":" E$21","v":"Forecast wage growth for adjuster"},0,"%",0,0,{"$f":" J$21","v":1},{"$f":" K$21","v":1.0109999999999999},1.0221209999999998,1.0343864519999999,1.0478334758759997,1.0614553110623877,1.0614553110623877]
[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,"Real adjustment factor for wages",null,"%",null,null,{"$f":" IF( J25 = 1, J23/J24, 0)","v":0},{"$f":" IF( K25 = 1, K23/K24, 0)","v":0},{"$f":" IF( L25 = 1, L23/L24, 0)","v":0},0,0,0,0]
[]
["WATER RESOURCES"]
[]
[null,"Adjustment For Wage Growth"]
[]
[null,null,"Totex for wage adjustment"]
[null,null,null,null,{"$f":" InpActive!E$29","v":"Base Costs - WR - Real"},{"$f":" InpActive!F$29","v":0},{"$f":" InpActive!G$29","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$30","v":"Metering (excluding new connections) for meters requested by optants, customers and businesses - WR - Real"},{"$f":" InpActive!F$30","v":0},{"$f":" InpActive!G$30","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$31","v":"WINEP / NEP ~ In-the-Round - WR - Real"},{"$f":" InpActive!F$31","v":0},{"$f":" InpActive!G$31","v":"£m"}]
[null,null,null,null,"Totex available for wage indexation adjustment - WR - Real",{"$f":" SUM(F33:F35)","v":0},"£m"]
[]
[null,null,"Profile for totex for wage adjustment"]
[null,null,null,null,{"$f":"InpActive!E$33","v":"Opex split profile - WR "},{"$f":"InpActive!F$33","v":0},{"$f":"InpActive!G$33","v":"%"},{"$f":"InpActive!H$33","v":0},{"$f":"InpActive!I$33","v":0},{"$f":"InpActive!J$33","v":0},{"$f":"InpActive!K$33","v":0},{"$f":"InpActive!L$33","v":0},{"$f":"InpActive!M$33","v":0},{"$f":"InpActive!N$33","v":0},{"$f":"InpActive!O$33","v":0},{"$f":"InpActive!P$33","v":0}]
[null,null,null,null,{"$f":"InpActive!E$34","v":"Capex Split Profile - WR"},{"$f":"InpActive!F$34","v":0},{"$f":"InpActive!G$34","v":"%"},{"$f":"InpActive!H$34","v":0},{"$f":"InpActive!I$34","v":0},{"$f":"InpActive!J$34","v":0},{"$f":"InpActive!K$34","v":0},{"$f":"InpActive!L$34","v":0},{"$f":"InpActive!M$34","v":0},{"$f":"InpActive!N$34","v":0},{"$f":"InpActive!O$34","v":0},{"$f":"InpActive!P$34","v":0}]
[null,null,null,null,"Totex profile - WR",null,"%",{"$f":" SUM(J41:P41)","v":0},null,{"$f":" SUM(J39:J40)","v":0},{"$f":" SUM(K39:K40)","v":0},{"$f":" SUM(L39:L40)","v":0},0,0,0,0]
[null,null,null,null,"Totex profile - 5 year percentage - WR",{"$f":"H$41","v":0},"%"]
[]
[null,null,null,null,{"$f":" E$42","v":"Totex profile - 5 year percentage - WR"},{"$f":" F$42","v":0},{"$f":" G$42","v":"%"}]
[null,null,null,null,"WR Totex profile 100% check",{"$f":" IF(OR($F$44 = 1, F44 = 0), 0, 1)","v":0},"Check"]
[]
[null,null,null,null,{"$f":" E$36","v":"Totex available for wage indexation adjustment - WR - Real"},{"$f":" F$36","v":0},"£m"]
[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,{"$f":" E$41","v":"Totex profile - WR"},{"$f":" F$41","v":0},"%",0,0,{"$f":" J$41","v":0},0,0,0,0,0,0]
[null,null,null,null,"Profiled Totex available for wage indexation adjustment - WR - Real",null,"£m",{"$f":" SUM(J50:P50)","v":0},null,{"$f":" IF(J48 = 1, J49 * $F47, 0)","v":0},{"$f":" IF(K48 = 1, K49 * $F47, 0)","v":0},{"$f":" IF(L48 = 1, L49 * $F47, 0)","v":0},0,0,0,0]
[]
[null,null,"Totex applicable for wage adjustment by year"]
[null,null,null,null,{"$f":"InpActive!E$147","v":"Percentage totex linked to wage growth - WR"},{"$f":"InpActive!F$147","v":0.38600000000000001},{"$f":"InpActive!G$147","v":"%"}]
[null,null,null,null,{"$f":"E50","v":"Profiled Totex available for wage indexation adjustment - WR - Real"},0,"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profiled Net totex available for wage adj - WR - Real",null,"£m",{"$f":" SUM(J55:P55)","v":0},null,{"$f":" J54 * $F53","v":0},{"$f":" K54 * $F53","v":0},{"$f":" L54 * $F53","v":0},0,0,0,0]
[]
[null,null,"Adjustment factor for wage linked totex"]
[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,{"$f":" E$55","v":"Profiled Net totex available for wage adj - WR - Real"},{"$f":" F$55","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Real adjustment factor for wages"},0,"%",0,0,{"$f":" J$26","v":0},{"$f":" K$26","v":0},{"$f":" L$26","v":0},0,0,0,0]
[null,null,null,null,"Profiled adjustment wage related totex - WR - Real",null,"£m",{"$f":" SUM(J61:P61)","v":0},null,{"$f":" IF(J58 = 1, J59 * J60, 0)","v":0},{"$f":" IF(K58 = 1, K59 * K60, 0)","v":0},{"$f":" IF(L58 = 1, L59 * L60, 0)","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast wage linked totex "]
[null,null,null,null,{"$f":" E$61","v":"Profiled adjustment wage related totex - WR - Real"},0,"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$55","v":"Profiled Net totex available for wage adj - WR - Real"},{"$f":" F$55","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast totex - WR",null,"£m",{"$f":" SUM(J66:P66)","v":0},null,{"$f":" J64 - J65","v":0},{"$f":" K64 - K65","v":0},{"$f":" L64 - L65","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast wage linked totex - Time adjusted"]
[null,null,null,null,{"$f":" InpActive!E$174","v":"Financing cost index"},{"$f":" InpActive!F$174","v":0},{"$f":" InpActive!G$174","v":"Index"},{"$f":" InpActive!H$174","v":0},{"$f":" InpActive!I$174","v":0},{"$f":" InpActive!J$174","v":0},{"$f":" InpActive!K$174","v":4},{"$f":" InpActive!L$174","v":3},{"$f":" InpActive!M$174","v":2},{"$f":" InpActive!N$174","v":1},{"$f":" InpActive!O$174","v":0},{"$f":" InpActive!P$174","v":0}]
[null,null,null,null,{"$f":" InpActive!E$176","v":"WACC - WR"},{"$f":" InpActive!F$176","v":0},{"$f":" InpActive!G$176","v":"%"}]
[null,null,null,null,"Time value of money factor - WR",null,"Factor",null,null,{"$f":"(1+$F70) ^ J69","v":1},1,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" E$66","v":"Variance to forecast totex - WR"},0,"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$71","v":"Time value of money factor - WR"},{"$f":" F$71","v":0},"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast - WR",null,"£m",{"$f":" SUM(J75:P75)","v":0},null,{"$f":" J73 * J74","v":0},{"$f":" K73 * K74","v":0},0,0,0,0,0]
[null,null,null,null,"Variance to updated Ofwat baseline - WR - Real",{"$f":" H75","v":0},"£m"]
[]
[null,null,"Under / Overperformance on wage linked totex "]
[null,null,null,null,{"$f":" InpActive!E$157","v":"Outperformance Rate - WR"},{"$f":" InpActive!F$157","v":0},{"$f":" InpActive!G$157","v":"%"}]
[null,null,null,null,{"$f":"E$76","v":"Variance to updated Ofwat baseline - WR - Real"},{"$f":"F$76","v":0},{"$f":"G$76","v":"£m"}]
[null,null,null,null,"Wages Outperformance Adjustment - WR - Real",{"$f":" IF( F80 < 0, $F$80 *  (1 - F79), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$158","v":"Underperformance Rate - WR"},{"$f":" InpActive!F$158","v":0},{"$f":" InpActive!G$158","v":"%"}]
[null,null,null,null,{"$f":"E61","v":"Profiled adjustment wage related totex - WR - Real"},{"$f":"F$76","v":0},{"$f":"G$76","v":"£m"}]
[null,null,null,null,"Wages Underperformance Adjustment - WR - Real",{"$f":" IF( F80 > 0, $F$84 *  F83, 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$81","v":"Wages Outperformance Adjustment - WR - Real"},{"$f":" F$81","v":0},"£m"]
[null,null,null,null,{"$f":"E$85","v":"Wages Underperformance Adjustment - WR - Real"},{"$f":"F$85","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing for wage adjustment - WR - Real",{"$f":" IF(F87 <> 0, F87, F88)","v":0},"£m"]
[]
[]
[null,"Cost sharing on net totex availale for reconcilation"]
[]
[null,null,null,null,{"$f":"InpActive!E$39","v":"Net totex for cost sharing reconciliation - WR - Real"},{"$f":"InpActive!F$39","v":0},{"$f":"InpActive!G$39","v":"£m"},{"$f":"InpActive!H$39","v":0},{"$f":"InpActive!I$39","v":0},{"$f":"InpActive!J$39","v":0},{"$f":"InpActive!K$39","v":0},{"$f":"InpActive!L$39","v":0},{"$f":"InpActive!M$39","v":0},{"$f":"InpActive!N$39","v":0},{"$f":"InpActive!O$39","v":0},{"$f":"InpActive!P$39","v":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,"Actual net totex for cost sharing reconciliation - WR - Real ",null,"£m",{"$f":" SUM(J96:P96)","v":0},null,{"$f":" J94 * J95","v":0},{"$f":" K94 * K95","v":0},{"$f":" L94 * L95","v":0},0,0,0,0]
[]
[null,null,"Profile for net totex for cost sharing"]
[null,null,null,null,{"$f":"InpActive!E$40","v":"Net totex available for cost sharing - WR - Real"},{"$f":"InpActive!F$40","v":0},{"$f":"InpActive!G$40","v":"£m"}]
[null,null,null,null,{"$f":" E$41","v":"Totex profile - WR"},{"$f":" F$41","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Net totex available for cost sharing profiled - WR - Real",null,"£m",{"$f":" SUM(J101:P101)","v":0},null,{"$f":" J100 * $F99","v":0},{"$f":" K100 * $F99","v":0},{"$f":" L100 * $F99","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast net totex for cost sharing"]
[null,null,null,null,{"$f":" E$96","v":"Actual net totex for cost sharing reconciliation - WR - Real "},{"$f":" F$96","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$101","v":"Net totex available for cost sharing profiled - WR - Real"},{"$f":" F$101","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast net totex for cost sharing - WR",null,"£m",{"$f":" SUM(J106:P106)","v":0},null,{"$f":" J104 - J105","v":0},{"$f":" K104 - K105","v":0},{"$f":" L104 - L105","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast net totex for cost sharing - Time adjusted"]
[null,null,null,null,{"$f":" E$106","v":"Variance to forecast net totex for cost sharing - WR"},{"$f":" F$106","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$71","v":"Time value of money factor - WR"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast net totex for cost sharing - WR",null,"£m",{"$f":" SUM(J111:P111)","v":0},null,{"$f":" J109 * J110","v":0},{"$f":" K109 * K110","v":0},{"$f":" L109 * L110","v":0},0,0,0,0]
[null,null,null,null,"Total variance to forecast net totex for cost sharing - WR",{"$f":" $H111","v":0},"£m"]
[]
[null,null,"Under / Overperformance on net totex for cost sharing"]
[null,null,null,null,{"$f":" InpActive!E$157","v":"Outperformance Rate - WR"},{"$f":" InpActive!F$157","v":0},{"$f":" InpActive!G$157","v":"%"}]
[null,null,null,null,{"$f":"E$112","v":"Total variance to forecast net totex for cost sharing - WR"},{"$f":"F$112","v":0},{"$f":"G$112","v":"£m"}]
[null,null,null,null,"Net Totex Outperformance Adjustment - WR - Real",{"$f":" IF( F116 < 0, $F$116 *  (1 - F115), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$158","v":"Underperformance Rate - WR"},{"$f":" InpActive!F$158","v":0},{"$f":" InpActive!G$158","v":"%"}]
[null,null,null,null,{"$f":"E$112","v":"Total variance to forecast net totex for cost sharing - WR"},{"$f":"F$112","v":0},{"$f":"G$112","v":"£m"}]
[null,null,null,null,"Net Totex Underperformance Adjustment - WR - Real",{"$f":" IF( F120 > 0, $F$116 *  (F119), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$117","v":"Net Totex Outperformance Adjustment - WR - Real"},{"$f":"F$117","v":0},"£m"]
[null,null,null,null,{"$f":"E$121","v":"Net Totex Underperformance Adjustment - WR - Real"},{"$f":"F$121","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing - Net totex for cost sharing - WR - Real",{"$f":" IF(F123 <> 0, F123, F124)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$51","v":"Ex-ante allowance above Ofwat forecast  - Water Resources - Real"},{"$f":" InpActive!F$51","v":0},{"$f":" InpActive!G$51","v":"£m"}]
[null,null,null,null,{"$f":" E$41","v":"Totex profile - WR"},{"$f":" F$41","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Ex ante allowance profiled - WR - Real",null,"£m",{"$f":" SUM(J129:P129)","v":0},null,{"$f":" J128 * $F127","v":0},{"$f":" K128 * $F127","v":0},{"$f":" L128 * $F127","v":0},{"$f":" M128 * $F127","v":0},{"$f":" N128 * $F127","v":0},{"$f":" O128 * $F127","v":0},{"$f":" P128 * $F127","v":0}]
[]
[null,null,null,null,{"$f":" E$129","v":"Ex ante allowance profiled - WR - Real"},{"$f":" F$129","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E$71","v":"Time value of money factor - WR"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Ex ante allowance profiled - WR - Real - NPV adjusted",null,"£m",{"$f":" SUM(J133:P133)","v":0},null,{"$f":" J131 * J132","v":0},{"$f":" K131 * K132","v":0},0,0,0,0,0]
[null,null,null,null,"NPV adjusted ex ante allowance - WR - Real",{"$f":" H133","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E125","v":"Active adjustment for cost sharing - Net totex for cost sharing - WR - Real"},{"$f":"F125","v":0},{"$f":"G125","v":"£m"}]
[null,null,null,null,{"$f":" E$134","v":"NPV adjusted ex ante allowance - WR - Real"},{"$f":" F$134","v":0},"£m"]
[null,null,null,null,"Total adjustment for cost sharing after ex ante allowance - WR - Real",{"$f":" F136 - F137","v":0},"£m"]
[]
[]
[null,"Cost sharing for business rates and abstraction"]
[]
[null,null,"Business rates & abstraction charges totex"]
[null,null,null,null,{"$f":"InpActive!E$43","v":"Business rates - WR - Real"},{"$f":"InpActive!F$43","v":0},{"$f":"InpActive!G$43","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$44","v":"Abstraction charges - WR - Real"},{"$f":"InpActive!F$44","v":0},{"$f":"InpActive!G$44","v":"£m"}]
[null,null,null,null,"Business rates & abstraction - Forecast - WR - Real",{"$f":" SUM(F144:F145)","v":0},"£m"]
[]
[null,null,"Profile total forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$146","v":"Business rates & abstraction - Forecast - WR - Real"},{"$f":" F$146","v":0},"£m"]
[null,null,null,null,{"$f":"InpActive!E$36","v":"Business Rates & Abstraction Charges forecast profile - WR"},{"$f":"InpActive!F$36","v":0},{"$f":"InpActive!G$36","v":"%"},{"$f":"InpActive!H$36","v":0},{"$f":"InpActive!I$36","v":0},{"$f":"InpActive!J$36","v":0},{"$f":"InpActive!K$36","v":0},{"$f":"InpActive!L$36","v":0},{"$f":"InpActive!M$36","v":0},{"$f":"InpActive!N$36","v":0},{"$f":"InpActive!O$36","v":0},{"$f":"InpActive!P$36","v":0}]
[null,null,null,null,"Business rates & abstraction - Forecast Profiled - WR - Real",null,"£m ",{"$f":" SUM(J151:P151)","v":0},null,{"$f":" J150 * $F149","v":0},{"$f":" K150 * $F149","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" InpActive!E$46","v":"Business rates - Actual - WR - Real"},{"$f":" InpActive!F$46","v":0},{"$f":" InpActive!G$46","v":"£m"},{"$f":" InpActive!H$46","v":0},{"$f":" InpActive!I$46","v":0},{"$f":" InpActive!J$46","v":0},{"$f":" InpActive!K$46","v":0},{"$f":" InpActive!L$46","v":0},{"$f":" InpActive!M$46","v":0},{"$f":" InpActive!N$46","v":0},{"$f":" InpActive!O$46","v":0},{"$f":" InpActive!P$46","v":0}]
[null,null,null,null,{"$f":" InpActive!E$47","v":"Abstraction charges - Actual - WR - Real"},{"$f":" InpActive!F$47","v":0},{"$f":" InpActive!G$47","v":"£m"},{"$f":" InpActive!H$47","v":0},{"$f":" InpActive!I$47","v":0},{"$f":" InpActive!J$47","v":0},{"$f":" InpActive!K$47","v":0},{"$f":" InpActive!L$47","v":0},{"$f":" InpActive!M$47","v":0},{"$f":" InpActive!N$47","v":0},{"$f":" InpActive!O$47","v":0},{"$f":" InpActive!P$47","v":0}]
[null,null,null,null,"Business rates & abstraction - Outturn - WR - Real",{"$f":" SUM(F153:F154)","v":0},"£m",{"$f":" SUM(J155:P155)","v":0},null,{"$f":" SUM(J153:J154)","v":0},{"$f":" SUM(K153:K154)","v":0},0,0,0,0,0]
[]
[null,null,"Variance to forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$155","v":"Business rates & abstraction - Outturn - WR - Real"},{"$f":" F$155","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$151","v":"Business rates & abstraction - Forecast Profiled - WR - Real"},{"$f":" F$151","v":0},"£m ",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance between forecast and outturn business rates & abstraction charges - WR - Real",null,"£m",{"$f":" SUM(J160:P160)","v":0},null,{"$f":" J158 - J159","v":0},{"$f":" K158 - K159","v":0},0,0,0,0,0]
[]
[null,null,"Variance to forecast business rates and abstraction charges – Time adjusted"]
[null,null,null,null,{"$f":" E$160","v":"Variance between forecast and outturn business rates & abstraction charges - WR - Real"},0,"£m",0,0,0,0,0,0,0,0,{"$f":" P$160","v":0}]
[null,null,null,null,{"$f":"E$71","v":"Time value of money factor - WR"},0,"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Variance on business rates & abstraction charges time value adjusted- WR - Real",null,"£m",{"$f":" SUM(J165:P165)","v":0},null,{"$f":" J163 * J164","v":0},{"$f":" K163 * K164","v":0},{"$f":" L163 * L164","v":0},0,0,0,0]
[null,null,null,null,"Adjustment for busines rates & abstraction for cost sharing - WR - Real",{"$f":" H$165","v":0},"£m"]
[]
[null,null,"Under / Overperformance business rates and abstraction charges"]
[null,null,null,null,{"$f":" InpActive!E$167","v":"Cost sharing rates Abstraction and Business rates - Overperformance"},{"$f":" InpActive!F$167","v":0.75},{"$f":" InpActive!G$167","v":"%"}]
[null,null,null,null,{"$f":"E$166","v":"Adjustment for busines rates & abstraction for cost sharing - WR - Real"},{"$f":"F$166","v":0},{"$f":"G$166","v":"£m"}]
[null,null,null,null,"Business Rates & Abstraction Outperformance Adjustment - WR - Real",{"$f":" IF( F170 < 0, $F$170 *  (1 - F169), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$168","v":"Cost sharing rates Abstraction and Business rates - Underperformance"},{"$f":" InpActive!F$168","v":0.25},{"$f":" InpActive!G$168","v":"%"}]
[null,null,null,null,{"$f":"E$166","v":"Adjustment for busines rates & abstraction for cost sharing - WR - Real"},{"$f":"F$166","v":0},"£m"]
[null,null,null,null,"Business Rates & Abstraction Underperformance Adjustment - WR - Real",{"$f":" IF( F174 > 0, $F$174 *  (F173), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$171","v":"Business Rates & Abstraction Outperformance Adjustment - WR - Real"},{"$f":"F$171","v":0},"£m"]
[null,null,null,null,{"$f":"E$175","v":"Business Rates & Abstraction Underperformance Adjustment - WR - Real"},{"$f":"F$175","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing business rates and abstraction - WR - Real",{"$f":" IF(F177 <> 0, F177, F178)","v":0},"£m"]
[]
[]
[null,"Total adjustments for cost sharing"]
[null,null,null,null,{"$f":"E$89","v":"Active adjustment for cost sharing for wage adjustment - WR - Real"},{"$f":"F$89","v":0},{"$f":"G$89","v":"£m"}]
[null,null,null,null,{"$f":" E$138","v":"Total adjustment for cost sharing after ex ante allowance - WR - Real"},{"$f":" F$138","v":0},{"$f":" G$138","v":"£m"}]
[null,null,null,null,{"$f":" E$179","v":"Active adjustment for cost sharing business rates and abstraction - WR - Real"},{"$f":" F$179","v":0},{"$f":" G$179","v":"£m"}]
[null,null,null,null,"Total adjustment for cost sharing - WR - Real",{"$f":" SUM(F183:F185)","v":0},"£m"]
[]
[null,null,"Revenue cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$138","v":"Total adjustment for cost sharing after ex ante allowance - WR - Real"},{"$f":" F$138","v":0},{"$f":" G$138","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$49","v":"Weighted average PAYG rate - WR"},{"$f":"InpActive!F$49","v":0},{"$f":"InpActive!G$49","v":"%"}]
[null,null,null,null,"Revenue adjustment for cost sharing - Net totex for cost sharing - WR - Real",{"$f":" F190 * F191","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$89","v":"Active adjustment for cost sharing for wage adjustment - WR - Real"},{"$f":"F$89","v":0},"£m"]
[null,null,null,null,{"$f":" E$179","v":"Active adjustment for cost sharing business rates and abstraction - WR - Real"},{"$f":" F$179","v":0},{"$f":" G$179","v":"£m"}]
[null,null,null,null,{"$f":"E$192","v":"Revenue adjustment for cost sharing - Net totex for cost sharing - WR - Real"},{"$f":"F$192","v":0},"£m"]
[null,null,null,null,"Total revenue adjustment - WR - Real",{"$f":" SUM(F194:F196)","v":0},"£m"]
[]
[]
[null,null,"RCV cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$138","v":"Total adjustment for cost sharing after ex ante allowance - WR - Real"},{"$f":" F$138","v":0},{"$f":" G$138","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$49","v":"Weighted average PAYG rate - WR"},{"$f":"InpActive!F$49","v":0},{"$f":"InpActive!G$49","v":"%"}]
[null,null,null,null,"RCV adjustment for cost sharing - WR - Real",{"$f":" F202 * (1-F203)","v":0},"£m"]
[]
[]
[]
["WATER NETWORK"]
[]
[null,"Adjustment For Wage Growth"]
[]
[null,null,"Totex for wage adjustment"]
[null,null,null,null,{"$f":" InpActive!E$56","v":"Base Costs - WN - Real"},{"$f":" InpActive!F$56","v":0},{"$f":" InpActive!G$56","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$57","v":"Metering (excluding new connections) for meters requested by optants, customers and businesses - WN - Real"},{"$f":" InpActive!F$57","v":0},{"$f":" InpActive!G$57","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$58","v":"WINEP / NEP ~ In-the-Round - WN - Real"},{"$f":" InpActive!F$58","v":0},{"$f":" InpActive!G$58","v":"£m"}]
[null,null,null,null,"Totex available for wage indexation adjustment - WN - Real",{"$f":" SUM(F213:F215)","v":0},"£m"]
[]
[null,null,"Profile for totex for wage adjustment"]
[null,null,null,null,{"$f":"InpActive!E$60","v":"Opex split profile - WN"},{"$f":"InpActive!F$60","v":0},{"$f":"InpActive!G$60","v":"%"},{"$f":"InpActive!H$60","v":0},{"$f":"InpActive!I$60","v":0},{"$f":"InpActive!J$60","v":0},{"$f":"InpActive!K$60","v":0},{"$f":"InpActive!L$60","v":0},{"$f":"InpActive!M$60","v":0},{"$f":"InpActive!N$60","v":0},{"$f":"InpActive!O$60","v":0},{"$f":"InpActive!P$60","v":0}]
[null,null,null,null,{"$f":"InpActive!E$61","v":"Capex Split Profile - WN"},{"$f":"InpActive!F$61","v":0},{"$f":"InpActive!G$61","v":"%"},{"$f":"InpActive!H$61","v":0},{"$f":"InpActive!I$61","v":0},{"$f":"InpActive!J$61","v":0},{"$f":"InpActive!K$61","v":0},{"$f":"InpActive!L$61","v":0},{"$f":"InpActive!M$61","v":0},{"$f":"InpActive!N$61","v":0},{"$f":"InpActive!O$61","v":0},{"$f":"InpActive!P$61","v":0}]
[null,null,null,null,"Totex profile - WN",null,"%",{"$f":" SUM(J221:P221)","v":0},null,{"$f":" SUM(J219:J220)","v":0},{"$f":" SUM(K219:K220)","v":0},{"$f":" SUM(L219:L220)","v":0},{"$f":" SUM(M219:M220)","v":0},{"$f":" SUM(N219:N220)","v":0},{"$f":" SUM(O219:O220)","v":0},{"$f":" SUM(P219:P220)","v":0}]
[null,null,null,null,"Totex profile - 5 year percentage - WN",{"$f":"H$221","v":0},"%"]
[]
[null,null,null,null,{"$f":" E$222","v":"Totex profile - 5 year percentage - WN"},{"$f":" F$222","v":0},"%"]
[null,null,null,null,"WN Totex profile 100% check",{"$f":" IF(OR($F$44 = 1, F224 = 0), 0, 1)","v":0},"Check"]
[]
[null,null,null,null,{"$f":" E$216","v":"Totex available for wage indexation adjustment - WN - Real"},{"$f":" F$216","v":0},"£m"]
[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,{"$f":" E$221","v":"Totex profile - WN"},{"$f":" F$221","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profiled Totex available for wage indexation adjustment - WN - Real",null,"£m",{"$f":" SUM(J230:P230)","v":0},null,{"$f":" IF(J228 = 1, J229 * $F227, 0)","v":0},{"$f":" IF(K228 = 1, K229 * $F227, 0)","v":0},{"$f":" IF(L228 = 1, L229 * $F227, 0)","v":0},{"$f":" IF(M228 = 1, M229 * $F227, 0)","v":0},{"$f":" IF(N228 = 1, N229 * $F227, 0)","v":0},{"$f":" IF(O228 = 1, O229 * $F227, 0)","v":0},{"$f":" IF(P228 = 1, P229 * $F227, 0)","v":0}]
[]
[null,null,"Totex applicable for wage adjustment by year"]
[null,null,null,null,{"$f":"InpActive!E$149","v":"Percentage totex linked to wage growth - WN"},{"$f":"InpActive!F$149","v":0.38600000000000001},{"$f":"InpActive!G$149","v":"%"}]
[null,null,null,null,{"$f":"E230","v":"Profiled Totex available for wage indexation adjustment - WN - Real"},0,"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profiled Net totex available for wage adj - WN - Real",null,"£m",{"$f":" SUM(J235:P235)","v":0},null,{"$f":" J234 * $F233","v":0},{"$f":" K234 * $F233","v":0},{"$f":" L234 * $F233","v":0},{"$f":" M234 * $F233","v":0},{"$f":" N234 * $F233","v":0},{"$f":" O234 * $F233","v":0},{"$f":" P234 * $F233","v":0}]
[]
[null,null,"Adjustment factor for wage linked totex"]
[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,{"$f":" E$235","v":"Profiled Net totex available for wage adj - WN - Real"},{"$f":" F$235","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Real adjustment factor for wages"},{"$f":" F$26","v":0},"%",0,0,{"$f":" J$26","v":0},{"$f":" K$26","v":0},0,0,0,0,0]
[null,null,null,null,"Profiled adjustment wage related totex - WN - Real",null,"£m",{"$f":" SUM(J241:P241)","v":0},null,{"$f":" IF(J238 = 1, J239 * J240, 0)","v":0},{"$f":" IF(K238 = 1, K239 * K240, 0)","v":0},{"$f":" IF(L238 = 1, L239 * L240, 0)","v":0},{"$f":" IF(M238 = 1, M239 * M240, 0)","v":0},{"$f":" IF(N238 = 1, N239 * N240, 0)","v":0},{"$f":" IF(O238 = 1, O239 * O240, 0)","v":0},{"$f":" IF(P238 = 1, P239 * P240, 0)","v":0}]
[]
[null,null,null,null,{"$f":" E$241","v":"Profiled adjustment wage related totex - WN - Real"},{"$f":" F$241","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$235","v":"Profiled Net totex available for wage adj - WN - Real"},{"$f":" F$235","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast totex - WN",null,"£m",{"$f":" SUM(J245:P245)","v":0},null,{"$f":" J243 - J244","v":0},{"$f":" K243 - K244","v":0},{"$f":" L243 - L244","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast wage linked totex - Time adjusted"]
[null,null,null,null,{"$f":" InpActive!E$174","v":"Financing cost index"},{"$f":" InpActive!F$174","v":0},{"$f":" InpActive!G$174","v":"Index"},{"$f":" InpActive!H$174","v":0},{"$f":" InpActive!I$174","v":0},{"$f":" InpActive!J$174","v":0},{"$f":" InpActive!K$174","v":4},{"$f":" InpActive!L$174","v":3},{"$f":" InpActive!M$174","v":2},{"$f":" InpActive!N$174","v":1},{"$f":" InpActive!O$174","v":0},{"$f":" InpActive!P$174","v":0}]
[null,null,null,null,{"$f":" InpActive!E$177","v":"WACC - WN"},{"$f":" InpActive!F$177","v":0},{"$f":" InpActive!G$177","v":"%"}]
[null,null,null,null,"Time value of money factor - WN",null,"Factor",null,null,{"$f":"(1+$F249) ^ J248","v":1},{"$f":"(1+$F249) ^ K248","v":1},{"$f":"(1+$F249) ^ L248","v":1},{"$f":"(1+$F249) ^ M248","v":1},{"$f":"(1+$F249) ^ N248","v":1},{"$f":"(1+$F249) ^ O248","v":1},{"$f":"(1+$F249) ^ P248","v":1}]
[]
[null,null,null,null,{"$f":" E$245","v":"Variance to forecast totex - WN"},{"$f":" F$245","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$250","v":"Time value of money factor - WN"},{"$f":" F$250","v":0},"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast - WN",null,"£m",{"$f":" SUM(J254:P254)","v":0},null,{"$f":" J252 * J253","v":0},{"$f":" K252 * K253","v":0},0,0,0,0,0]
[null,null,null,null,"Variance to updated Ofwat baseline - WN - Real",{"$f":" H254","v":0},"£m"]
[]
[null,null,"Under / Overperformance on wage linked totex "]
[null,null,null,null,{"$f":" InpActive!E$160","v":"Outperformance Rate - WN"},{"$f":" InpActive!F$160","v":0},{"$f":" InpActive!G$160","v":"%"}]
[null,null,null,null,{"$f":"E$255","v":"Variance to updated Ofwat baseline - WN - Real"},{"$f":"F$255","v":0},"£m"]
[null,null,null,null,"Wages Outperformance Adjustment - WN - Real",{"$f":" IF( F259 < 0, $F$259 *  (1 - F258), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$161","v":"Underperformance Rate - WN"},{"$f":" InpActive!F$161","v":0},{"$f":" InpActive!G$161","v":"%"}]
[null,null,null,null,{"$f":"E$255","v":"Variance to updated Ofwat baseline - WN - Real"},{"$f":"F$255","v":0},"£m"]
[null,null,null,null,"Wages Underperformance Adjustment - WN - Real",{"$f":" IF( F263 > 0, $F$263 *  (F262), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$260","v":"Wages Outperformance Adjustment - WN - Real"},{"$f":"F$260","v":0},"£m"]
[null,null,null,null,{"$f":"E$264","v":"Wages Underperformance Adjustment - WN - Real"},{"$f":"F$264","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing for wage adjustment - WN - Real",{"$f":" IF(F266 <> 0, F266, F267)","v":0},"£m"]
[]
[]
[null,"Cost sharing on net totex availale for reconcilation"]
[]
[null,null,null,null,{"$f":"InpActive!E$66","v":"Net totex for cost sharing reconciliation - WN  - Real"},{"$f":"InpActive!F$66","v":0},{"$f":"InpActive!G$66","v":"£m"},{"$f":"InpActive!H$66","v":0},{"$f":"InpActive!I$66","v":0},{"$f":"InpActive!J$66","v":0},{"$f":"InpActive!K$66","v":0},{"$f":"InpActive!L$66","v":0},{"$f":"InpActive!M$66","v":0},{"$f":"InpActive!N$66","v":0},{"$f":"InpActive!O$66","v":0},{"$f":"InpActive!P$66","v":0}]
[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,"Actual net totex for cost sharing reconciliation - WN - Real",null,"£m",{"$f":" SUM(J275:P275)","v":0},null,{"$f":" J273 * J274","v":0},0,0,0,0,0,0]
[]
[null,null,"Profile for net totex for cost sharing"]
[null,null,null,null,{"$f":"InpActive!E$67","v":"Net totex available for cost sharing - WN  - Real"},{"$f":"InpActive!F$67","v":0},{"$f":"InpActive!G$67","v":"£m"}]
[null,null,null,null,{"$f":" E$221","v":"Totex profile - WN"},{"$f":" F$221","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Net totex available for cost sharing profiled - WN - Real",null,"£m",{"$f":" SUM(J280:P280)","v":0},null,{"$f":" J279 * $F278","v":0},0,0,0,0,0,0]
[]
[null,null,"Variance to forecast net totex for cost sharing"]
[null,null,null,null,{"$f":" E$275","v":"Actual net totex for cost sharing reconciliation - WN - Real"},0,"£m",0,0,0,0,0,{"$f":" M$275","v":0},{"$f":" N$275","v":0},0,0]
[null,null,null,null,{"$f":" E$280","v":"Net totex available for cost sharing profiled - WN - Real"},{"$f":" F$280","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast net totex for cost sharing - WN",null,"£m",{"$f":" SUM(J285:P285)","v":0},null,{"$f":" J283 - J284","v":0},{"$f":" K283 - K284","v":0},{"$f":" L283 - L284","v":0},{"$f":" M283 - M284","v":0},{"$f":" N283 - N284","v":0},{"$f":" O283 - O284","v":0},{"$f":" P283 - P284","v":0}]
[]
[null,null,"Variance to forecast net totex for cost sharing - Time adjusted"]
[null,null,null,null,{"$f":" E$285","v":"Variance to forecast net totex for cost sharing - WN"},{"$f":" F$285","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$250","v":"Time value of money factor - WN"},0,"Factor",0,0,1,{"$f":" K$250","v":1},{"$f":" L$250","v":1},1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast net totex for cost sharing - WN",null,"£m",{"$f":" SUM(J290:P290)","v":0},null,{"$f":" J288 * J289","v":0},{"$f":" K288 * K289","v":0},{"$f":" L288 * L289","v":0},{"$f":" M288 * M289","v":0},{"$f":" N288 * N289","v":0},{"$f":" O288 * O289","v":0},{"$f":" P288 * P289","v":0}]
[null,null,null,null,"Total variance to forecast net totex for cost sharing - WN",{"$f":" $H290","v":0},"£m"]
[]
[null,null,"Under / Overperformance on net totex for cost sharing"]
[null,null,null,null,{"$f":" InpActive!E$160","v":"Outperformance Rate - WN"},{"$f":" InpActive!F$160","v":0},{"$f":" InpActive!G$160","v":"%"}]
[null,null,null,null,{"$f":"E$291","v":"Total variance to forecast net totex for cost sharing - WN"},{"$f":"F$291","v":0},{"$f":"G$291","v":"£m"}]
[null,null,null,null,"Net Totex Outperformance Adjustment - WN - Real",{"$f":" IF( F295 < 0, $F$295 *  (1 - F294), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$161","v":"Underperformance Rate - WN"},{"$f":" InpActive!F$161","v":0},{"$f":" InpActive!G$161","v":"%"}]
[null,null,null,null,{"$f":"E$291","v":"Total variance to forecast net totex for cost sharing - WN"},{"$f":"F$291","v":0},{"$f":"G$291","v":"£m"}]
[null,null,null,null,"Net Totex Underperformance Adjustment - WN - Real",{"$f":" IF( F299 > 0, $F$299 *  (F298), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$296","v":"Net Totex Outperformance Adjustment - WN - Real"},{"$f":"F$296","v":0},"£m"]
[null,null,null,null,{"$f":"E$300","v":"Net Totex Underperformance Adjustment - WN - Real"},{"$f":"F$300","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing - Net toex for cost sharing - WN - Real",{"$f":" IF(F302 <> 0, F302, F303)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$78","v":"Ex-ante allowance above Ofwat forecast  - Water Network - Real"},{"$f":" InpActive!F$78","v":0},{"$f":" InpActive!G$78","v":"£m"}]
[null,null,null,null,{"$f":" E$221","v":"Totex profile - WN"},{"$f":" F$221","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Ex ante allowance profiled - WN - Real",null,"£m",{"$f":" SUM(J308:P308)","v":0},null,{"$f":" J307 * $F306","v":0},{"$f":" K307 * $F306","v":0},{"$f":" L307 * $F306","v":0},{"$f":" M307 * $F306","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" E$308","v":"Ex ante allowance profiled - WN - Real"},{"$f":" F$308","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$250","v":"Time value of money factor - WN"},0,"Factor",0,0,1,{"$f":" K$250","v":1},{"$f":" L$250","v":1},1,1,1,1]
[null,null,null,null,"Ex ante allowance profiled - WN - Real - NPV adjusted",null,"£m",{"$f":" SUM(J312:P312)","v":0},null,{"$f":" J310 * J311","v":0},{"$f":" K310 * K311","v":0},{"$f":" L310 * L311","v":0},0,0,0,0]
[null,null,null,null,"NPV adjusted ex ante allowance - WN - Real",{"$f":" H312","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E304","v":"Active adjustment for cost sharing - Net toex for cost sharing - WN - Real"},{"$f":"F304","v":0},{"$f":"G304","v":"£m"}]
[null,null,null,null,{"$f":" E$313","v":"NPV adjusted ex ante allowance - WN - Real"},{"$f":" F$313","v":0},"£m"]
[null,null,null,null,"Total adjustment for cost sharing after ex ante allowance - WN - Real",{"$f":" F315 - F316","v":0},"£m"]
[]
[]
[null,"Cost sharing for business rates and abstraction"]
[]
[null,null,"Business rates & abstraction charges totex"]
[null,null,null,null,{"$f":"InpActive!E$70","v":"Business rates - WN  - Real"},{"$f":"InpActive!F$70","v":0},{"$f":"InpActive!G$70","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$71","v":"Abstraction charges - WN - Real"},{"$f":"InpActive!F$71","v":0},{"$f":"InpActive!G$71","v":"£m"}]
[null,null,null,null,"Business rates & abstraction - Forecast - WN - Real",{"$f":" SUM(F323:F324)","v":0},"£m"]
[]
[null,null,"Profile total forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$325","v":"Business rates & abstraction - Forecast - WN - Real"},{"$f":" F$325","v":0},{"$f":" G$325","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$63","v":"Business Rates & Abstraction Charges forecast profile - WN"},{"$f":"InpActive!F$63","v":0},{"$f":"InpActive!G$63","v":"%"},{"$f":"InpActive!H$63","v":0},{"$f":"InpActive!I$63","v":0},{"$f":"InpActive!J$63","v":0},{"$f":"InpActive!K$63","v":0},{"$f":"InpActive!L$63","v":0},{"$f":"InpActive!M$63","v":0},{"$f":"InpActive!N$63","v":0},{"$f":"InpActive!O$63","v":0},{"$f":"InpActive!P$63","v":0}]
[null,null,null,null,"Business rates & abstraction - Forecast Profiled - WN - Real",null,"£m ",{"$f":" SUM(J330:P330)","v":0},null,{"$f":" J329 * $F328","v":0},{"$f":" K329 * $F328","v":0},{"$f":" L329 * $F328","v":0},{"$f":" M329 * $F328","v":0},{"$f":" N329 * $F328","v":0},{"$f":" O329 * $F328","v":0},{"$f":" P329 * $F328","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E$73","v":"Business rates - Actual - WN - Real"},{"$f":" InpActive!F$73","v":0},{"$f":" InpActive!G$73","v":"£m"},{"$f":" InpActive!H$73","v":0},{"$f":" InpActive!I$73","v":0},{"$f":" InpActive!J$73","v":0},{"$f":" InpActive!K$73","v":0},{"$f":" InpActive!L$73","v":0},{"$f":" InpActive!M$73","v":0},{"$f":" InpActive!N$73","v":0},{"$f":" InpActive!O$73","v":0},{"$f":" InpActive!P$73","v":0}]
[null,null,null,null,{"$f":" InpActive!E$74","v":"Abstraction charges - Actual - WN - Real"},{"$f":" InpActive!F$74","v":0},{"$f":" InpActive!G$74","v":"£m"},{"$f":" InpActive!H$74","v":0},{"$f":" InpActive!I$74","v":0},{"$f":" InpActive!J$74","v":0},{"$f":" InpActive!K$74","v":0},{"$f":" InpActive!L$74","v":0},{"$f":" InpActive!M$74","v":0},{"$f":" InpActive!N$74","v":0},{"$f":" InpActive!O$74","v":0},{"$f":" InpActive!P$74","v":0}]
[null,null,null,null,"Business rates & abstraction - Outturn - WN - Real",null,"£m",{"$f":" SUM(J334:P334)","v":0},null,{"$f":" SUM(J332:J333)","v":0},{"$f":" SUM(K332:K333)","v":0},0,0,0,0,0]
[]
[null,null,"Variance to forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$334","v":"Business rates & abstraction - Outturn - WN - Real"},{"$f":" F$334","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$330","v":"Business rates & abstraction - Forecast Profiled - WN - Real"},{"$f":" F$330","v":0},"£m ",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance between forecast and outturn business rates & abstraction charges - WN - Real",null,"£m",{"$f":" SUM(J339:P339)","v":0},null,{"$f":" J337 - J338","v":0},0,0,0,0,0,0]
[]
[null,null,"Variance to forecast business rates and abstraction charges – Time adjusted"]
[null,null,null,null,{"$f":" E$339","v":"Variance between forecast and outturn business rates & abstraction charges - WN - Real"},{"$f":" F$339","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$250","v":"Time value of money factor - WN"},0,"Factor",0,0,1,{"$f":" K$250","v":1},{"$f":" L$250","v":1},1,1,1,1]
[null,null,null,null,"Variance on business rates & abstraction charges time value adjusted- WN - Real",null,"£m",{"$f":" SUM(J344:P344)","v":0},null,{"$f":" J342 * J343","v":0},{"$f":" K342 * K343","v":0},{"$f":" L342 * L343","v":0},0,0,0,0]
[null,null,null,null,"Adjustment for busines rates & abstraction for cost sharing - WN - Real",{"$f":" H$344","v":0},"£m"]
[]
[null,null,"Under / Overperformance business rates and abstraction charges"]
[null,null,null,null,{"$f":" InpActive!E$167","v":"Cost sharing rates Abstraction and Business rates - Overperformance"},{"$f":" InpActive!F$167","v":0.75},{"$f":" InpActive!G$167","v":"%"}]
[null,null,null,null,{"$f":"E$345","v":"Adjustment for busines rates & abstraction for cost sharing - WN - Real"},{"$f":"F$345","v":0},{"$f":"G$345","v":"£m"}]
[null,null,null,null,"Business Rates & Abstraction Outperformance Adjustment - WN - Real",{"$f":" IF( F349 < 0, $F$349 *  (1 - F348), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$168","v":"Cost sharing rates Abstraction and Business rates - Underperformance"},{"$f":" InpActive!F$168","v":0.25},{"$f":" InpActive!G$168","v":"%"}]
[null,null,null,null,{"$f":"E$345","v":"Adjustment for busines rates & abstraction for cost sharing - WN - Real"},{"$f":"F$345","v":0},{"$f":"G$345","v":"£m"}]
[null,null,null,null,"Business Rates & Abstraction Underperformance Adjustment - WN - Real",{"$f":" IF( F353 > 0, $F$353 *  (F352), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$350","v":"Business Rates & Abstraction Outperformance Adjustment - WN - Real"},{"$f":"F$350","v":0},"£m"]
[null,null,null,null,{"$f":"E$354","v":"Business Rates & Abstraction Underperformance Adjustment - WN - Real"},{"$f":"F$354","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing business rates and abstraction - WN - Real",{"$f":" IF(F356 <> 0, F356, F357)","v":0},"£m"]
[]
[]
[null,"Total adjustments for cost sharing"]
[null,null,null,null,{"$f":" E$268","v":"Active adjustment for cost sharing for wage adjustment - WN - Real"},{"$f":" F$268","v":0},{"$f":" G$268","v":"£m"}]
[null,null,null,null,{"$f":" E$317","v":"Total adjustment for cost sharing after ex ante allowance - WN - Real"},{"$f":" F$317","v":0},"£m"]
[null,null,null,null,{"$f":" E$358","v":"Active adjustment for cost sharing business rates and abstraction - WN - Real"},{"$f":" F$358","v":0},{"$f":" G$358","v":"£m"}]
[null,null,null,null,"Total adjustment for cost sharing - WN - Real",{"$f":" SUM(F362:F364)","v":0},"£m"]
[]
[null,null,"Revenue cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$317","v":"Total adjustment for cost sharing after ex ante allowance - WN - Real"},{"$f":" F$317","v":0},"£m"]
[null,null,null,null,{"$f":"InpActive!E$76","v":"Weighted average PAYG rate - WN"},{"$f":"InpActive!F$76","v":0},{"$f":"InpActive!G$76","v":"%"}]
[null,null,null,null,"Revenue adjustment for cost sharing - Net totex for cost sharing - WN - Real",{"$f":" F369 * F370","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$268","v":"Active adjustment for cost sharing for wage adjustment - WN - Real"},{"$f":" F$268","v":0},{"$f":" G$268","v":"£m"}]
[null,null,null,null,{"$f":" E$358","v":"Active adjustment for cost sharing business rates and abstraction - WN - Real"},{"$f":" F$358","v":0},{"$f":" G$358","v":"£m"}]
[null,null,null,null,{"$f":"E$371","v":"Revenue adjustment for cost sharing - Net totex for cost sharing - WN - Real"},{"$f":"F$371","v":0},"£m"]
[null,null,null,null,"Total revenue adjustment - WN - Real",{"$f":" SUM(F373:F375)","v":0},"£m"]
[]
[]
[null,null,"RCV cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$317","v":"Total adjustment for cost sharing after ex ante allowance - WN - Real"},{"$f":" F$317","v":0},"£m"]
[null,null,null,null,{"$f":"InpActive!E$76","v":"Weighted average PAYG rate - WN"},{"$f":"InpActive!F$76","v":0},{"$f":"InpActive!G$76","v":"%"}]
[null,null,null,null,"RCV adjustment for cost sharing - WN - Real",{"$f":" F381 * (1-F382)","v":0},"£m"]
[]
[]
[]
["WASTEWATER NETWORK"]
[]
[null,"Adjustment For Wage Growth"]
[]
[null,null,"Totex for wage adjustment"]
[null,null,null,null,{"$f":" InpActive!E$83","v":"Base Costs - WWN - Real"},{"$f":" InpActive!F$83","v":0},{"$f":" InpActive!G$83","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$84","v":"Metering (excluding new connections) for meters requested by optants, customers and businesses - WWN - Real"},{"$f":" InpActive!F$84","v":0},{"$f":" InpActive!G$84","v":"£m"}]
[null,null,null,null,{"$f":" InpActive!E$85","v":"WINEP / NEP ~ In-the-Round - WWN - Real"},{"$f":" InpActive!F$85","v":0},{"$f":" InpActive!G$85","v":"£m"}]
[null,null,null,null,"Totex available for wage indexation adjustment - WWN - Real",{"$f":" SUM(F392:F394)","v":0},"£m"]
[]
[null,null,"Profile for totex for wage adjustment"]
[null,null,null,null,{"$f":"InpActive!E$87","v":"Opex split profile - WWN"},{"$f":"InpActive!F$87","v":0},{"$f":"InpActive!G$87","v":"%"},{"$f":"InpActive!H$87","v":0},{"$f":"InpActive!I$87","v":0},{"$f":"InpActive!J$87","v":0},{"$f":"InpActive!K$87","v":0},{"$f":"InpActive!L$87","v":0},{"$f":"InpActive!M$87","v":0},{"$f":"InpActive!N$87","v":0},{"$f":"InpActive!O$87","v":0},{"$f":"InpActive!P$87","v":0}]
[null,null,null,null,{"$f":"InpActive!E$88","v":"Capex Split Profile - WWN"},{"$f":"InpActive!F$88","v":0},{"$f":"InpActive!G$88","v":"%"},{"$f":"InpActive!H$88","v":0},{"$f":"InpActive!I$88","v":0},{"$f":"InpActive!J$88","v":0},{"$f":"InpActive!K$88","v":0},{"$f":"InpActive!L$88","v":0},{"$f":"InpActive!M$88","v":0},{"$f":"InpActive!N$88","v":0},{"$f":"InpActive!O$88","v":0},{"$f":"InpActive!P$88","v":0}]
[null,null,null,null,"Totex profile - WWN",null,"%",{"$f":" SUM(J400:P400)","v":0},null,{"$f":" SUM(J398:J399)","v":0},{"$f":" SUM(K398:K399)","v":0},{"$f":" SUM(L398:L399)","v":0},{"$f":" SUM(M398:M399)","v":0},{"$f":" SUM(N398:N399)","v":0},{"$f":" SUM(O398:O399)","v":0},{"$f":" SUM(P398:P399)","v":0}]
[null,null,null,null,"Totex profile - 5 year percentage - WWN",{"$f":"H$221","v":0},"%"]
[]
[null,null,null,null,{"$f":" E$401","v":"Totex profile - 5 year percentage - WWN"},{"$f":" F$401","v":0},"%"]
[null,null,null,null,"WWN Totex profile 100% check",{"$f":" IF(OR($F$44 = 1, F403 = 0), 0, 1)","v":0},"Check"]
[]
[null,null,null,null,{"$f":" E$395","v":"Totex available for wage indexation adjustment - WWN - Real"},{"$f":" F$395","v":0},"£m"]
[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,{"$f":" E$400","v":"Totex profile - WWN"},{"$f":" F$400","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profiled Totex available for wage indexation adjustment - WWN - Real",null,"£m",{"$f":" SUM(J409:P409)","v":0},null,{"$f":" IF(J407 = 1, J408 * $F406, 0)","v":0},{"$f":" IF(K407 = 1, K408 * $F406, 0)","v":0},{"$f":" IF(L407 = 1, L408 * $F406, 0)","v":0},{"$f":" IF(M407 = 1, M408 * $F406, 0)","v":0},{"$f":" IF(N407 = 1, N408 * $F406, 0)","v":0},{"$f":" IF(O407 = 1, O408 * $F406, 0)","v":0},{"$f":" IF(P407 = 1, P408 * $F406, 0)","v":0}]
[]
[null,null,"Totex applicable for wage adjustment by year"]
[null,null,null,null,{"$f":"InpActive!E$151","v":"Percentage totex linked to wage growth - WWN"},{"$f":"InpActive!F$151","v":0.38600000000000001},{"$f":"InpActive!G$151","v":"%"}]
[null,null,null,null,{"$f":"E409","v":"Profiled Totex available for wage indexation adjustment - WWN - Real"},0,"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Profiled Net totex available for wage adj - WWN - Real",null,"£m",{"$f":" SUM(J414:P414)","v":0},null,{"$f":" J413 * $F412","v":0},{"$f":" K413 * $F412","v":0},{"$f":" L413 * $F412","v":0},{"$f":" M413 * $F412","v":0},{"$f":" N413 * $F412","v":0},{"$f":" O413 * $F412","v":0},{"$f":" P413 * $F412","v":0}]
[]
[null,null,"Adjustment factor for wage linked totex"]
[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,{"$f":" E$414","v":"Profiled Net totex available for wage adj - WWN - Real"},{"$f":" F$414","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$26","v":"Real adjustment factor for wages"},0,"%",0,0,{"$f":" J$26","v":0},{"$f":" K$26","v":0},0,0,0,0,0]
[null,null,null,null,"Profiled adjustment wage related totex - WWN - Real",null,"£m",{"$f":" SUM(J420:P420)","v":0},null,{"$f":" IF(J417 = 1, J418 * J419, 0)","v":0},{"$f":" IF(K417 = 1, K418 * K419, 0)","v":0},{"$f":" IF(L417 = 1, L418 * L419, 0)","v":0},{"$f":" IF(M417 = 1, M418 * M419, 0)","v":0},{"$f":" IF(N417 = 1, N418 * N419, 0)","v":0},{"$f":" IF(O417 = 1, O418 * O419, 0)","v":0},{"$f":" IF(P417 = 1, P418 * P419, 0)","v":0}]
[]
[null,null,null,null,{"$f":" E$420","v":"Profiled adjustment wage related totex - WWN - Real"},{"$f":" F$420","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$414","v":"Profiled Net totex available for wage adj - WWN - Real"},{"$f":" F$414","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast totex - WWN",null,"£m",{"$f":" SUM(J424:P424)","v":0},null,{"$f":" J422 - J423","v":0},{"$f":" K422 - K423","v":0},{"$f":" L422 - L423","v":0},0,0,0,0]
[]
[null,null,"Variance to forecast wage linked totex - Time adjusted"]
[null,null,null,null,{"$f":" InpActive!E$174","v":"Financing cost index"},{"$f":" InpActive!F$174","v":0},{"$f":" InpActive!G$174","v":"Index"},{"$f":" InpActive!H$174","v":0},{"$f":" InpActive!I$174","v":0},{"$f":" InpActive!J$174","v":0},{"$f":" InpActive!K$174","v":4},{"$f":" InpActive!L$174","v":3},{"$f":" InpActive!M$174","v":2},{"$f":" InpActive!N$174","v":1},{"$f":" InpActive!O$174","v":0},{"$f":" InpActive!P$174","v":0}]
[null,null,null,null,{"$f":" InpActive!E$178","v":"WACC - WWN"},{"$f":" InpActive!F$178","v":0},{"$f":" InpActive!G$178","v":"%"}]
[null,null,null,null,"Time value of money factor - WWN",null,"Factor",null,null,{"$f":"(1+$F428) ^ J427","v":1},{"$f":"(1+$F428) ^ K427","v":1},{"$f":"(1+$F428) ^ L427","v":1},{"$f":"(1+$F428) ^ M427","v":1},{"$f":"(1+$F428) ^ N427","v":1},{"$f":"(1+$F428) ^ O427","v":1},{"$f":"(1+$F428) ^ P427","v":1}]
[]
[null,null,null,null,{"$f":" E$424","v":"Variance to forecast totex - WWN"},{"$f":" F$424","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$429","v":"Time value of money factor - WWN"},{"$f":" F$429","v":0},"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast - WWN",null,"£m",{"$f":" SUM(J433:P433)","v":0},null,{"$f":" J431 * J432","v":0},{"$f":" K431 * K432","v":0},0,0,0,0,0]
[null,null,null,null,"Variance to updated Ofwat baseline - WWN - Real",{"$f":" H433","v":0},"£m"]
[]
[null,null,"Under / Overperformance on wage linked totex "]
[null,null,null,null,{"$f":" InpActive!E$163","v":"Outperformance Rate - WWN"},{"$f":" InpActive!F$163","v":0},{"$f":" InpActive!G$163","v":"%"}]
[null,null,null,null,{"$f":"E$434","v":"Variance to updated Ofwat baseline - WWN - Real"},{"$f":"F$434","v":0},{"$f":"G$434","v":"£m"}]
[null,null,null,null,"Wages Outperformance Adjustment - WWN - Real",{"$f":" IF( F438 < 0, $F$438 *  (1 - F437), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$164","v":"Underperformance Rate - WWN"},{"$f":" InpActive!F$164","v":0},{"$f":" InpActive!G$164","v":"%"}]
[null,null,null,null,{"$f":"E$434","v":"Variance to updated Ofwat baseline - WWN - Real"},{"$f":"F$434","v":0},{"$f":"G$434","v":"£m"}]
[null,null,null,null,"Wages Underperformance Adjustment - WWN - Real",{"$f":" IF( F442 > 0, $F$442 *  (F441), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$439","v":"Wages Outperformance Adjustment - WWN - Real"},{"$f":"F$439","v":0},"£m"]
[null,null,null,null,{"$f":"E$443","v":"Wages Underperformance Adjustment - WWN - Real"},{"$f":"F$443","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing for wage adjustment - WWN - Real",{"$f":" IF(F445 <> 0, F445, F446)","v":0},"£m"]
[]
[]
[null,"Cost sharing on net totex availale for reconcilation"]
[]
[null,null,null,null,{"$f":"InpActive!E$93","v":"Net totex for cost sharing reconciliation - WWN - Real"},{"$f":"InpActive!F$93","v":0},{"$f":"InpActive!G$93","v":"£m"},{"$f":"InpActive!H$93","v":0},{"$f":"InpActive!I$93","v":0},{"$f":"InpActive!J$93","v":0},{"$f":"InpActive!K$93","v":0},{"$f":"InpActive!L$93","v":0},{"$f":"InpActive!M$93","v":0},{"$f":"InpActive!N$93","v":0},{"$f":"InpActive!O$93","v":0},{"$f":"InpActive!P$93","v":0}]
[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,"Actual net totex for cost sharing reconciliation - WWN - Real",null,"£m",{"$f":" SUM(J454:P454)","v":0},null,{"$f":" J452 * J453","v":0},{"$f":" K452 * K453","v":0},{"$f":" L452 * L453","v":0},0,0,0,0]
[]
[null,null,"Profile for net totex for cost sharing"]
[null,null,null,null,{"$f":"InpActive!E$94","v":"Net totex available for cost sharing - WWN - Real"},{"$f":"InpActive!F$94","v":0},{"$f":"InpActive!G$94","v":"£m"}]
[null,null,null,null,{"$f":" E$400","v":"Totex profile - WWN"},{"$f":" F$400","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Net totex available for cost sharing profiled - WWN - Real",null,"£m",{"$f":" SUM(J459:P459)","v":0},null,{"$f":" J458 * $F457","v":0},0,0,0,0,0,0]
[]
[null,null,"Variance to forecast net totex for cost sharing"]
[null,null,null,null,{"$f":" E$454","v":"Actual net totex for cost sharing reconciliation - WWN - Real"},{"$f":" F$454","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$459","v":"Net totex available for cost sharing profiled - WWN - Real"},{"$f":" F$459","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance to forecast net totex for cost sharing - WWN",null,"£m",{"$f":" SUM(J464:P464)","v":0},null,{"$f":" J462 - J463","v":0},{"$f":" K462 - K463","v":0},{"$f":" L462 - L463","v":0},{"$f":" M462 - M463","v":0},{"$f":" N462 - N463","v":0},{"$f":" O462 - O463","v":0},{"$f":" P462 - P463","v":0}]
[]
[null,null,"Variance to forecast net totex for cost sharing - Time adjusted"]
[null,null,null,null,{"$f":" E$464","v":"Variance to forecast net totex for cost sharing - WWN"},{"$f":" F$464","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$429","v":"Time value of money factor - WWN"},{"$f":" F$429","v":0},"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Time adjusted variance to forecast net totex for cost sharing - WWN",null,"£m",{"$f":" SUM(J469:P469)","v":0},null,{"$f":" J467 * J468","v":0},{"$f":" K467 * K468","v":0},{"$f":" L467 * L468","v":0},{"$f":" M467 * M468","v":0},{"$f":" N467 * N468","v":0},{"$f":" O467 * O468","v":0},{"$f":" P467 * P468","v":0}]
[null,null,null,null,"Total variance to forecast net totex for cost sharing - WWN",{"$f":" $H469","v":0},"£m"]
[]
[null,null,"Under / Overperformance on net totex for cost sharing"]
[null,null,null,null,{"$f":" InpActive!E$163","v":"Outperformance Rate - WWN"},{"$f":" InpActive!F$163","v":0},{"$f":" InpActive!G$163","v":"%"}]
[null,null,null,null,{"$f":"E$470","v":"Total variance to forecast net totex for cost sharing - WWN"},{"$f":"F$470","v":0},{"$f":"G$470","v":"£m"}]
[null,null,null,null,"Net Totex Outperformance Adjustment - WWN - Real",{"$f":" IF( F474 < 0, $F$474 *  (1 - F473), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$164","v":"Underperformance Rate - WWN"},{"$f":" InpActive!F$164","v":0},{"$f":" InpActive!G$164","v":"%"}]
[null,null,null,null,{"$f":"E$470","v":"Total variance to forecast net totex for cost sharing - WWN"},{"$f":"F$470","v":0},{"$f":"G$470","v":"£m"}]
[null,null,null,null,"Net Totex Underperformance Adjustment - WWN - Real",{"$f":" IF( F478 > 0, $F$478 *  (F477), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E$475","v":"Net Totex Outperformance Adjustment - WWN - Real"},{"$f":"F$475","v":0},"£m"]
[null,null,null,null,{"$f":"E$479","v":"Net Totex Underperformance Adjustment - WWN - Real"},{"$f":"F$479","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing - Net totex for cost sharing - WWN - Real",{"$f":" IF(F481 <> 0, F481, F482)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$105","v":"Ex-ante allowance above Ofwat forecast  - Wastewater Network - Real"},{"$f":" InpActive!F$105","v":0},{"$f":" InpActive!G$105","v":"£m"}]
[null,null,null,null,{"$f":" E$400","v":"Totex profile - WWN"},{"$f":" F$400","v":0},"%",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Ex ante allowance profiled - WWN - Real",null,"£m",{"$f":" SUM(J487:P487)","v":0},null,{"$f":" J486 * $F485","v":0},{"$f":" K486 * $F485","v":0},{"$f":" L486 * $F485","v":0},{"$f":" M486 * $F485","v":0},0,0,0]
[]
[null,null,null,null,{"$f":" E$487","v":"Ex ante allowance profiled - WWN - Real"},{"$f":" F$487","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$250","v":"Time value of money factor - WN"},0,"Factor",0,0,1,{"$f":" K$250","v":1},{"$f":" L$250","v":1},1,1,1,1]
[null,null,null,null,"Ex ante allowance profiled - WWN - Real - NPV adjusted",null,"£m",{"$f":" SUM(J491:P491)","v":0},null,{"$f":" J489 * J490","v":0},{"$f":" K489 * K490","v":0},{"$f":" L489 * L490","v":0},0,0,0,0]
[null,null,null,null,"NPV adjusted ex ante allowance - WWN - Real",{"$f":" H491","v":0},"£m"]
[]
[null,null,null,null,{"$f":"E483","v":"Active adjustment for cost sharing - Net totex for cost sharing - WWN - Real"},{"$f":"F483","v":0},"£m"]
[null,null,null,null,{"$f":" E$492","v":"NPV adjusted ex ante allowance - WWN - Real"},{"$f":" F$492","v":0},"£m"]
[null,null,null,null,"Total adjustment for cost sharing after ex ante allowance - WWN - Real",{"$f":" F494 - F495","v":0},"£m"]
[]
[]
[null,"Cost sharing for business rates and abstraction"]
[]
[null,null,"Business rates & abstraction charges totex"]
[null,null,null,null,{"$f":"InpActive!E$97","v":"Business rates - WWN - Real"},{"$f":"InpActive!F$97","v":0},{"$f":"InpActive!G$97","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$98","v":"Abstraction charges - WWN - Real"},{"$f":"InpActive!F$98","v":0},{"$f":"InpActive!G$98","v":"£m"}]
[null,null,null,null,"Business rates & abstraction - Forecast - WWN - Real",{"$f":" SUM(F502:F503)","v":0},"£m"]
[]
[null,null,"Profile total forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$504","v":"Business rates & abstraction - Forecast - WWN - Real"},{"$f":" F$504","v":0},{"$f":" G$504","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$90","v":"Business Rates & Abstraction Charges forecast profile - WWN"},{"$f":"InpActive!F$90","v":0},{"$f":"InpActive!G$90","v":"%"},{"$f":"InpActive!H$90","v":0},{"$f":"InpActive!I$90","v":0},{"$f":"InpActive!J$90","v":0},{"$f":"InpActive!K$90","v":0},{"$f":"InpActive!L$90","v":0},{"$f":"InpActive!M$90","v":0},{"$f":"InpActive!N$90","v":0},{"$f":"InpActive!O$90","v":0},{"$f":"InpActive!P$90","v":0}]
[null,null,null,null,"Business rates & abstraction - Forecast Profiled - WWN - Real",null,"£m ",{"$f":" SUM(J509:P509)","v":0},null,{"$f":" J508 * $F507","v":0},{"$f":" K508 * $F507","v":0},{"$f":" L508 * $F507","v":0},{"$f":" M508 * $F507","v":0},{"$f":" N508 * $F507","v":0},{"$f":" O508 * $F507","v":0},{"$f":" P508 * $F507","v":0}]
[]
[null,null,null,null,{"$f":" InpActive!E$100","v":"Business rates - Actual - WWN - Real"},{"$f":" InpActive!F$100","v":0},{"$f":" InpActive!G$100","v":"£m"},{"$f":" InpActive!H$100","v":0},{"$f":" InpActive!I$100","v":0},{"$f":" InpActive!J$100","v":0},{"$f":" InpActive!K$100","v":0},{"$f":" InpActive!L$100","v":0},{"$f":" InpActive!M$100","v":0},{"$f":" InpActive!N$100","v":0},{"$f":" InpActive!O$100","v":0},{"$f":" InpActive!P$100","v":0}]
[null,null,null,null,{"$f":" InpActive!E$101","v":"Abstraction charges - Actual - WWN - Real"},{"$f":" InpActive!F$101","v":0},{"$f":" InpActive!G$101","v":"£m"},{"$f":" InpActive!H$101","v":0},{"$f":" InpActive!I$101","v":0},{"$f":" InpActive!J$101","v":0},{"$f":" InpActive!K$101","v":0},{"$f":" InpActive!L$101","v":0},{"$f":" InpActive!M$101","v":0},{"$f":" InpActive!N$101","v":0},{"$f":" InpActive!O$101","v":0},{"$f":" InpActive!P$101","v":0}]
[null,null,null,null,"Business rates & abstraction - Outturn - WWN - Real",{"$f":" SUM(F511:F512)","v":0},"£m",{"$f":" SUM(J513:P513)","v":0},null,{"$f":" SUM(J511:J512)","v":0},0,0,0,0,0,0]
[]
[null,null,"Variance to forecast business rates and abstraction charges"]
[null,null,null,null,{"$f":" E$513","v":"Business rates & abstraction - Outturn - WWN - Real"},{"$f":" F$513","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$509","v":"Business rates & abstraction - Forecast Profiled - WWN - Real"},{"$f":" F$509","v":0},"£m ",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Variance between forecast and outturn business rates & abstraction charges - WWN - Real",null,"£m",{"$f":" SUM(J518:P518)","v":0},null,{"$f":" J516 - J517","v":0},{"$f":" K516 - K517","v":0},{"$f":" L516 - L517","v":0},{"$f":" M516 - M517","v":0},{"$f":" N516 - N517","v":0},{"$f":" O516 - O517","v":0},{"$f":" P516 - P517","v":0}]
[]
[null,null,"Variance to forecast business rates and abstraction charges - Time adjusted"]
[null,null,null,null,{"$f":" E$518","v":"Variance between forecast and outturn business rates & abstraction charges - WWN - Real"},{"$f":" F$518","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$429","v":"Time value of money factor - WWN"},{"$f":" F$429","v":0},"Factor",0,0,1,1,1,1,1,1,1]
[null,null,null,null,"Variance on business rates & abstraction charges time value adjusted- WWN - Real",null,"£m",{"$f":" SUM(J523:P523)","v":0},null,{"$f":" J521 * J522","v":0},{"$f":" K521 * K522","v":0},{"$f":" L521 * L522","v":0},0,0,0,0]
[null,null,null,null,"Adjustment for busines rates & abstraction for cost sharing - WWN - Real",{"$f":" H$523","v":0},"£m"]
[]
[null,null,"Under / Overperformance business rates and abstraction charges"]
[null,null,null,null,{"$f":" InpActive!E$167","v":"Cost sharing rates Abstraction and Business rates - Overperformance"},{"$f":" InpActive!F$167","v":0.75},{"$f":" InpActive!G$167","v":"%"}]
[null,null,null,null,{"$f":"E$524","v":"Adjustment for busines rates & abstraction for cost sharing - WWN - Real"},{"$f":"F$524","v":0},{"$f":"G$524","v":"£m"}]
[null,null,null,null,"Business Rates & Abstraction Outperformance Adjustment - WWN - Real",{"$f":" IF( F528 < 0, $F$528 *  (1 - F527), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" InpActive!E$168","v":"Cost sharing rates Abstraction and Business rates - Underperformance"},{"$f":" InpActive!F$168","v":0.25},{"$f":" InpActive!G$168","v":"%"}]
[null,null,null,null,{"$f":"E$524","v":"Adjustment for busines rates & abstraction for cost sharing - WWN - Real"},{"$f":"F$524","v":0},{"$f":"G$524","v":"£m"}]
[null,null,null,null,"Business Rates & Abstraction Underperformance Adjustment - WWN - Real",{"$f":" IF( F532 > 0, $F$532 *  (F531), 0)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$529","v":"Business Rates & Abstraction Outperformance Adjustment - WWN - Real"},{"$f":" F$529","v":0},"£m"]
[null,null,null,null,{"$f":" E$533","v":"Business Rates & Abstraction Underperformance Adjustment - WWN - Real"},{"$f":" F$533","v":0},"£m"]
[null,null,null,null,"Active adjustment for cost sharing business rates and abstraction - WWN - Real",{"$f":" IF(F535 <> 0, F535, F536)","v":0},"£m"]
[]
[]
[null,"Total adjustments for cost sharing"]
[null,null,null,null,{"$f":" E$447","v":"Active adjustment for cost sharing for wage adjustment - WWN - Real"},{"$f":" F$447","v":0},{"$f":" G$447","v":"£m"}]
[null,null,null,null,{"$f":" E$496","v":"Total adjustment for cost sharing after ex ante allowance - WWN - Real"},{"$f":" F$496","v":0},{"$f":" G$496","v":"£m"}]
[null,null,null,null,{"$f":" E$537","v":"Active adjustment for cost sharing business rates and abstraction - WWN - Real"},{"$f":" F$537","v":0},{"$f":" G$537","v":"£m"}]
[null,null,null,null,"Total adjustment for cost sharing - WWN - Real",{"$f":" SUM(F541:F543)","v":0},"£m"]
[]
[null,null,"Revenue cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$496","v":"Total adjustment for cost sharing after ex ante allowance - WWN - Real"},{"$f":" F$496","v":0},{"$f":" G$496","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$103","v":"Weighted average PAYG rate - WWN"},{"$f":"InpActive!F$103","v":0},{"$f":"InpActive!G$103","v":"%"}]
[null,null,null,null,"Revenue adjustment for cost sharing - Net totex for cost sharing - WWN - Real",{"$f":" F548 * F549","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$447","v":"Active adjustment for cost sharing for wage adjustment - WWN - Real"},{"$f":" F$447","v":0},{"$f":" G$447","v":"£m"}]
[null,null,null,null,{"$f":" E$537","v":"Active adjustment for cost sharing business rates and abstraction - WWN - Real"},{"$f":" F$537","v":0},{"$f":" G$537","v":"£m"}]
[null,null,null,null,{"$f":"E$550","v":"Revenue adjustment for cost sharing - Net totex for cost sharing - WWN - Real"},{"$f":"F$550","v":0},"£m"]
[null,null,null,null,"Total revenue adjustment - WWN - Real",{"$f":" SUM(F552:F554)","v":0},"£m"]
[]
[]
[null,null,"RCV cost sharing adjustment"]
[]
[null,null,null,null,{"$f":" E$496","v":"Total adjustment for cost sharing after ex ante allowance - WWN - Real"},{"$f":" F$496","v":0},{"$f":" G$496","v":"£m"}]
[null,null,null,null,{"$f":"InpActive!E$103","v":"Weighted average PAYG rate - WWN"},{"$f":"InpActive!F$103","v":0},{"$f":"InpActive!G$103","v":"%"}]
[null,null,null,null,"RCV adjustment for cost sharing - WWN - Real",{"$f":" F560 * (1-F561)","v":0},"£m"]
[]
[]
[]
["END OF SHEET"]

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

{"sheet":"Outputs","index":11,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Outputs"}]
[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"},null,null,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}]
[]
["WATER RESOURCES"]
[]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E89","v":"Active adjustment for cost sharing for wage adjustment - WR - Real"},{"$f":"'Cost sharing Calculations'!F89","v":0},{"$f":"'Cost sharing Calculations'!G89","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E138","v":"Total adjustment for cost sharing after ex ante allowance - WR - Real"},{"$f":"'Cost sharing Calculations'!F138","v":0},{"$f":"'Cost sharing Calculations'!G138","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E179","v":"Active adjustment for cost sharing business rates and abstraction - WR - Real"},{"$f":"'Cost sharing Calculations'!F179","v":0},{"$f":"'Cost sharing Calculations'!G179","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E186","v":"Total adjustment for cost sharing - WR - Real"},{"$f":"'Cost sharing Calculations'!F186","v":0},{"$f":"'Cost sharing Calculations'!G186","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E197","v":"Total revenue adjustment - WR - Real"},{"$f":"'Cost sharing Calculations'!F197","v":0},{"$f":"'Cost sharing Calculations'!G197","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E204","v":"RCV adjustment for cost sharing - WR - Real"},{"$f":"'Cost sharing Calculations'!F204","v":0},{"$f":"'Cost sharing Calculations'!G204","v":"£m"}]
[]
["WATER NETWORK"]
[]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E268","v":"Active adjustment for cost sharing for wage adjustment - WN - Real"},{"$f":"'Cost sharing Calculations'!F268","v":0},{"$f":"'Cost sharing Calculations'!G268","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E317","v":"Total adjustment for cost sharing after ex ante allowance - WN - Real"},{"$f":"'Cost sharing Calculations'!F317","v":0},{"$f":"'Cost sharing Calculations'!G317","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E358","v":"Active adjustment for cost sharing business rates and abstraction - WN - Real"},{"$f":"'Cost sharing Calculations'!F358","v":0},{"$f":"'Cost sharing Calculations'!G358","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E365","v":"Total adjustment for cost sharing - WN - Real"},{"$f":"'Cost sharing Calculations'!F365","v":0},{"$f":"'Cost sharing Calculations'!G365","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E376","v":"Total revenue adjustment - WN - Real"},{"$f":"'Cost sharing Calculations'!F376","v":0},{"$f":"'Cost sharing Calculations'!G376","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E383","v":"RCV adjustment for cost sharing - WN - Real"},{"$f":"'Cost sharing Calculations'!F383","v":0},{"$f":"'Cost sharing Calculations'!G383","v":"£m"}]
[]
["WASTEWATER NETWORK"]
[]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E447","v":"Active adjustment for cost sharing for wage adjustment - WWN - Real"},{"$f":"'Cost sharing Calculations'!F447","v":0},{"$f":"'Cost sharing Calculations'!G447","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E496","v":"Total adjustment for cost sharing after ex ante allowance - WWN - Real"},{"$f":"'Cost sharing Calculations'!F496","v":0},{"$f":"'Cost sharing Calculations'!G496","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E537","v":"Active adjustment for cost sharing business rates and abstraction - WWN - Real"},{"$f":"'Cost sharing Calculations'!F537","v":0},{"$f":"'Cost sharing Calculations'!G537","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E544","v":"Total adjustment for cost sharing - WWN - Real"},{"$f":"'Cost sharing Calculations'!F544","v":0},{"$f":"'Cost sharing Calculations'!G544","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E555","v":"Total revenue adjustment - WWN - Real"},{"$f":"'Cost sharing Calculations'!F555","v":0},{"$f":"'Cost sharing Calculations'!G555","v":"£m"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E562","v":"RCV adjustment for cost sharing - WWN - Real"},{"$f":"'Cost sharing Calculations'!F562","v":0},{"$f":"'Cost sharing Calculations'!G562","v":"£m"}]
[]
["END OF SHEET"]

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

{"sheet":"Check","index":13,"n_rows":18,"n_cols":16,"rows_kept":18,"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"},null,null,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:F16)","v":0},"check"]
[]
["[Do not delete]"]
[]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E45","v":"WR Totex profile 100% check"},{"$f":"'Cost sharing Calculations'!F45","v":0},{"$f":"'Cost sharing Calculations'!G45","v":"Check"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E225","v":"WN Totex profile 100% check"},{"$f":"'Cost sharing Calculations'!F225","v":0},{"$f":"'Cost sharing Calculations'!G225","v":"Check"}]
[null,null,null,null,{"$f":"'Cost sharing Calculations'!E404","v":"WWN Totex profile 100% check"},{"$f":"'Cost sharing Calculations'!F404","v":0},{"$f":"'Cost sharing Calculations'!G404","v":"Check"}]
[]
["[Do not delete]"]
[]
["END OF SHEET"]