Laserfiche WebLink
Colorado Division of Water Resources 09/23/2015 <br /> <br />Notes How to Use the Application Workbook for a Subset (individual/group) of Wells Page 2 <br /> <br />2. On the “Net CU & Streamflow” worksheet change the historical Net Groundwater <br />Consumptive Use (Jan-Dec) (Column 12) from 1970 to 2010 to the historical Net Groundwater <br />Consumptive Use estimated for the individual/group of well(s) (consumptive use ratios of 83% <br />- sprinkler, 60% - flood, appropriate ratio – other for wells that do not generate returns <br />directly to streams, and 100% - other for wells that do generate returns directly to streams). <br />3. On the “Reach [X] Calculations” worksheet, which will need to be unhidden, change the <br />Surface Water Return Flow Credits in cells H161:H653 to the estimated individual/group of <br />well(s)’s Surface Water Return Flow Credits. <br />b. Note “X” refers to the stream reach number where the Surface Water Return Flow <br />Credits are applied. <br />4. Finally, the net stream depletions caused by individual/group of well(s) using Surface Water <br />Return Flow Credits are calculated on sheet “Table 2.6” for the Plan Year and on sheet “Table <br />2.7” for the Post Plan. <br /> <br /> <br /> <br />2. Stream Reaches without Surface Water Return Flow Credits <br /> <br />If the individual/group of well(s) is to be evaluated using the Application Workbook to estimate their net <br />stream depletions, the following steps should be completed: <br />1. Modify the worksheet “Net CU Worksheet” as follows: <br />a. Columns 2 & 3 change values to individual/group of well(s) Irrigation Pumping. <br />b. Column 4 change the values to the value of individual/group of well(s) Other Pumping. <br />c. If the individual/group of well(s) does not generate return flows directly to the stream, <br />then: <br />i. Column 5 change to the appropriate consumptive use ratio for each year based <br />on Other Pumping’s actual consumptive use ratios. <br />d. If the individual/group of well(s) does generate return flows directly to the stream, <br />then: <br />i. Column 5 change to the appropriate consumptive use ratio for each year based <br />on Other Pumping’s actual consumptive use ratios for wells that do not <br />generate returns directly to streams and 100% consumptive use ratio for wells <br />that do generate returns directly to streams. <br />2. On the “Net CU & Streamflow” worksheet change the historical Net Groundwater <br />Consumptive Use (Jan-Dec) (Column 12) from 1970 to 2010 to the historical Net Groundwater <br />Consumptive Use estimated for the individual/group of well(s) (consumptive use ratios of 83% <br />- sprinkler, 60% - flood, appropriate ratio – other for wells that do not generate returns <br />directly to streams, and 100% - other for wells that do generate returns directly to streams). <br />3. Finally, the net stream depletions caused by individual/group of well(s) are calculated on <br />sheet “Table 2.6” for the Plan Year and sheet “Table 2.7” for the Post Plan. <br /> <br /> <br /> <br />