A fully distributed spreadsheet modeling as a tool for analyzing groundwater level rise problem in Jeddah city
作者： Amro MM Elfeki , Jarbou Bahrawi , None
DOI: 10.1007/S12517-014-1340-Z
关键词: Aquifer 、 Groundwater recharge 、 Geographic information system 、 Pipe network analysis 、 Computer science 、 Variable (computer science) 、 Groundwater flow 、 Software 、 Hydraulic head 、 Hydrology 、 Civil engineering
摘要: In this paper, a spreadsheet modeling is introduced as tool for studying fully distributed real-world engineering problems. The merits of using the are following: its simplicity, very well known to many researchers and engineers; it performs fast calculations; has user-friendly graphic interface; can also provide animated graphs. These engineers scientists with flexible tackle environmental problems quickly performing solution scenarios their A case study been presented illustrate application such models. groundwater level rise in Jeddah city one that facing. reasons leakage from septic tanks, freshwater pipe networks, landscape irrigation, annual rainfall, flash floods eastern wadis, etc. sources have complied regional flow model (the general form partial differential equation steady heterogeneous, unconfined aquifer recharge, evaporation pumping rates, variable bottom elevation), discritized finite difference method, then formulated on spreadsheet, solved built-in macro-solver Excel software. tested compared analytical solution. calibrated observations, correlation coefficient was 0.96 hydraulic head data. results displayed graphically one, two, three dimensions. Various investigated show solutions problem. shown powerful, flexible, Results be transferred GIS software present over satellite images or base maps. Analysis various done efficiently, get quick answers decision makers at preliminary stage project before going sophisticated approach specialized
springer.com
sci-hub.se 参考文章(18)
W.J. DeCoursey, Basic Probability: Prerequisite: A good knowledge of algebra Statistics and Probability for Engineering Applications#R##N#With Microsoft® Excel. pp. 6- 40 ,(2003) , 10.1016/B978-075067618-2/50004-4
Chunmiao Zheng, P P Wang, MT3DMS: A Modular Three-Dimensional Multispecies Transport Model for Simulation of Advection, Dispersion, and Chemical Reactions of Contaminants in Groundwater Systems; Documentation and User's Guide This Digital Resource was created in Microsoft Word and Adobe Acrobat. ,(1999)
Arlen W. Harbaugh, MODFLOW-2005 : the U.S. Geological Survey modular ground-water model--the ground-water flow process Techniques and Methods. ,(2005) , 10.3133/TM6A16
Herbert F. Wang, Mary P. Anderson, Introduction to Groundwater Modeling: Finite Difference and Finite Element Methods ,(1995)
Halil Karahan, Implicit finite difference techniques for the advection-diffusion equation using spreadsheets Advances in Engineering Software. ,vol. 37, pp. 601- 608 ,(2006) , 10.1016/J.ADVENGSOFT.2006.01.003
Saleh A. Al-Sefry, Zekai Şen, Groundwater Rise Problem and Risk Evaluation in Major Cities of Arid Lands – Jedddah Case in Kingdom of Saudi Arabia Water Resources Management. ,vol. 20, pp. 91- 108 ,(2006) , 10.1007/S11269-006-4636-2
Omar Seraj Abu-Rizaiza, Threats from Groundwater Table Rise in Urban Areas in Developing Countries Water International. ,vol. 24, pp. 46- 52 ,(1999) , 10.1080/02508069908692133
Michael C. Hancock, James P. Heaney, Water Resources Analysis Using Electronic Spreadsheets Journal of Water Resources Planning and Management. ,vol. 113, pp. 639- 658 ,(1987) , 10.1061/(ASCE)0733-9496(1987)113:5(639)
Halil Karahan, Predicting Muskingum flood routing parameters using spreadsheets Computer Applications in Engineering Education. ,vol. 20, pp. 280- 286 ,(2012) , 10.1002/CAE.20394
Rajib Kumar Bhattacharjya, Solving Groundwater Flow Inverse Problem Using Spreadsheet Solver Journal of Hydrologic Engineering. ,vol. 16, pp. 472- 477 ,(2011) , 10.1061/(ASCE)HE.1943-5584.0000329