{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Cover","Documentation >>","User Guide","ToC","Model formatting","Inputs >>","Time","WINEP_Inputs","InpActive","Calcs >>","WINEP_Schemes","WINEP_Allowance","Outputs >>","Annual_Outputs","F_Outputs","QA >>","Track","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[29,3,29,4],[24,3,24,4],[23,3,23,4],[20,3,20,4],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[26,3,26,4],[27,3,27,4],[25,3,25,4],[28,3,28,4]]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,null,"Model name:","WINEP Reconciliation Model"]
[null,null,"Version number:","1n"]
[null,null,"Filename:","WINEP-Reconciliation-Model-Dec-2020-v1n.xlsm"]
[null,null,"Date:","2020-12-02"]
[null,null,"Author:","Ofwat"]
[null,null,"Author contact information:","OfwatPAndO@ofwat.gov.uk"]
[]
[]
[null,null,"Summary of model:","This illustrative model is designed to show how we will account for the impact of ministerial decisions on the scale of companies’ environmental enhancement programmes where this differs from our assumptions made at FD. Please note that, for brevity, the term 'WINEP' is used throughout. However, it should be taken to include both the WINEP in England and the NEP in Wales. "]
[null,null,null,"On sheet \"WINEP_Allowance\" we set out the adjustments we will make for each scheme in the company's WINEP programme that at the time of the final determination was unconfirmed. We show what will happen to adjust allowed totex for cost sharing, whether the scheme is confirmed as required or confirmed not required for the period 2020-25. For some companies there will be schemes listed that were not included in our enhancement allowance when we made our final determinations. We will make an opposite adjustment for these."]
[null,null,null,"On sheet \"WINEP_Schemes\" we convert the units used for each company’s unit cost mechanism as set out in the Cost Efficiency appendix to the company summary document of our Final Determinations. This is a bespoke conversion required for each company and the units shown are for illustration. Not all units shown will be relevant to every company."]
[null,null,null,"For most schemes the proportion confirmed will be either 100% or 0%. We have included a 'Proportion Confirmed' column to allow for the possibility that a scheme is partially confirmed. For example, if a scheme involves work on all reservoirs in a region but some reservoirs are subsequently sold then a reconciliation will be made to recover a proportion of the scheme's costs."]
[null,null,null,"Where schemes have been partially removed the company must present evidence that the proportion remaining has been signed off by the Environment Agency or Natural Resources Wales."]
[]
[null,null,null,"NB - The model price base is 'CPIH Financial year average 2017/18', unless otherwise stated. "]
[]
[]
[null,null,"Known limitations:","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,"Change Log:","Sheet(s) in current model",null,"Description of change(s) made","Model link(s)"]
[null,null,null,"Track",null,"Linked to correct cells in model. Previously this was incorrectly linked to blank cells. Added some additional tracking lines.",{"$f":"Track!A1","v":"Track"}]
[null,null,null,"User Guide",null,"Expanded the description of how to load the WINEP input data.",{"$f":"'User Guide'!D13","v":"INITIAL SET UP"}]
[null,null,null,"WINEP_Schemes",null,"Relabelled \"Quantity\" as \"Quantity in PR19 FD\"",{"$f":" WINEP_Schemes!J9","v":"Quantity in PR19 FD"}]
[null,null,null,"WINEP_Schemes",null,"Added new column \"Quantity Delivered\" and changed the input \"Proportion confirmed\" to be a calculation of \"Quantity Delivered\" divided by \"Quantity in PR19 FD\".",{"$f":" WINEP_Schemes!K9","v":"Quantity Delivered"}]
[null,null,null,"WINEP_Schemes",null,"Changed all Inputs to be brought forward from the WINEP_Inputs sheet. This affects \"Unit\", \"Unit Conversion\", \"Quantity\" and \"Price Control\"",{"$f":" WINEP_Schemes!F9","v":"Unit"}]
[null,null,null,"WINEP_Inputs",null,"Columns CR to CX now contain the WINEP inputs that need to be manually entered. The columns have been re-labelled for clarity.",{"$f":" WINEP_Inputs!CR3","v":"WINEP model inputs"}]
[null,null,null,"Annual_Outputs",null,"Relabelled the WINEP reconciliation outputs and added additional text for clarity. ",{"$f":" Annual_Outputs!E26","v":"WINEP Reconciliation, water resources - without adjustment for time value of money"}]
[]
[null,null,"Instructions:","A model 'User guide' is present in the model to help the user in operating the model."]
[null,null,null,"Follow link >>","Goto User Guide"]
[]
[null,null,"Error check status:",{"$f":"Check!$F$2","v":0},{"$f":" IF(D35 = 0, \"No error checks\", \"Error checks active\")","v":"No error checks"}]
[null,null,null,{"$f":"Check!$F$3","v":3},{"$f":" IF(D36 = 0, \"No output changes\", \"Output changes\")","v":"Output changes"}]
[]
[]
[]
["End of sheet"]

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

{"sheet":"User Guide","index":2,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"User Guide"}]
[]
[null,"INTRODUCTION"]
[]
[null,null,null,null,"This model will calculate the WINEP reconciliation adjustment in £m."]
[]
[null,null,null,"NAVIGATION"]
[null,null,null,null,"In order to navigate through the model the following key strokes will prove useful:"]
[null,null,null,null,"- To go to a sheet or row select a blue font cell and then either press CTRL+ [ or double click"]
[null,null,null,null,"- To return to the last position press F5 + Enter"]
[null,null,null,null,"- In accordance with best practice, the model is saved with a \"Manual Calculation\" setting. To ensure a full recalculation press: Ctrl + Alt + F9"]
[]
[null,null,null,"INITIAL SET UP"]
[null,null,null,null,"On first use of the model the WINEP_inputs sheet needs to be updated from the 2019 WINEP spreadsheet. You must use the list of WINEP sites as at Final Determination. "]
[]
[null,null,null,"1)","The WINEP_Inputs sheet needs to be setup so that the correct information is loaded onto the WINEP_Schemes sheet. Since all companies have used different units the procedure for doing this will vary. Most companies will be able to follow the steps below:"]
[null,null,null,"Step 1 - ","In the WINEP workbook identify all schemes that were Amber in the PR19 Final Determination WINEP workbook."]
[null,null,null,"Step 2 - ","Copy the schemes to cell C5 of WINEP_Inputs maintaining the column layout of the PR19 Final Determination WINEP spreadsheet."]
[null,null,null,"Step 3 - ","Complete column CR for all rows, 'Allowed totex unit rate'. This feeds through to the WINEP_Schemes sheet and should be copied directly from the tables in the Cost Efficiency appendix to the company summary document of our Final Determinations."]
[null,null,null,"Step 4 - ","Complete column CS for all rows, 'Quantity proposed in PR19 FD. This feeds through to the WINEP_Schemes sheet and is the amount to be delivered as stated in the Cost Efficiency appendix to the company summary document of our Final Determinations. This should be entered in the appropriate units e.g. £m per benefit point, £ per km LORI, £ per kgP/day removed, etc"]
[null,null,null,"Step 5 - ","Complete column CT for all rows, 'Quantity Delivered'. This feeds through to the WINEP_Schemes sheet and is the actual amount delivered. The proportion confirmed is then calculated from the inputs in columns CS and CT."]
[null,null,null,"Step 6 - ","Complete column CU for all rows with a 1 if the scheme was costed in the FD or a 0 if the scheme was not costed"]
[null,null,null,"Step 7 - ","In column CV select for all rows the price control that the WINEP adjustment will be applied to"]
[null,null,null,"Step 8 - ","Enter the units into column CW and a conversion factor into column CX to convert into £m."]
[]
[null,null,null,"2)","InpTime sheet : This is the sheet where all the Inputs related to dates and timelines are set up:"]
[null,null,null,null,{"$f":"Time!A1","v":"Time"}]
[]
[null,null,null,"3)","InpAct sheet : This is the sheet where all the Inputs used in the model calculations are present, all the inputs flow from this sheet into the model calculations:"]
[null,null,null,null,{"$f":"InpActive!A1","v":"InpActive"}]
[null,null,null,null,"Update all Input cells as required."]
[]
[null,null,null,null,"Recalculate the model once all the sheets are updated. Press Ctrl + Alt + F9"]
[]
[]
[]
[null,"HOW TO SAVE A PDF COPY OF ANY SHEET"]
[]
[null,null,null,"Step 1 - ","To save a sheet in PDF format, press button \"Save as PDF\""]
[]
[]
[]
[null,null,null,"Step 2 - ","In the dialog box, \"Enter sheet name\", type the name of the sheet you want to save"]
[]
[null,null,null,"Step 3 - ","In the dialog box, \"Save As\" change the file name if required"]
[]
[null,null,null,"Step 4 - ","Press \"Save\" to save a Pdf copy of the sheet"]
[]
[]
[]
[null,"HOW TO STORE TRACK IN TRACK SHEET"]
[]
[null,null,null,"USING MACRO"]
[null,null,null,null,"To store Track in the Track sheet using the macro, follow the steps below:"]
[]
[null,null,null,"Step 1 - ","Go to the Track sheet and press the \"Store Track\" button to save the track for a new case"]
[null,null,null,null,"Store Track"]
[]
[null,null,null,"Step 2 - ","A dialog box \"Enter the label for the new track column\" will appear, type the new track label (for example: \"version 17r\"), the label will appear in row 6"]
[]
[null,null,null,"Step 3 - ","A dialog box \"Enter the comment for the new track\" will appear, write a brief description of the change. The description will be appear at the bottom of the track column"]
[]
[null,null,null,"Step 4 - ","Press enter, a new track column will appear before the last stored track"]
[]
[null,null,null,"Step 5 - ","Review the difference between stored cases and active case (col H) by selecting the stored case in cell H6."]
[]
[null,null,null,"MANUAL METHOD"]
[]
[null,null,null,null,"To store Track in the Track sheet manually, follow the steps below:"]
[]
[null,null,null,"Step 1 - ","Select the column by pressing Ctrl + Spacebar and Copy (Ctrl + C). Then insert a new column after the last stored column by pressing Alt, I, E"]
[]
[null,null,null,"Step 2 - ","Select the newly inserted column (Ctrl + Spacebar) and delete the previously stored values from this column by pressing Delete button"]
[]
[null,null,null,"Step 3 - ","Go to active track column (H column). Select the range from H6 till 'do not delete row - range end' row and Copy (Ctrl + C)"]
[]
[null,null,null,"Step 4 - ","Paste the selected values (Alt E, S, V) in newly inserted column"]
[]
[null,null,null,"Step 5 - ","Update 'New track name' in row 6 of newly inserted column. Then select 'New track name' from the dropdown list present in H6."]
[]
[null,null,null,"Step 6 - ","Review the difference between stored cases and active case (col H) by selecting the stored case in cell H6."]
[]
[]
[]
["End of sheet"]

{"sheet":"ToC","index":3,"n_rows":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"ToC"}]
[]
["GENERIC MODEL DESIGN"]
[]
[null,null,null,null,null,"Table of Contents"]
[]
[]
[null,null,null,null,null,null,null,"DOCUMENTATION",null,null,null,"MODEL INPUTS",null,null,null,null,"MODEL CALCULATIONS",null,null,null,null,"MODEL OUTPUTS",null,null,null,"MODEL QA"]
[]
[null,null,null,null,null,null,null,"Cover",null,null,null,"WINEP_Inputs",null,null,null,null,"WINEP_Schemes",null,null,null,null,"Annual_Outputs",null,null,null,"Check"]
[null,null,null,null,null,null,null,"Model cover sheet",null,null,null,"WINEP inputs from business plans",null,null,null,null,"List of WINEP Amber schemes",null,null,null,null,"Annual profile of WINEP reconciliation",null,null,null,"Checks"]
[]
[null,null,null,null,null,null,null,"User Guide",null,null,null,"Time",null,null,null,null,"WINEP_Allowance",null,null,null,null,"F_Outputs",null,null,null,"Track"]
[null,null,null,null,null,null,null,"Explanation of setup and macros",null,null,null,"Dates and timelines",null,null,null,null,"Calculation of allowed cost",null,null,null,null,"Outputs to be uploaded to Fountain",null,null,null,"Model changes and track records"]
[]
[null,null,null,null,null,null,null,"ToC",null,null,null,"InpActive"]
[null,null,null,null,null,null,null,"Table of contents",null,null,null,"All inputs to be flowed into model"]
[]
[null,null,null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,null,null,"Explanation of different formatting types"]
[]
[]
[]
[]
["End of sheet"]

{"sheet":"Model formatting","index":4,"n_rows":72,"n_cols":7,"rows_kept":72,"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"]
[]
[null,null,null,null,"Orange",null,"To be used for internal purposes only, removed prior to publication"]
[]
["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,"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,"WINEP",null,"Water Industry National Environment Programme"]
[null,null,null,null,"£",null,"Great Britain Pound"]
[null,null,null,null,"m",null,"Million"]
[null,null,null,null,"na",null,"Not available / applicable"]
[null,null,null,null,"#",null,"Number"]
[]
["LIST OF MACROS USED"]
[]
[null,null,null,null,"Store track results"]
[null,null,null,null,null,null,"This macro helps in storing the results/outputs after any change is made in the model on \"Track\" sheet."]
[null,null,null,null,null,null,"These stored results then can be used to analyse the impact of any change made in the model."]
[null,null,null,null,null,null,"Goto macro"]
[]
[null,null,null,null,"Save as PDF"]
[null,null,null,null,null,null,"This macro helps in saving any worksheet or chart in PDF format."]
[]
["END OF SHEET"]

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

