Chromatography Forum

Hello,
This seems like it should be relatively easy and straight forward to do, but I haven't been able to figure it out.
Using Empower 2, I'm trying to set up a general summary report for system maintenance that allows me to go into a project, or multiple projects in global view, select all the sample sets run during a period of time and report the number of sample sets run. My lab is GMP regulated, so i prefer to do this without processing data or generating new results. I've tried to use the Count summary function on a Sample set field in the report editor, but it looks like the dataset used is basically a big table based on injections so no matter what I use I end up counting the number of injections.
We currently do obtain this information by manual counting. I'm hoping to automate this enough so at most all we have to do is set up a time based filter to limit the information to sample sets obtained during a specific stretch of time.

Thank you for the help.

Use view filter, scroll to bottom, read line number?

Doooh! Why do i always fail to see the simplest solutions.....

Thank you for the help. While this will work for sample sets, it is still more of a manual process and not all of the information I'll want. I only mentioned sample set as an example to be brief, but there are other sample set level custom fields (column ID, product tested, etc.) that i would like to count. I didn't see a way to include the custom fields as a viewable field in the Sample set window.

The more i think about it, the more unneccessary this seems. In the end, what is important is how many injections have been made and pushed through a system/column. I've already found counting injections to be pretty easy; I think I'll just stick to injection counting.

For anyone else interested in this I found labSuite which is an add on software that appears to automatically build its own database from Empower information which provides easy reporting of LC management information. I don't know the cost, but it looked pretty nice. Someone with the time and knowledge could likely set up something similar by exporting the sample set info to Excel or Access.

Again, thanks for the help.

Use view filter, scroll to bottom, read line number?

But this doesn't work with global projects.

Ace

For anyone else interested in this I found labSuite which is an add on software that appears to automatically build its own database from Empower information which provides easy reporting of LC management information. I don't know the cost, but it looked pretty nice. Someone with the time and knowledge could likely set up something similar by exporting the sample set info to Excel or Access.

Again, thanks for the help.

Thanks for the labSuite info.

Something I did in the past: made a view filter for my injections with all the info I needed (Acq by, Sample set name, ...), imported this table into R-project, for which I made a script to extract all the relevant data (like number of sample sets run on an instrument, number of sample sets started by every analyst,...)

Ace

Again, most stuff will have to be done "per project" - but if you have column ID as a required field for each project, a view filter can be built to look at that as well.

This may be somewhat off topic, but using the count command, would it be possible to create a variable for number of injections where I could set the number of injections shown in a report?
For example; from 6 standard injections with the labels S0101, S0201, etc. could I have it only use injections say 3 and 4 in a summary report? (while still loading all injections into report)

This may be somewhat off topic, but using the count command, would it be possible to create a variable for number of injections where I could set the number of injections shown in a report?
For example; from 6 standard injections with the labels S0101, S0201, etc. could I have it only use injections say 3 and 4 in a summary report? (while still loading all injections into report)

Not sure what you mean, but you could add a filter to your table which sorts out injection 3 and 4?

Ace

I'm trying to figure out a way to load a whole sample set in a report and have it summarize overlaping bracketing standards by twos. A new calibration curve is generated for each set of 2 standards so there should be SOME way...I just can't figure it out.

Curve 1- S0101+S0201
Curve 2- S0201+S0301
Curve 3- S0301+S0401

etc. I'd like one page per bracket showing the 2 injections and you know averaged area and such.

Is there a specific way it assigns a result ID or curve ID so that I could use a general identifier?

Is there a specific way it assigns a result ID or curve ID so that I could use a general identifier?

What's wrong with calibration curve ID?

You can make a report with calibration curve tables, this will generate a report with a table for each calibration curve. In this table, you can add sample name, date acquired, calibration ID, ...

Then you can add tables with filter where you only use unknowns, not standards.
If you add calibration ID to this table, one can see which calibration is used to calculate which result.

Ace

hey! I never thought to go that way, if I have time I will try it today! Thanks!