{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Master database","VI-IASG-ExistChem-Res","VI-IASG-NewChem-Res","VI-IASG-ExistChem-Nonres","VI-IASG-NewChem-Nonres","Sheet1"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Master database","index":0,"n_rows":227,"n_cols":7,"rows_kept":227,"cut":false,"hidden":false,"merged":[[210,1,210,2],[211,1,211,2],[224,1,224,2],[225,1,225,2]]}
[null,"Chemical","CAS No. ","2018 Standards Inhalation Unit Risk Factor (µg/m3)-1","2018 Standards Inhalation Reference Concentration (mg/m3)","2018 Air analytical reporting limit, Method TO-15 (µg/m3)","2018 Soil gas analytical reporting limit, Method TO-15 (µg/m3)"]
[1,"Acenaphthene","83-32-9","NA","NA"]
[3,"Acetone (2-Propanone)","67-64-1","NA","NA",12,{"$f":"F3*10","v":120}]
[4,"Acetophenone","98-86-2","NA","NA"]
[7,"Aldrin","309-00-2","NA","NA"]
[8,"Aluminum (total)","7429-90-5","NA",5.0000000000000001E-3]
[9,"Anthracene","120-12-7","NA","NA"]
[10,"Antimony (total)","7440-36-0","NA","NA"]
[11,"Arsenic (total)","7440-38-2",4.3E-3,"NA"]
[12,"Atrazine","1912-24-9","NA","NA"]
[13,"Barium (total)","7440-39-3","NA",5.0000000000000001E-4]
[14,"Benzaldehyde","100-52-7","NA","NA"]
[15,"Benzene","71-43-2",7.7999999999999999E-6,0.03,0.64,{"$f":"F13*10","v":6.4}]
[17,"Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3",6.0000000000000002E-5,"NA"]
[18,"Benzo(a)pyrene","50-32-8",5.9999999999999995E-4,1.9999999999999999E-6]
[19,"Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2",6.0000000000000002E-5,"NA"]
[21,"Benzo(k)fluoranthene","207-08-9",6.0000000000000002E-6,"NA"]
[23,"Beryllium","7440-41-7",2.3999999999999998E-3,2.0000000000000002E-5]
[24,"1,1'-Biphenyl","92-52-4","NA","NA"]
[25,"Bis(2-chloroethoxy)methane","111-91-1","NA","NA"]
[26,"Bis(2-chloroethyl)ether","111-44-4","NA","NA"]
[27,"Bis(2-ethylhexyl)phthalate","117-81-7","NA","NA"]
[28,"Bromodichloromethane (Dichlorobromomethane)","75-27-4","NA","NA",1.3,{"$f":"F23*10","v":13}]
[30,"Bromoform","75-25-2","NA","NA",2.1,{"$f":"F24*10","v":21}]
[31,"Bromomethane (Methyl bromide)","74-83-9","NA",5.0000000000000001E-3,0.78,{"$f":"F25*10","v":7.8000000000000007}]
[33,"2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3","NA",5,1.5,{"$f":"F26*10","v":15}]
[34,"Butylbenzyl phthalate","85-68-7","NA","NA"]
[35,"Cadmium","7440-43-9",1.8E-3,1.0000000000000001E-5]
[36,"Caprolactam","105-60-2","NA",2.2000000000000001E-3]
[38,"Carbon disulfide","75-15-0","NA",0.7,1.6,{"$f":"F30*10","v":16}]
[39,"Carbon tetrachloride","56-23-5",6.0000000000000002E-6,0.1,1.3,{"$f":"F31*10","v":13}]
[40,"Chlordane (alpha and gamma forms summed)","57-74-9","NA",6.9999999999999999E-4]
[41,"4-Chloroaniline","106-47-8","NA","NA"]
[42,"Chlorobenzene","108-90-7","NA",0.05,0.92,{"$f":"F34*10","v":9.2000000000000011}]
[44,"Chloroethane (Ethyl chloride)","75-00-3","NA",10,1.3,{"$f":"F35*10","v":13}]
[45,"Chloroform","67-66-3","NA",9.8000000000000004E-2,0.98,{"$f":"F36*10","v":9.8000000000000007}]
[46,"Chloromethane (Methyl chloride)","74-87-3","NA",0.09,1,{"$f":"F37*10","v":10}]
[48,"2-Chloronaphthalene","91-58-7","NA","NA"]
[49,"2-Chlorophenol (o-Chlorophenol)","95-57-8","NA","NA"]
[52,"Chrysene","218-01-9",5.9999999999999997E-7,"NA"]
[53,"Cobalt (total)","7440-48-4",8.9999999999999993E-3,6.0000000000000002E-6]
[54,"Copper (total)","7440-50-8","NA","NA"]
[55,"Cyanide","57-12-5","NA",8.0000000000000004E-4]
[56,"Cyclohexane","110-82-7","NA",6,0.69,{"$f":"F44*10","v":6.8999999999999995}]
[57,"4,4'-DDD (p,p'-TDE)","72-54-8","NA","NA"]
[58,"4,4'-DDE (p,p'-DDX)","72-55-9","NA","NA"]
[59,"4,4'-DDT","50-29-3","NA","NA"]
[60,"Dibenz(a,h)anthracene","53-70-3",5.9999999999999995E-4,"NA"]
[61,"Dibromochloromethane (Chlorodibromomethane)","124-48-1","NA","NA",1.7,{"$f":"F49*10","v":17}]
[62,"1,2-Dibromo-3-chloropropane","96-12-8",6.0000000000000001E-3,2.0000000000000001E-4]
[63,"1,2-Dibromoethane (Ethylene dibromide)","106-93-4",5.9999999999999995E-4,8.9999999999999993E-3,1.5,{"$f":"F51*10","v":15}]
[64,"1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1","NA",0.2,1.2,{"$f":"F52*10","v":12}]
[65,"1,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-1","NA","NA"]
[66,"1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7","NA",0.8,1.2,{"$f":"F54*10","v":12}]
[67,"3,3'-Dichlorobenzidine","91-94-1","NA","NA"]
[68,"Dichlorodifluoromethane (Freon 12)","75-71-8","NA","NA",2.5,{"$f":"F56*10","v":25}]
[69,"1,1-Dichloroethane","75-34-3","NA","NA",0.81,8.1000000000000014]
[70,"1,2-Dichloroethane","107-06-2","NA",7.0000000000000001E-3,0.81,8.1000000000000014]
[71,"1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4","NA",0.02,0.79,7.9]
[72,"1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2","NA","NA",0.79,7.9]
[73,"1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5","NA","NA",0.79,7.9]
[75,"2,4-Dichlorophenol","120-83-2","NA","NA"]
[76,"1,2-Dichloropropane","78-87-5",3.7000000000000002E-6,4.0000000000000001E-3,0.92,{"$f":"F63*10","v":9.2000000000000011}]
[77,"1,3-Dichloropropene (total)","542-75-6",3.9999999999999998E-6,0.02,0.91,{"$f":"F64*10","v":9.1}]
[78,"Dieldrin","60-57-1","NA","NA"]
[79,"Diethylphthalate","84-66-2","NA","NA"]
[80,"2,4-Dimethylphenol","105-67-9","NA","NA"]
[82,"Di-n-butyl phthalate","84-74-2","NA","NA"]
[84,"2,4-Dinitrophenol","51-28-5","NA","NA"]
[87,"2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6","NA","NA"]
[88,"Di-n-octyl phthalate","117-84-0","NA","NA"]
[89,"1,4-Dioxane","123-91-1",5.0000000000000004E-6,0.03,0.72,{"$f":"F72*10","v":7.1999999999999993}]
[91,"Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7","NA","NA"]
[93,"Endrin","72-20-8","NA","NA"]
[94,"Ethylbenzene","100-41-4",2.5000000000000002E-6,1,0.87,{"$f":"F75*10","v":8.6999999999999993}]
[95,"Extractable Petroleum Hydrocarbons (No. 2 Fuel Oil and Diesel)","various ","NA","NA"]
[95,"Extractable Petroleum Hydrocarbons (Other)","various","NA","NA"]
[96,"Fluoranthene","206-44-0","NA","NA"]
[97,"Fluorene","86-73-7","NA","NA"]
[98,"alpha-HCH (alpha-BHC)","319-84-6","NA","NA"]
[99,"beta-HCH (beta-BHC)","319-85-7","NA","NA"]
[100,"Heptachlor","76-44-8","NA","NA"]
[101,"Heptachlor epoxide","1024-57-3","NA","NA"]
[102,"Hexachlorobenzene","118-74-1","NA","NA"]
[103,"Hexachloro-1,3-butadiene","87-68-3","NA","NA",2.1,{"$f":"F85*10","v":21}]
[104,"Hexachlorocyclopentadiene","77-47-4","NA",2.0000000000000001E-4]
[105,"Hexachloroethane","67-72-1","NA",0.03]
[106,"n-Hexane","110-54-3","NA",0.7,0.7,{"$f":"F88*10","v":7}]
[107,"2-Hexanone","591-78-6","NA",0.03]
[108,"Indeno(1,2,3-cd)pyrene","193-39-5",6.0000000000000002E-5,"NA"]
[110,"Isophorone","78-59-1","NA",2]
[111,"Isopropylbenzene","98-82-8","NA",0.4]
[112,"Lead (total)","7439-92-1","NA","NA"]
[113,"Lindane (gamma-HCH)(gamma-BHC)","58-89-9","NA","NA"]
[115,"Manganese (total)","7439-96-5","NA",5.0000000000000002E-5]
[116,"Mercury (total)","7439-97-6","NA",2.9999999999999997E-4,1,{"$f":"F96*10","v":10}]
[117,"Methoxychlor","72-43-5","NA","NA"]
[118,"Methyl acetate","79-20-9","NA","NA"]
[120,"Methylene chloride (Dichloromethane)","75-09-2",1E-8,0.6,1.7,{"$f":"F99*10","v":17}]
[121,"2-Methylnaphthalene","91-57-6","NA","NA"]
[122,"4-Methyl-2-pentanone (MIBK)","108-10-1","NA",3,2,{"$f":"F101*10","v":20}]
[123,"2-Methylphenol (o-cresol)","95-48-7","NA","NA"]
[124,"4-Methylphenol (p-cresol)","106-44-5","NA","NA"]
[125,"Methyl tert-butyl ether (MTBE)","1634-04-4",2.6E-7,3,0.72,{"$f":"F104*10","v":7.1999999999999993}]
[126,"Naphthalene","91-20-3",3.4E-5,3.0000000000000001E-3,2.6,{"$f":"F105*10","v":26}]
[127,"Nickel (total)","7440-02-0",2.4000000000000001E-4,1.4E-5]
[129,"4-Nitroaniline","100-01-6","NA",6.0000000000000001E-3]
[131,"Nitrobenzene","98-95-3",4.0000000000000003E-5,8.9999999999999993E-3]
[132,"N-Nitrosodi-n-propylamine","621-64-7","NA","NA"]
[133,"N-Nitrosodiphenylamine","86-30-6","NA","NA"]
[134,"2,2'-oxybis(1-chloropropane)","108-60-1","NA","NA"]
[135,"Pentachlorophenol","87-86-5","NA","NA"]
[137,"Phenol","108-95-2","NA",0.2]
[138,"Polychlorinated biphenyls (PCBs)","1336-36-3","NA","NA"]
[139,"Pyrene","129-00-0","NA","NA"]
[140,"Selenium (total)","7782-49-2","NA","NA"]
[141,"Silver (total)","7440-22-4","NA","NA"]
[142,"Styrene","100-42-5","NA",1,0.85,{"$f":"F118*10","v":8.5}]
[143,"Tertiary butyl alcohol (TBA)","75-65-0","NA","NA"]
[144,"1,2,4,5-Tetrachlorobenzene","95-94-3","NA","NA"]
[145,"2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-01-6","NA","NA"]
[147,"1,1,2,2-Tetrachloroethane","79-34-5","NA","NA",1.4,{"$f":"F122*10","v":14}]
[148,"Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4",2.6E-7,0.04,1.4,{"$f":"F123*10","v":14}]
[149,"2,3,4,6-Tetrachlorophenol","58-90-2","NA","NA"]
[151,"Toluene","108-88-3","NA",5,0.75,{"$f":"F125*10","v":7.5}]
[152,"Toxaphene","8001-35-2","NA","NA"]
[153,"1,2,4-Trichlorobenzene","120-82-1","NA",2E-3,3.7,{"$f":"F127*10","v":37}]
[154,"1,1,1-Trichloroethane","71-55-6","NA",5,1.1000000000000001,{"$f":"F128*10","v":11}]
[155,"1,1,2-Trichloroethane","79-00-5","NA","NA",1.1000000000000001,{"$f":"F129*10","v":11}]
[156,"Trichloroethene (TCE) (Trichloroethylene)","79-01-6",4.0999999999999997E-6,2E-3,1.1000000000000001,{"$f":"F130*10","v":11}]
[157,"Trichlorofluoromethane (Freon 11)","75-69-4","NA","NA",1.1000000000000001,{"$f":"F131*10","v":11}]
[158,"2,4,5-Trichlorophenol","95-95-4","NA","NA"]
[159,"2,4,6-Trichlorophenol","88-06-2","NA","NA"]
[160,"1,1,2-Trichloro-1,2,2-trifluoroethane (Freon TF)","76-13-1","NA",5,1.5,{"$f":"F134*10","v":15}]
[161,"1,2,4-Trimethylbenzene","95-63-6","NA",0.06,0.98,{"$f":"F135*10","v":9.8000000000000007}]
[163,"Vanadium (total)","7440-62-2","NA",1E-4]
[164,"Vinyl chloride","75-01-4",4.4000000000000002E-6,0.1,0.51,{"$f":"F137*10","v":5.0999999999999996}]
[165,"Xylenes (total)","1330-20-7","NA",0.1,0.87,{"$f":"F138*10","v":8.6999999999999993}]
[166,"Zinc (total)","7440-66-6","NA","NA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A from EPA Supplemental Guidance for Developing Soil Screening Levels for Superfund Sites (2002)"]
[null,"B SCDM 1996"]
[null,"C HSDB"]
[null,"D J&E"]
[null,"E Average of isomers"]
[null,"F From WATER9"]
[null,"G Calculated using WATER9"]
[null,"H Calculated from log Kow using EPA SSL guidance - technical background document"]
[null,"I CRC 1972"]
[null,"J from EPA Technical Background document"]
[null,"K Values obtained from sources other than the J&E spreadsheet may often be at temperatures other than the boiling point (e.g. room temperature).  Temperature often not specified. However, uncertainty in measurement often higher than the adjustment to boiling point (WIKIPEDIA), so values from other temperatures judged to be OK. "]
[null,"L If log Kow used, chemical group is used to determine which equation from EPA Soil Screening Guidance is used to calculate Koc.  "]
[null,"M SCDM 2004"]
[null,"N NJDEP GWQS 2008"]
[null,"O Interim Specific NJDEP GWQS 2009"]
[null,"P Interim Generic QWQS 2009"]
[null,"Q CALCULATED WITH WATER 8"]
[null,"R HSDB 1999"]
[null,"S SOIL SCREENING GUIDANCE USER'S GUIDE"]
[null,"T FROM CHEMDAT8"]
[null,"U KOW FROM SCDM 1996"]
[null,"V pH 5.3"]
[null,"W KOW FROM HSDB 1999"]
[null,"X KOW CALCULATED USING WATER 8"]
[null,"NOTE: Calculation of Henry's law at 40°C is done using equations from the Johnson and Ettinger spreadsheet (see Fact Sheet - Correcting the Henry's law constant for soil temperature, June 2001)"]
[null,"AEGL-1 short-term inhalation reference concentrations are 1hr values that were divided by 10 as per NJDEP-Division of Air Quality Procedures.  They were interim values as of February 2010"]
[null,"ATSDR short-term inhalation reference concentrations are acute inhalation MRLs"]

