PVI2D Toolkit: A new petroleum vapor intrusion screening tool for 2-D soil gas concentration profiles
This excel spreadsheet tool can replicate two-dimensional soil gas profiles of hydrocarbons and oxygen as Abreu and Johnson 3-D numerical model, and can provide very similar predictions of indoor air concentration. A sensitivity analysis and a a simplified Monte Carlo analysis is also included in the spreadsheet.
Download the spreadsheet (4 MB)
Latest Version: 1.4 (June 2021).
Release notes:
Version 1.4: This new version also includes ethylene dibromide (EDV).
Version 1.3: In this new version the user can select between two methods for estimating indoor air contaminant concentrations. The first is the classic “continuous flow stirred-tank reactor” method as employed in the Johnson and Ettinger (1991) model. This method is generally used to calculate spatially and temporally averaged indoor air concentration, given a predicted entry rate of contaminant into the structure of concern. The other method implemented in the model employs a predicted subslab concentration and an empirical subslab-to-indoor air concentration attenuation factor. In this case the subslab concentration that can be either estimated by defining a specific position or, alternatively, can be conservatively set equal to the geometric mean of the horizontal subslab concentration profile along the whole subfoundation zone.
Version 1.2: This new version accounts also for the baseline oxygen demand. Furthermore with this new version the user can select the source matrix used in the model as soil gas, soil or groundwater. Finally in this ne version the tool allows to account for the maximum possible concentration in soil gas using the Raoult’s Law to estimate the vapor pressure of each chemical in the mixture.
Source Language: Microsoft® Excel and Visual Basic for Applications (VBA)
Supported Systems: Windows with installed Microsoft® Office
The Petroleum Vapor Intrusion tool (PVI2D) is developed in Microsoft® Excel® using Visual Basic for Applications (VBA) and hence to use it you need to enable in Excel the macros.
Macro Security setting in Excel (How to)
Publications:
Model development: Yao, Y., Verginelli, I., Suuberg, E. M. (2016). A two-dimensional analytical model of petroleum vapor intrusion. Water Resources Research. See Publication.
Tool development: Verginelli, I., Yao, Y., Suuberg, E. M. (2016). An Excel®-Based Visualization Tool of Two-Dimensional Soil Gas Concentration Profiles in Petroleum Vapor Intrusion. Groundwater Monitoring & Remediation, 36(2), 94-100. See Publication.
Comparison with Abreu–Johnson’s Model: Yao, Y., Wang, Y., Verginelli, I., Suuberg, E. M., Ye, J. (2016). Comparison between PVI2D and Abreu–Johnson’s Model for Petroleum Vapor Intrusion Assessment. Vadose Zone Journal, 15(11). See Publication.
For more info:
Iason Verginelli
University of Rome "Tor Vergata"
Email Address: verginelli@ing.uniroma2.it
Yijun Yao
College of Environmental & Resource Sciences, Zhejiang University
Email Address: Yijun_Yao@zju.edu.cn