{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["_com.sap.ip.bi.xl.hiddensheet","BBPTACShadowWks0001","Mod186 Statement","Mod186 Statement movement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":63,"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":"_com.sap.ip.bi.xl.hiddensheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"BBPTACShadowWks0001","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Mod186 Statement","index":2,"n_rows":164,"n_cols":23,"rows_kept":164,"cut":false,"hidden":false,"merged":[[112,21,116,22],[1,3,1,22],[5,21,5,22],[151,3,151,4],[37,21,37,22],[38,21,38,22],[35,21,35,22],[30,21,30,22],[130,3,130,4],[36,21,36,22],[135,3,135,4],[136,3,136,4],[148,3,148,4],[150,3,150,4],[93,21,93,22],[108,3,108,4],[27,21,27,22],[31,21,31,22],[34,21,34,22],[6,21,8,22],[14,21,14,22],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,21,18,22],[20,21,20,22],[21,21,21,22],[22,21,22,22],[26,21,26,22],[3,3,3,4],[110,3,110,4],[116,3,116,4],[104,3,104,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[97,3,97,4],[98,3,98,4],[109,3,109,4],[7,3,7,4],[153,3,153,4],[118,3,118,4],[106,3,106,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[89,3,89,4]]}
[]
[null,"Row ref.",null,"MOD 186 Report"]
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,null,null,"Published:","2019-03-14T11:45:06.880",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","2022-23","2023-24","2024-25","2025-26",null,"Assumptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GD2 years are 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.3969730053228715]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,null,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,null,null,null,null,null,null,null,"Prices will be set with an assumed RPI rate of 3.2% for 19/20 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.2499999999999973E-2,2.8999999999999915E-2,3.2000000000000028E-2,null,null,null,null,null,null,"As per February 2019 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-8.0000000000002985E-4,-2.7500000000000857E-3,"",null,null,null,null,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,null,null,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,-26.043927506517004,null,null,null,null,null,null,"Latest forecast of Annual Iteration Process"]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82995339082606956,0.37398419665520927,null,null,null,null,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.63244948162168,125.18443048337076]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73215375143411,440.53189442881973]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,4.9975071753579714]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.32873290389897425]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0135973098346884]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.3398373890916337]
[]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.996508163426038,null,null,null,null,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.0398589330894108,-8.7410532556040295,null,null,null,null,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.8749876033764656,-6.7445450921779919]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0423472182784905,null,null,null,null,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.5088295457876146,-4.9453614936504291,null,null,null,null,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.6992879810758312,-3.9030142753719383]
[]
[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.1753398387528815,null,null,null,null,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.5997621075940964,null,null,null,null,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,null,null,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.688412568634035,2.7753509349015641,null,null,null,null,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.78536432396881295]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.53615848062174,436.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.78626057598689,436.93761681366021,448.55998965557882,448.55990400439248,448.55982501194956,448.55975031596557,448.55964629992286,448.55957097734108]
[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.74989790463484951,0.10606593024209587,0,-8.5651186282120761E-5,-1.6464362920487474E-4,-2.3933961318789443E-4,-3.4335565590026818E-4,-4.1867823767915979E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,1.2002290917640934E-3,6.6649529809680752E-2,2.6848882019721021E-2,null,null,null,null,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,1.8310908307021512E-3,-2.428073934394057E-4,null,null,null,null,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.0613176358943875E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,null,"Latest view on how much load factors could move capacity levels"]
[null,32,null,"Year on Year movement in Aggregate Demand/Other underlying growth",null,null,null,null,null,null,null,null,-1.423147388011194E-3,-3.5512086853458358E-3,9.4054148633846354E-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.4015197985211223E-2,7.7929411955037067E-2,5.601148948966625E-2,1.9563482487996671E-2,1.9628499702411279E-2,1.6884353517559517E-2,2.2183085594379471E-2,1.9652585122980942E-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","2021-22","2021-22","2021-22","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.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876]
[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,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,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.3300000000000003E-2,3.5299999999999998E-2,3.5999999999999997E-2,3.6700000000000003E-2,3.73E-2,3.8100000000000002E-2,3.8800000000000001E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21129999999999999,0.22409999999999999,0.22850000000000001,0.23300000000000001,0.2369,0.2422,0.247]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1128,0.1197,0.122,0.1244,0.1265,0.1293,0.1318]
[]
[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,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.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876,448.55998965557876]
[]
[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.72051400817747,141.41815584047836,141.41815584047836,141.41815584047836,141.41815584047836,141.41815584047836,141.41815584047836]
[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,125.05090190777599,129.62632237337783,128.97930640448737,125.9563539106322,125.9563539106322,125.9563539106322,125.9563539106322,125.9563539106322]
[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.0314548095143667E-2,3.6588464343713101E-2,-4.9913933917432596E-3,-2.34375E-2,0,0,0,0]
[]
[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.251453256681582]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.7410532556040295,null,null,null,null,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.7547377231668912E-2]
[null,42,null,"MAXIMUM ALLOWED REVENUE (ECN)",null,null,null,10.861054760499998,10.701127740203553,6.5365408898483626,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4428526238458841]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1548984527777773,7.9025210429196511,3.4428526238458845]
[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.4496992164898792E-2,7.016670911939471E-3,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.11354828296636987,-0.5639477275128888]
[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.0963808640708212E-3,-8.8869191648047099E-4]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,0,0,null,null,1.4424029232627585E-3,3.7300043449729533E-3,-9.3893933778239173E-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.121181906447272,-0.55422581280719319]
[]
[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.93604651141038,445.11713703173285]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.6313621232091,429.03509577074055,445.11713703173291]
[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.81439489679974031,9.904925933017239E-2,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.5823254511500506E-2,3.7723783421620194E-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,2.0236140711982959E-3,-2.3091847872369831E-4]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,null,null,null,null,null,-1.5748489953564399E-3,-3.7143207538259601E-3,3.2386340062833252E-3]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,5.1999999999999998E-2,5.070194586005243E-2,6.8094260422890796E-2,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,6.073149894917982E-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","2021-22","2021-22","2021-22","2021-22",null,"Assumptions","Frequency"]
[]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,null,null,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,null,null,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,-2.4,null,null,null,null,null,null,"Impact of changes in CT rate and also in 20/21 special rate tax pool allowance change from 8% to 6%","At any time"]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,null,null,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,null,null,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,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,-25.326776995883527]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,null,-14.073390704007844,null,null,null,null,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,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,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,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,9.6346388303841624E-2,null,null,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,-26.043927506517001]
[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,-26.043927506517001]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,0,0,0]
[null,null,null,"Check that it adds down and matches the summary sheet",null,null,null,0,0,0,0,0,0,0,0,-448.55998965557876,-448.55998965557876]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":213,"n_cols":57,"rows_kept":213,"cut":false,"hidden":false,"merged":[[97,3,97,4],[98,3,98,4],[89,3,89,4],[114,3,114,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[106,3,106,4],[110,3,110,4],[112,3,112,4],[113,3,113,4],[148,3,148,4],[150,3,150,4],[151,3,151,4],[153,3,153,4],[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],[1,44,1,49],[1,51,1,56],[1,34,1,42],[45,3,45,4],[46,3,46,4],[7,3,7,4],[1,3,1,4],[3,34,5,42],[30,34,31,42],[15,34,15,42],[1,10,1,16],[1,18,1,24],[1,26,1,32]]}
[]
[null,null,null,"NORTHERN GAS NETWORKS",null,null,null,null,null,null,"CURRENT MOD186 STATEMENT",null,null,null,null,null,null,null,"DECEMBER MOD186",null,null,null,null,null,null,null,"VARIANCE",null,null,null,null,null,null,null,"SUPPORTING NOTES",null,null,null,null,null,null,null,null,null,"BUDGET SUBMISSION",null,null,null,null,null,null,"DIFFERENCE TO BUDGET"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,"RIIO-GD2",null,null,null,null,null,null,null,"RIIO-GD2",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,null,null,"Description","RIIO License Terms","2012-13",null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[]
[null,"ROW REF",null,"TABLE 1 : TOTAL CHARGE ELEMENTS (ECN + LDZ + CUSTOMER)"]
[]
[null,1,null,"Forecast RPI Factor","RPIFt",null,null,1.163,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3969730053228715,null,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.4013837345624929,null,null,null,0,0,0,0,-4.4107292396213804E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.355627679781122,1.392907440975103,null,null,0,0,0,2.9605262901264418E-3,4.0655643477685022E-3,0]
[null,2,null,"Assumed Annual Inflation for Price Setting","GRPIFt",null,null,0,1.9600131885767702E-2,1.0776609381026869E-2,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,3.175E-2,0,null,null,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.3E-2,3.4000000000000002E-2,3.3300000000000003E-2,null,null,null,null,0,0,0,3.175E-2,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.2499999999999973E-2,2.8999999999999915E-2,3.2000000000000028E-2,null,null,null,2.1427497658355055E-2,3.7421255484442417E-2,3.3500000000000085E-2,3.1749999999999945E-2,3.1500000000000083E-2,null,null,null,0,0,-1.0000000000001119E-3,-2.7500000000000302E-3,4.9999999999994493E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,2.1427497658355055E-2,3.7421255484442417E-2,3.2999999999999918E-2,3.0000000000000027E-2,2.750000000000008E-2,null,null,0,0,-4.9999999999994493E-4,-1.0000000000001119E-3,4.4999999999999485E-3,0]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-8.0000000000002985E-4,-2.7500000000000857E-3,"",null,null,null,-1.5725023416449449E-3,3.4212554844424148E-3,2.0000000000008206E-4,"","",null,null,null,0,0,-1.0000000000001119E-3,"","",0,0,null,null,null,null,null,null,null,null,null,null,null,-1.5725023416449449E-3,3.4212554844424148E-3,-3.0000000000008492E-4,"","",null,null,0,0,-4.9999999999994493E-4,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,5,null,"Opening Base Revenue Allowance (09/10 Prices)","PUt",null,null,340.50699531424129,338.63562073675809,348.8527866377201,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,340.17667651580683,330.80925201676388,333.54750774134828,336.22193991900997,341.01740725531073,null,null,0,0,0,0,0,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,-26.043927506517004,null,null,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.952189040023597,-27.078508294680468,null,null,null,0,0,0,0,1.0345807881634634,0,0,null,"Additional income for changes to special rate tax pool within the tax allowance calculation less the estimated impact of the GSOP removal from historic totex data",null,null,null,null,null,null,null,null,null,-6.2324478434481421,-11.079016524139888,-17.213056451050647,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.42402427058491199,1.0345807881634634,0]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82995339082606956,0.37398419665520927,null,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.83051422427869837,0.6971530585795408,null,null,null,0,0,0,-5.6083345262880613E-4,-0.32316886192433153,0,0,null,"Impact of changes in inflation since prices were set for 18/19",null,null,null,null,null,null,null,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82997742654546791,0.53449576789326958,null,null,0,0,0,-2.4035719398352029E-5,-0.16051157123806031,0]
[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.63244948162168,125.18443048337076,null,null,null,76.602895594612164,84.616406495412889,98.926361079340722,112.63265058988338,126.28979358746921,null,null,null,0,0,0,-2.0110826170594009E-4,-1.1053631040984442,0,0,null,"Impact of changes in inflation",null,null,null,null,null,null,null,null,null,76.602895594612164,84.616406495412889,98.926361079340722,111.85335236469609,123.55893677753761,null,null,0,0,0,0.77909711692558403,1.6254937058331507,0]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73215375143411,440.53189442881973,null,null,null,405.74788540780747,396.94748949190864,413.95451095107899,426.73291569314847,440.92584560667899,null,null,null,0,0,0,-7.6194171435872704E-4,-0.39395117785926459,0,0,null,null,null,null,null,null,null,null,null,null,null,405.74788540780747,396.94748949190864,413.95451095107899,426.37710494081284,438.0323315060611,null,null,0,0,0,0.35504881062126969,2.4995629227586278,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,4.9975071753579714,null,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0742468262679523,5.227630491292639,null,null,null,0,0,0,-3.4265606582941643E-3,-0.23012331593466762,0,0,null,"Actual invoice value known for 18/19 and 19/20",null,null,null,null,null,null,null,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0599168739905309,5.1785514559792123,null,null,0,0,0,1.0903391619127234E-2,-0.18104428062124089,0]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.32873290389897425,null,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32120995798630503,0.3309194503080653,null,null,null,0,0,0,-2.1690813292535305E-4,-2.1865464090910502E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32030284338849946,0.32781264935596643,null,null,0,0,0,6.9020646488021642E-4,9.2025454300781462E-4,0]
[null,12,null,"NTS Pensions Deficit Adjustment","PDt",null,null,0,0,-4.5141972492543113E-2,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0135973098346884,null,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2604755471979212,2.0190249116348156,null,null,null,0,0,0,-1.5264642900234549E-3,-5.4276018001271353E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2540918398567773,2.0040130730026235,null,null,0,0,0,4.8572430511204523E-3,9.5842368320648852E-3,0]
[null,13,null,"Theft of Gas, 3rd party Damage & Water Ingress, Misc","TPWIt + TGt + MPt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,-1.8331E-2,-0.15071466,0,0.78779600000000005,0.736896,0,null,null,null,-0.15071466,0,0.78779600000000005,0,0,null,null,null,0,0,0,0.736896,0,0,0,null,"Iresa/Octopus Energy Supplier of Last Resort Claim",null,null,null,null,null,null,null,null,null,-0.15071466,0,0.78779600000000005,0,0,null,null,0,0,0,0.736896,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.3398373890916337,null,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.6559323314521786,7.5775748532355198,null,null,null,0,0,0,0.73172606691875774,-0.23773746414388608,0,0,null,null,null,null,null,null,null,null,null,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,7.634311557235808,7.5103771783378015,null,null,0,0,0,0.75334684113512829,-0.17053978924616775,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,15,null,"NTS Exit Capacity Incentive Revenue Adjustment","Eit",null,null,0,0,2.1652342029610257E-2,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.996508163426038,null,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.166334221817201,2.0078431706682105,null,null,null,0,0,0,-1.4628921042558751E-3,-1.1335007242172512E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1602163747596084,1.9966397822162956,null,null,0,0,0,4.6549549533367873E-3,-1.3161879025758161E-4,0]
[null,16,null,"NTS Exit Capacity Cost Adjustment",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.7410532556040295,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0425888310073201,-8.8034580185673512,null,null,null,0,0,0,2.7298979179093408E-3,6.2404762963321758E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0311723376815163,-8.7186966619122224,null,null,0,0,0,-8.6865954078945151E-3,-2.2356593691807092E-2,0]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,null,0,0,-4.187268023082968,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.7445450921779919,null,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8762546091901191,-6.7956148478991407,null,null,null,0,0,0,1.2670058136534657E-3,5.1069755721148802E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8709559629219079,-6.722056879695927,null,null,0,0,0,-4.0316404545577278E-3,-2.2488212482064895E-2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0423472182784905,null,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0013930029813272,null,null,null,0,0,0,0,4.0954215297163366E-2,0,0,null,"Latest gas price forecast included",null,null,null,null,null,null,null,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,0.79417604948705034,null,null,0,0,0,0,0.24817116879144019,0]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-4.9453614936504291,null,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5132278281334512,-5.3091842253429053,null,null,null,0,0,0,4.3982823458366127E-3,0.36382273169247625,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.4948341143184356,-6.8751215441655633,null,null,0,0,0,-1.3995431469179032E-2,1.9297600505151342,0]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6992879810758312,-3.9030142753719383,null,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.7036862634216678,-4.307791222361578,null,null,null,0,0,0,4.3982823458366127E-3,0.40477694698963962,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6852925496066522,-6.0809454946785131,null,null,0,0,0,-1.3995431469179032E-2,2.1779312193065747,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,21,null,"Broad Measure of Customer Satisfaction Revenue Adjustment","BMt",null,null,0,0,2.9408253536039455,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072477837255715,3.1753398387528815,null,null,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9072477837255715,3.1785616077964924,null,null,null,0,0,0,0,-3.2217690436109336E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,2.7280489896020739,3.366405616377834,3.4113564233688738,2.9087827865017268,3.178825350749273,null,null,0,0,0,-1.5350027761553697E-3,-3.485511996391466E-3,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.5997621075940964,null,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.6042170830009672,null,null,null,0,0,0,0,-4.454975406870787E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.6019895952975309,null,null,0,0,0,0,-2.2274877034345053E-3,0]
[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,null,0.8,0,0,0.9,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.8,0,0,0.9,0,null,null,0,0,0,0,0,0]
[null,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.688412568634035,2.7753509349015641,null,null,null,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.6884173688668356,2.7778328273220776,null,null,null,0,0,0,-4.8002328005836148E-6,-2.4818924205134429E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.6861757611271213,2.7596036884881849,null,null,0,0,0,2.236807506913685E-3,1.5747246413379212E-2,0]
[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.78536432396881295,null,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.3531751492592994,0.29173682062174816,null,null,null,0,0,0,0,0.49362750334706479,0,0,null,"Under collection in 18/19 impact 2 years later (Feb commodity is £0.2m below)",null,null,null,null,null,null,null,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.3538791247462367,1.2567984757658177,null,null,0,0,0,7.0397548693734713E-4,-0.47143415179700476,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.53615848062174,436.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876,null,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.2523627283951,448.2523627283951,null,null,0,0,0,0.73662461313114136,0.30762692718366225,0.30762692718366225,448.55998965557876,null,null,null,null,null,null,null,null,null,null,null,411.31483044543194,409.0452105191099,409.53615848062174,435.73977652336777,444.53692342032531,444.53692342032531,null,0,0,0,1.0917743600503513,4.0230662352534523,4.0230662352534523]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.78626057598689,436.93761681366021,448.55998965557882,448.55990400439248,448.55982501194956,null,421.35891895000003,410.34560751000004,409.25787448087954,436.09492627028703,448.25236272839498,448.25219523406184,null,null,0,0,-0.47161390489264932,0.84269054337318039,0.30762692718383278,0.30770877033063471,448.55982501194956,null,null,null,null,null,null,null,null,null,null,null,421.35891895000003,410.34560751000004,408.33741256066969,435.73977652336788,444.53692342032497,415.27013215808086,null,0,0,0.44884801531719631,1.1978402902923335,4.0230662352538502,33.289771846311623]
[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.74989790463484951,0.10606593024209587,0,-8.5651186282120761E-5,-1.6464362920487474E-4,null,10.044088504568094,1.3003969908901354,-0.27828399974220019,0,0,-1.6749433325458085E-4,null,null,0,0,-0.47161390489264932,0.10606593024209587,0,8.184314697246009E-5,-1.6464362920487474E-4,null,null,null,null,null,null,null,null,null,null,null,10.044088504568094,1.3003969908901354,-1.1987459199520458,0,0,-29.266791262244453,null,0,0,0.44884801531719631,0.10606593024209587,0,29.266705611058171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,1.2002290917640934E-3,6.6649529809680752E-2,2.6848882019721021E-2,null,null,null,null,null,1.2002290917640934E-3,6.4850849527422039E-2,2.7877958962019722E-2,null,null,null,null,null,0,1.7986802822587133E-3,-1.0290769422987012E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2002290917640934E-3,6.3983649551144328E-2,2.0188992079509527E-2,null,null,0,0,0,2.6658802585364239E-3,6.6598899402114942E-3,0]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-3.1791033300202472E-3,1.8310908307021512E-3,-2.428073934394057E-4,null,null,null,null,null,-3.1791033300202472E-3,6.7951020680233278E-4,0,null,null,null,null,null,0,1.1515806238998184E-3,-2.428073934394057E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.1791033300202472E-3,2.9270820051625979E-3,0,null,null,0,0,0,-1.0959911744604467E-3,-2.428073934394057E-4,0]
[null,31,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943875E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,null,0,-7.000000000000001E-3,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943875E-2,0.02,2.0000000000000004E-2,null,null,0,0,0,-7.000000000000001E-3,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.423147388011194E-3,-3.5512086853458358E-3,9.4054148633846354E-3,null,null,null,null,null,-1.4234304192268163E-3,-4.0915223507130109E-3,9.4906586396109154E-3,null,null,null,null,null,2.8303121562232858E-7,5.4031366536717515E-4,-8.5243776226279905E-5,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.4181976965677041E-3,-2.7564947634653204E-3,9.0533147140567163E-3,null,null,0,0,-4.9496914434898898E-6,-7.9471392188051534E-4,3.5210014932791911E-4,0]
[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.4015197985211223E-2,7.7929411955037067E-2,5.601148948966625E-2,1.9563482487996671E-2,1.9628499702411279E-2,null,4.262170956228286E-2,-3.5094262359407283E-2,-1.4015481016426846E-2,8.1438837383511362E-2,5.7368617601630638E-2,1.9710974447135446E-2,null,null,0,0,2.8303121562232858E-7,-3.5094254284742943E-3,-1.3571281119643883E-3,-1.4749195913877494E-4,1.9628499702411279E-2,null,null,null,null,null,null,null,null,null,null,null,4.262170956228286E-2,-3.5094262359407283E-2,-1.4010248293767732E-2,8.4154236792841605E-2,4.9242306793566247E-2,0.2206329023078436,null,0,0,-4.9496914434916245E-6,-6.2248248378045379E-3,6.7691826961000026E-3,-0.20106941981984694]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 2 : DOMESTIC CUSTOMER BILL IMPACT",null,null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543194,409.0452105191099,409.53615848062174,436.09492627028698,448.2523627283951,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340114,1345753,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340114,1345432,null,null,null,null,null,-1340114,-1345432,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160912,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1156041,1160436,null,null,null,null,null,-1156041,-1160436,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2505868,0,0,0,0,null,-2496155,-2505868,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bopri 26/04/2018",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,19059743380,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18993861267,18993564750,null,null,null,null,null,-18993861267,-18993564750,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15841637342,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15871167741,15823425361,null,null,null,null,null,-15871167741,-15823425361,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34901380722,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34865029008,34816990111,0,0,0,0,null,-34865029008,-34816990111,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,null,14173.317543880596,14117.075221936151,"","","","",null,-14173.317543880596,-14117.075221936151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,13645.855449853219,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13728.896934451286,13635.758767394324,"","","","",null,-13728.896934451286,-13635.758767394324,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13923.432417973681,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13894.183616615081,"","","","",null,-13967.493608369672,-13894.183616615081,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35599999999999998,0.33900000000000002,null,null,null,null,null,-0.35599999999999998,-0.33900000000000002,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34499999999999997,0.34300000000000003,null,null,null,null,null,-0.34499999999999997,-0.34300000000000003,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,0.34085252038066521,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35090558438878994,0.34085234976463247,"","","","",null,-0.35090558438878994,-0.34085234976463247,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,null,109,114,"","","","",null,-109,-114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,109,"","","","",null,-109,-109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,112,"","","","",null,-109,-112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3399999999999999E-2,3.5499999999999997E-2,3.5499999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3500000000000002E-2,3.5299999999999998E-2,3.5299999999999998E-2,null,-3.2300000000000002E-2,-3.1300000000000001E-2,-3.09E-2,-3.3500000000000002E-2,-3.5299999999999998E-2,-3.5299999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21199999999999999,0.22520000000000001,0.22520000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21260000000000001,0.22409999999999999,0.22409999999999999,null,-0.20530000000000001,-0.19869999999999999,-0.19620000000000001,-0.21260000000000001,-0.22409999999999999,-0.22409999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1047,0.1132,0.1202,0.1202,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1096,0.1061,0.1047,0.1134,0.1195,0.1195,null,-0.1096,-0.1061,-0.1047,-0.1134,-0.1195,-0.1195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,null,4.5115004355034047,4.3488794720005206,"","","","",null,-4.5115004355034047,-4.3488794720005206,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,81.228559999999987,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81.678605000000005,81.228559999999987,"","","","",null,-81.678605000000005,-81.228559999999987,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,43.373680000000007,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43.604360000000007,43.373680000000007,"","","","",null,-43.604360000000007,-43.373680000000007,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,129.79446543550341,128.95111947200053,0,0,0,0,null,-129.79446543550341,-128.95111947200053,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543188,409.0452105191099,409.53615848062174,436.09492627028703,448.2523627283951,448.2523627283951,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,411.31483044543188,409.0452105191099,409.53615848062174,435.73977652336777,444.53692342032531,415.27013215808108,null,-411.31483044543188,-409.0452105191099,-409.53615848062174,-435.73977652336777,-444.53692342032531,-415.27013215808108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,"","","","","",null,13967.493608369672,13923.432417973681,"","","","",null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,13967.493608369672,13894.183616615081,"","","","",null,0,29.248801358600758]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,128.96027434682577,129.11505621977872,137.72051400817747,141.41815584047836,141.41815584047836,141.41815584047836,null,129.79446543550341,128.96027434682577,129.11505621977872,137.48827730241223,141.32116985480766,141.32116985480766,null,null,0,0,0,0.23223670576524569,9.6985985670698938E-2,9.6985985670698938E-2,141.41815584047836,null,null,null,null,null,null,null,null,null,null,null,129.79446543550341,128.95111947200053,129.10589035700636,137.36655640059752,140.13984871975867,130.9135201879314,null,0,9.1548748252421319E-3,9.165862772363198E-3,0.35395760757995731,1.2783071207196883,10.504635652546966]
[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,125.05090190777599,129.62632237337783,128.97930640448737,125.9563539106322,125.9563539106322,null,134.65153728703203,128.96027434682577,124.92990442165333,128.93793540564789,128.48517874700349,125.38197486899581,null,null,0,0,0.12099748612266126,0.68838696772994012,0.49412765748388665,0.57437904163639075,125.9563539106322,null,null,null,null,null,null,null,null,null,null,null,134.65153728703203,128.95111947200053,124.98150082962863,129.10511978552196,128.18649345624914,117.39914996963806,null,0,9.1548748252421319E-3,6.940107814736507E-2,0.52120258785586771,0.792812948238236,8.5572039409941425]
[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.0314548095143667E-2,3.6588464343713101E-2,-4.9913933917432596E-3,-2.34375E-2,0,null,-5.4430842079877584E-2,-4.2266602037185685E-2,-3.1252802039899219E-2,3.2082238456430545E-2,-3.5114309626566031E-3,-2.415223225176899E-2,null,null,0,0,9.3825394475555157E-4,4.5062258872825556E-3,-1.4799624290866564E-3,7.1473225176899025E-4,0,null,null,null,null,null,null,null,null,null,null,null,-1.9046457043139786E-2,-4.2334591419332379E-2,-3.0783902137691999E-2,3.2993834515673948E-2,-7.1153361756598477E-3,-8.4153510996015091E-2,null,-3.5384385036737798E-2,6.79893821466937E-5,4.6935404254833113E-4,3.5946298280391531E-3,2.1239427839165881E-3,6.0716010996015091E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,null,8.77,8.77,8.77,8.77,8.77,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,8.77,8.77,8.77,8.77,8.77,null,null,0,0,0,0,0,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.251453256681582,null,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.290135352113062,null,null,null,0,0,0,0,-3.8682095431479269E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.888854751680439,12.215798257351652,null,null,0,0,0,2.5963815564409742E-2,3.5654999329929993E-2,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.7410532556040295,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0425888310073201,-8.8034580185673512,null,null,null,0,0,0,2.7298979179093408E-3,6.2404762963321758E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0311723376815163,-8.7186966619122224,null,null,0,0,0,-8.6865954078945151E-3,-2.2356593691807092E-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.7547377231668912E-2,null,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-6.93430723425668E-2,null,null,null,0,0,0,0,1.795695110897888E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0555426041338927E-2,-3.7397847399837619E-2,null,null,0,0,0,-1.0688189065157644E-5,-3.0149529831831293E-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.8955043720077116,3.4428526238458841,null,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8927744740898023,3.4173342612031434,null,null,null,0,0,0,2.7298979179093408E-3,2.5518362642740655E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8782378400402617,3.4597037480395922,null,null,0,0,0,1.7266531967449872E-2,-1.6851124193708156E-2,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1548984527777773,7.9025210429196511,3.4428526238458845,null,null,null,9.2451910000000019,7.6683149999999998,7.1565469251612894,7.892999781750822,3.4181289585900614,null,null,null,0,0,-1.6484723835121784E-3,9.5212611688291204E-3,2.4723665255823146E-2,0,0,null,null,null,null,null,null,null,null,null,null,null,9.2451910000000019,7.6683149999999998,7.1260718706666673,7.8782378400402591,3.4597037480395927,null,null,0,0,2.882658211111E-2,2.4283202879392007E-2,-1.6851124193708156E-2,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.4496992164898792E-2,7.016670911939471E-3,0,null,null,null,0.48074452245191246,-1.9743427372537425E-2,6.614546454841097E-2,2.2530766101969135E-4,7.94697386917953E-4,null,null,null,0,0,-1.6484723835121784E-3,6.7913632509197797E-3,-7.94697386917953E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,0.48074452245191246,-1.9743427372537425E-2,3.5670410053788792E-2,0,0,null,null,0,0,2.882658211111E-2,7.016670911939471E-3,0,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.11354828296636987,-0.5639477275128888,null,null,null,null,null,-7.7738348687851122E-2,0.11316326979989766,-0.56703003836971644,null,null,null,null,null,0,3.8501316647221451E-4,3.0823108568276414E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-7.7738348687851122E-2,0.11111308489424854,-0.56085309706492548,null,null,0,0,0,2.4351980721213362E-3,-3.0946304479633202E-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.0963808640708212E-3,-8.8869191648047099E-4,null,null,null,null,null,2.5680641684827725E-3,-9.3288743826211371E-3,-2.8546065994831799E-5,null,null,null,null,null,0,2.3249351855031582E-4,-8.6014585048563915E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5680641684827725E-3,-5.0308025930460533E-3,0,null,null,0,0,0,-4.065578271024768E-3,-8.8869191648047099E-4,0]
[null,47,null,"Impact of change in Annual Load Factors",null,null,null,0,1.4187096291995636E-2,1.6654039063360715E-2,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,null,0,-7.000000000000001E-3,0,0,0,null,"Assumption changed to reflect that set in 19/20 prices",null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,0,0,0,-7.000000000000001E-3,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,1.4424029232627585E-3,3.7300043449729533E-3,-9.3893933778239173E-3,null,null,null,null,null,1.4424029232627585E-3,-2.9899297300658191E-3,-9.8345305904589571E-3,null,null,null,null,null,0,6.7199340750387724E-3,4.4513721263503975E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4424029232627585E-3,-6.5488424296296366E-4,-9.8101221851799418E-3,null,null,0,0,0,4.3848885879359169E-3,4.2072880735602447E-4,0]
[null,49,null,"ECN ARITHMETICAL PRICE CHANGE",null,null,null,0,-1.6220809548505163E-3,-0.36552970917716293,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.55422581280719319,null,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.1208444656872107,-0.55689311502617023,null,null,null,0,0,0,3.3744076006129997E-4,2.6673022189770412E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.12542739805823952,-0.55066321925010542,null,null,0,0,0,-4.2454916109675167E-3,-3.5625935570877676E-3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[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.93604651141038,445.11713703173285,null,null,null,402.55038396788387,401.35715209173736,402.44575702000884,428.2021517961972,444.83502846719193,null,null,null,0,0,0,0.73389471521318228,0.28210856454091982,0,0,null,null,null,null,null,null,null,null,null,null,null,402.55038396788387,401.35715209173736,402.44575702000884,427.86153868332752,441.07721967228571,null,null,0,0,0,1.0745078280828579,4.0399173594471449,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.6313621232091,429.03509577074055,445.11713703173291,null,null,null,412.11372795000005,402.67729251000003,402.10132755571823,428.20192648853623,444.83423376980494,null,null,null,0,0,-0.46996543250912737,0.83316928220432374,0.28290326192797011,0,0,null,null,null,null,null,null,null,null,null,null,null,412.11372795000005,402.67729251000003,401.211340690003,427.86153868332764,441.07721967228537,null,null,0,0,0.4200214332061023,1.1735570874129166,4.0399173594475428,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.81439489679974031,9.904925933017239E-2,0,null,null,null,9.5633439821161801,1.3201404182626675,-0.34442946429061294,-2.2530766096906518E-4,-7.9469738699344816E-4,null,null,null,0,0,-0.46996543250912737,9.9274566991141455E-2,7.9469738699344816E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,9.5633439821161801,1.3201404182626675,-1.2344163300058426,0,0,null,null,0,0,0.4200214332061023,9.904925933017239E-2,0,0]
[]
[null,53,null,"Year on Year movement in Allowed Revenue",null,null,null,1.0912309472510096E-2,4.4303285284007732E-2,3.2881978809911505E-2,null,null,2.7123097784556016E-3,6.5823254511500506E-2,3.7723783421620194E-2,null,null,null,null,null,2.7123097784556016E-3,6.3999667848176012E-2,3.8843514917484834E-2,null,null,null,null,null,0,1.8235866633244946E-3,-1.1197314958646398E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7123097784556016E-3,6.3153310029940402E-2,3.088775174704228E-2,null,null,0,0,0,2.6699444815601048E-3,6.8360316745779137E-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,2.0236140711982959E-3,-2.3091847872369831E-4,null,null,null,null,null,-3.2891912138167797E-3,8.558407146369506E-4,5.2617124884580298E-7,null,null,null,null,null,0,1.1677733565613453E-3,-2.314446499725441E-4,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-3.2891912138167797E-3,3.0672862329232352E-3,0,null,null,0,0,0,-1.0436721617249393E-3,-2.3091847872369831E-4,0]
[null,55,null,"Impact of change in Annual Load Factors",null,null,null,0,0,0,null,null,-1.0613176358943877E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,null,null,null,0,-7.000000000000001E-3,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.0613176358943877E-2,0.02,0.02,null,null,0,0,0,-7.000000000000001E-3,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.5748489953564399E-3,-3.7143207538259601E-3,3.2386340062833252E-3,null,null,null,null,null,-1.5748489953564399E-3,-4.1430304801509145E-3,3.2445865887303707E-3,null,null,null,null,null,0,4.2870972632495438E-4,-5.9525824470454958E-6,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,-1.5748489953564399E-3,-2.8263244387354211E-3,3.0600698733042227E-3,null,null,0,0,0,-8.87996315090539E-4,1.7856413297910254E-4,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,7.7132547828872841E-2,6.073149894917982E-2,null,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.0712478082662048E-2,6.2088627677464051E-2,null,null,null,0,0,0,-3.5799302537892069E-3,-1.3571287282842306E-3,0,0,null,null,null,null,null,null,null,null,null,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,8.3394271824128216E-2,5.3947821620346503E-2,null,null,0,0,0,-6.2617239952553749E-3,6.7836773288333166E-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,null,null,"F'Cast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F'Cast","F'Cast"]
[null,null,null,"Item Description","PCFM Term",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23",null,null,null,null,null,null,null,null,null,null,null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,58,null,"Cost of Debt","CDE",null,null,2.92E-2,2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,2.3800000000000002E-2,2.2200000000000001E-2,1.9199999999999998E-2,1.5900000000000001E-2,1.1599999999999999E-2,null,null,0,0,0,0,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,null,0.2,0.19,0.19,0.19,0.17,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.2,0.19,0.19,0.19,0.17,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,60,null,"Cost of Debt Adjustment","CDE £ impact",null,null,0,-1.9826492792511772,-3.7582635528091961,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-19.801908858477702,null,null,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-19.801908858477702,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.5790833627772258,-7.3944719953437357,-9.6025968033666231,-15.902530158706661,-19.801908858477702,null,null,0,0,0,0,0,0]
[null,61,null,"Tax Trigger Event","TTE",null,null,0,0,-0.29268194863368535,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-2.4,null,null,null,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.8257614948941407,-3.7345807881634583,null,null,null,0,0,0,0,1.3345807881634584,0,0,null,"Special rate tax allowance forecasted impact (8% to 6%)",null,null,null,null,null,null,null,null,null,-0.20009415299585953,-1.5562531640979955,-1.5716733537869363,-1.3810614948941407,-3.7345807881634583,null,null,0,0,0,-0.4447000000000001,1.3345807881634584,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.3197033947918726,0.3197033947918726,-2.7942966052081033,-3.0812268147554027,-3.1248681374058265,null,null,0,0,0,0,0,0]
[null,64,null,"Pension Scheme Administration and PPF Levy","APFE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL INSTRUMENTS",null,null,null,0,-1.9826492792511772,-3.7312421066510089,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-25.326776995883527,null,null,null,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.809518468356206,-26.661357784046988,null,null,null,0,0,0,0,1.3345807881634606,0,0,null,null,null,null,null,null,null,null,null,null,null,-5.4594741209812128,-8.6310217646498586,-13.968566762361663,-20.364818468356205,-26.661357784046988,null,null,0,0,0,-0.44470000000000098,1.3345807881634606,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,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,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,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,1.2814092277495206,1.4514366936938927,1.6271177938279493,1.8087574286076915,1.9966253728908896,null,null,0,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,0,-2.0440324277822035,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,9.6346388303841624E-2,null,null,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,0.39634638830384161,null,null,null,0,0,0,0,-0.3,0,0,null,"GSOP removal estimated impact - prior year totex impact to be finalised in Nov 19 AIP process",null,null,null,null,null,null,null,null,null,-1.4565788939009403,-2.7806280473498055,-2.8060970525917752,-1.6461696970981006,0.39634638830384161,null,null,0,0,0,0,-0.3,0]
[null,72,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,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,73,null,"Specified Streetworks","IAESW",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,74,null,"Change to Connection Charging Boundary","IAECCB",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,75,null,"Smart Metering Roll-out","IAESM",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,76,null,"Large Load Connections","IAELLC",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,77,null,"Fuel Poor Network Extensions","IAEFP",null,null,0,0,0,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0.44039938762585962,0.44703528497313982,0.45423635614167779,0.4618927941485822,0.46990821173807262,null,null,0,0,0,0,0,0]
[null,78,null,"Agency Costs (FGO)","IAECA",null,null,0,0,0,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,-0.86042197470556037,-1.5664219619676487,-2.1006485042972827,-2.4217101462949699,null,null,0,0,0,0,0,0]
[null,79,null,"Mains & Services (Repex T2)","RE",null,null,0,0,-0.83958541144077603,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.66045500523311962,null,null,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.66045500523311962,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.72182350838623877,-0.63350022196940414,-0.78148473902560589,-0.50964864723115666,-0.66045500523311962,null,null,0,0,0,0,0,0]
[null,80,null,"Innovation Roll-out Mechanism","IRM",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,81,null,"NTS Exit Capacity Costs","AEx",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,82,null,"Shrinkage Costs","ALSC",null,null,0,0,0,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.30210416460148792,-0.13357740079374025,-0.1099097950950636,-0.17752967521221308,-0.1978653320381909,null,null,0,0,0,0,0,0]
[null,83,null,"UNCERTAIN COSTS TOTAL",null,null,null,0,0,-0.83958541144077603,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8101222718282077,null,null,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8101222718282077,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,-0.58352828536186707,-1.1804643124955649,-2.0035801399466404,-2.3259340325920701,-2.8101222718282077,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-26.043927506517001,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.078508294680468,null,null,null,0,0,0,0,1.034580788163467,0,0,null,null,null,null,null,null,null,null,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,1.034580788163467,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,-26.043927506517001,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-27.078508294680468,null,null,null,0,0,0,0,1.034580788163467,0,0,null,null,null,null,null,null,null,null,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.528164769438686,-27.078508294680468,null,null,0,0,0,-0.44469999999999743,1.034580788163467,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,87,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,88,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,89,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,90,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[]
[]
[null,null,null,"Check MOD breakdown = mod above",null,null,null,null,1.4854894755260029E-2,1.6481866963729885E-2,1.4275770953642741E-2,-6.1660906661447967E-2,6.1930289978519681E-2,-2.0675729415085442E-2,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,3.5527136788005009E-15,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]