Redemption® Collectible Trading Card Game HQ > Playgroup and Tournament Central

Tournament Scoring Spreadsheet Updated

(1/4) > >>

frisian9:
All,

I updated the tournament tracker, an Excel spreadsheet that can be used to score and create pairs/tables for tournaments. The new version corrected a few bugs when only 2 or 3 players were entered for an event (the ranking numbers couldn't be generated).

I also added code to check for scores over the legal limit (5 for type 1 and 7 for type 2). It now warns you if you try to go the next round with a score over the legal limit. You are allowed to keep the larger value, but at least warned that it is over the limit. Cactus only allows a score over the legal limit if two or more players tie at the end of the game for the win, and one played a Son of God + New Jerusalem combo. Typically, if you play this combo while leading 4-3, you would only get to keep one of the two Lost Souls and end up with a 5-3 score. However, there are cases where a 5-5 tie could result, with a Son of God + New Jerusalem being allowed to result in a 6-5 win. This is very rare, and very unlikely. Hence, i place a warning instead of an error in the spreadsheet.

If you have not used the spreadsheet, you are encouraged to try it out. It can be downloaded from Cactus' website. It requires you to change the protection in Excel to allow macros to run, since all my code is in the macros. The spreadsheet has beeen used for over 6 years at all levels, including nationals. It is user friendly and it is reliable.

Regards,
Mike

Gabe:
Thanks, Mike.  I used it.  Love it.  And was wondering when we could expect an update with the new changes but didn't know who to ask. 

Did you also change the way it scores byes?  Version 2.2 was still giving a -3 LS differential when it should have been 0. 

Cameron the Conqueror:
Thank you so much!  Love using it for tournaments!

frisian9:
Gabe,

Would you mind elaborating? I am years beyond version 2.2, so don't know what specifically you think it should be doing. Whatever it is, it should be easy to fix. Now is the time to ask - the code is fresh in my head.

Thanks for your help in advance!

Mike

Gabe:
I downloaded your new version and after a couple tests it looks like it's scoring a bye correctly.  It used to give a 3 points and -3 for LS differential instead of 3 points and 0 LS differential.  I noticed we're on version 2.6 now so that was probably fixed a while ago.

Thanks, Mike!

Navigation

[0] Message Index

[#] Next page

Go to full version