Hi Guys,
I have recently been put in charge of maintaining the leader board for our poker league. For the past 8 months data has updated manually after being calculated first.
I have been trying to come up with a better way but I can’t seem to make my formula’s work for me.
Currently the way that the point’s structure works
1 place: 100 + # of registered players
2 place: 80 + # of registered players
3 place: 60 + # of registered players
4 place: 50 + # of registered players
5 place 40 + # of registered players
6 place 35 + # of registered players
7 place 30 + # of registered players
8 place 25 + # of registered players
9 Place 20 + # of registered players
10– 16 ½ the # of registered players
>17 gets 10
The issue I am having is that the # of players per game differs. The season runs for 12 weeks currently with 9 games a week.
Currently on one sheet this is how the table is set up
[TABLE="width: 454, align: center"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Points[/TD]
[TD]Games[/TD]
[TD]Final Tables[/TD]
[TD]Wins[/TD]
[TD]Chip Count[/TD]
[TD]Money[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2816[/TD]
[TD]57[/TD]
[TD]29[/TD]
[TD]7[/TD]
[TD]281600[/TD]
[TD]$2,030.00[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2227[/TD]
[TD]59[/TD]
[TD]23[/TD]
[TD]2[/TD]
[TD]222700[/TD]
[TD]$785.00[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2082[/TD]
[TD]42[/TD]
[TD]23[/TD]
[TD]3[/TD]
[TD]208200[/TD]
[TD]$1,370.00[/TD]
[/TR]
</tbody>[/TABLE]
(The only column that has a formula is the chip count =( # of points x 100) )
Now the next problem I am having is, my boss wants along with the overall leader board, which is the current one we use, he wants there to be a separate leader board for:
I honestly just don’t know how I can make it work in excel. So if anyone has ideas, suggestions or formula’s that could help, I would really appreciate it
Kind regards
Jade
I have recently been put in charge of maintaining the leader board for our poker league. For the past 8 months data has updated manually after being calculated first.
I have been trying to come up with a better way but I can’t seem to make my formula’s work for me.
Currently the way that the point’s structure works
1 place: 100 + # of registered players
2 place: 80 + # of registered players
3 place: 60 + # of registered players
4 place: 50 + # of registered players
5 place 40 + # of registered players
6 place 35 + # of registered players
7 place 30 + # of registered players
8 place 25 + # of registered players
9 Place 20 + # of registered players
10– 16 ½ the # of registered players
>17 gets 10
The issue I am having is that the # of players per game differs. The season runs for 12 weeks currently with 9 games a week.
Currently on one sheet this is how the table is set up
[TABLE="width: 454, align: center"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]Points[/TD]
[TD]Games[/TD]
[TD]Final Tables[/TD]
[TD]Wins[/TD]
[TD]Chip Count[/TD]
[TD]Money[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2816[/TD]
[TD]57[/TD]
[TD]29[/TD]
[TD]7[/TD]
[TD]281600[/TD]
[TD]$2,030.00[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2227[/TD]
[TD]59[/TD]
[TD]23[/TD]
[TD]2[/TD]
[TD]222700[/TD]
[TD]$785.00[/TD]
[/TR]
[TR]
[TD]Player
[/TD]
[TD]2082[/TD]
[TD]42[/TD]
[TD]23[/TD]
[TD]3[/TD]
[TD]208200[/TD]
[TD]$1,370.00[/TD]
[/TR]
</tbody>[/TABLE]
(The only column that has a formula is the chip count =( # of points x 100) )
Now the next problem I am having is, my boss wants along with the overall leader board, which is the current one we use, he wants there to be a separate leader board for:
- each venue that runs a game (overall)
- each night that a game is run. However there is 1 game on Tuesday at venue 1. 1 game at venues 2 & 3 on Wednesday. 1 game at venue 1 on Thursday. 1 game at venue’s 1 & 3. And on Sunday 2 games at venue 1.
I honestly just don’t know how I can make it work in excel. So if anyone has ideas, suggestions or formula’s that could help, I would really appreciate it
Kind regards
Jade
