2.3: Consolidate 7-1-7 performance: metrics, bottlenecks, and remedial actions

After each public health event, data originally captured on the 7-1-7 Assessment Tool should be stored in a single location in order to facilitate performance analysis across events. Ideally, these data should be captured in event or project management systems used to track other activities and collect other surveillance and/or response data. Jurisdictions lacking a suitable existing data system may choose to use the Data Consolidation Spreadsheet, a Microsoft Excel database developed to support implementation of the 7-1-7 approach. This tool contains four different sheets:

1. Input timeliness data: This page of the worksheet permits jurisdictions to record timeliness metrics, bottlenecks and enablers for each public health event reviewed against the 7-1-7 target;
2. Assess 7-1-7 results: This page automatically calculates the three timeliness metrics for each public health event and generates tables and graphs that summarize performance across all events entered in the spreadsheet;
3. Track remedial actions: This page allows jurisdictions to record all remedial actions identified as well as the responsible authority and implementation status;
4. Bottleneck analysis: This optional page can be used by jurisdictions to consolidate the bottlenecks identified through 7-1-7 implementation and categorize them, facilitating identification of the most common bottleneck types. This analysis has been found useful in helping jurisdictions prioritize longer-term remedial actions for funding.