Geog 427/527:  Fluvial Geomorphology
Winter 1999, University of Oregon

[Geog 4/527] [Syllabus] [Study Guides] [Exercises] [Grad Requirements] [Links] [Field course]

Exercise 1

Due Dates:  Your annual hydrograph for Part B is due in class on Thursday, Jan. 14.  Your completed Exercise 1, with written answers and computer work, is due in class on Tuesday, Jan. 19. 

Problems with the data for Part B: 
1.  The station number for Grande Ronde at Troy was incorrect on the sign-up sheet.  Go to the sign-up list below to get the correct number. 
2.  The gaging station for the N. Fk Alsea R. at Alsea was discontinued after water year 1989, so there are no data for WY 1990.  Use WY 1989 instead of WY 1990. 
3.  If you can't locate your data on the USGS web site, e-mail Suzanne or me.

Tips on accessing the data files: 
    If you are using the latest version of MS Internet Explorer (i.e. 4.0), and you have Excel 97 installed on your computer, you should be able to use the Excel file version.  Click on the link below, and it should open Excel and bring the file up as an Excel spreadsheet.  If you are using an earlier version of Internet Explorer or Excel, this may not work.  If you are using another web browser and/or another spreadsheet, it probably won't work. In this case, use the text file version.  
    Here's how to get the text file version into your spreadsheet.   (There may be other ways, but this worked for me.)  Open it by clicking, select all the rows containing the numbers (for easiest translation, don't select the text or column headings), and then copy it using the Edit-Copy command.  (All this is done in your web browser.)  Then go to your spreadsheet program, open it, and paste it into a new spreasheet.  In Excel, I do this using Edit - Paste, or Edit - Paste Special  - Text (or Unicode Text).  The data appear in the spreadsheet in multiple rows but all in one column.  To get the data separated into columns correctly, use the command Data - Text to Columns in Excel.  In other spreadsheet programs, there is probably an equivalent command.  In older versions of Excel this command used to called Data - Parse.  Excel's Data - Text to Columns command will allow you to place boundaries between the columns.  When you have the columns looking the way they should, save the spreadsheet file.  Then go back to the web and make sure you know which column contains the mid-point, which contains velocity, etc.   Edit these labels in your spreadsheet file. 

[Geog 4/527] [Syllabus] [Study Guides] [Exercises] [Grad Requirements] [Links] [Field course]

last update:  03/25/00 11:05 AM
Department of Geography, University of Oregon, Eugene OR, 97403-1251