{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover","Model formatting","ToC","InputsR","InputsC","Time","Index","Calc","Outputs","Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":61,"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,3,18,4],[19,3,19,4]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,null,"Model name:","Bioresources revenue reconciliation model"]
[null,null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"Bioresources-Revenue-Reconciliation-Model-December-2019.xlsm"}]
[null,null,"Date:","2019-12-16"]
[null,null,"Author:","Ofwat"]
[null,null,"Author contact information:","pr19@ofwat.gov.uk"]
[]
[]
[null,null,"Summary of model:","This is a draft model that illustrates how bioresources revenue reconciliation could work in 2020-2025. "]
[null,null,null,"The model combines three previously published bioresources models into a single bioresources reconciliation model."]
[]
[null,null,null,"Follow links >>","Pr19 Final Methodology"]
[null,null,null,"NB This brings together and simplifies two previous models published by Ofwat. "]
[]
[null,null,"Known limitations:"]
[]
[null,null,null,"Issue",null,"Details","Model link"]
[null,null,null,"Illustrative Model",null,"This is an initial, illustrative model. We may make refinements to it in due course."]
[null,null,null,"Rulebook",null,"We will publish a PR19 Reconcilation Rulebook in due course as appropriate. "]
[]
[]
[null,null,"Quality Assurance","The model has been subject to internal Ofwat quality assurance. "]
[]
[null,null,"Feedback:","We would welcome feedback on this model. Please send any feedback to the following email address."]
[null,null,null,"pr19@ofwat.gov.uk"]
[]
[null,null,"Checks"]
[null,null,null,{"$f":" Checks!$F$9","v":0},"Checks"]
[]
["End of sheet"]

