Page 1 of 1
Percent Difference Custom Field
Posted: Sun Jul 30, 2017 9:23 am
by EmpowersBane
I know you can create a custom field to get the AVERAGE area over 2 injections of a sample but is it possible to create one that calculates the difference between the area of 2 injections?
I have a standard that is injected twice after my samples and my criteria is the % Difference cant be more that 2%. Any ideas?
Re: Percent Difference Custom Field
Posted: Sun Jul 30, 2017 6:15 pm
by mattmullaney
Hi EmpowersBane,
Yes, there has to be a way to do this via InterSample Calculation. One of these days (or weeks, I guess) I really need to re-learn what I used to know and learn a heck of a lot more about Custom Calculations. So much horsepower I (or any Empower user) has that goes mostly to waste. I hope someone has an answer. There's a company in Berlin, Germany, Beyontics. They sell a Really Nice Empower manual (slanted to Empower 3) as well as one for Custom Calculations alone...I know the former one as I've purchased it. Maybe the Custom Calcs one is worth looking into? I'd do it myself...my personal funds are low now, sadly.

Re: Percent Difference Custom Field
Posted: Sun Jul 30, 2017 8:38 pm
by EmpowersBane
Thanks for the reply mattmullaney,
Is the Empower book from Beyontics worth purchasing? Do they cover the usual like report methods, changes from Empower 2 and running samples etc? I know what you mean about forgetting. I think its something like Highest Area (from the 2 injs) divided by Lowest Area x 100 -100 to get the percent but I'm not sure do I put it in CCalRef or CCompRef!
Re: Percent Difference Custom Field
Posted: Mon Jul 31, 2017 2:28 am
by mattmullaney
Hi EmpowersBane,
For me, yes, it was absolutely a worthwhile purchase. My copy of the book is at work at the moment...I will respond again with a list of the table of contents. This will help you see what is inside a bit, I think.
Unfortunately, I don't think that a direct answer to the question you're asking is in the text that I have--maybe it would be present in the other text Beyontics sells...or certainly in the one-day course Waters offers. No one seems to have money to go to the training these days. Waters does have some online courses, these may be too brief in nature to really help.
Re: Percent Difference Custom Field
Posted: Mon Jul 31, 2017 2:30 am
by DR
I think it's already in there. When you review your standard curve, there's a deviation column. I think that's all you may need - current std deviation from running average (confirm the math on this). You may need to multiply by 10 to make a % of it.
Re: Percent Difference Custom Field
Posted: Mon Jul 31, 2017 3:18 pm
by EmpowersBane
Ah thanks Ill double check the maths on that one. I saw a very long custom field for this on one of the training websites but it was almost like an IF function in Excel and gave 2 scenarios depending on if the area of the first injection was larger than the second.
Is it possible to create a custom field multiplying the std deviation by 10 and throw it into a report method?
Re: Percent Difference Custom Field
Posted: Tue Aug 01, 2017 7:19 am
by ydna1977
Hi ,
Worth trying multiple of 10
Try this is a custom field
Field type : Peak
Type : Real (0,0)
Area Ratio = (Area/CCompRef2(Area))*(CConst1/Cconst2)
Re: Percent Difference Custom Field
Posted: Tue Aug 01, 2017 8:27 pm
by EmpowersBane
For people who know more, I checked online and they suggested the following custom filed for calculating the percentage difference between area over 2 injections, bearing in mind the first area may be lower than the second.
Does this look right:
% Diff = Highest Area/Lowest Area *100 - 100.
Custom Field:
GT((.1.(CCompRef1[Area])),(.2.(CCompRef1[Area])))*((.1.((CCompRef1[Area]))/.2.(CCompRef1[Area])*100)-100)+ GT((.2.(CCompRef1[Area])),(.1.(CCompRef1[Area]))) *((.2.((CCompRef1[Area]))/.1.(CCompRef1[Area])*100)-100)
Re: Percent Difference Custom Field
Posted: Wed Aug 02, 2017 10:21 am
by ydna1977
Hi ,
Maybe a long-wided way of doing this but if it works..all good
Could you also simplify by using ABS function ?
Re: Percent Difference Custom Field
Posted: Thu Aug 03, 2017 11:29 am
by mattmullaney
Hi EmpowersBane,
My apology for interrupting; I am late to respond, good to see that folks are suggesting solutions. For the Beyontics book I have, "Empower 3, A Compact User's Guide," here is what is inside. Note, this is for Feature Release 2 (FR2), from 2015.
Intro
Editions and Network Architecture
QuickStart Interface
Project Window
Data Acquisition
Data Processing
Reports
Data Import and Export
Configuration Manager
Custom Fields
Overall the book is very good for a beginner or as a refresher...and a pretty fair reference, I'd think, for a moderately experienced user. Beyontics sells a separate text on the Custom Fields...this you may be interested in. Beyontics is in Berlin, Germany. I like the book I have a lot.
Re: Percent Difference Custom Field
Posted: Thu Aug 03, 2017 4:07 pm
by EmpowersBane
Thanks a million for that mattmulaney I really appreciate that. That manual sounds like a fantastic guide/refresher for Empower 3, particularly when its laid out in logical order like that. I looked into Beyontics and yes,I saw the custom field book they offer, which might be worth getting as well because there is so much to it you could nearly do a masters on it!
Thanks again for the information.

Re: Percent Difference Custom Field
Posted: Thu Aug 03, 2017 11:51 pm
by mattmullaney
I like the book I have...just no funds for the Custom Fields book.
Re: Percent Difference Custom Field
Posted: Mon Aug 07, 2017 8:09 am
by ydna1977
Hi ,
I have both books mentioned
Very useful as reference and custom fields manual I would recommend
Re: Percent Difference Custom Field
Posted: Mon Aug 07, 2017 8:18 am
by mattmullaney
@ ydna1977,
I will continue to save my money for the purchase of the Custom Fields text. My thanks for your endorsement!