An OEE Worksheet helps you determine the overall efficiency of your equipment. This spreadsheet calculates three ratios and multiplyes them to give you the overall effectiveness metric. The higher the OEE, the more efficient your equipment is. To use an OEE Worksheet, add the appropriate template to a workbook and then click Update Inputs. Then, fill in the data and click Compute Outputs to generate the analysis results.
In the example above, an asset produces 12,000 units in a 12-hour production period. Of these, 300 are defective. This leaves 11,700 usable units. The quality score is therefore 97.5%, or 0.975. You can then multiply these values to get the OEE of the asset. If you’re using a spreadsheet to calculate your OEE, make sure you use an Excel document for your data. It’s easy to use.
The OEE score is an indication of how well a manufacturing process is working. This metric can be used to identify underperforming assets and tie them to issues that will ultimately increase their overall efficiency. The underlying problems can be solved using maintenance KPIs. You can even use this metric to identify inefficiencies in maintenance. If you want to learn more about the OEE Worksheet, read on. So, start using one! It’ll improve your operations!
The availability component of an OEE Worksheet refers to whether a machine or cell is available to produce when it’s scheduled to. When a process is running, it creates value for the end-user, while a stopped process creates cost. The availability component of the OEE Worksheet compares scheduled run time to actual run time, giving you an idea of lost production due to downtime. You can then filter the data by date range, and analyze your production data.
To calculate the total available time for a given shift, you will need to record time in the current process. This can be done by day or shift, and each shift will record its time, production, and rejects. In the simplest example, the net available time for a shift is 480 minutes. You can calculate the remaining time by adding 50 minutes to the denominator to determine its availability. However, a lower number can make the entire process more efficient.
OEE can be used to compare similar machines, as well as to compare different types of machines. ANOVA analysis can help you identify the source of variation. You should also measure OEE consistently across your company, and use it for directional purposes. To calculate the OEE, you can download the OEE Worksheet example. Then, enter your data in the fields provided. The OEE Worksheet is a useful tool for comparing the average OEE for your company’s machines.
The OEE Worksheet can also help you determine why certain parts of your production process do not meet the standard. For example, if your MACHINE 1 is achieving 97.5% of its intended production, then it is not performing optimally. In this case, the company should keep the part in MACHINE 2, but try to reduce the speed losses as they reduce performance. It should also keep track of how much time your employees spend on each process.