Technologies Ltd. 

  ESDAT

Chemistry QA Error Checker

 
 

Holding Times

Holding Time Errors (Water, Liquid) - 11 errors
 
SDG Sample Code Field ID Depth Sampled Date-Time Chem Name Result Sampled to Extraction Days Sampled to Analysis Days Major Exceedance
8/01/2004 GsMW3 BH3   8/01/2004 Benzene 1 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 Ethylbenzene 1 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 m- & p-xylene 2 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 o-xylene 1 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 Toluene 1 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 TPH C10 - C14 Fraction 50 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 TPH C10 - C36 (Sum of total) 0 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 TPH C15-C28 Fraction 400 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 TPH C29-C36 Fraction 100 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 TPH C6 - C9 Fraction 280 PPB_W 43 48 Y
8/01/2004 GsMW3 BH3   8/01/2004 Xylene Total 0 PPB_W 43 48 Y


Holding Time Errors (Soil) - 11 errors
 
SDG Sample Code Field ID Depth Sampled Date-Time Chem Name Result Sampled to Extraction Days Sampled to Analysis Days Major Exceedance
001265 sMW3 BH3   8/01/2004 Benzene 1 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 Ethylbenzene 1 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 m- & p-xylene 2 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 o-xylene 1 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 Toluene 1 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 TPH C10 - C14 Fraction 50 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 TPH C10 - C36 (Sum of total) 0 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 TPH C15-C28 Fraction 400 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 TPH C29-C36 Fraction 100 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 TPH C6 - C9 Fraction 280 PPB_W 43 48 Y
001265 sMW3 BH3   8/01/2004 Xylene Total 0 PPB_W 43 48 Y


 

Blanks

Detects in Blanks - 6 errors

SampleCode Field ID Depth Sampled Date-Time Sample Type Compound Prefix Result Extraction Date SDG
Eq.Blak_27/02/2004 Blank   27/02/2004 Field_B Copper   0.9 6/02/2004 16714
Eq.Blak_27/02/2004 Blank   27/02/2004 Field_B Zinc   27.9 6/02/2004 16714
Eq.Blak_30/03/2004 Blank   30/03/2004 Field_B Copper   1 6/02/2004 16715
Eq.Blak_30/03/2004 Blank   30/03/2004 Field_B Zinc   31 6/02/2004 16715
Eq.Blak_30/1/04 Blank   27/02/2004 Field_B Copper   1 6/02/2004 16713
Eq.Blak_30/1/04 Blank   27/02/2004 Field_B Zinc   31 6/02/2004 16713


SDG's without Storage Blanks - no error


SDG's without Method Blanks - no error


 

Duplicates

Duplicate Samples with incorrect or missing Parent Samples - 3 errors

SampleCode Parent Sample Sample Type Problem
DUP8_16713_D DUP8_16713 LAB_D Parent Sample is not in database
DUP8_16714_D DUP8_16714 LAB_D Parent Sample is not in database
DUP8_16715_D DUP8_16715 LAB_D Parent Sample is not in database


Samples at the same Location/Depth/Time not specified as duplicates - no error


Field Duplicates with high RPD's - 14 errors
 
SDG Dupe Field ID Parent Field ID Depth Sampled Date-Time Method Name Compound Parent Result Dupe Result Result Unit EQL RPD
16714 DUPE2 GW1 A 27/02/2004 Filtered metals Zinc 31.5 11.7 PPB_W 5 PPB_W 92
16713 DUPE4 GW1 A 2/02/2004 Filtered metals Zinc 35.0 13.0 PPB_W 5 PPB_W 92
16715 DUPE4 GW1 A 30/03/2004 Filtered metals Zinc 35.0 13.0 PPB_W 5 PPB_W 92
16714 DUPE2 GW1 A 27/02/2004 Unfiltered metals Zinc 65.7 41.4 PPB_W 5 PPB_W 45
16713 DUPE2 GW1 A 2/02/2004 Unfiltered metals Zinc 73.0 46.0 PPB_W 5 PPB_W 45
16715 DUPE4 GW1 A 30/03/2004 Unfiltered metals Zinc 73.0 46.0 PPB_W 5 PPB_W 45
8/01/2004 DUPE1 BH1   8/01/2004 BTEX by P&T Ethylbenzene <1.0 14.0 PPB_W 1 PPB_W 173
8/01/2004 DUPE1 BH1   8/01/2004 BTEX by P&T Total Xylene 0.0 8.0 PPB_W 0 PPB_W 200
8/01/2004 DUPE1 BH1   8/01/2004 BTEX by P&T Benzene 2.0 80.0 mg 1 PPB_W 190
8/01/2004 DUPE1 BH1   8/01/2004 Volatile TPH by P&T (vTPH) C6-C9 350.0 610.0 PPB_W 0 PPB_W 54
001265 DUPE1 BH1   8/01/2004 BTEX by P&T Ethylbenzene <1.0 14.0 PPB_W 1 PPB_W 173
001265 DUPE1 BH1   8/01/2004 BTEX by P&T Total Xylene 0.0 8.0 PPB_W 0 PPB_W 200
001265 DUPE1 BH1   8/01/2004 BTEX by P&T Benzene 2.0 80.0 mg 1 PPB_W 190
001265 DUPE1 BH1   8/01/2004 Volatile TPH by P&T (vTPH) C6-C9 350.0 610.0 PPB_W 0 PPB_W 54


