Spreadsheet: 0a59d8c9-db14-464b-99b2-3930e8bc6308
Sheet: Sheet1

Input rules: | Unnamed: 1 | Unnamed: 2 | A blank cell indicates a place for data input | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | LR | Adj LR | LR/(1-LR) | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29
 |  |  | A shaded cell should not receive input.  It is a default value or explanation cell |  |  |  |  |  |  |  |  |  |  |  | 0.07142857142857142 | 0.07142857142857142 | 0.07692307692307691
 |  | 3 | Red letters indicate computed values |  |  |  |  |  |  |  |  |  |  |  | 0.1111111111111111 | 0.1111111111111111 | 0.125
 |  | 4 | Blue values indicate values that were transferred from elsewhere in the spreadsheet. |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1111111111111111 | 0.1111111111111111 | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1538461538461539 | 0.1538461538461539 | 0.1818181818181818
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Project Name = | Example Project |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Water Year = | 2001 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Total Project area (command and non-command) | 100000 | [NAME]; gross, including roads, all fields, water bodies |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Command area - area with irrig. facilities | 80000 | Physical area in hectares, NOT including multiple cropping |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Estimated conveyance efficiency for external water | 80 | Percent, % |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Est. convey. effic. for internal project recirculation | 90 | Percent, %
 | Estimated seepage (deep perc.) for paddy rice | 10 | Percent, % of irrigation water delivered to fields (averaged over the irrigation season) |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Estimated surface losses from paddy rice to drains | 10 | Percent (%) of irrigation water delivered to fields |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Estimated field irrigation efficiency for other crops | 60 | Percent, % |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Flow rate capacity of main canal(s) at diversion point(s) | 70 | [NAME] per Second (CMS) |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Actual Peak flow rate into the main canal(s) at the diversion point(s) | 65 | [NAME] per Second (CMS)
 | Average ECe of the Irrigation Water | 1 | dS/m   (same as mmho/cm) |  |  |  |  |  |  |  |  |  |  |  | The following table computes the monthly ET, [NAME], using the previous table [NAME] and ETo values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly ET of Each Crop and Area, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Irrigated Crops
This worksheet has 9 tables that require inputs FOR ONE YEAR, in addition to the cells above. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Paddy Rice #1 | 75 | 110 | 120 | 150 | 190 | 220 | 37.5 | 25 | 21 | 18 | 16 | 15 | 997.5
 | Table 1 - Field Coefficients and Crop Threshold Ece |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Paddy Rice #2 | 10 | 11 | 12 | 15 | 19 | 55 | 250 | 250 | 210 | 180 | 24 | 15 | 1051
 | Table 2 - Monthly ETo, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Table 3 - Surface Water Entering Command Area Boundaries |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Crop #4 | 10 | 11 | 72 | 120 | 152 | 176 | 200 | 175 | 105 | 18 | 16 | 15 | 1070
 | Table 4 - Internal Surface Irrigation Water Sources |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Crop #5 | 10 | 11 | 12 | 15 | 19 | 22 | 25 | 25 | 210 | 180 | 160 | 150 | 839
 | Table 5 - Hectares of Each Crop in the Command Area, by Month |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Table 6 - Groundwater Data |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Table 7 - Precipitation, effective precipitation, and deep percolation of precipitation |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Table 8 - Special agronomic requirements |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Table 9 - Crop Yields and Values |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 1 - Field Coefficients and Crop Threshold ECe |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Threshold |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ECe |  |  |  |  |  |  | Field Coefficient, [NAME]  (based on ETo) |  |  |  |  |  | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crop # | Water year month --> |  | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Irrigated Crop Name | dS/m |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | Paddy Rice #1 | 3 | 0.75 | 1 | 1 | 1 | 1 | 1 | 0.15 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Paddy Rice #2 | 2 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.25 | 1 | 1 | 1 | 1 | 0.15 | 0.1
