ATTACHMENT 1 Data Summary Example .xlsx

XLSX spreadsheet 55 KB Posted Jan 24, 2020

Attached to: ENVIRONMENTAL SAMPLING, ASSESSMENT, AND ANALYTICAL SERVICES Federal contract opportunity
Solicitation number: W911XK20R0009
Issued by: Department of the Army Corps of Engineers Engineering District Detroit

View the file

Other files for this federal contract opportunity

Other files attached to ENVIRONMENTAL SAMPLING, ASSESSMENT, AND ANALYTICAL SERVICES, newest first.
File	Type	Posted
SOW IDIQ.DOCX	DOCX document	Jan 24, 2020
ATTACHMENT 2 NOAA Query Manager Deliverable Format.pdf	PDF	Jan 24, 2020

On GovTribe

Work with this file on GovTribe

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.

Project Depth with OD Sample ID

					Lab ID
					Latitude
					Longitude
					Date
Physical Kit	Method	State Background Conc.	State Residential Contact Criteria	State Industrial Contact Criteria	Units
Density	ASTM D854				lbs/gal
Specific Density	ASTM D854				20°C
% Moisture	ASTM D2216				% by Wt.
% Solids *	ASTM D2216				% by Wt.
Nutrients Kit	Method				Units
Phosphorus, total	SM 4500 P-F				mg/kg dry
Nitrogen, Ammonia	SM 4500 NH3-C				mg/kg dry
Nitrogen, Kjeldahl, total	SM 4500 NH3-C				mg/Kg dry
Organic Indicators Kit	Method				Units
Oil & Grease, total	SW 9071				mg/Kg dry
Cyanide, total	SW 9012				mg/kg dry
Chemical Oxygen Demand	EPA 410.4				mg/Kg dry
Total Volatile Solids	SM 2540 G				% by Wt
Total Organic Carbon	SW 9060				mg/Kg dry
PCBs	Method				Units
Aroclor-1016	SW 8082				µg/kg dry
Aroclor-1221	SW 8082				µg/kg dry
Aroclor-1232	SW 8082				µg/kg dry
Aroclor-1242	SW 8082				µg/kg dry
Aroclor-1248	SW 8082				µg/kg dry
Aroclor-1254	SW 8082				µg/kg dry
Aroclor-1260	SW 8082				µg/kg dry
Aroclor-1262	SW 8082				µg/kg dry
Aroclor-1268	SW 8082				µg/kg dry
Total PCBs #	SW 8082				µg/kg dry
Organochlorine Pesticides	Method				Units
4,4'-DDD	SW8081				µg/kg dry
4,4'-DDE	SW8081				µg/kg dry
4,4'-DDT	SW8081				µg/kg dry
Aldrin	SW8081				µg/kg dry
alpha-BHC	SW8081				µg/kg dry
alpha-Chlordane	SW8081				µg/kg dry
beta-BHC	SW8081				µg/kg dry
Chlordane (Technical)	SW8081				µg/kg dry
delta-BHC	SW8081				µg/kg dry
Dieldrin	SW8081				µg/kg dry
Endosulfan I	SW8081				µg/kg dry
Endosulfan II	SW8081				µg/kg dry
Endosulfan sulfate	SW8081				µg/kg dry
Endrin	SW8081				µg/kg dry
Endrin aldehyde	SW8081				µg/kg dry
Endrin ketone	SW8081				µg/kg dry
gamma-BHC	SW8081				µg/kg dry
gamma-Chlordane	SW8081				µg/kg dry
Heptachlor	SW8081				µg/kg dry
Heptachlor epoxide	SW8081				µg/kg dry
Methoxychlor	SW8081				µg/kg dry
Toxaphene	SW8081				µg/kg dry
Metals Kit	Method				Units
Arsenic	SW 6010				µg/kg dry
Barium	SW 6010				µg/kg dry
Cadmium	SW 6010				µg/kg dry
Chromium	SW 6010				µg/kg dry
Copper	SW 6010				µg/kg dry
Iron	SW 6010				µg/kg dry
Lead	SW 6010				µg/kg dry
Manganese	SW 6010				µg/kg dry
Mercury	SW 7471A				µg/kg dry
Nickel	SW 6010				µg/kg dry
Selenium	SW 6010				µg/kg dry
Silver	SW 6010				µg/kg dry
Zinc	SW 6010				µg/kg dry
Semi-Volatile Organic Compounds/PAH	Method				Units
2-Methylnaphthalene	SW 8270				µg/kg dry
Acenaphthene	SW 8270				µg/kg dry
Acenaphthylene	SW 8270				µg/kg dry
Anthracene	SW 8270				µg/kg dry
Benzo(a)anthracene	SW 8270				µg/kg dry
Benzo(a)pyrene	SW 8270				µg/kg dry
Benzo(b)fluoranthene	SW 8270				µg/kg dry
Benzo(g,h,i)perylene	SW 8270				µg/kg dry
Benzo(k)fluoranthene	SW 8270				µg/kg dry
Chrysene	SW 8270				µg/kg dry
Dibenzo (a,h) anthracene	SW 8270				µg/kg dry
Fluoranthene	SW 8270				µg/kg dry
Fluorene	SW 8270				µg/kg dry
Indeno(1,2,3-cd)pyrene	SW 8270				µg/kg dry
Naphthalene	SW 8270				µg/kg dry
Phenanthrene	SW 8270				µg/kg dry
Pyrene	SW 8270				µg/kg dry
BAP Equivalents	Calculated				µg/kg dry
Total PAH's ND=1/2 RL	Calculated				µg/kg dry

