15
« on: November 03, 2013, 03:10:04 PM »
I run a league that has 8 games and you get to drop two scores. We just finished game two for this season and I had a guy who has only played one other time (last year). I asked before the tournament if is was going to join the league and he said no.
Well he ended up winning and asked me "how much to join the league?". I told him a $100 but, he would have to take a zero for tonight. After explaining what that meant, and why, he said ok and gave me the $100.
So now if I add him to the league it will calculate points for the last game and if I don't add him it will not calculate points next time. So I need to zero out his points for game 2 and adjust everyone else's points to what they would have been if he was not in the league.
What is the best way to accomplish this?
Here is the formula used to calculate points: if(inLeague = 1,sqrt(nm*bc)/(leagueRank + 1),0)