Forage Test Log Worksheet
This log records each lab test in one row so you can compare lots, track change over time and see which hay gives the cheapest nutrients. Keep it in a notebook or spreadsheet.
Why it matters
Lab reports pile up and are easy to lose or misread. A single log lets you compare lots side by side, justify prices to buyers and plan feeding groups with real, current numbers each winter.
Step by step
- Create columns: lot ID, field, cutting, harvest date, sample date, moisture, dry matter protein, ADF, NDF, TDN, price per ton.
- Fill one row for each lab report as soon as it arrives, copying values from the same basis.
- Add calculated columns for protein pounds per ton and cost per pound of protein.
- Add a notes column for storage, weather, mold, bale type, bale count and storage location.
- Sort by cost per pound of protein or energy and assign each lot to the group it fits best.
What good looks like
A good log is complete, uses one basis for every value, and lets you find any lot in seconds. Over a few seasons, it shows how weather and cutting date shaped quality.
Worked example
Sample row, illustrative: 10 percent moisture, 14 percent protein on dry matter, ADF 34, NDF 52, price 180 dollars per ton. Dry matter per ton is 1,800 lb, protein is 252 lb, so cost is 180 divided by 252, about 0.71 dollars per lb of protein. Sort the rows by that last column to rank lots from cheapest protein to dearest.
Common mistakes to avoid
- Mixing as fed and dry matter values in the same column.
- Leaving out the lot or cutting, so rows cannot be traced.
- Never recording price, which blocks any cost per nutrient comparison later.
- Entering test values from memory instead of copying the report.
Safety, legal and compliance notes
Keep test reports and sales records as part of your business files. Ask an accountant how long to keep them, and check any written feed claims with your extension office before advertising hay quality.
What to record
Keep a dated hay file: field and cutting, harvest and baling dates, bale counts and weights, moisture at baling, forage test results, storage location, sales or purchase prices and the animals fed. Good records let you compare cuttings, plan winter feed and settle disputes with buyers.
When to ask for help
Weight, moisture, weed-free certification, hauling and sales tax rules vary by state. Talk with your extension forage specialist, a forage testing lab, your state department of agriculture and your insurance agent before you buy, sell, store or haul large amounts of hay. The state directory lists agencies and resources in every state.
Frequently asked questions
What basis should the log use?
Use dry matter for nutrients and note moisture separately in its own column. That way two lots with different water content compare fairly and honestly.
How many lots should be in one log?
Keep every lot for the season in one log, and start a new sheet each year so trends are easy to compare.
Should I log storage conditions?
Yes. Notes on stacking, cover and heating explain why a retest may drop, and they help you decide which lots to feed first.
Related guides
- How to Sample Hay for Testing
- Reading a Forage Test Report
- Relative Feed Value and Quality Explained
- Judging Hay by Sight and Smell
- Bale Weights and Sizes Explained
- Hay Moisture and Heating Risks
More from the network
Farm news, humor and ranch life at farm.FM.