Click here to download document as ms-word formatTHE RAPID APPRAISAL PROCESS (RAP)
EXTERNAL INDICATORS FOR WATER SOURCES AND WATER DESTINATIONS
INTERNAL PROCESS AND INTERNAL INDICATORS
THE EXCEL SPREADSHEETS FOR RAP
GENERAL GUIDELINES FOR EXCEL WORKSHEET USAGE
Cell Coloring and Input Conventions
Prior to Table 1
Table 1 - Field Coefficients and Crop Threshold ECe
Table 2 - Monthly ETo values
Table 3 - Surface Water Entering the Command Area Boundaries (MCM)
Table 4 - Internal Surface Water Sources (MCM)
Table 5 - Hectares of Each Crop in the Command Area, by Month
Table 6 - Aquifer Data
Table 7 - Groundwater Data (MCM)
Table 8 - Precipitation, Effective Precipitation, and Deep Percolation of Precipitation
Table 9 - Special Agronomic Requirements (mm)
Table 10 - Crop Yields and ValuesWORKSHEET "2. INPUT - YEAR 2", AND "3. INPUT - YEAR 3"
WORKSHEET "4. EXTERNAL INDICATORS"
WORKSHEET 5. PROJECT OFFICE
WORKSHEET 6. PROJECT EMPLOYEES
WORKSHEET 7. WUA
WORKSHEET 8. MAIN CANAL
WORKSHEET 9. SECOND LEVEL CANALS
WORKSHEET 10. THIRD LEVEL CANALS
WORKSHEET 11. FINAL DELIVERIES
WORKSHEET 12. INTERNAL INDICATORS
WORKSHEET 13. IPTRID INDICATORS
This document also provides an explanation the EXCEL documents that are used by persons during the RAP. An EXCEL spreadsheet (with 13 internal worksheets) is provided twice:
As the names suggest, the EXAMPLE has data in it so that users can examine an example before entering data in a blank spreadsheet.
Click here to download document as ms-word format
Click here to download document as pdf format
September 2001
Dr.
Charles Burt
Irrigation Training and Research Center (ITRC)
California Polytechnic State University (Cal Poly)
San Luis Obispo, California, USA 93407
Food
and Agriculture Organization of the United Nations
FAO Regional Office for Asia and the Pacific
39 Phra Atit Road
Bangkok 10200, THAILAND
Thierry Facon - Water Managment Officer
