Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Order production tracker for a gold workshop

Order production tracker for a gold workshop

How many days did each order spend in each stage, and is it late against what was agreed?

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. This calculator is the same as the "Order production tracker: which stage ran late?" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

OrderPieceAgreed time (days)CastingFinishingStone settingPolishingTotal daysDays lateLongest stageStatusDelete

Result

Who this calculator is for

This is the online version of the "Order production tracker: which stage ran late?" sheet, made for goldsmiths and shop owners. A sheet to follow orders through the workshop: the days in each stage (casting, finishing, stone setting, polishing), the total, the agreed time, the delay, and the longest stage.

The question it answers: How many days did each order spend in each stage, and is it late against what was agreed?

How to use it

  1. The order: The number, the piece and the agreed time.
  2. The stages: The days each stage took, once it is done.
  3. The total: The sheet adds up the days.
  4. The delay: Compared with the agreed time.
  5. Longest stage: Where the time goes.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total days late1

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

The calculation

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 (تلميع).

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Tracking orders in a gold workshop: finding the delay.

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.

Related calculators

All calculators · All free sheets