{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover","User Guide","Map & Key","Inputs >>","WINEP_Inputs","Time","InpActive","Calcs >>","WINEP_Schemes","WINEP_Allowance","Outputs >>","Annual_Outputs","F_Outputs","QA >>","Track","Check"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":59,"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":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,3,7,4],[22,3,22,4],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6]]}
[{"$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:",{"$f":" LEFT(D5, FIND(\".\", D5, 1) - 1)","v":"WINEP Reconciliation Model v1g"}]
[null,null,"Filename:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"WINEP Reconciliation Model v1g.xlsm"}]
[null,null,"Date:","2019-09-02"]
[null,null,"Author:","Ofwat"]
[null,null,"Author contact information:","pr19@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."]
[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 is 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."]
[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 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 schemes 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."]
[]
[null,null,null,"NB - The model price base is 'CPIH Financial year average 2017/18', unless otherwise stated. "]
[]
[]
[null,null,"Known limitations:"]
[]
[null,null,null,"Issue",null,"Details","Model link"]
[null,null,null,"Illustrative Model",null,"This is an initial, illustrative model. We may make refinements to it in due course."]
[]
[]
[null,null,"Quality Assurance","The model has been subject to internal Ofwat quality assurance. "]
[null,null,null,"Users should refer to the \"Delivering Water 2020: Our final methodology for the 2019 price review\" for information on proposed policy."]
[null,null,null,"Follow link >>","Pr19 Final Methodology"]
[]
[null,null,"Feedback:","We would welcome feedback on this model. Please send any feedback to the following email address."]
[null,null,null,"pr19@ofwat.gov.uk"]
[]
[null,null,"Error check status:",{"$f":"Check!$F$2","v":0},{"$f":" IF(D33 = 0, \"No error checks\", \"Error checks active\")","v":"No error checks"}]
[null,null,null,{"$f":"Check!$F$3","v":0},{"$f":" IF(D34 = 0, \"No output changes\", \"Output changes\")","v":"No output changes"}]
[]
[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"]
[]
["End of sheet"]

{"sheet":"User Guide","index":1,"n_rows":82,"n_cols":5,"rows_kept":82,"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 WINEP spreadsheet. Please follow the steps below to update the WINEP_inputs:"]
[]
[null,null,null,"1)","Update the WINEP_Inputs sheet:"]
[null,null,null,"Step 1 - ","Go to the WINEP workbook and filter on Amber schemes for the company required"]
[null,null,null,"Step 2 - ","Copy the entire selection to cell C5 of WINEP_Inputs"]
[null,null,null,"Step 3 - ","Complete column CT 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 4 - ","Complete column CU for all rows with the proportion confirmed. This will usually be 100% or 0%"]
[null,null,null,"Step 5 - ","Columns CR and CS are available for any interim calculations needed to get the data into the format required by the WINEP_Schemes sheet "]
[]
[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!$A$1","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":"Map & Key","index":2,"n_rows":93,"n_cols":26,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Map & Key"}]
[]
["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,"Map & Key",null,null,null,"InpActive"]
[null,null,null,null,null,null,null,"ToC and key to formatting",null,null,null,"All inputs to be flowed into model"]
[]
[]
[]
[]
["SHEET TABS"]
[]
[null,null,null,null,null,null,null,"Light Yellow",null,"Input sheets"]
[]
[null,null,null,null,null,null,null,"No colour (default Excel tab colour)",null,"Calculation and documentation sheets"]
[]
[null,null,null,null,null,null,null,"Pale Blue",null,"Key output sheets"]
[]
[null,null,null,null,null,null,null,"Turquoise",null,"Quality control sheets"]
[]
[null,null,null,null,null,null,null,"Yellow",null,"To be completed, temporary, restructured, or deleted"]
[]
[]
["COLOUR"]
[]
[null,"Font colour only"]
[null,null,null,null,null,null,null,"Blue font",null,"Imported from another sheet"]
[]
[null,null,null,null,null,null,null,"Red font ",null,"Exported to another sheet (except from Input sheets)"]
[]
[null,null,null,null,null,null,null,"Black font",null,"Within sheet link or calculation"]
[]
[null,"Font + shade combinations"]
[null,null,null,null,null,null,null,"Black font + Light Yellow shade",null,"Inputs"]
[]
[null,null,null,null,null,null,null,"Black font + Light Grey shade on entire row",null,"Within-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Blue font + Light Grey shade on entire row",null,"Between-worksheet counter-flow "]
[]
[null,null,null,null,null,null,null,"Empty Cell with Light Grey shade",null,"Empty cells being deliberately referenced"]
[]
[null,"Other"]
[null,null,null,null,null,null,null,"Black font + Pale Blue shade on entire row",null,"Section separator"]
[]
[null,null,null,null,null,null,null,"Light Turquoise shade",null,"Stored/dead/hard coded outputs"]
[]
[null,null,null,null,null,null,null,"Tan shade",null,"Pre-model time line actuals"]
[]
[null,null,null,null,null,null,null,"Yellow shade",null,"Work in progress / temporary"]
[]
[null,null,null,null,null,null,null,"Lime shade",null,"Values or logic to be reviewed"]
[]
[null,"Error checks & alerts"]
[null,null,null,null,null,null,null,"Green shade",null,"OK"]
[]
[null,null,null,null,null,null,null,"Red shade",null,"Error"]
[]
[null,null,null,null,null,null,null,"Gold shade",null,"Alert"]
[]
[]
["ABBREVIATIONS"]
[]
[null,null,null,null,null,null,null,"WINEP","Water Industry National Environment Programme"]
[null,null,null,null,null,null,null,"£","Great Britain Pound"]
[null,null,null,null,null,null,null,"m","Million"]
[null,null,null,null,null,null,null,"na","Not available / applicable"]
[null,null,null,null,null,null,null,"#","Number"]
[]
["LIST OF MACROS USED"]
[]
[null,"Store track results"]
[null,null,null,null,null,null,null,"Store track results",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,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,null,null,null,null,null,"Goto macro"]
[]
[null,"Save as PDF"]
[null,null,null,null,null,null,null,"Save as PDF",null,null,null,"This macro helps in saving any worksheet or chart in PDF format."]
[]
[]
[]
[]
["End of sheet"]

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

{"sheet":"WINEP_Inputs","index":4,"n_rows":7,"n_cols":99,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,52,2,67],[2,85,2,91],[1,18,1,19],[1,34,1,51],[2,3,2,33],[2,34,2,38],[2,39,2,40],[2,41,2,48],[2,49,2,50]]}
["WINEP3  Update March 2019",null,null,null,null,null,null,"National Full data set "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FBG Detail"]
["VERSION 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSSI/N2K/Ramsar",null,null,null,null,"Eels",null,"NERC Driver",null,null,null,null,null,null,null,"INNS",null,"MCZ","Water Quality Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Resource Detail",null,null,null,null,null,null,null,null,null,"Environmental Outcome "]
["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","Calc Column 1","Calc Column 2","1 = In plan\n0 = Not in plan","1 = Confirmed\n0 = Not confirmed"]
["EX00001","EXAMPLE - delete this row",null,null,null,"WR","Humber","Yorkshire","Yorkshire Water Service Ltd","XXW000001","Sample Fish Passage","Sample waterbody","GB104027057490","River","Sample",null,null,null,null,null,null,null,null,null,null,"dd/mm/2024","Amber",null,111111,222222,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",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,30000,1,1]
["EX00002","EXAMPLE - delete this row",null,null,null,"FBG","Humber","Yorkshire","Yorkshire Water Service Ltd","XXW000002","Investigation - reservoirs ","Sample","Water Company Scale",null,"Sample",null,null,null,null,null,null,null,null,null,null,"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,null,10000,1,{"$f":" 18 / 20","v":0.9}]
["EX00003","EXAMPLE - delete this row",null,null,null,"WQ","Humber","Yorkshire","Yorkshire Water Service Ltd","XXW000003","Sample STW","Sample waterbody","GB104027057452","River","Sample",null,null,null,null,"Phosphorus",null,null,null,null,null,"dd/mm/2024","Amber",null,111111,222222,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",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,5,1,0]

{"sheet":"Time","index":5,"n_rows":129,"n_cols":20,"rows_kept":129,"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$103","v":"Timeline label"},null,null,null,null,{"$f":" Time!J$103","v":"Pre-Fcst"},{"$f":" Time!K$103","v":"Pre-Fcst"},{"$f":" Time!L$103","v":"Forecast"},{"$f":" Time!M$103","v":"Forecast"},{"$f":" Time!N$103","v":"Forecast"},{"$f":" Time!O$103","v":"Forecast"},{"$f":" Time!P$103","v":"Forecast"},{"$f":" Time!Q$103","v":"Post-Fcst"},{"$f":" Time!R$103","v":"Post-Fcst"},{"$f":" Time!S$103","v":"Post-Fcst"},{"$f":" Time!T$103","v":"Post-Fcst"}]
[null,null,null,null,{"$f":" Time!E$126","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$126","v":2019},{"$f":" Time!K$126","v":2020},{"$f":" Time!L$126","v":2021},{"$f":" Time!M$126","v":2022},{"$f":" Time!N$126","v":2023},{"$f":" Time!O$126","v":2024},{"$f":" Time!P$126","v":2025},{"$f":" Time!Q$126","v":2026},{"$f":" Time!R$126","v":2027},{"$f":" Time!S$126","v":2028},{"$f":" Time!T$126","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$31","v":"Months per model period"},{"$f":"InpActive!F$31","v":12},{"$f":"InpActive!G$31","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$31","v":"Months per model period"},{"$f":"InpActive!F$31","v":12},{"$f":"InpActive!G$31","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":1},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":" U68","v":0}]
[]
[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$126","v":"Financial year ending"},{"$f":" F$126","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 #"]
[]
[]
["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":" I97 + SUM(J94:J96)","v":1},{"$f":" J97 + SUM(K94:K96)","v":1},{"$f":" K97 + SUM(L94:L96)","v":2},{"$f":" L97 + SUM(M94:M96)","v":2},2,2,{"$f":" O97 + SUM(P94:P96)","v":2},{"$f":" P97 + SUM(Q94:Q96)","v":3},{"$f":" Q97 + SUM(R94:R96)","v":3},{"$f":" R97 + SUM(S94:S96)","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$97","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($F99:$F101, J102)","v":"Pre-Fcst"},{"$f":" INDEX($F99:$F101, K102)","v":"Pre-Fcst"},{"$f":" INDEX($F99:$F101, L102)","v":"Forecast"},{"$f":" INDEX($F99:$F101, M102)","v":"Forecast"},{"$f":" INDEX($F99:$F101, N102)","v":"Forecast"},{"$f":" INDEX($F99:$F101, O102)","v":"Forecast"},{"$f":" INDEX($F99:$F101, P102)","v":"Forecast"},{"$f":" INDEX($F99:$F101, Q102)","v":"Post-Fcst"},{"$f":" INDEX($F99:$F101, R102)","v":"Post-Fcst"},{"$f":" INDEX($F99:$F101, S102)","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(J109:T109)","v":0},null,{"$f":" MAX(0, SUM(J106:J108) - 1)","v":0},{"$f":" MAX(0, SUM(K106:K108) - 1)","v":0},{"$f":" MAX(0, SUM(L106:L108) - 1)","v":0},{"$f":" MAX(0, SUM(M106:M108) - 1)","v":0},{"$f":" MAX(0, SUM(N106:N108) - 1)","v":0},0,{"$f":" MAX(0, SUM(P106:P108) - 1)","v":0},{"$f":" MAX(0, SUM(Q106:Q108) - 1)","v":0},{"$f":" MAX(0, SUM(R106:R108) - 1)","v":0},{"$f":" MAX(0, SUM(S106:S108) - 1)","v":0},0]
[null,null,null,null,"Overlapping in periods - total",{"$f":" SUM(J109:T109)","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$110","v":"Overlapping in periods - total"},{"$f":" F$110","v":0},{"$f":" G$110","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(F112:F113) - SUM(F114:F116) <> 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(J125 = 1, $F122, IF(J124 > (DATE(I126, $F123 + 1, 1) - 1), I126 + 1, I126))","v":2019},{"$f":" IF(K125 = 1, $F122, IF(K124 > (DATE(J126, $F123 + 1, 1) - 1), J126 + 1, J126))","v":2020},{"$f":" IF(L125 = 1, $F122, IF(L124 > (DATE(K126, $F123 + 1, 1) - 1), K126 + 1, K126))","v":2021},{"$f":" IF(M125 = 1, $F122, IF(M124 > (DATE(L126, $F123 + 1, 1) - 1), L126 + 1, L126))","v":2022},2023,2024,{"$f":" IF(P125 = 1, $F122, IF(P124 > (DATE(O126, $F123 + 1, 1) - 1), O126 + 1, O126))","v":2025},{"$f":" IF(Q125 = 1, $F122, IF(Q124 > (DATE(P126, $F123 + 1, 1) - 1), P126 + 1, P126))","v":2026},{"$f":" IF(R125 = 1, $F122, IF(R124 > (DATE(Q126, $F123 + 1, 1) - 1), Q126 + 1, Q126))","v":2027},{"$f":" IF(S125 = 1, $F122, IF(S124 > (DATE(R126, $F123 + 1, 1) - 1), R126 + 1, R126))","v":2028},2029]
[]
[]
["End of sheet"]

{"sheet":"InpActive","index":6,"n_rows":41,"n_cols":19,"rows_kept":41,"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!E103","v":"Timeline label"},{"$f":"Check!F3","v":0},"Track chgs",null,null,{"$f":" Time!J$103","v":"Pre-Fcst"},{"$f":" Time!K$103","v":"Pre-Fcst"},{"$f":" Time!L$103","v":"Forecast"},{"$f":" Time!M$103","v":"Forecast"},{"$f":" Time!N$103","v":"Forecast"},{"$f":" Time!O$103","v":"Forecast"},{"$f":" Time!P$103","v":"Forecast"},{"$f":" Time!Q$103","v":"Post-Fcst"},{"$f":" Time!R$103","v":"Post-Fcst"},{"$f":" Time!S$103","v":"Post-Fcst"}]
[null,null,null,null,{"$f":"Time!E126","v":"Financial year ending"},null,null,null,null,{"$f":" Time!J$126","v":2019},{"$f":" Time!K$126","v":2020},{"$f":" Time!L$126","v":2021},{"$f":" Time!M$126","v":2022},{"$f":" Time!N$126","v":2023},{"$f":" Time!O$126","v":2024},{"$f":" Time!P$126","v":2025},{"$f":" Time!Q$126","v":2026},{"$f":" Time!R$126","v":2027},{"$f":" Time!S$126","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"]
[]
["B: 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":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"WINEP_Schemes","index":8,"n_rows":40,"n_cols":13,"rows_kept":40,"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":0},"Track chgs"]
[]
["AMBER WINEP SCHEMES"]
[]
[null,null,"List of WINEP schemes that were unconfirmed at FD"]
[]
[null,null,"WINEPID","Unique ID","Scheme category / name","Unit","Unit Conversion to £m",null,"Allowed totex unit rate","Quantity","1 = In plan\n0 = Not in plan","Proportion Confirmed","Price Control"]
[null,null,{"$f":" WINEP_Inputs!A5","v":"EX00001"},{"$f":" WINEP_Inputs!J5","v":"XXW000001"},{"$f":" WINEP_Inputs!K5","v":"Sample Fish Passage"},"£ per km LORI",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS5","v":30000},{"$f":" WINEP_Inputs!CR5","v":5},{"$f":" WINEP_Inputs!CT5","v":1},{"$f":" WINEP_Inputs!CU5","v":1},"WR"]
[null,null,{"$f":" WINEP_Inputs!A6","v":"EX00002"},{"$f":" WINEP_Inputs!J6","v":"XXW000002"},{"$f":" WINEP_Inputs!K6","v":"Investigation - reservoirs "},"£ per reservoir",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS6","v":10000},20,{"$f":" WINEP_Inputs!CT6","v":1},{"$f":" WINEP_Inputs!CU6","v":0.9},"WR"]
[null,null,{"$f":" WINEP_Inputs!A7","v":"EX00003"},{"$f":" WINEP_Inputs!J7","v":"XXW000003"},{"$f":" WINEP_Inputs!K7","v":"Sample STW"},"£m",1,null,{"$f":" WINEP_Inputs!CS7","v":5},1,{"$f":" WINEP_Inputs!CT7","v":1},{"$f":" WINEP_Inputs!CU7","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A8","v":0},{"$f":" WINEP_Inputs!J8","v":0},{"$f":" WINEP_Inputs!K8","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS8","v":0},1,{"$f":" WINEP_Inputs!CT8","v":0},{"$f":" WINEP_Inputs!CU8","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A9","v":0},{"$f":" WINEP_Inputs!J9","v":0},{"$f":" WINEP_Inputs!K9","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS9","v":0},1,{"$f":" WINEP_Inputs!CT9","v":0},{"$f":" WINEP_Inputs!CU9","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A10","v":0},{"$f":" WINEP_Inputs!J10","v":0},{"$f":" WINEP_Inputs!K10","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS10","v":0},1,{"$f":" WINEP_Inputs!CT10","v":0},{"$f":" WINEP_Inputs!CU10","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A11","v":0},{"$f":" WINEP_Inputs!J11","v":0},{"$f":" WINEP_Inputs!K11","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS11","v":0},1,{"$f":" WINEP_Inputs!CT11","v":0},{"$f":" WINEP_Inputs!CU11","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A12","v":0},{"$f":" WINEP_Inputs!J12","v":0},{"$f":" WINEP_Inputs!K12","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS12","v":0},1,{"$f":" WINEP_Inputs!CT12","v":0},{"$f":" WINEP_Inputs!CU12","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A13","v":0},{"$f":" WINEP_Inputs!J13","v":0},{"$f":" WINEP_Inputs!K13","v":0},"£m",1,null,{"$f":" WINEP_Inputs!CS13","v":0},1,{"$f":" WINEP_Inputs!CT13","v":0},{"$f":" WINEP_Inputs!CU13","v":0},"WR"]
[null,null,{"$f":" WINEP_Inputs!A14","v":0},{"$f":" WINEP_Inputs!J14","v":0},{"$f":" WINEP_Inputs!K14","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS14","v":0},{"$f":" WINEP_Inputs!BI14","v":0},{"$f":" WINEP_Inputs!CT14","v":0},{"$f":" WINEP_Inputs!CU14","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A15","v":0},{"$f":" WINEP_Inputs!J15","v":0},{"$f":" WINEP_Inputs!K15","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS15","v":0},{"$f":" WINEP_Inputs!BI15","v":0},{"$f":" WINEP_Inputs!CT15","v":0},{"$f":" WINEP_Inputs!CU15","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A16","v":0},{"$f":" WINEP_Inputs!J16","v":0},{"$f":" WINEP_Inputs!K16","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS16","v":0},{"$f":" WINEP_Inputs!BI16","v":0},{"$f":" WINEP_Inputs!CT16","v":0},{"$f":" WINEP_Inputs!CU16","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A17","v":0},{"$f":" WINEP_Inputs!J17","v":0},{"$f":" WINEP_Inputs!K17","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS17","v":0},{"$f":" WINEP_Inputs!BI17","v":0},{"$f":" WINEP_Inputs!CT17","v":0},{"$f":" WINEP_Inputs!CU17","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A18","v":0},{"$f":" WINEP_Inputs!J18","v":0},{"$f":" WINEP_Inputs!K18","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS18","v":0},{"$f":" WINEP_Inputs!BI18","v":0},{"$f":" WINEP_Inputs!CT18","v":0},{"$f":" WINEP_Inputs!CU18","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A19","v":0},{"$f":" WINEP_Inputs!J19","v":0},{"$f":" WINEP_Inputs!K19","v":0},"£ per kgP/day removed",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS19","v":0},{"$f":" WINEP_Inputs!BI19","v":0},{"$f":" WINEP_Inputs!CT19","v":0},{"$f":" WINEP_Inputs!CU19","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A20","v":0},{"$f":" WINEP_Inputs!J20","v":0},{"$f":" WINEP_Inputs!K20","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS20","v":0},{"$f":" WINEP_Inputs!BI20","v":0},{"$f":" WINEP_Inputs!CT20","v":0},{"$f":" WINEP_Inputs!CU20","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A21","v":0},{"$f":" WINEP_Inputs!J21","v":0},{"$f":" WINEP_Inputs!K21","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS21","v":0},{"$f":" WINEP_Inputs!BI21","v":0},{"$f":" WINEP_Inputs!CT21","v":0},{"$f":" WINEP_Inputs!CU21","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A22","v":0},{"$f":" WINEP_Inputs!J22","v":0},{"$f":" WINEP_Inputs!K22","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS22","v":0},{"$f":" WINEP_Inputs!BI22","v":0},{"$f":" WINEP_Inputs!CT22","v":0},{"$f":" WINEP_Inputs!CU22","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A23","v":0},{"$f":" WINEP_Inputs!J23","v":0},{"$f":" WINEP_Inputs!K23","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS23","v":0},{"$f":" WINEP_Inputs!BI23","v":0},{"$f":" WINEP_Inputs!CT23","v":0},{"$f":" WINEP_Inputs!CU23","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A24","v":0},{"$f":" WINEP_Inputs!J24","v":0},{"$f":" WINEP_Inputs!K24","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS24","v":0},{"$f":" WINEP_Inputs!BI24","v":0},{"$f":" WINEP_Inputs!CT24","v":0},{"$f":" WINEP_Inputs!CU24","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A25","v":0},{"$f":" WINEP_Inputs!J25","v":0},{"$f":" WINEP_Inputs!K25","v":0},"£m per benefit point",1,null,{"$f":" WINEP_Inputs!CS25","v":0},{"$f":" WINEP_Inputs!BI25","v":0},{"$f":" WINEP_Inputs!CT25","v":0},{"$f":" WINEP_Inputs!CU25","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A26","v":0},{"$f":" WINEP_Inputs!J26","v":0},{"$f":" WINEP_Inputs!K26","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS26","v":0},{"$f":" WINEP_Inputs!BI26","v":0},{"$f":" WINEP_Inputs!CT26","v":0},{"$f":" WINEP_Inputs!CU26","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A27","v":0},{"$f":" WINEP_Inputs!J27","v":0},{"$f":" WINEP_Inputs!K27","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS27","v":0},{"$f":" WINEP_Inputs!BI27","v":0},{"$f":" WINEP_Inputs!CT27","v":0},{"$f":" WINEP_Inputs!CU27","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A28","v":0},{"$f":" WINEP_Inputs!J28","v":0},{"$f":" WINEP_Inputs!K28","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS28","v":0},{"$f":" WINEP_Inputs!BI28","v":0},{"$f":" WINEP_Inputs!CT28","v":0},{"$f":" WINEP_Inputs!CU28","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A29","v":0},{"$f":" WINEP_Inputs!J29","v":0},{"$f":" WINEP_Inputs!K29","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS29","v":0},{"$f":" WINEP_Inputs!BI29","v":0},{"$f":" WINEP_Inputs!CT29","v":0},{"$f":" WINEP_Inputs!CU29","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A30","v":0},{"$f":" WINEP_Inputs!J30","v":0},{"$f":" WINEP_Inputs!K30","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS30","v":0},{"$f":" WINEP_Inputs!BI30","v":0},{"$f":" WINEP_Inputs!CT30","v":0},{"$f":" WINEP_Inputs!CU30","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A31","v":0},{"$f":" WINEP_Inputs!J31","v":0},{"$f":" WINEP_Inputs!K31","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS31","v":0},{"$f":" WINEP_Inputs!BI31","v":0},{"$f":" WINEP_Inputs!CT31","v":0},{"$f":" WINEP_Inputs!CU31","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A32","v":0},{"$f":" WINEP_Inputs!J32","v":0},{"$f":" WINEP_Inputs!K32","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS32","v":0},{"$f":" WINEP_Inputs!BI32","v":0},{"$f":" WINEP_Inputs!CT32","v":0},{"$f":" WINEP_Inputs!CU32","v":0},"WWN"]
[null,null,{"$f":" WINEP_Inputs!A33","v":0},{"$f":" WINEP_Inputs!J33","v":0},{"$f":" WINEP_Inputs!K33","v":0},"£ per p.e.",{"$f":" 1 / InpActive!$F$37","v":9.9999999999999995E-7},null,{"$f":" WINEP_Inputs!CS33","v":0},{"$f":" WINEP_Inputs!BI33","v":0},{"$f":" WINEP_Inputs!CT33","v":0},{"$f":" WINEP_Inputs!CU33","v":0},"WWN"]
[]
["End of sheet"]

{"sheet":"WINEP_Allowance","index":9,"n_rows":57,"n_cols":21,"rows_kept":57,"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":0},"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,"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!I9","v":"Allowed totex unit rate"},{"$f":"  WINEP_Schemes!J9","v":"Quantity"},{"$f":"  WINEP_Schemes!K9","v":"1 = In plan\n0 = Not in plan"},{"$f":"  WINEP_Schemes!L9","v":"Proportion Confirmed"},{"$f":"  WINEP_Schemes!M9","v":"Price Control"},"FD Allowance, £m","Adjusted Allowance, £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!I10","v":30000},{"$f":"  WINEP_Schemes!J10","v":5},{"$f":"  WINEP_Schemes!K10","v":1},{"$f":"  WINEP_Schemes!L10","v":1},{"$f":"  WINEP_Schemes!M10","v":"WR"},{"$f":" I11 * J11 * G11","v":0.15},{"$f":" L11 * N11","v":0.15},{"$f":" IF(K11 = 0, O11, -1 * K11 * (1 - L11) * N11)","v":0},{"$f":" IF($M11 = Q$9, $P11, 0)","v":0},{"$f":" IF($M11 = R$9, $P11, 0)","v":0},0,0,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!I11","v":10000},{"$f":"  WINEP_Schemes!J11","v":20},{"$f":"  WINEP_Schemes!K11","v":1},{"$f":"  WINEP_Schemes!L11","v":0.9},{"$f":"  WINEP_Schemes!M11","v":"WR"},0.19999999999999998,{"$f":" L12 * N12","v":0.18},-1.9999999999999993E-2,{"$f":" IF($M12 = Q$9, $P12, 0)","v":-1.9999999999999993E-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 STW"},{"$f":"  WINEP_Schemes!F12","v":"£m"},{"$f":"  WINEP_Schemes!G12","v":1},{"$f":"  WINEP_Schemes!H12","v":0},{"$f":"  WINEP_Schemes!I12","v":5},{"$f":"  WINEP_Schemes!J12","v":1},{"$f":"  WINEP_Schemes!K12","v":1},{"$f":"  WINEP_Schemes!L12","v":0},{"$f":"  WINEP_Schemes!M12","v":"WWN"},5,0,-5,0,0,-5,0,0]
[null,null,{"$f":"  WINEP_Schemes!C13","v":0},{"$f":"  WINEP_Schemes!D13","v":0},{"$f":"  WINEP_Schemes!E13","v":0},{"$f":"  WINEP_Schemes!F13","v":"£m"},{"$f":"  WINEP_Schemes!G13","v":1},{"$f":"  WINEP_Schemes!H13","v":0},{"$f":"  WINEP_Schemes!I13","v":0},{"$f":"  WINEP_Schemes!J13","v":1},{"$f":"  WINEP_Schemes!K13","v":0},{"$f":"  WINEP_Schemes!L13","v":0},{"$f":"  WINEP_Schemes!M13","v":"WR"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C14","v":0},{"$f":"  WINEP_Schemes!D14","v":0},{"$f":"  WINEP_Schemes!E14","v":0},{"$f":"  WINEP_Schemes!F14","v":"£m"},{"$f":"  WINEP_Schemes!G14","v":1},{"$f":"  WINEP_Schemes!H14","v":0},{"$f":"  WINEP_Schemes!I14","v":0},{"$f":"  WINEP_Schemes!J14","v":1},{"$f":"  WINEP_Schemes!K14","v":0},{"$f":"  WINEP_Schemes!L14","v":0},{"$f":"  WINEP_Schemes!M14","v":"WR"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C15","v":0},{"$f":"  WINEP_Schemes!D15","v":0},{"$f":"  WINEP_Schemes!E15","v":0},{"$f":"  WINEP_Schemes!F15","v":"£m"},{"$f":"  WINEP_Schemes!G15","v":1},{"$f":"  WINEP_Schemes!H15","v":0},{"$f":"  WINEP_Schemes!I15","v":0},{"$f":"  WINEP_Schemes!J15","v":1},{"$f":"  WINEP_Schemes!K15","v":0},{"$f":"  WINEP_Schemes!L15","v":0},{"$f":"  WINEP_Schemes!M15","v":"WR"},0,0,0,{"$f":" IF($M16 = Q$9, $P16, 0)","v":0},{"$f":" IF($M16 = R$9, $P16, 0)","v":0},0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C16","v":0},{"$f":"  WINEP_Schemes!D16","v":0},{"$f":"  WINEP_Schemes!E16","v":0},{"$f":"  WINEP_Schemes!F16","v":"£m"},{"$f":"  WINEP_Schemes!G16","v":1},{"$f":"  WINEP_Schemes!H16","v":0},{"$f":"  WINEP_Schemes!I16","v":0},{"$f":"  WINEP_Schemes!J16","v":1},{"$f":"  WINEP_Schemes!K16","v":0},{"$f":"  WINEP_Schemes!L16","v":0},{"$f":"  WINEP_Schemes!M16","v":"WR"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C17","v":0},{"$f":"  WINEP_Schemes!D17","v":0},{"$f":"  WINEP_Schemes!E17","v":0},{"$f":"  WINEP_Schemes!F17","v":"£m"},{"$f":"  WINEP_Schemes!G17","v":1},{"$f":"  WINEP_Schemes!H17","v":0},{"$f":"  WINEP_Schemes!I17","v":0},{"$f":"  WINEP_Schemes!J17","v":1},{"$f":"  WINEP_Schemes!K17","v":0},{"$f":"  WINEP_Schemes!L17","v":0},{"$f":"  WINEP_Schemes!M17","v":"WR"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C18","v":0},{"$f":"  WINEP_Schemes!D18","v":0},{"$f":"  WINEP_Schemes!E18","v":0},{"$f":"  WINEP_Schemes!F18","v":"£m"},{"$f":"  WINEP_Schemes!G18","v":1},{"$f":"  WINEP_Schemes!H18","v":0},{"$f":"  WINEP_Schemes!I18","v":0},{"$f":"  WINEP_Schemes!J18","v":1},{"$f":"  WINEP_Schemes!K18","v":0},{"$f":"  WINEP_Schemes!L18","v":0},{"$f":"  WINEP_Schemes!M18","v":"WR"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C19","v":0},{"$f":"  WINEP_Schemes!D19","v":0},{"$f":"  WINEP_Schemes!E19","v":0},{"$f":"  WINEP_Schemes!F19","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G19","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H19","v":0},{"$f":"  WINEP_Schemes!I19","v":0},{"$f":"  WINEP_Schemes!J19","v":0},{"$f":"  WINEP_Schemes!K19","v":0},{"$f":"  WINEP_Schemes!L19","v":0},{"$f":"  WINEP_Schemes!M19","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C20","v":0},{"$f":"  WINEP_Schemes!D20","v":0},{"$f":"  WINEP_Schemes!E20","v":0},{"$f":"  WINEP_Schemes!F20","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G20","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H20","v":0},{"$f":"  WINEP_Schemes!I20","v":0},{"$f":"  WINEP_Schemes!J20","v":0},{"$f":"  WINEP_Schemes!K20","v":0},{"$f":"  WINEP_Schemes!L20","v":0},{"$f":"  WINEP_Schemes!M20","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C21","v":0},{"$f":"  WINEP_Schemes!D21","v":0},{"$f":"  WINEP_Schemes!E21","v":0},{"$f":"  WINEP_Schemes!F21","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G21","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H21","v":0},{"$f":"  WINEP_Schemes!I21","v":0},{"$f":"  WINEP_Schemes!J21","v":0},{"$f":"  WINEP_Schemes!K21","v":0},{"$f":"  WINEP_Schemes!L21","v":0},{"$f":"  WINEP_Schemes!M21","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C22","v":0},{"$f":"  WINEP_Schemes!D22","v":0},{"$f":"  WINEP_Schemes!E22","v":0},{"$f":"  WINEP_Schemes!F22","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G22","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H22","v":0},{"$f":"  WINEP_Schemes!I22","v":0},{"$f":"  WINEP_Schemes!J22","v":0},{"$f":"  WINEP_Schemes!K22","v":0},{"$f":"  WINEP_Schemes!L22","v":0},{"$f":"  WINEP_Schemes!M22","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C23","v":0},{"$f":"  WINEP_Schemes!D23","v":0},{"$f":"  WINEP_Schemes!E23","v":0},{"$f":"  WINEP_Schemes!F23","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G23","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H23","v":0},{"$f":"  WINEP_Schemes!I23","v":0},{"$f":"  WINEP_Schemes!J23","v":0},{"$f":"  WINEP_Schemes!K23","v":0},{"$f":"  WINEP_Schemes!L23","v":0},{"$f":"  WINEP_Schemes!M23","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C24","v":0},{"$f":"  WINEP_Schemes!D24","v":0},{"$f":"  WINEP_Schemes!E24","v":0},{"$f":"  WINEP_Schemes!F24","v":"£ per kgP/day removed"},{"$f":"  WINEP_Schemes!G24","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H24","v":0},{"$f":"  WINEP_Schemes!I24","v":0},{"$f":"  WINEP_Schemes!J24","v":0},{"$f":"  WINEP_Schemes!K24","v":0},{"$f":"  WINEP_Schemes!L24","v":0},{"$f":"  WINEP_Schemes!M24","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C25","v":0},{"$f":"  WINEP_Schemes!D25","v":0},{"$f":"  WINEP_Schemes!E25","v":0},{"$f":"  WINEP_Schemes!F25","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G25","v":1},{"$f":"  WINEP_Schemes!H25","v":0},{"$f":"  WINEP_Schemes!I25","v":0},{"$f":"  WINEP_Schemes!J25","v":0},{"$f":"  WINEP_Schemes!K25","v":0},{"$f":"  WINEP_Schemes!L25","v":0},{"$f":"  WINEP_Schemes!M25","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C26","v":0},{"$f":"  WINEP_Schemes!D26","v":0},{"$f":"  WINEP_Schemes!E26","v":0},{"$f":"  WINEP_Schemes!F26","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G26","v":1},{"$f":"  WINEP_Schemes!H26","v":0},{"$f":"  WINEP_Schemes!I26","v":0},{"$f":"  WINEP_Schemes!J26","v":0},{"$f":"  WINEP_Schemes!K26","v":0},{"$f":"  WINEP_Schemes!L26","v":0},{"$f":"  WINEP_Schemes!M26","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C27","v":0},{"$f":"  WINEP_Schemes!D27","v":0},{"$f":"  WINEP_Schemes!E27","v":0},{"$f":"  WINEP_Schemes!F27","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G27","v":1},{"$f":"  WINEP_Schemes!H27","v":0},{"$f":"  WINEP_Schemes!I27","v":0},{"$f":"  WINEP_Schemes!J27","v":0},{"$f":"  WINEP_Schemes!K27","v":0},{"$f":"  WINEP_Schemes!L27","v":0},{"$f":"  WINEP_Schemes!M27","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C28","v":0},{"$f":"  WINEP_Schemes!D28","v":0},{"$f":"  WINEP_Schemes!E28","v":0},{"$f":"  WINEP_Schemes!F28","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G28","v":1},{"$f":"  WINEP_Schemes!H28","v":0},{"$f":"  WINEP_Schemes!I28","v":0},{"$f":"  WINEP_Schemes!J28","v":0},{"$f":"  WINEP_Schemes!K28","v":0},{"$f":"  WINEP_Schemes!L28","v":0},{"$f":"  WINEP_Schemes!M28","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C29","v":0},{"$f":"  WINEP_Schemes!D29","v":0},{"$f":"  WINEP_Schemes!E29","v":0},{"$f":"  WINEP_Schemes!F29","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G29","v":1},{"$f":"  WINEP_Schemes!H29","v":0},{"$f":"  WINEP_Schemes!I29","v":0},{"$f":"  WINEP_Schemes!J29","v":0},{"$f":"  WINEP_Schemes!K29","v":0},{"$f":"  WINEP_Schemes!L29","v":0},{"$f":"  WINEP_Schemes!M29","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C30","v":0},{"$f":"  WINEP_Schemes!D30","v":0},{"$f":"  WINEP_Schemes!E30","v":0},{"$f":"  WINEP_Schemes!F30","v":"£m per benefit point"},{"$f":"  WINEP_Schemes!G30","v":1},{"$f":"  WINEP_Schemes!H30","v":0},{"$f":"  WINEP_Schemes!I30","v":0},{"$f":"  WINEP_Schemes!J30","v":0},{"$f":"  WINEP_Schemes!K30","v":0},{"$f":"  WINEP_Schemes!L30","v":0},{"$f":"  WINEP_Schemes!M30","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C31","v":0},{"$f":"  WINEP_Schemes!D31","v":0},{"$f":"  WINEP_Schemes!E31","v":0},{"$f":"  WINEP_Schemes!F31","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G31","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H31","v":0},{"$f":"  WINEP_Schemes!I31","v":0},{"$f":"  WINEP_Schemes!J31","v":0},{"$f":"  WINEP_Schemes!K31","v":0},{"$f":"  WINEP_Schemes!L31","v":0},{"$f":"  WINEP_Schemes!M31","v":"WWN"},{"$f":" I32 * J32 * G32","v":0},{"$f":" L32 * N32","v":0},{"$f":" IF(K32 = 0, O32, -1 * K32 * (1 - L32) * N32)","v":0},{"$f":" IF($M32 = Q$9, $P32, 0)","v":0},0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C32","v":0},{"$f":"  WINEP_Schemes!D32","v":0},{"$f":"  WINEP_Schemes!E32","v":0},{"$f":"  WINEP_Schemes!F32","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G32","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H32","v":0},{"$f":"  WINEP_Schemes!I32","v":0},{"$f":"  WINEP_Schemes!J32","v":0},{"$f":"  WINEP_Schemes!K32","v":0},{"$f":"  WINEP_Schemes!L32","v":0},{"$f":"  WINEP_Schemes!M32","v":"WWN"},{"$f":" I33 * J33 * G33","v":0},{"$f":" L33 * N33","v":0},{"$f":" IF(K33 = 0, O33, -1 * K33 * (1 - L33) * N33)","v":0},0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C33","v":0},{"$f":"  WINEP_Schemes!D33","v":0},{"$f":"  WINEP_Schemes!E33","v":0},{"$f":"  WINEP_Schemes!F33","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G33","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H33","v":0},{"$f":"  WINEP_Schemes!I33","v":0},{"$f":"  WINEP_Schemes!J33","v":0},{"$f":"  WINEP_Schemes!K33","v":0},{"$f":"  WINEP_Schemes!L33","v":0},{"$f":"  WINEP_Schemes!M33","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C34","v":0},{"$f":"  WINEP_Schemes!D34","v":0},{"$f":"  WINEP_Schemes!E34","v":0},{"$f":"  WINEP_Schemes!F34","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G34","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H34","v":0},{"$f":"  WINEP_Schemes!I34","v":0},{"$f":"  WINEP_Schemes!J34","v":0},{"$f":"  WINEP_Schemes!K34","v":0},{"$f":"  WINEP_Schemes!L34","v":0},{"$f":"  WINEP_Schemes!M34","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C35","v":0},{"$f":"  WINEP_Schemes!D35","v":0},{"$f":"  WINEP_Schemes!E35","v":0},{"$f":"  WINEP_Schemes!F35","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G35","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H35","v":0},{"$f":"  WINEP_Schemes!I35","v":0},{"$f":"  WINEP_Schemes!J35","v":0},{"$f":"  WINEP_Schemes!K35","v":0},{"$f":"  WINEP_Schemes!L35","v":0},{"$f":"  WINEP_Schemes!M35","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C36","v":0},{"$f":"  WINEP_Schemes!D36","v":0},{"$f":"  WINEP_Schemes!E36","v":0},{"$f":"  WINEP_Schemes!F36","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G36","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H36","v":0},{"$f":"  WINEP_Schemes!I36","v":0},{"$f":"  WINEP_Schemes!J36","v":0},{"$f":"  WINEP_Schemes!K36","v":0},{"$f":"  WINEP_Schemes!L36","v":0},{"$f":"  WINEP_Schemes!M36","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C37","v":0},{"$f":"  WINEP_Schemes!D37","v":0},{"$f":"  WINEP_Schemes!E37","v":0},{"$f":"  WINEP_Schemes!F37","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G37","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H37","v":0},{"$f":"  WINEP_Schemes!I37","v":0},{"$f":"  WINEP_Schemes!J37","v":0},{"$f":"  WINEP_Schemes!K37","v":0},{"$f":"  WINEP_Schemes!L37","v":0},{"$f":"  WINEP_Schemes!M37","v":"WWN"},0,0,0,0,0,0,0,0]
[null,null,{"$f":"  WINEP_Schemes!C38","v":0},{"$f":"  WINEP_Schemes!D38","v":0},{"$f":"  WINEP_Schemes!E38","v":0},{"$f":"  WINEP_Schemes!F38","v":"£ per p.e."},{"$f":"  WINEP_Schemes!G38","v":9.9999999999999995E-7},{"$f":"  WINEP_Schemes!H38","v":0},{"$f":"  WINEP_Schemes!I38","v":0},{"$f":"  WINEP_Schemes!J38","v":0},{"$f":"  WINEP_Schemes!K38","v":0},{"$f":"  WINEP_Schemes!L38","v":0},{"$f":"  WINEP_Schemes!M38","v":"WWN"},0,0,0,0,0,0,0,0]
["EXPAND OR REDUCE THE BLOCK ABOVE TO INCLUDE ALL SCHEMES ON THE INPUT SHEET"]
[]
[null,null,null,null,"Total WINEP Reconciliation",{"$f":" P42","v":-5.0199999999999996},"£m",null,null,null,null,null,null,null,null,{"$f":"SUM(P11:P39)","v":-5.0199999999999996},-1.9999999999999993E-2,0,-5,0,0]
[null,null,null,null,"Total WINEP Reconciliation by price control",{"$f":" SUM(Q42:U42)","v":-5.0199999999999996},"£m"]
[]
[null,null,null,null,"Price Control Reconciliation vs Total Reconciliation - check",{"$f":" IF( F43 - F42 > Chk_Tol, 1, 0)","v":0},"check"]
[]
[null,null,null,null,"Total Final Reconciliation, water resources",{"$f":" Q42","v":-1.9999999999999993E-2},"£m"]
[null,null,null,null,"Total Final Reconciliation, water network",{"$f":" R42","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, wastewater network",{"$f":" S42","v":-5},"£m"]
[null,null,null,null,"Total Final Reconciliation, bioresources",{"$f":" T42","v":0},"£m"]
[null,null,null,null,"Total Final Reconciliation, dummy",{"$f":" U42","v":0},"£m"]
[]
[]
[]
[]
[]
["End of sheet"]

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

{"sheet":"Annual_Outputs","index":11,"n_rows":33,"n_cols":11,"rows_kept":33,"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,{"$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!E103","v":"Timeline label"},{"$f":"Check!F3","v":0},"Track chgs",null,{"$f":" Time!N$103","v":"Forecast"},{"$f":" Time!O$103","v":"Forecast"},{"$f":" Time!P$103","v":"Forecast"}]
[null,null,null,null,{"$f":"Time!E126","v":"Financial year ending"},null,null,null,{"$f":" Time!N$126","v":2023},{"$f":" Time!O$126","v":2024},{"$f":" Time!P$126","v":2025}]
[null,null,null,null,{"$f":"Time!E5","v":"Model column counter"},"Total","Unit",null,3,4,5]
[]
["ANNUAL ALLOWED COST"]
[]
["List of Amber Schemes"]
[null,"Calculate the final WINEP reconciliation, £m"]
[]
[null,null,null,null,{"$f":"WINEP_Allowance!E47","v":"Total Final Reconciliation, water resources"},{"$f":"WINEP_Allowance!F47","v":-1.9999999999999993E-2},{"$f":"WINEP_Allowance!G47","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E48","v":"Total Final Reconciliation, water network"},{"$f":"WINEP_Allowance!F48","v":0},{"$f":"WINEP_Allowance!G48","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E49","v":"Total Final Reconciliation, wastewater network"},{"$f":"WINEP_Allowance!F49","v":-5},{"$f":"WINEP_Allowance!G49","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E50","v":"Total Final Reconciliation, bioresources"},{"$f":"WINEP_Allowance!F50","v":0},{"$f":"WINEP_Allowance!G50","v":"£m"}]
[null,null,null,null,{"$f":"WINEP_Allowance!E51","v":"Total Final Reconciliation, dummy"},{"$f":"WINEP_Allowance!F51","v":0},{"$f":"WINEP_Allowance!G51","v":"£m"}]
[]
[null,null,null,null,{"$f":"E12","v":"Total Final Reconciliation, water resources"},{"$f":"F12","v":-1.9999999999999993E-2},"£m",null,{"$f":" $F12 / 3","v":-6.6666666666666645E-3},-6.6666666666666645E-3,-6.6666666666666645E-3]
[null,null,null,null,{"$f":"E13","v":"Total Final Reconciliation, water network"},0,"£m",null,0,0,0]
[null,null,null,null,"Total Final Reconciliation, wastewater network",-5,"£m",null,-1.6666666666666667,-1.6666666666666667,-1.6666666666666667]
[null,null,null,null,"Total Final Reconciliation, bioresources",0,"£m",null,0,0,0]
[null,null,null,null,"Total Final Reconciliation, dummy",0,"£m",null,0,0,0]
[]
[null,null,null,null,"WINEP Reconciliation, water resources",{"$f":"F18","v":-1.9999999999999993E-2},{"$f":"G18","v":"£m"},0,-6.6666666666666645E-3,-6.6666666666666645E-3,-6.6666666666666645E-3]
[null,null,null,null,"WINEP Reconciliation, water network",{"$f":"F19","v":0},"£m",0,0,0,0]
[null,null,null,null,"WINEP Reconciliation, wastewater network",-5,"£m",0,-1.6666666666666667,-1.6666666666666667,-1.6666666666666667]
[null,null,null,null,"WINEP Reconciliation, bioresources",0,"£m",0,0,0,0]
[null,null,null,null,"WINEP Reconciliation, dummy",0,"£m",0,0,0,0]
[]
[]
[]
[]
["End of sheet"]

{"sheet":"F_Outputs","index":12,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR19FM007_WINEP_Out"]
["Acronym","Reference","Item description","Unit","Model","2022-23","2023-24","2024-25"]
[]
[null,"BoN",{"$f":" Annual_Outputs!E24","v":"WINEP Reconciliation, water resources"},"£m","Price Review 2019",{"$f":"Annual_Outputs!I24","v":-6.6666666666666645E-3},{"$f":"Annual_Outputs!J24","v":-6.6666666666666645E-3},{"$f":"Annual_Outputs!K24","v":-6.6666666666666645E-3}]
[null,"BoN",{"$f":" Annual_Outputs!E25","v":"WINEP Reconciliation, water network"},"£m","Price Review 2019",{"$f":"Annual_Outputs!I25","v":0},{"$f":"Annual_Outputs!J25","v":0},{"$f":"Annual_Outputs!K25","v":0}]
[null,"BoN",{"$f":" Annual_Outputs!E26","v":"WINEP Reconciliation, wastewater network"},"£m","Price Review 2019",{"$f":"Annual_Outputs!I26","v":-1.6666666666666667},{"$f":"Annual_Outputs!J26","v":-1.6666666666666667},{"$f":"Annual_Outputs!K26","v":-1.6666666666666667}]
[null,"BoN",{"$f":" Annual_Outputs!E27","v":"WINEP Reconciliation, bioresources"},"£m","Price Review 2019",{"$f":"Annual_Outputs!I27","v":0},{"$f":"Annual_Outputs!J27","v":0},{"$f":"Annual_Outputs!K27","v":0}]
[null,"BoN",{"$f":" Annual_Outputs!E28","v":"WINEP Reconciliation, dummy"},"£m","Price Review 2019",{"$f":"Annual_Outputs!I28","v":0},{"$f":"Annual_Outputs!J28","v":0},{"$f":"Annual_Outputs!K28","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":"[…]02/09/2019 09:55:22"},"[…]02/09/2019 09:55:22","[…]02/09/2019 09:55:22"]
[null,"BoN_QA2","WINEP reconciliation model time stamp","text","Price Review 2019","[…]02/09/2019 09:55:22","[…]02/09/2019 09:55:22","[…]02/09/2019 09:55:22"]
[]
[]
["End of sheet"]

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

{"sheet":"Track","index":14,"n_rows":31,"n_cols":15,"rows_kept":31,"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:J21)","v":0}]
[null,null,null,null,null,{"$f":"J2","v":0},"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$34, 1, 0)","v":0},{"$f":" H9 - INDEX(M9:O9, $J$5)","v":0},{"$f":" IF(ABS(K9) > InpActive!$F$34, 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$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K10) > InpActive!$F$34, IF(INDEX(M10:O10, $J$5) = 0, 0, H10 / INDEX(M10:O10, $J$5) - 1), 0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":" IF(ABS(K11) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K11) > InpActive!$F$34, 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$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K12) > InpActive!$F$34, 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$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K13) > InpActive!$F$34, 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$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K14) > InpActive!$F$34, 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!E24","v":"WINEP Reconciliation, water resources"},{"$f":" Annual_Outputs!F24","v":-1.9999999999999993E-2},{"$f":" Annual_Outputs!G24","v":"£m"},{"$f":" Annual_Outputs!H24","v":0},null,{"$f":" IF(ABS(K15) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K15) > InpActive!$F$34, 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!E25","v":"WINEP Reconciliation, water network"},{"$f":" Annual_Outputs!F25","v":0},{"$f":" Annual_Outputs!G25","v":"£m"},{"$f":" Annual_Outputs!H25","v":0},null,{"$f":" IF(ABS(K16) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K16) > InpActive!$F$34, 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!E26","v":"WINEP Reconciliation, wastewater network"},{"$f":" Annual_Outputs!F26","v":-5},{"$f":" Annual_Outputs!G26","v":"£m"},{"$f":" Annual_Outputs!H26","v":0},null,{"$f":" IF(ABS(K17) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K17) > InpActive!$F$34, 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!E27","v":"WINEP Reconciliation, bioresources"},{"$f":" Annual_Outputs!F27","v":0},{"$f":" Annual_Outputs!G27","v":"£m"},{"$f":" Annual_Outputs!H27","v":0},null,{"$f":" IF(ABS(K18) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K18) > InpActive!$F$34, 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!E28","v":"WINEP Reconciliation, dummy"},{"$f":" Annual_Outputs!F28","v":0},{"$f":" Annual_Outputs!G28","v":"£m"},{"$f":" Annual_Outputs!H28","v":0},null,{"$f":" IF(ABS(K19) > InpActive!$F$34, 1, 0)","v":0},0,{"$f":" IF(ABS(K19) > InpActive!$F$34, IF(INDEX(M19:O19, $J$5) = 0, 0, H19 / INDEX(M19:O19, $J$5) - 1), 0)","v":0},null,0]
[]
["INFO ONLY"]
[]
[null,null,null,null,"Date",null,null,{"$f":" TODAY()","v":"2019-09-02"}]
[null,null,null,null,"Time",null,null,{"$f":" NOW()","v":43710.413450115739}]
[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 v1g.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":15,"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":0},"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!E45","v":"Price Control Reconciliation vs Total Reconciliation - check"},{"$f":"WINEP_Allowance!F45","v":0},{"$f":"WINEP_Allowance!G45","v":"check"}]
[]
[null,"TIME"]
[null,null,null,null,{"$f":"Time!E117","v":"Modelling period check"},{"$f":"Time!F117","v":0},{"$f":"Time!G117","v":"check"}]
[]
[]
[null,null,null,null,"[do not delete row]"]
[]
[null,null,null,null,"Total track changes",{"$f":"Track!J2","v":0}]
[]
[]
["End of sheet"]