A fully distributed spreadsheet modeling as a tool for analyzing groundwater level rise problem in Jeddah city

详细信息    查看全文

• 作者：Amro M. M. Elfeki (1)
  Jarbou Bahrawi (1)
  
  1. Department of Hydrology and Water Resources Management ; Faculty of Meteorology ; Environment and Arid Land Agriculture ; King Abdulaziz University ; P.O. Box 80208 ; Jeddah ; 21589 ; Saudi Arabia
  
• 关键词：Spreadsheet ; Groundwater level rise ; Microcomputer modeling ; Environmental models ; Jeddah city
• 刊名：Arabian Journal of Geosciences
• 出版年：2015
• 出版时间：April 2015
• 年：2015
• 卷：8
• 期：4
• 页码：2313-2325
• 全文大小：10,580 KB
• 参考文献：1. Abu-Rizaiza OS (1996) Groundwater rise problem in North Jeddah, Final report (In Arabic) Water and Sanitary Drainage Department of Makkah province, 2 vol. Saudi Arabia
  2. Abu-Rizaiza OS (1997) Groundwater rise problem in South Jeddah, Final report (In Arabiac) Water and Sanitary Drainage Department of Makkah province, Saudi Arabia
  3. Abu-Rizaiza OS (1999) Threats from groundwater table rise in urban areas in developing countries. IWRA, Water international, Vol.24, no. 1, 46-52
  4. Alquhtani MB and Shehata WM (2003) Vulnerability map of the groundwater rise in Jeddah, Saudi Arabia: 12th Asian regional conf. on the soil mechanics and geotechnical engineering / , 4鈥? August, 2003, Singapore, pp 357, Chapter 3鈥?
  5. AL-Sefry, SA, Sen, Z (2006) Groundwater rise problem and risk evaluation in major cities of arid lands- Jeddah case in Kingdom of Saudi Arabia. Water Resour Manag 20: pp. 91-108 CrossRef
  6. Aravind, H, Rajgopal, C, Soman, KP (2010) A Simple Approach to Clustering in Excel. Int J Comput Appl 11: pp. 1-25
  7. Ayvaz, MT, Karahan, H (2007) Modeling three-dimensional free-surface flows using multiple spreadsheets an extended pressure application for solving three-dimensional seepage problems with a free-surface. Comput Geotech 34: pp. 112-123 CrossRef
  8. Basamed AS (2001) Hydrochemical study and bacteriological effects on groundwater in the northern part of Jeddah district. Unpublished M.Sc. Thesis, Faculty of Earth Sciences, King Abdulaziz University, Jeddah, Saudi Arabia, 234 pp
  9. Batelaan, O, Smedt, F, Becker, P, Huybrechts, W Characterization of a regional groundwater discharge area by combined analysis of hydrochemistry, remote sensing and groundwater modeling. In: Dillon, P, Simmers, I eds. (1998) Shallow Groundwater Systems. IAH publ, Rotterdam, pp. 75-86
  10. Bhattacharjya, RK (2011) Solving groundwater flow inverse problem using spreadsheet solver. J Hydrol Eng 16: pp. 472-477 CrossRef
  11. DeCoursey WJ (2003) Statistics and probability for engineering applications with Microsoft庐 Excel. Library of Congress Cataloging-in-Publication Data, 396 pp
  12. Hancock, MC, Heaney, JP (1987) Water resources analysis using electronic spreadsheets. J Water Resour Plan 113: pp. 639-658 CrossRef
  13. Harbaugh AW (2005) MODFLOW-2005, The U.S. geological survey modular ground-water model鈥攖he ground-water flow process: U.S. Geological Survey Techniques and Methods 6-A16. http://water.usgs.gov/ogw/modflow/MODFLOW.html
  14. Karahan, H (2006) Implicit finite difference techniques for the advection-diffusion equation using spreadsheets. Adv Eng Softw 37: pp. 601-608 oft.2006.01.003" target="_blank" title="It opens in new window">CrossRef
  15. Karahan, H (2007) Unconditional stable explicit finite difference technique for the advection-diffusion equation using spreadsheets. Adv Eng Softw 38: pp. 80-86 oft.2006.08.001" target="_blank" title="It opens in new window">CrossRef
  16. Karahan, H (2012) Predicting Muskingum flood routing parameters using spreadsheets. Comput Appl Eng Educ 20: pp. 280-286 CrossRef
  17. Karahan, H, Ayvaz, MT (2005) Transient groundwater modeling using spreadsheets. Adv Eng Softw 36: pp. 374-384 oft.2005.01.002" target="_blank" title="It opens in new window">CrossRef
  18. Karahan, H, Ayvaz, MT (2005) Time-dependent groundwater modelling using spreadsheets. Comput Appl Eng Educ 13: pp. 192-199 CrossRef
  19. Liengme, BV (2003) A guide to Microsoft Excel 2002 for scientists and engineers. Elsevier Butterworth-Heinemann, Oxford
  20. Olsthoorn, TN (1985) The power of the electronic worksheet: modeling without special programs. Groundwater J 23: pp. 381-390 CrossRef
  21. Olsthoorn, TN (1998) Groundwater modelling: calibration and the use of spreadsheets. Delft University Press, Delft
  22. Ribando, RJ (1998) An Excel/Visual Basic for Applications (VBA) primer. Comput Educ J VIII: pp. 38-43
  23. Ribando, RJ, Galbis-Reig, V (1998) Convective heat and mass transfer from a runner using some advanced spreadsheet features. Comput Educ J VIII: pp. 22-28
  24. Wang, HF, Anderson, MP (1982) Introduction to groundwater modeling: finite difference and finite element methods. Freeman and Company, Bedford
  25. Zheng, C, Wang, PP (1999) MT3DMS: a modular three-dimensional multispecies transport model for simulation of advection, dispersion and chemical reactions of contaminants in groundwater systems. U.S. Army Engineer Research and Development Center, Vicksburg
  
