{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Points","Summary","Inputs","Operating Model","Electrolyzer Database","Truck Database","Refuller Database","NREL Backup","Email","Stanford Article","Tornado","Fuel Economy by Vehicle Type","Truck Databook","Refuler","Databook","Original Assumptions"],"not_rendered":{"charts":1,"images":17,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Points","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Introduce LCOE; LCOH"]
[]
[null,null,"Need to be able to change yourself",null,null,null,null,null,null,"Put reset when make spinners"]
[]
[null,null,"Fredrick Email"]
[]
[null,null,"Other Models"]
[]
[null,null,"Objective and Diagram"]
[]
[null,null,"Problems with Simple -- Need to see parts; e.g. fuel efficiency"]
[]
[null,null,"Database and Drop Down"]
[]
[null,null,"Average/Min/Median in Database"]
[]
[null,null,"A lot about set-up"]
[]
[null,null,"Google and conversions"]
[]
[null,null,"Currency -- Get in Common Currency and Change Around"]
[]
[null,null,"Collect Items and Compute Cash Flow"]

{"sheet":"Summary","index":1,"n_rows":26,"n_cols":23,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["          ",null,null,null,"Electrolizer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand "]
[null,null,null,null,"Life",null,null,null,null,null,null,"Currency",{"$f":"Inputs!$F$23","v":0.71}]
[null,null,null,null,"Evalutation Period",null,{"$f":"Inputs!F6","v":20},null,null,null,null,null,null,null,null,null,null,null,null,"Conventional Diesel "]
[null,null,null,null,"Electrolyzer Capacity ",null,{"$f":"Inputs!F85","v":17.142857142857142},"kg/hr",null,null,null,null,null,null,null,null,null,null,null,"Trucks",null,{"$f":"'Operating Model'!K29","v":31}]
[null,null,null,null,"Electrolyzer Capacity ",null,{"$f":"Inputs!F87","v":1200},"kw/hr",null,null,null,null,null,null,null,null,null,null,null,"Distance km",null,{"$f":"'Operating Model'!K34","v":50}]
[null,null,null,null,"Electrolyzer Life",null,{"$f":"Inputs!F33","v":20},"Yrs",null,null,null,null,null,null,null,null,null,null,null,"Efficiency",null,{"$f":"Inputs!F53","v":9.7703957010258922},"km/L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km per Year",null,{"$f":"'Operating Model'!K38","v":12500}]
[null,null,null,null,"Capital Cost/kg",null,{"$f":"Inputs!F95/Inputs!F23","v":178278.33333333334},{"$f":"Inputs!$D$23","v":"AUD"},null,null,null,null,null,null,null,null,null,null,null,"Truck Cost",null,{"$f":"'Operating Model'!H49","v":435000.00000000006},{"$f":"Inputs!$D$23","v":"AUD"}]
[null,null,null,null,"Capital Cost/kW",null,{"$f":"Inputs!F98/Inputs!F23","v":2546.8333333333335},{"$f":"Inputs!$D$23","v":"AUD"}]
[]
[null,null,null,null,"Efficiency",null,{"$f":"Inputs!F86","v":70},"kWh/kg",null,null,null,null,null,null,null,null,null,null,null,"Hydrogen Truck"]
[null,null,null,null,"Electricity Cost/MWH",null,{"$f":"Inputs!F101/Summary!M2","v":70.422535211267615},{"$f":"Inputs!$D$23&\"/MWH\"","v":"AUD/MWH"},"Storage and Compression",null,null,null,null,null,null,"Dispensor and Chiller",null,null,null,"Diesel Price USD/L",null,{"$f":"Inputs!F63","v":1.323943661971831}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diesel Price USD/gal",null,{"$f":"Inputs!F66","v":3.5582853999999999}]
[null,null,null,null,"Electricity Cost/kg",null,{"$f":"'Operating Model'!K91","v":4.9295774647887329},null,"Storage Capacity (kg)",null,null,{"$f":"Inputs!F117","v":345},null,null,null,"Target Fill Minutes",null,{"$f":"Inputs!F147","v":30}]
[null,null,null,null,"Water Cost/kg",null,{"$f":"'Operating Model'!K98","v":2.4402E-2},null,"Capital Cost/kg",null,null,{"$f":"Inputs!F123","v":6449.6869565217394},null,null,null,"Capacity per Minute",null,{"$f":"'Operating Model'!H133","v":2.9411764705882355},null,"Efficiency",null,{"$f":"Inputs!F60","v":5.8080493925102177},"kg/km"]
[null,null,null,null,"O&M Cost/kg",null,{"$f":"'Operating Model'!K107","v":1.3742369460688821},null,"Operating Cost/kg",null,null,{"$f":"'Operating Model'!K129","v":5.8352808031713321},null,null,null,"Number of Pumps",null,{"$f":"'Operating Model'!K147","v":4},null,"Truck Cost",null,{"$f":"'Operating Model'!H50","v":823235.29411764699},{"$f":"Inputs!$D$23","v":"AUD"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use per Day (kg/Day)",null,{"$f":"'Operating Model'!K138","v":5.8963987783279697}]
[null,null,null,null,"Capacity Factor",null,{"$f":"'Operating Model'!O1","v":0.45801780315620338},null,null,null,null,null,null,null,null,"Filling Minutes",null,{"$f":"'Operating Model'!K144","v":93.148043123576798},null,"Diesel Conv to H2",null,{"$f":"'Operating Model'!K55","v":7.8702341409016245},{"$f":"W16","v":"AUD"}]
[null,null,null,null,"Electrolyzer vs Truck Life",null,{"$f":"'Operating Model'!Q1","v":0.80244719112966834},null,null,null,null,null,null,null,null,null,null,null,null,"Discount Rate",null,{"$f":"Inputs!F171","v":0.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Levelised Cost/kg",null,{"$f":"'Operating Model'!K199","v":23.909554904121968}]
[null,null,null,null,"Total Capital Expenditure ",null,null,null,null,null,null,null,null,null,null,"Capital Cost/kg min",null,{"$f":"'Operating Model'!H150","v":340111.08906962909}]
[null,null,null,null,"Electrolyzer",null,{"$f":"'Operating Model'!K85","v":3056200.0000000005},null,null,null,null,null,null,null,null,"Operating Cost/kg",null,{"$f":"'Operating Model'!K156","v":3.5676711131131436},null,"Percent Increase",null,{"$f":"'Operating Model'!K197","v":2.0379725019696626}]
[null,null,null,null,"Storage and Compression",null,{"$f":"'Operating Model'!K120","v":2225142},null,null,null,null,null,null,null,null,null,null,null,null,"Level Equiv Diesel",null,{"$f":"'Operating Model'!K202","v":4.0221044392274408}]
[null,null,null,null,"Dispensor and Chiller",null,{"$f":"'Operating Model'!K182","v":4760539.9434588598}]
[null,null,null,null,"Additional Truck Cost",null,{"$f":"V16*V4*Inputs!$F$41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"NPV Required",null,{"$f":"'Operating Model'!H185","v":21679176.584220193}]
[null,null,null,null,"Total Capital Cost",null,{"$f":"SUM(G22:G25)","v":10041881.943458859}]

{"sheet":"Inputs","index":2,"n_rows":195,"n_cols":26,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
["          ",null,null,null,null,null,{"$f":"Inputs!$D$23","v":"AUD"}]
[null,"Timing"]
[null,null,"Start of Construction (Financial Close)",null,"Date","2020-01-01"]
[null,null,"Construction Period",null,"Months",12]
[null,null,"Commercial Operation",null,"Date",{"$f":"EDATE(F3,F4)","v":"2021-01-01"}]
[null,null,"BOT Period",null,"Years",{"$f":"F33","v":20}]
[null,null,"End of BOT Period",null,"Date",{"$f":"EDATE(F5,F6*12)","v":"2041-01-01"}]
[null,null,"Period for Analysis",null,"Years",{"$f":"F6","v":20}]
[null,null,"End of Operating Life",null,"Date",{"$f":"EDATE(F5,F8*12)","v":"2041-01-01"}]
[]
[null,null,"Periods per Year - Construction",null,"Months",12]
[null,null,"Periods per Year - Operation",null,"Months",1]
[]
[null,"Macro Economic"]
[null,null,"Inflaton Rate",null,"% p.a",1.4999999999999999E-2]
[]
[null,null,"Currency Table"]
[null,null,null,"USD","USD/USD",1]
[null,null,null,"AUD","USD/AUD",0.71]
[null,null,null,"EUR","USD/EUR",{"$f":"1.18","v":1.18}]
[]
[null,null,null,"Code",2]
[null,null,null,{"$f":"INDEX(D18:D20,$E$22)","v":"AUD"},{"$f":"INDEX(E18:E20,$E$22)","v":"USD/AUD"},{"$f":"INDEX(F18:F20,$E$22)","v":0.71}]
[]
[null,"Demand: Truck Assumptions"]
[]
[null,null,"Number of Trucks"]
[null,null,null,"Year",null,{"$f":"F3","v":"2020-01-01"},{"$f":"EDATE(F28,12)","v":"2021-01-01"},{"$f":"EDATE(G28,12)","v":"2022-01-01"},"2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01"]
[null,null,null,"Number of Trucks - Phase 1","Number",null,31,0,0]
[null,null,null,"Number of Trucks - Phase 2","Number"]
[null,null,null,"Number of Trucks - Phase 2","Number"]
[]
[null,null,null,"Electrolyzer Life","Years",{"$f":"'Electrolyzer Database'!G17","v":20}]
[null,null,null,"Truck Life","Years",{"$f":"F33/2","v":10}]
[null,null,null,"Date of Start","Date",{"$f":"G28","v":"2021-01-01"}]
[null,null,null,"First Truck End","Date",{"$f":"EDATE(F35,F34*12)","v":"2031-01-01"}]
[null,null,null,"Second Truck Life","Years",{"$f":"F34","v":10}]
[null,null,null,"End of Second Life","Date",{"$f":"EDATE(F36,F37*12)","v":"2041-01-01"}]
[]
[null,null,null,"Number Replacements","Number",1]
[null,null,null,"Replace Trucks","Flag",false]
[]
[null,null,null,"End of Truck Operation","Date",{"$f":"F9","v":"2041-01-01"}]
[]
[null,null,null,"Hours of Operation per Day","Hours",10,null,"Base Hrs",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"Days per Week","Days",5]
[]
[null,null,null,"Weeks of Operation (Schedued Maint)","Weeks",50]
[]
[null,null,"Diesel Truck Comparator",null,null,"Applied"]
[null,null,null,"Diesel Mileage litres/100 km","L/100 km",{"$f":"'Truck Database'!$G$14","v":102.34999999999998}]
[null,null,null,"Diesel Mileage litres/km","L/km",{"$f":"F51/100","v":1.0234999999999999}]
[null,null,null,"Diesel Mileage - km/Litre","km/L",{"$f":"1/F51*1000","v":9.7703957010258922}]
[null,null,null,"Diesel Mileage - Miles/gallon","Miles/gallon",{"$f":"'Truck Database'!G18","v":5.9521571414378407}]
[]
[null,null,null,"Capital Cost of New Diesel Truck","USD/Truck",{"$f":"F72*$F$23","v":308850},null,{"$f":"H72*$F$23","v":0}]
[]
[null,null,"Hydrogen Truck"]
[null,null,null,"Hydrogen Mileage ","kg/100 km",{"$f":"'Truck Database'!G29*100","v":580.80493925102178}]
[null,null,null,"Hydrogen Mileage kg/km","kg/km",{"$f":"F59/100","v":5.8080493925102177}]
[null,null,null,"Hydrogen Mileage km/kg","km/kg",{"$f":"1/F60","v":0.17217484432717672}]
[]
[null,null,null,"Diesel Cost/Litre","AUD/Litre",{"$f":"F64/F19","v":1.323943661971831}]
[null,null,null,"Diesel Cost/Litre","USD/Litre",{"$f":"diesel/100","v":0.94},null,94,null,"Base Diesel",94]
[null,null,null,"Converstion to Gallons (Americans)","Litre/Gallon",3.7854100000000002]
[null,null,null,"Diesel Cost/Gallon","USD/Gallon",{"$f":"F65*F64","v":3.5582853999999999}]
[]
[]
[null,null,null,"Diesel Truck fuel tank volume (liters)","Litres"]
[]
[null,null,"Truck Costs"]
[null,null,null,"Capital Cost of New Diesel Truck","AUD/Truck",{"$f":"F73/F19","v":435000}]
[null,null,null,"Capital Cost of New Diesel Truck","USD/Truck",{"$f":"'Truck Database'!G10","v":308850}]
[]
[null,null,null,"Capital Cost of New Hydrogen Truck","AUD/Truck",{"$f":"F76/F19","v":823235.29411764687}]
[null,null,null,"Capital Cost of New Hydrogen Truck","USD/Truck",{"$f":"'Truck Database'!G25","v":584497.05882352928}]
[]
[null,null,null,"Additional Truck Maintenance","USD/km/yr",0]
[null,null,null,"Include Truck Cost Differential","Flag",true]
[]
[null,"Production of Hydrogen from Electrolyzer and Compression"]
[]
[null,null,null,"Year of Operation","Date",{"$f":"F5","v":"2021-01-01"}]
[]
[null,null,null,"Electrolyzer Capaicty","kg/Hour",17.142857142857142,{"$f":"'Electrolyzer Database'!G7","v":17.142857142857142},{"$f":"capacity/db_cap","v":1}]
[null,null,null,"Electricity Efficiency","kWh/kg",{"$f":"'Electrolyzer Database'!$G$12","v":70}]
[null,null,null,"kWh per Hour Required- kW Capacity","kWh  ",{"$f":"F86*F85","v":1200}]
[null,null,null,"Water Efficiency","L/kg",{"$f":"'Electrolyzer Database'!G9","v":11.62}]
[]
[null,null,null,"Maximum Availability","%",{"$f":"'Electrolyzer Database'!$G$14","v":0.97}]
[null,null,null,"Maximum Annual Production","kg/Year",{"$f":"F85*8760*F90","v":145666.28571428571}]
[null,null,null,"Lifetime of Electrolyzer","Hours",100000]
[null,null,null,"Lifetime of Electrolyzer","Years",{"$f":"'Electrolyzer Database'!$G$17","v":20}]
[]
[null,null,null,"Capital Cost per kg","USD/kg-hr",{"$f":"'Electrolyzer Database'!$G$24","v":126577.61666666667}]
[null,null,null,"Capital Cost of Electrolyzer","USD ",{"$f":"F95*F85","v":2169902}]
[null,null,null,"Capital Cost of Electrolyzer","AUD"]
[null,null,null,"Capital Cost per kW","USD/kW",{"$f":"F96/F87","v":1808.2516666666668}]
[]
[null,null,null,"Cost of Electricity","AUD/MWH",{"$f":"F101/F23","v":70.422535211267615}]
[null,null,null,"Cost of Electricity","USD/MWH",50,null,"base price",50]
[]
[null,null,null,"Cost of Water","AUD/kLitre",{"$f":"F104/F19","v":2.1}]
[null,null,null,"Cost of Water","USD/kLitre",1.4909999999999999]
[]
[null,null,null,"Maintenance Overhaul Years","Years",{"$f":"ROUND('Electrolyzer Database'!$G$31,0)","v":8}]
[null,null,null,"Cost of Major Overhaul as Percent of Cost","%",{"$f":"'Electrolyzer Database'!G33","v":0.46085030568200774}]
[null,null,null,"Cost of Major Overhaul ","AUD",{"$f":"F109/F19","v":1408450.7042253523}]
[null,null,null,"Cost of Major Overhaul ","USD",{"$f":"F96*F107","v":1000000}]
[]
[null,null,null,"Other Overhead Costs","% of Capital Cost",{"$f":"'Electrolyzer Database'!$G$28","v":0.03}]
[]
[null,null,null,"Alternative Maintenance and Other/kg","AUD/kg",{"$f":"H113","v":0.23977096198533857},null,{"$f":"'Original Assumptions'!G38","v":0.23977096198533857}]
[]
[null,"Compressor and Storage"]
[null,null,null,null,null,null,null,"Mario","Alternate"]
[null,null,"Storage Capacity",null,"kg",{"$f":"H117","v":345},null,345]
[null,null,"Storage Hours at Full Production",null,"Hrs",{"$f":"F117/F85","v":20.125}]
[]
[null,null,"Capital Cost of Compressor and Storage",null,"AUD",{"$f":"F121/F19","v":2225142}]
[null,null,"Capital Cost of Compressor and Storage",null,"USD",{"$f":"'Refuller Database'!$G$10","v":1579850.8199999998}]
[]
[null,null,"Cost of Refuller per kg",null,"AUD/kg",{"$f":"F120/F117","v":6449.6869565217394}]
[null,null,"Cost of Refuller per kg",null,"USD/kg",{"$f":"F121/F117","v":4579.2777391304344}]
[]
[null,null,"Maintenance Cost",null,"%",{"$f":"I126","v":0}]
[null,null,"Years Until Overhaul",null,"USD",{"$f":"F120*F126","v":0}]
[null,null,"Maintenance Overhaul Years",null,"Years",8]
[null,null,"Discount Rate",null,"%",0.05]
[null,null,"Annual Maintenance Payment",null,"AUD",{"$f":"PMT(F129,F128,-F127)","v":0}]
[]
[null,null,"Other Overhead Costs",null,"% of Capital",{"$f":"'Refuller Database'!G21","v":0.17496268485692706}]
[null,null,"Total Other Overhead"]
[]
[null,"Dispensor +  Chiller +heat exchange +associated pipework "]
[]
[null,null,"Inlude Dispensor",null,"Flag",true]
[]
[null,null,"Number of Nozzels",null,"Number",1]
[null,null,"Flow Rate for 50 kg",null,"Minutes",17]
[null,null,"Flow Rate - kg/Minute",null,"kg/Minute",{"$f":"'Refuller Database'!$G$16","v":2.9411764705882355}]
[]
[null,null,"Flow Rate in Terms of kg/Hour",null,"kg/Hour",2000]
[null,null,"Captial Cost for Single Dispenser",null,"USD",{"$f":"'Refuller Database'!G19","v":241478.87323943662}]
[]
[null,null,"Manuevering Time",null,"Minutes",1]
[null,null,"Target Time per Day",null,"Minutes",30]
[]
[null,null,"Maximum Visits per Day",null,"Visits",2]
[null,null,"Hydrogen Truck fuel tank volume (liters)",null,"kg",{"$f":"I150","v":33},null,null,{"$f":"Databook!E10","v":33},{"$f":"INDEX($H$50:$I$50,MATCH(F150,H150:I150,0))","v":0}]
[]
[]
[null,"Revenues"]
[]
[null,null,"Fix Diesel ",null,"Flag",true]
[null,null,"Fuel Efficiency",null,"km/L 100",2.5]
[null,null,"Fuel Efficiency",null,"L/km",{"$f":"1/F156*100","v":40}]
[]
[]
[null,null,"Diesel Price Option"]
[null,null,null,"Percent Reduction"]
[null,null,null,"Flat Price"]
[null,null,null,"% of Palm Oil Price"]
[]
[null,"Discount Rates"]
[]
[null,null,"Investor Discount Rate",null,null,0.08]
[null,null,"Pre-BOT Discount Rate",null,null,0.08]
[null,null,"Post BOT Discount Rate",null,null,0.08]
[]
[null,null,"Discount Rate Applied",null,null,{"$f":"G171/100","v":0.04},4]
[]
[null,null,"Turn off Expenses",null,null,false]
[]
[null,"Financing"]
[null,null,"Senior Debt Percent",null,null,0.5]
[]
[null,null,"BOT Period",null,null,{"$f":"F6","v":20}]
[null,null,"Tail",null,null,2]
[null,null,"Debt Tenor",null,null,{"$f":"F178-F179","v":18}]
[]
[null,null,"Start Repayment Date",null,null,{"$f":"F5","v":"2021-01-01"}]
[null,null,"Debt Repaid Date",null,null,{"$f":"EDATE(F182,F180*12)","v":"2039-01-01"}]
[]
[null,null,null,null,null,{"$f":"F3","v":"2020-01-01"},{"$f":"F5","v":"2021-01-01"},{"$f":"EDATE(G185,60)","v":"2026-01-01"},{"$f":"EDATE(H185,30)","v":"2028-07-01"}]
[null,null,"Base Interest Rate",null,null,0.02,{"$f":"F186","v":0.02},{"$f":"G186","v":0.02},0.02]
[null,null,"Credit Spread",null,null,0.03,3.5000000000000003E-2,3.6999999999999998E-2,0.04]
[null,null,"Total Interest Rate",null,null,{"$f":"SUM(F186:F187)","v":0.05},{"$f":"SUM(G186:G187)","v":5.5000000000000007E-2},5.6999999999999995E-2,0.06]
[]
[null,null,"Mezzanine Debt Financing",null,null,0.2]
[]
[null,null,null,null,null,{"$f":"F185","v":"2020-01-01"},{"$f":"G185","v":"2021-01-01"},"2026-01-01","2028-07-01"]
[null,null,"Base Interest Rate",null,null,0.02,{"$f":"F193","v":0.02},{"$f":"G193","v":0.02},{"$f":"H193","v":0.02}]
[null,null,"Credit Spread",null,null,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2]
[null,null,"Total Interest Rate",null,null,{"$f":"SUM(F193:F194)","v":6.5000000000000002E-2},{"$f":"SUM(G193:G194)","v":6.5000000000000002E-2},6.5000000000000002E-2,6.5000000000000002E-2]

{"sheet":"Operating Model","index":3,"n_rows":202,"n_cols":71,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
["          ","Timeline",null,null,null,null,null,"Driver 1","Description","Driver 2","Sum/Max",null,null,"Capacity Factor",{"$f":"$K$79","v":0.45801780315620338},"Life Percent",{"$f":"$K$83","v":0.80244719112966834},"Fillin Minutes",{"$f":"$K$144","v":93.148043123576798}]
[null,null,"Period",null,null,null,null,null,null,"Equivalent Diesel",null,{"$f":"Summary!V23","v":4.0221044392274408},null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58]
[null,null,"Construction",null,null,null,"Flag",{"$f":"Inputs!F4","v":12},null,null,null,null,null,{"$f":"N2<=$H$3","v":true},true,true,true,true,true,true,true,true,true,true,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,{"$f":"BB2<=$H$3","v":false},{"$f":"BC2<=$H$3","v":false},{"$f":"BD2<=$H$3","v":false},{"$f":"BE2<=$H$3","v":false},{"$f":"BF2<=$H$3","v":false},{"$f":"BG2<=$H$3","v":false},{"$f":"BH2<=$H$3","v":false},{"$f":"BI2<=$H$3","v":false},{"$f":"BJ2<=$H$3","v":false},{"$f":"BK2<=$H$3","v":false},{"$f":"BL2<=$H$3","v":false},{"$f":"BM2<=$H$3","v":false},{"$f":"BN2<=$H$3","v":false},{"$f":"BO2<=$H$3","v":false},{"$f":"BP2<=$H$3","v":false},{"$f":"BQ2<=$H$3","v":false},{"$f":"BR2<=$H$3","v":false},{"$f":"BS2<=$H$3","v":false}]
[null,null,"Periods per Year",null,null,null,"Months",{"$f":"Inputs!F12","v":1},null,{"$f":"Inputs!F11","v":12},null,{"$f":"Inputs!D23","v":"AUD"},null,{"$f":"IF(N$3,$H4,$J4)","v":1},1,1,1,1,1,1,1,1,1,1,1,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,{"$f":"IF(AT$3,$H4,$J4)","v":12},12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12]
[null,null,"Start of Period",null,null,null,"Date",null,null,null,null,null,null,{"$f":"M6+1","v":"2020-01-01"},{"$f":"N6+1","v":"2020-02-01"},"2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2022-01-01","2023-01-01","2024-01-01","2025-01-01","2026-01-01","2027-01-01","2028-01-01","2029-01-01","2030-01-01","2031-01-01","2032-01-01","2033-01-01","2034-01-01","2035-01-01","2036-01-01","2037-01-01","2038-01-01","2039-01-01","2040-01-01","2041-01-01","2042-01-01","2043-01-01","2044-01-01","2045-01-01","2046-01-01","2047-01-01","2048-01-01",{"$f":"BA6+1","v":"2049-01-01"},{"$f":"BB6+1","v":"2050-01-01"},{"$f":"BC6+1","v":"2051-01-01"},{"$f":"BD6+1","v":"2052-01-01"},{"$f":"BE6+1","v":"2053-01-01"},{"$f":"BF6+1","v":"2054-01-01"},{"$f":"BG6+1","v":"2055-01-01"},{"$f":"BH6+1","v":"2056-01-01"},{"$f":"BI6+1","v":"2057-01-01"},{"$f":"BJ6+1","v":"2058-01-01"},{"$f":"BK6+1","v":"2059-01-01"},{"$f":"BL6+1","v":"2060-01-01"},{"$f":"BM6+1","v":"2061-01-01"},{"$f":"BN6+1","v":"2062-01-01"},{"$f":"BO6+1","v":"2063-01-01"},{"$f":"BP6+1","v":"2064-01-01"},{"$f":"BQ6+1","v":"2065-01-01"},{"$f":"BR6+1","v":"2066-01-01"}]
[null,null,"End of Period",null,null,null,"Date",null,null,null,null,null,{"$f":"Inputs!F3-1","v":"2019-12-31"},{"$f":"EDATE(N5,N4)-1","v":"2020-01-31"},{"$f":"EDATE(O5,O4)-1","v":"2020-02-29"},"2020-03-31","2020-04-30","2020-05-31","2020-06-30","2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-12-31","2022-12-31","2023-12-31","2024-12-31","2025-12-31","2026-12-31","2027-12-31","2028-12-31","2029-12-31","2030-12-31","2031-12-31","2032-12-31","2033-12-31","2034-12-31","2035-12-31","2036-12-31","2037-12-31","2038-12-31","2039-12-31","2040-12-31","2041-12-31","2042-12-31","2043-12-31","2044-12-31","2045-12-31","2046-12-31","2047-12-31","2048-12-31",{"$f":"EDATE(BB5,BB4)-1","v":"2049-12-31"},"2050-12-31","2051-12-31","2052-12-31","2053-12-31","2054-12-31","2055-12-31","2056-12-31","2057-12-31","2058-12-31","2059-12-31","2060-12-31","2061-12-31","2062-12-31","2063-12-31","2064-12-31","2065-12-31","2066-12-31"]
[null,null,"Date of Electrolyzer Operation",null,null,null,"Flag",{"$f":"Inputs!$F$83","v":"2021-01-01"},null,null,{"$f":"SUM(N7:BS7)","v":1},null,null,{"$f":"($H$7=N5)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"($H$7=AT5)*1","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]
[null,null,"Electrolizer Operating",null,null,null,"Flag",{"$f":"Inputs!$F$83","v":"2021-01-01"},null,{"$f":"Inputs!F43","v":"2041-01-01"},{"$f":"SUM(N8:BS8)","v":20},null,null,{"$f":"AND(N5>=$H$8,N5<$J$8)*1","v":0},{"$f":"AND(O5>=$H$8,O5<$J$8)*1","v":0},0,0,0,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,0,0,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,"Truck Demand in km and kg"]
[]
[null,null,"Truck Demand for Diesel and Hydrogen"]
[null,null,null,"Number of Trucks Added - Phase 1",null,null,"Number",null,null,null,{"$f":"MAX(N13:BS13)","v":31},null,null,{"$f":"LOOKUP(N$5,Inputs!$28:$28,Inputs!$29:$29)","v":0},{"$f":"LOOKUP(O$5,Inputs!$28:$28,Inputs!$29:$29)+(O$2<=$H$13)*O19","v":0},{"$f":"LOOKUP(P$5,Inputs!$28:$28,Inputs!$29:$29)+(P$2<=$H$13)*P19","v":0},{"$f":"LOOKUP(Q$5,Inputs!$28:$28,Inputs!$29:$29)+(Q$2<=$H$13)*Q19","v":0},{"$f":"LOOKUP(R$5,Inputs!$28:$28,Inputs!$29:$29)+(R$2<=$H$13)*R19","v":0},{"$f":"LOOKUP(S$5,Inputs!$28:$28,Inputs!$29:$29)+(S$2<=$H$13)*S19","v":0},{"$f":"LOOKUP(T$5,Inputs!$28:$28,Inputs!$29:$29)+(T$2<=$H$13)*T19","v":0},{"$f":"LOOKUP(U$5,Inputs!$28:$28,Inputs!$29:$29)+(U$2<=$H$13)*U19","v":0},{"$f":"LOOKUP(V$5,Inputs!$28:$28,Inputs!$29:$29)+(V$2<=$H$13)*V19","v":0},{"$f":"LOOKUP(W$5,Inputs!$28:$28,Inputs!$29:$29)+(W$2<=$H$13)*W19","v":0},{"$f":"LOOKUP(X$5,Inputs!$28:$28,Inputs!$29:$29)+(X$2<=$H$13)*X19","v":0},{"$f":"LOOKUP(Y$5,Inputs!$28:$28,Inputs!$29:$29)+(Y$2<=$H$13)*Y19","v":0},{"$f":"LOOKUP(Z$5,Inputs!$28:$28,Inputs!$29:$29)+(Z$2<=$H$13)*Z19","v":31},{"$f":"LOOKUP(AA$5,Inputs!$28:$28,Inputs!$29:$29)+(AA$2<=$H$13)*AA19","v":0},{"$f":"LOOKUP(AB$5,Inputs!$28:$28,Inputs!$29:$29)+(AB$2<=$H$13)*AB19","v":0},{"$f":"LOOKUP(AC$5,Inputs!$28:$28,Inputs!$29:$29)+(AC$2<=$H$13)*AC19","v":0},{"$f":"LOOKUP(AD$5,Inputs!$28:$28,Inputs!$29:$29)+(AD$2<=$H$13)*AD19","v":0},{"$f":"LOOKUP(AE$5,Inputs!$28:$28,Inputs!$29:$29)+(AE$2<=$H$13)*AE19","v":0},{"$f":"LOOKUP(AF$5,Inputs!$28:$28,Inputs!$29:$29)+(AF$2<=$H$13)*AF19","v":0},{"$f":"LOOKUP(AG$5,Inputs!$28:$28,Inputs!$29:$29)+(AG$2<=$H$13)*AG19","v":0},{"$f":"LOOKUP(AH$5,Inputs!$28:$28,Inputs!$29:$29)+(AH$2<=$H$13)*AH19","v":0},{"$f":"LOOKUP(AI$5,Inputs!$28:$28,Inputs!$29:$29)+(AI$2<=$H$13)*AI19","v":0},{"$f":"LOOKUP(AJ$5,Inputs!$28:$28,Inputs!$29:$29)+(AJ$2<=$H$13)*AJ19","v":0},{"$f":"LOOKUP(AK$5,Inputs!$28:$28,Inputs!$29:$29)+(AK$2<=$H$13)*AK19","v":0},{"$f":"LOOKUP(AL$5,Inputs!$28:$28,Inputs!$29:$29)+(AL$2<=$H$13)*AL19","v":0},{"$f":"LOOKUP(AM$5,Inputs!$28:$28,Inputs!$29:$29)+(AM$2<=$H$13)*AM19","v":0},{"$f":"LOOKUP(AN$5,Inputs!$28:$28,Inputs!$29:$29)+(AN$2<=$H$13)*AN19","v":0},{"$f":"LOOKUP(AO$5,Inputs!$28:$28,Inputs!$29:$29)+(AO$2<=$H$13)*AO19","v":0},{"$f":"LOOKUP(AP$5,Inputs!$28:$28,Inputs!$29:$29)+(AP$2<=$H$13)*AP19","v":0},{"$f":"LOOKUP(AQ$5,Inputs!$28:$28,Inputs!$29:$29)+(AQ$2<=$H$13)*AQ19","v":0},{"$f":"LOOKUP(AR$5,Inputs!$28:$28,Inputs!$29:$29)+(AR$2<=$H$13)*AR19","v":0},{"$f":"LOOKUP(AS$5,Inputs!$28:$28,Inputs!$29:$29)+(AS$2<=$H$13)*AS19","v":0},{"$f":"LOOKUP(AT$5,Inputs!$28:$28,Inputs!$29:$29)+(AT$2<=$H$13)*AT19","v":0},{"$f":"LOOKUP(AU$5,Inputs!$28:$28,Inputs!$29:$29)+(AU$2<=$H$13)*AU19","v":0},{"$f":"LOOKUP(AV$5,Inputs!$28:$28,Inputs!$29:$29)+(AV$2<=$H$13)*AV19","v":0},{"$f":"LOOKUP(AW$5,Inputs!$28:$28,Inputs!$29:$29)+(AW$2<=$H$13)*AW19","v":0},{"$f":"LOOKUP(AX$5,Inputs!$28:$28,Inputs!$29:$29)+(AX$2<=$H$13)*AX19","v":0},{"$f":"LOOKUP(AY$5,Inputs!$28:$28,Inputs!$29:$29)+(AY$2<=$H$13)*AY19","v":0},{"$f":"LOOKUP(AZ$5,Inputs!$28:$28,Inputs!$29:$29)+(AZ$2<=$H$13)*AZ19","v":0},{"$f":"LOOKUP(BA$5,Inputs!$28:$28,Inputs!$29:$29)+(BA$2<=$H$13)*BA19","v":0},{"$f":"LOOKUP(BB$5,Inputs!$28:$28,Inputs!$29:$29)+(BB$2<=$H$13)*BB19","v":0},{"$f":"LOOKUP(BC$5,Inputs!$28:$28,Inputs!$29:$29)+(BC$2<=$H$13)*BC19","v":0},{"$f":"LOOKUP(BD$5,Inputs!$28:$28,Inputs!$29:$29)+(BD$2<=$H$13)*BD19","v":0},{"$f":"LOOKUP(BE$5,Inputs!$28:$28,Inputs!$29:$29)+(BE$2<=$H$13)*BE19","v":0},{"$f":"LOOKUP(BF$5,Inputs!$28:$28,Inputs!$29:$29)+(BF$2<=$H$13)*BF19","v":0},{"$f":"LOOKUP(BG$5,Inputs!$28:$28,Inputs!$29:$29)+(BG$2<=$H$13)*BG19","v":0},{"$f":"LOOKUP(BH$5,Inputs!$28:$28,Inputs!$29:$29)+(BH$2<=$H$13)*BH19","v":0},{"$f":"LOOKUP(BI$5,Inputs!$28:$28,Inputs!$29:$29)+(BI$2<=$H$13)*BI19","v":0},{"$f":"LOOKUP(BJ$5,Inputs!$28:$28,Inputs!$29:$29)+(BJ$2<=$H$13)*BJ19","v":0},{"$f":"LOOKUP(BK$5,Inputs!$28:$28,Inputs!$29:$29)+(BK$2<=$H$13)*BK19","v":0},{"$f":"LOOKUP(BL$5,Inputs!$28:$28,Inputs!$29:$29)+(BL$2<=$H$13)*BL19","v":0},{"$f":"LOOKUP(BM$5,Inputs!$28:$28,Inputs!$29:$29)+(BM$2<=$H$13)*BM19","v":0},{"$f":"LOOKUP(BN$5,Inputs!$28:$28,Inputs!$29:$29)+(BN$2<=$H$13)*BN19","v":0},{"$f":"LOOKUP(BO$5,Inputs!$28:$28,Inputs!$29:$29)+(BO$2<=$H$13)*BO19","v":0},{"$f":"LOOKUP(BP$5,Inputs!$28:$28,Inputs!$29:$29)+(BP$2<=$H$13)*BP19","v":0},{"$f":"LOOKUP(BQ$5,Inputs!$28:$28,Inputs!$29:$29)+(BQ$2<=$H$13)*BQ19","v":0},{"$f":"LOOKUP(BR$5,Inputs!$28:$28,Inputs!$29:$29)+(BR$2<=$H$13)*BR19","v":0},{"$f":"LOOKUP(BS$5,Inputs!$28:$28,Inputs!$29:$29)+(BS$2<=$H$13)*BS19","v":0}]
[null,null,null,"Number of Trucks Added - Phase 2",null,null,"Number",null,null,null,{"$f":"MAX(N14:BS14)","v":0},null,null,{"$f":"LOOKUP(N$5,Inputs!$28:$28,Inputs!$30:$30)","v":0},{"$f":"LOOKUP(O$5,Inputs!$28:$28,Inputs!$30:$30)+(O$2<=$H$13)*O20","v":0},{"$f":"LOOKUP(P$5,Inputs!$28:$28,Inputs!$30:$30)+(P$2<=$H$13)*P20","v":0},{"$f":"LOOKUP(Q$5,Inputs!$28:$28,Inputs!$30:$30)+(Q$2<=$H$13)*Q20","v":0},{"$f":"LOOKUP(R$5,Inputs!$28:$28,Inputs!$30:$30)+(R$2<=$H$13)*R20","v":0},{"$f":"LOOKUP(S$5,Inputs!$28:$28,Inputs!$30:$30)+(S$2<=$H$13)*S20","v":0},{"$f":"LOOKUP(T$5,Inputs!$28:$28,Inputs!$30:$30)+(T$2<=$H$13)*T20","v":0},{"$f":"LOOKUP(U$5,Inputs!$28:$28,Inputs!$30:$30)+(U$2<=$H$13)*U20","v":0},{"$f":"LOOKUP(V$5,Inputs!$28:$28,Inputs!$30:$30)+(V$2<=$H$13)*V20","v":0},{"$f":"LOOKUP(W$5,Inputs!$28:$28,Inputs!$30:$30)+(W$2<=$H$13)*W20","v":0},{"$f":"LOOKUP(X$5,Inputs!$28:$28,Inputs!$30:$30)+(X$2<=$H$13)*X20","v":0},{"$f":"LOOKUP(Y$5,Inputs!$28:$28,Inputs!$30:$30)+(Y$2<=$H$13)*Y20","v":0},{"$f":"LOOKUP(Z$5,Inputs!$28:$28,Inputs!$30:$30)+(Z$2<=$H$13)*Z20","v":0},{"$f":"LOOKUP(AA$5,Inputs!$28:$28,Inputs!$30:$30)+(AA$2<=$H$13)*AA20","v":0},{"$f":"LOOKUP(AB$5,Inputs!$28:$28,Inputs!$30:$30)+(AB$2<=$H$13)*AB20","v":0},{"$f":"LOOKUP(AC$5,Inputs!$28:$28,Inputs!$30:$30)+(AC$2<=$H$13)*AC20","v":0},{"$f":"LOOKUP(AD$5,Inputs!$28:$28,Inputs!$30:$30)+(AD$2<=$H$13)*AD20","v":0},{"$f":"LOOKUP(AE$5,Inputs!$28:$28,Inputs!$30:$30)+(AE$2<=$H$13)*AE20","v":0},{"$f":"LOOKUP(AF$5,Inputs!$28:$28,Inputs!$30:$30)+(AF$2<=$H$13)*AF20","v":0},{"$f":"LOOKUP(AG$5,Inputs!$28:$28,Inputs!$30:$30)+(AG$2<=$H$13)*AG20","v":0},{"$f":"LOOKUP(AH$5,Inputs!$28:$28,Inputs!$30:$30)+(AH$2<=$H$13)*AH20","v":0},{"$f":"LOOKUP(AI$5,Inputs!$28:$28,Inputs!$30:$30)+(AI$2<=$H$13)*AI20","v":0},{"$f":"LOOKUP(AJ$5,Inputs!$28:$28,Inputs!$30:$30)+(AJ$2<=$H$13)*AJ20","v":0},{"$f":"LOOKUP(AK$5,Inputs!$28:$28,Inputs!$30:$30)+(AK$2<=$H$13)*AK20","v":0},{"$f":"LOOKUP(AL$5,Inputs!$28:$28,Inputs!$30:$30)+(AL$2<=$H$13)*AL20","v":0},{"$f":"LOOKUP(AM$5,Inputs!$28:$28,Inputs!$30:$30)+(AM$2<=$H$13)*AM20","v":0},{"$f":"LOOKUP(AN$5,Inputs!$28:$28,Inputs!$30:$30)+(AN$2<=$H$13)*AN20","v":0},{"$f":"LOOKUP(AO$5,Inputs!$28:$28,Inputs!$30:$30)+(AO$2<=$H$13)*AO20","v":0},{"$f":"LOOKUP(AP$5,Inputs!$28:$28,Inputs!$30:$30)+(AP$2<=$H$13)*AP20","v":0},{"$f":"LOOKUP(AQ$5,Inputs!$28:$28,Inputs!$30:$30)+(AQ$2<=$H$13)*AQ20","v":0},{"$f":"LOOKUP(AR$5,Inputs!$28:$28,Inputs!$30:$30)+(AR$2<=$H$13)*AR20","v":0},{"$f":"LOOKUP(AS$5,Inputs!$28:$28,Inputs!$30:$30)+(AS$2<=$H$13)*AS20","v":0},{"$f":"LOOKUP(AT$5,Inputs!$28:$28,Inputs!$30:$30)+(AT$2<=$H$13)*AT20","v":0},{"$f":"LOOKUP(AU$5,Inputs!$28:$28,Inputs!$30:$30)+(AU$2<=$H$13)*AU20","v":0},{"$f":"LOOKUP(AV$5,Inputs!$28:$28,Inputs!$30:$30)+(AV$2<=$H$13)*AV20","v":0},{"$f":"LOOKUP(AW$5,Inputs!$28:$28,Inputs!$30:$30)+(AW$2<=$H$13)*AW20","v":0},{"$f":"LOOKUP(AX$5,Inputs!$28:$28,Inputs!$30:$30)+(AX$2<=$H$13)*AX20","v":0},{"$f":"LOOKUP(AY$5,Inputs!$28:$28,Inputs!$30:$30)+(AY$2<=$H$13)*AY20","v":0},{"$f":"LOOKUP(AZ$5,Inputs!$28:$28,Inputs!$30:$30)+(AZ$2<=$H$13)*AZ20","v":0},{"$f":"LOOKUP(BA$5,Inputs!$28:$28,Inputs!$30:$30)+(BA$2<=$H$13)*BA20","v":0},{"$f":"LOOKUP(BB$5,Inputs!$28:$28,Inputs!$30:$30)+(BB$2<=$H$13)*BB20","v":0},{"$f":"LOOKUP(BC$5,Inputs!$28:$28,Inputs!$30:$30)+(BC$2<=$H$13)*BC20","v":0},{"$f":"LOOKUP(BD$5,Inputs!$28:$28,Inputs!$30:$30)+(BD$2<=$H$13)*BD20","v":0},{"$f":"LOOKUP(BE$5,Inputs!$28:$28,Inputs!$30:$30)+(BE$2<=$H$13)*BE20","v":0},{"$f":"LOOKUP(BF$5,Inputs!$28:$28,Inputs!$30:$30)+(BF$2<=$H$13)*BF20","v":0},{"$f":"LOOKUP(BG$5,Inputs!$28:$28,Inputs!$30:$30)+(BG$2<=$H$13)*BG20","v":0},{"$f":"LOOKUP(BH$5,Inputs!$28:$28,Inputs!$30:$30)+(BH$2<=$H$13)*BH20","v":0},{"$f":"LOOKUP(BI$5,Inputs!$28:$28,Inputs!$30:$30)+(BI$2<=$H$13)*BI20","v":0},{"$f":"LOOKUP(BJ$5,Inputs!$28:$28,Inputs!$30:$30)+(BJ$2<=$H$13)*BJ20","v":0},{"$f":"LOOKUP(BK$5,Inputs!$28:$28,Inputs!$30:$30)+(BK$2<=$H$13)*BK20","v":0},{"$f":"LOOKUP(BL$5,Inputs!$28:$28,Inputs!$30:$30)+(BL$2<=$H$13)*BL20","v":0},{"$f":"LOOKUP(BM$5,Inputs!$28:$28,Inputs!$30:$30)+(BM$2<=$H$13)*BM20","v":0},{"$f":"LOOKUP(BN$5,Inputs!$28:$28,Inputs!$30:$30)+(BN$2<=$H$13)*BN20","v":0},{"$f":"LOOKUP(BO$5,Inputs!$28:$28,Inputs!$30:$30)+(BO$2<=$H$13)*BO20","v":0},{"$f":"LOOKUP(BP$5,Inputs!$28:$28,Inputs!$30:$30)+(BP$2<=$H$13)*BP20","v":0},{"$f":"LOOKUP(BQ$5,Inputs!$28:$28,Inputs!$30:$30)+(BQ$2<=$H$13)*BQ20","v":0},{"$f":"LOOKUP(BR$5,Inputs!$28:$28,Inputs!$30:$30)+(BR$2<=$H$13)*BR20","v":0},{"$f":"LOOKUP(BS$5,Inputs!$28:$28,Inputs!$30:$30)+(BS$2<=$H$13)*BS20","v":0}]
[null,null,null,"Number of Trucks Added - Phase 3",null,null,"Number",null,null,null,0,null,null,{"$f":"LOOKUP(N$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(O$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(P$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(Q$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(R$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(S$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(T$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(U$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(V$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(W$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(X$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(Y$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(Z$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AA$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AB$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AC$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AD$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AE$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AF$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AG$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AH$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AI$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AJ$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AK$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AL$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AM$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AN$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AO$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AP$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AQ$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AR$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AS$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AT$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AU$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AV$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AW$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AX$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AY$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(AZ$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BA$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BB$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BC$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BD$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BE$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BF$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BG$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BH$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BI$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BJ$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BK$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BL$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BM$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BN$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BO$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BP$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BQ$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BR$5,Inputs!$28:$28,Inputs!$31:$31)","v":0},{"$f":"LOOKUP(BS$5,Inputs!$28:$28,Inputs!$31:$31)","v":0}]
[null,null,null,null,"Total Added",null,"Number",null,null,null,{"$f":"SUM(N16:BS16)","v":31},null,null,{"$f":"SUM(N13:N15)","v":0},{"$f":"SUM(O13:O15)","v":0},0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Period for Replacement (Note Truck Life is 1/2 Electrolizer)",null,null,"Flag",{"$f":"Inputs!F36","v":"2031-01-01"},null,{"$f":"Inputs!F38","v":"2041-01-01"},{"$f":"SUM(N18:BS18)","v":10},null,null,{"$f":"AND(N5>=$H$18,N5<$J$18)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,{"$f":"AND(AT5>=$H$18,AT5<$J$18)*1","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]
[null,null,null,"Number of Trucks Retired - Phase 1",null,null,"Number",{"$f":"Inputs!F34","v":10},null,null,{"$f":"SUM(N19:BS19)","v":31},null,null,{"$f":"IF(N18,OFFSET(N13,0,-$H19))*1","v":0},{"$f":"IF(O18,OFFSET(O13,0,-$H19))*1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Number of Trucks Retired - Phase 2",null,null,"Number",{"$f":"Inputs!F34","v":10},null,null,{"$f":"SUM(N20:BS20)","v":0},null,null,{"$f":"IF(N18,OFFSET(N14,0,-$H20))*1","v":0},{"$f":"IF(O18,OFFSET(O14,0,-$H20))*1","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]
[null,null,null,"Number of Trucks Retired - Phase 3",null,null,"Number",{"$f":"Inputs!F34","v":10},null,null,{"$f":"SUM(N21:BS21)","v":0},null,null,{"$f":"IF(N18,OFFSET(N15,0,-$H21))*1","v":0},{"$f":"IF(O18,OFFSET(O15,0,-$H21))*1","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]
[null,null,null,null,"Total Retired",null,"Number",null,null,null,{"$f":"SUM(N22:BS22)","v":31},null,null,{"$f":"SUM(N19:N21)","v":0},{"$f":"SUM(O19:O21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Replaced Trucks when with Period Flag"]
[null,null,null,"Number of Trucks Added - Phase 1",null,null,"Number",null,null,null,{"$f":"SUM(N25:BS25)","v":31},null,null,{"$f":"N$18*N19","v":0},{"$f":"O$18*O19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Number of Trucks Added - Phase 2",null,null,"Number",null,null,null,{"$f":"SUM(N26:BS26)","v":0},null,null,{"$f":"N$18*N20","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]
[null,null,null,"Number of Trucks Added - Phase 3",null,null,"Number",null,null,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Total Replaced Trucks",null,"Number",null,null,null,null,null,null,{"$f":"SUM(N25:N27)","v":0},{"$f":"SUM(O25:O27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Accumulated Trucks",null,"Number",null,null,null,{"$f":"MAX(N29:BS29)","v":31},null,null,{"$f":"M29+N16-N22+N28","v":0},{"$f":"N29+O16-O22+O28","v":0},0,0,0,0,0,0,0,0,0,0,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31]
[]
[]
[null,null,null,"Hours of Operation per Day",null,null,"Hours/day",{"$f":"Hrs_Truck","v":10},null,null,{"$f":"MAX(N32:BS32)","v":10},null,null,{"$f":"$H$32","v":10},{"$f":"$H$32","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
[null,null,null,"km/Hour of Operation",null,null,"km/Hour",{"$f":"Inputs!F46","v":5},null,null,{"$f":"MAX(N33:BS33)","v":5},null,null,{"$f":"$H$33","v":5},{"$f":"$H$33","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,null,"km/Truck-Day",null,null,"km/day",null,null,null,{"$f":"MAX(N34:BS34)","v":50},null,null,{"$f":"N32*N33","v":50},{"$f":"O32*O33","v":50},50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50]
[null,null,null,"Days of Operation per week",null,null,"Days",{"$f":"Inputs!F46","v":5},null,null,{"$f":"MAX(N35:BS35)","v":5},null,null,{"$f":"$H$35","v":5},{"$f":"$H$35","v":5},5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5,5]
[null,null,null,"km/week",null,null,"km",null,null,null,{"$f":"MAX(N36:BS36)","v":250},null,null,{"$f":"N34*N35","v":250},{"$f":"O34*O35","v":250},250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250,250]
[null,null,null,"Weeks of Operation per Year",null,null,"Weeks",{"$f":"Inputs!F48","v":50},null,null,50,null,null,{"$f":"$H$37","v":50},{"$f":"$H$37","v":50},50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50]
[null,null,null,null,"Total km per Year/Truck",null,"km/Year",null,null,null,{"$f":"MAX(N38:BS38)","v":12500},null,null,{"$f":"N36*N37","v":12500},{"$f":"O36*O37","v":12500},12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500,12500]
[]
[null,null,null,"Total km per Year for Trucks in Fleet",null,null,"km/year",null,null,null,{"$f":"SUM(N40:BS40)","v":17825000},null,null,{"$f":"N38*N29","v":0},0,0,0,0,0,0,0,0,0,0,0,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,{"$f":"AT38*AT29","v":387500},387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500]
[]
[null,null,null,"Diesel Efficiency ",null,null,"Litre/km",{"$f":"Inputs!F52","v":1.0234999999999999},null,null,null,null,null,{"$f":"$H$42","v":1.0234999999999999},{"$f":"$H$42","v":1.0234999999999999},1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999]
[null,null,null,"Diesel Usage",null,null,"Litre",null,null,null,{"$f":"SUM(N43:BS43)","v":18243887.499999996},null,null,{"$f":"N40*N42","v":0},{"$f":"O40*O42","v":0},0,0,0,0,0,0,0,0,0,0,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994]
[]
[null,null,null,"Hydrogen Efficiency",null,null,"kg/km",{"$f":"Inputs!F61","v":0.17217484432717672},null,null,null,null,null,{"$f":"$H$45","v":0.17217484432717672},{"$f":"$H$45","v":0.17217484432717672},0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672,0.17217484432717672]
[null,null,null,"Hydrogen Usage",null,null,"kg/year",null,null,null,{"$f":"MAX(N46:BS46)","v":66717.752176780981},null,null,{"$f":"N45*N40","v":0},{"$f":"O45*O40","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981]
[]
[null,null,null,"Exchange Rate",null,null,{"$f":"$L$4&\"/USD\"","v":"AUD/USD"},{"$f":"1/Inputs!$F$23","v":1.4084507042253522},null,null,null,null,null,{"$f":"$H$48","v":1.4084507042253522},{"$f":"$H$48","v":1.4084507042253522},1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522,1.4084507042253522]
[null,null,null,"Cost of Diesel Truck - Real",null,null,{"$f":"Inputs!$D$23","v":"AUD"},{"$f":"Inputs!F73*H48","v":435000.00000000006},null,null,null,null,null,{"$f":"$H$49*N16","v":0},0,0,0,0,0,0,0,0,0,0,0,13485000.000000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$H$49*AT16","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]
[null,null,null,"Cost of Hydrogen Truck - Real",null,null,{"$f":"Inputs!$D$23","v":"AUD"},{"$f":"Inputs!F76*H48","v":823235.29411764699},null,null,null,null,null,{"$f":"$H$50*N16","v":0},0,0,0,0,0,0,0,0,0,0,0,25520294.117647056,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$H$50*AT16","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]
[]
[null,null,null,"Real Cost of Diesel",null,null,"AUD/Litre",{"$f":"Inputs!F64*H48","v":1.323943661971831},null,null,null,null,null,{"$f":"$H$52","v":1.323943661971831},{"$f":"$H$52","v":1.323943661971831},1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831]
[null,null,null,"Total Cost of Diesel",null,null,"AUD  ",null,null,null,{"$f":"SUM(N53:BS53)","v":24153879.22535209},null,null,{"$f":"N52*N43","v":0},{"$f":"O52*O43","v":0},0,0,0,0,0,0,0,0,0,0,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538]
[]
[null,null,null,"Equivalent Cost of Hydrogen/kg",null,null,"AUD/kg",null,null,null,{"$f":"MAX(N55:BS55)","v":7.8702341409016245},null,null,{"$f":"IF(N46,N53/N46)","v":false},{"$f":"IF(O46,O53/O46)","v":false},false,false,false,false,false,false,false,false,false,false,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245]
[null,null,null,"Equivalent Cost of Hydrogen/kg",null,null,"USD/kg",null,null,null,{"$f":"MAX(N56:BS56)","v":5.5878662400401531},null,null,{"$f":"N55/$H$48","v":0},{"$f":"O55/$H$48","v":0},0,0,0,0,0,0,0,0,0,0,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531,5.5878662400401531]
[null,null,null,"Cost of Hydrogen Check",null,null,"AUD ",null,null,null,{"$f":"SUM(N57:BS57)","v":24153879.22535209},null,null,{"$f":"N55*N46","v":0},{"$f":"O55*O46","v":0},0,0,0,0,0,0,0,0,0,0,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538]
[]
[null,null,null,"New Trucks",null,null,"Number",null,null,null,{"$f":"SUM(N59:BS59)","v":31},null,null,{"$f":"N16","v":0},0,0,0,0,0,0,0,0,0,0,0,31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AT16","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]
[null,null,null,"Exchange Rate"]
[null,null,null,"Cost of Standard Truck",null,null,"AUD",{"$f":"Inputs!F72","v":435000},null,null,{"$f":"SUM(N61:BS61)","v":13485000},null,null,{"$f":"N59*$H$61","v":0},{"$f":"O59*$H$61","v":0},0,0,0,0,0,0,0,0,0,0,13485000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cost of Hydrogen Truck",null,null,"AUD",{"$f":"Inputs!F75","v":823235.29411764687},null,null,{"$f":"SUM(N62:BS62)","v":25520294.117647052},null,null,{"$f":"$H$62*N59","v":0},{"$f":"$H$62*O59","v":0},0,0,0,0,0,0,0,0,0,0,25520294.117647052,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Added Cost of Hydrogen Trucks",null,null,"AUD",{"$f":"Inputs!F41","v":false},null,null,{"$f":"SUM(N63:BS63)","v":0},null,null,{"$f":"(N62-N61)*$H$63","v":0},{"$f":"(O62-O61)*$H$63","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]
[]
[null,"Electrolyzer"]
[]
[null,null,"Capacity and Efficiency of Electrolyzer"]
[]
[null,null,null,"Total Capacity of Electrolyzer per hour",null,null,"kg/hour",{"$f":"Inputs!F85","v":17.142857142857142},"Tons/hour",null,{"$f":"MAX(N69:BS69)","v":17.142857142857142},null,null,{"$f":"$H69*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,17.142857142857142,{"$f":"$H69*AT8","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]
[null,null,null,"Efficiency of Electrolyzer (Including Compression)",null,null,"kWh/kg",{"$f":"Inputs!F86","v":70},null,null,{"$f":"MAX(N70:BS70)","v":70},null,null,{"$f":"$H$70","v":70},{"$f":"$H$70","v":70},70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70]
[null,null,null,"Total Electricity Used per Hour",null,null,"kW",null,null,null,{"$f":"MAX(N71:CN71)","v":1200},null,null,{"$f":"N69*N70","v":0},{"$f":"O69*O70","v":0},0,0,0,0,0,0,0,0,0,0,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Degradation per Year",null,null,"% p.a."]
[null,null,null,"Degradation Index",null,null,"Index"]
[null,null,null,"Availabile Capacity per Hour",null,null,"kg/hour",{"$f":"Inputs!F90","v":0.97},null,null,{"$f":"SUM(N74:BS74)","v":332.57142857142861},null,null,{"$f":"N69*$H$74","v":0},{"$f":"O69*$H$74","v":0},0,0,0,0,0,0,0,0,0,0,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,16.628571428571426,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Annual Potential Production from Capacity",null,null,"kg/year",8760,null,null,{"$f":"MAX(N76:BS76)","v":145666.28571428568},null,null,{"$f":"N74*$H$76","v":0},{"$f":"O74*$H$76","v":0},0,0,0,0,0,0,0,0,0,0,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,145666.28571428568,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Demanded Production from Trucks",null,null,"kg/year",null,null,null,{"$f":"MAX(N77:BS77)","v":66717.752176780981},null,null,{"$f":"N46","v":0},{"$f":"O46","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981]
[null,null,null,"Total Annual Production (Min)",null,null,"kg/year",null,null,null,{"$f":"MAX(N78:BS78)","v":66717.752176780981},null,null,{"$f":"MIN(N76,N46)","v":0},{"$f":"MIN(O76,O46)","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,{"$f":"MIN(AT76,AT46)","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]
[null,null,null,"Capacity Factor",null,null,"%",null,null,null,{"$f":"MAX(N79:BS79)","v":0.45801780315620338},null,null,{"$f":"IF(N76,N78/N76)","v":false},{"$f":"IF(O76,O78/O76)","v":false},false,false,false,false,false,false,false,false,false,false,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,0.45801780315620338,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,null,"Accumulated Hours of Operation",null,null,"Hours",8760,null,null,{"$f":"MAX(N81:BS81)","v":80244.719112966835},null,null,{"$f":"M81+N79*$H$81","v":0},{"$f":"N81+O79*$H$81","v":0},0,0,0,0,0,0,0,0,0,0,4012.2359556483416,8024.4719112966832,12036.707866945024,16048.943822593366,20061.179778241709,24073.415733890051,28085.651689538394,32097.887645186736,36110.123600835075,40122.359556483418,44134.59551213176,48146.831467780103,52159.067423428445,56171.303379076788,60183.53933472513,64195.775290373473,68208.011246021808,72220.24720167015,76232.483157318493,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835,80244.719112966835]
[null,null,null,"Lifetime Hours of Operation",null,null,"Hours",{"$f":"Inputs!F92","v":100000},null,null,null,null,null,{"$f":"$H$82","v":100000},{"$f":"$H$82","v":100000},100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000,100000]
[null,null,null,"Percent of Life Expired",null,null,"%",null,null,null,{"$f":"MAX(N83:BS83)","v":0.80244719112966834},null,null,{"$f":"N81/N82","v":0},{"$f":"O81/O82","v":0},0,0,0,0,0,0,0,0,0,0,4.0122359556483418E-2,8.0244719112966836E-2,0.12036707866945023,0.16048943822593367,0.20061179778241708,0.24073415733890052,0.28085651689538393,0.32097887645186735,0.36110123600835076,0.40122359556483417,0.44134595512131758,0.48146831467780105,0.5215906742342844,0.56171303379076787,0.60183539334725134,0.64195775290373469,0.68208011246021805,0.72220247201670151,0.76232483157318498,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834,0.80244719112966834]
[null,null,null,"Exchange Rate",null,null,null,{"$f":"1/Inputs!$F$23","v":1.4084507042253522}]
[null,null,"Capital Cost of Electrolyzer",null,null,null,{"$f":"L4","v":"AUD"},{"$f":"Inputs!F96*H84","v":3056200.0000000005},null,null,{"$f":"SUM(N85:BS85)","v":3056200.0000000005},null,null,{"$f":"$H$85*N7","v":0},0,0,0,0,0,0,0,0,0,0,0,3056200.0000000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$H$85*AT7","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]
[]
[null,null,"Electricy Costs"]
[null,null,null,null,"Electricity Required",null,"kWh",null,null,null,{"$f":"MAX(N88:BS88)","v":4670242.652374669},null,null,{"$f":"N78*N70","v":0},{"$f":"O78*O70","v":0},0,0,0,0,0,0,0,0,0,0,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,4670242.652374669,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Electricity Cost/Unit",null,{"$f":"L4&\"/kWh\"","v":"AUD/kWh"},{"$f":"Inputs!F101*H84","v":70.422535211267615},null,{"$f":"H89/1000","v":7.0422535211267609E-2},null,null,null,{"$f":"$J$89","v":7.0422535211267609E-2},7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,{"$f":"$J$89","v":7.0422535211267609E-2},7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2,7.0422535211267609E-2]
[null,null,null,null,"Total Electricity Cost",null,"AUD/Year",null,null,null,{"$f":"MAX(N90:BS90)","v":328890.32763201895},null,null,{"$f":"N88*N89","v":0},{"$f":"O88*O89","v":0},0,0,0,0,0,0,0,0,0,0,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,328890.32763201895,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Electricity Cost/kg",null,"AUD/kg",null,null,null,{"$f":"MAX(N91:BS91)","v":4.9295774647887329},null,null,{"$f":"IF(N78,N90/N78)","v":false},{"$f":"IF(O78,O90/O78)","v":false},false,false,false,false,false,false,false,false,false,false,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,4.9295774647887329,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,"Water Costs"]
[null,null,null,null,"Water Efficiency",null,"L/kg",{"$f":"Inputs!F88","v":11.62},null,null,null,null,null,{"$f":"$H$94","v":11.62},{"$f":"$H$94","v":11.62},11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62,11.62]
[null,null,null,null,"Total Water Used",null,"Litres",null,null,null,{"$f":"MAX(N95:BS95)","v":775260.28029419493},null,null,{"$f":"N94*N78","v":0},{"$f":"O94*O78","v":0},0,0,0,0,0,0,0,0,0,0,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,775260.28029419493,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Water Cost/Unit",null,"AUD/Litre",{"$f":"Inputs!F104/Inputs!F23","v":2.1},null,null,null,null,null,{"$f":"$H$96","v":2.1},{"$f":"$H$96","v":2.1},2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1]
[null,null,null,null,"Total Cost of Water",null,"AUD ",null,null,null,{"$f":"MAX(N97:BS97)","v":1628.0465886178094},null,null,{"$f":"N95*N96/1000","v":0},{"$f":"O95*O96/1000","v":0},0,0,0,0,0,0,0,0,0,0,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,1628.0465886178094,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Cost of Water per kg",null,"AUD/kg",null,null,null,{"$f":"MAX(N98:BS98)","v":2.4402E-2},null,null,{"$f":"IF(N78,N97/N78)","v":false},{"$f":"IF(O78,O97/O78)","v":false},false,false,false,false,false,false,false,false,false,false,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,2.4402E-2,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,"Maintenance and Other"]
[null,null,null,null,"Age of Compressor",null,"Years",null,null,null,null,null,null,{"$f":"M101+N8","v":0},0,0,0,0,0,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,{"$f":"AS101+AT8","v":20},20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[null,null,null,null,"Year of Maintenance",null,"Flag",{"$f":"Inputs!F106","v":8},null,null,{"$f":"SUM(N102:BS102)","v":1},null,null,{"$f":"(N101=$H$102)*1","v":0},{"$f":"(O101=$H$102)*1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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]
[null,null,null,null,"Extraordinary Maintenance",null,"AUD/Year",{"$f":"Inputs!F109","v":1000000},null,{"$f":"1/Inputs!$F$23","v":1.4084507042253522}]
[null,null,null,null,"Extraordinary Maintenance",null,"AUD/Year",{"$f":"H103*J103","v":1408450.7042253523},null,null,{"$f":"AVERAGE(N104:BS104)","v":70422.535211267619},null,null,{"$f":"IF(N8,$H$104*N102)","v":false},false,false,false,false,false,false,false,false,false,false,false,0,0,0,0,0,0,0,1408450.7042253523,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AT8,$H$104*AT102)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,null,null,"Other Maintenance Costs",null,"AUD/Year",{"$f":"Inputs!F111","v":0.03},null,{"$f":"H106*K85","v":91686.000000000015},{"$f":"MAX(N106:BS106)","v":91686.000000000015},null,null,{"$f":"$J$106*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,{"$f":"$J$106*AT8","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]
[null,null,null,null,"Other Maintenance Costs per kg",null,{"$f":"L4&\"/kg\"","v":"AUD/kg"},null,null,null,{"$f":"MAX(N107:BS107)","v":1.3742369460688821},null,null,{"$f":"IF(N78,N106/N78)","v":false},{"$f":"IF(O78,O106/O78)","v":false},false,false,false,false,false,false,false,false,false,false,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,null,null,"Total Maintenance and Other",null,"AUD/Year",null,null,null,{"$f":"MAX(N109:BS109)","v":1500136.7042253523},null,null,{"$f":"SUM(N104:N106)","v":0},{"$f":"SUM(O104:O106)","v":0},0,0,0,0,0,0,0,0,0,0,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,1500136.7042253523,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,91686.000000000015,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Maintenance and Other per kg",null,"AUD/kg",null,null,null,{"$f":"K109/K78","v":22.484820835247319},null,null,{"$f":"IF(N78,N109/N78)","v":false},{"$f":"IF(O78,O109/O78)","v":false},false,false,false,false,false,false,false,false,false,false,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,22.484820835247319,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,1.3742369460688821,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,null,null,"Grand Total Operation Costs",null,"AUD/Year",null,null,null,{"$f":"SUM(N112:BS112)","v":9852538.1886380892},null,null,{"$f":"N109+N97+N90","v":0},{"$f":"O109+O97+O90","v":0},0,0,0,0,0,0,0,0,0,0,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,1830655.0784459892,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,0,0,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,"Compression and Storage"]
[null,null,"Storate Capacity"]
[null,null,null,"Storage Capacity",null,null,"kg",{"$f":"Inputs!F117","v":345},null,null,null,null,null,{"$f":"$H$116*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,345,{"$f":"$H$116*AT8","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]
[null,null,null,"Average Hourly Production",null,null,"kg/hour",null,null,null,null,null,null,{"$f":"N78/8760","v":0},{"$f":"O78/8760","v":0},0,0,0,0,0,0,0,0,0,0,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,7.6161817553402944,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Potential Hours of Storage",null,null,"Hrs",null,null,null,{"$f":"MAX(N118:BS118)","v":45.298288707211299},null,null,{"$f":"IF(N117,N116/N117)","v":false},{"$f":"IF(O117,O116/O117)","v":false},false,false,false,false,false,false,false,false,false,false,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,45.298288707211299,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,{"$f":"1/Inputs!$F$23","v":1.4084507042253522}]
[null,null,null,"Cost of Compressor and Storage",null,null,"AUD",{"$f":"Inputs!F121*H119","v":2225142},null,null,{"$f":"SUM(N120:BS120)","v":2225142},null,null,{"$f":"$H$120*N7","v":0},0,0,0,0,0,0,0,0,0,0,0,2225142,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$H$120*AT7","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]
[]
[null,null,"Maintenance and Other"]
[null,null,null,null,"Year of Maintence",null,"Flag",null,null,null,{"$f":"SUM(N123:BS123)","v":1},null,null,{"$f":"N102","v":0},{"$f":"O102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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]
[null,null,null,null,"Levelised Maintenance",null,"AUD/Year",{"$f":"Inputs!F130","v":0},null,null,{"$f":"MAX(N124:BS124)","v":0},null,null,{"$f":"$H$124*N8","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":"$H$124*AT8","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]
[null,null,null,null,"Other Overhead Costs",null,"AUD/Year",{"$f":"Inputs!F132","v":0.17496268485692706},null,{"$f":"H125*K99","v":0},{"$f":"MAX(N125:BS125)","v":389316.81850791239},null,null,{"$f":"$H$125*N8*$H$120","v":0},0,0,0,0,0,0,0,0,0,0,0,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,{"$f":"$H$125*AT8*$H$120","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]
[null,null,null,null,"Total Maintenance and Other",null,"AUD",null,null,null,{"$f":"MAX(N126:BS126)","v":389316.81850791239},null,null,{"$f":"SUM(N124:N125)","v":0},{"$f":"SUM(O124:O125)","v":0},0,0,0,0,0,0,0,0,0,0,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Total Production",null,"kg/Year",null,null,null,{"$f":"MAX(N128:BS128)","v":66717.752176780981},null,null,{"$f":"N78","v":0},{"$f":"O78","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Cost per kg",null,{"$f":"L4&\"/kg\"","v":"AUD/kg"},null,null,null,{"$f":"MAX(N129:BS129)","v":5.8352808031713321},null,null,{"$f":"IF(N128,N126/N128)","v":false},{"$f":"IF(O128,O126/O128)","v":false},false,false,false,false,false,false,false,false,false,false,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,5.8352808031713321,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Dispensor +  Chiller +heat exchange +associated pipework "]
[null,null,"Capacity"]
[null,null,null,"Fillling Rate per Nozzel in kg/Minute",null,null,"kg/Minute",{"$f":"Inputs!F141","v":2.9411764705882355},null,null,{"$f":"MAX(Z133:BS133)","v":2.9411764705882355},null,null,{"$f":"$H$133*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,2.9411764705882355,{"$f":"$H$133*AT8","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]
[]
[null,null,null,"Production for All Trucks",null,null,"kg/Year",null,null,null,{"$f":"MAX(N135:BS135)","v":66717.752176780981},null,null,{"$f":"N46","v":0},0,0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,{"$f":"AT46","v":66717.752176780981},66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981]
[null,null,null,"Total Trucks",null,null,"Number",null,null,null,{"$f":"MAX(N136:BS136)","v":31},null,null,{"$f":"N29","v":0},0,0,0,0,0,0,0,0,0,0,0,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,{"$f":"AT29","v":31},31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31]
[null,null,null,"kg Use per Truck",null,null,"kg/Year/truck",null,null,null,{"$f":"MAX(N137:BS137)","v":2152.1855540897091},null,null,{"$f":"IF(N136,N135/N136)","v":false},{"$f":"IF(O136,O135/O136)","v":false},false,false,false,false,false,false,false,false,false,false,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091,2152.1855540897091]
[null,null,null,"Required kg per Day per Truck",null,null,"kg/Truck/Day",null,null,null,{"$f":"MAX(Z138:BS138)","v":5.8963987783279697},null,null,{"$f":"N137/365","v":0},{"$f":"O137/365","v":0},0,0,0,0,0,0,0,0,0,0,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697,5.8963987783279697]
[]
[null,null,null,"Minutes of Filling without Manovering per Truck",null,null,"Minutes/Fill",null,null,null,{"$f":"MAX(Z140:BS140)","v":2.0047755846315094},null,null,{"$f":"IF(N133,N138/N133)","v":false},{"$f":"IF(O133,O138/O133)","v":false},false,false,false,false,false,false,false,false,false,false,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,2.0047755846315094,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,"Manouvering Time",null,null,"Minutes/Fill",{"$f":"Inputs!F146","v":1},null,null,1,null,null,{"$f":"$H$141*N8","v":0},0,0,0,0,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,{"$f":"$H$141*AT8","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]
[null,null,null,"Total Required Time per Truck",null,null,"Minutes/Day",null,null,null,3.0047755846315094,null,null,{"$f":"N140+N141","v":0},{"$f":"O140+O141","v":0},0,0,0,0,0,0,0,0,0,0,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,3.0047755846315094,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Trucks",null,null,"Number",null,null,null,{"$f":"MAX(N143:BS143)","v":31},null,null,{"$f":"N136","v":0},{"$f":"O136","v":0},0,0,0,0,0,0,0,0,0,0,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31,31]
[null,null,null,"Total Required Time per Filling Period 1 Dispenser",null,null,"Minutes",null,null,null,93.148043123576798,null,null,{"$f":"N143*N142","v":0},{"$f":"O143*O142","v":0},0,0,0,0,0,0,0,0,0,0,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,93.148043123576798,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Target Time for Filling",null,null,"Minutes",{"$f":"Inputs!F147","v":30},null,null,null,null,null,{"$f":"$H$145","v":30},{"$f":"$H$145","v":30},30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30]
[null,null,null,"Number of Dispensers without Round",null,null,"Number",null,null,null,{"$f":"MAX(N146:BS146)","v":3.1049347707858934},null,null,{"$f":"N144/N145","v":0},{"$f":"O144/O145","v":0},0,0,0,0,0,0,0,0,0,0,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,3.1049347707858934,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Rounded Number of Dispensers",null,null,"Number",null,null,null,{"$f":"MAX(N147:BS147)","v":4},null,null,{"$f":"ROUNDUP(N146,0)","v":0},{"$f":"ROUNDUP(O146,0)","v":0},0,0,0,0,0,0,0,0,0,0,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Exchange Rate",null,null,{"$f":"$L$4&\"/USD\"","v":"AUD/USD"},{"$f":"1/Inputs!$F$23","v":1.4084507042253522}]
[null,null,null,"Total Capital Cost of Single Dispensor",null,null,{"$f":"L4","v":"AUD"},{"$f":"Inputs!F144*H149","v":340111.08906962909},null,{"$f":"Inputs!F137","v":true},{"$f":"SUM(N150:BS150)","v":340111.08906962909},null,null,{"$f":"$H$150*N7*$J$150","v":0},0,0,0,0,0,0,0,0,0,0,0,340111.08906962909,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$H$150*AT7*$J$150","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]
[null,null,null,"Total Capital Cost of All Dispensors",null,null,{"$f":"L4","v":"AUD"},null,null,null,{"$f":"SUM(N151:BS151)","v":1360444.3562785164},null,null,{"$f":"N150*N147","v":0},{"$f":"O150*O147","v":0},0,0,0,0,0,0,0,0,0,0,1360444.3562785164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Operating Cost of Dispensor",null,null,{"$f":"L4","v":"AUD"},{"$f":"Inputs!F132","v":0.17496268485692706},null,null,{"$f":"SUM(N153:BS153)","v":4760539.9434588598},null,null,{"$f":"$K$151*$H$153*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,{"$f":"$K$151*$H$153*AT8","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]
[]
[null,null,null,"Total Production",null,null,"kg/year",null,null,null,{"$f":"MAX(N155:BS155)","v":66717.752176780981},null,null,{"$f":"N78","v":0},{"$f":"O78","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Cost/kg",null,null,{"$f":"L4&\"/kg\"","v":"AUD/kg"},null,null,null,{"$f":"MAX(N156:BS156)","v":3.5676711131131436},null,null,{"$f":"IF(N155,N153/N155)","v":false},{"$f":"IF(O155,O153/O155)","v":false},false,false,false,false,false,false,false,false,false,false,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,3.5676711131131436,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,"Summary of Cash Flow and Required Support"]
[" "]
[null,null,"Total Truck Use"]
[null,null,null,"Total km Travelled",null,null,"km/year",null,null,null,{"$f":"MAX(N161:BS161)","v":387500},null,null,{"$f":"N40","v":0},{"$f":"O40","v":0},0,0,0,0,0,0,0,0,0,0,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500,387500]
[null,null,null,"Effiency",null,null,"Litre/km",null,null,null,{"$f":"MAX(N162:BS162)","v":1.0234999999999999},null,null,{"$f":"N42","v":1.0234999999999999},{"$f":"O42","v":1.0234999999999999},1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999,1.0234999999999999]
[null,null,null,"Diesel Use",null,null,"Litre/year",null,null,null,{"$f":"MAX(N163:BS163)","v":396606.24999999994},null,null,{"$f":"N161*N162","v":0},{"$f":"O161*O162","v":0},0,0,0,0,0,0,0,0,0,0,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994]
[null,null,null,"Diesel Price",null,null,{"$f":"L4&\"/Litre\"","v":"AUD/Litre"},{"$f":"Inputs!F64*J164","v":1.323943661971831},null,{"$f":"1/Inputs!$F$23","v":1.4084507042253522},null,null,null,{"$f":"$H$164","v":1.323943661971831},{"$f":"$H$164","v":1.323943661971831},1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831,1.323943661971831]
[null,null,null,"Total Diesel Cost",null,null,{"$f":"L4","v":"AUD"},null,null,null,{"$f":"MAX(N165:BS165)","v":525084.33098591538},null,null,{"$f":"N163*N164","v":0},{"$f":"O163*O164","v":0},0,0,0,0,0,0,0,0,0,0,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538]
[]
[null,null,"Revenues"]
[null,null,null,"Unadjusted Annual Demand",null,null,"kg/Year",null,null,null,{"$f":"MAX(N168:BS168)","v":66717.752176780981},null,null,{"$f":"N46","v":0},0,0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,{"$f":"AT46","v":66717.752176780981},66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981]
[null,null,null,"Equivalent Cost of Diesel",null,null,"AUD/kg",null,null,null,{"$f":"MAX(N169:BS169)","v":7.8702341409016245},null,null,{"$f":"IF(N168,N165/N168)","v":false},{"$f":"IF(O168,O165/O168)","v":false},false,false,false,false,false,false,false,false,false,false,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245,7.8702341409016245]
[null,null,null,"Total Revenues",null,null,"AUD ",null,null,null,{"$f":"MAX(N170:BS170)","v":525084.33098591538},null,null,{"$f":"N169*N168","v":0},{"$f":"O169*O168","v":0},0,0,0,0,0,0,0,0,0,0,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538]
[]
[null,null,"Capital Expenditures"]
[null,null,null,"Truck Cost",null,null,{"$f":"$L$4","v":"AUD"},null,null,null,{"$f":"SUM(N173:BS173)","v":0},null,null,{"$f":"N63","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":"AT63","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]
[null,null,null,"Electrolyzer Cap Exp",null,null,{"$f":"$L$4","v":"AUD"},null,null,null,{"$f":"SUM(N174:BS174)","v":3056200.0000000005},null,null,{"$f":"N85","v":0},0,0,0,0,0,0,0,0,0,0,0,3056200.0000000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AT85","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]
[null,null,null,"Storage and Compression Cap Exp",null,null,"AUD",null,null,null,{"$f":"SUM(N175:BS175)","v":2225142},null,null,{"$f":"N120","v":0},0,0,0,0,0,0,0,0,0,0,0,2225142,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AT120","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]
[null,null,null,"Dispenser",null,null,"AUD",null,null,null,{"$f":"SUM(N176:BS176)","v":1360444.3562785164},null,null,{"$f":"N151","v":0},{"$f":"O151","v":0},0,0,0,0,0,0,0,0,0,0,1360444.3562785164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Capital Expenditures",null,null,{"$f":"L4","v":"AUD"},null,null,null,{"$f":"SUM(N177:BS177)","v":6641786.3562785164},null,null,{"$f":"SUM(N173:N176)","v":0},{"$f":"SUM(O173:O176)","v":0},0,0,0,0,0,0,0,0,0,0,6641786.3562785164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Operating Expenditures"]
[null,null,null,"Electrolyzer",null,null,{"$f":"$L$4","v":"AUD"},{"$f":"NOT(Inputs!$F$173)","v":true},null,null,{"$f":"SUM(N180:BS180)","v":9852538.1886380892},null,null,{"$f":"N112*$H$180","v":0},{"$f":"O112*$H$180","v":0},0,0,0,0,0,0,0,0,0,0,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,1830655.0784459892,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,422204.37422063679,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Storage and Compression",null,null,{"$f":"$L$4","v":"AUD"},{"$f":"NOT(Inputs!$F$173)","v":true},null,null,{"$f":"SUM(N181:BS181)","v":7786336.3701582504},null,null,{"$f":"N126*$H$181","v":0},{"$f":"O126*$H$181","v":0},0,0,0,0,0,0,0,0,0,0,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,389316.81850791239,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Dispenser",null,null,"AUD",{"$f":"NOT(Inputs!$F$173)","v":true},null,null,{"$f":"SUM(N182:BS182)","v":4760539.9434588598},null,null,{"$f":"N153*$H$182","v":0},{"$f":"O153*$H$182","v":0},0,0,0,0,0,0,0,0,0,0,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,238026.99717294305,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Operating Expenses",null,null,{"$f":"G182","v":"AUD"},null,null,null,{"$f":"SUM(N183:BS183)","v":22399414.502255201},null,null,{"$f":"SUM(N180:N182)","v":0},{"$f":"SUM(O180:O182)","v":0},0,0,0,0,0,0,0,0,0,0,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,2457998.8941268446,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"NPV of Cash Flow",null,null,null,{"$f":"NPV(G188,N185:BS185)","v":21679176.584220193},null,null,{"$f":"SUM(N185:BS185)","v":29041200.858533725},null,null,{"$f":"IF(N8,N177+N183)","v":false},false,false,false,false,false,false,false,false,false,false,false,7691334.5461800089,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,2457998.8941268446,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,1049548.1899014923,{"$f":"IF(AT8,AT177+AT183)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,"Periods",null,null,null,null,null,null,{"$f":"SUM(N186:BS186)","v":20},null,null,{"$f":"N8","v":0},0,0,0,0,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,{"$f":"AT8","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]
[]
[null,null,null,"Payment Factor",null,null,{"$f":"Inputs!F171","v":0.04},null,null,null,{"$f":"PMT(G188,K186,-1)","v":7.3581750328628889E-2},0]
[null,null,null,"Annual Payment",null,null,null,null,null,null,{"$f":"H185*K188","v":1595191.7587503479}]
[]
[null,null,null,"Required Revenues",null,null,null,{"$f":"K189","v":1595191.7587503479},null,null,{"$f":"MAX(N191:BS191)","v":1595191.7587503479},null,null,{"$f":"$H$191*N8","v":0},0,0,0,0,0,0,0,0,0,0,0,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,1595191.7587503479,{"$f":"$H$191*AT8","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]
[null,null,null,"Net Cash Flow",null,null,null,null,null,null,null,null,null,{"$f":"IF(N8,N191-N185)","v":false},false,false,false,false,false,false,false,false,false,false,false,-6096142.7874296606,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,-862807.13537649671,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,545643.56884885556,{"$f":"IF(AT8,AT191-AT185)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[]
[null,null,null,"NPV of Net Cash Flow Check",null,null,null,{"$f":"NPV(G188,N192:BS192)","v":-9.3468070889894773E-9}]
[]
[null,null,null,"Diesel Costs",null,null,{"$f":"L4","v":"AUD"},null,null,null,{"$f":"MAX(N196:BS196)","v":525084.33098591538},null,null,{"$f":"N165","v":0},{"$f":"O165","v":0},0,0,0,0,0,0,0,0,0,0,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538,525084.33098591538]
[null,null,null,"Percent increase in Revenues",null,null,"% p.a.",null,null,null,{"$f":"MAX(N197:BS197)","v":2.0379725019696626},{"$f":"K191/K196-1","v":2.0379725019696626},null,{"$f":"IF(N196,N191/N196-1)","v":false},{"$f":"IF(O196,O191/O196-1)","v":false},false,false,false,false,false,false,false,false,false,false,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,2.0379725019696626,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1]
[null,null,null,"Total Hydrogen Required",null,null,"kg",null,null,null,{"$f":"MAX(N198:BS198)","v":66717.752176780981},null,null,{"$f":"N46","v":0},{"$f":"O46","v":0},0,0,0,0,0,0,0,0,0,0,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981,66717.752176780981]
[null,null,null,"Cost per kg of Hydrogen",null,null,{"$f":"L4&\"/kg\"","v":"AUD/kg"},null,null,null,{"$f":"MAX(N199:BS199)","v":23.909554904121968},null,null,{"$f":"IF(N198,N191/N198)","v":false},{"$f":"IF(O198,O191/O198)","v":false},false,false,false,false,false,false,false,false,false,false,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,23.909554904121968,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Total Diesel Used",null,null,"Litres",null,null,null,{"$f":"MAX(N201:BS201)","v":396606.24999999994},null,null,{"$f":"N163","v":0},{"$f":"O163","v":0},0,0,0,0,0,0,0,0,0,0,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994,396606.24999999994]
[null,null,null,"Equivelant Cost of Diesel",null,null,{"$f":"L4&\"/L\"","v":"AUD/L"},null,null,null,{"$f":"MAX(N202:BS202)","v":4.0221044392274408},null,null,{"$f":"IF(N201,N191/N201)","v":false},{"$f":"IF(O201,O191/O201)","v":false},false,false,false,false,false,false,false,false,false,false,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,4.0221044392274408,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Electrolyzer Database","index":4,"n_rows":97,"n_cols":42,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Scenario No",null,1]
[null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]
[null,null,null,null,"Applied",null,"Applied","Base Case","Average","Median","Mario 2","Mario 3","Stanford 1","Stanford 2","Forecourt Current","Central Current","AEC Small","AEC Med","AEC Large","PEM Small","PEM Med","PEM Large","SOEC Small","SOEC Med","SOEC Large","HTP-Small","HTP-Med","HTP-Large","Forecourt Future","Central Future","AEC Small","AEC Med","AEC Large","PEM Small","PEM Med","PEM Large","SOEC Small","SOEC Med","SOEC Large","HTP-Small","HTP-Med","HTP-Large"]
[null,null,null,null,null,null,null,2020,"","",2020,2020,2016,2016,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019 @ P atm","2019 @ P atm","2019 @ P atm","2019 @ 30 bar","2019 @ 30 bar","2019 @ 30 bar","2019 @ P atm","2019 @ P atm","2019 @ P atm","2019 @ 20 bar","2019 @ 20 bar","2019 @ 20 bar",null,null,"2025 @ 15 bar","2025 @ 15 bar","2025 @ 15 bar","2019 @ 30 bar","2019 @ 30 bar","2019 @ 30 bar","2025 @ 20 bar","2025 @ 20 bar","2025 @ 20 bar","2025 @ 50 bar","2025 @ 50 bar","2025 @ 50 bar"]
[null,"Production and Efficiency"]
[null,null,"Production capacity","kg/h",null,1,{"$f":"INDEX(H7:AP7,F7)","v":17.142857142857142},{"$f":"H11/H12","v":17.142857142857142},{"$f":"AVERAGE(K7:AP7)","v":286.49068948885883},{"$f":"MEDIAN(K7:AP7)","v":95.246734397677798},20,20,20,20,{"$f":"'NREL Backup'!N9","v":62.5},{"$f":"'NREL Backup'!P9","v":2083.3333333333335},{"$f":"Q11/Q12","v":17.241379310344829},96.15384615384616,392.15686274509807,15.873015873015873,81.967213114754102,344.82758620689657,27.777777777777779,142.85714285714286,588.23529411764707,20.833333333333332,108.69565217391305,454.54545454545456,{"$f":"'NREL Backup'!O9","v":62.5},{"$f":"'NREL Backup'!Q9","v":2083.3333333333335},{"$f":"AE11/AE12","v":18.181818181818183},100,408.16326530612247,18.518518518518519,94.339622641509436,384.61538461538464,29.411764705882351,151.5151515151515,625,23.80952380952381,125,526.31578947368416]
[null,null,"Production capacity","kg/day",null,1,{"$f":"INDEX(H8:AP8,F8)","v":411.42857142857144},{"$f":"H7*24","v":411.42857142857144},{"$f":"AVERAGE(K8:AP8)","v":6875.7765477326157},{"$f":"MEDIAN(K8:AP8)","v":2285.921625544267},{"$f":"K7*24","v":480},{"$f":"L7*24","v":480},{"$f":"M7*24","v":480},{"$f":"N7*24","v":480},{"$f":"'NREL Backup'!N5","v":1500},{"$f":"'NREL Backup'!P5","v":50000},{"$f":"Q7*24","v":413.79310344827593},2307.6923076923076,9411.7647058823532,380.95238095238096,1967.2131147540986,8275.8620689655181,666.66666666666674,3428.5714285714284,14117.64705882353,500,2608.695652173913,10909.09090909091,{"$f":"'NREL Backup'!O5","v":1500},{"$f":"'NREL Backup'!Q5","v":50000},{"$f":"AE7*24","v":436.36363636363637},2400,9795.9183673469397,444.44444444444446,2264.1509433962265,9230.7692307692305,705.88235294117646,3636.363636363636,15000,571.42857142857144,3000,12631.57894736842]
[null,null,"Water consumption","L/kg",null,1,{"$f":"INDEX(H9:AP9,F9)","v":11.62},11.62,12.892325,13.309999999999999,11.62,11.62,11.62,11.62,{"$f":"'NREL Backup'!N28*'NREL Backup'!N29","v":17.992799999999999},{"$f":"'NREL Backup'!P28*'NREL Backup'!P29","v":17.992799999999999},15,15,15,15,15,15,10,10,10,10,10,10,{"$f":"'NREL Backup'!O28*'NREL Backup'!O29","v":15.0444},{"$f":"'NREL Backup'!Q28*'NREL Backup'!Q29","v":15.0444},15,15,15,15,15,15,10,10,10,10,10,10]
[null,null,"Nominal power","MW",null,1,{"$f":"INDEX(H10:AP10,F10)","v":1.2},{"$f":"H7*H12/1000","v":1.2},13.645633223684211,5,{"$f":"K7*K12/1000","v":1.4},{"$f":"L7*L12/1000","v":1.1599999999999999},{"$f":"M7*M12/1000","v":1.0526315789473686},{"$f":"N7*N12/1000","v":1.0526315789473686},{"$f":"'NREL Backup'!N7/1000","v":3.1429999999999998},{"$f":"'NREL Backup'!P7/1000","v":113.125},1,5,20,1,5,20,1,5,20,1,5,20,{"$f":"'NREL Backup'!O7/1000","v":3.1440000000000001},{"$f":"'NREL Backup'!Q7/1000","v":104.583},1,5,20,1,5,20,1,5,20,1,5,20]
[null,null,"Nominal Power","kWh",null,1,{"$f":"INDEX(H11:AP11,F11)","v":1200},1200,13645.63322368421,5000,{"$f":"K10*1000","v":1400},{"$f":"L10*1000","v":1160},{"$f":"M10*1000","v":1052.6315789473686},{"$f":"N10*1000","v":1052.6315789473686},{"$f":"'NREL Backup'!N7","v":3143},{"$f":"'NREL Backup'!P7","v":113125},{"$f":"Q10*1000","v":1000},5000,20000,1000,5000,20000,1000,5000,20000,1000,5000,20000,{"$f":"'NREL Backup'!O7","v":3144},{"$f":"'NREL Backup'!Q7","v":104583},{"$f":"AE10*1000","v":1000},5000,20000,1000,5000,20000,1000,5000,20000,1000,5000,20000]
[null,null,"Efficiency","kWh/kg",null,1,{"$f":"INDEX(H12:AP12,F12)","v":70},70,48.636093684210522,50.295999999999999,70,58,{"$f":"'Stanford Article'!C4","v":52.631578947368425},{"$f":"'Stanford Article'!D4","v":52.631578947368425},{"$f":"'NREL Backup'!N10","v":50.287999999999997},{"$f":"'NREL Backup'!P10","v":54.3},58,52,51,63,61,58,36,35,34,48,46,44,{"$f":"'NREL Backup'!O10","v":50.304000000000002},{"$f":"'NREL Backup'!Q10","v":50.199839999999995},55,50,49,54,53,52,34,33,32,42,40,38]
[null,null,"Efficieny","kg/kWh",null,1,{"$f":"INDEX(H13:AP13,F13)","v":1.4285714285714285E-2},{"$f":"1/H12","v":1.4285714285714285E-2},2.1424191116806244E-2,1.9882297305940176E-2,{"$f":"1/K12","v":1.4285714285714285E-2},{"$f":"1/L12","v":1.7241379310344827E-2},1.9E-2,1.9E-2,1.9885459751829464E-2,1.841620626151013E-2,1.7241379310344827E-2,1.9230769230769232E-2,1.9607843137254902E-2,1.5873015873015872E-2,1.6393442622950821E-2,1.7241379310344827E-2,2.7777777777777776E-2,2.8571428571428571E-2,2.9411764705882353E-2,2.0833333333333332E-2,2.1739130434782608E-2,2.2727272727272728E-2,1.9879134860050891E-2,1.9920382216357665E-2,1.8181818181818181E-2,0.02,2.0408163265306121E-2,1.8518518518518517E-2,1.8867924528301886E-2,1.9230769230769232E-2,2.9411764705882353E-2,3.0303030303030304E-2,3.125E-2,2.3809523809523808E-2,2.5000000000000001E-2,2.6315789473684209E-2]
[null,null,"Availability","%/year",null,1,{"$f":"INDEX(H14:AP14,F14)","v":0.97},0.97,0.97750000000000015,0.98,0.97,0.97,0.97,0.97,{"$f":"'NREL Backup'!N4","v":0.97},{"$f":"'NREL Backup'!P4","v":0.97},0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,{"$f":"'NREL Backup'!O4","v":0.97},{"$f":"'NREL Backup'!Q4","v":0.97},0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98,0.98]
[]
[null,"Lifetime and Cap Exp",null,null,null,1]
[null,null,"Lifetime - System","Years",null,1,{"$f":"INDEX(H17:AP17,F17)","v":20},20,{"$f":"AVERAGE(K17:AP17)","v":20},{"$f":"MEDIAN(K17:AP17)","v":20},20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20]
[null,null,"Degradation - system","%/1000 h",null,1,{"$f":"INDEX(H18:AP18,F18)","v":1E-3},1E-3,{"$f":"AVERAGE(K18:AP18)","v":1.7668000000000003E-2},{"$f":"MEDIAN(K18:AP18)","v":2.5000000000000001E-3},1E-3,null,null,null,null,null,1.2999999999999999E-3,1.2999999999999999E-3,1.2999999999999999E-3,2.5000000000000001E-3,2.5000000000000001E-3,2.5000000000000001E-3,0.05,0.05,0.05,0.03,0.03,0.03,null,null,1.1000000000000001E-3,1.1000000000000001E-3,1.1000000000000001E-3,2E-3,2E-3,2E-3,0.03,0.03,0.03,0.03,0.03,0.03]
[null,null,null,null,null,1]
[null,null,"CAPEX - total system equipment","€/kW",null,1,{"$f":"INDEX(H20:AP20,F20)","v":2357},2357,{"$f":"AVERAGE(K20:AP20)","v":1373.9285714285713},{"$f":"MEDIAN(K20:AP20)","v":1250},2357,{"$f":"H20","v":2357},{"$f":"'Stanford Article'!C2","v":2287},{"$f":"'Stanford Article'!D2","v":2009},null,null,1200,830,750,1500,1300,1200,2500,2000,1800,1700,1500,1300,null,null,900,600,480,1000,900,700,1600,1400,1200,1200,1000,900]
[null,null,"Exchange Rate","##/USD",null,1,{"$f":"INDEX(H21:AP21,F21)","v":0.71},0.71,{"$f":"AVERAGE(K21:AP21)","v":1.1438461538461537},{"$f":"MEDIAN(K21:AP21)","v":1.18},0.71,0.71,null,null,null,null,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,null,null,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18,1.18]
[null,null,"CAPEX - total system equipment","USD/kW",null,1,{"$f":"INDEX(H22:AP22,F22)","v":1808.2516666666668},1808.2516666666668,1430.6021875000001,1416,{"$f":"K20*K21","v":1673.47},{"$f":"L20","v":2357},{"$f":"M20","v":2287},{"$f":"N20","v":2009},{"$f":"'NREL Backup'!N12","v":940},{"$f":"'NREL Backup'!P12","v":900},{"$f":"Q20*Q21","v":1416},979.4,885,1770,1534,1416,2950,2360,2124,2006,1770,1534,{"$f":"'NREL Backup'!O12","v":450},{"$f":"'NREL Backup'!Q12","v":400},{"$f":"AE20*AE21","v":1062},708,566.4,1180,1062,826,1888,1652,1416,1416,1180,1062]
[null,null,"CAPEX - total system equipment","USD ",null,1,{"$f":"INDEX(H23:AP23,F23)","v":2169902},{"$f":"H22*H11","v":2169902},13253656.351973685,5103500,{"$f":"K22*K11","v":2342858},{"$f":"L22*L11","v":2734120},2407368.4210526319,2114736.8421052634,2954420,101812500,1416000,4897000,17700000,1770000,7670000,28320000,2950000,11800000,42480000,2006000,8850000,30680000,1414800,41833200,1062000,3540000,11328000,1180000,5310000,16520000,1888000,8260000,28320000,1416000,5900000,21240000]
[null,null,"CAPEX - total system equipment","USD/kg-hr",null,1,{"$f":"INDEX(H24:AP24,F24)","v":126577.61666666667},{"$f":"H23/H7","v":126577.61666666667},68312.656848684215,61596,{"$f":"K23/K7","v":117142.9},{"$f":"L23/L7","v":136706},120368.4210526316,105736.84210526317,47270.720000000001,48870,82127.999999999985,50928.799999999996,45135,111510,93574,82128,106200,82600,72216,96288,81420,67496,22636.799999999999,20079.935999999998,58409.999999999993,35400,27753.599999999999,63720,56286,42952,64192,54516.000000000007,45312,59472,47200,40356.000000000007]
[null,null,null,null,null,1]
[null,"O&M Cost",null,null,null,1]
[null,null,"OPEX - Electrolyser system","€/kW/year",null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"Q20*0.04","v":48},{"$f":"R20*0.03","v":24.9},{"$f":"S20*0.02","v":15},{"$f":"T20*0.04","v":60},{"$f":"U20*0.03","v":39},{"$f":"V20*0.02","v":24},{"$f":"W20*0.04","v":100},{"$f":"X20*0.03","v":60},{"$f":"Y20*0.02","v":36},{"$f":"Z20*0.04","v":68},{"$f":"AA20*0.03","v":45},{"$f":"AB20*0.02","v":26},null,null,{"$f":"AE20*0.04","v":36},{"$f":"AF20*0.03","v":18},{"$f":"AG20*0.02","v":9.6},{"$f":"AH20*0.04","v":40},{"$f":"AI20*0.03","v":27},{"$f":"AJ20*0.02","v":14},{"$f":"AK20*0.04","v":64},{"$f":"AL20*0.03","v":42},{"$f":"AM20*0.02","v":24},{"$f":"AN20*0.04","v":48},{"$f":"AO20*0.03","v":30},{"$f":"AP20*0.02","v":18}]
[null,null,"O&M percent ","% of Capital",null,1,{"$f":"INDEX(H28:AP28,F28)","v":0.03},0.03,{"$f":"AVERAGE(K28:AP28)","v":3.0000000000000009E-2},{"$f":"MEDIAN(K28:AP28)","v":0.03},0.03,0.03,0.03,0.03,{"$f":"'NREL Backup'!N23","v":3.2000000000000001E-2},{"$f":"'NREL Backup'!P23","v":0.03},{"$f":"Q27/Q20","v":0.04},0.03,0.02,0.04,0.03,0.02,0.04,0.03,0.02,0.04,0.03,0.02,{"$f":"'NREL Backup'!O23","v":2.8000000000000001E-2},{"$f":"'NREL Backup'!Q23","v":0.03},{"$f":"AE27/AE20","v":0.04},0.03,0.02,0.04,0.03,0.02,0.04,0.03,0.02,0.04,0.03,0.02]
[null,null,null,null,null,1]
[null,null,"Lifetime - Stack @ full charge","Hours",null,1,null,null,null,null,null,null,null,null,null,null,80000,80000,80000,40000,40000,40000,10000,10000,10000,10000,10000,10000,null,null,90000,90000,90000,50000,50000,50000,20000,20000,20000,25000,25000,25000]
[null,null,"Replacement Year","Year",null,1,{"$f":"INDEX(H31:AP31,F31)","v":8},8,{"$f":"AVERAGE(K31:AP31)","v":8.8249143835616444},{"$f":"MEDIAN(K31:AP31)","v":9},8,8,8,8,{"$f":"'NREL Backup'!N25","v":7},{"$f":"'NREL Backup'!P25","v":7},{"$f":"Q30/8760","v":9.1324200913242013},{"$f":"R30/8760","v":9.1324200913242013},{"$f":"S30/8760","v":9.1324200913242013},9,9,9,9,9,9,9,9,9,{"$f":"'NREL Backup'!O25","v":10},{"$f":"'NREL Backup'!Q25","v":10},9,9,9,9,9,9,9,9,9,9,9,9]
[null,null,"CAPEX - Stack replacement*","€/kW",null,1,{"$f":"INDEX(H32:AP32,F32)","v":1000000},1000000,77296.461538461532,437.5,1000000,1000000,null,null,null,null,{"$f":"Q20*0.3","v":360},{"$f":"R20*0.3","v":249},{"$f":"S20*0.3","v":225},525,455,420,700,620,580,525,455,420,null,null,{"$f":"AE20*0.3","v":270},{"$f":"AF20*0.3","v":180},{"$f":"AG20*0.3","v":144},300,270,210,525,455,420,525,455,420]
[null,null,"Replacement Percent",null,null,1,{"$f":"INDEX(H33:AP33,F33)","v":0.46085030568200774},{"$f":"H32/H23","v":0.46085030568200774},0.26806644948043418,0.2556497175141243,{"$f":"K32/K23","v":0.42682911213569069},{"$f":"L32/L23","v":0.36574839436454876},0.25,0.25,{"$f":"'NREL Backup'!N26","v":0.15},{"$f":"'NREL Backup'!P26","v":0.15},{"$f":"Q32/Q22","v":0.25423728813559321},0.25423728813559321,0.25423728813559321,0.29661016949152541,0.29661016949152541,0.29661016949152541,0.23728813559322035,0.26271186440677968,0.27306967984934089,0.26171485543369888,0.25706214689265539,0.27379400260756193,{"$f":"'NREL Backup'!O26","v":0.12},{"$f":"'NREL Backup'!Q26","v":0.12},{"$f":"AE32/AE22","v":0.25423728813559321},0.25423728813559321,0.25423728813559321,0.25423728813559321,0.25423728813559321,0.25423728813559321,0.27807203389830509,0.27542372881355931,0.29661016949152541,0.37076271186440679,0.38559322033898308,0.39548022598870058]
[null,null,null,null,null,1]
[null,"Other",null,null,null,1]
[null,null,"Minimum power","% Pnom",null,1,null,null,null,null,null,null,null,null,null,null,0.15,0.15,0.15,0.05,0.05,0.05,0.3,0.3,0.3,0.2,0.2,0.2,null,null,0.1,0.1,0.1,0,0,0,0.3,0.3,0.3,0.2,0.2,0.2]
[null,null,"Peak power - for 10 min","% Pnom",null,1,null,null,null,null,null,null,null,null,null,null,1,1,1,1.6,1.6,1.6,1.2,1.2,1.2,1.2,1.2,1.2,null,null,1,1,1,2,2,2,1.2,1.2,1.2,1.2,1.2,1.2]
[null,null,"Pressure output","Bar",null,1,null,null,null,null,null,null,null,null,null,null,0,0,0,30,30,30,0,0,0,20,20,20,null,null,15,15,15,60,60,60,20,20,20,20,20,20]
[]
[]
[null,null,"Conversion","1nm3 =0,08.3748 kg"]
[null,null,"WACC","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"Discount rate (for NPV calc)","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[]
[null,null,"* AEC =30%, PEM =40%, SOEC =50% HTP-AEC =50%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"TRANSPOSE(H3:AP4)","v":"Base Case"},2020,{"$f":"I63&\" \"&J63","v":"Base Case 2020"}]
[null,null,null,null,null,null,null,2,"Average","",{"$f":"I64&\" \"&J64","v":"Average "}]
[null,null,null,null,null,null,null,3,"Median","","Median "]
[null,null,null,null,null,null,null,4,"Mario 2",2020,"Mario 2 2020"]
[null,null,null,null,null,null,null,5,"Mario 3",2020,"Mario 3 2020"]
[null,null,null,null,null,null,null,6,"Stanford 1",2016,"Stanford 1 2016"]
[null,null,null,null,null,null,null,7,"Stanford 2",2016,"Stanford 2 2016"]
[null,null,null,null,null,null,null,8,"Forecourt Current",2020,"Forecourt Current 2020"]
[null,null,null,null,null,null,null,9,"Central Current",2020,"Central Current 2020"]
[null,null,null,null,null,null,null,10,"AEC Small",2020,"AEC Small 2020"]
[null,null,null,null,null,null,null,11,"AEC Med",2020,"AEC Med 2020"]
[null,null,null,null,null,null,null,12,"AEC Large",2020,"AEC Large 2020"]
[null,null,null,null,null,null,null,13,"PEM Small",2020,"PEM Small 2020"]
[null,null,null,null,null,null,null,14,"PEM Med",2020,"PEM Med 2020"]
[null,null,null,null,null,null,null,15,"PEM Large",2020,"PEM Large 2020"]
[null,null,null,null,null,null,null,16,"SOEC Small",2020,"SOEC Small 2020"]
[null,null,null,null,null,null,null,17,"SOEC Med",2020,"SOEC Med 2020"]
[null,null,null,null,null,null,null,18,"SOEC Large",2020,"SOEC Large 2020"]
[null,null,null,null,null,null,null,19,"HTP-Small",2020,"HTP-Small 2020"]
[null,null,null,null,null,null,null,20,"HTP-Med",2020,"HTP-Med 2020"]
[null,null,null,null,null,null,null,21,"HTP-Large",2020,"HTP-Large 2020"]
[null,null,null,null,null,null,null,22,"Forecourt Future",2025,"Forecourt Future 2025"]
[null,null,null,null,null,null,null,23,"Central Future",2025,"Central Future 2025"]
[null,null,null,null,null,null,null,24,"AEC Small",2025,"AEC Small 2025"]
[null,null,null,null,null,null,null,25,"AEC Med",2025,"AEC Med 2025"]
[null,null,null,null,null,null,null,26,"AEC Large",2025,"AEC Large 2025"]
[null,null,null,null,null,null,null,27,"PEM Small",2025,"PEM Small 2025"]
[null,null,null,null,null,null,null,28,"PEM Med",2025,"PEM Med 2025"]
[null,null,null,null,null,null,null,29,"PEM Large",2025,"PEM Large 2025"]
[null,null,null,null,null,null,null,30,"SOEC Small",2025,"SOEC Small 2025"]
[null,null,null,null,null,null,null,31,"SOEC Med",2025,"SOEC Med 2025"]
[null,null,null,null,null,null,null,32,"SOEC Large",2025,"SOEC Large 2025"]
[null,null,null,null,null,null,null,33,"HTP-Small",2025,"HTP-Small 2025"]
[null,null,null,null,null,null,null,34,"HTP-Med",2025,"HTP-Med 2025"]
[null,null,null,null,null,null,null,35,"HTP-Large",2025,"HTP-Large 2025"]

{"sheet":"Truck Database","index":5,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,{"$f":"Inputs!$F$23","v":0.71}]
[]
[null,null,null,null,"Scenario",2]
[]
[]
[null,"Conventional Truck"]
[null,null,null,null,null,null,null,null,"General Search",{"$f":"Databook!C17","v":"LMCC (Council) Medium Duty Diesel"},"German Study","Alternative 2"]
[]
[null,null,"Cost of Truck",null,"USD/Truck",2,{"$f":"INDEX(I10:N10,F10)","v":308850},null,295000,{"$f":"Databook!E3*0.71","v":308850},{"$f":"200000*1.18","v":236000},{"$f":"K10","v":236000}]
[null,null,"Cost of Truck",null,"AUD/Truck",2,{"$f":"INDEX(I11:N11,F11)","v":435000},{"$f":"H26","v":0.71},{"$f":"I10/$H$11","v":415492.9577464789},{"$f":"J10/$H$11","v":435000},332394.36619718309,332394.36619718309]
[null,null,"Diesel Efficiency",null,"km/Litre",2,{"$f":"INDEX(I12:N12,F12)","v":0.97703957010258924},null,0.41,0.97703957010258924,0.6,0.6]
[null,null,"Diesel Efficiency",null,"Litre/km",2,{"$f":"1/G12","v":1.0234999999999999},null,{"$f":"1/I12","v":2.4390243902439024},{"$f":"1/J12","v":1.0234999999999999},1.6666666666666667,1.6666666666666667]
[null,null,"Diesel Efficiency",null,"Litre/100km",2,{"$f":"G13*100","v":102.34999999999998},null,{"$f":"I13*100","v":243.90243902439025},{"$f":"J13*100","v":102.34999999999998},166.66666666666669,166.66666666666669]
[null,null,"For Americans",null,"Litre/Gallon",2,{"$f":"0.264172","v":0.26417200000000002},null,{"$f":"0.264172","v":0.26417200000000002},{"$f":"0.264172","v":0.26417200000000002},{"$f":"J15","v":0.26417200000000002},0.26417200000000002]
[null,null,"Diesel Efficiency",null,"km/Gallon",2,{"$f":"G12/G15","v":3.6984978351323727},null,{"$f":"I12/I15","v":1.5520191390457729},{"$f":"J12/J15","v":3.6984978351323727},2.2712475205547897,2.2712475205547897]
[null,null,"For Americans",null,"Miles/km",2,{"$f":"1/0.621371","v":1.6093444978925633},null,{"$f":"1/0.621371","v":1.6093444978925633},{"$f":"1/0.621371","v":1.6093444978925633},{"$f":"1/0.621371","v":1.6093444978925633},1.6093444978925633]
[null,null,"Diesel Efficiency",null,"Miles/Gallon",2,{"$f":"G16*G17","v":5.9521571414378407},null,{"$f":"I16*I17","v":2.4977334620472678},{"$f":"J16*J17","v":5.9521571414378407},{"$f":"K16*K17","v":3.6552197005569775},3.6552197005569775]
[null,null,"Truck Life",null,"Years",2,{"$f":"INDEX(I19:N19,F19)","v":7},null,12,7,12,12]
[]
[null,null,null,null,null,1]
[null,null,null,null,"Htruck",1]
[null,"Hydrogen Trucks"]
[null,null,null,null,null,null,null,null,{"$f":"Databook!C23","v":"Hydrogen FCEV Refuse Truck (@ Model)"},{"$f":"Databook!C9","v":"Hyundai 18T HFCEV Reference"},"German Study"]
[null,null,"Cost of Truck",null,"USD/Truck",1,{"$f":"INDEX(I25:M25,F25)","v":584497.05882352928},null,{"$f":"I26*H26","v":584497.05882352928},{"$f":"J26*H26","v":600158.82352941169},{"$f":"K27*H27","v":501500}]
[null,null,"Cost of Truck",null,"AUD/Truck",1,{"$f":"INDEX(I26:M26,F26)","v":823235.29411764699},{"$f":"Inputs!$F$19","v":0.71},{"$f":"Databook!F64","v":823235.29411764699},{"$f":"Databook!G64","v":845294.1176470588},{"$f":"K25/H26","v":706338.02816901414}]
[null,null,"Cost of Truck",null,"Euro/Truck",1,{"$f":"INDEX(I27:M27,F27)","v":0},{"$f":"Inputs!F20","v":1.18},null,null,425000]
[null,null,"Diesel Efficiency",null,"km/kg",1,{"$f":"INDEX(I28:M28,F28)","v":0.17217484432717672},null,{"$f":"Databook!G25","v":0.17217484432717672},{"$f":"Databook!E12/100","v":8.2500000000000004E-2},0.125]
[null,null,"Diesel Efficiency",null,"kg/km",1,{"$f":"1/G28","v":5.8080493925102177},null,{"$f":"1/I28","v":5.8080493925102177},{"$f":"1/J28","v":12.121212121212121},{"$f":"1/K28","v":8}]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,{"$f":"TRANSPOSE(I8:L8)","v":"General Search"},null,null,{"$f":"TRANSPOSE(I24:K24)","v":"Hydrogen FCEV Refuse Truck (@ Model)"}]
[null,null,null,null,null,2,"LMCC (Council) Medium Duty Diesel",null,null,"Hyundai 18T HFCEV Reference"]
[null,null,null,null,null,3,"German Study",null,null,"German Study"]
[null,null,null,null,null,4,"Alternative 2"]

{"sheet":"Refuller Database","index":6,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Scenario",1,null,null,{"$f":"Inputs!F19","v":0.71}]
[null,null,null,null,null,2,null,null,1,null,null,2,3,4,5]
[]
[null,"Storage",null,null,null,null,null,null,"Base Case","Alternative 1","Alternative 2","Fast Dispenser","Original Estimate","NREL Study Case 1","NREL Study Case 2"]
[null,null,"Storage Capacity",null,"kg",1,{"$f":"INDEX(I6:Q6,F6)","v":345},null,345,345,345,345,{"$f":"L6","v":345},{"$f":"L6","v":345},{"$f":"N6","v":345}]
[null,null,"Associated Production/Day",null,"kg/day",1,{"$f":"INDEX(I7:Q7,F7)","v":480},null,{"$f":"20*24","v":480},{"$f":"20*24","v":480},{"$f":"20*24","v":480},{"$f":"20*24","v":480},{"$f":"20*24","v":480},480,480]
[null,null,"Storage Relative to Daily Production",null,"%",1,{"$f":"INDEX(I8:Q8,F8)","v":0.71875},null,{"$f":"I6/I7","v":0.71875},{"$f":"J6/J7","v":0.71875},{"$f":"K6/K7","v":0.71875},{"$f":"L6/L7","v":0.71875},{"$f":"M6/M7","v":0.71875},0.71875,0.71875]
[null,null,"Cost of Storage and Compressors",null,"AUD",1,{"$f":"INDEX(I9:Q9,F9)","v":2225142},null,2225142,2107142,2107142,{"$f":"I9","v":2225142},{"$f":"M11-M18","v":2714300},{"$f":"N11-N18","v":913224.38497652579},{"$f":"O11-O18","v":555533.1957260808}]
[null,null,"Cost of Storage and Compressors",null,"USD",1,{"$f":"INDEX(I10:Q10,F10)","v":1579850.8199999998},{"$f":"Inputs!F23","v":0.71},{"$f":"I9*$H$10","v":1579850.8199999998},{"$f":"J9*$H$10","v":1496070.8199999998},{"$f":"K9*$H$10","v":1496070.8199999998},{"$f":"I10","v":1579850.8199999998},{"$f":"M9-M19","v":2156453},{"$f":"N9-N19","v":791494.88497652579},{"$f":"O9-O19","v":433803.6957260808}]
[null,null,"Total Cost",null,"AUD",1,{"$f":"INDEX(I11:Q11,F11)","v":2396592},null,{"$f":"I9+I18","v":2396592},{"$f":"J9+J18","v":2278592},{"$f":"K9+K18","v":2278592},{"$f":"L9+L18","v":3010842},{"$f":"Databook!E154","v":3500000},{"$f":"N12/$H$10","v":1084674.3849765258},{"$f":"O12/$H$10","v":726983.1957260808}]
[null,null,"Total Cost",null,"USD",1,{"$f":"INDEX(I12:Q12,F12)","v":1701580.3199999998},null,{"$f":"I10+I19","v":1701580.3199999998},{"$f":"J10+J19","v":1617800.3199999998},{"$f":"K10+K19","v":1617800.3199999998},{"$f":"L10+L19","v":2137697.8199999998},{"$f":"M11*H10","v":2485000},{"$f":"N13*N6","v":770118.81333333335},{"$f":"O13*O6","v":516158.06896551733},{"$f":"P6*P13","v":0}]
[null,null,"Total Cost/kg",null,"USD/kg",1,{"$f":"INDEX(I13:Q13,F13)","v":4579.2777391304344},null,{"$f":"I10/I6","v":4579.2777391304344},{"$f":"J10/J6","v":4336.4371594202894},{"$f":"K10/K6","v":4336.4371594202894},{"$f":"L10/L6","v":4579.2777391304344},{"$f":"M12/M6","v":7202.898550724638},{"$f":"Refuler!B28","v":2232.2284444444444},{"$f":"Refuler!C28","v":1496.1103448275865},35000]
[null,null,null,null,null,1]
[null,"Dispenser",null,null,null,1]
[null,null,"Flow Rate - kg/Minute",null,"kg/Minute",1,{"$f":"INDEX(I16:Q16,F16)","v":2.9411764705882355},null,{"$f":"50/I25","v":2.9411764705882355},{"$f":"50/J25","v":2.9411764705882355},{"$f":"50/K25","v":2.9411764705882355},{"$f":"50/L25","v":4.5454545454545459},{"$f":"L16","v":4.5454545454545459},{"$f":"M16","v":4.5454545454545459},4.5454545454545459]
[null,null,"Dispenser Cost/Flow Rate",null,"USD/Minute",1,{"$f":"INDEX(I17:Q17,F17)","v":41388.03},null,{"$f":"I19/I16","v":41388.03},{"$f":"J19/J16","v":41388.03},{"$f":"K19/K16","v":41388.03},{"$f":"L19/L16","v":122726.33999999998},{"$f":"L17","v":122726.33999999998},{"$f":"I17","v":41388.03},41388.03]
[null,null,"Dispenser Cost",null,"AUD",1,{"$f":"INDEX(I18:Q18,F18)","v":171450},null,171450,171450,171450,{"$f":"Databook!F251","v":785700},{"$f":"L18","v":785700},{"$f":"I18","v":171450},171450]
[null,null,"Dispenser Cost",null,"USD",1,{"$f":"G18/I2","v":241478.87323943662},null,{"$f":"I18*$I$2","v":121729.5},{"$f":"J18*$I$2","v":121729.5},{"$f":"K18*$I$2","v":121729.5},{"$f":"L18*$I$2","v":557847},{"$f":"M18*$I$2","v":557847},{"$f":"N18*$I$2","v":121729.5},{"$f":"O18*$I$2","v":121729.5}]
[null,null,null,null,null,1]
[null,null,"O&M Percent",null,"%",1,{"$f":"INDEX(I21:O21,F21)","v":0.17496268485692706},null,{"$f":"Refuler!G29","v":0.17496268485692706},0.03,0.03,0.03,0.03,0.03,0.03]
[]
[null,"Other",null,null,null,1]
[null,null,"Minutes/kg",null,null,1,null,null,null,null,null,null,null,null,null,20]
[null,null,"Flow Rate for 50 kg",null,"Minutes",1,null,null,17,17,17,11]
[null,null,"Flow Rate for 1 kG",null,"Minutes",1,null,null,{"$f":"I25/50","v":0.34},{"$f":"J25/50","v":0.34},{"$f":"K25/50","v":0.34},{"$f":"L25/50","v":0.22}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"TRANSPOSE(I5:O5)","v":"Base Case"}]
[null,null,null,null,null,null,null,2,"Alternative 1"]
[null,null,null,null,null,null,null,3,"Alternative 2"]
[null,null,null,null,null,null,null,4,"Fast Dispenser"]
[null,null,null,null,null,null,null,5,"Original Estimate"]
[null,null,null,null,null,null,null,null,"NREL Study Case 1"]
[null,null,null,null,null,null,null,null,"NREL Study Case 2"]

{"sheet":"NREL Backup","index":7,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecourt Current","Forecourt Future","Central Current","Central Future"]
[]
[null,null,null,null,null,null,null,null,null,null,"Production Availablity",null,"%",0.97,0.97,0.97,0.97]
[null,null,null,null,null,null,null,null,null,null,"Plant Design",null,"kg/day",1500,1500,50000,50000]
[null,null,null,null,null,null,null,null,null,null,"Single Unit Size",null,"kg/day",500,750,500,750]
[null,null,null,null,null,null,null,null,null,null,"System Energy",null,"kW",3143,3144,113125,104583]
[]
[null,null,null,null,null,null,null,null,null,null,"Capacity",null,"kg/hour",{"$f":"N5/24","v":62.5},{"$f":"O5/24","v":62.5},2083.3333333333335,2083.3333333333335]
[null,null,null,null,null,null,null,null,null,null,"Efficiency",null,"kwh/kg",{"$f":"N7/N9","v":50.287999999999997},{"$f":"O7/O9","v":50.304000000000002},54.3,50.199839999999995]
[]
[null,null,null,null,null,null,null,null,null,null,"Cost/kW",null,"USD/kW",940,450,900,400]
[null,null,null,null,null,null,null,null,null,null,"Total Cost",null,"USD",{"$f":"N12*N7","v":2954420},{"$f":"O12*O7","v":1414800},101812500,41833200]
[]
[null,null,null,null,null,null,null,null,null,null,"Indirect 1",null,null,50000,50000,{"$f":"P13*0.08","v":8145000},{"$f":"Q13*0.08","v":3346656}]
[null,null,null,null,null,null,null,null,null,null,"Indirect 2",null,null,30000,30000,{"$f":"P13*0.15","v":15271875},{"$f":"Q13*0.15","v":6274980}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Cost",null,null,{"$f":"N13+N15+N16","v":3034420},{"$f":"O13+O15+O16","v":1494800},125229375,51454836]
[null,null,null,null,null,null,null,null,null,null,"Cost/kg",null,null,{"$f":"N18/N9","v":48550.720000000001},{"$f":"O18/O9","v":23916.799999999999},60110.1,24698.321279999996]
[]
[null,null,null,null,null,null,null,null,null,null,"AUD",0.71,null,{"$f":"N19/$L$21","v":68381.295774647893},{"$f":"O19/$L$21","v":33685.633802816905},84662.112676056335,34786.367999999995]
[]
[null,null,null,null,null,null,null,null,null,null,"Maint %",null,null,3.2000000000000001E-2,2.8000000000000001E-2,0.03,0.03]
[]
[null,null,null,null,null,null,null,null,null,null,"Replacement Year",null,null,7,10,7,10]
[null,null,null,null,null,null,null,null,null,null,"Replacement Percent",null,null,0.15,0.12,0.15,0.12]
[]
[null,null,null,null,null,null,null,null,null,null,"Water Usage ","gal/kg",null,4.76,3.98,4.76,3.98]
[null,null,null,null,null,null,null,null,null,null,"Converstion","L/gal",null,3.78,3.78,3.78,3.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N28*N29","v":17.992799999999999},{"$f":"O28*O29","v":15.0444},17.992799999999999,15.0444]

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

{"sheet":"Stanford Article","index":9,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Germany Texas",null,"Euro","USD"]
["PtG system price SPh e/kW /kW","Cost/kW",2287,2009]
["Conversion rate of PtG \u0011 kg/kWh kg/kWh","kg/kWh",1.9E-2,1.9E-2]
[null,"kwh/kg",{"$f":"1/C3","v":52.631578947368425},{"$f":"1/D3","v":52.631578947368425}]
["Wind system price SPe e/kW /kW","Cost/kW",1367,1596]
["Wind capacity factor CF","%",30.27,34.61]
["Electricity price pe ect/kWh ct/kWh",null,3.18,2.5499999999999998]
["Subsidy: PP or PTC ect/kWh ct/kWh",null,6.16,2.2999999999999998]
["Cost of capital WACC r",null,4,6]
["Germany Texas"]
["Break even price of hydrogen e/kg /kg",null,3.23,3.53]
["Co variation coe\u000ecient",null,0.88,0.89]
["Levelized cost of electricity ect/kWh ct/kWh",null,5.36,3.02]
["Wind energy pro\ft margin ect/kWh /kWh",null,0.63,-0.27]
["Conversion premium ect/kWh /kWh",null,2.85,4.2300000000000004]
["Levelized \fxed cost of hydrogen ect/kWh /kWh",null,2.54,2.4700000000000002]
["Optimal PtG capacity kW kW",null,0.01,0.28999999999999998]

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

{"sheet":"Fuel Economy by Vehicle Type","index":11,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,1,15,4],[1,1,1,4],[22,1,22,4],[24,1,24,4],[16,1,16,4],[25,1,25,4],[20,1,20,4],[35,1,35,4],[18,1,18,4],[17,1,17,4],[19,1,19,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[34,1,34,4],[29,1,29,4],[23,1,23,4]]}
[]
[null,"Average Fuel Economy by Major Vehicle Category"]
[null,"Vehicle Type","MPG Gasoline","MPG Diesel","Source"]
[null,"Refuse Truck",{"$f":"D4*0.885","v":2.4779999999999998},2.8,"A"]
[null,"Transit Bus",3.2745000000000002,3.7,"B"]
[null,"Class 8 Truck",5.3100000000000005,6,"C"]
[null,"School Bus",6.1950000000000003,7,"D"]
[null,"Delivery Truck",6.5401499999999997,7.39,"C"]
[null,"Paratransit Shuttle",7.08,8,"B"]
[null,"Light Truck/Van",17.5,{"$f":"C10/0.885","v":19.774011299435028},"C"]
[null,"Car",24.2,{"$f":"C11/0.885","v":27.344632768361581},"C"]
[null,"Ridesourcing Vehicle",25.5,{"$f":"C12/0.885","v":28.8135593220339},"E"]
[null,"Motorcycle",44,{"$f":"C13/0.885","v":49.717514124293785},"C"]
[]
[]
[null,"Data Sources:"]
[null,"A:  Gordon, Deborah, Juliet Burdelski, and James S. Cannon.  Greening Garbage Trucks: New Technologies for Cleaner Air.  Inform, Inc. 2003.  ISBN #0-918780-80-2."]
[null,"B:  Calculated from statistics found in American Public Transit Association's Public Transportation Fact Book 2019. Accessed 02/11/2020 at: apta.com/wp-content/uploads/APTA_Fact-Book-2019_FINAL.pdf"]
[null,"C:  Federal Highway Administration. Highway Statistics 2018, Table VM-1.  Accessed 02/11/20 at fhwa.dot.gov/policyinformation/statistics/2018/pdf/vm1.pdf"]
[null,"D:  American School Bus Council.  National School Bus Fuel Data.  Accessed 11/21/18 at americanschoolbuscouncil.org/insights/environment/"]
[null,"E:  Wenzel, Tom, Clement Rames, Eleftheria Kontou, and Alejandro Henao. \"Travel and energy implications of ridesourcing service in Austin, Texas.\" Transportation Research Part D: Transport and Environment 70 (2019): 18-34."]
[]
[null,"Notes:"]
[null,"The metric used is gasoline gallon equivalents (GGEs), representing a quantity of fuel with the same amount of energy contained in a gallon of gasoline."]
[null,"Numbers in bold indicate that the measurements were taken using that fuel.  They are the source of the non-bold energy based conversions."]
[null,"Conversion between diesel and gasoline is 1 gallon gasoline = 0.885 gallons diesel (from the AFDC)"]
[null,"Light-duty vehicles are sales-weighted combination of cars, wagons, vans, sport utility vehicles, and pickups. Vehicles with short wheelbases (<121\") are generalized as cars and vehicles with long wheelbases are generalized as light trucks."]
[null,"Delivery trucks are single-unit trucks with 2 axles and 6 or more tires."]
[null,"Class 8 trucks are combined tractor/trailer trucks, also know as long-haul."]
[null,"Transit buses include both conventional diesel and hybrid-electric diesel."]
[]
[null,"Acronyms:"]
[null,"MPG: Miles per gallon"]
[]
[null,"Worksheet available at afdc.energy.gov/data"]
[null,"Last updated 02/11/2020"]

{"sheet":"Truck Databook","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Refuler","index":13,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Component"]
[]
[]
[]
["Cost",{"$f":"'NREL Backup'!N13","v":2954420},{"$f":"'NREL Backup'!O13","v":1414800},{"$f":"'NREL Backup'!P13","v":101812500},{"$f":"'NREL Backup'!Q13","v":41833200}]
["kg/year",{"$f":"'NREL Backup'!N5*365","v":547500},{"$f":"'NREL Backup'!O5*365","v":547500},{"$f":"'NREL Backup'!P5*365","v":18250000},{"$f":"'NREL Backup'!Q5*365","v":18250000}]
["Capital/kg Produced/yr",{"$f":"B5/B6","v":5.3962009132420095},{"$f":"C5/C6","v":2.5841095890410961},5.5787671232876717,2.2922301369863014]
[null,{"$f":"B10/B7","v":0.25017600747354812},{"$f":"C10/C7","v":0.22444868532654788},0.23840392879066913,0.23121587638526339]
["Eletrolizer","Current Forecourt","Future Forecourt","Current Central","Future"]
["Capital per kg",1.35,0.57999999999999996,1.33,0.53]
["Decommissioning",0.02,0.01,0,0]
["Fixed operations and maintenance (O&M",0.42,0.18,0.4,0.2]
["Feedstock",3.34,3.46,3.38,3.46,null,2107142]
["Variable O&M",0.01,0.01,0.01,0.01]
[]
["Total Production Cost (2007$/kg",5.14,4.2300000000000004,5.12,4.2]
[null,null,null,null,null,null,785700]
["Capital",1.53,0.92]
["Fixed O&M",0.54,0.38]
["Variable O&M",0.36,0.27]
["Total CSD (Forecourt only (2007$/kg",2.44,1.57]
[]
["Total Cost (2007$/kg",7.58,5.79,5.12,4.2,null,118000]
["Cost per kg",{"$f":"B18/B8","v":6.115694368340943},{"$f":"C18/C8","v":4.0989324515824288},0,0,null,{"$f":"G13+G23","v":2225142}]
[]
[null,{"$f":"B24*B6","v":3348342.6666666665},{"$f":"C24*C6","v":2244165.5172413797},null,null,null,526785]
[null,{"$f":"B6/365","v":1500},{"$f":"C6/365","v":1500},null,null,null,{"$f":"G26/G24","v":0.23674219443073746}]
[null,{"$f":"B26/B27","v":2232.2284444444444},{"$f":"C26/C27","v":1496.1103448275865},null,null,null,{"$f":"G24+G17","v":3010842}]
[null,null,null,null,null,null,{"$f":"G26/G28","v":0.17496268485692706}]

{"sheet":"Databook","index":14,"n_rows":256,"n_cols":13,"rows_kept":256,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Govt pays gap","AUD"]
[null,null,null,"Conventional",435000,null,null,"No Payment for Trucks"]
[null,null,null,"Hydrogen",735000]
[null,null,null,"Pct Govt",0]
[null,null,null,null,null,null,null,"Maintenance costs the same"]
[null,"Trucks"]
[]
[null,null,"Hyundai 18T HFCEV Reference"]
[null,null,null,"H2 Tank Capacity",33,"kg"]
[null,null,null,"Range",400,"km"]
[null,null,null,"H2 Consumption",{"$f":"E10/(E11/100)","v":8.25},"kg/100km"]
[]
[null,null,null,"Diesel Medium Duty Reference"]
[null,null,null,"Diesel Consumption",29.425465838509318,"L/100km",null,{"$f":"E15/100","v":0.29425465838509318}]
[]
[null,null,"LMCC (Council) Medium Duty Diesel"]
[null,null,null,"Diesel Consumption",102.35,"L/100km"]
[null,null,null,"Multiple vs Reference",{"$f":"E18/E15","v":3.4782796833773082}]
[null,null,null,"LMCC Annual Range",22000,"km/Year/Truck"]
[null,null,null,"Reference Cost of Diesel",1.32,"$/L"]
[]
[null,null,"Hydrogen FCEV Refuse Truck (@ Model)"]
[null,null,null,"Drivetrain Efficiency Uplift",0.4,0.4]
[null,null,null,"H2 Consumption",{"$f":"(1-E24)*E19*E12","v":17.217484432717672},"kg/100km",{"$f":"E25/100","v":0.17217484432717672}]
[null,null,null,"H2 Capacity",40,"kg"]
[null,null,null,"Range",{"$f":"E26/E25*100","v":232.3219757004087},"km"]
[null,null,null,"Annual Consumption",{"$f":"E20/100*E25","v":3787.8465751978879},"kg/Truck"]
[null,null,null,"Monthly Consumption",{"$f":"E28/12","v":315.65388126649066},"kg/Truck"]
[null,null,null,"Breakeven Cost of H2",{"$f":"E18*E21/E25","v":7.8467908902691539},"$/kg"]
[]
[null,null,"Truck"]
[null,null,null,"Truck Cost",520000,"AUD","(Select)"]
[null,null,null,"Truck Sell",415000,"AUD","(Select)"]
[null,null,null,"Truck Amortisation Period",7,"Years","(Fixed)"]
[null,null,null,"Truck Buy Back Value",{"$f":"IF($E$33=520000,Databook!$E$43,IF($E$33=823235,Databook!$F$43,IF($E$33=845294,Databook!$G$43,\"Error\")))","v":78000},"AUD","(Calculated)"]
[null,null,null,"Truck H2 Consumption",{"$f":"Databook!$E$29","v":315.65388126649066},"kg/Month/Truck","(Calculated)"]
[null,null,null,"Demo Truck Cost",{"$f":"SUM(Databook!E53:E62)","v":310000},"$","(Calculated)"]
[]
[null,null,"Amortisation"]
[null,null,null,"Truck Lifetime",{"$f":"Databook!$E$35","v":7},{"$f":"Databook!$E$35","v":7},{"$f":"Databook!$E$35","v":7},"Years"]
[null,null,null,"Residual (Factor)",0.15,0.15,0.15,"%"]
[null,null,null,"Residual (Buyback) Value",{"$f":"E64*E42","v":78000},{"$f":"F64*F42","v":123485.29411764705},{"$f":"G64*G42","v":126794.11764705881},"$"]
[null,null,null,"Stack Refit Cost",80000,80000,80000,"$/Stack"]
[null,null,null,"Number of Stacks",1,2,2]
[null,null,null,"Pre-Disposal Cost",{"$f":"E43+E44*E45","v":158000},{"$f":"F43+F44*F45","v":283485.29411764705},{"$f":"G43+G44*G45","v":286794.1176470588}]
[null,null,null,"Disposal (Factor)",0.5,0.45,0.45,"%"]
[null,null,null,"Disposal Value",{"$f":"E47*E64","v":260000},{"$f":"F47*F64","v":370455.88235294115},{"$f":"G47*G64","v":380382.35294117645}]
[]
[null,null,null,null,{"$f":"C17","v":"LMCC (Council) Medium Duty Diesel"},{"$f":"C17","v":"LMCC (Council) Medium Duty Diesel"},{"$f":"C23","v":"Hydrogen FCEV Refuse Truck (@ Model)"}]
[null,null,"Truck Cost Scenarios",null,1,2,3]
[null,null,null,"Glider",100000,{"$f":"485000/0.68","v":713235.29411764699},{"$f":"500000/0.68","v":735294.1176470588}]
[null,null,null,"Fuel Cell",150000]
[null,null,null,"Storage",50000]
[null,null,null,"Storage Subframe",10000]
[null,null,null,"Battery",30000]
[null,null,null,"Motor",20000]
[null,null,null,"Controller",10000]
[null,null,null,"Gearbox",10000]
[null,null,null,"Connections",10000]
[null,null,null,"Frames",10000]
[null,null,null,"Assembly",10000]
[null,null,null,"Compactor",110000,110000,110000]
[null,null,null,"Total",{"$f":"SUM(E52:E63)","v":520000},{"$f":"SUM(F52:F63)","v":823235.29411764699},{"$f":"SUM(G52:G63)","v":845294.1176470588}]
[]
[null,"Electrolyser Scenarios",null,null,1,2,3]
[null,null,null,"Rated Output (MW)",1.4,1.4,1.4,"MW"]
[]
[null,null,null,"Installed Cost",{"$f":"SUM(Databook!$E$154:$E$157)","v":6800000},{"$f":"SUM(Databook!$E$154:$E$157)","v":6800000},{"$f":"SUM(Databook!$E$154:$E$157)","v":6800000},"AUD"]
[null,null,null,"Cost per kW",{"$f":"E$69/E67/1000","v":4857.1428571428569},{"$f":"F$69/F67/1000","v":4857.1428571428569},{"$f":"G$69/G67/1000","v":4857.1428571428569},"AUD"]
[null,null,null,"Uptime",0.98,0.98,0.98,"%"]
[]
[null,null,null,"Efficiency"]
[null,null,null,"Electrolyser (kWh/kg)",60,60,60,"kWh/kg"]
[null,null,null,"Compression",10,10,10,"kWh/kg"]
[null,null,null,"Total",{"$f":"E75+E74","v":70},{"$f":"F75+F74","v":70},{"$f":"G75+G74","v":70},"kWh/kg"]
[null,null,null,"Electrolyser (kg/kWh)",{"$f":"1/E74","v":1.6666666666666666E-2},{"$f":"1/F74","v":1.6666666666666666E-2},{"$f":"1/G74","v":1.6666666666666666E-2}]
[null,null,null,"Total kg/kWh",{"$f":"1/E76","v":1.4285714285714285E-2},{"$f":"1/F76","v":1.4285714285714285E-2},1.4285714285714285E-2]
[null,null,null,"Hourly (kg)",{"$f":"E78*E67*1000","v":19.999999999999996},{"$f":"F78*F67*1000","v":19.999999999999996},{"$f":"G78*G67*1000","v":19.999999999999996}]
[null,null,null,null,{"$f":"E79*24","v":479.99999999999989},{"$f":"F79*24","v":479.99999999999989},479.99999999999989]
[null,null,null,"Daily (@ MAX)",{"$f":"E67*1000/E76*E71*24","v":470.40000000000003},{"$f":"F67*1000/F76*F71*24","v":470.40000000000003},{"$f":"G67*1000/G76*G71*24","v":470.40000000000003},"kg"]
[null,null,null,"Monthly (@ MAX)",{"$f":"E81*365.25/12","v":14317.800000000001},{"$f":"F81*365.25/12","v":14317.800000000001},{"$f":"G81*365.25/12","v":14317.800000000001},"kg"]
[null,null,null,"Annually (@ MAX)",{"$f":"E81*365.25","v":171813.6},{"$f":"F81*365.25","v":171813.6},{"$f":"G81*365.25","v":171813.6},"kg"]
[]
[null,null,null,"O&M"]
[null,null,null,"Amortisation Period",8,14,20,"Years"]
[null,null,null,"Stack Refits",0,1,2,"#"]
[null,null,null,"Stack Refit Cost",1000000,1000000,1000000,"$/Refit"]
[null,null,null,"Retrofit Cost Percent of Total",{"$f":"E88/E69","v":0.14705882352941177},{"$f":"F88/F69","v":0.14705882352941177},0.14705882352941177]
[]
[null,null,null,"Output"]
[null,null,null,"Cost/kg",{"$f":"E69/E79","v":340000.00000000006},{"$f":"F69/F79","v":340000.00000000006},{"$f":"G69/G79","v":340000.00000000006}]
[null,null,null,"Electrolyzer Cost/kg",{"$f":"E157/$E$79","v":165000.00000000003}]
[]
[null,null,null,"Production Capacity"]
[]
[null,null,null,"OpEx"]
[null,null,null,"Overhead (Factor)",1.2E-2,1.2E-2,1.2E-2,"% CapEx"]
[null,null,null,"Monthly Cost",{"$f":"E100/12","v":6800},{"$f":"F100/12","v":6800},{"$f":"G100/12","v":6800},"$/Month"]
[null,null,null,"Annual Cost",{"$f":"E98*E69","v":81600},{"$f":"F98*F69","v":81600},{"$f":"G98*G69","v":81600},"$/Year"]
[null,null,null,"Lifetime Cost",{"$f":"E100*E86","v":652800},{"$f":"F100*F86","v":1142400},{"$f":"G100*G86","v":1632000},"$"]
[]
[null,null,null,"Disposal Value"]
[null,null,null,"Residual (Factor)",0.5,0.35,0.2,"%"]
[null,null,null,"Residual Value",{"$f":"E104*E69","v":3400000},{"$f":"F104*F69","v":2380000},{"$f":"G104*G69","v":1360000},"$"]
[]
[]
[null,"Hydrogen COGS Scenarios",null,null,1,2,3,null,null,null,null,"Bond rate",0.02]
[null,null,null,"Energy Cost (All In)",60,90,120,"$/MWh"]
[]
[null,null,null,"Production Efficiency",{"$f":"Databook!$E$76","v":70},{"$f":"Databook!$E$76","v":70},{"$f":"Databook!$E$76","v":70},"kWh/kg"]
[]
[null,null,null,"Water Cost",{"$f":"Databook!$E$175","v":2.1},{"$f":"Databook!$E$175","v":2.1},{"$f":"Databook!$E$175","v":2.1},"$/kL"]
[null,null,null,"Water Supply Charge",{"$f":"Databook!$E$176/3","v":833.33333333333337},{"$f":"Databook!$E$176/3","v":833.33333333333337},{"$f":"Databook!$E$176/3","v":833.33333333333337},"$/Month"]
[null,null,null,"Water Consumption",11.62,11.62,11.62,"L/kg"]
[]
[null,null,null,"Energy"]
[null,null,null,"Daily @ MAX",{"$f":"E$111*Databook!$E81","v":32928},{"$f":"F$111*Databook!$E81","v":32928},{"$f":"G$111*Databook!$E81","v":32928},"kWh"]
[null,null,null,"Monthly @ MAX",{"$f":"E$111*Databook!$E82","v":1002246.0000000001},{"$f":"F$111*Databook!$E82","v":1002246.0000000001},{"$f":"G$111*Databook!$E82","v":1002246.0000000001},"kWh"]
[null,null,null,"Annually @ MAX",{"$f":"E$111*Databook!$E83","v":12026952},{"$f":"F$111*Databook!$E83","v":12026952},{"$f":"G$111*Databook!$E83","v":12026952},"kWh"]
[]
[null,null,null,"Energy Cost"]
[null,null,null,"Daily @ MAX",{"$f":"E118*E$109/1000","v":1975.68},2963.52,3951.36,"$/Day"]
[null,null,null,"Monthly @ MAX",60134.760000000009,90202.140000000014,120269.52000000002,"$/Month"]
[null,null,null,"Annually @ MAX",721617.12,1082425.68,1443234.24,"$/Year"]
[]
[null,null,null,"Water"]
[null,null,null,"Daily @ MAX",{"$f":"E$115*Databook!$E81","v":5466.0479999999998},{"$f":"F$115*Databook!$E81","v":5466.0479999999998},{"$f":"G$115*Databook!$E81","v":5466.0479999999998},"L/Day"]
[null,null,null,"Monthly @ MAX",{"$f":"E$115*Databook!$E82","v":166372.83600000001},{"$f":"F$115*Databook!$E82","v":166372.83600000001},{"$f":"G$115*Databook!$E82","v":166372.83600000001},"L/Month"]
[null,null,null,"Annually @ MAX",{"$f":"E$115*Databook!$E83","v":1996474.0319999999},{"$f":"F$115*Databook!$E83","v":1996474.0319999999},{"$f":"G$115*Databook!$E83","v":1996474.0319999999},"L/Year"]
[]
[null,null,null,"Water"]
[null,null,null,"Daily @ MAX",{"$f":"(E$114*12/365.25)+(E$113*E$128)/1000","v":38.857208671321011},{"$f":"(F$114*12/365.25)+(F$113*F$128)/1000","v":38.857208671321011},{"$f":"(G$114*12/365.25)+(G$113*G$128)/1000","v":38.857208671321011},"$/Day"]
[null,null,null,"Monthly @ MAX",{"$f":"(E$114)+(E$113*E$129)/1000","v":1182.7162889333335},{"$f":"(F$114)+(F$113*F$129)/1000","v":1182.7162889333335},{"$f":"(G$114)+(G$113*G$129)/1000","v":1182.7162889333335},"$/Month"]
[null,null,null,"Annually @ MAX",{"$f":"(E$114*12)+(E$113*E$130)/1000","v":14192.595467200001},{"$f":"(F$114*12)+(F$113*F$130)/1000","v":14192.595467200001},{"$f":"(G$114*12)+(G$113*G$130)/1000","v":14192.595467200001},"$/Year"]
[]
[null,null,null,"Hydrogen COGS"]
[null,null,null,"Daily @ MAX",{"$f":"E133+E123","v":2014.537208671321},3002.3772086713211,3990.2172086713213,"$/Day"]
[null,null,null,"Monthly @ MAX",61317.476288933343,91384.856288933341,121452.23628893335,"$/Month"]
[null,null,null,"Annually @ MAX",735809.71546720003,1096618.2754672,1457426.8354672,"$/Year"]
[]
[null,null,null,"Unit COGS",{"$f":"E138/Databook!$E$81","v":4.2826046102706652},{"$f":"F138/Databook!$E$81","v":6.3826046102706648},{"$f":"G138/Databook!$E$81","v":8.4826046102706645},"$/kg"]
[]
[]
[]
[null,null,"Financial Inputs"]
[null,null,null,"Investment",6000000,"$","(Input)"]
[null,null,null,"LMCC Milestone 1 Fee",200000,"$","(Fixed)"]
[null,null,null,"LMCC Milestone 2 Fee",1000000,"$","(Fixed)"]
[null,null,null,"ARENA Contribution (% Expenses)",0.4,"%","(Input)",null,"Lifetime of Electorlyzer",null,100000,"hrs"]
[null,null,null,"Model Inputs",null,null,null,null,"Degradation","% p.a.",0.01]
[]
[null,null,null,"Plant",null,null,null,null,"Lifetime",null,100000,"hrs"]
[null,null,null,"Refueller Cost",3500000,"AUD","(Fixed)",null,"O&M 10% of Capital"]
[]
[null,null,null,null,null,null,null,null,"Lifetime of Truck",null,8,"yrs"]
[null,null,null,"Electrolyser & BoP Cost",3300000,"AUD","(Fixed)"]
[]
[null,null,null,"Total Cost",{"$f":"E154+E157","v":6800000}]
[]
[]
[null,null,null,"Plant Amortisation Period",8,"Years","(Fixed)"]
[null,null,null,"Plant Loan Value Ratio",0.8,null,"(Select)",null,"Sell Fuel at equivalent Diesel"]
[null,null,null,"Refueller Principal PMT",{"$f":"IF($E$162=8,Databook!$E$207,IF($E$162=14,Databook!$F$207,IF($E$162=20,Databook!$G$207,\"Error\")))","v":10937.499999999998},"$/Month","(Calculated)"]
[null,null,null,"Refueller Interest PMT",{"$f":"IF($E$162=8,Databook!$E$209,IF($E$162=14,Databook!$F$209,IF($E$162=20,Databook!$G$209,\"Error\")))","v":7694.5724007555491},"$/Month","(Calculated)"]
[null,null,null,"Electrolyser Principal PMT",{"$f":"IF($E$162=8,Databook!$E$208,IF($E$162=14,Databook!$F$208,IF($E$162=20,Databook!$G$208,\"Error\")))","v":10312.5},"$/Month","(Calculated)"]
[null,null,null,"Electrolyser Interest PMT",{"$f":"IF($E$162=8,Databook!$E$210,IF($E$162=14,Databook!$F$210,IF($E$162=20,Databook!$G$210,\"Error\")))","v":7254.8825492838041},"$/Month","(Calculated)"]
[null,null,null,"Refueller Depreciation",{"$f":"IF($E$162=8,Databook!$E$215,IF($E$162=14,Databook!$F$215,IF($E$162=20,Databook!$G$215,\"Error\")))","v":18229.166666666664},"$/Month","(Calculated)"]
[null,null,null,"Electrolyser Depreciation",{"$f":"IF($E$162=8,Databook!$E$216,IF($E$162=14,Databook!$F$216,IF($E$162=20,Databook!$G$216,\"Error\")))","v":17187.5},"$/Month","(Calculated)"]
[null,null,null,"Refueller Residual",{"$f":"IF($E$162=8,E154/SUM(E154:E157)*Databook!$E$105,IF($E$162=14,E154/SUM(E154:E157)*Databook!$F$105,IF($E$162=20,E154/SUM(E154:E157)*Databook!$G$105,\"Error\")))","v":1749999.9999999998},"$/Month","(Calculated)"]
[null,null,null,"Electrolyser Residual",{"$f":"IF($E$162=8,E157/SUM(E154:E157)*Databook!$E$105,IF($E$162=14,E157/SUM(E154:E157)*Databook!$F$105,IF($E$162=20,E157/SUM(E154:E157)*Databook!$G$105,\"Error\")))","v":1650000},"$/Month","(Calculated)"]
[]
[null,null,null,"O&M"]
[null,null,null,"Energy Cost",120,"$/MWh","(Select)"]
[null,null,null,"Water Cost",2.1,"$/kL","(Fixed)"]
[null,null,null,"Water Supply",2500,"$/QTR","(Calculated)"]
[null,null,null,"Plant OpEx",{"$f":"IF($E$162=8,Databook!$E$99,IF($E$162=14,Databook!$F$99,IF($E$162=20,Databook!$G$99,\"Error\")))","v":6800},"$/Month","(Calculated)"]
[]
[null,null,"Hydrogen Cost"]
[null,null,null,"COGS (Energy + Water)",{"$f":"IF(E174=120,Databook!G142,IF(E174=90,Databook!F142,IF(E174=60,Databook!E142,\"Error\")))","v":8.4826046102706645},"$/kg","(Calculated)"]
[null,null,null,"Plant Component @ MAX",{"$f":"IF(E162=8,Databook!$E$219,IF(E162=14,Databook!$F$219,IF(E162=20,Databook!$G$219,\"Error\")))","v":3.9926609965711224},"$/kg","(Calculated)"]
[null,null,null,"Plant Component @ Model",{"$f":"IF(E162=8,Databook!$E$220,IF(E162=14,Databook!$F$220,IF(E162=20,Databook!$G$220,\"Error\")))","v":{"$error":"#REF!"}},"$/kg","(Calculated)"]
[null,null,null,"Total Unit Cost @ MAX",{"$f":"E181+E180","v":12.475265606841788},"$/kg","(Calculated)"]
[null,null,null,"Total Unit Cost @ Model",{"$f":"E182+E180","v":{"$error":"#REF!"}},"$/kg","(Calculated)"]
[null,null,null,"H2 Diesel Breakeven Sell Price",{"$f":"Databook!E30","v":7.8467908902691539},"$/kg","(Calculated)"]
[]
[null,null,null,"Asset Finance"]
[null,null,null,"Cost of Capital",0.04,null,"(Fixed)"]
[null,null,null,"Loan Term",{"$f":"E162","v":8},"Years","(Fixed)"]
[]
[null,null,null,"Other"]
[null,null,null,"Staff incl. Overhead",{"$f":"Databook!E235","v":101500},"$/Month","(Fixed)"]
[null,null,null,"Imported Gas Budget",200000,"$","(Fixed)"]
[]
[]
[]
[]
[]
[null,null,null,"Asset Finance"]
[null,null,null,"LVR",{"$f":"Databook!$E$163","v":0.8},{"$f":"Databook!$E$163","v":0.8},{"$f":"Databook!$E$163","v":0.8},"%"]
[null,null,null,"Loan Principal",{"$f":"E200*(E69+E87*E88)","v":5440000},{"$f":"F200*(F69+F87*F88)","v":6240000},{"$f":"G200*(G69+G87*G88)","v":7040000},"$"]
[null,null,null,"Total Repayable",{"$f":"12*E86*PMT(Databook!$E$188/12,Databook!E86*12,-1*(Databook!E201),Databook!E105,0)+E105","v":6875147.6752037778},{"$f":"12*F86*PMT(Databook!$E$188/12,Databook!F86*12,-1*(Databook!F201),Databook!F105,0)+F105","v":8760215.9416425638},{"$f":"12*G86*PMT(Databook!$E$188/12,Databook!G86*12,-1*(Databook!G201),Databook!G105,0)+G105","v":10708723.849009676},"$"]
[null,null,null,"Monthly INT & Principal",{"$f":"PMT(Databook!$E$188/12,Databook!E86*12,-1*Databook!E201,Databook!E105,0)","v":36199.454950039355},{"$f":"PMT(Databook!$E$188/12,Databook!F86*12,-1*Databook!F201,Databook!F105,0)","v":37977.4758431105},{"$f":"PMT(Databook!$E$188/12,Databook!G86*12,-1*Databook!G201,Databook!G105,0)","v":38953.016037540314},"$/Month"]
[null,null,null,"Monthly Interest",{"$f":"(E202-E201)/(12*E86)","v":14949.454950039353},{"$f":"(F202-F201)/(12*F86)","v":15001.285366920023},{"$f":"(G202-G201)/(12*G86)","v":15286.34937087365},"$/Month"]
[null,null,null,"Mthly P&I Refueller",{"$f":"E207+E209","v":18632.072400755547},19547.230213365696,20049.346489910451,"$/Month"]
[null,null,null,"Mthly P&I Electrolyser",17567.382549283804,18430.245629744801,18903.669547629859,"$/Month"]
[null,null,null,"Mthly Principal Refueller",{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*(E203-E204)","v":10937.499999999998},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*(F203-F204)","v":11825.980392156862},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*(G203-G204)","v":12181.372549019605},"$/Month"]
[null,null,null,"Mthly Principal Electrolyser",{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*(E203-E204)","v":10312.5},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*(F203-F204)","v":11150.210084033613},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*(G203-G204)","v":11485.294117647058},"$/Month"]
[null,null,null,"Mthly INT Refueller",{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!E204","v":7694.5724007555491},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!F204","v":7721.2498212088349},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!G204","v":7867.9739408908481},"$/Month"]
[null,null,null,"Mthly INT Electrolyser",{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!E204","v":7254.8825492838041},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!F204","v":7280.0355457111873},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!G204","v":7418.3754299828006},"$/Month"]
[]
[null,null,null,"Lifetime Asset Cost"]
[null,null,null,"Net Exposure Ex OpEx",{"$f":"E69+E87*E88-E105","v":3400000},{"$f":"F69+F87*F88-F105","v":5420000},{"$f":"G69+G87*G88-G105","v":7440000},"$"]
[null,null,null,"Monthly Depreciation",{"$f":"(E69-E105)/(12*E86)","v":35416.666666666664},{"$f":"(F69-F105)/(12*F86)","v":26309.523809523809},{"$f":"(G69-G105)/(12*G86)","v":22666.666666666668},"$/Month"]
[null,null,null,"Mthly Dep. Refueller",{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!E214","v":18229.166666666664},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!F214","v":13541.666666666664},{"$f":"Databook!$E$154/SUM(Databook!$E$154:$E$157)*Databook!G214","v":11666.666666666666},"$/Month"]
[null,null,null,"Mthly Dep. Electrolyser",{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!E214","v":17187.5},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!F214","v":12767.857142857143},{"$f":"Databook!$E$157/SUM(Databook!$E$154:$E$157)*Databook!G214","v":11000},"$/Month"]
[]
[null,null,null,"Net Total Cost",{"$f":"(1-E200)*(E69+E87*E88)+E202+E101-E105","v":5487947.6752037778},{"$f":"(1-F200)*(F69+F87*F88)+F202+F101-F105","v":9082615.9416425638},{"$f":"(1-G200)*(G69+G87*G88)+G202+G101-G105","v":12740723.849009676},"$"]
[null,null,null,"Plant Cost of H2 @ MAX",{"$f":"E218/(E86*E83)","v":3.9926609965711224},{"$f":"F218/(F86*F83)","v":3.77594254206825},{"$f":"G218/(G86*G83)","v":3.7077169237504122},"$/kg"]
[null,null,null,"Plant Cost of H2 @ Model",{"$f":"(96/(E86*12)*E218/#REF!)","v":{"$error":"#REF!"}},{"$f":"(96/(F86*12)*F218/#REF!)","v":{"$error":"#REF!"}},{"$f":"(96/(G86*12)*G218/#REF!)","v":{"$error":"#REF!"}},"$/kg"]
[]
[]
[null,null,null,"Project Overheads"]
[null,null,null,"Managing Director",150000,"$/Year"]
[null,null,null,"Engineering Director",150000,"$/Year"]
[null,null,null,"Commercial Director",150000,"$/Year"]
[null,null,null,"Senior Engineer, Trucks",150000,"$/Year",2931200]
[null,null,null,"Senior Engineer",150000,"$/Year",125000]
[null,null,null,"Project Director",120000,"$/Year",{"$f":"SUM(G227:G228)","v":3056200}]
[null,null,null,"Annual Subtotal",{"$f":"SUM(E224:E229)","v":870000},"$/Year",1200,"kW"]
[null,null,null,null,null,null,{"$f":"G229/G230","v":2546.8333333333335},"AUD"]
[null,null,null,"Overhead (Factor)",0.4,null,{"$f":"G231*0.71","v":1808.2516666666668},"USD"]
[null,null,null,"Overhead Value",{"$f":"E232*E230","v":348000},"$/Year"]
[null,null,null,null,null,null,89280]
[null,null,null,"Monthly Total",{"$f":"E236/12","v":101500},"$/Month",{"$f":"G234/G229","v":2.9212747856815654E-2}]
[null,null,null,"Annual Total",{"$f":"E233+E230","v":1218000},"$/Year"]
[]
[]
[]
[]
[null,null,null,"1 Kg of Hydrogen would need 3,33 kw/kg "]
[]
[null,null,null,null,null,"Cap Exp for Refueller - compressor / storage "]
[null,null,null,null,null,2107142]
[]
[]
[null,null,null,null,null,"Dispensor +  Chiller +heat exchange +associated pipework "]
[null,null,null,null,null,171450]
[null,null,null,null,null," filling rate 14-20 min for 50 kg of H2"]
[null,null,null,null,null,"Dispensor +  Chiller +heat exchange +associated pipework "]
[null,null,null,null,null,785700]
[null,null,null,null,null," filling rate 8-14 mins for 50 kg of H2 "]
[null,null,null,null,null,{"$f":"AVERAGE(8,14)","v":11}]
[]
[null,null,null,null,null,"mario, 8:21 PM"]
[null,null,null,null,null,"Ed , We should select the lower cost option at $171,450 ( 14-20min ) fill"]

{"sheet":"Original Assumptions","index":15,"n_rows":243,"n_cols":30,"rows_kept":243,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Assumptions"]
[null,"Capacity and Production",null,null,null,"USD","AUD"]
[null,null,"Project Lifetime",null,"years",20]
[null,null,"Capacity",null,null,"Use the Capacity "]
[]
[null,null,"Size of installation",null,"kW",220,null,null,null,null,null,null,null,null,null,{"$f":"200/1.61","v":124.22360248447204}]
[null,null,"Availability",null,"%",0.97,null,null,null,null,null,null,null,null,null,{"$f":"40/1.61","v":24.844720496894407}]
[null,null,"Hours of operation",null,"hours",{"$f":"8760*F10","v":8497.1999999999989}]
[null,null,"Power Conversion",null,"kWh/kg",58]
[null,null,"Power Conversion Reciprical",null,"kg/KW",{"$f":"1/F12","v":1.7241379310344827E-2},null,null,null,48]
[null,null,"Hydrogen Capacity",null,"kg",{"$f":"F9*F13","v":3.7931034482758621}]
[null,null,"Hydrogen generation",null,"kg p.a.",{"$f":"((F9/F12)*F11)","v":32230.758620689652},null,null,null,null,null,null,null,null,null,"1 usd ~ .78 stg "]
[null,null,"Generation per Day",null,"kg p. day",{"$f":"F15/365","v":88.303448275862067},null,null,null,null,null,null,null,null,null,{"$f":"1/0.78","v":1.2820512820512819}]
[]
[null,null,"Rate of Return",null,"%",0.08,null,null,null,null,null,null,null,null,null,"1usd~ .62 Aud",null,null,null,null,null,"Pareto function: the first 20% of the years covers 80% of the costs (almost)"]
[null,null,"Conversion from Nm3 to kg",null,"Nm3 to kg",8.3748000000000003E-2]
[]
[null,"Cap Exp for Electrolyser",null,null,null,"Cost USD"]
[null,null,"Electrolyser ",null,"$",{"$f":"capexp*100","v":193200},null,null,null,null,"capexp",1932,"base capexp",1932,null,"Notes "]
[null,null,"Stack replacement",null,"$",57960]
[null,null,"Storage",null,"$",32200.000000000004,null,null,null,null,null,null,null,null,null,{"$f":"515/ 1.28","v":402.34375}]
[null,null,"Compression",null,"$",124000,null,null,null,null,null,null,null,null,null,{"$f":"1/0.62","v":1.6129032258064517}]
[null,null,"Direct Costs",null,"$",{"$f":"SUM(F22:F25)","v":407360},null,null,null,null,null,null,null,null,null,null,"USD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220kW ITM PEM electrolyser GBP515k",{"$f":"515*1.28","v":659.2},"k"]
[null,null,"Civil works costs",null,"$",161000,null,null,null,null,null,null,null,null,null,"Rated at 57-63kW/kg/hr"]
[null,null,"Grid connection costs",null,"$",80500,null,null,null,null,null,null,null,null,null,"Equates to 84kg / day       (there is a 0.2% cost reduction per kg under this amount when delivered)…"]
[null,null,"Permits costs/ shipping ",null,"$",24844]
[null,null,"Project costs",null,"$",{"$f":"SUM(F28:F30)","v":266344},null,null,null,null,null,null,null,null,null,"GBP 40k install",{"$f":"40*1.28","v":51.2},"k"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GBP 25-40k shipping",{"$f":"35*1.28","v":44.800000000000004},"k"]
[null,null,null,"CAPEX total","$",{"$f":"F31+F26","v":673704},null,null,null,null,null,null,null,null,null,"GBP 94k per annum maintenance             ",{"$f":"94*1.28","v":120.32000000000001},"annual "]
[]
[null,null,null,"Capital Cost/kW","$/kW",{"$f":"F33/F9","v":3062.2909090909093},null,null,null,null,null,null,null,null,null,"Haskel compressor $AUD200k (slow mechanical style pump)",{"$f":"200*0.62","v":124},"k"]
[null,null,null,"Capital Cost/kg","$/kg",{"$f":"F33/F14","v":177612.87272727271},null,null,null,null,null,null,null,null,null,"Refueller $AUD1.4M (this is from Linde – ",{"$f":"1.4*1.61","v":2.254},"m"]
[]
[null,null,null,"O&M costs","$/a",7728.0000000000018,{"$f":"F38/F15","v":0.23977096198533857}]
[null,null,null,"Labor costs","$/a",0]
[null,null,null,"Wastewater treatment costs","$",5000]
[null,null,null,"Feedstock - water","$",500]
[null,null,null,"OPEX total","$",{"$f":"opexp","v":13228},null,null,null,null,"opexp",13228,"base opexp",13228]
[]
[null,null,null,"Price of electricity","$/MWh",{"$f":"L44","v":45},100,null,null,null,"electricity",45,"base electricity",40]
[null,null,null,"Feedstock - electricity","$/a",{"$f":"F44*F11","v":382373.99999999994}]
[]
[]
[]
[null,null,null,"Year",null,"CAPEX",null,null,null,"OPEX","Feed - EL","Feed - water","Hydrogen",null,"CAPEX(0)","OPEX(0)","Feed - EL(0)","Feed - water(0)","Hydrogen(0)",null,"CAPEX_sum","OPEX_sum","Feed-EL_sum","Feed-water_sum","Hydrogen_sum","LCOH(t)"]
[null,null,null,1,null,{"$f":"+$F$33","v":673704},null,null,null,{"$f":"+$F$42","v":13228},{"$f":"+$F$45","v":382373.99999999994},{"$f":"+$F$41","v":500},{"$f":"+$F$15","v":32230.758620689652},null,{"$f":"+F50/(1+$F$18/100)^$D50","v":673165.46762589936},{"$f":"+J50/(1+$F$18/100)^$D50","v":13217.426059152678},382068.34532374097,499.60031974420468,32204.994624989664,null,{"$f":"+O50","v":673165.46762589936},{"$f":"+P50","v":13217.426059152678},{"$f":"+Q50","v":382068.34532374097},{"$f":"+R50","v":499.60031974420468},{"$f":"+S50","v":32204.994624989664},{"$f":"SUM(U50:X50)/Y50","v":33.192082525580631}]
[null,null,null,2,null,0,null,null,null,13228,382373.99999999994,500,{"$f":"+$F$15","v":32230.758620689652},null,0,13206.860570696123,381762.93497576035,499.20095897702305,32179.251224010455,null,{"$f":"+O51+U50","v":673165.46762589936},26424.286629848801,763831.28029950126,998.80127872122773,{"$f":"+S51+Y50","v":64384.245849000115},{"$f":"SUM(U51:X51)/Y51","v":22.745002547183102}]
[null,null,null,3,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13196.303527873824,381457.76876075182,498.80191744306865,32153.528401289426,null,673165.46762589936,39620.590157722625,1145289.049060253,1497.6031961642964,96537.774250289542,19.262643296693387]
[null,null,null,4,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13185.754923934675,381152.84648356494,498.40319488715886,32127.826140377121,null,673165.46762589936,52806.345081657302,1526441.8955438179,1996.0063910514552,128665.60039066666,17.521464228180445]
[null,null,null,5,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13175.214752132972,380848.16794920561,498.00479105431549,32102.144424837257,null,673165.46762589936,65981.559833790277,1907290.0634930236,2494.0111821057708,160767.74481550392,16.476757232458016]
[null,null,null,6,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13164.683005728386,380543.73296283529,497.6067056897636,32076.483238246652,null,673165.46762589936,79146.242839518658,2287833.7964558587,2991.6178877955344,{"$f":"+S55+Y54","v":192844.22805375056},15.780286273130628]
[null,null,null,7,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13154.159677986001,380239.54132977157,497.20893853893261,32050.842564195307,null,673165.46762589936,92300.402517504655,2668073.3377856305,3488.8268263344671,224895.07061794586,15.282807334600182]
[null,null,null,8,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13143.644762176258,379935.59285548714,496.8114893474546,32025.222386286274,null,673165.46762589936,105444.04727968092,3048008.9306411175,3985.6383156819215,256920.29300423214,14.909698409067593]
[null,null,null,9,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13133.138251574997,379631.88734561065,496.41435786116563,31999.622688135765,null,673165.46762589936,118577.18553125592,3427640.8179867282,4482.0526735430867,288919.91569236788,14.61950282553334]
[null,null,null,10,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13122.640139463429,379328.42460592592,496.01754382610477,31974.043453373066,null,673165.46762589936,131699.82567071935,3806969.2425926542,4978.0702173691916,320893.95914574096,14.387346581397676]
[null,null,null,11,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13112.150419128129,379025.20444237208,495.62104698851408,31948.484665640564,null,673165.46762589936,144811.97608984748,4185994.4470350263,5473.6912643577052,352842.44381138153,14.19740076591529]
[null,null,null,12,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13101.669083861038,378722.22666104324,495.22486709483815,31922.946308593684,null,673165.46762589936,157913.6451737085,4564716.673696069,5968.9161314525436,384765.3901199752,14.039112771922611]
[null,null,null,13,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13091.196126959474,378419.49106818874,494.82900389172488,31897.428365900971,null,673165.46762589936,171004.84130066796,4943136.1647642581,6463.7451353442684,416662.8184858762,13.905176948306378]
[null,null,null,14,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13080.731541726087,378116.99747021246,494.43345712602388,31871.930821243965,null,673165.46762589936,184085.57284239406,5321253.1622344702,6958.1785924702926,448534.74930712016,13.790374972842811]
[null,null,null,15,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13070.275321468916,377814.74567367363,494.03822654478819,31846.453658317321,null,673165.46762589936,197155.84816386297,5699067.9079081435,7452.2168190150805,480381.20296543749,13.690880075901122]
[null,null,null,16,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13059.827459501315,377512.7354852854,493.64331189527201,31820.996860828658,null,673165.46762589936,210215.67562336428,6076580.643393429,7945.8601309103524,512202.19982626615,13.603822180258202]
[null,null,null,17,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13049.387949142003,377210.96671191591,493.24871292493208,31795.56041249866,null,673165.46762589936,223265.06357250627,6453791.610105345,8439.1088438352854,543997.76023876481,13.527006520978713]
[null,null,null,18,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13038.95678371503,376909.43916058738,492.85442938142688,31770.144297061008,null,{"$f":"+O67+U66","v":673165.46762589936},{"$f":"+P67+V66","v":236304.0203562213},{"$f":"+Q67+W66","v":6830701.0492659323},{"$f":"+R67+X66","v":8931.963273216712},{"$f":"+S67+Y66","v":575767.90453582583},13.458726058668489]
[null,null,null,19,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13028.533956549791,376608.15263847663,492.46046101261686,31744.748498262401,null,673165.46762589936,249332.5543127711,7207309.2019044086,9424.4237342293291,607512.6530340882,13.397633130647909]
[null,null,null,20,null,0,null,null,null,13228,382373.99999999994,500,32230.758620689652,null,0,13018.119460981006,376307.10695291433,492.06680756656363,31719.372999862513,null,673165.46762589936,262350.67377375212,7583616.3088573227,9916.4905417958926,639232.02603395074,{"$f":"SUM(U69:X69)/Y69","v":13.342649606773263},{"$f":"LCOH(n)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,{"$f":"SUM(F50:F69)","v":673704},null,null,null,{"$f":"SUM(J50:J69)","v":264560},{"$f":"SUM(K50:K69)","v":7647479.9999999991},{"$f":"SUM(L50:L69)","v":10000},{"$f":"SUM(M50:M69)","v":644615.17241379269},null,{"$f":"SUM(O50:O69)","v":673165.46762589936},{"$f":"SUM(P50:P69)","v":262350.67377375212},{"$f":"SUM(Q50:Q69)","v":7583616.3088573227},{"$f":"SUM(R50:R69)","v":9916.4905417958926},{"$f":"SUM(S50:S69)","v":639232.02603395074},{"$f":"(O70+P70+Q70+R70)/S70","v":13.342649606773263}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O70","v":673165.46762589936},{"$f":"P70","v":262350.67377375212},{"$f":"Q70","v":7583616.3088573227},{"$f":"R70","v":9916.4905417958926},{"$f":"SUM(O71:R71)","v":8529048.9407987688}]
[]
["Contents","Electrolyser Assumptions",null,"Levelized Cost of Hydrogen"]
[]
[null,null,null,"CAPEXt =Investment expenditures in the year t; "]
[null,null,null,"OPEXt =Operations and maintenance expenditures in the year t; "]
[null,null,null,"Feedstockt =Electricity & water consumption =Feedstock expenditures in the year t; "]
[null,null,null,"Hydrogent =Hydrogen generation in the year t; "]
[null,null,null,"rt (Depreciation) =discount rate; and "]
[null,null,null,"n =lifetime of plant "]
[]
[]
["Contents"]
[null,null,"Trucks",null,null,22,"Units "]
[]
[null,"Standard Truck"]
[]
[null,null,"Hours of Operation per Year",null,null,{"$f":"Inputs!F45*365","v":3650}]
[null,null,"Km/Hour",null,null,5]
[null,null,"Km Travelled - Standard Truck",null,null,{"$f":"F88*F89","v":18250},"per annum, each"]
[]
[null,"Hydrogen Truck"]
[null,null,"Hours of Operation per Day",null,null,10,"Hrs Hydrogen","Base Hydrogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,"Hours of Operation per Year",null,null,{"$f":"F93*365","v":3650}]
[null,null,"Km/Hour",null,null,5]
[null,null,"Km Travelled - Standard Truck",null,null,{"$f":"F94*F95","v":18250},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300]
[]
[]
["Retrofit Up-front Cost"]
[null,null,"FC + Motor+ Storage + Battery",null,null,150000,"$AUD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Applied",150,"Base Cost",150]
[null,null,"Exchange Rate AUD/USD",null,null,0.62]
[null,null,"FC + Motor+ Storage + Battery",null,null,{"$f":"F100*F101","v":93000},"USD"]
[]
[null,null,"HFC+Motor + Storage ",null,null,120000,"$"]
[null,null,"Residual Cost of truck",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If truck is novated to Zenogen from council it may have value "]
[null,null,"Amount to fund by Zenogen "]
[]
[]
["Diesel Cost"]
[null,null,"Exchange Rate",null,null,{"$f":"F101","v":0.62}]
[null,null,"Diesel Price",null,null,1.5,"AUD $/L",15,"Diesel"]
[null,null,"Diesel Price",null,null,{"$f":"F101*F111","v":0.92999999999999994},"USD/L"]
[]
[null,null,"Exchange Rate"]
[null,null,"Diesel Fuel Cost",null,null,23423.423423423421,"per truck"]
[null,null,null,null,null,{"$f":"F111*F90","v":27375}]
[]
[null,null,"Hydrogen Price ",null,null,null,null,"from third party provider : BOC , Liquide "]
[]
["Infrastructure"]
[null,null,"Refuller Cost",null,null,500000,"AUD","Applied Refuller",500]
[null,null,"Exchange Rate",null,null,{"$f":"F110","v":0.62}]
[null,null,"refuller ",null,null,{"$f":"F121*F122","v":310000},"USD"]
[]
[null,null,"Hydrogen Fuel Cost",null,null,675.86493506493514,"per truck","Based on what costs ?"]
[]
[null,null,"Stage 2 ",null,null,"The number below reflect the cost for embedded hydrogen production "]
[null,null,"AEC 2019",null,null,"Alkaline Water Electroysis "]
[]
[null,null,"Size of installation",null,null,100,"kW"]
[null,null,"Availability",null,null,0.97,"%"]
[null,null,"Hours of operation",null,null,8497.1999999999989,"hours"]
[null,null,"Power consumption",null,null,58,"kWh/kg",null,null,"kw/h","annual "]
[null,null,"Hydrogen generation ( annual )",null,null,14650.344827586205,"kg/annual",{"$f":"+F134/350","v":41.858128078817728}]
[null,null,"Hydrogen Hourly",null,null,{"$f":"F134/8760","v":1.672413793103448}]
[]
[null,null,"CAPEX total",null,null,{"$f":"SUM(F138:F142)","v":444360.00000000006},"$","Need to review "]
[null,null,"Electrolyser ",null,null,193200.00000000003,"$","Need to review "]
[null,null,"Stack replacement",null,null,57960,"$","Need to review "]
[null,null,"Storage",null,null,32200.000000000004,"$","Need to review "]
[null,null,"Compression",null,null,161000,"$","Need to review "]
[]
[null,null,"Cost/kg",null,null,{"$f":"F137/F135","v":265699.7938144331}]
[]
[null,null,"Project costs",null,null,241500,"$","Need to review "]
[null,null,"Civil works costs",null,null,161000,"$","Need to review "]
[null,null,"Grid connection costs",null,null,80500,"$","Need to review "]
[null,null,"Pv Solar Plant ",null,null,150000,"$","Based on power consumed hours ( b17) "]
[null,null,"Permits costs",null,null,1000,"$","monthy rental"]
[null,null,"OPEX total",null,null,12728.000000000002,"$","Need to review "]
[null,null,"O&M costs",null,null,7728.0000000000018,"$/a","Need to review "]
[null,null,"Labor costs",null,null,"-","$/a"]
[null,null,"Wastewater treatment costs",null,null,5000,"$","Need to review "]
[null,null,"Feedstock - electricity",null,null,339887.99999999994,"$/a","Need to review - based on $40 mw/h"]
[null,null,"Price of electricity",null,null,40,"$/MWh","Imported Grid power"]
[null,null,"Price of electricity",null,null,20,"$/MWh","Embedded - PV Solar - assumed "]
[null,null,"Feedstock - water",null,null,500,"$"]
[null,null,"r",null,null,0.08,"%"]
[null,null,"n",null,null,20,"years"]
[null,null,"Conversion from Nm3 to kg",null,null,8.3748000000000003E-2,"Nm3 to kg"]
[null,null,"Hydrogen price from embedded production "]
[null,null,"Stage 1 ",null,null,"Retrofitting existing diesel trucks to Hydrogen and refuelling the trucks from hydrogen delivered by a thrid party at a cost per Kg . "]
[]
[null,null,null,null,null,null,null,"Comments"]
[null,null,"Hydrogen Price ",null,null,12,"$/kg"]
[null,null,"Retrofitting Cost "]
[]
[]
[]
[]
[null,null,"Number of trucks",null,null,22]
[null,null,"KM Travelled ",null,null,20000,"per annum , each "," annual trucks travel "]
[null,null,"Life of New Truck ",null,null,9,null,"year post retrofitting "]
[null,null,"Cost of capital "]
[null,null," Leasing payment ",null,null,null,null,"Leasing costs to councils ( average ) ",null,{"$f":"+F172*F177*F179","v":23423423.423423424}]
[null,null,"Hydrogen Mileage ",null,null,80,"kg/1000km",{"$f":"+F176*F104","v":9600000}]
[null,null,"Diesel Mileage ",null,null,900.90090090090087,"L/1000km"]
[null,null,"Hydrogen Fuel Cost",null,null,12,"$/Kg","BOC or  Embedded production"]
[null,null,"Diesel cost per liter",null,null,1.3,"$/L"]
[null,null,"Diesel Fuel Cost",null,null,23423.423423423421,"per truck","diesel  cost to councils "]
[null,null,"Hydrogen Fuel Cost",null,null,null,null,"Hydrogen cost to councils "]
[]
[null,null,"Trucks Background information "]
[null,null,"Trucks",null,null,22]
[null,null,"Km Travelled",null,null,20000,"per annum, each","80kg /1000 km "]
[null,null,null,null,null,null,null,"truck fuel cell 9 yrs before replaceemnt "]
[null,null,"Diesel Price",null,null,1.3,"$/L"]
[]
[null,null,"H2 Energy Input",null,null,41.7,"kWh/kg"]
[]
[null,null,"Hydrogen Mileage ",null,null,40.519480519480517,"kg/1000km",{"$f":"+F191*F185","v":810389.61038961029}]
[null,null,"Diesel Mileage ",null,null,900.90090090090087,"L/1000km"]
[]
[null,null,"Hydrogen Fuel Cost",null,null,675.86493506493514,"per truck"]
[null,null,"Diesel Fuel Cost",null,null,23423.423423423421,"per truck"]
[]
[null,null,"H2 Capacity",null,null,48.845401174168295,"kg/day"]
[]
[null,null,"Electrolysis "]
[null,null,"Generation "]
[null,null,"H2 Refueller",null,null,2000000,"installed"]
[null,null,"Storage infastructure "]
[]
[null,null,"Project Duration",null,null,10,"years"]
[null,null,"Hydrogen Project",null,null,2148690.2857142859,"total"]
[null,null,null,null,null,214869.02857142859,"per annum"]
[null,null,"Diesel usage over  duration ",null,null,5153153.1531531531,"total"]
[null,null,null,null,null,515315.31531531533,"per annum"]
[]
[null,null,"Hydrogen Cost",null,null,0.83400000000000007,"$/kg"]
[null,null,"Breakeven H2 Price",null,null,12.05194871794872,"$/kg"]
[null,null,"H2 @ Diesel NPV",null,null,28.90390390390391,"$/kg"]
[null,null,"Profit Margin",null,null,16.851955185955191,"$/kg"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Applied_Refuller","Base_Fuller",null,null,"='Sceanario assumptions '!$G$42"]
[null,null,null,null,null,"capexp","base_capexp",null,null,"='Electrolyser Assumptions'!$K$27"]
[null,null,null,null,null,"Cost_Applied","Base_Cost",null,null,"='Sceanario assumptions '!$I$21"]
[null,null,null,null,null,"Hrs_Hydrogen","Base_Hydrogen",null,null,"='Sceanario assumptions '!$I$42"]
[null,null,null,null,null,"Hrs_Truck","Base_Hrs",null,null,"='Sceanario assumptions '!$G$5"]
[null,null,null,null,null,"opexp","base_opexp",null,null,"='Sceanario assumptions '!$G$11"]
[null,null,null,null,null,null,null,null,null,"='Electrolyser Assumptions'!$K$47"]
[null,null,null,null,null,null,null,null,null,"='Electrolyser Assumptions'!$I$27"]
[null,null,null,null,null,null,null,null,null,"='Sceanario assumptions '!$G$21"]
[null,null,null,null,null,"Diesel",null,null,null,"='Sceanario assumptions '!$F$32"]
[null,null,null,null,null,null,null,null,null,"='Sceanario assumptions '!$D$11"]
[null,null,null,null,null,null,null,null,null,"='Sceanario assumptions '!$D$5"]
[null,null,null,null,null,"InfraNPV",null,null,null,"='Retrofit Financial Model'!$G$56"]
[null,null,null,null,null,"Infraprice",null,null,null,"='Retrofit Financial Model'!$F$45"]
[null,null,null,null,null,"npv",null,null,null,"='Electrolizer Financial Model'!$G$37"]
[null,null,null,null,null,null,null,null,null,"='Electrolyser Assumptions'!$I$47"]
[null,null,null,null,null,"price",null,null,null,"='Electrolizer Financial Model'!$F$17"]
[null,null,null,null,null,"retronpv",null,null,null,"='Retrofit Financial Model'!$G$30"]
[null,null,null,null,null,"retroprice",null,null,null,"='Retrofit Financial Model'!$F$15"]