2/20/2020 1:13:18 PM
2/20/2020 8:05:44 AM
Rio Grande Groundwater Withdrawal Rules
Document Type - Rulemaking
RESPONSE FUNCTIONS HOW TO ADJUST THE APPLICATION WORKBOOK FOR USE WITH A SUBSET OF WELLS
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
All rights reserved.
Page 1 of 1
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
View plain text
Colorado Division of Water Resources 10/15/2015 <br /> <br />How to Adjust the Application Workbook for use with a Subset of Wells Page 1 <br />Adjusting the Application Workbook for use with a Subset (individual/group) of Wells <br />In order to properly use the ‘Ratio Method’ Application Workbooks for subsets of wells within a <br />Response Area, the rounding functions within the Workbook must be adjusted. The steps below <br />illustrate the adjustments needed to properly calculate the Net Stream Depletions for the <br />individual/group of wells. The Response Area and the reaches that need to be adjusted are: <br /> Alamosa-La Jara: Reach 1 Calculations Ratio, and Reach 6 Calculations Ratio, <br /> Conejos: Reach 1 Calculations Ratio, and Reach 6 Calculations Ratio, <br /> Saguache: Reach 1 Calculations Ratio, and Reach 3 Calculations Ratio , <br /> San Luis: Reach 1 Calculations Ratio, and Reach 2 Calculations Ratio, <br /> Trinchera: Reach 1 Calculations Ratio <br />Steps to Make the Adjustments <br />1. To avoid unintended errors use an original version of the Application Workbook built for the <br />Response Area <br />2. Go to sheet “Projected Depletions Annual” and remove the round functions within the cell <br />formulas <br />a. From the Cells "B43:G44" for Alamosa-La Jara, “B43;H44” for Conejos, “B43:D44” for <br />Saguache, “B43:C44” for San Luis, and “B43:E43” for Trinchera Response Area <br />b. From the column 'Total' ("L8:L44" for Alamosa-La Jara & Conejos, "F8:F44" for Saguache <br />& San Luis, and "G8:G44" for Trinchera Response Area <br />3. Go to “Table 2.5” <br />a. From Cells “D80:I82” for Alamosa-La Jara, “D80:J82” for Conejos, “D80:F82” for <br />Saguache, “D80:E82” for San Luis, and “D80:G82” for Trinchera <br />b. From the Column 12 or ‘Total’ (L9:I82 for Alamosa-La Jara & Conejos, “H9:H82” for <br />Saguache, “G9:G82” for San Luis, and “I9:I82’ for Trinchera Response Area <br />4. Go to sheet "Table 2.6" and remove the round functions within the cells formulas for the Cells <br />"B13:M13" and "N9:N13" <br />5. UNHIDE the appropriate sheet “Reach [X] Calculations Ratio” by right clicking over one of the <br />working tabs and selecting unhide to open the required sheet (“Reach [X] Calculations Ratio” ) <br />from the list <br />6. Go to sheet "Reach [X] Calculations Ratio" and COPY Cells "AC185:AG189" and PASTE to the <br />same location (“AC185:AG189’) as a VALUE instead of the formula <br />7. Go to “Net CU Worksheet” <br />a. Input the individuals/group of wells irrigation pumping, other pumping, and <br />consumptive use ratio value for the year 2011 - 2015 <br />b. For Details Refer: Notes-How to Use the Application Workbook With or Without SW <br />Credits, CDWR, September 23, 2015 <br />8. Go to sheet "Net CU & Streamflow" <br />a. Input the Historical Net Groundwater Consumptive Use (NetGWCU) from 1970-2010 to <br />the individuals/group of wells pumping (NetGWCU) values <br />b. For Details Refer: Notes-How to Use the Application Workbook With or Without SW <br />Credits, CDWR, September 23, 2015 <br />9. Reformat “Table 2.6” to one or two decimal digits to see the small decimal values <br />10. Finally, the net stream depletions caused by individual/group of wells are calculated on sheet <br />“Table 2.6” for the Current Year and on sheet “Table 2.7” for the Post Plan Years.
The URL can be used to link to this page
Your browser does not support the video tag.