Page 1 of 1

Empower Custom Field Calculation with Bracketing Standard

Posted: Wed Feb 26, 2014 4:07 pm
by amittanna04
does any one know how to perform calculation of sample within the bracket with average of bracketing standard. Below is an example;

Sequence:
Std-1
Std-2
BS-1 (Bracketing Standard-1) - it is same as SS-1
Sample-1
Sample-2
BS-2
Sample-3
Sample-4
BS-3

The results for sample-1&2 will be calculated using average response value of BS-1 & BS-2 while results for Sample-3 & 4 will be calculated using average response value of BS-3 & BS-4.

Thanks

Re: Empower Custom Field Calculation with Bracketing Standar

Posted: Thu Feb 27, 2014 1:52 pm
by shaun78
Pictures are worth a thousand words:

Image

Make your sample set method look like what I have above.

Custom fields:

Code: Select all

SS1.%.%.AVE(Area)
SS2.%.%.AVE(Area)
You will need an SS#.%.%.AVE(Area) for as many SS# labels as you require in your sample set. I generally name these custom fields, SS1, SS2, etc. These are all peak, real (0.0), calculated type custom fields.

You will now need a custom field to calculate recoveries (peak, enum, calculated, used as field type custom field):

Code: Select all

ENUM((EQ(Label,"SS2")),(EQ(Label,"SS3")))

Translation                       Value
0                                     (SS2/SS1)*100 (fc)
1                                     (SS3/SS1)*100 (fc)
You will need as many translations and values as you have brackets. This will calculate standard recoveries for you, which you did not mention, but I assumed.

The setup of the sample set method handles the calculation of the samples using the desired standards.

Re: Empower Custom Field Calculation with Bracketing Standar

Posted: Thu Feb 27, 2014 3:17 pm
by amittanna04
Thanks Shaun78

The onlything is I am not able to open the image file so if you can resend the pic that will be great.

Thanks

Re: Empower Custom Field Calculation with Bracketing Standar

Posted: Thu Feb 27, 2014 3:25 pm
by shaun78
That is strange...

I have uploaded it into my personal dropbox account. The share link is below. Let me know if you continue to have trouble.

https://www.dropbox.com/s/o7h6vd9t399siia/SSM.JPG