How do you calculate blast media consumption?

Work out the media circulated (feed rate x 60 x blast hours, where blast hours = area / coverage rate), take off what the reclaim system recovers and the separator accepts, and add any initial charge. 10,000 ft² at 250 ft²/h and 5 lb/min circulates 12,000 lb; at 85% recovery and 90% yield 9,180 lb is reused, so with a 500 lb charge you buy 3,320 lb, the Blast Media Consumption calculator's own example.

Why is circulated media so much more than what I buy?

On a recycling system the same abrasive goes through the nozzle many times. Only what the reclaim system misses and the separator rejects has to be replaced, plus the charge that fills the system.

What coverage rate should I use?

The accepted area per active nozzle hour from comparable work on similar steel, condition and standard, not a theoretical rate. It sets the blast hours and so the media circulated.

How is the target status worked out?

Fresh media per square foot is compared with the media's target on Setup: On target at or below it, Near target up to the near band over (20% in the example), Above target beyond. Your targets come from past jobs on your own system.

Does it predict surface profile or cleanliness?

No. It is a mass balance of the media. Profile, cleanliness and coating adhesion depend on the media, pressure and technique, and the number of times a media can be recycled is for the supplier to confirm.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test jobs and shows Self-check: PASS.

Industry Cost Kits

Blast Media Consumption Excel Template

Fresh blast media = initial charge + media circulated − media reused, where circulated = feed × blast hours and reused = circulated × recovery × separator yield. Give every blasting job a row and see the fresh abrasive it needs, its cost per square foot, and which jobs use more than their media's target.

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 blast media consumption template is a working Excel workbook for blasting and coating supervisors, estimators and buyers. Each blast job is one row with its area, the accepted coverage rate, the measured media feed, how much of the circulated media the reclaim system recovers and the separator accepts, and any initial charge to fill the system. The workbook gives the fresh media to buy, as a total and per square foot, prices it, and compares it with each media's target. Areas are in square feet and media in pounds, as in the calculator. It ships with ten jobs and three media at a fictional blast and paint shop, so every tile and chart is filled in when you open it.

In the example a 10,000 ft² tank shell at 250 ft² an hour is 40 hours of blasting, circulating 12,000 lb of garnet at 5 lb a minute. At 85% recovery and 90% separator yield, 9,180 lb is reused; with a 500 lb initial charge the job needs 3,320 lb of fresh garnet, 0.33 lb/ft², under its 0.40 target. Steel grit on floor gratings is at 90% recovery instead of 97% because grit falls through the openings, and needs 0.33 lb/ft² against a 0.12 target. A small valve job carries a 300 lb fresh charge after a media change, more than its blasting loses.

Order fresh media, not circulated media: on a reclaim system the circulated figure is many times what you buy. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your shop, currency and near band, and the blast media with their price per pound and target fresh media per square foot
Jobs table, one row per blast job: surface, media, blast area, effective coverage rate, media feed, recovery, separator yield and initial charge, with a Check column
Per job: active blast hours, media circulated, reused and lost, fresh media, fresh media per square foot, media cost and cost per square foot, and a status in words
Dashboard with four tiles (jobs, fresh media, fresh media cost, jobs above target), fresh media per square foot against target, where the circulated media went, and the job table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Blast Media Consumption calculator (Self-check: PASS)
CSV with live formulas for the Jobs table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to order abrasive for a blast job, to put media cost into a surface preparation quote, or to spot the jobs and systems where poor recovery or separator rejection is costing you media.

How to use it

On Setup, type your shop and currency, and list your blast media with their price per pound and target fresh media per square foot.
On Jobs, give each blast job a row: media, area, effective coverage rate, media feed, recovery, separator yield and any initial charge.
Fix anything the Check column names.
Open the Dashboard: fresh media per square foot against target, where the circulated media went, and the cost.

Frequently Asked Questions

How do you calculate blast media consumption?: Work out the media circulated (feed rate x 60 x blast hours, where blast hours = area / coverage rate), take off what the reclaim system recovers and the separator accepts, and add any initial charge. 10,000 ft² at 250 ft²/h and 5 lb/min circulates 12,000 lb; at 85% recovery and 90% yield 9,180 lb is reused, so with a 500 lb charge you buy 3,320 lb, the Blast Media Consumption calculator's own example.
Why is circulated media so much more than what I buy?: On a recycling system the same abrasive goes through the nozzle many times. Only what the reclaim system misses and the separator rejects has to be replaced, plus the charge that fills the system.
What coverage rate should I use?: The accepted area per active nozzle hour from comparable work on similar steel, condition and standard, not a theoretical rate. It sets the blast hours and so the media circulated.
How is the target status worked out?: Fresh media per square foot is compared with the media's target on Setup: On target at or below it, Near target up to the near band over (20% in the example), Above target beyond. Your targets come from past jobs on your own system.
Does it predict surface profile or cleanliness?: No. It is a mass balance of the media. Profile, cleanliness and coating adhesion depend on the media, pressure and technique, and the number of times a media can be recycled is for the supplier to confirm.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test jobs and shows Self-check: PASS.