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?
Injection | Description | Nominal Concentration | Sample Group |
---|---|---|---|
1 | Blank | 0 | Blanks |
2 | Precision 1 | 100 | Precision |
3 | Precision 2 | 100 | Precision |
4 | Precision 3 | 100 | Precision |
5 | Precision 4 | 100 | Precision |
6 | Precision 5 | 100 | Precision |
7 | Precision 6 | 100 | Precision |
8 | Precision 7 | 100 | Precision |
9 | Precision 8 | 100 | Precision |
10 | Precision 9 | 100 | Precision |
11 | Blank | 0 | Blanks |
12 | Accuracy 1 | 50 | Accuracy Low |
13 | Accuracy 2 | 50 | Accuracy Low |
14 | Accuracy 3 | 50 | Accuracy Low |
15 | Blank | 0 | Blanks |
16 | Accuracy 4 | 100 | Accuracy Med |
17 | Accuracy 5 | 100 | Accuracy Med |
18 | Accuracy 6 | 100 | Accuracy Med |
19 | Blank | 0 | Blanks |
20 | Accuracy 7 | 150 | Accuracy High |
21 | Accuracy 8 | 150 | Accuracy High |
22 | Accuracy 9 | 150 | Accuracy High |
23 | Blank | 0 | Blanks |
24 | Linearity 1 | 15 | Linearity |
25 | Linearity 2 | 30 | Linearity |
26 | Linearity 3 | 45 | Linearity |
27 | Linearity 4 | 60 | Linearity |
28 | Linearity 5 | 75 | Linearity |
29 | Linearity 6 | 90 | Linearity |
30 | Linearity 7 | 105 | Linearity |
31 | Linearity 8 | 120 | Linearity |
32 | Linearity 9 | 135 | Linearity |
34 | Linearity 10 | 150 | Linearity |
35 | Blank | 0 | Blanks |