10-14-2014, 11:07 AM | #1 | ||
Torchbearer
Join Date: Sep 2001
Location: On Lake Harriet
|
Math/Excel Help (re: a Poker League)
I am in a poker league.
We are coming down to the end of the season and I'm trying to figure out whether I've clinched a spot at the final table (top 8). I currently sit in 5th place with 90.5 points. The remainder of the top 11 (only ones who can possibly knock me out of the top 8) are as follows: 6. 72 points 7. 71 points 8. 69 points 9. 67 points 10. 65 points 11. 64 points Points are awarded from 1st to 9th place in tournaments as follows: 20-16-12-9-7-5-4-3-2 Two tournaments remain. Other than brute force and trial and error (I can do this), can anyone come up with an excel formula I can use to try to see what the magic number for clinching a top 8 spot is? If it matters (and I don't think it does 4th place has 93 points). |
||
10-14-2014, 11:44 AM | #2 |
Pro Starter
Join Date: Jan 2002
Location: Pittsburgh
|
Highest possible total 9th can reach is 107
Not knowing the tie breaker, you need to finish with 107.5 So you need 17 points over the next two tournaments
__________________
"Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!" |
10-14-2014, 11:50 AM | #3 |
Pro Rookie
Join Date: Aug 2001
Location: Canada eh
|
True, but if 9th does that, the current 8th place team can only finish with a high of 101 (16 points in each tourney), so they'd be the team to get passed so long as digamma can get to 102 points.
I think the answer here is a combination of what's the lowest rated person who could pass him and how the points then spill out above that and how many people would get leapfrogged before digamma would be eliminated. Obviously 17.5 points gets him in, but a much lower number is probably the magic number.
__________________
"I don't want to play golf. When I hit a ball, I want someone else to go chase it." - Rogers Hornsby |
10-14-2014, 11:54 AM | #4 |
Pro Starter
Join Date: Jan 2002
Location: Pittsburgh
|
Good point
Honestly, putting into Excel in my head...You might be better off with the brute force math. You'd need to do an IF for every possible finish combination, 1st thru 9th (10th and 11th don't receive points if I'm reading correctly, so those don't need to be part of the IFs).
__________________
"Do you guys play fast tempos with odd time signatures?" "Yeah" "Cool!!" |
10-14-2014, 11:59 AM | #5 |
Grizzled Veteran
Join Date: Nov 2013
|
Well by adding the highest amounts of points left to the lowest total scores below I get
72 +16+9=97 71+12+16=99 69+9+20=98 67+20+12=99 So it seems to me you need 7 points to clinch.
__________________
"I am God's prophet, and I need an attorney" Last edited by NobodyHere : 10-14-2014 at 12:25 PM. |
10-14-2014, 12:10 PM | #6 |
Registered User
Join Date: Nov 2001
Location: Here
|
If you get no points from the first game, then to still have a chance to jump you:
#10 and 11 need to finish no worse than 5th in the first game. #9 needs to finish no worse worse than 7th in the first game. #8 needs to finish no worse than 9th in the first game. Last edited by Easy Mac : 10-14-2014 at 12:10 PM. |
10-14-2014, 12:10 PM | #7 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Head Coach
Join Date: Dec 2002
Location: Maryland
|
One scenario where 6-9 would pass you:
I don't think it's possible for you to be passed by any more than that (there just aren't enough total points), so I *think* you can focus on four spots. With that in mind, it would be worse for you if those currently in 6-9 all finish in the top 4 in the next two tourneys:
There might be some other way to pack these together more, but I'm not searching for it. I think you need to get to 97 to be absolutely sure. So one 5th place should do it. ETA: what NobodyHere said, essentially. And I guess he did find a way to pack them together more. But yay for your half-point.
__________________
null Last edited by cuervo72 : 10-14-2014 at 12:12 PM. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
10-14-2014, 12:19 PM | #8 | |
Grizzled Veteran
Join Date: Nov 2013
|
Quote:
I ignored the people in 10th and 11th since it seems to me that digamma's worst-case scenario would have the 4 people right behind him grabbing all the top points.
__________________
"I am God's prophet, and I need an attorney" Last edited by NobodyHere : 10-14-2014 at 12:20 PM. |
|
10-14-2014, 12:21 PM | #9 |
College Prospect
Join Date: Jan 2007
Location: TX
|
With 28.5 being the average of the top four scores combined and their average being slightly less than 70, I'd say 98.5 should get you in.
Edit:I know it's a given to get in so I just averaged it, 97.5 is the number I came up with when I was trying to focus on something else.
__________________
I try to open things I probably have no chance of opening. Last edited by TCY Junkie : 10-14-2014 at 01:04 PM. Reason: being anal |
10-14-2014, 01:51 PM | #10 |
Coordinator
Join Date: Oct 2000
Location: Maassluis, Zuid-Holland, Netherlands
|
I agree with TCY Junkie.
The absolute most a non-qualifying 9th ranked person can have equals: the average of 6th through 9th plus average of the top4 scores plus average of the top4 scores. = (72+71+69+67)/4+(20+16+12+9)/4+(20+16+12+9)/4 = 279/4+57/4+57/4 = 69.75+14.25+14.25 = 98.25 That means 98.5 (or even 98.26) should be sufficient.
__________________
* 2005 Golden Scribe winner for best FOF Dynasty about IHOF's Maassluis Merchantmen * Former GM of GEFL's Houston Oilers and WOOF's Curacao Cocktail |
10-14-2014, 02:00 PM | #11 |
Torchbearer
Join Date: Sep 2001
Location: On Lake Harriet
|
Thanks all.
It will be interesting to see what the final 8th place number is. I'm not sure it will be 90 points (there are 28 people in the league and there have been 18 tournaments so far (half online, half in person)). If averages hold, 8th place ends up at 77 or so. |
10-30-2014, 01:47 AM | #12 |
Torchbearer
Join Date: Sep 2001
Location: On Lake Harriet
|
Second to last tournament was tonight. I finished on the points bubble, but had some things break my way.
Going into the last tournament we sit... 5. Me 90.5 points 6. 78 points 7. 77 points 8. 71 points 9. 69 points 10. 69 points So, I'm in for the championship game. Bigger is there are some incentives (actually non-financial) for finishing in the top four. Those are in play for the final game as 4th place is at 93 points. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|