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))

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))

Thanks Marty.  Is there any documentation on writing custom code for reporting anywhere?  It would be interesting to see if its worth doing it your way rather than just grabbing the csv files and throwing them at Excel!

/Andy

Andy,

Other than what is in the help there is no documentation as the code would be written in C++ or VB. The advantage is the code can be automated and the results can be added to IR reports. In the cases where I have done something like this for a customer the request was to have the calculations from the raw data as part of an IR report. 

Marty Adams

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,

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