Free OEE Calculation Excel Template
A structured Excel workbook with Availability × Performance × Quality formulas pre-built — collect shift data, calculate OEE per machine, and pinpoint which loss category is stealing the most throughput.
What you get
A working OEE calculation Excel template plus a free 30-day trial of Resource Manager for Excel (RMX) — the tool manufacturers use when manual shift-data entry can no longer keep pace with real-time equipment performance demands.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Overall Equipment Effectiveness (OEE) is the single most widely cited metric in manufacturing improvement programs — and also one of the most frequently miscalculated. Most shops track uptime. Fewer track performance rate against ideal cycle time. Almost none consistently track first-pass quality yield at the machine level on a per-shift basis. The result is an OEE number that flatters the operation because two of the three factors are either ignored or estimated. A shop that believes its OEE is 82% when the real figure is 61% is making investment, staffing, and scheduling decisions on bad data.
The formula is deceptively simple: OEE = Availability × Performance × Quality. Availability is the percentage of scheduled time the machine was actually running (planned stops excluded, unplanned stops counted). Performance is actual output versus theoretical maximum output at ideal cycle time — this is where most shops bleed. Quality is first-pass-yield: good parts as a percentage of total parts started, with no rework credit. Multiply all three and you get a number that tells you how efficiently your most critical assets are converting scheduled time into good product.
A world-class OEE benchmark is 85%. Most discrete manufacturers operate in the 55–75% range. The gap between where you are and 85% is not a mystery to be solved — it is three specific loss categories (availability loss, speed loss, quality loss) each with identifiable root causes. This template structures your data collection to make that breakdown visible, shift by shift, machine by machine.
What's inside the template
Shift data entry form
Per-shift input for scheduled time, planned downtime, unplanned downtime, ideal cycle time, actual output, and rejected/rework parts — the six raw numbers that drive every OEE calculation.
Availability calculator
Automatically computes run time as scheduled time minus all stops, then divides by scheduled time. Distinguishes planned stops (changeovers, PM) from unplanned stops (breakdowns, waiting for material) so you can allocate improvement effort correctly.
Performance rate calculator
Compares actual parts produced against theoretical maximum at ideal (nameplate) cycle time. A performance rate below 95% almost always indicates hidden micro-stoppages or speed losses that operators do not log because each event is too short to feel like downtime.
Quality yield calculator
First-pass yield computed from total parts run versus confirmed good parts. Rework is counted as a loss even if the part eventually ships — rework consumes machine time that could have produced good product.
OEE summary dashboard
Rolls Availability × Performance × Quality into a single OEE score per machine per shift, with a 4-week trend chart and a benchmark line at 85% so deviation is visually obvious without additional formatting work.
Loss category breakdown
Six-big-loss waterfall chart: breakdowns, setups and adjustments, idling and minor stoppages, reduced speed, process defects, and reduced yield at startup. Sizes each loss in equivalent minutes per shift so you know which one to attack first.
Multi-machine comparison tab
Summarizes OEE across all tracked machines in a single ranked view. Useful for monthly management reviews, capital justification, and identifying which asset needs the next PM interval shortened.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
Define your machines and ideal cycle times
On the Machine Master tab, list every asset you want to track. For each one, enter the nameplate cycle time — the rate the machine is designed to run, not the rate it actually runs. If you do not know the nameplate rate, use the engineering estimate or the rate from the last time the machine ran without any constraints. This is your performance baseline and it must be honest; padding it produces a flattering OEE that hides real speed loss.
- 2
Set your shift calendar and planned downtime
On the Shift Calendar tab, enter your scheduled production hours per shift per machine. Then list planned downtime events — changeovers, preventive maintenance windows, scheduled breaks. These are excluded from the availability denominator because you cannot be faulted for time you did not plan to run. Unplanned stops (breakdowns, waiting for material, operator absence) stay in the loss column.
- 3
Collect shift data and enter it daily
At the end of each shift, the operator or supervisor fills in: actual run start/stop time, each unplanned stop event with duration and reason code, actual parts produced, and parts rejected or sent to rework. Five minutes per shift per machine. If this feels like too much, that is a sign the data collection is not being owned — which is the most common OEE implementation failure.
- 4
Review the OEE dashboard weekly
The dashboard tab automatically calculates Availability, Performance, Quality, and OEE for each machine for the current week. Look at the trend lines, not just today's number. A machine with 72% OEE and a declining trend needs a different response than a machine with 72% OEE and an improving trend. The six-big-loss waterfall tells you which category is driving the number.
- 5
Prioritize improvement using the loss breakdown
Sort the loss waterfall by minutes lost per week per machine. The largest bar is your first improvement target. If it is breakdown losses, open a corrective maintenance initiative. If it is speed loss (performance rate below 90%), investigate micro-stoppages and operator-controlled speed reductions. If it is quality loss, audit the setup procedure and first-article inspection process. Each category has a different improvement toolkit.
- 6
Set improvement targets and track progress monthly
After your first four weeks of data, you have a baseline. Set a 90-day OEE target for each machine — typically 3–5 percentage points above baseline for a first improvement cycle. Use the multi-machine comparison tab for monthly leadership reviews. A rising OEE trend is the evidence that your improvement program is working; a flat or declining trend means the root cause has not been addressed.
When you outgrow this template
Excel is the right answer for early-stage scheduling — until it isn't. Here are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown Excel scheduling. The good news: you do not have to leave Excel behind. Resource Manager for Excel (RMX) is a real finite-capacity scheduling engine that runs as an Excel add-in — so your team keeps the interface they know while gaining the scheduling power of a dedicated APS tool.
Learn about RMXFrequently asked questions
Is this OEE calculation Excel template really free?+
Yes. The template is included with the free 30-day trial of Resource Manager for Excel (RMX) from User Solutions — no credit card required, no obligation. The trial gives you access to all scheduling and capacity planning templates in the library, including this OEE workbook.
What is a good OEE score for a discrete manufacturer?+
World-class OEE is typically cited as 85% (Availability ~90%, Performance ~95%, Quality ~99.7%). Most discrete manufacturers operate in the 55–75% range. If your OEE comes in above 85% on your first measurement, double-check your ideal cycle time — it is often understated, which inflates the Performance factor artificially.
Should I include planned downtime in my OEE calculation?+
Standard OEE (as defined by SEMI E10 and the OEE industry standard) excludes planned downtime from the Availability denominator. You are measuring effectiveness during scheduled production time. However, some manufacturers track a separate metric called TEEP (Total Effective Equipment Performance) that includes planned downtime — this gives a true ceiling utilization view. This template calculates standard OEE by default and includes a TEEP column for reference.
How do I handle changeovers in the OEE calculation?+
Changeovers are planned downtime if they appear in the shift schedule, and unplanned availability losses if they exceed the planned window. In practice: enter the planned changeover duration as scheduled downtime and count any overrun as an availability loss. Many manufacturers also track changeover time separately as a SMED (Single-Minute Exchange of Die) metric because reducing changeover is often the highest-ROI availability improvement available.
Can I use this template for a job shop with highly variable cycle times?+
Yes, with a modification. For job shops where each work order runs at a different cycle time, use the work-order average cycle time as your ideal cycle time for the Performance calculation on that shift. The template supports a per-shift ideal cycle time override field for exactly this scenario. The OEE number becomes less comparable across shifts but remains valid as an efficiency signal within each shift.
When does it make sense to move from this Excel template to EDGEBI?+
When you need live OEE dashboards fed from machine data (PLC, MES, or sensor feeds) rather than manual entry, and when you need OEE trends to be visible to multiple stakeholders simultaneously without emailing spreadsheets. EDGEBI from User Solutions connects directly to production data sources and renders OEE dashboards, trend charts, and loss breakdowns in a browser — no manual data entry, no version-control problems, and no data lag.
Get the free template — plus the tool that grew up around it
The template is the starting point. Resource Manager for Excel (RMX) is what manufacturers move to when their Excel scheduler starts breaking. 35+ years in production, free 30-day trial.