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