custom field in EMPOWER3 for acceptance value

Discussions about chromatography data systems, LIMS, controllers, computer issues and related topics.

8 posts Page 1 of 1
Does any one know how create a custom field to calculate content uniformity( Acceptance value) .
Please give me details about the formula and the parameters of the CF .
THANKS
I would imagine its very easy to calculate what you are looking for but we need more information, how is content uniformity calculated in your lab, whats the formula? And whats the acceptance criteria in your specification eg content uniformity needs to be between 98-102%.
Hana81 wrote:
Does any one know how create a custom field to calculate content uniformity( Acceptance value) .
Please give me details about the formula and the parameters of the CF .
THANKS

Do You mean assay till 98.5, 98.5 to 101.5 and up to 101.5 per cent?
for K 2.4 (10 tablets) and K 2.0 30 tablets?
YES i mean
M=X̅ if  98.5%≤ X̅≥101.5%
M= 98.5% if X̅<98.5%
M= 101.5% if X̅>101.5%
for 10 tablets
Hi Hana81,

There is a way for Empower to do this using several custom fields and its explained from the Waters Informatics 2018 show, its too long to explain here so I will attach the guide via PM. Please be aware though that there are a LOT of custom fields required for it to work but if its done correctly it should save loads of time.
EmpowersBane wrote:
Hi Hana81,

There is a way for Empower to do this using several custom fields and its explained from the Waters Informatics 2018 show, its too long to explain here so I will attach the guide via PM. Please be aware though that there are a LOT of custom fields required for it to work but if its done correctly it should save loads of time.


Please remember that long costum field calculation formula take more time to calculate result. We made this formula in our company, but calculation for 10 tablets, deviation from 2 standards ect can take till 5 minutes processing.
Yes that's very true, but its still probably quicker than transcribing data into Excel.

Im afraid I cant attach the document. Look up Waters Informatics 2018 and the article Content Uniformity to see it.
as seen in Waters forums:
Here's how I've handled it-
USP_AV: ABS(-1*Ave_PercentClaim+M)+k*SD
L2Range: GTE(PercentClaim,(0.75*M))&LTE(PercentClaim,(1.25*M))
this is a calculated boolean where 0 translates to Outside L2 (25) Range and 1 translates to Within L2 (25) Range (so it's telling you whether there's any point to trying 20 more units if AV>15)
M: GT(AVE_PercentClaim,101.5)*101.5+LT(AVE_PercentClaim,98.5)*98.5+RANGE(AVE_PercentClaim, 98.5, 101.5)*AVE_PercentClaim
SD: SAME.%..%RSD(PercentClaim)*Ave_PercentClaim/100
k: boolean function that defaults to 0 (which translates to 2.4, and 1 translates to 2)

I'll assume users of this will already have appropriate dependent CFs corresponding to PercentClaim, AVE_PercentClaim etc.
Thanks,
DR
Image
8 posts Page 1 of 1

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 1117 on Mon Jan 31, 2022 2:50 pm

Users browsing this forum: No registered users and 1 guest

Latest Blog Posts from Separation Science

Separation Science offers free learning from the experts covering methods, applications, webinars, eSeminars, videos, tutorials for users of liquid chromatography, gas chromatography, mass spectrometry, sample preparation and related analytical techniques.

Subscribe to our eNewsletter with daily, weekly or monthly updates: Food & Beverage, Environmental, (Bio)Pharmaceutical, Bioclinical, Liquid Chromatography, Gas Chromatography and Mass Spectrometry.

Liquid Chromatography

Gas Chromatography

Mass Spectrometry