Multiple calibration level and % residual error on each point.

HI Martin, 

thank you for your response. I will try to get a try with the calibration table so I can at least have the % residual of the mean value. 

Yes the first post initially ask how to sort and perform statistic on each curves points anf I found it later so I change the post.

Would it be diffucult to create CC for having % residual on each point knowing that I have 60 target compounds? 

JF Fortin

Hello,

Here are the residual calculations I did for another project. Please note these calculations are done against the final calibration in the result set. It will calculate the individual residuals for all compounds in all standard injections against the calibration results from the last standard. This means it will not produce residuals for brackets or other intermediate calibration blocks results. It should work for most workflows as typically the calibration is done as one block at the top of the sequence. It will include historical data if you do not clear the old values. 

Marty

thank you Martin I will take a close look at this. I try the calibration table and so far, it's doing ok even if the residual is based on the average. I didn't check for QC curve point yet. 

I need to get more involved in custom calculations. 

You seem pretty good at it. Do you offer formation or consultation ? We have tried to work with a Florida private consultant recommended by Agilent Canada, but you were the person that find how to calculate % recovery for QC and Spike for 64 different compounds. 

The consultant wasn't able to find how to do it after one week. 

I know William Cody and he knows you as well. 

Let me know if it's possible. 

I am more like a application chemist that develop and validate analytical procedure but you help me a lot with openlab CDS. 

Check that on your side and come back to me with possible options. 

I must admit that I looked at your CC files and for me it's like chinese. lol

Hello,

I do work with customer's on custom reporting and calculation projects, typically this is for client server installations, but we can work with smaller environments. We also offer classes on IR reporting and custom calculator. You would need to talk to Agilent sales in your area about possible solutions. 

Marty

Ok I will check with my sales representative here. Can I mention your name, because I don't know if you remembered you were the one who help me regarding the calibration curve and QC % recovery with a variable with 64 target compound. Agilent Canada was hiring a consultant from Florida and he didn't find what you have told me to do. 

I think you are the best guy for us in future. 

We will migrate into client server on February or March 2024.