{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["_com.sap.ip.bi.xl.hiddensheet","MOD Timetable","K Model flowchart","Colour Coding","Pricing Notice Tables","BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":76,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"_com.sap.ip.bi.xl.hiddensheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"MOD Timetable","index":1,"n_rows":81,"n_cols":5,"rows_kept":81,"cut":false,"hidden":true,"merged":[[65,1,69,1],[71,1,80,1],[5,1,9,1],[11,1,20,1],[24,1,31,1],[35,1,39,1],[41,1,50,1],[54,1,61,1]]}
[]
[null,"HIGH LEVEL TIMETABLE - WHAT WILL BE INCLUDED IN \"MOD\""]
[]
[null,"MAR 13",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2013"]
[]
[null,"NOV 13",null,"(1) Legacy Price Control Adjustments (True up for 12/13 forecast vs. actuals)"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/13 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 14/15"]
[]
[null,"NOV 14",null,"(1) Totex Actuals for 13/14 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/14 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2013 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 15/16 onwards (13 years left)"]
[null,null,null,null,"- Deficit true up for year 13/14 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated year 13/14"]
[]
[null,null,null,"K model process generates prices for 15/16"]
[]
[null,"MAY 15",null,"First reopener window : 1st May to 31st May"]
[]
[null,"NOV 15",null,"(1) Totex Actuals for 14/15 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/15 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Ofgem view of reopener costs put through MOD process, costs entered against relevant year and"]
[null,null,null,"time value of money adjustment applied."]
[]
[null,null,null,"K model process generates prices for 16/17"]
[]
[null,"MAR 16",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2016"]
[]
[null,"NOV 16",null,"(1) Totex Actuals for 15/16 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/16 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 17/18"]
[]
[null,"NOV 17",null,"(1) Totex Actuals for 16/17 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/17 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2016 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 18/19 onwards (10 years left)"]
[null,null,null,null,"- Deficit true up for year 14/15, 15/16, 16/17 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated for years 14/15, 15/16, 16/17 "]
[]
[null,null,null,"K model process generates prices for 18/19"]
[]
[null,"MAY 18",null,"Second reopener window :1st May to 31st May"]
[]
[null,"NOV 18",null,"(1) Totex Actuals for 17/18 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/18 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Ofgem view of reopener costs put through MOD process, costs entered against relevant year and"]
[null,null,null,"time value of money adjustment applied."]
[]
[null,null,null,"K model process generates prices for 19/20"]
[]
[null,"MAR 19",null,"Actuarial defined benefit pension scheme valuation as at 31/3/2019"]
[]
[null,"NOV 19",null,"(1) Totex Actuals for 18/19 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/19 - this becomes the basis for all future years"]
[]
[null,null,null,"K model process generates prices for 20/21"]
[]
[null,"NOV 20",null,"(1) Totex Actuals for 19/20 input into model : TIM calculated"]
[]
[null,null,null,"(2) IBOXX 10 year index updated to 31/10/20 - this becomes the basis for all future years"]
[]
[null,null,null,"(3) Pension Scheme 31/3/2019 valuation impact on process :"]
[null,null,null,null,"- New deficit numbers updated for years 21/22 onwards (7 years left)"]
[null,null,null,null,"- Deficit true up for year 17/18, 18/19, 19/20 calculated"]
[null,null,null,null,"- PPF Levy / Admin costs above threshold calculated for years 17/18, 18/19, 19/20 "]
[]
[null,null,null,"K model process generates prices for 21/22"]

{"sheet":"K Model flowchart","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
["K Model Flowchart"]
[]
[]
[]
[]
[]
[]
[" "]
[null,null,null,null,null,null,null,null,null,null,null,null,"I"]
[]
[]
[]
[]
[]
[]
[]
[null,"BR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"PT"]
[]
[null,"BM"]
[]
[]
[null,"Ex"]
[]
[null,"SHR"]
[]
[null,"EEI"]
[]
[]
[null,"DRS"]
[]
[null,null,null,null,null,"RPI"]
[]
[null,"NIA"]
[]
[]
[]
[null,"K"]

{"sheet":"Colour Coding","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["The following colours are used throughout the K Model to identify the different types of data held within the model:"]
[]
[null,null,null,"Data hard coded from the Licence"]
[]
[null,null,null,"Data hard coded from a data source"]
[]
[null,null,null,"Data transferred from other worksheets within the K Model"]
[]
[null,null,null,"Data linking to other data files"]
[]
[null,null,null,"Calculation cells"]
[]
[null,null,null,"Manually keyed in data"]
[]
[null,null,null,"Macro driven calculation cells"]
[]
["The tabs in the K Model are coloured to reflect the type of calculation within the tab:",null,null,null,null," "]
[]
[null,null,null,"Tabs which calculate Allowed Revenue, per the the Allowed Revenue Formula",null,null,null,null,null,null," "]
[]
[null,null,null,"Tabs which calculate Actual and Forecast Collected Revenue"]
[]
[null,null,null,"Summary and Other Tabs"]
[]
[null,null,null,"Output tabs for Xoserve Pricing templates, Pricing Statements, and Financial Reporting requirements"]
[]
[null,null,null,"Overall summary tab for internal review purposes to show the building blocks"]
[]
[null,null,null,null,null," "]

{"sheet":"Pricing Notice Tables","index":4,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":true,"merged":[[1,1,1,2],[2,1,2,2],[13,1,13,2],[29,1,29,2],[45,1,45,2]]}
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,"60 day notice Pricing Notice Table"]
[]
[null,"DIRECTLY CONNECTED SUPPLY POINTS",null,null,null,null,null,null,"Notes",null,"19/20","20/21","Var","Var %"]
[]
[null,"Charge Type","LDZ CAPACITY","LDZ COMMODITY",null,null,null,null,1,"PRICE CONTROL REVENUE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L5-K5","v":{"$error":"#REF!"}},{"$f":"L5/K5-1","v":{"$error":"#REF!"}}]
[null,"Charge Code","ZCA","ZCO"]
[null,"Unit Rate","pence per peak day kWh per day","pence per kWh",null,null,null,null,null,"Adjustments to Base Revenue"]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},null,null,null,null,2,"Cost of Debt",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L8-K8","v":{"$error":"#REF!"}}]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},null,null,null,null,3,"RPI true ups",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,4,"Tax trigger events",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"FGO Allowance impact",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Minimum reached at SOQ of ",{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},null,null,null,null,null,"Repex Tier 2a workload",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,"Pension Deficit True Ups",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L13-K13","v":{"$error":"#REF!"}}]
[null,"CONNECTED SYSTEM EXIT POINTS",null,null,null,null,null,null,null,"Legacy GDPCR1 Adjustments",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Subject to a minimum rate of ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},null,null,null,null,5,"Totex incentive mechanism",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L15-K15","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Tax clawback adjustments",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L16-K16","v":{"$error":"#REF!"}}]
[null,"Charge Type","LDZ CAPACITY","LDZ COMMODITY",null,null,null,null,null,"Shrinkage allowance changes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Charge Code",891,893,null,null,null,null,null,"Exit allowance changes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Unit Rate","pence per peak day kWh per day","pence per kWh",null,null,null,null,null,"Fuel poor allowance changes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"73,200 to 732,000 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,"ADJUSTED BASE REVENUES",{"$f":"SUM(K5:K20)","v":{"$error":"#REF!"}},{"$f":"SUM(L5:L20)","v":{"$error":"#REF!"}},{"$f":"L21-K21","v":{"$error":"#REF!"}},{"$f":"L21/K21-1","v":{"$error":"#REF!"}}]
[null,"Subject to a minimum rate of ",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"Minimum reached at SOQ of ",{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},{"$f":"ROUND((#REF!/#REF!)^(1/#REF!),0)","v":{"$error":"#REF!"}},null,null,null,null,6,"Non Controllable Cost True Ups",{"$f":"#REF!-K24","v":{"$error":"#REF!"}},{"$f":"#REF!-L24","v":{"$error":"#REF!"}},{"$f":"L23-K23","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,7,"Supplier of Last Resort Claims",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L24-K24","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Network Innovation Allowance",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L25-K25","v":{"$error":"#REF!"}}]
[null,"CSEP administration charge "]
[null,"Charge per supply point ",{"$f":"#REF!&\" pence per day\"","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Incentives"]
[null,null,null,null,null,null,null,null,8,"Discretionary Reward Scheme",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L28-K28","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"NTS Exit Capacity",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L29-K29","v":{"$error":"#REF!"}}]
[null,"CUSTOMER CHARGES",null,null,null,null,null,null,null,"Stakeholder Engagement",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"L30-K30","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Customer Satisfaction",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null," ",null,null,null,null,null,null,"Shrinkage",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Charge Type","LDZ CAPACITY",null,null,null,null,null,null,"Environmental Emissions",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Charge Code","CCA",null,null,null,null,null,null,"Total Incentives",{"$f":"SUM(K28:K33)","v":{"$error":"#REF!"}},{"$f":"SUM(L28:L33)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Unit Rate","pence per peak day kWh per day"]
[null,"Up to 73,200 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},null,null,null,null,null,9,"Under/(Over) Collections \"K\"",{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"-#REF!","v":{"$error":"#REF!"}},{"$f":"L36-K36","v":{"$error":"#REF!"}}]
[null,"73,200 to 732,000 kWh per annum ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[null,"732,000 kWh per annum and above ",{"$f":"TEXT(#REF!,\"0.0000\")&\" x SOQ ^ \"&#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,"TOTAL ALLOWED REVENUE",{"$f":"K21+K23+K24+K25+K34+K36","v":{"$error":"#REF!"}},{"$f":"L21+L23+L24+L25+L34+L36","v":{"$error":"#REF!"}},{"$f":"L38-K38","v":{"$error":"#REF!"}},{"$f":"L38/K38-1","v":{"$error":"#REF!"}}]
[]
[null,"Charge Type","LDZ CAPACITY",null,null,null,null,null,null,"AQ/SOQ Change Impact - impact from 19/20 over collection",null,null,null,{"$f":"N43-N41-N38","v":{"$error":"#REF!"}}]
[null,"Charge Code","CFI",null,null,null,null,null,10,"AQ/SOQ Change Impact - forecast during 20/21",null,null,null,{"$f":"-#REF!","v":{"$error":"#REF!"}}]
[null,"Unit Rate","Fixed charge - pence per day"]
[null,"Non-monthly read supply points ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"OVERALL PRICE CHANGE",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Monthly read supply points ",{"$f":"TEXT(#REF!,\"0.0000\")","v":{"$error":"#REF!"}}]
[]
[null,"EXIT CAPACITY CHARGES"]
[null,null,null,null,null,null,null,null,null,"Check",{"$f":"K38-#REF!","v":{"$error":"#REF!"}},{"$f":"L38-#REF!","v":{"$error":"#REF!"}}]
[null,"Charge Type","LDZ EXIT CAPACITY"]
[null,"Charge Code - directly connected supply points/cseps","ECN/C04"]
[null,"Unit Rate","pence per peak day kWh per day"]
[null,"NE1",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NE2",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NE3",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NO1",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"NO2",{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"BBPTACShadowWks0001","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Mod186 Statement","index":6,"n_rows":164,"n_cols":23,"rows_kept":164,"cut":false,"hidden":false,"merged":[[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[27,21,27,22],[31,21,31,22],[34,21,34,22],[6,21,8,22],[14,21,14,22],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,21,18,22],[20,21,20,22],[21,21,21,22],[22,21,22,22],[26,21,26,22],[112,21,116,22],[1,3,1,22],[5,21,5,22],[151,3,151,4],[37,21,37,22],[38,21,38,22],[35,21,35,22],[30,21,30,22],[130,3,130,4],[36,21,36,22],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[93,21,93,22],[108,3,108,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,null,"Published:","2020-03-12T14:46:43.030","RIIO-GD2"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD2 data reflects our December 2019 business plan bid submission per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020."]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.4033061789047276,1.4303198228486436,1.4589262193056165,1.488104743691729,1.5178668385655634]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,null,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,null,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5249999999999995E-2,2.3749999999999938E-2,1.8250000000000099E-2,1.9249999999999989E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,null,"As per Feb 2020 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-6.5000000000000058E-3,"","","","","","",null,"Difference between forecast and actual drives true up in 2 years time"]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,"GD2 yrs as per bus.plan submission, discounted to 09/10 prices to be comparable with GD1 yrs"]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,"Actual Modt up to 20/21, forecast thereafter"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-3.0780648310690926,-0.40370206289036942,0,0,0,null,"Latest RPI inflation impact on the true up mechanism"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,122.67022311608036,130.93769631583427,141.11749719781523,150.7842281417702,161.25708276157582,null,"Assumed CPI for GD2 years"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,426.83174984800422,435.2176512782832,448.61245229394086,459.70199649068957,472.64424014018101]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.9464125338570284,4.6576007402913104,0,0,0]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.34606951621597665,0.35323091051740918,0,0,0]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0276696227323061,2.0696292320044525,0,1.4144653030025335E-15,0]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0.89660300000000004,0,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,8.2741136946406986,7.3201516728053111,7.0804608828131723,0,1.4144653030025335E-15,0]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1261945536294298,0.26615176789610334,0,0,0,null,"Data uses finalised July 2019 Gemini bookings applied with NTS incentive rates"]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3983565065284864,-4.9445658481987946,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.49270633043903339,0.48338650374832015,0,0,0,null,"13/14 - 18/19 actual volume impact with forecast thereafter"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.1703529938420498,-9.3264642767889558,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266,null,"Actuals and forecast compared against original allowance with actual/forecast gas prices"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.6776466634030172,-8.8430777730406351,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9650900231403003,3.2027433705714721,3.2352869631510339,0,0,0,null,"Assumes customer service scores and stakeholder results will continue at GD1 average rate"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.2733541247035971,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.2906299571047617,4.4617566271380635,0,0,0,null,"13/14 - 18/19 actual volume impact with forecast thereafter"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,0,0,0,0,0,null,"DRS from 11/12, 12/13,14/15/17/18"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7239369753869207,0,0,0,0,0,null,"Actual spend 13/14 - 18/19, assumed will spend maximum allowance thereafter"]
[null,25,null,"Less Correction Term revenue Adjustment (K added)","-Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.52013551170712968,-12.988199313084364,5.7773836446089057E-2,-1.1936133540468441E-13,4.1995985286290716E-13,-5.4206496176626622E-4]
[null,26,null,"GD2 Incentive Assumption",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,"NGN's assumed level of GD2 incentives (collected 2 years after)"]
[null,27,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.37923287870495,439.86214631042196,413.58107236547005,436.2652859665917,446.39562074654998,457.82045160604048,470.91415091315719]
[null,29,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.4477908756043121,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.421083399983956,-5.519485674687985E-2,0,0,5.1123529743790641E-4,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,4.5418267800534373E-4,6.733046752344829E-2,6.7722542581665213E-3,null,null,null,null,null,null,"Movement year on year in row reference 26"]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,null,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.842625412708738E-2,null,null,null,null,null,null,"Movement year on year in row reference 28"]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,null,null,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.8999999999999996E-2,null,null,null,null,null,null,"Latest view on how much load factors could move capacity levels"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other underlying growth",null,null,null,null,null,null,null,null,-1.0769815857443812E-3,-3.6130774076232521E-3,3.9516399388378129E-3]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1353936809144277E-2,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933595467905417E-2,1.297640069916948E-3]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,"2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22"]
[null,null,null,"Allowed Revenues £m","Nom Prices",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114,1345753,1348708]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041,1160912,1162830]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,2506665,2511538,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018","bopri 26/04/2019"]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267,19059743380,19384528503]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741,15841637342,15989045667]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,34901380722,35373574170,0,0,0,0,0,0,0]
[]
[null,null,null,"Average AQ","NE",null,null,15078.02270927113,14890.239844223981,14300.054833420678,14173.317543880596,14162.883813002833,14372.665175115741,"","","","","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,13645.855449853219,13750.114519749233,"","","","","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998,0.33900000000000002,0.34]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997,0.34300000000000003,0.34499999999999997]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,0.34085252038066521,0.34231497592311966,"","","","","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,114,116,"","","","","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,109,109,"","","","","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,112,113,"","","","","","",""]
[]
[null,null,null,"Unit Rates","Commodity",null,null,2.7799999999999998E-2,2.92E-2,3.1199999999999999E-2,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.3500000000000002E-2,3.04E-2,3.2599999999999997E-2,3.3500000000000002E-2,3.5200000000000002E-2,3.6999999999999998E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21129999999999999,0.21249999999999999,0.193,0.20680000000000001,0.21279999999999999,0.22359999999999999,0.2351]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1128,0.1134,0.10299999999999999,0.1103,0.1135,0.1193,0.12540000000000001]
[]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,4.3580343468257627,4.3520880108244429,"","","","","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,81.228559999999987,80.922690000000003,"","","","","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,43.373680000000007,43.183515,"","","","","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,128.45829301082443,0,0,0,0,0,0,0]
[]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.4080416156043,411.27572761540608,409.2076390972685,409.39349411865396,436.95814947872105,439.91734116716884,413.58107236546994,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",121.13327029305293,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.03597644816622,129.77225906344407,136.89004525046278,140.06855165015364,143.65356207080237,147.76206473719242]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (18/19 Prices)","18/19 prices",140.25979326838052,null,141.70831099797692,144.87369155996313,146.75383602671721,138.7659011533307,132.90073803295147,128.45829301082443,133.73074853597399,131.51297403388969,121.42378133072076,125.66462380188484,122.32358205810935,122.99452507493467,124.03154679544025]
[null,37,null,"% movement in domestic customer bill - (18/19 prices)",null,null,null,null,2.2337296519125083E-2,1.2977818446600953E-2,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,4.1044103899973816E-2,-1.658387862450128E-2,-7.6716329908021352E-2,3.4925962811299227E-2,-2.6586971278748872E-2,5.4849850334384165E-3,8.4314461954608788E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,32.481441185153081,33.151881862441371,33.250648594981207,33.151982045784486,33.151982109629245]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4971588894097829E-2,-5.397472889564308E-2,-7.7947091887781898E-4,5.1123529754040168E-4,-3.7496415434188139E-15,0]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005276060824272,24.90291539609952,27.940384775427596,33.294095773116119,33.183289335737058,33.173514724540219]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9471223517555991,3.4012722820179775,24.902428465184141,27.940384775427599,33.294095773116119,33.183289335737058,33.173514724540183]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.161797974788751E-2,7.4467593555027634E-4,-4.8693091537899136E-4,0,0,0,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930837526498346,6.3232504719433482,0.12197244101804361,0.19161192806467331,-3.3281107297268298E-3,-2.9456426389629087E-4]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5376418422223997E-3,-2.1898835175409123E-4,1.9553169082173332E-5,0,0,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7897071302195043E-3,0.12889091957692653,3.9002298576258226E-3,1.9963961898306799E-3,4.1265772461371066E-3,1.4021517497151866E-3]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,6.4709224031685206,0.14489222404475161,0.21260832425450399,1.9798466516410276E-2,2.0107587485818895E-2]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,380.29677084437623,null,384.44668689922634,401.47893814541436,414.87150072575594,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,436.51681356108639,388.67815696937038,408.32490119116449,413.10101373813643,424.63716227030335,437.74063618861697]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.73341855999996,441.43211052694937,436.46087402840396,388.67864390028592,408.32490119116409,413.10152497343387,424.63716227030341,437.74063618861703]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,3.013229155623776,null,3.0412093007736303,-2.5957629654143375,-6.461906585755969,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.369465420236111,-5.5939532682430126E-2,4.8693091554241619E-4,0,5.1123529743790641E-4,0,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6515900416947327E-2,1.7373147113562304E-2,-0.10959178456712859,5.0547590260757502E-2,1.1696843697357462E-2,2.7925732807520198E-2,3.0858047958535861E-2]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.8829042941176268E-2,1.2814977784263954E-4,-1.2527869313242332E-6,0,-1.237555175214305E-6,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,-1.8445896877580664E-3,-1.4600548737914894E-3,1.7924281553768177E-3,-1.7501547461512487E-3,3.9838297738948383E-3,1.3707662900694327E-3]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-9.1923689663077443E-2,7.1338765629202994E-2,2.8946688951206213E-2,5.090832502623982E-2,5.1228814248605294E-2]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"as per Nov19 AIP"]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22",null,"Assumptions","Frequency"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,"GD2 years as per business plan submission (CPI based methodology)"]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17]
[]
[null,60,null,"Cost of Debt Adjustment (*)","CDE £ impact",null,null,null,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.517784630239372,0,0,0,0,0]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973,0,0,0,0,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE"]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE"]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,0,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,null,17.398062412967949]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR"]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,0,0,0,0,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0]
[null,null,null,"Check that it adds down and matches the summary sheet",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Mod186 Statement movement","index":7,"n_rows":163,"n_cols":44,"rows_kept":163,"cut":false,"hidden":false,"merged":[[1,43,1,51],[45,3,45,4],[46,3,46,4],[7,3,7,4],[1,3,1,4],[3,43,5,51],[15,43,15,51],[1,10,1,19],[1,21,1,30],[1,32,1,41],[30,43,32,51],[148,3,148,4],[150,3,150,4],[151,3,151,4],[153,3,153,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[115,3,115,4],[116,3,116,4],[118,3,118,4],[130,3,130,4],[135,3,135,4],[136,3,136,4],[108,3,108,4],[109,3,109,4],[95,3,95,4],[97,3,97,4],[98,3,98,4],[89,3,89,4],[114,3,114,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[110,3,110,4],[112,3,112,4],[113,3,113,4]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,null,null,null,null,"DECEMBER MOD186",null,null,null,null,null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,"GD2 data reflects our December 2019 business plan Bid submission as per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.4033061789047276,1.4303198228486436,1.4589262193056165,1.488104743691729,1.5178668385655634,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3872501228224969,1.4153419378096526,1.445064118503655,1.4754104649922319,1.5063940847570685,1.5380283605369665,null,0,0,0,0,-7.4127053526875653E-3,-1.203575890492492E-2,-1.4744295655011452E-2,-1.648424568661544E-2,-1.8289341065339526E-2,-2.0161521971403085E-2]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,0,0,0,0,0,0,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,null,null,null,null,null,null,null,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5249999999999995E-2,2.3749999999999938E-2,1.8250000000000099E-2,1.9249999999999989E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2,null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,0,0,0,-2.0000000000000018E-3,-4.750000000000032E-3,-2.0000000000000018E-3,-1.7499999999999183E-3,-9.9999999999988987E-4,-9.9999999999988987E-4,-9.9999999999988987E-4]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-6.5000000000000058E-3,"","","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-4.500000000000004E-3,"","","","","","",null,0,0,0,-2.0000000000000018E-3,"","","","","",""]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,0,0,0,0,0,0,0,0,0,0]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-3.0780648310690926,-0.40370206289036942,0,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-2.4291824635517685,-5.3088989111343195E-14,0,0,0,null,0,0,0,0,0,-0.64888236751732409,-0.40370206289031635,0,0,0,null,"Impact of lower forecast inflation in 19/20 & 20/21 with a 2 year lag"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,122.67022311608036,130.93769631583427,141.11749719781523,150.7842281417702,161.25708276157582,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,121.34451550712765,126.60054597991484,135.60376323645255,146.18631958501459,156.4341305682471,167.53512177667733,null,0,0,0,0,-2.3227652790990874,-3.9303228638344763,-4.6660669206182774,-5.0688223871993614,-5.6499024264768991,-6.2780390151015126,null,"Impact of Feb 2020 inflation forecast vs. Dec 2019"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,426.83174984800422,435.2176512782832,448.61245229394086,459.70199649068957,472.64424014018101,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,434.69371375321344,431.41095507935597,440.28742026179179,453.68127468114022,465.35189891716647,478.92227915528252,null,0,0,0,0,-2.3227652790990874,-4.5792052313517502,-5.0697689835085953,-5.0688223871993614,-5.6499024264768991,-6.2780390151015126]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.9464125338570284,4.6576007402913104,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0583476927345217,4.9058935428152459,4.5152464233169312,0,0,0,null,0,0,0,0,-2.7029041411362975E-2,4.0518991041782471E-2,0.14235431697437928,0,0,0,null,"Movement due to include actual amount for 20/21 (values known in advance)"]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.34606951621597665,0.35323091051740918,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34389096601832431,0.35010962778984267,0.35796818576983019,0,0,0,null,0,0,0,0,-1.8375650955851919E-3,-4.0401115738660232E-3,-4.7372752524210138E-3,0,0,0]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0276696227323061,2.0696292320044525,0,1.4144653030025335E-15,0,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0149051928984458,2.0513412006289995,2.0973855892499156,0,0,1.4609941867111868E-15,null,0,0,0,0,-1.0766550503645167E-2,-2.3671577896693385E-2,-2.7756357245463104E-2,0,1.4144653030025335E-15,-1.4609941867111868E-15]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0.89660300000000004,0,0,0,0,0,null,-0.15071466,0,0.78779600000000005,0.736896,0.234705,0,0,0,0,0,null,0,0,0,0,0.6618980000000001,0,0,0,0,0,null,"OVO Energy (£643k) and Shell Energy (£18k) SOLR claims now included"]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,8.2741136946406986,7.3201516728053111,7.0804608828131723,0,1.4144653030025335E-15,0,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.651848851651291,7.3073443712340884,6.970600198336677,0,0,1.4609941867111868E-15,null,0,0,0,0,0.62226484298940754,1.2807301571222673E-2,0.10986068447649533,0,1.4144653030025335E-15,-1.4609941867111868E-15]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1261945536294298,0.26615176789610334,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9863531535937091,1.1365941270394262,0.2677790543281206,0,0,0,null,0,0,0,0,-1.0613984033401191E-2,-1.0399573409996421E-2,-1.6272864320172609E-3,0,0,0]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,0,0,0,0,4.6338493295726479E-2,9.8845608484292136E-2,0.11302467087720736,5.4129415489696811E-2,2.419466215143691E-2,-4.8414412470581536E-3]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3983565065284864,-4.9445658481987946,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.685660295935719,-6.486802541602783,-5.0559632326439843,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,0,0,0,0,3.5724509262324844E-2,8.8446035074296603E-2,0.11139738444518965,5.4129415489696811E-2,2.419466215143691E-2,-4.8414412470581536E-3]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.49270633043903339,0.48338650374832015,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.70917233907219934,0.88588374601115449,0,0,0,null,0,0,0,0,0,-0.21646600863316595,-0.40249724226283434,0,0,0,null,"Incentive forecasts are aligned to RRP volumes, these will be updated in June this year when actual shrinkage volumes are finalised. The cost adjustment is reflective of the latest UK market gas prices compared against the gas price assumption within the Dec 2019 bid submission"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.1703529938420498,-9.3264642767889558,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.4235623493677725,-7.6826802204551212,-6.6121320382852202,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,0,0,0,0,2.8980548638190662E-2,-1.4876727733869286,-2.7143322385037356,-2.2195918618381003,-1.870434972069821,-1.7250399107972865]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.6776466634030172,-8.8430777730406351,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4380158637376868,-6.9735078813829219,-5.7262482922740654,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,0,0,0,0,2.8980548638190662E-2,-1.7041387820200953,-3.1168294807665697,-2.2195918618381003,-1.870434972069821,-1.7250399107972865]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9650900231403003,3.2027433705714721,3.2352869631510339,0,0,0,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9654558900566048,3.205982088021154,3.2587242087620125,0,0,0,null,0,0,0,0,-3.6586691630446921E-4,-3.2387174496819604E-3,-2.3437245610978596E-2,0,0,0]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.2733541247035971,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.2906299571047617,4.4617566271380635,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.2989998765529061,4.4912024336340712,0,0,0,null,0,0,0,0,0,-8.3699194481443584E-3,-2.9445806496007698E-2,0,0,0]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,0,0,0,0,0,null,0.8,0,0,0.9,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7239369753869207,0,0,0,0,0,null,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7385703966452448,0,0,0,0,0,null,0,0,0,0,-1.463342125832412E-2,0,0,0,0,0]
[null,25,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.52013551170712968,-12.988199313084364,5.7773836446089057E-2,-1.1936133540468441E-13,4.1995985286290716E-13,-5.4206496176626622E-4,null,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.52019875048966657,-13.046837992942569,1.1941043080997777E-13,-1.8020925018778287E-13,1.0421903553867473E-3,1.8147805349144622E-13,null,0,0,0,0,-6.3238782536889637E-5,5.8638679858205478E-2,5.7773836445969645E-2,6.0847914783098457E-14,-1.0421903549667874E-3,-5.4206496194774431E-4]
[null,26,null,"GD2 Incentive Assumption",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0]
[null,27,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719,null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233512,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501,null,0,0,0,0,-1.6508579051662764,-6.1350606337658746,-7.9604496110144964,-7.2342848335476901,-7.4971849267502648,-8.0084624321078195]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.37923287870495,439.86214631042196,413.58107236547005,436.2652859665917,446.39562074654998,457.82045160604048,470.91415091315719,null,421.35891895000003,410.34560751000004,408.89558755999997,449.42289132076002,441.56819907233506,419.71613299923604,444.22475453855571,453.62939434480006,465.31763653279063,478.92258745384459,null,0,0,0,-4.3658442055061641E-2,-1.7060527619130994,-6.1350606337659883,-7.9594685719640097,-7.2337735982500817,-7.4971849267501511,-8.0084365406873985]
[null,29,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.4477908756043121,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.421083399983956,-5.519485674687985E-2,0,0,5.1123529743790641E-4,0,0,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.464741842039018,0,0,-9.8103905088464671E-4,0,0,-2.5891420420975919E-5,null,0,0,0,-4.3658442055061641E-2,-5.519485674687985E-2,0,9.8103905088464671E-4,5.1123529743790641E-4,0,2.5891420420975919E-5]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,4.5418267800534373E-4,6.733046752344829E-2,6.7722542581665213E-3,null,null,null,null,null,null,null,null,4.5418267800534373E-4,6.733046752344829E-2,1.0550322952241009E-2,null,null,null,null,null,null,null,null,0,0,-3.7780686940744879E-3,0,0,0,0,0]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.842625412708738E-2,null,null,null,null,null,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.8526168597402545E-2,null,null,null,null,null,null,null,null,0,0,9.9914470315164844E-5,0,0,0,0,0]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.8999999999999996E-2,null,null,null,null,null,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,null,null,null,null,null,null,null,null,0,0,2.9999999999999957E-3,0,0,0,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.0769815857443812E-3,-3.6130774076232521E-3,3.9516399388378129E-3,null,null,null,null,null,null,null,null,-1.0769815857443812E-3,-3.6141718432215388E-3,7.3789228494550788E-3,null,null,null,null,null,null,null,null,0,1.0944355982867027E-6,-3.4272829106172659E-3,0,0,0,0,0]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1353936809144277E-2,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933595467905417E-2,1.297640069916948E-3,null,null,null,null,null,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.793250103230713E-2,5.4030772042935448E-3,null,null,null,null,null,null,0,0,0,1.0944355982867027E-6,-4.1054371343765966E-3,0,0,0,0,0]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.27572761540614,409.2076390972685,409.39349411865396]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340114,1345753,1348708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160912,1162830]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,2511538,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018","bopri 26/04/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,19059743380,19384528503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15841637342,15989045667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34901380722,35373574170,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14173.317543880596,14162.883813002833,14372.665175115741,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,13645.855449853219,13750.114519749233,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003,0.34499999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,0.34085252038066521,0.34231497592311966,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,114,116,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,109,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,113,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.3599999999999998E-2,3.09E-2,3.32E-2,3.4099999999999998E-2,3.5799999999999998E-2,3.7699999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21129999999999999,0.21340000000000001,0.19600000000000001,0.2107,0.21629999999999999,0.2273,0.23910000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1047,0.1128,0.1139,0.1046,0.1125,0.11550000000000001,0.12139999999999999,0.12770000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5115004355034047,4.3580343468257627,4.3520880108244429,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,81.228559999999987,80.922690000000003,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,43.373680000000007,43.183515,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.96027434682577,128.45829301082443,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.27572761540608,409.2076390972685,409.39349411865396,436.95814947872105,441.56819907233518,419.71613299923587,444.22573557760666,453.62939434480023,465.31763653279069,478.92261334526501]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","","",null,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","","",null,0,0,0,0,0,0,0,0,0,0]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.03597644816622,129.77225906344407,136.89004525046278,140.06855165015364,143.65356207080237,147.76206473719242,null,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.55397781249573,131.69730044258981,139.38785184319096,142.33850438321363,146.00600682606191,150.27493665247425,null,0,0,0,0,-0.51800136432950694,-1.925041379145739,-2.4978065927281818,-2.2699527330599949,-2.3524447552595404,-2.5128719152818348]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (18/19 Prices)","18/19 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},138.7659011533307,132.90073803295147,128.45829301082443,133.73074853597399,131.51297403388969,121.42378133072076,125.66462380188484,122.32358205810935,122.99452507493467,124.03154679544025,null,138.7659011533307,132.90073803295147,128.45829301082443,133.47038202629091,131.14101863026474,122.17710306628857,126.65202371486433,122.91713252797823,123.49091355388168,124.48731256346828,null,0,0,0,0.26036650968308095,0.37195540362495194,-0.75332173556780901,-0.98739991297948393,-0.59355046986887317,-0.49638847894701144,-0.45576576802803004]
[null,37,null,"% movement in domestic customer bill - (18/19 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,4.1044103899973816E-2,-1.658387862450128E-2,-7.6716329908021352E-2,3.4925962811299227E-2,-2.6586971278748872E-2,5.4849850334384165E-3,8.4314461954608788E-3,null,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.9017247528301935E-2,-1.7452286871909362E-2,-6.8353255583966321E-2,3.6626508046666117E-2,-2.9489392094472766E-2,4.668031332189182E-3,8.0686018178321994E-3,null,0,0,0,2.0268563716718813E-3,8.684082474080812E-4,-8.3630743240550309E-3,-1.7005452353668904E-3,2.902420815723894E-3,8.169537012492345E-4,3.6284437762867938E-4]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509,null,8.77,8.77,8.77,8.77,8.77,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509,null,0,0,0,0,0,0,0,0,0,0]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,32.481441185153081,33.151881862441371,33.250648594981207,33.151982045784486,33.151982109629245,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.166183577153298,32.76002528951021,33.493624415324646,33.62634398891268,33.559431796346516,33.592333264761216,null,0,0,0,0,-6.5009425943070909E-2,-0.27858410435712955,-0.34174255288327515,-0.37569539393147267,-0.40744975056203003,-0.44035115513197098]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,0,0,0,0,4.6338493295726479E-2,9.8845608484292136E-2,0.11302467087720736,5.4129415489696811E-2,2.419466215143691E-2,-4.8414412470581536E-3]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4971588894097829E-2,-5.397472889564308E-2,-7.7947091887781898E-4,5.1123529754040168E-4,-3.7496415434188139E-15,0,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4980704041784932E-2,-4.2453450696853169E-2,0,-8.9410044879364233E-4,-1.1322497084931879E-14,-9.5150041012734233E-4,null,0,0,0,0,9.1151476871026427E-6,-1.1521278198789911E-2,-7.7947091887781898E-4,1.405335746334044E-3,7.572855541513065E-15,9.5150041012734233E-4]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005276060824272,24.90291539609952,27.940384775427596,33.294095773116119,33.183289335737058,33.173514724540219,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4191894235820843,25.094175170171148,28.16988212835254,33.61425641581156,33.566544424147644,33.617755820509124,null,0,0,0,0,-1.8661817499657118E-2,-0.19125977407162864,-0.22949735292494466,-0.32016064269544131,-0.38325508841058564,-0.4442410959689056]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9471223517555991,3.4012722820179775,24.902428465184141,27.940384775427599,33.294095773116119,33.183289335737058,33.173514724540183,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.936063724666667,3.4191894235820843,25.095021248709205,28.169882128352551,33.615150516260378,33.566544424147693,33.618707320919249,null,0,0,0,1.1058627088932127E-2,-1.7917141564106842E-2,-0.1925927835250647,-0.22949735292495177,-0.32105474314425919,-0.38325508841063538,-0.44519259637906572]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.161797974788751E-2,7.4467593555027634E-4,-4.8693091537899136E-4,0,0,0,0,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,4.0559352658955383E-2,0,8.4607853805707123E-4,0,8.9410044881788053E-4,0,9.5150041012459496E-4,null,0,0,0,1.1058627088932127E-2,7.4467593555027634E-4,-1.3330094534360626E-3,0,-8.9410044881788053E-4,0,-9.5150041012459496E-4]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930837526498346,6.3232504719433482,0.12197244101804361,0.19161192806467331,-3.3281107297268298E-3,-2.9456426389629087E-4,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56694477483866756,6.3392175926542995,0.12256656922668707,0.19326933150278758,-1.4193975042527951E-3,1.5256678112103295E-3,null,null,null,0,0,-2.3636004263158927E-3,-1.5967120710951299E-2,-5.9412820864346294E-4,-1.6574034381142688E-3,-1.9087132254740347E-3,-1.8202320751066203E-3]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5376418422223997E-3,-2.1898835175409123E-4,1.9553169082173332E-5,0,0,0,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-5.1370185801875162E-3,0,-3.3716132621198278E-5,0,-2.6598846565509963E-5,0,null,null,null,0,0,-1.4006232620348835E-3,-2.1898835175409123E-4,5.326930170337161E-5,0,2.6598846565509963E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,0,0,2.9999999999999992E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7897071302195043E-3,0.12889091957692653,3.9002298576258226E-3,1.9963961898306799E-3,4.1265772461371066E-3,1.4021517497151866E-3,null,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-4.5729897627748983E-3,0.13003245090487384,2.9046182318817962E-3,1.0578987528334811E-3,3.170288808907018E-3,4.6822453638322922E-4,null,null,null,0,0,-2.216717367444606E-3,-1.1415313279473094E-3,9.9561162574402645E-4,9.3849743699719879E-4,9.5628843723008852E-4,9.3392721333195733E-4]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,6.4709224031685206,0.14489222404475161,0.21260832425450399,1.9798466516410276E-2,2.0107587485818895E-2,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56065478318162998,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2,null,0,0,0,0,-2.980941055795383E-3,-1.8327640390652711E-2,-5.4524728119606514E-4,-1.7189060011170709E-3,-1.9258259416784357E-3,-1.8863048617746639E-3]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.87150072575594,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,436.51681356108639,388.67815696937038,408.32490119116449,413.10101373813643,424.63716227030335,437.74063618861697,null,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,438.14900964875301,394.62195782906463,416.05585344925407,420.01513792898868,431.75109210864304,445.3048575247559,null,0,0,0,0,-1.6321960876666139,-5.9438008596942495,-7.7309522580895873,-6.9141241908522488,-7.1139298383396863,-7.5642213361389281]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.73341855999996,441.43211052694937,436.46087402840396,388.67864390028592,408.32490119116409,413.10152497343387,424.63716227030341,437.74063618861703,null,412.11372795000005,402.67729251000003,401.73341855999996,441.48682759609335,438.14900964875295,394.62111175052684,416.05487241020319,420.01424382853969,431.75109210864292,445.30388013292531,null,0,0,0,-5.4717069143976005E-2,-1.6881356203489872,-5.9424678502409165,-7.7299712190391006,-6.9127188551058225,-7.1139298383395158,-7.5632439443082831]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.461906585755969,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.369465420236111,-5.5939532682430126E-2,4.8693091554241619E-4,0,5.1123529743790641E-4,0,0,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.424182489380087,0,-8.460785377906177E-4,-9.8103905088464671E-4,-8.9410044898841079E-4,0,-9.7739183058820345E-4,null,0,0,0,-5.4717069143976005E-2,-5.5939532682430126E-2,1.3330094533330339E-3,9.8103905088464671E-4,1.4053357464263172E-3,0,9.7739183058820345E-4]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6515900416947327E-2,1.7373147113562304E-2,-0.10959178456712859,5.0547590260757502E-2,1.1696843697357462E-2,2.7925732807520198E-2,3.0858047958535861E-2,null,null,null,1.9513668221058378E-3,6.6515900416947327E-2,2.1177244501860315E-2,-9.9343033673823244E-2,5.4315010087385485E-2,9.5162330896458869E-3,2.7941740951342942E-2,3.1392544602301342E-2,null,null,null,0,0,-3.8040973882980111E-3,-1.0248750893305347E-2,-3.7674198266279824E-3,2.180610607711575E-3,-1.6008143822743293E-5,-5.3449664376548078E-4]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.8829042941176268E-2,1.2814977784263954E-4,-1.2527869313242332E-6,0,-1.237555175214305E-6,0,null,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.89565699346538E-2,0,2.1440229592016443E-6,2.3579503635184479E-6,2.1287338675387813E-6,0,null,null,null,0,0,1.2752699347753221E-4,1.2814977784263954E-4,-3.3968098905258773E-6,-2.3579503635184479E-6,-3.3662890427530861E-6,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,0,0,2.9999999999999992E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3,-1.0000000000000009E-3]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,-1.8445896877580664E-3,-1.4600548737914894E-3,1.7924281553768177E-3,-1.7501547461512487E-3,3.9838297738948383E-3,1.3707662900694327E-3,null,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,1.5997561098670676E-3,-2.2495148560157212E-3,8.6456006973401056E-4,-2.7908599853965071E-3,2.9841609985418634E-3,3.7886767132636404E-4,null,null,null,0,0,-3.444345797625134E-3,7.894599822242318E-4,9.2786808564280718E-4,1.0407052392452584E-3,9.9966877535297496E-4,9.9189861874306867E-4]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-9.1923689663077443E-2,7.1338765629202994E-2,2.8946688951206213E-2,5.090832502623982E-2,5.1228814248605294E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,9.8204306770735827E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2,null,0,0,0,0,-4.1209161924456129E-3,-1.0331141133238478E-2,-3.842948550875705E-3,2.218957896593314E-3,-1.9705657512525399E-5,-5.42598025022413E-4]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,0,0,0,0,0,0,0,0,0,0]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17,null,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.517784630239372,0,0,0,0,0,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.517784630239372,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,61,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973,0,0,0,0,0,null,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,0,0,0,0,0,null,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,0,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,0,0,0,0,0,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,0,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,0,0,0,0,0,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,0,0,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,0,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,0,0,0,0,0,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"High level mod186 rec","index":8,"n_rows":115,"n_cols":13,"rows_kept":115,"cut":false,"hidden":true,"merged":[[35,1,35,2],[17,1,17,2],[74,1,74,12]]}
[]
[null,"MOD186 Reconciliation - Dec 2019 to Mar 2020"]
[]
[null,"ALLOWED REVENUE",null,"16/17","17/18","18/19","19/20","20/21","21/22","22/23","23/24","24/25","25/26"]
[]
[null,"DECEMBER",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233512,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   December",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2]
[null,"Cost of debt %   March",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2]
[null,"Cost of debt £ movement",null,0,0,0,0,0]
[]
[null,"Totex Incentive",null,0,0,0,0,0]
[]
[null,"Pension deficit valuation",null,0,0,0,0,0]
[]
[null,"Tax trigger",null,0,0,0,0,0]
[]
[null,"Repex Tier 2a",null,0,0,0,0,0]
[]
[null,"FGO Impact",null,0,0,0,0,0]
[]
[null,"Ofgem changes to Fuel Poor allowances",null,0,0,0,0,0]
[]
[null,"\"MOD\" Adjustment",null,0,0,0,0,0]
[]
[null,"Change in Inflation %"]
[null,"December (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2]
[null,"March (Based on HM Treasury Feb report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5249999999999995E-2,2.3749999999999938E-2,1.8250000000000099E-2,1.9249999999999989E-2,2.0000000000000018E-2,2.0000000000000018E-2,2.0000000000000018E-2]
[null,"Difference",null,0,0,0,-2.0000000000000018E-3,-4.750000000000032E-3,-2.0000000000000018E-3,-1.7499999999999183E-3,-9.9999999999988987E-4,-9.9999999999988987E-4,-9.9999999999988987E-4]
[null,"Cumulative change in inflation",null,0,0,0,-2.0000000000000018E-3,-6.7500000000000338E-3,-8.7500000000000355E-3,-1.0499999999999954E-2,-1.1499999999999844E-2,-1.2499999999999734E-2,-1.3499999999999623E-2]
[]
[null,"£ impact on change in inflation (incl. changes in \"Mod\" above)",null,0,0,0,0,-2.3227652790990874,-3.9303228638344261,-4.6660669206182792,-5.0688223871993614,-5.6499024264768991,-6.2780390151015126]
[]
[null,"£ Impact of changes in RPI on RPI true up (19/20 & 20/21)",null,0,0,0,0,0,-0.64888236751732409,-0.40370206289031635,0,0,0]
[]
[null,"Total base revenue changes",null,0,0,0,0,-2.3227652790990874,-4.5792052313517502,-5.0697689835085953,-5.0688223871993614,-5.6499024264768991,-6.2780390151015126]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,-3.6586691630446921E-4,-3.2387174496819604E-3,-2.3437245610978596E-2,0,0,0]
[null,"Shrinkage/Leakage",null,0,0,0,0,0,-0.22483592808131031,-0.43194304875884204,0,0,0]
[null,"DRS",null,0,0,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,-1.0613984033401191E-2,-1.0399573409996421E-2,-1.6272864320172609E-3,0,0,0]
[null,"Total",null,0,0,0,0,-1.0979850949705661E-2,-0.23847421894098869,-0.4570075808018379,0,0,0]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,-2.7029041411362975E-2,4.0518991041782471E-2,0.14235431697437928,0,0,0]
[null,"License Fee",null,0,0,0,0,-1.8375650955851919E-3,-4.0401115738660232E-3,-4.7372752524210138E-3,0,0,0]
[null,"Pension Deficit",null,0,0,0,0,-1.0766550503645167E-2,-2.3671577896693385E-2,-2.7756357245463104E-2,0,1.4144653030025335E-15,-1.4609941867111868E-15]
[null,"Exit Capacity",null,0,0,0,0,4.6338493295726479E-2,9.8845608484292136E-2,0.11302467087720736,5.4129415489696811E-2,2.419466215143691E-2,-4.8414412470581536E-3]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,0,0,2.8980548638190662E-2,-1.4876727733869286,-2.7143322385037356,-2.2195918618381003,-1.870434972069821,-1.7250399107972865]
[null,"SOLR",null,null,null,null,null,0.6618980000000001]
[null,"Total",null,0,0,0,0,0.6975838849233239,-1.3760198633314134,-2.4914468831500329,-2.1654624463484033,-1.8462403099183826,-1.7298813520443461]
[]
[null,"Network Innovation",null,0,0,0,0,-1.463342125832412E-2,0,0,0,0,0]
[]
[null,"K factor",null,0,0,0,0,-6.3238782536889637E-5,5.8638679858205478E-2,5.7773836445969645E-2,6.0847914783098457E-14,-1.0421903549667874E-3,-5.4206496194774431E-4]
[]
[null,"MARCH",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716879,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[null,"Difference",null,0,0,0,0,-1.6508579051663332,-6.1350606337658746,-7.9604496110144964,-7.2342848335476901,-7.4971849267502648,-8.0084624321078195]
[]
[null,"Memo:"]
[null,"In year (under)/over collection",null,null,null,-0.49790655865399458,12.4210833999839,-5.519485674687985E-2]
[]
[null,"SOQ Assumption DECEMBER",null,null,null,null,null,-1.6E-2]
[null,"SOQ Assumption MARCH",null,null,null,null,null,-1.8999999999999996E-2]
[]
[null,"LDZ Price Change","December",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,9.8204306770735827E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2]
[null,"LDZ Price Change","March",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,5.6995144846279698E-3,-9.1923689663077443E-2,7.1338765629202994E-2,2.8946688951206213E-2,5.090832502623982E-2,5.1228814248605294E-2]
[null,"LDZ PRICE CHANGE %","Difference",0,0,0,0,-4.1209161924456129E-3,-1.0331141133238478E-2,-3.842948550875705E-3,2.218957896593314E-3,-1.9705657512525399E-5,-5.42598025022413E-4]
[]
[null,"GD2 data reflects our December 2019 business plan bid submission per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020"]
[]
[null,"JAN 2020 60 DAY NOTICE REVENUE",null,{"$error":"#REF!"},{"$error":"#REF!"},408.89558756000008,449.76604162339174,439.91777027286781]
[null,"Difference",null,{"$error":"#REF!"},{"$error":"#REF!"},-408.89558756000008,-0.38680874468684578,-5.5623962445906727E-2]
[]
[]
[null,"CUSTOMER BILL IMPACT",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"Customer Bill Impact"]
[]
[null,"Assumed TDCV KWh","December",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Average Customer Bill","December (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Assumed TDCV KWh","March",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Average Customer Bill","March (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Difference in Customer Bill £",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Assumed TDCV KWh","Variance"]
[null,"Average Customer Bill","Variance"]
[]
[]
[]
[]
[null,"Checks",null,0,0,0,0,0]
[null,"Checks",null,0,0,0,0,0]
[null,"Checks",null,0,0,0,0,-5.6843418860808015E-14]
[]
[]
[null,"CALENDAR YEAR BASIS VS. 2017 BUDGET PROCESS",null,null,2017,2018,2019,2020]
[null,"Latest Mod186 data above",null,null,413.42078950999996,409.64380349999999,438.27775305999995,443.21417351212187]
[null,"Budget Data",null,null,413.45491335157914,406.8386478036482,426.42511686815283,440.71219660975794]
[null,"Variance",null,null,-3.4123841579173586E-2,2.8051556963517896,11.852636191847125,2.5019769023639356]
[]
[null,"5 YEAR PLAN REVENUE JULY 2019",null,411.31483044543188,409.0452105191099,408.89558756000008,448.59433935175906,441.65085477418916,406.07662024021892,433.31513705812222,448.03923235625666,460.18695161390769,473.65344736819526]
[null,"Difference",null,-3.9102830025740332E-2,0.16242857815859679,0,0.78489352694583658,-1.7887084637672501,7.5044521252509639,2.9501489084698846,-1.6441228450041194,-2.3665000078672733,-2.7392964550380725]
[]
[]
[]
[]
[null,null,null,0,0,0,0,0,0,0,0,0,0]