A Spreadsheet Tool for Reconstruction of Vertical Groundwater Concentration Profiles
Groundwater · 02.11.2026
DOI: 10.1111/gwat.70126 ↗Kurz gefasst
Fachartikel in der Zeitschrift Groundwater, online erschienen am 02.11.2026. Verfasst von Klaudio Peshtani und 4 weiteren Autor:innen. Beteiligte Einrichtung: Energy & Environmental Directorate, Pacific Northwest National Laboratory, 901 Battelle Boulevard, Richland, WA, 99352. Die Arbeit nennt 12 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0). Gefördert von: Environmental Management Headquarters Technology Operations Office.
Abstract (Originalsprache)
This methods brief introduces FLARE (Flow‐Log Analysis with Radial Exchange), a spreadsheet‐based inverse modeling tool for reconstruction of the vertical concentration profile (VCP) around long‐screened wells or open boreholes affected by borehole flow. In such wells, vertical flow and radial exchange can mix water from multiple aquifer intervals, causing sampled concentrations to differ from true aquifer conditions. FLARE uses flow logs and sampled concentrations to construct a forward flow‐and‐mixing model and formulate a regularized inverse problem to reconstruct the VCP in the aquifer surrounding the well. Implemented entirely in Excel without macros, the tool provides accessible calculations, traceable formulas, and diagnostic outputs that quantify sensitivity, model resolution, and estimation uncertainty (i.e., posterior covariance). These diagnostics help distinguish well‐constrained intervals from those where limited information or unfavorable flow conditions reduce interpretive confidence. An example application demonstrates how flow‐controlled mixing can cause sampled concentrations to misrepresent local aquifer conditions and documents the use and interpretation of FLARE's inversion and diagnostic results. FLARE enables practitioners to evaluate borehole‐flow impacts, extract more information from existing wells, and better target additional depth‐discrete characterization or focus remediation efforts where needed.
Autor:innen und Institutionen
- Energy & Environmental Directorate, Pacific Northwest National Laboratory, 901 Battelle Boulevard, Richland, WA, 99352.
ORCID-Profile: Klaudio Peshtani, Rebecka Iveson, Judith Robinson, Frederick D Day-Lewis
Förderung
- Environmental Management Headquarters Technology Operations Office
Zitieren
APA
Peshtani, K., Iveson, R., Robinson, J., Mackley, R. D., & Day-Lewis, F. D. (2026). A Spreadsheet Tool for Reconstruction of Vertical Groundwater Concentration Profiles. Groundwater. https://doi.org/10.1111/gwat.70126
Vancouver
Peshtani K, Iveson R, Robinson J, Mackley RD, Day-Lewis FD. A Spreadsheet Tool for Reconstruction of Vertical Groundwater Concentration Profiles. Groundwater. 2026. doi:10.1111/gwat.70126
BibTeX
@article{Peshtani2026,
author = {Peshtani, Klaudio and Iveson, Rebecka and Robinson, Judith and Mackley, Robert D and Day-Lewis, Frederick D},
title = {A Spreadsheet Tool for Reconstruction of Vertical Groundwater Concentration Profiles},
journal = {Groundwater},
year = {2026},
doi = {10.1111/gwat.70126}
}
EUVIMED