{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Introduction","Contents","Dashboard","Calculations","1. Revenue","2. RAB - Closing","3. Capex","4. Capex by Driver","5. Opex","6. Reliability -outage events","7. Reliability -outage duration","8. Market impact","9. Maximum demand","10. Energy delivered","11. Circuit length","12. Return on assets","Data sheet"],"not_rendered":{"charts":24,"images":1,"macros":1,"external_links":5,"defined_names":327,"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":"Introduction","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,2,10,14],[12,2,13,14],[16,2,16,14],[14,2,14,14]]}
[]
[null,null,null,"Electricity Transmission Network Service Provider"]
[null,null,null,null,"Performance Data"]
[]
[]
[null,"Introduction"]
[]
[]
[]
[]
[null,null,"This workbook contains performance data for electricity transmission businesses in the National Energy Market (NEM). The charts and data are presented for a range of financial and network performance measures.  "]
[null,null,"Interpretation"]
[null,null,"The data covers the regulatory years from 2006 to 2018. It is reported on an end of year basis. All transmission businesses report on a financial year basis, hence the label 2015 refers to data collected for the year ending 30 June 2015 (or 31 March 2015 for AusNet (T)). Exceptions to this are tables 6,7 and 8, which are reported on a calendar year basis, in line with STPIS reporting timeframes.\n\nAll financial values have been converted to June 2018 dollars (or March 2018 dollars for AusNet (T))."]
[]
[null,null,"These data series are provided to facilitate general stakeholder engagement in the AER's regulatory processes. The data is subject to revisions, arising from changes from improved data collation, or regulatory updates that apply from time to time. Information to aid interpretation of the data is available with the transmission businesses RIN responses, and AER Guidelines and Explanatory material associated with our models and data collections - available on the AER website."]
[null,null,"Sources"]
[null,null,"Data is classified as actual or forecast data. \n\nActual data is generally sourced from individual annual responses to regulatory information notices (RINs), including economic benchmarking and category analysis RINs, or historical data provided at the time of regulatory determinations. The RIN responses of the transmission businesses are available on the AER website.\n\nForecast data is generally sourced from the final regulatory determinations made by the AER for each of the businesses, updated for decisions by the Australian Competition Tribunal, and other allowed adjustments. \n\nDetailed data sources are listed in each of the worksheets."]
[]
[null,null,"VERSION RECORD"]
[]
[null,null,"Version","Publication date",null,"Data range/updates"]
[null,null,3,"Jul 2019",null,"Financial years",null,"2005-06 to 2017-18",null,"Data as at 27 June 2019"]
[null,null,2,"Aug 2018",null,"Financial years",null,"2005-06 to 2016-17",null,"Amended Opex data to remove Easement Tax for AusNet (T)"]
[null,null,1,"Feb 2018",null,"Financial years",null,"2005-06 to 2016-17"]

{"sheet":"Contents","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[12,2,12,12],[25,2,25,12],[11,2,11,12],[24,2,24,12],[13,2,13,12],[14,2,14,12],[15,2,15,12],[16,2,16,12],[17,2,17,12],[18,2,18,12],[19,2,19,12],[20,2,20,12],[21,2,21,12],[22,2,22,12],[23,2,23,12]]}
[]
[]
[null,null,"Electricity Transmission Network Service Provider"]
[null,null,null,null,"Performance Data"]
[]
[null,"Contents"]
[]
[]
[]
[]
[]
[]
[null,null,"Dashboard"]
[null,null,"1. Revenue"]
[null,null,"2. Regulated asset base"]
[null,null,"3. Capital expenditure"]
[null,null,"4. Capital expenditure by driver"]
[null,null,"5. Operating expenditure"]
[null,null,"6. Reliability - outage events"]
[null,null,"7. Reliability - outage duration"]
[null,null,"8. Market impact"]
[null,null,"9. Maximum demand"]
[null,null,"10. Energy delivered"]
[null,null,"11. Circuit length"]
[null,null,"12. Return on assets"]
[null,null,"Datasheet"]

{"sheet":"Dashboard","index":2,"n_rows":128,"n_cols":17,"rows_kept":128,"cut":false,"hidden":false,"merged":[[2,5,2,9]]}
[]
[]
[null,null,null,null,null,"Transmission total"]
[]
[]
[null,null,null,null,null,null,"Summary statistics"]
[]
[]
[null,null,null,null,null,null,null,"2018 value","5 year trend"]
[null,null,null,null,null,null,"Actual revenue",{"$f":"\"$\"&TEXT(Calculations!Q10,\"#,##0\")&\"m\"","v":"$2,634m"}]
[null,null,null,null,null,null,"Actual closing RAB",{"$f":"\"$\"&TEXT(Calculations!Q11,\"#,##0\")&\"m\"","v":"$20,718m"}]
[null,null,null,null,null,null,"Forecast closing RAB",{"$f":"\"$\"&TEXT(Calculations!Q12,\"#,##0\")&\"m\"","v":"$20,988m"}]
[null,null,null,null,null,null,"Actual annual capex",{"$f":"\"$\"&TEXT(Calculations!Q13,\"#,##0\")&\"m\"","v":"$744m"}]
[null,null,null,null,null,null,"Forecast annual capex",{"$f":"\"$\"&TEXT(Calculations!Q14,\"#,##0\")&\"m\"","v":"$708m"}]
[null,null,null,null,null,null,"Actual annual opex",{"$f":"\"$\"&TEXT(Calculations!Q15,\"#,##0\")&\"m\"","v":"$550m"}]
[null,null,null,null,null,null,"Forecast annual opex",{"$f":"\"$\"&TEXT(Calculations!Q16,\"#,##0\")&\"m\"","v":"$618m"}]
[null,null,null,null,null,null,"Loss of supply events*",{"$f":"TEXT(Calculations!P17,\"0\")&\" events\"","v":"12 events"}]
[null,null,null,null,null,null,"Average outage duration*",{"$f":"IF(Calculations!P18>0,TEXT(Calculations!P18,\"0\")&\" minutes\",\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,"Market impact indicator*",{"$f":"IF(Calculations!P19>0,TEXT(Calculations!P19,\"0\")&\" minutes\",\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,"Maximum demand",{"$f":"IF(Calculations!Q20>0,(TEXT(Calculations!Q20,\"000\")&\"MW\"),\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,"Energy delivered",{"$f":"TEXT(Calculations!Q21,\"0,00\")&\"GWh\"","v":"177,260GWh"}]
[null,null,null,null,null,null,"Circuit length - total",{"$f":"TEXT(Calculations!Q22,\"0,00\")&\"km\"","v":"43,308km"}]
[null,null,null,null,null,null,"Circuit length - overhead",{"$f":"TEXT(Calculations!Q23,\"0,00\")&\"km\"","v":"43,145km"}]
[null,null,null,null,null,null,"Circuit length - underground",{"$f":"TEXT(Calculations!Q24,\"0,0\")&\"km\"","v":"163km"}]
[null,null,null,null,null,null,"Return on assets, including incentive scheme penalties or rewards",{"$f":"IF(Calculations!Q25>0,TEXT(Calculations!Q25,\"0.0%\"),\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,"Return on assets, excluding incentive scheme penalties or rewards",{"$f":"IF(Calculations!Q26>0,TEXT(Calculations!Q26,\"0.0%\"),\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,"Real pre-tax WACC",{"$f":"IF(Calculations!Q27>0,TEXT(Calculations!Q27,\"0.0%\"),\"not calculated\")","v":"not calculated"}]
[null,null,null,null,null,null,null,"* 2018 data unavailable"]
[]
[]
[]
[]
[null,null,"Financials"]
[]
[null,null,"Annual revenue",null,null,null,null,"Closing RAB",null,null,null,null,null,null,null,null,"Return on Assets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"No data for Transmission total - Return on assets\", \"\")","v":"No data for Transmission total - Return on assets"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Expenditure"]
[]
[null,null,"Opex",null,null,null,null,"Capex By Driver",null,null,null,null,null,null,null,null,"Capex"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Service Performance"]
[]
[]
[null,null,"Reliability - outage events",null,null,null,null,"Reliability - outage duration",null,null,null,null,null,null,null,null,"Market impact"]
[null,null,{"$f":"IFERROR(Calculations!Q17,\"No Data for 2018\")","v":"No Data for 2018"},null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"No data for Transmission total - Outage duration\", \"\")","v":"No data for Transmission total - Outage duration"},null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"No data for Transmission total - Market impact\", \"\")","v":"No data for Transmission total - Market impact"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Network Descriptors"]
[]
[]
[null,null,"Energy delivered",null,null,null,null,"Circuit Length",null,null,null,null,null,null,null,null,"Maximum demand"]
[null,null,{"$f":"IF(F3=\"Transmission total\", \"No data for Transmission total - Maximum demand\", \"\")","v":"No data for Transmission total - Maximum demand"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"No data for Transmission total - Maximum demand\", \"\")","v":"No data for Transmission total - Maximum demand"}]

{"sheet":"Calculations","index":3,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,"Summary statistics"]
[]
[null,null,null,"Match",{"$f":"Dashboard!F3","v":"Transmission total"}]
[]
[null,null,null,null,"2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,"2018","2019","2020","2021","2022"]
[null,null,null,"Actual revenue",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2151.2422632778757},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2217.0856919452858},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2278.1691470757951},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2484.2967535367652},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2698.4285847159849},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2869.741445584436},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":3043.934877863685},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":3144.060494085858},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":3101.4778453343251},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":3059.1511007369777},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2932.1258387194566},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2923.7820399568373},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":2634.2295083171634},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D10&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Actual closing RAB",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":13216.349231033579},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":14306.715589866149},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":15674.169789277743},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":16847.280214226426},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":17631.505231431893},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":18394.405866874193},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":19382.180572759768},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20261.014706456015},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":21063.541218025977},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20982.259122544543},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20858.070635070188},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20761.27651065624},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20718.205594379262},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D11&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Forecast closing RAB",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":13461.307041121947},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":13627.164983037586},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":15614.461648109893},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":16954.245660464112},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":18176.90074788707},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":19282.688265525347},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20278.761080189819},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":21318.007609229313},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":22169.476644733622},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":21979.730744142213},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":22396.580784047874},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":22690.231359391077},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20987.973671858002},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D12&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Actual annual capex",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":897.33836880747879},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":989.41006957992533},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1685.0445790037609},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1782.5254459788271},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1451.6376231994898},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1448.08539939445},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1613.1331716735799},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1573.2220958448472},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1245.7647463317419},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":746.30173326627403},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":742.55101538406268},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":753.40578669891033},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":744.4902941705983},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D13&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Forecast annual capex",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":788.40136684582967},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":748.94485791134878},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1631.7953983171899},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1601.0285403729831},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1767.9609819508166},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1814.291787728552},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1719.0530827238954},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1759.7203140098452},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1638.0975513108319},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1100.6420398689254},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1287.0301116243149},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":1207.6897596195845},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":708.37101225790718},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D14&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Actual annual opex",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":521.26798503898522},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":531.78893652840179},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":532.76406774452846},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":550.31987979858854},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":577.25379879935053},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":553.77383537423475},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":574.14448958817252},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":559.16516619277354},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":606.50975876429925},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":613.58085764821669},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":626.06328101674865},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":622.94443556646615},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":550.22046002515219},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D15&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Forecast annual opex",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":504.6417324681247},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":502.48443557131583},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":557.79060323202202},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":557.20406530718265},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":624.13881679900874},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":612.07391382377068},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":624.26313778632584},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":646.74344732352824},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":661.56628208806853},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":622.98100056133251},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":633.02668982710497},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":650.26655228441996},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":617.88325563916192},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D16&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Loss of supply events",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":29},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":20},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":15},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":23},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":25},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":25},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":23},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":24},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":15},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":11},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":11},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":12},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D17&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Average outage duration",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D18&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Market impact indicator",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D19&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Maximum demand (MW)",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D20&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Energy delivered (GWh)",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":180731.49885553998},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":183476.66682193},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":184729.68349650002},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":185079.75041945998},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":183693.70975963},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":180265.99551486},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":177917.08292346},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":173499.60999222001},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":169552.88751910499},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":172616.53532602999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":176152.51001669999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":176397.41043595699},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":177260.3930889894},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D21&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Circuit length",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":39972.870000000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40133.263000000006},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40666.283000000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40985.418000000005},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41559.528000000006},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41991.232000000004},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41991.976000000002},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":42810.656000000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43308.369054000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43437.513697599999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43441.588756730001},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43253.854478733338},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43308.083696939961},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D22&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Circuit length - overhead",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":39876.073000000004},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40036.466},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40569.485999999997},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":40887.320999999996},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41461.430999999997},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41888.834999999999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":41871.178999999996},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":42679.869000000006},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43173.443054000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43271.600697599999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43275.659756729998},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43091.2321084},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":43145.404696939971},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D23&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Circuit length - underground",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":96.796999999999997},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":96.796999999999997},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":96.796999999999997},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":98.097000000000008},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":98.097000000000008},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":102.39699999999999},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":120.79699999999998},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":130.78700000000001},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":134.92600000000002},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":165.91300000000001},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":165.929},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":162.62237033333335},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":162.67900000000003},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D24&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D25&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D26&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Real pre-tax WACC",{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&E$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&F$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&G$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&H$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&I$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&J$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&K$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&L$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&M$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&N$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&O$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&P$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&Q$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":0},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&R$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&S$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&T$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('Data sheet'!$F:$K,MATCH($D27&U$9,'Data sheet'!$L:$L,0),MATCH($E$7,'Data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,"2009","2010","2011","2012","2013","2014","2015",2016,2017,"2018","2019","2020","2021","2022"]
[null,null,null,"augmentation expenditure",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!D80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!D88, \"#N/A\"))))))","v":1084.7740738219895},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!E80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!E88, \"\"))))))","v":672.90680243549957},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!F80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!F88, \"\"))))))","v":750.99236905082944},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!G80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!G88, \"\"))))))","v":544.30217227242997},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!H80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!H88, \"\"))))))","v":587.2944382893179},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!I80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!I88, \"\"))))))","v":557.943876328329},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!J80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!J88, \"\"))))))","v":50.23130542162081},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!K80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!K88, \"\"))))))","v":116.95964955583671},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!L80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!L88, \"\"))))))","v":25.987201240562893},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!M80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!M88, \"\"))))))","v":32.177953346431771},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!N80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!N88, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!O80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!O88, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!P80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!P88, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q38, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q53, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q61, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q69, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!Q80, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!Q88, \"\"))))))","v":0}]
[null,null,null,"overheads",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!D81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!D89, \"\"))))))","v":89.089962487743023},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!E81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!E89, \"\"))))))","v":101.67601155450767},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!F81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!F89, \"\"))))))","v":92.622307907951253},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!G81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!G89, \"\"))))))","v":97.81587584676106},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!H81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!H89, \"\"))))))","v":102.07237018481715},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!I81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!I89, \"\"))))))","v":85.867685007719473},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!J81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!J89, \"\"))))))","v":76.002642761199951},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!K81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!K89, \"\"))))))","v":70.644387601002222},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!L81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!L89, \"\"))))))","v":79.131469347770206},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!M81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!M89, \"\"))))))","v":76.198191115546933},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!N81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!N89, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!O81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!O89, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!P81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!P89, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q39, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q54, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q62, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q70, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!Q81, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!Q89, \"\"))))))","v":0}]
[null,null,null,"connections",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!D82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!D90, \"\"))))))","v":43.112187561495233},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!E82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!E90, \"\"))))))","v":63.457196001693617},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!F82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!F90, \"\"))))))","v":68.751991961229407},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!G82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!G90, \"\"))))))","v":53.868177262573056},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!H82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!H90, \"\"))))))","v":35.84571145993273},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!I82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!I90, \"\"))))))","v":86.023355084302779},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!J82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!J90, \"\"))))))","v":57.111344105541001},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!K82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!K90, \"\"))))))","v":78.78532402898098},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!L82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!L90, \"\"))))))","v":41.019198952951008},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!M82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!M90, \"\"))))))","v":19.639310170329086},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!N82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!N90, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!O82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!O90, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!P82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!P90, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q40, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q55, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q63, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q71, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!Q82, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!Q90, \"\"))))))","v":0}]
[null,null,null,"non-network",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!D83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!D91, \"\"))))))","v":103.40722859705889},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!E83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!E91, \"\"))))))","v":96.407405031816666},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!F83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!F91, \"\"))))))","v":118.95320097730891},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!G83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!G91, \"\"))))))","v":106.75127907780461},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!H83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!H91, \"\"))))))","v":128.38030895911115},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!I83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!I91, \"\"))))))","v":127.65980675063017},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!J83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!J91, \"\"))))))","v":77.191556712478672},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!K83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!K91, \"\"))))))","v":58.539649277314275},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!L83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!L91, \"\"))))))","v":72.386091723716845},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!M83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!M91, \"\"))))))","v":114.31030250217705},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!N83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!N91, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!O83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!O91, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!P83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!P91, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q56, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q64, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q72, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!Q83, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!Q91, \"\"))))))","v":0}]
[null,null,null,"replacement expenditure",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!D84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!D92, \"\"))))))","v":481.79912084865487},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!E84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!E92, \"\"))))))","v":456.97079278420176},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!F84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!F92, \"\"))))))","v":400.31697412845438},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!G84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!G92, \"\"))))))","v":575.7767111170017},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!H84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!H92, \"\"))))))","v":741.57968677806991},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!I84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!I92, \"\"))))))","v":685.11184050879729},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!J84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!J92, \"\"))))))","v":532.70380085559464},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!K84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!K92, \"\"))))))","v":442.80818090493511},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!L84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!L92, \"\"))))))","v":495.62572552247138},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!M84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!M92, \"\"))))))","v":492.62606722800228},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!N84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!N92, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!O84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!O92, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!P84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!P92, \"\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q73, IF($E$7='4. Capex by Driver'!$B$78,'4. Capex by Driver'!Q84, IF($E$7='4. Capex by Driver'!$B$86,'4. Capex by Driver'!Q92, \"\"))))))","v":0}]

