KADEMELİ POMPA TESTİNDEN ELDE EDİLEN VERİLERİN ANALİZ EDİLMESİ İÇİN YAZILIMSAL ÇÖZÜMLER

Abstract

Kademeli pompa testleri, akiferlerin hidrolik özelliklerinin belirlenmesinde ve yeraltı suyu yönetimi süreçlerinde kritik bir öneme sahiptir. Bu testler sonucunda elde edilen veriler, akifer hidrolik iletkenliği, özgül verim ve depolama katsayısı gibi parametrelerin analiz edilmesini sağlar. Ancak, bu verilerin doğru ve hızlı bir şekilde çözümlenmesi, genellikle karmaşık hesaplamalar ve kapsamlı veri yönetimi gerektirmektedir. Geleneksel yöntemlerin yanı sıra, günümüzde yazılımsal çözümler bu süreçleri optimize etmekte önemli bir rol oynamaktadır. Bu çalışmada, Visual Basic programlama dili kullanılarak, kademeli pompa testlerinden elde edilen verilerin analizini hızlandıran ve sonuçları görselleştirerek daha etkili karar alma süreçlerine olanak tanıyan bir yazılım geliştirilmiştir. Önerilen çözüm, hem zaman tasarrufu sağlamakta hem de analiz doğruluğunu artırmaktadır. Bu makale, kademeli pompa testlerinin önemini ve geliştirilen yazılımın bu süreçlere olan katkısını detaylandırmayı amaçlamaktadır. Çalışma kapsamında kullanılan veri seti Liwa Projesi’nde yapılmış olan kademeli pompa testlerinden elde edilmiştir. Liwa akiferi 80 metre kalınlığa sahip serbest bir akifer olup kum, kumtaşı ve karbonatlı birimlerden oluşmaktadır. Liwa Bölgesi, Abu-Dhabi Şehri’nin (BAE) 150 km güneybatısında yer almaktadır.

Keywords

• Kademeli Pompa Testi
• Akifer
• Visual Basic
• Yazılım
• Liwa
• BAE

SOFTWARE SOLUTIONS FOR ANALYZING DATA OBTAINED FROM STEP DRAWDOWN TEST

Abstract

Step-drawdown tests play a critical role in determining the hydraulic properties of aquifers and in the management of groundwater resources. The data obtained from these tests allow for the analysis of parameters such as aquifer hydraulic conductivity, specific yield, and storage coefficient. However, accurate and rapid interpretation of this data often requires complex calculations and comprehensive data management. In addition to traditional methods, software-based solutions today play an important role in optimizing these processes. In this study, a software application was developed using the Visual Basic programming language to accelerate the analysis of data obtained from step-drawdown tests and to facilitate more effective decision-making processes through data visualization. The proposed solution not only saves time but also increases the accuracy of analysis. This article aims to emphasize the importance of step-drawdown tests and to detail the contribution of the developed software to these processes. The dataset used in the study was obtained from step-drawdown tests conducted as part of the Liwa Project. The Liwa Region is located 150 km southwest of Abu Dhabi City, United Arab Emirates (UAE).

Keywords

• Step-Drawdown Test
• Aquifer
• Visual Basic
• Software
• Liwa
• UAE

References

1. Kruseman, G.P., and de Ridder, N.A., Analysis and Evaluation of Pumping Test Data, International Institute for Land Reclamation and Improvement, Wageningen, The Netherlands, 1994.
2. Beyazıt, N., and Atmaca, K., "The effect of cathode material, current density and anode-cathode gap on the COD and color removal from leachate by the electro-Fenton method", Desalination and Water Treatment, 193, 121–130, 2020.
3. Yılmaz, E., and Demir, A., "Investigation of reusability of effluents from an organized industrial zone wastewater treatment plant using a pressure-driven membrane process", Journal of Water Reuse and Desalination, 13, 559–567, 2022.
4. Beyazıt, N., and Atmaca, K., "Investigation of COD and color removal from medium density fiberboard wastewater by photo-electro-Fenton method", Environmental Technology & Innovation, 30, 102345, 2024.
5. Ozaktan, H., Aslan, E., Yolageldi, L., Gul, A., Akpınar, J., Düzel, A., and Çavdaroğlu, Ç., "Development of biopesticide and biostimulant formulations for good agricultural practices in greenhouse cucumber cultivation", Acta Horticulturae, 1320, 303–310, 2021.
6. Yeşilmaden, H.M., İnan, Ç.A., Kurtuluş, B., Canoğlu, M.C., Avşar, Ö., and Razack, M., "Land subsidence assessment under excessive groundwater pumping using ESA Sentinel-1 satellite data: A case study of Konya Basin, Turkey", Environmental Earth Sciences, 80, 567, 2021.
7. Sağır, Ç., Kurtuluş, B., Soupios, P., Ayrancı, K., Düztaş, E., Aksoy, M.E., Avşar, Ö., Erdem, G., Pekkan, E., Kaka, S.I., and Razack, M., "Investigating the structure of a coastal karstic aquifer through the hydrogeological characterization of springs using geophysical methods and field investigation, Gökova Bay, SW Turkey", Water, 12, 3343, 2020.
8. Canoğlu, M.C., Kurtuluş, B., and Razack, M., "Soil–aquifer interactions and vadose zone modeling: An example from Marais Poitevin (Western France)", Carpathian Journal of Earth and Environmental Sciences, 14, 825–834, 2019.

