{"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":[[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[108,3,108,4],[27,21,27,22],[31,21,31,22],[34,21,34,22],[6,21,8,22],[14,21,14,22],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,21,18,22],[20,21,20,22],[21,21,21,22],[22,21,22,22],[26,21,26,22],[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]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,null,"Published:","2020-09-10T15:56:57.100","RIIO-GD2"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* GD2 data reflects 1. draft determination data plus 2. an update to reflect the latest NTS unit rates for Mod678 plus 3. an expectation of increased repex workload allowances."]
[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.3901230136800731,1.4193155969673545,1.4491212245036689,1.4795527702182458,1.5106233783928291]
[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.5249999999999986E-2,1.6499999999999959E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,"As per Aug 2020 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.8653631202754686E-3,-9.5000000000000709E-3,"","","","","",null,"Difference between forecast and actual drives true up in 2 years time"]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,309.61376812050645,304.42623777283114,307.27169727546789,308.22250607396194,307.94714198628674,null,"GD2 yrs as per draft 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.54340997632090016,-0.76052299798448075,0,0,0,null,"Actual Modt up to 20/21, forecast thereafter"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-2.8705415309745583,-2.9480507042913726,0,0,0,null,"Latest RPI inflation impact on the true up mechanism"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,119.4555952454316,126.09560682837326,138.0022409356788,147.80895663137852,157.24501000745397,null,"Assumed CPI for GD2 years"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,425.65541185864259,426.81327089892858,445.27393821114669,456.03146270534046,465.19215199374071]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8710963077618601,4.9749550417061235,0,0,0,null,"Included actual costs up to 19/20 forecast thereafter"]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.49970376254440119,0.50713744215021195,0,0,0,null,"Included actual costs up to 19/20 forecast thereafter"]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0596061795575293,2.0902452373365219,0,-1.3844074441713438E-15,1.4119656068098912E-15,null,"Included actual costs up to 19/20 forecast thereafter"]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.75767600000000002,0.89660300000000004,3.6997000000000002E-2,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.4084383983709365,8.2741136946406986,7.467403249863791,7.5723377211928575,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.1153194185915583,0.26268565671973415,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.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,"Inclusive of latest set of indicative prices (with mod 678 data) applied to our latest bookings"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3446075036534149,11.31819980125773,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.54275730153219837,0.41414770531621964,0,0,0,null,"13/14 - 19/20 actual volume impact with forecast thereafter"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0966275906149274,-9.2499956100009584,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142,null,"Actuals and f'cast compared against allowance with actual/fcast gas prices as at 28.08.20"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.5538702890827292,-8.8358479046847389,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142]
[]
[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.4675512733413258,3.2354942485791733,0,0,0,null,"Assumes customer service scores and stakeholder results will continue at GD1 average rate"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.2733541247035971,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.7181036278823498,5.6361202793471339,0,0,0,null,"13/14 - 19/20 actual volume impact with forecast thereafter"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,0,0,0,0,0,null,"DRS from 11/12, 12/13,14/15/17/18"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.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,-12.997642402839627,1.7541274662688486,5.9139537711416779E-14,0,5.9998828557764462E-14]
[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,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.21935777099588,413.41234981415425,447.49370251088965,443.50214993706874,454.45788093543564,463.69956471296928]
[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.6968092498102578,0,0,0,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,4.5418267800534373E-4,6.7281410303816402E-2,6.8158429808102827E-3,-6.0247427108989227E-2,8.2439125759200094E-2,-8.9197960807586574E-3,2.4702768633526384E-2,2.0335622211041349E-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.8571195537126192E-3,0,0,0,0,null,"Movement year on year in row reference 28"]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,null,null,null,null,null,-1.0613176358943877E-2,1.2999999999999998E-2,1.8999999999999996E-2,1.9000000000000003E-2,1.8999999999999996E-2,1.9E-2,1.9E-2,1.8999999999999996E-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,4.1790466456852055E-3,0.49675751046103755,2.0179083742521219E-2,2.039452349524188E-3,4.0998978975639137E-3,1.9256839787452767E-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.3509874164235479E-3,0.459367202905761,0.12161820950172131,1.211965626876553E-2,4.7802666531090297E-2,4.1261306189786622E-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,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922]
[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,3.0099999999999998E-2,3.1800000000000002E-2,3.2599999999999997E-2,3.4200000000000001E-2,3.5799999999999998E-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.19070000000000001,0.2016,0.2069,0.21690000000000001,0.22689999999999999]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1128,0.1134,0.1018,0.1076,0.1105,0.1158,0.1212]
[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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[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,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.4080416156043,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,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.89765605584324,128.64992450122739,139.2557118060956,138.01357925370431,141.42289677029342,144.29881937100524]
[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,134.84132583683157,124.66058326335231,132.16208889737021,128.28915770303482,128.75441242307824,128.67063027631596]
[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,-8.3074681302041098E-3,-7.5501649885872157E-2,6.017544148795273E-2,-2.9304403605052709E-2,3.6266098271562353E-3,-6.5071281974382611E-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,27.10054479298779,27.533051904381232,29.311962506482811,29.266829728291906,27.669519483055829]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,37.673090999999999,39.078090000000003,42.476587000000002,43.301819000000002,41.798223]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,"Inclusive of latest set of indicative prices (with mod 678 data) applied to our latest bookings"]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4946647446030926E-2,-5.4014824296374067E-2,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,30.159149253458651,50.175810873302268,42.495181940835558,43.314898661218166,41.812937486421184]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.359724974193548,30.159149253458647,50.175810873302254,42.495181940835543,43.314898661218166,41.812937486421148]
[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.0827573336946088E-2,0,0,0,0,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930521632200892,7.8688966960267805,0.66370113598440139,-0.15307433599550357,1.9289639035405592E-2,-3.467539394572694E-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.2006158636364955E-2,0,0,0,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7430088093823996E-3,0.26094269841918832,1.4953084407844947E-2,-4.0770319044595819E-3,4.6513950349286078E-3,7.005021643719557E-4]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,8.1608455530823338,0.69765422039224634,-0.13815136789996316,4.29410340703342E-2,-1.4974891781354983E-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.51561447327566,383.25320056069552,397.31789163758737,401.0069679962333,411.14298227421762,421.88662722654806]
[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,434.85963279680232,383.25320056069563,397.31789163758742,401.00696799623319,411.1429822742175,421.88662722654811]
[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.6559816764733455,0,0,0,0,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6465978587054941E-2,1.7417976083145215E-2,-0.12201720201200494,3.6698169920865276E-2,9.2849489949748953E-3,2.5276404369311445E-2,2.6131164620401659E-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.7936367487599412E-3,0,0,0,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.2197712686397161E-3,-3.7494628703819682E-3,-1.6686639300311258E-3,-3.245459364280244E-3,1.3312559254008531E-3,-1.7667277736111812E-3,3.9896298933105138E-3,1.201098734714353E-3]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10246902462752525,5.7029425846266128E-2,2.6518221221363714E-2,4.8266034262621958E-2,4.6332263355116012E-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,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,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.17,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,0,0,0,0,0]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973,2.1174945914410848,0,0,0,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE"]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE"]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,2.1174945914410848,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,null,17.398062412967949]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR"]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-2.2628547598110789,-0.75033398329804868,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,0,0,0,0,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.39804980795090589,-1.0189014686432074E-2,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.39804980795090589,-1.0189014686432074E-2,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.54340997632089993,-0.76052299798448075,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.54340997632089993,-0.76052299798448075,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":163,"n_cols":44,"rows_kept":163,"cut":false,"hidden":false,"merged":[[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],[148,3,148,4],[150,3,150,4],[151,3,151,4],[153,3,153,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[115,3,115,4],[116,3,116,4],[118,3,118,4],[130,3,130,4],[135,3,135,4],[136,3,136,4],[108,3,108,4],[109,3,109,4],[95,3,95,4],[97,3,97,4],[98,3,98,4],[89,3,89,4],[114,3,114,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[110,3,110,4],[112,3,112,4],[113,3,113,4]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,null,null,null,null,"JUNE MOD186",null,null,null,null,null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,"* GD2 data reflects 1. draft determination data plus 2. an update to reflect the latest NTS unit rates for Mod678 plus 3. an expectation of increased repex workload allowances."]
[]
[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.3901230136800731,1.4193155969673545,1.4491212245036689,1.4795527702182458,1.5106233783928291,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3798374174698094,1.3901218350408078,1.4141014366952618,1.4395552625557768,1.4654672572817808,1.4918456679128527,null,0,0,0,0,0,1.1786392652979316E-6,5.2141602720927605E-3,9.5659619478920543E-3,1.4085512936464983E-2,1.877771047997645E-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.5249999999999986E-2,1.6499999999999959E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6999999999999904E-2,1.4750000000000041E-2,1.7249999999999988E-2,1.8000000000000016E-2,1.8000000000000016E-2,1.8000000000000016E-2,null,0,0,0,0,-1.7499999999999183E-3,1.7499999999999183E-3,3.7499999999999201E-3,2.9999999999998916E-3,2.9999999999998916E-3,2.9999999999998916E-3,null,"Difference between May and August HM Treasury forecast"]
[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,-9.5000000000000709E-3,"","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.8653631202754686E-3,-7.7500000000001526E-3,"","","","","",null,0,0,0,0,-1.7499999999999183E-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.61376812050645,304.42623777283114,307.27169727546789,308.22250607396194,307.94714198628674,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,311.3642446068738,309.19672494112058,312.61289223175504,314.45458426797063,316.09383170869296,null,0,0,0,0,0,-1.7504764863673472,-4.770487168289435,-5.3411949562871541,-6.2320781940086931,-8.1466897224062222,null,"Movement between our business plan submission for GD2 and draft determination data *"]
[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.54340997632090016,-0.76052299798448075,0,0,0,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0.57293180480128081,0.35581878313770021,0,0,0,null,"Updated totex actuals for 19/20 and a new forecast for 20/21, and impact of tax trigger for 2% shortfall in corporation tax for 20/21 allowances"]
[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,-2.9480507042913726,0,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,-2.869525188304265,-2.3948897526282664,5.1602891017584946E-14,0,0,null,0,0,0,0,0,-1.0163426702933798E-3,-0.55316095166310619,-5.1602891017584946E-14,0,0,null,"Impact of latest position of RPI in 20/21"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,119.4555952454316,126.09560682837326,138.0022409356788,147.80895663137852,157.24501000745397,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,119.02175022802857,119.91501673578739,126.58480199689194,137.4106419232499,146.36831287889493,155.46938177989495,null,0,0,0,0,0,-0.45942149035579405,-0.48919516851867684,0.59159901242890101,1.4406437524835951,1.7756282275590252]
[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.65541185864259,426.81327089892858,445.27393821114669,456.03146270534046,465.19215199374071,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,432.37094847411436,427.29339437323478,432.27029540426207,450.023534155005,460.82289714686556,471.56321348858791,null,0,0,0,0,0,-1.6379825145921814,-5.4570245053334929,-4.74959594385831,-4.791434441525098,-6.3710614948471971]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8710963077618601,4.9749550417061235,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0313186513231587,4.8693675209693668,4.9052520008783711,0,0,0,null,0,0,0,0,0,1.7287867924933309E-3,6.9703040827752361E-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.49970376254440119,0.50713744215021195,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34205340092273911,0.49952641411803794,0.50886290311255267,0,0,0,null,0,0,0,0,0,1.773484263632441E-4,-1.7254609623407191E-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.0596061795575293,2.0902452373365219,0,-1.3844074441713438E-15,1.4119656068098912E-15,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0041386423948007,2.0588752106470438,2.0973569909933842,0,0,0,null,0,0,0,0,0,7.3096891048551882E-4,-7.1117536568623407E-3,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,3.6997000000000002E-2,0,0,0,0,null,-0.15071466,0,0.78779600000000005,0.736896,0.89660300000000004,3.6997000000000002E-2,0,0,0,0,null,0,0,0,2.0780000000000021E-2,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,7.467403249863791,7.5723377211928575,0,-1.3844074441713438E-15,1.4119656068098912E-15,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,8.2741136946406986,7.4647661457344485,7.5114718949843073,0,0,0,null,0,0,0,2.0780000000000243E-2,0,2.6371041293424824E-3,6.0865826208550189E-2,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.1153194185915583,0.26268565671973415,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9757391695603079,1.1149235837818054,0.26471647735110676,0,0,0,null,0,0,0,0,0,3.9583480975280416E-4,-2.0308206313726096E-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.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,0,0,0,0,0,-2.6475812263431209E-3,1.5250588947584021E-2,2.2023336339821366E-2,1.0961361033997842E-2,1.0931665592659382E-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.3446075036534149,11.31819980125773,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.6499357866733941,-6.3423557572368248,11.304980032941518,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,0,0,0,0,0,-2.2517464165900947E-3,1.3219768316211855E-2,2.2023336339821366E-2,1.0961361033997842E-2,1.0931665592659382E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.74203371031620247,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.54275730153219837,0.41414770531621964,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,0.49351973243326808,0.35479809753594377,0,0,0,null,0,0,0,0,0,4.9237569098930289E-2,5.934960778027587E-2,0,0,0,null,"Long range gas prices have increased by c.9% from June, so the give back compared to the GD2 allowance has reduced"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0966275906149274,-9.2499956100009584,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.3945818007295818,-9.0805068887959308,-10.103738791231109,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633,null,0,0,0,0,0,-1.6120701818996608E-2,0.85374318123015058,0.63259836307375461,0.39778349776310051,0.28955545042114905]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.5538702890827292,-8.8358479046847389,-1.7903832149134702,-1.5866614311228922,-1.5073017671927142,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4090353150994961,-8.5869871563626621,-9.7489406936951646,-2.4229815779872248,-1.9844449288859927,-1.7968572176138633,null,0,0,0,0,0,3.3116867279932904E-2,0.91309278901042568,0.63259836307375461,0.39778349776310051,0.28955545042114905]
[]
[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.4675512733413258,3.2354942485791733,0,0,0,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9640889147649161,3.1805390961845563,3.1946822121268652,0,0,0,null,0,0,0,0,0,0.28701217715676952,4.0812036452308131E-2,0,0,0,null,"Finalised 19/20 stakeholder engagement award was £0.3m better than forecast (score of 6.96)"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.2733541247035971,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.7181036278823498,5.6361202793471339,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,4.2932858868858199,4.4350820998991107,0,0,0,null,0,0,0,0,0,0.42481774099652991,1.2010381794480232,0,0,0,null,"Impact of finalised actual volumes for 19/20 from RRP and latest RRP 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,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.6884126065569043,2.7239369753869207,0,0,0,0,0,null,0,0,0,-4.0863706556904411E-2,0,0,0,0,0,0]
[null,25,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.51996247371974869,-12.997642402839627,1.7541274662688486,5.9139537711416779E-14,0,5.9998828557764462E-14,null,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.51996247371974869,-12.976785184506575,3.1026799195387869E-7,5.9139537711416779E-14,5.9624589748810882E-14,0,null,0,0,0,0,0,-2.085721833305243E-2,1.7541271560008567,0,-5.9624589748810882E-14,5.9998828557764462E-14,null,"Latest position for 20/21 highlights an under collection of c.£1.7m"]
[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,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922,null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255,null,0,0,0,-2.0083706556874859E-2,0,-0.91350758977932855,-1.473868749897008,-4.0949742444446997,-4.3826895827280623,-6.070574378833328]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,438.21935777099588,413.41234981415425,447.49370251088965,443.50214993706874,454.45788093543564,463.69956471296928,null,421.35891895000003,410.34560751000004,408.89558755999997,449.45367699999997,439.91616672067653,414.32585740393347,448.96757126078666,447.59712418151355,458.84057051816376,469.77013909180255,null,0,0,0,0,-1.6968089496806442,-0.91350758977921487,-1.473868749897008,-4.0949742444448134,-4.3826895827281191,-6.0705743788332711]
[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.6968092498102578,0,0,0,0,0,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.495527521278973,-3.0012961360625923E-7,0,0,0,0,0,null,0,0,0,2.0083706556874859E-2,-1.6968089496806442,0,0,0,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,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,4.5418267800534373E-4,6.733046752344829E-2,6.7695671670477964E-3,-5.8170877851966507E-2,8.3609828442544831E-2,-3.0524411271500851E-3,2.5119567864092751E-2,2.381996988909707E-2,null,null,null,0,-4.905721963188725E-5,4.6275813762486351E-5,-2.0765492570227195E-3,-1.1707026833447376E-3,-5.8673549536085723E-3,-4.1679923056636703E-4,-3.4843476780557214E-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.8571195537126192E-3,0,0,0,0,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.8596623123257437E-2,6.8224274556398471E-10,0,0,0,0,null,null,null,0,0,-4.7279086814497329E-5,3.8571188714698738E-3,0,0,0,0]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999998E-2,1.8999999999999996E-2,1.9000000000000003E-2,1.8999999999999996E-2,1.9E-2,1.9E-2,1.8999999999999996E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.8999999999999996E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,0,0,0,0,0,0,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.0769815857443812E-3,-3.5639444136680611E-3,4.1790466456852055E-3,0.49675751046103755,2.0179083742521219E-2,2.039452349524188E-3,4.0998978975639137E-3,1.9256839787452767E-3,null,null,null,-1.0769815857443812E-3,-3.6130384505847126E-3,4.0295371711657792E-3,0.49723760486284452,1.9777757072707212E-2,2.2686235780013803E-3,4.1106243970915231E-3,2.0481156312936004E-3,null,null,null,0,4.9094036916651554E-5,1.4950947451942628E-4,-4.8009440180696306E-4,4.013266698140068E-4,-2.2917122847719226E-4,-1.0726499527609346E-5,-1.2243165254832364E-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.3509874164235479E-3,0.459367202905761,0.12161820950172131,1.211965626876553E-2,4.7802666531090297E-2,4.1261306189786622E-2,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7933634424943957E-2,1.2024812149561347E-3,0.45806672769312068,0.12238758551525204,1.8216182450851295E-2,4.8230192261184274E-2,4.486808552039067E-2,null,0,0,0,3.681728476256918E-8,1.4850620146741314E-4,1.3004752126403174E-3,-7.6937601353073426E-4,-6.0965261820857646E-3,-4.2752573009397637E-4,-3.6067793306040485E-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.958149478721,439.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340114,1345753,1348708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160912,1162830]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,2511538,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018","bopri 26/04/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,19059743380,19384528503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15841637342,15989045667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34901380722,35373574170,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14173.317543880596,14162.883813002833,14372.665175115741,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,13645.855449853219,13750.114519749233,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003,0.34499999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,0.34085252038066521,0.34231497592311966,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,114,116,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,109,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,113,"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.3500000000000002E-2,3.0099999999999998E-2,3.1899999999999998E-2,3.2899999999999999E-2,3.4500000000000003E-2,3.6200000000000003E-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.1908,0.20200000000000001,0.20860000000000001,0.21879999999999999,0.2298]
[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.10780000000000001,0.1113,0.1167,0.1226]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5115004355034047,4.3580343468257627,4.3520880108244429,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,81.228559999999987,80.922690000000003,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,43.373680000000007,43.183515,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.96027434682577,128.45829301082443,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.27572761540608,409.2076390972685,409.39349411865396,436.95814947872105,439.91616702080614,414.32585740393353,448.96757126078671,447.59712418151355,458.84057051816376,469.77013909180255]
[]
[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,"","","","","","","",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.89765605584324,128.64992450122739,139.2557118060956,138.01357925370431,141.42289677029342,144.29881937100524,null,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.03560802795519,130.00595553413908,140.87573117285757,140.44571629720818,143.973651998957,147.40310005439548,null,0,0,0,-1.1365501833411713,-1.1379519721119493,-1.3560310329116874,-1.6200193667619658,-2.4321370435038716,-2.5507552286635757,-3.1042806833902432]
[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,134.84132583683157,124.66058326335231,132.16208889737021,128.28915770303482,128.75441242307824,128.67063027631596,null,138.7659011533307,132.90073803295147,128.45829301082443,133.64801948250826,132.30359756847398,122.79613811770636,130.80668681163414,124.30340851346128,125.17274697382436,125.88836742404364,null,3.5919049626417063,3.4400873450303493,3.3250962687744448,2.3228802706579188,2.537728268357597,1.864445145645945,1.355402085736074,3.9857491895735393,3.581665449253876,2.7822628522723249]
[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,-8.3074681302041098E-3,-7.5501649885872157E-2,6.017544148795273E-2,-2.9304403605052709E-2,3.6266098271562353E-3,-6.5071281974382611E-4,null,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,4.0400089009796414E-2,-1.0059422647937133E-2,-7.186092914704767E-2,6.5234532752562968E-2,-4.9716711405876302E-2,6.9936815953759446E-3,5.7170627594274048E-3,null,-2.2204460492503131E-16,0,-1.1102230246251565E-16,-8.6243811876001164E-3,1.7519545177330231E-3,-3.6407207388244878E-3,-5.0590912646102382E-3,2.0412307800823593E-2,-3.3670717682197093E-3,-6.3677755791712309E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,27.10054479298779,27.533051904381232,29.311962506482811,29.266829728291906,27.669519483055829,null,8.77,8.77,8.77,8.77,8.77,27.100567770661687,27.634573437196295,29.50674288431787,29.548131345028004,28.017792925240894,null,0,0,0,0,0,-2.297767389691785E-5,-0.10152153281506315,-0.19478037783505897,-0.28130161673609777,-0.3482734421850644]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,37.673090999999999,39.078090000000003,42.476587000000002,43.301819000000002,41.798223,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.101174151210227,37.673090999999999,39.078089999999996,42.476587000000009,43.301819000000009,41.798223,null,0,0,0,0,0,0,0,0,0,0]
[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.4599269222449731,11.055514144537996,1.8594940835549564E-2,1.3079661218151696E-2,1.4714486421169543E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6256749562337021,-7.45727934101863,11.040263555590412,-3.4283955042718034E-3,2.1183001841538537E-3,3.7828208285101603E-3,null,0,0,0,0,0,-2.6475812263431209E-3,1.5250588947584021E-2,2.2023336339821366E-2,1.0961361033997842E-2,1.0931665592659382E-2]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4946647446030926E-2,-5.4014824296374067E-2,4.2206728764267218E-2,3.6962211069635487E-15,1.490614743720272E-14,1.4999707139441116E-14,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4946647446030926E-2,-5.4014824296374067E-2,-7.7351167882460478E-2,-3.6962211069635487E-15,1.490614743720272E-14,-2.9999414278882231E-14,null,0,0,0,0,0,0,0.1195578966467277,7.3924422139270974E-15,0,4.4999121418323344E-14]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005525475304941,30.159149253458651,50.175810873302268,42.495181940835558,43.314898661218166,41.812937486421184,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4005525475304941,30.161796834684996,50.041002387707948,42.47315860449573,43.303937300184174,41.802005820828484,null,0,0,0,0,0,-2.6475812263448972E-3,0.1348084855943199,2.2023336339827893E-2,1.0961361033992034E-2,1.0931665592700313E-2]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.359724974193548,30.159149253458647,50.175810873302254,42.495181940835543,43.314898661218166,41.812937486421148,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9475160000000002,3.4753761733333337,30.161796834684999,50.041002387707934,42.473158604495758,43.303937300184167,41.802005820828505,null,0,0,0,0,-0.11565119913978572,-2.6475812263520027E-3,0.1348084855943199,2.202333633978526E-2,1.096136103399914E-2,1.0931665592643469E-2]
[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.0827573336946088E-2,0,0,0,0,0,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,5.2011627992288645E-2,7.4823625802839633E-2,0,0,0,0,0,null,0,0,0,0,-0.11565119913978572,0,0,0,0,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930521632200892,7.8688966960267805,0.66370113598440139,-0.15307433599550357,1.9289639035405592E-2,-3.467539394572694E-2,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56930521632200892,7.8696752698583392,0.65908558637867931,-0.15123285749909721,1.9560087428969863E-2,-3.4683485451779017E-2,null,null,null,0,0,0,-7.7857383155865989E-4,4.6155496057220802E-3,-1.841478496406368E-3,-2.7044839356427097E-4,8.0915060520769799E-6]
[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.2006158636364955E-2,0,0,0,0,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-6.5874991060340385E-3,-2.200337290984581E-2,0,0,0,0,null,null,null,0,0,0,3.4009531546210767E-2,0,0,0,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,0,0,0,0,0,0,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7430088093823996E-3,0.26094269841918832,1.4953084407844947E-2,-4.0770319044595819E-3,4.6513950349286078E-3,7.005021643719557E-4,null,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-6.7430088093823996E-3,0.28747036754579997,1.4858889517931368E-2,-4.0445847535241324E-3,4.6576704659218419E-3,7.003370315971022E-4,null,null,null,0,0,0,-2.6527669126611642E-2,9.4194889913579161E-5,-3.2447150935449587E-5,-6.2754309932341878E-6,1.651327748534992E-7]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,8.1608455530823338,0.69765422039224634,-0.13815136789996316,4.29410340703342E-2,-1.4974891781354983E-2,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.56363572423742536,8.1541422644942934,0.69294447589661068,-0.13627744225262134,4.3217757894891705E-2,-1.4983148420181915E-2,null,0,0,0,0,0,6.7032885880404791E-3,4.7097444956356593E-3,-1.8739256473418175E-3,-2.7672382455750516E-4,8.2566388269322138E-6]
[]
[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.51561447327566,383.25320056069552,397.31789163758737,401.0069679962333,411.14298227421762,421.88662722654806,null,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,436.51561447327566,384.16406056924853,398.92656887307874,405.12396557701783,415.53663321797967,427.96813327097408,null,0,0,0,-2.0083706556874859E-2,0,-0.91086000855301563,-1.6086772354913705,-4.1169975807845276,-4.3936509437620543,-6.0815060444260212]
[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,434.85963279680232,383.25320056069563,397.31789163758742,401.00696799623319,411.1429822742175,421.88662722654811,null,412.11372795000005,402.67729251000003,401.73341855999996,441.50616099999996,436.44079054734317,384.16406056924848,398.92656887307874,405.12396557701777,415.53663321797961,427.96813327097402,null,0,0,0,0,-1.5811577505408536,-0.9108600085528451,-1.6086772354913137,-4.1169975807845844,-4.3936509437621112,-6.0815060444259075]
[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.6559816764733455,0,0,0,0,0,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.443515893286701,-7.4823925932491875E-2,0,0,0,0,0,null,0,0,0,2.0083706556874859E-2,-1.5811577505408536,0,0,0,0,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6465978587054941E-2,1.7417976083145215E-2,-0.12201720201200494,3.6698169920865276E-2,9.2849489949748953E-3,2.5276404369311445E-2,2.6131164620401659E-2,null,null,null,1.9513668221058378E-3,6.6515900416947327E-2,1.7370352445174486E-2,-0.11993054124122793,3.8427614186385295E-2,1.5535181628654193E-2,2.5702423272173203E-2,2.9916736718789361E-2,null,null,null,0,-4.9921829892385361E-5,4.7623637970728439E-5,-2.0866607707770157E-3,-1.7294442655200193E-3,-6.2502326336792979E-3,-4.2601890286175781E-4,-3.7855720983877017E-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.7936367487599412E-3,0,0,0,0,null,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.9001629564353808E-2,1.7141179708491904E-4,0,0,0,0,null,null,null,0,0,-4.8168104132311623E-5,3.6222249516750221E-3,0,0,0,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,null,null,null,0,0,0,0,0,0,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.2197712686397161E-3,-3.7494628703819682E-3,-1.6686639300311258E-3,-3.245459364280244E-3,1.3312559254008531E-3,-1.7667277736111812E-3,3.9896298933105138E-3,1.201098734714353E-3,null,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,-1.669208396192709E-3,-1.4275342871607408E-3,1.3668734271197365E-3,-1.6588687370339798E-3,4.0008268602322213E-3,1.2771484243794991E-3,null,null,null,0,4.9921829892385361E-5,5.4446616158318473E-7,-1.8179250771195032E-3,-3.5617501718883393E-5,-1.0785903657720142E-4,-1.1196966921707407E-5,-7.6049689665146081E-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.10246902462752525,5.7029425846266128E-2,2.6518221221363714E-2,4.8266034262621958E-2,4.6332263355116012E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10218666373130375,5.8794487613505031E-2,3.2876312891620213E-2,4.8703250132405423E-2,5.0193885143168859E-2,null,0,0,0,0,0,-2.8236089622149518E-4,-1.7650617672389027E-3,-6.3580916702564994E-3,-4.3721586978346522E-4,-3.8616217880528478E-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,1.9730000000000001E-2,1.83E-2,1.7170000000000001E-2,1.6289999999999999E-2,1.5599999999999999E-2,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,0,0,0,0,0,-5.7435918941961782E-3,-6.2525217252004245E-3,-6.6657742056609459E-3,-6.9956464677850966E-3,-7.2702487181647291E-3,null,"movement to reflect draft determination data"]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,0.19,0.19,0.19,0.19,0.19,null,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17,null,0,0,0,0,0,1.999999999999999E-2,1.999999999999999E-2,1.999999999999999E-2,1.999999999999999E-2,1.999999999999999E-2]
[]
[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,2.1174945914410848,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,2.1174945914410848,0,0,0,0,null,"NGN forecast of 20/21 allowances using 17% instead of 19% (Ofgem to confirm in FP)"]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,2.1174945914410848,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,2.1174945914410848,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-2.2628547598110789,-0.75033398329804868,0,0,0,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,0,0,0,0,0,-1.8063991643768216,-0.29387838786379139,0,0,0,null,"Updated for 19/20 actual RRP Totex and latest RRP forecast for 20/21"]
[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.39804980795090589,-1.0189014686432074E-2,0,0,0,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,0,0,0,0,0,0.26183637773701768,0.64969717100149149,0,0,0,null,"Updated for 19/20 actual RRP Totex and latest RRP forecast for 20/21"]
[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.39804980795090589,-1.0189014686432074E-2,0,0,0,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0,null,0,0,0,0,0,0.26183637773701768,0.64969717100149149,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.54340997632089993,-0.76052299798448075,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0.57293180480128103,0.35581878313770021,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.54340997632089993,-0.76052299798448075,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,0,0,0,0,0,0.57293180480128103,0.35581878313770021,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"High level mod186 rec","index":4,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":true,"merged":[[37,1,37,2],[19,1,19,2],[76,1,76,12]]}
[]
[null,"MOD186 Reconciliation - Jun 2020 to Sep 2020"]
[]
[null,"ALLOWED REVENUE",null,"16/17","17/18","18/19","19/20","20/21","21/22","22/23","23/24","24/25","25/26"]
[]
[null,"JUNE",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,439.91616702080614,414.32585740393353,448.96757126078666,447.59712418151355,458.84057051816382,469.77013909180255]
[]
[null,"Change to base allowed revenue to reflect draft determination data *",null,null,null,null,null,null,-1.7504764863673472,-4.770487168289435,-5.3411949562871541,-6.2320781940086931,-8.1466897224062222]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   June",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2]
[null,"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 £ movement",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Totex Incentive (19/20 actuals and new forecast for 20/21)",null,0,0,0,0,0,-1.8063991643768216,-0.29387838786379139,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,2.1174945914410848,0,0,0,0]
[]
[null,"Repex Tier 2a (19/20 actuals and new forecast for 20/21)",null,0,0,0,0,0,0.26183637773701768,0.64969717100149149,0,0,0]
[]
[null,"FGO Impact",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Ofgem changes to Fuel Poor allowances",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"\"MOD\" adjustment",null,0,0,0,0,0,0.57293180480128081,0.3558187831377001,0,0,0]
[]
[null,"Change in Inflation %"]
[null,"June (Based on HM Treasury May report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.5884636879724532E-2,1.6999999999999904E-2,1.4750000000000041E-2,1.7249999999999988E-2,1.8000000000000016E-2,1.8000000000000016E-2,1.8000000000000016E-2]
[null,"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,"Difference",null,0,0,0,0,-1.7499999999999183E-3,1.7499999999999183E-3,3.7499999999999201E-3,2.9999999999998916E-3,2.9999999999998916E-3,2.9999999999998916E-3]
[null,"Cumulative change in inflation",null,0,0,0,0,-1.7499999999999183E-3,0,3.7499999999999201E-3,6.7499999999998117E-3,9.7499999999997033E-3,1.2749999999999595E-2]
[]
[null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,0,0,0,0,0,-0.45942149035582158,-0.48919516851865197,0.59159901242889568,1.4406437524835951,1.7756282275590252]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 20/21)",null,0,0,0,0,0,-1.0163426702933798E-3,-0.55316095166310619,-5.1602891017584946E-14,0,0]
[]
[null,"Total base revenue changes",null,0,0,0,0,0,-1.6379825145921814,-5.4570245053334929,-4.74959594385831,-4.791434441525098,-6.3710614948471971]
[]
[null,"Incentive changes:"]
[]
[null,"Customer (19/20 stakeholder award better than forecast - score 6.96)",null,0,0,0,0,0,0.28701217715676952,4.0812036452308131E-2,0,0,0]
[null,"Shrinkage/Leakage (19/20 actual volumes and new forecast for 20/21)",null,0,0,0,0,0,0.4740553100954602,1.2603877872282991,0,0,0]
[null,"DRS",null,0,0,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,0,3.9583480975280416E-4,-2.0308206313726096E-3,0,0,0]
[null,"Total",null,0,0,0,0,0,0.76146332206198253,1.2991690030492347,0,0,0]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,0,1.7287867924933309E-3,6.9703040827752361E-2,0,0,0]
[null,"License Fee",null,0,0,0,0,0,1.773484263632441E-4,-1.7254609623407191E-3,0,0,0]
[null,"Pension Deficit",null,0,0,0,0,0,7.3096891048551882E-4,-7.1117536568623407E-3,0,-1.3844074441713438E-15,1.4119656068098912E-15]
[null,"Exit Capacity",null,0,0,0,0,0,-2.6475812263431209E-3,1.5250588947584021E-2,2.2023336339821366E-2,1.0961361033997842E-2,1.0931665592659382E-2]
[null,"Shrinkage pass thru (gas price increase impact)",null,0,0,0,0,0,-1.6120701818996608E-2,0.85374318123015058,0.63259836307375461,0.39778349776310051,0.28955545042114905]
[null,"SOLR",null,null,null,null,null,0,0,0,0,0,0]
[null,"Total",null,0,0,0,0,0,-1.6131178915997635E-2,0.9298595963862839,0.65462169941357595,0.40874485879709699,0.30048711601380984]
[]
[null,"Network Innovation",null,0,0,0,-4.0863706556904411E-2,0,0,0,0,0,0]
[]
[null,"K factor (under collection forecast during 20/21)",null,0,0,0,0,0,-2.085721833305243E-2,1.7541271560008567,0,-5.9624589748810882E-14,5.9998828557764462E-14]
[]
[null,"SEPTEMBER",null,411.27572761540614,409.2076390972685,409.39349411865396,436.91728577216412,439.91616702080614,413.4123498141542,447.49370251088965,443.50214993706885,454.45788093543575,463.69956471296922]
[null,"Difference",null,0,0,0,-4.0863706556876878E-2,0,-0.91350758977932855,-1.473868749897008,-4.0949742444446997,-4.3826895827280623,-6.070574378833328]
[]
[null,"Memo:"]
[null,"In year (under)/over collection",null,null,null,-0.49790655865399458,12.515611227835848,-1.6968092498102578]
[]
[null,"SOQ Assumption JUNE",null,null,null,null,-1.8999999999999996E-2]
[null,"SOQ Assumption SEPTEMBER",null,null,null,null,-1.8999999999999996E-2]
[]
[null,"Total Price Change","June",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,5.6995144846279698E-3,-0.10218666373130375,5.8794487613505031E-2,3.2876312891620213E-2,4.8703250132405423E-2,5.0193885143168859E-2]
[null,"Total Price Change","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,"TOTAL PRICE CHANGE %","Difference",0,0,0,0,0,-2.8236089622149518E-4,-1.7650617672389027E-3,-6.3580916702564994E-3,-4.3721586978346522E-4,-3.8616217880528478E-3]
[]
[null,"* GD2 data reflects 1. draft determination data plus 2. an adjustment to reflect the latest NTS unit rates for mod678 Exit capacity allowances plus 3. an expectation of increased repex workload allowances."]