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.

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.

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.

Hi agarwal.nik

Here's my step-by-step guide to doing what I think you are asking:

Create a new Single Sequence Summary report template

Add a Compound Summary RT Conc. Matrix

Customise the columns used in the matrix

Add the Peak_AreaPercent column and remove the Peak_RT and Compound_Concentration columns

The matrix sorts the injections alphabetically, rather than by injection order - Change the sort order in the Grouping section.

Remove the sort by Sample_Name for the first two groups

This will give you a report perfect for export to Excel.

Kind regards

Andy