Report and calculation for sequence have 20+ compound in older version CDS

I have a new study that needs to report and calculate %agreement of working and checking standard each injection with 20+ compounds, which means there will be 40+ different concentration for each working and checking. 

Repeat table is not feasible because each compound has it's own concentration and we would have to write 20+ "iif()" statement or create 20+ table for each compound. 

Are there any other way we can do this? 

Thank you for your help.

Picture above are the calculation we want to perform. 

Thanks again for any help.

  • Hello,

    What software and version are you using? The calculations in 8.2 and 8.3 are just normal Average RF calibration that can be done in Chemstation or CDS as part of the normal method workflow. The calculation in 8.1 can be done using compound custom fields to enter the check standard concentration in both CDS and Chemstation. If you are using Chemstation another option would be to setup the check standard as a second level in the calibration table and run it as a cal standard with no update. This would allow you to use the concentration from the calibration table in the method. 

    Marty

  • Thank you for your reply.

    This is the version Info we currently use.

  • Hello,

    When you setup the calibration curve in Chemstation use Average Rsp/Area to match your calculations. You can then setup 2 levels in your calibration table level 1 is the working standard and level 2 would be the check. Just make sure when you run the check it is level 2 and you select no update so it will not be part of the calibration. Since is it a calibration std with a defined level you can use the calibration amount from the method as part of your calculation. 

    Marty

Was this helpful?