{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Conceptual model","Inputs >>","BPT input","Data","Override","Final data","ANALYSIS>","Phase 1","Phase 2","Unit cost","Phase 3","Allowance","F_Outputs"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1600,"comments":0,"pivot_tables":1},"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":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Cover"]
[]
[null,"Water net zero"]
[]
[null,"Model code:","PR24CA44"]
[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":{"$error":"#VALUE!"}}]
[null,"Date:","2024-12-19"]
[]
[null,"For enquiries please contact:","PR24@ofwat.gov.uk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sheet","Description"]
[null,"Inputs"]
[null,"PR24_BP","Inputs from PR24 business plan data tables"]
[null,"Consolidated inputs"]
[null,"Data","Key input data from PR24_BP required for model and assessment"]
[null,"Override","Overrides to input sheet with explanation"]
[null,"Final data","Input data after overrides"]
[null,"Analysis"]
[null,"Phase 1 ","Written scheme level assessment "]
[null,"Phase 2 ","Written scheme level assessment "]
[null,"Unit cost","Written assessment of process emissions"]
[null,"Phase 3","Written scheme level unit cost assessment"]
[null,"Outputs"]
[null,"Allowances","Calculated allowances"]

{"sheet":"Conceptual model","index":1,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":{"$error":"#VALUE!"}}]
[]
["Conceptual model "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End of sheet"]

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

{"sheet":"BPT input","index":3,"n_rows":34,"n_cols":38,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,37,3,37],[3,8,3,10],[3,11,3,13],[3,14,3,16],[3,17,3,19],[3,20,3,22],[3,23,3,27]]}
[]
[null,null,"Scheme ID","Scheme name","Scheme description","Selected or Feasible","Units","DPs",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,21,22,23,24,25,null,26,null,"PR24 BP reference"]
[null,null,null,null,null,null,null,null,"Scheme Capex","Scheme Opex","Scheme Totex","Scheme Capex","Scheme Opex","Scheme Totex","Scheme Capex","Scheme Opex","Scheme Totex","Scheme Capex","Scheme Opex","Scheme Totex","Scheme Capex","Scheme Opex","Scheme Totex","AMP8  Capex Total","AMP8  Opex Total","AMP8  Totex Total","Water Resources costs (% of AMP 8 Totex)","Water Network + costs (% of AMP 8 Totex)",null,"Scheme benefits (cumulative impact on tCO2e)","Scheme benefits (cumulative impact on tCO2e)","Scheme benefits (cumulative impact on tCO2e)","Scheme benefits (cumulative impact on tCO2e)","Scheme benefits (cumulative impact on tCO2e)",null,"Overall scheme impact on total greehouse gas emissions  (total impact on tCO2e)"]
["Company","Date of BPT",null,null,null,null,null,null,"2025-26",null,null,"2026-27",null,null,"2027-28",null,null,"2028-29",null,null,"2029-30",null,null,"2025-30",null,null,null,null,null,"2025-26","2026-27","2027-28","2028-29","2029-30",null,"2029-30"]
["ANH","2024-01-25","CW21.1","AMP8 Small Scale Solar Delivery WS","WS Mounted Panels","Feasible","£m",3,2.0169999999999999,0,2.0169999999999999,2.0169999999999999,-0.24,1.7769999999999999,2.0169999999999999,-0.48099999999999998,1.536,2.0169999999999999,-0.72099999999999997,1.296,2.0169999999999999,-0.96199999999999997,1.0549999999999999,10.085000000000001,-2.4039999999999999,7.681,0,100,null,0,-454.48,-1363.74,-2727.48,-4545.8,null,-3045.8,null,"CW19.1"]
["AFW","2024-02-08","AFW_EV","Net Zero: Electric Vehicles","To replace all operational liveried diesel vehicles with electric vehicles with an aim to remove 1920 TC02e operational carbon per year (the amount emitted by the current diesel vehicles fleet) by the end of AMP 8.","Selected","£m",3,0.91200000000000003,7.8E-2,0.99,0.96599999999999997,0.13400000000000001,1.1000000000000001,0.83599999999999997,0.17799999999999999,1.014,0.434,0.186,0.62,0.33500000000000002,0.24299999999999999,0.57799999999999996,3.4830000000000001,0.81899999999999995,4.3019999999999996,10,90,null,-322.60000000000002,-937,-1858.6,-3087.4,-4700.2,null,-4135.732,null,"CW19.1"]
["HDD","2024-02-15",null,"EV & low carbon alternative fuels & charge points",null,"Select from Dropdown","£m",3,0.193,0.11899999999999999,0.312,null,0.14799999999999999,0.14799999999999999,null,0.16900000000000001,0.16900000000000001,null,0.24299999999999999,0.24299999999999999,null,0.27500000000000002,0.27500000000000002,0.193,0.95299999999999996,1.145,50,50,null,-236.566,-288.077,-328.29399999999998,-517.76599999999996,-563.82000000000005,null,516.25,null,"CW19.1"]
["HDD","2024-02-15",null,"Heat decarbonisation",null,"Select from Dropdown","£m",3,1.4999999999999999E-2,null,1.4999999999999999E-2,null,null,0,null,null,0,null,null,0,null,null,0,1.4999999999999999E-2,0,1.4999999999999999E-2,50,50,null,null,-2.093,-4.1859999999999999,-6.2789999999999999,-8.3729999999999993,null,-8.0830000000000002,null,"CW19.2"]
["SEW","2024-01-31",null,"Ozone upgrade at Barcombe","Upgrade of the current air-fed ozone treatment plant at Barcombe to a liquid oxygen fed ozone treatment plant. This will drastically reduce plant emissions, energy usage and reduce operating costs.","Selected","£m",3,0.153,0,0.153,0.39900000000000002,0,0.39900000000000002,1.258,0,1.258,1.258,0,1.258,0,9.9000000000000005E-2,9.9000000000000005E-2,3.069,9.9000000000000005E-2,3.1680000000000001,0,100,null,0,0,0,0,-573,null,464,null,"CW19.1"]
["SEW","2024-01-31",null,"Ozone upgrade at Arlington","Upgrade of the current air-fed ozone treatment plant at Arlington to a liquid oxygen fed ozone treatment plant. This will drastically reduce plant emissions, energy usage and reduce operating costs.","Selected","£m",3,5.8999999999999997E-2,0,5.8999999999999997E-2,0.154,0,0.154,0.48599999999999999,0,0.48599999999999999,0.48599999999999999,0,0.48599999999999999,0,3.5999999999999997E-2,3.5999999999999997E-2,1.1850000000000001,3.5999999999999997E-2,1.22,0,100,null,0,0,0,0,-114,null,272,null,"CW19.2"]
["SEW","2024-01-31",null,"Power resilience (generators)","Upgrading existing backup diesel generators with hybrid generators to reduce carbon equivalent emissions. Hybrid generators involve a combination of diesel and battery technologies.","Selected","£m",3,0.16,0,0.16,0.16,0,0.16,0.107,0,0.107,0.107,0,0.107,0,0,0,0.53400000000000003,0,0.53400000000000003,0,100,null,-169,-338,-508,-677,-846,null,-689,null,"CW19.3"]
["SEW","2024-01-31",null,"Transport offset (Electrifying fleet)","Procurement of a new fleet of electric vehicles to reduce company carbon equivalent emissions. A total of 227 vehicles will be procured across AMP8.","Selected","£m",3,1.605,0,1.605,1.47,0,1.47,1.9139999999999999,0,1.9139999999999999,1.337,0,1.337,1.881,0,1.881,8.2070000000000007,0,8.2070000000000007,0,100,null,-181,-423,-707,-888,-1371,null,2548,null,"CW19.4"]
["SSC","2024-02-16","SSC_CW21_1","Renewable electricity behind the meter assets ","Ground mounted Solar PV at four key sites including two water treatment works","Selected","£m",3,0,0,0,0,0,0,1.758,0,1.758,5.4779999999999998,0,5.4779999999999998,0,0,0,7.2370000000000001,0,7.2370000000000001,0,1,null,0,0,0,-297.262,-1551.2619999999999,null,-993.26199999999994,null,"CW19.1"]
["SVE","2024-02-15","NZ#1w","EV Charging Infrastructure","EV charge points - Included in our Net Zero Challenge Fund Investment Case","Selected","£m",3,0,0,0,0.88,0,0.88,0,0,0,0,0,0,0,0,0,0.88,0,0.88,50,50,null,0,0,-380.6,-1141.8,-2283.6,null,-2262.59,null,"CW19.1"]
["SVE","2024-02-15","NZ#2w","Heat pumps","Replacement of fossil fuel boilers with heat pumps for space heating - Included in our Net Zero Challenge Fund Investment Case","Selected","£m",3,8.0640000000000001,0,8.0640000000000001,0,0,0,0,-7.2999999999999995E-2,-7.2999999999999995E-2,0,-0.11,-0.11,0,-0.11,-0.11,8.0640000000000001,-0.29299999999999998,7.7709999999999999,50,50,null,0,0,-465,-1395,-2790,null,-2687.57,null,"CW19.2"]
["SVE","2024-02-15","NZ#3w","HVO diesel replacement","Infrastructure to enable replacement of mineral diesel with HVO - Included in our Net Zero Challenge Fund Investment Case","Selected","£m",3,0.33100000000000002,0,0.33100000000000002,0,0,0,0,0,0,0,0,0,0,0,0,0.33100000000000002,0,0.33100000000000002,50,50,null,0,0,-693,-2079,-4158,null,-2486,null,"CW19.3"]
["SVE","2024-02-15","NZ#4w","Hydrogen Production","Production of hydrogen by electrolysis of high strength liquors - Not included in our Investment Cases, we consider this to be base expenditure if economic.","Feasible","£m",3,0.55000000000000004,0,0.55000000000000004,0.55000000000000004,0,0.55000000000000004,0.55000000000000004,-0.26,0.28999999999999998,0.55000000000000004,-0.26,0.28999999999999998,0.55000000000000004,-0.26,0.28999999999999998,2.75,-0.78,1.97,50,50,null,0,0,-985.6,-1971.2,-2956.8,null,-2720.9789999999998,null,"CW19.4"]
["SVE","2024-02-15","NZ#5w","Electrical storage","Behind the meter battery storage  - Not included in our Investment Cases, we consider this to be base expenditure if economic.","Feasible","£m",3,1.21,0,1.21,1.21,0,1.21,1.21,-0.504,0.70599999999999996,1.21,-0.504,0.70599999999999996,1.21,-0.504,0.70599999999999996,6.05,-1.512,4.5380000000000003,50,50,null,"-   "," -   ",-40.15,-80.3,-120.45,null,398.35599999999999,null,"CW19.5"]
["SVE","2024-02-15","NZ#6w","EV fleet only","EV vehicles - Not included in our Investment Cases, we consider vehicle replacement to be part of base expenditure but note that there is a cost premium for electric vehicles.","Feasible","£m",3,0.80300000000000005,0,0.80300000000000005,0.80300000000000005,0,0.80300000000000005,0.80300000000000005,0,0.80300000000000005,0.80300000000000005,0,0.80300000000000005,0.80300000000000005,0,0.80300000000000005,4.0149999999999997,0,4.0149999999999997,50,50,null,0,-381,-1142,-2284,-3806,null,-3461.701,null,"CW19.6"]
["SVE","2024-02-15","NZ#7w","HVO fuel only","HVO (marginal cost of fuel only) - Not included in our Investment Cases, we consider this to be base expenditure but note that there is a cost premium for HVO fuel.","Feasible","£m",3,0,0.44,0.44,0,0.44,0.44,0,0.44,0.44,0,0.44,0.44,0,0.44,0.44,0,2.2000000000000002,2.2000000000000002,50,50,null,-2776.4,-5552.8,-8329.2000000000007,-11105.6,-13882,null,-13693.343000000001,null,"CW19.7"]
["SVE","2024-02-15","NZ#8w","Solar PV","Solar PV (other than very small scale) - Not included in our Investment Cases, we consider this to be base expenditure if economic.","Feasible","£m",3,2.86,0,2.86,2.86,0,2.86,2.86,-3.2090000000000001,-0.34899999999999998,2.86,-3.2090000000000001,-0.34899999999999998,2.86,-3.2090000000000001,-0.34899999999999998,14.3,-9.6270000000000007,4.673,50,50,null,0,0,-3208.788,-6417.576,-9626.3639999999996,null,-8400.0939999999991,null,"CW19.8"]
["TMS","2023-12-08","CW21_1","S40840/2 (PR24 Fleet - Life expired Enhancement (cost to convert to electrical) (Water))","Costs above base of converting life-expired transport to electric or alternative fuelled vehicle.","Feasible","£m",3,4.8529999999999998,-0.375,4.4779999999999998,4.4180000000000001,-0.39900000000000002,4.0190000000000001,3.5790000000000002,-0.42799999999999999,3.1509999999999998,2.6080000000000001,-0.47499999999999998,2.133,0.76800000000000002,-0.67500000000000004,9.2999999999999999E-2,16.225999999999999,-2.3519999999999999,13.874000000000001,0,1,null,-808,-2100,-3847,-6094,-8762,null,1377,null,"CW19.1"]
["TMS","2023-12-08","CW21_2","S40142/2 (PR24 Hybrid air source heat pump/existing boiler for 4 corporate offices (Water))","Lower GHG emission hybrid heating at four corporate offices","Feasible","£m",3,0.40600000000000003,-2E-3,0.40400000000000003,0.40799999999999997,-5.3999999999999999E-2,0.35399999999999998,0,-3.5999999999999997E-2,-3.5999999999999997E-2,0,-2.4E-2,-2.4E-2,0,-1.7000000000000001E-2,-1.7000000000000001E-2,0.81399999999999995,-0.13300000000000001,0.68100000000000005,0,1,null,-132.5,-397.52,-662.54,-927.56,-1192.58,null,-1703.58,null,"CW19.2"]
["TMS","2023-12-08","CW21_3","S40144/2 (PR24 Air source heat pump for site office (enhancement cost) (Water))","Lower GHG emission heating for life-expired site office boilers","Feasible","£m",3,0.33400000000000002,3.0000000000000001E-3,0.33700000000000002,0.33500000000000002,1.4999999999999999E-2,0.35,0.33700000000000002,2.7E-2,0.36399999999999999,0.33800000000000002,0.04,0.378,0.34,5.3999999999999999E-2,0.39400000000000002,1.6839999999999999,0.13900000000000001,1.823,0,1,null,-33.33,-100,-200.04,-333.39,-500.06,null,-241.81,null,"CW19.3"]
["NWT","2024-02-19","E00001340","Transport fossil fuel reductions - Green fleet LCVs phase 1","Procuring zero emission (Electric Vehicle, EV) cars & vans","Selected","£m",3,0.90900000000000003,-7.3999999999999996E-2,0.83399999999999996,1.155,-0.28799999999999998,0.86699999999999999,2.2919999999999998,-0.63300000000000001,1.659,1.974,-0.995,0.97899999999999998,0,-1.1990000000000001,-1.1990000000000001,6.33,-3.1890000000000001,3.141,3.5999999999999997E-2,0.315,null,-182.74199999999999,-776.65099999999995,-2055.8420000000001,-4179.2979999999998,-6690.1670000000004,null,-6690.1670000000004,null,"CW19.1"]
["NWT","2024-02-19","E00001341","Transport fossil fuel reductions - Green fleet LCVs phase 2 ","Procuring zero emission (Electric Vehicle, EV) cars & vans","Selected","£m",3,1.069,-2.5999999999999999E-2,1.0429999999999999,1.3580000000000001,-9.9000000000000005E-2,1.2589999999999999,2.6960000000000002,-0.219,2.4769999999999999,2.3210000000000002,-0.34399999999999997,1.9770000000000001,0,-0.41499999999999998,-0.41499999999999998,7.444,-1.1020000000000001,6.3410000000000002,3.5999999999999997E-2,0.315,null,-63.180999999999997,-268.51900000000001,-710.78599999999994,-1444.9480000000001,-2313.0549999999998,null,-2313.0549999999998,null,"CW19.2"]
["NWT","2024-02-19","E00001344","Peatland restoration","Habitat restoration works across 1494 hectares of peatland by 2030, verified by Natural England (or equivalent standard). ","Selected","£m",3,2.0179999999999998,0,2.0179999999999998,5.5419999999999998,0,5.5419999999999998,5.5010000000000003,0,5.5010000000000003,5.5869999999999997,0,5.5869999999999997,1.857,0,1.857,20.504999999999999,0,20.504999999999999,0,1,null,0,0,0,0,-13227,null,-13227,null,"CW19.3"]
["NWT","2024-02-19","E00001345","Woodland creation","Creation of 465 hectares of woodland from planting trees by 2030, verified by the Woodland Carbon Code (or equivalent standard). ","Selected","£m",3,0.84299999999999997,0,0.84299999999999997,0.85799999999999998,0,0.85799999999999998,0.84499999999999997,0,0.84499999999999997,0,0,0,0,0,0,2.5459999999999998,0,2.5459999999999998,0,1,null,0,0,-427.01499999999999,-854.03,-1662.633,null,-1662.633,null,"CW19.4"]
["NWT","2024-02-19","E00001346","Property emissions reductions ","Decarbonising heat within our UUW owned property portfolio, focused at moving away from fossil fuel usage. ","Selected","£m",3,1.206,0,1.206,0,0,0,0,0,0,0,0,0,0,0,0,1.206,0,1.206,0,0.33300000000000002,null,-408.28399999999999,-816.56899999999996,-1224.8530000000001,-1633.1379999999999,-2041.422,null,-1994.413,null,"CW19.5"]
["NWT","2024-02-19","E00001426","Phase 2 – Further low regrets emissions reductions in AMP8","Development of a net zero catchment strategy for St Cuthbert's garden village development to support the new WwTw in Carlisle, facilating the expected population growth","Selected","£m",3,0,0,0,0,0,0,7.61,0,7.61,7.7270000000000003,0,7.7270000000000003,7.702,0,7.702,23.039000000000001,0,23.039000000000001,7.0000000000000001E-3,0.26900000000000002,null,0,0,-5021.1040000000003,-10042.207,-15063.311,null,-14732.26,null,"CW19.6"]
["WSH","2024-02-09","CW21_1","Net Zero Carbon Strategy:  Network Control Systems (Water)","Delivery of a new Network Control System for Water to reduce energy consumption by using factors such as weather and demand patterns to predict optimum set points, and as a result, control and optimise pumping regimes","Selected","£m",3,0.17399999999999999,-4.2000000000000003E-2,0.13200000000000001,0.39400000000000002,-9.7000000000000003E-2,0.29699999999999999,0.39400000000000002,-9.7000000000000003E-2,0.29699999999999999,0.41399999999999998,-0.10100000000000001,0.313,0.34899999999999998,-8.4000000000000005E-2,0.26500000000000001,1.7250000000000001,-0.42099999999999999,1.304,0,100,null,-50,-165,-285,-400,-500,null,-360,null,"CW19.1"]
["WSH","2024-02-09","CW21_2","Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)","Restoration of degraded peatland and creation of new woodland to offset carbon emissions","Selected","£m",3,5.0599999999999996,0,5.0599999999999996,5.0599999999999996,0,5.0599999999999996,5.0599999999999996,0,5.0599999999999996,5.0599999999999996,0,5.0599999999999996,5.0599999999999996,0,5.0599999999999996,25.3,0,25.3,100,0,null,0,0,0,0,0,null,0,null,"CW19.2"]
["WSX","2024-02-05","CW21_1","Transport","Decarbonised Fleet Infrastructure","Selected","£m",3,0.39400000000000002,0,0.39500000000000002,0.63400000000000001,1E-3,0.63500000000000001,0.79700000000000004,3.0000000000000001E-3,0.8,0.80100000000000005,5.0000000000000001E-3,0.80500000000000005,0.41299999999999998,8.0000000000000002E-3,0.42099999999999999,3.04,1.6E-2,3.056,null,null,null,null,null,null,null,null,null,1664.1,null,"CW19.3"]
["YKY","2024-01-25","CW21-1","Solar ","Combination of rooftop and groundmount solar on YW sites.","Selected","£m",3,3.883,0,3.883,4.7770000000000001,-0.42,4.3570000000000002,4.3079999999999998,-1.2769999999999999,3.0310000000000001,2.431,-2.1339999999999999,0.29699999999999999,1.6579999999999999,-2.4289999999999998,-0.77100000000000002,17.056000000000001,-6.26,10.795999999999999,50,50,null,0,-1000,-2000,-3000,-3500,null,-3000,null,"CW19.1"]

{"sheet":"Data","index":4,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Consolidated data"]
[]
[]
[null,null,"Company","Scheme ID","Scheme name","Selected or Feasible","Totex 2025-26","Totex 2026-27","Totex 2027-28","Totex 2028-29","Totex 2029-30","AMP8 totex (£m, 2025-30)","Carbon benefits (cumulated) 2025-26","Carbon benefits (cumulated) 2026-27","Carbon benefits (cumulated) 2027-28","Carbon benefits (cumulated) 2028-29","Carbon benefits (cumulated) 2029-30","Scheme benefits (tCO2e cumulative, 2029-30)"]
[null,1,{"$f":"'BPT input'!A5","v":"ANH"},{"$f":"'BPT input'!C5","v":"CW21.1"},{"$f":"'BPT input'!D5","v":"AMP8 Small Scale Solar Delivery WS"},{"$f":"_xlfn.IFS('BPT input'!F5=\"Selected\", 'BPT input'!F5, 'BPT input'!F5=\"Feasible\",'BPT input'!F5, 'BPT input'!F5=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K5","v":2.0169999999999999},{"$f":"'BPT input'!N5","v":1.7769999999999999},{"$f":"'BPT input'!Q5","v":1.536},{"$f":"'BPT input'!T5","v":1.296},{"$f":"'BPT input'!W5","v":1.0549999999999999},{"$f":"'BPT input'!Z5","v":7.681},{"$f":"'BPT input'!AD5","v":0},{"$f":"'BPT input'!AE5","v":-454.48},{"$f":"'BPT input'!AF5","v":-1363.74},{"$f":"'BPT input'!AG5","v":-2727.48},{"$f":"'BPT input'!AH5","v":-4545.8},{"$f":"'BPT input'!AH5","v":-4545.8}]
[null,2,{"$f":"'BPT input'!A6","v":"AFW"},{"$f":"'BPT input'!C6","v":"AFW_EV"},{"$f":"'BPT input'!D6","v":"Net Zero: Electric Vehicles"},{"$f":"_xlfn.IFS('BPT input'!F6=\"Selected\", 'BPT input'!F6, 'BPT input'!F6=\"Feasible\",'BPT input'!F6, 'BPT input'!F6=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K6","v":0.99},{"$f":"'BPT input'!N6","v":1.1000000000000001},{"$f":"'BPT input'!Q6","v":1.014},{"$f":"'BPT input'!T6","v":0.62},{"$f":"'BPT input'!W6","v":0.57799999999999996},{"$f":"'BPT input'!Z6","v":4.3019999999999996},{"$f":"'BPT input'!AD6","v":-322.60000000000002},{"$f":"'BPT input'!AE6","v":-937},{"$f":"'BPT input'!AF6","v":-1858.6},{"$f":"'BPT input'!AG6","v":-3087.4},{"$f":"'BPT input'!AH6","v":-4700.2},{"$f":"'BPT input'!AH6","v":-4700.2}]
[null,3,{"$f":"'BPT input'!A7","v":"HDD"},{"$f":"'BPT input'!C7","v":0},{"$f":"'BPT input'!D7","v":"EV & low carbon alternative fuels & charge points"},{"$f":"_xlfn.IFS('BPT input'!F7=\"Selected\", 'BPT input'!F7, 'BPT input'!F7=\"Feasible\",'BPT input'!F7, 'BPT input'!F7=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K7","v":0.312},{"$f":"'BPT input'!N7","v":0.14799999999999999},{"$f":"'BPT input'!Q7","v":0.16900000000000001},{"$f":"'BPT input'!T7","v":0.24299999999999999},{"$f":"'BPT input'!W7","v":0.27500000000000002},{"$f":"'BPT input'!Z7","v":1.145},{"$f":"'BPT input'!AD7","v":-236.566},{"$f":"'BPT input'!AE7","v":-288.077},{"$f":"'BPT input'!AF7","v":-328.29399999999998},{"$f":"'BPT input'!AG7","v":-517.76599999999996},{"$f":"'BPT input'!AH7","v":-563.82000000000005},{"$f":"'BPT input'!AH7","v":-563.82000000000005}]
[null,4,{"$f":"'BPT input'!A8","v":"HDD"},{"$f":"'BPT input'!C8","v":0},{"$f":"'BPT input'!D8","v":"Heat decarbonisation"},{"$f":"_xlfn.IFS('BPT input'!F8=\"Selected\", 'BPT input'!F8, 'BPT input'!F8=\"Feasible\",'BPT input'!F8, 'BPT input'!F8=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K8","v":1.4999999999999999E-2},{"$f":"'BPT input'!N8","v":0},{"$f":"'BPT input'!Q8","v":0},{"$f":"'BPT input'!T8","v":0},{"$f":"'BPT input'!W8","v":0},{"$f":"'BPT input'!Z8","v":1.4999999999999999E-2},{"$f":"'BPT input'!AD8","v":0},{"$f":"'BPT input'!AE8","v":-2.093},{"$f":"'BPT input'!AF8","v":-4.1859999999999999},{"$f":"'BPT input'!AG8","v":-6.2789999999999999},{"$f":"'BPT input'!AH8","v":-8.3729999999999993},{"$f":"'BPT input'!AH8","v":-8.3729999999999993}]
[null,5,{"$f":"'BPT input'!A9","v":"SEW"},{"$f":"'BPT input'!C9","v":0},{"$f":"'BPT input'!D9","v":"Ozone upgrade at Barcombe"},{"$f":"_xlfn.IFS('BPT input'!F9=\"Selected\", 'BPT input'!F9, 'BPT input'!F9=\"Feasible\",'BPT input'!F9, 'BPT input'!F9=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K9","v":0.153},{"$f":"'BPT input'!N9","v":0.39900000000000002},{"$f":"'BPT input'!Q9","v":1.258},{"$f":"'BPT input'!T9","v":1.258},{"$f":"'BPT input'!W9","v":9.9000000000000005E-2},{"$f":"'BPT input'!Z9","v":3.1680000000000001},{"$f":"'BPT input'!AD9","v":0},{"$f":"'BPT input'!AE9","v":0},{"$f":"'BPT input'!AF9","v":0},{"$f":"'BPT input'!AG9","v":0},{"$f":"'BPT input'!AH9","v":-573},{"$f":"'BPT input'!AH9","v":-573}]
[null,6,{"$f":"'BPT input'!A10","v":"SEW"},{"$f":"'BPT input'!C10","v":0},{"$f":"'BPT input'!D10","v":"Ozone upgrade at Arlington"},{"$f":"_xlfn.IFS('BPT input'!F10=\"Selected\", 'BPT input'!F10, 'BPT input'!F10=\"Feasible\",'BPT input'!F10, 'BPT input'!F10=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K10","v":5.8999999999999997E-2},{"$f":"'BPT input'!N10","v":0.154},{"$f":"'BPT input'!Q10","v":0.48599999999999999},{"$f":"'BPT input'!T10","v":0.48599999999999999},{"$f":"'BPT input'!W10","v":3.5999999999999997E-2},{"$f":"'BPT input'!Z10","v":1.22},{"$f":"'BPT input'!AD10","v":0},{"$f":"'BPT input'!AE10","v":0},{"$f":"'BPT input'!AF10","v":0},{"$f":"'BPT input'!AG10","v":0},{"$f":"'BPT input'!AH10","v":-114},{"$f":"'BPT input'!AH10","v":-114}]
[null,7,{"$f":"'BPT input'!A11","v":"SEW"},{"$f":"'BPT input'!C11","v":0},{"$f":"'BPT input'!D11","v":"Power resilience (generators)"},{"$f":"_xlfn.IFS('BPT input'!F11=\"Selected\", 'BPT input'!F11, 'BPT input'!F11=\"Feasible\",'BPT input'!F11, 'BPT input'!F11=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K11","v":0.16},{"$f":"'BPT input'!N11","v":0.16},{"$f":"'BPT input'!Q11","v":0.107},{"$f":"'BPT input'!T11","v":0.107},{"$f":"'BPT input'!W11","v":0},{"$f":"'BPT input'!Z11","v":0.53400000000000003},{"$f":"'BPT input'!AD11","v":-169},{"$f":"'BPT input'!AE11","v":-338},{"$f":"'BPT input'!AF11","v":-508},{"$f":"'BPT input'!AG11","v":-677},{"$f":"'BPT input'!AH11","v":-846},{"$f":"'BPT input'!AH11","v":-846}]
[null,8,{"$f":"'BPT input'!A12","v":"SEW"},{"$f":"'BPT input'!C12","v":0},{"$f":"'BPT input'!D12","v":"Transport offset (Electrifying fleet)"},{"$f":"_xlfn.IFS('BPT input'!F12=\"Selected\", 'BPT input'!F12, 'BPT input'!F12=\"Feasible\",'BPT input'!F12, 'BPT input'!F12=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K12","v":1.605},{"$f":"'BPT input'!N12","v":1.47},{"$f":"'BPT input'!Q12","v":1.9139999999999999},{"$f":"'BPT input'!T12","v":1.337},{"$f":"'BPT input'!W12","v":1.881},{"$f":"'BPT input'!Z12","v":8.2070000000000007},{"$f":"'BPT input'!AD12","v":-181},{"$f":"'BPT input'!AE12","v":-423},{"$f":"'BPT input'!AF12","v":-707},{"$f":"'BPT input'!AG12","v":-888},{"$f":"'BPT input'!AH12","v":-1371},{"$f":"'BPT input'!AH12","v":-1371}]
[null,9,{"$f":"'BPT input'!A13","v":"SSC"},{"$f":"'BPT input'!C13","v":"SSC_CW21_1"},{"$f":"'BPT input'!D13","v":"Renewable electricity behind the meter assets "},{"$f":"_xlfn.IFS('BPT input'!F13=\"Selected\", 'BPT input'!F13, 'BPT input'!F13=\"Feasible\",'BPT input'!F13, 'BPT input'!F13=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K13","v":0},{"$f":"'BPT input'!N13","v":0},{"$f":"'BPT input'!Q13","v":1.758},{"$f":"'BPT input'!T13","v":5.4779999999999998},{"$f":"'BPT input'!W13","v":0},{"$f":"'BPT input'!Z13","v":7.2370000000000001},{"$f":"'BPT input'!AD13","v":0},{"$f":"'BPT input'!AE13","v":0},{"$f":"'BPT input'!AF13","v":0},{"$f":"'BPT input'!AG13","v":-297.262},{"$f":"'BPT input'!AH13","v":-1551.2619999999999},{"$f":"'BPT input'!AH13","v":-1551.2619999999999}]
[null,10,{"$f":"'BPT input'!A14","v":"SVE"},{"$f":"'BPT input'!C14","v":"NZ#1w"},{"$f":"'BPT input'!D14","v":"EV Charging Infrastructure"},{"$f":"_xlfn.IFS('BPT input'!F14=\"Selected\", 'BPT input'!F14, 'BPT input'!F14=\"Feasible\",'BPT input'!F14, 'BPT input'!F14=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K14","v":0},{"$f":"'BPT input'!N14","v":0.88},{"$f":"'BPT input'!Q14","v":0},{"$f":"'BPT input'!T14","v":0},{"$f":"'BPT input'!W14","v":0},{"$f":"'BPT input'!Z14","v":0.88},{"$f":"'BPT input'!AD14","v":0},{"$f":"'BPT input'!AE14","v":0},{"$f":"'BPT input'!AF14","v":-380.6},{"$f":"'BPT input'!AG14","v":-1141.8},{"$f":"'BPT input'!AH14","v":-2283.6},{"$f":"'BPT input'!AH14","v":-2283.6}]
[null,11,{"$f":"'BPT input'!A15","v":"SVE"},{"$f":"'BPT input'!C15","v":"NZ#2w"},{"$f":"'BPT input'!D15","v":"Heat pumps"},{"$f":"_xlfn.IFS('BPT input'!F15=\"Selected\", 'BPT input'!F15, 'BPT input'!F15=\"Feasible\",'BPT input'!F15, 'BPT input'!F15=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K15","v":8.0640000000000001},{"$f":"'BPT input'!N15","v":0},{"$f":"'BPT input'!Q15","v":-7.2999999999999995E-2},{"$f":"'BPT input'!T15","v":-0.11},{"$f":"'BPT input'!W15","v":-0.11},{"$f":"'BPT input'!Z15","v":7.7709999999999999},{"$f":"'BPT input'!AD15","v":0},{"$f":"'BPT input'!AE15","v":0},{"$f":"'BPT input'!AF15","v":-465},{"$f":"'BPT input'!AG15","v":-1395},{"$f":"'BPT input'!AH15","v":-2790},{"$f":"'BPT input'!AH15","v":-2790}]
[null,12,{"$f":"'BPT input'!A16","v":"SVE"},{"$f":"'BPT input'!C16","v":"NZ#3w"},{"$f":"'BPT input'!D16","v":"HVO diesel replacement"},{"$f":"_xlfn.IFS('BPT input'!F16=\"Selected\", 'BPT input'!F16, 'BPT input'!F16=\"Feasible\",'BPT input'!F16, 'BPT input'!F16=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K16","v":0.33100000000000002},{"$f":"'BPT input'!N16","v":0},{"$f":"'BPT input'!Q16","v":0},{"$f":"'BPT input'!T16","v":0},{"$f":"'BPT input'!W16","v":0},{"$f":"'BPT input'!Z16","v":0.33100000000000002},{"$f":"'BPT input'!AD16","v":0},{"$f":"'BPT input'!AE16","v":0},{"$f":"'BPT input'!AF16","v":-693},{"$f":"'BPT input'!AG16","v":-2079},{"$f":"'BPT input'!AH16","v":-4158},{"$f":"'BPT input'!AH16","v":-4158}]
[null,13,{"$f":"'BPT input'!A17","v":"SVE"},{"$f":"'BPT input'!C17","v":"NZ#4w"},{"$f":"'BPT input'!D17","v":"Hydrogen Production"},{"$f":"_xlfn.IFS('BPT input'!F17=\"Selected\", 'BPT input'!F17, 'BPT input'!F17=\"Feasible\",'BPT input'!F17, 'BPT input'!F17=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K17","v":0.55000000000000004},{"$f":"'BPT input'!N17","v":0.55000000000000004},{"$f":"'BPT input'!Q17","v":0.28999999999999998},{"$f":"'BPT input'!T17","v":0.28999999999999998},{"$f":"'BPT input'!W17","v":0.28999999999999998},{"$f":"'BPT input'!Z17","v":1.97},{"$f":"'BPT input'!AD17","v":0},{"$f":"'BPT input'!AE17","v":0},{"$f":"'BPT input'!AF17","v":-985.6},{"$f":"'BPT input'!AG17","v":-1971.2},{"$f":"'BPT input'!AH17","v":-2956.8},{"$f":"'BPT input'!AH17","v":-2956.8}]
[null,14,{"$f":"'BPT input'!A18","v":"SVE"},{"$f":"'BPT input'!C18","v":"NZ#5w"},{"$f":"'BPT input'!D18","v":"Electrical storage"},{"$f":"_xlfn.IFS('BPT input'!F18=\"Selected\", 'BPT input'!F18, 'BPT input'!F18=\"Feasible\",'BPT input'!F18, 'BPT input'!F18=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K18","v":1.21},{"$f":"'BPT input'!N18","v":1.21},{"$f":"'BPT input'!Q18","v":0.70599999999999996},{"$f":"'BPT input'!T18","v":0.70599999999999996},{"$f":"'BPT input'!W18","v":0.70599999999999996},{"$f":"'BPT input'!Z18","v":4.5380000000000003},{"$f":"'BPT input'!AD18","v":"-   "},{"$f":"'BPT input'!AE18","v":" -   "},{"$f":"'BPT input'!AF18","v":-40.15},{"$f":"'BPT input'!AG18","v":-80.3},{"$f":"'BPT input'!AH18","v":-120.45},{"$f":"'BPT input'!AH18","v":-120.45}]
[null,15,{"$f":"'BPT input'!A19","v":"SVE"},{"$f":"'BPT input'!C19","v":"NZ#6w"},{"$f":"'BPT input'!D19","v":"EV fleet only"},{"$f":"_xlfn.IFS('BPT input'!F19=\"Selected\", 'BPT input'!F19, 'BPT input'!F19=\"Feasible\",'BPT input'!F19, 'BPT input'!F19=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K19","v":0.80300000000000005},{"$f":"'BPT input'!N19","v":0.80300000000000005},{"$f":"'BPT input'!Q19","v":0.80300000000000005},{"$f":"'BPT input'!T19","v":0.80300000000000005},{"$f":"'BPT input'!W19","v":0.80300000000000005},{"$f":"'BPT input'!Z19","v":4.0149999999999997},{"$f":"'BPT input'!AD19","v":0},{"$f":"'BPT input'!AE19","v":-381},{"$f":"'BPT input'!AF19","v":-1142},{"$f":"'BPT input'!AG19","v":-2284},{"$f":"'BPT input'!AH19","v":-3806},{"$f":"'BPT input'!AH19","v":-3806}]
[null,16,{"$f":"'BPT input'!A20","v":"SVE"},{"$f":"'BPT input'!C20","v":"NZ#7w"},{"$f":"'BPT input'!D20","v":"HVO fuel only"},{"$f":"_xlfn.IFS('BPT input'!F20=\"Selected\", 'BPT input'!F20, 'BPT input'!F20=\"Feasible\",'BPT input'!F20, 'BPT input'!F20=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K20","v":0.44},{"$f":"'BPT input'!N20","v":0.44},{"$f":"'BPT input'!Q20","v":0.44},{"$f":"'BPT input'!T20","v":0.44},{"$f":"'BPT input'!W20","v":0.44},{"$f":"'BPT input'!Z20","v":2.2000000000000002},{"$f":"'BPT input'!AD20","v":-2776.4},{"$f":"'BPT input'!AE20","v":-5552.8},{"$f":"'BPT input'!AF20","v":-8329.2000000000007},{"$f":"'BPT input'!AG20","v":-11105.6},{"$f":"'BPT input'!AH20","v":-13882},{"$f":"'BPT input'!AH20","v":-13882}]
[null,17,{"$f":"'BPT input'!A21","v":"SVE"},{"$f":"'BPT input'!C21","v":"NZ#8w"},{"$f":"'BPT input'!D21","v":"Solar PV"},{"$f":"_xlfn.IFS('BPT input'!F21=\"Selected\", 'BPT input'!F21, 'BPT input'!F21=\"Feasible\",'BPT input'!F21, 'BPT input'!F21=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K21","v":2.86},{"$f":"'BPT input'!N21","v":2.86},{"$f":"'BPT input'!Q21","v":-0.34899999999999998},{"$f":"'BPT input'!T21","v":-0.34899999999999998},{"$f":"'BPT input'!W21","v":-0.34899999999999998},{"$f":"'BPT input'!Z21","v":4.673},{"$f":"'BPT input'!AD21","v":0},{"$f":"'BPT input'!AE21","v":0},{"$f":"'BPT input'!AF21","v":-3208.788},{"$f":"'BPT input'!AG21","v":-6417.576},{"$f":"'BPT input'!AH21","v":-9626.3639999999996},{"$f":"'BPT input'!AH21","v":-9626.3639999999996}]
[null,18,{"$f":"'BPT input'!A22","v":"TMS"},{"$f":"'BPT input'!C22","v":"CW21_1"},{"$f":"'BPT input'!D22","v":"S40840/2 (PR24 Fleet - Life expired Enhancement (cost to convert to electrical) (Water))"},{"$f":"_xlfn.IFS('BPT input'!F22=\"Selected\", 'BPT input'!F22, 'BPT input'!F22=\"Feasible\",'BPT input'!F22, 'BPT input'!F22=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K22","v":4.4779999999999998},{"$f":"'BPT input'!N22","v":4.0190000000000001},{"$f":"'BPT input'!Q22","v":3.1509999999999998},{"$f":"'BPT input'!T22","v":2.133},{"$f":"'BPT input'!W22","v":9.2999999999999999E-2},{"$f":"'BPT input'!Z22","v":13.874000000000001},{"$f":"'BPT input'!AD22","v":-808},{"$f":"'BPT input'!AE22","v":-2100},{"$f":"'BPT input'!AF22","v":-3847},{"$f":"'BPT input'!AG22","v":-6094},{"$f":"'BPT input'!AH22","v":-8762},{"$f":"'BPT input'!AH22","v":-8762}]
[null,19,{"$f":"'BPT input'!A23","v":"TMS"},{"$f":"'BPT input'!C23","v":"CW21_2"},{"$f":"'BPT input'!D23","v":"S40142/2 (PR24 Hybrid air source heat pump/existing boiler for 4 corporate offices (Water))"},{"$f":"_xlfn.IFS('BPT input'!F23=\"Selected\", 'BPT input'!F23, 'BPT input'!F23=\"Feasible\",'BPT input'!F23, 'BPT input'!F23=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K23","v":0.40400000000000003},{"$f":"'BPT input'!N23","v":0.35399999999999998},{"$f":"'BPT input'!Q23","v":-3.5999999999999997E-2},{"$f":"'BPT input'!T23","v":-2.4E-2},{"$f":"'BPT input'!W23","v":-1.7000000000000001E-2},{"$f":"'BPT input'!Z23","v":0.68100000000000005},{"$f":"'BPT input'!AD23","v":-132.5},{"$f":"'BPT input'!AE23","v":-397.52},{"$f":"'BPT input'!AF23","v":-662.54},{"$f":"'BPT input'!AG23","v":-927.56},{"$f":"'BPT input'!AH23","v":-1192.58},{"$f":"'BPT input'!AH23","v":-1192.58}]
[null,20,{"$f":"'BPT input'!A24","v":"TMS"},{"$f":"'BPT input'!C24","v":"CW21_3"},{"$f":"'BPT input'!D24","v":"S40144/2 (PR24 Air source heat pump for site office (enhancement cost) (Water))"},{"$f":"_xlfn.IFS('BPT input'!F24=\"Selected\", 'BPT input'!F24, 'BPT input'!F24=\"Feasible\",'BPT input'!F24, 'BPT input'!F24=\"Select from Dropdown\", \"Selected\")","v":"Feasible"},{"$f":"'BPT input'!K24","v":0.33700000000000002},{"$f":"'BPT input'!N24","v":0.35},{"$f":"'BPT input'!Q24","v":0.36399999999999999},{"$f":"'BPT input'!T24","v":0.378},{"$f":"'BPT input'!W24","v":0.39400000000000002},{"$f":"'BPT input'!Z24","v":1.823},{"$f":"'BPT input'!AD24","v":-33.33},{"$f":"'BPT input'!AE24","v":-100},{"$f":"'BPT input'!AF24","v":-200.04},{"$f":"'BPT input'!AG24","v":-333.39},{"$f":"'BPT input'!AH24","v":-500.06},{"$f":"'BPT input'!AH24","v":-500.06}]
[null,21,{"$f":"'BPT input'!A25","v":"NWT"},{"$f":"'BPT input'!C25","v":"E00001340"},{"$f":"'BPT input'!D25","v":"Transport fossil fuel reductions - Green fleet LCVs phase 1"},{"$f":"_xlfn.IFS('BPT input'!F25=\"Selected\", 'BPT input'!F25, 'BPT input'!F25=\"Feasible\",'BPT input'!F25, 'BPT input'!F25=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K25","v":0.83399999999999996},{"$f":"'BPT input'!N25","v":0.86699999999999999},{"$f":"'BPT input'!Q25","v":1.659},{"$f":"'BPT input'!T25","v":0.97899999999999998},{"$f":"'BPT input'!W25","v":-1.1990000000000001},{"$f":"'BPT input'!Z25","v":3.141},{"$f":"'BPT input'!AD25","v":-182.74199999999999},{"$f":"'BPT input'!AE25","v":-776.65099999999995},{"$f":"'BPT input'!AF25","v":-2055.8420000000001},{"$f":"'BPT input'!AG25","v":-4179.2979999999998},{"$f":"'BPT input'!AH25","v":-6690.1670000000004},{"$f":"'BPT input'!AH25","v":-6690.1670000000004}]
[null,22,{"$f":"'BPT input'!A26","v":"NWT"},{"$f":"'BPT input'!C26","v":"E00001341"},{"$f":"'BPT input'!D26","v":"Transport fossil fuel reductions - Green fleet LCVs phase 2 "},{"$f":"_xlfn.IFS('BPT input'!F26=\"Selected\", 'BPT input'!F26, 'BPT input'!F26=\"Feasible\",'BPT input'!F26, 'BPT input'!F26=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K26","v":1.0429999999999999},{"$f":"'BPT input'!N26","v":1.2589999999999999},{"$f":"'BPT input'!Q26","v":2.4769999999999999},{"$f":"'BPT input'!T26","v":1.9770000000000001},{"$f":"'BPT input'!W26","v":-0.41499999999999998},{"$f":"'BPT input'!Z26","v":6.3410000000000002},{"$f":"'BPT input'!AD26","v":-63.180999999999997},{"$f":"'BPT input'!AE26","v":-268.51900000000001},{"$f":"'BPT input'!AF26","v":-710.78599999999994},{"$f":"'BPT input'!AG26","v":-1444.9480000000001},{"$f":"'BPT input'!AH26","v":-2313.0549999999998},{"$f":"'BPT input'!AH26","v":-2313.0549999999998}]
[null,23,{"$f":"'BPT input'!A27","v":"NWT"},{"$f":"'BPT input'!C27","v":"E00001344"},{"$f":"'BPT input'!D27","v":"Peatland restoration"},{"$f":"_xlfn.IFS('BPT input'!F27=\"Selected\", 'BPT input'!F27, 'BPT input'!F27=\"Feasible\",'BPT input'!F27, 'BPT input'!F27=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K27","v":2.0179999999999998},{"$f":"'BPT input'!N27","v":5.5419999999999998},{"$f":"'BPT input'!Q27","v":5.5010000000000003},{"$f":"'BPT input'!T27","v":5.5869999999999997},{"$f":"'BPT input'!W27","v":1.857},{"$f":"'BPT input'!Z27","v":20.504999999999999},{"$f":"'BPT input'!AD27","v":0},{"$f":"'BPT input'!AE27","v":0},{"$f":"'BPT input'!AF27","v":0},{"$f":"'BPT input'!AG27","v":0},{"$f":"'BPT input'!AH27","v":-13227},{"$f":"'BPT input'!AH27","v":-13227}]
[null,24,{"$f":"'BPT input'!A28","v":"NWT"},{"$f":"'BPT input'!C28","v":"E00001345"},{"$f":"'BPT input'!D28","v":"Woodland creation"},{"$f":"_xlfn.IFS('BPT input'!F28=\"Selected\", 'BPT input'!F28, 'BPT input'!F28=\"Feasible\",'BPT input'!F28, 'BPT input'!F28=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K28","v":0.84299999999999997},{"$f":"'BPT input'!N28","v":0.85799999999999998},{"$f":"'BPT input'!Q28","v":0.84499999999999997},{"$f":"'BPT input'!T28","v":0},{"$f":"'BPT input'!W28","v":0},{"$f":"'BPT input'!Z28","v":2.5459999999999998},{"$f":"'BPT input'!AD28","v":0},{"$f":"'BPT input'!AE28","v":0},{"$f":"'BPT input'!AF28","v":-427.01499999999999},{"$f":"'BPT input'!AG28","v":-854.03},{"$f":"'BPT input'!AH28","v":-1662.633},{"$f":"'BPT input'!AH28","v":-1662.633}]
[null,25,{"$f":"'BPT input'!A29","v":"NWT"},{"$f":"'BPT input'!C29","v":"E00001346"},{"$f":"'BPT input'!D29","v":"Property emissions reductions "},{"$f":"_xlfn.IFS('BPT input'!F29=\"Selected\", 'BPT input'!F29, 'BPT input'!F29=\"Feasible\",'BPT input'!F29, 'BPT input'!F29=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K29","v":1.206},{"$f":"'BPT input'!N29","v":0},{"$f":"'BPT input'!Q29","v":0},{"$f":"'BPT input'!T29","v":0},{"$f":"'BPT input'!W29","v":0},{"$f":"'BPT input'!Z29","v":1.206},{"$f":"'BPT input'!AD29","v":-408.28399999999999},{"$f":"'BPT input'!AE29","v":-816.56899999999996},{"$f":"'BPT input'!AF29","v":-1224.8530000000001},{"$f":"'BPT input'!AG29","v":-1633.1379999999999},{"$f":"'BPT input'!AH29","v":-2041.422},{"$f":"'BPT input'!AH29","v":-2041.422}]
[null,26,{"$f":"'BPT input'!A30","v":"NWT"},{"$f":"'BPT input'!C30","v":"E00001426"},{"$f":"'BPT input'!D30","v":"Phase 2 – Further low regrets emissions reductions in AMP8"},{"$f":"_xlfn.IFS('BPT input'!F30=\"Selected\", 'BPT input'!F30, 'BPT input'!F30=\"Feasible\",'BPT input'!F30, 'BPT input'!F30=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K30","v":0},{"$f":"'BPT input'!N30","v":0},{"$f":"'BPT input'!Q30","v":7.61},{"$f":"'BPT input'!T30","v":7.7270000000000003},{"$f":"'BPT input'!W30","v":7.702},{"$f":"'BPT input'!Z30","v":23.039000000000001},{"$f":"'BPT input'!AD30","v":0},{"$f":"'BPT input'!AE30","v":0},{"$f":"'BPT input'!AF30","v":-5021.1040000000003},{"$f":"'BPT input'!AG30","v":-10042.207},{"$f":"'BPT input'!AH30","v":-15063.311},{"$f":"'BPT input'!AH30","v":-15063.311}]
[null,27,{"$f":"'BPT input'!A31","v":"WSH"},{"$f":"'BPT input'!C31","v":"CW21_1"},{"$f":"'BPT input'!D31","v":"Net Zero Carbon Strategy:  Network Control Systems (Water)"},{"$f":"_xlfn.IFS('BPT input'!F31=\"Selected\", 'BPT input'!F31, 'BPT input'!F31=\"Feasible\",'BPT input'!F31, 'BPT input'!F31=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K31","v":0.13200000000000001},{"$f":"'BPT input'!N31","v":0.29699999999999999},{"$f":"'BPT input'!Q31","v":0.29699999999999999},{"$f":"'BPT input'!T31","v":0.313},{"$f":"'BPT input'!W31","v":0.26500000000000001},{"$f":"'BPT input'!Z31","v":1.304},{"$f":"'BPT input'!AD31","v":-50},{"$f":"'BPT input'!AE31","v":-165},{"$f":"'BPT input'!AF31","v":-285},{"$f":"'BPT input'!AG31","v":-400},{"$f":"'BPT input'!AH31","v":-500},{"$f":"'BPT input'!AH31","v":-500}]
[null,28,{"$f":"'BPT input'!A32","v":"WSH"},{"$f":"'BPT input'!C32","v":"CW21_2"},{"$f":"'BPT input'!D32","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},{"$f":"_xlfn.IFS('BPT input'!F32=\"Selected\", 'BPT input'!F32, 'BPT input'!F32=\"Feasible\",'BPT input'!F32, 'BPT input'!F32=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K32","v":5.0599999999999996},{"$f":"'BPT input'!N32","v":5.0599999999999996},{"$f":"'BPT input'!Q32","v":5.0599999999999996},{"$f":"'BPT input'!T32","v":5.0599999999999996},{"$f":"'BPT input'!W32","v":5.0599999999999996},{"$f":"'BPT input'!Z32","v":25.3},{"$f":"'BPT input'!AD32","v":0},{"$f":"'BPT input'!AE32","v":0},{"$f":"'BPT input'!AF32","v":0},{"$f":"'BPT input'!AG32","v":0},{"$f":"'BPT input'!AH32","v":0},{"$f":"'BPT input'!AH32","v":0}]
[null,29,{"$f":"'BPT input'!A33","v":"WSX"},{"$f":"'BPT input'!C33","v":"CW21_1"},{"$f":"'BPT input'!D33","v":"Transport"},{"$f":"_xlfn.IFS('BPT input'!F33=\"Selected\", 'BPT input'!F33, 'BPT input'!F33=\"Feasible\",'BPT input'!F33, 'BPT input'!F33=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K33","v":0.39500000000000002},{"$f":"'BPT input'!N33","v":0.63500000000000001},{"$f":"'BPT input'!Q33","v":0.8},{"$f":"'BPT input'!T33","v":0.80500000000000005},{"$f":"'BPT input'!W33","v":0.42099999999999999},{"$f":"'BPT input'!Z33","v":3.056},{"$f":"'BPT input'!AD33","v":0},{"$f":"'BPT input'!AE33","v":0},{"$f":"'BPT input'!AF33","v":0},{"$f":"'BPT input'!AG33","v":0},{"$f":"'BPT input'!AH33","v":0},{"$f":"'BPT input'!AH33","v":0}]
[null,30,{"$f":"'BPT input'!A34","v":"YKY"},{"$f":"'BPT input'!C34","v":"CW21-1"},{"$f":"'BPT input'!D34","v":"Solar "},{"$f":"_xlfn.IFS('BPT input'!F34=\"Selected\", 'BPT input'!F34, 'BPT input'!F34=\"Feasible\",'BPT input'!F34, 'BPT input'!F34=\"Select from Dropdown\", \"Selected\")","v":"Selected"},{"$f":"'BPT input'!K34","v":3.883},{"$f":"'BPT input'!N34","v":4.3570000000000002},{"$f":"'BPT input'!Q34","v":3.0310000000000001},{"$f":"'BPT input'!T34","v":0.29699999999999999},{"$f":"'BPT input'!W34","v":-0.77100000000000002},{"$f":"'BPT input'!Z34","v":10.795999999999999},{"$f":"'BPT input'!AD34","v":0},{"$f":"'BPT input'!AE34","v":-1000},{"$f":"'BPT input'!AF34","v":-2000},{"$f":"'BPT input'!AG34","v":-3000},{"$f":"'BPT input'!AH34","v":-3500},{"$f":"'BPT input'!AH34","v":-3500}]

{"sheet":"Override","index":5,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Override data"]
[]
[]
["DD BPT link","Scheme resubmitted in DD ",null,"Company","Scheme ID","Scheme name","Selected or Feasible","Totex 2025-26","Totex 2026-27","Totex 2027-28","Totex 2028-29","Totex 2029-30","AMP8 totex (£m, 2025-30)","Carbon benefits (cumulated) 2025-26","Carbon benefits (cumulated) 2026-27","Carbon benefits (cumulated) 2027-28","Carbon benefits (cumulated) 2028-29","Carbon benefits (cumulated) 2029-30","Scheme benefits (tCO2e cumulative, 2029-30)","Reason for override","Reason for override 2"]
["ANH_DD_004-v7-Main-data-tables.xlsb","No",1,{"$f":"IF(Data!C5=\"\",\"\",Data!C5)","v":"ANH"},"CW21.1","AMP8 Small Scale Solar Delivery WS","Not defined",0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
[null,"No",2,{"$f":"IF(Data!C6=\"\",\"\",Data!C6)","v":"AFW"},"AFW_EV","Net Zero: Electric Vehicles","Not defined",0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["24.09.19 - HDD Original set BPDTs.xlsx","Yes",3,{"$f":"IF(Data!C7=\"\",\"\",Data!C7)","v":"HDD"},"HDD_1","Electric Vehicles & Low Carbon fuels transition","Not defined",0.31151067999999998,0.14764008000000001,0.16868604000000001,0.24276235500000001,0.27481507500000002,1.1454142300000001,-236.566,-288.077,-328.29399999999998,-517.76599999999996,-563.82000000000005,-563.82000000000005,"Rejected at DD: company representation."]
["24.09.19 - HDD Original set BPDTs.xlsx","No",4,{"$f":"IF(Data!C8=\"\",\"\",Data!C8)","v":"HDD"},"HDD_2","Heat Pump",null,0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["SEWDD8a01 - DD - PR24-BP-tables-V7-Publish - SUBMISSION.xlsx","Yes",5,{"$f":"IF(Data!C9=\"\",\"\",Data!C9)","v":"SEW"},"SEW_1","Ozone upgrade at Barcombe","Selected",0.15345335470050001,0.39897872222129999,1.2583175085441001,1.2583175085441001,9.9301329999999993E-2,3.1683684240100005,0,0,0,0,-573,-573,"Rejected at DD: company representation."]
["SEWDD8a01 - DD - PR24-BP-tables-V7-Publish - SUBMISSION.xlsx","Yes",6,{"$f":"IF(Data!C10=\"\",\"\",Data!C10)","v":"SEW"},"SEW_2","Ozone upgrade at Arlington","Selected",5.9230617873300001E-2,0.15399960647058,0.48569106656105993,0.48569106656105993,3.5806839999999993E-2,1.2204191974659997,0,0,0,0,-114,-114,"Rejected at DD: company representation."]
["SEWDD8a01 - DD - PR24-BP-tables-V7-Publish - SUBMISSION.xlsx","No",7,{"$f":"IF(Data!C11=\"\",\"\",Data!C11)","v":"SEW"},"SEW_3","Power resilience (generators)",null,0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["SEWDD8a01 - DD - PR24-BP-tables-V7-Publish - SUBMISSION.xlsx","Yes",8,{"$f":"IF(Data!C12=\"\",\"\",Data!C12)","v":"SEW"},"SEW_4","Transport offset (Electrifying fleet)","Selected",1.6053696,1.4698097999999999,1.9138482000000001,1.3374522,1.8807588,8.2072386000000002,-181,-423,-707,-888,-1371,-1371,"Rejected at DD: company representation."]
["24 09 09 - SSC BPDTS.xlsx","Yes",9,{"$f":"IF(Data!C13=\"\",\"\",Data!C13)","v":"SSC"},"SSC_CW21_1","Renewable electricity behind the meter assets ","Selected",0,0,1.7583852400506379,5.4783852400506383,0,7.236770480101276,0,0,0,-297.262,-1551.2619999999999,-1551.2619999999999,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",10,{"$f":"IF(Data!C14=\"\",\"\",Data!C14)","v":"SVE"},"NZ#1w","EV Charging Infrastructure","Selected",0,0.88,0,0,0,0.88,0,0,-380.6,-1141.8,-2283.6,-2283.6,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",11,{"$f":"IF(Data!C15=\"\",\"\",Data!C15)","v":"SVE"},"NZ#2w","Heat pumps","Selected",8.0640000000000001,0,-7.2999999999999995E-2,-0.11,-0.11,7.7709999999999999,0,0,-465,-1395,-2790,-2790,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",12,{"$f":"IF(Data!C16=\"\",\"\",Data!C16)","v":"SVE"},"NZ#3w","HVO diesel replacement","Selected",0.33100000000000002,0,0,0,0,0.33100000000000002,0,0,-693,-2079,-4158,-4158,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",13,{"$f":"IF(Data!C17=\"\",\"\",Data!C17)","v":"SVE"},"NZ#4w","Hydrogen Production","Feasible",0.55000000000000004,0.55000000000000004,0.29000000000000004,0.29000000000000004,0.29000000000000004,1.9700000000000002,0,0,-985.6,-1971.2,-2956.8,-2956.8,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",14,{"$f":"IF(Data!C18=\"\",\"\",Data!C18)","v":"SVE"},"NZ#5w","Electrical storage","Feasible",1.21,1.21,0.70599999999999996,0.70599999999999996,0.70599999999999996,4.5380000000000003," -   "," -   ",-40.15,-80.3,-120.45,-120.45,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",15,{"$f":"IF(Data!C19=\"\",\"\",Data!C19)","v":"SVE"},"NZ#6w","EV fleet only","Feasible",0.80300000000000005,0.80300000000000005,0.80300000000000005,0.80300000000000005,0.80300000000000005,4.0150000000000006,0,-381,-1142,-2284,-3806,-3806,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",16,{"$f":"IF(Data!C20=\"\",\"\",Data!C20)","v":"SVE"},"NZ#7w","HVO fuel only","Feasible",0.44,0.44,0.44,0.44,0.44,2.2000000000000002,-2776.4,-5552.8,-8329.2000000000007,-11105.6,-13882,-13882,"Rejected at DD: company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",17,{"$f":"IF(Data!C21=\"\",\"\",Data!C21)","v":"SVE"},"NZ#8w","Solar PV","Feasible",2.86,2.86,-0.3490000000000002,-0.3490000000000002,-0.3490000000000002,4.6729999999999992,0,0,-3208.788,-6417.576,-9626.3639999999996,-9626.3639999999996,"Rejected at DD: company representation."]
["TMS-DD-002-PR24-Draft-Determination-Data-Tables.xlsb","Yes",18,{"$f":"IF(Data!C22=\"\",\"\",Data!C22)","v":"TMS"},"CW21_1","S40840/2 (PR24 Fleet - Life expired Enhancement (cost to convert to electrical) (Water))","Feasible",4.4779999999999998,4.0190000000000001,3.1510000000000002,2.133,9.2999999999999972E-2,13.874000000000001,-808,-2100,-3847,-6094,-8762,-8762,"Rejected at DD: company representation."]
["TMS-DD-002-PR24-Draft-Determination-Data-Tables.xlsb","Yes",19,{"$f":"IF(Data!C23=\"\",\"\",Data!C23)","v":"TMS"},"CW21_2","S40142/2 (PR24 Hybrid air source heat pump/existing boiler for 4 corporate offices (Water))","Feasible",0.40400000000000003,0.35399999999999998,-3.5999999999999997E-2,-2.4E-2,-1.7000000000000001E-2,0.68100000000000005,-132.5,-397.52,-662.54,-927.56,-1192.58,-1192.58,"Rejected at DD: company representation."]
["TMS-DD-002-PR24-Draft-Determination-Data-Tables.xlsb","Yes",20,{"$f":"IF(Data!C24=\"\",\"\",Data!C24)","v":"TMS"},"CW21_3","S40144/2 (PR24 Air source heat pump for site office (enhancement cost) (Water))","Feasible",0.33700000000000002,0.35000000000000003,0.36400000000000005,0.378,0.39400000000000002,1.8230000000000002,-33.33,-100,-200.04,-333.39,-500.06,-500.06,"Rejected at DD: company representation."]
["24 09 16 - UUW BPDTS.xlsb","Yes",21,{"$f":"IF(Data!C25=\"\",\"\",Data!C25)","v":"NWT"},"E00001340","Transport fossil fuel reductions - Green fleet LCVs phase 1","Selected",0.83431418654062639,0.86720017290751972,1.6590817561861599,0.97931001095941539,-1.1989696359391653,3.1409364906545565,-182,-774,-2050,-4167,-6671,-6671,"Rejected at DD: company representation."]
["24 09 16 - UUW BPDTS.xlsb","No",22,{"$f":"IF(Data!C26=\"\",\"\",Data!C26)","v":"NWT"},"E00001341","Transport fossil fuel reductions - Green fleet LCVs phase 2 ",null,0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["24 09 16 - UUW BPDTS.xlsb","Yes",23,{"$f":"IF(Data!C27=\"\",\"\",Data!C27)","v":"NWT"},"E00001344","Peatland restoration","Selected",2.0175224038604949,5.5422741585021518,5.5009268029786718,5.5872058711786297,1.8566963094707822,20.504625545990727,0,0,0,0,-13227,-13227,"Rejected at DD: company representation."]
["24 09 16 - UUW BPDTS.xlsb","Yes",24,{"$f":"IF(Data!C28=\"\",\"\",Data!C28)","v":"NWT"},"E00001345","Woodland creation","Selected",0.84281730484853168,0.85751024789435737,0.84532302973692108,0,0,2.5456505824798104,0,0,-472.01499999999999,-854.03,-1662.63,-1662.63,"Rejected at DD: company representation."]
["24 09 16 - UUW BPDTS.xlsb","No",25,{"$f":"IF(Data!C29=\"\",\"\",Data!C29)","v":"NWT"},"E00001346","Property emissions reductions ","Not defined",0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["24 09 16 - UUW BPDTS.xlsb","No",26,{"$f":"IF(Data!C30=\"\",\"\",Data!C30)","v":"NWT"},"E00001426","Phase 2 – Further low regrets emissions reductions in AMP8","Not defined",0,0,0,0,0,0,0,0,0,0,0,0,"Rejected at DD: no company representation."]
["WSH-DD-101 PR24 Business Plan tables V7_Amended 240917.xlsb","Yes",27,{"$f":"IF(Data!C31=\"\",\"\",Data!C31)","v":"WSH"},"CW21_1","Net Zero Carbon Strategy:  Network Control Systems (Water)","Selected",0.13100000000000001,0.29342451119304636,0.29361912797446804,0.3094502010380813,0.2620131213230088,1.2895069615286043,-50,-165,-285,-400,-500,-500,"Rejected at DD: company representation."]
["WSH-DD-101 PR24 Business Plan tables V7_Amended 240917.xlsb","Yes",28,{"$f":"IF(Data!C32=\"\",\"\",Data!C32)","v":"WSH"},"CW21_2","Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)","Selected",2.7374000000000001,2.7374000000000001,2.7374000000000001,2.7374000000000001,2.7374000000000001,13.686999999999999,0,0,0,0,0,0,"Rejected at DD: company representation.","AMP8 totex for Peatland Restoration is £13.69 million, provided by query response."]
["WSX-D00a – August 2024 data tables v8. WORKING VERSION POST-DD 12.09.24.xlsx","Yes",29,{"$f":"IF(Data!C33=\"\",\"\",Data!C33)","v":"WSX"},"CW21_1","Transport","Selected",0.39473733923437504,0.63486005978232007,0.79984976502795002,0.80539457990984997,0.42109206464072318,3.0559338085952183,-106,-317,-633,-1056,-1584,-1584,"Rejected at DD: company representation."]
["YKY-PR24-DDR-85-Data-Tables-18Sept24_coastal.xlsb","No",30,{"$f":"IF(Data!C34=\"\",\"\",Data!C34)","v":"YKY"},"CW21-1","Solar ",0,0,0,0,0,0,0,null,null,null,null,null,null,"Rejected at DD: no company representation."]
["24 09 12 - SVE BPDTS.xlsx","Yes",31,"SVE",null,"Transport PR24","Feasible",8.9309999999999992,10.231,10.847,12.331,13.388999999999999,55.728999999999999]

{"sheet":"Final data","index":6,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Final data"]
[]
[]
["Scheme resubmitted in DD ","Number","Company","Scheme ID","Scheme name","Selected or Feasible","Totex 2025-26","Totex 2026-27","Totex 2027-28","Totex 2028-29","Totex 2029-30","AMP8 totex (£m, 2025-30)","Carbon benefits (cumulated) 2025-26","Carbon benefits (cumulated) 2026-27","Carbon benefits (cumulated) 2027-28","Carbon benefits (cumulated) 2028-29","Carbon benefits (cumulated) 2029-30","Scheme benefits (tCO2e cumulative, 2029-30)","Unit cost over AMP8 (000£/tCO2e)","Unit cost over AMP8 (£/tCO2e)","Final Decision"]
["No",1,{"$f":"IF(Override!D5<>\"\",Override!D5,Data!C5)","v":"ANH"},{"$f":"IF(Override!E5<>\"\",Override!E5,Data!D5)","v":"CW21.1"},{"$f":"IF(Override!F5<>\"\",Override!F5,Data!E5)","v":"AMP8 Small Scale Solar Delivery WS"},{"$f":"IF(Override!G5<>\"\",Override!G5,Data!F5)","v":"Not defined"},{"$f":"IF(Override!H5<>\"\",Override!H5,Data!G5)","v":0},{"$f":"IF(Override!I5<>\"\",Override!I5,Data!H5)","v":0},{"$f":"IF(Override!J5<>\"\",Override!J5,Data!I5)","v":0},{"$f":"IF(Override!K5<>\"\",Override!K5,Data!J5)","v":0},{"$f":"IF(Override!L5<>\"\",Override!L5,Data!K5)","v":0},{"$f":"IF(Override!M5<>\"\",Override!M5,Data!L5)","v":0},{"$f":"IF(Override!N5<>\"\",Override!N5,Data!M5)","v":0},{"$f":"IF(Override!O5<>\"\",Override!O5,Data!N5)","v":0},{"$f":"IF(Override!P5<>\"\",Override!P5,Data!O5)","v":0},{"$f":"IF(Override!Q5<>\"\",Override!Q5,Data!P5)","v":0},{"$f":"IF(Override!R5<>\"\",Override!R5,Data!Q5)","v":0},{"$f":"IF(Override!S5<>\"\",Override!S5,Data!R5)","v":0},{"$f":"IFERROR(((ABS(L5)*1000)/ABS(R5)),\"-\")","v":"-"},{"$f":"IFERROR(S5*1000,\"-\")","v":"-"},{"$f":"VLOOKUP(B5,'Phase 2'!B5:W34,22,FALSE)","v":"Fail"}]
["No",2,{"$f":"IF(Override!D6<>\"\",Override!D6,Data!C6)","v":"AFW"},{"$f":"IF(Override!E6<>\"\",Override!E6,Data!D6)","v":"AFW_EV"},{"$f":"IF(Override!F6<>\"\",Override!F6,Data!E6)","v":"Net Zero: Electric Vehicles"},{"$f":"IF(Override!G6<>\"\",Override!G6,Data!F6)","v":"Not defined"},{"$f":"IF(Override!H6<>\"\",Override!H6,Data!G6)","v":0},{"$f":"IF(Override!I6<>\"\",Override!I6,Data!H6)","v":0},{"$f":"IF(Override!J6<>\"\",Override!J6,Data!I6)","v":0},{"$f":"IF(Override!K6<>\"\",Override!K6,Data!J6)","v":0},{"$f":"IF(Override!L6<>\"\",Override!L6,Data!K6)","v":0},{"$f":"IF(Override!M6<>\"\",Override!M6,Data!L6)","v":0},{"$f":"IF(Override!N6<>\"\",Override!N6,Data!M6)","v":0},{"$f":"IF(Override!O6<>\"\",Override!O6,Data!N6)","v":0},{"$f":"IF(Override!P6<>\"\",Override!P6,Data!O6)","v":0},{"$f":"IF(Override!Q6<>\"\",Override!Q6,Data!P6)","v":0},{"$f":"IF(Override!R6<>\"\",Override!R6,Data!Q6)","v":0},{"$f":"IF(Override!S6<>\"\",Override!S6,Data!R6)","v":0},{"$f":"IFERROR(((ABS(L6)*1000)/ABS(R6)),\"-\")","v":"-"},{"$f":"IFERROR(S6*1000,\"-\")","v":"-"},{"$f":"VLOOKUP(B6,'Phase 2'!B6:W35,22,FALSE)","v":"Fail"}]
["Yes",3,{"$f":"IF(Override!D7<>\"\",Override!D7,Data!C7)","v":"HDD"},{"$f":"IF(Override!E7<>\"\",Override!E7,Data!D7)","v":"HDD_1"},{"$f":"IF(Override!F7<>\"\",Override!F7,Data!E7)","v":"Electric Vehicles & Low Carbon fuels transition"},"Selected",{"$f":"IF(Override!H7<>\"\",Override!H7,Data!G7)","v":0.31151067999999998},{"$f":"IF(Override!I7<>\"\",Override!I7,Data!H7)","v":0.14764008000000001},{"$f":"IF(Override!J7<>\"\",Override!J7,Data!I7)","v":0.16868604000000001},{"$f":"IF(Override!K7<>\"\",Override!K7,Data!J7)","v":0.24276235500000001},{"$f":"IF(Override!L7<>\"\",Override!L7,Data!K7)","v":0.27481507500000002},{"$f":"IF(Override!M7<>\"\",Override!M7,Data!L7)","v":1.1454142300000001},{"$f":"IF(Override!N7<>\"\",Override!N7,Data!M7)","v":-236.566},{"$f":"IF(Override!O7<>\"\",Override!O7,Data!N7)","v":-288.077},{"$f":"IF(Override!P7<>\"\",Override!P7,Data!O7)","v":-328.29399999999998},{"$f":"IF(Override!Q7<>\"\",Override!Q7,Data!P7)","v":-517.76599999999996},{"$f":"IF(Override!R7<>\"\",Override!R7,Data!Q7)","v":-563.82000000000005},{"$f":"IF(Override!S7<>\"\",Override!S7,Data!R7)","v":-563.82000000000005},2.0315246532581321,{"$f":"IFERROR(S7*1000,\"-\")","v":2031.524653258132},{"$f":"VLOOKUP(B7,'Phase 2'!B7:W36,22,FALSE)","v":"Fail"}]
["No",4,{"$f":"IF(Override!D8<>\"\",Override!D8,Data!C8)","v":"HDD"},{"$f":"IF(Override!E8<>\"\",Override!E8,Data!D8)","v":"HDD_2"},{"$f":"IF(Override!F8<>\"\",Override!F8,Data!E8)","v":"Heat Pump"},"Selected",{"$f":"IF(Override!H8<>\"\",Override!H8,Data!G8)","v":0},{"$f":"IF(Override!I8<>\"\",Override!I8,Data!H8)","v":0},{"$f":"IF(Override!J8<>\"\",Override!J8,Data!I8)","v":0},{"$f":"IF(Override!K8<>\"\",Override!K8,Data!J8)","v":0},{"$f":"IF(Override!L8<>\"\",Override!L8,Data!K8)","v":0},{"$f":"IF(Override!M8<>\"\",Override!M8,Data!L8)","v":0},{"$f":"IF(Override!N8<>\"\",Override!N8,Data!M8)","v":0},{"$f":"IF(Override!O8<>\"\",Override!O8,Data!N8)","v":0},{"$f":"IF(Override!P8<>\"\",Override!P8,Data!O8)","v":0},{"$f":"IF(Override!Q8<>\"\",Override!Q8,Data!P8)","v":0},{"$f":"IF(Override!R8<>\"\",Override!R8,Data!Q8)","v":0},{"$f":"IF(Override!S8<>\"\",Override!S8,Data!R8)","v":0},"-","-",{"$f":"VLOOKUP(B8,'Phase 2'!B8:W37,22,FALSE)","v":"Fail"}]
["Yes",5,{"$f":"IF(Override!D9<>\"\",Override!D9,Data!C9)","v":"SEW"},{"$f":"IF(Override!E9<>\"\",Override!E9,Data!D9)","v":"SEW_1"},{"$f":"IF(Override!F9<>\"\",Override!F9,Data!E9)","v":"Ozone upgrade at Barcombe"},{"$f":"IF(Override!G9<>\"\",Override!G9,Data!F9)","v":"Selected"},{"$f":"IF(Override!H9<>\"\",Override!H9,Data!G9)","v":0.15345335470050001},{"$f":"IF(Override!I9<>\"\",Override!I9,Data!H9)","v":0.39897872222129999},{"$f":"IF(Override!J9<>\"\",Override!J9,Data!I9)","v":1.2583175085441001},{"$f":"IF(Override!K9<>\"\",Override!K9,Data!J9)","v":1.2583175085441001},{"$f":"IF(Override!L9<>\"\",Override!L9,Data!K9)","v":9.9301329999999993E-2},{"$f":"IF(Override!M9<>\"\",Override!M9,Data!L9)","v":3.1683684240100005},{"$f":"IF(Override!N9<>\"\",Override!N9,Data!M9)","v":0},{"$f":"IF(Override!O9<>\"\",Override!O9,Data!N9)","v":0},{"$f":"IF(Override!P9<>\"\",Override!P9,Data!O9)","v":0},{"$f":"IF(Override!Q9<>\"\",Override!Q9,Data!P9)","v":0},{"$f":"IF(Override!R9<>\"\",Override!R9,Data!Q9)","v":-573},{"$f":"IF(Override!S9<>\"\",Override!S9,Data!R9)","v":-573},5.5294387853577671,5529.4387853577673,{"$f":"VLOOKUP(B9,'Phase 2'!B9:W38,22,FALSE)","v":"Fail"}]
["Yes",6,{"$f":"IF(Override!D10<>\"\",Override!D10,Data!C10)","v":"SEW"},{"$f":"IF(Override!E10<>\"\",Override!E10,Data!D10)","v":"SEW_2"},{"$f":"IF(Override!F10<>\"\",Override!F10,Data!E10)","v":"Ozone upgrade at Arlington"},{"$f":"IF(Override!G10<>\"\",Override!G10,Data!F10)","v":"Selected"},{"$f":"IF(Override!H10<>\"\",Override!H10,Data!G10)","v":5.9230617873300001E-2},{"$f":"IF(Override!I10<>\"\",Override!I10,Data!H10)","v":0.15399960647058},{"$f":"IF(Override!J10<>\"\",Override!J10,Data!I10)","v":0.48569106656105993},{"$f":"IF(Override!K10<>\"\",Override!K10,Data!J10)","v":0.48569106656105993},{"$f":"IF(Override!L10<>\"\",Override!L10,Data!K10)","v":3.5806839999999993E-2},{"$f":"IF(Override!M10<>\"\",Override!M10,Data!L10)","v":1.2204191974659997},{"$f":"IF(Override!N10<>\"\",Override!N10,Data!M10)","v":0},{"$f":"IF(Override!O10<>\"\",Override!O10,Data!N10)","v":0},{"$f":"IF(Override!P10<>\"\",Override!P10,Data!O10)","v":0},{"$f":"IF(Override!Q10<>\"\",Override!Q10,Data!P10)","v":0},{"$f":"IF(Override!R10<>\"\",Override!R10,Data!Q10)","v":-114},{"$f":"IF(Override!S10<>\"\",Override!S10,Data!R10)","v":-114},10.705431556719297,10705.431556719297,{"$f":"VLOOKUP(B10,'Phase 2'!B10:W39,22,FALSE)","v":"Fail"}]
["No",7,{"$f":"IF(Override!D11<>\"\",Override!D11,Data!C11)","v":"SEW"},{"$f":"IF(Override!E11<>\"\",Override!E11,Data!D11)","v":"SEW_3"},{"$f":"IF(Override!F11<>\"\",Override!F11,Data!E11)","v":"Power resilience (generators)"},{"$f":"IF(Override!G11<>\"\",Override!G11,Data!F11)","v":"Selected"},{"$f":"IF(Override!H11<>\"\",Override!H11,Data!G11)","v":0},{"$f":"IF(Override!I11<>\"\",Override!I11,Data!H11)","v":0},{"$f":"IF(Override!J11<>\"\",Override!J11,Data!I11)","v":0},{"$f":"IF(Override!K11<>\"\",Override!K11,Data!J11)","v":0},{"$f":"IF(Override!L11<>\"\",Override!L11,Data!K11)","v":0},{"$f":"IF(Override!M11<>\"\",Override!M11,Data!L11)","v":0},{"$f":"IF(Override!N11<>\"\",Override!N11,Data!M11)","v":0},{"$f":"IF(Override!O11<>\"\",Override!O11,Data!N11)","v":0},{"$f":"IF(Override!P11<>\"\",Override!P11,Data!O11)","v":0},{"$f":"IF(Override!Q11<>\"\",Override!Q11,Data!P11)","v":0},{"$f":"IF(Override!R11<>\"\",Override!R11,Data!Q11)","v":0},{"$f":"IF(Override!S11<>\"\",Override!S11,Data!R11)","v":0},"-","-",{"$f":"VLOOKUP(B11,'Phase 2'!B11:W40,22,FALSE)","v":"Fail"}]
["Yes",8,{"$f":"IF(Override!D12<>\"\",Override!D12,Data!C12)","v":"SEW"},{"$f":"IF(Override!E12<>\"\",Override!E12,Data!D12)","v":"SEW_4"},{"$f":"IF(Override!F12<>\"\",Override!F12,Data!E12)","v":"Transport offset (Electrifying fleet)"},{"$f":"IF(Override!G12<>\"\",Override!G12,Data!F12)","v":"Selected"},{"$f":"IF(Override!H12<>\"\",Override!H12,Data!G12)","v":1.6053696},{"$f":"IF(Override!I12<>\"\",Override!I12,Data!H12)","v":1.4698097999999999},{"$f":"IF(Override!J12<>\"\",Override!J12,Data!I12)","v":1.9138482000000001},{"$f":"IF(Override!K12<>\"\",Override!K12,Data!J12)","v":1.3374522},{"$f":"IF(Override!L12<>\"\",Override!L12,Data!K12)","v":1.8807588},{"$f":"IF(Override!M12<>\"\",Override!M12,Data!L12)","v":8.2072386000000002},{"$f":"IF(Override!N12<>\"\",Override!N12,Data!M12)","v":-181},{"$f":"IF(Override!O12<>\"\",Override!O12,Data!N12)","v":-423},{"$f":"IF(Override!P12<>\"\",Override!P12,Data!O12)","v":-707},{"$f":"IF(Override!Q12<>\"\",Override!Q12,Data!P12)","v":-888},{"$f":"IF(Override!R12<>\"\",Override!R12,Data!Q12)","v":-1371},{"$f":"IF(Override!S12<>\"\",Override!S12,Data!R12)","v":-1371},5.9863155361050335,5986.315536105034,{"$f":"VLOOKUP(B12,'Phase 2'!B12:W41,22,FALSE)","v":"Fail"}]
["Yes",9,{"$f":"IF(Override!D13<>\"\",Override!D13,Data!C13)","v":"SSC"},{"$f":"IF(Override!E13<>\"\",Override!E13,Data!D13)","v":"SSC_CW21_1"},{"$f":"IF(Override!F13<>\"\",Override!F13,Data!E13)","v":"Renewable electricity behind the meter assets "},{"$f":"IF(Override!G13<>\"\",Override!G13,Data!F13)","v":"Selected"},{"$f":"IF(Override!H13<>\"\",Override!H13,Data!G13)","v":0},{"$f":"IF(Override!I13<>\"\",Override!I13,Data!H13)","v":0},{"$f":"IF(Override!J13<>\"\",Override!J13,Data!I13)","v":1.7583852400506379},{"$f":"IF(Override!K13<>\"\",Override!K13,Data!J13)","v":5.4783852400506383},{"$f":"IF(Override!L13<>\"\",Override!L13,Data!K13)","v":0},{"$f":"IF(Override!M13<>\"\",Override!M13,Data!L13)","v":7.236770480101276},{"$f":"IF(Override!N13<>\"\",Override!N13,Data!M13)","v":0},{"$f":"IF(Override!O13<>\"\",Override!O13,Data!N13)","v":0},{"$f":"IF(Override!P13<>\"\",Override!P13,Data!O13)","v":0},{"$f":"IF(Override!Q13<>\"\",Override!Q13,Data!P13)","v":-297.262},{"$f":"IF(Override!R13<>\"\",Override!R13,Data!Q13)","v":-1551.2619999999999},{"$f":"IF(Override!S13<>\"\",Override!S13,Data!R13)","v":-1551.2619999999999},4.6650858978697833,4665.0858978697834,{"$f":"VLOOKUP(B13,'Phase 2'!B13:W42,22,FALSE)","v":"Fail"}]
["Yes",10,{"$f":"IF(Override!D14<>\"\",Override!D14,Data!C14)","v":"SVE"},{"$f":"IF(Override!E14<>\"\",Override!E14,Data!D14)","v":"NZ#1w"},{"$f":"IF(Override!F14<>\"\",Override!F14,Data!E14)","v":"EV Charging Infrastructure"},{"$f":"IF(Override!G14<>\"\",Override!G14,Data!F14)","v":"Selected"},{"$f":"IF(Override!H14<>\"\",Override!H14,Data!G14)","v":0},{"$f":"IF(Override!I14<>\"\",Override!I14,Data!H14)","v":0.88},{"$f":"IF(Override!J14<>\"\",Override!J14,Data!I14)","v":0},{"$f":"IF(Override!K14<>\"\",Override!K14,Data!J14)","v":0},{"$f":"IF(Override!L14<>\"\",Override!L14,Data!K14)","v":0},{"$f":"IF(Override!M14<>\"\",Override!M14,Data!L14)","v":0.88},{"$f":"IF(Override!N14<>\"\",Override!N14,Data!M14)","v":0},{"$f":"IF(Override!O14<>\"\",Override!O14,Data!N14)","v":0},{"$f":"IF(Override!P14<>\"\",Override!P14,Data!O14)","v":-380.6},{"$f":"IF(Override!Q14<>\"\",Override!Q14,Data!P14)","v":-1141.8},{"$f":"IF(Override!R14<>\"\",Override!R14,Data!Q14)","v":-2283.6},{"$f":"IF(Override!S14<>\"\",Override!S14,Data!R14)","v":-2283.6},0.38535645472061658,385.35645472061657,{"$f":"VLOOKUP(B14,'Phase 2'!B14:W43,22,FALSE)","v":"Fail"}]
["Yes",11,{"$f":"IF(Override!D15<>\"\",Override!D15,Data!C15)","v":"SVE"},{"$f":"IF(Override!E15<>\"\",Override!E15,Data!D15)","v":"NZ#2w"},{"$f":"IF(Override!F15<>\"\",Override!F15,Data!E15)","v":"Heat pumps"},{"$f":"IF(Override!G15<>\"\",Override!G15,Data!F15)","v":"Selected"},{"$f":"IF(Override!H15<>\"\",Override!H15,Data!G15)","v":8.0640000000000001},{"$f":"IF(Override!I15<>\"\",Override!I15,Data!H15)","v":0},{"$f":"IF(Override!J15<>\"\",Override!J15,Data!I15)","v":-7.2999999999999995E-2},{"$f":"IF(Override!K15<>\"\",Override!K15,Data!J15)","v":-0.11},{"$f":"IF(Override!L15<>\"\",Override!L15,Data!K15)","v":-0.11},{"$f":"IF(Override!M15<>\"\",Override!M15,Data!L15)","v":7.7709999999999999},{"$f":"IF(Override!N15<>\"\",Override!N15,Data!M15)","v":0},{"$f":"IF(Override!O15<>\"\",Override!O15,Data!N15)","v":0},{"$f":"IF(Override!P15<>\"\",Override!P15,Data!O15)","v":-465},{"$f":"IF(Override!Q15<>\"\",Override!Q15,Data!P15)","v":-1395},{"$f":"IF(Override!R15<>\"\",Override!R15,Data!Q15)","v":-2790},{"$f":"IF(Override!S15<>\"\",Override!S15,Data!R15)","v":-2790},2.785304659498208,2785.3046594982079,{"$f":"VLOOKUP(B15,'Phase 2'!B15:W44,22,FALSE)","v":"Fail"}]
["Yes",12,{"$f":"IF(Override!D16<>\"\",Override!D16,Data!C16)","v":"SVE"},{"$f":"IF(Override!E16<>\"\",Override!E16,Data!D16)","v":"NZ#3w"},{"$f":"IF(Override!F16<>\"\",Override!F16,Data!E16)","v":"HVO diesel replacement"},{"$f":"IF(Override!G16<>\"\",Override!G16,Data!F16)","v":"Selected"},{"$f":"IF(Override!H16<>\"\",Override!H16,Data!G16)","v":0.33100000000000002},{"$f":"IF(Override!I16<>\"\",Override!I16,Data!H16)","v":0},{"$f":"IF(Override!J16<>\"\",Override!J16,Data!I16)","v":0},{"$f":"IF(Override!K16<>\"\",Override!K16,Data!J16)","v":0},{"$f":"IF(Override!L16<>\"\",Override!L16,Data!K16)","v":0},{"$f":"IF(Override!M16<>\"\",Override!M16,Data!L16)","v":0.33100000000000002},{"$f":"IF(Override!N16<>\"\",Override!N16,Data!M16)","v":0},{"$f":"IF(Override!O16<>\"\",Override!O16,Data!N16)","v":0},{"$f":"IF(Override!P16<>\"\",Override!P16,Data!O16)","v":-693},{"$f":"IF(Override!Q16<>\"\",Override!Q16,Data!P16)","v":-2079},{"$f":"IF(Override!R16<>\"\",Override!R16,Data!Q16)","v":-4158},{"$f":"IF(Override!S16<>\"\",Override!S16,Data!R16)","v":-4158},7.960557960557961E-2,79.605579605579607,{"$f":"VLOOKUP(B16,'Phase 2'!B16:W45,22,FALSE)","v":"Fail"}]
["Yes",13,{"$f":"IF(Override!D17<>\"\",Override!D17,Data!C17)","v":"SVE"},{"$f":"IF(Override!E17<>\"\",Override!E17,Data!D17)","v":"NZ#4w"},{"$f":"IF(Override!F17<>\"\",Override!F17,Data!E17)","v":"Hydrogen Production"},{"$f":"IF(Override!G17<>\"\",Override!G17,Data!F17)","v":"Feasible"},{"$f":"IF(Override!H17<>\"\",Override!H17,Data!G17)","v":0.55000000000000004},{"$f":"IF(Override!I17<>\"\",Override!I17,Data!H17)","v":0.55000000000000004},{"$f":"IF(Override!J17<>\"\",Override!J17,Data!I17)","v":0.29000000000000004},{"$f":"IF(Override!K17<>\"\",Override!K17,Data!J17)","v":0.29000000000000004},{"$f":"IF(Override!L17<>\"\",Override!L17,Data!K17)","v":0.29000000000000004},{"$f":"IF(Override!M17<>\"\",Override!M17,Data!L17)","v":1.9700000000000002},{"$f":"IF(Override!N17<>\"\",Override!N17,Data!M17)","v":0},{"$f":"IF(Override!O17<>\"\",Override!O17,Data!N17)","v":0},{"$f":"IF(Override!P17<>\"\",Override!P17,Data!O17)","v":-985.6},{"$f":"IF(Override!Q17<>\"\",Override!Q17,Data!P17)","v":-1971.2},{"$f":"IF(Override!R17<>\"\",Override!R17,Data!Q17)","v":-2956.8},{"$f":"IF(Override!S17<>\"\",Override!S17,Data!R17)","v":-2956.8},0.66626082251082253,666.26082251082255,{"$f":"VLOOKUP(B17,'Phase 2'!B17:W46,22,FALSE)","v":"Fail"}]
["Yes",14,{"$f":"IF(Override!D18<>\"\",Override!D18,Data!C18)","v":"SVE"},{"$f":"IF(Override!E18<>\"\",Override!E18,Data!D18)","v":"NZ#5w"},{"$f":"IF(Override!F18<>\"\",Override!F18,Data!E18)","v":"Electrical storage"},{"$f":"IF(Override!G18<>\"\",Override!G18,Data!F18)","v":"Feasible"},{"$f":"IF(Override!H18<>\"\",Override!H18,Data!G18)","v":1.21},{"$f":"IF(Override!I18<>\"\",Override!I18,Data!H18)","v":1.21},{"$f":"IF(Override!J18<>\"\",Override!J18,Data!I18)","v":0.70599999999999996},{"$f":"IF(Override!K18<>\"\",Override!K18,Data!J18)","v":0.70599999999999996},{"$f":"IF(Override!L18<>\"\",Override!L18,Data!K18)","v":0.70599999999999996},{"$f":"IF(Override!M18<>\"\",Override!M18,Data!L18)","v":4.5380000000000003},{"$f":"IF(Override!N18<>\"\",Override!N18,Data!M18)","v":" -   "},{"$f":"IF(Override!O18<>\"\",Override!O18,Data!N18)","v":" -   "},{"$f":"IF(Override!P18<>\"\",Override!P18,Data!O18)","v":-40.15},{"$f":"IF(Override!Q18<>\"\",Override!Q18,Data!P18)","v":-80.3},{"$f":"IF(Override!R18<>\"\",Override!R18,Data!Q18)","v":-120.45},{"$f":"IF(Override!S18<>\"\",Override!S18,Data!R18)","v":-120.45},37.675383976753842,37675.383976753845,{"$f":"VLOOKUP(B18,'Phase 2'!B18:W47,22,FALSE)","v":"Fail"}]
["Yes",15,{"$f":"IF(Override!D19<>\"\",Override!D19,Data!C19)","v":"SVE"},{"$f":"IF(Override!E19<>\"\",Override!E19,Data!D19)","v":"NZ#6w"},{"$f":"IF(Override!F19<>\"\",Override!F19,Data!E19)","v":"EV fleet only"},{"$f":"IF(Override!G19<>\"\",Override!G19,Data!F19)","v":"Feasible"},{"$f":"IF(Override!H19<>\"\",Override!H19,Data!G19)","v":0.80300000000000005},{"$f":"IF(Override!I19<>\"\",Override!I19,Data!H19)","v":0.80300000000000005},{"$f":"IF(Override!J19<>\"\",Override!J19,Data!I19)","v":0.80300000000000005},{"$f":"IF(Override!K19<>\"\",Override!K19,Data!J19)","v":0.80300000000000005},{"$f":"IF(Override!L19<>\"\",Override!L19,Data!K19)","v":0.80300000000000005},{"$f":"IF(Override!M19<>\"\",Override!M19,Data!L19)","v":4.0150000000000006},{"$f":"IF(Override!N19<>\"\",Override!N19,Data!M19)","v":0},{"$f":"IF(Override!O19<>\"\",Override!O19,Data!N19)","v":-381},{"$f":"IF(Override!P19<>\"\",Override!P19,Data!O19)","v":-1142},{"$f":"IF(Override!Q19<>\"\",Override!Q19,Data!P19)","v":-2284},{"$f":"IF(Override!R19<>\"\",Override!R19,Data!Q19)","v":-3806},{"$f":"IF(Override!S19<>\"\",Override!S19,Data!R19)","v":-3806},1.054913294797688,1054.913294797688,{"$f":"VLOOKUP(B19,'Phase 2'!B19:W48,22,FALSE)","v":"Fail"}]
["Yes",16,{"$f":"IF(Override!D20<>\"\",Override!D20,Data!C20)","v":"SVE"},{"$f":"IF(Override!E20<>\"\",Override!E20,Data!D20)","v":"NZ#7w"},{"$f":"IF(Override!F20<>\"\",Override!F20,Data!E20)","v":"HVO fuel only"},{"$f":"IF(Override!G20<>\"\",Override!G20,Data!F20)","v":"Feasible"},{"$f":"IF(Override!H20<>\"\",Override!H20,Data!G20)","v":0.44},{"$f":"IF(Override!I20<>\"\",Override!I20,Data!H20)","v":0.44},{"$f":"IF(Override!J20<>\"\",Override!J20,Data!I20)","v":0.44},{"$f":"IF(Override!K20<>\"\",Override!K20,Data!J20)","v":0.44},{"$f":"IF(Override!L20<>\"\",Override!L20,Data!K20)","v":0.44},{"$f":"IF(Override!M20<>\"\",Override!M20,Data!L20)","v":2.2000000000000002},{"$f":"IF(Override!N20<>\"\",Override!N20,Data!M20)","v":-2776.4},{"$f":"IF(Override!O20<>\"\",Override!O20,Data!N20)","v":-5552.8},{"$f":"IF(Override!P20<>\"\",Override!P20,Data!O20)","v":-8329.2000000000007},{"$f":"IF(Override!Q20<>\"\",Override!Q20,Data!P20)","v":-11105.6},{"$f":"IF(Override!R20<>\"\",Override!R20,Data!Q20)","v":-13882},{"$f":"IF(Override!S20<>\"\",Override!S20,Data!R20)","v":-13882},0.15847860538827258,158.47860538827257,{"$f":"VLOOKUP(B20,'Phase 2'!B20:W49,22,FALSE)","v":"Fail"}]
["Yes",17,{"$f":"IF(Override!D21<>\"\",Override!D21,Data!C21)","v":"SVE"},{"$f":"IF(Override!E21<>\"\",Override!E21,Data!D21)","v":"NZ#8w"},{"$f":"IF(Override!F21<>\"\",Override!F21,Data!E21)","v":"Solar PV"},{"$f":"IF(Override!G21<>\"\",Override!G21,Data!F21)","v":"Feasible"},{"$f":"IF(Override!H21<>\"\",Override!H21,Data!G21)","v":2.86},{"$f":"IF(Override!I21<>\"\",Override!I21,Data!H21)","v":2.86},{"$f":"IF(Override!J21<>\"\",Override!J21,Data!I21)","v":-0.3490000000000002},{"$f":"IF(Override!K21<>\"\",Override!K21,Data!J21)","v":-0.3490000000000002},{"$f":"IF(Override!L21<>\"\",Override!L21,Data!K21)","v":-0.3490000000000002},{"$f":"IF(Override!M21<>\"\",Override!M21,Data!L21)","v":4.6729999999999992},{"$f":"IF(Override!N21<>\"\",Override!N21,Data!M21)","v":0},{"$f":"IF(Override!O21<>\"\",Override!O21,Data!N21)","v":0},{"$f":"IF(Override!P21<>\"\",Override!P21,Data!O21)","v":-3208.788},{"$f":"IF(Override!Q21<>\"\",Override!Q21,Data!P21)","v":-6417.576},{"$f":"IF(Override!R21<>\"\",Override!R21,Data!Q21)","v":-9626.3639999999996},{"$f":"IF(Override!S21<>\"\",Override!S21,Data!R21)","v":-9626.3639999999996},0.4854377000495721,485.43770004957207,{"$f":"VLOOKUP(B21,'Phase 2'!B21:W50,22,FALSE)","v":"Fail"}]
["Yes",18,{"$f":"IF(Override!D22<>\"\",Override!D22,Data!C22)","v":"TMS"},{"$f":"IF(Override!E22<>\"\",Override!E22,Data!D22)","v":"CW21_1"},{"$f":"IF(Override!F22<>\"\",Override!F22,Data!E22)","v":"S40840/2 (PR24 Fleet - Life expired Enhancement (cost to convert to electrical) (Water))"},{"$f":"IF(Override!G22<>\"\",Override!G22,Data!F22)","v":"Feasible"},{"$f":"IF(Override!H22<>\"\",Override!H22,Data!G22)","v":4.4779999999999998},{"$f":"IF(Override!I22<>\"\",Override!I22,Data!H22)","v":4.0190000000000001},{"$f":"IF(Override!J22<>\"\",Override!J22,Data!I22)","v":3.1510000000000002},{"$f":"IF(Override!K22<>\"\",Override!K22,Data!J22)","v":2.133},{"$f":"IF(Override!L22<>\"\",Override!L22,Data!K22)","v":9.2999999999999972E-2},{"$f":"IF(Override!M22<>\"\",Override!M22,Data!L22)","v":13.874000000000001},{"$f":"IF(Override!N22<>\"\",Override!N22,Data!M22)","v":-808},{"$f":"IF(Override!O22<>\"\",Override!O22,Data!N22)","v":-2100},{"$f":"IF(Override!P22<>\"\",Override!P22,Data!O22)","v":-3847},{"$f":"IF(Override!Q22<>\"\",Override!Q22,Data!P22)","v":-6094},{"$f":"IF(Override!R22<>\"\",Override!R22,Data!Q22)","v":-8762},{"$f":"IF(Override!S22<>\"\",Override!S22,Data!R22)","v":-8762},1.5834284409952066,1583.4284409952065,{"$f":"VLOOKUP(B22,'Phase 2'!B22:W51,22,FALSE)","v":"Fail"}]
["Yes",19,{"$f":"IF(Override!D23<>\"\",Override!D23,Data!C23)","v":"TMS"},{"$f":"IF(Override!E23<>\"\",Override!E23,Data!D23)","v":"CW21_2"},{"$f":"IF(Override!F23<>\"\",Override!F23,Data!E23)","v":"S40142/2 (PR24 Hybrid air source heat pump/existing boiler for 4 corporate offices (Water))"},{"$f":"IF(Override!G23<>\"\",Override!G23,Data!F23)","v":"Feasible"},{"$f":"IF(Override!H23<>\"\",Override!H23,Data!G23)","v":0.40400000000000003},{"$f":"IF(Override!I23<>\"\",Override!I23,Data!H23)","v":0.35399999999999998},{"$f":"IF(Override!J23<>\"\",Override!J23,Data!I23)","v":-3.5999999999999997E-2},{"$f":"IF(Override!K23<>\"\",Override!K23,Data!J23)","v":-2.4E-2},{"$f":"IF(Override!L23<>\"\",Override!L23,Data!K23)","v":-1.7000000000000001E-2},{"$f":"IF(Override!M23<>\"\",Override!M23,Data!L23)","v":0.68100000000000005},{"$f":"IF(Override!N23<>\"\",Override!N23,Data!M23)","v":-132.5},{"$f":"IF(Override!O23<>\"\",Override!O23,Data!N23)","v":-397.52},{"$f":"IF(Override!P23<>\"\",Override!P23,Data!O23)","v":-662.54},{"$f":"IF(Override!Q23<>\"\",Override!Q23,Data!P23)","v":-927.56},{"$f":"IF(Override!R23<>\"\",Override!R23,Data!Q23)","v":-1192.58},{"$f":"IF(Override!S23<>\"\",Override!S23,Data!R23)","v":-1192.58},0.57103087423904475,571.03087423904481,{"$f":"VLOOKUP(B23,'Phase 2'!B23:W52,22,FALSE)","v":"Fail"}]
["Yes",20,{"$f":"IF(Override!D24<>\"\",Override!D24,Data!C24)","v":"TMS"},{"$f":"IF(Override!E24<>\"\",Override!E24,Data!D24)","v":"CW21_3"},{"$f":"IF(Override!F24<>\"\",Override!F24,Data!E24)","v":"S40144/2 (PR24 Air source heat pump for site office (enhancement cost) (Water))"},{"$f":"IF(Override!G24<>\"\",Override!G24,Data!F24)","v":"Feasible"},{"$f":"IF(Override!H24<>\"\",Override!H24,Data!G24)","v":0.33700000000000002},{"$f":"IF(Override!I24<>\"\",Override!I24,Data!H24)","v":0.35000000000000003},{"$f":"IF(Override!J24<>\"\",Override!J24,Data!I24)","v":0.36400000000000005},{"$f":"IF(Override!K24<>\"\",Override!K24,Data!J24)","v":0.378},{"$f":"IF(Override!L24<>\"\",Override!L24,Data!K24)","v":0.39400000000000002},{"$f":"IF(Override!M24<>\"\",Override!M24,Data!L24)","v":1.8230000000000002},{"$f":"IF(Override!N24<>\"\",Override!N24,Data!M24)","v":-33.33},{"$f":"IF(Override!O24<>\"\",Override!O24,Data!N24)","v":-100},{"$f":"IF(Override!P24<>\"\",Override!P24,Data!O24)","v":-200.04},{"$f":"IF(Override!Q24<>\"\",Override!Q24,Data!P24)","v":-333.39},{"$f":"IF(Override!R24<>\"\",Override!R24,Data!Q24)","v":-500.06},{"$f":"IF(Override!S24<>\"\",Override!S24,Data!R24)","v":-500.06},3.645562532496101,3645.5625324961011,{"$f":"VLOOKUP(B24,'Phase 2'!B24:W53,22,FALSE)","v":"Fail"}]
["Yes",21,{"$f":"IF(Override!D25<>\"\",Override!D25,Data!C25)","v":"NWT"},{"$f":"IF(Override!E25<>\"\",Override!E25,Data!D25)","v":"E00001340"},{"$f":"IF(Override!F25<>\"\",Override!F25,Data!E25)","v":"Transport fossil fuel reductions - Green fleet LCVs phase 1"},{"$f":"IF(Override!G25<>\"\",Override!G25,Data!F25)","v":"Selected"},{"$f":"IF(Override!H25<>\"\",Override!H25,Data!G25)","v":0.83431418654062639},{"$f":"IF(Override!I25<>\"\",Override!I25,Data!H25)","v":0.86720017290751972},{"$f":"IF(Override!J25<>\"\",Override!J25,Data!I25)","v":1.6590817561861599},{"$f":"IF(Override!K25<>\"\",Override!K25,Data!J25)","v":0.97931001095941539},{"$f":"IF(Override!L25<>\"\",Override!L25,Data!K25)","v":-1.1989696359391653},{"$f":"IF(Override!M25<>\"\",Override!M25,Data!L25)","v":3.1409364906545565},{"$f":"IF(Override!N25<>\"\",Override!N25,Data!M25)","v":-182},{"$f":"IF(Override!O25<>\"\",Override!O25,Data!N25)","v":-774},{"$f":"IF(Override!P25<>\"\",Override!P25,Data!O25)","v":-2050},{"$f":"IF(Override!Q25<>\"\",Override!Q25,Data!P25)","v":-4167},{"$f":"IF(Override!R25<>\"\",Override!R25,Data!Q25)","v":-6671},{"$f":"IF(Override!S25<>\"\",Override!S25,Data!R25)","v":-6671},0.47083443121789187,470.83443121789185,{"$f":"VLOOKUP(B25,'Phase 2'!B25:W54,22,FALSE)","v":"Fail"}]
["No",22,{"$f":"IF(Override!D26<>\"\",Override!D26,Data!C26)","v":"NWT"},{"$f":"IF(Override!E26<>\"\",Override!E26,Data!D26)","v":"E00001341"},{"$f":"IF(Override!F26<>\"\",Override!F26,Data!E26)","v":"Transport fossil fuel reductions - Green fleet LCVs phase 2 "},{"$f":"IF(Override!G26<>\"\",Override!G26,Data!F26)","v":"Selected"},{"$f":"IF(Override!H26<>\"\",Override!H26,Data!G26)","v":0},{"$f":"IF(Override!I26<>\"\",Override!I26,Data!H26)","v":0},{"$f":"IF(Override!J26<>\"\",Override!J26,Data!I26)","v":0},{"$f":"IF(Override!K26<>\"\",Override!K26,Data!J26)","v":0},{"$f":"IF(Override!L26<>\"\",Override!L26,Data!K26)","v":0},{"$f":"IF(Override!M26<>\"\",Override!M26,Data!L26)","v":0},{"$f":"IF(Override!N26<>\"\",Override!N26,Data!M26)","v":0},{"$f":"IF(Override!O26<>\"\",Override!O26,Data!N26)","v":0},{"$f":"IF(Override!P26<>\"\",Override!P26,Data!O26)","v":0},{"$f":"IF(Override!Q26<>\"\",Override!Q26,Data!P26)","v":0},{"$f":"IF(Override!R26<>\"\",Override!R26,Data!Q26)","v":0},{"$f":"IF(Override!S26<>\"\",Override!S26,Data!R26)","v":0},"-","-",{"$f":"VLOOKUP(B26,'Phase 2'!B26:W55,22,FALSE)","v":"Fail"}]
["Yes",23,{"$f":"IF(Override!D27<>\"\",Override!D27,Data!C27)","v":"NWT"},{"$f":"IF(Override!E27<>\"\",Override!E27,Data!D27)","v":"E00001344"},{"$f":"IF(Override!F27<>\"\",Override!F27,Data!E27)","v":"Peatland restoration"},{"$f":"IF(Override!G27<>\"\",Override!G27,Data!F27)","v":"Selected"},{"$f":"IF(Override!H27<>\"\",Override!H27,Data!G27)","v":2.0175224038604949},{"$f":"IF(Override!I27<>\"\",Override!I27,Data!H27)","v":5.5422741585021518},{"$f":"IF(Override!J27<>\"\",Override!J27,Data!I27)","v":5.5009268029786718},{"$f":"IF(Override!K27<>\"\",Override!K27,Data!J27)","v":5.5872058711786297},{"$f":"IF(Override!L27<>\"\",Override!L27,Data!K27)","v":1.8566963094707822},{"$f":"IF(Override!M27<>\"\",Override!M27,Data!L27)","v":20.504625545990727},{"$f":"IF(Override!N27<>\"\",Override!N27,Data!M27)","v":0},{"$f":"IF(Override!O27<>\"\",Override!O27,Data!N27)","v":0},{"$f":"IF(Override!P27<>\"\",Override!P27,Data!O27)","v":0},{"$f":"IF(Override!Q27<>\"\",Override!Q27,Data!P27)","v":0},{"$f":"IF(Override!R27<>\"\",Override!R27,Data!Q27)","v":-13227},{"$f":"IF(Override!S27<>\"\",Override!S27,Data!R27)","v":-13227},1.5502098394186683,1550.2098394186683,{"$f":"VLOOKUP(B27,'Phase 2'!B27:W56,22,FALSE)","v":"Pass"}]
["Yes",24,{"$f":"IF(Override!D28<>\"\",Override!D28,Data!C28)","v":"NWT"},{"$f":"IF(Override!E28<>\"\",Override!E28,Data!D28)","v":"E00001345"},{"$f":"IF(Override!F28<>\"\",Override!F28,Data!E28)","v":"Woodland creation"},{"$f":"IF(Override!G28<>\"\",Override!G28,Data!F28)","v":"Selected"},{"$f":"IF(Override!H28<>\"\",Override!H28,Data!G28)","v":0.84281730484853168},{"$f":"IF(Override!I28<>\"\",Override!I28,Data!H28)","v":0.85751024789435737},{"$f":"IF(Override!J28<>\"\",Override!J28,Data!I28)","v":0.84532302973692108},{"$f":"IF(Override!K28<>\"\",Override!K28,Data!J28)","v":0},{"$f":"IF(Override!L28<>\"\",Override!L28,Data!K28)","v":0},{"$f":"IF(Override!M28<>\"\",Override!M28,Data!L28)","v":2.5456505824798104},{"$f":"IF(Override!N28<>\"\",Override!N28,Data!M28)","v":0},{"$f":"IF(Override!O28<>\"\",Override!O28,Data!N28)","v":0},{"$f":"IF(Override!P28<>\"\",Override!P28,Data!O28)","v":-472.01499999999999},{"$f":"IF(Override!Q28<>\"\",Override!Q28,Data!P28)","v":-854.03},{"$f":"IF(Override!R28<>\"\",Override!R28,Data!Q28)","v":-1662.63},{"$f":"IF(Override!S28<>\"\",Override!S28,Data!R28)","v":-1662.63},1.5310986704677592,1531.0986704677591,{"$f":"VLOOKUP(B28,'Phase 2'!B28:W57,22,FALSE)","v":"Fail"}]
["No",25,{"$f":"IF(Override!D29<>\"\",Override!D29,Data!C29)","v":"NWT"},{"$f":"IF(Override!E29<>\"\",Override!E29,Data!D29)","v":"E00001346"},{"$f":"IF(Override!F29<>\"\",Override!F29,Data!E29)","v":"Property emissions reductions "},{"$f":"IF(Override!G29<>\"\",Override!G29,Data!F29)","v":"Not defined"},{"$f":"IF(Override!H29<>\"\",Override!H29,Data!G29)","v":0},{"$f":"IF(Override!I29<>\"\",Override!I29,Data!H29)","v":0},{"$f":"IF(Override!J29<>\"\",Override!J29,Data!I29)","v":0},{"$f":"IF(Override!K29<>\"\",Override!K29,Data!J29)","v":0},{"$f":"IF(Override!L29<>\"\",Override!L29,Data!K29)","v":0},{"$f":"IF(Override!M29<>\"\",Override!M29,Data!L29)","v":0},{"$f":"IF(Override!N29<>\"\",Override!N29,Data!M29)","v":0},{"$f":"IF(Override!O29<>\"\",Override!O29,Data!N29)","v":0},{"$f":"IF(Override!P29<>\"\",Override!P29,Data!O29)","v":0},{"$f":"IF(Override!Q29<>\"\",Override!Q29,Data!P29)","v":0},{"$f":"IF(Override!R29<>\"\",Override!R29,Data!Q29)","v":0},{"$f":"IF(Override!S29<>\"\",Override!S29,Data!R29)","v":0},"-","-",{"$f":"VLOOKUP(B29,'Phase 2'!B29:W58,22,FALSE)","v":"Fail"}]
["No",26,{"$f":"IF(Override!D30<>\"\",Override!D30,Data!C30)","v":"NWT"},{"$f":"IF(Override!E30<>\"\",Override!E30,Data!D30)","v":"E00001426"},{"$f":"IF(Override!F30<>\"\",Override!F30,Data!E30)","v":"Phase 2 – Further low regrets emissions reductions in AMP8"},{"$f":"IF(Override!G30<>\"\",Override!G30,Data!F30)","v":"Not defined"},{"$f":"IF(Override!H30<>\"\",Override!H30,Data!G30)","v":0},{"$f":"IF(Override!I30<>\"\",Override!I30,Data!H30)","v":0},{"$f":"IF(Override!J30<>\"\",Override!J30,Data!I30)","v":0},{"$f":"IF(Override!K30<>\"\",Override!K30,Data!J30)","v":0},{"$f":"IF(Override!L30<>\"\",Override!L30,Data!K30)","v":0},{"$f":"IF(Override!M30<>\"\",Override!M30,Data!L30)","v":0},{"$f":"IF(Override!N30<>\"\",Override!N30,Data!M30)","v":0},{"$f":"IF(Override!O30<>\"\",Override!O30,Data!N30)","v":0},{"$f":"IF(Override!P30<>\"\",Override!P30,Data!O30)","v":0},{"$f":"IF(Override!Q30<>\"\",Override!Q30,Data!P30)","v":0},{"$f":"IF(Override!R30<>\"\",Override!R30,Data!Q30)","v":0},{"$f":"IF(Override!S30<>\"\",Override!S30,Data!R30)","v":0},"-","-",{"$f":"VLOOKUP(B30,'Phase 2'!B30:W59,22,FALSE)","v":"Fail"}]
["Yes",27,{"$f":"IF(Override!D31<>\"\",Override!D31,Data!C31)","v":"WSH"},{"$f":"IF(Override!E31<>\"\",Override!E31,Data!D31)","v":"CW21_1"},{"$f":"IF(Override!F31<>\"\",Override!F31,Data!E31)","v":"Net Zero Carbon Strategy:  Network Control Systems (Water)"},{"$f":"IF(Override!G31<>\"\",Override!G31,Data!F31)","v":"Selected"},{"$f":"IF(Override!H31<>\"\",Override!H31,Data!G31)","v":0.13100000000000001},{"$f":"IF(Override!I31<>\"\",Override!I31,Data!H31)","v":0.29342451119304636},{"$f":"IF(Override!J31<>\"\",Override!J31,Data!I31)","v":0.29361912797446804},{"$f":"IF(Override!K31<>\"\",Override!K31,Data!J31)","v":0.3094502010380813},{"$f":"IF(Override!L31<>\"\",Override!L31,Data!K31)","v":0.2620131213230088},{"$f":"IF(Override!M31<>\"\",Override!M31,Data!L31)","v":1.2895069615286043},{"$f":"IF(Override!N31<>\"\",Override!N31,Data!M31)","v":-50},{"$f":"IF(Override!O31<>\"\",Override!O31,Data!N31)","v":-165},{"$f":"IF(Override!P31<>\"\",Override!P31,Data!O31)","v":-285},{"$f":"IF(Override!Q31<>\"\",Override!Q31,Data!P31)","v":-400},{"$f":"IF(Override!R31<>\"\",Override!R31,Data!Q31)","v":-500},{"$f":"IF(Override!S31<>\"\",Override!S31,Data!R31)","v":-500},2.5790139230572087,2579.0139230572086,{"$f":"VLOOKUP(B31,'Phase 2'!B31:W60,22,FALSE)","v":"Fail"}]
["Yes",28,{"$f":"IF(Override!D32<>\"\",Override!D32,Data!C32)","v":"WSH"},{"$f":"IF(Override!E32<>\"\",Override!E32,Data!D32)","v":"CW21_2"},{"$f":"IF(Override!F32<>\"\",Override!F32,Data!E32)","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},{"$f":"IF(Override!G32<>\"\",Override!G32,Data!F32)","v":"Selected"},{"$f":"IF(Override!H32<>\"\",Override!H32,Data!G32)","v":2.7374000000000001},{"$f":"IF(Override!I32<>\"\",Override!I32,Data!H32)","v":2.7374000000000001},{"$f":"IF(Override!J32<>\"\",Override!J32,Data!I32)","v":2.7374000000000001},{"$f":"IF(Override!K32<>\"\",Override!K32,Data!J32)","v":2.7374000000000001},{"$f":"IF(Override!L32<>\"\",Override!L32,Data!K32)","v":2.7374000000000001},{"$f":"IF(Override!M32<>\"\",Override!M32,Data!L32)","v":13.686999999999999},{"$f":"IF(Override!N32<>\"\",Override!N32,Data!M32)","v":0},{"$f":"IF(Override!O32<>\"\",Override!O32,Data!N32)","v":0},{"$f":"IF(Override!P32<>\"\",Override!P32,Data!O32)","v":0},{"$f":"IF(Override!Q32<>\"\",Override!Q32,Data!P32)","v":0},{"$f":"IF(Override!R32<>\"\",Override!R32,Data!Q32)","v":0},{"$f":"IF(Override!S32<>\"\",Override!S32,Data!R32)","v":0},"-","-",{"$f":"VLOOKUP(B32,'Phase 2'!B32:W61,22,FALSE)","v":"Pass"}]
["Yes",29,{"$f":"IF(Override!D33<>\"\",Override!D33,Data!C33)","v":"WSX"},{"$f":"IF(Override!E33<>\"\",Override!E33,Data!D33)","v":"CW21_1"},{"$f":"IF(Override!F33<>\"\",Override!F33,Data!E33)","v":"Transport"},{"$f":"IF(Override!G33<>\"\",Override!G33,Data!F33)","v":"Selected"},{"$f":"IF(Override!H33<>\"\",Override!H33,Data!G33)","v":0.39473733923437504},{"$f":"IF(Override!I33<>\"\",Override!I33,Data!H33)","v":0.63486005978232007},{"$f":"IF(Override!J33<>\"\",Override!J33,Data!I33)","v":0.79984976502795002},{"$f":"IF(Override!K33<>\"\",Override!K33,Data!J33)","v":0.80539457990984997},{"$f":"IF(Override!L33<>\"\",Override!L33,Data!K33)","v":0.42109206464072318},{"$f":"IF(Override!M33<>\"\",Override!M33,Data!L33)","v":3.0559338085952183},{"$f":"IF(Override!N33<>\"\",Override!N33,Data!M33)","v":-106},{"$f":"IF(Override!O33<>\"\",Override!O33,Data!N33)","v":-317},{"$f":"IF(Override!P33<>\"\",Override!P33,Data!O33)","v":-633},{"$f":"IF(Override!Q33<>\"\",Override!Q33,Data!P33)","v":-1056},{"$f":"IF(Override!R33<>\"\",Override!R33,Data!Q33)","v":-1584},{"$f":"IF(Override!S33<>\"\",Override!S33,Data!R33)","v":-1584},1.9292511417899105,1929.2511417899104,{"$f":"VLOOKUP(B33,'Phase 2'!B33:W62,22,FALSE)","v":"Fail"}]
["No",30,{"$f":"IF(Override!D34<>\"\",Override!D34,Data!C34)","v":"YKY"},{"$f":"IF(Override!E34<>\"\",Override!E34,Data!D34)","v":"CW21-1"},{"$f":"IF(Override!F34<>\"\",Override!F34,Data!E34)","v":"Solar "},{"$f":"IF(Override!G34<>\"\",Override!G34,Data!F34)","v":0},{"$f":"IF(Override!H34<>\"\",Override!H34,Data!G34)","v":0},{"$f":"IF(Override!I34<>\"\",Override!I34,Data!H34)","v":0},{"$f":"IF(Override!J34<>\"\",Override!J34,Data!I34)","v":0},{"$f":"IF(Override!K34<>\"\",Override!K34,Data!J34)","v":0},{"$f":"IF(Override!L34<>\"\",Override!L34,Data!K34)","v":0},{"$f":"IF(Override!M34<>\"\",Override!M34,Data!L34)","v":0},{"$f":"IF(Override!N34<>\"\",Override!N34,Data!M34)","v":0},{"$f":"IF(Override!O34<>\"\",Override!O34,Data!N34)","v":-1000},{"$f":"IF(Override!P34<>\"\",Override!P34,Data!O34)","v":-2000},{"$f":"IF(Override!Q34<>\"\",Override!Q34,Data!P34)","v":-3000},{"$f":"IF(Override!R34<>\"\",Override!R34,Data!Q34)","v":-3500},{"$f":"IF(Override!S34<>\"\",Override!S34,Data!R34)","v":-3500},0,0,{"$f":"VLOOKUP(B34,'Phase 2'!B34:W63,22,FALSE)","v":"Fail"}]
["Yes",31,{"$f":"IF(Override!D35<>\"\",Override!D35,Data!C35)","v":"SVE"},{"$f":"IF(Override!E35<>\"\",Override!E35,Data!D35)","v":0},{"$f":"IF(Override!F35<>\"\",Override!F35,Data!E35)","v":"Transport PR24"},"Selected",{"$f":"IF(Override!H35<>\"\",Override!H35,Data!G35)","v":8.9309999999999992},{"$f":"IF(Override!I35<>\"\",Override!I35,Data!H35)","v":10.231},{"$f":"IF(Override!J35<>\"\",Override!J35,Data!I35)","v":10.847},{"$f":"IF(Override!K35<>\"\",Override!K35,Data!J35)","v":12.331},{"$f":"IF(Override!L35<>\"\",Override!L35,Data!K35)","v":13.388999999999999},{"$f":"IF(Override!M35<>\"\",Override!M35,Data!L35)","v":55.728999999999999},{"$f":"IF(Override!N35<>\"\",Override!N35,Data!M35)","v":0},{"$f":"IF(Override!O35<>\"\",Override!O35,Data!N35)","v":0},{"$f":"IF(Override!P35<>\"\",Override!P35,Data!O35)","v":0},{"$f":"IF(Override!Q35<>\"\",Override!Q35,Data!P35)","v":0},{"$f":"IF(Override!R35<>\"\",Override!R35,Data!Q35)","v":0},{"$f":"IF(Override!S35<>\"\",Override!S35,Data!R35)","v":0},"-","-",{"$f":"VLOOKUP(B35,'Phase 2'!B35:W64,22,FALSE)","v":"Fail"}]
[null,null,null,null,"Total",{"$f":"COUNTA(F5:F35)","v":31},null,null,null,null,null,{"$f":"SUM(L5:L35)","v":163.6868643208262},null,null,null,null,null,{"$f":"SUM(R5:R35)","v":-81395.566000000006}]

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

{"sheet":"Phase 1","index":8,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,68,4]]}
["Phase 1: Initial assessment"]
["Is the scheme true enhancement, a core business activity and has the reduction of GHG emissions as its primary driver"]
[null,"Schemes submitted",null,null,null,null,null,null,null,"Enhancement expenditure",null,null,"Net zero as the primary driver",null,null,"Core business activity",null,null,"Decisions of phase 1",null,null,"Results of phase 1"]
[null,null,"Company","Scheme ID","Scheme name",null,"Scheme description","Category",null,"Was this activity previously delivered by base expenditure? (Yes/No)","Justification",null,"Is net zero the primary driver of the scheme? (Yes/No)","Justification",null,"Is the scheme a core business activity? (Yes/No)","Justification",null,"Phase 1 assessment decision (pass/fail)","Rationale",null,null,"Company","Scheme ID","Scheme name",null,"AMP8 totex (£m, 2025-30)"]
[null,1,{"$f":"IF(Override!D5<>\"\",Override!D5,Data!C5)","v":"ANH"},"CW21.1",{"$f":"IF(Override!F5<>\"\",Override!F5,Data!E5)","v":"AMP8 Small Scale Solar Delivery WS"},null,"WS Mounted Panels - Solar PV on 400 sites and 20GWhs of electricity","Renewable energy",null,"No","Renewables excluded from price review",null,"Yes","Clear net zero driver - A secondary driver is insulation of energy costs. ",null,"No","Renewable energy investment not considered part of the appointment business",null,{"$f":"IF(OR(J5=\"Yes\",M5=\"No\",P5=\"No\"),\"Fail\",\"Pass\")","v":"Fail"},"Not a core business activity",null,1,{"$f":"IF($S5=\"Pass\",C5,\"\")","v":""},{"$f":"IF($S5=\"Pass\",D5,\"\")","v":""},{"$f":"IF($S5=\"Pass\",E5,\"\")","v":""},null,7.681]
[null,2,{"$f":"IF(Override!D6<>\"\",Override!D6,Data!C6)","v":"AFW"},"AFW_EV",{"$f":"IF(Override!F6<>\"\",Override!F6,Data!E6)","v":"Net Zero: Electric Vehicles"},null,"To replace all operational liveried diesel vehicles with electric vehicles with an aim to remove 1920 TC02e operational carbon per year (the amount emitted by the current diesel vehicles fleet) ","Transport",null,"Yes","Transport historically funded under base allowance. Affinity Water have already been investing in EVs through base in PR19 (20% of fleet should be electric by 2025). This proposal is to support fully transitioning fleet to electric by end of the 2025-2030 period. ",null,"Yes","We consider that charging infrastructures are new assets that will enable an upgrade of the company's transport, with a decarbonised fleet. This scheme is therefore clear enhancement, driven primarily by net zero. ",null,"No",null,null,{"$f":"IF(OR(J6=\"Yes\",M6=\"No\",P6=\"No\"),\"Fail\",\"Pass\")","v":"Fail"},"Should continue to be funded by Base allowance",null,2,"","","",null,4.3019999999999996]
[null,3,{"$f":"IF(Override!D7<>\"\",Override!D7,Data!C7)","v":"HDD"},"HDD_1",{"$f":"IF(Override!F7<>\"\",Override!F7,Data!E7)","v":"Electric Vehicles & Low Carbon fuels transition"},null,"Partial transition during 2025-2030 period, with electric vehcile chargers and HVO fuel","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","National Environment Programme (NEP) Driver for net zero",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,3,"","","",null,1.145]
[null,4,{"$f":"IF(Override!D8<>\"\",Override!D8,Data!C8)","v":"HDD"},"HDD_2",{"$f":"IF(Override!F8<>\"\",Override!F8,Data!E8)","v":"Heat Pump"},null,"Heat pumps at manned operational sites to reduce gas and electricity use","Heat pumps",null,"Yes","Heating historically funded under base allowance. ",null,"Yes","National Environment Programme (NEP) driver for net zero",null,"No",null,null,"Fail","Should continue to be funded by Base allowance",null,4,"","","",null,1.4999999999999999E-2]
[null,5,{"$f":"IF(Override!D9<>\"\",Override!D9,Data!C9)","v":"SEW"},"SEW_1",{"$f":"IF(Override!F9<>\"\",Override!F9,Data!E9)","v":"Ozone upgrade at Barcombe"},null,"Upgrade of the current air-fed ozone treatment plant at Barcombe to a liquid oxygen fed ozone treatment plant. This will drastically reduce plant emissions, energy usage and reduce operating costs.","Process emissions",null,"No","This is deployment of an existing technology. It is an upgrade to the site.",null,"No","The programme delivers reduction in energy demand which is equated with emissions. This is a cost reduction primarily. The emissions reduction can be made by transition to renewables",null,"Yes",null,null,"Fail","The scheme is not primarily driven by Net Zero. The justification provided for Net Zero Enhancement is countered by the fact the energy demand can be transitioned to renewable energy, the case is for efficiency of energy using an alternative but common technique in the sector",null,5,"","","",null,3.1680000000000001]
[null,6,{"$f":"IF(Override!D10<>\"\",Override!D10,Data!C10)","v":"SEW"},"SEW_2",{"$f":"IF(Override!F10<>\"\",Override!F10,Data!E10)","v":"Ozone upgrade at Arlington"},null,"Upgrade of the current air-fed ozone treatment plant at Arlington to a liquid oxygen fed ozone treatment plant. This will drastically reduce plant emissions, energy usage and reduce operating costs.","Process emissions",null,"No","This is deployment of an existing technology. It is an upgrade to the site.",null,"No","The programme delivers reduction in energy demand which is equated with emissions. This is a cost reduction primarily. The emissions reduction can be made by transition to renewables",null,"Yes",null,null,"Fail","The scheme is not primarily driven by Net Zero. The justification provided for Net Zero Enhancement is countered by the fact the energy demand can be transitioned to renewable energy, the case is for efficiency of energy using an alternative but common technique in the sector",null,6,"","","",null,1.22]
[null,7,{"$f":"IF(Override!D11<>\"\",Override!D11,Data!C11)","v":"SEW"},"SEW_3",{"$f":"IF(Override!F11<>\"\",Override!F11,Data!E11)","v":"Power resilience (generators)"},null,"Upgrading existing backup diesel generators with hybrid generators to reduce carbon equivalent emissions. Hybrid generators involve a combination of diesel and battery technologies.","Energy",null,"Yes","Energy scheme historically funded under base allowance.",null,"Yes","Company query response (OFW-OBQ-SEW-065) states resilience is the primary driver",null,"No",null,null,"Fail","Should continue to be funded by Base allowance",null,7,"","","",null,0.53400000000000003]
[null,8,{"$f":"IF(Override!D12<>\"\",Override!D12,Data!C12)","v":"SEW"},"SEW_4",{"$f":"IF(Override!F12<>\"\",Override!F12,Data!E12)","v":"Transport offset (Electrifying fleet)"},null,"Procurement of a new fleet of electric vehicles to reduce company carbon equivalent emissions. A total of 227 vehicles will be procured across 2025-2030 period.","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","Reduction of emissions by transitioning the fleet to EVs",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,8,"","","",null,8.2070000000000007]
[null,9,{"$f":"IF(Override!D13<>\"\",Override!D13,Data!C13)","v":"SSC"},"SSC_CW21_1",{"$f":"IF(Override!F13<>\"\",Override!F13,Data!E13)","v":"Renewable electricity behind the meter assets "},null,"Ground mounted Solar PV at four key sites including two water treatment works","Renewable energy",null,"Yes","Renewables excluded from price review",null,"Yes","Procurement of renewables infrastructure to reduce energy demand and provide clean electricity",null,"No","Renewable energy investment not considered part of the appointment business",null,"Fail","Not a core business activity",null,9,"","","",null,7.2370000000000001]
[null,10,{"$f":"IF(Override!D14<>\"\",Override!D14,Data!C14)","v":"SVE"},"NZ#1w",{"$f":"IF(Override!F14<>\"\",Override!F14,Data!E14)","v":"EV Charging Infrastructure"},null,"EV charge points - Included in our Net Zero Challenge Fund Investment Case","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","Infrastructure to support transition to EVs",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,10,"","","",null,0.88]
[null,11,{"$f":"IF(Override!D15<>\"\",Override!D15,Data!C15)","v":"SVE"},"NZ#2w",{"$f":"IF(Override!F15<>\"\",Override!F15,Data!E15)","v":"Heat pumps"},null,"Replacement of fossil fuel boilers with heat pumps for space heating - Included in our Net Zero Challenge Fund Investment Case","Heat pumps",null,"Yes","Heating historically funded under base allowance. ",null,"Yes","Infrastructure change to support low carbon heating",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,11,"","","",null,7.7709999999999999]
[null,12,{"$f":"IF(Override!D16<>\"\",Override!D16,Data!C16)","v":"SVE"},"NZ#3w",{"$f":"IF(Override!F16<>\"\",Override!F16,Data!E16)","v":"HVO diesel replacement"},null,"Infrastructure to enable replacement of mineral diesel with HVO - Included in our Net Zero Challenge Fund Investment Case","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","Transition to HVO to reduce dependence on fossil diesel",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,12,"","","",null,0.33100000000000002]
[null,13,{"$f":"IF(Override!D17<>\"\",Override!D17,Data!C17)","v":"SVE"},"NZ#4w",{"$f":"IF(Override!F17<>\"\",Override!F17,Data!E17)","v":"Hydrogen Production"},null,"Production of hydrogen by electrolysis of high strength liquors - Not included in our Investment Cases, we consider this to be base expenditure if economic.","Energy",null,"Yes","Energy scheme historically funded under base allowance. Sevent Trent has acknowledged this is Base allowance. ",null,"Yes","Support switch from fossil fuel energy",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,13,"","","",null,1.97]
[null,14,{"$f":"IF(Override!D18<>\"\",Override!D18,Data!C18)","v":"SVE"},"NZ#5w",{"$f":"IF(Override!F18<>\"\",Override!F18,Data!E18)","v":"Electrical storage"},null,"Behind the meter battery storage  - Not included in our Investment Cases, we consider this to be base allowance if economic.","Energy",null,"Yes","Energy scheme historically funded under base allowance. Sevent Trent has acknowledged this is Base allowance. ",null,"Yes","Behind the metter battery storage to increase resilience of electricity supply",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,14,"","","",null,4.5380000000000003]
[null,15,{"$f":"IF(Override!D19<>\"\",Override!D19,Data!C19)","v":"SVE"},"NZ#6w",{"$f":"IF(Override!F19<>\"\",Override!F19,Data!E19)","v":"EV fleet only"},null,"EV vehicles - Not included in our Investment Cases, we consider vehicle replacement to be part of base allowance but note that there is a cost premium for electric vehicles.","Transport",null,"Yes","Previously done under base allowance. Sevent Trent has acknowledged this is Base allowance. ",null,"Yes","Decarbonisation of the vehicle fleet",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,15,"","","",null,4.0149999999999997]
[null,16,{"$f":"IF(Override!D20<>\"\",Override!D20,Data!C20)","v":"SVE"},"NZ#7w",{"$f":"IF(Override!F20<>\"\",Override!F20,Data!E20)","v":"HVO fuel only"},null,"HVO (marginal cost of fuel only) - Not included in our Investment Cases, we consider this to be base expenditure but note that there is a cost premium for HVO fuel.","Transport",null,"Yes","Previously done under base allowance. Sevent Trent has acknowledged this is Base allowance. ",null,"Yes","Bunkers to support transition to HVO to reduce dependence on fossil diesel",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,16,"","","",null,2.2000000000000002]
[null,17,{"$f":"IF(Override!D21<>\"\",Override!D21,Data!C21)","v":"SVE"},"NZ#8w",{"$f":"IF(Override!F21<>\"\",Override!F21,Data!E21)","v":"Solar PV"},null,"Solar PV (other than very small scale) - Not included in our Investment Cases, we consider this to be base expenditure if economic.","Renewable energy",null,"No","Renewables excluded from price review",null,"Yes","Procurement of renewables infrastructure to reduce energy demand and provide clean electricity",null,"No",null,null,"Fail","Not a core business activity",null,17,"","","",null,4.673]
[null,18,{"$f":"IF(Override!D22<>\"\",Override!D22,Data!C22)","v":"TMS"},"CW21_1",{"$f":"IF(Override!F22<>\"\",Override!F22,Data!E22)","v":"S40840/2 (PR24 Fleet - Life expired Enhancement (cost to convert to electrical) (Water))"},null,"Costs above base of converting life-expired transport to electric or alternative fuelled vehicle.","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","Conversion of fleet to EV at end of useful life. ",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,18,"","","",null,13.874000000000001]
[null,19,{"$f":"IF(Override!D23<>\"\",Override!D23,Data!C23)","v":"TMS"},"CW21_2",{"$f":"IF(Override!F23<>\"\",Override!F23,Data!E23)","v":"S40142/2 (PR24 Hybrid air source heat pump/existing boiler for 4 corporate offices (Water))"},null,"Lower GHG emission hybrid heating at four corporate offices","Heat pumps",null,"Yes","Heating historically funded under base allowance. ",null,"Yes","Reduction of emissions through transition to low carbon heat",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,19,"","","",null,0.68100000000000005]
[null,20,{"$f":"IF(Override!D24<>\"\",Override!D24,Data!C24)","v":"TMS"},"CW21_3",{"$f":"IF(Override!F24<>\"\",Override!F24,Data!E24)","v":"S40144/2 (PR24 Air source heat pump for site office (enhancement cost) (Water))"},null,"Lower GHG emission heating for life-expired site office boilers","Heat pumps",null,"Yes","Heating historically funded under base allowance. ",null,"Yes","Reduction of emissions through transition to low carbon heat",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,20,"","","",null,1.823]
[null,21,{"$f":"IF(Override!D25<>\"\",Override!D25,Data!C25)","v":"NWT"},"E00001340",{"$f":"IF(Override!F25<>\"\",Override!F25,Data!E25)","v":"Transport fossil fuel reductions - Green fleet LCVs phase 1"},null,"Procuring zero emission (Electric Vehicle, EV) cars & vans","Transport",null,"Yes","Transport historically funded under base allowance. The scheme replaces light commercial vehicles (diesel) at their end of their life cycle, and the enhancement case is only the extra costs from the base allowance of in the 2025-2030 period. This replacement should be wholly funded from their base allowance.",null,"Yes","Vehicles at their end of life",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,21,"","","",null,3.141]
[null,22,{"$f":"IF(Override!D26<>\"\",Override!D26,Data!C26)","v":"NWT"},"E00001341",{"$f":"IF(Override!F26<>\"\",Override!F26,Data!E26)","v":"Transport fossil fuel reductions - Green fleet LCVs phase 2 "},null,"Procuring zero emission (Electric Vehicle, EV) cars & vans","Transport",null,"Yes","Transport historically funded under base allowance. The scheme includes the cost for switching away from fossil fuel vehicles, complementing 2025-2030 base allowances to replace some vehicles with a like for like option. But it concerns light commercial vehicles and will replace them before their end of life to make sure the all fleet is converted before the end of the 2025-2030 period. ",null,"Yes","Switch of vehicles to EVs before their end of life",null,"No",null,null,"Fail","Should continue to be funded by Base allowance",null,22,"","","",null,6.3410000000000002]
[null,23,{"$f":"IF(Override!D27<>\"\",Override!D27,Data!C27)","v":"NWT"},"E00001344",{"$f":"IF(Override!F27<>\"\",Override!F27,Data!E27)","v":"Peatland restoration"},null,"Restoration of 1,500 ha of peatland in the North West to store carbon and deliver wider benefits, by 2030, verified by Natural England (or equivalent). The alternative to peatland restoration in terms of reducing the impact of eroded peat soil (dissolved organic carbon) on drinking water quality is to upgrade the water treatment works. Without an upgrade the water treatment works may have to operate on a reduced throughput to remove the increase in dissolved organic carbon load. This has an impact on the volume of the output of the water treatment works which may have a knock on impact on local and regional supply and demand and would have increased GHG emissions","NBS",null,"No","Similar interventions previously under base allowance, but the company considers its challenging with the challenges of the 2025-2030 programme to continue doing it under base. UU considers it has explored all emissions reductions opportunities it could deliver through base allowance. It is also above and beyond what is proposed in their 2025-2030 WINEP programme.",null,"Yes","Net zero to reduce GHG through oxidisation. Climate adaptation is also a driver, with rewetting the upland to better face wildfires",null,"Yes","Peatland restoration funded as part of the green recovery decisions, for the improvements it will drive in raw water quality.",null,"Pass","Net zero is the primary driver and peatland restoration relates to core business activity. Peatland restoration passes to phase 2.",null,23,"NWT","E00001344","Peatland restoration",null,20.504999999999999]
[null,24,{"$f":"IF(Override!D28<>\"\",Override!D28,Data!C28)","v":"NWT"},"E00001345",{"$f":"IF(Override!F28<>\"\",Override!F28,Data!E28)","v":"Woodland creation"},null,"Creation of 465 hectares of woodland from planting trees by 2030, verified by the Woodland Carbon Code (or equivalent standard). ","NBS",null,"Yes","Previously funded under base allowance, supported by funding from Defra Nature 4 Climate Fund Pot and Woodland Creation route. The company says there is no guarantee the funding will remain, hence the enhancement case. ",null,"Yes","Sequestration of emissions from woodland creation",null,"No","Tree planting was not considered as a core business activity at this stage. In green recovery decisions, we stated that, at the present time, developing low carbon solutions is likely more important [than carbon offsets].",null,"Fail","Should continue to be funded by Base allowance",null,24,"","","",null,2.5459999999999998]
[null,25,{"$f":"IF(Override!D29<>\"\",Override!D29,Data!C29)","v":"NWT"},"E00001346",{"$f":"IF(Override!F29<>\"\",Override!F29,Data!E29)","v":"Property emissions reductions "},null,"Decarbonising heat within our UUW owned property portfolio, focused at moving away from fossil fuel usage. ","Heat pumps",null,"Yes","Heating historically funded under base allowance. The implicit base allowance for the 2025-2030 period is valued at a continuation of existing assets using fossil fuels. The scheme is about purchase of new assets and step change reduction in emissions (heat pump, boiler replacement)",null,"Yes","The scheme is not net zero challenge enhancement. Replacement of boilers and setting up a low emission heating system is part of maintenance and operations. ",null,"No",null,null,"Fail","Should continue to be funded by Base allowance",null,25,"","","",null,1.206]
[null,26,{"$f":"IF(Override!D30<>\"\",Override!D30,Data!C30)","v":"NWT"},"E00001426",{"$f":"IF(Override!F30<>\"\",Override!F30,Data!E30)","v":"Phase 2 – Further low regrets emissions reductions in AMP8"},null,"Potential HGVs switch to EVs, chemical use reduction with enhanced biological phosphorous removal, process emissions phase 2 and net zero catchment strategy phase 2","Other",null,"No","Interventions mentioned include base allowance (transport) and enhancement (P-removal).",null,"Yes","The company is not clear on which interventions it intends to deploy mid-2025-2030 and what the likely benefits are. We consider there are other price review mechanisms for mid-period funding. ",null,"No",null,null,"Fail","Net zero is not the primary driver",null,26,"","","",null,23.039000000000001]
[null,27,{"$f":"IF(Override!D31<>\"\",Override!D31,Data!C31)","v":"WSH"},"CW21_1",{"$f":"IF(Override!F31<>\"\",Override!F31,Data!E31)","v":"Net Zero Carbon Strategy:  Network Control Systems (Water)"},null,"Delivery of a new Network Control System for Water to reduce energy consumption by using factors such as weather and demand patterns to predict optimum set points, and as a result, control and optimise pumping regimes","Process emissions",null,"No","This scheme has a National Environment Programme (NEP) driver",null,"Yes","National Environment Programme (NEP) non-statutory driver for net zero",null,"Yes",null,null,"Pass",null,null,27,"WSH","CW21_1","Net Zero Carbon Strategy:  Network Control Systems (Water)",null,1.304]
[null,28,{"$f":"IF(Override!D32<>\"\",Override!D32,Data!C32)","v":"WSH"},"CW21_2",{"$f":"IF(Override!F32<>\"\",Override!F32,Data!E32)","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},null,"Restoration of 2000ha of degraded peatland and creation of new woodland (200,000 trees).","NBS",null,"No","WSH has not previously delivered these activities from base. ",null,"Yes","National Environment Programme (NEP) non-statutory driver for net zero",null,"Yes","Peatland restoration funded as part of the green recovery decisions, for the improvements it will drive in raw water quality. Tree planting was not considered as a core business activity at this stage.",null,"Pass","Net zero is the primary driver and peatland restoration relates to core business activity. Peatland restoration passes to phase 2.",null,28,"WSH","CW21_2","Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)",null,25.3]
[null,29,{"$f":"IF(Override!D33<>\"\",Override!D33,Data!C33)","v":"WSX"},"CW21_1",{"$f":"IF(Override!F33<>\"\",Override!F33,Data!E33)","v":"Transport"},null,"Decarbonised fleet infrastructure","Transport",null,"Yes","Transport historically funded under base allowance. ",null,"Yes","Decarbonisation of the fleet, with government legislation changes on purchase of new vehicles by 2035 being the main driver.",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,29,"","","",null,3.056]
[null,30,{"$f":"IF(Override!D34<>\"\",Override!D34,Data!C34)","v":"YKY"},"CW21-1",{"$f":"IF(Override!F34<>\"\",Override!F34,Data!E34)","v":"Solar "},null,"Combination of rooftop and groundmount solar on YW sites.","Renewable energy",null,"No","Renewables excluded from price review",null,"Yes","The focus is on reducing scope 1 and 2 emissions for next AMP, so decreasing carbon intensity of energy consumed is key.",null,"No","Renewable energy investment not considered part of the appointment business",null,"Fail","Not a core business activity",null,30,"","","",null,10.795999999999999]
[null,31,"SVE",null,{"$f":"IF(Override!F35<>\"\",Override!F35,Data!E35)","v":"Transport PR24"},null,"Increased costs associated with transitioning vehicle fleet from diesel to electric vehicles. Scheme only covers vehicles.","Transport",null,"Yes","Transport historically funded under base allowance.",null,"Yes","Current fleet is a significant contributor to emissions. Transitioning diesel vehicles to electric aligns with company's Net Zero ambition and triple carbon pledge.",null,"Yes",null,null,"Fail","Should continue to be funded by Base allowance",null,31,null,null,null,null,55.73]
[]
[null,null,null,"Totex (£m)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 1'!D5:D34)*('Final data'!$L$5:$L$34))","v":107.95786432082619},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totex (£m)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 1'!X5:X34)*('Final data'!$L$5:$L$34))","v":35.481132507519334}]
[null,null,null,"AMP8 benefits (tCO2e)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 1'!D5:D34)*('Final data'!$R$5:$R$34))","v":-81395.566000000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMP8 benefits (tCO2e)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 1'!X5:X34)*('Final data'!$R$5:$R$34))","v":-13727}]
[]
[]
[]
[null,"Process description\nThis phase sought to establish whether the scheme is eligible for Net Zero Enhancement funding. In our process we reviewed each scheme narrative, associated costs, and projected emissions reductions forecast in the Business Plan Table (Table CWW22). \n\nScheme details were assessed to ascertain whether:\n- those technologies should or could be funded by Base; \n- had been funded in a previous Price Review;\n- determine if Net Zero is the primary driver. \n\nFurther to these questions, scheme details were assessed for:\n- alignment with company net zero goals and Long Term Delivery Strategy\n- alignment with Ofwat's Net Zero Principles\n\nOverview of decisions\nSchemes passed to the next phase showed clearly that:\n- Net Zero is the primary driver, even if there were other commercial drivers or otherwise associated with the scheme\n- the scheme was not previously funded under Base expenditure at a previous Price Review\n- the scheme is a core business activity\n- the scheme was not driven by obligations set by WINEP or the Industrial Emissions Directive"]

{"sheet":"Phase 2","index":9,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,1,74,4]]}
["Phase 2: Net zero value assessment"]
["Is the scheme supporting UK government net zero targets, innovation and sector learning and align with our net zero principles"]
[null,"Scheme submitted",null,null,null,null,"Scheme description",null,null,"Additional information requested",null,null,null,"Assessment of tech maturity and contribution to innovation, learning and efficiency",null,null,"Confidence of impact on emissions",null,null,"IED overlap",null,null,"Decisions of phase 2",null,null,"Results of phase 2"]
[null,null,"Company","Scheme ID","Scheme name",null,"Category","Scheme description",null,"Query link","Purpose of query","Description of technology",null,"Innovation rating","Justification",null,"Innovation rating","Justification",null,"Overlap (Yes/No)","Justification",null,"Phase 2 assessment decision (pass/fail)","Justification",null,null,"Company","Scheme ID","Scheme name",null,"AMP8 totex (£m, 2025-30)"]
[null,1,{"$f":"'Phase 1'!W5","v":""},{"$f":"'Phase 1'!X5","v":""},{"$f":"'Phase 1'!Y5","v":""},null,{"$f":"IF(C5<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E5<>\"\", 'Phase 1'!G5, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,1,{"$f":"IF($W5=\"Pass\",C5,\"\")","v":""},{"$f":"IF($W5=\"Pass\",D5,\"\")","v":""},{"$f":"IF($W5=\"Pass\",E5,\"\")","v":""},null,7.681]
[null,2,{"$f":"'Phase 1'!W6","v":""},{"$f":"'Phase 1'!X6","v":""},{"$f":"'Phase 1'!Y6","v":""},null,{"$f":"IF(C6<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E6<>\"\", 'Phase 1'!G6, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,2,"","","",null,4.3019999999999996]
[null,3,{"$f":"'Phase 1'!W7","v":""},{"$f":"'Phase 1'!X7","v":""},{"$f":"'Phase 1'!Y7","v":""},null,{"$f":"IF(C7<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E7<>\"\", 'Phase 1'!G7, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,3,"","","",null,1.145]
[null,4,{"$f":"'Phase 1'!W8","v":""},{"$f":"'Phase 1'!X8","v":""},{"$f":"'Phase 1'!Y8","v":""},null,{"$f":"IF(C8<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E8<>\"\", 'Phase 1'!G8, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,4,"","","",null,1.4999999999999999E-2]
[null,5,{"$f":"'Phase 1'!W9","v":""},{"$f":"'Phase 1'!X9","v":""},{"$f":"'Phase 1'!Y9","v":""},null,{"$f":"IF(C9<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E9<>\"\", 'Phase 1'!G9, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,5,"","","",null,3.1680000000000001]
[null,6,{"$f":"'Phase 1'!W10","v":""},{"$f":"'Phase 1'!X10","v":""},{"$f":"'Phase 1'!Y10","v":""},null,{"$f":"IF(C10<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E10<>\"\", 'Phase 1'!G10, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,6,"","","",null,1.22]
[null,7,{"$f":"'Phase 1'!W11","v":""},{"$f":"'Phase 1'!X11","v":""},{"$f":"'Phase 1'!Y11","v":""},null,{"$f":"IF(C11<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E11<>\"\", 'Phase 1'!G11, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,7,"","","",null,0.53400000000000003]
[null,8,{"$f":"'Phase 1'!W12","v":""},{"$f":"'Phase 1'!X12","v":""},{"$f":"'Phase 1'!Y12","v":""},null,{"$f":"IF(C12<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E12<>\"\", 'Phase 1'!G12, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,8,"","","",null,8.2070000000000007]
[null,9,{"$f":"'Phase 1'!W13","v":""},{"$f":"'Phase 1'!X13","v":""},{"$f":"'Phase 1'!Y13","v":""},null,{"$f":"IF(C13<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E13<>\"\", 'Phase 1'!G13, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,9,"","","",null,7.2370000000000001]
[null,10,{"$f":"'Phase 1'!W14","v":""},{"$f":"'Phase 1'!X14","v":""},{"$f":"'Phase 1'!Y14","v":""},null,{"$f":"IF(C14<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E14<>\"\", 'Phase 1'!G14, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,10,"","","",null,0.88]
[null,11,{"$f":"'Phase 1'!W15","v":""},{"$f":"'Phase 1'!X15","v":""},{"$f":"'Phase 1'!Y15","v":""},null,{"$f":"IF(C15<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E15<>\"\", 'Phase 1'!G15, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,11,"","","",null,7.7709999999999999]
[null,12,{"$f":"'Phase 1'!W16","v":""},{"$f":"'Phase 1'!X16","v":""},{"$f":"'Phase 1'!Y16","v":""},null,{"$f":"IF(C16<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E16<>\"\", 'Phase 1'!G16, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,12,"","","",null,0.33100000000000002]
[null,13,{"$f":"'Phase 1'!W17","v":""},{"$f":"'Phase 1'!X17","v":""},{"$f":"'Phase 1'!Y17","v":""},null,{"$f":"IF(C17<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E17<>\"\", 'Phase 1'!G17, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,13,"","","",null,1.97]
[null,14,{"$f":"'Phase 1'!W18","v":""},{"$f":"'Phase 1'!X18","v":""},{"$f":"'Phase 1'!Y18","v":""},null,{"$f":"IF(C18<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E18<>\"\", 'Phase 1'!G18, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,14,"","","",null,4.5380000000000003]
[null,15,{"$f":"'Phase 1'!W19","v":""},{"$f":"'Phase 1'!X19","v":""},{"$f":"'Phase 1'!Y19","v":""},null,{"$f":"IF(C19<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E19<>\"\", 'Phase 1'!G19, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,15,"","","",null,4.0149999999999997]
[null,16,{"$f":"'Phase 1'!W20","v":""},{"$f":"'Phase 1'!X20","v":""},{"$f":"'Phase 1'!Y20","v":""},null,{"$f":"IF(C20<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E20<>\"\", 'Phase 1'!G20, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,16,"","","",null,2.2000000000000002]
[null,17,{"$f":"'Phase 1'!W21","v":""},{"$f":"'Phase 1'!X21","v":""},{"$f":"'Phase 1'!Y21","v":""},null,{"$f":"IF(C21<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E21<>\"\", 'Phase 1'!G21, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,17,"","","",null,4.673]
[null,18,{"$f":"'Phase 1'!W22","v":""},{"$f":"'Phase 1'!X22","v":""},{"$f":"'Phase 1'!Y22","v":""},null,{"$f":"IF(C22<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E22<>\"\", 'Phase 1'!G22, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,18,"","","",null,13.874000000000001]
[null,19,{"$f":"'Phase 1'!W23","v":""},{"$f":"'Phase 1'!X23","v":""},{"$f":"'Phase 1'!Y23","v":""},null,{"$f":"IF(C23<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E23<>\"\", 'Phase 1'!G23, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,19,"","","",null,0.68100000000000005]
[null,20,{"$f":"'Phase 1'!W24","v":""},{"$f":"'Phase 1'!X24","v":""},{"$f":"'Phase 1'!Y24","v":""},null,{"$f":"IF(C24<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E24<>\"\", 'Phase 1'!G24, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,20,"","","",null,1.823]
[null,21,{"$f":"'Phase 1'!W25","v":""},{"$f":"'Phase 1'!X25","v":""},{"$f":"'Phase 1'!Y25","v":""},null,{"$f":"IF(C25<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E25<>\"\", 'Phase 1'!G25, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,21,"","","",null,3.141]
[null,22,{"$f":"'Phase 1'!W26","v":""},{"$f":"'Phase 1'!X26","v":""},{"$f":"'Phase 1'!Y26","v":""},null,{"$f":"IF(C26<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E26<>\"\", 'Phase 1'!G26, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,22,"","","",null,6.3410000000000002]
[null,23,{"$f":"'Phase 1'!W27","v":"NWT"},{"$f":"'Phase 1'!X27","v":"E00001344"},{"$f":"'Phase 1'!Y27","v":"Peatland restoration"},null,{"$f":"IF(C27<>\"\",'Phase 1'!H27,\"\")","v":"NBS"},{"$f":"IF(E27<>\"\", 'Phase 1'!G27, \"\")","v":"Restoration of 1,500 ha of peatland in the North West to store carbon and deliver wider benefits, by 2030, verified by Natural England (or equivalent). The alternative to peatland restoration in terms of reducing the impact of eroded peat soil (dissolved organic carbon) on drinking water quality is to upgrade the water treatment works. Without an upgrade the water treatment works may have to operate on a reduced throughput to remove the increase in dissolved organic carbon load. This has an impact on the volume of the output of the water treatment works which may have a knock on impact on local and regional supply and demand and would have increased GHG emissions"},null,null,null,null,null,"Peatland- medium","Meets the criteria for insets included in the PC definition. ",null,"Peatland-medium","Meets the criteria for insets included in the PC definition. ",null,"No",null,null,"Pass",null,null,23,"NWT","E00001344","Peatland restoration",null,20.504999999999999]
[null,24,{"$f":"'Phase 1'!W28","v":""},{"$f":"'Phase 1'!X28","v":""},{"$f":"'Phase 1'!Y28","v":""},null,{"$f":"IF(C28<>\"\",'Phase 1'!H28,\"\")","v":""},{"$f":"IF(E28<>\"\", 'Phase 1'!G28, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,24,"","","",null,2.5459999999999998]
[null,25,{"$f":"'Phase 1'!W29","v":""},{"$f":"'Phase 1'!X29","v":""},{"$f":"'Phase 1'!Y29","v":""},null,{"$f":"IF(C29<>\"\",'Phase 1'!H29,\"\")","v":""},{"$f":"IF(E29<>\"\", 'Phase 1'!G29, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,25,"","","",null,1.206]
[null,26,{"$f":"'Phase 1'!W30","v":""},{"$f":"'Phase 1'!X30","v":""},{"$f":"'Phase 1'!Y30","v":""},null,{"$f":"IF(C30<>\"\",'Phase 1'!H30,\"\")","v":""},{"$f":"IF(E30<>\"\", 'Phase 1'!G30, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,26,"","","",null,23.039000000000001]
[null,27,{"$f":"'Phase 1'!W31","v":"WSH"},{"$f":"'Phase 1'!X31","v":"CW21_1"},{"$f":"'Phase 1'!Y31","v":"Net Zero Carbon Strategy:  Network Control Systems (Water)"},null,{"$f":"IF(C31<>\"\",'Phase 1'!H31,\"\")","v":"Process emissions"},{"$f":"IF(E31<>\"\", 'Phase 1'!G31, \"\")","v":"Delivery of a new Network Control System for Water to reduce energy consumption by using factors such as weather and demand patterns to predict optimum set points, and as a result, control and optimise pumping regimes"},null,"NA",null,"Network Control Systems (NOCs) aim to reduce energy consumption by using factors such as weather and demand patterns to predict optimum set points and as a result, control and optimise pumping regimes.",null,"Network Control Systems - Low","Network Control Systems to manage and optimise pumping regimes for wastewater. This is percieved as similar to real time control, it presents limited innovation in optimising assets. There is some learning to be taken from controlling the asset. [Real Time Control - TRL 7 – Deployment]",null,"Real time control - Medium","Real time control: control of the process variables is expected to support reductions in emissions but can be offset by changes in energy demand for aeration to reduce N2O. ",null,"No","Solution is designed to optimise the water treatment stage ",null,"Fail","The scheme uses existing technology to optimise the energy efficiency of the systems. This is part of general maintenance and operation and should be under base expenditure",null,27,"","","",null,1.304]
[null,28,{"$f":"'Phase 1'!W32","v":"WSH"},{"$f":"'Phase 1'!X32","v":"CW21_2"},{"$f":"'Phase 1'!Y32","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},null,{"$f":"IF(C32<>\"\",'Phase 1'!H32,\"\")","v":"NBS"},{"$f":"IF(E32<>\"\", 'Phase 1'!G32, \"\")","v":"Restoration of 2000ha of degraded peatland and creation of new woodland (200,000 trees)."},null,null,null,null,null,"Peatland-medium","Meets the criteria for insets included in the PC definition. ",null,"Peatland-medium","Meets the criteria for insets included in the PC defintion. ",null,"No",null,null,"Pass",null,null,28,"WSH","CW21_2","Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)",null,13.686999999999999]
[null,29,{"$f":"'Phase 1'!W33","v":""},{"$f":"'Phase 1'!X33","v":""},{"$f":"'Phase 1'!Y33","v":""},null,{"$f":"IF(C33<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E33<>\"\", 'Phase 1'!G33, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,29,"","","",null,3.056]
[null,30,{"$f":"'Phase 1'!W34","v":""},{"$f":"'Phase 1'!X34","v":""},{"$f":"'Phase 1'!Y34","v":""},null,{"$f":"IF(C34<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E34<>\"\", 'Phase 1'!G34, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,30,"","","",null,10.795999999999999]
[null,31,null,null,null,null,{"$f":"IF(C35<>\"\", 'Phase 1'!#REF!, \"\")","v":""},{"$f":"IF(E35<>\"\", 'Phase 1'!G35, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fail",null,null,31,{"$f":"IF($W35=\"Pass\",'Phase 1'!AV35,\"\")","v":""},{"$f":"IF($W35=\"Pass\",'Phase 1'!AW35,\"\")","v":""},{"$f":"IF($W35=\"Pass\",'Phase 1'!AX35,\"\")","v":""},null,55.73]
[]
[null,null,null,"Totex (£m)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 2'!D5:D34)*('Final data'!$L$5:$L$34))","v":35.481132507519334},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totex (£m)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 2'!AB5:AB34)*('Final data'!$L$5:$L$34))","v":34.191625545990725}]
[null,null,null,"AMP8 benefits (tCO2e)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 2'!D5:D34)*('Final data'!$R$5:$R$34))","v":-13727},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMP8 benefits (tCO2e)",{"$f":"SUMPRODUCT(('Final data'!$D$5:$D$34='Phase 2'!AB5:AB34)*('Final data'!$R$5:$R$34))","v":-13227}]
[]
[null,"Process description\nSchemes which passed Phase 1 were assessed at Phase 2. References to the scheme including queries issued to the proposing company were catalogued. \n\nThe key aspects of this phase were to: \n- review the technology maturity and contribution to innovation, sector learning and efficiency. \n- assess confidence of the delivery of emissions abatement\n- further review where a scheme is affected or driven by the Industrial Emissions Directive\n\nAdditional expert opinion was sought in the instances where it was difficult to judge the technical merits, cost, commercial opportunities, or level of innovation of a scheme. Three rounds of expert review were provided:\n1. Review of schemes with Richard Chamley, PR24 Engineering Advisor (18/12/23)\n2. Review of schemes with Edoard Piano, PR24 Engineering Advisor (20/12/23)\n3. Review of schemes with Eugenia Vela, Senior Associate, Water Engineer (29/1/24)\n\nOverview of decisions\nDecisions related to technology maturity and contribution to innovation, sector learning and efficiency were driven by the following considerations:\n- technology maturity should be sufficient to give confidence that it can be delivered and offer value for money for customers, however it should not be so mature that it is using existing technology which is commonplace in the sector to the extent it would form part of general maintenance and operation of an asset. \n- innovation and sector learning is demonstrated by alternative or newer technologies which are not yet commonplace in the wastewater sector but offer confidence that they might deliver emissions reductions\n- efficiency was deemed to have been met where the technology proposed offered a step change to a new model of operation. \n\nThe Industrial Emissions Directive (IED) has been important for the assessment of schemes. Where the IED is a driver a scheme is ineligible for Net Zero Enhancement. \n\nWhere Net Zero and emissions abatement are a driver but there are commercial benefits attached to the scheme, the scheme has not passed. This is particularly relevant for schemes which optimise the general operation of an asset or create a revenue stream (e.g. increase collection of biogas and biomethane for reuse). Net Zero as a primary driver for a scheme is expected to show emissions abatement through applying a technology soley for that purpose. \n"]

{"sheet":"Unit cost","index":10,"n_rows":37,"n_cols":30,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,54,4]]}
["Deep-dive: Process emission schemes"]
[]
[null,"Scheme submitted",null,null,null,null,"Deep dive into schemes",null,null,null,null,null,null,"IED overlap",null,null,null,"Carbon benefits ",null,null,null,null,null,null,null,null,null,null,"Stated asset life"]
[null,null,"Company","Scheme ID","Scheme name",null,"Subcategory","Intervention type","Intervention 1","Intervention 2","Intervention 3","Description",null,"Wastewater intervention","Bioresource intervention","Additional information",null,"AMP8 totex (£m)","Carbon benefits (tCO2e)","AMP8 (£000/tCO2e)","AMP8 £/tCO2e","5 years £/tCO2e","10 years £/tCO2e","15 years £/tCO2e","20 years £/tCO2e","25 years £/tCO2e","30 years £/tCO2e",null,"Years","tCo2e"]
[null,1,{"$f":"IF('Phase 1'!$S5=\"Pass\",'Phase 1'!C5,\"\")","v":""},{"$f":"IF('Phase 1'!$S5=\"Pass\",'Phase 1'!D5,\"\")","v":""},{"$f":"IF('Phase 1'!$S5=\"Pass\",'Phase 1'!E5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D5<>\"\",'Final data'!L5,\"\")","v":""},{"$f":"IF($D5<>\"\",'Final data'!R5,\"\")","v":""},{"$f":"IF($D5<>\"\",'Final data'!S5,\"\")","v":""},{"$f":"IFERROR(T5*1000,\"\")","v":""},{"$f":"IFERROR(U5/5,\"\")","v":""},{"$f":"IFERROR(V5/10,\"\")","v":""},{"$f":"IFERROR(W5/15,\"\")","v":""},{"$f":"IFERROR(X5/20,\"\")","v":""},{"$f":"IFERROR(Y5/25,\"\")","v":""},{"$f":"IFERROR(Z5/30,\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGE(V5:AA5),\"\")","v":""}]
[null,2,{"$f":"IF('Phase 1'!$S6=\"Pass\",'Phase 1'!C6,\"\")","v":""},{"$f":"IF('Phase 1'!$S6=\"Pass\",'Phase 1'!D6,\"\")","v":""},{"$f":"IF('Phase 1'!$S6=\"Pass\",'Phase 1'!E6,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D6<>\"\",'Final data'!L6,\"\")","v":""},{"$f":"IF($D6<>\"\",'Final data'!R6,\"\")","v":""},{"$f":"IF($D6<>\"\",'Final data'!S6,\"\")","v":""},"",{"$f":"IFERROR(U6/5,\"\")","v":""},{"$f":"IFERROR(V6/10,\"\")","v":""},{"$f":"IFERROR(W6/15,\"\")","v":""},{"$f":"IFERROR(X6/20,\"\")","v":""},{"$f":"IFERROR(Y6/25,\"\")","v":""},{"$f":"IFERROR(Z6/30,\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGE(V6:AA6),\"\")","v":""}]
[null,3,{"$f":"IF('Phase 1'!$S7=\"Pass\",'Phase 1'!C7,\"\")","v":""},{"$f":"IF('Phase 1'!$S7=\"Pass\",'Phase 1'!D7,\"\")","v":""},{"$f":"IF('Phase 1'!$S7=\"Pass\",'Phase 1'!E7,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D7<>\"\",'Final data'!L7,\"\")","v":""},{"$f":"IF($D7<>\"\",'Final data'!R7,\"\")","v":""},{"$f":"IF($D7<>\"\",'Final data'!S7,\"\")","v":""},"",{"$f":"IFERROR(U7/5,\"\")","v":""},{"$f":"IFERROR(U7/10,\"\")","v":""},{"$f":"IFERROR(U7/15,\"\")","v":""},{"$f":"IFERROR(U7/20,\"\")","v":""},{"$f":"IFERROR(U7/25,\"\")","v":""},{"$f":"IFERROR(U7/30,\"\")","v":""},null,null,""]
[null,4,{"$f":"IF('Phase 1'!$S8=\"Pass\",'Phase 1'!C8,\"\")","v":""},{"$f":"IF('Phase 1'!$S8=\"Pass\",'Phase 1'!D8,\"\")","v":""},{"$f":"IF('Phase 1'!$S8=\"Pass\",'Phase 1'!E8,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D8<>\"\",'Final data'!L8,\"\")","v":""},{"$f":"IF($D8<>\"\",'Final data'!R8,\"\")","v":""},{"$f":"IF($D8<>\"\",'Final data'!S8,\"\")","v":""},"",{"$f":"IFERROR(U8/5,\"\")","v":""},{"$f":"IFERROR(V8/10,\"\")","v":""},{"$f":"IFERROR(W8/15,\"\")","v":""},{"$f":"IFERROR(X8/20,\"\")","v":""},{"$f":"IFERROR(Y8/25,\"\")","v":""},{"$f":"IFERROR(Z8/30,\"\")","v":""},null,null,""]
[null,5]
[null,6]
[null,7,{"$f":"IF('Phase 1'!$S11=\"Pass\",'Phase 1'!C11,\"\")","v":""},{"$f":"IF('Phase 1'!$S11=\"Pass\",'Phase 1'!D11,\"\")","v":""},{"$f":"IF('Phase 1'!$S11=\"Pass\",'Phase 1'!E11,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D11<>\"\",'Final data'!L11,\"\")","v":""},{"$f":"IF($D11<>\"\",'Final data'!R11,\"\")","v":""},{"$f":"IF($D11<>\"\",'Final data'!S11,\"\")","v":""},"",{"$f":"IFERROR(U11/5,\"\")","v":""},{"$f":"IFERROR(V11/10,\"\")","v":""},{"$f":"IFERROR(W11/15,\"\")","v":""},{"$f":"IFERROR(X11/20,\"\")","v":""},{"$f":"IFERROR(Y11/25,\"\")","v":""},{"$f":"IFERROR(Z11/30,\"\")","v":""},null,null,""]
[null,8,{"$f":"IF('Phase 1'!$S12=\"Pass\",'Phase 1'!C12,\"\")","v":""},{"$f":"IF('Phase 1'!$S12=\"Pass\",'Phase 1'!D12,\"\")","v":""},{"$f":"IF('Phase 1'!$S12=\"Pass\",'Phase 1'!E12,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D12<>\"\",'Final data'!L12,\"\")","v":""},{"$f":"IF($D12<>\"\",'Final data'!R12,\"\")","v":""},{"$f":"IF($D12<>\"\",'Final data'!S12,\"\")","v":""},"",{"$f":"IFERROR(U12/5,\"\")","v":""},{"$f":"IFERROR(U12/10,\"\")","v":""},{"$f":"IFERROR(U12/15,\"\")","v":""},{"$f":"IFERROR(U12/20,\"\")","v":""},{"$f":"IFERROR(U12/25,\"\")","v":""},{"$f":"IFERROR(U12/30,\"\")","v":""},null,null,""]
[null,9,{"$f":"IF('Phase 1'!$S13=\"Pass\",'Phase 1'!C13,\"\")","v":""},{"$f":"IF('Phase 1'!$S13=\"Pass\",'Phase 1'!D13,\"\")","v":""},{"$f":"IF('Phase 1'!$S13=\"Pass\",'Phase 1'!E13,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D13<>\"\",'Final data'!L13,\"\")","v":""},{"$f":"IF($D13<>\"\",'Final data'!R13,\"\")","v":""},{"$f":"IF($D13<>\"\",'Final data'!S13,\"\")","v":""},"","","","","","","",null,null,""]
[null,10,{"$f":"IF('Phase 1'!$S14=\"Pass\",'Phase 1'!C14,\"\")","v":""},{"$f":"IF('Phase 1'!$S14=\"Pass\",'Phase 1'!D14,\"\")","v":""},{"$f":"IF('Phase 1'!$S14=\"Pass\",'Phase 1'!E14,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D14<>\"\",'Final data'!L14,\"\")","v":""},{"$f":"IF($D14<>\"\",'Final data'!R14,\"\")","v":""},{"$f":"IF($D14<>\"\",'Final data'!S14,\"\")","v":""},"","","","","","","",null,null,""]
[null,11,{"$f":"IF('Phase 1'!$S15=\"Pass\",'Phase 1'!C15,\"\")","v":""},{"$f":"IF('Phase 1'!$S15=\"Pass\",'Phase 1'!D15,\"\")","v":""},{"$f":"IF('Phase 1'!$S15=\"Pass\",'Phase 1'!E15,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D15<>\"\",'Final data'!L15,\"\")","v":""},{"$f":"IF($D15<>\"\",'Final data'!R15,\"\")","v":""},{"$f":"IF($D15<>\"\",'Final data'!S15,\"\")","v":""},"","","","","","","",null,null,""]
[null,12,{"$f":"IF('Phase 1'!$S16=\"Pass\",'Phase 1'!C16,\"\")","v":""},{"$f":"IF('Phase 1'!$S16=\"Pass\",'Phase 1'!D16,\"\")","v":""},{"$f":"IF('Phase 1'!$S16=\"Pass\",'Phase 1'!E16,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D16<>\"\",'Final data'!L16,\"\")","v":""},{"$f":"IF($D16<>\"\",'Final data'!R16,\"\")","v":""},{"$f":"IF($D16<>\"\",'Final data'!S16,\"\")","v":""},"","","","","","","",null,null,""]
[null,13,{"$f":"IF('Phase 1'!$S17=\"Pass\",'Phase 1'!C17,\"\")","v":""},{"$f":"IF('Phase 1'!$S17=\"Pass\",'Phase 1'!D17,\"\")","v":""},{"$f":"IF('Phase 1'!$S17=\"Pass\",'Phase 1'!E17,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D17<>\"\",'Final data'!L17,\"\")","v":""},{"$f":"IF($D17<>\"\",'Final data'!R17,\"\")","v":""},{"$f":"IF($D17<>\"\",'Final data'!S17,\"\")","v":""},"","","","","","","",null,null,""]
[null,14,{"$f":"IF('Phase 1'!$S18=\"Pass\",'Phase 1'!C18,\"\")","v":""},{"$f":"IF('Phase 1'!$S18=\"Pass\",'Phase 1'!D18,\"\")","v":""},{"$f":"IF('Phase 1'!$S18=\"Pass\",'Phase 1'!E18,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D18<>\"\",'Final data'!L18,\"\")","v":""},{"$f":"IF($D18<>\"\",'Final data'!R18,\"\")","v":""},{"$f":"IF($D18<>\"\",'Final data'!S18,\"\")","v":""},"","","","","","","",null,null,""]
[null,15,{"$f":"IF('Phase 1'!$S19=\"Pass\",'Phase 1'!C19,\"\")","v":""},{"$f":"IF('Phase 1'!$S19=\"Pass\",'Phase 1'!D19,\"\")","v":""},{"$f":"IF('Phase 1'!$S19=\"Pass\",'Phase 1'!E19,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D19<>\"\",'Final data'!L19,\"\")","v":""},{"$f":"IF($D19<>\"\",'Final data'!R19,\"\")","v":""},{"$f":"IF($D19<>\"\",'Final data'!S19,\"\")","v":""},"","","","","","","",null,null,""]
[null,16,{"$f":"IF('Phase 1'!$S20=\"Pass\",'Phase 1'!C20,\"\")","v":""},{"$f":"IF('Phase 1'!$S20=\"Pass\",'Phase 1'!D20,\"\")","v":""},{"$f":"IF('Phase 1'!$S20=\"Pass\",'Phase 1'!E20,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D20<>\"\",'Final data'!L20,\"\")","v":""},{"$f":"IF($D20<>\"\",'Final data'!R20,\"\")","v":""},{"$f":"IF($D20<>\"\",'Final data'!S20,\"\")","v":""},"","","","","","","",null,null,""]
[null,17,{"$f":"IF('Phase 1'!$S21=\"Pass\",'Phase 1'!C21,\"\")","v":""},{"$f":"IF('Phase 1'!$S21=\"Pass\",'Phase 1'!D21,\"\")","v":""},{"$f":"IF('Phase 1'!$S21=\"Pass\",'Phase 1'!E21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D21<>\"\",'Final data'!L21,\"\")","v":""},{"$f":"IF($D21<>\"\",'Final data'!R21,\"\")","v":""},{"$f":"IF($D21<>\"\",'Final data'!S21,\"\")","v":""},"","","","","","","",null,null,""]
[null,18,{"$f":"IF('Phase 1'!$S22=\"Pass\",'Phase 1'!C22,\"\")","v":""},{"$f":"IF('Phase 1'!$S22=\"Pass\",'Phase 1'!D22,\"\")","v":""},{"$f":"IF('Phase 1'!$S22=\"Pass\",'Phase 1'!E22,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D22<>\"\",'Final data'!L22,\"\")","v":""},{"$f":"IF($D22<>\"\",'Final data'!R22,\"\")","v":""},{"$f":"IF($D22<>\"\",'Final data'!S22,\"\")","v":""},"","","","","","","",null,null,""]
[null,19,{"$f":"IF('Phase 1'!$S23=\"Pass\",'Phase 1'!C23,\"\")","v":""},{"$f":"IF('Phase 1'!$S23=\"Pass\",'Phase 1'!D23,\"\")","v":""},{"$f":"IF('Phase 1'!$S23=\"Pass\",'Phase 1'!E23,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D23<>\"\",'Final data'!L23,\"\")","v":""},{"$f":"IF($D23<>\"\",'Final data'!R23,\"\")","v":""},{"$f":"IF($D23<>\"\",'Final data'!S23,\"\")","v":""},"","","","","","","",null,null,""]
[null,20,{"$f":"IF('Phase 1'!$S24=\"Pass\",'Phase 1'!C24,\"\")","v":""},{"$f":"IF('Phase 1'!$S24=\"Pass\",'Phase 1'!D24,\"\")","v":""},{"$f":"IF('Phase 1'!$S24=\"Pass\",'Phase 1'!E24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D24<>\"\",'Final data'!L24,\"\")","v":""},{"$f":"IF($D24<>\"\",'Final data'!R24,\"\")","v":""},{"$f":"IF($D24<>\"\",'Final data'!S24,\"\")","v":""},"","","","","","","",null,null,""]
[null,21,{"$f":"IF('Phase 1'!$S25=\"Pass\",'Phase 1'!C25,\"\")","v":""},{"$f":"IF('Phase 1'!$S25=\"Pass\",'Phase 1'!D25,\"\")","v":""},{"$f":"IF('Phase 1'!$S25=\"Pass\",'Phase 1'!E25,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D25<>\"\",'Final data'!L25,\"\")","v":""},{"$f":"IF($D25<>\"\",'Final data'!R25,\"\")","v":""},{"$f":"IF($D25<>\"\",'Final data'!S25,\"\")","v":""},"","","","","","","",null,null,""]
[null,22,{"$f":"IF('Phase 1'!$S26=\"Pass\",'Phase 1'!C26,\"\")","v":""},{"$f":"IF('Phase 1'!$S26=\"Pass\",'Phase 1'!D26,\"\")","v":""},{"$f":"IF('Phase 1'!$S26=\"Pass\",'Phase 1'!E26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D26<>\"\",'Final data'!L26,\"\")","v":""},{"$f":"IF($D26<>\"\",'Final data'!R26,\"\")","v":""},{"$f":"IF($D26<>\"\",'Final data'!S26,\"\")","v":""},"",{"$f":"IFERROR(U26/5,\"\")","v":""},{"$f":"IFERROR(V26/10,\"\")","v":""},{"$f":"IFERROR(W26/15,\"\")","v":""},{"$f":"IFERROR(X26/20,\"\")","v":""},{"$f":"IFERROR(Y26/25,\"\")","v":""},{"$f":"IFERROR(Z26/30,\"\")","v":""},null,null,""]
[null,23,{"$f":"IF('Phase 1'!$S27=\"Pass\",'Phase 1'!C27,\"\")","v":"NWT"},{"$f":"IF('Phase 1'!$S27=\"Pass\",'Phase 1'!D27,\"\")","v":"E00001344"},{"$f":"IF('Phase 1'!$S27=\"Pass\",'Phase 1'!E27,\"\")","v":"Peatland restoration"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D27<>\"\",'Final data'!L27,\"\")","v":20.504625545990727},{"$f":"IF($D27<>\"\",'Final data'!R27,\"\")","v":-13227},{"$f":"IF($D27<>\"\",'Final data'!S27,\"\")","v":1.5502098394186683},1550.2098394186683,{"$f":"IFERROR(U27/5,\"\")","v":310.04196788373366},{"$f":"IFERROR(U27/10,\"\")","v":155.02098394186683},{"$f":"IFERROR(U27/15,\"\")","v":103.34732262791121},{"$f":"IFERROR(U27/20,\"\")","v":77.510491970933415},{"$f":"IFERROR(U27/25,\"\")","v":62.008393576746727},{"$f":"IFERROR(U27/30,\"\")","v":51.673661313955606},null,null,126.60047021919125]
[null,24,{"$f":"IF('Phase 1'!$S28=\"Pass\",'Phase 1'!C28,\"\")","v":""},{"$f":"IF('Phase 1'!$S28=\"Pass\",'Phase 1'!D28,\"\")","v":""},{"$f":"IF('Phase 1'!$S28=\"Pass\",'Phase 1'!E28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D28<>\"\",'Final data'!L28,\"\")","v":""},{"$f":"IF($D28<>\"\",'Final data'!R28,\"\")","v":""},{"$f":"IF($D28<>\"\",'Final data'!S28,\"\")","v":""},"","","","","","","",null,null,""]
[null,25,{"$f":"IF('Phase 1'!$S29=\"Pass\",'Phase 1'!C29,\"\")","v":""},{"$f":"IF('Phase 1'!$S29=\"Pass\",'Phase 1'!D29,\"\")","v":""},{"$f":"IF('Phase 1'!$S29=\"Pass\",'Phase 1'!E29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D29<>\"\",'Final data'!L29,\"\")","v":""},{"$f":"IF($D29<>\"\",'Final data'!R29,\"\")","v":""},{"$f":"IF($D29<>\"\",'Final data'!S29,\"\")","v":""},"",{"$f":"IFERROR(U29/5,\"\")","v":""},{"$f":"IFERROR(V29/10,\"\")","v":""},{"$f":"IFERROR(W29/15,\"\")","v":""},{"$f":"IFERROR(X29/20,\"\")","v":""},{"$f":"IFERROR(Y29/25,\"\")","v":""},{"$f":"IFERROR(Z29/30,\"\")","v":""},null,null,""]
[null,26,{"$f":"IF('Phase 1'!$S30=\"Pass\",'Phase 1'!C30,\"\")","v":""},{"$f":"IF('Phase 1'!$S30=\"Pass\",'Phase 1'!D30,\"\")","v":""},{"$f":"IF('Phase 1'!$S30=\"Pass\",'Phase 1'!E30,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D30<>\"\",'Final data'!L30,\"\")","v":""},{"$f":"IF($D30<>\"\",'Final data'!R30,\"\")","v":""},{"$f":"IF($D30<>\"\",'Final data'!S30,\"\")","v":""},"",{"$f":"IFERROR(U30/5,\"\")","v":""},{"$f":"IFERROR(V30/10,\"\")","v":""},{"$f":"IFERROR(W30/15,\"\")","v":""},{"$f":"IFERROR(X30/20,\"\")","v":""},{"$f":"IFERROR(Y30/25,\"\")","v":""},{"$f":"IFERROR(Z30/30,\"\")","v":""},null,null,""]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,28,{"$f":"IF('Phase 1'!$S32=\"Pass\",'Phase 1'!C32,\"\")","v":"WSH"},{"$f":"IF('Phase 1'!$S32=\"Pass\",'Phase 1'!D32,\"\")","v":"CW21_2"},{"$f":"IF('Phase 1'!$S32=\"Pass\",'Phase 1'!E32,\"\")","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D32<>\"\",'Final data'!L32,\"\")","v":13.686999999999999},{"$f":"IF($D32<>\"\",'Final data'!R32,\"\")","v":0},{"$f":"IF($D32<>\"\",'Final data'!S32,\"\")","v":"-"},"",{"$f":"IFERROR(U32/5,\"\")","v":""},{"$f":"IFERROR(U32/10,\"\")","v":""},{"$f":"IFERROR(U32/15,\"\")","v":""},{"$f":"IFERROR(U32/20,\"\")","v":""},{"$f":"IFERROR(U32/25,\"\")","v":""},{"$f":"IFERROR(U32/30,\"\")","v":""},null,null,""]
[null,29,{"$f":"IF('Phase 1'!$S33=\"Pass\",'Phase 1'!C33,\"\")","v":""},{"$f":"IF('Phase 1'!$S33=\"Pass\",'Phase 1'!D33,\"\")","v":""},{"$f":"IF('Phase 1'!$S33=\"Pass\",'Phase 1'!E33,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D33<>\"\",'Final data'!L33,\"\")","v":""},{"$f":"IF($D33<>\"\",'Final data'!R33,\"\")","v":""},{"$f":"IF($D33<>\"\",'Final data'!S33,\"\")","v":""},"","","","","","","",null,null,""]
[null,30,{"$f":"IF('Phase 1'!$S34=\"Pass\",'Phase 1'!C34,\"\")","v":""},{"$f":"IF('Phase 1'!$S34=\"Pass\",'Phase 1'!D34,\"\")","v":""},{"$f":"IF('Phase 1'!$S34=\"Pass\",'Phase 1'!E34,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D34<>\"\",'Final data'!L34,\"\")","v":""},{"$f":"IF($D34<>\"\",'Final data'!R34,\"\")","v":""},{"$f":"IF($D34<>\"\",'Final data'!S34,\"\")","v":""},"",{"$f":"IFERROR(U34/5,\"\")","v":""},{"$f":"IFERROR(V34/10,\"\")","v":""},{"$f":"IFERROR(W34/15,\"\")","v":""},{"$f":"IFERROR(X34/20,\"\")","v":""},{"$f":"IFERROR(Y34/25,\"\")","v":""},{"$f":"IFERROR(Z34/30,\"\")","v":""},null,null,""]
[null,31,{"$f":"IF('Phase 1'!$S35=\"Pass\",'Phase 1'!C35,\"\")","v":""},{"$f":"IF('Phase 1'!$S35=\"Pass\",'Phase 1'!D35,\"\")","v":""},{"$f":"IF('Phase 1'!$S35=\"Pass\",'Phase 1'!E35,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D35<>\"\",'Final data'!L35,\"\")","v":""},{"$f":"IF($D35<>\"\",'Final data'!R35,\"\")","v":""},{"$f":"IF($D35<>\"\",'Final data'!S35,\"\")","v":""},"",{"$f":"IFERROR(U35/5,\"\")","v":""},{"$f":"IFERROR(U35/10,\"\")","v":""},{"$f":"IFERROR(U35/15,\"\")","v":""},{"$f":"IFERROR(U35/20,\"\")","v":""},{"$f":"IFERROR(U35/25,\"\")","v":""},{"$f":"IFERROR(U35/30,\"\")","v":""},null,null,""]
[]
[null,"Process description\nThis deep dive was undertaken on wastewater process emissions schemes to fully outline the interventions involved for each proposal. Furthermore, the schemes were assessed against the unit cost of abatement (£/tCO2e abated). \n\nFor the unit cost of abatement, the schemes were assessed using the information available for AMP 8 - the value of the investment in AMP 8 and emissions abated in AMP 8. However, this did not produce unit costs of abatement comparable to government values for unit costs of abatement under the UK Govenments valuation of greenhouse gas emissions, 2021 (https://www.gov.uk/government/publications/valuing-greenhouse-gas-emissions-in-policy-appraisal/valuation-of-greenhouse-gas-emissions-for-policy-appraisal-and-evaluation). \n\nScheme costs were extrapolated across a 20 year period to reflect a more realistic asset life of investments where no further information was provided by companies. Where companies have calculated the unit cost of abatement this has been recorded. \n"]

{"sheet":"Phase 3","index":11,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,43,4]]}
["Phase 3: Unit cost ranking"]
[]
[null,"Schemes passed in phase 2"]
[null,null,"Company","Scheme ID","Scheme name",null,"Unit cost (£000/tCO2e)"]
[null,1,{"$f":"'Phase 2'!AA5","v":""},{"$f":"'Phase 2'!AB5","v":""},{"$f":"'Phase 2'!AC5","v":""},null,{"$f":"IF(C5<>\"\",'Final data'!S5,\"\")","v":""}]
[null,2,{"$f":"'Phase 2'!AA6","v":""},{"$f":"'Phase 2'!AB6","v":""},{"$f":"'Phase 2'!AC6","v":""},null,{"$f":"IF(C6<>\"\",'Final data'!S6,\"\")","v":""}]
[null,3,{"$f":"'Phase 2'!AA7","v":""},{"$f":"'Phase 2'!AB7","v":""},{"$f":"'Phase 2'!AC7","v":""},null,{"$f":"IF(C7<>\"\",'Final data'!S7,\"\")","v":""}]
[null,4,{"$f":"'Phase 2'!AA8","v":""},{"$f":"'Phase 2'!AB8","v":""},{"$f":"'Phase 2'!AC8","v":""},null,{"$f":"IF(C8<>\"\",'Final data'!S8,\"\")","v":""}]
[null,5,{"$f":"'Phase 2'!AA9","v":""},{"$f":"'Phase 2'!AB9","v":""},{"$f":"'Phase 2'!AC9","v":""},null,{"$f":"IF(C9<>\"\",'Final data'!S9,\"\")","v":""}]
[null,6,{"$f":"'Phase 2'!AA10","v":""},{"$f":"'Phase 2'!AB10","v":""},{"$f":"'Phase 2'!AC10","v":""},null,{"$f":"IF(C10<>\"\",'Final data'!S10,\"\")","v":""}]
[null,7,{"$f":"'Phase 2'!AA11","v":""},{"$f":"'Phase 2'!AB11","v":""},{"$f":"'Phase 2'!AC11","v":""},null,{"$f":"IF(C11<>\"\",'Final data'!S11,\"\")","v":""}]
[null,8,{"$f":"'Phase 2'!AA12","v":""},{"$f":"'Phase 2'!AB12","v":""},{"$f":"'Phase 2'!AC12","v":""},null,{"$f":"IF(C12<>\"\",'Final data'!S12,\"\")","v":""}]
[null,9,{"$f":"'Phase 2'!AA13","v":""},{"$f":"'Phase 2'!AB13","v":""},{"$f":"'Phase 2'!AC13","v":""},null,{"$f":"IF(C13<>\"\",'Final data'!S13,\"\")","v":""}]
[null,10,{"$f":"'Phase 2'!AA14","v":""},{"$f":"'Phase 2'!AB14","v":""},{"$f":"'Phase 2'!AC14","v":""},null,{"$f":"IF(C14<>\"\",'Final data'!S14,\"\")","v":""}]
[null,11,{"$f":"'Phase 2'!AA15","v":""},{"$f":"'Phase 2'!AB15","v":""},{"$f":"'Phase 2'!AC15","v":""},null,{"$f":"IF(C15<>\"\",'Final data'!S15,\"\")","v":""}]
[null,12,{"$f":"'Phase 2'!AA16","v":""},{"$f":"'Phase 2'!AB16","v":""},{"$f":"'Phase 2'!AC16","v":""},null,{"$f":"IF(C16<>\"\",'Final data'!S16,\"\")","v":""}]
[null,13,{"$f":"'Phase 2'!AA17","v":""},{"$f":"'Phase 2'!AB17","v":""},{"$f":"'Phase 2'!AC17","v":""},null,{"$f":"IF(C17<>\"\",'Final data'!S17,\"\")","v":""}]
[null,14,{"$f":"'Phase 2'!AA18","v":""},{"$f":"'Phase 2'!AB18","v":""},{"$f":"'Phase 2'!AC18","v":""},null,{"$f":"IF(C18<>\"\",'Final data'!S18,\"\")","v":""}]
[null,15,{"$f":"'Phase 2'!AA19","v":""},{"$f":"'Phase 2'!AB19","v":""},{"$f":"'Phase 2'!AC19","v":""},null,{"$f":"IF(C19<>\"\",'Final data'!S19,\"\")","v":""}]
[null,16,{"$f":"'Phase 2'!AA20","v":""},{"$f":"'Phase 2'!AB20","v":""},{"$f":"'Phase 2'!AC20","v":""},null,{"$f":"IF(C20<>\"\",'Final data'!S20,\"\")","v":""}]
[null,17,{"$f":"'Phase 2'!AA21","v":""},{"$f":"'Phase 2'!AB21","v":""},{"$f":"'Phase 2'!AC21","v":""},null,{"$f":"IF(C21<>\"\",'Final data'!S21,\"\")","v":""}]
[null,18,{"$f":"'Phase 2'!AA22","v":""},{"$f":"'Phase 2'!AB22","v":""},{"$f":"'Phase 2'!AC22","v":""},null,{"$f":"IF(C22<>\"\",'Final data'!S22,\"\")","v":""}]
[null,19,{"$f":"'Phase 2'!AA23","v":""},{"$f":"'Phase 2'!AB23","v":""},{"$f":"'Phase 2'!AC23","v":""},null,{"$f":"IF(C23<>\"\",'Final data'!S23,\"\")","v":""}]
[null,20,{"$f":"'Phase 2'!AA24","v":""},{"$f":"'Phase 2'!AB24","v":""},{"$f":"'Phase 2'!AC24","v":""},null,{"$f":"IF(C24<>\"\",'Final data'!S24,\"\")","v":""}]
[null,21,{"$f":"'Phase 2'!AA25","v":""},{"$f":"'Phase 2'!AB25","v":""},{"$f":"'Phase 2'!AC25","v":""},null,{"$f":"IF(C25<>\"\",'Final data'!S25,\"\")","v":""}]
[null,22,{"$f":"'Phase 2'!AA26","v":""},{"$f":"'Phase 2'!AB26","v":""},{"$f":"'Phase 2'!AC26","v":""},null,{"$f":"IF(C26<>\"\",'Final data'!S26,\"\")","v":""}]
[null,23,{"$f":"'Phase 2'!AA27","v":"NWT"},{"$f":"'Phase 2'!AB27","v":"E00001344"},{"$f":"'Phase 2'!AC27","v":"Peatland restoration"},null,{"$f":"IF(C27<>\"\",'Final data'!S27,\"\")","v":1.5502098394186683}]
[null,24,{"$f":"'Phase 2'!AA28","v":""},{"$f":"'Phase 2'!AB28","v":""},{"$f":"'Phase 2'!AC28","v":""},null,{"$f":"IF(C28<>\"\",'Final data'!S28,\"\")","v":""}]
[null,25,{"$f":"'Phase 2'!AA29","v":""},{"$f":"'Phase 2'!AB29","v":""},{"$f":"'Phase 2'!AC29","v":""},null,{"$f":"IF(C29<>\"\",'Final data'!S29,\"\")","v":""}]
[null,26,{"$f":"'Phase 2'!AA30","v":""},{"$f":"'Phase 2'!AB30","v":""},{"$f":"'Phase 2'!AC30","v":""},null,{"$f":"IF(C30<>\"\",'Final data'!S30,\"\")","v":""}]
[null,27,{"$f":"'Phase 2'!AA31","v":""},{"$f":"'Phase 2'!AB31","v":""},{"$f":"'Phase 2'!AC31","v":""},null,{"$f":"IF(C31<>\"\",'Final data'!S31,\"\")","v":""}]
[null,28,{"$f":"'Phase 2'!AA32","v":"WSH"},{"$f":"'Phase 2'!AB32","v":"CW21_2"},{"$f":"'Phase 2'!AC32","v":"Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)"},null,{"$f":"IF(C32<>\"\",'Final data'!S32,\"\")","v":"-"}]
[null,29,{"$f":"'Phase 2'!AA33","v":""},{"$f":"'Phase 2'!AB33","v":""},{"$f":"'Phase 2'!AC33","v":""},null,{"$f":"IF(C33<>\"\",'Final data'!S33,\"\")","v":""}]
[null,30,{"$f":"'Phase 2'!AA34","v":""},{"$f":"'Phase 2'!AB34","v":""},{"$f":"'Phase 2'!AC34","v":""},null,{"$f":"IF(C34<>\"\",'Final data'!S34,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(C35<>\"\",'Final data'!S35,\"\")","v":""}]
[]
[]
[null,"Process description\nPhase three drew from the deep dive review of process emissions schemes. It identifies where, according to the limited unit cost of abatement benchmarking, schemes showed best value for emissions abatement. "]

{"sheet":"Allowance","index":12,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,15],[36,6,39,7],[40,14,40,15],[40,11,40,12],[40,17,40,19]]}
["Allowance"]
[]
["Summary of allowed costs "]
[]
[null,"Final list of schemes",null,null,null,null,null,"AMP8 totex (£m)",null,null,null,null,null,null,"Cumulated carbon benefits (tCO2e)"]
[null,null,"Company","Scheme ID","Scheme name","Selected or Feasible",null,"2025-26","2026-27","2027-28","2028-29","2029-30","AMP8 totex",null,"2025-26","2026-27","2027-28","2028-29","2029-30","AMP8 benefits"]
[null,18,"NWT","E00001344","Peatland restoration",{"$f":"INDEX('Final data'!$F$5:$F$96, MATCH(C7&D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":"Selected"},null,{"$f":"INDEX('Final data'!G$5:G$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.0175224038604949},{"$f":"INDEX('Final data'!H$5:H$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":5.5422741585021518},{"$f":"INDEX('Final data'!I$5:I$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":5.5009268029786718},{"$f":"INDEX('Final data'!J$5:J$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":5.5872058711786297},{"$f":"INDEX('Final data'!K$5:K$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":1.8566963094707822},{"$f":"INDEX('Final data'!L$5:L$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":20.504625545990727},null,{"$f":"INDEX('Final data'!M$5:M$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!N$5:N$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!O$5:O$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!P$5:P$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!Q$5:Q$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":-13227},{"$f":"INDEX('Final data'!R$5:R$95, MATCH($C7&$D7,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":-13227}]
[null,21,"WSH","CW21_2","Net Zero Carbon Strategy:  Carbon Work Package 6 (Peatland & Woodland Restoration)",{"$f":"INDEX('Final data'!$F$5:$F$96, MATCH(C8&D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":"Selected"},null,{"$f":"INDEX('Final data'!G$5:G$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.7374000000000001},{"$f":"INDEX('Final data'!H$5:H$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.7374000000000001},{"$f":"INDEX('Final data'!I$5:I$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.7374000000000001},{"$f":"INDEX('Final data'!J$5:J$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.7374000000000001},{"$f":"INDEX('Final data'!K$5:K$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":2.7374000000000001},{"$f":"INDEX('Final data'!L$5:L$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":13.686999999999999},"Totex value from outbound query response, as separate value for peatland restoration. ",{"$f":"INDEX('Final data'!M$5:M$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!N$5:N$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!O$5:O$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!P$5:P$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!Q$5:Q$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0},{"$f":"INDEX('Final data'!R$5:R$95, MATCH($C8&$D8,'Final data'!$C$5:$C$96&'Final data'!$D$5:$D$96,0),0)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Allowances per company requested in DD representations",null,"AMP8 totex (£m)",null,null,null,null,null,null,"Cumulated carbon benefits (tCO2e) in DD representations"]
[null,null,"Company","2025-26","2026-27","2027-28","2028-29","2029-30","AMP8 totex",null,"2025-26","2026-27","2027-28","2028-29","2029-30","AMP8 benefits"]
[null,1,"ANH",{"$f":"SUMIF($C$7:$C$17,$C17,H$7:H$17)","v":0},{"$f":"SUMIF($C$7:$C$17,$C17,I$7:I$17)","v":0},{"$f":"SUMIF($C$7:$C$17,$C17,J$7:J$17)","v":0},{"$f":"SUMIF($C$7:$C$17,$C17,K$7:K$17)","v":0},{"$f":"SUMIF($C$7:$C$17,$C17,L$7:L$17)","v":0},{"$f":"SUMIF($C$7:$C$17,$C17,M$7:M$17)","v":0},null,{"$f":"SUMIF($C$7:$C$12,$C17,O$7:O$12)","v":0},{"$f":"SUMIF($C$7:$C$12,$C17,P$7:P$12)","v":0},{"$f":"SUMIF($C$7:$C$12,$C17,Q$7:Q$12)","v":0},{"$f":"SUMIF($C$7:$C$12,$C17,R$7:R$12)","v":0},{"$f":"SUMIF($C$7:$C$12,$C17,S$7:S$12)","v":0},{"$f":"SUMIF($C$7:$C$12,$C17,T$7:T$12)","v":0}]
[null,2,"HDD",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,3,"NES",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,4,"NWT",2.0175224038604949,5.5422741585021518,5.5009268029786718,5.5872058711786297,1.8566963094707822,20.504625545990727,null,0,0,0,0,-13227,-13227]
[null,5,"SRN",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,6,"SVE",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,7,"SWB",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,8,"TMS",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,9,"WSH",2.7374000000000001,2.7374000000000001,2.7374000000000001,2.7374000000000001,2.7374000000000001,13.686999999999999,null,0,0,0,0,0,0]
[null,10,"WSX",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,11,"YKY",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,12,"AFW",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,13,"BRL",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,14,"PRT",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,15,"SEW",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,16,"SSC",0,0,0,0,0,0,null,0,0,0,0,0,0]
[null,17,"SES",0,0,0,0,0,0,null,0,0,0,0,0,0]
[]
[null,null,"Total",{"$f":"SUM(D17:D33)","v":4.7549224038604949},8.2796741585021518,8.2383268029786727,8.3246058711786297,4.5940963094707818,34.191625545990725,null,{"$f":"SUM(K17:K34)","v":0},{"$f":"SUM(L17:L34)","v":0},0,0,-13227,-13227]
[]
[null,null,null,null,null,null,"Pivot Table Note: Select \"scheme name\" in pivot table options to see all schemes"]
[]
[]
[null,"Allowance requested in DD representations"]
[null,null,null,null,null,null,null,null,null,null,null,"Assessed totex (£m) in DD representations- Selected schemes",null,null,"Assessed totex (£m) in DD representations- Feasible schemes",null,null,"Assessed totex (£m) in DD representations- Selected and Feasible schemes"]
[null,"Sum of AMP8 totex (£m, 2025-30)","Column Labels",null,null,null,null,null,null,null,null,"Overall assessed totex","Company",null,"Overall assessed totex","Company",null,"Overall assessed totex","Company","Compared to CWW3"]
[null,null,"Fail",null,null,null,"Fail Total","Pass","Pass Total","Grand Total",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B45, 'Final data'!$F$5:$F$95, \"Selected\")","v":0},"AFW",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B45, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"AFW",null,{"$f":"O43+L43","v":0},"AFW"]
[null,"Row Labels",0,"Feasible","Not defined","Selected",null,"Selected",null,null,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B46, 'Final data'!$F$5:$F$95, \"Selected\")","v":0},"ANH",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B46, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"ANH",null,{"$f":"O44+L44","v":0},"ANH"]
[null,"AFW",null,null,0,null,0,null,null,0,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B47, 'Final data'!$F$5:$F$95, \"Selected\")","v":1.1454142300000001},"HDD",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B47, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"HDD",null,1.1454142300000001,"HDD"]
[null,"ANH",null,null,0,null,0,null,null,0,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B48, 'Final data'!$F$5:$F$95, \"Selected\")","v":12.596026221476},"SEW",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B48, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"SEW",null,12.596026221476,"SEW"]
[null,"HDD",null,null,null,1.1454142300000001,1.1454142300000001,null,null,1.1454142300000001,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B49, 'Final data'!$F$5:$F$95, \"Selected\")","v":7.236770480101276},"SSC",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B49, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"SSC",null,7.236770480101276,"SSC"]
[null,"SEW",null,null,null,12.596026221476,12.596026221476,null,null,12.596026221476,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B50, 'Final data'!$F$5:$F$95, \"Selected\")","v":64.710999999999999},"SVE",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B50, 'Final data'!$F$5:$F$95, \"Feasible\")","v":17.396000000000001},"SVE",null,82.106999999999999,"SVE"]
[null,"SSC",null,null,null,7.236770480101276,7.236770480101276,null,null,7.236770480101276,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B51, 'Final data'!$F$5:$F$95, \"Selected\")","v":0},"TMS",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B51, 'Final data'!$F$5:$F$95, \"Feasible\")","v":16.378},"TMS",null,16.378,"TMS"]
[null,"SVE",null,17.396000000000001,null,64.710999999999999,82.106999999999999,null,null,82.106999999999999,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B52, 'Final data'!$F$5:$F$95, \"Selected\")","v":26.191212619125096},"NWT",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B52, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"NWT",null,26.191212619125096,"NWT"]
[null,"TMS",null,16.378,null,null,16.378,null,null,16.378,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B53, 'Final data'!$F$5:$F$95, \"Selected\")","v":14.976506961528603},"WSH",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B53, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"WSH",null,14.976506961528603,"WSH"]
[null,"NWT",null,null,0,5.6865870731343673,5.6865870731343673,20.504625545990727,20.504625545990727,26.191212619125096,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B54, 'Final data'!$F$5:$F$95, \"Selected\")","v":3.0559338085952183},"WSX",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B54, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"WSX",null,3.0559338085952183,"WSX"]
[null,"WSH",null,null,null,1.2895069615286043,1.2895069615286043,13.686999999999999,13.686999999999999,14.976506961528603,null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B55, 'Final data'!$F$5:$F$95, \"Selected\")","v":0},"YKY",null,{"$f":" SUMIFS('Final data'!$L$5:$L$95, 'Final data'!$C$5:$C$95, B55, 'Final data'!$F$5:$F$95, \"Feasible\")","v":0},"YKY",null,0,"YKY"]
[null,"WSX",null,null,null,3.0559338085952183,3.0559338085952183,null,null,3.0559338085952183]
[null,"YKY",0,null,null,null,0,null,null,0]
[null,"Grand Total",0,33.774000000000001,0,95.721238774835456,129.49523877483546,34.191625545990725,34.191625545990725,163.6868643208262,null,{"$f":"SUM(L43:L53)","v":129.9128643208262},null,null,{"$f":"SUM(O43:O53)","v":33.774000000000001},null,null,{"$f":"SUM(R43:R53)","v":163.6868643208262}]

{"sheet":"F_Outputs","index":13,"n_rows":139,"n_cols":13,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[null,null,"PR24CA44"]
["Acronym","Reference","Item description","Unit","Model","Constant","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","2029-30"]
[]
["ANH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},"Total enhancement allowance - Water - Net zero - Totex","£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A4)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A4)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A4)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A4)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A4)","v":0}]
["ANH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},"Total enhancement allowance - Water - Net zero - Accelerated programme","£m","Price Review 2024"]
["ANH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},"Total enhancement allowance - Water - Net zero - Transition allowance","£m","Price Review 2024"]
["ANH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["ANH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["ANH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["ANH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["ANH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A11)","v":0}]
["HDD",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A12)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A12)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A12)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A12)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A12)","v":0}]
["HDD",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["HDD",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["HDD",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["HDD",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["HDD",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["HDD",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["HDD",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A19)","v":1.1454142300000001}]
["NES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A20)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A20)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A20)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A20)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A20)","v":0}]
["NES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["NES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["NES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["NES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["NES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["NES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["NES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A27)","v":0}]
["NWT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A28)","v":2.0175224038604949},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A28)","v":5.5422741585021518},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A28)","v":5.5009268029786718},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A28)","v":5.5872058711786297},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A28)","v":1.8566963094707822}]
["NWT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["NWT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["NWT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["NWT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["NWT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["NWT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["NWT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A35)","v":26.191212619125096}]
["SRN",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A36)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A36)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A36)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A36)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A36)","v":0}]
["SRN",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SRN",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SRN",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SRN",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SRN",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SRN",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SRN",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A43)","v":0}]
["SVE",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A44)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A44)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A44)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A44)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A44)","v":0}]
["SVE",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SVE",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SVE",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SVE",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SVE",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SVE",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SVE",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A51)","v":82.106999999999999}]
["SWB",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A52)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A52)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A52)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A52)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A52)","v":0}]
["SWB",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SWB",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SWB",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SWB",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SWB",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SWB",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SWB",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A59)","v":0}]
["TMS",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A60)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A60)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A60)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A60)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A60)","v":0}]
["TMS",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["TMS",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["TMS",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["TMS",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["TMS",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["TMS",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["TMS",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A67)","v":16.378}]
["WSH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A68)","v":2.7374000000000001},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A68)","v":2.7374000000000001},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A68)","v":2.7374000000000001},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A68)","v":2.7374000000000001},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A68)","v":2.7374000000000001}]
["WSH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["WSH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["WSH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["WSH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["WSH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["WSH",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["WSH",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A75)","v":14.976506961528603}]
["WSX",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A76)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A76)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A76)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A76)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A76)","v":0}]
["WSX",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["WSX",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["WSX",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["WSX",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["WSX",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["WSX",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["WSX",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A83)","v":3.0559338085952183}]
["YKY",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A84)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A84)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A84)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A84)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A84)","v":0}]
["YKY",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["YKY",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["YKY",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["YKY",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["YKY",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["YKY",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["YKY",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A91)","v":0}]
["AFW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A92)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A92)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A92)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A92)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A92)","v":0}]
["AFW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["AFW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["AFW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["AFW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["AFW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["AFW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["AFW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A99)","v":0}]
["BRL",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A100)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A100)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A100)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A100)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A100)","v":0}]
["BRL",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["BRL",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["BRL",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["BRL",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["BRL",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["BRL",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["BRL",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A107)","v":0}]
["PRT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$S$17:$S$33, $A108)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$S$17:$S$33, $A108)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$S$17:$S$33, $A108)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$S$17:$S$33, $A108)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$S$17:$S$33, $A108)","v":0}]
["PRT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["PRT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["PRT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["PRT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["PRT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["PRT",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["PRT",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A115)","v":0}]
["SEW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A116)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A116)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A116)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A116)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A116)","v":0}]
["SEW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SEW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SEW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SEW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SEW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SEW",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SEW",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A123)","v":12.596026221476}]
["SSC",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A124)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A124)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A124)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A124)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A124)","v":0}]
["SSC",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SSC",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SSC",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SSC",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SSC",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SSC",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SSC",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A131)","v":7.236770480101276}]
["SES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TOT\")","v":"C_PR24CA44_ENH_W_TOT"},{"$f":" $C$4","v":"Total enhancement allowance - Water - Net zero - Totex"},"£m","Price Review 2024",null,null,null,{"$f":" SUMIFS(Allowance!D$17:D$33, Allowance!$C$17:$C$33, $A132)","v":0},{"$f":" SUMIFS(Allowance!E$17:E$33, Allowance!$C$17:$C$33, $A132)","v":0},{"$f":" SUMIFS(Allowance!F$17:F$33, Allowance!$C$17:$C$33, $A132)","v":0},{"$f":" SUMIFS(Allowance!G$17:G$33, Allowance!$C$17:$C$33, $A132)","v":0},{"$f":" SUMIFS(Allowance!H$17:H$33, Allowance!$C$17:$C$33, $A132)","v":0}]
["SES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_AP\")","v":"C_PR24CA44_ENH_W_AP"},{"$f":" $C$5","v":"Total enhancement allowance - Water - Net zero - Accelerated programme"},"£m","Price Review 2024"]
["SES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_TE\")","v":"C_PR24CA44_ENH_W_TE"},{"$f":" $C$6","v":"Total enhancement allowance - Water - Net zero - Transition allowance"},"£m","Price Review 2024"]
["SES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT1\")","v":"PR24QA_PR24CA44_OUT1"},{"$f":" CONCATENATE(\"Date & Time for Model - \", $C$1)","v":"Date & Time for Model - PR24CA44"},"Text","Price Review 2024",{"$f":"CONCATENATE(\"[…]\", TEXT(NOW(),\"dd/mm/yyy hh:mm:ss\"))","v":"[…]16/12/2024 16:45:37"},"[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37","[…]16/12/2024 16:45:37"]
["SES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT2\")","v":"PR24QA_PR24CA44_OUT2"},{"$f":" CONCATENATE(\"Name of Model - \", $C$1)","v":"Name of Model - PR24CA44"},"Text","Price Review 2024",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1,SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["SES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT3\")","v":"PR24QA_PR24CA44_OUT3"},{"$f":" CONCATENATE(\"F_Inputs time stamp - \", $C$1)","v":"F_Inputs time stamp - PR24CA44"},"Text","Price Review 2024","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["SES",{"$f":" CONCATENATE(\"PR24QA_\",  $C$1, \"_OUT4\")","v":"PR24QA_PR24CA44_OUT4"},{"$f":" CONCATENATE(\"Model override switch for - \", $C$1)","v":"Model override switch for - PR24CA44"},"nr","Price Review 2024",0,0,0,0,0,0,0,0]
["SES",{"$f":"CONCATENATE(\"C_\", $C$1, \"_ENH_W_ASSESSED\")","v":"C_PR24CA44_ENH_W_ASSESSED"},{"$f":"CONCATENATE(\"Total amount assessed - \", MID($C$4,31,200))","v":"Total amount assessed - Water - Net zero - Totex"},"£m","Price Review 2024",{"$f":" SUMIFS(Allowance!$R$43:$R$53, Allowance!$S$43:$S$53, A139)","v":0}]