reporting pooled results with unknown number of samples

Question

HI there,

I'm looking to report pooled precision from sequences but do not know how many samples wil be run.

The sequence takes the format:

	inj/vial
Blank	1
CAL 1-6	1
Precision (Cal 3)	6
Sample 1-5	1
Precision 2 (Cal 3)	1
Sample 6-10	1
Precision 3 (Cal 3)	1
Sample 10-13	1
Final Precision 4 (Cal 3)	1

The first set of precision data uses 6 replicate injections then after every 5 samples there is a single injection of the same cal standard and the data is combined with the Precision data from the 6 injections and the pooled RSD is then also reported. The problem is I don't know how many samples ie. how many individual precision injections (after every 5 samples) will take place in the sequence and can't think how to set the report up to take this into account.

If you are able to suggest a way to approach this it would be much appreciated.

Many thanks

martin.adams · Accepted Answer

Okay if that is the way you are doing it then you can forget custom calculator although that would work with the <= index. The way you want to do this can be done in IR. The example below shows all the standards in one repeating table. The report shows 2 ways to present the values in the table or as fields below. The template relies on a filter of sample type as calibration standards but that could be changed to something else. It also assumes that the sample names of the first injection set are all the same and that the other standards have unique names. You could alter this to use another method to repeat them as needed. This method stores the peak_area as an aggregator indexed on compound_name in case you have more than on compound. I am attaching the example template so you can see the way I did it. The template was done in 2.4.