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 |

Hello woodsja,

The documentation you are looking for is installed with the SDK (Software Development Kit), as noted in the last post here. The Data Set manuals contain information on how data is stored within the quant database.

Example expressions for Report Builder can be found in most of the shipping templates. Those are the only examples I'm aware of. Check in the result table cells as most reports have at least one expression.

I have attached some example Python/SDK based reports that perform averaging using Sample Groups, though not for all of the results you mention. I will update this if I find more examples.