DIRECTORY\FILE SUMMARY IMAGE
AlternativeCoordinates\
3D_VectorViewer.xls
Projects 3-D XYZ vectors to a 2-D chart.  Example maps channels in the Tracy Segment, NV. 
AlternativeCoordinates\
ellipse.xls
Visualizes direction dependent anisotropy ellipse as implemented in SUTRA.
AlternativeCoordinates\
SpinObs_FixEllipse.XLS
Estimates lateral anisotropy and orientation of the transmissivity ellipse with MODFLOW by rotating positions of observation wells about the production well.  Rotation and projection to a quarter-model are demonstrated.
AlternativeCoordinates\
X-section_AREA.xls
Interpolates a regularly spaced data set from irregular data so areas can be depicted.
AnalyticalAQfunc_DLL\
LeakyAnalysis_Fcall.xls
Solved with an external DLL -- Estimates aquifer storage and vertical hydraulic conductivity and specific storage of adjacent confining units with a leaky-aquifer solution that also provides another estimate of transmissivity (Moench, 1985). 
AnalyticalAQfunc_DLL\
LeakyAnalysis_VB.xls
Solved with internal VBA macros -- Estimates aquifer storage and vertical hydraulic conductivity and specific storage of adjacent confining units with a leaky-aquifer solution that also provides another estimate of transmissivity (Moench, 1985). 
AnalyticalAQfunc_DLL\
Slug_Cooper-Greene_Fcall.xls
Cooper-Greene solution solved with an external DLL -- LOOKUP version is documented in; Halford, K.J. and Kunianksy, E.L., 2002, Documentation of Spreadsheets for the Analysis of Aquifer Pumping and Slug Test Data: USGS OFR 02-197.
AnalyticalAQfunc_DLL\
UnconAnalysis_Fcall.xls
Moench solution for an unconfined aquifer that is solved with an external DLL.  BARLOW, P.M. and ALLEN F. MOENCH, 1999, WTAQ—A Computer Program for Calculating Drawdowns and Estimating Hydraulic Properties for Confined and Water-Table Aquifers, USGS WRIR 99-4225
AQtest_WorkBooks_OFR-02-197\
Confined_Predict.xls
Predicts drawdown response of a single pumping well in a Theis aquifer. 
AQtest_WorkBooks_OFR-02-197\
Flowing_Jacob-Lohman.xls
Estimates hydarulic properties of flowing artesian wells using the method of Jacob and Lohman, 1952. For application of this method, a flowing well is capped or has an above ground stand pipe for measuring the initial water level or pressure head.  It is then allowed to flow.  The outlet elevation is a constant head and the discharge gradually decreases.
AQtest_WorkBooks_OFR-02-197\
Pumping_Cooper-Jacob.xls
Estimates hydraulic properties using the Cooper-Jacob method (Cooper and Jacob, 1946), commonly referred to as the straight-line method. The method is a simplification of the Theis (1935) solution for flow to a fully penetrating well in a confined aquifer. The method may be used to analyze data from a single pumping well.
AQtest_WorkBooks_OFR-02-197\
Pumping_Cooper-Jacob_RECOVERY.xls
Estimates hydraulic properties using the theory of superposition in that the water-level rise after the test is assumed to be the combined response to an imaginary well recharging the aquifer and continued pumping.  Imaginary recharge occurs at an identical rate to the constant discharge during the pumping test.
AQtest_WorkBooks_OFR-02-197\
Pumping_Cooper-Jacob_wEfficiency.xls
Estimates efficiency by assigning a storage coefficient and estimates theoretical drawdown with Theis solution assuming observations are from pumping well.
AQtest_WorkBooks_OFR-02-197\
Pumping_DistanceDrawdown.xls
Estimates hydraulic properties using distance-drawdown methods. These methods can be used for multi-well aquifer-test data once the drawdown has reached quasi-steady-state.
AQtest_WorkBooks_OFR-02-197\
Pumping_Hantush-Jacob_LeakyAquifer.xls
Estimates hydraulic properties based on the equation for drawdown of a well pumped at a constant discharge rate in a leaky aquifer (Hantush and Jacob, 1955). During  early time of pumpage, water comes out of storage from the pumped aquifer and the leaky confining unit.  Eventually, discharge comes into equilibrium with leakage through the confining unit from the unstressed aquifer and the system is at steady-state. 
AQtest_WorkBooks_OFR-02-197\
Pumping_StepDrawdown.xls
Estimates transmissivity from step-drawdown test data. A step-drawdown test is a single-well test that frequently is conducted after well development to determine the correct sizing of the production pump and the efficiency of the well. Thus, these data are more common than multi-well aquifer-test data, but not as common as specific-capacity data.
AQtest_WorkBooks_OFR-02-197\
Slug_Bouwer-Rice.xls
Estimates aquifer hydraulic conductivity of near the well screen using the Bouwer and Rice (1976) method. The method is based on the Thiem (1906) analytical solution and was originally designed for the analysis of data from wells in unconfined aquifers.  However, the method also may be used to analyze data from confined aquifers. If the water table is within the well screen only the rising head test should be analyzed. 
AQtest_WorkBooks_OFR-02-197\
Slug_Bouwer-Rice_EuroExample.xls
METRIC EXAMPLE --Estimates aquifer hydraulic conductivity of near the well screen using the Bouwer and Rice (1976) method. The method is based on the Thiem (1906) analytical solution and was originally designed for the analysis of data from wells in unconfined aquifers. 
AQtest_WorkBooks_OFR-02-197\
Slug_Cooper-Greene.xls
Analyzes ordinary slug tests using the Cooper, Bredehoeft, and Papadopulos (1967) method and incorporates the Greene and Shapiro (1995) extension to analyze very low permeability material where the introduced slug does not reach equilibrium before being removed.
AQtest_WorkBooks_OFR-02-197\
Slug_KGS-HighK_BB426data.xls
Complete workbook of slug-test analyses.  Raw time-water level series are entered with mutiple slugs from a single well.  Slug periods are identified and selected, normalized responses are plotted en masse. Slug test responses are analyzed with KGS solution which ranges from underdamped to overdamped conditions.     
AQtest_WorkBooks_OFR-02-197\
Slug_van-der-Kamp.xls
Estimates hydraulic conductivity from slug-test data using the van der Kamp (1976) method. This method was developed for the analysis of slug-test data from highly transmissive aquifers, as evidenced by oscillatory water-level response to a slug displacement.  When slug tests are performed in high hydraulic conductivity materials or in wells with a very long water column above the screen or open interval, the water level response frequently oscillates rapidly.
AQtest_WorkBooks_OFR-02-197\
Trend-Analysis_Probability-Log.xls
Log-transforms data and plots transformed data on a probability scale. Can also esimate mean and standard deviation of log-transformed data even if some values are censored.
AquiferTestTools\
AnisotropyTheisBoundary.xls
Test uniqueness of lateral anisotropy estimates.
AquiferTestTools\
DD+Sensitivity_Viewer.xls
Creates hydrographs from MODOPTIM output for comparing simulated and measured drawdowns. Weighted-sensitivities for all observations are viewed by parameter in a single chart.  New estimates of drawdowns, parameters, and sensitivities are loaded from a single button.
AquiferTestTools\
ER-5-4_LateralAnisotropy.xls
Shows effects of lateral anisotropy on drawdown and apparent well positions.
AquiferTestTools\
ER-5-4_NoFlowPlaya.xls
Shows effects of an impervious boundary on drawdown.
AquiferTestTools\
LeakyAnalysis.xls
Estimates aquifer storage and vertical hydraulic conductivity and specific storage of adjacent confining units with a leaky-aquifer solution that also provides another estimate of transmissivity (Moench, 1985). 
AquiferTestTools\
LeakyRecovery.xls
Analysis of an aquifer test with a truncated data set.  Superposition with the Moench leaky aquifer solution simulates the recovery curve.  Solver is used to estimate Log(T), Log(S), and an offset of the drawdown data on the Y-axis.
AquiferTestTools\
QuickSite.xls
Allows digitizing of well locations from a bitmap or JPEG.
AquiferTestTools\
ROMP09_Well-Geology-Analytical-MODOPTIM_SUMMARY.XLS
Creates MODOPTIM input sets for analyzing drawdown estimates from multiple aquifer tests with a single numerical model that extends from land surface to the base of a geohydrologic column.  View well construction as collapsed on radial cross-section of geohydrology for each aquifer test. See poster GeohydrologicColumns_AGWSE2003.pdf.
AquiferTestTools\
TheisDistance.xls
Experiment with radius of influence of a single well that is simulated with a Theis solution.
AquiferTestTools\
TheisRecovery.xls
Analysis of an aquifer test with a truncated data set.  Superposition with the Theis solution simulates the recovery curve.  Solver is used to estimate Log(T), Log(S), and an offset of the drawdown data on the Y-axis.
AquiferTestTools\
TheisStream.xls
Analysis of an aquifer test near a "fully penetrating" stream.  Pumping well and imaginary injection well simuilated with Theis solution.  Solver is used to estimate Log(T), Log(S), and a offset of the Y-coordinate that defines a line-segment of the Truckee River.  
AquiferTestTools\
TimeSeries+DD.V0.2\
NV_WLsource.xls
Example data set from southern Nevada for the TimeSeries+Drawdown.RV0.2.xls workbook.
AquiferTestTools\
TimeSeries+DD.V0.2\
TimeSeries+Drawdown.RV0.2.xls
Workbook has been developed for analyzing time series with an emphasis on estimating drawdowns during aquifer tests by removing extraneous water-level changes at observation wells resulting from barometric pressure changes, gravity tides, earth tides or regional pumping. 
BoreholeLogging\
CompositeTidBits\
ue_1q_R+S_TemperatureLogger.xls
Borehole temperature logging on the cheap.
Class_N_Management\
CalendarADMIN.xls
Create a calendar with repeated sign-out labels in all days.
Class_N_Management\
Defining-VCON-with-thickness_Erroneous-Where-THIN.xls
Problems with defining VCON from the inverse thickness of a thin, smoothed surface.  Marked differences in leakance estimates from smoothed thickness and parallel flow through discrete features exist where confining unit can be absent.  
Class_N_Management\
OUTLINE_GWfieldTech-SacramentoCA2003.xls
Tracks list of course times, instructors, and notes.  Ensures times do not overlap and easily creates course schedule.
Class_N_Management\
PrintOrSummarize_CollectionOfSheets.xls
Print or collect static summary of a particular sheet from many workbooks.
Class_N_Management\
Sounds-N-Links_FlowChart.V3.xls
Demonstrates accessing sounds from internal WAV files.  File also uses Workbook_Open() subroutine which is in the ThisWorkbook object.  The Workbook_Open() subroutine can be ignored by holding ALT+SHIFT upon opening a file.
Class_N_Management\
SUMMARIZE_Listing_and_Description.xls
Scans directory and subdirectories for a specified file extension,  lists paths and files, creates hyperlink to each file, and formats labels. File descriptions also are pushed into file comment section.   
Filtering_N_Subtotals\
Average_with_Indirects.xls
Averagea subintervals dynamically with INDIRECT references.  This approach is best for repeated analyses.  Other statistics such as SUM, MAX, MIN, STandard DEViation also can be applied to subintervals.
Filtering_N_Subtotals\
MismatchedData+Averaging.xls
Data sampled at 1 minute and 10 minute intervals are averaged to common intervals.  Intervals of 10m, 20m, 30m, 1hr, 2hr, 4hr, 8hr, 12hr, & 24hr can be tested. MATCH and OFFSET functions used for testing regression of water level, temperature, discharge, and specific conductance. 
Filtering_N_Subtotals\
Reduce-with-Subtotals.xls
Reduces data in subintervals, such as daily values, with the Subtotal Tool in Excel.  This approach is easier to apply and very useful for a quick analysis that is not likely to be repeated.  Intermediate values can be eliminated by copying the reduced data set into an ASCII text editor and then copying those value back to a spreadsheet.
Filtering_N_Subtotals\
TidalSignal&DailyValues.xls
Investigates difference between averaging ideal spring discharge and averaging tidally affected discharge over 21 to 30 hour periods.
Functions_N_Modules\
BiLinear-Interpolator.xls
Interpolates bi-linearly from a single table.  Interpolation values are specified in the uppermost row and leftmost column of the look-up table.
Functions_N_Modules\
EarthTideFunction.xls
Computes theoretical earthtide as a function of latitude, longitude, altitude, date, and time.  Adapted from FORTRAN routine -- Harrison, J.C., 1971, New computer programs for the calculation of Earth tides: National Oceanic and Atmospheric Administration/University of Colorado, Cooperative Institute for Research in Environmental Sciences, 30 p.
Functions_N_Modules\
LeakyFracture_WellFunctions.xls
Presents multiple functions for the computation of dual-porosity and leaky aquifer well functions.  Other functions for computing drawdowns directly from discharge, hydraulic conductivities, specific storages, and time.  Adapted from FORTRAN routine DP_LAQ -- Moench, A.F., 1985, TRANSIENT FLOW TO A LARGE-DIAMETER WELL ...,WRR 21(8), P.1121-1131 and Moench, A.F., 1984, DOUBLE-POROSITY MODELS FOR A FISSURED GW...., WRR 20(7).
Functions_N_Modules\
PolygonBuffer.xls
Computes buffer polygon around a given polygon.  Will not behave well for large buffers around a highly irregular polygon.  INOUT function determines if a point, XY pair, is inside of a polygon.  Functions for computing area and perimeter of polygons are in workbook. 
Functions_N_Modules\
SigFigTABLE.xls
Convert values to text strings in scientific notation.  Also converts text strings in scientific notation to values.
Functions_N_Modules\
SignificantFigures.xls
Rounds positive or negative values to a specified number of significant figures using a function. Can optionally add another significant figure to values between 1 and 2.
Functions_N_Modules\
Theis_WellFunction.xls
Calculates Theis well function and Theis drawdown using two separate functions.  Algorithm from Bruce Hunt is better, http://www.civil.canterbury.ac.nz/staff/bhunt.asp. 
Functions_N_Modules\
UseMultiCellRange-in-function.xls
Finds the minimum value in a range while a condition is met in a parallel range using the function MINIconditional. In this example, a minimum is reported for a single SITEID, not the entire range.  MAXconditional is similar to MINconditional except a maximum is returned. 
Functions_N_Modules\
USGS_Date-TimeFunction.xls
All times in Excel are in decimal days but can be formatted to appear in many ways.  Converts various date-time formats to decimal days. The application includes a generic function for converting odd time formats such as yyyymmdd hhmmss to mm/dd/yy hr:mm (20011031 093023  to 10/31/01 09:30).
Functions_N_Modules\
UTM_Conversion_Functions.xls
Presents multiple functions for converting UTM to latitude/longitude and latitude/longitude to UTM.  Accepts latitude/longitude as decimal degrees or in USGS units.  For example, 390000 is the number three-hundred ninety thousand to most, but 39 degrees, 0 minutes, and 0 seconds in USGS output.
HydrographViewer_MF2K\
HydrographViewer.HA-Sens.xls
Loads observation locations, MODFLOW2000 output, and HYDMOD files from a single button.  View hydrographs of simulated and measured water level observations with simulated results from all layers and stress periods on the same figure.  Scatter plots of measured and simulated water levels depict error pattern for each well.  Map shows binary patterns of residuals above or below a user-specified threshold during user-specified periods.
HydrographViewer_MF2K\
Pumpage-by-AutoFilter.xls
Plots bargraphs of pumpage from a row-sequenced dataset containing all pumping wells using the filter option in the TOOL menu. The example presneted is for Death Valley Regional Flow System where pumpage is compiled by year and by well into a single dataset. Also plots well location using a user-defined function rowNOThidden.
KrigingTools\
KRIG_Max-40_XYZsamples.xls
The effect of nugget, sill, range, and variogram model on estimation of Z can be investigated in the file KRIG_Max-40_XYZsamples.xls.  Kriging is performed on a small subset of the Orlando data set.  Measured thickness and kriging weights are posted along with a target location.  Changing the target location will cause the weights and resulting estimate of Z to change.  
KrigingTools\
XYZ--Variograms+Kriging.xls
Constructs isotropic variograms from random XYZ data sets.  Fits a theoretical variogram model to the empirical variogram and fills a matrix of values by kriging or inverse-distance weighting from the XYZ data.
MappingTools\
Berger_DryValley\
QuicK_DryValleyMap.xls
Overlays map coordinates on a scanned image using XY charts.  Functions for computing perimeter and area of polygons are applied on the QuickArea page.
MappingTools\
EagleValley_WhereAmI\
EagleV_Where_Am_I.xls
Example of mapping with Excel.  Major features for Carson City are in digitized form and can be shown by hiding and unhiding data columns that hold XY information.  Locator can be moved to display information about “FIND ME DATA” wells and examine hydrographs from the “HYDRO-Wells.”  The base map only works at the full scale and should be killed if you zoom.  Zooming changes the map scale to that of the blue dashed box with red handles on the lower, left and upper, right corners. 
MappingTools\
GeoZones_by_Layer+X-Section.xls
Selects cross sections through Middle Humboldt Basin by moving cursor across map of surface geology.
MappingTools\
Humb5K_Daves_Locator.xls
Another mapping application where the model coordinate system differs from UTM coordinates by a 12 degree rotation. 
MappingTools\
UTM_Conversion_Functions.xls
Converts UTM to latitude/longitude and latitude/longitude to UTM using multiple functions. Accepts latitude/longitude as decimal degrees or in USGS units.  For example, 390000 is the number three-hundred ninety thousand to most, but 39 degrees, 0 minutes, and 0 seconds in USGS output. 
MatrixOperations_N_Tools\
Interpolate_Array1-Array2.xls
Interpolates from array1 to array 2.  Grids can be variably spaced. Grid reference can be node centered or block centered.   
MatrixOperations_N_Tools\
MatrixOperations.xls
Example of functions in Excel for adding, multiplying, and inverting matrices. 
MatrixOperations_N_Tools\
RandomArrayDist.xls
Generates random fields conditioned by assigned properties in adjacent cells. 
MatrixOperations_N_Tools\
ReWrapArray.xls
Takes a 1-D string of numbers and rewrap them into a NX by NY array.  Surface of array is plotted to check results.
MatrixOperations_N_Tools\
ShowArray.xls
Pastes an array on the “ARRAY” page.  Specify if the data are integer zones or real number in a continuous distribution.  Update and shade.  This is not the most efficient routine so only use it with this single sheet open.
MatrixOperations_N_Tools\
VolumetricSummary.xls
Summarize precipitation volumes in arrays above a given precipitation rate. 
PipeFlowProblems\
Head-Loss_in_Pipe.xls
Estimate head loss through a series of pipes, valves, and elbows.  
PipeFlowProblems\
Water_viscosity.xls
Calculates viscosity of water as functions of temperature and salinity.
Plotting_Tricks\
Digitize_from_Picture-in-a-Chart.xls
Example spreadsheet to digitze data directly from a scanned image inserted into a chart. Step-by-step instructions are listed for on-screen digitizing of a bar chart.  The instructions start with a blank spreadsheet, add data, include computations, chart data, add figure to be digitized, and sum all columns.
Plotting_Tricks\
HourGlass_Error.xls
Adds confidence intervals to a linear regression.  Adjust spread graphically by using column chart of confidence interval as a crude slider.
Plotting_Tricks\
Mismatch_time.xls
Interpolates values from irregularly spaced X values to regularly spaced, high-resolution series so lines and shaded areas can be plotted. 
Plotting_Tricks\
Post-Points_Next_to_XY.xls
Posts labels or values from a third column next to points plotted as an XY pair.  Macro automates selection of a label and replaces a text string with the address of the cell with the message to be posted.
Plotting_Tricks\
Trend-Analysis_Probability-Log.xls
Log-transforms data and plots transformed data on a probability scale.  Mean and standard deviation of log-transformed data can be estimated even if some values are censored.
SimpleReference_N_Explanations\
00_ExcelKeyboardShortcuts.xls
A summary of keyboard shortcuts by Charles Pearson.  Downloaded from http://www.cpearson.com/excel/topic.htm  under the "K" entry.
SimpleReference_N_Explanations\
00_Navigation_&_Copying.xls
General navigation instructions for toggling between windows. Quick copying of objects, sheets, and files.  Addition of miscellaneous series to XY charts.  Keyboard navigation with END and ARROW keys.   
SimpleReference_N_Explanations\
01_Importing_ASCII_Data.xls
Provides step-by-step instructions for importing external data with the "Import External Data" command.
SimpleReference_N_Explanations\
01_LookupTable+DataValidation.xls
Creates pull-down menus with data validation. This ensures label usage is consistent so exact matches can be made with HLOOKUP, MATCH, and VLOOKUP functions.  VLOOKUP searches for a specified value in the leftmost column of a specified range and returns a value from the same row and a specified column.  
SimpleReference_N_Explanations\
02_Text_and_Numbers.xls
Illustrates differences between treatment of text and numbers.  Introduces VALUE function for converting text to numbers and TEXT function for converting numbers to text.  
SimpleReference_N_Explanations\
03_USGS_Date-TimeFunction.xls
All times in Excel are in decimal days but can be formatted to appear in many ways.  Converts various date-time formats to decimal days. The application includes a generic function for converting odd time formats such as yyyymmdd hhmmss to mm/dd/yy hr:mm (20011031 093023  to 10/31/01 09:30).
SimpleReference_N_Explanations\
04_Hide-Unhide_Columns-and-Rows.xls
An XY series is made to disappear and reappear by hiding and unhiding a column.  Hiding and unhiding can be done from right-clicks on specified columns or through macros.  
SimpleReference_N_Explanations\
Box_and_Whiskers.xls
Demonstrates the use of clear boxes to support stacked columns without a visible base.
SimpleReference_N_Explanations\
FormulaCrib.xls
Example of creating a simple series with a formula and replacing the results with values by Pasting Special.
SimpleReference_N_Explanations\
Indirect_Reference.xls
Constructs cell references using the ADDRESS function. Also converts text strings of cell addresses to an active reference using the INDIRECT function.  
SimpleReference_N_Explanations\
Palisade_HISTOGRAMS.xls
Creates histogram of discharge using an Add-In utility "HISTOGRAM" that is included the analysis ToolPak.
SimpleReference_N_Explanations\
Palisade_INDIRECTreference.xls
Changes plotted time series by using indirect references.  
SimpleReference_N_Explanations\
Porosity_By_Mass.xls
Calculates porosity and moisture content from wet and dry weights of cores.  Example of simple calculations and segregating data and calculation cells. 
SolverExamples\
Effect_of_ParameterDefinition_on_Error.xls
Illustrates how poor parameter definition can create errors that are greater than measurement errors. The magnitude of these errors casts doubt on rigorous methods of weighting observations through analysis of quantifiable, but relatively slight, measurement errors.
SolverExamples\
Tube_Model-WL_Profiles.xls
Simulates a physical tube model with a numerical spreadsheet. A series of tubes (tube model) connected in series can approximate a 1-D ground-water flow system.   The Solver Add-In is used to estimate the 3 parameters that govern steady-state flow from the tube model.
SolverExamples\
Velocity-Stage-Relation.xls
Estimates the 3 coefficients in a velocity-stage-discharge relation using the Solver tool in Excel. User clicks on Tools>Solver and the sum-of-squares in cell J10 is minimized by changing the coefficients A, B, and C in cells J6:J8.
SurfaceWaterTools\
ADAPS_View+Summarize_WLs\
GENERIC_Summarize-A-WLseries.xls
Loads water levels and other data series from ADAPS output. User can view all time series at multiple resolutions. Spreadsheet routine identifies maximum water level in successive periods that vary from 21 to 30 hours in duration and compute frequency of monthly flooding of marsh surface. 
SurfaceWaterTools\
Discharge_Computation_AllPurpose-1Sheet.xls
Computes discharge worksheet and plots depth, velocity, and discharge profiles. Error checks restrict depth input, meter revolutions, and minimum observation time.
SurfaceWaterTools\
Indirect_PeakFlow\
INDIRECT_Slope-Conveyance.xls
Indirect-Slope Conveyance--This spreadsheet program will take channel geometry input, slope, and 'N' Values and compute the Q using Manning's equation. One can also specify a Q and cross-section from a discharge measurement and it will compute an 'N' value.  Stores multiple sheets for indirect flood estimation.  Summarizes user selected results from worksheets for each site to a single sheet. 
SurfaceWaterTools\
MULTI-Discharges.xls
Same entry sheet as in Discharge_Computation_AllPurpose-1Sheet.xls but all information for a site is contained on a single page.  Copies can be created within a workbook and selected information can be summarized  as in the INDIRECT_PeakFlows_Revised.xls sheet.
SurfaceWaterTools\
RatingCurve-Stage-Relation.xls
Rating Curve--Graphically depicts effects of shape, shifting control, roughness, and slope on rating curves. Different offsets may be chosen for plotting and the shape and interception of shifts plotted to a rating.
SurfaceWaterTools\
SegmentFit.xls
Fits a piece-wise continuous rating curve to noisy measurements by minimizing Log(Qsimulated/Qmeasured).  Estimates the related Q from speciefied segment stages.  Solver works equally well if Q is specified and stages are wiggled to minimize differences.
SurfaceWaterTools\
Stage-Area-Relation.xls
Illustrates relation between stage and cross-sectional area of a channel. Developed for training purposes.    Requested by a certain surface-water specialist but never applied.  
SurfaceWaterTools\
Stage-Control-Relation.xls
Surface-water profile example for teaching.  Illustrates effects of roughness and changing controls as discharge changes.
SurfaceWaterTools\
Velocity-Stage-Relation.xls
Estimates the 3 coefficients in a velocity-stage-discharge relation using the Solver tool in Excel. User clicks on Tools>Solver and the sum-of-squares in cell J10 is minimized by changing the coefficients A, B, and C in cells J6:J8.
SurfaceWaterTools\
Xsection-StageViewer\
DischargeStation_AREAS+RATING.xls
Loads cross-section and stage information so that ratings can be evaluated easily. 
Time_N_Date\
02_Text_and_Numbers.xls
Illustrates differences between treatment of text and numbers.  Introduces VALUE function for converting text to numbers and TEXT function for converting numbers to text.  
Time_N_Date\
03_USGS_Date-TimeFunction.xls
All times in Excel are in decimal days but can be formatted to appear in many ways.  Converts various date-time formats to decimal days. The application includes a generic function for converting odd time formats such as yyyymmdd hhmmss to mm/dd/yy hr:mm (20011031 093023  to 10/31/01 09:30).
WaterQualityTools\
Chemistry_for_cooperators2.xls
Example of QW data with holes in data set.
WaterQualityTools\
DurovPlot-QW.XLS
Plots Piper diagram from water-quality concentrations. Program allows users to view all data or subsets of the data and to graphically identify site name, cations, anions, and TDS.
WaterQualityTools\
FormatLabelEXP.xls
Labeling experiment for assigning useful information to transformed coordinates.  Alternative method for identifying plotted points in series.
WaterQualityTools\
PiperPlot-QW.XLS
Plots Piper diagram from water-quality concentrations. Program allows users to view all data or subsets of the data and to graphically identify site name, cations, anions, and TDS.