{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Intro","Table 1","Table 2","Table 3","Volumes","Volumes Variance"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2901,"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":"Intro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Table 1","index":1,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,16,6,16],[32,0,33,0],[29,0,30,0],[32,16,33,16],[29,16,30,16],[5,0,6,0],[4,2,6,2],[4,1,6,1]]}
["Company Name:","Northern Powergrid (Yorkshire) plc"]
["Date:","August 2022"]
["Title:","DCUSA Schedule 15 - Table 1 information"]
[]
["Description","Licence Term","CRC",null,null,null,null,null,null,null,null,null,null,null,null,null,"Assumptions"]
["Regulatory Year",null,null,"t-8","t-7","t-6","t-5","t-4","t-3","t-2","t-1","t","t+1","t+2","t+3","t+4"]
[null,null,null,"2014/15",{"$f":"LEFT(D7,4)+1&\"/\"&RIGHT(D7,2)+1","v":"2015/16"},{"$f":"LEFT(E7,4)+1&\"/\"&RIGHT(E7,2)+1","v":"2016/17"},{"$f":"LEFT(F7,4)+1&\"/\"&RIGHT(F7,2)+1","v":"2017/18"},"2018/19","2019/20","2020/21","2021/22","2022/23","2023/24","2024/25","2025/26","2026/27"]
["Base Demand Revenue before inflation (A1)","PU","CRC2A",348.5,323.60000000000002,322,322,322,322,322,322,322,310.43402369710748,302.42724053590837,297.64887442359708,294.3670472339212,"PU values are aligned to the Competition & Markets Authority decision to adjust our base revenue, and are in 2012/13 prices. RIIO-ED2 base revenue is aligned to Ofgem's published draft determination converted into 2012/13 prices."]
["Annual Iteration adjustment before inflation (A2)","MOD","CRC2A",0,0,1.2,-2.8,-7.9,-11.9,-8.6,-4.5999999999999996,-12.86,1.7072101635000561,1.7399375436425326,1.7749061518199658,1.7673019622158339,"2016/17 to 2021/22 aligned to the Ofgem directed values, with future years reflecting the assumed impact of the annual iteration process, which is primarily driven by revised cost of debt, legacy revenue and RAV adjustments, totex adjustments and corporation tax changes."]
["RPI True-up before inflation (A3)","TRU","CRC2A",0,0,0,-7.1184018338814683,-1.2680552279999584,0.79936715651983381,-0.33603996691372096,-2.9106159510872947,-4.1894393003883481,8.9899699443541881,13.68126459434022,-9.5794560038886756E-2,-1.8318818530145105E-2,"The RPI true-ups reflect the difference in RPI between forecasts prescribed in the distribution licence (sourced from annual (in November) HM Treasury 'Forecasts for the UK economy: a comparison of independent forecasts' publications) and the actual RPI for the same periods (forecasts being required due to the lag between performance/expenditure and when reflected in allowances, and in order to provide certainty and commonality in DNO assumptions). Figures are expressed in 2012/13 prices.\nThe 2015/16 to 2021/22 true-ups reflected in 2017/18 through to 2023/24 respectively are final and reflect variances between actual and prescribed forecast RPI.\nThe 2022/23 true-up in 2024/25 is primarily driven by 2021/22 actual RPI finalising at 5.78% compared to 2.50% prescribed when nominalising 2022/23 allowed revenue, and the latest forecast for 2022/23 at 8.30% compared to the prescribed 5.38%.\nThe minor variances in subsequent years are due to rounding, where Ofgem specify rounding of RPIF to three decimal places but not RPIA - the two are otherwise aligned."]
["Price index adjustment (A4)","RPIF","CRC2A",1.1671674547056599,1.0820000000000001,1.087,1.121,1.159,1.198,1.2170000000000001,1.238,1.321,1.468,1.4930000000000001,1.5209999999999999,1.5509999999999999,"Inflation is based on an average for the regulatory year t, and derived by applying two years forecast RPI inflation, as prescribed in the distribution licence, using the respective November HM Treasury 'Forecasts for the UK economy: a comparison of independent forecasts' publication, to actual RPI indices from year t-2.\nThe 2015/16 through to 2022/23 indices are final and reflect the relevant November HM Treasury publication forecasts applied to the latest (at the time) actual RPI indices.\nFor ED2 the indexation for the base revenue is based on the hybrid indexation as described in the GD financial hand book, and the indexation for the incentives is the forecast RPI from the latest HM Treasury forecasts. "]
["Base demand revenue (A): \n[A = (A1 + A2 + A3) * A4]","BR","CRC2A",{"$f":"(D8+D9+D10)*D11","v":406.75785796492244},{"$f":"(E8+E9+E10)*E11","v":350.13520000000005},351.3184,349.84347154421886,362.57222399074806,372.45744185351077,380.99883936026595,389.33785745255386,402.83969068418696,{"$f":"(M8+M9+M10)*M11","v":471.42060718568382},{"$f":"(N8+N9+N10)*N11","v":474.54772491211952},{"$f":"(O8+O9+O10)*O11","v":455.27786672939015},{"$f":"(P8+P9+P10)*P11","v":459.27596311566822},"A = (A1 + A2 + A3) * A4"]
["Pass-Through Licence Fees (B1)","LF","CRC2B",-0.15048411544332541,0,0,0.1378570854315517,-0.13899586206862372,0.20594332095977633,0.22122095519493543,0.37001902254610303,0.37381739338327691,0.91398757262665109,0.50712224978897513,0,0,"Based on final up to and including 2021/22 licence fees and then inflation and other known increases going forward.  We currently expect to be broadly in line with allowances in RIIO-ED1.  Any variations in RIIO-ED1 will be recovered/returned with a two-year lag and time value of money adjustment."]
["Pass-Through Business Rates (B2)","RB","CRC2B",-1.8559480491190392,0,0,0.26479843361841932,-0.11636582296843982,-8.0557651036319768,-9.9240835409407886,-9.2537815239961656,-9.7382435004645878,-12.565403160157148,-15.375505560133572,0,0,"Latest business expectations which reflect transitional arrangements for the 2017 business rates revaluation, and which vary to the Ofgem allowances.  Any variations in RIIO-ED1 will be recovered/returned with a two-year lag and time value of money adjustment."]
["Pass-Through Transmission Connection Point Charges (B3)","TB","CRC2B",1.0060037646389546,0,0,-1.7574519093272897E-2,1.006147349774134,0.18178777242690305,0.52251946018174034,0.56224988290093525,0.25576520417762383,-5.5876635755876753,-3.5184282664209787,0,0,"Based on the latest information from NGET and known future schemes, plus any valid interconnector charges.  Any variations in RIIO-ED1 will be recovered/returned with a two-year lag and time value of money adjustment."]
["Pass-through Smart Meter Communication Licence Costs (B4)","SMC","CRC2B",0,0,0,8.4203277586757094E-2,0.85768172312261604,0.90632832228601101,1.5047966049411128,1.9794710301200811,2.660123615264459,3.0136178610200473,3.4410941729549864,0,0,"Represents new RIIO-ED1 pass-through allowances in smart meter Data Communications Company (DCC) costs, and we currently expect to exceed allowances.  Any variations will be recovered/returned with a two-year lag and time value of money adjustment."]
["Pass-through Smart Meter IT Costs (B5)","SMIT","CRC2B",0,0,0,9.2398906754715127E-2,0.6851473327968578,0.10679452193414245,-2.5668868861111544E-2,-0.42330247245967995,-0.24413942439429592,1.2338092104682967,0.67822295851832748,0,0,"Represents new RIIO-ED1 pass-through allowances in smart meter IT costs, in particular relating to non-operational capex in preparation for the smart meter rollout, and the building of the gateway to transfer data from smart meters into our internal systems."]
["Pass-through Ring Fence Costs (B6)","RF","CRC2B",0,0,0,2.9190377782384085E-2,3.2586838682266174E-2,3.3238998712468E-2,3.3227616089909762E-2,3.4118449288153226E-2,3.9868511617759464E-2,4.1324289752962706E-2,4.1539804548517641E-2,0,0,"We currently expect to be in line with allowances included within our base demand revenue."]
["Pass-through Supplier of Last Resort Adjustment (B7)","SLR","CRC2B",0,0,0,0,0,0,0,5.3285573392698328E-2,76.956766742166607,0.9663043111060946,1.6200290067454697,0,0,"Ofgem's decision to modify the licence on 2 May 2019 introduced a pass-through mechanism associated with costs incurred as a result of the appointment of a supplier of last resort (SoLR); primarily representing last resort supply payment (LRSP) claims received from a SoLR. \nA claim totalling £0.2m was received in October 2019 from Together Energy (Retail) Limited, which will be recovered in 2021/22 and 2022/23.\nA claim totalling £15k from Shell Energy Retail Limited was also received in January 2020, and will be recovered in 2022/23.\nA claim totalling £0.5m expected was received in May 2020 from Ovo Energy Limited, which will be recovered in 2022/23 and 2023/24. \nA claim totalling £30k from Ovo Energy Limited, was received in October 2020, which will be recovered in 2022/23 and 2023/24.\nA claim totalling £0.4m from Scottish Power Energy Retail Energy was received in February 2021, which will be recovered in 2022/23 and 2023/24.\nA claim totalling £0.2m from EDF Energy Limited, was received in May 2021, which will be recovered in 2022/23 and 2023/24.\nClaims totalling £77.8m from various suppliers were received in December 2021. Claims under the materiality threshold will be recovered in 2023/24 and 2024/25. Claims over the materiality threshold will be recovered in 2022/23, via change in tariffs published in January 2022."]
["Pass-through Eligible Bad Debt Adjustment (B8)","EBD","CRC2B",0,0,0,0,0,0,0,1.2878601564901597,0.4037580588751023,1.2390443495565713,3.6876205862709961,0,0,"Ofgem's decision to modify the licence on 2 May 2019 introduced a pass-through mechanism associated with use of system bad debt incurred since 1 April 2015.  In June 2019 we claimed for such debt incurred between 1 April 2015 and 31 March 2019 totalling £1.1m (excluding any time value of money adjustments), which will be recovered in 2021/22.  In June 2020 we claimed for debt incurred between 1 April 2019 and 31 March 2020 totalling £0.3m (excluding any time value of money adjustments), which will be recovered in 2022/23. In June 2021 we claimed for debt incurred between 1 April 2020 and 31 March 2021 totalling £0.9m (excluding any time value of money adjustments), which will be recovered in 2022/23. In June 2022 we claimed for debt incurred between 1 April 2021 and 31 March 2022 totalling £3.0m, which will be recovered in 2024/25. "]
["Pass-through COVID-19 Bad Debt Adjustment (B9)","CBD","CRC2B",0,0,0,0,0,0,0,9.4237941206323464E-2,0,0,0,0,0,"Ofgem's decision to modify the licence on 20 November 2020 introduced a new pass-through mechanism associated with bad debt incurred through the Network Charge Deferral (NCD) scheme - which finalised at £0.1m and will impact 2021/22 (although we did not revise charges for 2021/22 so will not recover until 2023/24)"]
["Pass-Through Others (B10)","HB, SEC, UNC","CRC2B",0,0,0,0,0,0,0,0,0,0,0,0,0,"Not applicable to this licence area."]
["Allowed Pass-Through Items (B):\n[B = B1 + B2 + B3 + B4 + B5 + B6 + B7 + B8 + B9 + B10]","PT","CRC2B",{"$f":"SUM(D13:D22)","v":-1.0004283999234103},0,{"$f":"SUM(F13:F22)","v":0},0.59087356208055442,2.3262015593388106,-6.6216721673126759,-7.6679877733942012,-5.2958419405113908,70.707716600625943,{"$f":"SUM(M13:M22)","v":-10.7449791412142},-8.9183050477272801,{"$f":"SUM(O13:O22)","v":0},0,"B = B1 + B2 + B3 + B4 + B5 + B6 + B7 + B8 + B9"]
["Broad Measure of Customer Service incentive (C1)","BM","CRC2C",-0.32637018844335525,-1.124693400583354,-0.93216531468781072,1.5852435373060449,2.6430478740438859,2.8779822976011622,3.1370426898451562,3.9580622809817982,3.8468038549095764,1.1961683176244757,5.5327766416675273,0,0,"This incentive operates with a two year lag.  2015/16 and 2016/17 allowances include a penalty relating to customer service broader measure from 2013/14 and 2014/15 respectively, offset by stakeholder engagement discretionary rewards of £0.5m in both years.\nThis forecast includes the 2017/18 through to 2023/24 rewards associated with 2015/16 to 2021/22 actual performance respectively.\nIncluded in 2015/16 and 2016/17 is £0.8m for the Stakeholder Engagement and Consumer Vulnerability (SECV) discretionary reward. The rewards in 2017/18, 2018/19, 2019/20 and 2020/21 were £1.1m, £1.0m, £0.9m and £0.3m respectively. The 2021/22 reward has been aligned to the indicative scores giving no reward. Thereafter it is assumed that annual SECV rewards are in line with 2018/19.\nWe continue to assume we will achieve BMCS rewards throughout the RIIO-ED1 period, primarily due to supply interruptions and general enquiries performance with improving connections scores.  As a result our customers will receive improved customer service in return."]
["Quality of Service incentive (C2)","IQ","CRC2D",6.2170155595127961,9.1318670151695471,13.844560363984531,15.780877386240121,16.803293561486324,17.26117198360604,17.544324930362173,15.285068123440894,15.94814882921589,12.677875064939544,19.9080143531856,0,0,"This incentive operates with a two year lag.  During DPCR5 we managed to better the targets that were set at the beginning of the price control period, for both customer interruptions and customer minutes lost, and this forecast includes the final 2014/15 to 2021/22 performance figures which impact 2016/17 through to 2023/24 allowances respectively. The 2021/22 performance is subject to change relating to weather exemptions to be agreed with Ofgem.\nWe assume the IIS outperformance will continue throughout RIIO-ED1 albeit at a lower level (in real terms), where rewards reduce due to tightened targets as a result of the improved planned fault restoration performance which our customers will receive."]
["Connections Engagement incentive (C3)","ICE","CRC2E",-13.562773304674515,0,0,0,0,0,0,0,0,0,0,0,0,"Ofgem has confirmed no penalty will be applied relating to connections engagement in RIIO-ED1 to date, and we currently expect to be neutral to this penalty only incentive mechanism going forward."]
["Time to Connect incentive (C4)","TTC","CRC2F",0,0,0,0.7377767790433406,0.64982200878716667,7.0672170021457245E-2,0.40850541493818365,0.11979551246727969,0,0,1.6469318112402167,0,0,"This forecast includes the 2017/18 through to 2023/24 rewards associated with 2015/16 to 2021/22 actual performance respectively. Annual incremental rewards are assumed thereafter driven by connections improvement initiatives and which are calculated based on revised targets and incentive rates as per Ofgem's 31 July 2019 direction."]
["Losses Discretionary Reward incentive (C5)","LDR","CRC2G",0,0,0,0.19617499999999999,0,0,0,0,0,0,0,0,0,"This incentive was introduced to encourage and incentivise DNOs to undertake additional actions to better understand and manage electrical losses.\nOn 28 July 2016, Ofgem published its decision on the first tranche of losses discretionary rewards, with Northern Powergrid receiving £350k (2012/13 prices), to be split evenly across both licence areas, and impacting allowances in 2017/18.\nOn 11 September 2018, Ofgem published its decision on the second tranche of losses discretionary rewards, with no awards made.\nOn 14 September 2020, Ofgem published its decision on the third tranche of losses discretionary rewards, with no awards made."]
["Network Innovation Allowance (C6)","NIA","CRC2H",0.56913360000000002,0.73822394229707533,0.70427741300225,2.0979214020467616,2.1707300613004969,2.1020787332066373,2.2218470296678587,0.87245779299120607,2.3296836781226729,0,0,0,0,"This allowances replaces the Innovation Funding Incentive operating in DPCR5, and includes actual eligible expenditure up to and including 2021/22.\nWe have included an estimate of the costs associated with the Network Innovation Allowance (NIA) in 2022/23, which assumes we continue to broadly spend to our allowances. We have not included any NIA costs in RIIO-ED2."]
["Low Carbon Networks Fund (C7)","LCN1","CRC2J",5.8013000000000002E-2,0,0,0,0,0,0,0,0,0,0,0,0,"The LCN funding in the eighth year of the RIIO-ED1 period (2022/23) has now been drafted by Ofgem and has been reflected in this forecast. Ofgem have drafted that none of the available funding for the 2022/23 second tier reward should be made, and that licensees should return £3.3m to customers due to revenue that has not been spent, resulting in a net position of (-)£3.3m."]
[null,"LCN2","CRC2J",2.0197220400000018,1.58060117,8.3856570000000005E-2,0.24265197999999999,0.65832199000000002,8.9907860000000006E-2,-0.24241409999999999,5.3594280000000001E-2,-0.25154489000000002,0,0,0,0]
["Connection Guaranteed Standards Systems & Processes penalty (C8)","AUM, CGSRA","CRC2K-L",0,0,0,0,0,0,0,0,0,0,0,0,0,"We currently expect to be neutral to this incentive mechanism."]
["Residual Losses and Growth incentive (C9)","PPL","CRC2M",0,-10.991663877009817,-11.211497154550013,-7.5166364663786416,0,0,0,0,0,0,0,0,0,"Aligned to Ofgem's final decision regarding the close-out of the DPCR4 losses scheme announced in March 2014.  We have set the DPCR5 incentive mechanism to zero, in line with Ofgem’s decision not to activate it (Ofgem document ref:149/12).\nThis has been updated to reflect Ofgem's decision in May 2015 to modify the special conditions of the RIIO‐ED1 licence for the growth term which operated under DPCR4, whereby DNOs were rewarded for increasing electricity units distributed.  This incentive used common data to the losses incentive, therefore the restatement of data led to a recalculation of the growth term."]
[null,"GTA","CRC2M",0,0,-0.58698000000000006,0,0,0,0,0,0,0,0,0,0]
["Incentive Revenue and Other Adjustments (C):\n[C = C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9]",null,null,{"$f":"SUM(D24:D34)","v":-5.0252592936050728},-0.66566515012654826,{"$f":"SUM(F24:F34)","v":1.9020518777489568},13.124009618257627,22.925215495617874,22.401813044435297,23.06930596481337,20.288977989881179,21.873091472248138,{"$f":"SUM(M24:M34)","v":13.87404338256402},27.087722806093346,{"$f":"SUM(O24:O34)","v":0},0,"C = C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9"]
["Correction Factor (D)","-K","CRC2A",27.608478226066115,13.587624000000002,12.665139947409369,0.6775375118742093,-3.1135401776653335,1.7706228085388811,8.2260012650077101,5.4950869304840229,19.064351946022519,6.4540766941381111E-2,42.657231134791843,2.3419488570652903E-13,-2.927436071331613E-13,"With tariffs now set up to and including 2022/23 we will see any variations in actual revenue performance and any variation in allowed revenue assumptions in the intervening periods as adjustments in 2022/23 (driven by changes in 2020/21), 2023/24 (driven by changes in 2021/22 and 2022/23). It is expected that the licence conditions for RIIO-ED2 will transition from two year to a one year lag on correction factor, which is achieved by including two years' of corrections in 2023/24."]
["Total allowed Revenue (E):\n[E = A + B + C + D]","AR","CRC2A",{"$f":"SUM(D12,D23,D35:D36)","v":428.34064849746005},{"$f":"SUM(E12,E23,E35:E36)","v":363.05715884987353},365.88559182515831,364.23589223643125,384.71010086803938,390.00820553917225,404.62615881669285,409.82608043240771,514.48485070308357,{"$f":"SUM(M12,M23,M35:M36)","v":474.61421219397505},535.3743738052774,{"$f":"SUM(O12,O23,O35:O36)","v":455.27786672939038},459.27596311566793,"E = A + B + C + D"]
["Other 1. Excluded services - Top-up, standby, and enhanced system security (F1) (see note 1)","DRS4","CRC5C",1.1507251900000002,0,0,0,0,0,0,0,0,0,0,0,0]
["Other 2. Excluded services - Revenue protection services (F2) (see note 1)","DRS5","CRC5C",0.35574135999999995,0.35834878999999997,0,0,0,0,0,0,0,0,0,0,0]
["Other 3. Excluded services - Miscellaneous (F3) (see note 1)","DRS9","CRC5C",8.8199999999999834E-2,0,0,0,0,0,0,0,0,0,0,0,0]
["Other 4. blank or if required please provide description (F4)"]
["Other 5. blank or if required please provide description (F5)"]
["Total other revenue recovered by Use of System Charges (F):\n[F = F1 + F2 + F3 + F4 + F5]",null,null,{"$f":"SUM(D38:D42)","v":1.5946665499999999},{"$f":"SUM(E38:E42)","v":0.35834878999999997},{"$f":"SUM(F38:F42)","v":0},0,0,0,0,0,0,{"$f":"SUM(M38:M42)","v":0},0,{"$f":"SUM(O38:O42)","v":0},0,"F = F1 + F2 + F3 + F4 + F5"]
["Total Revenue for Use of System Charges (G):\n[G = E + F]",null,null,{"$f":"D37+D43","v":429.93531504746005},{"$f":"E37+E43","v":363.41550763987351},{"$f":"F37+F43","v":365.88559182515831},364.23589223643125,384.71010086803938,390.00820553917225,404.62615881669285,409.82608043240771,514.48485070308357,{"$f":"M37+M43","v":474.61421219397505},535.3743738052774,{"$f":"O37+O43","v":455.27786672939038},459.27596311566793,"G = E + F"]
["1. Revenue raised outside CDCM - EDCM and Certain Interconnector Revenue (H1)",null,null,10.966413818019003,9.7615142589819985,9.1942119867949952,10.063564689776003,11.854894775249999,10.966589752239999,11.554605676033001,12.599835893611001,13.260559767640411,12.493645336383377,13.800323985642457,12.106294732902457,12.35878541171059,"This reflects EDCM demand and generation revenue plus wheeled-unit inter-connector revenue."]
["2. Revenue raised outside CDCM - Voluntary under-recovery (H2)"]
["3. Revenue raised outside CDCM - blank or if required please provide description (H3)",null,null,{"$f":"D39","v":0.35574135999999995},{"$f":"E39","v":0.35834878999999997},{"$f":"F39","v":0},{"$f":"G39","v":0},0,0,0,0,0,{"$f":"M39","v":0},0,{"$f":"O39","v":0},0]
["4. Revenue raised outside CDCM - blank or if required please provide description (H4)",null,null,null,{"$f":"E36","v":13.587624000000002},0,0,0,0,0,0,0,0,0,0,0]
["Total Revenue to be raised outside the CDCM (H):\n[H = H1 + H2 + H3 + H4]",null,null,{"$f":"SUM(D45:D48)","v":11.322155178019003},{"$f":"SUM(E45:E48)","v":23.707487048981999},{"$f":"SUM(F45:F48)","v":9.1942119867949952},{"$f":"SUM(G45:G48)","v":10.063564689776003},{"$f":"SUM(H45:H48)","v":11.854894775249999},{"$f":"SUM(I45:I48)","v":10.966589752239999},11.554605676033001,12.599835893611001,13.260559767640411,12.493645336383377,13.800323985642457,{"$f":"SUM(O45:O48)","v":12.106294732902457},12.35878541171059,"H = H1 + H2 + H3 + H4"]
["Latest forecast of CDCM Revenue (I):\n[I = G - H]",null,null,{"$f":"D44-D49","v":418.61315986944106},{"$f":"E44-E49","v":339.70802059089152},{"$f":"F44-F49","v":356.69137983836333},{"$f":"G44-G49","v":354.17232754665525},{"$f":"H44-H49","v":372.85520609278939},379.04161578693225,{"$f":"J44-J49","v":393.07155314065983},397.22624453879672,501.22429093544315,462.12056685759165,521.57404981963498,443.1715719964879,{"$f":"P44-P49","v":446.91717770395735},"I = G - H"]
["CDCM Revenue Used in Charging Model",null,null,401.3,341.4,357.7,351.2,371.8,382.4,395.7,402.5,500.4,421.2,{"$f":"N50","v":521.57404981963498},{"$f":"O50","v":443.1715719964879},{"$f":"P50","v":446.91717770395735}]
["Final Collected Revenue Forecast (J)",null,null,404.63667792000007,362.76322852000004,368.88739396,362.53432938000003,376.83303244799998,384.71690965999994,386.17439844,413.58463252000001,510.59970436058569,432.48361354232878,535.37437380527706,455.27786672939067,459.27596311566839]
["Forecast Over / (Under) Recovery\n[being (J - F - E + H2)]",null,null,{"$f":"D52-D43-D37+D46","v":-25.298637127459983},{"$f":"E52-E43-E37+E46","v":-0.65227911987346943},{"$f":"F52-F43-F37+F46","v":3.0018021348416823},-1.7015628564312237,-7.877068420039393,-5.2912958791723099,-18.451760376692846,3.7585520875923066,-3.885146342497876,{"$f":"M52-M43-M37+M46","v":-42.130598651646267},-3.4106051316484809E-13,{"$f":"O52-O43-O37+O46","v":2.8421709430404007E-13},4.5474735088646412E-13,"J - F - E + H2"]
["Forecast overall percentage change to Allowed Revenue (K)",null,null,null,{"$f":"IFERROR(E37/D37-1,0)","v":-0.15241021340512262},{"$f":"IFERROR(F37/E37-1,0)","v":7.7905996517049214E-3},{"$f":"IFERROR(G37/F37-1,0)","v":-4.5087853295829872E-3},5.6211397800187024E-2,1.3771680699774969E-2,3.7481142883421636E-2,1.2851175096839418E-2,0.25537362131821961,-7.7496234251838825E-2,0.12802010569896227,-0.14960840674271636,8.7816620979159765E-3,"Et  / Et-1"]
["Overall % change to Use of System Charges effective 1st April of Regulatory Year to balance (L)",null,null,0.11,-9.6000000000000002E-2,5.6000000000000001E-2,-8.9999999999999993E-3,5.2999999999999999E-2,2.9000000000000001E-2,4.2999999999999997E-2,4.5999999999999999E-2,0.2680310997687731,-0.15795897520001778,0.23824387881824372,-0.1496084067427158,8.7816620979153104E-3,"The movement in tariffs is broadly in line with the movement in allowances.  The movements up to and including 2023/24 represent the overall change in revenue to be recovered from final use of system tariffs, compared to the revenue that would be yielded from the previous year tariffs.  The illustrative price changes from 2024/25 represents the average revenue change on previous year prices to ensure total allowed distribution network revenue is recovered in the period."]
["Note 1: Cost categories associated with excluded services should only be populated if the Company recovers the costs of providing these services from Use of System Charges"]

{"sheet":"Table 2","index":2,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,1,29,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[30,1,30,9],[28,1,28,9],[4,1,4,3],[4,4,4,6],[4,7,4,9],[5,1,5,3],[5,4,5,6],[5,7,5,9],[20,1,20,9],[21,1,21,9],[22,1,22,9],[23,1,23,9],[24,1,24,9]]}
["Company Name:",{"$f":"'Table 1'!B1","v":"Northern Powergrid (Yorkshire) plc"}]
["Date:",{"$f":"'Table 1'!B2","v":"August 2022"}]
["Title:","DCUSA Schedule 15 - Table 2 information"]
[]
["Description",{"$f":"INDIRECT(\"'Table 1'!\"&ADDRESS(ROW('Table 1'!$A$7),MATCH(\"t\",'Table 1'!$A$6:$Q$6,0)))","v":"2022/23"},null,null,{"$f":"LEFT(B5,4)+1&\"/\"&RIGHT(B5,2)+1","v":"2023/24"},null,null,{"$f":"LEFT(E5,4)+1&\"/\"&RIGHT(E5,2)+1","v":"2024/25"}]
["Regulatory Year","Regulatory Year t",null,null,"Regulatory Year t+1",null,null,"Regulatory Year t+2"]
["£m","Low","Central","High","Low","Central","High","Low","Central","High"]
["Under/over recovery",-10.501663025216594,{"$f":"SUMIF('Table 1'!$7:$7,B$5,'Table 1'!$53:$53)","v":-3.885146342497876},2.7313703402208409]
["RPI True-up",null,null,null,{"$f":"F9","v":8.9899699443541881},{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$10:$10)","v":8.9899699443541881},{"$f":"F9","v":8.9899699443541881},1.1155079916079325,{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$10:$10)","v":13.68126459434022},20.77490740960938]
["Annual Iteration",null,null,null,{"$f":"F10-1","v":0.70721016350005605},{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$9:$9)","v":1.7072101635000561},{"$f":"F10+1","v":2.7072101635000561},{"$f":"I10-1","v":0.73993754364253261},{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$9:$9)","v":1.7399375436425326},{"$f":"I10+1","v":2.7399375436425326}]
["Broad Measure of Customer Service",null,null,null,{"$f":"F11","v":1.1961683176244757},{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$24:$24)","v":1.1961683176244757},1.1961683176244757,3.9615848680903278,{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$24:$24)","v":5.5327766416675273},6.8593649273526198]
["Quality of Service",null,null,null,{"$f":"F12","v":12.677875064939544},{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$25:$25)","v":12.677875064939544},12.677875064939544,{"$f":"I12","v":19.9080143531856},{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$25:$25)","v":19.9080143531856},21.580057528779601]
["Incentive on Connections Engagement",null,null,null,0,{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$26:$26)","v":0},0,-0.12478062736282824,{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$26:$26)","v":0},{"$f":"I13","v":0}]
["Time to Connect",null,null,null,7.9991164606110388E-2,{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$27:$27)","v":0},{"$f":"F14","v":0},0,{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$27:$27)","v":1.6469318112402167},{"$f":"I14","v":1.6469318112402167}]
["Low Carbon Network Fund",null,null,null,{"$f":"'Table 1'!L31","v":-0.25154489000000002},{"$f":"SUMPRODUCT(('Table 1'!$D$7:$L$7=E$5)*'Table 1'!$D$30:$L$31)","v":0},{"$f":"F15","v":0},{"$f":"E15","v":-0.25154489000000002},{"$f":"SUMPRODUCT(('Table 1'!$D$7:$L$7=H$5)*'Table 1'!$D$30:$L$31)","v":0},{"$f":"I15","v":0}]
["Energy Bills Support Scheme",null,null,null,0,0,88.019199999999998,0,0,88.019199999999998]
["Supplier of Last Resort",null,null,null,0,0,21.190045999999999,0,0,0]
["Final Collected Revenue Forecast",null,null,null,418.04102716881982,{"$f":"SUMIF('Table 1'!$7:$7,E$5,'Table 1'!$52:$52)","v":432.48361354232878},446.92619991583774,520.95649522248459,{"$f":"SUMIF('Table 1'!$7:$7,H$5,'Table 1'!$52:$52)","v":535.37437380527706},549.79225238806953]
[]
["Description","Comments (Note: central case is as per the forecasts presented)"]
["Under/over recovery","Our central forecast is based on typical winter weather patterns based on three-year average temperatures.  The high and low scenarios represent a ± 3°C variation in each remaining month of the regulatory year, with demand in winter months being particularly sensitive to temperature fluctuations."]
["RPI True-up","2021/22 true-up in 2023/24 is final.\nThe high and low scenarios in 2024/25 are based on the highest (2022 11.20%, 2023 9.60%) and lowest (2022 4.50%, 2023 3.40%) forecasts from the May 2022 HM Treasury 'Forecasts for the UK economy: a comparison of independent forecasts' publication. \nNote: these values are in 2012/13 prices."]
["Annual Iteration","The high and low scenarios in 2022/23 reflect what we believe could be a typical variance of ±£1m from the central forecast.\nNote: these values are in 2012/13 prices."]
["Broad Measure of Customer Service","2023/24 relates to 2021/22 performance and is based on actual customer satisfaction scores.\nThe low scenario in 2024/25 assumes customer satisfaction scores do not improve between 2021/22 and 2022/23 and no SECV discretionary reward is achieved. The high scenario assumes that we achieve our customer satisfaction performance target plus receive maximum discretionary reward available in real terms (i.e. £1.1m, an additional £0.6m in real terms)."]
["Quality of Service","2023/24 relates to actual 2021/22 performance and is final subject to weather exemptions.\nFor 2024/25, the low scenario is aligned to the central scenario forecast. The high scenario assumes we achieve the maximum reward available."]
["Incentive on Connections Engagement","This incentive is penalty only and operates with a three-year lag. Ofgem has confirmed that there will be no penalty in 2020/21 or 2021/22.\nThe maximum penalty associated with this incentive is £2.8m in 2012/13 prices."]
["Time to Connect","This incentive is reward only. 2023/24 relates to 2021/22 performance and is based on actual performance.\nIn 2024/25, relating to 2022/23 performance, the low and central scenarios assume we achieve no rewards from this incentive, and the high scenario assumes we achieve maximum time to quote reward (based on revised targets and incentive rates as per Ofgem's 31 July 2019 direction)."]
["Low Carbon Network Fund","The amounts recoverable via DUoS could fall within a range of possible outcomes.  The central scenarios represents the ordinary discretionary reward funding element only, and at present we consider the central and high scenario to be aligned, with the low scenario representing the negative funding seen in 2020/21."]
[{"$f":"A16","v":"Energy Bills Support Scheme"},"It is the current BEIS policy intent that the Energy Bills Support Scheme grant of £200 per domestic customer is recovered from domestic customer fixed charges over the five year period commencing 1 April 2023. The high case forecasts (£88.0m in 2023/24 and 2024/25) is based on the current number of domestic customers. "]
[{"$f":"A17","v":"Supplier of Last Resort"},"The high case forecasts (£21.2m in 2023/24) that have been included in respect of SoLR claims is based on figures provided by Ofgem based on claims that they received in December 2021. Whilst we have included these preliminary SoLR forecasts as sensitivities, we await formal direction from Ofgem in relation to any SoLR claims impacting allowed revenue in 2023/24."]
["Final Collected Revenue Forecast","The high and low scenarios represent a ± 3°C temperature variation and a ± 1.5% change in underlying customer demand relative to prior year in each month of the regulatory year. These movements are equivalent to a ~£15m change in revenue and therefore over/under-recovery with use of system charges published up to and including 2023/24."]

