{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Project_Input","DCF","NPV_Output","Sensitivity","Hidden"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":2,"defined_names":220,"comments":2,"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":88,"n_cols":51,"rows_kept":88,"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},{"$f":"D3+1","v":4},{"$f":"E3+1","v":5},{"$f":"F3+1","v":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},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 event A","Cost of event A","Probability of event B","Cost of Event B","Carbon Reduction (in MWh)","Comments"]
[null,361,"REPEX","GRID COMMS AC Systems Replacements (Option1 - Risk based program) Preferred","Brad S","EECL",701000,879200,880200,881200,{"$f":"L6-SUM(G6:J6)","v":1058400},4400000,0,{"$f":"G6/L6","v":0.15931818181818183},{"$f":"H6/L6+N6","v":0.35913636363636364},{"$f":"O6+J6/L6","v":0.55940909090909097},1,1,12,"yes",200,4,0.01,"Failure of a site from weather, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"L6*2","v":8800000},0.05,"Currently having 2 fail a year, if proactive program not proceeding likely 5 per year, out of a propulation of 100","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"No"]
[null,362,"REPEX","GRID COMMS AC Systems Replacements (Option 2 - Replace all)","Brad S","EECL",{"$f":"$L7/5","v":1305130.8622400002},1305130.8622400002,1305130.8622400002,1305130.8622400002,1305130.8622400002,6525654.3112000003,0,{"$f":"G7/L7","v":0.2},{"$f":"H7/L7+N7","v":0.4},{"$f":"O7+J7/L7","v":0.60000000000000009},{"$f":"P7+K7/L7","v":0.8},1,12,"yes",200,4,0.01,"Failure of a site from weather, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"L7*2","v":13051308.622400001},0.05,"Currently having 2 fail a year, if proactive program not proceeding likely 5 per year, out of a propulation of 100","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"No"]
[null,363,"REPEX","GRID COMMS AC Systems Replacements (Option 3 - AER proposed)","Brad S","EECL",896582.43984000012,896582.43984000012,896582.43984000012,896582.43984000012,896582.43984000012,4482912.1992000006,0,{"$f":"G8/L8","v":0.2},{"$f":"H8/L8+N8","v":0.4},{"$f":"O8+J8/L8","v":0.60000000000000009},{"$f":"P8+K8/L8","v":0.8},1,12,"yes",200,4,0.01,"Failure of a site from weather, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"L8*2","v":8965824.3984000012},0.05,"Currently having 2 fail a year, if proactive program not proceeding likely 5 per year, out of a propulation of 100","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"No"]
[null,364,"REPEX","GRID COMMS AC Systems Replacements (Option 4 - Reactive replace)","Brad S","EECL",{"$f":"$L9/5","v":1522026.47832},{"$f":"$L9/5","v":1522026.47832},1522026.47832,1522026.47832,1522026.47832,7610132.3915999997,0,{"$f":"G9/L9","v":0.2},{"$f":"H9/L9+N9","v":0.4},{"$f":"O9+J9/L9","v":0.60000000000000009},{"$f":"P9+K9/L9","v":0.8},1,12]
[null,881,"REPEX","GRID COMMS P25 Replacement (Option 1 - Proposed Life Extension) Preferred","Luke A","EECL",448196.62443396676,449489.72297671071,1200459.2841964411,1200459.2841964411,1200459.2841964411,4499064.2000000011,0,0.1,0.3,0.6,0.9,1,9,"Yes",2000,8,0.01,"Outage of P25 during natural disaster increasing the restoration time. Probability once every 8 years.","Yes",{"$f":"90*112","v":10080},null,null,{"$f":"L10 * 2","v":8998128.4000000022},0.05,"double cost to replace reactivly vs proactivly","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,"P25 safety duress, impact detection functions utilised X  per year"]
[null,882,"REPEX","GRID COMMS P25 Replacement (Option 2 - Technology change)","Luke A","EECL",1517125.9739200003,2406476.0739199999,2981938.2369599999,2668050.3000000003,889350.09999999986,10462940.684799999,0,0.1,0.3,0.6,0.9,1,9,"Yes",2000,8,0.01,"Outage of P25 during natural disaster increasing the restoration time. Probability once every 8 years.","Yes",10080,null,null,20925881.369599998,0.05,"double cost to replace reactivly vs proactivly","Yes",9.9999999999999995E-7,30000000,1.0000000000000001E-5,500000,"P25 safety duress, impact detection functions utilised X  per year"]
[null,883,"REPEX","GRID COMMS P25 Replacement (Option 3 - Public network)","Luke A","EECL",404928,{"$f":"($L12-$G12)/4","v":2874400},{"$f":"($L12-$G12)/4","v":2874400},{"$f":"($L12-$G12)/4","v":2874400},{"$f":"($L12-$G12)/4","v":2874400},11902528,0.24,0,0.33,0.66,0.8,1,5,"Yes",2000,8,0.01,"Outage of P25 during natural disaster increasing the restoration time. Probability once every 8 years.","Yes",{"$f":"1200*8*112","v":1075200},{"$f":"673825+670818+71000+500000","v":1915643},null,{"$f":"L12 * 2","v":23805056},0.05,"double cost to replace reactivly vs proactivly","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,"P25 safety duress, impact detection functions utilised X  per year"]
[null,884,"REPEX","GRID COMMS P25 Replacement (Option 4 - Accelerated program)","Luke A","EECL",{"$f":"$L13/5","v":3998032.0504545467},3998032.0504545467,3998032.0504545467,3998032.0504545467,3998032.0504545467,19990160.252272733,0,0.2,0.4,0.6,0.8,1,9,"Yes",2000,8,0.01,"Outage of P25 during natural disaster increasing the restoration time. Probability once every 8 years.","Yes",{"$f":"90*112","v":10080},null,null,{"$f":"204502*115","v":23517730},0.05,"double cost due to not having like for like spares made available by the proactive program for the base station controller","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,"P25 safety duress, impact detection functions utilised X  per year"]
[null,885,"REPEX","GRID COMMS P25 Replacement (Option 5 - Reactive replace)","Luke A","EECL",1799617.6,1799617.6,1799617.6,1799617.6,1799617.6,{"$f":"204502*2*22","v":8998088},0,0.2,0.4,0.6,0.8,1,9,"No",null,null,null,null,"no",null,null,null,null,null,null,"no"]
[null,521,"REPEX","GRID COMMS SDH Replacement Edge (Option 1A - Spares mine 4%) Preferred","Luke A","EECL",682297.62,682297.62,682297.62,682297.62,682297.62,{"$f":"113716.27*30","v":3411488.1},0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"L19","v":14183868.16},{"$f":"(30/154)/5","v":3.896103896103896E-2},null,"No",null,null,null,null,null,"no"]
[null,522,"REPEX","GRID COMMS SDH Replacement Edge (Option 1B - Spares mine 5%)","Luke A","EECL",874978.88000000012,874978.88000000012,874978.88000000012,874978.88000000012,874978.88000000012,{"$f":"115128.8*38","v":4374894.4000000004},0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"AC15","v":14183868.16},{"$f":"(38/154)/5","v":4.9350649350649353E-2},null,"No",null,null,null,null,null,"no"]
[null,533,"REPEX","GRID COMMS SDH Replacement Edge (Option 1C - Spares mine 6%)","Luke A","EECL",1151288,1151288,1151288,1151288,1151288,{"$f":"115128.8*50","v":5756440},0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"AC15","v":14183868.16},{"$f":"(50/154)/5","v":6.4935064935064929E-2},null,"No",null,null,null,null,null,"no"]
[null,544,"REPEX","GRID COMMS SDH Replacement Edge (Option 1D - AER proposed)","Luke A","EECL",1013133.4400000001,1013133.4400000001,1013133.4400000001,1013133.4400000001,1013133.4400000001,{"$f":"(115128.8*24)+(8*115128.8*2.5)","v":5065667.2},0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"AC15","v":14183868.16},{"$f":"(24/154)/5","v":3.1168831168831169E-2},null,"No",null,null,null,null,null,"no"]
[null,555,"REPEX","GRID COMMS SDH Replacement Edge (Option 2 - Wholesale replace)","Luke A","EECL",2836773.6320000002,2836773.6320000002,2836773.6320000002,2836773.6320000002,2836773.6320000002,{"$f":"115128.8*154*0.8","v":14183868.16},0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"AC17","v":14183868.16},{"$f":"(50/154)/5","v":6.4935064935064929E-2},null,"No",null,null,null,null,null,"no"]
[null,556,"REPEX","GRID COMMS SDH Replacement Edge (Option 3 - Reactive replace)","Luke A","EECL",1801600,1801600,1801600,1801600,1801600,9008000,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"no",null,null,null,null,null,null,"No",null,null,null,null,null,"no"]
[null,551,"REPEX","GRID COMMS SDH Replacement Core (Option 1A - Spares mine 4%) Preferred","Luke A","EECL",845390.28799999994,845390.28799999994,845390.28799999994,845390.28799999994,845390.28799999994,4226951.4399999995,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$25","v":16907804},{"$f":"(52/261)/5","v":3.9846743295019152E-2},null,"No",null,null,null,null,null,"no"]
[null,552,"REPEX","GRID COMMS SDH Replacement Core (Option 1B - Spares mine 5%)","Luke A","EECL",1056737.75,1056737.75,1056737.75,1056737.75,1056737.75,5283688.75,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$25","v":16907804},{"$f":"(65/261)/5","v":4.9808429118773943E-2},null,"No",null,null,null,null,null,"no"]
[null,553,"REPEX","GRID COMMS SDH Replacement Core (Option 1C - Spares mine 6%)","Luke A","EECL",1268085.3,1268085.3,1268085.3,1268085.3,1268085.3,6340426.5,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$25","v":16907804},{"$f":"(78/261)/5","v":5.9770114942528742E-2},null,"No",null,null,null,null,null,"no"]
[null,554,"REPEX","GRID COMMS SDH Replacement Core (Option 1D - AER proposed)","Luke A","EECL",1130709.3924999998,1130709.3924999998,1130709.3924999998,1130709.3924999998,1130709.3924999998,5653546.9624999994,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$25","v":16907804},{"$f":"(40/261)/5","v":3.0651340996168581E-2},null,"No",null,null,null,null,null,"no"]
[null,555,"REPEX","GRID COMMS SDH Replacement Core (Option 2 - Wholesale replace)","Luke A","EECL",3381560.8,3381560.8,3381560.8,3381560.8,3381560.8,16907804,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$25","v":16907804},{"$f":"(78/261)/5","v":5.9770114942528742E-2},null,"No",null,null,null,null,null,"no"]
[null,556,"REPEX","GRID COMMS SDH Replacement Core (Option 3 - Reactive replace)","Luke A","EECL",2113475.5,2113475.5,2113475.5,2113475.5,2113475.5,10567377.5,0,0.2,0.4,0.6,0.8,1,4,"No",null,null,null,null,"No",null,null,null,null,null,null,"No",null,null,null,null,null,"no"]
[null,431,"REPEX","GRID COMMS Data Centre Ethernet Replacements (Option 1 - Preferred)","Luke A","EECL",{"$f":"L27*0.05","v":218423.43452000004},{"$f":"L27*0.05","v":218423.43452000004},{"$f":"$L27*0.1","v":436846.86904000008},{"$f":"$L27*0.4","v":1747387.4761600003},{"$f":"$L27*0.4","v":1747387.4761600003},4368468.6904000007,0,0.05,0.1,0.2,0.6,1,4,"Yes",2000,1,1,"An outage to the underlying telecommunications data centre infrastructure can lead to a failure of critical voice and control systems causing delays, cancellation and rescheduling of planned and unplanned work to the power network.\nProbability of Failure (PoF): We have taken a minimalistic approached to estimating the impact to Customer Reliability, by limiting the exposure to 1 instance of a small 2000KWh impact.\nLikelihood of Consequence (LoC) - Reliability: 100% likely that an outage would occur should no active remediation be conducted.","Yes",{"$f":"(6*64*112)+(6*140*112)","v":137088},{"$f":"(6*(23000*0.6))","v":82800},null,{"$f":"L27*2","v":8736937.3808000013},5.6000000000000001E-2,"There is a likelihood that on a yearly basis 5.6% ( 3 issues per annum accross the fleet) of the at-risk assets will experience either hardware or software defects that require an emergency response that will cost twice as much to fix compared to resolving as part of planned proactive work.","No",null,null,null,null,null,"no"]
[null,432,"REPEX","GRID COMMS Data Centre Ethernet Replacements (Option 2 - AER proposed)","Luke A","EECL",{"$f":"L28*0.05","v":137606.76374759999},{"$f":"L28*0.05","v":137606.76374759999},{"$f":"$L28*0.1","v":275213.52749519999},{"$f":"$L28*0.4","v":1100854.1099808},{"$f":"$L28*0.4","v":1100854.1099808},{"$f":"4368468.6904*(1-0.37)","v":2752135.274952},0.01,0.05,0.1,0.2,0.6,1,4,"Yes",2000,1,0.63,"An outage to the underlying telecommunications data centre infrastructure can lead to a failure of critical voice and control systems causing delays, cancellation and rescheduling of planned and unplanned work to the power network.\nProbability of Failure (PoF): We have taken a minimalistic approached to estimating the impact to Customer Reliability, by limiting the exposure to 1 instance of a small 2000KWh impact.\nLikelihood of Consequence (LoC) - Reliability: 100% likely that an outage would occur should no active remediation be conducted.","Yes",{"$f":"((6*64*112)+(6*140*112))*(1-0.37)","v":86365.440000000002},{"$f":"(6*(23000*0.6))*(1-0.37)","v":52164},null,{"$f":"L28*2","v":5504270.549904},5.6000000000000001E-2,"There is a likelihood that on a yearly basis 5.6% ( 3 issues per annum accross the fleet) of the at-risk assets will experience either hardware or software defects that require an emergency response that will cost twice as much to fix compared to resolving as part of planned proactive work.","No",null,null,null,null,null,"no"]
[null,433,"REPEX","GRID COMMS Data Centre Ethernet Replacements (Option 3 - Reactive replace)","Luke A","EECL",{"$f":"$L$29/5","v":567900.97},{"$f":"$L$29/5","v":567900.97},{"$f":"$L$29/5","v":567900.97},{"$f":"$L$29/5","v":567900.97},{"$f":"$L$29/5","v":567900.97},2839504.85,0,0.05,0.1,0.2,0.6,1,4,"no",null,null,null,null,"no",null,null,null,null,null,null,"No",null,null,null,null,null,"no"]
[null,471,"REPEX","GRID COMMS Operational Support Systems Replacements (Option 1) Preferred","Luke A","EECL",{"$f":"L30*0.5","v":1993534.1199999999},{"$f":"L30*0.4","v":1594827.2960000001},{"$f":"L30*0.1","v":398706.82400000002},0,0,3987068.2399999998,0,0.5,0.9,1,1,1,3,"No",null,null,null,null,"Yes",null,null,null,{"$f":"L30*2.5","v":9967670.5999999996},0.02,"There is an estimated likelihood that on a yearly basis 2% of the at-risk systems will experience software defects that will result in inability to centrally manage the telecommunications network and cost 2.5 as much to fix compared to resolving as part of planned proactive work. ","No",null,null,null,null,null,"Yes",1,{"$f":"(140*12*112)*2","v":376320},1,{"$f":"(140*12*112)*0.5","v":94080},null,"Event A - Infrastructure not fit for purpose  resulting in inability to efficiently manage the telco network resulting in increased labour costs for manual tasks.\n\nEvent B - cyber security risks due to vulnerabilities in obsolete systems requiring additional resources to monitor."]
[null,472,"REPEX","GRID COMMS Operational Support Systems Replacements (Option 2 - AER proposed)","Luke A","EECL",{"$f":"L31*0.5","v":1255926.4956},{"$f":"L31*0.4","v":1004741.19648},{"$f":"L31*0.1","v":251185.29912000001},0,0,{"$f":"3987068.24*(1-0.37)","v":2511852.9912},0,0.5,0.9,1,1,1,3,"No",null,null,null,null,"Yes",null,null,null,{"$f":"L31*2.5","v":6279632.4780000001},0.02,"There is an estimated likelihood that on a yearly basis 2% of the at-risk systems will experience software defects that will result in inability to centrally manage the telecommunications network and cost 2.5 as much to fix compared to resolving as part of planned proactive work. ","No",null,null,null,null,null,"Yes",0.63,{"$f":"(140*12*112)*2","v":376320},{"$f":"2/28","v":7.1428571428571425E-2},{"$f":"(140*12*112)*0.5","v":94080},null,"Event A - Infrastructure not fit for purpose  resulting in inability to efficiently manage the telco network resulting in increased labour costs for manual tasks.\n\nEvent B - cyber security risks due to vulnerabilities in obsolete systems requiring additional resources to monitor."]
[null,473,"REPEX","GRID COMMS Operational Support Systems Replacements (Option 3 - Wholesale replace)","Luke A","EECL",{"$f":"$L32/5","v":1760000},{"$f":"$L32/5","v":1760000},{"$f":"$L32/5","v":1760000},{"$f":"$L32/5","v":1760000},{"$f":"$L32/5","v":1760000},8800000,0,0.2,0.4,0.6,0.8,1,3,"No",null,null,null,null,"no",null,null,null,null,null,null,"No"]
[null,474,"REPEX","GRID COMMS Operational Support Systems Replacements (Option 4 - Reactive replace)","Luke A","EECL",{"$f":"L33*0.5","v":2478087.5},{"$f":"L33*0.4","v":1982470},{"$f":"L33*0.1","v":495617.5},0,0,4956175,0,0.5,0.9,1,1,1,3,"No",null,null,null,null,"no",null,null,null,null,null,null,"No",null,null,null,null,null,"no"]
[null,191,"REPEX","GRID COMMS Fringe Network Replacement (Option 1 - Hybrid approach) ","Luke A","EECL",{"$f":"L34*0.1","v":86814.219000000026},{"$f":"L34*0.15","v":130221.32850000002},{"$f":"L34*0.05","v":43407.109500000013},{"$f":"L34*0.3","v":260442.65700000004},{"$f":"L34*0.4","v":347256.87600000011},868142.19000000018,null,0.1,0.25,0.3,0.6,1,8,null,null,null,null,null,"Yes",{"$f":"112*8*12","v":10752},null,null,null,null,"Note: Probability of Failure does not apply, as this is a standards development project to be deployed in Fix on Fail scenario.\n\nFirmware upgrades to resolve bugs, improve performance, stability etc. Estimated to save labour costs of 8 hrs per month.","No",null,null,null,null,null,"Yes",1,{"$f":"((12*2)*4500*0.6)","v":64800},1,{"$f":"(52*4*112)","v":23296},null,"A: sub-obtimal investiment in aging tech. Assumed 5 x per month of older asset/tech deployed with 60% reduced life.\nB: 4 hours/week labour is wasted as result of aged technology related fault (eg. Inmarsat/NBN/LTE issues etc.) that could be resolved through migration to another technology (LEO/5G etc.)"]
[null,192,"REPEX","GRID COMMS Fringe Network Replacement (Option 2 - Standards develop) Preferred","Luke A","EECL",{"$f":"$L35/5","v":138902.75040000005},138902.75040000005,138902.75040000005,138902.75040000005,138902.75040000005,{"$f":"L34*0.8","v":694513.75200000021},null,0.1,0.25,0.3,0.6,1,8,null,null,null,null,null,"no",null,null,null,null,null,"Note: Probability of Failure does not apply, as this is a standards development project to be deployed in Fix on Fail scenario.","No",null,null,null,null,null,"Yes",1,{"$f":"((12*2)*4500*0.6)","v":64800},1,{"$f":"(52*4*112)","v":23296},null,"A: sub-obtimal investiment in aging tech. Assumed 5 x per month of older asset/tech deployed with 60% reduced life.\nB: 4 hours/week labour is wasted as result of aged technology related fault (eg. Inmarsat/NBN/LTE issues etc.) that could be resolved through migration to another technology (LEO/5G etc.)"]
[null,193,"REPEX","GRID COMMS Fringe Network Replacement (Option 3 - AER proposed)","Luke A","EECL",109385.91594000002,109385.91594000002,109385.91594000002,109385.91594000002,109385.91594000002,{"$f":"L34*(1-0.37)","v":546929.57970000012},0.2,0.2,0.4,0.6,0.8,1,8,null,null,null,null,null,"no",null,null,null,null,null,null,"No",null,null,null,null,null,"Yes",1,{"$f":"((12*2)*4500*0.6)","v":64800},null,null,null,"A: sub-obtimal investiment in aging tech. Assumed 5 x per month of older asset/tech deployed with 60% reduced life.\n1 x site per week where 4 hours is wasted as result of aged technology related fault (eg. Inmarsat/NBN/LTE issues etc.) that could be resolved through migration to another technology (LEO/5G etc.)"]
[null,194,"REPEX","GRID COMMS Fringe Network Replacement (Option 4 - Reactive replace)","Luke A","EECL",{"$f":"L37*0.1","v":255960},{"$f":"L37*0.15","v":383940},{"$f":"L37*0.05","v":127980},{"$f":"L37*0.3","v":767880},{"$f":"L37*0.4","v":1023840},{"$f":"((4600+3500)*2)*158","v":2559600},0.2,0.2,0.4,0.6,0.8,1,8,"No",null,null,null,null,"No",null,null,null,null,null,null,"No",null,null,null,null,null,"No"]
[null,661,"REPEX","GRID COMMS Microwave Radio Core Replacements (Option 1 - Spares mine) Preferred","Luke A","EECL",{"$f":"$L38/5","v":800055.82233600016},800055.82233600016,800055.82233600016,800055.82233600016,800055.82233600016,4000279.111680001,0,0.2,0.4,0.6,0.8,1,9,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$40","v":12800000},{"$f":"(18/96)/5","v":3.7499999999999999E-2},null,"no",null,null,null,null,null,"no"]
[null,664,"REPEX","GRID COMMS Microwave Radio Core Replacements (Option 2 - Hybrid Pro/Reactive replace)","Luke A","EECL",1210751.2,1210751.2,1210751.2,1210751.2,1210751.2,6053756,0,0.2,0.4,0.6,0.8,1,9,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$40","v":12800000},{"$f":"(18/96)/5","v":3.7499999999999999E-2},null,"no",null,null,null,null,null,"no"]
[null,665,"REPEX","GRID COMMS Microwave Radio Core Replacements (Option 3 - Wholesale replace)","Luke A","EECL",2560000,2560000,2560000,2560000,2560000,12800000,0,0.2,0.4,0.6,0.8,1,9,"No",null,null,null,null,"Yes",null,null,null,{"$f":"$L$40","v":12800000},{"$f":"(18/96)/5","v":3.7499999999999999E-2},null,"no",null,null,null,null,null,"no"]
[null,666,"REPEX","GRID COMMS Microwave Radio Core Replacements (Option 4 - Reactive replace)","Luke A","EECL",1706785.8,1706785.8,1706785.8,1706785.8,1706785.8,8533929,0,0.2,0.4,0.6,0.8,1,9,"No",null,null,null,null,"No",null,null,null,null,null,null,"no",null,null,null,null,null,"no"]
[null,421,"REPEX","GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 1 - Spares mine) Preferred","Luke A","EECL",541815.6,541815.6,541815.6,541815.6,541815.6,2709078,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$44","v":7212920.1750000045},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,422,"REPEX","GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 2 - AER proposed)","Luke A","EECL",747705.52800000052,747705.52800000052,747705.52800000052,747705.52800000052,747705.52800000052,3738527.6400000025,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$44","v":7212920.1750000045},2.8400000000000002E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,423,"REPEX","GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 3 - Wholesale replace)","Luke A","EECL",1442584.0350000008,1442584.0350000008,1442584.0350000008,1442584.0350000008,1442584.0350000008,7212920.1750000045,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$44","v":7212920.1750000045},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,424,"REPEX","GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 4 - Reactive replace)","Luke A","EECL",1083631.2000000007,1083631.2000000007,1083631.2000000007,1083631.2000000007,1083631.2000000007,5418156.0000000037,0,0.2,0.4,0.6,0.8,1,9]
[null,411,"REPEX","GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 1 - Spares mine) Preferred","Luke A","EECL",{"$f":"$L46/5","v":965845.20000000054},965845.20000000054,965845.20000000054,965845.20000000054,965845.20000000054,4829226.0000000028,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$48","v":13425248.280000007},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,412,"REPEX","GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 2 - AER proposed)","Luke A","EECL",1381158.6360000009,1381158.6360000009,1381158.6360000009,1381158.6360000009,1381158.6360000009,6905793.1800000044,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$48","v":13425248.280000007},2.5899999999999999E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,413,"REPEX","GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 3 - Wholesale replace)","Luke A","EECL",2685049.6560000014,2685049.6560000014,2685049.6560000014,2685049.6560000014,2685049.6560000014,13425248.280000007,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$48","v":13425248.280000007},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,414,"REPEX","GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 4 - Reactive replace)","Luke A","EECL",1931690.4000000011,1931690.4000000011,1931690.4000000011,1931690.4000000011,1931690.4000000011,9658452.0000000056,0,0.2,0.4,0.6,0.8,1,9]
[null,501,"REPEX","GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 1 - Spares mine) Preferred","Luke A","EECL",848059.20000000042,848059.20000000042,848059.20000000042,848059.20000000042,848059.20000000042,4240296.0000000019,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$52","v":11448799.200000007},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,502,"REPEX","GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 2 - AER proposed)","Luke A","EECL",1240993.2960000006,1240993.2960000006,1240993.2960000006,1240993.2960000006,1240993.2960000006,6204966.4800000032,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$52","v":11448799.200000007},2.5899999999999999E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,503,"REPEX","GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 3 - Wholesale replace)","Luke A","EECL",2289759.8400000012,2289759.8400000012,2289759.8400000012,2289759.8400000012,2289759.8400000012,11448799.200000007,0,0.2,0.4,0.6,0.8,1,9,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$52","v":11448799.200000007},4.4999999999999998E-2,"5% due to equipment failure. Double the cost to fix as requires significant temporary/repeated/cascaded work to also replace SDH equipment","no"]
[null,504,"REPEX","GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 4 - Reactive replace)","Luke A","EECL",1717319.8800000008,1717319.8800000008,1717319.8800000008,1717319.8800000008,1717319.8800000008,8586599.4000000041,0,0.2,0.4,0.6,0.8,1,9]
[null,141,"REPEX","GRID COMMS Edge Router Replacement (Option 1 - Hybrid Proactive) Preferred","Luke A","EECL",{"$f":"(N54)*$L54","v":734719.4},{"$f":"(O54-N54)*$L54","v":734719.4},734719.39999999979,734719.40000000026,734719.39999999979,3673597,1.32E-2,0.2,0.4,0.6,0.8,1,6,null,null,null,null,null,"Yes",{"$f":"(6*48*112)","v":32256},{"$f":"(43*(9000*0.6))","v":232200},null,{"$f":"$L$57","v":15634021},0.02,null,"No",null,null,null,null,null,"no"]
[null,142,"REPEX","GRID COMMS Edge Router Replacement (Option 2 - Standards Dev with Proactive Replacement)","Luke A","EECL",{"$f":"(N55)*$L55","v":650226.66900000011},650226.66900000011,650226.66899999988,650226.66900000023,650226.66899999988,3251133.3450000002,1.32E-2,0.2,0.4,0.6,0.8,1,6,null,null,null,null,null,"Yes",null,{"$f":"(43*(9000*0.6))","v":232200},null,{"$f":"$L$57","v":15634021},0.02,null,"No",null,null,null,null,null,"no"]
[null,143,"REPEX","GRID COMMS Edge Router Replacement (Option 3 - AER proposed)","Luke A","EECL",{"$f":"(N56)*$L56","v":862043.8498681318},862043.8498681318,862043.84986813157,862043.84986813203,862043.84986813157,4310219.249340659,1.32E-2,0.2,0.4,0.6,0.8,1,6,null,null,null,null,null,"Yes",null,null,null,{"$f":"$L$57","v":15634021},0.02,null,"No",null,null,null,null,null,"no"]
[null,144,"REPEX","GRID COMMS Edge Router Replacement (Option 4 - Wholesale Replace)","Luke A","EECL",{"$f":"(N57)*$L57","v":3126804.2},3126804.2,3126804.1999999993,3126804.2000000011,3126804.1999999993,15634021,1.32E-2,0.2,0.4,0.6,0.8,1,6,null,null,null,null,null,"Yes",{"$f":"(6*48*112)","v":32256},{"$f":"(43*(9000*0.6))+((AD57*106)*2000)","v":236440},null,{"$f":"$L$57","v":15634021},0.02,null,"No",null,null,null,null,null,"no"]
[null,145,"REPEX","GRID COMMS Edge Router Replacement (Option 5 - Reactive replace)","Luke A","EECL",{"$f":"(N58)*$L58","v":1324917.0718681319},1324917.0718681319,1324917.0718681314,1324917.0718681321,1324917.0718681314,6624585.3593406584,1.32E-2,0.2,0.4,0.6,0.8,1,6]
[null,441,"REPEX","GRID COMMS Core IP MPLS Ethernet Replacements (Option 1 - Multi-faceted proactive approach) Preferred","Luke A","EECL",0,0,{"$f":"L59*0.1","v":135807.3168},{"$f":"L59*0.4","v":543229.2672},{"$f":"L59*0.5","v":679036.58400000003},1358073.1680000001,0,0,0,0.1,0.5,1,6,null,null,null,null,null,"Yes",32256,null,null,2353993.1999999997,3.2599999999999997E-2,"There is a likelihood that on a yearly basis 3.26% ( 6 issues per annum accross the fleet) of the at-risk assets will experience either hardware or software defects that require an emergency response that will cost twice as much to fix compared to resolving as part of planned proactive work.","No",null,null,null,null,null,"Yes",1,{"$f":"12*(15000*0.6)","v":108000},null,null,null,"A: Sub-optimal investment in aging technology. 1 x asset per month with 60% reduced asset life."]
[null,442,"REPEX","GRID COMMS Core IP MPLS Ethernet Replacements  (Option 2 - AER proposed)","Luke A","EECL",0,0,{"$f":"L60*0.1","v":85558.599000000002},{"$f":"L60*0.4","v":342234.39600000001},{"$f":"L60*0.5","v":427792.995},855585.99,0,0,0,0.1,0.5,1,6,null,null,null,null,null,"Yes",null,null,null,2353993.1999999997,3.2599999999999997E-2,"There is a likelihood that on a yearly basis 3.26% ( 6 issues per annum accross the fleet) of the at-risk assets will experience either hardware or software defects that require an emergency response that will cost twice as much to fix compared to resolving as part of planned proactive work.","No"]
[null,443,"REPEX","GRID COMMS Core IP MPLS Ethernet Replacements  (Option 3 - Reactive Replace)","Luke A","EECL",{"$f":"$L61/5","v":181076.4},181076.4,181076.4,181076.4,181076.4,905382,0,0.2,0.4,0.6,0.8,1,6]
[null,181,"REPEX","GRID COMMS Operational Voice Replacements (Option 1 - Multi-faceted) Preferred","Luke A","EECL",0,0,{"$f":"L62*0.1","v":202999.0644},{"$f":"L62*0.4","v":811996.25760000001},{"$f":"L62*0.5","v":1014995.3219999999},2029990.6439999999,1.4999999999999999E-2,0,0,0.1,0.5,1,5,null,null,null,null,null,"Yes",{"$f":"40*2*112","v":8960},{"$f":"836942/5","v":167388.4},{"$f":"1043049/5","v":208609.8},null,null,"Other: 100% chance due to vendor end of sale of licenses that its required to deploy another instance of Call Manager reactivley in parrallel to existing to support newly deployed telephones.\n\nMaterial: 100% change of SBC receiving CVE requiring replacement. \n\nLabour: 2 weeks of labour savings from having working voice NMS software when triaging faults.\n\n"]
[null,182,"REPEX","GRID COMMS Operational Voice Replacements (Option 2 - AER proposed)","Luke A","EECL",0,0,{"$f":"L63*0.1","v":127889.41057199999},{"$f":"L63*0.4","v":511557.64228799997},{"$f":"L63*0.5","v":639447.05285999994},{"$f":"L62*(1-0.37)","v":1278894.1057199999},0.03,0,0,0.1,0.5,1,5,null,null,null,null,null,"Yes",null,null,{"$f":"1043049/5","v":208609.8},null,null,"Other: 100% chance due to vendor end of sale of licenses that its required to deploy another instance of Call Manager reactivley in parrallel to existing to support newly deployed telephones.\n\nNote: SBC and NMS software out of scope for this option.\n"]
[null,183,"REPEX","GRID COMMS Operational Voice Replacements (Option 3 - Reactive replace)","Luke A","EECL",{"$f":"$L64/5","v":751996.4},751996.4,751996.4,751996.4,751996.4,3759982,1.4999999999999999E-2,0.2,0.4,0.6,0.8,1,5]
[null,391,"REPEX","GRID COMMS DC Systems Replacements (Option 1 Preferred)","Brad S","EECL",987625,987625,987625,987625,987625,4938125,0,0.1,0.3,{"$f":"O65+20%","v":0.5},{"$f":"P65+20%","v":0.7},{"$f":"Q65+20%","v":0.89999999999999991},7,"Yes",2000,4,0.05,"Failure of a site from, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"2*L65","v":9876250},0.06,"8% based on escalating failure rate","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"Yes",0.01,{"$f":"16*8*112","v":14336}]
[null,392,"REPEX","GRID COMMS DC Systems Replacements (Option 2 AER proposed)","Mel M","EECL",{"$f":"$L66/5","v":1522139.35},1522139.35,1522139.35,1522139.35,1522139.35,{"$f":"(4938125*(1-0.37))+4499678","v":7610696.75},0,0.1,0.3,{"$f":"O66+20%","v":0.5},{"$f":"P66+20%","v":0.7},{"$f":"Q66+20%","v":0.89999999999999991},7,"Yes",2000,4,0.05,"Failure of a site from, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"2*L66","v":15221393.5},0.06,"8% based on escalating failure rate","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"Yes",0.01,{"$f":"16*8*112","v":14336}]
[null,393,"REPEX","GRID COMMS DC Systems Replacements (Option 3)","Mel M","EECL",1932026.6,1932026.6,1932026.6,1932026.6,1932026.6,9660133,0,0.1,0.3,{"$f":"O67+20%","v":0.5},{"$f":"P67+20%","v":0.7},{"$f":"Q67+20%","v":0.89999999999999991},7,"Yes",2000,4,0.05,"Failure of a site from, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"2*L67","v":19320266},0.06,"8% based on escalating failure rate","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"Yes",0.01,{"$f":"16*8*112","v":14336}]
[null,394,"REPEX","GRID COMMS DC Systems Replacements (Option 4 - Reactive replace)","Mel M","EECL",1980655.6,1980655.6,1980655.6,1980655.6,1980655.6,{"$f":"4951639*2","v":9903278},0,0.1,0.3,{"$f":"O68+20%","v":0.5},{"$f":"P68+20%","v":0.7},{"$f":"Q68+20%","v":0.89999999999999991},7,"Yes",2000,4,0.05,"Failure of a site from, loss of P25 and protection, SCADA and some depot comms","Yes",8960,null,null,{"$f":"(L68*0.5)*2","v":9903278},0.06,"8% based on escalating failure rate","Yes",{"$f":"1/1000000","v":9.9999999999999995E-7},30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"Yes",0.01,{"$f":"16*8*112","v":14336}]
[null,561,"AuGEX","GRID COMMS Reliability Core MPLS (Option 1A - Original)","Troy W","EECL",{"$f":"$L69/5","v":528903},528903,528903,528903,528903,2644515,1.4999999999999999E-2,0.2,{"$f":"N69+20%","v":0.4},{"$f":"O69+20%","v":0.60000000000000009},{"$f":"P69+20%","v":0.8},{"$f":"Q69+20%","v":1},4,"Yes",2000,4,0.15,"outage of scada at same time as a power issue","Yes",null,null,null,{"$f":"L69*3","v":7933545},0.05,"5% due to equipment failure. 3 x the cost to fix as requires significant temporary/repeated/cascaded work to also replace legacy equipment without and availbe alternate MPLS back haul","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"10*8*112","v":8960},0.1,{"$f":"30*8*112","v":26880}]
[null,562,"AuGEX","GRID COMMS Reliability Core MPLS (Option 1B - Preferred Multi-Technology)","Troy W","EECL",324600,324600,324600,324600,324600,1623000,0.02,0.2,{"$f":"N70+20%","v":0.4},0.60000000000000009,0.8,1,4,"Yes",2000,4,0.15,"outage of scada at same time as a power issue","Yes",null,null,null,{"$f":"L70*3","v":4869000},0.05,"5% due to equipment failure. 3 x the cost to fix as requires significant temporary/repeated/cascaded work to also replace legacy equipment without and availbe alternate MPLS back haul","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"10*8*112","v":8960},0.1,{"$f":"30*8*112","v":26880}]
[null,563,"AuGEX","GRID COMMS Reliability Core MPLS (Option 1C - Expanded program)","Troy W","EECL",1997400,1997400,1997400,1997400,1997400,9987000,0.04,0.2,0.4,0.60000000000000009,0.8,1,4,"Yes",2000,4,0.15,"outage of scada at same time as a power issue","Yes",null,null,null,{"$f":"L71*3","v":29961000},0.05,"5% due to equipment failure. 3 x the cost to fix as requires significant temporary/repeated/cascaded work to also replace legacy equipment without and availbe alternate MPLS back haul","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"10*8*112","v":8960},0.1,{"$f":"30*8*112","v":26880}]
[null,564,"AuGEX","GRID COMMS Reliability Core MPLS (Option 3 - Do Nothing)","Troy W","EECL",561000,561000,561000,561000,561000,{"$f":"11*102000*2.5","v":2805000},0,0.2,0.4,0.60000000000000009,0.8,1,4,null,null,null,null,null,"No"]
[null,511,"AuGEX","GRID COMMS Reliability Edge Backhaul (Option 1A - Original)","Troy W","EECL",363620.8,363620.8,363620.8,363620.8,363620.8,1818104,1.4999999999999999E-2,0.2,{"$f":"N73+20%","v":0.4},{"$f":"O73+20%","v":0.60000000000000009},{"$f":"P73+20%","v":0.8},{"$f":"Q73+20%","v":1},4,"Yes",1000,20,0.15,"a number of outage across numerous devices","Yes",{"$f":"2*112*8*10","v":17920},null,null,{"$f":"L73*2","v":3636208},0.05,"1. multiple eveents throughout the year with cellaular failures\n2. Microwave spur head site is taken down impactting numerous downstream sites, emergencey implementation of required reliability works required 2x effort to return services","Yes",9.9999999999999995E-7,30000000,1.0000000000000001E-5,500000,null,"yes",0.5,{"$f":"4*8*112","v":3584}]
[null,512,"AuGEX","GRID COMMS Reliability Edge Backhaul (Option 1B - Preferred Multi Tech)","Troy W","EECL",297800,297800,297800,297800,297800,1489000,2.5000000000000001E-2,0.2,0.4,0.60000000000000009,0.8,1,4,"Yes",1000,20,0.15,"a number of outage across numerous devices, extebnded durations due to remote site locations","Yes",{"$f":"2*112*8*10","v":17920},null,null,{"$f":"L74*2","v":2978000},0.05,"1. multiple eveents throughout the year with cellaular & Satellite failures\n2. Microwave spur head site is taken down impactting numerous downstream sites, emergencey implementation of required reliability works required 2x effort to return services","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"4*8*112","v":3584}]
[null,513,"AuGEX","GRID COMMS Reliability Edge Backhaul (Option 1C - Expanded scope)","Troy W","EECL",801200,801200,801200,801200,801200,4006000,4.0500000000000001E-2,0.2,0.4,0.60000000000000009,0.8,1,4,"Yes",1000,20,0.15,"a number of outage across numerous devices, extebnded durations due to remote site locations","Yes",{"$f":"2*112*8*10","v":17920},null,null,{"$f":"L75*2","v":8012000},0.05,"1. multiple eveents throughout the year with cellaular & Satellite failures\n2. Microwave spur head site is taken down impactting numerous downstream sites, emergencey implementation of required reliability works required 2x effort to return services","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"4*8*112","v":3584}]
[null,514,"AuGEX","GRID COMMS Reliability Edge Backhaul (Option 2 - Sat/Cell)","Troy W","EECL",117500,117500,117500,117500,117500,{"$f":"23500*25","v":587500},0.19,0.2,{"$f":"N76+20%","v":0.4},0.60000000000000009,0.8,1,4,"Yes",1000,20,0.15,"a number of outage across numerous devices, extebnded durations due to remote site locations","Yes",{"$f":"2*112*8*10","v":17920},null,null,{"$f":"L76*2","v":1175000},0.05,"1. multiple eveents throughout the year with cellaular & Satellite failures\n2. Microwave spur head site is taken down impactting numerous downstream sites, emergencey implementation of required reliability works required 2x effort to return services","Yes",9.9999999999999995E-7,30000000,{"$f":"1/100000","v":1.0000000000000001E-5},500000,null,"yes",0.5,{"$f":"4*8*112","v":3584}]
[null,515,"AuGEX","GRID COMMS Reliability Edge Backhaul (Option 3 - Do Nothing)","Troy W","EECL",2295000,2295000,2295000,2295000,2295000,{"$f":"30*2.5*153000","v":11475000},0,0.2,0.4,0.60000000000000009,0.8,1,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"DCF","index":1,"n_rows":65,"n_cols":71,"rows_kept":65,"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",361,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":"GRID COMMS AC Systems Replacements (Option1 - Risk based program) Preferred"},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 event A"},{"$f":"Project_Input!AN5","v":"Cost of event A"},{"$f":"Project_Input!AO5","v":"Probability of event B"},{"$f":"Project_Input!AP5","v":"Cost of Event B"},{"$f":"Project_Input!AQ5","v":"Carbon Reduction (in MWh)"}]
[null,"DNSP",{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!$F$3)","v":"EECL"},null,{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!G3,FALSE)","v":701000},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!H3,FALSE)","v":879200},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!I3,FALSE)","v":880200},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!J3,FALSE)","v":881200},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!K3,FALSE)","v":1058400},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!M3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!N3,FALSE)","v":0.15931818181818183},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!O3,FALSE)","v":0.35913636363636364},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!P3,FALSE)","v":0.55940909090909097},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Q3,FALSE)","v":1},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!R3,FALSE)","v":1},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!S3,FALSE)","v":12},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!T3,FALSE)","v":"yes"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!U3,FALSE)","v":200},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!V3,FALSE)","v":4},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!W3,FALSE)","v":0.01},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Y3,FALSE)","v":"Yes"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!Z3,FALSE)","v":8960},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AA3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AB3,FALSE)","v":0},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AC3,FALSE)","v":8800000},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AD3,FALSE)","v":0.05},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AF3,FALSE)","v":"Yes"},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AG3,FALSE)","v":9.9999999999999995E-7},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AH3,FALSE)","v":30000000},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AI3,FALSE)","v":1.0000000000000001E-5},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!AJ3,FALSE)","v":500000},{"$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},{"$f":"VLOOKUP(Index_1,Project_Table,Project_Input!F3)","v":"EECL"}]
[]
[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,{"$f":"IFERROR(HLOOKUP(H8,Table_2,2,FALSE),0)","v":701000},879200,880200,881200,1058400,0,0,0,0,0,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},701000,1580200,2460400,3341600,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,4400000,{"$f":"AP10+AO11","v":4400000},{"$f":"AQ10+AP11","v":4400000},{"$f":"AR10+AQ11","v":4400000},{"$f":"AS10+AR11","v":4400000},{"$f":"AT10+AS11","v":4400000},{"$f":"AU10+AT11","v":4400000},{"$f":"AV10+AU11","v":4400000},{"$f":"AW10+AV11","v":4400000},{"$f":"AX10+AW11","v":4400000},{"$f":"AY10+AX11","v":4400000},{"$f":"AZ10+AY11","v":4400000},{"$f":"BA10+AZ11","v":4400000},{"$f":"BB10+BA11","v":4400000},{"$f":"BC10+BB11","v":4400000},{"$f":"BD10+BC11","v":4400000},{"$f":"BE10+BD11","v":4400000},{"$f":"BF10+BE11","v":4400000},{"$f":"BG10+BF11","v":4400000},{"$f":"BH10+BG11","v":4400000},{"$f":"BI10+BH11","v":4400000},{"$f":"BJ10+BI11","v":4400000},{"$f":"BK10+BJ11","v":4400000},{"$f":"BL10+BK11","v":4400000},{"$f":"BM10+BL11","v":4400000},{"$f":"BN10+BM11","v":4400000},{"$f":"BO10+BN11","v":4400000},{"$f":"BP10+BO11","v":4400000},{"$f":"BQ10+BP11","v":4400000},{"$f":"BR10+BQ11","v":4400000},{"$f":"BS10+BR11","v":4400000}]
[null,"Capex Finish (Accumulative)",null,null,null,{"$f":"IF(F11>=SUM($E$5:$I$5),1,0)","v":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,{"$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.15931818181818183},{"$f":"L5","v":0.35913636363636364},0.55940909090909097,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,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},{"$f":"IF(H11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(I11=0,0,Hidden!$C$6)","v":1},{"$f":"IF(J11=0,0,Hidden!$C$6)","v":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":15.077863636363636},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.15931818181818183,0.35913636363636364,0.55940909090909097,1,1,1,1,1,1,1,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,{"$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,{"$f":"$R$5*$S$5*H17","v":127.45454545454547},287.30909090909091,447.52727272727276,800,800,800,800,800,800,800,800,800,800,800,800,800,800,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,{"$f":"$T$5*H17","v":1.5931818181818182E-3},3.5913636363636365E-3,5.5940909090909097E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,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":8.2702068181818191},{"$f":"Hidden!$C$7*I$17","v":18.642768636363634},{"$f":"Hidden!$C$7*J$17","v":29.03892590909091},{"$f":"Hidden!$C$7*K$17","v":51.91},{"$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":51.91},{"$f":"Hidden!$C$7*T$17","v":51.91},{"$f":"Hidden!$C$7*U$17","v":51.91},{"$f":"Hidden!$C$7*V$17","v":51.91},{"$f":"Hidden!$C$7*W$17","v":51.91},{"$f":"Hidden!$C$7*X$17","v":51.91},{"$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 ","$",{"$f":"SUM(F23:BM23)","v":135097.6581818182},null,{"$f":"$V$5*F$17","v":0},0,1427.4909090909091,3217.8618181818183,5012.3054545454552,8960,8960,8960,8960,8960,8960,8960,8960,8960,8960,8960,8960,8960,8960,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 ","$",{"$f":"SUM(F24:BM24)","v":0},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 ","$",{"$f":"SUM(F25:BM25)","v":0},null,{"$f":"$X5*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":"$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 ","$",6634260,null,{"$f":"$Y5*$Z$5*F$17","v":0},0,{"$f":"$Y5*$Z$5*H$17","v":70100},{"$f":"$Y5*$Z$5*I$17","v":158020},246140.00000000003,440000,440000,{"$f":"$Y5*$Z$5*M$17","v":440000},440000,440000,440000,440000,440000,440000,440000,440000,440000,440000,440000,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,5.5761363636363637,12.569772727272728,19.579318181818184,35,35,35,35,35,35,35,35,35,35,35,35,35,35,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,4.7795454545454552,10.774090909090908,16.78227272727273,30,30,30,30,30,30,30,30,30,30,30,30,30,30,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,"Event A",null,{"$f":"SUM(F33:BM33)","v":0},null,{"$f":"$AH$5*$AG$5*F$17","v":0},0,{"$f":"$AH$5*$AG$5*H$17","v":0},0,0,0,0,{"$f":"$AH$5*$AG$5*M$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,{"$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,"Event B",null,0,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":-4400000},null,{"$f":"IFERROR(-HLOOKUP(F8,Table_2,2,FALSE),0)","v":0},0,-701000,-879200,-880200,-881200,-1058400,0,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":0},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},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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,-4400000,null,{"$f":"SUM(F37:F38)","v":0},{"$f":"SUM(G37:G38)","v":0},-701000,-879200,-880200,-881200,-1058400,0,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(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":5907.5347188303222},null,{"$f":"IF($Q$5=\"Yes\",F21*F20*F19,0)","v":0},0,{"$f":"IF($Q$5=\"Yes\",H21*H20*H19,0)","v":1.6793338432484979},19.236194462523596,72.699190524550076,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,415.28000000000003,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":6769357.6581818182},null,{"$f":"IF($U$5=\"Yes\",(F23+F24+F25+F26),0)","v":0},0,71527.490909090906,161237.86181818182,{"$f":"IF($U$5=\"Yes\",(J23+J24+J25+J26),0)","v":251152.30545454548},448960,448960,448960,448960,448960,448960,448960,448960,448960,448960,448960,448960,448960,448960,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,527.72522727272735,null,{"$f":"IF($AA$5=\"Yes\",F28,0)","v":0},{"$f":"IF($AA$5=\"Yes\",G28,0)","v":0},5.5761363636363637,12.569772727272728,19.579318181818184,35,35,35,35,35,35,35,35,35,35,35,35,35,35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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\",BS28,0)","v":0}]
[null,"Environmental Saving + Event A + Event B",null,0,null,{"$f":"IF($AF$5=\"Yes\",F32+F33+F34,0)","v":0},{"$f":"IF($AF$5=\"Yes\",G32+G33+G34,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,0,0,0,0,0,0,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($AF$5=\"Yes\",BS32+BS33+BS34,0)","v":0}]
[null,"Total Cashflow Inflow",null,{"$f":"SUM(F46:BM46)","v":6775792.9181279242},null,{"$f":"SUM(F42:F45)","v":0},0,71534.746379297794,161269.6677853716,251244.58396325185,449410.28,449410.28,{"$f":"SUM(M42:M45)","v":449410.28},449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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":2375792.8981279223},null,{"$f":"F39+F46-0.01","v":-0.01},{"$f":"G39+G46-0.01","v":-0.01},{"$f":"H39+H46","v":-629465.25362070219},-717930.33221462835,-628955.41603674809,-431789.72,-608989.72,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,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":860541.31527332356}]
[]
[null,"WACC 2",2.5000000000000001E-2,{"$f":"NPV(C52,$F$48:$BM$48)","v":1202698.0727556518}]
[null,"WACC 3",4.4999999999999998E-2,{"$f":"NPV(C53,$F$48:$BM$48)","v":573909.91847565258}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD53","v":0}]
[null,"Counterfactual for RCP period",null,{"$f":"SUM(H46:L46)","v":1382869.5581279213},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD54","v":0}]
[null,"Counterfactual for the Benefit Claim Period",null,{"$f":"SUM(H46:BR46)","v":6775792.9181279242}]
[null,"NPV of the couterfactual case",null,{"$f":"-NPV(WACC,DCF!F46:BM46)","v":-4548829.5595567534}]
[null,"WACC 2.5%",null,{"$f":"Hidden!K18","v":1202698.0727556518}]
[null,"WACC 4.5%",null,{"$f":"Hidden!O18","v":573909.91847565258}]
[null,"WACC 75% Benefits",null,{"$f":"Hidden!M23","v":-277945.07272360194}]
[null,"WACC 125% Benefits",null,{"$f":"Hidden!M13","v":2000489.4153933725}]
[]
[]
[]
[null,"Couterfactual for period reactive cases",{"$f":"C5","v":"EECL"},{"$f":"SUM(H65:L65)+D55","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"H46-(1-$C65)*H39/$C65","v":{"$error":"#VALUE!"}},{"$f":"I46-(1-$C65)*I39/$C65","v":{"$error":"#VALUE!"}},{"$f":"J46-(1-$C65)*J39/$C65","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"NPV_Output","index":2,"n_rows":98,"n_cols":39,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"R\"&ROW(Start_1)+Index_1*1-1&\"C\"&COLUMN(Start_1)","v":{"$error":"#REF!"}}]
[null,"NPV Summary",null,null,null,null,null,null,null,null,null,null,null,"Cash Inflows (Benefits)"]
[]
[null,"Index","GT Stream","WR Description","Managers","Case Ref","Total Capex ","NPV","Counterfactual ","WACC 2.5%","WACC 4.5%","WACC 75%","WACC 125%",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]
[null,{"$f":"IF(Project_Input!$D6=\"\",\"\",Project_Input!B6)","v":361},{"$f":"IF(Project_Input!$D6=\"\",\"\",Project_Input!C6)","v":"REPEX"},{"$f":"IF(Project_Input!$D6=\"\",\"\",Project_Input!D6)","v":"GRID COMMS AC Systems Replacements (Option1 - Risk based program) Preferred"},{"$f":"IF(Project_Input!$D6=\"\",\"\",Project_Input!E6)","v":"Brad S"},{"$f":"IF(Project_Input!$D6=\"\",\"\",Project_Input!F6)","v":"EECL"},{"$f":"Project_Input!L6","v":4400000},860541.31527332356,1382869.5581279213,1202698.0727556518,573909.91847565258,-277945.07272360194,2000489.4153933725,71534.746379297794,161269.6677853716,251244.58396325185,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,449410.28,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D7=\"\",\"\",Project_Input!B7)","v":362},{"$f":"IF(Project_Input!$D7=\"\",\"\",Project_Input!C7)","v":"REPEX"},{"$f":"IF(Project_Input!$D7=\"\",\"\",Project_Input!D7)","v":"GRID COMMS AC Systems Replacements (Option 2 - Replace all)"},{"$f":"IF(Project_Input!$D7=\"\",\"\",Project_Input!E7)","v":"Brad S"},{"$f":"IF(Project_Input!$D7=\"\",\"\",Project_Input!F7)","v":"EECL"},{"$f":"Project_Input!L7","v":6525654.3112000003},1162247.0502545887,1985428.7973600002,1668266.3058085719,738436.92321072321,-504779.51005832624,2830681.8225728311,132315.40846400004,264650.75036800007,397025.95915200008,529460.96825600008,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,661975.71112000011,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D8=\"\",\"\",Project_Input!B8)","v":363},{"$f":"IF(Project_Input!$D8=\"\",\"\",Project_Input!C8)","v":"REPEX"},{"$f":"IF(Project_Input!$D8=\"\",\"\",Project_Input!D8)","v":"GRID COMMS AC Systems Replacements (Option 3 - AER proposed)"},{"$f":"IF(Project_Input!$D8=\"\",\"\",Project_Input!E8)","v":"Brad S"},{"$f":"IF(Project_Input!$D8=\"\",\"\",Project_Input!F8)","v":"EECL"},{"$f":"Project_Input!L8","v":4482912.1992000006},827945.18771666591,1372606.1637600004,1179012.5543717062,533789.74700910773,-325013.35753192136,1982311.9449705828,91460.566224000009,182941.06588800004,274461.43243200006,366041.59929600009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,457701.49992000009,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D9=\"\",\"\",Project_Input!B9)","v":364},{"$f":"IF(Project_Input!$D9=\"\",\"\",Project_Input!C9)","v":"REPEX"},{"$f":"IF(Project_Input!$D9=\"\",\"\",Project_Input!D9)","v":"GRID COMMS AC Systems Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D9=\"\",\"\",Project_Input!E9)","v":"Brad S"},{"$f":"IF(Project_Input!$D9=\"\",\"\",Project_Input!F9)","v":"EECL"},{"$f":"Project_Input!L9","v":7610132.3915999997},-6415112.8724759929,0,-6730350.0338524068,-6118596.9777984498,-6415112.8724759929,-6415112.8724759929,0,0,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":"IF(Project_Input!$D10=\"\",\"\",Project_Input!B10)","v":881},{"$f":"IF(Project_Input!$D10=\"\",\"\",Project_Input!C10)","v":"REPEX"},{"$f":"IF(Project_Input!$D10=\"\",\"\",Project_Input!D10)","v":"GRID COMMS P25 Replacement (Option 1 - Proposed Life Extension) Preferred"},{"$f":"IF(Project_Input!$D10=\"\",\"\",Project_Input!E10)","v":"Luke A"},{"$f":"IF(Project_Input!$D10=\"\",\"\",Project_Input!F10)","v":"EECL"},{"$f":"Project_Input!L10","v":4499064.2000000011},179260.53329436987,1350449.0668000006,380632.66172980895,10408.003946562198,-817878.80888869276,1199961.5218783633,46010.447600000021,138230.67720000003,277806.86160000006,420074.06040000019,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,468327.02000000014,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D11=\"\",\"\",Project_Input!B11)","v":882},{"$f":"IF(Project_Input!$D11=\"\",\"\",Project_Input!C11)","v":"REPEX"},{"$f":"IF(Project_Input!$D11=\"\",\"\",Project_Input!D11)","v":"GRID COMMS P25 Replacement (Option 2 - Technology change)"},{"$f":"IF(Project_Input!$D11=\"\",\"\",Project_Input!E11)","v":"Luke A"},{"$f":"IF(Project_Input!$D11=\"\",\"\",Project_Input!F11)","v":"EECL"},{"$f":"Project_Input!L11","v":10462940.684799999},42967.894998877557,3079973.2473919997,534193.85576110508,-369898.68505814194,-2199805.3578122128,2309302.7942108964,105649.21244800001,317146.97174399998,635639.45068799995,956822.94403199991,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,1064714.66848,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D12=\"\",\"\",Project_Input!B12)","v":883},{"$f":"IF(Project_Input!$D12=\"\",\"\",Project_Input!C12)","v":"REPEX"},{"$f":"IF(Project_Input!$D12=\"\",\"\",Project_Input!D12)","v":"GRID COMMS P25 Replacement (Option 3 - Public network)"},{"$f":"IF(Project_Input!$D12=\"\",\"\",Project_Input!E12)","v":"Luke A"},{"$f":"IF(Project_Input!$D12=\"\",\"\",Project_Input!F12)","v":"EECL"},{"$f":"Project_Input!L12","v":11902528},-2125643.3147140783,11680599.3043248,-1998498.235321692,-2225114.3116155784,-4079886.54466108,-155750.23331516626,0,1380071.6423472001,2761934.1547776004,3349157.1072000004,4189436.4,4189436.4,4189436.4,4189436.4,4189436.4,4189436.4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D13=\"\",\"\",Project_Input!B13)","v":884},{"$f":"IF(Project_Input!$D13=\"\",\"\",Project_Input!C13)","v":"REPEX"},{"$f":"IF(Project_Input!$D13=\"\",\"\",Project_Input!D13)","v":"GRID COMMS P25 Replacement (Option 4 - Accelerated program)"},{"$f":"IF(Project_Input!$D13=\"\",\"\",Project_Input!E13)","v":"Luke A"},{"$f":"IF(Project_Input!$D13=\"\",\"\",Project_Input!F13)","v":"EECL"},{"$f":"Project_Input!L13","v":19990160.252272733},-6767097.268872967,3572954.58,-6562931.2551307566,-6904955.2162556043,-9308339.4358398188,-4202723.1852094838,237266.74480000001,474932.15840000001,713394.90960000001,953053.66720000003,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,1194307.1000000001,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D14=\"\",\"\",Project_Input!B14)","v":885},{"$f":"IF(Project_Input!$D14=\"\",\"\",Project_Input!C14)","v":"REPEX"},{"$f":"IF(Project_Input!$D14=\"\",\"\",Project_Input!D14)","v":"GRID COMMS P25 Replacement (Option 5 - Reactive replace)"},{"$f":"IF(Project_Input!$D14=\"\",\"\",Project_Input!E14)","v":"Luke A"},{"$f":"IF(Project_Input!$D14=\"\",\"\",Project_Input!F14)","v":"EECL"},{"$f":"Project_Input!L14","v":8998088},-7585117.7298597116,0,-7957848.6591772139,-7234522.5002317559,-7585117.7298597116,-7585117.7298597116,0,0,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":"IF(Project_Input!$D15=\"\",\"\",Project_Input!B15)","v":521},{"$f":"IF(Project_Input!$D15=\"\",\"\",Project_Input!C15)","v":"REPEX"},{"$f":"IF(Project_Input!$D15=\"\",\"\",Project_Input!D15)","v":"GRID COMMS SDH Replacement Edge (Option 1A - Spares mine 4%) Preferred"},{"$f":"IF(Project_Input!$D15=\"\",\"\",Project_Input!E15)","v":"Luke A"},{"$f":"IF(Project_Input!$D15=\"\",\"\",Project_Input!F15)","v":"EECL"},{"$f":"Project_Input!L15","v":3411488.1},85117.777258920571,1657854.72,173904.84745280069,7806.7640267257948,-655107.15243680868,825342.70695464953,110523.648,221047.296,331570.94399999996,442094.592,552618.23999999999,552618.23999999999,552618.23999999999,552618.23999999999,552618.23999999999,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D16=\"\",\"\",Project_Input!B16)","v":522},{"$f":"IF(Project_Input!$D16=\"\",\"\",Project_Input!C16)","v":"REPEX"},{"$f":"IF(Project_Input!$D16=\"\",\"\",Project_Input!D16)","v":"GRID COMMS SDH Replacement Edge (Option 1B - Spares mine 5%)"},{"$f":"IF(Project_Input!$D16=\"\",\"\",Project_Input!E16)","v":"Luke A"},{"$f":"IF(Project_Input!$D16=\"\",\"\",Project_Input!F16)","v":"EECL"},{"$f":"Project_Input!L16","v":4374894.4000000004},62568.483689249551,2099949.3119999999,172808.66059131877,-33267.400102425956,-875049.76059200719,1000186.7279705065,139996.6208,279993.24160000001,419989.86240000004,559986.48320000002,699983.10400000005,699983.10400000005,699983.10400000005,699983.10400000005,699983.10400000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D17=\"\",\"\",Project_Input!B17)","v":533},{"$f":"IF(Project_Input!$D17=\"\",\"\",Project_Input!C17)","v":"REPEX"},{"$f":"IF(Project_Input!$D17=\"\",\"\",Project_Input!D17)","v":"GRID COMMS SDH Replacement Edge (Option 1C - Spares mine 6%)"},{"$f":"IF(Project_Input!$D17=\"\",\"\",Project_Input!E17)","v":"Luke A"},{"$f":"IF(Project_Input!$D17=\"\",\"\",Project_Input!F17)","v":"EECL"},{"$f":"Project_Input!L17","v":5756440},82326.9582217313,2763091.1999999997,227379.82265412674,-43772.888957925417,-1151381.2579378169,1316035.1743812792,184206.07999999999,368412.15999999997,552618.23999999987,736824.31999999995,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D18=\"\",\"\",Project_Input!B18)","v":544},{"$f":"IF(Project_Input!$D18=\"\",\"\",Project_Input!C18)","v":"REPEX"},{"$f":"IF(Project_Input!$D18=\"\",\"\",Project_Input!D18)","v":"GRID COMMS SDH Replacement Edge (Option 1D - AER proposed)"},{"$f":"IF(Project_Input!$D18=\"\",\"\",Project_Input!E18)","v":"Luke A"},{"$f":"IF(Project_Input!$D18=\"\",\"\",Project_Input!F18)","v":"EECL"},{"$f":"Project_Input!L18","v":5065667.2},-1901485.4248997848,1326283.7760000001,-1927240.4566723206,-1872297.3849875585,-2493665.368656368,-1309305.4811432015,88418.91840000001,176837.83680000002,265256.75520000001,353675.67360000004,442094.592,442094.592,442094.592,442094.592,442094.592,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D19=\"\",\"\",Project_Input!B19)","v":555},{"$f":"IF(Project_Input!$D19=\"\",\"\",Project_Input!C19)","v":"REPEX"},{"$f":"IF(Project_Input!$D19=\"\",\"\",Project_Input!D19)","v":"GRID COMMS SDH Replacement Edge (Option 2 - Wholesale replace)"},{"$f":"IF(Project_Input!$D19=\"\",\"\",Project_Input!E19)","v":"Luke A"},{"$f":"IF(Project_Input!$D19=\"\",\"\",Project_Input!F19)","v":"EECL"},{"$f":"Project_Input!L19","v":14183868.16},-7021741.6609604387,2763091.1999999997,-7225781.0845225984,-6819481.0710504977,-8255449.8771199863,-5788033.4448008891,184206.07999999999,368412.15999999997,552618.23999999987,736824.31999999995,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D20=\"\",\"\",Project_Input!B20)","v":556},{"$f":"IF(Project_Input!$D20=\"\",\"\",Project_Input!C20)","v":"REPEX"},{"$f":"IF(Project_Input!$D20=\"\",\"\",Project_Input!D20)","v":"GRID COMMS SDH Replacement Edge (Option 3 - Reactive replace)"},{"$f":"IF(Project_Input!$D20=\"\",\"\",Project_Input!E20)","v":"Luke A"},{"$f":"IF(Project_Input!$D20=\"\",\"\",Project_Input!F20)","v":"EECL"},{"$f":"Project_Input!L20","v":9008000},-7593473.2479153331,0,-7966614.7654565386,-7242491.8140278272,-7593473.2479153331,-7593473.2479153331,0,0,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":"IF(Project_Input!$D21=\"\",\"\",Project_Input!B21)","v":551},{"$f":"IF(Project_Input!$D21=\"\",\"\",Project_Input!C21)","v":"REPEX"},{"$f":"IF(Project_Input!$D21=\"\",\"\",Project_Input!D21)","v":"GRID COMMS SDH Replacement Core (Option 1A - Spares mine 4%) Preferred"},{"$f":"IF(Project_Input!$D21=\"\",\"\",Project_Input!E21)","v":"Luke A"},{"$f":"IF(Project_Input!$D21=\"\",\"\",Project_Input!F21)","v":"EECL"},{"$f":"Project_Input!L21","v":4226951.4399999995},46568.569665726282,2021162.7770114942,152001.84394358625,-45040.67817421566,-855871.82904240466,949008.96837385744,134744.18513409962,269488.37026819924,404232.55540229881,538976.74053639849,673720.92567049805,673720.92567049805,673720.92567049805,673720.92567049805,673720.92567049805,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D22=\"\",\"\",Project_Input!B22)","v":552},{"$f":"IF(Project_Input!$D22=\"\",\"\",Project_Input!C22)","v":"REPEX"},{"$f":"IF(Project_Input!$D22=\"\",\"\",Project_Input!D22)","v":"GRID COMMS SDH Replacement Core (Option 1B - Spares mine 5%)"},{"$f":"IF(Project_Input!$D22=\"\",\"\",Project_Input!E22)","v":"Luke A"},{"$f":"IF(Project_Input!$D22=\"\",\"\",Project_Input!F22)","v":"EECL"},{"$f":"Project_Input!L22","v":5283688.75},58211.180464861187,2526453.4712643679,190002.79616435184,-56300.400832450046,-1069839.3179203041,1186261.6788500247,168430.23141762451,336860.46283524903,505290.69425287354,673720.92567049805,842151.15708812256,842151.15708812256,842151.15708812256,842151.15708812256,842151.15708812256,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D23=\"\",\"\",Project_Input!B23)","v":553},{"$f":"IF(Project_Input!$D23=\"\",\"\",Project_Input!C23)","v":"REPEX"},{"$f":"IF(Project_Input!$D23=\"\",\"\",Project_Input!D23)","v":"GRID COMMS SDH Replacement Core (Option 1C - Spares mine 6%)"},{"$f":"IF(Project_Input!$D23=\"\",\"\",Project_Input!E23)","v":"Luke A"},{"$f":"IF(Project_Input!$D23=\"\",\"\",Project_Input!F23)","v":"EECL"},{"$f":"Project_Input!L23","v":6340426.5},69853.420357222014,3031744.1655172417,228003.35925207078,-67560.477253604506,-1283807.1777049757,1423514.0184194192,202116.27770114946,404232.55540229892,606348.83310344827,808465.11080459785,1010581.3885057472,1010581.3885057472,1010581.3885057472,1010581.3885057472,1010581.3885057472,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D24=\"\",\"\",Project_Input!B24)","v":554},{"$f":"IF(Project_Input!$D24=\"\",\"\",Project_Input!C24)","v":"REPEX"},{"$f":"IF(Project_Input!$D24=\"\",\"\",Project_Input!D24)","v":"GRID COMMS SDH Replacement Core (Option 1D - AER proposed)"},{"$f":"IF(Project_Input!$D24=\"\",\"\",Project_Input!E24)","v":"Luke A"},{"$f":"IF(Project_Input!$D24=\"\",\"\",Project_Input!F24)","v":"EECL"},{"$f":"Project_Input!L24","v":5653546.9624999994},-1989030.4803286016,1554740.5977011495,-2007428.7426676301,-1965907.4919385083,-2683215.4024117794,-1294845.5582454242,103649.37318007663,207298.74636015325,310948.11954022985,414597.4927203065,518246.8659003831,518246.8659003831,518246.8659003831,518246.8659003831,518246.8659003831,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D25=\"\",\"\",Project_Input!B25)","v":555},{"$f":"IF(Project_Input!$D25=\"\",\"\",Project_Input!C25)","v":"REPEX"},{"$f":"IF(Project_Input!$D25=\"\",\"\",Project_Input!D25)","v":"GRID COMMS SDH Replacement Core (Option 2 - Wholesale replace)"},{"$f":"IF(Project_Input!$D25=\"\",\"\",Project_Input!E25)","v":"Luke A"},{"$f":"IF(Project_Input!$D25=\"\",\"\",Project_Input!F25)","v":"EECL"},{"$f":"Project_Input!L25","v":16907804},-7021741.6609604387,2763091.1999999997,-7225781.0845225984,-6819481.0710504977,-8255449.8771199863,-5788033.4448008891,184206.07999999999,368412.15999999997,552618.23999999987,736824.31999999995,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,921030.39999999991,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D26=\"\",\"\",Project_Input!B26)","v":556},{"$f":"IF(Project_Input!$D26=\"\",\"\",Project_Input!C26)","v":"REPEX"},{"$f":"IF(Project_Input!$D26=\"\",\"\",Project_Input!D26)","v":"GRID COMMS SDH Replacement Core (Option 3 - Reactive replace)"},{"$f":"IF(Project_Input!$D26=\"\",\"\",Project_Input!E26)","v":"Luke A"},{"$f":"IF(Project_Input!$D26=\"\",\"\",Project_Input!F26)","v":"EECL"},{"$f":"Project_Input!L26","v":10567377.5},-7593473.2479153331,0,-7966614.7654565386,-7242491.8140278272,-7593473.2479153331,-7593473.2479153331,0,0,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":"IF(Project_Input!$D27=\"\",\"\",Project_Input!B27)","v":431},{"$f":"IF(Project_Input!$D27=\"\",\"\",Project_Input!C27)","v":"REPEX"},{"$f":"IF(Project_Input!$D27=\"\",\"\",Project_Input!D27)","v":"GRID COMMS Data Centre Ethernet Replacements (Option 1 - Preferred)"},{"$f":"IF(Project_Input!$D27=\"\",\"\",Project_Input!E27)","v":"Luke A"},{"$f":"IF(Project_Input!$D27=\"\",\"\",Project_Input!F27)","v":"EECL"},{"$f":"Project_Input!L27","v":4368468.6904000007},14349.12093707545,1510047.6394833601,102860.55260944943,-61303.58023319592,-1008134.6500627995,1186973.5135513362,35470.802166240006,71019.469332480017,142661.85866496002,447919.01599488006,812976.49332480016,812976.49332480016,812976.49332480016,812976.49332480016,812976.49332480016,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D28=\"\",\"\",Project_Input!B28)","v":432},{"$f":"IF(Project_Input!$D28=\"\",\"\",Project_Input!C28)","v":"REPEX"},{"$f":"IF(Project_Input!$D28=\"\",\"\",Project_Input!D28)","v":"GRID COMMS Data Centre Ethernet Replacements (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D28=\"\",\"\",Project_Input!E28)","v":"Luke A"},{"$f":"IF(Project_Input!$D28=\"\",\"\",Project_Input!F28)","v":"EECL"},{"$f":"Project_Input!L28","v":2752135.274952},-113753.02698526629,951330.01287451677,-68325.725233751844,-152007.6684632239,-727219.56117849844,594302.0988250298,22346.6053647312,44742.265679462405,89876.970958924809,282188.98007677437,512175.19079462398,512175.19079462398,512175.19079462398,512175.19079462398,512175.19079462398,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D29=\"\",\"\",Project_Input!B29)","v":433},{"$f":"IF(Project_Input!$D29=\"\",\"\",Project_Input!C29)","v":"REPEX"},{"$f":"IF(Project_Input!$D29=\"\",\"\",Project_Input!D29)","v":"GRID COMMS Data Centre Ethernet Replacements (Option 3 - Reactive replace)"},{"$f":"IF(Project_Input!$D29=\"\",\"\",Project_Input!E29)","v":"Luke A"},{"$f":"IF(Project_Input!$D29=\"\",\"\",Project_Input!F29)","v":"EECL"},{"$f":"Project_Input!L29","v":2839504.85},-2393617.2549937158,0,-2511239.0523410877,-2282980.7668220173,-2393617.2549937158,-2393617.2549937158,0,0,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":"IF(Project_Input!$D30=\"\",\"\",Project_Input!B30)","v":471},{"$f":"IF(Project_Input!$D30=\"\",\"\",Project_Input!C30)","v":"REPEX"},{"$f":"IF(Project_Input!$D30=\"\",\"\",Project_Input!D30)","v":"GRID COMMS Operational Support Systems Replacements (Option 1) Preferred"},{"$f":"IF(Project_Input!$D30=\"\",\"\",Project_Input!E30)","v":"Luke A"},{"$f":"IF(Project_Input!$D30=\"\",\"\",Project_Input!F30)","v":"EECL"},{"$f":"Project_Input!L30","v":3987068.2399999998},413789.44973690796,2946915.0128000001,550754.93017242569,291499.70322315802,-570546.38167316373,1398125.2811469801,334876.70600000001,602778.07079999999,669753.41200000001,669753.41200000001,669753.41200000001,669753.41200000001,669753.41200000001,669753.41200000001,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D31=\"\",\"\",Project_Input!B31)","v":472},{"$f":"IF(Project_Input!$D31=\"\",\"\",Project_Input!C31)","v":"REPEX"},{"$f":"IF(Project_Input!$D31=\"\",\"\",Project_Input!D31)","v":"GRID COMMS Operational Support Systems Replacements (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D31=\"\",\"\",Project_Input!E31)","v":"Luke A"},{"$f":"IF(Project_Input!$D31=\"\",\"\",Project_Input!F31)","v":"EECL"},{"$f":"Project_Input!L31","v":2511852.9912},-48245.707252136199,1625334.6980639999,17497.990769827287,-106330.71791445458,-591144.01765110192,494652.6031468297,184697.12478000001,332454.82460400002,369394.24956000003,369394.24956000003,369394.24956000003,369394.24956000003,369394.24956000003,369394.24956000003,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D32=\"\",\"\",Project_Input!B32)","v":473},{"$f":"IF(Project_Input!$D32=\"\",\"\",Project_Input!C32)","v":"REPEX"},{"$f":"IF(Project_Input!$D32=\"\",\"\",Project_Input!D32)","v":"GRID COMMS Operational Support Systems Replacements (Option 3 - Wholesale replace)"},{"$f":"IF(Project_Input!$D32=\"\",\"\",Project_Input!E32)","v":"Luke A"},{"$f":"IF(Project_Input!$D32=\"\",\"\",Project_Input!F32)","v":"EECL"},{"$f":"Project_Input!L32","v":8800000},-7418135.5001783194,0,-7782660.9613706255,-7075258.4333192762,-7418135.5001783194,-7418135.5001783194,0,0,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":"IF(Project_Input!$D33=\"\",\"\",Project_Input!B33)","v":474},{"$f":"IF(Project_Input!$D33=\"\",\"\",Project_Input!C33)","v":"REPEX"},{"$f":"IF(Project_Input!$D33=\"\",\"\",Project_Input!D33)","v":"GRID COMMS Operational Support Systems Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D33=\"\",\"\",Project_Input!E33)","v":"Luke A"},{"$f":"IF(Project_Input!$D33=\"\",\"\",Project_Input!F33)","v":"EECL"},{"$f":"Project_Input!L33","v":4956175},-4379997.6728001423,0,-4535224.2391673131,-4231671.1678998917,-4379997.6728001423,-4379997.6728001423,0,0,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":"IF(Project_Input!$D34=\"\",\"\",Project_Input!B34)","v":191},{"$f":"IF(Project_Input!$D34=\"\",\"\",Project_Input!C34)","v":"REPEX"},{"$f":"IF(Project_Input!$D34=\"\",\"\",Project_Input!D34)","v":"GRID COMMS Fringe Network Replacement (Option 1 - Hybrid approach) "},{"$f":"IF(Project_Input!$D34=\"\",\"\",Project_Input!E34)","v":"Luke A"},{"$f":"IF(Project_Input!$D34=\"\",\"\",Project_Input!F34)","v":"EECL"},{"$f":"Project_Input!L34","v":868142.19000000018},2282.2916018614769,222408,34656.749924807256,-24811.757187575811,-176573.40416612421,181137.98736984734,9884.8000000000011,24712,29654.399999999998,59308.799999999996,98848,98848,98848,98848,98848,98848,98848,98848,98848,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D35=\"\",\"\",Project_Input!B35)","v":192},{"$f":"IF(Project_Input!$D35=\"\",\"\",Project_Input!C35)","v":"REPEX"},{"$f":"IF(Project_Input!$D35=\"\",\"\",Project_Input!D35)","v":"GRID COMMS Fringe Network Replacement (Option 2 - Standards develop) Preferred"},{"$f":"IF(Project_Input!$D35=\"\",\"\",Project_Input!E35)","v":"Luke A"},{"$f":"IF(Project_Input!$D35=\"\",\"\",Project_Input!F35)","v":"EECL"},{"$f":"Project_Input!L35","v":694513.75200000021},52149.818099205564,198216,88354.11715069841,21314.642124551869,-107251.19531913847,211550.83151754978,8809.6,22024,26428.799999999999,52857.599999999999,88096,88096,88096,88096,88096,88096,88096,88096,88096,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D36=\"\",\"\",Project_Input!B36)","v":193},{"$f":"IF(Project_Input!$D36=\"\",\"\",Project_Input!C36)","v":"REPEX"},{"$f":"IF(Project_Input!$D36=\"\",\"\",Project_Input!D36)","v":"GRID COMMS Fringe Network Replacement (Option 3 - AER proposed)"},{"$f":"IF(Project_Input!$D36=\"\",\"\",Project_Input!E36)","v":"Luke A"},{"$f":"IF(Project_Input!$D36=\"\",\"\",Project_Input!F36)","v":"EECL"},{"$f":"Project_Input!L36","v":546929.57970000012},-812106.14388066949,194400,-868990.17624255456,-760225.02976905287,-724340.91154837923,-899871.37621295941,12960,25920,38880,51840,64800,64800,64800,64800,64800,64800,64800,64800,64800,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D37=\"\",\"\",Project_Input!B37)","v":194},{"$f":"IF(Project_Input!$D37=\"\",\"\",Project_Input!C37)","v":"REPEX"},{"$f":"IF(Project_Input!$D37=\"\",\"\",Project_Input!D37)","v":"GRID COMMS Fringe Network Replacement (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D37=\"\",\"\",Project_Input!E37)","v":"Luke A"},{"$f":"IF(Project_Input!$D37=\"\",\"\",Project_Input!F37)","v":"EECL"},{"$f":"Project_Input!L37","v":2559600},-6133358.0389646469,0,-6645850.1982948314,-5670705.2128025256,-5125668.1263920935,-7141047.9515372012,0,0,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":"IF(Project_Input!$D38=\"\",\"\",Project_Input!B38)","v":661},{"$f":"IF(Project_Input!$D38=\"\",\"\",Project_Input!C38)","v":"REPEX"},{"$f":"IF(Project_Input!$D38=\"\",\"\",Project_Input!D38)","v":"GRID COMMS Microwave Radio Core Replacements (Option 1 - Spares mine) Preferred"},{"$f":"IF(Project_Input!$D38=\"\",\"\",Project_Input!E38)","v":"Luke A"},{"$f":"IF(Project_Input!$D38=\"\",\"\",Project_Input!F38)","v":"EECL"},{"$f":"Project_Input!L38","v":4000279.111680001},684131.47942277649,1440000,933441.18255485012,471403.57026404771,-329930.15691460145,1698193.1157601543,96000,192000,288000,384000,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D39=\"\",\"\",Project_Input!B39)","v":664},{"$f":"IF(Project_Input!$D39=\"\",\"\",Project_Input!C39)","v":"REPEX"},{"$f":"IF(Project_Input!$D39=\"\",\"\",Project_Input!D39)","v":"GRID COMMS Microwave Radio Core Replacements (Option 2 - Hybrid Pro/Reactive replace)"},{"$f":"IF(Project_Input!$D39=\"\",\"\",Project_Input!E39)","v":"Luke A"},{"$f":"IF(Project_Input!$D39=\"\",\"\",Project_Input!F39)","v":"EECL"},{"$f":"Project_Input!L39","v":6053756},-1046887.8120581903,1440000,-882639.99633443076,-1179605.4789697586,-2060949.4483955675,-32826.175720812331,96000,192000,288000,384000,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D40=\"\",\"\",Project_Input!B40)","v":665},{"$f":"IF(Project_Input!$D40=\"\",\"\",Project_Input!C40)","v":"REPEX"},{"$f":"IF(Project_Input!$D40=\"\",\"\",Project_Input!D40)","v":"GRID COMMS Microwave Radio Core Replacements (Option 3 - Wholesale replace)"},{"$f":"IF(Project_Input!$D40=\"\",\"\",Project_Input!E40)","v":"Luke A"},{"$f":"IF(Project_Input!$D40=\"\",\"\",Project_Input!F40)","v":"EECL"},{"$f":"Project_Input!L40","v":12800000},-6733768.7190021621,1440000,-6848972.9150448935,-6603630.4366850806,-7747830.3553395439,-5719707.0826647878,96000,192000,288000,384000,480000,480000,480000,480000,480000,480000,480000,480000,480000,480000,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D41=\"\",\"\",Project_Input!B41)","v":666},{"$f":"IF(Project_Input!$D41=\"\",\"\",Project_Input!C41)","v":"REPEX"},{"$f":"IF(Project_Input!$D41=\"\",\"\",Project_Input!D41)","v":"GRID COMMS Microwave Radio Core Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D41=\"\",\"\",Project_Input!E41)","v":"Luke A"},{"$f":"IF(Project_Input!$D41=\"\",\"\",Project_Input!F41)","v":"EECL"},{"$f":"Project_Input!L41","v":8533929},-7193845.6449949788,0,-7547349.5546064731,-6861335.5831341548,-7193845.6449949788,-7193845.6449949788,0,0,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":"IF(Project_Input!$D42=\"\",\"\",Project_Input!B42)","v":421},{"$f":"IF(Project_Input!$D42=\"\",\"\",Project_Input!C42)","v":"REPEX"},{"$f":"IF(Project_Input!$D42=\"\",\"\",Project_Input!D42)","v":"GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 1 - Spares mine) Preferred"},{"$f":"IF(Project_Input!$D42=\"\",\"\",Project_Input!E42)","v":"Luke A"},{"$f":"IF(Project_Input!$D42=\"\",\"\",Project_Input!F42)","v":"EECL"},{"$f":"Project_Input!L42","v":2709078},459208.27234802098,973744.2236250008,627626.77820656425,315516.83881416521,-226511.63097367142,1144928.1756697139,64916.281575000045,129832.56315000009,194748.84472500012,259665.12630000018,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D43=\"\",\"\",Project_Input!B43)","v":422},{"$f":"IF(Project_Input!$D43=\"\",\"\",Project_Input!C43)","v":"REPEX"},{"$f":"IF(Project_Input!$D43=\"\",\"\",Project_Input!D43)","v":"GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D43=\"\",\"\",Project_Input!E43)","v":"Luke A"},{"$f":"IF(Project_Input!$D43=\"\",\"\",Project_Input!F43)","v":"EECL"},{"$f":"Project_Input!L43","v":3738527.6400000025},-1420404.6428912082,614540.79891000036,-1398153.4749844391,-1432041.2157180626,-1853170.0929875651,-987639.19279485068,40969.386594000032,81938.773188000065,122908.15978200008,163877.54637600013,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,204846.93297000014,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D44=\"\",\"\",Project_Input!B44)","v":423},{"$f":"IF(Project_Input!$D44=\"\",\"\",Project_Input!C44)","v":"REPEX"},{"$f":"IF(Project_Input!$D44=\"\",\"\",Project_Input!D44)","v":"GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 3 - Wholesale replace)"},{"$f":"IF(Project_Input!$D44=\"\",\"\",Project_Input!E44)","v":"Luke A"},{"$f":"IF(Project_Input!$D44=\"\",\"\",Project_Input!F44)","v":"EECL"},{"$f":"Project_Input!L44","v":7212920.1750000045},-3337395.3003802332,973744.2236250008,-3355541.0155137712,-3305602.1664887681,-4023115.2037019241,-2651675.3970585414,64916.281575000045,129832.56315000009,194748.84472500012,259665.12630000018,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,324581.40787500021,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D45=\"\",\"\",Project_Input!B45)","v":424},{"$f":"IF(Project_Input!$D45=\"\",\"\",Project_Input!C45)","v":"REPEX"},{"$f":"IF(Project_Input!$D45=\"\",\"\",Project_Input!D45)","v":"GRID COMMS Microwave Radio Edge Capricornia and Mackay Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D45=\"\",\"\",Project_Input!E45)","v":"Luke A"},{"$f":"IF(Project_Input!$D45=\"\",\"\",Project_Input!F45)","v":"EECL"},{"$f":"Project_Input!L45","v":5418156.0000000037},-4567342.6628805548,0,-4791780.8237498319,-4356233.4085647911,-4567342.6628805548,-4567342.6628805548,0,0,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":"IF(Project_Input!$D46=\"\",\"\",Project_Input!B46)","v":411},{"$f":"IF(Project_Input!$D46=\"\",\"\",Project_Input!C46)","v":"REPEX"},{"$f":"IF(Project_Input!$D46=\"\",\"\",Project_Input!D46)","v":"GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 1 - Spares mine) Preferred"},{"$f":"IF(Project_Input!$D46=\"\",\"\",Project_Input!E46)","v":"Luke A"},{"$f":"IF(Project_Input!$D46=\"\",\"\",Project_Input!F46)","v":"EECL"},{"$f":"Project_Input!L46","v":4829226.0000000028},1034368.5891427337,1812408.517800001,1356670.3932939167,758615.02271488402,-241946.65201842636,2310683.830303893,120827.23452000006,241654.46904000011,362481.70356000017,483308.93808000023,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D47=\"\",\"\",Project_Input!B47)","v":412},{"$f":"IF(Project_Input!$D47=\"\",\"\",Project_Input!C47)","v":"REPEX"},{"$f":"IF(Project_Input!$D47=\"\",\"\",Project_Input!D47)","v":"GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D47=\"\",\"\",Project_Input!E47)","v":"Luke A"},{"$f":"IF(Project_Input!$D47=\"\",\"\",Project_Input!F47)","v":"EECL"},{"$f":"Project_Input!L47","v":6905793.1800000044},-2883014.7780368975,1043141.7913560006,-2868437.5650142613,-2880951.7902420484,-3617605.1057274346,-2148424.4503463651,69542.786090400041,139085.57218080008,208628.35827120009,278171.14436160016,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,347713.93045200018,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D48=\"\",\"\",Project_Input!B48)","v":413},{"$f":"IF(Project_Input!$D48=\"\",\"\",Project_Input!C48)","v":"REPEX"},{"$f":"IF(Project_Input!$D48=\"\",\"\",Project_Input!D48)","v":"GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 3 - Wholesale replace)"},{"$f":"IF(Project_Input!$D48=\"\",\"\",Project_Input!E48)","v":"Luke A"},{"$f":"IF(Project_Input!$D48=\"\",\"\",Project_Input!F48)","v":"EECL"},{"$f":"Project_Input!L48","v":13425248.280000007},-6211819.8054360915,1812408.517800001,-6245594.0221545333,-6152643.9509891476,-7488135.0465972507,-4935504.5642749323,120827.23452000006,241654.46904000011,362481.70356000017,483308.93808000023,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,604136.17260000028,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D49=\"\",\"\",Project_Input!B49)","v":414},{"$f":"IF(Project_Input!$D49=\"\",\"\",Project_Input!C49)","v":"REPEX"},{"$f":"IF(Project_Input!$D49=\"\",\"\",Project_Input!D49)","v":"GRID COMMS Microwave Radio Edge South West and Wide Bay (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D49=\"\",\"\",Project_Input!E49)","v":"Luke A"},{"$f":"IF(Project_Input!$D49=\"\",\"\",Project_Input!F49)","v":"EECL"},{"$f":"Project_Input!L49","v":9658452.0000000056},-8141784.73200686,0,-8541870.1489915978,-7765459.5397424437,-8141784.73200686,-8141784.73200686,0,0,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":"IF(Project_Input!$D50=\"\",\"\",Project_Input!B50)","v":501},{"$f":"IF(Project_Input!$D50=\"\",\"\",Project_Input!C50)","v":"REPEX"},{"$f":"IF(Project_Input!$D50=\"\",\"\",Project_Input!D50)","v":"GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 1 - Spares mine) Preferred"},{"$f":"IF(Project_Input!$D50=\"\",\"\",Project_Input!E50)","v":"Luke A"},{"$f":"IF(Project_Input!$D50=\"\",\"\",Project_Input!F50)","v":"EECL"},{"$f":"Project_Input!L50","v":4240296.0000000019},779228.43094552401,1545587.8920000009,1049026.7495872437,548825.39202834223,-309189.19882166962,1867646.060712717,103039.19280000006,206078.38560000013,309117.57840000017,412156.77120000025,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D51=\"\",\"\",Project_Input!B51)","v":502},{"$f":"IF(Project_Input!$D51=\"\",\"\",Project_Input!C51)","v":"REPEX"},{"$f":"IF(Project_Input!$D51=\"\",\"\",Project_Input!D51)","v":"GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D51=\"\",\"\",Project_Input!E51)","v":"Luke A"},{"$f":"IF(Project_Input!$D51=\"\",\"\",Project_Input!F51)","v":"EECL"},{"$f":"Project_Input!L51","v":6204966.4800000032},-2724820.9925099649,889571.6978400005,-2725472.8021608214,-2710755.7032153928,-3351265.8060870813,-2098376.1789328461,59304.779856000037,118609.55971200007,177914.33956800011,237219.11942400015,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,296523.89928000019,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D52=\"\",\"\",Project_Input!B52)","v":503},{"$f":"IF(Project_Input!$D52=\"\",\"\",Project_Input!C52)","v":"REPEX"},{"$f":"IF(Project_Input!$D52=\"\",\"\",Project_Input!D52)","v":"GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 3 - Wholesale replace)"},{"$f":"IF(Project_Input!$D52=\"\",\"\",Project_Input!E52)","v":"Luke A"},{"$f":"IF(Project_Input!$D52=\"\",\"\",Project_Input!F52)","v":"EECL"},{"$f":"Project_Input!L52","v":11448799.200000007},-5297323.0865691947,1545587.8920000009,-5326125.1033237576,-5246859.030973671,-6385740.7163363881,-4208905.4568020022,103039.19280000006,206078.38560000013,309117.57840000017,412156.77120000025,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,515195.96400000027,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D53=\"\",\"\",Project_Input!B53)","v":504},{"$f":"IF(Project_Input!$D53=\"\",\"\",Project_Input!C53)","v":"REPEX"},{"$f":"IF(Project_Input!$D53=\"\",\"\",Project_Input!D53)","v":"GRID COMMS Microwave Radio Edge Nth QLD and Far North Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D53=\"\",\"\",Project_Input!E53)","v":"Luke A"},{"$f":"IF(Project_Input!$D53=\"\",\"\",Project_Input!F53)","v":"EECL"},{"$f":"Project_Input!L53","v":8586599.4000000041},-7238245.2089777095,0,-7593930.9028888177,-6903682.9343614252,-7238245.2089777095,-7238245.2089777095,0,0,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":"IF(Project_Input!$D54=\"\",\"\",Project_Input!B54)","v":141},{"$f":"IF(Project_Input!$D54=\"\",\"\",Project_Input!C54)","v":"REPEX"},{"$f":"IF(Project_Input!$D54=\"\",\"\",Project_Input!D54)","v":"GRID COMMS Edge Router Replacement (Option 1 - Hybrid Proactive) Preferred"},{"$f":"IF(Project_Input!$D54=\"\",\"\",Project_Input!E54)","v":"Luke A"},{"$f":"IF(Project_Input!$D54=\"\",\"\",Project_Input!F54)","v":"EECL"},{"$f":"Project_Input!L54","v":3673597},423586.32116188534,1731409.2599999998,580234.52897792403,287764.1597874249,-456493.22550456849,1303665.8678283393,115427.284,230854.568,346281.85199999996,461709.136,577136.41999999993,577136.41999999993,577136.41999999993,577136.41999999993,577136.41999999993,577136.41999999993,577136.41999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D55=\"\",\"\",Project_Input!B55)","v":142},{"$f":"IF(Project_Input!$D55=\"\",\"\",Project_Input!C55)","v":"REPEX"},{"$f":"IF(Project_Input!$D55=\"\",\"\",Project_Input!D55)","v":"GRID COMMS Edge Router Replacement (Option 2 - Standards Dev with Proactive Replacement)"},{"$f":"IF(Project_Input!$D55=\"\",\"\",Project_Input!E55)","v":"Luke A"},{"$f":"IF(Project_Input!$D55=\"\",\"\",Project_Input!F55)","v":"EECL"},{"$f":"Project_Input!L55","v":3251133.3450000002},602048.21768039814,1634641.2599999998,760610.81262008299,463843.8194905509,-233615.76252860829,1437712.1978894046,108976.084,217952.16800000001,326928.25199999998,435904.33600000001,544880.41999999993,544880.41999999993,544880.41999999993,544880.41999999993,544880.41999999993,544880.41999999993,544880.41999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D56=\"\",\"\",Project_Input!B56)","v":143},{"$f":"IF(Project_Input!$D56=\"\",\"\",Project_Input!C56)","v":"REPEX"},{"$f":"IF(Project_Input!$D56=\"\",\"\",Project_Input!D56)","v":"GRID COMMS Edge Router Replacement (Option 3 - AER proposed)"},{"$f":"IF(Project_Input!$D56=\"\",\"\",Project_Input!E56)","v":"Luke A"},{"$f":"IF(Project_Input!$D56=\"\",\"\",Project_Input!F56)","v":"EECL"},{"$f":"Project_Input!L56","v":4310219.249340659},-1930074.8567178131,938041.26,-1959195.1859291759,-1897108.4838550813,-2355902.4639127352,-1504247.2495228914,62536.084000000003,125072.16800000001,187608.25199999998,250144.33600000001,312680.42,312680.42,312680.42,312680.42,312680.42,312680.42,312680.42,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D57=\"\",\"\",Project_Input!B57)","v":144},{"$f":"IF(Project_Input!$D57=\"\",\"\",Project_Input!C57)","v":"REPEX"},{"$f":"IF(Project_Input!$D57=\"\",\"\",Project_Input!D57)","v":"GRID COMMS Edge Router Replacement (Option 4 - Wholesale Replace)"},{"$f":"IF(Project_Input!$D57=\"\",\"\",Project_Input!E57)","v":"Luke A"},{"$f":"IF(Project_Input!$D57=\"\",\"\",Project_Input!F57)","v":"EECL"},{"$f":"Project_Input!L57","v":15634021},-10681785.13961526,1744129.2599999998,-11110328.901985886,-10270517.528740099,-11306091.299620755,-10057478.979609756,116275.284,232550.568,348825.85199999996,465101.136,581376.41999999993,581376.41999999993,581376.41999999993,581376.41999999993,581376.41999999993,581376.41999999993,581376.41999999993,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D58=\"\",\"\",Project_Input!B58)","v":145},{"$f":"IF(Project_Input!$D58=\"\",\"\",Project_Input!C58)","v":"REPEX"},{"$f":"IF(Project_Input!$D58=\"\",\"\",Project_Input!D58)","v":"GRID COMMS Edge Router Replacement (Option 5 - Reactive replace)"},{"$f":"IF(Project_Input!$D58=\"\",\"\",Project_Input!E58)","v":"Luke A"},{"$f":"IF(Project_Input!$D58=\"\",\"\",Project_Input!F58)","v":"EECL"},{"$f":"Project_Input!L58","v":6624585.3593406584},-6166631.2849828666,0,-6492126.6517158095,-5862372.4541093837,-6021055.0509363739,-6312207.5190293584,0,0,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":"IF(Project_Input!$D59=\"\",\"\",Project_Input!B59)","v":441},{"$f":"IF(Project_Input!$D59=\"\",\"\",Project_Input!C59)","v":"REPEX"},{"$f":"IF(Project_Input!$D59=\"\",\"\",Project_Input!D59)","v":"GRID COMMS Core IP MPLS Ethernet Replacements (Option 1 - Multi-faceted proactive approach) Preferred"},{"$f":"IF(Project_Input!$D59=\"\",\"\",Project_Input!E59)","v":"Luke A"},{"$f":"IF(Project_Input!$D59=\"\",\"\",Project_Input!F59)","v":"EECL"},{"$f":"Project_Input!L59","v":1358073.1680000001},95932.886663744503,347193.88531199994,141095.20985041899,57533.867931954519,-200545.36287150328,392411.13619899232,0,0,21699.617831999996,108498.08915999999,216996.17831999998,216996.17831999998,216996.17831999998,216996.17831999998,216996.17831999998,216996.17831999998,216996.17831999998,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D60=\"\",\"\",Project_Input!B60)","v":442},{"$f":"IF(Project_Input!$D60=\"\",\"\",Project_Input!C60)","v":"REPEX"},{"$f":"IF(Project_Input!$D60=\"\",\"\",Project_Input!D60)","v":"GRID COMMS Core IP MPLS Ethernet Replacements  (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D60=\"\",\"\",Project_Input!E60)","v":"Luke A"},{"$f":"IF(Project_Input!$D60=\"\",\"\",Project_Input!F60)","v":"EECL"},{"$f":"Project_Input!L60","v":855585.99},-267292.10317053169,122784.28531199996,-270590.20329175598,-262941.38793280593,-372140.92545616976,-162443.28088489326,0,0,7674.0178319999977,38370.089159999989,76740.178319999977,76740.178319999977,76740.178319999977,76740.178319999977,76740.178319999977,76740.178319999977,76740.178319999977,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D61=\"\",\"\",Project_Input!B61)","v":443},{"$f":"IF(Project_Input!$D61=\"\",\"\",Project_Input!C61)","v":"REPEX"},{"$f":"IF(Project_Input!$D61=\"\",\"\",Project_Input!D61)","v":"GRID COMMS Core IP MPLS Ethernet Replacements  (Option 3 - Reactive Replace)"},{"$f":"IF(Project_Input!$D61=\"\",\"\",Project_Input!E61)","v":"Luke A"},{"$f":"IF(Project_Input!$D61=\"\",\"\",Project_Input!F61)","v":"EECL"},{"$f":"Project_Input!L61","v":905382},-763209.83015864249,0,-800713.78394209454,-727933.15667220869,-763209.83015864249,-763209.83015864249,0,0,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":"IF(Project_Input!$D62=\"\",\"\",Project_Input!B62)","v":181},{"$f":"IF(Project_Input!$D62=\"\",\"\",Project_Input!C62)","v":"REPEX"},{"$f":"IF(Project_Input!$D62=\"\",\"\",Project_Input!D62)","v":"GRID COMMS Operational Voice Replacements (Option 1 - Multi-faceted) Preferred"},{"$f":"IF(Project_Input!$D62=\"\",\"\",Project_Input!E62)","v":"Luke A"},{"$f":"IF(Project_Input!$D62=\"\",\"\",Project_Input!F62)","v":"EECL"},{"$f":"Project_Input!L62","v":2029990.6439999999},81504.751211252005,615933.11999999988,134482.0910639604,36391.662927059893,-346185.5393617049,509195.04178420978,0,0,38495.82,192479.09999999998,384958.19999999995,384958.19999999995,384958.19999999995,384958.19999999995,384958.19999999995,384958.19999999995,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D63=\"\",\"\",Project_Input!B63)","v":182},{"$f":"IF(Project_Input!$D63=\"\",\"\",Project_Input!C63)","v":"REPEX"},{"$f":"IF(Project_Input!$D63=\"\",\"\",Project_Input!D63)","v":"GRID COMMS Operational Voice Replacements (Option 2 - AER proposed)"},{"$f":"IF(Project_Input!$D63=\"\",\"\",Project_Input!E63)","v":"Luke A"},{"$f":"IF(Project_Input!$D63=\"\",\"\",Project_Input!F63)","v":"EECL"},{"$f":"Project_Input!L63","v":1278894.1057199999},-204885.08357196738,333775.68,-195055.03641184428,-212023.47040559826,-410271.69918138348,501.5320374485857,0,0,20860.98,104304.9,208609.8,208609.8,208609.8,208609.8,208609.8,208609.8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D64=\"\",\"\",Project_Input!B64)","v":183},{"$f":"IF(Project_Input!$D64=\"\",\"\",Project_Input!C64)","v":"REPEX"},{"$f":"IF(Project_Input!$D64=\"\",\"\",Project_Input!D64)","v":"GRID COMMS Operational Voice Replacements (Option 3 - Reactive replace)"},{"$f":"IF(Project_Input!$D64=\"\",\"\",Project_Input!E64)","v":"Luke A"},{"$f":"IF(Project_Input!$D64=\"\",\"\",Project_Input!F64)","v":"EECL"},{"$f":"Project_Input!L64","v":3759982},-3509063.0361037413,0,-3692910.0710647311,-3337037.9191711536,-3424185.2330430448,-3593940.8391644382,0,0,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":"IF(Project_Input!$D65=\"\",\"\",Project_Input!B65)","v":391},{"$f":"IF(Project_Input!$D65=\"\",\"\",Project_Input!C65)","v":"REPEX"},{"$f":"IF(Project_Input!$D65=\"\",\"\",Project_Input!D65)","v":"GRID COMMS DC Systems Replacements (Option 1 Preferred)"},{"$f":"IF(Project_Input!$D65=\"\",\"\",Project_Input!E65)","v":"Brad S"},{"$f":"IF(Project_Input!$D65=\"\",\"\",Project_Input!F65)","v":"EECL"},{"$f":"Project_Input!L65","v":4938125},82489.365785186703,1529719.3,283533.03769690573,-88817.34890379112,-1018238.209673222,1228282.6489398438,60192.100000000006,181074.636,303452.18,428321.40400000004,556678.98,622477.36,622477.36,622477.36,622477.36,622477.36,622477.36,622477.36,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D66=\"\",\"\",Project_Input!B66)","v":392},{"$f":"IF(Project_Input!$D66=\"\",\"\",Project_Input!C66)","v":"REPEX"},{"$f":"IF(Project_Input!$D66=\"\",\"\",Project_Input!D66)","v":"GRID COMMS DC Systems Replacements (Option 2 AER proposed)"},{"$f":"IF(Project_Input!$D66=\"\",\"\",Project_Input!E66)","v":"Mel M"},{"$f":"IF(Project_Input!$D66=\"\",\"\",Project_Input!F66)","v":"EECL"},{"$f":"Project_Input!L66","v":7610696.75},28187.826309712036,2331490.8249999997,328078.2754221675,-226925.62349413036,-1622188.7769127248,1723630.1372283997,92262.960999999996,277287.21899999998,463806.48499999999,652817.43099999998,845316.72899999993,943185.97,943185.97,943185.97,943185.97,943185.97,943185.97,943185.97,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D67=\"\",\"\",Project_Input!B67)","v":393},{"$f":"IF(Project_Input!$D67=\"\",\"\",Project_Input!C67)","v":"REPEX"},{"$f":"IF(Project_Input!$D67=\"\",\"\",Project_Input!D67)","v":"GRID COMMS DC Systems Replacements (Option 3)"},{"$f":"IF(Project_Input!$D67=\"\",\"\",Project_Input!E67)","v":"Mel M"},{"$f":"IF(Project_Input!$D67=\"\",\"\",Project_Input!F67)","v":"EECL"},{"$f":"Project_Input!L67","v":9660133},-13452.793229066381,2946321.6999999997,362237.36767442216,-332832.64147050102,-2085322.530275458,2103482.6515135686,116856.196,351066.924,586772.66,824970.07599999988,1066655.8439999998,1189118.32,1189118.32,1189118.32,1189118.32,1189118.32,1189118.32,1189118.32,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D68=\"\",\"\",Project_Input!B68)","v":394},{"$f":"IF(Project_Input!$D68=\"\",\"\",Project_Input!C68)","v":"REPEX"},{"$f":"IF(Project_Input!$D68=\"\",\"\",Project_Input!D68)","v":"GRID COMMS DC Systems Replacements (Option 4 - Reactive replace)"},{"$f":"IF(Project_Input!$D68=\"\",\"\",Project_Input!E68)","v":"Mel M"},{"$f":"IF(Project_Input!$D68=\"\",\"\",Project_Input!F68)","v":"EECL"},{"$f":"Project_Input!L68","v":9903278},-4091868.0487108217,1533773.4999999998,-4095438.0174889909,-4070666.3257658691,-5195374.9534655157,-2943295.4362598783,60354.268000000004,181561.13999999998,304263.01999999996,429456.57999999996,558138.49199999985,624099.03999999992,624099.03999999992,624099.03999999992,624099.03999999992,624099.03999999992,624099.03999999992,624099.03999999992,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D69=\"\",\"\",Project_Input!B69)","v":561},{"$f":"IF(Project_Input!$D69=\"\",\"\",Project_Input!C69)","v":"AuGEX"},{"$f":"IF(Project_Input!$D69=\"\",\"\",Project_Input!D69)","v":"GRID COMMS Reliability Core MPLS (Option 1A - Original)"},{"$f":"IF(Project_Input!$D69=\"\",\"\",Project_Input!E69)","v":"Troy W"},{"$f":"IF(Project_Input!$D69=\"\",\"\",Project_Input!F69)","v":"EECL"},{"$f":"Project_Input!L69","v":2644515},-7818.7252859747523,1323766.3500000001,57308.70022174772,-64277.346136547909,-651768.2240659825,737379.3585714153,81274.386000000013,165538.78800000003,255783.22200000004,354997.70400000009,466172.25,466172.25,466172.25,466172.25,466172.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D70=\"\",\"\",Project_Input!B70)","v":562},{"$f":"IF(Project_Input!$D70=\"\",\"\",Project_Input!C70)","v":"AuGEX"},{"$f":"IF(Project_Input!$D70=\"\",\"\",Project_Input!D70)","v":"GRID COMMS Reliability Core MPLS (Option 1B - Preferred Multi-Technology)"},{"$f":"IF(Project_Input!$D70=\"\",\"\",Project_Input!E70)","v":"Troy W"},{"$f":"IF(Project_Input!$D70=\"\",\"\",Project_Input!F70)","v":"EECL"},{"$f":"Project_Input!L70","v":1623000},70922.711918614033,864084.6,117564.26752169782,30213.044258077774,-377435.53633131902,620529.5452459295,50628.936000000002,104247.88799999999,163846.87200000003,232415.90399999998,312945,312945,312945,312945,312945,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D71=\"\",\"\",Project_Input!B71)","v":563},{"$f":"IF(Project_Input!$D71=\"\",\"\",Project_Input!C71)","v":"AuGEX"},{"$f":"IF(Project_Input!$D71=\"\",\"\",Project_Input!D71)","v":"GRID COMMS Reliability Core MPLS (Option 1C - Expanded program)"},{"$f":"IF(Project_Input!$D71=\"\",\"\",Project_Input!E71)","v":"Troy W"},{"$f":"IF(Project_Input!$D71=\"\",\"\",Project_Input!F71)","v":"EECL"},{"$f":"Project_Input!L71","v":9987000},-2224070.5095697618,4627884.5999999996,-2154318.2221028465,-2276555.259827842,-3861330.5991692222,-485561.83489291946,301548.93599999999,606087.88799999992,916606.87200000021,1236095.9039999999,1567545,1567545,1567545,1567545,1567545,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D72=\"\",\"\",Project_Input!B72)","v":564},{"$f":"IF(Project_Input!$D72=\"\",\"\",Project_Input!C72)","v":"AuGEX"},{"$f":"IF(Project_Input!$D72=\"\",\"\",Project_Input!D72)","v":"GRID COMMS Reliability Core MPLS (Option 3 - Do Nothing)"},{"$f":"IF(Project_Input!$D72=\"\",\"\",Project_Input!E72)","v":"Troy W"},{"$f":"IF(Project_Input!$D72=\"\",\"\",Project_Input!F72)","v":"EECL"},{"$f":"Project_Input!L72","v":2805000},-2364530.7036235067,0,-2480723.1945674638,-2255238.6383780674,-2364530.7036235067,-2364530.7036235067,0,0,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":"IF(Project_Input!$D73=\"\",\"\",Project_Input!B73)","v":511},{"$f":"IF(Project_Input!$D73=\"\",\"\",Project_Input!C73)","v":"AuGEX"},{"$f":"IF(Project_Input!$D73=\"\",\"\",Project_Input!D73)","v":"GRID COMMS Reliability Edge Backhaul (Option 1A - Original)"},{"$f":"IF(Project_Input!$D73=\"\",\"\",Project_Input!E73)","v":"Troy W"},{"$f":"IF(Project_Input!$D73=\"\",\"\",Project_Input!F73)","v":"EECL"},{"$f":"Project_Input!L73","v":1818104},76197.970701210012,884986.20000000019,131004.16116369463,28384.755500007348,-547484.56200276595,953001.96609864093,41557.320000000007,90589.680000000022,154572.12000000005,240979.68000000002,357287.4,357287.4,357287.4,357287.4,357287.4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D74=\"\",\"\",Project_Input!B74)","v":512},{"$f":"IF(Project_Input!$D74=\"\",\"\",Project_Input!C74)","v":"AuGEX"},{"$f":"IF(Project_Input!$D74=\"\",\"\",Project_Input!D74)","v":"GRID COMMS Reliability Edge Backhaul (Option 1B - Preferred Multi Tech)"},{"$f":"IF(Project_Input!$D74=\"\",\"\",Project_Input!E74)","v":"Troy W"},{"$f":"IF(Project_Input!$D74=\"\",\"\",Project_Input!F74)","v":"EECL"},{"$f":"Project_Input!L74","v":1489000},123960.53019450877,786255,174551.42041157625,79631.127683174243,-442306.44751350983,943348.97059598239,34975.24,77425.52,134825.88000000003,214651.36000000002,324377,324377,324377,324377,324377,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D75=\"\",\"\",Project_Input!B75)","v":513},{"$f":"IF(Project_Input!$D75=\"\",\"\",Project_Input!C75)","v":"AuGEX"},{"$f":"IF(Project_Input!$D75=\"\",\"\",Project_Input!D75)","v":"GRID COMMS Reliability Edge Backhaul (Option 1C - Expanded scope)"},{"$f":"IF(Project_Input!$D75=\"\",\"\",Project_Input!E75)","v":"Troy W"},{"$f":"IF(Project_Input!$D75=\"\",\"\",Project_Input!F75)","v":"EECL"},{"$f":"Project_Input!L75","v":4006000},-1319039.2600659337,1541355,-1319962.3640178253,-1313491.9603853263,-2054995.1256103634,-329961.93182805012,85315.239999999991,178105.52,285845.88000000006,416011.36,576077,576077,576077,576077,576077,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D76=\"\",\"\",Project_Input!B76)","v":514},{"$f":"IF(Project_Input!$D76=\"\",\"\",Project_Input!C76)","v":"AuGEX"},{"$f":"IF(Project_Input!$D76=\"\",\"\",Project_Input!D76)","v":"GRID COMMS Reliability Edge Backhaul (Option 2 - Sat/Cell)"},{"$f":"IF(Project_Input!$D76=\"\",\"\",Project_Input!E76)","v":"Troy W"},{"$f":"IF(Project_Input!$D76=\"\",\"\",Project_Input!F76)","v":"EECL"},{"$f":"Project_Input!L76","v":587500},2247.6109740104566,515805,21665.383527583213,-14607.06530379823,-343606.78646624135,601223.47110771702,16945.240000000002,41365.520000000004,80735.880000000019,142531.36000000002,234227,234227,234227,234227,234227,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(Project_Input!$D77=\"\",\"\",Project_Input!B77)","v":515},{"$f":"IF(Project_Input!$D77=\"\",\"\",Project_Input!C77)","v":"AuGEX"},{"$f":"IF(Project_Input!$D77=\"\",\"\",Project_Input!D77)","v":"GRID COMMS Reliability Edge Backhaul (Option 3 - Do Nothing)"},{"$f":"IF(Project_Input!$D77=\"\",\"\",Project_Input!E77)","v":"Troy W"},{"$f":"IF(Project_Input!$D77=\"\",\"\",Project_Input!F77)","v":"EECL"},{"$f":"Project_Input!L77","v":11475000},-9673080.0924692489,0,-10148413.009110149,-9225976.1900278218,-9673080.0924692489,-9673080.0924692489,0,0,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":"IF(Project_Input!$D78=\"\",\"\",Project_Input!B78)","v":""},{"$f":"IF(Project_Input!$D78=\"\",\"\",Project_Input!C78)","v":""},{"$f":"IF(Project_Input!$D78=\"\",\"\",Project_Input!D78)","v":""},{"$f":"IF(Project_Input!$D78=\"\",\"\",Project_Input!E78)","v":""},{"$f":"IF(Project_Input!$D78=\"\",\"\",Project_Input!F78)","v":""},{"$f":"Project_Input!L78","v":0}]
[null,{"$f":"IF(Project_Input!$D79=\"\",\"\",Project_Input!B79)","v":""},{"$f":"IF(Project_Input!$D79=\"\",\"\",Project_Input!C79)","v":""},{"$f":"IF(Project_Input!$D79=\"\",\"\",Project_Input!D79)","v":""},{"$f":"IF(Project_Input!$D79=\"\",\"\",Project_Input!E79)","v":""},{"$f":"IF(Project_Input!$D79=\"\",\"\",Project_Input!F79)","v":""},{"$f":"Project_Input!L79","v":0}]
[null,{"$f":"IF(Project_Input!$D80=\"\",\"\",Project_Input!B80)","v":""},{"$f":"IF(Project_Input!$D80=\"\",\"\",Project_Input!C80)","v":""},{"$f":"IF(Project_Input!$D80=\"\",\"\",Project_Input!D80)","v":""},{"$f":"IF(Project_Input!$D80=\"\",\"\",Project_Input!E80)","v":""},{"$f":"IF(Project_Input!$D80=\"\",\"\",Project_Input!F80)","v":""},{"$f":"Project_Input!L80","v":0}]
[null,{"$f":"IF(Project_Input!$D81=\"\",\"\",Project_Input!B81)","v":""},{"$f":"IF(Project_Input!$D81=\"\",\"\",Project_Input!C81)","v":""},{"$f":"IF(Project_Input!$D81=\"\",\"\",Project_Input!D81)","v":""},{"$f":"IF(Project_Input!$D81=\"\",\"\",Project_Input!E81)","v":""},{"$f":"IF(Project_Input!$D81=\"\",\"\",Project_Input!F81)","v":""},{"$f":"Project_Input!L81","v":0}]
[null,{"$f":"IF(Project_Input!$D82=\"\",\"\",Project_Input!B82)","v":""},{"$f":"IF(Project_Input!$D82=\"\",\"\",Project_Input!C82)","v":""},{"$f":"IF(Project_Input!$D82=\"\",\"\",Project_Input!D82)","v":""},{"$f":"IF(Project_Input!$D82=\"\",\"\",Project_Input!E82)","v":""},{"$f":"IF(Project_Input!$D82=\"\",\"\",Project_Input!F82)","v":""},{"$f":"Project_Input!L82","v":0}]
[null,{"$f":"IF(Project_Input!$D83=\"\",\"\",Project_Input!B83)","v":""},{"$f":"IF(Project_Input!$D83=\"\",\"\",Project_Input!C83)","v":""},{"$f":"IF(Project_Input!$D83=\"\",\"\",Project_Input!D83)","v":""},{"$f":"IF(Project_Input!$D83=\"\",\"\",Project_Input!E83)","v":""},{"$f":"IF(Project_Input!$D83=\"\",\"\",Project_Input!F83)","v":""},{"$f":"Project_Input!L83","v":0}]
[null,{"$f":"IF(Project_Input!$D84=\"\",\"\",Project_Input!B84)","v":""},{"$f":"IF(Project_Input!$D84=\"\",\"\",Project_Input!C84)","v":""},{"$f":"IF(Project_Input!$D84=\"\",\"\",Project_Input!D84)","v":""},{"$f":"IF(Project_Input!$D84=\"\",\"\",Project_Input!E84)","v":""},{"$f":"IF(Project_Input!$D84=\"\",\"\",Project_Input!F84)","v":""},{"$f":"Project_Input!L84","v":0}]
[null,{"$f":"IF(Project_Input!$D85=\"\",\"\",Project_Input!B85)","v":""},{"$f":"IF(Project_Input!$D85=\"\",\"\",Project_Input!C85)","v":""},{"$f":"IF(Project_Input!$D85=\"\",\"\",Project_Input!D85)","v":""},{"$f":"IF(Project_Input!$D85=\"\",\"\",Project_Input!E85)","v":""},{"$f":"IF(Project_Input!$D85=\"\",\"\",Project_Input!F85)","v":""},{"$f":"Project_Input!L85","v":0}]
[null,{"$f":"IF(Project_Input!$D86=\"\",\"\",Project_Input!B86)","v":""},{"$f":"IF(Project_Input!$D86=\"\",\"\",Project_Input!C86)","v":""},{"$f":"IF(Project_Input!$D86=\"\",\"\",Project_Input!D86)","v":""},{"$f":"IF(Project_Input!$D86=\"\",\"\",Project_Input!E86)","v":""},{"$f":"IF(Project_Input!$D86=\"\",\"\",Project_Input!F86)","v":""},{"$f":"Project_Input!L86","v":0}]
[null,{"$f":"IF(Project_Input!$D87=\"\",\"\",Project_Input!B87)","v":""},{"$f":"IF(Project_Input!$D87=\"\",\"\",Project_Input!C87)","v":""},{"$f":"IF(Project_Input!$D87=\"\",\"\",Project_Input!D87)","v":""},{"$f":"IF(Project_Input!$D87=\"\",\"\",Project_Input!E87)","v":""},{"$f":"IF(Project_Input!$D87=\"\",\"\",Project_Input!F87)","v":""},{"$f":"Project_Input!L87","v":0}]
[null,{"$f":"IF(Project_Input!$D88=\"\",\"\",Project_Input!B88)","v":""},{"$f":"IF(Project_Input!$D88=\"\",\"\",Project_Input!C88)","v":""},{"$f":"IF(Project_Input!$D88=\"\",\"\",Project_Input!D88)","v":""},{"$f":"IF(Project_Input!$D88=\"\",\"\",Project_Input!E88)","v":""},{"$f":"IF(Project_Input!$D88=\"\",\"\",Project_Input!F88)","v":""},{"$f":"Project_Input!L88","v":0}]
[null,{"$f":"IF(Project_Input!$D89=\"\",\"\",Project_Input!B89)","v":""},{"$f":"IF(Project_Input!$D89=\"\",\"\",Project_Input!C89)","v":""},{"$f":"IF(Project_Input!$D89=\"\",\"\",Project_Input!D89)","v":""},{"$f":"IF(Project_Input!$D89=\"\",\"\",Project_Input!E89)","v":""},{"$f":"IF(Project_Input!$D89=\"\",\"\",Project_Input!F89)","v":""},{"$f":"Project_Input!L89","v":0}]
[null,{"$f":"IF(Project_Input!$D90=\"\",\"\",Project_Input!B90)","v":""},{"$f":"IF(Project_Input!$D90=\"\",\"\",Project_Input!C90)","v":""},{"$f":"IF(Project_Input!$D90=\"\",\"\",Project_Input!D90)","v":""},{"$f":"IF(Project_Input!$D90=\"\",\"\",Project_Input!E90)","v":""},{"$f":"IF(Project_Input!$D90=\"\",\"\",Project_Input!F90)","v":""},{"$f":"Project_Input!L90","v":0}]
[null,{"$f":"IF(Project_Input!$D91=\"\",\"\",Project_Input!B91)","v":""},{"$f":"IF(Project_Input!$D91=\"\",\"\",Project_Input!C91)","v":""},{"$f":"IF(Project_Input!$D91=\"\",\"\",Project_Input!D91)","v":""},{"$f":"IF(Project_Input!$D91=\"\",\"\",Project_Input!E91)","v":""},{"$f":"IF(Project_Input!$D91=\"\",\"\",Project_Input!F91)","v":""},{"$f":"Project_Input!L91","v":0}]
[null,{"$f":"IF(Project_Input!$D92=\"\",\"\",Project_Input!B92)","v":""},{"$f":"IF(Project_Input!$D92=\"\",\"\",Project_Input!C92)","v":""},{"$f":"IF(Project_Input!$D92=\"\",\"\",Project_Input!D92)","v":""},{"$f":"IF(Project_Input!$D92=\"\",\"\",Project_Input!E92)","v":""},{"$f":"IF(Project_Input!$D92=\"\",\"\",Project_Input!F92)","v":""},{"$f":"Project_Input!L92","v":0}]
[null,{"$f":"IF(Project_Input!$D93=\"\",\"\",Project_Input!B93)","v":""},{"$f":"IF(Project_Input!$D93=\"\",\"\",Project_Input!C93)","v":""},{"$f":"IF(Project_Input!$D93=\"\",\"\",Project_Input!D93)","v":""},{"$f":"IF(Project_Input!$D93=\"\",\"\",Project_Input!E93)","v":""},{"$f":"IF(Project_Input!$D93=\"\",\"\",Project_Input!F93)","v":""},{"$f":"Project_Input!L93","v":0}]
[null,{"$f":"IF(Project_Input!$D99=\"\",\"\",Project_Input!B99)","v":""},{"$f":"IF(Project_Input!$D99=\"\",\"\",Project_Input!C99)","v":""},{"$f":"IF(Project_Input!$D99=\"\",\"\",Project_Input!D99)","v":""},{"$f":"IF(Project_Input!$D99=\"\",\"\",Project_Input!E99)","v":""},{"$f":"IF(Project_Input!$D99=\"\",\"\",Project_Input!F99)","v":""},{"$f":"Project_Input!L99","v":0}]
[null,{"$f":"IF(Project_Input!$D100=\"\",\"\",Project_Input!B100)","v":""},{"$f":"IF(Project_Input!$D100=\"\",\"\",Project_Input!C100)","v":""},{"$f":"IF(Project_Input!$D100=\"\",\"\",Project_Input!D100)","v":""},{"$f":"IF(Project_Input!$D100=\"\",\"\",Project_Input!E100)","v":""},{"$f":"IF(Project_Input!$D100=\"\",\"\",Project_Input!F100)","v":""},{"$f":"Project_Input!L100","v":0}]
[null,{"$f":"IF(Project_Input!$D101=\"\",\"\",Project_Input!B101)","v":""},{"$f":"IF(Project_Input!$D101=\"\",\"\",Project_Input!C101)","v":""},{"$f":"IF(Project_Input!$D101=\"\",\"\",Project_Input!D101)","v":""},{"$f":"IF(Project_Input!$D101=\"\",\"\",Project_Input!E101)","v":""},{"$f":"IF(Project_Input!$D101=\"\",\"\",Project_Input!F101)","v":""},{"$f":"Project_Input!L101","v":0}]
[null,{"$f":"IF(Project_Input!$D102=\"\",\"\",Project_Input!B102)","v":""},{"$f":"IF(Project_Input!$D102=\"\",\"\",Project_Input!C102)","v":""},{"$f":"IF(Project_Input!$D102=\"\",\"\",Project_Input!D102)","v":""},{"$f":"IF(Project_Input!$D102=\"\",\"\",Project_Input!E102)","v":""},{"$f":"IF(Project_Input!$D102=\"\",\"\",Project_Input!F102)","v":""},{"$f":"Project_Input!L102","v":0}]
[null,{"$f":"IF(Project_Input!$D103=\"\",\"\",Project_Input!B103)","v":""},{"$f":"IF(Project_Input!$D103=\"\",\"\",Project_Input!C103)","v":""},{"$f":"IF(Project_Input!$D103=\"\",\"\",Project_Input!D103)","v":""},{"$f":"IF(Project_Input!$D103=\"\",\"\",Project_Input!E103)","v":""},{"$f":"IF(Project_Input!$D103=\"\",\"\",Project_Input!F103)","v":""},{"$f":"Project_Input!L103","v":0}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G5:G84)","v":432530865.69790608},{"$f":"SUBTOTAL(9,H5:H84)","v":-168822391.09094661},96465080.141060889,-168864862.92091963,-168009309.59402263,-218406257.48550373,-117407117.84928286,5174288.1881896192,12175433.489075217,19234682.352950789,26330562.029189058,33550114.081656191,33902204.726656191,33902204.726656191,33902204.726656191,32863057.065096192,20196787.257811997,15413782.857812002,13103972.821172003,9725092.1311720032,9473348.1311720032,1569087.4910400002,1569087.4910400002,1569087.4910400002,0,0,0,0,0,0,0,0,0]