• 刊物类别：Earth and Environmental Science
• 出版者：Springer Berlin Heidelberg
• ISSN：1866-7538

文摘

In this paper, a spreadsheet modeling is introduced as a tool for studying fully distributed real-world engineering problems. The merits of using the spreadsheet are the following: its simplicity, the spreadsheet is very well known to many researchers and engineers; it performs fast calculations; it has a user-friendly graphic interface; and it can also provide animated graphs. These merits provide engineers and scientists with a flexible tool to tackle environmental problems and quickly performing solution scenarios to their problems. A real-world case study has been presented to illustrate the application of such spreadsheet models. The groundwater level rise in Jeddah city is one of the problems that Jeddah city are facing. The reasons of groundwater level rise in Jeddah are the following: the leakage from septic tanks, leakage from freshwater pipe networks, landscape irrigation, annual rainfall, flash floods from eastern wadis, etc. These sources have been complied with a regional groundwater flow model (the general form of the partial differential equation for steady groundwater flow in a heterogeneous, unconfined aquifer with a fully distributed recharge, evaporation and pumping rates, and with a variable aquifer bottom elevation), discritized with a finite difference method, then formulated on a spreadsheet, and solved with the built-in macro-solver on the Excel software. The spreadsheet model has been tested and compared with analytical solution. The model has also been calibrated with observations, and the correlation coefficient was 0.96 for the hydraulic head data. The results have been displayed graphically in one, two, and three dimensions. Various scenarios have been investigated to show solutions of the problem. The results have shown that the spreadsheet modeling is a powerful, flexible, and a user-friendly tool in modeling fully distributed real-world engineering problems. Results can be transferred from spreadsheet to GIS software to present results over satellite images or base maps. Analysis of various solution scenarios can be done efficiently, and one can get quick answers to the decision makers at a preliminary stage of a project before going to a sophisticated modeling approach with specialized software.