05__Lake-Water_Analysis_2017.xls
XLS spreadsheet 69 KB Posted
- Attached to
- YELL HAWKINS CHEMICAL MINIMUM GUARANTEE Federal contract opportunity
- Solicitation number
- 140P1421Q0047
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 09__Estimated_yearly_quantities_0001.xlsx | XLSX spreadsheet | |
| Sol_140P1421Q0047_Amd_0001.pdf | ||
| 02__Price_List.xlsx | XLSX spreadsheet | |
| 06__Madison-Water_Analysis_2017.xls | XLS spreadsheet | |
| 08__Old_Faithful-Water_Analysis_2017.xls | XLS spreadsheet | |
| 04__Grant-Water_Analysis_2017.xls | XLS spreadsheet | |
| 03__Canyon-Water_Analysis_2017.xls | XLS spreadsheet | |
| 01__Statement_of_Work.docx | DOCX document | |
| 07__Norris-Water_Analysis_2008.xls | XLS spreadsheet | |
| Sol_140P1421Q0047.pdf |
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
Text version
Inorganics
| Lake Village PWS#5680079N | Lake Village PWS#5680079N | Lake Village PWS#5680079N | Lake Village PWS#5680079N | ||||||||||||||||||||||||||||||||||||||||||||||
| Inorganics mg/l (Page 1 of 6) | Inorganics mg/l (Page 2 of 6) | Inorganics mg/l (Page 3 of 6) | Inorganics mg/l (Page 4 of 6) | ||||||||||||||||||||||||||||||||||||||||||||||
| Date | 9/1/78 (FB) | 9/1/78 (Lake) | 5/16/80 | 7/21/80 (FB) | 10/24/80 (FB) | 9/3/86 (BB) | 9/3/86 (FB#B18) | 9/3/86 (LDG) | 4/12/89 (MG) | 4/26/89 (706C) | 5/8/89 | 12/18/89(769C) | 6/11/90(BB) | 3/25/92(MG) | Date | 5/27/92(BB) | 7/19/93 (769D - Pre) | 7/19/93 (769D - Post) | 7/7/93 | 6/1/94 (BB) | 7/21/94 (739A - Pre/Post) | 7/21/94 (739A - Pre/Post) | 8/1/95 (MG) | 2/22/96 (711A - Pre/Post) | 2/22/96 (739B - Pre/Post) | 8/7/96 (FB) | 10/31/96 (739A - Post) | Date | 8/4/97 (SDO) | 7/22/98 | 11/11/98 (MG) | 7/22/99 (MG) | 7/22/99 (769 - Pre/Post) | 8/2/00 (Res#659C) | 6/1/01 (#659) | 7/25/02 (#659) | 7/10/03 (659A) | 7/1/04 (659) | 3/1/05 (MGRR) | 5/11/05 (Res#659D Pre/Post) | 6/22/05 (659B) | 6/14/06 (659) | 7/1/07 (PH) | 7/1/07 (WTP) | 8/28/07 EB Spring | ||||
| Primary | Primary | Primary | Primary | ||||||||||||||||||||||||||||||||||||||||||||||
| Arsenic | <0.005 | <0.002 | <0.005 | Arsenic | Antimony | <0.005 | <0.005 | <0.006 | Antimony | ||||||||||||||||||||||||||||||||||||||||
| Barium | <0.1 | <0.1 | <0.1 | 0.002 | Barium | Arsenic | <0.005 | <0.005 | <0.1 | Arsenic | <0.001 | ||||||||||||||||||||||||||||||||||||||
| Cadmium | <0.002 | <0.002 | <0.005 | Cadmium | Barium | <0.1 | <0.1 | <2.0 | Barium | ||||||||||||||||||||||||||||||||||||||||
| Chromium | <0.005 | <0.005 | <0.005 | Chromium | Beryllium | <0.001 | <0.001 | <0.004 | Beryllium | ||||||||||||||||||||||||||||||||||||||||
| Fluoride | 3.5* | 3.5* | 1.5 | 1.7 | 4.3* | 3.7* | 1.6(Post) | 3.2* | 2.0 | Fluoride | 3.6 | 0.5 (86.1% removal) | 3.8**/>2.0** | 3.3**/0.5 | 3.1**/0.3 | 2.9**/0.2 | 0.72 | Cadmium | <0.001 | <0.001 | <0.005 | Cadmium | |||||||||||||||||||||||||||
| Lead | <0.02 | <0.02 | <0.002 | Lead | Chromium | <0.01 | <0.01 | <0.1 | Chromium | ||||||||||||||||||||||||||||||||||||||||
| Mercury | <0.001 | <0.001 | <0.001 | Mercury | Cyanide | <0.005 | <0.005 | <0.005 | Cyanide, total | ||||||||||||||||||||||||||||||||||||||||
| Nitrates(NO3) | 1.0 | <0.1 | 0.1 | 0.1 | 0.1 | 0.2 | Nitrates(NO3) | <0.2 | <0.2 | Fluoride | 4.16* | 3.78** | 3.6**/5.0** | 3.9** | 2.94** | 2.92**/0.45 | 3.62** | Fluoride | |||||||||||||||||||||||||||||||
| Nitrite(NO2) | 0.07 | <0.1 | Nitrite(NO2) | <0.2 | <0.2 | Lead | <0.005 | Lead | |||||||||||||||||||||||||||||||||||||||||
| NO3 + NO2 as N | <0.2 | <0.1 | NO3 + NO2 as N | <0.2 | <0.2 | <0.2 | <0.2 | <0.2 | Mercury | <0.0002 | <0.0006 | <0.002 | Mercury | ||||||||||||||||||||||||||||||||||||
| Selenium | <0.005 | <0.005 | <0.005 | Selenium | Nickel | <0.01 | <0.01 | <0.1 | Nickel | ||||||||||||||||||||||||||||||||||||||||
| Silver | <0.004 | <0.04 | <0.005 | Silver | Nitrates(NO3) | 0.06 | <1.0 | <1.0 | Nitrogen, Nitrite as N | ||||||||||||||||||||||||||||||||||||||||
| NO3 + NO2 as N | <0.2 | <0.2 | <0.05 | 0.05 | 0.22 | 0.11 | <0.05 | <0.05 | NO3 + NO2 as N | <0.05 | <0.05 | <0.1 | |||||||||||||||||||||||||||||||||||||
| *Exceeds EPA primary MCL for FL = 4.0mg/l | **Exceeds EPA secondary MCL for FL = 2.0mg/l | Selenium | <0.005 | <0.005 | <0.05 | Selenium | |||||||||||||||||||||||||||||||||||||||||||
| **Exceeds EPA secondary MCL for FL = 2.0mg/l | Silver | <0.002 | <0.002 | Thallium | |||||||||||||||||||||||||||||||||||||||||||||
| Thallium | <0.002 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Secondary | Date | 4/12/89 (MG) | 5/8/89 | 12/18/89(769C) | 6/11/90(BB) | 3/25/92(MG) | *Exceeds EPA primary MCL for FL = 4.0mg/l | ||||||||||||||||||||||||||||||||||||||||||
| Chloride | <1.0 | 0.6 | 25 | **Exceeds EPA secondary MCL for FL = 2.0mg/l | |||||||||||||||||||||||||||||||||||||||||||||
| Color | NONE | Secondary | 8/28/07 EB Spring | ||||||||||||||||||||||||||||||||||||||||||||||
| Copper | 0.08 | Secondary | Date | 11/11/98 (MG) | 7/22/99 (MG) | 7/10/03 (659A) | Chloride | ND | |||||||||||||||||||||||||||||||||||||||||
| Detergent | <0.01 | Copper | 0.04 | Copper | <0.03 | ||||||||||||||||||||||||||||||||||||||||||||
| Iron | <0.05 | Sodium | 3.0 | 4.0 | Iron | 6.9/6.79 | |||||||||||||||||||||||||||||||||||||||||||
| Manganese | 0.002 | Sulfates | 2.0 | 1.0 | Manganese | ||||||||||||||||||||||||||||||||||||||||||||
| Odor | NONE | pH(Field) | 6.79 | ||||||||||||||||||||||||||||||||||||||||||||||
| pH | 7.44 | 7.8 | 6.8 | Sodium | 1 | ||||||||||||||||||||||||||||||||||||||||||||
| ROE(TDS) | 86 | 80 | 61 | Sulfates | |||||||||||||||||||||||||||||||||||||||||||||
| Sodium | 3.7 | 3.0 | Total Dissolved Solids | 77 | |||||||||||||||||||||||||||||||||||||||||||||
| Sulfates | 1.0 | <1.0 | 1.3 | ||||||||||||||||||||||||||||||||||||||||||||||
| General Mineral | 8/28/07 EB Spring | ||||||||||||||||||||||||||||||||||||||||||||||||
| Alkalinity, Total as CaCO3 | 19 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Bicarbonate as HCO3 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Calcium | 6 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Carbonate as CO3 | ND | ||||||||||||||||||||||||||||||||||||||||||||||||
| General Mineral | Date | 4/12/89 (MG) | 4/26/89 (706C) | 12/18/89(769C) | 6/11/90(BB) | 3/25/92(MG) | Conductivity (umhos/cm) | 64 | |||||||||||||||||||||||||||||||||||||||||
| Total Alkalinity as CaCO3 | 20 | 22 | Hardness as CaCO3 | 20.0 | |||||||||||||||||||||||||||||||||||||||||||||
| Boron | <0.05 | Magnesium | 1 | ||||||||||||||||||||||||||||||||||||||||||||||
| Bromide | <0.2 | Potassium | 2 | ||||||||||||||||||||||||||||||||||||||||||||||
| Calcium | 11.2 | 6.1 | Temperature (Celsius) | 5 | |||||||||||||||||||||||||||||||||||||||||||||
| Total Hardness as CaCO3 | 28 | Turbidity (ntus) | 0.07 | ||||||||||||||||||||||||||||||||||||||||||||||
| Magnesium | 1.41 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Phosphate(PO4) | <0.3 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Silica(SiO2) | 37.8 | Revised 4/25/17 | |||||||||||||||||||||||||||||||||||||||||||||||
| Strontium | 0.013 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Temperature | 6C | 11C | 8.5C | 6C | |||||||||||||||||||||||||||||||||||||||||||||
| Turbidity (ntus) | 0.12 | 0.17 |
&C&A &CPage 4 of 4
Organics
| Lake Village PWS#5680079N | |||||
| Organics (mg/l) | |||||
| Date | |||||
| Parameter | 05/16/80 | 6/15/80(FB) | |||
| 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 | |||
| Lake Village PWS# 5680079N | |||||
| Page 1 of 2 | |||||
| 3/25/92(MG) | 6/9/92(MG) | 10/28/92(MG) | 1/26/93(MG) | ||
| Regulated VOCs(ug/l) | |||||
| 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 | |||||
| Bromodichloromethane | 0.5 | <0.5 | <0.5 | <0.5 | |
| Bromoform | <0.5 | <0.5 | <0.5 | <0.5 | |
| Chlorodibromomethane | <0.5 | <0.5 | <0.5 | <0.5 | |
| Chloroform | 0.53 | <0.5 | <0.5 | <0.5 | |
| Total TTHMs | <2.03 | <2.00 | <2.00 | <2.00 | |
| 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 | <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.5 | <0.5 | <0.5 | <0.5 | |
| Lake Village PWS# 5680079N | |||||
| Page 2 of 2 | |||||
| Unregulated VOCs(ug/l) | 3/25/92(MG) | 6/9/92(MG) | 10/28/92(MG) | 1/26/93(MG) | |
| Xylenes(M,P,O) | <0.5 | <0.5 | <0.5 | <0.5 | |
| 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 | |
| Revised 4/12/2001 |
&CVOCs &CPage 1 of 1
Radiological
| Lake Village PWS# 5680079N | |||||
| Radiological (pCi/l) | |||||
| 8/5/86 (YPSS) | 8/5/86 (FB) | 8/13/91(FB) | 5/23/01 (MGRR) | 8/27/09 (Well #1) | |
| Gross Alpha | <1.0 | <1.0 | <1.0 | 0.5 +/- 0.3 | 0.1-0.9 |
| Radium 226 | .02-.08 | .07-.13 | 0.7-0.8 | ||
| Uranium | 0.3ugm/l | 0.3ugm/l | |||
| Uranium | <1.0pCi/l | <1.0pCi/l | |||
| TDS | 65mg/l | 74mg/l | 93mg/l | ||
| Revised 10/15/09 |
&CRadiological &CPage 1 of 1
ROs
| Lake Village PWS#5680079N | |||||||
| Reverse Osmosis | |||||||
| Sample Location | Sample Date | Cl2 (mg/l) | Fl (mg/l) | % Removal | HPC (cfu/ml) | TC/FC | Comments |
| Res # 769D (Pre) | 07/14/93 | 0.5 | 3.6** | Negative | |||
| Res # 769D (Post) | 07/14/93 | 0.5 | 87.00% | Negative | |||
| Res # 711A | 08/23/93 | 0 | 2/ml | Negative | |||
| Res # 769A (Pre) | 07/21/94 | 0.3 | 3.8** | 0/ml | Negative | ||
| Res # 769A (Post) | 07/21/94 | >2.0 | 0.00% | 2250/ml* | Negative | ||
| Res # 739B (Pre) | 07/21/94 | 0.3 | 3.3** | 0/ml | Negative | ||
| Res # 739B (Post) | 07/21/94 | 0.5 | 85.00% | 175/ml | Negative | ||
| Res # 711A (Pre) | 02/22/96 | 3.1** | 3/ml | Negative | |||
| Res # 711A (Post) | 02/22/96 | 0.3 | 90.40% | 2/ml | Negative | ||
| Res # 769C (Pre) | 02/22/96 | 2.9** | 3/ml | Negative | |||
| Res # 769C (Post) | 02/22/96 | 0.2 | 93.10% | 2/ml | Negative | ||
| Res # 739A (Post) | 10/31/96 | 0.72 | 2900/ml* | Negative | |||
| Res # 769A (Pre) | 12/20/96 | 3.3** | 0/ml | Negative | |||
| Res # 769A (Post) | 12/20/96 | 0.3 | 91.0% | 460/ml | Negative | ||
| Res # 769C (Pre) | 12/20/96 | 2.9** | 0/ml | Negative | |||
| Res # 769C (Post) | 12/20/96 | 0.2 | 93.20% | 760/ml* | Negative | ||
| Res #711A (Pre) | 12/20/96 | 3.1** | 4/ml | Negative | |||
| Res #711A (Post) | 12/20/96 | 0.3 | 90.30% | 30/ml | Negative | ||
| Res # 769A (Post) | 09/16/97 | 1/ml | Negative | ||||
| Res # 769C (Pre) | 10/19/98 | 3.0** | 775/ml* | Negative | |||
| Res # 769C (Post) | 10/19/98 | 0.5 | 83.30% | 1475/ml* | Negative | ||
| Res # 769C (Pre) | 07/22/99 | 3.6** | 1/ml | Negative | |||
| Res # 769C (Post) | 07/22/99 | 5.0** | 0.00% | 910/ml* | Negative | ||
| Res # 759D (Pre) | 5/11/05 | 2.92** | |||||
| Res # 759D (Post) | 5/11/05 | 0.45 | 84.60% | ||||
| Revised 11/17/06 |
&A Page &P
Bactisampling
| Lake Village PWS#5680079N | ||||
| Bacti/Cl2 Sampling Site Plan | ||||
| EPA(winter) | EPA(summer) | PHS(winter) | PHS(summer) | |
| Bacti | 0 | 8/month | 2/month | 8/month |
| Cl2 residual | 0 | 3/week | 1/day | |
| Sample Locations | FBRV | MGRR | FBRV | |
| FBYPSS | RST | FBYPSS | ||
| SDO | SDO | |||
| LDGHYD | LDGHYD | |||
| MH | MH | |||
| MGRR | MGRR | |||
| BBCGRD | BBCGRD | |||
| BBPCNC | BBPCNC |
&A Page &P
Source Water
| Lake Village PWS#5680079N | |||||||||||
| Source Water | |||||||||||
| Date | 6/14/07 LK | 6/14/07 EB | 6/19/07 FB | 7/1/07 EB | 7/5/07 FB | 8/16/07 EB | 8/16/07 EB & Lake | 8/28/07 EB & Lake | 6/3/08 (#430) | RAA | |
| Total Coliform CFU/100ml | 0 | 2 | 89 | 0 | 2 | 2 | 1 | 6 | 0 | 12.75 | |
| E. Coli CFU/100ml | 0 | 2 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0.625 | |
| Turbidity (ntus) | 0.45 | 0.23 | 1.1 | 0.062 | 0.07 | 0.05 | 0.07 | 4.98 | 0.8765 | ||
| Temperature (Celsius) | 10 | 11.6 | 10 | 51F | 11.1 | 11.1 | 5 | 10 | 9.8285714286 | ||
| pH | 6.8 | 7.3 | 6.68 | 6.9 | 6.9 | 6.79 | 6.9 | 6.8957142857 |
&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 .