Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ccarpol

Pages: [1]
1
Help Me / Re: Ranking players
« on: November 10, 2006, 09:28:31 AM »
In my league, which runs for several months, the players are all ranked according to their current point totals(a collection of ALL their tournament points, not just one tournament).  The more points you have, the higher you are ranked.  When I export that stats, players that have the same number of points should receive the same ranking.  This does not occur however.  Example: If two players are tied for 25th place(same amount of points) the first of the two is ranked in 25th place and the second is ranked in 26th place.  Can this be fixed, other than manually, to make both players ranked in 25th place?  Then the next player would be ranked in 27th place(since there are two tied at 25th).  The only stats we post in my league are rank(players position according to points), name, and total points.  The more new players we get, the more tedious it becomes having to manually change the player rankings.

Thanks for your help.

2
Help Me / Ranking players
« on: November 09, 2006, 11:17:10 AM »
Is it possible, when listing the player rankings, to give players with the same amount of points the same ranking number?

Example: Rank   Player    Points
             1        Jon       10
             2        Jim         9
             2       Tom        9
             4        Bill          8

When I try to run the stats, it shows Jim as rank #2 and Tom as rank #3 rather than showing them both as a tie at rank #2

Thanks Corey

3
Help Me / Merging the totals for the same player
« on: October 16, 2006, 10:17:31 AM »
I've accidentally entered a few players names more than once.  When I go to the stats page, it shows the player's name twice with a different point total for each.  How do I merge the two names into one, with their totals merging as well?

Thanks

4



Hi Cory,

I'm in a league and here is the point system:

1st place  - total number of players + number of rebuys
2nd place - 80% of 1st place points
3rd place - 70% of 1st place points
4th place - 60% of 1st place points
5th place - 50% of 1st place points
6th place - 40% of 1st place points
7th place - 30% of 1st place points
8th place - 20% of 1st place points
All other players - 5% of 1st place points for participation

Here's the problem

The formula below awards points  as follows: # of players plus the # of rebuys for the individual player.  I need a formula that will add the number of players plus the number of rebuys for all players.

For example:
33 players in a tournament and 17 total rebuys.

1st place=50 pts.
2nd place=40 pts.
3rd place=35 pts.
4th place=30 pts.
5th place=25 pts.
6th place=20 pts.
7th place=15 pts.
8th place=10 pts.
All other players receive 3 pts.(2.5 rounded)

round(if(r==1, n+nr, if(r==2, .80*(n+nr), if(r==3, .70*(n+nr), if(r==4, .60*(n+nr), if(r==5, .50*(n+nr), if(r==6, .40*(n+nr), if(r==7, .30*(n+nr), if(r==8, .20*(n+nr), if(r>8, .05*(n+nr)))))))))))

Thanks for your help, I'm almost there!

5
Help Me / Formula for adding number of points plus number of re-buys
« on: October 12, 2006, 07:14:58 AM »
The formula below is supposed to add the number of players plus the number of re-buys to come up with a point total.  For some reason this formula is not picking up the re-buys and adding them to the points.  Any suggestions

round(if(r==1, n+nr, if(r==2, .80*(n+nr), if(r==3, .70*(n+nr), if(r==4, .60*(n+nr), if(r==5, .50*(n+nr), if(r==6, .40*(n+nr), if(r==7, .30*(n+nr), if(r==8, .20*(n+nr), if(r>8, .05*(n+nr)))))))))))

6
Help Me / Formula for rounding points to the nearest whole number
« on: October 11, 2006, 02:41:45 PM »
Ive created this formula for point scoring, but I don't know how to make it round every number to the nearest whole number.  Any suggestions?

if(r==1,  n+nr, if(r==2, .80*(n+nr), if(r==3, .70*(n+nr), if(r==4,
.60*(n+nr), if(r==5, .50*(n+nr), if(r==6, .40*(n+nr), if(r==7,
.30*(n+nr),
if(r==8, .20*(n+nr), if(r>8, .05*(n+nr))))))))))


Pages: [1]