Spreadsheet: b5800139-afe8-44e4-8d39-4840fec3625a
Sheet: Sheet1

NATURAL GAS COMBUSTION EMISSIONS CALCULATOR REVISION K  06/19/2012 - INPUT SCREEN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 |  |  | Instructions:  Enter emission source / facility data on the "INPUT" tab/screen.  The air emission results and summary of input data are viewed / printed on the "OUTPUT" tab/screen.  The different tabs are on the bottom of this screen.
 |  |  | This spreadsheet is for your use only and should be used with caution. DENR does not guarantee the accuracy of the information contained.  This spreadsheet is subject to continual revision and updating.  It is your responsibility to be aware of the most current information available.  DENR is not responsible for errors or omissions that may be contained herein.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ***  The area below is for calculation purposes to the left
 |  | Directions: Enter and select information in the boxes in the column on the right:
 |  | FIELDS |  |  |  |  |  | SELECTIONS |  |  |  |  |  |  | SELECTION SUMMARY AND SOME BTU CALCULATIONS
 |  | COMPANY NAME: |  |  |  |  |  | Facility Name, INC.
 |  | FACILITY ID NUMBER: |  |  |  |  |  | 01/12/00999 |  |  |  |  |  |  | TYPE SELECTION = |  | 2 | SMALL BOILER (<100 mmBTU/HR)
 |  | PERMIT NUMBER |  |  |  |  |  | 9999R02 |  |  |  |  |  |  |  | 1 = | LARGE WALL-FIRED BOILER (> 100 mmBTU/HR)
 |  | FACILITY CITY: |  |  |  |  |  | ANYTOWN |  |  |  |  |  |  |  | 2 = | SMALL BOILER (<100 mmBTU/HR)
 |  | FACILITY COUNTY: |  |  |  |  |  | ANYCOUNTY |  |  |  |  |  |  |  | 3 = | TANGENTIAL FIRED BOILER (ALL SIZES)
 |  | SPREADSHEET PREPARED BY: |  |  |  |  |  | Your Name |  |  |  |  |  |  |  | 4 = | RESIDENTIAL FURNACE (<0.3 mmBTU/HR)
 |  | EMISSION SOURCE ID NO.: |  |  |  |  |  | ES-1 |  |  |  |  |  |  | NSPS |  |  | >250MMBtu/hr? |  | 0
 |  | MAXIMUM [NAME] (MILLION BTU PER HOUR): |  |  |  |  |  | 50 |  | mmBTU/HR |  |  |  |  |  |  | After | 1971-08-17 00:00:00 | ? | 1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If both 0, then Pre-NSPS |  |  | OR
 |  | TYPE OF BOILER: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | >100MMBtu/hr? |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | After | 1984-06-19 00:00:00 | ? | 1 | 0
 |  | DOES THE SOURCE ALSO BURN COAL OR FUEL OIL? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dual fuel boiler? |  | 1 | Yes
 |  | DATE OF CONSTRUCTION: |  |  |  |  |  | 2000-05-01 00:00:00 |  |  |  |  |  |  |  |  | 1= | Yes
 |  |  |  |  |  |  |  | (mm/dd/yyyy) |  |  |  |  |  |  |  |  | 2= | No
 |  | ADDITIONAL INFORMATION FOR GREENHOUSE GAS (GHG) EMISSIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTROL SELECT = |  | 1 | NO CONTROL
 |  | ENTER Calculation Tier from EPA Mandatory Reporting Rule (MRR)* Subpart C |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 = | NO CONTROL
 |  | * See http://www.epa.gov/climatechange/emissions/ghgrulemaking.html |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 = | LOW [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 = | **********
 |  | SINCE TIER 3 IS NOT BEING USED, DO NOT  ENTER FUEL CARBON CONTENT |  |  |  |  |  |  |  | 0.75 |  |  |  |  |  | 4 = | LOW [NAME]
 |  | SINCE TIER 3 IS NOT BEING USED, DO NOT  ENTER MOLECULAR WEIGHT |  |  |  |  |  |  |  | 19 |  | [NAME] |  |  | TIER SELECTED  for Greenhouse Gas Calculation Method
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HHV is higher heating value of fuel (mmBTU per quantity of fuel); EF is Emission factor ([NAME] per Million Btu)
 |  | FUEL HEATING VALUE |  |  |  |  |  |  |  |  |  |  |  |  | TIER SELECT = |  | 1
 |  | ANNUAL AVG MEASURED FUEL HEATING VALUE (BTU/SCF): |  |  |  |  |  | 1020 | BTU/SCF |  |  |  |  |  |  |  | TIER 1:  DEFAULT HHV AND DEFAULT EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER 2:   MEASURED HHV (ANNUAL AVG) AND DEFAULT EF
 |  | DEFAULT  FUEL HEATING VALUE (BTU/SCF)  -- will be used for GHG calculations under TIER 1 approach |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER 3:   MEASURED CARBON CONTENT (ANNUAL AVG)
 |  |  | 1028 | BTU/SCF | default value is from EPA's mandatory reporting rule, Table C-1, "Natural Gas Pipeline (Weighted U.S. Average)"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE:  For TIER 3, Carbon content and MW must be measured (and the annual avge must be computed).
 |  | USAGE AND OTHER SOURCE-SPECIFIC DATA |  |  |  |  |  |  |  |  |  |  |  |  | Reasonable value for Carbon content (http://www.epa.gov/appdstar/pdf/brochure.pdf) for natural gas is 0.0149 kg Carbon / scf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reasonable value for MW  is 19 kg / kg-mole
 |  | ACTUAL YEARLY FUEL USAGE (MILLION SCF): |  |  |  |  |  | 50 | MILLION SCF |  |  |  |  |  | FUEL HEATING VALUE: |  |  | 1020 | BTU/SCF
 |  | CALCULATED POTENTIAL YEARLY USAGE (MILLION SCF) |  |  |  |  |  | 429.4117647058824 | MILLION SCF
 |  | REQUESTED ANNUAL LIMITATION (MILLION SCF) |  |  |  |  |  | 429.4117647058824 | MILLION SCF | (TYPEOVER IF NECESSARY - DEFAULT IS POTENTIAL)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] mmBTU: |  |  |  | 50
 |  | DAILY HOURS OF OPERATION: |  |  |  |  |  | 24 | HOURS |  |  |  |  |  | DAILY mmBTU: |  |  |  | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARLY ACTUAL mmBTU: |  |  |  | 51000
 |  | TYPE OF EMISSION CONTROL: |  |  |  |  |  |  |  |  |  |  |  |  | YEARLY POTENTIAL mmBTU: |  |  |  | 438000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARLY LIMITED POTENTIAL mmBTU: |  |  |  | 438000
 |  | IS SNCR APPLIED TO THE BOILER? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SNCR= | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1= | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2= | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3