{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["_com.sap.ip.bi.xl.hiddensheet","BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":64,"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":"BBPTACShadowWks0001","index":1,"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":2,"n_rows":160,"n_cols":23,"rows_kept":160,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,null,"Published:","2020-06-12T14:39:47.020","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, inclusive of latest mod678 data, 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.3901218350408078,1.4141014366952618,1.4395552625557768,1.4654672572817808,1.4918456679128527]
[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,2.4750000000000057E-2]
[null,3,null,"Actual/Forecast Annual Inflation (CPI in GD2 years)",null,null,null,null,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6999999999999904E-2,1.4750000000000041E-2,1.7249999999999988E-2,1.8000000000000016E-2,1.8000000000000016E-2,1.8000000000000016E-2,null,"As per May 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,-5.8653631202754686E-3,-7.7500000000001526E-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,311.3642446068738,309.19672494112058,312.61289223175504,314.45458426797063,316.09383170869296,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,-2.869525188304265,-2.3948897526282664,5.1602891017584946E-14,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,119.91501673578739,126.58480199689194,137.4106419232499,146.36831287889493,155.46938177989495,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,427.29339437323478,432.27029540426207,450.023534155005,460.82289714686556,471.56321348858791]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8693675209693668,4.9052520008783711,0,0,0,null,"Included actual costs up to 19/20 forecast thereafter"]
[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.49952641411803794,0.50886290311255267,0,0,0,null,"Included actual costs up to 19/20 forecast thereafter"]
[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.0588752106470438,2.0973569909933842,0,0,0,null,"Included actual costs up to 19/20 forecast thereafter"]
[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,3.6997000000000002E-2,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.4647661457344485,7.5114718949843073,0,0,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.1149235837818054,0.26471647735110676,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.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,"Inclusive of latest set of indicative prices (with mod 678 data) 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.3423557572368248,11.304980032941518,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-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.49351973243326808,0.35479809753594377,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.0805068887959308,-10.103738791231109,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633,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.5869871563626621,-9.7489406936951646,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633]
[]
[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.9640889147649161,3.1805390961845563,3.1946822121268652,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.2932858868858199,4.4350820998991107,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.51996247371974869,-12.976785184506575,3.1026799195387869E-7,5.9139537711416779E-14,5.9624589748810882E-14,0]
[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.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,439.91616672067653,414.32585740393347,448.96757126078666,447.59712418151355,458.84057051816376,469.77013909180255]
[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.495527521278973,-3.0012961360625923E-7,0,0,0,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.7695671670477964E-3,-5.8170877851966507E-2,8.3609828442544831E-2,-3.0524411271500851E-3,2.5119567864092751E-2,2.381996988909707E-2,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.8596623123257437E-2,6.8224274556398471E-10,0,0,0,0,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,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,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.6130384505847126E-3,4.0295371711657792E-3,0.49723760486284452,1.9777757072707212E-2,2.2686235780013803E-3,4.1106243970915231E-3,2.0481156312936004E-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.7933634424943957E-2,1.2024812149561347E-3,0.45806672769312068,0.12238758551525204,1.8216182450851295E-2,4.8230192261184274E-2,4.486808552039067E-2]
[]
[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.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255]
[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.0099999999999998E-2,3.1899999999999998E-2,3.2899999999999999E-2,3.4500000000000003E-2,3.6200000000000003E-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.1908,0.20200000000000001,0.20860000000000001,0.21879999999999999,0.2298]
[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.1018,0.10780000000000001,0.1113,0.1167,0.1226]
[]
[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.91616702080614,414.32585740393353,448.96757126078671,447.59712418151355,458.84057051816376,469.77013909180255]
[]
[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.03560802795519,130.00595553413908,140.87573117285757,140.44571629720818,143.973651998957,147.40310005439548]
[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.64801948250826,132.30359756847398,122.79613811770636,130.80668681163414,124.30340851346128,125.17274697382436,125.88836742404364]
[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.0400089009796414E-2,-1.0059422647937133E-2,-7.186092914704767E-2,6.5234532752562968E-2,-4.9716711405876302E-2,6.9936815953759446E-3,5.7170627594274048E-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,27.100567770661687,27.634573437196295,29.50674288431787,29.548131345028004,28.017792925240894]
[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,37.673090999999999,39.078089999999996,42.476587000000009,43.301819000000009,41.798223]
[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.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,"Inclusive of latest set of indicative prices (with mod 678 data) 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.4946647446030926E-2,-5.4014824296374067E-2,-7.7351167882460478E-2,-3.6962211069635487E-15,1.490614743720272E-14,-2.9999414278882231E-14]
[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.4005525475304941,30.161796834684996,50.041002387707948,42.47315860449573,43.303937300184174,41.802005820828484]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.4753761733333337,30.161796834684999,50.041002387707934,42.473158604495758,43.303937300184167,41.802005820828505]
[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.2011627992288645E-2,7.4823625802839633E-2,0,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.56930521632200892,7.8696752698583392,0.65908558637867931,-0.15123285749909721,1.9560087428969863E-2,-3.4683485451779017E-2]
[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.5874991060340385E-3,-2.200337290984581E-2,0,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.7430088093823996E-3,0.28747036754579997,1.4858889517931368E-2,-4.0445847535241324E-3,4.6576704659218419E-3,7.003370315971022E-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,8.1541422644942934,0.69294447589661068,-0.13627744225262134,4.3217757894891705E-2,-1.4983148420181915E-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.51561447327566,384.16406056924853,398.92656887307874,405.12396557701783,415.53663321797967,427.96813327097408]
[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.50616099999996,436.44079054734317,384.16406056924848,398.92656887307874,405.12396557701777,415.53663321797961,427.96813327097402]
[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.443515893286701,-7.4823925932491875E-2,0,0,0,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.7370352445174486E-2,-0.11993054124122793,3.8427614186385295E-2,1.5535181628654193E-2,2.5702423272173203E-2,2.9916736718789361E-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.9001629564353808E-2,1.7141179708491904E-4,0,0,0,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.669208396192709E-3,-1.4275342871607408E-3,1.3668734271197365E-3,-1.6588687370339798E-3,4.0008268602322213E-3,1.2771484243794991E-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,-0.10218666373130375,5.8794487613505031E-2,3.2876312891620213E-2,4.8703250132405423E-2,5.0193885143168859E-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]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":163,"n_cols":44,"rows_kept":163,"cut":false,"hidden":false,"merged":[[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],[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],[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],[27,43,27,51],[14,43,14,51]]}
[]
[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,"MARCH 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, inclusive of latest mod678 data, 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.3901218350408078,1.4141014366952618,1.4395552625557768,1.4654672572817808,1.4918456679128527,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.4033061789047276,1.4303198228486436,1.4589262193056165,1.488104743691729,1.5178668385655634,null,0,0,0,0,0,-1.3184343863919867E-2,-1.6218386153381781E-2,-1.9370956749839685E-2,-2.2637486409948115E-2,-2.6021170652710701E-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,2.4750000000000057E-2,0,0,0,0,0,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,2.4750000000000057E-2,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.5884636879724532E-2,1.6999999999999904E-2,1.4750000000000041E-2,1.7249999999999988E-2,1.8000000000000016E-2,1.8000000000000016E-2,1.8000000000000016E-2,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,0,0,0,6.346368797245372E-4,-6.7500000000000338E-3,-3.5000000000000586E-3,-2.0000000000000018E-3,-2.0000000000000018E-3,-2.0000000000000018E-3,-2.0000000000000018E-3,null,"Based on May HM Treasury RPI and CPI forecasts"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.8653631202754686E-3,-7.7500000000001526E-3,"","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-6.5000000000000058E-3,"","","","","","",null,0,0,0,6.346368797245372E-4,"","","","","",""]
[]
[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,311.3642446068738,309.19672494112058,312.61289223175504,314.45458426797063,316.09383170869296,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,3.0083112627586956,3.3967261346591044,5.1179371356294041,5.5368159190512642,4.7066743300877647,null,"Additional exit capacity mod678 allowances included in GD2 estimate - to be finalised once Initial/Final Proposals published"]
[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,-2.869525188304265,-2.3948897526282664,5.1602891017584946E-14,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-3.0780648310690926,-0.40370206289036942,0,0,0,null,0,0,0,0,0,0.20853964276482762,-1.9911876897378971,5.1602891017584946E-14,0,0,null,"Finalised RPI for 19/20 and latest forecast of 20/21 with 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,119.91501673578739,126.58480199689194,137.4106419232499,146.36831287889493,155.46938177989495,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,122.67022311608036,130.93769631583427,141.11749719781523,150.7842281417702,161.25708276157582,null,0,0,0,0,0,-2.7552063802929752,-4.352894318942333,-3.7068552745653278,-4.4159152628752736,-5.7877009816808709,null,"Impact of May 2020 inflation forecast vs. Feb 2020"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,427.29339437323478,432.27029540426207,450.023534155005,460.82289714686556,471.56321348858791,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,426.83174984800422,435.2176512782832,448.61245229394086,459.70199649068957,472.64424014018101,null,0,0,0,0,0,0.46164452523055388,-2.9473558740211274,1.4110818610641331,1.1209006561759907,-1.0810266515931062]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8693675209693668,4.9052520008783711,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.9464125338570284,4.6576007402913104,0,0,0,null,0,0,0,0,0,-7.7045012887661635E-2,0.24765126058706066,0,0,0,null,"Includes finalised actual costs for 19/20"]
[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.49952641411803794,0.50886290311255267,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.34606951621597665,0.35323091051740918,0,0,0,null,0,0,0,0,0,0.1534568979020613,0.15563199259514349,0,0,0,null,"Includes finalised actual costs for 19/20"]
[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.0588752106470438,2.0973569909933842,0,0,0,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0276696227323061,2.0696292320044525,0,1.4144653030025335E-15,0,null,0,0,0,0,0,3.1205587914737709E-2,2.7727758988931761E-2,0,-1.4144653030025335E-15,0,null,"Includes finalised actual costs for 19/20"]
[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,3.6997000000000002E-2,0,0,0,0,null,-0.15071466,0,0.78779600000000005,0.736896,0.89660300000000004,0,0,0,0,0,null,0,0,0,0,0,3.6997000000000002E-2,0,0,0,0,null,"OVO Energy £36k claim included within 21/22"]
[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.4647661457344485,7.5114718949843073,0,0,0,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,8.2741136946406986,7.3201516728053111,7.0804608828131723,0,1.4144653030025335E-15,0,null,0,0,0,0,0,0.14461447292913743,0.43101101217113502,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.1149235837818054,0.26471647735110676,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1261945536294298,0.26615176789610334,0,0,0,null,0,0,0,0,0,-1.1270969847624324E-2,-1.4352905449965814E-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.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,0,0,0,0,0,6.7271719139286645E-2,16.250981171685311,-4.6364338341647257E-2,-2.9188989768424191E-2,-1.774979408246433E-2,null,"Now includes Mod678 - this is the impact of additional costs from Oct 20 to Mar 21 with no additional revenue allowance until 2 years later"]
[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.3423557572368248,11.304980032941518,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,-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,0,0,0,0,0,5.6000749291661656E-2,16.249545881140314,-4.6364338341647257E-2,-2.9188989768424191E-2,-1.774979408246433E-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.49351973243326808,0.35479809753594377,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.49270633043903339,0.48338650374832015,0,0,0,null,0,0,0,0,0,8.1340199423468595E-4,-0.12858840621237638,0,0,0,null,"Includes impact of long range UK market gas price forecast as at 29th May"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0805068887959308,-10.103738791231109,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.1703529938420498,-9.3264642767889558,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266,null,0,0,0,0,0,8.9846105046119007E-2,-0.77727451444215312,-0.16270285246162031,-7.1592754283862803E-2,-4.5777440640836664E-2]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.5869871563626621,-9.7489406936951646,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.6776466634030172,-8.8430777730406351,-2.2602787255256045,-1.9128521746021299,-1.7510797769730266,null,0,0,0,0,0,9.0659507040355081E-2,-0.90586292065452945,-0.16270285246162031,-7.1592754283862803E-2,-4.5777440640836664E-2]
[]
[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.9640889147649161,3.1805390961845563,3.1946822121268652,0,0,0,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9650900231403003,3.2027433705714721,3.2352869631510339,0,0,0,null,0,0,0,0,-1.001108375384252E-3,-2.2204274386915746E-2,-4.0604751024168717E-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.2932858868858199,4.4350820998991107,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.2906299571047617,4.4617566271380635,0,0,0,null,0,0,0,0,0,2.6559297810582194E-3,-2.6674527238952805E-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.7239369753869207,0,0,0,0,0,null,0,0,0,0,0,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.51996247371974869,-12.976785184506575,3.1026799195387869E-7,5.9139537711416779E-14,5.9624589748810882E-14,0,null,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,0,0,0,0,-1.7303798738099729E-4,1.1414128577788674E-2,-5.7773526178097105E-2,1.785008731161012E-13,-3.6033526311409628E-13,5.4206496176626622E-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.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255,null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719,null,0,0,0,0,-1.1741463627004123E-3,0.74478503846364674,12.702285294194553,1.2020146702610077,1.0201189121233938,-1.1440118213546384]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,439.91616672067653,414.32585740393347,448.96757126078666,447.59712418151355,458.84057051816376,469.77013909180255,null,421.35891895000003,410.34560751000004,408.89558755999997,449.37923287870495,439.86214631042196,413.58107236547005,436.2652859665917,446.39562074654998,457.82045160604048,470.91415091315719,null,0,0,0,7.444412129501643E-2,5.4020410254565832E-2,0.74478503846341937,12.702285294194951,1.2015034349635698,1.0201189121232801,-1.1440118213546384]
[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.495527521278973,-3.0012961360625923E-7,0,0,0,0,0,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.421083399983956,-5.519485674687985E-2,0,0,5.1123529743790641E-4,0,0,null,0,0,0,7.444412129501643E-2,5.5194556617266244E-2,0,0,-5.1123529743790641E-4,0,0]
[]
[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.7695671670477964E-3,-5.8170877851966507E-2,8.3609828442544831E-2,-3.0524411271500851E-3,2.5119567864092751E-2,2.381996988909707E-2,null,null,null,4.5418267800534373E-4,6.733046752344829E-2,6.7722542581665213E-3,null,null,null,null,null,null,null,null,0,0,-2.6870911187248936E-6,-5.8170877851966507E-2,8.3609828442544831E-2,-3.0524411271500851E-3,2.5119567864092751E-2,2.381996988909707E-2]
[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.8596623123257437E-2,6.8224274556398471E-10,0,0,0,0,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.842625412708738E-2,null,null,null,null,null,null,null,null,0,0,-1.7036899617005677E-4,6.8224274556398471E-10,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,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.8999999999999996E-2,null,null,null,null,null,null,null,null,0,0,0,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.0769815857443812E-3,-3.6130384505847126E-3,4.0295371711657792E-3,0.49723760486284452,1.9777757072707212E-2,2.2686235780013803E-3,4.1106243970915231E-3,2.0481156312936004E-3,null,null,null,-1.0769815857443812E-3,-3.6130774076232521E-3,3.9516399388378129E-3,null,null,null,null,null,null,null,null,0,3.8957038539511046E-8,7.7897232327966276E-5,0.49723760486284452,1.9777757072707212E-2,2.2686235780013803E-3,4.1106243970915231E-3,2.0481156312936004E-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.7933634424943957E-2,1.2024812149561347E-3,0.45806672769312068,0.12238758551525204,1.8216182450851295E-2,4.8230192261184274E-2,4.486808552039067E-2,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933595467905417E-2,1.297640069916948E-3,null,null,null,null,null,null,0,0,0,3.8957038539511046E-8,-9.5158854960813218E-5,0.45806672769312068,0.12238758551525204,1.8216182450851295E-2,4.8230192261184274E-2,4.486808552039067E-2]
[]
[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,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[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.3500000000000002E-2,3.04E-2,3.2599999999999997E-2,3.3500000000000002E-2,3.5200000000000002E-2,3.6999999999999998E-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.21249999999999999,0.193,0.20680000000000001,0.21279999999999999,0.22359999999999999,0.2351]
[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.1134,0.10299999999999999,0.1103,0.1135,0.1193,0.12540000000000001]
[]
[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,439.91734116716884,413.58107236546994,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[]
[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.03560802795519,130.00595553413908,140.87573117285757,140.44571629720818,143.973651998957,147.40310005439548,null,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.03597644816622,129.77225906344407,136.89004525046278,140.06855165015364,143.65356207080237,147.76206473719242,null,0,0,0,0,-3.6842021103211664E-4,0.23369647069500843,3.9856859223947936,0.377164647054542,0.32008992815462989,-0.3589646827969375]
[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.64801948250826,132.30359756847398,122.79613811770636,130.80668681163414,124.30340851346128,125.17274697382436,125.88836742404364,null,138.7659011533307,132.90073803295147,128.45829301082443,133.73074853597399,131.51297403388969,121.42378133072076,125.66462380188484,122.32358205810935,122.99452507493467,124.03154679544025,null,0,0,0,-8.2729053465726565E-2,0.79062353458428447,1.3723567869856055,5.1420630097492932,1.979826455351926,2.1782218988896886,1.856820628603387]
[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.0400089009796414E-2,-1.0059422647937133E-2,-7.186092914704767E-2,6.5234532752562968E-2,-4.9716711405876302E-2,6.9936815953759446E-3,5.7170627594274048E-3,null,-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,0,0,0,-6.4401489017740232E-4,6.5244559765641474E-3,4.8554007609736827E-3,3.0308569941263741E-2,-2.3129740127127429E-2,1.5086965619375281E-3,-2.714383436033474E-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,27.100567770661687,27.634573437196295,29.50674288431787,29.548131345028004,28.017792925240894,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,3.9541998051869989,4.4566230705323875,6.7155638959746327,7.2701417167306133,6.1766265809263849]
[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,37.673090999999999,39.078089999999996,42.476587000000009,43.301819000000009,41.798223,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,32.481441185153081,33.151881862441371,33.250648594981207,33.151982045784486,33.151982109629245,null,0,0,0,0,0,5.1916498148469188,5.9262081375586249,9.2259384050188018,10.149836954215523,8.6462408903707555]
[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.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.5245510601579166,-5.2107176160948976,4.2935942837375451E-2,3.1307289952578046E-2,2.1532614910974489E-2,null,0,0,0,0,0,6.7271719139286645E-2,16.250981171685311,-4.6364338341647257E-2,-2.9188989768424191E-2,-1.774979408246433E-2]
[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.4946647446030926E-2,-5.4014824296374067E-2,-7.7351167882460478E-2,-3.6962211069635487E-15,1.490614743720272E-14,-2.9999414278882231E-14,null,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,0,0,0,0,2.4941448066903571E-5,-4.0095400730986996E-5,-7.6571696963582653E-2,-5.1123529754409794E-4,1.8655788980621534E-14,-2.9999414278882231E-14]
[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.4005525475304941,30.161796834684996,50.041002387707948,42.47315860449573,43.303937300184174,41.802005820828484,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005276060824272,24.90291539609952,27.940384775427596,33.294095773116119,33.183289335737058,33.173514724540219,null,0,0,0,0,2.4941448066861938E-5,5.2588814385854761,22.100617612280352,9.1790628313796105,10.120647964447116,8.6284910962882648]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.4753761733333337,30.161796834684999,50.041002387707934,42.473158604495758,43.303937300184167,41.802005820828505,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9471223517555991,3.4012722820179775,24.902428465184141,27.940384775427599,33.294095773116119,33.183289335737058,33.173514724540183,null,0,0,0,3.9364824440113466E-4,7.4103891315356218E-2,5.2593683695008586,22.100617612280335,9.179062831379639,10.120647964447109,8.6284910962883217]
[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.2011627992288645E-2,7.4823625802839633E-2,0,0,0,0,0,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.161797974788751E-2,7.4467593555027634E-4,-4.8693091537899136E-4,0,0,0,0,null,0,0,0,3.9364824440113466E-4,7.4078949867289356E-2,4.8693091537899136E-4,0,0,0,0,null,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.56930521632200892,7.8696752698583392,0.65908558637867931,-0.15123285749909721,1.9560087428969863E-2,-3.4683485451779017E-2,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930837526498346,6.3232504719433482,0.12197244101804361,0.19161192806467331,-3.3281107297268298E-3,-2.9456426389629087E-4,null,null,null,0,0,3.1589429745348951E-6,1.546424797914991,0.5371131453606357,-0.34284478556377052,2.2888198158696693E-2,-3.4388921187882726E-2]
[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.5874991060340385E-3,-2.200337290984581E-2,0,0,0,0,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5376418422223997E-3,-2.1898835175409123E-4,1.9553169082173332E-5,0,0,0,null,null,null,0,0,-4.9857263811638707E-5,-2.1784384558091719E-2,-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,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,0,0,0,0,0,0,0,0]
[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.7430088093823996E-3,0.28747036754579997,1.4858889517931368E-2,-4.0445847535241324E-3,4.6576704659218419E-3,7.003370315971022E-4,null,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,0,0,4.6698320837104679E-5,0.15857944796887344,1.0958659660305545E-2,-6.0409809433548123E-3,5.3109321978473539E-4,-7.0181471811808435E-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,8.1541422644942934,0.69294447589661068,-0.13627744225262134,4.3217757894891705E-2,-1.4983148420181915E-2,null,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,0,0,0,0,1.6832198613257727,0.54805225185185913,-0.34888576650712533,2.3419291378481429E-2,-3.5090735906000814E-2]
[]
[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.51561447327566,384.16406056924853,398.92656887307874,405.12396557701783,415.53663321797967,427.96813327097408,null,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,436.51681356108639,388.67815696937038,408.32490119116449,413.10101373813643,424.63716227030335,437.74063618861697,null,0,0,0,0,-1.1990878107326353E-3,-4.5140964001218435,-9.3983323180857496,-7.9770481611186028,-9.1005290523236795,-9.7725029176428961]
[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.50616099999996,436.44079054734317,384.16406056924848,398.92656887307874,405.12396557701777,415.53663321797961,427.96813327097402,null,412.11372795000005,402.67729251000003,401.73341855999996,441.43211052694937,436.46087402840396,388.67864390028592,408.32490119116409,413.10152497343387,424.63716227030341,437.74063618861703,null,0,0,0,7.4050473050590426E-2,-2.0083481060794384E-2,-4.5145833310374428,-9.3983323180853517,-7.9775593964160976,-9.1005290523237932,-9.7725029176430098]
[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.443515893286701,-7.4823925932491875E-2,0,0,0,0,0,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.369465420236111,-5.5939532682430126E-2,4.8693091554241619E-4,0,5.1123529743790641E-4,0,0,null,0,0,0,7.4050473050590426E-2,-1.8884393250061748E-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.7370352445174486E-2,-0.11993054124122793,3.8427614186385295E-2,1.5535181628654193E-2,2.5702423272173203E-2,2.9916736718789361E-2,null,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,0,0,-2.7946683878177225E-6,-1.0338756674099336E-2,-1.2119976074372207E-2,3.8383379312967314E-3,-2.2233095353469956E-3,-9.4131123974650066E-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.9001629564353808E-2,1.7141179708491904E-4,0,0,0,0,null,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,0,0,-1.725866231775397E-4,4.3262019242279503E-5,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,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,0,0,0,0,0,0,0,0]
[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.669208396192709E-3,-1.4275342871607408E-3,1.3668734271197365E-3,-1.6588687370339798E-3,4.0008268602322213E-3,1.2771484243794991E-3,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,null,null,0,0,1.7538129156535742E-4,3.252058663074861E-5,-4.2555472825708124E-4,9.128600911726889E-5,1.6997086337382922E-5,-9.3617865689933633E-5]
[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,-0.10218666373130375,5.8794487613505031E-2,3.2876312891620213E-2,4.8703250132405423E-2,5.0193885143168859E-2,null,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,0,0,0,0,0,-1.0262974068226308E-2,-1.2544278015697963E-2,3.9296239404140003E-3,-2.2050748938343967E-3,-1.0349291054364343E-3]
[]
[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,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","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,30]
[null,31]

{"sheet":"High level mod186 rec","index":4,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":true,"merged":[[19,1,19,2],[76,1,76,12]]}
[]
[null,"MOD186 Reconciliation - Mar 2020 to Jun 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,"MARCH",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91734116716884,413.58107236546988,436.2652859665921,446.39510951125254,457.82045160604042,470.91415091315719]
[]
[null,"Change to base allowed revenue (Exit Mod678 : 09/10 prices)",null,null,null,null,null,null,3.0083112627586956,3.3967261346591044,5.1179371356294041,5.5368159190512642,4.7066743300877647]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[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 %   June",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,"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,"June (Based on HM Treasury May report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6999999999999904E-2,1.4750000000000041E-2,1.7249999999999988E-2,1.8000000000000016E-2,1.8000000000000016E-2,1.8000000000000016E-2]
[null,"Difference",null,0,0,0,6.346368797245372E-4,-6.7500000000000338E-3,-3.5000000000000586E-3,-2.0000000000000018E-3,-2.0000000000000018E-3,-2.0000000000000018E-3,-2.0000000000000018E-3]
[null,"Cumulative change in inflation",null,0,0,0,6.346368797245372E-4,-6.1153631202754966E-3,-9.6153631202755552E-3,-1.1615363120275557E-2,-1.3615363120275559E-2,-1.5615363120275561E-2,-1.7615363120275562E-2]
[]
[null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,0,0,0,null,null,-2.7552063802929694,-4.3528943189423348,-3.7068552745653225,-4.4159152628752736,-5.7877009816808709]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 19/20 and 20/21)",null,null,null,null,null,null,0.20853964276482762,-1.9911876897378971,5.1602891017584946E-14,0,0]
[]
[null,"Total base revenue changes",null,0,0,0,0,0,-2.5466667375281418,-6.3440820086802319,-3.706855274565271,-4.4159152628752736,-5.7877009816808709]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,-1.001108375384252E-3,-2.2204274386915746E-2,-4.0604751024168717E-2,0,0,0]
[null,"Shrinkage/Leakage",null,0,0,0,0,0,3.4693317752929054E-3,-0.15526293345132919,0,0,0]
[null,"DRS",null,0,0,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,0,-1.1270969847624324E-2,-1.4352905449965814E-3,0,0,0]
[null,"Total",null,0,0,0,0,-1.001108375384252E-3,-3.0005912459247164E-2,-0.19730297502049449,0,0,0]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,0,-7.7045012887661635E-2,0.24765126058706066,0,0,0]
[null,"License Fee",null,0,0,0,0,0,0.1534568979020613,0.15563199259514349,0,0,0]
[null,"Pension Deficit",null,0,0,0,0,0,3.1205587914737709E-2,2.7727758988931761E-2,0,-1.4144653030025335E-15,0]
[null,"Exit Capacity",null,0,0,0,0,0,6.7271719139286645E-2,16.250981171685311,-4.6364338341647257E-2,-2.9188989768424191E-2,-1.774979408246433E-2]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,0,0,0,8.9846105046119007E-2,-0.77727451444215312,-0.16270285246162031,-7.1592754283862803E-2,-4.5777440640836664E-2]
[null,"SOLR",null,null,null,null,null,0,3.6997000000000002E-2,0,0,0,0]
[null,"Total",null,0,0,0,0,0,0.30173229711454302,15.904717669414294,-0.20906719080326758,-0.1007817440522884,-6.352723472330099E-2]
[]
[null,"Network Innovation",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"K factor",null,0,0,0,0,-1.7303798738099729E-4,1.1414128577788674E-2,-5.7773526178097105E-2,1.785008731161012E-13,-3.6033526311409628E-13,5.4206496176626622E-4]
[]
[null,"JUNE",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91616702080609,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255]
[null,"Difference",null,0,0,0,0,-1.1741463627572557E-3,0.74478503846364674,12.702285294194553,1.2020146702610077,1.0201189121233938,-1.1440118213546384]
[]
[null,"Memo:"]
[null,"In year (under)/over collection",null,null,null,-0.49790655865399458,12.495527521278916,-3.0012961360625923E-7]
[]
[null,"SOQ Assumption MARCH",null,null,null,null,-1.8999999999999996E-2]
[null,"SOQ Assumption JUNE",null,null,null,null,-1.8999999999999996E-2]
[]
[null,"Total 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,"Total Price Change","June",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10218666373130375,5.8794487613505031E-2,3.2876312891620213E-2,4.8703250132405423E-2,5.0193885143168859E-2]
[null,"TOTAL PRICE CHANGE %","Difference",0,0,0,0,0,-1.0262974068226308E-2,-1.2544278015697963E-2,3.9296239404140003E-3,-2.2050748938343967E-3,-1.0349291054364343E-3]
[]
[null,"GD2 data reflects our December 2019 business plan bid submission per Appendix A33, inclusive of latest mod678 adjustments, with 2 year lagged entries for GD1 included aswell.   Initial Proposals will be available in July with final GD2 data published by Ofgem in December 2020"]
[]
[null,null,null,0,0,0,0,0,0,0,0,0,0]