Field Inter-lab Duplicates with high RPD's - no error


Lab Duplicates with high RPD's - 4 errors
 
SDG Lab Duplicate Field ID Depth Sampled Date-Time Method Name Compound Parent Result Dupe Result Result Unit EQL RPD
8/01/2004 GsMW1_D BH1   8/01/2004 Petroleum Hydrocarbons (TPH) C10-C14 Fraction 290 130 PPB_W 0 PPB_W 76
8/01/2004 GsMW1_D BH1   8/01/2004 Petroleum Hydrocarbons (TPH) Sum of TPH C10 - C36 290 130 PPB_W 0 PPB_W 76
001265 sMW1_D BH1   8/01/2004 Petroleum Hydrocarbons (TPH) C10-C14 Fraction 290 130 PPB_W 0 PPB_W 76
001265 sMW1_D BH1   8/01/2004 Petroleum Hydrocarbons (TPH) Sum of TPH C10 - C36 290 130 PPB_W 0 PPB_W 76


 

Surrogates

Surrogate Variation > 25% - no error


 

Laboratory Control Samples

SDG's without a Laboratory Control Sample - no error

Laboratory Control Samples, Error > 25% - 4 errors
 

SDG SampleCode Compound Result Result Type Method Type Comments
30/01/2004 Gslcs0109w C10-C14 Fraction 20 Reg SVOC-LL  
30/01/2004 Gslcs0109w Sum of TPH C10 - C36 17.2 Reg SVOC-LL  
30/01/2004 Gslcs0109w C29-C36 Fraction 16 Reg SVOC-LL  
30/01/2004 Gslcs0112w Total Xylene 18 Reg VOC  


 

Certified and Standard Reference Materials

Certified Reference Materials - Error > 25% - no error


 

Matrix Spikes

SDG's without a Matrix Spike - no error


Less than 1 matrix spike in 20 samples, or less than 1 matrix duplicate in 20 samples - 4 errors
 

Matrix Type Number of Samples Number of Matrix Spike Samples Number of Matrix Spike Dupe Samples
GAS 12 1 0
other 3 0 0
soil 36 1 0
WATER 79 6 0


Matrix Spike Recoveries less than 30% or greater than 150% - 8 errors
 
SDG SampleCode Field ID Depth Sampled Date-Time Method Name Compound Result Result Type Comments
8/01/2004 GsMW2_S BH2   8/01/2004 BTEX by P&T Total Xylene 0 Reg  
8/01/2004 GsMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) C10-C14 Fraction 0 Reg  
8/01/2004 GsMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) Sum of TPH C10 - C36 0 Reg  
8/01/2004 GsMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) C29-C36 Fraction 0 Reg  
001265 sMW2_S BH2   8/01/2004 BTEX by P&T Total Xylene 0 Reg  
001265 sMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) C10-C14 Fraction 0 Reg  
001265 sMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) Sum of TPH C10 - C36 0 Reg  
001265 sMW2_S BH2   8/01/2004 Petroleum Hydrocarbons (TPH) C29-C36 Fraction 0 Reg  


Trip Spike Recoveries less than 30% or greater than 150% - no error


 

Other
 

Unit Conversion Problems - 1 error
 
Table Matrix Type ChemCode OriginalChemName Result Unit Output Unit Conversion
Chemistry Soil 71-43-2 Benzene mg ug/kg  


Samples associated with Wells which are not specified in the Well Table - 6 errors
 
Field ID LocCode WellCode
GW1 GW1 A
GW1 GW1 A
GW1 GW1 A
GW6 GW6 A
GW6 GW6 A
GW6 GW6 A


Aborted Analysis - 2 errors
 
SampleCode Field ID Depth Sampled Date-Time Sample Type Method Name Compound Result Result Type Comments
gsMW2_S BH2   8/01/2004 MS Volatile TPH by P&T (vTPH) C6-C9 -999 Reg # Percent recovery not available due to significant background levels of analyte in sample.
sMW2_S BH2   8/01/2004 MS Volatile TPH by P&T (vTPH) C6-C9 -999 Reg # Percent recovery not available due to significant background levels of analyte in sample.


 
Created by ESDAT. Copyright 2004

Products   |    Downloads   |    Support   |    Purchase   |    Contact us  |  Privacy Policy  |  Terms Of Use