{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Title","Model logic overview","CBA >","Benefits analysis","Options analysis","Outputs","Inputs","Scen","Const","Time series","Supporting data","Sheet1","Sheet2"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"defined_names":34,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CBA for "]
[null,null,"Operational "]
[null,null,"Technology "]
[null,null,"capability uplift"]
[]
[null,null,"DRAFT"]
[null,null,"30 November 2023"]

{"sheet":"Model logic overview","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Not included"]

{"sheet":"CBA >","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Cost Benefit Analysis"]

{"sheet":"Benefits analysis","index":3,"n_rows":175,"n_cols":40,"rows_kept":175,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Benefits analysis"},"Active Option"]
[null,null,"[insert option title]"]
[]
[]
[null,null,"Period commencing",null,"date",null,null,null,{"$f":"'Time series'!I5","v":"2024-07-01"},{"$f":"'Time series'!J5","v":"2025-07-01"},{"$f":"'Time series'!K5","v":"2026-07-01"},{"$f":"'Time series'!L5","v":"2027-07-01"},{"$f":"'Time series'!M5","v":"2028-07-01"},{"$f":"'Time series'!N5","v":"2029-07-01"},{"$f":"'Time series'!O5","v":"2030-07-01"},{"$f":"'Time series'!P5","v":"2031-07-01"},{"$f":"'Time series'!Q5","v":"2032-07-01"},{"$f":"'Time series'!R5","v":"2033-07-01"},{"$f":"'Time series'!S5","v":"2034-07-01"},{"$f":"'Time series'!T5","v":"2035-07-01"},{"$f":"'Time series'!U5","v":"2036-07-01"},{"$f":"'Time series'!V5","v":"2037-07-01"},{"$f":"'Time series'!W5","v":"2038-07-01"},{"$f":"'Time series'!X5","v":"2039-07-01"},{"$f":"'Time series'!Y5","v":"2040-07-01"},{"$f":"'Time series'!Z5","v":"2041-07-01"},{"$f":"'Time series'!AA5","v":"2042-07-01"},{"$f":"'Time series'!AB5","v":"2043-07-01"},{"$f":"'Time series'!AC5","v":"2044-07-01"},{"$f":"'Time series'!AD5","v":"2045-07-01"},{"$f":"'Time series'!AE5","v":"2046-07-01"},{"$f":"'Time series'!AF5","v":"2047-07-01"},{"$f":"'Time series'!AG5","v":"2048-07-01"},{"$f":"'Time series'!AH5","v":"2049-07-01"},{"$f":"'Time series'!AI5","v":"2050-07-01"},{"$f":"'Time series'!AJ5","v":"2051-07-01"},{"$f":"'Time series'!AK5","v":"2052-07-01"},{"$f":"'Time series'!AL5","v":"2053-07-01"},{"$f":"'Time series'!AM5","v":"2054-07-01"},{"$f":"'Time series'!AN5","v":"2055-07-01"}]
[null,null,"Period ending",null,"date",null,null,null,{"$f":"'Time series'!I6","v":"2025-06-30"},{"$f":"'Time series'!J6","v":"2026-06-30"},{"$f":"'Time series'!K6","v":"2027-06-30"},{"$f":"'Time series'!L6","v":"2028-06-30"},{"$f":"'Time series'!M6","v":"2029-06-30"},{"$f":"'Time series'!N6","v":"2030-06-30"},{"$f":"'Time series'!O6","v":"2031-06-30"},{"$f":"'Time series'!P6","v":"2032-06-30"},{"$f":"'Time series'!Q6","v":"2033-06-30"},{"$f":"'Time series'!R6","v":"2034-06-30"},{"$f":"'Time series'!S6","v":"2035-06-30"},{"$f":"'Time series'!T6","v":"2036-06-30"},{"$f":"'Time series'!U6","v":"2037-06-30"},{"$f":"'Time series'!V6","v":"2038-06-30"},{"$f":"'Time series'!W6","v":"2039-06-30"},{"$f":"'Time series'!X6","v":"2040-06-30"},{"$f":"'Time series'!Y6","v":"2041-06-30"},{"$f":"'Time series'!Z6","v":"2042-06-30"},{"$f":"'Time series'!AA6","v":"2043-06-30"},{"$f":"'Time series'!AB6","v":"2044-06-30"},{"$f":"'Time series'!AC6","v":"2045-06-30"},{"$f":"'Time series'!AD6","v":"2046-06-30"},{"$f":"'Time series'!AE6","v":"2047-06-30"},{"$f":"'Time series'!AF6","v":"2048-06-30"},{"$f":"'Time series'!AG6","v":"2049-06-30"},{"$f":"'Time series'!AH6","v":"2050-06-30"},{"$f":"'Time series'!AI6","v":"2051-06-30"},{"$f":"'Time series'!AJ6","v":"2052-06-30"},{"$f":"'Time series'!AK6","v":"2053-06-30"},{"$f":"'Time series'!AL6","v":"2054-06-30"},{"$f":"'Time series'!AM6","v":"2055-06-30"},{"$f":"'Time series'!AN6","v":"2056-06-30"}]
[null,null,"Period number",null,"number",null,null,null,{"$f":"'Time series'!I7","v":1},{"$f":"'Time series'!J7","v":2},{"$f":"'Time series'!K7","v":3},{"$f":"'Time series'!L7","v":4},{"$f":"'Time series'!M7","v":5},{"$f":"'Time series'!N7","v":6},{"$f":"'Time series'!O7","v":7},{"$f":"'Time series'!P7","v":8},{"$f":"'Time series'!Q7","v":9},{"$f":"'Time series'!R7","v":10},{"$f":"'Time series'!S7","v":11},{"$f":"'Time series'!T7","v":12},{"$f":"'Time series'!U7","v":13},{"$f":"'Time series'!V7","v":14},{"$f":"'Time series'!W7","v":15},{"$f":"'Time series'!X7","v":16},{"$f":"'Time series'!Y7","v":17},{"$f":"'Time series'!Z7","v":18},{"$f":"'Time series'!AA7","v":19},{"$f":"'Time series'!AB7","v":20},{"$f":"'Time series'!AC7","v":21},{"$f":"'Time series'!AD7","v":22},{"$f":"'Time series'!AE7","v":23},{"$f":"'Time series'!AF7","v":24},{"$f":"'Time series'!AG7","v":25},{"$f":"'Time series'!AH7","v":26},{"$f":"'Time series'!AI7","v":27},{"$f":"'Time series'!AJ7","v":28},{"$f":"'Time series'!AK7","v":29},{"$f":"'Time series'!AL7","v":30},{"$f":"'Time series'!AM7","v":31},{"$f":"'Time series'!AN7","v":32}]
[null,null,"Valuation period",null,"flag",null,null,null,{"$f":"'Time series'!I8","v":1},{"$f":"'Time series'!J8","v":1},{"$f":"'Time series'!K8","v":1},{"$f":"'Time series'!L8","v":1},{"$f":"'Time series'!M8","v":1},{"$f":"'Time series'!N8","v":1},{"$f":"'Time series'!O8","v":1},{"$f":"'Time series'!P8","v":1},{"$f":"'Time series'!Q8","v":1},{"$f":"'Time series'!R8","v":1},{"$f":"'Time series'!S8","v":1},{"$f":"'Time series'!T8","v":1},{"$f":"'Time series'!U8","v":1},{"$f":"'Time series'!V8","v":1},{"$f":"'Time series'!W8","v":1},{"$f":"'Time series'!X8","v":1},{"$f":"'Time series'!Y8","v":1},{"$f":"'Time series'!Z8","v":1},{"$f":"'Time series'!AA8","v":1},{"$f":"'Time series'!AB8","v":1},{"$f":"'Time series'!AC8","v":1},{"$f":"'Time series'!AD8","v":1},{"$f":"'Time series'!AE8","v":1},{"$f":"'Time series'!AF8","v":1},{"$f":"'Time series'!AG8","v":1},{"$f":"'Time series'!AH8","v":1},{"$f":"'Time series'!AI8","v":1},{"$f":"'Time series'!AJ8","v":1},{"$f":"'Time series'!AK8","v":1},{"$f":"'Time series'!AL8","v":1},{"$f":"'Time series'!AM8","v":0},{"$f":"'Time series'!AN8","v":0}]
[]
[null,null,"Description","Constant","Unit"]
[]
[{"$f":"SectionNumber","v":1},null,"Areas of benefit"]
[null,{"$f":"SectionNumber","v":1.1000000000000001},"Benefits of UNM and data improvements"]
[]
[null,null,"Power system modelling cost reduciton"]
[null,null,"Internal labour to validate models and data",{"$f":"Scen!F22","v":50},"$'000 AUD",null,"Estimate from planning"]
[null,null,"Average annaul consultant costs",{"$f":"Scen!F23","v":250},"$'000 AUD",null,"Estimate from planning"]
[null,null,"Percentage saving due to accurate model and data (consulting fees)",{"$f":"Scen!F24","v":0.2},"$'000 AUD",null,"Estimate from planning"]
[null,null,"Modelling cost reduction",null,"$'000 AUD",null,null,null,{"$f":"$D$17+$D$18*$D$19","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[]
[]
[null,null,"Annual UNM and data improvement cost reduciton",null,"$'000 AUD",null,null,null,{"$f":"I20","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[]
[]
[]
[null,{"$f":"SectionNumber","v":1.2000000000000002},"Unknown network state (pin boards) - safety risk"]
[]
[null,null,"Probability method",{"$f":"Scen!$F$27","v":2},"choice",null,"Risk quantification procedure"]
[]
[null,null,"Worker safety","Probability","Cost"]
[null,null,"No consequence",{"$f":"CHOOSE($D$29,Const!I32,Const!J32)","v":0.99948016892066383},{"$f":"Const!H32","v":0},"$'000 AUD"]
[null,null,"Insignificant",{"$f":"CHOOSE($D$29,Const!I33,Const!J33)","v":1.0153179889364922E-5},{"$f":"Const!H33","v":14.628},"$'000 AUD"]
[null,null,"Minor",{"$f":"CHOOSE($D$29,Const!I34,Const!J34)","v":2.0306359778729844E-5},{"$f":"Const!H34","v":75.569999999999993},"$'000 AUD"]
[null,null,"Moderate",{"$f":"CHOOSE($D$29,Const!I35,Const!J35)","v":3.0459539668094766E-5},{"$f":"Const!H35","v":277.75},"$'000 AUD"]
[null,null,"Major",{"$f":"CHOOSE($D$29,Const!I36,Const!J36)","v":1.1472799999999999E-4},{"$f":"Const!H36","v":5550},"$'000 AUD"]
[null,null,"Severe",{"$f":"CHOOSE($D$29,Const!I37,Const!J37)","v":3.4418399999999998E-4},{"$f":"Const!H37","v":25050},"$'000 AUD"]
[]
[null,null,"Public safety","Probability","Cost"]
[null,null,"No consequence",{"$f":"CHOOSE($D$29,Const!I40,Const!J40)","v":0.99948016892066383},{"$f":"Const!H40","v":0},"$'000 AUD"]
[null,null,"Insignificant",{"$f":"CHOOSE($D$29,Const!I41,Const!J41)","v":1.0153179889364922E-5},{"$f":"Const!H41","v":29.256},"$'000 AUD"]
[null,null,"Minor",{"$f":"CHOOSE($D$29,Const!I42,Const!J42)","v":2.0306359778729844E-5},{"$f":"Const!H42","v":121.14},"$'000 AUD"]
[null,null,"Moderate",{"$f":"CHOOSE($D$29,Const!I43,Const!J43)","v":3.0459539668094766E-5},{"$f":"Const!H43","v":440.5},"$'000 AUD"]
[null,null,"Major",{"$f":"CHOOSE($D$29,Const!I44,Const!J44)","v":1.1472799999999999E-4},{"$f":"Const!H44","v":10050},"$'000 AUD"]
[null,null,"Severe",{"$f":"CHOOSE($D$29,Const!I45,Const!J45)","v":3.4418399999999998E-4},{"$f":"Const!H45","v":40050},"$'000 AUD"]
[]
[null,null,"Total expected HSE cost if there is an event",null,null,"$'000 AUD",null,null,{"$f":"SUMPRODUCT($D$32:$D$37,$E$32:$E$37)+SUMPRODUCT($D$40:$D$45,$E$40:$E$45)","v":24.222452790544949},24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949,24.222452790544949]
[]
[null,null,"Average annual switching events (with outage)",{"$f":"Scen!$F$30","v":1894},null,null,"from outage data records (excludes switching without an outage)"]
[null,null,"Probability of human error / switching error resulting in an outage",{"$f":"Scen!F28","v":4.0000000000000001E-3},"%",null,"from outage data records"]
[null,null,"Factor to adjust for activities not captured by current system",{"$f":"Scen!F29","v":2},"factor",null,"estiamte to account for switching without an outage"]
[null,null,"Annual growth rate (increased network complexity, demand growth and switching)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H52=\"\",1,H52*(1+$D$52))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[null,null,"Percentage reduced with base DMS and improved data",{"$f":"Scen!$F$31","v":0.5},"%",null,"estimate"]
[null,null,"Expected number of Human Errors",null,null,null,null,null,{"$f":"I52*$D$49*$D$50*$D$53","v":3.7880000000000003},{"$f":"J52*$D$49*$D$50*$D$53","v":3.8637600000000001},3.9410352,4.0198559039999999,4.1002530220800004,4.1822580825216003,4.2659032441720317,4.3512213090554726,4.4382457352365829,4.5270106499413139,4.6175508629401412,4.7099018801989434,4.8040999178029224,4.9001819161589806,4.9981855544821601,5.0981492655718039,5.2001122508832403,5.3041144959009054,5.4101967858189237,5.5184007215353024,5.628768735966009,5.7413441106853291,5.8561709928990355,5.9732944127570162,6.0927603010121567,6.2146155070323994,6.3389078171730473,6.4656859735165089,6.5949996929868391,6.7268996868465756,6.8614376805835082,6.9986664341951785]
[]
[]
[null,null,"Forecast average value of safety risk",null,null,"$'000 AUD",null,null,{"$f":"I47*I54*$D$51","v":183.50930234116854},{"$f":"J47*J54*$D$51","v":187.17948838799191},190.92307815575174,194.74153971886676,198.63637051324415,202.60909792350901,206.66127988197917,210.79450547961875,215.01039558921119,219.31060350099537,223.69681557101532,228.17075188243561,232.73416692008431,237.388850258486,242.1366272636557,246.97935980892885,251.91894700510744,256.95732594520962,262.09647246411379,267.33840191339607,272.68516995166402,278.13887335069734,283.70165081771125,289.37568383406546,295.16319751074678,301.0664614609617,307.08779069018095,313.22954650398458,319.49413743406427,325.88402018274553,332.40170058640052,339.04973459812857]
[]
[]
[null,{"$f":"SectionNumber","v":1.3000000000000003},"Connection process non-compliance costs"]
[]
[]
[null,null,"Detailed enquiry response (30 days)"]
[null,null,"Tier 3 penalty",{"$f":"Const!$D$51","v":188},"$'000 AUD"]
[null,null,"Number of FIA per year",{"$f":"Scen!F34","v":10},"#",null,"estimate from connections team based on current FY"]
[null,null,"Growth rate due to energy transistion/econcomic growth",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H66=\"\",1,H66*(1+$D66))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[null,null,"Non-compliance rate",{"$f":"Scen!F35","v":0.25},"%",null,"estimate from connections team based on recent performance",null,{"$f":"$D64*$D65*I66*$D67","v":470},479.40000000000003,488.988,498.76775999999995,508.74311519999998,518.91797750399996,529.29633705408003,539.88226379516163,550.67990907106491,561.69350725248614,572.92737739753591,584.38592494548664,596.07364344439634,607.99511631328426,620.15501863955001,632.55811901234108,645.20928139258785,658.11346702043966,671.27573636084844,684.70125108806542,698.3952761098268,712.36318163202338,726.61044526466389,741.14265416995715,755.96550725335624,771.08481739842341,786.50651374639187,802.23664402131976,818.28137690174617,834.64700443978109,851.33994452857678,868.36674341914829]
[]
[]
[null,null,"Probability of incurring penalty",{"$f":"Scen!F36","v":0.1},"%",null,"estimate based on recent performance, penalties applying, but no penalties incurred historically"]
[]
[null,null,"Forecast cost of customer expectations",null,"$'000 AUD",null,null,null,{"$f":"I67*$D70","v":47},47.940000000000005,48.898800000000001,49.876776,50.874311519999999,51.891797750400002,52.929633705408008,53.988226379516163,55.067990907106491,56.16935072524862,57.292737739753591,58.438592494548665,59.607364344439638,60.799511631328429,62.015501863955002,63.255811901234111,64.520928139258785,65.811346702043963,67.127573636084847,68.470125108806542,69.839527610982685,71.236318163202341,72.661044526466398,74.114265416995721,75.596550725335632,77.108481739842347,78.650651374639196,80.223664402131988,81.828137690174628,83.464700443978117,85.133994452857678,86.836674341914829]
[]
[]
[null,{"$f":"SectionNumber","v":1.4000000000000004},"Capital (field) efficiency improvement"]
[]
[null,null,"Number of distribution jobs schedule per year with outage",{"$f":"Scen!F39","v":443},"#",null,"from outage data records"]
[null,null,"Proportion of distribution jobs requiring an outage",{"$f":"Scen!$F$42","v":0.25},"%"]
[null,null,"Total number of distribution jobs per year",{"$f":"Scen!$F$80","v":1800},"#"]
[null,null,"Percentage cancelled due to planning / notification / human error",{"$f":"Scen!$F$40","v":0.02},"%"]
[null,null,"Percentage avoided with base DMS and improved data",{"$f":"Scen!$F$43","v":0.25},"%"]
[null,null,"Average mobilisation cost per job - direct finanical cost to the work",{"$f":"Scen!F41","v":10},"$'000 AUD"]
[null,null,"Annual growth rate (increased network complexity)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H83=\"\",1,H83*(1+$D$83))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[]
[null,null,"Forecast average field delivery efficiency cost",null,"$'000 AUD",null,null,null,{"$f":"$D$79*$D$80*$D$82*I83*$D$81","v":90},{"$f":"$D$79*$D$80*$D$82*J83*$D$81","v":91.8},93.635999999999996,95.508719999999997,97.418894399999999,99.367272287999995,101.35461773376001,103.3817100884352,105.44934429020391,107.558331176008,109.70949779952817,111.90368775551872,114.1417615106291,116.42459674084166,118.75308867565852,121.12815044917168,123.55071345815513,126.02172772731824,128.54216228186459,131.11300552750188,133.73526563805194,136.40997095081298,139.13817036982925,141.92093377722583,144.75935245277034,147.65453950182575,150.60763029186228,153.61978289769954,156.69217855565353,159.82602212676659,163.02254256930192,166.28299342068797]
[]
[]
[null,{"$f":"SectionNumber","v":1.5000000000000004},"Human error / switching error resulting in outages"]
[]
[null,null,"Annual average lost load",{"$f":"Scen!F46","v":2.2139375000000001},"MWh",null,"from outage data records"]
[null,null,"Customer weighted VCR",{"$f":"Scen!F47","v":26.204000000000004},"$'000 per MWh"]
[null,null,"Annual growth rate (increased network complexity)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H92=\"\",1,H92*(1+$D$92))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[null,null,"Annual average value of lost load",{"$f":"D90*D91","v":58.014018250000014},"$'000"]
[null,null,"Percentage reduced with base DMS and improved data",{"$f":"Scen!$F$31","v":0.5},"%"]
[null,null," "]
[null,null,"Value of lost load (Human error / switching error)",null,null,null,null,null,{"$f":"$D$93*I92*$D$94","v":29.007009125000007},{"$f":"$D$93*J92*$D$94","v":29.587149307500006},30.178892293650009,30.782470139523006,31.398119542313466,32.026081933159738,32.666603571822932,33.319935643259392,33.98633435612458,34.666061043247076,35.359382264112014,36.066569909394254,36.787901307582139,37.523659333733782,38.274132520408457,39.039615170816631,39.820407474232965,40.616815623717628,41.429151936191978,42.25773497491582,43.102889674414136,43.964947467902427,44.844246417260479,45.74113134560568,46.6559539725178,47.58907305196815,48.540854513007517,49.511671603267665,50.501905035333024,51.511943136039683,52.542181998760476,53.593025638735689]
[]
[null,{"$f":"SectionNumber","v":1.6000000000000005},"Overall outage restoration efficiency - avoiding deterioration of reliabiliy"]
[]
[null,null,"Avoided deterioration in reliability"]
[null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"Scen!F51","v":424},"MWh",null,"FY23 RIN data"]
[null,null,"Customer weighted VCR",{"$f":"Scen!F52","v":26.204000000000004},"$'000 per MWh"]
[null,null,"Forecast % avoided lost load / reliability deterioration",{"$f":"Scen!F53","v":0.05},"%"]
[null,null,"Annual growth rate (increased network complexity & demand growth)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H104=\"\",1,H104*(1+$D$104))","v":1},{"$f":"IF(I104=\"\",1,I104*(1+$D$104))","v":1.02},1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[]
[null,null,"Unserved Energy",null,"$'000 AUD",null,null,null,{"$f":"$D$101*$D$103*$D$102*I104","v":555.52480000000014},566.63529600000015,577.96800192000012,589.52736195840009,601.31790919756816,613.34426738151956,625.61115272914992,638.12337578373297,650.88584329940761,663.90356016539579,677.18163136870373,690.72526399607784,704.53976927599933,718.63056466151932,733.00317595474974,747.66323947384478,762.61650426332164,777.86883434858817,793.42621103555996,809.29473525627111,825.48062996139663,841.99024256062455,858.83004741183709,876.00664836007388,893.52678132727533,911.39731695382079,929.62526329289722,948.21776855875521,967.18212392993041,986.52576640852897,1006.2562817366996,1026.3814073714336]
[]
[null,null,"Major event day"]
[null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"Scen!$F$56","v":277},"MWh",null,"Average MED USE as recorded in outage data records"]
[null,null,"Customer weighted VCR",{"$f":"Scen!F57","v":26.204000000000004},"$ per MWh"]
[null,null,"Forecast % avoided lost load / reliability deterioration",{"$f":"Scen!$F$58","v":0.1},"%"]
[null,null,"Annual growth rate (increased network complexity & demand growth)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H112=\"\",1,H112*(1+$D$112))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[null,null,"Frequency",{"$f":"Scen!$F$59","v":0.6},"%"]
[]
[null,null,"Unserved Energy",null,"$'000 AUD",null,null,null,{"$f":"($D$109*$D$111*$D$110*I112)*$D$113","v":435.51048000000009},444.22068960000007,453.10510339200005,462.16720545984009,471.4105495690369,480.83876056041765,490.45553577162599,500.26464648705854,510.26993941679973,520.4753382051357,530.88484496923843,541.50254186862321,552.33259270599569,563.37924456011558,574.6468294513179,586.13976604034428,597.86256136115117,609.81981258837425,622.01620884014176,634.45653301694449,647.14566367728355,660.08857695082929,673.29034848984577,686.75615545964274,700.49127856883558,714.50110414021231,728.79112622301648,743.36694874747684,758.23428772242653,773.39897347687508,788.86695294641254,804.64429200534084]
[]
[null,null,"Cyclone/major storm condition reliability"]
[null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"Scen!F62","v":6710},"MWh",null,"Average of TCs Marcus and Carlos as recorded in outage data records"]
[null,null,"Customer weighted VCR",{"$f":"Scen!F63","v":26.204000000000004},"$ per MWh"]
[null,null,"Forecast % avoided lost load / reliability deterioration",{"$f":"Scen!$F$64","v":0.1},"%"]
[null,null,"Annual growth rate (increased network complexity & demand growth)",{"$f":"Scen!$F$18","v":0.02},"%",null,null,null,{"$f":"IF(H121=\"\",1,H121*(1+$D$121))","v":1},1.02,1.0404,1.0612079999999999,1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252,1.7068864766411058,1.7410242061739281,1.7758446902974065,1.8113615841033548,1.8475888157854219]
[null,null,"Frequency",{"$f":"Scen!F65","v":0.125},"%"]
[]
[null,null,"Unserved Energy",null,"$'000 AUD",null,null,null,{"$f":"($D$118*$D$120*$D$119*I121)*$D$122","v":2197.8605000000002},2241.8177100000003,2286.6540642,2332.387145484,2379.0348883936804,2426.6155861615539,2475.1478978847849,2524.6508558424807,2575.1438729593306,2626.6467504185171,2679.1796854268878,2732.7632791354254,2787.4185447181339,2843.1669156124963,2900.0302539247464,2958.0308590032414,3017.1914761833063,3077.5353057069728,3139.0860118211122,3201.8677320575343,3265.9050866986854,3331.2231884326593,3397.8476522013125,3465.8046052453387,3535.1206973502458,3605.8231112972503,3677.9395735231956,3751.4983649936594,3826.5283322935329,3903.0588989394037,3981.1200769181919,4060.7424784565555]
[]
[]
[null,null,"USE and avoidable outages",null,"$'000 AUD",null,null,null,{"$f":"I106+I115+I124","v":3188.8957800000007},{"$f":"J106+J115+J124","v":3252.6736956000004},3317.7271695120003,3384.0817129022403,3451.7633471602853,3520.7986141034912,3591.2145863855608,3663.0388781132724,3736.2996556755379,3811.0256487890483,3887.24616176483,3964.9910850001265,4044.2909067001292,4125.1767248341312,4207.6802593308139,4291.8338645174299,4377.670541807779,4465.2239526439353,4554.5284316968136,4645.6190003307502,4738.5313803373656,4833.302007944113,4929.9680481029955,5028.5674090650555,5129.1387572463573,5231.7215323912833,5336.3559630391092,5443.0830822998914,5551.94474394589,5662.9836388248077,5776.2433116013035,5891.7681778333299]
[]
[null,{"$f":"SectionNumber","v":1.7000000000000006},"Efficiency in SC raised through reduced SLA costs"]
[]
[null,null,"Base DMS and improved data - make sure drawings represent normal state of the network"]
[null,null,"Reduced drawing management and verification for pin up boards","[c-i-c]","#"]
[null,null,"Annual standard FTE cost","[c-i-c]","$'000 AUD"]
[null,null,"Overall saving",null,"$'000 AUD",null,null,null,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125,125]
[]
[null,null,"Pin board updates"]
[null,null,"Number of FTEs required","[c-i-c]","#"]
[null,null,"Annual standard FTE cost","[c-i-c]","$'000 AUD"]
[]
[null,null,"Near real-time risk modelling of distribution network",null,"$'000 AUD",null,null,null,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25,25]
[]
[null,null,"Switching and permitting process"]
[null,null,"Number of FTEs required","[c-i-c]","#"]
[null,null,"Savings in effort ","[c-i-c]","%"]
[null,null,"Annual standard FTE cost","[c-i-c]","$'000 AUD"]
[]
[null,null,"Near real-time risk modelling of distribution network",null,"$'000 AUD",null,null,null,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250]
[]
[null,null,"SLA efficiency benefits",null,"$'000 AUD",null,null,null,{"$f":"I134+I140+I147","v":400},400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400]
[]
[]
[]
[{"$f":"SectionNumber","v":2},null,"Summary of benefits"]
[]
[null,null,"Value dimension",null,null,"NPV"]
[null,{"$f":"SectionNumber","v":2.1},"Benefits of UNM and data improvements",null,"$'000 AUD",{"$f":"I156+NPV(D$167,OFFSET(J156,,,,$D$166-1))","v":1052.3621369016416},null,null,{"$f":"I23","v":100},100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100]
[null,{"$f":"SectionNumber","v":2.2000000000000002},"Value of safety risk",null,"$'000 AUD",2182.2645727497743,null,null,{"$f":"I57","v":183.50930234116854},187.17948838799191,190.92307815575174,194.74153971886676,198.63637051324415,202.60909792350901,206.66127988197917,210.79450547961875,215.01039558921119,219.31060350099537,223.69681557101532,228.17075188243561,232.73416692008431,237.388850258486,242.1366272636557,246.97935980892885,251.91894700510744,256.95732594520962,262.09647246411379,267.33840191339607,272.68516995166402,278.13887335069734,283.70165081771125,289.37568383406546,295.16319751074678,301.0664614609617,307.08779069018095,313.22954650398458,319.49413743406427,325.88402018274553,332.40170058640052,339.04973459812857]
[null,{"$f":"SectionNumber","v":2.3000000000000003},"Connection process non-compliance costs",null,"$'000 AUD",558.91681571844549,null,null,{"$f":"I72","v":47},47.940000000000005,48.898800000000001,49.876776,50.874311519999999,51.891797750400002,52.929633705408008,53.988226379516163,55.067990907106491,56.16935072524862,57.292737739753591,58.438592494548665,59.607364344439638,60.799511631328429,62.015501863955002,63.255811901234111,64.520928139258785,65.811346702043963,67.127573636084847,68.470125108806542,69.839527610982685,71.236318163202341,72.661044526466398,74.114265416995721,75.596550725335632,77.108481739842347,78.650651374639196,80.223664402131988,81.828137690174628,83.464700443978117,85.133994452857678,86.836674341914829]
[null,{"$f":"SectionNumber","v":2.4000000000000004},"Capex field delivery efficiency cost",null,"$'000 AUD",1070.2662428651081,null,null,{"$f":"I85","v":90},91.8,93.635999999999996,95.508719999999997,97.418894399999999,99.367272287999995,101.35461773376001,103.3817100884352,105.44934429020391,107.558331176008,109.70949779952817,111.90368775551872,114.1417615106291,116.42459674084166,118.75308867565852,121.12815044917168,123.55071345815513,126.02172772731824,128.54216228186459,131.11300552750188,133.73526563805194,136.40997095081298,139.13817036982925,141.92093377722583,144.75935245277034,147.65453950182575,150.60763029186228,153.61978289769954,156.69217855565353,159.82602212676659,163.02254256930192,166.28299342068797]
[null,{"$f":"SectionNumber","v":2.5000000000000004},"Value of lost load (Human error / switching error)",null,"$'000 AUD",344.94691858852963,null,null,{"$f":"I96","v":29.007009125000007},29.587149307500006,30.178892293650009,30.782470139523006,31.398119542313466,32.026081933159738,32.666603571822932,33.319935643259392,33.98633435612458,34.666061043247076,35.359382264112014,36.066569909394254,36.787901307582139,37.523659333733782,38.274132520408457,39.039615170816631,39.820407474232965,40.616815623717628,41.429151936191978,42.25773497491582,43.102889674414136,43.964947467902427,44.844246417260479,45.74113134560568,46.6559539725178,47.58907305196815,48.540854513007517,49.511671603267665,50.501905035333024,51.511943136039683,52.542181998760476,53.593025638735689]
[null,{"$f":"SectionNumber","v":2.6000000000000005},"USE and avoidable outages",null,"$'000 AUD",37921.861170544427,null,null,{"$f":"I127","v":3188.8957800000007},3252.6736956000004,3317.7271695120003,3384.0817129022403,3451.7633471602853,3520.7986141034912,3591.2145863855608,3663.0388781132724,3736.2996556755379,3811.0256487890483,3887.24616176483,3964.9910850001265,4044.2909067001292,4125.1767248341312,4207.6802593308139,4291.8338645174299,4377.670541807779,4465.2239526439353,4554.5284316968136,4645.6190003307502,4738.5313803373656,4833.302007944113,4929.9680481029955,5028.5674090650555,5129.1387572463573,5231.7215323912833,5336.3559630391092,5443.0830822998914,5551.94474394589,5662.9836388248077,5776.2433116013035,5891.7681778333299]
[null,{"$f":"SectionNumber","v":2.7000000000000006},"SLA efficiency benefits",null,"$'000 AUD",4209.4485476065665,null,null,{"$f":"I149","v":400},400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400,400]
[]
[null,null,"Total foreacst cost of retaining current system",null,"$'000 AUD",null,null,null,{"$f":"SUM(I156:I162)","v":4038.4120914661694},4109.1803332954923,4181.3639399614021,4254.9912187606296,4330.0910431358425,4406.6928639985599,4484.8267212785304,4564.5232557041018,4645.8137208181843,4728.7299952345475,4813.3045951392396,4899.5706870420236,4987.562100782864,5077.3133427985213,5168.8596096544916,5262.2368018475809,5357.4815378845333,5454.631168642225,5553.7237920150692,5654.7982678553708,5757.894233212478,5863.0521178767285,5970.3131602342628,6079.7194234389481,6191.3138119077275,6305.1400881458812,6421.242889908799,6539.6677477069752,6660.4611026611155,6783.6703247143378,6909.3437312086244,7037.5306058327969]
[]
[null,null,"NPV valuation period",{"$f":"Scen!$F$16","v":15},"yrs"]
[null,null,"WACC",{"$f":"Scen!$F$15","v":5.6099999999999997E-2},"%"]
[null,null,"Net Present Cost",{"$f":"NPV(D167,OFFSET(J164,,,,D166-1))+I164","v":47340.066404974488},"$'000 AUD"]
[]
[]
[]
[]
[]
[]
["END"]

{"sheet":"Options analysis","index":4,"n_rows":103,"n_cols":40,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Options analysis"},"Active Option"]
[]
[]
[]
[null,null,"Period commencing",null,"date",null,null,null,{"$f":"'Time series'!I5","v":"2024-07-01"},{"$f":"'Time series'!J5","v":"2025-07-01"},{"$f":"'Time series'!K5","v":"2026-07-01"},{"$f":"'Time series'!L5","v":"2027-07-01"},{"$f":"'Time series'!M5","v":"2028-07-01"},{"$f":"'Time series'!N5","v":"2029-07-01"},{"$f":"'Time series'!O5","v":"2030-07-01"},{"$f":"'Time series'!P5","v":"2031-07-01"},{"$f":"'Time series'!Q5","v":"2032-07-01"},{"$f":"'Time series'!R5","v":"2033-07-01"},{"$f":"'Time series'!S5","v":"2034-07-01"},{"$f":"'Time series'!T5","v":"2035-07-01"},{"$f":"'Time series'!U5","v":"2036-07-01"},{"$f":"'Time series'!V5","v":"2037-07-01"},{"$f":"'Time series'!W5","v":"2038-07-01"},{"$f":"'Time series'!X5","v":"2039-07-01"},{"$f":"'Time series'!Y5","v":"2040-07-01"},{"$f":"'Time series'!Z5","v":"2041-07-01"},{"$f":"'Time series'!AA5","v":"2042-07-01"},{"$f":"'Time series'!AB5","v":"2043-07-01"},{"$f":"'Time series'!AC5","v":"2044-07-01"},{"$f":"'Time series'!AD5","v":"2045-07-01"},{"$f":"'Time series'!AE5","v":"2046-07-01"},{"$f":"'Time series'!AF5","v":"2047-07-01"},{"$f":"'Time series'!AG5","v":"2048-07-01"},{"$f":"'Time series'!AH5","v":"2049-07-01"},{"$f":"'Time series'!AI5","v":"2050-07-01"},{"$f":"'Time series'!AJ5","v":"2051-07-01"},{"$f":"'Time series'!AK5","v":"2052-07-01"},{"$f":"'Time series'!AL5","v":"2053-07-01"},{"$f":"'Time series'!AM5","v":"2054-07-01"},{"$f":"'Time series'!AN5","v":"2055-07-01"}]
[null,null,"Period ending",null,"date",null,null,null,{"$f":"'Time series'!I6","v":"2025-06-30"},{"$f":"'Time series'!J6","v":"2026-06-30"},{"$f":"'Time series'!K6","v":"2027-06-30"},{"$f":"'Time series'!L6","v":"2028-06-30"},{"$f":"'Time series'!M6","v":"2029-06-30"},{"$f":"'Time series'!N6","v":"2030-06-30"},{"$f":"'Time series'!O6","v":"2031-06-30"},{"$f":"'Time series'!P6","v":"2032-06-30"},{"$f":"'Time series'!Q6","v":"2033-06-30"},{"$f":"'Time series'!R6","v":"2034-06-30"},{"$f":"'Time series'!S6","v":"2035-06-30"},{"$f":"'Time series'!T6","v":"2036-06-30"},{"$f":"'Time series'!U6","v":"2037-06-30"},{"$f":"'Time series'!V6","v":"2038-06-30"},{"$f":"'Time series'!W6","v":"2039-06-30"},{"$f":"'Time series'!X6","v":"2040-06-30"},{"$f":"'Time series'!Y6","v":"2041-06-30"},{"$f":"'Time series'!Z6","v":"2042-06-30"},{"$f":"'Time series'!AA6","v":"2043-06-30"},{"$f":"'Time series'!AB6","v":"2044-06-30"},{"$f":"'Time series'!AC6","v":"2045-06-30"},{"$f":"'Time series'!AD6","v":"2046-06-30"},{"$f":"'Time series'!AE6","v":"2047-06-30"},{"$f":"'Time series'!AF6","v":"2048-06-30"},{"$f":"'Time series'!AG6","v":"2049-06-30"},{"$f":"'Time series'!AH6","v":"2050-06-30"},{"$f":"'Time series'!AI6","v":"2051-06-30"},{"$f":"'Time series'!AJ6","v":"2052-06-30"},{"$f":"'Time series'!AK6","v":"2053-06-30"},{"$f":"'Time series'!AL6","v":"2054-06-30"},{"$f":"'Time series'!AM6","v":"2055-06-30"},{"$f":"'Time series'!AN6","v":"2056-06-30"}]
[null,null,"Period number",null,"number",null,null,null,{"$f":"'Time series'!I7","v":1},{"$f":"'Time series'!J7","v":2},{"$f":"'Time series'!K7","v":3},{"$f":"'Time series'!L7","v":4},{"$f":"'Time series'!M7","v":5},{"$f":"'Time series'!N7","v":6},{"$f":"'Time series'!O7","v":7},{"$f":"'Time series'!P7","v":8},{"$f":"'Time series'!Q7","v":9},{"$f":"'Time series'!R7","v":10},{"$f":"'Time series'!S7","v":11},{"$f":"'Time series'!T7","v":12},{"$f":"'Time series'!U7","v":13},{"$f":"'Time series'!V7","v":14},{"$f":"'Time series'!W7","v":15},{"$f":"'Time series'!X7","v":16},{"$f":"'Time series'!Y7","v":17},{"$f":"'Time series'!Z7","v":18},{"$f":"'Time series'!AA7","v":19},{"$f":"'Time series'!AB7","v":20},{"$f":"'Time series'!AC7","v":21},{"$f":"'Time series'!AD7","v":22},{"$f":"'Time series'!AE7","v":23},{"$f":"'Time series'!AF7","v":24},{"$f":"'Time series'!AG7","v":25},{"$f":"'Time series'!AH7","v":26},{"$f":"'Time series'!AI7","v":27},{"$f":"'Time series'!AJ7","v":28},{"$f":"'Time series'!AK7","v":29},{"$f":"'Time series'!AL7","v":30},{"$f":"'Time series'!AM7","v":31},{"$f":"'Time series'!AN7","v":32}]
[null,null,"Valuation period",null,"flag",null,null,null,{"$f":"'Time series'!I8","v":1},{"$f":"'Time series'!J8","v":1},{"$f":"'Time series'!K8","v":1},{"$f":"'Time series'!L8","v":1},{"$f":"'Time series'!M8","v":1},{"$f":"'Time series'!N8","v":1},{"$f":"'Time series'!O8","v":1},{"$f":"'Time series'!P8","v":1},{"$f":"'Time series'!Q8","v":1},{"$f":"'Time series'!R8","v":1},{"$f":"'Time series'!S8","v":1},{"$f":"'Time series'!T8","v":1},{"$f":"'Time series'!U8","v":1},{"$f":"'Time series'!V8","v":1},{"$f":"'Time series'!W8","v":1},{"$f":"'Time series'!X8","v":1},{"$f":"'Time series'!Y8","v":1},{"$f":"'Time series'!Z8","v":1},{"$f":"'Time series'!AA8","v":1},{"$f":"'Time series'!AB8","v":1},{"$f":"'Time series'!AC8","v":1},{"$f":"'Time series'!AD8","v":1},{"$f":"'Time series'!AE8","v":1},{"$f":"'Time series'!AF8","v":1},{"$f":"'Time series'!AG8","v":1},{"$f":"'Time series'!AH8","v":1},{"$f":"'Time series'!AI8","v":1},{"$f":"'Time series'!AJ8","v":1},{"$f":"'Time series'!AK8","v":1},{"$f":"'Time series'!AL8","v":1},{"$f":"'Time series'!AM8","v":0},{"$f":"'Time series'!AN8","v":0}]
[]
[null,null,"Description","Constant","Unit"]
[]
[{"$f":"SectionNumber","v":1},null,"Areas of benefit"]
[null,{"$f":"SectionNumber","v":1.1000000000000001},"Optoin 1: Base case / counterfactual"]
[]
[null,null,"NOT COSTED - identified as not a credible option"]
[]
[]
[null,null,"Total cost ",null,"$'000 AUD",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,{"$f":"SectionNumber","v":1.2000000000000002},"Option 2: GIS Upgrade"]
[]
[null,null,"NOTE: Option 2 does not include the DMS or data improvements so there is no incremetnal cost and none of the benefits are obtained."]
[]
[null,null,"Capex"]
[null,null,"Replacement/maintenace of existing systems",null,"$'000 AUD",null,null,null,0,0,0,0,0]
[null,null,"Opex - regulatory peirod 2024-29",null,"$'000 AUD",null,null,null,0,0,0,0,0]
[null,null,"Opex - after FY29-30"]
[null,null,"Total cost",null,"$'000 AUD",null,null,null,{"$f":"SUM(I28:I30)","v":0},{"$f":"SUM(J28:J30)","v":0},{"$f":"SUM(K28:K30)","v":0},{"$f":"SUM(L28:L30)","v":0},{"$f":"SUM(M28:M30)","v":0},{"$f":"SUM(N28:N30)","v":0},{"$f":"SUM(O28:O30)","v":0},{"$f":"SUM(P28:P30)","v":0},{"$f":"SUM(Q28:Q30)","v":0},{"$f":"SUM(R28:R30)","v":0},{"$f":"SUM(S28:S30)","v":0},{"$f":"SUM(T28:T30)","v":0},{"$f":"SUM(U28:U30)","v":0},{"$f":"SUM(V28:V30)","v":0},{"$f":"SUM(W28:W30)","v":0},{"$f":"SUM(X28:X30)","v":0},{"$f":"SUM(Y28:Y30)","v":0},{"$f":"SUM(Z28:Z30)","v":0},{"$f":"SUM(AA28:AA30)","v":0},{"$f":"SUM(AB28:AB30)","v":0},{"$f":"SUM(AC28:AC30)","v":0},{"$f":"SUM(AD28:AD30)","v":0},{"$f":"SUM(AE28:AE30)","v":0},{"$f":"SUM(AF28:AF30)","v":0},{"$f":"SUM(AG28:AG30)","v":0},{"$f":"SUM(AH28:AH30)","v":0},{"$f":"SUM(AI28:AI30)","v":0},{"$f":"SUM(AJ28:AJ30)","v":0},{"$f":"SUM(AK28:AK30)","v":0},{"$f":"SUM(AL28:AL30)","v":0},{"$f":"SUM(AM28:AM30)","v":0},{"$f":"SUM(AN28:AN30)","v":0}]
[]
[null,null,"Network risk"]
[null,null,"Rate of benefit received"]
[null,null,"USE and avoidable outages",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"SLA efficiency benefits",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Benefits of UNM and data improvements",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Value of lost load (Human error / switching error)",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Connection process non-compliance costs",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Capex field delivery efficiency cost",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Value of safety risk",null,"%",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Value of risk incurred"]
[null,null,"USE and avoidable outages",null,null,null,null,null,{"$f":"'Benefits analysis'!I156*I35","v":0},{"$f":"'Benefits analysis'!J156*J35","v":0},{"$f":"'Benefits analysis'!K156*K35","v":0},{"$f":"'Benefits analysis'!L156*L35","v":0},{"$f":"'Benefits analysis'!M156*M35","v":0},{"$f":"'Benefits analysis'!N156*N35","v":0},{"$f":"'Benefits analysis'!O156*O35","v":0},{"$f":"'Benefits analysis'!P156*P35","v":0},{"$f":"'Benefits analysis'!Q156*Q35","v":0},{"$f":"'Benefits analysis'!R156*R35","v":0},{"$f":"'Benefits analysis'!S156*S35","v":0},{"$f":"'Benefits analysis'!T156*T35","v":0},{"$f":"'Benefits analysis'!U156*U35","v":0},{"$f":"'Benefits analysis'!V156*V35","v":0},{"$f":"'Benefits analysis'!W156*W35","v":0},{"$f":"'Benefits analysis'!X156*X35","v":0},{"$f":"'Benefits analysis'!Y156*Y35","v":0},{"$f":"'Benefits analysis'!Z156*Z35","v":0},{"$f":"'Benefits analysis'!AA156*AA35","v":0},{"$f":"'Benefits analysis'!AB156*AB35","v":0},{"$f":"'Benefits analysis'!AC156*AC35","v":0},{"$f":"'Benefits analysis'!AD156*AD35","v":0},{"$f":"'Benefits analysis'!AE156*AE35","v":0},{"$f":"'Benefits analysis'!AF156*AF35","v":0},{"$f":"'Benefits analysis'!AG156*AG35","v":0},{"$f":"'Benefits analysis'!AH156*AH35","v":0},{"$f":"'Benefits analysis'!AI156*AI35","v":0},{"$f":"'Benefits analysis'!AJ156*AJ35","v":0},{"$f":"'Benefits analysis'!AK156*AK35","v":0},{"$f":"'Benefits analysis'!AL156*AL35","v":0},{"$f":"'Benefits analysis'!AM156*AM35","v":0},{"$f":"'Benefits analysis'!AN156*AN35","v":0}]
[null,null,"SLA efficiency benefits",null,null,null,null,null,{"$f":"'Benefits analysis'!I157*I36","v":0},{"$f":"'Benefits analysis'!J157*J36","v":0},{"$f":"'Benefits analysis'!K157*K36","v":0},{"$f":"'Benefits analysis'!L157*L36","v":0},{"$f":"'Benefits analysis'!M157*M36","v":0},{"$f":"'Benefits analysis'!N157*N36","v":0},{"$f":"'Benefits analysis'!O157*O36","v":0},{"$f":"'Benefits analysis'!P157*P36","v":0},{"$f":"'Benefits analysis'!Q157*Q36","v":0},{"$f":"'Benefits analysis'!R157*R36","v":0},{"$f":"'Benefits analysis'!S157*S36","v":0},{"$f":"'Benefits analysis'!T157*T36","v":0},{"$f":"'Benefits analysis'!U157*U36","v":0},{"$f":"'Benefits analysis'!V157*V36","v":0},{"$f":"'Benefits analysis'!W157*W36","v":0},{"$f":"'Benefits analysis'!X157*X36","v":0},{"$f":"'Benefits analysis'!Y157*Y36","v":0},{"$f":"'Benefits analysis'!Z157*Z36","v":0},{"$f":"'Benefits analysis'!AA157*AA36","v":0},{"$f":"'Benefits analysis'!AB157*AB36","v":0},{"$f":"'Benefits analysis'!AC157*AC36","v":0},{"$f":"'Benefits analysis'!AD157*AD36","v":0},{"$f":"'Benefits analysis'!AE157*AE36","v":0},{"$f":"'Benefits analysis'!AF157*AF36","v":0},{"$f":"'Benefits analysis'!AG157*AG36","v":0},{"$f":"'Benefits analysis'!AH157*AH36","v":0},{"$f":"'Benefits analysis'!AI157*AI36","v":0},{"$f":"'Benefits analysis'!AJ157*AJ36","v":0},{"$f":"'Benefits analysis'!AK157*AK36","v":0},{"$f":"'Benefits analysis'!AL157*AL36","v":0},{"$f":"'Benefits analysis'!AM157*AM36","v":0},{"$f":"'Benefits analysis'!AN157*AN36","v":0}]
[null,null,"Benefits of UNM and data improvements",null,null,null,null,null,{"$f":"'Benefits analysis'!I158*I37","v":0},{"$f":"'Benefits analysis'!J158*J37","v":0},{"$f":"'Benefits analysis'!K158*K37","v":0},{"$f":"'Benefits analysis'!L158*L37","v":0},{"$f":"'Benefits analysis'!M158*M37","v":0},{"$f":"'Benefits analysis'!N158*N37","v":0},{"$f":"'Benefits analysis'!O158*O37","v":0},{"$f":"'Benefits analysis'!P158*P37","v":0},{"$f":"'Benefits analysis'!Q158*Q37","v":0},{"$f":"'Benefits analysis'!R158*R37","v":0},{"$f":"'Benefits analysis'!S158*S37","v":0},{"$f":"'Benefits analysis'!T158*T37","v":0},{"$f":"'Benefits analysis'!U158*U37","v":0},{"$f":"'Benefits analysis'!V158*V37","v":0},{"$f":"'Benefits analysis'!W158*W37","v":0},{"$f":"'Benefits analysis'!X158*X37","v":0},{"$f":"'Benefits analysis'!Y158*Y37","v":0},{"$f":"'Benefits analysis'!Z158*Z37","v":0},{"$f":"'Benefits analysis'!AA158*AA37","v":0},{"$f":"'Benefits analysis'!AB158*AB37","v":0},{"$f":"'Benefits analysis'!AC158*AC37","v":0},{"$f":"'Benefits analysis'!AD158*AD37","v":0},{"$f":"'Benefits analysis'!AE158*AE37","v":0},{"$f":"'Benefits analysis'!AF158*AF37","v":0},{"$f":"'Benefits analysis'!AG158*AG37","v":0},{"$f":"'Benefits analysis'!AH158*AH37","v":0},{"$f":"'Benefits analysis'!AI158*AI37","v":0},{"$f":"'Benefits analysis'!AJ158*AJ37","v":0},{"$f":"'Benefits analysis'!AK158*AK37","v":0},{"$f":"'Benefits analysis'!AL158*AL37","v":0},{"$f":"'Benefits analysis'!AM158*AM37","v":0},{"$f":"'Benefits analysis'!AN158*AN37","v":0}]
[null,null,"Value of lost load (Human error / switching error)",null,null,null,null,null,{"$f":"'Benefits analysis'!I159*I38","v":0},{"$f":"'Benefits analysis'!J159*J38","v":0},{"$f":"'Benefits analysis'!K159*K38","v":0},{"$f":"'Benefits analysis'!L159*L38","v":0},{"$f":"'Benefits analysis'!M159*M38","v":0},{"$f":"'Benefits analysis'!N159*N38","v":0},{"$f":"'Benefits analysis'!O159*O38","v":0},{"$f":"'Benefits analysis'!P159*P38","v":0},{"$f":"'Benefits analysis'!Q159*Q38","v":0},{"$f":"'Benefits analysis'!R159*R38","v":0},{"$f":"'Benefits analysis'!S159*S38","v":0},{"$f":"'Benefits analysis'!T159*T38","v":0},{"$f":"'Benefits analysis'!U159*U38","v":0},{"$f":"'Benefits analysis'!V159*V38","v":0},{"$f":"'Benefits analysis'!W159*W38","v":0},{"$f":"'Benefits analysis'!X159*X38","v":0},{"$f":"'Benefits analysis'!Y159*Y38","v":0},{"$f":"'Benefits analysis'!Z159*Z38","v":0},{"$f":"'Benefits analysis'!AA159*AA38","v":0},{"$f":"'Benefits analysis'!AB159*AB38","v":0},{"$f":"'Benefits analysis'!AC159*AC38","v":0},{"$f":"'Benefits analysis'!AD159*AD38","v":0},{"$f":"'Benefits analysis'!AE159*AE38","v":0},{"$f":"'Benefits analysis'!AF159*AF38","v":0},{"$f":"'Benefits analysis'!AG159*AG38","v":0},{"$f":"'Benefits analysis'!AH159*AH38","v":0},{"$f":"'Benefits analysis'!AI159*AI38","v":0},{"$f":"'Benefits analysis'!AJ159*AJ38","v":0},{"$f":"'Benefits analysis'!AK159*AK38","v":0},{"$f":"'Benefits analysis'!AL159*AL38","v":0},{"$f":"'Benefits analysis'!AM159*AM38","v":0},{"$f":"'Benefits analysis'!AN159*AN38","v":0}]
[null,null,"Connection process non-compliance costs",null,null,null,null,null,{"$f":"'Benefits analysis'!I160*I39","v":0},{"$f":"'Benefits analysis'!J160*J39","v":0},{"$f":"'Benefits analysis'!K160*K39","v":0},{"$f":"'Benefits analysis'!L160*L39","v":0},{"$f":"'Benefits analysis'!M160*M39","v":0},{"$f":"'Benefits analysis'!N160*N39","v":0},{"$f":"'Benefits analysis'!O160*O39","v":0},{"$f":"'Benefits analysis'!P160*P39","v":0},{"$f":"'Benefits analysis'!Q160*Q39","v":0},{"$f":"'Benefits analysis'!R160*R39","v":0},{"$f":"'Benefits analysis'!S160*S39","v":0},{"$f":"'Benefits analysis'!T160*T39","v":0},{"$f":"'Benefits analysis'!U160*U39","v":0},{"$f":"'Benefits analysis'!V160*V39","v":0},{"$f":"'Benefits analysis'!W160*W39","v":0},{"$f":"'Benefits analysis'!X160*X39","v":0},{"$f":"'Benefits analysis'!Y160*Y39","v":0},{"$f":"'Benefits analysis'!Z160*Z39","v":0},{"$f":"'Benefits analysis'!AA160*AA39","v":0},{"$f":"'Benefits analysis'!AB160*AB39","v":0},{"$f":"'Benefits analysis'!AC160*AC39","v":0},{"$f":"'Benefits analysis'!AD160*AD39","v":0},{"$f":"'Benefits analysis'!AE160*AE39","v":0},{"$f":"'Benefits analysis'!AF160*AF39","v":0},{"$f":"'Benefits analysis'!AG160*AG39","v":0},{"$f":"'Benefits analysis'!AH160*AH39","v":0},{"$f":"'Benefits analysis'!AI160*AI39","v":0},{"$f":"'Benefits analysis'!AJ160*AJ39","v":0},{"$f":"'Benefits analysis'!AK160*AK39","v":0},{"$f":"'Benefits analysis'!AL160*AL39","v":0},{"$f":"'Benefits analysis'!AM160*AM39","v":0},{"$f":"'Benefits analysis'!AN160*AN39","v":0}]
[null,null,"Capex field delivery efficiency cost",null,null,null,null,null,{"$f":"'Benefits analysis'!I161*I40","v":0},{"$f":"'Benefits analysis'!J161*J40","v":0},{"$f":"'Benefits analysis'!K161*K40","v":0},{"$f":"'Benefits analysis'!L161*L40","v":0},{"$f":"'Benefits analysis'!M161*M40","v":0},{"$f":"'Benefits analysis'!N161*N40","v":0},{"$f":"'Benefits analysis'!O161*O40","v":0},{"$f":"'Benefits analysis'!P161*P40","v":0},{"$f":"'Benefits analysis'!Q161*Q40","v":0},{"$f":"'Benefits analysis'!R161*R40","v":0},{"$f":"'Benefits analysis'!S161*S40","v":0},{"$f":"'Benefits analysis'!T161*T40","v":0},{"$f":"'Benefits analysis'!U161*U40","v":0},{"$f":"'Benefits analysis'!V161*V40","v":0},{"$f":"'Benefits analysis'!W161*W40","v":0},{"$f":"'Benefits analysis'!X161*X40","v":0},{"$f":"'Benefits analysis'!Y161*Y40","v":0},{"$f":"'Benefits analysis'!Z161*Z40","v":0},{"$f":"'Benefits analysis'!AA161*AA40","v":0},{"$f":"'Benefits analysis'!AB161*AB40","v":0},{"$f":"'Benefits analysis'!AC161*AC40","v":0},{"$f":"'Benefits analysis'!AD161*AD40","v":0},{"$f":"'Benefits analysis'!AE161*AE40","v":0},{"$f":"'Benefits analysis'!AF161*AF40","v":0},{"$f":"'Benefits analysis'!AG161*AG40","v":0},{"$f":"'Benefits analysis'!AH161*AH40","v":0},{"$f":"'Benefits analysis'!AI161*AI40","v":0},{"$f":"'Benefits analysis'!AJ161*AJ40","v":0},{"$f":"'Benefits analysis'!AK161*AK40","v":0},{"$f":"'Benefits analysis'!AL161*AL40","v":0},{"$f":"'Benefits analysis'!AM161*AM40","v":0},{"$f":"'Benefits analysis'!AN161*AN40","v":0}]
[null,null,"Value of safety risk",null,null,null,null,null,{"$f":"'Benefits analysis'!I162*I41","v":0},{"$f":"'Benefits analysis'!J162*J41","v":0},{"$f":"'Benefits analysis'!K162*K41","v":0},{"$f":"'Benefits analysis'!L162*L41","v":0},{"$f":"'Benefits analysis'!M162*M41","v":0},{"$f":"'Benefits analysis'!N162*N41","v":0},{"$f":"'Benefits analysis'!O162*O41","v":0},{"$f":"'Benefits analysis'!P162*P41","v":0},{"$f":"'Benefits analysis'!Q162*Q41","v":0},{"$f":"'Benefits analysis'!R162*R41","v":0},{"$f":"'Benefits analysis'!S162*S41","v":0},{"$f":"'Benefits analysis'!T162*T41","v":0},{"$f":"'Benefits analysis'!U162*U41","v":0},{"$f":"'Benefits analysis'!V162*V41","v":0},{"$f":"'Benefits analysis'!W162*W41","v":0},{"$f":"'Benefits analysis'!X162*X41","v":0},{"$f":"'Benefits analysis'!Y162*Y41","v":0},{"$f":"'Benefits analysis'!Z162*Z41","v":0},{"$f":"'Benefits analysis'!AA162*AA41","v":0},{"$f":"'Benefits analysis'!AB162*AB41","v":0},{"$f":"'Benefits analysis'!AC162*AC41","v":0},{"$f":"'Benefits analysis'!AD162*AD41","v":0},{"$f":"'Benefits analysis'!AE162*AE41","v":0},{"$f":"'Benefits analysis'!AF162*AF41","v":0},{"$f":"'Benefits analysis'!AG162*AG41","v":0},{"$f":"'Benefits analysis'!AH162*AH41","v":0},{"$f":"'Benefits analysis'!AI162*AI41","v":0},{"$f":"'Benefits analysis'!AJ162*AJ41","v":0},{"$f":"'Benefits analysis'!AK162*AK41","v":0},{"$f":"'Benefits analysis'!AL162*AL41","v":0},{"$f":"'Benefits analysis'!AM162*AM41","v":0},{"$f":"'Benefits analysis'!AN162*AN41","v":0}]
[null,null,"Total benefits",null,"$'000 AUD",null,null,null,{"$f":"SUM(I44:I50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,"Total cost ",null,"$'000 AUD",null,null,null,{"$f":"-I31+I51","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,{"$f":"SectionNumber","v":1.3000000000000003},"Option 3: Evolving OT capaibility enhancements"]
[]
[]
[null,null,"Capex"]
[null,null,"Replacement/maintenace of existing systems",null,"$'000 AUD",null,null,null,1415,1565,2342,3400,2350]
[null,null,"Opex - regulatory peirod 2024-29",null,"$'000 AUD",null,null,null,540,540,540,640,640]
[null,null,"Opex - after FY29-30",null,"$'000 AUD",null,null,null,null,null,null,null,null,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700]
[null,null,"Total cost",null,"$'000 AUD",null,null,null,{"$f":"SUM(I61:I63)","v":1955},{"$f":"SUM(J61:J63)","v":2105},2882,4040,2990,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700,700]
[]
[null,null,"Network risk"]
[null,null,"Rate of benefit received"]
[null,null,"USE and avoidable outages",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"SLA efficiency benefits",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Benefits of UNM and data improvements",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Value of lost load (Human error / switching error)",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Connection process non-compliance costs",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Capex field delivery efficiency cost",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,null,"Value of safety risk",null,"%",null,null,null,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[null,null,"Value of risk incurred"]
[null,null,"USE and avoidable outages",null,null,null,null,null,{"$f":"'Benefits analysis'!I156*I68","v":0},{"$f":"'Benefits analysis'!J156*J68","v":0},{"$f":"'Benefits analysis'!K156*K68","v":0},{"$f":"'Benefits analysis'!L156*L68","v":0},{"$f":"'Benefits analysis'!M156*M68","v":0},{"$f":"'Benefits analysis'!N156*N68","v":100},{"$f":"'Benefits analysis'!O156*O68","v":100},{"$f":"'Benefits analysis'!P156*P68","v":100},{"$f":"'Benefits analysis'!Q156*Q68","v":100},{"$f":"'Benefits analysis'!R156*R68","v":100},{"$f":"'Benefits analysis'!S156*S68","v":100},{"$f":"'Benefits analysis'!T156*T68","v":100},{"$f":"'Benefits analysis'!U156*U68","v":100},{"$f":"'Benefits analysis'!V156*V68","v":100},{"$f":"'Benefits analysis'!W156*W68","v":100},{"$f":"'Benefits analysis'!X156*X68","v":100},{"$f":"'Benefits analysis'!Y156*Y68","v":100},{"$f":"'Benefits analysis'!Z156*Z68","v":100},{"$f":"'Benefits analysis'!AA156*AA68","v":100},{"$f":"'Benefits analysis'!AB156*AB68","v":100},{"$f":"'Benefits analysis'!AC156*AC68","v":100},{"$f":"'Benefits analysis'!AD156*AD68","v":100},{"$f":"'Benefits analysis'!AE156*AE68","v":100},{"$f":"'Benefits analysis'!AF156*AF68","v":100},{"$f":"'Benefits analysis'!AG156*AG68","v":100},{"$f":"'Benefits analysis'!AH156*AH68","v":100},{"$f":"'Benefits analysis'!AI156*AI68","v":100},{"$f":"'Benefits analysis'!AJ156*AJ68","v":100},{"$f":"'Benefits analysis'!AK156*AK68","v":100},{"$f":"'Benefits analysis'!AL156*AL68","v":100},{"$f":"'Benefits analysis'!AM156*AM68","v":100},{"$f":"'Benefits analysis'!AN156*AN68","v":100}]
[null,null,"SLA efficiency benefits",null,null,null,null,null,{"$f":"'Benefits analysis'!I157*I69","v":0},{"$f":"'Benefits analysis'!J157*J69","v":0},{"$f":"'Benefits analysis'!K157*K69","v":0},{"$f":"'Benefits analysis'!L157*L69","v":0},{"$f":"'Benefits analysis'!M157*M69","v":0},{"$f":"'Benefits analysis'!N157*N69","v":202.60909792350901},{"$f":"'Benefits analysis'!O157*O69","v":206.66127988197917},{"$f":"'Benefits analysis'!P157*P69","v":210.79450547961875},{"$f":"'Benefits analysis'!Q157*Q69","v":215.01039558921119},{"$f":"'Benefits analysis'!R157*R69","v":219.31060350099537},{"$f":"'Benefits analysis'!S157*S69","v":223.69681557101532},{"$f":"'Benefits analysis'!T157*T69","v":228.17075188243561},{"$f":"'Benefits analysis'!U157*U69","v":232.73416692008431},{"$f":"'Benefits analysis'!V157*V69","v":237.388850258486},{"$f":"'Benefits analysis'!W157*W69","v":242.1366272636557},{"$f":"'Benefits analysis'!X157*X69","v":246.97935980892885},{"$f":"'Benefits analysis'!Y157*Y69","v":251.91894700510744},{"$f":"'Benefits analysis'!Z157*Z69","v":256.95732594520962},{"$f":"'Benefits analysis'!AA157*AA69","v":262.09647246411379},{"$f":"'Benefits analysis'!AB157*AB69","v":267.33840191339607},{"$f":"'Benefits analysis'!AC157*AC69","v":272.68516995166402},{"$f":"'Benefits analysis'!AD157*AD69","v":278.13887335069734},{"$f":"'Benefits analysis'!AE157*AE69","v":283.70165081771125},{"$f":"'Benefits analysis'!AF157*AF69","v":289.37568383406546},{"$f":"'Benefits analysis'!AG157*AG69","v":295.16319751074678},{"$f":"'Benefits analysis'!AH157*AH69","v":301.0664614609617},{"$f":"'Benefits analysis'!AI157*AI69","v":307.08779069018095},{"$f":"'Benefits analysis'!AJ157*AJ69","v":313.22954650398458},{"$f":"'Benefits analysis'!AK157*AK69","v":319.49413743406427},{"$f":"'Benefits analysis'!AL157*AL69","v":325.88402018274553},{"$f":"'Benefits analysis'!AM157*AM69","v":332.40170058640052},{"$f":"'Benefits analysis'!AN157*AN69","v":339.04973459812857}]
[null,null,"Benefits of UNM and data improvements",null,null,null,null,null,{"$f":"'Benefits analysis'!I158*I70","v":0},{"$f":"'Benefits analysis'!J158*J70","v":0},{"$f":"'Benefits analysis'!K158*K70","v":0},{"$f":"'Benefits analysis'!L158*L70","v":0},{"$f":"'Benefits analysis'!M158*M70","v":0},{"$f":"'Benefits analysis'!N158*N70","v":51.891797750400002},{"$f":"'Benefits analysis'!O158*O70","v":52.929633705408008},{"$f":"'Benefits analysis'!P158*P70","v":53.988226379516163},{"$f":"'Benefits analysis'!Q158*Q70","v":55.067990907106491},{"$f":"'Benefits analysis'!R158*R70","v":56.16935072524862},{"$f":"'Benefits analysis'!S158*S70","v":57.292737739753591},{"$f":"'Benefits analysis'!T158*T70","v":58.438592494548665},{"$f":"'Benefits analysis'!U158*U70","v":59.607364344439638},{"$f":"'Benefits analysis'!V158*V70","v":60.799511631328429},{"$f":"'Benefits analysis'!W158*W70","v":62.015501863955002},{"$f":"'Benefits analysis'!X158*X70","v":63.255811901234111},{"$f":"'Benefits analysis'!Y158*Y70","v":64.520928139258785},{"$f":"'Benefits analysis'!Z158*Z70","v":65.811346702043963},{"$f":"'Benefits analysis'!AA158*AA70","v":67.127573636084847},{"$f":"'Benefits analysis'!AB158*AB70","v":68.470125108806542},{"$f":"'Benefits analysis'!AC158*AC70","v":69.839527610982685},{"$f":"'Benefits analysis'!AD158*AD70","v":71.236318163202341},{"$f":"'Benefits analysis'!AE158*AE70","v":72.661044526466398},{"$f":"'Benefits analysis'!AF158*AF70","v":74.114265416995721},{"$f":"'Benefits analysis'!AG158*AG70","v":75.596550725335632},{"$f":"'Benefits analysis'!AH158*AH70","v":77.108481739842347},{"$f":"'Benefits analysis'!AI158*AI70","v":78.650651374639196},{"$f":"'Benefits analysis'!AJ158*AJ70","v":80.223664402131988},{"$f":"'Benefits analysis'!AK158*AK70","v":81.828137690174628},{"$f":"'Benefits analysis'!AL158*AL70","v":83.464700443978117},{"$f":"'Benefits analysis'!AM158*AM70","v":85.133994452857678},{"$f":"'Benefits analysis'!AN158*AN70","v":86.836674341914829}]
[null,null,"Value of lost load (Human error / switching error)",null,null,null,null,null,{"$f":"'Benefits analysis'!I159*I71","v":0},{"$f":"'Benefits analysis'!J159*J71","v":0},{"$f":"'Benefits analysis'!K159*K71","v":0},{"$f":"'Benefits analysis'!L159*L71","v":0},{"$f":"'Benefits analysis'!M159*M71","v":0},{"$f":"'Benefits analysis'!N159*N71","v":99.367272287999995},{"$f":"'Benefits analysis'!O159*O71","v":101.35461773376001},{"$f":"'Benefits analysis'!P159*P71","v":103.3817100884352},{"$f":"'Benefits analysis'!Q159*Q71","v":105.44934429020391},{"$f":"'Benefits analysis'!R159*R71","v":107.558331176008},{"$f":"'Benefits analysis'!S159*S71","v":109.70949779952817},{"$f":"'Benefits analysis'!T159*T71","v":111.90368775551872},{"$f":"'Benefits analysis'!U159*U71","v":114.1417615106291},{"$f":"'Benefits analysis'!V159*V71","v":116.42459674084166},{"$f":"'Benefits analysis'!W159*W71","v":118.75308867565852},{"$f":"'Benefits analysis'!X159*X71","v":121.12815044917168},{"$f":"'Benefits analysis'!Y159*Y71","v":123.55071345815513},{"$f":"'Benefits analysis'!Z159*Z71","v":126.02172772731824},{"$f":"'Benefits analysis'!AA159*AA71","v":128.54216228186459},{"$f":"'Benefits analysis'!AB159*AB71","v":131.11300552750188},{"$f":"'Benefits analysis'!AC159*AC71","v":133.73526563805194},{"$f":"'Benefits analysis'!AD159*AD71","v":136.40997095081298},{"$f":"'Benefits analysis'!AE159*AE71","v":139.13817036982925},{"$f":"'Benefits analysis'!AF159*AF71","v":141.92093377722583},{"$f":"'Benefits analysis'!AG159*AG71","v":144.75935245277034},{"$f":"'Benefits analysis'!AH159*AH71","v":147.65453950182575},{"$f":"'Benefits analysis'!AI159*AI71","v":150.60763029186228},{"$f":"'Benefits analysis'!AJ159*AJ71","v":153.61978289769954},{"$f":"'Benefits analysis'!AK159*AK71","v":156.69217855565353},{"$f":"'Benefits analysis'!AL159*AL71","v":159.82602212676659},{"$f":"'Benefits analysis'!AM159*AM71","v":163.02254256930192},{"$f":"'Benefits analysis'!AN159*AN71","v":166.28299342068797}]
[null,null,"Connection process non-compliance costs",null,null,null,null,null,{"$f":"'Benefits analysis'!I160*I72","v":0},{"$f":"'Benefits analysis'!J160*J72","v":0},{"$f":"'Benefits analysis'!K160*K72","v":0},{"$f":"'Benefits analysis'!L160*L72","v":0},{"$f":"'Benefits analysis'!M160*M72","v":0},{"$f":"'Benefits analysis'!N160*N72","v":32.026081933159738},{"$f":"'Benefits analysis'!O160*O72","v":32.666603571822932},{"$f":"'Benefits analysis'!P160*P72","v":33.319935643259392},{"$f":"'Benefits analysis'!Q160*Q72","v":33.98633435612458},{"$f":"'Benefits analysis'!R160*R72","v":34.666061043247076},{"$f":"'Benefits analysis'!S160*S72","v":35.359382264112014},{"$f":"'Benefits analysis'!T160*T72","v":36.066569909394254},{"$f":"'Benefits analysis'!U160*U72","v":36.787901307582139},{"$f":"'Benefits analysis'!V160*V72","v":37.523659333733782},{"$f":"'Benefits analysis'!W160*W72","v":38.274132520408457},{"$f":"'Benefits analysis'!X160*X72","v":39.039615170816631},{"$f":"'Benefits analysis'!Y160*Y72","v":39.820407474232965},{"$f":"'Benefits analysis'!Z160*Z72","v":40.616815623717628},{"$f":"'Benefits analysis'!AA160*AA72","v":41.429151936191978},{"$f":"'Benefits analysis'!AB160*AB72","v":42.25773497491582},{"$f":"'Benefits analysis'!AC160*AC72","v":43.102889674414136},{"$f":"'Benefits analysis'!AD160*AD72","v":43.964947467902427},{"$f":"'Benefits analysis'!AE160*AE72","v":44.844246417260479},{"$f":"'Benefits analysis'!AF160*AF72","v":45.74113134560568},{"$f":"'Benefits analysis'!AG160*AG72","v":46.6559539725178},{"$f":"'Benefits analysis'!AH160*AH72","v":47.58907305196815},{"$f":"'Benefits analysis'!AI160*AI72","v":48.540854513007517},{"$f":"'Benefits analysis'!AJ160*AJ72","v":49.511671603267665},{"$f":"'Benefits analysis'!AK160*AK72","v":50.501905035333024},{"$f":"'Benefits analysis'!AL160*AL72","v":51.511943136039683},{"$f":"'Benefits analysis'!AM160*AM72","v":52.542181998760476},{"$f":"'Benefits analysis'!AN160*AN72","v":53.593025638735689}]
[null,null,"Capex field delivery efficiency cost",null,null,null,null,null,{"$f":"'Benefits analysis'!I161*I73","v":0},{"$f":"'Benefits analysis'!J161*J73","v":0},{"$f":"'Benefits analysis'!K161*K73","v":0},{"$f":"'Benefits analysis'!L161*L73","v":0},{"$f":"'Benefits analysis'!M161*M73","v":0},{"$f":"'Benefits analysis'!N161*N73","v":3520.7986141034912},{"$f":"'Benefits analysis'!O161*O73","v":3591.2145863855608},{"$f":"'Benefits analysis'!P161*P73","v":3663.0388781132724},{"$f":"'Benefits analysis'!Q161*Q73","v":3736.2996556755379},{"$f":"'Benefits analysis'!R161*R73","v":3811.0256487890483},{"$f":"'Benefits analysis'!S161*S73","v":3887.24616176483},{"$f":"'Benefits analysis'!T161*T73","v":3964.9910850001265},{"$f":"'Benefits analysis'!U161*U73","v":4044.2909067001292},{"$f":"'Benefits analysis'!V161*V73","v":4125.1767248341312},{"$f":"'Benefits analysis'!W161*W73","v":4207.6802593308139},{"$f":"'Benefits analysis'!X161*X73","v":4291.8338645174299},{"$f":"'Benefits analysis'!Y161*Y73","v":4377.670541807779},{"$f":"'Benefits analysis'!Z161*Z73","v":4465.2239526439353},{"$f":"'Benefits analysis'!AA161*AA73","v":4554.5284316968136},{"$f":"'Benefits analysis'!AB161*AB73","v":4645.6190003307502},{"$f":"'Benefits analysis'!AC161*AC73","v":4738.5313803373656},{"$f":"'Benefits analysis'!AD161*AD73","v":4833.302007944113},{"$f":"'Benefits analysis'!AE161*AE73","v":4929.9680481029955},{"$f":"'Benefits analysis'!AF161*AF73","v":5028.5674090650555},{"$f":"'Benefits analysis'!AG161*AG73","v":5129.1387572463573},{"$f":"'Benefits analysis'!AH161*AH73","v":5231.7215323912833},{"$f":"'Benefits analysis'!AI161*AI73","v":5336.3559630391092},{"$f":"'Benefits analysis'!AJ161*AJ73","v":5443.0830822998914},{"$f":"'Benefits analysis'!AK161*AK73","v":5551.94474394589},{"$f":"'Benefits analysis'!AL161*AL73","v":5662.9836388248077},{"$f":"'Benefits analysis'!AM161*AM73","v":5776.2433116013035},{"$f":"'Benefits analysis'!AN161*AN73","v":5891.7681778333299}]
[null,null,"Value of safety risk",null,null,null,null,null,{"$f":"'Benefits analysis'!I162*I74","v":0},{"$f":"'Benefits analysis'!J162*J74","v":0},{"$f":"'Benefits analysis'!K162*K74","v":0},{"$f":"'Benefits analysis'!L162*L74","v":0},{"$f":"'Benefits analysis'!M162*M74","v":0},{"$f":"'Benefits analysis'!N162*N74","v":400},{"$f":"'Benefits analysis'!O162*O74","v":400},{"$f":"'Benefits analysis'!P162*P74","v":400},{"$f":"'Benefits analysis'!Q162*Q74","v":400},{"$f":"'Benefits analysis'!R162*R74","v":400},{"$f":"'Benefits analysis'!S162*S74","v":400},{"$f":"'Benefits analysis'!T162*T74","v":400},{"$f":"'Benefits analysis'!U162*U74","v":400},{"$f":"'Benefits analysis'!V162*V74","v":400},{"$f":"'Benefits analysis'!W162*W74","v":400},{"$f":"'Benefits analysis'!X162*X74","v":400},{"$f":"'Benefits analysis'!Y162*Y74","v":400},{"$f":"'Benefits analysis'!Z162*Z74","v":400},{"$f":"'Benefits analysis'!AA162*AA74","v":400},{"$f":"'Benefits analysis'!AB162*AB74","v":400},{"$f":"'Benefits analysis'!AC162*AC74","v":400},{"$f":"'Benefits analysis'!AD162*AD74","v":400},{"$f":"'Benefits analysis'!AE162*AE74","v":400},{"$f":"'Benefits analysis'!AF162*AF74","v":400},{"$f":"'Benefits analysis'!AG162*AG74","v":400},{"$f":"'Benefits analysis'!AH162*AH74","v":400},{"$f":"'Benefits analysis'!AI162*AI74","v":400},{"$f":"'Benefits analysis'!AJ162*AJ74","v":400},{"$f":"'Benefits analysis'!AK162*AK74","v":400},{"$f":"'Benefits analysis'!AL162*AL74","v":400},{"$f":"'Benefits analysis'!AM162*AM74","v":400},{"$f":"'Benefits analysis'!AN162*AN74","v":400}]
[null,null,"Total benefits",null,"$'000 AUD",null,null,null,{"$f":"SUM(I77:I83)","v":0},0,0,0,0,4406.6928639985599,4484.8267212785304,4564.5232557041018,4645.8137208181843,4728.7299952345475,4813.3045951392396,4899.5706870420236,4987.562100782864,5077.3133427985213,5168.8596096544916,5262.2368018475809,5357.4815378845333,5454.631168642225,5553.7237920150692,5654.7982678553708,5757.894233212478,5863.0521178767285,5970.3131602342628,6079.7194234389481,6191.3138119077275,6305.1400881458812,6421.242889908799,6539.6677477069752,6660.4611026611155,6783.6703247143378,6909.3437312086244,7037.5306058327969]
[]
[]
[null,null,"Total",null,"$'000 AUD",null,null,null,{"$f":"-I64+I84","v":-1955},-2105,-2882,-4040,-2990,3706.6928639985599,3784.8267212785304,3864.5232557041018,3945.8137208181843,4028.7299952345475,4113.3045951392396,4199.5706870420236,4287.562100782864,4377.3133427985213,4468.8596096544916,4562.2368018475809,4657.4815378845333,4754.631168642225,4853.7237920150692,4954.7982678553708,5057.894233212478,5163.0521178767285,5270.3131602342628,5379.7194234389481,5491.3138119077275,5605.1400881458812,5721.242889908799,5839.6677477069752,5960.4611026611155,6083.6703247143378,6209.3437312086244,6337.5306058327969]
[]
[]
[null,{"$f":"SectionNumber","v":1.4000000000000004},"Option 4: New consolidated ADMS platform"]
[]
[]
[null,null,"NOT COSTED - identified as not a feasible option"]
[]
[]
[null,null,"Total",null,"$'000 AUD",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
["END"]

{"sheet":"Outputs","index":5,"n_rows":76,"n_cols":9,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))","v":"Outputs"},"Active Option"]
[]
[]
[]
[null,null,"Description","Constant","Unit"]
[]
[{"$f":"SectionNumber","v":1},null,"Control"]
[]
[null,null,"Active scenario",1]
[]
[]
[{"$f":"SectionNumber","v":2},null,"Summary of options analysis under active scenario"]
[]
[null,null,"WACC",{"$f":"Scen!$F$15","v":5.6099999999999997E-2}]
[null,null,"NPV Valuation period",{"$f":"Scen!$F$16","v":15}]
[]
[null,null,null,"NPV","NPC (capex & opex)","NPV Benefits"]
[null,null,"Optoin 1: Base case / counterfactual",0,0,0]
[null,null,"Option 2: GIS Upgrade",{"$f":"NPV($D$15,OFFSET('Options analysis'!I54,,,,$D$16-1))+'Options analysis'!I54","v":0},{"$f":"NPV($D$15,OFFSET('Options analysis'!I31,,,,$D$16-1))+'Options analysis'!I31","v":0},{"$f":"NPV($D$15,OFFSET('Options analysis'!I51,,,,$D$16-1))+'Options analysis'!I51","v":0}]
[null,null,"Option 3: Evolving OT capaibility enhancements",{"$f":"NPV($D$15,OFFSET('Options analysis'!I87,,,,$D$16-1))+'Options analysis'!I87","v":7421.8478453272182},{"$f":"NPV($D$15,OFFSET('Options analysis'!I64,,,,$D$16-1))+'Options analysis'!I64","v":17349.927943048395},{"$f":"NPV($D$15,OFFSET('Options analysis'!I84,,,,$D$16-1))+'Options analysis'!I84","v":24771.775788375617}]
[null,null,"Option 4: New consolidated ADMS platform",0,0,0]
[]
[null,null,null,"NPV (compared to Option 1)","BCR","Rank"]
[null,null,"Optoin 1: Base case / counterfactual",0,0,0]
[null,null,"Option 2: GIS Upgrade",{"$f":"D20-$D$19","v":0},{"$f":"IFERROR(F20/E20,0)","v":0},{"$f":"RANK(D26,$D$26:$D$27,0)","v":2}]
[null,null,"Option 3: Evolving OT capaibility enhancements",{"$f":"D21-$D$19","v":7421.8478453272182},{"$f":"F21/E21","v":1.4277739867098951},{"$f":"RANK(D27,$D$26:$D$27,0)","v":1}]
[null,null,"Option 4: New consolidated ADMS platform",0,0,0]
[]
[]
[{"$f":"SectionNumber","v":3},null,"Scenario analysis"]
[]
[]
[null,null,"NPV","Data table input formula",1,2,3,"Weighted outcome","Rank"]
[null,null,"Optoin 1: Base case / counterfactual",{"$f":"D25","v":0},0,0,0,{"$f":"SUMPRODUCT(E35:G35,$E$47:$G$47)","v":0},{"$f":"RANK(H35,$H$35:$H$38,0)","v":2}]
[null,null,"Option 2: GIS Upgrade",{"$f":"D26","v":0},0,0,0,{"$f":"SUMPRODUCT(E36:G36,$E$47:$G$47)","v":0},{"$f":"RANK(H36,$H$35:$H$38,0)","v":2}]
[null,null,"Option 3: Evolving OT capaibility enhancements",{"$f":"D27","v":7421.8478453272182},7421.8478453272182,964.11764525955732,57125.00550637862,{"$f":"SUMPRODUCT(E37:G37,$E$47:$G$47)","v":18233.204710573154},{"$f":"RANK(H37,$H$35:$H$38,0)","v":1}]
[null,null,"Option 4: New consolidated ADMS platform",{"$f":"D28","v":0},0,0,0,0,2]
[]
[]
[null,null,"BCR","Data table input formula",1,2,3,"Weighted outcome","Rank"]
[null,null,"Optoin 1: Base case / counterfactual",{"$f":"E25","v":0},0,0,0,{"$f":"SUMPRODUCT(E42:G42,$E$47:$G$47)","v":0},{"$f":"RANK(H42,$H$42:$H$45,0)","v":2}]
[null,null,"Option 2: GIS Upgrade",{"$f":"E26","v":0},0,0,0,{"$f":"SUMPRODUCT(E43:G43,$E$47:$G$47)","v":0},{"$f":"RANK(H43,$H$42:$H$45,0)","v":2}]
[null,null,"Option 3: Evolving OT capaibility enhancements",{"$f":"E27","v":1.4277739867098951},1.4277739867098951,1.0555689711464107,4.2925211962777592,{"$f":"SUMPRODUCT(E44:G44,$E$47:$G$47)","v":2.0509095352109901},1]
[null,null,"Option 4: New consolidated ADMS platform",0,0,0,0,0,2]
[]
[null,null,"Scenario weighting",null,0.5,0.25,0.25]
[]
[]
[{"$f":"SectionNumber","v":4},null,"Charts"]
[]
[null,null,"Value dimension","NPV"]
[null,null,"USE and avoidable outages",{"$f":"VLOOKUP(C53,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":37921.861170544427}]
[null,null,"SLA efficiency benefits",{"$f":"VLOOKUP(C54,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":4209.4485476065665}]
[null,null,"Benefits of UNM and data improvements",{"$f":"VLOOKUP(C55,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":1052.3621369016416}]
[null,null,"Value of lost load (Human error / switching error)",{"$f":"VLOOKUP(C56,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":344.94691858852963}]
[null,null,"Connection process non-compliance costs",{"$f":"VLOOKUP(C57,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":558.91681571844549}]
[null,null,"Capex field delivery efficiency cost",{"$f":"VLOOKUP(C58,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":1070.2662428651081}]
[null,null,"Value of safety risk",{"$f":"VLOOKUP(C59,'Benefits analysis'!$C$156:$F$162,4,FALSE)","v":2182.2645727497743}]
[]
[]
[null,null,"Waterfall chart items","Indicative cost for scale only"]
[null,null,"Quantified value",{"$f":"SUM(D53:D61)","v":47340.066404974496}]
[null,null,"Supported system",10000]
[null,null,"SOCI",5000]
[null,null,"BAU network management",2500]
[null,null,"Compliance (licence)",10000]
[null,null,"Key person risk",2500]
[]
[]
[]
[]
[]
[]
[]
["END"]

{"sheet":"Inputs","index":6,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Inputs"]

{"sheet":"Scen","index":7,"n_rows":98,"n_cols":18,"rows_kept":98,"cut":false,"hidden":false,"merged":[],"read":"row_number_cap"}
[]
[null,{"$f":" RIGHT(CELL(\"filename\", B2), LEN(CELL(\"filename\", B2)) - SEARCH(\"]\", CELL(\"filename\", B2)))","v":"Scen"},null,null,"Active Scenario"]
[]
[]
[]
[]
[null,null,null,null,"Active scenario",{"$f":"Outputs!$D$10","v":1},null,null,null,null,{"$f":"MATCH(F7,$L$7:$S$7,0)","v":2},null,1,2,3,4,5,6]
[null,null,null,null,"Comparison scenario",1,null,null,null,null,{"$f":"MATCH($F8,$L$7:$S$7,0)","v":2}]
[null,null,null,null,"Total comparison column differences",null,null,null,null,null,{"$f":"SUM(K12:K86)","v":0},null,"Expected case","Low growth, \nLow risk,\nLow benefit","High growth, \nHigh risk,\nHigh benefit"]
[]
[null,null,null,null,"Description","Constant","Unit","Comment"]
["start variable range"]
[]
[null,null,"Financial data"]
[null,null,null,null,"Discount rate",{"$f":"INDEX($L15:$S15,$K$7)","v":5.6099999999999997E-2},"%","AER draft determination",null,null,{"$f":" IFERROR(IF(ABS(F15 - INDEX(L15:S15,$K$8)) < 0.001, 0, 1),0)","v":0},null,5.6099999999999997E-2,5.6099999999999997E-2,5.6099999999999997E-2]
[null,null,null,null,"NPV valuation period",{"$f":"INDEX($L16:$S16,$K$7)","v":15},"yrs",null,null,null,{"$f":" IFERROR(IF(ABS(F16 - INDEX(L16:S16,$K$8)) < 0.001, 0, 1),0)","v":0},null,15,15,15]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F17 - INDEX(L17:S17,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,"Growth rate due to energy transistion/econcomic growth",{"$f":"INDEX($L18:$S18,$K$7)","v":0.02},"%",null,null,null,{"$f":" IFERROR(IF(ABS(F18 - INDEX(L18:S18,$K$8)) < 0.001, 0, 1),0)","v":0},null,0.02,0.01,0.03]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F19 - INDEX(L19:S19,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Power system modelling cost reduciton",null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F21 - INDEX(L21:S21,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,"Internal labour to validate models and data",{"$f":"INDEX($L22:$S22,$K$7)","v":50},"$'000 AUD",null,null,null,0,null,50,50,50]
[null,null,null,null,"Average annaul consultant costs",250,"$'000 AUD",null,null,null,0,null,250,250,250]
[null,null,null,null,"Percentage saving due to accurate model and data",{"$f":"INDEX($L24:$S24,$K$7)","v":0.2},"$'000 AUD",null,null,null,0,null,0.2,0.1,0.3]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Unknown network state (pin boards) - safety risk",null,null,null,null,null,null,null,0]
[null,null,null,null,"Probability method",{"$f":"INDEX($L27:$S27,$K$7)","v":2},"choice",null,null,null,0,null,2,2,1]
[null,null,null,null,"Probability of human error / switching error resulting in an outage",{"$f":"INDEX($L28:$S28,$K$7)","v":4.0000000000000001E-3},"%",null,null,null,0,null,4.0000000000000001E-3,2E-3,8.0000000000000002E-3]
[null,null,null,null,"Factor to adjust for activities not captured by current system",2,"factor",null,null,null,0,null,2,1,4]
[null,null,null,null,"Average annual switching events",1894,"#",null,null,null,0,null,1894,1894,1894]
[null,null,null,null,"Percentage avoided with base DMS and improved data",{"$f":"INDEX($L31:$S31,$K$7)","v":0.5},"%",null,null,null,0,null,0.5,{"$f":"M31*0.75","v":0.375},{"$f":"M31*1.25","v":0.625}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Connection process non-compliance costs",null,null,null,null,null,null,null,0]
[null,null,null,null,"Number of FIA per year",{"$f":"INDEX($L34:$S34,$K$7)","v":10},"#",null,null,null,0,null,10,5,15]
[null,null,null,null,"Non-compliance rate",{"$f":"INDEX($L35:$S35,$K$7)","v":0.25},"%",null,null,null,0,null,0.25,0.1,0.5]
[null,null,null,null,"Probability of incurring penalty",0.1,"%",null,null,null,{"$f":" IFERROR(IF(ABS(F36 - INDEX(L36:S36,$K$8)) < 0.001, 0, 1),0)","v":0},null,0.1,0.05,0.15]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Capital (field) efficiency improvement",null,null,null,null,null,null,null,0]
[null,null,null,null,"Number of distribution jobs schedule per year",{"$f":"INDEX($L39:$S39,$K$7)","v":443},"#",null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L39:S39,$K$8)) < 0.001, 0, 1),0)","v":0},null,443,443,443]
[null,null,null,null,"Percentage cancelled due to planning / notification / human error",{"$f":"INDEX($L40:$S40,$K$7)","v":0.02},"%",null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L40:S40,$K$8)) < 0.001, 0, 1),0)","v":0},null,0.02,0.01,0.03]
[null,null,null,null,"Average mobilisation cost per job - direct finanical cost to the work",10,"$'000 AUD",null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L41:S41,$K$8)) < 0.001, 0, 1),0)","v":0},null,10,5,15]
[null,null,null,null,"Proportion of distribution jobs requiring an outage",0.25,"%",null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L42:S42,$K$8)) < 0.001, 0, 1),0)","v":0},null,0.25,{"$f":"M42*0.75","v":0.1875},{"$f":"M42*1.25","v":0.3125}]
[null,null,null,null,"Percentage avoided with base DMS and improved data",0.25,"%",null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L43:S43,$K$8)) < 0.001, 0, 1),0)","v":0},null,0.25,{"$f":"M43*0.75","v":0.1875},{"$f":"M43*1.25","v":0.3125}]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L44:S44,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,"Human error / switching error resulting in outages",null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(#REF! - INDEX(L45:S45,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,"Annual average lost load",{"$f":"INDEX($L46:$S46,$K$7)","v":2.2139375000000001},"MWh",null,null,null,{"$f":" IFERROR(IF(ABS(F46 - INDEX(L46:S46,$K$8)) < 0.001, 0, 1),0)","v":0},null,2.2139375000000001,2.2139375000000001,4]
[null,null,null,null,"Customer weighted VCR",26.204000000000004,"$'000 per MWh",null,null,null,0,null,26.204000000000004,26.204000000000004,26.204000000000004]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Overall outage restoration efficiency - avoiding deterioration of reliabiliy",null,null,null,null,null,null,null,0]
[null,null,null,"Avoided deterioration in reliability",null,null,null,null,null,null,0]
[null,null,null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"INDEX($L51:$S51,$K$7)","v":424},"MWh",null,null,null,0,null,424,424,424]
[null,null,null,null,"Customer weighted VCR",26.204000000000004,"$ per MWh",null,null,null,0,null,26.204000000000004,26.204000000000004,26.204000000000004]
[null,null,null,null,"Forecast % avoided lost load / reliability deterioration",0.05,"%",null,null,null,0,null,0.05,0.05,0.08]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Major event day",null,null,null,null,null,null,0]
[null,null,null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"INDEX($L56:$S56,$K$7)","v":277},"MWh",null,null,null,0,null,277,277,277]
[null,null,null,null,"Customer weighted VCR",26.204000000000004,"$ per MWh",null,null,null,0,null,26.204000000000004,26.204000000000004,26.204000000000004]
[null,null,null,null,"Forecast % avoided lost load / reliability deterioration",0.1,"%",null,null,null,0,null,0.1,0.1,0.15]
[null,null,null,null,"Frequency",0.6,"%",null,null,null,0,null,0.6,0.5,0.7]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F60 - INDEX(L60:S60,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,"Cyclone/major storm condition reliability",null,null,null,null,null,null,0]
[null,null,null,null,"Average annaul Lost Load (Unserved Energy, USE)",{"$f":"INDEX($L62:$S62,$K$7)","v":6710},"MWh",null,null,null,0,null,6710,6710,6710]
[null,null,null,null,"Customer weighted VCR",26.204000000000004,"$ per MWh",null,null,null,0,null,26.204000000000004,26.204000000000004,26.204000000000004]
[null,null,null,null,"Forecast % avoided lost load / reliability deterioration",0.1,"%",null,null,null,0,null,0.1,0.1,0.15]
[null,null,null,null,"Frequency",0.125,"%",null,null,null,0,null,{"$f":"1/8","v":0.125},{"$f":"1/10","v":0.1},{"$f":"1/6","v":0.16666666666666666}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Efficiency in SC raised through reduced SLA costs",null,null,null,null,null,null,null,0]
[null,null,null,"Base DMS and improved data - make sure drawings represent normal state of the network",null,null,null,null,null,null,0]
[null,null,null,null,"Reduced drawing management and verification for pin up boards","[c-i-c]","$'000 AUD",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,"Annual standard FTE cost","[c-i-c]","%",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Pin board updates",null,null,null,null,null,null,0]
[null,null,null,null,"Number of FTEs required","[c-i-c]","#",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,"Annual standard FTE cost","[c-i-c]","$'000 AUD",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Switching and permitting process",null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F76 - INDEX(L76:S76,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,"Number of FTEs required","[c-i-c]","#",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,"Savings in effort ","[c-i-c]","%",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,"Annual standard FTE cost","[c-i-c]","$'000 AUD",null,null,null,0,null,"[c-i-c]","[c-i-c]","[c-i-c]"]
[null,null,null,null,"Total number of distribution jobs per year",{"$f":"INDEX($L80:$S80,$K$7)","v":1800},"#",null,null,null,0,null,1800,1800,1800]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["end variable range"]
[]
[null,null,null,null,"Scenario list"]
[null,null,null,null,{"$f":"TRANSPOSE(OFFSET($L$7,,1,,COUNT($L$7:$S$7)))","v":1}]
[null,null,null,null,2]
[null,null,null,null,3]
[null,null,null,null,4]
[null,null,null,null,5]
[null,null,null,null,6]
[]
[]
[]
[{"$f":"SectionNumber","v":1},null,"END"]

{"sheet":"Const","index":8,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["Energy at Risk "]
[]
[]
[]
[]
[{"$f":"SectionNumber","v":1},null,"General data"]
[]
[null,null,"Genreal data","Value"]
[null,null,"Start year","2024-07-01"]
[null,null,"Vlauation period",30]
[]
[]
[null,null,"Value of customer reliablity by category","Value","Unit"]
[null,null,"Residential",20.37,"$'000 AUD per MWh"]
[null,null,"Commercial",49.54,"$'000 AUD per MWh"]
[null,null,"Industrial",70.97,"$'000 AUD per MWh"]
[null,null,"Agricultural",42.14,"$'000 AUD per MWh"]
[null,null,"DKTL",{"$f":"SUMPRODUCT($D$15:$D$18,$D$23:$D$26)","v":26.204000000000004},"$'000 AUD per MWh"]
[null,null,"Source: Australian Energy Regulator, 2022 VCR Annual Adjustment, December 2022"]
[]
[null,null,"Percentage of customer types","Value","Unit"]
[null,null,"Residential",0.8,"%"]
[null,null,"Commercial",0.2,"%"]
[null,null,"Industrial",0,"%"]
[null,null,"Agricultural",0,"%"]
[null,null,"Source: Power Water GIS"]
[]
[{"$f":"SectionNumber","v":2},null,"Safety risk data"]
[]
[null,null,"Worker safety cost","VSL / VSLY","GDF","Litigation","Investigation","Total cost","Probability (LV assets)","Probability (estimate)"]
[null,null,"No consequence",0,3,0,0,{"$f":"D32*E32+F32+G32","v":0},0.91,0.99948016892066383]
[null,null,"Insignificant",4.8760000000000003,3,0,0,{"$f":"D33*E33+F33+G33","v":14.628},0.05,1.0153179889364922E-5]
[null,null,"Minor",15.19,3,15,15,75.569999999999993,0.01,2.0306359778729844E-5]
[null,null,"Moderate",54.25,3,100,15,277.75,5.0000000000000001E-3,3.0459539668094766E-5]
[null,null,"Major",1500,3,1000,50,5550,2E-3,1.1472799999999999E-4]
[null,null,"Severe",5000,3,10000,50,25050,1E-3,3.4418399999999998E-4]
[]
[null,null,"Worker safety cost","VSL / VSLY","GDF","Litigation","Investigation","Total cost","Probability (LV assets)","Probability (estimate)"]
[null,null,"No consequence",0,6,0,0,{"$f":"D40*E40+F40+G40","v":0},0.91,0.99948016892066383]
[null,null,"Insignificant",4.8760000000000003,6,0,0,{"$f":"D41*E41+F41+G41","v":29.256},0.05,1.0153179889364922E-5]
[null,null,"Minor",15.19,6,15,15,121.14,0.01,2.0306359778729844E-5]
[null,null,"Moderate",54.25,6,100,15,440.5,5.0000000000000001E-3,3.0459539668094766E-5]
[null,null,"Major",1500,6,1000,50,10050,2E-3,1.1472799999999999E-4]
[null,null,"Severe",5000,6,10000,50,40050,1E-3,3.4418399999999998E-4]
[]
[]
[{"$f":"SectionNumber","v":3},null,"Safety risk data"]
[]
[null,null,"Civil Penalties","Amount","Unit"]
[null,null,"Teir 1",188,"$'000 AUD"]
[null,null,"Teir 2",1500,"$'000 AUD"]
[null,null,"Teir 3",11000,"$'000 AUD"]
[]
[]
[]
[]
[{"$f":"SectionNumber","v":4},null,"END"]

{"sheet":"Time series","index":9,"n_rows":59,"n_cols":40,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Energy at Risk "]
[]
[]
[null,null,"Period commencing",null,"date",null,null,null,{"$f":"CHOOSE($E$21,I26,I33)","v":"2024-07-01"},"2025-07-01","2026-07-01","2027-07-01","2028-07-01","2029-07-01","2030-07-01","2031-07-01","2032-07-01","2033-07-01","2034-07-01","2035-07-01","2036-07-01","2037-07-01","2038-07-01","2039-07-01","2040-07-01","2041-07-01","2042-07-01","2043-07-01","2044-07-01","2045-07-01","2046-07-01","2047-07-01","2048-07-01","2049-07-01","2050-07-01","2051-07-01","2052-07-01","2053-07-01","2054-07-01","2055-07-01"]
[null,null,"Period ending",null,"date",null,null,null,{"$f":"CHOOSE($E$21,I27,I34)","v":"2025-06-30"},"2026-06-30","2027-06-30","2028-06-30","2029-06-30","2030-06-30","2031-06-30","2032-06-30","2033-06-30","2034-06-30","2035-06-30","2036-06-30","2037-06-30","2038-06-30","2039-06-30","2040-06-30","2041-06-30","2042-06-30","2043-06-30","2044-06-30","2045-06-30","2046-06-30","2047-06-30","2048-06-30","2049-06-30","2050-06-30","2051-06-30","2052-06-30","2053-06-30","2054-06-30","2055-06-30","2056-06-30"]
[null,null,"Period number",null,"number",null,null,null,{"$f":"CHOOSE($E$21,I28,I35)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,null,"Valuation period",null,"flag",null,null,null,{"$f":"CHOOSE($E$21,I29,I36)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0]
[]
[null,null,"Description","Constant","Unit"]
[]
[]
[]
[{"$f":"SectionNumber","v":1},null,"Time series"]
[]
[null,{"$f":"SectionNumber","v":1.1000000000000001},"From Const tab"]
[null,null,"Start year",{"$f":"Const!D10","v":"2024-07-01"},"Year"]
[null,null,"Period number"]
[null,null,"Valuation period",{"$f":"Const!D11","v":30},"Year"]
[null,null,{"$f":"Scen!E15","v":"Discount rate"},{"$f":"Scen!F15","v":5.6099999999999997E-2},{"$f":"Scen!G15","v":"%"}]
[null,null,"Financial year / Calendar year","Financial",2]
[]
[]
[]
[null,{"$f":"SectionNumber","v":1.2000000000000002},"Calendar year"]
[null,null,"Period commencing",null,"date",null,null,null,{"$f":"DATE(YEAR($D17)+I28-1,1,DAY($D17))","v":"2024-01-01"},"2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01","2047-01-01","2048-01-01","2049-01-01","2050-01-01","2051-01-01","2052-01-01","2053-01-01","2054-01-01","2055-01-01"]
[null,null,"Period ending",null,"date",null,null,null,{"$f":"DATE(YEAR($I26)+I28,MONTH($I26),DAY($I26)-1)","v":"2024-12-31"},{"$f":"DATE(YEAR($I26)+J28,MONTH($I26),DAY($I26)-1)","v":"2025-12-31"},"2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31","2031-12-31","2032-12-31","2033-12-31","2034-12-31","2035-12-31","2036-12-31","2037-12-31","2038-12-31","2039-12-31","2040-12-31","2041-12-31","2042-12-31","2043-12-31","2044-12-31","2045-12-31","2046-12-31","2047-12-31","2048-12-31","2049-12-31","2050-12-31","2051-12-31","2052-12-31","2053-12-31","2054-12-31","2055-12-31"]
[null,null,"Period number",null,"number",null,null,null,{"$f":"H28+1","v":1},{"$f":"I28+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,null,"Valuation period",null,"flag",null,null,null,{"$f":"IF(I28<=$D$19,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0]
[]
[]
[null,{"$f":"SectionNumber","v":1.3000000000000003},"Financial year"]
[null,null,"Period commencing",null,"date",null,null,null,{"$f":"DATE(YEAR($D17)+I35-1,MONTH($D17),DAY($D17))","v":"2024-07-01"},"2025-07-01","2026-07-01","2027-07-01","2028-07-01","2029-07-01","2030-07-01","2031-07-01","2032-07-01","2033-07-01","2034-07-01","2035-07-01","2036-07-01","2037-07-01","2038-07-01","2039-07-01","2040-07-01","2041-07-01","2042-07-01","2043-07-01","2044-07-01","2045-07-01","2046-07-01","2047-07-01","2048-07-01","2049-07-01","2050-07-01","2051-07-01","2052-07-01","2053-07-01","2054-07-01","2055-07-01"]
[null,null,"Period ending",null,"date",null,null,null,{"$f":"DATE(YEAR($I33)+I35,MONTH($I33),DAY($I33)-1)","v":"2025-06-30"},{"$f":"DATE(YEAR($I33)+J35,MONTH($I33),DAY($I33)-1)","v":"2026-06-30"},"2027-06-30","2028-06-30","2029-06-30","2030-06-30","2031-06-30","2032-06-30","2033-06-30","2034-06-30","2035-06-30","2036-06-30","2037-06-30","2038-06-30","2039-06-30","2040-06-30","2041-06-30","2042-06-30","2043-06-30","2044-06-30","2045-06-30","2046-06-30","2047-06-30","2048-06-30","2049-06-30","2050-06-30","2051-06-30","2052-06-30","2053-06-30","2054-06-30","2055-06-30","2056-06-30"]
[null,null,"Period number",null,"number",null,null,null,{"$f":"H35+1","v":1},{"$f":"I35+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,null,"Valuation period",null,"flag",null,null,null,{"$f":"IF(I35<=$D$19,1,0)","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SectionNumber","v":2},null,"END"]

{"sheet":"Supporting data","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Supporting data"]

{"sheet":"Sheet1","index":11,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Benefit type","Project area","Benefit","Incorported","How"]
["Compliance","GIS Upgrade (Out of Support GIS)","Failure to have a GIS will result in PWC not meeting its technical/safety obligations","No","Non quantified benefit"]
["Customers","OMS/DMS Enhancements & Remove Manual Pin Board","Enhanced information for consumers"]
["Data improvement","GIS Upgrade (Out of Support GIS)","Will allow implementation of any data improvement within GIS and key part of Unified Network Model","No","Non quantified benefit"]
["Data improvement","GIS Upgrade (Out of Support GIS)","Modelling non-network asset","No","Non quantified benefit"]
["Data improvement","Data Quality Improvements","Improved asset management  from better asset data","No","Non quantified benefit"]
["Data improvement","Enterprise Wide Common Information Model","Achieve a single definitive asset source view reducing risk of inconsistency","No","Non quantified benefit"]
["Data improvement","Enterprise Wide Common Information Model","Improves asset data inventory from definitive list","No","Non quantified benefit"]
["DER transition","Data Quality Improvements","Essential for confirming available hosting capacity","No","DOE business case??"]
["Data improvement","GIS Upgrade (Out of Support GIS)","Operational efficiencies from speed increases when editing GIS data","No","Non quantified benefit"]
["FTE efficiency","Data Quality Improvements","Efficiencies of avoided cancelled jobs with improved data","Yes","Higher mobilisation costs"]
["FTE efficiency - pin board","OMS/DMS Enhancements & Remove Manual Pin Board","Operator Inefficiencies with needing to manually pin the state of the network","Yes","Cost of labour"]
["FTE efficiency - pin board","OMS/DMS Enhancements & Remove Manual Pin Board","Challenge/Delay of undertaking manual pinning during a major event day","Yes","Cost of labour"]
["FTE efficiency - process","OMS/DMS Enhancements & Remove Manual Pin Board","Efficiency benefit from improved switching process","Yes","Cost of labour"]
["FTE efficiency - process","OMS/DMS Enhancements & Remove Manual Pin Board","Efficiency benefits from improved permitting processing","Yes","Cost of labour"]
["FTE efficiency / safety","OMS/DMS Enhancements & Remove Manual Pin Board","Inability to relocate Pin Board with state of the network in an emergency","No","Very low probability event. Not sure how to quantify wihtout double counting other safety risk"]
["ICT/Cyber","GIS Upgrade (Out of Support GIS)","Not operating a critical system without support( Used by many departments within PWC)","No","Non quantified benefit"]
["ICT/Cyber","GIS Upgrade (Out of Support GIS)","Improved Cyber security","No","Very low risk of cyber issue with pin board - this might actually be an increased risk with the new system"]
["ICT/Cyber","GIS Upgrade (Out of Support GIS)","Avoid increase in maintenance cost from unsupported software"]
["Key person","OMS/DMS Enhancements & Remove Manual Pin Board","In depth knowledge of network required for controllers to safely manage outages which put dependencies on key people"]
["Model","Unified Network Model ","Avoids multiple representation of the connectivity model that may be inconsistent (with safety and operational risks)","Yes","Improved modelling efficiency"]
["Model","Unified Network Model ","Single model to maintain rather than multiple models – Efficiency benefits","Yes","Improved modelling efficiency"]
["Model","Enterprise Wide Common Information Model","Efficiencies in maintaining a single common data model across the key system","Yes","Improved modelling efficiency"]
["Reliability","Data Quality Improvements","Used by OMS to provide faster restoration","Yes","reduction in USE"]
["Reliability","OMS/DMS Enhancements & Remove Manual Pin Board","Improves the restoration of outages relying on manual pinning","Yes","reduction in USE"]
["Reliability","OMS/DMS Enhancements & Remove Manual Pin Board","Reliability benefits to consumers from faster restoration","Yes","reduction in USE"]
["Safety","Data Quality Improvements","Key safety decision on operating the network require accurate data","Yes","quantified safety risk as per risk quantification procedure"]
["Safety","OMS/DMS Enhancements & Remove Manual Pin Board","Safety risk with field not able to see the pinned state of the network and more chance of an incorrect state of the network being assumed","Yes","quantified safety risk as per risk quantification procedure"]
["System","Unified Network Model ","Needed to allow the upgrade of GIS","No","Non quantified benefit"]
[]
[]
[]
[null,null,"Protection / fault level monitoring (managing operational restrictions) - qualitative only"]

{"sheet":"Sheet2","index":12,"n_rows":8,"n_cols":31,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Growth rates based on EV and underlying demand from Zubin - maybe for use instead of static 2% or 5% assumptions?"]
[]
["Electric vehicles",null,0.34742285082363061,2.1716048561608345,4.0374035396167463,5.945237901371188,7.8955186370438453,9.8886475028765233,11.925016656725679,14.005007974119362,16.128992338611976,27.134443433317337,38.378600418563281,49.863387701908636,61.590658690538888,73.562191340711834,85.779683544416216,98.2447483483122,110.95890899988753,123.92359381562478,137.14013086583341,160.17324100908814,183.65819735215584,207.59702360818187,231.9915325240278,256.84331485613842,282.15372796211926,307.92388399664333,334.15463769999997,360.84657376728239,387.9999937858866]
[null,null,null,{"$f":"D3/C3","v":6.2506103182696258},{"$f":"E3/D3","v":1.8591796422644056},1.4725399239966843,1.3280408232650962,1.2524379914045676,1.2059299973284308,1.1744225083510111,1.1516589186109456,1.6823396566665159,1.4143868663780912,1.2992497683107354,1.2351880112666587,1.1943725380552217,1.1660838534175477,1.1453148844672718,1.1294131326643451,1.1168422160292726,1.1066506921181802,1.1679531002182608,1.1466222210096577,1.1303444474635918,1.1175089531239526,1.1071236612031807,1.0985441770994022,1.0913337428523497,1.085185836716851,1.0798789933038311]
[]
[null,null,"FY22","FY23","FY24","FY25","FY26","FY27","FY28","FY29","FY30","FY31","FY32","FY33","FY34","FY35","FY36","FY37","FY38","FY39","FY40","FY41","FY42","FY43","FY44","FY45","FY46","FY47","FY48","FY49","FY50"]
["underlying demand growth",null,1415.9074228508237,1417.7316048561609,1419.5974035396166,1421.5052379013712,1423.4555186370437,1425.4486475028764,1427.4850166567255,1429.5650079741192,1431.688992338612,1442.6944434333172,1453.9386004185633,1465.4233877019085,1477.1506586905389,1489.1221913407119,1501.3396835444162,1513.8047483483122,1526.5189089998876,1539.4835938156248,1552.7001308658334,1575.733241009088,1599.2181973521558,1623.1570236081818,1647.5515325240278,1672.4033148561384,1697.7137279621193,1723.4838839966433,1749.7146376999999,1776.4065737672822,1803.5599937858865]
[null,null,0,{"$f":"D7/C7-1","v":1.2883483594319234E-3},{"$f":"E7/D7-1","v":1.3160450659805978E-3},1.3439263533432388E-3,1.3719827994105316E-3,1.4002045302694555E-3,1.4285812101448858E-3,1.4571020312810212E-3,1.4857557037597502E-3,7.687040379299237E-3,7.7938589397261726E-3,7.8990868528003855E-3,8.0026503514600833E-3,8.1044763983557644E-3,8.2044927372308951E-3,8.3026279399129876E-3,8.3988114487338894E-3,8.4929736142156376E-3,8.5850457278673353E-3,1.4834229536910382E-2,1.4904144770105932E-2,1.4969080701846549E-2,1.5029050523786447E-2,1.5084069809967016E-2,1.5134156265504739E-2,1.5179329477094772E-2,1.5219610665885286E-2,1.5255022443184663E-2]