The MariaJ code was created by José Alberto Carbonell, Alfredo Pérez Aparicio and Jesús Carrera Ramírez in 1997 (Carbonell et al., 1997). It includes several models for interpreting pumping tests as Theis, Hantush, General (Baker), Anisotropy 3D (Hseih and Neuman).
The quantification of the hydraulic parameters is important to support decision making in environmental impact assessment, water resources evaluation or groundwater contamination remediation, among others. These kind of parameters derived from aquifer tests usually encompasses a vast amount of data (spatial and non-spatial) for management and analysis.
To achieve this in a clear and understandable manner, the use of the most popular software could be a useful instrument. Development on popular software as Excel (Microsoft) to analyze pumping tests to support the hydraulic parameterization of groundwater flow and transport models is presented.
MJ-Pumpit v.3, developed for MS Excel 2010® (MJ-Pumpit.xlsm), is an interface for the MariaJ code and makes it possible to apply diagnostic plots and create other pumping tests interpretation methods through the use of the tools offered by MS Excel.
This new platform provides three interconnected modules to improve (a) pumping test interpretation code through a user-friendly interface, (b) pumping test data visualization supported by the own MS Excel tools and (c) the storage and management of hydrogeological information. Additionally, MJ-Pumpit can connect with the GIS platform (HYYH toolbar) to process the hydraulic parameters obtained from the pumping test and to create spatial distribution maps.
Estimation of hydraulic parameters from pumping tests. MJ-Pumpit is a Graphical User Interface for MariaJ code (hereinafter MJ) which simplifies the data handle and the model selection needed to execute MJ code (Carbonell et al., 1997). Thus, MJ-Pumpit has been developed as a MS Excel Add-in. The use of MS Excel spreadsheets as platform is due to: (a) ensure a portable and handled easily format; (b) easy performing of data queries, analysis and plots; (c) its user-friendly interface to create numerical and statistical computations; (d) user can apply special tools to fix contradictory data storage or check potential mistakes; (e) most of hydrogeologist utilize fluently these type of programs, among others. In this way, MJ-Pumpit has available many of the MS Excel tools to analyze and plot input and output data to ease the pumping test interpretation with analytical models for different aquifer test included in MJ code. MJ-Pumpit is composed of different commands that facilitate the interpretation process of pumping test interpretation and allow:
- Error typing avoidance during the field data insertion process.
- Field data quality analysis improvement thanks to the wide possibilities of data analysis of MS Excel before executing the code.
- Ensuring an appropriate selection of the conceptual model thanks to diagnostic plots.
- The integration of different aquifer scenarios by different methodologies of pumping test analysis: Theis (1935), Hantush (1956), Barker (1988) and Hseih and Neuman (1985a). Furthermore, other characteristics are available like edges (recharge or waterproof), pumping well loss (linear and quadratic), double porosity, wellbore pumping storage and anisotropy parameters, among others.
- Results display from the iterative process through automatically generated reports and graphical plots of fitted and measured values. Their formats can be changed as user wants with MS Excel capabilities.
- MJ-Pumpit can be used in six different languages.
Ref: Criollo, R.; Velasco, V.; Vàzquez-Suñé, E.; Serrano-Juan, A.; Alcaraz, M.; García-Gil, A. (2016). An integrated GIS-based tool for Aquifer Test Analysis. ENVIRONMENTAL EARTH SCIENCES, doi:10.1007/s12665-016-5292-3
The previous interface of MariaJ code is EPHEBO (http://h2ogeo.upc.edu/en/investigation-hydrogeology/software/156-ephebo-en)