{"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":[[122,21,122,22],[112,21,116,22],[1,3,1,22],[5,21,5,22],[151,3,151,4],[37,21,37,22],[38,21,38,22],[35,21,35,22],[30,21,30,22],[130,3,130,4],[36,21,36,22],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[93,21,93,22],[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],[23,21,23,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],[108,3,108,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,null,"Published:","2021-01-06T16:26:27.200","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.3806575756655506,1.4026712264365502,1.4275408206802833,1.4551097659011545,1.4841861170150621]
[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.2187315391552156E-2,1.2633376478261793E-2,1.5944323313032749E-2,1.7730166396093816E-2,1.9312193964256208E-2,1.9982239000300162E-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.2562684608447901E-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,309.98112351035115,301.87608901004222,308.39170266823038,309.71327445745555,308.10788548414837,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.80146350318811832,0.5980257351980196,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.9589154483450417,5.1480429087580584E-14,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,117.20905275161385,120.20348141083196,131.85004164976516,140.95353583481261,149.18156069429119,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,425.12109823417859,418.71868070772712,440.2417443179956,450.66681029226817,457.28944617843956]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8469685428862874,5.0995840493513773,0,0,0,null,"Included actual costs up to 19/20 forecast for 20/21"]
[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.49722860415533415,0.50444819075233938,0,0,0,null,"Included actual costs up to 19/20 forecast for 20/21"]
[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.0494044322511877,2.0791610726521519,0,0,0,null,"Included actual costs up to 19/20 forecast for 20/21"]
[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.1994795792928095,7.6785153127558683,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.1097949610582394,0.26855449998454795,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.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,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.3131810673023177,12.86297806920715,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3]
[]
[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.45668449927427157,0,0,0,null,"13/14 - 19/20 actual volume impact with forecast for 20/21"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.051569706762935,-8.8524826035156092,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255,null,"Actuals and f'cast compared against allowance with actual/fcast gas prices as at 23.12.20"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.3847008339728273,-8.5088124052307368,-8.3957981042413383,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255]
[]
[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,"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.2238675304449975,4.7181036278823498,5.6191179066990991,0,0,0,null,"13/14 - 19/20 actual volume impact with forecast for 20/21"]
[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,"Actual spend 13/14 - 19/20, 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,-11.375627003900552,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,415.30968778146041,439.71914107886602,439.00251064961577,449.15125590750546,455.61389036429239]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.47326733987069,415.30434995498268,439.69865244914195,439.00251064961589,449.15125590750654,455.61389036429358]
[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.5690141025547746,-5.3378264777279583E-3,-2.0488629724070506E-2,0,1.0800249583553523E-12,1.1937117960769683E-12]
[]
[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.6205039160994841E-2,5.8774100425632358E-2,-1.6297458134116871E-3,2.3117738536100996E-2,1.4388548115554567E-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.5655985088788845E-3,1.285264137767181E-5,4.6594809754701485E-5,0,-2.4045907567889864E-15,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.4999999999999998E-2,1.9999999999999997E-2,0.02,0.02,1.9999999999999997E-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.5639444136680611E-3,3.8911401944722347E-3,0.63597656527996171,1.1537391174104183E-2,3.5431007049303055E-3,3.2135357344099287E-3,8.469180091207236E-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.3517132257037225E-3,0.56833712462784569,9.0324344241114213E-2,2.195994970127332E-2,4.6331274270510925E-2,3.5235466124672883E-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,415.30968778146041,439.71914107886602,439.00251064961577,449.15125590750546,455.61389036429239]
[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,0.03,3.1199999999999999E-2,3.27E-2,3.4000000000000002E-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.1832,0.19040000000000001,0.1981,0.2074,0.2157]
[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.7699999999999995E-2,0.1016,0.1057,0.1106,0.115]
[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.8489185160179524E-2,2.8264301251349083E-2,2.3521365948969183E-2,2.4369907778357167E-2,2.3853933564181591E-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,7.4908933676467351,11.451281651984083,9.5296814142248643,9.8734681364014065,9.6644211835281713]
[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,415.3043499549828,439.69865244914178,439.00251064961577,449.15125590750546,455.61389036429239]
[]
[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,129.23869664454463,136.82996762506679,136.61333503053635,139.77152639031706,141.78263572296865]
[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.28810286565184,126.0896506399102,131.40085407548895,128.90726964751298,129.38853766646068,128.67895718940767]
[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,-5.0216398417149977E-3,-6.7991582636620862E-2,4.2122437556327386E-2,-1.8976927094731311E-2,3.7334435851732461E-3,-5.4841061646602185E-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,30.243594266757299,27.543945602259019,29.323799632908784,29.278103765626376,27.6802716063182]
[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,41.756047539753681,38.635099958822281,41.860920993426795,42.602854716430308,41.082674833303685]
[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.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,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,-1.2227206284500955E-2,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,34.320844305108622,51.229523528044879,41.854296257932589,42.60823305085384,41.081662677577619]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.3601303900000001,34.398867007049589,51.397436714956406,41.854296257932575,42.608233050853904,41.081662677577583]
[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.0422157530493941E-2,7.8022701940966499E-2,0.16791318691152668,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.0927257630624378,0.49266501350083103,-0.18300438154533982,1.8013366854265467E-2,-3.582806101004532E-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.1886938068299754E-2,-2.2733328250130751E-3,-3.2776644276147713E-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.4999999999999999E-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,7.1378149803132951E-3,1.4262139582427297E-2,-5.0428586348372235E-3,3.6217806678529342E-3,-3.2302165326690557E-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.0967505161110509,0.52465382025824525,-0.17132490460779182,4.1635147522118401E-2,-1.6151082663313727E-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,380.9888434763518,388.48961755082115,397.14821439168315,406.54302285665165,414.53222768671475]
[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.11313694987069,380.90548294793308,388.30121573418552,397.14821439168333,406.54302285665261,414.532227686716]
[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.5285919450242886,-8.3360528418722879E-2,-0.18840181663563271,0,9.6633812063373625E-13,1.2505552149377763E-12]
[]
[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.12745663489240056,1.9687647559514243E-2,2.2287846186080706E-2,2.365567343506414E-2,1.96515605505303E-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,3.5007921686574291E-3,2.188004448059307E-4,4.8495972124914383E-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.4999999999999999E-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,9.00756274167561E-4,-3.5192448630376461E-4,-2.3851676207406226E-3,3.1210936628631759E-3,2.1731317676444012E-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.13805508644957556,3.9554523518016409E-2,4.0387638286589228E-2,4.6776767097927316E-2,3.9868873727292364E-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.80146350318811832,0.5980257351980196,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.80146350318811832,0.5980257351980196,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.80146350318811832,0.5980257351980196,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":213,"n_cols":44,"rows_kept":213,"cut":false,"hidden":false,"merged":[[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],[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],[23,43,23,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,"SEPTEMBER 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,"RIIO-GD2 base allowances in row ref 5 represent final determination data plus an assumption within 21/22 that exit allowances will be updated to include the additional Revenue Recovery Charges.  This is being discussed with Ofgem currently."]
[]
[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.3806575756655506,1.4026712264365502,1.4275408206802833,1.4551097659011545,1.4841861170150621,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.3901230136800731,1.4193155969673545,1.4491212245036689,1.4795527702182458,1.5106233783928291,null,0,0,0,0,0,-9.465438014522487E-3,-1.6644370530804364E-2,-2.1580403823385552E-2,-2.4443004317091344E-2,-2.643726137776703E-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.2187315391552156E-2,1.2633376478261793E-2,1.5944323313032749E-2,1.7730166396093816E-2,1.9312193964256208E-2,1.9982239000300162E-2,null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.5249999999999986E-2,1.6499999999999959E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,0,0,0,0,-3.0626846084478299E-3,-3.8666235217381661E-3,-5.0556766869671588E-3,-3.2698336039060916E-3,-1.6878060357436997E-3,-1.0177609996997461E-3,null,"Updated to include Ofgem's PCFM published RPI and CPIH forecasts - as per model published on 14.12.2020"]
[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.2562684608447901E-2,"","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.8653631202754686E-3,-9.5000000000000709E-3,"","","","","",null,0,0,0,0,-3.0626846084478299E-3,"","","","",""]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,309.98112351035115,301.87608901004222,308.39170266823038,309.71327445745555,308.10788548414837,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,309.61376812050645,304.42623777283114,307.27169727546789,308.22250607396194,307.94714198628674,null,0,0,0,0,0,0.36735538984470395,-2.5501487627889219,1.1200053927624936,1.4907683834936165,0.16074349786163111,null,"movement between draft determination (plus NGN's estimate of known issues within) compared against final determinations"]
[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.80146350318811832,0.5980257351980196,0,0,0,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-0.54340997632090016,-0.76052299798448075,0,0,0,null,0,0,0,0,0,1.3448734795090185,1.3585487331825004,0,0,0,null,"Finalisation of 19/20 legacy adjustments (impacting 21/22) and forecast of 20/21 (impacting 22/23) - as per Ofgem model 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.9589154483450417,5.1480429087580584E-14,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-2.8705415309745583,-2.9480507042913726,0,0,0,null,0,0,0,0,0,0,-1.0108647440536691,5.1480429087580584E-14,0,0,null,"Drop in 20/21 RPI forecast as per Ofgem PCFM forecast - impacting 2 years later in 22/23"]
[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,117.20905275161385,120.20348141083196,131.85004164976516,140.95353583481261,149.18156069429119,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,119.4555952454316,126.09560682837326,138.0022409356788,147.80895663137852,157.24501000745397,null,0,0,0,0,0,-2.2465424938177421,-5.8921254175413083,-6.152199285913639,-6.8554207965659089,-8.0634493131627778,null,"This forecast uses the lower forecast for CPIH data as per Ofgem's published PCFM model on 14.12.20"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,425.12109823417859,418.71868070772712,440.2417443179956,450.66681029226817,457.28944617843956,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,425.65541185864259,426.81327089892858,445.27393821114669,456.03146270534046,465.19215199374071,null,0,0,0,0,0,-0.53431362446400499,-8.0945901912014619,-5.0321938931510886,-5.3646524130722923,-7.9027058153011467]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8469685428862874,5.0995840493513773,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8710963077618601,4.9749550417061235,0,0,0,null,0,0,0,0,0,-2.4127764875572666E-2,0.12462900764525386,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.49722860415533415,0.50444819075233938,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.49970376254440119,0.50713744215021195,0,0,0,null,0,0,0,0,0,-2.4751583890670337E-3,-2.6892513978725718E-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.0494044322511877,2.0791610726521519,0,0,0,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0596061795575293,2.0902452373365219,0,-1.3844074441713438E-15,1.4119656068098912E-15,null,0,0,0,0,0,-1.0201747306341602E-2,-1.1084164684370013E-2,0,1.3844074441713438E-15,-1.4119656068098912E-15]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.75767600000000002,0.89660300000000004,0.80587799999999998,-4.6779999999999999E-3,0,0,0,null,-0.15071466,0,0.78779600000000005,0.75767600000000002,0.89660300000000004,3.6997000000000002E-2,0,0,0,0,null,0,0,0,0,0,0.76888099999999993,-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.1994795792928095,7.6785153127558683,0,0,0,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.4084383983709365,8.2741136946406986,7.467403249863791,7.5723377211928575,0,-1.3844074441713438E-15,1.4119656068098912E-15,null,0,0,0,0,0,0.73207632942901846,0.10617759156301076,0,1.3844074441713438E-15,-1.4119656068098912E-15]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1097949610582394,0.26855449998454795,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1153194185915583,0.26268565671973415,0,0,0,null,0,0,0,0,0,-5.5244575333188717E-3,5.8688432648137945E-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.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,0,0,0,0,0,3.6950893884416303E-2,1.538909424684606,-2.521967632975539E-2,-7.7013267946168711E-3,-1.5726642147235643E-2,null,"We have assumed that the additional Revenue Recovery charges for Feb & Mar 2021 will be recovered 2 years later as these months sit within the RIIO-GD1 licence methodology"]
[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.3131810673023177,12.86297806920715,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3446075036534149,11.31819980125773,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,0,0,0,0,0,3.1426436351097209E-2,1.54477826794942,-2.521967632975539E-2,-7.7013267946168711E-3,-1.5726642147235643E-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.45668449927427157,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.54275730153219837,0.41414770531621964,0,0,0,null,0,0,0,0,2.4334481126668694E-2,0,4.2536793958051933E-2,0,0,0,null,"Updated for latest gas prices using forecast as at 23.12.2020 with cost compared against the new allowances"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.051569706762935,-8.8524826035156092,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0966275906149274,-9.2499956100009584,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142,null,0,0,0,0,0,4.5057883851992386E-2,0.39751300648534915,0.55777428202785528,6.5728711936622553E-2,-0.16724189122841127]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.3847008339728273,-8.5088124052307368,-8.3957981042413383,-1.2326089328856149,-1.5209327191862696,-1.6745436584211255,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.5538702890827292,-8.8358479046847389,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142,null,0,0,0,0,2.4334481126668805E-2,4.5057883851992386E-2,0.44004980044340058,0.55777428202785528,6.5728711936622553E-2,-0.16724189122841127]
[]
[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.4675512733413258,3.2354942485791733,0,0,0,null,0,0,0,0,0,1.0755431989273312E-3,1.5293813898598074E-4,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.6191179066990991,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.7181036278823498,5.6361202793471339,0,0,0,null,0,0,0,0,0.10177994049265049,0,-1.7002372648034836E-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.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.375627003900552,0,0,0,0,null,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.51996247371974869,-12.997642402839627,1.7541274662688486,5.9139537711416779E-14,0,5.9998828557764462E-14,null,0,0,0,0,0,1.6220153989390749,-1.7541274662688486,-5.9139537711416779E-14,0,-5.9998828557764462E-14,null,"GD2 principles now assume a 1 year lag for under/over collection issues - so the under collection from 20/21 is now being added into 21/22 revenues not 2 years after in 22/23 as per previous"]
[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.93806577216412,440.04228144242546,415.30968778146041,439.71914107886602,439.00251064961577,449.15125590750546,455.61389036429239,null,411.27572761540614,409.2076390972685,409.39349411865396,436.93806577216412,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922,null,0,0,0,0,0.12611442161932018,1.8973379673062141,-7.7745614320236314,-4.4996392874530784,-5.3066250279302949,-8.0856743486768323]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.47326733987069,415.30434995498268,439.69865244914195,439.00251064961589,449.15125590750654,455.61389036429358,null,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.21935777099588,413.41234981415425,447.49370251088965,443.50214993706874,454.45788093543564,463.69956471296928,null,0,0,0,0,0.25390956887480343,1.8920001408284293,-7.7950500617477019,-4.499639287452851,-5.3066250279291012,-8.0856743486756955]
[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.5690141025547746,-5.3378264777279583E-3,-2.0488629724070506E-2,0,1.0800249583553523E-12,1.1937117960769683E-12,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.515611227835848,-1.6968092498102578,0,0,0,0,0,null,0,0,0,0,0.12779514725548324,-5.3378264777279583E-3,-2.0488629724070506E-2,0,1.0800249583553523E-12,1.1937117960769683E-12]
[]
[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.6205039160994841E-2,5.8774100425632358E-2,-1.6297458134116871E-3,2.3117738536100996E-2,1.4388548115554567E-2,null,null,null,4.5418267800534373E-4,6.7281410303816402E-2,6.8158429808102827E-3,-6.0247427108989227E-2,8.2439125759200094E-2,-8.9197960807586574E-3,2.4702768633526384E-2,2.0335622211041349E-2,null,null,null,0,0,2.8863226049313795E-4,4.0423879479943858E-3,-2.3665025333567735E-2,7.2900502673469703E-3,-1.5850300974253884E-3,-5.9470740954867818E-3]
[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.5655985088788845E-3,1.285264137767181E-5,4.6594809754701485E-5,0,-2.4045907567889864E-15,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.8643902210071934E-2,3.8571195537126192E-3,0,0,0,0,null,null,null,0,0,0,-2.915210448337347E-4,1.285264137767181E-5,4.6594809754701485E-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.4999999999999998E-2,1.9999999999999997E-2,0.02,0.02,1.9999999999999997E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999998E-2,1.8999999999999996E-2,1.9000000000000003E-2,1.8999999999999996E-2,1.9E-2,1.9E-2,1.8999999999999996E-2,null,null,null,0,0,0,-3.4000000000000002E-2,1.0000000000000009E-3,1.0000000000000009E-3,1.0000000000000009E-3,1.0000000000000009E-3]
[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.8911401944722347E-3,0.63597656527996171,1.1537391174104183E-2,3.5431007049303055E-3,3.2135357344099287E-3,8.469180091207236E-4,null,null,null,-1.0769815857443812E-3,-3.5639444136680611E-3,4.1790466456852055E-3,0.49675751046103755,2.0179083742521219E-2,2.039452349524188E-3,4.0998978975639137E-3,1.9256839787452767E-3,null,null,null,0,0,-2.8790645121297073E-4,0.13921905481892416,-8.6416925684170351E-3,1.5036483554061175E-3,-8.8636216315398503E-4,-1.0787659696245532E-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.7933671242228719E-2,1.3517132257037225E-3,0.56833712462784569,9.0324344241114213E-2,2.195994970127332E-2,4.6331274270510925E-2,3.5235466124672883E-2,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933671242228719E-2,1.3509874164235479E-3,0.459367202905761,0.12161820950172131,1.211965626876553E-2,4.7802666531090297E-2,4.1261306189786622E-2,null,0,0,0,0,7.2580928017458926E-7,0.10896992172208469,-3.1293865260607096E-2,9.84029343250779E-3,-1.4713922605793725E-3,-6.0258400651137384E-3]
[]
[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.93806577216412,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340114,1345753,1348708,1351865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160912,1162830,1164484]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,2511538,2516349,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","bopri 28/04/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,19059743380,19384528503,19306905769]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15841637342,15989045667,15920353696]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34901380722,35373574170,35227259465,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,14281.681801807134,"","","","","",""]
[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,13671.595054977141,"","","","","",""]
[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,13999.353613111694,"","","","","",""]
[]
[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,0.33550000000000002]
[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,0.35624999999999996]
[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,0.34510242120627938,"","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,114,116,117,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,109,105,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,113,111,"","","","","",""]
[]
[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.0099999999999998E-2,3.1800000000000002E-2,3.2599999999999997E-2,3.4200000000000001E-2,3.5799999999999998E-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.19070000000000001,0.2016,0.2069,0.21690000000000001,0.22689999999999999]
[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.1018,0.1076,0.1105,0.1158,0.1212]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5962241668363879E-3,1.56783481731635E-3,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[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,4.6617847531661951,"","","","","",""]
[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,85.608194999999995,"","","","","",""]
[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,45.700919999999996,"","","","","",""]
[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,135.97089975316618,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,null,null,1.4570102211937626,0.63520827623571918,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[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.93806577216412,439.91616702080614,413.41234981415431,447.49370251088965,443.50214993706879,454.4578809354357,463.69956471296922]
[]
[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,129.23869664454463,136.82996762506679,136.61333503053635,139.77152639031706,141.78263572296865,null,129.79446543550341,128.96027434682577,128.45829301082443,135.97089975316618,136.89765605584324,128.64992450122739,139.2557118060956,138.01357925370431,141.42289677029342,144.29881937100524,null,0,0,0,0,3.9245588157058364E-2,0.58877214331724304,-2.4257441810288185,-1.4002442231679595,-1.6513703799763562,-2.5161836480365878]
[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.28810286565184,126.0896506399102,131.40085407548895,128.90726964751298,129.38853766646068,128.67895718940767,null,138.7659011533307,132.90073803295147,128.45829301082443,135.97089975316618,134.84132583683157,124.66058326335231,132.16208889737021,128.28915770303482,128.75441242307824,128.67063027631596,null,3.5919049626417063,3.4400873450303493,3.3250962687744448,0,0.44677702882026438,1.4290673765578958,-0.7612348218812599,0.61811194447815865,0.63412524338244225,8.3269130917074108E-3]
[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,-5.0216398417149977E-3,-6.7991582636620862E-2,4.2122437556327386E-2,-1.8976927094731311E-2,3.7334435851732461E-3,-5.4841061646602185E-3,null,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.1775707822196297E-2,-8.3074681302041098E-3,-7.5501649885872157E-2,6.017544148795273E-2,-2.9304403605052709E-2,3.6266098271562353E-3,-6.5071281974382611E-4,null,-2.2204460492503131E-16,0,-1.1102230246251565E-16,0,3.2858282884891121E-3,7.5100672492512954E-3,-1.8053003931625344E-2,1.0327476510321398E-2,1.0683375801701089E-4,-4.8333933449163924E-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,30.243594266757299,27.543945602259019,29.323799632908784,29.278103765626376,27.6802716063182,null,8.77,8.77,8.77,8.77,8.77,27.10054479298779,27.533051904381232,29.311962506482811,29.266829728291906,27.669519483055829,null,0,0,0,0,0,3.1430494737695085,1.0893697877786934E-2,1.1837126425973565E-2,1.1274037334469966E-2,1.0752123262371072E-2]
[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,41.756047539753681,38.635099958822281,41.860920993426795,42.602854716430308,41.082674833303685,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,37.673090999999999,39.078090000000003,42.476587000000002,43.301819000000002,41.798223,null,0,0,0,0,0,4.0829565397536811,-0.44299004117772256,-0.61566600657320691,-0.69896428356969409,-0.71554816669631549]
[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.4229760283605568,12.594423569222602,-6.6247354942058244E-3,5.3783344235348246E-3,-1.0121557260660992E-3,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,0,0,0,0,0,3.6950893884416303E-2,1.538909424684606,-2.521967632975539E-2,-7.7013267946168711E-3,-1.5726642147235643E-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,-1.2227206284500955E-2,0,0,0,0,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4946647446030926E-2,-5.4014824296374067E-2,4.2206728764267218E-2,3.6962211069635487E-15,1.490614743720272E-14,1.4999707139441116E-14,null,0,0,0,0,0,4.1787618011873112E-2,-4.2206728764267218E-2,-3.6962211069635487E-15,-1.490614743720272E-14,-1.4999707139441116E-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,34.320844305108622,51.229523528044879,41.854296257932589,42.60823305085384,41.081662677577619,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005525475304941,30.159149253458651,50.175810873302268,42.495181940835558,43.314898661218166,41.812937486421184,null,0,0,0,0,0,4.1616950516499713,1.0537126547426112,-0.64088568290296877,-0.7066656103643254,-0.73127480884356544]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.3601303900000001,34.398867007049589,51.397436714956406,41.854296257932575,42.608233050853904,41.081662677577583,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.359724974193548,30.159149253458647,50.175810873302254,42.495181940835543,43.314898661218166,41.812937486421148,null,0,0,0,0,4.0541580645214736E-4,4.2397177535909414,1.2216258416541521,-0.64088568290296877,-0.70666561036426145,-0.73127480884356544]
[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.0422157530493941E-2,7.8022701940966499E-2,0.16791318691152668,0,6.3948846218409017E-14,0,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.2011627992288645E-2,-4.0827573336946088E-2,0,0,0,0,0,null,0,0,0,0,4.0541580645214736E-4,7.8022701940966499E-2,0.16791318691152668,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.0927257630624378,0.49266501350083103,-0.18300438154533982,1.8013366854265467E-2,-3.582806101004532E-2,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930521632200892,7.8688966960267805,0.66370113598440139,-0.15307433599550357,1.9289639035405592E-2,-3.467539394572694E-2,null,null,null,0,0,0,1.2238290670356573,-0.17103612248357036,-2.9930045549836248E-2,-1.2762721811401256E-3,-1.1526670643183801E-3]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5874991060340385E-3,1.1886938068299754E-2,-2.2733328250130751E-3,-3.2776644276147713E-3,0,-1.5008565631455475E-15,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5874991060340385E-3,1.2006158636364955E-2,0,0,0,0,null,null,null,0,0,0,-1.1922056806520052E-4,-2.2733328250130751E-3,-3.2776644276147713E-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.4999999999999999E-2,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,0,0,0,-3.5000000000000003E-2,0,0,0,0,null,"SOQ assumption change is draft and will be finalised for 60 day notice"]
[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,7.1378149803132951E-3,1.4262139582427297E-2,-5.0428586348372235E-3,3.6217806678529342E-3,-3.2302165326690557E-4,null,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7430088093823996E-3,0.25994269841918832,1.3953084407844946E-2,-5.0770319044595828E-3,3.6513950349286069E-3,-2.9949783562804519E-4,null,null,null,0,0,0,-0.25280488343887503,3.090551745823511E-4,3.4173269622359351E-5,-2.9614367075672665E-5,-2.3523817638860384E-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.0967505161110509,0.52465382025824525,-0.17132490460779182,4.1635147522118401E-2,-1.6151082663313727E-2,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,8.1608455530823338,0.69765422039224634,-0.13815136789996316,4.29410340703342E-2,-1.4974891781354983E-2,null,0,0,0,0,0,0.93590496302871706,-0.17300040013400109,-3.317353670782866E-2,-1.3058865482157983E-3,-1.1761908819587445E-3]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.87150072575594,402.51128113785808,401.51958066989596,402.30309265804107,429.04256140015639,436.64172889489498,380.9888434763518,388.48961755082115,397.14821439168315,406.54302285665165,414.53222768671475,null,402.51128113785808,401.51958066989596,402.30309265804107,429.04256140015639,436.51561447327566,383.25320056069552,397.31789163758737,401.0069679962333,411.14298227421762,421.88662722654806,null,0,0,0,0,0.12611442161932018,-2.2643570843437146,-8.8282740867662142,-3.8587536045501452,-4.5999594175659695,-7.3543995398333095]
[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.11313694987069,380.90548294793308,388.30121573418552,397.14821439168333,406.54302285665261,414.532227686716,null,412.11372795000005,402.67729251000003,401.73341855999996,441.50616099999996,434.85963279680232,383.25320056069563,397.31789163758742,401.00696799623319,411.1429822742175,421.88662722654811,null,0,0,0,0,0.25350415306837704,-2.3477176127625512,-9.0166759034019037,-3.8587536045498609,-4.5999594175648895,-7.3543995398321158]
[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.5285919450242886,-8.3360528418722879E-2,-0.18840181663563271,0,9.6633812063373625E-13,1.2505552149377763E-12,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.463599599843576,-1.6559816764733455,0,0,0,0,0,null,0,0,0,0,0.12738973144905685,-8.3360528418722879E-2,-0.18840181663563271,0,9.6633812063373625E-13,1.2505552149377763E-12]
[]
[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.12745663489240056,1.9687647559514243E-2,2.2287846186080706E-2,2.365567343506414E-2,1.96515605505303E-2,null,null,null,1.9513668221058378E-3,6.6465978587054941E-2,1.7417976083145215E-2,-0.12201720201200494,3.6698169920865276E-2,9.2849489949748953E-3,2.5276404369311445E-2,2.6131164620401659E-2,null,null,null,0,0,2.939438483859913E-4,-5.4394328803956116E-3,-1.7010522361351033E-2,1.3002897191105811E-2,-1.6207309342473053E-3,-6.4796040698713586E-3]
[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,3.5007921686574291E-3,2.188004448059307E-4,4.8495972124914383E-4,0,-2.37696397749881E-15,null,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.9049797668486119E-2,3.7936367487599412E-3,0,0,0,0,null,null,null,0,0,0,-2.9284458010251204E-4,2.188004448059307E-4,4.8495972124914383E-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.4999999999999999E-2,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,0,0,0,-3.5000000000000003E-2,0,0,0,0,null,"SOQ assumption change is draft and will be finalised for 60 day notice"]
[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,9.00756274167561E-4,-3.5192448630376461E-4,-2.3851676207406226E-3,3.1210936628631759E-3,2.1731317676444012E-4,null,null,null,-1.2197712686397161E-3,-3.7494628703819682E-3,-1.6686639300311258E-3,-4.2454593642802449E-3,3.3125592540085222E-4,-2.7667277736111821E-3,2.989629893310513E-3,2.0109873471435211E-4,null,null,null,0,0,-2.939438483859913E-4,5.1462156384478059E-3,-6.8318041170461682E-4,3.815601528705595E-4,1.3146376955266298E-4,1.6214442050088013E-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.13805508644957556,3.9554523518016409E-2,4.0387638286589228E-2,4.6776767097927316E-2,3.9868873727292364E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10246902462752525,5.7029425846266128E-2,2.6518221221363714E-2,4.8266034262621958E-2,4.6332263355116012E-2,null,0,0,0,0,0,-3.5586061822050319E-2,-1.747490232824972E-2,1.3869417065225514E-2,-1.4892671646946423E-3,-6.4633896278236472E-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.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,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,0,0,0,0,0,1.3299999999999979E-3,1.3400000000000009E-3,1.3899999999999989E-3,1.4499999999999999E-3,1.5300000000000001E-3]
[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.17,0.19,0.19,0.19,0.19,0.19,null,0,0,0,0,1.999999999999999E-2,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,null,null,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,null,null,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,null,null,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,null,null,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.80146350318811832,0.5980257351980196,0,0,0,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,-0.54340997632089993,-0.75033398329804868,0,0,0,null,0,0,0,0,0,1.3448734795090183,1.3483597184960683,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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.80146350318811832,0.5980257351980196,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-0.54340997632089993,-0.76052299798448075,0,0,0,null,0,0,0,0,0,1.3448734795090183,1.3585487331825004,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.80146350318811832,0.5980257351980196,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-0.54340997632089993,-0.76052299798448075,0,0,0,null,0,0,0,0,0,1.3448734795090183,1.3585487331825004,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0,null,null,null,null,-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]

