Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - felix

Pages: [1]
Help Me / Re: Another guy who isn't able to write his own Formula ;)
« on: December 15, 2008, 04:39:40 PM »
Sorry for answering so late, just had a lot of other things to do.
Now i found out what caused the problem:
I also entered the Points for buy-in, hits, rebuys and add-ons in the fields for that in the game tab. So it seems that they were also counted. At least i set all those scores to 0 and it works perfect now.
Also i had posted the wrong formula in my question, i used the newer Version (nr instead of tnr) that corey posted.
I will ask the guys on hpt for the other question i had.
Thanks alot guys and i wish you all very nice and relaxing (even if they mostly aren't relaxing at all  ;)) christmas holidays!

Help Me / Re: Another guy who isn't able to write his own Formula ;)
« on: December 10, 2008, 05:31:38 AM »
The formula works very well, thanks for that!
But, i have a few more questions:
1. I think i made a mistake somewhere, if i look at the players tab after a tournament, the score is a little off.
Here is an example:
Game with 7 players, the player in the first place busted 3 other players and did not rebuy or addon.
In the points column, his score is 73.0 points. But he normally should get 59.0 points for that tournament (5 for playing +30 for surviving 7 guys +9 for busting 3 other players + 15 for placing first = 59 points). If i look at the game in the stats tab, the overall points column show the correct 59 points, but the points column also shows the (weird) 73.0 points. The "points" column shows some more points for each player than it should. By now i haven't been able to figure out how those extra points are calculated and where they come from.
I put this [ ((n-r+1) * 5) + (nh * 3) - (tnr * 3) - (tna * .3) + switch(r, 1, 15, 2, 10, 3, 5, 4, 2.5) ] formula into the "points for playing" field in the game tab and into the "tournament scoring" field in the filter located in the "stats tab". I put this [ sum(top(7, scores)) ] formula into the "stats tab" overall scoring filter. So do you know how i can solve this problem? I can't explain why he ads some 'mysterious' points in the "points" column but shows the exact points in the "overall scoring" column.

2. Also i have another question regarding the export to
If i export the game, everything works fine, but the rebuys and addons ar not included in the "Buy-In" column. Sure they aren't added to that column in the TD as well, but is there a way to add the total amount of money spent on buy-in, rebuys and addons per player that it is exported to HPT? Now it shows the usual $5 Buy-In for each player in in HPT and i have to add the costs of rebuys and addons for each player manually.
So it would be great if i could export the "total cost" column from the TD to HPT instead of the "Buy-In" column.
Is there a way to get that done?

Thanks again for helping a guy who's getting a little lost in the great functions of the software.

Help Me / Re: Another guy who isn't able to write his own Formula ;)
« on: December 06, 2008, 08:51:10 AM »
Thanks a lot!
So i can start our new season today  ;D

Kudos to you, corey and phaze, i really appreciate how helpful you are.

Help Me / Another guy who isn't able to write his own Formula ;)
« on: December 05, 2008, 01:04:15 PM »
Hi there,
i am hosting a single table tournament series.
For that i need a formula, that should cover the following criterias:
1. every player gets 5 points just for participating
2. every player gets 5 points for each other player that gets busted before
3. if a player busts out another, the hitman should get 3 points
4. i a player rebuys, he should loose 3 points
5. if a player takes an addon, he should loose 0.3 points (this is not a normal addon, we allow addons at the end of the rebuy phase in increments of a tenth of the starting stack, up to the starting stack, so the penalty for the addon is related to the penalty for the rebuy.)
6. the player who finishes fourth should get 2.5 additional points
7. the player who finishes third should get 5 additional points
8. the player who finishes second should get 10 additional points
9. the player who finishes first should get 15 additional points

Can someone of you guys can help me to set up a formula like that? I am a total dummie when it comes to algebra, so i don't have a clue how to do that  :-X

Also is it possible to add a formula to the whole season (10 games) that the td makes a ranking, where only the 7 best games of each participant get counted.

I hope you can help me out, thanks in advance,

Help Me / Re: Need someone who writes me a formula...Please.
« on: December 10, 2007, 06:36:17 AM »
thank you very much for the quick help!
I have been away for a while so I wasnt able to reply.
The last days i hosted the first tournament using the TD and your formula worked really great!
Everything i had to type in excel by hand was done automatically and directly exported to
I am really happy with the program.
So again, thank you!!!

Help Me / Need someone who writes me a formula...Please.
« on: November 29, 2007, 09:35:49 AM »
I have just started using the tournament director. In our earlier tournaments i used excel and i had a formula, where each player got the following points: 10*(number of participants - players finishing rank)
Also the first 3 places got a bonus of:
1st: 3*number of participants
2nd: 2*number of participants
3rd: 1*number of participants

Can anybody of you guys write a formula for me that i can put into TD, that assigns the points as i mentioned in the above.

I would be really happy if you can help me with this.

Pages: [1]