Skip to main content

The Excel half-life - how quickly your data crash?

It often starts with a simple task – to create a small report in a spreadsheet. You know that you need just a few charts and tables, and using spreadsheet is the fastest and the most convenient way to do it. However, soon after that, you find out that a report is never small enough. Your boss asks you to add some data that weren’t considered before, and another chart, and then change some numbers...
Actually, the report has become a living organism that is constantly changing according to the current needs. More questions arise – what if we tried this and that, what if we added one last chart, what if we changed the parameters slightly? There is always something to improve and you want your report to be as good as it can be, don’t you? So, the data are copied, duplicated, modified and the functions are getting more and more complex for the sake of soon-to-be perfection (in which you still believe).
The report is getting bigger and better, you think you’re almost finished, and then it happens… Wait, few cells are missing from the range, let’s fix that! By the way, what is the exact meaning of this column? Is this per week or overall value? How come that when I change the values, the chart is unaffected? Suddenly, everything is breaking down and the more you try to save it, the more impossible it seems.
Have you ever been through this spreadsheet nightmare? We bet you have. How long did it take for your spreadsheet to fall apart and make you start again from scratch? We bet it was before you delivered the results but after you spent enough time to feel disappointed and not productive.
Sure, spreadsheets are accessible and easy to use. On the other hand, they carry a lot of risks – from data integrity (wrong ranges, duplicates, wrong values) to wrong formatting (decimal separator). These all seem like little things but can ruin complex reports because they are so difficult to find and manage. And in spreadsheets all of this is a hard manual work.
Imagine you were not alone while creating the report. Wouldn’t it be better, if not only you, but also the system knew the meaning of the data you’re working with, and could address and eliminate those spreadsheet risks? Even give you hints about which formula/value/function could be useful for you right at that moment? We know about one guy that can do exactly that, and his name is Lumeer!
While creating your tables and filling in data, Lumeer tries to recognize what is the meaning of individual values. When unsure, he just asks you for a confirmation. He makes sure to always cover all your current data and that the records stay consistent. You can walk a long path and build another computations on the previous data and search results. Later, when putting more types of data into a context in a chart or any other visual report, Lumeer tries to suggest you some configurations based on what he already knows. When you do not like the output, you can directly edit the original data by dragging objects in a chart. You can also perform batch operations when there is something to be fixed. Lumeer is like your colleague who does all the hard work for you.

Comments

Favorites

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 …