3 | Paddy Rice #3 |  |  |  |  |  |  |  |  |  |  |  |  |  | MCM of ET for each irrigated field in the command area during the growing season, only
4 | Crop #4 | 2 | 0.1 | 0.1 | 0.6 | 0.8 | 0.8 | 0.8 | 0.8 | 0.7 | 0.5 | 0.1 | 0.1 | 0.1 | Crop # | Crop Desc. | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
5 | Crop #5 | 1.5 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 1 | 1 | 1 | 1
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Paddy Rice #1 | 11.25 | 16.5 | 18 | 22.5 | 28.5 | 33 | 5.625 | 0 | 0 | 0 | 0 | 0 | 135.375
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Paddy Rice #2 | 0 | 0 | 0 | 0 | 0 | 19.25 | 87.5 | 87.5 | 73.5 | 63 | 8.4 | 0 | 339.15
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Crop #4 | 0 | 0 | 7.2 | 12 | 15.2 | 17.6 | 20 | 17.5 | 10.5 | 0 | 0 | 0 | 100
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Crop #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.5 | 9 | 8 | 7.5 | 35
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 2  -  Monthly ETo values |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Month --> | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Annual | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Monthly ETo, [NAME].  --> | 100 | 110 | 120 | 150 | 190 | 220 | 250 | 250 | 210 | 180 | 160 | 150 | 2090 |  | Monthly ET Totals, MCM | 11.25 | 16.5 | 25.2 | 34.5 | 43.7 | 69.85 | 113.125 | 105 | 94.5 | 72 | 16.4 | 7.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Effective Ppt Totals, MCM | 2.65 | 3.975000000000001 | 3.975000000000001 | 4.6375 | 5.3 | 5.1 | 6.375 | 3.825000000000001 | 2.8 | 1.4 | 1.4 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly ET - Eff Rain, MCM | 8.6 | 12.525 | 21.225 | 29.8625 | 38.40000000000001 | 64.75 | 106.75 | 101.175 | 91.7 | 70.6 | 15 | 7.5
Table 3 - Surface Water Entering the Command Area Boundaries (Million [NAME]) and which can be used for Irrigation
 | Month --> | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Annual
 | Irrigation Water Entering from outside the command area through regular canals.  The MCM should be the total MCM at the original diversion point. | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 80 | 80 | 70 | 40 | 40 | 660
 | Other Irrigation water inflows to Command Area from External Source #2 (Define below) | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | 100
 | Other Irrigation water inflows to Command Area from External Source #3 (Define below) |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Total Surface Irrigation Water Sources | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 90 | 85 | 75 | 45 | 45 | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (ET - Effective Precipitation),   MCM
 | Define the External Sources of Irrigation Surface Water |  |  |  |  |  |  |  |  |  |  |  |  |  | Irrigated Crop Name | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
 |  | External Source #2: | River |  |  |  |  |  |  |  |  |  |  |  | Paddy Rice #1 | 10.5 | 15.375 | 16.875 | 21.1875 | 27 | 31.5 | 3.75 | -1.125 | -0.7500000000000001 | -0.3750000000000001 | -0.3750000000000001 | 0 | 123.5625
 |  | External Source #3: |  |  |  |  |  |  |  |  |  |  |  |  | Paddy Rice #2 | -1.4 | -2.1 | -2.1 | -2.45 | -2.8 | 16.45 | 84 | 85.4 | 72.1 | 62.3 | 7.7 | 0 | 317.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 4 - Internal Surface Irrigation Water Sources (Million [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crop #4 | -0.5 | -0.75 | 6.45 | 11.125 | 14.2 | 16.8 | 19 | 16.9 | 10.1 | -0.2 | -0.2 | 0 | 92.92499999999998
 | ("non-canal" water could have originated from canals, but the volumes below are pumped or diverted from rivers, drains, lakes, etc.) |  |  |  |  |  |  |  |  |  |  |  |  |  | Crop #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.25 | 8.875 | 7.875 | 7.5 | 34.5
 | Month --> | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Annual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Direct Farmer Usage of non-canal Water Inside the Command Area. | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Project Authority Use of non-canal Surface Water Inside Command Area. | 10 |  | 10 | 10 | 10 |  | 5 |  |  |  |  |  | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Recirculation inside Command Area | 30 | 20 | 30 | 30 | 30 | 20 | 25 | 20 | 20 | 20 | 20 | 20 | 285 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 5  - Hectares of Each Crop in the Command Area, by Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | (note - the blue numbers in the cells for each month are the Kc values that were entered earlier.  An area must be entered in the blank cells for those Kc values to be used) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Crop # | Month of the Water Year--> | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | [NAME]. value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Crop Name |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Fields with no crop this month (computed value) | 65000 | 65000 | 55000 | 55000 | 55000 | 20000 | 20000 | 35000 | 30000 | 40000 | 40000 | 75000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Paddy Rice #1 | 0.75 | 1 | 1 | 1 | 1 | 1 | 0.15 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |  | NET NEEDED BY MONTH, MCM (not including | 8.6 | 12.525 | 21.225 | 29.8625 | 38.4 | 64.75 | 106.75 | 101.175 | 91.69999999999999 | 70.6 | 15 | 7.5 | 568.0875
