Average of alternating injections

Hello,

In order to assist you we will need the following:

• Software product you are using (e.g. OpenLab CDS, OpenLab ChemStation, MassHunter Quant)
• Revision of the software you are using (found by going to either Help>About or File>About)

I use openlab CDs

Hello,

Is there something in common between the injections that you want to average(sample name, vial position, label, ect.) Below is a CC example that averages peak areas for identified peaks for all injections in the same vial.

CurrentSequence.AllIdentifiedPeaks.Where(function (x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name).Where(function (x) x.Injection.Sample.Sample_VialNumber = CurrentInjection.Sample.Sample_VialNumber).Select(function(x) x.Peak_Area).Average

Marty Adams

Hi Rahma05

Do you need to do this on an automated basis. I use the Chemstation version of Open Lab and if you select any two or more results in data analysis and the appropriate report layout you can get this information displayed. 

Not sure if this helps

Kevin

Hello,

This CC would average the current injection with the next by Sample_OrderNumber in the result set. This would be a more generic way to get the average. 

CurrentSequence.AllIdentifiedPeaks.Where(function (x) x.Compound_Name = CurrentPeakOrGroup.Compound_Name).Where(function(x) x.Injection.Sample.Sample_OrderNumber = CurrentSample.Sample_OrderNumber Or x.Injection.Sample.Sample_OrderNumber = (CurrentSample.Sample_OrderNumber +1)).Select(function(x) x.Peak_Area).Average