{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Cover & Instructions","BF-BOF - Low-C Elec","Assumptions - Today's Grid","BF-BOF - Today's Grid","Assumptions - Low-C Elec","Your Tech - Today's Grid","Your Tech - Low-C Elec","Comparison"],"not_rendered":{"charts":3,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":12,"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":"Cover & Instructions","index":0,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Welcome to the Ironmaking Cost and GHG Estimator Tool. Read everything here first!!!"]
["Disclaimer"]
["This spreadsheet tool is not designed to model every possible iron or steelmaking technology. "]
["This tool is meant for non-LCA experts to use! As long as you can estimate the material and energy inputs of your technology, this tool will do much of the background LCA work for you."]
["The goal of this tool is to enable fair comparison of technologies using input data from a common, standard input library."]
["Use this tool to quantify all your technology's material and energy inputs to your proposed iron/steelmaking technology. You can choose type of energy input (e.g. natural gas, electricity, hydrogen) and quality of ore (e.g. imported or US taconite)."]
["It should be possible to model your proposed technology using the data provided. If there are significant barriers to modeling your technology with the tool, do the best you can and discuss any limitations in your application."]
["The embodied emissions for steel scrap include collection, transportation, sorting, etc."]
["This tool only tracks GHG emissions. Refer back to the FOA and address any other environmental concerns explicitly noted."]
["This tool does not directly break emissions into Scopes as defined by the WRI GHG Protocol. However, on the Comparison sheet, results are broken out into life cycle stages. These results will be used in concert with your application to gauge the GHG reduction potential of your proposed technology."]
{"$rows_empty":12}
["The above steps are all covered automatically in this tool. Regardless of if you are applying to Track 1 or Track 2, fill out all of the green-shaded cells in on the \"Your Tech - Today's Grid\" sheet. "]
[]
["Sheet Overviews/Instructions"]
["There are 6 sheets after this cover page in the document. You may only edit three of them. You must update the data in \"Your Tech - Today's Grid\" case, and you may update the \"Assumptions - Low-C Elec\" and \"Your Tech - Low-C Elec\" sheets if and only if the provided model does not capture specific material and energy inputs to your technology."]
["Assumptions - Today's Grid: Background data (GHG emissions, energy consumption) and cost for energy and material inputs to iron and steel-making technologies using today's grid, energy costs, etc. Do not edit this sheet!"]
["Assumptions - Low-C Elec: Background data (GHG emissions, energy consumption) and cost for energy and material inputs to iron and steel-making technologies using a future low-carbon grid, energy cost estimates, etc. If there are specific energy or material feedstocks not captured in this tool, you may add them here with references for all data entered. If you add them, you will need to write manual formulas on the \"Your Tech - Today's Grid,\" \"Your Tech - Low-C Elec,\" and the \"Comparison\" sheets to use this new data. "]
["BF-BOF - Today's Grid: Process data for BF-BOF using today's grid scenario assumptions. Do not edit this sheet!"]
["BF-BOF - Low-C Elec: Process data for BF-BOF using low-carbon grid scenario assumptions. Do not edit this sheet!"]
["Your Tech - Today's Grid: For all green shaded cells, either leave a zero or add the correct number estimating how much material/energy flow your technology requires at each step of the iron/steelmaking process. For each number entered, provide jusfitifacion in the Justification column. Note all auxiliary processes are also modeled like feedstock production, sintering, skin mill, EAF, etc. You may edit energy and material inputs to these processes as well. "]
["Your Tech - Low-C Elec: Process data fed from the \"Your Tech - Today's Grid\" sheet. If there are technical reasons to believe that the material/energy inputs will change based solely on the carbon intensity of electricity in your process, you may make changes with ample justification. Otherwise, do note edit this sheet!"]
["Comparison: Auto-populated charts and tables fed from inputs on the other sheets of this workbook. Do not edit this sheet!"]
[]
["How to use"]
["Note units on all cells!"]
["Any green shaded cell is editable. "]
["Please update any inputs in green that are applicable to your technology. If you do this, you MUST also fill out the \"Justification for Changes\" column in that row."]
["Cradle-to-gate biogenic carbon uptake and emissions should not be tracked UNLESS biogenic CH4 is directly emitted during the process OR biogenic C is permanently stored in the iron/steel product. Note in your application how much biogenic C (t C/t product) is permanently sequestered in the final iron/steel product (if any)."]
["Sources for input data/assumptions are provided to help you as you document justifications for any changes you make to green shaded cells."]
["If your technology combines process steps, choose one of them represented in this model to apply your input material and energy consumption data, zero out the other(s), and provide ample justification."]
[]
["Abbreviations, definitions"]
["All greenhouse gas (GHG) emissions factors are cradle-to-gate (non-biogenic embodied columns) and gate-to-gate (non-biogenic chemical/combustion columns) in terms of CO2-equivalents and utilize 100-year GWP values. If your process directly (i.e. from process chemistry, not from upstream energy production or use) emits CH4, N2O, SF6, or other greenhouse gases to the atmosphere, please note this in your application."]
["\"t\" always means metric tonne"]
[]
["Request for comments, suggestions, additions"]
["Please send any questions or comments to daniel.garcia@hq.doe.gov cc-ing jenifer.shafer@hq.doe.gov"]

{"sheet":"BF-BOF - Low-C Elec","index":1,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["Notional BF-BOF Technology"]
["Input Variable",null,null,"Value","Cost Units","Value","Amount/t crude steel","Value","Embedded emissions",null,"Value","Process emissions","Justification for Changes","Source"]
[]
["Capital Equipment"]
["BF + BOF (total upfront cost)",null,null,{"$f":"'Assumptions - Low-C Elec'!C43","v":600},"$/t HRC"]
["BF + BOF Annualized",null,null,{"$f":"'Assumptions - Low-C Elec'!C44","v":59.165544664400912},"$/t HRC"]
[]
["On-Site Operations"]
["BF + BOF",null,null,{"$f":"D5*0.085","v":51.000000000000007},"$/t HRC"]
["Sintering",null,null,{"$f":"D68+SUM(E69:E75)","v":7.920100259578696},"$/t HRC",{"$nulls":5},{"$f":"SUM(H69:H75)","v":0.1381310773925683},"t CO2e/t HRC steel"]
["Hot Rolling",null,null,{"$f":"D60+SUM(E61:E66)","v":21.164088526841041},"$/t HRC",{"$nulls":5},{"$f":"SUM(H61:H66)","v":6.6287986935833917E-2},"t CO2e/t HRC steel"]
["Stamping",null,null,{"$f":"D77+SUM(E78:E83)","v":19.642892538670523},"$/t HRC",{"$nulls":5},{"$f":"SUM(H78:H83)","v":1.7642878424367781E-2},"t CO2e/t HRC steel"]
["Skin Mill",null,null,{"$f":"D85+SUM(E86:E91)","v":1.8616296356094906},"$/t HRC",{"$nulls":5},{"$f":"SUM(H86:H91)","v":8.6162894630633356E-4},"t CO2e/t HRC steel"]
[]
[]
["Transportation",null,"Distance (mi)"]
["Water",null,0,{"$f":"C17*'Assumptions - Low-C Elec'!$C$36*F17","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*'Assumptions - Low-C Elec'!$I$36*C17","v":0},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
["Rail",null,800,{"$f":"C18*'Assumptions - Low-C Elec'!$C$37*F18","v":96},"$/t HRC steel",4,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*'Assumptions - Low-C Elec'!$I$37*C18","v":0.13215999999999997},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
["Truck",null,0,{"$f":"C19*'Assumptions - Low-C Elec'!$C$38*F19","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F19*'Assumptions - Low-C Elec'!$I$38*C19","v":0},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
[]
["Energy Inputs to Ironmaking Step ONLY (Blast Furnace)"]
["Natural gas",null,null,{"$f":"F22*'Assumptions - Low-C Elec'!C24","v":3.9950533904138403},"$/t HRC steel",{"$f":"CONVERT(1.462*1000000,\"BTU\",\"GJ\")","v":1.5424916565304403},"GJ/t HRC steel",{"$f":"F22*'Assumptions - Low-C Elec'!F24","v":1.6967408221834842E-2},"t CO2e/t HRC steel",null,{"$f":"F22*'Assumptions - Low-C Elec'!I24","v":0.10334694098753951},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F23*'Assumptions - Low-C Elec'!C25","v":25.046888783937963},"$/t HRC steel",{"$f":"CONVERT(9.933*1000000,\"BTU\",\"GJ\")","v":10.479869784074461},"GJ/t HRC steel",{"$f":"F23*'Assumptions - Low-C Elec'!F25","v":6.2879218704446765E-2},"t CO2e/t HRC steel",null,{"$f":"F23*'Assumptions - Low-C Elec'!I25","v":1.1527856762481907},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F24*'Assumptions - Low-C Elec'!C27","v":2.022192001940641},"$/t HRC steel",{"$f":"CONVERT(0.23*1000000,\"BTU\",\"GJ\")","v":0.24266284610260003},"GJ/t HRC steel",{"$f":"F24*'Assumptions - Low-C Elec'!F27","v":4.7184442297727785E-3},"t CO2e/t HRC steel",null,{"$f":"F24*'Assumptions - Low-C Elec'!I26","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F25*'Assumptions - Low-C Elec'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F25*'Assumptions - Low-C Elec'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F25*'Assumptions - Low-C Elec'!I28","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F26*'Assumptions - Low-C Elec'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F26*'Assumptions - Low-C Elec'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F26*'Assumptions - Low-C Elec'!I29","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F27*'Assumptions - Low-C Elec'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F27*'Assumptions - Low-C Elec'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F27*'Assumptions - Low-C Elec'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F28*'Assumptions - Low-C Elec'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F28*'Assumptions - Low-C Elec'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F28*'Assumptions - Low-C Elec'!I31","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F29*'Assumptions - Low-C Elec'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F29*'Assumptions - Low-C Elec'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F29*'Assumptions - Low-C Elec'!I32","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Natural gas",null,null,{"$f":"F32*'Assumptions - Low-C Elec'!C24","v":0.91268661586745725},"$/t HRC steel",{"$f":"CONVERT(0.334*1000000,\"BTU\",\"GJ\")","v":0.35238865477508002},"GJ/t HRC steel",{"$f":"F32*'Assumptions - Low-C Elec'!F24","v":3.87627520252588E-3},"t CO2e/t HRC steel",null,{"$f":"F32*'Assumptions - Low-C Elec'!I24","v":2.3610039869930363E-2},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F33*'Assumptions - Low-C Elec'!C25","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F33*'Assumptions - Low-C Elec'!F25","v":0},"t CO2e/t HRC steel",null,{"$f":"F33*'Assumptions - Low-C Elec'!I25","v":0},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F34*'Assumptions - Low-C Elec'!C27","v":0.9671353052759587},"$/t HRC steel",{"$f":"CONVERT(0.11*1000000,\"BTU\",\"GJ\")","v":0.11605614378820002},"GJ/t HRC steel",{"$f":"F34*'Assumptions - Low-C Elec'!F27","v":2.2566472403261115E-3},"t CO2e/t HRC steel",null,{"$f":"F34*'Assumptions - Low-C Elec'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F35*'Assumptions - Low-C Elec'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F35*'Assumptions - Low-C Elec'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F35*'Assumptions - Low-C Elec'!I28","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F36*'Assumptions - Low-C Elec'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F36*'Assumptions - Low-C Elec'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F36*'Assumptions - Low-C Elec'!I29","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F37*'Assumptions - Low-C Elec'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F37*'Assumptions - Low-C Elec'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F37*'Assumptions - Low-C Elec'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F38*'Assumptions - Low-C Elec'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F38*'Assumptions - Low-C Elec'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F38*'Assumptions - Low-C Elec'!I31","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F39*'Assumptions - Low-C Elec'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F39*'Assumptions - Low-C Elec'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F39*'Assumptions - Low-C Elec'!I32","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Ironmaking Step ONLY (Blast Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F42*'Assumptions - Low-C Elec'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F42*SUM(H105:H112)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I14*F42","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F43*'Assumptions - Low-C Elec'!C15","v":456},"$/t HRC steel",4,"t Fe/t HRC steel",{"$f":"F43*SUM(H115:H122)","v":8.3022110585811673E-2},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I15*F43","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F44*'Assumptions - Low-C Elec'!C16","v":25},"$/t HRC steel",{"$f":"0.25*('Assumptions - Low-C Elec'!B15)","v":6.25E-2},"t scrap/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F16*F44","v":1.2500000000000001E-2},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I16*F44","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F45*'Assumptions - Low-C Elec'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F17*F45","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I17*F45","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F46*'Assumptions - Low-C Elec'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F18*F46","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I18*F46","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F47*'Assumptions - Low-C Elec'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F19*F47","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I19*F47","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F48*'Assumptions - Low-C Elec'!C20","v":10.5},"$/t HRC steel",{"$f":"150/2000","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F20*F48","v":8.2499999999999989E-4},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I20*F48","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F51*'Assumptions - Low-C Elec'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F51*SUM(H105:H112)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I14*F51","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F52*'Assumptions - Low-C Elec'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F52*SUM(H115:H122)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I15*F52","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F53*'Assumptions - Low-C Elec'!C16","v":0},"$/t HRC steel",{"$f":"0.25*('Assumptions - Low-C Elec'!B25)","v":0},"t scrap/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F16*F53","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I16*F53","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F54*'Assumptions - Low-C Elec'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F17*F54","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I17*F54","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F55*'Assumptions - Low-C Elec'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F18*F55","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I18*F55","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F56*'Assumptions - Low-C Elec'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F19*F56","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I19*F56","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F57*'Assumptions - Low-C Elec'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F20*F57","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I20*F57","v":0},"t CO2e/t HRC steel"]
[]
["Life Cycle Stages",{"$nulls":4},"Energy Input","Unit"]
["Hot Rolling",null,null,5,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F61*'Assumptions - Today''s Grid'!C23","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F61*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":5.1845444597746801E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F62*'Assumptions - Today''s Grid'!C26","v":14.442553892120989},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F62*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":1.4442542338087115E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F63*'Assumptions - Today''s Grid'!C17","v":0},0,"t/t HRC",{"$f":"F63*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F64*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F64*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F65*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F65*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F66*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F66*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
[]
["Sintering",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F69*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F69*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F70*'Assumptions - Today''s Grid'!C26","v":3.1387936725774299},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F70*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":3.1387911615445006E-3},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F71*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F71*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F72*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F72*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F73*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F73*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F74*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F74*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F75*'Assumptions - Today''s Grid'!C24","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F75*('Assumptions - Low-C Elec'!$F$25+'Assumptions - Low-C Elec'!$I$25)","v":0.1349922862310238},"t CO2e/t HRC"]
[]
["Stamping",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F78*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F78*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F79*'Assumptions - Today''s Grid'!C26","v":17.642892538670523},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F79*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":1.7642878424367781E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F80*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F80*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F81*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F81*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F82*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F82*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F83*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F83*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill",null,null,1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F86*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F86*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F87*'Assumptions - Today''s Grid'!C26","v":0.86162963560949068},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F87*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":8.6162894630633356E-4},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F88*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F88*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F89*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F89*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F90*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F90*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F91*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F91*'Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30","v":0},"t CO2e/t HRC"]
[]
["EAF",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F94*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F94*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F95*'Assumptions - Today''s Grid'!C26","v":0},0,"GJ/t HRC",{"$f":"F95*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F96*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F96*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F97*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F97*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F98*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F98*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F99*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F99*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F100*'Assumptions - Today''s Grid'!C24","v":0},0,"GJ/t HRC",{"$f":"F100*('Assumptions - Low-C Elec'!$F$25+'Assumptions - Low-C Elec'!$I$25)","v":0},"t CO2e/t HRC"]
["Scrap",null,null,null,{"$f":"F101*'Assumptions - Today''s Grid'!C16","v":0},0,"t/t HRC",{"$f":"F101*('Assumptions - Low-C Elec'!$F$16+'Assumptions - Low-C Elec'!$I$16)","v":0},"t CO2e/t HRC"]
["Iron Ore",null,null,null,{"$f":"F102*'Assumptions - Today''s Grid'!C14","v":0},0,"t/t HRC",{"$f":"F102*'Assumptions - Low-C Elec'!$F$15","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F105*'Assumptions - Today''s Grid'!C23","v":3.5259285913365163E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":1.3613623904774195E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F105*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":1.0618626645723871E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F106*'Assumptions - Today''s Grid'!C26","v":2.6140069590303288},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F106*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":2.614004867826434E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F107*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F108*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F109*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F110*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F111*'Assumptions - Today''s Grid'!C30","v":1.5806451612903225},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":4.7647683666709684E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*('Assumptions - Low-C Elec'!$F$31+'Assumptions - Low-C Elec'!$I$31)","v":4.3835868973372905E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F112*'Assumptions - Today''s Grid'!C31","v":9.6774193548387108E-2},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":3.4034059761935487E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*('Assumptions - Low-C Elec'!$F$32+'Assumptions - Low-C Elec'!$I$32)","v":3.0970994383361291E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F115*'Assumptions - Today''s Grid'!C23","v":8.7443029065145603E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":3.3761787283840002E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F115*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":2.6334194081395201E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F116*'Assumptions - Today''s Grid'!C26","v":6.4827372583952139},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F116*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":6.4827320722095558E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F117*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F117*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F118*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F118*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F119*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F120*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F121*'Assumptions - Today''s Grid'!C31","v":3.3600000000000003},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":0.11816625549344001},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*('Assumptions - Low-C Elec'!$F$31+'Assumptions - Low-C Elec'!$I$31)","v":1.0871295505396481E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F122*'Assumptions - Today''s Grid'!C32","v":0},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":8.4404468209600004E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*('Assumptions - Low-C Elec'!$F$32+'Assumptions - Low-C Elec'!$I$32)","v":7.6808066070736E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Assumptions - Today's Grid","index":2,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Assumptions"]
["Instructions: Standard assumptions are provided below; do not change them. To add alternate assumptions, feel free to insert as many rows as needed per section (see 'Alternate inputs (applicant-added) green rows)."]
["Input Variable",null,"Value","Cost Units",null,"Value","Non-biogenic Embodied Emissions Unit",null,"Value","Non-biogenic Process Emissions (i.e. chemical or combustion)","Cost Reference","Emissions Reference"]
[]
["Operational Assumptions"]
["Equipment availability",null,95,"%",{"$nulls":6},"IEA Iron & Steel Roadmap, Oct. 2020 (IEA, 2020) Fig 1.3","n/a"]
["Equipment lifetime",null,25,"years",{"$nulls":6},"IEA, 2020 Fig 1.3","n/a"]
["Cost of capital",null,8,"%",{"$nulls":6},"IEA, 2020 Fig 1.3","n/a"]
["Capital recovery factor (CRF)",null,{"$f":"(C8/100*(1+C8/100)^C7)/((1+C8/100)^C7-1)","v":9.3678779051968114E-2},{"$nulls":7},"Calculated from above","n/a"]
["Carbon capture rate",null,90,"%",{"$nulls":6},"climate.mit.edu/ask-mit/how-efficient-carbon-capture-and-storage","n/a"]
["On-site Hydrogen Electrolyzer Energy Consumpition",null,52,"kWh/kg H2",null,null,{"$f":"F29/F27","v":1.7652631578947366}]
[]
["Feedstock Assumptions","%Fe"]
["Iron ore fines (imported)",0.62,106,"$/tonne Fe",null,{"$f":"SUM('BF-BOF - Today''s Grid'!H105:H112)","v":2.0206872132155145E-2},"t CO2e/t Fe",null,0,"t CO2e/t Fe","USGS Mineral Yearbook 2021","GREET2 2022 Iron Ore Extraction & Processing on Steel Sheet","SGX TSI Iron Ore mean price 2015-2020, https://www.barchart.com/futures/quotes/J-M20"]
["Iron ore fines (US - Taconite)",0.25,114,"$/tonne Fe",null,{"$f":"SUM('BF-BOF - Today''s Grid'!H115:H122)","v":5.0113042887744756E-2},"t CO2e/t Fe",null,0,"t CO2e/t Fe","Internal estimate"]
["Scrap",0.98,400,"$/tonne Fe",null,0.2,"t CO2e/t Fe",null,0,"t CO2e/t Fe","IEA, 2020 Fig 1.3","Ashby, Michael F. 'Materials and the Environment: Eco-informed Material Choice', Butterworth Heinemann, 2009. 2nd Edition 2012 ISBN 9780123859716"]
["Biomass",null,3.7,"$/GJ",null,7.0000000000000007E-2,"t CO2e/t dry biomass",null,0,"t CO2e/t dry biomass","Assume $60/dry ton from 2016 Billion Ton Study and ~18 MJ/kg","GREET2020: poplar combined feedstock emissions"]
["Biocharcoal",null,300,"tonne",null,{"$f":"AVERAGE((19.38+0.67+18.39+1.34),(21.76+12.03+1.34+1.34))/1000+0.0308","v":6.8925E-2},"t CO2e/t biocharcoal",null,0,"t CO2e / t biocharcoal","Internal projection for 2050","Page 24 and Appendices 5 and 6 of \"Life Cycle Assessment and Carbon Footprint for the Production of Biochar as an Alternative of Soil Remediation,\" Alfonso R. Rodriguez, 2013"]
["Electrolysis Hydrogen",null,5,"$/kg H2",null,{"$f":"C11*F25/1000","v":20.123999999999999},"kg CO2/kg H2",null,0,"t CO2e/t H2","Internal projection for 2050","Electrolysis H2 embodied emissions from grid intensity assumption. Assume 53 kWh/kg H2 for electrolysis, purification, separation, compression, conveyance."]
["Lime",null,140,"$/tonne lime",null,1.0999999999999999E-2,"t CO2e/t lime",null,0,"t CO2e/t lime","Assume quicklime from https://pubs.usgs.gov/periodicals/mcs2022/mcs2022-lime.pdf","All emissions are embedded for the material"]
[]
["Fuel Assumptions"]
["Natural gas",null,2.59,"$/GJ",null,1.0999999999999999E-2,"t CO2e/GJ LHV",null,6.7000000000000004E-2,"t CO2e/GJ LHV","NG spot prices","Natural gas process emissions if fully combusted; GREET2020"]
["Coke",null,2.39,"$/GJ",null,6.0000000000000001E-3,"t CO2e/GJ",null,0.11,"t CO2e/GJ","Internal estimate","Coke/coal process emissions if fully combusted; Coal to coking plants GREET2020. Use combustion emissions only if not using blast furnace/coke oven gas downstream."]
["Electricity",null,7.0000000000000007E-2,"$/kWh",null,387,"g CO2e/kWh",null,0,"g CO2e/kWh",null,"EIA Outlook for 2023 national grid mix. "]
["Electricity",null,{"$f":"C25*277.778","v":19.444460000000003},"$/GJ",null,{"$f":"F25/1000000/0.0036","v":0.1075},"t CO2e/GJ",null,0,"t CO2e/GJ","Equivalent values to row 25; given here in alternate units","Assume ~90% reduction from 2020 national average grid using solar and wind"]
["Fossil SMR Hydrogen (US)",null,16.7,"$/GJ",null,9.5000000000000001E-2,"t CO2e/GJ",null,0,"t CO2e/GJ","Spot price","GREET 2022 plus leakage rate for Iron & Steel and indirect GWP of H2 gas from (REFs)"]
["Fossil SMR+CCS Hydrogen (US)",null,25,"$/GJ",null,4.4999999999999998E-2,"t CO2e/GJ",null,0,"t CO2e/GJ",null,"GREET 2022 plus leakage rate for Iron & Steel from (REF) and indirect GWP of H2 gas from (REFs)"]
["Electrolysis Hydrogen (US)",null,{"$f":"C19/120*1000","v":41.666666666666664},"$/GJ",null,{"$f":"C11*F25/120/1000","v":0.16769999999999999},"t CO2e/GJ",null,0,"t CO2e/GJ","Assume 120 MJ/kg LHV"]
["Fossil Diesel",null,{"$f":"35*CONVERT(1,\"GJ\",\"BTU\")/1000000","v":33.173599210966096},"$/GJ",null,1.6E-2,"t CO2e/GJ",null,7.5999999999999998E-2,"t CO2e/GJ","Spot/commodity price","GREET 2022 conventional fossil diesel"]
["Fossil Gasoline",null,{"$f":"30*CONVERT(1,\"GJ\",\"BTU\")/1000000","v":28.434513609399517},"$/GJ",null,1.7999999999999999E-2,"t CO2e/GJ",null,7.2999999999999995E-2,"t CO2e/GJ","Spot/commodity price","GREET 2022 conventional fossil gasoline"]
[]
["Transportation Assumptions",{"$nulls":10},"Note: all emissions associated with construction, maintenance, and dispoal of transport vehicles as well as production of the fuels are all aggregated into the numbers in column I"]
["Shipping solids worldwide (ocean)",null,0.02,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"6.95/1000000","v":6.9500000000000004E-6},"tonne CO2e/tonne-mile freight","https://www.steelonthenet.com/freight.html; internal estimate","GREET2020; Sea transit HFO (0.5% S fuel). "]
["Rail",null,0.03,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"41.3/1000000","v":4.1299999999999994E-5},"tonne CO2e/tonne-mile freight","Trains Magazine, https://cs.trains.com/trn/f/111/p/187338/2048866.aspx#:~:text=The%20average%20rate%20per%20ton-mile%20%28one%20ton%20of,year%202009%2C%20the%20average%20rate%20was%203.011%20cents.","GREET 2020; diesel rail"]
["Diesel Truck",null,0.06,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"114.5/1000000","v":1.145E-4},"tonne CO2e/tonne-mile freight","Internal estimate","GREET 2020; long haul diesel trucking (assumed payload of 19.1 U.S. short tons)"]
[]
[]
["BF-BOF Assumptions"]
["BF-BOF (tot upfront cost)",null,600,"$/t crude steel"]
["BF-BOF (annualized)",null,{"$f":"C40*C9/(C6*0.01)","v":59.165544664400912},"$/t crude steel"]
[]
[]
["EAF Assumptions"]
["Electric arc furnace (tot upfront cost)",null,310,"$/tonne HRC"]
["Electric arc furnace (annualized)",null,{"$f":"C45*C9/(C6*0.01)","v":30.568864743273803},"$/tonne HRC",{"$nulls":7},"Internal calcs; assumes state-of-art NG and solid carbon fuels inserted"]

