Filetype Excel XLSX | Posted on 16 Aug 2022 | 3 years ago
Authentication
digital resources
263x Filetype XLSX File size 0.14 MB Source: www.epa.gov
Sheet 1: Readme&change log
| Note: This calculator may not be used for State Implementation Plans (SIPs) and Conformity. Consult your EPA Regional Office or SIP and Conformity guidance documents.”This calculator was updated May 21 2008 to include an estimation tool for fireplaces that are being replaced |
| by gas firelogs. This fireplace calculator assumes that the emissions from the gas firelogs are zero. |
| The fireplace calculator is in the "FP Results table" worksheet. Directions on how to use are on that worksheet. |
| This calculator also estimates the amount of emissions avoided if a number of conventional woodstoves |
| are replaced by EPA-certified woodstoves. The calculator has a function where you can estimate |
| the number of conventional woodstoves that get converted to gas heating units. |
| This calculator accounts for the increased efficiency of the EPA certified woodstoves |
| This calculator was further updated on July 30 2008 to include HAPs. |
| Inputs to the calculations are documented. |
| All the inputs to the calculator can be changed to match other data, as needed. |
| Users of calculator do not have to use default inputs. If more reliable inputs are available, you can use them. |
| Full name of MARAMA report is "Task 6, Technical Memorandum 4 (Final Report), Control Analysis and Documentation |
| for Residential Wood Combustion in the MANE-VU Region" Prepared for MARAMA by OMNI Environmental Services, Inc, Dec 19, 2006. |
| http://www.omni-test.com/publications/Task%206%20Final%20Report.pdf |
| EPA's AP42 located on the web at |
| http://www.epa.gov/ttn/chief/ap42/index.html |
| Houck email - Jim Houck main point in his email to EPA staff is that the AP42 factor for Phase 2 certified stoves is based on testing in the late 1980's |
| and all on the first of the phase 2 models. Present day phase 2 models have improved. Emissions have improved from 19.6 to 12 lb/ton. |
| MARAMA report can be found online at |
| http://www.marama.org/visibility/ResWoodCombustion/RWC_FinalReport_121906.pdf |
| Report title; Control Analysis and Documentation for |
| Residential Wood Combustion in the MANE-VU Region, December 19, 2006 |
| NEI Documentation can be found on the web at |
| http://www.epa.gov/ttn/chief/net/2002inventory.html#documentation |
| Roy Huntley |
| huntley.roy@epa.gov |
| 919 541-1060 |
| Change log |
| May 20 2009 |
| Emission factors for PM10 and PM2.5 for fireplaces was changed to 22.2 lb/ton. The old value was from AP42 and |
| is superceded by a report from Huntley and Houck entitled |
| Updated Emissions Data for Revision of AP-42 Section 1.9, Residential Fireplaces, Dec 18 2002 |
| Beefed up some references |
| May 28 2009 |
| Changed the reference for the certified woodstove PM emission factor and moved some |
| references to the README worksheet. |
| Sept 24 2009 |
| Version 2 changes |
| Burn rates revised based on national average burn rates. Based on the U.S. Department of Agriculture (USDA) Forest Service documents from Midwest or Great Plainstate surveys |
| performed in the 1990s (publications available from http://www.ncrs.fs.fed.us/pubs/). |
| A summary of the survey results is available in a tab to this spreadsheet. |
| Oct 27 2009 changes - version 3 |
| Added a wood density worksheet. These values are state averages of oven dried wood densities. Source of data in the tab |
| These densities are used in the calculation to convert cords of wood to tons of wood |
| Added a burnrate tab and added the 3 tables explaining basis for burnrates used in calculator |
| Removed the "main" heat and "aesthetic" heat distinction for fireplaces. Now just use one burnrate for fireplaces. Simplifies equation. |
| Rename calculator tabs to "fireplace calculator" and "woodstove calculator" |
| Parameters for Calculation of Fireplace Changeout Benefit | Inputs | Input Description | ||||
| Wood density to convert cords to tons (tons oven dried wood/cord) = | 1.03 | avgerage wood density for Vermont | ||||
| # of Fireplaces changed to gas appliances = | 8 | input # of FP's being changed out (assume all go to gas or electric heaters) | ||||
| Burnrate for heating (cords/unit/yr) = | 1 | use appropriate burnrate or choose one from the tab labeled burnrates | ||||
| Directions for use: | Emission factors for Fireplaces(lb/ton) | Fireplace | Reference | |||
| Input in cell B2 the density of the firewood in tons of oven-dried wood per cord | CO | 253 | Compilation of Emission Factors, AP42, 5th edition | |||
| Input in cell B3 the number of fireplaces being changed out | SO2 | 0.4 | Compilation of Emission Factors, AP42, 5th edition | |||
| Input in cell B4 the burnrate per unit in cords/yr | NOX | 2.6 | Compilation of Emission Factors, AP42, 5th edition | |||
| Calculator will calculate emission reduction in the box below | VOC | 18.9 | MARAMA report, Dec 19, 2006 | |||
| PM2.5-PRI | 22.2 | Updated Emissions Data for Revision of AP-42 Section 1.9, Residential Fireplaces, Huntley Houck Dec 18 2002 | ||||
| PM10-PRI | 22.2 | Updated Emissions Data for Revision of AP-42 Section 1.9, Residential Fireplaces, Huntley Houck Dec 18 2002 | ||||
| NEI Pollutant Code | ||||||
| 600 | Dioxin teq | 7.87E-10 | MARAMA report, Dec 19, 2006 | |||
| 106990 | 1,3-butadiene | 0.1573 | MARAMA report, Dec 19, 2006 | |||
| Emission Reduction (tons) | 40 | 16-PAH | 0.75 | MARAMA report, Dec 19, 2006 | ||
| Pollutant | Total Emissions Avoided | 75 | 7-PAH | 0.22 | MARAMA report, Dec 19, 2006 | |
| CO | 1.04 | 75070 | Acetaldehyde | 1.06893111111111 | MARAMA report, Dec 19, 2006 | |
| SO2 | 0.00 | 107028 | Acrolein | 0.123398333333333 | MARAMA report, Dec 19, 2006 | |
| NOX | 0.01 | 71432 | Benzene | 0.68578 | MARAMA report, Dec 19, 2006 | |
| VOC | 0.08 | 50000 | Formaldehyde | 1.7933175 | MARAMA report, Dec 19, 2006 | |
| PM2.5-PRI | 0.09 | CH4 | Methane | 14.4133333333333 | MARAMA report, Dec 19, 2006 | |
| PM10-PRI | 0.09 | 91203 | Napthalene | 0.26502 | MARAMA report, Dec 19, 2006 | |
| Dioxin teq | 0.0000000000032 | |||||
| 1,3-butadiene | 0.00065 | |||||
| 16-PAH | 0.00309 | |||||
| 7-PAH | 0.00091 | |||||
| Acetaldehyde | 0.00440 | |||||
| Acrolein | 0.00051 | |||||
| Benzene | 0.00283 | |||||
| Formaldehyde | 0.00739 | |||||
| Methane | 0.05938 | |||||
| Napthalene | 0.00109 | |||||
| Total HAPS | 0.021 | |||||
| Parameters for Calculation of WS Changeout Benefit | Inputs | Input Description | |||
| Cords of Wood Burned per Woodstove = | 3 | See separate worksheet in this spreadsheet for EPA default values for burnrates | |||
| Wood density to convert cords to tons (tons oven dried wood/cord) = | 1.03 | use state average of wood density, based on oven dried wood. Densities available in this file in a separate worksheet. | |||
| Number of conventional stoves changed out = | 1 | ||||
| Woodstove % efficiency for conventional WS = | 54 | Compilation of Emission Factors, AP42, 5th edition | |||
| Woodstove % efficiency for certified WS = | 95 | Compilation of Emission Factors, AP42, 5th edition | |||
| Fraction assumed changed out to new Cert WS, remainder to non-wood burning heaters = | 1 | ||||
| NEI Pollutant Code | Emission factors (lb/ton) | Conv WS | Certified WS | Reference | |
| Directions for use | CO | 230.8 | 107 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| Input in cell B2 the number of cord burned per woodstove | SO2 | 0.4 | 0.4 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| input in cell B3 the wood density | NOX | 2.8 | 2 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| Input in cell B4 the number of conventional woodstoves being changed out | VOC | 53 | 15 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| Input in cell B7 the fraction of of new stoves that are EPA certified | PM2.5-PRI | 30.6 | Wood Stove and Fireplace Emissions Estimates Calculator: May not be used for State Implementation Plans (SIPs) and Conformity. Consult your EPA Regional Office or SIP and Conformity guidance documents.” | Conv Factor = AP-42; Certified EF = 060704 email from Jim Houck | |
| Emissions avoided displayed in box | PM10-PRI | 30.6 | 12 | Conv Factor = AP-42; Certified EF = 060704 email from Jim Houck | |
| 600 | Dioxin teq | 4.603E-09 | 7.94E-10 | MARAMA report | |
| 106990 | 1,3-butadiene | 0.4 | 0.18 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| 40 | 16-PAH | 0.64 | 0.3 | MARAMA report | |
| 75 | 7-PAH | 0.04 | 0.02 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| 75070 | Acetaldehyde | 0.62 | 0.54 | MARAMA report | |
| 107028 | Acrolein | 0.1 | 0.04 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| 71432 | Benzene | 2.16 | 0.96 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| 50000 | Formaldehyde | 1.46 | 0.98 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| CH4 | Methane | 64 | 28.4 | Section 1.10, Compilation of Emission Factors, AP42, 5th edition | |
| 91203 | Napthalene | 0.18 | 0.14 | MARAMA report | |
| Emission Avoided (tons) | |||||
| Pollutant | Total Emissions Avoided | ||||
| CO | 0.26 | ||||
| SO2 | 0.00 | ||||
| NOX | 0.00 | ||||
| VOC | 0.07 | ||||
| PM2.5-PRI | #VALUE! | ||||
| PM10-PRI | 0.04 | ||||
| Dioxin teq | 0.000000000006 | ||||
| 1,3-butadiene | 0.0005 | ||||
| 16-PAH | 0.0007 | ||||
| 7-PAH | 0.0000 | ||||
| Acetaldehyde | 0.0005 | ||||
| Acrolein | 0.0001 | ||||
| Benzene | 0.0025 | ||||
| Formaldehyde | 0.0014 | ||||
| Methane | 0.07 | ||||
| Napthalene | 0.0002 | ||||
| total HAPS = | 0.006 | ||||
no reviews yet
Please Login to review.
