Author Topic: Points for playing formula problem  (Read 985 times)

Bean_D

  • Newbie
  • *
  • Posts: 27
    • View Profile
Points for playing formula problem
« on: December 29, 2006, 06:27:27 AM »
Hello!

Our new leauge will be a 15-game leauge with a final where the starting chips will be determined depending how well the players have played during the season. We are 6-8 players, always the same guys.

The points (i.e the chips the player will bring to the final table) a player gets are fixed depending on how many players there are in each separate game, like this:

8 players
1st   10000
2nd   7000
3rd    5000
4       4000
5       3000
6       2000
7       1000
8         500

7 players
1st    9000
2nd   6000
3rd    4000
4       3000
5       2000
6       1000
7         500

6 players
1st    8000
2nd   5000
3rd    3000
4       2000
5       1000
6         500
 
My solution is to make 3 different games; "8 players", "7 players", "6 players", set the points manually and load the proper game every time.
I am sure this can be done with a formula. Not by me, though. I am useless when it comes to making them, I just don´t understand the math. *sigh*
Can anyone help?

Thanx in advance,

/Jörn

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5402
    • View Profile
Re: Points for playing formula problem
« Reply #1 on: December 29, 2006, 11:09:12 AM »
((n-r) * 1000) + if(r == 1, 3000, if(r == 2, 1000, 0), 0) + if(r == n, 500, 0)

Bean_D

  • Newbie
  • *
  • Posts: 27
    • View Profile
Re: Points for playing formula problem
« Reply #2 on: December 30, 2006, 08:28:50 AM »
Thank you, Corey, it worked like a charm!

/J