Shift Patterns: Repeating Rotas, Coverage, Gaps & Double Cover
This lesson is part of the course
In this lesson
You generate a four-crew 12-hour rota with MOD and INDEX, count the day and night cover for every day, and find the offset error that leaves some days empty and others double-staffed.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Post Hours: From Opening Times to Weekly and Annual Cover Locked
- Net Hours per Officer: Contract Hours Minus Leave, Training & Absence Locked
- The Relief Factor: How Many Officers One Post Really Needs Locked
- Shift Patterns: Repeating Rotas, Coverage, Gaps & Double Cover Locked
- Overtime or Extra Staff? Costing the Gap Hours Locked
- Building the Hourly Bill Rate: Pay, On-Costs, Paid Time Off Post, Overhead & Margin Locked
- Contract Margin per Post: Monthly Price, Overtime and Staff Turnover Locked
- Capstone: A Multi-Site Contract Dashboard Locked