How can I export the peak area percentages of several hundred samples from OpenLab to excel?

agarwal.nik we probably should clarify whether you have OpenLab CDS or OpenLab ChemStation.  The link provided by ISH was for a ChemStation discussion.  What version of SW are you using?  Has your question been answered yet?

Hi!

  I'm using OpenLab CDS 2.6, so unfortunately the link provided by ISH did not help me get this done.

Hi agarwal.nik

Are all of the peaks that you want to include identified compounds?

The simple answer is to create a single sequence summary report, but the table that you add to this report depends on the nature of the peaks you want to report.

Kind regards

Andy

Hi!

   Yes, the peaks I want to include are all identified. Optimally I would like to export a spreadsheet with a column for injection # and columns for each identified peak area % alongside the corresponding injection number, but I can't seem to export any reports like that for the entire resultset, I've only been able to export a report for each injection individually.

Have you tried a summary report?  These are used to report on an entire result set.  You should be able to save one of the canned summary report templates w/ a new name and tweak it to achieve what you've mentioned above.

Have you tried a summary report?  These are used to report on an entire result set.  You should be able to save one of the canned summary report templates w/ a new name and tweak it to achieve what you've mentioned above.

This is how I've got around a similar issue.

My sequences contain lots of integrated EICs and I want to be able to summarise all of the integrated peaks for all of the EICs in each sample.  

I've created a report template with a table that has a filter for EIC signals only.  Table column headers are "sample name", "signal name" (so I know which signal is from which EIC), then simply "RT", "Height" and "area". You can choose others obvs.

I run this as a sequence summary report from the sequence output dialogue box and save it as a pdf (looks pretty for reporting) and a .csv file (not .xls - I want the numbers, not the formatting!), so I can get the numbers into excel with copying or pasting. 

In the .csv file I can select the entire output and filter on "sample name" and "signal name" as I need.  Pivot tables etc can help me manipulate the data further.  I could probably do some (most? all?) of this in the intelligent report, but that's a little beyond my skills at the moment!

This is on ChemStation C.01.10.