Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections

[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 uncon...

Descripción completa

Detalles Bibliográficos
Autores: Gómez-Hernández, J. Jaime|||0000-0002-0720-2196, Secci, Daniele
Tipo de recurso: artículo
Fecha de publicación:2024
País:España
Institución:Universitat Politècnica de València (UPV)
Repositorio:RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia
Idioma:inglés
OAI Identifier:oai:riunet.upv.es:10251/211448
Acceso en línea:https://riunet.upv.es/handle/10251/211448
Access Level:acceso abierto
Palabra clave:Learning by spreadsheets
Excel
Iterative solutions
INGENIERIA HIDRAULICA
id ES_41f32e80e66b726f5e29cbfb59fa3fad
oai_identifier_str oai:riunet.upv.es:10251/211448
network_acronym_str ES
network_name_str España
repository_id_str
spelling Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-SectionsGómez-Hernández, J. Jaime|||0000-0002-0720-2196Secci, DanieleLearning by spreadsheetsExcelIterative solutionsINGENIERIA HIDRAULICA[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.Springer-VerlagDepartamento de Ingeniería Hidráulica y Medio AmbienteInstituto Universitario de Ingeniería del Agua y del Medio AmbienteEscuela Técnica Superior de Ingeniería de Caminos, Canales y PuertosEuropean CommissionAgencia Estatal de InvestigaciónRepositorio Institucional de la Universitat Politècnica de València Riunet20242024-08-01journal articlehttp://purl.org/coar/resource_type/c_6501VoRhttp://purl.org/coar/version/c_970fb48d4fbd8a85info:eu-repo/semantics/articleapplication/pdfapplication/pdfhttps://riunet.upv.es/handle/10251/211448reponame:RiuNet. Repositorio Institucional de la Universitat Politécnica de Valénciainstname:Universitat Politècnica de València (UPV)InglésengAgencia Estatal de Investigación http://dx.doi.org/10.13039/501100011033 Plan Estatal de Investigación Científica y Técnica y de Innovación 2017-2020 PID2019-109131RB-I00 APRENDIZAJE AUTOMATICO PARA HIDROGEOLOGOS FORENSESEuropean Molecular Biology Organization https://doi.org/10.13039/100004410 2222open accesshttp://purl.org/coar/access_right/c_abf2Reserva de todos los derechoshttp://rightsstatements.org/vocab/InC/1.0/info:eu-repo/semantics/openAccessoai:riunet.upv.es:10251/2114482026-06-13T07:49:27Z
dc.title.none.fl_str_mv Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
title Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
spellingShingle Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
Gómez-Hernández, J. Jaime|||0000-0002-0720-2196
Learning by spreadsheets
Excel
Iterative solutions
INGENIERIA HIDRAULICA
title_short Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
title_full Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
title_fullStr Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
title_full_unstemmed Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
title_sort Teaching Numerical Groundwater Flow Modeling with Spreadsheets: Unconfined Aquifers and Multilayered Vertical Cross-Sections
dc.creator.none.fl_str_mv Gómez-Hernández, J. Jaime|||0000-0002-0720-2196
Secci, Daniele
author Gómez-Hernández, J. Jaime|||0000-0002-0720-2196
author_facet Gómez-Hernández, J. Jaime|||0000-0002-0720-2196
Secci, Daniele
author_role author
author2 Secci, Daniele
author2_role author
dc.contributor.none.fl_str_mv Departamento de Ingeniería Hidráulica y Medio Ambiente
Instituto Universitario de Ingeniería del Agua y del Medio Ambiente
Escuela Técnica Superior de Ingeniería de Caminos, Canales y Puertos
European Commission
Agencia Estatal de Investigación
Repositorio Institucional de la Universitat Politècnica de València Riunet
dc.subject.none.fl_str_mv Learning by spreadsheets
Excel
Iterative solutions
INGENIERIA HIDRAULICA
topic Learning by spreadsheets
Excel
Iterative solutions
INGENIERIA HIDRAULICA
description [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.
publishDate 2024
dc.date.none.fl_str_mv 2024
2024-08-01
dc.type.none.fl_str_mv journal article
http://purl.org/coar/resource_type/c_6501
VoR
http://purl.org/coar/version/c_970fb48d4fbd8a85
dc.type.openaire.fl_str_mv info:eu-repo/semantics/article
format article
dc.identifier.none.fl_str_mv https://riunet.upv.es/handle/10251/211448
url https://riunet.upv.es/handle/10251/211448
dc.language.none.fl_str_mv Inglés
eng
language_invalid_str_mv Inglés
language eng
dc.relation.none.fl_str_mv Agencia Estatal de Investigación http://dx.doi.org/10.13039/501100011033 Plan Estatal de Investigación Científica y Técnica y de Innovación 2017-2020 PID2019-109131RB-I00 APRENDIZAJE AUTOMATICO PARA HIDROGEOLOGOS FORENSES
European Molecular Biology Organization https://doi.org/10.13039/100004410 2222
dc.rights.none.fl_str_mv open access
http://purl.org/coar/access_right/c_abf2
Reserva de todos los derechos
http://rightsstatements.org/vocab/InC/1.0/
dc.rights.openaire.fl_str_mv info:eu-repo/semantics/openAccess
rights_invalid_str_mv open access
http://purl.org/coar/access_right/c_abf2
Reserva de todos los derechos
http://rightsstatements.org/vocab/InC/1.0/
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
application/pdf
dc.publisher.none.fl_str_mv Springer-Verlag
publisher.none.fl_str_mv Springer-Verlag
dc.source.none.fl_str_mv reponame:RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia
instname:Universitat Politècnica de València (UPV)
instname_str Universitat Politècnica de València (UPV)
reponame_str RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia
collection RiuNet. Repositorio Institucional de la Universitat Politécnica de Valéncia
repository.name.fl_str_mv
repository.mail.fl_str_mv
_version_ 1869406889949790208
score 15,812455

Similares en LA Referencia