{"sheet":"BF-BOF - Today's Grid","index":3,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
["Notional BF-BOF Technology"]
["Input Variable",null,null,"Value","Cost Units","Value","Amount/t crude steel","Value","Embedded emissions",null,"Value","Process emissions","Justification for Changes","Source"]
[]
["Capital Equipment"]
["BF + BOF (total upfront cost)",null,null,{"$f":"'Assumptions - Today''s Grid'!C40","v":600},"$/t HRC"]
["BF + BOF Annualized",null,null,{"$f":"'Assumptions - Today''s Grid'!C41","v":59.165544664400912},"$/t HRC"]
[]
["On-Site Operations"]
["BF + BOF",null,null,{"$f":"D5*0.085","v":51.000000000000007},"$/t HRC"]
["Sintering",null,null,{"$f":"D68+SUM(E69:E75)","v":7.920100259578696},"$/t HRC",{"$nulls":5},{"$f":"SUM(H69:H75)","v":0.15234531736699125},"t CO2e/t HRC steel"]
["Hot Rolling",null,null,{"$f":"D60+SUM(E61:E66)","v":21.164088526841041},"$/t HRC",{"$nulls":5},{"$f":"SUM(H61:H66)","v":0.13169207152402843},"t CO2e/t HRC steel"]
["Stamping",null,null,{"$f":"D77+SUM(E78:E83)","v":19.642892538670523},"$/t HRC",{"$nulls":5},{"$f":"SUM(H78:H83)","v":9.7539913574719014E-2},"t CO2e/t HRC steel"]
["Skin Mill",null,null,{"$f":"D85+SUM(E86:E91)","v":1.8616296356094906},"$/t HRC",{"$nulls":5},{"$f":"SUM(H86:H91)","v":4.7635771745793013E-3},"t CO2e/t HRC steel"]
[]
[]
["Transportation",null,"Distance (mi)"]
["Water",null,0,{"$f":"C17*'Assumptions - Today''s Grid'!$C$34*F17","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*'Assumptions - Today''s Grid'!$I$34*C17","v":0},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
["Rail",null,800,{"$f":"C18*'Assumptions - Today''s Grid'!$C$35*F18","v":96},"$/t HRC steel",4,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*'Assumptions - Today''s Grid'!$I$35*C18","v":0.13215999999999997},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
["Truck",null,0,{"$f":"C19*'Assumptions - Today''s Grid'!$C$36*F19","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F19*'Assumptions - Today''s Grid'!$I$36*C19","v":0},"t CO2e/t HRC steel",null,"GREET1 2022. Fuel Embedded emissions are wrapped into the \"process emissions\" column as well as combustion."]
[]
["Energy Inputs to Ironmaking Step ONLY (Blast Furnace)"]
["Natural gas",null,null,{"$f":"F22*'Assumptions - Today''s Grid'!C23","v":3.9950533904138403},"$/t HRC steel",{"$f":"CONVERT(1.462*1000000,\"BTU\",\"GJ\")","v":1.5424916565304403},"GJ/t HRC steel",{"$f":"F22*'Assumptions - Today''s Grid'!F23","v":1.6967408221834842E-2},"t CO2e/t HRC steel",null,{"$f":"F22*'Assumptions - Today''s Grid'!I23","v":0.10334694098753951},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F23*'Assumptions - Today''s Grid'!C24","v":25.046888783937963},"$/t HRC steel",{"$f":"CONVERT(9.933*1000000,\"BTU\",\"GJ\")","v":10.479869784074461},"GJ/t HRC steel",{"$f":"F23*'Assumptions - Today''s Grid'!F24","v":6.2879218704446765E-2},"t CO2e/t HRC steel",null,{"$f":"F23*'Assumptions - Today''s Grid'!I24","v":1.1527856762481907},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F24*'Assumptions - Today''s Grid'!C26","v":4.7184480045281632},"$/t HRC steel",{"$f":"CONVERT(0.23*1000000,\"BTU\",\"GJ\")","v":0.24266284610260003},"GJ/t HRC steel",{"$f":"F24*'Assumptions - Today''s Grid'!F26","v":2.6086255956029501E-2},"t CO2e/t HRC steel",null,{"$f":"F24*'Assumptions - Today''s Grid'!I25","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F25*'Assumptions - Today''s Grid'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F25*'Assumptions - Today''s Grid'!F27","v":0},"t CO2e/t HRC steel",null,{"$f":"F25*'Assumptions - Today''s Grid'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F26*'Assumptions - Today''s Grid'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F26*'Assumptions - Today''s Grid'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F26*'Assumptions - Today''s Grid'!I28","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F27*'Assumptions - Today''s Grid'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F27*'Assumptions - Today''s Grid'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F27*'Assumptions - Today''s Grid'!I29","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F28*'Assumptions - Today''s Grid'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F28*'Assumptions - Today''s Grid'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F28*'Assumptions - Today''s Grid'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F29*'Assumptions - Today''s Grid'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F29*'Assumptions - Today''s Grid'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F29*'Assumptions - Today''s Grid'!I31","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Natural gas",null,null,{"$f":"F32*'Assumptions - Today''s Grid'!C23","v":0.91268661586745725},"$/t HRC steel",{"$f":"CONVERT(0.334*1000000,\"BTU\",\"GJ\")","v":0.35238865477508002},"GJ/t HRC steel",{"$f":"F32*'Assumptions - Today''s Grid'!F23","v":3.87627520252588E-3},"t CO2e/t HRC steel",null,{"$f":"F32*'Assumptions - Today''s Grid'!I23","v":2.3610039869930363E-2},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F33*'Assumptions - Today''s Grid'!C24","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F33*'Assumptions - Today''s Grid'!F24","v":0},"t CO2e/t HRC steel",null,{"$f":"F33*'Assumptions - Today''s Grid'!I24","v":0},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F34*'Assumptions - Today''s Grid'!C26","v":2.2566490456439041},"$/t HRC steel",{"$f":"CONVERT(0.11*1000000,\"BTU\",\"GJ\")","v":0.11605614378820002},"GJ/t HRC steel",{"$f":"F34*'Assumptions - Today''s Grid'!F26","v":1.2476035457231503E-2},"t CO2e/t HRC steel",null,{"$f":"F34*'Assumptions - Today''s Grid'!I26","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F35*'Assumptions - Today''s Grid'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F35*'Assumptions - Today''s Grid'!F27","v":0},"t CO2e/t HRC steel",null,{"$f":"F35*'Assumptions - Today''s Grid'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F36*'Assumptions - Today''s Grid'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F36*'Assumptions - Today''s Grid'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F36*'Assumptions - Today''s Grid'!I28","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F37*'Assumptions - Today''s Grid'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F37*'Assumptions - Today''s Grid'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F37*'Assumptions - Today''s Grid'!I29","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F38*'Assumptions - Today''s Grid'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F38*'Assumptions - Today''s Grid'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F38*'Assumptions - Today''s Grid'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F39*'Assumptions - Today''s Grid'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F39*'Assumptions - Today''s Grid'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F39*'Assumptions - Today''s Grid'!I31","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Ironmaking Step ONLY (Blast Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F42*'Assumptions - Today''s Grid'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F42*SUM(H105:H112)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I14*F42","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F43*'Assumptions - Today''s Grid'!C15","v":456},"$/t HRC steel",4,"t Fe/t HRC steel",{"$f":"F43*SUM(H115:H122)","v":0.20045217155097902},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I15*F43","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F44*'Assumptions - Today''s Grid'!C16","v":25},"$/t HRC steel",{"$f":"0.25*('Assumptions - Today''s Grid'!B15)","v":6.25E-2},"t scrap/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F16*F44","v":1.2500000000000001E-2},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I16*F44","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F45*'Assumptions - Today''s Grid'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F17*F45","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I17*F45","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F46*'Assumptions - Today''s Grid'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F18*F46","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I18*F46","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F47*'Assumptions - Today''s Grid'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F19*F47","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I19*F47","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F48*'Assumptions - Today''s Grid'!C20","v":10.5},"$/t HRC steel",{"$f":"150/2000","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F20*F48","v":8.2499999999999989E-4},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I20*F48","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F51*'Assumptions - Today''s Grid'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F51*SUM(H105:H112)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I14*F51","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F52*'Assumptions - Today''s Grid'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F52*SUM(H115:H122)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I15*F52","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F53*'Assumptions - Today''s Grid'!C16","v":0},"$/t HRC steel",{"$f":"0.25*('Assumptions - Today''s Grid'!B24)","v":0},"t scrap/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F16*F53","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I16*F53","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F54*'Assumptions - Today''s Grid'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F17*F54","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I17*F54","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F55*'Assumptions - Today''s Grid'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F18*F55","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I18*F55","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F56*'Assumptions - Today''s Grid'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F19*F56","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I19*F56","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F57*'Assumptions - Today''s Grid'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F20*F57","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I20*F57","v":0},"t CO2e/t HRC steel"]
[]
["Life Cycle Stages",{"$nulls":4},"Energy Input","Unit"]
["Hot Rolling",null,"Annual. CAPEX",5,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F61*'Assumptions - Today''s Grid'!C23","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F61*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":5.1845444597746801E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F62*'Assumptions - Today''s Grid'!C26","v":14.442553892120989},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F62*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":7.9846626926281625E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F63*'Assumptions - Today''s Grid'!C17","v":0},0,"t/t HRC",{"$f":"F63*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F64*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F64*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F65*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F65*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F66*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F66*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
[]
["Sintering",null,"Annual. CAPEX",2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F69*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F69*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F70*'Assumptions - Today''s Grid'!C26","v":3.1387936725774299},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F70*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":1.7353031135967451E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F71*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F71*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F72*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F72*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F73*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F73*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F74*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F74*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F75*'Assumptions - Today''s Grid'!C24","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F75*('Assumptions - Today''s Grid'!$F$24+'Assumptions - Today''s Grid'!$I$24)","v":0.1349922862310238},"t CO2e/t HRC"]
[]
["Stamping",null,"Annual. CAPEX",2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F78*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F78*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F79*'Assumptions - Today''s Grid'!C26","v":17.642892538670523},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F79*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":9.7539913574719014E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F80*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F80*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F81*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F81*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F82*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F82*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F83*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F83*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill",null,"Annual. CAPEX",1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F86*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F86*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F87*'Assumptions - Today''s Grid'!C26","v":0.86162963560949068},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F87*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":4.7635771745793013E-3},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F88*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F88*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F89*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F89*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F90*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F90*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F91*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F91*'Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29","v":0},"t CO2e/t HRC"]
[]
["EAF"]
["Natural Gas",null,null,null,{"$f":"F94*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F94*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F95*'Assumptions - Today''s Grid'!C26","v":0},0,"GJ/t HRC",{"$f":"F95*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F96*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F96*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F97*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F97*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F98*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F98*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F99*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F99*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F100*'Assumptions - Today''s Grid'!C24","v":0},0,"GJ/t HRC",{"$f":"F100*('Assumptions - Today''s Grid'!$F$24+'Assumptions - Today''s Grid'!$I$24)","v":0},"t CO2e/t HRC"]
["Scrap",null,null,null,{"$f":"F101*'Assumptions - Today''s Grid'!C16","v":0},0,"t/t HRC",{"$f":"F101*('Assumptions - Today''s Grid'!$F$16+'Assumptions - Today''s Grid'!$I$16)","v":0},"t CO2e/t HRC"]
["Iron Ore",null,null,null,{"$f":"F102*'Assumptions - Today''s Grid'!C14","v":0},0,"t/t HRC",{"$f":"F102*'Assumptions - Today''s Grid'!$F$15","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)"]
["Natural Gas",null,null,null,{"$f":"F105*'Assumptions - Today''s Grid'!C23","v":3.5259285913365163E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":1.3613623904774195E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F105*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":1.0618626645723871E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F106*'Assumptions - Today''s Grid'!C26","v":2.6140069590303288},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F106*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":1.4451712626411855E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F107*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F108*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F109*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F110*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F111*'Assumptions - Today''s Grid'!C30","v":1.5806451612903225},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":4.7647683666709684E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*('Assumptions - Today''s Grid'!$F$30+'Assumptions - Today''s Grid'!$I$30)","v":4.3835868973372905E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F112*'Assumptions - Today''s Grid'!C31","v":9.6774193548387108E-2},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":3.4034059761935487E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*('Assumptions - Today''s Grid'!$F$31+'Assumptions - Today''s Grid'!$I$31)","v":3.0970994383361291E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)"]
["Natural Gas",null,null,null,{"$f":"F115*'Assumptions - Today''s Grid'!C23","v":8.7443029065145603E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":3.3761787283840002E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F115*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":2.6334194081395201E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F116*'Assumptions - Today''s Grid'!C26","v":6.4827372583952139},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F116*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":3.5840247313501397E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F117*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F117*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F118*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F118*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F119*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F120*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F121*'Assumptions - Today''s Grid'!C31","v":3.3600000000000003},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":0.11816625549344001},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*('Assumptions - Today''s Grid'!$F$30+'Assumptions - Today''s Grid'!$I$30)","v":1.0871295505396481E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F122*'Assumptions - Today''s Grid'!C32","v":0},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":8.4404468209600004E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*('Assumptions - Today''s Grid'!$F$31+'Assumptions - Today''s Grid'!$I$31)","v":7.6808066070736E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Assumptions - Low-C Elec","index":4,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Assumptions"]
["Instructions: Standard assumptions are provided below; do not change them. To add alternate assumptions, feel free to insert as many rows as needed per section (see 'Alternate inputs (applicant-added) green rows)."]
["Input Variable",null,"Value","Cost Units",null,"Value","Non-biogenic Embodied Emissions Unit",null,"Value","Non-biogenic Process Emissions (i.e. chemical or combustion)","Cost Reference","Emissions Reference","Justification for Changes"]
[]
["Operational Assumptions"]
["Equipment availability",null,95,"%",{"$nulls":6},"IEA Iron & Steel Roadmap, Oct. 2020 (IEA, 2020) Fig 1.3","n/a"]
["Equipment lifetime",null,25,"years",{"$nulls":6},"IEA, 2020 Fig 1.3","n/a"]
["Cost of capital",null,8,"%",{"$nulls":6},"IEA, 2020 Fig 1.3","n/a"]
["Capital recovery factor (CRF)",null,{"$f":"(C8/100*(1+C8/100)^C7)/((1+C8/100)^C7-1)","v":9.3678779051968114E-2},{"$nulls":7},"Calculated from above","n/a"]
["Carbon capture rate",null,90,"%",{"$nulls":6},"climate.mit.edu/ask-mit/how-efficient-carbon-capture-and-storage","n/a"]
["On-site Hydrogen Electrolyzer Energy Consumpition",null,52,"kWh/kg H2"]
[]
["Feedstock Assumptions","%Fe"]
["Iron ore fines (imported)",0.62,106,"$/tonne Fe",null,{"$f":"'Assumptions - Today''s Grid'!F14","v":2.0206872132155145E-2},"t CO2e/t Fe",null,0,"t CO2e/t Fe","USGS Mineral Yearbook 2021","GREET2 2022 Iron Ore Extraction & Processing on Steel Sheet"]
["Iron ore fines (US - Taconite)",0.25,114,"$/tonne Fe",null,{"$f":"SUM('Your Tech - Low-C Elec'!H117:H124)","v":2.0755527646452918E-2},"t CO2e/t Fe",null,0,"t CO2e/t Fe","Internal estimate","ARPA-E estimations; assume fines on average see ~50% of beneficiation processes at mine, transported 400 miles by long haul truck and 400 miles by rail"]
["Scrap",0.98,400,"$/tonne Fe",null,0.2,"t CO2e/t Fe",null,0,"t CO2e/t Fe","IEA, 2020 Fig 1.3","Ashby, Michael F. 'Materials and the Environment: Eco-informed Material Choice', Butterworth Heinemann, 2009. 2nd Edition 2012 ISBN 9780123859716"]
["Biomass",null,3.7,"$/GJ",null,7.0000000000000007E-2,"t CO2e/t dry biomass",null,0,"t CO2e/t dry biomass","Assume $60/dry ton from 2016 Billion Ton Study and ~18 MJ/kg","GREET2020: poplar combined feedstock emissions"]
["Biocharcoal",null,300,"tonne",null,{"$f":"AVERAGE((19.38+0.67+18.39+1.34),(21.76+12.03+1.34+1.34))/1000+0.0308","v":6.8925E-2},"t CO2e/t biocharcoal",null,0,"t CO2e / t biocharcoal",null,"Page 24 and Appendices 5 and 6 of \"Life Cycle Assessment and Carbon Footprint for the Production of Biochar as an Alternative of Soil Remediation,\" Alfonso R. Rodriguez, 2013"]
["Electrolysis Hydrogen",null,2,"$/kg H2",null,{"$f":"C11*F26/1000","v":3.64},"kg CO2/kg H2",null,0,"t CO2e/t H2","Internal projection","Electrolysis H2 embodied emissions from grid intensity assumption. Assume 52 kWh/kg H2 for electrolysis, purification, separation, compression, conveyance."]
["Lime",null,140,"$/tonne lime",null,1.0999999999999999E-2,"t CO2e/t lime",null,0,"t CO2e/t lime","Assume quicklime https://pubs.usgs.gov/periodicals/mcs2022/mcs2022-lime.pdf","All emissions are embedded for the material"]
["Alternate Inputs (user-added) start here"]
[]
["Fuel Assumptions"]
["Natural gas",null,2.59,"$/GJ",null,1.0999999999999999E-2,"t CO2e/GJ LHV",null,6.7000000000000004E-2,"t CO2e/GJ LHV","Internal projection for 2050","Natural gas process emissions if fully combusted; GREET2020"]
["Coke",null,2.39,"$/GJ",null,6.0000000000000001E-3,"t CO2e/GJ",null,0.11,"t CO2e/GJ","Internal estimate","Coke/coal process emissions if fully combusted; Coal to coking plants GREET2020. Use combustion emissions only if not using blast furnace/coke oven gas downstream."]
["Electricity",null,0.03,"$/kWh",null,70,"g CO2e/kWh",null,0,"g CO2e/kWh","Internal renewable mix of PV solar and wind (approximately 90%) and 10% NGCC. Cis of each taken from GREET1 2022.","Assume ~90% reduction from 2020 national average grid using solar and wind"]
["Electricity",null,{"$f":"C26*277.778","v":8.3333399999999997},"$/GJ",null,{"$f":"F26/1000000/0.0036","v":1.9444444444444445E-2},"t CO2e/GJ",null,0,"t CO2e/GJ","Equivalent values to row 25; given here in alternate units","Assume ~90% reduction from 2020 national average grid using solar and wind"]
["Fossil SMR Hydrogen (US)",null,16.7,"$/GJ",null,9.5000000000000001E-2,"t CO2e/GJ",null,0,"t CO2e/GJ",null,"GREET 2022 plus leakage rate for Iron & Steel from (REF) and indirect GWP of H2 gas from (REFs)"]
["Fossil SMR+CCS Hydrogen (US)",null,25,"$/GJ",null,4.4999999999999998E-2,"t CO2e/GJ",null,0,"t CO2e/GJ",null,"GREET 2022 plus leakage rate for Iron & Steel from (REF) and indirect GWP of H2 gas from (REFs)"]
["Electrolysis Hydrogen (US)",null,{"$f":"C19/120*1000","v":16.666666666666668},"$/GJ",null,{"$f":"C11*F26/120/1000","v":3.0333333333333334E-2},"t CO2e/GJ",null,0,"t CO2e/GJ","Assume 120 MJ/kg LHV"]
["Fossil Diesel",null,{"$f":"35*CONVERT(1,\"GJ\",\"BTU\")/1000000","v":33.173599210966096},"$/GJ",null,1.6E-2,"t CO2e/GJ",null,7.5999999999999998E-2,"t CO2e/GJ",null,"GREET 2022 conventional fossil diesel"]
["Fossil Gasoline",null,{"$f":"30*CONVERT(1,\"GJ\",\"BTU\")/1000000","v":28.434513609399517},"$/GJ",null,1.7999999999999999E-2,"t CO2e/GJ",null,7.2999999999999995E-2,"t CO2e/GJ"]
["Alternate Inputs (user-added) start here"]
[]
["Transportation Assumptions",{"$nulls":10},"Note: all emissions associated with construction, maintenance, and dispoal of transport vehicles as well as production of the fuels are all aggregated into the numbers in column I"]
["Shipping solids worldwide (ocean)",null,0.02,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"6.95/1000000","v":6.9500000000000004E-6},"tonne CO2e/tonne-mile freight","https://www.steelonthenet.com/freight.html","GREET2020; Sea transit HFO (0.5% S fuel). "]
["Rail",null,0.03,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"41.3/1000000","v":4.1299999999999994E-5},"tonne CO2e/tonne-mile freight","Trains Magazine, https://cs.trains.com/trn/f/111/p/187338/2048866.aspx#:~:text=The%20average%20rate%20per%20ton-mile%20%28one%20ton%20of,year%202009%2C%20the%20average%20rate%20was%203.011%20cents.","GREET 2020; diesel rail"]
["Truck",null,0.06,"$/tonne-mile",null,0,"tonne CO2e/tonne-mile freight",null,{"$f":"114.5/1000000","v":1.145E-4},"tonne CO2e/tonne-mile freight","Internal estimate","GREET 2020; long haul diesel trucking (assumed payload of 19.1 U.S. short tons)"]
["Alternate Inputs (user-added) start here"]
[]
[]
["BF-BOF Assumptions"]
["BF-BOF (tot upfront cost)",null,600,"$/t crude steel"]
["BF-BOF (annualized)",null,{"$f":"C43*C9/(C6*0.01)","v":59.165544664400912},"$/t crude steel"]
[]
[]
["EAF Assumptions"]
["Electric arc furnace (tot upfront cost)",null,310,"$/tonne HRC"]
["Electric arc furnace (annualized)",null,{"$f":"C48*C9/(C6*0.01)","v":30.568864743273803},"$/tonne HRC",{"$nulls":7},"Internal calcs; assumes state-of-art NG and solid carbon fuels inserted"]

