{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover page","Summary","DCF Analysis","Options - Base Case","Options - Scenario","Scenarios","Inputs","Const","Opex costs","Capex - Option 1","Capex - Option 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,0,15,2],[14,0,14,2],[13,0,13,2]]}
[null,"Name","Net Present Cost ($m, AUD 2017)","Preferred option (least cost)","Increased cost compared to Preferred option"]
["Option 1","Greenfield replacement",null,{"$f":"IF(C2=MIN($C$2:$C$3),\"Yes\",\"No\")","v":"Yes"}]
["Option 3","AER solution plus future SB replacement",null,{"$f":"IF(C3=MIN($C$2:$C$3),\"Yes\",\"No\")","v":"Yes"}]
[]
[]
["Preferred year of replacement based on Value of Energy at Risk analysis"]
[2019]
[]
["Proposed replacement year based on resource and other implementaiton constraints and accepting risk"]
[2021]
[]
[]
["Model Legend (DCF Analysis)"]
["formulas in black text - use inputs from same sheet"]
["Green text means link to other sheet"]
["Blue text indicates it is an input for the data table scenario analysis"]
["Red text indicates hard coded values (Base case)"]
["Black highlight indicates cells which have been made confidential for the public version"]
[]
[]
["Model notes"]
["All values in real $'m 2018 AUD "]
["CPI not included, WACC excludes CPI"]

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

