2019 Excel for Hydrology

Hosted During the 2019 June Well & Water Week  

 
 

2019 June Well & Water Week
Sponsorship & Exhibitor Opportunities

Mail-in Sponsorship/Exhibitor Form Online Sponsorship/Exhibitorship         

 

 Instructors:
 Keith Halford, Halford Hydrology LLC (Retired USGS) 

Tracie Jackson, Hydrogeologist, U.S. Geological Survey

 Miscellaneous:
Participants need a laptop with Microsoft Excel installed, to include the Solver add-in.

Excel for Hydrology

Hydrologic analysis requires data, but data rarely arrives in an analyzable form. Mismatches between available and required data range from, “Well, a few tweaks…” to “What the hell is this...” The many functions and features of Microsoft Excel are well suited to eliminating these mismatches, including the latter category.

A 1-day, Excel-for-Hydrology class will introduce functions and features for wrangling disparate data sets into analyzable forms. Essential features of Excel such as conditional formatting, data validation, text to columns, remove duplicates, pivot tables, and more will be introduced. Translating 3-column data in the form of [site name, time, value] as comes from databases into individual time series by site name using MATCH and OFFSET functions, which are more versatile than a VLOOKUP function. The Solver add-in will be explained and applied with two examples, a stage-velocity index relation and superimposed Theis functions. Shading areas in XY plots with INT and MOD functions will be demonstrated along with other approaches for drawing what you want to see. Manipulating text with LEFT, MID, RIGHT, and FIND functions and formatting numbers in text strings with TEXT function will be addressed. These approaches are especially useful for exploring new data sets or reviewing reported data, where repeated analysis is less likely than during an ongoing project.

Introduced functions and features will be applied to build a hydrograph viewer, similar to PEST-HYDROS. Class attendees will participate. We will all reduce data, utilize feature, apply functions, and draw pictures together. Participants are encouraged to bring their bad data for wrangling as a class exercise. 


2019 June Well & Water Week Exhibitors

Boart Longyear

Silver Level Sponsor

Boart Logo.jpg

Cancellation Policy: All cancellations must be received in writing and sent to NWRA via fax to 775-473-5473, mailed to P.O. Box 8064, Reno, NV 89507, or e-mailed to nevadawaterresources@gmail.com.  Cancellations received within 7 days of the start of the event will not be refunded, however substitutions are welcome.  All other cancellation requests will receive a refund minus a 25% administrative fee.  If you have purchased the registration with a credit card, the convenience fee is non-refundable.


Date:
Tuesday
June 11, 2019

Time:
8:00 a.m. - 5:00 p.m.

Location:
5650 Riggins Court
Reno, NV 89502

Registration by May 31, 2019:
$100 NWRA Member
$150 Non-Member

Registration after May 31, 2019:
$150 NWRA Member
$200 Non-Member

Student Registration:
$20


JOIN OR RENEW YOUR NWRA MEMBERSHIP TO SAVE MONEY ON EVENTS

JOIN OR RENEW YOUR NWRA MEMBERSHIP TO SAVE MONEY ON EVENTS