Shift schedules in Excel: how far do they get you?

What Excel does well

A grid for the month, formulas totalling each person, weekends shaded. For a small team with few constraints that is genuinely enough. If four people cover one shift a week each, adding software on top of the spreadsheet buys you nothing.

Where it breaks down

In three places:

• Verification. A spreadsheet computes a cell; it does not check a constraint. Whether somebody is rostered two days running, over their weekly hours, or past their holiday cap is something you have to count by hand.
• Alternatives. When you dislike a distribution there is no way to produce a second option — you rearrange the grid yourself.
• Distribution. You hold the current file; the team holds a screenshot. Editing the file does not remove the old image.

The switching threshold

In practice you have outgrown the spreadsheet when two of these are true: the team is larger than six, more than one rule applies at once (rest hours plus weekly caps plus holiday balance), and the published rota changes at least once mid-month.

You do not have to give up the printout

Leaving Excel does not mean leaving the paper schedule behind. Once the rota is generated against your rules and published, you can still download it as a PDF and pin it to the wall. What changes is how the schedule is produced and who is looking at which version.

How this works in practice

The same problem looks different depending on the team. These pages work through it for specific sectors:

• Manufacturing and production
• Security teams
• Call centres and support