When the spreadsheet becomes the brake
Most companies start the same way. November 2023: a meeting with a client from the railway industry, and a sentence we hear almost everywhere we go: “We have Excel, but we are slowly losing control of it.”
A year later the picture is completely different. Scattered spreadsheets have been replaced by an integrated system, operational errors have been all but eliminated, and preparing reports has gone from hours to minutes. This is not a story about technology — it is a story about fixing the foundations of a business.
A scale that outgrew the tools
Our client manages rail transport in Poland and abroad. Their team’s day is route planning, assigning train drivers, tracking rolling stock and complex reporting. For years, Excel was the engine behind all of it.
While the company was smaller, copying data by hand and dozens of phone calls between dispatchers did the job. But as the business grew, the seams started to split. Rolling-stock schedules began to clash and staff assignments went wrong. It was not the people’s fault — the data architecture simply could no longer keep pace with the company’s growth.
From diagnosis to solution
The first workshop took just three hours. We did not go looking for code straight away, but for answers: Where does the data leak? Who edits it? What does the business fear most? Because the client knew their bottlenecks inside out, we prepared the first specification almost immediately.
What changed with the rollout?
- Central order management: the full history and filtering in a single view, instead of digging through e-mails.
- Smart crew assignment: the system suggests train drivers who hold the right qualifications for a given route. The dispatcher’s decision rests on facts, not luck.
- Full control of rolling stock: every locomotive and wagon has a digital record with its status and job history.
- Automated maintenance: service requests are tracked from start to finish, with complete documentation in the cloud.
- One-click reporting: what used to take staff a large part of their day is now generated automatically, in the formats the authorities require.
The result: a business without the noise
We closed the first phase of the project in May 2024 — on schedule and within the agreed budget. The client gained more than lower costs and a competitive edge. They gained peace of mind.
Dispatchers no longer have to phone around to confirm a status — they simply see it. Information is available instantly, which has made decision-making dramatically faster.
A lesson for your company
The railway industry has its own specifics, but the problem of “shoes that are too small” in IT affects every sector, from logistics to banking. Excel is a brilliant tool for an analyst, but it rarely works as the operating system for dozens of people running the live heart of a company.
If you feel your operations are starting to outgrow the cells of a spreadsheet, let’s talk about designing tools that fit your scale.