Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Filings and sweepings calculator: expected vs returned

Filings and sweepings calculator: expected vs returned

The filings and sweepings we sent to the lab: how much should come back, and how much actually did?

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.

Settings and prices

Loading today's prices…

The table

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

BatchTypeWeight sent (g)Lab purity (per thousand)Pure gold returned (g)Lab fee per gramExpected pure gold (g)Expected, returned batches (g)Difference (g)Net valueDelete

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

  1. The batch: The type and the weight sent.
  2. The test: The purity the lab measured.
  3. What came back: The pure gold returned and the fee.
  4. Compare: The expected gold and the difference.
  5. 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:

ResultValue
Expected pure gold (all batches)66.460
Expected from the batches returned41.820
Pure gold actually returned41.300
Difference (returned − expected)−0.520
Total net value287,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

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

All calculators · All free sheets