In this guide 6 sections
Spreadsheets suit a few jobs. Job software wins once drawing revisions, rework loops, outside processing and several estimators overlap and a single sheet can no longer hold the history. Choose by change, not volume. Count how often a job changes after release, not how many jobs you run, and let that count decide whether the sheet stays.
Why one-off work behaves differently
A batch shop repeats a routing. A tool room builds a progressive die, a welding jig or a gauge once, and the design shifts while the D2 steel is still on the surface grinder. Revision C lands after grinding.
A fixed routing will not do. The record needs a changing parts list, a drawing issue for each part and a log of the work done under every revision, so no change erases history.
Time is lumpy too. A single wire cut might wait a week for an EDM slot and then take two hours, so spare capacity hides in the waits. A tracker that shows queue time as well as cutting time lets you promise delivery dates that the die customer can rely on.
Where a spreadsheet holds up
For a small shop one sheet per job is quick to build, since columns for part, material, stock size, operation, hours and status take an afternoon. Nobody needs a training session.
It suits an owner who walks the floor each morning and carries the state of every die in his head, so the sheet is only a notebook. That is fine.
The pain starts when a second person needs to edit the sheet at the same moment, or when a customer asks to see last month’s version.
- Up to a few live jobs at a time
- One estimator and one planner
- Few outside processes
- Revisions rare or handled by the customer
Where it starts to fail
Revisions are the first crack. A sheet overwrites old numbers, so when a customer disputes a rework charge months later nobody can prove which drawing issue the wire cut used.
Rework is the second. A die insert is reground, reheated and refitted, and in a sheet those hours blur into the original estimate so the next quote repeats the optimistic fitting figure.
Outside processes are the third. Heat treatment, nitriding and profile grinding need a dispatch date, a vendor name and a return inspection, or a hardened plate sits missing for ten days.
- Drawing issue stored against each part and each operation
- Rework logged as its own line with a reason
- Outside processing with out and back dates
- Photos of trial results and measurement reports on the job
What job software should handle
Look for parts held as children of the tool, each with a status, so a bolster plate can finish while the punch waits for steel. The parent shows progress.
Ask for estimate against actual by operation, so you can compare what milling, jig boring, fitting and polishing took on this job with the figure you quoted. That sharpens the next quote.
Check how it treats tryout, the stage where most tool rooms lose their margin to endless spotting, grinding and re-spotting and then call it finishing. Finally, ask for a drawing viewer on the job screen, so fitters open the current PDF at the bench instead of a printout from last week.
A way to decide this month
Take your last five jobs. Could you show the drawing issue used for each part, say where the hours went against the quote, and find where each outside part sat last month?
If the answer is no to two of them, the sheet is already costing you, so move one live job into trial software and leave the rest alone.
Run both for a month. Then lay the sheet record beside the software record and compare drawing issues, rework hours and outside process dates for the same job.
Tool room job record template
The header carries customer, tool name, due date and drawing issue, above a parts table of material, revision, operation, planned hours, actual hours and status. A rework strip records reason, hours and who approved it, and an outside process strip records vendor, sent date and returned date.
Open a blank worksheet to printQuestions owners ask
Can I begin with a sheet and move later?
Yes. Keep columns consistent from the start, with one row per part and operation, because clean rows import into software far more easily than free-text notes in one cell.
How do I price rework fairly?
Log it with a reason. A few jobs later the repeat causes, such as design change or trial error, show up on their own, and you can quote for them in advance.
Do tool rooms need machine monitoring?
Rarely at first. Booking hours by operation gives most of the value, so add monitoring only for the wire cutter or jig borer that turns out to be your bottleneck.
Who should enter the data?
The fitter or machinist doing the work should enter it at the bench in a few taps, with a note field for the reason behind any rework. Day-end entries are guesses.