Minnesota/Wisconsin Engineering Notes

Computer Spreadsheet Available for Irrigation Scheduling

Jerry Wright, Minnesota Extension Engineer

A simple, user-friendly spreadsheet style computer program is now available to assist you in planning your next irrigation event and keeping a daily record of your precipitation and irrigations amounts and estimated daily soil water status throughout the growing season. The beta version of the software can be used to monitor daily soil water status for alfalfa, corn, soybeans, potatoes, dry beans, wheat and sugar beets.

The software creates a spreadsheet-like working file for each field that reflects the soil types and depth, available water holding capacity, crop type and emergence date.

The software generates a 30-day soil water depletion graph for each field for any date, which is easily printed to take to the field or to file with other annual information pieces on performance and input records.

After an initial file setup and an in-field soil moisture estimation, the user needs to enter the daily maximum air temperature, rainfall amounts, and irrigation depths for each respective event. If the day’s air temperature is not entered, a historical maximum temperature is already assigned based on the nearest historical weather site that is incorporated into the software. The software lists several regional weather stations around Minnesota and North Dakota.

Once the daily inputs are updated in the spreadsheet for the specific field, a new estimated soil water depletion status is calculated for each day (expressed in inches of water depleted and also percent deficit). This estimate should be cross-checked every five to ten days with an in-field soil water assessment. If differences are found, a correction can be made to the spreadsheet estimate.

The program is designed to run on IBM-compatible computers with Windows 3.1 or higher operating systems. The software requires 5 MB of memory and 5 MB of free hard drive space. The program works best on faster processors and operating systems.

A copy of the software and operating manual can be obtained by sending a $30 check made payable to University of Minnesota to:

West Central Research & Outreach Center
University of Minnesota
Attn: Jerry Wright, Extension Engineer
PO Box 471
Morris, MN 56267

Tom Scherer and Dean Steele, North Dakota State University Irrigation Engineers, and Jerry Wright, University of Minnesota Extension Engineer, developed the software program. The software was field tested with about a dozen farmers and crop consultants in Minnesota during the summer of 1999 and revised in 2000.

The software is based on the concepts used in the University of Minnesota Extension Service bulletin #1322, Irrigation Scheduling: Checkbook Method, which can be viewed at http://www.extension.umn.edu/distribution/cropsystems/DC1322.html or purchased with a credit card by calling 800-876-8636 or 612-624-4900.

For more information contact Jerry Wright, Extension Engineer at the West Central Research and Outreach Center in Morris, MN at 320-589-1711 or jwright@umn.edu.

The information given in this publication is for educational purposes only. Reference to commercial products or trade names is made with the understanding that no discrimination is intended and no endorsement is implied.

 

Regents of the University of Minnesota. All Rights Reserved.
The University of Minnesota is an equal opportunity educator and employer.
This page is part of the Biosystems and Agricultural Engineering Department web at http://www.bae.umn.edu/

Privacy Statement