Skip to main content

Do you accept 94% probability of an error?

It is an undeniable fact that spreadsheets are one of the most frequently used types of software. Just Excel alone has 750 million users, as Microsoft reports, and there are also other software solutions that share a portion of the market, such as Apple Numbers or Google Sheets. Those outstanding numbers show that spreadsheets have become a de facto standard for data analysis and manipulation and are widely used by businesses of all sizes from small to big, municipalities and other government organizations.

With that in mind, it is easy to imagine the tremendous impact that can be made by errors in spreadsheets. Unfortunately, those errors exist and are very common. And this is not just an assumption, there has been an actual scientific research and a number of papers was published on the subject. The errors were categorised in many ways, from hard-coded constraints, wrong formulas, forgotten rows to corrupted links. Researchers developed an auditing protocol and applied it on 50 real-life spreadsheets from various sources (consulting company, bank, college etc.). The results are quite disturbing: only 3 of 50 spreadsheets were without error, which means that 94% of spreadsheets contain errors.

It is hard to believe that so many people and organizations rely on such a risky tool. There is even a scientific group maintaining a list of “horror stories”, real-world cases and examples of how errors in spreadsheet caused several damage, mostly (but not only) financial. High fines, disrupted investors’ confidence and millions of dollars lost, these are just some of the consequences of forgotten minus signs, too many zeros at the end of the number or manually copied data.

Although spreadsheet software itself offers many powerful functions, it lacks means to verify and control the relationships between the data that are inserted, processed and analyzed. What is more, those means aren’t just something that can be added or plugged in in future. There aren’t any such means of control because the actual nature of spreadsheets, the way they are and work, doesn’t allow that kind of control. The only way to maintain data integrity is to use guidelines and methodologies, but another research shows that the majority of users states that “common sense” is their main testing method. This proves that, rather than to force users to follow guidelines and formal procedures, we have to build software which does it for them. We give you Lumeer, because we think that software is there to help you get your work done. Effectively. With minimum risk. And with great results.



How to track tasks for employees?

When multiple employees work on multiple projects, even in a small company it can easily happen that you lose track of who is doing what and on which project. However, it is very important to have quick and easy access to this kind information: you want to know progress on a project to plan for the future release, or you want to see if employees have some spare capacity or are too overwhelmed by the workload. 
Maybe you feel that all that information is being lost in a pile of spreadsheets and emails. They are all there, but to access them means to spend precious minutes or even hours on searching the documents, every time. You wish to have everything in one place, with every question about current status or capacity answered within seconds and with just a few clicks. You want to easily make changes that are smoothly and automatically propagated to relevant people in the company. In this article, we will show you how to achieve this with Lumeer.
After we login into Lumeer, we create …

How to effectively search and publish townhall meeting's resolutions

In previous posts, we created invitation to a townhall meeting and added minutes and comments. The collections are now filled with data and we will show you how to search those data and easily export them into publishable form.

After every townhall meeting, the municipality has to publish the resolutions which were approved during the meeting. To achieve that, we first search for the data we need by using Lumeer’s search box. We adjust the filters, hit enter and immediately see all resolutions from particular meeting.

We see the result of the search in table perspective, but we switch it to smart document perspective and produce the list of resolutions in a similar way that we have created the invitation.

Of course, we can choose how we want to export the document. Do we want to print it? Then we use export to PDF. Do we want to publish it on municipality’s website? We can put the PDF there, or, even simpler, we just put there the link to document which points directly to Lumeer, where t…

How do you search for your data in company IS?

“I need to look up that information.” This situation comes countless number of times every day and it’s not something people are used to look forward to. Looking for a particular piece of information often becomes a stressful and time-consuming procedure with uncertain result. You need to go through a number of systems – e.g. email, wiki, document server and other sources which are independent and not connected in any way. What’s more, in every of these sources, you have to be very concrete about what and where are you going to search for. Even if the data is stored in a typical information system or a spreadsheet, you need to specify the table and only after that you can get to the right report and finally see the data in the context.

But what can you do in the case you are not so sure about what exactly you are looking for and where it is stored? How can you do it without spending precious time trying to work out all the details?

Lumeer provides a solution to all these problems with …