{"sheet":"Your Tech - Today's Grid","index":5,"n_rows":124,"n_cols":16384,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["Your Tech, Standard Case (user to fill in using values from Standard Assumptions in Assumptions tab as needed)"]
["Input Variable",null,null,"Value","Cost Units","Value","Amount/t crude steel","Value","Embedded emissions",null,"Value","Process emissions","Justification for Changes"]
[]
["Capital Equipment, Ironmaking"]
["Capital Equipment (tot upfront cost)",null,null,500,"$/t crude steel"]
["Cap Equip Annualized",null,null,{"$f":"D5*100*'Assumptions - Today''s Grid'!C9/'Assumptions - Today''s Grid'!C6","v":49.304620553667434},"$/t crude steel"]
[]
["On-Site Operations"]
["Ironmaking",null,null,{"$f":"0.085*D5","v":42.5},"$/t HRC"]
["Sintering",null,null,{"$f":"D70+SUM(E71:E77)","v":7.920100259578696},"$/t HRC",{"$nulls":5},{"$f":"SUM(H71:H77)","v":0.15234531736699125},"t CO2e/t HRC steel",{"$nulls":16371},"BF + BOF"]
["Hot Rolling",null,null,{"$f":"D62+SUM(E63:E68)","v":21.164088526841041},"$/t HRC",{"$nulls":5},{"$f":"SUM(H63:H68)","v":0.13169207152402843},"t CO2e/t HRC steel",{"$nulls":16371},"Sintering"]
["Stamping",null,null,{"$f":"D79+SUM(E80:E85)","v":19.642892538670523},"$/t HRC",{"$nulls":5},{"$f":"SUM(H80:H85)","v":9.7539913574719014E-2},"t CO2e/t HRC steel",{"$nulls":16371},"Hot Rolling"]
["Skin Mill",null,null,{"$f":"D87+SUM(E88:E93)","v":1.8616296356094906},"$/t HRC",{"$nulls":5},{"$f":"SUM(H88:H93)","v":4.7635771745793013E-3},"t CO2e/t HRC steel",{"$nulls":16371},"Stamping"]
[{"$nulls":16383},"Skin Mill"]
[]
["Transportation","Distance (mi)"]
["Water",0,null,{"$f":"B17*'Assumptions - Today''s Grid'!$C$34*F17","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*'Assumptions - Today''s Grid'!$I$34*B17","v":0},"t CO2e/t HRC steel"]
["Rail",700,null,{"$f":"B18*'Assumptions - Today''s Grid'!$C$35*F18","v":63},"$/t HRC steel",3,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*'Assumptions - Today''s Grid'!$I$35*B18","v":8.6729999999999988E-2},"t CO2e/t HRC steel"]
["Truck",100,null,{"$f":"B19*'Assumptions - Today''s Grid'!$C$36*F19","v":18},"$/t HRC steel",3,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F19*'Assumptions - Today''s Grid'!$I$36*B19","v":3.4349999999999999E-2},"t CO2e/t HRC steel"]
[]
[]
["Energy Inputs to Ironmaking Step ONLY (New Tech)"]
["Natural gas",null,null,{"$f":"F23*'Assumptions - Today''s Grid'!C23","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F23*'Assumptions - Today''s Grid'!F23","v":0},"t CO2e/t HRC steel",null,{"$f":"F23*'Assumptions - Today''s Grid'!I23","v":0},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F24*'Assumptions - Today''s Grid'!C24","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F24*'Assumptions - Today''s Grid'!F24","v":0},"t CO2e/t HRC steel",null,{"$f":"F24*'Assumptions - Today''s Grid'!I24","v":0},"t CO2e/t HRC steel"]
["Electricity ",null,null,{"$f":"F25*'Assumptions - Today''s Grid'!C26","v":196.00015680000004},"$/t HRC steel",{"$f":"CONVERT(2800,\"kWh\",\"GJ\")","v":10.08},"GJ/t HRC steel",{"$f":"F25*'Assumptions - Today''s Grid'!F26","v":1.0835999999999999},"t CO2e/t HRC steel",null,{"$f":"F25*'Assumptions - Today''s Grid'!I26","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F26*'Assumptions - Today''s Grid'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F26*'Assumptions - Today''s Grid'!F27","v":0},"t CO2e/t HRC steel",null,{"$f":"F26*'Assumptions - Today''s Grid'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F27*'Assumptions - Today''s Grid'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F27*'Assumptions - Today''s Grid'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F27*'Assumptions - Today''s Grid'!I28","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F28*'Assumptions - Today''s Grid'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F28*'Assumptions - Today''s Grid'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F28*'Assumptions - Today''s Grid'!I29","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F29*'Assumptions - Today''s Grid'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F29*'Assumptions - Today''s Grid'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F29*'Assumptions - Today''s Grid'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F30*'Assumptions - Today''s Grid'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F30*'Assumptions - Today''s Grid'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F30*'Assumptions - Today''s Grid'!I31","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F31*'Assumptions - Today''s Grid'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F31*'Assumptions - Today''s Grid'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F31*'Assumptions - Today''s Grid'!I32","v":0},"t CO2e/t HRC steel"]
[]
[]
["Feedstocks to Ironmaking Step ONLY (New Tech)"]
["Iron ore fines (imported)",null,null,{"$f":"F35*'Assumptions - Today''s Grid'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F35*SUM(H107:H114)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I14*F35","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F36*'Assumptions - Today''s Grid'!C15","v":342},"$/t HRC steel",{"$f":"0.75*(1/('Assumptions - Today''s Grid'!B15))","v":3},"t Fe/t HRC steel",{"$f":"F36*SUM(H117:H124)","v":0.15033912866323426},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I15*F36","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F37*'Assumptions - Today''s Grid'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F17*F37","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I17*F37","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F38*'Assumptions - Today''s Grid'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F18*F38","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I18*F38","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F39*'Assumptions - Today''s Grid'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F19*F39","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I19*F39","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F40*'Assumptions - Today''s Grid'!C20","v":10.5},"$/t HRC steel",{"$f":"150/2000","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F20*F40","v":8.2499999999999989E-4},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I20*F40","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F41*'Assumptions - Today''s Grid'!C21","v":0},"$/t HRC steel",0,"t/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F21*F41","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I21*F41","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (EAF)"]
["Natural Gas",null,null,{"$f":"F44*'Assumptions - Today''s Grid'!C23","v":1.2815868947360403},"$/t HRC steel",{"$f":"F96","v":0.49482119487878001},"GJ/t HRC",{"$f":"F44*('Assumptions - Today''s Grid'!F23)","v":5.4430331436665794E-3},"t CO2e/t HRC",null,{"$f":"F44*('Assumptions - Today''s Grid'!I23)","v":3.3153020056878264E-2},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F45*'Assumptions - Today''s Grid'!C24","v":0.42866919291950611},"$/t HRC steel",{"$f":"F102","v":0.17935949494540004},"GJ/t HRC",{"$f":"F45*('Assumptions - Today''s Grid'!F24)","v":1.0761569696724003E-3},"t CO2e/t HRC",null,{"$f":"F45*('Assumptions - Today''s Grid'!I24)","v":1.9729544443994006E-2},"t CO2e/t HRC steel"]
["Electricity",null,null,{"$f":"F46*'Assumptions - Today''s Grid'!C26","v":31.387936725774306},"$/t HRC steel",{"$f":"F97","v":1.6142354545086004},"GJ/t HRC",{"$f":"F46*('Assumptions - Today''s Grid'!F26)","v":0.17353031135967453},"t CO2e/t HRC",null,{"$f":"F46*('Assumptions - Today''s Grid'!I26)","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen",null,null,{"$f":"F47*'Assumptions - Today''s Grid'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F47*('Assumptions - Today''s Grid'!F27)","v":0},"t CO2e/t HRC",null,{"$f":"F47*('Assumptions - Today''s Grid'!I27)","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen",null,null,{"$f":"F48*'Assumptions - Today''s Grid'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F48*('Assumptions - Today''s Grid'!F28)","v":0},"t CO2e/t HRC",null,{"$f":"F48*('Assumptions - Today''s Grid'!I28)","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F49*'Assumptions - Today''s Grid'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F49*('Assumptions - Today''s Grid'!F29)","v":0},"t CO2e/t HRC",null,{"$f":"F49*('Assumptions - Today''s Grid'!I29)","v":0},"t CO2e/t HRC steel"]
[]
["Additional Feedstocks to Steelmaking Step ONLY (EAF)"]
["Iron ore fines (imported)",null,null,{"$f":"F52*'Assumptions - Today''s Grid'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F52*SUM(H107:H114)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I13*F52","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F53*'Assumptions - Today''s Grid'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F53*SUM(H117:H124)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I14*F53","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F54*'Assumptions - Today''s Grid'!C16","v":101.6},"$/t HRC steel",{"$f":"F103","v":0.254},"t scrap/t HRC steel",{"$f":"F54*'Assumptions - Today''s Grid'!F16","v":5.0800000000000005E-2},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I15*F54","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F55*'Assumptions - Today''s Grid'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F16*F55","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I16*F55","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F56*'Assumptions - Today''s Grid'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F17*F56","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I17*F56","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F57*'Assumptions - Today''s Grid'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F18*F57","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I18*F57","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F58*'Assumptions - Today''s Grid'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F19*F58","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I19*F58","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F59*'Assumptions - Today''s Grid'!C21","v":0},"$/t HRC steel",0,"t/t HRC steel",{"$f":"'Assumptions - Today''s Grid'!F20*F59","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Today''s Grid'!I20*F59","v":0},"t CO2e/t HRC steel"]
[]
["Life Cycle Stages",{"$nulls":4},"Energy Input","Unit"]
["Hot Rolling",null,null,5,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F63*'Assumptions - Today''s Grid'!C23","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F63*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":5.1845444597746801E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F64*'Assumptions - Today''s Grid'!C26","v":14.442553892120989},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F64*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":7.9846626926281625E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F65*'Assumptions - Today''s Grid'!C17","v":0},0,"t/t HRC",{"$f":"F65*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F66*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F66*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F67*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F67*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F68*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F68*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
[]
["Sintering",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F71*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F71*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F72*'Assumptions - Today''s Grid'!C26","v":3.1387936725774299},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F72*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":1.7353031135967451E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F73*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F73*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F74*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F74*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F75*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F75*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F76*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F76*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F77*'Assumptions - Today''s Grid'!C24","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F77*('Assumptions - Today''s Grid'!$F$24+'Assumptions - Today''s Grid'!$I$24)","v":0.1349922862310238},"t CO2e/t HRC"]
[]
["Stamping",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F80*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F80*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F81*'Assumptions - Today''s Grid'!C26","v":17.642892538670523},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F81*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":9.7539913574719014E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F82*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F82*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F83*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F83*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F84*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F84*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F85*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F85*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill",null,null,1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F88*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F88*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F89*'Assumptions - Today''s Grid'!C26","v":0.86162963560949068},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F89*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":4.7635771745793013E-3},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F90*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F90*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F91*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F91*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F92*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F92*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F93*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F93*'Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29","v":0},"t CO2e/t HRC"]
[]
["EAF",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F96*'Assumptions - Today''s Grid'!C23","v":1.2815868947360403},0.49482119487878001,"GJ/t HRC",{"$f":"F96*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":3.8596053200544843E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F97*'Assumptions - Today''s Grid'!C26","v":31.387936725774306},1.6142354545086004,"GJ/t HRC",{"$f":"F97*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":0.17353031135967453},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F98*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F98*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F99*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F99*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F100*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F100*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F101*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F101*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F102*'Assumptions - Today''s Grid'!C24","v":0.42866919291950611},0.17935949494540004,"GJ/t HRC",{"$f":"F102*('Assumptions - Today''s Grid'!$F$24+'Assumptions - Today''s Grid'!$I$24)","v":2.0805701413666406E-2},"t CO2e/t HRC"]
["Scrap",null,null,null,{"$f":"F103*'Assumptions - Today''s Grid'!C16","v":101.6},0.254,"t/t HRC",{"$f":"F103*('Assumptions - Today''s Grid'!$F$16+'Assumptions - Today''s Grid'!$I$16)","v":5.0800000000000005E-2},"t CO2e/t HRC"]
["Iron Ore",null,null,null,{"$f":"F104*'Assumptions - Today''s Grid'!C14","v":0},0,"t/t HRC",{"$f":"F104*'Assumptions - Today''s Grid'!$F$15","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F107*'Assumptions - Today''s Grid'!C23","v":3.5259285913365163E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":1.3613623904774195E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":1.0618626645723871E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F108*'Assumptions - Today''s Grid'!C26","v":2.6140069590303288},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":1.4451712626411855E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F109*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F110*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F111*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F112*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F113*'Assumptions - Today''s Grid'!C30","v":1.5806451612903225},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":4.7647683666709684E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F113*('Assumptions - Today''s Grid'!$F$30+'Assumptions - Today''s Grid'!$I$30)","v":4.3835868973372905E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F114*'Assumptions - Today''s Grid'!C31","v":9.6774193548387108E-2},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$14","v":3.4034059761935487E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F114*('Assumptions - Today''s Grid'!$F$31+'Assumptions - Today''s Grid'!$I$31)","v":3.0970994383361291E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F117*'Assumptions - Today''s Grid'!C23","v":8.7443029065145603E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":3.3761787283840002E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F117*('Assumptions - Today''s Grid'!$F$23+'Assumptions - Today''s Grid'!$I$23)","v":2.6334194081395201E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F118*'Assumptions - Today''s Grid'!C26","v":6.4827372583952139},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F118*('Assumptions - Today''s Grid'!$F$26+'Assumptions - Today''s Grid'!$I$26)","v":3.5840247313501397E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F119*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*('Assumptions - Today''s Grid'!$F$17+'Assumptions - Today''s Grid'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F120*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*('Assumptions - Today''s Grid'!$F$27+'Assumptions - Today''s Grid'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F121*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*('Assumptions - Today''s Grid'!$F$28+'Assumptions - Today''s Grid'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F122*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*('Assumptions - Today''s Grid'!$F$29+'Assumptions - Today''s Grid'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F123*'Assumptions - Today''s Grid'!C30","v":3.9199999999999995},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":0.11816625549344001},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F123*('Assumptions - Today''s Grid'!$F$30+'Assumptions - Today''s Grid'!$I$30)","v":1.0871295505396481E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F124*'Assumptions - Today''s Grid'!C31","v":0.24000000000000002},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Today''s Grid'!$B$15","v":8.4404468209600004E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F124*('Assumptions - Today''s Grid'!$F$31+'Assumptions - Today''s Grid'!$I$31)","v":7.6808066070736E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Your Tech - Low-C Elec","index":6,"n_rows":124,"n_cols":16384,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["Your Tech, Standard Case (user to fill in using values from Standard Assumptions in Assumptions tab as needed)"]
["Input Variable",null,null,"Value","Cost Units","Value","Amount/t crude steel","Value","Embedded emissions",null,"Value","Process emissions","Justification for Changes"]
[]
["Capital Equipment, Ironmaking"]
["Capital Equipment (tot upfront cost)",null,null,{"$f":"'Your Tech - Today''s Grid'!D5","v":500},"$/t crude steel"]
["Cap Equip Annualized",null,null,{"$f":"'Your Tech - Today''s Grid'!D6","v":49.304620553667434},"$/t crude steel"]
[]
["On-Site Operations"]
["Ironmaking",null,null,{"$f":"0.085*D5","v":42.5},"$/t HRC"]
["Sintering",null,null,{"$f":"D70","v":2},"$/t HRC",{"$nulls":5},{"$f":"SUM(H71:H77)","v":0.1381310773925683},"t CO2e/t HRC steel",{"$nulls":16371},"BF + BOF"]
["Hot Rolling",null,null,{"$f":"D62","v":5},"$/t HRC",{"$nulls":5},{"$f":"SUM(H63:H68)","v":6.6287986935833917E-2},"t CO2e/t HRC steel",{"$nulls":16371},"Sintering"]
["Stamping",null,null,{"$f":"D79","v":2},"$/t HRC",{"$nulls":5},{"$f":"SUM(H80:H85)","v":1.7642878424367781E-2},"t CO2e/t HRC steel",{"$nulls":16371},"Hot Rolling"]
["Skin Mill",null,null,{"$f":"D87","v":1},"$/t HRC",{"$nulls":5},{"$f":"SUM(H88:H93)","v":8.6162894630633356E-4},"t CO2e/t HRC steel",{"$nulls":16371},"Stamping"]
[{"$nulls":16383},"Skin Mill"]
[]
["Transportation of Ore","Distance (mi)"]
["Water",{"$f":"'Your Tech - Today''s Grid'!B17","v":0},null,{"$f":"B17*'Assumptions - Low-C Elec'!$C$36*F17","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F17","v":0},"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*'Assumptions - Low-C Elec'!$I$36*B17","v":0},"t CO2e/t HRC steel"]
["Rail",{"$f":"'Your Tech - Today''s Grid'!B18","v":700},null,{"$f":"B18*'Assumptions - Low-C Elec'!$C$37*F18","v":63},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F18","v":3},"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*'Assumptions - Low-C Elec'!$I$37*B18","v":8.6729999999999988E-2},"t CO2e/t HRC steel"]
["Truck",{"$f":"'Your Tech - Today''s Grid'!B19","v":100},null,{"$f":"B19*'Assumptions - Low-C Elec'!$C$38*F19","v":18},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F19","v":3},"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F19*'Assumptions - Low-C Elec'!$I$38*B19","v":3.4349999999999999E-2},"t CO2e/t HRC steel"]
[]
[]
["Energy Inputs to Ironmaking Step ONLY (New Tech)"]
["Natural gas",null,null,{"$f":"F23*'Assumptions - Low-C Elec'!C24","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F23","v":0},"GJ/t HRC steel",{"$f":"F23*'Assumptions - Low-C Elec'!F24","v":0},"t CO2e/t HRC steel",null,{"$f":"F23*'Assumptions - Low-C Elec'!I24","v":0},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F24*'Assumptions - Low-C Elec'!C25","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F24","v":0},"GJ/t HRC steel",{"$f":"F24*'Assumptions - Low-C Elec'!F25","v":0},"t CO2e/t HRC steel",null,{"$f":"F24*'Assumptions - Low-C Elec'!I25","v":0},"t CO2e/t HRC steel"]
["Electricity ",null,null,{"$f":"F25*'Assumptions - Low-C Elec'!C27","v":84.000067200000004},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F25","v":10.08},"GJ/t HRC steel",{"$f":"F25*'Assumptions - Low-C Elec'!F27","v":0.19600000000000001},"t CO2e/t HRC steel",null,{"$f":"F25*'Assumptions - Low-C Elec'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F26*'Assumptions - Low-C Elec'!C28","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F26","v":0},"GJ/t HRC steel",{"$f":"F26*'Assumptions - Low-C Elec'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F26*'Assumptions - Low-C Elec'!I28","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F27*'Assumptions - Low-C Elec'!C29","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F27","v":0},"GJ/t HRC steel",{"$f":"F27*'Assumptions - Low-C Elec'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F27*'Assumptions - Low-C Elec'!I29","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F28*'Assumptions - Low-C Elec'!C30","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F28","v":0},"GJ/t HRC steel",{"$f":"F28*'Assumptions - Low-C Elec'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F28*'Assumptions - Low-C Elec'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F29*'Assumptions - Low-C Elec'!C31","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F29","v":0},"GJ/t HRC steel",{"$f":"F29*'Assumptions - Low-C Elec'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F29*'Assumptions - Low-C Elec'!I31","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F30*'Assumptions - Low-C Elec'!C32","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F30","v":0},"GJ/t HRC steel",{"$f":"F30*'Assumptions - Low-C Elec'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F30*'Assumptions - Low-C Elec'!I32","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F31*'Assumptions - Low-C Elec'!C33","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F31","v":0},"GJ/t HRC steel",{"$f":"F31*'Assumptions - Low-C Elec'!F34","v":0},"t CO2e/t HRC steel",null,{"$f":"F31*'Assumptions - Low-C Elec'!I34","v":0},"t CO2e/t HRC steel"]
[]
[]
["Feedstocks to Ironmaking Step ONLY (New Tech)"]
["Iron ore fines (imported)",null,null,{"$f":"F35*'Assumptions - Low-C Elec'!C14","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F35","v":0},"t Fe/t HRC steel",{"$f":"SUM(H107:H114)*F35","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I14*F35","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F36*'Assumptions - Low-C Elec'!C15","v":342},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F36","v":3},"t Fe/t HRC steel",{"$f":"SUM(H117:H124)*F36","v":6.2266582939358758E-2},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I15*F36","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F37*'Assumptions - Low-C Elec'!C16","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F37","v":0},"t biomass/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F17*F37","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I17*F37","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F38*'Assumptions - Low-C Elec'!C17","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F38","v":0},"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F18*F38","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I18*F38","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F39*'Assumptions - Low-C Elec'!C18","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F39","v":0},"t H2/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F19*F39","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I19*F39","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F40*'Assumptions - Low-C Elec'!C19","v":0.15},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F40","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F20*F40","v":8.2499999999999989E-4},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I20*F40","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F41*'Assumptions - Low-C Elec'!C20","v":0},"$/t HRC steel",{"$f":"'Your Tech - Today''s Grid'!F41","v":0},"t/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F21*F41","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I21*F41","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (EAF)"]
["Natural Gas",null,null,{"$f":"F44*'Assumptions - Low-C Elec'!C24","v":1.2815868947360403},"$/t HRC steel",{"$f":"F96","v":0.49482119487878001},"GJ/t HRC",{"$f":"F44*('Assumptions - Low-C Elec'!F24)","v":5.4430331436665794E-3},"t CO2e/t HRC",null,{"$f":"F44*('Assumptions - Low-C Elec'!I24)","v":3.3153020056878264E-2},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F45*'Assumptions - Low-C Elec'!C25","v":0.42866919291950611},"$/t HRC steel",{"$f":"F102","v":0.17935949494540004},"GJ/t HRC",{"$f":"F45*('Assumptions - Low-C Elec'!F25)","v":1.0761569696724003E-3},"t CO2e/t HRC",null,{"$f":"F45*('Assumptions - Low-C Elec'!I25)","v":1.9729544443994006E-2},"t CO2e/t HRC steel"]
["Electricity",null,null,{"$f":"F46*'Assumptions - Low-C Elec'!C27","v":13.451972882474699},"$/t HRC steel",{"$f":"F97","v":1.6142354545086004},"GJ/t HRC",{"$f":"F46*('Assumptions - Low-C Elec'!F27)","v":3.1387911615445005E-2},"t CO2e/t HRC",null,{"$f":"F46*('Assumptions - Low-C Elec'!I27)","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen",null,null,{"$f":"F47*'Assumptions - Low-C Elec'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F47*('Assumptions - Low-C Elec'!F28)","v":0},"t CO2e/t HRC",null,{"$f":"F47*('Assumptions - Low-C Elec'!I28)","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen",null,null,{"$f":"F48*'Assumptions - Low-C Elec'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F48*('Assumptions - Low-C Elec'!F29)","v":0},"t CO2e/t HRC",null,{"$f":"F48*('Assumptions - Low-C Elec'!I29)","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F49*'Assumptions - Low-C Elec'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"F49*('Assumptions - Low-C Elec'!F30)","v":0},"t CO2e/t HRC",null,{"$f":"F49*('Assumptions - Low-C Elec'!I30)","v":0},"t CO2e/t HRC steel"]
[]
["Additional Feedstocks to Steelmaking Step ONLY (EAF)"]
["Iron ore fines (imported)",null,null,{"$f":"F52*'Assumptions - Low-C Elec'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F13*F52","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I13*F52","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F53*'Assumptions - Low-C Elec'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F14*F53","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I14*F53","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F54*'Assumptions - Low-C Elec'!C16","v":101.6},"$/t HRC steel",{"$f":"F103","v":0.254},"t scrap/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F15*F54","v":5.2719040221990412E-3},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I15*F54","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F55*'Assumptions - Low-C Elec'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F16*F55","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I16*F55","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F56*'Assumptions - Low-C Elec'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F17*F56","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I17*F56","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F57*'Assumptions - Low-C Elec'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F18*F57","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I18*F57","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F58*'Assumptions - Low-C Elec'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F19*F58","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I19*F58","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,null,{"$f":"F59*'Assumptions - Low-C Elec'!C21","v":0},"$/t HRC steel",0,"t/t HRC steel",{"$f":"'Assumptions - Low-C Elec'!F20*F59","v":0},"t CO2e/t HRC steel",null,{"$f":"'Assumptions - Low-C Elec'!I20*F59","v":0},"t CO2e/t HRC steel"]
[]
["Life Cycle Stages",{"$nulls":4},"Energy Input","Unit"]
["Hot Rolling",null,null,5,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F63*'Assumptions - Today''s Grid'!C23","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F63*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":5.1845444597746801E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F64*'Assumptions - Today''s Grid'!C26","v":14.442553892120989},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F64*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":1.4442542338087115E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F65*'Assumptions - Today''s Grid'!C17","v":0},0,"t/t HRC",{"$f":"F65*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F66*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F66*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F67*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F67*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F68*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F68*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
[]
["Sintering",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F71*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F71*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F72*'Assumptions - Today''s Grid'!C26","v":3.1387936725774299},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F72*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":3.1387911615445006E-3},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F73*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F73*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F74*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F74*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F75*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F75*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F76*'Assumptions - Today''s Grid'!C30","v":0},0,"GJ/t HRC",{"$f":"F76*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F77*'Assumptions - Today''s Grid'!C24","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F77*('Assumptions - Low-C Elec'!$F$25+'Assumptions - Low-C Elec'!$I$25)","v":0.1349922862310238},"t CO2e/t HRC"]
[]
["Stamping",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F80*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F80*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F81*'Assumptions - Today''s Grid'!C26","v":17.642892538670523},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F81*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":1.7642878424367781E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F82*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F82*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F83*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F83*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F84*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F84*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F85*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F85*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill",null,null,1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F88*'Assumptions - Today''s Grid'!C23","v":0},0,"GJ/t HRC",{"$f":"F88*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F89*'Assumptions - Today''s Grid'!C26","v":0.86162963560949068},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F89*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":8.6162894630633356E-4},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F90*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F90*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F91*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F91*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F92*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F92*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F93*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F93*'Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30","v":0},"t CO2e/t HRC"]
[]
["EAF",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F96*'Assumptions - Today''s Grid'!C23","v":1.2815868947360403},0.49482119487878001,"GJ/t HRC",{"$f":"F96*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":3.8596053200544843E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F97*'Assumptions - Today''s Grid'!C26","v":31.387936725774306},1.6142354545086004,"GJ/t HRC",{"$f":"F97*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":3.1387911615445005E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F98*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t HRC",{"$f":"F98*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F99*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t HRC",{"$f":"F99*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F100*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t HRC",{"$f":"F100*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F101*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t HRC",{"$f":"F101*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F102*'Assumptions - Today''s Grid'!C24","v":0.42866919291950611},0.17935949494540004,"GJ/t HRC",{"$f":"F102*('Assumptions - Low-C Elec'!$F$25+'Assumptions - Low-C Elec'!$I$25)","v":2.0805701413666406E-2},"t CO2e/t HRC"]
["Scrap",null,null,null,{"$f":"F103*'Assumptions - Today''s Grid'!C16","v":101.6},0.254,"t/t HRC",{"$f":"F103*('Assumptions - Today''s Grid'!$F$16+'Assumptions - Today''s Grid'!$I$16)","v":5.0800000000000005E-2},"t CO2e/t HRC"]
["Iron Ore",null,null,null,{"$f":"F104*'Assumptions - Today''s Grid'!C14","v":0},0,"t/t HRC",{"$f":"F104*'Assumptions - Today''s Grid'!$F$15","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F107*'Assumptions - Today''s Grid'!C23","v":3.5259285913365163E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":1.3613623904774195E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":1.0618626645723871E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F108*'Assumptions - Today''s Grid'!C26","v":2.6140069590303288},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":2.614004867826434E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F109*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F110*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F111*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F112*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F113*'Assumptions - Today''s Grid'!C30","v":1.5806451612903225},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":4.7647683666709684E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F113*('Assumptions - Low-C Elec'!$F$31+'Assumptions - Low-C Elec'!$I$31)","v":4.3835868973372905E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F114*'Assumptions - Today''s Grid'!C31","v":9.6774193548387108E-2},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$14","v":3.4034059761935487E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F114*('Assumptions - Low-C Elec'!$F$32+'Assumptions - Low-C Elec'!$I$32)","v":3.0970994383361291E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F117*'Assumptions - Today''s Grid'!C23","v":8.7443029065145603E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":3.3761787283840002E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F117*('Assumptions - Low-C Elec'!$F$24+'Assumptions - Low-C Elec'!$I$24)","v":2.6334194081395201E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F118*'Assumptions - Today''s Grid'!C26","v":6.4827372583952139},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F118*('Assumptions - Low-C Elec'!$F$27+'Assumptions - Low-C Elec'!$I$27)","v":6.4827320722095558E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F119*'Assumptions - Today''s Grid'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*('Assumptions - Low-C Elec'!$F$17+'Assumptions - Low-C Elec'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F120*'Assumptions - Today''s Grid'!C27","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*('Assumptions - Low-C Elec'!$F$28+'Assumptions - Low-C Elec'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F121*'Assumptions - Today''s Grid'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*('Assumptions - Low-C Elec'!$F$29+'Assumptions - Low-C Elec'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F122*'Assumptions - Today''s Grid'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*('Assumptions - Low-C Elec'!$F$30+'Assumptions - Low-C Elec'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F123*'Assumptions - Today''s Grid'!C30","v":3.9199999999999995},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":0.11816625549344001},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F123*('Assumptions - Low-C Elec'!$F$31+'Assumptions - Low-C Elec'!$I$31)","v":1.0871295505396481E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F124*'Assumptions - Today''s Grid'!C31","v":0.24000000000000002},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Assumptions - Low-C Elec'!$B$15","v":8.4404468209600004E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F124*('Assumptions - Low-C Elec'!$F$32+'Assumptions - Low-C Elec'!$I$32)","v":7.6808066070736E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Comparison","index":7,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":28}
["Levelized Cost of Hot-Rolled Coil Comparison"]
[null,null,"CAPEX","Fixed OPEX","Electricity","Fuel","Feedstocks","Transportation","Carbon Capture","Target"]
[null,"BF-BOF: Today's Grid",{"$f":"'BF-BOF - Today''s Grid'!D6","v":59.165544664400912},{"$f":"SUM('BF-BOF - Today''s Grid'!D9:D13)","v":101.58871096069976},{"$f":"'BF-BOF - Today''s Grid'!D24","v":4.7184480045281632},{"$f":"SUM('BF-BOF - Today''s Grid'!D22:D29)-'BF-BOF - Today''s Grid'!D24","v":29.041942174351803},{"$f":"SUM('BF-BOF - Today''s Grid'!D42:D48)","v":491.5},{"$f":"SUM('BF-BOF - Today''s Grid'!D17:D19)","v":96}]
[null,"Your Tech: Today's Grid",{"$f":"'Your Tech - Today''s Grid'!D6+'Assumptions - Today''s Grid'!C46","v":79.87348529694124},{"$f":"'Your Tech - Today''s Grid'!D9+SUM('Your Tech - Today''s Grid'!D10:D13)","v":93.088710960699757},{"$f":"'Your Tech - Today''s Grid'!D25+'Your Tech - Today''s Grid'!D46","v":227.38809352577434},{"$f":"SUM('Your Tech - Today''s Grid'!D23:D31)-'Your Tech - Today''s Grid'!D25+SUM('Your Tech - Today''s Grid'!D44:D49)-'Your Tech - Today''s Grid'!D46","v":1.7102560876555479},{"$f":"SUM('Your Tech - Today''s Grid'!D35:D41)+SUM('Your Tech - Today''s Grid'!D52:D59)","v":454.1},{"$f":"SUM('Your Tech - Today''s Grid'!D17:D19)","v":81}]
[null,"BF-BOF: Low-C Grid",{"$f":"'BF-BOF - Low-C Elec'!D6","v":59.165544664400912},{"$f":"SUM('BF-BOF - Low-C Elec'!D9:D13)","v":101.58871096069976},{"$f":"'BF-BOF - Low-C Elec'!D24+'BF-BOF - Low-C Elec'!D34","v":2.9893273072165996},{"$f":"SUM('BF-BOF - Low-C Elec'!D22:D39)-'BF-BOF - Low-C Elec'!D24-'BF-BOF - Low-C Elec'!D34","v":29.954628790219257},{"$f":"SUM('BF-BOF - Low-C Elec'!D42:D57)","v":491.5},{"$f":"SUM('BF-BOF - Low-C Elec'!D17:D19)","v":96}]
[null,"Your Tech: Low-C Grid",{"$f":"'Your Tech - Low-C Elec'!D6+'Assumptions - Today''s Grid'!C46","v":79.87348529694124},{"$f":"SUM('Your Tech - Low-C Elec'!D9:D13)","v":52.5},{"$f":"'Your Tech - Low-C Elec'!D25+'Your Tech - Low-C Elec'!D46","v":97.452040082474696},{"$f":"SUM('Your Tech - Low-C Elec'!D23:D31)-'Your Tech - Low-C Elec'!D25+SUM('Your Tech - Low-C Elec'!D44:D49)-'Your Tech - Low-C Elec'!D46","v":1.7102560876555462},{"$f":"SUM('Your Tech - Low-C Elec'!D35:D41)+SUM('Your Tech - Low-C Elec'!D52:D59)","v":443.75},{"$f":"SUM('Your Tech - Low-C Elec'!D17:D19)","v":81}]
[null,"Target",{"$nulls":7},400]
[]
["GHG Emissions Comparison"]
[null,null,"Capital Equip","Operations","Electricity","Fuel","Feedstocks","Transportation","Other","Target"]
[null,"BF-BOF: Today's Grid",{"$f":"'BF-BOF - Today''s Grid'!H6+'BF-BOF - Today''s Grid'!K6","v":0},{"$f":"SUM('BF-BOF - Today''s Grid'!K10:K13)","v":0.38634087964031805},{"$f":"'BF-BOF - Today''s Grid'!H24+'BF-BOF - Today''s Grid'!H34","v":3.8562291413261007E-2},{"$f":"SUM('BF-BOF - Today''s Grid'!H22:H29)+SUM('BF-BOF - Today''s Grid'!K22:K29)+SUM('BF-BOF - Today''s Grid'!H32:H39)+SUM('BF-BOF - Today''s Grid'!K32:K39)-'BF-BOF - Today''s Grid'!H24-'BF-BOF - Today''s Grid'!H34","v":1.3634655592344682},{"$f":"SUM('BF-BOF - Today''s Grid'!H42:H57)+SUM('BF-BOF - Today''s Grid'!K42:K57)","v":0.21377717155097903},{"$f":"SUM('BF-BOF - Today''s Grid'!H17:H19)+SUM('BF-BOF - Today''s Grid'!K17:K19)","v":0.13215999999999997}]
[null,"Your Tech: Today's Grid",{"$f":"'Your Tech - Today''s Grid'!H6+'Your Tech - Today''s Grid'!K6","v":0},{"$f":"SUM('Your Tech - Today''s Grid'!K10:K13)","v":0.38634087964031805},{"$f":"'Your Tech - Today''s Grid'!H25+'Your Tech - Today''s Grid'!K25+'Your Tech - Today''s Grid'!H46+'Your Tech - Today''s Grid'!K46","v":1.2571303113596743},{"$f":"SUM('Your Tech - Today''s Grid'!H23:H31)-'Your Tech - Today''s Grid'!H25+SUM('Your Tech - Today''s Grid'!K23:K31)-'Your Tech - Today''s Grid'!K25+SUM('Your Tech - Today''s Grid'!H44:H49)-'Your Tech - Today''s Grid'!H46+SUM('Your Tech - Today''s Grid'!K44:K49)-'Your Tech - Today''s Grid'!K46","v":5.9401754614211252E-2},{"$f":"SUM('Your Tech - Today''s Grid'!H52:H59)+SUM('Your Tech - Today''s Grid'!K52:K59)+SUM('Your Tech - Today''s Grid'!H35:H41)+SUM('Your Tech - Today''s Grid'!K35:K41)","v":0.20196412866323427},{"$f":"SUM('Your Tech - Today''s Grid'!H17:H19)+SUM('Your Tech - Today''s Grid'!K17:K19)","v":0.12107999999999999}]
[null,"BF-BOF: Low-C Elec Mix",0,{"$f":"SUM('BF-BOF - Low-C Elec'!K10:K13)","v":0.22292357169907637},{"$f":"'BF-BOF - Low-C Elec'!H24+'BF-BOF - Low-C Elec'!K24+'BF-BOF - Low-C Elec'!H34+'BF-BOF - Low-C Elec'!K34","v":6.9750914700988896E-3},{"$f":"SUM('BF-BOF - Low-C Elec'!H22:H39)+SUM('BF-BOF - Low-C Elec'!K22:K39)-'BF-BOF - Low-C Elec'!H24-'BF-BOF - Low-C Elec'!K24-'BF-BOF - Low-C Elec'!H34-'BF-BOF - Low-C Elec'!K34","v":1.3634655592344682},{"$f":"SUM('BF-BOF - Low-C Elec'!H42:H57)+SUM('BF-BOF - Low-C Elec'!K42:K57)","v":9.6347110585811677E-2},{"$f":"SUM('BF-BOF - Low-C Elec'!H17:H19)+SUM('BF-BOF - Low-C Elec'!K17:K19)","v":0.13215999999999997}]
[null,"Your Tech: Low-C Elec Mix",0,{"$f":"SUM('Your Tech - Low-C Elec'!K10:K13)","v":0.22292357169907637},{"$f":"'Your Tech - Low-C Elec'!H25+'Your Tech - Low-C Elec'!K25+'Your Tech - Low-C Elec'!H46+'Your Tech - Low-C Elec'!K46","v":0.22738791161544503},{"$f":"SUM('Your Tech - Low-C Elec'!H23:H31)+SUM('Your Tech - Low-C Elec'!K23:K31)-'Your Tech - Low-C Elec'!H25-'Your Tech - Low-C Elec'!K25+SUM('Your Tech - Low-C Elec'!H44:H49)+SUM('Your Tech - Low-C Elec'!K44:K49)-'Your Tech - Low-C Elec'!H46-'Your Tech - Low-C Elec'!K46","v":5.9401754614211252E-2},{"$f":"SUM('Your Tech - Low-C Elec'!H35:H41)+SUM('Your Tech - Low-C Elec'!K35:K41)+SUM('Your Tech - Low-C Elec'!H52:H59)+SUM('Your Tech - Low-C Elec'!K52:K59)","v":6.8363486961557807E-2},{"$f":"SUM('Your Tech - Low-C Elec'!H17:H19)+SUM('Your Tech - Low-C Elec'!K17:K19)","v":0.12107999999999999}]
[null,"Target",{"$nulls":7},0.7]
[]
[]
["GHG Emissions Comparison",null,"Extraction + Beneficiation + Agglomeration","Iron Ore Transport","Ironmaking","Steelmaking & Finishing","Target"]
[null,"BF-BOF: Today's Grid",{"$f":"SUM('BF-BOF - Today''s Grid'!H42:H43)+SUM('BF-BOF - Today''s Grid'!K42:K43)+'BF-BOF - Today''s Grid'!K10","v":0.35279748891797025},{"$f":"H39","v":0.13215999999999997},{"$f":"SUM('BF-BOF - Today''s Grid'!H22:H29)+SUM('BF-BOF - Today''s Grid'!K22:K29)+SUM('BF-BOF - Today''s Grid'!H44:H48)+SUM('BF-BOF - Today''s Grid'!K44:K48)","v":1.3753905001180415},{"$f":"SUM('BF-BOF - Today''s Grid'!H32:H39)+SUM('BF-BOF - Today''s Grid'!K32:K39)+SUM('BF-BOF - Today''s Grid'!K11:K13)","v":0.27395791280301451},null,{"$f":"SUM(C47:F47)","v":2.134305901839026},{"$f":"H47-K39","v":2.134305901839026}]
[null,"Your Tech: Today's Grid",{"$f":"SUM('Your Tech - Today''s Grid'!H35:H36)+SUM('Your Tech - Today''s Grid'!K35:K36)+'Your Tech - Today''s Grid'!K10","v":0.30268444603022548},{"$f":"SUM('Your Tech - Today''s Grid'!H17:H19)+SUM('Your Tech - Today''s Grid'!K17:K19)","v":0.12107999999999999},{"$f":"SUM('Your Tech - Today''s Grid'!H23:H31)+SUM('Your Tech - Today''s Grid'!K23:K31)+SUM('Your Tech - Today''s Grid'!H37:H41)+SUM('Your Tech - Today''s Grid'!K37:K41)","v":1.084425},{"$f":"SUM('Your Tech - Today''s Grid'!H44:H59)+SUM('Your Tech - Today''s Grid'!K44:K59)+SUM('Your Tech - Today''s Grid'!K11:K13)","v":0.51772762824721252},null,{"$f":"SUM(C48:F48)","v":2.0259170742774382},{"$f":"H48-K40","v":2.0259170742774382}]
[null,"BF-BOF: Low-C Elec Mix",{"$f":"SUM('BF-BOF - Low-C Elec'!H42:H43)+SUM('BF-BOF - Low-C Elec'!K42:K43)+'BF-BOF - Low-C Elec'!K10","v":0.22115318797837996},{"$f":"SUM('BF-BOF - Low-C Elec'!H17:H19)+SUM('BF-BOF - Low-C Elec'!K17:K19)","v":0.13215999999999997},{"$f":"SUM('BF-BOF - Low-C Elec'!H22:H29)+SUM('BF-BOF - Low-C Elec'!K22:K29)+SUM('BF-BOF - Low-C Elec'!H44:H48)+SUM('BF-BOF - Low-C Elec'!K44:K48)","v":1.3540226883917847},{"$f":"SUM('BF-BOF - Low-C Elec'!H32:H39)+SUM('BF-BOF - Low-C Elec'!K32:K39)+SUM('BF-BOF - Low-C Elec'!K11:K13)","v":0.11453545661929038},null,{"$f":"SUM(C49:F49)","v":1.8218713329894551},1.8218713329894551]
[null,"Your Tech, Low-C Elec Mix",{"$f":"SUM('Your Tech - Low-C Elec'!H35:H36)+SUM('Your Tech - Low-C Elec'!K35:K36)+'Your Tech - Low-C Elec'!K10","v":0.20039766033192707},{"$f":"SUM('Your Tech - Low-C Elec'!H17:H19)+SUM('Your Tech - Low-C Elec'!K17:K19)","v":0.12107999999999999},{"$f":"SUM('Your Tech - Low-C Elec'!H23:H31)+SUM('Your Tech - Low-C Elec'!K23:K31)+SUM('Your Tech - Low-C Elec'!H37:H41)+SUM('Your Tech - Low-C Elec'!K37:K41)","v":0.196825},{"$f":"SUM('Your Tech - Low-C Elec'!K11:K13)+SUM('Your Tech - Low-C Elec'!H44:H59)+SUM('Your Tech - Low-C Elec'!K44:K59)","v":0.18085406455836334},null,0.69915672489029035,0.69915672489029035]
[null,"Target",{"$nulls":4},0.7]