This Excel workbook provides a robust framework for capturing, analysing and evidencing demographic participation across resident engagement, surveys, consultations, scrutiny, co-design and community activity. It includes automated demographic summaries, RAG ratings, representation gap analysis, participation tracking, evidence mapping, data quality checks, action tracking, “You Said, We Did” accountability and dashboard reporting. The workbook helps organisations understand who is taking part, whose voice may be missing, what action is needed and how engagement activity supports inclusion, resident influence, transparency and accreditation readiness.


