Advertise on Bikeforums.net



User Tag List

Results 1 to 9 of 9
  1. #1
    Traffic shark
    Join Date
    May 2001
    Location
    California
    My Bikes
    2 fixies, 1 road, 29er in the works.
    Posts
    4,612
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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!
    Regards,
    William
    For the SD Crowd

    sdbikecommuter.com

    View from the handle bars:
    sdcyclist.blogspot.com

  2. #2
    Senior Member skiahh's Avatar
    Join Date
    Aug 2003
    Location
    CO Springs, CO
    My Bikes
    08 Stumpjumper FSR Expert, 02 Litespeed Tuscany, 04 Specialized S-Works Epic
    Posts
    1,034
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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"?
    www.teamnavycycling.org
    2010 Pivot Mach 429
    09 Felt Nine Race
    03 Litespeed Tuscany

  3. #3
    Senior Member
    Join Date
    Nov 2006
    Location
    Charlotte, North Carolina, USA
    My 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)
    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.

  4. #4
    Tail End Charlie Ritehsedad's Avatar
    Join Date
    Sep 2005
    Location
    Maine, The Way Life Should Be
    My Bikes
    Fuji Nevada MTB, Giant OCR1
    Posts
    545
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Better check her work.
    Why isn't 11 pronounced onety one?

  5. #5
    hide not your essence TRACKMAN's Avatar
    Join Date
    Oct 2006
    Location
    Dodge City
    My Bikes
    Airborne,Guerciotti,Jamis,Merckx,Paris Sport,Raleigh,Vitus
    Posts
    155
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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
    .......\<,
    ....( )/ ( )...

  6. #6
    Traffic shark
    Join Date
    May 2001
    Location
    California
    My Bikes
    2 fixies, 1 road, 29er in the works.
    Posts
    4,612
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.
    Regards,
    William
    For the SD Crowd

    sdbikecommuter.com

    View from the handle bars:
    sdcyclist.blogspot.com

  7. #7
    Huge Member RacerMike's Avatar
    Join Date
    May 2005
    Location
    Ittybittycity, MD
    My Bikes
    2009 BMC Team Machine, Pedal Force RS2, Salsa Campeon, Jamis Nova, Trek 7000
    Posts
    636
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    NaN
    --
    Quote Originally Posted by BlazingPedals View Post
    If you're faster than me, you're fast. If you're not, you suck.

  8. #8
    Traffic shark
    Join Date
    May 2001
    Location
    California
    My Bikes
    2 fixies, 1 road, 29er in the works.
    Posts
    4,612
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by RacerMike
    NaN
    NAN.. ESMO and DMO... DMO looses to NSIPS. Are pn/dk/ps?
    Regards,
    William
    For the SD Crowd

    sdbikecommuter.com

    View from the handle bars:
    sdcyclist.blogspot.com

  9. #9
    Traffic shark
    Join Date
    May 2001
    Location
    California
    My Bikes
    2 fixies, 1 road, 29er in the works.
    Posts
    4,612
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(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.
    Regards,
    William
    For the SD Crowd

    sdbikecommuter.com

    View from the handle bars:
    sdcyclist.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •