5
« on: September 29, 2022, 09:43:12 PM »
Ok, so we are going into our 3rd league season using TD and everything has been fantastic, I've been able to manage the formula and kept it fairly simple. Up until this season we've given players 100 points for showing up, and 100 bonus points for each higher position they move in a tournament. For example if 16 show up, and they finished 12th they'd get 500 points. 100 points for showing up then another 100 for moving up 4 places. There was of course bonus points for finishing in the top 4. However this has lead to players just sitting on chips later in the season not playing as much trying to squeeze every few places they can to either make or hold position for our final free roll tournament.
What I'd like to do for this season is limit it to 100 show up points, then you don't begin to accumulate bonus points until the final table which is typically 9 seats sometimes 8 (not sure if I can make it dynamic for that) so that leads me to my question. How do I adjust the formula to change if say we only get 8 players or even 6. At any point less than 9 I simply want it to be the bonus points for 1-4. Or if possible can I change the formula to dynamically adjust the points based on whether the player finishes in the money?
Here's what I have so far. Any help is appreciated!
(100) - (rebuys * 25) + (numberofhits * 25) + if(rank = 1, 1200) + if(rank = 2, 1000) + if(rank = 3, 850) + if(rank = 4, 700) + if(rank = 5, 500) + if(rank = 6, 400) + if(rank = 7, 300) + if(rank = 8, 200) + if(rank = 9, 100)