1
Help Me / Recreate Tournament?
« on: April 01, 2016, 11:57:35 AM »
I was not around for my leagues tournament last night, but i have the results. Is there a way to recreate it?
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.
Looks good to me, but for those not too familiar with the formula system, that last comma will cause an error:Is there a way to have it remove the lowest score when do the standings? We are playing 11 tournaments with only the top 10 results counting in the standings.
switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25,)
So just remove it:
switch(r, 1, 100, 2, 75, 3, 63, 4, 55, 5, 50, 6, 45, 7, 40, 8, 35, 9, 30, 10, 25)
I sure can take a look at it for you. Tell your buddy to search ONLY first OR last name, not both. Unless you have 1000s of names, going by one or the other should show results on one screen, or at worst a small scroll to check and enter. Should always use add player.I have the latest. Will send it right now.
Send it to me at michael.brinkley@hotmail.com and I can fix it up for you. I've got plenty of time to kill tonight
The question is, how are you getting duplicates? At buy-in or tournament setup are you entering new players that are already in the database? Doesn't the software warn you that there is already a player with the same name? Or are you entering different names for the same people that are already in the database? Are you importing players from a file? The software should also warn you at that time that the players have the same names as players already in your database.QuoteBecause now I have multiple players in the standings listed twice AND they are already listed as being merged.
What do you mean "they are already listed as being merged"?
There are a couple of methods for eliminating duplicate players, but it will depend on what information in the database is important to you. The player database serves 3 purposes, mainly: (1) as a place to store player personal information (address, phone, email, etc; items beyond their name); (2) as a way to uniquely identify players and collate them across saved tournaments; and (3) as a means to divide players into leagues and divide tournaments into seasons.
If you don't mind losing that personal player information, you can easily (well, sort of easily) rebuild a database by deleting all of the players in the database and loading each of your saved tournaments and adding the players to the database or merging them with existing players.
Magic_fubu's answer is a really succinct way of putting it, and is what I would recommend. To give a concrete example, let's say you have 3 players in your database named "Joe", but they all represent the same player, so you need to eliminate two of them as duplicates.
(1) Pick the "best" Joe in the database. That is, pick the one with the most up-to-date personal information. If it doesn't matter, then pick one at random. Delete the other two.
(2) Load your first tournament. Go to the Players tab. See the players listed italics? Those were players you deleted from the database. That is, those were "attached" to the wrong database player. Press the Merge Players button (or, on version 3, press the Database button and then press Merge players in your current tournament...).
(3) This allows you to match each italicized player with the corresponding player in the database.
(4) Save the tournament. Repeat with all saved tournaments.
Instead of doing this one player at a time, in step 1 delete ALL of your duplicate players, leaving only one of each player in the player database. In step 2, merge ALL italicized players.
Once you've made one pass through all of your saved tournaments, you should be done. Make a backup.
When you register people, are you using "new player" or "add player"? If new, that would be the issue right there. Only thing I can think of off hand.I am not sure. Is there a way to merge them all together tho?
See if this is works for you. It's a little verbose but I think it's what you've described.I think it works fine. Is there a way to round the bottom numbers tho? Looks like this:
assign("lowRank", ceil(0.8 * n))
assign("upper80", round(8 * (sqrt(n) / sqrt(r)) * (1 + log10(bc + 0.25))))
assign("lower20", round(8 * (sqrt(n) / sqrt(lowRank)) * (1 + log10(bc + 0.25))))
assign("step", (lower20 - 10) / (n - lowRank))
if(r <= lowRank, upper80, 10 + ((n - r) * step))
Just take out the "IF". As it is, the formula is specifying that the top 80% get the results of the inner formula, while the bottom 20% get 10 points. Basically, you just want everyone to get the results of the inner formula:Me and my friend were talking who run the league about what we want to happen with the bottom 20% of people in the league.
round(8 * (sqrt(n) / sqrt(r)) * (1 + log10(bc + 0.25)))
No, sorry if I confused everyone. I want the formula to continue to the bottom, not give the bottom few the same amount of points.To take out the ten points, I believe that you would take out the 10 in ...(bc+0.25)), 10I tried that, just taking out the 10 and the bottom people get 0 points.
But, that's just based upon a quick glance, and looking back at the post made with where you got the formula from. If that doesn't work, respond back and I'll do some testing once I get back to my computer with TD installed on.
Isn't that what you wanted?
To take out the ten points, I believe that you would take out the 10 in ...(bc+0.25)), 10I tried that, just taking out the 10 and the bottom people get 0 points.
But, that's just based upon a quick glance, and looking back at the post made with where you got the formula from. If that doesn't work, respond back and I'll do some testing once I get back to my computer with TD installed on.