Downloads

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.

  1. Single Machine – Multi Part OEE Template.xls
  2. Cost Weighted OEE Template.xls
  3. How to Calculate OEE – Tutorial.xls
  4. Multi Part – Multi Machine OEE Template.xls
  5. Multi Part – Quality Factor Machine A.xls

Alternative site links to download individual files:

  1. Single Machine – Multi Part OEE Template.xls
  2. Cost Weighted OEE Template.xls
  3. How to Calculate OEE – Tutorial.xls
  4. Multi Part – Multi Machine OEE Template.xls
  5. Multi Part – Quality Factor Machine A.xls

Note that these files are also available from our “Free Downloads” widget on the sidebar or click here to access all files available files for downloading.

Customized Solutions

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 Support@VergenceAnalytics.com or LeanExecution@gmail.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.

Please respect our copyright (c) – All Rights Reserved.

Vergence Analytics – Catalysts for Excellence
Lean Execution Team – Toronto, Ontario, Canada

Vergence Analytics
  1. Randy Finchum
    January 5, 2011 at 9:32 pm | #1

    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.

    • January 6, 2011 at 5:12 am | #2

      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)

      Quality = Value Added Time / Ideal Operating Time

      where, Value Added Time = (Good Parts Produced x Cycle Time Minutes Per Part)
      and, Ideal Operating Time = (Total Parts Produced x Cycle time Minutes Per Part)

      Let’s use an example to demonstrate how the formulas work:

      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.

      Scheduled Operating Time = Total Time – Planned Down Time
      = 510 minutes – (2 x 15 minute breaks) – 30 minute meal break
      = 450 minutes

      Effective Operating Time = Available Time – Unplanned Downtime
      = 450 – 25
      = 425

      Availability = Effective Operating Time / Scheduled Operating Time
      = 425 minutes / 450 minutes
      = 94.44%

      Performance = Ideal Operating Time / Effective Operating Time
      = (Total Parts Produced x Cycle Time Minutes / Part) / Effective Operating Time
      = (18 parts x 20 minutes / part) / 425 minutes
      = 360 minutes / 425 minutes
      = 84.71 %

      Quality = Value Added Time / Ideal Operating Time
      = (Good Parts Produced x Cycle Time Minutes Per Parts) / (Total Parts Produced x Cycle Time Parts Per Minute)
      = ((18 – 1) x 20) / (18 x 20)
      = 340 / 360
      = 94.44 %

      So, now we can calculate OEE = A x P x Q.

      OEE = 94.44 x 84.7% x 94.44%
      = 75.5%

      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:

      Seconds / Part
      Parts / Second
      Parts / Minute
      Minutes / Part
      Parts / Hour
      Hours / Part

      I trust this answers your question. Please advise if you require additional information or if you need assistance to setup a spreadsheet for your specific application.

      Redge

  2. Andrew Joseph
    February 24, 2011 at 8:41 pm | #3

    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!

  3. March 9, 2011 at 3:03 pm | #4

    It is arduous to find educated people on this topic, but you sound like you understand what you’re talking about! Thanks. Warm regards from all of us.

  4. Sonya
    April 4, 2011 at 4:51 am | #5

    Awesome spreadsheets, thank you so much!

  5. Manny
    May 29, 2011 at 7:53 pm | #6

    Hi,

    I find this site so interesting.
    I have some clarifications in terms of planned downtime. Per example above, it entails only on the breaktime, lunch.

    Is TPM schedule, housekeeping will not be included in the computation? let say in daily basis?

    • May 30, 2011 at 5:42 am | #7

      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.

      Redge.

  6. Hasan
    June 20, 2011 at 4:49 pm | #8

    How you will calculate the savings if OEE improves from 80% to 85%.

  7. September 26, 2011 at 4:17 am | #9

    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.

  8. September 28, 2011 at 7:23 am | #10

    I’m doing some research for a university assignment and thought this infomation may be usefull. I will come back in the next couple of days and see what others have thought about the site. Cheers

  9. November 20, 2011 at 5:09 am | #11

    How can OEE be applicable in a jobshop? A high mix very low volume environment? Where cycle time really changes everytime?

    • November 20, 2011 at 4:44 pm | #12

      Hi Karl, the rules for OEE are the same regardless of volume. For high mix / low volume situations, set up / change over time is typically the greater concern.

      Job sequence and process type (CNC, automation, or manual) will also influence whether OEE is even worth considering for your operation.

      Our spreadsheets can accomodate any number of parts / jobs. The down loads are free and you are welcome to modify as you see fit.

      Thank you for your question and best of luck with your application.

  10. Lawana Carretero
    December 30, 2011 at 5:15 am | #13

    Great site !

  11. Aaron Johnson
    January 14, 2012 at 9:42 pm | #14

    Hi there! Do you use Twitter? I’d like to follow you if that would be ok. I’m undoubtedly enjoying your blog and look forward to new updates.

    • January 14, 2012 at 10:59 pm | #15

      Hi Aaron, thank you for your kind words. Yes, you can follow us on Twitter: Versalytics

  12. Rigoni
    January 28, 2012 at 11:42 pm | #16

    Thanks for helping out, excellent information.

  13. CNA Training Online
    February 21, 2012 at 3:32 pm | #17

    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.

    • February 22, 2012 at 2:54 pm | #18

      Thank you for your kind words. We definitely appreciate your comments and your feedback.

  14. Alva Desrosier
    March 8, 2012 at 12:04 pm | #19

    This really answered my problem, thank you!

    • March 11, 2012 at 8:27 am | #20

      Thank you for your feedback, we do appreciate hearing from our visitors. Many people have successfully implemented OEE using the tools we offer here.

      Good luck with your implementation strategy and I’m sure you’ll be rewarded through your lean journey.

  15. Matthew C. Kriner
    August 8, 2012 at 1:52 am | #21

    I gave you a link back on one of my pages, I hope this is ok.

    • August 8, 2012 at 6:43 am | #22

      A link back is always appreciated.

      Thank you.

  16. John Mulhern
    August 24, 2012 at 2:05 pm | #23

    Hi, great information here. What happens if we plan to run a line for 8 hours but then actally run it for 12? How is available time calculated?

    • August 24, 2012 at 3:01 pm | #24

      Thank you for your question John.

      For the purposes of calculating OEE, your plan changed. All calculations will simply be based on the extended shift.

      In this instance, you may incur an additional break at the end of the 8 hour shift and another after 10 hours.

      Thanks again for visiting, Redge

  17. Uzziel Roque
    August 29, 2012 at 12:42 am | #25

    thank you for the data it will help a lot now we are facing over capacity due to high client demand,

    • August 29, 2012 at 7:15 am | #26

      Uzziel, thank you for your kind comment. I wish you the best of success.

  18. anna
    August 10, 2013 at 3:27 pm | #27

    i have to ask how to calculate Assembly manual Plant. how to calculate ideal run rate because everything depend on people skills ? just used peak production historical data or any suggestion ?

    • August 11, 2013 at 1:48 pm | #28

      Hello Anna,

      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.

  19. Sachinkanpur
    October 1, 2013 at 5:41 am | #29

    Great article and its worth to have this

    • October 1, 2013 at 7:15 pm | #30

      We appreciate and thank you for your kind comment.

  20. November 12, 2013 at 4:21 am | #31

    Thank you for sharing such an impressive file!

    • November 14, 2013 at 11:19 pm | #32

      We appreciate your kind comment and thank you for visiting.

  1. June 27, 2009 at 6:44 pm | #1
  2. November 29, 2009 at 3:32 pm | #2
  3. November 29, 2009 at 4:56 pm | #3
  4. November 29, 2009 at 5:53 pm | #4
  5. November 29, 2009 at 6:07 pm | #5
  6. November 29, 2009 at 7:06 pm | #6
  7. November 30, 2009 at 7:24 pm | #7
  8. February 25, 2011 at 3:38 pm | #8

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 6,315 other followers

%d bloggers like this: