Forum adverts like this one are shown to any user who is not logged in. Join us by filling out a tiny 3 field form and you will get your own, free, dakka user account which gives a good range of benefits to you: No adverts like this in the forums anymore. Times and dates in your local timezone. Full tracking of what you have read so you can skip to your first unread post, easily see what has changed since you last logged in, and easily see what is new at a glance. Email notifications for threads you want to watch closely. Being a part of the oldest wargaming community on the net. If you are already a member then feel free to login now.

@barontuman
No offence taken, SQL is my normal home. The UI is in VB.net but the work is being done by the DB to allow for many people to update the system at once as it has to be able to handle more than one event at the same time (ok it does not have to, but this is really a vanity project so it will do; god damn it!)

T-SQL does allow a table variable which is essentially a temp table held in memory only(and could be thought of as a 2 dimensional array) and could be used to hold the matrix quite easily as you can reference a row and column very easily.

To hold the flags that seem to be required you could create related tables (giving you almost a psudo-3 dimensional array) or just have additional columns in the table. The beauty of T-SQL here being that if you are not interested in a column, you can just ignore it.

My problem is that I cannot see how to relate the algorithm, which seems to only solve a single variable (cost), to the problem of matching players based upon previous opponents, current scores and teams. I trust you that it can be done and the issue is my understanding. I'll try and have a go at implementing a few examples of this algorithm in T-SQL after I have finished this project (it has to be ready by Thursday :-0 )

It's just a matter of weighting. Add "point" if they've played already or on the same team.


Done by Thursday? Good luck! No testing either? Yikes!

People battle over thief computer? How does that work?

THanks for the replies.. i went with perfect swiss. Easy to modify and not absurdly expensive to the point of being "wtf?" like tournament overlord is

Kirasu , will you have that software with you this weekend? Would love to take a look at it, we've just been using excel at our events so far. Has worked ok, but as the field grows it does take time to do pairings.

On a side note, anyone know what GW used in the past at all the GT's and Gamesday Tournaments?

@barontuman

I am trying to use your product you gave out.

However even after reading instructions, I have no idea where or how to add in the Judge Score Entry.

Ive double clicked on just about every part of this program in an effort to bring up this dialog box you mention, but I am thus far completly un able to find it.

Ive tried in the results tab and every other tab during and prior to hitting "begin tournament"

Any help you can give would be much appreciated.

@barontuman

Yeah, I believe its euphemistically called "agile" development

barontuman wrote:
@ Grokin,

First run : it doesn't install on the start menu, if you're going to have an install program, you might as well install it where a user can find it. You say that it's free, but you have an "evaluation period?" Also, after entering one player in, I clicked on it and got an Unhandled exception error. The player entry system is pretty slow and typing and mouse intensive. It would show down a large tournament registration.

Why not just use mine?

The evaluation was for the installer software, which does not work great to begin with, it did not add to the start menu as you pointed out. I need to find something that works better.

Like you I'd rather do something myself when I can I know what going on under the hood of my app but no idea on yours. Plus I can customize it for what my group needs.

@ Marius Xerxes

I broke it with the last revision, and am working on it right now. Sorry for the inconvenience, and thanks for finding it!

EDIT : Fixed that problem, as well as updating the scoring buttons when scores are entered by double-clicking on the results tab.

@Grokin,

While I can understand the desire to do things yourself, I would counter that because it's written in Java, you can see the code yourself. I've allowed for a LOT of customization, and if there are things that your group needs that are not available in my program, I'm always open for suggestions. Further, if we all create our own solutions and are duplicating work, we're not doing the community any great service. However if we were to all combine forces and work together to create the "best" solution possible, we would have more features, fewer bugs, and less time spent on the whole.

Just something to think about!

@barontuman

Tournament Marshal seems to only work for Battle Point tournaments. I don't think you even have a # of wins column in the results page. Your program works fine for traditional RTT events where pairings are #1 seed vs #2 seed...

To expand it further, offer different types of tournaments. NOVA style was based on W/L and then battle points (3.00 down to 0.00) with the three objectives equally weighted for battle points. NOVA seeded with opposite pairings between each round. Top win vs bottom win.

Swiss Perfect uses Subgroup pairings - top upper group winner vs top lower group winner, and mainly cares about W/L, then other chess tiebreakers.

I've started using Swiss Perfect for tournaments that are based on W/L record, and then battle points. To enter battle points in SP, just check the multiple game option on starting up and then when entering round scoring, enter the BPs as the Minor Score. At the beginning of the tournament you can set tie breakers to Minor score first. This will pair rounds based on W/L record and then difference in Minor Score between yours and opponents. Then at the end you can change tie breakers to Bucholz and then Minor score if you want the tiebreakers to be in a different order. It's not the best way if you want to rank on W/L and then BPs, but it's close.

Maybe we can get barontuman to add in different formats. Also, adding in ELO scoring would be great. Allow the user to enter a default number for new players and then select the K value for the event. By doing this, you will help out the first round so it will be less random pairings.