Overall Equipment Effectiveness Calculator in Excel

Calculate OEE using this template in QI Macros add-in

oee and six sigma calculator

Instructions for Use

Input areas are shaded in yellow and represent the following:

Planned Production Time = How long is your production time per Minutes/per h:mm:ss?
Scheduled Downtime = How long do you plan to have scheduled downtime during your production?
Unplanned Downtime = What is your estimate for unplanned downtime during your production?
Setup & Adjustments = How much time will you allot for setup? And estimate amount for adjustments during your production?
Reduced Speed = During your production, were there any moments where production slowed down?
Small Stops = During your production, were there any moments where production stopped for a short period of time?
Ideal Cycle Time/Piece = 10 seconds = 10/60 seconds/min
Total Pieces = How many pieces are your creating in your entire production?
Startup Rejects = How many rejected pieces did you have at startup?
Production Rejects = How many rejected pieces did you have during your production?

When you input these items, the template performs the calculations and displays these metrics in cells B(G)6, B(G)10, B(G)14, along with B(G)16:B(G)18 and B(G)20:

Run Time: Planned Production Time - Downtime - Setup
Run Rate: Run Time/Total Pieces
Good Pieces: The total number of pieces in your entire production that are considered "good"
Availability: Run Time/(Planned Production Time - Scheduled Downtime)
Performance: (Ideal Cycle Time * Total Pieces)/Run Time
Quality: Good Pieces/Total Pieces
OEE: 85% or better is considered "World Class"

QI Macros OEE Calculator Template

The OEE template is one of many tools in QI Macros add-in for Excel. QI Macros installs a new menu on your Excel tool-bar. To access the OEE calculator, just click on QI Macros, then Calculators, and then "DPMO | Yield | Cp/PPM | OEE":