Free Setup Time Tracker Excel Template
Log every setup and changeover. Compare standard to actual. Most shops cut setup time 30%+ once they can see the pattern of where time is actually being spent.
What you get
Working setup-time log structured for SMED analysis. Separates internal time (machine stopped) from external time (machine could be running) — the foundation of every setup-reduction project.
Free 30-day trial · No credit card required · Used by manufacturers since 1991
Why manufacturers still use Excel for this
Setup time is the cleanest target in any manufacturing improvement program. Unlike cycle time (limited by physics) or yield (limited by material), setup time is almost always reducible — the only question is how much. Shops that systematically attack setup typically cut it 30–60% in the first year.
The unlock is SMED (Single-Minute Exchange of Die) discipline: separate internal setup (must happen while the machine is stopped) from external setup (can happen while the previous job runs). Most shops mix the two and lose 20–40% of setup time to "external" tasks done internally — finding tools, walking to the supply room, looking up programs.
This template gives you the smallest workable structure to enable SMED analysis: every setup event logged with start time, end time, internal vs external task breakdown, and notes on what specifically caused delay. After 30 days of disciplined logging, the patterns are obvious.
What's inside the template
Setup event log
Job from/to, machine, operator, setup start, setup end, total time, standard time, variance, and notes.
Internal/external task breakdown
For each setup, break time into internal (machine down) and external (machine could have been running) sub-tasks.
Setup variance by machine
Identifies machines where setup time consistently exceeds standard. These are the SMED project candidates.
Top 10 delay reasons
Coded reasons (tool search, program load, fixture issue, material wait, operator question) sorted by total time lost.
SMED conversion candidates
Tasks currently done internally that could be moved external — sorted by minutes saved per setup × setups per month.
Setup reduction trend
Month-over-month average setup time per machine. Tracks whether SMED projects are actually working.
How to use this template
A practical walkthrough — five steps from blank spreadsheet to a working schedule.
- 1
Time the next 5 setups on one machine
Start with one bottleneck machine. Get a baseline. Trying to track every setup on every machine immediately is the fastest way to abandon the system.
- 2
Separate internal vs external during observation
A simple checkbox per sub-task: is the machine stopped while this happens? Yes = internal. No = external. That distinction drives 90% of the value.
- 3
Pick one external-conversion opportunity
From the Pareto, pick one task that is currently done internally and could be done externally. Build a 30-day project to make it external.
- 4
Measure the result and pick the next one
After the conversion, observe 5 more setups. The trend column confirms the gain. Pick the next opportunity. Cycle.
When you outgrow this template
Excel is the right answer for early-stage scheduling — until it isn't. Here are the warning signs that you need a real production scheduling tool.
If three or more of these apply, you have outgrown Excel scheduling. The good news: you do not have to leave Excel behind. Resource Manager for Excel (RMX) is a real finite-capacity scheduling engine that runs as an Excel add-in — so your team keeps the interface they know while gaining the scheduling power of a dedicated APS tool.
Learn about RMXFrequently asked questions
What is SMED and how does this template support it?+
SMED (Single-Minute Exchange of Die) is a methodology for reducing setup time by separating internal tasks (require the machine to be stopped) from external tasks (can be done while the machine runs the previous job). The template forces that separation on every logged event.
How long should a "good" setup take?+
It depends on equipment and complexity. The right benchmark is your own trend, not an industry number. A shop that cuts average setup from 90 minutes to 50 minutes wins regardless of whether competitor benchmarks say 30 minutes.
Should I track setup time on every machine?+
No — start with bottleneck machines. Setup time on a non-bottleneck machine is mostly cost; setup time on a bottleneck machine is also throughput. Always go after bottlenecks first.
How is setup time different from changeover time?+
In most shops they mean the same thing — the time between the last good part of job A and the first good part of job B. Some shops distinguish "changeover" as the cleaning/teardown portion only. Use whatever terminology your operators use; consistency matters more than the label.
Get the free template — plus the tool that grew up around it
The template is the starting point. Resource Manager for Excel (RMX) is what manufacturers move to when their Excel scheduler starts breaking. 35+ years in production, free 30-day trial.