Weather knowledge for the working farmFind current NWS forecasts & warnings ↗
AgWeather & Alerts HubA practical farm weather directory

Spreadsheet errors can be larger than instrument errors. Look for duplicate dates, missing readings, unit changes, overflow and totals that span several days.

What changes the decision

Preserve the raw record before correcting an interpretation.

Illustrative farm scenario

Work through the situation

A two-day accumulation is entered on both dates, doubling the event. Correct the duplicate while keeping the original note. A monthly total that looks wet may be an accounting problem rather than a weather signal.

Put the information to work

  1. Check dates and units before summing.
  2. Mark accumulations and gaps.
  3. Compare monthly totals with a suitable nearby station as a reasonableness check.

Understand the weather behind it

Water entering a field is not automatically water stored where active roots can use it. Runoff, evaporation and drainage can change the usable amount. Weather-based crop use must match the crop coefficient and reference method, while soil observations help check the estimate. Keep rainfall, irrigation and deficits in compatible units and record the area irrigated. A water balance supports a decision only when its assumptions fit the field.

Terms used in this decision

ET
Evaporation and plant transpiration combined.
Root-zone deficit
The estimated shortage relative to the chosen soil-water reference.

A field record for this job

Use one record for the specific location and work period. Keep the original source or measurement available so another person can understand why the decision was made.

Record fields for Checking a Farm Rainfall Spreadsheet Before Using the Totals
RecordYour notes
Measured rainfall and effective root-zone contribution________________________________
Irrigated area, applied volume or depth________________________________
Crop stage, soil zone and representative depths________________________________
Next check and responsible person________________________________

Before the plan is committed

  • Which depth and area does the number represent?
  • Did rainfall reach and remain in the active roots?
  • Can the system deliver the required water in time?

Sources and local help

Use the source appropriate to the actual crop, animal, machine and location. Equipment manuals, current product instructions and advice from qualified local specialists supply details that a general weather guide cannot determine.

Find local forecasts, weather networks and Extension offices · Find television and radio weather