- Qintar
- Calculators
- Filings and sweepings calculator: expected vs returned
Filings and sweepings calculator: expected vs returned
Filings, floor sweepings and wash water all hold gold that comes back through refining. This sheet records each batch and compares the pure gold returned with what the lab's test said to expect. This calculator is the same as the "Filings and sweepings: how much gold came back?" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Filings and sweepings: how much gold came back?" sheet, made for goldsmiths and shop owners. A sheet for batches of filings, floor sweepings and wash water: the weight sent, the purity the lab measured, the expected pure gold, the pure gold actually returned, the difference, the lab fee and the net value.
The question it answers: The filings and sweepings we sent to the lab: how much should come back, and how much actually did?
How to use it
- The batch: The type and the weight sent.
- The test: The purity the lab measured.
- What came back: The pure gold returned and the fee.
- Compare: The expected gold and the difference.
- The value: At today's price, minus the fee.
Worked example
Buying price, 1 g of 24K (example): 7,009.37
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Expected pure gold (all batches) | 66.460 |
| Expected from the batches returned | 41.820 |
| Pure gold actually returned | 41.300 |
| Difference (returned − expected) | −0.520 |
| Total net value | 287,298.76 |
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
- Expected pure gold = weight sent × the purity the lab measured ÷ 1000.
- Difference = pure gold returned − expected (once it is returned).
- Net value = returned ÷ 0.999 × the 24K buying price − returned × the lab fee per gram.
Terms used on this sheet
- Filings
- Gold dust and shavings from filing and polishing (رايش), collected at the bench.
- Floor sweepings
- Dust swept from the workshop floor, which holds fine gold particles (تراب).
- Purity per thousand
- A lab result in parts per thousand: 610 means 61% of the weight is gold.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Workshop filings and sweepings: did the lab return your gold?.
Frequently asked questions
Where does the purity figure come from?
From the lab's test of a sample. The sheet does not estimate purity; it uses the lab's figure.
What does a negative difference mean?
That less came back than the test suggested. Ask the lab how they calculate and what loss rate they apply.
How much is the lab fee?
Whatever you agree with the lab. The figure in the example is an illustration.
Why is floor dust worth sending?
Because gold dust settles everywhere in a workshop. Even at a low purity, a large weight of sweepings can hold many grams of pure gold, as the example shows.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.
Related calculators
- Gold alloying calculator: how much alloy for 21K or 18K?I have gold of a given karat: how much alloy do I add to make it 21K or 18K?
- Craftsman account: loss, allowance and wagesHow much gold did the craftsman take and return? Is the loss within the allowance? What are the wages?
- Casting loss calculator: each batch and its allowanceHow much gold did this casting batch lose, and is it within the allowance?
- Piece cost calculator for a gold workshopWhat does this piece cost the workshop, and what is the real cost of the work per gram?
- Gold loss calculator for each manufacturing stageAt which stage does the gold loss happen: casting, filing or polishing?