Poker Leaderboard: help requried with fomula improvment

[PPoker]

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

Name	Points	Games	Final Tables	Wins	Chip Count	Money
Player	2816	57	29	7	281600	$2,030.00
Player	2227	59	23	2	222700	$785.00
Player	2082	42	23	3	208200	$1,370.00

<tbody>
</tbody>

(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:

1. each venue that runs a game (overall)
2. 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

 

[PPoker]

Hey guys, I thought maybe I could just use 3 spreadsheets over all and copy a sheet of the nightly games if need be.