IntroductionGoals of this ExerciseComputer RequirementsUser Feedback on HydroExcelProcedureHydroExcel SpreadsheetsSelecting a Data SourceGetting a List of VariablesGetting a List of SitesGetting a Site CatalogGetting a Time SeriesSummarizing Daily Time Series by Months and YearsDescriptive Statistics in ExcelHistograms in ExcelTo be turned in:CE 397 Statistics in Water ResourcesExercise 1Exploring Time Series Data with HydroExcelBy: Stephanie Johnson, Tim Whiteaker, David MaidmentCenter for Research in Water ResourcesUniversity of Texas at AustinJanuary 2009ContentsIntroduction................................................................................................................................................. 2Goals of this Exercise...............................................................................................................................2Computer Requirements.........................................................................................................................2User Feedback on HydroExcel..................................................................................................................2Procedure....................................................................................................................................................3HydroExcel Spreadsheets.........................................................................................................................3Selecting a Data Source...........................................................................................................................4Getting a List of Variables........................................................................................................................5Getting a List of Sites...............................................................................................................................6Getting a Site Catalog..............................................................................................................................9Getting a Time Series.............................................................................................................................12Summarizing Daily Time Series by Months and Years............................................................................13Descriptive Statistics in Excel.................................................................................................................18Histograms in Excel................................................................................................................................23To be turned in:.........................................................................................................................................241IntroductionIn this exercise we’re going to explore some examples of temporal and spatial variation in hydrologic variables. To do our exploration, we will use some tools developed by the Consortium of Universities for the Advancement of Hydrologic Science Inc. (CUAHSI) to explore mean daily streamflows at various sites across the nation. Streamflow is an excellent example of how variables vary in time and space and it is one of the most common hydrologic variables to explore.Goals of this ExerciseThe goals of this exercise are to explore temporal variations in mean daily stream discharge using HydroExcel. These daily mean values are archived and available through the National Water Information System (NWIS); they can be downloaded online at http://waterdata.usgs.gov/nwis/dv/?referred_module=sw. They can also be obtained using CUASHI web services through HydroExcel.Computer RequirementsTo perform this exercise you will need a computer with the Windows operating system, a live internet connection, Microsoft Excel 2007, and Google Earth (download and install it here: http://earth.google.com/). We will be using HydroExcel, developed by CUAHSI researchers to adapt Microsoft Excel for CUAHSI web services input, serving data both from national data providers and universities. The spreadsheet uses VBA macros and an object library called HydroObjects http://his.cuahsi.org/hydroobjects.html to communicate with and retrieve data from WaterOneFlow web services. The latest version of HydroExcel available online is at http://his.cuahsi.org/hydroexcel.html. It is Version 1.1. We will be using HydroExcel Version 1.1.1 which is contained in the file HydroExcel-Jan09.xlsb, which is accessible as a zip file at HydroExcel-Jan09.zip, which uses the same version of HydroObjects as Version 1.1 If you’d like to download HydroExcel and install it on your personal computer, you can do so. Otherwise, the tool has already been installed on the computers in the Civil Engineering Learning Resource Center (LRC) on the 3rd floor of ECJ. If you choose to install HydroExcel onyour personal computer you first need to install the object library, HydroObjects. HydroObjects is available at http://his.cuahsi.org/hydroobjects.html ; simply run the .exe file and follow the installation procedure. (HydroObjects is already installed and enabled on the computers in the LRC). User Feedback on HydroExcelWe would like feedback on user improvements that could be made to HydroExcel. If you have problems using this tool or see places where it could be improved, please note them as you do this exercise and then respond at the end to the following questions:2(1) Installation – were you able to install the tool correctly?(2) Errors – Did you encounter any errors? Is the error reproducible? If so, please list the steps so that the developers can recreate the error.(3) User Interface – Is the user interface intuitive? Are buttons labeled appropriately? Is it clear where to input the parameters for each worksheet?(4) Explanatory Text – Is the text on the left side of each worksheet useful? There's a lot of text there. Can it be trimmed down? Should more be added to it?(5) Operability – Is the spreadsheet responsive? When things happen, do you get an appropriate message box or status message?(6) Distractions – List up to three things that annoy you about the spreadsheet. If it annoys you, how could it do those things differently so as not to annoy you?(7) Capabilities – List up to three things that you wish the spreadsheet did that it does not currently do.Procedure HydroExcel SpreadsheetsOpen HydroExcel from the file HydroExcel-Jan09.xlsb. HydroExcel