{"sheet":"1. Revenue","index":4,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,13],[28,1,28,15],[40,1,40,12]]}
[]
[]
[]
[null,"Revenue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Actual revenues are reported by the transmission businesses and include all components of their revenue associated with delivering prescribed transmission services. Transmission businesses are regulated via a revenue cap, which limits the revenues that can be earned in any year. "]
[]
[null,"Actual Revenue"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",641.12712484478629,675.48525049510101,687.93848779847337,741.87784478298363,787.37679819077573,847.91763611880435,935.64561671394279,950.62747120424842,978.17209186033006,1014.9489978748531,1028.2098681012305,1072.0629033721682,786.56846528128676]
[null,"Transgrid","NSW",621.84236245640568,641.08297539077489,663.62650636061051,704.05023650800945,811.15276068282174,861.55431179496543,918.05889258324237,963.54731169618333,952.88682755736556,905.88016486472873,774.55274018761554,746.91056053263389,719.90105500648178]
[null,"AusNet (T)","VIC",501.27423359501086,502.3382352012726,522.65895584170414,576.38746313250522,601.2468487828296,607.59429385324734,611.66903115655293,625.24771194705875,629.8700498895804,611.52794292419458,594.22549916996161,583.64992335233762,593.60742190979011]
[null,"ElectraNet","SA",230.27290281480938,235.63517693874255,237.91465965680024,284.02603791959757,299.3644335846783,318.22289358663653,338.1663790099887,361.22311790031978,307.51599110148567,322.29860167579909,335.42463565255872,341.40698989569444,353.29228145537542]
[null,"TasNetworks (T)","TAS",156.72563956686338,162.54405391939477,166.03053741820685,177.95517119366912,199.28774347487939,234.45231023078225,240.39495839995789,243.41488133804796,233.03288492556339,204.49539339740184,199.71309560809038,179.75166280400288,180.86028466422923]
[null,"Total",null,2151.2422632778757,2217.0856919452858,2278.1691470757951,2484.2967535367652,2698.4285847159849,2869.741445584436,3043.934877863685,3144.060494085858,3101.4778453343251,3059.1511007369777,2932.1258387194566,2923.7820399568373,2634.2295083171634]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"2. RAB - Closing","index":5,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[[56,1,56,15],[57,1,57,15],[3,1,3,13],[26,1,26,13],[28,1,28,13],[40,1,41,15],[53,1,53,15],[55,1,55,15]]}
[]
[]
[]
[null,"Regulatory Asset Base"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The regulatory asset base (RAB) represents the value of the network at a given point in time. The value of the network changes each year due to capital expenditures, depreciation, and disposal of assets."]
[]
[null,"Actual Closing RAB"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",4006.141175351519,4880.044723640387,5548.7817151440313,6106.657031357463,6424.5476214104892,6687.7674939445915,7246.6714479830607,7530.6499356665699,7637.9567302980722,7541.5878748808927,7400.071160754881,7204.3724818747178,7113.7580261942076]
[null,"Transgrid","NSW",4305.9915401492708,4423.6830063529151,4665.0857113491538,5140.5339711658908,5424.3028425615821,5647.2905643955501,5839.7856235976851,6173.520304501938,6499.0555494949258,6510.011793774107,6499.44250265349,6405.980670585398,6371.2252446444118]
[null,"AusNet (T)*","VIC",2549.8522743541266,2538.6043495928816,2761.8255169772692,2747.5463478540159,2749.8417143203997,2743.4248259493752,2758.2331568615341,2811.2949680315214,3080.6850399648447,3086.6620502175456,3078.9982481606803,3228.2151035745487,3242.9792399413614]
[null,"ElectraNet","SA",1371.1437291399277,1408.0323873991083,1636.2965057746246,1692.8675528850686,1767.1111662457856,1973.8239955775409,2103.621408327499,2275.6732901094056,2337.3072909967732,2364.1476702595155,2432.5408234713764,2484.8676591745752,2560.1560828966099]
[null,"TasNetworks (T)","TAS",983.22051203873457,1056.3511228808579,1062.1803400326637,1159.6753109639853,1265.7018868936373,1342.0989870071303,1433.8689359899874,1469.8762081465843,1508.5366072713607,1479.8497334124834,1447.0179000297592,1437.8405954469988,1430.087000702672]
[null," Total",null,13216.349231033579,14306.715589866149,15674.169789277743,16847.280214226426,17631.505231431893,18394.405866874193,19382.180572759768,20261.014706456015,21063.541218025977,20982.259122544543,20858.070635070188,20761.27651065624,20718.205594379262]
[]
[null,"Sources:"]
[null,"Actual closing RAB has been taken from Roll forward models developed as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as updated by the Australian Competition Tribunal. Where a final decision for a regulatory period is not yet available, draft decisions or regulatory proposals have been used. If no RFM is available we have used the forecast RAB data from the Post Tax Revenue Models (Powerlink 2018, and AusNet (T) 2018)."]
[]
[]
[null,"Forecast Closing RAB"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",3993.8684511524639,3930.7841803477968,5626.0675394756927,6260.3120023012052,6592.2593649842402,6969.5538316851225,7244.2941735034237,7796.2383769116432,8183.1713257040183,8352.0609268428871,8551.7397417218999,8806.6294254355598,7113.7580261942076]
[null,"Transgrid","NSW",4406.3224739182542,4556.0723422077535,4885.7591778833612,5118.7812770382616,5598.4172123510889,5946.4397913118246,6430.4774773959216,6837.6300814117294,7063.6063287095158,6521.044787337356,6583.2353092775038,6556.2067349605104,6530.7033363506844]
[null,"AusNet (T)*","VIC",2658.633016606595,2645.0591005501592,2629.1113015290671,2779.5513672792067,2783.3032477392903,2808.6108778196208,2838.6722702353386,2842.4194074504344,2890.0492630623339,3093.6059240136574,3136.2997393769788,3173.3546541698202,3242.9792399413614]
[null,"ElectraNet","SA",1421.1133582648811,1440.4232930920034,1412.7391621433933,1738.7328208376682,1901.8470486721146,2122.1478469433123,2271.4212908978952,2289.6427303588644,2427.0847978674078,2504.5865901455927,2605.0412830469413,2637.857615428959,2596.6142866940777]
[null,"TasNetworks (T)","TAS",981.36974117975331,1054.826066839873,1060.7844670783788,1056.8681930077707,1301.0738741403384,1435.9359177654662,1493.8958681572401,1552.0770130966398,1605.5649293903493,1508.4325158027152,1520.2647106245497,1516.1829293962285,1503.9187826776722]
[null," Total",null,13461.307041121947,13627.164983037586,15614.461648109893,16954.245660464112,18176.90074788707,19282.688265525347,20278.761080189819,21318.007609229313,22169.476644733622,21979.730744142213,22396.580784047874,22690.231359391077,20987.973671858002]
[]
[null,"Sources:"]
[null,"Forecast closing RAB is sourced from post tax revenue models determined as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as adjusted by the Australian Competition Tribunal. Updates to the model are also taken into account."]
[]
[null,"Notes:"]
[null,"AusNet (T) - differences between actual and forecast closing RAB arise due to the treatment of augmentation capital works (Group 3 assets). These assets are included in Actual RAB data, but are not included in forecasts. The AER's Final decision on Ausnet (T)'s RAB explains the issue and advises:"]
[null,"During a regulatory control period, AEMO or a distribution business may request AusNet Services to provide augmentations to the transmission network or distribution connection services. While the assets constructed due to these requests provide prescribed transmission services, the forecast capex associated with these assets sit outside of the revenue determination. This is because AusNet Services is not responsible for the planning of these capex. AusNet Services and AEMO refer to the assets that provide these services as ‘Group 3’ assets. Group 3 assets sit outside of the RAB and are governed by commercial contracts until such time as they are rolled into the RAB, usually at the next revenue reset. "]

{"sheet":"3. Capex","index":6,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,13],[28,1,28,13],[40,1,42,15],[54,1,54,15]]}
[]
[]
[]
[null,"Capital expenditure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Capital expenditure (capex) measures the new investments in the transmission networks. This includes expenditure for augmentation of the network, replacement of assets, new connections, improving network reliability and non-network investments (e.g. buildings). All data is reported on an as-incurred basis."]
[]
[null,"Actual annual capex"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",361.36092584949688,323.50271442711676,844.28695136158899,765.13999877046058,532.82843831741161,493.3133757121837,716.62238114737659,498.20295187367446,342.79752934579636,169.27416382062097,138.6919963830486,176.91466226076525,150.84443081587133]
[null,"Transgrid","NSW",209.94281689242013,285.37814121958905,408.30944706815615,701.84368933231633,486.22161226076082,422.05775835931831,398.65748353316832,539.13996327100449,519.29929609409737,267.51131178598234,257.85450464819553,189.66437484502785,229.64267232162436]
[null,"AusNet (T)","VIC",138.44505045399978,141.39719346864993,139.41660171311779,112.93689360821496,132.16840583240048,127.82608754027696,149.98986089683041,191.57232196432651,157.59429960302145,162.1951393927954,145.92300214671698,179.72523536924464,134.93739604185501]
[null,"ElectraNet","SA",92.105803837220421,106.10755361152678,213.73671948950715,120.03280743535048,141.09782150877103,270.30509474632294,205.14206692514972,249.44067773309084,142.53994594966309,120.50767465264327,174.24441961194924,154.76739935322186,176.37645920373106]
[null,"TasNetworks (T)","TAS",95.483771774341662,133.02446685304281,79.294859371390928,82.572056832484989,159.32134528014612,134.58308303634797,142.72137917105479,94.866181002751091,83.533675339163622,26.813443614232007,25.837092594152299,52.334114870650694,52.689335787516498]
[null," Total",null,897.33836880747879,989.41006957992533,1685.0445790037609,1782.5254459788271,1451.6376231994898,1448.08539939445,1613.1331716735799,1573.2220958448472,1245.7647463317419,746.30173326627403,742.55101538406268,753.40578669891033,744.4902941705983]
[]
[null,"Sources:"]
[null,"Actual capex has been taken from Roll forward models developed as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as updated by the Australian Competition Tribunal. The latest available RFM has been used, and if no RFM data is available, Category analysis RIN responses are used."]
[]
[]
[]
[null,"Forecast annual capex"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",271.26259830034519,121.4915904481976,920.61626496779047,839.80914689167469,556.57298161347808,614.44358650574713,523.55732084409647,757.03921674327012,625.08791809686579,445.17578620400309,494.95731751072015,560.43533391269864,167.60949239008738]
[null,"Transgrid","NSW",254.84038939030066,307.24061691128566,485.38897062415543,406.42816554133975,655.12491678902791,558.40274089747857,686.55867289370076,630.99674091619579,474.26327525213571,273.06952418869963,325.8233841503698,251.72180593400242,235.09362804522729]
[null,"AusNet (T)","VIC",75.348308791863545,102.16559245587985,103.46386323184038,146.8192859177683,140.54031176875012,166.3159749469263,175.69449525767672,154.1312067465247,188.36449880770365,161.28076928955821,194.69786890486606,193.66941446448143,183.76580752835386]
[null,"ElectraNet","SA",116.35138190166751,101.52253105961022,67.289687520609974,162.04483823800703,222.02675671446318,283.6493584397345,218.9246248269769,97.369182751781423,230.48234705223987,166.95664255026239,202.60145315715445,145.42001531668859,74.270416378279108]
[null,"TasNetworks (T)","TAS",70.598688461652699,116.52452703637546,55.036611972793764,45.92710378419342,193.69601506509747,191.48012693866556,114.31796890144454,120.18396685207308,119.89951210188674,54.159317636401902,68.95008790120427,56.443189991713631,47.631667915959483]
[null,"Total",null,788.40136684582967,748.94485791134878,1631.7953983171899,1601.0285403729831,1767.9609819508166,1814.291787728552,1719.0530827238954,1759.7203140098452,1638.0975513108319,1100.6420398689254,1287.0301116243149,1207.6897596195845,708.37101225790718]
[]
[null,"Sources:"]
[null,"Forecast capex is sourced from post tax revenue models determined as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as adjusted by the Australian Competition Tribunal. Updates to the models are also taken into account."]

{"sheet":"4. Capex by Driver","index":7,"n_rows":92,"n_cols":18,"rows_kept":92,"cut":false,"hidden":false,"merged":[[3,1,3,12],[33,1,33,12],[44,1,44,12],[47,11,48,12],[74,11,75,12]]}
[]
[]
[]
[null,"Capital expenditure by driver"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Transmission businesses are required to report their capital expenditure annually by driver. This shows how the transmission businesses investment's were split between the various drivers."]
[]
[null,"Capex by Driver"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure*",1084.7740738219895,672.90680243549957,750.99236905082944,544.30217227242997,587.2944382893179,557.943876328329,50.23130542162081,116.95964955583671,25.987201240562893,32.177953346431771]
[null,null,"overheads",89.089962487743023,101.67601155450767,92.622307907951253,97.81587584676106,102.07237018481715,85.867685007719473,76.002642761199951,70.644387601002222,79.131469347770206,76.198191115546933]
[null,null,"connections",43.112187561495233,63.457196001693617,68.751991961229407,53.868177262573056,35.84571145993273,86.023355084302779,57.111344105541001,78.78532402898098,41.019198952951008,19.639310170329086]
[null,null,"non-network",103.40722859705889,96.407405031816666,118.95320097730891,106.75127907780461,128.38030895911115,127.65980675063017,77.191556712478672,58.539649277314275,72.386091723716845,114.31030250217705]
[null,null,"replacement expenditure",481.79912084865487,456.97079278420176,400.31697412845438,575.7767111170017,741.57968677806991,685.11184050879729,532.70380085559464,442.80818090493511,495.62572552247138,492.62606722800228]
[]
[null,"Notes:"]
[null,"The Category Analysis RIN may result in some expenditures being classified into more than one driver. (For example, some connections capex may also be reported under augmentation capex). As such the total capex by driver may not reconcile with the total capex shown on worksheet 3. Capex."]
[null,"*Does not include Victorian augmentation expenditure"]
[]
[null,"Sources:"]
[null,"Category Analysis RINs 2008-13, 2014, 2015, 2016, 2017, 2018"]
[]
[null,"Powerlink"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure",471.93421340934583,227.44234150461168,306.32248356898816,211.94933451038182,200.02977325648408,275.16445976055849,10.194855785744124,12.180730959583848,0,2.2013941433693152]
[null,null,"overheads",35.674713127080118,28.681979931136333,26.294259679044842,25.519166425500387,24.958322217354244,20.711745965887253,13.220156652816241,7.3913264945542867,12.278886077187744,8.4321210132121749]
[null,null,"connections",18.506403477122856,4.6166794446458734,4.7444926260358224,6.4227440657333945,3.1372748246914202,5.3546998694690267,1.4596671315616501,0,0,0]
[null,null,"non-network",30.155938680299059,38.336371563877748,38.45747794553111,32.614216423767566,35.427176952298801,13.782629322611468,8.0365162058235402,13.464182631190152,17.820972594889742,35.046994448218094]
[null,null,"replacement expenditure",193.14146274319992,158.47510017066767,82.019330733713559,205.94152105752565,237.87940128341563,260.19233808751557,152.11061251635721,52.851911081413498,117.86083313928661,63.243143137564211]
[]
[null,"Transgrid"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure",530.11465997911796,295.35862418263025,219.75839747103629,188.35125691955409,292.50957728306605,244.79876291248326,23.020920559431236,55.374730517521371,4.8609386227464757,4.4694971989504273]
[null,null,"overheads",29.792412443099231,45.945039823619389,33.158507114392378,38.506122395719551,42.113283721405558,34.531342594796214,34.473635049528013,30.400336128426996,31.689662013300858,32.133251305665077]
[null,null,"connections",0,0,0,0,0,2.9999026268652806,2.5727458411421114,1.8366023164064975,0.80207516873591755,0.33753143117322748]
[null,null,"non-network",40.246114647018082,25.983261897302175,30.566777563254995,45.21153571785031,55.907064425165927,73.92672156574487,36.761236727208846,21.582230656037698,23.549959979612744,29.872189807615957]
[null,null,"replacement expenditure",99.40852144563506,119.49291427874985,140.5981145110396,132.97804586888745,149.64650194102097,163.81600291485915,171.32289022980197,142.49598389713603,123.30641289516532,161.79399081506784]
[]
[null,"AusNet (T)"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure*",0,0,0,0,0,0,0,0,0,0]
[null,null,"overheads",12.436397803900952,13.316946272503412,14.349204680737799,15.522973020331115,17.708327395190899,15.456910606024291,13.742016141951199,18.134212936193279,13.695339128129728,9.9079956141395691]
[null,null,"connections",9.3313067702969033,27.847101297307994,6.510456690185471,4.2177781674438508,16.917489811655663,61.674939305369563,33.287293453170918,74.582597790560499,36.674597701469807,19.005915115432821]
[null,null,"non-network",13.650088769052079,10.972325542741004,16.177449149968638,13.341399186307823,18.282394614434075,23.025852343117517,22.699559935766164,10.493911792526987,8.3593074517818646,11.195889188351332]
[null,null,"replacement expenditure",89.156097774962888,108.43419481948295,98.069725038798637,124.21086499619744,157.64601708618903,120.81896362588357,125.62193155871455,126.30698086721434,116.67505105952628,111.60150598165849]
[]
[null,"Notes:"]
[null,"*Augmentation of Vic transmission networks is carried out by AEMO, hence $0 expenditure reported by AusNet (T)"]
[]
[null,"ElectraNet"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure",14.502511417071114,46.280299075802539,182.9181836391742,89.230951071773376,83.764292095878545,33.308815246246354,16.866096279038501,49.146873584458149,19.859709853496526,22.239216018157009]
[null,null,"overheads",7.3702004452495702,9.757393804296667,14.342468513184624,14.880768514131669,14.404176139021393,12.425211548697193,11.655989087941256,10.201583362067229,10.520036363033778,14.295965753742168]
[null,null,"connections",14.703230275200021,23.665882637099234,31.393695122663729,16.573722328421862,13.630686988166051,15.873354731285666,19.789144504377575,2.3651228078585835,3.5425260827452814,0.29586362372303826]
[null,null,"non-network",8.5362844818386936,9.964979338737372,8.4032684471128736,7.9288766831732644,12.892314130314023,11.290245657146555,6.3235475941974597,7.4566942503687486,12.306523257625136,28.523460042028454]
[null,null,"replacement expenditure",74.056265102159827,50.44730870944435,33.528534831267123,65.141698247714459,122.35588739291907,68.21016934477872,65.9573939289631,105.89133540251139,108.54168830684742,128.0746353822303]
[]
[null,"TasNetworks (T)"]
[null,null,"($m 2018)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,null,"augmentation expenditure",68.222689016454595,103.82553767245507,41.993304371630771,54.770629770720667,10.990795653889165,4.6718384090408547,0.14943279740695362,0.2573144942733458,1.2665527643198948,3.2678459859550228]
[null,null,"overheads",3.8162386684131571,3.9746517229518665,4.4778679205916019,3.3868454910783505,2.8882607118450525,2.7424742923145198,2.9108458289632515,4.5169286797604205,10.947545766118097,11.428857428787943]
[null,null,"connections",0.57124703887545847,7.3275326226405149,26.103347522344389,26.653932700973943,2.1602598354195948,0.12045855131324852,2.4931752887488814E-3,1.0011141553997087E-3,0,0]
[null,null,"non-network",10.818802018850993,11.150466689158371,25.348227871441299,7.6552510667056639,5.8713588368983096,5.6343578620097485,3.3706962494826636,5.5426299471906884,10.349328439807353,9.6717690159632053]
[null,null,"replacement expenditure",26.036773782697189,20.121274805856906,46.101269013635502,47.504580946676732,74.051879074525246,72.074366535760362,17.690972621757705,15.261969656659883,29.241740121645773,27.912791911481467]

{"sheet":"5. Opex","index":8,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[3,1,3,13],[31,1,31,13],[43,1,43,13],[55,1,55,15]]}
[]
[]
[]
[null,"Operating expenditure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[]
[]
[null,"Operating expenditure (opex) includes network operation, maintenance and other non-capital costs incurred by the transmission businesses. Easement taxes applicable to AusNet (T) have been removed."]
[]
[null,"Actual annual opex"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",160.56328698849705,168.81018754920487,183.54564916457593,175.97431269235068,182.31571173633375,175.79972323956821,182.21524511098306,186.35446840677676,196.21443694220815,224.22735388120861,228.0114040240735,233.01851181800785,189.39663075123485]
[null,"Transgrid","NSW",163.38952456569641,162.18959671861091,152.64553840212537,153.16329893304408,172.12131401558338,160.55440815006858,173.0179534479216,159.45571179400054,190.6044958158229,178.4210978880553,176.79518240052792,174.8957909647645,155.01553271059416]
[null,"AusNet (T)","VIC",83.909963693012983,81.515359470232681,74.522021467935176,96.042580824847832,96.316371049346358,88.241264705035093,83.081389445781454,84.703729942746293,89.829262817397094,89.639391057077106,92.895064513460696,89.821037364833202,82.549959280625956]
[null,"ElectraNet","SA",65.46149124658254,69.655524366075468,62.968930636532079,67.592234742339386,69.087167566517152,74.921167154349476,82.457042125526357,78.516526539799088,80.378058479127745,84.484575846035213,89.147780312229855,92.308924482921554,94.008178310544892]
[null,"TasNetworks (T)","TAS",47.943718545196226,49.618268424277886,59.081928073359911,57.547452606006594,57.413234431569933,54.257272125213426,53.372859457960075,50.134729509450842,49.483504709743301,36.808438975840453,39.213849766456754,32.900170935939087,29.250158972152402]
[null,"Total",null,521.26798503898522,531.78893652840179,532.76406774452846,550.31987979858854,577.25379879935053,553.77383537423475,574.14448958817252,559.16516619277354,606.50975876429925,613.58085764821669,626.06328101674865,622.94443556646615,550.22046002515219]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]
[]
[null,"Forecast annual opex"]
[null,"$m 2018","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",122.64012967694804,122.64489173371452,181.9516657703484,182.75864587350551,196.39606571022412,187.76481873936785,193.38917883926931,199.7677976601997,207.36588801652658,212.64335359467279,220.60573734102351,227.00062865611557,200.65339431203952]
[null,"Transgrid","NSW",163.77996018590969,163.25981851464704,162.84089360103548,162.58504013030625,192.85581037872424,186.1145434336398,190.86134979060435,201.67686060899388,203.71338309940555,181.97851579997786,180.74474526683809,185.58183680092841,178.61165149996862]
[null,"AusNet (T)","VIC",104.11802805363519,104.11802805363524,104.11802805363523,103.35046042520484,102.53766704926829,102.51095628836917,101.25513834506798,100.70873507405379,99.343471404986914,90.208427412327239,92.513315960115705,93.283109465827252,93.59258676756815]
[null,"ElectraNet","SA",69.8943492635876,69.8943492635876,69.894349263587515,69.647102642040466,71.830321361092302,74.315289840141872,77.850226633240638,80.806998413833867,87.74518909882282,91.078117852357337,92.732790012055631,97.720432519630677,98.102103517869693]
[null,"TasNetworks (T)","TAS",44.209265288044207,42.56734800573139,38.985666543415384,38.862816236125589,60.518952299699812,61.368305522252115,60.907244178143642,63.783055566447047,63.398350468326733,47.072585901997314,46.430101247071946,46.680544841918071,46.923519541715962]
[null,"Total",null,504.6417324681247,502.48443557131583,557.79060323202202,557.20406530718265,624.13881679900874,612.07391382377068,624.26313778632584,646.74344732352824,661.56628208806853,622.98100056133251,633.02668982710497,650.26655228441996,617.88325563916192]
[]
[null,"Sources:"]
[null,"Forecast opex is sourced from post tax revenue models determined as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as adjusted by the Australian Competition Tribunal. Updates to the models are also taken into account. The forecast opex excludes efficiency carryovers, capex efficiencies items and easement tax. "]

{"sheet":"6. Reliability -outage events","index":9,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,1,3,12],[28,1,32,12],[44,1,44,12]]}
[]
[]
[]
[null,"Network Reliability - Outage events"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reliability is an important component of network performance. Network performance measures form part of the service target performance incentive scheme (STPIS) relevant to the transmission businesses.\n\nLoss of supply events measure the number of times energy is not available for set periods of times to transmission network customers. These thresholds vary for each business between 0.05 and 1.0 system minutes, as outlined in published AER STPIS decisions.\n"]
[]
[]
[]
[]
[]
[null,"Loss of supply events"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,"Powerlink","QLD",2,2,2,2,0,4,1,0,3,1,0,3]
[null,"TransGrid","NSW",2,5,2,3,3,3,3,4,3,4,2,1]
[null,"AusNet (T)","VIC",5,2,1,6,1,0,2,5,1,2,3,0]
[null,"ElectraNet","SA",4,1,4,4,12,7,7,5,4,1,5,4]
[null,"TasNetworks (T)","TAS",16,10,6,8,9,11,10,10,4,3,1,4]
[null,"Total",null,29,20,15,23,25,25,23,24,15,11,11,12]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"7. Reliability -outage duration","index":10,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,1,3,12],[28,1,34,13],[45,1,45,12]]}
[]
[]
[]
[null,"Network Reliability - Outage Duration"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reliability is an important component of network performance. Network performance measures form part of the service target performance incentive scheme (STPIS) relevant to the transmission businesses.\n\nAverage outage duration shows the average length of time of unplanned outages on the transmission network that resulted in a loss of supply event. This includes emergency and extreme events and outages with less than 24 hours notice to affected customers. Outages caused by third party systems, at the direction of emergency services/AEMO, planned outages or transient interruptions of less than a minute are not included in this data.\n\nAverage outage duration is calculated as the total duration of outages divided by the number of events for each network.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,"Average outage duration"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,"Powerlink","QLD",39.034769679999997,1249.94338791,35.289638070000002,62.276197510000003,16.62000158,86.769421570000006,26.086666659999999,5.62142857,115.971,236.2286666,30.06,27.45]
[null,"TransGrid","NSW",64.84,125.4,34.28,84.96,225.83,137.11000000000001,94.23,180.32,71.138000000000005,63.545000000000002,169.17750789999999,35.64]
[null,"AusNet (T)","VIC",61.9,27.6,71.5,103.1,92.5,4,230,19.899999999999999,24,97.5,39.8333333333333,19]
[null,"ElectraNet","SA",88.46,269.94,200.2,161.27000000000001,126.85,242.28,124.76,154.16999999999999,130.71,147,250.57,97]
[null,"TasNetworks (T)","TAS",53.846150000000002,142.7619,112.9,67.157889999999995,127.7692,90.866669999999999,110.88460000000001,160.94120000000001,201,74,15,410]
[]
[null,"Sources:                                                                                                   "]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"8. Market impact","index":11,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,1,3,12],[40,1,40,12],[29,1,29,14]]}
[]
[]
[]
[null,"Quality of Services - Market impact"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Market impact measures the relative disruption of outages on customers. The relative disruption is determined by estimating the impact on energy price in the NEM - if an outage increases the energy price by more than $10/MWh it is counted in the market impact measure. The chart shows the percentage of dispatch intervals where a transmission outage impacted on the energy price.\n\nThe data excludes outages caused by force majeure events, resulting from third party systems, required to maintain personal safety or security, and other specific exclusions.\n"]
[]
[null,"Market impact indicator"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017]
[null,"Powerlink","QLD",3.7376331811263319E-2,2.5275875190258753E-2,1.2480974124809741E-2,9.8744292237442927E-3,1.4830669710806698E-2,3.1773211567732115E-3,2.2355403348554032E-3,9.2275494672754946E-4,3.7490487062404869E-2,6.278538812785388E-4,3.9954337899543381E-4,6.9444444444444447E-4]
[null,"TransGrid","NSW",2.5884703196347031E-2,3.2581811263318113E-2,2.8139269406392695E-2,2.3982115677321156E-2,7.4200913242009128E-3,8.2952815829528161E-3,7.0110350076103504E-3,5.6411719939117198E-3,7.1299467275494676E-3,1.2642694063926941E-2,2.9071537290715373E-2,6.4778348554033485E-2]
[null,"AusNet (T)","VIC",1.1529680365296804E-2,2.546613394216134E-2,3.1421232876712328E-2,1.4421613394216133E-2,2.0918949771689496E-2,3.1601978691019786E-2,2.4809741248097414E-2,1.2813926940639269E-2,8.090753424657534E-3,1.8060312024353119E-2,0.10300608828006089,6.1596270928462711E-2]
[null,"ElectraNet","SA",0.27002473363774732,0.10402397260273973,5.2777777777777778E-2,3.5378614916286147E-2,2.1489726027397259E-2,1.6856925418569254E-2,5.0656392694063926E-2,2.7844368340943684E-2,2.1879756468797563E-3,0.17256468797564689,0.1396689497716895,2.2146118721461189E-2]
[null,"TasNetworks","TAS",2.9490106544901064E-3,5.6668569254185695E-2,3.1963470319634705E-3,9.9124809741248099E-3,3.7775875190258754E-2,6.9349315068493152E-3,1.3375190258751902E-2,1.6999619482496196E-2,1.1700913242009132E-2,2.349695585996956E-3,2.9214231354642312E-2,2.5703957382039573E-2]
[]
[null,"Sources:                                                                                                   "]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"9. Maximum demand","index":12,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,27,14],[39,1,39,13],[42,1,42,13]]}
[]
[]
[]
[null,"Maximum demand"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Maximum demand is reported as the coincident maximum demand on each transmission network. That is, the overall demand at the  point in time when demand on the network was at its highest. Maximum demand information can be used to inform expenditure decisions, and is one of the indicators of demand that the AER uses to assess expenditure proposals."]
[]
[]
[null,"Maximum demand (MW)"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",7336.8405000000002,7758.2674399999996,7281.0681000000004,7848.6144160000003,8002.824568,7797.4507640000002,7740.0070679999999,7681.4389380000002,7637.8836000000001,8105.0587999999998,8272.1218719999997,8547.9858320000003,8788.5806080000002]
[null,"TransGrid","NSW",12600,12400,13200,13700,13200,13700,11900,12700,12100,10900,11900,13200,12200]
[null,"AEMO","VIC",6717.51,7719,8721.3799999999992,9260.43,8974.76,8812.86,8071.43,8410.82,9137.4,7714.9530000000004,8780.0097165999996,7979.8370000000004,8393.9879999999994]
[null,"ElectraNet","SA",2716.662362,2707.0492840000002,2939.8044199999999,3128.41975,3055.21236,3169.0990660000002,2807.6773880000001,2913.5559640000001,3115.1382140000001,2668.4565240000002,2804.4766439999999,2955.0151501099999,2812.0036520499998]
[null,"TasNetworks (T)","TAS",1949.873,2329.5059999999999,2245.0819999999999,2154.23,2267.0709999999999,2238.723,2264.047,2184.59,2132,2143.1571779999999,2218.9,1963.6911299999999,2184.5047559999998]
[]
[]
[null,"Notes:"]
[null,"AEMO 2007 - this data is an average of the reported amounts in 2006 and 2008. AEMO did not provide maximum demand information for 2007."]
[]
[null,"Sources:"]
[null,"Economic benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018; AEMO"]

{"sheet":"10. Energy delivered","index":13,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,13],[38,1,38,15]]}
[]
[]
[]
[null,"Energy delivered"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Energy delivered is a measure of total energy transported through the transmission networks in each year. The information reported includes energy delivered to distribution networks and directly connected end users. Energy delivered to other transmission networks is excluded."]
[]
[null,"Energy delivered (GWh)"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",45060.104981989993,45382.173574879998,45653.437835029996,46906.847428429995,46927.335373220005,45240.660978680004,45394.0430901,45650.659825679999,45145.469261291,46783.452324999998,49089.331985550001,49874.617357620002,48730.430983799]
[null,"TransGrid","NSW",68438.366632749996,69428.257359979994,69631.571031910004,69326.238029019994,68026.11947849,67031.334420269995,65246.150635600003,61547.66818457,59449.885653933998,62950,63300,65100,64900]
[null,"AEMO","VIC",44577.27296196,45321.423887069999,45599.915214890003,44831.923378820007,44951.498645439999,44021.41014778,44017.086091990001,43180.372172119998,42632.210273879995,40806.327471379998,41407.788293259997,39593.532484169998,41497.108406169995]
[null,"ElectraNet","SA",12571.032278840001,13107.23,13107.150414670001,13326.575583190001,13266.263262480001,13362.436968130001,12991.97710577,12928.029809850001,12341,11951.75099,12325.698099020001,11817.0800945133,11749.25906308338]
[null,"TasNetworks (T)","TAS",10084.722000000002,10237.582,10737.609,10688.166000000001,10522.492999999999,10610.152999999998,10267.826000000001,10192.880000000001,9984.3223300000009,10125.004539650001,10029.691638870001,10012.180499653683,10383.594635937006]
[null,"Total",null,180731.49885553998,183476.66682193,184729.68349650002,185079.75041945998,183693.70975963,180265.99551486,177917.08292346,173499.60999222001,169552.88751910499,172616.53532602999,176152.51001669999,176397.41043595699,177260.3930889894]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"11. Circuit length","index":14,"n_rows":57,"n_cols":16,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,13],[56,1,56,13]]}
[]
[]
[]
[null,"Circuit length"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The circuit length data is measured at the end of each regulatory year. It includes both overhead lines and underground cables. Circuit length is always greater than or equal to route length, as a double circuit line that traverses 10 kms is counted as 20 km of circuit length."]
[]
[null,"Circuit length"]
[null,"Km","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",11700.8,11892.8,12428.8,12865.1,13321.1,13738.4,13702.4,14313.5,14772.5,14754.5,14755.5,14532.5,14527.5]
[null,"TransGrid","NSW",12517.231000000002,12526.494000000001,12523.514000000001,12523.349,12682.458999999999,12681.862999999999,12697.206999999999,12893.616999999998,12929.665999999999,13024.7646976,13039.195,13078.1133974,13089.494696939964]
[null,"AusNet (T)","VIC",6573,6573,6573,6573,6573,6573,6573,6573,6573,6573.2,6558.84475673,6559.9720813333333,6623.72]
[null,"ElectraNet","SA",5600.5389999999998,5518.6689999999999,5518.6689999999999,5503.6689999999999,5501.6689999999999,5504.6689999999999,5526.0690000000004,5527.3490000000002,5529.4030540000003,5521.3490000000002,5524.3490000000002,5519.5689999999995,5522.1689999999999]
[null,"TasNetworks (T)","TAS",3581.3,3622.3,3622.3,3520.3,3481.3,3493.3,3493.3,3503.19,3503.8,3563.7000000000003,3563.7000000000003,3563.7,3545.2]
[null,"Total",null,39972.870000000003,40133.263000000006,40666.283000000003,40985.418000000005,41559.528000000006,41991.232000000004,41991.976000000002,42810.656000000003,43308.369054000003,43437.513697599999,43441.588756730001,43253.854478733338,43308.083696939961]
[]
[null,"Circuit length - overhead"]
[null,"Km","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",11685,11877,12413,12848,13304,13717,13681,14292,14751,14733,14734,14511,14506]
[null,"TransGrid","NSW",12469.323000000002,12478.586000000001,12475.606000000002,12475.441000000001,12634.550999999999,12633.955,12649.298999999999,12845.708999999999,12878.228999999999,12942.540697599999,12956.955,12996.5323974,13007.854696939965]
[null,"AusNet (T)","VIC",6562,6562,6562,6562,6562,6562,6562,6562,6562,6562,6547.6447567300002,6551.4297109999998,6615.18]
[null,"ElectraNet","SA",5591.75,5509.88,5509.88,5494.88,5492.88,5495.88,5498.88,5500.16,5502.214054,5494.16,5497.16,5492.37,5494.97]
[null,"TasNetworks (T)","TAS",3568,3609,3609,3507,3468,3480,3480,3480,3480,3539.9,3539.9,3539.8999999999996,3521.3999999999996]
[null,"Total",null,39876.073000000004,40036.466,40569.485999999997,40887.320999999996,41461.430999999997,41888.834999999999,41871.178999999996,42679.869000000006,43173.443054000003,43271.600697599999,43275.659756729998,43091.2321084,43145.404696939971]
[]
[null,"Circuit length - underground"]
[null,"Km","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",15.8,15.8,15.8,17.100000000000001,17.100000000000001,21.4,21.4,21.5,21.500000000000004,21.500000000000004,21.500000000000004,21.500000000000004,21.500000000000004]
[null,"TransGrid","NSW",47.908000000000001,47.908000000000001,47.908000000000001,47.908000000000001,47.908000000000001,47.908000000000001,47.908000000000001,47.908000000000001,51.437000000000005,82.22399999999999,82.24,81.581000000000003,81.64]
[null,"AusNet (T)","VIC",11,11,11,11,11,11,11,11,11,11.2,11.2,8.5423703333333396,8.5399999999999991]
[null,"ElectraNet","SA",8.7889999999999997,8.7889999999999997,8.7889999999999997,8.7889999999999997,8.7889999999999997,8.7889999999999997,27.189,27.189,27.189,27.189,27.189,27.199000000000002,27.199000000000002]
[null,"TasNetworks (T)","TAS",13.3,13.3,13.3,13.3,13.3,13.3,13.3,23.19,23.8,23.8,23.8,23.8,23.8]
[null,"Total",null,96.796999999999997,96.796999999999997,96.796999999999997,98.097000000000008,98.097000000000008,102.39699999999999,120.79699999999998,130.78700000000001,134.92600000000002,165.91300000000001,165.929,162.62237033333335,162.67900000000003]
[]
[null,"Sources:"]
[null,"Economic benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018"]

{"sheet":"12. Return on assets","index":15,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[[57,1,57,11],[56,1,56,11],[3,1,3,11],[18,1,18,10],[47,1,47,11],[49,1,49,11],[50,1,50,11],[51,1,51,11],[52,1,52,11],[53,1,53,11],[54,1,54,11],[55,1,55,11],[58,1,58,11],[59,1,59,11],[60,1,60,11],[63,1,63,11],[64,1,64,11]]}
[]
[]
[]
[null,"Return on assets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The return on assets data shown includes the impact of incentive scheme rewards and penalties. It is a ratio of earnings before interest and tax (EBIT) compared to the asset base (RAB) for each transmission business. When considering the return on assets (ROA) data, please review the AER's explanatory note on interpretation of regulatory ROA ratios."]
[null,"Return on Assets for electricity network businesses - Explanatory Note"]
[]
[]
[null,"Return on assets, including incentive scheme penalties or rewards"]
[null,"%","State","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",6.8920123658946134E-2,5.6147579351566987E-2,6.9815876814477054E-2,9.4779526866631825E-2,5.0937960767351173E-2]
[null,"TransGrid","NSW",7.902087544207255E-2,7.1269527348295461E-2,4.9875403712356457E-2,4.4137936751557819E-2,4.6131810723057547E-2]
[null,"AusNet (T)","Vic",9.4767629663681283E-2,8.0423817923701776E-2,7.2720328904892467E-2,6.5168816528246576E-2,5.9111325621584984E-2]
[null,"ElectraNet","SA",5.8772953652493694E-2,5.8125707014376284E-2,5.8991328463815142E-2,5.6523418216879319E-2,5.941583656586575E-2]
[null,"TasNetworks (T)","Tas",7.591858931174332E-2,7.4468547394089202E-2,6.9779440049587471E-2,5.7936583605475739E-2,6.1722123852800501E-2]
[]
[null,"Return on assets, excluding incentive scheme penalties or rewards"]
[null,"%","State","2014","2015",2016,2017,2018]
[null,"Powerlink","QLD",6.6200565570013761E-2,5.3669436657306197E-2,6.8910590543738034E-2,9.1815261950858804E-2,4.7679595088528579E-2]
[null,"TransGrid","NSW",7.8077663407970677E-2,6.6375290926789204E-2,4.5738671536295926E-2,3.9655306807066401E-2,4.1697279210276036E-2]
[null,"AusNet (T)","Vic",9.0116427368267624E-2,7.2283463983577739E-2,6.3327189650429522E-2,5.858169621229832E-2,5.6109781011416907E-2]
[null,"ElectraNet","SA",5.979369534238789E-2,5.8295564034747976E-2,5.6474111942980548E-2,5.5266935045530451E-2,5.7562297630993055E-2]
[null,"TasNetworks (T)","Tas",7.5408072421250388E-2,6.4623576721286768E-2,6.1323378234656625E-2,4.8857324700602778E-2,5.6570494618788797E-2]
[]
[null,"Real pre-tax WACC"]
[null,"%","State","2014","2015",2016,2017,2018]
[null,"Powerlink","Qld",6.1271060000000002E-2,6.1271060000000002E-2,6.1271060000000002E-2,6.1271060000000002E-2,3.9668282673079001E-2]
[null,"TransGrid","NSW",8.03537E-2,4.8832621186796002E-2,4.7918679869966001E-2,4.7120955203597999E-2,4.6074728455127001E-2]
[null,"AusNet (T)","Vic",7.6632259999999994E-2,5.6151859999999998E-2,5.6151859999999998E-2,5.6151859999999998E-2,3.7202109999999997E-2]
[null,"ElectraNet","SA",5.1799630226234003E-2,5.1799630226234003E-2,5.1799630226234003E-2,5.1799630226234003E-2,5.1799630226234003E-2]
[null,"TasNetworks (T)","Tas",7.9343769999999994E-2,4.3943072676233999E-2,4.2857901474426002E-2,4.2505739261996002E-2,4.1935582222341998E-2]
[]
[null,"Sources:"]
[null,"Roll forward Model     \nPost tax revenue model   \nEconomic benchmarking RIN responses, 2014 - 2018        \nTransmission regulatory accounts 2014 to 2018\n"]
[]
[null,"Notes:"]
[null,"We have calculated the regulatory return on assets (EBIT) measure for each transmission network service provider using the formulae used in our profitability measures review (i.e. EBIT/RAB). The approach and data sources used are detailed below:"]
[null,"• Revenue and expenditures are sourced from the annual Regulatory Accounts (TNSPs) and relate to the core regulated service."]
[null,"• Revenue is adjusted to exclude capital contributions and interest income."]
[null,"• Expenditure is adjusted to exclude depreciation, finance charges and impairment losses."]
[null,"• The depreciation reported in the annual regulatory accounts has been replaced by straight line depreciation."]
[null,"• The closing regulatory asset base is on an as-incurred basis for both DNSPs and TNSPs."]
[null,"• The straight line depreciation recognises assets on an as-commissioned basis and is sourced from the final decision roll forward models (RFM), where available for the relevant regulatory years. In cases where no RFM is available we applied the nominal straight-line depreciation values from the economic benchmarking RIN. Note we will update our analysis as the RFMs become available.  "]
[null,"• The closing regulatory asset base is sourced from the final decision roll forward models (RFM), where available for the relevant regulatory years. If a final decision RFM is not available then we have used the businesses regulatory proposal RFM for the relevant years. In cases where no RFM is available we have used a final decision / updated PTRM for the relevant regulatory years. Note we will update our analysis as the RFMs become available.  "]
[null,"• Incentive payments/penalties have been sourced from the revenue sheet of the economic benchmarking RIN and the return on assets measure has been calculated both with and without incentives so that the impact of incentives on returns can be observed."]
[null,"• The pre-tax real WACC is sourced from the final decision PTRM or an updated PTRM. As noted in our draft position paper we consider actual Return on Assets can be compared against the pre-tax real WACC.  "]
[null,"• All inputs are in nominal dollar values.  "]
[]
[null,"Additional comments provided by Powerlink:"]
[null,"1.  From FY2015 there was a change in the accounting treatment of regulated revenues to report them on an ‘as collected' basis.  Therefore, EBIT reflects the outcome of under / over collections and the impact of IRSR's.  Total undercollections in 2014/15 were $88 M which were subsequently recovered from customers in 2016/17 in accordance with the regulatory framework.  This resulted in a lower EBIT in 2014/15 and a higher result in 2016/17 with a further $50 M of IRSR's received during the 2016/17 financial year. "]
[null,"2.  Due to lower demand than forecast in the AER Final Determination for 2012/13 to 2016/17, Powerlink underspent it's capex allowance.  This has resulted in a lower RAB and higher return on assets during the regulatory period."]

{"sheet":"Data sheet","index":16,"n_rows":213,"n_cols":12,"rows_kept":213,"cut":false,"hidden":false,"merged":[[0,3,0,12]]}
[null,null,null,"This sheet contains the data, as reported in the tables on worksheets 1-12, reformatted for presentation on the Dashboard."]
[]
[]
[null,null,null,"Raw data"]
[]
[null,null,null,"Category","Year","Powerlink","Transgrid","AusNet (T)","ElectraNet","TasNetworks (T)","Transmission total",{"$f":"D6&E6","v":"CategoryYear"}]
[null,null,null,"Actual Revenue","2006",641.12712484478629,621.84236245640568,501.27423359501086,230.27290281480938,156.72563956686338,2151.2422632778757,{"$f":"D7&E7","v":"Actual Revenue2006"}]
[null,null,null,"Actual Revenue","2007",675.48525049510101,641.08297539077489,502.3382352012726,235.63517693874255,162.54405391939477,2217.0856919452858,{"$f":"D8&E8","v":"Actual Revenue2007"}]
[null,null,null,"Actual Revenue","2008",687.93848779847337,663.62650636061051,522.65895584170414,237.91465965680024,166.03053741820685,2278.1691470757951,"Actual Revenue2008"]
[null,null,null,"Actual Revenue","2009",741.87784478298363,704.05023650800945,576.38746313250522,284.02603791959757,177.95517119366912,2484.2967535367652,"Actual Revenue2009"]
[null,null,null,"Actual Revenue","2010",787.37679819077573,811.15276068282174,601.2468487828296,299.3644335846783,199.28774347487939,2698.4285847159849,"Actual Revenue2010"]
[null,null,null,"Actual Revenue","2011",847.91763611880435,861.55431179496543,607.59429385324734,318.22289358663653,234.45231023078225,2869.741445584436,"Actual Revenue2011"]
[null,null,null,"Actual Revenue","2012",935.64561671394279,918.05889258324237,611.66903115655293,338.1663790099887,240.39495839995789,3043.934877863685,"Actual Revenue2012"]
[null,null,null,"Actual Revenue","2013",950.62747120424842,963.54731169618333,625.24771194705875,361.22311790031978,243.41488133804796,3144.060494085858,"Actual Revenue2013"]
[null,null,null,"Actual Revenue","2014",978.17209186033006,952.88682755736556,629.8700498895804,307.51599110148567,233.03288492556339,3101.4778453343251,"Actual Revenue2014"]
[null,null,null,"Actual Revenue","2015",1014.9489978748531,905.88016486472873,611.52794292419458,322.29860167579909,204.49539339740184,3059.1511007369777,"Actual Revenue2015"]
[null,null,null,"Actual Revenue",2016,1028.2098681012305,774.55274018761554,594.22549916996161,335.42463565255872,199.71309560809038,2932.1258387194566,"Actual Revenue2016"]
[null,null,null,"Actual Revenue",2017,1072.0629033721682,746.91056053263389,583.64992335233762,341.40698989569444,179.75166280400288,2923.7820399568373,"Actual Revenue2017"]
[null,null,null,"Actual Revenue",2018,786.56846528128676,719.90105500648178,593.60742190979011,353.29228145537542,180.86028466422923,2634.2295083171634,"Actual Revenue2018"]
[null,null,null,"Actual Closing RAB","2006",4006.141175351519,4305.9915401492708,2549.8522743541266,1371.1437291399277,983.22051203873457,13216.349231033579,"Actual Closing RAB2006"]
[null,null,null,"Actual Closing RAB","2007",4880.044723640387,4423.6830063529151,2538.6043495928816,1408.0323873991083,1056.3511228808579,14306.715589866149,"Actual Closing RAB2007"]
[null,null,null,"Actual Closing RAB","2008",5548.7817151440313,4665.0857113491538,2761.8255169772692,1636.2965057746246,1062.1803400326637,15674.169789277743,"Actual Closing RAB2008"]
[null,null,null,"Actual Closing RAB","2009",6106.657031357463,5140.5339711658908,2747.5463478540159,1692.8675528850686,1159.6753109639853,16847.280214226426,"Actual Closing RAB2009"]
[null,null,null,"Actual Closing RAB","2010",6424.5476214104892,5424.3028425615821,2749.8417143203997,1767.1111662457856,1265.7018868936373,17631.505231431893,"Actual Closing RAB2010"]
[null,null,null,"Actual Closing RAB","2011",6687.7674939445915,5647.2905643955501,2743.4248259493752,1973.8239955775409,1342.0989870071303,18394.405866874193,"Actual Closing RAB2011"]
[null,null,null,"Actual Closing RAB","2012",7246.6714479830607,5839.7856235976851,2758.2331568615341,2103.621408327499,1433.8689359899874,19382.180572759768,"Actual Closing RAB2012"]
[null,null,null,"Actual Closing RAB","2013",7530.6499356665699,6173.520304501938,2811.2949680315214,2275.6732901094056,1469.8762081465843,20261.014706456015,"Actual Closing RAB2013"]
[null,null,null,"Actual Closing RAB","2014",7637.9567302980722,6499.0555494949258,3080.6850399648447,2337.3072909967732,1508.5366072713607,21063.541218025977,"Actual Closing RAB2014"]
[null,null,null,"Actual Closing RAB","2015",7541.5878748808927,6510.011793774107,3086.6620502175456,2364.1476702595155,1479.8497334124834,20982.259122544543,"Actual Closing RAB2015"]
[null,null,null,"Actual Closing RAB",2016,7400.071160754881,6499.44250265349,3078.9982481606803,2432.5408234713764,1447.0179000297592,20858.070635070188,"Actual Closing RAB2016"]
[null,null,null,"Actual Closing RAB",2017,7204.3724818747178,6405.980670585398,3228.2151035745487,2484.8676591745752,1437.8405954469988,20761.27651065624,"Actual Closing RAB2017"]
[null,null,null,"Actual Closing RAB",2018,7113.7580261942076,6371.2252446444118,3242.9792399413614,2560.1560828966099,1430.087000702672,20718.205594379262,"Actual Closing RAB2018"]
[null,null,null,"Forecast Closing RAB","2006",3993.8684511524639,4406.3224739182542,2658.633016606595,1421.1133582648811,981.36974117975331,13461.307041121947,"Forecast Closing RAB2006"]
[null,null,null,"Forecast Closing RAB","2007",3930.7841803477968,4556.0723422077535,2645.0591005501592,1440.4232930920034,1054.826066839873,13627.164983037586,"Forecast Closing RAB2007"]
[null,null,null,"Forecast Closing RAB","2008",5626.0675394756927,4885.7591778833612,2629.1113015290671,1412.7391621433933,1060.7844670783788,15614.461648109893,"Forecast Closing RAB2008"]
[null,null,null,"Forecast Closing RAB","2009",6260.3120023012052,5118.7812770382616,2779.5513672792067,1738.7328208376682,1056.8681930077707,16954.245660464112,"Forecast Closing RAB2009"]
[null,null,null,"Forecast Closing RAB","2010",6592.2593649842402,5598.4172123510889,2783.3032477392903,1901.8470486721146,1301.0738741403384,18176.90074788707,"Forecast Closing RAB2010"]
[null,null,null,"Forecast Closing RAB","2011",6969.5538316851225,5946.4397913118246,2808.6108778196208,2122.1478469433123,1435.9359177654662,19282.688265525347,"Forecast Closing RAB2011"]
[null,null,null,"Forecast Closing RAB","2012",7244.2941735034237,6430.4774773959216,2838.6722702353386,2271.4212908978952,1493.8958681572401,20278.761080189819,"Forecast Closing RAB2012"]
[null,null,null,"Forecast Closing RAB","2013",7796.2383769116432,6837.6300814117294,2842.4194074504344,2289.6427303588644,1552.0770130966398,21318.007609229313,"Forecast Closing RAB2013"]
[null,null,null,"Forecast Closing RAB","2014",8183.1713257040183,7063.6063287095158,2890.0492630623339,2427.0847978674078,1605.5649293903493,22169.476644733622,"Forecast Closing RAB2014"]
[null,null,null,"Forecast Closing RAB","2015",8352.0609268428871,6521.044787337356,3093.6059240136574,2504.5865901455927,1508.4325158027152,21979.730744142213,"Forecast Closing RAB2015"]
[null,null,null,"Forecast Closing RAB",2016,8551.7397417218999,6583.2353092775038,3136.2997393769788,2605.0412830469413,1520.2647106245497,22396.580784047874,"Forecast Closing RAB2016"]
[null,null,null,"Forecast Closing RAB",2017,8806.6294254355598,6556.2067349605104,3173.3546541698202,2637.857615428959,1516.1829293962285,22690.231359391077,"Forecast Closing RAB2017"]
[null,null,null,"Forecast Closing RAB",2018,7113.7580261942076,6530.7033363506844,3242.9792399413614,2596.6142866940777,1503.9187826776722,20987.973671858002,"Forecast Closing RAB2018"]
[null,null,null,"Actual annual capex","2006",361.36092584949688,209.94281689242013,138.44505045399978,92.105803837220421,95.483771774341662,897.33836880747879,"Actual annual capex2006"]
[null,null,null,"Actual annual capex","2007",323.50271442711676,285.37814121958905,141.39719346864993,106.10755361152678,133.02446685304281,989.41006957992533,"Actual annual capex2007"]
[null,null,null,"Actual annual capex","2008",844.28695136158899,408.30944706815615,139.41660171311779,213.73671948950715,79.294859371390928,1685.0445790037609,"Actual annual capex2008"]
[null,null,null,"Actual annual capex","2009",765.13999877046058,701.84368933231633,112.93689360821496,120.03280743535048,82.572056832484989,1782.5254459788271,"Actual annual capex2009"]
[null,null,null,"Actual annual capex","2010",532.82843831741161,486.22161226076082,132.16840583240048,141.09782150877103,159.32134528014612,1451.6376231994898,"Actual annual capex2010"]
[null,null,null,"Actual annual capex","2011",493.3133757121837,422.05775835931831,127.82608754027696,270.30509474632294,134.58308303634797,1448.08539939445,"Actual annual capex2011"]
[null,null,null,"Actual annual capex","2012",716.62238114737659,398.65748353316832,149.98986089683041,205.14206692514972,142.72137917105479,1613.1331716735799,"Actual annual capex2012"]
[null,null,null,"Actual annual capex","2013",498.20295187367446,539.13996327100449,191.57232196432651,249.44067773309084,94.866181002751091,1573.2220958448472,"Actual annual capex2013"]
[null,null,null,"Actual annual capex","2014",342.79752934579636,519.29929609409737,157.59429960302145,142.53994594966309,83.533675339163622,1245.7647463317419,"Actual annual capex2014"]
[null,null,null,"Actual annual capex","2015",169.27416382062097,267.51131178598234,162.1951393927954,120.50767465264327,26.813443614232007,746.30173326627403,"Actual annual capex2015"]
[null,null,null,"Actual annual capex",2016,138.6919963830486,257.85450464819553,145.92300214671698,174.24441961194924,25.837092594152299,742.55101538406268,"Actual annual capex2016"]
[null,null,null,"Actual annual capex",2017,176.91466226076525,189.66437484502785,179.72523536924464,154.76739935322186,52.334114870650694,753.40578669891033,"Actual annual capex2017"]
[null,null,null,"Actual annual capex",2018,150.84443081587133,229.64267232162436,134.93739604185501,176.37645920373106,52.689335787516498,744.4902941705983,"Actual annual capex2018"]
[null,null,null,"Forecast annual capex","2006",271.26259830034519,254.84038939030066,75.348308791863545,116.35138190166751,70.598688461652699,788.40136684582967,"Forecast annual capex2006"]
[null,null,null,"Forecast annual capex","2007",121.4915904481976,307.24061691128566,102.16559245587985,101.52253105961022,116.52452703637546,748.94485791134878,"Forecast annual capex2007"]
[null,null,null,"Forecast annual capex","2008",920.61626496779047,485.38897062415543,103.46386323184038,67.289687520609974,55.036611972793764,1631.7953983171899,"Forecast annual capex2008"]
[null,null,null,"Forecast annual capex","2009",839.80914689167469,406.42816554133975,146.8192859177683,162.04483823800703,45.92710378419342,1601.0285403729831,"Forecast annual capex2009"]
[null,null,null,"Forecast annual capex","2010",556.57298161347808,655.12491678902791,140.54031176875012,222.02675671446318,193.69601506509747,1767.9609819508166,"Forecast annual capex2010"]
[null,null,null,"Forecast annual capex","2011",614.44358650574713,558.40274089747857,166.3159749469263,283.6493584397345,191.48012693866556,1814.291787728552,"Forecast annual capex2011"]
[null,null,null,"Forecast annual capex","2012",523.55732084409647,686.55867289370076,175.69449525767672,218.9246248269769,114.31796890144454,1719.0530827238954,"Forecast annual capex2012"]
[null,null,null,"Forecast annual capex","2013",757.03921674327012,630.99674091619579,154.1312067465247,97.369182751781423,120.18396685207308,1759.7203140098452,"Forecast annual capex2013"]
[null,null,null,"Forecast annual capex","2014",625.08791809686579,474.26327525213571,188.36449880770365,230.48234705223987,119.89951210188674,1638.0975513108319,"Forecast annual capex2014"]
[null,null,null,"Forecast annual capex","2015",445.17578620400309,273.06952418869963,161.28076928955821,166.95664255026239,54.159317636401902,1100.6420398689254,"Forecast annual capex2015"]
[null,null,null,"Forecast annual capex",2016,494.95731751072015,325.8233841503698,194.69786890486606,202.60145315715445,68.95008790120427,1287.0301116243149,"Forecast annual capex2016"]
[null,null,null,"Forecast annual capex",2017,560.43533391269864,251.72180593400242,193.66941446448143,145.42001531668859,56.443189991713631,1207.6897596195845,"Forecast annual capex2017"]
[null,null,null,"Forecast annual capex",2018,167.60949239008738,235.09362804522729,183.76580752835386,74.270416378279108,47.631667915959483,708.37101225790718,"Forecast annual capex2018"]
[null,null,null,"Actual annual opex","2006",160.56328698849705,163.38952456569641,83.909963693012983,65.46149124658254,47.943718545196226,521.26798503898522,{"$f":"D72&E72","v":"Actual annual opex2006"}]
[null,null,null,"Actual annual opex","2007",168.81018754920487,162.18959671861091,81.515359470232681,69.655524366075468,49.618268424277886,531.78893652840179,"Actual annual opex2007"]
[null,null,null,"Actual annual opex","2008",183.54564916457593,152.64553840212537,74.522021467935176,62.968930636532079,59.081928073359911,532.76406774452846,"Actual annual opex2008"]
[null,null,null,"Actual annual opex","2009",175.97431269235068,153.16329893304408,96.042580824847832,67.592234742339386,57.547452606006594,550.31987979858854,"Actual annual opex2009"]
[null,null,null,"Actual annual opex","2010",182.31571173633375,172.12131401558338,96.316371049346358,69.087167566517152,57.413234431569933,577.25379879935053,"Actual annual opex2010"]
[null,null,null,"Actual annual opex","2011",175.79972323956821,160.55440815006858,88.241264705035093,74.921167154349476,54.257272125213426,553.77383537423475,"Actual annual opex2011"]
[null,null,null,"Actual annual opex","2012",182.21524511098306,173.0179534479216,83.081389445781454,82.457042125526357,53.372859457960075,574.14448958817252,"Actual annual opex2012"]
[null,null,null,"Actual annual opex","2013",186.35446840677676,159.45571179400054,84.703729942746293,78.516526539799088,50.134729509450842,559.16516619277354,"Actual annual opex2013"]
[null,null,null,"Actual annual opex","2014",196.21443694220815,190.6044958158229,89.829262817397094,80.378058479127745,49.483504709743301,606.50975876429925,"Actual annual opex2014"]
[null,null,null,"Actual annual opex","2015",224.22735388120861,178.4210978880553,89.639391057077106,84.484575846035213,36.808438975840453,613.58085764821669,"Actual annual opex2015"]
[null,null,null,"Actual annual opex",2016,228.0114040240735,176.79518240052792,92.895064513460696,89.147780312229855,39.213849766456754,626.06328101674865,"Actual annual opex2016"]
[null,null,null,"Actual annual opex",2017,233.01851181800785,174.8957909647645,89.821037364833202,92.308924482921554,32.900170935939087,622.94443556646615,"Actual annual opex2017"]
[null,null,null,"Actual annual opex",2018,189.39663075123485,155.01553271059416,82.549959280625956,94.008178310544892,29.250158972152402,550.22046002515219,"Actual annual opex2018"]
[null,null,null,"Forecast annual opex","2006",122.64012967694804,163.77996018590969,104.11802805363519,69.8943492635876,44.209265288044207,504.6417324681247,"Forecast annual opex2006"]
[null,null,null,"Forecast annual opex","2007",122.64489173371452,163.25981851464704,104.11802805363524,69.8943492635876,42.56734800573139,502.48443557131583,"Forecast annual opex2007"]
[null,null,null,"Forecast annual opex","2008",181.9516657703484,162.84089360103548,104.11802805363523,69.894349263587515,38.985666543415384,557.79060323202202,"Forecast annual opex2008"]
[null,null,null,"Forecast annual opex","2009",182.75864587350551,162.58504013030625,103.35046042520484,69.647102642040466,38.862816236125589,557.20406530718265,"Forecast annual opex2009"]
[null,null,null,"Forecast annual opex","2010",196.39606571022412,192.85581037872424,102.53766704926829,71.830321361092302,60.518952299699812,624.13881679900874,"Forecast annual opex2010"]
[null,null,null,"Forecast annual opex","2011",187.76481873936785,186.1145434336398,102.51095628836917,74.315289840141872,61.368305522252115,612.07391382377068,"Forecast annual opex2011"]
[null,null,null,"Forecast annual opex","2012",193.38917883926931,190.86134979060435,101.25513834506798,77.850226633240638,60.907244178143642,624.26313778632584,"Forecast annual opex2012"]
[null,null,null,"Forecast annual opex","2013",199.7677976601997,201.67686060899388,100.70873507405379,80.806998413833867,63.783055566447047,646.74344732352824,"Forecast annual opex2013"]
[null,null,null,"Forecast annual opex","2014",207.36588801652658,203.71338309940555,99.343471404986914,87.74518909882282,63.398350468326733,661.56628208806853,"Forecast annual opex2014"]
[null,null,null,"Forecast annual opex","2015",212.64335359467279,181.97851579997786,90.208427412327239,91.078117852357337,47.072585901997314,622.98100056133251,"Forecast annual opex2015"]
[null,null,null,"Forecast annual opex",2016,220.60573734102351,180.74474526683809,92.513315960115705,92.732790012055631,46.430101247071946,633.02668982710497,"Forecast annual opex2016"]
[null,null,null,"Forecast annual opex",2017,227.00062865611557,185.58183680092841,93.283109465827252,97.720432519630677,46.680544841918071,650.26655228441996,"Forecast annual opex2017"]
[null,null,null,"Forecast annual opex",2018,200.65339431203952,178.61165149996862,93.59258676756815,98.102103517869693,46.923519541715962,617.88325563916192,"Forecast annual opex2018"]
[null,null,null,"Loss of supply events",2006,2,2,5,4,16,29,"Loss of supply events2006"]
[null,null,null,"Loss of supply events",2007,2,5,2,1,10,20,"Loss of supply events2007"]
[null,null,null,"Loss of supply events",2008,2,2,1,4,6,15,"Loss of supply events2008"]
[null,null,null,"Loss of supply events",2009,2,3,6,4,8,23,"Loss of supply events2009"]
[null,null,null,"Loss of supply events",2010,0,3,1,12,9,25,"Loss of supply events2010"]
[null,null,null,"Loss of supply events",2011,4,3,0,7,11,25,"Loss of supply events2011"]
[null,null,null,"Loss of supply events",2012,1,3,2,7,10,23,"Loss of supply events2012"]
[null,null,null,"Loss of supply events",2013,0,4,5,5,10,24,"Loss of supply events2013"]
[null,null,null,"Loss of supply events",2014,3,3,1,4,4,15,"Loss of supply events2014"]
[null,null,null,"Loss of supply events",2015,1,4,2,1,3,11,"Loss of supply events2015"]
[null,null,null,"Loss of supply events",2016,0,2,3,5,1,11,"Loss of supply events2016"]
[null,null,null,"Loss of supply events",2017,3,1,0,4,4,12,"Loss of supply events2017"]
[null,null,null,"Average outage duration",2006,39.034769679999997,64.84,61.9,88.46,53.846150000000002,null,"Average outage duration2006"]
[null,null,null,"Average outage duration",2007,1249.94338791,125.4,27.6,269.94,142.7619,null,"Average outage duration2007"]
[null,null,null,"Average outage duration",2008,35.289638070000002,34.28,71.5,200.2,112.9,null,"Average outage duration2008"]
[null,null,null,"Average outage duration",2009,62.276197510000003,84.96,103.1,161.27000000000001,67.157889999999995,null,"Average outage duration2009"]
[null,null,null,"Average outage duration",2010,16.62000158,225.83,92.5,126.85,127.7692,null,"Average outage duration2010"]
[null,null,null,"Average outage duration",2011,86.769421570000006,137.11000000000001,4,242.28,90.866669999999999,null,"Average outage duration2011"]
[null,null,null,"Average outage duration",2012,26.086666659999999,94.23,230,124.76,110.88460000000001,null,"Average outage duration2012"]
[null,null,null,"Average outage duration",2013,5.62142857,180.32,19.899999999999999,154.16999999999999,160.94120000000001,null,"Average outage duration2013"]
[null,null,null,"Average outage duration",2014,115.971,71.138000000000005,24,130.71,201,null,"Average outage duration2014"]
[null,null,null,"Average outage duration",2015,236.2286666,63.545000000000002,97.5,147,74,null,"Average outage duration2015"]
[null,null,null,"Average outage duration",2016,30.06,169.17750789999999,39.8333333333333,250.57,15,null,"Average outage duration2016"]
[null,null,null,"Average outage duration",2017,27.45,35.64,19,97,410,null,"Average outage duration2017"]
[null,null,null,"Market impact indicator",2006,3.7376331811263319E-2,2.5884703196347031E-2,1.1529680365296804E-2,0.27002473363774732,2.9490106544901064E-3,null,"Market impact indicator2006"]
[null,null,null,"Market impact indicator",2007,2.5275875190258753E-2,3.2581811263318113E-2,2.546613394216134E-2,0.10402397260273973,5.6668569254185695E-2,null,"Market impact indicator2007"]
[null,null,null,"Market impact indicator",2008,1.2480974124809741E-2,2.8139269406392695E-2,3.1421232876712328E-2,5.2777777777777778E-2,3.1963470319634705E-3,null,"Market impact indicator2008"]
[null,null,null,"Market impact indicator",2009,9.8744292237442927E-3,2.3982115677321156E-2,1.4421613394216133E-2,3.5378614916286147E-2,9.9124809741248099E-3,null,"Market impact indicator2009"]
[null,null,null,"Market impact indicator",2010,1.4830669710806698E-2,7.4200913242009128E-3,2.0918949771689496E-2,2.1489726027397259E-2,3.7775875190258754E-2,null,"Market impact indicator2010"]
[null,null,null,"Market impact indicator",2011,3.1773211567732115E-3,8.2952815829528161E-3,3.1601978691019786E-2,1.6856925418569254E-2,6.9349315068493152E-3,null,"Market impact indicator2011"]
[null,null,null,"Market impact indicator",2012,2.2355403348554032E-3,7.0110350076103504E-3,2.4809741248097414E-2,5.0656392694063926E-2,1.3375190258751902E-2,null,"Market impact indicator2012"]
[null,null,null,"Market impact indicator",2013,9.2275494672754946E-4,5.6411719939117198E-3,1.2813926940639269E-2,2.7844368340943684E-2,1.6999619482496196E-2,null,"Market impact indicator2013"]
[null,null,null,"Market impact indicator",2014,3.7490487062404869E-2,7.1299467275494676E-3,8.090753424657534E-3,2.1879756468797563E-3,1.1700913242009132E-2,null,"Market impact indicator2014"]
[null,null,null,"Market impact indicator",2015,6.278538812785388E-4,1.2642694063926941E-2,1.8060312024353119E-2,0.17256468797564689,2.349695585996956E-3,null,"Market impact indicator2015"]
[null,null,null,"Market impact indicator",2016,3.9954337899543381E-4,2.9071537290715373E-2,0.10300608828006089,0.1396689497716895,2.9214231354642312E-2,null,"Market impact indicator2016"]
[null,null,null,"Market impact indicator",2017,6.9444444444444447E-4,6.4778348554033485E-2,6.1596270928462711E-2,2.2146118721461189E-2,2.5703957382039573E-2,null,"Market impact indicator2017"]
[null,null,null,"Maximum demand (MW)","2006",7336.8405000000002,12600,6717.51,2716.662362,1949.873,null,"Maximum demand (MW)2006"]
[null,null,null,"Maximum demand (MW)","2007",7758.2674399999996,12400,7719,2707.0492840000002,2329.5059999999999,null,"Maximum demand (MW)2007"]
[null,null,null,"Maximum demand (MW)","2008",7281.0681000000004,13200,8721.3799999999992,2939.8044199999999,2245.0819999999999,null,{"$f":"D136&E136","v":"Maximum demand (MW)2008"}]
[null,null,null,"Maximum demand (MW)","2009",7848.6144160000003,13700,9260.43,3128.41975,2154.23,null,"Maximum demand (MW)2009"]
[null,null,null,"Maximum demand (MW)","2010",8002.824568,13200,8974.76,3055.21236,2267.0709999999999,null,"Maximum demand (MW)2010"]
[null,null,null,"Maximum demand (MW)","2011",7797.4507640000002,13700,8812.86,3169.0990660000002,2238.723,null,"Maximum demand (MW)2011"]
[null,null,null,"Maximum demand (MW)","2012",7740.0070679999999,11900,8071.43,2807.6773880000001,2264.047,null,"Maximum demand (MW)2012"]
[null,null,null,"Maximum demand (MW)","2013",7681.4389380000002,12700,8410.82,2913.5559640000001,2184.59,null,"Maximum demand (MW)2013"]
[null,null,null,"Maximum demand (MW)","2014",7637.8836000000001,12100,9137.4,3115.1382140000001,2132,null,"Maximum demand (MW)2014"]
[null,null,null,"Maximum demand (MW)","2015",8105.0587999999998,10900,7714.9530000000004,2668.4565240000002,2143.1571779999999,null,"Maximum demand (MW)2015"]
[null,null,null,"Maximum demand (MW)",2016,8272.1218719999997,11900,8780.0097165999996,2804.4766439999999,2218.9,null,"Maximum demand (MW)2016"]
[null,null,null,"Maximum demand (MW)",2017,8547.9858320000003,13200,7979.8370000000004,2955.0151501099999,1963.6911299999999,null,"Maximum demand (MW)2017"]
[null,null,null,"Maximum demand (MW)",2018,8788.5806080000002,12200,8393.9879999999994,2812.0036520499998,2184.5047559999998,null,"Maximum demand (MW)2018"]
[null,null,null,"Energy delivered (GWh)","2006",45060.104981989993,68438.366632749996,44577.27296196,12571.032278840001,10084.722000000002,180731.49885553998,"Energy delivered (GWh)2006"]
[null,null,null,"Energy delivered (GWh)","2007",45382.173574879998,69428.257359979994,45321.423887069999,13107.23,10237.582,183476.66682193,"Energy delivered (GWh)2007"]
[null,null,null,"Energy delivered (GWh)","2008",45653.437835029996,69631.571031910004,45599.915214890003,13107.150414670001,10737.609,184729.68349650002,"Energy delivered (GWh)2008"]
[null,null,null,"Energy delivered (GWh)","2009",46906.847428429995,69326.238029019994,44831.923378820007,13326.575583190001,10688.166000000001,185079.75041945998,"Energy delivered (GWh)2009"]
[null,null,null,"Energy delivered (GWh)","2010",46927.335373220005,68026.11947849,44951.498645439999,13266.263262480001,10522.492999999999,183693.70975963,"Energy delivered (GWh)2010"]
[null,null,null,"Energy delivered (GWh)","2011",45240.660978680004,67031.334420269995,44021.41014778,13362.436968130001,10610.152999999998,180265.99551486,"Energy delivered (GWh)2011"]
[null,null,null,"Energy delivered (GWh)","2012",45394.0430901,65246.150635600003,44017.086091990001,12991.97710577,10267.826000000001,177917.08292346,"Energy delivered (GWh)2012"]
[null,null,null,"Energy delivered (GWh)","2013",45650.659825679999,61547.66818457,43180.372172119998,12928.029809850001,10192.880000000001,173499.60999222001,"Energy delivered (GWh)2013"]
[null,null,null,"Energy delivered (GWh)","2014",45145.469261291,59449.885653933998,42632.210273879995,12341,9984.3223300000009,169552.88751910499,"Energy delivered (GWh)2014"]
[null,null,null,"Energy delivered (GWh)","2015",46783.452324999998,62950,40806.327471379998,11951.75099,10125.004539650001,172616.53532602999,"Energy delivered (GWh)2015"]
[null,null,null,"Energy delivered (GWh)",2016,49089.331985550001,63300,41407.788293259997,12325.698099020001,10029.691638870001,176152.51001669999,"Energy delivered (GWh)2016"]
[null,null,null,"Energy delivered (GWh)",2017,49874.617357620002,65100,39593.532484169998,11817.0800945133,10012.180499653683,176397.41043595699,"Energy delivered (GWh)2017"]
[null,null,null,"Energy delivered (GWh)",2018,48730.430983799,64900,41497.108406169995,11749.25906308338,10383.594635937006,177260.3930889894,"Energy delivered (GWh)2018"]
[null,null,null,"Circuit length","2006",11700.8,12517.231000000002,6573,5600.5389999999998,3581.3,39972.870000000003,"Circuit length2006"]
[null,null,null,"Circuit length","2007",11892.8,12526.494000000001,6573,5518.6689999999999,3622.3,40133.263000000006,"Circuit length2007"]
[null,null,null,"Circuit length","2008",12428.8,12523.514000000001,6573,5518.6689999999999,3622.3,40666.283000000003,"Circuit length2008"]
[null,null,null,"Circuit length","2009",12865.1,12523.349,6573,5503.6689999999999,3520.3,40985.418000000005,"Circuit length2009"]
[null,null,null,"Circuit length","2010",13321.1,12682.458999999999,6573,5501.6689999999999,3481.3,41559.528000000006,"Circuit length2010"]
[null,null,null,"Circuit length","2011",13738.4,12681.862999999999,6573,5504.6689999999999,3493.3,41991.232000000004,"Circuit length2011"]
[null,null,null,"Circuit length","2012",13702.4,12697.206999999999,6573,5526.0690000000004,3493.3,41991.976000000002,"Circuit length2012"]
[null,null,null,"Circuit length","2013",14313.5,12893.616999999998,6573,5527.3490000000002,3503.19,42810.656000000003,"Circuit length2013"]
[null,null,null,"Circuit length","2014",14772.5,12929.665999999999,6573,5529.4030540000003,3503.8,43308.369054000003,"Circuit length2014"]
[null,null,null,"Circuit length","2015",14754.5,13024.7646976,6573.2,5521.3490000000002,3563.7000000000003,43437.513697599999,"Circuit length2015"]
[null,null,null,"Circuit length",2016,14755.5,13039.195,6558.84475673,5524.3490000000002,3563.7000000000003,43441.588756730001,"Circuit length2016"]
[null,null,null,"Circuit length",2017,14532.5,13078.1133974,6559.9720813333333,5519.5689999999995,3563.7,43253.854478733338,"Circuit length2017"]
[null,null,null,"Circuit length",2018,14527.5,13089.494696939964,6623.72,5522.1689999999999,3545.2,43308.083696939961,"Circuit length2018"]
[null,null,null,"Circuit length - overhead","2006",11685,12469.323000000002,6562,5591.75,3568,39876.073000000004,"Circuit length - overhead2006"]
[null,null,null,"Circuit length - overhead","2007",11877,12478.586000000001,6562,5509.88,3609,40036.466,"Circuit length - overhead2007"]
[null,null,null,"Circuit length - overhead","2008",12413,12475.606000000002,6562,5509.88,3609,40569.485999999997,"Circuit length - overhead2008"]
[null,null,null,"Circuit length - overhead","2009",12848,12475.441000000001,6562,5494.88,3507,40887.320999999996,"Circuit length - overhead2009"]
[null,null,null,"Circuit length - overhead","2010",13304,12634.550999999999,6562,5492.88,3468,41461.430999999997,"Circuit length - overhead2010"]
[null,null,null,"Circuit length - overhead","2011",13717,12633.955,6562,5495.88,3480,41888.834999999999,"Circuit length - overhead2011"]
[null,null,null,"Circuit length - overhead","2012",13681,12649.298999999999,6562,5498.88,3480,41871.178999999996,"Circuit length - overhead2012"]
[null,null,null,"Circuit length - overhead","2013",14292,12845.708999999999,6562,5500.16,3480,42679.869000000006,"Circuit length - overhead2013"]
[null,null,null,"Circuit length - overhead","2014",14751,12878.228999999999,6562,5502.214054,3480,43173.443054000003,"Circuit length - overhead2014"]
[null,null,null,"Circuit length - overhead","2015",14733,12942.540697599999,6562,5494.16,3539.9,43271.600697599999,"Circuit length - overhead2015"]
[null,null,null,"Circuit length - overhead",2016,14734,12956.955,6547.6447567300002,5497.16,3539.9,43275.659756729998,"Circuit length - overhead2016"]
[null,null,null,"Circuit length - overhead",2017,14511,12996.5323974,6551.4297109999998,5492.37,3539.8999999999996,43091.2321084,"Circuit length - overhead2017"]
[null,null,null,"Circuit length - overhead",2018,14506,13007.854696939965,6615.18,5494.97,3521.3999999999996,43145.404696939971,"Circuit length - overhead2018"]
[null,null,null,"Circuit length - underground","2006",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2006"]
[null,null,null,"Circuit length - underground","2007",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2007"]
[null,null,null,"Circuit length - underground","2008",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2008"]
[null,null,null,"Circuit length - underground","2009",17.100000000000001,47.908000000000001,11,8.7889999999999997,13.3,98.097000000000008,"Circuit length - underground2009"]
[null,null,null,"Circuit length - underground","2010",17.100000000000001,47.908000000000001,11,8.7889999999999997,13.3,98.097000000000008,"Circuit length - underground2010"]
[null,null,null,"Circuit length - underground","2011",21.4,47.908000000000001,11,8.7889999999999997,13.3,102.39699999999999,"Circuit length - underground2011"]
[null,null,null,"Circuit length - underground","2012",21.4,47.908000000000001,11,27.189,13.3,120.79699999999998,"Circuit length - underground2012"]
[null,null,null,"Circuit length - underground","2013",21.5,47.908000000000001,11,27.189,23.19,130.78700000000001,"Circuit length - underground2013"]
[null,null,null,"Circuit length - underground","2014",21.500000000000004,51.437000000000005,11,27.189,23.8,134.92600000000002,"Circuit length - underground2014"]
[null,null,null,"Circuit length - underground","2015",21.500000000000004,82.22399999999999,11.2,27.189,23.8,165.91300000000001,"Circuit length - underground2015"]
[null,null,null,"Circuit length - underground",2016,21.500000000000004,82.24,11.2,27.189,23.8,165.929,"Circuit length - underground2016"]
[null,null,null,"Circuit length - underground",2017,21.500000000000004,81.581000000000003,8.5423703333333396,27.199000000000002,23.8,162.62237033333335,"Circuit length - underground2017"]
[null,null,null,"Circuit length - underground",2018,21.500000000000004,81.64,8.5399999999999991,27.199000000000002,23.8,162.67900000000003,"Circuit length - underground2018"]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards","2014",6.8920123658946134E-2,7.902087544207255E-2,9.4767629663681283E-2,5.8772953652493694E-2,7.591858931174332E-2,null,"Return on assets, including incentive scheme penalties or rewards2014"]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards","2015",5.6147579351566987E-2,7.1269527348295461E-2,8.0423817923701776E-2,5.8125707014376284E-2,7.4468547394089202E-2,null,{"$f":"D200&E200","v":"Return on assets, including incentive scheme penalties or rewards2015"}]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards",2016,6.9815876814477054E-2,4.9875403712356457E-2,7.2720328904892467E-2,5.8991328463815142E-2,6.9779440049587471E-2,null,"Return on assets, including incentive scheme penalties or rewards2016"]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards",2017,9.4779526866631825E-2,4.4137936751557819E-2,6.5168816528246576E-2,5.6523418216879319E-2,5.7936583605475739E-2,null,"Return on assets, including incentive scheme penalties or rewards2017"]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards",2018,5.0937960767351173E-2,4.6131810723057547E-2,5.9111325621584984E-2,5.941583656586575E-2,6.1722123852800501E-2,null,"Return on assets, including incentive scheme penalties or rewards2018"]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards","2014",6.6200565570013761E-2,7.8077663407970677E-2,9.0116427368267624E-2,5.979369534238789E-2,7.5408072421250388E-2,null,"Return on assets, excluding incentive scheme penalties or rewards2014"]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards","2015",5.3669436657306197E-2,6.6375290926789204E-2,7.2283463983577739E-2,5.8295564034747976E-2,6.4623576721286768E-2,null,"Return on assets, excluding incentive scheme penalties or rewards2015"]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards",2016,6.8910590543738034E-2,4.5738671536295926E-2,6.3327189650429522E-2,5.6474111942980548E-2,6.1323378234656625E-2,null,"Return on assets, excluding incentive scheme penalties or rewards2016"]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards",2017,9.1815261950858804E-2,3.9655306807066401E-2,5.858169621229832E-2,5.5266935045530451E-2,4.8857324700602778E-2,null,"Return on assets, excluding incentive scheme penalties or rewards2017"]
[null,null,null,"Return on assets, excluding incentive scheme penalties or rewards",2018,4.7679595088528579E-2,4.1697279210276036E-2,5.6109781011416907E-2,5.7562297630993055E-2,5.6570494618788797E-2,null,"Return on assets, excluding incentive scheme penalties or rewards2018"]
[null,null,null,"Real pre-tax WACC","2014",6.1271060000000002E-2,8.03537E-2,7.6632259999999994E-2,5.1799630226234003E-2,7.9343769999999994E-2,null,"Real pre-tax WACC2014"]
[null,null,null,"Real pre-tax WACC","2015",6.1271060000000002E-2,4.8832621186796002E-2,5.6151859999999998E-2,5.1799630226234003E-2,4.3943072676233999E-2,null,"Real pre-tax WACC2015"]
[null,null,null,"Real pre-tax WACC",2016,6.1271060000000002E-2,4.7918679869966001E-2,5.6151859999999998E-2,5.1799630226234003E-2,4.2857901474426002E-2,null,"Real pre-tax WACC2016"]
[null,null,null,"Real pre-tax WACC",2017,6.1271060000000002E-2,4.7120955203597999E-2,5.6151859999999998E-2,5.1799630226234003E-2,4.2505739261996002E-2,null,"Real pre-tax WACC2017"]
[null,null,null,"Real pre-tax WACC",2018,3.9668282673079001E-2,4.6074728455127001E-2,3.7202109999999997E-2,5.1799630226234003E-2,4.1935582222341998E-2,null,"Real pre-tax WACC2018"]