- Qintar
- Free sheets
- Order production tracker: which stage ran late?
Order production tracker: which stage ran late?
The customer asks: is my order ready? The workshop asks: where did we fall behind? This sheet records the days each order spends in each stage and compares them with the time agreed.
Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. Or try it online without downloading.

How to use it
- The order: The number, the piece and the agreed time.
- The stages: The days each stage took, once it is done.
- The total: The sheet adds up the days.
- The delay: Compared with the agreed time.
- Longest stage: Where the time goes.
Example The calculation with numbers
| Order | Piece | Agreed time (days) | Total days | Days late | Longest stage | Status |
|---|---|---|---|---|---|---|
| Example: 701 | Wedding bands with names | 7 | 4 | 0 | Finishing | On time |
| Example: 702 | Set with stones | 10 | 11 | 1 | Stone setting | Late |
| Example: 703 | Bracelet | 5 | 5 | 0 | Finishing | On time |
| Result | Value |
|---|---|
| Total days late | 1 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Total days = the sum of the days in each stage.
- Days late = total − agreed time (when it is above zero).
- Longest stage = the stage that took the most days on that order.
Terms used on this sheet
- Casting
- Pouring molten gold into molds to form the pieces (صب).
- Finishing
- Filing, assembling and cleaning up the cast pieces (تشطيب).
- Stone setting
- Fixing stones into the piece (تركيب فصوص).
- Polishing
- The last stage, which gives the piece its shine (تلميع).
Read more
- Tracking orders in a gold workshop: finding the delayA step-by-step guide with a worked example.
- Order production tracker for a gold workshopThe same sheet online, with today's prices.
Frequently asked questions
Why days and not dates?
So the calculation works in any spreadsheet program without date problems. Write the date in the piece column if you need it.
My workshop has other stages. Can I change them?
Rename any column to the stage you have; the calculation stays the same.
What agreed time should I type?
The time you agreed with the customer, or the one you set for the workshop.
What if two stages took the same number of days?
The sheet names the first of them, in the order casting, finishing, stone setting, polishing.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.
Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.
More free sheets
- Buying gold at several price levelsIf I split my buying over several prices, what will my average cost be?
- Comparing suppliers: which making charge is cheaper?For an order of a given weight, which supplier has the lowest real making charge after the discount?
- Gold to silver ratio: a daily logHow many grams of silver does a gram of gold buy today, and how does that ratio move?