LIVE TOOL
OEE calculator
Availability, performance and quality from planned time, downtime, ideal cycle time and counts, with TEEP, the six big losses and several shifts or lines.
Shift input
The downtime list is used: 3 stops, 55.0 min.
Shift time and planned stops give the planned production time. The ideal cycle time is the fastest the machine is designed to run one unit (nameplate or a validated best), not the average. Calendar time is optional: 1440 min for a day.
Example dataReplace with your own downtime list
Paste, open a CSV, TSV, TXT or XLSX file (up to 20 MB), or drop it on the field. Files are read in this browser only.
Reason Minutes Loss Pump fault 22 Breakdown Mould change 25 Setup
1 row = 1 stop
Columns: tab, ; or ,
Decimals: 12,5 or 12.5
Read as: tab-separated · whole numbers · 3 rows · header row skipped
| # | Reason | Minutes | Loss |
|---|---|---|---|
| 1 | Hydraulic pump fault | 22 | Breakdown |
| 2 | Mould change | 25 | Setup |
| 3 | Colour change adjustment | 8 | Setup |
One row per stop: reason, minutes and, if you like, the loss (Breakdown, Setup or adjustment; anything else counts as other downtime). While the list has rows its sum is the unplanned downtime.
Runs in this browser. Data is not uploaded or stored.
Shift results
71.7%OEE
87.5%Availability
85.2%Performance
96.2%Quality
21.9%TEEP
OEE 71.7% = 87.5% × 85.2% × 96.2% · fully productive 315.6 of 440.0 planned minutes · TEEP 21.9%
| Time | Minutes |
|---|---|
| Calendar time | 1440.0 |
| Shift time | 480.0 |
| Planned production time | 440.0 |
| Run time | 385.0 |
| Net run time | 328.0 |
| Fully productive time | 315.6 |
| Loss | Category | Minutes | Share |
|---|---|---|---|
| Breakdowns | Availability | 22.0 | 5.0% |
| Setups and adjustments | Availability | 33.0 | 7.5% |
| Minor stops | Performance | 18.0 | 4.1% |
| Reduced speed | Performance | 39.0 | 8.9% |
| Startup rejects | Quality | 4.8 | 1.1% |
| Production rejects | Quality | 7.6 | 1.7% |
| Fully productive time (OEE) | 315.6 | 71.7% |
| Reason | Loss | Minutes |
|---|---|---|
| Hydraulic pump fault | Breakdown | 22.0 |
| Mould change | Setup / adjustment | 25.0 |
| Colour change adjustment | Setup / adjustment | 8.0 |
Shifts or lines input
Example dataReplace with your own shift data
Paste, open a CSV, TSV, TXT or XLSX file (up to 20 MB), or drop it on the field. Files are read in this browser only.
Shift Planned Downtime Ideal Total Good A early 450 32 24 940 912
1 row = 1 shift or line
Columns: tab, ; or ,
Decimals: 12,5 or 12.5
Read as: tab-separated · whole numbers · 6 rows · header row skipped
| # | Shift / line | Planned (min) | Downtime (min) | Ideal cycle (s) | Total count | Good count |
|---|---|---|---|---|---|---|
| 1 | Line A early | 450 | 32 | 24 | 940 | 912 |
| 2 | Line A late | 450 | 61 | 24 | 820 | 801 |
| 3 | Line A night | 420 | 18 | 24 | 930 | 921 |
| 4 | Line B early | 450 | 25 | 40 | 560 | 548 |
| 5 | Line B late | 240 | 95 | 40 | 190 | 172 |
| 6 | Line B night | 420 | 40 | 40 | 520 | 509 |
One row per shift, day or line: planned production time (breaks already taken off) and unplanned downtime in minutes, the ideal cycle time in seconds per unit, the total count and the good count or the rejects.
Runs in this browser. Data is not uploaded or stored.
Shifts or lines results
77.1%OEE of the totals
75.0%Mean of row OEEs
88.8%Availability
89.1%Performance
97.4%Quality
6 rows · OEE of the totals 77.1% · mean of the row OEEs 75.0%
| Shift / line | Planned | Run | Fully productive | A | P | Q | OEE |
|---|---|---|---|---|---|---|---|
| Line A early | 450.0 | 418.0 | 364.8 | 92.9% | 90.0% | 97.0% | 81.1% |
| Line A late | 450.0 | 389.0 | 320.4 | 86.4% | 84.3% | 97.7% | 71.2% |
| Line A night | 420.0 | 402.0 | 368.4 | 95.7% | 92.5% | 99.0% | 87.7% |
| Line B early | 450.0 | 425.0 | 365.3 | 94.4% | 87.8% | 97.9% | 81.2% |
| Line B late | 240.0 | 145.0 | 114.7 | 60.4% | 87.4% | 90.5% | 47.8% |
| Line B night | 420.0 | 380.0 | 339.3 | 90.5% | 91.2% | 97.9% | 80.8% |
| Total | 2430.0 | 2159.0 | 1872.9 | 88.8% | 89.1% | 97.4% | 77.1% |
| Total | Value |
|---|---|
| OEE of the totals (Σ fully productive / Σ planned) | 77.1% |
| Mean of the row OEEs | 75.0% |
| Difference | -2.1 points |
| Quality by time (Σ good × ideal / Σ total × ideal) | 97.4% |
| Quality by counts (Σ good / Σ total) | 97.6% |
Download offline versionSingle HTML file · v1.4 · 572 KB · works without internet
How OEE is calculated
Overall equipment effectiveness (OEE) is the share of the planned production time in which a machine or line made good parts at its ideal speed. It splits the gap to 100 % into three losses, so that a single number points to where the time went: stops (availability), slow or interrupted running (performance) and bad parts (quality).
Formulas
- Planned production time = shift time − planned stops (breaks, meetings, planned maintenance, no orders).
- Run time = planned production time − unplanned downtime (breakdowns, setups and adjustments).
- Availability (A) = run time / planned production time.
- Performance (P) = ideal cycle time × total count / run time. The numerator is the net run time: the time the units made would have taken at the ideal speed.
- Quality (Q) = good count / total count. Good means right first time: reworked units are not good.
- OEE = A × P × Q = ideal cycle time × good count / planned production time (the fully productive time over the planned production time).
- TEEP (total effective equipment performance) = OEE × utilization, utilization = planned production time / calendar time. TEEP shows how much of all the time in the period (1440 min a day) was fully productive, so unscheduled shifts and planned stops lower it.
- Times are in minutes, the ideal cycle time in seconds per unit; an ideal rate is turned into a cycle time (60 / units per minute, 3600 / units per hour). One unit per cycle: for a mould with several cavities count shots, or use the cycle time per part.
Worked example (the tool's example)
- An 8-hour shift is 480 min. Two breaks and a meeting take 40 min, so the planned production time is 480 − 40 = 440 min.
- The downtime list has a pump fault (22 min, breakdown), a mould change (25 min) and a colour change adjustment (8 min): 55 min of downtime, so the run time is 440 − 55 = 385 min and A = 385 / 440 = 87.5 %.
- The ideal cycle time is 24 s and 820 shots were made: net run time = 24 × 820 / 60 = 328.0 min, P = 328.0 / 385 = 85.2 %. The missing 57 min are performance loss: 18 min of recorded minor stops and 39 min of running slower than ideal.
- 31 of the 820 were rejects, 789 good: Q = 789 / 820 = 96.2 %. The rejects cost 31 × 24 s = 12.4 min (12 startup rejects 4.8 min, 19 production rejects 7.6 min).
- OEE = 0.875 × 0.852 × 0.962 = 71.7 %, the same as 24 × 789 / 60 = 315.6 fully productive minutes out of 440.
- With a calendar time of 1440 min the utilization is 440 / 1440 = 30.6 % and TEEP = 315.6 / 1440 = 21.9 %.
Six big losses
- The losses are grouped as in Nakajima's total productive maintenance: availability — equipment failures (breakdowns) and setups and adjustments; performance — idling and minor stops, and reduced speed; quality — process defects (production rejects) and reduced yield (startup rejects).
- The tool expresses every loss in minutes of the planned production time, so the losses and the fully productive time add up to it. The loss chart is a waterfall from the shift time down to the fully productive time; the calendar time only enters TEEP.
- The split inside each loss is optional: give a downtime list with the loss of each stop (Breakdown, Setup; anything else is other downtime), the minutes of minor stops that are not in the downtime record (the rest of the performance loss is reduced speed), and the number of startup rejects. Where to draw the line between a minor stop and recorded downtime (often 5 min) is a choice of each plant; keep it the same over time.
Several shifts or lines
- Each row gets its own A, P, Q and OEE. The total is calculated from the sums: OEE = Σ fully productive time / Σ planned production time, availability = Σ run time / Σ planned time, performance = Σ net run time / Σ run time.
- Quality of the total is weighted by the ideal cycle time (Σ good × ideal / Σ total × ideal), so that A × P × Q equals the OEE of the totals also when the rows make parts with different cycle times. The plain count ratio Σ good / Σ total is shown beside it.
- The mean of the row OEEs is shown too, to make the difference visible: it gives a short shift as much weight as a full one. In the example the short late shift on line B (240 min, 47.8 %) pulls the mean down to 75.0 %, while the OEE of the totals is 77.1 %.
Common mistakes
- Using the planned or average cycle time as the ideal cycle time: performance then looks better than it is (and can exceed 100 %, which the tool flags).
- Counting breaks or planned maintenance as downtime, or leaving short stops out of the record and then wondering about a low performance.
- Counting reworked units as good: quality is first-pass yield.
- Averaging OEE percentages over shifts, machines or days instead of adding the times.
- Comparing the OEE of different machines or plants as a ranking: the ideal cycle times and the loss definitions differ. OEE is best for following one asset over time.
Input and files
- Numbers may use a decimal comma or point; a comma in the fields gives commas in the results. Planned stops, downtime, calendar time and the loss split may be left empty.
- Table columns are found by their header names (Planned, Downtime, Ideal, Total, Good or Rejects, Shift / line), otherwise from the right in that order. With both Good and Rejects the good count is used and a mismatch is reported.
- Files: CSV, TSV and TXT are read as if pasted (UTF-8, UTF-16, otherwise Windows-1257). XLSX: choose the sheet and the columns or a cell range; formula cells use the value Excel last saved, dates are kept as text. Files up to 20 MB are read in this browser only and never uploaded.
- XLSX files are read with SheetJS Community Edition 0.20.3, Apache License 2.0 (license), loaded only when an Excel file is opened or created.
Questions
- What is a good OEE?
- There is no universal target: OEE depends on the process, the product mix and how the ideal cycle time was set. A figure of 85 % is often quoted as world class for discrete manufacturing, but comparing OEE between different machines or plants says little. Use it to follow one machine or line over time and to see which loss is the largest.
- Are breaks counted as downtime in OEE?
- No. Breaks, meetings and other planned stops are taken off the shift time before OEE starts: OEE is measured against the planned production time. They do lower TEEP, which is measured against the calendar time.
- Why can performance be above 100 %?
- Only when the ideal cycle time is set too slow (too long), or when the counts or the downtime are recorded wrongly. The ideal cycle time must be the fastest cycle the equipment is designed for or has shown, not an average or a planned standard.
- How do I combine the OEE of several shifts or machines?
- Add up the times and counts first and calculate OEE from the sums: the sum of the fully productive time divided by the sum of the planned production time. The plain average of the OEE values gives a short or idle shift the same weight as a full one, so it is not the OEE of the whole period.
Related tools
- Takt time calculator: the pace the line must keep to meet demand, with an OEE factor for the planned cycle time.
- MTBF and MTTR: how often the breakdowns behind the availability loss happen and how long repairs take.
- Capacity planning: available hours per resource with an OEE or efficiency factor, load and bottleneck.
- Pareto chart: rank the downtime reasons or reject types.
- Cycle time → output: theoretical output of a shift from one cycle time.