还有一种可能的解决方案,可借助样品自定义字段识别进样对。
例如,在控制面板中创建样品自定义参数 “Spike_Sample”。输入其对应的未加标样品的样品名称。如果进样不是加标进样,请输入 ""。
范围:“峰或组”
类型:“Double”
公式:
IF(CurrentSample.GetCustomField("Spike_Sample")<>””, (CurrentSequence.AllInjectionsBySampleName(CurrentSample.GetCustomField("Spike_Sample")).First().AllPeaksAndGroupsByName(Compound_Name).first().Compound_Amount - Compound_Amount)/ CurrentPeakOrGroup .GetCustomField(“SpikedAmount”)*100, "")
公式部分(高亮显示) |
说明 |
---|---|
IF(CurrentSample.GetCustomField("Spike_Sample")<>””, (CurrentSequence.AllInjectionsBySampleName(CurrentSample.GetCustomField("Spike_Sample")).First().AllPeaksAndGroupsByName(Compound_Name).first().Compound_Amount - Compound_Amount)/ CurrentPeakOrGroup .GetCustomField(“SpikedAmount”)*100, "") | 意味着仅针对加标样品完成了计算(Spike_Sample 不为空) |
IF(CurrentSample.GetCustomField("Spike_Sample")<>””, (CurrentSequence.AllInjectionsBySampleName(CurrentSample.GetCustomField("Spike_Sample")).First().AllPeaksAndGroupsByName(Compound_Name).first().Compound_Amount - Compound_Amount)/ CurrentPeakOrGroup .GetCustomField(“SpikedAmount”)*100, "") | 选择 sample_name 拥有正确名称的进样。该名称必须是唯一的,以便按预期展开第一项工作。 |
IF(CurrentSample.GetCustomField("Spike_Sample")<>””, (CurrentSequence.AllInjectionsBySampleName(CurrentSample.GetCustomField("Spike_Sample")).First().AllPeaksAndGroupsByName(Compound_Name).first().Compound_Amount - Compound_Amount)/ CurrentPeakOrGroup .GetCustomField(“SpikedAmount”)*100, "") | 选择名称与当前名称相同的化合物,然后获取第一个。由于只有一个,所以会返回正确的峰。 |