Spreadsheet: cd3608b8-50c1-4ed4-a911-15f56149b64c
Sheet: Sheet1

LIQUEFIED PETROLEUM GAS (LPG) COMBUSTION EMISSIONS CALCULATOR - REVISION D 2/1/2010 - 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
 |  |  | 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.
 |  | Directions: Enter and select information in the boxes in the column on the right:
 |  | FIELDS |  |  |  |  |  | SELECTIONS
 |  | COMPANY NAME: |  |  |  |  |  | Facility Name, Inc.
 |  | FACILITY ID NUMBER: |  |  |  |  |  | 01/12/00999
 |  | PERMIT NUMBER |  |  |  |  |  | 9999R02
 |  | FACILITY CITY: |  |  |  |  |  | ANYTOWN
 |  | FACILITY COUNTY: |  |  |  |  |  | ANYCOUNTY
 |  | SPREADSHEET PREPARED BY: |  |  |  |  |  | Your Name
 |  | EMISSION SOURCE ID NO.: |  |  |  |  |  | ES-1
 |  | MAXIMUM [NAME] (MILLION BTU PER HOUR): |  |  |  |  |  | 25 |  | MMBTU/HR
 |  | TYPE OF BOILER: |  |  |  |  |  | INDUSTRIAL
 |  | (TYPE OVER NUMBER AT RIGHT IF YOU HAVE SITE SPECIFIC DATA) |  |  |  |  |  |  |  |  | DEFAULT VALUES AS FOLLOWS:
 |  | These fuel properties are not used for GHG calculations.  See below for GHG |  | FUEL HEATING VALUE (BTU/GAL): |  |  |  | 91000 | BTU/GAL |  | 90500 | BTU/GAL
 |  |  |  | PERCENT PROPANE: |  |  |  | 96.8 | % |  | 97.5 | %
 |  |  |  | PERCENT BUTANE: |  |  |  | 3.2 | % |  | 2.5 | %
 |  |  |  | SULFUR CONTENT: |  |  |  | 0.15 | GRAINS/100 FT3 |  | 0.1 | GRAINS/100 FT3
 |  |  |  | ANNUAL HOURS OF OPERATION: |  |  |  | 8760 | HOURS |  | 8760 | HOURS
 |  | ACTUAL YEARLY FUEL USAGE (GALLONS PER YEAR): |  |  |  |  |  | 9000 | GAL/YR
 |  | CALCULATED POTENTIAL YEARLY USAGE (GALLONS PER YEAR) |  |  |  |  |  | 2406593.406593407 | GAL/YR
 |  | REQUESTED ANNUAL LIMITATION (GALLONS PER YEAR) |  |  |  |  |  | 2406593.406593407 | GAL/YR
 |  |  | (TYPEOVER AS NECESSARY - DEFAULT IS POTENTIAL)
 |  | NOX CONTROL IF PRESENT (DEFAULT IS ZERO) |  |  |  |  |  | 50 | % |  | 0 | %
 |  | ADDITIONAL INFORMATION FOR GREENHOUSE GAS (GHG) EMISSIONS
 |  | ENTER CALCULATION TIER  from EPA Mandatory Reporting Rule (MRR) Subpart C -www.epa.gov/climatechange/emissions/ghgrulemaking.html |  |  |  |  |  |  |  |  |  |  |  |  | TIER SELECTED  for Greenhouse Gas Calculation Method
 |  | NOTE:   EF is "Emission Factor" |  |  |  |  |  |  |  |  |  |  |  |  |  | HHV is higher heating value of fuel (mmBTU per quantity of fuel); EF is Emission factor ([NAME] per Million Btu)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER SELECT = |  | 1
 |  | ENTER FUEL TYPE (PROPANE or BUTANE or LPG) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER 1:  DEFAULT HIGH HEAT VALUE AND DEFAULT EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER 2:   MEASURED HIGH HEAT VALUE (ANNUAL AVG) AND DEFAULT EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIER 3:   MEASURED CARBON CONTENT (ANNUAL AVG)
 |  | SINCE TIER 3 IS NOT BEING USED, |  |  |  |  |  | 2.67 |  | kg Carbon/gal
 |  | FUEL CARBON CONTENT WILL NOT BE USED |  |  |  |  |  |  |  |  |  |  |  |  | FUEL SELECTED for Greenhouse Gas Calculation Method
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Select = |  | 1
 |  | SINCE NOT USING TIER 2, THIS HHV IS NOT USED -- |  |  |  |  |  | 0.08 | [NAME]/gal |  |  |  |  |  |  |  | PROPANE
 |  | [NAME] (See below) IS USED |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BUTANE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LPG
 |  | NOTE:  When using TIER 1 or TIER 3, the above HHV will be overridden with the EPA DEFAULT HHV listed below:
 |  | DEFAULT VALUES BELOW FROM TABLE C-1, EPA MRR (http://www.epa.gov/climatechange/emissions/ghgrulemaking.html)
 |  | PROPANE |  | 0.091 | [NAME]/gal |  | THIS VALUE WILL BE USED FOR GHG calcuations- actual emissions
 |  | BUTANE |  | 0.101 | [NAME]/gal
 |  | LPG |  | 0.092 | [NAME]/gal
 |  | PROPANE |  | DEFAULT HHV OF |  | 0.091 | [NAME]/gal | THIS VALUE WILL BE USED FOR GHG calcuations- actual emissions
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3