5 February 2016
I have a love/hate relationship with spreadsheets. I’ve seen them in the skilled hands of a master make a report sing and dance. I wouldn’t be surprised if there’s a spreadsheet somewhere literally making the coffee! As an ex software developer I love the rich functionality, the versatility, and the ease of use that has made spreadsheets the glue that holds many business processes together, and keeps everyone informed. I’ve also seen spreadsheets inflict pain and suffering as they clog up workdays and unintentionally misinform people. I’ve also seen the stress created when the spreadsheet master walks out the door for the last time!
It never starts out bad. There’s a specific need and the spreadsheet stepped up and delivered. It was quick and cost effective, and the person who created it is a hero. Same for the next step, and the next, and the one after that. All the time the spreadsheet is becoming more important and valuable. However, there are unseen problems creeping in as the business becomes more reliant on it:
Each step down the slippery slope can appear to be the cheapest and easiest option. There is point at which the burden of using spreadsheets outweighs the cost of developing an alternative. That’s the best time to look at systemising – shifting the mind-set from authoring documents to designing reliable solutions.
So here’s the main challenge I see most people face – how do they know when the cost & pain of continuing down the slope is greater than replacing it with a reporting solution? Today, with a smart and agile approach, the right tools and the right skills, it’s possible to start addressing this problem in small, practical steps.
I recently helped a client with a spreadsheet that had taken months to write and everyone was scared to touch, because the author was long gone. I sucked the data into a database and built the same report within a couple of hours. They are now on a path back up the slope, nobody is scared of the report, and it will still work next week for anyone who needs it!
So I’d encourage you to take a look at how spreadsheets are being used. If people are squinting to read them on their mobile phones or spending large chunks of time to make them work, then perhaps it’s time to look at better and easier ways to serve up the information.