{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["BBPTACShadowWks0001","Mod186 Statement","Movement Sept to Dec","Memo Move vs Nov Indicatives","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":69,"comments":0,"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":"BBPTACShadowWks0001","index":0,"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":1,"n_rows":164,"n_cols":19,"rows_kept":164,"cut":false,"hidden":false,"merged":[[112,17,116,18],[1,3,1,18],[5,17,5,18],[151,3,151,4],[37,17,37,18],[38,17,38,18],[35,17,35,18],[30,17,30,18],[130,3,130,4],[36,17,36,18],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[93,17,93,18],[108,3,108,4],[27,17,27,18],[31,17,31,18],[34,17,34,18],[6,17,8,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[17,17,17,18],[18,17,18,18],[20,17,20,18],[21,17,21,18],[22,17,22,18],[26,17,26,18],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,"Published:",null,"2017-12-14T10:44:10.210",null,"RIIO-GD2"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[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.3550871234589861,1.3981111396288088]
[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,null,null,null,null,"Prices will be set with an assumed RPI rate of 3.3% for 18/19 regulatory year"]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,null,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.5500000000000087E-2,3.3250000000000002E-2,3.125E-2,3.1749999999999945E-2]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,1.5000000000000846E-3,-5.0000000000001432E-5,"","",null,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,null,null,"Per final proposal data"]
[null,6,null,"Price Control Financial Model Iteration Adjustment (09/10 Prices)","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.171199014605822,-29.374309111201036,null,null,"14/15 - 17/18 MOD is actual, forecast thereafter."]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.21451187922461867,-5.6274618773451616E-14,null,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.616406495412889,98.926361079340722,111.59154461404984,124.0685889596042]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,425.85679739767863,435.71168710371381]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.7828467824603411,5.4642957339676093]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.167274275113737E-2,-6.3552377470316349E-2]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2674586565960988,2.0315231835774954]
[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.87532900000000002,0,0,null,null,"£0.9m is an indicative view of the SOLR claim for Co-op Energy - amount to be finalised by Ofgem Jan 2018"]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.4803253264025198,7.9886326963053023,7.4322665400747887]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1647606123168193,1.8567091697205527,null,null,"Data uses finalised July 2017 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.0159298389659304,-8.6936539894059699,null,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.8511692266491111,-6.8369448196854172]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.94290432123618673,0.95957166667750993,null,null,"13/14 - 16/17 actual volume impact - and assumed this level of outperformance will continue"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-7.2138910526559821,-7.4197454368429039,null,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.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-6.2709867314197956,-6.4601737701653938]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,3.1086732937949924,3.2190879613745476,null,null,"Assumes customer service scores and stakeholder results will continue at same rate as 16/17"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2989426966198909,5.4194757396761357,null,null,"13/14 - 16/17 actual volume impact - and assumed this level of outperformance will continue"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,"DRS from 11/12, 12/13,14/15 - forecast thereafter"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.5007691837990245,2.6079134189917976,2.6828978236053755,2.7449836287533973,null,null,"Actual spend 13/14 - 16/17, 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.4989282987774661,-10.417966175725102,-1.2276556354990138,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,409.62369148062174,436.3861323144364,441.23038238374193,441.23038238374193]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.36082499676377,409.62369148062174,436.38613022971555,441.23051901805951,441.23052728578222]
[null,28,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,10.044088504568094,1.1791596938548423,0,-2.0847208475061052E-6,1.366343175845941E-4,1.449020402901624E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,1.0802687783812992E-3,6.5334211351592897E-2,1.1100834125074899E-2,null,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.8817510505558313E-3,0,4.7772389934792141E-9,null,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,-6.4711587792203326E-3,0.02,0.02,null,null,"Latest view on how much load factors could move capacity levels"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.5590503172216883E-3,-1.8441702659258256E-3,8.4330769693173289E-3]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1350878274177234E-2,4.262170956228286E-2,-3.5092500034003368E-2,-9.8316913686165523E-3,8.3490041085667072E-2,3.9533915871631221E-2,1.9709848909822386E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,0,0,0,0,0]
[]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,0,0,0,0,0]
[]
[null,null,null,"Average AQ","NE",null,null,15078.02270927113,14890.239844223981,14300.054833420678,14173.317543880596,"","","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,"","","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,"","","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,"","","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,"","","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,"","","","",""]
[]
[null,null,null,"Unit Rates","Commodity",null,null,2.7799999999999998E-2,2.92E-2,3.1199999999999999E-2,3.2300000000000002E-2,3.1300000000000001E-2,3.1E-2,3.3599999999999998E-2,3.5099999999999999E-2,3.5099999999999999E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19700000000000001,0.21329999999999999,0.22270000000000001,0.22270000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1052,0.1139,0.11890000000000001,0.11890000000000001]
[]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,"","","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,"","","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,"","","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,0,0,0,0,0]
[]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.21690097198598,411.31483044543188,409.18166530290893,409.62369148062174,436.38613231443628,441.23038238374187,441.23038238374187]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,129.12132406333461,129.26080979834347,137.70596286518648,139.23461391698663,139.23461391698663]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (16/17 Prices)","16/17 prices",null,null,132.54664381436916,135.50737749986558,137.26596764323389,129.79446543550341,124.69466350877316,120.81235640996123,124.80536866669924,122.30754772201317,119.52850986759168]
[null,37,null,"% movement in domestic customer bill - (16/17 prices)",null,null,null,null,2.2337296519125083E-2,1.2977818446601175E-2,-5.4430842079877806E-2,-3.9291366620438861E-2,-3.113450880388946E-2,3.3051356462150627E-2,-2.0013729949042935E-2,-2.2721720009772683E-2]
[]
[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]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.884114072735308,12.261434694544652]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0159298389659304,-8.6936539894059699,null,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.3134829247637538E-2,2.1301451072617094E-4]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8913190630170149,3.5679937196494085]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6658374906666671,7.0901982854176913,7.8910929375571497,3.5676784705127327]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-2.2220936705870109E-2,-2.0317519518719962E-4,-2.2612545986522292E-4,-3.1524913667579924E-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.11295800482571083,-0.5478583882926551]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.8903183964828832E-3,2.865496351875647E-5,2.8654963518706146E-5]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-6.4711587792203318E-3,0.02,0.02]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,4.7367688820482926E-4,-4.1815370752855407E-4,-9.5648703748205839E-3]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.0845512182383741E-2,0.13256850608170104,-0.53739460370395697]
[]
[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.68036008213767,402.55038396788387,401.49360687553639,402.53329002000885,428.49481325141937,437.66238866409253]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.69498750609711,402.53349319520407,428.49503729215837,437.66284054754675]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,3.013229155623776,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.2013806305607204,2.0317519522450311E-4,2.2404073899906507E-4,4.5188345421820486E-4]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,2.5895384799856647E-3,6.4495344546832589E-2,2.1394834031034371E-2]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.9922783575807976E-3,-5.0474134751539135E-7,-5.2285519467328806E-7]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-6.4711587792203318E-3,0.02,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.7069593445789531E-3,-1.9086199949873463E-3,2.8425344234231133E-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,-8.5808580013944178E-3,8.2586219810497727E-2,4.423684559926281E-2,1.9704202015741235E-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,"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",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,2.0299999999999999E-2,1.6E-2,1.15E-2,null,null,"Internal NGN Treasury view on IBOXX 10 year rate","Annual"]
[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]
[]
[null,60,null,"Cost of Debt Adjustment (*)","CDE £ impact",null,null,null,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.679115855350643,-19.910873115125526,null,null,"Cash Impact of the above vs. allowance","Annual"]
[null,61,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5874860939472359,-1.3812193529385581,-3.9035815265714975,null,null,"Forecast impact of long term change in Corp. Tax rates","At any time"]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","At any time"]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.8718681374057837,-3.0008681374058597,-3.1248681374058265,null,null,"31.03.2016 valuation impact, and forecast therafter","3-yearly review"]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","3-yearly review"]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-14.061951034719643,-20.061203345695063,-26.939322779102849]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844,null,null,null,null,null,null,null,null,"Revenue impact via RAV will be over 45 years","One-off"]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,null,17.398062412967949,null,null,null,null,null,null,null,null,"This amount is to be spread over the 8 years of RIIO-GD1","One-off"]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.3701493322271574,-1.5861707889526353,null,null,"Forecasted IQI impact from Totex outperformance"]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,73,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","Reopener -> Revenue Driver"]
[null,76,null,"Large Load Connections","IAELLC",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,"Change in allowance directed by Ofgem","1 Reopener (Flexible)"]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,"Change in allowance directed by Ofgem","1 Reopener (Flexible)"]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.73231837993037918,-0.69577364944135256,null,null,"13/14 - 16/17 actual, then assumes  50% of allowance","Annual"]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,null,null,"No current change in revenue allowance forecast","Annual"]
[null,82,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,"As per Ofgem direction from shrinkage model changes","Annual"]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.5486037652912925,-2.8454409160364409]
[]
[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.244510433430108,-22.171199014605822,-29.374309111201036]
[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.244510433430108,-22.171199014605822,-29.374309111201036]
[null,null,null,"* Note the cash impact of cost of debt in 19/20 assumes that Ofgem will restate 18/19 to 1.93% which was our internal forecast - 18/19 data was impacted by Bank of England data not being available."]
[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,-3.1453982379460399E-2,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]