{"sheet":"Sensitivity","index":3,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,1,16,1],[4,3,4,13]]}
[]
[null,"NPV (Base Case)",null,null,{"$f":"NPV_1","v":860541.31527332356},null,null,null,null,null,null,null,null,"Base Case)"]
[]
[null,"NPV Sensitivity Analysis",null,null,null,"Project Index",{"$f":"Index_1","v":361},null,"Project Name",{"$f":"DCF!C4","v":"GRID COMMS AC Systems Replacements (Option1 - Risk based program) Preferred"}]
[null,null,null,"WACC Sensitivity"]
[null,null,null,{"$f":"Hidden!H12","v":9.9999999999999985E-3},{"$f":"Hidden!I12","v":1.4999999999999999E-2},{"$f":"Hidden!J12","v":0.02},{"$f":"Hidden!K12","v":2.5000000000000001E-2},{"$f":"Hidden!L12","v":3.0000000000000002E-2},{"$f":"Hidden!M12","v":3.5000000000000003E-2},{"$f":"Hidden!N12","v":0.04},{"$f":"Hidden!O12","v":4.4999999999999998E-2},{"$f":"Hidden!P12","v":4.9999999999999996E-2},{"$f":"Hidden!Q12","v":5.4999999999999993E-2},{"$f":"Hidden!R12","v":5.9999999999999991E-2}]
[null,"Benefit Sensitivity",{"$f":"Hidden!G13","v":1.2500000000000002},{"$f":"Hidden!H13","v":3353376.1025560456},{"$f":"Hidden!I13","v":3035987.3762662532},{"$f":"Hidden!J13","v":2744020.5095057413},{"$f":"Hidden!K13","v":2475368.2302910197},{"$f":"Hidden!L13","v":2228108.9613793865},{"$f":"Hidden!M13","v":2000489.4153933725},{"$f":"Hidden!N13","v":1790908.9170908828},{"$f":"Hidden!O13","v":1597905.2722529459},{"$f":"Hidden!P13","v":1420142.0224450722},{"$f":"Hidden!Q13","v":1256396.942429021},{"$f":"Hidden!R13","v":1105551.6525265439}]
[null,null,{"$f":"Hidden!G14","v":1.2000000000000002},{"$f":"Hidden!H14","v":3051269.5637953449},{"$f":"Hidden!I14","v":2750810.5611509546},{"$f":"Hidden!J14","v":2474621.0571477087},{"$f":"Hidden!K14","v":2220683.2834915407},{"$f":"Hidden!L14","v":1987157.5039326414},{"$f":"Hidden!M14","v":1772365.3178540356},{"$f":"Hidden!N14","v":1574774.6211785581},{"$f":"Hidden!O14","v":1392986.0513391383},{"$f":"Hidden!P14","v":1225720.7620458235},{"$f":"Hidden!Q14","v":1071809.3903991766},{"$f":"Hidden!R14","v":930182.09379996033}]
[null,null,{"$f":"Hidden!G15","v":1.1500000000000001},{"$f":"Hidden!H15","v":2749257.1176985665},{"$f":"Hidden!I15","v":2465722.3516869643},{"$f":"Hidden!J15","v":2205305.1022155178},{"$f":"Hidden!K15","v":1966077.0751054895},{"$f":"Hidden!L15","v":1746280.3480629248},{"$f":"Hidden!M15","v":1544311.382496608},{"$f":"Hidden!N15","v":1358706.6228502579},{"$f":"Hidden!O15","v":1188129.5174644683},{"$f":"Hidden!P15","v":1031358.8131771036},{"$f":"Hidden!Q15","v":887277.99198270659},{"$f":"Hidden!R15","v":754865.7323474806}]
[null,null,{"$f":"Hidden!G16","v":1.1000000000000001},{"$f":"Hidden!H16","v":2447334.8437380535},{"$f":"Hidden!I16","v":2180719.0559721468},{"$f":"Hidden!J16","v":1936069.1656497631},{"$f":"Hidden!K16","v":1711546.3243656422},{"$f":"Hidden!L16","v":1505474.3978711956},{"$f":"Hidden!M16","v":1316324.6858968444},{"$f":"Hidden!N16","v":1142702.1597066503},{"$f":"Hidden!O16","v":983333.05866897351},{"$f":"Hidden!P16","v":837053.70452514186},{"$f":"Hidden!Q16","v":702800.40744572051},{"$f":"Hidden!R16","v":579600.35161601799}]
[null,null,{"$f":"Hidden!G17","v":1.05},{"$f":"Hidden!H17","v":2145498.821386137},{"$f":"Hidden!I17","v":1895796.9821043608},{"$f":"Hidden!J17","v":1666909.7683910299},{"$f":"Hidden!K17","v":1457087.7505047717},{"$f":"Hidden!L17","v":1264736.5574584086},{"$f":"Hidden!M17","v":1088402.3046304975},{"$f":"Hidden!N17","v":926758.46934839897},{"$f":"Hidden!O17","v":778594.06299268955},{"$f":"Hidden!P17","v":642802.96477616357},{"$f":"Hidden!Q17","v":518374.29705432802},{"$f":"Hidden!R17","v":404383.73505248321}]
[null,null,{"$f":"Hidden!G18","v":1},{"$f":"Hidden!H18","v":1843745.1301151568},{"$f":"Hidden!I18","v":1610952.438181472},{"$f":"Hidden!J18","v":1397823.4313799115},{"$f":"Hidden!K18","v":1202698.0727556518},{"$f":"Hidden!L18","v":1024063.7309255237},{"$f":"Hidden!M18","v":860541.31527332356},{"$f":"Hidden!N18","v":710872.78937617084},{"$f":"Hidden!O18","v":573909.91847565258},{"$f":"Hidden!P18","v":448604.1226163992},{"$f":"Hidden!Q18","v":333997.32107463764},{"$f":"Hidden!R18","v":229213.66610379089}]
[null,null,{"$f":"Hidden!G19","v":0.95},{"$f":"Hidden!H19","v":1542069.8493974465},{"$f":"Hidden!I19","v":1326181.7323013397},{"$f":"Hidden!J19","v":1128806.6755569959},{"$f":"Hidden!K19","v":948374.01035105612},{"$f":"Hidden!L19","v":783452.82237349555},{"$f":"Hidden!M19","v":632738.79440107325},{"$f":"Hidden!N19","v":495042.35739063029},{"$f":"Hidden!O19","v":369278.01315789804},{"$f":"Hidden!P19","v":254454.70673207525},{"$f":"Hidden!Q19","v":149667.1397727608},{"$f":"Hidden!R19","v":54087.928216850334}]
[null,null,{"$f":"Hidden!G20","v":0.89999999999999991},{"$f":"Hidden!H20","v":1240469.0587053436},{"$f":"Hidden!I20","v":1041481.172561827},{"$f":"Hidden!J20","v":859856.02186287148},{"$f":"Hidden!K20","v":694112.28252375778},{"$f":"Hidden!L20","v":542900.73590328125},{"$f":"Hidden!M20","v":404991.81858950114},{"$f":"Hidden!N20","v":279264.41099244414},{"$f":"Hidden!O20","v":164695.73507946022},{"$f":"Hidden!P20","v":60352.245809418986},{"$f":"Hidden!Q20","v":-34618.586585195975},{"$f":"Hidden!R20","v":-120995.69516142421}]
[null,null,{"$f":"Hidden!G21","v":0.84999999999999987},{"$f":"Hidden!H21","v":938938.8375111866},{"$f":"Hidden!I21","v":756847.06706079608},{"$f":"Hidden!J21","v":590967.99123813119},{"$f":"Hidden!K21","v":439909.60850653198},{"$f":"Hidden!L21","v":302404.37561584008},{"$f":"Hidden!M21","v":177297.46441436294},{"$f":"Hidden!N21","v":63536.187782277164},{"$f":"Hidden!O21","v":-39839.527719621365},{"$f":"Hidden!P21","v":-133705.73146533957},{"$f":"Hidden!Q21","v":-218862.19773312152},{"$f":"Hidden!R21","v":-296039.42058411968}]
[null,null,{"$f":"Hidden!G22","v":0.79999999999999982},{"$f":"Hidden!H22","v":637475.26528731023},{"$f":"Hidden!I22","v":472275.7238961102},{"$f":"Hidden!J22","v":322139.10462336434},{"$f":"Hidden!K22","v":185762.70753215207},{"$f":"Hidden!L22","v":61960.645612128428},{"$f":"Hidden!M22","v":-50347.191548588547},{"$f":"Hidden!N22","v":-152145.07463920515},{"$f":"Hidden!O22","v":-244330.38719931321},{"$f":"Hidden!P22","v":-327721.69640597334},{"$f":"Hidden!Q22","v":-403066.03340490564},{"$f":"Hidden!R22","v":-471045.46460432542}]
[null,null,{"$f":"Hidden!G23","v":0.74999999999999978},{"$f":"Hidden!H23","v":336074.42150604876},{"$f":"Hidden!I23","v":187763.45116562973},{"$f":"Hidden!J23","v":53365.882959157825},{"$f":"Hidden!K23","v":-68331.701166610292},{"$f":"Hidden!L23","v":-178433.55000689926},{"$f":"Hidden!M23","v":-277945.07272360194},{"$f":"Hidden!N23","v":-367782.13867133798},{"$f":"Hidden!O23","v":-448779.4553195801},{"$f":"Hidden!P23","v":-521698.12032625498},{"$f":"Hidden!Q23","v":-587232.43333444127},{"$f":"Hidden!R23","v":-646016.04377512936}]

