Expression for calulating RSD in OpenLab 2.7

Hello,

All injections in the report or just certain types of injections? You could do this as a custom calculation but if you want to do it in the IR reporting that is also possible. Do you need to do it for just the one compound, as it would be just about as easy to do it for all named compounds.

Marty Adams

Hey Martin,

Just for the selected injections in the report, and only for one compound at the moment.  Once I get a hang for for formula we'll use it for other applications later on.

Hello,

See the link below for a pdf version of a CC file that will do the calculations. In the example, the RSD is calculated for area and RT by sample type, calibration level, and compound. I also show an example for RT RSD for all injections. I also calculate a Pass/Fail from a limit and the previously outlined CCs. You can view the results in DA and also add to reports. 

/cfs-file/__key/communityserver-discussions-components-files/26/Com-Example.pdf

Thanks, I'll play around with this and see how it works!

Hi Martin,

How would I go about using conditional formatting for the Area P/F field to color the field green for Pass and Red for Fail?  I'm not quite sure what type of exprssion to use.

Hi Martin,

How would I go about using conditional formatting for the Area P/F field to color the field green for Pass and Red for Fail?  I'm not quite sure what type of exprssion to use.