{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Project_Input","DCF","NPV_Output","Sensitivity","Hidden"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":219,"comments":3,"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":"Project_Input","index":0,"n_rows":42,"n_cols":51,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,4,4,4],[3,5,4,5],[3,3,4,3],[3,2,4,2],[3,1,4,1],[3,37,3,43],[3,44,3,50],[3,18,4,18],[3,6,3,11],[3,19,3,23],[3,24,3,30],[3,31,3,36],[3,13,3,17]]}
[]
[null,"Project Input"]
[null,1,{"$f":"B3+1","v":2},{"$f":"C3+1","v":3},4,5,6,7,8,9,10,11,{"$f":"L3+1","v":12},{"$f":"M3+1","v":13},{"$f":"N3+1","v":14},{"$f":"O3+1","v":15},{"$f":"P3+1","v":16},{"$f":"Q3+1","v":17},{"$f":"R3+1","v":18},{"$f":"S3+1","v":19},{"$f":"T3+1","v":20},{"$f":"U3+1","v":21},{"$f":"V3+1","v":22},{"$f":"W3+1","v":23},{"$f":"X3+1","v":24},{"$f":"Y3+1","v":25},{"$f":"Z3+1","v":26},{"$f":"AA3+1","v":27},{"$f":"AB3+1","v":28},{"$f":"AC3+1","v":29},{"$f":"AD3+1","v":30},{"$f":"AE3+1","v":31},{"$f":"AF3+1","v":32},{"$f":"AG3+1","v":33},{"$f":"AH3+1","v":34},{"$f":"AI3+1","v":35},{"$f":"AJ3+1","v":36},{"$f":"AK3+1","v":37},{"$f":"AL3+1","v":38},{"$f":"AM3+1","v":39},{"$f":"AN3+1","v":40},{"$f":"AO3+1","v":41},{"$f":"AP3+1","v":42},{"$f":"AQ3+1","v":43},{"$f":"AR3+1","v":44},{"$f":"AS3+1","v":45},{"$f":"AT3+1","v":46},{"$f":"AU3+1","v":47},48,49,50]
[null,"Index","Stream","WR Description","Manager","DNSP","Capex Input",null,null,null,null,null,"O&M","Benefit Claim Ramping Up (% from 2026 to 2030)",null,null,null,null,"Additional Benefit Claim Period (No of Year beyond 2030)","Value of Customer Reliability (VCR) (Reliability)",null,null,null,null,"Financial",null,null,null,null,null,null,"Safety",null,null,null,null,null,"Environmental",null,null,null,null,null,null,"Other Inputs"]
[null,null,null,null,null,null,2026,{"$f":"G5+1","v":2027},{"$f":"H5+1","v":2028},2029,2030,"Total","As % of Capex",2026,{"$f":"N5+1","v":2027},{"$f":"O5+1","v":2028},{"$f":"P5+1","v":2029},{"$f":"Q5+1","v":2030},null,"Yes/No","Average Load (KWh)","Outage Duration (Hours Per Year)","Frequency of Event (%)","Comments","Yes/No","Labour Saving ($/Per Year)","Material Saving ($/Per Year)","Other Saving ($/Per Year)","Equipment Replacement Cost","Probability of Failure of Equipment (%)","Comments","Yes/No","Probability of Fatality (%)","Cost of Fatality ($)","Probability of Enjury (%)","Cost of Enjury ($)","Comments","Yes/No","Probability of Bushfire/Flood  (%)","Bushfire/Flood Cost($)","Probability of Oil Spilt (%)","Cost of Oil Split ($)","Carbon Reduction (in MWh)","Comments"]
[null,1,null,"Ergon AER Response",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,{"$f":"B6+1","v":2},"OT","Server & Workstation_ERG_1829387",null,"ERG",3620640,508517,0,0,0,{"$f":"SUM(G7:K7)","v":4129157},2.8044462949142384E-3,0.47388816991566046,0.89595694638954948,0.92985891058685444,0.96467144391085979,1,6,"Yes",2000,1,1,null,"Yes",null,null,{"$f":"384543.874628548*1","v":384543.87462854799},null,null,null,null,null,null,null,null,null,"No"]
[null,{"$f":"B7+1","v":3},"OT","STOR BACKUP_ERG_1829388",null,"ERG",null,null,752283.95962188172,310726.12516317161,214505.18220766695,1277515.2669927203,{"$f":"7.62263168415946%*2","v":0.1524526336831892},0.74131166318219299,0.84701665252436253,0.89688900489178125,0.9480905965513291,1,5,"Yes",2000,2,1,null,"Yes",null,null,{"$f":"245310.527011228*1","v":245310.527011228},null,null,null,null,null,null,null,null,null,"No"]
[null,4,"OT","Zetron Combined ERG (opt1) - Sept 2024",null,"ERG",125000,125000,125000,4255912.3687826656,125000,4755912.3687826656,6.4100000000000004E-2,2.1174750710691682E-2,0.65987712764575457,0.73597803000356077,0.85203739920467336,1,10,"Yes",3000,2.5,1,null,"Yes",null,null,519929.61572109937,null,null,null,null,null,null,null,null,null,"No"]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]