1 | Paddy Rice #1 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 |  |  |  |  |  | 15000 | special needs and salinity control)
 | Paddy Rice #2 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.25 | 1 | 1 | 1 | 1 | 0.15 | 0.1 |  |  | Gross Needed at the Field (includes field efficiency and special rice losses of deep perc and surface runoff) - MCM
2 | Paddy Rice #2 |  |  |  |  |  | 35000 | 35000 | 35000 | 35000 | 35000 | 35000 |  | 35000 | Irrigated Crop Name | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
 | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Paddy Rice #1 | 13.125 | 19.21875 | 21.09375 | 26.484375 | 33.75 | 39.375 | 4.6875 | -1.40625 | -0.9375000000000001 | -0.4687500000000001 | -0.4687500000000001 | 0 | 154.453125
3 | Paddy Rice #3 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Paddy Rice #2 | -1.75 | -2.625 | -2.625 | -3.0625 | -3.5 | 20.5625 | 105 | 106.75 | 90.12499999999999 | 77.87499999999999 | 9.625 | 0 | 396.375
 | Crop #4 | 0.1 | 0.1 | 0.6 | 0.8 | 0.8 | 0.8 | 0.8 | 0.7 | 0.5 | 0.1 | 0.1 | 0.1 |  | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Crop #4 |  |  | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 |  |  |  | 10000 | Crop #4 | -0.8333333333333334 | -1.25 | 10.75 | 18.54166666666666 | 23.66666666666667 | 28 | 31.66666666666667 | 28.16666666666666 | 16.83333333333333 | -0.3333333333333334 | -0.3333333333333334 | 0 | 154.875
 | Crop #5 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 1 | 1 | 1 | 1 |  | Crop #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17.08333333333334 | 14.79166666666667 | 13.125 | 12.5 | 57.5
5 | Crop #5 |  |  |  |  |  |  |  |  | 5000 | 5000 | 5000 | 5000 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | TOTAL GROSS NEEDED BY MONTH, MCM | 10.54166666666667 | 15.34375 | 29.21875 | 41.96354166666666 | 53.91666666666667 | 87.9375 | 141.3541666666667 | 133.5104166666667 | 123.1041666666667 | 91.86458333333333 | 21.94791666666666 | 12.5 | 763.2031249999999
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | before check with special requirements, and also not including salinity requirements |  |  |  |  |  |  |  |  |  |  |  | Computed Overall Field Irrigation Efficiency = | 74.43464018835091
12 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Maximum Gross Needed Per Month - Including Special Requirements  - MCM
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Irrigated Crop Name | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Paddy Rice #1 | 20.625 | 19.21875 | 21.09375 | 26.484375 | 33.75 | 39.375 | 4.6875 | -1.40625 | -0.9375000000000001 | -0.4687500000000001 | -0.4687500000000001 | 0 | 161.953125
14 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Paddy Rice #2 | -1.75 | -2.625 | -2.625 | -3.0625 | -3.5 | 20.5625 | 105 | 106.75 | 90.12499999999999 | 77.87499999999999 | 9.625 | 0 | 396.375
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Crop #4 | -0.8333333333333334 | -1.25 | 10.75 | 18.54166666666666 | 23.66666666666667 | 28 | 31.66666666666667 | 28.16666666666666 | 16.83333333333333 | -0.3333333333333334 | -0.3333333333333334 | 0 | 154.875
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | Crop #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17.08333333333334 | 14.79166666666667 | 13.125 | 12.5 | 57.5
16 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Irrigated Cropland, Ha | 15000 | 15000 | 25000 | 25000 | 25000 | 60000 | 60000 | 45000 | 50000 | 40000 | 40000 | 5000 | 65000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
The [NAME] data below should be provided only if wells are used within the project area. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 6 Groundwater Data (MCM) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Month --> | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Annual | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ground water pumped by farmers Inside the Command Area | 10 |  |  |  |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ground water pumped by the Project Authorities Inside the Command Area. | 10 | 10 | 5 | 100 | 5 | 5 |  |  |  |  |  |  | 135 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Ground water pumped from the Aquifer, But which remains outside the Command Area |  |  |  |  |  |  |  |  |  |  |  |  | 0 | TOTAL GROSS NEEDED BY MONTH, MCM | 18.04166666666667 | 15.34375 | 29.21875 | 41.96354166666666 | 53.91666666666667 | 87.9375 | 141.3541666666667 | 133.5104166666667 | 123.1041666666667 | 91.86458333333333 | 21.94791666666666 | 12.5
 | Ground water pumped outside the Command Area and then brought into the command area. |  |  | 100 |  |  |  |  |  |  |  |  |  | 100 | Including special practices
 | Total ground water pumped outside Command Area | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | Not including salinity control
 | Total Ground water pumped Inside the Command Area | 20 | 10 | 5 | 100 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 245 | Maximum Monthly Value, MCM: | 141.3541666666667
