With the latest DCI Floor Rules, there's the change to scoring, where players only receive 2 points instead of 3 if their game is decided by the tie-breakers (points, gambit, closest to the center, etc.), rather than a full victory.

We are anticipating the DCI Software to be updated at some point to include this option, but at this time, we have no ETA on that.

The Regionals this year, and GenCon, are supposed to be run utilizing this new 3/2/0 scoring system instead of the previous 3/0 system. In order to do that, there are two methods.

First, you use the standard DCI software to track wins/losses, and determine standings. However, you keep a separate sheet of paper with all the players names, and you make a mark/note of some kind, whenever a player would only receive 2 points instead of 3. Then at the end of the tournament, you adjust the standings that the DCI software kicks out as needed. This will oftentimes shift the standings around slightly. For a tournament of 16 players or less, this isn't too difficult. Going higher than 16 is where it gets troublesome.

So, I've created an Excel file to help T.O.'s run their events utilizing the new scoring system. It will require no math. Yay! ;) It does require a little extra work though, as you end up having to enter the player and winner/loser data twice. You would still need a program to do the Swiss Parings, like the DCI Software or some other program (there are quite a few Swiss Pairing programs you can find all over the internet). But you enter the same player/parings/winner/loser data into this spreadsheet, and then when your tournament is over, you just click the 'Determine Standings' button, and voila! You know the standings based on the tie-breakers in the latest DCI Floor Rules.

I would like for some T.O.'s to download this file and test it out at their LGS between now and Regionals. Especially if you have a large event going on where you expect 17 or more players. If you are not able, or don't want to, use the file at the event itself, please feel free to enter the information afterwards and see how it works. Or, I wold LOVE it if some T.O.'s would export/copy the tournament information out of their DCI Software and send it to me. Then I can enter it myself and use those tournies to test the file. I'm not exactly sure if there's an easy way to export the data, but I will check on that this Thursday at my LGS.

So, without further delay (or reading, haha, sorry). The file can be found on the SWMGamers.com homepage, under the Gamers Downloads section, under DCI Resources. There are actually two files there. Version 1 has a bunch of random player and game data entered so you can sort of see how it works. Version 2 is the actual file intended for distribution. I figured I'd throw a test file up there so people can see how I used it, and how it is supposed to work.

Here are the quick-links to the download page: http://www.swmgamers.com/page.php?27

Also, I have the file hosted on my Google Sheets account, so you can get it from there as well.

http://docs.google.com/fileview?id=0B5h8A10UMwcNMGFiNmU1MmMtNGM1ZC00MWFlLWE3YTItMjBkZTk3NDFmNjA2&hl=en

EDIT: Be sure to 'Enable Macros' when you open the file, otherwise the sorting won't work.

I have some problems, if i push a butten i get this massage ...


Run Time Error "1004"

Sort method of Range class failed


can anybody help me ?

Bump. Need help testing this program. There's a chance this could become the basis for a standardized reporting software if/when DCI stops supporting the game.



I've been getting that error as well, and I'm trying to get to the bottom of it. Could you let me know exactly which button you were pressing when it caused that problem? The best help would be if you could email the file to me to see exactly what your 'data entry' page looked like. Thanks.