{"sheet":"VI-IASG-ExistChem-Res","index":1,"n_rows":100,"n_cols":79,"rows_kept":100,"cut":false,"hidden":false,"merged":[[8,10,8,11],[21,1,21,2],[15,1,15,2],[9,1,9,2],[11,1,11,2],[12,1,12,2],[20,1,20,2],[16,1,16,2],[14,1,14,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,2,3,5],[2,0,3,1],[3,7,3,8],[2,7,2,8],[22,1,22,2],[6,6,6,7],[7,6,7,7],[8,1,8,2],[17,1,17,2],[19,1,19,2],[10,1,10,2],[13,1,13,2],[18,1,18,2]]}
["NJDEP 2021 Vapor Intrusion Residential Air, Soil Gas and Rapid Action Level Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acetone","67-64-1"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell",null,null,null,null,null,null,null,null,null,null,null,"Benzene","71-43-2"]
["Contaminant:",null,null,null,null,null,"CAS No.:",{"$f":"CA100","v":"67-64-1"},null,null,null,"Required data entry",null,null,null,null,null,null,null,null,null,null,null,"Bromodichloromethane","75-27-4"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification",null,null,null,null,null,null,null,null,null,null,null,"Bromoform","75-25-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromomethane (Methyl bromide)","74-83-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3"]
[null,null,null,null,null,null,"Air Reporting Limit (µg/m3) = ",null,{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Air analytical reporting limit, Method TO-15 (µg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon disulfide","75-15-0"]
[null,null,null,null,null,null,"Soil Gas Reporting Limit =",null,{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Soil gas analytical reporting limit, Method TO-15 (µg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":120},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon tetrachloride","56-23-5"]
["Parameter","Definition",null,"Units","Default Scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorobenzene","108-90-7"]
["TR","Target Cancer Risk",null,"unitless",9.9999999999999995E-7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroethane (Ethyl chloride)","75-00-3"]
["THQ","Target Hazard Quotient",null,"unitless",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroform","67-66-3"]
["AT","Averaging Time",null,"days/year",365,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloromethane (Methyl chloride)","74-87-3"]
["LT","Lifetime",null,"years",70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyclohexane","110-82-7"]
["EF","Residential Exposure Frequency",null,"days/year",350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibromochloromethane","124-48-1"]
["ED","Residential Exposure Duration",null,"years",26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dibromoethane (Ethylene dibromide)","106-93-4"]
["ET","Residential Exposure Time",null,"hours/day",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1"]
["IUR","Inhalation Unit Risk",null,"(µg/m3)-1",{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Standards Inhalation Unit Risk Factor (µg/m3)-1\",'Master database'!$C$1:$GK$1,0),FALSE)","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7"]
["RfC","Inhalation Reference Concentration",null,"mg/m3",{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Standards Inhalation Reference Concentration (mg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dichlorodifluoromethane (Freon 12)","75-71-8"]
["IAc","Carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)),\"NA\",Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1-Dichloroethane","75-34-3"]
["IAnc","Non-carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))),\"NA\",Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethane","107-06-2"]
["IA","Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(E19=\"NA\",E20,IF(E20=\"NA\",E19,MIN(E19,E20)))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4"]
["SGSL","Human Health-Based Soil Gas Screening Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E21=E19,Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17*0.02)),Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18)*0.02))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2"]
["RAL","Human Health-Based Rapid Action Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E19=\"NA\",Round_to_Even(2*E20),IF(E20=\"NA\",100*E19,MIN(Round_to_Even(2*E20),100*E19))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloropropane","78-87-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,3-Dichloropropene (total)","542-75-6"]
["Residential Indoor Air Standard:",null,null,null,null,{"$f":"IF(E21=\"NA\",\"NA\",IF(E21<I7,I7,E21))","v":"NA"},"µg/m3",{"$f":"IF(F26=\"NA\",\"not of concern\",IF(F26=I7,\"Controlled by RL\",IF(F26=E19,\"Cancer-based\",IF(F26=E20,\"Noncancer-based\",\"\"))))","v":"not of concern"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,4-Dioxane","123-91-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethylbenzene","100-41-4"]
["Residential Soil Gas Screening Level:",null,null,null,null,{"$f":"IF(E22=\"NA\",\"NA\",IF(E22<I8,I8,E22))","v":"NA"},"µg/m3",{"$f":"IF(F28=\"NA\",\"\",IF(F28=I8,\"controlled by RL\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachlorobutadiene","87-68-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n-Hexane","110-54-3"]
["Residential Rapid Action Level:",null,null,null,null,{"$f":"IF(E23=\"NA\",\"NA\",IF(E23<I7,I7,E23))","v":"NA"},"µg/m3",{"$f":"IF(F30=I7,\"Controlled by RL\",IF(AND(E19<>\"NA\",E20<>\"NA\"),IF(F30=100*E19,\"Cancer-based\",\"Noncancer-based\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury (elemental)","7439-97-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methylene chloride (Dichloromethane)","75-09-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Methyl-2-pentanone (MIBK)","108-10-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl tert-butyl ether (MTBE)","1634-04-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naphthalene","91-20-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Styrene","100-42-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2,2-Tetrachloroethane","79-34-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toluene","108-88-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2,4-Trichlorobenzene","120-82-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,1-Trichloroethane","71-55-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2-Trichloroethane","79-00-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethene (TCE) (Trichloroethylene)","79-01-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichlorofluoromethane","75-69-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2-Trichloro-1,2,2-trifluoroethane (Freon TF)","76-13-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2,4-Trimethylbenzene","95-63-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vinyl chloride","75-01-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xylenes (total)","1330-20-7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"67-64-1"]

{"sheet":"VI-IASG-NewChem-Res","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,2],[21,1,21,2],[22,1,22,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[8,10,8,11],[9,1,9,2],[10,1,10,2],[11,1,11,2],[19,1,19,2],[12,1,12,2],[8,1,8,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,0,3,1],[2,2,3,5],[2,7,2,8],[3,7,3,8]]}
["NJDEP 2021 Vapor Intrusion Residential Air, Soil Gas and Rapid Action Level Calculator"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell"]
["Contaminant:",null,null,null,null,null,"CAS No.:",null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification"]
[]
[]
[]
[]
["Parameter","Definition",null,"Units","Default Scenario"]
["TR","Target Cancer Risk",null,"unitless",9.9999999999999995E-7]
["THQ","Target Hazard Quotient",null,"unitless",1]
["AT","Averaging Time",null,"days/year",365]
["LT","Lifetime",null,"years",70]
["EF","Residential Exposure Frequency",null,"days/year",350]
["ED","Residential Exposure Duration",null,"years",26]
["ET","Residential Exposure Time",null,"hours/day",24]
["IUR","Inhalation Unit Risk",null,"(µg/m3)-1","Optional Value Here"]
["RfC","Inhalation Reference Concentration",null,"mg/m3","Optional Value Here"]
["IAc","Carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)),\"NA\",Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)))","v":"NA"}]
["IAnc","Non-carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))),\"NA\",Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))))","v":"NA"}]
["IA","Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(E19=\"NA\",E20,IF(E20=\"NA\",E19,MIN(E19,E20)))","v":"NA"},{"$f":"IF(E21=\"NA\",\"not of concern\",IF(E21=E19,\"Cancer-based\",IF(E21=E20,\"Noncancer-based\",\"\")))","v":"not of concern"}]
["SGSL","Human Health-Based Soil Gas Screening Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E21=E19,Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17*0.02)),Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18)*0.02))))","v":"NA"}]
["RAL","Human Health-Based Rapid Action Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E19=\"NA\",Round_to_Even(2*E20),IF(E20=\"NA\",100*E19,MIN(Round_to_Even(2*E20),100*E19))))","v":"NA"},{"$f":"IF(AND(E19<>\"NA\",E20<>\"NA\"),IF(E23=100*E19,\"cancer-based\",\"noncancer-based\"),\"\")","v":""}]

{"sheet":"VI-IASG-ExistChem-Nonres","index":3,"n_rows":100,"n_cols":79,"rows_kept":100,"cut":false,"hidden":false,"merged":[[8,10,8,11],[9,1,9,2],[22,1,22,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[10,1,10,2],[6,6,6,7],[7,6,7,7],[8,1,8,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,0,3,1],[2,2,3,5],[2,7,2,8],[3,7,3,8]]}
["NJDEP 2021 Vapor Intrusion Nonresidential Air, Soil Gas and Rapid Action Level Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acetone","67-64-1"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell",null,null,null,null,null,null,null,null,null,null,null,"Benzene","71-43-2"]
["Contaminant:",null,null,null,null,null,"CAS No.:",{"$f":"CA100","v":"67-64-1"},null,null,null,"Required data entry",null,null,null,null,null,null,null,null,null,null,null,"Bromodichloromethane","75-27-4"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification",null,null,null,null,null,null,null,null,null,null,null,"Bromoform","75-25-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromomethane (Methyl bromide)","74-83-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3"]
[null,null,null,null,null,null,"Air Reporting Limit (µg/m3) = ",null,{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Air analytical reporting limit, Method TO-15 (µg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon disulfide","75-15-0"]
[null,null,null,null,null,null,"Soil Gas Reporting Limit =",null,{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Soil gas analytical reporting limit, Method TO-15 (µg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":120},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon tetrachloride","56-23-5"]
["Parameter","Definition",null,"Units","Default Scenario","Alternative Scenario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorobenzene","108-90-7"]
["TR","Target Cancer Risk",null,"unitless",9.9999999999999995E-7,9.9999999999999995E-7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroethane (Ethyl chloride)","75-00-3"]
["THQ","Target Hazard Quotient",null,"unitless",1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroform","67-66-3"]
["AT","Averaging Time",null,"days/year",365,365,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloromethane (Methyl chloride)","74-87-3"]
["LT","Lifetime",null,"years",70,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyclohexane","110-82-7"]
["EF","Nonresidential Exposure Frequency",null,"days/year",250,250,{"$f":"IF(OR(F14<0,F14>365),\"out of range\",IF(F14<>250,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibromochloromethane","124-48-1"]
["ED","Nonresidential Exposure Duration",null,"years",25,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dibromoethane (Ethylene dibromide)","106-93-4"]
["ET","Nonresidential Exposure Time",null,"hours/day",8,8,{"$f":"IF(OR(F16<0,F16>24),\"out of range\",IF(F16<>8,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1"]
["IUR","Inhalation Unit Risk",null,"(µg/m3)-1",{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Standards Inhalation Unit Risk Factor (µg/m3)-1\",'Master database'!$C$1:$GK$1,0),FALSE)","v":"NA"},{"$f":"E17","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7"]
["RfC","Inhalation Reference Concentration",null,"mg/m3",{"$f":"VLOOKUP(H3,'Master database'!$C$2:$GK$455,MATCH(\"2018 Standards Inhalation Reference Concentration (mg/m3)\",'Master database'!$C$1:$GK$1,0),FALSE)","v":"NA"},{"$f":"E18","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dichlorodifluoromethane (Freon 12)","75-71-8"]
["IAc","Carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)),\"NA\",Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)))","v":"NA"},{"$f":"IF(ISERROR((F10*F12*F13)/(F14*F15*F16*(1/24)*F17)),\"NA\",Round_to_Even((F10*F12*F13)/(F14*F15*F16*(1/24)*F17)))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1-Dichloroethane","75-34-3"]
["IAnc","Non-carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))),\"NA\",Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))))","v":"NA"},{"$f":"IF(ISERROR((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18))),\"NA\",Round_to_Even((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethane","107-06-2"]
["IA","Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(E19=\"NA\",E20,IF(E20=\"NA\",E19,MIN(E19,E20)))","v":"NA"},{"$f":"IF(F19=\"NA\",F20,IF(F20=\"NA\",F19,MIN(F19,F20)))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4"]
["SGSL","Human Health-Based Soil Gas Screening Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E21=E19,Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17*0.02)),Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18)*0.02))))","v":"NA"},{"$f":"IF(AND(F19=\"NA\",F20=\"NA\"),\"NA\",IF(F21=F19,Round_to_Even((F10*F12*F13)/(F14*F15*F16*(1/24)*F17*0.02)),Round_to_Even((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18)*0.02))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2"]
["RAL","Human Health-Based Rapid Action Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E19=\"NA\",Round_to_Even(2*E20),IF(E20=\"NA\",100*E19,MIN(Round_to_Even(2*E20),100*E19))))","v":"NA"},{"$f":"IF(AND(F19=\"NA\",F20=\"NA\"),\"NA\",IF(F19=\"NA\",Round_to_Even(2*F20),IF(F20=\"NA\",100*F19,MIN(Round_to_Even(2*F20),100*F19))))","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2-Dichloropropane","78-87-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,3-Dichloropropene (total)","542-75-6"]
["Alternative Nonresidential Indoor Air Standard:",null,null,null,null,{"$f":"IF(F21=\"NA\",\"NA\",IF(F21<I7,I7,F21))","v":"NA"},"µg/m3",{"$f":"IF(F26=\"NA\",\"not of concern\",IF(F26=I7,\"controlled by RL\",IF(F26=F19,\"Cancer-based\",IF(F26=F20,\"Noncancer-based\",\"\"))))","v":"not of concern"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,4-Dioxane","123-91-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ethylbenzene","100-41-4"]
["Alternative Nonresidential Soil Gas Screening Level:",null,null,null,null,{"$f":"IF(F22=\"NA\",\"NA\",IF(F22<I8,I8,F22))","v":"NA"},"µg/m3",{"$f":"IF(F28=\"NA\",\"\",IF(F28=I8,\"controlled by RL\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachlorobutadiene","87-68-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n-Hexane","110-54-3"]
["Alternative Nonresidential Rapid Action Level:",null,null,null,null,{"$f":"IF(F23=\"NA\",\"NA\",IF(F23<I7,I7,F23))","v":"NA"},"µg/m3",{"$f":"IF(F30=I7,\"Controlled by RL\",IF(AND(F19<>\"NA\",F20<>\"NA\"),IF(F30=100*F19,\"Cancer-based\",\"Noncancer-based\"),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury (elemental)","7439-97-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methylene chloride (Dichloromethane)","75-09-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Methyl-2-pentanone (MIBK)","108-10-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl tert-butyl ether (MTBE)","1634-04-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naphthalene","91-20-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Styrene","100-42-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2,2-Tetrachloroethane","79-34-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toluene","108-88-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2,4-Trichlorobenzene","120-82-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,1-Trichloroethane","71-55-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2-Trichloroethane","79-00-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichloroethene (TCE) (Trichloroethylene)","79-01-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trichlorofluoromethane","75-69-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,2-Trichloro-1,2,2-trifluoroethane (Freon TF)","76-13-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,2,4-Trimethylbenzene","95-63-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vinyl chloride","75-01-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Xylenes (total)","1330-20-7"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"67-64-1"]

{"sheet":"VI-IASG-NewChem-Nonres","index":4,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,2],[21,1,21,2],[22,1,22,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[8,10,8,11],[9,1,9,2],[10,1,10,2],[11,1,11,2],[19,1,19,2],[12,1,12,2],[8,1,8,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,0,3,1],[2,2,3,5],[2,7,2,8],[3,7,3,8]]}
["NJDEP 2021 Vapor Intrusion Nonresidential Air, Soil Gas and Rapid Action Level Calculator"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell"]
["Contaminant:",null,null,null,null,null,"CAS No.:",null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification"]
[]
[]
[]
[]
["Parameter","Definition",null,"Units","Default Scenario","Alternative Scenario"]
["TR","Target Cancer Risk",null,"unitless",9.9999999999999995E-7,9.9999999999999995E-7]
["THQ","Target Hazard Quotient",null,"unitless",1,1]
["AT","Averaging Time",null,"days/year",365,365]
["LT","Lifetime",null,"years",70,70]
["EF","Nonresidential Exposure Frequency",null,"days/year",250,250,{"$f":"IF(OR(F14<0,F14>365),\"out of range\",IF(F14<>250,\"changed\",\"\"))","v":""}]
["ED","Nonresidential Exposure Duration",null,"years",25,25]
["ET","Nonresidential Exposure Time",null,"hours/day",8,8,{"$f":"IF(OR(F16<0,F16>24),\"out of range\",IF(F16<>8,\"changed\",\"\"))","v":""}]
["IUR","Inhalation Unit Risk",null,"(µg/m3)-1","Optional Value Here",{"$f":"IF(E17=\"Optional Value Here\",\"\",E17)","v":""}]
["RfC","Inhalation Reference Concentration",null,"mg/m3","Optional Value Here",{"$f":"IF(E18=\"Optional Value Here\",\"\",E18)","v":""}]
["IAc","Carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)),\"NA\",Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17)))","v":"NA"},{"$f":"IF(ISERROR((F10*F12*F13)/(F14*F15*F16*(1/24)*F17)),\"NA\",Round_to_Even((F10*F12*F13)/(F14*F15*F16*(1/24)*F17)))","v":"NA"}]
["IAnc","Non-carcinogenic Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(ISERROR((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))),\"NA\",Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18))))","v":"NA"},{"$f":"IF(ISERROR((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18))),\"NA\",Round_to_Even((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18))))","v":"NA"}]
["IA","Indoor Air Human Health-Based Criterion",null,"µg/m3",{"$f":"IF(E19=\"NA\",E20,IF(E20=\"NA\",E19,MIN(E19,E20)))","v":"NA"},{"$f":"IF(F19=\"NA\",F20,IF(F20=\"NA\",F19,MIN(F19,F20)))","v":"NA"},{"$f":"IF(E21=\"NA\",\"not of concern\",IF(E21=E19,\"Cancer-based\",IF(E21=E20,\"Noncancer-based\",\"\")))","v":"not of concern"}]
["SGSL","Human Health-Based Soil Gas Screening Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E21=E19,Round_to_Even((E10*E12*E13)/(E14*E15*E16*(1/24)*E17*0.02)),Round_to_Even((E11*E12*E15*1000)/(E14*E15*E16*(1/24)*(1/E18)*0.02))))","v":"NA"},{"$f":"IF(AND(F19=\"NA\",F20=\"NA\"),\"NA\",IF(F21=F19,Round_to_Even((F10*F12*F13)/(F14*F15*F16*(1/24)*F17*0.02)),Round_to_Even((F11*F12*F15*1000)/(F14*F15*F16*(1/24)*(1/F18)*0.02))))","v":"NA"}]
["RAL","Human Health-Based Rapid Action Criterion",null,"µg/m3",{"$f":"IF(AND(E19=\"NA\",E20=\"NA\"),\"NA\",IF(E19=\"NA\",Round_to_Even(2*E20),IF(E20=\"NA\",100*E19,MIN(Round_to_Even(2*E20),100*E19))))","v":"NA"},{"$f":"IF(AND(F19=\"NA\",F20=\"NA\"),\"NA\",IF(F19=\"NA\",Round_to_Even(2*F20),IF(F20=\"NA\",100*F19,MIN(Round_to_Even(2*F20),100*F19))))","v":"NA"},{"$f":"IF(AND(E19<>\"NA\",E20<>\"NA\"),IF(E23=100*E19,\"cancer-based\",\"noncancer-based\"),\"\")","v":""}]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}