Reality Check on Groundwater Storage and [NAME]:
 | A.  Total reported annual pump withdrawals from the aquifer = |  |  | 345 | MCM |  |  |  |  |  |  |  |  |  | Examine the MCM of irrigation water needed in a year for salt removal
 | B.  Estimation of seepage and deep percolation of irrigation water |  |  |  |  |  |  |  |  |  |  |  |  |  | Net mm for salt removal = previous Net*LR/(1-LR) - (Rain Deep Perc)….but not less than zero
 | Your previous estimate of conveyance efficiency of external water (%): |  | 80 | This estimate includes spills, seepage, and evaporation. |  |  |  |  |  |  |  |  |  |  |  |  |  | LR | Adj. LR | [NAME] of | LR - DP | LR needed
 | Your estimate of the % of external water that deep percolates during conveyance: |  |  |  |  | 15 | % |  |  |  |  |  |  |  | Crop # | ET-(Effective Rain), MCM | LR/(1-LR) | Net MCM | Net MCM | Rain, MCM | MCM | MCM
 | **Note: your deep percolation estimate cannot exceed: |  |  | 20 | %
 | Your previous est. of the convey. effic. of internal project well water (%): |  | 90 |  |  |  |  |  |  |  |  |  |  |  | 1 | 123.5625 | 0.07692307692307691 | 9.504807692307692 | 9.504807692307692 | 11.7 | -2.195192307692308 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 317.1 | 0.125 | 39.6375 | 39.6375 | 27.3 | 12.3375 | 12.3375
 | Est. of field irrigation efficiency computed from your earlier values: |  | 75.57234999022738 | % | (this is weighted between rice and other crops; you must complete Table 7 before a value is displayed) |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Your estimate of the % of delivered water that deep percolates on-farm: |  |  |  |  | 20 | % |  |  |  |  |  |  |  | 4 | 92.92499999999998 | 0.125 | 11.615625 | 11.615625 | 7.8 | 3.815624999999998 | 3.815624999999998
 | **Note: your deep percolation estimate cannot exceed: |  |  | 24.42765000977262 | % |  |  |  |  |  |  |  |  |  | 5 | 34.5 | 0.1818181818181818 | 6.272727272727272 | 6.272727272727272 | 0.4 | 5.872727272727272 | 5.872727272727272
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Estimated surface water imports that deep percolate due to conveyance seepage |  |  | 114 | MCM |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Estimated surface water imports that deep percolate on-farm |  |  | 30.4 | MCM |  |  |  |  |  |  |  |  |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | C.  Estimate of pumped groundwater that is used for ET or special practices in the command area: |  |  |  | 12.82451625513062 | MCM |  |  |  |  |  |  |  |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] from surface canal water that originated outside the boundaries |  |  |  | 144.4 | MCM |  |  |  |  |  |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | E.  Difference (C - D).   If the value > 0.0, the aquifer is considered as an external water source |  |  |  | -131.5754837448694 | MCM - Estimated net Aquifer contribution |  |  |  |  |  |  |  |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Rough estimate of Net Aquifer Contribution as an external source: | 0 | MCM |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0
END of the GROUNDWATER INPUT SECTION |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 7 - Precipitation, effective precipitation, and deep percolation of precipitation |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | This table requires 3 inputs for each month: |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A.  The gross millimeters of precipitation per month. |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B.   For each crop, an estimate of the PERCENT of the precipitation that is effective, by month. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NET MCM of irrigation water needed for salt control: | 22.02585227272726
 | Effective precipitation is defined for this worksheet as precipitation that is either
 | - Stored in the root zone of the crop for use as ET in subsequent months, or
 | - Is used as ET during that month…….it does NOT include deep percolation for salt removal
 | ***All other precipitation either DEEP PERCOLATES, or RUNS OFF.
 | C.  For each crop, an estimate of the millimeters of deep percolation of precipitation beyond the root zone, by month. |  |  |  |  |  |  |  |  |  |  |  |  |  | NET Needed Per Month, PLUS any special GROSS requirements - MCM
 |  | Item | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | It is understood that this isn't the perfect combination (Net plus Gross) - but the "special" requirements are difficult to handle.
 |  | Precipitation, [NAME] | 20 | 30 | 30 | 35 | 40 | 40 | 50 | 30 | 20 | 10 | 10 | 0
 | Crop Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Irrigated Crop Name | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
