Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Foo Off-Topic chit chat with no general subject.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 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!
SD Fixed is offline   Reply With Quote
Old 02-21-07, 03:07 PM   #2
skiahh
Senior Member
 
skiahh's Avatar
 
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"?
skiahh is offline   Reply With Quote
Old 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)
Tagged: 0 Thread(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.
VegaVixen is offline   Reply With Quote
Old 02-21-07, 09:42 PM   #4
Ritehsedad
Tail End Charlie
 
Ritehsedad's Avatar
 
Join Date: Sep 2005
Location: Maine, The Way Life Should Be
Bikes: Fuji Nevada MTB, Giant OCR1
Posts: 543
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Better check her work.
__________________
Why isn't 11 pronounced onety one?
Ritehsedad is offline   Reply With Quote
Old 02-21-07, 10:59 PM   #5
TRACKMAN
hide not your essence
 
TRACKMAN's Avatar
 
Join Date: Oct 2006
Location: Dodge City
Bikes: Airborne,Guerciotti,Jamis,Merckx,Paris Sport,Raleigh,Vitus
Posts: 155
Mentioned: 0 Post(s)
Tagged: 0 Thread(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
.......\<,
....( )/ ( )...
TRACKMAN is offline   Reply With Quote
Old 02-22-07, 10:14 AM   #6
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)
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.
SD Fixed is offline   Reply With Quote
Old 02-22-07, 10:22 AM   #7
RacerMike
Huge Member
 
RacerMike's Avatar
 
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)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
NaN
__________________
--
Quote:
Originally Posted by BlazingPedals View Post
If you're faster than me, you're fast. If you're not, you suck.
RacerMike is offline   Reply With Quote
Old 02-22-07, 11:17 AM   #8
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)
Quote:
Originally Posted by RacerMike
NaN
NAN.. ESMO and DMO... DMO looses to NSIPS. Are pn/dk/ps?
SD Fixed is offline   Reply With Quote
Old 02-22-07, 11:18 AM   #9
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)
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.
SD Fixed is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 09:32 AM.