These optional spreadsheets are provided to assist reporters in calculating emissions and in keeping records of these calculations.
Reporters are required to keep records of these calculations under 40 CFR 98.3(g) and additional subpartspecific provisions, but are not required to use these spreadsheets or to submit any spreadsheets to EPA.
Overview
This help page provides guidance for working with the supplemental Subpart Q calculation spreadsheets. The guidance provides stepbystep instructions for the following tasks:
 Selecting the Appropriate Calculation Spreadsheet
 Downloading a Calculation Spreadsheet
 General Information on Using a Calculation Spreadsheet
 Using the Equation Q1 Calculation Spreadsheet
 Using the Equation Q2 Calculation Spreadsheet
 Using the Equation Q3 Calculation Spreadsheet
 Using the Equation Q4 Calculation Spreadsheet
 Using the Equation Q5 Calculation Spreadsheet
 Using the Equation Q6 Calculation Spreadsheet
 Using the Equation Q7 Calculation Spreadsheet
 Using the Equation EF Approach Calculation Spreadsheet
Specific information on each of the spreadsheets is provided below:
Calculation Spreadsheet  Calculation Method  Selection Criteria:  Instructions 

Carbon Mass Balance  Taconite indurating furnace  
Carbon Mass Balance  Basic oxygen process furnace  
Carbon Mass Balance  Nonrecovery coke oven battery  
Carbon Mass Balance  Sinter process  
Carbon Mass Balance  Electric arc furnace (EAF)  
Carbon Mass Balance  Decarburization vessel  
Carbon Mass Balance  Direct reduction furnace  
Sitespecific emission factor approach  Exhaust Stack 
Selecting the Appropriate Calculation Spreadsheet
Subpart Q requires facilities to report annual carbon dioxide (CO_{2}) process emissions from each taconite indurating furnace, basic oxygen furnace, nonrecovery coke oven battery, coke pushing process sinter process, electric arc furnace, decarburization vessel, and direct reduction furnace or from each exhaust stack used for iron and steel production. To calculate emissions, you may use the carbon mass balance method for each process unit (furnace, coke, oven battery, vessel, etc.), or the sitespecific emission factor approach for each process unit used for iron and steel production.
Carbon Mass Balance Method
Carbon mass balance method calculations are based on the annual mass of inputs and outputs associated with the process and the annual average weight fraction of carbon in each input and output. Each process unit type has a unique Spreadsheet Tool for calculating emissions using the carbon mass balance method.
Equation Q1 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a taconite indurating furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q1, provided below:
(Equation Q1) 

Equation Q2 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a basic oxygen process furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q2, provided below:
(Equation Q2) 

Equation Q3 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a nonrecovery coke oven battery used in iron and steel production. This spreadsheet performs the calculation using Equation Q3, provided below:
(Equation Q3) 

Equation Q4 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a sinter process used in iron and steel production. This spreadsheet performs the calculation using Equation Q4, provided below:
(Equation Q4) 

Equation Q5 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from an electric arc furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q5, provided below:
(Equation Q5) 

Equation Q6 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a decarburization vessel used in iron and steel production. This spreadsheet performs the calculation using Equation Q6, provided below:
(Equation Q6) 

Equation Q7 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from a direct reduction furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q7, provided below:
(Equation Q7) 

SiteSpecific Emission Factor Approach
Sitespecific emission factor approach calculations are based on emission factors and feed rates derived from performance testing. Performance tests must measure CO_{2} emissions from all exhaust stacks for the process and measure either the feed rate of materials into the process, or the production rate from the process during the test.
EF Approach Calculation Spreadsheet. Use this spreadsheet to calculate annual CO_{2} emissions from each exhaust stack used in iron and steel production. This spreadsheet performs the calculation using the methodology described in 98.173(b)(2)(iii) and (iv) including the equations below:
(Equation Q8 EF Approach  EF) 

(Equation Q8 EF Approach  CO_{2}) 

Downloading a Calculation Spreadsheet
Calculation spreadsheets for Subpart Q may be downloaded by clicking one of the links in the first column of the table below. Users may also jump to instructions for each spreadsheet by clicking one of the links in the fourth column.
Calculation Spreadsheet  Calculation Method  Selection Criteria:  Instructions 

Carbon Mass Balance  Taconite indurating furnace  
Carbon Mass Balance  Basic oxygen process furnace  
Carbon Mass Balance  Nonrecovery coke oven battery  
Carbon Mass Balance  Sinter process  
Carbon Mass Balance  Electric arc furnace (EAF)  
Carbon Mass Balance  Decarburization vessel  
Carbon Mass Balance  Direct reduction furnace  
Sitespecific emission factor approach  Exhaust Stack 
Using a Spreadsheet to Make Calculations
The guidance provided in this section applies to each of the calculation spreadsheet for Subpart Q. Additional guidance is provided for each individual spreadsheet in the sections below.
Color coding
The calculation spreadsheets contain green input cells, gray informational cells, and redbordered results cells filled with yellow or white. Users should use green input cells to enter all data specific to their facility, unit, or process. Gray informational cells contain parameter names, column and row headings, equation constants and subtotals. Calculation results are displayed in redbordered results cells filled with yellow or white. For redbordered, yellowfilled results cells, the values in these cells should be entered in the appropriate and separate calculation spreadsheet (as directed below cell) where additional calculations will be made. For redbordered, white filled results cells, the values in these cells should be entered in eGGRT for the appropriate process units. All cells that are not green input cells are locked and cannot be modified.

