From a shift log to an auditable OEE report
- Load the synthetic example or download its CSV. Keep the exact header and machine type values.
- Enter shift duration, the ideal cycle time for this product, total output and first-pass rejects.
- Replace the example events with your records. An interval includes its start and excludes its end; 60–75 and 75–90 are adjacent, not overlapping.
- Validate every row. Correct all errors; the tool never computes a partial shift from valid rows alone.
- Review time reconciliation, OEE factors and all event rows, then print or save a PDF.
Worked example: 78.4% OEE
A 480-minute shift excludes a 30-minute scheduled break and records 45 minutes of stops. Planned production is 450 minutes and run time is 405 minutes. At 3 seconds per part, 7,200 total parts need 360 ideal minutes; 7,056 good parts need 352.8 minutes. Availability = 405/450 = 90%; performance = 360/405 ≈ 88.8889%; quality = 7056/7200 = 98%; OEE = 352.8/450 = 78.4%.
Interpretation and boundaries
Planned production = shift − excluded time. Run time = planned production − stops. Availability = run / planned; performance = ideal cycle time × total / run; quality = good / total. OEE = ideal cycle time × good / planned. Convert seconds to minutes before multiplication.
Unrecorded time is treated as run time; the tool cannot detect missing events. Do not hide setup or changeovers in exclusions. Performance above 100% is flagged, not capped: review cycle time, counts and stop records. A zero denominator is shown as not defined, not a perfect score. No scheduled production means OEE is undefined. This is not a machine monitoring system, product-mix aggregator or automatic root-cause diagnosis.
Definitions: Vorne — Calculating OEE. Keep classification rules consistent before comparing shifts.