Moving a multi-store schedule off spreadsheets

A spreadsheet is a good way to schedule one store. It is free, everyone knows how it works, and it does what you tell it. The trouble starts when you add stores, because a spreadsheet records decisions without checking them. Here is how to tell when you have outgrown it, and how to move without a messy month.

Signs you have outgrown it

No single event tells you. Look for a pattern:

One person holds the schedule in their head, and everything stops when they are away.
Time-off requests live in text messages, and some get lost.
A rule problem, such as a sixth day or a short rest, is found after the schedule is out.
Someone works two stores and nobody can see their total hours.
Each manager has their own version of the template.
You cannot easily answer "why is this person on Saturday?"
Writing the schedule takes a day or more of a manager's week.

If three or more of these sound familiar, the spreadsheet is now costing more than it saves. That cost is hard to see, because it comes out of your managers' time.

Before you change anything, write down the rules

The most valuable thing in your spreadsheet is not in the cells. It is in your manager's head. Before you move, collect these:

Hard rules. Hours per day and week. Days per week. Minimum rest between shifts. Minors' hours if relevant. Anything from local law, which you should confirm with counsel.

Store facts. Hours per store, including exceptions. How many people each part of the day needs. Which hours are peak. Any two-person rules.

People facts. Who can work where. Who can open and close. Who wants more hours or fewer. Standing arrangements, such as someone who never works Thursdays because of a class.

Unwritten habits. Ask your manager to explain last week's schedule out loud, shift by shift. Each time they say "because…", write it down. This is where you find the rule nobody remembers making, such as "Sam and Lee never close together".

Some of those habits should become rules. Others should quietly retire. Moving is a good moment to decide.

Clean up your data

Make one list, in one place:

Every store, with its hours.
Every person, with their role, home store and the stores they can work at.
All approved time off from now on.
Each person's sales per hour worked, if you plan to use it.

This usually takes less time than you fear, and it tends to reveal something surprising, such as a former employee still on the template.

Run one store first

Do not switch every store on the same Monday. Pick a store with a manager who is curious and willing to complain. A problem store is a bad first choice, because you will not know whether trouble comes from the store or the tool.

A rollout that works:

Week 1: Run both. The manager writes the schedule as usual, and you also build it in the new tool. Compare them. Differences will show you rules you forgot to enter.
Week 2: Run both, new tool first. Build the week in the new tool, then check it against what the manager would have done. Discuss each difference. Sometimes the tool is wrong. Sometimes the old habit was.
Week 3: Go live. Publish from the new tool. Keep the old spreadsheet closed but saved.
Week 4: Adjust. Ask what is still being done on the side. A text thread that is still going is a sign that something is missing.

Before you start, decide how you will judge it. Time to write the week is a simple measure. So is how many changes you make after publishing.

Bring your managers with you

Managers can read a new tool as a sign that you do not trust their judgment. Say the opposite, and mean it: they still own the schedule. The tool does the first draft and the checking, and they make the calls. Ask them to break it. The manager who finds a real problem is your strongest ally for the next store.

Tell your team, too. People notice when the schedule looks different. A short note helps: what is changing, who to ask, and what stays the same.

Mistakes to avoid

Rebuilding your old spreadsheet in new software. If you copy every habit across, you get the same problems with a higher bill. Use the move to drop what no longer helps.

Entering everything before you test anything. Set up one store and one week, and see what comes out. You will learn more from one real week than from a month of setup.

Too many exceptions. Every special case makes the next one harder. Set a default for the company, then allow a store to differ only when it truly does.

Leaving your old time-off records behind. Move every approved day off before you publish a single shift. Missing one is the fastest way to lose your team's trust.

What good looks like

After a month, you should be able to answer these without calling anyone: who is working at each store on Saturday, why they were chosen, who could cover if someone calls out, and whether any rule was bent, and why.

If you can answer those, you have moved. The spreadsheet can stay for what it does well, which is everything other than running your schedule.