{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Introduction","Contents","Dashboard","Calculations","New data sheet","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"],"not_rendered":{"charts":22,"images":3,"macros":1,"external_links":2,"defined_names":68,"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":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,2,10,14],[16,2,16,14],[12,2,13,14]]}
[]
[null,null,null,"Electricity Transmission Network Service Provider"]
[null,null,"Operational Performance Data"]
[]
[]
[null,"Introduction"]
[]
[]
[]
[]
[null,null,"This workbook contains operational 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 operational performance measures.  "]
[null,null,"Interpretation"]
[null,null,"The data covers the regulatory years from 2006 to 2022. 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 2022 dollars (or March 2022 dollars for AusNet (T))."]
[]
[]
[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,8,"21 July 2023",null,"Financial years",null,"2005-06 to 2021-22",null,"Data updates"]
[null,null,7,"7 July 2023",null,"Financial years",null,"2005-06 to 2021-22",null,"Data as at 30 June 2022"]
[null,null,6,"July 2022",null,"Financial years ",null,"2005-06 to 2020-21",null,"Data as at 30 June 2021"]
[null,null,5,"2021-09-22",null,"Financial years",null,"2005-06 to 2019-20",null,"Data as at 30 June 2020"]
[null,null,4,"2020-09-01",null,"Financial years",null,"2005-06 to 2018-19",null,"Data as at June 2020"]
[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":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[23,2,23,8],[12,2,12,8],[13,2,13,8],[14,2,14,8],[15,2,15,8],[16,2,16,8]]}
[]
[]
[null,null,null,null,null,null,null,"Electricity Transmission Network Service Provider"]
[null,"Operational Performance Data"]
[]
[null,"Contents"]
[]
[]
[]
[]
[]
[]
[null,null,"1. Revenue"]
[null,null,"2. Regulated asset base - closing"]
[null,null,"3. Capital expenditure"]
[null,null,"4. Capital expenditure by driver"]
[null,null,"5. Operating expenditure"]
[null,null,"6. Reliability - outage evetns"]
[null,null,"7. Reliability - outage duration"]
[null,null,"8. Reliabilty - market impact"]
[null,null,"9. Maximum demand"]
[null,null,"10 . Energy delivered"]
[null,null,"11. Circuit length"]

{"sheet":"Dashboard","index":2,"n_rows":126,"n_cols":17,"rows_kept":126,"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,2022,"5 year trend"]
[null,null,null,null,null,null,"Actual revenue from customers",{"$f":"\"$\"&TEXT(Calculations!U10,\"#,##0\")&\"m\"","v":"$2,459m"}]
[null,null,null,null,null,null,"Budgeted revenue from customers",{"$f":"\"$\"&TEXT(Calculations!U11,\"#,##0\")&\"m\"","v":"$2,584m"}]
[null,null,null,null,null,null,"Actual closing RAB",{"$f":"\"$\"&TEXT(Calculations!U12,\"#,##0\")&\"m\"","v":"$22,828m"}]
[null,null,null,null,null,null,"Forecast closing RAB",{"$f":"\"$\"&TEXT(Calculations!U13,\"#,##0\")&\"m\"","v":"$23,811m"}]
[null,null,null,null,null,null,"Actual annual capex",{"$f":"\"$\"&TEXT(Calculations!U14,\"#,##0\")&\"m\"","v":"$1,250m"}]
[null,null,null,null,null,null,"Forecast annual capex",{"$f":"\"$\"&TEXT(Calculations!U15,\"#,##0\")&\"m\"","v":"$2,148m"}]
[null,null,null,null,null,null,"Actual annual opex",{"$f":"\"$\"&TEXT(Calculations!U16,\"#,##0\")&\"m\"","v":"$617m"}]
[null,null,null,null,null,null,"Forecast annual opex",{"$f":"\"$\"&TEXT(Calculations!U17,\"#,##0\")&\"m\"","v":"$658m"}]
[null,null,null,null,null,null,"Loss of supply events",{"$f":"TEXT(Calculations!T18,\"0\")&\" events\"","v":"5 events"}]
[null,null,null,null,null,null,"Average outage duration",{"$f":"IF(Calculations!T19>0,TEXT(Calculations!T19,\"0\")&\" minutes\",\"not reported\")","v":"not reported"}]
[null,null,null,null,null,null,"Market impact indicator",{"$f":"IF(Calculations!T20>0,TEXT(Calculations!T20,\"0.0%\"),\"not reported\")","v":"not reported"}]
[null,null,null,null,null,null,"Maximum demand",{"$f":"IF(Calculations!U21>0,(TEXT(Calculations!U21,\"000\")&\"MW\"),\"not reported\")","v":"not reported"}]
[null,null,null,null,null,null,"Energy delivered (Individual)",{"$f":"IF($F$3=\"Transmission Total\",\"n/a\", TEXT(Calculations!U22,\"0,00\")&\" GWh\")","v":"n/a"}]
[null,null,null,null,null,null,"Energy delivered (Transmission total)",{"$f":"IF($F$3=\"Transmission Total\",TEXT(Calculations!U23,\"0,00\")&\" GWh\",\"n/a\")","v":"170,661 GWh"}]
[null,null,null,null,null,null,"Circuit length - total",{"$f":"TEXT(Calculations!U24,\"0,00\")&\"km\"","v":"43,118km"}]
[null,null,null,null,null,null,"Circuit length - overhead",{"$f":"TEXT(Calculations!U25,\"0,00\")&\"km\"","v":"42,931km"}]
[null,null,null,null,null,null,"Circuit length - underground",{"$f":"TEXT(Calculations!U26,\"0,0\")&\"km\"","v":"186km"}]
[]
[]
[]
[]
[]
[null,null,"Financials"]
[]
[null,null,"Annual revenue",null,null,null,null,null,null,"Closing RAB"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"IF($F$3=\"transmission total\", \"\", \"Reliability - outage duration\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"\", \"Market impact\")","v":""}]
[null,null,{"$f":"IF(Calculations!S18<>\"\", \"\",IFERROR(Calculations!S18,\"No Data for 2020\"))","v":""},null,null,null,null,{"$f":"IF(Calculations!S19<>\"\", \"\",IFERROR(Calculations!S19,\"No Data for 2020\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Calculations!S20<>\"\", \"\",IFERROR(Calculations!S20,\"No Data for 2020\"))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Network Descriptors"]
[]
[]
[null,null,"Energy delivered",null,null,null,null,"Circuit Length",null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\", \"\", \"Maximum demand\")","v":""}]
[null,null,{"$f":"IF(F3=\"Transmission total\", \"No data for Transmission total - Maximum demand\", \"\")","v":"No data for Transmission total - Maximum demand"}]

{"sheet":"Calculations","index":3,"n_rows":36,"n_cols":21,"rows_kept":36,"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 from customers",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1898.8674679313026},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1963.741979457031},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2045.0735114914733},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2193.2704689620705},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2519.8664941968477},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2790.8799260823926},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2991.8646952906356},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":3104.589567869225},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2928.5686436238666},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2929.4181787455759},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2908.0555896820615},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2936.0939186686005},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2448.703326872891},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2279.004949705517},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2337.7092501811862},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2398.1214873528493},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D10&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2458.7968573385183}]
[null,null,null,"Budgeted revenue from Customers",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":3027.7675534739656},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":3108.5301649767757},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":3071.9094682440532},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2551.3155510387724},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2311.8800844527309},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2461.5087252772355},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2539.0602115121287},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D11&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2583.9037616140085}]
[null,null,null,"Actual closing RAB",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":14281.724180992402},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":15461.661521134512},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":16939.653825360299},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":18209.148928642295},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":19057.717603694509},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":19883.277707249832},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":20952.006669314433},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":21902.565029623158},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22768.917078378836},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22680.918989518657},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22546.596368575105},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22440.729819519536},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22315.648304731785},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22196.693313955162},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22136.397373865671},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22552.494328971203},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D12&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22827.69801782252}]
[null,null,null,"Forecast closing RAB",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":14545.962834782544},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":14725.53533201171},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":16876.049219117202},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":18324.650920727752},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":19647.620400235606},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":20843.968001932204},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":21921.560703254137},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23046.069387677442},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23967.057860345787},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23760.200170292974},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":24210.938012194678},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":24528.408109815507},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22685.920245760601},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22325.720813774955},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22322.022979680965},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":22626.43982864881},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D13&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23811.29442076648}]
[null,null,null,"Actual annual capex",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":969.93545149704471},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1069.5411102153687},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1822.2810319685032},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1926.8156861099974},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1568.494153993506},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1566.151289953945},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1736.0460050825943},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1700.8868554947751},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1346.8122044674376},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":806.32367382527855},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":802.3882070747901},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":765.48472478695396},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":804.96553771575623},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":815.19978151732721},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":927.18893281206158},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1420.9457852030075},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D14&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1249.8813416607929}]
[null,null,null,"Forecast annual capex",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":852.53525482795681},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":809.63773966515987},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1764.9336345631239},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1731.3138437300615},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1911.993850676716},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1961.9320572365104},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1858.8062191321183},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1902.9740826988525},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1771.1108742136823},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1189.7514563977743},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1391.1835756000592},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1305.3395726845556},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":765.11684891242237},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":780.73405569249132},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1033.3614951842171},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":1281.5841977471134},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D15&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":2147.5360134823413}]
[null,null,null,"Actual annual opex",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":563.41359403742285},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":574.81610670757141},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":575.92415922657949},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":594.75800303181165},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":623.90030671561647},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":598.55442696475689},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":620.63591789868531},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":604.4149774694605},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":655.60635497546275},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":663.25921203662324},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":676.74143903201423},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":673.38988102378585},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":594.7524726242309},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":605.48560989117368},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":600.15309531223784},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":604.36089356966397},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D16&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":616.7901359329951}]
[null,null,null,"Forecast annual opex",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":545.2699923007599},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":542.93564695654879},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":602.78076860631404},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":602.15189914287464},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":674.58610509347125},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":661.5312426119242},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":674.73032917543844},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":699.05972092567072},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":715.10938536637434},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":673.42651697651525},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":684.27921919659434},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":702.92812775975983},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":667.88480684364708},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":655.24790318740975},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":640.99704016544069},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":646.86435539276056},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D17&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":657.88743248943138}]
[null,null,null,"Loss of supply events",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":29},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":20},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":15},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":25},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":25},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":23},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":27},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":20},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":13},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":13},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":15},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":8},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":10},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":13},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":5},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D18&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""}]
[null,null,null,"Average outage duration",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D19&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""}]
[null,null,null,"Market impact indicator",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D20&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":""}]
[null,null,null,"Maximum demand (MW)",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D21&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0}]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D22&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":0}]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":182631.49885557801},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":186176.66682195303},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":187629.683496529},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":187179.75041948701},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":185093.70975965209},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":181765.99551489801},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":179217.082923487},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":174799.60999226087},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":170562.854865181},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":173326.24864551096},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":177091.91910189003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":177372.37977258896},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":177652.72599460339},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":173893.61086704468},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":170294.07134627813},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":168026.76317128178},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D23&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":170660.9990665798}]
[null,null,null,"Circuit length",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":39972.870000000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40133.262999999999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40666.283000000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40985.418000000005},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41559.528000000006},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41991.232000000004},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41991.97600000001},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":42810.656000000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43308.369054000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43437.513697599999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43441.588756755365},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43253.854478733338},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43308.083696939961},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43264.214219753245},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43181.878691999998},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43172.046999999999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D24&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43117.573999999993}]
[null,null,null,"Circuit length - overhead",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":39876.073000000004},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40036.466},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40569.485999999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":40887.320999999996},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41461.430999999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41888.834999999999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":41871.178999999996},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":42679.869000000006},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43173.443054000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43271.600697599999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43275.659756755376},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43091.2321084},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43145.404696939971},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43099.067219753248},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43016.067691999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":43006.236000000004},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D25&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":42931.143000000004}]
[null,null,null,"Circuit length - underground",{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":96.796999999999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":96.796999999999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":96.796999999999997},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":98.097000000000008},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":98.097000000000008},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":102.39699999999999},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":120.79699999999998},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":130.78700000000001},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":134.92600000000002},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":165.91300000000001},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":165.929},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":162.62237033333335},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":162.67900000000003},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":165.14700000000002},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":165.81100000000004},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":165.81100000000004},{"$f":"IFERROR(INDEX('New data sheet'!$F:$K,MATCH($D26&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0)),\"\")","v":186.43099999999998}]
[null,null,null,"Return on assets, including incentive scheme penalties or rewards",{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D27&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New 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('New data sheet'!$F:$K,MATCH($D28&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D28&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}}]
[null,null,null,"Real pre-tax WACC",{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&E$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&F$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&G$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&H$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&I$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&J$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&K$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&L$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&M$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&N$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&O$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&P$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&Q$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&R$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&S$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&T$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New data sheet'!$F$6:$K$6,0))","v":{"$error":"#N/A"}},{"$f":"INDEX('New data sheet'!$F:$K,MATCH($D29&U$9,'New data sheet'!$L:$L,0),MATCH($E$7,'New 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'!D41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!D57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!D65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!D84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D92,\n\"#N/A\"))))))","v":1173.8010272489553},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!E57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!E65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!E84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E92,\n\"#N/A\"))))))","v":728.1319815827477},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!F57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!F65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!F84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F92,\n\"#N/A\"))))))","v":812.62599791137825},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!G57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!G65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!G84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G92,\n\"#N/A\"))))))","v":588.97282334206841},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!H57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!H65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!H84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H92,\n\"#N/A\"))))))","v":635.49344660566112},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!I57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!I65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!I84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I92,\n\"#N/A\"))))))","v":603.73409633029587},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!J57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!J65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!J84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J92,\n\"#N/A\"))))))","v":54.353767597168542},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!K57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!K65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!K84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K92,\n\"#N/A\"))))))","v":126.5584789573861},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!L57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!L65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!L84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L92,\n\"#N/A\"))))))","v":28.119959950760808},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!M57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!M65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!M84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M92,\n\"#N/A\"))))))","v":34.818784486370951},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!N57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!N65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!N84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N92,\n\"#N/A\"))))))","v":62.490140113061429},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!O57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!O65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!O84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O92,\n\"#N/A\"))))))","v":200.89968930326103},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!P57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!P65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!P84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P92,\n\"#N/A\"))))))","v":690.80749097269381},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q41,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!Q57,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!Q65,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q73,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!Q84,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q92,\n\"#N/A\"))))))","v":414.04137946634569}]
[null,null,null,"overheads",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!D58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!D66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!D85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D93,\n\"#N/A\"))))))","v":96.307478185437262},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!E58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!E66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!E85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E93,\n\"#N/A\"))))))","v":109.91979917252506},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!F58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!F66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!F85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F93,\n\"#N/A\"))))))","v":100.1152545866351},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!G58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!G66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!G85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G93,\n\"#N/A\"))))))","v":105.72617891004136},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!H58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!H66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!H85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H93,\n\"#N/A\"))))))","v":110.31547346946977},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!I58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!I66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!I85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I93,\n\"#N/A\"))))))","v":92.797904708003969},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!J58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!J66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!J85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J93,\n\"#N/A\"))))))","v":82.136212836687918},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!K58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!K66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!K85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K93,\n\"#N/A\"))))))","v":76.304988432900132},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!L58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!L66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!L85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L93,\n\"#N/A\"))))))","v":85.522173941521828},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!M58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!M66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!M85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M93,\n\"#N/A\"))))))","v":82.37680759870976},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!N58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!N66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!N85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N93,\n\"#N/A\"))))))","v":74.686050347083182},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!O58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!O66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!O85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O93,\n\"#N/A\"))))))","v":71.631420918027544},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!P58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!P66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!P85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P93,\n\"#N/A\"))))))","v":76.466634193830373},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q42,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!Q58,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!Q66,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q74,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!Q85,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q93,\n\"#N/A\"))))))","v":87.570014003304863}]
[null,null,null,"connections",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!D59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!D67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!D86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D94,\n\"#N/A\"))))))","v":46.579811273938745},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!E59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!E67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!E86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E94,\n\"#N/A\"))))))","v":68.454485572325922},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!F59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!F67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!F86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F94,\n\"#N/A\"))))))","v":74.345198597939216},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!G59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!G67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!G86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G94,\n\"#N/A\"))))))","v":58.257215676030505},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!H59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!H67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!H86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H94,\n\"#N/A\"))))))","v":38.659601969363919},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!I59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!I67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!I86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I94,\n\"#N/A\"))))))","v":92.616789881507785},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!J59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!J67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!J86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J94,\n\"#N/A\"))))))","v":61.546686482284798},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!K59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!K67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!K86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K94,\n\"#N/A\"))))))","v":84.687112196564954},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!L59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!L67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!L86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L94,\n\"#N/A\"))))))","v":44.108246535658751},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!M59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!M67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!M86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M94,\n\"#N/A\"))))))","v":21.107352739777106},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!N59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!N67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!N86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N94,\n\"#N/A\"))))))","v":26.711107118839788},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!O59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!O67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!O86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O94,\n\"#N/A\"))))))","v":20.780439500692459},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!P59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!P67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!P86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P94,\n\"#N/A\"))))))","v":36.811611528533639},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q43,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!Q59,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!Q67,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q75,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!Q86,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q94,\n\"#N/A\"))))))","v":7.2797933087084772}]
[null,null,null,"non-network",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!D60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!D68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!D87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D95,\n\"#N/A\"))))))","v":111.79057681624656},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!E60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!E68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!E87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E95,\n\"#N/A\"))))))","v":104.23653338457092},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!F60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!F68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!F87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F95,\n\"#N/A\"))))))","v":128.59328545444501},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!G60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!G68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!G87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G95,\n\"#N/A\"))))))","v":115.41140682890823},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!H60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!H68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!H87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H95,\n\"#N/A\"))))))","v":138.77815190796318},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!I60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!I68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!I87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I95,\n\"#N/A\"))))))","v":137.96264220537893},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!J60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!J68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!J87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J95,\n\"#N/A\"))))))","v":83.354951892752567},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!K60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!K68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!K87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K95,\n\"#N/A\"))))))","v":63.264605177369042},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!L60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!L68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!L87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L95,\n\"#N/A\"))))))","v":78.263563996724656},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!M60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!M68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!M87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M95,\n\"#N/A\"))))))","v":123.60702326593751},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!N60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!N68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!N87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N95,\n\"#N/A\"))))))","v":96.568803741965354},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!O60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!O68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!O87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O95,\n\"#N/A\"))))))","v":138.9523776570021},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!P60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!P68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!P87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P95,\n\"#N/A\"))))))","v":93.931370801346333},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q44,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!Q60,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!Q68,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q76,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!Q87,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q95,\n\"#N/A\"))))))","v":79.54658767565374}]
[null,null,null,"replacement expenditure",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!D61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!D69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!D88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D96,\n\"#N/A\"))))))","v":520.66585864052001},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!E61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!E69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!E88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E96,\n\"#N/A\"))))))","v":493.65407412667776},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!F61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!F69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!F88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F96,\n\"#N/A\"))))))","v":432.42908989092956},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!G61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!G69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!G88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G96,\n\"#N/A\"))))))","v":622.09102072216581},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!H61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!H69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!H88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H96,\n\"#N/A\"))))))","v":801.24849709196951},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!I61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!I69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!I88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I96,\n\"#N/A\"))))))","v":740.42489230005981},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!J61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!J69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!J88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J96,\n\"#N/A\"))))))","v":575.47246245912197},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!K61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!K69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!K88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K96,\n\"#N/A\"))))))","v":478.19396543808739},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!L61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!L69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!L88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L96,\n\"#N/A\"))))))","v":535.4190729441375},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!M61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!M69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!M88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M96,\n\"#N/A\"))))))","v":532.21160667971924},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!N61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!N69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!N88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N96,\n\"#N/A\"))))))","v":525.51150684094443},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!O61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!O69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!O88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O96,\n\"#N/A\"))))))","v":427.19991907586603},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!P61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!P69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!P88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P96,\n\"#N/A\"))))))","v":516.26960145974238},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q45,\nIF($E$7=\"Powerlink\",'4. Capex by Driver'!Q61,\nIF($E$7=\"Transgrid\",'4. Capex by Driver'!Q69,\nIF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q77,\nIF($E$7=\"ElectraNet\", '4. Capex by Driver'!Q88,\nIF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q96,\n\"#N/A\"))))))","v":550.615944033505}]

