Potential to Emit (PTE) Calculation Spreadsheets

These tools (in Microsoft Excel format) are designed to assist your facility in estimating its potential to emit (PTE) from various operations:

Painting/coating PTE

Tool to assist businesses in calculating the potential to emit air pollutants from a painting/coating operation. Designed for input based on purchase or usage amount. 

Welding PTE

Tool to assist businesses with calculating emissions from welding operations [both actual and potential to emit (PTE)]. Can be used to track 12-month rolling totals. Designed for entering data from purchasing records, equipment inventories, SDSs, or other supporting documentation.

Abrasive Blasting PTE

Tool to assist businesses in calculating PTE for new (or existing projects) to determine if a construction approval or permit would be (would have been) required.  It also contains a table for tracking and calculating a 12 month rolling total of actual abrasive media usage.    

Plasma/Laser Cutting PTE

Tool to assist businesses in calculating both the potential to emit (PTE) and actual emissions from the source. It is designed to calculate a 12-month rolling total based on actual hours operated during each month for each plasma-/laser-cutting activity. It can be used in two ways, and it is recommended that a copy of two spreadsheets be used: one for PTE of new projects and a second for facility-wide calculation of actual emissions from total operations.                                                                     

Boiler/furnace PTE

Tool to assist businesses in calculating the potential to emit air pollutants from a boiler or small furnace. Heat input capacity is entered in units of BTU/hour or horsepower.

Engine PTE

Tool to assist businesses in calculating the potential to emit air pollutants from an engine running on natural gas, gasoline, or diesel fuel.

Air curtain incinerator PTE

Tool to assist businesses in calculating the potential and actual air pollutant emissions from air curtain incinerator operations. The tool is designed to track hours of operation, amounts and types of materials burned, document ozone alert days, track performance test dates and document monthly qualitative assessments for the Class I operating permit.

Grain elevator PTE

These spreadsheets will guide country and terminal elevators through the process of determining the amount of PM and PM-10 their facility emits. It will calculate the potential-to-emit (for the entire facility and/or for new air-emitting equipment, operations, or structures) to indicate if a permit or approval is need.

K-State Pollution Prevention Institute
(800) 578-8898 | sbeap@ksu.edu
2323 Anderson Ave., Suite 300, Manhattan, KS 66506