{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Cover","Documentation >>","User Guide","Model formatting","ToC","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":1},{"$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":"Model formatting","index":3,"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":"ToC","index":4,"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":"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":156,"n_cols":103,"rows_kept":156,"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 - YKY UPDATED AUGUST 2023",null,null,null,null,null,null,null,null,null,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","Comments"]
["YOR00025","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100089","Little Don Catchment Scheme","Langsett Reservoir","GB30432034","Lake","Don Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","2/27/05/032",421253,400361,null,null,"This scheme relates to implementation of Mitigation Measure (MM)5 at Langsett Reservoir which lies in waterbody GB104027057460. The MM assessment determined that MM5 was not in place. The scheme will include: ecological monitoring, civils work to introduce a new compensation release from Langsett Reservoir, post scheme monitoring and licence variation. The wider 'Little Don Catchment Scheme will look at rebalancing flows between Langsett, Midhope and Underbank Reservoirs. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Sustainable","Grid SWZ","X",5,17155,null,"X",null,1.5,null,null,null,null,null,3.05,null,null,null,null,null,null,"This scheme is to introduce a new compensation release and is not a change to the existing abstraction volume.",null,null,80760,3.05,3.05,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00029","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100091","Winscar  Catchment Scheme","Winscar Reservoir","GB30431876","Lake","Don Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","2/27/05/026",415431,402472,null,null,"Winscar Reservoir lies in GB104027057500. The Winscar Catchment Scheme will address MM5. This is likely to be addressed by introducing a compensation release from Winscar Reservoir. The compensation flows from Winscar and Windleden Lower Reservoirs will be assessed together as well as the change to the maintained flow at Dunford Bridge. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","Sustainable","Grid SWZ","X",5,10140,null,"X",null,0,null,null,null,null,null,11.25,null,null,null,null,null,null,"This is a change to the existing compensation release and not a change to the abstraction volume. The sustainability change has been modelled in combination with a change to the maintained flow at Dunford Bridge and the new compensation arrangements at Langsett, Dale Dike and the R. Burn/Leighton. As a result the individual yield loss is zero. ",null,null,80760,11.25,11.25,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00033","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100093","Agden  River Restoration Scheme","Agden Reservoir","GB30432352","Lake","Don Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Land Management/ Habitat Restoration/ Physical Improvement","2024-12-22","Amber","2/27/05/030",425875,392216,null,null,"The Agden River Restoration Scheme will address MM6 downstream of Agden reservoir (which lies in waterbody GB104027057390). The scheme will include ecological monitoring and geomorphological suverys, the input of technical expertise and partnership working to enable the implementation of targeted river restoration measures.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ","X",6,12410,null,"X",null,null,null,null,null,null,null,0.44,null,null,null,null,null,null,null,null,null,80760,0.44,0.44,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00042","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100098","River Burn Catchment Scheme","Burn from Source to Leighton Beck","GB104027069300","River","Ure Middle and Lower",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","2/27/22/209",413395,481150,null,null,"The River Burn Catchment Scheme covers two water bodies. The scheme is likely to include the implementation of a HOF on the River Burn intake to address the water body deficit, a fish pass to address MM4 and to introduce a seasonal compensation release out of Leighton Reservoir to address MM5. It will include ecological monitoring, flow gauging and water qaulity sampling. Licences will varied with new the compensation release and HOF condition,.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",1,"Grid SWZ","X",5,6400,null,null,null,null,0,null,null,null,5,4.84,null,null,null,null,null,null,"Current HOF needs changing to protect ecology and remove flow deficit. The sustainability change has been modelled in combination with a change to the maintained flow at Dunford Bridge, and the new compensation arrangements at Langsett,Winscar and Dale Dike. As a result the individual yield loss is zero. Updated flow classification data has changed this water body from Actual Serious Damage to Risk of Serious Damage. ",null,null,80760,6.49,6.49,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00044","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100098","River Burn Catchment Scheme","Leighton Reservoir","GB30429612","Lake","Ure Middle and Lower",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Sustainability Change","2024-12-22","Amber","2/27/22/210",416256,479051,null,null,"The River Burn Catchment Scheme covers two water bodies. Leighton Reservoir lies in waterbody GB104027069270. The scheme is likely to include the implementation of a HOF on the River Burn intake to address the water body deficit, a fish pass to address MM4 and to introduce a seasonal compensation release out of Leighton Reservoir to address MM5. It will include ecological monitoring, flow gauging and water quality sampling. Licences will  varied with new the compensation release and HOF condition,.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ","X",5,null,null,null,null,null,null,null,null,null,null,1.65,null,null,null,null,null,null,"Change to current compensation release from flat line to seasonal profile. Profiled using existing compensation release 'pot' so no additional resource required. ",null,null,80760,6.49,6.49,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00045","Changed","Yes – alteration made",null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100098","River Burn Catchment Scheme","Burn from Source to Leighton Beck","GB104027069300","River","Ure Middle and Lower",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber","2/27/22/209",413395,481150,null,null,"The River Burn Catchment Scheme covers two water bodies. The scheme is likely to include the implementation of a HOF on the River Burn intake to address the water body deficit, a fish pass to address MM4 and to introduce a seasonal compensation release out of Leighton Reservoir to address MM5. It will include ecological monitoring, flow gauging and water quality sampling. Licences will varied with new the compensation release and HOF condition,.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ","X",4,null,null,null,null,null,null,null,null,null,null,13.56,null,null,null,null,null,null,"The fish pass scheme will be considered along side the flow scheme for the River Burn. ",null,null,80760,6.49,6.49,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00055","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100121","HARROGATE SOUTH/STW","Crimple Beck from Park Beck to River Nidd","GB104027063742","River","Nidd Middle and Lower",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","QR.27/21/0048",437870,451620,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36729.800000000003,null,"0.4mg/l average","4000ug/l Fe 95%ile","9800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.5,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial.  2 kilometres improved from Bad to Moderate and 2.5 kilometres improved from Poor to Moderate status. Total 4.5km in river length improvement.","*",null,276351,4.4529999999999994,4.4529999999999994,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00059","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100125","OWLWOOD (GARFORTH) STW","Lin Dike from Source to River Aire","GB104027062810","River","Aire Lower",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",2225,441750,428790,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39030.800000000003,null,"0.25mg/l average","4000ug/l Fe 95%ile","8801m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 3.3 kilometres improved from Bad to Moderate.","*",null,276351,10.028000000000002,10.028000000000002,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00060","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100126","DRONFIELD/STW","Drone/Whitting from Source to River Rother","GB104027057710","River","Rother and Doe Lea",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","1863",436750,377810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21779,null,"0.3mg/l average","4000ug/l Fe 95%ile","5500m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.8,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 2.7 kilometres improved from Bad to Mod and 4.1 kilometres improved from Poor to Moderate status. Total 6.8km in river length improvement.","*",null,276351,7.8539999999999992,7.8539999999999992,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00062","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100128","DANESMOOR/STW","Rother from Source to Redleadmill Brook","GB104027052280","River","Rother and Doe Lea",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2138",44074,36300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6669.6,null,"0.4mg/l average","4000ug/l Fe 95%ile","1392m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",7.9,null,null,null,null,null,null,"Cost beneficial scheme. 3 kilometres improved from Poor to Good status and 4.2 kilometres improved from Poor to Moderate status and 0.7 kilometres improved from Bad to Moderate. Total 7.9km in river length improvement.","*",null,276351,4.8639999999999999,4.8639999999999999,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00063","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100129","TUPTON/STW","Redleadmill Brook","GB104027057620","River","Rother and Doe Lea",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","3139(SS)",439820,366810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11012,null,"0.25mg/l average","4000ug/l Fe 95%ile","2641m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",7.9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 3 kilometres improved from Poor to Good status and 4.2 kilometres improved from Poor to Moderate status and 0.7 kilometres improved from Bad to Mod. Total 7.9km in river length improvement.","*",null,276351,10.223000000000001,10.223000000000001,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00065","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100131","ACKWORTH/STW","Went from Hoyle Mill Stream to Blowell Drain","GB104027063360","River","Don Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",430,446630,416680,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9301,null,"0.5mg/l average","4000ug/l Fe 95%ile","2331m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",10.1,null,null,null,null,null,null,"Cost beneficial scheme. 8.1 kilometres improved from Poor to Good status and 2 kilometres improved from Poor to Moderate status. Total 10.1km in river length improvement.","*",null,276351,1.5829999999999984,1.5829999999999984,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00066","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100132","CARLETON/NO 2 STW","Went from Hoyle Mill Stream to Blowell Drain","GB104027063360","River","Don Lower",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",381,446370,419260,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6519,null,"0.25mg/l average","2819ug/l Fe 95%ile","1418m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.2,null,null,null,null,null,null,"Cost beneficial scheme. 3.2 kilometres improved from Bad to Moderate","*",null,276351,10.102999999999998,10.102999999999998,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00067","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW100133","NORTON (ASKERN) WwTW","Went from Hoyle Mill Stream to Blowell Drain","GB104027063360","River","Don Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","3816(SS)",454900,416200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9866.2000000000007,null,"0.25mg/l average","4000ug/l Fe 95%ile","4004m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.1,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 8.1 kilometres improved from Poor to Good status and 2 kilometres improved from Poor to Moderate status. ","*",null,276351,13.8,13.8,1,"WWN+","£ per km LORI",0.27635100000000001]
["EMD00773","Changed",null,null,null,"WQ","Humber","East Midlands","Yorkshire Water Service Ltd","7YW200005","BALBY (STW)","Mother Drain from Source to Torne","GB104028058440","River","Isle of Axholme",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","T/83/45405/R",458063,401770,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17202,null,0.25,null,6200,null,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,null,null,null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001]
["EMD00812","Changed",null,null,null,"WQ","Humber","East Midlands","Yorkshire Water Service Ltd","7YW200006","HATFIELD WOODHOUSE (STW)","Hatfield Waste Drain Catchment (trib of Torne/Three Rivers)","GB104028064330","River","Isle of Axholme",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","T/83/45453/R",468570,408164,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,516,null,0.3,"4000 (8000)",103,null,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,null,null,null,2933301,0,0,1,"WWN+","per km LORI",1]
["EMD00813","Changed",null,null,null,"WQ","Humber","East Midlands","Yorkshire Water Service Ltd","7YW200007","HATFIELD WOODHOUSE (STW)","Hatfield Waste Drain Catchment (trib of Torne/Three Rivers)","GB104028064330","River","Isle of Axholme",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","T/83/45453/R",468570,408164,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,516,10,"2 (12)",null,103,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.9,null,null,null,null,null,null,"May relax to 3mg/l if demonstrated that Final Effluent shows a Non Parametric Distribution ",null,null,2933301,0,0,1,"WWN+","per km LORI",1]
["YOR00112","Changed",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200060","Grimwith Sediment Scheme","Barben Beck/River Dibb Catchment (trib of Wharfe)","GB104027064120","River","Wharfe Upper",null,null,null,"WFD_IMP_WRHMWB","Land Management / Physical Improvement",null,null,null,null,"Land Management/ Habitat Restoration/ Physical Improvement","2024-12-22","Amber",null,405740,463906,null,null,"The scheme will address sediment mitigation measures on a stretch of watercourse downstream of Grimwith reservoir where the banks of the river have been straightened and lined with large boulders, preventing natural erosional processes. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ","x","7, 8",null,null,null,null,null,null,null,null,null,null,5.1100000000000003,null,null,null,null,null,null,"Scheme is subject to the outcome of the Grimwith Reservoir flow trial. ",null,null,80760,5.1100000000000003,5.1100000000000003,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00115","Changed","Yes – alteration made",null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200063","Airebank Mills Fish Passage","Aire from Otterburn Beck to Eshton Beck","GB104027063050","River","Aire Upper",null,null,null,"WFD_IMP_FISH",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,394138,453944,null,null,"This scheme has been included to improve fish passage for salmonids up to Gargrave. Gargrave is target for initial salmon recovery on the River Aire. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ",null,null,null,null,null,null,null,null,null,null,null,null,4.5,null,null,null,null,null,"Recovering Salmon River","This scheme is cost beneficial within the bundle of measures. The bundle of measures includes Systergenix weir (not a YWS asset). Once fish passage at Systergenix has been achieved the actual LORI will be 4.5km",null,null,37745,4.5,4.5,1,"WR","£ per km LORI",3.7754000000000003E-2]
["YOR00116","Changed",null,null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200064","Cheesebottom Weir Fish Passage","Don from Scout Dyke to the Little Don","GB104027057490","River","Don Upper",null,null,null,"WFD_IMP_FISH",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,427908,400642,null,null,"This weir is within the second phase for salmon restoration on the River Don (the first phase is almost complete). The fish passage scheme will improve fish passage for Atlantic Salmon and brown trout. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ",null,null,null,null,null,null,null,null,null,null,null,null,9.5,null,null,null,null,null,"Recovering Salmon River"," There is a hydropower site located on the opposite bank which may limit the options for fish passage. ",null,null,37745,9.5,9.5,1,"WR","£ per km LORI",3.7754000000000003E-2]
["YOR00122","Changed",null,null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200070","Cononley Weir Fish Passage","Aire (Eshton Beck to R Worth)","GB104027063033","River","Aire Upper",null,null,null,"WFD_IMP_FISH",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,399495,446773,null,null,"The waterbody is currently failing for mulitiple species and lower densities of brown trout. Addressing fish passage at the site will help to improve the fish status of the waterbody. The site comprises of five small weirs. The scheme will include options appraisal and implementation of a fish passage solution. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ",null,null,null,null,null,null,null,null,null,null,null,null,45.54,null,null,null,null,null,null,null,null,null,37745,45.54,45.54,1,"WR","£ per km LORI",3.7754000000000003E-2]
["YOR00123","Changed","Yes – alteration made",null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200071","Farnley Beck Fish Passage","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMP_FISH",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,425339,433023,null,null,"Scheme to address fish passage. The waterbody is currently failing for mulitiple species and lower densities of brown trout.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.29,null,null,null,null,null,null,null,null,null,37745,3.29,3.29,1,"WR","£ per km LORI",3.7754000000000003E-2]
["YOR00124","Changed","Yes – alteration made",null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200072","Schole Hill Fish Passage","Don from Source to Scout Dyke","GB104027057500","River","Don Upper",null,null,null,"WFD_IMP_WRHMWB",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,422580,403143,null,null,"Scheme to improve fish passage. Site lies downstream of Harden, Windleden and Winscar Reservoirs.WB failing for minor species and to an extent grayling. It is anticipated that a low cost solution will be suitable at this location. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Grid SWZ","x",1,null,null,null,null,null,null,null,null,null,null,0.78,null,null,null,null,null,null,null,null,null,80760,0.78,0.78,1,"WR","£ per km LORI",8.0759999999999998E-2]
["YOR00125","Changed","Yes – alteration made",null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200073","Watson Mill Fish Passage","Ryburn from Booth Dean Clough to R Calder","GB104027062580","River","Calder Middle",null,null,null,"WFD_IMP_FISH",null,null,null,null,null,"Fish Passage","2024-12-22","Amber",null,405809,423222,null,null,"Scheme to improve fish passage. WB failing for minor species. It is anticipated that a low cost solution will be suitable at this location. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94,null,null,null,null,null,null,null,null,null,37745,0.94,0.94,1,"WR","£ per km LORI",3.7754000000000003E-2]
["YOR01523","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200635","SOUTH ELMSALL/STW 6X","Ea Beck from Frickley Beck to the Skell","GB104027063200","River","Don Lower",null,null,null,"WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7507 schedule 4",448250,410650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35231.1,"15mg/l",null,null,"9800m³/d",null,"10,000m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25,null,null,null,null,null,null,"FIS, 10,000m³ storage on storm discharge","*",null,590,10000,10000,1,"WWN+","£ per m3",5.9000000000000003E-4]
["YOR00693","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200637","BENTLEY/STW FE transfer to NGR 458119 405197","Bentley Mill Stream","GB104027057541","River","Don Lower",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Continuous Discharge","2024-12-22","Amber","1978 schedule 1",457130,405720,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20936,null,"1mg/l",null,"5046m³/d",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,null,null,null,null,null,null,"Relocate Bentley STW FE to the R.Don . Proposed 1mg/l would be required if transfer scheme was not able to be completed.This will require feasibility as part of solution delivery which may change the exact discharge location. No changes to to flow or quality conditions. Needed to meet FIS standards. If FE transfer proposal passes CBA then 1mg/l on permit not required.","*",null,2933301,0,0,1,"WWN+","£ per km LORI",2.9333010000000002,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00694","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200638","CLAYTON WEST/STW","Dearne from Bentley Brook to Cawthorne Dyke","GB104027063260","River","Dearne",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Intermittent Discharge","2024-12-22","Amber","3809(SS) / schedule 2",426780,412070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16803.8,"n/a",null,null,null,null,"8,120m³",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0499999999999998,null,null,null,null,null,null,"FIS & 99%ile. Current storage 1120m³, additional storage 7000m³  on the settled storm, total proposed storage 8,120m³. Settled storm discharge point will not change from current NGR under then the FE transfer scheme.","*",null,2933301,0,0,1,"WWN+","£ per km LORI",2.9333010000000002,"Multiple drivers. No LORI to avoid double counting."]
["YOR00696","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200640","Little Don intermittents - Huinself Rd","Little Don from Source to River Don","GB104027057460","River","Don Upper",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA8524",427290,398460,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,000m³",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,"FIS. Storage4000m^3. Provisionally attached to Huinself Road CSO but 4000m³ or equivalent network interention to provide the same water quality benefit to the Little Don.","*",null,590,4000,4000,1,"WWN+","£ per m3",5.9000000000000003E-4]
["YOR01536","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200641","Pudsey intermittents (Farnley Ring Road)","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","C4966",424670,433540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5,000m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Total proposed storage 5,000m³ total. Farnley Ring Road","*",null,590,5000,5000,1,"WWN+","£ per m3",5.9000000000000003E-4]
["YOR00775","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200719","SHERBURN IN ELMET/STW","Upper Fox Drain Catchment ds of Sherburn STW","GB104027063610","River","Ouse Lower Yorkshire",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/24/0162",452920,433420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12214,"11mg/l","1.3mg/l 95%ile",null,"3750m³/d",null,"12mg/l upper tier",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.5,null,null,null,null,null,null,"New proposed limit is 1.3mg/l to improve 4.5km from Moderate to Good.","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00787","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200731","BOLSOVER/STW","Doe Lea from Source to Hawke Brook","GB104027057290","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",1866,445919,370148,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11810.6,"10mg/l","1mg/l 95%ile",null,"1900m³/d",null,"12mg/l upper tier",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4,null,null,null,null,null,null,"Cost beneficial due to No Det scheme.kilometres improved from Poor to Good status","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00793","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200737","CARTHORPE WPC WORKS","Healam Beck from Burniston Bk to River Swale","GB104027068850","River","Swale Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/23/0207",432120,483610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,549,null,"0.5mg/l average","4000ug/l Fe 95%ile","124m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.8,null,null,null,null,null,null,"Cost beneficial scheme. 4.8kilometres improved from Moderate to Good status","*",null,276351,4.83,4.83,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00799","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200743","THORNTON LE BEANS","Otterington Beck catchment (trib of Wiske)","GB104027069450","River","Wiske",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","COPA/2783",439300,490500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190.4,null,"1.5mg/l average","4000ug/l Fe 95%ile","37m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.4,null,null,null,null,null,null,"Cost beneficial scheme.6.4 kilometres improved from Moderate to Good status","*",null,276351,6.4379999999999997,6.4379999999999997,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00804","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200748","Rainton STW","Cundall Beck/Soppa Gutter Catch (trib of Swale)","GB104027068780","River","Swale Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","COPA/2253",437600,474900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,345.6,null,"3mg/l average","4000ug/l Fe 95%ile","109m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",7.8,null,null,null,null,null,null,"Cost beneficial scheme. 7.8 kilometres improved from Moderate to Good status","*",null,276351,1.464,1.464,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00805","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200749","DISHFORTH WPC WORKS","Cundall Beck/Soppa Gutter Catch (trib of Swale)","GB104027068780","River","Swale Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/23/0150",438500,473355,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,594.4,null,"0.5mg/l average","4000ug/l Fe 95%ile","113m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",1.6,null,null,null,null,null,null,"Cost beneficial scheme. 1.6 kilometres improved from Poor to Good status","*",null,276351,7.7649999999999997,7.7649999999999997,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00806","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200750","KIRKBY MALZEARD/STW","Kex Beck and the Laver","GB104027069260","River","Ure Middle and Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/22/0048",424700,474140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1476,null,"1.5mg/l average","4000ug/l Fe 95%ile","442m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9.8000000000000007,null,null,null,null,null,null,"Cost beneficial scheme. 4.8 kilometres improved from Poor to Good status and 5 kilometres improved from Moderate to Good status. Total 9.8km in river length improvement.","*",null,276351,12.117999999999997,12.117999999999997,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00812","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200756","KILLINGHALL STW","Nidd from Burstwith to Oak Beck","GB104027068296","River","Nidd Middle and Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/21/0089",427100,459060,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3470.6,null,"0.5mg/l average","4000ug/l Fe 95%ile","1631m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",2.8,null,null,null,null,null,null,"Cost beneficial scheme.2.8 kilometres improved from Moderate to Good status","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Change is too small Phosphorous change and no LORI associuated"]
["YOR00813","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200757","SHAW MILLS/STW","Thornton Beck Catch (Trib of Nidd)","GB104027063850","River","Nidd Middle and Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/21/0091",427605,461435,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,595.6,null,"1mg/l average","4000ug/l Fe 95%ile","132m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.6,null,null,null,null,null,null,"Cost beneficial scheme.1.3 kilometres improved from Poor to Good status and 5.3 kilometres improved from Moderate to Good status. Total 6.6km in river length improvement.","*",null,276351,29.858000000000011,29.858000000000011,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00833","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200777","DRAUGHTON WPC WORKS","Hambleton Beck/Ings Bk Catch (trib of Wharfe)","GB104027064030","River","Wharfe Middle and Washburn",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/19/0082",404610,453100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,303.8,null,"0.25mg/l average","4000ug/l Fe 95%ile","96m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.5,null,null,null,null,null,null,"Cost beneficial scheme. 3.5 kilometres improved from Moderate to Good status","*",null,276351,3.5189999999999992,3.5189999999999992,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00838","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200782","SHERBURN IN ELMET/STW","Upper Fox Drain Catchment ds of Sherburn STW","GB104027063610","River","Ouse Lower Yorkshire",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/24/0162",452920,433420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12214,null,"0.5mg/l average","2663ug/l Fe 95%ile","3750m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.5,null,null,null,null,null,null,"New proposed P limit pf 0.5mg/l to achieve Moderate. RLI improved is the same as ammonia so moves from Bad to Moderate.","*",null,276351,10.129999999999999,10.129999999999999,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00840","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200784","HAROME/STW","Walmouth Beck from Source to River Riccal","GB104027068210","River","Rye",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/25/0079",465980,482149,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1413.8,null,"0.25mg/l average","4000ug/l Fe 95%ile","755m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",5.4,null,null,null,null,null,null,"Cost beneficial scheme. 5.4 kilometres improved from Poor to Good status","*",null,276351,6.4020000000000001,6.4020000000000001,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00846","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200790","BISHOP WILTON WPC WO","Bishop Wilton Beck Catch (trib of Blackfoss Beck)","GB104027063470","River","Derwent Lower Yorkshire",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/28/0104",479290,454370,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,484,null,"1mg/l average","4000ug/l Fe 95%ile","118m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9.9,null,null,null,null,null,null,"9.9 kilometres improved from Moderate to Good status","*",null,1287218,1,1,1,"WWN+","£ per kgP/day removed",1.287218]
["YOR00847","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200791","POCKLINGTON/STW","Pocklington Beck from Source to Bielby beck","GB104027063480","River","Derwent Lower Yorkshire",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","27/28/0195",480052,447318,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10171,"1mg/l","0.25mg/l average","4000ug/l Fe 95%ile","2797m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9.6,null,null,null,null,null,null,"Cost beneficial scheme.9.6 kilometres improved from Moderate to Good status","*",null,276351,2.17,2.17,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00849","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200793","CROFTON/STW","Oakenshaw Beck from Source to River Calder","GB104027062560","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2207",436290,418470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9343.2000000000007,null,"0.25mg/l average","3774ug/l Fe 95%ile","4546m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.7,null,null,null,null,null,null,"Cost beneficial scheme. 2.8 kilometres improved from Bad to Good status and 0.8 kilometres improved from Poor to Good status. Total 3.7km in river length improvement.","*",null,276351,8.9890000000000008,8.9890000000000008,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00850","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200794","MELTHAM/STW","Mag Brook from Source to River Holme","GB104027063590","River","Colne and Holme",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA6680",411092,411402,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8484.2000000000007,null,"0.4mg/l average","4000ug/l Fe 95%ile","2350m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.7,null,null,null,null,null,null,"Cost beneficial scheme. 3.7 kilometres improved from Poor to Good status","*",null,276351,17.146000000000001,17.146000000000001,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00851","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200795","NEILEY NO 2 STW","Holme from New Mill Dike to R Colne","GB104027063301","River","Colne and Holme",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2255",414628,411578,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20346,null,"0.4mg/l average","4000ug/l Fe 95%ile","7497m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",1.5,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial.1.5 kilometres improved from Poor to Good status","*",null,276351,1.5309999999999988,1.5309999999999988,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00852","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200796","RIPPONDEN WOOD STW","Ryburn from Booth Dean Clough to R Calder","GB104027062580","River","Calder Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E741(SS)",404540,420640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5163.6000000000004,null,"0.5mg/l average","4000ug/l Fe 95%ile","1639m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.9,null,null,null,null,null,null,"Cost beneficial scheme. 3.9 kilometres improved from Poor to Good status","*",null,276351,7.9579999999999993,7.9579999999999993,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00853","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200797","EASTWOOD/STW","Calder from Walsden Water to Colden Water","GB104027062650","River","Calder Upper",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E61",397163,426382,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14727.6,null,"0.5mg/l average","4000ug/l Fe 95%ile","10255m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.4,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.4kilometres improved from Poor to Good status","*",null,276351,1.833000000000002,1.833000000000002,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00854","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200798","REDACRE STW","Calder from Colden Water to Ryburn Confluence","GB104027062641","River","Calder Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E740(SS)",401025,426209,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8547.4,null,"0.5mg/l average","4000ug/l Fe 95%ile","4421m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.4,null,null,null,null,null,null,"Cost beneficial scheme. 6.4 kilometres improved from Poor to Good status","*",null,276351,5.0390000000000015,5.0390000000000015,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00855","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200799","HIGH ROYD NO 2 STW","Luddenden Brook from Source to River Calder","GB104027062770","River","Calder Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","967",405169,423937,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11495.8,null,"0.5mg/l average","4000ug/l Fe 95%ile","6696m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.4,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.4 kilometres improved from Poor to Good status","*",null,276351,1.5399999999999991,1.5399999999999991,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00856","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200800","HALIFAX COPLEY STW","Calder from Ryburn Confluence  to River Colne","GB104027062642","River","Calder Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7510",409224,422301,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167246,null,"0.3mg/l average","4000ug/l Fe 95%ile","57700m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.4,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.4 kilometres improved from Poor to Good status","*",null,276351,12.996000000000006,12.996000000000006,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00857","Changed","Pending – decision not yet taken",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200801","Huddersfield STW Colne Bridge","Calder from Ryburn Confluence to River Colne","GB104027062642","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7409",417820,420440,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237696,null,0.25,"4000ug/l Fe 95%ile","84000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Links to work around Cooper Bridge. "]
["YOR00858","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200802","HUDDERSFIELD STW Cooper Bridge","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7409",418470,420810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56427,null,"0.25mg/l average","4000ug/l Fe 95%ile","20000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,12.022000000000006,12.022000000000006,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00859","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200803","MITCHELL LAITHES WWT","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E15",426460,419490,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,251691.2,null,"0.5mg/l average","4000ug/l Fe 95%ile","85694m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,5.8190000000000026,5.8190000000000026,1,"WWN+","£ per km LORI",0.27635100000000001,"Links up to Dewsbury"]
["YOR00860","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200804","HORBURY (DUDFLEET) STW","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","C4107",430000,417070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,null,"0.5mg/l average","4000ug/l Fe 95%ile","10m3/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,3.3089999999999975,3.3089999999999975,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00861","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200805","CALDER VALE/STW","Calder from River Chald to River Aire","GB104027062632","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","C4106",435070,420410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101008,null,"0.6mg/l average","4000ug/l Fe 95%ile","32000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,6.7109999999999985,6.7109999999999985,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00862","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200806","SMALLEY BIGHT (STANL","Calder from River Chald to River Aire","GB104027062632","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E743(SS)",435280,423900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18957.2,null,"1mg/l average","4000ug/l Fe 95%ile","5300m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,7.8109999999999928,7.8109999999999928,1,"WWN+","£ per km LORI",0.27635100000000001,"Same site as 7YW200942"]
["YOR00863","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200807","NORMANTON/STW (Mill Lane)","Choke Churl Bk from Source to River Calder","GB104027062590","River","Calder Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WA6472",439670,424910,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44569.8,null,"0.8mg/l average","4000ug/l Fe 95%ile","12464m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 6.3 kilometres improved from Poor to Good status","*",null,276351,3.3939999999999912,3.3939999999999912,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00866","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200810","EMBSAY/STW","Haw Beck from Source to Eller beck","GB104027063060","River","Aire Upper",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2583",399880,453010,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1777.4,null,"0.25mg/l average","4000ug/l Fe 95%ile","727m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.2,null,null,null,null,null,null,"Cost beneficial scheme. 3.9 kilometres improved from Poor to Good status and 0.3 kilometres improved from Moderate to Good status. Total 4.2km in river length improvement.","*",null,276351,2.7149999999999981,2.7149999999999981,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00867","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200811","EAST MARTON","Langber Beck from Source to Earby Beck","GB104027063010","River","Aire Upper",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",1850,390970,450550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220.8,null,"4mg/l average","4000ug/l Fe 95%ile","44m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",2,null,null,null,null,null,null,"Cost beneficial scheme. 2 kilometres improved from Moderate to Good status","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Change is too small Phosphorous change and no LORI associated"]
["YOR00872","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200816","KEIGHLEY MARLEY/STW","Aire (R Worth to Gill Beck)","GB104027063034","River","Aire Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7172",409030,441150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90039,null,"0.5mg/l average","4000ug/l Fe 95%ile","28129m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",5.0999999999999996,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 5.1 kilometres improved from Poor to Good status","*",null,276351,6.4589999999999961,6.4589999999999961,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00873","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200817","DOWLEY GAP (BINGLEY)","Aire (R Worth to Gill Beck)","GB104027063034","River","Aire Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",2502,412310,438140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38795.4,null,"0.25mg/l average","4000ug/l Fe 95%ile","11713m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",5.0999999999999996,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 5.1 kilometres improved from Poor to Good status","*",null,276351,9.1550000000000082,9.1550000000000082,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00874","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200818","BRADFORD ESHOLT/NO 2 STW","Aire from Gill Beck (Baildon) to River Calder","GB104027063032","River","Aire Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA6925",418984,438746,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,367696.2,null,"0.5mg/l average","4000ug/l Fe 95%ile","130000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",13.1,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 1.4 kilometres improved from Poor to Moderate status and 11.7 kilometres improved from Poor to Good status. Total 13.1km in river length improvement.","*",null,276351,23.472000000000008,23.472000000000008,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00875","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200819","KNOSTROP WWTW","Wyke Beck from Source to River Aire","GB104027062880","River","Aire Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA6924",433276,432035,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,366809,null,"0.4mg/l average","4000ug/l Fe 95%ile","213600m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",13.1,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 1.4 kilometres improved from Poor to Moderate status and 11.7 kilometres improved from Poor to Good status. Total 13.1km in river length improvement.","*",null,276351,5.593,5.593,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00876","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200820","LEMONROYD STW","Oulton Beck from Source to River Aire","GB104027062680","River","Aire Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7220",438200,428000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35201.199999999997,null,"2mg/l average","4000ug/l Fe 95%ile","7500m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",13.1,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 1.4 kilometres improved from Poor to Moderate status and 11.7 kilometres improved from Poor to Good status. Total 13.1km in river length improvement.","*",null,276351,5.5859999999999985,5.5859999999999985,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00878","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200822","WHELDALE (CASTLEFORD","Aire from River Calder to River Ouse","GB104027062760","River","Aire Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA6659",444640,426680,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34117,null,"3mg/l average","4000ug/l Fe 95%ile","8400m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9.9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 9.9 kilometres improved from Poor to Good status","*",null,276351,5.296999999999997,5.296999999999997,1,"WWN+","£ per km LORI",0.27635100000000001,"Site also known as Castleford. "]
["YOR00879","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200823","SUTTON WWTW","Aire from River Calder to River Ouse","GB104027062760","River","Aire Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",1945,450400,424310,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48826,null,"1mg/l average","4000ug/l Fe 95%ile","11073m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9.9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 9.9 kilometres improved from Poor to Good status","*",null,276351,23.16500000000002,23.16500000000002,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00881","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200825","SOUTH ELMSALL/STW","Ea Beck from Frickley Beck to the Skell","GB104027063200","River","Don Lower",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7507",448390,410640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35231.4,null,"0.3mg/l average","4000ug/l Fe 95%ile","9800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 3.9 kilometres improved from Bad to Moderate and 5.1 kilometres improved from Poor to Good status. Total 9km in river length improvement.","*",null,276351,5.1169999999999991,5.1169999999999991,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00882","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200826","WRANGBROOK STW","The Skell from Source to Ea Beck","GB104027063280","River","Don Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E744",449590,412540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6534.8,null,"0.5mg/l average","4000ug/l Fe 95%ile","1340m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",5.8,null,null,null,null,null,null,"Cost beneficial scheme. 5.8 kilometres improved from Poor to Good status","*",null,276351,8.7759999999999998,8.7759999999999998,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00883","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200827","Adwick Le Street","Ea Beck from the Skell to River Don","GB104027057591","River","Don Lower",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7541",454690,408050,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20133,null,"0.3mg/l average","4000ug/l Fe 95%ile","5400m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 2.4 kilometres improved from Bad to Mod and 1.5 kilometres improved from Poor to Good status. Total 3.9km in river length improvement.","*",null,276351,8.5730000000000004,8.5730000000000004,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00886","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200830","GRIMETHORPE/STW","Grimethorpe Dike from Source to River Dearne","GB104027063180","River","Dearne",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2246",440280,409430,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12973.4,null,"0.25mg/l average","4000ug/l Fe 95%ile","3157m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.7,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 3.7 kilometres improved from Bad to Moderate.","*",null,276351,10.161000000000003,10.161000000000003,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00887","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200831","CLAYTON WEST/STW","Dearne from Source to Bentley Brook","GB104027063220","River","Dearne",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","3809(SS)",426780,412070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16803.8,null,"0.25mg/l average","4000ug/l Fe 95%ile","5748m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",8,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 8 kilometres improved from Poor to Good status","*",null,276351,3.7070000000000007,3.7070000000000007,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00888","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200832","HOYLANDSWAINE/STW","Silkstone Beck from Source to Cawthorne Dyke","GB104027057560","River","Dearne",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2344",426900,405700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,967.2,null,"0.4mg/l average","4000ug/l Fe 95%ile","236m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.7,null,null,null,null,null,null,"Cost beneficial scheme. 3.7 kilometres improved from Poor to Good status","*",null,276351,9.8049999999999997,9.8049999999999997,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00902","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200846","INGBIRCHWORTH STW","Scout Dyke from Source to River Don","GB104027057530","River","Don Upper",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA7365",422717,405548,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,429.8,null,"1mg/l average","4000ug/l Fe 95%ile","102m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",6,null,null,null,null,null,null,"Cost beneficial scheme. 6 kilometres improved from Moderate to Good status","*",null,1287218,1,1,1,"WWN+","£ per kgP/day removed",1.287218]
["YOR00903","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200847","CHEESEBOTTOM STW","Don from Scout Dyke to the Little Don","GB104027057490","River","Don Upper",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2556",427990,401280,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13297.2,null,"0.5mg/l average","4000ug/l Fe 95%ile","4478m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.5,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 4.3 kilometres improved from Moderate to Good status and 1.4 kilometres improved from Poor to Good status and 9.8 kilometres improved from Poor to Moderate status. Total 15.5 km in river length improvement.","*",null,276351,7.7469999999999999,7.7469999999999999,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00904","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200848","STOCKSBRIDGE/STW","Don from Little Don to River Loxley confluence","GB104027057411","River","Don Upper",null,null,null,"WFD_IMPm","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E697(SS)",429150,397500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14718.2,null,"0.5mg/l average","4000ug/l Fe 95%ile","3482m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",15.5,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 4.3 kilometres improved from Moderate to Good status and 1.4 kilometres improved from Poor to Good status and 9.8 kilometres improved from Poor to Moderate status. Total 15.5km in river length improvement.","*",null,276351,23.136999999999979,23.136999999999979,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00906","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200850","BLACKBURN MEADOWS/STW","Don from River Don Works to River Rother","GB104027057413","River","Don Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E25",440520,391930,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,460744,null,"0.3mg/l average","4000ug/l Fe 95%ile","158000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",2.4,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 2.4 kilometres improved from Poor to Good status","*",null,276351,6.5280000000000058,6.5280000000000058,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00913","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200857","Old Whittington (Chesterfield) STW","Rother, Spittal Brook to Doe Lea","GB104027057771","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA6756",439406,374553,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97084.6,null,"0.25mg/l average","4000ug/l Fe 95%ile","29600m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 8.3 kilometres improved from Poor to Good status","*",null,276351,9.2680000000000007,9.2680000000000007,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00914","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200858","STOCKLEY/STW","Doe Lea from Source to Hawke Brook","GB104027057290","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E280",445920,367970,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2673.4,null,"0.5mg/l average","4000ug/l Fe 95%ile","677m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4,null,null,null,null,null,null,"Cost beneficial scheme. 4 kilometres improved from Poor to Good status","*",null,276351,2.3670000000000009,2.3670000000000009,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00915","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200859","BOLSOVER/STW","Doe Lea from Source to Hawke Brook","GB104027057290","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",1866,445919,370148,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11810.6,null,"0.3mg/l average","4000ug/l Fe 95%ile","1900m³/d",null,"8000ug/l  Fe Upper Tier ",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,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 4 kilometres improved from Poor to Good status","*",null,276351,7.7959999999999958,7.7959999999999958,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00916","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200860","STAVELEY/STW","Doe Lea from Hawke Brooke to River Rother","GB104027057301","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","WRA 6647",444380,476610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28138,null,"0.25mg/l average","4000ug/l Fe 95%ile","5730m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",2.9,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 2.9 kilometres improved from Bad to Good status","*",null,276351,12.93399999999999,12.93399999999999,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00917","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200861","WOODHOUSE MILL WwTW","Rother, Doe Lea to Don","GB104027057772","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","3334(SS)",443290,386140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128370,null,"0.9mg/l average","4000ug/l Fe 95%ile","28343m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",8.5,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 8.5 kilometres improved from Poor to Good status","*",null,276351,4.2749999999999986,4.2749999999999986,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00918","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200862","LONG LANE/STW","Ulley Brook from Source to River Rother","GB104027057740","River","Rother and Doe Lea",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","2081",443678,389206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22968,null,"0.5mg/l average","4000ug/l Fe 95%ile","4472m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",4.0999999999999996,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 4.1 kilometres improved from Poor to Good status","*",null,276351,4.2360000000000042,4.2360000000000042,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00919","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200863","ALDWARKE/STW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","C4954",445060,394470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109591,null,"0.7mg/l average","4000ug/l Fe 95%ile","31277m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.8,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 7.8 kilometres improved from Poor to Good status kilometres improved from Poor to Good status","*",null,276351,7.0600000000000023,7.0600000000000023,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00920","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200864","MEXBORO SWINTON/STW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber",2160,446986,399204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16175.2,null,"1mg/l average","4000ug/l Fe 95%ile","4800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",7.8,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 7.8 kilometres improved from Poor to Good status kilometres improved from Poor to Good status","*",null,276351,3.0600000000000023,3.0600000000000023,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00921","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200865","DENABY WTW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E728(SS)",449450,399940,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32166,null,"0.6mg/l average","4000ug/l Fe 95%ile","8199m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",7.8,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. 7.8 kilometres improved from Poor to Good status kilometres improved from Poor to Good status","*",null,276351,13.415999999999983,13.415999999999983,1,"WWN+","£ per km LORI",0.27635100000000001]
["YOR00922","Changed","Yes – alteration made",null,null,"wq","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200866","Clifton STW","Kearsley Bk","GB104027064244","River","Don Middle",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E727(SS)",451600,396800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,189,null,"4mg/l average","4000ug/l Fe 95%ile","40m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",3.5,null,null,null,null,null,null,"Cost beneficial scheme. 3.5 kilometres improved from Moderate to Good status","*",null,276351,0,0,1,"WWN+","£ per km LORI",0.27635100000000001,"Doesn't have a LORI associated. Small Phosophorous change. "]
["YOR00923","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200867","BENTLEY/STW P removal for WFD","Bentley Mill Stream","GB104027057541","River","Don Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","1978 sched 1",457130,405720,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20936,null,"0.25mg/l average","4000ug/l Fe 95%ile","5046m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,null,null,null,null,null,null,"Works identified for both WFD and SAe drivers.  WFD limit is concluded to be cost beneficial. ","*",null,2933301,0,0,1,"WWN+","£ per km LORI",1,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00928","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200872","KIRK SMEATON/STW","Went from Hoyle Mill Stream to Blowell Drain","GB104027063360","River","Don Lower",null,null,null,"WFD_IMPg","Phosphorus",null,null,null,null,"Continuous Discharge","2024-12-22","Amber","E730",453354,415995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800.6,null,"0.5mg/l average","4000ug/l Fe 95%ile","171m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",10.1,null,null,null,null,null,null,"Cost beneficial scheme. 8.1 kilometres improved from Poor to Good status and 2 kilometres improved from Poor to Moderate status. Total 10.1km in river length improvement.","*",null,1287218,2,2,1,"WWN+","£ per kgP/day removed",1.287218]
["YOR00966","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200910","Adwick Le Street","Ea Beck from the Skell to River Don","GB104027057591","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7541",454640,407980,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20133,null,"2mg/l average","4000ug/l Fe 95%ile","5400m³/d",null,"8000ug/l  Fe Upper Tier ",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,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00967","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200911","ALDWARKE/STW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","C4954",445060,394470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109591,null,"1mg/l average","4000ug/l Fe 95%ile","31277m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.8,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00968","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200912","BENTLEY/STW Sae","Bentley Mill Stream","GB104027057541","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",1978,457130,405720,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20936,null,"2mg/l average","4000ug/l Fe 95%ile","5046m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,null,null,null,null,null,null,"Defra to confirm sensitive areas.","*",null,2933301,0,0,1,"WWN+","£ per km LORI",2.9333010000000002,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00969","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200913","BLACKBURN MEADOWS/STW","Don from River Don Works to River Rother","GB104027057413","River","Don Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E25",440520,391930,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,460744,null,"1mg/l average","4000ug/l Fe 95%ile","158000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00970","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200914","BOLSOVER/STW","Doe Lea from Source to Hawke Brook","GB104027057290","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",1866,445960,370100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11810.6,null,"2mg/l average","4000ug/l Fe 95%ile","1900m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00971","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200915","BOLTON ON DEARNE/STW","Dearne Darfield STW to River Don","GB104027063173","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",3331,445930,402080,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101008,null,"2mg/l average","4000ug/l Fe 95%ile","5400m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,5.8619999999999948,5.8619999999999948,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR00972","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200916","BRADFORD ESHOLT/NO 2 STW","Aire from Gill Beck (Baildon) to River Calder","GB104027063032","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA6925",418984,438746,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,367696.2,null,"1mg/l average","4000ug/l Fe 95%ile","130000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00973","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200917","CALDER VALE/STW","Calder from River Chald to River Aire","GB104027062632","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","C4106",435070,420410,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101008,null,"1mg/l average","4000ug/l Fe 95%ile","32000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00974","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200918","CASTLEFORD/STW","Aire from River Calder to River Ouse","GB104027062760","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA6659",444640,426680,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40721,null,"2mg/l average","4000ug/l Fe 95%ile","8400m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Wheldale will have the LORI associated. Same works with different names. Wheldale = EA Name. Castleford = YW Name. "]
["YOR00975","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200919","CHEESEBOTTOM STW","Don from Scout Dyke to the Little Don","GB104027057490","River","Don Upper",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2556,427990,401280,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13297.2,null,"2mg/l average","4000ug/l Fe 95%ile","4478m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00976","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200920","CLAYTON WEST/STW","Dearne from Source to Bentley Brook","GB104027063220","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","3809(SS)",426780,412070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16803.8,null,"2mg/l average","4000ug/l Fe 95%ile","5748m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00977","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200921","DARTON/STW","Dearne from Cawthorne Dyke to Lundwood STW","GB104027063171","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2026,432637,408976,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22301,null,"2mg/l average","4000ug/l Fe 95%ile","4200m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,7.718,7.718,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR00978","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200922","DENABY WTW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E728(SS)",449450,399940,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32166,null,"2mg/l average","4000ug/l Fe 95%ile","8199m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00979","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200923","DEWSBURY/STW","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E15",426130,419640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250450,null,"1mg/l average","4000ug/l Fe 95%ile","85694m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers and dual names - see Mitchell Laithes"]
["YOR00980","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200924","DOWLEY GAP (BINGLEY)","Aire (R Worth to Gill Beck)","GB104027063034","River","Aire Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2502,412310,438140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38795.4,null,"2mg/l average","4000ug/l Fe 95%ile","11713m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00981","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200925","DRONFIELD/STW","Drone/Whitting from Source to River Rother","GB104027057710","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",1863,436750,377810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21779,null,"2mg/l average","4000ug/l Fe 95%ile","5500m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00982","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200926","OWLWOOD (GARFORTH) STW","Lin Dike from Source to River Aire","GB104027062810","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2225,441750,428790,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39030.800000000003,null,"2mg/l average","3481ug/l Fe 95%ile","8801m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00983","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200927","GRIMETHORPE/STW","Grimethorpe Dike from Source to River Dearne","GB104027063180","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2246,440280,409430,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12973.4,null,"2mg/l average","2655ug/l Fe 95%ile","3157m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00984","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200928","HARROGATE SOUTH/STW","Crimple Beck from Park Beck to River Nidd","GB104027063742","River","Nidd Middle and Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","QR.27/21/0048",437870,451620,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36729.800000000003,null,"2mg/l average","4000ug/l Fe 95%ile","9800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00985","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200929","HORBURY (DUDFLEET) STW","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","C4107",430000,417070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,null,"2mg/l average","4000ug/l Fe 95%ile","10m3/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00986","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200930","HUDDERSFIELD STW Cooper Bridge","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7409",418470,420810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56427,null,"1mg/l average","4000ug/l Fe 95%ile","20000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00987","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200931","KNOSTROP WWTW","Wyke Beck from Source to River Aire","GB104027062880","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA6924 / 11",433276,432035,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,366809,null,"1mg/l average","4000ug/l Fe 95%ile","213600m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00988","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200932","LEMONROYD STW","Oulton Beck from Source to River Aire","GB104027062680","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7220",438200,428000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35201.199999999997,null,"2mg/l average","4000ug/l Fe 95%ile","7500m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00989","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200933","LONG LANE/STW","Ulley Brook from Source to River Rother","GB104027057740","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","2081",443678,389206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22968,null,"2mg/l average","4000ug/l Fe 95%ile","4472m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00990","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200934","LUNDWOOD STW","Dearne from Lundwood to River Dove","GB104027063172","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E10",437940,406610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85600,null,"2mg/l average","4000ug/l Fe 95%ile","18237m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,2.0150000000000006,2.0150000000000006,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR00991","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200935","NORMANTON/STW (Mill Lane)","Choke Churl Bk from Source to River Calder","GB104027062590","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WA6472",439370,424190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44569.8,null,"2mg/l average","4000ug/l Fe 95%ile","12464m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.3,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00992","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200936","Norton (Askern) WwTW","Went from Hoyle Mill Stream to Blowell Drain","GB104027063360","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","3816(SS)",455120,416000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9866.2000000000007,null,"2mg/l average","4000ug/l Fe 95%ile","4004m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00993","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200937","Old Whittington (Chesterfield) STW","Rother, Spittal Brook to Doe Lea","GB104027057771","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA6756",439200,374630,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97084.6,null,"1mg/l average","4000ug/l Fe 95%ile","29600m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00994","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200938","SANDALL/STW","Don from Mill Dyke to River Ouse","GB104027064243","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","2829(T)",459760,406360,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91114,null,"2mg/l average","4000ug/l Fe 95%ile","25800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,14.064000000000007,14.064000000000007,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR00995","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200939","SHERBURN IN ELMET/STW","Upper Fox Drain Catchment ds of Sherburn STW","GB104027063610","River","Ouse Lower Yorkshire",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","27/24/0162",452920,433420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12214,null,"2mg/l average","2663ug/l Fe 95%ile","3750m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Multiple drivers. No LORI to avoid double counting. "]
["YOR00996","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200940","SNAITH/STW","Aire from River Calder to River Ouse","GB104027062760","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","1943",463530,422350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10800,null,"2mg/l average","4000ug/l Fe 95%ile","1367m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,15.47499999999998,15.47499999999998,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR00997","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200941","SOUTH ELMSALL/STW","Ea Beck from Frickley Beck to the Skell","GB104027063200","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7507",448390,410640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35231.1,null,"2mg/l average","4000ug/l Fe 95%ile","9800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR00998","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200942","Stanley (Smalley Bight) STW","Calder from River Chald to River Aire","GB104027062632","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E743(SS)",435280,423900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18957.2,null,"2mg/l average","4000ug/l Fe 95%ile","5300m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Same site as 7YW200806. LORI on other site. "]
["YOR00999","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200943","STAVELEY/STW","Doe Lea from Hawke Brooke to River Rother","GB104027057301","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA 6647",444380,376610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28138,null,"2mg/l average","4000ug/l Fe 95%ile","5730m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01000","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200944","STOCKSBRIDGE/STW","Don from Little Don to River Loxley confluence","GB104027057411","River","Don Upper",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E697(SS)",429150,397500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14718.2,null,"2mg/l average","4000ug/l Fe 95%ile","3482m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01001","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200945","SUTTON WWTW","Aire from River Calder to River Ouse","GB104027062760","River","Aire Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","1945",450400,424310,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48826,null,"2mg/l average","4000ug/l Fe 95%ile","11073m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01002","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200946","TUPTON/STW","Redleadmill Brook","GB104027057620","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","3139(SS)",439820,366810,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11012,null,"2mg/l average","4000ug/l Fe 95%ile","2641m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01003","Changed","Yes – alteration made",null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200947","WOMBWELL/STW","Dearne Darfield STW to River Don","GB104027063173","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WA6273",440881,403364,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41515.800000000003,null,"2mg/l average","4000ug/l Fe 95%ile","9900m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,5.1970000000000045,5.1970000000000045,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR01004","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200948","Woodhouse Mill WwTW","Rother, Doe Lea to Don","GB104027057772","River","Rother and Doe Lea",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","3334(SS)",443290,386140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146562,null,"1mg/l average","4000ug/l Fe 95%ile","23993m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01005","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200949","WORSBROUGH WwTW","Dove from Source to River Dearne","GB104027057510","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7404",436280,403430,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19580,null,"2mg/l average","4000ug/l Fe 95%ile","5400m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,5.7629999999999999,5.7629999999999999,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR01006","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200950","HIGH ROYD NO 2 STW","Luddenden Brook from Source to River Calder","GB104027062770","River","Calder Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","967",405169,423937,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11495.8,null,"2mg/l average","4000ug/l Fe 95%ile","6696m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01007","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200951","EASTWOOD/STW","Calder from Walsden Water to Colden Water","GB104027062650","River","Calder Upper",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","E61",397163,426382,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14727.6,null,"2mg/l average","4000ug/l Fe 95%ile","10255m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01008","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200952","HALIFAX COPLEY STW","Calder from Ryburn Confluence  to River Colne","GB104027062642","River","Calder Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7510",409224,422301,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,167246,null,"1mg/l average","4000ug/l Fe 95%ile","57700m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01009","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200953","NEILEY NO 2 STW","Holme from New Mill Dike to R Colne","GB104027063301","River","Colne and Holme",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","2255",414628,411578,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20346,null,"2mg/l average","4000ug/l Fe 95%ile","7497m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01010","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200954","Huddersfield STW Colne Bridge","Calder from River Colne to River Chald","GB104027062631","River","Calder Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7409",417820,420440,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237696,null,"2mg/l average","4000ug/l Fe 95%ile","84000m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Performs lower than standard being applied so no LORI. "]
["YOR01011","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200955","KEIGHLEY MARLEY/STW","Aire (R Worth to Gill Beck)","GB104027063034","River","Aire Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","WRA7172",409030,441150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90039,null,"2mg/l average","4000ug/l Fe 95%ile","28129m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01012","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200956","Wath-Upon-Dearne STW","Dearne Darfield STW to River Don","GB104027063173","River","Dearne",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","2172",444490,401120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18067.2,null,"2mg/l average","4000ug/l Fe 95%ile","6850m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,1.3049999999999997,1.3049999999999997,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR01013","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200957","MEXBORO SWINTON/STW","Don from River Rother to River Dearne","GB104027057452","River","Don Middle",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","2160",446986,399204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16175.2,null,"2mg/l average","4000ug/l Fe 95%ile","4800m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas","*",null,502014,0,0,1,"WWN+","£ per km LORI",0.50201399999999996,"Two drivers so LORI is on the WFD driver. "]
["YOR01014","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW200958","THORNE/STW","Don from Mill Dyke to River Ouse","GB104027064243","River","Don Lower",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber","3332",467780,414470,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39527,null,"2mg/l average","4000ug/l Fe 95%ile","7874m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas. ","*",null,502014,10.300999999999988,10.300999999999988,1,"WWN+","£ per km LORI",0.50201399999999996]
["YOR01518","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW201465","SKIPTON/STW","Aire (Eshton Beck to R Worth)","GB104027063033","River","Aire Upper",null,null,null,"U_IMP2","Phosphorus",null,null,null,null,"Continuous Discharge","2025-03-31","Amber",2838,398720,449400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19750,"0.5mg/l","2mg/l average","4000ug/l Fe 95%ile","5002m³/d",null,"8000ug/l  Fe Upper Tier ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Defra to confirm sensitive areas. This site already has a tighter P limit.","*",null,0,0,0,0,"WWN+","-","-","Was a WFD improvement in AMP6 so no activity in AMP7. Permitting matter only. No river length and no funding."]
["YOR00691","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300057","SOUTH ELMSALL/STW 3X","Ea Beck from Frickley Beck to the Skell","GB104027063200","River","Don Lower",null,null,null,"WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7507 schedule 2",448250,410650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35231.1,"15mg/l",null,null,"9800m³/d",null,"5,340m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25,null,null,null,null,null,null,"FIS, current storage 1340m³, additional storage 4,000m³ storage on settled storm discharge, total proposed storage 5340m³","*",null,590,5340,5340,1,"WWN+","£ per m3",5.9000000000000003E-4,"7YW300057 links with 7YW200635."]
["YOR00697","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300058","Pudsey intermittents - Smalewell","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7473 1",420740,432870,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3,950m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Current storage 950m³, additional storage 3000m³, total storage 3950m³. Smalewell","*",null,590,0,0,1,"WWN+","£ per m3",5.9000000000000003E-4,"All columns updated. Link to 7YW200641."]
["YOR01524","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300059","Bentley Mill Stream intermittents - BentleyMill Rise SPS","Bentley Mill Stream","GB104027057541","River","Don Lower",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7543/1",456650,404360,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39,null,null,null,null,null,null,"No current storage, additional storage 100m³, total proposed stoage 100m³ at Bentley Mill Rise SPS. To meet FIS standards.","*",null,2933301,1.18,1.18,1,"WWN+","£ per km LORI",9.9999999999999995E-7]
["YOR01525","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300060","West Bretton storm tank discharge Transfer to NGR 429884,412035","Dearne from Bentley Brook to Cawthorne Dyke","GB104027063260","River","Dearne",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Continuous Discharge","2024-12-22","Amber","C5412 / 2",429160,413280,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,"20mg/l",null,null,"219m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,null,null,"This will require feasibility as part of solution delivery which may change the exact discharge location. No changes to to flow or quality conditions. To meet FIS standards.","*",null,2933301,4.0999999999999996,4.0999999999999996,1,"WWN+","£ per km LORI",9.9999999999999995E-7]
["YOR01526","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300061","CLAYTON WEST/STW Final Effluent Transfer to NGR 429884,412035","Dearne from Bentley Brook to Cawthorne Dyke","GB104027063260","River","Dearne",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Continuous Discharge","2024-12-22","Amber","3809(SS) / schedule 1",426780,412070,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16803.8,"5mg/l",null,null,"8400m³/d","n/a","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0499999999999998,null,null,null,null,null,null,"This will require feasibility as part of solution delivery which may change the exact discharge location. No changes to to flow or quality conditions. To meet FIS standards.","*",null,2933301,5.76,5.76,1,"WWN+","£ per km LORI",9.9999999999999995E-7]
["YOR01527","Changed",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300062","West Bretton Final Effluent Transfer to NGR 429884,412035","Dearne from Bentley Brook to Cawthorne Dyke","GB104027063260","River","Dearne",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Continuous Discharge","2024-12-22","Amber","C5412 / 1",429160,413280,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,318,"20mg/l",null,null,"219m³/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,null,null,"This will require feasibility as part of solution delivery which may change the exact discharge location. No changes to to flow or quality conditions. To meet FIS standards.","*",null,2933301,0,0,1,"WWN+","£ per km LORI",9.9999999999999995E-7,"Dual driver. LORI on other scheme. "]
["YOR01531","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300066","Pudsey intermittents - Dick Lane","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7450 1",419710,433260,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,225m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Current storage 1,225m³, additional storage 3000m³ total proposed storage 4,225m³. Dick Lane(New Lane)","*",null,590,4225,4225,1,"WWN+","£ per m3",5.9000000000000003E-4,"Link to 7YW200641. "]
["YOR01532","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300067","Pudsey intermittents - Dale Farm","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7971 1",422990,430110,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"250m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Total proposed storage 250m³ total. Dale Farm CSO","*",null,590,250,250,1,"WWN+","£ per m3",5.9000000000000003E-4,"Link to 7YW200641. "]
["YOR01533","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300068","Pudsey intermittents - Hough Side Works","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","C4917 1",423660,433150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25,400m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Current storage, 400m³, additional storage 25,000m³ total, total proposed storage 25,400m³. Houghside Works","*",null,590,25400,25400,1,"WWN+","£ per m3",5.9000000000000003E-4,"Link to 7YW200641"]
["YOR01534","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300069","Pudsey intermittents - Gaint Road","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","C3961 1",423020,432610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,500m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Total proposed storage 2,500m³,  total.  Kent Road","*",null,590,2500,2500,1,"WWN+","£ per m3",5.9000000000000003E-4,"Link to 7YW200641.  "]
["YOR01535","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300070","Pudsey intermittents - Smalewell Reach 1","Low/Wortley/Pudsey Bks","GB104027062830","River","Aire Lower",null,null,null,"WFD_IMPg","Ammonia",null,null,null,null,"Intermittent Discharge","2024-12-22","Amber","WRA7473 1",420740,432870,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8,450m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.74,null,null,null,null,null,null,"Current storage 950m³, additional storage 7,500m³, total proposed storage8450m³. Smalewell in reach 1.  RLI has bee counted in previous line for Pudsey Smalewell CSO.YW write \"No investment identified for Dick lane under this Reach 3 solution, but 7500m³ at Pudsey Smalewell alone will not allowReach 1 to pass WQ\".","*",null,590,8450,8450,1,"WWN+","£ per m3",5.9000000000000003E-4,"Link to 7YW200641."]
["YOR01549","Addition",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","7YW300636","BENTLEY/STW storm discharge transfer to NGR 458119 405197","Bentley Mill Stream","GB104027057541","River","Don Lower",null,null,null,"WFD_IMPg","Ammonia","WFD_IMPg","Biochemical Oxygen Demand / Dissolved Oxygen",null,null,"Intermittent Discharge","2024-12-22","Amber","1978 schedule 2",457160,405724,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20936,null,null,null,"5046m³/d",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,null,null,null,null,null,null,"Relocate Bentley STW continuous and intermittents to the R.Don . Proposed 1mg/l would be required if transferscheme was not able to be completed.This will require feasibility as part of solution delivery which may change the exact discharge location. Needed to meet FIS standards",null,null,2933301,3.4329999999999936,3.4329999999999936,1,"WWN+","£ per km LORI",9.9999999999999995E-7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"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":1},"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":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"WINEP_Schemes"}]
[null,null,null,null,null,{"$f":" Check!F2","v":0},"Checks"]
[null,null,null,null,null,{"$f":" Check!F3","v":1},"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!A19","v":"EMD00773"},{"$f":" WINEP_Inputs!J19","v":"7YW200005"},{"$f":" WINEP_Inputs!K19","v":"BALBY (STW)"},{"$f":"WINEP_Inputs!CW19","v":"£ per km LORI"},{"$f":"WINEP_Inputs!CX19","v":0.27635100000000001},null,{"$f":" WINEP_Inputs!CR19","v":276351},{"$f":" WINEP_Inputs!CS19","v":0},{"$f":" WINEP_Inputs!CT19","v":0},{"$f":" WINEP_Inputs!CU19","v":1},{"$f":" WINEP_Inputs!CV19","v":"WWN+"},{"$f":" IF(K10 = 0, 0, K10 / J10)","v":0}]
[null,null,{"$f":" WINEP_Inputs!A20","v":"EMD00812"},{"$f":" WINEP_Inputs!J20","v":"7YW200006"},{"$f":" WINEP_Inputs!K20","v":"HATFIELD WOODHOUSE (STW)"},{"$f":"WINEP_Inputs!CW20","v":"per km LORI"},{"$f":"WINEP_Inputs!CX20","v":1},null,{"$f":" WINEP_Inputs!CR20","v":2933301},{"$f":" WINEP_Inputs!CS20","v":0},{"$f":" WINEP_Inputs!CT20","v":0},{"$f":" WINEP_Inputs!CU20","v":1},{"$f":" WINEP_Inputs!CV20","v":"WWN+"},0]
[null,null,{"$f":" WINEP_Inputs!A21","v":"EMD00813"},{"$f":" WINEP_Inputs!J21","v":"7YW200007"},{"$f":" WINEP_Inputs!K21","v":"HATFIELD WOODHOUSE (STW)"},{"$f":"WINEP_Inputs!CW21","v":"per km LORI"},{"$f":"WINEP_Inputs!CX21","v":1},null,{"$f":" WINEP_Inputs!CR21","v":2933301},{"$f":" WINEP_Inputs!CS21","v":0},{"$f":" WINEP_Inputs!CT21","v":0},{"$f":" WINEP_Inputs!CU21","v":1},{"$f":" WINEP_Inputs!CV21","v":"WWN+"},0]
[null,null,{"$f":" WINEP_Inputs!A5","v":"YOR00025"},{"$f":" WINEP_Inputs!J5","v":"7YW100089"},{"$f":" WINEP_Inputs!K5","v":"Little Don Catchment Scheme"},{"$f":"WINEP_Inputs!CW5","v":"£ per km LORI"},{"$f":"WINEP_Inputs!CX5","v":8.0759999999999998E-2},null,{"$f":" WINEP_Inputs!CR5","v":80760},{"$f":" WINEP_Inputs!CS5","v":3.05},{"$f":" WINEP_Inputs!CT5","v":3.05},{"$f":" WINEP_Inputs!CU5","v":1},{"$f":" WINEP_Inputs!CV5","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A6","v":"YOR00029"},{"$f":" WINEP_Inputs!J6","v":"7YW100091"},{"$f":" WINEP_Inputs!K6","v":"Winscar  Catchment Scheme"},{"$f":"WINEP_Inputs!CW6","v":"£ per km LORI"},{"$f":"WINEP_Inputs!CX6","v":8.0759999999999998E-2},null,{"$f":" WINEP_Inputs!CR6","v":80760},{"$f":" WINEP_Inputs!CS6","v":11.25},{"$f":" WINEP_Inputs!CT6","v":11.25},{"$f":" WINEP_Inputs!CU6","v":1},{"$f":" WINEP_Inputs!CV6","v":"WR"},1]
[null,null,{"$f":" WINEP_Inputs!A7","v":"YOR00033"},{"$f":" WINEP_Inputs!J7","v":"7YW100093"},{"$f":" WINEP_Inputs!K7","v":"Agden  River Restoration Scheme"},{"$f":"WINEP_Inputs!CW7","v":"£ per km LORI"},{"$f":"WINEP_Inputs!CX7","v":8.0759999999999998E-2},null,{"$f":" WINEP_Inputs!CR7","v":80760},{"$f":" WINEP_Inputs!CS7","v":0.44},{"$f":" WINEP_Inputs!CT7","v":0.44},{"$f":" WINEP_Inputs!CU7","v":1},{"$f":" WINEP_Inputs!CV7","v":"WR"},1]
[]
["End of sheet"]

{"sheet":"WINEP_Allowance","index":11,"n_rows":36,"n_cols":22,"rows_kept":36,"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":1},"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":"EMD00773"},{"$f":"WINEP_Schemes!D10","v":"7YW200005"},{"$f":"WINEP_Schemes!E10","v":"BALBY (STW)"},{"$f":"WINEP_Schemes!F10","v":"£ per km LORI"},{"$f":"WINEP_Schemes!G10","v":0.27635100000000001},{"$f":"WINEP_Schemes!H10","v":0},{"$f":"WINEP_Schemes!J10","v":0},{"$f":"WINEP_Schemes!I10","v":276351},{"$f":"WINEP_Schemes!K10","v":0},{"$f":"WINEP_Schemes!L10","v":1},{"$f":"WINEP_Schemes!M10","v":"WWN+"},{"$f":"WINEP_Schemes!N10","v":0},{"$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":"EMD00812"},{"$f":"WINEP_Schemes!D11","v":"7YW200006"},{"$f":"WINEP_Schemes!E11","v":"HATFIELD WOODHOUSE (STW)"},{"$f":"WINEP_Schemes!F11","v":"per km LORI"},{"$f":"WINEP_Schemes!G11","v":1},{"$f":"WINEP_Schemes!H11","v":0},{"$f":"WINEP_Schemes!J11","v":0},{"$f":"WINEP_Schemes!I11","v":2933301},{"$f":"WINEP_Schemes!K11","v":0},{"$f":"WINEP_Schemes!L11","v":1},{"$f":"WINEP_Schemes!M11","v":"WWN+"},{"$f":"WINEP_Schemes!N11","v":0},{"$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":"EMD00813"},{"$f":"WINEP_Schemes!D12","v":"7YW200007"},{"$f":"WINEP_Schemes!E12","v":"HATFIELD WOODHOUSE (STW)"},{"$f":"WINEP_Schemes!F12","v":"per km LORI"},{"$f":"WINEP_Schemes!G12","v":1},{"$f":"WINEP_Schemes!H12","v":0},{"$f":"WINEP_Schemes!J12","v":0},{"$f":"WINEP_Schemes!I12","v":2933301},{"$f":"WINEP_Schemes!K12","v":0},{"$f":"WINEP_Schemes!L12","v":1},{"$f":"WINEP_Schemes!M12","v":"WWN+"},{"$f":"WINEP_Schemes!N12","v":0},{"$f":" I13 * J13 * G13","v":0},{"$f":" N13 * O13","v":0},{"$f":" IF(L13 = 0, P13, (N13 - 1) * O13)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C13","v":"YOR00025"},{"$f":"WINEP_Schemes!D13","v":"7YW100089"},{"$f":"WINEP_Schemes!E13","v":"Little Don Catchment Scheme"},{"$f":"WINEP_Schemes!F13","v":"£ per km LORI"},{"$f":"WINEP_Schemes!G13","v":8.0759999999999998E-2},{"$f":"WINEP_Schemes!H13","v":0},{"$f":"WINEP_Schemes!J13","v":3.05},{"$f":"WINEP_Schemes!I13","v":80760},{"$f":"WINEP_Schemes!K13","v":3.05},{"$f":"WINEP_Schemes!L13","v":1},{"$f":"WINEP_Schemes!M13","v":"WR"},{"$f":"WINEP_Schemes!N13","v":1},{"$f":" I14 * J14 * G14","v":19892.641680000001},{"$f":" N14 * O14","v":19892.641680000001},{"$f":" IF(L14 = 0, P14, (N14 - 1) * O14)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C14","v":"YOR00029"},{"$f":"WINEP_Schemes!D14","v":"7YW100091"},{"$f":"WINEP_Schemes!E14","v":"Winscar  Catchment Scheme"},{"$f":"WINEP_Schemes!F14","v":"£ per km LORI"},{"$f":"WINEP_Schemes!G14","v":8.0759999999999998E-2},{"$f":"WINEP_Schemes!H14","v":0},{"$f":"WINEP_Schemes!J14","v":11.25},{"$f":"WINEP_Schemes!I14","v":80760},{"$f":"WINEP_Schemes!K14","v":11.25},{"$f":"WINEP_Schemes!L14","v":1},{"$f":"WINEP_Schemes!M14","v":"WR"},{"$f":"WINEP_Schemes!N14","v":1},73374.497999999992,73374.497999999992,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C15","v":"YOR00033"},{"$f":"WINEP_Schemes!D15","v":"7YW100093"},{"$f":"WINEP_Schemes!E15","v":"Agden  River Restoration Scheme"},{"$f":"WINEP_Schemes!F15","v":"£ per km LORI"},{"$f":"WINEP_Schemes!G15","v":8.0759999999999998E-2},{"$f":"WINEP_Schemes!H15","v":0},{"$f":"WINEP_Schemes!J15","v":0.44},{"$f":"WINEP_Schemes!I15","v":80760},{"$f":"WINEP_Schemes!K15","v":0.44},{"$f":"WINEP_Schemes!L15","v":1},{"$f":"WINEP_Schemes!M15","v":"WR"},{"$f":"WINEP_Schemes!N15","v":1},2869.7581439999999,2869.7581439999999,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:Q16)","v":0},0,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":" Q19","v":0},"£m"]
[null,null,null,null,"Sum of the WINEP Reconciliation by price control",{"$f":" SUM(R19:V19)","v":0},"£m"]
[]
[null,null,null,null,"Price Control Reconciliation vs Total Reconciliation - check",{"$f":" IF( F23 - F22 > 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":" R19","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, water network",{"$f":" S19","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, wastewater network",{"$f":" T19","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, bioresources",{"$f":" U19","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, dummy",{"$f":" V19","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":1},"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!E29","v":"Total Final Reconciliation, water resources"},{"$f":"WINEP_Allowance!F29","v":0},{"$f":"WINEP_Allowance!G29","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E30","v":"Total Final Reconciliation, water network"},{"$f":"WINEP_Allowance!F30","v":0},{"$f":"WINEP_Allowance!G30","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E31","v":"Total Final Reconciliation, wastewater network"},{"$f":"WINEP_Allowance!F31","v":0},{"$f":"WINEP_Allowance!G31","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E32","v":"Total Final Reconciliation, bioresources"},{"$f":"WINEP_Allowance!F32","v":0},{"$f":"WINEP_Allowance!G32","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E33","v":"Total Final Reconciliation, dummy"},{"$f":"WINEP_Allowance!F33","v":0},{"$f":"WINEP_Allowance!G33","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":0},null,{"$f":" IF( J$17 = 1, $F11 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F11 / 3, 0)","v":0},{"$f":" IF( O$17 = 1, $F11 / 3, 0)","v":0},0]
[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",0,0,0,0,0,0,0,0,0]
[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":0},0,{"$f":" J26","v":0},0,0,0,0,0,{"$f":" P26","v":0}]
[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":0},null,{"$f":" J38 * J$44","v":0},0,0,0,0,0,0]
[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},{"$f":"Annual_Outputs!O26","v":0},{"$f":"Annual_Outputs!P26","v":0},{"$f":"Annual_Outputs!H26","v":0}]
[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},{"$f":"Annual_Outputs!O47","v":0},{"$f":"Annual_Outputs!P47","v":0},{"$f":"Annual_Outputs!H47","v":0}]
[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":"[…]03/06/2024 14:10:04"},"[…]03/06/2024 14:10:04","[…]03/06/2024 14:10:04","[…]03/06/2024 14:10:04"]
[null,"BoN_QA2","WINEP reconciliation model time stamp","text","Price Review 2019","[…]03/06/2024 14:10:04","[…]03/06/2024 14:10:04","[…]03/06/2024 14:10:04","[…]03/06/2024 14:10:04"]
[]
[]
["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":1}]
[null,null,null,null,null,{"$f":"J2","v":1},"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":0},null,{"$f":" IF(ABS(K15) > InpActive!$F$42, 1, 0)","v":0},0,{"$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":0},null,{"$f":" IF(ABS(K20) > InpActive!$F$42, 1, 0)","v":0},{"$f":" H20 - INDEX(M20:O20, $J$5)","v":0},{"$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":"2024-06-03"}]
[null,null,null,null,"Time",null,null,{"$f":" NOW()","v":45446.590329513892}]
[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":"YKY87_WINEP Reconciliation Model.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":1},"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!E25","v":"Price Control Reconciliation vs Total Reconciliation - check"},{"$f":"WINEP_Allowance!F25","v":0},{"$f":"WINEP_Allowance!G25","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":1}]
[]
[]
["End of sheet"]