SBEAP has developed a series of Microsoft Excel spreadsheets to help small businesses determine if they need an air emissions permit and/or track compliance with their current air emissions permit. Some spreadsheets will require manipulation to best represent the materials used at each facility.
Abrasive blasting. Determine potential emissions for blasting activities.
Aggregate, non-metallic minerals. Determine potential and actual emissions at sand and gravel operations using the air emissions calculator and record compliance with the general non-metallic mineral processing permit with the compliance calendar.
- Aggregate: sand and gravel air emissions calculator (p-sbap5-30)
- Aggregate facility compliance calendar (p-sbap-02)
Asphalt. Track actual monthly emissions from hot mix asphalt plants.
Boilers. Determine potential and actual emissions for permits for natural gas, fuel oil, propane, coal and wood-fired boilers.
Coatings/painting. Determine actual air emissions from painting and coating operations.
Commercial lawn mowers. Estimate air pollution from large commercial gasoline lawn mowers.
Electroplating. Determine potential emissions for an electroplating shop.
- Electroplating Potential to Emit Calculations
- Calculating PTE for Plating
- Example: Potential to emit calculations for a plating shop
Engines. Determine potential and actual emissions from diesel and gasoline engines and natural gas turbines for permitting purposes.
Fiberglass. Determine potential and actual emissions from fiberglass operations.
Foundry. Determine actual emissions from iron foundry operations. These spreadsheets can be changed for other types of metal alloys.
- Foundry Actual Monthly Emissions Criteria Pollutant Emissions
- Directions for Using Foundry.xls to Track Registration Permit Option D Compliance (2005)
Gasoline storage tank. Estimate emissions reductions from installing Stage 1 Vapor Recovery on a storage tank that dispenses gasoline blends.
Grain elevators. Determine potential and actual air emissions from a grain elevator for permitting purposes.
Hazardous air pollutants and air toxics. Search for HAPs and other air toxics by name or CAS number.
Insignificant facility potential to emit tool. Use this spreadsheet to calculate emissions to help determine eligibility as an insignificant facility under Minn. R. 7008.2600.
Mechanical finishing. Use this spreadsheet to calculate emissions to help determine applicability under Minn. R. 7008.4110 as a conditionally insignificant activity.
Passenger car to electric vehicle. Estimates emissions reductions from converting miles normally driven in an internal combustion engine gasoline passenger car to miles in an electric vehicle.
Printing. Calculate actual emissions from printing operations.
Registration Option C. Track use of boilers, engines, and VOC-containing material to calculate your Option C eligibility number.
Registration Option D. Calculate and track 12-month rolling sums.
- Calculating 12-month rolling sums (p-sbap5-34)
- 12-month rolling sums for Option D air permit (p-sbap5-34a)
Small engines. Estimate air pollution from gasoline-2 cycle oil powered hand-held equipment (e.g., chainsaws, leafblowers, and weedwackers, etc.)
Storage tanks. Determine potential and actual air emissions for various storage tanks.
- Fixed roof, horizontal, above and underground (p-sbap5-42h)
- Fixed roof, vertical, cone and dome (p-sbap5-42v)
- Floating roof tanks and additional details for storage tank emission calculations
VOC and HAP total. Calculate annual volatile organic compound (VOC) and hazardous air pollutant (HAP) total emissions for conditionally exempt coating and auto body facilities.
Woodworking facility. Use this spreadsheet to calculate emissions to help determine eligibility under Minn. R. 7008.2500 as a conditionally exempt source.