You walk into a modern factory. Robotic arms are flying around you, autonomous vehicles are moving pallets, and large screens display cloud-based data in real time.
But if you look over the shoulder of the production manager or chief planner, chances are you’ll see a familiar grid on the monitor.
Excel.
Despite multimillion investments in robust ERP (Enterprise Resource Planning) systems, Excel remains the symbolic “pencil and paper” of industry. It’s the tool that handles everything from daily shift planning to complex job-cost calculations.
Why do we love it? Why does it scare us? And how do we survive with it in the jungle of industrial management?
Why Excel Is Still King
In an industrial environment where priorities change faster than the weather, Excel offers several irreplaceable benefits:
Absolute Flexibility
Need to quickly add a new production line to the plan or account for a supplier outage in Asia? In an ERP system, you might wait for IT approval. In Excel, you just insert a row and drag the formula.
Democratization of Data
Everyone in the company — from shop-floor supervisors to the CFO — can (more or less) work with Excel. It’s the universal language of business.
Zero Additional Cost
You already have it installed. No new licenses. No expensive consultants for every small reporting change.
The Perfect Sandbox (Prototyping)
Before investing in an expensive Advanced Planning and Scheduling (APS) module, you can test your planning logic in Excel and see what actually works.
The Dark Side of the Grid
With great power comes great responsibility — and in Excel’s case, great risk. In industrial planning, even a small mistake can have serious consequences.
1. The Human Factor as the Weakest Link
One accidental overwrite of a formula with a fixed value, one forgotten filter — and your material purchasing plan is off by hundreds of thousands. Excel does not protect data integrity the way databases do.
2. “Excel Hell”
You know the drill:
- Production_plan_2025.xlsx
- Production_plan_2025_FINAL.xlsx
- Production_plan_2025_FINAL_v2_FIXED.xlsx
- Production_plan_2025_FINAL_v2_FIXED_Karel_after_coffee.xlsx
Once multiple people work on the same file, informational chaos begins. No one knows which version is the “truth.”
3. Dependency on the “Excel Wizard”
Almost every company has one — “Jirka from Logistics” — who built a massive file full of macros and interlinked sheets. As long as Jirka is there, everything works.
But when Jirka goes on vacation — or worse, joins a competitor — the planning process collapses because no one understands how the black box works.
4. Performance Limits
Excel is not a database. Start feeding it five years of production data with thousands of rows, and the file takes ten minutes to open. Every recalculation comes with laptop fan noise and a silent prayer that the program doesn’t freeze.
When Planning “Works”
Imagine a mid-sized engineering company. Planner Karel uses a massive Excel file to calculate paint shop capacity. To make navigation easier, he uses hidden columns for “helper calculations.”
One day, Karel accidentally selects an entire column with unit quantities and presses Delete. Because he had a filter on “Completed Orders,” he thinks nothing happened.
But the total paint consumption formula was linked to all data — including the hidden rows.
The result?
The “system” (Karel) reports that only 5 liters of blue paint are needed next week instead of the usual 500 liters. The warehouse doesn’t order more.
Tuesday morning: the paint shop stops. Ten painters are playing cards in the locker room. The company director turns redder than the paint they have plenty of — but don’t need.
Lesson learned: Excel is a great servant. But if you’re running a company worth millions on it, it can become a very unpredictable master.
Conclusion: What’s the Way Out?
Excel will not disappear from industry — and it would be foolish to try to eliminate it. It is the digital pencil we need for quick sketches and operational adjustments.
The key is knowing when to put the pencil down and pick up “proper technical documentation” — meaning specialized software.
The golden rule:
If the operation of an entire production line — or employee payroll — depends on one Excel file, and the file is so complex you’re afraid to even save it, it’s time to consider a change.