An excel tool for teaching theis method of estimating aquifer. Groundwater recharge can be defined as water added to the aquifer through the unsaturated zone after infiltration and percolation following any storm rainfall event. This session introduces a method of aquifer test using excel spreadsheet. Pdf spreadsheets for the analysis of aquifertest and. 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. Determination of aquifer properties for a confined aquifer. Usgs ofr 02197 spreadsheets for the analysis of aquifer. Several spreadsheets were developed for the analysis of aquifer test and slugtest data. Targac, wattenbarger and startzman 1990 developed two aif aquiferinfluence function type curves for aquifers. 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. Spreadsheets for the analysis of aquifer test and slugtest data. A layer of soil groundwater can flow through is called aquifer how to use aquifer in a sentence is shown in this page. This raster map is the expected negative change, or reduction in saturation level. Each spreadsheet incorporates analytical solutions of the partial differential equation for groundwater flow to a well for a specific type of condition or aquifer.
The idealized aquifers and associated calculations of aquifer response to pumping discussed here represent ideal end members of a continuum. 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. This type of aquifer does not have a layer of waterproof material above. Most importantly, they predict the cumulative water influx history. The confined aquifer parameters, transmissivity and storage. This permit holder list will be updated periodically throughout each month and is available for download in the following formats.
Spreadsheets for the analysis of aquifertest and slugtest. The international boundary and water commission, united states and mexico ibwc have completed the binational study of the transboundary san pedro aquifer. Putting the values of known parameters in equations 7 and 8, values of transmissivity and storage coefficient were found as 1027. Saturation levels over the ogallala aquifer in 2050. 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 study of water flow in aquifers and the characterization of aquifers is called hydrogeology. 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. Edwards aquifer forms, instructions, and checklists application forms, instructions, and checklists for edwards aquifer protection plans. This type of aquifer does not have a layer of waterproof material above them.
The following notes are designed to explain how excel. Estimating confined aquifer parameters using a simple derivative. This paper presents a simple ground water modeling spreadsheet template developed in excel with macros written in visual basic for applications vba. The spreadsheets are written in microsoft excel version 9. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of. An aquifer s storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer. Pdf analyse the well losses and aquifer losses on the. Geological survey usgs is frequently asked to conduct and analyze aquifer tests. An excel tool for teaching theis method of estimating. Confined and unconfined aquifers respond differently to. You may need a pdf reader to view some of the files on this page. This raster map is the expected negative change, or reduction in saturation level of the ogallala aquifer, over the 42 years. Njdep new jersey geological and water survey aquifer. 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.
An aquifers storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer. 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 spreadsheets were written in microsoft excel version 9. These programs are implemented by entering in an excel spreadsheet cell the call name and list of. 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. Targac, wattenbarger and startzman 1990 developed two aif aquifer influence function type curves for aquifers. Groundwater modeling south florida water management district.
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. Designed by hydrogeologists for hydrogeologists, aquifertest delivers all the tools. Aquifer exemption boundaries are determined in a variety of ways. 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 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. In this aquifer and groundwater lesson, students build a model aquifer find its relationship to water usage. Aquifertest is an easytouse software package for analyzing, interpreting and visualizing pumping and slug test data.
Comanche station no aquifer determination memorandum 1. Our library of courses covers a broad range of disciplines and critical health care topics. Theis method, typecurve, curve matching, excel, aquifers, teaching tool 1. Spreadsheets for the analysis of aquifer test and slugtest data, version 1. Introduction aquifer well pumping test method is a widely adopted method to determine the aquifer. 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.
A confined aquifer is a completely saturated aquifer bounded above and below by aquicludes. The same aquifer may be free, confined and semiconfined by sector and area of study. 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. Students are generally more interested in creating interactive tools to process aquifer test data to help them better understand aquifer response to pumping. 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. In the wells import dialog, match the data columns in the source file to the format required by aquifertest. 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. Excel for hydrology listing and description nevada water. 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. Spreadsheets for the analysis of aquifertest and slugtest data. The barton springsedwards aquifer conservation district was created in 1987 with a directive to conserve, protect, and enhance the groundwater resources in. Related terms include aquitard, which is a bed of low permeability along an aquifer, and aquiclude or aquifuge.
Pdf hydraulic conductivity and storage coefficient of aquifers are often. The proposed excel method can also be used for different aquifer types i. There is an unsaturated zone if this type of aquifer is drilled, the water level will rise to be in a position. 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.
Zekai sen, in applied drought modeling, prediction, and mitigation, 2015. Several spreadsheets have been developed for the analysis of aquifer test and slugtest data. Documentation of spreadsheets for the analysis of aquifer. Several spreadsheets were developed for the analysis of aquifertest and slugtest data. Fetkovich aquifer found in most reservoir engineering texts. Aquifertest is an easy to use software package for analyzing, interpreting and visualizing pumping and slug test data. 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. The spreadsheets, together with a pdf version of the documentation, can be downloaded for free. Each spreadsheet incorporates analytical solutions of the partial differential equation for ground. Download the pdf version of the documentation for highresolution. According to these rules, a major development project, which is one that disturbs at least 1 acre of land or creates at least 0.
The new jersey geological survey is a public service and research agency within the nj department of environmental protection. Determination of aquifer properties for a confined aquifer with graphical analysis in msexcel from the graph it is found that s 0. The barton springsedwards aquifer conservation district is committed to conserving, protecting, recharging, and preventing waste of groundwater and preserving all aquifers in the district. Pdf an excel tool for teaching theis method of estimating. Groundwater recharge an overview sciencedirect topics. The ogallala aquifer initiative offers a combination of technical and. Material balance calculations using the excel spreadsheet. I then added this map to the 2009 saturation levels to find the predicted 2050 saturation levels. In cases where advection dominates the transport of contaminants see chapter 152, modeling solute transport phenomena, volume 4, little. 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. The basic requirements for the application of material balance to a reservoir include. Aquifertest professional free version download for pc. Groundwater recharge depends on several factors such as infiltration capacity, stochastic.
Unconfined upper aquifers regularly fill and spill because they. 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. Water influx models are mathematical models that simulate and predict aquifer performance. Fact sheet on aquifer exemption data pdf 3 pp, 569 k user guide for aquifer exemption data. 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. 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.
Geological survey halford and kuniansky 2002 for the analysis of aquifertest and slugtest data, a common. Groundwater spreadsheets for solving groundwater flow and pollution problems. At the free water table, the groundwater is at atmospheric pressure. Students record observations as they build the layers of the aquifer. Analytical modelling of groundwater wells and well systems. 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. Groundwater flow systems can also be influenced by surface. The file is an excel spreadsheet with sitespecific information on each aquifer exemption. 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. Pdf spreadsheets for the analysis of aquifertest and slug. 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. Spreadsheets for the analysis of aquifertest and slugtest data, version 1. The boundary of an aquifer exemption contains the portion of the aquifer that may be affected by the injection activity.
This report documents several spreadsheets that have been developed for the analysis of aquiferpumping test and slugtest data. If the change is reversed it can take decades for the aquifer to recover. Several spreadsheets have been developed for the analysis of aquifertest and slugtest data. Information about the file format and how to generate the file is available in appendix b. Obtaining aquifer test data is expensive and timeconsuming. Spreadsheets for the analysis of aquifertest and slug. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of water drive reservoirs.
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. There are two types of aquifers, confined and unconfined. Spreadsheet for unconfined aquifer test analisis youtube. Aquifer exemption data protecting underground sources of. Feb 21, 20 get notifications on updates for this project. This report documents several spreadsheets that have been developed for the analysis of aquifer pumping test and slugtest data. Geological survey halford and kuniansky 2002 for the analysis of aquifer test and slugtest data, a common. Ambastha and abraham sageev stanford university stanford. A confined aquifer is a closed system and, for these. If this level is above the ground surface, the well is a freeflowing or artesian well. Edwards aquifer authority permit holder list edwards. Edwards aquifer forms, instructions, and checklists tceq.