IEEE 1584-2023 Incident Energy Calculation Workbook (Excel)

The IEEE 1584-2023 Incident Energy Calculation Workbook operationalizes the revised statistical regression models introduced in the 2023 edition of IEEE Std 1584—'IEEE Guide for Performing Arc-Flash Hazard Calculations'. Unlike its 2018 predecessor, the 2023 version incorporates over 2,000 new high-fidelity lab test results, expands voltage coverage (0.208–15 kV), introduces separate equations for grounded and ungrounded systems, and refines enclosure geometry effects (e.g., vertical vs. horizontal bus configurations). The workbook uses structured worksheets to guide users through system parameters (available fault current, X/R ratio, electrode configuration, enclosure size, working distance), automatically selects appropriate calculation models based on voltage and configuration, and applies correction factors for grounding, conductor gap, and arc duration (often derived from device clearing time via time-current curves or protective device coordination studies). It also integrates uncertainty quantification per Annex D of IEEE 1584-2023, reporting confidence intervals for incident energy estimates. Validation features include built-in consistency checks, unit conversion safeguards (metric/imperial), and traceable audit logs—making it suitable for compliance documentation, arc flash studies required under NFPA 70E, and integration into electrical safety programs.