Chromatography Forum

Dear experts,

I am try to automate calculation in Empower 2 using custom fields that will be locked (not editable by other users). Every thing goes Ok when the chromatogram contains ONE peak .I can add a custom field eg to calculate amout of Salicylic Acid (Peak A),
[b]Concentration_of_A= Amout * 5 / 3[/b]

The problem occurs when my chromatogram contains more than ONE peak eg , Peak A , Peak B and peak C . each peak is calculated as follows :

[b]Concentration_of_A= Amout * 5 / 3[/b]
[b]Concentration_of_B= Amout * 6 / 3[/b]
[b]Concentration_of_C= Amout * 7 / 3[/b]

It's obvious that each peak have different factors , so the same equation can not be used . I need to make a custom field that is smart enough to get the constants for each peak .

I got a simple solution by storing each constant in the CONST1,CONST2,... IN THE component table . It worked fine by I have another problem that it is editable by users. when i tried to lock it , I had to lock the entire processing method which is not feasible since each user has to edit the processing method (eg changing Threshold , Retension times ,...etc and otehr parameters that changes between different runs)

I hope the situation is clear now . for any further inquires , please feel free to ask .

and thank you in advance for your help .

Dear All ,

Thank you all in advance for your help .

You can make use of CCompRef1, 2, 3 ... Bu this is also editable (altough not so clearly visible factors).

Another way is to setup your custom fields and to calculate each factor for each peak eg:

for peak A:
Amount * 5 / 3
Amount * 6 / 3
Amount * 7 / 3

the same for peak B and C.

Then in your report make different tables for peak A, B and C within the report and show only the appropriate custom field.
You can also lock your report.

Or you can make use of the EQ function for example EQ(Name,"Peak A")*amount*5/3 + EQ(Name,"Peak B")*amount * 6/3 .....

Kind regards

Ace