Emergency Power Prioritization Matrix (Excel + Visual Flowchart)

The Emergency Power Prioritization Matrix operationalizes resilience planning by translating complex interdependencies—such as personnel safety, regulatory compliance, mine dewatering integrity, and ventilation continuity—into actionable prioritization tiers. At its core, it applies a weighted multi-criteria decision analysis (MCDA) framework where each load (e.g., main fan, sump pumps, refuge chambers, communications) is scored across dimensions including Life Safety Impact (LSI), Environmental Risk (ER), Production Criticality (PC), and Recovery Time Sensitivity (RTS). Scores are normalized and aggregated using configurable weights—allowing site-specific calibration based on geology, regulatory jurisdiction (e.g., MSHA, DMRE), and infrastructure topology. The Excel implementation supports dynamic recalculations, sensitivity analysis via sliders or dropdowns, and automated tier assignment (Tier 1: Immediate Backup Required; Tier 2: Graceful Degradation Permitted; Tier 3: Deferrable). The companion visual flowchart maps the decision logic into a deterministic, auditable pathway—illustrating conditional branching (e.g., 'If LSI ≥ 9 AND ER ≥ 7 → Tier 1') and integration points with existing SCADA alarms, battery runtime estimators, and diesel generator capacity dashboards. This dual-format design bridges technical rigor with field usability, enabling rapid consensus among engineers, safety officers, and operations managers during pre-incident planning and real-time incident response.