MES & Shop FloorFree worksheetPDF, Excel, Word exportDiscrete Manufacturing

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.

Download:
Changeover stepTodayWhoMinutes todayMinutes moved outside stoppageMinutes cut by simplifyingMachine-stopped minutes after
0 min
10 min
12 min
0 min
2 min
17 min
Total minutes today
101 min
Stopped minutes after
41 min
Minutes saved per changeover
60 min
Reduction
59.4%

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.