Hello community!
I want to be able to calculate the average value of a particular signal. The signal is essentially background, no peaks, just a bit of elevated background signal.
Is there a way to do this directly in OpenLab Data Analysis?
My current solution is to export the signals using the Post Processing option to export csv files and do the work offline, in Excel.
/Andy
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))
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
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
