Sound familiar?

If three or more of these ring true, you’re in good company. It’s one of the commonest things owners bring us.

Drag the handle.Tap Before or After.

  • The master sheet: Has tabs nobody dares delete.
  • Dave: Knows how it all works. He's on holiday.
  • The same order: Typed into four places, slightly differently each time.
  • Which sheet?: Karen knows. If she's off, nobody does.
  • Customers: Ring to ask where their order is.
  • Software: Bought twice to fix it. Still using the spreadsheet.

Before

  • The master sheet has tabs nobody dares delete.
  • The same order, typed into four places, slightly differently each time.
  • Customers ring to ask where their order is.
  • Software bought twice to fix it. Still using the spreadsheet.

After

  • One room-readiness and admin view for every site manager
  • Head office sees staffing gaps and overdue actions directly
  • Typed in once

The after side is a real job: Five clinics. One meaning of ready.

What usually causes it

Nobody sets out to run a business on one spreadsheet. It happens a sensible decision at a time.

  1. It grew one tab at a timeEvery sheet started as a sensible fix for one job. Ten years on it’s the system the business runs on, and nobody designed it.
  2. The rules live in one headThe spreadsheet holds the numbers. What happens next, and why, lives with whoever built it.
  3. Tools that don’t talkAccounts, email, the quote sheet and the order board each hold part of the story, so someone types it across by hand.
  4. Software before the processNew software set up the way the old mess worked, or not at all. Automate a mess and you get a faster mess.

One order, typed four times. Spot the difference.

What we’d look at first

01

  • Follow one order, start to finishFrom enquiry to invoice, with the people who do the work. Count the retyping, the chasing and the waiting.

02

  • Find who it all depends onWhat do they know that isn’t written down? The calculations, the exceptions, the handovers. That’s the first thing to get out of their head.

03

  • Decide what earns its placeSome spreadsheets are fine. We keep what works and fix the process before deciding whether anything needs building.

We sort out how the work should flow before anything is built.

Keep, fix or replace?

Not every spreadsheet is the problem. A quick way to sort yours before anyone mentions software. Four questions for each spreadsheet first. They’re what we asked of all eleven trackers in the job further down.

  1. Question 1What is it actually used for?

    Follow where its numbers go next, and who reads them.

  2. Question 2Are its rules written down?

    The calculations, the exceptions, who hands it to whom.

  3. Question 3Does it repeat another one?

    The same information, kept again to make a different report.

  4. Question 4Who else could run it?

    If the answer is one name, that’s the risk. Not the spreadsheet.

Keep, fix or replace?
  1. Keep itIt does one job wellOne person uses it, for one job.Anyone else could open it and follow it.Nothing gets typed out of it into somewhere else.
  2. Fix itRight data, wrong stepsThe numbers are right but the steps around them aren’t.The formulas only make sense to whoever wrote them.Something is copied into it by hand every week.
  3. Replace itThe business runs on itSeveral people need it at once, and take turns.Work stops when it breaks, or when its owner is off.Orders, customers or money live in it, and get typed again elsewhere.

A rule of thumb, not a verdict. Most businesses have all three.

Three ways in

Three businesses that ran on one person’s spreadsheet. One for each way we work.

Project · OperationsAdvise
Most start here

Eleven trackers. Keep, fix or replace? (read it on the work page)

Specialist construction contractor, 50 staff.

Where it startedOnly one person understands the linked sheets. The owner wants a safer way to work.

The turning pointThe costing workbook held useful rules. Several progress trackers simply repeated the same information.

The numbersEleven trackers reviewed: four to keep, three to repair and four in the replacement brief.

These are decisions about scope, not software delivered or time saved during the advice work.

How longFive weeks.

Project · OperationsBuild

Written in the field. Typed again in the office. (read it on the work page)

Agricultural services business, 35 permanent and seasonal staff.

Where it startedField notes arrive by message and on paper, then get typed into office trackers.

The turning pointMissing units and unclear activity descriptions caused most office queries.

The numbersWeekly re-entry fell from eight staff-hours to three in the fourth week after launch, at around 120 records a week.

That measures office re-entry, not all administration. Offline records appear only after a successful sync.

How longSeven-week build and four weeks of adoption.

Project · OperationsRun

New templates. Old ones still in use. (read it on the work page)

Architecture and design practice, 30 staff.

Where it startedThere is a project system, but teams keep their own checklists.

The turning pointNew templates had been added without removing the old ones.

The numbersIncomplete handovers fell from seven of 20 in month 1 to two of 20 in month 6, using the same checklist.

More complete records do not prove that every project ran faster. Exceptions still need review.

How longSix months, starting with a two-week review.

Each figure is as the job measured it; the whole job, small print and all, is a click away.

Try the numbers

Your own figures, roughly. Everything runs in your browser and nothing you type is stored or sent.

  • Quick sum

    How many Daves?

    Ten jobs. Tick the ones only one person can do, and see where the knowledge piles up.

    Try it
  • Quick sum

    The retyping bill

    The same thing typed twice, every week, all year. What it adds up to.

    When it opens75 things a week at 4 minutes each: 31 working days a year.

    Try it

Bring the spreadsheet to the first call

Half an hour. We’ll say which parts we’d keep and where the retyping starts.

  1. The spreadsheet itselfTabs and all, including the ones nobody dares delete.
  2. One recent orderAnd every place it got typed on its way to the invoice.
  3. Who gets the call when it breaksJust the name. We won’t ring them yet.
Book a first call

Before you ask

Do we have to stop using spreadsheets?

No. Spreadsheets are fine for plenty of jobs. The trouble starts when the business depends on one that only one person can work.

What about the person who built the spreadsheet?

They’re usually the most useful person in the room. We build with them, not around them, and they stop being the only one who can answer the question.

Can we fix this without replacing everything?

Usually. We start from the sheets you have, tabs and all, work out what each part is for, then keep, fix or replace them one at a time.

Which spreadsheet would you miss most?

Bring it to a first call. We’ll say what we’d keep, what we’d fix and whether anything needs building.

Book a Call