The subscription, the build and the spreadsheet you already have, costed over the years. Workarounds included.
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
£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
three ways, costedover 3 years
Keep the spreadsheet
Buy it
Build it
Someone's sorted column F again. Karen
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.
£25,600cheapest over 3 yearsBuild
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.