# Alloying gold: turning gold into 21K or 18K | Free sheet

> Free Excel and PDF sheet for alloying gold: pure gold and final weight at 21K or 18K, the alloy to add, or the 24K needed to raise the karat.

Source: https://qintar.app/en/sheets/workshop-alloying.html
Language: English
قنطار (Qintar)، qintar.app

---

# Alloying gold: turning gold into 21K or 18K

Free sheet for goldsmiths and shop owners · I have gold of a given karat: how much alloy do I add to make it 21K or 18K?

Moving gold from one karat to another is a matter of proportion: the pure gold stays the same and the weight changes. This sheet works out the final weight and the alloy to add, or the 24K to add if you are raising the karat.

[Download PDF138 KB](https://qintar.app/en/sheets/workshop-alloying.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-alloying.xlsx)

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](https://qintar.app/en/tools/workshop-alloying.html).

![Preview of the first page of the "Alloying gold: turning gold into 21K or 18K" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-alloying.png)

## How to use it

1. **What goes in:** The weight of the gold and its karat, or its purity per thousand if it was tested.
2. **The target:** The karat you want to reach.
3. **Final weight:** Pure gold ÷ purity of the target karat.
4. **The alloy:** The difference between the final weight and the weight in, when you lower the karat.
5. **Raising the karat:** If the target is higher, the sheet works out how much 24K to add.

## Example The calculation with numbers

| Note | Weight in (g) | Current karat | Target karat | Pure gold (g) | Final weight at the target karat | Alloy to add (g) | 24K to add to raise the karat (g) |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Example: 24K bar to 21K | 100.000 | 24 | 21 | 99.900 | 114.171 | 14.171 | 0.000 |
| Example: 24K bar to 18K | 50.000 | 24 | 18 | 49.950 | 66.600 | 16.600 | 0.000 |
| Example: 18K scrap to 21K | 40.000 | 18 | 21 | 30.000 | 34.286 | 0.000 | 40.323 |

| Result | Value |
| --- | --- |
| Total pure gold | 179.850 |
| Total alloy | 30.771 |
| Total 24K added | 40.323 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

## The calculation

- Pure gold = weight × purity (24K = 0.999, 21K = 0.875, 18K = 0.75, or the lab purity ÷ 1000).
- Final weight = pure gold ÷ purity of the target karat. Alloy = final weight − weight in.
- To raise the karat: 24K to add = (target purity × weight − pure gold) ÷ (0.999 − target purity).

## Terms used on this sheet

- **Karat:** Gold content in 24ths: 21K is 21 parts gold in 24, which is 87.5%; 18K is 75%.
- **Alloy:** The other metals melted in with the gold to lower its karat, usually a copper and silver mix chosen by the workshop.
- **Hallmark:** The stamp on a finished piece that shows its purity (الدمغة).

## Read more

- [Alloying gold: working out the alloy for 21K and 18K](https://qintar.app/en/articles/gold-alloying-karat.html)A step-by-step guide with a worked example.
- [Gold alloying calculator: how much alloy for 21K or 18K?](https://qintar.app/en/tools/workshop-alloying.html)The same sheet online, with today's prices.

## Frequently asked questions

**What is the alloy made of?**

The kind of alloy and its share of copper and silver are the workshop's choice, and they affect the color and hardness. The sheet works out the weight only.

**Does this include the melting loss?**

No. This is the purity calculation. Record the melting loss in the craftsman account sheet or in your stock count.

**Why 0.999 for 24K?**

In the calculation 24K is 99.9% pure, as on every other Qintar sheet.

**Why do the examples aim at 21K?**

21K is Egypt's standard karat for jewelry, and the gold pound is 21K too. That is why the examples bring a 24K bar and 18K scrap to 21K; the sheet works in both directions.

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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?

[All free sheets](https://qintar.app/en/sheets/)
