Far from the Maddening Crowd

It’s time to stop with the Excel Spreadsheet fetish, it’s pretty bad for you, but it’s worse for your business. Step away from the grid-lines, now!

Time to go Cold-Turkey

One of things that has always surprised, and frankly occasionally unnerved me, is the lack of basic digital skills in the sector. Now I’m not talking about being a Black Belt in Python (until 6 months ago I thought that was just a type of snake) or a Pokemon master at Q-Basic here. I’m simply talking about a broader depth of knowledge beyond the Housing Management system people use (or more’s the point, the narrow part of it related to their role) and Microsoft Word. But it is not just at an individual level that the sector has a bit of an issue. If you were to take a look around your business I guarantee your mortgage (I can’t afford one so I rent #millennialproblems) that a significant proportion of your staff are using off-system solutions to carry out day-to-day work. Why? Because your current software solutions doesn’t meet their need.

Square Pegs, Round Holes: Failure to Develop = Failure

People fall back onto Excel and Access-based solutions when there is no obviously better way to interrogate data. Their over-use is symptomatic of a business crying out for a more suitable solution but without the foggiest idea of what it needs or where it can be acquired from. It is also a result of failure to update and refresh the software solutions the business has as its disposal.  It’s no good thinking your billy big balls with your Morris Minor when everyone else is cruising around in their Audi R8. Also, considering the sector seems fine to throw a dollar or two around when it comes to Chief Executive pay maybe they can cough up and pump some money into the machinery that keeps the organisation ticking over. Just a thought.

FYI good reads come from Jules Birch and Kevin Williams on Chief Executive pay and the wider debate/ramifications related to them. Funnily enough Kevin’s Blog is from last year’s nicker twisting championships on the same subject. But it’s worth re-reading if only for the fact the name comes from my favourite Biggy Smalls song.

Sorry, got side-tracked 

The problem is for a lot of staff Excel is actually pretty crap when trying to communicate performance and data trends. Surprise, surprise, it’s not everyone’s cup of tea. Indeed the near meltdowns I’ve seen when merely mentioning the name Excel is highly amusing. It’s like dropping the Voldemort-bomb at a Harry Potter LARPing event. Additionally spreadsheets are not always easily understood and it’s too easy to miss important information in them. And I can guarantee you unless you lock that baby down someone is going to delete an essential bit of formula quicker than Liam Fox can insult the entire country’s business community.

More worryingly for the sector they’re actually not great when being used for managing essential business processes (good heavens, no!). So if you’re using them to monitor performance for say Planned Works or Estates Services, or god forbid Repairs. Please stop. Now. Because the amount of things that could go tits up relying on spreadsheets for such business critical processes frankly gives me nightmares.

What to do

Go back to basics. Look at what you want to report, who you want to report it, why you need to report it and then how. Because believe me there are a million and one better pieces of kit out there to monitor, report on and interrogate data than Excel. 

Excel is fine for basic bits and pieces, but it should be a useful extra, not the go to for essential business processes. It’s like using an abacus when you have calculator available. Cute for none users to admire your handiwork, but you’ll be buggered if you believe everyone else can use it. Worse over-reliance on it will leave you over-exposed to one muppet and the delete button. Be brave, make the change.

You can find more of my stuff here and follow me on Twitter here.

*Updated 13/09/16

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s