9. Al-Hashmi, A., and Al-Amri, S., "Assessment of aquifer recharging using dams in terms of geotechnical characterization and hydrogeological conditions in arid regions", Journal of African Earth Sciences, 160, 103634, 2019.
10. Rumbaugh, D.B., and Rumbaugh, J.O., Guide to Using AquiferWin32, Environmental Simulations Inc., 2011.
11. Duffield, G.M., AQTESOLV for Windows Version 4.5 User’s Guide, 2007.
12. Labadie, J.W., and Helweg, O.J., "Step-drawdown Test Analysis by Computer", Groundwater, 13, 438–444, 1975.
13. Eden, R.N., and Hazel, C.P., Computer and Graphical Analysis of Variable Discharge Pumping Tests of Wells, Institution of Engineers Australia, Barton, Australia, 1973, 15, 5–10.
14. Patterson, M., Mastering VBA for Microsoft Office 2013, Wiley, 2013.
15. Rorabaugh, M.I., "Graphical and Theoretical Analysis of Step-Drawdown Test of Artesian Wells", Proc. Am. Soc. Civ. Eng., 19, 1–23, 1953.
16. Walkenbach, J., Excel VBA Programming for Dummies, Wiley, 2015.
17. Jelen, B., and Syrstad, T., VBA and Macros: Microsoft Excel 2010, Que Publishing, 2010.
18. Roman, S., Developing Applications with Microsoft Excel, Microsoft Press, 2002.
19. Deitel, H.M., and Deitel, P.J., Visual Basic 2017, Pearson Education, 2017.
20. Bullen, S., Bovey, J., and Green, R., Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Addison-Wesley, 2013.
21. Jacob, C.E., "Drawdown Test to Determine Effective Radius of Artesian Well", Trans. Am. Soc. Civ. Eng., 112, 1047–1070, 1947.
22. Kurtulus, B., Yaylım, T.N., Avşar, O., Kulac, H.F., and Razack, M., "The Well Efficiency Criteria Revisited—Development of a General Well Efficiency Criteria (GWEC) Based on Rorabaugh’s Model", Water, 11, 1784, 2019.
23. Kurtulus, B., Yaylım, T.N., Avşar, O., Kulac, H.F., and Razack, M., "The Well Efficiency Criteria Revisited—Development of a General Well Efficiency Criteria (GWEC) Based on Rorabaugh’s Model", Water, 11, 1784, 2019.
24. Schneider, D.I., An Introduction to Programming Using Visual Basic, Pearson, 2017.
25. Clark, L., "The Analysis and Planning of Step Drawdown Tests", Q. J. Eng. Geol. Hydrogeol., 10, 125–143, 1977.
26. Boonstra, J., "Well Design and Construction", in The Handbook of Groundwater Engineering, Delleur, J.W. (Ed.), CRC Press, Boca Raton, USA, 1999.
27. Lennox, D.H., "Analysis of Step-Drawdown Test", J. Hydraul. Div. Proc. Am. Soc. Civ. Eng., 92, 25–48, 1966.
28. Cooper, H.H., and Jacob, C.E., "A Generalized Graphical Method for Evaluating Formation Constants and Summarizing Well Field History", Eos. Trans. AGU, 27, 526–534, 1946.
29. Poulos, H., and Bunce, G., "Foundation Design For The Burj Dubai - The World's Tallest Building", 6th International Conference on Case Histories in Geotechnical Engineering, 2008.
30. Getz, K., Gilbert, M., and Litwin, P., Microsoft Office Access 2007 Developer's Guide, Microsoft Press, 2008.
31. Connell, J., VBA and Macros for Microsoft Excel, Holy Macro! Books, 2014.
32. Shekhar, S., "An approach to interpretation of step drawdown tests", Hydrogeology Journal, 14, 1018–1027, 2006.
33. Halford, K.J., Step Drawdown Test Analysis Spreadsheet (Pumping_StepDrawdown-2019.xlsm), U.S. Geological Survey, 2019.
34. Lee, H., and An, H., "TASHAn: A Python-based tool for transient analysis of step-drawdown tests", Groundwater, 59, 180–193, 2021.
35. Benson, C.A., Lin, J., and Cardiff, M., "Automated parameter estimation for variable-rate pumping tests using Python and MATLAB", Journal of Hydrologic Engineering, 28, 04022063, 2023.