The Staff Rota template is for care homes, clinics and other teams that work to a fortnightly rota. The Staff tab lists each member of staff with their role, contract hours and notes. The Rota tab is a grid with one row per person and one column per day for two weeks, where each cell holds a shift code such as E, L, N, OFF or AL.

The file comes with sample data for nine staff, so you can see how it works. Make a copy, replace the names and codes with your own, and the role counts and contracted hours on the Dashboard update on their own.