Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Thursday, May 14, 2009 11:08:42 PM(UTC)
Rank: Member


Groups: Registered
Posts: 14

I want to sum the combined compounds using 0.5 of the EQL value for all data less than detection, however where all values are non-detects ESdat always uses a multiplier of 1.

In the example below (Table 1) for Bore 1, all parameters reported results less than detection, the sum of total has used the EQL x 1, I was expecting the sum of total to be <100 rather than <200.

For bore 2, where there is a combination of values less than detection and above the detection limit, the sum of total has used EQL x 0.5 for results less than the detection limit as expected. I was wondering how to apply EQL x 0.5 to the Bore 1 example below.   

Table 1 Output from Chemistry Results Table
ParameterUnitsEQLBore 1Bore 2
TPH C10 - C14 Fractionµg/L50<50<50
TPH C15-C28 Fractionµg/L100<100100
TPH C29-C36 Fractionµg/L50<50<50
TPH+C10 - C36 (Sum of total)µg/L <200150

Edited by moderator Friday, May 15, 2009 1:19:11 AM(UTC)  | Reason: Not specified

#2 Posted : Thursday, June 11, 2009 2:00:57 AM(UTC)
Rank: Newbie


Groups: Registered
Posts: 0
Location: Perth

I have the same issue and was wondering if it had been resolved.
Warwick Wood  
#3 Posted : Thursday, June 11, 2009 2:32:37 AM(UTC)
Warwick Wood
Rank: Administration


Groups: Registered, Administrators
Posts: 505
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

ESdat has options for how Combined Compounds are calculated under:

Setup - Chemistry - Post Import Calcs and Combined Compounds.

For all non-detects users can select whether to show:

< and the sum of the detection values, or

an estimate based on a non-detect multiplier (which can be zero)

For a mix of detects and non-detects a non-detect multiplier is set for the non-detects (which can be zero).


Edited by moderator Thursday, November 1, 2012 3:38:38 AM(UTC)  | Reason: Not specified

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.