{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Cover & Instructions","Your Tech - Edit This Sheet","Input Assumptions","Example - BF-BOF","Example - Low-C Elec","Comparison"],"not_rendered":{"charts":3,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":2,"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":47,"n_cols":1,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Welcome to the Ironmaking Cost and Greenhouse Gas (GHG) Estimator Tool. Read everything here first!!!"]
["Disclaimer"]
["This spreadsheet tool is not designed to model every possible iron or steelmaking technology and its use is not a criterion for a succesful proposal."]
["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 analysis of technologies using input data from a common, standard input library."]
["Use this tool to estimate 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 type of feedstock. If a material or energy carrier is both produced and consumed within your process, do not model it here. Only quantify externally purchased materials and energy carriers. The only exception is if you plan to purchase natural gas, reform it to H2, and sequester the CO2 on-site. In that case, choose the \"SMR+CCS H2\" input rather than \"Natural Gas\""]
["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."]
["If you are NOT making a steel product as part of your application (i.e. stopping after the ironmaking step), do not add values to any of the green-shaded cells on the \"Your Tech - Edit This Sheet\" sheet for stamping, sintering, skin mill, and hot rolling. Also do not add values to any of the green-shaded cells in this sheet that quantify energy and material inputs to the steelmaking step."]
["The embodied emissions for steel scrap include collection, transportation, and sorting."]
["This tool only tracks emissions from greenhouse gas emissions. Refer back to the FOA and address any other environmental concerns."]
["This tool does not directly break emissions into Scopes as defined by the World Resources Institute (WRI) GHG Protocol."]
{"$rows_empty":12}
["The above steps are all covered automatically in this tool. If a particular technology is not part of your process, please make sure those values in the \"Your Tech - Edit This Sheet\" tab are zero."]
[]
["Sheet Overviews/Instructions"]
["There are 4 sheets after this cover page in the document. You may only edit one of them. You must update the data in \"Your Tech - Edit This Sheet\" tab."]
["Input Assumptions: Background data (GHG emissions, energy consumption) and cost for energy and material inputs to iron and steel-making technologies. Do not edit this sheet!"]
["Example - BF-BOF: Process data for BF-BOF this tool's template. Do not edit this sheet, but take a look to see how energy and material flows are modeled."]
["Your Tech - Edit This Sheet: 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. "]
["Default values are provided (columns M and N) to allow you to complete the calculation for the cost/emissions for HRC production. If you use the default values, it is recommended to copy the value from the Default Values columns, then ctrl+alt+v paste selecting the \"Values\" option."]
["You may add your own energy and material inputs on the \"Your Tech - Edit This Sheet\" sheet. If you do, you need to estimate how much of that energy/material input you need, its unit cost, and its carbon footprint (upstream and any direct GHG emissions during the iron/steel-making processes). "]
["Comparison: Auto-populated charts and tables fed from inputs on the other sheets of this workbook. Do not edit this sheet! This is for your use only and is not a criterion for a successful proposal."]
[]
["How to use"]
["Note units on all cells!"]
["Any green shaded cell is editable. Any cell that is not shaded green is NOT EDITABLE."]
["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 energy 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 arpa-e-co@hq.doe.gov"]

{"sheet":"Your Tech - Edit This Sheet","index":1,"n_rows":168,"n_cols":16383,"rows_kept":168,"cut":false,"hidden":false,"merged":[]}
["Your Tech, Standard Case (user to fill in using values from Standard Assumptions in Assumptions tab or Columns M and N as needed)"]
["Input Variable",null,"Value","Units","Value","Amount/t crude steel","Value","Embedded emissions",null,"Value","Process emissions","Justification for Changes","Default Values","Default Values"]
[]
["Capital Costs"]
["Facility Capital Cost ($)",null,0,"$",{"$nulls":8},600000000]
["Facility Capacity (tonnes of steel per yr)",null,0,"t HRC steel/yr",{"$nulls":8},40000]
["Facility Lifetime (yrs)",null,0,"yrs",{"$nulls":8},25]
["Capital Equipment (tot upfront cost)",null,{"$f":"IF(C6*C7>0,C5/C6/C7,0)","v":0},"$/t HRC steel"]
["Cap Equip Annualized",null,{"$f":"C8*'Input Assumptions'!C9/('Input Assumptions'!C6/100)","v":0},"$/t HRC steel"]
[]
["Fixed OPEX (assumed a % of capital cost)"]
["Fixed OPEX",null,{"$f":"0.085*C8","v":0},"$/t HRC steel"]
[{"$nulls":16382},"Skin Mill"]
[]
["Iron Feedstock Transportation","Distance (mi)"]
["Barge",0,{"$f":"B16*'Input Assumptions'!$C$38*E16","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"E16*'Input Assumptions'!$I$38*B16","v":0},"t CO2e/t HRC steel",null,0,0]
["Rail",0,{"$f":"B17*'Input Assumptions'!$C$39*E17","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"E17*'Input Assumptions'!$I$39*B17","v":0},"t CO2e/t HRC steel",null,700,3]
["Truck",0,{"$f":"B18*'Input Assumptions'!$C$40*E18","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"E18*'Input Assumptions'!$I$40*B18","v":0},"t CO2e/t HRC steel",null,100,3]
[]
[]
["Energy Inputs to Ironmaking Step ONLY (New Tech)"]
["Natural gas",null,{"$f":"E22*'Input Assumptions'!C24","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E22*'Input Assumptions'!F24","v":0},"t CO2e/t HRC steel",null,{"$f":"E22*'Input Assumptions'!I24","v":0},"t CO2e/t HRC steel",null,0]
["Coke",null,{"$f":"E23*'Input Assumptions'!C25","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E23*'Input Assumptions'!F25","v":0},"t CO2e/t HRC steel",null,{"$f":"E23*'Input Assumptions'!I25","v":0},"t CO2e/t HRC steel",null,0]
["Electricity ",null,{"$f":"E24*'Input Assumptions'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E24*'Input Assumptions'!F27","v":0},"t CO2e/t HRC steel",null,{"$f":"E24*'Input Assumptions'!I27","v":0},"t CO2e/t HRC steel",null,{"$f":"CONVERT(2800,\"kWh\",\"GJ\")","v":10.08}]
["Fossil SMR Hydrogen",null,{"$f":"E25*'Input Assumptions'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E25*'Input Assumptions'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"E25*'Input Assumptions'!I28","v":0},"t CO2e/t HRC steel",null,0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E26*'Input Assumptions'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E26*'Input Assumptions'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"E26*'Input Assumptions'!I29","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E27*'Input Assumptions'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E27*'Input Assumptions'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"E27*'Input Assumptions'!I30","v":0},"t CO2e/t HRC steel",null,0]
["Fossil Diesel",null,{"$f":"E28*'Input Assumptions'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E28*'Input Assumptions'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"E28*'Input Assumptions'!I31","v":0},"t CO2e/t HRC steel",null,0]
["Fossil Gasoline",null,{"$f":"E29*'Input Assumptions'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E29*'Input Assumptions'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"E29*'Input Assumptions'!I32","v":0},"t CO2e/t HRC steel",null,0]
["Electricity (Future; Greener)",null,{"$f":"E30*'Input Assumptions'!C34","v":0},"$/t HRC steel",{"$f":"E24","v":0},"GJ/t HRC steel",{"$f":"E30*'Input Assumptions'!F34","v":0},"t CO2e/t HRC steel",null,{"$f":"E30*'Input Assumptions'!I34","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (US; Future; Greener; IRA)",null,{"$f":"E31*'Input Assumptions'!C35","v":0},"$/t HRC steel",{"$f":"E27","v":0},"GJ/t HRC steel",{"$f":"E31*'Input Assumptions'!F35","v":0},"t CO2e/t HRC steel",null,{"$f":"E31*'Input Assumptions'!I35","v":0},"t CO2e/t HRC steel",null,0]
["Alternate Inputs (user-added) start here",null,{"$f":"E32*'Input Assumptions'!C36","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E32*'Input Assumptions'!F36","v":0},"t CO2e/t HRC steel",null,{"$f":"E32*'Input Assumptions'!I36","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E33*'Input Assumptions'!C37","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E33*'Input Assumptions'!F37","v":0},"t CO2e/t HRC steel",null,{"$f":"E33*'Input Assumptions'!I37","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E34*'Input Assumptions'!C38","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E34*'Input Assumptions'!F38","v":0},"t CO2e/t HRC steel",null,{"$f":"E34*'Input Assumptions'!I38","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E35*'Input Assumptions'!C39","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E35*'Input Assumptions'!F39","v":0},"t CO2e/t HRC steel",null,{"$f":"E35*'Input Assumptions'!I39","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E36*'Input Assumptions'!C40","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E36*'Input Assumptions'!F40","v":0},"t CO2e/t HRC steel",null,{"$f":"E36*'Input Assumptions'!I40","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E37*'Input Assumptions'!C41","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E37*'Input Assumptions'!F41","v":0},"t CO2e/t HRC steel",null,{"$f":"E37*'Input Assumptions'!I41","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Ironmaking Step ONLY (New Tech)"]
["Iron ore fines (imported)",null,{"$f":"E40*'Input Assumptions'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"E40*SUM(G147:G154)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I14*E40","v":0},"t CO2e/t HRC steel",null,0]
["Iron ore fines (US - Taconite)",null,{"$f":"E41*'Input Assumptions'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"E41*SUM(G159:G166)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I15*E41","v":0},"t CO2e/t HRC steel",null,3]
["Biomass",null,{"$f":"E42*'Input Assumptions'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Input Assumptions'!F17*E42","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I17*E42","v":0},"t CO2e/t HRC steel",null,0]
["Biocharcoal",null,{"$f":"E43*'Input Assumptions'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Input Assumptions'!F18*E43","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I18*E43","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E44*'Input Assumptions'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F19*E44","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I19*E44","v":0},"t CO2e/t HRC steel",null,0]
["Lime",null,{"$f":"E45*'Input Assumptions'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Input Assumptions'!F20*E45","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I20*E45","v":0},"t CO2e/t HRC steel",null,7.4999999999999997E-2]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E46*'Input Assumptions'!C21","v":0},"$/t HRC steel",{"$f":"E44","v":0},"t H2/t HRC steel",{"$f":"'Input Assumptions'!F21*E46","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I21*E46","v":0},"t CO2e/t HRC steel",null,0]
["Alternate Inputs (user-added) start here",null,{"$f":"E47*'Input Assumptions'!C50","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E47*'Input Assumptions'!F50","v":0},"t CO2e/t HRC steel",null,{"$f":"E47*'Input Assumptions'!I50","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E48*'Input Assumptions'!C51","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E48*'Input Assumptions'!F51","v":0},"t CO2e/t HRC steel",null,{"$f":"E48*'Input Assumptions'!I51","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E49*'Input Assumptions'!C52","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E49*'Input Assumptions'!F52","v":0},"t CO2e/t HRC steel",null,{"$f":"E49*'Input Assumptions'!I52","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E50*'Input Assumptions'!C53","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E50*'Input Assumptions'!F53","v":0},"t CO2e/t HRC steel",null,{"$f":"E50*'Input Assumptions'!I53","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E51*'Input Assumptions'!C54","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E51*'Input Assumptions'!F54","v":0},"t CO2e/t HRC steel",null,{"$f":"E51*'Input Assumptions'!I54","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E52*'Input Assumptions'!C55","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E52*'Input Assumptions'!F55","v":0},"t CO2e/t HRC steel",null,{"$f":"E52*'Input Assumptions'!I55","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY"]
["Natural Gas",null,{"$f":"E55*'Input Assumptions'!C24","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E55*('Input Assumptions'!F24)","v":0},"t CO2e/t HRC",null,{"$f":"E55*('Input Assumptions'!I24)","v":0},"t CO2e/t HRC steel",null,0.49482119487878001]
["Coke",null,{"$f":"E56*'Input Assumptions'!C25","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E56*('Input Assumptions'!F25)","v":0},"t CO2e/t HRC",null,{"$f":"E56*('Input Assumptions'!I25)","v":0},"t CO2e/t HRC steel",null,0.17935949494540004]
["Electricity",null,{"$f":"E57*'Input Assumptions'!C27","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E57*('Input Assumptions'!F27)","v":0},"t CO2e/t HRC",null,{"$f":"E57*('Input Assumptions'!I27)","v":0},"t CO2e/t HRC steel",null,1.6142354545086004]
["Fossil SMR Hydrogen",null,{"$f":"E58*'Input Assumptions'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E58*('Input Assumptions'!F28)","v":0},"t CO2e/t HRC",null,{"$f":"E58*('Input Assumptions'!I28)","v":0},"t CO2e/t HRC steel",null,0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E59*'Input Assumptions'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E59*('Input Assumptions'!F29)","v":0},"t CO2e/t HRC",null,{"$f":"E59*('Input Assumptions'!I29)","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E60*'Input Assumptions'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC",{"$f":"E60*('Input Assumptions'!F30)","v":0},"t CO2e/t HRC",null,{"$f":"E60*('Input Assumptions'!I30)","v":0},"t CO2e/t HRC steel",null,0]
["Electricity (Future; Greener)",null,{"$f":"E61*'Input Assumptions'!C34","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E61*'Input Assumptions'!F34","v":0},"t CO2e/t HRC steel",null,{"$f":"E61*'Input Assumptions'!I34","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Future; Greener; IRA)",null,{"$f":"E62*'Input Assumptions'!C35","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E62*'Input Assumptions'!F35","v":0},"t CO2e/t HRC steel",null,{"$f":"E62*'Input Assumptions'!I35","v":0},"t CO2e/t HRC steel",null,0]
["Alternate Inputs (user-added) start here",null,{"$f":"E63*'Input Assumptions'!C64","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E63*'Input Assumptions'!F64","v":0},"t CO2e/t HRC steel",null,{"$f":"E63*'Input Assumptions'!I64","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E64*'Input Assumptions'!C65","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E64*'Input Assumptions'!F65","v":0},"t CO2e/t HRC steel",null,{"$f":"E64*'Input Assumptions'!I65","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E65*'Input Assumptions'!C66","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E65*'Input Assumptions'!F66","v":0},"t CO2e/t HRC steel",null,{"$f":"E65*'Input Assumptions'!I66","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E66*'Input Assumptions'!C67","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E66*'Input Assumptions'!F67","v":0},"t CO2e/t HRC steel",null,{"$f":"E66*'Input Assumptions'!I67","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,0,"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E67*'Input Assumptions'!F68","v":0},"t CO2e/t HRC steel",null,{"$f":"E67*'Input Assumptions'!I68","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E68*'Input Assumptions'!C69","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E68*'Input Assumptions'!F69","v":0},"t CO2e/t HRC steel",null,{"$f":"E68*'Input Assumptions'!I69","v":0},"t CO2e/t HRC steel"]
[]
["Additional Feedstocks to Steelmaking Step ONLY"]
["Iron ore fines (imported)",null,{"$f":"E71*'Input Assumptions'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"E71*SUM(G147:G154)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I13*E71","v":0},"t CO2e/t HRC steel",null,0]
["Iron ore fines (US - Taconite)",null,{"$f":"E72*'Input Assumptions'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"E72*SUM(G159:G166)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I14*E72","v":0},"t CO2e/t HRC steel",null,0]
["Scrap",null,{"$f":"E73*'Input Assumptions'!C16","v":0},"$/t HRC steel",0,"t scrap/t HRC steel",{"$f":"E73*'Input Assumptions'!F16","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I15*E73","v":0},"t CO2e/t HRC steel",null,0.254]
["Biomass",null,{"$f":"E74*'Input Assumptions'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Input Assumptions'!F16*E74","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I16*E74","v":0},"t CO2e/t HRC steel",null,0]
["Biocharcoal",null,{"$f":"E75*'Input Assumptions'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Input Assumptions'!F17*E75","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I17*E75","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E76*'Input Assumptions'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F18*E76","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I18*E76","v":0},"t CO2e/t HRC steel",null,0]
["Lime",null,{"$f":"E77*'Input Assumptions'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Input Assumptions'!F19*E77","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I19*E77","v":0},"t CO2e/t HRC steel",null,0]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E78*'Input Assumptions'!C21","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F20*E78","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I20*E78","v":0},"t CO2e/t HRC steel",null,0]
["Alternate Inputs (user-added) start here",null,{"$f":"E79*'Input Assumptions'!C79","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E79*'Input Assumptions'!F79","v":0},"t CO2e/t HRC steel",null,{"$f":"E79*'Input Assumptions'!I79","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E80*'Input Assumptions'!C80","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E80*'Input Assumptions'!F80","v":0},"t CO2e/t HRC steel",null,{"$f":"E80*'Input Assumptions'!I80","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E81*'Input Assumptions'!C81","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E81*'Input Assumptions'!F81","v":0},"t CO2e/t HRC steel",null,{"$f":"E81*'Input Assumptions'!I81","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E82*'Input Assumptions'!C82","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E82*'Input Assumptions'!F82","v":0},"t CO2e/t HRC steel",null,{"$f":"E82*'Input Assumptions'!I82","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E83*'Input Assumptions'!C83","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"E83*'Input Assumptions'!F83","v":0},"t CO2e/t HRC steel",null,{"$f":"E83*'Input Assumptions'!I83","v":0},"t CO2e/t HRC steel"]
["Alternate Inputs (user-added) start here",null,{"$f":"E84*'Input Assumptions'!C22","v":0},"$/t HRC steel",0,"t/t HRC steel",{"$f":"'Input Assumptions'!F20*E84","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I20*E84","v":0},"t CO2e/t HRC steel"]
[]
["Processes",null,"Value","Units","$ or Energy Input","Unit","Value","Combined Embedded + Process Emissions"]
["Hot Rolling (Fixed Costs)",null,null,null,0,"$/t HRC",{"$nulls":6},5]
["Natural Gas",null,{"$f":"E88*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E88*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC",{"$nulls":4},0.66468518715059999]
["Electricity",null,{"$f":"E89*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E89*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t HRC",{"$nulls":4},0.74275932024448021]
["Biomass",null,{"$f":"E90*'Input Assumptions'!C17","v":0},"$/t HRC",0,"t/t HRC",{"$f":"E90*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E91*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E91*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E92*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E92*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E93*'Input Assumptions'!C31","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E93*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity (Future; Greener)",null,{"$f":"E94*'Input Assumptions'!C34","v":0},"$/t HRC",{"$f":"E89","v":0},"GJ/t HRC",{"$f":"E94*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E95*'Input Assumptions'!C35","v":0},"$/t HRC",{"$f":"E93","v":0},"GJ/t HRC",{"$f":"E95*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t HRC"]
[]
["Sintering (Fixed Costs)",null,null,null,0,"$/t HRC",{"$nulls":6},2]
["Natural Gas",null,{"$f":"E98*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E98*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity",null,{"$f":"E99*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E99*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t HRC",{"$nulls":4},0.16142354545086002]
["Biomass",null,{"$f":"E100*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E100*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E101*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E101*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E102*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E102*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E103*'Input Assumptions'!C31","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E103*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Coke",null,{"$f":"E104*'Input Assumptions'!C25","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E104*('Input Assumptions'!$F$25+'Input Assumptions'!$I$25)","v":0},"t CO2e/t HRC",{"$nulls":4},1.1637266054398603]
["Electricity (Future; Greener)",null,{"$f":"E105*'Input Assumptions'!C45","v":0},"$/t HRC",{"$f":"E99","v":0},"GJ/t HRC",{"$f":"E105*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E106*'Input Assumptions'!C46","v":0},"$/t HRC",{"$f":"E103","v":0},"GJ/t HRC",{"$f":"E106*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t HRC"]
[]
["Stamping (Fixed Costs)",null,null,null,0,"$/t HRC",{"$nulls":6},2]
["Natural Gas",null,{"$f":"E109*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E109*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity",null,{"$f":"E110*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E110*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t HRC",{"$nulls":4},0.90734803325320013]
["Biomass",null,{"$f":"E111*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E111*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E112*'Input Assumptions'!C28","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E112*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E113*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E113*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E114*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E114*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity (Future; Greener)",null,{"$f":"E115*'Input Assumptions'!C55","v":0},"$/t HRC",{"$f":"E110","v":0},"GJ/t HRC",{"$f":"E115*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E116*'Input Assumptions'!C56","v":0},"$/t HRC",{"$f":"E114","v":0},"GJ/t HRC",{"$f":"E116*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill (Fixed Costs)",null,null,null,0,"$/t HRC",{"$nulls":6},1]
["Natural Gas",null,{"$f":"E119*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E119*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity",null,{"$f":"E120*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E120*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t HRC",{"$nulls":4},4.431234581004001E-2]
["Biomass",null,{"$f":"E121*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E121*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E122*'Input Assumptions'!C28","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E122*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E123*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E123*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E124*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E124*'Input Assumptions'!$F$30+'Input Assumptions'!$I$30","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity (Future; Greener)",null,{"$f":"E125*'Input Assumptions'!C65","v":0},"$/t HRC",{"$f":"E120","v":0},"GJ/t HRC",{"$f":"E125*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E126*'Input Assumptions'!C66","v":0},"$/t HRC",{"$f":"E124","v":0},"GJ/t HRC",{"$f":"E126*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t HRC"]
[]
["EAF"]
["EAF Capital Cost ($)",null,null,null,0,"$",{"$nulls":6},310000000]
["EAF Capacity (tonnes steel/yr)",null,null,null,0,"t HRC/yr",{"$nulls":6},20000]
["EAF Lifetime (yrs)",null,null,null,0,"yr",{"$nulls":6},50]
["Electric arc furnace (tot upfront cost)",null,null,null,{"$f":"IF(E130*E131>0,E129/E130/E131,0)","v":0},"$/tonne HRC"]
["Fixed CAPEX Electric arc furnace (annualized)",null,null,null,{"$f":"E132*'Input Assumptions'!C9/('Input Assumptions'!C6*0.01)","v":0},"$/tonne HRC"]
["Natural Gas",null,{"$f":"E134*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E134*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity",null,{"$f":"E135*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E135*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Biomass",null,{"$f":"E136*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E136*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E137*'Input Assumptions'!C28","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E137*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E138*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E138*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E139*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E139*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Coke",null,{"$f":"E140*'Input Assumptions'!C25","v":0},"$/t HRC",0,"GJ/t HRC",{"$f":"E140*('Input Assumptions'!$F$25+'Input Assumptions'!$I$25)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Scrap",null,{"$f":"E141*'Input Assumptions'!C16","v":0},"$/t HRC",0,"t/t HRC",{"$f":"E141*('Input Assumptions'!$F$16+'Input Assumptions'!$I$16)","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Iron Ore",null,{"$f":"E142*'Input Assumptions'!C14","v":0},"$/t HRC",0,"t/t HRC",{"$f":"E142*'Input Assumptions'!$F$15","v":0},"t CO2e/t HRC",{"$nulls":4},0]
["Electricity (Future; Greener)",null,{"$f":"E143*'Input Assumptions'!C80","v":0},"$/t HRC",{"$f":"E136","v":0},"GJ/t HRC",{"$f":"E143*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E144*'Input Assumptions'!C81","v":0},"$/t HRC",{"$f":"E139","v":0},"GJ/t HRC",{"$f":"E144*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)"]
["Natural Gas",null,{"$f":"E147*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E147*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},1.3613623904774195E-2]
["Electricity",null,{"$f":"E148*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E148*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0.13443453605964517]
["Biomass",null,{"$f":"E149*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E149*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E150*'Input Assumptions'!C28","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E150*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E151*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E151*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E152*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E152*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil Diesel",null,{"$f":"E153*'Input Assumptions'!C31","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E153*('Input Assumptions'!$F$31+'Input Assumptions'!$I$31)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},4.7647683666709684E-2]
["Fossil Gasoline",null,{"$f":"E154*'Input Assumptions'!C32","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E154*('Input Assumptions'!$F$32+'Input Assumptions'!$I$32)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},3.4034059761935487E-3]
["Electricity (Future; Greener)",null,{"$f":"E155*'Input Assumptions'!C92","v":0},"$/t HRC",{"$f":"E148","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E155*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E156*'Input Assumptions'!C93","v":0},"$/t HRC",{"$f":"E152","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E156*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)"]
["Natural Gas",null,{"$f":"E159*'Input Assumptions'!C24","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E159*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},3.3761787283840002E-2]
["Electricity",null,{"$f":"E160*'Input Assumptions'!C27","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E160*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0.33339764942792]
["Biomass",null,{"$f":"E161*'Input Assumptions'!C17","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E161*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil SMR Hydrogen",null,{"$f":"E162*'Input Assumptions'!C28","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E162*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil SMR+CCS Hydrogen",null,{"$f":"E163*'Input Assumptions'!C29","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E163*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Electrolysis Hydrogen (Today)",null,{"$f":"E164*'Input Assumptions'!C30","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E164*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0]
["Fossil Diesel",null,{"$f":"E165*'Input Assumptions'!C31","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E165*('Input Assumptions'!$F$31+'Input Assumptions'!$I$31)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},0.11816625549344001]
["Fossil Gasoline",null,{"$f":"E166*'Input Assumptions'!C32","v":0},"$/t HRC",0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E166*('Input Assumptions'!$F$32+'Input Assumptions'!$I$32)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)",{"$nulls":4},8.4404468209600004E-3]
["Electricity (Future; Greener)",null,{"$f":"E167*'Input Assumptions'!C104","v":0},"$/t HRC",{"$f":"E160","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E167*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,{"$f":"E168*'Input Assumptions'!C105","v":0},"$/t HRC",{"$f":"E164","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"E168*('Input Assumptions'!$F$35+'Input Assumptions'!$I$35)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Input Assumptions","index":2,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Assumptions"]
["Instructions: Standard assumptions are provided below; do not change them. "]
["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"]
[]
["Feedstock Assumptions","%Fe"]
["Iron ore fines (imported)",0.62,106,"$/tonne Fe",null,{"$f":"SUM('Example - BF-BOF'!H107:H114)","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('Example - BF-BOF'!H119:H126)","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 (Today)",null,5,"$/kg H2",null,{"$f":"C11*F26/1000","v":20.123999999999999},"kg CO2/kg H2",null,0,"t CO2e/t H2",null,"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 from https://pubs.usgs.gov/periodicals/mcs2022/mcs2022-lime.pdf","All emissions are embedded for the material"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,2,"$/kg H2",null,{"$f":"C11*F33/1000","v":3.64},"kg CO2/kg H2",null,0,"t CO2e/t H2"]
[]
["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,{"$f":"F26","v":387},"g CO2e/kWh",null,"EIA Outlook for 2023 national grid mix. "]
["Electricity",null,{"$f":"C26*CONVERT(1,\"GJ\",\"kWh\")","v":19.444444444444446},"$/GJ",null,{"$f":"F26/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 https://www.energypolicy.columbia.edu/research/commentary/hydrogen-leakage-potential-risk-hydrogen-economy"]
["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 and indirect GWP of H2 gas from https://www.energypolicy.columbia.edu/research/commentary/hydrogen-leakage-potential-risk-hydrogen-economy"]
["Electrolysis Hydrogen (Today's US Avg Grid)",null,{"$f":"C19/120*1000","v":41.666666666666664},"$/GJ",null,{"$f":"C11*F26/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"]
["Electricity (Future; Greener)",null,7.0000000000000007E-2,"$/kWh",null,70,"g CO2e/kWh",null,{"$f":"F33","v":70},"g CO2e/kWh","Internal renewable mix of PV solar and wind (approximately 90%) and 10% NGCC. Cis of each taken from GREET1 2022."]
["Electricity (Future; Greener)",null,{"$f":"C33*CONVERT(1,\"GJ\",\"kWh\")","v":19.444444444444446},"$/GJ",null,{"$f":"F33/1000000/0.0036","v":1.9444444444444445E-2},"t CO2e/GJ",null,0,"t CO2e/GJ","Equivalent values to row 32; given here in alternate units"]
["Electrolysis Hydrogen (US; Future; Greener; IRA)",null,{"$f":"30*CONVERT(1,\"GJ\",\"BTU\")/1000000","v":28.434513609399517},"$/GJ",null,{"$f":"C11*F33/120/1000","v":3.0333333333333334E-2},"t CO2e/GJ",null,0,"t CO2e/GJ","Assume 120 MJ/kg LHV"]
[]
["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":"C44*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":"C49*C9/(C6*0.01)","v":30.568864743273803},"$/tonne HRC",{"$nulls":7},"Internal calcs; assumes state-of-art NG and solid carbon fuels inserted"]

{"sheet":"Example - BF-BOF","index":3,"n_rows":128,"n_cols":14,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
["BF-BOF Pathway to HRC"]
["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"]
["Facility Capital Cost ($)",null,null,600000000,"$"]
["Facility Capacity (tonnes of steel per yr)",null,null,40000,"t HRC/yr"]
["Facility Lifetime (yrs)",null,null,25,"yr"]
["BF + BOF (total upfront cost)",null,null,{"$f":"D5/D6/D7","v":600},"$/t HRC"]
["BF + BOF Annualized per Tonne Steel",null,null,{"$f":"D8*'Input Assumptions'!C9/('Input Assumptions'!C6/100)","v":59.165544664400912},"$/t HRC"]
[]
["Fixed OPEX (assumed a % of capital cost)"]
["Fixed OPEX",null,null,{"$f":"D8*0.085","v":51.000000000000007},"$/t HRC"]
[]
[]
["Transportation",null,"Distance (mi)"]
["Barge",null,0,{"$f":"C16*'Input Assumptions'!$C$38*F16","v":0},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F16*'Input Assumptions'!$I$38*C16","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":"C17*'Input Assumptions'!$C$39*F17","v":96},"$/t HRC steel",4,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*'Input Assumptions'!$I$39*C17","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,50,{"$f":"C18*'Input Assumptions'!$C$40*F18","v":15},"$/t HRC steel",5,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*'Input Assumptions'!$I$40*C18","v":2.8624999999999998E-2},"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":"F21*'Input Assumptions'!C24","v":3.9950533904138403},"$/t HRC steel",{"$f":"CONVERT(1.462*1000000,\"BTU\",\"GJ\")","v":1.5424916565304403},"GJ/t HRC steel",{"$f":"F21*'Input Assumptions'!F24","v":1.6967408221834842E-2},"t CO2e/t HRC steel",null,{"$f":"F21*'Input Assumptions'!I24","v":0.10334694098753951},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F22*'Input Assumptions'!C25","v":25.046888783937963},"$/t HRC steel",{"$f":"CONVERT(9.933*1000000,\"BTU\",\"GJ\")","v":10.479869784074461},"GJ/t HRC steel",{"$f":"F22*'Input Assumptions'!F25","v":6.2879218704446765E-2},"t CO2e/t HRC steel",null,{"$f":"F22*'Input Assumptions'!I25","v":1.1527856762481907},"t CO2e/t HRC steel"]
["Electricity",null,null,{"$f":"F23*'Input Assumptions'!C27","v":4.7184442297727784},"$/t HRC steel",{"$f":"CONVERT(0.23*1000000,\"BTU\",\"GJ\")","v":0.24266284610260003},"GJ/t HRC steel",{"$f":"F23*'Input Assumptions'!F27","v":2.6086255956029501E-2},"t CO2e/t HRC steel",null,{"$f":"F23*'Input Assumptions'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F24*'Input Assumptions'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F24*'Input Assumptions'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F24*'Input Assumptions'!I28","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F25*'Input Assumptions'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F25*'Input Assumptions'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F25*'Input Assumptions'!I29","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Today's US Avg Grid)",null,null,{"$f":"F26*'Input Assumptions'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F26*'Input Assumptions'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F26*'Input Assumptions'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F27*'Input Assumptions'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F27*'Input Assumptions'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F27*'Input Assumptions'!I31","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F28*'Input Assumptions'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F28*'Input Assumptions'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F28*'Input Assumptions'!I32","v":0},"t CO2e/t HRC steel"]
["Electricity (Future; Greener)",null,null,{"$f":"F29*'Input Assumptions'!C34","v":4.7184442297727784},"$/t HRC steel",{"$f":"F23","v":0.24266284610260003},"GJ/t HRC steel",{"$f":"F29*'Input Assumptions'!F34","v":4.7184442297727785E-3},"t CO2e/t HRC steel",null,{"$f":"F29*'Input Assumptions'!I34","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US; Future; Greener; IRA)",null,null,{"$f":"F30*'Input Assumptions'!C35","v":0},"$/t HRC steel",{"$f":"F26","v":0},"GJ/t HRC steel",{"$f":"F30*'Input Assumptions'!F35","v":0},"t CO2e/t HRC steel",null,{"$f":"F30*'Input Assumptions'!I35","v":0},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Natural gas",null,null,{"$f":"F33*'Input Assumptions'!C24","v":0.91268661586745725},"$/t HRC steel",{"$f":"CONVERT(0.334*1000000,\"BTU\",\"GJ\")","v":0.35238865477508002},"GJ/t HRC steel",{"$f":"F33*'Input Assumptions'!F24","v":3.87627520252588E-3},"t CO2e/t HRC steel",null,{"$f":"F33*'Input Assumptions'!I24","v":2.3610039869930363E-2},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F34*'Input Assumptions'!C25","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F34*'Input Assumptions'!F25","v":0},"t CO2e/t HRC steel",null,{"$f":"F34*'Input Assumptions'!I25","v":0},"t CO2e/t HRC steel"]
["Electricity",null,null,{"$f":"F35*'Input Assumptions'!C27","v":2.2566472403261115},"$/t HRC steel",{"$f":"CONVERT(0.11*1000000,\"BTU\",\"GJ\")","v":0.11605614378820002},"GJ/t HRC steel",{"$f":"F35*'Input Assumptions'!F27","v":1.2476035457231503E-2},"t CO2e/t HRC steel",null,{"$f":"F35*'Input Assumptions'!I27","v":0},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F36*'Input Assumptions'!C28","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F36*'Input Assumptions'!F28","v":0},"t CO2e/t HRC steel",null,{"$f":"F36*'Input Assumptions'!I28","v":0},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F37*'Input Assumptions'!C29","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F37*'Input Assumptions'!F29","v":0},"t CO2e/t HRC steel",null,{"$f":"F37*'Input Assumptions'!I29","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Today's US Avg Grid)",null,null,{"$f":"F38*'Input Assumptions'!C30","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F38*'Input Assumptions'!F30","v":0},"t CO2e/t HRC steel",null,{"$f":"F38*'Input Assumptions'!I30","v":0},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F39*'Input Assumptions'!C31","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F39*'Input Assumptions'!F31","v":0},"t CO2e/t HRC steel",null,{"$f":"F39*'Input Assumptions'!I31","v":0},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F40*'Input Assumptions'!C32","v":0},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F40*'Input Assumptions'!F32","v":0},"t CO2e/t HRC steel",null,{"$f":"F40*'Input Assumptions'!I32","v":0},"t CO2e/t HRC steel"]
["Electricity (Future; Greener)",null,null,{"$f":"F41*'Input Assumptions'!C34","v":2.2566472403261115},"$/t HRC steel",{"$f":"F35","v":0.11605614378820002},"GJ/t HRC steel",{"$f":"F41*'Input Assumptions'!F34","v":2.2566472403261115E-3},"t CO2e/t HRC steel",null,{"$f":"F41*'Input Assumptions'!I34","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US; Future; Greener; IRA)",null,null,{"$f":"F42*'Input Assumptions'!C35","v":0},"$/t HRC steel",{"$f":"F38","v":0},"GJ/t HRC steel",{"$f":"F42*'Input Assumptions'!F35","v":0},"t CO2e/t HRC steel",null,{"$f":"F42*'Input Assumptions'!I35","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Ironmaking Step ONLY (Blast Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F45*'Input Assumptions'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F45*SUM(H107:H114)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I14*F45","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F46*'Input Assumptions'!C15","v":456},"$/t HRC steel",4,"t Fe/t HRC steel",{"$f":"F46*SUM(H119:H126)","v":0.20045217155097902},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I15*F46","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F47*'Input Assumptions'!C16","v":25},"$/t HRC steel",{"$f":"0.25*('Input Assumptions'!B15)","v":6.25E-2},"t scrap/t HRC steel",{"$f":"'Input Assumptions'!F16*F47","v":1.2500000000000001E-2},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I16*F47","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F48*'Input Assumptions'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Input Assumptions'!F17*F48","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I17*F48","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F49*'Input Assumptions'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Input Assumptions'!F18*F49","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I18*F49","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Today's US Avg Grid)",null,null,{"$f":"F50*'Input Assumptions'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F19*F50","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I19*F50","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F51*'Input Assumptions'!C20","v":10.5},"$/t HRC steel",{"$f":"150/2000","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"'Input Assumptions'!F20*F51","v":8.2499999999999989E-4},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I20*F51","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,{"$f":"F52*'Input Assumptions'!C21","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F21*F52","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I21*F52","v":0},"t CO2e/t HRC steel"]
[]
["Feedstocks to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F55*'Input Assumptions'!C14","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F55*SUM(H107:H114)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I14*F55","v":0},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F56*'Input Assumptions'!C15","v":0},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F56*SUM(H119:H126)","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I15*F56","v":0},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F57*'Input Assumptions'!C16","v":0},"$/t HRC steel",{"$f":"0.25*('Input Assumptions'!B25)","v":0},"t scrap/t HRC steel",{"$f":"'Input Assumptions'!F16*F57","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I16*F57","v":0},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F58*'Input Assumptions'!C17","v":0},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"'Input Assumptions'!F17*F58","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I17*F58","v":0},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F59*'Input Assumptions'!C18","v":0},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"'Input Assumptions'!F18*F59","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I18*F59","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Today's US Avg Grid)",null,null,{"$f":"F60*'Input Assumptions'!C19","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F19*F60","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I19*F60","v":0},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F61*'Input Assumptions'!C20","v":0},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"'Input Assumptions'!F20*F61","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I20*F61","v":0},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,{"$f":"F62*'Input Assumptions'!C21","v":0},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"'Input Assumptions'!F21*F62","v":0},"t CO2e/t HRC steel",null,{"$f":"'Input Assumptions'!I21*F62","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":"F66*'Input Assumptions'!C24","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F66*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":5.1845444597746801E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F67*'Input Assumptions'!C27","v":14.442542338087117},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F67*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":7.9846626926281625E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F68*'Input Assumptions'!C17","v":0},0,"t/t HRC",{"$f":"F68*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F69*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F69*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F70*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F70*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F71*'Input Assumptions'!C31","v":0},0,"GJ/t HRC",{"$f":"F71*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F72*'Input Assumptions'!C34","v":14.442542338087117},{"$f":"F67","v":0.74275932024448021},"GJ/t HRC",{"$f":"F72*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":1.4442542338087115E-2},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F73*'Input Assumptions'!C35","v":0},{"$f":"F71","v":0},"GJ/t HRC",{"$f":"F73*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
[]
["Sintering",null,"Annual. CAPEX",2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F76*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F76*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F77*'Input Assumptions'!C27","v":3.1387911615445008},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F77*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":1.7353031135967451E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F78*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F78*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F79*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F79*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F80*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F80*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F81*'Input Assumptions'!C31","v":0},0,"GJ/t HRC",{"$f":"F81*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F82*'Input Assumptions'!C25","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F82*('Input Assumptions'!$F$25+'Input Assumptions'!$I$25)","v":0.1349922862310238},"t CO2e/t HRC"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F83*'Input Assumptions'!C34","v":3.1387911615445008},{"$f":"F77","v":0.16142354545086002},"GJ/t HRC",{"$f":"F83*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":3.1387911615445006E-3},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F84*'Input Assumptions'!C35","v":0},{"$f":"F81","v":0},"GJ/t HRC",{"$f":"F84*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
[]
["Stamping",null,"Annual. CAPEX",2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F87*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F87*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F88*'Input Assumptions'!C27","v":17.642878424367783},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F88*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":9.7539913574719014E-2},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F89*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F89*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F90*'Input Assumptions'!C28","v":0},0,"GJ/t HRC",{"$f":"F90*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F91*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F91*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F92*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F92*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t HRC"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F93*'Input Assumptions'!C34","v":17.642878424367783},{"$f":"F88","v":0.90734803325320013},"GJ/t HRC",{"$f":"F93*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":1.7642878424367781E-2},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F94*'Input Assumptions'!C35","v":0},{"$f":"F92","v":0},"GJ/t HRC",{"$f":"F94*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
[]
["Skin Mill",null,"Annual. CAPEX",1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F97*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F97*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F98*'Input Assumptions'!C27","v":0.86162894630633358},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F98*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":4.7635771745793013E-3},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F99*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F99*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F100*'Input Assumptions'!C28","v":0},0,"GJ/t HRC",{"$f":"F100*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F101*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F101*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F102*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F102*'Input Assumptions'!$F$30+'Input Assumptions'!$I$30","v":0},"t CO2e/t HRC"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F103*'Input Assumptions'!C34","v":0.86162894630633358},{"$f":"F98","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F103*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":8.6162894630633356E-4},"t CO2e/t HRC"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F104*'Input Assumptions'!C35","v":0},{"$f":"F102","v":0},"GJ/t HRC",{"$f":"F104*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)"]
["Natural Gas",null,null,null,{"$f":"F107*'Input Assumptions'!C24","v":3.5259285913365163E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$14","v":1.3613623904774195E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":1.0618626645723871E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F108*'Input Assumptions'!C27","v":2.6140048678264343},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$14","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":1.4451712626411855E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F109*'Input Assumptions'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F110*'Input Assumptions'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F111*'Input Assumptions'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F112*'Input Assumptions'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F113*'Input Assumptions'!C31","v":1.5806451612903225},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$14","v":4.7647683666709684E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F113*('Input Assumptions'!$F$31+'Input Assumptions'!$I$31)","v":4.3835868973372905E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F114*'Input Assumptions'!C32","v":9.6774193548387108E-2},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$14","v":3.4034059761935487E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F114*('Input Assumptions'!$F$32+'Input Assumptions'!$I$32)","v":3.0970994383361291E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F115*'Input Assumptions'!C34","v":2.6140048678264343},{"$f":"F108","v":0.13443453605964517},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F115*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":2.614004867826434E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F116*'Input Assumptions'!C35","v":0},{"$f":"F112","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F116*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
[]
["Extraction + Beneficiation (US Taconite)"]
["Natural Gas",null,null,null,{"$f":"F119*'Input Assumptions'!C24","v":8.7443029065145603E-2},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$15","v":3.3761787283840002E-2},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*('Input Assumptions'!$F$24+'Input Assumptions'!$I$24)","v":2.6334194081395201E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F120*'Input Assumptions'!C27","v":6.4827320722095561},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$15","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*('Input Assumptions'!$F$27+'Input Assumptions'!$I$27)","v":3.5840247313501397E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F121*'Input Assumptions'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*('Input Assumptions'!$F$17+'Input Assumptions'!$I$17)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F122*'Input Assumptions'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*('Input Assumptions'!$F$28+'Input Assumptions'!$I$28)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F123*'Input Assumptions'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F123*('Input Assumptions'!$F$29+'Input Assumptions'!$I$29)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F124*'Input Assumptions'!C31","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F124*('Input Assumptions'!$F$30+'Input Assumptions'!$I$30)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F125*'Input Assumptions'!C32","v":3.3600000000000003},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$15","v":0.11816625549344001},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F125*('Input Assumptions'!$F$31+'Input Assumptions'!$I$31)","v":1.0871295505396481E-2},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F126*'Input Assumptions'!C36","v":0},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/'Input Assumptions'!$B$15","v":8.4404468209600004E-3},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F126*('Input Assumptions'!$F$32+'Input Assumptions'!$I$32)","v":7.6808066070736E-4},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity (Future; Greener)",null,null,null,{"$f":"F127*'Input Assumptions'!C34","v":6.4827320722095561},{"$f":"F120","v":0.33339764942792},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F127*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":6.4827320722095558E-3},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (Future; Greener; IRA credits)",null,null,null,{"$f":"F128*'Input Assumptions'!C35","v":0},{"$f":"F124","v":0},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F128*('Input Assumptions'!$F$34+'Input Assumptions'!$I$34)","v":0},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Example - Low-C Elec","index":4,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":true,"merged":[]}
["BF-BOF Pathway to HRC"]
["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":"#REF!","v":{"$error":"#REF!"}},"$/t HRC"]
["BF + BOF Annualized",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"$/t HRC"]
[]
["On-Site Operations"]
["BF + BOF",null,null,{"$f":"D5*0.085","v":{"$error":"#REF!"}},"$/t HRC"]
["Sintering",null,null,{"$f":"D68+SUM(E69:E75)","v":7.9200977485457669},"$/t HRC",{"$nulls":5},{"$f":"SUM(H69:H75)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Hot Rolling",null,null,{"$f":"D60+SUM(E61:E66)","v":21.16407697280717},"$/t HRC",{"$nulls":5},{"$f":"SUM(H61:H66)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Stamping",null,null,{"$f":"D77+SUM(E78:E83)","v":19.642878424367783},"$/t HRC",{"$nulls":5},{"$f":"SUM(H78:H83)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Skin Mill",null,null,{"$f":"D85+SUM(E86:E91)","v":1.8616289463063336},"$/t HRC",{"$nulls":5},{"$f":"SUM(H86:H91)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
[]
[]
["Transportation",null,"Distance (mi)"]
["Barge",null,0,{"$f":"C17*#REF!*F17","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F17*#REF!*C17","v":{"$error":"#REF!"}},"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*#REF!*F18","v":{"$error":"#REF!"}},"$/t HRC steel",4,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F18*#REF!*C18","v":{"$error":"#REF!"}},"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*#REF!*F19","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t ore/t HRC steel",0,"t CO2e/t HRC steel",null,{"$f":"F19*#REF!*C19","v":{"$error":"#REF!"}},"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*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"CONVERT(1.462*1000000,\"BTU\",\"GJ\")","v":1.5424916565304403},"GJ/t HRC steel",{"$f":"F22*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F22*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F23*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"CONVERT(9.933*1000000,\"BTU\",\"GJ\")","v":10.479869784074461},"GJ/t HRC steel",{"$f":"F23*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F23*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F24*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"CONVERT(0.23*1000000,\"BTU\",\"GJ\")","v":0.24266284610260003},"GJ/t HRC steel",{"$f":"F24*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F24*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F25*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F25*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F25*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F26*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F26*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F26*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F27*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F27*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F27*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F28*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F28*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F28*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F29*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F29*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F29*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
[]
["Energy Inputs to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Natural gas",null,null,{"$f":"F32*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"CONVERT(0.334*1000000,\"BTU\",\"GJ\")","v":0.35238865477508002},"GJ/t HRC steel",{"$f":"F32*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F32*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Coke",null,null,{"$f":"F33*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F33*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F33*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electricity (2050 grid)",null,null,{"$f":"F34*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"CONVERT(0.11*1000000,\"BTU\",\"GJ\")","v":0.11605614378820002},"GJ/t HRC steel",{"$f":"F34*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F34*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil SMR Hydrogen (US)",null,null,{"$f":"F35*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F35*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F35*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil SMR+CCS Hydrogen (US)",null,null,{"$f":"F36*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F36*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F36*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen (US)",null,null,{"$f":"F37*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F37*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F37*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil Diesel",null,null,{"$f":"F38*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F38*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F38*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Fossil Gasoline",null,null,{"$f":"F39*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"GJ/t HRC steel",{"$f":"F39*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"F39*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
[]
["Feedstocks to Ironmaking Step ONLY (Blast Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F42*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F42*SUM(H105:H112)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F42","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F43*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",4,"t Fe/t HRC steel",{"$f":"F43*SUM(H115:H122)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F43","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F44*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"0.25*(#REF!)","v":{"$error":"#REF!"}},"t scrap/t HRC steel",{"$f":"#REF!*F44","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F44","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F45*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"#REF!*F45","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F45","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F46*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"#REF!*F46","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F46","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F47*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"#REF!*F47","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F47","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F48*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"150/2000","v":7.4999999999999997E-2},"t lime/t HRC steel",{"$f":"#REF!*F48","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F48","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
[]
["Feedstocks to Steelmaking Step ONLY (Basic Oxygen Furnace)"]
["Iron ore fines (imported)",null,null,{"$f":"F51*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F51*SUM(H105:H112)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F51","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Iron ore fines (US - Taconite)",null,null,{"$f":"F52*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t Fe/t HRC steel",{"$f":"F52*SUM(H115:H122)","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F52","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Scrap",null,null,{"$f":"F53*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",{"$f":"0.25*(#REF!)","v":{"$error":"#REF!"}},"t scrap/t HRC steel",{"$f":"#REF!*F53","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F53","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Biomass",null,null,{"$f":"F54*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t biomass/t HRC steel",{"$f":"#REF!*F54","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F54","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Biocharcoal",null,null,{"$f":"F55*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t biocharcoal/t HRC steel",{"$f":"#REF!*F55","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F55","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Electrolysis Hydrogen",null,null,{"$f":"F56*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t H2/t HRC steel",{"$f":"#REF!*F56","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F56","v":{"$error":"#REF!"}},"t CO2e/t HRC steel"]
["Lime",null,null,{"$f":"F57*#REF!","v":{"$error":"#REF!"}},"$/t HRC steel",0,"t lime/t HRC steel",{"$f":"#REF!*F57","v":{"$error":"#REF!"}},"t CO2e/t HRC steel",null,{"$f":"#REF!*F57","v":{"$error":"#REF!"}},"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*'Input Assumptions'!C24","v":1.721534634720054},{"$f":"CONVERT(0.63*1000000,\"BTU\",\"GJ\")","v":0.66468518715059999},"GJ/t HRC",{"$f":"F61*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F62*'Input Assumptions'!C27","v":14.442542338087117},{"$f":"CONVERT(1000000*0.704,\"BTU\",\"GJ\")","v":0.74275932024448021},"GJ/t HRC",{"$f":"F62*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F63*'Input Assumptions'!C17","v":0},0,"t/t HRC",{"$f":"F63*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F64*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F64*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F65*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F65*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F66*'Input Assumptions'!C31","v":0},0,"GJ/t HRC",{"$f":"F66*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
[]
["Sintering",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F69*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F69*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F70*'Input Assumptions'!C27","v":3.1387911615445008},{"$f":"CONVERT(1000000*0.153,\"BTU\",\"GJ\")","v":0.16142354545086002},"GJ/t HRC",{"$f":"F70*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F71*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F71*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F72*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F72*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F73*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F73*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F74*'Input Assumptions'!C31","v":0},0,"GJ/t HRC",{"$f":"F74*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F75*'Input Assumptions'!C25","v":2.7813065870012661},{"$f":"CONVERT(1.103*1000000,\"BTU\",\"GJ\")","v":1.1637266054398603},"GJ/t HRC",{"$f":"F75*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
[]
["Stamping",null,null,2,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F78*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F78*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F79*'Input Assumptions'!C27","v":17.642878424367783},{"$f":"CONVERT(1000000*0.86,\"BTU\",\"GJ\")","v":0.90734803325320013},"GJ/t HRC",{"$f":"F79*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F80*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F80*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F81*'Input Assumptions'!C28","v":0},0,"GJ/t HRC",{"$f":"F81*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F82*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F82*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F83*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F83*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
[]
["Skin Mill",null,null,1,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F86*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F86*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F87*'Input Assumptions'!C27","v":0.86162894630633358},{"$f":"CONVERT(1000000*0.042,\"BTU\",\"GJ\")","v":4.431234581004001E-2},"GJ/t HRC",{"$f":"F87*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F88*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F88*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F89*'Input Assumptions'!C28","v":0},0,"GJ/t HRC",{"$f":"F89*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F90*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F90*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F91*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F91*#REF!+#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
[]
["EAF",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F94*'Input Assumptions'!C24","v":0},0,"GJ/t HRC",{"$f":"F94*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Electricity",null,null,null,{"$f":"F95*'Input Assumptions'!C27","v":0},0,"GJ/t HRC",{"$f":"F95*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Biomass",null,null,null,{"$f":"F96*'Input Assumptions'!C17","v":0},0,"GJ/t HRC",{"$f":"F96*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC","Base value from GREET2 2022"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F97*'Input Assumptions'!C28","v":0},0,"GJ/t HRC",{"$f":"F97*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F98*'Input Assumptions'!C29","v":0},0,"GJ/t HRC",{"$f":"F98*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F99*'Input Assumptions'!C30","v":0},0,"GJ/t HRC",{"$f":"F99*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Coke",null,null,null,{"$f":"F100*'Input Assumptions'!C25","v":0},0,"GJ/t HRC",{"$f":"F100*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Scrap",null,null,null,{"$f":"F101*'Input Assumptions'!C16","v":0},0,"t/t HRC",{"$f":"F101*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
["Iron Ore",null,null,null,{"$f":"F102*'Input Assumptions'!C14","v":0},0,"t/t HRC",{"$f":"F102*#REF!","v":{"$error":"#REF!"}},"t CO2e/t HRC"]
[]
["Extraction + Beneficiation (Imported high quality)",null,null,null,"$/t HRC"]
["Natural Gas",null,null,null,{"$f":"F105*'Input Assumptions'!C24","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F105*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F106*'Input Assumptions'!C27","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F106*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F107*'Input Assumptions'!C17","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F107*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F108*'Input Assumptions'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F108*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F109*'Input Assumptions'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F109*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F110*'Input Assumptions'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F110*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F111*'Input Assumptions'!C31","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F111*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F112*'Input Assumptions'!C32","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F112*(#REF!+#REF!)","v":{"$error":"#REF!"}},"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*'Input Assumptions'!C24","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.008*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F115*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electricity",null,null,null,{"$f":"F116*'Input Assumptions'!C27","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.079*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F116*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Biomass",null,null,null,{"$f":"F117*'Input Assumptions'!C28","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F117*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR Hydrogen",null,null,null,{"$f":"F118*'Input Assumptions'!C29","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F118*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil SMR+CCS Hydrogen",null,null,null,{"$f":"F119*'Input Assumptions'!C30","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F119*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Electrolysis Hydrogen (US)",null,null,null,{"$f":"F120*'Input Assumptions'!C31","v":0},0,"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F120*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Diesel",null,null,null,{"$f":"F121*'Input Assumptions'!C32","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.028*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F121*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]
["Fossil Gasoline",null,null,null,{"$f":"F122*'Input Assumptions'!C36","v":{"$error":"#REF!"}},{"$f":"CONVERT(0.002*1000000,\"BTU\",\"GJ\")/#REF!","v":{"$error":"#REF!"}},"GJ/t Fe (adjusted for Fe content in ore)",{"$f":"F122*(#REF!+#REF!)","v":{"$error":"#REF!"}},"t CO2e/t Fe (adjusted for Fe content in ore)"]

{"sheet":"Comparison","index":5,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":28}
["Levelized Cost of Hot-Rolled Coil Comparison"]
[null,null,"CAPEX","Fixed OPEX","Electricity","Fuel","Feedstocks","Transportation"]
[null,"BF-BOF: Today's Grid",{"$f":"'Example - BF-BOF'!D9","v":59.165544664400912},{"$f":"SUM('Example - BF-BOF'!D65,'Example - BF-BOF'!D75,'Example - BF-BOF'!D86,'Example - BF-BOF'!D96)+'Example - BF-BOF'!D12","v":61.000000000000007},{"$f":"'Example - BF-BOF'!D23+'Example - BF-BOF'!D35+'Example - BF-BOF'!E67+'Example - BF-BOF'!E77+'Example - BF-BOF'!E88+'Example - BF-BOF'!E98","v":43.060932340404626},{"$f":"SUM('Example - BF-BOF'!D21:D28)-'Example - BF-BOF'!D23+SUM('Example - BF-BOF'!D33:D40)-'Example - BF-BOF'!D35+SUM('Example - BF-BOF'!E66:E71)-'Example - BF-BOF'!E67+SUM('Example - BF-BOF'!E76:E82)-'Example - BF-BOF'!E77+SUM('Example - BF-BOF'!E87:E92)-'Example - BF-BOF'!E88+SUM('Example - BF-BOF'!E97:E102)-'Example - BF-BOF'!E98","v":34.457470011940572},{"$f":"SUM('Example - BF-BOF'!D45:D51)","v":491.5},{"$f":"SUM('Example - BF-BOF'!D16:D18)","v":111}]
[null,"Your Tech: Today's Grid",{"$f":"'Your Tech - Edit This Sheet'!C9+'Your Tech - Edit This Sheet'!E133","v":0},{"$f":"'Your Tech - Edit This Sheet'!C12+SUM('Your Tech - Edit This Sheet'!E87,'Your Tech - Edit This Sheet'!E97,'Your Tech - Edit This Sheet'!E108,'Your Tech - Edit This Sheet'!E118)","v":0},{"$f":"'Your Tech - Edit This Sheet'!C24+'Your Tech - Edit This Sheet'!C57+'Your Tech - Edit This Sheet'!C89+'Your Tech - Edit This Sheet'!C99+'Your Tech - Edit This Sheet'!C110+'Your Tech - Edit This Sheet'!C120","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!C22:C29)-'Your Tech - Edit This Sheet'!C24+SUM('Your Tech - Edit This Sheet'!C32:C37)+SUM('Your Tech - Edit This Sheet'!C55:C60)-'Your Tech - Edit This Sheet'!C57+SUM('Your Tech - Edit This Sheet'!C63:C68)+SUM('Your Tech - Edit This Sheet'!C88:C93)-'Your Tech - Edit This Sheet'!C89+SUM('Your Tech - Edit This Sheet'!C98:C104)-'Your Tech - Edit This Sheet'!C99+SUM('Your Tech - Edit This Sheet'!C109:C114)-'Your Tech - Edit This Sheet'!C110+SUM('Your Tech - Edit This Sheet'!C119:C124)-'Your Tech - Edit This Sheet'!C120+SUM('Your Tech - Edit This Sheet'!C134:C139)-'Your Tech - Edit This Sheet'!C135","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!C40:C45)+SUM('Your Tech - Edit This Sheet'!C47:C52)+SUM('Your Tech - Edit This Sheet'!C71:C77)+SUM('Your Tech - Edit This Sheet'!C79:C84)","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!C16:C18)","v":0}]
[null,"BF-BOF: Low-C Grid",{"$f":"C31","v":59.165544664400912},61.000000000000007,43.060932340404626,{"$f":"SUM('Example - BF-BOF'!D21:D30)-SUM('Example - BF-BOF'!D23,'Example - BF-BOF'!D26,'Example - BF-BOF'!D29)+SUM('Example - BF-BOF'!D33:D42)-SUM('Example - BF-BOF'!D35,'Example - BF-BOF'!D38,'Example - BF-BOF'!D41)+SUM('Example - BF-BOF'!E66:E73)-SUM('Example - BF-BOF'!E67,'Example - BF-BOF'!E71,'Example - BF-BOF'!E72)+SUM('Example - BF-BOF'!E76:E84)-SUM('Example - BF-BOF'!E77,'Example - BF-BOF'!E83,'Example - BF-BOF'!E81)+SUM('Example - BF-BOF'!E87:E94)-SUM('Example - BF-BOF'!E88,'Example - BF-BOF'!E92,'Example - BF-BOF'!E93)+SUM('Example - BF-BOF'!E97:E104)-SUM('Example - BF-BOF'!E98,'Example - BF-BOF'!E103,'Example - BF-BOF'!E102)","v":34.457470011940579},{"$f":"G31","v":491.5},{"$f":"H31","v":111}]
[null,"Your Tech: Low-C Grid",0,0,0,{"$f":"SUM('Your Tech - Edit This Sheet'!C22:C37)-SUM('Your Tech - Edit This Sheet'!C24,'Your Tech - Edit This Sheet'!C27,'Your Tech - Edit This Sheet'!C30)+SUM('Your Tech - Edit This Sheet'!C55:C68)-SUM('Your Tech - Edit This Sheet'!C57,'Your Tech - Edit This Sheet'!C60,'Your Tech - Edit This Sheet'!C61)+SUM('Your Tech - Edit This Sheet'!C88:C95)-SUM('Your Tech - Edit This Sheet'!C89,'Your Tech - Edit This Sheet'!C93,'Your Tech - Edit This Sheet'!C94)+SUM('Your Tech - Edit This Sheet'!C98:C106)-SUM('Your Tech - Edit This Sheet'!C99,'Your Tech - Edit This Sheet'!C103,'Your Tech - Edit This Sheet'!C105)+SUM('Your Tech - Edit This Sheet'!C109:C116)-SUM('Your Tech - Edit This Sheet'!C110,'Your Tech - Edit This Sheet'!C114,'Your Tech - Edit This Sheet'!C115)+SUM('Your Tech - Edit This Sheet'!C119:C126)-SUM('Your Tech - Edit This Sheet'!C120,'Your Tech - Edit This Sheet'!C124,'Your Tech - Edit This Sheet'!C125)+SUM('Your Tech - Edit This Sheet'!C134:C144)-SUM('Your Tech - Edit This Sheet'!C135,'Your Tech - Edit This Sheet'!C139,'Your Tech - Edit This Sheet'!C143)","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!C40:C52)-'Your Tech - Edit This Sheet'!C44+SUM('Your Tech - Edit This Sheet'!C71:C84)-'Your Tech - Edit This Sheet'!C76","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!C16:C18)","v":0}]
[]
["GHG Emissions Comparison"]
[null,null,null,"Operations","Electricity","Fuel","Feedstocks","Transportation"]
[null,"BF-BOF: Today's Grid",null,{"$f":"SUM('Example - BF-BOF'!H66:H71)+SUM('Example - BF-BOF'!H87:H92)+SUM('Example - BF-BOF'!H97:H102)","v":0.23399556227332674},{"$f":"'Example - BF-BOF'!H23+'Example - BF-BOF'!K23+'Example - BF-BOF'!H35+'Example - BF-BOF'!K35","v":3.8562291413261007E-2},{"$f":"SUM('Example - BF-BOF'!H21:H28)-'Example - BF-BOF'!H23+SUM('Example - BF-BOF'!K21:K28)-'Example - BF-BOF'!K23+SUM('Example - BF-BOF'!H33:H40)-'Example - BF-BOF'!H35+SUM('Example - BF-BOF'!K33:K40)-'Example - BF-BOF'!K35","v":1.3634655592344682},{"$f":"SUM('Example - BF-BOF'!H107:H114)*('Example - BF-BOF'!F45+'Example - BF-BOF'!F55)+SUM('Example - BF-BOF'!H119:H126)*('Example - BF-BOF'!F46+'Example - BF-BOF'!F56)+SUM('Example - BF-BOF'!H47:H51)+SUM('Example - BF-BOF'!K47:K51)+SUM('Example - BF-BOF'!H57:H61)+SUM('Example - BF-BOF'!K57:K61)+SUM('Example - BF-BOF'!H76:H82)","v":0.36612248891797028},{"$f":"SUM('Example - BF-BOF'!H16:H18)+SUM('Example - BF-BOF'!K16:K18)","v":0.16078499999999996}]
[null,"Your Tech: Today's Grid",null,{"$f":"SUM('Your Tech - Edit This Sheet'!G88:G93)+SUM('Your Tech - Edit This Sheet'!G109:G114)+SUM('Your Tech - Edit This Sheet'!G119:G124)","v":0},{"$f":"'Your Tech - Edit This Sheet'!G24+'Your Tech - Edit This Sheet'!J24+'Your Tech - Edit This Sheet'!G57+'Your Tech - Edit This Sheet'!J57","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G22:G29)-'Your Tech - Edit This Sheet'!G24+SUM('Your Tech - Edit This Sheet'!G32:G37)+SUM('Your Tech - Edit This Sheet'!J22:J29)-'Your Tech - Edit This Sheet'!J24+SUM('Your Tech - Edit This Sheet'!J32:J37)+SUM('Your Tech - Edit This Sheet'!G55:G60)-'Your Tech - Edit This Sheet'!G57+SUM('Your Tech - Edit This Sheet'!G63:G68)+SUM('Your Tech - Edit This Sheet'!J55:J60)-'Your Tech - Edit This Sheet'!J57+SUM('Your Tech - Edit This Sheet'!J63:J68)","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G147:G154)*('Your Tech - Edit This Sheet'!E71+'Your Tech - Edit This Sheet'!E40)+SUM('Your Tech - Edit This Sheet'!G159:G166)*('Your Tech - Edit This Sheet'!E72+'Your Tech - Edit This Sheet'!E41)+SUM('Your Tech - Edit This Sheet'!G42:G45)+SUM('Your Tech - Edit This Sheet'!G47:G52)+SUM('Your Tech - Edit This Sheet'!J40:J45)+SUM('Your Tech - Edit This Sheet'!J47:J52)+SUM('Your Tech - Edit This Sheet'!G73:G77)+SUM('Your Tech - Edit This Sheet'!G79:G84)+SUM('Your Tech - Edit This Sheet'!J73:J77)+SUM('Your Tech - Edit This Sheet'!J79:J84)+SUM('Your Tech - Edit This Sheet'!G98:G104)","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G16:G18)+SUM('Your Tech - Edit This Sheet'!J16:J18)","v":0}]
[null,"BF-BOF: Low-C Elec Mix",null,{"$f":"SUM('Example - BF-BOF'!H66:H73)-'Example - BF-BOF'!H67-'Example - BF-BOF'!H71+SUM('Example - BF-BOF'!H87:H94)-'Example - BF-BOF'!H88-'Example - BF-BOF'!H92+SUM('Example - BF-BOF'!H97:H104)-'Example - BF-BOF'!H98-'Example - BF-BOF'!H102","v":8.4792494306508009E-2},{"$f":"'Example - BF-BOF'!H29+'Example - BF-BOF'!K29+'Example - BF-BOF'!H41+'Example - BF-BOF'!K41","v":6.9750914700988896E-3},{"$f":"SUM('Example - BF-BOF'!H21:H30)-'Example - BF-BOF'!H23-'Example - BF-BOF'!H26+SUM('Example - BF-BOF'!K21:K30)-'Example - BF-BOF'!K23-'Example - BF-BOF'!K26-'Example - BF-BOF'!K29-'Example - BF-BOF'!H29+SUM('Example - BF-BOF'!H33:H42)-'Example - BF-BOF'!H41-'Example - BF-BOF'!H38-'Example - BF-BOF'!H35+SUM('Example - BF-BOF'!K33:K42)-'Example - BF-BOF'!K41-'Example - BF-BOF'!K38-'Example - BF-BOF'!K35","v":1.3634655592344682},{"$f":"(SUM('Example - BF-BOF'!H107:H116)-'Example - BF-BOF'!H108-'Example - BF-BOF'!H112)*('Example - BF-BOF'!F45+'Example - BF-BOF'!F55)+(SUM('Example - BF-BOF'!H119:H128)-'Example - BF-BOF'!H120-'Example - BF-BOF'!H124)*('Example - BF-BOF'!F46+'Example - BF-BOF'!F56)+SUM('Example - BF-BOF'!H47:H52)-'Example - BF-BOF'!H50+SUM('Example - BF-BOF'!K47:K52)-'Example - BF-BOF'!K50+SUM('Example - BF-BOF'!H57:H62)-'Example - BF-BOF'!H60+SUM('Example - BF-BOF'!K57:K62)-'Example - BF-BOF'!K60++SUM('Example - BF-BOF'!H76:H84)-'Example - BF-BOF'!H77-'Example - BF-BOF'!H81","v":0.23447818797837996},{"$f":"SUM('Example - BF-BOF'!H16:H18)+SUM('Example - BF-BOF'!K16:K18)","v":0.16078499999999996}]
[null,"Your Tech: Low-C Elec Mix",null,{"$f":"SUM('Your Tech - Edit This Sheet'!G88:G95)-'Your Tech - Edit This Sheet'!G93-'Your Tech - Edit This Sheet'!G89+SUM('Your Tech - Edit This Sheet'!G109:G116)-'Your Tech - Edit This Sheet'!G114-'Your Tech - Edit This Sheet'!G110+SUM('Your Tech - Edit This Sheet'!G119:G126)-'Your Tech - Edit This Sheet'!G124-'Your Tech - Edit This Sheet'!G120","v":0},{"$f":"'Your Tech - Edit This Sheet'!G30+'Your Tech - Edit This Sheet'!J30+'Your Tech - Edit This Sheet'!G61+'Your Tech - Edit This Sheet'!J61","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G22:G37)-'Your Tech - Edit This Sheet'!G30-'Your Tech - Edit This Sheet'!G27-'Your Tech - Edit This Sheet'!G24+SUM('Your Tech - Edit This Sheet'!J22:J37)-'Your Tech - Edit This Sheet'!J30-'Your Tech - Edit This Sheet'!J27-'Your Tech - Edit This Sheet'!J24+SUM('Your Tech - Edit This Sheet'!G55:G68)-'Your Tech - Edit This Sheet'!G61-'Your Tech - Edit This Sheet'!G60-'Your Tech - Edit This Sheet'!G57+SUM('Your Tech - Edit This Sheet'!J55:J68)-'Your Tech - Edit This Sheet'!J61-'Your Tech - Edit This Sheet'!J60-'Your Tech - Edit This Sheet'!J57","v":0},{"$f":"(SUM('Your Tech - Edit This Sheet'!G147:G156)-'Your Tech - Edit This Sheet'!G152-'Your Tech - Edit This Sheet'!G148)*('Your Tech - Edit This Sheet'!E71+'Your Tech - Edit This Sheet'!E40)+(SUM('Your Tech - Edit This Sheet'!G159:G168)-'Your Tech - Edit This Sheet'!G164-'Your Tech - Edit This Sheet'!G160)*('Your Tech - Edit This Sheet'!E72+'Your Tech - Edit This Sheet'!E41)+SUM('Your Tech - Edit This Sheet'!G42:G52)-'Your Tech - Edit This Sheet'!G44+SUM('Your Tech - Edit This Sheet'!J42:J52)-'Your Tech - Edit This Sheet'!J44+SUM('Your Tech - Edit This Sheet'!G73:G84)-'Your Tech - Edit This Sheet'!G76+SUM('Your Tech - Edit This Sheet'!J73:J84)-'Your Tech - Edit This Sheet'!J76+SUM('Your Tech - Edit This Sheet'!G98:G106)-'Your Tech - Edit This Sheet'!G99-'Your Tech - Edit This Sheet'!G103","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G16:G18)+SUM('Your Tech - Edit This Sheet'!J16:J18)","v":0}]
[]
[]
[]
["GHG Emissions Comparison",null,"Extraction + Beneficiation + Agglomeration","Iron Ore Transport","Ironmaking","Steelmaking & Finishing"]
[null,"BF-BOF: Today's Grid",{"$f":"SUM('Example - BF-BOF'!H107:H114)*('Example - BF-BOF'!F45+'Example - BF-BOF'!F55)+SUM('Example - BF-BOF'!H119:H126)*('Example - BF-BOF'!F46+'Example - BF-BOF'!F56)+SUM('Example - BF-BOF'!H76:H82)","v":0.35279748891797025},{"$f":"H38","v":0.16078499999999996},{"$f":"SUM('Example - BF-BOF'!H21:H28)+SUM('Example - BF-BOF'!K21:K28)+SUM('Example - BF-BOF'!H47:H51)+SUM('Example - BF-BOF'!K47:K51)","v":1.3753905001180415},{"$f":"SUM('Example - BF-BOF'!H33:H40)+SUM('Example - BF-BOF'!K33:K40)+SUM('Example - BF-BOF'!H57:H61)+SUM('Example - BF-BOF'!K57:K61)+SUM('Example - BF-BOF'!H66:H71)+SUM('Example - BF-BOF'!H87:H92)+SUM('Example - BF-BOF'!H97:H102)","v":0.27395791280301451}]
[null,"Your Tech: Today's Grid",{"$f":"SUM('Your Tech - Edit This Sheet'!G147:G154)*('Your Tech - Edit This Sheet'!E71+'Your Tech - Edit This Sheet'!E40)+SUM('Your Tech - Edit This Sheet'!G159:G166)*('Your Tech - Edit This Sheet'!E72+'Your Tech - Edit This Sheet'!E41)+SUM('Your Tech - Edit This Sheet'!G98:G104)","v":0},{"$f":"H39","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G22:G29)+SUM('Your Tech - Edit This Sheet'!G32:G37)+SUM('Your Tech - Edit This Sheet'!J22:J29)+SUM('Your Tech - Edit This Sheet'!J32:J37)+SUM('Your Tech - Edit This Sheet'!G42:G45)+SUM('Your Tech - Edit This Sheet'!G47:G52)+SUM('Your Tech - Edit This Sheet'!J40:J45)+SUM('Your Tech - Edit This Sheet'!J47:J52)","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G55:G60)+SUM('Your Tech - Edit This Sheet'!G63:G68)+SUM('Your Tech - Edit This Sheet'!J55:J60)+SUM('Your Tech - Edit This Sheet'!J63:J68)+SUM('Your Tech - Edit This Sheet'!G73:G77)+SUM('Your Tech - Edit This Sheet'!G79:G84)+SUM('Your Tech - Edit This Sheet'!J73:J77)+SUM('Your Tech - Edit This Sheet'!J79:J84)+SUM('Your Tech - Edit This Sheet'!G88:G93)+SUM('Your Tech - Edit This Sheet'!G109:G114)+SUM('Your Tech - Edit This Sheet'!G119:G124)","v":0}]
[null,"BF-BOF: Low-C Elec Mix",{"$f":"(SUM('Example - BF-BOF'!H107:H116)-'Example - BF-BOF'!H108-'Example - BF-BOF'!H112)*('Example - BF-BOF'!F45+'Example - BF-BOF'!F55)+(SUM('Example - BF-BOF'!H119:H128)-'Example - BF-BOF'!H120-'Example - BF-BOF'!H124)*('Example - BF-BOF'!F46+'Example - BF-BOF'!F56)+SUM('Example - BF-BOF'!H76:H84)-'Example - BF-BOF'!H77-'Example - BF-BOF'!H81","v":0.22115318797837996},{"$f":"H40","v":0.16078499999999996},{"$f":"SUM('Example - BF-BOF'!H21:H30)-'Example - BF-BOF'!H23-'Example - BF-BOF'!H26+SUM('Example - BF-BOF'!K21:K30)-'Example - BF-BOF'!K23-'Example - BF-BOF'!K26+SUM('Example - BF-BOF'!H47:H52)-'Example - BF-BOF'!H50+SUM('Example - BF-BOF'!K47:K52)-'Example - BF-BOF'!K50","v":1.3540226883917847},{"$f":"SUM('Example - BF-BOF'!H33:H42)-'Example - BF-BOF'!H35-'Example - BF-BOF'!H38+SUM('Example - BF-BOF'!K33:K42)-'Example - BF-BOF'!K35-'Example - BF-BOF'!K38+SUM('Example - BF-BOF'!H57:H62)-'Example - BF-BOF'!H60+SUM('Example - BF-BOF'!K57:K62)-'Example - BF-BOF'!K60+SUM('Example - BF-BOF'!H66:H73)-'Example - BF-BOF'!H67-'Example - BF-BOF'!H71+SUM('Example - BF-BOF'!H87:H94)-'Example - BF-BOF'!H88-'Example - BF-BOF'!H92+SUM('Example - BF-BOF'!H97:H104)-'Example - BF-BOF'!H98-'Example - BF-BOF'!H102","v":0.1145354566192904}]
[null,"Your Tech, Low-C Elec Mix",{"$f":"(SUM('Your Tech - Edit This Sheet'!G147:G156)-'Your Tech - Edit This Sheet'!G152-'Your Tech - Edit This Sheet'!G148)*('Your Tech - Edit This Sheet'!E40+'Your Tech - Edit This Sheet'!E71)+(SUM('Your Tech - Edit This Sheet'!G159:G168)-'Your Tech - Edit This Sheet'!G164-'Your Tech - Edit This Sheet'!G160)*('Your Tech - Edit This Sheet'!E72+'Your Tech - Edit This Sheet'!E41)+SUM('Your Tech - Edit This Sheet'!G98:G106)-'Your Tech - Edit This Sheet'!G103-'Your Tech - Edit This Sheet'!G99","v":0},{"$f":"H41","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G22:G37)-'Your Tech - Edit This Sheet'!G27-'Your Tech - Edit This Sheet'!G24+SUM('Your Tech - Edit This Sheet'!J22:J37)-'Your Tech - Edit This Sheet'!J27-'Your Tech - Edit This Sheet'!J24+SUM('Your Tech - Edit This Sheet'!G42:G52)-'Your Tech - Edit This Sheet'!G44+SUM('Your Tech - Edit This Sheet'!J40:J52)-'Your Tech - Edit This Sheet'!J44","v":0},{"$f":"SUM('Your Tech - Edit This Sheet'!G55:G68)-'Your Tech - Edit This Sheet'!G60-'Your Tech - Edit This Sheet'!G57+SUM('Your Tech - Edit This Sheet'!J55:J68)-'Your Tech - Edit This Sheet'!J60-'Your Tech - Edit This Sheet'!J57+SUM('Your Tech - Edit This Sheet'!G73:G84)-'Your Tech - Edit This Sheet'!G76+SUM('Your Tech - Edit This Sheet'!J73:J84)-'Your Tech - Edit This Sheet'!J76+SUM('Your Tech - Edit This Sheet'!G88:G95)-'Your Tech - Edit This Sheet'!G93-'Your Tech - Edit This Sheet'!G89+SUM('Your Tech - Edit This Sheet'!G109:G116)-'Your Tech - Edit This Sheet'!G114-'Your Tech - Edit This Sheet'!G110+SUM('Your Tech - Edit This Sheet'!G119:G126)-'Your Tech - Edit This Sheet'!G124-'Your Tech - Edit This Sheet'!G120","v":0}]