A spreadsheet is an excellent modelling and analysis tool and a poor operational one. The gap is that it has no notification: somebody has to remember to open it. Under pressure that is precisely what does not happen, so the sheet is least accurate exactly when it matters most.
What Spreadsheets was built for
Almost every store starts here and many should. A spreadsheet is free, flexible, immediately understood, and for planning and analysis it is genuinely hard to beat.
What it cannot do is come to you. Operational events need to reach people, and a spreadsheet is a place you go. That single structural fact produces most of the failures below.
The second problem is that accuracy is hand-maintained. A tracker is only correct if somebody updates it, updating is the first thing dropped in a busy week, and a tracker that is 80 per cent accurate is worse than none because people act on it.
Where a store team pushes against it
The failures are about the medium, not about how well the sheet is built.
- Nothing arrives. There is no mechanism to tell anyone something needs doing.
- Accuracy decays exactly when you are busiest, and nobody announces that they stopped updating it.
- Concurrent editing produces silent conflicts, especially on phones and in poor signal.
- One person understands the structure. When they are away, nobody wants to touch it.
- No ownership or state. A row does not know who is doing it or whether it is done.
The structural difference
| Spreadsheets | Store Huddle | |
|---|---|---|
| Built for | Modelling and analysis | Time-sensitive operational work |
| Information model | You go and look | It comes to you |
| Accuracy | Hand-maintained | A by-product of doing the work |
| Ownership | A name typed in a cell | Assigned, with a due date |
| Under pressure | Stops being updated | Is the working surface |
| Best for | Planning, forecasting, analysis | Daily coordination |
Neither column is a verdict. The question the table is trying to answer is whether the work your team does all day is the work the tool was shaped around, because that is what determines how much friction you absorb every week.
Keep Spreadsheets if
- You use them for planning and analysis and coordinate somewhere else. This is the correct arrangement and worth protecting.
- Your operational volume is genuinely low, and a daily glance at one sheet covers it.
- The sheet does something no tool does: your own reorder model, a margin calculation, a forecast. Keep it. Nothing here argues against spreadsheets for the thing they are good at.
Consider moving if
- Your tracker was accurate in January and you no longer trust it.
- People find out about problems by remembering to check a tab.
- Two people have overwritten each other's edits and nobody noticed for a day.
- The person who built it is the only one who will edit it, which is a dependency rather than a preference.
Common questions
Can I run store operations on spreadsheets?
For a while, and many stores should start there. The limit is that a spreadsheet has no notification, so somebody has to remember to open it, and under pressure that is exactly what stops happening.
Why do operational trackers go stale?
Because accuracy is hand-maintained and updating is the first thing dropped in a busy week. A tracker that is mostly accurate is worse than none, because people act on it.
Should I stop using spreadsheets?
No. Keep them for planning, forecasting and analysis, which is what they are good at. The thing to move is the time-sensitive coordination that needs to reach people.