Overview

This help page provides guidance for working with the supplemental Subpart Q calculation spreadsheets. The guidance provides step-by-step instructions for the following tasks:

• Selecting the Appropriate Calculation Spreadsheet
• Downloading a Calculation Spreadsheet
• General Information on Using a Calculation Spreadsheet
• Using the Equation Q-1 Calculation Spreadsheet
• Using the Equation Q-2 Calculation Spreadsheet
• Using the Equation Q-3 Calculation Spreadsheet
• Using the Equation Q-4 Calculation Spreadsheet
• Using the Equation Q-5 Calculation Spreadsheet
• Using the Equation Q-6 Calculation Spreadsheet
• Using the Equation Q-7 Calculation Spreadsheet
• Using the Equation EF Approach Calculation Spreadsheet

Specific information on each of the spreadsheets is provided below:

Selecting the Appropriate Calculation Spreadsheet

Subpart Q requires facilities to report annual carbon dioxide (CO₂) process emissions from each taconite indurating furnace, basic oxygen furnace, non-recovery 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 site-specific 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 Q--1 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a taconite indurating furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q-1, provided below:

Equation Q--2 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a basic oxygen process furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q-2, provided below:

Equation Q--3 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a non-recovery coke oven battery used in iron and steel production. This spreadsheet performs the calculation using Equation Q-3, provided below:

Equation Q--4 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a sinter process used in iron and steel production. This spreadsheet performs the calculation using Equation Q-4, provided below:

Equation Q--5 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from an electric arc furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q-5, provided below:

Equation Q--6 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a decarburization vessel used in iron and steel production. This spreadsheet performs the calculation using Equation Q-6, provided below:

Equation Q--7 Calculation Spreadsheet. Use this spreadsheet to calculate annual CO₂ emissions from a direct reduction furnace used in iron and steel production. This spreadsheet performs the calculation using Equation Q-7, provided below:

Site-Specific Emission Factor Approach

Site-specific emission factor approach calculations are based on emission factors and feed rates derived from performance testing. Performance tests must measure CO₂ 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₂ 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:

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.

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.

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 Q-1 Calculation Spreadsheet

Use the Equation Q-1 Calculation Spreadsheet to calculate annual CO₂ emissions from a taconite indurating furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-1 Calculation Spreadsheet performs the calculations using Equation Q-1 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--1, 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₂ emissions from this taconite indurating furnace. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this furnace.

Using the Equation Q-2 Calculation Spreadsheet

Use the Equation Q-2 Calculation Spreadsheet to calculate annual CO₂ emissions from a basic oxygen process furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-2 Calculation Spreadsheet performs the calculations using Equation Q-2 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--2, 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₂ emissions from this basic oxygen process furnace. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this furnace.

Using the Equation Q-3 Calculation Spreadsheet

Use the Equation Q-3 Calculation Spreadsheet to calculate annual CO₂ emissions from a non-recovery coke oven battery using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-3 Calculation Spreadsheet performs the calculations using Equation Q-3 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--3, 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₂ emissions from this non-recovery coke oven battery. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this oven battery.

Using the Equation Q-4 Calculation Spreadsheet

Use the Equation Q-4 Calculation Spreadsheet to calculate annual CO₂ emissions from a sinter process using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-4 Calculation Spreadsheet performs the calculations using Equation Q-4 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--4, 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₂ emissions from this sinter process. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this sinter process.

Using the Equation Q-5 Calculation Spreadsheet

Use the Equation Q-5 Calculation Spreadsheet to calculate annual CO₂ emissions from an electric arc furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-5 Calculation Spreadsheet performs the calculations using Equation Q-5 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--5, 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₂ emissions from this electric arc furnace. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this furnace.

Using the Equation Q-6 Calculation Spreadsheet

Use the Equation Q-6 Calculation Spreadsheet to calculate annual CO₂ emissions from a decarburization vessel using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-6 Calculation Spreadsheet performs the calculations using Equation Q-6 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--6, 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₂ emissions from this decarburization vessel. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this decarburization vessel.

Using the Equation Q-7 Calculation Spreadsheet

Use the Equation Q-7 Calculation Spreadsheet to calculate annual CO₂ emissions from a direct reduction furnace using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-7 Calculation Spreadsheet performs the calculations using Equation Q-7 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 Equation Data table.

If you have a process input or output other than CO₂ in the exhaust gas that contains carbon that is not included in Equations Q--7, 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₂ emissions from this direct reduction furnace. The calculated value will be displayed in the red-bordered cell at the bottom of the spreadsheet. This value should be entered in e-GGRT for this furnace.

Using the Equation Q-8 EF Approach Calculation Spreadsheet

Use the Equation Q-8 EF Approach Calculation Spreadsheet to calculate annual CO₂ emissions from an exhaust stack using the carbon mass balance method. Use a separate spreadsheet for each furnace. The Equation Q-8 EF Approach Calculation Spreadsheet performs the calculations using an equation to solve for the site-specific emission factor and an equation to calculate CO₂ 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 site-specific emission factor for this stack and then use that value to calculate annual CO₂ emissions from this exhaust stack. The calculated values will be displayed in the red-bordered cells at the bottom of the spreadsheet. These values should be entered in e-GGRT for this stack.

Back to Top