Short answer: Create columns for metal, weight, price per kilogram, gross value and an allowance percentage, enter each metal on its own row, calculate weight times price and apply the allowance, then total the column, and keep the sheet so that you can update the prices each time you sell, because a template you reuse makes every future estimate a two-minute job.
Estimate done? See current prices and offers.
List Free →Five columns
Metal, weight, price, gross value and allowance are enough.
Reuse it
Updating prices and weights each time makes the template quick to use.
Add a notes column
Recording the buyer and the actual payment shows how your estimates compare with reality.
How ScrapTrade Fits In
ScrapTrade price pages give you the numbers to drop into your sheet.
An estimate makes you a harder person to underpay. ScrapTrade shows current prices and connects you with verified buyers, transparent weighing and escrow-protected payments.
List or Find Scrap on ScrapTrade →Practical answers on estimating the value of a scrap load from weight, metal type and realistic deductions.