OT Asset Criticality Scoring Matrix (Excel)
The OT Asset Criticality Scoring Matrix (Excel) is a structured, quantitative risk-assessment tool used to prioritize operational technology (OT) assets—such as PLCs, HMIs, SCADA servers, and field devices—based on their impact on safety, production continuity, environmental compliance, and security posture within mining automation environments. It assigns weighted scores across multiple criticality dimensions to enable evidence-based asset segmentation and informed investment in cybersecurity controls. The Excel implementation facilitates collaborative scoring, version control, and integration with broader Mine Automation Cybersecurity Framework workflows.
📖 Overview
📑 Key Components
🎯 Applications
- ✓ Prioritizing OT asset patch management and vulnerability remediation
- ✓ Informing network zoning and micro-segmentation design in mine IIoT architectures
- ✓ Supporting regulatory audits and third-party cybersecurity assessments for mining operations
📐 Key Formulas
Weighted Criticality Score
SUM( (Score_i × Weight_i) for i = 1 to n ) / SUM(Weight_i) × 100
Normalizes composite score to 0–100 scale, accounting for domain-specific importance of each criticality dimension
Impact Severity Index
IF(Safety_Impact >= 4 AND Production_Impact >= 4, 'Tier-0', IF(OR(Safety_Impact >= 4, Environmental_Impact >= 4), 'Tier-1', 'Tier-2'))
Rule-based classification for high-consequence assets requiring immediate mitigation actions