Your OEE Score Is a Lie And Excel Is the Reason
Written by Ketsol Manufacturing Suite
Industrial Data & AI Practitioners | OT/IT Convergence Specialists.
Ketsol is an industrial technology firm specialising in data infrastructure for manufacturing environments. With over 15 years of experience across discrete and process industries, the team has delivered large-scale data architecture and IIoT implementations, including work with Tier-1 manufacturers.
Core expertise includes Unified Namespace (UNS) architecture, industrial data modelling, and AI readiness for production systems. Ketsol combines deep operational understanding with modern data engineering practices to bridge the gap between OT and enterprise systems.
Published: May 2026
We’re Running at 84%” Are You Sure About That?
It’s 10:15 a.m. The morning review is wrapping up.
The plant head glances at the Excel sheet and announces:
“We’re running at 84% OEE. Good week.”
Heads nod. Someone notes it in the minutes. Leadership is satisfied.
But here is the question nobody asks: where did that 84% come from?
If the answer is a manually filled shift log compiled by an operator at the end of a 12-hour shift, averaged into a spreadsheet, and sent upward, then that number is not a performance metric. It is a best guess dressed up as data.
And the uncomfortable truth, backed by real-world data from over 15,000 connected machines across 18 countries, is this:
Your 84% may be 68% in reality. And every decision sitting on top of that number hiring plans, capacity targets, capex approvals, customer commitments, is sitting on sand.
This is not about blame. Nobody is falsifying data. This is about what happens when a 1990s tool is asked to do a 2026 job.
“If you have explored how Excel slows down your daily production review, this goes one step further it is not just slow, it is structurally inaccurate.”
Why Does Excel Inflate OEE, Without Anyone Trying to Cheat?
Excel does not lie intentionally. People do not lie intentionally either. The inflation happens structurally, across three unavoidable failure points.
Failure 1 — Operators round in their favour, naturally
An operator running behind on a shift does not carefully log a 4-minute unplanned stop caused by a jammed conveyor. They log it as part of a “changeover” or absorb it into the break window. Not because they are dishonest, but because the categories are ambiguous, the form is inconvenient, and the shift is already over.
4 minutes × 3 shifts × 25 days = 5 hours of invisible downtime every month.
Failure 2 — Downtime gets systematically under-reported
Short stops under 2–3 minutes rarely make it into a manual log. Yet in most plants, these micro-stoppages account for 15–25% of total production loss. They are invisible in Excel. They are unmissable with automated machine-level capture.
Failure 3 — Data arrives cold
By the time an Excel-based OEE figure reaches a plant manager, the shift it describes is already history. In Indian manufacturing, where only 25–30% of plants use real-time production data today, the standard operating mode is reactive. You are reading a post-mortem, not a live feed.
We covered the full cost of this delay in The ₹Crore Mistake including how Indian plants lose crores annually to reporting lag alone.
The result is a number that feels precise to two decimal places, colour-coded cells, but reflects what operators believed happened, not what machines recorded happening.
What Does a 10-Point OEE Gap Actually Cost an Indian Plant?
Let us make this tangible.
A mid-size auto-component plant in Pune, 3 shifts, 25 production days a month, ₹80 lakhs of installed daily capacity, running a real OEE of 72% but reporting 84% is carrying a ₹2.4 crore monthly blind spot.
Over a year: a number that belongs in a board conversation, not buried in a shift log.
This is not a technology problem. It is a visibility problem, and visibility problems in manufacturing always have a rupee value attached.
The Moment the Truth Arrives,
What Happens When Machines Start Talking?
When a plant connects machine-level sensors to an automated production reporting system for the first time, there is almost always a difficult week.
The OEE dashboard drops. Sometimes sharply.
Operators are confused. Supervisors are defensive. Plant heads want to know why efficiency “fell” overnight.
It did not fall. It was revealed.
This is exactly what happened at Meleghy Automotive when they automated OEE capture across 6 plants, stamping, joining, and coating with bidirectional ERP integration. The real numbers appeared for the first time. And once the initial discomfort passed, the improvement began in earnest: 5% availability improvement and 7% higher output, measured, not estimated.
Manufacturing companies that switch from manual tracking to automated OEE capture typically achieve 10 to 15 percentage points of OEE improvement within the first six to twelve months, not because the machines changed, but because the truth changed what people focused on.
You cannot improve a number you cannot accurately see.
What Decisions Has Your Plant Made Based on a Lie?
This is the question that should sit with every operations leader for a moment.
When OEE is inflated by 10–15 points, the downstream decisions built on it carry that inflation forward:
- Capacity expansion decisions made when existing capacity was actually under-utilised
- Hiring approvals justified by output targets that were never realistic
- Customer commitments made on delivery timelines that assumed a performance level the plant was not hitting
- Improvement project priorities aimed at the wrong bottlenecks because the real ones were hidden in micro-stoppages that never made the log
None of these decisions were made in bad faith. They were made with the best available data. The problem is that “best available” and “accurate” are not the same thing when the data source is a manually filled Excel sheet.
What Does Honest OEE Change on the Shop Floor?
When a plant moves from Excel-based reporting to a live factory reporting system, the change is not just in the numbers it is in the conversations.
- Morning reviews become forward-looking. Instead of debating what happened on the night shift, teams are looking at what is happening right now and adjusting.
- Accountability becomes specific. “Line 3 dropped 8% between 6 a.m. and 8 a.m. due to 14 micro-stoppages on the press cycle” is a different conversation from “output was a bit low last night.”
- Improvement energy goes to the right place. When you can see a Pareto of your real downtime causes, not the ones operators chose to log, you stop solving the wrong problems.
Plants that automate production reports in factories consistently report an 8–15% reduction in downtime within 12 months, not from new machines or new people, but from finally seeing where time was actually going.
Is Your OEE Trustworthy? 5 Questions to Ask Today
Before your next morning review, run through these honestly:
- Is your OEE calculated automatically from machine signals, or filled in manually by operators?
- Are stops under 3 minutes being captured or falling through the cracks?
- Do your OEE figures come from the same shift they describe, or are they compiled hours later?
- Are downtime categories defined clearly enough that two different operators would log the same stop the same way?
- When was the last time your reported OEE surprised anyone upward or downward?
If the answers are uncomfortable, the number is probably not the problem. The method is.
The Shift Your Plant Actually Needs
Replacing Excel for production reporting is not an IT project. It does not require a year-long ERP implementation or a team of data scientists.
The plants moving fastest in India right now are starting with one thing: clean, automatic data capture at the machine level. OPC-UA, PLC integration, edge computing the building blocks exist, and they connect to existing equipment without production interruption.
From there, the daily plant review stops being a retrospective and starts being a tool.
If you have been working with a number that feels slightly too comfortable, it probably is. The first step is simply deciding you want to know the real one.
Frequently Asked Questions
Why is Excel not enough for manufacturing reporting in 2026?
Excel captures what people remember and choose to record after the fact. Modern manufacturing moves too fast for retrospective, manually entered data. Short stops, speed losses, and quality failures that happen in real time are routinely missed or misclassified, making any OEE figure built on Excel structurally inaccurate.
How much can automated OEE reporting improve plant performance?
Data from over 15,000 connected machines shows plants switching from manual to automated OEE tracking achieve 10–15 percentage point improvements within 6–12 months. Even without advanced AI, basic real-time tracking delivers 8–12% output improvement within the first year for most Indian plants.
What is the difference between plant daily review software and a regular MES?
A full MES manages production orders, quality, scheduling, and traceability across the entire manufacturing process. Plant daily review software focuses specifically on giving operations teams a live, accurate view of shift performance, OEE, downtime causes, and line speed, so morning reviews are based on facts, not recollections. Many plants start with daily review tools before scaling to a full MES.
How difficult is it to connect production reporting software to existing machines?
Modern industrial platforms use standardised protocols OPC-UA, Modbus, and direct PLC signals to connect to equipment without modifying machine controllers or interrupting production. Legacy machines without modern interfaces can be connected via IoT gateways that tap directly into electrical signals. Most connections are completed without any production downtime.
How do I reduce reporting time in manufacturing without replacing existing systems?
Start by automating data capture at the machine level . This eliminates the manual shift log. Layer a dashboard on top that aggregates the data automatically and sends shift reports by email at the end of each shift. Most plants report a 30–40% reduction in reporting effort within the first month of switching from Excel to an automated factory reporting system.
About This Article
This article is based on industry best practices and real-world implementation experience from Ketsol’s work across manufacturing environments adopting Industry 4.0 architectures, including MES integration, IIoT deployment, and unified data strategies aligned with ISA-95 standards.