{"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":2,"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-06-14T07:56:36.960",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.384889050445137]
[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.0555639758707454E-2,2.6250000000000107E-2,2.7749999999999941E-2,null,null,null,null,null,null,"As per May 2019 HM Treasury Report"]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.4999999999998939E-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.25144929809729283,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,121.13306345433404]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73215375143411,435.85509390503051]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0497384846213533]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34330567036952131]
[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.011475863957914]
[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.404520018948789]
[]
[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.9829724196615399,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.6572538534948507,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.6742814338333112]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,0.97592284107351002,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,-5.4046343300088786,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,-4.4287114889353685]
[]
[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.5911000305370413,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.5453169999999998,2.688412568634035,2.7458870916016922,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.60530980409241153]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.47356206162993,436.83155088341812,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,437.0318608601998,443.27425776619521,443.27425776619469,443.27425776619464,443.27425776619481,443.27425776619469,443.27425776619458]
[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.57797450162996711,0.20030997678168205,5.1159076974727213E-13,0,0,0,0,0]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,null,null,null,null,null,1.0471985284374874E-3,6.6812589032721359E-2,1.4748721491722128E-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.4115062733719938E-3,-4.5855198960924163E-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.0613176358943877E-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.2715563997322786E-3,-3.2946833510562844E-3,8.8926742817349615E-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.4016637560258914E-2,7.7929411955037067E-2,4.3182843783847846E-2,1.9681698172816696E-2,1.9765951932262774E-2,1.7024582390813694E-2,2.2324411003298128E-2,1.9733399185896474E-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.47356206162993,436.83155088341812,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469,443.27425776619469]
[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.49E-2,3.56E-2,3.6299999999999999E-2,3.6900000000000002E-2,3.7699999999999997E-2,3.8399999999999997E-2]
[null,null,null,null,"Capacity",null,null,0.1769,0.18590000000000001,0.19839999999999999,0.20530000000000001,0.19869999999999999,0.19620000000000001,0.21129999999999999,0.22140000000000001,0.2258,0.2303,0.23419999999999999,0.2394,0.24410000000000001]
[null,null,null,null,"Fixed",null,null,9.4399999999999998E-2,9.9199999999999997E-2,0.10589999999999999,0.1096,0.1061,0.1047,0.1128,0.1182,0.1205,0.1229,0.125,0.1278,0.1303]
[]
[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.47356206162993,436.83155088341812,443.27425776619464,443.27425776619464,443.27425776619464,443.27425776619464,443.27425776619464,443.27425776619464]
[]
[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.09532135634865,137.72051400817747,139.75171551298087,139.75171551298087,139.75171551298087,139.75171551298087,139.75171551298087,139.75171551298087]
[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.2676870378147,130.21889942114666,128.57159980702281,126.17428832877609,123.79130569416344,121.3640251903563,118.98433842191794,116.65131217835092]
[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,-2.8633525538882099E-2,3.952505630472225E-2,-1.2650234500878765E-2,-1.8645731108930086E-2,-1.8886436104979198E-2,-1.9607843137255054E-2,-1.9607843137254943E-2,-1.9607843137254943E-2]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77]
[null,39,null,"Inflated Base Revenue (Nominal)","AExt",null,null,10.315809999999999,10.701127740203553,10.757714378168743,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.14547697240385]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6572538534948507,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,-7.5161784964738076E-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.4130613339442615]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9025210429196511,3.4130613339442601]
[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,7.1767539387121104E-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.56772092406854435]
[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,-1.0121787854438031E-2,-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,4.7554113353401612E-3,-9.4735179137946483E-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.55808313389881947]
[]
[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.38316060101704,428.93604651141038,439.86119643225044]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,383.31,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.73341855999996,429.12933981728014,439.86119643225095]
[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.64974204101707755,0.19329330586975857,5.1159076974727213E-13]
[]
[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.5563478909804704E-3,6.598905846540104E-2,2.5470346942616739E-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,1.6147346724117244E-3,-4.5063432519098546E-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.4188871078813087E-3,-3.4712453089399235E-3,2.8285976283198982E-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,4.7848310245745651E-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,-443.27425776619464,-443.27425776619464]

