SeriesSEE Workshop

Time Series Analysis & Water-Level Modeling with SeriesSEE: An Excel Add-IN  


Keith Halford


About the Workshop

Time Series Analysis & Water-Level Modeling with SeriesSEE: An Excel Add-IN  
Small pumping signals can be detected reliably with water-level modeling as implemented in SeriesSEE.  For example, drawdowns of less than 0.05 ft are detected routinely beneath Pahute Mesa, Nevada where environmental, barometric and tidal, fluctuations exceed 0.5 ft.  Water-level models simulate environmental water-level fluctuations and pumping effects. Environmental water-level fluctuations are simulated by summing individual time-series of barometric pressure, tidal potential, and background water levels. Water levels from background wells, unaffected by pumping, are critical because they are affected by tidal potential–rock interaction, imperfect barometric coupling, seasonal trends, and climatic trends.  Pumping schedules are transformed to water-level responses with superposition Theis models. Numerical experiments have confirmed that these Theis transforms closely approximate water-level responses through hydrogeologically complex aquifers.   SeriesSEE is an Excel Add-In for viewing, cleaning, and analyzing time series or geophysical logs. Bad data in series can be identified and removed either conditionally or graphically. Series can be added, subtracted, multiplied, or divided even where measurement frequencies are irregular, different, and asynchronous. Many other tools exist in SeriesSEE that facilitate rapid data reduction and the creation of water-level models.  Water-level models are created interactively with SeriesSEE in a new workbook.  Synthetic water levels are simulated with a FORTRAN program where differences between synthetic and measured water levels are minimized with PEST.  Model fit is defined by RMS error and evaluated graphically.  Estimated drawdowns are the summation of all Theis transforms and differences between synthetic and measured water levels.   The methodology and supporting software in SeriesSEE is documented in publically available articles and reports. The validity of simulating pumping signals in geologically complex environments was demonstrated clearly in the article, “Detecting Drawdowns Masked by Environmental Stresses with WaterLevel Models,” The software SeriesSEE has been documented, validated, and distributed through a USGS Techniques and Methods report, SeriesSEE is public domain software that can be adapted and used freely.


Contact Hours Available / CEU approval for attendees

Seating is limited, so we advise you to register early


March 1, 2017

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

Desert Research Institute
Rogers Auditorium
755 East Flamingo Road
Las Vegas, NV 89119

Registration by
February 15, 2017:
NWRA Members $150
Non-Members $200
Students $20

Registration after
February 15, 2017:

NWRA Members $200
Non-Members $250
Students $25


Header photo by LEO DROZDOFF, Director, Nevada Department of Conservation and Natural Resources