{"sheet":"Movement Sept to Dec","index":2,"n_rows":213,"n_cols":32,"rows_kept":213,"cut":false,"hidden":false,"merged":[[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],[148,3,148,4],[150,3,150,4],[151,3,151,4],[153,3,153,4],[1,10,1,15],[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],[1,24,1,29],[1,31,1,39],[45,3,45,4],[46,3,46,4],[7,3,7,4],[1,3,1,4],[1,17,1,22],[3,31,5,39]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,"SEPTEMBER MOD186",null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[]
[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",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.3550871234589861,1.3981111396288088,null,null,1.2327329838381795,1.2709189417960116,1.3140249519157237,1.3534457004731957,1.3940490714873917,null,null,0,0,-1.0746221612567552E-6,1.6414229857903972E-3,4.0620681414171855E-3]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,0,0,null,null,2.3E-2,3.4000000000000002E-2,null,null,null,null,null,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.5500000000000087E-2,3.3250000000000002E-2,3.125E-2,3.1749999999999945E-2,null,null,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2,null,null,0,5.0000000000016698E-4,-4.9999999999994493E-4,1.2499999999999734E-3,1.7499999999999183E-3]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,1.5000000000000846E-3,-5.0000000000001432E-5,"","",null,null,-1.5725023416449449E-3,9.9999999999991762E-4,"","","",null,null,0,5.0000000000016698E-4,"","",""]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,0,0,0,0,0]
[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.171199014605822,-29.374309111201036,null,null,-6.2324478434481421,-11.079016524139888,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.79948548516229323,-1.3330298386633359,-1.5323562596577815,null,null,"Movement in 18/19 and 19/20 is largely cost of debt related as detailed below in table 5"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.21451187922461867,-5.6274618773451616E-14,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,5.3890861274262444E-2,5.6268108628512755E-14,null,null,0,0,0,0.16062101795035622,-1.1254272740196438E-13,null,null,"Refective of movement in RPI between September and December"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.926361079340722,111.59154461404984,124.0685889596042,null,null,76.602895594612164,84.616406495412889,98.675641224536605,111.49008526137345,123.40649702044658,null,null,0,0,0.2507198548041174,0.10145935267638606,0.66209193915761944]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,425.85679739767863,435.71168710371381,null,null,405.74788540780747,396.94748949190864,412.90430561111259,426.92774686571522,436.58195142421414,null,null,0,0,1.0502053399663964,-1.0709494680365879,-0.87026432050032554]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.7828467824603411,5.4642957339676093,null,null,0.45240792338436564,0.96340416482706637,0.42583303954468199,5.8069421677628705,5.981150432795757,null,null,0,0,-3.48250328630062E-7,-2.4095385302529415E-2,-0.51685469882814772,null,null,"We have reduced the growth to CPI levels in line with November budget decision"]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.167274275113737E-2,-6.3552377470316349E-2,null,null,0.21262510901874174,0.24439389996628133,-5.9937766987509522E-2,-6.1674099920134638E-2,-6.3524322917738685E-2,null,null,0,0,4.9017678548091137E-8,1.3571689972680101E-6,-2.8054552577663761E-5]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2674586565960988,2.0315231835774954,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391031842379761,2.2715064366794158,2.339651629779798,null,null,0,0,-1.8311599787601551E-6,-4.0477800833169653E-3,-0.30812844620230262,null,null,"Reflects the indicative NTS pricing statement which has costs for 18/19 £0.3m lower"]
[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.87532900000000002,0,0,null,null,-0.15071466,0,0,0,0,null,null,0,0,0.87532900000000002,0,0,null,null,"£0.9m is an indicative view of the SOLR claim for Co-op Energy - amount to be finalised by Ofgem Jan 2018"]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.4803253264025198,7.9886326963053023,7.4322665400747887,null,null,0.55789903343100389,3.5055935921424757,2.6049984567951485,8.0167745045221519,8.2572777396578161,null,null,0,0,0.87532686960737127,-2.814180821684964E-2,-0.82501119958302738]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1647606123168193,1.8567091697205527,null,null,0.67553374772655639,3.3793563036027767,1.9310260127886272,2.165854051077365,1.8558880265214446,null,null,0,0,-1.5792115244384064E-6,-1.0934387605456841E-3,8.2114319910808753E-4]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0159298389659304,-8.6936539894059699,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,0,0,3.2180409936799492E-6,-4.1483319477384484E-3,-1.1009182827313202,null,null,"Reflects the indicative NTS pricing statement which has lower unit rates from Oct 2018 onwards"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8511692266491111,-6.8369448196854172,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039255584813738,-1.845927455940827,-5.7368476801532049,null,null,0,0,1.6388294694635874E-6,-5.2417707082841325E-3,-1.1000971395322123]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.94290432123618673,0.95957166667750993,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.92964166347367816,0.93437767594001142,null,null,0,0,0,1.3262657762508567E-2,2.5193990737498506E-2]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-7.2138910526559821,-7.4197454368429039,null,null,-5.7074720867072717,-7.208780850335943,-7.3099516506447442,-7.2917508127408812,-7.6350198214282115,null,null,0,0,5.9781483070509012E-6,7.7859760084899143E-2,0.21527438458530757,null,null,"Impact of latest UK Market Gas price forecast included"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-6.2709867314197956,-6.4601737701653938,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481471132640724,-6.3621091492672033,-6.7006421454882004,null,null,0,0,5.9781483070509012E-6,9.1122417847407711E-2,0.24046837532280652]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,3.1086732937949924,3.2190879613745476,null,null,2.7280489896020739,3.366405616377834,3.4091212241289091,3.0983210477234864,3.1925927538746204,null,null,0,0,2.2351992399647358E-3,1.0352246071505977E-2,2.6495207499927176E-2]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2989426966198909,5.4194757396761357,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2963840569788383,5.4855713933858627,null,null,0,0,0,2.5586396410526291E-3,-6.6095653709727031E-2]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,0.8,0,0,0.8,0,null,null,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.5007691837990245,2.6079134189917976,2.6828978236053755,2.7449836287533973,null,null,2.4086934000000002,2.5007691837990245,2.6012971253500092,2.6896448052540061,2.7504662939725493,null,null,0,0,6.6162936417883955E-3,-6.7469816486305234E-3,-5.482665219151972E-3]
[null,25,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.2276556354990138,0,null,null,2.7784430349248272,6.4989282987774661,-10.411240613350806,-0.6526168685756718,-1.1842336658238662E-13,null,null,0,0,-6.7255623742958903E-3,-0.57503876692334199,1.1842336658238662E-13]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,409.62369148062174,436.3861323144364,441.23038238374193,441.23038238374193,null,411.31483044543194,409.18166530290893,407.69602572356268,437.96821780641005,443.83036977946341,443.83036977946341,null,0,0,1.9276657570590601,-1.5820854919736576,-2.5999873957214845,-2.5999873957214845]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.36082499676377,409.62369148062174,436.38613022971555,441.23051901805951,441.23052728578222,null,421.35891895000003,409.81056549398045,407.69602572356285,437.96821780641039,443.83036977946369,443.83036977946352,null,0,0.55025950278331948,1.9276657570588895,-1.5820875766948461,-2.5998507614041841,-2.599842493681308]
[null,28,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,10.044088504568094,1.1791596938548423,0,-2.0847208475061052E-6,1.366343175845941E-4,1.449020402901624E-4,null,10.044088504568094,0.62890019107152284,0,0,0,0,null,0,0.55025950278331948,0,-2.0847208475061052E-6,1.366343175845941E-4,null,null,"Post Nexus Capacity Invoices have been c.£0.1m higher per month which we have forecast to continue"]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,1.0802687783812992E-3,6.5334211351592897E-2,1.1100834125074899E-2,null,null,null,null,-3.6307579379111221E-3,7.4251869463582532E-2,1.3384879849077436E-2,null,null,null,null,4.7110267162924213E-3,-8.9176581119896348E-3,-2.2840457240025369E-3]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-2.8817510505558313E-3,0,4.7772389934792141E-9,null,null,null,null,-1.5369706035238914E-3,0,0,null,null,null,null,-1.34478044703194E-3,0,4.7772389934792141E-9]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-6.4711587792203326E-3,0.02,0.02,null,null,null,null,-7.4999999999999997E-3,2.0000000000000004E-2,2.0000000000000004E-2,null,null,null,null,1.0288412207796671E-3,0,0,null,null,"December capacity change based on Xoserve snapshot report"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.5590503172216883E-3,-1.8441702659258256E-3,8.4330769693173289E-3,null,null,null,null,-4.1656217812578548E-4,-1.7084668933655262E-3,5.9803391185916932E-3,null,null,null,null,-1.1424881390959029E-3,-1.3570337256029949E-4,2.4527378507256357E-3]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1350878274177234E-2,4.262170956228286E-2,-3.5092500034003368E-2,-9.8316913686165523E-3,8.3490041085667072E-2,3.9533915871631221E-2,1.9709848909822386E-2,null,4.262170956228286E-2,-3.5098650983371234E-2,-1.3084290719560798E-2,9.2543402570217009E-2,3.9365218967669133E-2,1.9707241358115791E-2,null,0,6.150949367865477E-6,3.252599350944246E-3,-9.0533614845499377E-3,1.6869690396208864E-4,2.6075517065952958E-6]
[]
[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",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,1340114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14173.317543880596,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,"","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,"","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"","","","",""]
[]
[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.3700000000000001E-2,3.5200000000000002E-2,3.5200000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20530000000000001,0.19869999999999999,0.19639999999999999,0.21440000000000001,0.2238,0.2238]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1048,0.1144,0.11940000000000001,0.11940000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5115004355034047,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,"","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543188,409.18166530290893,407.69602572356274,437.96821780641005,443.83036977946347,443.83036977946347]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,"","","","","",null,13967.493608369672,"","","","","",null,0,0,0,0,0,0]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,129.12132406333461,129.26080979834347,137.70596286518648,139.23461391698663,139.23461391698663,null,129.79446543550341,129.12132406333461,128.65251579103807,138.2052055997157,140.05506567118493,140.05506567118493,null,0,0,0.60829400730540328,-0.49924273452921852,-0.8204517541983023,-0.8204517541983023]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (16/17 Prices)","16/17 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,124.69466350877316,120.81235640996123,124.80536866669924,122.30754772201317,119.52850986759168,null,129.79446543550341,124.75490247665179,120.24372200647292,125.40975063758528,123.386742797837,120.6716310981291,null,0,-6.0238967878632366E-2,0.56863440348830352,-0.60438197088603829,-1.0791950758238329,-1.1431212305374174]
[null,37,null,"% movement in domestic customer bill - (16/17 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877806E-2,-3.9291366620438861E-2,-3.113450880388946E-2,3.3051356462150627E-2,-2.0013729949042935E-2,-2.2721720009772683E-2,null,-5.4430842079877806E-2,-3.8827256169530977E-2,-3.6160346251909004E-2,4.2962980061730383E-2,-1.6131184612546257E-2,-2.2004889975550168E-2,null,0,-4.6411045090788416E-4,5.0258374480195434E-3,-9.9116235995797553E-3,-3.8825453364966789E-3,-7.1683003422251534E-4]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,8.77,8.77,8.77,8.77,8.77,null,null,0,0,0,0,0,0]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.884114072735308,12.261434694544652,null,null,10.811068268260835,11.145959119551021,11.523998828300895,11.869718793149925,12.225810356944423,null,null,0,0,-9.4244363531004183E-6,1.4395279585382781E-2,3.5624337600228984E-2,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0159298389659304,-8.6936539894059699,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,0,0,3.2180409936799492E-6,-4.1483319477384484E-3,-1.1009182827313202,0]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.3134829247637538E-2,2.1301451072617094E-4,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,4.6425642213681218E-3,-6.4762778599742681E-15,null,null,0,0,-3.2190848083235579E-4,1.8492265026269418E-2,2.130145107326472E-4,0]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8913190630170149,3.5679937196494085,null,null,8.7644464775480895,7.6880584273725372,7.0907295754890702,7.862579850353101,4.6330746502697675,null,null,0,0,-3.2811487619177626E-4,2.8739212663913882E-2,-1.065080930620359,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6658374906666671,7.0901982854176913,7.8910929375571497,3.5676784705127327,null,null,9.2451910000000019,7.683584578064516,7.0907295754890765,7.8625798503531126,4.6330746502697675,null,null,0,-1.7747087397848915E-2,-5.3129007138519313E-4,2.8513087204037113E-2,-1.0653961797570348,0]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-2.2220936705870109E-2,-2.0317519518719962E-4,-2.2612545986522292E-4,-3.1524913667579924E-4,null,null,0.48074452245191246,-4.4738493080211938E-3,0,1.1546319456101628E-14,0,null,null,0,-1.7747087397848915E-2,-2.0317519518719962E-4,-2.2612545987676924E-4,-3.1524913667579924E-4,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11295800482571083,-0.5478583882926551,null,null,null,null,-7.7695670178147935E-2,0.1088534355522639,-0.41074370773332103,null,null,null,null,-4.2678509703186762E-5,4.1045692734469341E-3,-0.13711468055933407,0]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.8903183964828832E-3,2.865496351875647E-5,2.8654963518706146E-5,null,null,null,null,5.8192186626632755E-4,0,-1.46851538246484E-15,null,null,null,null,2.3083965302165554E-3,2.865496351875647E-5,2.8654963520174661E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-6.4711587792203318E-3,0.02,0.02,null,null,null,null,-7.4999999999999997E-3,0.02,0.02,null,null,null,null,1.0288412207796679E-3,0,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,4.7367688820482926E-4,-4.1815370752855407E-4,-9.5648703748205839E-3,null,null,null,null,-2.5117254049654338E-4,-4.6182192291089816E-4,-6.3270136264644405E-3,null,null,null,null,7.2484942870137264E-4,4.3668215382344083E-5,-3.2378567483561434E-3,0]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.0845512182383741E-2,0.13256850608170104,-0.53739460370395697,null,null,0.38917876005399071,-0.17690890802795603,-8.4864920852378151E-2,0.128391613629353,-0.39707072135978694,null,null,0,0,4.0194086699944093E-3,4.1768924523480355E-3,-0.14032388234417004,0]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.55038396788387,401.49360687553639,402.53329002000885,428.49481325141937,437.66238866409253,null,null,402.55038396788387,401.49360687553639,400.60529614807359,430.10563795605697,439.19729512919366,null,null,0,0,1.9279938719352572,-1.6108247046375936,-1.5349064651011304,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.69498750609711,402.53349319520407,428.49503729215837,437.66284054754675,null,null,412.11372795000005,402.12698091591591,400.60529614807376,430.10563795605731,439.19729512919395,null,null,0,0.56800659018119859,1.9281970471303111,-1.6106006638989356,-1.5344545816471964,0]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.2013806305607204,2.0317519522450311E-4,2.2404073899906507E-4,4.5188345421820486E-4,null,null,9.5633439821161801,0.63337404037952183,0,0,0,null,null,0,0.56800659018119859,2.0317519522450311E-4,2.2404073899906507E-4,4.5188345421820486E-4,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,2.5895384799856647E-3,6.4495344546832589E-2,2.1394834031034371E-2,null,null,null,null,-2.2125152486878186E-3,7.3639420376208298E-2,2.113819576125997E-2,null,null,null,null,4.8020537286734832E-3,-9.1440758293757085E-3,2.5663826977440074E-4,0]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.9922783575807976E-3,-5.0474134751539135E-7,-5.2285519467328806E-7,null,null,null,null,-1.5775445225853092E-3,0,0,null,null,null,null,-1.4147338349954884E-3,-5.0474134751539135E-7,-5.2285519467328806E-7,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-6.4711587792203318E-3,0.02,0.02,null,null,null,null,-7.4999999999999997E-3,0.02,0.02,null,null,null,null,1.0288412207796679E-3,0,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.7069593445789531E-3,-1.9086199949873463E-3,2.8425344234231133E-3,null,null,null,null,-5.2371095785329683E-4,-1.7513438400424096E-3,2.8309684356323563E-3,null,null,null,null,-1.1832483867256563E-3,-1.5727615494493669E-4,1.1565987790757015E-5,0]
[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,-8.5808580013944178E-3,8.2586219810497727E-2,4.423684559926281E-2,1.9704202015741235E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.1813770729126424E-2,9.1888076536165889E-2,4.3969164196892327E-2,1.969992454579032E-2,null,0,0,3.2329127277320058E-3,-9.3018567256681617E-3,2.6768140237048293E-4,4.2774699509154357E-6]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",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,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,2.0299999999999999E-2,1.6E-2,1.15E-2,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2,null,null,0,0,9.9999999999999742E-4,0,0,null,null,"Reflects the decision by Ofgem to include the rate as at May 2017"]
[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,null,null,0.2,0.19,0.19,0.19,0.18,null,null,0,0,0,0,-9.9999999999999811E-3,null,null,"Corrected 20/21 position to latest CT rates published @ 17% for 20/21 (Sept version @ 18%)"]
[]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.679115855350643,-19.910873115125526,null,null,-5.5790833627772258,-7.3944719953437357,-10.686093517544123,-14.552293314851397,-19.908210400401288,null,null,0,0,1.0834967141774996,-1.126822540499246,-2.6627147242379579E-3,null,null,"Our £ forecast for 19/20 assumes that Ofgem will restate the cod for 18/19 to 1.93% during the Nov 18 AIP"]
[null,61,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5874860939472359,-1.3812193529385581,-3.9035815265714975,null,null,-0.20009415299585953,-1.5562531640979955,-1.3476202057198634,-1.3790617652316541,-2.7013801056288003,null,null,0,0,-0.23986588822737254,-2.1575877069039961E-3,-1.2022014209426972,null,null,"Corrected 20/21 position to latest CT rates published @ 17% for 20/21 (Sept version @ 18%)"]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.8718681374057837,-3.0008681374058597,-3.1248681374058265,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081601,-2.7942966052081033,null,null,0,0,-7.7571532197680426E-2,-0.20657153219769953,-0.33057153219772317,null,null,"Reflects the Ofgem AIP figures"]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-14.061951034719643,-20.061203345695063,-26.939322779102849,null,null,-5.4594741209812128,-8.6310217646498586,-14.828010328472089,-18.725651685291211,-25.403887111238191,null,null,0,0,0.76605929375244664,-1.3355516604038513,-1.5354356678646575]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,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,null,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,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.3701493322271574,-1.5861707889526353,null,null,-1.4565788939009403,-2.7806280473498055,-2.808761744527652,-1.3733628810600989,-1.5899423343145109,null,null,0,0,2.6646919358768173E-3,3.2135488329414486E-3,3.7715453618756278E-3]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,null,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,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,null,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,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.73231837993037918,-0.69577364944135256,null,null,-0.72182350838623877,-0.63350022196940414,-0.78079225612011349,-0.73162665283795314,-0.69508151228635329,null,null,0,0,-6.9248290549239755E-4,-6.9172709242604213E-4,-6.9213715499927275E-4]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,null,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,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.5486037652912925,-2.8454409160364409,null,null,-0.58352828536186707,-1.1804643124955649,-2.002887657041148,-2.5479120381988665,-2.8447487788814416,null,null,0,0,-6.9248290549239755E-4,-6.9172709242604213E-4,-6.9213715499927275E-4]
[]
[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.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.76803150278283283,-1.3330298386633359,-1.5323562596577815]
[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.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.76803150278283283,-1.3330298386633359,-1.5323562596577815]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,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,-3.1453982379460399E-2,0,0,null,null,1.4275770953642741E-2,-6.1660906661447967E-2,0,0,0,0,null,0,0,-3.1453982379460399E-2,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]

