Goal
Estimate the amount of annual evapotranspiration from Dry Creek Experimental Watershed (DCEW) and its subwatersheds using a water balance approach. Students will
- Calculate the effective depth of annual streamflow discharge
- Determine the annual depth of precipitation
- Calculate the annual depth of evapotranspiration
- Answer discussion questions, as assigned by instructor
Prior to completing the steps below, students should ensure that they understand the project by reading the information in the INTRODUCTION and BACKGROUND tabs.
This exercise can be completed for all watersheds within the DCEW. A watershed is defined as the area draining to one of the steam gauging stations (BS, TL, C1W, C1E, C2E, C2M, and LG). The following steps are written as a demonstration for the LG station draining the entire DCEW (27 km2) for the 2012 water year (Oct 1, 2011 – Sept 30, 2012).
Steps
1. Download and prepare the Excel Template.
a. Open the Site-Discharge tab.
i. Click cell C1. An scroll arrow should appear to the right of the cell. Select the Lower Gage site. You should see the title of plot change to Site: Lower Gage.
ii. Enter the year 2012 in cell B11.
iii. Reproduce cell a11-c18 in subsequent columns for additional water years if assigned by instructor.
b. Open the Site-precipitation tab and prepare the page as you did for streamflow.
2. Calculate the Total Annual Depth of Streamflow (Q)
a. Evaluate the water year 2012Â Â (Oct 1, 2011-Sep 30, 2012) streamflow data at the LG station that is provided in columns A and B of the of the Site-Discharge tab.
i. Inspect the streamflow data for missing values, denoted as -6999. Replace missing values with your best estimate of streamflow. A simple average of neighboring values will suffice for short durations.
ii. A hydrograph is automatically generated for WY 2012. Visually inspect the hydrograph for annual streamflow patterns. Discuss with colleagues, instructor, neighbors, or yourself anything of interest you might see. When is the peak? When is low flow?
b. For additional water years as assigned, obtain streamflow data for additional years of interest by one of the methods below as assigned by your instructor. Create hydograph plots for each water year similar to what is automatically done for 2012.
i. Download and compile calendar year data by browsing to Lower Gauge Data Access page. You will need to construct a time series for the water year from the two calendar year data sets. For example, to construct a 2013 water year dataset you will need to combine Oct 1-Dec 31st, 2012 with Jan 1- Sept 30, 2013 into a continuous record.
ii. Download the entire continuous dataset for the period of record Scholarworks (https://scholarworks.boisestate.edu/dcew_data/7/). You can extract the appropriate dates from the LG column.
iii. Use files provided by your instructor.
c. Calculate the streamflow volume (L) by determining the area under the hydrograph. View an example of how to perform this calculation. The general steps are
i. First calculate the volume of streamflow within each time step in Column C, beginning in the second timestep (cell c20).
ii. Second, in the calculation ‘red cells’, sum the values from step 1.b.i to obtain the Cumulative Annual Streamflow Volume (L)
d. Convert the volume of streamflow to depth (cm) (Cell C14).
e. Record your results in the appropriate cell in the “Answers” workbook tab.
3. Calculate the Total Annual Precipitation
Precipitation is strongly controlled by elevation in the DCEW (see Background). The value for P in equation 5 (Background) should be the elevation-weighted average over the entire watershed. The best way to obtain the elevation-weighted average is to complete the Spatial Average Precipitation exercise.  If your instructor does not assign the precipitation exercise, you can either use a direct average of several stations within the watershed or assume that the precipitation collected at the Treeline site approximates the average precipitation that falls over the entire DCEW. To complete this Watershed Water Balance exercise
a. Complete the Spatial Average Precipitation exercise, OR
b. Compute the average of 3 stations, OR
c. Use precipitation collected at the Treeline Site to represent the watershed average and follow the steps below
i. Obtain historical records of cumulative precipitation values for Treeline for water year 2012 (October 1, 2011-Sep 30, 2012). To build water year data from calendar year data you can compute the precipitation that fell from Oct 1, 2011 through December 31, 2011 and then add that amount to the total the fell from Jan 1, 2012 through Sep 30, 2012.
ii. Copy your precipitation water year data into the first column, ‘Date/Time’, and second column, ‘Cumulative Precipitation (mm)’, of the “Site-Precipitation” workbook tab. Make sure to update and rename the “Site-Precipitation” tab with the site name, as outlined in the worksheet procedures.
iii. A plot of cumulative precipitation is automatically generated for 2012. Create additional plots for other water years as assigned.
iv. Determine the total cumulative depth of precipitation for the year. Enter result in cell B12 and in the appropriate cells in the “Answers” workbook tab.
d. Repeat for additional years as assigned
4. Calculate the Total Annual Evapotranspiration
For each year and watershed in your analysis, use the annual streamflow and precipitation estimates from above to compute the variables below. Record your results in the “Answers” workbook tab:
- Annual evapotranspiration
- Ratios ET/P and Q/P
5. Questions/Problems
a. Describe the sources and potential magnitudes of error in the estimation of evapotranspiration by the water balance method?
b. Review the ET/P ratios that you computed. Explain what these ratios tell you about the dominant export of water from the landscape. How might these computations be different in a more humid and more arid environment?
c. Describe the climatological and geological factors that may determine the ratios ET/P and Q/P.
d. If you completed the exercise for multiple years, comment on the interannual variability of P, Q, ET, and the ratio ET/P and Q/P. Do they all vary the same?
e. Your water balance computations were over an annual time period. You can also perform similar calculations at shorter time periods, or for individual rain storms. Describe some complications that might arise for shorter time durations. Would you expect the ET/P and Q/P ratios for storm events to be similar to annual?
6. Products to hand in
Your instructor will specific instructions for what to turn in and how to do so. In general, expect to turn in
- Hard copy of ‘Summary of Results’ table(s) found in the “Answers” tab of the accompanying EXCEL workbook
- Answers to discussion questions as assigned by instructor.
- Digital copy of your completed excel workbook. Be sure to follow you instructor’s file naming conventions.