DIRECTORY\FILE  SUMMARY  IMAGE  
AlternativeCoordinates\ 3D_VectorViewer.xls 
Projects 3D XYZ vectors to a 2D 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 quartermodel are demonstrated. 


AlternativeCoordinates\ Xsection_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 leakyaquifer 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 leakyaquifer solution that also provides another estimate of transmissivity (Moench, 1985). 


AnalyticalAQfunc_DLL\ Slug_CooperGreene_Fcall.xls 
CooperGreene 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 02197. 


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 WaterTable Aquifers, USGS WRIR 994225 


AQtest_WorkBooks_OFR02197\ Confined_Predict.xls 
Predicts drawdown response of a single pumping well in a Theis aquifer. 


AQtest_WorkBooks_OFR02197\ Flowing_JacobLohman.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_OFR02197\ Pumping_CooperJacob.xls 
Estimates hydraulic properties using the CooperJacob method (Cooper and Jacob, 1946), commonly referred to as the straightline 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_OFR02197\ Pumping_CooperJacob_RECOVERY.xls 
Estimates hydraulic properties using the theory of superposition in that the waterlevel 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_OFR02197\ Pumping_CooperJacob_wEfficiency.xls 
Estimates efficiency by assigning a storage coefficient and estimates theoretical drawdown with Theis solution assuming observations are from pumping well. 


AQtest_WorkBooks_OFR02197\ Pumping_DistanceDrawdown.xls 
Estimates hydraulic properties using distancedrawdown methods. These methods can be used for multiwell aquifertest data once the drawdown has reached quasisteadystate. 


AQtest_WorkBooks_OFR02197\ Pumping_HantushJacob_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 steadystate. 


AQtest_WorkBooks_OFR02197\ Pumping_StepDrawdown.xls 
Estimates transmissivity from stepdrawdown test data. A stepdrawdown test is a singlewell 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 multiwell aquifertest data, but not as common as specificcapacity data. 


AQtest_WorkBooks_OFR02197\ Slug_BouwerRice.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_OFR02197\ Slug_BouwerRice_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_OFR02197\ Slug_CooperGreene.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_OFR02197\ Slug_KGSHighK_BB426data.xls 
Complete workbook of slugtest analyses. Raw timewater 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_OFR02197\ Slug_vanderKamp.xls 
Estimates hydraulic conductivity from slugtest data using the van der Kamp (1976) method. This method was developed for the analysis of slugtest data from highly transmissive aquifers, as evidenced by oscillatory waterlevel 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_OFR02197\ TrendAnalysis_ProbabilityLog.xls 
Logtransforms data and plots transformed data on a probability scale. Can also esimate mean and standard deviation of logtransformed 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. Weightedsensitivities 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\ ER54_LateralAnisotropy.xls 
Shows effects of lateral anisotropy on drawdown and apparent well positions. 


AquiferTestTools\ ER54_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 leakyaquifer 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 Yaxis. 


AquiferTestTools\ QuickSite.xls 
Allows digitizing of well locations from a bitmap or JPEG. 


AquiferTestTools\ ROMP09_WellGeologyAnalyticalMODOPTIM_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 crosssection 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 Yaxis. 


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 Ycoordinate that defines a linesegment 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 waterlevel 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 signout labels in all days. 


Class_N_Management\ DefiningVCONwiththickness_ErroneousWhereTHIN.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_GWfieldTechSacramentoCA2003.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\ SoundsNLinks_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\ ReducewithSubtotals.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\ BiLinearInterpolator.xls 
Interpolates bilinearly from a single table. Interpolation values are specified in the uppermost row and leftmost column of the lookup 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 dualporosity 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 LARGEDIAMETER WELL ...,WRR 21(8), P.11211131 and Moench, A.F., 1984, DOUBLEPOROSITY 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\ UseMultiCellRangeinfunction.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_DateTimeFunction.xls 
All times in Excel are in decimal days but can be formatted to appear in many ways. Converts various datetime 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 threehundred ninety thousand to most, but 39 degrees, 0 minutes, and 0 seconds in USGS output. 


