{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["New data sheet","Calculations","Introduction","Dashboard","Contents","1. Revenue","2. RAB - Closing","3. Capex","4. Capex by Driver","5. Opex","6. Reliability -outage events","7. Reliability -outage duration","8. Market impact","9. Maximum demand","10. Energy delivered","11. Circuit length","12. Return on assets"],"not_rendered":{"charts":22,"images":2,"macros":1,"external_links":5,"defined_names":348,"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":"New data sheet","index":0,"n_rows":227,"n_cols":12,"rows_kept":227,"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","2006",524.43109000144091,442.14759870463524,457.00205241091709,204.68199901278044,161.53776893958144,1789.800509069355,{"$f":"D7&E7","v":"Actual Revenue2006"}]
[null,null,null,"Actual Revenue","2007",556.81118232983226,428.86815563942804,501.49371289907765,225.03862439427624,138.96735974822522,1851.1790350108395,{"$f":"D8&E8","v":"Actual Revenue2007"}]
[null,null,null,"Actual Revenue","2008",602.32788722541363,441.2820921956548,509.02960279439526,231.93793453347348,151.80866929448166,1936.3861860434188,"Actual Revenue2008"]
[null,null,null,"Actual Revenue","2009",627.96699530738965,542.36931513484524,479.74628692122536,259.59490428746028,163.33800535491272,2073.0155070058331,"Actual Revenue2009"]
[null,null,null,"Actual Revenue","2010",707.35852778910271,660.52056994090231,570.78363351286453,251.12987072423661,192.09981097052099,2381.8924129376273,"Actual Revenue2010"]
[null,null,null,"Actual Revenue","2011",804.47573327091129,746.67637495176916,569.35035616253583,290.49637116951084,229.02615261128855,2640.0249881660156,"Actual Revenue2011"]
[null,null,null,"Actual Revenue","2012",890.03687921150242,768.82805140067501,599.02342934853164,335.647041210711,240.36836748681193,2833.9037686582319,"Actual Revenue2012"]
[null,null,null,"Actual Revenue","2013",879.96579623707089,804.71735403020557,674.18669548291825,347.49686249516668,237.85154827939371,2944.2182565247549,"Actual Revenue2013"]
[null,null,null,"Actual Revenue","2014",904.01442974213751,753.59312302858166,593.53490582093468,299.23732185142592,233.28809656587211,2783.6678770089516,"Actual Revenue2014"]
[null,null,null,"Actual Revenue","2015",884.11022807428935,765.25181357632675,599.88185354879454,310.74511288888806,200.33114626018542,2760.3201543484838,"Actual Revenue2015"]
[null,null,null,"Actual Revenue",2016,989.87155633956502,750.91655054869432,601.12793989034321,298.03757974862862,183.63784501332125,2823.591471540552,"Actual Revenue2016"]
[null,null,null,"Actual Revenue",2017,1104.8789738732394,652.09037120454684,561.56730472584013,278.80069736094504,168.95699275009838,2766.2943399146698,"Actual Revenue2017"]
[null,null,null,"Actual Revenue",2018,733.02707159824888,605.55021007937171,535.93765571707297,267.5365678444428,165.57769276725432,2307.6291980063907,"Actual Revenue2018"]
[null,null,null,"Actual Revenue",2019,676.40572543279154,535.95811870029775,517.10082269381087,264.20322841041957,154.18620981462078,2147.8541050519407,"Actual Revenue2019"]
[null,null,null,"Budgeted revenue","2006",null,null,null,null,null,null,"Budgeted revenue2006"]
[null,null,null,"Budgeted revenue","2007",null,null,null,null,null,null,"Budgeted revenue2007"]
[null,null,null,"Budgeted revenue","2008",null,null,null,null,null,null,"Budgeted revenue2008"]
[null,null,null,"Budgeted revenue","2009",null,null,null,null,null,null,"Budgeted revenue2009"]
[null,null,null,"Budgeted revenue","2010",null,null,null,null,null,null,"Budgeted revenue2010"]
[null,null,null,"Budgeted revenue","2011",null,null,null,null,null,null,"Budgeted revenue2011"]
[null,null,null,"Budgeted revenue","2012",null,null,null,null,null,null,"Budgeted revenue2012"]
[null,null,null,"Budgeted revenue","2013",null,null,null,null,null,null,"Budgeted revenue2013"]
[null,null,null,"Budgeted revenue","2014",null,null,null,null,null,null,"Budgeted revenue2014"]
[null,null,null,"Budgeted revenue","2015",895.98242870828949,857.99833457930742,602.01967912183704,317.38571973786463,179.46269305974164,2852.8488552070403,"Budgeted revenue2015"]
[null,null,null,"Budgeted revenue",2016,1014.7983430838242,845.34929451281835,601.29129505271112,304.60319873273079,162.7697037213145,2928.8118351033991,"Budgeted revenue2016"]
[null,null,null,"Budgeted revenue",2017,1113.358619391272,760.46765115874348,573.61710463009774,285.91724231919039,160.78354524719884,2894.1441627465028,"Budgeted revenue2017"]
[null,null,null,"Budgeted revenue",2018,740.65189077252194,696.70283112427694,540.13499629836394,274.30441370664704,152.3900087977708,2404.1841406995809,"Budgeted revenue2018"]
[null,null,null,"Budgeted revenue",2019,679.19949110129369,556.38887047243134,518.58862583476673,271.01227976915118,153.59976289934951,2178.7890300769923,"Budgeted revenue2019"]
[null,null,null,"Actual Closing RAB","2006",4077.6155941802708,4382.8156532652474,2597.9195075331359,1395.6065967427792,1000.7623588190914,13454.719710540523,"Actual Closing RAB2006"]
[null,null,null,"Actual Closing RAB","2007",4967.1106419925763,4502.6068780095338,2586.4595482835903,1433.1533934187105,1075.1977084808755,14564.528170185285,"Actual Closing RAB2007"]
[null,null,null,"Actual Closing RAB","2008",5647.7787127380516,4748.31650013327,2813.8886550890547,1665.4900205966555,1081.1309259386906,15956.604814495722,"Actual Closing RAB2008"]
[null,null,null,"Actual Closing RAB","2009",6215.6072014084457,5232.2473337201473,2799.3403095357771,1723.0703638196749,1180.3653254325675,17150.630533916614,"Actual Closing RAB2009"]
[null,null,null,"Actual Closing RAB","2010",6539.1693452536529,5521.078986059887,2801.6789459329043,1798.6385733152979,1288.2835441154996,17948.849394677243,"Actual Closing RAB2010"]
[null,null,null,"Actual Closing RAB","2011",6807.0853796527899,5748.045079389989,2795.1410928650225,2009.0394103068379,1366.0436611756986,18725.35462339034,"Actual Closing RAB2011"]
[null,null,null,"Actual Closing RAB","2012",7375.9608582949795,5943.9744839792884,2810.2285754498539,2141.1525663708012,1459.450897390441,19730.767381485362,"Actual Closing RAB2012"]
[null,null,null,"Actual Closing RAB","2013",7665.0058667139956,6283.6633964639923,2864.2906541459452,2316.2740624574762,1496.1005829688888,20625.334562750297,"Actual Closing RAB2013"]
[null,null,null,"Actual Closing RAB","2014",7774.2271447588764,6615.0065851683476,3138.7589949372295,2379.0076886933093,1535.4507305054631,21442.451144063227,"Actual Closing RAB2014"]
[null,null,null,"Actual Closing RAB","2015",7676.1389520505281,6626.1583021376091,3144.8486777452649,2406.3269328916058,1506.252048013956,21359.724912838967,"Actual Closing RAB2015"]
[null,null,null,"Actual Closing RAB",2016,7532.0974080649585,6615.4004420407382,3137.0404054566693,2475.9403029349505,1472.8344548920275,21233.313013389343,"Actual Closing RAB2016"]
[null,null,null,"Actual Closing RAB",2017,7332.9072273140655,6520.2711375004037,3289.0701459220222,2529.2007128752989,1463.4934160615776,21134.942639673369,"Actual Closing RAB2017"]
[null,null,null,"Actual Closing RAB",2018,7240.6760998105319,6484.8956325952631,3304.1125910051123,2605.832373403246,1455.6014877803323,21091.118184594485,"Actual Closing RAB2018"]
[null,null,null,"Actual Closing RAB",2019,7129.226180824674,6452.0147322060511,3294.7648209887006,2616.2271963527569,1454.7350984387058,20946.968028810887,"Actual Closing RAB2019"]
[null,null,null,"Forecast Closing RAB","2006",4065.1239096922081,4484.9366126143777,2708.7508741907263,1446.4677446746014,998.87856796261929,13704.157709134533,"Forecast Closing RAB2006"]
[null,null,null,"Forecast Closing RAB","2007",4000.9141389623915,4637.3582002310759,2694.9210764132981,1466.1221921659007,1073.6454435899132,13872.961051362581,"Forecast Closing RAB2007"]
[null,null,null,"Forecast Closing RAB","2008",5726.4434099391283,4972.9270490320268,2678.6726456332813,1437.9441427347106,1079.7101489174199,15895.697396256568,"Forecast Closing RAB2008"]
[null,null,null,"Forecast Closing RAB","2009",6372.0035634484138,5210.1065451388449,2831.9486551722675,1769.7539237964174,1075.7240037661588,17259.536691322101,"Forecast Closing RAB2009"]
[null,null,null,"Forecast Closing RAB","2010",6709.8732698010836,5698.2997508456847,2835.771262283753,1935.7783073460193,1324.2866066658758,18504.009196942417,"Forecast Closing RAB2010"]
[null,null,null,"Forecast Closing RAB","2011",7093.8991275224989,6052.5314561935629,2861.5559661806783,2160.0095391278542,1461.5547481098256,19629.550837134419,"Forecast Closing RAB2011"]
[null,null,null,"Forecast Closing RAB","2012",7373.5411703545069,6545.2049399087091,2892.184045527034,2311.9462024215027,1520.5487695637134,20643.425127775467,"Forecast Closing RAB2012"]
[null,null,null,"Forecast Closing RAB","2013",7935.3327279826763,6959.6216164539501,2896.0018199786796,2330.4927344687508,1579.7679315982082,21701.216830482266,"Forecast Closing RAB2013"]
[null,null,null,"Forecast Closing RAB","2014",8329.1690300001355,7189.6295305514323,2944.5295454001398,2470.3869352067004,1634.2101318188768,22567.925172977284,"Forecast Closing RAB2014"]
[null,null,null,"Forecast Closing RAB","2015",8501.0718265244213,6637.3881376912841,3151.9234504088658,2549.2714534844968,1535.3447819187331,22374.999650027799,"Forecast Closing RAB2015"]
[null,null,null,"Forecast Closing RAB",2016,8704.3131537107147,6700.688213992541,3195.422086351653,2651.5183799790893,1547.3880774510374,22799.329911485034,"Forecast Closing RAB2016"]
[null,null,null,"Forecast Closing RAB",2017,8963.7503786162906,6673.1774171185989,3233.1755228816728,2684.9201955436588,1543.2334722935757,23098.256986453795,"Forecast Closing RAB2017"]
[null,null,null,"Forecast Closing RAB","2018",7240.6760998105319,6647.2190069367871,3304.1125910051123,2642.9410357876372,1530.7505183186668,21365.699251858732,"Forecast Closing RAB2018"]
[null,null,null,"Forecast Closing RAB","2019",7129.226180824674,6452.0147322060511,3294.7648209887006,2616.2271963527569,1506.359756485667,20998.59268685785,"Forecast Closing RAB2019"]
[null,null,null,"Actual annual capex","2006",367.80804317063115,213.68845147863053,141.05487636022383,93.749083120668189,97.187318103945827,913.48777223409945,"Actual annual capex2006"]
[null,null,null,"Actual annual capex","2007",329.27439532679745,290.46963351092973,144.06267018574292,108.00064109790542,135.39778472731695,1007.2051248486925,"Actual annual capex2007"]
[null,null,null,"Actual annual capex","2008",859.35005486491582,415.59418299142607,142.04474231991779,217.55004187112186,80.70957586329817,1715.2485979106798,"Actual annual capex2008"]
[null,null,null,"Actual annual capex","2009",778.79102461828234,714.36543222852436,115.06586563336604,121.09570236241365,84.045242503002441,1813.3632673455886,"Actual annual capex2009"]
[null,null,null,"Actual annual capex","2010",542.33474408578684,494.89639578832578,134.65991084173612,142.41197164833386,162.16383137392475,1476.4668537381074,"Actual annual capex2010"]
[null,null,null,"Actual annual capex","2011",502.11468482390939,429.58778086593577,130.23573556501825,275.30536764265872,136.98420851424882,1474.2277774117711,"Actual annual capex2011"]
[null,null,null,"Actual annual capex","2012",729.40779383510721,405.77001678553955,152.8173179485037,200.95528891225734,145.26770172539977,1634.2181192068076,"Actual annual capex2012"]
[null,null,null,"Actual annual capex","2013",507.09149703568022,548.75887437067161,195.18364946430336,253.89100204590468,96.558708763728205,1601.4837316802882,"Actual annual capex2013"]
[null,null,null,"Actual annual capex","2014",348.91345324570295,528.56422555161953,160.56510776429943,145.08303162716064,85.024017450477928,1268.1498356392603,"Actual annual capex2014"]
[null,null,null,"Actual annual capex","2015",172.29422034264124,272.28403813363633,165.25267797648971,122.65767786327483,27.291827978446722,759.78044229448881,{"$f":"D72&E72","v":"Actual annual capex2015"}]
[null,null,null,"Actual annual capex",2016,141.16642992726759,262.45494184084839,148.67379486577693,177.3531515341142,26.298057671657247,755.94637583966437,"Actual annual capex2016"]
[null,null,null,"Actual annual capex",2017,180.07103453201665,193.04821739355646,183.1132335725527,157.52863752187866,53.267818971821988,767.0289419918264,"Actual annual capex2017"]
[null,null,null,"Actual annual capex",2018,153.53567846646644,233.73977619890542,137.481099198838,179.52322921628581,53.629377460799475,757.90916054129514,"Actual annual capex2018"]
[null,null,null,"Actual annual capex",2019,169.2739498492343,211.09760648761701,145.82415563375707,155.25545173865422,60.824767060410309,742.27593076967287,"Actual annual capex2019"]
[null,null,null,"Forecast annual capex","2006",276.10225215048547,259.38705111002002,76.768698813971881,118.42723171258032,71.858254714313617,802.54348850137137,"Forecast annual capex2006"]
[null,null,null,"Forecast annual capex","2007",123.65914781569455,312.72216226206621,104.09151475531688,103.33381618110185,118.60346596655143,762.41010698073092,"Forecast annual capex2007"]
[null,null,null,"Forecast annual capex","2008",937.04117602876761,494.04889873520096,105.41425921735924,68.490217181994581,56.018531900943408,1661.0130830642656,"Forecast annual capex2008"]
[null,null,null,"Forecast annual capex","2009",854.79236093077623,413.679337094262,149.58697448755547,164.93591486317843,46.74649903458036,1629.7410864103524,"Forecast annual capex2009"]
[null,null,null,"Forecast annual capex","2010",566.50291884119383,666.81314016295721,143.18963549020822,225.98798349949428,197.15178705223821,1799.6454650460919,"Forecast annual capex2010"]
[null,null,null,"Forecast annual capex","2011",625.40600553350316,568.36532332145248,169.45119538309584,288.71000717394423,194.89636477229269,1846.8288961842884,"Forecast annual capex2011"]
[null,null,null,"Forecast annual capex","2012",532.89821862900419,698.80771260963195,179.00651005792082,222.83050580613812,116.35754024703543,1749.9004873497304,"Forecast annual capex2012"]
[null,null,null,"Forecast annual capex","2013",770.54571488788827,642.25448837178669,157.03673229081551,99.106367173756695,122.3281946990413,1791.2714974232886,"Forecast annual capex2013"]
[null,null,null,"Forecast annual capex","2014",636.24024500564326,482.72470753710542,191.91535567637391,234.5944317454109,122.03866493462019,1667.5134048991536,"Forecast annual capex2014"]
[null,null,null,"Forecast annual capex","2015",453.11826242004912,277.94141578885512,164.32107108514978,169.93535160557482,55.125585569254802,1120.4416864688835,"Forecast annual capex2015"]
[null,null,null,"Forecast annual capex",2016,503.78795661154589,331.63646861335616,198.36811605073859,206.21610887806702,70.180241119780675,1310.1888912734883,"Forecast annual capex2016"]
[null,null,null,"Forecast annual capex",2017,570.43418027013945,256.21282834138896,197.32027422919668,148.01448481386407,57.450204978184928,1229.4319726327742,"Forecast annual capex2017"]
[null,null,null,"Forecast annual capex",2018,170.59984907858166,239.28798358573115,187.22997452265381,75.595490711522245,48.481474658438735,721.19477255692766,"Forecast annual capex2018"]
[null,null,null,"Forecast annual capex",2019,171.29194563686369,221.06413399695066,163.4945299049007,115.122484340315,37.029638114413977,708.00273199344406,"Forecast annual capex2019"]
[null,null,null,"Actual annual opex","2006",163.42793082415326,166.3045919085269,85.491749364066038,66.629403668466608,48.799092649481373,530.65276841469426,"Actual annual opex2006"]
[null,null,null,"Actual annual opex","2007",171.82196609602371,165.08325589289524,83.052004487176035,70.898263427022357,50.503518529974343,541.35900843309162,"Actual annual opex2007"]
[null,null,null,"Actual annual opex","2008",186.82032622371156,155.36891999716806,75.926835158084643,64.092372753151736,60.136021348531493,542.34447548064747,"Actual annual opex2008"]
[null,null,null,"Actual annual opex","2009",179.1139079232577,155.89591800410699,97.853078308978596,68.798162213210517,58.574168977211208,560.23523542676492,"Actual annual opex2009"]
[null,null,null,"Actual annual opex","2010",185.56844521958695,175.19216707563015,98.132029749558626,70.319766452628002,58.437556187708793,587.64996468511254,"Actual annual opex2010"]
[null,null,null,"Actual annual opex","2011",178.9362035828257,163.41889357647469,89.904699677033193,76.257851670929952,55.225287684985268,563.74293619224875,"Actual annual opex2011"]
[null,null,null,"Actual annual opex","2012",185.46618614775318,176.10480364324539,84.647555674113235,83.928175794134972,54.325096022776371,584.47181728202315,"Actual annual opex2012"]
[null,null,null,"Actual annual opex","2013",189.67925820886157,162.30059514447379,86.300478891397375,79.917356629715925,51.029193907478657,569.22688278192732,"Actual annual opex2013"]
[null,null,null,"Actual annual opex","2014",199.71514054510263,194.00511126302777,91.522633121854383,81.812100557256798,50.366350467276668,617.42133595451821,"Actual annual opex2014"]
[null,null,null,"Actual annual opex","2015",228.22784190763559,181.60434673530011,91.329182091367116,85.991883176026931,37.465146183259606,624.61840009358934,"Actual annual opex2015"]
[null,null,null,"Actual annual opex",2016,232.07940409586752,179.94942294291022,94.646228207161087,90.738284867309929,39.913472420630818,637.32681253387955,"Actual annual opex2016"]
[null,null,null,"Actual annual opex",2017,237.17584476748249,178.01614405958637,91.514252611388031,93.955827685114514,33.487149900005797,634.14921902357719,"Actual annual opex2017"]
[null,null,null,"Actual annual opex",2018,192.77569642030207,157.78119787938235,84.106107525592932,95.685398262561392,29.772017294581474,560.12041738242021,"Actual annual opex2018"]
[null,null,null,"Actual annual opex",2019,201.13756149662501,155.81952257758931,87.725137162968934,94.171444110684774,31.391660335488488,570.24532568335655,"Actual annual opex2019"]
[null,null,null,"Forecast annual opex","2006",124.82817837769656,166.70199337388277,106.08075569198859,71.141349250449053,44.998012221006,513.75028891502302,"Forecast annual opex2006"]
[null,null,null,"Forecast annual opex","2007",124.8330253953331,166.17257174416758,106.08075569198866,71.141349250449068,43.326801146567774,511.55450322850618,"Forecast annual opex2007"]
[null,null,null,"Forecast annual opex","2008",185.1979042319067,165.74617270185647,106.08075569198863,71.141349250448968,39.681218139099492,567.84740001530042,"Forecast annual opex2008"]
[null,null,null,"Forecast annual opex","2009",186.01928183913441,165.48575449480737,105.29871867659485,70.889691468442848,39.556176032015671,567.2496225109951,"Forecast annual opex2009"]
[null,null,null,"Forecast annual opex","2010",199.90000979069188,196.29659203814424,104.47060335543232,73.111861471529892,61.598683846912273,635.37775050271068,"Forecast annual opex2010"]
[null,null,null,"Forecast annual opex","2011",191.11477090242514,189.43505271327976,104.4433890634603,75.641164799085161,62.46319057203582,623.09756805028621,"Forecast annual opex2011"]
[null,null,null,"Forecast annual opex","2012",196.83947640999659,194.26654785200245,103.16389771578091,79.239169144363657,61.993903319741484,635.50299444188511,"Forecast annual opex2012"]
[null,null,null,"Forecast annual opex","2013",203.33189753870056,205.27502050627064,102.60719420998407,82.24869333121579,64.921022667232108,658.38382825340318,"Forecast annual opex2013"]
[null,null,null,"Forecast annual opex","2014",211.0655470428147,207.34787702647986,101.21619394993233,89.310669725028362,64.52945397095624,673.46974171521151,"Forecast annual opex2014"]
[null,null,null,"Forecast annual opex","2015",216.43716901507824,185.22523329863955,91.908945359388071,92.703061971043439,47.91241794306778,634.18682758721707,"Forecast annual opex2015"]
[null,null,null,"Forecast annual opex",2016,224.54161135508247,183.96945080237506,94.257283329178307,94.387255489523142,47.258470582434555,644.41407155859361,"Forecast annual opex2016"]
[null,null,null,"Forecast annual opex",2017,231.05059528203205,188.8928419178051,95.041588209277393,99.463883590453648,47.513382394851533,661.96229139441971,"Forecast annual opex2017"]
[null,null,null,"Forecast annual opex",2018,204.23329429976584,181.79830005482995,95.356899454332932,99.852364062345487,47.760692058071328,629.00154992934552,"Forecast annual opex2018"]
[null,null,null,"Forecast annual opex",2019,203.34354465156144,178.69138055671837,95.863267830710967,91.988291487900526,47.232287700960192,617.11877222785154,"Forecast annual opex2019"]
[null,null,null,"Loss of supply events",2006,2,2,5,4,16,29,"Loss of supply events2006"]
[null,null,null,"Loss of supply events",2007,2,5,2,1,10,20,"Loss of supply events2007"]
[null,null,null,"Loss of supply events",2008,2,2,1,4,6,15,"Loss of supply events2008"]
[null,null,null,"Loss of supply events",2009,2,3,6,4,8,23,"Loss of supply events2009"]
[null,null,null,"Loss of supply events",2010,0,3,1,12,9,25,"Loss of supply events2010"]
[null,null,null,"Loss of supply events",2011,4,3,0,7,11,25,"Loss of supply events2011"]
[null,null,null,"Loss of supply events",2012,1,3,2,7,10,23,"Loss of supply events2012"]
[null,null,null,"Loss of supply events",2013,0,3,5,5,10,23,"Loss of supply events2013"]
[null,null,null,"Loss of supply events",2014,3,4,1,4,4,16,"Loss of supply events2014"]
[null,null,null,"Loss of supply events",2015,1,4,2,1,3,11,"Loss of supply events2015"]
[null,null,null,"Loss of supply events",2016,0,2,3,5,1,11,"Loss of supply events2016"]
[null,null,null,"Loss of supply events",2017,3,1,0,4,4,12,"Loss of supply events2017"]
[null,null,null,"Loss of supply events",2018,1,1,0,3,2,7,"Loss of supply events2018"]
[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,{"$f":"D136&E136","v":"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,180.32,19.899999999999999,154.16999999999999,160.94120000000001,null,"Average outage duration2013"]
[null,null,null,"Average outage duration",2014,115.971,71.138000000000005,24,130.71,201,null,"Average outage duration2014"]
[null,null,null,"Average outage duration",2015,236.2286666,63.545000000000002,97.5,147,74,null,"Average outage duration2015"]
[null,null,null,"Average outage duration",2016,30.06,169.17750790715201,39.8333333333333,250.57,15,null,"Average outage duration2016"]
[null,null,null,"Average outage duration",2017,27.45,35.64,19,97,410,null,"Average outage duration2017"]
[null,null,null,"Average outage duration",2018,36.238181818181801,58.200000151991802,24.5,463,46,null,"Average outage duration2018"]
[null,null,null,"Market impact indicator",2006,3.7376331811263319E-2,2.5884703196347031E-2,1.1529680365296804E-2,0.27002473363774732,2.9490106544901064E-3,null,"Market impact indicator2006"]
[null,null,null,"Market impact indicator",2007,2.5275875190258753E-2,3.2581811263318113E-2,2.546613394216134E-2,0.10402397260273973,5.6668569254185695E-2,null,"Market impact indicator2007"]
[null,null,null,"Market impact indicator",2008,1.2480974124809741E-2,2.8139269406392695E-2,3.1421232876712328E-2,5.2777777777777778E-2,3.1963470319634705E-3,null,"Market impact indicator2008"]
[null,null,null,"Market impact indicator",2009,9.8744292237442927E-3,2.3982115677321156E-2,1.4421613394216133E-2,3.5378614916286147E-2,9.9124809741248099E-3,null,"Market impact indicator2009"]
[null,null,null,"Market impact indicator",2010,1.4830669710806698E-2,7.4200913242009128E-3,2.0918949771689496E-2,2.1489726027397259E-2,3.7775875190258754E-2,null,"Market impact indicator2010"]
[null,null,null,"Market impact indicator",2011,3.1773211567732115E-3,8.2952815829528161E-3,3.1601978691019786E-2,1.6856925418569254E-2,6.9349315068493152E-3,null,"Market impact indicator2011"]
[null,null,null,"Market impact indicator",2012,2.2355403348554032E-3,7.0110350076103504E-3,2.4809741248097414E-2,5.0656392694063926E-2,1.3375190258751902E-2,null,"Market impact indicator2012"]
[null,null,null,"Market impact indicator",2013,9.2275494672754946E-4,5.6411719939117198E-3,1.2813926940639269E-2,2.7844368340943684E-2,1.6999619482496196E-2,null,"Market impact indicator2013"]
[null,null,null,"Market impact indicator",2014,3.7490487062404869E-2,7.1299467275494676E-3,8.090753424657534E-3,2.1879756468797563E-3,1.1700913242009132E-2,null,"Market impact indicator2014"]
[null,null,null,"Market impact indicator",2015,6.278538812785388E-4,1.2642694063926941E-2,1.8060312024353119E-2,0.17256468797564689,2.349695585996956E-3,null,"Market impact indicator2015"]
[null,null,null,"Market impact indicator",2016,3.9954337899543381E-4,2.9071537290715373E-2,0.10300608828006089,0.1396689497716895,2.9214231354642312E-2,null,"Market impact indicator2016"]
[null,null,null,"Market impact indicator",2017,6.9444444444444447E-4,6.4778348554033485E-2,6.1596270928462711E-2,2.2146118721461189E-2,2.5703957382039573E-2,null,"Market impact indicator2017"]
[null,null,null,"Market impact indicator",2018,4.2427701674277018E-3,4.6965372907153732E-2,3.0251141552511416E-3,6.8683409436834097E-2,4.0525114155251139E-2,null,"Market impact indicator2018"]
[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,"Energy delivered (GWh)","2006",51045.96344425701,81538.366632759004,45186.299678676005,15241.186994052407,10530.108800000002,182631.49885557801,"Energy delivered (GWh)2006"]
[null,null,null,"Energy delivered (GWh)","2007",51964.465679886984,83028.257359986004,45956.437073730005,14809.02240557884,12828.493,186176.666821953,"Energy delivered (GWh)2007"]
[null,null,null,"Energy delivered (GWh)","2008",51187.327595034978,82531.571031917003,45046.718030759999,14506.431798357989,13500.337,187629.68349652903,"Energy delivered (GWh)2008"]
[null,null,null,"Energy delivered (GWh)","2009",52191.948260312034,81126.238029020999,47419.179046665005,14847.610973429968,13412.710999999999,187179.75041948701,"Energy delivered (GWh)2009"]
[null,null,null,"Energy delivered (GWh)","2010",52848.520626357022,80626.119478491994,48976.636241104999,15008.379403305271,13030.212,185093.70975965206,"Energy delivered (GWh)2010"]
[null,null,null,"Energy delivered (GWh)","2011",51917.071191967989,79831.334420277999,48047.970992500006,15262.885728180965,13108.442999999999,181765.99551489798,"Energy delivered (GWh)2011"]
[null,null,null,"Energy delivered (GWh)","2012",50878.576976755998,76646.150635604004,47529.361264941996,15068.932757169014,12589.843000000001,179217.08292348697,"Energy delivered (GWh)2012"]
[null,null,null,"Energy delivered (GWh)","2013",49333.938670689997,71147.668184577997,49056.428480179005,15061.136823993089,12866.188,174799.60999226093,"Energy delivered (GWh)2013"]
[null,null,null,"Energy delivered (GWh)","2014",47613.581421290997,67800,48503.771563634997,14707.393943953022,13359.963803999997,170562.854865181,"Energy delivered (GWh)2014"]
[null,null,null,"Energy delivered (GWh)","2015",53087.563425,74400,47967.077018124997,14485.733633013175,13109.624082295986,173326.24864551099,"Energy delivered (GWh)2015"]
[null,null,null,"Energy delivered (GWh)",2016,52872.387581990006,72200,47805.245822115998,15043.148933640963,11654.573903348006,177091.91910189003,"Energy delivered (GWh)2016"]
[null,null,null,"Energy delivered (GWh)",2017,54253.300021025992,75000,46829.301624718995,15106.161242227327,12426.663323709681,177372.37977258899,"Energy delivered (GWh)2017"]
[null,null,null,"Energy delivered (GWh)",2018,54849.858036833997,75700,42163.488406169992,14127.757580186377,12434.326120010006,178090.8344007734,"Energy delivered (GWh)2018"]
[null,null,null,"Energy delivered (GWh)",2019,53765.29422406599,74400,41479.994350973,13786.714687984706,12884.563992276986,177692.77521801769,"Energy delivered (GWh)2019"]
[null,null,null,"Circuit length","2006",11700.8,12517.231000000002,6573,5600.5389999999998,3581.3,39972.870000000003,"Circuit length2006"]
[null,null,null,"Circuit length","2007",11892.8,12526.494000000001,6573,5518.6689999999999,3622.3,40133.263000000006,"Circuit length2007"]
[null,null,null,"Circuit length","2008",12428.8,12523.514000000001,6573,5518.6689999999999,3622.3,40666.283000000003,"Circuit length2008"]
[null,null,null,"Circuit length","2009",12865.1,12523.349,6573,5503.6689999999999,3520.3,40985.418000000005,"Circuit length2009"]
[null,null,null,"Circuit length","2010",13321.1,12682.458999999999,6573,5501.6689999999999,3481.3,41559.528000000006,"Circuit length2010"]
[null,null,null,"Circuit length","2011",13738.4,12681.862999999999,6573,5504.6689999999999,3493.3,41991.232000000004,"Circuit length2011"]
[null,null,null,"Circuit length","2012",13702.4,12697.206999999999,6573,5526.0690000000004,3493.3,41991.976000000002,"Circuit length2012"]
[null,null,null,"Circuit length","2013",14313.5,12893.616999999998,6573,5527.3490000000002,3503.19,42810.656000000003,"Circuit length2013"]
[null,null,null,"Circuit length","2014",14772.5,12929.665999999999,6573,5529.4030540000003,3503.8,43308.369054000003,"Circuit length2014"]
[null,null,null,"Circuit length","2015",14754.5,13024.7646976,6573.2,5521.3490000000002,3563.7000000000003,43437.513697599999,"Circuit length2015"]
[null,null,null,"Circuit length",2016,14755.5,13039.195,6558.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.6689999999999,3545.2,43264.214219753245,"Circuit length2019"]
[null,null,null,"Circuit length - overhead","2006",11685,12469.323000000002,6562,5591.75,3568,39876.073000000004,{"$f":"D200&E200","v":"Circuit length - overhead2006"}]
[null,null,null,"Circuit length - overhead","2007",11877,12478.586000000001,6562,5509.88,3609,40036.466,"Circuit length - overhead2007"]
[null,null,null,"Circuit length - overhead","2008",12413,12475.606000000002,6562,5509.88,3609,40569.485999999997,"Circuit length - overhead2008"]
[null,null,null,"Circuit length - overhead","2009",12848,12475.441000000001,6562,5494.88,3507,40887.320999999996,"Circuit length - overhead2009"]
[null,null,null,"Circuit length - overhead","2010",13304,12634.550999999999,6562,5492.88,3468,41461.430999999997,"Circuit length - overhead2010"]
[null,null,null,"Circuit length - overhead","2011",13717,12633.955,6562,5495.88,3480,41888.834999999999,"Circuit length - overhead2011"]
[null,null,null,"Circuit length - overhead","2012",13681,12649.298999999999,6562,5498.88,3480,41871.178999999996,"Circuit length - overhead2012"]
[null,null,null,"Circuit length - overhead","2013",14292,12845.708999999999,6562,5500.16,3480,42679.869000000006,"Circuit length - overhead2013"]
[null,null,null,"Circuit length - overhead","2014",14751,12878.228999999999,6562,5502.214054,3480,43173.443054000003,"Circuit length - overhead2014"]
[null,null,null,"Circuit length - overhead","2015",14733,12942.540697599999,6562,5494.16,3539.9,43271.600697599999,"Circuit length - overhead2015"]
[null,null,null,"Circuit length - overhead",2016,14734,12956.955,6547.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.47,3521.3999999999996,43099.067219753248,"Circuit length - overhead2019"]
[null,null,null,"Circuit length - underground","2006",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2006"]
[null,null,null,"Circuit length - underground","2007",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2007"]
[null,null,null,"Circuit length - underground","2008",15.8,47.908000000000001,11,8.7889999999999997,13.3,96.796999999999997,"Circuit length - underground2008"]
[null,null,null,"Circuit length - underground","2009",17.100000000000001,47.908000000000001,11,8.7889999999999997,13.3,98.097000000000008,"Circuit length - underground2009"]
[null,null,null,"Circuit length - underground","2010",17.100000000000001,47.908000000000001,11,8.7889999999999997,13.3,98.097000000000008,"Circuit length - underground2010"]
[null,null,null,"Circuit length - underground","2011",21.4,47.908000000000001,11,8.7889999999999997,13.3,102.39699999999999,"Circuit length - underground2011"]
[null,null,null,"Circuit length - underground","2012",21.4,47.908000000000001,11,27.189,13.3,120.79699999999998,"Circuit length - underground2012"]
[null,null,null,"Circuit length - underground","2013",21.5,47.908000000000001,11,27.189,23.19,130.78700000000001,"Circuit length - underground2013"]
[null,null,null,"Circuit length - underground","2014",21.500000000000004,51.437000000000005,11,27.189,23.8,134.92600000000002,"Circuit length - underground2014"]
[null,null,null,"Circuit length - underground","2015",21.500000000000004,82.22399999999999,11.2,27.189,23.8,165.91300000000001,"Circuit length - underground2015"]
[null,null,null,"Circuit length - underground",2016,21.500000000000004,82.24,11.2,27.189,23.8,165.929,"Circuit length - underground2016"]
[null,null,null,"Circuit length - underground",2017,21.500000000000004,81.581000000000003,8.5423703333333396,27.199000000000002,23.8,162.62237033333335,"Circuit length - underground2017"]
[null,null,null,"Circuit length - underground",2018,21.500000000000004,81.64,8.5399999999999991,27.199000000000002,23.8,162.67900000000003,"Circuit length - underground2018"]
[null,null,null,"Circuit length - underground",2019,20.200000000000003,85.408000000000001,8.5399999999999991,27.199000000000002,23.8,165.14700000000002,"Circuit length - underground2019"]

{"sheet":"Calculations","index":1,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Calculations"]
[]
[null,null,null,"Summary statistics"]
[]
[null,null,null,"Match",{"$f":"Dashboard!F3","v":"Powerlink"}]
[]
[null,null,null,null,"2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,"2018","2019","2020","2021","2022"]
[null,null,null,"Actual revenue",{"$f":"INDEX('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":524.43109000144091},{"$f":"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":556.81118232983226},{"$f":"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":602.32788722541363},{"$f":"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":627.96699530738965},{"$f":"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":707.35852778910271},{"$f":"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":804.47573327091129},{"$f":"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":890.03687921150242},{"$f":"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":879.96579623707089},{"$f":"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":904.01442974213751},{"$f":"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":884.11022807428935},{"$f":"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":989.87155633956502},{"$f":"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":1104.8789738732394},{"$f":"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":733.02707159824888},{"$f":"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":676.40572543279154},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Actual closing RAB",{"$f":"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":4077.6155941802708},{"$f":"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":4967.1106419925763},{"$f":"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":5647.7787127380516},{"$f":"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":6215.6072014084457},{"$f":"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":6539.1693452536529},{"$f":"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":6807.0853796527899},{"$f":"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":7375.9608582949795},{"$f":"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":7665.0058667139956},{"$f":"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":7774.2271447588764},{"$f":"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":7676.1389520505281},{"$f":"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":7532.0974080649585},{"$f":"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":7332.9072273140655},{"$f":"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":7240.6760998105319},{"$f":"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":7129.226180824674},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Forecast closing RAB",{"$f":"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":4065.1239096922081},{"$f":"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":4000.9141389623915},{"$f":"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":5726.4434099391283},{"$f":"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":6372.0035634484138},{"$f":"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":6709.8732698010836},{"$f":"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":7093.8991275224989},{"$f":"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":7373.5411703545069},{"$f":"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":7935.3327279826763},{"$f":"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":8329.1690300001355},{"$f":"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":8501.0718265244213},{"$f":"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":8704.3131537107147},{"$f":"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":8963.7503786162906},{"$f":"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":7240.6760998105319},{"$f":"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":7129.226180824674},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Actual annual capex",{"$f":"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":367.80804317063115},{"$f":"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":329.27439532679745},{"$f":"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":859.35005486491582},{"$f":"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":778.79102461828234},{"$f":"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":542.33474408578684},{"$f":"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":502.11468482390939},{"$f":"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":729.40779383510721},{"$f":"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":507.09149703568022},{"$f":"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":348.91345324570295},{"$f":"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":172.29422034264124},{"$f":"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":141.16642992726759},{"$f":"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":180.07103453201665},{"$f":"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":153.53567846646644},{"$f":"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":169.2739498492343},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Forecast annual capex",{"$f":"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":276.10225215048547},{"$f":"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":123.65914781569455},{"$f":"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":937.04117602876761},{"$f":"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":854.79236093077623},{"$f":"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":566.50291884119383},{"$f":"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":625.40600553350316},{"$f":"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":532.89821862900419},{"$f":"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":770.54571488788827},{"$f":"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":636.24024500564326},{"$f":"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":453.11826242004912},{"$f":"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":503.78795661154589},{"$f":"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":570.43418027013945},{"$f":"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":170.59984907858166},{"$f":"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":171.29194563686369},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Actual annual opex",{"$f":"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":163.42793082415326},{"$f":"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":171.82196609602371},{"$f":"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":186.82032622371156},{"$f":"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":179.1139079232577},{"$f":"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":185.56844521958695},{"$f":"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":178.9362035828257},{"$f":"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":185.46618614775318},{"$f":"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":189.67925820886157},{"$f":"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":199.71514054510263},{"$f":"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":228.22784190763559},{"$f":"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":232.07940409586752},{"$f":"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":237.17584476748249},{"$f":"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":192.77569642030207},{"$f":"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":201.13756149662501},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Forecast annual opex",{"$f":"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":124.82817837769656},{"$f":"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":124.8330253953331},{"$f":"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":185.1979042319067},{"$f":"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":186.01928183913441},{"$f":"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":199.90000979069188},{"$f":"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":191.11477090242514},{"$f":"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":196.83947640999659},{"$f":"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":203.33189753870056},{"$f":"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":211.0655470428147},{"$f":"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":216.43716901507824},{"$f":"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":224.54161135508247},{"$f":"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":231.05059528203205},{"$f":"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":204.23329429976584},{"$f":"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":203.34354465156144},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Loss of supply events",{"$f":"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":2},{"$f":"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":2},{"$f":"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":2},{"$f":"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":2},{"$f":"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":0},{"$f":"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":4},{"$f":"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":1},{"$f":"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":0},{"$f":"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":3},{"$f":"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":1},{"$f":"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":0},{"$f":"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":3},{"$f":"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":1},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Average outage duration",{"$f":"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":39.034769685990298},{"$f":"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":1249.94338791423},{"$f":"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":35.289638071895403},{"$f":"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":62.276197516025597},{"$f":"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":16.620001587301601},{"$f":"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":86.769421575429206},{"$f":"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":26.086666666666702},{"$f":"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":5.6214285714285701},{"$f":"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":115.971},{"$f":"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":236.2286666},{"$f":"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":30.06},{"$f":"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":27.45},{"$f":"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":36.238181818181801},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Market impact indicator",{"$f":"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":3.7376331811263319E-2},{"$f":"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":2.5275875190258753E-2},{"$f":"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":1.2480974124809741E-2},{"$f":"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":9.8744292237442927E-3},{"$f":"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":1.4830669710806698E-2},{"$f":"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":3.1773211567732115E-3},{"$f":"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":2.2355403348554032E-3},{"$f":"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":9.2275494672754946E-4},{"$f":"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":3.7490487062404869E-2},{"$f":"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":6.278538812785388E-4},{"$f":"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":3.9954337899543381E-4},{"$f":"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":6.9444444444444447E-4},{"$f":"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":4.2427701674277018E-3},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Maximum demand (MW)",{"$f":"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":7336.8405000000002},{"$f":"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":7758.2674399999996},{"$f":"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":7281.0681000000004},{"$f":"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":7848.6144160000003},{"$f":"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":8002.824568},{"$f":"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":7797.4507640000002},{"$f":"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":7740.0070679999999},{"$f":"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":7681.4389380000002},{"$f":"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":7637.8836000000001},{"$f":"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":8105.0587999999998},{"$f":"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":8272.1218719999997},{"$f":"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":8547.9858320000003},{"$f":"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":8788.5806080000002},{"$f":"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":8968.9724920000008},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Energy delivered (GWh)",{"$f":"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":51045.96344425701},{"$f":"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":51964.465679886984},{"$f":"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":51187.327595034978},{"$f":"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":52191.948260312034},{"$f":"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":52848.520626357022},{"$f":"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":51917.071191967989},{"$f":"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":50878.576976755998},{"$f":"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":49333.938670689997},{"$f":"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":47613.581421290997},{"$f":"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":53087.563425},{"$f":"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":52872.387581990006},{"$f":"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":54253.300021025992},{"$f":"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":54849.858036833997},{"$f":"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":53765.29422406599},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Circuit length",{"$f":"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":11700.8},{"$f":"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":11892.8},{"$f":"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":12428.8},{"$f":"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":12865.1},{"$f":"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":13321.1},{"$f":"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":13738.4},{"$f":"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":13702.4},{"$f":"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":14313.5},{"$f":"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":14772.5},{"$f":"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":14754.5},{"$f":"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":14755.5},{"$f":"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":14532.5},{"$f":"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":14527.5},{"$f":"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":14526.2},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Circuit length - overhead",{"$f":"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":11685},{"$f":"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":11877},{"$f":"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":12413},{"$f":"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":12848},{"$f":"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":13304},{"$f":"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":13717},{"$f":"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":13681},{"$f":"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":14292},{"$f":"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":14751},{"$f":"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":14733},{"$f":"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":14734},{"$f":"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":14511},{"$f":"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":14506},{"$f":"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":14506},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}}]
[null,null,null,"Circuit length - underground",{"$f":"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":15.8},{"$f":"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":15.8},{"$f":"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":15.8},{"$f":"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":17.100000000000001},{"$f":"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":17.100000000000001},{"$f":"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":21.4},{"$f":"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":21.4},{"$f":"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":21.5},{"$f":"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":21.500000000000004},{"$f":"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":21.500000000000004},{"$f":"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":21.500000000000004},{"$f":"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":21.500000000000004},{"$f":"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":21.500000000000004},{"$f":"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":20.200000000000003},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$error":"#N/A"}},{"$f":"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":{"$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, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!D84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D92, \"#N/A\"))))))","v":480.35409232833439},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!E84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E92, \"#N/A\"))))))","v":231.50018881067089},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!F84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F92, \"#N/A\"))))))","v":311.78764830706154},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!G84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G92, \"#N/A\"))))))","v":215.73076777550867},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!H84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H92, \"#N/A\"))))))","v":203.59854708800179},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!I84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I92, \"#N/A\"))))))","v":280.07372755289737},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!J84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J92, \"#N/A\"))))))","v":10.37674438138632},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!K84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K92, \"#N/A\"))))))","v":12.398049977596029},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!L84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L92, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!M84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M92, \"#N/A\"))))))","v":2.2406696856238932},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!N84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N92, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!O84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O92, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!P84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P92, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q41, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q57, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q65, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q73, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!Q84, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q92, \"#N/A\"))))))","v":0}]
[null,null,null,"overheads",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!D85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D93, \"#N/A\"))))))","v":36.311193289918258},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!E85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E93, \"#N/A\"))))))","v":29.193701250157517},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!F85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F93, \"#N/A\"))))))","v":26.763381171980559},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!G85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G93, \"#N/A\"))))))","v":25.974459314447714},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!H85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H93, \"#N/A\"))))))","v":25.403608965210882},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!I85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I93, \"#N/A\"))))))","v":21.081268641460667},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!J85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J93, \"#N/A\"))))))","v":13.456020286229581},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!K85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K93, \"#N/A\"))))))","v":7.5231967263928885},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!L85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L93, \"#N/A\"))))))","v":12.497956301580075},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!M85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M93, \"#N/A\"))))))","v":8.5825602819581377},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!N85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N93, \"#N/A\"))))))","v":12.446182045524093},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!O85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O93, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!P85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P93, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q42, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q58, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q66, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q74, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!Q85, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q93, \"#N/A\"))))))","v":0}]
[null,null,null,"connections",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!D86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D94, \"#N/A\"))))))","v":18.836580167169625},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!E86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E94, \"#N/A\"))))))","v":4.6990466069053918},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!F86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F94, \"#N/A\"))))))","v":4.8291401305146122},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!G86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G94, \"#N/A\"))))))","v":6.5373336119552095},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!H86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H94, \"#N/A\"))))))","v":3.1932476137135914},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!I86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I94, \"#N/A\"))))))","v":5.4502342114756237},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!J86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J94, \"#N/A\"))))))","v":1.4857093640605223},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!K86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!L86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!M86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!N86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!O86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!P86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P94, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q43, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q59, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q67, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q75, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!Q86, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q94, \"#N/A\"))))))","v":0}]
[null,null,null,"non-network",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!D87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D95, \"#N/A\"))))))","v":30.693957211615682},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!E87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E95, \"#N/A\"))))))","v":39.020338942359082},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!F87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F95, \"#N/A\"))))))","v":39.143606008787735},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!G87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G95, \"#N/A\"))))))","v":33.196093612416348},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!H87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H95, \"#N/A\"))))))","v":36.059240769467635},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!I87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I95, \"#N/A\"))))))","v":14.02852815084721},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!J87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J95, \"#N/A\"))))))","v":8.1798974048569804},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!K87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K95, \"#N/A\"))))))","v":13.704399984110561},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!L87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L95, \"#N/A\"))))))","v":18.138920366431098},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!M87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M95, \"#N/A\"))))))","v":35.672275348275448},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!N87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N95, \"#N/A\"))))))","v":21.782784549389572},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!O87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O95, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!P87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P95, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q44, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q60, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q68, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q76, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!Q87, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q95, \"#N/A\"))))))","v":0}]
[null,null,null,"replacement expenditure",{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!D45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!D61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!D69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!D77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!D88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!D96, \"#N/A\"))))))","v":196.58734075824336},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!E45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!E61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!E69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!E77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!E88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!E96, \"#N/A\"))))))","v":161.30248822009983},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!F45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!F61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!F69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!F77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!F88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!F96, \"#N/A\"))))))","v":83.482655100060029},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!G45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!G61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!G69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!G77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!G88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!G96, \"#N/A\"))))))","v":209.61576764195925},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!H45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!H61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!H69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!H77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!H88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!H96, \"#N/A\"))))))","v":242.12345839819733},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!I45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!I61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!I69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!I77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!I88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!I96, \"#N/A\"))))))","v":264.83448506499195},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!J45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!J61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!J69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!J77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!J88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!J96, \"#N/A\"))))))","v":154.82445038462436},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!K45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!K61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!K69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!K77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!K88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!K96, \"#N/A\"))))))","v":53.794853295176374},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!L45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!L61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!L69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!L77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!L88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!L96, \"#N/A\"))))))","v":119.96361339154903},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!M45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!M61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!M69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!M77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!M88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!M96, \"#N/A\"))))))","v":64.371477537877468},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!N45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!N61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!N69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!N77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!N88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!N96, \"#N/A\"))))))","v":128.24244369164359},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!O45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!O61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!O69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!O77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!O88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!O96, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!P45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!P61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!P69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!P77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!P88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!P96, \"#N/A\"))))))","v":0},{"$f":"IF($E$7=\"Transmission total\", '4. Capex by Driver'!Q45, IF($E$7=\"Powerlink\",'4. Capex by Driver'!Q61, IF($E$7=\"Transgrid\",'4. Capex by Driver'!Q69, IF($E$7=\"AusNet (T)\",'4. Capex by Driver'!Q77, IF($E$7='4. Capex by Driver'!$B$82,'4. Capex by Driver'!Q88, IF($E$7='4. Capex by Driver'!$B$90,'4. Capex by Driver'!Q96, \"#N/A\"))))))","v":0}]

