| Abstract: | Several spreadsheets have been developed for the analysis of aquifer-test and slug-test data. Each spreadsheet incorporates analytical solution(s) of the partial differential equation for ground-water flow to a well for a specific type of condition or aquifer. The derivations of the analytical solutions were previously published. Thus, this report abbreviates the theoretical discussion, but includes practical information about each method and the important assumptions for the applications of each method. These spreadsheets were written in Microsoft Excel 9.0 (use of trade names does not constitute endorsement by the USGS). Storage properties should not be estimated with many of the spreadsheets because most are for analyzing single-well tests. Estimation of storage properties from single-well tests is generally discouraged because single-well tests are affected by wellbore storage and by well construction. These non-ideal effects frequently cause estimates of storage to be erroneous by orders of magnitude. Additionally, single-well tests are not sensitive to aquifer-storage properties. Single-well tests include all slug tests (Bouwer and Rice Method, Cooper, Bredehoeft, Papadopulos Method, and van der Kamp Method), the Cooper-Jacob straight-line Method, Theis recovery-data analysis, Jacob-Lohman method for flowing wells in a confined aquifer, and the step-drawdown test. Multi-well test spreadsheets included in this report are; Hantush-Jacob Leaky Aquifer Method and Distance-Drawdown Methods. The distance-drawdown method is an equilibrium or steady-state method, thus storage cannot be estimated. |
| Genre: | USGS Numbered Series |
| ProdID: | 50638 |
| Citation Author: | Halford, Keith J.; Kuniansky, Eve L. |
| Citation Contributing Office: | |
| Citation Datum: | |
| Citation Day: | |
| Citation Edition: | Version 1.1 |
| Citation Editor: | |
| Citation End Page: | |
| Citation Issue: | |
| Citation Keywords: | |
| Citation Language: | ENGLISH |
| Citation Larger Work Title: | |
| Citation LatN: | |
| Citation LatS: | |
| Citation LonE: | |
| Citation LonW: | |
| Citation Month: | |
| Citation No Pagination: | |
| Citation Number Of Pages: | |
| Citation Online Only Flag: | |
| Citation Phsyical Description: | 51 p. |
| Citation Projection: | |
| Citation Public Comments: | |
| Citation Publisher: | |
| Citation Series: | Open-File Report |
| Citation Series Code: | OFR |
| Citation Series Number: | 2002-197 |
| Citation Search Results Text: | Documentation of spreadsheets for the analysis of aquifer-test and slug-test data; 2002; OFR; 2002-197; Halford, Keith J.; Kuniansky, Eve L. |
| Citation Start Page: | |
| Citation Volume: | |
| Citation Year: | 2002 |
| Type: | citation/reference |
| Text: | Documentation of spreadsheets for the analysis of aquifer-test and slug-test data; 2002; OFR; 2002-197; Halford, Keith J.; Kuniansky, Eve L. |
| URL (THUMBNAIL): | http://pubs.er.usgs.gov/thumbnails/usgs_thumb.jpg |
| URL (INDEX PAGE): | http://pubs.water.usgs.gov/ofr02197/ |
| Date Other: | Sat, 1 Jan 1994 00:00 -0600 |
| Publisher: | |
