Customization, extension and reuse of outdated hydrogeological software


  • A. Serrano-Juan Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain)
  • R. Criollo Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain) GHS, Department of Geotechnical Engineering and Geosciences, Universitat Politècnica de Catalunya (UPC) Jordi Girona 1-3, Building D 2, 08034 Barcelona (Spain) Barcelona Cicle de l’Aigua SA (BCASA) Carrer de l’Acer 16, 08038 Barcelona, Spain
  • E. Vázquez-Suñé Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain)
  • M. Alcaraz Instituto de Hidrología de Llanuras “Dr. Eduardo Usunoff” República de Italia 78, B7300 Azul, Provincia de Buenos Aires, Argentina. Consejo Nacional de Investigaciones Científicas (CONICET) Av. Rivadavia, 1917, C1066AAJ Ciudad Autónoma de Buenos Aires, Argentina.
  • C. Ayora Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain)
  • V. Velasco Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain)
  • L. Scheiber Institute of Environmental Assessment and Water Research (IDAEA- CSIC) Jordi Girona 18-26, 08034 Barcelona (Spain)



Software improvement, Software customization, MIX, EasyQuim, EasyBal, BrineMIX.


Each scientist is specialized in his or her field of research and in the tools that he or she uses during the research in a specified site. Thus, he or she is the most suitable person for improving the tools by overcoming their limitations to realize faster and higher quality analysis. However, most scientists are not software developers. Hence, it is necessary to provide them with an easy approach that enables non-software developers to improve and customize their tools. This paper presents an approach for easily improving and customizing any hydrogeological software. It is the result of experiences with updating several interdisciplinary case studies. The main insights of this approach
have been demonstrated using four examples: MIX (FORTRAN-based), BrineMIX (C++-based), EasyQuim and EasyBal (both spreadsheet-based). The improved software has been proven to be a better tool for enhanced analysis by substantially reducing the computation time and the tedious processing of the input and output data files.


Aliane, N., 2010. Data acquisition and real-time control using spreadsheets: interfacing Excel with external hardware. ISA Transactions, July 2010, 49(3), 264-9. DOI: 10.1016/j.isatra.2010.03.009

Asuncion, H.U., 2013. Automated data provenance capture in spreadsheets, with case studies. Future Generation Computer Systems, October 2013, 29(8), 2169-2181. DOI: 10.1016/j.future.2013.04.009

Bea, S.A., Carrera, J., Ayora, C., Batlle, F., Saaltink, M.W., 2009. CHEPROO: A Fortran 90 object-oriented module to solve chemical processes in Earth Science models. Computers & Geosciences, 35 (6), 1098-1112. DOI: 10.1016/j.cageo.2008.08.010

Buccella, A., Cechich, A., Arias, M., Pol’la, M., Doldan, M.D.S., Morsan, E., 2013. Towards systematic software reuse of GIS:

Insights from a case study. Computers & Geosciences, 54, 9-20. DOI: 10.1016/j.cageo.2012.11.014

Buregio, V.A.D.A., Almeida, E.S.D., Lucredio, D., Meira, S.R.D.L., 2007. 31st IEEE Annual International Computer Software

and Applications (COMPSAC) Conference, Beijing (China), Short paper.

Cánovas, C.R., Olias, M., Vazquez-Suñé, E., Ayora, C., Nieto, J.M., 2012. Influence of releases from a fresh water reservoir on

the hydrochemistry of the Tinto River (SW Spain). Science of the Total Environment, 416, 418-428. DOI: 10.1016/j.scitotenv.2011.11.079

Carrera, J., Vázquez-Suñé, E., Castillo, O., Sánchez-Vila, X., 2004. A methodology to compute mixing ratios with uncertain

end-members. Water Resources Research, 40(12), n/a. DOI: 10.1029/2003WR002263

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, 75, 1-11. DOI: 10.1007/s12665-016-5292-3

Criollo, R., Velasco, V., Nardi, A., de Vries, L.M., Riera, C., Scheiber, L., Jurado, A., Brouyère, S., Pujades, E., Rossetto, R., VázquezSuñé, E., 2019. AkvaGIS: An open source tool for water quantity and quality management. Computers & Geosciences, 127, 123-132. DOI: 10.1016/j.cageo.2018.10.012

Cunha, J., Mendes, J., Saraiva, J., Visser, J., 2014. Model-based programming environments for spreadsheets. Science of Computer Programming, 1, 1-22. DOI: 10.1016/j.scico.2014.02.002

