Event_13269_Line1_BidSpreadsheet.xlsx

XLSX spreadsheet 231 KB Posted Apr 12, 2024

Attached to: Oak Ridge Lab Services
Solicitation number: Event 32701-13269
Issued by: Anderson County, Tennessee

About this file

Written by GovTribe AI · Jul 11, 2024

This document is an Invitation to Bid (ITB) issued by the Tennessee Department of Environment and Conservation (TDEC), Division of Remediation, Oak Ridge Office (DoR-OR) for various analytical testing services. The ITB requests pricing for a wide range of analytical tests including metals, semivolatiles, volatiles, general chemistry parameters, and mercury analysis across multiple media types such as air, biota, fish, milk, sediment, sludge, solids, vegetables, waste, and water. The ITB provides estimated annual sampling quantities for each test and matrix, as well as the required analytical methods and target reporting limits. Responses to the ITB are due by a specified deadline, with the contract term and potential renewal options not explicitly stated.

The ITB provides detailed pricing tables for each analytical test, requesting that responding laboratories provide unit costs for both a Level 2 and a Level 4 quality control data package. Laboratories are also asked to provide their method detection limits. While the document does not mention any set-asides or incumbent contractors, it does reference State of Tennessee Ambient Water Quality Criteria and EPA Lifetime Health Advisory Limits that the analytical testing must meet. The funding source and total contract value are not disclosed.

View the file

Other files

File	Type	Posted
TDEC_DoR-OR_ITB_General_Analytical_Testing_Excel.xlsx	XLSX spreadsheet	Apr 12, 2024
Event_13269_AMD1.pdf	PDF	Apr 12, 2024
Event_13269_Line_2_Specs.pdf	PDF	Apr 12, 2024
OakRidge_LabServices.pdf	PDF	Apr 12, 2024
DoR-OR_ITB-2023-General_Biology.xlsx	XLSX spreadsheet	Apr 12, 2024
Specs_and_Instructions_for_Toxicity_Analytical_Testing.pdf	PDF	Apr 12, 2024
Event_13269_Line2_BidSpreadsheet.xlsx	XLSX spreadsheet	Apr 12, 2024
Event_13269_Terms_Conditions.pdf	PDF	Apr 12, 2024
Event_13269_PreBidMemo.pdf	PDF	Apr 12, 2024
Event_13269_Line_1_Specs.pdf	PDF	Apr 12, 2024
Specs_and_Bid_Instructions_for_General_Analytical_Testing.pdf	PDF	Apr 12, 2024

Show all 11

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions Sheet

TDEC DoR-OR Invitation To Bid (ITB) - Attachment 1
Instructions Sheet
	Instructions for ITB Bid Sheet

ITB Bidsheet

TDEC DoR-OR Invitation To Bid (ITB) Analytical Tests
	Division of Remediation, Oak Ridge Office (DoR-OR)
	761 Emory Valley Rd.
