Laserfiche WebLink
Document management portal powered by Laserfiche WebLink 9 © 1998-2015 Laserfiche. All rights reserved.
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 1 <br /> <br />How to Use the Application Workbook for a Subset (individual/group) of Wells <br /> <br />The Application Workbook is build to be used for the whole Response Area. If there is a need to use it <br />for individual/group of well(s) either with or without Surface Water Return flow Credits, there are few <br />steps that need to be followed. <br /> <br />1. Stream Reaches With Surface Water Return Flow Credits <br /> <br />The five reaches with Surface Water Return Flow Credits are: <br /> Rio Grande Alluvium Response Area - Reach 1 (Rio Grande from Del Norte to Excelsior Ditch) <br />from the Town of Del Norte and the City of Monte Vista, <br /> Alamosa/La Jara Response Area - Reach 3 (Rio Grande from Del Norte to Excelsior Ditch) from <br />the City of Monte Vista, <br /> Alamosa/La Jara Response Area - Reach 5 (Rio Grande from Chicago to State Line) from the City <br />of Alamosa, <br /> Conejos Response Area - Reach 7 (San Antonio River) from the Town of Antonito. <br /> San Luis Creek Response Area - Reach 2 (Crestone Creek) from the Town of Crestone and the <br />Baca Water and Sanitation District. <br /> <br />If the individual/group of well(s) does not have Surface Water Return Flow Credits but is located in the <br />Response Area where Surface Water Return Flow Credits exist, 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. Column 5 change to the appropriate consumptive use ratio for each year based on <br />Other Pumping’s actual consumptive use ratios. <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, and appropriate ratio – other). <br />3. On the “Reach [X] Calculations” worksheet, which will need to be unhidden, ZERO out all of <br />the Surface Water Return Flow Credits in cells H161:H653. <br />a. 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) are calculated on <br />sheet “Table 2.6” for the Plan Year and sheet “Table 2.7” for the Post Plan. <br /> <br />If the individual/group of well(s) does have Surface Water Return Flow Credits the following steps <br />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. Column 5 change to the appropriate consumptive use ratio for each year based on <br />Other Pumping’s actual consumptive use ratios for wells that do not generate returns <br />directly to streams and 100% consumptive use ratio for wells that do generate returns <br />directly to streams. <br />