2019 Excel for Hydrology
Hosted During the 2019 June Well & Water Week
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.
June 11, 2019
8:00 a.m. - 5:00 p.m.
5650 Riggins Court
Reno, NV 89502
Registration by May 31, 2019:
$100 NWRA Member
Registration after May 31, 2019:
$150 NWRA Member