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