{"sheet":"Time","index":6,"n_rows":133,"n_cols":20,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Time"}]
[null,null,null,null,{"$f":" Time!E$25","v":"Model period ending"},null,null,null,null,{"$f":" Time!J$25","v":"2019-03-31"},{"$f":" Time!K$25","v":"2020-03-31"},{"$f":" Time!L$25","v":"2021-03-31"},{"$f":" Time!M$25","v":"2022-03-31"},{"$f":" Time!N$25","v":"2023-03-31"},{"$f":" Time!O$25","v":"2024-03-31"},{"$f":" Time!P$25","v":"2025-03-31"},{"$f":" Time!Q$25","v":"2026-03-31"},{"$f":" Time!R$25","v":"2027-03-31"},{"$f":" Time!S$25","v":"2028-03-31"},{"$f":" Time!T$25","v":"2029-03-31"}]
[null,null,null,null,{"$f":" Time!E$107","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$107","v":"Pre-Fcst"},{"$f":" Time!K$107","v":"Pre-Fcst"},{"$f":" Time!L$107","v":"Forecast"},{"$f":" Time!M$107","v":"Forecast"},{"$f":" Time!N$107","v":"Forecast"},{"$f":" Time!O$107","v":"Forecast"},{"$f":" Time!P$107","v":"Forecast"},{"$f":" Time!Q$107","v":"Post-Fcst"},{"$f":" Time!R$107","v":"Post-Fcst"},{"$f":" Time!S$107","v":"Post-Fcst"},{"$f":" Time!T$107","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$130","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$130","v":2019},{"$f":" Time!K$130","v":2020},{"$f":" Time!L$130","v":2021},{"$f":" Time!M$130","v":2022},{"$f":" Time!N$130","v":2023},{"$f":" Time!O$130","v":2024},{"$f":" Time!P$130","v":2025},{"$f":" Time!Q$130","v":2026},{"$f":" Time!R$130","v":2027},{"$f":" Time!S$130","v":2028},{"$f":" Time!T$130","v":2029}]
[null,null,null,null,{"$f":" Time!E$10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10},{"$f":" Time!T$10","v":11}]
[]
["MODEL PERIOD"]
[]
[null,"Model column counter "]
[null,null,null,null,"Model column counter",null,"counter",null,null,{"$f":" I10 + 1","v":1},{"$f":" J10 + 1","v":2},{"$f":" K10 + 1","v":3},{"$f":" L10 + 1","v":4},5,6,{"$f":" O10 + 1","v":7},{"$f":" P10 + 1","v":8},{"$f":" Q10 + 1","v":9},{"$f":" R10 + 1","v":10},11]
[null,null,null,null,"Model column total",{"$f":" MAX(J10:T10)","v":11},"columns"]
[]
[null,null,null,null,{"$f":" E$10","v":"Model column counter"},0,"counter",{"$f":" H$10","v":0},0,{"$f":" J$10","v":1},2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,"1st model column flag",null,"flag",{"$f":" SUM(J14:T14)","v":1},null,{"$f":" IF(J13 = 1, 1, 0)","v":1},{"$f":" IF(K13 = 1, 1, 0)","v":0},0,{"$f":" IF(M13 = 1, 1, 0)","v":0},{"$f":" IF(N13 = 1, 1, 0)","v":0},0,{"$f":" IF(P13 = 1, 1, 0)","v":0},{"$f":" IF(Q13 = 1, 1, 0)","v":0},{"$f":" IF(R13 = 1, 1, 0)","v":0},{"$f":" IF(S13 = 1, 1, 0)","v":0},0]
[]
[null,"Model period beginning"]
[null,null,null,null,{"$f":"InpActive!E12","v":"1st model column start date"},{"$f":"InpActive!F12","v":"2018-04-01"},{"$f":"InpActive!G12","v":"date"}]
[null,null,null,null,{"$f":"InpActive!E$39","v":"Months per model period"},{"$f":"InpActive!F$39","v":12},{"$f":"InpActive!G$39","v":"months"}]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",{"$f":" H$14","v":1},0,{"$f":" J$14","v":1},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model period beginning",null,"date",null,null,{"$f":" IF(J19 = 1, $F17, DATE(YEAR(I20), MONTH(I20) + $F18, DAY(1)))","v":"2018-04-01"},{"$f":" IF(K19 = 1, $F17, DATE(YEAR(J20), MONTH(J20) + $F18, DAY(1)))","v":"2019-04-01"},{"$f":" IF(L19 = 1, $F17, DATE(YEAR(K20), MONTH(K20) + $F18, DAY(1)))","v":"2020-04-01"},{"$f":" IF(M19 = 1, $F17, DATE(YEAR(L20), MONTH(L20) + $F18, DAY(1)))","v":"2021-04-01"},{"$f":" IF(N19 = 1, $F17, DATE(YEAR(M20), MONTH(M20) + $F18, DAY(1)))","v":"2022-04-01"},"2023-04-01",{"$f":" IF(P19 = 1, $F17, DATE(YEAR(O20), MONTH(O20) + $F18, DAY(1)))","v":"2024-04-01"},{"$f":" IF(Q19 = 1, $F17, DATE(YEAR(P20), MONTH(P20) + $F18, DAY(1)))","v":"2025-04-01"},{"$f":" IF(R19 = 1, $F17, DATE(YEAR(Q20), MONTH(Q20) + $F18, DAY(1)))","v":"2026-04-01"},{"$f":" IF(S19 = 1, $F17, DATE(YEAR(R20), MONTH(R20) + $F18, DAY(1)))","v":"2027-04-01"},"2028-04-01"]
[]
[null,"Model period ending"]
[null,null,null,null,{"$f":"InpActive!E$39","v":"Months per model period"},{"$f":"InpActive!F$39","v":12},{"$f":"InpActive!G$39","v":"months"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01","2028-04-01"]
[null,null,null,null,"Model period ending",null,"date",null,null,{"$f":" DATE(YEAR(J24), MONTH(J24) + $F23, DAY(J24) - 1)","v":"2019-03-31"},{"$f":" DATE(YEAR(K24), MONTH(K24) + $F23, DAY(K24) - 1)","v":"2020-03-31"},"2021-03-31","2022-03-31","2023-03-31","2024-03-31",{"$f":" DATE(YEAR(P24), MONTH(P24) + $F23, DAY(P24) - 1)","v":"2025-03-31"},{"$f":" DATE(YEAR(Q24), MONTH(Q24) + $F23, DAY(Q24) - 1)","v":"2026-03-31"},{"$f":" DATE(YEAR(R24), MONTH(R24) + $F23, DAY(R24) - 1)","v":"2027-03-31"},{"$f":" DATE(YEAR(S24), MONTH(S24) + $F23, DAY(S24) - 1)","v":"2028-03-31"},"2029-03-31"]
[]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31","2029-03-31"]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01","2028-04-01"]
[null,null,null,null,"Days in a year",null,"days",null,null,{"$f":" J27 - J28 + 1","v":365},{"$f":" K27 - K28 + 1","v":366},365,365,365,366,365,365,365,{"$f":" S27 - S28 + 1","v":366},365]
[]
[]
["FORECAST PERIOD"]
[]
[null,"Forecast start period flag"]
[null,null,null,null,{"$f":"InpActive!E$25","v":"Forecast start date"},{"$f":"InpActive!F$25","v":"2020-04-01"},{"$f":"InpActive!G$25","v":"date"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01","2028-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31","2029-03-31"]
[null,null,null,null,"Forecast start period flag",null,"flag",{"$f":" SUM(J38:T38)","v":1},null,{"$f":" IF(AND($F35 >= J36, $F35 <= J37), 1, 0)","v":0},{"$f":" IF(AND($F35 >= K36, $F35 <= K37), 1, 0)","v":0},1,0,0,0,{"$f":" IF(AND($F35 >= P36, $F35 <= P37), 1, 0)","v":0},{"$f":" IF(AND($F35 >= Q36, $F35 <= Q37), 1, 0)","v":0},{"$f":" IF(AND($F35 >= R36, $F35 <= R37), 1, 0)","v":0},{"$f":" IF(AND($F35 >= S36, $F35 <= S37), 1, 0)","v":0},0]
[]
[null,"Forecast end period flag"]
[null,null,null,null,{"$f":"InpActive!E$25","v":"Forecast start date"},{"$f":"InpActive!F$25","v":"2020-04-01"},{"$f":"InpActive!G$25","v":"date"}]
[null,null,null,null,{"$f":"InpActive!E26","v":"Forecast duration"},{"$f":"InpActive!F26","v":5},{"$f":"InpActive!G26","v":"years"}]
[null,null,null,null,"Forecast end date",{"$f":" DATE(YEAR(F41) + F42, MONTH(F41), DAY(F41) - 1)","v":"2025-03-31"},"date"]
[]
[null,null,null,null,{"$f":" E$43","v":"Forecast end date"},{"$f":" F$43","v":"2025-03-31"},{"$f":" G$43","v":"date"}]
[null,null,null,null,{"$f":" E$20","v":"Model period beginning"},"00:00:00","date","00:00:00","00:00:00","2018-04-01","2019-04-01","2020-04-01","2021-04-01","2022-04-01","2023-04-01","2024-04-01","2025-04-01","2026-04-01","2027-04-01","2028-04-01"]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31","2029-03-31"]
[null,null,null,null,"Forecast end period flag",null,"flag",{"$f":" SUM(J48:T48)","v":1},null,{"$f":" IF(AND($F45 >= J46, $F45 <= J47), 1, 0)","v":0},{"$f":" IF(AND($F45 >= K46, $F45 <= K47), 1, 0)","v":0},{"$f":" IF(AND($F45 >= L46, $F45 <= L47), 1, 0)","v":0},{"$f":" IF(AND($F45 >= M46, $F45 <= M47), 1, 0)","v":0},0,0,1,0,0,{"$f":" IF(AND($F45 >= S46, $F45 <= S47), 1, 0)","v":0},0]
[]
[null,"Forecast period flag"]
[null,null,null,null,{"$f":" E$38","v":"Forecast start period flag"},{"$f":" F$38","v":0},"flag",{"$f":" H$38","v":1},0,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$48","v":"Forecast end period flag"},{"$f":" F$48","v":0},"flag",{"$f":" H$48","v":1},0,0,0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"Forecast period flag",null,"flag",{"$f":" SUM(J53:T53)","v":5},null,{"$f":" J51 + I53 - I52","v":0},{"$f":" K51 + J53 - J52","v":0},{"$f":" L51 + K53 - K52","v":1},{"$f":" M51 + L53 - L52","v":1},1,1,{"$f":" P51 + O53 - O52","v":1},{"$f":" Q51 + P53 - P52","v":0},{"$f":" R51 + Q53 - Q52","v":0},{"$f":" S51 + R53 - R52","v":0},0]
[null,null,null,null,"Total number of forecast periods ",{"$f":" SUM(J53:R53)","v":5},"periods"]
[]
[null,"Forecast period counter"]
[null,null,null,null,{"$f":"E38","v":"Forecast start period flag"},{"$f":"F38","v":0},"flag",1,0,0,{"$f":"K38","v":0},1,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"E53","v":"Forecast period flag"},{"$f":"F53","v":0},"flag",5,0,0,{"$f":"K53","v":0},1,1,1,1,1,0,0,0,0]
[null,null,null,null,{"$f":"E48","v":"Forecast end period flag"},{"$f":"F48","v":0},"flag",1,0,{"$f":"J48","v":0},{"$f":"K48","v":0},{"$f":"L48","v":0},0,0,0,1,0,0,0,0]
[null,null,null,null,"Forecast period counter",null,"counter",null,null,{"$f":" IF(J57 = 1, 1, I60 + J58 - I59) * J58","v":0},{"$f":" IF(K57 = 1, 1, J60 + K58 - J59) * K58","v":0},{"$f":" IF(L57 = 1, 1, K60 + L58 - K59) * L58","v":1},{"$f":" IF(M57 = 1, 1, L60 + M58 - L59) * M58","v":2},{"$f":" IF(N57 = 1, 1, M60 + N58 - M59) * N58","v":3},4,5,0,0,0,0]
[]
[null,"Pre-forecast period flag"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},{"$f":" F$14","v":0},"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$38","v":"Forecast start period flag"},{"$f":" F$38","v":0},"flag",1,0,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Pre-forecast period flag",null,"flag",{"$f":" SUM(J65:T65)","v":2},null,{"$f":" J63 + I65 - J64","v":1},{"$f":" K63 + J65 - K64","v":1},{"$f":" L63 + K65 - L64","v":0},{"$f":" M63 + L65 - M64","v":0},0,0,{"$f":" P63 + O65 - P64","v":0},{"$f":" Q63 + P65 - Q64","v":0},{"$f":" R63 + Q65 - R64","v":0},{"$f":" S63 + R65 - S64","v":0},0]
[null,null,null,null,"Pre-forecast period flag - total",{"$f":" SUM(J65:T65)","v":2},"periods"]
[]
[null,null,null,null,{"$f":" E$38","v":"Forecast start period flag"},{"$f":" F$38","v":0},"flag",1,0,{"$f":" J$38","v":0},0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Last pre-forecast period flag",null,"flag",{"$f":" SUM(J69:T69)","v":{"$error":"#REF!"}},null,{"$f":" K68","v":0},{"$f":" L68","v":1},{"$f":" M68","v":0},{"$f":" N68","v":0},0,0,{"$f":" Q68","v":0},{"$f":" R68","v":0},{"$f":" S68","v":0},{"$f":" T68","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"First post-forecast period flag"]
[null,null,null,null,{"$f":" E$48","v":"Forecast end period flag"},{"$f":" F$48","v":0},"flag",1,0,{"$f":" J$48","v":0},0,0,0,0,0,1,0,0,0,0]
[null,null,null,null,"First post-forecast period flag",null,"flag",{"$f":" SUM(J73:T73)","v":1},null,{"$f":" I72","v":0},{"$f":" J72","v":0},{"$f":" K72","v":0},{"$f":" L72","v":0},0,0,{"$f":" O72","v":0},{"$f":" P72","v":1},{"$f":" Q72","v":0},{"$f":" R72","v":0},0]
[]
[null,"Post-forecast period flag"]
[null,null,null,null,{"$f":" E$73","v":"First post-forecast period flag"},0,"flag",1,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"Post-forecast period flag",null,"flag",{"$f":" SUM(J77:T77)","v":4},null,{"$f":" J76 + I77","v":0},{"$f":" K76 + J77","v":0},{"$f":" L76 + K77","v":0},{"$f":" M76 + L77","v":0},0,0,{"$f":" P76 + O77","v":0},{"$f":" Q76 + P77","v":1},{"$f":" R76 + Q77","v":1},{"$f":" S76 + R77","v":1},1]
[null,null,null,null,"Post-forecast period - total",{"$f":" SUM(J77:T77)","v":4},"periods"]
[]
[null,"Model period flag"]
[null,null,null,null,{"$f":" E$53","v":"Forecast period flag"},{"$f":" F$53","v":0},"flag",5,0,0,0,1,1,1,1,1,0,0,0,0]
[null,null,null,null,{"$f":" E$65","v":"Pre-forecast period flag"},{"$f":" F$65","v":0},"flag",2,0,1,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Model period flag",null,"flag",{"$f":" SUM(J83:T83)","v":7},null,{"$f":" MAX(J81:J82)","v":1},{"$f":" MAX(K81:K82)","v":1},1,1,1,1,1,0,0,{"$f":" MAX(S81:S82)","v":0},0]
[]
[null,"Forecast year"]
[null,null,null,null,{"$f":" E$130","v":"Financial year ending"},{"$f":" F$130","v":0},"year #",0,0,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,null,null,{"$f":" E$38","v":"Forecast start period flag"},{"$f":" F$38","v":0},"flag",1,0,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,"Forecast year 1",{"$f":" SUMPRODUCT(J87:T87, J86:T86)","v":2021},"year #"]
[]
[null,"Forecast year"]
[null,null,null,null,{"$f":" InpActive!E$29","v":"Forecast period reconcilation is profiled from"},{"$f":" InpActive!F$29","v":3},{"$f":" InpActive!G$29","v":"year"}]
[null,null,null,null,{"$f":"E60","v":"Forecast period counter"},0,"counter",0,0,0,0,1,2,3,4,5,0,0,0,0]
[null,null,null,null,"Start of adjustment profiling flag",null,"counter",{"$f":" SUM(J93:T93)","v":3},null,{"$f":" IF(J92 >= $F91, 1, 0)","v":0},{"$f":" IF(K92 >= $F91, 1, 0)","v":0},0,0,1,1,1,0,0,0,0]
[]
["MODEL TIMELINE"]
[]
[null,"Timeline label"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$38","v":"Forecast start period flag"},{"$f":" F$38","v":0},"flag",1,0,0,0,1,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$73","v":"First post-forecast period flag"},0,"flag",1,0,0,0,0,0,0,0,0,1,0,0,0]
[null,null,null,null,"Timeline label counter",null,"counter",null,null,{"$f":" I101 + SUM(J98:J100)","v":1},{"$f":" J101 + SUM(K98:K100)","v":1},{"$f":" K101 + SUM(L98:L100)","v":2},{"$f":" L101 + SUM(M98:M100)","v":2},2,2,{"$f":" O101 + SUM(P98:P100)","v":2},{"$f":" P101 + SUM(Q98:Q100)","v":3},{"$f":" Q101 + SUM(R98:R100)","v":3},{"$f":" R101 + SUM(S98:S100)","v":3},3]
[]
[null,null,null,null,{"$f":"InpActive!E19","v":"Pre - forecast period"},{"$f":"InpActive!F19","v":"Pre-Fcst"},{"$f":"InpActive!G19","v":"label"}]
[null,null,null,null,{"$f":"InpActive!E20","v":"Forecast period"},{"$f":"InpActive!F20","v":"Forecast"},{"$f":"InpActive!G20","v":"label"}]
[null,null,null,null,{"$f":"InpActive!E21","v":"Post - forecast period"},{"$f":"InpActive!F21","v":"Post-Fcst"},{"$f":"InpActive!G21","v":"label"}]
[null,null,null,null,{"$f":" E$101","v":"Timeline label counter"},0,"counter",0,0,1,1,2,2,2,2,2,3,3,3,3]
[null,null,null,null,"Timeline label",null,"label",null,null,{"$f":" INDEX($F103:$F105, J106)","v":"Pre-Fcst"},{"$f":" INDEX($F103:$F105, K106)","v":"Pre-Fcst"},{"$f":" INDEX($F103:$F105, L106)","v":"Forecast"},{"$f":" INDEX($F103:$F105, M106)","v":"Forecast"},{"$f":" INDEX($F103:$F105, N106)","v":"Forecast"},{"$f":" INDEX($F103:$F105, O106)","v":"Forecast"},{"$f":" INDEX($F103:$F105, P106)","v":"Forecast"},{"$f":" INDEX($F103:$F105, Q106)","v":"Post-Fcst"},{"$f":" INDEX($F103:$F105, R106)","v":"Post-Fcst"},{"$f":" INDEX($F103:$F105, S106)","v":"Post-Fcst"},"Post-Fcst"]
[]
[null,"Modelling period check"]
[null,null,null,null,{"$f":" E$65","v":"Pre-forecast period flag"},{"$f":" F$65","v":0},"flag",2,0,1,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":" E$53","v":"Forecast period flag"},{"$f":" F$53","v":0},"flag",5,0,0,0,1,1,1,1,1,0,0,0,0]
[null,null,null,null,{"$f":" E$77","v":"Post-forecast period flag"},0,"flag",4,0,0,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,"No. of overlapping in flags",null,"#",{"$f":" SUM(J113:T113)","v":0},null,{"$f":" MAX(0, SUM(J110:J112) - 1)","v":0},{"$f":" MAX(0, SUM(K110:K112) - 1)","v":0},{"$f":" MAX(0, SUM(L110:L112) - 1)","v":0},{"$f":" MAX(0, SUM(M110:M112) - 1)","v":0},{"$f":" MAX(0, SUM(N110:N112) - 1)","v":0},0,{"$f":" MAX(0, SUM(P110:P112) - 1)","v":0},{"$f":" MAX(0, SUM(Q110:Q112) - 1)","v":0},{"$f":" MAX(0, SUM(R110:R112) - 1)","v":0},{"$f":" MAX(0, SUM(S110:S112) - 1)","v":0},0]
[null,null,null,null,"Overlapping in periods - total",{"$f":" SUM(J113:T113)","v":0},"periods"]
[]
[null,null,null,null,{"$f":" E$11","v":"Model column total"},{"$f":" F$11","v":11},{"$f":" G$11","v":"columns"}]
[null,null,null,null,{"$f":" E$114","v":"Overlapping in periods - total"},{"$f":" F$114","v":0},{"$f":" G$114","v":"periods"}]
[null,null,null,null,{"$f":" E$66","v":"Pre-forecast period flag - total"},{"$f":" F$66","v":2},{"$f":" G$66","v":"periods"}]
[null,null,null,null,{"$f":" E$54","v":"Total number of forecast periods "},{"$f":" F$54","v":5},{"$f":" G$54","v":"periods"}]
[null,null,null,null,{"$f":" E$78","v":"Post-forecast period - total"},{"$f":" F$78","v":4},{"$f":" G$78","v":"periods"}]
[null,null,null,null,"Modelling period check",{"$f":" IF(SUM(F116:F117) - SUM(F118:F120) <> 0, 1, 0)","v":0},"check"]
[]
[]
["FINANCIAL YEAR"]
[]
[null,null,null,null,{"$f":"InpActive!E15","v":"First modelling column financial year #"},{"$f":"InpActive!F15","v":2019},{"$f":"InpActive!G15","v":"year #"}]
[null,null,null,null,{"$f":"InpActive!E16","v":"Financial year end month number #"},{"$f":"InpActive!F16","v":3},{"$f":"InpActive!G16","v":"month #"}]
[null,null,null,null,{"$f":" E$25","v":"Model period ending"},"00:00:00","date","00:00:00","00:00:00","2019-03-31","2020-03-31","2021-03-31","2022-03-31","2023-03-31","2024-03-31","2025-03-31","2026-03-31","2027-03-31","2028-03-31","2029-03-31"]
[null,null,null,null,{"$f":" E$14","v":"1st model column flag"},0,"flag",1,0,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Financial year ending",null,"year #",null,null,{"$f":" IF(J129 = 1, $F126, IF(J128 > (DATE(I130, $F127 + 1, 1) - 1), I130 + 1, I130))","v":2019},{"$f":" IF(K129 = 1, $F126, IF(K128 > (DATE(J130, $F127 + 1, 1) - 1), J130 + 1, J130))","v":2020},{"$f":" IF(L129 = 1, $F126, IF(L128 > (DATE(K130, $F127 + 1, 1) - 1), K130 + 1, K130))","v":2021},{"$f":" IF(M129 = 1, $F126, IF(M128 > (DATE(L130, $F127 + 1, 1) - 1), L130 + 1, L130))","v":2022},2023,2024,{"$f":" IF(P129 = 1, $F126, IF(P128 > (DATE(O130, $F127 + 1, 1) - 1), O130 + 1, O130))","v":2025},{"$f":" IF(Q129 = 1, $F126, IF(Q128 > (DATE(P130, $F127 + 1, 1) - 1), P130 + 1, P130))","v":2026},{"$f":" IF(R129 = 1, $F126, IF(R128 > (DATE(Q130, $F127 + 1, 1) - 1), Q130 + 1, Q130))","v":2027},{"$f":" IF(S129 = 1, $F126, IF(S128 > (DATE(R130, $F127 + 1, 1) - 1), R130 + 1, R130))","v":2028},2029]
[]
[]
["End of sheet"]

{"sheet":"WINEP_Inputs","index":7,"n_rows":48,"n_cols":104,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,18,1,19]]}
["WINEP3  Update March 2019",null,null,null,null,null,null,"National Full data set "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FBG Detail"]
["VERSION 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSSI/N2K/Ramsar",null,null,null,null,"Eels",null,"NERC Driver",null,null,null,null,null,null,null,"INNS",null,"MCZ","Water Quality Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Resource Detail",null,null,null,null,null,null,null,null,null,"Environmental Outcome ",null,null,null,null,null,null,null,null,null,"WINEP model inputs"]
["WINEPID","Change Log Winep 2 to 3  ","NEW Column. Has an alteration to this measure been made? If Y then please refer to alterations log. ","Application in determination by NPS?","Has a permit been issued?","Function","RBD","Area","Water Company ","Unique ID *   (completed on company collation)","Scheme Name/Name of Investigation/Site Name/Licence name","Name of Waterbody","Waterbody ID","Water Body Type(s)","WFD Operational Catchment","Blank Column","Blank Column","Blank Column","Driver Code \n(Primary)","Further Driver Code Information \n(related to the primary driver if applicable)","Driver Code \n(Secondary)","Further Driver Code Information \n(related to the secondary driver if applicable)","Driver Code\n(Tertiary)","Further Driver Code Information \n(related to the tertiary driver if applicable)","Measure Type","Completion Date (DD/MM/YY)","Level of Certainty? (P= Purple, R=Red, A=Amber, G=Green","Abstraction Licence/ Permit, Obstruction ID or No Obstruction ID","Eastings","Northings","Investigation Type","Investigation Scope","Implementation Scope","Groundwater Measures Information","Name of SSSI \n(if applicable)","Name of N2K/Ramsar site \n(if applicable)","SSSI/N2K/Ramsar Unit ID","SSSI/N2K/Ramsar Area of Unit (Hectares)","Justification for Action/Investigation","Eel Priority Status","Eel Improvement Type ","Primary Type of Priority Habitat Created or Restored/Improved","Secondary Type of Priority Habitat Created or Restored/Improved","Other Priority Habitat Created or Restored/Improved","Type of Action Taken","Units Recorded (Hectare or km)","Number of Hectares or Kms","Name of Priority Species","Name of High Risk of Extinction Species","INNS Control Measure","INNS Species \n(if applicable)","Name of MCZ","Name of Bathing Water \n(where applicable)","Name of Shellfish Water \n(where applicable)","Chemical of Interest \n(for chemicals measures only)","Groundwater Chemicals","Drinking Water Inspectorate - Undertaking or Notice \nY/N","DrWPA Substances at Risk\n(if applicable)","Safeguard Zone Name \n(if applicable)","Safeguard Zone ID \n(if applicable)","Population Equivalent for STWs ","Current Permit Limit (mg/l)","Proposed Permit Limit (mg/l)","Proposed Iron or Aluminium Limits \n(for Phosphorus measures only)","Current DWF (m3/d)","Proposed DWF (m3/d) \n(if applicable)","Proposed Permit Limit Other","Catchment Measure Actions ","Unsustainable Abstraction System Code","Linked Groundwater Body Name","Linked Groundwater Body ID","Licence Category","Water Resource Zone \n(WRZ)","WR HMWB Flag  \n(X)","Scheme Relates to Following Missing Mitigation Measures \n(HMWB only)","Annual Licence Volume (Ml/a)","Daily Licence Volume (Ml/d)","Aggregate Licence (x)","Sustainability Change (to Annual Licence Volume) \nMl/a","Sustainability Change (to Daily Licence Volume) \nMl/d","Sustainability Change (to HoF Condition) \nMl/d","*NEW* \nWater returned to the environment (Reduction in actual abstraction) ML/d","New Annual Licence Volume \n(Ml/a)","New Daily Licence Volume \n(Ml/d)","New HoF Condition \n(Ml/d)","Quantitative\nKm River Length Improved or Protected ","Quantitative\nArea (km2) Improved or Protected","Volume (Ml/yr) Drinking Water Protected","Hectares of Designated Site (HD/RAMSAR/\nSSSI) Restored or Improved","*NEW* \nINNS ,No Det outcome - Km2 of land with reduced risk of INNS","Delivers Additional FCERM Benefits \n(Y/N)","Delivers on Salmon 5-Point Action Plan","Additional Comments","CPS Reference","Flow Categorisation\n1= PR19 Synergy\n2= WFD failure\n3= Neither","Allowed totex unit rate","Quantity proposed in PR19 FD","Quantity Delivered","1 = In PR19, funded\n0 = In PR19, not funded","Price Control","Unit","Unit Conversion to £m","Changes made by company July 23 - please add comments on any changes"]
["EAN00324","Changed","Yes – alteration made",null,null,"WR","Anglian","East Anglia","Essex & Suffolk Water","7ES100130","LANGHAM A, B, C & E","River Brett catchment","GB105036040930","River","Stour OC",null,null,null,"WFD_IMP_WRFlow",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","8/36/15/*G/0092",602526,234430,null,null,"The Investigation and options appraisal is due to finish 31/3/2021 - this will inform the licence and non licence changes required.  The sustainability change listed in this WINEP is unconfirmed and comes from groundwater modelling completed 2018.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Essex Chalk",null,"CAT 1","South Essex","X",null,"No Annual on licence.  ",22.73,"X","No change","Reduction of 4.5Ml/d","N/A",null,"No Annual on licence","New daily of 18.23Ml/d","N/A",null,null,null,null,null,null,null,"This is part of the River Brett Scheme, which is a project involving Essex and Suffolk Water, Affinity Water and Anglian Water, in order to find joint solutions.  The extent of this licence change for ESW is uncertain, but is likely a licence change will be required.  A 4.5ML/d reduction represents the worst case scenario and is based on recent actual abstraction and the flows required in the outflow of the River Brett to meet the EFI. This Implementation line represents the licence and any non-licence changes (environmental improvements to the river) which will need to be in place so the River Brett waterbody reaches good Ecological Potential in 2027.  Therefore this licence change and other catchment measures need to be completed by 2024.  An Investigation and Options Apprasial has to be completed first by 31/3/2021 and this is shown as a seperate line in this WINEP.  ",null,null,0,1,1,1]
["EAN00401","Changed",null,null,null,"FBG","Anglian","East Anglia","Essex & Suffolk Water","7ES200010","Eel measures at Ormesby Broad","Ormesby Broad","GB30547009","Lake","Bure",null,null,null,"EE_IMP","Other",null,null,null,null,"Eel Screen","2025-03-31","Amber","7/34/09/*S/0054",646663,315512,null,null,"Cost beneficial screening",null,null,null,null,null,null,"High Priority","Both",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1.59,null,null,null,null,null,"Investigation completed, screening to be implemented with programme of works",null,null,0,1,1,1,"WR","£ million",1]
["NEA00013","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200012","Aldin Grange","Browney from Deerness confl to Wear","GB103024077552","River","Browney",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/0991",424900,543190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2152,null,0.7,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",576,576,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4,null,null,null,null,null,null,"Catchment solution for Browney",null,null,3.1259999999999999,1,1,1,"WWN+","£ million",1]
["NEA00702",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100001","Balder  - d/s Hury Resvoir dam wall -  - continue AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7  - MM5, MM2, MM7 and MM8","Balder Catchment (trib of Tees)","GB103025072240","River","Tees Upper",null,null,null,"WFD_IMP_WRHMWB","n/a",null,null,null,null,"Adaptive Management","2024-12-22","Amber","1/25/01/001",396700,519500,null," continue AMP6,  trial MM5 putting seasonality to compensation release, plus  MM2, MM7 and MM8 with a view to implementimng end AMP 7 ",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kielder","x","2,5,7, 8",53098.391000000003,145.47499999999999,"x",null,4.3,null,null,null,null,null,"5.4",null,null,null,null,null,"Recovering Salmon River","Adman trial started AMP6, implement the outcomes. \nNeed to account and include for monitoring\nCol BY/ Sust Change is for if scheme at IMP stage,  not reducing the licence but is worst case impact of adopting UKTAG building block flows and is subject to Aquator modelling as part of Options Appraisal report","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103025072240",null,8.3000000000000004E-2,1,1,1,"WR","£ million",1]
["NEA00703",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW10005","Barrasford raw water pumping station  - Rede to Gunnerton Burn, Barrasford to S Tyne, Watersmeet to Tidal Limit  -  Eels Regs and MM3","N Tyne from Barrasford to S Tyne confluence","GB103023075802","River","North Tyne Lower",null,null,null,"EE_IMP",null,null,null,null,null,"Eel Screen","2024-12-22","Amber","1/23/01/159",392280,572900,null,null,"Eel screens on raw water abstraction",null,null,null,null,null,null,"Medium Priority","Screen",null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"x",null,21900,60,"x",null,null,null,null,null,null,null,null,null,null,null,null,"No","Pricipal Salmon River","Also applies under HMWB MM3 entrainment.The main work will be carried out on GB103023074920 waterbody which is linked to the abstraction licence but further outcomes will be seen at these waterbodies GB103023075802, GB103023075801. Covering North Tyne Lower & Tyne Upper. These EE_IMP lines have been grouped as it was one structure that would have outcomes on three waterbodies. ","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103023074920",null,1.071,1,0,1,"WR","£ million",1,"Agreed late delivery 2025/26",{"$f":"+K9","v":"Barrasford raw water pumping station  - Rede to Gunnerton Burn, Barrasford to S Tyne, Watersmeet to Tidal Limit  -  Eels Regs and MM3"}]
["NEA00047","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200044","Bishop Middleham","Skerne from Carrs to Woodham Burn","GB103025072430","River","Skerne",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/03/1221",432710,530300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1168,null,1,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",274,274,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1,null,null,null,null,null,null,"Possible northumbria integrated drainage plans",null,null,1.895,1,1,1,"WWN+","£ million",1]
["NEA00706",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW10088","BLACK BURN catchwater, feeds into  Burnhope Burn d/s of  Catchwater . 100% take. MM5, MM7 ","Burnhope Burn from Source to River Derwent","GB103023074760","River","Derwent Tyne",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","1/23/04/001",null,null,null,"BLACK BURN catchwater, feeds into  Burnhope Burn d/s of  Catchwater . 100% take. MM5, MM6",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAT 4","Kielder","x","5,7,8",null,null,null,null,1.4,null,null,null,null,null,0.34,null,null,null,null,"No",null,"No control on current structure - should not rule out need for control on any future structure if deemed significant. The available resource of the Black Burn was assessed as 0.3mgd (1.4Mld). The value in BY/ Sust change is therefore the worse case, assuming the structure is removed. \nWill need to include env monitoring","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103023074760",null,0.13300000000000001,1,1,1,"WR","£ million",1]
["NEA00054","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200051","Bowburn","Croxdale Beck from Source to Wear","GB103024077410","River","Wear Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","243/0970",430090,"536978, ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9150,2,0.25,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",2618,2618,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.6,null,null,null,null,null,null,"Possible northumbria integrated drainage plans",null,null,0,1,1,1,"WWN+","£ million",1]
["NEA00060","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200057","Browney","Browney from Deerness confl to Wear","GB103024077552","River","Browney",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/0974"," 425870","538500",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20631,2,1,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",4676,4676,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4,null,null,null,null,null,null,null,null,null,0.14000000000000001,1,1,1,"WWN+","£ million",1]
["NEA00707",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW10009","Burnhope Burn catchwater  to River Derwent MM1 and MM2 , MM5, MM7 ","Burnhope Burn from Source to River Derwent","Gb103023074760","River","Derwent Tyne",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","1/23/04/001",400720,549200,null,"Implement PR6 Options Appraisal for Burnhope Burn catchwater  to River Derwent MM1 and MM2 , MM5, MM6",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","2,5,7,8",50006,137.00299999999999,"x",null,16.8,null,null,null,null,null,34.299999999999997,null,null,null,null,"No","Recovering Salmon River","No control on current structure - should not rule out need for control on any future structure if deemed significant. The catchwater (including the Black Burn - row 32) was designed to increase yield of Derwent reservoir by 4mgd (18.2Mld). The value in BY/ sust change is therefore the worse case, assuming the structure is removed. \nAlthough main River Tyne is a principal Salmon river, this is part of the River Derwent system , which is just beginning to recover salmon stocks\nWill need to include monitoring","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103023074760",null,0.24299999999999999,1,1,1,"WR","£ million",1]
["NEA00068","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200065","Carlton Redmarshall","Billingham Beck from Bishopton Bck to Brierle","GB103025072360","River","Tees Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/04/1706",438480,522230,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2641,null,0.4,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",685,685,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2,null,null,null,null,null,null,null,null,null,3.1850000000000001,1,1,1,"WWN+","£ million",1]
["NEA00070","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200067","Chilton Lane","Carrs from Source to Skerne","GB103025072520","River","Skerne",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/03/1218",431080,530350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3274,null,0.25,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1182,1182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,null,null,null,null,null,null,"Preferred solution would be WFD_IMPg, if affordability is unfavourable the no deterioration limit will apply. ",null,null,3.226,1,1,1,"WWN+","£ million",1]
["NEA00074","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200071","Crookhall","Smallhope Burn from Source to Browney, Stocke","GB103024077330","River","Browney",null,null,null,"WFD_IMPp","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/1006",412560,550430,null,null,null,null,null,1410,1410,null,null,null,null,null,null,null,"Refer to Salmon five point 4.2. http://www.salmon-trout.org/uploads/51bd4785e29c624c82a196553963da7d.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4869,null,0.9,"Iron\n3000 ug/l (95%ile)\n8000 ug/l (UT)",1410,1410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,1.385,1,1,1,"WWN+","£ million",1]
["NEA00081","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200078","Dipton","Pont Burn Catchment (trib of Derwent)","GB103023074780","River","Derwent Tyne",null,null,null,"WFD_IMPp","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","234/A/0656",415800,554400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2829,null,1,"Iron\n3000 ug/l (95%ile)\n8000 ug/l (UT)",780,780,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,null,null,null,null,null,null,null,null,null,1.962,1,1,1,"WWN+","£ million",1]
["NEA00089","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200086","Esh Winning","Deerness from Hedleyhope Burn to Browney","GB103024077280","River","Browney",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/1026",420157,542222,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4729,null,0.6,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1410,1410,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,"Required as part of Browney catchment solution.\nFAS:Highway and rural surface water run-off issues exposed in 2012 flood event.  Works at Pringle Place (New Brancepeth) mainly relate to additional highway drainage.  Works in Ushaw Moor are mainly a culvert upsizing to ease rural runoff backing up. Best Option to be determined following outcome of study (i.e. SUDS).",null,null,0,1,1,1,"WWN+","£ million",1]
["NEA00093","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200089","Fishburn","Skerne from Source to Carrs","GB103025076070","River","Skerne",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/03/1234",435580,531780,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2723,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1007,1007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3,null,null,null,null,null,"Other","Possible northumbria integrated drainage plans. Preferred solution would be WFD_IMPg, if affordability is unfavourable the no deterioration limit will apply. ",null,null,2.403,1,1,1,"WWN+","£ million",1]
["NEA00710",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100011","Harthope burn catchwater - Water supply asset    - MM1 and MM7","Wear from Wearhead to Middlehope Burn, Iresho","GB103024077440","River","Wear Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber","-",386981,536817,null,"Harthope beck catchwater - Water supply asset    - MM1 and MM6",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","1,8","-","-","-",null,null,null,null,null,null,null,4.25,null,null,null,null,"No",null,"Scheme name changed from Harthope Beck to Harthope Burn to avoid misunderstanding about location (Harthope beck is a WFD WB elsewhere).","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103024077440",null,0.17599999999999999,1,1,1,"WR","£ million",1]
["NEA00115","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200110","Hustledown STW (CIP2 T1)","Twizell Burn from Source to Cong Burn","GB103024077590","River","Wear Lower and Estuary",null,null,null,"WFD_IMP_CHEM",null,null,null,null,null,"Continuous Discharge","2024-12-31","Amber","245/1247",421200,551600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zinc (dissolved)",null,null,null,null,null,null,null,"41 ug/l (mean) ",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5,null,null,null,null,null,null,null,null,null,4.5049999999999999,1,1,1,"WWN+","£ million",1]
["NEA00117","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200112","Hustledown STW (CIP2 T1)","Twizell Burn from Source to Cong Burn","GB103024077590","River","Wear Lower and Estuary",null,null,null,"WFD_IMP_CHEM",null,null,null,null,null,"Continuous Discharge","31/12/2024","Amber","245/1247",421200,551600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iron (total)",null,null,null,null,null,null,null,"2.1 mg/l (95%)\n5.3 mg/l (UT)",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.5,null,null,null,null,null,null,null,null,null,0,1,1,1,"WWN+","£ million",1]
["NEA00711",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100013","Ireshope - Wham pasture MM1. MM7 \nBurnhope res supply","Ireshope Burn","GB103024077441","River","Wear Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber","-",384872,537169,null,"Ireshope - Wham pasture MM1. MM7 \nBurnhope res supply",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","1,7","-","-","-",null,null,null,null,null,null,null,15.1,null,null,null,null,"No","Pricipal Salmon River",null,"http://environment.data.gov.uk/catchment-planning/WaterBody/GB103024077441",null,0.17599999999999999,1,1,1,"WR","£ million",1]
["NEA00712",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100014","Ireshope Burn - Greenwell Crags - MM1, MM7\nBurnhope res supply\n","Ireshope Burn","GB103024077441","River","Wear Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber","-",385680,538015,null,"Ireshope Burn - Greenwell Crags - MM1, MM7\nBurnhope res supply\n",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","1,7","-","-","-",null,null,null,null,null,null,null,1.35,null,null,null,null,"No","Pricipal Salmon River",null,"http://environment.data.gov.uk/catchment-planning/WaterBody/GB103024077441",null,0.17599999999999999,1,1,1,"WR","£ million",1]
["NEA00466","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200461","Kelloe","Croxdale Beck from Source to Wear","GB103024077410","River","Wear Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","243/0965","433830","535890",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2186,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",526,526,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.9,null,null,null,null,null,null,"Possible northumbria integrated drainage plans",null,null,2.169,1,1,1,"WWN+","£ million",1]
["NEA00468","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200463","Kirklevington STW","Saltergill Beck Catchment (trib of Tees)","GB103025072050","River","Tees Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/04/1773",442720,510310,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1497,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",299,299,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3,null,null,null,null,null,null,null,null,null,3.1019999999999999,1,1,1,"WWN+","£ million",1]
["NEA00469","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200464","Knitsley","Smallhope Burn from Source to Browney, Stocke","GB103024077330","River","Browney",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/1028",412440,548120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5460,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1472,1472,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1,null,null,null,null,null,null,"Catchment solution for the Browney catchment. Preferred solution would be WFD_IMPg, if affordability is unfavourable the no deterioration limit will apply. ",null,null,3.6219999999999999,1,1,1,"WWN+","£ million",1]
["NEA00470","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200465","Lanchester","Smallhope Burn from Source to Browney, Stocke","GB103024077330","River","Browney",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/0986","417350","546570",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5447,null,0.7,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1261,1261,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,4.3250000000000002,1,1,1,"WWN+","£ million",1]
["NEA00477","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200472","Longnewton","Lustrum Beck Catchment (trib of Tees)","GB103025072550","River","Tees Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","254/1940",439010,516640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,732,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",184,184,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,"Possible northumbria integrated drainage plans. FAS:Portrack Industrial Estates",null,null,3.06,1,1,1,"WWN+","£ million",1]
["NEA00713",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100002","Lune - Grassholme Res Dam wall -  continue  AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7 - MM5, MM2, MM7 amd MM8","Lune from Selset Reservoir to the River Tees","GB103025072330","River","Tees Upper",null,null,null,"WFD_IMP_WRHMWB","n/a",null,null,null,null,"Adaptive Management","2024-12-22","Amber","1/25/01/001",394700,522900,null," continue AMP6,  trial MM5 putting seasonality to compensation release, plus  MM2, MM7 and MM8 with a view to implementimng end AMP 7 ",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kielder","x","2,5,7, 9",53098.391000000003,145.47499999999999,"x",null,18.600000000000001,null,null,null,null,null,3.5,null,null,null,null,null,"Recovering Salmon River","Adman trial started AMP6, implement the outcomes. \nNeed to account and include for monitoring\nCol BY/ Sust Change is for if scheme at IMP stage,  not reducing the licence but is worst case impact of adopting UKTAG building block flows and is subject to Aquator modelling as part of Options Appraisal report","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103025072330",null,8.3000000000000004E-2,1,1,1,"WR","£ million",1]
["NEA00499","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200494","New Moors","Hummer Beck from Source to Gaunless","GB103024072680","River","Gaunless",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","242/A/0706",416948,524152,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,743,null,0.4,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",263,263,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,null,null,null,null,null,null,"Preferred solution would be WFD_IMPm, if affordability is unfavourable the no deterioration limit will apply. ",null,null,3.5510000000000002,1,1,1,"WWN+","£ million",1]
["NEA00512","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200507","Pittington","Old Durham Beck from Chapman Beck to Wear","GB103024077470","River","Wear Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/0842","433228","543765",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1542,null,0.6,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",297,297,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.8,null,null,null,null,null,null,null,null,null,3.1019999999999999,1,1,1,"WWN+","£ million",1,"Name change to Sherburn STW"]
["NEA00513","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200508","Pity Me","Blackdene Burn to confluence with Wear","GB103024077622","River","Wear Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/1274",426300,545940,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1284,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",421,421,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,"Coal Authority planned removal of minewater point source discharge.\nFAS:Hillmeads, Nettlesworth",null,null,3.9950000000000001,1,1,1,"WWN+","£ million",1]
["NEA00514","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200509","Plawsworth","Blackdene Burn to confluence with Wear","GB103024077622","River","Wear Lower and Estuary",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/A/0712","426470","547470",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1417,null,1,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",400,400,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,null,null,null,null,null,null,"Coal Authority planned removal of minewater point source discharge.FAS:Hillmeads, Nettlesworth",null,null,3.0950000000000002,1,1,1,"WWN+","£ million",1]
["NEA00716","Changed",null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW10006","Pont  - channel d/s of sluice - MM6 and MM7","Pont from Source to Fenwick Burn","GB103022076850","River","Pont",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","1/23/01/001",405338,571341,null,"Channel d/s of sluice - MM6 and MM7 - unlikely to recover with new flow alone, needs intervention. ",null,null,null,null,null,null,null,"Yes",null,"Coastal and floodplain grazing marsh",null,null,"Restore habitat features",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","6,7","-","-","-",null,null,null,null,null,null,null,1.7,null,null,null,null,null,null,"suspect MM1 fish pass and licence compliance delivered in AMP 6 , is not enough to improve degraded channel downstream of sluice. Estimated changes: Not being able to abstract water from the Pont would mean (in an average year) an additional 7,000Ml/year of pumping is required at Barrasford and the DI of Whittle Dene would need to be reduced by an average of 14Ml/d, resulting in an additional 5,110Ml/year being pumped at Ovingham. There will be no reduction in total supply. ","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103022076850",null,0.14899999999999999,1,1,1,"WR","£ million",1]
["NEA00717",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100016","River Derwent -  implement outcomes of Adaptive Management trials for end of AMP 7  - MM5","Derwent from Burnhope Burn to River Tyne","GB103023074790","River","Derwent Tyne",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Adaptive Management","2024-12-22","Amber","1/23/04/001",412531,556850,null,"River Derwent - implement outcomes of the AMP 6  adman / trial MM5 seasonal compensation.",null,null,"",null,null,null,null,"Yes",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x",5,50006,137.00299999999999,"x",null,18.399999999999999,null,null,null,null,null,38,null,null,null,null,"No","Recovering Salmon River","Adman trial started AMP6 and will spillover into AMP7, implement the outcomes by end of AMP7. \nNeed to account and include for monitoring\nCol BY/Sust change is not reducing the licence but is the worst case impact of changing the reservoir releases to comply with UKTAG guidelines (given NW outflow constraints) and is subject to Aquator modelling as part of Options Appraisal report.\nPotential for Catchment Solution and Resilence combined with Flood scheme at Cherry Tree Drive and Path Head Dene, Sherburn Park Estate, Rowlands Gill Surface water management scheme, Shotley Bridge SW Flood Management Works, Leam Lane Estate, Ryton Greenfieldds, South Whickham ","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103023074790",null,8.3000000000000004E-2,1,1,1,"WR","£ million",1]
["NEA00526","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200521","Sacriston","South Burn to confluence with Wear","GB103024077623","River","Wear Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/1254",424620,547880,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5334,null,0.25,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1467,1467,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.9000000000000004,null,null,null,null,null,null,"FAS:The properties in Craigland Villas suffer regularly from flooding from overland flows from the school fields to the rear. The properties have been flooded internally on several occasions. Option to be determined following outcome of study (ie SUDS).\nThe properties in Dene Crescent suffer regularly from flooding from overland flows from the rear fields to the rear. The properties have been flooded internally on several occasions.  Best option to be determined following outcome of study (i.e. SUDS).",null,null,4.0019999999999998,1,1,1,"WWN+","£ million",1]
["NEA00529","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200524","Sedgefield","Billingham Beck from Source to Bishopton Beck","GB103025072410","River","Tees Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","254/1864",436020,527950,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4585,null,0.25,"Iron\n3500 ug/l (95%ile)\n8000 ug/l (UT)",1517,1517,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.7,null,null,null,null,null,null,"Possible northumbria integrated drainage plans",null,null,3.5640000000000001,1,1,1,"WWN+","£ million",1]
["NEA00530","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200525","Sedgeletch","Lumley Park Burn from Herrington Burn to R Wear","Gb103024077580","River","Wear Lower and Estuary",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/1243",432030,550820,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51589,null,"3.00",null,13500,13500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,"potential Catchment Solution and resilience combined with flood scheme Caroline Street Flood Alleviation, Hetton",null,null,4.6680000000000001,1,1,1,"WWN+","£ million",1]
["NEA00532","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200527","Sherburn","Old Durham Beck from Chapman Beck to Wear","GB103024077470","River","Wear Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","245/1248",431650,541830,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5323,null,0.5,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1650,1650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7,null,null,null,null,null,null,null,null,null,3.3490000000000002,1,1,1,"WWN+","£ million",1]
["NEA00536","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200531","Slaley - in combination effect with De Vere Hotel","March Burn Catchment (trib of Tyne)","GB103023075650","River","Tyne Upper",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","233/1178",398400,557300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,308,null,2,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",86,86,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,1.8049999999999999,1,1,1,"WWN+","£ million",1]
["NEA00720","Changed",null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100017","Smiddy Shaw and Hisehope reservoirs Surface Water Transfer , MM5, MM7 and MM8","Horsleyhope Burn Catchment (Trib of Derwent)","GB103023074740","River","Derwent Tyne",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Investigation and Options Appraisal","2024-12-22","Amber","1/24/01/034",402200,546620,null,"MM5 Establish an appropriate baseline flow regime plus gravels MM7 and MM8\n",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kielder","x","5,7,8",35458.800000000003,97.149000000000001,"x",null,null,null,null,null,null,null,4.72,null,null,null,null,null,null,null,"http://environment.data.gov.uk/catchment-planning/WaterBody/GB103023074740",null,8.3000000000000004E-2,1,1,1,"WR","£ million",1]
["NEA00563","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200556","Teeside Airport","Lustrum Beck Catchment (trib of Tees)","GB103025072550","River","Tees Lower and Estuary",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","254/1866",437210,514190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,755,null,0.4,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",447,447,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,null,null,null,null,null,"Recovering Salmon River","Possible northumbria integrated drainage plans. FAS:Portrack Industrial Estates",null,null,3.8839999999999999,1,1,1,"WWN+","£ million",1]
["NEA00575","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200568","Trimdon","Skerne from Source to Carrs","GB103025076070","River","Skerne",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","25/03/1232",437660,534510,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4715,null,0.3,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1308,1308,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.8,null,null,null,null,null,null,"Possible northumbria integrated drainage plans",null,null,4.2649999999999997,1,1,1,"WWN+","£ million",1]
["NEA00722",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100003","Waskerley Res -  d/s dam wall -  implement outcomes of Adaptive Management trials for end of AMP 7 - MM5, plus  MM1, MM2, MM4, MM8","Waskerley Beck from Source to Wear","GB103024077520","River","Wear Upper",null,null,null,"WFD_IMP_WRHMWB","n/a",null,null,null,null,"Adaptive Management","2024-12-22","Amber","1/24/01/034",402500,544210,null," Implement outcomes of the AMP6  trial MM5 putting seasonality to compensation release, plus  MM1, MM2, MM7 and MM8.  ",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","1,2,4,5,8",35458.800000000003,97.149000000000001,"x",null,2.4,null,null,null,null,null,2.81,null,null,null,null,null,null,"Adman trial started AMP6 and will spillover into AMP7, implement the outcomes by end of AMP7. \nNeed to account and include for monitoring\nCol BX/ Sust Change is for if scheme at IMP stage,  not reducing the licence but is worst case impact of adopting UKTAG building block flows and is subject to Aquator modelling as part of Options Appraisal report","http://environment.data.gov.uk/catchment-planning/WaterBody/GB103024077520",null,8.3000000000000004E-2,1,1,1,"WR","£ million",1]
["NEA00723",null,null,null,null,"WR","Northumbria","North East","Northumbrian Water","7NW100012","Wear Pipe crossing St Johns Chapel -fish passage MM1","Wear from Wearhead to Middlehope Burn, Iresho","GB103024077440","River","Wear Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber","-",387963,538352,null,"Wear Pipe crossing St Johns Chapel -fish passage MM0",null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Kielder","x","1,8","-","-","-",null,null,null,null,null,null,null,22.14,null,null,null,null,"No",null,null,"http://environment.data.gov.uk/catchment-planning/WaterBody/GB103024077440",null,0.17599999999999999,1,1,1,"WR","£ million",1]
["NEA00590","Changed",null,null,null,"WQ","Northumbria","North East","Northumbrian Water","7NW200583","Witton Gilbert","Browney from Deerness confl to Wear","GB103024077552","River","Browney",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","244/1027",423280,545060,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7377,null,0.7,"Iron\n4000 ug/l (95%ile)\n8000 ug/l (UT)",1730,1730,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,2.7240000000000002,1,1,1,"WWN+","£ million",1]

{"sheet":"InpActive","index":8,"n_rows":48,"n_cols":19,"rows_kept":48,"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!E25","v":"Model period ending"},{"$f":"Check!F2","v":0},"Checks",null,null,{"$f":" Time!J$25","v":"2019-03-31"},{"$f":" Time!K$25","v":"2020-03-31"},{"$f":" Time!L$25","v":"2021-03-31"},{"$f":" Time!M$25","v":"2022-03-31"},{"$f":" Time!N$25","v":"2023-03-31"},{"$f":" Time!O$25","v":"2024-03-31"},{"$f":" Time!P$25","v":"2025-03-31"},{"$f":" Time!Q$25","v":"2026-03-31"},{"$f":" Time!R$25","v":"2027-03-31"},{"$f":" Time!S$25","v":"2028-03-31"}]
[null,null,null,null,{"$f":"Time!E107","v":"Timeline label"},{"$f":"Check!F3","v":3},"Track chgs",null,null,{"$f":" Time!J$107","v":"Pre-Fcst"},{"$f":" Time!K$107","v":"Pre-Fcst"},{"$f":" Time!L$107","v":"Forecast"},{"$f":" Time!M$107","v":"Forecast"},{"$f":" Time!N$107","v":"Forecast"},{"$f":" Time!O$107","v":"Forecast"},{"$f":" Time!P$107","v":"Forecast"},{"$f":" Time!Q$107","v":"Post-Fcst"},{"$f":" Time!R$107","v":"Post-Fcst"},{"$f":" Time!S$107","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E130","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$130","v":2019},{"$f":" Time!K$130","v":2020},{"$f":" Time!L$130","v":2021},{"$f":" Time!M$130","v":2022},{"$f":" Time!N$130","v":2023},{"$f":" Time!O$130","v":2024},{"$f":" Time!P$130","v":2025},{"$f":" Time!Q$130","v":2026},{"$f":" Time!R$130","v":2027},{"$f":" Time!S$130","v":2028}]
[null,null,null,null,{"$f":"Time!E10","v":"Model column counter"},"Constant","Unit","Total",null,{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6},{"$f":" Time!P$10","v":7},{"$f":" Time!Q$10","v":8},{"$f":" Time!R$10","v":9},{"$f":" Time!S$10","v":10}]
[]
["A: TIME"]
[]
[null,"Timeline setup"]
[]
[null,null,"Timeline start dates"]
[null,null,null,null,"1st model column start date","2018-04-01","date","Date should be the first date of the financial year"]
[]
[null,null,"Financial year inputs"]
[null,null,null,null,"First modelling column financial year #",2019,"year #","Financial model start year"]
[null,null,null,null,"Financial year end month number #",3,"month #","Month of financial year end for financial model"]
[]
[null,null,"Timeline labels"]
[null,null,null,null,"Pre - forecast period","Pre-Fcst","label"]
[null,null,null,null,"Forecast period","Forecast","label"]
[null,null,null,null,"Post - forecast period","Post-Fcst","label"]
[]
[null,"Project dates"]
[]
[null,null,null,null,"Forecast start date","2020-04-01","date"]
[null,null,null,null,"Forecast duration",5,"years"]
[null,null,null,null,"Forecast duration (text)","2020-25","years #","For Info only"]
[]
[null,null,null,null,"Forecast period reconcilation is profiled from",3,"year"]
[]
["B: FINANCING INPUTS"]
[]
[null,null,null,null,"Financing cost index",null,"Index",null,null,null,null,4,3,2,1,0]
[]
[null,null,null,null,"Financing Cost",2.92E-2,"%"]
[]
["C: NON CHANGEABLE MODEL TECHNICAL INPUTS"]
[]
[null,null,null,null,"Months per model period",12,"months"]
[]
[null,null,null,null,"Track Tolerance Level",1E-3,"tolerance"]
[null,null,null,null,"Check Tolerance Level",9.9999999999999995E-8,"tolerance"]
[]
[null,null,null,null,"Thousands in a million",1000,"thousands"]
[null,null,null,null,"Units in a million",1000000,"unit"]
[null,null,null,null,"Unit conversion to percentage",100,"unit"]
[]
["End of sheet"]

{"sheet":"Calcs >>","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"WINEP_Schemes","index":10,"n_rows":99,"n_cols":14,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"WINEP_Schemes"}]
[null,null,null,null,null,{"$f":" Check!F2","v":0},"Checks"]
[null,null,null,null,null,{"$f":" Check!F3","v":3},"Track chgs"]
[]
["AMBER WINEP SCHEMES"]
[]
[null,null,"List of WINEP schemes that were unconfirmed at FD"]
[null,null,"The lines below are examples with some dummy inputs."]
[null,null,"WINEPID","Unique ID","Scheme category / name","Unit","Unit Conversion to £m",null,"Allowed totex unit rate","Quantity in PR19 FD","Quantity Delivered","1 = In FD, funded\n0 = In FD, not funded","Price Control","Proportion Confirmed"]
[null,null,{"$f":" WINEP_Inputs!A5","v":"EAN00324"},{"$f":" WINEP_Inputs!J5","v":"7ES100130"},{"$f":" WINEP_Inputs!K5","v":"LANGHAM A, B, C & E"},{"$f":"WINEP_Inputs!CW5","v":0},{"$f":"WINEP_Inputs!CX5","v":0},null,{"$f":" WINEP_Inputs!CR5","v":0},{"$f":" WINEP_Inputs!CS5","v":1},{"$f":" WINEP_Inputs!CT5","v":1},{"$f":" WINEP_Inputs!CU5","v":1},{"$f":" WINEP_Inputs!CV5","v":0},{"$f":" IF(K10 = 0, 0, K10 / J10)","v":1}]
[null,null,{"$f":" WINEP_Inputs!A6","v":"EAN00401"},{"$f":" WINEP_Inputs!J6","v":"7ES200010"},{"$f":" WINEP_Inputs!K6","v":"Eel measures at Ormesby Broad"},{"$f":"WINEP_Inputs!CW6","v":"£ million"},{"$f":"WINEP_Inputs!CX6","v":1},null,{"$f":" WINEP_Inputs!CR6","v":0},{"$f":" WINEP_Inputs!CS6","v":1},{"$f":" WINEP_Inputs!CT6","v":1},{"$f":" WINEP_Inputs!CU6","v":1},{"$f":" WINEP_Inputs!CV6","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A7","v":"NEA00013"},{"$f":" WINEP_Inputs!J7","v":"7NW200012"},{"$f":" WINEP_Inputs!K7","v":"Aldin Grange"},{"$f":"WINEP_Inputs!CW7","v":"£ million"},{"$f":"WINEP_Inputs!CX7","v":1},null,{"$f":" WINEP_Inputs!CR7","v":3.1259999999999999},{"$f":" WINEP_Inputs!CS7","v":1},{"$f":" WINEP_Inputs!CT7","v":1},{"$f":" WINEP_Inputs!CU7","v":1},{"$f":" WINEP_Inputs!CV7","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A8","v":"NEA00702"},{"$f":" WINEP_Inputs!J8","v":"7NW100001"},{"$f":" WINEP_Inputs!K8","v":"Balder  - d/s Hury Resvoir dam wall -  - continue AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7  - MM5, MM2, MM7 and MM8"},{"$f":"WINEP_Inputs!CW8","v":"£ million"},{"$f":"WINEP_Inputs!CX8","v":1},null,{"$f":" WINEP_Inputs!CR8","v":8.3000000000000004E-2},{"$f":" WINEP_Inputs!CS8","v":1},{"$f":" WINEP_Inputs!CT8","v":1},{"$f":" WINEP_Inputs!CU8","v":1},{"$f":" WINEP_Inputs!CV8","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A9","v":"NEA00703"},{"$f":" WINEP_Inputs!J9","v":"7NW10005"},{"$f":" WINEP_Inputs!K9","v":"Barrasford raw water pumping station  - Rede to Gunnerton Burn, Barrasford to S Tyne, Watersmeet to Tidal Limit  -  Eels Regs and MM3"},{"$f":"WINEP_Inputs!CW9","v":"£ million"},{"$f":"WINEP_Inputs!CX9","v":1},null,{"$f":" WINEP_Inputs!CR9","v":1.071},{"$f":" WINEP_Inputs!CS9","v":1},{"$f":" WINEP_Inputs!CT9","v":0},{"$f":" WINEP_Inputs!CU9","v":1},{"$f":" WINEP_Inputs!CV9","v":"WR"},0]
[null,null,{"$f":" WINEP_Inputs!A10","v":"NEA00047"},{"$f":" WINEP_Inputs!J10","v":"7NW200044"},{"$f":" WINEP_Inputs!K10","v":"Bishop Middleham"},{"$f":"WINEP_Inputs!CW10","v":"£ million"},{"$f":"WINEP_Inputs!CX10","v":1},null,{"$f":" WINEP_Inputs!CR10","v":1.895},{"$f":" WINEP_Inputs!CS10","v":1},{"$f":" WINEP_Inputs!CT10","v":1},{"$f":" WINEP_Inputs!CU10","v":1},{"$f":" WINEP_Inputs!CV10","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A11","v":"NEA00706"},{"$f":" WINEP_Inputs!J11","v":"7NW10088"},{"$f":" WINEP_Inputs!K11","v":"BLACK BURN catchwater, feeds into  Burnhope Burn d/s of  Catchwater . 100% take. MM5, MM7 "},{"$f":"WINEP_Inputs!CW11","v":"£ million"},{"$f":"WINEP_Inputs!CX11","v":1},null,{"$f":" WINEP_Inputs!CR11","v":0.13300000000000001},{"$f":" WINEP_Inputs!CS11","v":1},{"$f":" WINEP_Inputs!CT11","v":1},{"$f":" WINEP_Inputs!CU11","v":1},{"$f":" WINEP_Inputs!CV11","v":"WR"},{"$f":" IF(K16 = 0, 0, K16 / J16)","v":1}]
[null,null,{"$f":" WINEP_Inputs!A12","v":"NEA00054"},{"$f":" WINEP_Inputs!J12","v":"7NW200051"},{"$f":" WINEP_Inputs!K12","v":"Bowburn"},{"$f":"WINEP_Inputs!CW12","v":"£ million"},{"$f":"WINEP_Inputs!CX12","v":1},null,{"$f":" WINEP_Inputs!CR12","v":0},{"$f":" WINEP_Inputs!CS12","v":1},{"$f":" WINEP_Inputs!CT12","v":1},{"$f":" WINEP_Inputs!CU12","v":1},{"$f":" WINEP_Inputs!CV12","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A13","v":"NEA00060"},{"$f":" WINEP_Inputs!J13","v":"7NW200057"},{"$f":" WINEP_Inputs!K13","v":"Browney"},{"$f":"WINEP_Inputs!CW13","v":"£ million"},{"$f":"WINEP_Inputs!CX13","v":1},null,{"$f":" WINEP_Inputs!CR13","v":0.14000000000000001},{"$f":" WINEP_Inputs!CS13","v":1},{"$f":" WINEP_Inputs!CT13","v":1},{"$f":" WINEP_Inputs!CU13","v":1},{"$f":" WINEP_Inputs!CV13","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A14","v":"NEA00707"},{"$f":" WINEP_Inputs!J14","v":"7NW10009"},{"$f":" WINEP_Inputs!K14","v":"Burnhope Burn catchwater  to River Derwent MM1 and MM2 , MM5, MM7 "},{"$f":"WINEP_Inputs!CW14","v":"£ million"},{"$f":"WINEP_Inputs!CX14","v":1},null,{"$f":" WINEP_Inputs!CR14","v":0.24299999999999999},{"$f":" WINEP_Inputs!CS14","v":1},{"$f":" WINEP_Inputs!CT14","v":1},{"$f":" WINEP_Inputs!CU14","v":1},{"$f":" WINEP_Inputs!CV14","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A15","v":"NEA00068"},{"$f":" WINEP_Inputs!J15","v":"7NW200065"},{"$f":" WINEP_Inputs!K15","v":"Carlton Redmarshall"},{"$f":"WINEP_Inputs!CW15","v":"£ million"},{"$f":"WINEP_Inputs!CX15","v":1},null,{"$f":" WINEP_Inputs!CR15","v":3.1850000000000001},{"$f":" WINEP_Inputs!CS15","v":1},{"$f":" WINEP_Inputs!CT15","v":1},{"$f":" WINEP_Inputs!CU15","v":1},{"$f":" WINEP_Inputs!CV15","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A16","v":"NEA00070"},{"$f":" WINEP_Inputs!J16","v":"7NW200067"},{"$f":" WINEP_Inputs!K16","v":"Chilton Lane"},{"$f":"WINEP_Inputs!CW16","v":"£ million"},{"$f":"WINEP_Inputs!CX16","v":1},null,{"$f":" WINEP_Inputs!CR16","v":3.226},{"$f":" WINEP_Inputs!CS16","v":1},{"$f":" WINEP_Inputs!CT16","v":1},{"$f":" WINEP_Inputs!CU16","v":1},{"$f":" WINEP_Inputs!CV16","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A17","v":"NEA00074"},{"$f":" WINEP_Inputs!J17","v":"7NW200071"},{"$f":" WINEP_Inputs!K17","v":"Crookhall"},{"$f":"WINEP_Inputs!CW17","v":"£ million"},{"$f":"WINEP_Inputs!CX17","v":1},null,{"$f":" WINEP_Inputs!CR17","v":1.385},{"$f":" WINEP_Inputs!CS17","v":1},{"$f":" WINEP_Inputs!CT17","v":1},{"$f":" WINEP_Inputs!CU17","v":1},{"$f":" WINEP_Inputs!CV17","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A18","v":"NEA00081"},{"$f":" WINEP_Inputs!J18","v":"7NW200078"},{"$f":" WINEP_Inputs!K18","v":"Dipton"},{"$f":"WINEP_Inputs!CW18","v":"£ million"},{"$f":"WINEP_Inputs!CX18","v":1},null,{"$f":" WINEP_Inputs!CR18","v":1.962},{"$f":" WINEP_Inputs!CS18","v":1},{"$f":" WINEP_Inputs!CT18","v":1},{"$f":" WINEP_Inputs!CU18","v":1},{"$f":" WINEP_Inputs!CV18","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A19","v":"NEA00089"},{"$f":" WINEP_Inputs!J19","v":"7NW200086"},{"$f":" WINEP_Inputs!K19","v":"Esh Winning"},{"$f":"WINEP_Inputs!CW19","v":"£ million"},{"$f":"WINEP_Inputs!CX19","v":1},null,{"$f":" WINEP_Inputs!CR19","v":0},{"$f":" WINEP_Inputs!CS19","v":1},{"$f":" WINEP_Inputs!CT19","v":1},{"$f":" WINEP_Inputs!CU19","v":1},{"$f":" WINEP_Inputs!CV19","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A20","v":"NEA00093"},{"$f":" WINEP_Inputs!J20","v":"7NW200089"},{"$f":" WINEP_Inputs!K20","v":"Fishburn"},{"$f":"WINEP_Inputs!CW20","v":"£ million"},{"$f":"WINEP_Inputs!CX20","v":1},null,{"$f":" WINEP_Inputs!CR20","v":2.403},{"$f":" WINEP_Inputs!CS20","v":1},{"$f":" WINEP_Inputs!CT20","v":1},{"$f":" WINEP_Inputs!CU20","v":1},{"$f":" WINEP_Inputs!CV20","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A21","v":"NEA00710"},{"$f":" WINEP_Inputs!J21","v":"7NW100011"},{"$f":" WINEP_Inputs!K21","v":"Harthope burn catchwater - Water supply asset    - MM1 and MM7"},{"$f":"WINEP_Inputs!CW21","v":"£ million"},{"$f":"WINEP_Inputs!CX21","v":1},null,{"$f":" WINEP_Inputs!CR21","v":0.17599999999999999},{"$f":" WINEP_Inputs!CS21","v":1},{"$f":" WINEP_Inputs!CT21","v":1},{"$f":" WINEP_Inputs!CU21","v":1},{"$f":" WINEP_Inputs!CV21","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A22","v":"NEA00115"},{"$f":" WINEP_Inputs!J22","v":"7NW200110"},{"$f":" WINEP_Inputs!K22","v":"Hustledown STW (CIP2 T1)"},{"$f":"WINEP_Inputs!CW22","v":"£ million"},{"$f":"WINEP_Inputs!CX22","v":1},null,{"$f":" WINEP_Inputs!CR22","v":4.5049999999999999},{"$f":" WINEP_Inputs!CS22","v":1},{"$f":" WINEP_Inputs!CT22","v":1},{"$f":" WINEP_Inputs!CU22","v":1},{"$f":" WINEP_Inputs!CV22","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A23","v":"NEA00117"},{"$f":" WINEP_Inputs!J23","v":"7NW200112"},{"$f":" WINEP_Inputs!K23","v":"Hustledown STW (CIP2 T1)"},{"$f":"WINEP_Inputs!CW23","v":"£ million"},{"$f":"WINEP_Inputs!CX23","v":1},null,{"$f":" WINEP_Inputs!CR23","v":0},{"$f":" WINEP_Inputs!CS23","v":1},{"$f":" WINEP_Inputs!CT23","v":1},{"$f":" WINEP_Inputs!CU23","v":1},{"$f":" WINEP_Inputs!CV23","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A24","v":"NEA00711"},{"$f":" WINEP_Inputs!J24","v":"7NW100013"},{"$f":" WINEP_Inputs!K24","v":"Ireshope - Wham pasture MM1. MM7 \nBurnhope res supply"},{"$f":"WINEP_Inputs!CW24","v":"£ million"},{"$f":"WINEP_Inputs!CX24","v":1},null,{"$f":" WINEP_Inputs!CR24","v":0.17599999999999999},{"$f":" WINEP_Inputs!CS24","v":1},{"$f":" WINEP_Inputs!CT24","v":1},{"$f":" WINEP_Inputs!CU24","v":1},{"$f":" WINEP_Inputs!CV24","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A25","v":"NEA00712"},{"$f":" WINEP_Inputs!J25","v":"7NW100014"},{"$f":" WINEP_Inputs!K25","v":"Ireshope Burn - Greenwell Crags - MM1, MM7\nBurnhope res supply\n"},{"$f":"WINEP_Inputs!CW25","v":"£ million"},{"$f":"WINEP_Inputs!CX25","v":1},null,{"$f":" WINEP_Inputs!CR25","v":0.17599999999999999},{"$f":" WINEP_Inputs!CS25","v":1},{"$f":" WINEP_Inputs!CT25","v":1},{"$f":" WINEP_Inputs!CU25","v":1},{"$f":" WINEP_Inputs!CV25","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A26","v":"NEA00466"},{"$f":" WINEP_Inputs!J26","v":"7NW200461"},{"$f":" WINEP_Inputs!K26","v":"Kelloe"},{"$f":"WINEP_Inputs!CW26","v":"£ million"},{"$f":"WINEP_Inputs!CX26","v":1},null,{"$f":" WINEP_Inputs!CR26","v":2.169},{"$f":" WINEP_Inputs!CS26","v":1},{"$f":" WINEP_Inputs!CT26","v":1},{"$f":" WINEP_Inputs!CU26","v":1},{"$f":" WINEP_Inputs!CV26","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A27","v":"NEA00468"},{"$f":" WINEP_Inputs!J27","v":"7NW200463"},{"$f":" WINEP_Inputs!K27","v":"Kirklevington STW"},{"$f":"WINEP_Inputs!CW27","v":"£ million"},{"$f":"WINEP_Inputs!CX27","v":1},null,{"$f":" WINEP_Inputs!CR27","v":3.1019999999999999},{"$f":" WINEP_Inputs!CS27","v":1},{"$f":" WINEP_Inputs!CT27","v":1},{"$f":" WINEP_Inputs!CU27","v":1},{"$f":" WINEP_Inputs!CV27","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A28","v":"NEA00469"},{"$f":" WINEP_Inputs!J28","v":"7NW200464"},{"$f":" WINEP_Inputs!K28","v":"Knitsley"},{"$f":"WINEP_Inputs!CW28","v":"£ million"},{"$f":"WINEP_Inputs!CX28","v":1},null,{"$f":" WINEP_Inputs!CR28","v":3.6219999999999999},{"$f":" WINEP_Inputs!CS28","v":1},{"$f":" WINEP_Inputs!CT28","v":1},{"$f":" WINEP_Inputs!CU28","v":1},{"$f":" WINEP_Inputs!CV28","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A29","v":"NEA00470"},{"$f":" WINEP_Inputs!J29","v":"7NW200465"},{"$f":" WINEP_Inputs!K29","v":"Lanchester"},{"$f":"WINEP_Inputs!CW29","v":"£ million"},{"$f":"WINEP_Inputs!CX29","v":1},null,{"$f":" WINEP_Inputs!CR29","v":4.3250000000000002},{"$f":" WINEP_Inputs!CS29","v":1},{"$f":" WINEP_Inputs!CT29","v":1},{"$f":" WINEP_Inputs!CU29","v":1},{"$f":" WINEP_Inputs!CV29","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A30","v":"NEA00477"},{"$f":" WINEP_Inputs!J30","v":"7NW200472"},{"$f":" WINEP_Inputs!K30","v":"Longnewton"},{"$f":"WINEP_Inputs!CW30","v":"£ million"},{"$f":"WINEP_Inputs!CX30","v":1},null,{"$f":" WINEP_Inputs!CR30","v":3.06},{"$f":" WINEP_Inputs!CS30","v":1},{"$f":" WINEP_Inputs!CT30","v":1},{"$f":" WINEP_Inputs!CU30","v":1},{"$f":" WINEP_Inputs!CV30","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A31","v":"NEA00713"},{"$f":" WINEP_Inputs!J31","v":"7NW100002"},{"$f":" WINEP_Inputs!K31","v":"Lune - Grassholme Res Dam wall -  continue  AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7 - MM5, MM2, MM7 amd MM8"},{"$f":"WINEP_Inputs!CW31","v":"£ million"},{"$f":"WINEP_Inputs!CX31","v":1},null,{"$f":" WINEP_Inputs!CR31","v":8.3000000000000004E-2},{"$f":" WINEP_Inputs!CS31","v":1},{"$f":" WINEP_Inputs!CT31","v":1},{"$f":" WINEP_Inputs!CU31","v":1},{"$f":" WINEP_Inputs!CV31","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A32","v":"NEA00499"},{"$f":" WINEP_Inputs!J32","v":"7NW200494"},{"$f":" WINEP_Inputs!K32","v":"New Moors"},{"$f":"WINEP_Inputs!CW32","v":"£ million"},{"$f":"WINEP_Inputs!CX32","v":1},null,{"$f":" WINEP_Inputs!CR32","v":3.5510000000000002},{"$f":" WINEP_Inputs!CS32","v":1},{"$f":" WINEP_Inputs!CT32","v":1},{"$f":" WINEP_Inputs!CU32","v":1},{"$f":" WINEP_Inputs!CV32","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A33","v":"NEA00512"},{"$f":" WINEP_Inputs!J33","v":"7NW200507"},{"$f":" WINEP_Inputs!K33","v":"Pittington"},{"$f":"WINEP_Inputs!CW33","v":"£ million"},{"$f":"WINEP_Inputs!CX33","v":1},null,{"$f":" WINEP_Inputs!CR33","v":3.1019999999999999},{"$f":" WINEP_Inputs!CS33","v":1},{"$f":" WINEP_Inputs!CT33","v":1},{"$f":" WINEP_Inputs!CU33","v":1},{"$f":" WINEP_Inputs!CV33","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A34","v":"NEA00513"},{"$f":" WINEP_Inputs!J34","v":"7NW200508"},{"$f":" WINEP_Inputs!K34","v":"Pity Me"},{"$f":"WINEP_Inputs!CW34","v":"£ million"},{"$f":"WINEP_Inputs!CX34","v":1},null,{"$f":" WINEP_Inputs!CR34","v":3.9950000000000001},{"$f":" WINEP_Inputs!CS34","v":1},{"$f":" WINEP_Inputs!CT34","v":1},{"$f":" WINEP_Inputs!CU34","v":1},{"$f":" WINEP_Inputs!CV34","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A35","v":"NEA00514"},{"$f":" WINEP_Inputs!J35","v":"7NW200509"},{"$f":" WINEP_Inputs!K35","v":"Plawsworth"},{"$f":"WINEP_Inputs!CW35","v":"£ million"},{"$f":"WINEP_Inputs!CX35","v":1},null,{"$f":" WINEP_Inputs!CR35","v":3.0950000000000002},{"$f":" WINEP_Inputs!CS35","v":1},{"$f":" WINEP_Inputs!CT35","v":1},{"$f":" WINEP_Inputs!CU35","v":1},{"$f":" WINEP_Inputs!CV35","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A36","v":"NEA00716"},{"$f":" WINEP_Inputs!J36","v":"7NW10006"},{"$f":" WINEP_Inputs!K36","v":"Pont  - channel d/s of sluice - MM6 and MM7"},{"$f":"WINEP_Inputs!CW36","v":"£ million"},{"$f":"WINEP_Inputs!CX36","v":1},null,{"$f":" WINEP_Inputs!CR36","v":0.14899999999999999},{"$f":" WINEP_Inputs!CS36","v":1},{"$f":" WINEP_Inputs!CT36","v":1},{"$f":" WINEP_Inputs!CU36","v":1},{"$f":" WINEP_Inputs!CV36","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A37","v":"NEA00717"},{"$f":" WINEP_Inputs!J37","v":"7NW100016"},{"$f":" WINEP_Inputs!K37","v":"River Derwent -  implement outcomes of Adaptive Management trials for end of AMP 7  - MM5"},{"$f":"WINEP_Inputs!CW37","v":"£ million"},{"$f":"WINEP_Inputs!CX37","v":1},null,{"$f":" WINEP_Inputs!CR37","v":8.3000000000000004E-2},{"$f":" WINEP_Inputs!CS37","v":1},{"$f":" WINEP_Inputs!CT37","v":1},{"$f":" WINEP_Inputs!CU37","v":1},{"$f":" WINEP_Inputs!CV37","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A38","v":"NEA00526"},{"$f":" WINEP_Inputs!J38","v":"7NW200521"},{"$f":" WINEP_Inputs!K38","v":"Sacriston"},{"$f":"WINEP_Inputs!CW38","v":"£ million"},{"$f":"WINEP_Inputs!CX38","v":1},null,{"$f":" WINEP_Inputs!CR38","v":4.0019999999999998},{"$f":" WINEP_Inputs!CS38","v":1},{"$f":" WINEP_Inputs!CT38","v":1},{"$f":" WINEP_Inputs!CU38","v":1},{"$f":" WINEP_Inputs!CV38","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A39","v":"NEA00529"},{"$f":" WINEP_Inputs!J39","v":"7NW200524"},{"$f":" WINEP_Inputs!K39","v":"Sedgefield"},{"$f":"WINEP_Inputs!CW39","v":"£ million"},{"$f":"WINEP_Inputs!CX39","v":1},null,{"$f":" WINEP_Inputs!CR39","v":3.5640000000000001},{"$f":" WINEP_Inputs!CS39","v":1},{"$f":" WINEP_Inputs!CT39","v":1},{"$f":" WINEP_Inputs!CU39","v":1},{"$f":" WINEP_Inputs!CV39","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A40","v":"NEA00530"},{"$f":" WINEP_Inputs!J40","v":"7NW200525"},{"$f":" WINEP_Inputs!K40","v":"Sedgeletch"},{"$f":"WINEP_Inputs!CW40","v":"£ million"},{"$f":"WINEP_Inputs!CX40","v":1},null,{"$f":" WINEP_Inputs!CR40","v":4.6680000000000001},{"$f":" WINEP_Inputs!CS40","v":1},{"$f":" WINEP_Inputs!CT40","v":1},{"$f":" WINEP_Inputs!CU40","v":1},{"$f":" WINEP_Inputs!CV40","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A41","v":"NEA00532"},{"$f":" WINEP_Inputs!J41","v":"7NW200527"},{"$f":" WINEP_Inputs!K41","v":"Sherburn"},{"$f":"WINEP_Inputs!CW41","v":"£ million"},{"$f":"WINEP_Inputs!CX41","v":1},null,{"$f":" WINEP_Inputs!CR41","v":3.3490000000000002},{"$f":" WINEP_Inputs!CS41","v":1},{"$f":" WINEP_Inputs!CT41","v":1},{"$f":" WINEP_Inputs!CU41","v":1},{"$f":" WINEP_Inputs!CV41","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A42","v":"NEA00536"},{"$f":" WINEP_Inputs!J42","v":"7NW200531"},{"$f":" WINEP_Inputs!K42","v":"Slaley - in combination effect with De Vere Hotel"},{"$f":"WINEP_Inputs!CW42","v":"£ million"},{"$f":"WINEP_Inputs!CX42","v":1},null,{"$f":" WINEP_Inputs!CR42","v":1.8049999999999999},{"$f":" WINEP_Inputs!CS42","v":1},{"$f":" WINEP_Inputs!CT42","v":1},{"$f":" WINEP_Inputs!CU42","v":1},{"$f":" WINEP_Inputs!CV42","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A43","v":"NEA00720"},{"$f":" WINEP_Inputs!J43","v":"7NW100017"},{"$f":" WINEP_Inputs!K43","v":"Smiddy Shaw and Hisehope reservoirs Surface Water Transfer , MM5, MM7 and MM8"},{"$f":"WINEP_Inputs!CW43","v":"£ million"},{"$f":"WINEP_Inputs!CX43","v":1},null,{"$f":" WINEP_Inputs!CR43","v":8.3000000000000004E-2},{"$f":" WINEP_Inputs!CS43","v":1},{"$f":" WINEP_Inputs!CT43","v":1},{"$f":" WINEP_Inputs!CU43","v":1},{"$f":" WINEP_Inputs!CV43","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A44","v":"NEA00563"},{"$f":" WINEP_Inputs!J44","v":"7NW200556"},{"$f":" WINEP_Inputs!K44","v":"Teeside Airport"},{"$f":"WINEP_Inputs!CW44","v":"£ million"},{"$f":"WINEP_Inputs!CX44","v":1},null,{"$f":" WINEP_Inputs!CR44","v":3.8839999999999999},{"$f":" WINEP_Inputs!CS44","v":1},{"$f":" WINEP_Inputs!CT44","v":1},{"$f":" WINEP_Inputs!CU44","v":1},{"$f":" WINEP_Inputs!CV44","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A45","v":"NEA00575"},{"$f":" WINEP_Inputs!J45","v":"7NW200568"},{"$f":" WINEP_Inputs!K45","v":"Trimdon"},{"$f":"WINEP_Inputs!CW45","v":"£ million"},{"$f":"WINEP_Inputs!CX45","v":1},null,{"$f":" WINEP_Inputs!CR45","v":4.2649999999999997},{"$f":" WINEP_Inputs!CS45","v":1},{"$f":" WINEP_Inputs!CT45","v":1},{"$f":" WINEP_Inputs!CU45","v":1},{"$f":" WINEP_Inputs!CV45","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A46","v":"NEA00722"},{"$f":" WINEP_Inputs!J46","v":"7NW100003"},{"$f":" WINEP_Inputs!K46","v":"Waskerley Res -  d/s dam wall -  implement outcomes of Adaptive Management trials for end of AMP 7 - MM5, plus  MM1, MM2, MM4, MM8"},{"$f":"WINEP_Inputs!CW46","v":"£ million"},{"$f":"WINEP_Inputs!CX46","v":1},null,{"$f":" WINEP_Inputs!CR46","v":8.3000000000000004E-2},{"$f":" WINEP_Inputs!CS46","v":1},{"$f":" WINEP_Inputs!CT46","v":1},{"$f":" WINEP_Inputs!CU46","v":1},{"$f":" WINEP_Inputs!CV46","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A47","v":"NEA00723"},{"$f":" WINEP_Inputs!J47","v":"7NW100012"},{"$f":" WINEP_Inputs!K47","v":"Wear Pipe crossing St Johns Chapel -fish passage MM1"},{"$f":"WINEP_Inputs!CW47","v":"£ million"},{"$f":"WINEP_Inputs!CX47","v":1},null,{"$f":" WINEP_Inputs!CR47","v":0.17599999999999999},{"$f":" WINEP_Inputs!CS47","v":1},{"$f":" WINEP_Inputs!CT47","v":1},{"$f":" WINEP_Inputs!CU47","v":1},{"$f":" WINEP_Inputs!CV47","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A48","v":"NEA00590"},{"$f":" WINEP_Inputs!J48","v":"7NW200583"},{"$f":" WINEP_Inputs!K48","v":"Witton Gilbert"},{"$f":"WINEP_Inputs!CW48","v":"£ million"},{"$f":"WINEP_Inputs!CX48","v":1},null,{"$f":" WINEP_Inputs!CR48","v":2.7240000000000002},{"$f":" WINEP_Inputs!CS48","v":1},{"$f":" WINEP_Inputs!CT48","v":1},{"$f":" WINEP_Inputs!CU48","v":1},{"$f":" WINEP_Inputs!CV48","v":"WWN+"},1]
[null,null,{"$f":" WINEP_Inputs!A49","v":0},{"$f":" WINEP_Inputs!J49","v":0},{"$f":" WINEP_Inputs!K49","v":0},{"$f":"WINEP_Inputs!CW49","v":0},{"$f":"WINEP_Inputs!CX49","v":0},null,{"$f":" WINEP_Inputs!CR49","v":0},{"$f":" WINEP_Inputs!CS49","v":0},{"$f":" WINEP_Inputs!CT49","v":0},{"$f":" WINEP_Inputs!CU49","v":0},{"$f":" WINEP_Inputs!CV49","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of sheet"]

{"sheet":"WINEP_Allowance","index":11,"n_rows":80,"n_cols":22,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"WINEP_Allowance"}]
[null,null,null,null,null,{"$f":"Check!F2","v":0},"Checks"]
[null,null,null,null,null,{"$f":"Check!F3","v":3},"Track chgs"]
[]
["CALCULATION OF ADJUSTED ALLOWED COST FOR CONFIRMED SCHEMES"]
[]
["List of Amber Schemes"]
[null,"Calculate the adjusted allowed cost per scheme, £m and the WINEP reconciliation per control, £m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WR","WN","WWN","BR","DMY"]
[null,null,{"$f":" WINEP_Schemes!C9","v":"WINEPID"},{"$f":" WINEP_Schemes!D9","v":"Unique ID"},{"$f":" WINEP_Schemes!E9","v":"Scheme category / name"},{"$f":" WINEP_Schemes!F9","v":"Unit"},{"$f":" WINEP_Schemes!G9","v":"Unit Conversion to £m"},{"$f":" WINEP_Schemes!H9","v":0},{"$f":" WINEP_Schemes!J9","v":"Quantity in PR19 FD"},{"$f":" WINEP_Schemes!I9","v":"Allowed totex unit rate"},{"$f":" WINEP_Schemes!K9","v":"Quantity Delivered"},{"$f":" WINEP_Schemes!L9","v":"1 = In FD, funded\n0 = In FD, not funded"},{"$f":" WINEP_Schemes!M9","v":"Price Control"},{"$f":" WINEP_Schemes!N9","v":"Proportion Confirmed"},"FD Allowance, £m","Adjusted Allowance (Delivered), £m","WINEP Reconciliation, £m","Water Resources £m","Water Network £m","Wastewater Network £m","Bioresources £m","Dummy £m"]
[null,null,{"$f":"WINEP_Schemes!C10","v":"EAN00324"},{"$f":"WINEP_Schemes!D10","v":"7ES100130"},{"$f":"WINEP_Schemes!E10","v":"LANGHAM A, B, C & E"},{"$f":"WINEP_Schemes!F10","v":0},{"$f":"WINEP_Schemes!G10","v":0},{"$f":"WINEP_Schemes!H10","v":0},{"$f":"WINEP_Schemes!J10","v":1},{"$f":"WINEP_Schemes!I10","v":0},{"$f":"WINEP_Schemes!K10","v":1},{"$f":"WINEP_Schemes!L10","v":1},{"$f":"WINEP_Schemes!M10","v":0},{"$f":"WINEP_Schemes!N10","v":1},{"$f":" I11 * J11 * G11","v":0},{"$f":" N11 * O11","v":0},{"$f":" IF(L11 = 0, P11, (N11 - 1) * O11)","v":0},{"$f":" IF($M11 = R$9, $Q11, 0)","v":0},{"$f":" IF($M11 = S$9, $Q11, 0)","v":0},{"$f":" IF($M11 = T$9, $Q11, 0)","v":0},{"$f":" IF($M11 = U$9, $Q11, 0)","v":0},{"$f":" IF($M11 = V$9, $Q11, 0)","v":0}]
[null,null,{"$f":"WINEP_Schemes!C11","v":"EAN00401"},{"$f":"WINEP_Schemes!D11","v":"7ES200010"},{"$f":"WINEP_Schemes!E11","v":"Eel measures at Ormesby Broad"},{"$f":"WINEP_Schemes!F11","v":"£ million"},{"$f":"WINEP_Schemes!G11","v":1},{"$f":"WINEP_Schemes!H11","v":0},{"$f":"WINEP_Schemes!J11","v":1},{"$f":"WINEP_Schemes!I11","v":0},{"$f":"WINEP_Schemes!K11","v":1},{"$f":"WINEP_Schemes!L11","v":1},{"$f":"WINEP_Schemes!M11","v":"WR"},{"$f":"WINEP_Schemes!N11","v":1},{"$f":" I12 * J12 * G12","v":0},{"$f":" N12 * O12","v":0},{"$f":" IF(L12 = 0, P12, (N12 - 1) * O12)","v":0},{"$f":" IF($M12 = R$9, $Q12, 0)","v":0},0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C12","v":"NEA00013"},{"$f":"WINEP_Schemes!D12","v":"7NW200012"},{"$f":"WINEP_Schemes!E12","v":"Aldin Grange"},{"$f":"WINEP_Schemes!F12","v":"£ million"},{"$f":"WINEP_Schemes!G12","v":1},{"$f":"WINEP_Schemes!H12","v":0},{"$f":"WINEP_Schemes!J12","v":1},{"$f":"WINEP_Schemes!I12","v":3.1259999999999999},{"$f":"WINEP_Schemes!K12","v":1},{"$f":"WINEP_Schemes!L12","v":1},{"$f":"WINEP_Schemes!M12","v":"WWN+"},{"$f":"WINEP_Schemes!N12","v":1},{"$f":" I13 * J13 * G13","v":3.1259999999999999},{"$f":" N13 * O13","v":3.1259999999999999},{"$f":" IF(L13 = 0, P13, (N13 - 1) * O13)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C13","v":"NEA00702"},{"$f":"WINEP_Schemes!D13","v":"7NW100001"},{"$f":"WINEP_Schemes!E13","v":"Balder  - d/s Hury Resvoir dam wall -  - continue AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7  - MM5, MM2, MM7 and MM8"},{"$f":"WINEP_Schemes!F13","v":"£ million"},{"$f":"WINEP_Schemes!G13","v":1},{"$f":"WINEP_Schemes!H13","v":0},{"$f":"WINEP_Schemes!J13","v":1},{"$f":"WINEP_Schemes!I13","v":8.3000000000000004E-2},{"$f":"WINEP_Schemes!K13","v":1},{"$f":"WINEP_Schemes!L13","v":1},{"$f":"WINEP_Schemes!M13","v":"WR"},{"$f":"WINEP_Schemes!N13","v":1},{"$f":" I14 * J14 * G14","v":8.3000000000000004E-2},{"$f":" N14 * O14","v":8.3000000000000004E-2},{"$f":" IF(L14 = 0, P14, (N14 - 1) * O14)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C14","v":"NEA00703"},{"$f":"WINEP_Schemes!D14","v":"7NW10005"},{"$f":"WINEP_Schemes!E14","v":"Barrasford raw water pumping station  - Rede to Gunnerton Burn, Barrasford to S Tyne, Watersmeet to Tidal Limit  -  Eels Regs and MM3"},{"$f":"WINEP_Schemes!F14","v":"£ million"},{"$f":"WINEP_Schemes!G14","v":1},{"$f":"WINEP_Schemes!H14","v":0},{"$f":"WINEP_Schemes!J14","v":1},{"$f":"WINEP_Schemes!I14","v":1.071},{"$f":"WINEP_Schemes!K14","v":0},{"$f":"WINEP_Schemes!L14","v":1},{"$f":"WINEP_Schemes!M14","v":"WR"},{"$f":"WINEP_Schemes!N14","v":0},1.071,0,-1.071,-1.071,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C15","v":"NEA00047"},{"$f":"WINEP_Schemes!D15","v":"7NW200044"},{"$f":"WINEP_Schemes!E15","v":"Bishop Middleham"},{"$f":"WINEP_Schemes!F15","v":"£ million"},{"$f":"WINEP_Schemes!G15","v":1},{"$f":"WINEP_Schemes!H15","v":0},{"$f":"WINEP_Schemes!J15","v":1},{"$f":"WINEP_Schemes!I15","v":1.895},{"$f":"WINEP_Schemes!K15","v":1},{"$f":"WINEP_Schemes!L15","v":1},{"$f":"WINEP_Schemes!M15","v":"WWN+"},{"$f":"WINEP_Schemes!N15","v":1},1.895,1.895,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C16","v":"NEA00706"},{"$f":"WINEP_Schemes!D16","v":"7NW10088"},{"$f":"WINEP_Schemes!E16","v":"BLACK BURN catchwater, feeds into  Burnhope Burn d/s of  Catchwater . 100% take. MM5, MM7 "},{"$f":"WINEP_Schemes!F16","v":"£ million"},{"$f":"WINEP_Schemes!G16","v":1},{"$f":"WINEP_Schemes!H16","v":0},{"$f":"WINEP_Schemes!J16","v":1},{"$f":"WINEP_Schemes!I16","v":0.13300000000000001},{"$f":"WINEP_Schemes!K16","v":1},{"$f":"WINEP_Schemes!L16","v":1},{"$f":"WINEP_Schemes!M16","v":"WR"},{"$f":"WINEP_Schemes!N16","v":1},{"$f":" I17 * J17 * G17","v":0.13300000000000001},{"$f":" N17 * O17","v":0.13300000000000001},{"$f":" IF(L17 = 0, P17, (N17 - 1) * O17)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C17","v":"NEA00054"},{"$f":"WINEP_Schemes!D17","v":"7NW200051"},{"$f":"WINEP_Schemes!E17","v":"Bowburn"},{"$f":"WINEP_Schemes!F17","v":"£ million"},{"$f":"WINEP_Schemes!G17","v":1},{"$f":"WINEP_Schemes!H17","v":0},{"$f":"WINEP_Schemes!J17","v":1},{"$f":"WINEP_Schemes!I17","v":0},{"$f":"WINEP_Schemes!K17","v":1},{"$f":"WINEP_Schemes!L17","v":1},{"$f":"WINEP_Schemes!M17","v":"WWN+"},{"$f":"WINEP_Schemes!N17","v":1},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C18","v":"NEA00060"},{"$f":"WINEP_Schemes!D18","v":"7NW200057"},{"$f":"WINEP_Schemes!E18","v":"Browney"},{"$f":"WINEP_Schemes!F18","v":"£ million"},{"$f":"WINEP_Schemes!G18","v":1},{"$f":"WINEP_Schemes!H18","v":0},{"$f":"WINEP_Schemes!J18","v":1},{"$f":"WINEP_Schemes!I18","v":0.14000000000000001},{"$f":"WINEP_Schemes!K18","v":1},{"$f":"WINEP_Schemes!L18","v":1},{"$f":"WINEP_Schemes!M18","v":"WWN+"},{"$f":"WINEP_Schemes!N18","v":1},0.14000000000000001,0.14000000000000001,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C19","v":"NEA00707"},{"$f":"WINEP_Schemes!D19","v":"7NW10009"},{"$f":"WINEP_Schemes!E19","v":"Burnhope Burn catchwater  to River Derwent MM1 and MM2 , MM5, MM7 "},{"$f":"WINEP_Schemes!F19","v":"£ million"},{"$f":"WINEP_Schemes!G19","v":1},{"$f":"WINEP_Schemes!H19","v":0},{"$f":"WINEP_Schemes!J19","v":1},{"$f":"WINEP_Schemes!I19","v":0.24299999999999999},{"$f":"WINEP_Schemes!K19","v":1},{"$f":"WINEP_Schemes!L19","v":1},{"$f":"WINEP_Schemes!M19","v":"WR"},{"$f":"WINEP_Schemes!N19","v":1},0.24299999999999999,0.24299999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C20","v":"NEA00068"},{"$f":"WINEP_Schemes!D20","v":"7NW200065"},{"$f":"WINEP_Schemes!E20","v":"Carlton Redmarshall"},{"$f":"WINEP_Schemes!F20","v":"£ million"},{"$f":"WINEP_Schemes!G20","v":1},{"$f":"WINEP_Schemes!H20","v":0},{"$f":"WINEP_Schemes!J20","v":1},{"$f":"WINEP_Schemes!I20","v":3.1850000000000001},{"$f":"WINEP_Schemes!K20","v":1},{"$f":"WINEP_Schemes!L20","v":1},{"$f":"WINEP_Schemes!M20","v":"WWN+"},{"$f":"WINEP_Schemes!N20","v":1},3.1850000000000001,3.1850000000000001,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C21","v":"NEA00070"},{"$f":"WINEP_Schemes!D21","v":"7NW200067"},{"$f":"WINEP_Schemes!E21","v":"Chilton Lane"},{"$f":"WINEP_Schemes!F21","v":"£ million"},{"$f":"WINEP_Schemes!G21","v":1},{"$f":"WINEP_Schemes!H21","v":0},{"$f":"WINEP_Schemes!J21","v":1},{"$f":"WINEP_Schemes!I21","v":3.226},{"$f":"WINEP_Schemes!K21","v":1},{"$f":"WINEP_Schemes!L21","v":1},{"$f":"WINEP_Schemes!M21","v":"WWN+"},{"$f":"WINEP_Schemes!N21","v":1},3.226,3.226,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C22","v":"NEA00074"},{"$f":"WINEP_Schemes!D22","v":"7NW200071"},{"$f":"WINEP_Schemes!E22","v":"Crookhall"},{"$f":"WINEP_Schemes!F22","v":"£ million"},{"$f":"WINEP_Schemes!G22","v":1},{"$f":"WINEP_Schemes!H22","v":0},{"$f":"WINEP_Schemes!J22","v":1},{"$f":"WINEP_Schemes!I22","v":1.385},{"$f":"WINEP_Schemes!K22","v":1},{"$f":"WINEP_Schemes!L22","v":1},{"$f":"WINEP_Schemes!M22","v":"WWN+"},{"$f":"WINEP_Schemes!N22","v":1},1.385,1.385,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C23","v":"NEA00081"},{"$f":"WINEP_Schemes!D23","v":"7NW200078"},{"$f":"WINEP_Schemes!E23","v":"Dipton"},{"$f":"WINEP_Schemes!F23","v":"£ million"},{"$f":"WINEP_Schemes!G23","v":1},{"$f":"WINEP_Schemes!H23","v":0},{"$f":"WINEP_Schemes!J23","v":1},{"$f":"WINEP_Schemes!I23","v":1.962},{"$f":"WINEP_Schemes!K23","v":1},{"$f":"WINEP_Schemes!L23","v":1},{"$f":"WINEP_Schemes!M23","v":"WWN+"},{"$f":"WINEP_Schemes!N23","v":1},1.962,1.962,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C24","v":"NEA00089"},{"$f":"WINEP_Schemes!D24","v":"7NW200086"},{"$f":"WINEP_Schemes!E24","v":"Esh Winning"},{"$f":"WINEP_Schemes!F24","v":"£ million"},{"$f":"WINEP_Schemes!G24","v":1},{"$f":"WINEP_Schemes!H24","v":0},{"$f":"WINEP_Schemes!J24","v":1},{"$f":"WINEP_Schemes!I24","v":0},{"$f":"WINEP_Schemes!K24","v":1},{"$f":"WINEP_Schemes!L24","v":1},{"$f":"WINEP_Schemes!M24","v":"WWN+"},{"$f":"WINEP_Schemes!N24","v":1},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C25","v":"NEA00093"},{"$f":"WINEP_Schemes!D25","v":"7NW200089"},{"$f":"WINEP_Schemes!E25","v":"Fishburn"},{"$f":"WINEP_Schemes!F25","v":"£ million"},{"$f":"WINEP_Schemes!G25","v":1},{"$f":"WINEP_Schemes!H25","v":0},{"$f":"WINEP_Schemes!J25","v":1},{"$f":"WINEP_Schemes!I25","v":2.403},{"$f":"WINEP_Schemes!K25","v":1},{"$f":"WINEP_Schemes!L25","v":1},{"$f":"WINEP_Schemes!M25","v":"WWN+"},{"$f":"WINEP_Schemes!N25","v":1},2.403,2.403,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C26","v":"NEA00710"},{"$f":"WINEP_Schemes!D26","v":"7NW100011"},{"$f":"WINEP_Schemes!E26","v":"Harthope burn catchwater - Water supply asset    - MM1 and MM7"},{"$f":"WINEP_Schemes!F26","v":"£ million"},{"$f":"WINEP_Schemes!G26","v":1},{"$f":"WINEP_Schemes!H26","v":0},{"$f":"WINEP_Schemes!J26","v":1},{"$f":"WINEP_Schemes!I26","v":0.17599999999999999},{"$f":"WINEP_Schemes!K26","v":1},{"$f":"WINEP_Schemes!L26","v":1},{"$f":"WINEP_Schemes!M26","v":"WR"},{"$f":"WINEP_Schemes!N26","v":1},0.17599999999999999,0.17599999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C27","v":"NEA00115"},{"$f":"WINEP_Schemes!D27","v":"7NW200110"},{"$f":"WINEP_Schemes!E27","v":"Hustledown STW (CIP2 T1)"},{"$f":"WINEP_Schemes!F27","v":"£ million"},{"$f":"WINEP_Schemes!G27","v":1},{"$f":"WINEP_Schemes!H27","v":0},{"$f":"WINEP_Schemes!J27","v":1},{"$f":"WINEP_Schemes!I27","v":4.5049999999999999},{"$f":"WINEP_Schemes!K27","v":1},{"$f":"WINEP_Schemes!L27","v":1},{"$f":"WINEP_Schemes!M27","v":"WWN+"},{"$f":"WINEP_Schemes!N27","v":1},4.5049999999999999,4.5049999999999999,0,{"$f":" IF($M28 = R$9, $Q28, 0)","v":0},0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C28","v":"NEA00117"},{"$f":"WINEP_Schemes!D28","v":"7NW200112"},{"$f":"WINEP_Schemes!E28","v":"Hustledown STW (CIP2 T1)"},{"$f":"WINEP_Schemes!F28","v":"£ million"},{"$f":"WINEP_Schemes!G28","v":1},{"$f":"WINEP_Schemes!H28","v":0},{"$f":"WINEP_Schemes!J28","v":1},{"$f":"WINEP_Schemes!I28","v":0},{"$f":"WINEP_Schemes!K28","v":1},{"$f":"WINEP_Schemes!L28","v":1},{"$f":"WINEP_Schemes!M28","v":"WWN+"},{"$f":"WINEP_Schemes!N28","v":1},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C29","v":"NEA00711"},{"$f":"WINEP_Schemes!D29","v":"7NW100013"},{"$f":"WINEP_Schemes!E29","v":"Ireshope - Wham pasture MM1. MM7 \nBurnhope res supply"},{"$f":"WINEP_Schemes!F29","v":"£ million"},{"$f":"WINEP_Schemes!G29","v":1},{"$f":"WINEP_Schemes!H29","v":0},{"$f":"WINEP_Schemes!J29","v":1},{"$f":"WINEP_Schemes!I29","v":0.17599999999999999},{"$f":"WINEP_Schemes!K29","v":1},{"$f":"WINEP_Schemes!L29","v":1},{"$f":"WINEP_Schemes!M29","v":"WR"},{"$f":"WINEP_Schemes!N29","v":1},0.17599999999999999,0.17599999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C30","v":"NEA00712"},{"$f":"WINEP_Schemes!D30","v":"7NW100014"},{"$f":"WINEP_Schemes!E30","v":"Ireshope Burn - Greenwell Crags - MM1, MM7\nBurnhope res supply\n"},{"$f":"WINEP_Schemes!F30","v":"£ million"},{"$f":"WINEP_Schemes!G30","v":1},{"$f":"WINEP_Schemes!H30","v":0},{"$f":"WINEP_Schemes!J30","v":1},{"$f":"WINEP_Schemes!I30","v":0.17599999999999999},{"$f":"WINEP_Schemes!K30","v":1},{"$f":"WINEP_Schemes!L30","v":1},{"$f":"WINEP_Schemes!M30","v":"WR"},{"$f":"WINEP_Schemes!N30","v":1},0.17599999999999999,0.17599999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C31","v":"NEA00466"},{"$f":"WINEP_Schemes!D31","v":"7NW200461"},{"$f":"WINEP_Schemes!E31","v":"Kelloe"},{"$f":"WINEP_Schemes!F31","v":"£ million"},{"$f":"WINEP_Schemes!G31","v":1},{"$f":"WINEP_Schemes!H31","v":0},{"$f":"WINEP_Schemes!J31","v":1},{"$f":"WINEP_Schemes!I31","v":2.169},{"$f":"WINEP_Schemes!K31","v":1},{"$f":"WINEP_Schemes!L31","v":1},{"$f":"WINEP_Schemes!M31","v":"WWN+"},{"$f":"WINEP_Schemes!N31","v":1},2.169,2.169,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C32","v":"NEA00468"},{"$f":"WINEP_Schemes!D32","v":"7NW200463"},{"$f":"WINEP_Schemes!E32","v":"Kirklevington STW"},{"$f":"WINEP_Schemes!F32","v":"£ million"},{"$f":"WINEP_Schemes!G32","v":1},{"$f":"WINEP_Schemes!H32","v":0},{"$f":"WINEP_Schemes!J32","v":1},{"$f":"WINEP_Schemes!I32","v":3.1019999999999999},{"$f":"WINEP_Schemes!K32","v":1},{"$f":"WINEP_Schemes!L32","v":1},{"$f":"WINEP_Schemes!M32","v":"WWN+"},{"$f":"WINEP_Schemes!N32","v":1},3.1019999999999999,3.1019999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C33","v":"NEA00469"},{"$f":"WINEP_Schemes!D33","v":"7NW200464"},{"$f":"WINEP_Schemes!E33","v":"Knitsley"},{"$f":"WINEP_Schemes!F33","v":"£ million"},{"$f":"WINEP_Schemes!G33","v":1},{"$f":"WINEP_Schemes!H33","v":0},{"$f":"WINEP_Schemes!J33","v":1},{"$f":"WINEP_Schemes!I33","v":3.6219999999999999},{"$f":"WINEP_Schemes!K33","v":1},{"$f":"WINEP_Schemes!L33","v":1},{"$f":"WINEP_Schemes!M33","v":"WWN+"},{"$f":"WINEP_Schemes!N33","v":1},3.6219999999999999,3.6219999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C34","v":"NEA00470"},{"$f":"WINEP_Schemes!D34","v":"7NW200465"},{"$f":"WINEP_Schemes!E34","v":"Lanchester"},{"$f":"WINEP_Schemes!F34","v":"£ million"},{"$f":"WINEP_Schemes!G34","v":1},{"$f":"WINEP_Schemes!H34","v":0},{"$f":"WINEP_Schemes!J34","v":1},{"$f":"WINEP_Schemes!I34","v":4.3250000000000002},{"$f":"WINEP_Schemes!K34","v":1},{"$f":"WINEP_Schemes!L34","v":1},{"$f":"WINEP_Schemes!M34","v":"WWN+"},{"$f":"WINEP_Schemes!N34","v":1},4.3250000000000002,4.3250000000000002,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C35","v":"NEA00477"},{"$f":"WINEP_Schemes!D35","v":"7NW200472"},{"$f":"WINEP_Schemes!E35","v":"Longnewton"},{"$f":"WINEP_Schemes!F35","v":"£ million"},{"$f":"WINEP_Schemes!G35","v":1},{"$f":"WINEP_Schemes!H35","v":0},{"$f":"WINEP_Schemes!J35","v":1},{"$f":"WINEP_Schemes!I35","v":3.06},{"$f":"WINEP_Schemes!K35","v":1},{"$f":"WINEP_Schemes!L35","v":1},{"$f":"WINEP_Schemes!M35","v":"WWN+"},{"$f":"WINEP_Schemes!N35","v":1},3.06,3.06,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C36","v":"NEA00713"},{"$f":"WINEP_Schemes!D36","v":"7NW100002"},{"$f":"WINEP_Schemes!E36","v":"Lune - Grassholme Res Dam wall -  continue  AMP 6 adaptive management trial putting seasonality to compensation release then implement end of AMP 7 - MM5, MM2, MM7 amd MM8"},{"$f":"WINEP_Schemes!F36","v":"£ million"},{"$f":"WINEP_Schemes!G36","v":1},{"$f":"WINEP_Schemes!H36","v":0},{"$f":"WINEP_Schemes!J36","v":1},{"$f":"WINEP_Schemes!I36","v":8.3000000000000004E-2},{"$f":"WINEP_Schemes!K36","v":1},{"$f":"WINEP_Schemes!L36","v":1},{"$f":"WINEP_Schemes!M36","v":"WR"},{"$f":"WINEP_Schemes!N36","v":1},8.3000000000000004E-2,8.3000000000000004E-2,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C37","v":"NEA00499"},{"$f":"WINEP_Schemes!D37","v":"7NW200494"},{"$f":"WINEP_Schemes!E37","v":"New Moors"},{"$f":"WINEP_Schemes!F37","v":"£ million"},{"$f":"WINEP_Schemes!G37","v":1},{"$f":"WINEP_Schemes!H37","v":0},{"$f":"WINEP_Schemes!J37","v":1},{"$f":"WINEP_Schemes!I37","v":3.5510000000000002},{"$f":"WINEP_Schemes!K37","v":1},{"$f":"WINEP_Schemes!L37","v":1},{"$f":"WINEP_Schemes!M37","v":"WWN+"},{"$f":"WINEP_Schemes!N37","v":1},3.5510000000000002,3.5510000000000002,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C38","v":"NEA00512"},{"$f":"WINEP_Schemes!D38","v":"7NW200507"},{"$f":"WINEP_Schemes!E38","v":"Pittington"},{"$f":"WINEP_Schemes!F38","v":"£ million"},{"$f":"WINEP_Schemes!G38","v":1},{"$f":"WINEP_Schemes!H38","v":0},{"$f":"WINEP_Schemes!J38","v":1},{"$f":"WINEP_Schemes!I38","v":3.1019999999999999},{"$f":"WINEP_Schemes!K38","v":1},{"$f":"WINEP_Schemes!L38","v":1},{"$f":"WINEP_Schemes!M38","v":"WWN+"},{"$f":"WINEP_Schemes!N38","v":1},3.1019999999999999,3.1019999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C39","v":"NEA00513"},{"$f":"WINEP_Schemes!D39","v":"7NW200508"},{"$f":"WINEP_Schemes!E39","v":"Pity Me"},{"$f":"WINEP_Schemes!F39","v":"£ million"},{"$f":"WINEP_Schemes!G39","v":1},{"$f":"WINEP_Schemes!H39","v":0},{"$f":"WINEP_Schemes!J39","v":1},{"$f":"WINEP_Schemes!I39","v":3.9950000000000001},{"$f":"WINEP_Schemes!K39","v":1},{"$f":"WINEP_Schemes!L39","v":1},{"$f":"WINEP_Schemes!M39","v":"WWN+"},{"$f":"WINEP_Schemes!N39","v":1},3.9950000000000001,3.9950000000000001,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C40","v":"NEA00514"},{"$f":"WINEP_Schemes!D40","v":"7NW200509"},{"$f":"WINEP_Schemes!E40","v":"Plawsworth"},{"$f":"WINEP_Schemes!F40","v":"£ million"},{"$f":"WINEP_Schemes!G40","v":1},{"$f":"WINEP_Schemes!H40","v":0},{"$f":"WINEP_Schemes!J40","v":1},{"$f":"WINEP_Schemes!I40","v":3.0950000000000002},{"$f":"WINEP_Schemes!K40","v":1},{"$f":"WINEP_Schemes!L40","v":1},{"$f":"WINEP_Schemes!M40","v":"WWN+"},{"$f":"WINEP_Schemes!N40","v":1},3.0950000000000002,3.0950000000000002,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C41","v":"NEA00716"},{"$f":"WINEP_Schemes!D41","v":"7NW10006"},{"$f":"WINEP_Schemes!E41","v":"Pont  - channel d/s of sluice - MM6 and MM7"},{"$f":"WINEP_Schemes!F41","v":"£ million"},{"$f":"WINEP_Schemes!G41","v":1},{"$f":"WINEP_Schemes!H41","v":0},{"$f":"WINEP_Schemes!J41","v":1},{"$f":"WINEP_Schemes!I41","v":0.14899999999999999},{"$f":"WINEP_Schemes!K41","v":1},{"$f":"WINEP_Schemes!L41","v":1},{"$f":"WINEP_Schemes!M41","v":"WR"},{"$f":"WINEP_Schemes!N41","v":1},0.14899999999999999,0.14899999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C42","v":"NEA00717"},{"$f":"WINEP_Schemes!D42","v":"7NW100016"},{"$f":"WINEP_Schemes!E42","v":"River Derwent -  implement outcomes of Adaptive Management trials for end of AMP 7  - MM5"},{"$f":"WINEP_Schemes!F42","v":"£ million"},{"$f":"WINEP_Schemes!G42","v":1},{"$f":"WINEP_Schemes!H42","v":0},{"$f":"WINEP_Schemes!J42","v":1},{"$f":"WINEP_Schemes!I42","v":8.3000000000000004E-2},{"$f":"WINEP_Schemes!K42","v":1},{"$f":"WINEP_Schemes!L42","v":1},{"$f":"WINEP_Schemes!M42","v":"WR"},{"$f":"WINEP_Schemes!N42","v":1},8.3000000000000004E-2,8.3000000000000004E-2,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C43","v":"NEA00526"},{"$f":"WINEP_Schemes!D43","v":"7NW200521"},{"$f":"WINEP_Schemes!E43","v":"Sacriston"},{"$f":"WINEP_Schemes!F43","v":"£ million"},{"$f":"WINEP_Schemes!G43","v":1},{"$f":"WINEP_Schemes!H43","v":0},{"$f":"WINEP_Schemes!J43","v":1},{"$f":"WINEP_Schemes!I43","v":4.0019999999999998},{"$f":"WINEP_Schemes!K43","v":1},{"$f":"WINEP_Schemes!L43","v":1},{"$f":"WINEP_Schemes!M43","v":"WWN+"},{"$f":"WINEP_Schemes!N43","v":1},4.0019999999999998,4.0019999999999998,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C44","v":"NEA00529"},{"$f":"WINEP_Schemes!D44","v":"7NW200524"},{"$f":"WINEP_Schemes!E44","v":"Sedgefield"},{"$f":"WINEP_Schemes!F44","v":"£ million"},{"$f":"WINEP_Schemes!G44","v":1},{"$f":"WINEP_Schemes!H44","v":0},{"$f":"WINEP_Schemes!J44","v":1},{"$f":"WINEP_Schemes!I44","v":3.5640000000000001},{"$f":"WINEP_Schemes!K44","v":1},{"$f":"WINEP_Schemes!L44","v":1},{"$f":"WINEP_Schemes!M44","v":"WWN+"},{"$f":"WINEP_Schemes!N44","v":1},3.5640000000000001,3.5640000000000001,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C45","v":"NEA00530"},{"$f":"WINEP_Schemes!D45","v":"7NW200525"},{"$f":"WINEP_Schemes!E45","v":"Sedgeletch"},{"$f":"WINEP_Schemes!F45","v":"£ million"},{"$f":"WINEP_Schemes!G45","v":1},{"$f":"WINEP_Schemes!H45","v":0},{"$f":"WINEP_Schemes!J45","v":1},{"$f":"WINEP_Schemes!I45","v":4.6680000000000001},{"$f":"WINEP_Schemes!K45","v":1},{"$f":"WINEP_Schemes!L45","v":1},{"$f":"WINEP_Schemes!M45","v":"WWN+"},{"$f":"WINEP_Schemes!N45","v":1},4.6680000000000001,4.6680000000000001,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C46","v":"NEA00532"},{"$f":"WINEP_Schemes!D46","v":"7NW200527"},{"$f":"WINEP_Schemes!E46","v":"Sherburn"},{"$f":"WINEP_Schemes!F46","v":"£ million"},{"$f":"WINEP_Schemes!G46","v":1},{"$f":"WINEP_Schemes!H46","v":0},{"$f":"WINEP_Schemes!J46","v":1},{"$f":"WINEP_Schemes!I46","v":3.3490000000000002},{"$f":"WINEP_Schemes!K46","v":1},{"$f":"WINEP_Schemes!L46","v":1},{"$f":"WINEP_Schemes!M46","v":"WWN+"},{"$f":"WINEP_Schemes!N46","v":1},3.3490000000000002,3.3490000000000002,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C47","v":"NEA00536"},{"$f":"WINEP_Schemes!D47","v":"7NW200531"},{"$f":"WINEP_Schemes!E47","v":"Slaley - in combination effect with De Vere Hotel"},{"$f":"WINEP_Schemes!F47","v":"£ million"},{"$f":"WINEP_Schemes!G47","v":1},{"$f":"WINEP_Schemes!H47","v":0},{"$f":"WINEP_Schemes!J47","v":1},{"$f":"WINEP_Schemes!I47","v":1.8049999999999999},{"$f":"WINEP_Schemes!K47","v":1},{"$f":"WINEP_Schemes!L47","v":1},{"$f":"WINEP_Schemes!M47","v":"WWN+"},{"$f":"WINEP_Schemes!N47","v":1},1.8049999999999999,1.8049999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C48","v":"NEA00720"},{"$f":"WINEP_Schemes!D48","v":"7NW100017"},{"$f":"WINEP_Schemes!E48","v":"Smiddy Shaw and Hisehope reservoirs Surface Water Transfer , MM5, MM7 and MM8"},{"$f":"WINEP_Schemes!F48","v":"£ million"},{"$f":"WINEP_Schemes!G48","v":1},{"$f":"WINEP_Schemes!H48","v":0},{"$f":"WINEP_Schemes!J48","v":1},{"$f":"WINEP_Schemes!I48","v":8.3000000000000004E-2},{"$f":"WINEP_Schemes!K48","v":1},{"$f":"WINEP_Schemes!L48","v":1},{"$f":"WINEP_Schemes!M48","v":"WR"},{"$f":"WINEP_Schemes!N48","v":1},8.3000000000000004E-2,8.3000000000000004E-2,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C49","v":"NEA00563"},{"$f":"WINEP_Schemes!D49","v":"7NW200556"},{"$f":"WINEP_Schemes!E49","v":"Teeside Airport"},{"$f":"WINEP_Schemes!F49","v":"£ million"},{"$f":"WINEP_Schemes!G49","v":1},{"$f":"WINEP_Schemes!H49","v":0},{"$f":"WINEP_Schemes!J49","v":1},{"$f":"WINEP_Schemes!I49","v":3.8839999999999999},{"$f":"WINEP_Schemes!K49","v":1},{"$f":"WINEP_Schemes!L49","v":1},{"$f":"WINEP_Schemes!M49","v":"WWN+"},{"$f":"WINEP_Schemes!N49","v":1},3.8839999999999999,3.8839999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C50","v":"NEA00575"},{"$f":"WINEP_Schemes!D50","v":"7NW200568"},{"$f":"WINEP_Schemes!E50","v":"Trimdon"},{"$f":"WINEP_Schemes!F50","v":"£ million"},{"$f":"WINEP_Schemes!G50","v":1},{"$f":"WINEP_Schemes!H50","v":0},{"$f":"WINEP_Schemes!J50","v":1},{"$f":"WINEP_Schemes!I50","v":4.2649999999999997},{"$f":"WINEP_Schemes!K50","v":1},{"$f":"WINEP_Schemes!L50","v":1},{"$f":"WINEP_Schemes!M50","v":"WWN+"},{"$f":"WINEP_Schemes!N50","v":1},4.2649999999999997,4.2649999999999997,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C51","v":"NEA00722"},{"$f":"WINEP_Schemes!D51","v":"7NW100003"},{"$f":"WINEP_Schemes!E51","v":"Waskerley Res -  d/s dam wall -  implement outcomes of Adaptive Management trials for end of AMP 7 - MM5, plus  MM1, MM2, MM4, MM8"},{"$f":"WINEP_Schemes!F51","v":"£ million"},{"$f":"WINEP_Schemes!G51","v":1},{"$f":"WINEP_Schemes!H51","v":0},{"$f":"WINEP_Schemes!J51","v":1},{"$f":"WINEP_Schemes!I51","v":8.3000000000000004E-2},{"$f":"WINEP_Schemes!K51","v":1},{"$f":"WINEP_Schemes!L51","v":1},{"$f":"WINEP_Schemes!M51","v":"WR"},{"$f":"WINEP_Schemes!N51","v":1},8.3000000000000004E-2,8.3000000000000004E-2,0,{"$f":" IF($M52 = R$9, $Q52, 0)","v":0},0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C52","v":"NEA00723"},{"$f":"WINEP_Schemes!D52","v":"7NW100012"},{"$f":"WINEP_Schemes!E52","v":"Wear Pipe crossing St Johns Chapel -fish passage MM1"},{"$f":"WINEP_Schemes!F52","v":"£ million"},{"$f":"WINEP_Schemes!G52","v":1},{"$f":"WINEP_Schemes!H52","v":0},{"$f":"WINEP_Schemes!J52","v":1},{"$f":"WINEP_Schemes!I52","v":0.17599999999999999},{"$f":"WINEP_Schemes!K52","v":1},{"$f":"WINEP_Schemes!L52","v":1},{"$f":"WINEP_Schemes!M52","v":"WR"},{"$f":"WINEP_Schemes!N52","v":1},{"$f":" I53 * J53 * G53","v":0.17599999999999999},{"$f":" N53 * O53","v":0.17599999999999999},{"$f":" IF(L53 = 0, P53, (N53 - 1) * O53)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C53","v":"NEA00590"},{"$f":"WINEP_Schemes!D53","v":"7NW200583"},{"$f":"WINEP_Schemes!E53","v":"Witton Gilbert"},{"$f":"WINEP_Schemes!F53","v":"£ million"},{"$f":"WINEP_Schemes!G53","v":1},{"$f":"WINEP_Schemes!H53","v":0},{"$f":"WINEP_Schemes!J53","v":1},{"$f":"WINEP_Schemes!I53","v":2.7240000000000002},{"$f":"WINEP_Schemes!K53","v":1},{"$f":"WINEP_Schemes!L53","v":1},{"$f":"WINEP_Schemes!M53","v":"WWN+"},{"$f":"WINEP_Schemes!N53","v":1},{"$f":" I54 * J54 * G54","v":2.7240000000000002},{"$f":" N54 * O54","v":2.7240000000000002},{"$f":" IF(L54 = 0, P54, (N54 - 1) * O54)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C54","v":0},{"$f":"WINEP_Schemes!D54","v":0},{"$f":"WINEP_Schemes!E54","v":0},{"$f":"WINEP_Schemes!F54","v":0},{"$f":"WINEP_Schemes!G54","v":0},{"$f":"WINEP_Schemes!H54","v":0},{"$f":"WINEP_Schemes!J54","v":0},{"$f":"WINEP_Schemes!I54","v":0},{"$f":"WINEP_Schemes!K54","v":0},{"$f":"WINEP_Schemes!L54","v":0},{"$f":"WINEP_Schemes!M54","v":0},{"$f":"WINEP_Schemes!N54","v":0},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C55","v":0},{"$f":"WINEP_Schemes!D55","v":0},{"$f":"WINEP_Schemes!E55","v":0},{"$f":"WINEP_Schemes!F55","v":0},{"$f":"WINEP_Schemes!G55","v":0},{"$f":"WINEP_Schemes!H55","v":0},{"$f":"WINEP_Schemes!J55","v":0},{"$f":"WINEP_Schemes!I55","v":0},{"$f":"WINEP_Schemes!K55","v":0},{"$f":"WINEP_Schemes!L55","v":0},{"$f":"WINEP_Schemes!M55","v":0},{"$f":"WINEP_Schemes!N55","v":0},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C56","v":0},{"$f":"WINEP_Schemes!D56","v":0},{"$f":"WINEP_Schemes!E56","v":0},{"$f":"WINEP_Schemes!F56","v":0},{"$f":"WINEP_Schemes!G56","v":0},{"$f":"WINEP_Schemes!H56","v":0},{"$f":"WINEP_Schemes!J56","v":0},{"$f":"WINEP_Schemes!I56","v":0},{"$f":"WINEP_Schemes!K56","v":0},{"$f":"WINEP_Schemes!L56","v":0},{"$f":"WINEP_Schemes!M56","v":0},{"$f":"WINEP_Schemes!N56","v":0},0,0,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C57","v":0},{"$f":"WINEP_Schemes!D57","v":0},{"$f":"WINEP_Schemes!E57","v":0},{"$f":"WINEP_Schemes!F57","v":0},{"$f":"WINEP_Schemes!G57","v":0},{"$f":"WINEP_Schemes!H57","v":0},{"$f":"WINEP_Schemes!J57","v":0},{"$f":"WINEP_Schemes!I57","v":0},{"$f":"WINEP_Schemes!K57","v":0},{"$f":"WINEP_Schemes!L57","v":0},{"$f":"WINEP_Schemes!M57","v":0},{"$f":"WINEP_Schemes!N57","v":0},0,0,0,0,0,0,0,0]
[]
[]
["EXPAND OR REDUCE THE BLOCK ABOVE TO INCLUDE ALL SCHEMES ON THE INPUT SHEET"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q11:Q58)","v":-1.071},{"$f":"SUM(R11:R58)","v":-1.071},0,0,0,0]
[null,"Check the total WINEP reconciliation against the sum of the price control totals"]
[]
[null,null,null,null,"Total WINEP Reconciliation",{"$f":" Q63","v":-1.071},"£m"]
[null,null,null,null,"Sum of the WINEP Reconciliation by price control",{"$f":" SUM(R63:V63)","v":-1.071},"£m"]
[]
[null,null,null,null,"Price Control Reconciliation vs Total Reconciliation - check",{"$f":" IF( F67 - F66 > Chk_Tol, 1, 0)","v":0},"check"]
[]
[null,"Total WINEP reconciliation for each price control"]
[]
[null,null,null,null,"Total Final Reconciliation, water resources",{"$f":" R63","v":-1.071},"£m"]
[null,null,null,null,"Total Final Reconciliation, water network",{"$f":" S63","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, wastewater network",{"$f":" T63","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, bioresources",{"$f":" U63","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, dummy",{"$f":" V63","v":0},"£m"]
[]
[]
["End of sheet"]

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

{"sheet":"Annual_Outputs","index":13,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Annual_Outputs"}]
[null,null,null,null,{"$f":"Time!E25","v":"Model period ending"},{"$f":"Check!F2","v":0},"Checks",null,null,{"$f":" Time!J$25","v":"2019-03-31"},{"$f":" Time!K$25","v":"2020-03-31"},{"$f":" Time!L$25","v":"2021-03-31"},{"$f":" Time!M$25","v":"2022-03-31"},{"$f":" Time!N$25","v":"2023-03-31"},{"$f":" Time!O$25","v":"2024-03-31"},{"$f":" Time!P$25","v":"2025-03-31"}]
[null,null,null,null,{"$f":"Time!E107","v":"Timeline label"},{"$f":"Check!F3","v":3},"Track chgs",null,null,{"$f":" Time!J$107","v":"Pre-Fcst"},{"$f":" Time!K$107","v":"Pre-Fcst"},{"$f":" Time!L$107","v":"Forecast"},{"$f":" Time!M$107","v":"Forecast"},{"$f":" Time!N$107","v":"Forecast"},{"$f":" Time!O$107","v":"Forecast"},{"$f":" Time!P$107","v":"Forecast"}]
[null,null,null,null,{"$f":"Time!E130","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$130","v":2019},{"$f":" Time!K$130","v":2020},{"$f":" Time!L$130","v":2021},{"$f":" Time!M$130","v":2022},{"$f":" Time!N$130","v":2023},{"$f":" Time!O$130","v":2024},{"$f":" Time!P$130","v":2025}]
[null,null,null,null,{"$f":"Time!E5","v":"Model column counter"},"Total","Unit",null,null,{"$f":" Time!I$10","v":0},{"$f":" Time!J$10","v":1},{"$f":" Time!K$10","v":2},{"$f":" Time!L$10","v":3},{"$f":" Time!M$10","v":4},{"$f":" Time!N$10","v":5},{"$f":" Time!O$10","v":6}]
[]
["ANNUAL ALLOWED COST"]
[]
[null,"WINEP reconciliation profiled across final 3 years of period"]
[]
[null,null,null,null,{"$f":"WINEP_Allowance!E73","v":"Total Final Reconciliation, water resources"},{"$f":"WINEP_Allowance!F73","v":-1.071},{"$f":"WINEP_Allowance!G73","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E74","v":"Total Final Reconciliation, water network"},{"$f":"WINEP_Allowance!F74","v":0},{"$f":"WINEP_Allowance!G74","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E75","v":"Total Final Reconciliation, wastewater network"},{"$f":"WINEP_Allowance!F75","v":0},{"$f":"WINEP_Allowance!G75","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E76","v":"Total Final Reconciliation, bioresources"},{"$f":"WINEP_Allowance!F76","v":0},{"$f":"WINEP_Allowance!G76","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E77","v":"Total Final Reconciliation, dummy"},{"$f":"WINEP_Allowance!F77","v":0},{"$f":"WINEP_Allowance!G77","v":"£m"}]
[]
[null,null,null,null,{"$f":" Time!E$93","v":"Start of adjustment profiling flag"},{"$f":" Time!F$93","v":0},{"$f":" Time!G$93","v":"counter"},{"$f":" Time!H$93","v":3},{"$f":" Time!I$93","v":0},{"$f":" Time!J$93","v":0},{"$f":" Time!K$93","v":0},{"$f":" Time!L$93","v":0},{"$f":" Time!M$93","v":0},{"$f":" Time!N$93","v":1},{"$f":" Time!O$93","v":1},{"$f":" Time!P$93","v":1}]
[]
[null,null,null,null,"Total Final Reconciliation - profiled, water resources",null,"£m",{"$f":" SUM(J19:P19)","v":-1.071},null,{"$f":" IF( J$17 = 1, $F11 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F11 / 3, 0)","v":-0.35699999999999998},{"$f":" IF( O$17 = 1, $F11 / 3, 0)","v":-0.35699999999999998},-0.35699999999999998]
[null,null,null,null,"Total Final Reconciliation - profiled, water network",null,"£m",{"$f":" SUM(J20:P20)","v":0},null,{"$f":" IF( J$17 = 1, $F12 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F12 / 3, 0)","v":0},0,0]
[null,null,null,null,"Total Final Reconciliation - profiled, wastewater network",null,"£m",0,null,{"$f":" IF( J$17 = 1, $F13 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F13 / 3, 0)","v":0},0,0]
[null,null,null,null,"Total Final Reconciliation - profiled, bioresources",null,"£m",0,null,{"$f":" IF( J$17 = 1, $F14 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F14 / 3, 0)","v":0},0,0]
[null,null,null,null,"Total Final Reconciliation - profiled, dummy",null,"£m",0,null,{"$f":" IF( J$17 = 1, $F15 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F15 / 3, 0)","v":0},0,0]
[]
[null,null,"WINEP reconciliation for cost reconciliation model"]
[null,null,null,null,"WINEP Reconciliation, water resources - without adjustment for time value of money",{"$f":"F19","v":0},"£m",-1.071,0,0,0,0,0,-0.35699999999999998,-0.35699999999999998,-0.35699999999999998]
[null,null,null,null,"WINEP Reconciliation, water network - without adjustment for time value of money",{"$f":"F20","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"WINEP Reconciliation, wastewater network - without adjustment for time value of money",{"$f":"F21","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"WINEP Reconciliation, bioresources - without adjustment for time value of money",{"$f":"F22","v":0},"£m",0,0,0,0,0,0,0,0,0]
[null,null,null,null,"WINEP Reconciliation, dummy - without adjustment for time value of money",{"$f":"F23","v":0},"£m",0,0,0,0,0,0,0,0,0]
[]
[null,"WINEP reconciliation adjusted for time value of money"]
[]
[null,null,null,null,{"$f":" InpActive!E$33","v":"Financing cost index"},{"$f":" InpActive!F$33","v":0},{"$f":" InpActive!G$33","v":"Index"},null,null,{"$f":" InpActive!J$33","v":0},{"$f":" InpActive!K$33","v":0},{"$f":" InpActive!L$33","v":4},{"$f":" InpActive!M$33","v":3},{"$f":" InpActive!N$33","v":2},{"$f":" InpActive!O$33","v":1},{"$f":" InpActive!P$33","v":0}]
[null,null,null,null,{"$f":" InpActive!E$35","v":"Financing Cost"},{"$f":" InpActive!F$35","v":2.92E-2},{"$f":" InpActive!G$35","v":"%"}]
[null,null,null,null,"Time value of money factor",null,"Factor",null,null,{"$f":"(1+$F35) ^ J$34","v":1},{"$f":"(1+$F35) ^ K$34","v":1},{"$f":"(1+$F35) ^ L$34","v":1.122016155346969},1.0901828170879997,{"$f":"(1+$F35) ^ N$34","v":1.0592526399999997},{"$f":"(1+$F35) ^ O$34","v":1.0291999999999999},{"$f":"(1+$F35) ^ P$34","v":1}]
[]
[null,null,null,null,{"$f":" E26","v":"WINEP Reconciliation, water resources - without adjustment for time value of money"},{"$f":" F26","v":0},{"$f":" G26","v":"£m"},{"$f":" H26","v":-1.071},0,{"$f":" J26","v":0},0,0,0,-0.35699999999999998,-0.35699999999999998,{"$f":" P26","v":-0.35699999999999998}]
[null,null,null,null,{"$f":" E27","v":"WINEP Reconciliation, water network - without adjustment for time value of money"},0,"£m",{"$f":" H27","v":0},0,{"$f":" J27","v":0},0,0,0,0,0,{"$f":" P27","v":0}]
[null,null,null,null,"WINEP Reconciliation, wastewater network - without adjustment for time value of money",0,"£m",{"$f":" H28","v":0},0,{"$f":" J28","v":0},0,0,0,0,0,{"$f":" P28","v":0}]
[null,null,null,null,"WINEP Reconciliation, bioresources - without adjustment for time value of money",0,"£m",{"$f":" H29","v":0},0,{"$f":" J29","v":0},0,0,0,0,0,{"$f":" P29","v":0}]
[null,null,null,null,"WINEP Reconciliation, dummy - without adjustment for time value of money",0,"£m",{"$f":" H30","v":0},0,{"$f":" J30","v":0},0,0,0,0,0,{"$f":" P30","v":0}]
[]
[null,null,null,null,{"$f":" E$36","v":"Time value of money factor"},{"$f":" F$36","v":0},"Factor",0,0,1,1,1.122016155346969,1.0901828170879997,1.0592526399999997,1.0291999999999999,{"$f":" P$36","v":1}]
[]
[null,null,"WINEP reconciliation for PR24 RCV adjustment"]
[null,null,null,null,"WINEP Reconciliation, water resources - adjusted for time value of money",null,"£m",{"$f":" SUM(J47:P47)","v":-1.1025775924799999},null,{"$f":" J38 * J$44","v":0},0,0,0,-0.3781531924799999,-0.36742439999999993,-0.35699999999999998]
[null,null,null,null,"WINEP Reconciliation, water network - adjusted for time value of money",null,"£m",{"$f":" SUM(J48:P48)","v":0},null,{"$f":" J39 * J$44","v":0},0,0,0,{"$f":" N39 * N$44","v":0},0,{"$f":" P39 * P$44","v":0}]
[null,null,null,null,"WINEP Reconciliation, wastewater network - adjusted for time value of money",null,"£m",0,null,{"$f":" J40 * J$44","v":0},0,0,0,{"$f":" N40 * N$44","v":0},0,{"$f":" P40 * P$44","v":0}]
[null,null,null,null,"WINEP Reconciliation, bioresources - adjusted for time value of money",null,"£m",0,null,{"$f":" J41 * J$44","v":0},0,0,0,{"$f":" N41 * N$44","v":0},0,{"$f":" P41 * P$44","v":0}]
[null,null,null,null,"WINEP Reconciliation, dummy - adjusted for time value of money",null,"£m",0,null,{"$f":" J42 * J$44","v":0},0,0,0,{"$f":" N42 * N$44","v":0},0,{"$f":" P42 * P$44","v":0}]
[]
[]
["End of sheet"]

{"sheet":"F_Outputs","index":14,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19FM007_WINEP_Out"]
["Acronym","Reference","Item description","Unit","Model","2022-23","2023-24","2024-25","2020-25"]
[]
[null,"BoN",{"$f":" Annual_Outputs!E26","v":"WINEP Reconciliation, water resources - without adjustment for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N26","v":-0.35699999999999998},{"$f":"Annual_Outputs!O26","v":-0.35699999999999998},{"$f":"Annual_Outputs!P26","v":-0.35699999999999998},{"$f":"Annual_Outputs!H26","v":-1.071}]
[null,"BoN",{"$f":" Annual_Outputs!E27","v":"WINEP Reconciliation, water network - without adjustment for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N27","v":0},{"$f":"Annual_Outputs!O27","v":0},{"$f":"Annual_Outputs!P27","v":0},{"$f":"Annual_Outputs!H27","v":0}]
[null,"BoN",{"$f":" Annual_Outputs!E28","v":"WINEP Reconciliation, wastewater network - without adjustment for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N28","v":0},{"$f":"Annual_Outputs!O28","v":0},{"$f":"Annual_Outputs!P28","v":0},{"$f":"Annual_Outputs!H28","v":0}]
[null,"BoN",{"$f":" Annual_Outputs!E29","v":"WINEP Reconciliation, bioresources - without adjustment for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N29","v":0},{"$f":"Annual_Outputs!O29","v":0},{"$f":"Annual_Outputs!P29","v":0},{"$f":"Annual_Outputs!H29","v":0}]
[null,"BoN",{"$f":" Annual_Outputs!E30","v":"WINEP Reconciliation, dummy - without adjustment for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N30","v":0},{"$f":"Annual_Outputs!O30","v":0},{"$f":"Annual_Outputs!P30","v":0},{"$f":"Annual_Outputs!H30","v":0}]
[null,"BoN",{"$f":"Annual_Outputs!E47","v":"WINEP Reconciliation, water resources - adjusted for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N47","v":-0.3781531924799999},{"$f":"Annual_Outputs!O47","v":-0.36742439999999993},{"$f":"Annual_Outputs!P47","v":-0.35699999999999998},{"$f":"Annual_Outputs!H47","v":-1.1025775924799999}]
[null,"BoN",{"$f":"Annual_Outputs!E48","v":"WINEP Reconciliation, water network - adjusted for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N48","v":0},{"$f":"Annual_Outputs!O48","v":0},{"$f":"Annual_Outputs!P48","v":0},{"$f":"Annual_Outputs!H48","v":0}]
[null,"BoN",{"$f":"Annual_Outputs!E49","v":"WINEP Reconciliation, wastewater network - adjusted for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N49","v":0},{"$f":"Annual_Outputs!O49","v":0},{"$f":"Annual_Outputs!P49","v":0},{"$f":"Annual_Outputs!H49","v":0}]
[null,"BoN",{"$f":"Annual_Outputs!E50","v":"WINEP Reconciliation, bioresources - adjusted for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N50","v":0},{"$f":"Annual_Outputs!O50","v":0},{"$f":"Annual_Outputs!P50","v":0},{"$f":"Annual_Outputs!H50","v":0}]
[null,"BoN",{"$f":"Annual_Outputs!E51","v":"WINEP Reconciliation, dummy - adjusted for time value of money"},"£m","Price Review 2019",{"$f":"Annual_Outputs!N51","v":0},{"$f":"Annual_Outputs!O51","v":0},{"$f":"Annual_Outputs!P51","v":0},{"$f":"Annual_Outputs!H51","v":0}]
[null,"BoN_QA1","WINEP reconciliation model date stamp","text","Price Review 2019",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(), \"dd/mm/yyy hh:mm:ss\"))","v":"[…]21/08/2023 15:21:24"},"[…]21/08/2023 15:21:24","[…]21/08/2023 15:21:24","[…]21/08/2023 15:21:24"]
[null,"BoN_QA2","WINEP reconciliation model time stamp","text","Price Review 2019","[…]21/08/2023 15:21:24","[…]21/08/2023 15:21:24","[…]21/08/2023 15:21:24","[…]21/08/2023 15:21:24"]
[]
[]
["End of sheet"]

{"sheet":"QA >>","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Track","index":16,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Track"},null,null,null,null,null,null,null,null,null,null,null,"do not del col",null,"do not del col"]
[null,null,null,null,null,{"$f":"Check!$F$2","v":0},"Checks",null,null,{"$f":" SUM(J7:J28)","v":3}]
[null,null,null,null,null,{"$f":"J2","v":3},"Track chgs"]
[]
[null,null,null,null,null,null,"Unit",null,null,{"$f":" MATCH($H$6, M6:O6, 0)","v":2},"Difference","Diff %"]
[null,null,null,null,"Comparison column label",null,null,"Nil inputs",null,null,null,null,null,"Nil inputs"]
[null,null,null,null,"[do not delete row]"]
["INPUTS"]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K9) > InpActive!$F$42, 1, 0)","v":0},{"$f":" H9 - INDEX(M9:O9, $J$5)","v":0},{"$f":" IF(ABS(K9) > InpActive!$F$42, IF(INDEX(M9:O9, $J$5) = 0, 0, H9 / INDEX(M9:O9, $J$5) - 1), 0)","v":0}]
[null,null,"Inputs",null,null,null,null,null,null,{"$f":" IF(ABS(K10) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K10) > InpActive!$F$42, IF(INDEX(M10:O10, $J$5) = 0, 0, H10 / INDEX(M10:O10, $J$5) - 1), 0)","v":0}]
[null,null,null,null,{"$f":" InpActive!E35","v":"Financing Cost"},null,{"$f":"InpActive!G35","v":"%"},{"$f":"InpActive!F35","v":2.92E-2},null,{"$f":" IF(ABS(K11) > InpActive!$F$42, 1, 0)","v":1},2.92E-2,{"$f":" IF(ABS(K11) > InpActive!$F$42, IF(INDEX(M11:O11, $J$5) = 0, 0, H11 / INDEX(M11:O11, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K12) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K12) > InpActive!$F$42, IF(INDEX(M12:O12, $J$5) = 0, 0, H12 / INDEX(M12:O12, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K13) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K13) > InpActive!$F$42, IF(INDEX(M13:O13, $J$5) = 0, 0, H13 / INDEX(M13:O13, $J$5) - 1), 0)","v":0},null,0]
[null,null,"Outputs",null,null,null,null,null,null,{"$f":" IF(ABS(K14) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K14) > InpActive!$F$42, IF(INDEX(M14:O14, $J$5) = 0, 0, H14 / INDEX(M14:O14, $J$5) - 1), 0)","v":0}]
[null,null,null,null,{"$f":" Annual_Outputs!E26","v":"WINEP Reconciliation, water resources - without adjustment for time value of money"},null,{"$f":" Annual_Outputs!G26","v":"£m"},{"$f":" Annual_Outputs!H26","v":-1.071},null,{"$f":" IF(ABS(K15) > InpActive!$F$42, 1, 0)","v":1},-1.071,{"$f":" IF(ABS(K15) > InpActive!$F$42, IF(INDEX(M15:O15, $J$5) = 0, 0, H15 / INDEX(M15:O15, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":" Annual_Outputs!E27","v":"WINEP Reconciliation, water network - without adjustment for time value of money"},null,{"$f":" Annual_Outputs!G27","v":"£m"},{"$f":" Annual_Outputs!H27","v":0},null,{"$f":" IF(ABS(K16) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K16) > InpActive!$F$42, IF(INDEX(M16:O16, $J$5) = 0, 0, H16 / INDEX(M16:O16, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":" Annual_Outputs!E28","v":"WINEP Reconciliation, wastewater network - without adjustment for time value of money"},null,{"$f":" Annual_Outputs!G28","v":"£m"},{"$f":" Annual_Outputs!H28","v":0},null,{"$f":" IF(ABS(K17) > InpActive!$F$42, 1, 0)","v":0},{"$f":" H17 - INDEX(M17:O17, $J$5)","v":0},{"$f":" IF(ABS(K17) > InpActive!$F$42, IF(INDEX(M17:O17, $J$5) = 0, 0, H17 / INDEX(M17:O17, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":" Annual_Outputs!E29","v":"WINEP Reconciliation, bioresources - without adjustment for time value of money"},null,{"$f":" Annual_Outputs!G29","v":"£m"},{"$f":" Annual_Outputs!H29","v":0},null,{"$f":" IF(ABS(K18) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K18) > InpActive!$F$42, IF(INDEX(M18:O18, $J$5) = 0, 0, H18 / INDEX(M18:O18, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":" Annual_Outputs!E30","v":"WINEP Reconciliation, dummy - without adjustment for time value of money"},null,{"$f":" Annual_Outputs!G30","v":"£m"},{"$f":" Annual_Outputs!H30","v":0},null,{"$f":" IF(ABS(K19) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K19) > InpActive!$F$42, IF(INDEX(M19:O19, $J$5) = 0, 0, H19 / INDEX(M19:O19, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":"Annual_Outputs!E47","v":"WINEP Reconciliation, water resources - adjusted for time value of money"},null,{"$f":"Annual_Outputs!G47","v":"£m"},{"$f":"Annual_Outputs!H47","v":-1.1025775924799999},null,{"$f":" IF(ABS(K20) > InpActive!$F$42, 1, 0)","v":1},{"$f":" H20 - INDEX(M20:O20, $J$5)","v":-1.1025775924799999},{"$f":" IF(ABS(K20) > InpActive!$F$42, IF(INDEX(M20:O20, $J$5) = 0, 0, H20 / INDEX(M20:O20, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":"Annual_Outputs!E48","v":"WINEP Reconciliation, water network - adjusted for time value of money"},null,{"$f":"Annual_Outputs!G48","v":"£m"},{"$f":"Annual_Outputs!H48","v":0},null,{"$f":" IF(ABS(K21) > InpActive!$F$42, 1, 0)","v":0},{"$f":" H21 - INDEX(M21:O21, $J$5)","v":0},{"$f":" IF(ABS(K21) > InpActive!$F$42, IF(INDEX(M21:O21, $J$5) = 0, 0, H21 / INDEX(M21:O21, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":"Annual_Outputs!E49","v":"WINEP Reconciliation, wastewater network - adjusted for time value of money"},null,{"$f":"Annual_Outputs!G49","v":"£m"},{"$f":"Annual_Outputs!H49","v":0},null,{"$f":" IF(ABS(K22) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K22) > InpActive!$F$42, IF(INDEX(M22:O22, $J$5) = 0, 0, H22 / INDEX(M22:O22, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":"Annual_Outputs!E50","v":"WINEP Reconciliation, bioresources - adjusted for time value of money"},null,{"$f":"Annual_Outputs!G50","v":"£m"},{"$f":"Annual_Outputs!H50","v":0},null,{"$f":" IF(ABS(K23) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K23) > InpActive!$F$42, IF(INDEX(M23:O23, $J$5) = 0, 0, H23 / INDEX(M23:O23, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,{"$f":"Annual_Outputs!E51","v":"WINEP Reconciliation, dummy - adjusted for time value of money"},null,{"$f":"Annual_Outputs!G51","v":"£m"},{"$f":"Annual_Outputs!H51","v":0},null,{"$f":" IF(ABS(K24) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K24) > InpActive!$F$42, IF(INDEX(M24:O24, $J$5) = 0, 0, H24 / INDEX(M24:O24, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K25) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K25) > InpActive!$F$42, IF(INDEX(M25:O25, $J$5) = 0, 0, H25 / INDEX(M25:O25, $J$5) - 1), 0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K26) > InpActive!$F$42, 1, 0)","v":0},0,{"$f":" IF(ABS(K26) > InpActive!$F$42, IF(INDEX(M26:O26, $J$5) = 0, 0, H26 / INDEX(M26:O26, $J$5) - 1), 0)","v":0},null,0]
[]
["INFO ONLY"]
[]
[null,null,null,null,"Date",null,null,{"$f":" TODAY()","v":"2023-08-21"}]
[null,null,null,null,"Time",null,null,{"$f":" NOW()","v":45159.639858449074}]
[null,null,null,null,"File",null,null,{"$f":" MID(CELL(\"filename\",$A$1), SEARCH(\"[\", CELL(\"filename\",$A$1)) + 1, SEARCH(\"]\", CELL(\"filename\",$A$1)) - SEARCH(\"[\", CELL(\"filename\",$A$1)) - 1)","v":"NES_WINEP-Reconciliation-Model-Dec-2020 v1n-NES.xlsm"}]
[null,null,null,null,"[do not delete row]",null,null,null,null,"range end"]
[]
[null,null,null,null,"Comment: Key input and logic changes",null,null,null,null,null,null,null,null,"Nil inputs"]
[null,null,null,null,"Comment: Key result changes"]
[]
["End of sheet"]

{"sheet":"Check","index":17,"n_rows":27,"n_cols":7,"rows_kept":27,"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,null,{"$f":"F11","v":0},"Checks"]
[null,null,null,null,null,{"$f":"F24","v":3},"Track chgs"]
[]
[null,null,null,null,null,"Constant","Unit"]
[]
["CHECK SUMMARY"]
[]
["MODEL INTEGRITY CHECKS"]
[]
[null,null,null,null,"Total model integrity checks",{"$f":" SUM(F16:F21)","v":0}]
[]
[null,null,null,null,"[do not delete row]"]
[]
[null,"WINEP RECONCILIATION"]
[null,null,null,null,{"$f":"WINEP_Allowance!E69","v":"Price Control Reconciliation vs Total Reconciliation - check"},{"$f":"WINEP_Allowance!F69","v":0},{"$f":"WINEP_Allowance!G69","v":"check"}]
[]
[null,"TIME"]
[null,null,null,null,{"$f":"Time!E121","v":"Modelling period check"},{"$f":"Time!F121","v":0},{"$f":"Time!G121","v":"check"}]
[]
[]
[null,null,null,null,"[do not delete row]"]
[]
[null,null,null,null,"Total track changes",{"$f":"Track!J2","v":3}]
[]
[]
["End of sheet"]