The Indispensable Swiss Army Knife for Professionals and Managers

In many companies and organizations, spreadsheets such as Microsoft Excel, Google Sheets, LibreOffice Calc, or Apple Numbers have become the go-to tool for a virtually endless range of use cases. They help people get a wide variety of everyday tasks done efficiently, e.g., planning, visualizations, reports, what-if analyses, budgeting, forecasting, and more. The immediate benefits are obvious:

  • Every employee is familiar with spreadsheets and can start working with them right away, without any prior training.
  • A spreadsheet application comes pre-installed on every workstation.
  • Any kind of data can be quickly structured and organized in the grid.
  • With formulas, formatting, charts, and many other features, almost any requirement can be met without having to call in a specialist.

What Do Spread­sheets Really Cost?

Given how important spreadsheets are across large parts of the economy, IDC, the world's leading IT market research firm, conducted an in-depth study of spreadsheet use . Among other things, it found that knowledge workers spend up to 26 hours a week working with spreadsheets. Of those, 8 hours a week are spent on repetitive tasks, e.g., updating data via copy-and-paste, formatting, or gathering and merging data sets.

The widespread use of copy-and-paste is a major source of inefficiency and waste
IDC Advanced Spreadsheet
Users Survey
Media disruptions and data scattered across multiple applications are responsible for reduced knowledge worker productivity.

In other words, specialized knowledge workers spend around 20 % of their working time on trivial "fiddling." Given the shortage of skilled workers and growing complaints about administrative burden, this is a real wake-up call. According to IDC, this adds up to 1.3 billion working hours, or 60 billion dollars, in the U.S. alone.

How Risky Is the Use of Spread­sheets?

As a spreadsheet grows in size and age, further risks and hidden costs come into play:

  • Security risks due to the lack of solid access control: Which users may read, create, or modify certain records? Which user changed a particular entry, when, and why?
    Case study: In 2017, a Boeing employee emailed an internal spreadsheet to his wife to use as a formatting template. This caused a critical data leak, as the spreadsheet contained sensitive data on approximately 36,000 employees in "hidden" columns .
  • Spreadsheet formulas and structures are often undocumented. Individual power users pour their heart and soul into maintaining their spreadsheets. But when these knowledge holders leave the team, the spreadsheets often receive only rudimentary maintenance. And when they are eventually replaced, valuable process knowledge and experience are lost.
  • The potential for hidden errors, faulty formulas, or inconsistent data increases. According to a University of Hawaii study, 94 % of all spreadsheets contain errors .
    Case study: Due to a spreadsheet handling error, England's public health agency delayed contact tracing for 15,841 COVID-19 cases, resulting in between 1,521 and 2,049 additional deaths .
Chaotic spreadsheet
YouTube As spreadsheets age, their complexity grows – clarity is lost and they become increasingly error-prone.

These many risks materialize every day in real-world work. The European Spreadsheet Risks Interest Group is dedicated to this issue and, among other things, maintains an interesting list of spreadsheet disasters .

Shouldn't We Be Able to Do Better by Now?

VisiCalc, the first spreadsheet software, hit the market as early as 1979 (see this worthwhile article in the Financial Times ) and, starting in accounting departments, went on to conquer the world. Since then, however, the basic principles of working with spreadsheets have hardly changed.

More than 40 years later, the low-code movement is now poised to revolutionize the world of work once again. The core idea behind low-code platforms is to use modern web technology to simplify and speed up the development of business applications so dramatically that spreadsheets are no longer needed. Since hardly any code is involved – hence the name – engaged users can maintain their low-code applications themselves as so-called "citizen developers."

On low-code platforms, business requirements can be implemented up to seven times faster than with conventional programming and up to three times faster than with spreadsheets . Existing spreadsheets can now even be transformed automatically into a low-code application. Authorized users then have immediate access to the data as a modern, high-performance web app in their browser and on their smartphone.

Screenshots of a low-code application on a desktop computer and smartphones
Thanks to modern web technologies, low-code applications run on desktop computers as well as tablets and smartphones without any prior installation.

A modern low-code platform integrates artificial intelligence, workflow and BPM functionality, and robotic process automation. Instantly configurable interfaces to surrounding systems relieve users of routine tasks, eliminate media disruptions, and do away with copy-and-paste. For managers, they provide a clear dashboard view with the most important data and live charts.

