Author Topic: Assigning points earned by SUBS to LEAGUE players...?  (Read 1160 times)

3oH_TD

  • Newbie
  • *
  • Posts: 3
    • View Profile
Assigning points earned by SUBS to LEAGUE players...?
« on: February 14, 2012, 08:12:51 PM »
Hi all,

Running 2.5.12

I run a 9 game league with the 10th game being the championship.  Total points earned in each game less your bottom game equals your total starting chip stack for the championship game.  I have points setup in each tournament = .5*(7.5*bc+7.5*bc*((n+1)-r))+50*nh+if(rank=1, 1000, 0)+if(rank=2, 600, 0)+if(rank=3, 250, 0)+if(rank=4, 150, 0).  I also award points in the prizes for two bounties each night - 250 for the current league leader and 100 for the prior tournament winner. 

There are 20 people in the league and the formula above allows for non-league players to participate.  In addition, we allow subs, if you miss a game, you can have anyone sub for you and they earn you points for the tournament (only for rank) not for hits or bonus or bounty. 

I have been allocating the sub points earned to the league player that had a sub by adding the league player to the tournament, not buying them in and adjusting their points on the player tab / edit player / adjust points. 

My Tournament Scoring is set to "points" and my Overall Scoring is set to "sum(top(n-1, scores))."

The total points calculate properly (including the adjustments for non-bought in league players - that had subs for a specific tournament and have been allocated points in the adjustment area, and for the points for prizes for a bounty.)

HOWEVER - the Overall Score will not include the tournaments that league players have not bought into in the "n" calculation and therefore doesn't include the adjustments...

So - my question is, do you have any best practices for subs for leagues and how to properly assign points to league players. 
  *** I tried putting my "points" formula into the tournament scoring dialogue, but then the points for prizes are not added to that total, and the adjustments are not included, so run into a different set of issues...

Thanks for all the help, please let me know if you need any clarification!



Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5401
    • View Profile
Re: Assigning points earned by SUBS to LEAGUE players...?
« Reply #1 on: February 15, 2012, 10:31:11 AM »
To take a typical scenario, let's say there are 3 tournaments, and "Player" did not participate in tournament 2, but Player had "Sub" fill in for him.

So, some things to note about Statistics using this method:

  • Player's "Points" value will include points for this tournament.
  • Player will have 2 buy-ins, and thus have 2 Score values.  In the Overall Score formula, "s", "numberOfScores", and "count(scores)" (which all refer to the same thing) will be 2.
  • Player will have other statistics, such as hits, add-ons, rebuys, etc, from 2 tournaments, not 3.  In other words, Player will receive none of those stats from Sub.  Player's averages will be computed using 2 tournaments.
  • Sub will receive all of those statistics.  So, if it matters, Sub will have an additional tournament, receiving points, hits, winnings, etc.

So:

Quote
HOWEVER - the Overall Score will not include the tournaments that league players have not bought into in the "n" calculation and therefore doesn't include the adjustments...

This isn't quite true.  In this example, "n" will be 2 for Player, and you'd like it to be 3.  But Player will receive the points you allocating by adjusting Player's points in tournament 2 (and winnings, if you adjust those).

My suggestion is to use Sub during the tournament.  Then afterwards, instead of adding Player and adjusting Player's points, just change Sub into Player (edit the player on the Players tab and press "Change Player").  That allows you to see "Sub" during the tournament, so as to minimize confusion, and then replace Sub with Player after it's over.  Make a note that Sub substituted for Player.

Of course, if you want Sub to receive any kind of credit for this tournament, this might not work.  In fact, we might be back at square one in that case.


3oH_TD

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Assigning points earned by SUBS to LEAGUE players...?
« Reply #2 on: February 16, 2012, 05:11:04 PM »
Thanks Corey.  We are back at square one, just because I have lifetime formulas that are calculating over 7 seasons and if I change player after the tournament is complete, that player receives credit for a tournament they never played in, wins, take, position, hits, etc...

I've gone through this time and again to try to come up with a good solution, and I haven't found one which is why I posted here.  Right now, it's a manual process to calculate the final points.  I export to excel, then manipulate the data there.

3oH_TD

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Assigning points earned by SUBS to LEAGUE players...?
« Reply #3 on: February 16, 2012, 05:14:09 PM »
Also, where are the Overall Score formulas kept in the background?  When I updated from 2.4 to 2.5 I seemed to have lost the filters and formulas I created...  Can I retrieve those?

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 5401
    • View Profile
Re: Assigning points earned by SUBS to LEAGUE players...?
« Reply #4 on: February 17, 2012, 10:22:36 AM »
Quote
Also, where are the Overall Score formulas kept in the background?

Stats filter information is kept in your preferences.

Quote
When I updated from 2.4 to 2.5 I seemed to have lost the filters and formulas I created...  Can I retrieve those?

I've gotten many reports of preferences being reset, but I have to say that this has never happened to me.  I use different versions of the software constantly, which means preferences files get upgraded constantly, and I have never seen this happen.  The best way to protect yourself from losing data, be it preferences or anything else, is to make a backup.  This is especially true when you upgrade.  It's so quick and easy.  http://www.thetournamentdirector.net/faq.html#faq32

Having said that, if you don't have a backup of your preferences file, and you truly did lose an Overall Formula somehow, unfortunately in all likelihood it is gone.  Overwritten by a new preferences file.  Sorry.