Amount Correction
Posted: Thu Mar 17, 2016 9:07 pm
Hello:
I have a calculation where I need to determine a corrected amount after correcting for a blank subtraction.
Currently my amount = Sample Area / (Std. Avg. Area/Std. Wt.)
My corrected amount = (Sample Area - Blank Area) / ((Std. Avg. Area - Blank Area)/Std. Wt.)
Is there any way I can correct the amount by performing some mathematical function on the amount rather than just subtracting the blank areas?
Example: If amount = A, Sample Area = B, Std. Avg. Area = C, Blank Area = D, Std. Wt. = E
My corrected amount formula would be A = (B-D) / ((C-D)/E)
I want to be able to change the formula so the right side of the equation is just B/(C/E). Would this be possible and if so what would the left side of the equation look like?
Thanks!
I have a calculation where I need to determine a corrected amount after correcting for a blank subtraction.
Currently my amount = Sample Area / (Std. Avg. Area/Std. Wt.)
My corrected amount = (Sample Area - Blank Area) / ((Std. Avg. Area - Blank Area)/Std. Wt.)
Is there any way I can correct the amount by performing some mathematical function on the amount rather than just subtracting the blank areas?
Example: If amount = A, Sample Area = B, Std. Avg. Area = C, Blank Area = D, Std. Wt. = E
My corrected amount formula would be A = (B-D) / ((C-D)/E)
I want to be able to change the formula so the right side of the equation is just B/(C/E). Would this be possible and if so what would the left side of the equation look like?
Thanks!