{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BBPTACShadowWks0001","Mod186 Statement","Mod186 Movement","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":62,"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":142,"n_cols":19,"rows_kept":142,"cut":false,"hidden":false,"merged":[[27,17,27,18],[30,17,30,18],[34,17,34,18],[78,17,81,18],[7,17,9,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],[1,3,1,18],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,17,6,18],[5,13,6,13],[5,14,6,14],[5,12,6,12],[5,15,6,15],[139,3,139,4],[37,17,37,18],[38,17,38,18],[35,17,35,18],[31,17,31,18],[115,3,115,4],[36,17,36,18],[104,17,104,18],[120,3,120,4],[121,3,121,4],[133,3,133,4],[138,3,138,4],[103,17,103,18],[87,17,87,18]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"Published","2017-06-13T09:25:51.250",null,null,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 base revenues are flat year on year,  and then flows through any RIIO-GD1 2 year lagged entries from 19/20.  All RIIO-GD2 revenues will be driven from Ofgem modelling/methodologies which will be developed over the next 2-3 years.                   ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[null,null,null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"RPI built into pricing statements",null,null,null,2.6499999999999999E-2,3.1E-2,2.5999999999999999E-2,2.3250000000000031E-2,3.400000000000003E-2,null,null,null,null,null,"Prices set with an assumed RPI rate of 3.4% for 17/18 regulatory year"]
[null,2,null,"Latest Actual/Projected RPI",null,null,null,2.88464289363441E-2,1.9600131885767733E-2,1.0776609381026855E-2,2.1427497658355051E-2,3.4750000000000107E-2,3.3500000000000037E-2,3.2000000000000077E-2,3.2249999999999848E-2,3.2999999999999904E-2,null,"Per February 2017  HM Treasury report - independent average"]
[null,3,null,"Assumed Interest Rate","It",null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,3.3561643835616438E-3,2.8698630136986302E-3,4.4931506849315069E-3,6.7459016393442619E-3,9.986301369863013E-3,1.3000000000000003E-2,null,"Per February 2017  HM Treasury report - independent average"]
[]
[null,4,null,"Opening Base Revenue Allowance","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,341.01740725531073,null,"Per final proposal data"]
[null,5,null,"Price Control Financial Model Iteration Adjustment","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-19.554571793368861,-22.173495732598031,-28.396169323769392,-28.396169323769392,null,"14/15 - 17/18 MOD is actual, forecast thereafter."]
[null,6,null,"RPI True Up","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,-2.6610394064885853E-2,0,0,null,"Latest RPI inflation impact on the true up mechanism"]
[null,7,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3133898502180597,1.3554183254250376,1.3991305664199949,1.4453018751118547]
[null,null,null,"Base Revenue","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,410.67945208978421,425.6309481057225,437.39792970207742,451.83206138224597]
[]
[null,8,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42562722360036376,5.8274159204022657,6.0153500838352381,6.2138566366017898]
[null,9,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9908797539469393E-2,-6.1763988911131704E-2,-6.3755877553515694E-2,-6.5859821512781705E-2]
[null,10,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2380209686898764,2.2768204257384697,2.3502478844685339,2.4278060646559956]
[null,11,null,"Pass-Through Others: Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,0,0,0,0,0,0]
[null,12,null,"Pass Through","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.70861369343100389,3.5055935921424757,2.6037393947507708,8.0424723572296042,8.3018420907502559,8.5758028797450034]
[]
[null,13,null,"Exit Capacity Incentive Revenue","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9300926987772247,1.8128460755617586,1.5260777929398257,0.99121285189824115,null,"Data uses finalised Gemini bookings applied with NTS incentive rates"]
[null,14,null,"Exit Capacity Allowance Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,-1.5587100522651507,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,15,null,"NTS Exit Capacity Revenue Adjustment","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0029570102644407,-2.0877689677196654,-5.8965501080919269,-0.56749720036690954]
[]
[null,16,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.0362141281641657,-6.9272492758046305,-7.3549049722594573,-7.7018558267016015,null,"Actuals and forecast compared against original allowance with actual/forecast gas prices"]
[null,17,null,"Shrinkage Incentive Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.56566492100254073,0.61875416863662702,0.61436104957349347,0.60632695649242019,null,"13/14 - 15/16 actual volume impact - and assumed this level of outperformance will continue"]
[null,18,null,"Shrinkage Allowance Rev Adjustment","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4705492071616248,-6.3084951071680031,-6.7405439226859638,-7.095528870209181]
[]
[null,19,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.0502608515814709,3.0085042909545647,3.0909542364897487,3.185391006607051,null,"Assumes customer service scores and stakeholder results will continue at same rate"]
[null,20,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,3.192177531877407,3.3540080013561226,3.472973382465594,3.6387993719878358,null,"13/14 - 15/16 actual volume impact - and assumed this level of outperformance will continue"]
[null,21,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,0,null,"DRS from 11/12, 12/13,14/15 - forecast thereafter"]
[null,22,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.5562116780691873,2.5007691837990245,2.5872805481656407,2.6814749730660519,2.7556069571230877,0,null,"Actual spend 13/14 - 15/16, assumed will spend maximum allowance thereafter"]
[null,23,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.1021060536889,-6.54178924246238E-2,0,5.9530722902600659E-14]
[]
[null,24,null,"Maximum DN Allowed Revenue (including NTS Exit)","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.61306338350113,409.18166530290893,403.53729814504459,435.0557257610165,442.38221233812817,459.56902857000983]
[null,25,null,"Collectable Revenue (including NTS Exit)","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,409.24470585093388,403.53729814504453,435.05572576101645,442.38244817259852,459.56952311506109]
[null,26,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,9.7458555664989035,6.3040548024957843E-2,0,0,2.3583447034525307E-4,4.9454505125368087E-4]
[null,27,null,"Total incl Exit - Arithmetical April Price Change (%) ",null,null,null,5.0609507050951102E-2,4.9377871620601733E-2,6.1468011442234696E-2,4.2053798015704705E-2,-3.5050122301578224E-2,1.4810448459786334E-2,0.10743710254609998,5.3159760460817808E-2,8.653794832459763E-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.1800000000000002E-2,3.5200000000000002E-2,3.7199999999999997E-2,3.7199999999999997E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.2019,0.22339999999999999,0.23630000000000001,0.23630000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.10780000000000001,0.1193,0.12620000000000001,0.12620000000000001]
[]
[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.61306338350107,409.18166530290893,403.53729814504453,435.0557257610165,442.38221233812823,459.56902857000983]
[]
[null,28,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[null,29,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,129.02776961798671,127.24792421669012,137.1866696737826,139.49693990908517,144.91648030709462]
[null,30,null,"Total annual charges £ (excl.exit capacity) - (14/15 Prices)","14/15 prices",null,null,128.38255278613195,131.25027193559805,132.95361413584527,125.71683696086805,120.77721932054072,115.25029930743219,120.39919176566238,118.60184563441969,119.27357114740421]
[null,31,null,"% movement in domestic customer bill - (14/15 prices)",null,null,null,null,2.2337296519125305E-2,1.2977818446601175E-2,-5.4430842079877917E-2,-3.9291615663738733E-2,-4.5761278858724053E-2,4.4675740446412426E-2,-1.4928224225466025E-2,5.6637020224379331E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,32,null,"Initial Allowed Revenue","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,8.77]
[null,33,null,"Inflated Base Allowance",null,null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.518428986412383,11.887018713977579,12.270375067503355,12.675297444730965]
[null,34,null,"Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,-1.5587100522651507,null,"Inclusive of latest set of indicative prices applied to our latest bookings"]
[null,35,null,"ECN (K added)",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,-1.5303440238558523E-3,-9.251825514248955E-16,-1.6408121855404108E-4]
[null,36,null,"Total Allowed Revenue",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0870615958288941,7.9848733266722993,4.8477471664716019,11.116423311247262]
[null,37,null,"Collected Revenue",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6895331573333312,7.0870615958288949,7.9850300010242758,4.8477471664716019,11.116587392465814]
[null,38,null,"Under/Over Recovery",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,1.4747299607940079E-3,0,1.5667435197652679E-4,0,1.6408121855171487E-4]
[null,39,null,"ECN Charges Arithmetical April Price Change (%) ",null,null,null,null,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-4.9737792103599521E-2,0.15837823696850303,-0.37240439201052422,1.3640670563307182]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,40,null,"DN Allowed Revenue less ECN Allowed Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.84861690595307,401.49360687553639,396.45023654921567,427.0708524343442,437.53446517165656,448.45260525876256]
[null,41,null,"DN Collectable Revenue less ECN Allowed Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,401.55517269360053,396.45023654921562,427.07069575999219,437.53470100612691,448.45293572259527]
[null,42,null,"DN Under/Over Recovery Carried Forward",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.2651110440469893,6.1565818064138966E-2,0,-1.5667435201294211E-4,2.3583447034525307E-4,3.3046383271084778E-4]
[null,43,null,"LDZ+Customer Arithmetical April Price Change (%) ",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,1.5944066984958379E-2,0.10650214529489185,5.7823210655596417E-2,5.56360522563931E-2]
[]
[null,null,null,"TABLE 5 : SOQ OCTOBER IMPACT ASSUMPTION"]
[]
[null,44,null,"Annual October/April from March 18 SOQ Assumption",null,null,null,-1.43E-2,-3.5000000000000003E-2,-6.6000000000000003E-2,1.6E-2,0,-0.03,-0.03,-0.03,-0.03,null,"16/17 reflects the latest position from AQ and load factor changes from the summer review."]
[null,null,null,"Note: A movement of 1% will equate to a change in transportation prices of approx 1%"]
[]
[null,null,null,"TABLE 6 : ANNUAL ITERATION PROCESS ADJUSTMENTS"]
[null,null,null,null,null,null,null,"Actual","Actual","Actual","Actual","Actual","Forecast","Forecast","Forecast"]
[null,null,null,"Item Description","PCFM Term",null,null,null,"2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"Assumptions","Frequency"]
[null,45,null,"Cost of debt adjustment (drives changes to WACC)","CDE",null,null,null,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5800000000000002E-2,1.1299999999999999E-2,null,null,"Internal NGN Treasury view on IBOXX 10 year rate","Annual"]
[null,46,null,"Cost of debt adjustment - £ effect on revenue - 9/10 prices","CDE £ impact",null,null,null,-1.9826492792511772,-3.7582636937721094,-5.5790833627772258,-7.3944730844739297,-10.686628331710097,-14.722000417543541,-20.624849417592372,null,null,"Cash Impact of the above vs. allowance","Annual"]
[null,47,null,"Tax Trigger Event","TTE",null,null,null,0,-0.29268194863368535,-0.19685269418482676,-1.5508191124258197,-1.3844534664004868,-1.1960955798004989,-2.535955725271549,null,null,"Forecast impact of long term change in Corp. Tax rates","At any time"]
[null,48,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,49,null,"Pension Scheme Established Deficit","EDE",null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081033,-2.7942966052081033,null,null,"31.03.2013 valuation impact, and forecasted 2016 valuation impact","3-yearly review"]
[null,50,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,51,null,"Specified Financial Adjustments - Impact on revenue (9/10 prices)",null,null,null,null,-1.9826492792511772,-3.7312422476139222,-5.45623266217018,-8.6255888021078775,-14.865378403318687,-18.712392602552143,-25.955101748072025]
[null,52,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,53,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,54,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,55,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,null,null,null,null,null,null,null,null,null,null,"No impact","One-off"]
[null,56,null,"Overall legacy adjustments - Impact on revenue (9/10 prices)",null,null,null,null,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896]
[null,57,null,"Totex Incentive Mechanism - Impact on revenue 2 years after  (9/10 prices)",null,null,null,null,0,-2.0440305826387606,-1.4566126363418817,-2.7806280473497438,-4.3889206310587134,-2.7313037388832599,-1.601354361620885,null,null,"Forecasted IQI impact from Totex outperformance"]
[null,58,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,59,null,"Specified Streetworks","IAESW",null,null,null,0,0,0,0,0,0,0,null,null,"No current revenue impact forecast","2 Reopeners"]
[null,60,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,61,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,62,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,63,null,"Fuel Poor Network Extensions","IAEFP",null,null,null,0,0,0.44039938762580277,0.44703528497319667,0.45423635614167779,0.46189279414852535,0.46990821173807262,null,null,"Additional allowances from Ofgem for higher number of FP connections - confirmed Sept 15","1 Reopener (Flexible)"]
[null,64,null,"Agency Costs (FGO)","IAECA",null,null,null,0,0,0,-0.86042197470561721,-1.5664219619677056,-2.1006485042972827,-2.4217101462949699,null,null,"Impact of reduction in xoserve allowances from FGO decision","1 Reopener (Flexible)"]
[null,65,null,"Mains & Services (Repex T2)","RE",null,null,null,null,-0.83958598565060172,-0.72183359008705117,-0.63350022196946565,-0.70529515189831926,-0.72227143440934882,-0.68667132037228429,null,null,"13/14 - 15/16 actual, thereafter assuming workload will be 50% of original allowance","Annual"]
[null,66,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,67,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,68,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210545545344614,-0.1335774007937971,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,"As per Ofgem direction from shrinkage model changes","Annual"]
[null,69,null,"Uncertain costs total - Impact on revenue (9/10 prices)",null,null,null,null,0,-0.83958598565060172,-0.58353965791469453,-1.1804643124956833,-1.9273905528194106,-2.538556819770319,-2.8363385869673725]
[null,null,null,"Other - 1 - blank or if required please provide description "]
[null,null,null,"Other - 2 - blank or if required please provide description "]
[null,null,null,"Other - 3 - blank or if required please provide description "]
[]
[null,70,null,"Total Potential Impact of Revenue Adjustments shown in Table 6",null,null,null,null,0.97285489475525999,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392]
[null,71,null,"Total value included in Table 1 in this forecast",null,null,null,null,0.97285489475525999,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6482996934433558E-2,1.7472114770906266E-2,-5.6227944119523698E-2,0,0,0]

{"sheet":"Mod186 Movement","index":2,"n_rows":111,"n_cols":38,"rows_kept":111,"cut":false,"hidden":false,"merged":[[3,37,3,45],[5,34,6,34],[5,27,6,27],[5,28,6,28],[5,29,6,29],[5,30,6,30],[5,31,6,31],[5,32,6,32],[5,33,6,33],[5,37,8,45],[70,3,70,4],[75,3,75,4],[90,37,90,45],[98,37,98,45],[101,37,101,45],[73,37,75,45],[47,37,50,45],[5,3,6,3],[5,4,6,4],[5,5,6,5],[34,37,34,45],[15,37,15,45],[5,12,6,12],[16,37,16,45],[5,24,6,24],[5,22,6,22],[23,37,24,45],[45,3,45,4],[40,37,43,45],[102,3,102,4],[3,3,3,5],[8,3,8,5],[5,14,6,14],[5,17,6,17],[5,13,6,13],[5,7,6,7],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,8,6,8],[84,3,84,4],[89,3,89,4],[90,3,90,4],[52,3,52,4],[63,3,63,4],[3,7,3,15],[5,15,6,15],[5,25,6,25],[5,35,6,35],[3,17,3,25],[3,27,3,35],[5,18,6,18],[5,19,6,19],[5,20,6,20],[5,21,6,21],[5,23,6,23]]}
[]
[]
[]
[null,"Row ref.",null,"NORTHERN GAS NETWORKS",null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,null,null,null,"MARCH MOD186",null,null,null,null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,null,null,null,"SUPPORTING NOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,null,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,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"21/22 is illustrative only  - it assumes base revenues are flat year on year,  and then flows through any RIIO-GD1 2 year lagged entries from 19/20.  All RIIO-GD2 revenues will be driven from Ofgem modelling/methodologies which will be developed over the next 2-3 years.                                                              ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[]
[]
[null,null,null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + Customer)"]
[]
[null,1,null,"Assumed Year on Year Actual RPI ",null,null,null,2.6499999999999999E-2,3.1E-2,2.5999999999999999E-2,2.3250000000000031E-2,3.400000000000003E-2,null,null,null,null,null,null,3.1E-2,2.5999999999999999E-2,2.3250000000000031E-2,3.400000000000003E-2,null,null,null,null,null,2.6499999999999999E-2]
[null,2,null,"Latest Actual/Projected RPI",null,null,null,2.88464289363441E-2,1.9600131885767733E-2,1.0776609381026855E-2,2.1427497658355051E-2,3.4750000000000107E-2,3.3500000000000037E-2,3.2000000000000077E-2,3.2249999999999848E-2,3.2999999999999904E-2,null,null,1.9600131885767733E-2,1.0776609381026855E-2,2.2250000000000061E-2,3.4750000000000121E-2,3.3500000000000175E-2,3.2000000000000119E-2,3.224999999999982E-2,null,null,2.88464289363441E-2,0,0,-8.2250234164501015E-4,0,-1.3877787807814457E-16,0,0,3.2999999999999904E-2,null,"RPI 5 year forecasts remain as per the Feb 17 Treasury publication until post election - next update August"]
[null,3,null,"Assumed Interest Rate","It",null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,3.3561643835616438E-3,2.8698630136986302E-3,4.4931506849315069E-3,6.7459016393442619E-3,9.986301369863013E-3,1.3000000000000003E-2,null,null,5.0000000000000001E-3,5.0000000000000001E-3,3.3561643835616438E-3,2.8698630136986302E-3,4.4931506849315069E-3,6.7459016393442619E-3,9.986301369863013E-3,null,null,5.0000000000000001E-3,0,0,0,0,0,0,0,1.3000000000000003E-2,null,"16/17 Actual RPI now included which was (0.08%) lower than March forecast."]
[]
[null,4,null,"Opening Base Revenue Allowance","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,341.01740725531073,null,null,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,340.50699531424129,0,0,0,0,0,0,0,341.01740725531073]
[null,5,null,"Price Control Financial Model Iteration Adjustment","MODt",null,null,0,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-19.554571793368861,-22.173495732598031,-28.396169323769392,-28.396169323769392,null,null,0.95799999999999996,-5.514553499721444,-6.2324478434481421,-11.079016524139888,-19.554571793368861,-21.673495732598031,-26.896169323769392,null,null,0,0,0,0,0,0,-0.5,-1.5,-28.396169323769392,null,"Impact of latest cost of debt forecast - assumed rates are shown below in row reference 45"]
[null,6,null,"RPI True Up","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,-2.6610394064885853E-2,0,0,null,null,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.0242287655917244,0.2415428268012062,5.6046589952361681E-14,null,null,0,0,0,0,0,-0.28207265296764272,-0.26815322086609206,-5.6046589952361681E-14,0,null,"Impact of including final RPI for 16/17 regulatory year on the true up"]
[null,7,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3133898502180597,1.3554183254250376,1.3991305664199949,1.4453018751118547,null,null,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3144474546293112,1.3565097731774491,1.400257213362422,null,null,1.163,0,0,0,0,-1.0576044112515781E-3,-1.0914477524115451E-3,-1.1266469424271452E-3,1.4453018751118547]
[null,null,null,"Base Revenue","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,410.67945208978421,425.6309481057225,437.39792970207742,451.83206138224597,null,null,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,411.38092053451578,427.01569388182594,439.85052928397448,null,null,396.00963555046263,0,0,0,0,-0.70146844473157444,-1.3847457761034434,-2.4525995818970614,451.83206138224597]
[]
[null,8,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42562722360036376,5.8274159204022657,6.0153500838352381,6.2138566366017898,null,null,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.39134260943446325,5.7920696170856258,5.9788638622366284,null,null,0,0,0,0,0,3.4284614165900507E-2,3.5346303316639904E-2,3.6486221598609703E-2,6.2138566366017898]
[null,9,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9908797539469393E-2,-6.1763988911131704E-2,-6.3755877553515694E-2,-6.5859821512781705E-2,null,null,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.6666049101113454E-2,-5.8420822517977949E-2,-6.0304894044183079E-2,null,null,0,0,0,0,0,-3.2427484383559385E-3,-3.3431663931537542E-3,-3.4509835093326155E-3,-6.5859821512781705E-2]
[null,10,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2380209686898764,2.2768204257384697,2.3502478844685339,2.4278060646559956,null,null,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2310151876920785,2.3001028725772086,2.3742811902178222,null,null,0,0,0,0,0,7.0057809977979169E-3,-2.3282446838738924E-2,-2.4033305749288303E-2,2.4278060646559956]
[null,11,null,"Others: Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,0,0,0,0,0,0,null,null,-1.8242749999999999E-2,-1.8331E-2,0,0,0,0,0,null,null,7.8759559999999992E-2,0,0,0,0,0,0,0,0]
[null,12,null,"Pass Through","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.70861369343100389,3.5055935921424757,2.6037393947507708,8.0424723572296042,8.3018420907502559,8.5758028797450034,null,null,-1.8242749999999999E-2,0.39925424134292031,0.70861369343100389,3.5055935921424757,2.5656917480254284,8.0337516671448554,8.292840158410268,null,null,7.8759559999999992E-2,0,0,0,0,3.8047646725342332E-2,8.720690084748739E-3,9.001932339987917E-3,8.5758028797450034]
[]
[null,13,null,"Exit Capacity Incentive Revenue","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9300926987772247,1.8128460755617586,1.5260777929398257,0.99121285189824115,null,null,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9300926987772244,1.8128460755617584,1.5260777929398257,null,null,0,0,0,0,0,0,0,0,0.99121285189824115]
[null,14,null,"Exit Capacity Allowance Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,-1.5587100522651507,null,null,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9430509086902457,-4.5313351423227699,-6.480832778680595,null,null,0,0,0,0,0,1.0001199648580261E-2,0.63072009904134596,-0.94179512235115759,-1.5587100522651507,null,"Updated to reflect latest set of Indicative NTS prices published in April 17"]
[null,15,null,"NTS Exit Capacity Revenue Adjustment","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0029570102644407,-2.0877689677196654,-5.8965501080919269,-0.56749720036690954,null,null,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0129582099130214,-2.7184890667610118,-4.9547549857407693,null,null,0,0,0,0,0,1.0001199648580705E-2,0.6307200990413464,-0.94179512235115759,-0.56749720036690954]
[]
[null,16,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.0362141281641657,-6.9272492758046305,-7.3549049722594573,-7.7018558267016015,null,null,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.0771304404194844,-6.7964219388942819,-6.9552754239177892,null,null,0,0,0,0,0,4.0916312255318665E-2,-0.13082733691034854,-0.39962954834166808,-7.7018558267016015,null,"Updated to reflect latest long term UK gas prices as at 24/05/2017"]
[null,17,null,"Shrinkage Incentive Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.56566492100254073,0.61875416863662702,0.61436104957349347,0.60632695649242019,null,null,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.56261934818920567,0.63326470183688888,0.65735430896701863,null,null,0,0,0,0,0,3.0455728133350624E-3,-1.4510533200261855E-2,-4.2993259393525163E-2,0.60632695649242019]
[null,18,null,"Shrinkage Allowance Rev Adjustment","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4705492071616248,-6.3084951071680031,-6.7405439226859638,-7.095528870209181,null,null,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.5145110922302791,-6.1631572370573933,-6.2979211149507703,null,null,0,0,0,0,0,4.3961885068654283E-2,-0.14533787011060983,-0.44262280773519347,-7.095528870209181]
[]
[null,19,null,"Broad Measure of Customer Satisfaction","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.0502608515814709,3.0085042909545647,3.0909542364897487,3.185391006607051,null,null,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.0502608515814709,3.0085042909545647,3.0945720415796609,null,null,0,0,0,0,0,0,0,-3.6178050899122738E-3,3.185391006607051]
[null,20,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,3.192177531877407,3.3540080013561226,3.472973382465594,3.6387993719878358,null,null,0,2.0544320472078006,2.819183646010214,3.0799122187215673,3.1947480261131065,3.3567088092366002,3.4757699869687015,null,null,0,0,0,0,0,-2.5704942356994387E-3,-2.7008078804775515E-3,-2.7966045031075915E-3,3.6387993719878358]
[null,21,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.8,0,0,null,null,0.83327062499999982,0,0.8,0,0,0.8,0,null,null,1.1110274999999998,0,0,0,0,0,0,0,0]
[null,22,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.5562116780691873,2.5007691837990245,2.5872805481656407,2.6814749730660519,2.7556069571230877,0,null,null,2.1268943999999999,2.6537751000000003,2.5562116780691873,2.5007691837990245,2.5916997993674493,2.6901988714555034,2.7710583344890392,null,null,1.181812788,0,0,0,0,-4.4192512018086383E-3,-8.7238983894515343E-3,-1.545137736595148E-2,0]
[null,23,null,"Correction Term revenue Adjustment (K added)","Kt",null,null,-3.0734937387362518,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.1021060536889,-6.54178924246238E-2,0,5.9530722902600659E-14,null,null,0,-3.1763272797327131,2.7784430349248272,6.4989282987774661,-10.074566992616083,-7.0598251629406916E-2,-2.3684673316477325E-13,null,null,-3.0734937387362518,0,0,0,0,-2.7539061072817006E-2,5.1803592047831165E-3,2.3684673316477325E-13,5.9530722902600659E-14]
[]
[null,24,null,"Maximum DN Allowed Revenue (incl NTS Exit)","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.61306338350113,409.18166530290893,403.53729814504459,435.0557257610165,442.38221233812817,459.56902857000983,null,null,412.18006588561792,421.21690097198604,411.61306338350113,409.18166530290893,404.18128466484387,435.95261296516958,446.23209370473046,null,null,395.30774165972633,0,0,0,0,-0.64398651979928445,-0.89688720415307444,-3.8498813666022897,459.56902857000983]
[null,25,null,"Collectable Revenue (including NTS Exit)","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,409.24470585093388,403.53729814504453,435.05572576101645,442.38244817259852,459.56952311506109,null,null,409.50951318,414.96025073999999,421.33235105314503,409.24969795127726,404.1812846648441,435.95261296516964,446.23209370473029,null,null,398.36072827999999,0,0,2.6567896854999162E-2,-4.9921003433723854E-3,-0.64398651979956867,-0.89688720415318812,-3.849645532131774,459.56952311506109]
[null,26,null,"Under/Over-Recovery Carried Forward  (including NTS Exit)","Rt - ARt",3.013229155623776,null,3.0529866202736571,-2.6705527056179221,-6.2566502319860433,9.7458555664989035,6.3040548024957843E-2,0,0,2.3583447034525307E-4,4.9454505125368087E-4,null,null,-2.6705527056179221,-6.2566502319860433,9.7192876696439043,6.8032648368330229E-2,0,0,0,null,null,3.0529866202736571,0,0,2.6567896854999162E-2,-4.9921003433723854E-3,0,0,2.3583447034525307E-4,4.9454505125368087E-4]
[null,27,null,"Total incl Exit - Arithmetical April Price Change (%) ",null,null,null,5.0609507050951102E-2,4.9377871620601733E-2,6.1468011442234696E-2,4.2053798015704705E-2,-3.5050122301578224E-2,1.4810448459786334E-2,0.10743710254609998,5.3159760460817808E-2,8.653794832459763E-2,null,null,4.9377871620601733E-2,6.1468011442234696E-2,4.2053798015704705E-2,-3.5050122301578224E-2,1.7068387963345751E-2,0.10794579082528487,5.7878321437629131E-2,null,null,5.0609507050951102E-2,0,0,0,0,-2.2579395035594169E-3,-5.0868827918489068E-4,-4.7185609768113229E-3,8.653794832459763E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT"]
[]
[null,28,null,"NGN Specifc - average AQ",null,null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","","",null,null,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",null,null,14800.269162497658,0,0,0,"","","","",""]
[null,29,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)",null,null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,129.02776961798671,127.24792421669012,137.1866696737826,139.49693990908517,144.91648030709462,null,null,131.25027193559805,134.38640330118304,129.79446543550341,129.02776961798671,127.45099329666039,137.46948624491395,140.71092784683597,null,null,125.91460982717436,0,0,0,0,-0.20306907997026258,-0.28281657113134884,-1.2139879377508009,144.91648030709462]
[null,30,null,"Total annual charges £ (excl.exit capacity) - (14/15 prices)",null,null,null,128.38255278613195,131.25027193559805,132.95361413584527,125.71683696086805,120.77721932054072,115.25029930743219,120.39919176566238,118.60184563441969,119.27357114740421,null,null,131.25027193559805,132.95361413584527,125.61568519487685,120.68004197086253,115.34134355840035,120.5503272888768,119.53773413615582,null,null,128.38255278613195,0,0,0.10115176599120446,9.7177349678190694E-2,-9.1044250968167262E-2,-0.15113552321442114,-0.93588850173613025,119.27357114740421]
[null,31,null,"% movement in domestic customer bill - (14/15 prices)",null,null,null,0,2.2337296519125305E-2,1.2977818446601175E-2,-5.4430842079877917E-2,-3.9291615663738733E-2,-4.5761278858724053E-2,4.4675740446412426E-2,-1.4928224225466025E-2,5.6637020224379331E-3,null,null,2.2337296519125305E-2,1.2977818446601175E-2,-5.5191647016612166E-2,-3.9291615663738844E-2,-4.4238453395228139E-2,4.5161462228320515E-2,-8.3997544883847031E-3,null,null,0,0,0,7.6080493673424954E-4,1.1102230246251565E-16,-1.5228254634959137E-3,-4.8572178190808835E-4,-6.5284697370813216E-3,5.6637020224379331E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAP. ONLY)"]
[]
[null,32,null,"Initial Allowed Revenue","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,8.77,null,null,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,8.8699999999999992,0,0,0,0,0,0,0,8.77]
[null,33,null,"Inflated Base Allowance",null,null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.518428986412383,11.887018713977579,12.270375067503355,12.675297444730965,null,null,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.527704177099059,11.896590710766228,12.280255761188441,null,null,10.315809999999999,0,0,0,0,-9.2751906866759271E-3,-9.571996788649173E-3,-9.8806936850852622E-3,12.675297444730965]
[null,34,null,"Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9330497090416654,-3.9006150432814239,-7.4226279010317526,-1.5587100522651507,null,null,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9430509086902457,-4.5313351423227699,-6.480832778680595,null,null,0,0,0,0,0,1.0001199648580261E-2,0.63072009904134596,-0.94179512235115759,-1.5587100522651507]
[null,35,null,"ECN (K added)",null,null,null,0.54524476049999981,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.49831768154182421,-1.5303440238558523E-3,-9.251825514248955E-16,-1.6408121855404108E-4,null,null,0,-1.2253123207802016E-2,7.78112457077762E-2,-1.466231685652297E-2,-0.50015418581355542,-8.4523393219647219E-3,9.4324565975077203E-4,null,null,0.54524476049999981,0,0,0,0,1.8365042717312097E-3,6.9219952981088694E-3,-9.4324565975169718E-4,-1.6408121855404108E-4]
[null,36,null,"Total Allowed Revenue",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0870615958288941,7.9848733266722993,4.8477471664716019,11.116423311247262,null,null,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0844990825952578,7.3568032291214935,5.8003662281675963,null,null,10.861054760499998,0,0,0,0,2.56251323363621E-3,0.62807009755080578,-0.95261906169599442,11.116423311247262]
[null,37,null,"Collected Revenue",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6895331573333312,7.0870615958288949,7.9850300010242758,4.8477471664716019,11.116587392465814,null,null,10.626338000000001,6.5506565999999991,9.2469627400000007,7.6962036011652195,7.0835935635296678,7.3568032291214944,5.8002340568523207,null,null,10.87283208,0,0,-1.7717399999988004E-3,-6.6704438318883064E-3,3.4680322992270973E-3,0.62822677190278142,-0.95248689038071888,11.116587392465814]
[null,38,null,"Under/Over Recovery",null,null,null,1.1777319500001937E-2,-7.4789740203552668E-2,1.4115710151636485E-2,0.48074452245191246,1.4747299607940079E-3,0,1.5667435197652679E-4,0,1.6408121855171487E-4,null,null,-7.4789740203552668E-2,1.4115710151636485E-2,0.48251626245191126,8.1451737926823142E-3,-9.0551906558999917E-4,0,-1.3217131527554216E-4,null,null,1.1777319500001937E-2,0,0,-1.7717399999988004E-3,-6.6704438318883064E-3,9.0551906558999917E-4,1.5667435197652679E-4,1.3217131527554216E-4,1.6408121855171487E-4]
[null,39,null,"ECN Charges Arithmetical April Price Change (%) ",null,null,null,null,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-4.9737792103599521E-2,0.15837823696850303,-0.37240439201052422,1.3640670563307182,null,null,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-5.1132979937137495E-2,6.7764678497577072E-2,-0.18497136863192448,null,null,0,0,0,0,0,1.3951878335379739E-3,9.0613558470925962E-2,-0.18743302337859974,1.3640670563307182]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,40,null,"DN Allowed Revenue less ECN Allowed Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.84861690595307,401.49360687553639,396.45023654921567,427.0708524343442,437.53446517165656,448.45260525876256,null,null,401.47893814541436,414.68036008213767,402.84861690595307,401.49360687553639,397.09678558224863,428.59580973604807,440.43172747656286,null,null,384.44668689922634,0,0,0,0,-0.64654903303295441,-1.5249573017038642,-2.8972623049062918,448.45260525876256]
[null,41,null,"DN Collectable Revenue less ECN Allowed Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,401.55517269360053,396.45023654921562,427.07069575999219,437.53470100612691,448.45293572259527,null,null,398.88317518000002,408.40959413999997,412.08538831314502,401.55349435011203,397.09769110131441,428.59580973604812,440.43185964787796,null,null,387.48789619999997,0,0,2.8339636855037043E-2,1.6783434884928283E-3,-0.6474545520987931,-1.525113976055934,-2.897158641751048,448.45293572259527]
[null,42,null,"DN Under/Over Recovery Carried Forward",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.2651110440469893,6.1565818064138966E-2,0,-1.5667435201294211E-4,2.3583447034525307E-4,3.3046383271084778E-4,null,null,-2.5957629654143375,-6.2707659421377002,9.2367714071919522,5.9887474575646138E-2,9.0551906578184571E-4,0,1.3217131510145919E-4,null,null,3.0412093007736303,0,0,2.8339636855037043E-2,1.6783434884928283E-3,-9.0551906578184571E-4,-1.5667435201294211E-4,1.0366315524379388E-4,3.3046383271084778E-4]
[null,43,null,"LDZ+Customer Arithmetical April Price Change (%) ",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,1.5944066984958379E-2,0.10650214529489185,5.7823210655596417E-2,5.56360522563931E-2,null,null,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,1.8263823147147921E-2,0.10862385657860515,6.1035013124920635E-2,null,null,5.1999999999999998E-2,0,0,0,0,-2.3197561621895423E-3,-2.1217112837133012E-3,-3.2118024693242181E-3,5.56360522563931E-2]
[]
[null,null,null,"TABLE 5 : SOQ OCTOBER IMPACT ASSUMPTION"]
[]
[null,44,null,"Annual October/April from March 18 SOQ Assumption",null,null,null,-1.43E-2,-3.5000000000000003E-2,-6.6000000000000003E-2,1.6E-2,0,-0.03,-0.03,-0.03,-0.03,null,null,-3.5000000000000003E-2,-6.6000000000000003E-2,1.6E-2,0,-0.03,-0.03,-0.03,null,null,-1.43E-2,0,0,0,0,0,0]
[null,null,null,"Note: A movement of 1% will equate to a change in transportation prices of approx 1%"]
[]
[null,null,null,"TABLE 6 : ANNUAL ITERATION PROCESS ADJ (9/10 PRICES)"]
[]
[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,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,45,null,"Cost of Debt Adjustment (drives changes to WACC)","CDE",null,null,0,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5800000000000002E-2,1.1299999999999999E-2,null,null,null,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6299999999999999E-2,1.2200000000000001E-2,null,null,0,0,0,0,0,-1.0000000000000286E-4,-4.9999999999999697E-4,-9.0000000000000149E-4,0]
[null,46,null,"Cost of debt adjustment - £ effect on revenue - (9/10 prices)","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582636937721094,-5.5790833627772258,-7.3944730844739297,-10.686628331710097,-14.722000417543541,-20.624849417592372,null,null,null,-2.007388401208118,-3.7582636937721094,-5.5790833627772258,-7.3944730844739297,-10.686628331710097,-14.222000417543541,-19.124849417592372,null,null,0,2.4739121956940835E-2,0,0,0,0,-0.5,-1.5,0]
[null,47,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.19685269418482676,-1.5508191124258197,-1.3844534664004868,-1.1960955798004989,-2.535955725271549,null,null,null,0,-0.29268194863368535,-0.19685269418482676,-1.5508191124258197,-1.3844534664004868,-1.1960955798004989,-2.535955725271549,null,null,0,0,0,0,0,0,0,0,0]
[null,48,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,49,null,"Pension Scheme Established Deficit","EDE",null,null,0,0,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081033,-2.7942966052081033,null,null,null,null,0.3197033947918726,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-2.7942966052081033,-2.7942966052081033,null,null,0,0,0,0,0,0,0,0,0]
[null,50,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,51,null,"Specified Financial Adjustments - Impact on revenue (9/10 prices)",null,null,null,0,-1.9826492792511772,-3.7312422476139222,-5.45623266217018,-8.6255888021078775,-14.865378403318687,-18.712392602552143,-25.955101748072025,null,null,null,-2.007388401208118,-3.7312422476139222,-5.45623266217018,-8.6255888021078775,-14.865378403318687,-18.212392602552143,-24.455101748072025,null,null,0,2.4739121956940835E-2,0,0,0,0,-0.5,-1.5,0]
[null,52,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,null,null,null,-14.073390704007844,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,53,null,"Legacy Allowed Revenue Adjustment","LAR",null,null,0,17.398062412967949,0,0,0,0,0,0,null,null,null,17.398062412967949,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,54,null,"Legacy IFI Cap Adjustment","IFIAR",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,55,null,"Legacy Streetworks Cost Adjustment","IAEAR",null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,56,null,"Overall legacy adjustments - Impact on revenue (9/10 prices)",null,null,null,0,2.9555041740064372,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,null,2.9556922968116788,1.1167883131162739,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,0,-1.881228052416084E-4,0,0,0,0,0,0,0]
[null,57,null,"Totex Incentive Mechanism - Impact on revenue 2 years after  (9/10 prices)",null,null,null,0,0,-2.0440305826387606,-1.4566126363418817,-2.7806280473497438,-4.3889206310587134,-2.7313037388832599,-1.601354361620885,null,null,null,0,-2.0440305826387606,-1.4566126363418817,-2.7806280473497438,-4.3889206310587134,-2.7313037388832599,-1.601354361620885,null,null,0,0,0,0,0,0,0,0,0]
[null,58,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,59,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,60,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,61,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,62,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,63,null,"Fuel Poor Network Extensions","IAEFP",null,null,0,0,0,0.44039938762580277,0.44703528497319667,0.45423635614167779,0.46189279414852535,0.46990821173807262,null,null,null,0,0,0.44039938762580277,0.44703528497319667,0.45423635614167779,0.46189279414852535,0.46990821173807262,null,null,0,0,0,0,0,0,0,0,0]
[null,64,null,"Agency Costs (FGO)","IAECA",null,null,0,0,0,0,-0.86042197470561721,-1.5664219619677056,-2.1006485042972827,-2.4217101462949699,null,null,null,0,0,0,-0.86042197470561721,-1.5664219619677056,-2.1006485042972827,-2.4217101462949699,null,null,0,0,0,0,0,0,0,0,0]
[null,65,null,"Mains & Services (Repex T2)","RE",null,null,0,0,-0.83958598565060172,-0.72183359008705117,-0.63350022196946565,-0.70529515189831926,-0.72227143440934882,-0.68667132037228429,null,null,null,null,-0.83958598565060172,-0.72183359008705117,-0.63350022196946565,-0.70529515189831926,-0.72227143440934882,-0.68667132037228429,null,null,0,0,0,0,0,0,0,0,0]
[null,66,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,67,null,"NTS Exit Capacity Costs","AEx",null,null,null,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,0]
[null,68,null,"Shrinkage Costs","ALSC",null,null,null,0,0,-0.30210545545344614,-0.1335774007937971,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,null,0,0,-0.30210545545344614,-0.1335774007937971,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,null,0,0,0,0,0,0,0,0]
[null,69,null,"Uncertain costs total - Impact on revenue (9/10 prices)",null,null,null,0,0,-0.83958598565060172,-0.58353965791469453,-1.1804643124956833,-1.9273905528194106,-2.538556819770319,-2.8363385869673725,null,null,null,0,-0.83958598565060172,-0.58353965791469453,-1.1804643124956833,-1.9273905528194106,-2.538556819770319,-2.8363385869673725,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"Other - 1 - blank or if required please provide description ",null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"Other - 2 - blank or if required please provide description ",null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,"Other - 3 - blank or if required please provide description ",null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,null,null,0,0,0,0,0,0,0,0,0]
[]
[null,70,null,"Total Potential Impact of Revenue Adjustments shown in Table 5",null,null,null,0,0.97285489475525999,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392,null,null,null,0.94830389560356076,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-21.673495732598028,-26.896169323769392,null,null,0,2.4550999151699227E-2,0,0,0,0,-0.5,-1.5,0]
[null,71,null,"Total value included in Table 1 in this forecast",null,null,null,0,0.97285489475525999,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-22.173495732598028,-28.396169323769392,null,null,null,0.94830389560356076,-5.4980705027870105,-6.2149757286772358,-11.135244468259412,-19.554571793368861,-21.673495732598028,-26.896169323769392,null,null,0,2.4550999151699227E-2,0,0,0,0,-0.5,-1.5,0]
[]
[null,null,null,"Check mod breakdown ties into mod in above table",null,null,null,0,1.4854894755260029E-2,1.6482996934433558E-2,1.7472114770906266E-2,-5.6227944119523698E-2,0,0,0,null,null,0,-9.696104396439198E-3,null,null,null,null,null,null,null,null,null,2.4550999151699227E-2,0,0,0,0,0,0,28.396169323769392]

{"sheet":"High level mod186 rec","index":3,"n_rows":108,"n_cols":12,"rows_kept":108,"cut":false,"hidden":true,"merged":[[35,1,35,2],[33,1,33,6],[84,1,84,11]]}
[]
[null,"MOD186 Reconciliation - March 2017 to June 2017"]
[]
[null,"ALLOWED REVENUE",null,"13/14","14/15","15/16","16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"MARCH",null,0,412.18006588561792,421.21690097198604,411.61306338350113,409.18166530290893,404.18128466484387,435.95261296516958,446.23209370473046,0]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   March",null,0,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9300000000000001E-2,1.6299999999999999E-2,1.2200000000000001E-2,0]
[null,"Cost of debt %   June",null,0,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5800000000000002E-2,1.1299999999999999E-2,0]
[null,"Cost of debt £ movement",null,0,2.4739121956940835E-2,0,0,0,0,-0.5,-1.5,0]
[]
[null,"Totex Incentive",null,0,0,0,0,0,0,0,0,0]
[]
[null,"Pension deficit valuation",null,0,0,0,0,0,0,0,0,0]
[]
[null,"Tax trigger - Corp. Tax rates long term impact",null,0,0,0,0,0,0,0,0,0]
[]
[null,"Repex Tier 2a",null,0,0,0,0,0,0,0,0,0]
[]
[null,"FGO Impact",null,null,0,0,0,0,0,0,0,0]
[]
[null,"Ofgem changes to Fuel Poor allowances",null,0,0,0,0,0,0,0,0,0]
[]
[null,"\"MOD\" Adjustment (Cost of Debt new long term forecast)",null,0,2.4739121956940835E-2,0,0,0,0,-0.5,-1.5,0]
[]
[null,"Change in Inflation %"]
[null,"March (Based on HM Treasury Feb report)",null,0,1.9600131885767733E-2,1.0776609381026855E-2,2.2250000000000061E-2,3.4750000000000121E-2,3.3500000000000175E-2,3.2000000000000119E-2,3.224999999999982E-2,0]
[null,"June (Based on HM Treasury May report)",null,2.88464289363441E-2,1.9600131885767733E-2,1.0776609381026855E-2,2.1427497658355051E-2,3.4750000000000107E-2,3.3500000000000037E-2,3.2000000000000077E-2,3.2249999999999848E-2,3.2999999999999904E-2]
[null,"Difference",null,2.88464289363441E-2,0,0,-8.2250234164501015E-4,0,-1.3877787807814457E-16,0,0,3.2999999999999904E-2]
[null,"Cumulative change in inflation",null,null,null,null,-8.2250234164501015E-4,-8.2250234164501015E-4,-8.2250234164514893E-4,-8.2250234164514893E-4,-8.2250234164514893E-4,3.2177497658354759E-2]
[]
[null,"£ impact on change in inflation (including changes in \"Mod\" above)",null,null,null,null,null,0,-0.41939579176393171,-0.61659255523735135,-0.95259958189700533,451.83206138224597]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 17/18)",null,0,0,0,0,0,-0.28207265296764272,-0.26815322086609206,-5.6046589952361681E-14,0]
[]
[null,"Total base revenue changes",null,0,2.4739121956940835E-2,0,0,0,-0.70146844473157444,-1.3847457761034434,-2.4525995818970614,451.83206138224597]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,0,0,0,-3.6178050899122738E-3,3.185391006607051]
[null,"Shrinkage/Leakage",null,0,0,0,0,0,4.7507857763562367E-4,-1.7211341080739406E-2,-4.5789863896632754E-2,4.2451263284802563]
[null,"DRS",null,1.1110274999999998,0,0,0,0,0,0,0,0]
[null,"Exit",null,0,0,0,0,0,0,0,0,0.99121285189824115]
[null,"Total",null,1.1110274999999998,0,0,0,0,4.7507857763562367E-4,-1.7211341080739406E-2,-4.9407668986545028E-2,8.421730186985549]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,0,0,3.4284614165900507E-2,3.5346303316639904E-2,3.6486221598609703E-2,6.2138566366017898]
[null,"License Fee",null,0,0,0,0,0,-3.2427484383559385E-3,-3.3431663931537542E-3,-3.4509835093326155E-3,-6.5859821512781705E-2]
[null,"Pension Deficit",null,0,0,0,0,0,7.0057809977979169E-3,-2.3282446838738924E-2,-2.4033305749288303E-2,2.4278060646559956]
[null,"Exit Capacity",null,0,0,0,0,0,1.0001199648580261E-2,0.63072009904134596,-0.94179512235115759,-1.5587100522651507]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,0,0,0,4.0916312255318665E-2,-0.13082733691034854,-0.39962954834166808,-7.7018558267016015]
[null,"Others",null,7.8759559999999992E-2,0,0,0,0,-1.5265566588595902E-16,1.5543122344752192E-15,0,0]
[null,"Total",null,7.8759559999999992E-2,0,0,0,0,8.8965158629241259E-2,0.50861345221574616,-1.3324227383528369,-0.68476299922174899]
[]
[null,"Network Innovation",null,1.181812788,0,0,0,0,-4.4192512018086383E-3,-8.7238983894515343E-3,-1.545137736595148E-2,0]
[]
[null,"K factor",null,-3.0734937387362518,0,0,0,0,-2.7539061072817006E-2,5.1803592047831165E-3,2.3684673316477325E-13,5.9530722902600659E-14]
[]
[null,"JUNE",null,-0.70189389073625197,412.20480500757486,421.21690097198604,411.61306338350113,409.18166530290893,403.53729814504453,435.05572576101645,442.38221233812828,459.56902857000983]
[null,"Difference",null,-0.70189389073625197,2.4739121956940835E-2,0,0,0,-0.64398651979934129,-0.89688720415313128,-3.8498813666021761,459.56902857000983]
[]
[null,"COLLECTED REVENUE £",null,"13/14","14/15","15/16","16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"March",null,0,409.50951318,414.96025073999999,421.33235105314503,409.24969795127726,404.1812846648441,435.95261296516964,446.23209370473029,0]
[null,"June",null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,409.24470585093388,403.53729814504453,435.05572576101645,442.38244817259852,459.56952311506109]
[null,"Difference",null,398.36072827999999,0,0,2.6567896854999162E-2,-4.9921003433723854E-3,-0.64398651979956867,-0.89688720415318812,-3.849645532131774,459.56952311506109]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,"PRICE CHANGE % IMPACT",null,"13/14","14/15","15/16","16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"LDZ Price Change %","March",0,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,1.8263823147147921E-2,0.10862385657860515,6.1035013124920635E-2,0]
[null,"LDZ Price Change %","June",5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,1.5944066984958379E-2,0.10650214529489185,5.7823210655596417E-2,5.56360522563931E-2]
[null,"LDZ PRICE CHANGE %","Difference",5.1999999999999998E-2,0,0,0,0,-2.3197561621895423E-3,-2.1217112837133012E-3,-3.2118024693242181E-3,5.56360522563931E-2]
[]
[null,"Exit Cap. Price Change %","March",0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-5.1132979937137495E-2,6.7764678497577072E-2,-0.18497136863192448,0]
[null,"Exit Cap. Price Change %","June",0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-4.9737792103599521E-2,0.15837823696850303,-0.37240439201052422,1.3640670563307182]
[null,"EXIT CAP. PRICE CHANGE %","Difference",0,0,0,0,0,1.3951878335379739E-3,9.0613558470925962E-2,-0.18743302337859974,1.3640670563307182]
[]
[null,"Total Price Change","March",0,4.9377871620601733E-2,6.1468011442234696E-2,4.2053798015704705E-2,-3.5050122301578224E-2,1.7068387963345751E-2,0.10794579082528487,5.7878321437629131E-2,0]
[null,"Total Price Change","June",5.0609507050951102E-2,4.9377871620601733E-2,6.1468011442234696E-2,4.2053798015704705E-2,-3.5050122301578224E-2,1.4810448459786334E-2,0.10743710254609998,5.3159760460817808E-2,8.653794832459763E-2]
[null,"TOTAL PRICE CHANGE %","Difference",5.0609507050951102E-2,0,0,0,0,-2.2579395035594169E-3,-5.0868827918489068E-4,-4.7185609768113229E-3,8.653794832459763E-2]
[]
[null,"21/22 are illustrative only assuming flat base revenues year on year.  The final outcome could be significantly different to this."]
[]
[]
[null,"CUSTOMER BILL IMPACT",null,"13/14","14/15","15/16","16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"Customer Bill Impact"]
[]
[null,"Assumed TDCV KWh","March",0,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",0]
[null,"Average Customer Bill","March (14/15 prices)",0,131.25027193559805,132.95361413584527,125.61568519487685,120.68004197086253,115.34134355840035,120.5503272888768,119.53773413615582,0]
[]
[null,"Assumed TDCV KWh","June",14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,"","","","",""]
[null,"Average Customer Bill","June (14/15 prices)",128.38255278613195,131.25027193559805,132.95361413584527,125.71683696086805,120.77721932054072,115.25029930743219,120.39919176566238,118.60184563441969,119.27357114740421]
[]
[null,"Difference in Customer Bill £",null,128.38255278613195,0,0,0.10115176599120446,9.7177349678190694E-2,-9.1044250968167262E-2,-0.15113552321442114,-0.93588850173613025,119.27357114740421]
[]
[null,"Assumed TDCV KWh","Variance"]
[null,"Average Customer Bill","Variance"]
[]
[]
[]
[]
[null,"Checks",null,-396.00963555046258,2.4739121956997678E-2,0,0,0,0,0,0,0]
[null,"Checks",null,0,0,0,0,0,0,0,0,0]
[null,"Checks",null,-396.00963555046258,2.4739121956940835E-2,0,0,0,-5.6843418860808015E-14,-5.6843418860808015E-14,1.1368683772161603E-13,0]