OEE Shift & Downtime Log

Validate one machine’s event log before calculating OEE. Explicitly separate time outside the production schedule from stops during planned production.

Factory operationsFreeNo sign-up

One machine, one product cycle time, one shift. Times are elapsed minutes from shift start, not clock times. Maximum shift: 10,080 minutes; up to six decimal places. Counts must be whole, nonnegative safe integers.

id,start_minute,end_minute,type,reason. Every event needs a unique ID, start, end and type. The reason may be empty. Types: planned_exclusion (production genuinely not scheduled) or stop (a loss during planned production, including changeovers). Endpoints use a decimal point; no thousands separators or scientific notation. Adjacent intervals may share an endpoint. Overlaps, including overlaps between types, are rejected. Header-only CSV means no recorded events.

Free printing opens your browser’s print dialog; choose Save as PDF if available. It does not directly download a PDF. Check paper size and preview. Editing any input invalidates the previous report.

Files and calculations stay in this page’s memory. No machine connection, automatic Excel synchronization or saved log is provided. Tool inputs are not sent by this tool. Avoid personal or confidential identifiers; downloaded and printed files contain your entries.

From a shift log to an auditable OEE report

  1. Load the synthetic example or download its CSV. Keep the exact header and machine type values.
  2. Enter shift duration, the ideal cycle time for this product, total output and first-pass rejects.
  3. 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.
  4. Validate every row. Correct all errors; the tool never computes a partial shift from valid rows alone.
  5. 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.

Frequently asked questions