{"sheet":"Table 3","index":3,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[[4,0,4,8],[4,10,4,18],[4,20,4,28]]}
["Company Name:",{"$f":"'Table 1'!B1","v":"Northern Powergrid (Yorkshire) plc"},null,null,null,null,null,null,null,null,"Company Name:",{"$f":"B1","v":"Northern Powergrid (Yorkshire) plc"},null,null,null,null,null,null,null,null,"Company Name:",{"$f":"L1","v":"Northern Powergrid (Yorkshire) plc"}]
["Date:",{"$f":"'Table 1'!B2","v":"August 2022"},null,null,null,null,null,null,null,null,"Date:",{"$f":"B2","v":"August 2022"},null,null,null,null,null,null,null,null,"Date:",{"$f":"L2","v":"August 2022"}]
["Title:","DCUSA Schedule 15 - Table 3 information",null,null,null,null,null,null,null,null,"Title:",{"$f":"B3","v":"DCUSA Schedule 15 - Table 3 information"},null,null,null,null,null,null,null,null,"Title:",{"$f":"L3","v":"DCUSA Schedule 15 - Table 3 information"}]
["Illustrative Charging Year:",{"$f":"'Table 2'!$H$5&\" (t+2)\"","v":"2024/25 (t+2)"},null,null,null,null,null,null,null,null,"Illustrative Charging Year:",{"$f":"LEFT(B4,4)+1&\"/\"&MID(B4,6,2)+1&\" (\"&INDIRECT(\"'Table 1'!\"&ADDRESS(6,MATCH(LEFT(B4,4)+1&\"/\"&MID(B4,6,2)+1,'Table 1'!$7:$7,0)))&\")\"","v":"2025/26 (t+3)"},null,null,null,null,null,null,null,null,"Illustrative Charging Year:",{"$f":"LEFT(L4,4)+1&\"/\"&MID(L4,6,2)+1&\" (\"&INDIRECT(\"'Table 1'!\"&ADDRESS(6,MATCH(LEFT(L4,4)+1&\"/\"&MID(L4,6,2)+1,'Table 1'!$7:$7,0)))&\")\"","v":"2026/27 (t+4)"}]
["PLEASE NOTE THAT THESE ARE ILLUSTRATIVE TARIFFS ONLY AND ARE NOT TO BE CONSIDERED TO REPRESENT THE FINAL TARIFFS WHICH WILL BE APPLIED BY THIS COMPANY",null,null,null,null,null,null,null,null,null,"PLEASE NOTE THAT THESE ARE ILLUSTRATIVE TARIFFS ONLY AND ARE NOT TO BE CONSIDERED TO REPRESENT THE FINAL TARIFFS WHICH WILL BE APPLIED BY THIS COMPANY",null,null,null,null,null,null,null,null,null,"PLEASE NOTE THAT THESE ARE ILLUSTRATIVE TARIFFS ONLY AND ARE NOT TO BE CONSIDERED TO REPRESENT THE FINAL TARIFFS WHICH WILL BE APPLIED BY THIS COMPANY"]
["."]
[null,"PCs","Unit rate 1 p/kWh","Unit rate 2 p/kWh","Unit rate 3 p/kWh","Fixed charge p/MPAN/day","Capacity charge p/kVA/day","Exceeded capacity charge p/kVA/day","Reactive power charge p/kVArh",null,null,"PCs","Unit rate 1 p/kWh","Unit rate 2 p/kWh","Unit rate 3 p/kWh","Fixed charge p/MPAN/day","Capacity charge p/kVA/day","Exceeded capacity charge p/kVA/day","Reactive power charge p/kVArh",null,null,"PCs","Unit rate 1 p/kWh","Unit rate 2 p/kWh","Unit rate 3 p/kWh","Fixed charge p/MPAN/day","Capacity charge p/kVA/day","Exceeded capacity charge p/kVA/day","Reactive power charge p/kVArh"]
["Domestic Aggregated with Residual","0, 1 or 2",4.1520000000000001,1.1160000000000001,0.161,21.48,0,0,0,null,"Domestic Aggregated with Residual","0, 1 or 2",4.1760000000000002,1.1220000000000001,0.16200000000000001,17.23,0,0,0,null,"Domestic Aggregated with Residual","0, 1 or 2",4.2359999999999998,1.137,0.16300000000000001,17.309999999999999,0,0,0]
["Domestic Aggregated (Related MPAN)",2,4.1520000000000001,1.1160000000000001,0.161,0,0,0,0,null,"Domestic Aggregated (Related MPAN)",2,4.1760000000000002,1.1220000000000001,0.16200000000000001,0,0,0,0,null,"Domestic Aggregated (Related MPAN)",2,4.2359999999999998,1.137,0.16300000000000001,0,0,0,0]
["Non-Domestic Aggregated No Residual","3, 4 or 5-8",4.6529999999999996,1.25,0.18099999999999999,7.41,0,0,0,null,"Non-Domestic Aggregated No Residual","3, 4 or 5-8",4.68,1.2569999999999999,0.18099999999999999,6.99,0,0,0,null,"Non-Domestic Aggregated No Residual","3, 4 or 5-8",4.7469999999999999,1.274,0.183,6.99,0,0,0]
["Non-Domestic Aggregated Band 1","3, 4 or 5-8",4.6529999999999996,1.25,0.18099999999999999,13.94,0,0,0,null,"Non-Domestic Aggregated Band 1","3, 4 or 5-8",4.68,1.2569999999999999,0.18099999999999999,11.86,0,0,0,null,"Non-Domestic Aggregated Band 1","3, 4 or 5-8",4.7469999999999999,1.274,0.183,11.9,0,0,0]
["Non-Domestic Aggregated Band 2","3, 4 or 5-8",4.6529999999999996,1.25,0.18099999999999999,40.25,0,0,0,null,"Non-Domestic Aggregated Band 2","3, 4 or 5-8",4.68,1.2569999999999999,0.18099999999999999,31.48,0,0,0,null,"Non-Domestic Aggregated Band 2","3, 4 or 5-8",4.7469999999999999,1.274,0.183,31.66,0,0,0]
["Non-Domestic Aggregated Band 3","3, 4 or 5-8",4.6529999999999996,1.25,0.18099999999999999,89.39,0,0,0,null,"Non-Domestic Aggregated Band 3","3, 4 or 5-8",4.68,1.2569999999999999,0.18099999999999999,68.150000000000006,0,0,0,null,"Non-Domestic Aggregated Band 3","3, 4 or 5-8",4.7469999999999999,1.274,0.183,68.59,0,0,0]
["Non-Domestic Aggregated Band 4","3, 4 or 5-8",4.6529999999999996,1.25,0.18099999999999999,265.42,0,0,0,null,"Non-Domestic Aggregated Band 4","3, 4 or 5-8",4.68,1.2569999999999999,0.18099999999999999,199.46,0,0,0,null,"Non-Domestic Aggregated Band 4","3, 4 or 5-8",4.7469999999999999,1.274,0.183,200.86,0,0,0]
["Non-Domestic Aggregated (Related MPAN)",4,4.6529999999999996,1.25,0.18099999999999999,0,0,0,0,null,"Non-Domestic Aggregated (Related MPAN)",4,4.68,1.2569999999999999,0.18099999999999999,0,0,0,0,null,"Non-Domestic Aggregated (Related MPAN)",4,4.7469999999999999,1.274,0.183,0,0,0,0]
["LV Site Specific No Residual",0,3.4740000000000002,0.92600000000000005,0.13400000000000001,15.39,1.38,2.89,0.10100000000000001,null,"LV Site Specific No Residual",0,3.4969999999999999,0.93200000000000005,0.13400000000000001,14.97,1.38,2.89,0.10199999999999999,null,"LV Site Specific No Residual",0,3.552,0.94599999999999995,0.13600000000000001,14.97,1.38,2.89,0.10299999999999999]
["LV Site Specific Band 1",0,3.4740000000000002,0.92600000000000005,0.13400000000000001,404.29,1.38,2.89,0.10100000000000001,null,"LV Site Specific Band 1",0,3.4969999999999999,0.93200000000000005,0.13400000000000001,305.08,1.38,2.89,0.10199999999999999,null,"LV Site Specific Band 1",0,3.552,0.94599999999999995,0.13600000000000001,307.2,1.38,2.89,0.10299999999999999]
["LV Site Specific Band 2",0,3.4740000000000002,0.92600000000000005,0.13400000000000001,808.51,1.38,2.89,0.10100000000000001,null,"LV Site Specific Band 2",0,3.4969999999999999,0.93200000000000005,0.13400000000000001,606.63,1.38,2.89,0.10199999999999999,null,"LV Site Specific Band 2",0,3.552,0.94599999999999995,0.13600000000000001,610.92999999999995,1.38,2.89,0.10299999999999999]
["LV Site Specific Band 3",0,3.4740000000000002,0.92600000000000005,0.13400000000000001,1275.1500000000001,1.38,2.89,0.10100000000000001,null,"LV Site Specific Band 3",0,3.4969999999999999,0.93200000000000005,0.13400000000000001,954.74,1.38,2.89,0.10199999999999999,null,"LV Site Specific Band 3",0,3.552,0.94599999999999995,0.13600000000000001,961.58,1.38,2.89,0.10299999999999999]
["LV Site Specific Band 4",0,3.4740000000000002,0.92600000000000005,0.13400000000000001,2496.61,1.38,2.89,0.10100000000000001,null,"LV Site Specific Band 4",0,3.4969999999999999,0.93200000000000005,0.13400000000000001,1865.93,1.38,2.89,0.10199999999999999,null,"LV Site Specific Band 4",0,3.552,0.94599999999999995,0.13600000000000001,1879.4,1.38,2.89,0.10299999999999999]
["LV Sub Site Specific No Residual",0,2.3540000000000001,0.61499999999999999,8.8999999999999996E-2,15.39,1.56,2.42,6.4000000000000001E-2,null,"LV Sub Site Specific No Residual",0,2.3740000000000001,0.62,0.09,14.97,1.56,2.42,6.5000000000000002E-2,null,"LV Sub Site Specific No Residual",0,2.4209999999999998,0.63200000000000001,9.0999999999999998E-2,14.97,1.56,2.42,6.6000000000000003E-2]
["LV Sub Site Specific Band 1",0,2.3540000000000001,0.61499999999999999,8.8999999999999996E-2,404.29,1.56,2.42,6.4000000000000001E-2,null,"LV Sub Site Specific Band 1",0,2.3740000000000001,0.62,0.09,305.08,1.56,2.42,6.5000000000000002E-2,null,"LV Sub Site Specific Band 1",0,2.4209999999999998,0.63200000000000001,9.0999999999999998E-2,307.2,1.56,2.42,6.6000000000000003E-2]
["LV Sub Site Specific Band 2",0,2.3540000000000001,0.61499999999999999,8.8999999999999996E-2,808.51,1.56,2.42,6.4000000000000001E-2,null,"LV Sub Site Specific Band 2",0,2.3740000000000001,0.62,0.09,606.63,1.56,2.42,6.5000000000000002E-2,null,"LV Sub Site Specific Band 2",0,2.4209999999999998,0.63200000000000001,9.0999999999999998E-2,610.92999999999995,1.56,2.42,6.6000000000000003E-2]
["LV Sub Site Specific Band 3",0,2.3540000000000001,0.61499999999999999,8.8999999999999996E-2,1275.1500000000001,1.56,2.42,6.4000000000000001E-2,null,"LV Sub Site Specific Band 3",0,2.3740000000000001,0.62,0.09,954.74,1.56,2.42,6.5000000000000002E-2,null,"LV Sub Site Specific Band 3",0,2.4209999999999998,0.63200000000000001,9.0999999999999998E-2,961.58,1.56,2.42,6.6000000000000003E-2]
["LV Sub Site Specific Band 4",0,2.3540000000000001,0.61499999999999999,8.8999999999999996E-2,2496.61,1.56,2.42,6.4000000000000001E-2,null,"LV Sub Site Specific Band 4",0,2.3740000000000001,0.62,0.09,1865.93,1.56,2.42,6.5000000000000002E-2,null,"LV Sub Site Specific Band 4",0,2.4209999999999998,0.63200000000000001,9.0999999999999998E-2,1879.4,1.56,2.42,6.6000000000000003E-2]
["HV Site Specific No Residual",0,1.605,0.40699999999999997,5.8999999999999997E-2,183.14,1.89,3.01,3.9E-2,null,"HV Site Specific No Residual",0,1.623,0.41199999999999998,5.8999999999999997E-2,182.72,1.89,3.01,0.04,null,"HV Site Specific No Residual",0,1.665,0.42199999999999999,0.06,182.72,1.89,3.01,0.04]
["HV Site Specific Band 1",0,1.605,0.40699999999999997,5.8999999999999997E-2,2537.87,1.89,3.01,3.9E-2,null,"HV Site Specific Band 1",0,1.623,0.41199999999999998,5.8999999999999997E-2,1939.33,1.89,3.01,0.04,null,"HV Site Specific Band 1",0,1.665,0.42199999999999999,0.06,1952.11,1.89,3.01,0.04]
["HV Site Specific Band 2",0,1.605,0.40699999999999997,5.8999999999999997E-2,7237.03,1.89,3.01,3.9E-2,null,"HV Site Specific Band 2",0,1.623,0.41199999999999998,5.8999999999999997E-2,5444.84,1.89,3.01,0.04,null,"HV Site Specific Band 2",0,1.665,0.42199999999999999,0.06,5483.14,1.89,3.01,0.04]
["HV Site Specific Band 3",0,1.605,0.40699999999999997,5.8999999999999997E-2,15192.91,1.89,3.01,3.9E-2,null,"HV Site Specific Band 3",0,1.623,0.41199999999999998,5.8999999999999997E-2,11379.84,1.89,3.01,0.04,null,"HV Site Specific Band 3",0,1.665,0.42199999999999999,0.06,11461.33,1.89,3.01,0.04]
["HV Site Specific Band 4",0,1.605,0.40699999999999997,5.8999999999999997E-2,36205.300000000003,1.89,3.01,3.9E-2,null,"HV Site Specific Band 4",0,1.623,0.41199999999999998,5.8999999999999997E-2,27054.84,1.89,3.01,0.04,null,"HV Site Specific Band 4",0,1.665,0.42199999999999999,0.06,27250.42,1.89,3.01,0.04]
["Unmetered Supplies","0, 1 or 8",12.379,2.573,1.8240000000000001,0,0,0,0,null,"Unmetered Supplies","0, 1 or 8",12.015000000000001,2.14,1.3959999999999999,0,0,0,0,null,"Unmetered Supplies","0, 1 or 8",12.173999999999999,2.1589999999999998,1.407,0,0,0,0]
["LV Generation Aggregated",0,-3.0139999999999998,-0.81,-0.11700000000000001,0,0,0,0,null,"LV Generation Aggregated",0,-3.032,-0.81399999999999995,-0.11700000000000001,0,0,0,0,null,"LV Generation Aggregated",0,-3.0750000000000002,-0.82599999999999996,-0.11799999999999999,0,0,0,0]
["LV Sub Generation Aggregated",0,-2.65,-0.70899999999999996,-0.10199999999999999,0,0,0,0,null,"LV Sub Generation Aggregated",0,-2.6659999999999999,-0.71299999999999997,-0.10299999999999999,0,0,0,0,null,"LV Sub Generation Aggregated",0,-2.7069999999999999,-0.72399999999999998,-0.104,0,0,0,0]
["LV Generation Site Specific",0,-3.0139999999999998,-0.81,-0.11700000000000001,0,0,0,7.9000000000000001E-2,null,"LV Generation Site Specific",0,-3.032,-0.81399999999999995,-0.11700000000000001,0,0,0,7.9000000000000001E-2,null,"LV Generation Site Specific",0,-3.0750000000000002,-0.82599999999999996,-0.11799999999999999,0,0,0,0.08]
["LV Generation Site Specific no RP Charge",0,-3.0139999999999998,-0.81,-0.11700000000000001,0,0,0,0,null,"LV Generation Site Specific no RP Charge",0,-3.032,-0.81399999999999995,-0.11700000000000001,0,0,0,0,null,"LV Generation Site Specific no RP Charge",0,-3.0750000000000002,-0.82599999999999996,-0.11799999999999999,0,0,0,0]
["LV Sub Generation Site Specific",0,-2.65,-0.70899999999999996,-0.10199999999999999,0,0,0,7.2999999999999995E-2,null,"LV Sub Generation Site Specific",0,-2.6659999999999999,-0.71299999999999997,-0.10299999999999999,0,0,0,7.3999999999999996E-2,null,"LV Sub Generation Site Specific",0,-2.7069999999999999,-0.72399999999999998,-0.104,0,0,0,7.3999999999999996E-2]
["LV Sub Generation Site Specific no RP Charge",0,-2.65,-0.70899999999999996,-0.10199999999999999,0,0,0,0,null,"LV Sub Generation Site Specific no RP Charge",0,-2.6659999999999999,-0.71299999999999997,-0.10299999999999999,0,0,0,0,null,"LV Sub Generation Site Specific no RP Charge",0,-2.7069999999999999,-0.72399999999999998,-0.104,0,0,0,0]
["HV Generation Site Specific",0,-1.8939999999999999,-0.49299999999999999,-7.0999999999999994E-2,114.14,0,0,0.06,null,"HV Generation Site Specific",0,-1.91,-0.497,-7.1999999999999995E-2,114.14,0,0,0.06,null,"HV Generation Site Specific",0,-1.95,-0.50700000000000001,-7.2999999999999995E-2,114.14,0,0,6.0999999999999999E-2]
["HV Generation Site Specific no RP Charge",0,-1.8939999999999999,-0.49299999999999999,-7.0999999999999994E-2,114.14,0,0,0,null,"HV Generation Site Specific no RP Charge",0,-1.91,-0.497,-7.1999999999999995E-2,114.14,0,0,0,null,"HV Generation Site Specific no RP Charge",0,-1.95,-0.50700000000000001,-7.2999999999999995E-2,114.14,0,0,0]

{"sheet":"Volumes","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Volumes Variance","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}