04__Grant-Water_Analysis_2017.xls

XLS spreadsheet 120 KB Posted

Attached to
YELL HAWKINS CHEMICAL MINIMUM GUARANTEE Federal contract opportunity
Solicitation number
140P1421Q0047
Issued by
Department of the Interior National Park Service Intermountain Region

View the file

Other files for this federal contract opportunity

Other files attached to YELL HAWKINS CHEMICAL MINIMUM GUARANTEE, newest first.
File Type Posted
09__Estimated_yearly_quantities_0001.xlsx XLSX spreadsheet
Sol_140P1421Q0047_Amd_0001.pdf PDF
08__Old_Faithful-Water_Analysis_2017.xls XLS spreadsheet
05__Lake-Water_Analysis_2017.xls XLS spreadsheet
02__Price_List.xlsx XLSX spreadsheet
06__Madison-Water_Analysis_2017.xls XLS spreadsheet
01__Statement_of_Work.docx DOCX document
07__Norris-Water_Analysis_2008.xls XLS spreadsheet
Sol_140P1421Q0047.pdf PDF
03__Canyon-Water_Analysis_2017.xls XLS spreadsheet

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.

Inorganics

Grant Village PWS#5680077NGrant Village PWS#5680077NGrant Village PWS#5680077NGrant Village PWS#5680077N
Primary Inorganics (Page 1 of 4)Primary Inorganics (Page 2 of 4)Primary Inorganics mg/l (Page 3 of 4)Primary Inorganics mg/l (Page 4 of 4)
Date9/1/785/16/807/21/804/8/839/3/86 (CG)4/12/895/8/895/22/90 (WTP)6/5/90 (MG)8/14/90 (CG)05/12/92 (STR)Date7/7/93 (MG)6/8/94 (STK)6/24/94 (RES)9/6/94 (MG)8/9/95 (633E)6/13/96 (TC)11/4/97 (MG)8/18/98 (TC)1/2/997/22/99 (MG)Date8/2/00 ( TC1)5/23/01 (TC1)6/10/01 (WTP*)8/1/02 (TC1)7/10/03 (TC1)7/1/04 (TC1)6/22/05 (WTP)1/29/06 (RAW)1/29/06 (WTP)Date6/14/06 (WTP)7/1/07 (WTP)6/3/08 (WTP)6/17/09 (PH)6/15/10 (WTP)7/5/11 (TP01)6/12/12 (TP01)6/16/13 (TP01)7/16/14 (TP01)7/8/15 (TP01)6/14/15 (TP01)6/16/16 (TP01
ParameterParameterParameterParameter
Arsenic0.011*0.009Antimony<0.005<0.005<0.005<0.005Antimony<0.006Antimony<0.006<0.006
Barium<0.1<0.10.01Arsenic<0.005<0.005<0.005<0.005Arsenic<0.01Arsenic0.0050.009
Cadmium<0.002<0.005Barium<0.1<0.1<0.1<0.1Barium<2.0Barium<2.0<2.0
Chromium<0.005<0.005Beryllium<0.001<0.001<0.001<0.001Beryllium<0.004Beryllium<0.004<0.004
Fluoride0.70.81.70.60.5Cadmium<0.001<0.001<0.001<0.001Cadmium<0.005Cadmium<0.005<0.005
Lead<0.020.003Chromium<0.01<0.01<0.01<0.01Chromium<0.1Chromium<0.1<0.1
Mercury<0.001<0.001Total Cyanide<0.005<0.005<0.005<0.005Total Cyanide<0.2Total Cyanide<0.2<0.2
Nitrates(NO3)<0.10.00.04<0.1Fluoride<0.20.75/0.180.670.510.50.57Fluoride0.610.700.60.6Fluoride0.60.6
Nitrite(NO2)<0.1Lead<0.20.047<0.005Mercury<0.002Mercury<0.002<0.002
NO3 + NO2 as N<0.2<0.2Mercury<0.2<0.0002<0.0002<0.0002<0.0006Nickel<0.1Nickel<0.01<0.01
Selenium<0.005<0.005Nickel<0.01<0.01<0.01<0.01NO3 + NO2 as N0.250.03<1.00.00.0NO3 + NO2 as N<0.05<0.05<0.05<0.050.080.010.02<0.010.01<0.010.020.02
Silver<0.004<0.005Nitrates(NO3)<0.2Selenium<0.05<0.05<0.05Selenium<0.05<0.05
Nitrite(NO2)<0.2Thallium<0.002Thallium<0.002<0.002
*Exceeds EPA MCL of 0.010 for ArsenicNO3 + NO2 as N<0.2<0.05<0.2<0.05<0.05<0.20.0<0.05<0.05
Selenium<0.005<0.005<0.005<0.005Secondary Inorganics (mg/l)
Secondary Inorganics (mg/l)Silver<0.005Secondary Inorganics (mg/l)Date6/15/10 (WTP)7/8/15 (TP01)
Date4/8/834/12/895/8/895/22/90 (WTP)6/5/90 (MG)8/14/90 (CG)Thallium<0.002<0.002<0.002<0.002Date6/10/01 (WTP*)7/10/03 (TC1)1/29/06 (RAW)1/29/06 (WTP)Parameter
ParameterParameter
Chloride3.05.86.7Secondary Inorganics (mg/l)Chloride119
ColorNONEDate9/6/94 (MG)6/13/96 (TC)11/4/97 (MG)1/2/997/22/99 (MG)ChlorideSodium1313
Copper<0.05ParameterCopper0.050.0Sulfates68
Corrosivity (LI)-2.13Chloride710Color
Detergent<0.01Color00Iron0.020.02
Iron0.090.07Copper<0.010.010.01pH6.97.437.35
OdorNONECorrosivity-0.09-1.44ROE(TDS)51.580=40102=51
Manganese0.004Detergent<1.0<1.00.01Sodium14
pH8.248.06.997.57Iron (Total)0.10.33**Sulfates
ROE(TDS)708081.5Manganese<0.010.01
Sodium131110.8OdorNONENONEGeneral Mineral (mg/l)
Sulfates15.61718.2pH8.7 s.u.7.5 s.u.6.7Date6/10/01 (WTP*)1/29/06 (RAW)1/29/06 (WTP)
ROE(TDS)1128251.5Parameter
General Mineral (mg/l)Sodium1110910Aluminum0.00.0
Date4/12/895/22/90 (WTP)6/5/90 (MG)8/14/90 (CG)Sulfates16191515Total Alkalinty as CaCO327.33331
ParameterZinc0.272.68Conductivity (umhos)103
Total Alkalinity as CaCO3442826Total Hardness as CaCO3252428
Boron (B)0.1General Mineral (mg/l)Silica4.84.4
Bromide (Br)<0.2Date9/6/94 (MG)6/13/96 (TC)1/2/99Temperature (Celsius)11.5C3.2C3.7C
Calcium12.810.6ParameterTurbidity (ntus)0.240.06
Lithium0.06Total Alkalinity as CaCO3373627.2*Tests run by EPA during Sniatry Survey
Magnesium2.27Aluminum<0.1
Phosphates (PO4)<0.3Calcium (Ca)10
Silica (SiO2)11.1Conductivity (umhos/cm)172
Strontium (Sr)0.053Total Hardness as CaCO33435
Total Hardness as CaCO34748Magnesium2.0
Temperature (C)74.88.215Total Phosphorus as P0.03
Potassium2.0
Turbidity (ntus)0.260.570.25Temperature (Celsius)11.5C
Revised 6/26/17

&C&A

Organics

Grant Village PWS#5680077N
Organics mg/l
Date5/16/808/10/8310/29/85
Parameter
Endrin<0.0002<0.0002
Lindane<0.004<0.004
Methoxychlor<0.1<0.1
Toxaphene<0.005<0.005
2,4-D<0.1<0.1
Silvex<0.01<0.01
Phenols<0.01
Grant Village PWS#5680077N
ParameterDate3/25/92(MG)6/9/92(MG)10/27/92(MG)1/26/93(MG)
Regulated VOCs
Trichloroethane<0.5<0.5<0.5<0.5
Carbon tetrachloride<0.5<0.5<0.5<0.5
Vinyl Chloride<0.5<0.5<0.5<0.5
1,2-Dichloroethane<0.5<0.5<0.5<0.5
Benzene<0.5<0.5<0.5<0.5
1,4-Dichlorobenzene<0.5<0.5<0.5<0.5
1,1-Dichloroethene<0.5<0.5<0.5<0.5
1,1,1-Trichloroethane<0.5<0.5<0.5<0.5
Trihalomehtanes
Bromodichloromethane6.457.88.7
Bromoform<0.5<0.5<0.5<0.5
Chlorodibromomethane12.31.91.7
Chloroform33212336
Unregulated VOCs
Bromobenzene<0.5<0.5<0.5<0.5
Bromomethane<0.5<0.5<0.5<0.5
Chlorobenzene<0.5<0.5<0.5<0.5
Chloroethane<0.5<0.5<0.5<0.5
Chloromethane<0.5<0.5<0.5<0.5
o-Chlorotoluene<0.5<0.5<0.5<0.5
p-Chlorotoluene<0.5<0.5<0.5<0.5
Dibromomethane<0.5<0.5<0.5<0.5
1,3-Dichlorobenzene<0.5<0.5<0.5<0.5
1,2-Dichlorobenzene<0.5<0.5<0.5<0.5
trans-1,2-Dichloroethene<0.5<0.5<0.5<0.5
cis-1,2-Dichloroethene<0.5<0.5<0.5<0.5
Methylene chloride<0.5<0.5<0.5<0.5
1,1-Dichloroethane<0.5<0.5<0.5<0.5
1,1-Dichloropropene<0.5<0.5<0.5<0.5
DBCP<0.5<0.5<0.5<0.5
Bromorchloromethane<0.5<0.5<0.5<0.5
n-Butylbenzene<0.5<0.5<0.5<0.5
sec-Butylbenzene<0.5<0.5<0.5<0.5
tert-Butylbenzene<0.5<0.5<0.5<0.5
Dichlorodifluoromethane<0.5<0.5<0.5<0.5
Fluorotrichloromethane<0.5<0.5<0.5<0.5
Hexachlorobutadiene<0.5<0.5<0.5<0.5
Isopropylbenzene<0.5<0.5<0.5<0.5
1,2-Dichloropropane<0.5<0.5<0.5<0.5
1,2-Dichloropropane<0.5<0.5<0.5<0.5
cis-1,3-Dichloropropene<0.5<0.5<0.5<0.5
trans-1,2-Dichloropropene<0.5<0.5<0.5<0.5
2,2-Dichloropropane<0.5<0.5<0.5<0.5
Etylbenzene<0.5<0.5<0.5<0.5
Styrene<0.5<0.5<0.5<0.5
1,1,2-Trichloroethane<0.5<0.5<0.5<0.5
1,1,1,2-Tetrachloroethane<0.5<0.5<0.5<0.5
1,1,2,2-Tetrachloroethene<0.5<0.5<0.5<0.5
Tetrachloroethene<0.5<0.5<0.5<0.5
Toulene<0.51.659.1
Grant Village PWS#5680077N
ParameterDate3/25/92(MG)6/9/92(MG)10/27/92(MG)1/26/93(MG)
Unregulated VOCs
Xylenes(M,P,O)<0.5<0.50.530.89
1,2-Dibromomethane<0.5<0.5<0.5<0.5
p-Isopropyltoluene<0.5<0.5<0.5<0.5
Napthalene<0.5<0.5<0.5<0.5
n-Propylbenzene<0.5<0.5<0.5<0.5
1,2,3-Trichlorobenzene<0.5<0.5<0.5<0.5
1,2,4-Trichlorobenzene<0.5<0.5<0.5<0.5
1,2,4-Trimethylbenzene<0.5<0.5<0.5<0.5
1,3,5-Trimethylbenzene<0.5<0.5<0.5<0.5

&CVOCs &CPage 2 of 2

Radiological

Grant Village PWS#5680077N
Radiological (pCi/l)
Date7/19/90(MG)5/23/01(MGRR)
Parameter
Gross Alpha<0.5 +/- 0.3
Radium 226<0.2
Revised 11/17/01

&CRadiological &CPage 1 of 1

ROs

Grant Village PWS#5680077N
Reverse Osmosis
Sample LocationSample DateCl2 (mg/l)Fluoride(mg/l)% RemovalHPC (cfu/ml)TC/FC ResultsComments
Res #642 (Post)06/28/930.2295/mlNegative
Res # 642 (Pre)07/19/940.7515/mlNegative
Res # 642 (Post)07/19/940.1876%153/mlNegative
Revised 12/15/00

&A Page &P

Bactis

Grant Village PWS#5680077N
Bacti/Cl2 Sampling Site Plan
EPA(winter)EPA(summer)PHS(winter)PHS(summer)
Bacti1/month6/month2/month6/month
Cl2 residual1/day1/day1/day1/day
Sample LocationsCGRDMGRRCGRD
MINISTRRESMINISTR
Summer = May - SeptemberGOVTTCGOVTTC
Winter = October - AprilCONCTCCONCTC
STKHSESTKHSE
HAMDRMHAMDRM

&A Page &P

TOCs

Grant Village (PWS# 5680077N)
Total Organic Carbon - TOCs (ug/l)
Date8/7/02 (INF)8/7/02 (EFF)
TOCs1.71.3
Temperature(C)7.77.3
Total Alkalinty(mg/l)3634
Trihalomethanes (ug/l)8/7/02 (648)
Bromodichloromethane6.6
BromoformND
Chlorodibromomethane1.5
Chloroform25
Total33.1
HAA5s (ug/l)8/7/02 (648)
Dibromoacetic Acid0.22
Dichloroacetic Acid8.9
Monobromoacetic AcidND
Monochloroacetic AcidND
Trichloroacetic Acid12
Total21.12

&A Page &P source H20

Grant Village (PWS# 5680077N)
Source H20 Bacterial Counts
Date1/30/074/21/074/28/075/5/076/7/076/17/07 1533*6/17/07 1627**6/28/077/1/077/17/078/3/078/21/079/7/079/16/074/17/08Date4/29/085/15/08 ID#2995/28/08 (#396)6/3/06 (#428)6/10/08 (#462)6/24/08 (#507)7/9/08 (#556)7/23/08 ( SW637)8/6/08 (SW671)8/20/08 (SW717)9/3/08 (SW762)9/16/08 (SW801)10/3/08 (834)RAA
Total Coliform CFU/100ml0011000300532702940Total Coliform CFU/100ml102320125047241.85714286
E. Coli CFU/100ml000000000000000E. Coli CFU/100ml00100000000000
Turbidity (ntus)0.330.560.170.680.370.730.710.40.380.510.360.290.30.460.297Turbidity (ntus)0.330.550.421.181.060.560.380.360.510.40.280.40.4806296296
Temperature (Celsius)1.74.534.57.36.27.27.58.51010.39.211.312.73Temperature (Celsius)3.82.97.24.14.4678.73.84.69.68.52.56.428571429
pH6.897.77.87.037.537.567.277.537.498.227.487.797.31pH7.728.18.028.418.28.257.367.517.466.876.837.047.5748
* ran crypto/giardia
For systems using lakes or reservoirs, if the mean annual E. coli concentration is greater than 10 E. coli/100 mL.
This also applies to GWUDI systems if the nearest surface water body is a lake or reservoir.
Compliance Data
Date4/17/08 (SW417a)4/29/08 (SW429a3)5/15/08 (#321)5/28/08 (#396)6/3/06 (#428)6/10/08 (#462)6/24/08 (#507)7/9/08 (#556)7/23/08 (SW637)8/6/08 (SW671)8/20/08 (SW717)9/3/08 (SW762)9/16/08 (SW801)10/3/08 (834)10/8/08 (SW857)RAA
Total Coliform CFU/100ml01023201250447205116.75
E. Coli CFU/100ml0001000000000000
Turbidity (ntus)0.290.330.550.421.181.060.560.380.360.510.40.280.40.220.4957142857
Temperature (Celsius)33.82.97.24.14.44.47.58.73.84.69.68.52.57.85.52
pH7.317.728.18.028.418.28.257.367.517.466.876.837.046.77.5557142857

&A Page &P

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .