5 reasons why spreadsheets are not right for prioritizing your projects

Written by Dan Dures

As a seasoned expert at low quality Home Improvements, I know that there are very few jobs that can’t be done with duct tape, super glue and Polyfilla. Solving problems with the wrong tools and no skills. What could possibly go wrong?

Similarly, we all know that there are very few problems that cannot be fixed with a spreadsheet, right? Build a quick database? Organise your sales pipeline? Create charts for your investors? Manage your taxes? We’ve got a spreadsheet for that! Now technically you probably could (and possibly have) been able to do just this. But (like my home improvements) how often do you regret that initial decision to ‘just put it in a spreadsheet’ rather than take the time to get the right tool for the job?

Having witnessed the rise of AWS, Salesforce, Tableau, Power BI and a plethora of other data titans it’s fair to say the sector has evolved to offer better choices (much as my home improvements have given way to calling Gary).

Picture1Yet, when we surveyed people on LinkedIn to tell us how they were prioritizing, spreadsheets were still top (albeit tied with PPM tools, to be fair) so we’ve clearly got a long way to go on this transition. And this makes sense – spreadsheets are familiar, and you don’t have to ask finance for budget – making a change feels uncomfortable… do you really want to make that change now?

Yes, of course you do! And here are 5 reasons why:

1) Spreadsheets make mistakes

Research shows that only 1 in 10 spreadsheet is error free. I’m not totally sure how this research has been done, or indeed how accurate it is, but the quantum of the problem is clear. It’s just way too easy to drag a formula a little too far, or to mess up your VLOOKUP by adding in an extra column. Most of us have had that sinking feeling when we see these errors, hope that they’ve not been seismically catastrophic, and patched it up.

Is this really a risk you want to plumb into your progressive tech-enabled planning process? When there are $millions being potentially mis-managed is that ‘free’ spreadsheet still good value?

2) People don’t like Black Box solutions

Anyone who has managed a planning process powered by a big spreadsheet knows that moment when a foot dragging participant sucks in the air through their teeth, and asks, “how can we really trust this model – it’s just such a Black Box”. This challenge can be heartfelt, politically motivated… or a bit of both. But it’s tricky. At best you’re scrambling to document all the bodges, at worst you’re struggling to recall why you used that percentage in the bright yellow input field, and what exactly does that “Adjustment Factor” line mean.

Does any of this sound familiar? If so you probably realise that the ‘free’ spreadsheet has some nasty hidden costs when it comes to organisational alignment.

3) Spreadsheets don’t benefit from Decision Science

Thinking specifically about scoring options, spreadsheets are powered by inputs – the answer is 23.7, put it into Cell DX3032 (coloured a nice shade of magenta) and you’ve got your answer. But humans simply don’t work like that. It’s been proven that people are far more able to think in terms of relative importance or relative size, than to create a value in the abstract. This is the fundamental principle of AHP – Analytic Hierarchy Process – and has led to the development of a large body of best practice relating to both Pairwise & Verbal Scale based scoring.

In theory this can be built in a spreadsheet – but it’s overly complicated, not advisable, and certainly not free, assuming you put value on your time, sanity and peace of mind.

4) Teams are smarter than individual people

Scores are subjective perspectives, crystallised into data points. The fact that you have a number does not mean you create truth – you simply quantify bias. Most judgements that power organizations remain exactly this – subjective human perspectives (subject to AI enabled robot take-over perhaps). And this is great – inherent in human judgement is millions of years of evolution, topped off with professional experience and (probably) a bit of L&D. However, better still is a syndicated perspective of a group of people working together to share knowledge and create the ‘wisdom of the team’.

The time and positivity of your team is the most valuable resource you have – choosing to use the cheapest solution available to capture their insight is not a smart saving.

5) Spreadsheets don’t make it simple to collect data

Data collection is painful. Chasing people to fill in spreadsheets, managing different versions of submitted data, finding stale data, hunting through email attachments for updates to copy into ‘the master’… If these are not familiar then relax. Your spreadsheet enabled process clearly works better than any that I’ve used. If it does, take a moment and ask yourself that question again…

Isn’t there a better way of doing this?

If you’re nodding right now then it’s time to think about Project Prioritization solutions. At TransparentChoice we’ve been working on making your planning process better and more inclusive, and would love the chance to help you say goodbye to that spreadsheet, and hello to tech-enabled collaborative Project Prioritization.


Want to hear more?
Read our Ultimate Guide, take a look at our latest product demo or reach out to speak with us.

COVID 19 Support- free tch sw (1)How are you prioritizing your projects remotely? 

Now more than ever, the decisions you make will determine the future of your organisation. 

Making good decisions is even more difficult in an environment of high uncertainty and unremitting change, all whilst working remotely. 

TransparentChoice software is helping remote teams make better faster decisions taking into account the uncertainties of the future.

Click here to learn more. 

Don't forget to share this post!