How to Adjust the Application Workbook for use with a Subset of Wells Page 1
Adjusting the Application Workbook for use with a Subset (individual/group) of Wells
In order to properly use the ‘Ratio Method’ Application Workbooks for subsets of wells within a
Response Area, the rounding functions within the Workbook must be adjusted. The steps below
illustrate the adjustments needed to properly calculate the Net Stream Depletions for the
individual/group of wells. The Response Area and the reaches that need to be adjusted are:
 Alamosa-La Jara: Reach 1 Calculations Ratio, and Reach 6 Calculations Ratio,
 Conejos: Reach 1 Calculations Ratio, and Reach 6 Calculations Ratio,
 Saguache: Reach 1 Calculations Ratio, and Reach 3 Calculations Ratio ,
 San Luis: Reach 1 Calculations Ratio, and Reach 2 Calculations Ratio,
 Trinchera: Reach 1 Calculations Ratio
1. To avoid unintended errors use an original version of the Application Workbook built for the
Response Area
2. Go to sheet “Projected Depletions Annual” and remove the round functions within the cell
formulas
a. From the Cells "B43:G44" for Alamosa-La Jara, “B43;H44” for Conejos, “B43:D44” for
Saguache, “B43:C44” for San Luis, and “B43:E43” for Trinchera Response Area
b. From the column 'Total' ("L8:L44" for Alamosa-La Jara & Conejos, "F8:F44" for Saguache
& San Luis, and "G8:G44" for Trinchera Response Area
3. Go to “Table 2.5”
a. From Cells “D80:I82” for Alamosa-La Jara, “D80:J82” for Conejos, “D80:F82” for
Saguache, “D80:E82” for San Luis, and “D80:G82” for Trinchera
b. From the Column 12 or ‘Total’ (L9:I82 for Alamosa-La Jara & Conejos, “H9:H82” for
Saguache, “G9:G82” for San Luis, and “I9:I82’ for Trinchera Response Area
4. Go to sheet "Table 2.6" and remove the round functions within the cells formulas for the Cells
"B13:M13" and "N9:N13"
5. UNHIDE the appropriate sheet “Reach [X] Calculations Ratio” by right clicking over one of the
working tabs and selecting unhide to open the required sheet (“Reach [X] Calculations Ratio” )
from the list
6. Go to sheet "Reach [X] Calculations Ratio" and COPY Cells "AC185:AG189" and PASTE to the
same location (“AC185:AG189’) as a VALUE instead of the formula
7. Go to “Net CU Worksheet”
a. Input the individuals/group of wells irrigation pumping, other pumping, and
consumptive use ratio value for the year 2011 - 2015
b. For Details Refer: Notes-How to Use the Application Workbook With or Without SW
Credits, CDWR, September 23, 2015
8. Go to sheet "Net CU & Streamflow"
a. Input the Historical Net Groundwater Consumptive Use (NetGWCU) from 1970-2010 to
the individuals/group of wells pumping (NetGWCU) values
b. For Details Refer: Notes-How to Use the Application Workbook With or Without SW
Credits, CDWR, September 23, 2015
9. Reformat “Table 2.6” to one or two decimal digits to see the small decimal values
10. Finally, the net stream depletions caused by individual/group of wells are calculated on sheet
“Table 2.6” for the Current Year and on sheet “Table 2.7” for the Post Plan Years.