This spreadsheet template is designed to standardize health-related field data collection by providing a clear set of input fields and pre-defined categories that enable consistent reporting across locations and assessment rounds. It typically captures core contextual information (date, location, population group, assessment team, and coverage area) alongside key service and system indicators such as facility functionality, service availability, staffing, essential medicines and supplies, referral pathways, and immediate operational constraints.
The template also supports analysis of priority public health risks by structuring data on morbidity patterns, communicable disease alerts, maternal and child health, vaccination/cold chain, reproductive health needs, and outbreak preparedness, often linking these to WASH and other determinants where relevant. Overall, it helps teams produce comparable datasets, quickly flag gaps, and generate evidence for response planning, resource allocation, and follow-up monitoring.
Table of contents (workbook structure)
1. Instructions & Definitions
2. Assessment Metadata (location, date, team, population, methods)
3. Population & Vulnerability Profile
4. Health Facility/Service Availability
5. Staffing & Capacity
6. Medicines, Supplies & Equipment
7. Service Utilization & Caseload Trends
8. Priority Health Risks & Surveillance/Alerts
9. Maternal, Newborn & Child Health
10. Reproductive Health / MISP
11. Referral Pathways & Ambulance/Transport
12. Infrastructure & Utilities (power, water, waste management, cold chain)
13. Key Findings, Gaps & Priority Actions
14. Annex / Lookup Lists (indicators, codes, facility list)