{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["_com.sap.ip.bi.xl.hiddensheet","BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":63,"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":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],[108,3,108,4],[151,3,151,4],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,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],[93,21,93,22],[31,21,31,22],[34,21,34,22],[43,21,43,22],[122,21,122,22],[112,21,116,22],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[1,3,1,22],[5,21,5,22],[27,21,27,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],[23,21,23,22],[3,3,3,4],[7,3,7,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,null,"Published:","2021-03-08T14:58:13.240","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,"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.3819994936726991,1.4040786621520611,1.4290836418948434,1.4567095162934216,1.4857933825215159]
[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.2157327839878773E-2,1.3646061451968894E-2,1.5977818886124817E-2,1.7808816853933429E-2,1.9331180897115718E-2,1.9965453580682135E-2]
[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,-1.2592672160121283E-2,"","","","","",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.6807612918206,305.66140481268138,312.59035525631583,313.06820373317845,311.80498394986091,null,"GD2 yrs as per final determinations * 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,0.80185544098002037,0.59952383057623726,0,0,0,null,"Finalisation of GD1 legacy entries feeding 21/22 and 22/23"]
[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.8705415309745583,-3.9687812285352857,-4.9732158940875662E-4,0,0,null,"Latest RPI inflation impact on the true up mechanism using Ofgem PCFM inflation assumption"]
[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,118.27165596205123,122.14980650641462,134.12719466202412,142.98122789383029,151.47279784006992,null,"Assumed CPIH 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.88373116387731,424.44195392113693,446.71705259675053,456.04943162700874,463.27778178993083]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8438063807437501,5.0849069566220422,0,0,0,null,"Actual 2020/21 business rate adjustment values available in July - post RRP process"]
[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.49690421222781606,0.50285009781943324,0,0,0,null,"Actual 2020/21 licensee fee adjustment values available in July - post RRP process"]
[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.0480674008566013,2.0725742859860654,0,0,0,null,"Actual 2020/21 NTS pension deficit adjustment values available in July - post RRP process"]
[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.75767600000000002,0.89660300000000004,0.80587799999999998,-4.6779999999999999E-3,0,0,0,null,"Supplier of Last resort claims for OVO - Cardiff Energy (£5.2k), EDF & Solarplicity (£218k), and provisional amount subject to Ofgem approval for LRSP & SP Extra Energy (£550k)"]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.4084383983709365,8.2741136946406986,8.1946559938281673,7.6556533404275404,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.1090709308565192,0.26771165011684755,0,0,0,null,"Data uses finalised July 2020 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.4181332790061605,12.566217452555646,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2,null,"The £12.6m included 2 months worth of Revenue Recovery charges for Feb & Mar 2021"]
[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.3090623481496415,12.833929102672494,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,1.0098809667567545,0.54275730153219837,0.48378036817084447,0,0,0,null,"2020/21 energy volumes and incentive value will be available in July - post RRP process"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0456644629380563,-8.6093710418314178,-0.96002920287185201,-1.3818431827388797,-1.7170305855285652,null,"Actuals and f'cast compared against allowance with actual/fcast gas prices as at 29.01.21"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.3847008339728273,-8.502907161405858,-8.1255906736605734,-0.96002920287185201,-1.3818431827388797,-1.7170305855285652]
[]
[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.4686268165402532,3.2356471867181593,0,0,0,null,"2021 scores and incentive value will be available in July - post RRP process"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.2733541247035971,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.2238675304449975,4.7181036278823498,5.6189514319902933,0,0,0,null,"2021 emissions volumes and incentive value will be available in July - post RRP process"]
[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.6475488999999999,2.7239369753869207,0,0,0,0,0,null,"2020/21 actual NIA spend available in July - post RRP process"]
[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,-11.610490592272082,0,0,0,0]
[null,26,null,"GD2 Incentive Assumption",null,null,null,null,null,null,null,null,null,null,null,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.93806577216412,440.04228144242546,417.8426575003005,445.66054430928483,445.71046671035322,454.62091859293474,461.50658609039152]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.70045647911843,417.39372842846353,445.65978360390909,445.71046671035344,454.62091859293452,461.50658609039215]
[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.515611227835848,-1.3418249633070332,-0.44892907183697162,-7.6070537573968977E-4,0,0,6.2527760746888816E-13,null,"Subject to SOQ movements - constant rolling position"]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,4.5418267800534373E-4,6.7281410303816402E-2,7.1044752413034207E-3,-5.0448842936992921E-2,6.6575028445879258E-2,1.1201889354106598E-4,1.9991569747838112E-2,1.5145953949431412E-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.8643902210071934E-2,3.0493091684477046E-3,1.0743974167755927E-3,1.7069165880921385E-6,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.2999999999999998E-2,1.9E-2,-1.3640871144579682E-2,0.02,0.02,0.02,0.02,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.5639444136680611E-3,3.8963828164417305E-3,0.71924603497167539,1.0685841917535802E-2,5.2526473099832154E-3,3.0864052800265405E-3,8.6584687715326666E-4]
[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.7933671242228719E-2,1.3569558476732163E-3,0.65820563005855048,9.8335267780190652E-2,2.5366373120112373E-2,4.3077975027864653E-2,3.6011800826584679E-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.93806577216412,440.04228144242546,417.8426575003005,445.66054430928483,445.71046671035322,454.62091859293474,461.50658609039152]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114,1345753,1348708,1351865]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041,1160912,1162830,1164484]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,2506665,2511538,2516349,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","bopri 28/04/2020"]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267,19059743380,19384528503,19306905769]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741,15841637342,15989045667,15920353696]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,34901380722,35373574170,35227259465,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,14281.681801807134,"","","","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,13645.855449853219,13750.114519749233,13671.595054977141,"","","","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,13999.353613111694,"","","","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998,0.33900000000000002,0.34,0.33550000000000002]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997,0.34300000000000003,0.34499999999999997,0.35624999999999996]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,0.34085252038066521,0.34231497592311966,0.34510242120627938,"","","","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,114,116,117,"","","","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,109,109,105,"","","","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,112,113,111,"","","","","",""]
[]
[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,2.8899999999999999E-2,3.0300000000000001E-2,3.1699999999999999E-2,3.3099999999999997E-2,3.44E-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.18340000000000001,0.19239999999999999,0.20130000000000001,0.21,0.2185]
[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,9.7900000000000001E-2,0.1027,0.1074,0.112,0.1166]
[null,null,null,null,"Memo : Exit",null,null,5.1199999999999996E-3,5.1473927969485894E-3,3.3019814815517974E-3,4.1027777103017629E-3,3.389596903965026E-3,3.097359283372487E-3,3.5962241668363879E-3,1.56783481731635E-3,1.9942198327608286E-2,2.984219329978522E-2,2.4129553374381531E-2,2.5101273995332886E-2,2.4718352659373381E-2]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,4.3580343468257627,4.3520880108244429,4.6617847531661951,"","","","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,81.228559999999987,80.922690000000003,85.608194999999995,"","","","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,43.373680000000007,43.183515,45.700919999999996,"","","","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,128.45829301082443,135.97089975316618,0,0,0,0,0,0]
[null,null,null,null,"Memo : Exit (using 19/20 soq in future years)",null,null,2.2986240000000002,2.2921340124812066,1.4101111916966951,1.6322901120435562,1.3856672143409026,1.2775058364269822,1.4570102211937626,0.63520827623571918,8.0795816524304982,12.090564615407981,9.7760885496306766,10.169781159209119,10.014640579945127]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.4080416156043,411.27572761540608,409.2076390972685,409.39349411865396,436.93806577216412,440.04228144242546,417.8419635241039,445.6597836039092,445.71046671035322,454.62091859293469,461.50658609039152]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,13999.353613111694,"","","","","",""]
[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,135.97089975316618,136.9369016440003,130.02837744200383,138.68501398095697,138.70078607344632,141.4736325123136,143.61638563540387]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (19/20 Prices)","19/20 prices",140.25979326838052,null,145.37637917099863,148.623694459418,150.55250578297546,142.35780611597241,136.34082537798182,131.78338927959888,135.97089975316618,135.29211109526585,126.73710494494838,133.04879552752433,130.73567887406699,130.82037792609054,130.20223075163332]
[null,37,null,"% movement in domestic customer bill - (19/20 prices)",null,null,null,null,2.2337296519125305E-2,1.2977818446601175E-2,-5.4430842079877917E-2,-4.2266602037185352E-2,-3.3426789706958449E-2,3.1775707822196297E-2,-4.9921612575378749E-3,-6.3233591974135583E-2,4.980144201114256E-2,-1.7385476090077234E-2,6.4786485795620408E-4,-4.7251596750963465E-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,31.81083911763896,29.238045237848823,29.76682766880732,29.770207259379873,28.173508056383682]
[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,43.962563553880734,41.052515441500219,42.539286492595359,43.366544216766165,41.860011832591489]
[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.4181332790061605,12.566217452555646,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2,null,"The £12.6m included 2 months worth of Revenue Recovery charges for Feb & Mar 2021"]
[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,-8.0064686249006825E-3,0,0,0,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.4005525475304941,36.536423806249672,53.618732894055867,42.492729809069871,43.319874365431012,41.805846718580732]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.3560475699999999,36.277595430066363,53.625334211664089,42.492729809069871,43.319874365431019,41.805846718580725]
[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,-4.4504977530494205E-2,-0.25882837618330967,6.6013176082222458E-3,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,9.7442609092403796,0.46754190225054848,-0.20750216359960671,1.9465554697890797E-2,-3.4949954703896058E-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,1.3087572360207767E-2,7.084119057624798E-3,-1.2311588230303112E-4,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.364087114457968E-2,0.02,0.02,0.02,0.02]
[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,3.7475942513353951E-3,1.3735493249690433E-2,-6.0122192372390696E-3,3.6554769471414499E-3,-3.051011164060223E-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,9.7474552047073431,0.50836151455786371,-0.19363749871914882,4.3121031645032247E-2,-1.5255055820302081E-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.04256140015639,436.64172889489498,381.30623369405083,392.04181141522895,403.21773690128333,411.30104422750372,419.70073937181081]
[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,435.34440890911844,381.11613299839718,392.03444939224499,403.21773690128356,411.3010442275035,419.70073937181144]
[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.463599599843576,-1.2973199857765394,-0.19010069565365484,-7.3620229839548301E-3,0,0,6.2527760746888816E-13]
[]
[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.6465978587054941E-2,1.7711919931531206E-2,-0.12672974555339411,2.8154739609612678E-2,2.8506973390696411E-2,2.0047003359376925E-2,2.0422255820145674E-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.9049797668486119E-2,2.9711314790273292E-3,4.9855124006754675E-4,1.8778667911411581E-5,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.364087114457968E-2,0.02,0.02,0.02,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.2197712686397161E-3,-3.7494628703819682E-3,-1.9626077784171171E-3,6.0198159470973081E-4,3.443536403884076E-4,-2.280191555055603E-3,3.0268688936922507E-3,2.3358349975623541E-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,-0.13679750362423673,4.8997644490068631E-2,4.6245560503552219E-2,4.3073872253069176E-2,4.065583931990191E-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,null,null,null,null,null,null,"GD2 years as per draft determination(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.19,0.19,0.19,0.19,0.19,0.19]
[]
[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]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973]
[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]
[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]
[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.80185544098002037,0.59952383057623726,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]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,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]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,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]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,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]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117]
[]
[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,0.80185544098002037,0.59952383057623726,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,0.80185544098002037,0.59952383057623726,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,6.9397619660094279E-4,7.6070537562600293E-4,0,0,0]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":213,"n_cols":44,"rows_kept":213,"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],[27,43,27,51],[14,43,14,51],[23,43,23,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],[38,43,38,51],[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],[43,43,43,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,"JANUARY 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,"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.3819994936726991,1.4040786621520611,1.4290836418948434,1.4567095162934216,1.4857933825215159,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.3806575756655506,1.4026712264365502,1.4275408206802833,1.4551097659011545,1.4841861170150621,null,0,0,0,0,0,1.341918007148557E-3,1.4074357155109407E-3,1.5428212145600639E-3,1.5997503922671186E-3,1.6072655064538477E-3]
[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,0,0,0,0,0,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.2157327839878773E-2,1.3646061451968894E-2,1.5977818886124817E-2,1.7808816853933429E-2,1.9331180897115718E-2,1.9965453580682135E-2,null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.2187315391552156E-2,1.2633376478261793E-2,1.5944323313032749E-2,1.7730166396093816E-2,1.9312193964256208E-2,1.9982239000300162E-2,null,0,0,0,0,-2.998755167338274E-5,1.0126849737071009E-3,3.3495573092068298E-5,7.8650457839612997E-5,1.8986932859510475E-5,-1.6785419618026154E-5]
[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,-1.2592672160121283E-2,"","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.8653631202754686E-3,-1.2562684608447901E-2,"","","","","",null,0,0,0,0,-2.998755167338274E-5,"","","","",""]
[]
[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.6807612918206,305.66140481268138,312.59035525631583,313.06820373317845,311.80498394986091,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,309.98112351035115,301.87608901004222,308.39170266823038,309.71327445745555,308.10788548414837,null,0,0,0,0,0,1.6996377814694483,3.7853158026391611,4.1986525880854515,3.3549292757228955,3.6970984657125427,null,"Updated to reflect Ofgem's latest PCFM model, published 3rd Feb."]
[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,0.80185544098002037,0.59952383057623726,0,0,0,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,0.80146350318811832,0.5980257351980196,0,0,0,null,0,0,0,0,0,3.919377919020528E-4,1.4980953782176565E-3,0,0,0,null,"This included updated allowances and inflation methodology"]
[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.8705415309745583,-3.9687812285352857,-4.9732158940875662E-4,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-2.8705415309745583,-3.9589154483450417,5.1480429087580584E-14,0,0,null,0,0,0,0,0,0,-9.8657801902439779E-3,-4.9732158946023703E-4,0,0]
[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,118.27165596205123,122.14980650641462,134.12719466202412,142.98122789383029,151.47279784006992,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,117.20905275161385,120.20348141083196,131.85004164976516,140.95353583481261,149.18156069429119,null,0,0,0,0,0,1.0626032104373735,1.9463250955826652,2.2771530122589638,2.0276920590176815,2.2912371457787231]
[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.88373116387731,424.44195392113693,446.71705259675053,456.04943162700874,463.27778178993083,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,425.12109823417859,418.71868070772712,440.2417443179956,450.66681029226817,457.28944617843956,null,0,0,0,0,0,2.7626329296987251,5.7232732134098114,6.4753082787549374,5.3826213347405769,5.9883356114912658]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8438063807437501,5.0849069566220422,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8469685428862874,5.0995840493513773,0,0,0,null,0,0,0,0,0,-3.1621621425372837E-3,-1.4677092729335151E-2,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.49690421222781606,0.50285009781943324,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.49722860415533415,0.50444819075233938,0,0,0,null,0,0,0,0,0,-3.2439192751809731E-4,-1.5980929329061366E-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.0480674008566013,2.0725742859860654,0,0,0,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0494044322511877,2.0791610726521519,0,0,0,null,0,0,0,0,0,-1.3370313945864076E-3,-6.5867866660864749E-3,0,0,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.75767600000000002,0.89660300000000004,0.80587799999999998,-4.6779999999999999E-3,0,0,0,null,-0.15071466,0,0.78779600000000005,0.75767600000000002,0.89660300000000004,0.80587799999999998,-4.6779999999999999E-3,0,0,0,null,0,0,0,0,0,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.4084383983709365,8.2741136946406986,8.1946559938281673,7.6556533404275404,0,0,0,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.4084383983709365,8.2741136946406986,8.1994795792928095,7.6785153127558683,0,0,0,null,0,0,0,0,0,-4.8235854646421217E-3,-2.2861972328327873E-2,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.1090709308565192,0.26771165011684755,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1097949610582394,0.26855449998454795,0,0,0,null,0,0,0,0,0,-7.2403020172018273E-4,-8.4284986770039039E-4,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.4181332790061605,12.566217452555646,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,0,0,0,0,0,4.8427493543963251E-3,-2.8206116666956049E-2,-3.9931948031280931E-2,-5.2048185758686707E-2,-5.3152958284694359E-2]
[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.3090623481496415,12.833929102672494,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3131810673023177,12.86297806920715,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,0,0,0,0,0,4.1187191526761424E-3,-2.9048966534656273E-2,-3.9931948031280931E-2,-5.2048185758686707E-2,-5.3152958284694359E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,1.0098809667567545,0.54275730153219837,0.48378036817084447,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,1.0098809667567545,0.54275730153219837,0.45668449927427157,0,0,0,null,0,0,0,0,0,0,2.7095868896572894E-2,0,0,0,null,"Movement reflects updated gas prices as at 29.01.2021"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0456644629380563,-8.6093710418314178,-0.96002920287185201,-1.3818431827388797,-1.7170305855285652,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.051569706762935,-8.8524826035156092,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255,null,0,0,0,0,0,5.9052438248787809E-3,0.24311156168419146,0.2725797300137629,0.13908953644738986,-4.2486927107439731E-2]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.3847008339728273,-8.502907161405858,-8.1255906736605734,-0.96002920287185201,-1.3818431827388797,-1.7170305855285652,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.3847008339728273,-8.5088124052307368,-8.3957981042413383,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255,null,0,0,0,0,0,5.9052438248787809E-3,0.27020743058076491,0.2725797300137629,0.13908953644738986,-4.2486927107439731E-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.4686268165402532,3.2356471867181593,0,0,0,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9640889147649161,3.4686268165402532,3.2356471867181593,0,0,0,null,0,0,0,0,0,0,0,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.2238675304449975,4.7181036278823498,5.6189514319902933,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.2238675304449975,4.7181036278823498,5.6191179066990991,0,0,0,null,0,0,0,0,0,0,-1.6647470880570836E-4,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.6475488999999999,2.7239369753869207,0,0,0,0,0,null,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6475488999999999,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,-11.610490592272082,0,0,0,0,null,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.51996247371974869,-11.375627003900552,0,0,0,0,null,0,0,0,0,0,-0.23486358837152999,0,0,0,0,null,"Movement reflects latest forecast of 2021 under recovery"]
[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,0,0,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.93806577216412,440.04228144242546,417.8426575003005,445.66054430928483,445.71046671035322,454.62091859293474,461.50658609039152,null,411.27572761540614,409.2076390972685,409.39349411865396,436.93806577216412,440.04228144242546,415.30968778146041,439.71914107886602,439.00251064961577,449.15125590750546,455.61389036429239,null,0,0,0,0,0,2.5329697188400928,5.941403230418814,6.7079560607374447,5.4696626854292845,5.8926957260991344]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.70045647911843,417.39372842846353,445.65978360390909,445.71046671035344,454.62091859293452,461.50658609039215,null,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.47326733987069,415.30434995498268,439.69865244914195,439.00251064961589,449.15125590750654,455.61389036429358,null,0,0,0,0,0.22718913924774142,2.0893784734808492,5.9611311547671448,6.7079560607375583,5.4696626854279771,5.892695726098566]
[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.515611227835848,-1.3418249633070332,-0.44892907183697162,-7.6070537573968977E-4,0,0,6.2527760746888816E-13,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.515611227835848,-1.5690141025547746,-5.3378264777279583E-3,-2.0488629724070506E-2,0,1.0800249583553523E-12,1.1937117960769683E-12,null,0,0,0,0,0.22718913924774142,-0.44359124535924366,1.9727924348330816E-2,0,-1.0800249583553523E-12,-5.6843418860808015E-13,null,"Movement reflects latest forecast of 2021 under recovery"]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,4.5418267800534373E-4,6.7281410303816402E-2,7.1044752413034207E-3,-5.0448842936992921E-2,6.6575028445879258E-2,1.1201889354106598E-4,1.9991569747838112E-2,1.5145953949431412E-2,null,null,null,4.5418267800534373E-4,6.7281410303816402E-2,7.1044752413034207E-3,-5.6205039160994841E-2,5.8774100425632358E-2,-1.6297458134116871E-3,2.3117738536100996E-2,1.4388548115554567E-2,null,null,null,0,0,0,5.7561962240019193E-3,7.8009280202469E-3,1.7417647069527531E-3,-3.1261687882628841E-3,7.5740583387684524E-4]
[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.8643902210071934E-2,3.0493091684477046E-3,1.0743974167755927E-3,1.7069165880921385E-6,0,0,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.8643902210071934E-2,3.5655985088788845E-3,1.285264137767181E-5,4.6594809754701485E-5,0,-2.4045907567889864E-15,null,null,null,0,0,0,-5.1628934043117984E-4,1.061544775397921E-3,-4.488789316660935E-5,0,2.4045907567889864E-15]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999998E-2,1.9E-2,-1.3640871144579682E-2,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999998E-2,1.9E-2,-1.4999999999999998E-2,1.9999999999999997E-2,0.02,0.02,1.9999999999999997E-2,null,null,null,0,0,0,1.3591288554203156E-3,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.5639444136680611E-3,3.8963828164417305E-3,0.71924603497167539,1.0685841917535802E-2,5.2526473099832154E-3,3.0864052800265405E-3,8.6584687715326666E-4,null,null,null,-1.0769815857443812E-3,-3.5639444136680611E-3,3.8911401944722347E-3,0.63597656527996171,1.1537391174104183E-2,3.5431007049303055E-3,3.2135357344099287E-3,8.469180091207236E-4,null,null,null,0,0,5.2426219694957921E-6,8.3269469691713671E-2,-8.5154925656838118E-4,1.7095466050529098E-3,-1.2713045438338816E-4,1.8928868032543067E-5]
[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.7933671242228719E-2,1.3569558476732163E-3,0.65820563005855048,9.8335267780190652E-2,2.5366373120112373E-2,4.3077975027864653E-2,3.6011800826584679E-2,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933671242228719E-2,1.3517132257037225E-3,0.56833712462784569,9.0324344241114213E-2,2.195994970127332E-2,4.6331274270510925E-2,3.5235466124672883E-2,null,0,0,0,0,5.2426219694938405E-6,8.9868505430704793E-2,8.0109235390764394E-3,3.4064234188390524E-3,-3.2532992426462723E-3,7.763347019117961E-4]
[]
[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","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,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]
[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]
[]
[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]
[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]
[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]
[]
[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]
[]
[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]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,14084.42721949658,13999.353613111694,"","","","","","",null,13967.493608369672,13923.432417973681,14084.42721949658,13999.353613111694,"","","","","","",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,135.97089975316618,136.9369016440003,130.02837744200383,138.68501398095697,138.70078607344632,141.4736325123136,143.61638563540387,null,129.79446543550341,128.96027434682577,128.45829301082443,135.97089975316618,136.9369016440003,129.23869664454463,136.82996762506679,136.61333503053635,139.77152639031706,141.78263572296865,null,0,0,0,0,0,0.78968079745919795,1.8550463558901811,2.0874510429099757,1.7021061219965361,1.8337499124352235]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (19/20 Prices)","19/20 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},142.35780611597241,136.34082537798182,131.78338927959888,135.97089975316618,135.29211109526585,126.73710494494838,133.04879552752433,130.73567887406699,130.82037792609054,130.20223075163332,null,138.7659011533307,132.90073803295147,128.45829301082443,135.97089975316618,135.28810286565184,126.0896506399102,131.40085407548895,128.90726964751298,129.38853766646068,128.67895718940767,null,3.5919049626417063,3.4400873450303493,3.3250962687744448,0,4.0082296140155904E-3,0.64745430503818113,1.6479414520353828,1.8284092265540153,1.4318402596298654,1.5232735622256541]
[null,37,null,"% movement in domestic customer bill - (19/20 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877917E-2,-4.2266602037185352E-2,-3.3426789706958449E-2,3.1775707822196297E-2,-4.9921612575378749E-3,-6.3233591974135583E-2,4.980144201114256E-2,-1.7385476090077234E-2,6.4786485795620408E-4,-4.7251596750963465E-3,null,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.1775707822196297E-2,-5.0216398417149977E-3,-6.7991582636620862E-2,4.2122437556327386E-2,-1.8976927094731311E-2,3.7334435851732461E-3,-5.4841061646602185E-3,null,-2.2204460492503131E-16,0,-1.1102230246251565E-16,0,2.9478584177122791E-5,4.7579906624852786E-3,7.6790044548151748E-3,1.5914510046540764E-3,-3.0855787272170421E-3,7.5894648956387201E-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,31.81083911763896,29.238045237848823,29.76682766880732,29.770207259379873,28.173508056383682,null,8.77,8.77,8.77,8.77,8.77,30.243594266757299,27.543945602259019,29.323799632908784,29.278103765626376,27.6802716063182,null,0,0,0,0,0,1.5672448508816608,1.6940996355898044,0.44302803589853568,0.49210349375349693,0.49323645006548134,null,"Allowance updated to reflect the latest revenue recovery charges, published Nation Grid in October"]
[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,43.962563553880734,41.052515441500219,42.539286492595359,43.366544216766165,41.860011832591489,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,41.756047539753681,38.635099958822281,41.860920993426795,42.602854716430308,41.082674833303685,null,0,0,0,0,0,2.2065160141270539,2.4174154826779386,0.6783654991685637,0.76368950033585747,0.77733699928780453]
[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.4181332790061605,12.566217452555646,-4.6556683525486753E-2,-4.6669851335151884E-2,-5.4165114010760455E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,0,0,0,0,0,4.8427493543963251E-3,-2.8206116666956049E-2,-3.9931948031280931E-2,-5.2048185758686707E-2,-5.3152958284694359E-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,-8.0064686249006825E-3,0,0,0,0,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4946647446030926E-2,-1.2227206284500955E-2,0,0,0,0,null,0,0,0,0,0,4.2207376596002724E-3,0,0,0,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.4005525475304941,36.536423806249672,53.618732894055867,42.492729809069871,43.319874365431012,41.805846718580732,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005525475304941,34.320844305108622,51.229523528044879,41.854296257932589,42.60823305085384,41.081662677577619,null,0,0,0,0,0,2.2155795011410504,2.3892093660109879,0.63843355113728251,0.71164131457717161,0.72418404100311307]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.3560475699999999,36.277595430066363,53.625334211664089,42.492729809069871,43.319874365431019,41.805846718580725,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.3601303900000001,34.398867007049589,51.397436714956406,41.854296257932575,42.608233050853904,41.081662677577583,null,0,0,0,0,-4.0828200000002646E-3,1.8787284230167742,2.2278974967076834,0.63843355113729672,0.71164131457711477,0.72418404100314149]
[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,-4.4504977530494205E-2,-0.25882837618330967,6.6013176082222458E-3,0,0,0,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.2011627992288645E-2,-4.0422157530493941E-2,7.8022701940966499E-2,0.16791318691152668,0,6.3948846218409017E-14,0,null,0,0,0,0,-4.0828200000002646E-3,-0.33685107812427617,-0.16131186930330443,0,-6.3948846218409017E-14,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,9.7442609092403796,0.46754190225054848,-0.20750216359960671,1.9465554697890797E-2,-3.4949954703896058E-2,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930521632200892,9.0927257630624378,0.49266501350083103,-0.18300438154533982,1.8013366854265467E-2,-3.582806101004532E-2,null,null,null,0,0,0,0.65153514617794173,-2.5123111250282548E-2,-2.4497782054266892E-2,1.4521878436253299E-3,8.7810630614926222E-4]
[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,1.3087572360207767E-2,7.084119057624798E-3,-1.2311588230303112E-4,0,0,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5874991060340385E-3,1.1886938068299754E-2,-2.2733328250130751E-3,-3.2776644276147713E-3,0,-1.5008565631455475E-15,null,null,null,0,0,0,1.2006342919080124E-3,9.3574518826378735E-3,3.1545485453117403E-3,0,1.5008565631455475E-15]
[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.364087114457968E-2,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,-1.4999999999999999E-2,0.02,0.02,0.02,0.02,null,null,null,0,0,0,1.359128855420319E-3,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,3.7475942513353951E-3,1.3735493249690433E-2,-6.0122192372390696E-3,3.6554769471414499E-3,-3.051011164060223E-4,null,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7430088093823996E-3,7.1378149803132951E-3,1.4262139582427297E-2,-5.0428586348372235E-3,3.6217806678529342E-3,-3.2302165326690557E-4,null,null,null,0,0,0,-3.3902207289779E-3,-5.2664633273686451E-4,-9.6936060240184613E-4,3.3696279288515651E-5,1.7920536860883268E-5]
[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,9.7474552047073431,0.50836151455786371,-0.19363749871914882,4.3121031645032247E-2,-1.5255055820302081E-2,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,9.0967505161110509,0.52465382025824525,-0.17132490460779182,4.1635147522118401E-2,-1.6151082663313727E-2,null,0,0,0,0,0,0.65070468859629216,-1.6292305700381537E-2,-2.2312594111356998E-2,1.4858841229138456E-3,8.9602684301164602E-4]
[]
[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.04256140015639,436.64172889489498,381.30623369405083,392.04181141522895,403.21773690128333,411.30104422750372,419.70073937181081,null,402.51128113785808,401.51958066989596,402.30309265804107,429.04256140015639,436.64172889489498,380.9888434763518,388.48961755082115,397.14821439168315,406.54302285665165,414.53222768671475,null,0,0,0,0,0,0.3173902176990282,3.5521938644077977,6.0695225096001764,4.7580213708520773,5.168511685096064]
[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,435.34440890911844,381.11613299839718,392.03444939224499,403.21773690128356,411.3010442275035,419.70073937181144,null,412.11372795000005,402.67729251000003,401.73341855999996,441.50616099999996,435.11313694987069,380.90548294793308,388.30121573418552,397.14821439168333,406.54302285665261,414.532227686716,null,0,0,0,0,0.23127195924774924,0.21065005046409624,3.7332336580594756,6.0695225096002332,4.7580213708508836,5.1685116850954387]
[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.463599599843576,-1.2973199857765394,-0.19010069565365484,-7.3620229839548301E-3,0,0,6.2527760746888816E-13,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.463599599843576,-1.5285919450242886,-8.3360528418722879E-2,-0.18840181663563271,0,9.6633812063373625E-13,1.2505552149377763E-12,null,0,0,0,0,0.23127195924774924,-0.10674016723493196,0.18103979365167788,0,-9.6633812063373625E-13,-6.2527760746888816E-13]
[]
[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.6465978587054941E-2,1.7711919931531206E-2,-0.12672974555339411,2.8154739609612678E-2,2.8506973390696411E-2,2.0047003359376925E-2,2.0422255820145674E-2,null,null,null,1.9513668221058378E-3,6.6465978587054941E-2,1.7711919931531206E-2,-0.12745663489240056,1.9687647559514243E-2,2.2287846186080706E-2,2.365567343506414E-2,1.96515605505303E-2,null,null,null,0,0,0,7.2688933900644237E-4,8.4670920500984348E-3,6.2191272046157042E-3,-3.6086700756872148E-3,7.7069526961537349E-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.9049797668486119E-2,2.9711314790273292E-3,4.9855124006754675E-4,1.8778667911411581E-5,0,0,null,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.9049797668486119E-2,3.5007921686574291E-3,2.188004448059307E-4,4.8495972124914383E-4,0,-2.37696397749881E-15,null,null,null,0,0,0,-5.2966068963009993E-4,2.7975079526161605E-4,-4.6618105333773226E-4,0,2.37696397749881E-15]
[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.364087114457968E-2,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,-1.4999999999999999E-2,0.02,0.02,0.02,0.02,null,null,null,0,0,0,1.359128855420319E-3,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.7494628703819682E-3,-1.9626077784171171E-3,6.0198159470973081E-4,3.443536403884076E-4,-2.280191555055603E-3,3.0268688936922507E-3,2.3358349975623541E-4,null,null,null,-1.2197712686397161E-3,-3.7494628703819682E-3,-1.9626077784171171E-3,9.00756274167561E-4,-3.5192448630376461E-4,-2.3851676207406226E-3,3.1210936628631759E-3,2.1731317676444012E-4,null,null,null,0,0,0,-2.9877467945783019E-4,6.9627812669217221E-4,1.049760656850196E-4,-9.422476917092526E-5,1.6270322991795289E-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.13679750362423673,4.8997644490068631E-2,4.6245560503552219E-2,4.3073872253069176E-2,4.065583931990191E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.13805508644957556,3.9554523518016409E-2,4.0387638286589228E-2,4.6776767097927316E-2,3.9868873727292364E-2,null,0,0,0,0,0,1.2575828253388321E-3,9.4431209720522227E-3,5.8579222169629908E-3,-3.70289484485814E-3,7.8696559260954535E-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","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,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.1059999999999999E-2,1.9640000000000001E-2,1.856E-2,1.7739999999999999E-2,1.7129999999999999E-2,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.1059999999999999E-2,1.9640000000000001E-2,1.856E-2,1.7739999999999999E-2,1.7129999999999999E-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.19,0.19,0.19,0.19,0.19,0.19,null,0.2,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19,0.19,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,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.80185544098002037,0.59952383057623726,0,0,0,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0.80146350318811832,0.5980257351980196,0,0,0,null,0,0,0,0,0,3.919377919020528E-4,1.4980953782176565E-3,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,0,0,0,0,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,0,0,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,0,0,0,0,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,0,0,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,0,0,0,0,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,0,0,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,0.80185544098002037,0.59952383057623726,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,0.80146350318811832,0.5980257351980196,0,0,0,null,0,0,0,0,0,3.919377919020528E-4,1.4980953782176565E-3,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,0.80185544098002037,0.59952383057623726,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,0.80146350318811832,0.5980257351980196,0,0,0,null,0,0,0,0,0,3.919377919020528E-4,1.4980953782176565E-3,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,0,0,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,0,0,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,0,0,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,0,0,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,0,0,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,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]