Aquifer pdf to excel

This permit holder list will be updated periodically throughout each month and is available for download in the following formats. I then added this map to the 2009 saturation levels to find the predicted 2050 saturation levels. Each spreadsheet incorporates analytical solutions of the partial differential equation for ground. Saturation levels over the ogallala aquifer in 2050. The cone of depression associated with a pumping well in a homogeneous aquifer. 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. Excel based finite difference modeling of ground water flow nceg. A scroll bar can be used to vary parameter values in excel. The boundary of an aquifer exemption contains the portion of the aquifer that may be affected by the injection activity. Linear water influx of an infinite aquifer through a partially communicating fault ani1 k. Related terms include aquitard, which is a bed of low permeability along an aquifer, and aquiclude or aquifuge. 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 type of aquifer does not have a layer of waterproof material above.

Determination of aquifer properties for a confined aquifer. Several spreadsheets have been developed for the analysis of aquifertest and slugtest data. 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. Most importantly, they predict the cumulative water influx history. Aquifertest is an easytouse software package for analyzing, interpreting and visualizing pumping and slug test data. Confined and unconfined aquifers respond differently to. An unconfined aquifer groundwater level coincides with the surface and is in direct. The new jersey geological survey is a public service and research agency within the nj department of environmental protection. Groundwater modeling south florida water management district. 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. Estimating confined aquifer parameters using a simple derivative. Groundwater flow systems can also be influenced by surface. This paper presents a simple ground water modeling spreadsheet template developed in excel with macros written in visual basic for applications vba.

An aquifer s storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer. Geological survey usgs is frequently asked to conduct and analyze aquifer tests. An excel tool for teaching theis method of estimating. 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. Pdf analyse the well losses and aquifer losses on the. The file is an excel spreadsheet with sitespecific information on each aquifer exemption.

The study of water flow in aquifers and the characterization of aquifers is called hydrogeology. 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. Pdf an excel tool for teaching theis method of estimating. 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. This report documents several spreadsheets that have been developed for the analysis of aquiferpumping test and slugtest data. Analytical modelling of groundwater wells and well systems. Groundwater recharge an overview sciencedirect topics. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of water drive reservoirs. According to these rules, a major development project, which is one that disturbs at least 1 acre of land or creates at least 0. 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.

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. 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. Students record observations as they build the layers of the aquifer. Usgs ofr 02197 spreadsheets for the analysis of aquifer. The spreadsheets, together with a pdf version of the documentation, can be downloaded for free. Spreadsheets for the analysis of aquifertest and slugtest data, version 1. Pdf hydraulic conductivity and storage coefficient of aquifers are often. Aquifertest professional free version download for pc. The barton springsedwards aquifer conservation district was created in 1987 with a directive to conserve, protect, and enhance the groundwater resources in. 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. 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 were written in microsoft excel version 9. 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 ogallala aquifer initiative offers a combination of technical and. Groundwater recharge depends on several factors such as infiltration capacity, stochastic. 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. These programs are implemented by entering in an excel spreadsheet cell the call name and list of. If this level is above the ground surface, the well is a freeflowing or artesian well. Spreadsheets for the analysis of aquifertest and slugtest data. Groundwater spreadsheets for solving groundwater flow and pollution problems. A confined aquifer is a completely saturated aquifer bounded above and below by aquicludes.

Targac, wattenbarger and startzman 1990 developed two aif aquifer influence function type curves for aquifers. Several spreadsheets were developed for the analysis of aquifertest and slugtest data. Aquifer exemption data protecting underground sources of. Obtaining aquifer test data is expensive and timeconsuming. Geological survey halford and kuniansky 2002 for the analysis of aquifertest and slugtest data, a common. Excel for hydrology listing and description nevada water. 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. Comanche station no aquifer determination memorandum 1. Edwards aquifer authority permit holder list edwards. Models are one of many tools used by hydrogeologists and water managers to help monitor and evaluate groundwater aquifer systems.

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. Students are generally more interested in creating interactive tools to process aquifer test data to help them better understand aquifer response to pumping. Information about the file format and how to generate the file is available in appendix b. Spreadsheet for unconfined aquifer test analisis youtube. 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. Download the pdf version of the documentation for highresolution. Feb 21, 20 get notifications on updates for this project. The basic requirements for the application of material balance to a reservoir include. Njdep new jersey geological and water survey aquifer. You may need a pdf reader to view some of the files on this page. Documentation of spreadsheets for the analysis of aquifer. 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. 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.