HydrographViewer_MF2K\ HydrographViewer.HASens.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 userspecified threshold during userspecified periods. 


HydrographViewer_MF2K\ PumpagebyAutoFilter.xls 
Plots bargraphs of pumpage from a rowsequenced 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 userdefined function rowNOThidden. 


KrigingTools\ KRIG_Max40_XYZsamples.xls 
The effect of nugget, sill, range, and variogram model on estimation of Z can be investigated in the file KRIG_Max40_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\ XYZVariograms+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 inversedistance 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 “HYDROWells.” 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+XSection.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 threehundred ninety thousand to most, but 39 degrees, 0 minutes, and 0 seconds in USGS output. 


MatrixOperations_N_Tools\ Interpolate_Array1Array2.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 1D 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\ HeadLoss_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_PictureinaChart.xls 
Example spreadsheet to digitze data directly from a scanned image inserted into a chart. Stepbystep instructions are listed for onscreen 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, highresolution series so lines and shaded areas can be plotted. 


Plotting_Tricks\ PostPoints_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\ TrendAnalysis_ProbabilityLog.xls 
Logtransforms data and plots transformed data on a probability scale. Mean and standard deviation of logtransformed 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 stepbystep instructions for importing external data with the "Import External Data" command. 


SimpleReference_N_Explanations\ 01_LookupTable+DataValidation.xls 
Creates pulldown 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_DateTimeFunction.xls 
All times in Excel are in decimal days but can be formatted to appear in many ways. Converts various datetime 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_HideUnhide_ColumnsandRows.xls 
An XY series is made to disappear and reappear by hiding and unhiding a column. Hiding and unhiding can be done from rightclicks 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 AddIn 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_ModelWL_Profiles.xls 
Simulates a physical tube model with a numerical spreadsheet. A series of tubes (tube model) connected in series can approximate a 1D groundwater flow system. The Solver AddIn is used to estimate the 3 parameters that govern steadystate flow from the tube model. 


SolverExamples\ VelocityStageRelation.xls 
Estimates the 3 coefficients in
a velocitystagedischarge relation using the Solver tool in Excel. User
clicks on Tools>Solver and the sumofsquares in cell J10 is minimized by
changing the coefficients A, B, and C in cells J6:J8. 


SurfaceWaterTools\ ADAPS_View+Summarize_WLs\ GENERIC_SummarizeAWLseries.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_AllPurpose1Sheet.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_SlopeConveyance.xls 
IndirectSlope ConveyanceThis 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 crosssection 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\ MULTIDischarges.xls 
Same entry sheet as in Discharge_Computation_AllPurpose1Sheet.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\ RatingCurveStageRelation.xls 
Rating CurveGraphically 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 piecewise 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\ StageAreaRelation.xls 
Illustrates relation between stage and crosssectional area of a channel. Developed for training purposes. Requested by a certain surfacewater specialist but never applied. 


SurfaceWaterTools\ StageControlRelation.xls 
Surfacewater profile example for teaching. Illustrates effects of roughness and changing controls as discharge changes. 


SurfaceWaterTools\ VelocityStageRelation.xls 
Estimates the 3 coefficients in
a velocitystagedischarge relation using the Solver tool in Excel. User
clicks on Tools>Solver and the sumofsquares in cell J10 is minimized by
changing the coefficients A, B, and C in cells J6:J8. 


SurfaceWaterTools\ XsectionStageViewer\ DischargeStation_AREAS+RATING.xls 
Loads crosssection 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_DateTimeFunction.xls 
All times in Excel are in decimal days but can be formatted to appear in many ways. Converts various datetime 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\ DurovPlotQW.XLS 
Plots Piper diagram from waterquality 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\ PiperPlotQW.XLS 
Plots Piper diagram from waterquality concentrations. Program allows users to view all data or subsets of the data and to graphically identify site name, cations, anions, and TDS. 
