# Equation Q 4 Calculation Spreadsheet by zN26V1Q

VIEWS: 0 PAGES: 3

• pg 1
Subpart Q - Iron and Steel Production - Calculating CO2 Emissions for Sinter Processes Using Equation Q-4
OPTIONAL SPREADSHEET FOR FACILITY RECORDKEEPING PURPOSES
Version e-GGRT RY2011.R.01
Today's date 10/3/2012
Use one spreadsheet for each process. Make additional copies as needed.

This spreadsheet is protected and contains locked cells to ensure that you do not inadvertently alter any of the included formulas
and/or calculations. To remove this protection and alter this spreadsheet, right-click the "worksheet" tab near the bottom of the
screen and select “Unprotect Sheet.” When prompted for the password, type “GHG” and click "OK." Please note that making
changes to an unprotected sheet could result in incorrect calculations and that you are responsible for the accuracy of the data you
report to EPA. For additional help, visit the Microsoft Excel Support website (http://office.microsoft.com/en-us/excel-help).

Equation Q-4:
* [ Fg  * Cgf  *
44                         MW
CO2                                      * 0.001 
12                        MVC
Feed  * CFeed   Sinter  * CSinter   R  * CR ]
Facility Name:
Reporter Name:
Unit Name/ ID:
Reporting Period:
Comments:
Unit Type:                        Sinter Process

Input Data
[Fg] = Annual volume of the gaseous
fuel combusted (scf)
[Cgf] = Carbon content of the gaseous
fuel, from the fuel analysis results (kg C
per kg of fuel)
[MW] = Molecular weight of the
gaseous fuel (kg/kg-mole)
[Feed] = Annual mass of sinter feed
material (metric tons)
[CFeed] = Carbon content of the mixed
sinter feed materials that form the bed
entering the sintering machine, from the
carbon analysis results (percent by
weight, expressed as a decimal
fraction)
[Sinter] = Annual mass of sinter
produced (metric tons)
Subpart Q - Iron and Steel Production - Calculating CO2 Emissions for Sinter Processes Using Equation Q-4
OPTIONAL SPREADSHEET FOR FACILITY RECORDKEEPING PURPOSES
Version e-GGRT RY2011.R.01
Today's date 10/3/2012
[CSinter] = Carbon content of the sinter
pellets, from the carbon analysis results
(percent by weight, expressed as a
decimal fraction)
[R] = Annual mass of air pollution
control residue collected (metric tons)
[CR] = Carbon content of the air
pollution control residue, from the
carbon analysis results (percent by
weight, expressed as a decimal
fraction)

Inputs other than CO2 in the exhaust gas that contain carbon that are not included in Equations Q–4 (if applicable per 98.173(b)(1))
Space provided for up to 3 addition inputs. For additional inputs, use additional copies of this workbook and sum results before entering in e-GGRT.
[IMi] = Additional annual input mass (i)
other than CO2 in the exhaust gas
(metric tons)
[ICi] = Carbon content of the additional
annual input mass (i) (percent by
weight, expressed as a decimal fraction,
e.g., 95% = 0.95)
[IMj] = Additional annual input mass (j)
other than CO2 in the exhaust gas
(metric tons)
[ICj] = Carbon content of the additional
annual input mass (j) (percent by
weight, expressed as a decimal fraction,
e.g., 95% = 0.95)
[IMk] = Additional annual input mass (k)
other than CO2 in the exhaust gas
(metric tons)
[ICk] = Carbon content of the additional
annual input mass (k) (percent by
weight, expressed as a decimal fraction,
e.g., 95% = 0.95)

Outputs other than CO2 in the exhaust gas that contain carbon that are not included in Equations Q–4 (if applicable per 98.173(b)(1))
Subpart Q - Iron and Steel Production - Calculating CO2 Emissions for Sinter Processes Using Equation Q-4
OPTIONAL SPREADSHEET FOR FACILITY RECORDKEEPING PURPOSES
Version e-GGRT RY2011.R.01
Today's date 10/3/2012
Space provided for up to 3 addition outputs. For additional outputs, use additional copies of this workbook and sum results before entering in e-GGRT.
[OMi] = Additional annual output mass
(i) other than CO2 in the exhaust gas
(metric tons)
[OCi] = Carbon content of the additional
annual output mass (i) (percent by
weight, expressed as a decimal fraction,
e.g., 95% = 0.95)
[OMj] = Additional annual output mass
(j) other than CO2 in the exhaust gas
(metric tons)
[OCj] = Carbon content of the additional
annual output mass (j) (percent by
weight, expressed as a decimal fraction,
e.g., 95% = 0.95)
[OMk] = Additional annual output mass
(k) other than CO2 in the exhaust gas
(metric tons)
[OCk] = Carbon content of the
additional annual output mass (k)
(percent by weight, expressed as a
decimal fraction, e.g., 95% = 0.95)

Constants
[44/12] = Ratio of molecular weights,
44/12
CO2 to carbon
[MVC] = Molar volume conversion
Standard conditions are 68°F
factor (849.5 scf per kg-mole at             849.5
and 14.7 psia
standard conditions)
[0.001] = Conversion factor from kg to
0.001
metric tons

Annual CO2 Emissions (metric tons) from Equation Q-4

[CO2] = Annual CO2 mass emissions
0.0000000
from the sinter process (metric tons)

Enter this value in e-GGRT

To top