Resilience Index Calculation Workbook (ISO 24510-aligned)

The workbook implements the four-pillar resilience framework defined in ISO 24510 — namely Resistance (ability to withstand disruption), Redundancy (existence of alternative pathways or sources), Resourcefulness (capacity to mobilize response capabilities), and Rapidity (speed of restoration). Each pillar is assessed using quantifiable network parameters (e.g., pipe connectivity, valve isolation efficiency, pump station backup power, SCADA coverage) mapped to ordinal or continuous scales aligned with ISO’s qualitative descriptors. The tool supports both static baseline assessments and scenario-based stress testing (e.g., pipe failure, power outage, demand surge) by enabling users to toggle infrastructure states and recalculate indices dynamically. It incorporates built-in data validation, automated normalization, weighted aggregation, and visual dashboards (e.g., radar charts, pillar-wise scores, trend tracking), facilitating comparative analysis across assets, zones, or time periods. Designed for utility engineers, asset managers, and regulatory auditors, the workbook bridges ISO 24510’s high-level principles with practical, spreadsheet-based implementation—requiring no specialized software beyond Microsoft Excel and compatible with EPANET-exported hydraulic model outputs.