This report documents several spreadsheets that have been developed for the analysis of aquiferpumping test and slugtest data. In the wells import dialog, match the data columns in the source file to the format required by aquifertest. This raster map is the expected negative change, or reduction in saturation level of the ogallala aquifer, over the 42 years. In this aquifer and groundwater lesson, students build a model aquifer find its relationship to water usage. This permit holder list will be updated periodically throughout each month and is available for download in the following formats. Pdf analyse the well losses and aquifer losses on the. If the change is reversed it can take decades for the aquifer to recover. Aquifertest professional with the ability to characterize your aquifer and analyze pumping and slug tests, aquifertest pro features all of the tools you need in one convenient groundwater data analysis program. Aquifer storage and recovery is capturing water when it is abundant such as a rainy season or during spring snow melts, storing the water in the subsurface in brackish aquifers, and recovering the water when needed. The study marks the first time researchers from both countries have collaborated to collect data and jointly prepare binational maps of the san pedro river aquifer, which spans the border between the states of arizona and sonora near the. An unconfined aquifer groundwater level coincides with the surface and is in direct.
Confined and unconfined aquifers respond differently to. Aquifertest is an easy to use software package for analyzing, interpreting and visualizing pumping and slug test data. Groundwater recharge can be defined as water added to the aquifer through the unsaturated zone after infiltration and percolation following any storm rainfall event. The study of water flow in aquifers and the characterization of aquifers is called hydrogeology. An aquifer s storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of water drive reservoirs. Material balance calculations using the excel spreadsheet. Introduction aquifer well pumping test method is a widely adopted method to determine the aquifer. Most importantly, they predict the cumulative water influx history. The idealized aquifers and associated calculations of aquifer response to pumping discussed here represent ideal end members of a continuum.
Aquifer resources llc filed as a domestic limited liability company llc in the state of texas on wednesday, december 21, 2016 and is approximately four years old, as recorded in documents filed with texas secretary of state. In these aquifers water is subjected to a pressure greater than the one of the atmosphere and takes up all pores and voids of the geological formation completely saturating it. An aquifer is not important for ecosystems and never provides drinking water create your account to access this entire worksheet a premium account gives you access to all lesson, practice exams. Determination of aquifer properties for a confined aquifer. The ogallala aquifer initiative offers a combination of technical and. Excel based finite difference modeling of ground water flow nceg. The cone of depression associated with a pumping well in a homogeneous aquifer. The following notes are designed to explain how excel. Saturation levels over the ogallala aquifer in 2050.
Spreadsheets for the analysis of aquifertest and slugtest data. Targac, wattenbarger and startzman 1990 developed two aif aquifer influence function type curves for aquifers. The spreadsheets were written in microsoft excel version 9. If the aquifergas reservoir radii relationship is greater than 10 the aquifer is considered to be infinite and its water providing capability is higher than finite aquifer size. This report documents several spreadsheets that have been developed for the analysis of aquifer pumping test and slugtest data. Edwards aquifer authority permit holder list edwards.
The file is an excel spreadsheet with sitespecific information on each aquifer exemption. Spreadsheets for the analysis of aquifertest and slug. A layer of soil groundwater can flow through is called aquifer how to use aquifer in a sentence is shown in this page. A confined aquifer is a closed system and, for these. Kuhlman april 16, 20 1 1 abstract 2 analytic and semianalytic solution are often used by researchers and practicioners to esti3 mate aquifer parameters from uncon. Geological survey halford and kuniansky 2002 for the analysis of aquifertest and slugtest data, a common.
The spreadsheets, together with a pdf version of the documentation, can be downloaded for free. Aquifer thickness b specific yield sy or storage coefficient s distance from well to river x distance to boundary w data is assigned by model cell 1,000s might include complex geometry, multiple layers, boundary conditions, partially penetrating streams, et from gw, subirrigation, impact on canals. This paper presents a simple ground water modeling spreadsheet template developed in excel with macros written in visual basic for applications vba. Each spreadsheet incorporates analytical solutions of the partial differential equation for ground. This type of aquifer does not have a layer of waterproof material above them. A scroll bar can be used to vary parameter values in excel. Geological survey halford and kuniansky 2002 for the analysis of aquifer test and slugtest data, a common. The proposed excel method can also be used for different aquifer types i.
Download the pdf version of the documentation for highresolution. Spreadsheets for the analysis of aquifer test and slugtest data. This type of aquifer does not have a layer of waterproof material above. Targac, wattenbarger and startzman 1990 developed two aif aquiferinfluence function type curves for aquifers. In cases where advection dominates the transport of contaminants see chapter 152, modeling solute transport phenomena, volume 4, little. Spreadsheets for the analysis of aquifertest and slugtest data, version 1. Aquifertest professional free version download for pc.
Excel for hydrology listing and description nevada water. An excel tool for teaching theis method of estimating. Putting the values of known parameters in equations 7 and 8, values of transmissivity and storage coefficient were found as 1027. Groundwater models take into account the basic components of the hydrological cycle along with the physical properties of the aquifer and the stresses to the system, rainfall, pumping rates, etc. Information about the file format and how to generate the file is available in appendix b. Groundwater spreadsheets for solving groundwater flow and pollution problems. Analytical modelling of groundwater wells and well systems. An excel tool for teaching theis method of estimating aquifer. The spreadsheets are written in microsoft excel version 9.
I then added this map to the 2009 saturation levels to find the predicted 2050 saturation levels. You may need a pdf reader to view some of the files on this page. This session introduces a method of aquifer test using excel spreadsheet. Aquifer exemption data protecting underground sources of. Creating a scroll bar in an excel worksheet the key to create an interactive environment is the ability to change an aquifer parameter for example, transmissivity and to view the effect of this change on the type curves.
Several spreadsheets have been developed for the analysis of aquifertest and slugtest data. Edwards aquifer forms, instructions, and checklists tceq. There is an unsaturated zone if this type of aquifer is drilled, the water level will rise to be in a position. Groundwater flow systems can also be influenced by surface. This discussion is intended to show that through the use of the fetkovich aquifer, only two parameters are required to describe an aquifer and estimate water influx, the aquifer productivity index j and the aquifer maximum encroachable water wei. This raster map is the expected negative change, or reduction in saturation level. Njdep new jersey geological and water survey aquifer. The same aquifer may be free, confined and semiconfined by sector and area of study. If the aquifer gas reservoir radii relationship is greater than 10 the aquifer is considered to be infinite and its water providing capability is higher than finite aquifer size. The confined aquifer parameters, transmissivity and storage. A confined aquifer is a completely saturated aquifer bounded above and below by aquicludes. Material balance calculations using the excel spreadsheet introduction material balance is a fundamental petroleum reservoir engineering tool that can be used to provide an understanding of a reservoir and the influence of any connecting aquifer. The new jersey geological survey is a public service and research agency within the nj department of environmental protection.
An aquifer is an underground layer of waterbearing permeable rock, rock fractures or unconsolidated materials gravel, sand, or silt. Models are one of many tools used by hydrogeologists and water managers to help monitor and evaluate groundwater aquifer systems. Theis method, typecurve, curve matching, excel, aquifers, teaching tool 1. There are two types of aquifers, confined and unconfined. The boundary of an aquifer exemption contains the portion of the aquifer that may be affected by the injection activity. Feb 21, 20 get notifications on updates for this project. Groundwater recharge an overview sciencedirect topics. The basara basin is located in ne of iraq, 25 km west of sulaimani city, between the 496652 537752 east and 3911038 3951906 north in universal transverse mercator utm and lie in zone 38n. The rate at which groundwater levels drop when pumping occurs depends on how much water is stored and how quickly it moves through the aquifer. By submitting your application, you confirm that your edwards aquifer protection plan is final, contains all required information and attachments, and includes the correct number of copies.
Comanche station no aquifer determination memorandum 1. These programs are implemented by entering in an excel spreadsheet cell the call name and list of. Groundwater recharge depends on several factors such as infiltration capacity, stochastic. The barton springsedwards aquifer conservation district is committed to conserving, protecting, recharging, and preventing waste of groundwater and preserving all aquifers in the district. Fetkovich aquifer found in most reservoir engineering texts. The time it takes for an aquifer to respond to a change in rainfall, pumping or land use can range from hours to millions of years. Several spreadsheets have been developed for the analysis of aquifer test and slugtest data.
Determination of aquifer properties for a confined aquifer with graphical analysis in msexcel from the graph it is found that s 0. Pdf spreadsheets for the analysis of aquifertest and. Ambastha and abraham sageev stanford university stanford. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of. Pdf hydraulic conductivity and storage coefficient of aquifers are often. Founded in 1835, the njgs has evolved from a mineral resources and topographic mapping agency to a modern environmental organization that collects and provides geoscience information to government, consultants, industry, environmental groups, and the public. The free aquifer is such in which there is free shallow water in contact with air and atmospheric pressure, so that its pressure is actually equal to the atmospheric pressure. Estimating confined aquifer parameters using a simple derivative. Each spreadsheet incorporates analytical solutions of the partial differential equation for groundwater flow to a well for a specific type of condition or aquifer. Water influx models are mathematical models that simulate and predict aquifer performance. Kuhlman april 16, 20 1 1 abstract 2 analytic and semianalytic solution are often used by researchers and practicioners to esti3 mate aquifer parameters from.
At the free water table, the groundwater is at atmospheric pressure. Pdf an excel tool for teaching theis method of estimating. Several spreadsheets were developed for the analysis of aquifer test and slugtest data. Designed by hydrogeologists for hydrogeologists, aquifertest delivers all the tools. Unconfined upper aquifers regularly fill and spill because they. If this level is above the ground surface, the well is a freeflowing or artesian well. An aquifers storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer. The international boundary and water commission, united states and mexico ibwc have completed the binational study of the transboundary san pedro aquifer. Spreadsheets for the analysis of aquifer test and slugtest data, version 1. Our library of courses covers a broad range of disciplines and critical health care topics. The barton springsedwards aquifer conservation district was created in 1987 with a directive to conserve, protect, and enhance the groundwater resources in. The pressure of the water in confined aquifers is usually higher than atmospheric pressure, which is why when a well is bored into the aquifer the water rises up the well tube, to a level higher than the aquifer figure 2.
Psco comanche station no aquifer determination memorandum facility description 2 annual report to document the nine sample events performed and to describe the hydrogeologic site conditions relative to the definition of an aquifer. Students are generally more interested in creating interactive tools to process aquifer test data to help them better understand aquifer response to pumping. Geological survey usgs is frequently asked to conduct and analyze aquifer tests. Documentation of spreadsheets for the analysis of aquifer. Zekai sen, in applied drought modeling, prediction, and mitigation, 2015. Usgs ofr 02197 spreadsheets for the analysis of aquifer. Related terms include aquitard, which is a bed of low permeability along an aquifer, and aquiclude or aquifuge. Spreadsheet for unconfined aquifer test analisis youtube. Several spreadsheets were developed for the analysis of aquifertest and slugtest data. Spreadsheets for the analysis of aquifertest and slugtest.
Chapter 6 groundwater recharge this chapter presents the standards, data, and procedures necessary to meet the groundwater recharge requirements of the njdep stormwater management rules at n. Students record observations as they build the layers of the aquifer. Pdf spreadsheets for the analysis of aquifertest and slug. An unconfined aquifer is a partly saturated aquifer bounded below by an aquiclude and above by the free water table or phreatic surface figure 2. Groundwater modeling south florida water management district. Aquifertest is an easytouse software package for analyzing, interpreting and visualizing pumping and slug test data.
The basic requirements for the application of material balance to a reservoir include. Edwards aquifer forms, instructions, and checklists application forms, instructions, and checklists for edwards aquifer protection plans. Ca 94305 abstract this paper presents a linear flow water influx analysis method where the aquifer is separated from the reservoir by a partially communicating fault. Aquifer exemption boundaries are determined in a variety of ways. According to these rules, a major development project, which is one that disturbs at least 1 acre of land or creates at least 0. Linear water influx of an infinite aquifer through a partially communicating fault ani1 k.
224 341 987 342 1040 440 1105 259 706 1224 143 225 58 942 346 1277 112 272 1014 1400 1396 1331 1431 1259 542 831 1465 229 1032 977 934 996 134 1404 962 48 1139 609 120 519 118 914 376 840 336 201 329 114 582