{"sheet":"Memo Move vs Nov Indicatives","index":3,"n_rows":213,"n_cols":32,"rows_kept":213,"cut":false,"hidden":false,"merged":[[151,3,151,4],[153,3,153,4],[118,3,118,4],[130,3,130,4],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[110,3,110,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[116,3,116,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[108,3,108,4],[109,3,109,4],[89,3,89,4],[95,3,95,4],[97,3,97,4],[98,3,98,4],[100,3,100,4],[101,3,101,4],[7,3,7,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[1,3,1,4],[1,10,1,15],[1,17,1,22],[1,24,1,29],[1,31,1,39],[3,31,5,39]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,"NOVEMBER INDICATIVES",null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[]
[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",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.3550871234589861,1.3981111396288088,null,null,1.2327329838381795,1.2709189417960116,1.3140249519157237,1.3534457004731957,1.3940490714873917,null,null,0,0,-1.0746221612567552E-6,1.6414229857903972E-3,4.0620681414171855E-3]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,0,0,null,null,2.3E-2,3.4000000000000002E-2,0,0,0,null,null,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.5500000000000087E-2,3.3250000000000002E-2,3.125E-2,3.1749999999999945E-2,null,null,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2,null,null,0,5.0000000000016698E-4,-4.9999999999994493E-4,1.2499999999999734E-3,1.7499999999999183E-3]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,1.5000000000000846E-3,-5.0000000000001432E-5,"","",null,null,-1.5725023416449449E-3,9.9999999999991762E-4,"","","",null,null,0,5.0000000000016698E-4,"","",""]
[]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,0,0,0,0,0]
[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.171199014605822,-29.374309111201036,null,null,-6.2324478434481421,-11.079016524139888,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.79948548516229323,-1.3330298386633359,-1.5323562596577815]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.21451187922461867,-5.6274618773451616E-14,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,5.3890861274262444E-2,5.6268108628512755E-14,null,null,0,0,0,0.16062101795035622,-1.1254272740196438E-13]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.926361079340722,111.59154461404984,124.0685889596042,null,null,76.602895594612164,84.616406495412889,98.675641224536605,111.49008526137345,123.40649702044658,null,null,0,0,0.2507198548041174,0.10145935267638606,0.66209193915761944]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,425.85679739767863,435.71168710371381,null,null,405.74788540780747,396.94748949190864,412.90430561111259,426.92774686571522,436.58195142421414,null,null,0,0,1.0502053399663964,-1.0709494680365879,-0.87026432050032554]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.7828467824603411,5.4642957339676093,null,null,0.45240792338436564,0.96340416482706637,0.42583303954468199,5.8069421677628705,5.981150432795757,null,null,0,0,-3.48250328630062E-7,-2.4095385302529415E-2,-0.51685469882814772]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.167274275113737E-2,-6.3552377470316349E-2,null,null,0.21262510901874174,0.24439389996628133,-5.9937766987509522E-2,-6.1674099920134638E-2,-6.3524322917738685E-2,null,null,0,0,4.9017678548091137E-8,1.3571689972680101E-6,-2.8054552577663761E-5]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2674586565960988,2.0315231835774954,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391031842379761,2.2715064366794158,2.339651629779798,null,null,0,0,-1.8311599787601551E-6,-4.0477800833169653E-3,-0.30812844620230262]
[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.87532900000000002,0,0,null,null,-0.15071466,0,0,0,0,null,null,0,0,0.87532900000000002,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.4803253264025198,7.9886326963053023,7.4322665400747887,null,null,0.55789903343100389,3.5055935921424757,2.6049984567951485,8.0167745045221519,8.2572777396578161,null,null,0,0,0.87532686960737127,-2.814180821684964E-2,-0.82501119958302738]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1647606123168193,1.8567091697205527,null,null,0.67553374772655639,3.3793563036027767,1.9310260127886272,2.165854051077365,1.8558880265214446,null,null,0,0,-1.5792115244384064E-6,-1.0934387605456841E-3,8.2114319910808753E-4]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0159298389659304,-8.6936539894059699,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,0,0,3.2180409936799492E-6,-4.1483319477384484E-3,-1.1009182827313202]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8511692266491111,-6.8369448196854172,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039255584813738,-1.845927455940827,-5.7368476801532049,null,null,0,0,1.6388294694635874E-6,-5.2417707082841325E-3,-1.1000971395322123]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.94290432123618673,0.95957166667750993,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.94087041670374516,0.92312011357928847,null,null,0,0,0,2.0339045324415661E-3,3.6451553098221456E-2]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-7.2138910526559821,-7.4197454368429039,null,null,-5.7074720867072717,-7.208780850335943,-7.3099516506447442,-7.2236271001459142,-7.6350198214282115,null,null,0,0,5.9781483070509012E-6,9.7360474899321758E-3,0.21527438458530757]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-6.2709867314197956,-6.4601737701653938,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481471132640724,-6.2827566834421695,-6.7118997078489233,null,null,0,0,5.9781483070509012E-6,1.1769952022373964E-2,0.25172593768352947]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,3.1086732937949924,3.2190879613745476,null,null,2.7280489896020739,3.366405616377834,3.4091212241289091,3.0983210477234864,3.1925927538746204,null,null,0,0,2.2351992399647358E-3,1.0352246071505977E-2,2.6495207499927176E-2]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2989426966198909,5.4194757396761357,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2963840569788383,5.4194801717788055,null,null,0,0,0,2.5586396410526291E-3,-4.4321026697602406E-6]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,0.8,0,0,0.8,0,null,null,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.5007691837990245,2.6079134189917976,2.6828978236053755,2.7449836287533973,null,null,2.4086934000000002,2.5007691837990245,2.6012971253500092,2.6896448052540061,2.7504662939725493,null,null,0,0,6.6162936417883955E-3,-6.7469816486305234E-3,-5.482665219151972E-3]
[null,25,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.2276556354990138,0,null,null,2.7784430349248272,6.4989282987774661,-10.411240613350806,-1.015555471590206,1.1842336658238662E-13,null,null,0,0,-6.7255623742958903E-3,-0.21210016390880782,-1.1842336658238662E-13]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,409.62369148062174,436.3861323144364,441.23038238374193,441.23038238374193,null,411.31483044543194,409.18166530290893,407.69602572356268,437.68463166922049,443.75302099549583,443.75302099549583,null,0,0,1.9276657570590601,-1.2984993547840986,-2.522638611753905,-2.522638611753905]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.36082499676377,409.62369148062174,436.38613022971555,441.23051901805951,441.23052728578222,null,421.35891895000003,410.16031458532899,407.69602572356263,437.68463166922038,443.75302099549589,443.75302099549594,null,0,0.20051041143477732,1.9276657570591169,-1.2985014395048324,-2.5225019774363773,-2.5224937097137285]
[null,28,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,10.044088504568094,1.1791596938548423,0,-2.0847208475061052E-6,1.366343175845941E-4,1.449020402901624E-4,null,10.044088504568094,0.97864928242006499,0,0,0,0,null,0,0.20051041143477732,0,-2.0847208475061052E-6,1.366343175845941E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,1.0802687783812992E-3,6.5334211351592897E-2,1.1100834125074899E-2,null,null,null,null,-3.6307579379111221E-3,7.3556287168694334E-2,1.3864753037208466E-2,null,null,null,null,4.7110267162924213E-3,-8.2220758171014374E-3,-2.7639189121335672E-3]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-2.8817510505558313E-3,0,4.7772389934792141E-9,null,null,null,null,-2.3917232012230817E-3,0,0,null,null,null,null,-4.9002784933274961E-4,0,4.7772389934792141E-9]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-6.4711587792203326E-3,0.02,0.02,null,null,null,null,0,1.9999999999999997E-2,0.02,null,null,null,null,-6.4711587792203326E-3,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.5590503172216883E-3,-1.8441702659258256E-3,8.4330769693173289E-3,null,null,null,null,-1.4482422814372274E-3,-1.7167439687329131E-3,6.0339531279413917E-3,null,null,null,null,-1.108080357844609E-4,-1.2742629719291257E-4,2.3991238413759372E-3]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.0569796731464424E-2,4.9352744996484676E-2,6.1350878274177234E-2,4.262170956228286E-2,-3.5092500034003368E-2,-9.8316913686165523E-3,8.3490041085667072E-2,3.9533915871631221E-2,1.9709848909822386E-2,null,4.262170956228286E-2,-3.5091157538558765E-2,-7.4707234205714313E-3,9.1839543199961418E-2,3.9898706165149858E-2,1.9706494783452686E-2,null,0,-1.3424954446034087E-6,-2.360967948045121E-3,-8.3495021142943465E-3,-3.6479029351863673E-4,3.3541263696999779E-6]
[]
[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",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,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,"","","","","",null,13967.493608369672,"","","","","",null,0,0,0,0,0,0]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,129.12132406333461,129.26080979834347,137.70596286518648,139.23461391698663,139.23461391698663,null,129.79446543550341,129.12132406333461,128.65251579103807,138.11571718753865,140.03065749690083,140.03065749690083,null,0,0,0.60829400730540328,-0.40975432235217113,-0.79604357991419761,-0.79604357991419761]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (16/17 Prices)","16/17 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,124.69466350877316,120.81235640996123,124.80536866669924,122.30754772201317,119.52850986759168,null,129.79446543550341,124.75490247665179,120.24372200647292,125.32854733263466,123.36523950477063,120.65060098266076,null,0,-6.0238967878632366E-2,0.56863440348830352,-0.52317866593541851,-1.057691782757459,-1.1220911150690824]
[null,37,null,"% movement in domestic customer bill - (16/17 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877806E-2,-3.9291366620438861E-2,-3.113450880388946E-2,3.3051356462150627E-2,-2.0013729949042935E-2,-2.2721720009772683E-2,null,-5.4430842079877806E-2,-3.8827256169530977E-2,-3.6160346251909004E-2,4.2287657445334359E-2,-1.5665288313389647E-2,-2.2004889975550057E-2,null,0,-4.6411045090788416E-4,5.0258374480195434E-3,-9.2363009831837317E-3,-4.3484416356532885E-3,-7.1683003422262637E-4]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,8.77,8.77,8.77,8.77,8.77,null,null,0,0,0,0,0,0]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.884114072735308,12.261434694544652,null,null,10.811068268260835,11.145959119551021,11.523998828300895,11.869718793149925,12.225810356944423,null,null,0,0,-9.4244363531004183E-6,1.4395279585382781E-2,3.5624337600228984E-2,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0159298389659304,-8.6936539894059699,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349515712700009,-4.0117815070181919,-7.5927357066746497,null,null,0,0,3.2180409936799492E-6,-4.1483319477384484E-3,-1.1009182827313202,0]
[null,41,null,"ECN Correction Factor",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.3134829247637538E-2,2.1301451072617094E-4,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,2.7078227135856985E-2,-6.4762778599742681E-15,null,null,0,0,-3.2190848083235579E-4,-3.9433978882194472E-3,2.130145107326472E-4,0]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8913190630170149,3.5679937196494085,null,null,8.7644464775480895,7.6880584273725372,7.0907295754890702,7.8850155132675903,4.6330746502697675,null,null,0,0,-3.2811487619177626E-4,6.3035497494245973E-3,-1.065080930620359,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6658374906666671,7.0901982854176913,7.8910929375571497,3.5676784705127327,null,null,9.2451910000000019,7.6619642470967726,7.0907295754890765,7.8850155132676054,4.633074650269787,null,null,0,3.8732435698944911E-3,-5.3129007138519313E-4,6.0774242895442754E-3,-1.0653961797570544,0]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-2.2220936705870109E-2,-2.0317519518719962E-4,-2.2612545986522292E-4,-3.1524913667579924E-4,null,null,0.48074452245191246,-2.60941802757646E-2,0,1.5099033134902129E-14,1.9539925233402755E-14,null,null,0,3.8732435698944911E-3,-2.0317519518719962E-4,-2.2612545988032196E-4,-3.1524913669533916E-4,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11295800482571083,-0.5478583882926551,null,null,null,null,-7.7695670178147935E-2,0.1120175193994386,-0.41242035066716087,null,null,null,null,-4.2678509703186762E-5,9.4048542627223064E-4,-0.13543803762549422,0]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.8903183964828832E-3,2.865496351875647E-5,2.8654963518706146E-5,null,null,null,null,3.3941183619077306E-3,0,-1.9149021469261526E-15,null,null,null,null,-5.0379996542484736E-4,2.865496351875647E-5,2.8654963520621047E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-6.4711587792203318E-3,0.02,0.02,null,null,null,null,0,0.02,0.02,null,null,null,null,-6.4711587792203318E-3,0,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,4.7367688820482926E-4,-4.1815370752855407E-4,-9.5648703748205839E-3,null,null,null,null,1.6815280176936094E-4,-4.0607025034889929E-4,-6.3659181172384775E-3,null,null,null,null,3.0552408643546832E-4,-1.2083457179654783E-5,-3.1989522575821064E-3,0]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.0845512182383741E-2,0.13256850608170104,-0.53739460370395697,null,null,0.38917876005399071,-0.17690890802795603,-7.4133399014470844E-2,0.1316114491490897,-0.39878626878440127,null,null,0,0,-6.7121131679128976E-3,9.5705693261133318E-4,-0.13860833491955571,0]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.55038396788387,401.49360687553639,402.53329002000885,428.49481325141937,437.66238866409253,null,null,402.55038396788387,401.49360687553639,400.60529614807359,429.79961615595289,439.11994634522608,null,null,0,0,1.9279938719352572,-1.304802904533517,-1.4575576811335509,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.69498750609711,402.53349319520407,428.49503729215837,437.66284054754675,null,null,412.11372795000005,402.49835033823223,400.60529614807353,429.79961615595278,439.11994634522608,null,null,0,0.19663716786487839,1.9281970471305385,-1.3045788637944042,-1.4571057976793327,0]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.2013806305607204,2.0317519522450311E-4,2.2404073899906507E-4,4.5188345421820486E-4,null,null,9.5633439821161801,1.004743462695842,0,0,0,null,null,0,0.19663716786487839,2.0317519522450311E-4,2.2404073899906507E-4,4.5188345421820486E-4,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,2.5895384799856647E-3,6.4495344546832589E-2,2.1394834031034371E-2,null,null,null,null,-2.2125152486878186E-3,7.2875521838054569E-2,2.1685292026625058E-2,null,null,null,null,4.8020537286734832E-3,-8.3801772912219796E-3,-2.9045799559068719E-4,0]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.9922783575807976E-3,-5.0474134751539135E-7,-5.2285519467328806E-7,null,null,null,null,-2.5025142256058738E-3,0,0,null,null,null,null,-4.8976413197492378E-4,-5.0474134751539135E-7,-5.2285519467328806E-7,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-6.4711587792203318E-3,0.02,0.02,null,null,null,null,0,0.02,0.02,null,null,null,null,-6.4711587792203318E-3,0,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.7069593445789531E-3,-1.9086199949873463E-3,2.8425344234231133E-3,null,null,null,null,-1.5757619534660923E-3,-1.7656258588279981E-3,2.84189948474756E-3,null,null,null,null,-1.3119739111286085E-4,-1.4299413615934814E-4,6.349386755533093E-7,0]
[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,-8.5808580013944178E-3,8.2586219810497727E-2,4.423684559926281E-2,1.9704202015741235E-2,null,3.4662491904579415E-2,-3.2384756950241796E-2,-6.2907914277597846E-3,9.1109895979226571E-2,4.4527191511372619E-2,1.969992454579032E-2,null,0,0,-2.2900665736346332E-3,-8.5236761687288443E-3,-2.903459121098087E-4,4.2774699509154357E-6]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",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,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,2.0299999999999999E-2,1.6E-2,1.15E-2,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2,null,null,0,0,9.9999999999999742E-4,0,0]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.17,null,null,0.2,0.19,0.19,0.19,0.17,null,null,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.679115855350643,-19.910873115125526,null,null,-5.5790833627772258,-7.3944719953437357,-10.686093517544123,-14.552293314851397,-19.908210400401288,null,null,0,0,1.0834967141774996,-1.126822540499246,-2.6627147242379579E-3]
[null,61,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5874860939472359,-1.3812193529385581,-3.9035815265714975,null,null,-0.20009415299585953,-1.5562531640979955,-1.3476202057198634,-1.3790617652316541,-2.7013801056288003,null,null,0,0,-0.23986588822737254,-2.1575877069039961E-3,-1.2022014209426972]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,63,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.8718681374057837,-3.0008681374058597,-3.1248681374058265,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081601,-2.7942966052081033,null,null,0,0,-7.7571532197680426E-2,-0.20657153219769953,-0.33057153219772317]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-14.061951034719643,-20.061203345695063,-26.939322779102849,null,null,-5.4594741209812128,-8.6310217646498586,-14.828010328472089,-18.725651685291211,-25.403887111238191,null,null,0,0,0.76605929375244664,-1.3355516604038513,-1.5354356678646575]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,67,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,68,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,69,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,null,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,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.3701493322271574,-1.5861707889526353,null,null,-1.4565788939009403,-2.7806280473498055,-2.808761744527652,-1.3733628810600989,-1.5899423343145109,null,null,0,0,2.6646919358768173E-3,3.2135488329414486E-3,3.7715453618756278E-3]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,null,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,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,null,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,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.73231837993037918,-0.69577364944135256,null,null,-0.72182350838623877,-0.63350022196940414,-0.78079225612011349,-0.73162665283795314,-0.69508151228635329,null,null,0,0,-6.9248290549239755E-4,-6.9172709242604213E-4,-6.9213715499927275E-4]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,null,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,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.5486037652912925,-2.8454409160364409,null,null,-0.58352828536186707,-1.1804643124955649,-2.002887657041148,-2.5479120381988665,-2.8447487788814416,null,null,0,0,-6.9248290549239755E-4,-6.9172709242604213E-4,-6.9213715499927275E-4]
[]
[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.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.76803150278283283,-1.3330298386633359,-1.5323562596577815]
[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.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-18.012541936212941,-20.838169175942486,-27.841952851543255,null,null,0,0,0.76803150278283283,-1.3330298386633359,-1.5323562596577815]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,0,0,0,0,0,null,null,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,-3.1453982379460399E-2,0,0,null,null,1.4275770953642741E-2,-6.1660906661447967E-2,0,0,0,0,null,0,0,-3.1453982379460399E-2,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]

