B08_Appendix_B_EDD_File_Example.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
RADCHEM TESTING
Solicitation number
140G0225R0019
Issued by

About this file

This file is an Excel spreadsheet (B08 Appendix B EDD File Example) containing detailed radiochemistry testing data for Radium-224 in water samples, directly related to the US Geological Survey's (USGS) Solicitation Number 140G0225R0019 for Radiochemistry (Radchem) Analysis. The data includes multiple water sample measurements from various geographic locations, with each entry documenting critical details such as sample location ID, observed and analyzed datetime, result values (in pCi/L), measurement uncertainties, sample types (groundwater, produced water), and laboratory analysis metadata.

The data appears to be part of an Indefinite Delivery, Indefinite Quantity (IDIQ) contract for radiochemical water testing, with samples collected between October and December 2021. Each sample entry includes technical specifics like laboratory method (AS056, Radium-224 water filtration alpha analysis), result qualifiers, standard deviation values, and quality control indicators. The samples represent diverse water sources across different time zones, with result values ranging from 0.007 pCi/L to 63 pCi/L, and include various quality control samples such as blanks, replicates, and produced water tests.

View the file

Other files

File Type Posted
Sol_140G0225R0019_Amd_0001.pdf PDF
B08_Appendix_C_Daily_Sample_Receipt_-_Example.xlsx XLSX spreadsheet
B08_Appendix_D_Methods_with_Reporting_Requirements.xlsx XLSX spreadsheet
Sol_140G0225R0019.pdf PDF
B08_Appendix_A_Pricing_Schedule.xlsx XLSX spreadsheet
B08_Appendix_E_ASR.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

B08 Appendix B EDD File Example

Location IDObserved Property IDObserved DateTimeAnalyzed DateTimeResult ValueResult UnitNull Measure Qualifier CodeMediumLab: Analysis MethodLab: Detection ConditionLab: MDLLab: MRLLab: Received DateTimeLab: Prepared DateTimeLab: From LaboratoryLab: CommentQC: TypeActivity: CommentActivity:EA_SIDNOEA_Radiochemical uncertainty typeEA_Radiochemical uncertainty valueEA_Reporting levelEA_Reporting level typeEA_Result value (original - as text)EA_Set number - analysisEA_Set number - preparationEA_Standard deviation value - laboratoryEA_Value qualifier code(s) textVolume UsedInstrument Number
USGS-353229119050601Radium-224, water, fltd2021-10-26 12:00:00.000[PDT]2021-12-22 [PDT]0.035pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021364541-sigma uncertainty0.0850.1764SSLC - Sample-specific critical level0.035RXXX_22188J
USGS-334831118173301Radium-224, water, fltd2021-12-06 09:01:00.000[PST]2021-12-10 [PST]22.88pCi/LWDQ - QC sample - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]REPLICATEWQL-0022005731-sigma uncertainty8.314.79SSLC - Sample-specific critical level22.88RXXX_22220L[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-345252120191001Radium-224, water, fltd2021-12-07 08:00:00.000[PST]2021-12-10 [PST]2.244pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005781-sigma uncertainty0.460.6937SSLC - Sample-specific critical level2.244RXXX_22220M[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-345233120183301Radium-224, water, fltd2021-12-07 10:00:00.000[PST]2021-12-10 [PST]4.659pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005791-sigma uncertainty0.50.492SSLC - Sample-specific critical level4.659RXXX_22220M[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-345927078170301Radium-224, water, fltd2021-12-14 11:39:00.000[EST]2021-12-16 [EST]0.118pCi/LOAQ - QC sample - Artificial (Other)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]BLANKWQL-0022245441-sigma uncertainty0.0590.1339SSLC - Sample-specific critical level0.118RXXX_22222F
USGS-344911120153501Radium-224, water, fltd2021-12-12 13:00:00.000[PST]2021-12-16 [PST]0.129pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021410881-sigma uncertainty0.0940.1738SSLC - Sample-specific critical level0.129RXXX_22221I
USGS-354245077311701Radium-224, water, fltd2021-12-07 15:00:00.000[EST]2021-12-10 [EST]1.002pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021404491-sigma uncertainty0.160.224SSLC - Sample-specific critical level1.002RXXX_22220M[^ - yield outside of contractually acceptable range]
USGS-353229119050601Radium-224, water, fltd2021-10-26 12:01:00.000[PDT]2021-12-22 [PDT]0.112pCi/LWGQ - QC sample - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]REPLICATEWQL-0021364551-sigma uncertainty0.0860.161SSLC - Sample-specific critical level0.112RXXX_22188J
USGS-395920075031902Radium-224, water, fltd2021-10-07 10:35:00.000[EDT]2021-10-11 [EDT]1.818pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021340531-sigma uncertainty0.250.3128SSLC - Sample-specific critical level1.818RXXX_22234E[^ - yield outside of contractually acceptable range]
USGS-344733120154001Radium-224, water, fltd2021-12-08 15:00:00.000[PST]2021-12-13 [PST]3.004pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005911-sigma uncertainty1.62.962SSLC - Sample-specific critical level3.004RXXX_22220N[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-344738120153301Radium-224, water, fltd2021-12-08 09:00:00.000[PST]2021-12-13 [PST]0.95pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005941-sigma uncertainty0.571.059SSLC - Sample-specific critical level0.95RXXX_22220N[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-395918075032401Radium-224, water, fltd2021-10-07 12:40:00.000[EDT]2021-10-11 [EDT]0.8559pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021340541-sigma uncertainty0.240.4281SSLC - Sample-specific critical level0.8559RXXX_22234E[^ - yield outside of contractually acceptable range]
USGS-353229119050604Radium-224, water, fltd2021-10-27 13:00:00.000[PDT]2021-12-22 [PDT]0.125pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021364561-sigma uncertainty0.0780.1506SSLC - Sample-specific critical level0.125RXXX_22179A[^ - yield outside of contractually acceptable range]
USGS-394808075172403Radium-224, water, fltd2021-12-07 12:10:00.000[EST]2021-12-10 [EST]6.268pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021402451-sigma uncertainty0.540.3506SSLC - Sample-specific critical level6.268RXXX_22220M
USGS-334831118173301Radium-224, water, fltd2021-12-06 09:00:00.000[PST]2021-12-10 [PST]15.56pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005741-sigma uncertainty8.515.05SSLC - Sample-specific critical level15.56RXXX_22220L[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-334827118175801Radium-224, water, fltd2021-12-06 07:00:00.000[PST]2021-12-10 [PST]1pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005751-sigma uncertainty1223.84SSLC - Sample-specific critical level1RXXX_22220L[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-344710120145601Radium-224, water, fltd2021-12-08 13:00:00.000[PST]2021-12-13 [PST]2pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005901-sigma uncertainty1.12.027SSLC - Sample-specific critical level2RXXX_22220N[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-351806077434501Radium-224, water, fltd2021-12-08 12:30:00.000[EST]2021-12-13 [EST]0.02pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021404481-sigma uncertainty0.130.2778SSLC - Sample-specific critical level0.02RXXX_22220N
USGS-353605077483901Radium-224, water, fltd2021-12-07 12:00:00.000[EST]2021-12-10 [EST]0.264pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021404471-sigma uncertainty0.10.1834SSLC - Sample-specific critical level0.264RXXX_22220M
USGS-394808075172402Radium-224, water, fltd2021-12-09 14:10:00.000[EST]2021-12-13 [EST]0.7077pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021407011-sigma uncertainty0.150.2316SSLC - Sample-specific critical level0.7077RXXX_22220O
USGS-352301077300701Radium-224, water, fltd2021-12-08 11:00:00.000[EST]2021-12-13 [EST]0.04pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021404461-sigma uncertainty0.140.2803SSLC - Sample-specific critical level0.04RXXX_22220N
USGS-345307120191301Radium-224, water, fltd2021-12-13 14:00:00.000[PST]2021-12-16 [PST]0.007pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021410891-sigma uncertainty0.0980.1969SSLC - Sample-specific critical level0.007RXXX_22221J
USGS-353350119055401Radium-224, water, fltd2021-12-09 08:00:00.000[PST]2021-12-13 [PST]5.485pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005891-sigma uncertainty1.21.849SSLC - Sample-specific critical level5.485RXXX_22220O[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-394808075172403Radium-224, water, fltd2021-12-07 13:05:00.000[EST]2021-12-10 [EST]5.348pCi/LWGQ - QC sample - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]REPLICATEWQL-0021402441-sigma uncertainty0.50.3686SSLC - Sample-specific critical level5.348RXXX_22220M
USGS-351654119081401Radium-224, water, fltd2021-12-14 10:00:00.000[PST]2021-12-16 [PST]0.05pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021413061-sigma uncertainty0.0760.1546SSLC - Sample-specific critical level0.05RXXX_22222D
USGS-334728118163001Radium-224, water, fltd2021-12-06 11:00:00.000[PST]2021-12-11 [PST]63pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005711-sigma uncertainty3470.53SSLC - Sample-specific critical level63RXXX_22220L[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-345120120173501Radium-224, water, fltd2021-12-13 09:00:00.000[PST]2021-12-16 [PST]0.3817pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021410871-sigma uncertainty0.120.22SSLC - Sample-specific critical level0.3817RXXX_22221H[^ - yield outside of contractually acceptable range]
USGS-372105077113601Radium-224, water, fltd2021-12-20 11:00:00.000[EST]2021-12-23 [EST]0.11pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]Generated activity from observation import file file401411e51d1b_2dbe9c2d-31b2-47f3-b909-f9414963b808.csvWQL-0021418961-sigma uncertainty0.110.2092SSLC - Sample-specific critical level0.11RXXX_22188K
USGS-351653119084401Radium-224, water, fltd2021-12-15 08:00:00.000[PST]2021-12-20 [PST]0.14pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021413051-sigma uncertainty0.170.3236SSLC - Sample-specific critical level0.14RXXX_22221C
USGS-345941078105001Radium-224, water, fltd2021-12-14 14:30:00.000[EST]2021-12-16 [EST]0.04pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021411111-sigma uncertainty0.080.161SSLC - Sample-specific critical level0.04RXXX_22222C
USGS-344734077254601Radium-224, water, fltd2021-12-15 10:00:00.000[EST]2021-12-20 [EST]0.02pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021415281-sigma uncertainty0.160.326SSLC - Sample-specific critical level0.02RXXX_22221C[^ - yield outside of contractually acceptable range]
USGS-351653119074301Radium-224, water, fltd2021-12-15 12:00:00.000[PST]2021-12-20 [PST]0.3147pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021413071-sigma uncertainty0.130.2336SSLC - Sample-specific critical level0.3147RXXX_22221C
USGS-365147076343001Radium-224, water, fltd2021-12-08 11:00:00.000[EST]2021-12-13 [EST]0.07pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021404261-sigma uncertainty0.160.3125SSLC - Sample-specific critical level0.07RXXX_22220N
USGS-353600119080001Radium-224, water, fltd2021-12-01 08:00:00.000[PST]2021-12-02 [PST]0.053pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021400151-sigma uncertainty0.0650.1261SSLC - Sample-specific critical level0.053RXXX_22195K
USGS-353410119054401Radium-224, water, fltd2021-12-09 10:00:00.000[PST]2021-12-13 [PST]1.695pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005881-sigma uncertainty0.220.246SSLC - Sample-specific critical level1.695RXXX_22220O[^ - yield outside of contractually acceptable range]
USGS-345927078170301Radium-224, water, fltd2021-12-14 11:30:00.000[EST]2021-12-16 [EST]0.009pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021411101-sigma uncertainty0.0760.1523SSLC - Sample-specific critical level0.009RXXX_22222E
USGS-403029112043401Radium-224, water, fltd2021-12-08 12:30:00.000[MST]2021-12-13 [MST]1.268pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021405071-sigma uncertainty0.210.2842SSLC - Sample-specific critical level1.268RXXX_22220N
USGS-345927078170301Radium-224, water, fltd2021-12-14 11:38:00.000[EST]2021-12-16 [EST]0.04pCi/LOAQ - QC sample - Artificial (Other)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]BLANKWQL-0021411121-sigma uncertainty0.070.138SSLC - Sample-specific critical level0.04RXXX_22222G
USGS-344720120155401Radium-224, water, fltd2021-12-08 07:00:00.000[PST]2021-12-13 [PST]1.19pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005931-sigma uncertainty0.831.551SSLC - Sample-specific critical level1.19RXXX_22220N[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-344743120152501Radium-224, water, fltd2021-12-08 11:00:00.000[PST]2021-12-13 [PST]1.5pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0022005921-sigma uncertainty1.52.916SSLC - Sample-specific critical level1.5RXXX_22220N[) - sample-specific MDC (ssMDC) above contractual MDC]
USGS-334730118163701Radium-224, water, fltd2021-12-06 13:00:00.000[PST]2021-12-10 [PST]55.79pCi/LWD - Produced water (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0022005721-sigma uncertainty2750.1SSLC - Sample-specific critical level55.79RXXX_22220L[) - sample-specific MDC (ssMDC) above contractual MDC];[^ - yield outside of contractually acceptable range]
USGS-380139077212901Radium-224, water, fltd2021-12-07 11:00:00.000[EST]2021-12-10 [EST]0.2932pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021403651-sigma uncertainty0.120.2206SSLC - Sample-specific critical level0.2932RXXX_22220M
USGS-353229119050602Radium-224, water, fltd2021-10-27 09:00:00.000[PDT]2021-12-22 [PDT]0.022pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021364531-sigma uncertainty0.0740.1463SSLC - Sample-specific critical level0.022RXXX_22179A
USGS-353122119065201Radium-224, water, fltd2021-12-01 21:00:00.000[PST]2021-12-07 [PST]0.06pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)R[Redacted]WQL-0021400141-sigma uncertainty0.170.3289SSLC - Sample-specific critical level0.06RXXX_22195L
USGS-353229119050603Radium-224, water, fltd2021-10-26 08:00:00.000[PDT]2021-12-22 [PDT]0.2986pCi/LWG - Groundwater (Water)AS056;Radium-224, wf, alpha (Eberline);USGSNWQL (QW)[Redacted]WQL-0021364521-sigma uncertainty0.0970.1745SSLC - Sample-specific critical level0.2986RXXX_22188J

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