Related Experiment Video
Updated: Mar 8, 2026

Measuring Carbon-based Contaminant Mineralization Using Combined CO2 Flux and Radiocarbon Analyses
Published on: October 21, 2016
An Excel®-based visualization tool of 2-D soil gas concentration profiles in petroleum vapor intrusion
Iason Verginelli1, Yijun Yao2, Eric M Suuberg3
1Laboratory of Environmental Engineering, Department of Civil Engineering and Computer Science Engineering, University of Rome "Tor Vergata", Via del Politecnico, 100133 Rome, Italy.
Abstract:
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.
Related Concept Videos
Volatilization
Vapor Pressure of Fluid
When a liquid is placed in a closed container with a small air space, and the space is evacuated, vapor molecules will...
pV-Diagrams
Vapor Pressure
Vaporization
Gas Solubility

