Empower Custom Fields - Average of Two Samples
Posted: Mon Dec 10, 2018 3:45 pm
Hello everyone. I have a (hopefully) quick question about creating a custom field in Empower to take an average of two sample results.
In my lab, we prepare duplicate preparations of each sample and then average the results. The challenge that I'm facing is that I want to include our detection/quantitation thresholds. I understand how to do this for individual samples, displaying ND or <LOQ for certain impurities, but that transforms results into strings and makes it impossible to do an average in the Empower Report.
I think that I'll need to use intersample calculations in order to achieve this, but to be honest I'm a little unsure of how they work. I'll put what my goal is in certain instances, what my best guess is for getting that to happen, and hopefully someone else can help me figure out how to accomplish it in Empower.
Points 2 and 3 could possibly be combined into one if I could do something like the following:
AvgResult = (Rep1Result*Boolean1 + Rep2Result*Boolean2)/(Boolean1 + Boolean2)
Where the Boolean is testing whether the result is >0.05.
So the thing I'm having trouble with is figuring out how to make this sort of comparison. Like I said, I think I have to utilize intersample calculations somehow.
Any thoughts?
In my lab, we prepare duplicate preparations of each sample and then average the results. The challenge that I'm facing is that I want to include our detection/quantitation thresholds. I understand how to do this for individual samples, displaying ND or <LOQ for certain impurities, but that transforms results into strings and makes it impossible to do an average in the Empower Report.
I think that I'll need to use intersample calculations in order to achieve this, but to be honest I'm a little unsure of how they work. I'll put what my goal is in certain instances, what my best guess is for getting that to happen, and hopefully someone else can help me figure out how to accomplish it in Empower.
- If at least one result is ND and neither result is >ND, print ND
- If at least one result is <LOQ and neither result is >LOQ, print <LOQ
- If one result is >LOQ and the other is not, print the result that is >LOQ
- If both results are >LOQ, print the average of the results
Points 2 and 3 could possibly be combined into one if I could do something like the following:
AvgResult = (Rep1Result*Boolean1 + Rep2Result*Boolean2)/(Boolean1 + Boolean2)
Where the Boolean is testing whether the result is >0.05.
So the thing I'm having trouble with is figuring out how to make this sort of comparison. Like I said, I think I have to utilize intersample calculations somehow.
Any thoughts?