{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Cover","Documentation >>","User Guide","ToC","Model formatting","Inputs >>","Time","WINEP_Inputs","InpActive","Calcs >>","WINEP_Schemes","WINEP_Allowance","Outputs >>","Annual_Outputs","F_Outputs","QA >>","Track","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":61,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

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

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

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

{"sheet":"Model formatting","index":4,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Model formatting"}]
[]
[]
["SHEET TABS"]
[]
[null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[null,null,null,null,"Orange",null,"To be used for internal purposes only, removed prior to publication"]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks & alerts"]
[null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,"Red shade",null,"Error"]
[]
[null,null,null,null,"Gold shade",null,"Alert"]
[]
["ABBREVIATIONS"]
[]
[null,null,null,null,"WINEP",null,"Water Industry National Environment Programme"]
[null,null,null,null,"£",null,"Great Britain Pound"]
[null,null,null,null,"m",null,"Million"]
[null,null,null,null,"na",null,"Not available / applicable"]
[null,null,null,null,"#",null,"Number"]
[]
["LIST OF MACROS USED"]
[]
[null,null,null,null,"Store track results"]
[null,null,null,null,null,null,"This macro helps in storing the results/outputs after any change is made in the model on \"Track\" sheet."]
[null,null,null,null,null,null,"These stored results then can be used to analyse the impact of any change made in the model."]
[null,null,null,null,null,null,"Goto macro"]
[]
[null,null,null,null,"Save as PDF"]
[null,null,null,null,null,null,"This macro helps in saving any worksheet or chart in PDF format."]
[]
["END OF SHEET"]

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

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

{"sheet":"WINEP_Inputs","index":7,"n_rows":12,"n_cols":103,"rows_kept":12,"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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The lines below are examples with some dummy inputs."]
["VERSION 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSSI/N2K/Ramsar",null,null,null,null,"Eels",null,"NERC Driver",null,null,null,null,null,null,null,"INNS",null,"MCZ","Water Quality Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Resource Detail",null,null,null,null,null,null,null,null,null,"Environmental Outcome ",null,null,null,null,null,null,null,null,null,"WINEP model inputs"]
["WINEPID","Change Log Winep 2 to 3  ","NEW Column. Has an alteration to this measure been made? If Y then please refer to alterations log. ","Application in determination by NPS?","Has a permit been issued?","Function","RBD","Area","Water Company ","Unique ID *   (completed on company collation)","Scheme Name/Name of Investigation/Site Name/Licence name","Name of Waterbody","Waterbody ID","Water Body Type(s)","WFD Operational Catchment","Blank Column","Blank Column","Blank Column","Driver Code \n(Primary)","Further Driver Code Information \n(related to the primary driver if applicable)","Driver Code \n(Secondary)","Further Driver Code Information \n(related to the secondary driver if applicable)","Driver Code\n(Tertiary)","Further Driver Code Information \n(related to the tertiary driver if applicable)","Measure Type","Completion Date (DD/MM/YY)","Level of Certainty? (P= Purple, R=Red, A=Amber, G=Green","Abstraction Licence/ Permit, Obstruction ID or No Obstruction ID","Eastings","Northings","Investigation Type","Investigation Scope","Implementation Scope","Groundwater Measures Information","Name of SSSI \n(if applicable)","Name of N2K/Ramsar site \n(if applicable)","SSSI/N2K/Ramsar Unit ID","SSSI/N2K/Ramsar Area of Unit (Hectares)","Justification for Action/Investigation","Eel Priority Status","Eel Improvement Type ","Primary Type of Priority Habitat Created or Restored/Improved","Secondary Type of Priority Habitat Created or Restored/Improved","Other Priority Habitat Created or Restored/Improved","Type of Action Taken","Units Recorded (Hectare or km)","Number of Hectares or Kms","Name of Priority Species","Name of High Risk of Extinction Species","INNS Control Measure","INNS Species \n(if applicable)","Name of MCZ","Name of Bathing Water \n(where applicable)","Name of Shellfish Water \n(where applicable)","Chemical of Interest \n(for chemicals measures only)","Groundwater Chemicals","Drinking Water Inspectorate - Undertaking or Notice \nY/N","DrWPA Substances at Risk\n(if applicable)","Safeguard Zone Name \n(if applicable)","Safeguard Zone ID \n(if applicable)","Population Equivalent for STWs ","Current Permit Limit (mg/l)","Proposed Permit Limit (mg/l)","Proposed Iron or Aluminium Limits \n(for Phosphorus measures only)","Current DWF (m3/d)","Proposed DWF (m3/d) \n(if applicable)","Proposed Permit Limit Other","Catchment Measure Actions ","Unsustainable Abstraction System Code","Linked Groundwater Body Name","Linked Groundwater Body ID","Licence Category","Water Resource Zone \n(WRZ)","WR HMWB Flag  \n(X)","Scheme Relates to Following Missing Mitigation Measures \n(HMWB only)","Annual Licence Volume (Ml/a)","Daily Licence Volume (Ml/d)","Aggregate Licence (x)","Sustainability Change (to Annual Licence Volume) \nMl/a","Sustainability Change (to Daily Licence Volume) \nMl/d","Sustainability Change (to HoF Condition) \nMl/d","*NEW* \nWater returned to the environment (Reduction in actual abstraction) ML/d","New Annual Licence Volume \n(Ml/a)","New Daily Licence Volume \n(Ml/d)","New HoF Condition \n(Ml/d)","Quantitative\nKm River Length Improved or Protected ","Quantitative\nArea (km2) Improved or Protected","Volume (Ml/yr) Drinking Water Protected","Hectares of Designated Site (HD/RAMSAR/\nSSSI) Restored or Improved","*NEW* \nINNS ,No Det outcome - Km2 of land with reduced risk of INNS","Delivers Additional FCERM Benefits \n(Y/N)","Delivers on Salmon 5-Point Action Plan","Additional Comments","CPS Reference","Flow Categorisation\n1= PR19 Synergy\n2= WFD failure\n3= Neither","Allowed totex unit rate","Quantity proposed in PR19 FD","Quantity Delivered","1 = In PR19, funded\n0 = In PR19, not funded","Price Control","Unit","Unit Conversion to £m"]
["EX00001"," EXAMPLE ",null,null,null,"WR","Humber","Yorkshire","Sample Water Services Ltd","XXW000001","Sample Fish Passage","Sample waterbody","GB104027057490","River","Sample",null,null,null," WFD_IMP_FISH ",null,null,null,null,null," Fish Passage ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,30000,{"$f":" CH5","v":10},5,1,"WR","£ per km LORI",9.9999999999999995E-7]
["EX00002"," EXAMPLE ",null,null,null,"FBG","Humber","Yorkshire","Sample Water Services Ltd","XXW000002","Investigation - reservoirs ","Sample","Water Company Scale",null,"Sample",null,null,null," EE_INV ",null,null,null,null,null," Investigation  ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15000,20,17,1,"WR","£ per reservoir",9.9999999999999995E-7]
["EX00003"," EXAMPLE ",null,null,null,"WQ","Humber","Yorkshire","Sample Water Services Ltd","XXW000003","Sample STW1","Sample waterbody","GB104027057452","River","Sample",null,null,null," WFD_IMPg ","Phosphorus",null,null,null,null," Continuous Discharge ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,3.4,1,1,0,"WWN","£m",1]
["EX00004"," EXAMPLE ",null,null,null,"WQ","Thames","Thames","Sample Water Services Ltd","XXW000004","Sample STW2","Sample waterbody","GB106039017900","River","Sample",null,null,null," WFD_IMPg ","Phosphorus",null,null,null,null," Continuous Discharge ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15800,null,0.3,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,412,{"$f":"BI8","v":15800},{"$f":"CS8","v":15800},1,"WWN","£ per p.e.",9.9999999999999995E-7]
["EX00005"," EXAMPLE ",null,null,null,"WQ","Thames","Thames","Sample Water Services Ltd","XXW000005","Sample STW3","Sample waterbody","GB106038040110","River","Sample",null,null,null," WFD_IMPg ","Phosphorus",null,null,null,null," Continuous Discharge ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,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,null,"0.4 mg/l",null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.588000000000001,null,null,null,null,null,null,null,null,null,1937,{"$f":"BI9","v":800},{"$f":"CS9","v":800},1,"WWN","£ per p.e.",9.9999999999999995E-7]
["EX00006"," EXAMPLE ",null,null,null,"WQ","Thames","Thames","Sample Water Services Ltd","XXW000006","Sample STW4","Sample waterbody","GB106038040140","River","Sample",null,null,null,"WFD_IMP_CHEM",null,null,null,null,null," Continuous Discharge ","dd/mm/2024","Amber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.6,null,null,null,null,null,null,null,null,null,2.4590000000000001,1,1,1,"WWN","£m",1]
["NEP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRW, NEP"]
["NEP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRW, NEP"]

{"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":5},"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":5},"Track chgs"]
[]
["AMBER WINEP SCHEMES"]
[]
[null,null,"List of WINEP schemes that were unconfirmed at FD"]
[null,null,"The lines below are examples with some dummy inputs."]
[null,null,"WINEPID","Unique ID","Scheme category / name","Unit","Unit Conversion to £m",null,"Allowed totex unit rate","Quantity in PR19 FD","Quantity Delivered","1 = In FD, funded\n0 = In FD, not funded","Price Control","Proportion Confirmed"]
[null,null,{"$f":" WINEP_Inputs!A5","v":"EX00001"},{"$f":" WINEP_Inputs!J5","v":"XXW000001"},{"$f":" WINEP_Inputs!K5","v":"Sample Fish Passage"},{"$f":"WINEP_Inputs!CW5","v":"£ per km LORI"},{"$f":"WINEP_Inputs!CX5","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CR5","v":30000},{"$f":" WINEP_Inputs!CS5","v":10},{"$f":" WINEP_Inputs!CT5","v":5},{"$f":" WINEP_Inputs!CU5","v":1},{"$f":" WINEP_Inputs!CV5","v":"WR"},{"$f":" IF(K10 = 0, 0, K10 / J10)","v":0.5}]
[null,null,{"$f":" WINEP_Inputs!A6","v":"EX00002"},{"$f":" WINEP_Inputs!J6","v":"XXW000002"},{"$f":" WINEP_Inputs!K6","v":"Investigation - reservoirs "},{"$f":"WINEP_Inputs!CW6","v":"£ per reservoir"},{"$f":"WINEP_Inputs!CX6","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CR6","v":15000},{"$f":" WINEP_Inputs!CS6","v":20},{"$f":" WINEP_Inputs!CT6","v":17},{"$f":" WINEP_Inputs!CU6","v":1},{"$f":" WINEP_Inputs!CV6","v":"WR"},0.85]
[null,null,{"$f":" WINEP_Inputs!A7","v":"EX00003"},{"$f":" WINEP_Inputs!J7","v":"XXW000003"},{"$f":" WINEP_Inputs!K7","v":"Sample STW1"},{"$f":"WINEP_Inputs!CW7","v":"£m"},{"$f":"WINEP_Inputs!CX7","v":1},null,{"$f":" WINEP_Inputs!CR7","v":3.4},{"$f":" WINEP_Inputs!CS7","v":1},{"$f":" WINEP_Inputs!CT7","v":1},{"$f":" WINEP_Inputs!CU7","v":0},{"$f":" WINEP_Inputs!CV7","v":"WWN"},1]
[null,null,{"$f":" WINEP_Inputs!A8","v":"EX00004"},{"$f":" WINEP_Inputs!J8","v":"XXW000004"},{"$f":" WINEP_Inputs!K8","v":"Sample STW2"},{"$f":"WINEP_Inputs!CW8","v":"£ per p.e."},{"$f":"WINEP_Inputs!CX8","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CR8","v":412},{"$f":" WINEP_Inputs!CS8","v":15800},{"$f":" WINEP_Inputs!CT8","v":15800},{"$f":" WINEP_Inputs!CU8","v":1},{"$f":" WINEP_Inputs!CV8","v":"WWN"},1]
[null,null,{"$f":" WINEP_Inputs!A9","v":"EX00005"},{"$f":" WINEP_Inputs!J9","v":"XXW000005"},{"$f":" WINEP_Inputs!K9","v":"Sample STW3"},{"$f":"WINEP_Inputs!CW9","v":"£ per p.e."},{"$f":"WINEP_Inputs!CX9","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CR9","v":1937},{"$f":" WINEP_Inputs!CS9","v":800},{"$f":" WINEP_Inputs!CT9","v":800},{"$f":" WINEP_Inputs!CU9","v":1},{"$f":" WINEP_Inputs!CV9","v":"WWN"},1]
[null,null,{"$f":" WINEP_Inputs!A10","v":"EX00006"},{"$f":" WINEP_Inputs!J10","v":"XXW000006"},{"$f":" WINEP_Inputs!K10","v":"Sample STW4"},{"$f":"WINEP_Inputs!CW10","v":"£m"},{"$f":"WINEP_Inputs!CX10","v":1},null,{"$f":" WINEP_Inputs!CR10","v":2.4590000000000001},{"$f":" WINEP_Inputs!CS10","v":1},{"$f":" WINEP_Inputs!CT10","v":1},{"$f":" WINEP_Inputs!CU10","v":1},{"$f":" WINEP_Inputs!CV10","v":"WWN"},1]
[]
["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":5},"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":"EX00001"},{"$f":"WINEP_Schemes!D10","v":"XXW000001"},{"$f":"WINEP_Schemes!E10","v":"Sample Fish Passage"},{"$f":"WINEP_Schemes!F10","v":"£ per km LORI"},{"$f":"WINEP_Schemes!G10","v":9.9999999999999995E-7},{"$f":"WINEP_Schemes!H10","v":0},{"$f":"WINEP_Schemes!J10","v":10},{"$f":"WINEP_Schemes!I10","v":30000},{"$f":"WINEP_Schemes!K10","v":5},{"$f":"WINEP_Schemes!L10","v":1},{"$f":"WINEP_Schemes!M10","v":"WR"},{"$f":"WINEP_Schemes!N10","v":0.5},{"$f":" I11 * J11 * G11","v":0.3},{"$f":" N11 * O11","v":0.15},{"$f":" IF(L11 = 0, P11, (N11 - 1) * O11)","v":-0.15},{"$f":" IF($M11 = R$9, $Q11, 0)","v":-0.15},{"$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":"EX00002"},{"$f":"WINEP_Schemes!D11","v":"XXW000002"},{"$f":"WINEP_Schemes!E11","v":"Investigation - reservoirs "},{"$f":"WINEP_Schemes!F11","v":"£ per reservoir"},{"$f":"WINEP_Schemes!G11","v":9.9999999999999995E-7},{"$f":"WINEP_Schemes!H11","v":0},{"$f":"WINEP_Schemes!J11","v":20},{"$f":"WINEP_Schemes!I11","v":15000},{"$f":"WINEP_Schemes!K11","v":17},{"$f":"WINEP_Schemes!L11","v":1},{"$f":"WINEP_Schemes!M11","v":"WR"},{"$f":"WINEP_Schemes!N11","v":0.85},{"$f":" I12 * J12 * G12","v":0.3},{"$f":" N12 * O12","v":0.255},{"$f":" IF(L12 = 0, P12, (N12 - 1) * O12)","v":-4.5000000000000005E-2},{"$f":" IF($M12 = R$9, $Q12, 0)","v":-4.5000000000000005E-2},0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C12","v":"EX00003"},{"$f":"WINEP_Schemes!D12","v":"XXW000003"},{"$f":"WINEP_Schemes!E12","v":"Sample STW1"},{"$f":"WINEP_Schemes!F12","v":"£m"},{"$f":"WINEP_Schemes!G12","v":1},{"$f":"WINEP_Schemes!H12","v":0},{"$f":"WINEP_Schemes!J12","v":1},{"$f":"WINEP_Schemes!I12","v":3.4},{"$f":"WINEP_Schemes!K12","v":1},{"$f":"WINEP_Schemes!L12","v":0},{"$f":"WINEP_Schemes!M12","v":"WWN"},{"$f":"WINEP_Schemes!N12","v":1},{"$f":" I13 * J13 * G13","v":3.4},{"$f":" N13 * O13","v":3.4},{"$f":" IF(L13 = 0, P13, (N13 - 1) * O13)","v":3.4},0,0,3.4,0,0]
[null,null,{"$f":"WINEP_Schemes!C13","v":"EX00004"},{"$f":"WINEP_Schemes!D13","v":"XXW000004"},{"$f":"WINEP_Schemes!E13","v":"Sample STW2"},{"$f":"WINEP_Schemes!F13","v":"£ per p.e."},{"$f":"WINEP_Schemes!G13","v":9.9999999999999995E-7},{"$f":"WINEP_Schemes!H13","v":0},{"$f":"WINEP_Schemes!J13","v":15800},{"$f":"WINEP_Schemes!I13","v":412},{"$f":"WINEP_Schemes!K13","v":15800},{"$f":"WINEP_Schemes!L13","v":1},{"$f":"WINEP_Schemes!M13","v":"WWN"},{"$f":"WINEP_Schemes!N13","v":1},{"$f":" I14 * J14 * G14","v":6.5095999999999998},{"$f":" N14 * O14","v":6.5095999999999998},{"$f":" IF(L14 = 0, P14, (N14 - 1) * O14)","v":0},0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C14","v":"EX00005"},{"$f":"WINEP_Schemes!D14","v":"XXW000005"},{"$f":"WINEP_Schemes!E14","v":"Sample STW3"},{"$f":"WINEP_Schemes!F14","v":"£ per p.e."},{"$f":"WINEP_Schemes!G14","v":9.9999999999999995E-7},{"$f":"WINEP_Schemes!H14","v":0},{"$f":"WINEP_Schemes!J14","v":800},{"$f":"WINEP_Schemes!I14","v":1937},{"$f":"WINEP_Schemes!K14","v":800},{"$f":"WINEP_Schemes!L14","v":1},{"$f":"WINEP_Schemes!M14","v":"WWN"},{"$f":"WINEP_Schemes!N14","v":1},1.5495999999999999,1.5495999999999999,0,0,0,0,0,0]
[null,null,{"$f":"WINEP_Schemes!C15","v":"EX00006"},{"$f":"WINEP_Schemes!D15","v":"XXW000006"},{"$f":"WINEP_Schemes!E15","v":"Sample STW4"},{"$f":"WINEP_Schemes!F15","v":"£m"},{"$f":"WINEP_Schemes!G15","v":1},{"$f":"WINEP_Schemes!H15","v":0},{"$f":"WINEP_Schemes!J15","v":1},{"$f":"WINEP_Schemes!I15","v":2.4590000000000001},{"$f":"WINEP_Schemes!K15","v":1},{"$f":"WINEP_Schemes!L15","v":1},{"$f":"WINEP_Schemes!M15","v":"WWN"},{"$f":"WINEP_Schemes!N15","v":1},2.4590000000000001,2.4590000000000001,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":3.2050000000000001},-0.19500000000000001,0,3.4,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":3.2050000000000001},"£m"]
[null,null,null,null,"Sum of the WINEP Reconciliation by price control",{"$f":" SUM(R19:V19)","v":3.2050000000000001},"£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.19500000000000001},"£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":3.4},"£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":5},"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.19500000000000001},{"$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":3.4},{"$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.19500000000000001},null,{"$f":" IF( J$17 = 1, $F11 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F11 / 3, 0)","v":-6.5000000000000002E-2},{"$f":" IF( O$17 = 1, $F11 / 3, 0)","v":-6.5000000000000002E-2},-6.5000000000000002E-2]
[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",3.4,null,{"$f":" IF( J$17 = 1, $F13 / 3, 0)","v":0},0,0,0,{"$f":" IF( N$17 = 1, $F13 / 3, 0)","v":1.1333333333333333},1.1333333333333333,1.1333333333333333]
[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.19500000000000001,0,0,0,0,0,-6.5000000000000002E-2,-6.5000000000000002E-2,-6.5000000000000002E-2]
[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",3.4,0,0,0,0,0,1.1333333333333333,1.1333333333333333,1.1333333333333333]
[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.19500000000000001},0,{"$f":" J26","v":0},0,0,0,-6.5000000000000002E-2,-6.5000000000000002E-2,{"$f":" P26","v":-6.5000000000000002E-2}]
[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":3.4},0,{"$f":" J28","v":0},0,0,0,1.1333333333333333,1.1333333333333333,{"$f":" P28","v":1.1333333333333333}]
[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.20074942159999998},null,{"$f":" J38 * J$44","v":0},0,0,0,-6.885142159999999E-2,-6.6897999999999999E-2,-6.5000000000000002E-2]
[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",3.5002463253333329,null,{"$f":" J40 * J$44","v":0},0,0,0,{"$f":" N40 * N$44","v":1.2004863253333331},1.1664266666666665,{"$f":" P40 * P$44","v":1.1333333333333333}]
[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":-6.5000000000000002E-2},{"$f":"Annual_Outputs!O26","v":-6.5000000000000002E-2},{"$f":"Annual_Outputs!P26","v":-6.5000000000000002E-2},{"$f":"Annual_Outputs!H26","v":-0.19500000000000001}]
[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":1.1333333333333333},{"$f":"Annual_Outputs!O28","v":1.1333333333333333},{"$f":"Annual_Outputs!P28","v":1.1333333333333333},{"$f":"Annual_Outputs!H28","v":3.4}]
[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":-6.885142159999999E-2},{"$f":"Annual_Outputs!O47","v":-6.6897999999999999E-2},{"$f":"Annual_Outputs!P47","v":-6.5000000000000002E-2},{"$f":"Annual_Outputs!H47","v":-0.20074942159999998}]
[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":1.2004863253333331},{"$f":"Annual_Outputs!O49","v":1.1664266666666665},{"$f":"Annual_Outputs!P49","v":1.1333333333333333},{"$f":"Annual_Outputs!H49","v":3.5002463253333329}]
[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":"[…]01/12/2020 17:14:13"},"[…]01/12/2020 17:14:13","[…]01/12/2020 17:14:13","[…]01/12/2020 17:14:13"]
[null,"BoN_QA2","WINEP reconciliation model time stamp","text","Price Review 2019","[…]01/12/2020 17:14:13","[…]01/12/2020 17:14:13","[…]01/12/2020 17:14:13","[…]01/12/2020 17:14:13"]
[]
[]
["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":5}]
[null,null,null,null,null,{"$f":"J2","v":5},"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.19500000000000001},null,{"$f":" IF(ABS(K15) > InpActive!$F$42, 1, 0)","v":1},-0.19500000000000001,{"$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":3.4},null,{"$f":" IF(ABS(K17) > InpActive!$F$42, 1, 0)","v":1},{"$f":" H17 - INDEX(M17:O17, $J$5)","v":3.4},{"$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.20074942159999998},null,{"$f":" IF(ABS(K20) > InpActive!$F$42, 1, 0)","v":1},{"$f":" H20 - INDEX(M20:O20, $J$5)","v":-0.20074942159999998},{"$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":3.5002463253333329},null,{"$f":" IF(ABS(K22) > InpActive!$F$42, 1, 0)","v":1},3.5002463253333329,{"$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":"2020-12-01"}]
[null,null,null,null,"Time",null,null,{"$f":" NOW()","v":44166.718205555553}]
[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":"WINEP-Reconciliation-Model-Dec-2020-v1n.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":5},"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":5}]
[]
[]
["End of sheet"]