Deursen, A.V., Klint, P., Visser, J., 2000. Domain-specific anguages: An annotated bibliography. ACM SIGPLAN Notices, 35(6),


Devanbu, P.T., Karstu, S., Melo, W.L., Thomas, W., 1996. Analytical and empirical evaluation of software reuse metrics. Berlin (Germany), 18th International Conference on Software Engineering (ICSE), 189-199.

Elmore, A., 2007. Applying one-dimensional mass transport model using groundwater concentration data. Journal of Environmental Engineering, 133(4), 372-379.

Ibrahim, D., 2009. Using the excel spreadsheet in teaching science subjects. Procedia-Social and Behavioral Sciences, 1(1), 309-312. DOI: 10.1016/j.sbspro.2009.01.058

Jannach, D., Schmitz, T., Hofer, B., Wotawa, F., 2014. Journal of Systems and Software. DOI: 10.1016/j.jss.2014.03.058

Jisc Digital Media, 2019. Accessed: November 10, 2019. Link:

Jones, W.R., Spence, M.J., Bowman, A.W., Evers, L., Molinari, D.A., 2014. A software tool for the spatiotemporal analysis and reporting of groundwater monitoring data. Environmental Modelling & Software, 55, 242-249. DOI: 10.1016/j.envsoft.2014.01.020

Jurado, A., Vàzquez-Suñé, E., Carrera, J., Tubau, I., Pujades, E., 2015. Quantifying chemical reactions by using mixing analysis. Science of the Total Environment, 502, 448-456. DOI: 10.1016/j.scitotenv.2014.09.036

Kruchten, P.A., 2003. The Rational Unified Process: An Introduction. Boston (MA United States). Addison-Wesley Longman Publishing Co., Inc.75 Arlington Street, Suite 300, 320pp. ISBN: 978-0-321-19770-2.

Krueger, C., 1992. Software reuse. ACM Computing Surveys, 24(2), 131-183.

Lucredio, D., Almeida, E.S.d., Prado, A.F.d., 2004. A Survey on Software Components Search and Retrieval. In: 30th IEEE EUROMICRO Conference, Component-Based Software Engineering Track. Rennes (France), IEEE Computer Society Press, Los Alamitos, 152- 159.

Lucrédio, D., dos Santos Brito, K., Alvaro, A., Garcia, V.C., de Almeida, E.S., de Mattos Fortes, R.P., Meira, S.L., 2008. Software reuse: The Brazilian industry scenario. Journal of Systems and Software, 81(6), 996-1013. DOI: 10.1016/j.jss.2007.08.036

Marcus, A., 1995, Principles of Effective Visual Communication for Graphical User Interface Design. In: Readings in Human-Computer Interaction. Baecker, Grudin, Buxton and Greenberg, Morgan Kaufman, Palo Alto, 2nd edition, 425-441. ISBN: 1-55860-246-1.

Molano, C., 2013. Groundwater Spreadsheets: Efficient and Practical Resource for Solving Simple and Complex Flow, Pollution, and Environmental Problems. William A. McEllhiney Distinguished Lecture Series in Water Well Technology, 2013 NGWA Groundwater Expo and Annual Meeting, NGWA.

Parkhurst, D.L., Appelo, C.A.J., 2013, Description of input and examples for PHREEQC version 3—A computer program for speciation, batch-reaction, one-dimensional transport, and inverse geochemical calculations. U.S. Geological Survey Techniques and Methods, book 6, chap. A43, 497pp. Available at:

Phong. V.V., Kumar, P., Drewry, D.T., Quijano, J.C., 2012. A graphical user interface for numerical modeling of acclimation responses of vegetation to climate change. Computers & Geosciences, 49, 91-101. DOI: 10.1016/j.cageo.2012.07.007

Robin, B., 1995. Supporting geoscience with Graphical-UserInterface internet tools for the Macintosh. Computers & Geosciences, 21(6), 737-751.

Rossetto, R., De Filippis, G., Borsi, I., Foglia, L., Cannata, M., Criollo, R., Vázquez-Suñé, E., 2018. Integrating free and open source tools and distributed modelling codes in GIS environment for data-based groundwater management. Environmental Modelling and Software, 107, 210-230. DOI: 10.1016/j.envsoft.2018.06.007

Scheiber, L., Ayora, C., Vázquez-Suñé, E., Cendón, D., Soler, A., Custodio, E., Baquero, J.C., 2015. Recent and old groundwater