Biological Effects Analysis

< TEC

Sample ID

Average

Minimum

Maximum

Standard Deviation

Variance

Confidence

95% UCL

> TEC

Excedes Biological Effect Conc. (MEC)

Lab ID

Latitude

Excedes Biological Effect Conc. (PEC)

Longitude

Date

PCBs

Method

Biological Effect Conc. (TEC)

Biological Effect Conc. (MEC)

Biological Effect Conc. (PEC)

Units

Aroclor-1016

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1221

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1232

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1242

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1248

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1254

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1260

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1262

SW 8082

µg/kg dry

ERROR:#DIV/0!

Aroclor-1268

SW 8082

µg/kg dry

ERROR:#DIV/0!

Total PCBs #

SW 8082

59.8

368

676

µg/kg dry

ERROR:#DIV/0!

Organochlorine Pesticides

Method

Biological Effect Conc. (TEC)

Biological Effect Conc. (MEC)

Biological Effect Conc. (PEC)

Units

4,4'-DDD

SW8081

4.9

µg/kg dry

ERROR:#DIV/0!

4,4'-DDE

SW8081

3.2

µg/kg dry

ERROR:#DIV/0!

4,4'-DDT

SW8081

4.2

µg/kg dry

ERROR:#DIV/0!

Aldrin

SW8081

µg/kg dry

ERROR:#DIV/0!

alpha-BHC

SW8081

100

µg/kg dry

ERROR:#DIV/0!

alpha-Chlordane

SW8081

µg/kg dry

ERROR:#DIV/0!

beta-BHC

SW8081

108

210

µg/kg dry

ERROR:#DIV/0!

Chlordane

SW8081

3.2

µg/kg dry

ERROR:#DIV/0!

delta-BHC

SW8081

µg/kg dry

ERROR:#DIV/0!

Dieldrin

SW8081

µg/kg dry

ERROR:#DIV/0!

Endosulfan I

SW8081

µg/kg dry

ERROR:#DIV/0!

Endosulfan II

SW8081

µg/kg dry

ERROR:#DIV/0!

Endosulfan sulfate

SW8081

µg/kg dry

ERROR:#DIV/0!

Endrin

SW8081

2.2

105

207

µg/kg dry

ERROR:#DIV/0!

Endrin aldehyde

SW8081

µg/kg dry

ERROR:#DIV/0!

Endrin ketone

SW8081

µg/kg dry

ERROR:#DIV/0!

gamma-BHC

SW8081

µg/kg dry

ERROR:#DIV/0!

gamma-Chlordane

SW8081

µg/kg dry

ERROR:#DIV/0!

Heptachlor

SW8081

µg/kg dry

ERROR:#DIV/0!

Heptachlor epoxide

SW8081

2.5

µg/kg dry

ERROR:#DIV/0!

Methoxychlor

SW8081

µg/kg dry

ERROR:#DIV/0!

Toxaphene

SW8081

1.5

µg/kg dry

ERROR:#DIV/0!

Metals Kit

Method

Biological Effect Conc. (TEC)

Biological Effect Conc. (MEC)

