My business purchases precious metals scrap from consumers. A typical transaction may include multiple metal types and purities. We need a way to capture all this information in a single row while still being able to draw aggregate metrics such as “total grams 14k purchased in 2025.” This template provides a solution using a wide-format dataset.
🚀 What This Solution Does
This template solves the problem of needing to track multiple metal types within a single transaction without creating multiple rows. It uses a wide-format structure to keep your data clean and easy to analyze.
🧠 Use Cases
- Track daily or weekly purchases of different precious metal types.
- Easily calculate and report on total grams purchased for each metal/purity combination.
- Streamline your data entry process for combined invoices.
- Create simple dashboards to visualize purchasing trends over time.
🧑🏫 How It Works
Instead of spreading a single transaction over multiple rows, this template dedicates a column for each unique metal and purity combination (e.g., "Grams 14k Gold," "Grams 22k Gold," "Grams Sterling Silver").
For a transaction, you enter the gram amount for each metal in its respective column. You can then use SUMIF or other aggregation functions in Excel to easily calculate your total metrics from the data.