📦 Resource excel

Blast Design Excel Template v4.2

Blast Design Excel Template v4.2 is a comprehensive, calculation-driven spreadsheet tool engineered for mine planners, blasting engineers, and explosives technicians to rapidly design, analyze, and optimize surface and underground blast patterns. It integrates empirical models, rock mass properties, explosive performance data, and regulatory safety constraints into a single, auditable, and user-friendly interface—significantly reducing manual calculation errors and iterative redesign cycles. The template supports real-time sensitivity analysis and automatic compliance checks, making it indispensable for efficient, safe, and cost-effective blast planning.

Download Resource File

🎯 When to Use

Engineers use this template during pre-blast planning phases to evaluate multiple design scenarios, validate regulatory compliance prior to permit submission, conduct training and peer reviews, and support QA/QC documentation for audits. It is especially valuable in open-pit mining, quarry operations, civil excavation, and demolition projects where rapid iteration, traceability, and defensible engineering rationale are required.

📑 Key Contents

1 Blast Geometry Calculator: Computes burden, spacing, stemming, subdrilling, and pattern layout (square, rectangular, staggered) based on rock type, drill diameter, and explosive selection

2 Explosive Energy & Loading Module: Converts ANFO, emulsion, and cartridge-based explosives into equivalent TNT energy, calculates powder factor, charge weight per hole, and total explosive mass with density and VOD adjustments

3 Fragmentation Prediction Engine: Implements Kuz-Ram and Swebrec models with user-input rock hardness (UCS), joint spacing, and blast design parameters to forecast post-blast fragment size distribution (P80, P50)

4 Vibration & Airblast Compliance Dashboard: Estimates PPV (Peak Particle Velocity) using scaled-distance equations (USBM, Langefors–Kihlstrom) and predicts air overpressure (dB) against site-specific regulatory thresholds

5 Reporting & Documentation Generator: Auto-populates professional blast design reports—including annotated schematics, summary tables, safety verifications, and revision history—with export-ready formatting for stakeholder review and regulatory submission

📏 Standards Referenced

Institute of Makers of Explosives (IME) SP-100: Safe Practices for the Storage, Handling, and Use of Explosives US Bureau of Mines (USBM) RI 8507 – Blasting Vibration Guidelines ISO 13320:2020 Particle Size Analysis – Laser Diffraction Methods (for fragmentation validation)

📥 Note: Available as a macro-free .xlsx file compatible with Microsoft Excel 2016+ and LibreOffice Calc; includes built-in data validation, password-protected input cells (unlocked via provided engineering key), and printable documentation tabs. No external add-ins or internet connection required.