{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":63,"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,"2018-06-14T08:07:32.730",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.3531171209306334,1.3943871931190177]
[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.2999999999999918E-2,3.0000000000000027E-2,3.0499999999999972E-2,null,null,"As per May 2018 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,1.5000000000000846E-3,-3.0000000000008492E-4,"","",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,-8.0596332558672837E-2,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,110.97244127149276,122.87626057059646]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,425.23769405512155,434.43876238214744]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.77443977852288,5.4496218505321004]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.158308397049745E-2,-6.3383102190575108E-2]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2641622639073193,2.0280967910105558]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.977018958459702,7.4143355393520807]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1616135202917275,1.8522118738573357,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.0100915487191342,-8.7492534752040463,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.8484780284274067,-6.8970416013467108,null,null,"THIS EXCLUDES ANY COST INCREASE AS A RESULT OF MOD621 IMPLEMENTATION"]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,1.0360790304949885,1.016413717667271,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,-6.6392288295903708,-7.0584721996680644,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,-5.603149799095382,-6.0420584820007939]
[]
[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 17/18"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2989426966198909,5.4181644704432106,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.6789974725472661,2.7369642030075294,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.2118122908859081,1.4054343087362424]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,409.53615848062174,436.43788635813479,441.69364878171353,441.69364878171353]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.19564233913644,436.43788635813468,441.69364878171376,441.69364878171501]
[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.163942207091111,-1.3405161414852955,0,0,1.4779288903810084E-12]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,8.6634668112606228E-4,6.5688284954662945E-2,1.2042406463461663E-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.8445610001353997E-3,3.2732546656163587E-3,0,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,-1.0613176358943877E-2,2.0000000000000004E-2,1.9999999999999997E-2,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.4188180142127669E-3,-2.4392965769119007E-3,8.7752218144982463E-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.5093358744102333E-2,-1.401020869216598E-2,8.6522243043367406E-2,4.0817628277959907E-2,1.9708777652333566E-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.09E-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.19620000000000001,0.21299999999999999,0.22270000000000001,0.22270000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1137,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.53615848062174,436.43788635813468,441.69364878171359,441.69364878171359]
[]
[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.2331878938995,137.72229436587341,139.38080221370782,139.38080221370782]
[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.81577184574844,125.00189581919365,122.76294949767271,119.88569286882098]
[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.110711841130076E-2,3.4648820344332476E-2,-1.791129891949339E-2,-2.3437500000000222E-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.866837150561654,12.228775683653785]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0100915487191342,-8.7492534752040463,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.0555426041338927E-2,-3.7156058994424188E-2]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8773010278838589,3.4423661494553146]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1258412506666673,7.8773010278838695,3.4423661494553137]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-1.9743427372537425E-2,3.5439790053788833E-2,1.0658141036401503E-14,0]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11098096090076148,-0.56300182800300269]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.5680641684827725E-3,-4.9982769312367677E-3,-1.3530193906103247E-15]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,0.02,0.02]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,1.4424029232627585E-3,-6.8911203954446359E-4,-9.8599809125655309E-3]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.12529357192998025,-0.55286180891556957]
[]
[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.44575702000884,428.56058533025094,438.25128263225821]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.06980108846977,428.56058533025083,438.25128263225844]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,3.013229155623776,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.1836856344636431,-1.3759559315390675,0,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.3715200644967016E-3,6.4890305972200135E-2,2.26121991469177E-2]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.9482054363834174E-3,3.4189848135749074E-3,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,0.02,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.5750450588309026E-3,-2.4996971071540343E-3,2.8686487933963951E-3]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.580959367862101E-2,4.5480847940314095E-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":"Mod186 Statement movement","index":2,"n_rows":163,"n_cols":32,"rows_kept":163,"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],[30,31,31,39]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,"MARCH 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.3531171209306334,1.3943871931190177,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3544264582271617,1.3953978585885336,null,null,0,0,0,-1.3093372965282679E-3,-1.0106654695158923E-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,3.3300000000000003E-2,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.2999999999999918E-2,3.0000000000000027E-2,3.0499999999999972E-2,null,null,2.1427497658355055E-2,3.5749999999999948E-2,3.3749999999999947E-2,3.0000000000000027E-2,3.025000000000011E-2,null,null,0,-2.4999999999986144E-4,-7.5000000000002842E-4,0,2.4999999999986144E-4,null,null,"Movement reflects latest position from May 2018 HM Treasury report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,1.5000000000000846E-3,-3.0000000000008492E-4,"","",null,null,-1.5725023416449449E-3,1.749999999999946E-3,4.499999999999435E-4,"","",null,null,0,-2.4999999999986144E-4,-7.5000000000002842E-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,-17.213056451050647,-22.171199014605822,-29.374309111201036,null,null,0,0,0,0,0]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.21451187922461867,-8.0596332558672837E-2,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.29479744160380605,0.24141918137070509,null,null,0,0,0,-8.0285562379187381E-2,-0.32201551392937794,null,null,"Movement reflects latest position from May 2018 HM Treasury report"]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.926361079340722,110.97244127149276,122.87626057059646,null,null,76.602895594612164,84.616406495412889,98.926361079340722,111.41237581548603,123.31847027741333,null,null,0,0,0,-0.43993454399327447,-0.44220970681686822,null,null,"Movement reflects latest position from May 2018 HM Treasury report"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,425.23769405512155,434.43876238214744,null,null,405.74788540780747,396.94748949190864,413.95451095107899,425.757914161494,435.2029876028937,null,null,0,0,0,-0.52022010637244875,-0.76422522074625476]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.77443977852288,5.4496218505321004,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.768058103189877,5.4417331560506721,null,null,0,0,0,6.3816753330030451E-3,7.88869448142826E-3]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.158308397049745E-2,-6.3383102190575108E-2,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,-6.1642674546531842E-2,-6.3429042882695214E-2,null,null,0,0,0,5.9590576034392051E-5,4.5940692120105542E-5]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2641622639073193,2.0280967910105558,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2643566937110333,2.021631406525731,null,null,0,0,0,-1.9442980371398022E-4,6.4653844848248099E-3]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0,0,null,null,-0.15071466,0,0.78779600000000005,0,0,null,null,0,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.977018958459702,7.4143355393520807,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.9707721223543793,7.3999355196937078,null,null,0,0,0,6.2468361053227284E-3,1.4400019658372898E-2]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1616135202917275,1.8522118738573357,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1631829395949405,1.8517625259985639,null,null,0,0,0,-1.5694193032129711E-3,4.4934785877170924E-4]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0100915487191342,-8.7492534752040463,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.016087635261206,-8.6800250671941264,null,null,0,0,0,5.9960865420718434E-3,-6.9228408009919917E-2,null,null,"This data excludes any potential impacts from Mod621 implementation"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8484780284274067,-6.8970416013467108,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8529046956662656,-6.8282625411955626,null,null,0,0,0,4.4266672388588724E-3,-6.8779060151148208E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,1.0360790304949885,1.016413717667271,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.99069941086212776,0.95028812063351187,null,null,0,0,0,4.5379619632860746E-2,6.6125597033759087E-2,null,null,"Inclusive of latest actuals to May 18 and latest forward market data - higher gas prices so returning less money"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.6392288295903708,-7.0584721996680644,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.9221429816415778,-7.4650461747432981,null,null,0,0,0,0.28291415205120707,0.40657397507523374]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.603149799095382,-6.0420584820007939,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.9314435707794502,-6.5147580541097865,null,null,0,0,0,0.32829377168406815,0.47269957210899261]
[]
[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.4113564233688738,3.1086732937949924,3.2190879613745476,null,null,0,0,0,0,0]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,5.2989426966198909,5.4181644704432106,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,5.3002220164404168,5.4234073313235731,null,null,0,0,0,-1.2793198205258705E-3,-5.242860880362521E-3]
[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.6789974725472661,2.7369642030075294,null,null,2.4086934000000002,2.5007691837990245,2.6079134189917976,2.6822748592174124,2.7417788218982304,null,null,0,0,0,-3.2773866701463206E-3,-4.8146188907010057E-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.2118122908859081,1.4054343087362424,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-0.9466554733687581,-2.6266674725499227E-2,null,null,0,0,0,-0.26515681751715003,1.4317009834617416,null,null,"Collected Revenue in 18/19 is forecast to be lower due to differences in capacity invoices"]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.18166530290893,409.53615848062174,436.43788635813479,441.69364878171353,441.69364878171353,null,411.31483044543194,409.18166530290893,409.53615848062174,436.88885271348676,440.61790996715291,440.61790996715291,null,0,0,0,-0.45096635535196583,1.0757388145606228,1.0757388145606228]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.19564233913644,436.43788635813468,441.69364878171376,441.69364878171501,null,421.35891895000003,410.09092515223938,409.56121187602685,436.88885271348676,440.61790996715291,440.61856806292934,null,0,0.2546823577606574,-1.3655695368904048,-0.45096635535207952,1.0757388145608502,1.0750807187856708]
[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.163942207091111,-1.3405161414852955,0,0,1.4779288903810084E-12,null,10.044088504568094,0.90925984933045356,2.5053395405109313E-2,0,0,6.5809577642994554E-4,null,0,0.2546823577606574,-1.3655695368904048,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,8.6634668112606228E-4,6.5688284954662945E-2,1.2042406463461663E-2,null,null,null,null,8.6634668112606228E-4,6.6789448663931106E-2,8.5354827217614115E-3,null,null,null,null,0,-1.1011637092681603E-3,3.5069237417002519E-3]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-2.8445610001353997E-3,3.2732546656163587E-3,0,null,null,null,null,-2.2221422082960313E-3,-6.1175051057902572E-5,0,null,null,null,null,-6.224187918393684E-4,3.334429716674261E-3,0]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,2.0000000000000004E-2,1.9999999999999997E-2,null,null,null,null,-1.0613176358943875E-2,0.02,0.02,null,null,null,null,0,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.4188180142127669E-3,-2.4392965769119007E-3,8.7752218144982463E-3,null,null,null,null,-2.0352507573673847E-3,-1.8256844220405632E-3,8.3467643066167767E-3,null,null,null,null,6.164327431546178E-4,-6.1361215487133747E-4,4.2845750788146966E-4]
[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.5093358744102333E-2,-1.401020869216598E-2,8.6522243043367406E-2,4.0817628277959907E-2,1.9708777652333566E-2,null,4.262170956228286E-2,-3.5092823823804194E-2,-1.4004222643481229E-2,8.4902589190832642E-2,3.6882247028378189E-2,1.9713172597417915E-2,null,0,-5.3492029813972941E-7,-5.9860486847519018E-6,1.6196538525347637E-3,3.9353812495817181E-3,-4.3949450843489002E-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.3500000000000002E-2,3.49E-2,3.49E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.2127,0.2215,0.2215]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1047,0.1135,0.1182,0.1182]
[]
[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,409.53615848062174,436.88885271348676,440.61790996715291,440.61790996715291]
[]
[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.2331878938995,137.72229436587341,139.38080221370782,139.38080221370782,null,129.79446543550341,129.12132406333461,129.2331878938995,137.86460126241525,139.04134218443312,139.04134218443312,null,0,0,0,-0.14230689654183948,0.33946002927470431,0.33946002927470431]
[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.81577184574844,125.00189581919365,122.76294949767271,119.88569286882098,null,129.79446543550341,124.66456583474258,120.69897805814514,125.01009345334812,122.37526323325885,119.5946867659505,null,0,3.0097674030585608E-2,0.11679378760329939,-8.1976341544702791E-3,0.38768626441385834,0.29100610287048312]
[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.110711841130076E-2,3.4648820344332476E-2,-1.791129891949339E-2,-2.3437500000000222E-2,null,-5.4430842079877806E-2,-3.9523253811696191E-2,-3.1810063670010935E-2,3.5717911324204765E-2,-2.1076939847841536E-2,-2.2721720009772794E-2,null,0,2.3188719125732948E-4,7.0294525871017477E-4,-1.0690909798722892E-3,3.1656409283481457E-3,-7.1577999022742755E-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.866837150561654,12.228775683653785,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.878320038652207,12.237639219821439,null,null,0,0,0,-1.1482888090553089E-2,-8.863536167654118E-3,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0100915487191342,-8.7492534752040463,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.016087635261206,-8.6800250671941264,null,null,0,0,0,5.9960865420718434E-3,-6.9228408009919917E-2,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.0555426041338927E-2,-3.7156058994424188E-2,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.21622294131039E-2,-6.1124491497398443E-4,null,null,0,0,0,-1.6068033717649734E-3,-3.6544814079450205E-2,0]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8773010278838589,3.4423661494553146,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8843946328041055,3.5570029077123388,null,null,0,0,0,-7.0936049202465767E-3,-0.11463675825702424,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1258412506666673,7.8773010278838695,3.4423661494553137,null,null,9.2451910000000019,7.6667716699999993,7.0909844716222361,7.8843946328041037,3.5565260869702224,null,null,0,1.543330000000509E-3,3.4856779044431185E-2,-7.0936049202341422E-3,-0.11415993751490872,0]
[null,44,null,"Under/Over Recovery Carried Forward (ECN)",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,-1.9743427372537425E-2,3.5439790053788833E-2,1.0658141036401503E-14,0,null,null,0.48074452245191246,-2.1286757372537934E-2,5.8301100935764794E-4,0,-4.7682074211641279E-4,null,null,0,1.543330000000509E-3,3.4856779044431185E-2,1.0658141036401503E-14,4.7682074211641279E-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.11098096090076148,-0.56300182800300269,null,null,null,null,-7.7738348687851122E-2,0.11198141270305384,-0.54885529284481271,null,null,null,null,0,-1.000451802292357E-3,-1.4146535158189977E-2,0]
[null,46,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-1.0843624085972068E-3,6.9889587358696499E-3,null,null,2.5680641684827725E-3,-4.9982769312367677E-3,-1.3530193906103247E-15,null,null,null,null,2.7688079602450257E-3,-8.2225387743736268E-5,0,null,null,null,null,-2.0074379176225317E-4,-4.9160515434930312E-3,-1.3530193906103247E-15,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,0,0,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,1.4424029232627585E-3,-6.8911203954446359E-4,-9.8599809125655309E-3,null,null,null,null,1.2416591315005058E-3,-4.1751758749374729E-4,-9.5936073150123362E-3,null,null,null,null,2.0074379176225274E-4,-2.7159445205071631E-4,-2.6637359755319473E-4,0]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.12529357192998025,-0.55286180891556957,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.13148166972781636,-0.53844890015982505,null,null,0,0,0,-6.1880977978361063E-3,-1.4412908755744525E-2,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.44575702000884,428.56058533025094,438.25128263225821,null,null,402.55038396788387,401.49360687553639,402.44575702000884,429.00445808068264,437.06090705944058,null,null,0,0,0,-0.44387275043169439,1.1903755728176293,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.06980108846977,428.56058533025083,438.25128263225844,null,null,412.11372795000005,402.42415348223938,402.47022740440462,429.00445808068264,437.06138388018269,null,null,0,0.25313902776065333,-1.4004263159348511,-0.44387275043180807,1.1898987520757487,0]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.1836856344636431,-1.3759559315390675,0,0,null,null,9.5633439821161801,0.93054660670298972,2.447038439578364E-2,0,4.7682074210797509E-4,null,null,0,0.25313902776065333,-1.4004263159348511,0,-4.7682074210797509E-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.3715200644967016E-3,6.4890305972200135E-2,2.26121991469177E-2,null,null,null,null,2.3715200644967016E-3,6.5993244051901767E-2,1.8779406197319215E-2,null,null,null,null,0,-1.1029380797016319E-3,3.8327929495984847E-3,0]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-2.9482054363834174E-3,3.4189848135749074E-3,0,null,null,null,null,-2.3177121397887179E-3,-6.0804180362043222E-5,0,null,null,null,null,-6.3049329659469952E-4,3.4797889939369507E-3,0,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,0,0,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.5750450588309026E-3,-2.4996971071540343E-3,2.8686487933963951E-3,null,null,null,null,-2.2055383554256021E-3,-1.8858973852792608E-3,2.7845229503501052E-3,null,null,null,null,6.3049329659469952E-4,-6.1379972187477344E-4,8.4125843046289894E-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,-1.2764906789661495E-2,8.580959367862101E-2,4.5480847940314095E-2,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.4046542486260464E-2,4.1563929147669321E-2,null,null,0,0,0,1.7630511923605457E-3,3.9169187926447746E-3,0]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"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,2.0299999999999999E-2,1.6E-2,1.15E-2,null,null,0,0,0,0,0]
[null,59,null,"Corporation Tax Rate","CT",null,null,0.23,0.21,0.2,0.2,0.19,0.19,0.19,0.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,-9.6025968033666231,-15.679115855350643,-19.910873115125526,null,null,0,0,0,0,0]
[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.5874860939472359,-1.3812193529385581,-3.9035815265714975,null,null,0,0,0,0,0]
[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.8718681374057837,-3.0008681374058597,-3.1248681374058265,null,null,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,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.061951034719643,-20.061203345695063,-26.939322779102849,null,null,0,0,0,0,0]
[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.8060970525917752,-1.3701493322271574,-1.5861707889526353,null,null,0,0,0,0,0]
[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.78148473902560589,-0.73231837993037918,-0.69577364944135256,null,null,0,0,0,0,0]
[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.0035801399466404,-2.5486037652912925,-2.8454409160364409,null,null,0,0,0,0,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-17.244510433430108,-22.171199014605822,-29.374309111201036,null,null,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.244510433430108,-22.171199014605822,-29.374309111201036,null,null,-6.2181720724944993,-11.140677430801336,-17.244510433430108,-22.171199014605822,-29.374309111201036,null,null,0,0,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,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,null,null,null,null,null,null,null,0,0,0,0,0,0]