# Foo - Excell formula help

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.

View Full Version : Excell formula help

SD Fixed
02-21-07, 02:11 PM
Accuracy on excel, the following formula is used:

((A2-B2)/A2)*100

Where A2 is the amount of submitted, and B2 is the amount of rejected, the results is the accuracy rate.

Example A2 is 100 submission.
B2 is 1 reject.
The result is 99. So, 99% accuracy.

So, if I wanted to create a formula to determine how much more to add to A2 to keep the accuracy rate above a given point (let's say 97 or 98%).

I'd need help.

So.

Help!

skiahh
02-21-07, 03:07 PM
Wouldn't you want the reject rate to be lower in order to keep your accuracy rate up? Better to have lower rejects than higher overall numbers to allow for more rejects.

I'm not sure how I'd write that one, however. Did you try using the "Solver"?

VegaVixen
02-21-07, 03:29 PM
So, if I wanted to create a formula to determine how much more to add to A2 to keep the accuracy rate above a given point (let's say 97 or 98%).

A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.

02-21-07, 09:42 PM
Better check her work. :D

TRACKMAN
02-21-07, 10:59 PM
A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.
+1 to the nth

SD Fixed
02-22-07, 10:14 AM
Wouldn't you want the reject rate to be lower in order to keep your accuracy rate up? Better to have lower rejects than higher overall numbers to allow for more rejects.

I'm not sure how I'd write that one, however. Did you try using the "Solver"?

Ideally, there would be no rejects. With out going into to much detail, there are provisions being taken to increase it. However, setting the standard at 98%, one method of ensuring they submit quality items is that they understand the ramifications of a reject.. I.E. the rework, the customer end, as well as how much work they'd have to do in order to get back up to a higher over all. Quantity isn't neccisarily the answer, but it is one motivator.

RacerMike
02-22-07, 10:22 AM
NaN

SD Fixed
02-22-07, 11:17 AM
NaN

NAN.. ESMO and DMO... DMO looses to NSIPS. Are pn/dk/ps?

SD Fixed
02-22-07, 11:18 AM
A2 = B2/(1-x), where x=0.97 or 0.98, or whatever level of accuracy you want, but less than 1.

Hmm.. didn't seem to work.