What's Inside the Template
A single workbook, built for the shop floor — no macros to enable, no setup required. Just open it and start logging.
| Date | Shift | Machine | Start Time | End Time | Duration (min) | Reason | Comments | Operator |
|---|---|---|---|---|---|---|---|---|
| 24.11.2025 | 1st Shift | Machine 1 | 06:10 | 06:15 | 5 | Material | Waiting for Material | |
| 24.11.2025 | 2nd Shift | Machine 2 | 07:00 | 07:30 | 30 | Tool | Changeover | |
| 24.11.2025 | 2nd Shift | Machine 3 | 08:00 | 08:10 | 10 | Electrical | ||
| 25.11.2025 | 3rd Shift | Machine 2 | 04:00 | 05:00 | 60 | Material |
Sample rows from the actual template — Shift, Machine and Reason are all dropdowns, so entries stay consistent between operators.
- Date, Shift & Machine: Pick from dropdowns, so every entry is consistent.
- Start & End Time: Duration (min) calculates automatically the moment both are filled in.
- Reason & Comments: Choose a reason from the dropdown (Mechanical, Electrical, Tool, Material, Operator, Quality), then add detail in Comments.
- Machines, Reason Codes & Shifts sheets: Define your own machine names, reason codes and shift names once — they populate every dropdown in the log.
- Downtime By Reason & Downtime By Shift: Two ready-made charts that total your losses automatically, so you don't have to build a pivot table yourself.
How to Use It
- Open the template in Excel (or Google Sheets) — no installation, no account needed.
- Log each stop as it happens, or at the end of the shift if that fits your process better.
- Pick a reason code from the dropdown instead of typing free text, so the data stays usable later.
- Review the totals — durations and per-reason minutes are calculated for you.
Starter Reason Codes
The Reason Codes sheet ships with six entries to get you started. Rename or extend them to match your equipment:
- Mechanical — mechanical issue.
- Electrical — electrical issue.
- Tool — tool change.
- Material — material shortage.
- Operator — operator unavailable.
- Quality — quality issue.
Ready to Start Tracking?
Download the free Excel template and start logging your first shift today.
By submitting you agree to receive occasional emails about downtime tracking from hopit. Unsubscribe anytime. See our Privacy Policy.
When Excel Starts to Hide the Truth
A manual log is the right first step — it's honest about that. But it inherently misses the losses that happen too fast, or too often, for anyone to write down:
- Micro-stops: A 15-second jam won't get logged, but 20 of those a shift is 5 minutes lost every hour.
- Forgotten stops: Downtime during high-pressure moments is often simply never written down.
- Subjective coding: Reasons get simplified or misclassified when operators are rushed.
Read the full guide to machine downtime tracking for the complete picture, or see how automatic downtime tracking software closes the gap entirely.