{"sheet":"High level mod186 rec","index":4,"n_rows":118,"n_cols":10,"rows_kept":118,"cut":false,"hidden":true,"merged":[[68,2,68,9]]}
[]
[null,"MOD186 Reconciliation - September 2017 to December 2017"]
[]
[null,null,"ALLOWED REVENUE",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"Notes","SEPTEMBER",null,411.31483044543194,409.18166530290893,407.69602572356268,437.96821780641005,443.83036977946341,443.83036977946341]
[]
[null,null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,null,"Cost of debt %   September",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6E-2,1.15E-2]
[null,null,"Cost of debt %   December",null,2.3800000000000002E-2,2.2200000000000001E-2,2.0299999999999999E-2,1.6E-2,1.15E-2]
[null,1,"Cost of debt £ movement",null,0,0,1.0834967141774996,-1.126822540499246,-2.6627147242379579E-3]
[]
[null,null,"Totex Incentive",null,0,0,2.6646919358768173E-3,3.2135488329414486E-3,3.7715453618756278E-3]
[]
[null,2,"Pension deficit valuation",null,0,0,-7.7571532197680426E-2,-0.20657153219769953,-0.33057153219772317]
[]
[null,3,"Tax trigger - Corp. Tax rates long term impact",null,0,0,-0.23986588822737254,-2.1575877069039961E-3,-1.2022014209426972]
[]
[null,null,"Repex Tier 2a",null,0,0,-6.9248290549239755E-4,-6.9172709242604213E-4,-6.9213715499927275E-4]
[]
[null,null,"FGO Impact",null,0,0,0,0,0]
[]
[null,null,"Ofgem changes to Fuel Poor allowances",null,0,0,0,0,0]
[]
[null,null,"\"MOD\" Adjustment",null,0,0,0.76803150278283105,-1.3330298386633341,-1.532356259657782]
[]
[null,null,"Change in Inflation %"]
[null,null,"September (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.499999999999992E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.0000000000000027E-2]
[null,4,"December (Based on HM Treasury Nov report)",null,2.1427497658355055E-2,3.5500000000000087E-2,3.3250000000000002E-2,3.125E-2,3.1749999999999945E-2]
[null,null,"Difference",null,0,5.0000000000016698E-4,-4.9999999999994493E-4,1.2499999999999734E-3,1.7499999999999183E-3]
[null,null,"Cumulative change in inflation",null,0,5.0000000000016698E-4,2.2204460492503131E-16,1.2500000000001954E-3,3.0000000000001137E-3]
[]
[null,null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,null,null,0.28217383718356537,0.10145935267639006,0.66209193915756903]
[]
[null,null,"£ Impact of changes in RPI on RPI true up (relating to 17/18)",null,null,null,null,0.16062101795035622,-1.1254272740196438E-13]
[]
[null,null,"Total base revenue changes",null,0,0,1.0502053399663964,-1.0709494680365879,-0.87026432050032554]
[]
[null,null,"Incentive changes:"]
[]
[null,null,"Customer",null,0,0,2.2351992399647358E-3,1.0352246071505977E-2,2.6495207499927176E-2]
[null,null,"Shrinkage/Leakage",null,0,0,0,1.5821297403561196E-2,-4.0901662972228525E-2]
[null,null,"DRS",null,0,0,0,0,0]
[null,null,"Exit",null,0,0,-1.5792115244384064E-6,-1.0934387605456841E-3,8.2114319910808753E-4]
[null,null,"Total",null,0,0,2.2336200284402974E-3,2.5080104714521489E-2,-1.3585312273193262E-2]
[]
[null,null,"Pass through changes:"]
[]
[null,5,"Rates",null,0,0,-3.48250328630062E-7,-2.4095385302529415E-2,-0.51685469882814772]
[null,null,"License Fee",null,0,0,4.9017678548091137E-8,1.3571689972680101E-6,-2.8054552577663761E-5]
[null,6,"Pension Deficit",null,0,0,-1.8311599787601551E-6,-4.0477800833169653E-3,-0.30812844620230262]
[null,7,"Exit Capacity",null,0,0,3.2180409936799492E-6,-4.1483319477384484E-3,-1.1009182827313202]
[null,null,"Shrinkage pass thru (gas price impact)",null,0,0,5.9781483070509012E-6,7.7859760084899143E-2,0.21527438458530757]
[null,8,"Indicative view of Coop Energy SOLR Claim",null,0,0,0.87532900000000002,0,0]
[null,null,"Total",null,0,0,0.87533606579667189,4.5569619920311583E-2,-1.7106550977290407]
[]
[null,null,"Network Innovation",null,0,0,6.6162936417883955E-3,-6.7469816486305234E-3,-5.482665219151972E-3]
[]
[null,9,"K factor",null,0,0,-6.7255623742958903E-3,-0.57503876692334199,1.1842336658238662E-13]
[]
[null,null,"DECEMBER",null,411.31483044543194,409.18166530290893,409.62369148062169,436.38613231443634,441.23038238374181,441.23038238374193]
[null,null,"Difference",null,0,0,1.9276657570590032,-1.5820854919737144,-2.5999873957215982,-2.5999873957214845]
[]
[null,null,"Total Price Change","September",3.4662491904579415E-2,-3.2384756950241796E-2,-1.1813770729126424E-2,9.1888076536165889E-2,4.3969164196892327E-2,1.969992454579032E-2]
[null,10,"Total Price Change","December",3.4662491904579415E-2,-3.2384756950241796E-2,-8.5808580013944178E-3,8.2586219810497727E-2,4.423684559926281E-2,1.9709848909822386E-2]
[null,null,"TOTAL PRICE CHANGE %","Difference",0,0,3.2329127277320058E-3,-9.3018567256681617E-3,2.6768140237048293E-4,9.9243640320663407E-6]
[]
[null,null,"21/22 is illustrative only assuming flat revenues year on year.  The final outcome could be significantly different to this."]
[]
[]
[null,null,"CUSTOMER BILL IMPACT",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,null,"Customer Bill Impact"]
[]
[null,null,"Assumed TDCV KWh","September",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Average Customer Bill","September (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"Assumed TDCV KWh","December",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,"Average Customer Bill","December (14/15 prices)",{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"Difference in Customer Bill £",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,null,"Assumed TDCV KWh","Variance"]
[null,null,"Average Customer Bill","Variance"]
[]
[]
[]
[]
[null,null,"Checks",null,0,0,0,0,0]
[null,null,"Checks",null,0,0,0,0,0]
[null,null,"Checks",null,0,0,-5.6843418860808015E-14,-5.6843418860808015E-14,-1.1368683772161603E-13]
[]
[]
[null,null,"CALENDAR YEAR BASIS VS. 2017 BUDGET PROCESS",null,null,2017,2018,2019,2020]
[null,null,"Latest Mod186 data above",null,null,413.693098087804,410.04970212422495,428.70132374196766,440.80622899008983]
[null,null,"Budget Data",null,null,413.45491335157914,406.8386478036482,426.42511686815283,440.71219660975794]
[null,null,"Variance",null,null,0.23818473622486636,3.2110543205767499,2.2762068738148287,9.4032380331896093E-2]
[null,null,"Movement from 150 day Indicative notice",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,null,"Allowed Revenues as per Nov 150 day notice",null,411.31483044543188,409.18166530290893,407.69602572356274,437.68463166922049,443.75302099549589,443.75302099549589]
[null,null,"Cost of Debt movement",null,0,0,1.0834967141774996,-1.126822540499246,-2.6627147242379579E-3]
[null,null,"Pension deficit valuation",null,0,0,-7.7571532197680426E-2,-0.20657153219769953,-0.33057153219772317]
[null,null,"Tax Trigger",null,0,0,-0.23986588822737254,-2.1575877069039961E-3,-1.2022014209426972]
[null,null,"Inflation",null,0,0,0.2507198548041174,0.26208037062674228,0.66209193915750686]
[null,null,"Supplier of Last Resort",null,0,0,0.87532900000000002,0,0]
[null,null,"Pass Through Changes",null,0,0,7.0657966710907516E-6,-2.2554092674655912E-2,-1.71065509772904]
[null,null,"Incentives",null,0,0,8.849913670228915E-3,7.1043698358241869E-3,5.8280806475435654E-2]
[null,null,"K factor",null,0,0,-6.7255623742958903E-3,-0.21210016390880782,-1.1842336658238662E-13]
[null,null,"Allowed Revenues as per Dec Mod186",null,411.31483044543188,409.18166530290893,409.59026528921197,436.38361049269571,441.227302975535,441.227302975535]
[null,null,"Movement £m",null,null,null,1.8942395656492295,-1.3010211765247846,-2.5257180199608911,-2.5257180199608911]
[]
[null,null,"Price Change as per Nov 150 day notice",null,3.4662491904579415E-2,-3.2384756950241796E-2,-6.2907914277597846E-3,9.1109895979226571E-2,4.4527191511372619E-2,1.969992454579032E-2]
[null,null,"YOY changes in allowed revenues",null,null,null,4.8020537286734832E-3,-8.3801772912219796E-3,-2.9045799559068719E-4,0]
[null,null,"Change in capacity levels per Dec Xoserve snapshot",null,0,0,-6.4711587792203318E-3,0,0]
[null,null,"Other",null,null,null,-6.2096152308778463E-4,-1.4349887750686352E-4,1.1208348088002123E-7,0]
[null,null,"Price Change as per Dec Mod186",null,3.4662491904579415E-2,-3.2384756950241796E-2,-8.5808580013944178E-3,8.2586219810497727E-2,4.423684559926281E-2,1.969992454579032E-2]
[null,null,"Movement %",null,0,0,-2.2900665736346332E-3,-8.5236761687288443E-3,-2.903459121098087E-4,0]