Low-code applications combine the advantages of proven off-the-shelf software with those of professional custom software:

  • Unlike off-the-shelf software, a low-code application can be tailored to your own specific needs. Later adjustments due to changing circumstances are also easy to make.
  • Unlike custom software, development doesn't start from scratch, because the low-code platform provides a wide range of mature components. And since a new low-code application can be built in an agile way within days, there's no need to launch a costly development project involving multiple parties or capital expenditure requests.

What Does Introducing Low-Code Look Like in Practice?

This is best illustrated with a short case study: The employee assistance department of a global industrial group uses around two dozen spreadsheets, documents, and templates every day for client data, case documentation, task management, time and service tracking, and reporting. In addition, the social workers operate several SAP modules and an internally developed database.

Over the years, increasingly complex administrative tasks take up a growing share of working time, until the head of the department finally manages to secure a budget of 30,000 euros for a dedicated software solution. It quickly becomes clear that no off-the-shelf software on the market adequately covers the department's needs. At the same time, the available budget is too small for custom development. The department therefore decides to go with Protogrid, the low-code platform developed by ETH engineers.

Two Protogrid specialists hold an initial low-code workshop with the department's managers. Together, they consolidate and prioritize the requirements for the new solution. At the same time, a first version of the new "Employee Assistance" app is built live on the projector. This lets the future users immediately get a concrete picture of the new app and step in directly.

Screenshot of the employee assistance solution
All employee assistance work processes are covered in a single, user-friendly low-code application.

The very next day, the department is already actively trying out the new app, gathering valuable feedback and noting further ideas. This forms the basis for the follow-up workshop two weeks later. Together, the team refines the app and extends it with additional features. This time, however, the roles are reversed: The dedicated head of the department rolls up her sleeves and takes over further development of the app herself. The Protogrid specialists support her with tips and tricks.

By the end of the second low-code workshop, the app already meets all of the department's requirements. Only one thing is still missing: Following the workshop, the Protogrid engineers additionally implement automatic SAP synchronization in close coordination with corporate IT.

Since then, the social workers have handled their daily work entirely in the new app and can focus fully on working with their clients. The users continuously improve their app and keep adding new features. When needed, they bring in the Protogrid engineers for targeted support.

Bottom line: In less than a month, a new low-code application went live and a vibrant citizen developer culture was established. Requirements were met for which there would otherwise have been no solution other than continuing to juggle various spreadsheets, file shares, and third-party systems.

What Is Protogrid?

Protogrid is a Swiss platform for web-based, platform-independent, and therefore future-proof business applications. Protogrid was designed in 2012 by the ETH engineers of ATEGRA AG . Since then, Protogrid has been used successfully across a wide range of industries for tailor-made business applications and is valued not least for its clean, user-friendly interface.

Zurich skyline
Protogrid's headquarters are located at Kreuzstrasse 60 in Zurich .

Protogrid is continuously adapted to evolving software and hardware systems and is constantly being developed further, so customers benefit both from a high degree of future-proofing and from a steady stream of innovative new features.

What Are Your Options?

Since low-code requires neither installing software nor setting up servers, and no special technical skills are needed, any manager or team can in principle take the initiative themselves. Just like when creating a new spreadsheet, IT doesn't need to be involved.

The following five approaches have proven effective:

  • Hold a workshop with citizen developers
  • Run a trial period to gain hands-on experience
  • Transform an existing spreadsheet into a new low-code application
  • Build a test app yourself to get the most realistic impression possible of working with a low-code platform
  • For your next planned software development project, request a comparative low-code quote or build a proof of concept

Our  Low-Code Assessment recommends the best approach for you. It takes 1 - 2 minutes and delivers a concrete result right away, without requiring any contact details.

If you're somewhat skeptical about low-code or would simply like to get to know the technology better first, one of our engineers will be happy to show you live how he builds a proof of concept to your specifications within minutes. Just book a convenient  online meeting.

Alternatively, you can send us an  email describing your requirements and ideas. A few keywords are perfectly sufficient. Our engineers will then give you direct feedback on whether a low-code implementation makes sense and what it might look like.