{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement","High level mod186 rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":64,"comments":1,"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":160,"n_cols":19,"rows_kept":160,"cut":false,"hidden":false,"merged":[[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[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],[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]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,"Published:",null,"2018-12-13T11:41:14.710",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.3585882060712484,1.4013837345624929]
[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.7421255484442417E-2,3.3500000000000085E-2,3.1749999999999945E-2,3.1500000000000083E-2,null,null,"As per November 2018 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,2.0000000000008206E-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.952189040023597,-27.078508294680468,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.83051422427869837,0.6971530585795408,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,112.63265058988338,126.28979358746921]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73291569314847,440.92584560667899]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0742468262679523,5.227630491292639]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32120995798630503,0.3309194503080653]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2604755471979212,2.0190249116348156]
[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.6559323314521786,7.5775748532355198]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.166334221817201,2.0078431706682105,null,null,"Data uses finalised July 2018 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.0425888310073201,-8.8034580185673512,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.8762546091901191,-6.7956148478991407]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0013930029813272,null,null,"13/14 - 17/18 actual volume impact with forecast thereafter"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5132278281334512,-5.3091842253429053,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.7036862634216678,-4.307791222361578]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072477837255715,3.1785616077964924,null,null,"Assumes customer service scores and stakeholder results will continue at GD1 average rate"]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.6042170830009672,null,null,"13/14 - 17/18 actual volume impact with forecast thereafter"]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,null,null,"DRS from 11/12, 12/13,14/15/17/18"]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.6884173688668356,2.7778328273220776,null,null,"Actual spend 13/14 - 17/18, 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.3531751492592994,0.29173682062174816]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.2523627283951,448.2523627283951]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,409.25787448087954,436.09492627028703,448.25236272839498,448.25219523406184]
[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.3003969908901354,-0.27828399974220019,0,0,-1.6749433325458085E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,1.2002290917640934E-3,6.4850849527422039E-2,2.7877958962019722E-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,-3.1791033300202472E-3,6.7951020680233278E-4,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,0.02,0.02,null,null,"Latest view on how much load factors could move capacity levels"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.4234304192268163E-3,-4.0915223507130109E-3,9.4906586396109154E-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.5094262359407283E-2,-1.4015481016426846E-2,8.1438837383511362E-2,5.7368617601630638E-2,1.9710974447135446E-2]
[]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,"2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,null,null,"Allowed Revenues £m","Nom Prices",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.2523627283951]
[null,null,null,"Customer Numbers","NE",null,null,1330690,1333453,1335700,1340114,1345753]
[null,null,null,null,"NO",null,null,1150915,1151968,1153630,1156041,1160912]
[null,null,null,null,"Total",null,null,2481605,2485421,2489330,2496155,2506665,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018"]
[null,null,null,"AQ","NE",null,null,20064174039,19855434991,19100583241,18993861267,19059743380]
[null,null,null,null,"NO",null,null,16664247916,16704443457,16285308941,15871167741,15841637342]
[null,null,null,null,"Total",null,null,36728421955,36559878448,35385892182,34865029008,34901380722,0,0,0,0]
[]
[null,null,null,"Average AQ","NE",null,null,15078.02270927113,14890.239844223981,14300.054833420678,14173.317543880596,14162.883813002833,"","","",""]
[null,null,null,null,"NO",null,null,14479.130010469931,14500.787744972082,14116.578921317927,13728.896934451286,13645.855449853219,"","","",""]
[null,null,null,null,"Total",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,"","","",""]
[]
[null,null,null,"Load Factors","NE",null,null,0.34100000000000003,0.34399999999999997,0.35099999999999998,0.35599999999999998,0.33900000000000002]
[null,null,null,null,"NO",null,null,0.317,0.317,0.314,0.34499999999999997,0.34300000000000003]
[null,null,null,null,"Average",null,null,0.3298693164302941,0.33148576760234982,0.33385309300092797,0.35090558438878994,0.34085252038066521,"","","",""]
[]
[null,null,null,"SOQ","NE",null,null,121,119,112,109,114,"","","",""]
[null,null,null,null,"NO",null,null,125,125,123,109,109,"","","",""]
[null,null,null,null,"Total",null,null,123,122,117,109,112,"","","",""]
[]
[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.3399999999999999E-2,3.5499999999999997E-2,3.5499999999999997E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21199999999999999,0.22520000000000001,0.22520000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1132,0.1202,0.1202]
[]
[null,null,null,"Charges","Commodity",null,null,4.114474827174349,4.2952419355980336,4.4350883011830486,4.5115004355034047,4.3580343468257627,"","","",""]
[null,null,null,null,"Capacity",null,null,79.419255000000007,82.781270000000006,84.726719999999986,81.678605000000005,81.228559999999987,"","","",""]
[null,null,null,null,"Fixed",null,null,42.380879999999998,44.173760000000001,45.224595000000001,43.604360000000007,43.373680000000007,"","","",""]
[null,null,null,null,"Total",null,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,0,0,0,0]
[]
[null,null,null,"Latest allowed revenue phasing",null,null,null,395.30774165972633,412.18006588561786,421.21690097198598,411.31483044543188,409.0452105191099,409.53615848062174,436.09492627028703,448.2523627283951,448.2523627283951]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,14800.269162497658,14709.732656157648,14215.026606355927,13967.493608369672,13923.432417973681,"","","",""]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",121.13327029305293,null,125.91460982717436,131.25027193559805,134.38640330118304,129.79446543550341,128.96027434682577,129.11505621977872,137.48827730241223,141.32116985480766,141.32116985480766]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (17/18 Prices)","17/18 prices",136.10113598642835,null,137.50670563615202,140.57823369331484,142.40263248773053,134.65153728703203,128.96027434682577,124.92990442165333,128.93793540564789,128.48517874700349,125.38197486899581]
[null,37,null,"% movement in domestic customer bill - (17/18 prices)",null,null,null,null,2.2337296519125527E-2,1.2977818446600953E-2,-5.4430842079877584E-2,-4.2266602037185685E-2,-3.1252802039899219E-2,3.2082238456430545E-2,-3.5114309626566031E-3,-2.415223225176899E-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.914818567244849,12.290135352113062]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0425888310073201,-8.8034580185673512,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.0544737852273769E-2,-6.93430723425668E-2]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8927744740898023,3.4173342612031434]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1565469251612894,7.892999781750822,3.4181289585900614]
[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,6.614546454841097E-2,2.2530766101969135E-4,7.94697386917953E-4]
[]
[null,45,null,"Year on Year movement in Allowed Revenue",null,null,null,"",-1.4724814838248945E-2,-0.38917270697639328,null,null,-7.7738348687851122E-2,0.11316326979989766,-0.56703003836971644]
[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,-9.3288743826211371E-3,-2.8546065994831799E-5]
[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,-2.9899297300658191E-3,-9.8345305904589571E-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.1208444656872107,-0.55689311502617023]
[]
[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.35715209173736,402.44575702000884,428.2021517961972,444.83502846719193]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,402.10132755571823,428.20192648853623,444.83423376980494]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,3.013229155623776,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.3201404182626675,-0.34442946429061294,-2.2530766096906518E-4,-7.9469738699344816E-4]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,2.7123097784556016E-3,6.3999667848176012E-2,3.8843514917484834E-2]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,null,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-3.2891912138167797E-3,8.558407146369506E-4,5.2617124884580298E-7]
[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.5748489953564399E-3,-4.1430304801509145E-3,3.2445865887303707E-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.0712478082662048E-2,6.2088627677464051E-2]
[]
[null,null,null,"TABLE 5 : OFGEM PCFM ADJUSTMENTS (VIA ANNUAL ITERATION PROCESS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-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.902530158706661,-19.801908858477702,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.5716733537869363,-1.8257614948941407,-3.7345807881634583,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.7942966052081033,-3.0812268147554027,-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,-13.968566762361663,-20.809518468356206,-26.661357784046988]
[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.6461696970981006,0.39634638830384161,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.50964864723115666,-0.66045500523311962,null,null,"13/14 - 17/18 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.3259340325920701,-2.8101222718282077]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.078508294680468]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.078508294680468]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]

{"sheet":"Mod186 Statement movement","index":2,"n_rows":211,"n_cols":32,"rows_kept":211,"cut":false,"hidden":false,"merged":[[46,3,46,4],[7,3,7,4],[1,3,1,4],[1,17,1,22],[3,31,5,39],[30,31,31,39],[15,31,15,39],[1,24,1,29],[1,31,1,39],[45,3,45,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],[95,3,95,4],[97,3,97,4],[98,3,98,4],[89,3,89,4],[114,3,114,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[110,3,110,4],[112,3,112,4],[113,3,113,4]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,"SEPTEMBER MOD186",null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,"SUPPORTING NOTES"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,"RIIO-GD2",null,"21/22 is illustrative only  - it assumes revenues are flat year on year ** THE FINAL OUTCOME COULD BE SIGNIFICANTLY DIFFERENT TO THIS ILLUSTRATION **"]
[]
[null,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.4013837345624929,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3569431064793467,1.3979906354503471,null,null,0,0,0,1.645099591901733E-3,3.3930991121458032E-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.7421255484442417E-2,3.3500000000000085E-2,3.1749999999999945E-2,3.1500000000000083E-2,null,null,2.1427497658355055E-2,3.7421255484442417E-2,3.3250000000000002E-2,3.0750000000000055E-2,3.025000000000011E-2,null,null,0,0,2.5000000000008349E-4,9.9999999999988987E-4,1.2499999999999734E-3,null,null,"Movement between August and November HM Treasury forecast"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,2.0000000000008206E-4,"","",null,null,-1.5725023416449449E-3,3.4212554844424148E-3,-5.0000000000001432E-5,"","",null,null,0,0,2.5000000000008349E-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.952189040023597,-27.078508294680468,null,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.42402427058491199,0,null,null,"Finalisation of Modt value to match the finalised published Ofgem number"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.83051422427869837,0.6971530585795408,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.83051422427869837,0.61674490637205759,null,null,0,0,0,0,8.0408152207483208E-2]
[null,8,null,"Uplift to Nominal Prices using RPIFt",null,null,null,55.502640236221339,69.644522873859785,78.082217075455048,76.602895594612164,84.616406495412889,98.926361079340722,112.63265058988338,126.28979358746921,null,null,76.602895594612164,84.616406495412889,98.926361079340722,112.26727691231099,125.1902005871213,null,null,0,0,0,0.36537367757239281,1.0995930003479089,null,null,"Movement between August and November HM Treasury forecast"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73291569314847,440.92584560667899,null,null,405.74788540780747,396.94748949190864,413.95451095107899,426.79156628616101,439.74584445412358,null,null,0,0,0,-5.865059301254405E-2,1.1800011525554055]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0742468262679523,5.227630491292639,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0681024763127578,5.2149730956477773,null,null,0,0,0,6.144349955194528E-3,1.265739564486168E-2]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32120995798630503,0.3309194503080653,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32082100836313249,0.3301182118853983,null,null,0,0,0,3.8894962317254089E-4,8.0123842266699441E-4]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2604755471979212,2.0190249116348156,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2577383620938689,2.0161215144046492,null,null,0,0,0,2.7371851040522976E-3,2.9033972301664157E-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.6559323314521786,7.5775748532355198,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.64666184676976,7.5612128219378256,null,null,0,0,0,9.2704846824185339E-3,1.6362031297694202E-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.166334221817201,2.0078431706682105,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1637110314138779,2.0101959972283217,null,null,0,0,0,2.6231904033231501E-3,-2.3528265601111542E-3]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0425888310073201,-8.8034580185673512,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.037693704429306,-8.7810799587353863,null,null,0,0,0,-4.895126578014164E-3,-2.2378059831964947E-2]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8762546091901191,-6.7956148478991407,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8739826730154281,-6.7708839615070646,null,null,0,0,0,-2.2719361746910138E-3,-2.4730886392076101E-2]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0013930029813272,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,0.90210120915269443,null,null,0,0,0,0,9.9291793828632735E-2,null,null,"Shrinkage prices c.11% than September which results in not returning as much money to customers"]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5132278281334512,-5.3091842253429053,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5053410318296541,-6.0757381174054599,null,null,0,0,0,-7.8867963037971833E-3,0.76655389206255453]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.7036862634216678,-4.307791222361578,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6957994671178707,-5.1736369082527656,null,null,0,0,0,-7.8867963037971833E-3,0.8658456858911876]
[]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072477837255715,3.1785616077964924,null,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072477837255715,3.1785616077964924,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,4.1435291149650562,4.6042170830009672,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.60310333914925,null,null,0,0,0,0,1.1137438517172527E-3]
[null,23,null,"Discretionary Reward Scheme Revenue Adjustment","DRSt",null,null,1.1110274999999998,0.83327062499999982,0,0.8,0,0,0.9,0,null,null,0.8,0,0,0.9,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.3643144000000005,2.6079134189917976,2.6884173688668356,2.7778328273220776,null,null,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.6887868676028144,2.7703988200609788,null,null,0,0,0,-3.6949873597880156E-4,7.434007261098774E-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.3531751492592994,0.29173682062174816,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.3531751492592994,0.89086741634440614,null,null,0,0,0,0,-0.59913059572265803,null,null,"Underlying capacity invoices higher than previously forecast for 18/19 - therefore returning money 2 years later"]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.2523627283951,448.2523627283951,null,411.31483044543194,409.0452105191099,409.53615848062174,436.1548346098316,446.80546758965266,446.80546758965266,null,0,0,0,-5.9908339544620048E-2,1.446895138742434,1.446895138742434]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,409.25787448087954,436.09492627028703,448.25236272839498,448.25219523406184,null,421.35891895000003,410.34560751000004,408.68637151395785,436.15566563712071,446.80546758965261,446.80485888366343,null,0,0,0.57150296692168467,-6.0739366833672648E-2,1.4468951387423772,1.447336350398416]
[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.3003969908901354,-0.27828399974220019,0,0,-1.6749433325458085E-4,null,10.044088504568094,1.3003969908901354,-0.84978696666388487,8.3102728910944279E-4,0,-6.0870598923656871E-4,null,0,0,0.57150296692168467,-8.3102728910944279E-4,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,1.2002290917640934E-3,6.4850849527422039E-2,2.7877958962019722E-2,null,null,null,null,1.2002290917640934E-3,6.4997132922194334E-2,2.4419385352792755E-2,null,null,null,null,0,-1.4628339477229524E-4,3.458573609226967E-3]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-3.1791033300202472E-3,6.7951020680233278E-4,0,null,null,null,null,-3.1791033300202472E-3,2.0749986272679626E-3,-1.9053492548187615E-6,null,null,null,null,0,-1.3954884204656298E-3,1.9053492548187615E-6]
[null,31,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]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.4234304192268163E-3,-4.0915223507130109E-3,9.4906586396109154E-3,null,null,null,null,-1.4210282698834849E-3,-3.425852830484747E-3,9.3166029759812197E-3,null,null,null,null,-2.4021493433314112E-6,-6.6566952022826392E-4,1.7405566362969568E-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.5094262359407283E-2,-1.4015481016426846E-2,8.1438837383511362E-2,5.7368617601630638E-2,1.9710974447135446E-2,null,4.262170956228286E-2,-3.5094262359407283E-2,-1.4013078867083516E-2,8.3646278718977549E-2,5.3734082979519156E-2,1.9708688202025846E-2,null,0,0,-2.4021493433296764E-6,-2.207441335466187E-3,3.6345346221114821E-3,2.2862451095999325E-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,1345753]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160912]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,19059743380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15841637342]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34901380722,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14173.317543880596,14162.883813002833,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,13645.855449853219,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13923.432417973681,"","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,0.34085252038066521,"","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,114,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,"","","",""]
[]
[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.5499999999999997E-2,3.5499999999999997E-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.21249999999999999,0.22489999999999999,0.22489999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1047,0.1134,0.12,0.12]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5115004355034047,4.3580343468257627,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,81.228559999999987,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,43.373680000000007,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.96027434682577,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543188,409.0452105191099,409.53615848062174,436.1548346098316,446.80546758965272,446.80546758965272]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,"","","","",null,13967.493608369672,13923.432417973681,"","","","",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,128.96027434682577,129.11505621977872,137.48827730241223,141.32116985480766,141.32116985480766,null,129.79446543550341,128.96027434682577,129.11505621977872,137.50716469115227,140.86500513451548,140.86500513451548,null,0,0,0,-1.8887388740040478E-2,0.45616472029217903,0.45616472029217903]
[null,36,null,"Total annual charges £ (excl.exit capacity) - (17/18 Prices)","17/18 prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},134.65153728703203,128.96027434682577,124.92990442165333,128.93793540564789,128.48517874700349,125.38197486899581,null,134.65153728703203,128.96027434682577,124.96013183622426,129.11198848911786,128.38128987109829,125.46424614815371,null,0,0,-3.0227414570930478E-2,-0.17405308346997117,0.10388887590519857,-8.2271279157893673E-2]
[null,37,null,"% movement in domestic customer bill - (17/18 prices)",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},-5.4430842079877584E-2,-4.2266602037185685E-2,-3.1252802039899219E-2,3.2082238456430545E-2,-3.5114309626566031E-3,-2.415223225176899E-2,null,-1.9046457043139786E-2,-4.2266602037185685E-2,-3.1018408815132625E-2,3.322545032470936E-2,-5.6594172746488036E-3,-2.2721720009772906E-2,null,-3.5384385036737798E-2,0,-2.3439322476659363E-4,-1.143211868278815E-3,2.1479863119922005E-3,-1.4305122419960847E-3]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,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.914818567244849,12.290135352113062,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.90039104382387,12.260377872899543,null,null,0,0,0,1.4427523420978972E-2,2.9757479213518678E-2,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0425888310073201,-8.8034580185673512,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.037693704429306,-8.7810799587353863,null,null,0,0,0,-4.895126578014164E-3,-2.2378059831964947E-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.0544737852273769E-2,-6.93430723425668E-2,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-5.467620830521018E-2,null,null,0,0,0,0,-1.4666864037356619E-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.8927744740898023,3.4173342612031434,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8832420772468375,3.4246217058589465,null,null,0,0,0,9.5323968429648076E-3,-7.2874446558031103E-3,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1565469251612894,7.892999781750822,3.4181289585900614,null,null,9.2451910000000019,7.6683149999999998,7.142556392258065,7.8841978402665882,3.4254659907204266,null,null,0,0,1.3990532903224384E-2,8.801941484233744E-3,-7.3370321303651842E-3,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,6.614546454841097E-2,2.2530766101969135E-4,7.94697386917953E-4,null,null,0.48074452245191246,-1.9743427372537425E-2,5.2154931645186586E-2,9.5576301975075495E-4,8.442848614800269E-4,null,null,0,0,1.3990532903224384E-2,-7.304553587310636E-4,-4.9587474562073908E-5,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.11316326979989766,-0.56703003836971644,null,null,null,null,-7.7738348687851122E-2,0.11181886117988982,-0.56558206987664017,null,null,null,null,0,1.344408620007842E-3,-1.4479684930762682E-3,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,-9.3288743826211371E-3,-2.8546065994831799E-5,null,null,null,null,2.5680641684827725E-3,-7.3557092549564086E-3,-1.2123984147453049E-4,null,null,null,null,0,-1.9731651276647284E-3,9.2693775479698687E-5,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,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,-2.9899297300658191E-3,-9.8345305904589571E-3,null,null,null,null,1.4424029232627585E-3,-1.1835960921499564E-3,-9.7429263388050837E-3,null,null,null,null,0,-1.8063336379158627E-3,-9.1604251653873425E-5,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.1208444656872107,-0.55689311502617023,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.12327955583278345,-0.55544623605691978,null,null,0,0,0,-2.4350901455727492E-3,-1.4468789692504425E-3,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.35715209173736,402.44575702000884,428.2021517961972,444.83502846719193,null,null,402.55038396788387,401.35715209173736,402.44575702000884,428.27159253258475,443.38084588379371,null,null,0,0,0,-6.9440736387548441E-2,1.4541825833982216,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,402.10132755571823,428.20192648853623,444.83423376980494,null,null,412.11372795000005,402.67729251000003,401.54381512169977,428.2714677968541,443.38000159893215,null,null,0,0,0.55751243401846295,-6.9541308317866424E-2,1.4542321708727854,0]
[null,52,null,"Under / Over Recovery Carried Forward (LDZ & Customer)",null,null,null,3.0412093007736303,-2.5957629654143375,-6.2707659421377002,9.5633439821161801,1.3201404182626675,-0.34442946429061294,-2.2530766096906518E-4,-7.9469738699344816E-4,null,null,9.5633439821161801,1.3201404182626675,-0.9019418983090759,-1.2473573065108212E-4,-8.4428486155729843E-4,null,null,0,0,0.55751243401846295,-1.0057193031798306E-4,4.9587474563850265E-5,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.7123097784556016E-3,6.3999667848176012E-2,3.8843514917484834E-2,null,null,null,null,2.7123097784556016E-3,6.4172214670142225E-2,3.5279606713721989E-2,null,null,null,null,0,-1.7254682196621296E-4,3.5639082037628445E-3,0]
[null,54,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,-7.9106138885020796E-3,6.465502218883922E-3,null,null,-3.2891912138167797E-3,8.558407146369506E-4,5.2617124884580298E-7,null,null,null,null,-3.2891912138167797E-3,2.2411514659458395E-3,2.912538044222293E-7,null,null,null,null,0,-1.3853107513088889E-3,2.3491744442357368E-7,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.5748489953564399E-3,-4.1430304801509145E-3,3.2445865887303707E-3,null,null,null,null,-1.5748489953564399E-3,-3.4967099353250021E-3,3.1605824228147124E-3,null,null,null,null,0,-6.4632054482591239E-4,8.4004165915658319E-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.0712478082662048E-2,6.2088627677464051E-2,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.2916656200763064E-2,5.8440480390341124E-2,null,null,0,0,0,-2.2041781181010162E-3,3.648147287122927E-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,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-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.902530158706661,-19.801908858477702,null,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-19.801908858477702,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.5716733537869363,-1.8257614948941407,-3.7345807881634583,null,null,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.3810614948941407,-3.7345807881634583,null,null,0,0,0,-0.4447000000000001,0,null,null,"Finalised values from Ofgem PCFM Annual Iteration November 2018"]
[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.7942966052081033,-3.0812268147554027,-3.1248681374058265,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-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,-13.968566762361663,-20.809518468356206,-26.661357784046988,null,null,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.364818468356205,-26.661357784046988,null,null,0,0,0,-0.44470000000000098,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.6461696970981006,0.39634638830384161,null,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,0.39634638830384161,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.50964864723115666,-0.66045500523311962,null,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.66045500523311962,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.3259340325920701,-2.8101222718282077,null,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8101222718282077,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.151126161072128,-22.972864769438683,-27.078508294680468,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.078508294680468,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,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,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]

{"sheet":"High level mod186 rec","index":3,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":true,"merged":[[35,1,35,2]]}
[]
[null,"MOD186 Reconciliation - September 2018 to December 2018"]
[]
[null,"ALLOWED REVENUE",null,"16/17","17/18","18/19","19/20","20/21","21/22"]
[]
[null,"SEPTEMBER",null,411.31483044543194,409.0452105191099,409.53615848062174,436.1548346098316,446.80546758965266,446.80546758965266]
[]
[null,"Adjustments to Base Revenue via \"MOD\" (9/10 prices)"]
[]
[null,"Cost of debt %   September",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2]
[null,"Cost of debt %   December",null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2]
[null,"Cost of debt £ movement",null,0,0,0,0,0]
[]
[null,"Totex Incentive",null,0,0,0,0,0]
[]
[null,"Pension deficit valuation",null,0,0,0,0,0]
[]
[null,"Tax trigger - Corp. Tax rates long term impact",null,0,0,0,-0.4447000000000001,0]
[]
[null,"Repex Tier 2a",null,0,0,0,0,0]
[]
[null,"FGO Impact",null,0,0,0,0,0]
[]
[null,"Ofgem changes to Fuel Poor allowances",null,0,0,0,0,0]
[]
[null,"\"MOD\" Adjustment",null,0,0,0,-0.4447000000000001,0]
[]
[null,"Change in Inflation %"]
[null,"September (Based on HM Treasury Aug report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.3250000000000002E-2,3.0750000000000055E-2,3.025000000000011E-2]
[null,"December (Based on HM Treasury Nov report)",null,2.1427497658355055E-2,3.7421255484442417E-2,3.3500000000000085E-2,3.1749999999999945E-2,3.1500000000000083E-2]
[null,"Difference",null,0,0,2.5000000000008349E-4,9.9999999999988987E-4,1.2499999999999734E-3]
[null,"Cumulative change in inflation",null,0,0,2.5000000000008349E-4,1.2499999999999734E-3,2.4999999999999467E-3]
[]
[null,"£ impact on change in infl (incl. changes in \"Mod\" above)",null,0,0,0,0.38604940698745605,1.0995930003479222]
[]
[null,"£ Impact of changes in RPI on RPI true up (relating to 18/19)",null,0,0,0,0,8.0408152207483208E-2]
[]
[null,"Total base revenue changes",null,0,0,0,-5.865059301254405E-2,1.1800011525554055]
[]
[null,"Incentive changes:"]
[]
[null,"Customer",null,0,0,0,0,0]
[null,"Shrinkage/Leakage",null,0,0,0,0,0.10040553768034999]
[null,"DRS",null,0,0,0,0,0]
[null,"Exit",null,0,0,0,2.6231904033231501E-3,-2.3528265601111542E-3]
[null,"Total",null,0,0,0,2.6231904033231501E-3,9.8052711120238834E-2]
[]
[null,"Pass through changes:"]
[]
[null,"Rates",null,0,0,0,6.144349955194528E-3,1.265739564486168E-2]
[null,"License Fee",null,0,0,0,3.8894962317254089E-4,8.0123842266699441E-4]
[null,"Pension Deficit",null,0,0,0,2.7371851040522976E-3,2.9033972301664157E-3]
[null,"Exit Capacity",null,0,0,0,-4.895126578014164E-3,-2.2378059831964947E-2]
[null,"Shrinkage pass thru (gas price impact)",null,0,0,0,-7.8867963037971833E-3,0.76655389206255453]
[null,"Co-op Energy SOLR claim - finalised figure £88k less than December f'cast",null,0,0,0,0,0]
[null,"Total",null,0,0,0,-3.5114381993919808E-3,0.76053786352828467]
[]
[null,"Network Innovation",null,0,0,0,-3.6949873597880156E-4,7.434007261098774E-3]
[]
[null,"K factor",null,0,0,0,0,-0.59913059572265803]
[]
[null,"DECEMBER",null,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.25236272839504,448.2523627283951]
[null,"Difference",null,0,0,0,-5.9908339544620048E-2,1.4468951387423772,1.446895138742434]
[]
[null,"Total Price Change","September",4.262170956228286E-2,-3.5094262359407283E-2,-1.4013078867083516E-2,8.3646278718977549E-2,5.3734082979519156E-2,1.9708688202025846E-2]
[null,"Total Price Change","December",4.262170956228286E-2,-3.5094262359407283E-2,-1.4015481016426846E-2,8.1438837383511362E-2,5.7368617601630638E-2,1.9710974447135446E-2]
[null,"TOTAL PRICE CHANGE %","Difference",0,0,-2.4021493433296764E-6,-2.207441335466187E-3,3.6345346221114821E-3,2.2862451095999325E-6]