{"sheet":"Hidden","index":4,"n_rows":1014,"n_cols":18,"rows_kept":1014,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Model General Input"]
[null,"Model Start Year",2023,"Year"]
[null,"Program Start Year",2026,"Year"]
[null,"Pre-Tax Real WACC",3.5000000000000003E-2,"%"]
[null,"Benefit Sensitivity",1,"%"]
[null,"VCR ",51.91,"$/KWh"]
[null,"Carbon Conversion Rate",8.5000000000000006E-3,"Ton/MWh"]
[null,"Carbon Price",30,"$/Ton"]
[null,null,null,null,null,null,"NPV",{"$f":"NPV_1","v":860541.31527332356}]
[null,"Yes",null,null,null,null,"Sensitivity Table",1,{"$f":"H11+1","v":2},{"$f":"I11+1","v":3},4,5,{"$f":"L11+1","v":6},7,8,9,10,11]
[null,"No",null,null,null,null,{"$f":"H10","v":860541.31527332356},{"$f":"I12-0.5%","v":9.9999999999999985E-3},1.4999999999999999E-2,0.02,2.5000000000000001E-2,{"$f":"M12-0.5%","v":3.0000000000000002E-2},3.5000000000000003E-2,{"$f":"M12+0.5%","v":0.04},{"$f":"N12+0.5%","v":4.4999999999999998E-2},{"$f":"O12+0.5%","v":4.9999999999999996E-2},5.4999999999999993E-2,5.9999999999999991E-2]
[null,null,null,null,null,1,{"$f":"G14+5%","v":1.2500000000000002},3353376.1025560456,3035987.3762662532,2744020.5095057413,2475368.2302910197,2228108.9613793865,2000489.4153933725,1790908.9170908828,1597905.2722529459,1420142.0224450722,1256396.942429021,1105551.6525265439]
[null,null,null,null,null,{"$f":"F13+1","v":2},1.2000000000000002,3051269.5637953449,2750810.5611509546,2474621.0571477087,2220683.2834915407,1987157.5039326414,1772365.3178540356,1574774.6211785581,1392986.0513391383,1225720.7620458235,1071809.3903991766,930182.09379996033]
[null,1,null,null,null,{"$f":"F14+1","v":3},1.1500000000000001,2749257.1176985665,2465722.3516869643,2205305.1022155178,1966077.0751054895,1746280.3480629248,1544311.382496608,1358706.6228502579,1188129.5174644683,1031358.8131771036,887277.99198270659,754865.7323474806]
[null,{"$f":"B15+1","v":2},null,null,null,4,1.1000000000000001,2447334.8437380535,2180719.0559721468,1936069.1656497631,1711546.3243656422,1505474.3978711956,1316324.6858968444,1142702.1597066503,983333.05866897351,837053.70452514186,702800.40744572051,579600.35161601799]
[null,{"$f":"B16+1","v":3},null,null,null,5,{"$f":"G18+5%","v":1.05},2145498.821386137,1895796.9821043608,1666909.7683910299,1457087.7505047717,1264736.5574584086,1088402.3046304975,926758.46934839897,778594.06299268955,642802.96477616357,518374.29705432802,404383.73505248321]
[null,4,null,null,null,6,1,1843745.1301151568,1610952.438181472,1397823.4313799115,1202698.0727556518,1024063.7309255237,860541.31527332356,710872.78937617084,573909.91847565258,448604.1226163992,333997.32107463764,229213.66610379089]
[null,5,null,null,null,7,{"$f":"G18-5%","v":0.95},1542069.8493974465,1326181.7323013397,1128806.6755569959,948374.01035105612,783452.82237349555,632738.79440107325,495042.35739063029,369278.01315789804,254454.70673207525,149667.1397727608,54087.928216850334]
[null,6,null,null,null,8,{"$f":"G19-5%","v":0.89999999999999991},1240469.0587053436,1041481.172561827,859856.02186287148,694112.28252375778,542900.73590328125,404991.81858950114,279264.41099244414,164695.73507946022,60352.245809418986,-34618.586585195975,-120995.69516142421]
[null,7,null,null,null,9,0.84999999999999987,938938.8375111866,756847.06706079608,590967.99123813119,439909.60850653198,302404.37561584008,177297.46441436294,63536.187782277164,-39839.527719621365,-133705.73146533957,-218862.19773312152,-296039.42058411968]
[null,8,null,null,null,10,0.79999999999999982,637475.26528731023,472275.7238961102,322139.10462336434,185762.70753215207,61960.645612128428,-50347.191548588547,-152145.07463920515,-244330.38719931321,-327721.69640597334,-403066.03340490564,-471045.46460432542]
[null,9,null,null,null,11,{"$f":"G22-5%","v":0.74999999999999978},336074.42150604876,187763.45116562973,53365.882959157825,-68331.701166610292,-178433.55000689926,-277945.07272360194,-367782.13867133798,-448779.4553195801,-521698.12032625498,-587232.43333444127,-646016.04377512936]
[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]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,{"$f":"B115+1","v":102}]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]
[null,126]
[null,127]
[null,128]
[null,129]
[null,130]
[null,131]
[null,132]
[null,133]
[null,134]
[null,135]
[null,136]
[null,137]
[null,138]
[null,139]
[null,140]
[null,141]
[null,142]
[null,143]
[null,144]
[null,145]
[null,146]
[null,147]
[null,148]
[null,149]
[null,150]
[null,151]
[null,152]
[null,153]
[null,154]
[null,155]
[null,156]
[null,157]
[null,158]
[null,159]
[null,160]
[null,161]
[null,162]
[null,163]
[null,164]
[null,165]
[null,{"$f":"B179+1","v":166}]
[null,167]
[null,168]
[null,169]
[null,170]
[null,171]
[null,172]
[null,173]
[null,174]
[null,175]
[null,176]
[null,177]
[null,178]
[null,179]
[null,180]
[null,181]
[null,182]
[null,183]
[null,184]
[null,185]
[null,186]
[null,187]
[null,188]
[null,189]
[null,190]
[null,191]
[null,192]
[null,193]
[null,194]
[null,195]
[null,196]
[null,197]
[null,198]
[null,199]
[null,200]
[null,201]
[null,202]
[null,203]
[null,204]
[null,205]
[null,206]
[null,207]
[null,208]
[null,209]
[null,210]
[null,211]
[null,212]
[null,213]
[null,214]
[null,215]
[null,216]
[null,217]
[null,218]
[null,219]
[null,220]
[null,221]
[null,222]
[null,223]
[null,224]
[null,225]
[null,226]
[null,227]
[null,228]
[null,229]
[null,{"$f":"B243+1","v":230}]
[null,231]
[null,232]
[null,233]
[null,234]
[null,235]
[null,236]
[null,237]
[null,238]
[null,239]
[null,240]
[null,241]
[null,242]
[null,243]
[null,244]
[null,245]
[null,246]
[null,247]
[null,248]
[null,249]
[null,250]
[null,251]
[null,252]
[null,253]
[null,254]
[null,255]
[null,256]
[null,257]
[null,258]
[null,259]
[null,260]
[null,261]
[null,262]
[null,263]
[null,264]
[null,265]
[null,266]
[null,267]
[null,268]
[null,269]
[null,270]
[null,271]
[null,272]
[null,273]
[null,274]
[null,275]
[null,276]
[null,277]
[null,278]
[null,279]
[null,280]
[null,281]
[null,282]
[null,283]
[null,284]
[null,285]
[null,286]
[null,287]
[null,288]
[null,289]
[null,290]
[null,291]
[null,292]
[null,293]
[null,{"$f":"B307+1","v":294}]
[null,295]
[null,296]
[null,297]
[null,298]
[null,299]
[null,300]
[null,301]
[null,302]
[null,303]
[null,304]
[null,305]
[null,306]
[null,307]
[null,308]
[null,309]
[null,310]
[null,311]
[null,312]
[null,313]
[null,314]
[null,315]
[null,316]
[null,317]
[null,318]
[null,319]
[null,320]
[null,321]
[null,322]
[null,323]
[null,324]
[null,325]
[null,326]
[null,327]
[null,328]
[null,329]
[null,330]
[null,331]
[null,332]
[null,333]
[null,334]
[null,335]
[null,336]
[null,337]
[null,338]
[null,339]
[null,340]
[null,341]
[null,342]
[null,343]
[null,344]
[null,345]
[null,346]
[null,347]
[null,348]
[null,349]
[null,350]
[null,351]
[null,352]
[null,353]
[null,354]
[null,355]
[null,356]
[null,357]
[null,{"$f":"B371+1","v":358}]
[null,359]
[null,360]
[null,361]
[null,362]
[null,363]
[null,364]
[null,365]
[null,366]
[null,367]
[null,368]
[null,369]
[null,370]
[null,371]
[null,372]
[null,373]
[null,374]
[null,375]
[null,376]
[null,377]
[null,378]
[null,379]
[null,380]
[null,381]
[null,382]
[null,383]
[null,384]
[null,385]
[null,386]
[null,387]
[null,388]
[null,389]
[null,390]
[null,391]
[null,392]
[null,393]
[null,394]
[null,395]
[null,396]
[null,397]
[null,398]
[null,399]
[null,400]
[null,401]
[null,402]
[null,403]
[null,404]
[null,405]
[null,406]
[null,407]
[null,408]
[null,409]
[null,410]
[null,411]
[null,412]
[null,413]
[null,414]
[null,415]
[null,416]
[null,417]
[null,418]
[null,419]
[null,420]
[null,421]
[null,{"$f":"B435+1","v":422}]
[null,423]
[null,424]
[null,425]
[null,426]
[null,427]
[null,428]
[null,429]
[null,430]
[null,431]
[null,432]
[null,433]
[null,434]
[null,435]
[null,436]
[null,437]
[null,438]
[null,439]
[null,440]
[null,441]
[null,442]
[null,443]
[null,444]
[null,445]
[null,446]
[null,447]
[null,448]
[null,449]
[null,450]
[null,451]
[null,452]
[null,453]
[null,454]
[null,455]
[null,456]
[null,457]
[null,458]
[null,459]
[null,460]
[null,461]
[null,462]
[null,463]
[null,464]
[null,465]
[null,466]
[null,467]
[null,468]
[null,469]
[null,470]
[null,471]
[null,472]
[null,473]
[null,474]
[null,475]
[null,476]
[null,477]
[null,478]
[null,479]
[null,480]
[null,481]
[null,482]
[null,483]
[null,484]
[null,485]
[null,{"$f":"B499+1","v":486}]
[null,487]
[null,488]
[null,489]
[null,490]
[null,491]
[null,492]
[null,493]
[null,494]
[null,495]
[null,496]
[null,497]
[null,498]
[null,499]
[null,500]
[null,501]
[null,502]
[null,503]
[null,504]
[null,505]
[null,506]
[null,507]
[null,508]
[null,509]
[null,510]
[null,511]
[null,512]
[null,513]
[null,514]
[null,515]
[null,516]
[null,517]
[null,518]
[null,519]
[null,520]
[null,521]
[null,522]
[null,523]
[null,524]
[null,525]
[null,526]
[null,527]
[null,528]
[null,529]
[null,530]
[null,531]
[null,532]
[null,533]
[null,534]
[null,535]
[null,536]
[null,537]
[null,538]
[null,539]
[null,540]
[null,541]
[null,542]
[null,543]
[null,544]
[null,545]
[null,546]
[null,547]
[null,548]
[null,549]
[null,{"$f":"B563+1","v":550}]
[null,551]
[null,552]
[null,553]
[null,554]
[null,555]
[null,556]
[null,557]
[null,558]
[null,559]
[null,560]
[null,561]
[null,562]
[null,563]
[null,564]
[null,565]
[null,566]
[null,567]
[null,568]
[null,569]
[null,570]
[null,571]
[null,572]
[null,573]
[null,574]
[null,575]
[null,576]
[null,577]
[null,578]
[null,579]
[null,580]
[null,581]
[null,582]
[null,583]
[null,584]
[null,585]
[null,586]
[null,587]
[null,588]
[null,589]
[null,590]
[null,591]
[null,592]
[null,593]
[null,594]
[null,595]
[null,596]
[null,597]
[null,598]
[null,599]
[null,600]
[null,601]
[null,602]
[null,603]
[null,604]
[null,605]
[null,606]
[null,607]
[null,608]
[null,609]
[null,610]
[null,611]
[null,612]
[null,613]
[null,{"$f":"B627+1","v":614}]
[null,615]
[null,616]
[null,617]
[null,618]
[null,619]
[null,620]
[null,621]
[null,622]
[null,623]
[null,624]
[null,625]
[null,626]
[null,627]
[null,628]
[null,629]
[null,630]
[null,631]
[null,632]
[null,633]
[null,634]
[null,635]
[null,636]
[null,637]
[null,638]
[null,639]
[null,640]
[null,641]
[null,642]
[null,643]
[null,644]
[null,645]
[null,646]
[null,647]
[null,648]
[null,649]
[null,650]
[null,651]
[null,652]
[null,653]
[null,654]
[null,655]
[null,656]
[null,657]
[null,658]
[null,659]
[null,660]
[null,661]
[null,662]
[null,663]
[null,664]
[null,665]
[null,666]
[null,667]
[null,668]
[null,669]
[null,670]
[null,671]
[null,672]
[null,673]
[null,674]
[null,675]
[null,676]
[null,677]
[null,{"$f":"B691+1","v":678}]
[null,679]
[null,680]
[null,681]
[null,682]
[null,683]
[null,684]
[null,685]
[null,686]
[null,687]
[null,688]
[null,689]
[null,690]
[null,691]
[null,692]
[null,693]
[null,694]
[null,695]
[null,696]
[null,697]
[null,698]
[null,699]
[null,700]
[null,701]
[null,702]
[null,703]
[null,704]
[null,705]
[null,706]
[null,707]
[null,708]
[null,709]
[null,710]
[null,711]
[null,712]
[null,713]
[null,714]
[null,715]
[null,716]
[null,717]
[null,718]
[null,719]
[null,720]
[null,721]
[null,722]
[null,723]
[null,724]
[null,725]
[null,726]
[null,727]
[null,728]
[null,729]
[null,730]
[null,731]
[null,732]
[null,733]
[null,734]
[null,735]
[null,736]
[null,737]
[null,738]
[null,739]
[null,740]
[null,741]
[null,{"$f":"B755+1","v":742}]
[null,743]
[null,744]
[null,745]
[null,746]
[null,747]
[null,748]
[null,749]
[null,750]
[null,751]
[null,752]
[null,753]
[null,754]
[null,755]
[null,756]
[null,757]
[null,758]
[null,759]
[null,760]
[null,761]
[null,762]
[null,763]
[null,764]
[null,765]
[null,766]
[null,767]
[null,768]
[null,769]
[null,770]
[null,771]
[null,772]
[null,773]
[null,774]
[null,775]
[null,776]
[null,777]
[null,778]
[null,779]
[null,780]
[null,781]
[null,782]
[null,783]
[null,784]
[null,785]
[null,786]
[null,787]
[null,788]
[null,789]
[null,790]
[null,791]
[null,792]
[null,793]
[null,794]
[null,795]
[null,796]
[null,797]
[null,798]
[null,799]
[null,800]
[null,801]
[null,802]
[null,803]
[null,804]
[null,805]
[null,{"$f":"B819+1","v":806}]
[null,807]
[null,808]
[null,809]
[null,810]
[null,811]
[null,812]
[null,813]
[null,814]
[null,815]
[null,816]
[null,817]
[null,818]
[null,819]
[null,820]
[null,821]
[null,822]
[null,823]
[null,824]
[null,825]
[null,826]
[null,827]
[null,828]
[null,829]
[null,830]
[null,831]
[null,832]
[null,833]
[null,834]
[null,835]
[null,836]
[null,837]
[null,838]
[null,839]
[null,840]
[null,841]
[null,842]
[null,843]
[null,844]
[null,845]
[null,846]
[null,847]
[null,848]
[null,849]
[null,850]
[null,851]
[null,852]
[null,853]
[null,854]
[null,855]
[null,856]
[null,857]
[null,858]
[null,859]
[null,860]
[null,861]
[null,862]
[null,863]
[null,864]
[null,865]
[null,866]
[null,867]
[null,868]
[null,869]
[null,{"$f":"B883+1","v":870}]
[null,871]
[null,872]
[null,873]
[null,874]
[null,875]
[null,876]
[null,877]
[null,878]
[null,879]
[null,880]
[null,881]
[null,882]
[null,883]
[null,884]
[null,885]
[null,886]
[null,887]
[null,888]
[null,889]
[null,890]
[null,891]
[null,892]
[null,893]
[null,894]
[null,895]
[null,896]
[null,897]
[null,898]
[null,899]
[null,900]
[null,901]
[null,902]
[null,903]
[null,904]
[null,905]
[null,906]
[null,907]
[null,908]
[null,909]
[null,910]
[null,911]
[null,912]
[null,913]
[null,914]
[null,915]
[null,916]
[null,917]
[null,918]
[null,919]
[null,920]
[null,921]
[null,922]
[null,923]
[null,924]
[null,925]
[null,926]
[null,927]
[null,928]
[null,929]
[null,930]
[null,931]
[null,932]
[null,933]
[null,{"$f":"B947+1","v":934}]
[null,935]
[null,936]
[null,937]
[null,938]
[null,939]
[null,940]
[null,941]
[null,942]
[null,943]
[null,944]
[null,945]
[null,946]
[null,947]
[null,948]
[null,949]
[null,950]
[null,951]
[null,952]
[null,953]
[null,954]
[null,955]
[null,956]
[null,957]
[null,958]
[null,959]
[null,960]
[null,961]
[null,962]
[null,963]
[null,964]
[null,965]
[null,966]
[null,967]
[null,968]
[null,969]
[null,970]
[null,971]
[null,972]
[null,973]
[null,974]
[null,975]
[null,976]
[null,977]
[null,978]
[null,979]
[null,980]
[null,981]
[null,982]
[null,983]
[null,984]
[null,985]
[null,986]
[null,987]
[null,988]
[null,989]
[null,990]
[null,991]
[null,992]
[null,993]
[null,994]
[null,995]
[null,996]
[null,997]
[null,{"$f":"B1011+1","v":998}]
[null,999]
[null,1000]