CF calculated

PMJ

Hi everyone.
I am working on a peak boolean calaculated to get whether the resolution between two peaks is => 1.5
How do I have to create the custom field??

Thanks

Empower2019

Create a peak, bool custom field. Search order Result Set First, peak and sample type All. Pick Use as Position and your formula is GTE(Resolution,1.5) and in the translation box, 0 is No and 1 is Yes, you can edit this to suit your needs for example. 1 = Acceptable Resolution and 0 = Unacceptable Resolution. If you only want it calculated for one particular peak, select this peak in CCalRef1 or CCompRef1 of processing method and then the formula is GTE(CCalRef1[Resolution],1.5) 

PMJ

And what if the resolution is 1.45 it will be 1.5 with only one decimal so for me would be correct. I need to consider that value as well.
In that case GTE(Resolution,1.5) it will not be enough

Empower2019

You can round to the desired decimal within the formula, so if you want to include all values of 1.45 onwards, amend the formula to..
GTE(ROUND(Resolution,-1),1.5)

PMJ

What does that -1 mean??

Empower2019

Rounding to one decimal place. 0 is rounding to a whole number and 1 is rounding to one positive position past zero.-1 means rounding to one decimal point.

PMJ

THANKS!!

PMJ

And what if we want to get a CF to get whether a peak has EP Plate Count ≥ 6000? How do we have to create the CF?
We have to consider that a value of 5999.5 will be rounded to 6000 so it will has EP Plate Count ≥ 6000

Jovvor

Hey PMJ,

Same principle as Empower2019 has explained in the first answer but than switch your calculation to GTE(ROUND(EP Plate Count,0),6000)

This will calculate the pass/fail result for every peak in your chromatogram, depending on your sample type in the custom field.

If you want a specific peak you could use a few options

GTE(ROUND(CCalRef1[EP Plate Count],0),6000) with the peak of interest in the CCalRef1 defined
GTE(ROUND(CCompRef1[EP Plate Count],0),6000)  with the peak of interests in the CCompRef1 defined

However you could switch them up in the table and you will get results based on the CCompRef1 defined peak for a different component. So CCompRef only to use if you have multiple peaks and remember to set them the same order as the name in that tab.

Or you could name the peak for example: Paracetamol

GTE(ROUND("Paracetamol"[EP Plate Count],0),6000)
Remember to use "" before and after the peak name.

Kind regards

PMJ

OK Great thanks!!!!

PMJ

Sorry for bothering again

And what if we want to get a CF to get whether a peak has EP Plate Count ≥ 6000.27? How do we have to create the CF to get that rounded to two decimals?
-1 means 1 decimal point
What about two decimal points?

Empower2019

I would strongly recommend you use the CConst1-7/CCalRef1 options in your CFs as it allows for changing the specification value without changing the CF each time. 
Create a peak, bool CF, use as position (if this is what you require) and the formula is GTE(ROUND(EP Plate Count,-2),CConst1)
This CF will calculate a value for EP Plate Count for each peak and look at its value to 2 decimal places (the -2 in formula) and compare it to the value set against the peak or peaks in CConst1 of your processing method. So if your peak is Soft Drink then put a value of 6000.27 in the CConst1 cell against the Soft Drink peak.

If you want this CF to calculate both known and unknown peaks, then you will need to set a peak as CCalRef1 and in the CConst1 field for that peak put in 6000.27. Then all peaks will be calculated using that value as its spec. Only CCalRef1 will work for all peaks (known and unknown). CCompRef1-3 is only specifically for the known peaks in those cells. In that case the formula would change to 
GTE(ROUND(EP Plate Count,-2),CCalRef1[CConst1])
It all depends on your requirements for this calculation. 

PMJ

Perfect!! Thanks again!!