Volunteer rota gap and overlap checker
Paste role requirements and assigned shifts to find uncovered time and people assigned to different roles at once.
Your working figures
Fictional example data is shown. Replace it with your own. Keep the CSV header names, and use a dot for decimals.
Up to 500 CSV rows, with smaller limits on tools that compare combinations. No personal data is needed for the examples.
Your report
How the worksheet works
Split the day at every shift or requirement boundary. Count distinct people per role in each interval. Someone assigned to different roles at the same time is excluded from coverage in that interval. Overlapping requirements for the same role use the highest needed count.
A worked example
Welcome needs two people. From 09:00–10:00, Alex and Sam cover it. After Sam leaves, it is short one person. Alex’s overlapping Workshop assignment also flags a conflict from 10:00–10:30.
Check these limits
One local calendar day only; no overnight shifts. Names and roles are matched without case differences. This checks supplied numbers, not qualifications, legal staffing ratios or attendance. Use role labels rather than personal details when sharing exports.
Working with CSV
Keep the header row shown in the example. Put one item or shift on each row. Fields containing commas can be enclosed in double quotes. Reports flag inconsistent entries rather than silently filling missing values.