{"sheet":"DCF","index":1,"n_rows":50,"n_cols":71,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,31,2,36],[4,2,4,3],[2,2,2,3],[3,2,3,3],[2,10,2,14],[2,15,3,15],[2,16,2,19],[2,20,2,25],[2,26,2,30]]}
[null,"Discounted Cashflow Analysis","All $ in Real AUD2022"]
[]
[null,"Project Inedx",2,null,"Capex",null,null,null,null,"O&M","Benefit Claim Ramping Up (%)",null,null,null,null,"Benefit Claim Period (No of Year)",{"$f":"Project_Input!T4","v":"Value of Customer Reliability (VCR) (Reliability)"},null,null,null,{"$f":"Project_Input!Y4","v":"Financial"},null,null,null,null,null,{"$f":"Project_Input!AF4","v":"Safety"},null,null,null,null,{"$f":"Project_Input!AL4","v":"Environmental"}]
[null,"WR Description",{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!$D$3,FALSE)","v":"Server & Workstation_ERG_1829387"},null,2026,2027,2028,2029,2030,"As % of Capex",2026,{"$f":"K4+1","v":2027},{"$f":"L4+1","v":2028},2029,2030,null,{"$f":"Project_Input!T5","v":"Yes/No"},{"$f":"Project_Input!U5","v":"Average Load (KWh)"},{"$f":"Project_Input!V5","v":"Outage Duration (Hours Per Year)"},{"$f":"Project_Input!W5","v":"Frequency of Event (%)"},{"$f":"Project_Input!Y5","v":"Yes/No"},{"$f":"Project_Input!Z5","v":"Labour Saving ($/Per Year)"},{"$f":"Project_Input!AA5","v":"Material Saving ($/Per Year)"},{"$f":"Project_Input!AB5","v":"Other Saving ($/Per Year)"},{"$f":"Project_Input!AC5","v":"Equipment Replacement Cost"},{"$f":"Project_Input!AD5","v":"Probability of Failure of Equipment (%)"},{"$f":"Project_Input!AF5","v":"Yes/No"},{"$f":"Project_Input!AG5","v":"Probability of Fatality (%)"},{"$f":"Project_Input!AH5","v":"Cost of Fatality ($)"},{"$f":"Project_Input!AI5","v":"Probability of Enjury (%)"},{"$f":"Project_Input!AJ5","v":"Cost of Enjury ($)"},{"$f":"Project_Input!AL5","v":"Yes/No"},{"$f":"Project_Input!AM5","v":"Probability of Bushfire/Flood  (%)"},{"$f":"Project_Input!AN5","v":"Bushfire/Flood Cost($)"},{"$f":"Project_Input!AO5","v":"Probability of Oil Spilt (%)"},{"$f":"Project_Input!AP5","v":"Cost of Oil Split ($)"},{"$f":"Project_Input!AQ5","v":"Carbon Reduction (in MWh)"}]
[null,"DNSP",{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!$F$3,FALSE)","v":"ERG"},null,{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!G3,FALSE)","v":3620640},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!H3,FALSE)","v":508517},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!I3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!J3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!K3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!M3,FALSE)","v":2.8044462949142384E-3},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!N3,FALSE)","v":0.47388816991566046},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!O3,FALSE)","v":0.89595694638954948},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!P3,FALSE)","v":0.92985891058685444},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Q3,FALSE)","v":0.96467144391085979},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!R3,FALSE)","v":1},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!S3,FALSE)","v":6},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!T3,FALSE)","v":"Yes"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!U3,FALSE)","v":2000},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!V3,FALSE)","v":1},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!W3,FALSE)","v":1},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Y3,FALSE)","v":"Yes"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Z3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AA3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AB3,FALSE)","v":384543.87462854799},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AC3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AD3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AF3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AG3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AH3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AI3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AJ3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AL3,FALSE)","v":"No"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AM3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AN3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AO3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AP3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AQ3,FALSE)","v":0}]
[]
[null,"Year Index",null,null,0,1,{"$f":"F7+1","v":2},{"$f":"G7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$f":"Y7+1","v":21},{"$f":"Z7+1","v":22},{"$f":"AA7+1","v":23},{"$f":"AB7+1","v":24},{"$f":"AC7+1","v":25},{"$f":"AD7+1","v":26},{"$f":"AE7+1","v":27},{"$f":"AF7+1","v":28},{"$f":"AG7+1","v":29},{"$f":"AH7+1","v":30},{"$f":"AI7+1","v":31},{"$f":"AJ7+1","v":32},{"$f":"AK7+1","v":33},{"$f":"AL7+1","v":34},{"$f":"AM7+1","v":35},{"$f":"AN7+1","v":36},{"$f":"AO7+1","v":37},{"$f":"AP7+1","v":38},{"$f":"AQ7+1","v":39},{"$f":"AR7+1","v":40},{"$f":"AS7+1","v":41},{"$f":"AT7+1","v":42},{"$f":"AU7+1","v":43},{"$f":"AV7+1","v":44},{"$f":"AW7+1","v":45},{"$f":"AX7+1","v":46},{"$f":"AY7+1","v":47},{"$f":"AZ7+1","v":48},{"$f":"BA7+1","v":49},{"$f":"BB7+1","v":50},{"$f":"BC7+1","v":51},{"$f":"BD7+1","v":52},{"$f":"BE7+1","v":53},{"$f":"BF7+1","v":54},{"$f":"BG7+1","v":55},{"$f":"BH7+1","v":56},{"$f":"BI7+1","v":57},{"$f":"BJ7+1","v":58},{"$f":"BK7+1","v":59},{"$f":"BL7+1","v":60},{"$f":"BM7+1","v":61},{"$f":"BN7+1","v":62},{"$f":"BO7+1","v":63},{"$f":"BP7+1","v":64},{"$f":"BQ7+1","v":65},{"$f":"BR7+1","v":66}]
[null,"Financial Year",null,"Sum",{"$f":"Hidden!C3","v":2023},{"$f":"E8+1","v":2024},{"$f":"F8+1","v":2025},2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089]
[null,"Capex Start Flag",null,null,null,{"$f":"IF(F8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(G8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(H8=Hidden!$C$4,1,0)","v":1},{"$f":"IF(I8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(J8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(K8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(L8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(M8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(N8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(O8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(P8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(Q8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(R8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(S8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(T8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(U8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(V8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(W8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(X8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(Y8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(Z8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AA8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AB8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AC8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AD8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AE8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AF8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AG8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AH8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AI8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AJ8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AK8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AL8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AM8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AN8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AO8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AP8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AQ8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AR8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AS8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AT8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AU8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AV8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AW8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AX8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AY8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(AZ8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BA8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BB8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BC8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BD8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BE8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BF8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BG8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BH8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BI8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BJ8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BK8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BL8=Hidden!$C$4,1,0)","v":0},{"$f":"IF(BM8=Hidden!$C$4,1,0)","v":0}]
[null,"Capex",null,null,{"$f":"IFERROR(HLOOKUP(E8,Table_2,2,FALSE),0)","v":0},0,0,3620640,508517,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,"Capex (Accumulative)",null,null,null,{"$f":"F10+E11","v":0},{"$f":"G10+F11","v":0},3620640,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,4129157,{"$f":"AP10+AO11","v":4129157},{"$f":"AQ10+AP11","v":4129157},{"$f":"AR10+AQ11","v":4129157},{"$f":"AS10+AR11","v":4129157},{"$f":"AT10+AS11","v":4129157},{"$f":"AU10+AT11","v":4129157},{"$f":"AV10+AU11","v":4129157},{"$f":"AW10+AV11","v":4129157},{"$f":"AX10+AW11","v":4129157},{"$f":"AY10+AX11","v":4129157},{"$f":"AZ10+AY11","v":4129157},{"$f":"BA10+AZ11","v":4129157},{"$f":"BB10+BA11","v":4129157},{"$f":"BC10+BB11","v":4129157},{"$f":"BD10+BC11","v":4129157},{"$f":"BE10+BD11","v":4129157},{"$f":"BF10+BE11","v":4129157},{"$f":"BG10+BF11","v":4129157},{"$f":"BH10+BG11","v":4129157},{"$f":"BI10+BH11","v":4129157},{"$f":"BJ10+BI11","v":4129157},{"$f":"BK10+BJ11","v":4129157},{"$f":"BL10+BK11","v":4129157},{"$f":"BM10+BL11","v":4129157},{"$f":"BN10+BM11","v":4129157},{"$f":"BO10+BN11","v":4129157},{"$f":"BP10+BO11","v":4129157},{"$f":"BQ10+BP11","v":4129157},{"$f":"BR10+BQ11","v":4129157},{"$f":"BS10+BR11","v":4129157}]
[null,"Capex Finish (Accumulative)",null,null,null,{"$f":"IF(F11>=SUM($E$5:$I$5),1,0)","v":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,1,1,{"$f":"IF(AL11>=SUM($E$5:$I$5),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,1,1,{"$f":"IF(BR11>=SUM($E$5:$I$5),1,0)","v":1},1]
[null,"Benefit Ramping Up",null,null,null,0,0,{"$f":"K5","v":0.47388816991566046},{"$f":"L5","v":0.89595694638954948},0.92985891058685444,0.96467144391085979,1,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,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,"Benefit Start Flag",null,null,null,0,0,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,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,1,1]
[null,"Benefit Count",null,null,null,{"$f":"F14+E15","v":0},{"$f":"G14+F15","v":0},0,0,0,0,0,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,{"$f":"AP14+AO15","v":30},{"$f":"AQ14+AP15","v":31},{"$f":"AR14+AQ15","v":32},{"$f":"AS14+AR15","v":33},{"$f":"AT14+AS15","v":34},{"$f":"AU14+AT15","v":35},{"$f":"AV14+AU15","v":36},{"$f":"AW14+AV15","v":37},{"$f":"AX14+AW15","v":38},{"$f":"AY14+AX15","v":39},{"$f":"AZ14+AY15","v":40},{"$f":"BA14+AZ15","v":41},{"$f":"BB14+BA15","v":42},{"$f":"BC14+BB15","v":43},{"$f":"BD14+BC15","v":44},{"$f":"BE14+BD15","v":45},{"$f":"BF14+BE15","v":46},{"$f":"BG14+BF15","v":47},{"$f":"BH14+BG15","v":48},{"$f":"BI14+BH15","v":49},{"$f":"BJ14+BI15","v":50},{"$f":"BK14+BJ15","v":51},{"$f":"BL14+BK15","v":52},{"$f":"BM14+BL15","v":53},{"$f":"BN14+BM15","v":54},{"$f":"BO14+BN15","v":55},{"$f":"BP14+BO15","v":56},{"$f":"BQ14+BP15","v":57},{"$f":"BR14+BQ15","v":58},{"$f":"BS14+BR15","v":59}]
[null,"Benefit Sensitivity",null,null,null,{"$f":"IF(F11=0,0,Hidden!$C$6)","v":0},{"$f":"IF(G11=0,0,Hidden!$C$6)","v":0},1,1,1,{"$f":"IF(K11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(L11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(M11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(N11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(O11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(P11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(Q11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(R11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(S11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(T11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(U11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(V11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(W11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(X11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(Y11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(Z11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AA11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AB11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AC11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AD11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AE11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AF11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AG11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AH11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AI11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AJ11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AK11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AL11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AM11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AN11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AO11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AP11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AQ11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AR11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AS11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AT11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AU11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AV11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AW11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AX11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AY11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(AZ11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BA11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BB11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BC11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BD11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BE11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BF11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BG11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BH11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BI11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BJ11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BK11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BL11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BM11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BN11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BO11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BP11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BQ11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BR11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(BS11=0,0,Hidden!$C$6)","v":1}]
[null,"Benefit % to Be Applied",null,{"$f":"SUM(F17:BS17)","v":10.264375470802925},null,{"$f":"IF(F8<=2030,F13,IF(OR(F15=0,F15>$P$5),0,1))*F16","v":0},{"$f":"IF(G8<=2030,G13,IF(OR(G15=0,G15>$P$5),0,1))*G16","v":0},0.47388816991566046,0.89595694638954948,0.92985891058685444,0.96467144391085979,1,1,1,1,1,1,1,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(BS8<=2030,BS13,IF(OR(BS15=0,BS15>$P$5),0,1))*BS16","v":0}]
[null,"VCR Saving"]
[null,"Lost Energy","KWh",null,null,{"$f":"$R$5*$S$5*F17","v":0},0,947.77633983132091,1791.9138927790989,1859.7178211737089,1929.3428878217196,2000,2000,2000,2000,2000,2000,{"$f":"$R$5*$S$5*R17","v":2000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$R$5*$S$5*AL17","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,0,0]
[null,"Frequency of Event","%",null,null,{"$f":"$T$5*F17","v":0},0,0.47388816991566046,0.89595694638954948,0.92985891058685444,0.96467144391085979,1,1,1,1,1,1,{"$f":"$T$5*R17","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$T$5*AL17","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,0,0]
[null,"VCR","$/KWh",null,null,{"$f":"Hidden!$C$7*F$17","v":0},{"$f":"Hidden!$C$7*G$17","v":0},{"$f":"Hidden!$C$7*H$17","v":24.599534900321935},{"$f":"Hidden!$C$7*I$17","v":46.509125087081507},{"$f":"Hidden!$C$7*J$17","v":48.268976048563609},{"$f":"Hidden!$C$7*K$17","v":50.076094653412731},{"$f":"Hidden!$C$7*L$17","v":51.91},{"$f":"Hidden!$C$7*M$17","v":51.91},{"$f":"Hidden!$C$7*N$17","v":51.91},{"$f":"Hidden!$C$7*O$17","v":51.91},{"$f":"Hidden!$C$7*P$17","v":51.91},{"$f":"Hidden!$C$7*Q$17","v":51.91},{"$f":"Hidden!$C$7*R$17","v":51.91},{"$f":"Hidden!$C$7*S$17","v":0},{"$f":"Hidden!$C$7*T$17","v":0},{"$f":"Hidden!$C$7*U$17","v":0},{"$f":"Hidden!$C$7*V$17","v":0},{"$f":"Hidden!$C$7*W$17","v":0},{"$f":"Hidden!$C$7*X$17","v":0},{"$f":"Hidden!$C$7*Y$17","v":0},{"$f":"Hidden!$C$7*Z$17","v":0},{"$f":"Hidden!$C$7*AA$17","v":0},{"$f":"Hidden!$C$7*AB$17","v":0},{"$f":"Hidden!$C$7*AC$17","v":0},{"$f":"Hidden!$C$7*AD$17","v":0},{"$f":"Hidden!$C$7*AE$17","v":0},{"$f":"Hidden!$C$7*AF$17","v":0},{"$f":"Hidden!$C$7*AG$17","v":0},{"$f":"Hidden!$C$7*AH$17","v":0},{"$f":"Hidden!$C$7*AI$17","v":0},{"$f":"Hidden!$C$7*AJ$17","v":0},{"$f":"Hidden!$C$7*AK$17","v":0},{"$f":"Hidden!$C$7*AL$17","v":0},{"$f":"Hidden!$C$7*AM$17","v":0},{"$f":"Hidden!$C$7*AN$17","v":0},{"$f":"Hidden!$C$7*AO$17","v":0},{"$f":"Hidden!$C$7*AP$17","v":0},{"$f":"Hidden!$C$7*AQ$17","v":0},{"$f":"Hidden!$C$7*AR$17","v":0},{"$f":"Hidden!$C$7*AS$17","v":0},{"$f":"Hidden!$C$7*AT$17","v":0},{"$f":"Hidden!$C$7*AU$17","v":0},{"$f":"Hidden!$C$7*AV$17","v":0},{"$f":"Hidden!$C$7*AW$17","v":0},{"$f":"Hidden!$C$7*AX$17","v":0},{"$f":"Hidden!$C$7*AY$17","v":0},{"$f":"Hidden!$C$7*AZ$17","v":0},{"$f":"Hidden!$C$7*BA$17","v":0},{"$f":"Hidden!$C$7*BB$17","v":0},{"$f":"Hidden!$C$7*BC$17","v":0},{"$f":"Hidden!$C$7*BD$17","v":0},{"$f":"Hidden!$C$7*BE$17","v":0},{"$f":"Hidden!$C$7*BF$17","v":0},{"$f":"Hidden!$C$7*BG$17","v":0},{"$f":"Hidden!$C$7*BH$17","v":0},{"$f":"Hidden!$C$7*BI$17","v":0},{"$f":"Hidden!$C$7*BJ$17","v":0},{"$f":"Hidden!$C$7*BK$17","v":0},{"$f":"Hidden!$C$7*BL$17","v":0},{"$f":"Hidden!$C$7*BM$17","v":0},{"$f":"Hidden!$C$7*BN$17","v":0},{"$f":"Hidden!$C$7*BO$17","v":0},{"$f":"Hidden!$C$7*BP$17","v":0},{"$f":"Hidden!$C$7*BQ$17","v":0},{"$f":"Hidden!$C$7*BR$17","v":0},{"$f":"Hidden!$C$7*BS$17","v":0}]
[null,"Financial Saving"]
[null,"Labour Saving ","$",null,null,{"$f":"$V$5*F$17","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,{"$f":"$V$5*AL$17","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,0,0]
[null,"Material Saving ","$",null,null,{"$f":"$W$5*F$17","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,{"$f":"$W$5*AL$17","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,0,0]
[null,"Other Saving ","$",null,null,{"$f":"$X5*F$17","v":0},0,182230.79299999977,344534.7556649996,357571.54833494959,370958.49478499801,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X5*AL$17","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,0,0]
[null,"Replacement Cost Saving ","$",null,null,{"$f":"$Y5*$Z$5*F$17","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,{"$f":"$Y5*$Z$5*AL$17","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,0,0]
[null,"Safety Saving"]
[null,{"$f":"B27","v":"Safety Saving"},"$",null,null,{"$f":"F$17*($AC$5*$AB$5+$AE$5*$AD$5)","v":0},0,0,{"$f":"I$17*($AC$5*$AB$5+$AE$5*$AD$5)","v":0},{"$f":"J$17*($AC$5*$AB$5+$AE$5*$AD$5)","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,{"$f":"AL$17*($AC$5*$AB$5+$AE$5*$AD$5)","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,0,0]
[null,"Environmental Saving"]
[null,"Carbon Price","$/Ton",null,null,{"$f":"Carbon_Price*F$17","v":0},0,14.216645097469813,26.878708391686484,27.895767317605632,28.940143317325795,30,30,30,30,30,30,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Carbon_Price*AL$17","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,0,0]
[null,"Carbon","Ton",null,null,{"$f":"$AK$5*Hidden!$C$8*F$17","v":0},{"$f":"$AK$5*Hidden!$C$8*G$17","v":0},{"$f":"$AK$5*Hidden!$C$8*H$17","v":0},{"$f":"$AK$5*Hidden!$C$8*I$17","v":0},{"$f":"$AK$5*Hidden!$C$8*J$17","v":0},{"$f":"$AK$5*Hidden!$C$8*K$17","v":0},{"$f":"$AK$5*Hidden!$C$8*L$17","v":0},{"$f":"$AK$5*Hidden!$C$8*M$17","v":0},{"$f":"$AK$5*Hidden!$C$8*N$17","v":0},{"$f":"$AK$5*Hidden!$C$8*O$17","v":0},{"$f":"$AK$5*Hidden!$C$8*P$17","v":0},{"$f":"$AK$5*Hidden!$C$8*Q$17","v":0},{"$f":"$AK$5*Hidden!$C$8*R$17","v":0},{"$f":"$AK$5*Hidden!$C$8*S$17","v":0},{"$f":"$AK$5*Hidden!$C$8*T$17","v":0},{"$f":"$AK$5*Hidden!$C$8*U$17","v":0},{"$f":"$AK$5*Hidden!$C$8*V$17","v":0},{"$f":"$AK$5*Hidden!$C$8*W$17","v":0},{"$f":"$AK$5*Hidden!$C$8*X$17","v":0},{"$f":"$AK$5*Hidden!$C$8*Y$17","v":0},{"$f":"$AK$5*Hidden!$C$8*Z$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AA$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AB$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AC$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AD$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AE$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AF$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AG$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AH$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AI$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AJ$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AK$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AL$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AM$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AN$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AO$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AP$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AQ$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AR$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AS$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AT$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AU$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AV$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AW$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AX$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AY$17","v":0},{"$f":"$AK$5*Hidden!$C$8*AZ$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BA$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BB$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BC$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BD$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BE$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BF$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BG$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BH$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BI$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BJ$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BK$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BL$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BM$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BN$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BO$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BP$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BQ$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BR$17","v":0},{"$f":"$AK$5*Hidden!$C$8*BS$17","v":0}]
[null,"Carbon Reduction Saving","$",null,null,{"$f":"F31*F30","v":0},{"$f":"G31*G30","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,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,{"$f":"BS31*BS30","v":0}]
[null,"Bush Fire/Flood",null,null,null,{"$f":"$AH$5*$AG$5*F$17","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,{"$f":"$AH$5*$AG$5*AL$17","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,0,0]
[null,"Oil Spilt",null,null,null,{"$f":"$AJ$5*$AI$5*F$17","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,{"$f":"$AJ$5*$AI$5*AL$17","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,0,0]
[]
[null,"Cashflow Outflow"]
[null,"Capex",null,{"$f":"SUM(F37:BM37)","v":-4129157},null,{"$f":"IFERROR(-HLOOKUP(F8,Table_2,2,FALSE),0)","v":0},0,-3620640,-508517,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,{"$f":"IFERROR(-HLOOKUP(AL8,Table_2,2,FALSE),0)","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,0,0]
[null,"O&M",null,{"$f":"SUM(F38:BM38)","v":-173699.98574653789},null,{"$f":"-SUM($E$5:$I$5)*$J$5*F$17","v":0},{"$f":"-SUM($E$5:$I$5)*$J$5*G$17","v":0},{"$f":"-SUM($E$5:$I$5)*$J$5","v":-11579.999049769192},{"$f":"-SUM($E$5:$I$5)*$J$5","v":-11579.999049769192},{"$f":"-SUM($E$5:$I$5)*$J$5","v":-11579.999049769192},-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-SUM($E$5:$I$5)*$J$5*BS$17","v":0}]
[null,"Total Cashflow Outflow",null,-4302856.9857465345,null,{"$f":"SUM(F37:F38)","v":0},{"$f":"SUM(G37:G38)","v":0},-3632219.9990497692,-520096.99904976919,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AL37:AL38)","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]
[]
[null,"Cashflow Inflow (Benefit)",null,"Sum"]
[null,"VCR Saving",null,{"$f":"SUM(F42:BM42)","v":989129.0662003078},null,{"$f":"IF($Q$5=\"Yes\",F21*F20*F19,0)","v":0},0,11048.634986364721,74669.363153698767,83470.342592117042,93200.725468127275,103820,103820,103820,103820,103820,103820,103820,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($Q$5=\"Yes\",AL21*AL20*AL19,0)","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,0,0]
[null,"Financial Saving",null,{"$f":"SUM(F43:BM43)","v":3947102.7141847834},null,{"$f":"IF($U$5=\"Yes\",(F23+F24+F25+F26),0)","v":0},0,182230.79299999977,344534.7556649996,357571.54833494959,370958.49478499801,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,384543.87462854799,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($U$5=\"Yes\",(AL23+AL24+AL25+AL26),0)","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,0,0]
[null,"Safety Saving",null,0,null,{"$f":"IF($U$5=\"Yes\",F28,0)","v":0},0,0,{"$f":"IF($U$5=\"Yes\",I28,0)","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,{"$f":"IF($U$5=\"Yes\",AL28,0)","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,0,0]
[null,"Environmental Saving",null,0,null,{"$f":"IF($AA$5=\"Yes\",F32+F33+F34,0)","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,{"$f":"IF($AA$5=\"Yes\",AL32+AL33+AL34,0)","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,0,0]
[null,"Total Cashflow Inflow",null,{"$f":"SUM(F46:BM46)","v":4936231.78038509},null,{"$f":"SUM(F42:F45)","v":0},0,193279.42798636449,419204.11881869833,441041.89092706662,464159.2202531253,488363.87462854799,488363.87462854799,488363.87462854799,488363.87462854799,488363.87462854799,488363.87462854799,488363.87462854799,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BR42:BR45)","v":0},0]
[]
[null,"Net Cashflow",null,{"$f":"SUM(F48:BM48)","v":633374.77463855222},null,{"$f":"F39+F46-0.01","v":-0.01},{"$f":"G39+G46-0.01","v":-0.01},{"$f":"H39+H46","v":-3438940.5710634049},-100892.88023107086,429461.89187729743,452579.22120335611,476783.8755787788,476783.8755787788,476783.8755787788,476783.8755787788,476783.8755787788,476783.8755787788,476783.8755787788,-11579.999049769192,-11579.999049769192,-11579.999049769192,-11579.999049769192,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AN39+AN46","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,{"$f":"BN39+BN46","v":0},0,0,0,0,0]
[]
[null,"NPV",null,{"$f":"NPV(WACC,DCF!F48:BM48)","v":-115465.97472609166}]

{"sheet":"NPV_Output","index":2,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"R\"&ROW(Start_1)+Index_1*1-1&\"C\"&COLUMN(Start_1)","v":"R6C8"}]
[null,"NPV Summary",null,null,null,"WACC:",{"$f":"Hidden!C5","v":3.5000000000000003E-2}]
[]
[null,"Index","GT Stream","WR Description","GT Lvl 3 Managers","DNSP","Total Capex ","NPV"]
[null,1,{"$f":"IF(Project_Input!C6=0,\"\",Project_Input!C6)","v":""},{"$f":"IF(Project_Input!D6=0,\"\",Project_Input!D6)","v":"Ergon AER Response"},{"$f":"IF(Project_Input!E6=0,\"\",Project_Input!E6)","v":""},{"$f":"IF(Project_Input!F6=0,\"\",Project_Input!F6)","v":""},{"$f":"IF(Project_Input!L6<>\"\",Project_Input!L6,\"\")","v":""},-1.8996942752456305E-2]
[null,{"$f":"B5+1","v":2},{"$f":"IF(Project_Input!C7=0,\"\",Project_Input!C7)","v":"OT"},{"$f":"IF(Project_Input!D7=0,\"\",Project_Input!D7)","v":"Server & Workstation_ERG_1829387"},{"$f":"IF(Project_Input!E7=0,\"\",Project_Input!E7)","v":""},{"$f":"IF(Project_Input!F7=0,\"\",Project_Input!F7)","v":"ERG"},{"$f":"IF(Project_Input!L7<>\"\",Project_Input!L7,\"\")","v":4129157},-115465.97472609166]
[null,{"$f":"B6+1","v":3},{"$f":"IF(Project_Input!C8=0,\"\",Project_Input!C8)","v":"OT"},{"$f":"IF(Project_Input!D8=0,\"\",Project_Input!D8)","v":"STOR BACKUP_ERG_1829388"},{"$f":"IF(Project_Input!E8=0,\"\",Project_Input!E8)","v":""},{"$f":"IF(Project_Input!F8=0,\"\",Project_Input!F8)","v":"ERG"},{"$f":"IF(Project_Input!L8<>\"\",Project_Input!L8,\"\")","v":1277515.2669927203},-9454.1988352567278]
[null,4,{"$f":"IF(Project_Input!C9=0,\"\",Project_Input!C9)","v":"OT"},{"$f":"IF(Project_Input!D9=0,\"\",Project_Input!D9)","v":"Zetron Combined ERG (opt1) - Sept 2024"},{"$f":"IF(Project_Input!E9=0,\"\",Project_Input!E9)","v":""},{"$f":"IF(Project_Input!F9=0,\"\",Project_Input!F9)","v":"ERG"},{"$f":"IF(Project_Input!L9<>\"\",Project_Input!L9,\"\")","v":4755912.3687826656},908780.68120789609]
[null,5,{"$f":"IF(Project_Input!C10=0,\"\",Project_Input!C10)","v":""},{"$f":"IF(Project_Input!D10=0,\"\",Project_Input!D10)","v":""},{"$f":"IF(Project_Input!E10=0,\"\",Project_Input!E10)","v":""},{"$f":"IF(Project_Input!F10=0,\"\",Project_Input!F10)","v":""},{"$f":"IF(Project_Input!L10<>\"\",Project_Input!L10,\"\")","v":""},-1.8996942752456305E-2]
[null,6,{"$f":"IF(Project_Input!C11=0,\"\",Project_Input!C11)","v":""},{"$f":"IF(Project_Input!D11=0,\"\",Project_Input!D11)","v":""},{"$f":"IF(Project_Input!E11=0,\"\",Project_Input!E11)","v":""},{"$f":"IF(Project_Input!F11=0,\"\",Project_Input!F11)","v":""},{"$f":"IF(Project_Input!L11<>\"\",Project_Input!L11,\"\")","v":""},-1.8996942752456305E-2]
[null,7,{"$f":"IF(Project_Input!C12=0,\"\",Project_Input!C12)","v":""},{"$f":"IF(Project_Input!D12=0,\"\",Project_Input!D12)","v":""},{"$f":"IF(Project_Input!E12=0,\"\",Project_Input!E12)","v":""},{"$f":"IF(Project_Input!F12=0,\"\",Project_Input!F12)","v":""},{"$f":"IF(Project_Input!L12<>\"\",Project_Input!L12,\"\")","v":""},-1.8996942752456305E-2]
[null,8,{"$f":"IF(Project_Input!C13=0,\"\",Project_Input!C13)","v":""},{"$f":"IF(Project_Input!D13=0,\"\",Project_Input!D13)","v":""},{"$f":"IF(Project_Input!E13=0,\"\",Project_Input!E13)","v":""},{"$f":"IF(Project_Input!F13=0,\"\",Project_Input!F13)","v":""},{"$f":"IF(Project_Input!L13<>\"\",Project_Input!L13,\"\")","v":""},-1.8996942752456305E-2]
[null,9,{"$f":"IF(Project_Input!C14=0,\"\",Project_Input!C14)","v":""},{"$f":"IF(Project_Input!D14=0,\"\",Project_Input!D14)","v":""},{"$f":"IF(Project_Input!E14=0,\"\",Project_Input!E14)","v":""},{"$f":"IF(Project_Input!F14=0,\"\",Project_Input!F14)","v":""},{"$f":"IF(Project_Input!L14<>\"\",Project_Input!L14,\"\")","v":""},-1.8996942752456305E-2]
[null,10,{"$f":"IF(Project_Input!C15=0,\"\",Project_Input!C15)","v":""},{"$f":"IF(Project_Input!D15=0,\"\",Project_Input!D15)","v":""},{"$f":"IF(Project_Input!E15=0,\"\",Project_Input!E15)","v":""},{"$f":"IF(Project_Input!F15=0,\"\",Project_Input!F15)","v":""},{"$f":"IF(Project_Input!L15<>\"\",Project_Input!L15,\"\")","v":""},-1.8996942752456305E-2]
[null,11,{"$f":"IF(Project_Input!C16=0,\"\",Project_Input!C16)","v":""},{"$f":"IF(Project_Input!D16=0,\"\",Project_Input!D16)","v":""},{"$f":"IF(Project_Input!E16=0,\"\",Project_Input!E16)","v":""},{"$f":"IF(Project_Input!F16=0,\"\",Project_Input!F16)","v":""},{"$f":"IF(Project_Input!L16<>\"\",Project_Input!L16,\"\")","v":""},-1.8996942752456305E-2]
[null,12,{"$f":"IF(Project_Input!C17=0,\"\",Project_Input!C17)","v":""},{"$f":"IF(Project_Input!D17=0,\"\",Project_Input!D17)","v":""},{"$f":"IF(Project_Input!E17=0,\"\",Project_Input!E17)","v":""},{"$f":"IF(Project_Input!F17=0,\"\",Project_Input!F17)","v":""},{"$f":"IF(Project_Input!L17<>\"\",Project_Input!L17,\"\")","v":""},-1.8996942752456305E-2]
[null,13,{"$f":"IF(Project_Input!C18=0,\"\",Project_Input!C18)","v":""},{"$f":"IF(Project_Input!D18=0,\"\",Project_Input!D18)","v":""},{"$f":"IF(Project_Input!E18=0,\"\",Project_Input!E18)","v":""},{"$f":"IF(Project_Input!F18=0,\"\",Project_Input!F18)","v":""},{"$f":"IF(Project_Input!L18<>\"\",Project_Input!L18,\"\")","v":""},-1.8996942752456305E-2]
[null,14,{"$f":"IF(Project_Input!C19=0,\"\",Project_Input!C19)","v":""},{"$f":"IF(Project_Input!D19=0,\"\",Project_Input!D19)","v":""},{"$f":"IF(Project_Input!E19=0,\"\",Project_Input!E19)","v":""},{"$f":"IF(Project_Input!F19=0,\"\",Project_Input!F19)","v":""},{"$f":"IF(Project_Input!L19<>\"\",Project_Input!L19,\"\")","v":""},-1.8996942752456305E-2]
[null,15,{"$f":"IF(Project_Input!C20=0,\"\",Project_Input!C20)","v":""},{"$f":"IF(Project_Input!D20=0,\"\",Project_Input!D20)","v":""},{"$f":"IF(Project_Input!E20=0,\"\",Project_Input!E20)","v":""},{"$f":"IF(Project_Input!F20=0,\"\",Project_Input!F20)","v":""},{"$f":"IF(Project_Input!L20<>\"\",Project_Input!L20,\"\")","v":""},-1.8996942752456305E-2]
[null,16,{"$f":"IF(Project_Input!C21=0,\"\",Project_Input!C21)","v":""},{"$f":"IF(Project_Input!D21=0,\"\",Project_Input!D21)","v":""},{"$f":"IF(Project_Input!E21=0,\"\",Project_Input!E21)","v":""},{"$f":"IF(Project_Input!F21=0,\"\",Project_Input!F21)","v":""},{"$f":"IF(Project_Input!L21<>\"\",Project_Input!L21,\"\")","v":""},-1.8996942752456305E-2]
[null,17,{"$f":"IF(Project_Input!C22=0,\"\",Project_Input!C22)","v":""},{"$f":"IF(Project_Input!D22=0,\"\",Project_Input!D22)","v":""},{"$f":"IF(Project_Input!E22=0,\"\",Project_Input!E22)","v":""},{"$f":"IF(Project_Input!F22=0,\"\",Project_Input!F22)","v":""},{"$f":"IF(Project_Input!L22<>\"\",Project_Input!L22,\"\")","v":""},-1.8996942752456305E-2]
[null,18,{"$f":"IF(Project_Input!C23=0,\"\",Project_Input!C23)","v":""},{"$f":"IF(Project_Input!D23=0,\"\",Project_Input!D23)","v":""},{"$f":"IF(Project_Input!E23=0,\"\",Project_Input!E23)","v":""},{"$f":"IF(Project_Input!F23=0,\"\",Project_Input!F23)","v":""},{"$f":"IF(Project_Input!L23<>\"\",Project_Input!L23,\"\")","v":""},-1.8996942752456305E-2]
[null,19,{"$f":"IF(Project_Input!C24=0,\"\",Project_Input!C24)","v":""},{"$f":"IF(Project_Input!D24=0,\"\",Project_Input!D24)","v":""},{"$f":"IF(Project_Input!E24=0,\"\",Project_Input!E24)","v":""},{"$f":"IF(Project_Input!F24=0,\"\",Project_Input!F24)","v":""},{"$f":"IF(Project_Input!L24<>\"\",Project_Input!L24,\"\")","v":""},-1.8996942752456305E-2]
[null,20,{"$f":"IF(Project_Input!C25=0,\"\",Project_Input!C25)","v":""},{"$f":"IF(Project_Input!D25=0,\"\",Project_Input!D25)","v":""},{"$f":"IF(Project_Input!E25=0,\"\",Project_Input!E25)","v":""},{"$f":"IF(Project_Input!F25=0,\"\",Project_Input!F25)","v":""},{"$f":"IF(Project_Input!L25<>\"\",Project_Input!L25,\"\")","v":""},-1.8996942752456305E-2]
[null,21,{"$f":"IF(Project_Input!C26=0,\"\",Project_Input!C26)","v":""},{"$f":"IF(Project_Input!D26=0,\"\",Project_Input!D26)","v":""},{"$f":"IF(Project_Input!E26=0,\"\",Project_Input!E26)","v":""},{"$f":"IF(Project_Input!F26=0,\"\",Project_Input!F26)","v":""},{"$f":"IF(Project_Input!L26<>\"\",Project_Input!L26,\"\")","v":""},-1.8996942752456305E-2]
[null,22,{"$f":"IF(Project_Input!C27=0,\"\",Project_Input!C27)","v":""},{"$f":"IF(Project_Input!D27=0,\"\",Project_Input!D27)","v":""},{"$f":"IF(Project_Input!E27=0,\"\",Project_Input!E27)","v":""},{"$f":"IF(Project_Input!F27=0,\"\",Project_Input!F27)","v":""},{"$f":"IF(Project_Input!L27<>\"\",Project_Input!L27,\"\")","v":""},-1.8996942752456305E-2]
[null,23,{"$f":"IF(Project_Input!C28=0,\"\",Project_Input!C28)","v":""},{"$f":"IF(Project_Input!D28=0,\"\",Project_Input!D28)","v":""},{"$f":"IF(Project_Input!E28=0,\"\",Project_Input!E28)","v":""},{"$f":"IF(Project_Input!F28=0,\"\",Project_Input!F28)","v":""},{"$f":"IF(Project_Input!L28<>\"\",Project_Input!L28,\"\")","v":""},-1.8996942752456305E-2]
[null,24,{"$f":"IF(Project_Input!C29=0,\"\",Project_Input!C29)","v":""},{"$f":"IF(Project_Input!D29=0,\"\",Project_Input!D29)","v":""},{"$f":"IF(Project_Input!E29=0,\"\",Project_Input!E29)","v":""},{"$f":"IF(Project_Input!F29=0,\"\",Project_Input!F29)","v":""},{"$f":"IF(Project_Input!L29<>\"\",Project_Input!L29,\"\")","v":""},-1.8996942752456305E-2]
[null,25,{"$f":"IF(Project_Input!C30=0,\"\",Project_Input!C30)","v":""},{"$f":"IF(Project_Input!D30=0,\"\",Project_Input!D30)","v":""},{"$f":"IF(Project_Input!E30=0,\"\",Project_Input!E30)","v":""},{"$f":"IF(Project_Input!F30=0,\"\",Project_Input!F30)","v":""},{"$f":"IF(Project_Input!L30<>\"\",Project_Input!L30,\"\")","v":""},-1.8996942752456305E-2]
[null,26,{"$f":"IF(Project_Input!C31=0,\"\",Project_Input!C31)","v":""},{"$f":"IF(Project_Input!D31=0,\"\",Project_Input!D31)","v":""},{"$f":"IF(Project_Input!E31=0,\"\",Project_Input!E31)","v":""},{"$f":"IF(Project_Input!F31=0,\"\",Project_Input!F31)","v":""},{"$f":"IF(Project_Input!L31<>\"\",Project_Input!L31,\"\")","v":""},-1.8996942752456305E-2]
[null,27,{"$f":"IF(Project_Input!C32=0,\"\",Project_Input!C32)","v":""},{"$f":"IF(Project_Input!D32=0,\"\",Project_Input!D32)","v":""},{"$f":"IF(Project_Input!E32=0,\"\",Project_Input!E32)","v":""},{"$f":"IF(Project_Input!F32=0,\"\",Project_Input!F32)","v":""},{"$f":"IF(Project_Input!L32<>\"\",Project_Input!L32,\"\")","v":""},-1.8996942752456305E-2]
[null,28,{"$f":"IF(Project_Input!C33=0,\"\",Project_Input!C33)","v":""},{"$f":"IF(Project_Input!D33=0,\"\",Project_Input!D33)","v":""},{"$f":"IF(Project_Input!E33=0,\"\",Project_Input!E33)","v":""},{"$f":"IF(Project_Input!F33=0,\"\",Project_Input!F33)","v":""},{"$f":"IF(Project_Input!L33<>\"\",Project_Input!L33,\"\")","v":""},-1.8996942752456305E-2]
[null,29,{"$f":"IF(Project_Input!C34=0,\"\",Project_Input!C34)","v":""},{"$f":"IF(Project_Input!D34=0,\"\",Project_Input!D34)","v":""},{"$f":"IF(Project_Input!E34=0,\"\",Project_Input!E34)","v":""},{"$f":"IF(Project_Input!F34=0,\"\",Project_Input!F34)","v":""},{"$f":"IF(Project_Input!L34<>\"\",Project_Input!L34,\"\")","v":""},-1.8996942752456305E-2]
[null,30,{"$f":"IF(Project_Input!C35=0,\"\",Project_Input!C35)","v":""},{"$f":"IF(Project_Input!D35=0,\"\",Project_Input!D35)","v":""},{"$f":"IF(Project_Input!E35=0,\"\",Project_Input!E35)","v":""},{"$f":"IF(Project_Input!F35=0,\"\",Project_Input!F35)","v":""},{"$f":"IF(Project_Input!L35<>\"\",Project_Input!L35,\"\")","v":""},-1.8996942752456305E-2]
[null,31,{"$f":"IF(Project_Input!C36=0,\"\",Project_Input!C36)","v":""},{"$f":"IF(Project_Input!D36=0,\"\",Project_Input!D36)","v":""},{"$f":"IF(Project_Input!E36=0,\"\",Project_Input!E36)","v":""},{"$f":"IF(Project_Input!F36=0,\"\",Project_Input!F36)","v":""},{"$f":"IF(Project_Input!L36<>\"\",Project_Input!L36,\"\")","v":""},-1.8996942752456305E-2]
[null,32,{"$f":"IF(Project_Input!C37=0,\"\",Project_Input!C37)","v":""},{"$f":"IF(Project_Input!D37=0,\"\",Project_Input!D37)","v":""},{"$f":"IF(Project_Input!E37=0,\"\",Project_Input!E37)","v":""},{"$f":"IF(Project_Input!F37=0,\"\",Project_Input!F37)","v":""},{"$f":"IF(Project_Input!L37<>\"\",Project_Input!L37,\"\")","v":""},-1.8996942752456305E-2]
[null,33,{"$f":"IF(Project_Input!C38=0,\"\",Project_Input!C38)","v":""},{"$f":"IF(Project_Input!D38=0,\"\",Project_Input!D38)","v":""},{"$f":"IF(Project_Input!E38=0,\"\",Project_Input!E38)","v":""},{"$f":"IF(Project_Input!F38=0,\"\",Project_Input!F38)","v":""},{"$f":"IF(Project_Input!L38<>\"\",Project_Input!L38,\"\")","v":""},-1.8996942752456305E-2]
[null,34,{"$f":"IF(Project_Input!C39=0,\"\",Project_Input!C39)","v":""},{"$f":"IF(Project_Input!D39=0,\"\",Project_Input!D39)","v":""},{"$f":"IF(Project_Input!E39=0,\"\",Project_Input!E39)","v":""},{"$f":"IF(Project_Input!F39=0,\"\",Project_Input!F39)","v":""},{"$f":"IF(Project_Input!L39<>\"\",Project_Input!L39,\"\")","v":""},-1.8996942752456305E-2]
[null,35,{"$f":"IF(Project_Input!C40=0,\"\",Project_Input!C40)","v":""},{"$f":"IF(Project_Input!D40=0,\"\",Project_Input!D40)","v":""},{"$f":"IF(Project_Input!E40=0,\"\",Project_Input!E40)","v":""},{"$f":"IF(Project_Input!F40=0,\"\",Project_Input!F40)","v":""},{"$f":"IF(Project_Input!L40<>\"\",Project_Input!L40,\"\")","v":""},-1.8996942752456305E-2]
[null,36,{"$f":"IF(Project_Input!C41=0,\"\",Project_Input!C41)","v":""},{"$f":"IF(Project_Input!D41=0,\"\",Project_Input!D41)","v":""},{"$f":"IF(Project_Input!E41=0,\"\",Project_Input!E41)","v":""},{"$f":"IF(Project_Input!F41=0,\"\",Project_Input!F41)","v":""},{"$f":"IF(Project_Input!L41<>\"\",Project_Input!L41,\"\")","v":""}]
[null,37,{"$f":"IF(Project_Input!C42=0,\"\",Project_Input!C42)","v":""},{"$f":"IF(Project_Input!D42=0,\"\",Project_Input!D42)","v":""},{"$f":"IF(Project_Input!E42=0,\"\",Project_Input!E42)","v":""},{"$f":"IF(Project_Input!F42=0,\"\",Project_Input!F42)","v":""},{"$f":"IF(Project_Input!L42<>\"\",Project_Input!L42,\"\")","v":""}]

{"sheet":"Sensitivity","index":3,"n_rows":19,"n_cols":28,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,1,16,1],[4,3,4,13],[2,24,2,25],[2,26,2,27],[2,22,2,23]]}
[]
[null,"NPV (Base Case)",null,null,{"$f":"NPV_1","v":-115465.97472609166},null,null,null,null,null,null,null,null,"Base Case)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-01",null,"NPV","Benefit","VCR","Discount",null,"Failure rate",null,"Benefit"]
[null,"NPV Sensitivity Analysis",null,null,null,"Project Index",{"$f":"Index_1","v":2},null,"Project Name",{"$f":"DCF!C4","v":"Server & Workstation_ERG_1829387"},null,null,null,null,null,null,null,null,null,3.5000000000000003E-2,null,null,2.5000000000000001E-2,4.4999999999999998E-2,1.25,0.75,1.25,0.75]
[null,null,null,"WACC Sensitivity",null,null,null,null,null,null,null,null,null,null,null,1,"","OT Server & Workstation Replacement",""]
[null,null,null,{"$f":"Hidden!C14","v":9.9999999999999985E-3},{"$f":"Hidden!D14","v":1.4999999999999999E-2},{"$f":"Hidden!E14","v":0.02},{"$f":"Hidden!F14","v":2.5000000000000001E-2},{"$f":"Hidden!G14","v":3.0000000000000002E-2},{"$f":"Hidden!H14","v":3.5000000000000003E-2},{"$f":"Hidden!I14","v":0.04},{"$f":"Hidden!J14","v":4.4999999999999998E-2},{"$f":"Hidden!K14","v":4.9999999999999996E-2},{"$f":"Hidden!L14","v":5.4999999999999993E-2},{"$f":"Hidden!M14","v":5.9999999999999991E-2},null,2,"OT","Server & Workstation_EGX_7862124","EGX",-119075.3506069242,488363.87462854799,103820,60127.333641324913,-275481.60229089012,65313.110911224285,-303463.81212507328,999044.12365674938,-1015105.2803154073]
[null,"Benefit Sensitivity",{"$f":"Hidden!B15","v":1.2500000000000002},{"$f":"Hidden!C15","v":1790066.8567402998},{"$f":"Hidden!D15","v":1612368.8617642992},{"$f":"Hidden!E15","v":1445416.3153588087},{"$f":"Hidden!F15","v":1288550.0968910397},{"$f":"Hidden!G15","v":1141154.3645141434},{"$f":"Hidden!H15","v":1002653.499537583},{"$f":"Hidden!I15","v":872509.28166532819},{"$f":"Hidden!J15","v":750218.27654998039},{"$f":"Hidden!K15","v":635309.4186870188},{"$f":"Hidden!L15","v":527341.77410934912},{"$f":"Hidden!M15","v":425902.4686497337},null,3,"OT","Server & Workstation_ERG_1829387","ERG",-115465.97472609166,488363.87462854799,103820,63855.376876618706,-271985.403714124,68922.486792057331,-299854.43624423956,1002653.499537583,-1011495.9044345733]
[null,null,{"$f":"Hidden!B16","v":1.2000000000000002},{"$f":"Hidden!C16","v":1482820.1098892873},{"$f":"Hidden!D16","v":1319156.1328750809},{"$f":"Hidden!E16","v":1165497.1629941075},{"$f":"Hidden!F16","v":1021227.9881946159},{"$f":"Hidden!G16","v":885773.80495415372},{"$f":"Hidden!H16","v":758597.36658577039},{"$f":"Hidden!I16","v":639196.34682615963},{"$f":"Hidden!J16","v":527100.90142493311},{"$f":"Hidden!K16","v":421871.41192036908},{"$f":"Hidden!L16","v":323096.39712306927},{"$f":"Hidden!M16","v":230390.57904554586},null,4,"","",""]
[null,null,{"$f":"Hidden!B17","v":1.1500000000000001},{"$f":"Hidden!C17","v":1188998.4439082958},{"$f":"Hidden!D17","v":1038754.3945813697},{"$f":"Hidden!E17","v":897807.33994595322},{"$f":"Hidden!F17","v":765584.05238177779},{"$f":"Hidden!G17","v":641548.96836588695},{"$f":"Hidden!H17","v":525201.53177260689},{"$f":"Hidden!I17","v":416073.73755308014},{"$f":"Hidden!J17","v":313727.85972887283},{"$f":"Hidden!K17","v":217754.3489952512},{"$f":"Hidden!L17","v":127769.88647024817},{"$f":"Hidden!M17","v":43415.581255445613},null,5,"","OT SAN & Backup Replacement",""]
[null,null,{"$f":"Hidden!B18","v":1.1000000000000001},{"$f":"Hidden!C18","v":908042.48042774189},{"$f":"Hidden!D18","v":770629.85560835432},{"$f":"Hidden!E18","v":641837.2908261579},{"$f":"Hidden!F18","v":521131.69891570986},{"$f":"Hidden!G18","v":408015.03295885393},{"$f":"Hidden!H18","v":302021.81600898248},{"$f":"Hidden!I18","v":202716.85694750323},{"$f":"Hidden!J18","v":109693.13756892702},{"$f":"Hidden!K18","v":22569.857251601057},{"$f":"Hidden!L18","v":-59009.377279673652},{"$f":"Hidden!M18","v":-135378.22854615422},null,6,"OT","STOR BACKUP_EGX_7862125","EGX",-11928.480656387699,452950.52701122803,207640,-29869.559981791823,1207.9594246554357,327174.09000222734,-351031.05131500325,1296301.2020821981,-928648.32486851874]
[null,null,{"$f":"Hidden!B19","v":1.05},{"$f":"Hidden!C19","v":639392.84107804147},{"$f":"Hidden!D19","v":514248.72468122013},{"$f":"Hidden!E19","v":397077.46024653193},{"$f":"Hidden!F19","v":287384.33725959552},{"$f":"Hidden!G19","v":184707.17694256658},{"$f":"Hidden!H19","v":88614.04020578682},{"$f":"Hidden!I19","v":-1298.8918891574642},{"$f":"Hidden!J19","v":-85409.278947780782},{"$f":"Hidden!K19","v":-164070.43597064461},{"$f":"Hidden!L19","v":-237613.01355725815},{"$f":"Hidden!M19","v":-306346.55418484012},null,7,"OT","STOR BACKUP_ERG_1829388","ERG",-9454.1988352567278,452950.52701122803,207640,-27186.819774002328,3494.9391530632852,329648.37182335835,-348556.76949387247,1298775.4839033284,-926174.04304738797]
[null,null,{"$f":"Hidden!B20","v":1},{"$f":"Hidden!C20","v":382490.14748960856},{"$f":"Hidden!D20","v":269077.21052515402},{"$f":"Hidden!E20","v":163018.29281888375},{"$f":"Hidden!F20","v":63855.376876618706},{"$f":"Hidden!G20","v":-28839.421473465081},{"$f":"Hidden!H20","v":-115465.97472609166},{"$f":"Hidden!I20","v":-196398.10585549052},{"$f":"Hidden!J20","v":-271985.403714124},{"$f":"Hidden!K20","v":-342554.90333155065},{"$f":"Hidden!L20","v":-408412.64179306605},{"$f":"Hidden!M20","v":-469845.09948619962},null,8,"","",""]
[null,null,{"$f":"Hidden!B21","v":0.95},{"$f":"Hidden!C21","v":136775.02129286056},{"$f":"Hidden!D21","v":34581.521865344082},{"$f":"Hidden!E21","v":-60849.766844973892},{"$f":"Hidden!F21","v":-149941.77277003654},{"$f":"Hidden!G21","v":-233089.58407972692},{"$f":"Hidden!H21","v":-310662.40787576133},{"$f":"Hidden!I21","v":-383005.38185008249},{"$f":"Hidden!J21","v":-450441.25062297814},{"$f":"Hidden!K21","v":-513271.91749117989},{"$f":"Hidden!L21","v":-571779.88141765783},{"$f":"Hidden!M21","v":-626229.56827581977},null,9,"","OT Monitoring Replacement",""]
[null,null,{"$f":"Hidden!B22","v":0.89999999999999991},{"$f":"Hidden!C22","v":-98311.91588178683},{"$f":"Hidden!D22","v":-189772.13257302216},{"$f":"Hidden!E22","v":-275036.27413323225},{"$f":"Hidden!F22","v":-354493.7022171868},{"$f":"Hidden!G22","v":-428508.13266670983},{"$f":"Hidden!H22","v":-497419.43833233474},{"$f":"Hidden!I22","v":-561545.31677151972},{"$f":"Hidden!J22","v":-621182.83356721664},{"$f":"Hidden!K22","v":-676609.85110959678},{"$f":"Hidden!L22","v":-728086.35186159553},{"$f":"Hidden!M22","v":-775855.66437928693},null,10,"OT ","MONITORING_EGX_7862123","EGX",700533.35627292353,1027135.288594285,519099.99999999994,652123.19605303591,734479.61464290507,1708059.7449751613,-306993.03242931509,3901611.5693637626,-1498367.4199496303]
[null,null,{"$f":"Hidden!B23","v":0.84999999999999987},{"$f":"Hidden!C23","v":-323330.04240391881},{"$f":"Hidden!D23","v":-404517.5440647584},{"$f":"Hidden!E23","v":-480050.78443407913},{"$f":"Hidden!F23","v":-550287.00200164702},{"$f":"Hidden!G23","v":-615559.88902490109},{"$f":"Hidden!H23","v":-676181.24518492084},{"$f":"Hidden!I23","v":-732442.50751839008},{"$f":"Hidden!J23","v":-784616.16643971438},{"$f":"Hidden!K23","v":-832957.07684686477},{"$f":"Hidden!L23","v":-877703.67255543801},{"$f":"Hidden!M23","v":-919079.0916221888},null,11,"OT ","MONITORING_ERG_1829386","ERG",735712.25107872137,1027135.288594285,519099.99999999994,690352.71825216198,766921.29261875874,1743238.6397809589,-271814.13762351649,3936790.4641695605,-1463188.5251438327]
[null,null,{"$f":"Hidden!B24","v":0.79999999999999982},{"$f":"Hidden!C24","v":-538838.7366431182},{"$f":"Hidden!D24","v":-610188.50388467719},{"$f":"Hidden!E24","v":-676402.85313570453},{"$f":"Hidden!F24","v":-737808.26266023458},{"$f":"Hidden!G24","v":-794709.67494478845},{"$f":"Hidden!H24","v":-847392.00752262992},{"$f":"Hidden!I24","v":-896121.55098928034},{"$f":"Hidden!J24","v":-941147.26313334587},{"$f":"Hidden!K24","v":-982701.96736304869},{"$f":"Hidden!L24","v":-1021003.4629297459},{"$f":"Hidden!M24","v":-1056255.5538301107},null,12,"","",""]
[null,null,{"$f":"Hidden!B25","v":0.74999999999999978},{"$f":"Hidden!C25","v":-745397.37696897076},{"$f":"Hidden!D25","v":-807318.80330759054},{"$f":"Hidden!E25","v":-864602.03562629886},{"$f":"Hidden!F25","v":-917544.07472976425},{"$f":"Hidden!G25","v":-966422.31221686152},{"$f":"Hidden!H25","v":-1011495.9044345733},{"$f":"Hidden!I25","v":-1053007.0440827771},{"$f":"Hidden!J25","v":-1091182.1375409861},{"$f":"Hidden!K25","v":-1126232.8953182106},{"$f":"Hidden!L25","v":-1158357.3424150823},{"$f":"Hidden!M25","v":-1187740.7548286421},null,13,"","OT Infrastructure Augmentation",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"OT","OT Infrastructure Augmentation_EGX_7780410","EGX",30593.503528500314,308935.7929,207640,19757.3412866484,38022.541015273237,398369.69116521766,-337182.68410821701,1165586.7232341778,-708903.94262107112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"OT","OT Infrastructure Augmentation_ERG_1781885","ERG",111201.13828501542,308935.7929,207640,106934.49377371343,112727.62743256536,478977.32592173252,-256575.04935170204,1246194.3579906926,-628296.30786455597]

{"sheet":"Hidden","index":4,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Model General Input"]
[null,"Model Start Year",2023,"Year"]
[null,"Program Start Year",2026,"Year",null,"2023-11-01",3.5]
[null,"Pre-Tax Real WACC",3.5000000000000003E-2,"%",null,"2023-05-01",2.73]
[null,"Benefit Sensitivity",1]
[null,"VCR ",51.91,"$/KWh"]
[null,"Carbon Conversion Rate",8.5000000000000006E-3,"Ton/MWh"]
[null,"Carbon Price",30,"$/Ton"]
[]
[]
[null,"NPV",{"$f":"NPV_1","v":-115465.97472609166}]
[null,"Sensitivity Table",1,{"$f":"C13+1","v":2},{"$f":"D13+1","v":3},4,5,6,7,8,9,10,11]
[null,{"$f":"C12","v":-115465.97472609166},{"$f":"D14-0.5%","v":9.9999999999999985E-3},1.4999999999999999E-2,0.02,2.5000000000000001E-2,{"$f":"H14-0.5%","v":3.0000000000000002E-2},3.5000000000000003E-2,{"$f":"H14+0.5%","v":0.04},{"$f":"I14+0.5%","v":4.4999999999999998E-2},{"$f":"J14+0.5%","v":4.9999999999999996E-2},5.4999999999999993E-2,5.9999999999999991E-2]
[1,{"$f":"B16+5%","v":1.2500000000000002},1790066.8567402998,1612368.8617642992,1445416.3153588087,1288550.0968910397,1141154.3645141434,1002653.499537583,872509.28166532819,750218.27654998039,635309.4186870188,527341.77410934912,425902.4686497337]
[{"$f":"A15+1","v":2},1.2000000000000002,1482820.1098892873,1319156.1328750809,1165497.1629941075,1021227.9881946159,885773.80495415372,758597.36658577039,639196.34682615963,527100.90142493311,421871.41192036908,323096.39712306927,230390.57904554586]
[{"$f":"A16+1","v":3},1.1500000000000001,1188998.4439082958,1038754.3945813697,897807.33994595322,765584.05238177779,641548.96836588695,525201.53177260689,416073.73755308014,313727.85972887283,217754.3489952512,127769.88647024817,43415.581255445613]
[4,1.1000000000000001,908042.48042774189,770629.85560835432,641837.2908261579,521131.69891570986,408015.03295885393,302021.81600898248,202716.85694750323,109693.13756892702,22569.857251601057,-59009.377279673652,-135378.22854615422]
[5,{"$f":"B20+5%","v":1.05},639392.84107804147,514248.72468122013,397077.46024653193,287384.33725959552,184707.17694256658,88614.04020578682,-1298.8918891574642,-85409.278947780782,-164070.43597064461,-237613.01355725815,-306346.55418484012]
[6,1,382490.14748960856,269077.21052515402,163018.29281888375,63855.376876618706,-28839.421473465081,-115465.97472609166,-196398.10585549052,-271985.403714124,-342554.90333155065,-408412.64179306605,-469845.09948619962]
[7,{"$f":"B20-5%","v":0.95},136775.02129286056,34581.521865344082,-60849.766844973892,-149941.77277003654,-233089.58407972692,-310662.40787576133,-383005.38185008249,-450441.25062297814,-513271.91749117989,-571779.88141765783,-626229.56827581977]
[8,{"$f":"B21-5%","v":0.89999999999999991},-98311.91588178683,-189772.13257302216,-275036.27413323225,-354493.7022171868,-428508.13266670983,-497419.43833233474,-561545.31677151972,-621182.83356721664,-676609.85110959678,-728086.35186159553,-775855.66437928693]
[{"$f":"A22+1","v":9},0.84999999999999987,-323330.04240391881,-404517.5440647584,-480050.78443407913,-550287.00200164702,-615559.88902490109,-676181.24518492084,-732442.50751839008,-784616.16643971438,-832957.07684686477,-877703.67255543801,-919079.0916221888]
[10,0.79999999999999982,-538838.7366431182,-610188.50388467719,-676402.85313570453,-737808.26266023458,-794709.67494478845,-847392.00752262992,-896121.55098928034,-941147.26313334587,-982701.96736304869,-1021003.4629297459,-1056255.5538301107]
[11,0.74999999999999978,-745397.37696897076,-807318.80330759054,-864602.03562629886,-917544.07472976425,-966422.31221686152,-1011495.9044345733,-1053007.0440827771,-1091182.1375409861,-1126232.8953182106,-1158357.3424150823,-1187740.7548286421]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yes"]
[null,"No"]
[]
[]
[null,1]
[null,{"$f":"B38+1","v":2}]
[null,{"$f":"B39+1","v":3}]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]