{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Master Sheet","Calculator","Calc Sheet","User's Guide"],"not_rendered":{"charts":0,"images":10,"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 Sheet","index":0,"n_rows":138,"n_cols":4,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
["Chemical","CAS No.","Final Toxicity Values","Basis for Final Toxicity Values"]
["Acenaphthene","83-32-9","Not Available","No RfC/IUR Available for This Contaminant"]
["Acetone (2-Propanone)","67-64-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Acetophenone","98-86-2","Not Available","No RfC/IUR Available for This Contaminant"]
["Aldrin","309-00-2","Not Available","No RfC/IUR Available for This Contaminant"]
["Aluminum (total)","7429-90-5",5,"Inhalation Reference Concentration (µg/m3)"]
["Anthracene","120-12-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Antimony (total)","7440-36-0",2.9999999999999997E-4,"Inhalation Reference Concentration (µg/m3)"]
["Arsenic (total)","7440-38-2",4.3E-3,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Atrazine","1912-24-9","Not Available","No RfC/IUR Available for This Contaminant"]
["Barium (total)","7440-39-3",0.5,"Inhalation Reference Concentration (µg/m3)"]
["Benzaldehyde","100-52-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Benzene","71-43-2",30,"Inhalation Reference Concentration (µg/m3)"]
["Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3",6.0000000000000002E-5,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Benzo(a)pyrene","50-32-8",2E-3,"Inhalation Reference Concentration (µg/m3)"]
["Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2",6.0000000000000002E-5,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Benzo(k)fluoranthene","207-08-9",6.0000000000000002E-6,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Beryllium","7440-41-7",0.02,"Inhalation Reference Concentration (µg/m3)"]
["1,1'-Biphenyl","92-52-4","Not Available","No RfC/IUR Available for This Contaminant"]
["Bis(2-chloroethoxy)methane","111-91-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Bis(2-chloroethyl)ether","111-44-4",117,"Inhalation Reference Concentration (µg/m3)"]
["Bis(2-chloroisopropyl)ether; (2,2'-oxybis(1-chloropropane)); (2-chloro-1-methylethyl) ether","108-60-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Bis(2-ethylhexyl)phthalate","117-81-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Bromodichloromethane (Dichlorobromomethane)","75-27-4","Not Available","No RfC/IUR Available for This Contaminant"]
["Bromoform","75-25-2","Not Available","No RfC/IUR Available for This Contaminant"]
["Bromomethane (Methyl bromide)","74-83-9",5,"Inhalation Reference Concentration (µg/m3)"]
["2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3",5000,"Inhalation Reference Concentration (µg/m3)"]
["Butylbenzyl phthalate","85-68-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Cadmium","7440-43-9",0.01,"Inhalation Reference Concentration (µg/m3)"]
["Caprolactam","105-60-2",2.2000000000000002,"Inhalation Reference Concentration (µg/m3)"]
["Carbon disulfide","75-15-0",700,"Inhalation Reference Concentration (µg/m3)"]
["Carbon tetrachloride","56-23-5",100,"Inhalation Reference Concentration (µg/m3)"]
["Chlordane (alpha and gamma forms summed)","57-74-9",0.7,"Inhalation Reference Concentration (µg/m3)"]
["4-Chloroaniline","106-47-8","Not Available","No RfC/IUR Available for This Contaminant"]
["Chlorobenzene","108-90-7",50,"Inhalation Reference Concentration (µg/m3)"]
["Chloroethane (Ethyl chloride)","75-00-3",10000,"Inhalation Reference Concentration (µg/m3)"]
["Chloroform","67-66-3",98,"Inhalation Reference Concentration (µg/m3)"]
["Chloromethane (Methyl chloride)","74-87-3",90,"Inhalation Reference Concentration (µg/m3)"]
["2-Chloronaphthalene","91-58-7","Not Available","No RfC/IUR Available for This Contaminant"]
["2-Chlorophenol (o-Chlorophenol)","95-57-8","Not Available","No RfC/IUR Available for This Contaminant"]
["Chrysene","218-01-9",5.9999999999999997E-7,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Cobalt (total)","7440-48-4",6.0000000000000001E-3,"Inhalation Reference Concentration (µg/m3)"]
["Copper (total)","7440-50-8","Not Available","No RfC/IUR Available for This Contaminant"]
["Cyanide","57-12-5",0.8,"Inhalation Reference Concentration (µg/m3)"]
["Cyclohexane","110-82-7",6000,"Inhalation Reference Concentration (µg/m3)"]
["4,4'-DDD (p,p'-TDE)","72-54-8","Not Available","No RfC/IUR Available for This Contaminant"]
["4,4'-DDE (p,p'-DDX)","72-55-9","Not Available","No RfC/IUR Available for This Contaminant"]
["4,4'-DDT","50-29-3","Not Available","No RfC/IUR Available for This Contaminant"]
["Dibenz(a,h)anthracene","53-70-3",5.9999999999999995E-4,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Dibromochloromethane (Chlorodibromomethane)","124-48-1","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2-Dibromo-3-chloropropane","96-12-8",0.2,"Inhalation Reference Concentration (µg/m3)"]
["1,2-Dibromoethane (Ethylene dibromide)","106-93-4",9,"Inhalation Reference Concentration (µg/m3)"]
["1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1",200,"Inhalation Reference Concentration (µg/m3)"]
["1,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-1","Not Available","No RfC/IUR Available for This Contaminant"]
["1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7",800,"Inhalation Reference Concentration (µg/m3)"]
["3,3'-Dichlorobenzidine","91-94-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Dichlorodifluoromethane (Freon 12)","75-71-8","Not Available","No RfC/IUR Available for This Contaminant"]
["1,1-Dichloroethane","75-34-3","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2-Dichloroethane","107-06-2",7,"Inhalation Reference Concentration (µg/m3)"]
["1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4",200,"Inhalation Reference Concentration (µg/m3)"]
["1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4-Dichlorophenol","120-83-2","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2-Dichloropropane","78-87-5",4,"Inhalation Reference Concentration (µg/m3)"]
["1,3-Dichloropropene (total)","542-75-6",20,"Inhalation Reference Concentration (µg/m3)"]
["Dieldrin","60-57-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Diethylphthalate","84-66-2","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4-Dimethylphenol","105-67-9","Not Available","No RfC/IUR Available for This Contaminant"]
["Di-n-butyl phthalate","84-74-2","Not Available","No RfC/IUR Available for This Contaminant"]
["4,6-Dinitro-2-methylphenol","534-52-1","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4-Dinitrophenol","51-28-5","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6","Not Available","No RfC/IUR Available for This Contaminant"]
["Di-n-octyl phthalate","117-84-0","Not Available","No RfC/IUR Available for This Contaminant"]
["1,4-Dioxane","123-91-1",30,"Inhalation Reference Concentration (µg/m3)"]
["Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Endrin","72-20-8","Not Available","No RfC/IUR Available for This Contaminant"]
["Ethylbenzene","100-41-4",1000,"Inhalation Reference Concentration (µg/m3)"]
["Fluoranthene","206-44-0","Not Available","No RfC/IUR Available for This Contaminant"]
["Fluorene","86-73-7","Not Available","No RfC/IUR Available for This Contaminant"]
["alpha-HCH (alpha-BHC)","319-84-6","Not Available","No RfC/IUR Available for This Contaminant"]
["beta-HCH (beta-BHC)","319-85-7","Not Available","No RfC/IUR Available for This Contaminant"]
["Heptachlor","76-44-8","Not Available","No RfC/IUR Available for This Contaminant"]
["Heptachlor epoxide","1024-57-3","Not Available","No RfC/IUR Available for This Contaminant"]
["Hexachlorobenzene","118-74-1","Not Available","No RfC/IUR Available for This Contaminant"]
["Hexachloro-1,3-butadiene","87-68-3","Not Available","No RfC/IUR Available for This Contaminant"]
["Hexachlorocyclopentadiene","77-47-4",0.2,"Inhalation Reference Concentration (µg/m3)"]
["Hexachloroethane","67-72-1",30,"Inhalation Reference Concentration (µg/m3)"]
["n-Hexane","110-54-3",700,"Inhalation Reference Concentration (µg/m3)"]
["2-Hexanone","591-78-6",30,"Inhalation Reference Concentration (µg/m3)"]
["Indeno(1,2,3-cd)pyrene","193-39-5",6.0000000000000002E-5,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Isophorone","78-59-1",2000,"Inhalation Reference Concentration (µg/m3)"]
["Isopropylbenzene","98-82-8",400,"Inhalation Reference Concentration (µg/m3)"]
["Lead (total)","7439-92-1",0.15,"Lead NAAQS 0.15 µg/m3"]
["Lindane (gamma-HCH)(gamma-BHC)","58-89-9","Not Available","No RfC/IUR Available for This Contaminant"]
["Manganese (total)","7439-96-5",0.05,"Inhalation Reference Concentration (µg/m3)"]
["Mercury (total)","7439-97-6",0.3,"Inhalation Reference Concentration (µg/m3)"]
["Methoxychlor","72-43-5","Not Available","No RfC/IUR Available for This Contaminant"]
["Methyl acetate","79-20-9","Not Available","No RfC/IUR Available for This Contaminant"]
["Methylene chloride (Dichloromethane)","75-09-2",600,"Inhalation Reference Concentration (µg/m3)"]
["2-Methylnaphthalene","91-57-6","Not Available","No RfC/IUR Available for This Contaminant"]
["4-Methyl-2-pentanone (MIBK)","108-10-1",3000,"Inhalation Reference Concentration (µg/m3)"]
["2-Methylphenol (o-cresol)","95-48-7","Not Available","No RfC/IUR Available for This Contaminant"]
["4-Methylphenol (p-cresol)","106-44-5","Not Available","No RfC/IUR Available for This Contaminant"]
["Methyl tert-butyl ether (MTBE)","1634-04-4",3000,"Inhalation Reference Concentration (µg/m3)"]
["Naphthalene","91-20-3",3,"Inhalation Reference Concentration (µg/m3)"]
["Nickel (total)","7440-02-0",1.4E-2,"Inhalation Reference Concentration (µg/m3)"]
["4-Nitroaniline","100-01-6",6,"Inhalation Reference Concentration (µg/m3)"]
["Nitrobenzene","98-95-3",9,"Inhalation Reference Concentration (µg/m3)"]
["N-Nitrosodi-n-propylamine","621-64-7","Not Available","No RfC/IUR Available for This Contaminant"]
["N-Nitrosodiphenylamine","86-30-6","Not Available","No RfC/IUR Available for This Contaminant"]
["Pentachlorophenol","87-86-5","Not Available","No RfC/IUR Available for This Contaminant"]
["Phenol","108-95-2",200,"Inhalation Reference Concentration (µg/m3)"]
["Polychlorinated biphenyls (PCBs)","1336-36-3",5.6999999999999998E-4,"Inhalation Unit Risk Factor (µg/m3)-1"]
["Pyrene","129-00-0","Not Available","No RfC/IUR Available for This Contaminant"]
["Selenium (total)","7782-49-2","Not Available","No RfC/IUR Available for This Contaminant"]
["Silver (total)","7440-22-4","Not Available","No RfC/IUR Available for This Contaminant"]
["Styrene","100-42-5",1000,"Inhalation Reference Concentration (µg/m3)"]
["Tertiary butyl alcohol (TBA)","75-65-0","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2,4,5 - Tetrachlorobenzene","95-94-3","Not Available","No RfC/IUR Available for This Contaminant"]
["2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-01-6","Not Available","No RfC/IUR Available for This Contaminant"]
["1,1,2,2-Tetrachloroethane","79-34-5","Not Available","No RfC/IUR Available for This Contaminant"]
["Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4",40,"Inhalation Reference Concentration (µg/m3)"]
["2,3,4,6-Tetrachlorophenol","58-90-2","Not Available","No RfC/IUR Available for This Contaminant"]
["Toluene","108-88-3",5000,"Inhalation Reference Concentration (µg/m3)"]
["Toxaphene","8001-35-2","Not Available","No RfC/IUR Available for This Contaminant"]
["1,2,4-Trichlorobenzene","120-82-1",2,"Inhalation Reference Concentration (µg/m3)"]
["1,1,1-Trichloroethane","71-55-6",5000,"Inhalation Reference Concentration (µg/m3)"]
["1,1,2-Trichloroethane","79-00-5","Not Available","No RfC/IUR Available for This Contaminant"]
["Trichloroethene (TCE) (Trichloroethylene)","79-01-6",2,"Inhalation Reference Concentration (µg/m3)"]
["Trichlorofluoromethane (Freon 11)","75-69-4","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4,5-Trichlorophenol","95-95-4","Not Available","No RfC/IUR Available for This Contaminant"]
["2,4,6-Trichlorophenol","88-06-2","Not Available","No RfC/IUR Available for This Contaminant"]
["1,1,2-Trichloro-1,2,2-trifluoroethane","76-13-1",5000,"Inhalation Reference Concentration (µg/m3)"]
["1,2,4-Trimethylbenzene","95-63-6",60,"Inhalation Reference Concentration (µg/m3)"]
["Vanadium (total)","7440-62-2",0.1,"Inhalation Reference Concentration (µg/m3)"]
["Vinyl chloride","75-01-4",100,"Inhalation Reference Concentration (µg/m3)"]
["Xylenes (total)","1330-20-7",100,"Inhalation Reference Concentration (µg/m3)"]
["Zinc (total)","7440-66-6","Not Available","No RfC/IUR Available for This Contaminant"]

{"sheet":"Calculator","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,13],[4,2,4,3],[22,12,26,12],[1,5,3,5],[1,6,3,6],[12,1,12,3],[12,8,12,10],[13,1,13,4],[13,8,13,11],[16,5,16,6],[10,5,10,6],[16,12,16,13],[10,12,10,13],[6,5,7,7],[6,12,7,14],[12,12,13,14],[12,5,13,7],[9,21,9,22],[1,2,1,3],[2,2,2,3],[3,2,3,3],[7,1,7,4],[7,8,7,11],[1,4,3,4],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10],[6,1,6,3],[6,8,6,10]]}
[null,"NJDEP Perimeter Air Monitoring HBTV\nand Response Level Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Site Name:",null,null,"Averaging Time (year)","Exposure Time (hours/24 hours)","Exposure Frequency (days/365 days)","Exposure Duration (year)","Number of Contaminants (Up to 4)",null,null,null,null,null,null,2]
[null,"Site PI #:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Evaluated by:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Date:",null,null,"1 (NC), 70 (C) ",8,30,1,4]
[]
[null,"Mercury (total)",null,null,{"$f":"VLOOKUP(B7,'Master Sheet'!$A$2:$AB$138,MATCH(\"CAS No.\",'Master Sheet'!$A$1:$AB$1,0),FALSE)","v":"7439-97-6"},{"$f":"IF(E7=\"1336-36-3\", \" \", IF('Calc Sheet'!A2=\"b\", \"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2.\", \" \"))","v":"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2."},null,null,"Benzene",null,null,{"$f":"VLOOKUP(I7,'Master Sheet'!$A$2:$AB$138,MATCH(\"CAS No.\",'Master Sheet'!$A$1:$AB$1,0),FALSE)","v":"71-43-2"},{"$f":"IF(L7=\"1336-36-3\", \" \", IF('Calc Sheet'!B2=\"b\",\"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2.\",\" \"))","v":" "}]
[null,{"$f":"IF('Calc Sheet'!A2=\"p\", \"Analyzed as Particulate\",IF('Calc Sheet'!A2=\"v\", \"Analyzed as Volatile\",\"Provide Justification for Analyzing as Volatile or Particulate\"))","v":"Provide Justification for Analyzing as Volatile or Particulate"},null,null,null,null,null,null,{"$f":"IF('Calc Sheet'!B2=\"p\",\"Analyzed as Particulate\",IF('Calc Sheet'!B2=\"v\", \"Analyzed as Volatile\", \"Provide Justification for Analyzing as Volatile or Particulate\"))","v":"Analyzed as Volatile"}]
[null,{"$f":"VLOOKUP(E7,'Master Sheet'!$B$2:$AB$138,MATCH(\"Basis for Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":"Inhalation Reference Concentration (µg/m3)"},{"$f":"VLOOKUP(E7,'Master Sheet'!$B$2:$AB$138,MATCH(\"Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":0.3},"HBTV (µg/m3)",{"$f":"IF(E7=\"7439-92-1\",'Calc Sheet'!A13,IF(C9=\"Not Available\", \"Appropriate Toxicity Value Not Available, Choose a Surrogate or Consult with Department\", 'Calc Sheet'!A5))","v":10.950000000000001},{"$f":"IF('Calc Sheet'!A2<>\"p\",\"HBTV (ppbv)\",\"\")","v":"HBTV (ppbv)"},{"$f":"IF(C9=\"Not Available\",\"Appropriate Toxicity Value Not Available\",IF('Calc Sheet'!A2<>\"p\",'Calc Sheet'!A12,\"\"))","v":1.3347001346029215},null,{"$f":"VLOOKUP(L7,'Master Sheet'!$B$2:$AB$138,MATCH(\"Basis for Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":"Inhalation Reference Concentration (µg/m3)"},{"$f":"VLOOKUP(L7,'Master Sheet'!$B$2:$AB$138,MATCH(\"Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":30},"HBTV (µg/m3)",{"$f":"IF(L7=\"7439-92-1\",'Calc Sheet'!B13,IF(J9=\"Not Available\", \"Appropriate Toxicity Value Not Available, Choose a Surrogate or Consult with Department\", 'Calc Sheet'!B5))","v":1095},{"$f":"IF('Calc Sheet'!B2<>\"p\",\"HBTV (ppbv)\",\"\")","v":"HBTV (ppbv)"},{"$f":"IF(J9=\"Not Available\",\"Appropriate Toxicity Value Not Available\",IF('Calc Sheet'!B2<>\"p\",'Calc Sheet'!B12,\"\"))","v":342.75700934579442}]
[null,{"$f":"IF('Calc Sheet'!A2=\"p\", \"Soil Concentration (mg/kg)\", \"Percent of Total Volatiles in Air\")","v":"Percent of Total Volatiles in Air"},null,"Response Level (µg/m3)",{"$f":"IF(C9=\"Not Available\",\"Not Available\",IF(C10=\"\",E9,IF(C10=0,\"\",IF(E7=\"7439-92-1\",'Calc Sheet'!A15,IF('Calc Sheet'!A2<>\"P\",'Calc Sheet'!A9,IF('Calc Sheet'!A9>150,150,'Calc Sheet'!A9))))))","v":10.950000000000001},{"$f":"IF('Calc Sheet'!A2<>\"p\",\"Response Level (ppbv)\",'Calc Sheet'!A17)","v":"Response Level (ppbv)"},{"$f":"IF('Calc Sheet'!A2=\"p\",\"\",IF(C9=\"Not Available\",\"Not Available\",IF(C10=\"\",G9,IF(C10=0,\"\",IF('Calc Sheet'!A2<>\"p\",'Calc Sheet'!A10,\"\")))))","v":1.3347001346029215},null,{"$f":"IF('Calc Sheet'!B2=\"p\", \"Soil Concentration (mg/kg)\", \"Percent of Total Volatiles in Air\")","v":"Percent of Total Volatiles in Air"},null,"Response Level (µg/m3)",{"$f":"IF(J9=\"Not Available\",\"Not Available\",IF(J10=\"\",L9,IF(J10=0,\"\",IF(L7=\"7439-92-1\",'Calc Sheet'!B15,IF('Calc Sheet'!B2<>\"P\",'Calc Sheet'!B9,IF('Calc Sheet'!B9>150,150,'Calc Sheet'!B9))))))","v":1095},{"$f":"IF('Calc Sheet'!B2<>\"p\",\"Response Level (ppbv)\",'Calc Sheet'!B17)","v":"Response Level (ppbv)"},{"$f":"IF('Calc Sheet'!B2=\"p\",\"\",IF(J9=\"Not Available\",\"Not Available\",IF(J10=\"\",N9,IF(J10=0,\"\",IF('Calc Sheet'!B2<>\"p\",'Calc Sheet'!B10,\"\")))))","v":342.75700934579442}]
[null,{"$f":"IF('Calc Sheet'!A2=\"b\", \"Soil Concentration (mg/kg)\", \"\")","v":"Soil Concentration (mg/kg)"},null,{"$f":"IF('Calc Sheet'!A2=\"b\", \"Response Level (µg/m3)\", \"\")","v":"Response Level (µg/m3)"},{"$f":"IF(C9=\"Not Available\",\"Not Available\",IF(C11=\"\",E9,IF(C11=0,\"\",IF('Calc Sheet'!A20>150,150,'Calc Sheet'!A20))))","v":10.950000000000001},{"$f":"IF(C9=\"Not Available\", \" \",IF('Calc Sheet'!A2=\"p\",'Calc Sheet'!A18,IF(C11=0,\"\",IF(C11=\"\",\"\",IF('Calc Sheet'!A2=\"b\",'Calc Sheet'!A21,'Calc Sheet'!A18)))))","v":""},null,null,{"$f":"IF('Calc Sheet'!B2=\"b\", \"Soil Concentration (mg/kg)\", \"\")","v":""},null,{"$f":"IF('Calc Sheet'!B2=\"b\", \"Response Level (µg/m3)\", \"\")","v":""},{"$f":"IF(J9=\"Not Available\",\"Not Available\",IF(J11=\"\",L9,IF(J11=0,\"\",IF('Calc Sheet'!B20>150,150,'Calc Sheet'!B20))))","v":1095},{"$f":"IF(J9=\"Not Available\", \" \",IF('Calc Sheet'!B2=\"p\",'Calc Sheet'!B18,IF(J11=0,\"\",IF(J11=\"\",\"\",IF('Calc Sheet'!B2=\"b\",'Calc Sheet'!B21,'Calc Sheet'!B18)))))","v":""}]
[]
[null,"Polychlorinated biphenyls (PCBs)",null,null,{"$f":"VLOOKUP(B13,'Master Sheet'!$A$2:$AB$138,MATCH(\"CAS No.\",'Master Sheet'!$A$1:$AB$1,0),FALSE)","v":"1336-36-3"},{"$f":"IF(E13=\"1336-36-3\", \" \", IF('Calc Sheet'!C2=\"b\", \"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2.\", \" \"))","v":" "},null,null,"Naphthalene",null,null,{"$f":"VLOOKUP(I13,'Master Sheet'!$A$2:$AB$138,MATCH(\"CAS No.\",'Master Sheet'!$A$1:$AB$1,0),FALSE)","v":"91-20-3"},{"$f":"IF(L13=\"1336-36-3\", \" \", IF('Calc Sheet'!D2=\"b\", \"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2.\", \" \"))","v":"For further guidance regarding analyzing CoCs as volatiles or particulates, refer to the User's Guide, Section 5.2."}]
[null,{"$f":"IF('Calc Sheet'!C2=\"p\",\"Analyzed as Particulate\",IF('Calc Sheet'!C2=\"v\",\"Analyzed as Volatile\",\"Provide Justification for Analyzing as Volatile or Particulate\"))","v":"Provide Justification for Analyzing as Volatile or Particulate"},null,null,null,null,null,null,{"$f":"IF('Calc Sheet'!D2=\"p\",\"Analyzed as Particulate\",IF('Calc Sheet'!D2=\"v\",\"Analyzed as Volatile\",\"Provide Justification for Analyzing as Volatile or Particulate\"))","v":"Provide Justification for Analyzing as Volatile or Particulate"}]
[null,{"$f":"VLOOKUP(E13,'Master Sheet'!$B$2:$AB$138,MATCH(\"Basis for Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":"Inhalation Unit Risk Factor (µg/m3)-1"},{"$f":"VLOOKUP(E13,'Master Sheet'!$B$2:$AB$138,MATCH(\"Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":5.6999999999999998E-4},"HBTV (µg/m3)",{"$f":"IF(E13=\"7439-92-1\",'Calc Sheet'!C13,IF(C15=\"Not Available\", \"Appropriate Toxicity Value Not Available, Choose a Surrogate or Consult with Department\", 'Calc Sheet'!C5))","v":4.4824561403508776},{"$f":"IF('Calc Sheet'!C2<>\"p\",\"HBTV (ppbv)\",\"\")","v":"HBTV (ppbv)"},{"$f":"IF(C15=\"Not Available\",\"Appropriate Toxicity Value Not Available\",IF('Calc Sheet'!C2<>\"p\",'Calc Sheet'!C12,\"\"))","v":"Refer to User's Guide Section 5.2"},null,{"$f":"VLOOKUP(L13,'Master Sheet'!$B$2:$AB$138,MATCH(\"Basis for Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":"Inhalation Reference Concentration (µg/m3)"},{"$f":"VLOOKUP(L13,'Master Sheet'!$B$2:$AB$138,MATCH(\"Final Toxicity Values\",'Master Sheet'!$B$1:$AB$1,0),FALSE)","v":3},"HBTV (µg/m3)",{"$f":"IF(L13=\"7439-92-1\",'Calc Sheet'!D13,IF(J15=\"Not Available\", \"Appropriate Toxicity Value Not Available, Choose a Surrogate or Consult with Department\", 'Calc Sheet'!D5))","v":109.5},{"$f":"IF('Calc Sheet'!D2<>\"p\",\"HBTV (ppbv)\",\"\")","v":"HBTV (ppbv)"},{"$f":"IF(J15=\"Not Available\",\"Appropriate Toxicity Value Not Available\",IF('Calc Sheet'!D2<>\"p\",'Calc Sheet'!D12,\"\"))","v":20.886838820408801}]
[null,{"$f":"IF('Calc Sheet'!C2=\"p\", \"Soil Concentration (mg/kg)\", \"Percent of Total Volatiles in Air\")","v":"Percent of Total Volatiles in Air"},null,"Response Level (µg/m3)",{"$f":"IF(C15=\"Not Available\",\"Not Available\",IF(C16=\"\",E15,IF(C16=0,\"\",IF(E13=\"7439-92-1\",'Calc Sheet'!C15,IF('Calc Sheet'!C2<>\"P\",'Calc Sheet'!C9,IF('Calc Sheet'!C9>150,150,'Calc Sheet'!C9))))))","v":4.4824561403508776},{"$f":"IF('Calc Sheet'!C2<>\"p\",\"Response Level (ppbv)\",'Calc Sheet'!C17)","v":"Response Level (ppbv)"},{"$f":"IF('Calc Sheet'!C2=\"p\",\"\",IF(C15=\"Not Available\",\"Not Available\",IF(C16=\"\",G15,IF(C16=0,\"\",IF('Calc Sheet'!C2<>\"p\",'Calc Sheet'!C10,\"\")))))","v":"Refer to User's Guide Section 5.2"},null,{"$f":"IF('Calc Sheet'!D2=\"p\", \"Soil Concentration (mg/kg)\", \"Percent of Total Volatiles in Air\")","v":"Percent of Total Volatiles in Air"},null,"Response Level (µg/m3)",{"$f":"IF(J15=\"Not Available\",\"Not Available\",IF(J16=\"\",L15,IF(J16=0,\"\",IF(L13=\"7439-92-1\",'Calc Sheet'!D15,IF('Calc Sheet'!D2<>\"P\",'Calc Sheet'!D9,IF('Calc Sheet'!D9>150,150,'Calc Sheet'!D9))))))","v":109.5},{"$f":"IF('Calc Sheet'!D2<>\"p\",\"Response Level (ppbv)\",'Calc Sheet'!D17)","v":"Response Level (ppbv)"},{"$f":"IF('Calc Sheet'!D2=\"p\",\"\",IF(J15=\"Not Available\",\"Not Available\",IF(J16=\"\",N15,IF(J16=0,\"\",IF('Calc Sheet'!D2<>\"p\",'Calc Sheet'!D10,\"\")))))","v":20.886838820408801}]
[null,{"$f":"IF('Calc Sheet'!C2=\"b\", \"Soil Concentration (mg/kg)\", \"\")","v":"Soil Concentration (mg/kg)"},null,{"$f":"IF('Calc Sheet'!C2=\"b\", \"Response Level (µg/m3)\", \"\")","v":"Response Level (µg/m3)"},{"$f":"IF(C15=\"Not Available\",\"Not Available\",IF(C17=\"\",E15,IF(C17=0,\"\",IF('Calc Sheet'!C20>150,150,'Calc Sheet'!C20))))","v":4.4824561403508776},{"$f":"IF(C15=\"Not Available\", \" \",IF('Calc Sheet'!C2=\"p\",'Calc Sheet'!C18,IF(C17=0,\"\",IF(C17=\"\",\"\",IF('Calc Sheet'!C2=\"b\",'Calc Sheet'!C21,'Calc Sheet'!C18)))))","v":""},null,null,{"$f":"IF('Calc Sheet'!D2=\"b\", \"Soil Concentration (mg/kg)\", \"\")","v":"Soil Concentration (mg/kg)"},null,{"$f":"IF('Calc Sheet'!D2=\"b\", \"Response Level (µg/m3)\", \"\")","v":"Response Level (µg/m3)"},{"$f":"IF(J15=\"Not Available\",\"Not Available\",IF(J17=\"\",L15,IF(J17=0,\"\",IF('Calc Sheet'!D20>150,150,'Calc Sheet'!D20))))","v":109.5},{"$f":"IF(J15=\"Not Available\", \" \",IF('Calc Sheet'!D2=\"p\",'Calc Sheet'!D18,IF(J17=0,\"\",IF(J17=\"\",\"\",IF('Calc Sheet'!D2=\"b\",'Calc Sheet'!D21,'Calc Sheet'!D18)))))","v":""}]

{"sheet":"Calc Sheet","index":2,"n_rows":171,"n_cols":9,"rows_kept":171,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"VLOOKUP(Calculator!E7,'Calc Sheet'!$B$36:$C$171,MATCH(\"Type\",'Calc Sheet'!$B$35:$C$35,0),FALSE)","v":"B"},{"$f":"VLOOKUP(Calculator!L7,'Calc Sheet'!$B$36:$C$171,MATCH(\"Type\",'Calc Sheet'!$B$35:$C$35,0),FALSE)","v":"V"},{"$f":"VLOOKUP(Calculator!E13,'Calc Sheet'!$B$36:$C$171,MATCH(\"Type\",'Calc Sheet'!$B$35:$C$35,0),FALSE)","v":"B"},{"$f":"VLOOKUP(Calculator!L13,'Calc Sheet'!$B$36:$C$171,MATCH(\"Type\",'Calc Sheet'!$B$35:$C$35,0),FALSE)","v":"B"}]
[{"$f":"(Calculator!C9)/((Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":10.950000000000001},{"$f":"(Calculator!J9)/((Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":1095},{"$f":"(Calculator!C15)/((Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":2.0805000000000001E-2},{"$f":"(Calculator!J15)/((Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":109.5}]
[{"$f":"(0.000001)*(70)/(Calculator!C9*(Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":8.5166666666666672E-3},{"$f":"(0.000001)*(70)/(Calculator!J9*(Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":8.5166666666666659E-5},{"$f":"(0.000001)*(70)/(Calculator!C15*(Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":4.4824561403508776},{"$f":"(0.000001)*(70)/(Calculator!J15*(Calculator!F5/24)*(Calculator!G5/365)*Calculator!H5)","v":8.5166666666666659E-4}]
[{"$f":"IF(Calculator!B9=\"Inhalation Unit Risk Factor (µg/m3)-1\", A4, A3)","v":10.950000000000001},{"$f":"IF(Calculator!I9=\"Inhalation Unit Risk Factor (µg/m3)-1\", B4, B3)","v":1095},{"$f":"IF(Calculator!B15=\"Inhalation Unit Risk Factor (µg/m3)-1\", C4, C3)","v":4.4824561403508776},{"$f":"IF(Calculator!I15=\"Inhalation Unit Risk Factor (µg/m3)-1\", D4, D3)","v":109.5}]
[{"$f":"A5*(1000000/Calculator!C10)","v":{"$error":"#DIV/0!"}},{"$f":"B5*(1000000/Calculator!J10)","v":{"$error":"#DIV/0!"}},{"$f":"C5*(1000000/Calculator!C16)","v":{"$error":"#DIV/0!"}},{"$f":"D5*(1000000/Calculator!J16)","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"A5*(100/Calculator!C10)","v":{"$error":"#DIV/0!"}},{"$f":"B5*(100/Calculator!J10)","v":{"$error":"#DIV/0!"}},{"$f":"C5*(100/Calculator!C16)","v":{"$error":"#DIV/0!"}},{"$f":"D5*(100/Calculator!J16)","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(Calculator!B10=\"Soil Concentration (mg/kg)\", A6, A8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Calculator!I10=\"Soil Concentration (mg/kg)\", B6, B8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Calculator!B16=\"Soil Concentration (mg/kg)\", C6, C8)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Calculator!I16=\"Soil Concentration (mg/kg)\", D6, D8)","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(A11>0,A9*24.45/A11, \"Refer to User's Guide Section 5.2\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B11>0,B9*24.45/B11, \"Refer to User's Guide Section 5.2\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C11>0,C9*24.45/C11, \"Refer to User's Guide Section 5.2\")","v":"Refer to User's Guide Section 5.2"},{"$f":"IF(D11>0,D9*24.45/D11, \"Refer to User's Guide Section 5.2\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"VLOOKUP(Calculator!E7,'Calc Sheet'!$B$36:$D$171,MATCH(\"Molecular Weight\",'Calc Sheet'!$B$35:$D$35,0),FALSE)","v":200.59},{"$f":"VLOOKUP(Calculator!L7,'Calc Sheet'!$B$36:$D$171,MATCH(\"Molecular Weight\",'Calc Sheet'!$B$35:$D$35,0),FALSE)","v":78.11},{"$f":"VLOOKUP(Calculator!E13,'Calc Sheet'!$B$36:$D$171,MATCH(\"Molecular Weight\",'Calc Sheet'!$B$35:$D$35,0),FALSE)","v":0},{"$f":"VLOOKUP(Calculator!L13,'Calc Sheet'!$B$36:$D$171,MATCH(\"Molecular Weight\",'Calc Sheet'!$B$35:$D$35,0),FALSE)","v":128.18}]
[{"$f":"IF(A11>0,A5*24.45/A11,\"Refer to User's Guide Section 5.2\")","v":1.3347001346029215},{"$f":"IF(B11>0,B5*24.45/B11,\"Refer to User's Guide Section 5.2\")","v":342.75700934579442},{"$f":"IF(C11>0, C5*24.45/C11, \"Refer to User's Guide Section 5.2\")","v":"Refer to User's Guide Section 5.2"},{"$f":"IF(D11>0,D5*24.45/D11,\"Refer to User's Guide Section 5.2\")","v":20.886838820408801}]
[{"$f":"(Calculator!C9)/(Calculator!F5/24)","v":0.9},{"$f":"(Calculator!J9)/(Calculator!F5/24)","v":90},{"$f":"(Calculator!C15)/(Calculator!F5/24)","v":1.7099999999999999E-3},{"$f":"(Calculator!J15)/(Calculator!F5/24)","v":9}]
[{"$f":"A13*(1000000/Calculator!C10)","v":{"$error":"#DIV/0!"}},{"$f":"B13*(1000000/Calculator!J10)","v":{"$error":"#DIV/0!"}},{"$f":"C13*(1000000/Calculator!C16)","v":{"$error":"#DIV/0!"}},{"$f":"D13*(1000000/Calculator!J16)","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(A14>150, 150,A14)","v":{"$error":"#DIV/0!"}},{"$f":"IF(B14>150, 150,B14)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C14>150, 150,C14)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D14>150, 150,D14)","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(A22>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, the NAAQS limit is the default Response Level\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B22>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, the NAAQS limit is the default Response Level\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C22>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, the NAAQS limit is the default Response Level\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D22>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, the NAAQS limit is the default Response Level\",\"\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF('Calc Sheet'!A2<>\"P\",\"\",IF(Calculator!C10=\"\",\"\",IF(Calculator!C10=0,\"\",IF(Calculator!C9=\"NA\",\"\",IF(Calculator!E7=\"7439-92-1\",A16,IF(A23>=150,\"Value Exceeds NAAQS of 150 ug/m3; \",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!B2<>\"P\",\"\",IF(Calculator!J10=\"\",\"\",IF(Calculator!J10=0,\"\",IF(Calculator!J9=\"NA\",\"\",IF(Calculator!L7=\"7439-92-1\",B16,IF(B23>=150,\"Value Exceeds NAAQS of 150 ug/m3; \",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!C2<>\"P\",\"\",IF(Calculator!C16=\"\",\"\",IF(Calculator!C16=0,\"\",IF(Calculator!C15=\"NA\",\"\",IF(Calculator!E13=\"7439-92-1\",C16,IF(C23>=150,\"Value Exceeds NAAQS of 150 ug/m3; \",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!D2<>\"P\",\"\",IF(Calculator!J16=\"\",\"\",IF(Calculator!J16=0,\"\",IF(Calculator!J15=\"NA\",\"\",IF(Calculator!L13=\"7439-92-1\",D16,IF(D23>=150,\"Value Exceeds NAAQS of 150 ug/m3; \",\"\"))))))","v":""}]
[{"$f":"IF('Calc Sheet'!A2<>\"P\",\"\",IF(Calculator!C10=\"\",\"\",IF(Calculator!C10=0,\"\",IF(Calculator!C9=\"NA\",\"\",IF(Calculator!E7=\"7439-92-1\",A19,IF(A23>=150,\"therefore, value                                           defaults to                                           NAAQS limit\",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!B2<>\"P\",\"\",IF(Calculator!J10=\"\",\"\",IF(Calculator!J10=0,\"\",IF(Calculator!J9=\"NA\",\"\",IF(Calculator!L7=\"7439-92-1\",B19,IF(B23>=150,\"therefore, value                                           defaults to                                           NAAQS limit\",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!C2<>\"P\",\"\",IF(Calculator!C16=\"\",\"\",IF(Calculator!C16=0,\"\",IF(Calculator!C15=\"NA\",\"\",IF(Calculator!E13=\"7439-92-1\",C19,IF(C23>=150,\"therefore, value                                           defaults to                                           NAAQS limit\",\"\"))))))","v":""},{"$f":"IF('Calc Sheet'!D2<>\"P\",\"\",IF(Calculator!J16=\"\",\"\",IF(Calculator!J16=0,\"\",IF(Calculator!J15=\"NA\",\"\",IF(Calculator!L13=\"7439-92-1\",D19,IF(D23>=150,\"therefore, value                                           defaults to                                           NAAQS limit\",\"\"))))))","v":""}]
[{"$f":"IF(A22>=150,\"therefore,                                            value defaults to                                                NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B22>=150,\"therefore,                                            value defaults to                                                NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C22>=150,\"therefore,                                            value defaults to                                                NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D22>=150,\"therefore,                                            value defaults to                                                NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"A5*(1000000/Calculator!C11)","v":{"$error":"#DIV/0!"}},{"$f":"B5*(1000000/Calculator!J11)","v":{"$error":"#DIV/0!"}},{"$f":"C5*(1000000/Calculator!C17)","v":{"$error":"#DIV/0!"}},{"$f":"D5*(1000000/Calculator!J17)","v":{"$error":"#DIV/0!"}}]
[{"$f":"IF(A24>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, value defaults to NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(B24>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, value defaults to NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(C24>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, value defaults to NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(D24>=150,\"Value Exceeds NAAQS of 150 ug/m3; therefore, value defaults to NAAQS limit\",\"\")","v":{"$error":"#DIV/0!"}}]
[{"$f":"ROUND(A14,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(B14,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C14,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D14,0)","v":{"$error":"#DIV/0!"}}]
[{"$f":"ROUND(A9,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(B9,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C9,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D9,0)","v":{"$error":"#DIV/0!"}}]
[{"$f":"ROUND(A20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(B20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(C20,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D20,0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Chemical","CAS Number","Type","Molecular Weight",null,null,"ppbv","µg/m3","ppbv"]
["Acenaphthene","83-32-9","P",154.21]
["Acetone (2-Propanone)","67-64-1","V",58.08,null,null,0.2,{"$f":"(G37*D37)/24.5","v":0.47412244897959183},{"$f":"H37*24.5/D37","v":0.2}]
["Acetophenone","98-86-2","v",120.15,null,null,0.2,{"$f":"(G38*D38)/24.5","v":0.98081632653061224},{"$f":"H38*24.5/D38","v":0.2}]
["Aldrin","309-00-2","p",364.92]
["Aluminum (total)","7429-90-5","P",26.981999999999999]
["Anthracene","120-12-7","P",178.24]
["Antimony (total)","7440-36-0","p",121.76]
["Arsenic (total)","7440-38-2","P",74.921999999999997]
["Atrazine","1912-24-9","p",215.69]
["Barium (total)","7440-39-3","P",137.33000000000001]
["Benzaldehyde","100-52-7","v",106.12,null,null,0.2,{"$f":"(G46*D46)/24.5","v":0.86628571428571444},{"$f":"H46*24.5/D46","v":0.20000000000000004}]
["Benzene","71-43-2","V",78.11,null,null,0.2,{"$f":"(G47*D47)/24.5","v":0.63763265306122452},{"$f":"H47*24.5/D47","v":0.2}]
["Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3","P",228.3]
["Benzo(a)pyrene","50-32-8","P",252.31]
["Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2","P",252.32]
["Benzo(k)fluoranthene","207-08-9","P",252.32]
["Beryllium","7440-41-7","P",9.01]
["1,1'-Biphenyl","92-52-4","p",154.21]
["Bis(2-chloroethoxy)methane","111-91-1","P",173.04]
["Bis(2-chloroethyl)ether","111-44-4","V",143.01,null,null,0.2,{"$f":"(G55*D55)/24.5","v":1.1674285714285715},{"$f":"H55*24.5/D55","v":0.2}]
["Bis(2-chloroisopropyl)ether; (2,2'-oxybis(1-chloropropane)); (2-chloro-1-methylethyl) ether","108-60-1","p",171.07]
["Bis(2-ethylhexyl)phthalate","117-81-7","p",390.57]
["Bromodichloromethane (Dichlorobromomethane)","75-27-4","v",163.83000000000001,null,null,0.2,{"$f":"(G58*D58)/24.5","v":1.337387755102041},{"$f":"H58*24.5/D58","v":0.2}]
["Bromoform","75-25-2","v",252.73,null,null,0.2,{"$f":"(G59*D59)/24.5","v":2.0631020408163265},{"$f":"H59*24.5/D59","v":0.2}]
["Bromomethane (Methyl bromide)","74-83-9","V",94.94,null,null,0.2,{"$f":"(G60*D60)/24.5","v":0.77502040816326534},{"$f":"H60*24.5/D60","v":0.2}]
["2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3","V",72.11,null,null,0.5,{"$f":"(G61*D61)/24.5","v":1.4716326530612245},{"$f":"H61*24.5/D61","v":0.5}]
["Butylbenzyl phthalate","85-68-7","p",312.37]
["Cadmium","7440-43-9","P",112.41]
["Caprolactam","105-60-2","P",113.16]
["Carbon disulfide","75-15-0","V",76.13,null,null,0.5,{"$f":"(G65*D65)/24.5","v":1.553673469387755},{"$f":"H65*24.5/D65","v":0.5}]
["Carbon tetrachloride","56-23-5","V",153.82,null,null,0.2,{"$f":"(G66*D66)/24.5","v":1.2556734693877551},{"$f":"H66*24.5/D66","v":0.20000000000000004}]
["Chlordane (alpha and gamma forms summed)","57-74-9","P",409.78]
["4-Chloroaniline","106-47-8","P",127.57]
["Chlorobenzene","108-90-7","V",112.56,null,null,0.2,{"$f":"(G69*D69)/24.5","v":0.91885714285714293},{"$f":"H69*24.5/D69","v":0.2}]
["Chloroethane (Ethyl chloride)","75-00-3","V",64.52,null,null,0.5,{"$f":"(G70*D70)/24.5","v":1.316734693877551},{"$f":"H70*24.5/D70","v":0.5}]
["Chloroform","67-66-3","V",119.38,null,null,0.2,{"$f":"(G71*D71)/24.5","v":0.97453061224489801},{"$f":"H71*24.5/D71","v":0.2}]
["Chloromethane (Methyl chloride)","74-87-3","V",50.49,null,null,0.5,{"$f":"(G72*D72)/24.5","v":1.0304081632653062},{"$f":"H72*24.5/D72","v":0.5}]
["2-Chloronaphthalene","91-58-7","P",162.62]
["2-Chlorophenol (o-Chlorophenol)","95-57-8","p",128.56]
["Chrysene","218-01-9","P",228.3]
["Cobalt (total)","7440-48-4","P",58.93]
["Copper (total)","7440-50-8","p",63.55]
["Cyanide","57-12-5","P",26.017399999999999]
["Cyclohexane","110-82-7","V",84.162999999999997]
["4,4'-DDD (p,p'-TDE)","72-54-8","p",320.05]
["4,4'-DDE (p,p'-DDX)","72-55-9","p",318.02999999999997]
["4,4'-DDT","50-29-3","p",354.49]
["Dibenz(a,h)anthracene","53-70-3","P",278.36]
["Dibromochloromethane (Chlorodibromomethane)","124-48-1","v",208.28,null,null,0.2,{"$f":"(G84*D84)/24.5","v":1.700244897959184},{"$f":"H84*24.5/D84","v":0.20000000000000004}]
["1,2-Dibromo-3-chloropropane","96-12-8","V",236.33,null,null,0.2,1.9292244897959185,0.2]
["1,2-Dibromoethane (Ethylene dibromide)","106-93-4","V",187.86,null,null,0.2,1.5335510204081633,0.2]
["1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1","V",147,null,null,0.2,1.2000000000000002,0.20000000000000004]
["1,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-1","v",147,null,null,0.2,1.2000000000000002,0.20000000000000004]
["1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7","v",147,null,null,0.2,1.2000000000000002,0.20000000000000004]
["3,3'-Dichlorobenzidine","91-94-1","v",253.13,null,null,0.2,2.0663673469387756,0.19999999999999998]
["Dichlorodifluoromethane (Freon 12)","75-71-8","v",120.91,null,null,0.5,2.467551020408163,0.49999999999999994]
["1,1-Dichloroethane","75-34-3","v",98.96,null,null,0.2,0.80783673469387762,0.20000000000000004]
["1,2-Dichloroethane","107-06-2","V",98.96,null,null,0.2,0.80783673469387762,0.20000000000000004]
["1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4","V",96.94,null,null,0.2,0.79134693877551032,0.2]
["1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2","v",96.94,null,null,0.2,0.79134693877551032,0.2]
["1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5","v",96.94,null,null,0.2,0.79134693877551032,0.2]
["2,4-Dichlorophenol","120-83-2","v",163]
["1,2-Dichloropropane","78-87-5","V",112.99,null,null,0.2,{"$f":"(G98*D98)/24.5","v":0.92236734693877542},{"$f":"H98*24.5/D98","v":0.2}]
["1,3-Dichloropropene (total)","542-75-6","V",110.97,null,null,0.2,{"$f":"(G99*D99)/24.5","v":0.90587755102040823},{"$f":"H99*24.5/D99","v":0.20000000000000004}]
["Dieldrin","60-57-1","p",380.91]
["Diethylphthalate","84-66-2","p",222.24]
["2,4-Dimethylphenol","105-67-9","p",122.17]
["Di-n-butyl phthalate","84-74-2","p",278.35000000000002]
["2,4-Dinitrophenol","51-28-5","p",184.11]
["2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6","p",182.14]
["Di-n-octyl phthalate","117-84-0","p",390.57]
["1,4-Dioxane","123-91-1","V",88.11,null,null,0.2,{"$f":"(G107*D107)/24.5","v":0.71926530612244899},{"$f":"H107*24.5/D107","v":0.2}]
["Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7","p",406.92]
["Endrin","72-20-8","p",380.91]
["Ethylbenzene","100-41-4","V",106.17,null,null,0.2,{"$f":"(G110*D110)/24.5","v":0.86669387755102045},{"$f":"H110*24.5/D110","v":0.2}]
["Fluoranthene","206-44-0","P",202.26]
["Fluorene","86-73-7","P",166.22]
["alpha-HCH (alpha-BHC)","319-84-6","p",290.83]
["beta-HCH (beta-BHC)","319-85-7","p",290.83]
["Heptachlor","76-44-8","p",373.32]
["Heptachlor epoxide","1024-57-3","p",389.32]
["Hexachlorobenzene","118-74-1","v",284.77999999999997,null,null,0.2,{"$f":"(G117*D117)/24.5","v":2.3247346938775508},{"$f":"H117*24.5/D117","v":0.2}]
["Hexachloro-1,3-butadiene","87-68-3","v",260.76,null,null,0.2,{"$f":"(G118*D118)/24.5","v":2.1286530612244898},{"$f":"H118*24.5/D118","v":0.2}]
["Hexachlorocyclopentadiene","77-47-4","P",272.77]
["Hexachloroethane","67-72-1","V",236.74]
["n-Hexane","110-54-3","V",86.18,null,null,0.2,{"$f":"(G121*D121)/24.5","v":0.70351020408163267},{"$f":"H121*24.5/D121","v":0.19999999999999998}]
["2-Hexanone","591-78-6","V",100.16]
["Indeno(1,2,3-cd)pyrene","193-39-5","P",276.33999999999997]
["Isophorone","78-59-1","V",138.21,null,null,0.2,{"$f":"(G124*D124)/24.5","v":1.1282448979591837},{"$f":"H124*24.5/D124","v":0.19999999999999998}]
["Isopropylbenzene","98-82-8","V",120.19,null,null,0.2,{"$f":"(G125*D125)/24.5","v":0.98114285714285721},{"$f":"H125*24.5/D125","v":0.2}]
["Lead (total)","7439-92-1","P",207.2]
["Lindane (gamma-HCH)(gamma-BHC)","58-89-9","p",290.83]
["Manganese (total)","7439-96-5","P",54.94]
["Mercury (total)","7439-97-6","B",200.59]
["Methoxychlor","72-43-5","v",345.66,null,null,0.2,{"$f":"(G130*D130)/24.5","v":2.8217142857142861},{"$f":"H130*24.5/D130","v":0.2}]
["Methyl acetate","79-20-9","v",74.08,null,null,0.2,{"$f":"(G131*D131)/24.5","v":0.60473469387755108},{"$f":"H131*24.5/D131","v":0.2}]
["Methylene chloride (Dichloromethane)","75-09-2","V",84.93,null,null,0.5,{"$f":"(G132*D132)/24.5","v":1.7332653061224492},{"$f":"H132*24.5/D132","v":0.5}]
["2-Methylnaphthalene","91-57-6","p",142.19999999999999]
["4-Methyl-2-pentanone (MIBK)","108-10-1","V",100.16,null,null,0.2,{"$f":"(G134*D134)/24.5","v":0.81763265306122446},{"$f":"H134*24.5/D134","v":0.2}]
["2-Methylphenol (o-cresol)","95-48-7","p",108.14]
["4-Methylphenol (p-cresol)","106-44-5","p",108.14]
["Methyl tert-butyl ether (MTBE)","1634-04-4","V",88.15,null,null,0.2,{"$f":"(G137*D137)/24.5","v":0.71959183673469396},{"$f":"H137*24.5/D137","v":0.2}]
["Naphthalene","91-20-3","B",128.18,null,null,0.2,{"$f":"(G138*D138)/24.5","v":1.0463673469387755},{"$f":"H138*24.5/D138","v":0.19999999999999998}]
["Nickel (total)","7440-02-0","P",58.69]
["4-Nitroaniline","100-01-6","P",138.13]
["Nitrobenzene","98-95-3","V",123.11]
["N-Nitrosodi-n-propylamine","621-64-7","v",130.19]
["N-Nitrosodiphenylamine","86-30-6","p",198.23]
["Pentachlorophenol","87-86-5","p",266.33999999999997]
["Phenol","108-95-2","V",94.11,null,null,0.2,{"$f":"(G145*D145)/24.5","v":0.7682448979591836},{"$f":"H145*24.5/D145","v":0.19999999999999998}]
["Polychlorinated biphenyls (PCBs)","1336-36-3","B"]
["Pyrene","129-00-0","P",202.26]
["Selenium (total)","7782-49-2","p",78.959999999999994]
["Silver (total)","7440-22-4","p",107.87]
["Styrene","100-42-5","V",104.15,null,null,0.2,{"$f":"(G150*D150)/24.5","v":0.85020408163265315},{"$f":"H150*24.5/D150","v":0.2}]
["Tertiary butyl alcohol (TBA)","75-65-0","v",74.12,null,null,5,{"$f":"(G151*D151)/24.5","v":15.126530612244899},{"$f":"H151*24.5/D151","v":5}]
["1,2,4,5 - Tetrachlorobenzene","95-94-3","v",215.89,null,null,0.2,{"$f":"(G152*D152)/24.5","v":1.7623673469387755},{"$f":"H152*24.5/D152","v":0.2}]
["2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-01-6","p",321.98]
["1,1,2,2-Tetrachloroethane","79-34-5","v",167.85,null,null,0.2,{"$f":"(G154*D154)/24.5","v":1.3702040816326531},{"$f":"H154*24.5/D154","v":0.2}]
["Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4","V",165.83,null,null,0.2,{"$f":"(G155*D155)/24.5","v":1.3537142857142859},{"$f":"H155*24.5/D155","v":0.2}]
["2,3,4,6-Tetrachlorophenol","58-90-2","p",231.89]
["Toluene","108-88-3","V",92.14,null,null,0.2,{"$f":"(G157*D157)/24.5","v":0.75216326530612243},{"$f":"H157*24.5/D157","v":0.2}]
["Toxaphene","8001-35-2","p",413.82]
["1,2,4-Trichlorobenzene","120-82-1","V",181.45,null,null,0.5,{"$f":"(G159*D159)/24.5","v":3.7030612244897956},{"$f":"H159*24.5/D159","v":0.5}]
["1,1,1-Trichloroethane","71-55-6","V",133.41,null,null,0.2,1.0890612244897959,0.19999999999999998]
["1,1,2-Trichloroethane","79-00-5","v",133.41,null,null,0.2,1.0890612244897959,0.19999999999999998]
["Trichloroethene (TCE) (Trichloroethylene)","79-01-6","V",131.38999999999999,null,null,0.2,1.0725714285714285,0.2]
["Trichlorofluoromethane (Freon 11)","75-69-4","v",137.37,null,null,0.2,1.121387755102041,0.2]
["2,4,5-Trichlorophenol","95-95-4","p",197.45,null,null,0.2,1.6118367346938776,0.2]
["1,1,2-Trichloro-1,2,2-trifluoroethane","76-13-1","V",187.38]
["1,2,4-Trimethylbenzene","95-63-6","V",120.2]
["2,4,6-Trichlorophenol","88-06-2","p",197.45]
["Vanadium (total)","7440-62-2","P",50.94]
["Vinyl chloride","75-01-4","V",62.5,null,null,0.2,{"$f":"(G169*D169)/24.5","v":0.51020408163265307},{"$f":"H169*24.5/D169","v":0.2}]
["Xylenes (total)","1330-20-7","V",106.17,null,null,0.2,{"$f":"(G170*D170)/24.5","v":0.86669387755102045},{"$f":"H170*24.5/D170","v":0.2}]
["Zinc (total)","7440-66-6","p",65.38]

{"sheet":"User's Guide","index":3,"n_rows":254,"n_cols":1,"rows_kept":254,"cut":false,"hidden":false,"merged":[[0,0,22,0],[131,0,221,0],[101,0,130,0],[222,0,252,0],[253,0,280,0],[23,0,60,0],[61,0,78,0],[79,0,100,0]]}
["User's Guide\n\n1. Enter the Site name, PI #, the name of person conducting the evaluation, and the date.\n2. Enter the number of hours per day and days per year.\n3. Select the number of chemicals that need an HBTV and Initial Response Level.\n4. Select the chemicals from the drop-down list(s).\n5. Enter the soil concentration or percent of total volatiles for each chemical, as appropriate.\n6. Print results.\n\n  Table of Contents:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n1. PAM Calculator Standard Operating Procedure:\n\nNote: The blue boxes are for site-specific information, such as site name, program interest number, etc. Yellow boxes within the calculator are protected and represent values that cannot be changed. Blue boxes require user input to appropriately calculate health-based threshold values (HBTVs) and Response Level values. \n\n1. Enter the Site Name, Program Interest Number (PI #) for the Site, name of person conducting the evaluation, and the date in the white boxes.\n\n2. Enter the projected number of hours per day that remediation efforts will be conducted. The hours per day can be adjusted and response levels recalculated should project conditions change. The calculator allows the user to enter work hour durations between 8-12 hours per day. If work hours fall outside of the range, please contact the Department. \n\n3. Enter the projected number of days per year that remediation efforts will be conducted. Be advised that the number of days cannot exceed 225 (NJDEP default exposure assumption for a non-residential exposure scenario) for the use of this calculator. The days per year can be adjusted and response levels recalculated should project conditions change. The calculator allows the user to enter between 20-225 days for the project duration. If remediation efforts will be conducted for greater than 225 days, please contact the Department. \n\n4. Select the Number of Contaminants requiring the development of a HBTV and Response Level. The calculator allows the user to enter in a maximum of four contaminants at a time. If greater than four COCs exist at the site, a subsequent calculator(s) should be run for the remaining contaminants. \n\n5. Select the COC from the Contaminant drop-down list(s). Selected contaminants should be those that are drivers for the air monitoring program (i.e., those that pose the greatest health risk to receptors based on their known concentrations in soil and/or their toxicity).\n\n6. Enter the soil concentration for calculation of particulate Response Levels or percent volatile of total volatiles in air for calculation of vapor Response Levels for each chemical, as appropriate. See Section 5 of this User’s Guide for derivation of soil concentration and percent total volatiles. \n\n7. Print results. HBTV and Response Levels will automatically populate once all required information has been entered."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n2. Calculator Scope\n\nThe NJDEP Perimeter Air Monitoring (PAM) Calculator is used to aid in calculating the HBTV and Response Level for a given contaminant at a remediation site. The HBTV is a calculated air concentration that is protective of human health for off-site receptors. The HBTV is calculated from selected chemical specific toxicity reference values and site-specific exposure assumptions (e.g., expected duration of the remedial activities having the potential for causing air emissions, hours worked per day, etc.). The response level is derived from the HBTV input values and is calculated using site-specific soil data. The response level is a concentration of a contaminant that is present as a vapor and/or particulate matter (PM10) which, if exceeded, acts as a threshold that dictates when additional actions should be taken to reduce vapors/particulate matter for the protection of receptors. \n\nPlease be advised that the HBTV and response level values calculated using this resource are suggested concentrations that are not to be exceeded. More stringent HBTVs and response level values may be used if they are required to ensure receptor or public safety/health or to address other receptor and public concerns. The HBTVs and response levels may also be adjusted throughout the PAM process as confirmatory analytical data become available. \n\n\n\n\n\n\n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n3. Health-Based Threshold Values\n\nHBTVs are derived using the health-based targets set forth in the New Jersey Brownfield Act (N.J.S.A. 58:10B-12.d). This statute mandates that the Department develop remediation standards based on (a) an additional cancer risk of one in one million and (b) a hazard quotient of one (1) for noncarcinogens. Given the short-term nature of PAM, as covered in the PAM Technical Guidance for project durations of 225 working days or less per calendar year, the noncancer endpoint (reference concentration (RfC)) was chosen, where available. If an RfC is not available for a contaminant, but an inhalation unit risk (IUR) factor for carcinogenicity is available, the IUR may be used to develop an HBTV.\n\nThe health-based targets approved by the Department, the HBTV equations, and the contaminant inhalation toxicity values are already incorporated into the calculator for user convenience. An estimate of the reasonable maximum total number of days and number of hours each day vapors or particulate emissions associated with remedial action are expected to occur should be used to set the exposure assumptions associated with the chronic RfC or IUR. If the noncancer or cancer toxicity criteria for a particular COC are not in the calculator, contact the Department for guidance. The inhalation toxicity values used in the calculator can be found in Appendix B of the Perimeter Air Monitoring Technical Guidance. \n\nFor cases where an area of concern or site COC is identified and not listed in the PAM calculator, consult the Department to determine if appropriate inhalation toxicity information is available and an HBTV can be calculated for the COC in question.\n\n\n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n4. HBTV Equations\n\nA.  \tUsing a Reference Concentration (RfC) to Derive an HBTV\n\n\n\nWhere:\n  RfC = Reference Concentration = Contaminant-specific (μg/m3)\n  AT = Averaging Time = 1 year\n  ET = Exposure Time = Work shift length (hours/24 hours)\n  EF = Exposure Frequency = Length of actual excavation (days/365 days)\n  ED = Exposure Duration = 1 year\n\nB.  \tUsing an Inhalation Unit Risk (IUR) to Derive an HBTV\n\nIf an RfC is not available for a contaminant, but an IUR (for carcinogenicity) is available, the IUR may be used to develop an HBTV.\n\n\n\nWhere:\n  TR = Target Risk = 1 x 10-6\n  AT = Averaging Time = 70 years\n  IUR = Inhalation Unit Risk = Contaminant-specific but in terms of (μg/m3)-1 \n  ET = Exposure Time = Work shift length (hours/24 hours)\n  EF = Exposure Frequency = Length of actual excavation (days/365 days)\n  ED = Exposure Duration = 1 year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n5. Response Levels \n\nCalculated response level air concentrations are based on the HBTV but are adjusted using site-specific soil data to account for the capabilities of the selected monitoring instrumentation. Adjustments may include:\n\n• \tFor particulates: using an estimate of the soil contaminant concentration (e.g., 95% UCL of all contaminant-specific soil values in the area to be remediated) to adjust the response level for a specific contaminant to a general dust level as measured by a particulate meter.\n\n• \tFor volatiles: using the percent of a specific contaminant to adjust the response level to a general total volatiles concentration as measured by a real-time VOC meter.\n\nNOTE:  For PCBs, mercury, and naphthalene, the PAM calculator will calculate both particulate and volatile response levels due to the chemical properties of these contaminants and their ability to exist in both forms in the environment (see Section 7.1 of the PAM Technical Guidance).\n\nNOTE:  For real-time instrumentation that can detect specific contaminants (e.g., field gas chromatograph, mercury detector) response levels should not be used, as no adjustment to the HBTV is necessary. However, the contaminant HBTV air concentrations may be used with a time-weighted average (TWA) monitoring interval of 15-minutes or less. \n\nNOTE:  Although particulate real time response levels will be derived using the PAM calculator, analytical sampling for PCBs must also be conducted to appropriately evaluate both volatile and particulate fractions.  Analytical data for PCBs should be compared to the HBTVs and evaluation conducted to determine if PCB concentrations are consistently below the HBTVs.  If analysis confirms that concentrations are consistently below the HBTV, the use of real time monitoring using PM10 as the surrogate may be employed.\n\n5.1\t Determining Percent of Total Volatiles\n\nWhen calculating the response level for volatiles, the PAM calculator requires the user to determine the “percent of total volatiles” for input into the PAM calculator. To determine the appropriate value for this input parameter, review available data to identify the maximum contaminant levels in soil for each volatile contaminant where the data indicates exceedance of the most stringent soil remediation standard (residential soil remediation standards for the ingestion-dermal and inhalation exposure pathways, and soil remediation standard for migration to ground water exposure pathway). If there is sufficient characterization data, the statistical mean of the dataset for the area(s) being remediated can be calculated (i.e., 95% upper confidence limit (UCL) of the arithmetic mean), otherwise the maximum value should be used. Next, the soil concentration (maximum concentration or 95% UCL of the mean) for the individual VOC being evaluated should be divided by the total soil concentration for all VOCs detected to determine the percent of total volatiles [% of Total Volatiles = (Individual VOC soil concentration (mg/kg)/Total VOCs soil concentration (mg/kg)) X 100].  This methodology assumes the fraction of total VOCs will be consistent with that in the soil. This methodology can be applied on a site-wide or an AOC-specific basis. Please see Step 1 of Appendix F for a case study of these steps and calculations. Once laboratory confirmation data is received for the site, the percent volatile may be adjusted based on the analytical results by using percent of an individual volatile per total volatiles in air.\n\nWhen using a real-time monitor to monitor for total volatiles, the investigator must also take into account the capabilities of the selected instrumentation and ensure that not only the appropriate correction factor will be used but that the instrument can detect contaminant concentrations below the calculated response level.\n\n5.2\tSemi-Volatile Response Levels – Volatile vs. Particulate Real-Time Monitoring Determination\n\nFor the purposes of real-time monitoring using a real-time monitor for semi-volatiles, the PAM calculator will calculate response levels for both the particulate and volatile fractions for PCBs, mercury, and naphthalene. It is the responsibility of the investigator to evaluate and justify which form(s) will be monitored in the site-specific PAM plan. Justification can be supported with analytical results (air or speciated soil data) and/or chemical properties information. \n\nThe remedial actions selected to address soil contamination can also provide the basis for the type of real time monitoring selected for semi-volatiles. For example, the selection of treatments to remediate PCB contamination in soils and sediments that employ an exothermic process would require monitoring for volatiles as this type of treatment has been shown to volatilize PCBs.\n\nIt should be noted that neither a HBTV nor a response level can be calculated for PCBs in ppbv using the PAM Calculator since Total PCBs are a mixture of PCB congeners whose individual molecular weights differ.\n\n5.3 \tCeiling Limits \n\nA ceiling limit is an established concentration that can act as a response level for vapor or particulate matter. A ceiling limit can be developed as a site-wide maximum allowable concentration for a particular type of media. This value may be a site-specific calculation (e.g., the calculated HBTV or response level) or may be derived from existing guidance material. The 24-hour National Ambient Air Quality Standard (NAAQS) for PM10 of 150 µg/m3 is used as the ceiling value for the calculation of particulate HBTVs and real-time response levels and should not be exceeded. This value may serve as the response level for particulate matter during remediation activities. However, more stringent time-weighted average concentrations may be calculated using the HBTV and response level calculator depending on the toxicity and soil concentration of the contaminant, thus each contaminant should be evaluated individually.\n\n5.4 \tShorter-Duration Time-Weighted Average Response Levels\n\nThe PAM Calculator will produce contaminant specific response level values, derived from HBTV values, that should be used during remediation at the perimeter of the site. The investigator may use the response level as a shorter-duration time-weighted average (e.g., 5-minute, 15-minute) value to accommodate instantaneous response level exceedances that may resolve quickly without intervention. This may aid in reducing the quantity of immediate reactionary protocols and work cessations to address these exceedances. If the response level is exceeded over the selected weighted averaging period, sources of emissions should be identified, instrumentation checked, and corrective actions and confirmatory sampling initiated as appropriate (see Section 5.6.1 through Section 5.6.3 of the PAM Technical Guidance) to confirm that the daily HBTVs are not being exceeded at the site. Note that the use of a shorter-duration TWA does not require any additional calculations other than the HBTV and Response Level concentrations. \n\nExample for the Development of the HBTV, Response Level, and Shorter-Duration TWA:\n\nUser Input for PAM Calculator: \n•  Exposure time – 8 hours\n•  Exposure frequency – 30 days\n•  Number of contaminants – 1 \n•  Contaminant – Benzene\n•  Percent volatiles in air – 2%\n\nCalculator Output:\n•  HBTV – 3.43 x 102 ppbv\n•  Response level – 1.71 x 104 ppbv (for the entire 8-hour day)\n•  15-minute TWA used for real-time PAM monitoring responses – 1.71 x 104 ppbv"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n6. Measuring Protectiveness of Response Levels\n\nThe protectiveness of the real-time response level must be confirmed by taking confirmatory laboratory analytical samples, both during commencement of representative emission generating activities and periodically (e.g., once a week) over the course of the remediation. The results of confirmatory sample analysis should be compared to the COCs’ HBTVs to ensure COC concentrations are below their respective HBTV, and the real-time monitoring program is functioning as designed. For cases where the analytical results indicate that the response levels are not protective (i.e., confirmatory sampling results exceed the HBTV(s)), the following information should be evaluated:\n\n1) Assess the analytical data to determine if new COCs are present. If so, HBTVs and response levels should be calculated for the new COCs. New equipment may be necessary for the real-time monitoring and confirmatory sampling of these COCs.\n\n2) Determine whether the incorrect real-time equipment was selected to monitor the site COCs. If the equipment is incapable of detecting the site COCs, new equipment should be selected and employed.\n\n3) Determine whether an incorrect surrogate was selected for real-time monitoring of COCs. If an incorrect surrogate was selected, a new surrogate should be determined, or contaminant-specific instrumentation can be used at the perimeter for real-time monitoring.\n\n4) Determine whether the characterization data that was used to calculate the HBTVs and response levels was insufficient (e.g., not enough data, data that is not representative, unidentified hotspots). If characterization data is incomplete, additional sampling may be required to adequately address site COCs and concentrations for the development of HBTVs and response levels. \n\nFor cases where analytical results consistently demonstrate that COCs for which HBTVs and response levels were initially calculated are not present in one or both forms (volatile and particulate), discretion may be used to reduce or discontinue monitoring, or reduce or discontinue confirmatory analytical sampling. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["\n7. Response Level Equations\n\nA. Response Level Particulate Equation\n\n\n\nWhere:\n\n  HBTV (carcinogenic or non-carcinogenic) is calculated using the equations from Section 3.A or 3.B above. \n\n  Soil Concentration = Concentration in mg/kg of selected contaminant (e.g., 95% UCL of the mean) \n\n\nB. Response Level Vapor Equation\n\n\n\nWhere:\n\n  HBTV (carcinogenic or non-carcinogenic) is calculated using the equations from Section 3.A. or 3.B. "]