Downloads provided by UsageCounts
handle: 10251/211448 , 11381/2975354
[EN] The use of spreadsheets in numerical groundwater flow modeling, although not new, has yet to be fully exploited in educational settings. This teaching aid complements the one published earlier, broadening its scope from the numerical solution for a single-layer confined aquifer to include unconfined aquifers. It covers flow in horizontal layers and multilayered vertical cross-sections. The new spreadsheets can also handle hydraulic conductivity anisotropy, provided its principal directions align with the Cartesian axes. It can also manage irregular aquifer shapes, incorporate all three types of boundary conditions, and account for pumping and recharge in the modeling process. However, the flow regime remains at steady state. With the integration of these new features, the spreadsheet model becomes a versatile tool for simulating a great number of steady-state groundwater flow situations. This user-friendly platform enables students to swiftly experiment with diverse configurations, delve into the underlying mathematical expressions, and gain insight into the workings of more sophisticated numerical codes like MODFLOW. As a complement, and for verification purposes, Python Flopy scripts are provided for all examples in the GitHub repository where the spreadsheets can be accessed.
The first author acknowledges grant PID2019-109131RB-I00 funded by MCIN/AEI/10.13039/501100011033 and project OurMED, which is part of the PRIMA Programme supported by the European Union's Horizon 2020 Research and Innovation Programme under Grant Agreement No. 2222.
Learning by spreadsheet, INGENIERIA HIDRAULICA, 550, Learning by spreadsheets, Excel, 510, Iterative solutions
Learning by spreadsheet, INGENIERIA HIDRAULICA, 550, Learning by spreadsheets, Excel, 510, Iterative solutions
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 1 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
| views | 32 | |
| downloads | 13 |

Views provided by UsageCounts
Downloads provided by UsageCounts