Instructions for the New Jersey Johnson & Ettinger (J&E) Spreadsheets
NJ-GW-SCREEN and NJ-GW-ADV
The New Jersey versions of the USEPA J&E Spreadsheets are adapted from the USEPA version 3.1 spreadsheet formulations of the Johnson and Ettinger model
(see User's Guide for Evaluating Subsurface Vapor Intrusion into Buildings | Risk Assessment | US EPA for additional information).
The GW-SCREEN and GW-ADV spreadsheets have been adapted for New Jersey use (NJ-GW-SCREEN and NJ-GW-ADV). The following modifications have been made to the USEPA
versions of the spreadsheets:
The VLOOKUP database was changed to contain the current New Jersey contaminant list.
Chemical properties for the contaminants were updated.
Toxicity factors for the contaminants were updated.
Default soil/groundwater temperature is set to 13°C.
Default depth to groundwater is set to 11.5 feet (352.5 cm).
General Guidelines for Using the New Jersey J&E Spreadsheets
The only J&E parameters allowed to be adjusted site-specifically are soil texture and depth to groundwater.
A soil/groundwater temperature of 13°C must be used.
The standard values for soil properties associated with each soil texture that are built into the spreadsheet database must be used. The use of field or
laboratory-measured values for soil moisture, soil bulk density and soil porosity is not allowed.
For hydrocarbons (benzene, cyclohexane, ethylbenzene, n-hexane, naphthalene, styrene, toluene, 1,2,4-trimethylbenzene, and xylene), a multiplication factor of
ten may be applied to the calculated ground water screening level to allow for contaminant degradation.
Site-Specific Adjustments Using the New Jersey J&E Spreadsheets
Using an alternate soil texture (no soil layers) (NJ-GW-SCREEN or NJ-GW-ADV).
If a soil texture other than sand is to be used, collect soil core(s) and submit samples to laboratory for texture analysis, as described in the most recent NJDEP
Vapor Intrusion Technical Guidance. The median USDA soil texture should be determined. A median soil texture means that half of the vertical soil column height
should exhibit a texture coarser than or equal to the selected soil texture, and the other half of the soil column should have a texture finer than or equal to the
selected soil texture.
- Select the appropriate soil texture in the spreadsheet.
- Select the built-in soil properties for the soil texture.
Using site-specific soil texture layers (NJ-GW-ADV spreadsheet only)
Layers must be continuous across the site and may not be fractured, as demonstrated by soil borings.
Enter the depth range of each soil layer in the advanced version of J&E spreadsheet (NJ-GW-ADV). Select the built-in soil properties for each layer.
Modifying the depth to ground water (NJ-GW-SCREEN or NJ-GW-ADV)
Enter the depth of the water table on either the screening (NJ-GW-SCREEN) or advanced (NJ-GW-ADV) spreadsheet.
Download the Spreadsheets
We recommend you download these spreadsheets to your computer before
working with them. They might not work properly if open in a Web
You will need Microsoft Excel or compatible spreadsheet software.
Be sure to configure the spreadsheet software to allow macros to
run. Otherwise, the spreadsheets' programming will not work.
Help for Using the File Formats