Appendix_B_-_EDD_Example.xlsx
XLSX spreadsheet 21 KB Posted
- Attached to
- PFAS CHEMICAL ANALYTICAL SERVICES Federal contract opportunity
- Solicitation number
- 140G0223R0012
About this file
This document contains an example file for analytical results reporting and is related to a federal contract opportunity for PFAS chemical analytical services. The example file provides guidance on properly formatting laboratory analytical results for reporting to the United States Geological Survey's National Water Information System. It specifies codes and qualifiers to include for parameters, methods, values, dates, sample identifiers and other associated data. The related federal contract opportunity is a solicitation issued by the Department of the Interior US Geological Survey Office of Acquisitions and Grants seeking analytical testing services for per- and polyfluoroalkyl substances (PFAS) chemicals. It includes the solicitation number but no further details on required services, response dates, or other contractual terms.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Q_A_0002.pdf | ||
| 140G0223R0012_rev_0002_doc_0002.pdf | ||
| Sol_140G0223R0012_Amd_0002.pdf | ||
| Updated_Appendix_D_-_Methods_with_Reporting_Requirements_(2nd_Update)_0002.xlsx | XLSX spreadsheet | |
| Appendix_A_-_Pricing_Schedule_(2nd_Update)_0002.xlsx | XLSX spreadsheet | |
| Updated_Appendix_D_-_Methods_with_Reporting_Requirements_0001.xlsx | XLSX spreadsheet | |
| 140G0223R0012_rev_0001.pdf | ||
| Sol_140G0223R0012_Amd_0001.pdf | ||
| Updated_Appendix_A_-_Pricing_Schedule_0001.xlsx | XLSX spreadsheet | |
| Appendix_D_-_Methods_with_Reporting_Requirements.xlsx | XLSX spreadsheet | |
| Appendix_E_-_ASR_Example.JPG | JPG image | |
| Sol_140G0223R0012.pdf | ||
| Appendix_A_-_Pricing_Schedule.xlsx | XLSX spreadsheet | |
| Appendix_C_-_Daily_Recipts_File_Example.xlsx | XLSX spreadsheet |
Show all 14
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
1 Example_qwresult
| Sample Integer | Parameter Code | result Value | Remark Code | QA Code | Method Code | Rounding Code | Value Qualifiers | Report level | Report Level Type | Data Quality Indicator | Null-Value Qualifier | Prep Set number | Analytical Set Number | Analysis Date | Prep Date | Lab result Comment | Field Result Comment | Lab Standard Deviation | Analyzing entity code |
| 1 | 53962 | 1.85 | LM111 | cn | 1.85 | LRL | S | HXX3157 | XLC2061 | 20210209 | 20210209 | ||||||||
| EXPLANATIONS | |||||||||||||||||||
| Sample Integer | matches the smp.txt sample info with the res.txt individual results - (Usually reference sample #1, 2, 3, etc.). [EX: Sample Integer 1 on qwsample references results in Sample Integer 1 in qwresults.] | ||||||||||||||||||
| parameter Code | 5 digit code similar to STORET code; see parameter code library in USGS NWIS | ||||||||||||||||||
| result Value | Sample result from Analytical Report. | ||||||||||||||||||
| Remark Code | See Result-level codes for USGS NWQL (non-rad) file for translation from analytical report results. | ||||||||||||||||||
| QA Code | Leave Blank | ||||||||||||||||||
| Method Code | 5 character code to describe analytical method; see method code library or contact the NWQL Contract Lab Serivces (QAS). Must upload pcode with mcode pair. Need COR approval to upload a pcode without an mcode! | ||||||||||||||||||
| Rounding Code | Leave Blank | ||||||||||||||||||
| Value Qualifiers | up to 3 qualifiers allowed (ex: cnd); additional qualifiers are added to the Lab Result Comment in column Q; (Must have a "c" value qualifier at the very least.); See Value-Qualifier Codes section of Result-level codes for USGS NWQL (non-rad) file for translation from analytical report results. | ||||||||||||||||||
| Report level | From Analytical Report | ||||||||||||||||||
| Report Level Type | From Analytical Report | ||||||||||||||||||
| Data Quality Indicator | S = immediate release to NWIS; I = WSC needs to check then release | ||||||||||||||||||
| Null-Value Qualifier | Leave Blank | ||||||||||||||||||
| Prep Set number | From Analytical Report | ||||||||||||||||||
| Analytical Set Number | From Analytical Report | ||||||||||||||||||
| Analysis Date | From Analytical Report | ||||||||||||||||||
| Prep Date | From Analytical Report | ||||||||||||||||||
| Lab result Comment | Must contain clause regarding additional qualifier codes "Added qualifier codes: none.", and will contain Contract Lab and Sub-Contract Lab sample ID numbers, and other sample site information. | ||||||||||||||||||
| Field Result Comment | Leave Blank | ||||||||||||||||||
| Lab Standard Deviation | Leave Blank | ||||||||||||||||||
| Analyzing entity code | Analyzing Laboratory Code | ||||||||||||||||||
| Value | |||||||||||||||||||
| Codes used in USGS National Water Information Systems can be found at https://nwis.usgs.gov/nwisdocs5_2/qw/QW-AppxA.pdf |
File details come from the government source that posted it. Updated .