Skip to main content
NEWIEEE 1584-2018 / NFPA 70E

Arc Flash Hazard Study Record (Excel)

Free download · Excel (.xlsx)

An arc flash hazard study per IEEE 1584-2018 produces critical safety data for every piece of electrical equipment — data that must be accurately recorded for label creation, PPE selection, and safe work procedure development. This Excel template provides a comprehensive study record with columns for Equipment ID, Equipment Type, Voltage (V), Electrode Configuration (VCB/VCBB/HCB/VOA/HOA), Enclosure Dimensions (H x W x D in mm), Gap Between Conductors (mm), Bolted Fault Current (kA), Working Distance (mm), Arc Duration (ms), Arcing Current (kA), Incident Energy (cal/cm²), Arc Flash Boundary (mm), PPE Category (1-4), Required Arc Rating, Hazard Risk Category, Approach Boundaries (Limited/Restricted/Prohibited), NFPA 70E Reference, and Notes. Conditional formatting colour-codes incident energy levels: green (<1.2), amber (1.2-8), orange (8-25), red (25-40), dark red (>40 cal/cm²). Transfer results directly to arc flash warning labels.

What's Included

Front:Equipment ID, type, voltage, electrode config, enclosure dims, gap, bolted fault kA, working distance, arc duration, arcing current, incident energy (cal/cm²).
Back:Arc flash boundary, PPE category, required arc rating, hazard risk category, approach boundaries, NFPA 70E ref. Colour-coded incident energy cells.
Size:Excel (.xlsx)
Format:PDF, print-ready

How to Print

  • Open in Microsoft Excel 2016+, Google Sheets, or LibreOffice Calc
  • Add your company logo and project details to the header
  • Copy data rows to add more circuits or equipment
  • Print on A4 or A3 landscape for site records
  • Keep completed records for design verification and audit trail

Try the Interactive Calculator

Need precise calculations beyond quick reference? Try our free online calculator with full clause references and professional report output.

Open Calculator

Frequently Asked Questions

What is the difference between this and the arc flash boundary worksheet?

The boundary worksheet is a single-equipment fillable PDF for manual calculations. This study record is an Excel spreadsheet designed to document the complete arc flash study across all equipment in a facility, with multiple rows and automated conditional formatting.

What electrode configuration should I use?

IEEE 1584-2018 defines five electrode configurations: VCB (vertical in box), VCBB (vertical barrier in box), HCB (horizontal in box), VOA (vertical open air), HOA (horizontal open air). Select based on the equipment type — VCB for most switchgear, VCBB for MCC buckets with barriers.

How do I determine the PPE category from incident energy?

NFPA 70E Table 130.7(C)(15)(a): Category 1 (4 cal/cm²), Category 2 (8 cal/cm²), Category 3 (25 cal/cm²), Category 4 (40 cal/cm²). Above 40 cal/cm² is not covered by standard PPE — de-energise the equipment.