Free template
OEE tracking sheet
OEE, overall equipment effectiveness, measures how much of a machine's planned production time is truly productive. It multiplies three factors: availability (run time as a share of planned time), performance (actual output against the ideal cycle time) and quality (good parts as a share of all parts). An OEE tracking sheet records the inputs shift by shift, so you can see the number and, more usefully, where the losses come from. This template has one row per shift for a week, with planned time, downtime under four reasons, ideal cycle time, total and good count, and the four percentages. Page 2 has downtime by reason, a worked example and a chart to plot each day. The Excel version does every calculation, per shift and for the week, and draws the daily trend against your target.
Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.
When to use it
When to use an OEE tracking sheet
- To start measuring OEE on one machine or line before investing in automatic data collection.
- To find which of the three losses, availability, performance or quality, costs the most output.
- To check the effect of a change, such as a SMED project or a maintenance fix, week on week.
- As the data behind a daily production meeting or a tier board.
How to fill it in
- 1
Agree the rules
Decide what counts as planned time, usually the shift less breaks and planned meetings, and set the ideal cycle time: the fastest proven time per part.
- 2
Record each shift
Enter the planned time, the downtime minutes by reason, the total count and the good count. The Excel version fills in the date and the ideal cycle time.
- 3
Work out the three factors
Availability = run time ÷ planned time. Performance = ideal cycle time × total count ÷ run time. Quality = good count ÷ total count.
- 4
Multiply for OEE
OEE = availability × performance × quality. Work out the week from the totals, not by averaging the shift percentages.
- 5
Plot the week
Plot each day on the chart on page 2 against your target, or let the Excel version draw it.
- 6
Work on the biggest loss
Look at downtime by reason and at the lowest of the three factors, and pick one loss to work on.
A filled-in example
Illustrative, not a benchmarkAn example with illustrative numbers: one shift on a filling machine.
- Planned time 450 minutes: a 480-minute shift less a 30-minute break.
- Downtime 45 minutes, 20 for a breakdown and 25 for a changeover, so run time is 405 minutes and availability is 90.0%.
- Ideal cycle time 30 seconds and 700 parts made: 350 minutes of ideal time in 405 minutes of running, so performance is 86.4%.
- 686 good parts out of 700, so quality is 98.0%.
OEE for the shift is 0.900 × 0.864 × 0.980 = 76.2%. Performance is the biggest loss, so the next step is to look at slow running and short stops rather than breakdowns.
Common mistakes
Averaging percentages
The week's OEE comes from the week's totals. Averaging the shift percentages gives a short shift the same weight as a full one.
An ideal cycle time that is too slow
If performance comes out over 100%, the ideal cycle time is set too slow. Use the fastest proven rate, not the planned one.
Changing the rules
If planned stops count one week and not the next, the trend means nothing. Write the rules down.
Chasing the number
OEE points to losses. Look at which factor and which downtime reason is biggest, and fix that.
Comparing different machines
Machines with different products, rules and ideal cycle times do not compare well. Compare a machine with itself over time.
Download the template
Free to use: print it, copy it and edit it for your team. Enter your name and work email once to download.
Run this template in LeanSuite
LeanSuite's production dashboard tracks OEE and its three factors next to downtime by reason and output against plan, and KPI values can be pulled on a schedule from Excel on SharePoint or OneDrive or from Google Sheets.
In the lean glossary
FAQ
OEE tracking sheet: common questions
More free templates
All templates- 5S audit checklist template25 checks, five per S, scored 1 to 5, with a score summary and a chart of the five S's.
- Gemba walk checklistA walk plan and route, 30 prompts in six groups and a findings table with owners and due dates.
- Leader standard work templateA team leader's daily, weekly and monthly routine with a box per day, follow-ups and a weekly review.
- Autonomous maintenance (CILR) checklist20 clean, inspect, lubricate and retighten checks with a box per day, an abnormality log and sign-off.
- A3 problem solving templateThe standard seven-box A3 on one landscape sheet, from background to follow-up.
- PDCA templateOne improvement cycle on one landscape page: plan, do, check against the goal, then standardize or adjust.
- 5 Whys templateA problem statement, five why rows with evidence, the root cause and the countermeasure.
- 5W1H templateSix questions with prompts and evidence, turned into a problem statement before the root cause analysis.
- 8D report templateD0 to D8 on three pages: team, is/is not, containment, occurrence and escape causes, actions and closure.
- Poka-yoke worksheetEach step's possible errors, prevention or detection, the method, a device idea and a verified box.
- Skills matrix templatePeople by skills, a 0 to 4 scale, a training column and a coverage row that shows the gaps.
- Standard work sheet templateTakt time, each element's manual, machine and walk time on a time chart, key points and standard WIP.
- One point lesson (OPL) templateOne topic on one page: wrong way and right way pictures, key points, why it matters and a sign-off record.
- SMED changeover worksheetChangeover steps with times, internal or external, what can move, ideas and before/after totals.
- Kaizen event charter templateScope, team and roles, baseline and target metrics, a five-day schedule, risks and sign-off.
- RACI matrix template17 kaizen project tasks by 10 roles, with R, A, C, I drop-downs and a check for one accountable per task.
- Layered process audit (LPA) checklist20 yes, no or N/A checks at the station, a fixed-on-the-spot box, scores by group and a findings table.
- PFMEA template (process FMEA)Failure modes, effects and causes rated for severity, occurrence and detection, with RPN before and after action.
- 5S red tag log and red tagsA log of every red-tagged item with its decision, and six printable red tags to cut out.
- Shift handover templateProduction against plan, safety, quality, equipment, materials and people, and the open issues the next shift takes over.
- Kanban card templateSix production and six withdrawal kanban cards to print and cut out, with loop sizing and a card register.
- Pareto chart templateA tally sheet, the categories sorted largest first with cumulative %, and the chart. Excel does the sorting and drawing.
- Control plan templateWhat is checked at each step, against which limits, how, how often, and what to do when a result is out.
- Corrective action request (CAPA) formProblem, containment, root cause, corrective and preventive action, and proof the fix worked, on two pages.
- Idea suggestion formA one-page idea form with the supervisor's answer and points, and an idea log that tracks days to answer.
- Just Do It (JDI) card templateSix Just Do It cards per sheet for quick fixes, with the rules for what counts and a log of every card.
- Quick kaizen templateOne page for a small improvement: before and after, the cause, the countermeasure, the results and whether the standard changed.
- Time study sheetTime each element over 10 cycles and work out the average, lowest repeatable and standard time. Excel does the sums.
- Spaghetti diagram templateSquared paper to trace every trip, a tally of trips and distance, and a before and after comparison.
- Near miss report formA two-page near miss report from the first report to closure, and an Excel log with status and days open.
- Safety observation card templateFour behavior-based safety cards per sheet, with safe and at-risk checks, the conversation and a tally sheet.
- Job safety analysis (JSA) templateJob steps, hazards, risk scored before and after the controls, the hierarchy of controls, PPE and sign-off.
- Risk assessment matrix template (5×5)A color-coded 5 × 5 severity and likelihood matrix, a scoring guide and a risk register.
- Incident investigation report templateWhat happened, people, evidence and timeline, root cause with 5 Whys and contributing factors, actions and sign-off.
- Toolbox talk templateA record of a short safety talk: topic, key points, questions raised, actions and an attendee sign-in sheet.
- Lockout/tagout (LOTO) procedure templateA machine-specific LOTO procedure: energy sources and isolation points, the steps from shutdown to restart, and the annual review.
- Forklift inspection checklist23 pre-shift checks for a week on one page, a do-not-operate rule, and a defect and repair log.
- Non-conformance report (NCR) formA two-page NCR from the requirement against what was found to disposition and closure, and an Excel NCR log.
- CAPA log templateAn Excel CAPA tracker with status, days open, late flags and counts by source, plus a printable log and monthly review.
- Supplier corrective action request (SCAR) formA SCAR from the problem and containment asked for to the supplier's 8D-style response, verification and closure.
- First article inspection (FAI) report templatePart information, a ballooned characteristic table with tolerances and results, material and process certificates, and sign-off.
- Preventive maintenance checklist templateA PM checklist per machine with readings and sign-off, and a PM schedule that works out the next due date.
- Equipment downtime log (MTTR and MTBF)A breakdown and downtime log, with MTTR, MTBF and downtime by machine and cause worked out in Excel.
- Environmental aspects and impacts registerAn ISO 14001-style register of aspects and impacts, with significance scoring, legal requirements, controls and owners.
- Manufacturing process instruction (MPI) templateOperation steps with parameters, tools, quality checks, safety and a photo each, plus revision history and approval.
- Engineering process instruction (EPI) templateScope, parameters and limits, equipment and materials, validation steps, acceptance criteria, change history and approvals.
- Training sign-off sheetAn attendance and sign-off record where each person signs they understood, with a competence check and an Excel log.
- On-the-job training (OJT) checklistA job breakdown and the four TWI Job Instruction steps with sign-offs, the tries and the date the trainee qualified.
- New hire onboarding checklist (manufacturing)29 onboarding items from before day 1 to the 90-day review, with owners, dates and review notes.
- Competency assessment formEach task rated 0 to 4 on the skills matrix scale with the evidence seen, then the gaps and a training plan.
- Cross-training plan templateWho is learning which task, from and to which level, by when, and how many are qualified on each task.
- Absenteeism tracker templateA monthly attendance grid with codes, absence rate by person and team, and an optional Bradford factor.
Can't find the template you need?
Tell us what you're looking for. We'll make it and send it to your inbox, free.
A shift handover sheet, a red tag log, a changeover checklist for one machine: if your team uses it on the floor, ask.