{"sheet":"Model formatting","index":1,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Model formatting"}]
[]
[]
["SHEET TABS"]
[]
[null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,null,null,null,"Green font",null,"Additional descriptions"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks & alerts"]
[null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,"Red shade",null,"Error"]
[]
[null,null,null,null,"Gold shade",null,"Alert"]
[]
[]
["ABBREVIATIONS"]
[]
[null,null,null,null,"chk",null,"Checks"]
[null,null,null,null,"£",null,"Great Britain Pound"]
[null,null,null,null,"TDS",null,"Tonnes Dry Solid "]
[]
["END"]

{"sheet":"ToC","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"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,"MODEL INPUTS",null,"MODEL OUTPUTS"]
[]
[null,{"$f":" 'Model formatting'!A1","v":"Model formatting"},null,{"$f":" Time!A1","v":"Time"},null,{"$f":" Outputs!A1","v":"Outputs"}]
[null,"Explanation of different formatting types",null,"Flags, part period factors (PPFs) and dates",null,"Outputs from the model"]
[]
[null,{"$f":" A1","v":"ToC"},null,{"$f":" Index!A1","v":"Index"},null,{"$f":" Checks!A1","v":"Checks"}]
[null,"Table of contents",null,"Inflation indexation",null,"Checks"]
[]
[null,{"$f":" InputsR!A1","v":"InputsR"},null,{"$f":" Calc!A1","v":"Calc"}]
[null,"Inputs - row format",null,"Calculation of changes in revenue between "]
[null,null,null,"actual and forecast TDS"]
[null,{"$f":" InputsC!A1","v":"InputsC"}]
[null,"Inputs - column format"]
[]
["END"]

{"sheet":"InputsR","index":3,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"InputsR"}]
[null,null,null,null,{"$f":" Time!E$2","v":"Model Period Ending"},null,null,null,{"$f":" Time!I$2","v":0},{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$3","v":"Pre Forecast vs Forecast"},null,null,null,{"$f":" Time!I$3","v":0},{"$f":" Time!J$55","v":"Pre Fcst"},{"$f":" Time!K$55","v":"Pre Fcst"},{"$f":" Time!L$55","v":"Pre Fcst"},{"$f":" Time!M$55","v":"Pre Fcst"},{"$f":" Time!N$55","v":"Forecast"},{"$f":" Time!O$55","v":"Forecast"},{"$f":" Time!P$55","v":"Forecast"},{"$f":" Time!Q$55","v":"Forecast"},{"$f":" Time!R$55","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$4","v":"Financial Year Ending"},null,null,null,{"$f":" Time!I$4","v":0},{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,{"$f":" Time!E$5","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["A: Sludge production"]
[]
[null,null,null,null,"Company forecast of sludge produced (ttds)",null,"ttds",{"$f":" SUM( N9:R9 )","v":0}]
[]
[null,null,null,null,"Outturn sludge produced in year (ttds)",null,"ttds",{"$f":" SUM( N11:R11 )","v":0}]
[]
["B: Bioresources in-period correction inputs"]
[]
[null,null,null,null,"Variable revenue",null,"£/TDS"]
[]
[null,null,null,null,"Recovered revenue for bioresources",null,"£m",{"$f":" SUM( N17:R17 )","v":0}]
[]
[null,null,null,null,"Total bioresources revenue allowance - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM( N19:R19 )","v":0}]
[]
[null,null,null,null,"Profit from bioresources trading",null,"£m",{"$f":" SUM( N21:R21 )","v":0}]
[]
[null,null,null,null,"Other adjustments, such as in-period ODIs",null,"£m",{"$f":" SUM( N23:R23 )","v":0}]
[]
[null,null,null,null,"Discount rate",null,"%"]
[]
["C: Bioresources forecasting incentive inputs"]
[]
[null,null,null,null,"Penalty rate",0.1,"%"]
[]
[null,null,null,null,"Deadband",0.06,"%"]
[]
["D: Inflation"]
[]
[null,null,null,null,"Consumer price index (including housing costs) for November",null,"index",null,null,101.8,104.7,106.9]
[]
[null,null,null,null,"Base Consumer price index (including housing costs) for November 2016",{"$f":" $J$35","v":101.8},"index"]
[]
[null,null,null,null,"CPIH Nov-Nov % change - Base case"]
[]
["END"]

{"sheet":"InputsC","index":4,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"InputsC"}]
[null,null,null,null,{"$f":" Time!E$2","v":"Model Period Ending"},{"$f":" Checks!$F$9","v":0},"Error chks",{"$f":" Time!H$2","v":0},{"$f":" Time!I$2","v":0},{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$3","v":"Pre Forecast vs Forecast"},null,null,{"$f":" Time!H$3","v":0},{"$f":" Time!I$3","v":0},{"$f":" Time!J$55","v":"Pre Fcst"},{"$f":" Time!K$55","v":"Pre Fcst"},{"$f":" Time!L$55","v":"Pre Fcst"},{"$f":" Time!M$55","v":"Pre Fcst"},{"$f":" Time!N$55","v":"Forecast"},{"$f":" Time!O$55","v":"Forecast"},{"$f":" Time!P$55","v":"Forecast"},{"$f":" Time!Q$55","v":"Forecast"},{"$f":" Time!R$55","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$4","v":"Financial Year Ending"},null,null,{"$f":" Time!H$4","v":0},{"$f":" Time!I$4","v":0},{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,{"$f":" Time!E$5","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["A: Time"]
[]
[null,null,null,null,"First date of time ruler","2016-04-01","date"]
[]
[null,null,null,null,"First Modelling Column Financial Year Number",2017,"count"]
[]
[null,null,null,null,"Financial Year End Month Number",3,"month #"]
[]
[null,null,null,null,"Last Pre Forecast Date","2020-03-31","date"]
[]
[null,null,null,null,"Last Pre Forecast Flag","2025-03-31","date"]
[]
["B: Non changeable inputs"]
[]
[null,null,null,null,"Units in a million",1000000,"unit"]
[]
[null,null,null,null,"Units in a thousand",1000,"unit"]
[]
[null,null,null,null,"Check Tolerance Level",9.9999999999999995E-8,"tolerance"]
[]
["END"]

{"sheet":"Time","index":5,"n_rows":68,"n_cols":18,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"Time"}]
[null,null,null,null,{"$f":" E$21","v":"Model Period Ending"},{"$f":" Checks!$F$9","v":0},"Error chks",{"$f":" H$21","v":0},0,"2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[null,null,null,null,{"$f":" E55","v":"Pre Forecast vs Forecast"},null,null,{"$f":" H55","v":0},0,{"$f":" J55","v":"Pre Fcst"},"Pre Fcst","Pre Fcst","Pre Fcst","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,{"$f":" E$29","v":"Financial Year Ending"},null,null,{"$f":" H$29","v":0},0,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,null,null,null,{"$f":" E$8","v":"Model column counter"},{"$f":" F$8","v":0},"counter",0,0,{"$f":" J$8","v":1},{"$f":" K$8","v":2},3,4,5,6,7,8,9]
[]
[null,"Model column counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I8 + 1","v":1},{"$f":" J8 + 1","v":2},3,4,5,6,7,8,9]
[null,null,null,null,"Model column total",{"$f":" MAX(L8:R8)","v":9},"columns"]
[]
[null,null,null,null,{"$f":" E$8","v":"Model column counter"},{"$f":" F$8","v":0},"counter",0,0,{"$f":" J$8","v":1},{"$f":" K$8","v":2},3,4,5,6,7,8,9]
[null,null,null,null,"First model column flag",null,"flag",{"$f":" SUM(L12:CC12)","v":0},null,{"$f":" IF( J11 = 1, 1, 0)","v":1},{"$f":" IF( K11 = 1, 1, 0)","v":0},{"$f":" IF( L11 = 1, 1, 0)","v":0},{"$f":" IF( M11 = 1, 1, 0)","v":0},0,0,0,0,0]
[]
[null,"Model period beginning"]
[null,null,null,null,{"$f":"InputsC!E9","v":"First date of time ruler"},{"$f":"InputsC!F9","v":"2016-04-01"},{"$f":"InputsC!G9","v":"date"}]
[null,null,null,null,"First model period BEG",{"$f":" DATE(YEAR(F15), MONTH(F15), 1)","v":"2016-04-01"},"month"]
[]
[null,null,null,null,{"$f":" E$16","v":"First model period BEG"},{"$f":" F$16","v":"2016-04-01"},{"$f":" G$16","v":"month"}]
[null,null,null,null,{"$f":" E$12","v":"First model column flag"},{"$f":" F$12","v":0},"flag",{"$f":" H$12","v":0},0,{"$f":" J$12","v":1},{"$f":" K$12","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Model Period Beginning",null,"date",null,null,{"$f":" IF( J19 = 1, $F18, I21 + 1)","v":"2016-04-01"},{"$f":" IF( K19 = 1, $F18, J21 + 1)","v":"2017-04-01"},"2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01"]
[null,null,null,null,"Model Period Ending",null,"date",null,null,{"$f":" DATE(YEAR(J20), MONTH(J20) + 12, DAY(1) - 1)","v":"2017-03-31"},{"$f":" DATE(YEAR(K20), MONTH(K20) + 12, DAY(1) - 1)","v":"2018-03-31"},"2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"InputsC!E11","v":"First Modelling Column Financial Year Number"},{"$f":"InputsC!F11","v":2017},{"$f":"InputsC!G11","v":"count"}]
[null,null,null,null,{"$f":"InputsC!E13","v":"Financial Year End Month Number"},{"$f":"InputsC!F13","v":3},{"$f":"InputsC!G13","v":"month #"}]
[null,null,null,null,{"$f":" E21","v":"Model Period Ending"},{"$f":" F21","v":0},"date",0,0,{"$f":" J21","v":"2017-03-31"},"2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[null,null,null,null,{"$f":" E$12","v":"First model column flag"},{"$f":" F$12","v":0},"flag",0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Financial Year Ending",null,"year #",null,null,{"$f":" IF(J28 = 1, $F25, IF(J27 > (DATE(I29, $F26 + 1, 1) - 1), I29 + 1, I29))","v":2017},{"$f":" IF(K28 = 1, $F25, IF(K27 > (DATE(J29, $F26 + 1, 1) - 1), J29 + 1, J29))","v":2018},2019,2020,2021,2022,2023,2024,2025]
[]
["PRE FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":"InputsC!E15","v":"Last Pre Forecast Date"},{"$f":"InputsC!F15","v":"2020-03-31"},{"$f":"InputsC!G15","v":"date"}]
[null,null,null,null,{"$f":" E$21","v":"Model Period Ending"},{"$f":" F$21","v":"00:00:00"},{"$f":" G$21","v":"date"},"00:00:00","00:00:00",{"$f":" J$21","v":"2017-03-31"},{"$f":" K$21","v":"2018-03-31"},{"$f":" L$21","v":"2019-03-31"},"2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[null,null,null,null,"Last Pre Forecast Flag",null,"flag",{"$f":" SUM(L35:CC35)","v":1},null,{"$f":" IF(J34 = $F33, 1, 0)","v":0},0,{"$f":" IF(L34 = $F33, 1, 0)","v":0},{"$f":" IF(M34 = $F33, 1, 0)","v":1},0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Flag",null,"flag",{"$f":" SUM(J36:CC36)","v":4},null,{"$f":" IF($F33 >= J34, 1, 0)","v":1},1,{"$f":" IF($F33 >= L34, 1, 0)","v":1},1,0,0,0,0,0]
[null,null,null,null,"Pre Forecast Period Total",{"$f":" SUM(J36:CC36)","v":4},"columns"]
[]
["FORECAST PERIOD"]
[]
[null,null,null,null,{"$f":" E$35","v":"Last Pre Forecast Flag"},0,"flag",1,0,0,0,0,{"$f":" M$35","v":1},0,0,0,0,0]
[null,null,null,null,"1st Forecast Period Flag",null,"flag",{"$f":" SUM(L42:CC42)","v":1},null,{"$f":" I41","v":0},{"$f":" J41","v":0},0,0,1,0,0,0,0]
[]
[null,null,null,null,{"$f":"InputsC!E17","v":"Last Pre Forecast Flag"},{"$f":"InputsC!F17","v":"2025-03-31"},{"$f":"InputsC!G17","v":"date"}]
[null,null,null,null,{"$f":" E$21","v":"Model Period Ending"},{"$f":" F$21","v":0},"date",0,0,"2017-03-31","2018-03-31","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31"]
[null,null,null,null,"Last Forecast Period Flag",null,"flag",{"$f":" SUM(L46:CC46)","v":1},null,{"$f":" IF(AND($F44 > I45, $F44 <= J45), 1, 0)","v":0},{"$f":" IF(AND($F44 > J45, $F44 <= K45), 1, 0)","v":0},0,0,0,0,0,0,1]
[]
[null,null,null,null,{"$f":" E$42","v":"1st Forecast Period Flag"},{"$f":" F$42","v":0},"flag",1,0,0,0,0,0,{"$f":" N$42","v":1},0,0,0,0]
[null,null,null,null,{"$f":" E$46","v":"Last Forecast Period Flag"},{"$f":" F$46","v":0},"flag",1,0,0,0,0,0,0,0,0,0,1]
[null,null,null,null,"Forecast Period Flag",null,"flag",{"$f":" SUM(L50:CC50)","v":5},null,{"$f":" J48 - I49 + I50","v":0},{"$f":" K48 - J49 + J50","v":0},0,0,1,1,1,1,1]
[null,null,null,null,"Forecast Period Total ",{"$f":" SUM(L50:CC50)","v":5},"columns"]
[]
[null,null,null,null,{"$f":" E$36","v":"Pre Forecast Period Flag"},{"$f":" F$36","v":0},"flag",4,0,1,1,1,1,0,0,0,0,0]
[null,null,null,null,{"$f":" E$50","v":"Forecast Period Flag"},{"$f":" F$50","v":0},"flag",5,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"Pre Forecast vs Forecast",null,"flag",null,null,{"$f":" IF(J53 = 1, \"Pre Fcst\", IF(J54 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Pre Fcst"},"Pre Fcst",{"$f":" IF(L53 = 1, \"Pre Fcst\", IF(L54 = 1, \"Forecast\", \"Post-Fcst\"))","v":"Pre Fcst"},"Pre Fcst","Forecast","Forecast","Forecast","Forecast","Forecast"]
[]
[null,null,null,null,{"$f":" E$36","v":"Pre Forecast Period Flag"},{"$f":" F$36","v":0},"flag",4,0,1,1,1,1,0,0,0,0,0]
[null,null,null,null,{"$f":" E$50","v":"Forecast Period Flag"},{"$f":" F$50","v":0},"flag",5,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"Forecast period counter",null,"counter",null,null,{"$f":" IF( J53 = 1,  J58, I59 + J58 )","v":0},{"$f":" IF( K53 = 1,  K58, J59 + K58 )","v":0},0,0,1,2,3,4,5]
[]
["Model Period Check"]
[]
[null,null,null,null,{"$f":" E$9","v":"Model column total"},{"$f":" F$9","v":9},{"$f":" G$9","v":"columns"}]
[null,null,null,"less",{"$f":" E$37","v":"Pre Forecast Period Total"},{"$f":" F$37","v":4},{"$f":" G$37","v":"columns"}]
[null,null,null,"less",{"$f":" E$51","v":"Forecast Period Total "},{"$f":" F$51","v":5},{"$f":" G$51","v":"columns"}]
[null,null,null,null,"Modelling Period Check",{"$f":" IF(F63 - SUM(F64:F65) <> 0, 1, 0)","v":0},"check"]
[]
["END"]

{"sheet":"Index","index":6,"n_rows":28,"n_cols":18,"rows_kept":28,"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,"Model period ending",null,null,null,null,{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,"Timeline label",null,null,null,null,{"$f":" Time!J55","v":"Pre Fcst"},{"$f":" Time!K55","v":"Pre Fcst"},{"$f":" Time!L55","v":"Pre Fcst"},{"$f":" Time!M55","v":"Pre Fcst"},{"$f":" Time!N55","v":"Forecast"},{"$f":" Time!O55","v":"Forecast"},{"$f":" Time!P55","v":"Forecast"},{"$f":" Time!Q55","v":"Forecast"},{"$f":" Time!R55","v":"Forecast"}]
[null,null,null,null,"Financial year ending",null,null,null,null,{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,"Model column counter","Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["CPIH INDEXATION"]
[]
[null,"Nov-Nov CPIH - base index Nov 2016"]
[]
[null,null,null,null,{"$f":" InputsR!E$37","v":"Base Consumer price index (including housing costs) for November 2016"},{"$f":" InputsR!F$37","v":101.8},{"$f":" InputsR!G$37","v":"index"}]
[]
[null,null,null,null,{"$f":" InputsR!E$35","v":"Consumer price index (including housing costs) for November"},{"$f":" InputsR!F$35","v":0},{"$f":" InputsR!G$35","v":"index"},{"$f":" InputsR!H$35","v":0},{"$f":" InputsR!I$35","v":0},{"$f":" InputsR!J$35","v":101.8},{"$f":" InputsR!K$35","v":104.7},{"$f":" InputsR!L$35","v":106.9},{"$f":" InputsR!M$35","v":0},{"$f":" InputsR!N$35","v":0},{"$f":" InputsR!O$35","v":0},{"$f":" InputsR!P$35","v":0},{"$f":" InputsR!Q$35","v":0},{"$f":" InputsR!R$35","v":0}]
[]
[null,null,null,null,{"$f":" InputsR!E$39","v":"CPIH Nov-Nov % change - Base case"},{"$f":" InputsR!F$39","v":0},{"$f":" InputsR!G$39","v":0},{"$f":" InputsR!H$39","v":0},{"$f":" InputsR!I$39","v":0},{"$f":" InputsR!J$39","v":0},{"$f":" InputsR!K$39","v":0},{"$f":" InputsR!L$39","v":0},{"$f":" InputsR!M$39","v":0},{"$f":" InputsR!N$39","v":0},{"$f":" InputsR!O$39","v":0},{"$f":" InputsR!P$39","v":0},{"$f":" InputsR!Q$39","v":0},{"$f":" InputsR!R$39","v":0}]
[]
[null,null,null,null,"CPIH: November - index",null,"index",null,null,{"$f":" IF( J13 > 0, J13, I17 * (1 + $F$15))","v":101.8},{"$f":" IF( K13 > 0, K13, J17 * (1 + $F$15))","v":104.7},106.9,106.9,106.9,106.9,106.9,106.9,106.9]
[]
[null,"CPIH base year: November 2016 - indexation factor"]
[]
[null,null,null,null,{"$f":" E$11","v":"Base Consumer price index (including housing costs) for November 2016"},{"$f":" F$11","v":101.8},{"$f":" G$11","v":"index"}]
[null,null,null,null,{"$f":" E$17","v":"CPIH: November - index"},{"$f":" F$17","v":0},"index",0,0,101.8,104.7,106.9,106.9,106.9,106.9,106.9,106.9,106.9]
[null,null,null,null,"CPI(H) base year: November - indexation factor - CALC",null,"%",null,null,{"$f":" IF($F21 <> 0, I22 / $F21, 0)","v":0},1,1.0284872298624754,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121]
[]
[null,null,null,null,{"$f":" E$23","v":"CPI(H) base year: November - indexation factor - CALC"},{"$f":" F$23","v":0},"%",0,0,0,1,1.0284872298624754,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121,1.0500982318271121]
[null,null,null,null,"CPI(H) Nov-Nov - percentage increase - CALC",null,null,null,null,{"$f":" IF(I25 > 0, J25 / I25, 0)","v":0},{"$f":" IF(J25 > 0, K25 / J25, 0)","v":0},1.0284872298624754,1.0210124164278893,{"$f":" IF(M25 > 0, N25 / M25, 0)","v":1},1,1,1,1]
[]
["End of sheet"]

{"sheet":"Calc","index":7,"n_rows":231,"n_cols":18,"rows_kept":231,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"Calc"}]
[null,null,null,null,{"$f":" Time!E$2","v":"Model Period Ending"},{"$f":" Checks!$F$9","v":0},"Error chks",{"$f":" Time!H$2","v":0},{"$f":" Time!I$2","v":0},{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$3","v":"Pre Forecast vs Forecast"},null,null,{"$f":" Time!H$3","v":0},{"$f":" Time!I$3","v":0},{"$f":" Time!J55","v":"Pre Fcst"},{"$f":" Time!K55","v":"Pre Fcst"},{"$f":" Time!L55","v":"Pre Fcst"},{"$f":" Time!M55","v":"Pre Fcst"},{"$f":" Time!N55","v":"Forecast"},{"$f":" Time!O55","v":"Forecast"},{"$f":" Time!P55","v":"Forecast"},{"$f":" Time!Q55","v":"Forecast"},{"$f":" Time!R55","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$4","v":"Financial Year Ending"},null,null,{"$f":" Time!H$4","v":0},{"$f":" Time!I$4","v":0},{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,{"$f":" Time!E$5","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["Calculation of average revenue control"]
[]
[null,null,null,null,{"$f":" Time!E$42","v":"1st Forecast Period Flag"},{"$f":" Time!F$42","v":0},{"$f":" Time!G$42","v":"flag"},{"$f":" Time!H$42","v":1},{"$f":" Time!I$42","v":0},{"$f":" Time!J$42","v":0},{"$f":" Time!K$42","v":0},{"$f":" Time!L$42","v":0},{"$f":" Time!M$42","v":0},{"$f":" Time!N$42","v":1},{"$f":" Time!O$42","v":0},{"$f":" Time!P$42","v":0},{"$f":" Time!Q$42","v":0},{"$f":" Time!R$42","v":0}]
[null,null,null,null,{"$f":" InputsR!E$25","v":"Discount rate"},{"$f":" InputsR!F$25","v":0},{"$f":" InputsR!G$25","v":"%"},{"$f":" InputsR!H$25","v":0},{"$f":" InputsR!I$25","v":0},{"$f":" InputsR!J$25","v":0},{"$f":" InputsR!K$25","v":0},{"$f":" InputsR!L$25","v":0},{"$f":" InputsR!M$25","v":0},{"$f":" InputsR!N$25","v":0},{"$f":" InputsR!O$25","v":0},{"$f":" InputsR!P$25","v":0},{"$f":" InputsR!Q$25","v":0},{"$f":" InputsR!R$25","v":0}]
[null,null,null,null,"Discount factor for NPV for five-year average revenue control",null,"index",null,null,{"$f":" IF( J9 = 1, 1, ( I11 / (1 + $F$10) ) )","v":0},{"$f":" IF( K9 = 1, 1, ( J11 / (1 + $F$10) ) )","v":0},0,0,1,1,1,1,1]
[]
[null,null,null,null,{"$f":" InputsR!E$9","v":"Company forecast of sludge produced (ttds)"},{"$f":" InputsR!F$9","v":0},{"$f":" InputsR!G$9","v":"ttds"},{"$f":" InputsR!H$9","v":0},{"$f":" InputsR!I$9","v":0},{"$f":" InputsR!J$9","v":0},{"$f":" InputsR!K$9","v":0},{"$f":" InputsR!L$9","v":0},{"$f":" InputsR!M$9","v":0},{"$f":" InputsR!N$9","v":0},{"$f":" InputsR!O$9","v":0},{"$f":" InputsR!P$9","v":0},{"$f":" InputsR!Q$9","v":0},{"$f":" InputsR!R$9","v":0}]
[null,null,null,null,{"$f":" InputsC!E$23","v":"Units in a thousand"},{"$f":" InputsC!F$23","v":1000},{"$f":" InputsC!G$23","v":"unit"},{"$f":" InputsC!H$23","v":0},{"$f":" InputsC!I$23","v":0},{"$f":" InputsC!J$23","v":0},{"$f":" InputsC!K$23","v":0},{"$f":" InputsC!L$23","v":0},{"$f":" InputsC!M$23","v":0},{"$f":" InputsC!N$23","v":0},{"$f":" InputsC!O$23","v":0},{"$f":" InputsC!P$23","v":0},{"$f":" InputsC!Q$23","v":0},{"$f":" InputsC!R$23","v":0}]
[null,null,null,null,"Company forecast of sludge produced",null,"TDS",{"$f":" SUM( J15:R15 )","v":0},null,{"$f":" J13 * $F$14","v":0},{"$f":" K13 * $F$14","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,"The in year sludge production in each year is required to be discounted to maintain a neutral NPV."]
[null,null,null,null,{"$f":" E$11","v":"Discount factor for NPV for five-year average revenue control"},0,"index",{"$f":" H$11","v":0},0,{"$f":" J$11","v":0},0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" E$15","v":"Company forecast of sludge produced"},{"$f":" F$15","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Discounted forecast of sludge produced",null,"TDS",{"$f":" SUM(L20:R20)","v":0},null,{"$f":" J18 * J19","v":0},{"$f":" K18 * K19","v":0},{"$f":" L18 * L19","v":0},0,{"$f":" N18 * N19","v":0},0,0,0,0]
[]
[null,null,null,null,{"$f":" E$20","v":"Discounted forecast of sludge produced"},{"$f":" F$20","v":0},"TDS",{"$f":" H$20","v":0},0,{"$f":" J$20","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted sludge produced for forecast period",{"$f":" SUM(J22:R22)","v":0},"TDS"]
[]
[null,null,null,null,{"$f":" E$11","v":"Discount factor for NPV for five-year average revenue control"},{"$f":" F$11","v":0},"index",0,0,{"$f":" J$11","v":0},0,0,0,1,1,1,1,1]
[null,null,null,null,{"$f":" InputsR!E$19","v":"Total bioresources revenue allowance - 2017-18 FYA (CPIH deflated)"},{"$f":" InputsR!F$19","v":0},{"$f":" InputsR!G$19","v":"£m"},{"$f":" InputsR!H$19","v":0},{"$f":" InputsR!I$19","v":0},{"$f":" InputsR!J$19","v":0},{"$f":" InputsR!K$19","v":0},{"$f":" InputsR!L$19","v":0},{"$f":" InputsR!M$19","v":0},{"$f":" InputsR!N$19","v":0},{"$f":" InputsR!O$19","v":0},{"$f":" InputsR!P$19","v":0},{"$f":" InputsR!Q$19","v":0},{"$f":" InputsR!R$19","v":0}]
[null,null,null,null,"Discounted total revenue requirement  - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM(J27:R27)","v":0},null,{"$f":" J25 * J26","v":0},{"$f":" K25 * K26","v":0},{"$f":" L25 * L26","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$27","v":"Discounted total revenue requirement  - 2017-18 FYA (CPIH deflated)"},{"$f":" F$27","v":0},"£m",{"$f":" H$27","v":0},0,{"$f":" J$27","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted revenue requirement for forecast period - 2017-18 FYA (CPIH deflated)",{"$f":" SUM(J29:R29)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$30","v":"Total discounted revenue requirement for forecast period - 2017-18 FYA (CPIH deflated)"},{"$f":" F$30","v":0},{"$f":" G$30","v":"£m"},0,0,{"$f":" J$30","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,{"$f":" E$23","v":"Total discounted sludge produced for forecast period"},{"$f":" F$23","v":0},{"$f":" G$23","v":"TDS"},0,0,{"$f":" J$23","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Standard average revenue control for five-year period (SAR) - 2017-18 FYA (CPIH deflated)",{"$f":" IFERROR( ( F32 * F33 ) / F34, 0)","v":0},"£/TDS"]
[]
[null,"Revenue requirement for period check"]
[]
[null,null,null,null,{"$f":" E$35","v":"Standard average revenue control for five-year period (SAR) - 2017-18 FYA (CPIH deflated)"},{"$f":" F$35","v":0},{"$f":" G$35","v":"£/TDS"},{"$f":" H$35","v":0},{"$f":" I$35","v":0}]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,{"$f":" E$15","v":"Company forecast of sludge produced"},{"$f":" F$15","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Unadjusted revenue by year - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM(J42:R42)","v":0},null,{"$f":" ($F39 * J41) / $F40","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$42","v":"Unadjusted revenue by year - 2017-18 FYA (CPIH deflated)"},0,"£m",0,0,{"$f":" J$42","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$11","v":"Discount factor for NPV for five-year average revenue control"},0,"index",0,0,{"$f":" J$11","v":0},0,0,0,1,1,1,1,1]
[null,null,null,null,"Discounted unadjusted revenue by year - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM(J46:R46)","v":0},null,{"$f":" J44 * J45","v":0},{"$f":" K44 * K45","v":0},{"$f":" L44 * L45","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$46","v":"Discounted unadjusted revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$46","v":0},"£m",0,0,{"$f":" J$46","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Reconstructed total unadjusted revenue for the period - 2017-18 FYA (CPIH deflated)",{"$f":" SUM(J48:R48)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$30","v":"Total discounted revenue requirement for forecast period - 2017-18 FYA (CPIH deflated)"},{"$f":" F$30","v":0},{"$f":" G$30","v":"£m"},0,0,{"$f":" J$30","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$49","v":"Reconstructed total unadjusted revenue for the period - 2017-18 FYA (CPIH deflated)"},{"$f":" F$49","v":0},{"$f":" G$49","v":"£m"},0,0,{"$f":" J$49","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted revenue requirement check",{"$f":"IF(ABS(F51 - F52) > CHK_TOL,1, 0)","v":0},"check"]
[]
["Company fixed and variable elements of revenue adjustment"]
[]
[null,null,null,null,{"$f":" InputsR!E$15","v":"Variable revenue"},{"$f":" InputsR!F$15","v":0},{"$f":" InputsR!G$15","v":"£/TDS"},{"$f":" InputsR!H$15","v":0},{"$f":" InputsR!I$15","v":0},{"$f":" InputsR!J$15","v":0},{"$f":" InputsR!K$15","v":0},{"$f":" InputsR!L$15","v":0},{"$f":" InputsR!M$15","v":0},{"$f":" InputsR!N$15","v":0},{"$f":" InputsR!O$15","v":0},{"$f":" InputsR!P$15","v":0},{"$f":" InputsR!Q$15","v":0},{"$f":" InputsR!R$15","v":0}]
[null,null,null,null,{"$f":" E$15","v":"Company forecast of sludge produced"},{"$f":" F$15","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,"Revenue to remunerate variable costs by year - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM( J60:R60 )","v":0},null,{"$f":" ( $F$57 * J58 ) / $F$59","v":0},{"$f":" ( $F$57 * K58 ) / $F$59","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$60","v":"Revenue to remunerate variable costs by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$60","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$11","v":"Discount factor for NPV for five-year average revenue control"},0,"index",0,0,{"$f":" J$11","v":0},0,0,0,1,1,1,1,1]
[null,null,null,null,"Discounted variable element revenue by year - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM(L64:R64)","v":0},null,{"$f":" J62 * J63","v":0},{"$f":" K62 * K63","v":0},{"$f":" L62 * L63","v":0},{"$f":" M62 * M63","v":0},0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$46","v":"Discounted unadjusted revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$46","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$64","v":"Discounted variable element revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$64","v":0},"£m",0,0,{"$f":" J$64","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Discounted fixed element revenue by year - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM(J68:R68)","v":0},null,{"$f":"J66-J67","v":0},{"$f":"K66-K67","v":0},{"$f":"L66-L67","v":0},0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$68","v":"Discounted fixed element revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$68","v":0},"£m",0,0,{"$f":" J$68","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted fixed element revenue for period - 2017-18 FYA (CPIH deflated)",{"$f":" SUM(J70:R70)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$64","v":"Discounted variable element revenue by year - 2017-18 FYA (CPIH deflated)"},0,"£m",0,0,{"$f":" J$64","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted variable element revenue for period - 2017-18 FYA (CPIH deflated)",{"$f":" SUM(J73:R73)","v":0},"£m"]
[]
[null,null,null,null,{"$f":" E$22","v":"Discounted forecast of sludge produced"},{"$f":" F$22","v":0},"TDS",0,0,{"$f":" J$22","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Total discounted forecast of sludge produced for period",{"$f":" SUM(J76:R76)","v":0},"TDS"]
[]
[null,null,null,null,{"$f":" E$74","v":"Total discounted variable element revenue for period - 2017-18 FYA (CPIH deflated)"},{"$f":" F$74","v":0},"£m",0,0,{"$f":" J$74","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,{"$f":" E$77","v":"Total discounted forecast of sludge produced for period"},{"$f":" F$77","v":0},"TDS",0,0,{"$f":" J$77","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Discounted variable revenue - 2017-18 FYA (CPIH deflated)",{"$f":" IFERROR( ( F79 * F80 ) / F81, 0)","v":0},"£/TDS"]
[]
[null,null,null,null,{"$f":" E$71","v":"Total discounted fixed element revenue for period - 2017-18 FYA (CPIH deflated)"},{"$f":" F$71","v":0},"£m",0,0,{"$f":" J$71","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,{"$f":" E$77","v":"Total discounted forecast of sludge produced for period"},{"$f":" F$77","v":0},"TDS",0,0,{"$f":" J$77","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Discounted fixed revenue - 2017-18 FYA (CPIH deflated)",{"$f":" IFERROR( ( F84 * F85 ) / F86, 0)","v":0},"£/TDS"]
[]
[null,null,null,null,{"$f":" E$82","v":"Discounted variable revenue - 2017-18 FYA (CPIH deflated)"},{"$f":" F$82","v":0},"£/TDS",0,0,{"$f":" J$82","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$87","v":"Discounted fixed revenue - 2017-18 FYA (CPIH deflated)"},{"$f":" F$87","v":0},"£/TDS",0,0,{"$f":" J$87","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Discounted total average revenue - 2017-18 FYA (CPIH deflated)",{"$f":" F89 + F90","v":0},"£/TDS"]
[]
[null,null,null,null,{"$f":" E$91","v":"Discounted total average revenue - 2017-18 FYA (CPIH deflated)"},{"$f":" F$91","v":0},"£/TDS",0,0,{"$f":" J$91","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$35","v":"Standard average revenue control for five-year period (SAR) - 2017-18 FYA (CPIH deflated)"},{"$f":" F$35","v":0},"£/TDS",0,0,{"$f":" J$35","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Fixed element adjustment total revenue check",{"$f":"IF(ABS(F93 - F94) > CHK_TOL,1, 0)","v":0},"check"]
[]
["Calculation of modified revenue"]
[]
[null,null,null,null,{"$f":" InputsR!E$11","v":"Outturn sludge produced in year (ttds)"},{"$f":" InputsR!F$11","v":0},{"$f":" InputsR!G$11","v":"ttds"},{"$f":" InputsR!H$11","v":0},{"$f":" InputsR!I$11","v":0},{"$f":" InputsR!J$11","v":0},{"$f":" InputsR!K$11","v":0},{"$f":" InputsR!L$11","v":0},{"$f":" InputsR!M$11","v":0},{"$f":" InputsR!N$11","v":0},{"$f":" InputsR!O$11","v":0},{"$f":" InputsR!P$11","v":0},{"$f":" InputsR!Q$11","v":0},{"$f":" InputsR!R$11","v":0}]
[null,null,null,null,{"$f":" InputsC!E$23","v":"Units in a thousand"},{"$f":" InputsC!F$23","v":1000},{"$f":" InputsC!G$23","v":"unit"},{"$f":" InputsC!H$23","v":0},{"$f":" InputsC!I$23","v":0},{"$f":" InputsC!J$23","v":0},{"$f":" InputsC!K$23","v":0},{"$f":" InputsC!L$23","v":0},{"$f":" InputsC!M$23","v":0},{"$f":" InputsC!N$23","v":0},{"$f":" InputsC!O$23","v":0},{"$f":" InputsC!P$23","v":0},{"$f":" InputsC!Q$23","v":0},{"$f":" InputsC!R$23","v":0}]
[null,null,null,null,"Outturn sludge produced in year",null,"TDS",{"$f":" SUM( J101:R101 )","v":0},null,{"$f":" J99 * $F$100","v":0},{"$f":" K99 * $F$100","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$101","v":"Outturn sludge produced in year"},{"$f":" F$101","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$11","v":"Discount factor for NPV for five-year average revenue control"},0,"index",0,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,"Discounted outturn sludge produced",null,"TDS",{"$f":" SUM( J105:R105 )","v":0},null,{"$f":" J103 * J104","v":0},{"$f":" K103 * K104","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" InputsC!E$21","v":"Units in a million"},{"$f":" InputsC!F$21","v":1000000},{"$f":" InputsC!G$21","v":"unit"}]
[null,null,null,null,{"$f":" E$42","v":"Unadjusted revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$42","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$101","v":"Outturn sludge produced in year"},{"$f":" F$101","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$15","v":"Company forecast of sludge produced"},{"$f":" F$15","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$82","v":"Discounted variable revenue - 2017-18 FYA (CPIH deflated)"},{"$f":" F$82","v":0},"£/TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Modified revenue - 2017-18 FYA (CPIH deflated)",null,"£m",{"$f":" SUM( J112:R112 )","v":0},null,{"$f":" J108 + ( ( J109 - J110 ) * $F$111 ) / $F$107","v":0},{"$f":" K108 + ( ( K109 - K110 ) * $F$111 ) / $F$107","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$112","v":"Modified revenue - 2017-18 FYA (CPIH deflated)"},{"$f":" F$112","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Index!E$23","v":"CPI(H) base year: November - indexation factor - CALC"},{"$f":" Index!F$23","v":0},{"$f":" Index!G$23","v":"%"},{"$f":" Index!H$23","v":0},{"$f":" Index!I$23","v":0},{"$f":" Index!J$23","v":0},{"$f":" Index!K$23","v":1},{"$f":" Index!L$23","v":1.0284872298624754},{"$f":" Index!M$23","v":1.0500982318271121},{"$f":" Index!N$23","v":1.0500982318271121},{"$f":" Index!O$23","v":1.0500982318271121},{"$f":" Index!P$23","v":1.0500982318271121},{"$f":" Index!Q$23","v":1.0500982318271121},{"$f":" Index!R$23","v":1.0500982318271121}]
[null,null,null,null,"Modified revenue",null,"£m",{"$f":" SUM( J116:R116 )","v":0},null,{"$f":" J114 * J115","v":0},{"$f":" K114 * K115","v":0},0,0,0,0,0,0,0]
[]
["Allowed revenue - application of an in-period revenue correction"]
[]
[null,null,null,null,{"$f":" E$116","v":"Modified revenue"},{"$f":" F$116","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$167","v":"Total adjustment to allowed revenue including over / under recovery true up"},{"$f":" F$167","v":"2 PD LK BCK"},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Allowed revenue",null,"£m",{"$f":" SUM( J122:R122 )","v":0},null,{"$f":" J120 + J121","v":0},{"$f":" K120 + K121","v":0},0,0,0,0,0,0,0]
[]
[null,"Revenue over / under recovery"]
[]
[null,null,null,null,{"$f":" InputsR!E$17","v":"Recovered revenue for bioresources"},{"$f":" InputsR!F$17","v":0},{"$f":" InputsR!G$17","v":"£m"},{"$f":" InputsR!H$17","v":0},{"$f":" InputsR!I$17","v":0},{"$f":" InputsR!J$17","v":0},{"$f":" InputsR!K$17","v":0},{"$f":" InputsR!L$17","v":0},{"$f":" InputsR!M$17","v":0},{"$f":" InputsR!N$17","v":0},{"$f":" InputsR!O$17","v":0},{"$f":" InputsR!P$17","v":0},{"$f":" InputsR!Q$17","v":0},{"$f":" InputsR!R$17","v":0}]
[null,null,null,"less",{"$f":" E$122","v":"Allowed revenue"},{"$f":" F$122","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Revenue imbalance",null,"£m",{"$f":" SUM(J128:W128)","v":0},null,{"$f":" J126 - J127","v":0},{"$f":" K126 - K127","v":0},0,0,0,0,0,0,0]
[]
[null,"Bioresources revenue adjustment (ABR)"]
[]
[null,null,null,null,{"$f":" InputsR!E$25","v":"Discount rate"},{"$f":" InputsR!F$25","v":0},{"$f":" InputsR!G$25","v":"%"},{"$f":" InputsR!H$25","v":0},{"$f":" InputsR!I$25","v":0},{"$f":" InputsR!J$25","v":0},{"$f":" InputsR!K$25","v":0},{"$f":" InputsR!L$25","v":0},{"$f":" InputsR!M$25","v":0},{"$f":" InputsR!N$25","v":0},{"$f":" InputsR!O$25","v":0},{"$f":" InputsR!P$25","v":0},{"$f":" InputsR!Q$25","v":0},{"$f":" InputsR!R$25","v":0}]
[null,null,null,null,{"$f":" Time!E$50","v":"Forecast Period Flag"},{"$f":" Time!F$50","v":0},{"$f":" Time!G$50","v":"flag"},{"$f":" Time!H$50","v":5},{"$f":" Time!I$50","v":0},{"$f":" Time!J$50","v":0},{"$f":" Time!K$50","v":0},{"$f":" Time!L$50","v":0},{"$f":" Time!M$50","v":0},{"$f":" Time!N$50","v":1},{"$f":" Time!O$50","v":1},{"$f":" Time!P$50","v":1},{"$f":" Time!Q$50","v":1},{"$f":" Time!R$50","v":1}]
[null,null,null,null,{"$f":" E$128","v":"Revenue imbalance"},{"$f":" F$128","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bioresources revenue adjustment (ABR) - with financing adjustment",null,"£m",{"$f":" SUM(J135:W135)","v":0},null,{"$f":" IF( J133 = 1, J134 * (  1 + $F132 ) * ( 1 + $F132 ), 0)","v":0},{"$f":" IF( K133 = 1, K134 * (  1 + $F132 ) * ( 1 + $F132 ), 0)","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Index!E$26","v":"CPI(H) Nov-Nov - percentage increase - CALC"},{"$f":" Index!F$26","v":0},{"$f":" Index!G$26","v":0},{"$f":" Index!H$26","v":0},{"$f":" Index!I$26","v":0},{"$f":" Index!J$26","v":0},{"$f":" Index!K$26","v":0},{"$f":" Index!L$26","v":1.0284872298624754},{"$f":" Index!M$26","v":1.0210124164278893},{"$f":" Index!N$26","v":1},{"$f":" Index!O$26","v":1},{"$f":" Index!P$26","v":1},{"$f":" Index!Q$26","v":1},{"$f":" Index!R$26","v":1}]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period counter"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"counter"},{"$f":" Time!H$59","v":0},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":1},{"$f":" Time!O$59","v":2},{"$f":" Time!P$59","v":3},{"$f":" Time!Q$59","v":4},{"$f":" Time!R$59","v":5}]
[null,null,null,null,{"$f":" E$135","v":"Bioresources revenue adjustment (ABR) - with financing adjustment"},{"$f":" F$135","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Bioresources revenue adjustment (ABR) - with financing adjustment & 2 year lag of inflation",null,"£m",{"$f":" SUM(J140:W140)","v":0},null,{"$f":" IF( J138 < 4, J139 * K137 * L137, 0 )","v":0},{"$f":" IF( K138 < 4, K139 * L137 * M137, 0 )","v":0},0,0,0,0,0,0,0]
[]
[null,"Profit from bioresources trading adjustment"]
[]
[null,null,null,null,{"$f":" Index!E$26","v":"CPI(H) Nov-Nov - percentage increase - CALC"},{"$f":" Index!F$26","v":0},{"$f":" Index!G$26","v":0},{"$f":" Index!H$26","v":0},{"$f":" Index!I$26","v":0},{"$f":" Index!J$26","v":0},{"$f":" Index!K$26","v":0},{"$f":" Index!L$26","v":1.0284872298624754},{"$f":" Index!M$26","v":1.0210124164278893},{"$f":" Index!N$26","v":1},{"$f":" Index!O$26","v":1},{"$f":" Index!P$26","v":1},{"$f":" Index!Q$26","v":1},{"$f":" Index!R$26","v":1}]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period counter"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"counter"},{"$f":" Time!H$59","v":0},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":1},{"$f":" Time!O$59","v":2},{"$f":" Time!P$59","v":3},{"$f":" Time!Q$59","v":4},{"$f":" Time!R$59","v":5}]
[null,null,null,null,{"$f":" InputsR!E$21","v":"Profit from bioresources trading"},{"$f":" InputsR!F$21","v":0},{"$f":" InputsR!G$21","v":"£m"},{"$f":" InputsR!H$21","v":0},{"$f":" InputsR!I$21","v":0},{"$f":" InputsR!J$21","v":0},{"$f":" InputsR!K$21","v":0},{"$f":" InputsR!L$21","v":0},{"$f":" InputsR!M$21","v":0},{"$f":" InputsR!N$21","v":0},{"$f":" InputsR!O$21","v":0},{"$f":" InputsR!P$21","v":0},{"$f":" InputsR!Q$21","v":0},{"$f":" InputsR!R$21","v":0}]
[null,null,null,null,"Profit from bioresources trading - with 2 year lag of inflation",null,"£m",{"$f":" SUM(J147:W147)","v":0},0,{"$f":" IF( J145 < 4, J146 * K144 * L144, 0 )","v":0},{"$f":" IF( K145 < 4, K146 * L144 * M144, 0 )","v":0},0,0,0,0,0,0,0]
[]
[null,"Other revenue adjustments"]
[]
[null,null,null,null,{"$f":" Index!E$26","v":"CPI(H) Nov-Nov - percentage increase - CALC"},{"$f":" Index!F$26","v":0},{"$f":" Index!G$26","v":0},{"$f":" Index!H$26","v":0},{"$f":" Index!I$26","v":0},{"$f":" Index!J$26","v":0},{"$f":" Index!K$26","v":0},{"$f":" Index!L$26","v":1.0284872298624754},{"$f":" Index!M$26","v":1.0210124164278893},{"$f":" Index!N$26","v":1},{"$f":" Index!O$26","v":1},{"$f":" Index!P$26","v":1},{"$f":" Index!Q$26","v":1},{"$f":" Index!R$26","v":1}]
[null,null,null,null,{"$f":" Time!E$59","v":"Forecast period counter"},{"$f":" Time!F$59","v":0},{"$f":" Time!G$59","v":"counter"},{"$f":" Time!H$59","v":0},{"$f":" Time!I$59","v":0},{"$f":" Time!J$59","v":0},{"$f":" Time!K$59","v":0},{"$f":" Time!L$59","v":0},{"$f":" Time!M$59","v":0},{"$f":" Time!N$59","v":1},{"$f":" Time!O$59","v":2},{"$f":" Time!P$59","v":3},{"$f":" Time!Q$59","v":4},{"$f":" Time!R$59","v":5}]
[null,null,null,null,{"$f":" InputsR!E$23","v":"Other adjustments, such as in-period ODIs"},{"$f":" InputsR!F$23","v":0},{"$f":" InputsR!G$23","v":"£m"},{"$f":" InputsR!H$23","v":0},{"$f":" InputsR!I$23","v":0},{"$f":" InputsR!J$23","v":0},{"$f":" InputsR!K$23","v":0},{"$f":" InputsR!L$23","v":0},{"$f":" InputsR!M$23","v":0},{"$f":" InputsR!N$23","v":0},{"$f":" InputsR!O$23","v":0},{"$f":" InputsR!P$23","v":0},{"$f":" InputsR!Q$23","v":0},{"$f":" InputsR!R$23","v":0}]
[null,null,null,null,"Other adjustments, such as in- period ODIs - with 2 year lag of inflation",null,"£m",{"$f":" SUM(J154:W154)","v":0},null,{"$f":" IF( J152 < 4, J153 * K151 * L151, 0 )","v":0},{"$f":" IF( K152 < 4, K153 * L151 * M151, 0 )","v":0},0,0,0,0,0,0,0]
[]
[null,"Total revenue adjustment calculation"]
[]
[null,null,null,null,{"$f":" E$154","v":"Other adjustments, such as in- period ODIs - with 2 year lag of inflation"},{"$f":" F$154","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" E$140","v":"Bioresources revenue adjustment (ABR) - with financing adjustment & 2 year lag of inflation"},{"$f":" F$140","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" E$147","v":"Profit from bioresources trading - with 2 year lag of inflation"},{"$f":" F$147","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total revenue adjustment",null,"£m",{"$f":" SUM(J161:W161)","v":0},0,{"$f":"  J158 - J159 - J160","v":0},{"$f":"  K158 - K159 - K160","v":0},0,0,0,0,0,0,0]
[]
[null,"Adjustment to allowed revenue"]
[]
[null,null,null,null,{"$f":" E$161","v":"Total revenue adjustment"},{"$f":" F$161","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$50","v":"Forecast Period Flag"},{"$f":" Time!F$50","v":0},{"$f":" Time!G$50","v":"flag"},{"$f":" Time!H$50","v":5},{"$f":" Time!I$50","v":0},{"$f":" Time!J$50","v":0},{"$f":" Time!K$50","v":0},{"$f":" Time!L$50","v":0},{"$f":" Time!M$50","v":0},{"$f":" Time!N$50","v":1},{"$f":" Time!O$50","v":1},{"$f":" Time!P$50","v":1},{"$f":" Time!Q$50","v":1},{"$f":" Time!R$50","v":1}]
[null,null,null,null,"Total adjustment to allowed revenue including over / under recovery true up","2 PD LK BCK","£m",{"$f":"SUM(J167:U167)","v":0},0,null,{"$f":" I165 * K166","v":0},{"$f":" J165 * L166","v":0},0,0,0,0,0,0]
[]
["Application of adjustments in last two years at the end of AMP7"]
[]
[null,"Year 4 - One year of CPIH and financing costs adjustments applied"]
[]
[null,null,null,null,{"$f":" InputsR!E$25","v":"Discount rate"},{"$f":" InputsR!F$25","v":0},{"$f":" InputsR!G$25","v":"%"},{"$f":" InputsR!H$25","v":0},{"$f":" InputsR!I$25","v":0},{"$f":" InputsR!J$25","v":0},{"$f":" InputsR!K$25","v":0},{"$f":" InputsR!L$25","v":0},{"$f":" InputsR!M$25","v":0},{"$f":" InputsR!N$25","v":0},{"$f":" InputsR!O$25","v":0},{"$f":" InputsR!P$25","v":0},{"$f":" InputsR!Q$25","v":0},{"$f":" InputsR!R$25","v":0}]
[null,null,null,null,{"$f":" Index!E$26","v":"CPI(H) Nov-Nov - percentage increase - CALC"},{"$f":" Index!F$26","v":0},{"$f":" Index!G$26","v":0},{"$f":" Index!H$26","v":0},{"$f":" Index!I$26","v":0},{"$f":" Index!J$26","v":0},{"$f":" Index!K$26","v":0},{"$f":" Index!L$26","v":1.0284872298624754},{"$f":" Index!M$26","v":1.0210124164278893},{"$f":" Index!N$26","v":1},{"$f":" Index!O$26","v":1},{"$f":" Index!P$26","v":1},{"$f":" Index!Q$26","v":1},{"$f":" Index!R$26","v":1}]
[null,null,null,null,{"$f":" E$134","v":"Revenue imbalance"},{"$f":" F$134","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" Time!E$46","v":"Last Forecast Period Flag"},{"$f":" Time!F$46","v":0},{"$f":" Time!G$46","v":"flag"},{"$f":" Time!H$46","v":1},{"$f":" Time!I$46","v":0},{"$f":" Time!J$46","v":0},{"$f":" Time!K$46","v":0},{"$f":" Time!L$46","v":0},{"$f":" Time!M$46","v":0},{"$f":" Time!N$46","v":0},{"$f":" Time!O$46","v":0},{"$f":" Time!P$46","v":0},{"$f":" Time!Q$46","v":0},{"$f":" Time!R$46","v":1}]
[null,null,null,null,"Value of year 4 bioresources revenue adjustment (ABR) to be applied in PR24",null,"£m",{"$f":" SUM( J177:U177 )","v":0},null,{"$f":" J176 * - I175 * ( 1 + $F$173 ) * J174","v":0},{"$f":" K176 * - J175 * ( 1 + $F$173 ) * K174","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" Index!E$26","v":"CPI(H) Nov-Nov - percentage increase - CALC"},{"$f":" Index!F$26","v":0},{"$f":" Index!G$26","v":0},{"$f":" Index!H$26","v":0},{"$f":" Index!I$26","v":0},{"$f":" Index!J$26","v":0},{"$f":" Index!K$26","v":0},{"$f":" Index!L$26","v":1.0284872298624754},{"$f":" Index!M$26","v":1.0210124164278893},{"$f":" Index!N$26","v":1},{"$f":" Index!O$26","v":1},{"$f":" Index!P$26","v":1},{"$f":" Index!Q$26","v":1},{"$f":" Index!R$26","v":1}]
[null,null,null,null,{"$f":" InputsR!E$23","v":"Other adjustments, such as in-period ODIs"},{"$f":" InputsR!F$23","v":0},{"$f":" InputsR!G$23","v":"£m"},{"$f":" InputsR!H$23","v":0},{"$f":" InputsR!I$23","v":0},{"$f":" InputsR!J$23","v":0},{"$f":" InputsR!K$23","v":0},{"$f":" InputsR!L$23","v":0},{"$f":" InputsR!M$23","v":0},{"$f":" InputsR!N$23","v":0},{"$f":" InputsR!O$23","v":0},{"$f":" InputsR!P$23","v":0},{"$f":" InputsR!Q$23","v":0},{"$f":" InputsR!R$23","v":0}]
[null,null,null,"less",{"$f":" InputsR!E$21","v":"Profit from bioresources trading"},{"$f":" InputsR!F$21","v":0},{"$f":" InputsR!G$21","v":"£m"},{"$f":" InputsR!H$21","v":0},{"$f":" InputsR!I$21","v":0},{"$f":" InputsR!J$21","v":0},{"$f":" InputsR!K$21","v":0},{"$f":" InputsR!L$21","v":0},{"$f":" InputsR!M$21","v":0},{"$f":" InputsR!N$21","v":0},{"$f":" InputsR!O$21","v":0},{"$f":" InputsR!P$21","v":0},{"$f":" InputsR!Q$21","v":0},{"$f":" InputsR!R$21","v":0}]
[null,null,null,null,{"$f":" Time!E$46","v":"Last Forecast Period Flag"},{"$f":" Time!F$46","v":0},{"$f":" Time!G$46","v":"flag"},{"$f":" Time!H$46","v":1},{"$f":" Time!I$46","v":0},{"$f":" Time!J$46","v":0},{"$f":" Time!K$46","v":0},{"$f":" Time!L$46","v":0},{"$f":" Time!M$46","v":0},{"$f":" Time!N$46","v":0},{"$f":" Time!O$46","v":0},{"$f":" Time!P$46","v":0},{"$f":" Time!Q$46","v":0},{"$f":" Time!R$46","v":1}]
[null,null,null,null,"Value of other year 4 revenue adjustments to be applied in PR24",null,"£m",{"$f":" SUM( J183:U183 )","v":0},null,{"$f":" J182 * ( I180 - I181 ) * J179","v":0},{"$f":" K182 * ( J180 - J181 ) * K179","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$177","v":"Value of year 4 bioresources revenue adjustment (ABR) to be applied in PR24"},{"$f":" F$177","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$183","v":"Value of other year 4 revenue adjustments to be applied in PR24"},{"$f":" F$183","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Value of year 4 total bioresources revenue adjustment to be applied in PR24",null,"£m",{"$f":" SUM( J187:U187 )","v":0},null,{"$f":" J185 + J186","v":0},{"$f":" K185 + K186","v":0},{"$f":" L185 + L186","v":0},0,{"$f":" N185 + N186","v":0},0,0,0,0]
[]
[null,"Year 5 - No CPIH and financing costs adjustments applied"]
[]
[null,null,null,null,{"$f":" InputsR!E$23","v":"Other adjustments, such as in-period ODIs"},{"$f":" InputsR!F$23","v":0},{"$f":" InputsR!G$23","v":"£m"},{"$f":" InputsR!H$23","v":0},{"$f":" InputsR!I$23","v":0},{"$f":" InputsR!J$23","v":0},{"$f":" InputsR!K$23","v":0},{"$f":" InputsR!L$23","v":0},{"$f":" InputsR!M$23","v":0},{"$f":" InputsR!N$23","v":0},{"$f":" InputsR!O$23","v":0},{"$f":" InputsR!P$23","v":0},{"$f":" InputsR!Q$23","v":0},{"$f":" InputsR!R$23","v":0}]
[null,null,null,"less",{"$f":" E$134","v":"Revenue imbalance"},{"$f":" F$134","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"less",{"$f":" InputsR!E$21","v":"Profit from bioresources trading"},{"$f":" InputsR!F$21","v":0},{"$f":" InputsR!G$21","v":"£m"},{"$f":" InputsR!H$21","v":0},{"$f":" InputsR!I$21","v":0},{"$f":" InputsR!J$21","v":0},{"$f":" InputsR!K$21","v":0},{"$f":" InputsR!L$21","v":0},{"$f":" InputsR!M$21","v":0},{"$f":" InputsR!N$21","v":0},{"$f":" InputsR!O$21","v":0},{"$f":" InputsR!P$21","v":0},{"$f":" InputsR!Q$21","v":0},{"$f":" InputsR!R$21","v":0}]
[null,null,null,null,{"$f":" Time!E$46","v":"Last Forecast Period Flag"},{"$f":" Time!F$46","v":0},{"$f":" Time!G$46","v":"flag"},{"$f":" Time!H$46","v":1},{"$f":" Time!I$46","v":0},{"$f":" Time!J$46","v":0},{"$f":" Time!K$46","v":0},{"$f":" Time!L$46","v":0},{"$f":" Time!M$46","v":0},{"$f":" Time!N$46","v":0},{"$f":" Time!O$46","v":0},{"$f":" Time!P$46","v":0},{"$f":" Time!Q$46","v":0},{"$f":" Time!R$46","v":1}]
[null,null,null,null,"Value of year 5 total bioresources revenue adjustment to be applied in PR24",null,"£m",{"$f":" SUM( J195:U195 )","v":0},null,{"$f":" J194 * ( J191 - J192 - J193 )","v":0},{"$f":" K194 * ( K191 - K192 - K193 )","v":0},0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":" E$187","v":"Value of year 4 total bioresources revenue adjustment to be applied in PR24"},{"$f":" F$187","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$195","v":"Value of year 5 total bioresources revenue adjustment to be applied in PR24"},{"$f":" F$195","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total bioresources revenue adjustment to be applied in PR24",null,"£m",{"$f":" SUM( J199:R199 )","v":0},null,{"$f":" J197 + J198","v":0},{"$f":" K197 + K198","v":0},0,0,0,0,0,0,0]
[]
["Bioresources FAIM calculation"]
[]
[null,"Sludge production forecasting error"]
[]
[null,null,null,null,{"$f":" E$15","v":"Company forecast of sludge produced"},{"$f":" F$15","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"5-year total company forecast of sludge produced",{"$f":" SUM( N205:R205 )","v":0},"TDS"]
[]
[null,null,null,null,{"$f":" E$101","v":"Outturn sludge produced in year"},{"$f":" F$101","v":0},"TDS",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"5-year total outturn sludge produced in year",{"$f":" SUM( N208:R208 )","v":0},"TDS"]
[]
[null,null,null,null,{"$f":" E$206","v":"5-year total company forecast of sludge produced"},{"$f":" F$206","v":0},"TDS"]
[null,null,null,null,{"$f":" E$209","v":"5-year total outturn sludge produced in year"},{"$f":" F$209","v":0},"TDS"]
[null,null,null,null,"Absolute 5-year Forecast Error",{"$f":" ABS( F212 - F211 )","v":0},"TDS"]
[]
[null,null,null,null,{"$f":" E$206","v":"5-year total company forecast of sludge produced"},{"$f":" F$206","v":0},"TDS"]
[null,null,null,null,{"$f":" E$209","v":"5-year total outturn sludge produced in year"},{"$f":" F$209","v":0},"TDS"]
[null,null,null,null,"Forecast Error %",{"$f":" IF( F215 = 0, 0, ABS(( F216 - F215 ) / F215 ))","v":0},"%"]
[]
[null,"Calculation of penalty"]
[]
[null,null,null,null,{"$f":" InputsR!E$31","v":"Deadband"},{"$f":" InputsR!F$31","v":0.06},{"$f":" InputsR!G$31","v":"%"}]
[null,null,null,null,{"$f":" E$217","v":"Forecast Error %"},{"$f":" F$217","v":0},"%"]
[null,null,null,null,"Penalty required ?",{"$f":" IF( F222 >= F221, TRUE, FALSE)","v":false},"Boolean"]
[]
[null,null,null,null,{"$f":" InputsR!E$29","v":"Penalty rate"},{"$f":" InputsR!F$29","v":0.1},{"$f":" InputsR!G$29","v":"%"}]
[null,null,null,null,{"$f":" E$42","v":"Unadjusted revenue by year - 2017-18 FYA (CPIH deflated)"},{"$f":" F$42","v":0},"£m",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$217","v":"Forecast Error %"},{"$f":" F$217","v":0},"%"]
[null,null,null,null,{"$f":" E$223","v":"Penalty required ?"},{"$f":" F$223","v":false},"Boolean"]
[null,null,null,null,"Bioresources forecasting accuracy incentive penalty - 2017/18 FYA (CPIH deflated)",{"$f":" IF($F228 = FALSE, 0, $F225 * $H226 * $F$227 )","v":0},"£m"]
[]
["End of sheet"]

{"sheet":"Outputs","index":8,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"Outputs"}]
[null,null,null,null,{"$f":" Time!E$2","v":"Model Period Ending"},{"$f":" Checks!$F$9","v":0},"Error chks",{"$f":" Time!H$2","v":0},{"$f":" Time!I$2","v":0},{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$3","v":"Pre Forecast vs Forecast"},null,null,{"$f":" Time!H$3","v":0},{"$f":" Time!I$3","v":0},{"$f":" Time!J55","v":"Pre Fcst"},{"$f":" Time!K55","v":"Pre Fcst"},{"$f":" Time!L55","v":"Pre Fcst"},{"$f":" Time!M55","v":"Pre Fcst"},{"$f":" Time!N55","v":"Forecast"},{"$f":" Time!O55","v":"Forecast"},{"$f":" Time!P55","v":"Forecast"},{"$f":" Time!Q55","v":"Forecast"},{"$f":" Time!R55","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$4","v":"Financial Year Ending"},null,null,{"$f":" Time!H$4","v":0},{"$f":" Time!I$4","v":0},{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,{"$f":" Time!E$5","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["Bioresources outputs"]
[]
[null,null,null,null,{"$f":" Calc!E$199","v":"Total bioresources revenue adjustment to be applied in PR24"},{"$f":" Calc!F$199","v":0},{"$f":" Calc!G$199","v":"£m"},{"$f":" Calc!H$199","v":0},{"$f":" Calc!I$199","v":0},{"$f":" Calc!J$199","v":0},{"$f":" Calc!K$199","v":0},{"$f":" Calc!L$199","v":0},{"$f":" Calc!M$199","v":0},{"$f":" Calc!N$199","v":0},{"$f":" Calc!O$199","v":0},{"$f":" Calc!P$199","v":0},{"$f":" Calc!Q$199","v":0},{"$f":" Calc!R$199","v":0}]
[]
[null,null,null,null,{"$f":" Calc!E$229","v":"Bioresources forecasting accuracy incentive penalty - 2017/18 FYA (CPIH deflated)"},{"$f":" Calc!F$229","v":0},{"$f":" Calc!G$229","v":"£m"},{"$f":" Calc!H$229","v":0},{"$f":" Calc!I$229","v":0},{"$f":" Calc!J$229","v":0},{"$f":" Calc!K$229","v":0},{"$f":" Calc!L$229","v":0},{"$f":" Calc!M$229","v":0},{"$f":" Calc!N$229","v":0},{"$f":" Calc!O$229","v":0},{"$f":" Calc!P$229","v":0},{"$f":" Calc!Q$229","v":0},{"$f":" Calc!R$229","v":0}]
[]
["End"]

{"sheet":"Checks","index":9,"n_rows":19,"n_cols":18,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"Checks"}]
[null,null,null,null,{"$f":" Time!E$2","v":"Model Period Ending"},{"$f":" Checks!$F$9","v":0},"Error chks",{"$f":" Time!H$2","v":0},{"$f":" Time!I$2","v":0},{"$f":" Time!J$21","v":"2017-03-31"},{"$f":" Time!K$21","v":"2018-03-31"},{"$f":" Time!L$21","v":"2019-03-31"},{"$f":" Time!M$21","v":"2020-03-31"},{"$f":" Time!N$21","v":"2021-03-31"},{"$f":" Time!O$21","v":"2022-03-31"},{"$f":" Time!P$21","v":"2023-03-31"},{"$f":" Time!Q$21","v":"2024-03-31"},{"$f":" Time!R$21","v":"2025-03-31"}]
[null,null,null,null,{"$f":" Time!E$3","v":"Pre Forecast vs Forecast"},null,null,{"$f":" Time!H$3","v":0},{"$f":" Time!I$3","v":0},{"$f":" Time!J55","v":"Pre Fcst"},{"$f":" Time!K55","v":"Pre Fcst"},{"$f":" Time!L55","v":"Pre Fcst"},{"$f":" Time!M55","v":"Pre Fcst"},{"$f":" Time!N55","v":"Forecast"},{"$f":" Time!O55","v":"Forecast"},{"$f":" Time!P55","v":"Forecast"},{"$f":" Time!Q55","v":"Forecast"},{"$f":" Time!R55","v":"Forecast"}]
[null,null,null,null,{"$f":" Time!E$4","v":"Financial Year Ending"},null,null,{"$f":" Time!H$4","v":0},{"$f":" Time!I$4","v":0},{"$f":" Time!J$29","v":2017},{"$f":" Time!K$29","v":2018},{"$f":" Time!L$29","v":2019},{"$f":" Time!M$29","v":2020},{"$f":" Time!N$29","v":2021},{"$f":" Time!O$29","v":2022},{"$f":" Time!P$29","v":2023},{"$f":" Time!Q$29","v":2024},{"$f":" Time!R$29","v":2025}]
[null,null,null,null,{"$f":" Time!E$5","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$8","v":1},{"$f":" Time!K$8","v":2},{"$f":" Time!L$8","v":3},{"$f":" Time!M$8","v":4},{"$f":" Time!N$8","v":5},{"$f":" Time!O$8","v":6},{"$f":" Time!P$8","v":7},{"$f":" Time!Q$8","v":8},{"$f":" Time!R$8","v":9}]
[]
["CHECK SUMMARY"]
[]
[null,null,null,null,"Total Checks",{"$f":" SUM(F11:F17)","v":0},"check "]
[]
[null,null,null,null,"[do not delete this row]","[range start]"]
[]
[null,null,null,null,{"$f":" Time!E$66","v":"Modelling Period Check"},{"$f":" Time!F$66","v":0},{"$f":" Time!G$66","v":"check"}]
[null,null,null,null,{"$f":" Calc!E$53","v":"Total discounted revenue requirement check"},{"$f":" Calc!F$53","v":0},{"$f":" Calc!G$53","v":"check"}]
[null,null,null,null,{"$f":" Calc!E$95","v":"Fixed element adjustment total revenue check"},{"$f":" Calc!F$95","v":0},{"$f":" Calc!G$95","v":"check"}]
[]
[null,null,null,null,"[do not delete this row]","[range ends]"]
[]
["END"]