Biological Effect Conc. (PEC)

Units

Arsenic

SW 6010

9,790

21,395

33,000

µg/kg dry

ERROR:#DIV/0!

Barium

SW 6010

µg/kg dry

ERROR:#DIV/0!

Cadmium

SW 6010

990

2,985

4,980

µg/kg dry

ERROR:#DIV/0!

Chromium

SW 6010

43,400

77,200

111,000

µg/kg dry

ERROR:#DIV/0!

Copper

SW 6010

31,600

90,300

149,000

µg/kg dry

ERROR:#DIV/0!

Iron

SW 6010

20,000,000

30,000,000

40,000,000

µg/kg dry

ERROR:#DIV/0!

Lead

SW 6010

35,800

81,900

128,000

µg/kg dry

ERROR:#DIV/0!

Manganese

SW 6010

µg/kg dry

ERROR:#DIV/0!

Mercury

SW 7471A

180

620

1,060

µg/kg dry

ERROR:#DIV/0!

Nickel

SW 6010

22,700

35,650

48,600

µg/kg dry

ERROR:#DIV/0!

Selenium

SW 6010

µg/kg dry

ERROR:#DIV/0!

Silver

SW 6010

µg/kg dry

ERROR:#DIV/0!

Zinc

SW 6010

121,000

290,000

459,000

µg/kg dry

ERROR:#DIV/0!

Semi-Volatile Organic Compounds/PAH

Method

Biological Effect Conc. (TEC)

Biological Effect Conc. (MEC)

Biological Effect Conc. (PEC)

Units

2-Methylnaphthalene

SW 8270

111

201

µg/kg dry

ERROR:#DIV/0!

Acenaphthene

SW 8270

µg/kg dry

ERROR:#DIV/0!

Acenaphthylene

SW 8270

128

µg/kg dry

ERROR:#DIV/0!

Anthracene

SW 8270

451

845

µg/kg dry

ERROR:#DIV/0!

Benzo(a)anthracene

SW 8270

108

579

1,050

µg/kg dry

ERROR:#DIV/0!

Benzo(a)pyrene

SW 8270

150

800

1,450

µg/kg dry

ERROR:#DIV/0!

Benzo(b)fluoranthene

SW 8270

240

6,820

13,400

µg/kg dry

ERROR:#DIV/0!

Benzo(g,h,i)perylene

SW 8270

170

1,685

3,200

µg/kg dry

ERROR:#DIV/0!

Benzo(k)fluoranthene

SW 8270

240

6,820

13,400

µg/kg dry

ERROR:#DIV/0!

Chrysene

SW 8270

166

728

1,290

µg/kg dry

ERROR:#DIV/0!

Dibenzo (a,h) anthracene

SW 8270

135

µg/kg dry

ERROR:#DIV/0!

Fluoranthene

SW 8270

423

1,327

2,230

µg/kg dry

ERROR:#DIV/0!

Fluorene

SW 8270

307

536

µg/kg dry

ERROR:#DIV/0!

Indeno(1,2,3-cd)pyrene

SW 8270

200

1,700

3,200

µg/kg dry

ERROR:#DIV/0!

Naphthalene

SW 8270

176

369

561

µg/kg dry

ERROR:#DIV/0!

Phenanthrene

SW 8270

204

687

1,170

µg/kg dry

ERROR:#DIV/0!

Pyrene

SW 8270

195

858

1,520

µg/kg dry

ERROR:#DIV/0!

Total PAH's ND=1/2 RL

Calculated

1,610

12,205

22,800

µg/kg dry

ERROR:#DIV/0!

BAP Calculations Sample ID

Lab ID
Latitude
Longitude
Date
cPAH	RPF		Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv	Conc.	BAP equiv
Benzo(a)pyrene	1	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Benzo(a)anthracene	0.1	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Benzo(b)fluoranthene	0.1	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Benzo(k)fluoranthene	0.01	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Chrysene	0.001	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Dibenzo (a,h) anthracene	1	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
Indeno(1,2,3-cd)pyrene	0.1	µg/kg dry		0		0		0		0		0		0		0		0		0		0		0		0
BAP Equivalents		µg/kg dry	0		0		0		0		0		0		0		0		0		0		0		0

0 0 0 0 0 0 0 0 0 0 0 0

File details come from the government source that posted it. Updated Jan 24, 2020.