{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["_com.sap.ip.bi.xl.hiddensheet","BBPTACShadowWks0001","High level rec","MOD186 report","breakdown of movement"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":6,"defined_names":185,"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":"_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":"High level rec","index":2,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[15,1,25,1],[27,1,37,1],[3,1,13,1]]}
[]
[null,"Mod186 - March to June",null,null,null,"21/22","22/23","23/24","24/25","25/26",null,"GD2"]
[]
[null,"Mod186 : March",null,"Calculated revenue",null,430.74198884868196,566.21346879108569,"","",""]
[null,null,null,"AIP adjustment term",null,0,23.336813105498077,"","",""]
[null,null,null,"Adjusted revenue",null,430.74198884868196,589.55028189658378,517.97623956478208,498.71302604532644,509.5043036820158,null,2546.4858400373901]
[null,null,null,"Legacy Allowed Revenue",null,-13.758309947582799,10.789090515120025,0,0,0]
[null,null,null,"K Correction Factor",null,0.22531619608972683,-3.5694019316585774,0,0,0]
[null,null,null,"Allowed Revenue",null,417.2089950971889,596.76997048004523,517.97623956478208,498.71302604532644,509.5043036820158,null,2540.1725348693585]
[null,null,null,"Recovered Revenue",null,421.37276273297027,596.76997048004523,517.97623956478208,498.71302604532644,509.5043036820158]
[]
[null,null,null,"Inflation %",null,4.0504430498107924E-2,3.5628913618373614E-2,2.4416717530456822E-2,2.0525543471916041E-2,2.001263978442136E-2]
[null,null,null,"SOQ % Change",null,1.364087114457968E-2,-1.1751252876183171E-3,0,0,0]
[null,null,null,"LDZ Price Change",null,-0.13679750362423673,0.1541791087696408,-3.7615795099099503E-3,2.5551928159394829E-2,2.1291033316035195E-2]
[]
[null,"Mod186 : Latest Position",null,"Calculated revenue",null,430.74198884868196,566.21346879108569,540.09615862541239,"",""]
[null,null,null,"AIP adjustment term",null,0,23.336813105498077,5.5667055966060062,"",""]
[null,null,null,"Adjusted revenue",null,430.74198884868196,589.55028189658378,545.66286422201836,524.83735394275323,530.542583510638,null,2621.3350724206757]
[null,null,null,"Legacy Allowed Revenue",null,-13.758309947582799,10.789090515120025,0,0,0]
[null,null,null,"K Correction Factor",null,0.22531619608972683,-3.5694019316585774,-2.6932145981734186,0,0]
[null,null,null,"Allowed Revenue",null,417.2089950971889,596.76997048004523,542.96964962384493,524.83735394275323,530.542583510638,null,2612.3285526544705]
[null,null,null,"Recovered Revenue",null,421.15927115999995,599.40269295394114,542.96964962384345,524.83735394275311,530.54258351063822]
[]
[null,null,null,"Inflation %",null,4.4741803886011677E-2,7.6413310932051948E-2,3.3146068923555205E-2,1.6944069304936082E-2,1.9104788826139973E-2]
[null,null,null,"SOQ % Change",null,1.364087114457968E-2,-1.1751252876183171E-3,0,0,0]
[null,null,null,"LDZ Price Change",null,-0.13679750362423673,0.1541791087696408,7.0648063005912476E-2,1.6966663754571501E-3,1.2890888213830453E-2]
[]
[null,"Difference",null,"Calculated revenue",null,0,0,"","",""]
[null,null,null,"AIP adjustment term",null,0,0,"","",""]
[null,null,null,"Adjusted revenue",null,0,0,27.68662465723628,26.124327897426781,21.038279828622194,null,74.849232383285653]
[null,null,null,"Legacy Allowed Revenue",null,0,0,0,0,0]
[null,null,null,"K Correction Factor",null,0,0,-2.6932145981734186,0,0]
[null,null,null,"Allowed Revenue",null,0,0,24.993410059062853,26.124327897426781,21.038279828622194,null,72.156017785111999]
[null,null,null,"Recovered Revenue",null,-0.21349157297032662,2.6327224738959103,24.993410059061375,26.124327897426667,21.038279828622422]
[]
[null,null,null,"Inflation %",null,4.2373733879037534E-3,4.0784397313678333E-2,8.7293513930983835E-3,-3.5814741669799588E-3,-9.0785095828138651E-4]
[null,null,null,"SOQ % Change",null,0,0,0,0,0]
[null,null,null,"LDZ Price Change",null,0,0,7.4409642515822425E-2,-2.3855261783937678E-2,-8.4001451022047424E-3]

{"sheet":"MOD186 report","index":3,"n_rows":157,"n_cols":42,"rows_kept":157,"cut":false,"hidden":false,"merged":[[88,3,88,4],[1,19,1,23],[1,30,1,34],[1,8,1,12],[14,3,14,4],[76,3,76,4]]}
[null,null,null,"Red numbers are linked to latest PCFM forecast."]
[null,null,null,"NGN - Quarterly Movements",null,null,null,null,"Latest MOD186",null,null,null,null,null,null,null,null,null,null,"March Mod186",null,null,null,null,null,null,null,null,null,null,"Variance",null,null,null,null,null,null,null,null,null,null,"Notes"]
[]
[null,null,null,"DESCRIPTION","LICENCE \nTERM","PRICE BASE","2020/21",null,"21/22","22/23","23/24","24/25","25/26","26/27","27/28","28/29","29/30","30/31",null,"21/22","22/23","23/24","24/25","25/26","26/27","27/28","28/29","29/30","30/31",null,"21/22","22/23","23/24","24/25","25/26","26/27","27/28","28/29","29/30","30/31"]
[]
[null,"REF.",null,"TABLE 1: ALLOWED REVENUE & ARITHMETICAL PRICE CHANGE"]
[]
[null,1,null,"LDZ Revenue",null,"Nominal",null,null,379.6526457129238,444.27877623253215,480.66222826089802,480.2153084459153,486.39512587985297,null,null,null,null,null,null,379.6891074388148,444.19865013840132,444.3351833658345,454.47465710253761,464.13390913665057,null,null,null,null,null,null,-3.6461725891001606E-2,8.0126094130832826E-2,36.327044895063523,25.740651343377692,22.261216743202397,0,0,0,0,0]
[null,2,null,"Exit Revenue",null,"Nominal",null,null,37.55634938426509,56.58479712751312,37.958756380438267,44.622045496837949,44.147457630785034,null,null,null,null,null,null,37.55634938426509,56.664923221643896,47.62895679223675,44.238368942788817,45.37039454536523,null,null,null,null,null,null,0,-8.0126094130775982E-2,-9.6702004117984828,0.38367655404913137,-1.2229369145801954,0,0,0,0,0]
[null,3,null,"SOLR Revenue",null,"Nominal",null,null,0,95.906397119999951,24.348664982508716,0,0,null,null,null,null,null,null,0,95.906397119999994,26.012099406710814,0,0,null,null,null,null,null,null,0,0,-1.663434424202098,0,0,0,0,0,0,0]
[null,4,null,"ALLOWED REVENUE (AS PUBLISHED)","ARt","Nominal",438.78355547521431,null,417.24545682307991,596.76997048004523,542.96964962384493,524.83735394275323,530.542583510638,null,null,null,null,null,null,417.24545682307991,596.76997048004523,517.97623956478208,498.71302604532644,509.5043036820158,null,null,null,null,null,null,0,0,24.993410059062853,26.124327897426781,21.038279828622194,0,0,0,0,0]
[]
[null,5,null,"Total LDZ & Cust Charges Arithmetical Price Change",null,"%",null,null,-0.13679750362423673,0.1541791087696408,7.0648063005912476E-2,1.6966663754571501E-3,1.2890888213830453E-2,null,null,null,null,null,null,-0.13679750362423673,0.1541791087696408,-3.7615795099099503E-3,2.5551928159394829E-2,2.1291033316035195E-2,null,null,null,null,null,null,0,0,7.4409642515822425E-2,-2.3855261783937678E-2,-8.4001451022047424E-3,0,0,0,0,0]
[null,6,null,"Total ECN Charges Arithmetical Price Change",null,"%",null,null,9.7474552047073431,0.50764642828166728,-0.33092051492532409,0.17876089584799812,-1.0635726371767129E-2,null,null,null,null,null,null,9.7474552047073431,0.50764642828166728,-0.15251343129772826,-6.8642839542071843E-2,2.5590658187866211E-2,null,null,null,null,null,null,0,0,-0.17840708362759583,0.24740373539006996,-3.622638455963334E-2,0,0,0,0,0]
[null,7,null,"% Movement in Allowed Revenue",null,"%",null,null,-4.9085929459703803E-2,0.43026115856088798,-9.0152526965998292E-2,-3.3394676283754143E-2,1.0870471632830947E-2,null,null,null,null,null,null,-4.9085929459703803E-2,0.43026115856088798,-0.13203367262578747,-3.7189376747553404E-2,2.1638251004313158E-2,null,null,null,null,null,null,null,0,4.1881145659789176E-2,3.794700463799261E-3,-1.0767779371482211E-2,0,0,0,0,0]
[]
[null,null,null,"TABLE 2: ALLOWED REVENUE COMPOSITION (TOTAL OF LDZ + EXIT + SOLR)"]
[]
[null,8,null,"Base Revenue (Including Tax Allowance)",null,"18/19",null,null,405.15031225240466,500.7314790751621,442.37629828022023,422.47914439135303,419.02251714150765,null,null,null,null,null,null,405.15031225240466,500.7314790751621,446.58514940259431,421.02783647460052,421.70732026219582,null,null,null,null,null,null,0,0,-4.2088511223740852,1.451307916752512,-2.6848031206881728,0,0,0,0,0,null,"Shrinkage/NTS prices/SOLR updates"]
[null,9,null,"Total Output Delivery Incentive  ","ODIt","18/19",null,null,0,0.49882352941176433,0.49882352941176433,0.49882352941176433,0.49882352941176433,null,null,null,null,null,null,0,0.49882352941176433,0.49882352941176433,0.49882352941176433,0.49882352941176433,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,10,null,"Business Plan Incentive","BPIt","18/19",null,null,0.4206045538022069,1.149006,1.149006,1.149006,1.149006,null,null,null,null,null,null,0.4206045538022069,1.149006,1.149006,1.149006,1.149006,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,11,null,"Other Revenue Allowances ","ORAt","18/19",null,null,3.6762489201999999,3.6759999999999997,3.6759999999999997,3.6759999999999997,3.6759999999999997,null,null,null,null,null,null,3.6762489201999999,3.6759999999999997,3.6759999999999997,3.6759999999999997,3.6759999999999997,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,12,null,"Other Revenue Total (Inc. Siu/Cross Subsidy Adj.)","CSUBt/DRSt","18/19",null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,13,null,"TOTAL CALCULATED REVENUE","Rt","18/19",null,null,409.24716572640688,506.05530860457384,447.70012780963197,427.80297392076477,424.34634667091939,null,null,null,null,null,null,409.24716572640688,506.05530860457384,451.90897893200605,426.35166600401226,427.03114979160756,null,null,null,null,null,null,0,0,-4.2088511223740852,1.451307916752512,-2.6848031206881728,0,0,0,0,0]
[]
[null,14,null,"F'Cast Infl. Factor; Cpih (As Published)","PIt / PI2018/19",null,null,null,1.0526119339395996,1.118876650760557,1.2063792817478678,1.2268202559058428,1.2502583978225545,null,null,null,null,null,null,1.0526119339395996,1.118876650760557,1.1461959458936011,1.1697222406083743,1.1931314704574956,null,null,null,null,null,null,0,0,6.0183335854266717E-2,5.7098015297468496E-2,5.7126927365058977E-2,0,0,0,0,0]
[null,15,null,"Inflation True-Up To Nominal Prices",null,"Nominal",null,null,21.531284848166081,60.15816018651185,92.396030815780421,97.034380021988454,106.19623683971861,null,null,null,null,null,null,21.531284848166081,60.15816018651185,66.067260632776026,72.361360041314185,82.473153890408241,null,null,null,null,null,null,0,0,26.328770183004394,24.673019980674269,23.723082949310367,0,0,0,0,0,null,"inclusive of actual CPIH to April and OBR March forecast thereafter"]
[null,16,null,"TOTAL CALCULATED REVENUE NOMINAL (AS PUBLISHED)","Rt","Nominal",null,null,430.77845057457296,566.21346879108569,540.09615862541239,524.83735394275323,530.542583510638,null,null,null,null,null,null,430.77845057457296,566.21346879108569,517.97623956478208,498.71302604532644,509.5043036820158,null,null,null,null,null,null,0,0,22.119919060630309,26.124327897426781,21.038279828622194,0,0,0,0,0]
[]
[null,17,null,"Adj Term (Prior Years Movement)","ADJt","Nominal",null,null,0,23.336813105498077,5.5667055966060062,"","",null,null,null,null,null,null,0,23.336813105498077,null,null,null,null,null,null,null,null,null,0,0,5.5667055966060062,"","",0,0,0,0,0,null,"Inflation benefit for 22/23 less monies being returned for 22/23 on shrinkage, rates and exit"]
[null,18,null,"Correction Term; K Factor","Kt","Nominal",null,null,0.22531619608972683,-3.5694019316585774,-2.6932145981734186,0,0,null,null,null,null,null,null,0.22531619608972683,-3.5694019316585774,null,null,null,null,null,null,null,null,null,0,0,-2.6932145981734186,0,0,0,0,0,0,0,null,"latest over collection estimate for 22/23 being returned in 23/24"]
[null,19,null,"Legacy Revenue","LARt","Nominal",null,null,-13.758309947582799,10.789090515120025,null,null,null,null,null,null,null,null,null,-13.758309947582799,10.789090515120025,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,20,null,"ALLOWED REVENUE (AS PUBLISHED)","ARt","Nominal",438.78355547521431,null,417.24545682307991,596.76997048004523,542.96964962384493,524.83735394275323,530.542583510638,null,null,null,null,null,null,417.24545682307991,596.76997048004523,517.97623956478208,498.71302604532644,509.5043036820158,null,null,null,null,null,null,0,0,24.993410059062853,26.124327897426781,21.038279828622194,0,0,0,0,0]
[null,21,null,"memo;  Current assessment Allowed Revenue ","ARt","Nominal",null,null,453.34197949232578,569.70695802986779,540.09615862541239,524.83735394275323,530.542583510638,null,null,null,null,null,null,452.60406007286315,566.21346879108569,517.97623956478208,498.71302604532644,509.5043036820158,null,null,null,null,null,null,0.73791941946262796,3.4934892387821037,22.119919060630309,26.124327897426781,21.038279828622194,0,0,0,0,0]
[]
[null,22,null,"Recovered Revenue  (+ Forecast)","RRt","Nominal",438.56092403999997,null,421.15927115999995,599.40269295394114,542.96964962384345,524.83735394275311,530.54258351063822,null,null,null,null,null,null,421.37276273297027,596.81217342369041,517.97623956478208,498.7130260453265,509.50386848828038,null,null,null,null,null,null,-0.21349157297032662,2.5905195302507309,24.993410059061375,26.12432789742661,21.038715022357849,0,0,0,0,0]
[null,23,null,"Under / Over Recovery Carried Fwd","ARt - RRt","Nominal",0.22263143521433904,null,-3.9138143369200407,-2.6327224738959103,1.4779288903810084E-12,0,0,null,null,null,null,null,null,-4.1273059098903673,-4.2202943645179403E-2,0,0,4.3519373542721951E-4,null,null,null,null,null,null,0.21349157297032662,-2.5905195302507309,1.4779288903810084E-12,0,-4.3519373542721951E-4,0,0,0,0,0]
[]
[null,null,null,"TABLE 3: DOMESTIC CUST BILL IMPACT (LDZ CHARGES ONLY - EXCL. EXIT AND SOLR)"]
[null,null,null,"Customer Numbers - Bopri 28.04.21",null,"#",2516349,null,2524893,null,null,null,null,null,null,null,null,null,null,2524893,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Aq Per Domestic Customer - Bopri 28.04.21",null,"Kwh",35227259465,null,36011906698,null,null,null,null,null,null,null,null,null,null,36011906698,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Soq Per Domestic Customer - Bopri 28.04.21",null,"Kwh",283340857,null,293076859,null,null,null,null,null,null,null,null,null,null,293076859,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,24,null,"Average AQ Per Domestic Customer",null,"Kwh",13999.353613111694,null,14262.745668034249,null,null,null,null,null,null,null,null,null,null,14262.745668034249,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,25,null,"Average SOQ Per Domestic Customer",null,"Kwh",112.59998394499333,null,116.07496198848823,null,null,null,null,null,null,null,null,null,null,116.07496198848823,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Unit Rates - Commodity",null,"p/kwh",3.3500000000000002E-2,null,2.8899999999999999E-2,3.3399999999999999E-2,3.5799999999999998E-2,3.5900000000000001E-2,3.6400000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8899999999999999E-2,3.3399999999999999E-2,3.5799999999999998E-2,3.5900000000000001E-2,3.6400000000000002E-2,0,0,0,0,0]
[null,null,null,"Unit Rates - Capacity",null,"p/pdkwh/d",0.21249999999999999,null,0.18340000000000001,0.2117,0.22670000000000001,0.2271,0.23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18340000000000001,0.2117,0.22670000000000001,0.2271,0.23,0,0,0,0,0]
[null,null,null,"Unit Rates - Capacity Fixed",null,"p/kwh",0.1134,null,9.7900000000000001E-2,0.113,0.121,0.1212,0.12280000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.7900000000000001E-2,0.113,0.121,0.1212,0.12280000000000001,0,0,0,0,0]
[null,null,null,"Unit Rates - Capacity Exit",null,"p/kwh"]
[null,null,null,"Unit Rates - Capacity SOLR",null,"p/kwh"]
[null,null,null,"Charges - Commodity",null,"£",4.6897834603924178,null,4.1219334980618978,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1219334980618978,0,0,0,0,0,0,0,0,0]
[null,null,null,"Charges - Capacity",null,"£",87.33536254733545,null,77.701740304713908,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77.701740304713908,0,0,0,0,0,0,0,0,0]
[null,null,null,"Charges - Fixed",null,"£",46.606259354672183,null,41.477646542156442,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41.477646542156442,0,0,0,0,0,0,0,0,0]
[null,null,null,"Charges - Exit",null,"£"]
[null,null,null,"Charges - SOLR",null,"£"]
[null,null,null,"Total Annual Charge (Excl. Ecn) ",null,"NOMINAL",138.63140536240005,null,123.30132034493224,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123.30132034493224,0,0,0,0,0,0,0,0,0]
[null,26,null,"Total Annual Charge (Excl. Exit & SOLR) ",null,"Nominal",138.63140536240005,null,123.30132034493224,144.276353040098,156.21244437817657,155.94648469280057,157.95333617778275,null,null,null,null,null,null,123.30132034493224,144.25033266546231,144.29467085395294,147.58739238544885,150.72416535579939,null,null,null,null,null,null,0]
[null,27,null,"Total Annual Charge (Excl. Exit & SOLR)",null,"18/19",133.51421779335735,null,117.13844045397973,128.94750546633185,129.48866640999296,127.11437061956148,126.33655287008965,null,null,null,null,null,null,117.13844045397973,128.92424966363188,125.89005516108108,126.17302404089405,126.32653574882704,null,null,null,null,null,null,0]
[null,28,null,"% Movement In Domestic Customer Bill",null,"%",null,null,-0.11058161732828886,0.17011198774261826,8.2730753076086128E-2,-1.7025512047691427E-3,1.286884721342374E-2,null,null,null,null,null,null,-0.11058161732828886,0.16990095695590091,3.0736974862621835E-4,2.2819425776497537E-2,2.125366482631752E-2,null,null,null,null,null,null,0]
[]
[null,null,null,"TABLE 4: EXIT CAPACITY CHARGES"]
[]
[null,29,null,"NTS Exit Capacity Pass-Through Allowed Revenue","ECt","18/19",null,null,41.768555026269532,40.617432788080094,36.073881119859905,36.372113422508377,35.310666745108222,null,null,null,null,null,null,41.768555026269532,40.617432788080094,41.002174074309785,37.81955015216294,38.026316184559576,null,null,null,null,null,null,0,0,-4.9282929544498799,-1.4474367296545623,-2.7156494394513544,0,0,0,0,0,null,"Impact of including latest NTS prices published on 27.05.22"]
[null,30,null,"Inflated Nts Exit Capacity Pass-Through Allowed Revenue","AECt","Nominal",null,null,43.919876016046274,45.445897160419086,43.518782795234564,44.622045496838069,44.147457630785162,null,null,null,null,null,null,43.919876016046274,45.445897160419086,46.99652569679759,44.238368942788817,45.37039454536523,null,null,null,null,null,null,0,0,-3.4777429015630261,0.38367655404925216,-1.2229369145800675,0,0,0,0,0]
[null,31,null,"Legacy NTS Pass-Through"," ","Nominal",null,null,-6.406577193257232,13.343530254527836,0,0,0,null,null,null,null,null,null,-6.406577193257232,13.343530254527836,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,32,null,"NTS Cost True Up - Part Of Adj. Term",null,"Nominal",null,null,0,-2.6292941761235795,-5.5705485158960402,0,0,null,null,null,null,null,null,0,-2.6292941761235795,0,0,0,null,null,null,null,null,null,0,0,-5.5705485158960402,0,0,0,0,0,0,0]
[null,33,null,"Correction Term; K Factor For ECN",null,"Nominal",null,null,4.3050561476052795E-2,0.424663888689779,1.0522101099742689E-2,-1.2372302014403637E-13,-1.3082227018855957E-13,null,null,null,null,null,null,4.3050561476052795E-2,0.50478998282055298,0.63243109543916265,0,0,null,null,null,null,null,null,0,-8.0126094130773984E-2,-0.62190899433941993,-1.2372302014403637E-13,-1.3082227018855957E-13,0,0,0,0,0]
[null,34,null,"ECN Total Allowed Revenue (As Published)",null,"Nominal",3.400712811476053,null,37.55634938426509,56.58479712751312,37.958756380438267,44.622045496837949,44.147457630785034,null,null,null,null,null,null,37.55634938426509,56.664923221643896,47.62895679223675,44.238368942788817,45.37039454536523,null,null,null,null,null,null,0,-8.0126094130775982E-2,-9.6702004117984828,0.38367655404913137,-1.2229369145801954,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,null," "]
[null,35,null,"Collectable Revenue (ECN)",null,"Nominal",3.3576622500000002,null,37.059583140000001,56.574511362666648,37.958756380438388,44.622045496838076,44.147457630785155,null,null,null,null,null,null,37.058251669999997,56.046697121398289,47.62895679223675,44.23836894278881,45.370457921192433,null,null,null,null,null,null,1.331470000003776E-3,0.5278142412683593,-9.670200411798362,0.38367655404926637,-1.2230002904072776,0,0,0,0,0]
[null,36,null,"Under / Over Recovery Carried Forwards (ECN)",null,"Nominal",-4.3050561476052795E-2,null,-0.49676624426508909,-1.0285764846472034E-2,1.2079226507921703E-13,1.2789769243681803E-13,1.2079226507921703E-13,null,null,null,null,null,null,-0.49809771426509286,-0.61822610024560731,0,0,6.3375827203060453E-5,null,null,null,null,null,null,1.331470000003776E-3,0.60794033539913528,1.2079226507921703E-13,1.2789769243681803E-13,-6.3375827082268188E-5,0,0,0,0,0]
[]
[null,37,null,"Year On Year Movement In Allowed Revenue",null,"%",null,null,10.043669802850552,0.506663934466973,-0.3291704078235238,0.17554023766262139,-1.0635726371767129E-2,null,null,null,null,null,null,10.043669802850552,0.50879742442125342,-0.15946313725800199,-7.1187531237311918E-2,2.5589225589225606E-2,null,null,null,null,null,null,0,-2.1334899542804209E-3,-0.16970727056552182,0.24672776889993331,-3.6224951960992735E-2,0,0,0,0,0]
[null,38,null,"Adjustment For Prior Year Over / Under Recovery",null,"%",null,null,1.1462924959924248E-3,8.7791468642298507E-3,2.7097212414927058E-4,-2.7070086934445158E-15,-2.897056802374777E-15,null,null,null,null,null,null,1.1462924959924248E-3,8.7902301096710565E-3,1.298004705293849E-2,0,0,null,null,null,null,null,null,0,-1.1083245441205827E-5,-1.270907492878922E-2,-2.7070086934445158E-15,-2.897056802374777E-15,0,0,0,0,0]
[null,39,null,"Impact Of Change In Annual Load Factors",null,"%",null,null,-1.364087114457968E-2,1.1751252876183171E-3,0,0,0,null,null,null,null,null,null,-1.364087114457968E-2,1.1751252876183171E-3,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,40,null,"Year On Year Movement In Aggregate Demand",null,"%",null,null,-0.28372001949462167,-8.9717783371539017E-3,-2.0210792259495736E-3,3.2206581853794491E-3,2.8969882048812678E-15,null,null,null,null,null,null,-0.28372001949462167,-1.1116351536875513E-2,-6.0303410926647594E-3,2.5446916952400755E-3,1.4325986406049651E-6,null,null,null,null,null,null,0,2.1445731997216111E-3,4.0092618667151858E-3,6.759664901393736E-4,-1.4325986377079769E-6,0,0,0,0,0]
[null,41,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,"%",null,null,9.7474552047073431,0.50764642828166728,-0.33092051492532409,0.17876089584799812,-1.0635726371767129E-2,null,null,null,null,null,null,9.7474552047073431,0.50764642828166728,-0.15251343129772826,-6.8642839542071843E-2,2.5590658187866211E-2,null,null,null,null,null,null,0,0,-0.17840708362759583,0.24740373539006996,-3.622638455963334E-2,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: LDZ & CUSTOMER CHARGE ELEMENTS"]
[]
[null,42,null,"Dn Allowed Revenue (less Exit and SOLR)",null,"Nominal",435.38284266373824,null,379.6891074388148,444.27877622945215,481.03429396263664,480.2153084459153,486.39512587985297,null,null,null,null,null,null,379.6891074388148,444.19865013840132,444.3351833658345,454.47465710253761,464.13390913665057,null,null,null,null,null,null,0,8.0126091050829018E-2,36.699110596802143,25.740651343377692,22.261216743202397,0,0,0,0,0]
[null,43,null,"Dn Collectable Revenue (Less Exit and SOLR)",null,"Nominal",435.20326179,null,384.09968801999992,447.28549322860783,480.66222826089637,480.21530844591501,486.39512587985308,null,null,null,null,null,null,384.31451106297027,444.85907918229213,470.34728277254533,454.47465710253766,464.13341056708794,null,null,null,null,null,null,-0.21482304297035171,2.4264140463156991,10.314945488351043,25.740651343377351,22.261715312765148,0,0,0,0,0]
[null,44,null,"Under / Over Recovery Carried Forwards (LDZ & Customer)",null,"Nominal",-0.17958087373824583,null,4.4105805811851155,3.0067169991556852,-0.37206570174026865,0,0,null,null,null,null,null,null,4.6254036241554672,0.66042904389081514,26.012099406710831,0,-4.9856956263738539E-4,null,null,null,null,null,null,-0.21482304297035171,2.3462879552648701,-26.3841651084511,0,4.9856956263738539E-4,0,0,0,0,0]
[]
[null,45,null,"Year On Year Movement In Allowed Revenue",null,"%",null,null,-0.12791899396903361,0.17011198774261826,8.2730753076086128E-2,-1.7025512047691427E-3,1.286884721342374E-2,null,null,null,null,null,null,-0.12791899396903361,0.16990095695590091,3.0736974862621835E-4,2.2819425776497537E-2,2.125366482631752E-2,null,null,null,null,null,null,0,2.1103078671735886E-4,8.2423383327459909E-2,-2.452197698126668E-2,-8.3848176128937801E-3,0,0,0,0,0]
[null,46,null,"Adjustment For Prior Year Over / Under Recovery",null,"%","",null,4.729682000877112E-4,-9.9275068204186002E-3,-6.2505252471442832E-3,7.7478933969089185E-4,0,null,null,null,null,null,null,4.729682000877112E-4,-1.0412916884628771E-2,-1.4863307444800383E-3,-5.7235533379459788E-2,0,null,null,null,null,null,null,0,4.8541006421017052E-4,-4.7641945026642447E-3,5.801032271915068E-2,0,0,0,0,0,0]
[null,47,null,"Impact Of Change In Annual Load Factors",null,"%",null,null,-1.364087114457968E-2,1.1751252876183171E-3,0,0,0,null,null,null,null,null,null,-1.364087114457968E-2,1.1751252876183171E-3,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,48,null,"Year On Year Movement In Aggregate Demand",null,"%",null,null,4.2893932892888453E-3,-7.1804974401771804E-3,-5.8321648230293677E-3,2.6244282405354009E-3,2.2041000406713279E-5,null,null,null,null,null,null,4.2893932892888453E-3,-6.4840565892496371E-3,-2.5826185140561302E-3,5.9968035762357083E-2,3.7368489717675563E-5,null,null,null,null,null,null,0,-6.9644085092754326E-4,-3.2495463089732375E-3,-5.7343607521821681E-2,-1.5327489310962283E-5,0,0,0,0,0]
[null,49,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,"%",null,null,-0.13679750362423673,0.1541791087696408,7.0648063005912476E-2,1.6966663754571501E-3,1.2890888213830453E-2,null,null,null,null,null,null,-0.13679750362423673,0.1541791087696408,-3.7615795099099503E-3,2.5551928159394829E-2,2.1291033316035195E-2,null,null,null,null,null,null,0,0,7.4409642515822425E-2,-2.3855261783937678E-2,-8.4001451022047424E-3,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: PASS THROUGH COSTS"]
[]
[null,50,null,"Shrinkage","SLt","Nominal",null,null,16.306662594167872,19.483430812725569,16.832501222812532,12.43659183933533,8.9534174485545091,null,null,null,null,null,null,16.595704642793319,20.923569355232797,7.5479731028685437,5.6637154046602243,5.177905730718189,null,null,null,null,null,null,-0.28904204862544702,-1.4401385425072277,9.2845281199439889,6.7728764346751058,3.77551171783632,0,0,0,0,0,null,"Inclusive of latest gas price forecast on 27.05.22"]
[null,51,null,"Licensed Activity","LFt","Nominal",null,null,2.2802519999999999,2.3614949015361235,2.419154855496545,2.4688093236483364,2.5182167153389305,null,null,null,null,null,null,2.2802519999999999,2.3614949015361235,2.419154855496545,2.4688093236483359,2.5182167153389305,null,null,null,null,null,null,0,0,0,4.4408920985006262E-16,0,0,0,0,0,0]
[null,52,null,"Prescribed Rates","RBt","Nominal",null,null,45.639679999999998,45.639680000000006,47.152455978929027,47.951410460933943,48.867512031705623,null,null,null,null,null,null,45.637859999999996,47.263887371667423,48.41791635901275,49.41172040605926,50.400579367674268,null,null,null,null,null,null,1.8200000000021532E-3,-1.624207371667417,-1.2654603800837236,-1.4603099451253172,-1.5330673359686458,0,0,0,0,0,null,"known actuals for 21/22 and 22/23 now included, inflationary impact thereafter."]
[null,53,null,"Pension Scheme Established Deficit Repair","EDEt","Nominal",null,null,5.1068726808450204,5.2888250064508773,15.125140434624768,15.435592162134499,15.744499107934528,null,null,null,null,null,null,5.1068726808450204,5.2888250064508782,15.125140434624768,15.435592162134499,15.744499107934528,null,null,null,null,null,null,0,-8.8817841970012523E-16,0,0,0,0,0,0,0,0]
[null,54,null,"Distribution Network Pension Deficit Charge","PDt","Nominal",null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,55,null,"Third Party Damage & Water Ingress Costs","TPWIt","Nominal",null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,56,null,"Gas Illegally Taken","TGt","Nominal",null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,57,null,"Bad Debt","BDt","Nominal",null,null,0.16145891333333351,3.3475686900000001,0,0,0,null,null,null,null,null,null,0.16145891333333351,3.3475686900000001,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,58,null,"Nts Exit Flat Capacity Costs & Nts Flex Capacity Costs","ECt","Nominal",null,null,42.66292567,40.211049183350674,43.518782795234564,44.622045496838069,44.147457630785162,null,null,null,null,null,null,42.66292908220575,45.445897160419086,46.99652569679759,44.238368942788817,45.37039454536523,null,null,null,null,null,null,-3.4122057499530456E-6,-5.2348479770684122,-3.4777429015630261,0.38367655404925216,-1.2229369145800675,0,0,0,0,0,null,"Impact of including latest NTS prices published on 27.05.22"]
[null,59,null,"Cdsp Costs (Xoserve)","CDSPt","Nominal",null,null,3.59016,3.7927933928571429,2.5827171428571427,2.5666896428571433,2.5449380357142855,null,null,null,null,null,null,3.59016,3.7927933928571429,2.5827171428571427,2.5666896428571433,2.5449380357142855,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,60,null,"Miscellaneous Costs","MPt","Nominal",null,null,0,95.906397123080012,23.976599280770003,0,0,null,null,null,null,null,null,0,95.906397119999994,26.012099406710814,0,0,null,null,null,null,null,null,0,3.0800180184087367E-9,-2.0355001259408105,0,0,0,0,0,0,0,null,"revision of latest estimate of SOLR (20% impact for 23/24)"]
[null,61,null,"Stranraer Ldz","SLDZt","Nominal",null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,62,null,"TOTAL PASS THROUGH COSTS","PTt","Nominal",null,null,115.74801185834622,216.0312391100004,151.60735171072457,125.48113892574732,122.77604097003304,null,null,null,null,null,null,116.03523731917741,224.33043299816342,149.10152699836814,119.78489588214828,121.75653350274543,null,null,null,null,null,null,-0.28722546083119482,-8.2991938881630176,2.5058247123564286,5.6962430435990399,1.0195074672876103,0,0,0,0,0]
[]
[null,null,null,"TABLE 7: INFLATION"]
[]
[null,63,null,"Forecast Inflation Factor; Cpih","PIt / PI2018/19",null,1.0383269111980469,null,1.0526119339395996,1.118876650760557,1.2063792817478678,1.2268202559058428,1.2502583978225545,null,null,null,null,null,null,1.0526119339395996,1.118876650760557,1.1461959458936011,1.1697222406083743,1.1931314704574956,null,null,null,null,null,null,0,0,6.0183335854266717E-2,5.7098015297468496E-2,5.7126927365058977E-2,0,0,0,0,0]
[null,64,null,"Assumed Annual Inflation For Price Setting",null,null,null,null,1.3728694438340794E-2,3.5628913618373614E-2,null,null,null,null,null,null,null,null,null,1.3728694438340794E-2,3.5628913618373614E-2,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,65,null,"Actual / Forecast Annual Inflation",null,null,null,null,4.4741803886011677E-2,7.6413310932051948E-2,3.3146068923555205E-2,1.6944069304936082E-2,1.9104788826139973E-2,null,null,null,null,null,null,4.0504430498107924E-2,3.5628913618373614E-2,2.4416717530456822E-2,2.0525543471916041E-2,2.001263978442136E-2,null,null,null,null,null,null,4.2373733879037534E-3,4.0784397313678333E-2,8.7293513930983835E-3,-3.5814741669799588E-3,-9.0785095828138651E-4,0,0,0,0,0]
[null,66,null,"Difference (Drives Cpih True Up)",null,null,null,null,3.1013109447670884E-2,4.0784397313678333E-2,"","","",null,null,null,null,null,null,2.677573605976713E-2,0,"","","",null,null,null,null,null,null,4.2373733879037534E-3,4.0784397313678333E-2,"","","",0,0,0,0,0]
[]
[null,null,null,"TABLE 8: RISKS AND SENSITIVITES "]
[]
[null,67]
[null,68]
[null,69]
[null,70]
[]
[null,null,null,"TABLE 9: UNIT RATES",null,null,null,null,"Actual","Actual","Forecast"]
[]
[null,null,null,"LDZ CAPACITY CHARGES"]
[]
[null,71,null,"Commodity ","0-73.2","p/kwh",null,null,2.8899999999999999E-2,3.3399999999999999E-2,3.5799999999999998E-2]
[null,72,null,null,"73.2 - 732","p/kwh",null,null,2.4799999999999999E-2,2.86E-2,3.0599999999999999E-2]
[null,73,null,null,">732","multiplyer",null,null,0.318,0.36699999999999999,0.39290000000000003]
[null,74,null,null,null,"peak ^",null,null,-0.29399999999999998,-0.29399999999999998,-0.29399999999999998]
[null,75,null,null,"Subject to a minimum rate of",null,null,null,8.9999999999999998E-4,1E-3,1.1000000000000001E-3]
[]
[null,76,null,"Capacity","0-73.2","p/pdkwh/d",null,null,0.18340000000000001,0.2117,0.22670000000000001]
[null,77,null,null,"73.2 - 732","p/pdkwh/d",null,null,0.15759999999999999,0.18190000000000001,0.1948]
[null,78,null,null,">732","multiplyer",null,null,1.8492,2.1343000000000001,2.2850999999999999]
[null,79,null,null,null,"peak ^",null,null,-0.28339999999999999,-0.28339999999999999,-0.28339999999999999]
[null,80,null,null,"Subject to a minimum rate of",null,null,null,4.7000000000000002E-3,5.4000000000000003E-3,5.7999999999999996E-3]
[]
[null,null,null,"LDZ CUSTOMER CHARGES"]
[]
[null,81,null,"Capacity","0-73.2","p/kwh",null,null,9.7900000000000001E-2,0.113,0.121]
[null,82,null,null,"73.2 - 732","p/pdkwh/d",null,null,3.5000000000000001E-3,4.0000000000000001E-3,4.3E-3]
[null,83,null,null,">732","multiplyer",null,null,7.4800000000000005E-2,8.6300000000000002E-2,9.2399999999999996E-2]
[null,84,null,null,null,"peak ^",null,null,-0.21,-0.21,-0.21]
[null,85,null,"Fixed charges between 73,200 & 732,000 kwh","Non monthly read supply points",null,null,null,30.7638,35.506900000000002,38.0154]
[null,86,null,null,"Monthly read supply points",null,null,null,32.756300000000003,37.806600000000003,40.477600000000002]
[]
[]
[null,null,null,"EXIT CHARGES"]
[]
[null,87,null,"Capacity","NE1","p/pdkwh/d",null,null,1.9093157013661103E-2,2.933966746361991E-2,1.9681917159213601E-2]
[null,88,null,"Capacity","NE2","p/pdkwh/d",null,null,2.1533425821170644E-2,3.2999050145039129E-2,7.6900454504038136E-3]
[null,89,null,"Capacity","NE3","p/pdkwh/d",null,null,2.1533425821170644E-2,3.2999050145039129E-2,7.6900454504038136E-3]
[null,90,null,"Capacity","NO1","p/pdkwh/d",null,null,1.9875125306190757E-2,2.99036577656095E-2,2.0060258543488769E-2]
[null,91,null,"Capacity","NO2","p/pdkwh/d",null,null,1.7675857675848269E-2,2.7568841367584619E-2,1.8493994611394789E-2]
[]
[null,null,null,"SOLR CHARGES"]
[]
[null,92,null,"Capacity","0-73.2","p/pdkwh/d",null,null,null,0.09]

{"sheet":"breakdown of movement","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,3,1,5]]}
[]
[null,"Detailed Movements",null,"23/24 Breakdown",null,null,"24/25","25/26",null,"GD2"]
[null,null,null,"Prior yr impact","Reforecast 23/24","Total","Reforecast","Reforecast"]
[]
[null,"Inflation",null,14.737214950398378,20.236829597354859,34.974044547753238,20.428084853827784,20.018772361334641,null,75.420901762915662]
[null,"Shrinkage",null,-1.8737462554786717,9.2845281199441061,7.4107818644654344,6.7728764346751404,3.7755117178361388,null,17.959170016976714]
[null,"SOLR estimate",null,null,-2.6582353717441265,-2.6582353717441265,null,null,null,-2.6582353717441265]
[null,"22/23 over collection",null,null,-2.6932145981734186,-2.6932145981734186,null,null,null,-2.6932145981734186]
[null,"Rates",null,-1.7262145856952973,-1.2654603800839279,-2.9916749657792252,-1.4603099451253456,-1.5330673359684397,null,-5.9850522468730105]
[null,"Exit (NTS prices)",null,-5.5705485158960402,-3.4777429015630004,-9.0482914174590405,0.38367655404920242,-1.2229369145801456,null,-9.8875517779899837]
[null,"Total movement",null,5.5667055933283693,19.426704465734492,24.99341005906286,26.124327897426781,21.038279828622194,null,72.156017785111828]
[]
[]
[null,null,null,null,null,0,0,0]