Bike Forums > Foo > Excell formula help
 Register All Albums Elite Membership Forum Rules Calendar Search Today's Posts Mark Forums Read

 Foo Off-Topic chit chat with no general subject.

 02-21-07, 02:11 PM #1 SD Fixed Traffic shark Thread Starter   Join Date: May 2001 Location: California Bikes: 2 fixies, 1 road, 29er in the works. Posts: 4,612 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 2 Post(s) Excell formula help 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!
 02-21-07, 03:07 PM #2 skiahh Senior Member     Join Date: Aug 2003 Location: CO Springs, CO Bikes: 08 Stumpjumper FSR Expert, 02 Litespeed Tuscany, 04 Specialized S-Works Epic Posts: 1,035 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 0 Post(s) 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"?
02-21-07, 03:29 PM   #3
VegaVixen
Senior Member

Join Date: Nov 2006
Location: Charlotte, North Carolina, USA
Bikes: '71 Raleigh Sports, '84 Schwinn LeTour on the trainer (and available for hill repeats), '06 Scott CR1 SL (Ksyrium SL), and a yet-to-be-determined TT bike.
Posts: 1,643
Mentioned: 0 Post(s)
Quoted: 0 Post(s)
Quote:
 Originally Posted by William Karsten 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 #4 Ritehsedad Tail End Charlie     Join Date: Sep 2005 Location: Maine, The Way Life Should Be Bikes: Fuji Nevada MTB, Giant OCR1 Posts: 545 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 0 Post(s) Better check her work. __________________ Why isn't 11 pronounced onety one?
02-21-07, 10:59 PM   #5
TRACKMAN

Join Date: Oct 2006
Location: Dodge City
Bikes: Airborne,Guerciotti,Jamis,Merckx,Paris Sport,Raleigh,Vitus
Posts: 155
Mentioned: 0 Post(s)
Quoted: 0 Post(s)
now theres a real sharp woman ;0)

Quote:
 Originally Posted by VegaVixen 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
__________________
May you find the joy and peace you long for.
Life is a journey ... NOT a guided tour.
.......__O
.......\<,
....( )/ ( )...

02-22-07, 10:14 AM   #6
SD Fixed
Traffic shark

Join Date: May 2001
Location: California
Bikes: 2 fixies, 1 road, 29er in the works.
Posts: 4,612
Mentioned: 0 Post(s)
Quoted: 2 Post(s)
Quote:
 Originally Posted by skiahh 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.

02-22-07, 10:22 AM   #7
RacerMike
Huge Member

Join Date: May 2005
Location: Ittybittycity, MD
Bikes: 2009 BMC Team Machine, Pedal Force RS2, Salsa Campeon, Jamis Nova, Trek 7000
Posts: 636
Mentioned: 0 Post(s)
Quoted: 0 Post(s)
NaN
__________________
--
Quote:
 Originally Posted by BlazingPedals If you're faster than me, you're fast. If you're not, you suck.

02-22-07, 11:17 AM   #8
SD Fixed
Traffic shark

Join Date: May 2001
Location: California
Bikes: 2 fixies, 1 road, 29er in the works.
Posts: 4,612
Mentioned: 0 Post(s)
Quoted: 2 Post(s)
Quote:
 Originally Posted by RacerMike NaN
NAN.. ESMO and DMO... DMO looses to NSIPS. Are pn/dk/ps?

02-22-07, 11:18 AM   #9
SD Fixed
Traffic shark

Join Date: May 2001
Location: California
Bikes: 2 fixies, 1 road, 29er in the works.
Posts: 4,612
Mentioned: 0 Post(s)
Quoted: 2 Post(s)
Quote:
 Originally Posted by VegaVixen 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.