{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SC MOD0186 ","MOVEMENT"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SC MOD0186 ","index":0,"n_rows":132,"n_cols":23,"rows_kept":132,"cut":false,"hidden":false,"merged":[[127,3,127,4],[129,3,129,4],[130,3,130,4],[122,3,122,4],[126,3,126,4],[128,3,128,4],[106,3,106,4],[107,3,107,4],[119,3,119,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[121,3,121,4],[124,3,124,4],[81,3,81,4],[66,3,66,4],[68,3,68,4],[69,3,69,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[77,3,77,4],[79,3,79,4],[80,3,80,4],[89,3,89,4],[101,3,101,4],[2,6,3,22],[60,3,60,4],[9,3,9,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[53,3,53,4],[58,3,58,4]]}
[]
[]
[null,"                              SGN",null,"                           SGN",null,null,"MOD 186 REPORT UPDATE MARCH 2020"]
[null,null,null,"                           SCOTLAND DISTRIBUTION NETWORK    "]
[]
[]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM",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," ",null,"PLEASE NOTE THAT FORECAST REVENE ITEMS HAVE BEEN PROVIDED FOR THE FIRST YEAR OF GD2 ONLY WHERE THERE IS AN AGREED GD1 MECHANISM OPERATING ON A TWO YEAR LAGGED BASIS."]
[]
[null,"ROW REF",null,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTES (RIIO GD-1)",null,"NOTES (RIIO GD-2)"]
[]
[null,1,null,"FORECAST RPI FACTOR","RPIFt",null,1.1630161697108456,1.2050819527256253,1.2266493019576674,1.2327329838381795,1.2709189417960116,1.3140238772935624,1.3585865587485577,1.3798374174698094,1.4074361227024954,1.4355848451565454,1.4642965420596763,1.4935824729008698,1.5234541223588871,null,null,null,"CPIH"]
[null,2,null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING (RPIFT as a %)",null,null,2.6499999999999999E-2,3.6169559899789087E-2,1.7896997945460517E-2,4.9595934802252615E-3,3.0976666040798292E-2,3.391635302613133E-2,3.3913144369019474E-2,1.5641887949212875E-2]
[null,3,null,"ACTUAL / FORECAST ANNUAL INFLATION",null,null,2.8846428936344183E-2,1.9600131885767744E-2,1.0776609381026826E-2,2.1427497658355055E-2,3.7419997584832748E-2,3.055688933509881E-2,2.5249999999999939E-2,2.3750000000000011E-2,null,null,null,null,null,null,"HM TREASURY REVISED FORECAST IS LOWER THAN FEBRUARY RELEASE"]
[null,4,null,"DIFFERENCE FROM FORECAST TO ACTUAL (DRIVES t+2 RPI TRUE UP)",null,null,2.3464289363441838E-3,-1.6569428014021344E-2,-7.1203885644336908E-3,1.6467904178129794E-2,6.4433315440344564E-3,-3.3594636910325194E-3,-8.6631443690195348E-3,8.1081120507871356E-3]
[]
[null,5,null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)","PUt",null,256.5,249.4,243.3,256,259.5,261.60000000000002,257.10000000000002,261.7,224.26463053238447,229.38943045878742,229.39848287124533,224.85362381363325,222.31907192965727,null,"AS PER LICENSE VALUES",null,"DEC19 BP ALTERNATIVE COST OF CAPITAL SCENARIO"]
[null,6,null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)","MODt",null,null,-0.3,-9.5,6,-9.6999999999999993,-16.2,-22.44637093027174,-21.425990981182537,0.10084568694594509,0.10084568694594509,null,null,null,null,"20/21 REFLECTS NOVEMBER 19 AIP PROCESS",null,"MODt FORECAST ONLY REFLECTS GD1 LAGGED REVENUE ITEMS"]
[null,7,null,"RPI TRUE UP (2009/10 PRICES)","TRUt",null,null,null,0.87638095513275316,-3.5203558807257558,-5.0648403332399941,-1.027801969046259,0.64910168340563035,-0.19598704441109729,null,null,null,null,null,null,null,null," "]
[null,8,null,"UPLIFT TO NOMINAL PRICES USING RPIFt",null,null,41.813647530831929,51.085914423953241,53.189237929432501,60.156738837309462,66.303390477196572,76.738705128430368,84.376396484904717,91.190615858018688,91.373511523422422,99.918559546939065,106.50892235085507,110.98380768265497,116.37383468058104,null,null,null,"INFLATED USING CPIH"]
[null,9,null,"BASE REVENUE (NOMINAL)","BRt",null,298.31364753083193,300.18591442395325,287.86561888456527,318.6363829565837,311.03855014395657,321.11090315938412,319.67912723803863,331.26863783242504,315.73898774275284,329.40883569267243,335.90740522210041,335.83743149628822,338.69290661023831]
[]
[null,10,null,"BUSINESS RATES ADJUSTMENT","RBt",null,null,null,-2.4613113115656349,-2.3698811328589389,-2.1050457747246414,-1.7984570726702203,8.6986834220084734,8.7141675752413121,8.7020795852777937,8.6283059836518561,null,null,null,null,"REFLECTS REVISED RATES 2019/20 ONWARDS"]
[null,11,null,"LICENSE FEES ADJUSTMENT","LFt",null,null,null,0.13006380555966793,0.17103177905432396,0.19869709719342088,-1.4087824647235488E-2,0.2630911544536752,0.28210001365285192,0.40750480771756098,0.41843671983888564]
[null,12,null,"PENSION DEFICIT ADJUSTMENT","PDt",null,null,null,-7.3482405363103298E-2,-1.2878720734667944E-2,1.5864383987380104,1.5467535637125891,1.5578638511684921,1.3836091402887076,1.460685324840356,1.4639559285979915]
[null,13,null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH","TPWIt + TGt + MPt",null,8.0000000000000036E-3,3.0000000000000001E-3,7.6400000000000003E-4,0,2E-3,0.52324168000000004,0.48825099999999999,0.64692566234853,0,0,null,null,null,null,"20/21 REFLECTS CONFIRMED SOLR CLAIMS"]
[null,14,null,"PASS THROUGH","PTt",null,8.0000000000000036E-3,3.0000000000000001E-3,-2.4039659113690699,-2.2117280745392831,-0.31791027879320999,0.25745034639513326,11.007889427630641,11.026802391531401,10.570269717835711,10.510698632088733]
[]
[null,15,null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT","EIt",null,null,null,0.10062369901729006,-2.810133595747067E-2,-2.0318007988140777E-2,1.38515106205597E-2,5.7676159961033051E-3,-4.3189467602009375E-3,3.4981790426340219E-3,4.1075373805343441E-3,null,null,null,null,"REFLECTS OCTOBER 19 BOOKINGS AND OCTOBER 20 FORECAST"]
[null,16,null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,null,null,0.11486388723002124,0.35019572264500104,0.26348423524162368,6.1928992590020965E-2,2.198868631309895E-2,-0.12107727458903418,-9.4294504571654281E-2,-3.4041961682191486E-2,null,null,null,null,"REFLECTS OCTOBER 19 BOOKINGS AND OCTOBER 20 FORECAST"]
[null,17,null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT","EXt",null,0,0,0.21548758624731132,0.32209438668753032,0.24316622725348289,7.5780503210580649E-2,2.7756302309202282E-2,-0.12539622134923509,-9.0796325529020269E-2,-2.9934424301657124E-2]
[]
[null,18,null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT","SHRRt",null,null,null,0.10393421653650955,0.16959666181593275,7.9021928813446815E-2,0.19463149233760568,0.1854417178160522,0.1997049597469121,0.11020337349621374,3.7020173797373941E-2,null,null,null,null,"REVISED FORECASTS 19/20 ONWARDS "]
[null,19,null,"SHRINKAGE COST ADJUSTMENT","SHRAt",null,null,null,-0.85901986903448713,-2.5761821345075746,-3.2981825781053109,-3.4969742482287107,-2.9958481026081687,-2.3369738133071563,-4.433842666216032,-4.4836380691845905,null,null,null,null,"REFLECTS UPDATED GAS PRICE AND 2020/21 FINAL SHRINKAGE FINAL PROPOSALS"]
[null,20,null,"SHRINKAGE REVENUE ADJUSTMENT","SHRt",null,0,0,-0.75508565249797754,-2.406585472691642,-3.2191606492918643,-3.3023427558911052,-2.8104063847921164,-2.137268853560244,-4.3236392927198182,-4.4466178953872166]
[]
[null,21,null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT","BMt",null,null,null,2.0068130724252415,2.2361342025543238,1.988479992629455,2.5988049288849013,2.3095057783457218,2.5607127054336187,2.5505094473264784,2.6429745279098058,null,null,null,null,"FINAL 18/19 FINAL POSITION, ASSUMES SAME LEVEL FOR FUTURE YEARS"]
[null,22,null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT","EEIt",null,null,null,0.33185566726505739,0.77262279908221121,0.44756682818321097,1.22607651782739,0.93157531022416695,0.96269074306006341,0.80418019133584406,0.24696885396753082,null,null,null,null,"REFLECTS 2020/21 FINAL SHRINKAGE FPS"]
[null,23,null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT","DRSt",null,0.23028569999999993,0.31007767499999989,null,0.21520799999999998,null,null,0.138573,null,null,null,null,null,null,null,"AS PER OFGEM DECISION OCTOBER 2018"]
[null,24,null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT","NIAt",null,0.96929999999999994,0.91575000000000006,1.2953952849805437,1.2456,1.1358000000000001,1.1551696101992839,1.4385560725711739,1.4907088702459128,null,null,null,null,null,null,"REFLECTS ACTUALS FOR YEAR 2018/19 AND ASSUMED MAXIMUM SPEND ALL FUTURE YEARS"]
[null,25,null,"CORRECTION TERM REVENUE ADJUSTMENT","-Kt",null,-6.5473799999999827,0,-1.2392690986424761,1.746563279750962,-9.5084149999013512,-1.4833829318425533,-3.9802201451817303,6.2339943600104206,-0.96257995640800542,null,null,null,null,null,"LATEST FORECAST OF 19/20 ON TWO YEAR LAG + INTEREST RATE"]
[]
[null,26,null,"MAXIMUM ALLOWED REVENUE","ARt",null,292.97385323083193,301.41474209895324,287.3168498329739,320.55629207742783,301.80807726403634,321.63845937816774,328.74235659914575,351.28088182779692," "," "]
[]
[null,27,null,"COLLECTABLE REVENUE","Rt",null,294.16500000000002,299.73599999999999,296.47039999999998,321.98641659999998,305.63299999999998,315.67113433166662,329.66303971931649,351.28088182779692,null,null,null,null,null,null,"LATEST FORECAST OF 2019/20"]
[null,28,null,"UNDER / OVER RECOVERY CARRIED FORWARDS","ARt - Rt",null,1.1911467691680855,-1.6787420989532507,9.1535501670260828,1.4301245225721573,3.8249227359636393,-5.9673250465011165,0,0]
[]
[null,29,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,2.8811065475767172E-2,-4.6772404587135497E-2,0.11568915037101735,-5.8486497619154476E-2,6.5705273012898191E-2,2.2086591369428143E-2,6.8559845654856399E-2]
[null,30,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,31,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS"]
[null,32,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,null,null,0,0.01,null,null,null,null,null,null,"REFLECTS LATEST XOSERVE VIEW OF SOQ/AQ'S"]
[null,33,null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,4.3999999999999997E-2,-2.1999999999999999E-2,5.6000000000000001E-2,-7.1999999999999995E-2,5.0999999999999997E-2,3.1E-2,7.8559845654856394E-2]
[]
[null,null,null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT",null,null,"2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022/23","2023/24",null,null,null,"REFLECTS METHODOLOGY AS AGREED WITH OFGEM FOR THE 2014/15 ANNUAL REPORT"]
[]
[null,34,null,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",null,null,15148.061045721144,14919.632532814625,14378.46140922877,14097.177876269187,13888.158378344611,13669.282141635831,13890.09393183435,13890.09393183435]
[null,35,null,"TOTAL ANNUAL CHARGE (EXCL.ECN) (NOMINAL)",null,null,129.94,133.41,124.66,137.15,129.55000000000001,138.17562021942106,141.23934584507958,150.97957073673953]
[null,36,null,"TOTAL ANNUAL CHARGE (EXCL.ECN) (2018/19 PRICES)",null,null,146.23881659497124,147.25779824221141,136.13251181638816,146.63005653499334,133.50821187863127,138.17562021942106,137.64277367838929,143.98441642521274,null,null,null,null,null,null,"UPDATED TO REFLECT 2018/19 PRICE BASE"]
[null,37,null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (2018/19 PRICES)",null,null,null,6.9679287002326618E-3,-7.5549726796296679E-2,7.7112693937242405E-2,-8.9489460527013676E-2,3.4959709781993142E-2,-3.8562992529769247E-3,4.6073197868281124E-2]
[]
[null,null,null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,38,null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)","AEXt",null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,39,null,"INFLATED BASE REVENEUE (NOMINAL)","AEXt",null,0.23260323394216914,0.24101639054512508,0.24532986039153348,0.24654659676763591,0.25418378835920236,0.2628047754587125,0.27171731174971153,0.27596748349396188]
[null,40,null,"ECN COST TRUE UP",null,null,null,null,0.11486388723002124,0.35019572264500104,0.26348423524162368,6.1928992590020965E-2,2.198868631309895E-2,-0.12107727458903418,-9.4294504571654281E-2,-3.4041961682191486E-2]
[null,41,null,"CORRECTION FACTOR (ECN)",null,null,3.5391725399999997E-2,null,5.4990967884144093E-2,-9.1577517669300355E-3,-2.2511693265099865E-2,-6.0111219955260954E-2,-5.184995735827224E-2,-3.8707705430325096E-5,0,0]
[null,42,null,"TOTAL ALLOWED REVENUE (ECN)",null,null,0.26799495934216916,0.24101639054512508,0.4151847155056988,0.58758456764570688,0.49515633033572609,0.26462254809347246,0.24185604070453826,0.15485150119949739,-9.4294504571654281E-2,-3.4041961682191486E-2]
[]
[null,43,null,"COLLECTABLE REVENUE (ECN)",null,null,0.32087088999999996,0.23221086000000005,0.32684791000000007,0.6638889,0.55183464000000015,0.26472330000000005,0.24185604070453826,0.15485150119949739]
[null,44,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",null,null,5.2875930657830805E-2,-8.8055305451250343E-3,-8.8336805505698723E-2,7.6304332354293125E-2,5.6678309664274062E-2,1.0075190652758526E-4,0,0]
[]
[null,45,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,-0.10066819489167533,0.72264099784518376,0.415236509682259,-0.15730201642346708,-0.46557777436864645,-8.6033890735918717E-2,-0.3597368883224602]
[null,46,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,47,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,null,null,null,null,null,0,0]
[null,48,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,null,null,0,0]
[null,49,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,-0.31678665514548604,0.31900000000000001,0.90300000000000002,-0.29399999999999998,-0.54800000000000004,-8.6033890735918717E-2,-0.3597368883224602]
[]
[null,null,null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,50,null,"DN ALLOWED REVENUE LESS ECN REVENUE",null,null,292.70585827148977,301.17372570840814,286.90166511746821,319.96870750978212,301.31292093370064,321.37383683007425,328.50050055844122,351.1260303265974]
[null,51,null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",null,null,293.84412911000004,299.50378913999998,296.14355208999996,321.32252769999997,305.08116536,315.40641103166661,329.42118367861195,351.1260303265974]
[null,52,null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",null,null,1.138270838510266,-1.6699365684081613,9.241886972531745,1.3538201902178457,3.7682444262993613,-5.9674257984076462,0.92068312017073595,0]
[]
[null,53,null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,null,null,2.8929613800432685E-2,-4.7388133069608873E-2,0.11525566566082857,-5.8305034643149067E-2,6.6578345974043662E-2,2.2175618894997973E-2,6.8875175927261667E-2]
[null,54,null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,55,null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,null,null,null,null,null,0,0]
[null,56,null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,null,null,0,0]
[null,57,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,null,null,4.3999999999999997E-2,-2.1999999999999999E-2,5.3999999999999999E-2,-7.1999999999999995E-2,5.1999999999999998E-2,3.4647245853358211E-2,6.8875175927261667E-2]
[]
[null,null,null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,null,null,"DESCRIPTION","PCFM TERM",null,"FREQUENCY","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24"]
[]
[null,58,null,"COST OF DEBT","CDE",null,"ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9099999999999999E-2,1.5800000000000002E-2,1.09E-2,null,null,null,null,null,null,"CDE VALUE 2019/20 AS PER FINAL AIP POSITION NOVEMBER 2018, INTERNAL FORECAST 20/21 "]
[null,59,null,"CORPORATION TAX RATE","CT",null,"ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.17]
[]
[null,60,null,"COST OF DEBT ADJUSTMENT","CDE £ IMPACT",null,"ANNUAL",-1.600864387615502,-2.6570063341693242,-3.32457,-5.2661444683427021,-7.3997975961903535,-12.293585538047704,-16.354219496732298]
[null,61,null,"TAX TRIGGER EVENT","TTE",null,"AT ANY TIME",0,-0.24628205028233197,-0.23809413529789936,-1.430894659526075,-1.2702609564933027,-1.8885241553080903,-1.6361484710889727,null,null,null,null,null,null,"INCLUDES CHANGES TO SPECIAL RATE POOL ALLOWANCE"]
[null,62,null,"TAX LIABILITY - GEARING/INTEREST COSTS","TGIE",null,"AT ANY TIME",0,0,0,0,-1.4787562630696698,-2.011928908079085,-2.8346281568165068]
[null,63,null,"PENSION SCHEME ESTABLISHED DEFICIT","EDE",null,"3 YEARLY REVIEW",0,-0.91476105671432606,-0.9147610567143829,-0.89182952517319336,-0.52293153154107586,-0.5229315315411327,-0.52293153154107586]
[null,64,null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","APFE",null,"3 YEARLY REVIEW",0,0,0,0,0,0,0]
[null,65,null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,null,null,-1.600864387615502,-3.8180494411659822,-4.4774251920122818,-7.5888686530419704,-10.671746347294402,-16.716970132976012,-21.347927656178854,0,0,0,0,0]
[null,66,null,"LEGACY CAPEX RAV ADJUSTMENT","LRAV",null,"ONE OFF",0.71154887064682271,0,0,0,0,0,0]
[null,67,null,"LEGACY ALLOWED REVENUE ADJUSTMENT","LAR",null,"ONE OFF",0.61401032609836648,0,0,0,0,0,0]
[null,68,null,"LEGACY IFI CAP ADJUSTMENT","IFIAR",null,"ONE OFF",0,0,0,0,0,0,0]
[null,69,null,"LEGACY STREETWORKS COST ADJUSTMENT","IAEAR",null,"ONE OFF",0,0,0,0,0,0,0]
[null,70,null,"OVERALL LEGACY ADJUSTMENTS",null,null,null,1.3255591967451892,0,0,0,0,0,0]
[null,71,null,"TOTEX INCENTIVE MECHANISM",null,null,null,0,-5.54,1.5633298637571329,-2.2611581305228015,-5.3585252018236815,-5.2041461922566556,0.64689359206352037,null,null,null,null,null,null,"REFELCTS FINAL 2017/18 RRP POSITION AND UPDATED FORECAST ONWARDS"]
[null,72,null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","IAEEPS",null,"2 RE-OPENERS",0,0,8.8661896361532513,5.6547409252232228E-2,4.8159854996583817E-2,4.8135646357081896E-2,4.8109087396539962E-2]
[null,73,null,"SPECIFIED STREETWORKS","IAESW",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,"NO IMPACT FORECAST GD1"]
[null,74,null,"CHANGE TO CONNECTION CHARGING BOUNDARY","IAECCB",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,"NO IMPACT FORECAST GD1"]
[null,75,null,"SMART METERING ROLL-OUT","IAESM",null,"RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,null,null,null,null,null,"NO IMPACT FORECAST GD1"]
[null,76,null,"LARGE LOAD CONNECTIONS","IAELLC",null,"2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,"NO IMPACT FORECAST GD1"]
[null,77,null,"FUEL POOR NETWORK EXTENSIONS","IAEFP",null,"1 RE-OPENER (FLEXIBLE)",0,0,1.0421286669950405,1.041949023171469,1.0417352851813462,1.0412260177569124,1.0406673075718231,null,null,null,null,null,null,"REFLECTS FINAL REVISED ALLOWANCES FROM APRIL 2016 ONWARDS."]
[null,78,null,"AGENCY COSTS (FGO)","IAECA",null,"1 RE-OPENER (FLEXIBLE)",0,0,0,-0.58531905042195831,-1.0550243098261944,-1.3868974077371377,-1.554578998981583,null,null,null,null,null,null,"REFLECTS REVISED ALLOWANCES FOLLOWING FGO REVIEW"]
[null,79,null,"MAINS & SERVICES (REPEX T2)","RE",null,"ANNUAL",0,-0.11050513012781948,-3.0216938206365285E-2,-7.1431392094893909E-2,8.946968570342051E-2,6.4677644909437504E-2,0.10084568694594509,0.10084568694594509,0.10084568694594509]
[null,80,null,"INNOVATION ROLL-OUT MECHANISM","IRM",null,"ANNUAL",0,0,0,0,0,0,0,null,null,null,null,null,null,"NO IMPACT FORECAST GD1"]
[null,81,null,"NTS EXIT CAPACITY COST ALLOWANCE","AEX",null,"ANNUAL",0,0,0,0,0,0,0]
[null,82,null,"SHRINKAGE COST ALLOWANCE","ALSC",null,"ANNUAL",0,0,-0.97019305178821469,-0.32999999999998408,-0.33000000000004093,-0.34999999999990905,-0.3599999999999568,null,null,null,null,null,null,"REFLECTS ALLOWANCE ADJUSTMENTS FOLLOWING THE APPROVAL OF MOD 4."]
[null,83,null,"UNCERTAIN COSTS",null,null,null,0,-0.11050513012781948,8.9079083131537118,0.11174598990686491,-0.20565948394488487,-0.58285809871361494,-0.72495691706723164,0.10084568694594509,0.10084568694594509,0]
[]
[null,84,null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,null,null,-0.2753051908703128,-9.4685545712938008,5.9938129848985628,-9.738280793657907,-16.235931033062968,-22.503974423946282,-21.425990981182565,0.10084568694594509,0.10084568694594509,0]
[null,85,null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,null,null,-0.3,-9.5,6,-9.6999999999999993,-16.2,-22.44637093027174,-21.425990981182537,0.10084568694594509,0.10084568694594509,0]
[]
[null,null,null,"TABLE 6: RISKS AND SENSITIVITIES",null,null,"2013/14","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22","2022/23","2023/24"]
[]
[null,86,null,"Impact of proposed NTS Charging Methodology MOD0678",null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null," "]
[null,87,null,"Potential future effects of DEM. Changes to domestic EUC bands",null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null," "]
[null,88,null," ",null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null," "]
[null,89,null," ",null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null," "]
[null,90,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"MOVEMENT","index":1,"n_rows":132,"n_cols":29,"rows_kept":132,"cut":false,"hidden":false,"merged":[[3,18,3,25],[3,3,3,12]]}
[]
[]
["                              SGN","                                     SGN"]
[null,"                       SCOTLAND DISTRIBUTION NETWORK    ",null,"(UPDATE MARCH 2020)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOVEMENT DECEMBER 2019 TO MARCH 2020"]
[]
[]
[]
[null,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,"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,"TABLE 1: TOTAL CHARGE ELEMENTS (LDZ + CUSTOMER + ECN)"]
[]
[null,"FORECAST RPI FACTOR",1.1630163167045706,1.2050836282602921,1.226652469327056,1.2327332569617151,1.2709207088698118,1.3140257043000614,1.358588447714592,1.3798393359828387,null,null,null,null,null,null,-1.4699372496984608E-7,-1.6755346667896021E-6,-3.1673693885458931E-6,-2.7312353556574465E-7,-1.767073800174046E-6,-1.8270064989778234E-6,-1.8889660342580328E-6,-1.9185130293308816E-6,0,0,0,0,0]
[null,"ASSUMED ANNUAL INFLATION FOR PRICE SETTING",2.6499999999999999E-2,3.6170869618510654E-2,1.789821101287508E-2,4.9572212070751118E-3,3.0977871078303097E-2,3.3916353026131309E-2,3.3913144369019564E-2,1.5641887949212892E-2,null,null,null,null,null,null,0,-1.309718721566322E-6,-1.2130674145634235E-6,2.3722731501496855E-6,-1.2050375048054673E-6,0,-9.0205620750793969E-17,0,0,0,0,0,0]
[null,"ACTUAL / FORECAST ANNUAL INFLATION",2.8847655052620862E-2,1.9597725052664827E-2,1.077779080807904E-2,2.1427497658355089E-2,3.7419997584832783E-2,3.0556889335098612E-2,2.5500000000000102E-2,2.4750000000000008E-2,null,null,null,null,null,null,-1.2261162766792622E-6,2.4068331029164503E-6,-1.1814270522141762E-6,-3.4694469519536142E-17,0,1.9775847626135601E-16,-2.5000000000016329E-4,-9.9999999999999742E-4,0,0,0,0,0]
[null,"DIFFERENCE (DRIVES t+2 RPI TRUE UP)",2.3476550526208631E-3,-1.6573144565845827E-2,-7.1204202047960401E-3,1.6470276451279978E-2,6.4421265065296857E-3,-3.3594636910326964E-3,-8.4131443690194617E-3,9.1081120507871156E-3,null,null,null,null,null,null,-1.2261162766792622E-6,3.7165518244827722E-6,3.1640362349247275E-8,-2.3722731501835126E-6,1.2050375047707729E-6,1.7694179454963432E-16,-2.5000000000007308E-4,-9.9999999999998007E-4,0,0,0,0,0]
[]
[null,"OPENING BASE REVENUE ALLOWANCE (2009/10 PRICES)",256.5,249.4,243.3,256,259.5,261.60000000000002,257.10000000000002,261.7,null,null,null,null,null,null,0,0,0,0,0,0,0,0,224.26463053238447,229.38943045878742,229.39848287124533,224.85362381363325,222.31907192965727]
[null,"PRICE CONTROL FINANCIAL MODEL ITERATION ADJUSTMENT (2009/10 PRICES)",null,-0.3,-9.5,6,-9.6999999999999993,-16.2,-22.44637093027174,-21.425990981182537,0.10084568694594509,0.10084568694594509,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RPI TRUE UP (2009/10 PRICES)",null,null,0.87706243229736924,-3.5206752592915525,-5.0651584573321866,-1.0274782525454527,0.64910071675135705,-0.19598727302834501,0,0,null,null,null,null,0,0,-6.8147716461608443E-4,3.1937856579666857E-4,3.181240921925621E-4,-3.2371650080631476E-4,9.6665427329334364E-7,2.2861724771616743E-7,0,0,0,0,0]
[null,"UPLIFT TO NOMINAL PRICES USING RPIFt",41.813685234722357,51.086331799638756,53.190135694699883,60.156735104169883,66.303736755880621,76.739253253326481,84.376840617139791,91.191076363994057,null,null,null,null,null,null,-3.7703890427565057E-5,-4.1737568551525328E-4,-8.9776526738205575E-4,3.7331395787987276E-6,-3.4627868404868423E-4,-5.4812489611322235E-4,-4.4413223507433486E-4,-4.6050597536861915E-4,91.373511523422422,99.918559546939065,106.50892235085507,110.98380768265497,116.37383468058104]
[null,"BASE REVENUE (NOMINAL)",298.31368523472236,300.18633179963877,287.86719812699727,318.63605984487833,311.03857829854843,321.11177500078105,319.67957040361944,331.26909810978316,null,null,null,null,null,null,-3.7703890427565057E-5,-4.1737568551525328E-4,-1.5792424320011378E-3,3.2311170537013822E-4,-2.8154591859674838E-5,-8.7184139692908502E-4,-4.4316558080481627E-4,-4.6027735811549064E-4,315.73898774275284,329.40883569267243,335.90740522210041,335.83743149628822,338.69290661023831]
[]
[null,"BUSINESS RATES ADJUSTMENT",null,null,-2.4613874707583041,-2.3698876855368787,-2.1050880797082678,-1.7985007222734075,8.698638424816874,8.714122057386227,8.6917335383027332,8.7238656258740193,null,null,null,null,0,0,7.6159192669233988E-5,6.5526779398084045E-6,4.2304983626451076E-5,4.3649603187256858E-5,4.4997191599449593E-5,4.5517855085108749E-5,1.0346046975060474E-2,-9.5559642222163177E-2,0,0,0]
[null,"LICENSE FEES ADJUSTMENT",null,null,0.13006116551182442,0.17103155192715627,0.19869563082940825,-1.4089337618091179E-2,0.26308959477307098,0.28209843592514933,0.40712038506809789,0.41804198448993618,null,null,null,null,0,0,2.6400478435051333E-6,2.2712716768458208E-7,1.4663640126311162E-6,1.5129708556913674E-6,1.5596806042239564E-6,1.577727702595233E-6,3.8442264946308979E-4,3.9473534894945983E-4,0,0,0]
[null,"PENSION DEFICIT ADJUSTMENT",null,null,-7.3492188665398236E-2,-1.2879562406438198E-2,1.5864329647901203,1.5467479570523603,1.5578580714145867,1.383603293657143,1.4592728056970139,1.4793030171545885,null,null,null,null,0,0,9.7833022949384008E-6,8.4167177025369633E-7,5.433947890098878E-6,5.6066602287518919E-6,5.7797539054771363E-6,5.8466315646654721E-6,1.4125191433420614E-3,-1.5347088556596944E-2,0,0,0]
[null,"OTHER PASS THROUGH: \nTHIRD PARTY DAMAGE & WATER INGRESS, THEFT OF GAS, MISC PASS THROUGH",8.0000000000000036E-3,3.0000000000000001E-3,7.6400000000000003E-4,0,2E-3,0.52324168000000004,0.48825099999999999,0.16937632407528599,0,0,null,null,null,null,0,0,0,0,0,0,0,0.47754933827324397,0,0,0,0,0]
[null,"PASS THROUGH",8.0000000000000036E-3,3.0000000000000001E-3,-2.404054493911878,-2.2117356960161607,-0.3179594840887392,0.25739957716086154,11.00783709100453,10.549200111043804,10.558126729067844,10.621210627518543,null,null,null,null,0,0,8.8582542808079978E-5,7.6214768776061703E-6,4.9205295529208826E-5,5.0769234271719199E-5,5.2336626110260909E-5,0.47760228048759679,1.2142988767866569E-2,-0.11051199542981038,0,0,0]
[]
[null,"NTS EXIT CAPACITY INCENTIVE REVENUE ADJUSTMENT",null,null,0.1006236990172901,-2.810133595747067E-2,-2.0318007988140777E-2,1.3851510620559698E-2,5.7676159961033051E-3,-4.3189467602009384E-3,3.4973262442326001E-3,4.102528676593574E-3,null,null,null,null,0,0,0,0,0,0,0,0,8.5279840142176919E-7,5.0087039407701803E-6,0,0,0]
[null,"NTS EXIT CAPACITY COST ADJUSTMENT",null,null,0.11486319971756204,0.35019566349730108,0.26348385337599539,6.1928598587193982E-2,2.1988280146274949E-2,-0.12107768545562342,-9.4345756628757063E-2,-3.4380025270342861E-2,null,null,null,null,0,0,6.8751245919929094E-7,5.914769996007152E-8,3.8186562828501636E-7,3.940028269824869E-7,4.0616682400046455E-7,4.1086658923716879E-7,5.1252057102782467E-5,3.3806358815137438E-4,0,0,0]
[null,"NTS EXIT CAPACITY REVENUE ADJUSTMENT",0,0,0.21548689873485205,0.32209432753983042,0.24316584538785463,7.5780109207753632E-2,2.7755896142378271E-2,-0.12539663221582437,-9.0848430384524489E-2,-3.027749659374929E-2,null,null,null,null,0,0,6.8751245926867988E-7,5.9147699904560369E-8,3.8186562825726078E-7,3.9400282701718137E-7,4.061668240108729E-7,4.1086658927880215E-7,5.2104855504220282E-5,3.4307229209216625E-4,0,0,0]
[]
[null,"SHRINKAGE INCENTIVE REVENUE ADJUSTMENT",null,null,0.10393421653650955,0.16959666181593275,7.9021928813446815E-2,0.19463149233760568,0.1854417178160522,0.1997049597469121,0.12970015252610331,0.14444081705540562,null,null,null,null,0,0,0,0,0,0,0,0,-1.9496779029889569E-2,-0.10742064325803169,0,0,0]
[null,"SHRINKAGE COST ADJUSTMENT",null,null,-0.85903774435842639,-2.5761835540523736,-3.298191551947574,-3.4969833102937304,-2.9958571804366843,-2.3369827907421321,-4.0804637181833696,-3.5779200822023478,null,null,null,null,0,0,1.7875323939264831E-5,1.4195447990417165E-6,8.9738422630603054E-6,9.0620650197159591E-6,9.0778285155579397E-6,8.9774349758542371E-6,-0.35337894803266234,-0.90571798698224271,0,0,0]
[null,"SHRINKAGE REVENUE ADJUSTMENT",0,0,-0.75510352782191681,-2.4065868922364411,-3.2191696231341274,-3.3023518179561249,-2.8104154626206319,-2.1372778309952198,-3.9507635656572662,-3.4334792651469423,null,null,null,null,0,0,1.7875323939264831E-5,1.4195447990417165E-6,8.9738422630603054E-6,9.0620650197159591E-6,9.0778285155579397E-6,8.9774349758542371E-6,-0.37287572706255201,-1.0131386302402743,0,0,0]
[]
[null,"BROAD MEASURE OF CUSTOMER SATISFACTION REVENUE ADJUSTMENT",null,null,2.0068132479403582,2.2361362987608113,1.9884881145575244,2.5988032696252934,2.3095059234021096,2.5607172151869282,2.5505129830531006,2.6429782001600408,null,null,null,null,0,0,-1.7551511666269448E-7,-2.0962064875007513E-6,-8.1219280694266871E-6,1.6592596079334498E-6,-1.4505638779027663E-7,-4.5097533094562436E-6,-3.5357266221502925E-6,-3.6722502350094999E-6,0,0,0]
[null,"ENVIRONMENTAL EMISSIONS INCENTIVE REVENUE ADJUSTMENT",null,null,0.33185652415991734,0.77262297026402682,0.44756745047593943,1.2260782225527038,0.93157660547775833,0.96269208157626129,0.80437740341545594,0.83727609295608774,null,null,null,null,0,0,-8.5689485995743553E-7,-1.7118181561137646E-7,-6.2229272845826245E-7,-1.7047253138002816E-6,-1.2952535913823837E-6,-1.3385161978796134E-6,-1.9721207961187481E-4,-0.59030723898855686,0,0,0]
[null,"DISCRETIONARY REWARD SCHEME REVENUE ADJUSTMENT",0.23028569999999993,0.31007767499999989,null,0.21520799999999998,null,null,0.138573,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NETWORK INNOVATION ALLOWANCE REVENUE ADJUSTMENT",0.96929999999999994,0.91575000000000006,1.2954023915714876,1.2456,1.1358000000000001,1.1551696101992839,1.4385580668162876,1.4907109414940243,null,null,null,null,null,null,0,0,-7.1065909439393948E-6,0,0,0,-1.9942451137122674E-6,-2.0712481114681935E-6,0,0,0,0,0]
[null,"CORRECTION TERM REVENUE ADJUSTMENT",-6.5473799999999827,0,-1.2392298715148755,1.7469975174141721,-9.5068366301713816,-1.4832747547460985,-3.9786002330592338,6.2349553046472366,null,null,null,null,null,null,0,0,-3.9227127600627298E-5,-4.3423766321004642E-4,-1.5783697299696087E-3,-1.081770964548312E-4,-1.6199121224964586E-3,-9.6094463681595244E-4,-0.96257995640800542,0,0,0,0]
[]
[null,"MAXIMUM ALLOWED REVENUE",292.97389093472236,301.41515947463876,287.31836929615525,320.55639637060466,301.80963397157552,321.63937921682469,328.74436129078265,350.80469930052038," "," ",null,null,null,null,-3.7703890427565057E-5,-4.1737568551525328E-4,-1.5194631813528758E-3,-1.0429317683247064E-4,-1.5567075391800245E-3,-9.1983865695510758E-4,-2.0046916368983148E-3,0.47618252727653498,0,0,1,1,1]
[]
[null,"COLLECTABLE REVENUE",294.16500000000002,299.73599999999999,296.47039999999998,321.98641659999998,305.63299999999998,315.67113433166662,328.94656704420538,350.80469930052038,null,null,null,null,null,null,0,0,0,0,0,0,0.71647267511110613,0.47618252727653498,0,0,0,0,0]
[null,"UNDER / OVER RECOVERY CARRIED FORWARD",1.1911090652776579,-1.6791594746387659,9.1520307038447299,1.4300202293953248,3.8233660284244593,-5.9682448851580716,0,0,null,null,null,null,null,null,3.7703890427565057E-5,4.1737568551525328E-4,1.5194631813528758E-3,1.0429317683247064E-4,1.5567075391800245E-3,9.1983865695510758E-4,0,0,0,0,0,0,0]
[]
[null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,2.8812357691618384E-2,-4.6768683443307757E-2,0.11568361311486175,-5.8481947673742374E-2,6.5702823943375899E-2,2.2089901091272512E-2,6.7104840743488214E-2,null,null,null,null,null,null,null,-1.2922158512118642E-6,-3.7211438277395814E-6,5.5372561555966371E-6,-4.5499454121022964E-6,2.4490695222922909E-6,-3.3097218443689513E-6,1.4550049113681851E-3,0,0,0,0,0]
[null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,0,8.0000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,0,2E-3,0,0,0,0,0]
[null,"TOTAL DISTRIBUTION CHARGES ARITHMETICAL PRICE CHANGE",null,4.3999999999999997E-2,-2.1999999999999999E-2,5.6000000000000001E-2,-7.1999999999999995E-2,5.0999999999999997E-2,3.1E-2,7.5104840743488221E-2,null,null,null,null,null,null,0,0,0,0,0,0,0,3.455004911368173E-3]
[]
[null,"TABLE 2: DOMESTIC CUSTOMER BILL IMPACT","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022/23","2023/24",null,null,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,"AVERAGE AQ PER DOMESTIC CUSTOMER (Kwh)",15148.061045721144,14919.632532814625,14378.46140922877,14097.177876269187,13888.158378344611,13669.282141635831,13890.09393183435,13890.09393183435,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL ANNUAL CHARGE (EXCL.ECN) (NOMINAL)",129.94,133.41,124.66,137.15,129.55000000000001,138.17562037652596,141.24020777783892,151.549023044743,null,null,null,null,null,null,0,0,0,0,0,-1.5710489265075012E-7,-8.6193275933510449E-4,-0.5694523080034628,0,0,0,0,0]
[null,"TOTAL ANNUAL CHARGE (EXCL.ECN) (2016/17 PRICES)",146.23881659497124,147.25779824221141,136.13251181638816,146.63005653499334,133.50821187863127,138.17562037652596,137.49350964014496,143.44079880120671,null,null,null,null,null,null,0,0,0,0,0,-1.5710489265075012E-7,0.14926403824432555,0.54361762400603197,0,0,0,0,0]
[null,"% MOVEMENT IN DOMESTIC CUSTOMER BILL (2016/17 PRICES)",null,6.9679287002326618E-3,-7.5549726796296679E-2,7.7112693937242405E-2,-8.9489460527013676E-2,3.495971095873629E-2,-4.9365491142522311E-3,4.3255053832193857E-2,null,null,null,null,null,null,0,0,0,0,0,-1.1767431473685974E-9,1.0802498612753064E-3,2.8181440360872667E-3,0,0,0,0,0]
[]
[null,"TABLE 3: ECN CHARGE ELEMENTS (NTS EXIT CAPACITY ONLY)"]
[]
[null,"INITIAL ALLOWED REVENUE (2009/10 PRICES)",0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,"INFLATED BASE REVENEUE (NOMINAL)",0.23260326334091413,0.24101672565205845,0.2453304938654112,0.24654665139234302,0.25418414177396237,0.26280514086001228,0.27171768954291842,0.27596786719656774,null,null,null,null,null,null,-2.9398744993969217E-8,-3.3510693336902264E-7,-6.3347387771472974E-7,-5.4624707118700044E-8,-3.5341476001260475E-7,-3.6540129977336022E-7,-3.7779320688491325E-7,-3.837026058550741E-7]
[null,"ECN COST TRUE UP",null,null,0.11486319971756204,0.35019566349730108,0.26348385337599539,6.1928598587193982E-2,2.1988280146274949E-2,-0.12107768545562342,-9.4345756628757063E-2,-3.4380025270342861E-2,null,null,null,null,0,0,6.8751245919929094E-7,5.914769996007152E-8,3.8186562828501636E-7,3.940028269824869E-7,4.0616682400046455E-7,4.1086658923716879E-7,5.1252057102782467E-5,3.3806358815137438E-4,0,0,0]
[null,"CORRECTION FACTOR (ECN)",3.5391725399999997E-2,null,5.4990967884144093E-2,-9.1577517669300355E-3,-2.2511693265099865E-2,-6.0111219955260954E-2,-5.184995735827224E-2,-3.8707705430325096E-5,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL ALLOWED REVENUE (ECN)",0.26799498874091415,0.24101672565205845,0.41518466146711736,0.58758456312271412,0.49515630188485787,0.26462251949194526,0.24185601233092113,0.154851474035514,-9.4345756628757063E-2,-3.4380025270342861E-2,null,null,null,null,-2.9398744993969217E-8,-3.3510693336902264E-7,5.4038581442927835E-8,4.5229927581047491E-9,2.845086821690046E-8,2.8601527202187782E-8,2.8373617122490202E-8,2.716398339597248E-8,5.1252057102782467E-5,3.3806358815137438E-4,0,2.9398744993969217E-8,3.3510693336902264E-7]
[]
[null,"COLLECTABLE REVENUE (ECN)",0.32087088999999996,0.23221086000000005,0.32684791000000007,0.6638889,0.55183464000000015,0.26472330000000005,0.24185601233092113,0.154851474035514,null,null,null,null,null,null,0,0,0,0,0,0,2.8373617122490202E-8,2.716398339597248E-8,0,0,0,0,0]
[null,"UNDER / OVER RECOVERY CARRIED FORWARDS (ECN)",5.2875901259085811E-2,-8.8058656520584033E-3,-8.833675146711728E-2,7.6304336877285883E-2,5.6678338115142279E-2,1.0078050805478744E-4,0,0,null,null,null,null,null,null,2.9398744993969217E-8,3.3510693336902264E-7,-5.4038581442927835E-8,-4.5229927581047491E-9,-2.845086821690046E-8,-2.8601527202187782E-8,0,0,0,0,0,0,0]
[]
[null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,-0.10066704312496344,0.72263837849367696,0.41523668298919292,-0.15730205835675271,-0.46557780142424654,-8.6033899173562634E-2,-0.35973692552394598,null,null,null,null,null,null,0,-1.1517667118932096E-6,2.6193515068051454E-6,-1.7330693391492957E-7,4.1933285621631455E-8,2.7055600093639498E-8,8.437643916892057E-9,3.7201485780791188E-8,0,0,0,0,0]
[null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,null,null,null,0,0]
[null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,0,0]
[null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,-0.31678665514548604,0.31900000000000001,0.90300000000000002,-0.29399999999999998,-0.54800000000000004,-8.6033899173562634E-2,-0.35973692552394598,null,null,null,null,null,null,0,0,0,0,0,0,8.437643916892057E-9,3.7201485780791188E-8,0,0,0,0,0]
[]
[null,"TABLE 4: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,"DN ALLOWED REVENUE LESS ECN REVENUE",292.70589594598147,301.1741427489867,286.90318463468816,319.96881180748193,301.31447766969069,321.37475669733277,328.50250527845174,350.64984782648486,null,null,null,null,null,null,-3.7674491693451273E-5,-4.1704057855440624E-4,-1.5195172199469198E-3,-1.0429769980646597E-4,-1.5567359900501287E-3,-9.1986725851711526E-4,-2.0047200105182128E-3,0.47618250011254304,0,0,0,0,0]
[null,"DN COLLECTABLE REVENUE LESS ECN REVENUE",293.84412911000004,299.50378913999998,296.14355208999996,321.32252769999997,305.08116536,315.40641103166661,328.70471103187447,350.64984782648486,null,null,null,null,null,null,0,0,0,0,0,0,0.71647264673748623,0.47618250011254304,0,0,0,0,0]
[null,"UNDER / OVER RECOVERY CARRIED FORWARDS (LDZ & CUSTOMER)",1.1382331640185726,-1.6703536089867157,9.240367455311798,1.3537158925180393,3.7666876903093112,-5.9683456656661633,0.2022057534227315,0,null,null,null,null,null,null,3.7674491693451273E-5,4.1704057855440624E-4,1.5195172199469198E-3,1.0429769980646597E-4,1.5567359900501287E-3,9.1986725851711526E-4,0.71847736674800444,0,0,0,0,0,0]
[]
[null,"YEAR ON YEAR MOVEMENT IN ALLOWED REVENUE",null,2.8930906142621948E-2,-4.7384406855248029E-2,0.11525012249304933,-5.8300476325846229E-2,6.6575888363494817E-2,2.2178931084596121E-2,6.7419097852115861E-2,null,null,null,null,null,null,0,-1.292342189262996E-6,-3.7262143608440823E-6,5.5431677792316947E-6,-4.5583173028385104E-6,2.4576105488449684E-6,-3.312189598148052E-6,1.4560780751458058E-3,0,0,0,0,0]
[null,"ADJUSTMENT FOR PRIOR YEAR OVER / UNDER RECOVERY"]
[null,"IMPACT OF CHANGE IN ANNUAL LOAD FACTORS",null,null,null,null,null,null,0,0]
[null,"YEAR ON YEAR MOVEMENT IN AGGREGATE DEMAND",null,null,null,null,null,null,0,0]
[null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,4.3999999999999997E-2,-2.1999999999999999E-2,5.3999999999999999E-2,-7.1999999999999995E-2,5.1999999999999998E-2,3.4653559932131373E-2,6.7419097852115861E-2,null,null,null,null,null,null,null,0,0,0,0,0,-6.3140787731619241E-6,1.4560780751458058E-3,0,0,0,0,0]
[]
[null,"TABLE 5: PCFM ADJUSTMENTS"]
[]
[null,"DESCRIPTION","FREQUENCY","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,null,null,null,null,null,null,"2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"COST OF DEBT","ANNUAL",2.7199999999999998E-2,2.5499999999999998E-2,2.3800000000000002E-2,2.2200000000000001E-2,1.9099999999999999E-2,1.5800000000000002E-2,1.09E-2,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATION TAX RATE","ANNUAL",0.21,0.2,0.2,0.19,0.19,0.19,0.17,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"COST OF DEBT ADJUSTMENT","ANNUAL",-1.600864387615502,-2.6570063341693242,-3.32457,-5.2661444683427021,-7.3997975961903535,-12.293585538047704,-16.354219496732298,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TAX TRIGGER EVENT","AT ANY TIME",0,-0.24628205028233197,-0.23809413529789936,-1.430894659526075,-1.2702609564933027,-1.8885241553080903,-1.6361484710889727,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TAX LIABILITY - GEARING/INTEREST COSTS","AT ANY TIME",0,0,0,0,-1.4787562630696698,-2.011928908079085,-2.8346281568165068,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PENSION SCHEME ESTABLISHED DEFICIT","3 YEARLY REVIEW",0,-0.91476105671432606,-0.9147610567143829,-0.89182952517319336,-0.52293153154107586,-0.5229315315411327,-0.52293153154107586,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PENSION SCHEME ADMINISTRATION & PPF LEVY","3 YEARLY REVIEW",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SPECIFIED FINANCIAL ADJUSTMENTS",null,-1.600864387615502,-3.8180494411659822,-4.4774251920122818,-7.5888686530419704,-10.671746347294402,-16.716970132976012,-21.347927656178854,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LEGACY CAPEX RAV ADJUSTMENT","ONE OFF",0.71154887064682271,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LEGACY ALLOWED REVENUE ADJUSTMENT","ONE OFF",0.61401032609836648,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LEGACY IFI CAP ADJUSTMENT","ONE OFF",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LEGACY STREETWORKS COST ADJUSTMENT","ONE OFF",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OVERALL LEGACY ADJUSTMENTS",null,1.3255591967451892,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTEX INCENTIVE MECHANISM",null,0,-5.54,1.5633298637571329,-2.2611581305228015,-5.3585252018236815,-5.2041461922566556,0.64689359206352037,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ENHANCED PHYSICAL SITE SECURITY (CNI)","2 RE-OPENERS",0,0,8.8661896361532513,5.6547409252232228E-2,4.8159854996583817E-2,4.8135646357081896E-2,4.8109087396539962E-2,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SPECIFIED STREETWORKS","2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CHANGE TO CONNECTION CHARGING BOUNDARY","2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SMART METERING ROLL-OUT","RE-OPENER > REV DRIVER",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LARGE LOAD CONNECTIONS","2 RE-OPENERS",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FUEL POOR NETWORK EXTENSIONS","1 RE-OPENER (FLEXIBLE)",0,0,1.0421286669950405,1.041949023171469,1.0417352851813462,1.0412260177569124,1.0406673075718231,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"AGENCY COSTS (FGO)","1 RE-OPENER (FLEXIBLE)",0,0,0,-0.58531905042195831,-1.0550243098261944,-1.3868974077371377,-1.554578998981583,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MAINS & SERVICES (REPEX T2)","ANNUAL",0,-0.11050513012781948,-3.0216938206365285E-2,-7.1431392094893909E-2,8.946968570342051E-2,6.4677644909437504E-2,0.10084568694594509,0.10084568694594509,0.10084568694594509,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INNOVATION ROLL-OUT MECHANISM","ANNUAL",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NTS EXIT CAPACITY COST ALLOWANCE","ANNUAL",0,0,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SHRINKAGE COST ALLOWANCE","ANNUAL",0,0,-0.97019305178821469,-0.32999999999998408,-0.33000000000004093,-0.34999999999990905,-0.3599999999999568,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"UNCERTAIN COSTS",null,0,-0.11050513012781948,8.9079083131537118,0.11174598990686491,-0.20565948394488487,-0.58285809871361494,-0.72495691706723164,0.10084568694594509,0.10084568694594509,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL POTENTIAL IMPACT OF REVENUE ADJUSTMENTS SHOWN IN TABLE 4",null,-0.2753051908703128,-9.4685545712938008,5.9938129848985628,-9.738280793657907,-16.235931033062968,-22.503974423946282,-21.425990981182565,0.10084568694594509,0.10084568694594509,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL VALUE INCLUDED IN TABLE 1 IN THIS FORECAST",null,-0.3,-9.5,6,-9.6999999999999993,-16.2,-22.44637093027174,-21.425990981182537,0.10084568694594509,0.10084568694594509,0,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TABLE 6: RISKS AND SENSITIVITIES","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,null,null,null,null,null,null,"2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26"]
[]
[null,"Impact of proposed NTS Charging Methodology MOD0678",0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Potential future effects of DEM. Changes to domestic EUC bands",0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null," ",0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null," ",0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]