Report to calculate RRT and rank

Andy

Thank you for the response, you've been very helpful.

It does for the most part, however are you suggesting another table in an entirely separate report or just another table within the same report?

We use our standard to monitor column health so we run it as its own injection, its not in with a sample of any sort. Do I need to set it as a reference somewhere to allow for filtering? It has a fixed name if that would make filtering easier?

Thank you for all your help with this.

Toby

Hi t0by

I assumed that you ran your standard in the same sequence as the samples.

I was suggesting that a table at the top of an existing sequence summary report could be used, but that sounds like it wouldn't work if the standard isn't in the same sequence as the samples.

Maybe a cross-sequence summary report could be used, and you would need the injection of the standard and the results set for the samples.  That way, you could filter the first table in the report to just show that sample, using Sample_Name, since that is always the same.  You could then save the RT and use that in tables used to report the remaining samples.

The other way would be to create a report parameter and type the RT of your standard each time you create a report.  Probably not the best way, though

I can't picture the type of report that you're looking to generate, so I'm being a little vague in my answers.

/Andy

Andy

Apologies I think I may have confused things more,

I merely meant to say that our reference is its own injection at the start of the sequence (we also run it intermittently through the sequence) however I just meant to clarify that the reference was not mixed with a sample in that first injection, but on its own.

So a second table, filtering using Sample_Name, save the retention time as a variable, apply it to the other table in the report and use a custom calculation?

Is there anything I could do to clarify the situation from your end?

Thank you very much,

Toby

Toby

I think that sounds like you're on the right track.

Can you explain to me how you want to report the data for each of the samples?  Are there multiple peaks in the samples?

I'm creating an example results set from the Agilent-supplied example data and I'll build a report and share screenshots with you, to illustrate how I would go about this.

Would that help?

Andy

Andy

That would be a massive help, please let me know what I could do to thank you!

So there are multiple peaks in a sample but we only quote the RT of the monomer, the other peaks are aggregate and fragments so we quote their percentages but not the RT.

So we would have a report table that has every sample as another row, with columns such as sample name, % HMWS, % LMWS, % Monomer, RT of monomer etc, however we'd also add an RRT of the monomer, relative to the standard. Happy to send a blanked screenshot if it would help.

Thanks again,

Toby

I'm not sure how you're calculating the % HMWS, % LMWS, % Monomer.  Are you identifying 3 "Compounds" in your processing method?

A screenshot would be very useful, I think!

Andy