Agronomy Field & Trial Calculators: 11 Excel Spreadsheets

One Excel workbook with the calculations agronomists, growers and ag students do every week, organized and ready to use.

Type your data in the yellow cells and the results appear in the green ones. Formulas are protected so they can't be overwritten, and every sheet comes with a worked example.

What it calculates:

• Seeding rate: kg/ha and seeds per metre of row from target population, seed weight, germination and establishment.

• Sprayer calibration (volumetric method, nozzle check, required flow and pressure) and knapsack calibration.

• Tank mix: product per tank, hectares per tank and number of tank loads.

• Soybean and corn yield estimates from yield components, in kg/ha and bu/ac.

• Harvest losses in kg/ha and % against an editable tolerance.

• Moisture shrink and its value.

• Lime by base saturation and gypsum by clay content.

• Fertilizer: from kg of N, P2O5 and K2O to kg of urea, MAP, TSP, potash and more, with cost per ha.

• Gross margin, break-even yield and break-even price.

• Farm unit conversions (metric and US).

TRIAL BONUS: randomized complete block layout (up to 12 treatments × 6 blocks) with reproducible randomization and a field book, plus a yield sheet with means, difference vs the check, ANOVA, CV % and LSD.

Includes a PDF user guide. Tested in Microsoft Excel; can be imported into Google Sheets. No macros.

Author: Juan Francisco Sanchez, who runs a crop trials company in Rosario, Argentina.

Please note: this is a support tool. Results depend on the data you enter; always check rates against the product label and with your agronomic adviser.