Free Templates

We are pleased to offer several free Excel spreadsheet templates that will make it easy for you to get started with Overall Equipment Effectiveness and show you how to calculate OEE correctly.

While we encourage the use of a database for larger OEE implementations, a spreadsheet based system will certainly serve its intended purpose for the short term. These files are more than just a simple OEE calculator. They are among the best of free OEE templates available anywhere.

We presume that you are at least comfortable working with Excel. The formulas presented in these spreadsheets are not necessarily complex, however, some of the content may appear to be somewhat daunting to the novice user. There is no hidden content – all formulas are displayed and there are no macros or VBA. We did not impose any security levels on the spreadsheet content, so any data in the cells can be changed, modified, or overwritten.

We recommend that you exercise due care when working with the spreadsheets for the first time and strongly suggest making a copy under a new name to preserve the original downloaded file.

Free Excel Files / Templates

The following files are currently being offered at no charge to our clients and visitors. Simply click on the links below to access the file of your choice.

We also offer custom spreadsheet solutions. If you are looking for a specific solution in Excel, we can help. Please forward your inquiries or project details to Redge@Versalytics.com. We look forward to working with you.

If you have any questions, concerns, or comments regarding the use of these files, please feel free to contact us. Send your e-mail inquiries to leanexecution@gmail.com or support@vergenceanalytics.com and we will respond at our earliest convenience. We appreciate your feedback. We respect your privacy – your contact information will not be published or provided to any outside agencies or persons of interest. Please see our Privacy Policy for more information.

Vergence Analytics

35 comments on “Free Templates”

The OEE How to calculate tutorial is very informative and helpful. The problem I am having is with cycle times. What type of formula would you use for cycle times that are longer, like 3 to 6 pieces per hour? All of the templates I see are putting out several parts per minute.

Randy, thank you for your question. Although OEE is expressed as a percent, as your question correctly notes, the basis for calculating the components of OEE is “units of time”. While the formula for OEE itself does not change, variations do exist to accommodate different units of measure. In your case, I recommend measuring cycle times using “MINUTES per PART”. As such, 3 to 6 pieces per hour = 20 to 10 minutes per part. Minutes Per Part is also more meaningful in human terms especially when part cycles don’t equate to “whole” pieces per hour. For example, 19 minutes per part is more meaningful than 3.16 parts per hour. Since we typically measure Downtime in Minutes as well, this seems to be a practical basis for measurement of cycle time as well.

Since cycle time affects both performance and quality, the following formulas apply when using “Minutes per Part”:

Performance = Ideal Operating Time / Effective Operating Time

where, Ideal Operating Time = (Total Parts Produced x Cycle Time Minutes Per Part)
and, Effective Operating Time = Scheduled Time – (Planned Down Time + Unplanned Down Time)

Part “X” was scheduled to run on 1st Shift from 7:00 AM to 3:30 PM.
Planned Downtime = Two 15 minute Breaks, One 30 minute Meal Break.
Cycle Time = 20 Minutes Per Part (3 Pieces Per Hour)
25 Minutes of UNPLANNED downtime were incurred during the shift.
A total of 18 parts were produced of which 1 was rejected.

Rather than multiply the percentages as we did above, let’s see what happens when we substitute the TIMES from our equations just before we calculated the percents:

OEE = (425 / 450) x (360 / 425) x (340 / 360)

When we look at the formula in this way, we can see that some numbers actually “cancel” each other. When we do this our OEE calculation reduces to (340) / (450) = 75.5% This is actually known as the Quick method or “back of the envelope” method of calculating OEE. The final “Quick” method reduces to the following formula:

OEE = Value Added Time / Scheduled Operating Time

Having said all this, the spreadsheets that we provide can be modified as you see fit to suit your application. The following units of measure are commonly used:

Ooh shoot i just wrote a large comment and as soon as i hit reply it came up blank! Please inform me it worked correct? I dont want to submit it again if i do not have to! Either the blog glitched out or i’m an idiot, the second option doesnt surprise me lol. Thanks for a great blog!

Hi Manny, thank you for your question. Preventive maintenance is a planned event and typically requires the machine to be down. In other words, the equipment is not available to produce parts. Regarding housekeeping, that may depend on your process. What is the nature of the housekeeping? Why can’t areas be maintained in real time – while the process is running?

I have managed plants where 10 minutes was allocated for “housekeeping” at the end of each shift. I abandoned the practice, instead requiring that housekeeping was performed as needed. I also challenged the team to ask why they needed the time. I have typically found that “allocated” time for housekeeping is abused.

How you decide to allocate “time”, however, is really at your discretion. The purpose of OEE is to help us identify how much equipment time is lost and why. It seems to be human nature for people strive to find ways to “improve” OEE without making real improvements. They will claim downtime for events like housekeeping, although this may not necessarily be the case.

I just want to mention I am just very new to blogs and absolutely liked your blog site. Most likely I’m planning to bookmark your blog post . You certainly have exceptional article content. Many thanks for sharing your web-site.

Hello, I am so excited I found your website and many thanks for the great downloads. I don’t have time to read all the information on your site but I have book-marked it and also subscribed to your RSS feed. Please do keep up the excellent work.

Thank you for recent comment / inquiry requesting more information regarding cycle time calculations for manual assembly. We are pleased to advise as follows:

1. If there is no established cycle time for your process, then using historical data is a good place to start. We recommend using an average rate that is likely more representative of your day to day operations.

Again it is worth noting that historical data is NOT necessarily the ideal rate. It would be interesting to see how much variance exists in the production rates from one hour or day to the next. Minimum rate versus average versus peak or maximum rate.

2. Although the assembly process is based on human effort, it is still possible to perform a time study on the process using a reasonable sample size depending on the complexity of your operation. If possible, recording a video of the operation is also highly recommended.

It is worth noting that people will have a natural tendency to make improvements while the time study is being performed. This is commonly referred to as the Hawthorne effect. We recommend establishing a base line first then make the improvements. (See note 3 below).

3. We recommend preparing a “value stream map” of the current state. At a minimum, prepare a flow diagram that describes the current process. Using a detailed work instruction is a good place to start for a task like this.

When improvements or changes are introduced to the process, you will have base line to serve as a reference and to validate the significance of the new method.

Thank you again for visiting our website and we wish you the best of successes on your implementation.

It can be applicable, as long as the data is meaningful and will help to improve your operation. For example, one courier company determined that their trucks would always make right turns to avoid delays incurred when attempting to turn left.

TEEP is used to measure how effectively an asset’s time is being utilized.