in the Niebla-Posadas regional aquifer (southern Spain): Implications for its management. Journal of Hydrology, 523, 624-635. DOI: 10.1016/j.jhydrol.2015.01.076

Scheiber, L., Ayora, C., Vázquez-Suñé, E., Cendón, D., Soler, A., Baquero, J.C., 2016. Origin of high ammonium, arsenic and

boron concentrations in the proximity of a mine: Natural vs. anthropogenic processes. Science of the Total Environment,

, 655-666. DOI: 10.1016/j.scitotenv.2015.09.098

Scheiber, L., Ayora, C., Vázquez-Suñé, E., 2018. Quantification of proportions of different water sources in a mining operation. Science of the Total Environment, 619-620, 587-620. DOI: 10.1016/j.scitotenv.2017.11.172

Serrano-Juan, A., Vázquez-Suñè, E., Monserrat, O., Crosetto, M., Hoffmann, C., Ledesma, A., Criollo, R., Pujades, E., Velasco, V., Garcia-Gil, A., Garcia-Alcaraz, M., 2016. GbSAR interferometry displacement measurements during dewatering in construction works. Case of La Sagrera railway station in Barcelona, Spain. Engineering Geology, 205, 104-115. DOI: 10.1016/j.enggeo.2016.02.014

Serrano-Juan, A., Pujades, E., Vázquez-Suñè, E., Velasco, V., Criollo, R., Jurado, A., 2018. Integration of groundwater bypass facilities in the bottom slab design for large underground structures. Tunnelling and underground space technology, 71, 231-243. DOI: 10.1016/j.tust.2017.07.020

Suri, P.K., Neeraj Garg, 2008. Simulator for evaluating Reliability of Reusable Components in a Domain Interconnection Network. International Journal of Computer Science and Network Security, 8(3), March 2008, 251-259.

Torlapati, J., Prabhakar Clement, T., 2013. Benchmarking a VisualBasic based multi-component one-dimensional reactive

transport modeling tool. Computers & Geosciences, 50, 72-83. DOI: 10.1016/j.cageo.2012.08.009

Tubau, I., Vàzquez-Suñé, E., Jurado, A., Carrera, J., 2014. Using EMMA and MIX analysis to assess mixing ratios and to identify hydrochemical reactions in groundwater. Science of the Total Environment, 470-471, 1120-1131. DOI: 10.1016/j.


Tubau, I., Vazquez-Suñe, E., Carrera, J., Valhondo, C., Criollo, R., 2017. Quantification of groundwater recharge in urban

environments. Science of the Total Environment, 592, 391-402. DOI: 10.1016/j.scitotenv.2017.03.118

Vázquez-Suñé, E., Carrera, J., Tubau, I., Sánchez-Vila, X., Soler, A., 2010. An approach to identify urban groundwater recharge. Hydrology and Earth System Sciences (HESS), 14, 2085-2097. DOI: 10.5194/hess-14-2085-2010

Velasco, V., Tubau, I., Vázquez-Suñè, E., Gogu, R., Gaitanaru, D., Alcaraz, M., Serrano-Juan, A., Fernàndez-Garcia, D., Garrido, T., Fraile, J., Sanchez-Vila, X., 2014. GIS-based hydrogeochemical analysis tools (QUIMET). Computers & Geosciences, 70, 164-180. DOI: 10.1016/j.cageo.2014.04.013

Verplank, W.L., 1985. Graphics in human-computer communication: Principles of graphical user-interface design. Proceedings of the IFIP-IMIA Second Stockholm Conference on Communication in Health Care. Stockholm (Sweden), H.E.

Peterson and W. Schneider, 13-130.

Wang, J.-P., Huang, D., 2012. RosenPoint: A Microsoft Excelbased program for the Rosenblueth point estimate method and an application in slope stability analysis. Computers & Geosciences, 48, 239-243. DOI: 10.1016/j.cageo.2012.01.009

Wang, J.-P., Huang, D., Yang, Z., 2012. Deterministic seismic hazard map for Taiwan developed using an in-house Excelbased program. Computers & Geosciences, 48, 111-116. DOI: 10.1016/j.cageo.2012.05.014

Wang, J.-P., Huang, D., Cheng, C.-T., Shao, K.-S., Wu, Y.-C., Chang, C.-W., 2013. Seismic hazard analyses for Taipei city including deaggregation, design spectra, and time history with excel applications. Computers & Geosciences, 52, 146-154. DOI: 10.1016/j.cageo.2012.09.021