ItÃ¢â¬â¢s a dark winter night. ItÃ¢â¬â¢s cold and windy outside. A group of people have gathered in the churchÃ¢â¬â¢s basement. TheyÃ¢â¬â¢s sitting in the circle, staring down at the floor. There are some stale donuts and cold coffee on the folding table behind them. Finally one man stands up:
Ã¢â¬Ã Ã¢â¬ÅHello, my name is Scott, and I use ExcelÃ¢â¬
Ã¢â¬ Ã¢â¬ÅHello, ScottÃ¢â¬ , answers the group in unison.
Ã According toÃ National Institutes of Health (NIH):
Addiction is defined as a chronic, relapsing brain disease that is characterized by compulsive drug seeking and use, despite harmful consequences. It is considered a brain disease because drugs change the brain; they change its structure and how it works. These brain changes can be long lasting and can lead to many harmful, often self-destructive, behaviors.
If you think that this definition only applies to people, youÃ¢â¬â¢re wrong. Just replace Ã¢â¬ÅbrainÃ¢â¬ with Ã¢â¬ÅorganizationÃ¢â¬ and Ã¢â¬ÅdrugsÃ¢â¬ with Ã¢â¬ÅspreadsheetsÃ¢â¬ and read it again.
Spreadsheets in general-and Microsoft Excel in particular-are probably one of the most popular types of software in the world. Excel can be found on virtually any computer. People use it all the time to track their finances, manage their tasks, keep track of their vendors and suppliers, create invoices, track orders and customers and for a million other things.
The biggest reason Excel is so widespread is that itÃ¢â¬â¢s awfully easy to use. The entry barrier is almost non-existent Ã¢â¬ anyone and everyone can open it and start playing with lists and numbers. Like meth or cocaine, it doesnÃ¢â¬â¢t take long to start using it and get hooked; then it becomes really, really hard to quit. Using spreadsheets becomes very addictive Ã¢â¬ you get your results fast without thinking about the long-term effects of your actions. And thatÃ¢â¬â¢s exactly where the problem lies.
In software development, thereÃ¢â¬â¢s a concept calledÃ Technical Debt. It happens when you create bad Ã¢â¬ÅspaghettiÃ¢â¬ code in order to move your project forward quickly. It gives you immediate results, but you eventually have to pay this debt back by re-writing your algorithms. There are consequences if you donÃ¢â¬â¢t. First, you might not be able to expand your product functionality later on. Second, your system performance will degrade. Third and most likely, supporting your product will become a nightmare. Similar to the financial debt, you will pay really high interest in time, when the debt comes due.
Using Excel in your company results in anÃ Organizational Debt, which can manifest itself in a variety of dire consequences:
Culture of Silos
Excel by its very nature is an individualistic product. Using it discouragesÃ team collaboration, simply because it was not built for that. If you want to share your results, you have to manually send the file to everyone on your team, get their input, combine it into a new spreadsheet, rinse and repeat. Even if you resort to using online spreadsheets, you still face the challenge of sharing the document, setting the correct permissions and tracking changes. Yes, it can be done, but it takes a lot of time and resources, which is exactly why spreadsheets never leave the limits of their team in most organizations. As a result, each department tends to work in their own informational silo, and itÃ¢â¬â¢s a struggle to get any meaningful data for multi-functional projects or organization-wide metrics.
Loss of Knowledge
Another issue with managing organizational processes using Excel is that itÃ¢â¬â¢s usually a single person who creates that master-spreadsheet file. Those people will often protect the sacred knowledge and wonÃ¢â¬â¢t give anyone permission to make any changes. It can either be a legitimate fear of Ã¢â¬ÅtheyÃ¢â¬â¢ll screw it up, because they donÃ¢â¬â¢t understand how it works,Ã¢â¬ or a desire to retain their unique status in the company.
And what if that Master of Spreadsheets quits, gets sick or is struck by lightning? Good luck finding another volunteer able to or willing to take over.
Over the course of those months or years, that used-to-be simple table can become a monstrous Frankenstein, and its creator will be the only one who can tame or manage that wild beast of a spreadsheet; and thatÃ¢â¬â¢s the best-case scenario. More often, the Demiurge becomes a powerless Oracle, who only interprets the results spit out by the hornetÃ¢â¬â¢s nest of formulas and macros, without daring to touch or change anything.
Ã¢â¬ÅThatÃ¢â¬â¢s the way things are done here,Ã¢â¬ Ã is often a direct result of organizationÃ¢â¬â¢s inability to change the mechanisms powering their internal processes and workflows rather than a legitimate business reason.
Full disclosure: as a project management software vendor, I am biased. Biased the same way an addiction counselor is. Over the years IÃ¢â¬â¢ve seen hundreds of businesses ranging from mom and pop shops to teams at Fortune 100 companies who simply could not scale anymore because all of the their processes were based on Excel.
Of course, IÃ¢â¬â¢m not the only one who rings the alarm.Ã Tim WorstallÃ of Forbes warns:
Ã¢â¬ÅQuite simply, without Excel weÃ¢â¬â¢d not have had the incredible financialisation of the economy over the past 30 odd years. And if we hadnÃ¢â¬â¢t had that then we also wouldnÃ¢â¬â¢t have had the financial crash of 2007. So thereÃ¢â¬â¢s a dangerous piece of software for you.Ã¢â¬
Ã¢â¬ÅI donÃ¢â¬â¢t have time to learn any new systems. Excel is easy for us,Ã¢â¬ you might say.
Yes, itÃ isÃ easy. ItÃ¢â¬â¢s always easier and faster to take shortcuts. Just be ready to end up with a culture of patchworks. The moment you stop taking time to sit down and think about a proper solution, to learn new, better,Ã more effective ways of doing thingsÃ Ã¢â¬ is the moment you and your team stop innovating. ThatÃ¢â¬â¢s the moment youÃ¢â¬â¢ll become preoccupied with putting out fires instead.
DonÃ¢â¬â¢t get me wrong Ã¢â¬ IÃ¢â¬â¢m all for recreational use. You need a quick pie chart for your 4:20 presentation Ã¢â¬ go ahead and fire up Excel. Are you really intoÃ Grumpy CatÃ and have a lot of time on your hands? Who am I to judge? Of course, there are also specialized cases that Excel was made for, like crunching large amounts of data. Same as how morphine is a great tool to alleviate pain. ThatÃ¢â¬â¢s its main intention Ã¢â¬ as opposed to just getting high.
How to fight your addiction
- Ã The first step in fighting your addiction is to admit that you have one. You need to list and catalogue all processes that are currently managed with spreadsheets. (Hint: donÃ¢â¬â¢t use Excel for this list).
- Create a plan. ItÃ¢â¬â¢s never a good idea to go with a big bang approach and try to change things overnight. Pace yourself! Use a slow, but methodical step-by-step process. Rate each process or spreadsheet based on two criteria:
- Ease of replacement
Start with the items that are easiest to replace, Ã but will get you the biggest impact.
- Pick specialized products that were specifically built to manage each domain problem and are inherently collaborative. For example, if youÃ¢â¬â¢ve been using Excel to create invoices Ã¢â¬ considerÃ FreshBooks. Migrating your spreadsheet-based accounting Ã¢â¬ look atÃ Wave Accounting. Personal notes or companyÃ¢â¬â¢s knowledge base Ã¢â¬ check outÃ Evernote. The list can go on Ã¢â¬ do your research!
- There will be resistance. People hate change, so be ready to do an intervention. You need to be able to explain the consequences of keeping the status quo. Arrange a screening ofÃ TrainspottingÃ if you have to! DonÃ¢â¬â¢t be afraid to use use bad metaphors or Ã cliche to make your point.
ItÃ¢â¬â¢s also a good idea to pick vendors that offer full implementation and training, to help facilitate the transition for everyone in your organization.
ItÃ¢â¬â¢s a dark winter night. ItÃ¢â¬â¢s cold and windy outside. A group of people have gathered in the churchÃ¢â¬â¢s basement. Luckily you are not there. You are sitting in a local pub with the team celebrating yet another profitable quarter. Cheers!