Messages

1

Help Me / Re: Formula for SHOWING the lowest score?

« on: February 13, 2011, 07:38:26 PM »

Okay, I am half way home.  I found the lowest score by using bottom(1,scores).  What I'd really like to do is use the "if" function and only display this number if the player has played in at least 5 tourneys.  Those that have played in less should have a lowest score of "0".  Essentially, I am trying to show a "score to beat" value.  I know there is a delivered column for number of tournaments played, but not sure how incorporate that into a formula.  any thoughts?

bullet

I want the formula to be this:  if(numberoftournaments > 4, bottom(1,scores),0)

2

Help Me / Formula for SHOWING the lowest score?

« on: February 13, 2011, 07:09:49 PM »

My league uses top 5 of 7 scores.  We just played our 5th tournament, so I would like to show everyone's lowest score to indicate what they need to beat to move up the standings.  Is it possible to do this on the Overall Score portion of the stats tab via a formula?

bullet

3

Help Me / Help with Top 5 scoring with manual adjustment

« on: December 12, 2010, 01:26:39 PM »

My league has 7 monthly tournaments and we use only the top 5 points/scores for league standings to allow players to miss a couple months without getting hurt in the standings.  We use Dr Neau's formula for points:(sqrt((numberOfPlayers*pow(buyinCost,2))/(buyinCost + (rebuyCost * numberOfRebuys) + (addOnCost * numberOfAddOns)))/(rank + 1))*10.  Part of our rules are if you say you are coming to play in a given month and do not show up, you lose 20 points from your league total.  We had our first no show this month and I am seeing a problem with the top 5 scoring formula that I am using:  sum(top(5,scores)).  Since this player did not play in the tourney, I used the manual points adjustment of -20 on the Player tab.  When it comes to calculate top 5, it looks like this -20 is being skipped.  What I want to do with this person is total their top 5 (not counting the -20 as one of them) and then subtract 20 points from that number.

Is there a way to do this?

4

Help Me / Re: Points adjustment

« on: February 26, 2010, 07:51:20 PM »

Corey -  I used the right-click on the player info screen in tournament history and did the add-on.  Worked perfectly. Thank you!

5

Help Me / Re: Points adjustment

« on: February 25, 2010, 06:25:57 PM »

Corey -  If I do this, will it adjust the points or just record the add-on?

Also, as my original post stated I do have the number of decimal points set to 4.  The score adjust reads 0.0000 before I enter the adjustment.  When I entered the adjustment with 4 decimals (-1.6759), the system rounded it to -1.6800 on the Edit Game Player page.  Points and Score Precision are both set to 4 on the Preferences tab.

Regarding Phaze's comments, when I hit B, nothing happens.  I am not even prompted to override anything.  It just acts like I didn't do anything.  I am on version 2.5.10.  I do remember after the point in time where I no longer allow add-ons/rebuys, that a screen popped up regarding an override and I click something to keep that screen from appearing after every knockout after that point in time.  Is that what you are referring to?  If so, how do I get that back?

Bullet

6

Help Me / Re: Points adjustment

« on: February 14, 2010, 02:03:27 PM »

I tried that first.  That does not work because the tournament is over.  That's why my original post mentioned undoing the last knockout.

7

Help Me / Points adjustment

« on: February 13, 2010, 12:47:18 PM »

I had a tourney last night and realized I failed to enter an add-on for one player.  We utilze Dr. Neau's scoring system.  Of course, this person happens to have won the tournament and it is a fairly significant difference between 1st place with and 1st place without an add-on.  I thought the best way to remedy this would be to manually adjust his points down to the proper score.  However, I use 4 digits to the right of the decimal and when I enter the adjustment it rounds it off to two.  I know you're thinking "Big Deal" but that could be important as my standings are very tight.  All of my Stats show 4 digits, so it's just this adjustment that rounds.  Am I missing a setting somewhere?  Should I undo the last knockout and enter is add-on and then re-knockout the last player? 

Please help

Bullet

8

General Discussion / Re: blind structure

« on: April 02, 2009, 09:13:37 PM »

A 10 seater that lasts 9 hours?  Ouch.

9

General Discussion / Re: TOC Question/Feedback

« on: April 02, 2009, 08:36:57 PM »

