Appendix 2 "Concentrations of anthropogenic organic compounds in groundwater and associated finished water from community water systems and in quality-assurance/quality-control samples for Source Water-Quality Assessment studies, 2002–10" Concentrations are presented by use (or source) groups as defined in table 4. Concentrations for each of the 13 groups are presented as a separate worksheet within this spreadsheet. "Data are presented within each worksheet in a similar order. First, the groundwater and finished-water samples are presented (sample type: regular), followed by quality-assurance/quality-control samples (sample types: equipment blanks, field blanks, source solution blanks, and replicates). The sample medium indicates whether the regular sample was of groundwater (source water) or finished water and whether the quality-assurance/quality-control samples were associated with groundwater (source water) or finished water. " "The concentrations presented in the worksheets are not rounded; concentrations are presented as received from the laboratories, with the following exceptions: (1) concentrations for benzophenone, bisphenol A, isophorone, N,N-diethyl-meta-toluamide (DEET), para-nonylphenol (total), pentachlorophenol, and phenol were removed by coding concentrations with an ""R"" in the remark columns; (2) for compounds detected in 50 percent or more of an individual Study Unit's field blank samples, all environmental and quality-control data for those compounds for those particular Study Units were removed by coding concentrations with an ""R"" in the remark columns, and after removal of those data; and (3) compounds detected in 5 percent or more of all field blanks were evaluated, and all detections for those compounds in environmental samples that were less than or equal to the highest blank concentration were censored by coding concentrations with a ""C<"" in the remark columns and by changing the concentration to the highest blank concentration. The remark columns indicate whether a concentration was less than (<) the minimum reporting level, censored (C), estimated (E), or removed (R); an empty cell indicates that there is no remark for the associated concentration. " Sampling component: 1 Source-water samples analyzed for all anthropogenic organic compounds. 2 Source- and finished-water samples analyzed for those anthropogenic organic compounds found to occur most frequently or at relatively higher concentrations in source-water samples collected using sampling component 1. 3 Source- and finished-water samples analyzed for all anthropogenic organic compounds. Abbreviations used in this spreadsheet: µg/L micrograms per liter < less than C censored E estimated R removed -- no data ACAD Acadian-Pontchartrain Drainages CAZB Central Arizona Basins CCYK Central Columbia Plateau/Yakima River Basin CONN "Connecticut, Housatonic, and Thames River Basins" EIWA Eastern Iowa Basins GAFL Georgia-Florida Coast Plain GRSL Great Salt Lake Basins HPGW High Plains Regional Ground Water Study LINJ Long Island-New Jersey Coastal Drainages LIRB Lower Illinois River Basin MISE Mississippi Embayment NECB New England Coastal Basins NVBR Nevada Basin and Range PODL Potomac River Basin and Delmarva Peninsula PUGT Puget Sound Basin RIOG Rio Grande Valley SACR Sacramento River Basin SANA Santa Ana Basin SANJ San Joaquin-Tulare Basins SANT Santee River Basin and Coastal Drainages SCTX South-Central Texas SOFL Southern Florida SPLT South Platte River Basin TRIN Trinity River Basin UMIS Upper Mississippi River Basin USNK Upper Snake River Basin WHMI White and Great and Little Miami River Basins