{"sheet":"Mod186 Statement movement","index":3,"n_rows":213,"n_cols":35,"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,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,"MARCH 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,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,"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.384889050445137,null,null,null,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585882060712484,1.3969730053228715,null,null,null,0,0,0,0,-1.2083954877734504E-2,0,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,3.175E-2,null,null,null,null,0,0]
[null,3,null,"Actual/Forecast Annual Inflation",null,null,null,0,3.6183966230116438E-2,1.7896997945460624E-2,2.1427497658355055E-2,3.7421255484442417E-2,3.0555639758707454E-2,2.6250000000000107E-2,2.7749999999999941E-2,null,null,null,2.1427497658355055E-2,3.7421255484442417E-2,3.2499999999999973E-2,2.8999999999999915E-2,3.2000000000000028E-2,null,null,null,0,0,-1.9443602412925198E-3,-2.7499999999998082E-3,-4.250000000000087E-3,0,0]
[null,4,null,"Difference",null,null,null,0,1.6583834344348736E-2,7.120388564433755E-3,-1.5725023416449449E-3,3.4212554844424148E-3,-2.7443602412925497E-3,-5.4999999999998939E-3,"",null,null,null,-1.5725023416449449E-3,3.4212554844424148E-3,-8.0000000000002985E-4,-2.7500000000000857E-3,"",null,null,null,0,0,-1.9443602412925198E-3,-2.7499999999998082E-3,"",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,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,-26.043927506517004,null,null,null,0,0,0,0,0,0,0]
[null,7,null,"RPI True Up (09/10 Prices)","TRUt",null,null,0,0,1.1685286345961718,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82995339082606956,-0.25144929809729283,null,null,null,-4.799238859163383,-7.3991524961282567,-1.3063014185593671,0.82995339082606956,0.37398419665520927,null,null,null,0,0,0,0,-0.62543349475250209,0,0,null,"Impact of changes in inflation since prices were set for 18/19 (3.3% assumed vs. 3.1% latest projection)"]
[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,121.13306345433404,null,null,null,76.602895594612164,84.616406495412889,98.926361079340722,112.63244948162168,125.18443048337076,null,null,null,0,0,0,0,-4.0513670290367259,0,0,null,"Impact of cumulative changes in inflation"]
[null,9,null,"BASE REVENUE","BRt",null,null,396.00963555046263,409.2381436106179,422.58897884804986,405.74788540780747,396.94748949190864,413.95451095107899,426.73215375143411,435.85509390503051,null,null,null,405.74788540780747,396.94748949190864,413.95451095107899,426.73215375143411,440.53189442881973,null,null,null,0,0,0,0,-4.6768005237892112,0,0]
[]
[null,10,null,"Business Rate Adjustment","RBt",null,null,0,0,0.30315588674430971,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,5.0497384846213533,null,null,null,0.45240792338436564,0.96340416482706637,0.42583269129435336,5.0708202656096582,4.9975071753579714,null,null,null,0,0,0,0,5.2231309263381931E-2,0,0]
[null,11,null,"Licensee Fee Adjustment","LFt",null,null,0,0,0.15957132709115368,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.34330567036952131,null,null,null,0.21262510901874174,0.24439389996628133,-5.9937717969830974E-2,0.32099304985337967,0.32873290389897425,null,null,null,0,0,0,0,1.4572766470547061E-2,0,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.011475863957914,null,null,null,4.3580661027896449E-2,2.2977955273491282,2.2391013530779973,2.2589490829078978,2.0135973098346884,null,null,null,0,0,0,0,-2.1214458767744304E-3,0,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.736896,0,null,null,null,0,0,0,0,0,0,0]
[null,14,null,"PASS THROUGH","PTt",null,null,7.8759559999999992E-2,-1.8242749999999999E-2,0.39925424134292031,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.404520018948789,null,null,null,0.55789903343100389,3.5055935921424757,3.3927923264025197,8.3876583983709363,7.3398373890916337,null,null,null,0,0,0,0,6.4682629857155227E-2,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.9829724196615399,null,null,null,0.67553374772655639,3.3793563036027767,1.9310244335771027,2.1648713297129452,1.996508163426038,null,null,null,0,0,0,0,-1.3535743764498065E-2,0,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.6572538534948507,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.7410532556040295,null,null,null,0,0,0,0,8.37994021091788E-2,0,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.6742814338333112,null,null,null,-1.4488992886939647,-6.3882071719184363E-2,-2.0039239196519043,-1.8749876033764656,-6.7445450921779919,null,null,null,0,0,0,0,7.0263658344680735E-2,0,0]
[]
[null,18,null,"Shrinkage Incentive Revenue Adjustment","SHRRt",null,null,0,0,0.6769412160957371,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,0.97592284107351002,null,null,null,0.63104830905755127,0.55522982323705239,0.86180453738067153,0.80954156471178307,1.0423472182784905,null,null,null,0,0,0,0,-6.6424377204980511E-2,0,0,null,"18/19 now has actual gas prices included for the full year.  Final gas prices were 6% lower than previously forecast which results in more money being returned to customers in 20/21."]
[null,19,null,"Shrinkage Cost Adjustment","SHRAt",null,null,0,0,-2.7337105314985441,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-5.4046343300088786,null,null,null,-5.7074720867072717,-7.208780850335943,-7.3099456724964371,-6.5088295457876146,-4.9453614936504291,null,null,null,0,0,0,0,-0.45927283635844951,0,0]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,null,0,0,-2.0567693154028071,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6992879810758312,-4.4287114889353685,null,null,null,-5.0764237776497207,-6.6535510270988905,-6.4481411351157654,-5.6992879810758312,-3.9030142753719383,null,null,null,0,0,0,0,-0.52569721356343013,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.1753398387528815,null,null,null,0,0,0,0,0,0,0]
[null,22,null,"Environmental Emissions Incentive Revenue Adjustment","EEIt",null,null,0,0,2.0544320472078006,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.5911000305370413,null,null,null,2.819183646010214,3.0799122187215673,5.0396165912723072,4.1435291149650562,4.5997621075940964,null,null,null,0,0,0,0,-8.6620770570551286E-3,0,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,24,null,"Network Innovation Allowance Revenue Adjustment","NIAt",null,null,1.181812788,2.1268943999999999,2.6537751000000003,2.4086934000000002,2.3643144000000005,2.5453169999999998,2.688412568634035,2.7458870916016922,null,null,null,2.4086934000000002,2.3643144000000005,2.6079134189917976,2.688412568634035,2.7753509349015641,null,null,null,0,0,-6.2596418991797798E-2,0,-2.946384329987195E-2,0,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.60530980409241153,null,null,null,2.7784430349248272,6.4989282987774661,-10.417966175725102,-1.3531751492592994,0.78536432396881295,null,null,null,0,0,0,0,-0.18005451987640142,0,0]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",380.29677084437623,null,395.30774165972633,412.18006588561792,421.21690097198604,411.31483044543194,409.0452105191099,409.47356206162993,436.83155088341812,443.27425776619469,443.27425776619469,443.27425776619469,null,411.31483044543194,409.0452105191099,409.53615848062174,436.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876,null,0,0,-6.2596418991802238E-2,0,-5.285731889384067,-5.285731889384067,-5.285731889384067]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",383.31,null,398.36072827999999,409.50951318,414.96025073999999,421.35891895000003,410.34560751000004,408.89558755999997,437.0318608601998,443.27425776619521,443.27425776619469,443.27425776619464,null,421.35891895000003,410.34560751000004,408.78626057598689,436.93761681366021,448.55998965557882,448.55990400439248,448.55982501194956,null,0,0,0.10932698401308016,9.4244046539586179E-2,-5.2857318893836123,-5.2856462381977849,-5.285567245754919]
[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.57797450162996711,0.20030997678168205,5.1159076974727213E-13,0,0,null,10.044088504568094,1.3003969908901354,-0.74989790463484951,0.10606593024209587,0,-8.5651186282120761E-5,-1.6464362920487474E-4,null,0,0,0.1719234030048824,9.4244046539586179E-2,5.1159076974727213E-13,8.5651186282120761E-5,1.6464362920487474E-4]
[]
[null,29,null,"Year on Year movement in Allowed Revenue",null,null,null,0,0,0,null,null,1.0471985284374874E-3,6.6812589032721359E-2,1.4748721491722128E-2,null,null,null,null,null,1.2002290917640934E-3,6.6649529809680752E-2,2.6848882019721021E-2,null,null,null,null,null,-1.5303056332660603E-4,1.6305922304060694E-4,-1.2100160527998893E-2,0,0]
[null,30,null,"Adjustment for Prior Year Under/Over Recovery",null,null,null,0,0,0,null,null,-3.1791033300202472E-3,1.4115062733719938E-3,-4.5855198960924163E-4,null,null,null,null,null,-3.1791033300202472E-3,1.8310908307021512E-3,-2.428073934394057E-4,null,null,null,null,null,0,-4.1958455733015747E-4,-2.1574459616983594E-4,0,0]
[null,31,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.0613176358943875E-2,1.2999999999999999E-2,0.02,null,null,null,null,null,0,0,0,0,0]
[null,32,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.2715563997322786E-3,-3.2946833510562844E-3,8.8926742817349615E-3,null,null,null,null,null,-1.423147388011194E-3,-3.5512086853458358E-3,9.4054148633846354E-3,null,null,null,null,null,1.5159098827891536E-4,2.565253342895514E-4,-5.1274058164967398E-4,0,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.4016637560258914E-2,7.7929411955037067E-2,4.3182843783847846E-2,1.9681698172816696E-2,1.9765951932262774E-2,null,4.262170956228286E-2,-3.5094262359407283E-2,-1.4015197985211223E-2,7.7929411955037067E-2,5.601148948966625E-2,1.9563482487996671E-2,1.9628499702411279E-2,null,0,0,-1.4395750476906694E-6,0,-1.2828645705818403E-2,1.1821568482002498E-4,1.3745222985149519E-4]
[]
[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","2021-22",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,null,null,null,null,null,null,null,411.31483044543194,409.0452105191099,409.53615848062174,436.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876]
[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,1156041,1160912]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2496155,2506665,0,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,18993861267,19059743380]
[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,34865029008,34901380722,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,13728.896934451286,13645.855449853219,"","","","",""]
[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,0.35599999999999998,0.33900000000000002]
[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,0.35090558438878994,0.34085252038066521,"","","","",""]
[]
[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,109,109,"","","","",""]
[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,3.2300000000000002E-2,3.1300000000000001E-2,3.09E-2,3.3300000000000003E-2,3.5299999999999998E-2,3.5999999999999997E-2,3.6700000000000003E-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.21129999999999999,0.22409999999999999,0.22850000000000001,0.23300000000000001]
[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.1128,0.1197,0.122,0.1244]
[]
[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,81.678605000000005,81.228559999999987,"","","","",""]
[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,129.79446543550341,128.96027434682577,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.83155088341812,448.55998965557876,448.55998965557876,448.55998965557876]
[]
[null,34,null,"NGN average domestic AQ","Actual",null,null,0,0,0,13967.493608369672,13923.432417973681,"","","","","",null,13967.493608369672,13923.432417973681,"","","","","",null,0,0,0,0,0,0,0]
[null,35,null,"Total annual charges £ (excl.exit capacity) - (Nominal Prices)","Nom Prices",null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},129.79446543550341,128.96027434682577,129.09532135634865,137.72051400817747,139.75171551298087,139.75171551298087,139.75171551298087,null,129.79446543550341,128.96027434682577,129.11505621977872,137.72051400817747,141.41815584047836,141.41815584047836,141.41815584047836,null,0,0,-1.9734863430073801E-2,0,-1.6664403274974973,-1.6664403274974973,-1.6664403274974973]
[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.2676870378147,130.21889942114666,128.57159980702281,126.17428832877609,123.79130569416344,null,134.65153728703203,128.96027434682577,125.05090190777599,129.62632237337783,128.97930640448737,125.9563539106322,125.9563539106322,null,0,0,0.21678513003870137,0.59257704776882747,-0.40770659746456772,0.21793441814388359,-2.1650482164687617]
[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,-2.8633525538882099E-2,3.952505630472225E-2,-1.2650234500878765E-2,-1.8645731108930086E-2,-1.8886436104979198E-2,null,-5.4430842079877584E-2,-4.2266602037185685E-2,-3.0314548095143667E-2,3.6588464343713101E-2,-4.9913933917432596E-3,-2.34375E-2,0,null,0,0,1.6810225562615688E-3,2.9365919610091495E-3,-7.6588411091355058E-3,4.7917688910699141E-3,-1.8886436104979198E-2]
[]
[null,null,null,"TABLE 3 : ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"Initial Allowed Revenue (09/10 Prices)","AExt",null,null,8.8699999999999992,8.8800000000000008,8.77,8.77,8.77,8.77,8.77,8.77,null,null,null,8.77,8.77,8.77,8.77,8.77,null,null,null,0,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.14547697240385,null,null,null,10.811068268260835,11.145959119551021,11.523989403864542,11.914818567244849,12.251453256681582,null,null,null,0,0,0,0,-0.10597628427773209,0,0]
[null,40,null,"ECN Cost True Up",null,null,null,0,0,-4.2089203651125784,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.6572538534948507,null,null,null,-2.1244330364205211,-3.4432383753219611,-3.9349483532290073,-4.0398589330894108,-8.7410532556040295,null,null,null,0,0,0,0,8.37994021091788E-2,0,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,-7.5161784964738076E-2,null,null,null,7.78112457077762E-2,-1.466231685652297E-2,-0.49863959002265656,2.0544737852273769E-2,-6.7547377231668912E-2,null,null,null,0,0,0,0,-7.6144077330691645E-3,0,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.4130613339442615,null,null,null,8.7644464775480895,7.6880584273725372,7.0904014606128785,7.8955043720077116,3.4428526238458841,null,null,null,0,0,0,0,-2.9791289901622608E-2,0,0]
[]
[null,43,null,"COLLECTED REVENUE (ECN)",null,null,null,10.87283208,10.626338000000001,6.5506565999999991,9.2451910000000019,7.6683149999999998,7.1621689999999996,7.9025210429196511,3.4130613339442601,null,null,null,9.2451910000000019,7.6683149999999998,7.1548984527777773,7.9025210429196511,3.4428526238458845,null,null,null,0,0,7.2705472222223122E-3,0,-2.9791289901624385E-2,0,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,7.1767539387121104E-2,7.016670911939471E-3,0,null,null,null,0.48074452245191246,-1.9743427372537425E-2,6.4496992164898792E-2,7.016670911939471E-3,0,null,null,null,0,0,7.2705472222223122E-3,0,0,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.56772092406854435,null,null,null,null,null,-7.7738348687851122E-2,0.11354828296636987,-0.5639477275128888,null,null,null,null,null,0,0,-3.7731965556555558E-3,0,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,-1.0121787854438031E-2,-8.8869191648047099E-4,null,null,null,null,null,2.5680641684827725E-3,-9.0963808640708212E-3,-8.8869191648047099E-4,null,null,null,null,null,0,-1.0254069903672097E-3,0,0,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,1.2999999999999999E-2,0.02,null,null,null,null,null,0,0,0,0,0]
[null,48,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,1.4424029232627585E-3,4.7554113353401612E-3,-9.4735179137946483E-3,null,null,null,null,null,1.4424029232627585E-3,3.7300043449729533E-3,-9.3893933778239173E-3,null,null,null,null,null,0,1.0254069903672079E-3,-8.4124535970730996E-5,0,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.55808313389881947,null,null,null,0.38917876005399071,-0.17690890802795603,-8.4341057955049467E-2,0.121181906447272,-0.55422581280719319,null,null,null,0,0,0,0,-3.8573210916262868E-3,0,0]
[]
[null,null,null,"TABLE 4 : LDZ + CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN Allowed Revenued Less ECN Revenue",null,null,null,384.44668689922634,401.47893814541436,414.68036008213767,402.55038396788387,401.35715209173736,402.38316060101704,428.93604651141038,439.86119643225044,null,null,null,402.55038396788387,401.35715209173736,402.44575702000884,428.93604651141038,445.11713703173285,null,null,null,0,0,-6.2596418991802238E-2,0,-5.2559405994824147,0,0]
[null,51,null,"DN Collectable Revenue Less ECN Revenue",null,null,null,387.48789619999997,398.88317518000002,408.40959413999997,412.11372795000005,402.67729251000003,401.73341855999996,429.12933981728014,439.86119643225095,null,null,null,412.11372795000005,402.67729251000003,401.6313621232091,429.03509577074055,445.11713703173291,null,null,null,0,0,0.10205643679086052,9.4244046539586179E-2,-5.2559405994819599,0,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.64974204101707755,0.19329330586975857,5.1159076974727213E-13,null,null,null,9.5633439821161801,1.3201404182626675,-0.81439489679974031,9.904925933017239E-2,0,null,null,null,0,0,0.16465285578266275,9.4244046539586179E-2,5.1159076974727213E-13,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.5563478909804704E-3,6.598905846540104E-2,2.5470346942616739E-2,null,null,null,null,null,2.7123097784556016E-3,6.5823254511500506E-2,3.7723783421620194E-2,null,null,null,null,null,-1.5596188747513118E-4,1.6580395390053404E-4,-1.2253436479003454E-2,0,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,1.6147346724117244E-3,-4.5063432519098546E-4,null,null,null,null,null,-3.2891912138167797E-3,2.0236140711982959E-3,-2.3091847872369831E-4,null,null,null,null,null,0,-4.0887939878657149E-4,-2.1971584646728715E-4,0,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,1.2999999999999999E-2,0.02,null,null,null,null,null,0,0,0,0,0]
[null,56,null,"Year on Year movement in Aggregate Demand/Other",null,null,null,0,0,0,null,null,-1.4188871078813087E-3,-3.4712453089399235E-3,2.8285976283198982E-3,null,null,null,null,null,-1.5748489953564399E-3,-3.7143207538259601E-3,3.2386340062833252E-3,null,null,null,null,null,1.5596188747513118E-4,2.4307544488603658E-4,-4.1003637796342696E-4,0,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,4.7848310245745651E-2,null,null,null,3.4662491904579415E-2,-3.2384756950241796E-2,-1.2764906789661495E-2,7.7132547828872841E-2,6.073149894917982E-2,null,null,null,0,0,0,0,-1.2883188703434169E-2,0,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,"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","2021-22",null,"2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23"]
[]
[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,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,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,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,-2.4,null,null,null,0,0,0,0,0,0,0]
[null,62,null,"Tax Liability - gearing/interest costs","TGIE",null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,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,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,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,-25.326776995883527,null,null,null,0,0,0,0,0,0,0]
[null,66,null,"Legacy Capex RAV Adjustment","LRAV",null,null,0,-14.073390704007844,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,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,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,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,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,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,9.6346388303841624E-2,null,null,null,0,0,0,0,0,0,0]
[null,72,null,"Enhanced Physical Site Security (CNI)","IAEEPS",null,null,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,null,null,null,0,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,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,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,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,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,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,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,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,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,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,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,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,-26.043927506517001,null,null,null,0,0,0,0,0,0,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,0,0.97285489475525999,-5.4980716327577142,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-26.043927506517001,null,null,null,-6.2181720724944993,-11.140677430801336,-17.151126161072128,-22.972864769438683,-26.043927506517001,null,null,null,0,0,0,0,0,0,0]
[]
[null,null,null,"TABLE 6 : RISKS AND SENSITIVITIES"]
[]
[null,86,null,null,null,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,0,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,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,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,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,"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,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Old:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,28]
[null,29]
[null,30]
[null,31]