81% companies use spreadsheets
The rise of spreadsheets in early 80’s meant a revolution in a way how business data is stored, processed, analyzed and presented. Suddenly, there was no need to use physical sheets, because everything could be stored in a set of tables that were more flexible, more understandable and could effectively perform useful calculations. In those days, it had to look almost like a miracle.
VisiCalc, the first widely used spreadsheet software [ source ]
Since then, spreadsheets became the first choice when it comes to working with data in many business. They are easy to start with, offer a lot of flexibility and even unexperienced and non-professional users can use it as a sandbox to experiment with their data. It is quite usual to have some data in advance and no idea what do we want to search for in these data.
Also, since then, the times they are a changin’. The amount of data entered into spreadsheets grow and they are becoming more and more complex. However, their functionality and possibilities are not growing so fast and are now imposing significant limitations on their usage. But the spreadsheets are so hard-wired into the minds of people that they continue to be used even if they are error-prone and difficult to manage – there is a report that reads: 81% of businesses still use spreadsheets.
The question we ask ourselves is: Why do people continue using spreadsheets instead of turning to other solutions? We are convinced the answer is that it’s because there is no product on the market that would meet all their needs. Either they are too complex, too expensive or the learning curve is so steep that it requires hours and days of specialized training. We want to change that with Lumeer, so that you can manage your data effectively and intuitively, without adapting your habits and processes to software, and without expensive and time-consuming training. We provide you with an environment to experiment with your data the way you want but without constraints imposed by spreadsheets. Just simple as that.
As spreadsheets are easy to start with and learn, there is a huge number of businesses that use them for keeping records and data analysis. The results are further used for predictions and decision making – definitely very important, sometimes even mission critical tasks.
On these terms, it is quite scary that more than 90% of spreadsheets contain errors. As might be expected, nobody wants to make predictions and decisions based on wrong data, and the only way to minimize errors is to introduce policies and guidelines on how to create and manage spreadsheets. Unfortunately, you can’t get that for nothing. And what’s the price? Your own time. Your most precious resource.
According to a study conducted as a part of the Spreadsheet Engineering Research Project, a majority of users spends up to 50% of their time working with spreadsheets. Unless the person’s job belongs to the field of data analysis, that number is really high. We think that the main cause is a typical spreadsheet lifecycle which has seven interconnected stages, each of them requiring non-trivial effort:
[ source ]
The first step requires you to at least briefly design your spreadsheet even before you actually create it, so you can avoid changing it later. However, we all know that a spreadsheet report is not etched in stone, it rather resembles a living organism. There will always be something to change or add and the software you use has to encourage it, instead of forcing you to know almost everything in advance.
Another time-consuming step is documentation. Mostly, the data is not self-explanatory and you or someone else will have to use them again in future. But the spreadsheet itself knows nothing about the meaning of the data. If there is no documentation, there is no understanding. What if the software you use would know something more about your data than just letters and figures, so you don’t have to write extensive documentation?
What about the team work? We don’t consider emailing file attachments and maintaining multiple historical copies an option. In today’s world, collaboration is a must and if your software supports it in real time, it saves your time.
We believe that software must adapt to your processes, not vice-versa, and that’s the way we build Lumeer. Because there are so many better ways to spend 50% of your time than fighting with your software.