{"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":164,"n_cols":23,"rows_kept":164,"cut":false,"hidden":false,"merged":[[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[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],[52,21,87,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:","2019-12-16T14:24:17.060","RIIO-GD2"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD2 data reflects our December 2019 business plan bid submission per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020."]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3872501228224969,1.4153419378096526,1.445064118503655,1.4754104649922319,1.5063940847570685,1.5380283605369665]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,null,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,null,null,null,null,null,null,null,"Final RPI will be available on 18th December 2019 for 20/21 rates"]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,null,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,"As per Aug 2019 HM Treasury Report - note the delay until Dec 19 RPI publication due to election"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-4.500000000000004E-3,"","","","","","",null,"Difference between forecast and actual drives true up in 2 years time"]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,"GD2 yrs as per December 2019 Appendix A33 Bid proposal business plan submission, discounted to 09/10 prices to be comparable with GD1 yrs"]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,"Latest forecast of Annual Iteration Process"]
[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.4291824635517685,-5.3088989111343195E-14,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,121.34451550712765,126.60054597991484,135.60376323645255,146.18631958501459,156.4341305682471,167.53512177667733,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,434.69371375321344,431.41095507935597,440.28742026179179,453.68127468114022,465.35189891716647,478.92227915528252]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0583476927345217,4.9058935428152459,4.5152464233169312,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.34389096601832431,0.35010962778984267,0.35796818576983019,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.0149051928984458,2.0513412006289995,2.0973855892499156,0,0,1.4609941867111868E-15]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0.234705,0,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.651848851651291,7.3073443712340884,6.970600198336677,0,0,1.4609941867111868E-15]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9863531535937091,1.1365941270394262,0.2677790543281206,0,0,0,null,"Data uses finalised July 2019 Gemini bookings applied with NTS incentive rates"]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.685660295935719,-6.486802541602783,-5.0559632326439843,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-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.70917233907219934,0.88588374601115449,0,0,0,null,"13/14 - 18/19 actual volume impact with forecast thereafter"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.4235623493677725,-7.6826802204551212,-6.6121320382852202,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,"Actuals and forecast compared against original allowance with actual/forecast gas prices"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4380158637376868,-6.9735078813829219,-5.7262482922740654,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9654558900566048,3.205982088021154,3.2587242087620125,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.2989998765529061,4.4912024336340712,0,0,0,null,"13/14 - 18/19 actual volume impact with forecast thereafter"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,0,0,0,0,0,null,"DRS from 11/12, 12/13,14/15/17/18"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7385703966452448,0,0,0,0,0,null,"Actual spend 13/14 - 18/19, assumed will spend maximum allowance thereafter"]
[null,25,null,"Less Correction Term revenue Adjustment (K added)","-Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.52019875048966657,-13.046837992942569,1.1941043080997777E-13,-1.8020925018778287E-13,1.0421903553867473E-3,1.8147805349144622E-13]
[null,26,null,"GD2 Incentives",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,"NGN's assumed level of GD2 incentives (collected 2 years after)"]
[null,27,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233512,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501]
[]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.42289132076002,441.56819907233506,419.71613299923604,444.22475453855571,453.62939434480006,465.31763653279063,478.92258745384459]
[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.464741842039018,0,0,-9.8103905088464671E-4,0,0,-2.5891420420975919E-5]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,4.5418267800534373E-4,6.733046752344829E-2,1.0550322952241009E-2,-4.9487409009541627E-2,5.8395664715646056E-2,2.1168649211569246E-2,2.5766059990165235E-2,2.9238042456006363E-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.8526168597402545E-2,0,0,2.2084246190938173E-6,0,0,null,"Movement year on year in row reference 28"]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,null,null,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,0.02,1.9999999999999997E-2,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.6141718432215388E-3,7.3789228494550788E-3,0.318591923909052,9.7553878960493848E-4,-1.5009001210017289E-3,3.1970485454792842E-3,5.8024874845931385E-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.793250103230713E-2,5.4030772042935448E-3,0.28910451489951039,7.9371203505250995E-2,3.9669957515186607E-2,4.896310853564452E-2,4.9818291204465674E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,"2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22"]
[null,null,null,"Allowed Revenues £m","Nom Prices",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233512,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501,null,"Note customer bill methodology shown here for GD2 years excluded NTS Exit Capacity charges, per standard Mod186 methodology.  Our GD2 business plan submission includes NTS exit capacity charges to show the full impact of distribution charges within the NGN network."]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114,1345753,1348708]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041,1160912,1162830]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,2506665,2511538,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018","bopri 26/04/2019"]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267,19059743380,19384528503]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741,15841637342,15989045667]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,34901380722,35373574170,0,0,0,0,0,0,0]
[]
[null,null,null,"Average AQ","NE",null,null,15078.02270927113,14890.239844223981,14300.054833420678,14173.317543880596,14162.883813002833,14372.665175115741,"","","","","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,13645.855449853219,13750.114519749233,"","","","","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998,0.33900000000000002,0.34]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997,0.34300000000000003,0.34499999999999997]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,0.34085252038066521,0.34231497592311966,"","","","","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,114,116,"","","","","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,109,109,"","","","","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,112,113,"","","","","","",""]
[]
[null,null,null,"Unit Rates","Commodity",null,null,2.7799999999999998E-2,2.92E-2,3.1199999999999999E-2,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.3599999999999998E-2,3.09E-2,3.32E-2,3.4099999999999998E-2,3.5799999999999998E-2,3.7699999999999997E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21129999999999999,0.21340000000000001,0.19600000000000001,0.2107,0.21629999999999999,0.2273,0.23910000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1128,0.1139,0.1046,0.1125,0.11550000000000001,0.12139999999999999,0.12770000000000001]
[]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,4.3580343468257627,4.3520880108244429,"","","","","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,81.228559999999987,80.922690000000003,"","","","","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,43.373680000000007,43.183515,"","","","","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,128.45829301082443,0,0,0,0,0,0,0]
[]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.4080416156043,411.27572761540608,409.2076390972685,409.39349411865396,436.95814947872105,441.56819907233518,419.71613299923587,444.22573557760666,453.62939434480023,465.31763653279069,478.92261334526501]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","",""]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",121.13327029305293,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.55397781249573,131.69730044258981,139.38785184319096,142.33850438321363,146.00600682606191,150.27493665247425]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (18/19 Prices)","18/19 prices",140.25979326838052,null,141.70831099797692,144.87369155996313,146.75383602671721,138.7659011533307,132.90073803295147,128.45829301082443,133.47038202629091,131.14101863026474,122.17710306628857,126.65202371486433,122.91713252797823,123.49091355388168,124.48731256346828]
[null,37,null,"% movement in domestic customer bill - (18/19 prices)",null,null,null,null,2.2337296519125083E-2,1.2977818446600953E-2,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.9017247528301935E-2,-1.7452286871909362E-2,-6.8353255583966321E-2,3.6626508046666117E-2,-2.9489392094472766E-2,4.668031332189182E-3,8.0686018178321994E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.166183577153298,32.76002528951021,33.493624415324646,33.62634398891268,33.559431796346516,33.592333264761216]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.4980704041784932E-2,-4.2453450696853169E-2,0,-8.9410044879364233E-4,-1.1322497084931879E-14,-9.5150041012734233E-4]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4191894235820843,25.094175170171148,28.16988212835254,33.61425641581156,33.566544424147644,33.617755820509124]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.936063724666667,3.4191894235820843,25.095021248709205,28.169882128352551,33.615150516260378,33.566544424147693,33.618707320919249]
[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,4.0559352658955383E-2,0,8.4607853805707123E-4,0,8.9410044881788053E-4,0,9.5150041012459496E-4]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56694477483866756,6.3392175926542995,0.12256656922668707,0.19326933150278758,-1.4193975042527951E-3,1.5256678112103295E-3]
[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,-5.1370185801875162E-3,0,-3.3716132621198278E-5,0,-2.6598846565509963E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,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,-4.5729897627748983E-3,0.13003245090487384,2.9046182318817962E-3,1.0578987528334811E-3,3.170288808907018E-3,4.6822453638322922E-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.56065478318162998,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,380.29677084437623,null,384.44668689922634,401.47893814541436,414.87150072575594,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,438.14900964875301,394.62195782906463,416.05585344925407,420.01513792898868,431.75109210864304,445.3048575247559]
[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.48682759609335,438.14900964875295,394.62111175052684,416.05487241020319,420.01424382853969,431.75109210864292,445.30388013292531]
[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.424182489380087,0,-8.460785377906177E-4,-9.8103905088464671E-4,-8.9410044898841079E-4,0,-9.7739183058820345E-4]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6515900416947327E-2,2.1177244501860315E-2,-9.9343033673823244E-2,5.4315010087385485E-2,9.5162330896458869E-3,2.7941740951342942E-2,3.1392544602301342E-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.89565699346538E-2,0,2.1440229592016443E-6,2.3579503635184479E-6,2.1287338675387813E-6,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,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.7993847002743535E-3,1.5997561098670676E-3,-2.2495148560157212E-3,8.6456006973401056E-4,-2.7908599853965071E-3,2.9841609985418634E-3,3.7886767132636404E-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,9.8204306770735827E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"as per Nov19 AIP"]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2021-22","2021-22",null,"Assumptions","Frequency"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,"GD2 years as per business plan submission (CPI based methodology)"]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17]
[]
[null,60,null,"Cost of Debt Adjustment (*)","CDE £ impact",null,null,null,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.517784630239372,0,0,0,0,0]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4967783032913973,0,0,0,0,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE"]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE"]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.139431070936595,0,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,null,17.398062412967949]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR"]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,0,0,0,0,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,"last 2 years of GD1 will be adjusted for in first 2 years of GD2"]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0]
[null,null,null,"Check that it adds down and matches the summary sheet",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":213,"n_cols":66,"rows_kept":213,"cut":false,"hidden":false,"merged":[[1,53,1,58],[1,60,1,65],[1,43,1,51],[45,3,45,4],[46,3,46,4],[7,3,7,4],[1,3,1,4],[3,43,5,51],[30,43,31,51],[15,43,15,51],[1,10,1,19],[1,21,1,30],[1,32,1,41],[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,"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,"BUDGET SUBMISSION",null,null,null,null,null,null,"DIFFERENCE TO BUDGET"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,"GD2 data reflects our December 2019 business plan Bid submission as per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[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.3872501228224969,1.4153419378096526,1.445064118503655,1.4754104649922319,1.5063940847570685,1.5380283605369665,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3872501228224969,null,null,null,null,null,null,0,0,0,0,0,1.4153419378096526,1.445064118503655,1.4754104649922319,1.5063940847570685,1.5380283605369665,null,null,null,null,null,null,null,null,null,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.355627679781122,1.392907440975103,null,null,0,0,0,2.9605262901264418E-3,-5.6573181526060612E-3,1.4153419378096526]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,0,0,0,0,0,0,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,null,null,null,null,0,0,0,3.175E-2,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.7249999999999996E-2,2.849999999999997E-2,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,null,null,null,null,null,null,0,0,0,0,0,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,null,null,null,null,null,null,null,null,null,null,null,2.1427497658355055E-2,3.7421255484442417E-2,3.2999999999999918E-2,3.0000000000000027E-2,2.750000000000008E-2,null,null,0,0,-2.4443602412924648E-3,-2.7500000000000302E-3,9.9999999999988987E-4,2.0250000000000101E-2]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-4.500000000000004E-3,"","","","","","",null,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-4.500000000000004E-3,"",null,null,null,null,null,null,0,0,0,0,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,-1.5725023416449449E-3,3.4212554844424148E-3,-3.0000000000008492E-4,"","",null,null,0,0,-2.4443602412924648E-3,null,null,{"$error":"#VALUE!"}]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,null,null,null,null,0,0,0,0,0,308.3559333441151,305.79999880646147,307.49495509612564,308.91776834891937,311.3871573786052,null,null,null,null,null,null,null,null,null,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,0,0,0,0,0,308.3559333441151]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.416759711127668,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.208814745762975,null,null,null,null,null,null,0,0,0,0,-0.20794496536469254,-1.116341781122181,-1.116341781122181,0,0,0,null,"Movement on finalised mod adjustment per November 2019 Annual Iteration Process",null,null,null,null,null,null,null,null,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.42402427058491199,-0.33825141644719992,-1.116341781122181]
[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.4291824635517685,-5.3088989111343195E-14,0,0,0,null,-4.799238859163383,-7.397500940821363,-1.3063014185593671,0.82995782153066311,-0.25144929809729283,null,null,null,null,null,null,0,0,0,0,0,-2.4291824635517685,-5.3088989111343195E-14,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82997742654546791,0.53449576789326958,null,null,0,1.6515553068936484E-3,0,-1.9605014804802146E-5,-0.78594506599056246,-2.4291824635517685]
[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,121.34451550712765,126.60054597991484,135.60376323645255,146.18631958501459,156.4341305682471,167.53512177667733,null,76.602895594612164,84.616853933028949,98.926361079340722,112.63245107042013,121.42504222050547,null,null,null,null,null,null,0,0,0,0,-8.0526713377821579E-2,126.60054597991484,135.60376323645255,146.18631958501459,156.4341305682471,167.53512177667733,null,null,null,null,null,null,null,null,null,null,null,76.602895594612164,84.616406495412889,98.926361079340722,111.85335236469609,123.55893677753761,null,null,0,4.4743761606014232E-4,0,0.77909870572403861,-2.2144212704099573,126.60054597991484]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,434.69371375321344,431.41095507935597,440.28742026179179,453.68127468114022,465.35189891716647,478.92227915528252,null,405.74788540780747,396.94958848483157,413.95451095107899,426.73215977093719,434.98218543195594,null,null,null,null,null,null,0,0,0,0,-0.28847167874249635,431.41095507935597,440.28742026179179,453.68127468114022,465.35189891716647,478.92227915528252,null,null,null,null,null,null,null,null,null,null,null,405.74788540780747,396.94748949190864,413.95451095107899,426.37710494081284,438.0323315060611,null,null,0,2.0989929229244808E-3,0,0.35505483012434524,-3.3386177528476537,431.41095507935597]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0583476927345217,4.9058935428152459,4.5152464233169312,0,0,0,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0583476927345217,null,null,null,null,null,null,0,0,0,0,0,4.9058935428152459,4.5152464233169312,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0599168739905309,5.1785514559792123,null,null,0,0,0,1.0903391619127234E-2,-0.12020376324469062,4.9058935428152459]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34389096601832431,0.35010962778984267,0.35796818576983019,0,0,0,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34389096601832431,null,null,null,null,null,null,0,0,0,0,0,0.35010962778984267,0.35796818576983019,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32030284338849946,0.32781264935596643,null,null,0,0,0,6.9020646488021642E-4,1.6078316662357872E-2,0.35010962778984267]
[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.0149051928984458,2.0513412006289995,2.0973855892499156,0,0,1.4609941867111868E-15,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0149051928984458,null,null,null,null,null,null,0,0,0,0,0,2.0513412006289995,2.0973855892499156,0,0,1.4609941867111868E-15,null,null,null,null,null,null,null,null,null,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2540918398567773,2.0040130730026235,null,null,0,0,0,4.8572430511204523E-3,1.0892119895822283E-2,2.0513412006289995]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0.234705,0,0,0,0,0,null,-0.15071466,0,0.78779600000000005,0.736896,0,null,null,null,null,null,null,0,0,0,0,0.234705,0,0,0,0,0,null,"Together Energy SOLR claim £235k",null,null,null,null,null,null,null,null,null,-0.15071466,0,0.78779600000000005,0,0,null,null,0,0,0,0.736896,0.234705,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.651848851651291,7.3073443712340884,6.970600198336677,0,0,1.4609941867111868E-15,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.4171438516512911,null,null,null,null,null,null,0,0,0,0,0.23470499999999994,7.3073443712340884,6.970600198336677,0,0,1.4609941867111868E-15,null,null,null,null,null,null,null,null,null,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.634311557235808,7.5103771783378015,null,null,0,0,0,0.75334684113512829,0.14147167331348953,7.3073443712340884]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,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.9863531535937091,1.1365941270394262,0.2677790543281206,0,0,0,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.9863531535937091,null,null,null,null,null,null,0,0,0,0,0,1.1365941270394262,0.2677790543281206,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1602163747596084,1.9966397822162956,null,null,0,0,0,4.6549549533367873E-3,-1.0286628622586447E-2,1.1365941270394262]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,null,null,null,null,null,null,0,0,0,0,0,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,null,null,null,null,null,null,null,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0311723376815163,-8.7186966619122224,null,null,0,0,0,-8.6865954078945151E-3,4.6683212382793826E-2,-7.6233966686422088]
[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.685660295935719,-6.486802541602783,-5.0559632326439843,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.685660295935719,null,null,null,null,null,null,0,0,0,0,0,-6.486802541602783,-5.0559632326439843,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,null,null,null,null,null,null,null,null,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8709559629219079,-6.722056879695927,null,null,0,0,0,-4.0316404545577278E-3,3.6396583760208046E-2,-6.486802541602783]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[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.70917233907219934,0.88588374601115449,0,0,0,null,0.62430579478113291,0.54979434816097894,0.85626690692416452,0.80288411218541877,0.98554648563008584,null,null,null,null,null,null,0,0,0,0,0,0.70917233907219934,0.88588374601115449,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,0.79417604948705034,null,null,-6.7425142764183654E-3,-5.4354750760734483E-3,-5.5376304565070145E-3,-6.6574525263642936E-3,0.1913704361430355,0.70917233907219934]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.8265844595965404,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.4235623493677725,-7.6826802204551212,-6.6121320382852202,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.4235623493677725,null,null,null,null,null,null,0,0,0,0,0,-7.6826802204551212,-6.6121320382852202,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,null,null,null,null,null,null,null,null,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.4948341143184356,-6.8751215441655633,null,null,0,0,0,-1.3995431469179032E-2,1.4515591947977908,-7.6826802204551212]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0845507492803379,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4380158637376868,-6.9735078813829219,-5.7262482922740654,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,-5.0831662919261387,-6.6589865021749644,-6.4536787655722723,-5.7059454336021957,-4.4380158637376868,null,null,null,null,null,null,0,0,0,0,0,-6.9735078813829219,-5.7262482922740654,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2,null,null,null,null,null,null,null,null,null,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6852925496066522,-6.0809454946785131,null,null,-6.7425142764179213E-3,-5.4354750760738924E-3,-5.5376304565069034E-3,-2.0652883995543547E-2,1.6429296309408263,-6.9735078813829219]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[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.9654558900566048,3.205982088021154,3.2587242087620125,0,0,0,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072631567728506,2.9716718863483695,null,null,null,null,null,null,0,0,0,0,-6.2159962917647249E-3,3.205982088021154,3.2587242087620125,0,0,0,null,null,null,null,null,null,null,null,null,null,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9087827865017268,3.178825350749273,null,null,0,0,0,-1.519629728876204E-3,-0.21336946069266816,3.205982088021154]
[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.2989998765529061,4.4912024336340712,0,0,0,null,2.7868233302608458,3.0471350412864737,5.005644658978051,4.107742797150185,4.122087589952347,null,null,null,null,null,null,0,0,0,0,0,4.2989998765529061,4.4912024336340712,0,0,0,null,null,null,null,null,null,null,null,null,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.6019895952975309,null,null,-3.2360315749368151E-2,-3.2777177435093563E-2,-3.3971932294256213E-2,-3.5786317814871182E-2,-0.4799020053451839,4.2989998765529061]
[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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.8,0,0,0.9,0,null,null,0,0,0,0,0,0]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7385703966452448,0,0,0,0,0,null,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.6884126065569043,2.7403877682213227,null,null,null,null,null,null,0,0,0,0,-1.8173715760778641E-3,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.6861757611271213,2.7596036884881849,null,null,0,0,-6.2596418991797798E-2,2.2368454297829743E-3,-2.1033291842940116E-2,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.52019875048966657,-13.046837992942569,1.1941043080997777E-13,-1.8020925018778287E-13,1.0421903553867473E-3,1.8147805349144622E-13,null,2.7784430349248272,6.6974705365242881,-10.458524555950305,-1.1841542140883532,0.52145504797395337,null,null,null,null,null,null,0,0,0,0,-1.2562974842867947E-3,-13.046837992942569,1.1941043080997777E-13,-1.8020925018778287E-13,1.0421903553867473E-3,1.8147805349144622E-13,null,null,null,null,null,null,null,null,null,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.3538791247462367,1.2567984757658177,null,null,0,0.198542237746822,-4.0558380225203194E-2,0.16972491065788353,-0.73659972527615114,-13.046837992942569]
[null,26,null,"GD2 Incentives",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0,0,0,0,0,0]
[null,27,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.4080416156043,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233512,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501,null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.63125541642984,441.63125541642984,441.63125541642984,441.63125541642984,0,0,null,0,0,0,0,-6.3056344094718497E-2,-21.915122417194084,2.5944801611767616,11.998138928370395,465.31763653279069,478.92261334526501,null,null,null,null,null,null,null,null,null,null,null,411.31483044543194,409.0452105191099,409.53615848062174,435.73977652336777,444.53692342032531,444.53692342032531,null,-3.9102830025797175E-2,0.16242857815859679,-0.14266436196777477,1.2183729553532316,-2.9687243479901895,-24.820790421089555]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,28,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,449.42289132076002,441.56819907233506,419.71613299923604,444.22475453855571,453.62939434480006,465.31763653279063,478.92258745384459,null,421.35891895000003,410.34560751000004,408.89558755999997,449.15686866285239,441.63125541642972,441.63125541642972,441.63125541642972,441.63125541642972,0,0,null,0,0,0,0.26602265790762658,-6.3056344094661654E-2,-21.915122417193686,2.5934991221259907,11.998138928370338,465.31763653279063,478.92258745384459,null,null,null,null,null,null,null,null,null,null,null,421.35891895000003,410.34560751000004,408.33741256066969,435.73977652336788,444.53692342032497,415.27013215808086,null,0,0,0.55817499933027648,13.683114797392136,-2.9687243479899053,4.4460008411551826]
[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.464741842039018,0,0,-9.8103905088464671E-4,0,0,-2.5891420420975919E-5,null,10.083191334593891,1.1379684127315386,-0.49790655865399458,12.198719184131392,0,0,0,0,0,0,null,0,0,0,0.26602265790762658,0,0,-9.8103905088464671E-4,0,0,-2.5891420420975919E-5,null,null,null,null,null,null,null,null,null,null,null,10.044088504568094,1.3003969908901354,-1.1987459199520458,0,0,-29.266791262244453,null,3.9102830025797175E-2,-0.16242857815859679,0.70083936129805124,12.464741842039018,0,29.266791262244453]
[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,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,null,null,null,null,null,null,null,null,null,null,0,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.733046752344829E-2,1.0550322952241009E-2,-4.9487409009541627E-2,5.8395664715646056E-2,2.1168649211569246E-2,2.5766059990165235E-2,2.9238042456006363E-2,null,null,null,4.5418267800534373E-4,6.733046752344829E-2,1.0694630465832411E-2,null,null,null,null,null,null,null,null,0,0,-1.4430751359140181E-4,-4.9487409009541627E-2,5.8395664715646056E-2,2.1168649211569246E-2,2.5766059990165235E-2,2.9238042456006363E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2002290917640934E-3,6.3983649551144328E-2,2.0188992079509527E-2,null,null,0,0,-7.4604641375874969E-4,3.3468179723039615E-3,-9.6386691272685177E-3,-4.9487409009541627E-2]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.8526168597402545E-2,0,0,2.2084246190938173E-6,0,0,null,null,null,-2.7809070603910303E-3,1.2162053520803802E-3,-2.7917362792487396E-2,null,null,null,null,null,null,null,null,0,0,-6.0880580491514888E-4,0,0,2.2084246190938173E-6,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.1791033300202472E-3,2.9270820051625979E-3,0,null,null,0,0,3.9819626962921692E-4,-1.7108766530822177E-3,-2.8526168597402545E-2,0]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,1.6E-2,0.02,0.02,1.9999999999999997E-2,0.02,1.9999999999999997E-2,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,2.0000000000000004E-2,null,null,null,null,null,null,null,null,0,0,-4.0000000000000036E-3,0.02,0.02,1.9999999999999997E-2,0.02,1.9999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943875E-2,0.02,2.0000000000000004E-2,null,null,0,0,0,-7.000000000000001E-3,-4.0000000000000036E-3,0.02]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.0769815857443812E-3,-3.6141718432215388E-3,7.3789228494550788E-3,0.318591923909052,9.7553878960493848E-4,-1.5009001210017289E-3,3.1970485454792842E-3,5.8024874845931385E-4,null,null,null,-1.0769815857443812E-3,-3.6149833392664001E-3,7.1815742755080084E-3,null,null,null,null,null,null,null,null,0,8.11496044861304E-7,1.9734857394707039E-4,0.318591923909052,9.7553878960493848E-4,-1.5009001210017289E-3,3.1970485454792842E-3,5.8024874845931385E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.4181976965677041E-3,-2.7564947634653204E-3,9.0533147140567163E-3,null,null,0,0,3.4121611082332283E-4,-8.5767707975621839E-4,-1.6743918646016376E-3,0.318591923909052]
[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.793250103230713E-2,5.4030772042935448E-3,0.28910451489951039,7.9371203505250995E-2,3.9669957515186607E-2,4.896310853564452E-2,4.9818291204465674E-2,null,4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7931689536262269E-2,9.9588419488530287E-3,2.0881313184737234E-2,2.2966353068235277E-2,2.6332620884656117E-2,0,0,null,0,0,0,8.11496044861304E-7,-4.5557647445594839E-3,0.26822320171477315,5.6404850437015722E-2,1.3337336630530491E-2,4.896310853564452E-2,4.9818291204465674E-2,null,null,null,null,null,null,null,null,null,null,null,4.262170956228286E-2,-3.5094262359407283E-2,-1.4010248293767732E-2,8.4154236792841605E-2,4.9242306793566247E-2,0.2206329023078436,null,7.5585438546327266E-7,1.0755477270474323E-6,-6.6340333062121087E-6,-6.2217357605344747E-3,-4.38392295892727E-2,6.8471612591666786E-2]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.27572761540614,409.2076390972685,409.39349411865396,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1340114,1345753,1348708,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,null,null,null,null,1340114,1345432,null,null,null,null,null,-1340114,-1345432,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,1156041,1160912,1162830,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,null,null,null,null,1156041,1160436,null,null,null,null,null,-1156041,-1160436,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,2496155,2506665,2511538,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,2496155,2505868,0,0,0,0,null,-2496155,-2505868,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,18993861267,19059743380,19384528503,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,null,null,null,null,18993861267,18993564750,null,null,null,null,null,-18993861267,-18993564750,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,15871167741,15841637342,15989045667,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,null,null,null,null,15871167741,15823425361,null,null,null,null,null,-15871167741,-15823425361,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,34865029008,34901380722,35373574170,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,34865029008,34816990111,0,0,0,0,null,-34865029008,-34816990111,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,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,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,14173.317543880596,14117.075221936151,"","","","",null,-14173.317543880596,-14117.075221936151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,13728.896934451286,13635.758767394324,"","","","",null,-13728.896934451286,-13635.758767394324,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,13967.493608369672,13894.183616615081,"","","","",null,-13967.493608369672,-13894.183616615081,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,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,null,null,null,null,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002,null,null,null,null,null,-0.35599999999999998,-0.33900000000000002,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,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,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003,null,null,null,null,null,-0.34499999999999997,-0.34300000000000003,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,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,null,null,null,0.35090558438878994,0.34085234976463247,"","","","",null,-0.35090558438878994,-0.34085234976463247,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,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,null,null,null,null,null,null,null,null,null,null,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,109,114,116,"","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,114,"","","","",null,-109,-114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,109,109,"","","","",null,-109,-109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,109,112,"","","","",null,-109,-112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,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,null,null,null,null,null,null,null,null,null,null,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,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.3799999999999997E-2,3.44E-2,3.49E-2,3.5000000000000003E-2,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.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3500000000000002E-2,3.5299999999999998E-2,3.5299999999999998E-2,null,-3.2300000000000002E-2,-3.1300000000000001E-2,-3.09E-2,-3.3500000000000002E-2,-3.5299999999999998E-2,-3.5299999999999998E-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.21429999999999999,0.21790000000000001,0.22090000000000001,0.2218,null,null,null,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.21260000000000001,0.22409999999999999,0.22409999999999999,null,-0.20530000000000001,-0.19869999999999999,-0.19620000000000001,-0.21260000000000001,-0.22409999999999999,-0.22409999999999999]
[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.1144,0.1163,0.1179,0.11840000000000001,null,null,null,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.1134,0.1195,0.1195,null,-0.1096,-0.1061,-0.1047,-0.1134,-0.1195,-0.1195]
[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,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,null,null,null,null,null,null,null,null,null,null,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,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,null,null,null,4.5115004355034047,4.3488794720005206,"","","","",null,-4.5115004355034047,-4.3488794720005206,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,81.678605000000005,81.228559999999987,"","","","",null,-81.678605000000005,-81.228559999999987,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,43.604360000000007,43.373680000000007,"","","","",null,-43.604360000000007,-43.373680000000007,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.95111947200053,0,0,0,0,null,-129.79446543550341,-128.95111947200053,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,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,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.27572761540608,409.2076390972685,409.39349411865396,436.95814947872105,441.63125541642984,441.63125541642984,441.63125541642984,441.63125541642984,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543188,409.0452105191099,409.53615848062174,435.73977652336777,444.53692342032531,415.27013215808108,null,-411.31483044543188,-409.0452105191099,-409.53615848062174,-435.73977652336777,-444.53692342032531,-415.27013215808108]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","","","",null,13967.493608369672,13923.432417973681,14084.42721949658,"","","","","",0,0,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13894.183616615081,"","","","",null,0,29.248801358600758]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.55397781249573,131.69730044258981,139.38785184319096,142.33850438321363,146.00600682606191,150.27493665247425,null,129.79446543550341,128.96027434682577,128.45829301082443,137.10744993650735,138.57376344769088,138.57376344769088,138.57376344769088,138.57376344769088,0,0,null,0,0,0,0,-1.9785635195148643E-2,-6.8764630051010727,0.81408839550007883,3.7647409355227524,146.00600682606191,150.27493665247425,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.95111947200053,129.10589035700636,137.36655640059752,140.13984871975867,130.9135201879314,null,0,9.1548748252421319E-3,-0.6475973461819251,-0.25910646409016636,-1.5858709072629438,0.78378025465841006]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (18/19 Prices)","18/19 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},138.7659011533307,132.90073803295147,128.45829301082443,133.47038202629091,131.14101863026474,122.17710306628857,126.65202371486433,122.91713252797823,123.49091355388168,124.48731256346828,null,138.7659011533307,132.90073803295147,128.45829301082443,133.47038202629091,131.15974568808514,128.5564770282628,125.91231834305859,119.66607152722959,0,0,null,0,0,0,0,-1.8727057820399295E-2,-6.3793739619742382,0.7397053718057407,3.2510610007486349,123.49091355388168,124.48731256346828,null,null,null,null,null,null,null,null,null,null,null,134.65153728703203,128.95111947200053,124.98150082962863,129.10511978552196,128.18649345624914,117.39914996963806,null,4.1143638662986746,3.9496185609509382,3.4767921811958047,4.3652622407689421,2.9545251740156004,4.7779530966505064]
[null,37,null,"% movement in domestic customer bill - (18/19 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.9017247528301935E-2,-1.7452286871909362E-2,-6.8353255583966321E-2,3.6626508046666117E-2,-2.9489392094472766E-2,4.668031332189182E-3,8.0686018178321994E-3,null,-5.4430842079877695E-2,-4.2266602037185352E-2,-3.3426789706958338E-2,3.9017247528301935E-2,-1.7311978156701602E-2,-1.9848076451850161E-2,-2.0568070519098813E-2,-4.9607908884741314E-2,0,0,null,0,0,0,0,-1.4030871520775978E-4,-4.8505179132116161E-2,5.7194578565764931E-2,2.0118516790268548E-2,4.668031332189182E-3,8.0686018178321994E-3,null,null,null,null,null,null,null,null,null,null,null,-1.9046457043139786E-2,-4.2334591419332379E-2,-3.0783902137691999E-2,3.2993834515673948E-2,-7.1153361756598477E-3,-8.4153510996015091E-2,null,-3.5384385036737909E-2,6.7989382147026767E-5,-2.6428875692663389E-3,6.0234130126279872E-3,-1.0336950696249514E-2,1.5800255412048769E-2]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)",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,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,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509,null,8.77,8.77,8.77,8.77,8.77,null,null,null,null,null,null,0,0,0,0,0,23.146367965474688,23.177950366663907,22.791178988343237,22.277989628297391,21.841166344314509,null,null,null,null,null,null,null,null,null,null,null,8.77,8.77,8.77,8.77,8.77,null,null,0,0,0,0,0,23.146367965474688]
[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.166183577153298,32.76002528951021,33.493624415324646,33.62634398891268,33.559431796346516,33.592333264761216,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.166183577153298,null,null,null,null,null,null,0,0,0,0,0,32.76002528951021,33.493624415324646,33.62634398891268,33.559431796346516,33.592333264761216,null,null,null,null,null,null,null,null,null,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.888854751680439,12.215798257351652,null,null,0,0,0,2.5963815564409742E-2,-4.9614680198354577E-2,32.76002528951021]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6720134495294285,null,null,null,null,null,null,0,0,0,0,0,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2,null,null,null,null,null,null,null,null,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0311723376815163,-8.7186966619122224,null,null,0,0,0,-8.6865954078945151E-3,4.6683212382793826E-2,-7.6233966686422088]
[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.4980704041784932E-2,-4.2453450696853169E-2,0,-8.9410044879364233E-4,-1.1322497084931879E-14,-9.5150041012734233E-4,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-7.5161784964738076E-2,null,null,null,null,null,null,0,0,0,0,1.810809229531446E-4,-4.2453450696853169E-2,0,-8.9410044879364233E-4,-1.1322497084931879E-14,-9.5150041012734233E-4,null,null,null,null,null,null,null,null,null,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0555426041338927E-2,-3.7397847399837619E-2,null,null,0,0,0,-1.0688189065157644E-5,-3.7582856641947313E-2,-4.2453450696853169E-2]
[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.4191894235820843,25.094175170171148,28.16988212835254,33.61425641581156,33.566544424147644,33.617755820509124,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4190083426591311,null,null,null,null,null,null,0,0,0,0,1.8108092295321399E-4,25.094175170171148,28.16988212835254,33.61425641581156,33.566544424147644,33.617755820509124,null,null,null,null,null,null,null,null,null,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8782378400402617,3.4597037480395922,null,null,0,0,0,1.7266531967449872E-2,-4.0514324457507911E-2,25.094175170171148]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.936063724666667,3.4191894235820843,25.095021248709205,28.169882128352551,33.615150516260378,33.566544424147693,33.618707320919249,null,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9278643964516124,3.4190083426591311,null,null,null,null,null,null,0,0,0,8.1993282150545355E-3,1.8108092295321399E-4,25.095021248709205,28.169882128352551,33.615150516260378,33.566544424147693,33.618707320919249,null,null,null,null,null,null,null,null,null,null,null,9.2451910000000019,7.6683149999999998,7.1260718706666673,7.8782378400402591,3.4597037480395927,null,null,0,0,3.6097129333332312E-2,5.782588462640792E-2,-4.0514324457508355E-2,25.095021248709205]
[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,4.0559352658955383E-2,0,8.4607853805707123E-4,0,8.9410044881788053E-4,0,9.5150041012459496E-4,null,0.48074452245191246,-1.9743427372537425E-2,7.1767539387121104E-2,3.2360024443900848E-2,0,null,null,null,null,null,null,0,0,0,8.1993282150545355E-3,0,8.4607853805707123E-4,0,8.9410044881788053E-4,0,9.5150041012459496E-4,null,null,null,null,null,null,null,null,null,null,null,0.48074452245191246,-1.9743427372537425E-2,3.5670410053788792E-2,0,0,null,null,0,0,3.6097129333332312E-2,4.0559352658955383E-2,0,8.4607853805707123E-4]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56694477483866756,6.3392175926542995,0.12256656922668707,0.19326933150278758,-1.4193975042527951E-3,1.5256678112103295E-3,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.56696770952585429,null,null,null,null,null,null,null,null,0,0,2.2934687186726421E-5,6.3392175926542995,0.12256656922668707,0.19326933150278758,-1.4193975042527951E-3,1.5256678112103295E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.7738348687851122E-2,0.11111308489424854,-0.56085309706492548,null,null,0,0,0,2.4351980721213362E-3,-6.091677773742088E-3,6.3392175926542995]
[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,-5.1370185801875162E-3,0,-3.3716132621198278E-5,0,-2.6598846565509963E-5,0,null,null,null,2.5680641684827725E-3,-1.0121787854438031E-2,-4.0985379678375334E-3,null,null,null,null,null,null,null,null,0,0,-1.0384806123499828E-3,0,-3.3716132621198278E-5,0,-2.6598846565509963E-5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5680641684827725E-3,-5.0308025930460533E-3,0,null,null,0,0,0,-5.0909852613919776E-3,-5.1370185801875162E-3,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.6E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,null,null,null,0,0,-4.0000000000000001E-3,0.02,0.02,0.02,0.02,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,0,0,0,-7.000000000000001E-3,-4.0000000000000001E-3,0.02]
[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,-4.5729897627748983E-3,0.13003245090487384,2.9046182318817962E-3,1.0578987528334811E-3,3.170288808907018E-3,4.6822453638322922E-4,null,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-7.1959791746869454E-3,null,null,null,null,null,null,null,null,0,0,2.6229894119120471E-3,0.13003245090487384,2.9046182318817962E-3,1.0578987528334811E-3,3.170288808907018E-3,4.6822453638322922E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4424029232627585E-3,-6.5488424296296366E-4,-9.8101221851799418E-3,null,null,0,0,0,5.4102955783031249E-3,5.2371324224050435E-3,0.13003245090487384]
[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.56065478318162998,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.55826222666837877,null,null,null,null,null,null,0,0,0,0,-2.3925565132512094E-3,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2,null,null,null,null,null,null,null,null,null,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.12542739805823952,-0.55066321925010542,null,null,0,0,0,-4.2454916109675167E-3,-9.9915639315245608E-3,6.4892500435591733]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS",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,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,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.87150072575594,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,438.14900964875301,394.62195782906463,416.05585344925407,420.01513792898868,431.75109210864304,445.3048575247559,null,402.51128113785808,401.51958066989596,402.30309265804107,429.06264510671326,438.2122470737707,null,null,null,null,null,null,0,0,0,0,-6.3237425017689475E-2,394.62195782906463,416.05585344925407,420.01513792898868,431.75109210864304,445.3048575247559,null,null,null,null,null,null,null,null,null,null,null,402.55038396788387,401.35715209173736,402.44575702000884,427.86153868332752,441.07721967228571,null,null,-3.9102830025797175E-2,0.16242857815859679,-0.14266436196777477,1.2011064233857383,-2.9282100235326993,394.62195782906463]
[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.48682759609335,438.14900964875295,394.62111175052684,416.05487241020319,420.01424382853969,431.75109210864292,445.30388013292531,null,412.11372795000005,402.67729251000003,401.73341855999996,441.22900426640075,438.21224707377058,null,null,null,null,null,null,0,0,0,0.25782332969259869,-6.3237425017632631E-2,394.62111175052684,416.05487241020319,420.01424382853969,431.75109210864292,445.30388013292531,null,null,null,null,null,null,null,null,null,null,null,412.11372795000005,402.67729251000003,401.211340690003,427.86153868332764,441.07721967228537,null,null,0,0,0.52207786999696282,13.625288912765711,-2.9282100235324151,394.62111175052684]
[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.424182489380087,0,-8.460785377906177E-4,-9.8103905088464671E-4,-8.9410044898841079E-4,0,-9.7739183058820345E-4,null,9.6024468121419773,1.1577118401040707,-0.56967409804110503,12.166359159687488,0,null,null,null,null,null,null,0,0,0,0.25782332969259869,0,-8.460785377906177E-4,-9.8103905088464671E-4,-8.9410044898841079E-4,0,-9.7739183058820345E-4,null,null,null,null,null,null,null,null,null,null,null,9.5633439821161801,1.3201404182626675,-1.2344163300058426,0,0,null,null,3.9102830025797175E-2,-0.16242857815859679,0.66474223196473758,12.424182489380087,0,-8.460785377906177E-4]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.3358070144867247E-2,null,null,1.9513668221058378E-3,6.6515900416947327E-2,2.1177244501860315E-2,-9.9343033673823244E-2,5.4315010087385485E-2,9.5162330896458869E-3,2.7941740951342942E-2,3.1392544602301342E-2,null,null,null,1.9513668221058378E-3,6.6515900416947327E-2,2.1324629564948072E-2,null,null,null,null,null,null,null,null,0,0,-1.4738506308775712E-4,-9.9343033673823244E-2,5.4315010087385485E-2,9.5162330896458869E-3,2.7941740951342942E-2,3.1392544602301342E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7123097784556016E-3,6.3153310029940402E-2,3.088775174704228E-2,null,null,0,0,-7.6094295634976383E-4,3.3625903870069251E-3,-9.7105072451819652E-3,-9.9343033673823244E-2]
[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.89565699346538E-2,0,2.1440229592016443E-6,2.3579503635184479E-6,2.1287338675387813E-6,0,null,null,null,-2.883325984183741E-3,1.4160321121998679E-3,-2.8355670898969922E-2,null,null,null,null,null,null,null,null,0,0,-6.0089903568387795E-4,0,2.1440229592016443E-6,2.3579503635184479E-6,2.1287338675387813E-6,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.2891912138167797E-3,3.0672862329232352E-3,0,null,null,0,0,4.0586522963303876E-4,-1.6512541207233673E-3,-2.89565699346538E-2,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.6E-2,0.02,0.02,0.02,0.02,0.02,null,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,null,null,null,0,0,-4.0000000000000001E-3,0.02,0.02,0.02,0.02,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,0,0,0,-7.000000000000001E-3,-4.0000000000000001E-3,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,1.5997561098670676E-3,-2.2495148560157212E-3,8.6456006973401056E-4,-2.7908599853965071E-3,2.9841609985418634E-3,3.7886767132636404E-4,null,null,null,-1.2197712686397161E-3,-3.7993847002743535E-3,1.4232431148969854E-3,null,null,null,null,null,null,null,null,0,0,1.7651299497008222E-4,-2.2495148560157212E-3,8.6456006973401056E-4,-2.7908599853965071E-3,2.9841609985418634E-3,3.7886767132636404E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.5748489953564399E-3,-2.8263244387354211E-3,3.0600698733042227E-3,null,null,0,0,3.5507772671672377E-4,-9.7306026153893242E-4,-1.460313763437155E-3,-2.2495148560157212E-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,9.8204306770735827E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,1.4392201780875136E-2,null,null,null,null,null,null,0,0,0,0,-4.5717711038015529E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2,null,null,null,null,null,null,null,null,null,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.3394271824128216E-2,5.3947821620346503E-2,null,null,0,0,0,-6.2617239952553749E-3,-4.4127390943272921E-2,-8.1592548529838965E-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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F'Cast","F'Cast"]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23","2023-24","2024-25","2025-26",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.09E-2,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.0999999999999999E-2,null,null,null,null,null,null,0,0,0,0,-9.9999999999999395E-5,2.5473591894196179E-2,2.4552521725200425E-2,2.3835774205660947E-2,2.3285646467785096E-2,2.2870248718164728E-2,null,null,null,null,null,null,null,null,null,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,0,0,0,0,-6.9999999999999923E-4,2.5473591894196179E-2]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,0.17,0.17,0.17,0.17,0.17,null,0.2,0.19,0.19,0.19,0.17,null,null,null,null,null,null,0,0,0,0,0,0.17,0.17,0.17,0.17,0.17,null,null,null,null,null,null,null,null,null,null,null,0.2,0.19,0.19,0.19,0.17,null,null,0,0,0,0,0,0.17]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.517784630239372,0,0,0,0,0,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-20.317784630239373,null,null,null,null,null,null,0,0,0,0,-0.19999999999999929,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-19.801908858477702,null,null,0,0,0,0,-0.71587577176167017,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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.3810614948941407,-3.7345807881634583,null,null,0,0,0,-0.4447000000000001,1.237802484872061,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,-25.939431070936596,null,null,null,null,null,null,0,0,0,0,-0.19999999999999929,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.364818468356205,-26.661357784046988,null,null,0,0,0,-0.44470000000000098,0.52192671311039263,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,0,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,-0.45645559543425729,-0.45645559543425729,0,0,0,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,-0.45645559543425729,null,null,null,null,null,null,0,0,0,0,0,-0.45645559543425729,-0.45645559543425729,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,0.39634638830384161,null,null,0,0,0,0,-0.8528019837380989,-0.45645559543425729]
[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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,0,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,0,0,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,-0.65988618568792357,-0.65988618568792357,0,0,0,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.65988618568792357,null,null,null,null,null,null,0,0,0,0,0,-0.65988618568792357,-0.65988618568792357,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.66045500523311962,null,null,0,0,0,0,5.6881954519605316E-4,-0.65988618568792357]
[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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,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,null,null,null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,0,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,-0.65988618568792357,-0.65988618568792357,0,0,0,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8095534522830117,null,null,null,null,null,null,0,0,0,0,0,-0.65988618568792357,-0.65988618568792357,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8101222718282077,null,null,0,0,0,0,5.6881954519605316E-4,-0.65988618568792357]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.208814745762975,null,null,null,null,null,null,0,0,0,0,-0.19999999999999929,-1.116341781122181,-1.116341781122181,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,-0.33030645108250667,-1.116341781122181]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.408814745762974,-1.116341781122181,-1.116341781122181,0,0,0,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.208814745762975,null,null,null,null,null,null,0,0,0,0,-0.19999999999999929,-1.116341781122181,-1.116341781122181,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,-0.33030645108250667,-1.116341781122181]
[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,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,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES",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,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,null,null,null,null,null,null,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,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,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,7.9449653646932461E-3,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,0,0,0,0,7.9449653646932461E-3,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":108,"n_cols":13,"rows_kept":108,"cut":false,"hidden":true,"merged":[[35,1,35,2],[17,1,17,2],[78,1,78,12]]}
[]
[null,"MOD186 Reconciliation - Sept 2019 to Dec 2019"]
[]
[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.958149478721,441.63125541642984,441.63125541642984,441.63125541642984,441.63125541642984,0,0]
[]
[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.0999999999999999E-2,0,0,0,0,0]
[null,"Cost of debt %   December",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 £ movement",null,0,0,0,0,-0.19999999999999929,0,0,0,0,0]
[]
[null,"Totex Incentive",null,0,0,0,0,0,-0.45645559543425729,-0.45645559543425729,0,0,0]
[]
[null,"Pension deficit valuation",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Tax trigger",null,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Repex Tier 2a",null,0,0,0,0,0,-0.65988618568792357,-0.65988618568792357,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.19999999999999929,-1.116341781122181,-1.116341781122181,0,0,0]
[]
[null,"Change in Inflation %"]
[null,"September (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,0,0,0,0,0]
[null,"December (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.7249999999999996E-2,2.849999999999997E-2,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2]
[null,"Difference",null,0,0,0,0,0,2.0250000000000101E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2,2.0999999999999908E-2]
[null,"Cumulative change in inflation",null,0,0,0,0,0,2.0250000000000101E-2,4.1250000000000009E-2,6.2249999999999917E-2,8.3249999999999824E-2,0.10424999999999973]
[]
[null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,0,0,0,0,-8.8471678742497062E-2,434.95647932402994,441.40376204291402,453.68127468114022,465.35189891716647,478.92227915528252]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 18/19)",null,0,0,0,0,0,-2.4291824635517685,-5.3088989111343195E-14,0,0,0]
[]
[null,"Total base revenue changes",null,0,0,0,0,-0.28847167874249635,431.41095507935597,440.28742026179179,453.68127468114022,465.35189891716647,478.92227915528252]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,-6.2159962917647249E-3,3.205982088021154,3.2587242087620125,0,0,0]
[null,"Shrinkage/Leakage",null,0,0,0,0,0,5.0081722156251054,5.3770861796452261,0,0,0]
[null,"DRS",null,0,0,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,0,1.1365941270394262,0.2677790543281206,0,0,0]
[null,"Total",null,0,0,0,0,-6.2159962917647249E-3,9.3507484306856856,8.9035894427353579,0,0,0]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,0,4.9058935428152459,4.5152464233169312,0,0,0]
[null,"License Fee",null,0,0,0,0,0,0.35010962778984267,0.35796818576983019,0,0,0]
[null,"Pension Deficit",null,0,0,0,0,0,2.0513412006289995,2.0973855892499156,0,0,1.4609941867111868E-15]
[null,"Exit Capacity",null,0,0,0,0,0,-7.6233966686422088,-5.3237422869721049,-1.1193472652321361E-2,7.112627801141135E-3,2.6374056158032642E-2]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,0,0,0,-7.6826802204551212,-6.6121320382852202,-4.0686863687504307E-2,-4.241720253230883E-2,-2.6039866175740063E-2]
[null,"SOLR",null,null,null,null,null,0.234705]
[null,"Total",null,0,0,0,0,0.234705,-7.9987325178632416,-4.9652741269206482,-5.1880336339825667E-2,-3.5304574731167694E-2,3.3418998229403987E-4]
[]
[null,"Network Innovation",null,0,0,0,0,-1.8173715760778641E-3,0,0,0,0,0]
[]
[null,"K factor",null,0,0,0,0,-1.2562974842867947E-3,-13.046837992942569,1.1941043080997777E-13,-1.8020925018778287E-13,1.0421903553867473E-3,1.8147805349144622E-13]
[]
[null,"DECEMBER",null,411.27572761540614,409.2076390972685,409.39349411865396,436.958149478721,441.56819907233523,419.71613299923575,444.2257355776066,453.62939434480023,465.31763653279069,478.92261334526501]
[null,"Difference",null,0,0,0,0,-6.305634409460481E-2,-21.915122417194084,2.5944801611767616,11.998138928370395,465.31763653279069,478.92261334526501]
[]
[null,"Memo:"]
[null,"In year (under)/over collection",null,null,null,-0.49790655865399458,12.464741842038961,0]
[]
[null,"SOQ Assumption SEPTEMBER",null,null,null,null,null,-2.0000000000000004E-2]
[null,"SOQ Assumption DECEMBER",null,null,null,null,null,-1.6E-2,-0.02,-0.02,-1.9999999999999997E-2,-0.02,-1.9999999999999997E-2]
[null,"SOQ Assumption","Difference",0,0,0,0,4.0000000000000036E-3,-0.02,-0.02,-1.9999999999999997E-2,-0.02,-1.9999999999999997E-2]
[]
[null,"LDZ Price Change","September",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,1.4392201780875136E-2,0,0,0,0,0]
[null,"LDZ Price Change","December",4.2622465416668323E-2,-3.5093186811680235E-2,-1.4016882327073944E-2,7.7132547828872841E-2,9.8204306770735827E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2]
[null,"LDZ PRICE CHANGE %","Difference",0,0,0,0,-4.5717711038015529E-3,-8.1592548529838965E-2,7.5181714180078699E-2,2.6727731054612899E-2,5.0928030683752346E-2,5.1771412273627707E-2]
[null,"Exit Capacity Price Change","September",411.27572761540614,409.2076390972685,409.39349411865396,0.121181906447272,-0.55826222666837877,0,0,0,0,0]
[null,"Exit Capacity Price Change","December",0,0,0,0.121181906447272,-0.56065478318162998,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2]
[null,"LDZ PRICE CHANGE %","Difference",-411.27572761540614,-409.2076390972685,-409.39349411865396,0,-2.3925565132512094E-3,6.4892500435591733,0.14543747132594767,0.21432723025562106,2.1724292458088712E-2,2.1993892347593559E-2]
[]
[null,"GD2 data reflects our December 2019 business plan bid submission per Appendix A33, with 2 year lagged entries for GD1 included aswell.   Final GD2 data published by Ofgem won't be available until c. Q4 2020"]
[]
[]
[null,"CUSTOMER BILL IMPACT",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"Customer Bill Impact"]
[]
[null,"Assumed TDCV KWh","September",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Average Customer Bill","September (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Assumed TDCV KWh","December",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Average Customer Bill","December (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Difference in Customer Bill £",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"Assumed TDCV KWh","Variance"]
[null,"Average Customer Bill","Variance"]
[]
[]
[]
[]
[null,"Checks",null,0,0,0,0,0]
[null,"Checks",null,0,0,0,0,0]
[null,"Checks",null,0,0,0,0,1.1368683772161603E-13]
[]
[]
[null,"CALENDAR YEAR BASIS VS. 2017 BUDGET PROCESS",null,null,2017,2018,2019,2020]
[null,"Latest Mod186 data above",null,null,413.42078950999996,409.64380349999999,438.24448434979092,444.56583336631394]
[null,"Budget Data",null,null,413.45491335157914,406.8386478036482,426.42511686815283,440.71219660975794]
[null,"Variance",null,null,-3.4123841579173586E-2,2.8051556963517896,11.819367481638096,3.8536367565559999]