{"sheet":"Introduction","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"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, service and network operational performance measures.  "]
[null,null,"Interpretation"]
[null,null,"The data covers the regulatory years from 2006 to 2019. 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 service performance scheme (STPIS) reporting timeframes.\n\nAll financial values have been converted to June 2019 dollars (or March 2019 dollars for AusNet (T))."]
[]
[]
[null,null,"Sources"]
[null,null,"Data is classified as actual or forecast. \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 annual 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,4,"June 2020",null,"Financial years",null,"2005-06 to 2018-19"]
[null,null,3,"Jul 2019",null,"Financial years",null,"2005-06 to 2017-18"]
[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":"Dashboard","index":3,"n_rows":125,"n_cols":17,"rows_kept":125,"cut":false,"hidden":false,"merged":[[2,5,2,9],[0,5,0,9],[1,4,1,10]]}
[null,null,null,null,null,"Electricity Transmission Network Service Provider"]
[null,null,null,null,"Operational Performance Data"]
[null,null,null,null,null,"Powerlink"]
[]
[]
[null,null,null,null,null,null,"Summary statistics"]
[]
[]
[null,null,null,null,null,null,null,"2019 value","5 year trend"]
[null,null,null,null,null,null,"Actual revenue",{"$f":"\"$\"&TEXT(Calculations!R10,\"#,##0\")&\"m\"","v":"$676m"}]
[null,null,null,null,null,null,"Actual closing RAB",{"$f":"\"$\"&TEXT(Calculations!R11,\"#,##0\")&\"m\"","v":"$7,129m"}]
[null,null,null,null,null,null,"Forecast closing RAB",{"$f":"\"$\"&TEXT(Calculations!R12,\"#,##0\")&\"m\"","v":"$7,129m"}]
[null,null,null,null,null,null,"Actual annual capex",{"$f":"\"$\"&TEXT(Calculations!R13,\"#,##0\")&\"m\"","v":"$169m"}]
[null,null,null,null,null,null,"Forecast annual capex",{"$f":"\"$\"&TEXT(Calculations!R14,\"#,##0\")&\"m\"","v":"$171m"}]
[null,null,null,null,null,null,"Actual annual opex",{"$f":"\"$\"&TEXT(Calculations!R15,\"#,##0\")&\"m\"","v":"$201m"}]
[null,null,null,null,null,null,"Forecast annual opex",{"$f":"\"$\"&TEXT(Calculations!R16,\"#,##0\")&\"m\"","v":"$203m"}]
[null,null,null,null,null,null,"Loss of supply events*",{"$f":"TEXT(Calculations!Q17,\"0\")&\" events\"","v":"1 events"}]
[null,null,null,null,null,null,"Average outage duration*",{"$f":"IF(Calculations!P18>0,TEXT(Calculations!Q18,\"0\")&\" minutes\",\"not available\")","v":"36 minutes"}]
[null,null,null,null,null,null,"Market impact indicator*",{"$f":"IF(Calculations!P19>0,TEXT(Calculations!Q19,\"0\")&\" minutes\",\"not available\")","v":"0 minutes"}]
[null,null,null,null,null,null,"Maximum demand",{"$f":"IF(Calculations!R20>0,(TEXT(Calculations!R20,\"000\")&\"MW\"),\"not available\")","v":"8969MW"}]
[null,null,null,null,null,null,"Energy delivered",{"$f":"TEXT(Calculations!R21,\"0,00\")&\"GWh\"","v":"53,765GWh"}]
[null,null,null,null,null,null,"Circuit length - total",{"$f":"TEXT(Calculations!R22,\"0,00\")&\"km\"","v":"14,526km"}]
[null,null,null,null,null,null,"Circuit length - overhead",{"$f":"TEXT(Calculations!R23,\"0,00\")&\"km\"","v":"14,506km"}]
[null,null,null,null,null,null,"Circuit length - underground",{"$f":"TEXT(Calculations!R24,\"0,0\")&\"km\"","v":"20km"}]
[null,null,null,null,null,null,null,"* Using 2018 data because 2019 data is not yet reported"]
[]
[]
[]
[]
[null,null,"Financials"]
[]
[null,null,"Annual revenue",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,"Reliability - outage duration",null,null,null,null,null,null,null,null,"Market impact"]
[null,null,{"$f":"IFERROR(Calculations!R17,\"No Data for 2019\")","v":"No Data for 2019"},null,null,null,null,{"$f":"IFERROR(Calculations!R18,\"No Data for 2019\")","v":"No Data for 2019"},null,null,null,null,null,null,null,null,{"$f":"IF($F$3=\"Transmission total\",\"No data for Transmission total - Market Impact\",IFERROR(Calculations!R19,\"No Data for 2019\"))","v":"No Data for 2019"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Network Descriptors"]
[]
[]
[null,null,"Energy delivered",null,null,null,null,"Circuit Length",null,null,null,null,null,null,null,null,"Maximum demand"]
[null,null,{"$f":"IF(F3=\"Transmission total\", \"No data for Transmission total - Maximum demand\", \"\")","v":""}]

{"sheet":"Contents","index":4,"n_rows":24,"n_cols":8,"rows_kept":24,"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],[22,2,22,5],[20,2,20,6],[19,2,19,6],[18,2,18,7],[17,2,17,7]]}
[]
[]
[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 events"]
[null,null,"7. Reliability - outage duration"]
[null,null,"8. Market impact"]
[null,null,"9. Maximum demand"]
[null,null,"10. Energy delivered"]
[null,null,"11. Circuit length"]
[null,null,"12. Return on assets"]

{"sheet":"1. Revenue","index":5,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,1,58,16],[3,1,3,13],[29,1,29,13],[43,1,43,13],[31,1,31,16],[56,1,56,13]]}
[]
[]
[]
[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 budgeted (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 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",524.43109000144091,556.81118232983226,602.32788722541363,627.96699530738965,707.35852778910271,804.47573327091129,890.03687921150242,879.96579623707089,904.01442974213751,884.11022807428935,989.87155633956502,1104.8789738732394,733.02707159824888,676.40572543279154]
[null,"Transgrid","NSW",442.14759870463524,428.86815563942804,441.2820921956548,542.36931513484524,660.52056994090231,746.67637495176916,768.82805140067501,804.71735403020557,753.59312302858166,765.25181357632675,750.91655054869432,652.09037120454684,605.55021007937171,535.95811870029775]
[null,"AEMO/AusNet (T)","VIC",457.00205241091709,501.49371289907765,500.31700796202415,475.16290245616239,568.5377749859241,562.68052564723223,581.58589640676746,645.21027628487082,551.56395833954866,599.88185354879454,601.12793989034321,561.56730472584013,535.93765571707297,517.10082269381087]
[null,"ElectraNet","SA",204.68199901278001,225.03862439427624,231.93793453347348,259.59490428746028,251.12987072423661,290.49637116951084,335.647041210711,347.49686249516668,299.23732185142592,310.74511288888806,298.03757974862862,278.80069736094504,267.5365678444428,264.20322841041957]
[null,"TasNetworks (T)","TAS",161.53776893958144,138.96735974822522,151.80866929448166,163.33800535491272,192.09981097052099,229.02615261128855,240.36836748681193,237.85154827939371,233.28809656587211,200.33114626018542,183.63784501332125,168.95699275009838,165.57769276725432,154.18620981462078]
[null,"Total",null,{"$f":"SUM(D36:D40)","v":1789.8005090693546},{"$f":"SUM(E36:E40)","v":1851.1790350108395},1927.6735912110478,2068.4321225407703,2379.6465544106868,2633.355157650712,2816.466235716468,2915.2418373267078,2741.6969295275653,2760.3201543484838,2823.591471540552,2766.2943399146698,2307.6291980063907,{"$f":"SUM(Q36:Q40)","v":2147.8541050519407}]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RINs, 2006-2019"]
[]
[]
[null,"Budgeted revenue from customers"]
[null,"$m 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",null,null,null,null,null,null,null,null,null,895.98242870828949,1014.7983430838242,1113.358619391272,740.65189077252194,679.19949110129369]
[null,"Transgrid","NSW",null,null,null,null,null,null,null,null,null,857.99833457930742,845.34929451281835,760.46765115874348,696.70283112427694,556.38887047243134]
[null,"AEMO/AusNet (T)","VIC",null,null,null,null,null,null,null,null,null,602.01967912183704,601.29129505271112,573.61710463009774,540.13499629836394,518.58862583476673]
[null,"ElectraNet","SA",null,null,null,null,null,null,null,null,null,317.38571973786463,304.60319873273079,285.91724231919039,274.30441370664704,271.01227976915118]
[null,"TasNetworks (T)","TAS",null,null,null,null,null,null,null,null,null,179.46269305974164,162.7697037213145,160.78354524719884,152.3900087977708,153.59976289934951]
[null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M53)","v":2852.8488552070403},2928.8118351033991,2894.1441627465028,2404.1841406995809,2178.7890300769923]
[]
[null,"Sources:"]
[null,"Information requests: all TNSPs, 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":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,1,3,13],[29,1,29,13],[61,1,61,16],[60,1,60,16],[59,1,59,16],[56,1,56,16],[57,1,57,16],[43,1,44,16],[31,1,31,16]]}
[]
[]
[]
[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 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",4077.6155941802708,4967.1106419925763,5647.7787127380516,6215.6072014084457,6539.1693452536529,6807.0853796527899,7375.9608582949795,7665.0058667139956,7774.2271447588764,7676.1389520505281,7532.0974080649585,7332.9072273140655,7240.6760998105319,7129.226180824674]
[null,"Transgrid","NSW",4382.8156532652474,4502.6068780095338,4748.31650013327,5232.2473337201473,5521.078986059887,5748.045079389989,5943.9744839792884,6283.6633964639923,6615.0065851683476,6626.1583021376091,6615.4004420407382,6520.2711375004037,6484.8956325952631,6452.0147322060511]
[null,"AusNet (T)*","VIC",2597.9195075331359,2586.4595482835903,2813.8886550890547,2799.3403095357771,2801.6789459329043,2795.1410928650225,2810.2285754498539,2864.2906541459452,3138.7589949372295,3144.8486777452649,3137.0404054566693,3289.0701459220222,3304.1125910051123,3294.7648209887006]
[null,"ElectraNet","SA",1395.6065967427792,1433.1533934187105,1665.4900205966555,1723.0703638196749,1798.6385733152979,2009.0394103068379,2141.1525663708012,2316.2740624574762,2379.0076886933093,2406.3269328916058,2475.9403029349505,2529.2007128752989,2605.832373403246,2616.2271963527569]
[null,"TasNetworks (T)","TAS",1000.7623588190914,1075.1977084808755,1081.1309259386906,1180.3653254325675,1288.2835441154996,1366.0436611756986,1459.450897390441,1496.1005829688888,1535.4507305054631,1506.252048013956,1472.8344548920275,1463.4934160615776,1455.6014877803323,1454.7350984387058]
[null," Total",null,{"$f":"SUM(D36:D40)","v":13454.719710540523},{"$f":"SUM(E36:E40)","v":14564.528170185285},15956.604814495722,17150.630533916614,17948.849394677243,18725.35462339034,19730.767381485362,20625.334562750297,21442.451144063227,21359.724912838967,21233.313013389343,{"$f":"SUM(O36:O40)","v":21134.942639673369},{"$f":"SUM(P36:P40)","v":21091.118184594485},{"$f":"SUM(Q36:Q40)","v":20946.968028810887}]
[]
[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 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,"2018","2019"]
[null,"Powerlink","QLD",4065.1239096922081,4000.9141389623915,5726.4434099391283,6372.0035634484138,6709.8732698010836,7093.8991275224989,7373.5411703545069,7935.3327279826763,8329.1690300001355,8501.0718265244213,8704.3131537107147,8963.7503786162906,7240.6760998105319,7129.226180824674]
[null,"Transgrid","NSW",4484.9366126143777,4637.3582002310759,4972.9270490320268,5210.1065451388449,5698.2997508456847,6052.5314561935629,6545.2049399087091,6959.6216164539501,7189.6295305514323,6637.3881376912841,6700.688213992541,6673.1774171185989,6647.2190069367871,6452.0147322060511]
[null,"AusNet (T)*","VIC",2708.7508741907263,2694.9210764132981,2678.6726456332813,2831.9486551722675,2835.771262283753,2861.5559661806783,2892.184045527034,2896.0018199786796,2944.5295454001398,3151.9234504088658,3195.422086351653,3233.1755228816728,3304.1125910051123,3294.7648209887006]
[null,"ElectraNet","SA",1446.4677446746014,1466.1221921659007,1437.9441427347106,1769.7539237964174,1935.7783073460193,2160.0095391278542,2311.9462024215027,2330.4927344687508,2470.3869352067004,2549.2714534844968,2651.5183799790893,2684.9201955436588,2642.9410357876372,2616.2271963527569]
[null,"TasNetworks (T)","TAS",998.87856796261929,1073.6454435899132,1079.7101489174199,1075.7240037661588,1324.2866066658758,1461.5547481098256,1520.5487695637134,1579.7679315982082,1634.2101318188768,1535.3447819187331,1547.3880774510374,1543.2334722935757,1530.7505183186668,1506.359756485667]
[null," Total",null,{"$f":"SUM(D50:D54)","v":13704.157709134533},{"$f":"SUM(E50:E54)","v":13872.961051362581},15895.697396256568,17259.536691322101,18504.009196942417,19629.550837134419,20643.425127775467,21701.216830482266,22567.925172977284,22374.999650027799,22799.329911485034,{"$f":"SUM(O50:O54)","v":23098.256986453795},{"$f":"SUM(P50:P54)","v":21365.699251858732},{"$f":"SUM(Q50:Q54)","v":20998.59268685785}]
[]
[null,"Sources:"]
[null,"Forecast closing RAB is sourced from post tax revenue models determined as part of final regulatory decisions, as made by the AER or jurisdictional regulators, and as adjusted by the Australian Competition Tribunal. Updates to the model are also taken into account."]
[]
[null,"Notes:"]
[null,"AusNet (T) - differences between actual and forecast closing RAB arise due to the treatment of augmentation capital works (Group 3 assets). These assets are included in Actual RAB data, but are not included in forecasts. The AER's Final decision on AusNet (T)'s RAB explains the issue and advises*:"]
[null,"During a regulatory control period, AEMO or a distribution business may request AusNet Services to provide augmentations to the transmission network or distribution connection services. While the assets constructed due to these requests provide prescribed transmission services, the forecast capex associated with these assets sit outside of the revenue determination. This is because AusNet Services is not responsible for the planning of these capex. AusNet Services and AEMO refer to the assets that provide these services as ‘Group 3’ assets. Group 3 assets sit outside of the RAB and are governed by commercial contracts until such time as they are rolled into the RAB, usually at the next revenue reset. \n\n* AER, Final decision: AusNet Services transmission determination 2017–22, Attachment 2 – Regulatory asset base, p 2-6. "]

{"sheet":"3. Capex","index":7,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,1,3,13],[29,1,29,13],[57,1,57,16],[43,1,45,16],[31,1,31,16]]}
[]
[]
[]
[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 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",367.80804317063115,329.27439532679745,859.35005486491582,778.79102461828234,542.33474408578684,502.11468482390939,729.40779383510721,507.09149703568022,348.91345324570295,172.29422034264124,141.16642992726759,180.07103453201665,153.53567846646644,169.2739498492343]
[null,"Transgrid","NSW",213.68845147863053,290.46963351092973,415.59418299142607,714.36543222852436,494.89639578832578,429.58778086593577,405.77001678553955,548.75887437067161,528.56422555161953,272.28403813363633,262.45494184084839,193.04821739355646,233.73977619890542,211.09760648761701]
[null,"AusNet (T)","VIC",141.05487636022383,144.06267018574292,142.04474231991779,115.06586563336604,134.65991084173612,130.23573556501825,152.8173179485037,195.18364946430336,160.56510776429943,165.25267797648971,148.67379486577693,183.1132335725527,137.481099198838,145.82415563375707]
[null,"ElectraNet","SA",93.749083120668189,108.00064109790542,217.55004187112186,121.09570236241365,142.41197164833386,275.30536764265872,200.95528891225734,253.89100204590468,145.08303162716064,122.65767786327483,177.3531515341142,157.52863752187866,179.52322921628581,155.25545173865422]
[null,"TasNetworks (T)","TAS",97.187318103945827,135.39778472731695,80.70957586329817,84.045242503002441,162.16383137392475,136.98420851424882,145.26770172539977,96.558708763728205,85.024017450477928,27.291827978446722,26.298057671657247,53.267818971821988,53.629377460799475,60.824767060410309]
[null," Total",null,{"$f":"SUM(D36:D40)","v":913.48777223409945},{"$f":"SUM(E36:E40)","v":1007.2051248486925},1715.2485979106798,1813.3632673455886,1476.4668537381074,1474.2277774117711,1634.2181192068076,1601.4837316802882,1268.1498356392603,759.78044229448881,755.94637583966437,{"$f":"SUM(O36:O40)","v":767.0289419918264},{"$f":"SUM(P36:P40)","v":757.90916054129514},{"$f":"SUM(Q36:Q40)","v":742.27593076967287}]
[]
[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 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",276.10225215048547,123.65914781569455,937.04117602876761,854.79236093077623,566.50291884119383,625.40600553350316,532.89821862900419,770.54571488788827,636.24024500564326,453.11826242004912,503.78795661154589,570.43418027013945,170.59984907858166,171.29194563686369]
[null,"Transgrid","NSW",259.38705111002002,312.72216226206621,494.04889873520096,413.679337094262,666.81314016295721,568.36532332145248,698.80771260963195,642.25448837178669,482.72470753710542,277.94141578885512,331.63646861335616,256.21282834138896,239.28798358573115,221.06413399695066]
[null,"AusNet (T)","VIC",76.768698813971881,104.09151475531688,105.41425921735924,149.58697448755547,143.18963549020822,169.45119538309584,179.00651005792082,157.03673229081551,191.91535567637391,164.32107108514978,198.36811605073859,197.32027422919668,187.22997452265381,163.4945299049007]
[null,"ElectraNet","SA",118.42723171258032,103.33381618110185,68.490217181994581,164.93591486317843,225.98798349949428,288.71000717394423,222.83050580613812,99.106367173756695,234.5944317454109,169.93535160557482,206.21610887806702,148.01448481386407,75.595490711522245,115.122484340315]
[null,"TasNetworks (T)","TAS",71.858254714313617,118.60346596655143,56.018531900943408,46.74649903458036,197.15178705223821,194.89636477229269,116.35754024703543,122.3281946990413,122.03866493462019,55.125585569254802,70.180241119780675,57.450204978184928,48.481474658438735,37.029638114413977]
[null,"Total",null,{"$f":"SUM(D50:D54)","v":802.54348850137137},{"$f":"SUM(E50:E54)","v":762.41010698073092},1661.0130830642656,1629.7410864103524,1799.6454650460919,1846.8288961842884,1749.9004873497304,1791.2714974232886,1667.5134048991536,1120.4416864688835,1310.1888912734883,{"$f":"SUM(O50:O54)","v":1229.4319726327742},{"$f":"SUM(P50:P54)","v":721.19477255692766},{"$f":"SUM(Q50:Q54)","v":708.00273199344406}]
[]
[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."]

{"sheet":"4. Capex by Driver","index":8,"n_rows":96,"n_cols":18,"rows_kept":96,"cut":false,"hidden":false,"merged":[[51,12,52,13],[48,1,48,13],[36,1,36,13],[3,1,3,13]]}
[]
[]
[]
[null,"Capital expenditure by driver"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Transmission businesses are required to report their capital expenditure (capex) 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 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure*",1104.1277593495913,684.91227616316405,764.39098402051388,554.01318337452381,597.77248357548183,567.89827198093155,51.127492851087787,119.04635159965189,26.450844438431968,32.752047072505384,58.780914978567921]
[null,null,"overheads",90.691993456708033,103.50348206340215,94.289291707754529,99.576704440463701,103.91134651603232,87.415276673155333,77.372498448426768,71.923080642659016,80.557099963955949,77.567664127527806,70.311116628292254]
[null,null,"connections",43.890783804516388,64.617468650067735,69.985184999298454,54.833509901646536,36.502325285735793,87.62039386711443,58.163892423130683,80.266261377478159,41.788064290527558,20.00889097353242,25.298524956947254]
[null,null,"non-network",105.2659225170172,98.138509670867236,121.09180596832631,108.66932320856375,130.68923051320127,129.96066349258192,78.591669163878379,59.59466412257207,73.685988432302267,116.36104230074648,90.943145014966689]
[null,null,"replacement expenditure",490.48502921448795,465.23320018117863,407.55814289356374,586.17469110765342,754.96955496206556,697.45706679885757,542.33473272967444,450.83595760264109,504.58610522002596,501.52780624731355,495.3247873955176]
[]
[]
[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 RINs 2008-13, 2014, 2015, 2016, 2017, 2018, 2019"]
[]
[null,"Powerlink"]
[null,null,"Reported Capex spent annually ($m 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure",480.35409232833439,231.50018881067089,311.78764830706154,215.73076777550867,203.59854708800179,280.07372755289737,10.37674438138632,12.398049977596029,0,2.2406696856238932,0]
[null,null,"overheads",36.311193289918258,29.193701250157517,26.763381171980559,25.974459314447714,25.403608965210882,21.081268641460667,13.456020286229581,7.5231967263928885,12.497956301580075,8.5825602819581377,12.446182045524093]
[null,null,"connections",18.836580167169625,4.6990466069053918,4.8291401305146122,6.5373336119552095,3.1932476137135914,5.4502342114756237,1.4857093640605223,0,0,0,0]
[null,null,"non-network",30.693957211615682,39.020338942359082,39.143606008787735,33.196093612416348,36.059240769467635,14.02852815084721,8.1798974048569804,13.704399984110561,18.138920366431098,35.672275348275448,21.782784549389572]
[null,null,"replacement expenditure",196.58734075824336,161.30248822009983,83.482655100060029,209.61576764195925,242.12345839819733,264.83448506499195,154.82445038462436,53.794853295176374,119.96361339154903,64.371477537877468,128.24244369164359]
[]
[null,"Transgrid"]
[null,null,"Reported Capex spent annually ($m 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure",539.57254864957702,300.62818036787019,223.67915389335616,191.71167185121385,297.72830301514654,249.16626983331273,23.431641711249853,56.362682890715334,4.9476636650791521,4.54923845138486,17.992961578342843]
[null,null,"overheads",30.323945225313427,46.764755074710024,33.750095109296765,39.193118334982969,42.864635794936554,35.147423640198497,35.088686522311797,30.942715006721855,32.255044029595261,32.706547493098832,25.453949073172748]
[null,null,"connections",0,0,0,0,0,3.0534245292179194,2.6186467482097715,1.869369529901707,0.81638516282576468,0.3435534013993326,0.78696072597966049]
[null,null,"non-network",40.964154159007855,26.446834812508385,31.11212595867433,46.018164365804715,56.904514281101257,75.245663966561082,37.417101789246537,21.967283834557552,23.970119836519313,30.405145914799064,29.059507693135782]
[null,null,"replacement expenditure",101.1820900708921,121.62481283858531,143.10655544790015,135.35053553648547,152.31637708715917,166.73867914884428,174.37949844086029,145.03828512634453,125.5063488968632,164.68059190008216,132.46849149667509]
[]
[null,"AusNet (T)"]
[null,null,"Reported Capex spent annually ($m 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure*",0,0,0,0,0,0,0,0,0,0,0]
[null,null,"overheads",12.670836182610023,13.567983859328006,14.61970135784329,15.815596389655161,18.042146852371264,15.748288633606457,14.001066715542798,18.476060756354833,13.953509793920405,10.094771114944722,7.2993407132316497]
[null,null,"connections",9.5072111169541937,28.372046653900028,6.6331852274331435,4.2972874506721546,17.236401199487528,62.837572811126158,33.914791803724547,75.988553404206286,37.365950081838847,19.364195382420345,21.684470710080902]
[null,null,"non-network",13.907406420892363,11.179164713654455,16.482410040587464,13.592897734703241,18.627035805549905,23.459912396264286,23.127469054842642,10.691732391847468,8.5168886515013202,11.406942754738573,13.340213254205368]
[null,null,"replacement expenditure",90.836778253664974,110.47828646329745,99.91843619303107,126.5523624512427,160.61780017309144,123.09652039082408,127.99002901179681,128.68799217620079,118.8744909807568,113.70530456838644,126.16901156446504]
[]
[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 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure",14.761253815234689,47.105995758689247,186.18166595209371,90.822939494106279,85.258748689918164,33.903084920577285,17.167007898646681,50.02371343431475,20.214031171132479,22.635990612593268,37.261612634094064]
[null,null,"overheads",7.5016937627383875,9.9314775474598438,14.598355551778413,15.146259477809265,14.661164116524132,12.646892397023654,11.863946074345202,10.383591985832942,10.707726574684688,14.551023126690234,11.200802183075341]
[null,null,"connections",14.965553741305236,24.088110694852986,31.953796730561283,16.869417642042187,13.873874980818554,16.156554637285431,20.14220685057521,2.4073194681236822,3.6057290458629456,0.30114218971274337,2.827093520886693]
[null,null,"non-network",8.6885821532363217,10.14276665967826,8.5531929510756086,8.0703374625340487,13.122328655386648,11.491677337024294,6.4363673550216776,7.5897307222754291,12.52608656284591,29.032353173911101,21.921003928777854]
[null,null,"replacement expenditure",75.377518716827907,51.347349899621719,34.126724569559023,66.303905174524402,124.53886486647804,69.427121518637477,67.134153856330855,107.78056529372495,110.47820370928882,130.35964225791633,82.168982594557946]
[]
[null,"TasNetworks (T)"]
[null,null,"Reported Capex spent annually ($m 2019)","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,null,"augmentation expenditure",69.439864556445116,105.67791122593374,42.742515868002393,55.747804253695044,11.186884782415321,4.7551896741441739,0.15209885980493698,0.26190529702576948,1.2891496022203393,3.326148322903367,3.5263407661310175]
[null,null,"overheads",3.8843249961279467,4.0455643317467427,4.5577585168554995,3.4472709235685897,2.9397907869894868,2.7914033608660738,2.9627788499973957,4.5975161673565035,11.142863264175512,11.632762110835879,13.910842613288418]
[null,null,"connections",0.58143877908733321,7.4582646944093325,26.569062910789409,27.129471196976986,2.1988014917161149,0.1226076780092923,2.5376565606266537E-3,1.0189752464862336E-3,0,0,0]
[null,null,"non-network",11.011822572264968,11.349404542667042,25.800471009201164,7.7918300331053905,5.9761110016957986,5.7348816418850381,3.4308335599105488,5.641517189781065,10.533973015004632,9.8443251090223001,4.8396355894581191]
[null,null,"replacement expenditure",26.501301414859594,20.48026275957433,46.923771583013448,48.352120303441595,75.373054437139658,73.3602606755599,18.006601036062065,15.534261711194404,29.763448241568092,28.41078998305111,26.275858048175962]

{"sheet":"5. Opex","index":9,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,13],[43,1,43,13],[55,1,55,16],[56,1,56,16],[31,1,31,16]]}
[]
[]
[]
[null,"Operating expenditure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"."]
[]
[]
[null,"Operating expenditure (opex) includes network operation, maintenance and other non-capital costs incurred by the transmission businesses. Easement taxes applicable to AusNet (T) have been removed."]
[]
[null,"Actual annual opex"]
[null,"$m 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",163.42793082415326,171.82196609602371,186.82032622371156,179.1139079232577,185.56844521958695,178.9362035828257,185.46618614775318,189.67925820886157,199.71514054510263,228.22784190763559,232.07940409586752,237.17584476748249,192.77569642030207,201.13756149662501]
[null,"Transgrid","NSW",166.3045919085269,165.08325589289524,155.36891999716806,155.89591800410699,175.19216707563015,163.41889357647469,176.10480364324539,162.30059514447379,194.00511126302777,181.60434673530011,179.94942294291022,178.01614405958637,157.78119787938235,155.81952257758931]
[null,"AusNet (T)","VIC",85.491749364066038,83.052004487176035,75.926835158084643,97.853078308978596,98.132029749558626,89.904699677033193,84.647555674113235,86.300478891397375,91.522633121854383,91.329182091367116,94.646228207161087,91.514252611388031,84.106107525592932,87.725137162968934]
[null,"ElectraNet","SA",66.629403668466608,70.898263427022357,64.092372753151736,68.798162213210517,70.319766452628002,76.257851670929952,83.928175794134972,79.917356629715925,81.812100557256798,85.991883176026931,90.738284867309929,93.955827685114514,95.685398262561392,94.171444110684774]
[null,"TasNetworks (T)","TAS",48.799092649481373,50.503518529974343,60.136021348531493,58.574168977211208,58.437556187708793,55.225287684985268,54.325096022776371,51.029193907478657,50.366350467276668,37.465146183259606,39.913472420630818,33.487149900005797,29.772017294581474,31.391660335488488]
[null,"Total",null,{"$f":"SUM(D36:D40)","v":530.65276841469426},{"$f":"SUM(E36:E40)","v":541.35900843309162},542.34447548064747,560.23523542676492,587.64996468511254,563.74293619224875,584.47181728202315,569.22688278192732,617.42133595451821,624.61840009358934,637.32681253387955,{"$f":"SUM(O36:O40)","v":634.14921902357719},{"$f":"SUM(P36:P40)","v":560.12041738242021},{"$f":"SUM(Q36:Q40)","v":570.24532568335655}]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018, 2019"]
[]
[]
[null,"Forecast annual opex"]
[null,"$m 2019","State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015",2016,2017,2018,2019]
[null,"Powerlink","QLD",124.82817837769656,124.8330253953331,185.1979042319067,186.01928183913441,199.90000979069188,191.11477090242514,196.83947640999659,203.33189753870056,211.0655470428147,216.43716901507824,224.54161135508247,231.05059528203205,204.23329429976584,203.34354465156144]
[null,"Transgrid","NSW",166.70199337388277,166.17257174416758,165.74617270185647,165.48575449480737,196.29659203814424,189.43505271327976,194.26654785200245,205.27502050627064,207.34787702647986,185.22523329863955,183.96945080237506,188.8928419178051,181.79830005482995,178.69138055671837]
[null,"AusNet (T)","VIC",106.08075569198859,106.08075569198866,106.08075569198863,105.29871867659485,104.47060335543232,104.4433890634603,103.16389771578091,102.60719420998407,101.21619394993233,91.908945359388071,94.257283329178307,95.041588209277393,95.356899454332932,95.863267830710967]
[null,"ElectraNet","SA",71.141349250449053,71.141349250449068,71.141349250448968,70.889691468442848,73.111861471529892,75.641164799085161,79.239169144363657,82.24869333121579,89.310669725028362,92.703061971043439,94.387255489523142,99.463883590453648,99.852364062345487,91.988291487900526]
[null,"TasNetworks (T)","TAS",44.998012221006,43.326801146567774,39.681218139099492,39.556176032015671,61.598683846912273,62.46319057203582,61.993903319741484,64.921022667232108,64.52945397095624,47.91241794306778,47.258470582434555,47.513382394851533,47.760692058071328,47.232287700960192]
[null,"Total",null,{"$f":"SUM(D49:D53)","v":513.75028891502302},{"$f":"SUM(E49:E53)","v":511.55450322850618},567.84740001530042,567.2496225109951,635.37775050271068,623.09756805028621,635.50299444188511,658.38382825340318,673.46974171521151,634.18682758721707,644.41407155859361,{"$f":"SUM(O49:O53)","v":661.96229139441971},{"$f":"SUM(P49:P53)","v":629.00154992934552},{"$f":"SUM(Q49:Q53)","v":617.11877222785154}]
[]
[null,"Sources:"]
[null,"Forecast opex 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":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,1,3,12],[28,1,32,15],[44,1,44,12]]}
[]
[]
[]
[null,"Network Reliability - Outage events"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Reliability is an important component of network performance. Network performance measures form part of the service target performance incentive scheme (STPIS) relevant to the transmission businesses.\n\nLoss of supply events measure the number of times energy is not available for set periods of times to transmission network customers. These thresholds vary for each business between  0.05 and 1.0 system minutes, as outlined in published AER STPIS decisions.\n"]
[]
[]
[]
[]
[]
[null,"Loss of supply events"]
[null,null,"State",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018]
[null,"Powerlink","QLD",2,2,2,2,0,4,1,0,3,1,0,3,1]
[null,"TransGrid","NSW",2,5,2,3,3,3,3,3,4,4,2,1,1]
[null,"AusNet (T)","VIC",5,2,1,6,1,0,2,5,1,2,3,0,0]
[null,"ElectraNet","SA",4,1,4,4,12,7,7,5,4,1,5,4,3]
[null,"TasNetworks (T)","TAS",16,10,6,8,9,11,10,10,4,3,1,4,2]
[null,"Total loss of supply events",null,29,20,15,23,25,25,23,23,16,11,11,12,7]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018, 2019"]

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

{"sheet":"8. Market impact","index":12,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,1,3,12],[29,1,29,15],[40,1,40,12]]}
[]
[]
[]
[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 National Electricity Market - 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]
[null,"Powerlink","QLD",3.7376331811263319E-2,2.5275875190258753E-2,1.2480974124809741E-2,9.8744292237442927E-3,1.4830669710806698E-2,3.1773211567732115E-3,2.2355403348554032E-3,9.2275494672754946E-4,3.7490487062404869E-2,6.278538812785388E-4,3.9954337899543381E-4,6.9444444444444447E-4,4.2427701674277018E-3]
[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,4.6965372907153732E-2]
[null,"AusNet (T)","VIC",1.1529680365296804E-2,2.546613394216134E-2,3.1421232876712328E-2,1.4421613394216133E-2,2.0918949771689496E-2,3.1601978691019786E-2,2.4809741248097414E-2,1.2813926940639269E-2,8.090753424657534E-3,1.8060312024353119E-2,0.10300608828006089,6.1596270928462711E-2,3.0251141552511416E-3]
[null,"ElectraNet","SA",0.27002473363774732,0.10402397260273973,5.2777777777777778E-2,3.5378614916286147E-2,2.1489726027397259E-2,1.6856925418569254E-2,5.0656392694063926E-2,2.7844368340943684E-2,2.1879756468797563E-3,0.17256468797564689,0.1396689497716895,2.2146118721461189E-2,6.8683409436834097E-2]
[null,"TasNetworks","TAS",2.9490106544901064E-3,5.6668569254185695E-2,3.1963470319634705E-3,9.9124809741248099E-3,3.7775875190258754E-2,6.9349315068493152E-3,1.3375190258751902E-2,1.6999619482496196E-2,1.1700913242009132E-2,2.349695585996956E-3,2.9214231354642312E-2,2.5703957382039573E-2,4.0525114155251139E-2]
[]
[null,"Sources:                                                                                                   "]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018, 2019"]

{"sheet":"9. Maximum demand","index":13,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,41,16],[3,1,3,13],[26,1,27,16],[37,1,37,16],[38,1,38,16],[40,1,40,16]]}
[]
[]
[]
[null,"Maximum demand"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Maximum demand is reported as the coincident maximum demand on each transmission network. That is, the overall demand at the  point in time when demand on the network was at its highest. Maximum demand information can be used to inform expenditure decisions, and is one of the indicators of demand that the AER uses to assess expenditure proposals."]
[]
[]
[null,"Maximum demand (MW)"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[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]
[null,"TransGrid","NSW",12600,12400,13200,13700,13200,13700,11900,12700,12100,10900,11900,13200,12200,13000]
[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]
[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]
[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]
[]
[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, 2014, 2015, 2016, 2017, 2018, 2019; AER data request."]

{"sheet":"10. Energy delivered","index":14,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,16],[41,1,41,16],[42,1,42,16]]}
[]
[]
[]
[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 transmission networks. "]
[]
[null,"Energy delivered - total (GWh)"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[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]
[null,"TransGrid","NSW",81538.366632759004,83028.257359986004,82531.571031917003,81126.238029020999,80626.119478491994,79831.334420277999,76646.150635604004,71147.668184577997,67800,74400,72200,75000,75700,74400]
[null,"AEMO","VIC",45186.299678676005,45956.437073730005,45046.718030759999,47419.179046665005,48976.636241104999,48047.970992500006,47529.361264941996,49056.428480179005,48503.771563634997,47967.077018124997,47805.245822115998,46829.301624718995,42163.488406169992,41479.994350973]
[null,"ElectraNet","SA",15241.186994052407,14809.02240557884,14506.431798357989,14847.610973429968,15008.379403305271,15262.885728180965,15068.932757169014,15061.136823993089,14707.393943953022,14485.733633013175,15043.148933640963,15106.161242227327,14127.757580186377,13786.714687984706]
[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]
[]
[]
[null,"Energy delivered (GWh) -  excluding energy delivered to other transmission networks"]
[null,null,null,"2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[null,"Transmission total",null,182631.49885557801,186176.666821953,187629.68349652903,187179.75041948701,185093.70975965206,181765.99551489798,179217.08292348697,174799.60999226093,170562.854865181,173326.24864551099,177091.91910189003,177372.37977258899,178090.8344007734,177692.77521801769]
[]
[null,"Sources:"]
[null,"Economic Benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018, 2019"]

{"sheet":"11. Circuit length","index":15,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[3,1,3,13],[26,1,26,16],[56,1,56,13]]}
[]
[]
[]
[null,"Circuit length"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The circuit length data is measured at the end of each regulatory year. It includes both overhead lines and underground cables. Circuit length is always greater than or equal to route length, as a double circuit line that traverses 10 kms is counted as 20 km of circuit length."]
[]
[null,"Circuit length"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[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]
[null,"TransGrid","NSW",12517.231000000002,12526.494000000001,12523.514000000001,12523.349,12682.458999999999,12681.862999999999,12697.206999999999,12893.616999999998,12929.665999999999,13024.7646976,13039.195,13078.1133974,13089.494696939964,13052.375219753239]
[null,"AusNet (T)","VIC",6573,6573,6573,6573,6573,6573,6573,6573,6573,6573.2,6558.8447567553667,6559.9720813333333,6623.72,6627.7700000000013]
[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.6689999999999]
[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]
[null,"Total",null,{"$f":"SUM(D31:D35)","v":39972.870000000003},{"$f":"SUM(E31:E35)","v":40133.263000000006},40666.283000000003,40985.418000000005,41559.528000000006,41991.232000000004,41991.976000000002,42810.656000000003,43308.369054000003,43437.513697599999,43441.588756755365,{"$f":"SUM(O31:O35)","v":43253.854478733338},{"$f":"SUM(P31:P35)","v":43308.083696939961},{"$f":"SUM(Q31:Q35)","v":43264.214219753245}]
[]
[null,"Circuit length - overhead"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[null,"Powerlink","QLD",11685,11877,12413,12848,13304,13717,13681,14292,14751,14733,14734,14511,14506,14506]
[null,"TransGrid","NSW",12469.323000000002,12478.586000000001,12475.606000000002,12475.441000000001,12634.550999999999,12633.955,12649.298999999999,12845.708999999999,12878.228999999999,12942.540697599999,12956.955,12996.5323974,13007.854696939965,12966.96721975324]
[null,"AusNet (T)","VIC",6562,6562,6562,6562,6562,6562,6562,6562,6562,6562,6547.6447567553669,6551.4297109999998,6615.18,6619.2300000000014]
[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.47]
[null,"TasNetworks (T)","TAS",3568,3609,3609,3507,3468,3480,3480,3480,3480,3539.9,3539.9,3539.8999999999996,3521.3999999999996,3521.3999999999996]
[null,"Total",null,{"$f":"SUM(D40:D44)","v":39876.073000000004},40036.466,40569.485999999997,40887.320999999996,41461.430999999997,41888.834999999999,41871.178999999996,42679.869000000006,43173.443054000003,43271.600697599999,43275.659756755376,{"$f":"SUM(O40:O44)","v":43091.2321084},{"$f":"SUM(P40:P44)","v":43145.404696939971},{"$f":"SUM(Q40:Q44)","v":43099.067219753248}]
[]
[null,"Circuit length - underground"]
[null,null,"State","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019"]
[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.500000000000004,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]
[null,"AusNet (T)","VIC",11,11,11,11,11,11,11,11,11,11.2,11.2,8.5423703333333396,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]
[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]
[null,"Total",null,{"$f":"SUM(D49:D53)","v":96.796999999999997},96.796999999999997,96.796999999999997,98.097000000000008,98.097000000000008,102.39699999999999,120.79699999999998,130.78700000000001,134.92600000000002,165.91300000000001,165.929,{"$f":"SUM(O49:O53)","v":162.62237033333335},{"$f":"SUM(P49:P53)","v":162.67900000000003},{"$f":"SUM(Q49:Q53)","v":165.14700000000002}]
[]
[null,"Sources:"]
[null,"Economic benchmarking RIN responses, 2006-13, 2014, 2015, 2016, 2017, 2018, 2019"]

{"sheet":"12. Return on assets","index":16,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,11],[3,1,3,11]]}
[]
[]
[]
[null,"Return on assets"]
[]
[null,"This page has been removed. We will report Return on Assets alongside our other profitability measures as part of our 2020 network performance report."]
[]
[null,"For information on Return on Assets go to the ",null,null,"Profitability measures for electricity and gas network businesses",null,null,null,null,null,null,"webpage"]
[null,"at www.aer.gov.au."]