Brown University

An Excel ® -Based Visualization Tool of Two- Dimensional Soil Gas Concentration Profiles in Petroleum Vapor Intrusion

Description

Abstract:
We present a petroleum vapor intrusion (PVI) tool implemented in Microsoft ® Excel ® using Visual Basic for Applications 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 PVI guidance, a sensitivity analysis and a simplified Monte Carlo uncertainty analysis are also included in the spreadsheet.
Notes:
This research is supported by the National Institute of Environmental Health Sciences (NIEHS) Superfund Research Program P42ES013660

Access Conditions

Use and Reproduction
Attribution 4.0 International (CC BY 4.0)

Citation

YVerginelli, Iason, Yao, Yijun, and Suuberg, Eric M., "An Excel ® -Based Visualization Tool of Two- Dimensional Soil Gas Concentration Profiles in Petroleum Vapor Intrusion" (2016). Brown Superfund Project 3: Indoor Air Concentration Dynamics and Vapor Intrusion Digital Archive, Brown Superfund Presentations & Publications. Brown Digital Repository. Brown University Library. https://repository.library.brown.edu/studio/item/bdr:841696/

Relations

Collections: