
RAP Manual & Excel Files : Blank & Example
THE 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
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 - Groundwater Data (MCM)
Table 7 - Precipitation, Effective Precipitation, and Deep Percolation of Precipitation
Table 8 - Special Agronomic Requirements (mm)
Table 9 - Crop Yields and Values
WORKSHEET 5. PROJECT OFFICE QUESTIONS
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
WORKSHEET 14. WORLD BANK BMTI INDICATORS
HOW TO USE FIELD IE VALUES
SUMMARY OF THE INTERPRETATION PROCESS
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 open document as ms-word format
Click here to open document as pdf format
October
2002
Revised for World Bank Irrigation Institutions Window
Dr.
Charles Burt
Irrigation Training and Research Center (ITRC)
California Polytechnic State University (Cal Poly)
San Luis Obispo, California, USA 93407
cburt@calpoly.edu
originally funded by:
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
Thierry.Facon@fao.org
modified with funds from:
Irrigation Institutions
Window
The World Bank
Dr. Fernando Gonzalez - Task Manager
FGonzalez@worldbank.org