Analytical Tests	Chemical Abstracts Services Registry Number (CAS #) or	Sample Matrix	TDEC DoR-OR Needed Analytical Method(s)	TDEC DoR-OR Needed WATER Reporting Limit (RL)	Laboratory Minimum Detection Limit (MDL)	Cost Per Test with Level 2 QC Data Package (** KEY)	Cost Per Test with Level 4 QC Data Package (*** KEY)	Estimated Sampling Quantities	Total Cost
	See (4th Tab) General Information Table 1		or Enter Laboratory Equivalent	for TN AWQC (µg/L) or EPA LHAL (ng/L) - (* KEY)	Responding Lab please provide MDL	Enter Costs Below	Enter Costs Below	See (3rd tab) Estimated Sampling Quantities	(**** KEY)
General Inorganics (all Water except Particle Size Distribution)
Alkalinity (total)	NA	Water	EPA 310.2			$ - 0	$ - 0	150	$ - 0
Ammonia	7664-41-7	Water	EPA-350.1			$ - 0	$ - 0	150	$ - 0
Bromide	24959-67-9	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Chloride	16887-00-6	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
COD	NA	Water	EPA-5220-C			$ - 0	$ - 0	150	$ - 0
Cyanide	57-12-5	Water	SW846-9016	≤ 140		$ - 0	$ - 0	150	$ - 0
Fluoride	16984-48-8	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Hexavalent chromium	18540-29-9	Water	SW846-7199			$ - 0	$ - 0	150	$ - 0
Inorganic Anions by IC	NA	Water	EPA 300.0			$ - 0	$ - 0	150	$ - 0
Nitrate	14797-55-8	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Nitrate and nitrite (as nitrogen)	NA	Water	EPA-353.2			$ - 0	$ - 0	150	$ - 0
Nitrite	14797-65-0	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Orthophosphate	9066-91-5	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Particle size distribution (sediment)	NA	Sediment	ASTM-D7928			$ - 0	$ - 0	15	$ - 0
Phosphorus (total)	7723-14-0	Water	EPA-365.1			$ - 0	$ - 0	150	$ - 0
Sulfate	14808-79-8	Water	EPA-300.0			$ - 0	$ - 0	150	$ - 0
Sulfide	18496-25-8	Water	SM-4500-S2-F			$ - 0	$ - 0	150	$ - 0
Total dissolved solids (TDS)	NA	Water	SM-2540-C			$ - 0	$ - 0	150	$ - 0
Total suspended solids (TSS)	NA	Water	SM-2540-D			$ - 0	$ - 0	150	$ - 0
Total solids	NA	Water	SM-2540-B			$ - 0	$ - 0	150	$ - 0
Total kjeldahl nitrogen	Nitrogen 7727-37-9	Water	EPA-351.2			$ - 0	$ - 0	150	$ - 0
Total organic carbon	Carbon 7440-44-0	Water	SW846-9060			$ - 0	$ - 0	150	$ - 0
Mercury in air filters	7439-97-6	Air filters	SW846-7471			$ - 0	$ - 0	80	$ - 0
Mercury in biota	7439-97-6	Biota	SW846-7471			$ - 0	$ - 0	25	$ - 0
Mercury in fish	7439-97-6	Fish	SW846-7471			$ - 0	$ - 0	10	$ - 0
Mercury in milk	7439-97-6	Milk	SW846-7471			$ - 0	$ - 0	10	$ - 0
Mercury in sediment	7439-97-6	Sediment	SW846-7471			$ - 0	$ - 0	15	$ - 0
Mercury in sludge	7439-97-6	Sludge	SW846-7471			$ - 0	$ - 0	5	$ - 0
Mercury in solids	7439-97-6	Solids	SW846-7471			$ - 0	$ - 0	25	$ - 0
Mercury in vegetable	7439-97-6	Vegetable	SW846-7471			$ - 0	$ - 0	10	$ - 0
Mercury in waste	7439-97-6	Waste	SW846-7471			$ - 0	$ - 0	5	$ - 0
Mercury in water	7439-97-6	Water	SW846-7470			$ - 0	$ - 0	150	$ - 0
Metals analysis by ICP-MS in air filters	Metals ICP-MS	Air filters	EPA-200.8			$ - 0	$ - 0	80	$ - 0
Metals analysis by ICP-MS in biota	Metals ICP-MS	Biota	EPA-200.8			$ - 0	$ - 0	25	$ - 0
Metals analysis by ICP-MS in fish	Metals ICP-MS	Fish	EPA-200.8			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-MS in milk	Metals ICP-MS	Milk	EPA-200.8			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-MS in sediment	Metals ICP-MS	Sediment	EPA-200.8			$ - 0	$ - 0	15	$ - 0
Metals analysis by ICP-MS in sludge	Metals ICP-MS	Sludge	EPA-200.8			$ - 0	$ - 0	5	$ - 0
Metals analysis by ICP-MS in solids	Metals ICP-MS	Solids	EPA-200.8			$ - 0	$ - 0	25	$ - 0
Metals analysis by ICP-MS in vegetable	Metals ICP-MS	Vegetable	EPA-200.8			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-MS in waste	Metals ICP-MS	Waste	EPA-200.8			$ - 0	$ - 0	5	$ - 0
Metals analysis by ICP-MS in water	Metals ICP-MS	Water	EPA-200.8	See General Information Table 1 for NEEDED RL	See General Information Table 1 for MDL	$ - 0	$ - 0	150	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in air filters	Metals ICP-OES	Air filters	EPA-200.7			$ - 0	$ - 0	80	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in biota	Metals ICP-OES	Biota	EPA-200.7			$ - 0	$ - 0	25	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in fish	Metals ICP-OES	Fish	EPA-200.7			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in milk	Metals ICP-OES	Milk	EPA-200.7			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in sediment	Metals ICP-OES	Sediment	EPA-200.7			$ - 0	$ - 0	15	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in sludge	Metals ICP-OES	Sludge	EPA-200.7			$ - 0	$ - 0	5	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in solids	Metals ICP-OES	Solids	EPA-200.7			$ - 0	$ - 0	25	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in vegetable	Metals ICP-OES	Vegetable	EPA-200.7			$ - 0	$ - 0	10	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in waste	Metals ICP-OES	Waste	EPA-200.7			$ - 0	$ - 0	5	$ - 0
Metals analysis by ICP-OES (includes Fe ,K ,Mg ,Ca ,Na) in water	Metals ICP-OES	Water	EPA-200.7	See General Information Table 1 for NEEDED RL	See General Information Table 1 for MDL	$ - 0	$ - 0	150	$ - 0
Total hardness	NA	Water	ASTM-D1126, Calculated			$ - 0	$ - 0	150	$ - 0
Semivolatile in air filters	SV	Air filters	SW846-8270			$ - 0	$ - 0	80	$ - 0
Semivolatile in biota	SV	Biota	SW846-8270			$ - 0	$ - 0	25	$ - 0
Semivolatile in fish	SV	Fish	SW846-8270			$ - 0	$ - 0	10	$ - 0
Semivolatile in milk	SV	Milk	SW846-8270			$ - 0	$ - 0	10	$ - 0
Semivolatile in sediment	SV	Sediment	SW846-8270			$ - 0	$ - 0	15	$ - 0
Semivolatile in sludge	SV	Sludge	SW846-8270			$ - 0	$ - 0	5	$ - 0
Semivolatile in solids	SV	Solids	SW846-8270			$ - 0	$ - 0	25	$ - 0
Semivolatile in vegetable	SV	Vegetable	SW846-8270			$ - 0	$ - 0	10	$ - 0
Semivolatile in waste	SV	Waste	SW846-8270			$ - 0	$ - 0	5	$ - 0
Semivolatile in water	SV	Water	SW846-8270	See General Information Table 1 for NEEDED RL	See General Information Table 1 for MDL	$ - 0	$ - 0	150	$ - 0
Volatile in air filters	VOA	Air filters	SW846-8260			$ - 0	$ - 0	80	$ - 0
Volatile in biota	VOA	Biota	SW846-8260			$ - 0	$ - 0	25	$ - 0
Volatile in fish	VOA	Fish	SW846-8260			$ - 0	$ - 0	10	$ - 0
Volatile in milk	VOA	Milk	SW846-8260			$ - 0	$ - 0	10	$ - 0
Volatile in sediment	VOA	Sediment	SW846-8260			$ - 0	$ - 0	15	$ - 0
Volatile in sludge	VOA	Sludge	SW846-8260			$ - 0	$ - 0	5	$ - 0
Volatile in solids	VOA	Solids	SW846-8260			$ - 0	$ - 0	25	$ - 0
Volatile in vegetable	VOA	Vegetable	SW846-8260			$ - 0	$ - 0	10	$ - 0
Volatile in waste	VOA	Waste	SW846-8260			$ - 0	$ - 0	5	$ - 0
Volatile in water	VOA	Water	SW846-8260	See General Information Table 1 for NEEDED RL	See General Information Table 1 for MDL	$ - 0	$ - 0	150	$ - 0
Total Final Cost									$ - 0
Key:
* TN AWQC = State of Tennesse Ambient Water Quality Criteria, EPA LHAL = EPA Lifetime Health Advisory Limits
** Level 2 QC Package: Sample Results, Laboratory Method Blank, Laboratory Control Sample (LCS/LCSD), Laboratory Matrix Spike (MS/MSD), and Level 2 EDD
*** Level 4 QC Package: Sample Results, ALL Level 4, and Level 4 EDD
**** Assume Level 2 QC Package for Bid costs. Please provide Level 4 QC Package cost, if appropriate, if needed in future but it is not the norm

Estimated Sampling Quantities

TDEC DoR-OR Invitation To Bid (ITB)
ITB Bid Sheet
		Division of Remediation, Oak Ridge Office (DoR-OR)
	761 Emory Valley Rd.	865-481-0995
Group	Analysis Type	Basic Method	Media that may be sampled (estimated quantity of samples annually)
			air filters	biota	fish tissue	milk	sediment	sludge	solids	vegetables	waste	water
1	Metals ICP-MS	EPA-200.8	80	25	10	10	15	5	25	10	5	150
	Metals ICP-OES	EPA-200.7	80	25	10	10	15	5	25	10	5	150
	Semi VOAs	SW846-8270	80	25	10	10	15	5	25	10	5	150
	VOA	SW846-8260	80	25	10	10	15	5	25	10	5	150
	Inorganic Anions by IC	EPA 300.0										150
	Alkalinity (total)	SM-2320-B, EPA 310.2										150
	Ammonia	EPA-350.1										150
	COD	EPA-5220-C										150
	Cyanide	SW846-9016, SM-4500-CN-E										150
	Hexavalent chromium	SW846-7199, ASTM-D5257										50
	Nitrate and nitrite (as nitrogen)	EPA-353.2										150
	Particle size distribution (sediment)	ASTM-D7928					15
	Phosphorus (total)	EPA-365.1										150
	Sulfide	SM-4500-S2-F										150
	Total dissolved solids (TDS)	SM-2540-C										150
	Total suspended solids (TSS)	SM-2540-D										150
	Total solids	SM-2540-B										150
	Total kjeldahl nitrogen	EPA-351.2										150
	Total organic carbon	SW846-9060										150
	Mercury	SW846-7470, SW846-7471	80	25	10	10	15	5	25	10	5	150

General Information Table 1

TDEC DoR-OR ITB Analytical Water Test Table
Analytical Fraction Test Table	Analyte	Chemical Abstract Services Registry Number	TDEC DoR-OR Needed WATER Reporting Limit (RL)	Laboratory Minimum Detection Limit (MDL) WATER
		CAS #	TN AWQC's (µg/L) or EPA LHAL (ng/L) for PFAs- (* KEY)	Responding Lab please provide MDL

Metals ICP-MS	Aluminum	7429-90-5
Metals ICP-MS	Antimony	7440-36-0	≤ 5.6
Metals ICP-MS	Arsenic	7440-38-2	≤ 10
Metals ICP-MS	Barium	7440-39-3
Metals ICP-MS	Beryllium	7440-41-7
Metals ICP-MS	Cadmium	7440-43-9
Metals ICP-MS	Chromium	7440-47-3
Metals ICP-MS	Cobalt	7440-48-4
Metals ICP-MS	Copper	7440-50-8
Metals ICP-MS	Lead	7439-92-1
Metals ICP-MS	Manganese	7439-96-5
Metals ICP-MS	Molybdenum	7439-98-7
Metals ICP-MS	Nickel	7440-02-0	≤ 610
Metals ICP-MS	Selenium	7782-49-2	≤ 170
Metals ICP-MS	Silver	7440-22-4
Metals ICP-MS	Thallium	7440-28-0	≤ 0.24
Metals ICP-MS	Thorium (NOT in ICP-OES)	7440-29-1
Metals ICP-MS	Uranium (NOT in ICP-OES)	7440-61-1
Metals ICP-MS	Vanadium	7440-62-2
Metals ICP-MS	Zinc	7440-66-6	≤ 7400

Metals ICP-OES	Aluminum	7429-90-5
Metals ICP-OES	Antimony	7440-36-0	≤ 5.6
Metals ICP-OES	Arsenic	7440-38-2	≤ 10
Metals ICP-OES	Barium	7440-39-3
Metals ICP-OES	Beryllium	7440-41-7
Metals ICP-OES	Boron (NOT in ICP-MS)	7440-42-8
Metals ICP-OES	Cadmium	7440-43-9
Metals ICP-OES	Calcium (NOT in ICP-MS)	7440-70-2
Metals ICP-OES	Cerium (NOT in ICP-MS)	7440-45-1
Metals ICP-OES	Chromium	7440-47-3
Metals ICP-OES	Cobalt	7440-48-4
Metals ICP-OES	Copper	7440-50-8
Metals ICP-OES	Iron (NOT in ICP-MS)	7439-89-6
Metals ICP-OES	Lead	7439-92-1
Metals ICP-OES	Lithium (NOT in ICP-MS)	7439-93-2
Metals ICP-OES	Magnesium (NOT in ICP-MS)	7439-95-4
Metals ICP-OES	Manganese	7439-96-5
Metals ICP-OES	Mercury (NOT in ICP-MS)	7439-97-6
Metals ICP-OES	Molybdenum	7439-98-7
Metals ICP-OES	Nickel	7440-02-0
Metals ICP-OES	Phosphorus (NOT in ICP-MS)	7723-14-0
Metals ICP-OES	Potassium (NOT in ICP-MS)	7440-09-7
Metals ICP-OES	Selenium	7782-49-2
Metals ICP-OES	Silica (NOT in ICP-MS)	7631-86-9
Metals ICP-OES	Silver	7440-22-4
Metals ICP-OES	Sodium (NOT in ICP-MS)	7440-23-5
Metals ICP-OES	Strontium (NOT in ICP-MS)	7440-24-6
Metals ICP-OES	Thallium	7440-28-0	≤ 0.24
Metals ICP-OES	Tin (NOT in ICP-MS)	7440-31-5
Metals ICP-OES	Titanium (NOT in ICP-MS)	7440-32-6
Metals ICP-OES	Vanadium	7440-62-2
Metals ICP-OES	Zinc	7440-66-6	≤ 7400

Semivolatiles (SV)	1,2,4-Trichlorobenzene	120-82-1	≤ 35
SV	1,2-Dichlorobenzene	95-50-1	≤ 420
SV	1,3-Dichlorobenzene	541-73-1	≤ 320
SV	1,4-Dichlorobenzene	106-46-7	≤ 63
SV	1,2-Diphenylhydrazine	122-66-7	≤ 0.36
SV	1,2,4,5-Tetrachlorobenzene	95-94-3	≤ 0.97
SV	2,4,5-Trichlorophenol	95-95-4	≤ 1800
SV	2,4,6-Trichlorophenol	88-06-2	≤ 14
SV	2,4-Dichlorophenol	120-83-2	≤ 77
SV	2,4-Dimethylphenol	105-67-9	≤ 380
SV	2,4-Dinitrophenol	51-28-5	≤ 69
SV	2,4-Dinitrotoluene	121-14-2	≤ 1.1
SV	2,6-Dinitrotoluene	606-20-2
SV	2-Chloronaphthalene	91-58-7	≤ 1000
SV	2-Chlorophenol	95-57-8	≤ 81
SV	2-Methylnaphthalene	91-57-6
SV	2-Methylphenol	95-48-7
SV	2-Nitroaniline	88-74-4
SV	2-Nitrophenol	88-75-5
SV	3-Methylphenol	108-39-4
SV	4-Methylphenol	106-44-5
SV	3,3'-Dichlorobenzidine	91-94-1	≤ 0.21
SV	3-Nitroaniline	99-09-2
SV	2-Methyl-4,6-dinitrophenol	534-52-1	≤ 13
SV	4-Bromophenyl phenyl ether	101-55-3
SV	4-Chloro-3-methylphenol	59-50-7
SV	4-Chloroaniline	106-47-8
SV	4-Chlorophenyl phenyl ether	7005-72-3
SV	4-Nitroaniline	100-01-6
SV	4-Nitrophenol	100-02-7
SV	Acenaphthene	83-32-9	≤ 670
SV	Acenaphthylene	208-96-8
SV	Anthracene	120-12-7	≤ 8300
SV	Benzo(a)anthracene	56-55-3	≤ 0.038
SV	Benzo(a)pyrene	50-32-8	≤ 0.038
SV	Benzo(b)fluoranthene	205-99-2	≤ 0.038
SV	Benzo(g,h,i)perylene	191-24-2
SV	Benzo(k)fluoranthene	207-08-9	≤ 0.038
SV	Benzidine	92-87-5	≤ 0.00086
SV	Benzoic acid	65-85-0
SV	Benzyl alcohol	100-51-6
SV	Bis(2-chloro-isopropyl)ether	108-60-1	≤ 1400
SV	Bis(2-chloroethoxy)methane	111-91-1
SV	Bis(2-chloroethyl)ether	111-44-4	≤ 0.30
SV	Bis(2-chloromethyl)ether	542-88-1	≤ 0.0010
SV	Bis(2-ethylhexyl)phthalate	117-81-7	≤ 12
SV	Butyl benzyl phthalate	85-68-7	≤ 1500
SV	Carbazole	86-74-8
SV	Chrysene	218-01-9	≤ 0.038
SV	Di-n-butyl phthalate	84-74-2	≤ 2000
SV	Di-n-octyl phthalate	117-84-0
SV	Dibenzo(a,h)anthracene	53-70-3	≤ 0.038
SV	Dibenzofuran	132-64-9
SV	Diethyl phthalate	84-66-2	≤ 17000
SV	Dimethyl phthalate	131-11-3	≤ 270000
SV	Fluoranthene	206-44-0	≤ 130
SV	Fluorene	86-73-7	≤ 1100
SV	Hexachlorobenzene	118-74-1	≤ 0.0028
SV	Hexachlorobutadiene	87-68-3	≤ 4.4
SV	Hexachlorocyclohexane-technical	58-89-9	≤ 0.123
SV	Hexachlorocyclopentadiene	77-47-4	≤ 40
SV	Hexachloroethane	67-72-1	≤ 14
SV	Indeno(1,2,3-cd)pyrene	193-39-5	≤ 0.038
SV	Isophorone	78-59-1	≤ 350
SV	Nitrosamines	62-75-9	≤ 0.0008
SV	n-Nitrosodibutylamine	924-16-3	≤ 0.063
SV	n-Nitrosodiethylamine	55-18-5	≤ 0.008
SV	n-Nitrosodimethylamine	62-75-9	≤ 0.0069
SV	n-Nitrosodipropylamine	621-64-7	≤ 0.05
SV	n-Nitrosodiphenylamine	86-30-6	≤ 33
SV	Nitrosopyrrolidine	930-55-2	≤ 0.16
SV	Napthalene	91-20-3
SV	Nitrobenzene	98-95-3	≤ 17
SV	Pentachlorobenzene	608-93-5	≤ 1.4
SV	Pentachlorophenol	87-86-5	≤ 2.7
SV	Phenanthrene	85-01-8
SV	Phenol	108-95-2	≤ 1000
SV	Pyrene	129-00-0	≤ 830

VOA	1,1,1-Trichloroethane	71-55-6
VOA	1,1,2,2-Tetrachloroethane	79-34-5	≤ 1.7
VOA	1,1,2-Trichloroethane	79-00-5	≤ 5.9
VOA	1,1-Dichloroethane	75-34-3
VOA	1,1-Dichloroethene	75-35-4	≤ 330
VOA	1,2-Dichloroethane	107-06-2	≤ 3.8
VOA	1,2-Dichloropropane	78-87-5	≤ 5.0
VOA	1,3-Dichloropropene	542-75-6	≤ 3.4
VOA	2-Butanone	78-93-3
VOA	2-Hexanone	591-78-6
VOA	4-Methyl-2-pentanone	108-10-1
VOA	Acetone	67-64-1
VOA	Acrolein	107-02-8	≤ 6
VOA	Acrylonitrile	107-13-1	≤ 0.51
VOA	Benzene	71-43-2	≤ 22
VOA	Bromodichloromethane	75-27-4	≤ 5.5
VOA	Bromoform	75-25-2	≤ 43
VOA	Bromomethane	74-83-9	≤ 47
VOA	Carbon disulfide	75-15-0
VOA	Carbon tetrachloride	56-23-5	≤ 2.3
VOA	Chlorobenzene	108-90-7	≤ 130
VOA	Chloroethane	75-00-3
VOA	Chloroform	67-66-3	≤ 57
VOA	Chloromethane	74-87-3
VOA	cis-1,2-Dichloroethene	156-59-2
VOA	cis-1,3-Dichloropropene	10061-01-5
VOA	Dibromochloromethane	124-48-1	≤ 4.0
VOA	Ethylbenzene	100-41-4	≤ 530
VOA	Methylene chloride	75-09-2	≤ 46
VOA	Styrene	100-42-5
VOA	Tetrachloroethene	127-18-4	≤ 6.9
VOA	Toluene	108-88-3	≤ 1300
VOA	trans-1,2-Dichloroethene	156-60-5	≤ 140
VOA	trans-1,3-Dichloropropene	10061-02-6
VOA	Trichloroethene	79-01-6	≤ 25
VOA	Vinyl chloride	75-01-4	≤ 0.25
VOA	Xylenes (total)	1330-20-7

KEY:

* TN AWQC = State of Tennesse Ambient Water Quality Criteria, EPA LHAL = EPA Lifetime Health Advisory Limits

TDEC DoR-OR SEDD Format Example

TDEC DoR-OR Invitation To Bid (ITB) - Attachment 3

TDEC-DoR-OR Standard Electronic Data Deliverable Format Example

proj_name

fy_emr

staff_present

weather_notes

event_comments

field_book_name

d_start

d_end

med_type

station_name

station_type

d_collected

t_collected

collected_by

filtered

co_sampled

sample_comments

lab_parameter_name

lab_sample_type

lab_unit

lab_ana_type

lab_results

lab_number

lab_name

qualifier

ana_method

detect_limit

quant_limit

ssmdc

csu

rad_error

dilu_factor

d_analyzed

d_received_from_lab

analyzed_by

lab_results_pdf_filename

order_name

family_name

genus_name

identification_comments

Surface Water Sampling

2021

JWB

SW sampling

9/9/20

surface water

EFK 13.8

stream

9/9/20

12:00

JWB

FALSE

Alkalinity

routine

mg/L

metals

153

N2009064-05

tdh

2320-B

N2009064

Not Applicable

Surface Water Sampling

2021

JWB

SW sampling

9/9/20

surface water

EFK 23.4

stream

9/9/20

12:00

JWB

FALSE

Alkalinity

routine

mg/L

metals

127

N2009064-03

tdh

2320-B

N2009064

Not Applicable

Surface Water Sampling

2021

JWB

SW sampling

9/9/20

surface water

EFK 23.4

stream

9/9/20

12:00

JWB

FALSE

Alkalinity

field-duplicate

mg/L

metals

126

N2009064-04

tdh

2320-B

N2009064

Not Applicable

Surface Water Sampling

2021

JWB

SW sampling

9/9/20

surface water

EFK 24.4

stream

9/9/20

12:00

JWB

FALSE

Alkalinity

routine

mg/L

metals

132

N2009064-02

tdh

2320-B

N2009064

Not Applicable

column name	description
station_name	Name of the sampling location/station
d_collected	Date Collected
t_collected	Time collected in 24 hr format
filtered	true or false if filtered or not
lab_parameter_name	Name of the lab parameter
lab_unit	unit used by lab (e.g, mg/L, ug/L, etc.)
lab_results	Numeric results of laboratory test
lab_number	Lab number or Sample Delivery Group SDG (e.g, TDH uses something similar to N2009064-03)
lab_name	Name of laboratory performing the test
qualifier	result qualifier (e.g., U, J, etc.)
ana_method	Analytical method used for the test
detect_limit	detection limit
quant_limit	quantitation limit
ssmdc	Sample-specific minimum detection concentration
csu	Combined Standard Uncertainty
rad_error	Rad Error
dilu_factor	Dilution Factor
d_analyzed	Date Analyzed by lab
analyzed_by	Person from lab who analyzed the sample
lab_results_pdf_filename	Name of the file (pdf) sent from lab

image1.png image2.png image3.png image4.png

File details come from the government source that posted it. Updated Jul 11, 2024.