Laserfiche WebLink
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.