An Excel®-based visualization tool of 2-D soil gas concentration profiles in petroleum vapor intrusion.
In this study we present a petroleum vapor intrusion tool implemented in Microsoft®Excel®using Visual Basic for Applications (VBA) and integrated within a graphical interface. The latter helps users easily visualize two-dimensional soil gas concentration profiles and indoor concentrations as a function of site-specific conditions such as source strength and depth, biodegradation reaction rate constant, soil characteristics and building features. This tool is based on a two-dimensional explicit analytical model that combines steady-state diffusion-dominated vapor transport in a homogeneous soil with a piecewise first-order aerobic biodegradation model, in which rate is limited by oxygen availability. As recommended in the recently released United States Environmental Protection Agency's final Petroleum Vapor Intrusion guidance, a sensitivity analysis and a simplified Monte Carlo uncertainty analysis are also included in the spreadsheet.
Laboratory of Environmental Engineering, Department of Civil Engineering and Computer Science Engineering, University of Rome "Tor Vergata", Via del Politecnico, 100133 Rome, Italy.
Iason
I
Verginelli
MOE Key Lab of Environmental Remediation and Ecosystem Health, College of Environmental and Resource Sciences, Zhejiang University, Hangzhou 310058, China; Research Center for Air Pollution and Health, Zhejiang University, Hangzhou 310058, China; Institute of Environmental Science, Zhejiang University, Hangzhou 310058, China.
Yijun
Y
Yao
School of Engineering, Brown University, Providence, RI 02912, USA.
Eric M
EM
Suuberg