How create the custom fields formula ?

I would like to create a custom field to calculate the assay of two API in the same analysis, can someone help me? 
if I write you the formula, can you help me create a formula step by step?



  • Whats the formula? There are several custom field options for assay so I'm sure there is a way to do this.
  • are CF required here ? can assay of 2 APIs not been completed in processing method with dilutions, purity component table ?
  • These are the formula: 1 = (area sample average 2 replicates* weight std * purity std in % * 100)/(area std average 6 replicates * 50000*0,05).

    2= (area sample average 2 replicates* weight std * purity std in % * 100)/(area std average 6 replicates * 20000*0,20).

    How Can i create the custom fields formula?
    The chromatogram is the same for Boh API .
    Can Young help me ?
    Many thanks
  • Can someone help me?
  • You need to use the component editor to enter you standard amounts. You need to use the sample weights and dilutions field within the sample set method to accommodate your standard weight and dilutions.

    Empower will then calculate the concentration of your analytes in the amount field.

    To average the two replicates you can most easily generate an average by using the same sample label in the sample set for replicate one and two. You can then setup a report to group samples by label and give you an average for each group.

    If you want to use the average value for a calculation down stream, then you will need the following custom field:


  • Many thanks,
    But if i have two api in the same analysis and in the same chromatogram, How can i use sample weight and dilution etc.? I ma obliged To ceate A formula in the empower project.

  • First row - Values for API1
    Second row - Values for API2

  • Can you describe me step by step?
  • @egio : What are you getting stuck on exactly?  Can you also describe where the 50,000, 0.05, 20,000 and 0.20 come from in those two formulas?  Are those related to the dilution schemes of the two different APIs, and if so, what is your typical prep (e.g. 20 mg/100 mL, diluted 1 mL in 50 mL)?  Also in your original formula, why the *100 if your purity is already in % (like 99.2% purity value used) that for unit conversion of some sort?
  • egio said:
    Can you describe me step by step?
    In the Processing Method (PM), you enter names and retention times for both APIs. Pull APIs into Component editor in Sample Set Method editor by clicking on the PM button (the left hand of the 2 buttons w/ yellow on them) once you open the Component editor (Amounts button). Both components will show up. Enter concentrations, purity, etc. for each (taking into account their dilutions makes it all a bit simpler). Do the couple of clicks so you can see samples as well. Enter your Label Claim values for each component there. Enter Sample dilutions in the first table. Process and you should be there.
  • Many thanks, I managed to do It. Now i would like To perform the calculation on empower with bracketing .I have the following sequence ;
    6inj. Std 1 (S1)
    2 inj. Sample 1
    2 inj. Sample 2
    2 inj. Std 2 (S2)
    I would like To calculate the samples With the avearage of the standards before S1and after the samples S2 .
    Can you describe step by step ?
    Many thanks 

  • In sample set, add a "Clear Calibration" line before the Std1 line. Label the 6 injections of Std1 as S0101, label the 2 injections of Std2 as S0102. Label the Samples 1 and 2 as U1 U2 U3 and U4. After the std2 line, insert a Clear Calibration, then Calibrate (making sure the label Reference on the Calibrate line is set to S01* then Quantitate with the Label Reference on Quantitate set to U*). In the component editor of your sample set make sure you have the amounts or concentrations entered in the Value tab for all standard components. Save all changes, bring the standard/sample channels into review, open processing method, and for the standard injections press integrate then calibrate, which builds your calibration curve. File>Save as Calibration to save curves. Then for your sample injections press integrate then quantitate and your amounts will appear.

    Or you can batch process a sample set to generate a result set. Right click sample set, process, use specified processing method, select the method, make sure clear calibration is ticked then click ok- your result set will be generated with amounts stored. Make sure to account for any dilution factors or sampleweights for your samples before saving sample set.

  • How come you add Clear Calibration before STD1?
  • If you do not do this, and do not check that box when processing, previous standards used with the processing method will be included in your calibration curve.
  • The confusing thing about clear calibration though is it only kicks in when a sample set is batch processed or a set of injections/channels are batch processed. That's the usual procedure in our company. When you review raw data using a processing method and cycle through the injections, any standards of different strengths will construct a nonsense calibration curve and hence inaccurate amounts. The only way around it that I know of is to first select the standards which are relevant then the associated results (unknowns). Then select Edit < Clear Calibration and repeat the next selection of your standards/samples. 

    Clear Calibration in the sample set as an added line only "kicks in" during live, line by line processing during batch processing. 
  • I am sorry but i have another question on calculation empower with bracketing. 
    In addition to compiling the sample set as you described me, do I also have to enter a precise formula in the custom fields?
    Can i send you an example to Understand if i have Compiled The sample set well?
  • Hi, yes send on an example of what you are looking for so its more clear. Thanks. 
  • Hi , I send you an example.
    I will want to calculate the assay on sample called Beg with bracketing between std1 before and after the sample. Do i have to enter a formula in the custom fields? I only enter amount, diluition and sample weight. Many thanks .

  • I would like to create a new custom fields that has the same funcionality as the diluition field or that multiplies the field "amount". How can i do?
  • What do you need to multiply amount by? If its a number you create a peak real calculated cf such as Amount*10  or whatever the number is. If its a variable number then you could put it into CConst1 of the processing method then change the formula to Amount*CConst1.
  • I don't want to create a formula inside the custom field but I just want a field that is shown in the sample set which has the function of multiplying the amount. It is a variable number.  Many thanks 
  • You need another field to multiply the amount, I suggest a component custom field called Factor- enter your variable number for standards and unknowns in the component editor and then a second custom field called Corrected_Area coded as Amount*Factor. When amount is calculated, multipliers only exist when standard amounts are calculated by multiplying the Value by Sampleweight and then for unknowns, when amount is calculated, the Value is multiplied against Dilution. 

    If you want the calculated amount multiplied by a variable number you need a custom field. 
  • Do i have To create The second custom fields As a component? 
  • Another question....can i block the custom fields dilution with a constant value without Another user Being abel To modify it? I ' sorry for all These questione. Many thanks
  • No, the second custom field (call it Corrected_Area) is a Peak, Real, Calculated CF. Pick Result Set Only in the wizard as this is the most common scenario. Then the formula is Area*Factor. Put the variable value against your component(s) in the Factor custom field in the component editor- make sure to pick the "Standards and Unknowns" view to select all the unknowns- the Standards Only is the default view. 

    You cant block the Dilution field, only hide it. Why do you need to block it? You put the dilution value in the sample set, run the samples and if there is a dilution error, simply change it through "Alter Sample" before processing. 
  • I need to block dilution to not let Other users change The number. I would like to create a new sample set with a numeric value on dilution that Cannot be' changed.

  • I still dont see why you care that others may change the number? Do you have people working with you that alter results or may do something dodgy when processing? If you have full audit trail enabled then every action that a user takes is stamped in the Audit Trail so any changes in any field like Dilution is easily traceable. Dilution is entered to account for the concentration of a sample so if this value is changed, then the result wont be correct, surely this is obvious when reviewing results?

    I dont think you can lock individual fields in a sample set. I know you can lock processing methods to prevent any changes so if you wanted to add your number in the CConst1 field of the processing method then lock the Processing Method but this would prevent any integration changes so its very limiting. 
  • Hi everyone,
    i need your help.
    I would like to know how i can calculate the recovery % between std1 and std2 if i have two analytes to calculate. I need to know what i have to set in the Samp le set to calculate the recovery % in the presence of two active ingredients.
    using the sample weight, dilution field and entering the sample function field in reference to std2 in the sample set, i can calculate but only for one analyte.
    can you help me?
    many thanks.
  • What is the exact formula for % recovery and how many injections of Std1 and Std 2 are there? Is the formula (Difference in Area between Std 1 and Std2 divided by Mean of Area in Std1 and Std2) *100?
  • many thanks,
    the formula is the following:
    (area std1/area std2 )*(weight std2/weight std1 )*100
    i have six injections for std1 and two injections standard 2.

Sign In or Register to comment.