How to Calculate OEE in Excel (Formula & Free Template)

Introduction to OEE

Overall Equipment Effectiveness (OEE) is the industry standard for measuring manufacturing productivity. It breaks down the efficiency of a machine or line into three key components: Availability, Performance, and Quality.

In this guide, we will look at how to build a clean OEE calculation dashboard directly in Excel, which is the tool of choice for many plant engineers and supervisors.

The OEE Formula

The standard OEE formula is simple:

OEE = Availability × Performance × Quality

1. Availability

Availability measures the percentage of scheduled time that the machine is actually running. It accounts for planned and unplanned downtime losses.

Availability = Run Time / Planned Production Time

• Planned Production Time = Total Shift Time - Planned Breaks
• Run Time = Planned Production Time - Unplanned Downtime (Breakdowns, Setups)

2. Performance

Performance measures how close the machine is running to its maximum designed speed (ideal cycle time) during the time it is active.

Performance = (Ideal Cycle Time × Total Count) / Run Time

3. Quality

Quality measures the ratio of good parts produced to the total number of parts processed.

Quality = Good Count / Total Count

Structuring Your Excel Sheet

To build a functional OEE sheet, structure your data into three separate tables:

1. Shift Setup Table: Define the shift length, scheduled breaks, and target cycle rates.
2. Downtime Log: A running table of when the machine stopped, for how long, and the reason (e.g. breakdown, tooling change).
3. Production Summary: Total parts produced and defects found during the shift.

Once your calculations are in place, you can use Excel formulas to summarize these daily logs into a dashboard with availability trends and loss category Pareto charts.