7
« on: July 10, 2007, 01:07:47 PM »
okay, I know one of you smart individuals will figure this one out for me. It is a 2 part question, one for payouts and one for points.
for the tournament that I ran for 2 years and will probably start doing again in a few months will have anywhere from 45 to 65 players each month and the season will run for 12 months with a EOY championship at the end of the 12 months.
These are the payouts that I used, but I had to save each of the groups of payouts as a separate prize template, but I know there must be an easier way, even if it involves a bunch of IF statements,
There will be 1 position paid for every 6 players per the table below.
42-47 players – 7th-$50 6th-6% 5th-8% 4th-10% 3rd-16% 2nd-20% 1st-40%
48-53 players – 8th-$50 7th-4% 6th-6% 5th-8% 4th-10% 3rd-12% 2nd-20% 1st-40%
54-59 players – 9th-$50 8th-3% 7th-4% 6th-6% 5th-8% 4th-9% 3rd-12% 2nd-20% 1st-38%
60-65 players – 10th-$50 9th-3% 8th-4% 7th-5% 6th-6% 5th-7% 4th-9% 3rd-11% 2nd-18% 1st-37%
So see if you can create a formula for this.
Second is the points structure. I want there to be more points available depending on how many players play in the tournament. Again, I had to save a different template for each one of different levels on #'s of players.
60-65 players
1st – 46 2nd – 38 3rd – 32 4th – 27 5th – 23 6th – 20 7th – 18 8th – 16 9th – 14 10th – 12 11th – 10 12th-17th – 9
18th-23rd – 8 24th-29th – 7 30th-35th – 6 36th-41st – 5 42nd-47th – 4 48th-53rd – 3 54th-59th – 2 60th-65th – 1
54-59 players
1st – 44 2nd – 36 3rd – 30 4th – 25 5th – 21 6th – 18 7th – 16 8th – 14 9th – 12 10th – 10 11th – 9 12th-17th – 8
18th-23rd – 7 24th-29th – 6 30th-35th – 5 36th-41st – 4 42nd-47th – 3 48th-53rd – 2 54th-59th – 1
48-53 players
1st – 40 2nd – 32 3rd – 26 4th – 21 5th – 17 6th – 14 7th – 12 8th – 10 9th – 9 10th – 8 11th-17th – 7 18th-23rd – 6
24th-29th – 5 30th-35th – 4 36th-41st – 3 42nd-47th – 2 48th-53rd – 1
42-47 players
1st – 36 2nd – 28 3rd – 22 4th – 17 5th – 13 6th – 10 7th – 9 8th-9th – 8 10th-11th – 7 12th-17th – 6 18th-23rd – 5
24th-29th – 4 30th-35th – 3 36th-41st – 2 42nd-47th – 1
Now, the points do not have to exactly match these tables, but I'm sure you get the gist that the more players there are, the more points you can get for finishing higher. If I were able to automate it all in a formula without having to switch around templates every time I get to another break level, that would sure make my life easier.
The final thing, and this has to do with new overall scoring system, is that rather than taking all 12 scores and adding them up to come up with the final points standing for the season, I am thinking of taking the top 9 or 10 scores for the year so that the regular players won't get penalized for missing a couple of months or just plain having a couple of bad months. Is it possible to write a formula for this as well?