AnsweredAssumed Answered

Using Quant, how do I average properties like RT, area, and ion ratio?

Question asked by woodsja on Jun 23, 2020
Latest reply on Jul 6, 2020 by howard_sanford

Setup: I have a 1260 with auto sampler feeding a 6495 using 7.0 for acquisition and data analysis.

Goal: Average properties like RT, Area, and ion ratio for successive injections using Quantitative Analysis.

Example: From the following injection sequence, I'd like to calculate the average and standard deviation of the RT, peak area response, and ion ratio between my target and qualifier ions for the Precision and Low/Med/High Accuracy sample groups. I can do this with Excel by exporting a CSV but I'd rather set up a Quant method and PDF reporting to perform this to minimize the amount of data interpretation.

 

How do I average properties of successive injections?

 

23 JUN 2020 Edit: It looks like there is the ability to run scripts and expressions as part of the report builder using Python for .NET; Are there any examples available of expressions or scripts that I can use to write my own? Nothing comes up immediately when I searched.

I did find the Report Builder Familiarization guide available here. Is there anything else describing the types of variables that are available or any sort of debugging environment?

 

 

InjectionDescription

Nominal

Concentration

Sample

Group

1

Blank

0Blanks
2Precision 1100Precision
3Precision 2100Precision
4Precision 3100Precision
5Precision 4100Precision
6Precision 5100Precision
7Precision 6100Precision
8Precision 7100Precision
9

Precision 8

100Precision
10Precision 9100Precision
11Blank0Blanks
12Accuracy 150Accuracy Low
13Accuracy 250Accuracy Low
14Accuracy 350Accuracy Low
15Blank0Blanks
16Accuracy 4100Accuracy Med
17Accuracy 5100Accuracy Med
18Accuracy 6100Accuracy Med
19Blank0Blanks
20Accuracy 7150Accuracy High
21Accuracy 8150Accuracy High
22Accuracy 9150Accuracy High
23Blank0Blanks
24Linearity 115Linearity
25

Linearity 2

30Linearity
26Linearity 345Linearity
27Linearity 460Linearity
28Linearity 575Linearity
29Linearity 690Linearity
30Linearity 7105Linearity
31Linearity 8120Linearity
32Linearity 9135Linearity
34Linearity 10150Linearity
35Blank0Blanks

Outcomes