{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["SUE overview table","Fuel production cost (cat. 1a)","Fuel production cost (cat. 1b)","H2 production cost (cat. 2a)"," Fuel conversion cost (cat. 2b)","Reference and suggested values"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"SUE overview table","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,4,22,7],[3,0,3,1],[4,0,4,1],[1,0,1,9],[0,0,0,9],[17,7,18,7],[17,4,18,4],[17,6,18,6],[17,5,18,5]]}
[" COST ANALYSIS SUMMARY"]
["Purpose: This worksheet is intended to provide an estimated production cost of the fuel using the proposed technology. The total calculated value will be based on cost estimates provided by the applicant for converting electricity into fuel, transporting for 1000 miles, storing the fuel, and converting it back to electricity.  Fields higlighted in blue need to be filled in by the applicant or selected from a dropdown menu, while orange fields will automatically be populated based on the data provided. If proposing to either \"Category 1\", \"Category 2\", or \"Category 1&2 combined\", then fill out the appropriate sheet in this workbook. When entering the final value in that spreadsheet, the values in this sheet will highlight yellow and change the SUE accordingly. "]
[]
["PI institution"]
["Control number"]
[]
[null,"Input cells","blue shaded cells require manual input"]
[null,"Input cells","Do not change values in yellow cells"]
[null,"Output cells","Do not change formulas in green cells"]
[]
[null,"Category 1&2"]
[null,"Ammonia","Indicate here which category you are proposing to from dropdown "]
["Fuel type:","Liquified gas"]
["Energy density, kWh/L",4.25]
["Density, g/cm3"]
["Fuel conversion method","Fuel cell"]
[]
[{"$nulls":4},"*Same values as Table 3 of FOA, all units must be in $/kWh","CF","Conversion efficiency","CC"]
["SUE",{"$f":"((B21+B22+B23)/B24)+B25","v":5.0481283422459888E-2},"=((CF+CT+CS)/η)+CC in $/kWh"]
[{"$nulls":4},"Ammonia",{"$f":"(IF($B$12=E20,'Fuel production cost (cat. 1a)'!B2,0.128))+(IF($B$12=E20,'Fuel production cost (cat. 1b)'!B2,0))","v":0},{"$f":"'Reference and suggested values'!B33","v":0.55000000000000004},{"$f":"'H2 production cost (cat. 2a)'!B2+' Fuel conversion cost (cat. 2b)'!B2","v":0}]
["CF",{"$f":"IF(B11=\"Category 1\",IF(B12=\"Ammonia\",F20,IF(B12=\"gasoline\",F21,F22)),IF(B11=\"Category 1&2\",IF(B12=\"Ammonia\",F20,IF(B12=\"gasoline\",F21,F22)),IF(B11=\"Category 2\",IF(B12=\"Ammonia\",F20,IF(B12=\"gasoline\",F21,F22)))))","v":0},"Cost of fuel production",null,"gasoline",{"$f":"IF($B$12=E21,'Fuel production cost (cat. 1a)'!B2,0.09)+IF($B$12=E21,'Fuel production cost (cat. 1b)'!B2)","v":0.09},{"$f":"'Reference and suggested values'!B34","v":0.3},{"$f":"'H2 production cost (cat. 2a)'!B2+' Fuel conversion cost (cat. 2b)'!B2","v":0}]
["CT",{"$f":"IF(B13=\"Liquified gas\",'Reference and suggested values'!B14/'SUE overview table'!B14,'Reference and suggested values'!B13/'SUE overview table'!B14)","v":1.3411764705882354E-2},"Transportation cost",null,"Other"]
["CS",{"$f":"IF(B13=\"Liquified gas\",'Reference and suggested values'!B18/'SUE overview table'!B14,'Reference and suggested values'!B17/'SUE overview table'!B14)","v":1.4352941176470587E-2},"Storage cost",null,"*If selecting 'Other', then enter your own values in blue cells. Do not edit cells otherwise"]
["η",{"$f":"IF(B16=\"Fuel Cell\",'Reference and suggested values'!B33,'Reference and suggested values'!B34)","v":0.55000000000000004},"Efficiency of fuel conversion"]
["CC",{"$f":"IF(B12=\"Ammonia\",H20,IF(B12=\"gasoline\",H21,H22))","v":0},"Cost of fuel conversion"]
[]
[{"$nulls":7},"Category 1"]
[{"$nulls":7},"Category 2"]
[{"$nulls":7},"Category 1&2"]

{"sheet":"Fuel production cost (cat. 1a)","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"CF"]
["Total fuel production cost ",null,"$/kWh","Sum of capital cost (B26) and + OPEX(B22). Enter value manually"]
[]
["Fuel selected",{"$f":"'SUE overview table'!B12","v":"Ammonia"}]
[]
[null,null,"Units","Explanation and reference for each input"]
["Inputs",null,null,"*can include additional inputs as needed"]
["Energy input",150,"MW"]
["Electricity delivery method","Solar Thermal",null,"select from dropdown"]
["Capacity factor",{"$f":"LOOKUP(B9,'Reference and suggested values'!A8:A10,'Reference and suggested values'!B8:B10)","v":0.22700000000000001},null,"Populated from \"References and suggested values\" sheet"]
["Process output",{"$f":"B8*24*B10*1000*B20","v":0},"kWh/day"]
["Feedstock 1","N2 or CO2"]
["Feedstock 1 cost",null,"$/kg","ex. Cost of N2 from air separation unit, or hydrogen or water from desalination plant"]
["Feedstock 1 cost",null,"$/kWh fuel"]
["Feedstock 2","H2"]
["Feedstock 2 cost",null,"$/kg"]
["Feedstock 2 cost",null,"$/kWh fuel"]
["Electricity cost",0.05,"$/kWh","0.05 $/kWh Do not change."]
["Theoretical energy requirement",null,"kWh/kWh fuel","Calculate based on thermodynamics of the production of fuel from water and air. "]
["Fuel production efficiency",null,"%"]
["Energy cost",{"$f":"B19/B20*B18","v":{"$error":"#DIV/0!"}},null,"The formula in cell B21 was changed to include the electricity cost multiplier"]
["Total material cost (OPEX)",null,"$/kWh","Feedstock 1 + Feedstock 2 + Energy (i.e. all consumables)"]
["Capital Cost",null,"$/kW","The formula in cell B23 was removed and the cell color changed to blue indicating that input from the applicant is required "]
["O&M cost",{"$f":"B23*0.1","v":0},"$/kW","Assumed 10% of Capital Cost"]
["Projected lifetime of equipment",25,"years","25 years is the default value"]
["Levelized capital cost of fuel production",{"$f":"(B23+B24)/B25/8000/B10","v":0},"$/kWh"]

{"sheet":"Fuel production cost (cat. 1b)","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"CF"]
["Total fuel production cost ",null,"$/kWh","Sum of capital cost (B26) and + OPEX(B22). Enter value manually"]
[]
["Fuel selected",{"$f":"'SUE overview table'!B12","v":"Ammonia"}]
[]
[null,null,"Units","Explanation and reference for each input"]
["Inputs",null,null,"*can include additional inputs as needed"]
["Energy input",150,"MW"]
["Electricity delivery method","Solar Thermal",null,"select from dropdown"]
["Capacity factor",{"$f":"LOOKUP(B9,'Reference and suggested values'!A8:A10,'Reference and suggested values'!B8:B10)","v":0.22700000000000001},null,"Populated from \"References and suggested values\" sheet"]
["Process output",{"$f":"B8*24*B10*1000*B20","v":0},"kWh/day"]
["Feedstock 1","N2 or CO2"]
["Feedstock 1 cost",null,"$/kg","ex. Cost of N2 from air separation unit, or hydrogen or water from desalination plant"]
["Feedstock 1 cost",null,"$/kWh fuel"]
["Feedstock 2","H2"]
["Feedstock 2 cost",null,"$/kg"]
["Feedstock 2 cost",null,"$/kWh fuel"]
["Electricity cost",0.05,"$/kWh","0.05 $/kWh Do not change."]
["Theoretical energy requirement",null,"kWh/kWh fuel","Calculate based on thermodynamics of the production of fuel from water and air. "]
["Fuel production efficiency",null,"%"]
["Energy cost",{"$f":"B19/B20","v":{"$error":"#DIV/0!"}},null,"The formula in cell B21 was changed to include the electricity cost multiplier"]
["Total material cost (OPEX)",null,"$/kWh","Feedstock 1 + Feedstock 2 + Energy (i.e. all consumables)"]
["Capital Cost",null,"$/kW","The formula in cell B23 was removed and the cell color changed to blue indicating that input from the applicant is required "]
["O&M cost",{"$f":"B23*0.1","v":0},"$/kW","Assumed 10% of Capital Cost"]
["Projected lifetime of equipment",25,"years","25 years is the default value "]
["Levelized capital cost of fuel production",{"$f":"(B23+B24)/B25/8000/B10","v":0},"$/kWh"]

{"sheet":"H2 production cost (cat. 2a)","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,"CF"]
["Fuel conversion cost (CC)",null,"$/kWh","<- This cell is tied to a formula. Enter value manually after calculating below. "]
["Efficiency",0.5,"%","<- This cell is tied to a formula. Enter value manually after calculating below. "]
["Fuel selected",{"$f":"'SUE overview table'!B12","v":"Ammonia"}]
[]
[null,null,"Units","Explanation and reference for each input"]
["Inputs",null,null,"*can include additional inputs as needed"]
[]
["Electricity cost",0.05,"$/kWh","0.05 $/kWh Do not change."]
["Fuel price, $/kg",null,"$/kg","manual "]
["Fuel price, $/kWh",null,"$/kWh","manual or output from Fuel production cost spreadsheet"]
["Hydrogen content",null,"weight fraction"]
["Process output",null,"kWh/day"]
["Conversion system","low temp FC",null,"select from dropdown. If Other, note temperature and references."]
["Fuel Cell costs, $/kW ",{"$f":"LOOKUP(B14,'Reference and suggested values'!A21:A23,'Reference and suggested values'!B21:B23)","v":1600},"$/kW","Populated from \"References and suggested values\" sheet Fuel cell cost section"]
["Fuel cell power density, mW/cm2",{"$f":"LOOKUP(B14,'Reference and suggested values'!A21:A23,'Reference and suggested values'!B27:B29)","v":410},"mW/cm2","Populated from \"References and suggested values\" sheet Fuel cell powre density section"]
["Power density, mW/cm2",300,"mW/cm2"]
["Conversion efficiency",0.5,"%"]
["Capital Cost at 150 MW scale",{"$f":"B15/B17*B16","v":2186.6666666666665},"$/kW"]
["O&M cost",{"$f":"B19*0.1","v":218.66666666666666},"$/kW","Assumed 10% of Capital Cost"]
["Cost of H2 generation",{"$f":"B10*B12/B18","v":0},"$/kg"]
["Capacity factor",0.65,"%"]
["Projected lifetime of equipment",15,"years","15 years is the default number. "]
["Levelized capital cost of H2 generation",{"$f":"(B19+B20)/B23/8000/B22/B18","v":6.1675213675213662E-2},"$/kWh"]
["Levelized capital cost of H2 generation",{"$f":"B24*33.6","v":2.0722871794871791},"$/kg"]
["Total H2 cost",{"$f":"B21+B25","v":2.0722871794871791},"$/kg"]

{"sheet":" Fuel conversion cost (cat. 2b)","index":4,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"CF"]
["Fuel conversion cost (CC)",null,"$/kWh","<- This cell is tied to a formula. Enter value manually after calculating below"]
["Efficiency",null,"%","<- This cell is tied to a formula. Enter value manually after calculating below. "]
["Fuel selected",{"$f":"'SUE overview table'!B12","v":"Ammonia"}]
[]
[null,null,"Units","Explanation and reference for each input"]
["Inputs",null,null,"*can include additional inputs as needed"]
[]
["Electricity cost",0.05,"$/kWh","0.05 $/kWh Do not change."]
["Fuel price, $/kg",null,"$/kg","manual "]
["Fuel price, $/kWh",null,"$/kWh","manual or output from Fuel production cost spreadsheet"]
[null,null,"weight fraction"]
["Process output",null,"kWh/day"]
["Conversion system","low temp FC",null,"select from dropdown. If Other, note temperature and references."]
["Fuel Cell costs, $/kW ",{"$f":"LOOKUP(B14,'Reference and suggested values'!A21:A23,'Reference and suggested values'!B21:B23)","v":1600},"$/kW","Populated from \"References and suggested values\" sheet Fuel cell cost section"]
["Fuel cell power density, mW/cm2",{"$f":"LOOKUP(B14,'Reference and suggested values'!A21:A23,'Reference and suggested values'!B27:B29)","v":410},"mW/cm2","Populated from \"References and suggested values\" sheet Fuel cell powre density section"]
["Power density, mW/cm2",300,"mW/cm2"]
["Conversion efficiency",0.65,"%"]
["Capital Cost at 150 MW scale",{"$f":"B15/B17*B16","v":2186.6666666666665},"$/kW"]
["O&M cost",{"$f":"B19*0.1","v":218.66666666666666},"$/kW","Assumed 10% of Capital Cost"]
["Capacity factor",0.65,"%"]
["Projected lifetime of equipment",15,"years","15 years is the default number. "]
["Levelized capital cost of fuel conversion",{"$f":"(B19+B20)/B22/8000/B21/B18","v":4.7442472057856663E-2},"$/kWh"]

{"sheet":"Reference and suggested values","index":5,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Assumptions"]
[]
["Feedstock cost, $/ton"]
["Nitrogen from air",40,null,"http://adgastech.com/Products/Industrial-Gas-Generators/Nitrogen-Generators/ "]
["CO2 from air",250,null,"https://static1.squarespace.com/static/51957744e4b088893b86e2f3/t/51b228f9e4b0d25a229e7ca4/1370630392913/CE-Air-Capture-FAQ.pdf"]
[]
["Capacity factors for fuel production (directly linked to source), %",null,null,"(https://www.eia.gov/electricity/monthly/epm_table_grapher.cfm?t=epmt_6_07_b)"]
["PV solar",0.28599999999999998]
["Solar Thermal",0.22700000000000001]
["Wind",0.32500000000000001]
[]
["Transportation cost, $/L ",null,null,"https://www.iea.org/publications/freepublications/publication/FeaturedInsights_AlternativeFuel_FINAL.pdf;"]
["Liquid",5.2999999999999999E-2,null,"http://lib.dr.iastate.edu/cgi/viewcontent.cgi?article=2119&context=etd "]
["Liquified gas",5.7000000000000002E-2]
[]
["Storage cost, $/L ",null,null,"https://www.iea.org/publications/freepublications/publication/FeaturedInsights_AlternativeFuel_FINAL.pdf;"]
["Liquid",2.5999999999999999E-3,null,"http://lib.dr.iastate.edu/cgi/viewcontent.cgi?article=2119&context=etd "]
["Liquified gas",6.0999999999999999E-2]
[]
["Fuel Cell costs, $/kW "]
["high temp FC",1700,null,"https://www.sainc.com/service/SA%202015%20Manufacturing%20Cost%20and%20Installed%20Price%20of%20Stationary%20Fuel%20Cell%20Systems.pdf)"]
["low temp FC",1600,null,"https://www.sainc.com/service/SA%202015%20Manufacturing%20Cost%20and%20Installed%20Price%20of%20Stationary%20Fuel%20Cell%20Systems.pdf)"]
["other",null,null,"Note the tempearture and any references"]
[]
[]
["Fuel cell power density, mW/cm2",null,"at cell voltage"]
["high temp FC",290,0.8,"https://www.sainc.com/service/SA%202015%20Manufacturing%20Cost%20and%20Installed%20Price%20of%20Stationary%20Fuel%20Cell%20Systems.pdf)"]
["low temp FC",410,0.67500000000000004,"https://www.sainc.com/service/SA%202015%20Manufacturing%20Cost%20and%20Installed%20Price%20of%20Stationary%20Fuel%20Cell%20Systems.pdf)"]
["other"]
[]
[]
["Conversion efficiency, %"]
["Fuel cell",0.55000000000000004]
["Internal combustion engine",0.3]