I agree.  I think his beef is he wants to put someone in his chair and have that person try to win the money that he thinks he has a claim to.  I don't think it's fair to have someone who has never played in the league to step in and walk off with our money that was raked over 6 tournaments.  I think the only other "fair" option would be to leave that chair open and just post his blinds until his chips are gone.  I llike having a full table better than empty seats.

10

General Discussion / TOC Question/Feedback

« on: April 02, 2009, 05:22:34 PM »

I just started doing a league this year.  I put together a document covering all of the things I could think of (not poker rules, league specific stuff).  The top 10 point getters are invited to a freeroll TOC at the end of the season.  I had put in the doc that if there was anyone in the top 10 that could not make the TOC, #11 would be invited...so on and so on until we had 10 people committed to playing.  The TOC (and all tour events) is being played on the 2nd Friday of every month..anounced well in advance (months ago).  Of course, I have someone that is in the top 10 and can't make it and is sqawking a bit about wanting to be able to designate someone to take his spot rather than it going to the next person in the standings.  Since I documented that it will be this way, I am not going to change it for this year.  I would entertain the idea of changing it for next year. 

I am looking for thoughts on how you guys are handling this situation or would suggest the best way to handle it in your opinion.

thanks for the feedback.

Bullet

11

General Discussion / Tournament of Champions - Feedback requested

« on: January 08, 2009, 11:40:19 PM »

I am running a league with 6 monthly tourneys followed by a ToC (free roll) for the top 10 in points.  I rake 20% for the ToC from each tourney and payout the top 4 or 5 each month depending upon the attendance.  I use Dr Neau's point formula

I do not pay anything or have any sort of "benefit" to finishing in the top 10 other than making the free roll ToC.  So in that sense, finishing 10th is no different than finishing first.

We start with 1500 in chips each tourney.  I am toying with the idea of starting the ToC with chip stacks that are relative to the number of points that the first place person has or by rank.  This would give some sort of benefit to finishing higher than the next guy.

A couple examples/thoughts:
    1.  1st place has 50 points and 10th has 25, 1st place would start the ToC with 1500 chips and 10th would start with 750 (50% of points = 50% of chips).
    2.  1st place gets 1500 chips and each position after that gets 50 chips less than the one before it (points wouldn't matter other than to rank players).

Does anyone have feedback on these or perhaps other options to consider?

Bullet

12

Help Me / Re: Help with undo

« on: December 13, 2008, 01:38:24 PM »

Cancel that last reply.  I need to read your posts a bit more thoroughly.  I clicked SAVE and all is well again.

Thanks again for the help.  You turned a bit of a pain in the arse to a 2 minute fix!

Great product!

BM

13

Help Me / Re: Help with undo

« on: December 13, 2008, 12:49:46 PM »

Corey -

first of all, thank you very much for your quick reply.  I did have these guys in the player database.  You solution, at least on the surface, appears to have fixed my problem.  All of the player stats from this second tournament have been corrected between Craig and Greg.  However, when I go to the Stats tab and run the stats for my two tournaments, it is evident that the point system we use has added Greg's points from Tourney 1 to Craig's points from tourney 2 and given them to Greg.

Should I be doing any of the merge/unmerge stuff to my first tourney file?

Bullet

14

Help Me / Help with undo

« on: December 13, 2008, 01:30:46 AM »

Ran our second tournament tonight.  My co-director was running the software and did not know everyone that was playing.  Unfortunately we had a "Greg" and a "Craig" playing.  He heard Craig busted out, but it was really Greg (and he didn't know either of the guys so he went with what he thought he heard).  It was discovered about 2 hours later that the wrong guy was busted out and in the meantime a handful of other people were busted out.  Rather than trying to fix on the fly, we let it go and treated Greg as though he was Craig figuring we could fix it after the tourney was done.

I would like to preserve all of the stats if possible, but realize it may not be.  My initial thought was to note who went out in what rounds and by whom and just recreate the whole tournament with a new file advancing the rounds manually to accommodate the round in which the player was bounced out.  I think that would technically work, but any stats related to time of play would be gone unless I sit in front of my computer for 4.5 hours and bust players out at the same exact elapsed time (which I am not willing to do).

Any suggestions on the best way to handle this big oops after the fact?

Bullet

15

Help Me / Sum and Avg on Stats page

« on: November 20, 2008, 08:09:02 PM »

Is there a way to remove the Sum and Avg lines from the bottom of the stats page (and keep the rank number)?  These are useless for my purposes and would like to know if there is a way to remove them (without editing them out of the exported file manually).

Bullet