Skip to main content

Are you a heavy spreadsheet user too?

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.



How to create a comprehensive overview of job postings

Managing information about two or three job postings at your company is easy and can be done even in some simple tool or spreadsheet. However, as the number of postings, candidates and other information grows, it becomes increasingly difficult not to get lost in the data and maintain a clear overview. There are candidates with their names, addresses and positions they are applying for. There are also job postings with salaries and managers who want to hire people for those positions. Those pieces of information are related to each other and we will show you how to effectively manage and view them with Lumeer. As Lumeer allows us to put similar data to collections, we will want to store information about candidates, job postings and company’s employees in separate collections. It’s the most intuitive way because candidates have similar attributes, e.g. name, address, phone number or the date they applied for a job at the company. On the other hand, postings have their names and salaries…

How to track and manage your suppliers

Whether it is construction, manufacturing or digital services, supplier management appears in every business field. You need to track your suppliers and orders either for materials, tools or office supplies, and it can surely become a mess. In this article, we will show you how Lumeer will help you store and see all the information in one place.

We will use a chemical laboratory as a model example, but don’t worry, you will see that the supplier management principles are the same across all industries. We identified three basic entities: suppliers, orders and inventory items. Let’s create a collection for each one of them (if it’s the first time you are creating a collection, First time in Lumeer article can help you with that):

Then we fill the collection with all the items that we obtain from our suppliers:

And also with our suppliers:

Now we have two tables, but they don’t give us a complete picture, because they are missing the information about which supplier to contact when ordering…

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 …