Computerised irrigation scheduling using spreadsheet models

Microcomputers are increasingly being used to help in the management of smallholder irrigation schemes in Third World countries. In many cases, commercially available spreadsheet packages offer advantages over established scientific programming languages. The paper starts with a review of computer models which have been developed for irrigation scheduling. Two criteria are identified which must be considered when developing computer models for this purpose: realistic data requirements and programs which are easy to understand. Spreadsheet packages provide a good introduction to computing and macro programming techniques can be used to customise spreadsheet models to create refined yet simple management tools. Two practical examples are presented from current research projects:

-a small scale scheme in Zimbabwe, where a spreadsheet model is used to produce irrigation schedules for smallholder farmers;

-a 20,000 ha project in Thailand, where a spreadsheet model makes use of feedback to improve main system scheduling.