{"sheet":"Options - Base Case","index":3,"n_rows":72,"n_cols":42,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy at Risk "]
[]
[]
[null,null,null,null,{"$f":"Const!E15","v":"Base year (year commencing)"},{"$f":"Const!F15","v":"2017-07-01"},{"$f":"Const!G15","v":"date"},null,null,null,{"$f":"DATE(YEAR($F5)+K6,MONTH($F5),DAY($F5))","v":"2017-07-01"},{"$f":"DATE(YEAR($F5)+L6,MONTH($F5),DAY($F5))","v":"2018-07-01"},"2019-07-01","2020-07-01","2021-07-01","2022-07-01","2023-07-01","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"]
[null,null,null,null,"Period number",null,null,null,null,null,0,{"$f":"K6+1","v":1},{"$f":"L6+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]
[null,null,null,null,{"$f":"Const!E16","v":"Valuation period"},{"$f":"Const!F16","v":30},{"$f":"Const!G16","v":"years"},null,null,null,{"$f":"IF(K6<=$F$7,1,0)","v":1},{"$f":"IF(L6<=$F$7,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]
[null,null,null,null,{"$f":"Const!E17","v":"discount rate"},{"$f":"Const!F17","v":6.2399999999999997E-2},{"$f":"Const!G17","v":"%"},null,null,null,{"$f":"(1/(1+$F$8)^(K6))*K7","v":1},{"$f":"(1/(1+$F$8)^(L6))*L7","v":0.94126506024096379},0.88597991363042528,0.83394193677562622,0.78496040735657591,0.7388558051172589,0.69545915391308255,0.65461140240312732,0.61616284111740161,0.57997255376261436,0.54590790075547291,0.51384403309061832,0.48366343476150064,0.45525549205713545,0.42851608815618925,0.40334722153255759,0.37965664677386823,0.35735753649648744,0.33636816311792866,0.31661159932033944,0.29801543610724729,0.28051151742022523,0.26403569034283247,0.24852756997631065,0.23393031812529244,0.22019043498239121,0.20725756304818452,0.19508430256794473,0.18362603780868295,0.17284077353979946,0.16268898111803412,0]
[]
[null,null,null,null,"Description","Constant","Unit","Comment","Total"]
[]
[]
[]
[null,"Option 1 - Replace ZSS with greenfield construction"]
[]
[null,null,"Replacement year of transfomers based on E@R"]
[null,null,null,null,"Remediation year",2021,"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"Transformer replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,{"$f":"Const!$E$54","v":"Year -2"},{"$f":"Const!$F$54","v":0}]
[]
[null,null,null,"Substation operational expenditure"]
[null,null,null,null,"Opex flag"]
[null,null,null,null,"Transformer opex - current"]
[null,null,null,null,"Transformer opex - post replacement"]
[null,null,null,null,"Swichboard opex - current"]
[null,null,null,null,"Swichboard opex - post replacement"]
[]
[null,null,null,null,"Total (NPC of project)",null,"A$m FY17 Real"]
[]
[null,"Option 2 - AER solution plus future switchboard replacement"]
[]
[null,null,"Replacement year of transfomers based on E@R"]
[null,null,null,null,"Remediation year",2021,"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"Transformer replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,{"$f":"Const!$E$54","v":"Year -2"},{"$f":"Const!$F$54","v":0}]
[]
[null,null,"Replacement year of switchboard based on engineering assessment"]
[null,null,null,null,"Remediation year",null,"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"recoverable protection and control asset value (relay value, loss of labour and control wiring)"]
[null,null,null,null,"depresiated value",20]
[null,null,null,null,"switchboard replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,"depresiated value",1]
[]
[null,null,null,"Substaiton operational expenditure"]
[null,null,null,null,"Transformer opex flag"]
[null,null,null,null,"Transformer opex - current"]
[null,null,null,null,"Transformer opex - post replacement"]
[]
[null,null,null,null,"Switchboard opex flag"]
[null,null,null,null,"Swichboard opex - current"]
[null,null,null,null,"Swichboard opex - post replacement"]
[]
[null,null,null,null,"Total (NPC of project)",null,"A$m FY17 Real"]
[]
[]
[]
[null,"END"]

{"sheet":"Options - Scenario","index":4,"n_rows":74,"n_cols":42,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy at Risk "]
[]
[]
[null,null,null,null,{"$f":"Const!E15","v":"Base year (year commencing)"},{"$f":"Const!F15","v":"2017-07-01"},{"$f":"Const!G15","v":"date"},null,null,null,{"$f":"DATE(YEAR($F5)+K6,MONTH($F5),DAY($F5))","v":"2017-07-01"},{"$f":"DATE(YEAR($F5)+L6,MONTH($F5),DAY($F5))","v":"2018-07-01"},"2019-07-01","2020-07-01","2021-07-01","2022-07-01","2023-07-01","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"]
[null,null,null,null,"Period number",null,null,null,null,null,0,{"$f":"K6+1","v":1},{"$f":"L6+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]
[null,null,null,null,{"$f":"Const!E16","v":"Valuation period"},{"$f":"Const!F16","v":30},{"$f":"Const!G16","v":"years"},null,null,null,{"$f":"IF(K6<=$F$7,1,0)","v":1},{"$f":"IF(L6<=$F$7,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]
[null,null,null,null,{"$f":"Const!E17","v":"discount rate"},{"$f":"Const!F17","v":6.2399999999999997E-2},{"$f":"Const!G17","v":"%"},null,null,null,{"$f":"(1/(1+$F$8)^(K6))*K7","v":1},{"$f":"(1/(1+$F$8)^(L6))*L7","v":0.94126506024096379},0.88597991363042528,0.83394193677562622,0.78496040735657591,0.7388558051172589,0.69545915391308255,0.65461140240312732,0.61616284111740161,0.57997255376261436,0.54590790075547291,0.51384403309061832,0.48366343476150064,0.45525549205713545,0.42851608815618925,0.40334722153255759,0.37965664677386823,0.35735753649648744,0.33636816311792866,0.31661159932033944,0.29801543610724729,0.28051151742022523,0.26403569034283247,0.24852756997631065,0.23393031812529244,0.22019043498239121,0.20725756304818452,0.19508430256794473,0.18362603780868295,0.17284077353979946,0.16268898111803412,0]
[]
[null,null,null,null,"Description","Constant","Unit","Comment","Total"]
[]
[]
[]
[null,"Option 1 - Replace ZSS with greenfield construction"]
[]
[null,null,"Replacement year of transfomers based on E@R"]
[null,null,null,null,"Remediation year",{"$f":"Scenarios!B10","v":2021},"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"Transformer replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,{"$f":"Const!$E$54","v":"Year -2"},{"$f":"Const!$F$54","v":0}]
[]
[null,null,null,"Substaiton operational expenditure"]
[null,null,null,null,"Opex flag"]
[null,null,null,null,"Transformer opex - current"]
[null,null,null,null,"Transformer opex - post replacement"]
[null,null,null,null,"Swichboard opex - current"]
[null,null,null,null,"Swichboard opex - post replacement"]
[]
[null,null,null,null,"Total (NPC of project)",null,"A$m FY17 Real"]
[]
[]
[null,"Option 2 - AER solution plus future switchboard replacement"]
[]
[null,null,"Replacement year of transfomers based on E@R"]
[null,null,null,null,"Remediation year",{"$f":"Scenarios!B5","v":2021},"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"Transformer replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,{"$f":"Const!$E$54","v":"Year -2"},{"$f":"Const!$F$54","v":0}]
[]
[null,null,"Replacement year of switchboard based on engineering assessment"]
[null,null,null,null,"Remediation year",{"$f":"Scenarios!B11","v":2023},"year"]
[null,null,null,null,"Remediation 'in-service' flag"]
[]
[null,null,null,"Expenditure schedule"]
[null,null,null,null,"recoverable protection and control asset value (relay value, loss of labour and control wiring)"]
[null,null,null,null,"depreciated value"]
[null,null,null,null,"switchboard replacement cost",null,"$'M AUD 2018"]
[null,null,null,null,{"$f":"Const!$E$52","v":"Year 0"},{"$f":"Const!$F$52","v":0}]
[null,null,null,null,{"$f":"Const!$E$53","v":"Year -1"},{"$f":"Const!$F$53","v":0}]
[null,null,null,null,"depresiated value",1]
[]
[null,null,null,"Substaiton operational expenditure"]
[null,null,null,null,"Transformer opex flag"]
[null,null,null,null,"Transformer opex - current"]
[null,null,null,null,"Transformer opex - post replacement"]
[]
[null,null,null,null,"Switchboard opex flag"]
[null,null,null,null,"Swichboard opex - current"]
[null,null,null,null,"Swichboard opex - post replacement"]
[]
[null,null,null,null,"Total (NPC of project)",null,"A$m FY17 Real"]
[]
[]
[]
[]
[null,"END"]

{"sheet":"Scenarios","index":5,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[43,0,60,0],[41,2,41,10],[18,0,35,0]]}
["Scenario analysis on replacement timing"]
["Variables"]
[]
["Option 1 variables"]
["TF replacement year",2021]
["TF replacement cost"]
[]
[]
["Option 2 variables"]
["TF replacement year",2021]
["SB Replacement year",2023]
["TF replacement cost"]
["11kV switchboard capex"]
[]
["Scenario's run based on Options - Option 1"]
[]
[null,"Replacement year of Switchboard (vertical) impact on NPC"]
[]
["11kV Switchboard replacement year",2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[]
[]
["The table below shows it is only more cost effective to do a partial brown field replacement followed by switchboard replacement if the switchboard is replacedafter 2038 based on the expected costs"]
["Option 1 NPV"]
[]
[null,null,"Switchboard replacemnt capex ($'M)"]
[null,{"$f":"'Options - Scenario'!I69","v":0},4,{"$f":"C43+0.5","v":4.5},{"$f":"D43+0.5","v":5},5.5,6,6.5,7,7.5,8,8.5,9]
["11kV Switchboard replacement year",2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"END"]

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

{"sheet":"Const","index":7,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":" RIGHT(CELL(\"filename\", B2), LEN(CELL(\"filename\", B2)) - SEARCH(\"]\", CELL(\"filename\", B2)))","v":"Const"}]
[]
[]
[]
[]
[null,null,null,null,"Active scenario",1,null,null,null,null,{"$f":"MATCH($F7,$L$7:$N$7,0)","v":2},null,1]
[null,null,null,null,"Comparison scenario",1,null,null,null,null,{"$f":"MATCH($F8,$L$7:$N$7,0)","v":2}]
[null,null,null,null,"Total comparison column differences",null,null,null,null,null,{"$f":"SUM(K12:K62)","v":0},null,"Base case"]
[]
[null,null,null,null,"Description","Constant","Unit","Comment"]
["start range"]
[]
[null,null,"Financial data"]
[null,null,null,null,"Base year (year commencing)",{"$f":"INDEX($L15:$N15,$K$7)","v":"2017-07-01"},"date",null,null,null,{"$f":" IFERROR(IF(ABS(F15 - INDEX(L15:N15,$K$8)) < 0.001, 0, 1),0)","v":0},null,"2017-07-01"]
[null,null,null,null,"Valuation period",{"$f":"INDEX($L16:$N16,$K$7)","v":30},"years",null,null,null,0,null,30]
[null,null,null,null,"discount rate",{"$f":"INDEX($L17:$N17,$K$7)","v":6.2399999999999997E-2},"%",null,null,null,0,null,6.2399999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Value of customer reliability",null,null,null,null,null,null,null,0]
[null,null,null,null,"ASP",{"$f":"INDEX($L20:$N20,$K$7)","v":1.9E-2},"$m per MWh","2014 AEMO study ($33.46 per kWh for network average VCR) escalated to 2018 dollars",null,null,0,null,1.9E-2]
[null,null,null,null,"TC",{"$f":"INDEX($L21:$N21,$K$7)","v":1.9E-2},"$m per MWh","2014 AEMO study ($33.46 per kWh for network average VCR) escalated to 2018 dollars",null,null,0,null,1.9E-2]
[null,null,null,null,"KTH",{"$f":"INDEX($L22:$N22,$K$7)","v":2.9000000000000001E-2},"$m per MWh","2014 AEMO study ($33.46 per kWh for network average VCR) escalated to 2018 dollars",null,null,0,null,2.9000000000000001E-2]
[null,null,null,null,"DRW",{"$f":"INDEX($L23:$N23,$K$7)","v":3.9E-2},"$m per MWh","2014 AEMO study ($33.46 per kWh for network average VCR) escalated to 2018 dollars",null,null,0,null,3.9E-2]
[null,null,null,null,"Average",{"$f":"INDEX($L24:$N24,$K$7)","v":2.6500000000000003E-2},"$m per MWh","Estimate",null,null,0,null,{"$f":"AVERAGE(M20:M23)","v":2.6500000000000003E-2}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Outage duration",null,null,null,null,null,null,null,0]
[null,null,null,null,"Transformer outage duration as percentage of year",{"$f":"INDEX($L27:$N27,$K$7)","v":1},"%","not used",null,null,0,null,1]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Weibull Parameters",null,null,null,null,null,null,null,0]
[null,null,null,null,"Weibull shape factor",0,"factors","Estimated",null,null,0,null,0]
[null,null,null,null,"Weibull scale (mean life)",{"$f":"INDEX($L31:$N31,$K$7)","v":51.66777231087876},"years","Calculated",null,null,0,null,{"$f":"M42*M40+M41","v":51.66777231087876}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Perks Formula Parameters",null,null,null,null,"Source: in house data",null,null,0]
[null,null,null,null,"A",{"$f":"INDEX($L34:$N34,$K$7)","v":5.0000000000000001E-3},"factor",null,null,null,0,null,5.0000000000000001E-3]
[null,null,null,null,"b",{"$f":"INDEX($L35:$N35,$K$7)","v":0.16900000000000001},"factor",null,null,null,0,null,0.16900000000000001]
[null,null,null,null,"a",{"$f":"INDEX($L36:$N36,$K$7)","v":2.0010000000000001E-4},"factor",null,null,null,0,null,2.0010000000000001E-4]
[null,null,null,null,"µ",{"$f":"INDEX($L37:$N37,$K$7)","v":2.0000000000000001E-4},"factor",null,null,null,0,null,2.0000000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"DP Analysis",null,null,null,null,"Source: Tx DP Analysis and Characteristics.xlsx",null,null,0]
[null,null,null,null,"m",{"$f":"INDEX($L40:$N40,$K$7)","v":-4.4278848675560936E-2},"factor",null,null,null,0,null,-4.4278848675560936E-2]
[null,null,null,null,"c",{"$f":"INDEX($L41:$N41,$K$7)","v":60.523542045990943},"factor",null,null,null,0,null,60.523542045990943]
[null,null,null,null,"End of Life DP Value",{"$f":"INDEX($L42:$N42,$K$7)","v":200},"factor",null,null,null,0,null,200]
[null,null,null,null,"New Transformer DP",{"$f":"INDEX($L43:$N43,$K$7)","v":1200},"factor",null,null,null,0,null,1200]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Restoration parameters",null,null,null,null,null,null,null,0]
[null,null,null,null,"Restuaration time N-1",{"$f":"INDEX($L46:$N46,$K$7)","v":1},"months",null,null,null,0,null,1]
[null,null,null,null,"Restuaration time N-2",{"$f":"INDEX($L47:$N47,$K$7)","v":2},"months",null,null,null,0,null,2]
[null,null,null,null,"Restoration cost",{"$f":"INDEX($L48:$N48,$K$7)","v":1E-3},"$'m/MVAh",null,null,null,0,null,1E-3]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Expenditure S-Curve",null,null,null,null,null,null,null,0]
[null,null,null,null,"Year 0",null,null,null,null,null,0]
[null,null,null,null,"Year -1",null,null,null,null,null,0]
[null,null,null,null,"Year -2",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F55 - INDEX(L55:N55,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,"Annual opex costs",null,null,null,null,null,null,null,0]
[null,null,null,null,"Transformer opex - current",null,"$AUD 2017",null,null,null,0]
[null,null,null,null,"Transformer opex - post replacement",null,"$AUD 2017",null,null,null,0]
[null,null,null,null,"Swichboard opex - current",null,"$AUD 2017",null,null,null,0]
[null,null,null,null,"Swichboard opex - post replacement",null,"$AUD 2017",null,null,null,{"$f":" IFERROR(IF(ABS(F60 - INDEX(L60:N60,$K$8)) < 0.001, 0, 1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":" IFERROR(IF(ABS(F61 - INDEX(L61:N61,$K$8)) < 0.001, 0, 1),0)","v":0}]
["end range"]

{"sheet":"Opex costs","index":8,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Historical opex analysis"]
[]
["TF","denotes assets replaced as part of the transformer replacement"]
["SB","denotes assets replaced as part of the switchboard replacement"]
[]
["Berrimah actual costs"]
["Split","Asset Class","Sum of 2013/2014","Sum of 2014/2015","Sum of 2015/2016","Sum of 2016/2017","Average"]
["SB","Buildings"]
["SB","Cables"]
["TF","Capacitor Banks"]
["TF","Civil and Grounds"]
["SB","Communications"]
["TF","Customer"]
["SB","Fire Systems"]
["TF","GIS"]
["SB","11kV CBs"]
["TF","66kV CBs"]
["SB","HV Switchboards"]
["SB","Instrument Transformers"]
["SB","Multiple"]
["TF","Outdoor Disconnectors and Busbars"]
["TF","Power Transformers"]
["SB","Protection"]
["SB","SCADA"]
["SB","Substation Auxiliary Plant"]
["TF","Surge Arrestors"]
["SB","Unknown"]
[null,"Grand Total"]
[]
[null,"TF"]
[null,"SB"]
[]
[]
[]
["Opex for new substations of similar size"]
[null,"Asset Class","Sum of 2013/2014","Sum of 2014/2015","Sum of 2015/2016","Sum of 2016/2017","Average"]
["SB","Buildings"]
["SB","Cable Tunnels"]
["TF","Cables"]
["TF","Capacitor Banks"]
["TF","Civil and Grounds"]
["SB","Communications"]
["SB","Distribution Substations"]
["SB","Distribution Switchgear"]
["TF","Easements"]
["SB","Fire Systems"]
["TF","HV Circuit Breakers"]
["SB","HV Switchboards"]
["SB","Instrument Transformers"]
["TF","Multiple"]
["TF","Outdoor Disconnectors and Busbars"]
["TF","Poletops"]
["TF","Power Transformers"]
["SB","Protection"]
["SB","SCADA"]
["SB","Substation Auxiliary Plant"]
["SB","Unknown"]
[null,"Grand Total"]
[]
[null,"TF"]
[null,"SB"]

{"sheet":"Capex - Option 1","index":9,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,"Option 1"]
[null,"Greenfield replacement 38MVA"]
[]
["Item","Estimated Cost $’000 (P50)"]
["Design"]
["Functional/Concept"]
["Detailed"]
["Geotechnical"]
["Direct Costs"]
["Civil Works + Control Building"]
["11kV control building"]
["66kV Switchyard "]
["11kV switchboard"]
["66kV Protection Systems"]
["11kV Protection Systems"]
["66/11kV Power Transformers"]
["Auxiliary Systems "]
["RTU and Comms"]
["Cables"]
["Remote End Works"]
["Statutory Approvals"]
["Land Purchase"]
["Landscaping and Site Rehabilitation"]
["Spares"]
["Project Management"]
["External"]
["PWC"]
["Other PWC Costs"]
["Scada and Communications"]
["Testing and Commissioning"]
[]
[]
[]
["PWC - add cost back to AER ","Expenditure","Comments"]
["Item 1",null,"allowance for larger transformer, cables, CBs etc"]
["Item 2"]
["Total"]
[]
["Revised targeted brownfield cost"]
[]
["Amount spent to 2019 (Budget)"]
[]
["Total cost forOptions analysis"]
[]
["End"]

{"sheet":"Capex - Option 2","index":10,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"Option 2","Option 3"]
[null,"AER Option - targeted brown field","Brownfield now, 11kV switchboard later"]
[]
["Item","Estimated Cost $’000 (P50)","Estimated Cost $’000 (P50)"]
["Design"]
["Functional/Concept"]
["Detailed"]
["Geotechnical"]
["Direct Costs"]
["Civil Works + Control Building"]
["11kV control building"]
["66kV Switchyard "]
["11kV switchboard"]
["66kV Protection Systems"]
["11kV Protection Systems"]
["66/11kV Power Transformers"]
["Auxiliary Systems "]
["RTU and Comms"]
["Cables"]
["Remote End Works"]
["Statutory Approvals"]
["Land Purchase"]
["Landscaping and Site Rehabilitation"]
["Spares"]
["Project Management"]
["External"]
["PWC"]
["Other PWC Costs"]
["Scada and Communications"]
["Testing and Commissioning"]
[]
[]
[]
["AER Analysis","Expenditure","Comments"]
["Step #1",null,"Removed the amount forecast for expenditure in the 14-19 period."]
["Step #2",null,"Removed Civil Works and Building Structures as per the CAR"]
["Step #3",null,"Removed the provision for bus 1 and bus 2 in the 11 kV Switchboard as per the CAR"]
["Step #3",null,"Included an amount for spare transformer given the non-standard size of the Berrimah transformer"]
[]
["PWC - add cost back to AER "]
["Item 1",null,"Allowance for TF bunding and fire walls"]
["Item 2",null,"Decommissioning and reinstatement of civil works"]
["Item 3",null,"Increased labour for brownfield construction"]
["Item 4",null,"Sunk costs"]
["Item 5",null,"Reduction of allowance for spare transformer"]
["Total"]
[]
["Revised targeted brownfield cost"]
[]
["Amount spent to 2019 (Budget)"]
[]
["Total cost for Options analysis"]
[]
["End"]