Is there an option to select a field in data analysis to report % recovery for check standards? or is this a custom calculator situation. If CC is required could someone assist me in the formatting for the calculation. I am using OpenLabs CDS.
Find maintenance, best practice, and troubleshooting articles.
Is there an option to select a field in data analysis to report % recovery for check standards? or is this a custom calculator situation. If CC is required could someone assist me in the formatting for the calculation. I am using OpenLabs CDS.
in the calculation what is the sample type=4 for?
If that is the case, you only need one CC as below. You could get away with Compound_Concentration / Sample_Amount * 100 but it would do the calculation for all the injections. Just put the check standards conc in the sample amount field in the sequence. The likely reason "Simply give them sample amount and dilutionFactors/multipliers, then the calculated result will be the recovery :)" this did not work is that sample amount is not used in the concentration calculation unless you have selected % mass calculation.
Marty Adams
If(Sample_Type = 4, Compound_Concentration / Sample_Amount * 100, 0)
4 is the enumeration value for the sample_type control (QC Check). If(Sample_Type = 4, Compound_Concentration / Sample_Amount * 100, 0) means that if the sample type is QC Check then the recovery calculation will be performed if not it will assign 0.0 as the value of the CC.
Marty Adams
thank you for the clarification. the sample type is listed as QC check but the CC field in the injection results is blank?
If the column is present but empty, then you must be missing a value it needs. I assume for the other injection types you are getting 0.0 as the value. The calculation requires the peak have a calculated concentration and the injection have a non zero sample amount which should be the check standard conc.
Marty Adams
Thank you for your response. I realized the sample amount had not been entered and now it is populating. As for the zero at the end, is that to tell the calculation how many significant figures?