{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Master database","foc calc","MGW-ExistChem","MGW-NewChem","MGW-DAF","MGW-SPLP-ExistChem","MGW-SPLP-NewChem","MGW-SPLP-PFAS","Sheet1"],"not_rendered":{"charts":0,"images":45,"macros":1,"external_links":0,"defined_names":6,"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":12,"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 Ground water practical quantitation level (µg/L)","2018 Standards Ground Water Remediation Standard (µg/L)","2018 Standards Soil Reporting Limit (mg/kg)","2018 Standards Ambient background (mg/kg)","2018 Standards Water Solubility (mg/L)","2018 Standards Henry's Law Constant (atm-m3/mol),25°C","2018 Standards Henry's Law Constant (dimensionless, 25°C)","2018 Standards Koc (L/kg)","2018 Standards Kd (L/kg)"]
[1,"Acenaphthene","83-32-9",10,400,0.17,"NA",3.9,1.84E-4,7.5224000000000003E-3,5027,"NA"]
[3,"Acetone (2-Propanone)","67-64-1",10,6000,0.01,"NA",1000000,3.4999999999999997E-5,1.4308999999999999E-3,2.3639999999999999,"NA"]
[4,"Acetophenone","98-86-2",10,700,0.33,"NA",6130,1.04E-5,4.2517999999999999E-4,51.85,"NA"]
[7,"Aldrin","309-00-2",0.04,0.04,1.6999999999999999E-3,"NA",1.7000000000000001E-2,4.3999999999999999E-5,1.7989E-3,82020,"NA"]
[8,"Aluminum (total)","7429-90-5",30,"NA",20,"NA","NA",0,0,"NA",1500]
[9,"Anthracene","120-12-7",10,2000,0.17,"NA",4.3400000000000001E-2,5.5600000000000003E-5,2.2731000000000001E-3,16360,"NA"]
[10,"Antimony (total)","7440-36-0",3,6,1,"NA","NA",0,0,"NA",45]
[11,"Arsenic (total)","7440-38-2",3,3,0.5,19,"NA",0,0,"NA",26]
[12,"Atrazine","1912-24-9",0.1,3,0.33,"NA",34.700000000000003,2.3600000000000001E-9,9.6484000000000006E-8,224.5,"NA"]
[13,"Barium (total)","7440-39-3",200,6000,5,"NA","NA",0,0,"NA",17]
[14,"Benzaldehyde","100-52-7","NA","NA",0.33,"NA",6950,2.6699999999999998E-5,1.0916000000000001E-3,11.09,"NA"]
[15,"Benzene","71-43-2",1,1,5.0000000000000001E-3,"NA",1790,5.5500000000000002E-3,0.22690109999999999,145.80000000000001,"NA"]
[17,"Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3",0.1,0.1,0.17,"NA",9.4000000000000004E-3,1.2E-5,4.9058999999999995E-4,176900,"NA"]
[18,"Benzo(a)pyrene","50-32-8",0.1,0.1,0.17,"NA",1.6199999999999999E-3,4.5699999999999998E-7,1.8683000000000001E-5,587400,"NA"]
[19,"Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2",0.2,0.2,0.17,"NA",1.5E-3,6.5700000000000002E-7,2.686E-5,599400,"NA"]
[21,"Benzo(k)fluoranthene","207-08-9",0.3,0.5,0.17,"NA",8.0000000000000004E-4,5.8400000000000004E-7,2.3875000000000001E-5,587400,"NA"]
[23,"Beryllium","7440-41-7",1,1,0.5,"NA","NA",0,0,"NA",35]
[24,"1,1'-Biphenyl","92-52-4",10,400,0.17,"NA",7.48,3.0800000000000001E-4,1.2592000000000001E-2,5129,"NA"]
[25,"Bis(2-chloroethoxy)methane","111-91-1","NA","NA",0.17,"NA",7800,3.8500000000000004E-6,1.574E-4,14.38,"NA"]
[26,"Bis(2-chloroethyl)ether","111-44-4",7,7,0.33,"NA",17200,1.7E-5,6.9501000000000003E-4,32.21,"NA"]
[27,"Bis(2-ethylhexyl)phthalate","117-81-7",3,3,0.17,"NA",0.27,2.7000000000000001E-7,1.1038E-5,119600,"NA"]
[28,"Bromodichloromethane (Dichlorobromomethane)","75-27-4",1,1,5.0000000000000001E-3,"NA",3030,2.1199999999999999E-3,8.6672100000000002E-2,31.82,"NA"]
[30,"Bromoform","75-25-2",0.8,4,5.0000000000000001E-3,"NA",3100,5.3499999999999999E-4,2.18724E-2,31.82,"NA"]
[31,"Bromomethane (Methyl bromide)","74-83-9",1,10,5.0000000000000001E-3,"NA",15200,7.3400000000000002E-3,0.30008180000000001,13.22,"NA"]
[33,"2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3",2,300,0.01,"NA",223000,5.6900000000000001E-5,2.3262000000000001E-3,4.51,"NA"]
[34,"Butylbenzyl phthalate","85-68-7",1,100,0.17,"NA",2.69,1.26E-6,5.1513E-5,7155,"NA"]
[35,"Cadmium","7440-43-9",0.5,4,0.5,"NA","NA",0,0,"NA",23]
[36,"Caprolactam","105-60-2",60,4000,0.33,"NA",772000,2.5300000000000002E-8,1.0343E-6,24.5,"NA"]
[38,"Carbon disulfide","75-15-0",1,700,5.0000000000000001E-3,"NA",2160,1.44E-2,0.58871629999999997,21.73,"NA"]
[39,"Carbon tetrachloride","56-23-5",1,1,5.0000000000000001E-3,"NA",793,2.76E-2,1.1283729,43.89,"NA"]
[40,"Chlordane (alpha and gamma forms summed)","57-74-9",0.5,0.5,1.6999999999999999E-3,"NA",5.6000000000000001E-2,4.8600000000000002E-5,1.9869000000000002E-3,67540,"NA"]
[41,"4-Chloroaniline","106-47-8",10,30,0.17,"NA",3900,1.1599999999999999E-6,4.7423999999999999E-5,112.7,"NA"]
[42,"Chlorobenzene","108-90-7",1,50,5.0000000000000001E-3,"NA",498,3.1099999999999999E-3,0.12714639999999999,233.9,"NA"]
[44,"Chloroethane (Ethyl chloride)","75-00-3",0.5,"NA",5.0000000000000001E-3,"NA",6710,1.11E-2,0.45380209999999999,21.73,"NA"]
[45,"Chloroform","67-66-3",1,70,5.0000000000000001E-3,"NA",7950,3.6700000000000001E-3,0.1500409,31.82,"NA"]
[46,"Chloromethane (Methyl chloride)","74-87-3","NA","NA",5.0000000000000001E-3,"NA",5320,8.8199999999999997E-3,0.36058869999999998,13.22,"NA"]
[48,"2-Chloronaphthalene","91-58-7",10,600,0.17,"NA",11.7,3.2000000000000003E-4,1.3082E-2,2478,"NA"]
[49,"2-Chlorophenol (o-Chlorophenol)","95-57-8",20,40,0.17,"NA",11300,1.1199999999999999E-5,4.5789000000000002E-4,398,"NA"]
[52,"Chrysene","218-01-9",0.2,5,0.17,"NA",2E-3,5.2299999999999999E-6,2.1382000000000001E-4,180500,"NA"]
[53,"Cobalt (total)","7440-48-4",0.5,100,0.5,"NA","NA",0,0,"NA",45]
[54,"Copper (total)","7440-50-8",4,1300,1,"NA","NA",0,0,"NA",35]
[55,"Cyanide","57-12-5",6,100,0.5,"NA","NA",0,0,"NA",9.9]
[56,"Cyclohexane","110-82-7","NA","NA",5.0000000000000001E-3,"NA",55,0.15,6.1325000000000003,145.80000000000001,"NA"]
[57,"4,4'-DDD (p,p'-TDE)","72-54-8",0.02,0.1,3.3E-3,"NA",0.09,6.6000000000000003E-6,2.6982999999999998E-4,117500,"NA"]
[58,"4,4'-DDE (p,p'-DDX)","72-55-9",0.01,0.1,3.3E-3,"NA",0.04,4.1600000000000002E-5,1.7007000000000001E-3,117500,"NA"]
[59,"4,4'-DDT","50-29-3",0.1,0.1,3.3E-3,"NA",5.4999999999999997E-3,8.32E-6,3.4015E-4,168600,"NA"]
[60,"Dibenz(a,h)anthracene","53-70-3",0.3,0.3,0.17,"NA",2.49E-3,1.4100000000000001E-7,5.7644999999999996E-6,1912000,"NA"]
[61,"Dibromochloromethane (Chlorodibromomethane)","124-48-1",1,1,5.0000000000000001E-3,"NA",2700,7.8299999999999995E-4,3.2011400000000002E-2,31.82,"NA"]
[62,"1,2-Dibromo-3-chloropropane","96-12-8",0.02,0.02,5.0000000000000001E-3,"NA",1230,1.47E-4,6.0098E-3,115.8,"NA"]
[63,"1,2-Dibromoethane (Ethylene dibromide)","106-93-4",0.03,0.03,5.0000000000000001E-3,"NA",3910,6.4999999999999997E-4,2.6574E-2,39.6,"NA"]
[64,"1,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-1",5,600,5.0000000000000001E-3,"NA",156,1.92E-3,7.8495599999999999E-2,382.9,"NA"]
[65,"1,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-1",5,600,5.0000000000000001E-3,"NA",125,2.63E-3,0.10750999999999999,375.3,"NA"]
[66,"1,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7",5,75,5.0000000000000001E-3,"NA",81.3,2.4099999999999998E-3,9.8528199999999996E-2,375.3,"NA"]
[67,"3,3'-Dichlorobenzidine","91-94-1",30,30,0.33,"NA",3.1,2.84E-11,1.1611000000000001E-9,3190,"NA"]
[68,"Dichlorodifluoromethane (Freon 12)","75-71-8",2,1000,5.0000000000000001E-3,"NA",280,0.34300000000000003,14.022895,43.89,"NA"]
[69,"1,1-Dichloroethane","75-34-3",1,50,5.0000000000000001E-3,"NA",5040,5.62E-3,0.22976289999999999,31.82,"NA"]
[70,"1,2-Dichloroethane","107-06-2",2,2,5.0000000000000001E-3,"NA",8600,1.1800000000000001E-3,4.8242E-2,39.6,"NA"]
[71,"1,1-Dichloroethene (1,1-Dichloroethylene)","75-35-4",1,1,5.0000000000000001E-3,"NA",2420,2.6100000000000002E-2,1.0670481999999999,31.82,"NA"]
[72,"1,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2",1,70,5.0000000000000001E-3,"NA",6410,4.0800000000000003E-3,0.1668029,39.6,"NA"]
[73,"1,2-Dichloroethene (trans) (t-1,2-Dichloroethylene)","156-60-5",1,100,5.0000000000000001E-3,"NA",4520,9.3799999999999994E-3,0.38347999999999999,39.6,"NA"]
[75,"2,4-Dichlorophenol","120-83-2",10,20,0.17,"NA",5500,4.2899999999999996E-6,1.7537999999999999E-4,159,"NA"]
[76,"1,2-Dichloropropane","78-87-5",1,1,5.0000000000000001E-3,"NA",2800,2.82E-3,0.1152903,60.7,"NA"]
[77,"1,3-Dichloropropene (total)","542-75-6",1,1,5.0000000000000001E-3,"NA",2800,3.5500000000000002E-3,0.14513490000000001,72.17,"NA"]
[78,"Dieldrin","60-57-1",0.03,0.03,3.3E-3,"NA",0.19500000000000001,1.0000000000000001E-5,4.0883E-4,20090,"NA"]
[79,"Diethylphthalate","84-66-2",1,6000,0.17,"NA",1080,6.0999999999999998E-7,2.4939E-5,104.9,"NA"]
[80,"2,4-Dimethylphenol","105-67-9",20,100,0.17,"NA",7870,9.5099999999999998E-7,3.8878999999999998E-5,491.8,"NA"]
[82,"Di-n-butyl phthalate","84-74-2",1,700,0.17,"NA",11.2,1.81E-6,7.3998000000000005E-5,1157,"NA"]
[84,"2,4-Dinitrophenol","51-28-5",40,40,0.33,"NA",2790,8.6000000000000002E-8,3.5159000000000001E-6,1.78E-2,"NA"]
[87,"2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6",10,10,0.17,"NA",270,3.9700000000000002E-7,1.6229999999999999E-5,587.4,"NA"]
[88,"Di-n-octyl phthalate","117-84-0",10,100,0.33,"NA",2.1999999999999999E-2,2.57E-6,1.0506E-4,140800,"NA"]
[89,"1,4-Dioxane","123-91-1",0.1,0.4,6.7000000000000004E-2,"NA",1000000,4.7999999999999998E-6,1.9624E-4,2.633,"NA"]
[91,"Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7",0.1,40,3.3E-3,"NA",0.32500000000000001,6.4999999999999994E-5,2.6573999999999999E-3,6761,"NA"]
[93,"Endrin","72-20-8",0.03,2,3.3E-3,"NA",0.25,6.3600000000000001E-6,2.5999999999999998E-4,20090,"NA"]
[94,"Ethylbenzene","100-41-4",2,700,5.0000000000000001E-3,"NA",169,7.8799999999999999E-3,0.32215860000000002,446.1,"NA"]
[95,"Extractable Petroleum Hydrocarbons (No. 2 Fuel Oil and Diesel)","various ","NA","NA",80,"NA","NA",null,"NA","NA","NA"]
[95,"Extractable Petroleum Hydrocarbons (Other)","various","NA","NA",80,"NA","NA",null,"NA","NA","NA"]
[96,"Fluoranthene","206-44-0",10,300,0.33,"NA",0.26,8.8599999999999999E-6,3.6222000000000001E-4,55450,"NA"]
[97,"Fluorene","86-73-7",1,300,0.17,"NA",1.69,9.6199999999999994E-5,3.9328999999999996E-3,9160,"NA"]
[98,"alpha-HCH (alpha-BHC)","319-84-6",0.02,0.02,1.6999999999999999E-3,"NA",2,6.7000000000000002E-6,2.7391999999999998E-4,2807,"NA"]
[99,"beta-HCH (beta-BHC)","319-85-7",0.04,0.04,1.6999999999999999E-3,"NA",0.24,4.4000000000000002E-6,1.7988000000000001E-5,2807,"NA"]
[100,"Heptachlor","76-44-8",0.05,0.05,1.6999999999999999E-3,"NA",0.18,2.9399999999999999E-4,1.2019999999999999E-2,41260,"NA"]
[101,"Heptachlor epoxide","1024-57-3",0.2,0.2,1.6999999999999999E-3,"NA",0.2,2.0999999999999999E-5,8.5853999999999998E-4,10110,"NA"]
[102,"Hexachlorobenzene","118-74-1",0.02,0.02,0.17,"NA",6.1999999999999998E-3,1.6999999999999999E-3,6.9501199999999999E-2,6195,"NA"]
[103,"Hexachloro-1,3-butadiene","87-68-3",1,1,0.17,"NA",3.2,1.03E-2,0.42109570000000002,845.2,"NA"]
[104,"Hexachlorocyclopentadiene","77-47-4",0.5,40,0.33,"NA",1.8,2.7E-2,1.1038429999999999,1404,"NA"]
[105,"Hexachloroethane","67-72-1",7,7,0.17,"NA",50,3.8899999999999998E-3,0.15903519999999999,196.8,"NA"]
[106,"n-Hexane","110-54-3",5,30,"NA","NA",9.5,1.8,73.589534,131.5,"NA"]
[107,"2-Hexanone","591-78-6",1,40,0.01,"NA",17200,9.3200000000000002E-5,3.8103E-3,14.98,"NA"]
[108,"Indeno(1,2,3-cd)pyrene","193-39-5",0.2,0.2,0.17,"NA",1.9000000000000001E-4,3.4799999999999999E-7,1.4226999999999999E-5,1951000,"NA"]
[110,"Isophorone","78-59-1",10,40,0.17,"NA",12000,6.64E-6,2.7146000000000001E-4,65.150000000000006,"NA"]
[111,"Isopropylbenzene","98-82-8",1,700,5.0000000000000001E-3,"NA",61.3,1.15E-2,0.47016000000000002,697.8,"NA"]
[112,"Lead (total)","7439-92-1",5,5,0.5,"NA","NA",0,0,"NA",900]
[113,"Lindane (gamma-HCH)(gamma-BHC)","58-89-9",0.02,0.03,1.6999999999999999E-3,"NA",7.3,5.1399999999999999E-6,2.1013999999999999E-4,2807,"NA"]
[115,"Manganese (total)","7439-96-5",0.4,"NA",0.5,"NA","NA",0,0,"NA",65]
[116,"Mercury (total)","7439-97-6",0.05,2,0.1,"NA","NA",0,0,"NA",0.2]
[117,"Methoxychlor","72-43-5",0.1,40,1.7000000000000001E-2,"NA",0.1,2.03E-7,8.2993000000000003E-6,26890,"NA"]
[118,"Methyl acetate","79-20-9",0.5,7000,5.0000000000000001E-3,"NA",243000,1.15E-4,4.7016000000000002E-3,3.0640000000000001,"NA"]
[120,"Methylene chloride (Dichloromethane)","75-09-2",1,3,5.0000000000000001E-3,"NA",13000,3.2499999999999999E-3,0.13286999999999999,21.73,"NA"]
[121,"2-Methylnaphthalene","91-57-6",10,30,0.17,"NA",24.6,5.1800000000000001E-4,2.1177399999999999E-2,2478,"NA"]
[122,"4-Methyl-2-pentanone (MIBK)","108-10-1","NA","NA",0.01,"NA",19000,1.3799999999999999E-4,5.6419E-3,12.6,"NA"]
[123,"2-Methylphenol (o-cresol)","95-48-7",0.1,50,0.33,"NA",25900,1.1999999999999999E-6,4.9060000000000001E-5,306.5,"NA"]
[124,"4-Methylphenol (p-cresol)","106-44-5",0.1,50,0.33,"NA",21500,9.9999999999999995E-7,4.0883000000000001E-5,300.39999999999998,"NA"]
[125,"Methyl tert-butyl ether (MTBE)","1634-04-4",1,70,5.0000000000000001E-3,"NA",51000,5.8699999999999996E-4,2.39984E-2,11.56,"NA"]
[126,"Naphthalene","91-20-3",2,300,0.17,"NA",31,4.4000000000000002E-4,1.7988000000000001E-2,1544,"NA"]
[127,"Nickel (total)","7440-02-0",4,100,0.5,"NA","NA",0,0,"NA",24]
[129,"4-Nitroaniline","100-01-6","NA","NA",0.33,"NA",728,1.26E-9,5.1512999999999999E-8,109.1,"NA"]
[131,"Nitrobenzene","98-95-3",6,6,0.17,"NA",2090,2.4000000000000001E-5,9.8119000000000006E-4,226.4,"NA"]
[132,"N-Nitrosodi-n-propylamine","621-64-7",10,10,0.17,"NA",13000,5.3800000000000002E-6,2.1995000000000001E-4,275.39999999999998,"NA"]
[133,"N-Nitrosodiphenylamine","86-30-6",10,10,0.17,"NA",35,1.2100000000000001E-6,4.9468000000000001E-5,2632,"NA"]
[134,"2,2'-oxybis(1-chloropropane)","108-60-1",10,300,0.33,"NA",1700,7.4200000000000001E-5,3.0335000000000002E-3,82.92,"NA"]
[135,"Pentachlorophenol","87-86-5",0.1,0.3,0.33,"NA",14,2.4500000000000001E-8,1.0016000000000001E-6,5100,"NA"]
[137,"Phenol","108-95-2",10,2000,0.33,"NA",82800,3.3299999999999998E-7,1.3614E-5,187.2,"NA"]
[138,"Polychlorinated biphenyls (PCBs)","1336-36-3",0.5,0.5,0.03,"NA",0.7,4.15E-4,1.6965999999999998E-2,78100,"NA"]
[139,"Pyrene","129-00-0",0.1,200,0.17,"NA",0.13500000000000001,1.19E-5,4.8651E-4,54340,"NA"]
[140,"Selenium (total)","7782-49-2",4,40,2.5,"NA","NA",0,0,"NA",14]
[141,"Silver (total)","7440-22-4",1,40,0.5,"NA","NA",0,0,"NA",0.26]
[142,"Styrene","100-42-5",2,100,5.0000000000000001E-3,"NA",310,2.7499999999999998E-3,0.1124285,446.1,"NA"]
[143,"Tertiary butyl alcohol (TBA)","75-65-0",2,100,0.1,"NA",1000000,9.0499999999999997E-6,3.6996000000000002E-4,2.1110000000000002,"NA"]
[144,"1,2,4,5-Tetrachlorobenzene","95-94-3","NA","NA",0.17,"NA",0.59499999999999997,1E-3,4.0883000000000003E-2,2220,"NA"]
[145,"2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-01-6",1.0000000000000001E-5,1.0000000000000001E-5,9.9999999999999995E-7,"NA",2.0000000000000001E-4,5.0000000000000002E-5,2.0441999999999999E-3,249100,"NA"]
[147,"1,1,2,2-Tetrachloroethane","79-34-5",1,1,5.0000000000000001E-3,"NA",2830,3.6699999999999998E-4,1.5004099999999999E-2,94.94,"NA"]
[148,"Tetrachloroethene (PCE) (Tetrachloroethylene)","127-18-4",1,1,5.0000000000000001E-3,"NA",206,1.77E-2,0.72363040000000001,94.94,"NA"]
[149,"2,3,4,6-Tetrachlorophenol","58-90-2",3,200,0.17,"NA",23,8.8400000000000001E-6,3.614E-4,3140,"NA"]
[151,"Toluene","108-88-3",1,600,5.0000000000000001E-3,"NA",526,6.6400000000000001E-3,0.27146360000000003,233.9,"NA"]
[152,"Toxaphene","8001-35-2",2,2,0.17,"NA",0.55000000000000004,6.0000000000000002E-6,2.453E-4,77200,"NA"]
[153,"1,2,4-Trichlorobenzene","120-82-1",1,9,5.0000000000000001E-3,"NA",49,1.42E-3,5.8054000000000001E-2,1356,"NA"]
[154,"1,1,1-Trichloroethane","71-55-6",1,30,5.0000000000000001E-3,"NA",1290,1.72E-2,0.70318890000000001,43.89,"NA"]
[155,"1,1,2-Trichloroethane","79-00-5",2,3,5.0000000000000001E-3,"NA",4590,8.2399999999999997E-4,3.3687700000000001E-2,60.7,"NA"]
[156,"Trichloroethene (TCE) (Trichloroethylene)","79-01-6",1,1,5.0000000000000001E-3,"NA",1280,9.8499999999999994E-3,0.40269830000000001,60.7,"NA"]
[157,"Trichlorofluoromethane (Freon 11)","75-69-4",1,2000,5.0000000000000001E-3,"NA",1100,9.7000000000000003E-2,3.9657,43.89,"NA"]
[158,"2,4,5-Trichlorophenol","95-95-4",10,700,0.2,"NA",1200,1.6199999999999999E-6,6.6229999999999994E-5,2340,"NA"]
[159,"2,4,6-Trichlorophenol","88-06-2",20,20,0.2,"NA",800,2.6000000000000001E-6,1.063E-4,999,"NA"]
[160,"1,1,2-Trichloro-1,2,2-trifluoroethane (Freon TF)","76-13-1",0.3,20000,5.0000000000000001E-3,"NA",170,0.52600000000000002,21.504497000000001,196.8,"NA"]
[161,"1,2,4-Trimethylbenzene","95-63-6","NA","NA",7.5999999999999998E-2,"NA",57,6.1599999999999997E-3,0.2518397,614.29999999999995,"NA"]
[163,"Vanadium (total)","7440-62-2","NA","NA",2.5,"NA","NA",0,0,"NA",1000]
[164,"Vinyl chloride","75-01-4",1,1,5.0000000000000001E-3,"NA",8800,2.7799999999999998E-2,1.1365495000000001,21.73,"NA"]
[165,"Xylenes (total)","1330-20-7",2,1000,5.0000000000000001E-3,"NA",106,6.6299999999999996E-3,0.27105000000000001,382.9,"NA"]
[166,"Zinc (total)","7440-66-6",10,2000,1,"NA","NA",0,0,"NA",23]
[167,"Perfluorononanoic Acid (PFNA)","375-95-1",null,1.2999999999999999E-2,null,"NA","NA",0,0,"NA","NA"]
[168,"Perfluorooctanoic Acid (PFOA)","335-67-1",null,1.4E-2,null,"NA","NA",0,0,"NA","NA"]
[169,"Perfluorooctane Sulfonate (PFOS)","1763-23-1",null,1.2999999999999999E-2,null,"NA","NA",0,0,"NA","NA"]
[170,"HFPO-DA","13252-13-6 & 62037-80-3",null,0.02,null,"NA","NA",0,0,"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":"foc calc","index":1,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[30,0,30,3],[11,2,12,9],[13,2,13,3],[16,2,16,7],[29,0,29,3],[21,2,23,9],[3,12,3,15],[4,1,5,1],[4,2,5,9],[7,2,7,4],[8,2,8,4],[9,2,9,4],[0,0,0,9],[1,0,1,1],[1,2,1,6],[1,8,1,9],[2,0,2,1],[2,2,2,6],[2,8,2,9]]}
["NJDEP 2023 Organic Carbon Calculator"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,null,"Calculated or locked cell"]
["Additional Description:",null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optional data entry"]
[null,"Total organic carbon (mg/kg)","Enter up to 20 total organic carbon content values in the outlined cells.  Use units of mg/kg. Leave unused cells blank. Reset button will clear entries."]
[]
[]
[null,null,"Maximum organic carbon =",null,null,{"$f":"MAX(B7:B26)","v":0},"mg/kg"]
[null,null,"Minimum organic carbon =",null,null,{"$f":"MIN(B7:B26)","v":0},"mg/kg"]
[null,null,"Maxium/Minimum = ",null,null,{"$f":"F8/F9","v":{"$error":"#DIV/0!"}}]
[null,null,"Average organic carbon = ",null,null,{"$f":"AVERAGE(B7:B26)","v":{"$error":"#DIV/0!"}},"mg/kg"]
[null,null,{"$f":"IF(F10>10,\"Organic carbon contents vary by more than an order of magnitude.  Use minimum organic carbon content (maximum for MGW SESOIL/AT123D option).\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,"(Fraction) organic carbon content for MGW soil-water partition equation:",null,null,null,null,null,{"$f":"IF(F10>10, IF(F9<2000,0.002,F9/1000000),IF(F11<2000,0.002,F11/1000000))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I17=0.002,\"default\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,"Percent organic carbon for SESOIL model:",null,null,null,null,null,{"$f":"IF(F10>10, IF(F9<2000,0.002,F9/1000000),IF(F11<2000,0.002,F11/1000000))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I18=0.002,\"default\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,"Percent organic carbon for SESOIL/AT123D model:",null,null,null,null,null,{"$f":"IF(F10>10, F8/1000000,F11/1000000)","v":{"$error":"#DIV/0!"}}]
[null,null,"(Fraction) organic carbon for inhalation pathway:",null,null,null,null,null,{"$f":"IF(F10>10, IF(F9<2000,0.002,F9/1000000),IF(F11<2000,0.002,F11/1000000))","v":{"$error":"#DIV/0!"}},{"$f":"IF(I20=0.002,\"default\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"IF(I17=0.002,\"Minimum or average value less than or equal to 0.002. Default value of 0.002 (0.2%) may be used in soil-water partition equation, SESOIL model, or inhalation pathway. (Defaults are NOT used in the combination SESOIL/AT123D model)\",\"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"MGW-ExistChem","index":2,"n_rows":136,"n_cols":79,"rows_kept":136,"cut":false,"hidden":false,"merged":[[33,0,33,8],[41,0,41,3],[42,0,42,3],[23,1,23,2],[24,1,24,2],[25,1,25,4],[26,1,26,4],[31,3,31,4],[31,5,31,6],[8,11,8,12],[14,5,14,6],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[0,0,0,9],[1,0,1,1],[1,2,1,6],[1,8,1,9],[2,0,3,1],[2,2,3,6],[2,8,2,9],[3,8,3,9]]}
["NJDEP 2023 Soil-Water Partition Equation Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acenaphthene","83-32-9"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,null,"Calculated or locked cell",null,null,null,null,null,null,null,null,null,null,"Acetone (2-Propanone)","67-64-1"]
["Contaminant:",null,null,null,null,null,null,"CAS No.:",{"$f":"CA100","v":"83-32-9"},null,null,null,"Required data entry",null,null,null,null,null,null,null,null,null,null,"Acetophenone","98-86-2"]
[null,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,"Aldrin","309-00-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aluminum (total)","7429-90-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anthracene","120-12-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antimony (total)","7440-36-0"]
["Contaminant Parameters:",null,null,null,null,"Soil Parameters:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arsenic (total)","7440-38-2"]
["Parameter","Definition","Units","Value",null,"Parameter","Definition","Units","Value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atrazine","1912-24-9"]
["GWRS","Ground Water Remediation Standard","µg/L",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Ground Water Remediation Standard (µg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":400},null,"θw","Water-filled soil porosity","dimensionless (v/v)",0.23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barium (total)","7440-39-3"]
["Koc","Soil Organic Carbon-Water Partition Coefficient","L/kg",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Koc (L/kg)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":5027},null,"θa","Air-filled Soil Porosity","dimensionless (v/v)",0.18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzaldehyde","100-52-7"]
["Kd","Soil-Water Partition Coefficient","L/kg",{"$f":"IF(D11=\"NA\",VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Kd (L/kg)\",'Master database'!$C$1:$GP$1,0),FALSE),D11*I12)","v":10.054},null,"foc","(Fraction) Organic Carbon Content of Soil","dimensionless (w/w)",2E-3,{"$f":"IF(OR(I12>1,I12<0),\"out of range\",IF(I12<>0.002,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzene","71-43-2"]
["H'","Henry's Law Constant","dimensionless",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Henry's Law Constant (dimensionless, 25°C)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":7.5224000000000003E-3},null,"ρb","Dry Soil Bulk Density","kg/L",1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3"]
["S","Water Solubility","mg/L",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Water Solubility (mg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":3.9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(a)pyrene","50-32-8"]
["RLsoil","Soil Reporting Limit","mg/kg",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Soil Reporting Limit (mg/kg)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":0.17},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2"]
["Csat","Soil Saturation Limit","mg/kg",{"$f":"IF(D14=\"NA\",\"NA\",Round_to_Even((D14/1.5)*(D11*I12*1.5+0.23+D13*0.18)))","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(k)fluoranthene","207-08-9"]
["Camb","Ambient Background Concentration","mg/kg",{"$f":"VLOOKUP(I3,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Ambient background (mg/kg)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":"NA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beryllium","7440-41-7"]
["DAF Parameters:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1'-Biphenyl","92-52-4"]
[null,null,null,null,null,"Converted to metric:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bis(2-chloroethoxy)methane","111-91-1"]
["Parameter","Definition",null,"Value","units","Value","units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bis(2-chloroethyl)ether","111-44-4"]
["L","Length of Area of Concern Parallel to Ground Water Flow",null,100,"ft",{"$f":"D21*0.3048","v":30.48},"m",{"$f":"IF(D21<0,\"out of range\",IF(D21<>100,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bis(2-ethylhexyl)phthalate","117-81-7"]
["da","Aquifer Thickness",null,11.5,"ft",{"$f":"D22*0.3048","v":3.5052000000000003},"m",{"$f":"IF(D22<0,\"out of range\",IF(D22<>11.5,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromodichloromethane (Dichlorobromomethane)","75-27-4"]
["I","Infiltration Rate",null,11,"in/yr",{"$f":"D23*0.0254","v":0.27939999999999998},"m/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromoform","75-25-2"]
["K","Aquifer Hydraulic Conductivity",null,51865,"ft/yr",{"$f":"D24*0.3048","v":15808.452000000001},"m/yr",{"$f":"IF(D24<0,\"out of range\",IF(D24<>51865,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromomethane (Methyl bromide)","74-83-9"]
["i","Gradient",null,3.0000000000000001E-3,"dimensionless",{"$f":"D25","v":3.0000000000000001E-3},"dimensionless",{"$f":"IF(OR(D25<0,D25>1),\"out of range\",IF(D25<>0.003,\"changed\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Butanone (Methyl ethyl ketone) (MEK)","78-93-3"]
["d","Mixing Zone Depth",null,null,null,{"$f":"IF((0.0112*F21^2)^0.5+F22*(1-EXP((-F21*F23)/(F24*F25*F22)))>F22,F22,(0.0112*F21^2)^0.5+F22*(1-EXP((-F21*F23)/(F24*F25*F22))))","v":3.4007467135056353},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Butylbenzyl phthalate","85-68-7"]
["DAF","Dilution-Attenuation Factor",null,null,null,{"$f":"Round_to_Even(1+((F24*F25*F26)/(F23*F21)))","v":20},"dimensionless",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cadmium","7440-43-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caprolactam","105-60-2"]
["Site-specific Migration to Groundwater Soil Criterion:",null,null,null,null,null,{"$f":"IF($D$10=\"NA\",\"NA\",Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27))","v":82},"mg/kg",null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon tetrachloride","56-23-5"]
["Site-specific Migration to Ground Water Soil Remediation Standard (MGWSRS):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlordane (alpha and gamma forms summed)","57-74-9"]
[null,null,null,{"$f":"IF($D$10=\"NA\",\"NA\",IF(Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27)<$E$43,Round_to_Even($D$17),IF(AND($D$15<>\"NA\",Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27)<$D$15),$D$15,IF(Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27)>$E$42,\"NA\",Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27)))))","v":"NA"},null,"mg/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Chloroaniline","106-47-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorobenzene","108-90-7"]
[{"$f":"IF($D$10=\"NA\",\"\",IF(Round_to_Even($D$10/1000*(($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27))<$E$43,\"CONTROLLED BY AMBIENT BACKGROUND CONCENTRATION\",IF(AND($D$15<>\"NA\",Round_to_Even($D$10/1000*(($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27))<$D$15),\"CONTROLLED BY SOIL REPORTING LIMIT\",IF(Round_to_Even($D$10/1000*(($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$27))>$E$42,\"ABOVE SOIL SATURATION LIMIT\",\"\"))))","v":"ABOVE SOIL SATURATION LIMIT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroethane (Ethyl chloride)","75-00-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroform","67-66-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloromethane (Methyl chloride)","74-87-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Chloronaphthalene","91-58-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Chlorophenol (o-Chlorophenol)","95-57-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chrysene","218-01-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cobalt (total)","7440-48-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper (total)","7440-50-8"]
["CSAT VALUE FOR CALCULATION:",null,null,null,{"$f":"IF($D$16=\"NA\",1000000,$D$16)","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyanide","57-12-5"]
["AMBIENT VALUE FOR CALCULATION:",null,null,null,{"$f":"IF($D$17=\"NA\",0,$D$17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyclohexane","110-82-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDD (p,p'-TDE)","72-54-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDE (p,p'-DDX)","72-55-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDT","50-29-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibenz(a,h)anthracene","53-70-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibromochloromethane (Chlorodibromomethane)","124-48-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-Dibromo-3-chloropropane","96-12-8"]
[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-Dibromoethane (Ethylene dibromide)","106-93-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,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-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,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-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,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3,3'-Dichlorobenzidine","91-94-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dichlorodifluoromethane (Freon 12)","75-71-8"]
[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-Dichloroethane","75-34-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-Dichloroethane","107-06-2"]
[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-Dichloroethene (1,1-Dichloroethylene)","75-35-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,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2"]
[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-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,"2,4-Dichlorophenol","120-83-2"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dieldrin","60-57-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diethylphthalate","84-66-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dimethylphenol","105-67-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di-n-butyl phthalate","84-74-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dinitrophenol","51-28-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di-n-octyl phthalate","117-84-0"]
[null,null,null,null,null,null,null,null,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,"Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Endrin","72-20-8"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluoranthene","206-44-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluorene","86-73-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alpha-HCH (alpha-BHC)","319-84-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beta-HCH (beta-BHC)","319-85-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heptachlor","76-44-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heptachlor epoxide","1024-57-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachlorobenzene","118-74-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachloro-1,3-butadiene","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,"Hexachlorocyclopentadiene","77-47-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachloroethane","67-72-1"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Hexanone","591-78-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indeno(1,2,3-cd)pyrene","193-39-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isophorone","78-59-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isopropylbenzene","98-82-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lead (total)","7439-92-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lindane (gamma-HCH)(gamma-BHC)","58-89-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manganese (total)","7439-96-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury (total)","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,"Methoxychlor","72-43-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl acetate","79-20-9"]
[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,"2-Methylnaphthalene","91-57-6"]
[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,"2-Methylphenol (o-cresol)","95-48-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Methylphenol (p-cresol)","106-44-5",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,"CAS Number:",null,"83-32-9"]
[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,"Nickel (total)","7440-02-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Nitroaniline","100-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,"Nitrobenzene","98-95-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-Nitrosodi-n-propylamine","621-64-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-Nitrosodiphenylamine","86-30-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,2'-oxybis(1-chloropropane)","108-60-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pentachlorophenol","87-86-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phenol","108-95-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polychlorinated biphenyls (PCBs)","1336-36-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pyrene","129-00-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selenium (total)","7782-49-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver (total)","7440-22-4"]
[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,"Tertiary butyl alcohol (TBA)","75-65-0"]
[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,5-Tetrachlorobenzene","95-94-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-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,"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,"2,3,4,6-Tetrachlorophenol","58-90-2"]
[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,"Toxaphene","8001-35-2"]
[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 (Freon 11)","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,"2,4,5-Trichlorophenol","95-95-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4,6-Trichlorophenol","88-06-2"]
[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,"Vanadium (total)","7440-62-2"]
[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,"Zinc (total)","7440-66-6"]

{"sheet":"MGW-NewChem","index":3,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,0,29,8],[38,3,38,4],[41,0,41,3],[42,0,42,3],[22,1,22,2],[23,1,23,4],[24,1,24,4],[25,5,25,6],[26,0,26,8],[27,3,27,4],[27,5,27,6],[6,11,6,12],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[0,0,0,9],[1,0,1,1],[1,2,1,6],[1,8,1,9],[2,0,3,1],[2,2,3,6],[2,8,2,9],[3,8,3,9]]}
["NJDEP 2023 Soil-Water Partition Equation Calculator"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,null,"Calculated or locked cell"]
["Contaminant:",null,null,null,null,null,null,"CAS No.:",null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification"]
[]
[]
[]
["Contaminant Parameters:",null,null,null,null,"Soil Parameters:"]
["Parameter","Definition","Units","Value",null,"Parameter","Definition","Units","Value"]
["GWRS","Ground Water Remediation Standard","µg/L","Enter Value Here",null,"θw","Water-filled soil porosity","dimensionless (v/v)",0.23]
["Koc","Soil Organic Carbon-Water Partition Coefficient","L/kg",null,null,"θa","Air-filled Soil Porosity","dimensionless (v/v)",0.18]
["Kd","Soil-Water Partition Coefficient","L/kg",null,null,"foc","(Fraction) Organic Carbon Content of Soil","dimensionless (w/w)",2E-3,{"$f":"IF(OR(I12>1,I12<0),\"out of range\",IF(I12<>0.002,\"changed\",\"\"))","v":""}]
["H'","Henry's Law Constant","dimensionless","Enter Value Here or Zero",null,"ρb","Dry Soil Bulk Density","kg/L",1.5]
["S","Water Solubility","mg/L","Enter Value Here or NA"]
["Csat","Soil Saturation Limit","mg/kg",{"$f":"IF($D$14=\"NA\",\"NA\",IF(ISERROR($D$14/$I$13*($D$37*$I$13+$I$10+$D$13*$I$11)),\"\",Round_to_Even($D$14/$I$13*($D$37*$I$13+$I$10+$D$13*$I$11))))","v":""}]
["DAF Parameters:"]
[null,null,null,null,null,"Converted to metric:"]
["Parameter","Definition",null,"Value","units","Value","units"]
["L","Length of Area of Concern Parallel to Ground Water Flow",null,100,"ft",{"$f":"D19*0.3048","v":30.48},"m",{"$f":"IF(D19<0,\"out of range\",IF(D19<>100,\"changed\",\"\"))","v":""}]
["da","Aquifer Thickness",null,11.5,"ft",{"$f":"D20*0.3048","v":3.5052000000000003},"m",{"$f":"IF(D20<0,\"out of range\",IF(D20<>11.5,\"changed\",\"\"))","v":""}]
["I","Infiltration Rate",null,11,"in/yr",{"$f":"D21*0.0254","v":0.27939999999999998},"m/yr"]
["K","Aquifer Hydraulic Conductivity",null,51865,"ft/yr",{"$f":"D22*0.3048","v":15808.452000000001},"m/yr",{"$f":"IF(D22<0,\"out of range\",IF(D22<>51865,\"changed\",\"\"))","v":""}]
["i","Gradient",null,3.0000000000000001E-3,"dimensionless",{"$f":"D23","v":3.0000000000000001E-3},"dimensionless",{"$f":"IF(OR(D23<0,D23>1),\"out of range\",IF(D23<>0.003,\"changed\",\"\"))","v":""}]
["d","Mixing Zone Depth",null,null,null,{"$f":"IF((0.0112*F19^2)^0.5+F20*(1-EXP((-F19*F21)/(F22*F23*F20)))>F20,F20,(0.0112*F19^2)^0.5+F20*(1-EXP((-F19*F21)/(F22*F23*F20))))","v":3.4007467135056353},"m"]
["DAF","Dilution-Attenuation Factor",null,null,null,{"$f":"Round_to_Even(1+((F22*F23*F24)/(F21*F19)))","v":20},"dimensionless"]
[null,"Soil criterion  before Csat adjustment:",null,null,null,{"$f":"IF(OR(AND($D$11=\"\",$D$12=\"\"),AND($D$11<>0,$D$12<>0),$D$10=\"Enter Value Here\",$D$13=\"Enter Value Here or Zero\",$D$14=\"Enter Value Here or NA\"),\"\",IF($D$11=0,Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$25),Round_to_Even($D$10/1000*($D$11*$I$12+($I$10+$I$11*$D$13)/$I$13)*$F$25)))","v":""}]
["Site-specific Migration to Ground Water Soil Criterion:"]
[null,null,null,{"$f":"IF(OR(AND($D$11=\"\",$D$12=\"\"),AND($D$11<>0,$D$12<>0),$D$10=\"Enter Value Here\",$D$13=\"Enter Value Here or Zero\",$D$14=\"Enter Value Here or NA\"),\"\",IF($F$26>$D$38,\"NA\",IF($D$11=0,Round_to_Even($D$10/1000*($D$12+($I$10+$I$11*$D$13)/$I$13)*$F$25),Round_to_Even($D$10/1000*($D$11*$I$12+($I$10+$I$11*$D$13)/$I$13)*$F$25))))","v":""},null,"mg/kg"]
[]
[{"$f":"IF(OR($D$13=\"Enter Value Here or Zero\",$D$10=\"Enter Value Here\",$D$14=\"Enter Value Here or NA\",AND($D$11=\"\",$D$12=\"\")),\"ERROR: MISSING CONTAMINANT PARAMETERS\",IF(AND($D$11<>0,$D$12<>0),\"ERROR: ENTER ONLY Kd or Koc - DELETE ONE OR RESET SHEET\",IF($F$26>$D$38,\"SOIL CRITERION HIGHER THAN SOIL SATURATION LIMIT\",\"\")))","v":"ERROR: MISSING CONTAMINANT PARAMETERS"}]
[null,{"$f":"IF(A30=\"HEALTH-BASED CRITERION HIGHER THAN Csat CONCENTRATION\",\"CRITERION SHOULD BE LOWERED TO\",\"\")","v":""},null,null,null,null,{"$f":"IF(A30=\"HEALTH-BASED CRITERION HIGHER THAN Csat CONCENTRATION\",Round_to_Even($D$15),\"\")","v":""},{"$f":"IF(A30=\"HEALTH-BASED CRITERION HIGHER THAN Csat CONCENTRATION\",\"mg/kg\",\"\")","v":""}]
[]
[]
[]
[]
[]
["Calculated Kd",null,null,{"$f":"IF($D$11=0,$D$12,$D$11*$I$12)","v":0}]
["Csat value for comparison",null,null,{"$f":"IF($D$15=\"NA\",1000000,$D$15)","v":""}]

{"sheet":"MGW-DAF","index":4,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,5],[25,0,25,3],[26,0,26,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,5],[0,0,0,9],[1,0,1,1],[1,2,1,6],[1,8,1,9],[2,0,2,1],[2,2,2,6],[2,8,2,9]]}
["NJDEP 2023 Migration to Ground Water Dilution-Attenuation Factor Calculator"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,null,"Calculated or locked cell"]
["Additional Description:",null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optional data entry/modification"]
[]
[]
[]
[null,null,null,null,null,null,"Converted to metric:"]
[null,"Parameter","Definition",null,"Value","units","Value","units"]
[null,"L","Length of Area of Concern Parallel to Ground Water Flow",null,100,"ft",{"$f":"E10*0.3048","v":30.48},"m",{"$f":"IF(E10<0,\"out of range\",IF(E10<>100,\"changed\",\"\"))","v":""}]
[null,"da","Aquifer Thickness",null,11.5,"ft",{"$f":"E11*0.3048","v":3.5052000000000003},"m",{"$f":"IF(E11<0,\"out of range\",IF(E11<>11.5,\"changed\",\"\"))","v":""}]
[null,"I","Infiltration Rate",null,11,"in/yr",{"$f":"E12*0.0254","v":0.27939999999999998},"m/yr"]
[null,"K","Aquifer Hydraulic Conductivity",null,51865,"ft/yr",{"$f":"E13*0.3048","v":15808.452000000001},"m/yr",{"$f":"IF(E13<0,\"out of range\",IF(E13<>51865,\"changed\",\"\"))","v":""}]
[null,"i","Gradient",null,3.0000000000000001E-3,"dimensionless",{"$f":"E14","v":3.0000000000000001E-3},"dimensionless",{"$f":"IF(OR(E14<0,E14>1),\"out of range\",IF(E14<>0.003,\"changed\",\"\"))","v":""}]
[null,"d","Mixing Zone Depth",null,null,null,{"$f":"IF((0.0112*G10^2)^0.5+G11*(1-EXP((-G10*G12)/(G13*G14*G11)))>G11,G11,(0.0112*G10^2)^0.5+G11*(1-EXP((-G10*G12)/(G13*G14*G11))))","v":3.4007467135056353},"m"]
[null,"DAF","Dilution-Attenuation Factor",null,null,null,{"$f":"Round_to_Even(1+((G13*G14*G15)/(G12*G10)))","v":20},"dimensionless"]

{"sheet":"MGW-SPLP-ExistChem","index":5,"n_rows":136,"n_cols":79,"rows_kept":136,"cut":false,"hidden":false,"merged":[[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,15,9],[15,10,16,10],[15,0,16,0],[15,1,16,1],[0,0,0,4],[1,1,1,3],[2,1,2,3],[3,1,3,3],[6,0,6,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]]}
["NJDEP 2023 SPLP Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acenaphthene","83-32-9"]
["Case name/area of concern:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acetone (2-Propanone)","67-64-1"]
["Case number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acetophenone","98-86-2"]
["Sampling date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aldrin","309-00-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aluminum (total)","7429-90-5"]
["Contaminant:",null,null,null,"NOTE:",null,null,null,null,null,null,null,null,null,null,null,null,"check columns - to verify that data has not changed",null,null,null,null,null,"Anthracene","120-12-7"]
["CAS No:",null,{"$f":"CA100","v":"83-32-9"},null,"USE ONE PAGE PER CONTAMINANT, do not leave empty rows between samples",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antimony (total)","7440-36-0"]
["Water solubility (mg/L)",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Water Solubility (mg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":3.9},null,"Do not enter samples with soil concentrations at or below the soil reporting limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arsenic (total)","7440-38-2"]
["Aqueous reporting limit (µg/L):",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Ground water practical quantitation level (µg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":10},null,"SPLP leachate concentrations may be entered down to the detection limit, but see guidance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Atrazine","1912-24-9"]
["Soil reporting limit (mg/kg):",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Soil Reporting Limit (mg/kg)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":0.17},null,"Enter site-specific dilution-attenuation factor (DAF) if desired",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barium (total)","7440-39-3"]
["Ground Water Remediation Std (µg/L)",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Ground Water Remediation Standard (µg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":400},null,null,"Data entry cells (do not skip rows)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzaldehyde","100-52-7"]
["DAF (20, or site-specific if approved):",null,20,{"$f":"IF(C12<>20,\"changed\",\"\")","v":""},null,"Optional data entry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzene","71-43-2"]
["Leachate Standard (µg/L):",null,{"$f":"IF(C11=\"NA\",\"NA\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8), \"NA\",Round_to_Even(C11*C12)))","v":"NA"},{"$f":"IF(C11=\"NA\",\"no GWRS\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8),\"above Csat\",\"\"))","v":"above Csat"},null,"Calculated or locked cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(a)anthracene (1,2-Benzanthracene)","56-55-3"]
["Henry's law constant (dimensionless):",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Henry's Law Constant (dimensionless, 25°C)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":7.5224000000000003E-3},null,null,"Indicates that Alternative Remediation Standard needs to be recalculated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(a)pyrene","50-32-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzo(b)fluoranthene (3,4-Benzofluoranthene)","205-99-2"]
["Sample ID","Soil sample weight (kg)","Leachate Volume (L)","Total Soil Concentration (mg/kg)","SPLP Leachate Concentration (µg/L)","Final pH of Leachate (except VOCs)","Optional data",null,null,null,"Kd (L/kg)","% Contaminant in Leachate","Need to adjust leachate concentration?","Field leachate concentration (µg/L)","Pass or fail?",null,null,null,null,null,null,null,null,"Benzo(k)fluoranthene","207-08-9"]
[null,null,null,null,null,null,"Sampling Depth (ft)","Soil Type","Organic Carbon (mg/kg)","Organic Carbon (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beryllium","7440-41-7"]
[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'-Biphenyl","92-52-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bis(2-chloroethoxy)methane","111-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,"Bis(2-chloroethyl)ether","111-44-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bis(2-ethylhexyl)phthalate","117-81-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bromodichloromethane (Dichlorobromomethane)","75-27-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Butylbenzyl phthalate","85-68-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cadmium","7440-43-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caprolactam","105-60-2"]
[null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carbon tetrachloride","56-23-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlordane (alpha and gamma forms summed)","57-74-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Chloroaniline","106-47-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chlorobenzene","108-90-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroethane (Ethyl chloride)","75-00-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloroform","67-66-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chloromethane (Methyl chloride)","74-87-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Chloronaphthalene","91-58-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Chlorophenol (o-Chlorophenol)","95-57-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chrysene","218-01-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cobalt (total)","7440-48-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper (total)","7440-50-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyanide","57-12-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cyclohexane","110-82-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDD (p,p'-TDE)","72-54-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDE (p,p'-DDX)","72-55-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4'-DDT","50-29-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibenz(a,h)anthracene","53-70-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dibromochloromethane (Chlorodibromomethane)","124-48-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-Dibromo-3-chloropropane","96-12-8"]
[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-Dibromoethane (Ethylene dibromide)","106-93-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,2-Dichlorobenzene (o-Dichlorobenzene)","95-50-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,3-Dichlorobenzene (m-Dichlorobenzene)","541-73-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,4-Dichlorobenzene (p-Dichlorobenzene)","106-46-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3,3'-Dichlorobenzidine","91-94-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dichlorodifluoromethane (Freon 12)","75-71-8"]
[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-Dichloroethane","75-34-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-Dichloroethane","107-06-2"]
[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-Dichloroethene (1,1-Dichloroethylene)","75-35-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,2-Dichloroethene (cis) (c-1,2-Dichloroethylene)","156-59-2"]
[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-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,"2,4-Dichlorophenol","120-83-2"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dieldrin","60-57-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diethylphthalate","84-66-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dimethylphenol","105-67-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di-n-butyl phthalate","84-74-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dinitrophenol","51-28-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4-Dinitrotoluene/2,6-Dinitrotoluene (mixture)","25321-14-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Di-n-octyl phthalate","117-84-0"]
[null,null,null,null,null,null,null,null,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,"Endosulfan I and Endosulfan II (alpha and beta) (summed)","115-29-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Endrin","72-20-8"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluoranthene","206-44-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluorene","86-73-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"alpha-HCH (alpha-BHC)","319-84-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beta-HCH (beta-BHC)","319-85-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heptachlor","76-44-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heptachlor epoxide","1024-57-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachlorobenzene","118-74-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachloro-1,3-butadiene","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,"Hexachlorocyclopentadiene","77-47-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hexachloroethane","67-72-1"]
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Hexanone","591-78-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indeno(1,2,3-cd)pyrene","193-39-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isophorone","78-59-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isopropylbenzene","98-82-8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lead (total)","7439-92-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lindane (gamma-HCH)(gamma-BHC)","58-89-9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manganese (total)","7439-96-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mercury (total)","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,"Methoxychlor","72-43-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Methyl acetate","79-20-9"]
[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,"2-Methylnaphthalene","91-57-6"]
[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,"2-Methylphenol (o-cresol)","95-48-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Methylphenol (p-cresol)","106-44-5",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,"CAS Number:",null,"83-32-9"]
[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,"Nickel (total)","7440-02-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Nitroaniline","100-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,"Nitrobenzene","98-95-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-Nitrosodi-n-propylamine","621-64-7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-Nitrosodiphenylamine","86-30-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,2'-oxybis(1-chloropropane)","108-60-1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pentachlorophenol","87-86-5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phenol","108-95-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polychlorinated biphenyls (PCBs)","1336-36-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pyrene","129-00-0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selenium (total)","7782-49-2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Silver (total)","7440-22-4"]
[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,"Tertiary butyl alcohol (TBA)","75-65-0"]
[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,5-Tetrachlorobenzene","95-94-3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin","1746-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,"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,"2,3,4,6-Tetrachlorophenol","58-90-2"]
[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,"Toxaphene","8001-35-2"]
[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 (Freon 11)","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,"2,4,5-Trichlorophenol","95-95-4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,4,6-Trichlorophenol","88-06-2"]
[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,"Vanadium (total)","7440-62-2"]
[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,"Zinc (total)","7440-66-6"]

{"sheet":"MGW-SPLP-NewChem","index":6,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,14,16,14],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,15,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[13,0,13,1],[0,0,0,4],[1,1,1,3],[2,1,2,3],[3,1,3,3],[5,1,5,3],[6,0,6,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1]]}
["NJDEP 2023 SPLP Spreadsheet"]
["Case name/area of concern:"]
["Case number:"]
["Sampling date:"]
[]
["Contaminant:",null,null,null,"NOTE:",null,null,null,null,null,null,null,null,null,null,null,null,"check columns - to verify that data has not changed"]
["CAS No:",null,null,null,"USE ONE PAGE PER CONTAMINANT, do not leave empty rows between samples"]
["Water solubility (mg/L)",null,null,null,"Do not enter samples with soil concentrations at or below the soil reporting limit."]
["Aqueous reporting limit (µg/L):",null,null,null,"SPLP leachate concentrations may be entered down to the detection limit, but see guidance"]
["Soil reporting limit (mg/kg):",null,null,null,"Enter site-specific dilution-attenuation factor (DAF) if desired"]
["Ground Water Criterion (µg/L)",null,null,null,null,"Data entry cells (do not skip rows)"]
["DAF (20, or site-specific if approved):",null,20,{"$f":"IF(C12<>20,\"changed\",\"\")","v":""},null,"Optional data entry"]
["Leachate Criterion (µg/L):",null,{"$f":"IF(C11=\"NA\",\"NA\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8),\"NA\",Round_to_Even(C11*C12)))","v":0},{"$f":"IF(C11=\"NA\",\"no GWRS\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8),\"above Csat\",\"\"))","v":""},null,"Calculated or locked cells"]
["Henry's law constant (dimensionless):",null,null,null,null,"Indicates that Alternative Remediation Standard needs to be recalculated"]
[]
["Sample ID","Soil sample weight (kg)","Leachate Volume (L)","Total Soil Concentration (mg/kg)","SPLP Leachate Concentration (µg/L)","Final pH of Leachate (except VOCs)","Optional data",null,null,null,"Kd (L/kg)","% Contaminant in Leachate","Need to adjust leachate concentration?","Field leachate concentration (µg/L)","Pass or fail?"]
[null,null,null,null,null,null,"Sampling Depth (ft)","Soil Type","Organic Carbon (mg/kg)","Organic Carbon (%)"]

{"sheet":"MGW-SPLP-PFAS","index":7,"n_rows":100,"n_cols":79,"rows_kept":100,"cut":false,"hidden":false,"merged":[[15,0,16,0],[15,1,16,1],[0,0,0,4],[1,1,1,3],[2,1,2,3],[3,1,3,3],[6,0,6,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,15,9],[15,10,16,10]]}
["NJDEP 2023 PFAS SPLP Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HFPO-DA (GenX)","13252-13-6 & 62037-80-3"]
["Case name/area of concern:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perfluorononanoic Acid (PFNA)","375-95-1"]
["Case number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perfluorooctanoic Acid (PFOA)","335-67-1"]
["Sampling date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perfluorooctane Sulfonate (PFOS)","1763-23-1"]
[]
["Contaminant:",null,null,null,"NOTE:",null,null,null,null,null,null,null,null,null,null,null,null,"check columns - to verify that data has not changed"]
["CAS No:",null,{"$f":"CA100","v":"13252-13-6 & 62037-80-3"},null,"USE ONE PAGE PER CONTAMINANT, do not leave empty rows between samples"]
["Water solubility (mg/L)",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Water Solubility (mg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":"NA"},null,"Do not enter samples with soil concentrations at or below the soil reporting limit"]
["Laboratory-specific aqueous reporting limit (µg/L):",null,null,null,"SPLP leachate concentrations may be entered down to the detection limit, but see guidance"]
["Laboratory-specific soil reporting limit (mg/kg):",null,null,null,"Enter site-specific dilution-attenuation factor (DAF) if desired"]
["Ground Water Remediation Std (µg/L)",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Ground Water Remediation Standard (µg/L)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":0.02},null,null,"Data entry cells (do not skip rows)"]
["DAF (20, or site-specific if approved):",null,20,{"$f":"IF(C12<>20,\"changed\",\"\")","v":""},null,"Optional data entry"]
["Leachate Standard (µg/L):",null,{"$f":"IF(C11=\"NA\",\"NA\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8), \"NA\",Round_to_Even(C11*C12)))","v":0.4},{"$f":"IF(C11=\"NA\",\"no GWRS\",IF(AND(C8<>\"NA\",(C11*C12)/1000>C8),\"above Csat\",\"\"))","v":""},null,"Calculated or locked cells"]
["Henry's law constant (dimensionless):",null,{"$f":"VLOOKUP(C7,'Master database'!$C$2:$GP$455,MATCH(\"2018 Standards Henry's Law Constant (dimensionless, 25°C)\",'Master database'!$C$1:$GP$1,0),FALSE)","v":0},null,null,"Indicates that Alternative Remediation Standard needs to be recalculated"]
[]
["Sample ID","Soil sample weight (kg)","Leachate Volume (L)","Total Soil Concentration (mg/kg)","SPLP Leachate Concentration (µg/L)","Final pH of Leachate ","Optional data",null,null,null,"Kd (L/kg)","% Contaminant in Leachate","Need to adjust leachate concentration?","Field leachate concentration (µg/L)","Pass or fail?"]
[null,null,null,null,null,null,"Sampling Depth (ft)","Soil Type","Organic Carbon (mg/kg)","Organic Carbon (%)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"CAS Number:",null,"13252-13-6 & 62037-80-3"]

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