SMED Changeover Analysis Worksheet (Excel Export)
SMED (single-minute exchange of die) is the standard method for shortening changeovers, and the first step is always a written analysis of what happens during the stoppage. This worksheet lets you list each step, mark it internal or external, and estimate the minutes you can recover.
| Changeover step | Today | Who | Minutes today | Minutes moved outside stoppage | Minutes cut by simplifying | Machine-stopped minutes after | |
|---|---|---|---|---|---|---|---|
0 min | |||||||
10 min | |||||||
12 min | |||||||
0 min | |||||||
2 min | |||||||
17 min |
Time a real changeover on video first, then fill the table from the recording. Internal means the machine must be stopped, external means it can be done while the previous job runs. Moved-outside minutes leave the stoppage entirely; cut minutes are steps you shorten with quick-release clamps, standard heights or pre-set tooling.
Pull changeover times from your ERP
Optional: we can review how setup and run times are recorded in your ERP and show where to get automatic changeover data.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Film one complete changeover from last good piece of the old job to first good piece of the new job. Replay the video with the operators and write every step as a row, including walking, searching and waiting. For each row enter the minutes it takes today, then decide how many of those minutes could happen while the machine is still running, and how many you can remove by redesign. The last column calculates the minutes the machine is still stopped, and the summary shows the saving per changeover.
The method behind it
SMED comes from the Toyota production system work of Shigeo Shingo. The method runs in stages: observe and record, separate internal from external elements, convert internal elements to external where possible, then streamline what remains with standard parts, quick fasteners and parallel work. Most plants find the biggest first gain in stage two and three, because fetching tools, preheating and paperwork were done while the machine sat idle only out of habit.
- Internal element: requires the machine to be stopped
- External element: can be completed while the machine runs
- Convert: preheat, pre-stage, pre-set, pre-load programs
- Streamline: eliminate adjustments, use quick release, work in parallel
Reading the result
The reduction percent tells you how far one round of improvement could take you. With the example data the stoppage falls from 101 minutes to 41. Multiply the saved minutes by the number of changeovers per week and your planned run rate to see the capacity you free up, then smaller lot sizes become realistic. Repeat the exercise after the changes are in place, because the second pass usually finds a further layer of waste that the first pass hid.
Common mistakes
Teams often time the changeover from memory instead of from a recording, which hides waiting and walking. Others stop at the first pass and never standardize the new sequence, so the gain disappears within weeks. Define the endpoint as first good piece, not first piece, otherwise adjustment time is excluded from the number. Also record who does each step, because idle operators during an internal step are a clear sign of work that could be split.
- Start and end at last good piece and first good piece
- Write the improved sequence as a standard work sheet
- Check that moved-outside work really happens before the stop
Frequently Asked Questions
What is a good target for changeover reduction?
Many plants aim to cut stopped time by half in the first improvement cycle, mostly by converting internal work to external work. The original SMED goal of under ten minutes is a direction, not a rule, and depends on the machine and product.
Should I include cleaning and first piece approval?
Yes. The changeover runs from the last good piece of the old job to the first good piece of the new one. Cleaning, adjustments and approval all keep the machine from producing, so they belong in the worksheet and often offer the largest savings.
Can I export the worksheet to Excel?
Yes. Edit the rows in the browser, then export to Excel, PDF or CSV. Everything runs in your browser, so nothing is uploaded and no sign-up is needed.
How does this connect to OEE?
Changeover time is planned stop or setup loss, depending on your OEE convention. Shorter changeovers raise availability and make smaller batches economical, which also lowers inventory. Decide once whether changeovers count as a loss and keep that rule constant.
If changeover durations and job sequences already live in your ERP or MES, we can pull them into this view automatically so you can see which setups cost the most each week.
Related Tools
OEE Loss Pareto Worksheet
Enter losses by reason code, get minutes per event and totals, and use the list to pick the next improvement target.
MES & Shop FloorMicro Stop Log Worksheet
Tally minor stops by cause on the line, convert them to lost minutes, and export a clean log for OEE analysis.
MES & Shop FloorOEE Improvement Action Plan Template
A one-document plan for an OEE project: baseline, target, top losses, actions with owners and dates, and the review rhythm.
Costing & FinanceOEE Improvement Value Calculator
Convert a planned OEE gain into extra good units and annual contribution margin, so the improvement can be justified.
More MES & Shop Floor tools
See all- Line Balancing Worksheet
- SMED Changeover Reduction Worksheet
- Finite Capacity Scheduling Worksheet
- Production Schedule Template
- Bottleneck Analysis Calculator
- Drum Buffer Rope Buffer Sizing Calculator
- Production Schedule Adherence Calculator
- Production Schedule Release Checklist
- Daily Production Schedule Board Worksheet