The cheap one isn't always. Count the hours it leaves you.

Three ways to deal with the spreadsheet everyone works around. Each one costs what you pay, plus the hours your team still spends by hand.

Starting figures · add your own
Keep the spreadsheet

Copying, retyping, fixing and chasing, across the whole team.

Buy it

Still done the old way, by hand.

Build it
All three
£25,600
Build it, over 3 years. The cheapest of the three
£4,300
A year of the subscription's cost is the 30% it doesn't fit, done by hand

Rough sums. Not financial advice. It leaves out the weeks of switching over, and what money doesn't count, like the one person who understands the spreadsheet.

How this works

Each way costs what you pay, plus the hours your team still spends by hand. Keeping the spreadsheet costs nothing to start, and all the hours, every week. Buying costs the set-up, the subscription, and the work it doesn't fit, still done the old way. Building costs the price and the running, and leaves a little by hand.

Keep = hours a week × 48 weeks × an hour × years
Buy = set-up + (people × a month × 12 + hours × share it doesn't fit × 48 × an hour) × years
Build = price + (running + hours × still by hand × 48 × an hour) × years

Type in any build price, from anyone. If the spreadsheet comes out cheapest, it is. Keep it, and tidy it.

We did one like it

The work · Advise

Eleven trackers. Keep, fix or replace?

A 50-person contractor ran on linked spreadsheets only one coordinator understood. We wrote the rules down and went through all eleven trackers: four kept, three fixed, four replaced, and a brief for the build.

5 weeks, 11 trackers

Read the job
More on operations

Seen something familiar?

Rough sums only get you so far. Bring the real ones to a first call.

Book a Call