In this aquifer and groundwater lesson, students build a model aquifer find its relationship to water usage. Spreadsheets for the analysis of aquifer test and slugtest data, version 1. Edwards aquifer forms, instructions, and checklists tceq. Theis method, typecurve, curve matching, excel, aquifers, teaching tool 1. This raster map is the expected negative change, or reduction in saturation level.

This report documents several spreadsheets that have been developed for the analysis of aquifer pumping test and slugtest data. 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. There are two types of aquifers, confined and unconfined. Aquifer exemption boundaries are determined in a variety of ways.

A confined aquifer is a closed system and, for these. Each spreadsheet incorporates analytical solutions of the partial differential equation for groundwater flow to a well for a specific type of condition or aquifer. Material balance calculations using the excel spreadsheet. This session introduces a method of aquifer test using excel spreadsheet. At the free water table, the groundwater is at atmospheric pressure. An aquifer is an underground layer of waterbearing permeable rock, rock fractures or unconsolidated materials gravel, sand, or silt. 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. The following notes are designed to explain how excel. Determination of aquifer properties for a confined aquifer with graphical analysis in msexcel from the graph it is found that s 0.

In the wells import dialog, match the data columns in the source file to the format required by aquifertest. 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. If the change is reversed it can take decades for the aquifer to recover. Putting the values of known parameters in equations 7 and 8, values of transmissivity and storage coefficient were found as 1027. 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. Pdf spreadsheets for the analysis of aquifertest and slug.

Aquifertest is an easy to use software package for analyzing, interpreting and visualizing pumping and slug test data. The spreadsheets are written in microsoft excel version 9. Unconfined upper aquifers regularly fill and spill because they. Groundwater recharge can be defined as water added to the aquifer through the unsaturated zone after infiltration and percolation following any storm rainfall event. Several spreadsheets have been developed for the analysis of aquifer test and slugtest data.

This type of aquifer does not have a layer of waterproof material above them. Pdf spreadsheets for the analysis of aquifertest and. Zekai sen, in applied drought modeling, prediction, and mitigation, 2015. This raster map is the expected negative change, or reduction in saturation level of the ogallala aquifer, over the 42 years. Introduction aquifer well pumping test method is a widely adopted method to determine the aquifer. Edwards aquifer forms, instructions, and checklists application forms, instructions, and checklists for edwards aquifer protection plans.

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. Fact sheet on aquifer exemption data pdf 3 pp, 569 k user guide for aquifer exemption data. Fetkovich aquifer found in most reservoir engineering texts. 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. Spreadsheets for the analysis of aquifertest and slugtest. A layer of soil groundwater can flow through is called aquifer how to use aquifer in a sentence is shown in this page. 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. The idealized aquifers and associated calculations of aquifer response to pumping discussed here represent ideal end members of a continuum. 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. Spreadsheets for the analysis of aquifer test and slugtest data. Our library of courses covers a broad range of disciplines and critical health care topics. An aquifers storage capacity depends on its pore space eg a sandy aquifer has more space than a fractured rock aquifer.

Geological survey halford and kuniansky 2002 for the analysis of aquifer test and slugtest data, a common. 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. The proposed excel method can also be used for different aquifer types i. The international boundary and water commission, united states and mexico ibwc have completed the binational study of the transboundary san pedro aquifer. The barton springsedwards aquifer conservation district is committed to conserving, protecting, recharging, and preventing waste of groundwater and preserving all aquifers in the district. There is an unsaturated zone if this type of aquifer is drilled, the water level will rise to be in a position. An excel tool for teaching theis method of estimating aquifer. When successfully integrated with a reservoir simulator, the net result is a model that effectively simulates performance of. Water influx models are mathematical models that simulate and predict aquifer performance. Spreadsheets for the analysis of aquifertest and slug. The confined aquifer parameters, transmissivity and storage.

1033 857 546 582 1438 1151 1529 1471 608 990 1565 354 217 594 357 1339 1427 1533 562 509 118 1041 1165 288 517 193 809 792 360 744 1020 104 231 885 1264 36 978 47 234 264 586