How do you calculate dust collector CFM?

Add the airflow of every hood that runs at the same time, plus any other simultaneous airflow, then add your reserve. Six hoods at 1,800 CFM plus 2,400 CFM is 13,200 CFM; a 10% reserve makes 14,520 CFM, the Dust Collector CFM calculator's own example.

How do you calculate filter area?

Divide the design airflow by the air-to-cloth ratio for the media online, then divide by the share of media available during cleaning for the installed area. 12,000 CFM at 2.0 CFM/ft² needs 6,000 ft² online; with 85% online while cleaning, 7,058.8 ft² installed, the Filter Area Sizing calculator's own example.

What air-to-cloth ratio should I use?

The one your filter supplier qualifies for your dust, media and cleaning method. It depends on the dust's particle size, loading and stickiness, so the workbook assumes no figure; the example ratios are invented. A lower ratio means more media and usually longer filter life.

Which hoods count as simultaneous?

Only hoods that run at the same time. A booth used on one shift and a grinder used on another should not both count toward the same peak. In the example every listed hood is assumed open together; leave out closed gates or list the worst combination.

How many filter elements do I need?

Installed media area divided by the area of one cartridge or bag, rounded up. In the example the weld fume collector needs 8,218 ft² and its cartridges carry 226 ft² each: 36.4, so 37 cartridges, which run at 1.97 CFM/ft² against the 2.0 qualified.

Is this a combustible dust or duct design?

No. It sizes airflow and filter media only. Duct velocity, static pressure, fan selection and explosion protection need a ventilation design and a combustible dust hazard analysis under the standards that apply to you.

Safety and People

Dust Collector Sizing Excel Template

Design airflow = simultaneous hoods × airflow per hood + other airflow, plus your reserve; filter media area = design airflow ÷ air-to-cloth ratio, plus what is off-line while it cleans. List every pickup point by collector and see each collector's design CFM, installed media area and filter element count.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This dust collector sizing template is a working Excel workbook for plant, facilities and EHS engineers and ventilation project managers. Every hood or pickup point that runs at the same time is one row under its collector; the workbook adds them up with your planned reserve and sizes the filter media at the air-to-cloth ratio your supplier qualifies. It ships with three collectors of a fictional fabricator, so every tile and chart is filled in when you open it.

In the example the weld fume collector serves six booths at 1,000 CFM, a robot cell at 2,500 CFM, four fume arms at 900 CFM and 600 CFM of duct leakage: 12,700 CFM, or 13,970 CFM with a 10% reserve. At a qualified 2.0 CFM/ft² it needs 6,985 ft² online and, with 85% of the media online during cleaning, 8,218 ft² installed: 37 cartridges of 226 ft².

Across the three collectors the plant needs 31,240 CFM, 14,881 ft² of media and 131 filter elements. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the sizing, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Pickups table, one row per group of identical hoods or pickup point: collector, simultaneous hoods, airflow per hood and other airflow, with a Check column
Setup list of collectors with each one's planned reserve, qualified air-to-cloth ratio, share of media online during cleaning and the area of one filter element
Sizing by collector: pickup airflow, reserve, design airflow, online media, installed media, offline allowance, filter elements and the air-to-cloth ratio with the elements fitted
Dashboard with four tiles (design airflow, installed media area, filter elements, pickup points) and charts of design airflow and media area by collector
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and both the Dust Collector CFM and Filter Area Sizing calculators (Self-check: PASS)
CSV with live formulas for the Pickups table; the sizing, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to size a new collector, to check a supplier's proposal against your own hood list, or to see whether an existing collector has room for another booth or machine.

How to use it

On Setup, type the site name and list each collector with its planned reserve, the air-to-cloth ratio your filter supplier qualifies, the share of media online while cleaning and the area of one cartridge or bag.
On Pickups, add one row per group of identical hoods or pickup point that runs at the same time.
Fix anything the Check column names.
Open the Dashboard: design airflow, installed media area and filter elements for every collector.

Frequently Asked Questions

How do you calculate dust collector CFM?: Add the airflow of every hood that runs at the same time, plus any other simultaneous airflow, then add your reserve. Six hoods at 1,800 CFM plus 2,400 CFM is 13,200 CFM; a 10% reserve makes 14,520 CFM, the Dust Collector CFM calculator's own example.
How do you calculate filter area?: Divide the design airflow by the air-to-cloth ratio for the media online, then divide by the share of media available during cleaning for the installed area. 12,000 CFM at 2.0 CFM/ft² needs 6,000 ft² online; with 85% online while cleaning, 7,058.8 ft² installed, the Filter Area Sizing calculator's own example.
What air-to-cloth ratio should I use?: The one your filter supplier qualifies for your dust, media and cleaning method. It depends on the dust's particle size, loading and stickiness, so the workbook assumes no figure; the example ratios are invented. A lower ratio means more media and usually longer filter life.
Which hoods count as simultaneous?: Only hoods that run at the same time. A booth used on one shift and a grinder used on another should not both count toward the same peak. In the example every listed hood is assumed open together; leave out closed gates or list the worst combination.
How many filter elements do I need?: Installed media area divided by the area of one cartridge or bag, rounded up. In the example the weld fume collector needs 8,218 ft² and its cartridges carry 226 ft² each: 36.4, so 37 cartridges, which run at 1.97 CFM/ft² against the 2.0 qualified.
Is this a combustible dust or duct design?: No. It sizes airflow and filter media only. Duct velocity, static pressure, fan selection and explosion protection need a ventilation design and a combustible dust hazard analysis under the standards that apply to you.