Excerpt Include |
---|
| TBSAND:Spreadsheet Usage WarningTBSAND: |
---|
| Spreadsheet Usage Warning |
---|
nopanel | true |
---|
|
...
This help page provides guidance for working with the supplemental Subpart K Calculation Spreadsheet. The guidance provides step-by-step instructions for the following tasks:
- Using Subpart K Calculation Spreadsheets#Downloading Downloading the Calculation Spreadsheet
- Using Subpart K Calculation Spreadsheets#General General Information on Using a Calculation Spreadsheet
- Using Subpart K Calculation Spreadsheets#Using the Equation K-1, K-3 Calculation Spreadsheet
...
...
the Calculation Spreadsheet | | Downloading the |
---|
|
...
...
The calculation spreadsheet for Subpart K may be downloaded by clicking the link in the first column of the table below. Users may also jump to instructions for each calculation spreadsheet by clicking the link in the second column.
...
Anchor |
---|
| General Information on Using a Calculation Spreadsheet |
---|
| General |
---|
|
...
...
...
...
...
...
The guidance provided in this section applies to calculation spreadsheets for all subparts. Additional guidance specific to Subpart K is provided in the following section.
Include Page |
---|
| TBSAND:Spreadsheet Color CodingTBSAND: |
---|
| Spreadsheet Color Coding |
---|
|
Include Page |
---|
| TBSAND:Spreadsheet Stop and Warning MessagesTBSAND: |
---|
| Spreadsheet Stop and Warning Messages |
---|
|
...
Anchor |
---|
| Using the Equation K-1, K-3 Calculation Spreadsheet |
---|
| Using |
---|
|
...
...
...
...
...
...
Use the Equation K-1, K-3 Calculation Spreadsheet to calculate the annual CO2 and CH4 process emissions from an electric arc furnace. A separate spreadsheet is to be used for each furnace. Users should not use aggregated data from multiple furnaces in a single calculation spreadsheet. The Equation K-1, K-3 Calculation Spreadsheet performs the calculations using Equations K-1 and K-3, provided below (see calculation spreadsheet for definitions of variables).
Image Removed Image Added |
---|
(Equation K-3) |
Image Removed Image Added |
Begin by entering the facility name, your name, the furnace name or identifier, the reporting period and any additional comments in the green input cells of the General Information table located immediately below the equations in the calculation spreadsheet. This is for your records.
Image Removed
Image Added
Next, enter the requested information in the green input cells of the input data tables.
Image Added
Image Removed
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
Image Removed
Image Added
The calculation spreadsheet will then calculate the annual CO2 and CH4 process emissions from this electric arc furnace. The calculated values will be displayed in red-bordered cells in the K-1, K-3 Results tables at the bottom of the spreadsheet. This value should be entered in e-GGRT for this furnace.
Image Removed
Image Added
Back to Top