{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["_com.sap.ip.bi.xl.hiddensheet","BBPTACShadowWks0001","MOD186","High level rec"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":6,"defined_names":184,"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":"MOD186","index":2,"n_rows":157,"n_cols":52,"rows_kept":157,"cut":false,"hidden":false,"merged":[[1,40,1,44],[1,45,1,49],[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,"June Mod186",null,null,null,null,null,null,null,null,null,null,"Variance",null,null,null,null,null,null,null,null,null,"22/23 60 day notice data",null,null,null,null,"Latest vs. 60 day notice",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","21/22","22/23","23/24","24/25","25/26","21/22","22/23","23/24","24/25","25/26"]
[]
[null,"REF.",null,"TABLE 1: ALLOWED REVENUE & ARITHMETICAL PRICE CHANGE"]
[]
[null,1,null,"LDZ Revenue",null,"Nominal",null,null,378.85036516107829,443.3429014411883,484.35471979068012,486.62932089487794,490.97215249117005,null,null,null,null,null,null,379.6526457129238,444.27877623253215,480.66222826089802,480.2153084459153,486.39512587985297,null,null,null,null,null,null,-0.80228055184551295,-0.93587479134384921,3.692491529782103,6.4140124489626373,4.5770266113170806,0,0,0,0,0]
[null,2,null,"Exit Revenue",null,"Nominal",null,null,37.556868540344752,57.951657818469869,39.255369943953248,44.607999999999997,44.134,null,null,null,null,null,null,37.55634938426509,56.58479712751312,37.958756380438267,44.622045496837949,44.147457630785034,null,null,null,null,null,null,5.1915607966179778E-4,1.3668606909567487,1.2966135635149811,-1.4045496837951532E-2,-1.3457630785033814E-2,0,0,0,0,0]
[null,3,null,"SOLR Revenue",null,"Nominal",null,null,0.80587739000000003,95.906397123079998,23.936157167312341,0,0,null,null,null,null,null,null,0,95.906397119999951,24.348664982508716,0,0,null,null,null,null,null,null,0.80587739000000003,3.0800464401181671E-9,-0.41250781519637414,0,0,0,0,0,0,0]
[null,4,null,"ALLOWED REVENUE (AS PUBLISHED)","ARt","Nominal",438.78355547521431,null,417.24545682307991,596.76997048004523,547.2917496969801,531.20429393085305,535.06328745477754,null,null,null,null,null,null,417.24545682307991,596.76997048004523,542.96964962384493,524.83735394275323,530.542583510638,null,null,null,null,null,null,0,0,4.3221000731351751,6.3669399880998299,4.5207039441395409,0,0,0,0,0,417.2089950971889,596.76997048004523,491.96414015807125,498.71302604532644,509.5043036820158,3.6461725891001606E-2,0,55.32760953890886,32.491267885526611,25.558983772761735]
[]
[null,5,null,"Total LDZ & Cust Charges Arithmetical Price Change",null,"%",null,null,-0.13679750362423673,0.1541791087696408,7.8892657747482178E-2,7.4215989747168348E-3,8.8989735603745585E-3,null,null,null,null,null,null,-0.13679750362423673,0.1541791087696408,7.0648063005912476E-2,1.6966663754571501E-3,1.2890888213830453E-2,null,null,null,null,null,null,0,0,8.2445947415697024E-3,5.7249325992596847E-3,-3.9919146534558945E-3,0,0,0,0,0]
[null,6,null,"Total ECN Charges Arithmetical Price Change",null,"%",null,null,9.7474552047073431,0.50764642828166728,-0.30919599504162065,0.13946738401634162,-1.0635726371767167E-2,null,null,null,null,null,null,9.7474552047073431,0.50764642828166728,-0.33092051492532409,0.17876089584799812,-1.0635726371767129E-2,null,null,null,null,null,null,0,0,2.1724519883703441E-2,-3.9293511831656497E-2,-3.8163916471489756E-17,0,0,0,0,0]
[null,7,null,"% Movement in Allowed Revenue",null,"%",null,null,-4.9085929459703803E-2,0.43026115856088798,-8.291003775418615E-2,-2.9394661576817471E-2,7.2646128203677218E-3,null,null,null,null,null,null,-4.9085929459703803E-2,0.43026115856088798,-9.0152526965998292E-2,-3.3394676283754143E-2,1.0870471632830947E-2,null,null,null,null,null,null,null,0,7.242489211812142E-3,4.000014706936672E-3,-3.6058588124632251E-3,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,448.00091826693853,426.38277059498279,421.85907833310313,null,null,null,null,null,null,405.15031225240466,500.7314790751621,442.37629828022023,422.47914439135303,419.02251714150765,null,null,null,null,null,null,0,0,5.6246199867183009,3.9036262036297558,2.8365611915954787,0,0,0,0,0,405.15031225240466,500.7314790751621,423.89086270588888,421.02783647460052,421.70732026219582,0,0,24.110055561049649,5.3549341203822678,0.15175807090730586,null,"see slide detail for breakdown of movement"]
[null,9,null,"Total Output Delivery Incentive  ","ODIt","18/19",null,null,0,0.49882352941176433,1.6218191979879839,1.8326606621006378,1.859566380458668,null,null,null,null,null,null,0,0.49882352941176433,0.49882352941176433,0.49882352941176433,0.49882352941176433,null,null,null,null,null,null,0,0,1.1229956685762197,1.3338371326888736,1.3607428510469037,0,0,0,0,0,0,0.49882352941176433,0.49882352941176433,0.49882352941176433,0.49882352941176433,0,0,1.1229956685762197,1.3338371326888736,1.3607428510469037,null,"Customer Service Incentive"]
[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,0.4206045538022069,1.149006,1.149006,1.149006,1.149006,0,0,0,0,0]
[null,11,null,"Other Revenue Allowances ","ORAt","18/19",null,null,3.6762489201999999,3.6759999999999997,4.952,3.3860000000000006,2.855,null,null,null,null,null,null,3.6762489201999999,3.6759999999999997,3.6759999999999997,3.6759999999999997,3.6759999999999997,null,null,null,null,null,null,0,0,1.2760000000000002,-0.28999999999999915,-0.82099999999999973,0,0,0,0,0,3.6762489201999999,3.6759999999999997,3.6759999999999997,3.6759999999999997,3.6759999999999997,0,0,1.2760000000000002,-0.28999999999999915,-0.82099999999999973,null,"Rephasing on Innovation allowances"]
[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,0,null,null,null,null,0,0,0,0,0]
[null,13,null,"TOTAL CALCULATED REVENUE","Rt","18/19",null,null,409.24716572640688,506.05530860457384,455.72374346492649,432.75043725708343,427.72265071356179,null,null,null,null,null,null,409.24716572640688,506.05530860457384,447.70012780963197,427.80297392076477,424.34634667091939,null,null,null,null,null,null,0,0,8.0236156552945204,4.9474633363186626,3.3763040426424027,0,0,0,0,0,409.24716572640688,506.05530860457384,429.21469223530062,426.35166600401226,427.03114979160756,0,0,26.509051229625868,6.3987712530711747,0.69150092195422985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,14,null,"F'Cast Infl. Factor; Cpih (As Published)","PIt / PI2018/19",null,null,null,1.0526119339395996,1.118876650760557,1.2070548174037865,1.2275072378847331,1.2509585044470788,null,null,null,null,null,null,1.0526119339395996,1.118876650760557,1.2063792817478678,1.2268202559058428,1.2502583978225545,null,null,null,null,null,null,0,0,6.7553565591871312E-4,6.8698197889038859E-4,7.0010662452424377E-4,0,0,0,0,0,1.0526119339395996,1.118876650760557,1.1461959458936011,1.1697222406083743,1.1931314704574956,0,0,6.0858871510185431E-2,5.7784997276358885E-2,5.7827033989583221E-2]
[null,15,null,"Inflation True-Up To Nominal Prices",null,"Nominal",null,null,21.531284848166081,60.15816018651185,94.359796489700386,98.453856673769621,107.34063674121575,null,null,null,null,null,null,21.531284848166081,60.15816018651185,92.396030815780421,97.034380021988454,106.19623683971861,null,null,null,null,null,null,0,0,1.9637656739199656,1.4194766517811672,1.1443999014971382,0,0,0,0,0,21.531284848166081,60.15816018651185,62.749447922770628,72.361360041314185,82.473153890408241,0,0,31.610348566929758,26.092496632455436,24.867482850807505,null,"Now includes May and June actual"]
[null,16,null,"TOTAL CALCULATED REVENUE NOMINAL (AS PUBLISHED)","Rt","Nominal",null,null,430.77845057457296,566.21346879108569,550.08353995462687,531.20429393085305,535.06328745477754,null,null,null,null,null,null,430.77845057457296,566.21346879108569,540.09615862541239,524.83735394275323,530.542583510638,null,null,null,null,null,null,0,0,9.987381329214486,6.3669399880998299,4.5207039441395409,0,0,0,0,0,430.77845057457296,566.21346879108569,491.96414015807125,498.71302604532644,509.5043036820158,0,0,58.119399796555626,32.491267885526611,25.558983772761735]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,17,null,"Adj Term (Prior Years Movement)","ADJt","Nominal",null,null,0,23.336813105498077,-0.64710958134810115,"","",null,null,null,null,null,null,0,23.336813105498077,5.5667055966060062,"","",null,null,null,null,null,null,0,0,-6.2138151779541069,"","",0,0,0,0,0,0,23.336813105498077,null,null,null,0,0,-0.64710958134810115,"","",null,"breakdown provided on slides"]
[null,18,null,"Correction Term; K Factor","Kt","Nominal",null,null,0.22531619608972683,-3.5694019316585774,-2.1446806762986323,0,0,null,null,null,null,null,null,0.22531619608972683,-3.5694019316585774,-2.6932145981734186,0,0,null,null,null,null,null,null,0,0,0.54853392187478622,0,0,0,0,0,0,0,0.22531619608972683,-3.5694019316585774,0,0,0,0,0,-2.1446806762986323,0,0]
[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,-13.758309947582799,10.789090515120025,0,0,0,0,0,0,0,0]
[null,20,null,"ALLOWED REVENUE (AS PUBLISHED)","ARt","Nominal",438.78355547521431,null,417.24545682307991,596.76997048004523,547.2917496969801,531.20429393085305,535.06328745477754,null,null,null,null,null,null,417.24545682307991,596.76997048004523,542.96964962384493,524.83735394275323,530.542583510638,null,null,null,null,null,null,0,0,4.3221000731351751,6.3669399880998299,4.5207039441395409,0,0,0,0,0,417.24545682307991,596.76997048004523,491.96414015807125,498.71302604532644,509.5043036820158,0,0,55.32760953890886,32.491267885526611,25.558983772761735]
[null,21,null,"memo;  Current assessment Allowed Revenue ","ARt","Nominal",null,null,442.86757868765085,571.98549954664088,550.33803715959255,531.23732089487794,535.10615249117006,null,null,null,null,null,null,453.34197949232578,569.70695802986779,540.09615862541239,524.83735394275323,530.542583510638,null,null,null,null,null,null,-10.474400804674929,2.2785415167730889,10.241878534180159,6.3999669521247142,4.5635689805320681,0,0,0,0,0]
[]
[null,22,null,"Recovered Revenue  (+ Forecast)","RRt","Nominal",438.56092403999997,null,421.15927115999995,599.3651522776106,547.54624690194566,531.23732089487794,535.1057140091782,null,null,null,null,null,null,421.15927115999995,599.40269295394114,542.96964962384345,524.83735394275311,530.54258351063822,null,null,null,null,null,null,0,-3.7540676330536371E-2,4.5765972781022128,6.3999669521248279,4.5631304985399765,0,0,0,0,0]
[null,23,null,"Under / Over Recovery Carried Fwd","ARt - RRt","Nominal",0.22263143521433904,null,-3.9138143369200407,-2.5951817975653739,-0.25449720496555983,-3.3026964024884364E-2,-4.2426554400663008E-2,null,null,null,null,null,null,-3.9138143369200407,-2.6327224738959103,1.4779288903810084E-12,0,0,null,null,null,null,null,null,0,3.7540676330536371E-2,-0.25449720496703776,-3.3026964024884364E-2,-4.2426554400663008E-2,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.22",null,"#",2516349,null,2524893,2527399,null,null,null,null,null,null,null,null,null,2524893,null,null,null,null,null,null,null,null,null,null,0,2527399,0,0,0,0,0,0,0,0]
[null,null,null,"Total Aq Per Domestic Customer - Bopri 28.04.22",null,"Kwh",35227259465,null,36011906698,36246478182,null,null,null,null,null,null,null,null,null,36011906698,null,null,null,null,null,null,null,null,null,null,0,36246478182,0,0,0,0,0,0,0,0]
[null,null,null,"Total Soq Per Domestic Customer - Bopri 28.04.22",null,"Kwh",283340857,null,293076859,295374263,null,null,null,null,null,null,null,null,null,293076859,null,null,null,null,null,null,null,null,null,null,0,295374263,0,0,0,0,0,0,0,0]
[null,24,null,"Average AQ Per Domestic Customer",null,"Kwh",13999.353613111694,null,14262.745668034249,14341.415099871449,null,null,null,null,null,null,null,null,null,14262.745668034249,null,null,null,null,null,null,null,null,null,null,0,14341.415099871449,0,0,0,0,0,0,0,0]
[null,25,null,"Average SOQ Per Domestic Customer",null,"Kwh",112.59998394499333,null,116.07496198848823,116.86886914175403,null,null,null,null,null,null,null,null,null,116.07496198848823,null,null,null,null,null,null,null,null,null,null,0,116.86886914175403,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.5999999999999997E-2,3.6299999999999999E-2,3.6600000000000001E-2,null,null,null,null,null,null,2.8899999999999999E-2,3.3399999999999999E-2,3.5799999999999998E-2,3.5900000000000001E-2,3.6400000000000002E-2,null,null,null,null,null,null,0,0,1.9999999999999879E-4,3.9999999999999758E-4,1.9999999999999879E-4,0,0,0,0,0]
[null,null,null,"Unit Rates - Capacity",null,"p/pdkwh/d",0.21249999999999999,null,0.18340000000000001,0.2117,0.22839999999999999,0.2301,0.2321,null,null,null,null,null,null,0.18340000000000001,0.2117,0.22670000000000001,0.2271,0.23,null,null,null,null,null,null,0,0,1.6999999999999793E-3,3.0000000000000027E-3,2.0999999999999908E-3,0,0,0,0,0]
[null,null,null,"Unit Rates - Capacity Fixed",null,"p/kwh",0.1134,null,9.7900000000000001E-2,0.113,0.12189999999999999,0.12280000000000001,0.1239,null,null,null,null,null,null,9.7900000000000001E-2,0.113,0.121,0.1212,0.12280000000000001,null,null,null,null,null,null,0,0,8.9999999999999802E-4,1.6000000000000042E-3,1.0999999999999899E-3,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,4.7900326433570637,0,0,0,null,null,null,null,null,null,4.1219334980618978,0,0,0,0,null,null,null,null,null,null,0,4.7900326433570637,0,0,0,0,0,0,0,0]
[null,null,null,"Charges - Capacity",null,"£",87.33536254733545,null,77.701740304713908,90.30515953017904,0,0,0,null,null,null,null,null,null,77.701740304713908,0,0,0,0,null,null,null,null,null,null,0,90.30515953017904,0,0,0,0,0,0,0,0]
[null,null,null,"Charges - Fixed",null,"£",46.606259354672183,null,41.477646542156442,48.202565077516446,0,0,0,null,null,null,null,null,null,41.477646542156442,0,0,0,0,null,null,null,null,null,null,0,48.202565077516446,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,143.29775725105256,0,0,0,null,null,null,null,null,null,123.30132034493224,0,0,0,0,null,null,null,null,null,null,0,143.29775725105256,0,0,0,0,0,0,0,0]
[null,26,null,"Total Annual Charge (Excl. Exit & SOLR) ",null,"Nominal",138.63140536240005,null,123.30132034493224,143.29775725105256,156.6105550192236,157.43120733654055,158.83308484847612,null,null,null,null,null,null,123.30132034493224,144.276353040098,156.21244437817657,155.94648469280057,157.95333617778275,null,null,null,null,null,null,0]
[null,27,null,"Total Annual Charge (Excl. Exit & SOLR)",null,"18/19",133.51421779335735,null,113.664447245956,122.66425882759924,129.74601713290201,128.25277316313785,126.96910751542477,null,null,null,null,null,null,117.13844045397973,128.94750546633185,129.48866640999296,127.11437061956148,126.33655287008965,null,null,null,null,null,null,-3.4739932080237281]
[null,28,null,"% Movement In Domestic Customer Bill",null,"%",null,null,-0.11058161732828886,0.16217536722381243,9.2903043449922951E-2,5.2400830660246367E-3,8.9046989834662416E-3,null,null,null,null,null,null,-0.11058161732828886,0.17011198774261826,8.2730753076086128E-2,-1.7025512047691427E-3,1.286884721342374E-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.72466091246735,40.617432788080094,36.042273617343611,36.340315252942588,35.280147057721265,null,null,null,null,null,null,41.768555026269532,40.617432788080094,36.073881119859905,36.372113422508377,35.310666745108222,null,null,null,null,null,null,-4.3894113802181778E-2,0,-3.1607502516294517E-2,-3.1798169565789181E-2,-3.0519687386956207E-2,0,0,0,0,0,41.768555026269532,40.617432788080094,41.002174074309785,37.81955015216294,38.026316184559576,-4.3894113802181778E-2,0,-4.9599004569661744,-1.4792348992203515,-2.7461691268383106]
[null,30,null,"Inflated Nts Exit Capacity Pass-Through Allowed Revenue","AECt","Nominal",null,null,43.919876016046274,45.445897160419086,43.505000000000003,44.607999999999997,44.134,null,null,null,null,null,null,43.919876016046274,45.445897160419086,43.518782795234564,44.622045496838069,44.147457630785162,null,null,null,null,null,null,0,0,-1.3782795234561718E-2,-1.4045496838072324E-2,-1.3457630785161712E-2,0,0,0,0,0,43.919876016046274,45.445897160419086,46.99652569679759,44.238368942788817,45.37039454536523,0,0,-3.4915256967975878,0.36963105721117984,-1.2363945453652292]
[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,-6.406577193257232,13.343530254527836,0,0,0,0,0,0,0,0]
[null,32,null,"NTS Cost True Up - Part Of Adj. Term",null,"Nominal",null,null,0,-1.3417363514084788,-5.6343761028713022,0,0,null,null,null,null,null,null,0,-2.6292941761235795,-5.5705485158960402,0,0,null,null,null,null,null,null,0,1.2875578247151007,-6.382758697526203E-2,0,0,0,0,0,0,0,0,-2.6292941761235795,0,0,0,0,1.2875578247151007,-5.6343761028713022,0,0]
[null,33,null,"Correction Term; K Factor For ECN",null,"Nominal",null,null,4.3569717555710229E-2,0.50396675493142429,1.3847460468245487,0,0,null,null,null,null,null,null,4.3050561476052795E-2,0.424663888689779,1.0522101099742689E-2,-1.2372302014403637E-13,-1.3082227018855957E-13,null,null,null,null,null,null,5.1915607965743321E-4,7.9302866241645287E-2,1.374223945724806,1.2372302014403637E-13,1.3082227018855957E-13,0,0,0,0,0,4.3050561476052795E-2,0.424663888689779,-6.5418200315243531E-14,0,3.8018155361628084E-5,5.1915607965743321E-4,7.9302866241645287E-2,1.3847460468246142,0,-3.8018155361628084E-5]
[null,34,null,"ECN Total Allowed Revenue (As Published)",null,"Nominal",3.400712811476053,null,37.556868540344752,57.951657818469869,39.255369943953248,44.607999999999997,44.134,null,null,null,null,null,null,37.55634938426509,56.58479712751312,37.958756380438267,44.622045496837949,44.147457630785034,null,null,null,null,null,null,5.1915607966179778E-4,1.3668606909567487,1.2966135635149811,-1.4045496837951532E-2,-1.3457630785033814E-2,0,0,0,0,0,37.55634938426509,56.58479712751312,46.996525696797526,44.238368942788817,45.370432563520588,5.1915607966179778E-4,1.3668606909567487,-7.7411557528442785,0.36963105721117984,-1.2364325635205873]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,35,null,"Collectable Revenue (ECN)",null,"Nominal",3.3576622500000002,null,37.059583140000001,56.655408965483872,39.255369943953241,44.607999999999983,44.133561518008207,null,null,null,null,null,null,37.059583140000001,56.574511362666648,37.958756380438388,44.622045496838076,44.147457630785155,null,null,null,null,null,null,0,8.0897602817223913E-2,1.2966135635148532,-1.4045496838093641E-2,-1.3896112776947689E-2,0,0,0,0,0,37.137315489999999,56.584797127513184,46.996525696797512,44.238331774542658,45.370419801786383,-7.7732349999998007E-2,7.061183797068793E-2,-7.7411557528442714,0.3696682254573247,-1.2368582837781759]
[null,36,null,"Under / Over Recovery Carried Forwards (ECN)",null,"Nominal",-4.3050561476052795E-2,null,-0.49728540034475088,-1.2962488529859968,0,0,-4.3848199179308267E-4,null,null,null,null,null,null,-0.49676624426508909,-1.0285764846472034E-2,1.2079226507921703E-13,1.2789769243681803E-13,1.2079226507921703E-13,null,null,null,null,null,null,-5.1915607966179778E-4,-1.2859630881395248,-1.2079226507921703E-13,-1.2789769243681803E-13,-4.3848199191387494E-4,0,0,0,0,0,-0.41903389426509108,6.3948846218409017E-14,0,-3.716824615906944E-5,-1.2761734204502773E-5,-7.8251506079659805E-2,-1.2962488529860607,0,3.716824615906944E-5,-4.257202575885799E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,37,null,"Year On Year Movement In Allowed Revenue",null,"%",null,null,10.043822463809722,0.54303753403232768,-0.32261868906462754,0.13635408515290903,-1.0625896700143356E-2,null,null,null,null,null,null,10.043669802850552,0.506663934466973,-0.3291704078235238,0.17554023766262139,-1.0635726371767129E-2,null,null,null,null,null,null,1.5266095916999234E-4,3.6373599565354686E-2,6.5517187588962633E-3,-3.9186152509712358E-2,9.8296716237733506E-6,0,0,0,0,0]
[null,38,null,"Adjustment For Prior Year Over / Under Recovery",null,"%",null,null,1.1462766505627739E-3,8.5810383872445533E-3,3.3020930762764758E-2,0,0,null,null,null,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.5845429650893431E-8,-1.981084769852974E-4,3.274995863861549E-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,null,null,null,null,null,null,null,null,null,null,"note SOQ assumption will be revised later this year"]
[null,40,null,"Year On Year Movement In Aggregate Demand",null,"%",null,null,-0.2838726646083618,-4.5147269425523273E-2,-1.9598236739757857E-2,3.1132988634325898E-3,-9.8296716238115145E-6,null,null,null,null,null,null,-0.28372001949462167,-8.9717783371539017E-3,-2.0210792259495736E-3,3.2206581853794491E-3,2.8969882048812678E-15,null,null,null,null,null,null,-1.5264511374013523E-4,-3.6175491088369371E-2,-1.7577157513808284E-2,-1.0735932194685938E-4,-9.8296716267085027E-6,0,0,0,0,0]
[null,41,null,"ECN CHARGES ARITHMETICAL PRICE CHANGE",null,"%",null,null,9.7474552047073431,0.50764642828166728,-0.30919599504162065,0.13946738401634162,-1.0635726371767167E-2,null,null,null,null,null,null,9.7474552047073431,0.50764642828166728,-0.33092051492532409,0.17876089584799812,-1.0635726371767129E-2,null,null,null,null,null,null,0,0,2.1724519883703441E-2,-3.9293511831656497E-2,-3.8163916471489756E-17,0,0,0,0,0]
[]
[null,null,null,"TABLE 5: LDZ & CUSTOMER CHARGE ELEMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,42,null,"Dn Allowed Revenue (less Exit and SOLR)",null,"Nominal",435.38284266373824,null,379.68858828273517,442.91191553849541,484.05978047225682,486.59629393085305,490.92928745477752,null,null,null,null,null,null,379.6891074388148,444.27877622945215,481.03429396263664,480.2153084459153,486.39512587985297,null,null,null,null,null,null,-5.1915607963337607E-4,-1.3668606909567416,3.0254865096201797,6.380985484937753,4.5341615749245534,0,0,0,0,0]
[null,43,null,"Dn Collectable Revenue (Less Exit and SOLR)",null,"Nominal",435.20326179,null,383.29381062999994,446.78955759904676,484.35471979068006,486.62932089487794,490.97215249116999,null,null,null,null,null,null,384.09968801999992,447.28549322860783,480.66222826089637,480.21530844591501,486.39512587985308,null,null,null,null,null,null,-0.80587738999997782,-0.49593562956107462,3.6924915297836947,6.4140124489629216,4.57702661131691,0,0,0,0,0]
[null,44,null,"Under / Over Recovery Carried Forwards (LDZ & Customer)",null,"Nominal",-0.17958087373824583,null,3.6052223472647711,3.8776420605513522,0.29493931842324628,3.3026964024884364E-2,4.2865036392470302E-2,null,null,null,null,null,null,4.4105805811851155,3.0067169991556852,-0.37206570174026865,0,0,null,null,null,null,null,null,-0.80535823392034445,0.87092506139566694,0.66700502016351493,3.3026964024884364E-2,4.2865036392470302E-2,0,0,0,0,0]
[]
[null,45,null,"Year On Year Movement In Allowed Revenue",null,"%",null,null,-0.12792018638184544,0.16651363566576549,9.2903043449922951E-2,5.2400830660246367E-3,8.9046989834662416E-3,null,null,null,null,null,null,-0.12791899396903361,0.17011198774261826,8.2730753076086128E-2,-1.7025512047691427E-3,1.286884721342374E-2,null,null,null,null,null,null,-1.1924128118234734E-6,-3.5983520768527733E-3,1.0172290373836823E-2,6.9426342707937794E-3,-3.9641482299574982E-3,0,0,0,0,0]
[null,46,null,"Adjustment For Prior Year Over / Under Recovery",null,"%","",null,4.7296884678693819E-4,-8.1398179204131733E-3,-8.0106677253133068E-3,-6.0612734232036328E-4,-6.7274381196755713E-5,null,null,null,null,null,null,4.729682000877112E-4,-9.9275068204186002E-3,-6.2505252471442832E-3,7.7478933969089185E-4,0,null,null,null,null,null,null,6.4669922699269258E-10,1.7876889000054269E-3,-1.7601424781690236E-3,-1.380916682011255E-3,-6.7274381196755713E-5,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,null,null,null,null,null,null,null,null,null,null,"note SOQ assumption will be revised later this year"]
[null,48,null,"Year On Year Movement In Aggregate Demand",null,"%",null,null,4.2905850554014469E-3,-5.3698342633298202E-3,-5.9997179771274639E-3,2.7876432510125617E-3,6.1548958105072521E-5,null,null,null,null,null,null,4.2893932892888453E-3,-7.1804974401771804E-3,-5.8321648230293677E-3,2.6244282405354009E-3,2.2041000406713279E-5,null,null,null,null,null,null,1.1917661126015222E-6,1.8106631768473602E-3,-1.6755315409809624E-4,1.6321501047716078E-4,3.9507957698359242E-5,0,0,0,0,0]
[null,49,null,"LDZ & CUSTOMER CHARGES ARITHMETICAL PRICE CHANGE",null,"%",null,null,-0.13679750362423673,0.1541791087696408,7.8892657747482178E-2,7.4215989747168348E-3,8.8989735603745585E-3,null,null,null,null,null,null,-0.13679750362423673,0.1541791087696408,7.0648063005912476E-2,1.6966663754571501E-3,1.2890888213830453E-2,null,null,null,null,null,null,0,0,8.2445947415697024E-3,5.7249325992596847E-3,-3.9919146534558945E-3,0,0,0,0,0]
[]
[null,null,null,"TABLE 6: PASS THROUGH COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,50,null,"Shrinkage","SLt","Nominal",null,null,16.819021371383748,27.427893645687679,21.060922480109287,13.092290738301367,9.5306190115068468,null,null,null,null,null,null,16.306662594167872,19.483430812725569,16.832501222812532,12.43659183933533,8.9534174485545091,null,null,null,null,null,null,0.51235877721587642,7.9444628329621096,4.2284212572967554,0.65569889896603684,0.57720156295233771,0,0,0,0,0,16.595704642793319,20.923569355232797,7.5479731028685437,5.6637154046602243,5.177905730718189,0.22331672859042939,6.5043242904548819,13.512949377240744,7.4285753336411426,4.3527132807886577,null,"data as at end of June - likely to change further"]
[null,51,null,"Licensed Activity","LFt","Nominal",null,null,2.5075519999999996,2.6583150647146367,2.7464277590701944,2.7929634213608803,2.8463223977251122,null,null,null,null,null,null,2.2802519999999999,2.3614949015361235,2.419154855496545,2.4688093236483364,2.5182167153389305,null,null,null,null,null,null,0.22729999999999961,0.29682016317851323,0.32727290357364947,0.32415409771254389,0.32810568238618165,0,0,0,0,0,2.2802519999999999,2.3614949015361235,2.419154855496545,2.4688093236483359,2.5182167153389305,0.22729999999999961,0.29682016317851323,0.32727290357364947,0.32415409771254433,0.32810568238618165,null,"RRP update impact"]
[null,52,null,"Prescribed Rates","RBt","Nominal",null,null,45.639679999999991,45.639679999999991,47.152455978929012,47.951410460933936,48.867512031705616,null,null,null,null,null,null,45.639679999999998,45.639680000000006,47.152455978929027,47.951410460933943,48.867512031705623,null,null,null,null,null,null,-7.1054273576010019E-15,-1.4210854715202004E-14,-1.4210854715202004E-14,-7.1054273576010019E-15,-7.1054273576010019E-15,0,0,0,0,0,45.637859999999996,47.263887371667423,48.41791635901275,49.41172040605926,50.400579367674268,1.8199999999950478E-3,-1.6242073716674312,-1.2654603800837378,-1.4603099451253243,-1.5330673359686529]
[null,53,null,"Pension Scheme Established Deficit Repair","EDEt","Nominal",null,null,5.3246263789999988,5.6447621095285934,16.055618086878177,16.327665592475824,16.639602195643899,null,null,null,null,null,null,5.1068726808450204,5.2888250064508773,15.125140434624768,15.435592162134499,15.744499107934528,null,null,null,null,null,null,0.21775369815497836,0.35593710307771609,0.93047765225340839,0.89207343034132514,0.89510308770937108,0,0,0,0,0,5.1068726808450204,5.2888250064508782,15.125140434624768,15.435592162134499,15.744499107934528,0.21775369815497836,0.3559371030777152,0.93047765225340839,0.89207343034132514,0.89510308770937108,null,"RRP update impact"]
[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,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,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,0,0,0,0,0,0,0,0,0,0]
[null,57,null,"Bad Debt","BDt","Nominal",null,null,null,null,null,null,null,null,null,null,null,null,null,0.16145891333333351,3.3475686900000001,0,0,0,null,null,null,null,null,null,-0.16145891333333351,-3.3475686900000001,0,0,0,0,0,0,0,0,0.16145891333333351,3.3475686900000001,0,0,0,-0.16145891333333351,-3.3475686900000001,0,0,0,null,"Bad debt treatment now different in PCFM - now done via \"K\""]
[null,58,null,"Nts Exit Flat Capacity Costs & Nts Flex Capacity Costs","ECt","Nominal",null,null,42.662999999999997,40.204999999999998,43.505000000000003,44.607999999999997,44.134,null,null,null,null,null,null,42.66292567,40.211049183350674,43.518782795234564,44.622045496838069,44.147457630785162,null,null,null,null,null,null,7.4329999996791685E-5,-6.0491833506759463E-3,-1.3782795234561718E-2,-1.4045496838072324E-2,-1.3457630785161712E-2,0,0,0,0,0,42.66292908220575,45.445897160419086,46.99652569679759,44.238368942788817,45.37039454536523,7.0917794246838639E-5,-5.2408971604190882,-3.4915256967975878,0.36963105721117984,-1.2363945453652292]
[null,59,null,"Cdsp Costs (Xoserve)","CDSPt","Nominal",null,null,3.6044637599999989,3.9369703594108096,2.7515207457870061,2.6764843255629129,2.6036353573356616,null,null,null,null,null,null,3.59016,3.7927933928571429,2.5827171428571427,2.5666896428571433,2.5449380357142855,null,null,null,null,null,null,1.4303759999998888E-2,0.14417696655366674,0.16880360292986341,0.10979468270576964,5.8697321621376197E-2,0,0,0,0,0,3.59016,3.7927933928571429,2.5827171428571427,2.5666896428571433,2.5449380357142855,1.4303759999998888E-2,0.14417696655366674,0.16880360292986341,0.10979468270576964,5.8697321621376197E-2,null,"RRP update impact"]
[null,60,null,"Miscellaneous Costs","MPt","Nominal",null,null,0,95.906397123079998,23.976599280769999,0,0,null,null,null,null,null,null,0,95.906397123080012,23.976599280770003,0,0,null,null,null,null,null,null,0,-1.4210854715202004E-14,-3.5527136788005009E-15,0,0,0,0,0,0,0,0,95.906397119999994,0,0,0,0,3.0800038075540215E-9,23.976599280769999,0,0]
[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,0,0,0,0,0,0,0,0,0,0]
[null,62,null,"TOTAL PASS THROUGH COSTS","PTt","Nominal",null,null,116.55834351038374,221.4190183024217,157.24854433154368,127.44881453863491,124.62169099391714,null,null,null,null,null,null,115.74801185834622,216.0312391100004,151.60735171072457,125.48113892574732,122.77604097003304,null,null,null,null,null,null,0.81033165203751878,5.3877791924213057,5.6411926208191119,1.9676756128875894,1.8456500238841045,0,0,0,0,0,116.03523731917741,224.33043299816342,123.08942759165734,119.78489588214828,121.75653350274543,0.52310619120632396,-2.911414695741712,34.159116739886343,7.6639186564866293,2.8651574911717148]
[]
[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.2070548174037865,1.2275072378847331,1.2509585044470788,null,null,null,null,null,null,1.0526119339395996,1.118876650760557,1.2063792817478678,1.2268202559058428,1.2502583978225545,null,null,null,null,null,null,0,0,6.7553565591871312E-4,6.8698197889038859E-4,7.0010662452424377E-4,0,0,0,0,0,1.0803837514069832,1.118876650760557,1.1461959458936011,1.1697222406083743,1.1931314704574956,-2.7771817467383553E-2,0,6.0858871510185431E-2,5.7784997276358885E-2,5.7827033989583221E-2]
[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,1.3728694438340794E-2,3.5628913618373614E-2,null,null,null,0,0]
[null,65,null,"Actual / Forecast Annual Inflation",null,null,null,null,4.4741803886011677E-2,7.690717720815643E-2,3.3250536375935003E-2,1.6944069304936082E-2,1.9104788826139529E-2,null,null,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,0,4.9386627610448208E-4,1.0446745237979727E-4,0,-4.4408920985006262E-16,0,0,0,0,0,4.0504430498107924E-2,3.5628913618373614E-2,2.4416717530456822E-2,2.0525543471916041E-2,2.001263978442136E-2,4.2373733879037534E-3,4.1278263589782815E-2,8.8338188454781807E-3,-3.5814741669799588E-3,-9.078509582818306E-4]
[null,66,null,"Difference (Drives Cpih True Up)",null,null,null,null,3.1013109447670884E-2,4.1278263589782815E-2,"","","",null,null,null,null,null,null,3.1013109447670884E-2,4.0784397313678333E-2,"","","",null,null,null,null,null,null,0,4.9386627610448208E-4,"","","",0,0,0,0,0,2.677573605976713E-2,0,"","","",4.2373733879037534E-3,4.1278263589782815E-2,"","",""]
[]
[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.5999999999999997E-2]
[null,72,null,null,"73.2 - 732","p/kwh",null,null,2.4799999999999999E-2,2.86E-2,3.09E-2]
[null,73,null,null,">732","multiplyer",null,null,0.318,0.36699999999999999,0.39600000000000002]
[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.22839999999999999]
[null,77,null,null,"73.2 - 732","p/pdkwh/d",null,null,0.15759999999999999,0.18190000000000001,0.1963]
[null,78,null,null,">732","multiplyer",null,null,1.8492,2.1343000000000001,2.3027000000000002]
[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.12189999999999999]
[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.3100000000000002E-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.308100000000003]
[null,86,null,null,"Monthly read supply points",null,null,null,32.756300000000003,37.806600000000003,40.789299999999997]
[]
[]
[null,null,null,"EXIT CHARGES"]
[]
[null,87,null,"Capacity","NE1","p/pdkwh/d",null,null,1.9093157013661103E-2,2.933966746361991E-2,2.0360564174926751E-2]
[null,88,null,"Capacity","NE2","p/pdkwh/d",null,null,2.1533425821170644E-2,3.2999050145039129E-2,7.9552038876331832E-3]
[null,89,null,"Capacity","NE3","p/pdkwh/d",null,null,2.1533425821170644E-2,3.2999050145039129E-2,7.9552038876331832E-3]
[null,90,null,"Capacity","NO1","p/pdkwh/d",null,null,1.9875125306190757E-2,2.99036577656095E-2,2.0751951049094101E-2]
[null,91,null,"Capacity","NO2","p/pdkwh/d",null,null,1.7675857675848269E-2,2.7568841367584619E-2,1.9007446210351022E-2]
[]
[null,null,null,"SOLR CHARGES"]
[]
[null,92,null,"Capacity","0-73.2","p/pdkwh/d",null,null,null,0.09]

{"sheet":"High level rec","index":3,"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 - June to Sept",null,null,null,"21/22","22/23","23/24","24/25","25/26",null,"GD2"]
[]
[null,"Mod186 : June",null,"Calculated revenue",null,430.77845057457296,566.21346879108569,540.09615862541239]
[null,null,null,"AIP adjustment term",null,0,23.336813105498077,5.5667055966060062]
[null,null,null,"Adjusted revenue",null,430.77845057457296,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.24545682307991,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,"Mod186 : Latest Position",null,"Calculated revenue",null,430.74198884868196,562.88853545097368,550.33803715959255,"",""]
[null,null,null,"AIP adjustment term",null,0,23.164462716276546,-0.64710958134810115,"",""]
[null,null,null,"Adjusted revenue",null,430.74198884868196,586.05299816725028,549.69092757824444,531.23732089487794,535.10615249117006,null,2632.829387980225]
[null,null,null,"Legacy Allowed Revenue",null,-13.758309947582799,10.789090515120025,0,0,0]
[null,null,null,"K Correction Factor",null,0.22943219032387699,0.35886770036786669,-2.1446806762986323,0,0]
[null,null,null,"Allowed Revenue",null,417.21311109142306,597.20095638273824,547.54624690194578,531.23732089487794,535.10615249117006,null,2628.3037877621555]
[null,null,null,"Recovered Revenue",null,421.15927115999995,599.3651522776106,547.54624690194566,531.23732089487794,535.1057140091782]
[]
[null,null,null,"Inflation %",null,4.4741803886011677E-2,7.690717720815643E-2,3.3250536375935003E-2,1.6944069304936082E-2,1.9104788826139529E-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.8892657747482178E-2,7.4215989747168348E-3,8.8989735603745585E-3]
[]
[null,"Difference",null,"Calculated revenue",null,-3.6461725891001606E-2,-3.3249333401120111,10.241878534180159,"",""]
[null,null,null,"AIP adjustment term",null,0,-0.17235038922153123,-6.2138151779541069,"",""]
[null,null,null,"Adjusted revenue",null,-3.6461725891001606E-2,-3.4972837293335033,4.0280633562260846,6.3999669521247142,4.5635689805320681,null,11.49431555954925]
[null,null,null,"Legacy Allowed Revenue",null,0,0,0,0,0]
[null,null,null,"K Correction Factor",null,4.1159942341501554E-3,3.9282696320264443,0.54853392187478622,0,0]
[null,null,null,"Allowed Revenue",null,-3.234573165684651E-2,0.43098590269300985,4.5765972781008486,6.3999669521247142,4.5635689805320681,null,15.975235107684966]
[null,null,null,"Recovered Revenue",null,0,-3.7540676330536371E-2,4.5765972781022128,6.3999669521248279,4.5631304985399765]
[]
[null,null,null,"Inflation %",null,0,4.9386627610448208E-4,1.0446745237979727E-4,0,-4.4408920985006262E-16]
[null,null,null,"SOQ % Change",null,0,0,0,0,0]
[null,null,null,"LDZ Price Change",null,0,0,8.2445947415697024E-3,5.7249325992596847E-3,-3.9919146534558945E-3]