Crop # | Irrigated Crops |  |  |  |  |  |  |  |  |  |  |  |  |  | Paddy Rice #1 | 18 | 15.375 | 16.875 | 21.1875 | 27 | 31.5 | 3.75 | -1.125 | -0.7500000000000001 | -0.3750000000000001 | -0.3750000000000001 | 0 | 131.0625
 |  | ETfield, [NAME] | 75 | 110 | 120 | 150 | 190 | 220 | 37.5 | 25 | 21 | 18 | 16 | 15 | Paddy Rice #2 | -1.4 | -2.1 | -2.1 | -2.45 | -2.8 | 16.45 | 84 | 85.4 | 72.1 | 62.3 | 7.7 | 0 | 317.1
1 | Paddy Rice #1 | % Effective precip | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | Paddy Rice #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 5 | 7.5 | 7.5 | 8.75 | 10 | 10 | 12.5 | 7.5 | 5 | 2.5 | 2.5 | 0 | Crop #4 | -0.5 | -0.75 | 6.45 | 11.125 | 14.2 | 16.8 | 19 | 16.9 | 10.1 | -0.2 | -0.2 | 0 | 92.92499999999998
 |  | Deep perc. of [NAME], [NAME]. | 5 | 5 | 6 | 6 | 6 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | Crop #5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.25 | 8.875 | 7.875 | 7.5 | 34.5
 |  | ETfield, [NAME] | 10 | 11 | 12 | 15 | 19 | 55 | 250 | 250 | 210 | 180 | 24 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | Paddy Rice #2 | % Effective precip | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 4 | 6 | 6 | 7 | 8 | 8 | 10 | 6 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. | 5 | 5 | 6 | 6 | 6 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | Paddy Rice #3 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 10 | 11 | 72 | 120 | 152 | 176 | 200 | 175 | 105 | 18 | 16 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | Crop #4 | % Effective precip | 25 | 25 | 25 | 25 | 25 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 5 | 7.5 | 7.5 | 8.75 | 10 | 8 | 10 | 6 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. | 5 | 5 | 6 | 6 | 6 | 10 | 10 | 10 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 10 | 11 | 12 | 15 | 19 | 22 | 25 | 25 | 210 | 180 | 160 | 150 | TOTAL by MONTH: | 16.1 | 12.525 | 21.225 | 29.8625 | 38.4 | 64.75 | 106.75 | 101.175 | 91.69999999999999 | 70.6 | 15 | 7.5 | 575.5875
