Can I measure the average value of a signal in OpenLab CDS V2.7

Hello,

Not directly but it can be done with custom code. To create the report below, I wrote a custom VB dll to read the exported CSV signal file and do the average signal calculation for a variable time range around the peak RT. The same thing could be done for the average of the entire signal. 

Marty Adams

=Val(Code.DataMacro.ValueSingle(Compound_ExpectedRetTime,NoiseRange))

Dear Martin,

Could you please share this report template in .rdl ?

Thank you in advance.

Hello,

The template will not help without the custom dll and that I cannot share on the community site. 

Marty Adams

Hello Marty,

I see.
At the moment I do export of the chromatogram to csv. Than I open it using excel and manually select time range to calculate average, max and min values for height over specific time range. In my case in the range from 7 to 8 min I have 1212 data points. I would like to do it automated.
Unfortunately, I am not familiar with VB and can’t find how to write a correct expression for calculation of average, max and min height for a specific time range. Could you please advise an example of expression for such calculations that can be added to a report.
=Peak_RetentionTime( from 7 to 8 min) _avg(Peak_Height)
=Peak_RetentionTime( from 7 to 8 min) _min(Peak_Height)

Thank you in advance.
Kind regards,
Rustam

Hello Marty,

I see.
At the moment I do export of the chromatogram to csv. Than I open it using excel and manually select time range to calculate average, max and min values for height over specific time range. In my case in the range from 7 to 8 min I have 1212 data points. I would like to do it automated.
Unfortunately, I am not familiar with VB and can’t find how to write a correct expression for calculation of average, max and min height for a specific time range. Could you please advise an example of expression for such calculations that can be added to a report.
=Peak_RetentionTime( from 7 to 8 min) _avg(Peak_Height)
=Peak_RetentionTime( from 7 to 8 min) _min(Peak_Height)

Thank you in advance.
Kind regards,
Rustam

Hello,

There is no simple expression to calculate those values in IR as it has no access to the raw data points. I my example, I wrote and complied a custom dll in VB with functions that could be called in an IR template to read in the exported CSV and then do the requested calculations from the raw data. As the template and custom code was part of a on demand solution project, I cannot share it. If you need something like this done and do not have access to any programing resources, you can ask your local Agilent sales about quoting custom solutions. 

Marty 

Hello Marty,

Thank you very much for your feedback.

Kind regards,
Rustam