OEE Tracking Template
A free, auto-calculating OEE log. Enter each shift's downtime, output and quality, and get Availability, Performance, Quality and OEE for every row plus a rolling total. Export to CSV or print, no signup.
Your OEE log
One row per shift or run. Ideal cycle time is the fastest your machine can make one part, in seconds. Everything else is measured on the floor.
| Shift / run | Planned time (min) |
Downtime (min) |
Total units | Good units | Ideal cycle (sec/unit) |
Avail. | Perf. | Qual. | OEE | |
|---|---|---|---|---|---|---|---|---|---|---|
| Period total | - | - | - | - | - | - | - | - |
Want the editable spreadsheet version?
We'll email a spreadsheet copy of this template plus the 2026 Manufacturing OEE Benchmark so you can see where your line sits. One email, no spam.
No spam. Unsubscribe anytime.
Prefer to skip the spreadsheet? Track it live, free.
The free OEE Tracker does everything this template does and more: log a shift and instantly get your OEE, your availability/performance/quality split, your downtime Pareto and how you compare to your industry. It keeps your history and builds your trend, no spreadsheet to maintain.
Open the free OEE TrackerA template measures the loss. Closing it is the hard part.
Most of the gap between a typical 60% OEE and world-class 85% hides in the short micro-stops nobody logs by hand. Fabrico reads OEE straight from PLC signals and uses computer vision to identify the true cause of each stop, then closes the loop to an automatically routed work order. It is EU-built with EU data residency and carries ISO 27001 / 20000-1 / 9001, which supports audit-readiness.
Book a Fabrico demoHow to use this OEE tracking template
- One row per shift or run. Label it (for example "Mon A") so the log reads as a timeline.
- Planned production time is the time the line was scheduled to run, in minutes (exclude planned no-production time like unstaffed shifts).
- Downtime is every minute the line was down when it should have been running: breakdowns, changeovers, minor stops, starved or blocked time.
- Total units is everything the line produced; good units is what passed first time (no scrap, no rework).
- Ideal cycle time is the fastest the machine can make one good part, in seconds. The nameplate or best-ever cycle is a good source.
The template then calculates the three OEE factors for each row and a rolling total for the whole period:
- Availability = run time / planned time, where run time = planned time minus downtime.
- Performance = (ideal cycle time x total units) / run time. It captures speed loss and micro-stops.
- Quality = good units / total units.
- OEE = Availability x Performance x Quality.
Prefer a single-run calculator, or want to check one number quickly? Use the OEE calculator. For the formula and worked examples see how to calculate OEE, and to understand where the losses come from read the six big losses and Availability vs Performance vs Quality.
What should an OEE tracking template include?
Five measured inputs per shift: planned production time, downtime, total units, good units and the ideal cycle time. Everything else (Availability, Performance, Quality and OEE) is calculated from those, which is exactly what this template does.
How do I track OEE across many shifts?
Add one row per shift and read the "Period total" line and rolling OEE tiles. The rolling figure aggregates run time, output and quality across every row, so it reflects the whole period rather than an average of averages.
Can I export it to Excel or Google Sheets?
Yes. Use Download CSV to open the log and all calculated columns in any spreadsheet, or Print / PDF for a clean one-page copy.
Why is my Performance above 100%?
That usually means the ideal cycle time is set too slow. Set it to the genuine fastest cycle the machine can achieve; Performance should sit at or below 100%.
All OEE Lab tools · Downtime log template · PM checklist template