DWR_3579066

• Rule Name: Rio Grande Groundwater Withdrawal Rules
• Document Type - Rulemaking: Supporting Documents
• Subject: RESPONSE FUNCTIONS HOW TO USE THE APPLICATION WORKBOOK WITH OR WITHOUT SW CREDITS
• Date Effective: 9/23/2015

Colorado Division of Water Resources 09/23/2015

Notes How to Use the Application Workbook for a Subset (individual/group) of Wells Page 2

2. On the “Net CU & Streamflow” worksheet change the historical Net Groundwater
Consumptive Use (Jan-Dec) (Column 12) from 1970 to 2010 to the historical Net Groundwater
Consumptive Use estimated for the individual/group of well(s) (consumptive use ratios of 83%
- sprinkler, 60% - flood, appropriate ratio – other for wells that do not generate returns
directly to streams, and 100% - other for wells that do generate returns directly to streams).
3. On the “Reach [X] Calculations” worksheet, which will need to be unhidden, change the
Surface Water Return Flow Credits in cells H161:H653 to the estimated individual/group of
well(s)’s Surface Water Return Flow Credits.
b. Note “X” refers to the stream reach number where the Surface Water Return Flow
Credits are applied.
4. Finally, the net stream depletions caused by individual/group of well(s) using Surface Water
Return Flow Credits are calculated on sheet “Table 2.6” for the Plan Year and on sheet “Table
2.7” for the Post Plan.

2. Stream Reaches without Surface Water Return Flow Credits

If the individual/group of well(s) is to be evaluated using the Application Workbook to estimate their net
stream depletions, the following steps should be completed:
1. Modify the worksheet “Net CU Worksheet” as follows:
a. Columns 2 & 3 change values to individual/group of well(s) Irrigation Pumping.
b. Column 4 change the values to the value of individual/group of well(s) Other Pumping.
c. If the individual/group of well(s) does not generate return flows directly to the stream,
then:
i. Column 5 change to the appropriate consumptive use ratio for each year based
on Other Pumping’s actual consumptive use ratios.
d. If the individual/group of well(s) does generate return flows directly to the stream,
then:
i. Column 5 change to the appropriate consumptive use ratio for each year based
on Other Pumping’s actual consumptive use ratios for wells that do not
generate returns directly to streams and 100% consumptive use ratio for wells
that do generate returns directly to streams.
2. On the “Net CU & Streamflow” worksheet change the historical Net Groundwater
Consumptive Use (Jan-Dec) (Column 12) from 1970 to 2010 to the historical Net Groundwater
Consumptive Use estimated for the individual/group of well(s) (consumptive use ratios of 83%
- sprinkler, 60% - flood, appropriate ratio – other for wells that do not generate returns
directly to streams, and 100% - other for wells that do generate returns directly to streams).
3. Finally, the net stream depletions caused by individual/group of well(s) are calculated on
sheet “Table 2.6” for the Plan Year and sheet “Table 2.7” for the Post Plan.