{"sheet":"High level mod186 rec","index":4,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":true,"merged":[[37,1,37,2],[19,1,19,2]]}
[]
[null,"MOD186 Reconciliation - Sep 2020 to Jan 2021"]
[]
[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,"SEPTEMBER",null,411.27572761540614,409.2076390972685,409.39349411865396,436.93806577216412,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922]
[]
[null,"Movement to FD data","09/10",null,null,null,null,null,-2.7648808182603641,-2.5501487627889219,1.1200053927624936,1.4907683834936165,0.16074349786163111]
[null,"Add : additional Exit RRC proposed","09/10",null,null,null,null,null,3.1322362081050681]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   September",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2]
[null,"Cost of debt %   January",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,"Cost of debt £ movement",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Close out of GD1 adjustments","09/10",0,0,0,0,0,1.3448734795090185,1.3585487331825004,0,0,0]
[]
[null,"Pension deficit valuation",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Tax trigger (2% shortfall in CT in allowances for 20/21)",null,0,0,0,0,0]
[]
[null,"Repex Tier 2a (19/20 actuals and new forecast for 20/21)",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,1.3448734795090185,1.3585487331825004,0,0,0]
[]
[null,"Change in Inflation %",null,null,null,null,null,"RPI","CPIH","CPIH","CPIH","CPIH","CPIH"]
[null,"September (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.5249999999999986E-2,1.6499999999999959E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2]
[null,"January (Based on Ofgem GD2 Dec 20 PCFM)",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,"Difference",null,0,0,0,0,-3.0626846084478299E-3,-3.8666235217381661E-3,-5.0556766869671588E-3,-3.2698336039060916E-3,-1.6878060357436997E-3,-1.0177609996997461E-3]
[null,"Cumulative change in inflation",null,0,0,0,0,-3.0626846084478299E-3,-6.929308130185996E-3,-1.1984984817153155E-2,-1.5254818421059246E-2,-1.6942624456802946E-2,-1.7960385456502692E-2]
[]
[null,"£ impact on change in inflation (incl. changes above)",null,0,0,0,0,0,-2.2465424938177274,-5.8921254175413722,-6.1521992859136336,-6.8554207965659089,-8.0634493131627778]
[]
[null,"£ Impact of changes in RPI on RPI true up from 20/21",null,0,0,0,0,0,0,-1.0108647440536691,5.1480429087580584E-14,0,0]
[]
[null,"Total base revenue changes",null,0,0,0,0,0,-0.53431362446400499,-8.0945901912014619,-5.0321938931510886,-5.3646524130722923,-7.9027058153011467]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,0,1.0755431989273312E-3,1.5293813898598074E-4,0,0,0]
[null,"Shrinkage/Leakage",null,0,0,0,0,0.12611442161931918,0,2.5534421310017097E-2,0,0,0]
[null,"DRS",null,0,0,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,0,-5.5244575333188717E-3,5.8688432648137945E-3,0,0,0]
[null,"Total",null,0,0,0,0,0.12611442161931918,-4.4489143343915405E-3,3.1556202713816872E-2,0,0,0]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,0,-2.4127764875572666E-2,0.12462900764525386,0,0,0]
[null,"License Fee",null,0,0,0,0,0,-2.4751583890670337E-3,-2.6892513978725718E-3,0,0,0]
[null,"Pension Deficit",null,0,0,0,0,0,-1.0201747306341602E-2,-1.1084164684370013E-2,0,1.3844074441713438E-15,-1.4119656068098912E-15]
[null,"Exit Capacity",null,0,0,0,0,0,3.6950893884416303E-2,1.538909424684606,-2.521967632975539E-2,-7.7013267946168711E-3,-1.5726642147235643E-2]
[null,"Shrinkage pass thru",null,0,0,0,0,0,4.5057883851992386E-2,0.39751300648534915,0.55777428202785528,6.5728711936622553E-2,-0.16724189122841127]
[null,"SOLR (Cardiff Energy, Solarplicity & SP Extra Energy)",null,null,null,null,null,0,0.76888099999999993,-4.6779999999999999E-3,0,0,0]
[null,"Total",null,0,0,0,0,0,0.81408510716542737,2.0426000227329664,0.53255460569809987,5.8027385142007067E-2,-0.18296853337564833]
[]
[null,"Network Innovation",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"K factor",null,0,0,0,0,0,1.6220153989390749,-1.7541274662688486,-5.9139537711416779E-14,0,-5.9998828557764462E-14]
[]
[null,"JANUARY",null,411.27572761540614,409.2076390972685,409.39349411865396,436.93806577216412,440.04228144242546,415.30968778146041,439.71914107886602,439.00251064961577,449.15125590750546,455.61389036429239]
[null,"Difference",null,0,0,0,0,0.12611442161932018,1.8973379673062141,-7.7745614320236314,-4.4996392874530784,-5.3066250279302949,-8.0856743486768323]
[]
[null,"Memo:"]
[null,"In year (under)/over collection",null,null,null,-0.49790655865399458,12.515611227835848,-1.5690141025547746]
[null,"SOQ Assumption SEPTEMBER",null,null,null,null,-1.8999999999999996E-2,null,-0.02,-0.02,-0.02,-0.02,-0.02]
[null,"SOQ Assumption JANUARY(DRAFT 21/22 assumption)",null,null,null,null,-1.9E-2,null,1.4999999999999999E-2,-0.02,-0.02,-0.02,-0.02]
[null,"Change",null,null,null,null,null,null,3.5000000000000003E-2,0,0,0,0]
[]
[null,"LDZ Price Change","September",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10246902462752525,5.7029425846266128E-2,2.6518221221363714E-2,4.8266034262621958E-2,4.6332263355116012E-2]
[null,"LDZ Price Change","January",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.13805508644957556,3.9554523518016409E-2,4.0387638286589228E-2,4.6776767097927316E-2,3.9868873727292364E-2]
[null,"LDZ Price Change %","Difference",0,0,0,0,0,-3.5586061822050319E-2,-1.747490232824972E-2,1.3869417065225514E-2,-1.4892671646946423E-3,-6.4633896278236472E-3]