How do you convert wet tons to dry tons?

Multiply the wet weight by one minus the moisture fraction. 200 wet tons at 5% moisture is 200 × 0.95 = 190 dry tons and 10 tons of water, the Moisture Content Adjustment calculator's own example.

What is the difference between wet basis and dry basis moisture?

Wet basis is water as a share of the wet weight; dry basis is water as a share of the dry solids. The workbook uses wet basis, which most labs report. To convert a dry-basis figure, divide it by one plus itself: 10% dry basis is 9.1% wet basis.

How is the water above the limit worked out?

It is the wet weight less the wet weight the same dry material would have at the limit: wet − dry ÷ (1 − limit). 29.1 tons of ball clay at 14.6% is 24.85 dry tons; at the 12% limit that would weigh 28.24 tons, so 0.86 tons of the load is water above the limit.

Why is a material shown Out of limits when its average moisture is under the limit?

Contracts apply the limit to each delivery, not to the average. A material is Out of limits when any of its lots is over; in the example ball clay averages 11.4% against 12% but two loads were over.

How is the testing cost worked out?

Each delivery carries the testing and handling cost per wet ton; each month adds the fixed lab cost on Setup. At 0.50 a ton and 75 a month, a month of 107.7 wet tons costs 128.85, about 1.28 per dry ton.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test lots and shows Self-check: PASS.

Quality and Inspection

Moisture and Dry Tonnage Log Excel Template

Dry tons = wet tons × (1 − moisture content). Log every delivery of clay, sand or other bulk mineral with its weighbridge weight and tested moisture, and see its dry weight, the water you hauled with it, its dry-basis value and any water above the contract limit, month by month and material by material.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This moisture and dry tonnage log is a working Excel workbook for quality managers, purchasing and stores staff receiving clays, sands, minerals and other bulk materials bought on a dry basis. Each delivery is one row with its date, weighbridge ticket, material, supplier, wet weight and the moisture from the lab; each material's price per dry ton and moisture limit come from Setup. The workbook gives the dry weight, the water, the dry-basis value, the water above the contract limit and the testing cost, and totals dry tons, water and testing cost by month. It ships with six months of deliveries of four materials at a fictional tile maker, so every tile and chart is filled in when you open it.

In the example 650 wet tons arrived in 24 loads: 608 tons of dry material and 42 tons of water. Billed on the wet weight at the dry-ton prices, that water would have cost 4,564. In September and October rain at the pits pushed ball clay to 12.9% and 14.6% against a 12% limit: the October load of 29.1 wet tons was 24.85 tons of clay and 4.25 of water, 0.86 tons more water than the limit allows. A silica sand load from an uncovered stockpile tested 6.3% against 5%.

A moisture result is only as good as the sample behind it. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your site, currency and mass unit, the testing cost per wet ton and fixed lab cost per month, and the materials with their price per dry ton and moisture limit
Lots table, one row per delivery: date, ticket, material, supplier, wet weight and tested moisture, with a Check column
Per delivery: dry weight, water, water above the moisture limit, a status in words, dry-basis value, what the water would cost if billed wet, and the testing cost
Dashboard with four tiles (lots, dry weight, water, lots over moisture limit), the moisture of the material you pick against its limit over its last six deliveries, moisture against limit by material, and the material, trend and six-month tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Moisture Content Adjustment calculator (Self-check: PASS)
CSV with live formulas for the Lots table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to check suppliers' invoices against dry tons, to raise moisture claims on loads over the contract limit, or to report raw material receipts and stock on a consistent dry basis.

How to use it

On Setup, type your site, currency and mass unit, your testing cost per wet ton and fixed lab cost per month, and list your materials with their price per dry ton and moisture limit.
On Lots, give each delivery a row: date, ticket, material, supplier, wet weight and the tested moisture.
Fix anything the Check column names.
Open the Dashboard: pick a material for its moisture trend, and see moisture against the limit by material and dry tons by month.

Frequently Asked Questions

How do you convert wet tons to dry tons?: Multiply the wet weight by one minus the moisture fraction. 200 wet tons at 5% moisture is 200 × 0.95 = 190 dry tons and 10 tons of water, the Moisture Content Adjustment calculator's own example.
What is the difference between wet basis and dry basis moisture?: Wet basis is water as a share of the wet weight; dry basis is water as a share of the dry solids. The workbook uses wet basis, which most labs report. To convert a dry-basis figure, divide it by one plus itself: 10% dry basis is 9.1% wet basis.
How is the water above the limit worked out?: It is the wet weight less the wet weight the same dry material would have at the limit: wet − dry ÷ (1 − limit). 29.1 tons of ball clay at 14.6% is 24.85 dry tons; at the 12% limit that would weigh 28.24 tons, so 0.86 tons of the load is water above the limit.
Why is a material shown Out of limits when its average moisture is under the limit?: Contracts apply the limit to each delivery, not to the average. A material is Out of limits when any of its lots is over; in the example ball clay averages 11.4% against 12% but two loads were over.
How is the testing cost worked out?: Each delivery carries the testing and handling cost per wet ton; each month adds the fixed lab cost on Setup. At 0.50 a ton and 75 a month, a month of 107.7 wet tons costs 128.85, about 1.28 per dry ton.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test lots and shows Self-check: PASS.