Page 1 of 1
custom field in EMPOWER3 for acceptance value
Posted: Wed Apr 24, 2019 3:58 pm
by Hana81
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
Re: custom field in EMPOWER3 for acceptance value
Posted: Thu Apr 25, 2019 8:28 pm
by EmpowersBane
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%.
Re: custom field in EMPOWER3 for acceptance value
Posted: Fri Apr 26, 2019 10:03 am
by Kris_Markovs
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?
Re: custom field in EMPOWER3 for acceptance value
Posted: Fri Apr 26, 2019 10:24 am
by Hana81
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
Re: custom field in EMPOWER3 for acceptance value
Posted: Fri Apr 26, 2019 10:36 am
by EmpowersBane
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.
Re: custom field in EMPOWER3 for acceptance value
Posted: Fri Apr 26, 2019 10:52 am
by Kris_Markovs
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.
Re: custom field in EMPOWER3 for acceptance value
Posted: Fri Apr 26, 2019 2:09 pm
by EmpowersBane
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.
Re: custom field in EMPOWER3 for acceptance value
Posted: Mon May 13, 2019 5:13 pm
by DR
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))<E(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.