Equation Q 4 Calculation Spreadsheet by zN26V1Q

VIEWS: 0 PAGES: 3

									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