5 | Crop #5 | % Effective precip |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25 |  |  |  |  |  |  |  |  |  |  |  |  | 575.5875
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2.5 | 2.5 | 0 | Maximum monthly value, MCM: | 575.5875
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  | 2 | 2 | 2 | 2
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | Item | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MCM ppt on irrigated fields in command | 16 | 24 | 24 | 28 | 32 | 32 | 40 | 24 | 16 | 8 | 8 | 0 | 0
 |  | Deep perc. of [NAME], [NAME].
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MCM effective ppt on irrig land in command | 2.65 | 3.975000000000001 | 3.975000000000001 | 4.6375 | 5.3 | 5.1 | 6.375 | 3.825000000000001 | 2.8 | 1.4 | 1.4 | 0 | 0
7 | 0 | % Effective precip
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | MCM of effective ppt.
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Crop # | [NAME] this year | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb
8 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 15000 | 0.7500000000000001 | 1.125 | 1.125 | 1.3125 | 1.5 | 1.5 | 1.875 | 1.125 | 0.7500000000000001 | 0.3750000000000001 | 0.3750000000000001 | 0 | Total
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 35000 | 1.4 | 2.1 | 2.1 | 2.45 | 2.8 | 2.8 | 3.5 | 2.1 | 1.4 | 0.7 | 0.7 | 0 | 22.05
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 10000 | 0.5 | 0.75 | 0.75 | 0.875 | 1 | 0.8 | 1 | 0.6 | 0.4 | 0.2 | 0.2 | 0 | 7.075
9 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 | 0.125 | 0.125 | 0 | 0.5
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Deep perc. of [NAME], [NAME].
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0 | % Effective precip
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MCM of special agronomic requirements
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS: | 7.5 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Crop | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Total
14 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | ETfield, [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | % Effective precip |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Effective precip., [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Deep perc. of [NAME], [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Table 8   - Special agronomic requirements (mm) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42.5
Some crops have special irrigation requirements at a specific time of the year. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total by Month: | 7.5 | 0 | 0 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 77.5
For example, rice fields may need to be flooded prior to transplanting or planting.
Cotton fields may need to be "pre-irrigated" - that is, irrigated prior to planting.
These special requirements may require a much higher project irrigation water demand than what is expected if one just examines
 | evapotranspiration requirements.  However, they do NOT include any leaching requirements for salinity control.
**The units of the input values for Table 8 are millimeters.  They should represent the gross millimeters needed IN ADDITION TO
 | any ET requirements (minus effective rainfall).  These should be "gross" values at the field,
 | but should not include any conveyance losses that are necessary to transport the water to the field.
[NAME]. [NAME] for this year.  There may be no entries in this table, depending upon the crops and practices.
 |  |  |  |  | Special Needs, [NAME]. of Irrigation Water
 | Irrigated Crop Description | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb
1 | Paddy Rice #1 | 50
2 | Paddy Rice #2 |  |  |  | 100
3 | Paddy Rice #3
4 | Crop #4
5 | Crop #5
6 | 0
7 | 0
8 | 0
9 | 0
10 | 0
11 | 0
12 | 0
13 | 0
14 | 0
15 | 0
16 | 0
17 | 0
Table 9 - Crop Yields and Values
 | Exchange rate -  $US/(local currency) : | 0.25
 | Irrigated Crop Name | Typical yield, [NAME]/ha | Farmgate selling price, Local currency/ metric ton | hectares | Gross tonnage/yr | Value of agricultural production, $US/yr
1 | Paddy Rice #1 | 4 | 900 | 15000 | 60000 | 13500000
2 | Paddy Rice #2 | 4.5 | 820 | 35000 | 157500 | 32287500
3 | Paddy Rice #3 |  |  | 0 | 0 | 0
4 | Crop #4 | 1.5 | 1800 | 10000 | 15000 | 6750000
5 | Crop #5 | 2 | 2400 | 5000 | 10000 | 6000000
6 | 0 |  |  | 0 | 0 | 0
7 | 0 |  |  | 0 | 0 | 0
8 | 0 |  |  | 0 | 0 | 0
9 | 0 |  |  | 0 | 0 | 0
10 | 0 |  |  | 0 | 0 | 0
11 | 0 |  |  | 0 | 0 | 0
12 | 0 |  |  | 0 | 0 | 0
13 | 0 |  |  | 0 | 0 | 0
14 | 0 |  |  | 0 | 0 | 0
15 | 0 |  |  | 0 | 0 | 0
16 | 0 |  |  | 0 | 0 | 0
17 | 0 |  |  | 0 | 0 | 0
 |  |  |  |  | Total annual value ($US) | 58537500