An OEE spreadsheet that shows both definitions.
Seven inputs, both calculations, and the loss in rupees at your own machine-hour rate. Free, no email, every formula visible and editable.
A spreadsheet that computes OEE both ways from one shift's numbers: the ISO 22400-2 figure you can quote externally, and the MachineWise time-in-cut variant alongside it, so the difference between them is visible rather than asserted.
No email required, nothing to sign up for. It is a working file, not a lead form.
| Section | What it does |
|---|---|
| Inputs | Seven fields — shift length, breaks, unplanned downtime, ideal cycle time, parts produced, parts rejected, machine-hour rate. Orange cells are the only ones you type in. |
| ISO 22400-2 block | Planned production time, actual production time, then Availability, Effectiveness and Quality computed to the standard, with each formula stated beside it. |
| MachineWise variant block | Machine on-time and productive time in, Availability and Performance on the variant out — labelled clearly as not comparable to published benchmarks. |
| Loss value | Availability and performance loss converted to rupees at your own machine-hour rate, per shift and annualised on one machine. |
| Definitions footer | The distinction between the two methods, in the file itself, so anyone opening it later knows what they are reading. |
It opens in Excel, LibreOffice Calc and Google Sheets. Every formula is visible and editable — nothing is locked or hidden, because a spreadsheet you cannot inspect is not much use in an audit.
OEE calculator template, both definitions.
Excel format, 6 KB. No email, no sign-up, no follow-up call.
Download the template ↓Fill the seven inputs from one real shift, not from an average. Averages hide the variation that makes the exercise worthwhile, and a single honest shift is more informative than a month of estimates.
Be careful with two of them. The ideal cycle time should be the fastest the machine has demonstrably run that part — not the quoted rate and not the average, for the reasons set out in ideal cycle time explained. The machine-hour rate should be the absorbed cost your costing team uses for quoting, not the electricity cost, or the loss figure will be understated by a wide margin.
Then read the split, not the product. Sixty per cent from poor Availability and sixty from poor Performance are unrelated problems with different owners. The template shows all three factors separately for exactly that reason.
It cannot see what you did not record
Short stops are the largest under-recorded loss in most plants, and a spreadsheet inherits whatever your logbook missed. Expect the real figure to be lower.
One shift is a sample, not a trend
Useful for establishing a starting point and for settling an argument about definitions. Not useful for judging whether anything is improving.
It cannot attribute losses to causes
You get three factors, not a Pareto of reasons — and the Pareto is what actually gets a corrective action approved.
The usual reaction to a first honest OEE calculation is that it must be wrong. Occasionally it is — check the four common errors in how to calculate OEE before concluding anything. Far more often it is correct, and the surprise is the point.
If you want the same arithmetic without the spreadsheet, the online OEE calculator does both definitions in your browser. If you want it computed continuously from the machines themselves rather than from a shift you measured by hand, that is the OEE monitoring page.