This paper extends our previous work on spreadsheet-based steady-state groundwater flow modeling to include transient conditions. Using a step-by-step Excel implementation, a numerical solution for transient groundwater flow in a confined aquifer is presented, highlighting the spreadsheet’s educational value in understanding complex groundwater flow phenomena. Implementing transient flow in an easy-to-visualize and interactive way in Excel was not trivial and required the use of macros created with Visual Basic for Applications. Although the actions of the macros were simple to describe, their implementation was challenging. For this reason, we used ChatGPT as a coding companion, which provided the code after being provided with carefully designed prompts
15-09-2025
08-09-2025
This study uses a coupled hydrological model (mHM + MODFLOW) to simulate the evolution of the active river network in Germany’s Bode catchment (2000–2022), focusing on the 2018–2022 drought. This contraction has significant impacts on water resources, ecosystems, and water quality.
25-06-2025
The paper presents a numerical simulation and optimization of the Agia aquifer in Crete, aiming to maximize groundwater extraction while minimizing pumping costs using the Princeton Transport Code and Gurobi solver. The model, calibrated with real data from 2017 to 2021, incorporates hydraulic and economic constraints for both dry and wet seasonal scenarios.
19-05-2025
This study demonstrates that using a small, diverse Mix dataset (999 images) improves transferability, reduces costs, and optimizes floating macroplastic detection with YOLOv7 and YOLOv8, highlighting that dataset quality and heterogeneity are critical for global-scale detection.
29-04-2025
This study presents an open-source SQL platform integrated with Metabase to unify and visualize hydrometeorological data in Crete. It improves data access, supports decision-making on water risks, and encourages collaboration between public and private weather stations.
14-04-2025
OurMED is part of the PRIMA programme supported by the European Union.