Compound_CalibAmount in report

Hello

I have a processing method where there is some calibration amount entered for a compound. When I am processing a sequence where there are no standards, only QC checks, I cannot get the Compound_CalibAmount values from the processing method and use it in reporting. Is there a way?

Thank you

Martin

Parents
  • Hi Martin,

     

    The Compound_CalibAmount function could only be called out if the processing data file is defined as "Calibration" in the sequence. I am not sure which calculations you are trying to perform that need those calibration amounts as most of the time you would just need to use the compound_responsefactor instead. Perhaps you could elaborate your calculation.

     

    In case you really need the calibration amount, and depending on which version you are using, you could do this:

     

    1. For C.01.08 and below: you can store these amount in compound custom fields or report parameters.

    2. For C.01.09 and above: it would be more convenient to store the amounts in an external file like txt and use some VB codes to import the values.

    3. For CDS2.x you could simply create a constant file.

     

    Hope this helps. 

     

    Peter.

  • Hello petertran,

    thank you for your reply. in that case there is probably a way to calculate recovery of standard checks? say i have a sequence with only samples and QC checks. calibration is stored in the processing method. I want to show in report simple % value of the QC check with respect to the corresponding calibration amount.

    thank you

    martin 

  • Hi Martin,

     

    Is your calibration table having multiple levels or only one level ? And is your QC the same as one of the levels in your calibration table ? Also which software revision are you using ?

     

    Peter.

  • Hello

    multiple levels, QC is one of the standards. 

    OpenLab Data Analysis - Build 2.205.0.1344 version 2.5

  • Hi Martin Adams,

     

    That's helpful. Thanks for the custom formulas. However I can't find any official documents discussing about the classes you are using in the formula. Would you please suggest one ? Without understanding the whole formula it would be hard for us as users to modify or create new formula for our needs.

     

    Hi Martin,

     

    Back to your original question since the QC is one of the calibration levels, an alternative to Adam's suggestion would be to change the QC run from "Quality Control" to "Calibration" in the sequence and select the appropriate level (no update to RT and RF). That way you should be able to use compound_calibamount function for any of your calculations.

     

    Peter.

  • Thanks Martin, it's very useful.

     

    Peter.

Reply Children
No Data
Was this helpful?