EMPOWER 3 : Standards concordance

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

3 posts Page 1 of 1
Hello,

I want to set up customs fields to automatically calculate differences and ratio between 2 standards.

The common practice I use is:
6 injections of standard 1 (label is Std1)
and
2 injections of standard 2 (label is Std2)
then I compare, with correction by mass, my standard areas 1 and 2.

In order to achieve this I already have create these custom field :

- Concordance
= ((StdCheckAveStd1/StdCheckAveStd2)*(Std2SampleWt/Std1SampleWt))
(Uses the other Custom Fields below to do final Calculation)

- StdCheckAveStd1 and StdCheckAveStd2
= STD1.%..AVE(Area) or STD2.%..AVE(Area)
(Averages the Areas of Std1 and Std2)

- Std1SampleW1 and Std1SampleW2
= Std1Check..(Value) or Std2Check..(Value) ' where Value is the standard amount (mg)
(Uses the weight of Std1 and Std2)

With this calculation I manage to calculate the ratio but I would also like to calculate the difference.
Here is the EXCEL formula that I use today and that I do not know how to transcribe on empower :

RF1 = AREA_Std1 / amount Std1
RF2 = AREA_Std2 / amount Std2

=ABS(RF1-RF2)/MAX(RF1,RF2)

TL;DR : How to use MAX function in EMPOWER in order to get MAX AREA between AVERAGE Standard 1 and AVERAGE Standard 2 ?

Thans you for reading me,

Maxime.
Create a peak, real CF, search order Result Set Only, call it Max_RF, The formula is:

(GT(RF1,RF2))*RF1+(GT(RF2,RF1))*RF2

This will return the value for RF1 if greater than RF2 and vice versa.

Create a second peak, real CF search order Result Set Only and incorporate the first CF into it:

(ABS(RF1-RF2))/Max_RF and this will work.
EmpowersBane wrote:
Create a peak, real CF, search order Result Set Only, call it Max_RF, The formula is:

(GT(RF1,RF2))*RF1+(GT(RF2,RF1))*RF2

This will return the value for RF1 if greater than RF2 and vice versa.

Create a second peak, real CF search order Result Set Only and incorporate the first CF into it:

(ABS(RF1-RF2))/Max_RF and this will work.

Thanks you for your response,
It did the trick !
3 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry