A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEX
This lesson is part of the course
In this lesson
You generate two weeks of Northgate's 24/7 rota for four crews from one 8-day pattern, check the coverage and find Crew D's first night shift.
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
- A Dynamic Monthly Calendar: First Monday with WEEKDAY & a SEQUENCE Grid Locked
- Highlighting Weekends, Closed Days & the As-of Date with Formula Rules Locked
- Week Numbers & Working Days: ISOWEEKNUM, NETWORKDAYS & WORKDAY with a Closed-Day List Locked
- A 4-on-4-off Shift Rota: Repeating Patterns with MOD & INDEX Locked
- Weekly Hours & Overtime from a Shift Rota: COUNTIF per Shift Code & MAX(0, …) Locked
- A Daily Gantt with Progress: WORKDAY End Dates & Two Formula Rules Locked
- Milestones: Days Remaining, Overdue / Due Soon Status & the Next Milestone Locked
- Yearly Planner Summary: Events per Month with COUNTIFS & a Stacked Column Chart Locked