{"sheet":"New data sheet","index":4,"n_rows":283,"n_cols":12,"rows_kept":283,"cut":false,"hidden":true,"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 from customers","2006",557.52402469039987,470.04823595856647,481.96604117697734,217.59795337642566,171.73121272893337,1898.8674679313026,{"$f":"D7&E7","v":"Actual revenue from customers2006"}]
[null,null,null,"Actual revenue from customers","2007",591.94738314293227,455.93082628451015,528.88808311911237,239.23913355850695,147.73655335196946,1963.741979457031,{"$f":"D8&E8","v":"Actual revenue from customers2007"}]
[null,null,null,"Actual revenue from customers","2008",640.3363078040552,469.1281137890702,527.64710002691106,246.57380770298258,161.38818216845414,2045.0735114914733,"Actual revenue from customers2008"]
[null,null,null,"Actual revenue from customers","2009",667.59330877113609,576.59419742205887,499.46191158903258,275.9760025422359,173.64504863760706,2193.2704689620705,"Actual revenue from customers2009"]
[null,null,null,"Actual revenue from customers","2010",751.99464873635247,702.20109670316572,594.47214762171279,266.97680384618531,204.22179728943146,2519.8664941968477,"Actual revenue from customers2010"]
[null,null,null,"Actual revenue from customers","2011",855.24019672008649,793.79355198640667,589.54046191042301,308.82743052464252,243.47828494083365,2790.8799260823926,"Actual revenue from customers2011"]
[null,null,null,"Actual revenue from customers","2012",946.20046843431726,817.34305552061687,615.95772633123352,356.827222601747,255.53622240272077,2991.8646952906356,"Actual revenue from customers2012"]
[null,null,null,"Actual revenue from customers","2013",935.49387452722897,855.49706436339989,691.31324574499331,369.42479772711323,252.86058550648946,3104.589567869225,"Actual revenue from customers2013"]
[null,null,null,"Actual revenue from customers","2014",961.06003792919216,801.14676444668419,600.23271544590455,318.11995741084837,248.00916839123749,2928.5686436238666,"Actual revenue from customers2014"]
[null,null,null,"Actual revenue from customers","2015",939.89983054698894,813.54114800006903,632.65073013031122,330.35391931132386,212.97255075688295,2929.4181787455759,"Actual revenue from customers2015"]
[null,null,null,"Actual revenue from customers",2016,1052.3349674319884,798.30129344046304,545.34896050440136,316.84450853206312,195.22585977314566,2908.0555896820615,"Actual revenue from customers2016"]
[null,null,null,"Actual revenue from customers",2017,1174.5996453183529,693.23893100010275,592.24300395864861,296.39372997267975,179.61860841881665,2936.0939186686005,"Actual revenue from customers2017"]
[null,null,null,"Actual revenue from customers",2018,779.28294289980784,643.76196742005436,565.21354528046868,284.41880525443554,176.02606601812499,2448.703326872891,"Actual revenue from customers2018"]
[null,null,null,"Actual revenue from customers",2019,719.08864588078734,569.77843819760108,545.34699045887669,280.8751236300086,163.91575153824323,2279.004949705517,"Actual revenue from customers2019"]
[null,null,null,"Actual revenue from customers",2020,716.26101119489886,555.57876773789064,628.80311377961061,288.94736309978595,148.11899436900021,2337.7092501811862,"Actual revenue from customers2020"]
[null,null,null,"Actual revenue from customers",2021,716.32468669107834,574.7558423072901,663.39505921062948,306.23819814837049,137.40770099548089,2398.1214873528493,"Actual revenue from customers2021"]
[null,null,null,"Actual revenue from customers",2022,735.68100503440348,622.13018286497697,662.30612345408974,310.65531002438496,128.02423596066316,2458.7968573385183,"Actual revenue from customers2022"]
[null,null,null,"Budgeted revenue from Customers","2015",952.52119721573774,912.14021020569112,634.90533560249798,337.41356533043745,190.78724511960149,3027.7675534739656,"Budgeted revenue from Customers2015"]
[null,null,null,"Budgeted revenue from Customers",2016,1078.8346977744832,898.69298356183253,634.13716315250645,323.82443476143726,173.04088572651614,3108.5301649767757,"Budgeted revenue from Customers2016"]
[null,null,null,"Budgeted revenue from Customers",2017,1183.6143780206962,808.45509277437168,604.95125483896618,303.95934700541557,170.92939560460357,3071.9094682440532,"Budgeted revenue from Customers2017"]
[null,null,null,"Budgeted revenue from Customers",2018,787.388907543448,740.66655052914359,569.64016790232347,291.61371939190599,162.00620567195179,2551.3155510387724,"Budgeted revenue from Customers2018"]
[null,null,null,"Budgeted revenue from Customers",2019,722.05870526369108,591.49842233397112,546.9168150874151,288.11384343556637,163.29229833208717,2311.8800844527309,"Budgeted revenue from Customers2019"]
[null,null,null,"Budgeted revenue from Customers",2020,716.71732630336146,679.40161765304197,628.7937006120718,288.61264594923625,147.98343475952416,2461.5087252772355,"Budgeted revenue from Customers2020"]
[null,null,null,"Budgeted revenue from Customers",2021,719.92392980520458,705.26980839239832,663.39505900389247,312.54126313827936,137.93015117235407,2539.0602115121287,"Budgeted revenue from Customers2021"]
[null,null,null,"Budgeted revenue from Customers",2022,743.2054947864217,732.51266512788686,662.29784248918065,317.33574990154665,128.55200930897269,2583.9037616140085,"Budgeted revenue from Customers2022"]
[null,null,null,"Actual Closing RAB","2006",4334.9235019637581,4659.3824604826696,2739.8322912045592,1483.6729201130609,1063.9130072283554,14281.724180992402,"Actual Closing RAB2006"]
[null,null,null,"Actual Closing RAB","2007",5280.5479480604772,4786.7328159733343,2727.7463253704645,1523.589015089304,1143.0454166409331,15461.661521134512,"Actual Closing RAB2007"]
[null,null,null,"Actual Closing RAB","2008",6004.1679040764884,5047.9473397560341,2967.598872371454,1770.5866739559483,1149.3530352003736,16939.653825360299,"Actual Closing RAB2008"]
[null,null,null,"Actual Closing RAB","2009",6607.8278135919618,5562.4154389154583,2952.25581543112,1831.8004831842907,1254.8493775194604,18209.148928642295,"Actual Closing RAB2009"]
[null,null,null,"Actual Closing RAB","2010",6951.8075510891576,5869.4731026211048,2954.7222011292338,1912.1372387655219,1369.5775100894914,19057.717603694509,"Actual Closing RAB2010"]
[null,null,null,"Actual Closing RAB","2011",7236.6297682023269,6110.7613333041327,2947.8272142374062,2135.814903332338,1452.2444881736308,19883.277707249832,"Actual Closing RAB2011"]
[null,null,null,"Actual Closing RAB","2012",7841.4027354178716,6319.0543813031509,2963.7388588665071,2276.2647353267193,1551.5459584001835,20952.006669314433,"Actual Closing RAB2012"]
[null,null,null,"Actual Closing RAB","2013",8148.6872185136017,6680.1785275292295,3020.7541083812243,2462.436842910523,1590.5083322885789,21902.565029623158,"Actual Closing RAB2013"]
[null,null,null,"Actual Closing RAB","2014",8264.8006368032929,7032.4303135926066,3310.2154334272091,2529.1291204075064,1632.3415741482186,22768.917078378836,"Actual Closing RAB2014"]
[null,null,null,"Actual Closing RAB","2015",8160.5228298310722,7044.2857322462214,3316.6377685119692,2558.172278350135,1601.3003805792575,22680.918989518657,"Actual Closing RAB2015"]
[null,null,null,"Actual Closing RAB",2016,8007.3918983196827,7032.8490238347067,3308.4029650498742,2632.1784289746752,1565.7740523961666,22546.596368575105,"Actual Closing RAB2016"]
[null,null,null,"Actual Closing RAB",2017,7795.6323108956321,6931.716818394345,3468.7374138049786,2688.7997061505394,1555.8435702740442,22440.729819519536,"Actual Closing RAB2017"]
[null,null,null,"Actual Closing RAB",2018,7676.7183673411064,6894.1090292182635,3425.6354798556681,2771.7317870568545,1547.4536412598943,22315.648304731785,"Actual Closing RAB2018"]
[null,null,null,"Actual Closing RAB",2019,7553.8655594538741,6871.8221094977844,3397.4178263708636,2827.055238083869,1546.5325805487744,22196.693313955162,"Actual Closing RAB2019"]
[null,null,null,"Actual Closing RAB",2020,7414.9616395361263,6930.0831355194587,3370.2506879759403,2884.8684788387641,1536.23343199538,22136.397373865671,"Actual Closing RAB2020"]
[null,null,null,"Actual Closing RAB",2021,7275.9923653883407,7453.0193856812093,3327.1812436312271,2973.2542470299168,1523.0470872405097,22552.494328971203,"Actual Closing RAB2021"]
[null,null,null,"Actual Closing RAB",2022,7161.7833141164301,7646.2809765666234,3297.1135678276501,3211.9819565676175,1510.5382027441951,22827.69801782252,"Actual Closing RAB2022"]
[null,null,null,"Forecast Closing RAB","2006",4321.6435604352573,4767.9475119204426,2856.7178822963024,1537.7435357496004,1061.9103443809411,14545.962834782544,"Forecast Closing RAB2006"]
[null,null,null,"Forecast Closing RAB","2007",4253.3819899748996,4929.9872891150562,2842.1326241997554,1558.6382288319371,1141.3951998900623,14725.53533201171,"Forecast Closing RAB2007"]
[null,null,null,"Forecast Closing RAB","2008",6087.7965436075128,5286.7313851672498,2824.9966139410058,1528.6820728634589,1147.8426035379725,16876.049219117202,"Forecast Closing RAB2008"]
[null,null,null,"Forecast Closing RAB","2009",6774.093183578384,5538.8775103009648,2986.6454099041466,1881.4298944478949,1143.6049224963601,18324.650920727752,"Forecast Closing RAB2009"]
[null,null,null,"Forecast Closing RAB","2010",7133.2833271417412,6057.876948094492,2990.6768290340565,2057.9308385720547,1407.852457393258,19647.620400235606,"Forecast Closing RAB2010"]
[null,null,null,"Forecast Closing RAB","2011",7541.5421925370756,6434.4615743758022,3017.8700365799773,2296.3116309921816,1553.7825674471678,20843.968001932204,"Forecast Closing RAB2011"]
[null,null,null,"Forecast Closing RAB","2012",7838.8303590184305,6958.2240071071556,3050.1711916263102,2457.8358839064626,1616.4992615957797,21921.560703254137,"Forecast Closing RAB2012"]
[null,null,null,"Forecast Closing RAB","2013",8436.0723917992691,7398.7914292363193,3054.1975141096759,2477.5527492643173,1679.4553032678584,23046.069387677442,"Forecast Closing RAB2013"]
[null,null,null,"Forecast Closing RAB","2014",8854.7607654602489,7643.3134273084024,3105.3760932545993,2626.2746296281462,1737.3329446943885,23967.057860345787,"Forecast Closing RAB2014"]
[null,null,null,"Forecast Closing RAB","2015",9037.5110653585471,7056.2241989653694,3324.0990045281324,2710.136961504541,1632.2289399363838,23760.200170292974,"Forecast Closing RAB2015"]
[null,null,null,"Forecast Closing RAB",2016,9253.5774368545808,7123.5186709666186,3369.9737774122882,2818.8359289348132,1645.0321980263791,24210.938012194678,"Forecast Closing RAB2016"]
[null,null,null,"Forecast Closing RAB",2017,9529.3858100451707,7094.2718728876589,3409.7895162020977,2854.3454839565679,1640.615426724012,24528.408109815507,"Forecast Closing RAB2017"]
[null,null,null,"Forecast Closing RAB","2018",7697.5811648292101,7066.675421046697,3484.6015607340164,2809.7173325244439,1627.3447666262343,22685.920245760601,"Forecast Closing RAB2018"]
[null,null,null,"Forecast Closing RAB","2019",7579.0984726908709,6881.861081962511,3474.7431636330084,2788.6032097592888,1601.4148857292766,22325.720813774955,"Forecast Closing RAB2019"]
[null,null,null,"Forecast Closing RAB","2020",7451.5505769450474,6987.8301795321204,3447.2591878169192,2891.8600295751044,1543.5230058117752,22322.022979680965,"Forecast Closing RAB2020"]
[null,null,null,"Forecast Closing RAB","2021",7325.515911996411,7349.483450543702,3423.2499810968457,2985.7348424045294,1542.4556426073214,22626.43982864881,"Forecast Closing RAB2021"]
[null,null,null,"Forecast Closing RAB","2022",7186.2859101701861,8415.5300254695703,3371.7232817637137,3302.1553276182185,1535.5998757447937,23811.29442076648,"Forecast Closing RAB2022"]
[null,null,null,"Actual annual capex","2006",391.01766552670858,227.17273588394363,148.7600766547915,99.664888541078042,103.32008489052293,969.93545149704471,"Actual annual capex2006"]
[null,null,null,"Actual annual capex","2007",350.05244656564832,308.79900565184721,151.93217287430241,114.81575604886851,143.94172907470235,1069.5411102153687,"Actual annual capex2007"]
[null,null,null,"Actual annual capex","2008",913.57722747690048,441.81923222489013,149.80401458761403,231.27800244493474,85.802555234163563,1822.2810319685032,"Actual annual capex2008"]
[null,null,null,"Actual annual capex","2009",827.93471767044662,759.44370665486622,121.35140190584967,128.73714896197075,89.348710916864349,1926.8156861099974,"Actual annual capex2009"]
[null,null,null,"Actual annual capex","2010",576.55744485193418,526.12561620616771,142.01578262339862,151.39852901790368,172.3967812941018,1568.494153993506,"Actual annual capex2010"]
[null,null,null,"Actual annual capex","2011",533.79939762612105,456.69586169182878,137.34993433597072,292.67783606533351,145.62826023469128,1566.151289953945,"Actual annual capex2011"]
[null,null,null,"Actual annual capex","2012",775.43527951094472,431.37513616201767,161.16504809194603,213.63607839664215,154.43446292104369,1736.0460050825943,{"$f":"D72&E72","v":"Actual annual capex2012"}]
[null,null,null,"Actual annual capex","2013",539.09025933766941,583.38695408556043,205.84566379627455,269.91216957202602,102.65180870324475,1700.8868554947751,"Actual annual capex2013"]
[null,null,null,"Actual annual capex","2014",370.93077895445748,561.91797159869634,169.33606519283384,154.23813967024105,90.389249051208949,1346.8122044674376,"Actual annual capex2014"]
[null,null,null,"Actual annual capex","2015",183.16642355444711,289.46585298518755,174.27969650912524,130.39768908689933,29.014011689619348,806.32367382527855,"Actual annual capex2015"]
[null,null,null,"Actual annual capex",2016,150.07439044853334,279.01651573439949,156.79518277914971,188.54458616203243,27.957531950675119,802.3882070747901,"Actual annual capex2016"]
[null,null,null,"Actual annual capex",2017,191.43397448495745,205.23005056825986,144.72245106865364,167.46909492904425,56.629153736038759,765.48472478695396,"Actual annual capex2017"]
[null,null,null,"Actual annual capex",2018,163.61997886450661,248.48935015711993,144.99107994802458,190.85160126148631,57.013527484618869,804.96553771575623,"Actual annual capex2018"]
[null,null,null,"Actual annual capex",2019,179.10407738114426,249.47367999203215,153.78988043489645,168.16917925327022,64.662964455984138,815.19978151732721,"Actual annual capex2019"]
[null,null,null,"Actual annual capex",2020,176.44896760786781,341.21826763286015,162.40351431094996,194.11939891596589,52.998784344417828,927.18893281206158,"Actual annual capex2020"]
[null,null,null,"Actual annual capex",2021,187.23038610544137,812.3469667760977,146.45820185505869,228.37028738509113,46.539943081318683,1420.9457852030075,"Actual annual capex2021"]
[null,null,null,"Actual annual capex",2022,205.66339781540475,486.2952177121561,135.9495124857263,375.63489651692868,46.338317130577202,1249.8813416607929,"Actual annual capex2022"]
[null,null,null,"Forecast annual capex","2006",293.52500601098814,275.75503330101088,80.962231260197754,125.90029103186691,76.392693223893204,852.53525482795681,"Forecast annual capex2006"]
[null,null,null,"Forecast annual capex","2007",131.46235433868262,332.45572552487749,109.77757106794226,109.85444261847216,126.08764611518534,809.63773966515987,"Forecast annual capex2007"]
[null,null,null,"Forecast annual capex","2008",996.17085584828806,525.22463993496672,111.1725711746072,72.81212396297947,59.553443642282346,1764.9336345631239,"Forecast annual capex2008"]
[null,null,null,"Forecast annual capex","2009",908.73193147154518,439.78355468478389,157.75824534062031,175.34379029713836,49.69632193597355,1731.3138437300615,"Forecast annual capex2009"]
[null,null,null,"Forecast annual capex","2010",602.25069286097198,708.89074409962063,151.01144817777916,240.24839963618379,209.59256590216032,1911.993850676716,"Forecast annual capex2010"]
[null,null,null,"Forecast annual capex","2011",664.87071403342725,604.2306197974774,178.70756024102718,306.92834242067772,207.19482074390095,1961.9320572365104,"Forecast annual capex2011"]
[null,null,null,"Forecast annual capex","2012",566.52545065467405,742.90425538605029,188.78483924170166,236.89167707523637,123.69999677445571,1858.8062191321183,"Forecast annual capex2012"]
[null,null,null,"Forecast annual capex","2013",819.16910793953252,682.78237896141729,165.61495026617294,105.3602308341512,130.04741469757855,1902.9740826988525,"Forecast annual capex2013"]
[null,null,null,"Forecast annual capex","2014",676.38862155288666,513.18586349036707,202.3988376604579,249.39793664082578,129.73961486914484,1771.1108742136823,"Forecast annual capex2014"]
[null,null,null,"Forecast annual capex","2015",481.71117643779002,295.48022554941235,173.29720007834825,180.65870420469884,58.60415012752474,1189.7514563977743,"Forecast annual capex2015"]
[null,null,null,"Forecast annual capex",2016,535.57825711639259,352.5635726801043,209.20408362355528,219.22886947335166,74.608792706655166,1391.1835756000592,"Forecast annual capex2016"]
[null,null,null,"Forecast annual capex",2017,606.43002687789453,272.38050900797833,208.09900286550624,157.35457500369535,61.07545892948113,1305.3395726845556,"Forecast annual capex2017"]
[null,null,null,"Forecast annual capex",2018,181.36513315715905,254.38766353154284,197.45751498115951,80.365758311197283,51.540778931363612,765.11684891242237,"Forecast annual capex2018"]
[null,null,null,"Forecast annual capex",2019,182.10090276732211,257.2813682548616,172.42550863098293,129.5599736442467,39.36630239507793,780.73405569249132,"Forecast annual capex2019"]
[null,null,null,"Forecast annual capex",2020,185.50290288564116,388.33250097321928,168.0838148428065,231.75702905636334,59.685247426186933,1033.3614951842171,"Forecast annual capex2020"]
[null,null,null,"Forecast annual capex",2021,193.01402664238611,649.68878915152493,156.43753352548208,225.08752292759928,57.35632550012113,1281.5841977471134,"Forecast annual capex2021"]
[null,null,null,"Forecast annual capex",2022,180.47761748404048,1342.5845611547998,117.61692922213633,452.99351300040041,53.863392620964675,2147.5360134823413,"Forecast annual capex2022"]
[null,null,null,"Actual annual opex","2006",173.74064863251309,176.79883434272028,90.16178325003284,70.83388838724774,51.87843942490894,563.41359403742285,"Actual annual opex2006"]
[null,null,null,"Actual annual opex","2007",182.66436886457186,175.50042892031718,87.588765965770151,75.372124046431125,53.690418910481029,574.81610670757141,"Actual annual opex2007"]
[null,null,null,"Actual annual opex","2008",198.60916363660138,165.17309373932059,80.07438033852641,68.136764372982455,63.930757139148703,575.92415922657949,"Actual annual opex2008"]
[null,null,null,"Actual annual opex","2009",190.41645075452439,165.7333466599319,103.1983565954604,73.139501108347815,62.270347913547234,594.75800303181165,"Actual annual opex2009"]
[null,null,null,"Actual annual opex","2010",197.27828575929715,186.24723809179557,103.49254591208914,74.757122442626937,62.125114509807673,623.90030671561647,"Actual annual opex2010"]
[null,null,null,"Actual annual opex","2011",190.22753281855242,173.73104111153597,94.8157934038843,81.069915930620638,58.71014370016362,598.55442696475689,"Actual annual opex2011"]
[null,null,null,"Actual annual opex","2012",197.16957388012736,187.21746434641349,89.271475014901696,89.224257001127015,57.753147656115765,620.63591789868531,"Actual annual opex2012"]
[null,null,null,"Actual annual opex","2013",201.64850149636223,172.54217520617587,91.014690073130282,84.960344953413838,54.24926574037827,604.4149774694605,"Actual annual opex2013"]
[null,null,null,"Actual annual opex","2014",212.31767351552014,206.24732687296404,96.522107354061433,86.974652038520631,53.5445951943965,655.60635497546275,"Actual annual opex2014"]
[null,null,null,"Actual annual opex","2015",242.6295988027716,193.06404258537924,96.31808895450736,91.418189563996904,39.829292129968131,663.25921203662324,"Actual annual opex2015"]
[null,null,null,"Actual annual opex",2016,246.72420435432849,191.30468889548692,99.816330540944278,96.464101265597009,42.432113975657572,676.74143903201423,"Actual annual opex2016"]
[null,null,null,"Actual annual opex",2017,252.14224338558859,189.24941520094549,96.513269053595934,99.884679213009917,35.600274170646038,673.38988102378585,"Actual annual opex2017"]
[null,null,null,"Actual annual opex",2018,204.94033282894625,167.7375924870218,88.700449963113712,101.72339008982263,31.650707255326495,594.7524726242309,"Actual annual opex2018"]
[null,null,null,"Actual annual opex",2019,213.82985284435298,165.65213048783201,92.517171087289768,100.11390158305078,33.372553888648234,605.48560989117368,"Actual annual opex2019"]
[null,null,null,"Actual annual opex",2020,212.90387930079098,170.08184746188468,83.278881667956824,105.21078588934424,28.677700992261119,600.15309531223784,"Actual annual opex2020"]
[null,null,null,"Actual annual opex",2021,218.97488560642046,175.18704372023751,74.583644979956617,103.67744261171299,31.937876651336452,604.36089356966397,"Actual annual opex2021"]
[null,null,null,"Actual annual opex",2022,209.99213472174412,188.78156333535671,83.496717214780915,101.9004608715239,32.619259789589449,616.7901359329951,"Actual annual opex2022"]
[null,null,null,"Forecast annual opex","2006",132.70515370039027,177.22131285058654,111.87547538617666,75.630549203150593,47.837501160455851,545.2699923007599,"Forecast annual opex2006"]
[null,null,null,"Forecast annual opex","2007",132.71030657715897,176.65848337044235,111.87547538617673,75.630549203150622,46.060832419620127,542.93564695654879,"Forecast annual opex2007"]
[null,null,null,"Forecast annual opex","2008",196.8843626935172,176.20517746481272,111.8754753861767,75.630549203150508,42.185203858656919,602.78076860631404,"Forecast annual opex2008"]
[null,null,null,"Forecast annual opex","2009",197.75757131539908,175.92832620701205,111.05071916817984,75.363011175478448,42.052271276805328,602.15189914287464,"Forecast annual opex2009"]
[null,null,null,"Forecast annual opex","2010",212.51420848037651,208.68340590908764,110.17736759158817,77.725405753694545,65.485717358724443,674.58610509347125,"Forecast annual opex2010"]
[null,null,null,"Forecast annual opex","2011",203.17459868943212,201.38888601332894,110.14866670393134,80.414314549772143,66.404776655459628,661.5312426119242,"Forecast annual opex2011"]
[null,null,null,"Forecast annual opex","2012",209.26054766461544,206.52526077517877,108.79928243681923,84.239362114034023,65.905876184790898,674.73032917543844,"Forecast annual opex2012"]
[null,null,null,"Forecast annual opex","2013",216.16265706787314,218.22839603339725,108.21216869546346,87.438794926173927,69.017704202762957,699.05972092567072,"Forecast annual opex2013"]
[null,null,null,"Forecast annual opex","2014",224.38431951177361,220.43205506846633,106.7451842802371,94.946399979368053,68.601426526529295,715.10938536637434,"Forecast annual opex2014"]
[null,null,null,"Forecast annual opex","2015",230.09490448316333,196.91341629382001,96.929522110297825,98.552860798313063,50.935813290921054,673.42651697651525,"Forecast annual opex2015"]
[null,null,null,"Forecast annual opex",2016,238.71075773331677,195.57839073030661,99.406139334825511,100.34333120840587,50.240600189739546,684.27921919659434,"Forecast annual opex2016"]
[null,null,null,"Forecast annual opex",2017,245.63047508948665,200.81246033855953,100.23328730088598,105.74030744541611,50.511597585411586,702.92812775975983,"Forecast annual opex2017"]
[null,null,null,"Forecast annual opex",2018,217.12093425557816,193.2702348523292,100.56582259633147,106.15330202245799,50.774513116950246,667.88480684364708,"Forecast annual opex2018"]
[null,null,null,"Forecast annual opex",2019,216.17503914315753,189.9672608372471,101.09985162410636,97.792986481001833,50.212765101896942,655.24790318740975,"Forecast annual opex2019"]
[null,null,null,"Forecast annual opex",2020,215.15701989950821,193.38407256170564,102.18766307742239,98.314361732208766,31.953922894595685,640.99704016544069,"Forecast annual opex2020"]
[null,null,null,"Forecast annual opex",2021,214.36688001589167,197.99437869794966,102.32011557295907,100.12008738819547,32.062893717764759,646.86435539276056,"Forecast annual opex2021"]
[null,null,null,"Forecast annual opex",2022,214.22959988748636,207.2182969051608,102.82991075186051,101.38726638797165,32.222358556951981,657.88743248943138,"Forecast annual opex2022"]
[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,{"$f":"D136&E136","v":"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,7,5,5,10,27,"Loss of supply events2013"]
[null,null,null,"Loss of supply events",2014,5,3,3,4,5,20,"Loss of supply events2014"]
[null,null,null,"Loss of supply events",2015,2,4,2,1,4,13,"Loss of supply events2015"]
[null,null,null,"Loss of supply events",2016,1,2,3,5,2,13,"Loss of supply events2016"]
[null,null,null,"Loss of supply events",2017,6,1,0,4,4,15,"Loss of supply events2017"]
[null,null,null,"Loss of supply events",2018,2,1,0,3,2,8,"Loss of supply events2018"]
[null,null,null,"Loss of supply events",2019,0,3,1,4,2,10,"Loss of supply events2019"]
[null,null,null,"Loss of supply events",2020,0,1,3,1,8,13,"Loss of supply events2020"]
[null,null,null,"Loss of supply events",2021,3,0,0,0,2,5,"Loss of supply events2021"]
[null,null,null,"Average outage duration",2006,39.034769685990298,64.84,61.9,88.46,53.846150000000002,null,"Average outage duration2006"]
[null,null,null,"Average outage duration",2007,1249.94338791423,125.4,27.6,269.94,142.7619,null,"Average outage duration2007"]
[null,null,null,"Average outage duration",2008,35.289638071895403,34.28,71.5,200.2,112.9,null,"Average outage duration2008"]
[null,null,null,"Average outage duration",2009,62.276197516025597,84.96,103.1,161.27000000000001,67.157889999999995,null,"Average outage duration2009"]
[null,null,null,"Average outage duration",2010,16.620001587301601,225.83,92.5,126.85,127.7692,null,"Average outage duration2010"]
[null,null,null,"Average outage duration",2011,86.769421575429206,137.11000000000001,4,242.28,90.866669999999999,null,"Average outage duration2011"]
[null,null,null,"Average outage duration",2012,26.086666666666702,94.23,230,124.76,110.88460000000001,null,"Average outage duration2012"]
[null,null,null,"Average outage duration",2013,5.6214285714285701,178.69,19.899999999999999,154.16999999999999,160.94120000000001,null,"Average outage duration2013"]
[null,null,null,"Average outage duration",2014,115.971,71.14,24,130.71,201,null,"Average outage duration2014"]
[null,null,null,"Average outage duration",2015,236.2286666,63.55,97.5,147,74,null,"Average outage duration2015"]
[null,null,null,"Average outage duration",2016,30.060000000000002,169.17750790715218,39.833333333333336,250.57142857142784,15,null,"Average outage duration2016"]
[null,null,null,"Average outage duration",2017,27.451875000000001,35.639999896287918,19,97.4,410.45454545511694,null,"Average outage duration2017"]
[null,null,null,"Average outage duration",2018,36.238181818181822,58.200000151991844,24.5,463,45.909090909154408,null,"Average outage duration2018"]
[null,null,null,"Average outage duration",2019,15,69.824999794363976,87,192,273,null,"Average outage duration2019"]
[null,null,null,"Average outage duration",2020,36.203749999999999,45.171428727252142,72.300000000756697,205,105.0000000002794,null,"Average outage duration2020"]
[null,null,null,"Average outage duration",2021,51.068750000000001,72.238095060428805,47.3,199.87499999954406,19,null,"Average outage duration2021"]
[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.2857686453576863E-3,9.1324200913242006E-4,1.5468036529680365E-2,null,"Market impact indicator2014"]
[null,null,null,"Market impact indicator",2015,6.183409436834094E-4,1.2642694063926941E-2,9.2180365296803644E-3,0.10271118721461187,2.349695585996956E-3,null,"Market impact indicator2015"]
[null,null,null,"Market impact indicator",2016,3.9954337899543381E-4,2.9071537290715373E-2,6.3641552511415525E-2,0.11115391933028919,2.7245053272450533E-2,null,"Market impact indicator2016"]
[null,null,null,"Market impact indicator",2017,6.9444444444444447E-4,6.4778348554033485E-2,4.2760654490106548E-2,2.2146118721461189E-2,2.5703957382039573E-2,null,"Market impact indicator2017"]
[null,null,null,"Market impact indicator",2018,4.2427701674277018E-3,6.7323059360730589E-2,3.0251141552511416E-3,6.8683409436834097E-2,3.9278919330289194E-2,null,"Market impact indicator2018"]
[null,null,null,"Market impact indicator",2019,0.13254375951293759,1.3622526636225266E-2,1.8873668188736682E-2,7.4728881278538814E-2,1.6695205479452056E-2,null,"Market impact indicator2019"]
[null,null,null,"Market impact indicator",2020,0.23687214611872145,0.15904680365296803,9.1990106544901067E-3,6.8730974124809746E-2,1.3261035007610351E-2,null,"Market impact indicator2020"]
[null,null,null,"Market impact indicator",2021,0.11093036529680365,0.32745433789954337,3.5730593607305933E-2,0.13810882800608829,1.310882800608828E-2,null,"Market impact indicator2021"]
[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,"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,"Maximum demand (MW)",2019,8968.9724920000008,13000,8683.9030000000002,3192.8984160999998,2147.1028240000001,null,"Maximum demand (MW)2019"]
[null,null,null,"Maximum demand (MW)",2020,8766.4130399999995,13500,8947.7000000000007,2922.5114060000001,2047.92679399999,null,"Maximum demand (MW)2020"]
[null,null,null,"Maximum demand (MW)",2021,8478.9833699999999,11700,7786.0590000000002,2744.4459701999899,2040.7527340039901,null,"Maximum demand (MW)2021"]
[null,null,null,"Maximum demand (MW)",2022,9171.1070779999991,12000,7969,2501.1071460869998,2117.4323960499901,null,"Maximum demand (MW)2022"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2006",null,null,null,null,null,182631.49885557801,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2006"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2007",null,null,null,null,null,186176.66682195303,{"$f":"D200&E200","v":"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2007"}]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2008",null,null,null,null,null,187629.683496529,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2008"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2009",null,null,null,null,null,187179.75041948701,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2009"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2010",null,null,null,null,null,185093.70975965209,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2010"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2011",null,null,null,null,null,181765.99551489801,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2011"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2012",null,null,null,null,null,179217.082923487,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2012"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2013",null,null,null,null,null,174799.60999226087,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2013"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2014",null,null,null,null,null,170562.854865181,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2014"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks","2015",null,null,null,null,null,173326.24864551096,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2015"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2016,null,null,null,null,null,177091.91910189003,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2016"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2017,null,null,null,null,null,177372.37977258896,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2017"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2018,null,null,null,null,null,177652.72599460339,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2018"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2019,null,null,null,null,null,173893.61086704468,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2019"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2020,null,null,null,null,null,170294.07134627813,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2020"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2021,null,null,null,null,null,168026.76317128178,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2021"]
[null,null,null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks",2022,null,null,null,null,null,170660.9990665798,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks2022"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2006",51045.96344425701,81538.366632759004,45186.299678676005,15241.186994052407,10530.108800000002,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2006"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2007",51964.465679886984,83028.257359986004,45956.437073730005,14809.02240557884,12828.493,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2007"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2008",51187.327595034978,82531.571031917003,45046.718030759999,14506.431798357989,13500.337,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2008"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2009",52191.948260312034,81126.238029020999,47419.179046665005,14847.610973429968,13412.710999999999,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2009"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2010",52848.520626357022,80626.119478492008,48976.636241104992,15008.379403305271,13030.212,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2010"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2011",51917.071191967989,79831.334420277999,48047.970992500006,15262.885728180965,13108.442999999999,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2011"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2012",50878.576976755998,76646.150635604004,47529.361264941996,15068.932757169014,12589.843000000001,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2012"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2013",49333.938670689997,71147.668184577997,49056.428480178998,15061.136823993089,12866.188,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2013"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2014",47613.581421290997,67800,48503.771563634997,14707.393943953022,13359.963803999997,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2014"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks","2015",53087.563425,74400,47967.077018124997,14485.733990000001,13109.624082295986,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2015"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2016,52872.387581990006,72200,47805.245822115998,15043.149099044002,11654.573903348006,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2016"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2017,54253.300021025992,75000,46829.301624718995,15106.1610945133,12426.663323709681,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2017"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2018,54849.858036833997,75700,41725,14127.75806308338,12434.326120010006,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2018"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2019,53765.29422406599,74400,41479.993999999999,13786.71468798471,12884.563992276986,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2019"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2020,53076.368905469993,72900,41527.840000000004,13856.515144038129,12412.888664812004,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2020"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2021,51783.263917914992,71300,42258.700000000004,13621.7689999098,12909.204958704957,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2021"]
[null,null,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks",2022,51131.761323307503,68200,44066.71,13615.85709313897,13236.63157566114,null,"Energy delivered (GWh) -  including energy delivered to other transmission networks2022"]
[null,null,null,"Circuit length","2006",11700.8,12517.231,6573,5600.5389999999998,3581.3,39972.870000000003,"Circuit length2006"]
[null,null,null,"Circuit length","2007",11892.8,12526.493999999999,6573,5518.6689999999999,3622.3,40133.262999999999,"Circuit length2007"]
[null,null,null,"Circuit length","2008",12428.8,12523.513999999999,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.459000000001,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.207,6573,5526.0690000000004,3493.3,41991.97600000001,"Circuit length2012"]
[null,null,null,"Circuit length","2013",14313.5,12893.617,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.8447567553667,5524.3490000000002,3563.7000000000003,43441.588756755365,"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",2019,14526.2,13052.375219753239,6627.7700000000013,5512.668999999999,3545.2,43264.214219753245,"Circuit length2019"]
[null,null,null,"Circuit length",2020,14528.2,13052.451309999999,6731.1111999999994,5519.5789999999997,3350.5371820000005,43181.878691999998,"Circuit length2020"]
[null,null,null,"Circuit length",2021,14534.2,13038.453,6734.0199999999995,5515.1390000000001,3350.2350000000001,43172.046999999999,"Circuit length2021"]
[null,null,null,"Circuit length",2022,14535.2,13074.842999999999,6628.5450000000001,5518.0389999999998,3360.9470000000006,43117.573999999993,"Circuit length2022"]
[null,null,null,"Circuit length - overhead","2006",11685,12469.323,6562,5591.75,3568,39876.073000000004,"Circuit length - overhead2006"]
[null,null,null,"Circuit length - overhead","2007",11877,12478.585999999999,6562,5509.88,3609,40036.466,"Circuit length - overhead2007"]
[null,null,null,"Circuit length - overhead","2008",12413,12475.606,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.551000000001,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.299000000001,6562,5498.88,3480,41871.178999999996,"Circuit length - overhead2012"]
[null,null,null,"Circuit length - overhead","2013",14292,12845.709000000001,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.6447567553669,5497.16,3539.9,43275.659756755376,"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 - overhead",2019,14506,12966.96721975324,6619.2300000000014,5485.4699999999993,3521.3999999999996,43099.067219753248,"Circuit length - overhead2019"]
[null,null,null,"Circuit length - overhead",2020,14508,12966.743309999998,6722.5711999999994,5492.38,3326.3731820000003,43016.067691999997,{"$f":"D264&E264","v":"Circuit length - overhead2020"}]
[null,null,null,"Circuit length - overhead",2021,14514,12952.744999999999,6725.48,5487.9400000000005,3326.0709999999999,43006.236000000004,"Circuit length - overhead2021"]
[null,null,null,"Circuit length - overhead",2022,14515,12968.514999999999,6620.0050000000001,5490.84,3336.7830000000004,42931.143000000004,"Circuit length - overhead2022"]
[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.5,81.64,8.5399999999999991,27.199000000000002,23.8,162.67900000000003,"Circuit length - underground2018"]
[null,null,null,"Circuit length - underground",2019,20.200000000000003,85.408000000000001,8.5399999999999991,27.199000000000002,23.8,165.14700000000002,"Circuit length - underground2019"]
[null,null,null,"Circuit length - underground",2020,20.200000000000003,85.707999999999998,8.5399999999999991,27.199000000000002,24.164000000000001,165.81100000000004,"Circuit length - underground2020"]
[null,null,null,"Circuit length - underground",2021,20.200000000000003,85.707999999999998,8.5399999999999991,27.199000000000002,24.164000000000001,165.81100000000004,"Circuit length - underground2021"]
[null,null,null,"Circuit length - underground",2022,20.200000000000003,106.32799999999999,8.5399999999999991,27.199000000000002,24.164000000000001,186.43099999999998,"Circuit length - underground2022"]

{"sheet":"1. Revenue","index":5,"n_rows":59,"n_cols":20,"rows_kept":59,"cut":false,"hidden":false,"merged":[[3,1,3,13],[29,1,29,13],[31,1,31,19],[58,1,58,19],[56,1,56,19],[55,1,55,19],[43,1,43,19],[42,1,42,19]]}
[]
[]
[]
[null,"Revenue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Transmission businesses earn revenues for delivering prescribed transmission services. They earn some revenues directly from customers, and other revenue from sources such as inter-regional and intra-regional settlements residues or inter-regional settlements auction proceeds. The revenues shown in the chart only include the revenues budgetted (forecast) to be collected from customers and the actual revenues received from customers. Transmission businesses are regulated via a revenue cap, which limits the revenues that can be earned in any year. "]
[]
[null,"Actual revenue from customers"]
[null,"$m 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",557.52402469039987,591.94738314293227,640.3363078040552,667.59330877113609,751.99464873635247,855.24019672008649,946.20046843431726,935.49387452722897,961.06003792919216,939.89983054698894,1052.3349674319884,1174.5996453183529,779.28294289980784,719.08864588078734,716.26101119489886,716.32468669107834,735.68100503440348]
[null,"Transgrid","NSW",470.04823595856647,455.93082628451015,469.1281137890702,576.59419742205887,702.20109670316572,793.79355198640667,817.34305552061687,855.49706436339989,801.14676444668419,813.54114800006903,798.30129344046304,693.23893100010275,643.76196742005436,569.77843819760108,555.57876773789064,574.7558423072901,622.13018286497697]
[null,"AEMO/AusNet (T)","VIC",481.96604117697734,528.88808311911237,527.64710002691106,499.46191158903258,594.47214762171279,589.54046191042301,615.95772633123352,691.31324574499331,600.23271544590455,632.65073013031122,545.34896050440136,592.24300395864861,565.21354528046868,545.34699045887669,628.80311377961061,663.39505921062948,662.30612345408974]
[null,"ElectraNet","SA",217.59795337642566,239.23913355850695,246.57380770298258,275.9760025422359,266.97680384618531,308.82743052464252,356.827222601747,369.42479772711323,318.11995741084837,330.35391931132386,316.84450853206312,296.39372997267975,284.41880525443554,280.8751236300086,288.94736309978595,306.23819814837049,310.65531002438496]
[null,"TasNetworks (T)","TAS",171.73121272893337,147.73655335196946,161.38818216845414,173.64504863760706,204.22179728943146,243.47828494083365,255.53622240272077,252.86058550648946,248.00916839123749,212.97255075688295,195.22585977314566,179.61860841881665,176.02606601812499,163.91575153824323,148.11899436900021,137.40770099548089,128.02423596066316]
[null,"NEM Total",null,1898.8674679313026,1963.741979457031,2045.0735114914733,2193.2704689620705,2519.8664941968477,2790.8799260823926,2991.8646952906356,3104.589567869225,2928.5686436238666,2929.4181787455759,2908.0555896820615,2936.0939186686005,2448.703326872891,2279.004949705517,2337.7092501811862,2398.1214873528493,2458.7968573385183]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses."]
[]
[]
[null,"Budgeted revenue from customers"]
[null,"$m 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",null,null,null,null,null,null,null,null,null,952.52119721573774,1078.8346977744832,1183.6143780206962,787.388907543448,722.05870526369108,716.71732630336146,719.92392980520458,743.2054947864217]
[null,"Transgrid","NSW",null,null,null,null,null,null,null,null,null,912.14021020569112,898.69298356183253,808.45509277437168,740.66655052914359,591.49842233397112,679.40161765304197,705.26980839239832,732.51266512788686]
[null,"AEMO/AusNet (T)","VIC",null,null,null,null,null,null,null,null,null,634.90533560249798,634.13716315250645,604.95125483896618,569.64016790232347,546.9168150874151,628.7937006120718,663.39505900389247,662.29784248918065]
[null,"ElectraNet","SA",null,null,null,null,null,null,null,null,null,337.41356533043745,323.82443476143726,303.95934700541557,291.61371939190599,288.11384343556637,288.61264594923625,312.54126313827936,317.33574990154665]
[null,"TasNetworks (T)","TAS",null,null,null,null,null,null,null,null,null,190.78724511960149,173.04088572651614,170.92939560460357,162.00620567195179,163.29229833208717,147.98343475952416,137.93015117235407,128.55200930897269]
[null,"NEM Total",null,null,null,null,null,null,null,null,null,null,3027.7675534739656,3108.5301649767757,3071.9094682440532,2551.3155510387724,2311.8800844527309,2461.5087252772355,2539.0602115121287,2583.9037616140085]
[]
[null,"Sources:"]
[null,"Information requests: All TNSPs 2015 to 2022 (information request issued annually from February 2020). "]
[]
[null,"Note: The AER has not collected budgeted revenues from customers for the years prior to 2015."]

{"sheet":"2. RAB - Closing","index":6,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[60,1,60,19],[59,1,59,19],[29,1,29,13],[3,1,3,17],[43,1,44,19],[42,1,42,19],[57,1,57,19],[56,1,56,19],[31,1,31,19]]}
[]
[]
[]
[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 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",4334.9235019637581,5280.5479480604772,6004.1679040764884,6607.8278135919618,6951.8075510891576,7236.6297682023269,7841.4027354178716,8148.6872185136017,8264.8006368032929,8160.5228298310722,8007.3918983196827,7795.6323108956321,7676.7183673411064,7553.8655594538741,7414.9616395361263,7275.9923653883407,7161.7833141164301]
[null,"Transgrid","NSW",4659.3824604826696,4786.7328159733343,5047.9473397560341,5562.4154389154583,5869.4731026211048,6110.7613333041327,6319.0543813031509,6680.1785275292295,7032.4303135926066,7044.2857322462214,7032.8490238347067,6931.716818394345,6894.1090292182635,6871.8221094977844,6930.0831355194587,7453.0193856812093,7646.2809765666234]
[null,"AusNet (T)*","VIC",2739.8322912045592,2727.7463253704645,2967.598872371454,2952.25581543112,2954.7222011292338,2947.8272142374062,2963.7388588665071,3020.7541083812243,3310.2154334272091,3316.6377685119692,3308.4029650498742,3468.7374138049786,3425.6354798556681,3397.4178263708636,3370.2506879759403,3327.1812436312271,3297.1135678276501]
[null,"ElectraNet","SA",1483.6729201130609,1523.589015089304,1770.5866739559483,1831.8004831842907,1912.1372387655219,2135.814903332338,2276.2647353267193,2462.436842910523,2529.1291204075064,2558.172278350135,2632.1784289746752,2688.7997061505394,2771.7317870568545,2827.055238083869,2884.8684788387641,2973.2542470299168,3211.9819565676175]
[null,"TasNetworks (T)","TAS",1063.9130072283554,1143.0454166409331,1149.3530352003736,1254.8493775194604,1369.5775100894914,1452.2444881736308,1551.5459584001835,1590.5083322885789,1632.3415741482186,1601.3003805792575,1565.7740523961666,1555.8435702740442,1547.4536412598943,1546.5325805487744,1536.23343199538,1523.0470872405097,1510.5382027441951]
[null," Total",null,14281.724180992402,15461.661521134512,16939.653825360299,18209.148928642295,19057.717603694509,19883.277707249832,20952.006669314433,21902.565029623158,22768.917078378836,22680.918989518657,22546.596368575105,22440.729819519536,22315.648304731785,22196.693313955162,22136.397373865671,22552.494328971203,22827.69801782252]
[]
[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."]
[]
[]
[]
[null,"Forecast Closing RAB"]
[null,"$m 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,"2018","2019","2020","2021","2022"]
[null,"Powerlink","QLD",4321.6435604352573,4253.3819899748996,6087.7965436075128,6774.093183578384,7133.2833271417412,7541.5421925370756,7838.8303590184305,8436.0723917992691,8854.7607654602489,9037.5110653585471,9253.5774368545808,9529.3858100451707,7697.5811648292101,7579.0984726908709,7451.5505769450474,7325.515911996411,7186.2859101701861]
[null,"Transgrid","NSW",4767.9475119204426,4929.9872891150562,5286.7313851672498,5538.8775103009648,6057.876948094492,6434.4615743758022,6958.2240071071556,7398.7914292363193,7643.3134273084024,7056.2241989653694,7123.5186709666186,7094.2718728876589,7066.675421046697,6881.861081962511,6987.8301795321204,7349.483450543702,8415.5300254695703]
[null,"AusNet (T)*","VIC",2856.7178822963024,2842.1326241997554,2824.9966139410058,2986.6454099041466,2990.6768290340565,3017.8700365799773,3050.1711916263102,3054.1975141096759,3105.3760932545993,3324.0990045281324,3369.9737774122882,3409.7895162020977,3484.6015607340164,3474.7431636330084,3447.2591878169192,3423.2499810968457,3371.7232817637137]
[null,"ElectraNet","SA",1537.7435357496004,1558.6382288319371,1528.6820728634589,1881.4298944478949,2057.9308385720547,2296.3116309921816,2457.8358839064626,2477.5527492643173,2626.2746296281462,2710.136961504541,2818.8359289348132,2854.3454839565679,2809.7173325244439,2788.6032097592888,2891.8600295751044,2985.7348424045294,3302.1553276182185]
[null,"TasNetworks (T)","TAS",1061.9103443809411,1141.3951998900623,1147.8426035379725,1143.6049224963601,1407.852457393258,1553.7825674471678,1616.4992615957797,1679.4553032678584,1737.3329446943885,1632.2289399363838,1645.0321980263791,1640.615426724012,1627.3447666262343,1601.4148857292766,1543.5230058117752,1542.4556426073214,1535.5998757447937]
[null," Total",null,14545.962834782544,14725.53533201171,16876.049219117202,18324.650920727752,19647.620400235606,20843.968001932204,21921.560703254137,23046.069387677442,23967.057860345787,23760.200170292974,24210.938012194678,24528.408109815507,22685.920245760601,22325.720813774955,22322.022979680965,22626.43982864881,23811.29442076648]
[]
[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. \nUpdates to the model are also taken into account."]
[]
[null,"Notes:"]
[null,"\nAusNet (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:\n\nDuring 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. \n\n* AER, Final decision: AusNet Services transmission determination 2017–22, Attachment 2 – Regulatory asset base, pp. 2-6. "]

{"sheet":"3. Capex","index":7,"n_rows":56,"n_cols":29,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,1,55,19],[54,1,54,19],[3,1,3,13],[29,1,29,13],[31,1,31,19],[43,1,43,19],[42,1,42,19]]}
[]
[]
[]
[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 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",391.01766552670858,350.05244656564832,913.57722747690048,827.93471767044662,576.55744485193418,533.79939762612105,775.43527951094472,539.09025933766941,370.93077895445748,183.16642355444711,150.07439044853334,191.43397448495745,163.61997886450661,179.10407738114426,176.44896760786781,187.23038610544137,205.66339781540475,null,null,null,null,null,{"$f":"Q49-Q37","v":7.8076882628294584},{"$f":"R49-R37","v":47.114233340359135},-162.65817762457277,856.28934344264371]
[null,"Transgrid","NSW",227.17273588394363,308.79900565184721,441.81923222489013,759.44370665486622,526.12561620616771,456.69586169182878,431.37513616201767,583.38695408556043,561.91797159869634,289.46585298518755,279.01651573439949,205.23005056825986,248.48935015711993,249.47367999203215,341.21826763286015,812.3469667760977,486.2952177121561]
[null,"AusNet (T)","VIC",148.7600766547915,151.93217287430241,149.80401458761403,121.35140190584967,142.01578262339862,137.34993433597072,161.16504809194603,205.84566379627455,169.33606519283384,174.27969650912524,156.79518277914971,144.72245106865364,144.99107994802458,153.78988043489645,162.40351431094996,146.45820185505869,135.9495124857263]
[null,"ElectraNet","SA",99.664888541078042,114.81575604886851,231.27800244493474,128.73714896197075,151.39852901790368,292.67783606533351,213.63607839664215,269.91216957202602,154.23813967024105,130.39768908689933,188.54458616203243,167.46909492904425,190.85160126148631,168.16917925327022,194.11939891596589,228.37028738509113,375.63489651692868]
[null,"TasNetworks (T)","TAS",103.32008489052293,143.94172907470235,85.802555234163563,89.348710916864349,172.3967812941018,145.62826023469128,154.43446292104369,102.65180870324475,90.389249051208949,29.014011689619348,27.957531950675119,56.629153736038759,57.013527484618869,64.662964455984138,52.998784344417828,46.539943081318683,46.338317130577202]
[null," Total",null,969.93545149704471,1069.5411102153687,1822.2810319685032,1926.8156861099974,1568.494153993506,1566.151289953945,1736.0460050825943,1700.8868554947751,1346.8122044674376,806.32367382527855,802.3882070747901,765.48472478695396,804.96553771575623,815.19978151732721,927.18893281206158,1420.9457852030075,1249.8813416607929]
[]
[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 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",293.52500601098814,131.46235433868262,996.17085584828806,908.73193147154518,602.25069286097198,664.87071403342725,566.52545065467405,819.16910793953252,676.38862155288666,481.71117643779002,535.57825711639259,606.43002687789453,181.36513315715905,182.10090276732211,185.50290288564116,193.01402664238611,180.47761748404048]
[null,"Transgrid","NSW",275.75503330101088,332.45572552487749,525.22463993496672,439.78355468478389,708.89074409962063,604.2306197974774,742.90425538605029,682.78237896141729,513.18586349036707,295.48022554941235,352.5635726801043,272.38050900797833,254.38766353154284,257.2813682548616,388.33250097321928,649.68878915152493,1342.5845611547998]
[null,"AusNet (T)","VIC",80.962231260197754,109.77757106794226,111.1725711746072,157.75824534062031,151.01144817777916,178.70756024102718,188.78483924170166,165.61495026617294,202.3988376604579,173.29720007834825,209.20408362355528,208.09900286550624,197.45751498115951,172.42550863098293,168.0838148428065,156.43753352548208,117.61692922213633]
[null,"ElectraNet","SA",125.90029103186691,109.85444261847216,72.81212396297947,175.34379029713836,240.24839963618379,306.92834242067772,236.89167707523637,105.3602308341512,249.39793664082578,180.65870420469884,219.22886947335166,157.35457500369535,80.365758311197283,129.5599736442467,231.75702905636334,225.08752292759928,452.99351300040041]
[null,"TasNetworks (T)","TAS",76.392693223893204,126.08764611518534,59.553443642282346,49.69632193597355,209.59256590216032,207.19482074390095,123.69999677445571,130.04741469757855,129.73961486914484,58.60415012752474,74.608792706655166,61.07545892948113,51.540778931363612,39.36630239507793,59.685247426186933,57.35632550012113,53.863392620964675]
[null,"Total",null,852.53525482795681,809.63773966515987,1764.9336345631239,1731.3138437300615,1911.993850676716,1961.9320572365104,1858.8062191321183,1902.9740826988525,1771.1108742136823,1189.7514563977743,1391.1835756000592,1305.3395726845556,765.11684891242237,780.73405569249132,1033.3614951842171,1281.5841977471134,2147.5360134823413]
[]
[null,"Sources:"]
[null,"Forecast capex is sourced from post tax revenue models (PTRMs) 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.\n\nWe reported Transgrid's forecast capex based on the AER's determination of 18 May 2018 inclusive of annual updates, but exclusive of the Humelink contingent project determination. We will update Transgrid's actual and forecast capex in our report in 2024 to include Humelink based on the AER's decision to update the Transgrid determination of 28 April 2023. For those readers interested in the Humelink determinations, please refer to our website: https://www.aer.gov.au/networks-pipelines/determinations-access-arrangements/contingent-projects/transgrid-humelink-contingent-project/final-decision"]

{"sheet":"4. Capex by Driver","index":8,"n_rows":96,"n_cols":19,"rows_kept":96,"cut":false,"hidden":false,"merged":[[51,1,51,16],[52,1,52,16],[79,1,79,16],[78,1,78,16],[3,1,3,13],[36,1,36,16],[48,1,48,16],[47,1,47,16],[49,1,49,16]]}
[]
[]
[]
[null,"Capital expenditure by driver"]
[]
[]
[]
[null,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,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure*",1173.8010272489553,728.1319815827477,812.62599791137825,588.97282334206841,635.49344660566112,603.73409633029587,54.353767597168542,126.5584789573861,28.119959950760808,34.818784486370951,62.490140113061429,200.89968930326103,690.80749097269381,414.04137946634569]
[null,null,"overheads",96.307478185437262,109.91979917252506,100.1152545866351,105.72617891004136,110.31547346946977,92.797904708003969,82.136212836687918,76.304988432900132,85.522173941521828,82.37680759870976,74.686050347083182,71.631420918027544,76.466634193830373,87.570014003304863]
[null,null,"connections",46.579811273938745,68.454485572325922,74.345198597939216,58.257215676030505,38.659601969363919,92.616789881507785,61.546686482284798,84.687112196564954,44.108246535658751,21.107352739777106,26.711107118839788,20.780439500692459,36.811611528533639,7.2797933087084772]
[null,null,"non-network",111.79057681624656,104.23653338457092,128.59328545444501,115.41140682890823,138.77815190796318,137.96264220537893,83.354951892752567,63.264605177369042,78.263563996724656,123.60702326593751,96.568803741965354,138.9523776570021,93.931370801346333,79.54658767565374]
[null,null,"replacement expenditure",520.66585864052001,493.65407412667776,432.42908989092956,622.09102072216581,801.24849709196951,740.42489230005981,575.47246245912197,478.19396543808739,535.4190729441375,532.21160667971924,525.51150684094443,427.19991907586603,516.26960145974238,550.615944033505]
[]
[]
[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 3. Capex."]
[null,"*Does not include Victorian augmentation expenditure"]
[]
[null,"Sources:"]
[null,"Category Analysis RIN responses."]
[]
[null,"Powerlink"]
[null,null,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure",510.66565643669719,246.10843911248264,331.46224136412525,229.34392752996746,216.44613288146053,297.74709160531398,11.031543325698182,13.180398442440021,0,2.3820616377404011,0,9.4026335128839467,0,0]
[null,null,"overheads",38.602521876135839,31.035897998633594,28.452218546549105,27.61351371465835,27.006641257494159,22.411550273524707,14.305129366517532,7.9979295610119392,13.28660910939233,9.1241416494437164,13.231567766188224,4.7417205689246114,5.5217676353769782,11.096389771402052]
[null,null,"connections",20.025216251338151,4.9955683910396305,5.1338711466382509,6.9498559783538081,3.3947496541933311,5.7941578426993035,1.5794614010564558,0,0,0,0,0,0,0]
[null,null,"non-network",32.630823924355781,41.482621504891661,41.613667036511558,35.290851491552289,38.334670511274574,14.913763932495703,8.6960697213773273,14.569182454624187,19.283532343979793,37.923286588482341,23.157333618238056,26.432853543381885,25.284565446570781,21.114575687447761]
[null,null,"replacement expenditure",208.99250161240138,171.48108519805464,88.750622818907232,222.84305534592235,257.40206401140551,281.5462141839036,164.59426671038528,57.189445264723304,127.5336222996925,68.433481379005968,136.33486783344793,35.01346013405805,83.884287718484075,154.11558927276516]
[]
[null,"Transgrid"]
[null,null,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure",573.62094786322405,319.59858263472864,237.79387701370661,203.80916560519162,316.51571565063341,264.88929474829746,24.910237857796584,59.919311434213711,5.2598738174767981,4.8363069601488755,19.128363185389944,83.406722520205932,617.34783345939752,281.41585114797329]
[null,null,"overheads",32.23746324128421,49.715729978635487,35.879811890952425,41.666303716331804,45.569503259647696,37.365315403646491,37.302871824332996,32.895278968583433,34.290419288255165,34.770413767860738,27.060157954214393,31.448900794425935,41.447202799800493,46.557713653279315]
[null,null,"connections",0,0,0,0,0,3.2461033776874011,2.7838900136533167,1.9873314984844663,0.86790114154921538,0.36523249421331538,0.83661994795208661,1.1902547759151691,1.9590254538641159,6.8794660922389426]
[null,null,"non-network",43.549096402170605,28.115697307250283,33.0753801821838,48.92202749844121,60.495333762467837,79.993856609498948,39.778216012581751,23.353475277229069,25.482695321382991,32.323787900658608,30.893236487093603,30.453995070191798,31.10248842707945,39.49288484677281]
[null,null,"replacement expenditure",107.56693712181634,129.29964765399086,152.13694282059751,143.89149833984027,161.92792761325504,177.26031359118974,185.38328800066807,154.19056955149543,133.42611850297584,175.07235580613565,140.82758999602743,162.10118287392638,154.44343595204791,149.88265309596085]
[]
[null,"AusNet (T)"]
[null,null,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure*",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"overheads",13.362987586417812,14.30914244900049,15.418310595011819,16.679532051468904,19.027709059284977,16.608547572182314,14.765882694717748,19.485325749212976,14.715727950064068,10.646203545893172,7.6980712191526779,7.5167287202207236,6.2136540156868669,7.185718491853434]
[null,null,"connections",10.026547759466244,29.921885325742895,6.9955266231167137,4.5320291440128315,18.17794910641992,66.270109828121591,35.767405981548976,80.139469977828085,39.40708568102297,20.4219752182881,22.868996863406924,19.077755929602592,32.772293382562523,42.77304079650569]
[null,null,"non-network",14.667106154897077,11.789832742065485,17.38277076527153,14.335417258537234,19.644547893606415,24.741423029364189,24.390819787353745,11.275774161269966,8.9821283840062325,12.030053284072228,14.068929749148754,63.587256134283493,16.142982939353139,10.850278455698712]
[null,null,"replacement expenditure",95.798787286023895,116.51322369741541,105.37653579124066,133.46535493756596,169.3916359534721,129.82073560160038,134.98155482565636,135.71764461225749,125.36807551010205,119.91651944348691,133.06106329750199,138.06354838966763,123.205528615155,94.224903162282573]
[]
[null,"Notes:"]
[null,"*Augmentation of Vic transmission networks is carried out by AEMO, hence $0 expenditure reported by AusNet (T)"]
[]
[null,"ElectraNet"]
[null,null,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure",15.692726448623825,50.078503817081305,197.93020227860649,96.554097814505809,90.638792428457919,36.042455748168329,18.250289729236098,53.180336893797872,21.489587914622071,24.064379152564229,39.612915096543581,106.41429909614033,71.881813802424801,128.72392342541812]
[null,null,"overheads",7.9750697056982629,10.558179022847265,15.519548890716248,16.102026947048795,15.586320835533508,13.444943450998791,12.612591225399392,11.03882303138937,11.383411336628022,15.469229669303552,11.907601269123949,11.112691127037829,11.639196232251187,12.030863554373456]
[null,null,"connections",15.909918219284274,25.608131702766453,33.970162518992893,17.933920771075559,14.749351754367106,17.17607429888443,21.413231296886668,2.5592274450780073,3.8332597130865631,0.32014502727568778,3.0054903074807782,0.13177506671496392,0,0]
[null,null,"non-network",9.2368537702679436,10.78280101506544,9.0929211653415649,8.5795962682329723,13.950380945647648,12.216831384584053,6.8425184939888535,8.0686620211393798,13.316514461640791,30.864368448689188,23.304274991768281,11.261769239196385,13.318937049669124,12.938816299562227]
[null,null,"replacement expenditure",80.134031729634358,54.587498184260141,36.280207627410292,70.487850111041425,132.39758377128615,73.80814934452836,71.370489594854689,114.58179290209245,117.44965915807872,138.58566701038862,87.354054239438256,65.198864386876522,131.53034063336301,220.83163366941545]
[]
[null,"TasNetworks (T)"]
[null,null,"Reported Capex spent annually ($m 2022)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,null,"augmentation expenditure",73.821696500410297,112.34645601845507,45.439677254940015,59.265632392403546,11.892805645109361,5.0552542285160964,0.16169668443767524,0.27843218693449523,1.3704982186619414,3.5360367359174467,3.7488618311279009,1.6760341740307971,1.577843710871579,3.9016048929543317]
[null,null,"overheads",4.1294357759011495,4.3008497234082244,4.8453646634055083,3.6648024805334982,3.1252990575094182,2.9675480076516547,3.1497377257202626,4.8876311227024116,11.846006257182234,12.366818966208589,14.78865213840394,16.81137970741845,11.64481351071484,10.699328532396601]
[null,null,"connections",0.61812904385007628,7.9289001527769436,28.24563830919136,28.841409782588308,2.337551454383564,0.13034453411504915,2.6977891393866016E-3,1.0832751743977249E-3,0,0,0,0.38065372845973561,2.0802926921070015,0.40032721646953467]
[null,null,"non-network",11.706696564555164,12.065580815298054,27.428546305136553,8.2835143121445132,6.3532187949666969,6.0967672494360476,3.6473278774508944,5.99751126310644,11.198693485714855,10.465527044035159,5.1450288957166643,7.2165036699485237,8.0823969386738383,6.0003108418709363]
[null,null,"replacement expenditure",28.173600890643975,21.772619392956692,49.884780832773835,51.403261987795766,80.129285742550735,77.989479578837759,19.142863327557542,16.514513107518717,31.641597473288503,30.203583040702181,27.933931474528944,26.822863291337459,23.20600854069232,25.786067995363528]

{"sheet":"5. Opex","index":9,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,13],[56,1,56,19],[55,1,55,19],[43,1,43,19],[42,1,42,19],[31,1,31,19]]}
[]
[]
[]
[null,"Operating expenditure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,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 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",173.74064863251309,182.66436886457186,198.60916363660138,190.41645075452439,197.27828575929715,190.22753281855242,197.16957388012736,201.64850149636223,212.31767351552014,242.6295988027716,246.72420435432849,252.14224338558859,204.94033282894625,213.82985284435298,212.90387930079098,218.97488560642046,209.99213472174412]
[null,"Transgrid","NSW",176.79883434272028,175.50042892031718,165.17309373932059,165.7333466599319,186.24723809179557,173.73104111153597,187.21746434641349,172.54217520617587,206.24732687296404,193.06404258537924,191.30468889548692,189.24941520094549,167.7375924870218,165.65213048783201,170.08184746188468,175.18704372023751,188.78156333535671]
[null,"AusNet (T)","VIC",90.16178325003284,87.588765965770151,80.07438033852641,103.1983565954604,103.49254591208914,94.8157934038843,89.271475014901696,91.014690073130282,96.522107354061433,96.31808895450736,99.816330540944278,96.513269053595934,88.700449963113712,92.517171087289768,83.278881667956824,74.583644979956617,83.496717214780915]
[null,"ElectraNet","SA",70.83388838724774,75.372124046431125,68.136764372982455,73.139501108347815,74.757122442626937,81.069915930620638,89.224257001127015,84.960344953413838,86.974652038520631,91.418189563996904,96.464101265597009,99.884679213009917,101.72339008982263,100.11390158305078,105.21078588934424,103.67744261171299,101.9004608715239]
[null,"TasNetworks (T)","TAS",51.87843942490894,53.690418910481029,63.930757139148703,62.270347913547234,62.125114509807673,58.71014370016362,57.753147656115765,54.24926574037827,53.5445951943965,39.829292129968131,42.432113975657572,35.600274170646038,31.650707255326495,33.372553888648234,28.677700992261119,31.937876651336452,32.619259789589449]
[null,"NEM Total",null,563.41359403742285,574.81610670757141,575.92415922657949,594.75800303181165,623.90030671561647,598.55442696475689,620.63591789868531,604.4149774694605,655.60635497546275,663.25921203662324,676.74143903201423,673.38988102378585,594.7524726242309,605.48560989117368,600.15309531223784,604.36089356966397,616.7901359329951]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses."]
[]
[]
[null,"Forecast annual opex"]
[null,"$m 2022","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",132.70515370039027,132.71030657715897,196.8843626935172,197.75757131539908,212.51420848037651,203.17459868943212,209.26054766461544,216.16265706787314,224.38431951177361,230.09490448316333,238.71075773331677,245.63047508948665,217.12093425557816,216.17503914315753,215.15701989950821,214.36688001589167,214.22959988748636]
[null,"Transgrid","NSW",177.22131285058654,176.65848337044235,176.20517746481272,175.92832620701205,208.68340590908764,201.38888601332894,206.52526077517877,218.22839603339725,220.43205506846633,196.91341629382001,195.57839073030661,200.81246033855953,193.2702348523292,189.9672608372471,193.38407256170564,197.99437869794966,207.2182969051608]
[null,"AusNet (T)","VIC",111.87547538617666,111.87547538617673,111.8754753861767,111.05071916817984,110.17736759158817,110.14866670393134,108.79928243681923,108.21216869546346,106.7451842802371,96.929522110297825,99.406139334825511,100.23328730088598,100.56582259633147,101.09985162410636,102.18766307742239,102.32011557295907,102.82991075186051]
[null,"ElectraNet","SA",75.630549203150593,75.630549203150622,75.630549203150508,75.363011175478448,77.725405753694545,80.414314549772143,84.239362114034023,87.438794926173927,94.946399979368053,98.552860798313063,100.34333120840587,105.74030744541611,106.15330202245799,97.792986481001833,98.314361732208766,100.12008738819547,101.38726638797165]
[null,"TasNetworks (T)","TAS",47.837501160455851,46.060832419620127,42.185203858656919,42.052271276805328,65.485717358724443,66.404776655459628,65.905876184790898,69.017704202762957,68.601426526529295,50.935813290921054,50.240600189739546,50.511597585411586,50.774513116950246,50.212765101896942,31.953922894595685,32.062893717764759,32.222358556951981]
[null,"NEM Total",null,545.2699923007599,542.93564695654879,602.78076860631404,602.15189914287464,674.58610509347125,661.5312426119242,674.73032917543844,699.05972092567072,715.10938536637434,673.42651697651525,684.27921919659434,702.92812775975983,667.88480684364708,655.24790318740975,640.99704016544069,646.86435539276056,657.88743248943138]
[]
[null,"Sources:"]
[null,"Forecast capex is sourced from post tax revenue models (PTRMs) 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":10,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,1,3,12],[28,1,32,18],[43,1,43,18],[44,1,44,18],[45,1,45,18]]}
[]
[]
[]
[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 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,2018,2019,2020,2021]
[null,"Powerlink","QLD",2,2,2,2,0,4,1,0,5,2,1,6,2,0,0,3]
[null,"TransGrid","NSW",2,5,2,3,3,3,3,7,3,4,2,1,1,3,1,0]
[null,"AusNet (T)","VIC",5,2,1,6,1,0,2,5,3,2,3,0,0,1,3,0]
[null,"ElectraNet","SA",4,1,4,4,12,7,7,5,4,1,5,4,3,4,1,0]
[null,"TasNetworks (T)","TAS",16,10,6,8,9,11,10,10,5,4,2,4,2,2,8,2]
[null,"Total loss of supply events (LHS)",null,29,20,15,23,25,25,23,27,20,13,13,15,8,10,13,5]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses: 2006-13."]
[null,"AER analysis: 2014 to 2021."]

{"sheet":"7. Reliability -outage duration","index":11,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,1,3,12],[28,1,34,18],[44,1,44,18],[45,1,45,18],[46,1,46,18]]}
[]
[]
[]
[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."]
[]
[]
[]
[]
[]
[]
[]
[null,"Average outage duration"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021]
[null,"Powerlink","QLD",39.034769685990298,1249.94338791423,35.289638071895403,62.276197516025597,16.620001587301601,86.769421575429206,26.086666666666702,5.6214285714285701,115.971,236.2286666,30.060000000000002,27.451875000000001,36.238181818181822,15,36.203749999999999,51.068750000000001]
[null,"TransGrid","NSW",64.84,125.4,34.28,84.96,225.83,137.11000000000001,94.23,178.69,71.14,63.55,169.17750790715218,35.639999896287918,58.200000151991844,69.824999794363976,45.171428727252142,72.238095060428805]
[null,"AusNet (T)","VIC",61.9,27.6,71.5,103.1,92.5,4,230,19.899999999999999,24,97.5,39.833333333333336,19,24.5,87,72.300000000756697,47.3]
[null,"ElectraNet","SA",88.46,269.94,200.2,161.27000000000001,126.85,242.28,124.76,154.16999999999999,130.71,147,250.57142857142784,97.4,463,192,205,199.87499999954406]
[null,"TasNetworks (T)","TAS",53.846150000000002,142.7619,112.9,67.157889999999995,127.7692,90.866669999999999,110.88460000000001,160.94120000000001,201,74,15,410.45454545511694,45.909090909154408,273,105.0000000002794,19]
[]
[null,"Sources:                                                                                                   "]
[null,"Economic Benchmarking RIN responses: 2006-13."]
[null,"AER analysis: 2014 to 2021."]

{"sheet":"8. Market impact","index":12,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,12],[29,1,29,18],[39,1,39,18],[40,1,40,18],[41,1,41,18]]}
[]
[]
[]
[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."]
[]
[null,"Market impact indicator"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021]
[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.183409436834094E-4,3.9954337899543381E-4,6.9444444444444447E-4,4.2427701674277018E-3,0.13254375951293759,0.23687214611872145,0.11093036529680365]
[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,6.7323059360730589E-2,1.3622526636225266E-2,0.15904680365296803,0.32745433789954337]
[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.2857686453576863E-3,9.2180365296803644E-3,6.3641552511415525E-2,4.2760654490106548E-2,3.0251141552511416E-3,1.8873668188736682E-2,9.1990106544901067E-3,3.5730593607305933E-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,9.1324200913242006E-4,0.10271118721461187,0.11115391933028919,2.2146118721461189E-2,6.8683409436834097E-2,7.4728881278538814E-2,6.8730974124809746E-2,0.13810882800608829]
[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.5468036529680365E-2,2.349695585996956E-3,2.7245053272450533E-2,2.5703957382039573E-2,3.9278919330289194E-2,1.6695205479452056E-2,1.3261035007610351E-2,1.310882800608828E-2]
[]
[null,"Sources:                                                                                                   "]
[null,"Economic Benchmarking RIN responses: 2006-13."]
[null,"AER analysis: 2014 to 2021."]

{"sheet":"9. Maximum demand","index":13,"n_rows":43,"n_cols":20,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,1,42,19],[3,1,3,13],[26,1,27,19],[38,1,38,19],[39,1,39,19],[41,1,41,19]]}
[]
[]
[]
[null,"Maximum demand"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Maximum demand is reported as the coincident maximum demand on each transmisison 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,2019,2020,2021,2022]
[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,8968.9724920000008,8766.4130399999995,8478.9833699999999,9171.1070779999991]
[null,"TransGrid","NSW",12600,12400,13200,13700,13200,13700,11900,12700,12100,10900,11900,13200,12200,13000,13500,11700,12000]
[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,8683.9030000000002,8947.7000000000007,7786.0590000000002,7969]
[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,3192.8984160999998,2922.5114060000001,2744.4459701999899,2501.1071460869998]
[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,2147.1028240000001,2047.92679399999,2040.7527340039901,2117.4323960499901]
[]
[]
[null,"Notes:"]
[null,"AEMO 2007 - this data is an average of the reported amounts in 2006 and 2008. "]
[]
[null,"Sources:"]
[null,"Economic benchmarking RIN responses, 2006-13 and 2014 to 2022.\nAEMO responses to AER data request."]

{"sheet":"10. Energy delivered","index":14,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,19],[40,1,40,19],[41,1,41,19]]}
[]
[]
[]
[null,"Energy delivered"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Energy delivered is a measure of energy transported through the transmission networks in each year. The chart shows energy delivered to distribution networks and directly connected end users but excludes energy delivered to other transmisson networks. "]
[]
[null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Transmission total",null,182631.49885557801,186176.66682195303,187629.683496529,187179.75041948701,185093.70975965209,181765.99551489801,179217.082923487,174799.60999226087,170562.854865181,173326.24864551096,177091.91910189003,177372.37977258896,177652.72599460339,173893.61086704468,170294.07134627813,168026.76317128178,170660.9990665798]
[]
[null,"Energy delivered (GWh) -  including energy delivered to other transmission networks"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",51045.96344425701,51964.465679886984,51187.327595034978,52191.948260312034,52848.520626357022,51917.071191967989,50878.576976755998,49333.938670689997,47613.581421290997,53087.563425,52872.387581990006,54253.300021025992,54849.858036833997,53765.29422406599,53076.368905469993,51783.263917914992,51131.761323307503]
[null,"TransGrid","NSW",81538.366632759004,83028.257359986004,82531.571031917003,81126.238029020999,80626.119478492008,79831.334420277999,76646.150635604004,71147.668184577997,67800,74400,72200,75000,75700,74400,72900,71300,68200]
[null,"AEMO","VIC",45186.299678676005,45956.437073730005,45046.718030759999,47419.179046665005,48976.636241104992,48047.970992500006,47529.361264941996,49056.428480178998,48503.771563634997,47967.077018124997,47805.245822115998,46829.301624718995,41725,41479.993999999999,41527.840000000004,42258.700000000004,44066.71]
[null,"ElectraNet","SA",15241.186994052407,14809.02240557884,14506.431798357989,14847.610973429968,15008.379403305271,15262.885728180965,15068.932757169014,15061.136823993089,14707.393943953022,14485.733990000001,15043.149099044002,15106.1610945133,14127.75806308338,13786.71468798471,13856.515144038129,13621.7689999098,13615.85709313897]
[null,"TasNetworks (T)","TAS",10530.108800000002,12828.493,13500.337,13412.710999999999,13030.212,13108.442999999999,12589.843000000001,12866.188,13359.963803999997,13109.624082295986,11654.573903348006,12426.663323709681,12434.326120010006,12884.563992276986,12412.888664812004,12909.204958704957,13236.63157566114]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13 and 2014 to 2022."]

{"sheet":"11. Circuit length","index":15,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,19],[55,1,55,19],[56,1,56,19]]}
[]
[]
[]
[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. \nCircuit length is always greater than or equal to route length, for example a double circuit line that traverses 10 kms is counted as 20 km of circuit length."]
[]
[null,"Circuit length"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,{"$f":"B40","v":"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,14526.2,14528.2,14534.2,14535.2]
[null,"TransGrid","NSW",12517.231,12526.493999999999,12523.513999999999,12523.349,12682.459000000001,12681.862999999999,12697.207,12893.617,12929.665999999999,13024.7646976,13039.195,13078.1133974,13089.494696939964,13052.375219753239,13052.451309999999,13038.453,13074.842999999999]
[null,"AusNet (T)","VIC",6573,6573,6573,6573,6573,6573,6573,6573,6573,6573.2,6558.8447567553667,6559.9720813333333,6623.72,6627.7700000000013,6731.1111999999994,6734.0199999999995,6628.5450000000001]
[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,5512.668999999999,5519.5789999999997,5515.1390000000001,5518.0389999999998]
[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,3545.2,3350.5371820000005,3350.2350000000001,3360.9470000000006]
[null,"Total",null,39972.870000000003,40133.262999999999,40666.283000000003,40985.418000000005,41559.528000000006,41991.232000000004,41991.97600000001,42810.656000000003,43308.369054000003,43437.513697599999,43441.588756755365,43253.854478733338,43308.083696939961,43264.214219753245,43181.878691999998,43172.046999999999,43117.573999999993]
[]
[null,"Circuit length - overhead"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,"Powerlink","QLD",11685,11877,12413,12848,13304,13717,13681,14292,14751,14733,14734,14511,14506,14506,14508,14514,14515]
[null,"TransGrid","NSW",12469.323,12478.585999999999,12475.606,12475.441000000001,12634.551000000001,12633.955,12649.299000000001,12845.709000000001,12878.228999999999,12942.540697599999,12956.955,12996.5323974,13007.854696939965,12966.96721975324,12966.743309999998,12952.744999999999,12968.514999999999]
[null,"AusNet (T)","VIC",6562,6562,6562,6562,6562,6562,6562,6562,6562,6562,6547.6447567553669,6551.4297109999998,6615.18,6619.2300000000014,6722.5711999999994,6725.48,6620.0050000000001]
[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,5485.4699999999993,5492.38,5487.9400000000005,5490.84]
[null,"TasNetworks (T)","TAS",3568,3609,3609,3507,3468,3480,3480,3480,3480,3539.9,3539.9,3539.8999999999996,3521.3999999999996,3521.3999999999996,3326.3731820000003,3326.0709999999999,3336.7830000000004]
[null,"Total",null,39876.073000000004,40036.466,40569.485999999997,40887.320999999996,41461.430999999997,41888.834999999999,41871.178999999996,42679.869000000006,43173.443054000003,43271.600697599999,43275.659756755376,43091.2321084,43145.404696939971,43099.067219753248,43016.067691999997,43006.236000000004,42931.143000000004]
[]
[null,"Circuit length - underground"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019,2020,2021,2022]
[null,{"$f":"B40","v":"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.5,20.200000000000003,20.200000000000003,20.200000000000003,20.200000000000003]
[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,85.408000000000001,85.707999999999998,85.707999999999998,106.32799999999999]
[null,"AusNet (T)","VIC",11,11,11,11,11,11,11,11,11,11.2,11.2,8.5423703333333396,8.5399999999999991,8.5399999999999991,8.5399999999999991,8.5399999999999991,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,27.199000000000002,27.199000000000002,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,23.8,24.164000000000001,24.164000000000001,24.164000000000001]
[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,165.14700000000002,165.81100000000004,165.81100000000004,186.43099999999998]
[]
[null,"Sources:"]
[null,"Economic benchmarking RIN responses, 2006-13 and 2014 to 2022."]