• State Verified Answer
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 118 subscribers
  • Views 1894 views
  • Users 0 members are here
Related

Agilent Knowledge Portal

Find maintenance, best practice, and troubleshooting articles.

Agilent Knowledge Portal

Calculate RSD on alternating injections

schuurda

Hello,

 

I want the be able to calculate the RSD of our reference injections, but we need to do it each time with a different injection. I'm out of inspiration to get them grouped together. This is the situation:

 

1) at the beginning of the sequence, the reference is injected 5 times

2) after 4 sample injections the reference is repeated

3) in total this are 6 reference injections, RSD needs to be calculated on those

 

So far no problem, but we can build the sequence endlessly with sample injections. So if we have 8 sample injections, another reference injection is made. Then we need to calculate RSD of this reference injection with the 5 injections at the beginning, but without the reference injection made after 4 sample injection.

 

And so on for more sample injections. I don't know how to group every time the first 5 reference injections, with each other reference injection sepperately.

 

Thanks in advance,

Davy

Parents
  • 0

    CDS 2.3.

    I added a screen with a sequence example. In this case we need the RSD on referentie 1 of line number 6,7,8,9,10,20 and 6,7,8,9,10,24

     

    Analists don't have permission to make changes in the injection list. We use sequence templates. Before start of the sequence, analists do have permission to adjust the sequence.

  • 0 in reply to schuurda

    Hello,

     

    You will need some way to differentiate the initial 5 injections of the standard you want to group with your later injections. In this example CCF, I used the sample label field with SSS to isolate those injections. Once you have that a CCF file can be used to calculate that RSD value for each injection of the level 1 standard in your sequence with the initial standards. You can name and label the CC anything you want but the scope is peak or group and the type is double. You only need the first CC in the screenshot the second was just a test. The formula is copied below.

     

     

     

    RelStdDev("Peak_Area",CurrentSequence.AllIdentifiedPeaks.Where(function  x.Injection.Sample.Sample_CalibrationLevel = 1).Where(function  x.Injection.Injection_SampleLabel.ToUpper.Equals("SSS") OR x.Injection.CreationTime = CurrentInjection.CreationTime).Where(function  x.Compound_Name = CurrentPeakOrGroup.Compound_Name))

     

     

  • 0 in reply to martin.adams

    Oh... I see. Sorry, for the first time i don't get the situation.  It's little bit more complicated.

  • 0 in reply to martin.adams

    Hello,

     

    I'm the analyst trying to calculate the RSD on the control reference in our sequence.

     

    I created a ccf file and made the link with the processing method used in the result set. Yet, no additional result is seen in the injection results after reprocessing all injections from the result set.

     

     

    First: do I have to change something in my injection list? The sample label field is now empty, what do I need to insert here?

     

    Second: how do I continue? = how do I import the results from this ccf result into the report editor? How do we filter in the injections using the ccf?

     

    Thanks for your input!

     

    Kevin

  • 0 in reply to paridake

    Hello,

     

    You will need to fix the syntax of the CC as it looks like you have an extra 1 at the end. There is a check file button in the CC editor that can be used to check all expressions in the file. In the sample label field,  I used SSS to isolate the initial standard group.

     

    Marty Adams 

  • 0 in reply to martin.adams

    Hello,

     

    Thanks for the update, I've corrected my typo.

     

    Yet, receive a lot of errors when applying the "check file button". (see attachment)

    Could you tell us what to replace the "x" with?

     

    And what does the "SSS" in the formula stand for?

     

    We're all new in the custom calculations part of the software...

     

    Thanks

     

    Kevin

  • 0 in reply to paridake

    Kevin,

     

    Sorry, I missed this in the earlier reply but the editor in the community page removed all the (X) values from the syntax of the CC. Try the syntax below it should work as I just tested it again. In my example, the SSS is the value I placed in the sample label field for the initial block of standards. 

     

     

    RelStdDev("Peak_Area",CurrentSequence.AllIdentifiedPeaks.Where(function (x) x.Injection.Sample.Sample_CalibrationLevel = 1).Where(function (x) x.Injection.Injection_SampleLabel.ToUpper.Equals("SSS") OR x.Injection.CreationTime = CurrentInjection.CreationTime).Where(function (x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name))
  • 0 in reply to martin.adams

    Hello Martin

    sorry to necro this post :s

    I just wanted to say that we have recently had some training about CC's, and one of the things we wanted to implement was this feature.
    We used your formula, (our instructor said it was quite original with the "OR" in it and quite elegant) and have successfully used it!!

    A year ago our knowledge was not quite there yet, and my colleague Kevin wasn't able to make it work.
    Now we actually understand what they do Slight smile

    so (a late) thank you for this.

    Kind regards

    Sven

Reply
  • 0 in reply to martin.adams

    Hello Martin

    sorry to necro this post :s

    I just wanted to say that we have recently had some training about CC's, and one of the things we wanted to implement was this feature.
    We used your formula, (our instructor said it was quite original with the "OR" in it and quite elegant) and have successfully used it!!

    A year ago our knowledge was not quite there yet, and my colleague Kevin wasn't able to make it work.
    Now we actually understand what they do Slight smile

    so (a late) thank you for this.

    Kind regards

    Sven

Children
No Data
Was this helpful?
Privacy Statement
Terms of Use
Contact Us
Site Help