Check out our brand new Local Poker Communities! Get updates and interact with poker players in your area.
Visit the United States Poker Community | Visit the California Poker Community | Read more about the Launch of P5s Local

Calculating percent of field beaten

Reply to Thread
  1. luv4dmb luv4dmb is offline

    South Berwick, ME
    United States

    Posts: 10
    Joined: Nov 07

    Jan 23rd, 2008 (1/23/2008 6:49pm)

    Does anyone have a good formula for excel that will calculate the percent of field beaten in tournaments?

    I thought I had it, and tested with an easy number using a 10 person field, if I finish 5th, the following formula returns 55.5%. Is that right?

    =SUM((I6-J6)/I6)/((I6-1)/I6) assuming I6 is the total field, and J6 is my placement.

    Help!

    Thanks :)
  2. MarkFSU1 MarkFSU1 is offline

    Posts: 3,464
    Joined: Apr 07

    Jan 23rd, 2008 (1/23/2008 6:51pm) in reply to luv4dmb

    I think you can use this:

    1-(place finished/total entrants)

    right?
     
Reply to Thread