{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Enh large schemes>>","Enh large scheme change log","Detailed change log","PCD schemes>>","PCD scheme change log"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", $A$1), LEN(CELL(\"filename\", $A$1)) - SEARCH(\"]\", CELL(\"filename\", $A$1)))","v":"Cover"}]
[]
[null,"PR24 Enhancement schemes change log"]
[]
[null,"Model code:","PR24CA151"]
[null,"Version number:",1]
[null,"File name:",{"$f":" MID(CELL(\"filename\"), FIND(\"[\", CELL(\"filename\"), 1) + 1, FIND(\"]\", CELL(\"filename\"), 1) - FIND(\"[\", CELL(\"filename\"), 1) - 1)","v":"PR24-FD-CA151-Enhancement-schemes-change-log - BRL 2025-26 FINAL.xlsm"}]
[null,"Date:","December 2024"]
[]
[null,"For enquiries please contact:","PR24@ofwat.gov.uk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Contents:"]
[]
[null,"Tab name","Description"]
[null,"Enh large schemes>>","Empty sheet"]
[null,"Enh large scheme change log","Change log for enhnacement large schemes and Gated Allowances"]
[null,"Detailed change log","Detailed change log for enhancement large schemes and Gated Allowances"]
[null,"PCD schemes>>","Empty sheet"]
[null,"PCD scheme change log","Change log for PCD schemes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change log - subsequent to this model being developed we identified the following corrections that we will make for final determinations: "]
[]
[null,"Company","Description of change to be made ","Sheet(s) in current model","Model link(s)"]

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

{"sheet":"Enh large scheme change log","index":2,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,20]]}
[null,"Enhancement large schemes change log",null,null,null,null,null,"Company name"]
[]
[]
[]
[null,null,"Scheme/programme name","Company scheme/programme reference","PCD reference (if applicable)","Initial estimate/ allowance £m","Initial planned start date (year)","Initial planned completion (year)","Change description, including any to addressed risks","Originator","Date recorded","Gate changed occurred in (1,2 or 3 or TMS 0 to 6)","Reason for change","Change to totex estimate £m","Actual expenditure to date £k","Change to programme duration (months)","Revised completion date","External assurance carried out?","Date of external assurance","Assurance acceptance","Assurance comment"]
[]
[null,1]
[null,{"$f":"1+B7","v":2}]
[null,{"$f":"1+B8","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,"Add rows if necessary"]

{"sheet":"Detailed change log","index":3,"n_rows":115,"n_cols":19,"rows_kept":115,"cut":false,"hidden":false,"merged":[[66,1,66,2],[38,1,38,2],[49,1,49,14],[50,1,50,2],[54,1,54,2],[65,1,65,14],[2,12,2,13],[4,3,4,12],[35,1,35,2],[2,1,2,2],[2,4,2,5],[2,6,2,7],[2,9,2,10],[8,1,8,2],[19,1,19,14],[20,1,20,2],[23,1,23,2],[34,1,34,14],[98,1,98,2],[102,1,102,2],[113,1,113,14],[114,1,114,2],[70,1,70,2],[81,1,81,14],[82,1,82,2],[86,1,86,2],[97,1,97,14]]}
[null,"Enhancement large schemes change log",null,null,null,null,"Company name"]
[]
[null,"[Scheme name]",null,"[Company scheme reference]","[Section name & reference or whole scheme]",null,"Initial estimate/ allowance £m (Totex)",null,null,"Initial planned start date (MM/YYYY)",null,null,"Initial planned completion (MM/YYYY)"]
[]
[null,null,"Scheme description & risk mitigation"]
[]
[null,null,"Change description, including any to addressed risks","Company Change Order Reference","Originator","Date Recorded","Reason for change","Change to Opex estimate £m","Change to Capex estimate £m","Actual expenditure to date £k","Change to programme duration (months)","Details of external requirements that impact the programme/ scope/ costs (if applicable)","Change to benefit value or risk reduction","Revised total estimited Totex £m","Revised Completion Date","External assurance carried out?","Date of external assurance","Assurance acceptance","Assurance comment"]
[]
[null,"Gate  0 (TMS only)"]
[null,1]
[null,{"$f":"1+B10","v":2},null,null,"  "]
[null,{"$f":"1+B11","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B9","v":"Total change in Gate  0 (TMS only)"},null,null,null,null,null,{"$f":"SUM(H10:H20)","v":0},{"$f":"SUM(I10:I20)","v":0},{"$f":"SUM(J10:J20)","v":0}]
[]
[]
[null,"Gate 1"]
[null,1]
[null,{"$f":"1+B25","v":2}]
[null,{"$f":"1+B26","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B24","v":"Total change in Gate 1"},null,null,null,null,null,{"$f":"SUM(H25:H35)","v":0},{"$f":"SUM(I25:I35)","v":0},{"$f":"SUM(J25:J35)","v":0}]
[]
[]
[null,"Gate 2"]
[null,1]
[null,{"$f":"1+B40","v":2}]
[null,{"$f":"1+B41","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B39","v":"Total change in Gate 2"},null,null,null,null,null,{"$f":"SUM(H40:H50)","v":0},{"$f":"SUM(I40:I50)","v":0},{"$f":"SUM(J40:J50)","v":0}]
[]
[]
[]
[null,"Gate 3"]
[null,1]
[null,{"$f":"1+B56","v":2}]
[null,{"$f":"1+B57","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B55","v":"Total change in Gate 3"},null,null,null,null,null,{"$f":"SUM(H56:H66)","v":0},{"$f":"SUM(I56:I66)","v":0},{"$f":"SUM(J56:J66)","v":0}]
[]
[]
[]
[null,"Gate 4 (TMS only)"]
[null,1]
[null,{"$f":"1+B72","v":2}]
[null,{"$f":"1+B73","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B71","v":"Total change in Gate 4 (TMS only)"},null,null,null,null,null,{"$f":"SUM(H72:H82)","v":0},{"$f":"SUM(I72:I82)","v":0},{"$f":"SUM(J72:J82)","v":0}]
[]
[]
[]
[null,"Gate 5 (TMS only)"]
[null,1]
[null,{"$f":"1+B88","v":2}]
[null,{"$f":"1+B89","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B87","v":"Total change in Gate 5 (TMS only)"},null,null,null,null,null,{"$f":"SUM(H88:H98)","v":0},{"$f":"SUM(I88:I98)","v":0},{"$f":"SUM(J88:J98)","v":0}]
[]
[]
[]
[null,"Gate 6 (TMS only)"]
[null,1]
[null,{"$f":"1+B104","v":2}]
[null,{"$f":"1+B105","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,"Add rows if necessary"]
[null,{"$f":"\"Total change in \"&B103","v":"Total change in Gate 6 (TMS only)"},null,null,null,null,null,{"$f":"SUM(H104:H114)","v":0},{"$f":"SUM(I104:I114)","v":0},{"$f":"SUM(J104:J114)","v":0}]

{"sheet":"PCD schemes>>","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PCD scheme change log","index":5,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,20]]}
[null,"PCD schemes change log",null,null,null,null,null,"Company name"]
[]
[]
[]
[null,null,"Scheme/programme name","Company scheme/programme reference","PCD reference (if applicable)","Initial estimate/ allowance £m","Initial planned start date (year)","Initial planned completion (year)","Change description, including any to addressed risks","Originator","Date recorded","Gate changed occurred in (1,2 or 3)","Reason for change","Change to totex estimate £m","Actual expenditure to date £k","Change to programme duration (months)","Revised completion date","External assurance carried out?","Date of external assurance","Assurance acceptance","Assurance comment"]
[]
[null,1,"Water WINEP/NEP Investigations","08BW100008a:Water Resources for Peat investigation ","PCDW8",1.8879999999999999,null,"2027-28","Delivery Plan baseline change (blue RAG rating): the line 08BW100008 Water Resources for Peat investigation was removed from the BRL WINEP spreadsheet in November 2024.\n\nThis WINEP scheme was no longer required due to the significant amount of work covered by the North Somerset Councils, North Somerset Levels and Moors Peatland Partnership investigation. It was agreed that Bristol Water would instead be required to increase its engagement and presence at the NSLM partnership meetings. \n\nSee appendix \"BRL ESCLA.1\" (particularly the \"removed\" worksheet) and \"BRL ESCLA.2\" for further evidence of approval from the Environment Agency.\n\n\n"]
[null,{"$f":"1+B7","v":2},"Water WINEP/NEP Investigations","08BW100009a: Chew Stoke Eel Pass Monitoring","PCDW8",1.8879999999999999,null,"2027-28","Non-Delivery Flexibility Request: In 2023, scheme 08BW100009a was placed on the BRL AMP8 WINEP to enable monitoring of an Eel pass that was planned to be installed in AMP7. However in 2024 it was confirmed that the AMP7 Eel Pass installation scheme was deferred to AMP9 therefore there would be no Eel Pass to monitor in AMP8. It was acknowledged by the Environment Agency in June 2024 and also confirmed in October 2025 that the scheme would be deferred. Our view is that funding would still likely be required in AMP9, but the scheme cannot be completed in AMP8. A non-delivery flexibility request is therefore more appropriate than a request for a revision to the Delivery Plan baseline.  \n\nSee appendix \"BRL ESCLA.1\"  (particularly the \"removed\" worksheet) and \"BRL ESCLA.3\" for further evidence of approval from the Environment Agency."]
[null,{"$f":"1+B8","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,"Add rows if necessary"]