Excel Spreadsheet Help

saterob

Member
Hey,

I have a weekly Poker group and I made a spreadsheet for it to keep track of all the satistics. Iv managed to make a worksheet for each season and then I thought wouldnt it be cool to have an 'overall' worksheet to show the overall standings - sorta like a league table ladder.

Here are the things I want:

1# In each of the seasons, in the ranking ladder, I need a tiebreaker like rebuys to break ties. Because when there is a tie, it glitches and it shows my name twice.

2#In each players profile in each season, under the average placing column, in the average, I need a formula that doesnt count the 0s, because if someone doesnt show up, there will be a zero, and the current formula counts that 0 as a placing. It saves me manually having to exclude the 0s from everyone's average at the end of each season.

3#If you open the overall tab, you will see the overall standings ladder. That is the beast I am hoping to get up and running with your help. I want it cover all the stats across every season automatically. So when a new seasonis made, it will track it auto, when a new player is added, it will track it auto. The primary column will be score obviously, then for tie breakers use re-buys again. In this table Score refers to Profit in the player profiles,1st, 2nd 3rd refers to how many time each player has finished 1st 2nd or 3rd all together, Average placing refers to the average placing column in the players profile, Prize Money refers to the gross column in the player profiles, Minor premiership refers to how many times a player has come first in a season, Major premiership refers to how many times a player wins a BOC (battle of the champions) which is a season finale only top 6 can qualify for, BOC app (battle of the champions appearances) refers to how many times a player qualifies for the final, rake refers to how much rake (house fee) a player has payed all up (note: since I am the host, I collect rake whilst everyone else pays it), Rake is just money to cover for the food and drink i supply each night and is not for profiteering, ITN (In The Money) refers to the percentage of how many times a player finishes in the money (note: in Season 1, Week B only top 2 got paid and in all BOCS, its winner takes all, otherwise top 3 always get paid), Net refers to the net column in the player profiles which is a true representation of how money one has made because it include the rake fees (net is not used for rankings because of bias reasons, since I collect rake and everyone else pays it).

Cheers,
Jordan.
 

My Computer

Back
Top