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).

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.