Green input cell (data entry) 

Gray informational cells (locked) 

Redbordered, yellowfilled results cells (enter in appropriate and separate calculation spreadsheet) 

Redbordered, white filled results cells (enter in eGGRT) 
Stop and Warning Messages
The calculation spreadsheets will display a stop message if the user enters a value that is invalid or a warning message if the user enters a value outside the EPA estimated range for a particular data element. For invalid data entries, the stop messages will not allow a user to proceed and the user must reenter valid data before moving forward. For data entries that are outside the EPA estimated range for a particular data element, the warning messages will allow a user to proceed if the user deems the entered value to be accurate.
Multiple Units or Processes
Users with multiple unit should use separate Spreadsheet Tools for each unit. Users should not aggregate data for multiple process types when using these Spreadsheet Tools.
Using the Equation Q1 Calculation Spreadsheet
Use the Equation Q1 Calculation Spreadsheet to calculate annual CO_{2} emissions from a taconite indurating furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q1 Calculation Spreadsheet performs the calculations using Equation Q1 provided below.
(Equation Q1) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q1, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this taconite indurating furnace. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this furnace.
Using the Equation Q2 Calculation Spreadsheet
Use the Equation Q2 Calculation Spreadsheet to calculate annual CO_{2} emissions from a basic oxygen process furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q2 Calculation Spreadsheet performs the calculations using Equation Q2 provided below.
(Equation Q2) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q2, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this basic oxygen process furnace. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this furnace.
Using the Equation Q3 Calculation Spreadsheet
Use the Equation Q3 Calculation Spreadsheet to calculate annual CO_{2} emissions from a nonrecovery coke oven battery using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q3 Calculation Spreadsheet performs the calculations using Equation Q3 provided below.
(Equation Q3) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q3, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this nonrecovery coke oven battery. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this oven battery.
Using the Equation Q4 Calculation Spreadsheet
Use the Equation Q4 Calculation Spreadsheet to calculate annual CO_{2} emissions from a sinter process using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q4 Calculation Spreadsheet performs the calculations using Equation Q4 provided below.
(Equation Q4) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q4, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this sinter process. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this sinter process.
Using the Equation Q5 Calculation Spreadsheet
Use the Equation Q5 Calculation Spreadsheet to calculate annual CO_{2} emissions from an electric arc furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q5 Calculation Spreadsheet performs the calculations using Equation Q5 provided below.
(Equation Q5) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q5, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this electric arc furnace. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this furnace.
Using the Equation Q6 Calculation Spreadsheet
Use the Equation Q6 Calculation Spreadsheet to calculate annual CO_{2} emissions from a decarburization vessel using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q6 Calculation Spreadsheet performs the calculations using Equation Q6 provided below.
(Equation Q6) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q6, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The spreadsheet will calculate the annual CO_{2} emissions from this decarburization vessel. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this decarburization vessel.
Using the Equation Q7 Calculation Spreadsheet
Use the Equation Q7 Calculation Spreadsheet to calculate annual CO_{2} emissions from a direct reduction furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q7 Calculation Spreadsheet performs the calculations using Equation Q7 provided below.
(Equation Q7) 

Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Equation Data table.
If you have a process input or output other than CO_{2} in the exhaust gas that contains carbon that is not included in Equations Q7, enter the carbon and mass rate of each additional process input or output in the provided additional green input cells.
The calculation spreadsheet will calculate the annual CO_{2} emissions from this direct reduction furnace. The calculated value will be displayed in the redbordered cell at the bottom of the spreadsheet. This value should be entered in eGGRT for this furnace.
Using the Equation Q8 EF Approach Calculation Spreadsheet
Use the Equation Q8 EF Approach Calculation Spreadsheet to calculate annual CO_{2} emissions from an exhaust stack using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q8 EF Approach Calculation Spreadsheet performs the calculations using an equation to solve for the sitespecific emission factor and an equation to calculate CO_{2} emissions. These equations are provided below.




Begin by entering the facility name, your name, the unit name or identifier, reporting period, and any additional comments in the green input cells of the general information table located immediately below the equation in the spreadsheet. This is for your records.
Next, enter the requested information in the green input cells in the Input Data table.
The spreadsheet will first calculate the sitespecific emission factor for this stack and then use that value to calculate annual CO_{2} emissions from this exhaust stack. The calculated values will be displayed in the redbordered cells at the bottom of the spreadsheet. These values should be entered in eGGRT for this stack.