Tournament Plus - Revision History

2.05.14 - Interim Change 12/3/07
Fixed problem with 16-person brackets, consolation rounds, which prevented selecting winners in the first consolation round.
Fixed code glitch that did not correctly advance the team name of the winner of the 32-man bracket 12th first round match (btnTxt23)
Fixed "3OT" designator in form to enter bout results
Restored one instance where tblAddedPoints was not cleared when starting a new tournament
Modified drop-down registration list to include a box to check/uncheck wrestler as a team scorer
Added Final Results report format 4
Added an option to specify, on a bracket-by-bracket basis, to score using pin points only or pin points plus final placement points
Added 32-person brackets to Custom Bracket #2 format - rounds 1 & 2 single elimination, losers of champ qtr-finals wrestle for 5th (single elim.) and losers of champ semi-finals wrestle for 3rd
2.05.13 - Interim Change 9/15/07
Fixed bug that deleted Setup Options when deleting a bracket from the Data Entry Screen (affects versions from 2.05.10, 2.05.11 and 2.05.12 only (Problem was in qryQuickEnter)
Added Custom Bracket 2; cleaned up shortcut menu to print individual BS for Custom Brackets 2 and 3
Added optional designator for a win in second or third overtime period (2OT and 3OT)
Incorporated code changes to support later compatibility with Vista
2.05.12 - Interim Change 6/9/07
Fixed bug in Auto Seeding form that caused lock up; eliminated requery that sent you back to first record everytime
Fixed minor errors in printed reports and Report Print Format Options page
Option to print Freestyle Bout Slips (setup in Print Options form) fixed
Changed menu item under Reports - Output Reports to Disk - Output Bracket Sheets as *.pdf (Original format) to actually use original format
2.05.11 - Interim Change 3/21/07
Fixed "Labels for Wrestlers" form; three choices under "Who?" did not work right
Updated Age calculation code (again); if cutoff date is on birthday, age is increased
Recoded Data Entry form to reflect changes when replacing a Bye with a wrestler and vice versa
Removed copyright notice on bout slips and bracket sheets to facilitate commercial printing of programs and brackets
Added an option under Match Numbering to number Championship Semis and Consolation Qtr-Finals together
2.05.10 - Interim Change 3/13/07
Changed code in Data Entry form back to pre-2.05.09 format; this change caused data to be deleted when the Data Entry form was reopened after starting the bracket
Fixed problem with AutoSeed screen that prevented adding new bracket from that form
Fixed Consolation Semi-Final Match Number field to allow changes on right click (interfered with by Custom Bracket #1 code)
Fixed 16-person Consolation side only bracket sheet - was titled "Championship Rounds"; restored feature to print only the championship or consolation side of the bracket sheet depending on which was visible when the "Print Current Bracket Sheet" button is clicked.
Added Bracket Size column to Print Brackets and Bout Slips screen to help printing for multiple bracket sizes in a single division
Added menu item to import a list of Team Names into the Contacts and Invitations form from an *.xls file
Updated code for automatic update to advance first round Byes in 16-person brackets
Added Custom Bracket #3 - "Follow-the-leader", 32-person bracket with 18 wrestlers, first round (pig-tail) single elim, 6-places only
Modified code in Print Brackets and Bout Slips form to print only the appropriate bracket size matches when you select "All" weights
Changed Age calculation in Registration form (was adding a year to kids born on or one day after the cutoff date)
Changed the "x" that is added to a match number when you print the bout slip individually to a "." to minimize confusion with numbers
2.05.09 - Interim Change 2/16/07
Fixed bracketing of first round byes in 8, 16 && 32 brackets (showed incorrect info if Bye was changed to a wrestler when creating the original bracket)
Fixed M30 Match number display in 16-person SE2
Fixed problem with opening Match Number Reports from the menu bar
Fixed round robin scoring scheme to show 0 pts for Bye - fixes problem with total pts if one person is a "Bye"
Fixed problem with Refresh feature of Team Scores Display screen - Only affects scores displayed in this form and only when using "Place Points Only" scoring.
Modified form showing winner results to better handle pin times like "3:04" (was showing them as "3:4")
Changed "Personal Contacts" form to allow exporting to and importing from other than the A: drive
Modified code for 6-person round robin auto place for RR3Place 3-way tie
Added Custom Bracket #1 - 8 person only; only one consolation round; three places
Added report for pre-determined Match Numbers (from Interim Change 08)
Added logo2.gif to all bracket sheets
New form to specify how you want Bracket Sheets printed (paper size, some format options) Under "Tools" menu bar item
Added Team Scores by Section/Nickname (Overall scores using "nickname" in Contacts && Invitations to group teams)
Added "Seeding Info" column to Seeding Table screen
Added code to "Update Division" module to handle All-In-One-Group
Added Team Scoring code to allow assigning 4 Placement Points to 4th Place in a 8-person bracket with only 4 participants.
Added pdf report options for letter (original), letter (horizontal) and legal
2.05.08 - Interim Change 1/15/07
Fixed Pig-Tail bout slips (missing Division on second slip on the page)
Corrected code for sorting match number reports by Mat [error in Val() function handling]
Changed default value for team scoring for 16-person bracket, 5th place to be 2 pts
Enlarged Bout Slip scoring area to allow for more overtime rounds
Added feature to allow printing Match Numbers on Registration/Weigh-In cards for Round Robin participants only
Added Print button to pop-up view of Registration List (from menu bar)
2.05.07 - Interim Change 1/9/07
Fixed a problem with 5th and 6th place bout slips (half page bout slips) not maintaining bottom margin
2.05.06 - Interim Change 1/1/07
Fixed a problem with printing bracket sheets on a select few disks due to duplicate page header
Fixed a problem with "Final Results" that did not show all Wrestle-Backs for Second when some individual Divisions were selected
2.05.05 - Interim Change 12/27/06
Changed bracket sheet that prints from "Print Final Bracket Sheet" button to be 8-1/2x11, championship on right, consolation on left; 8-person and 16-person only
2.05.04 - Interim Change 12/22/06
Fixed logo2.gif images on bracket sheets (logo1.gif is only on the 11x17 32-person brackets)
Added Sponsor form to show text on the bottom of brackets sheets (eg, "This Backet Sponsored by BrownBag Data Software")
2.05.03 - Interim Change 12/12/06
Fixed 16-person 11x17 report (wrong reference to third and fourth place winners)
Fixed 32-person 11x17 report (extra lines between Tournament Title and Tournament Date)
Fixed code that kept giving message that you had already entered results when assigning single elimination rounds
Added specific single elimination bracket sheet printouts and stopped assigning match numbers to single elimination rounds
Added "Clear Clipboard" to close button on LineChart - eliminates message when single elim selected
2.05.02 - Interim Change 12/4/06
Fixed incorrect placement of wrestlers in 16-Person Championship Finals (legal size and 11x17 versions only)
2.05.01 - Interim Change 12/2/06
Added option to have all Match Numbers blanked out.
2.05 - Initial Distribution 11/24/06
Fixed 4-person RR problem with team name not showing for second place (frmRoundRobin4 RRPlace2_4) 
Fixed 'Cancel' feature on various modules that went directly to Exit Function without restoring control to app
Fixed queries to fetch winners of 2nd and 3rd place matches in round robin brackets (qryAppWinners-2-16, qryAppWinners-3-16)
Fixed report for initial pairings/match numbers to inclue 6-person RR and correct 2/3-person RR (rptPairings)
Fixed bad winner select buttons in 32-person brackets
Changed Options screen to show Match Number buttons if activated
Changed tab order for 6-person round robin data entry (frmQuick Entry)
Changed Print form to include 6-person RR when "All" is selected (qryBracketsRR)
Changed RR Bout Slip report sections to "Keep Together" to try to fix printing issue
Made the Final Reports text fields wider to accommodate longer names
Added Seeding Table to Data Entry screen
Added a shortcut menu to allow swapping wrestlers in crossover matches
Added more label choices and fixed label printout for winners
Added reports for Match Numbers by Mat as well as by Bracket and for Mat Assignments by Mat
Added optional Freestyle type Bout Slips for all bracket sizes
Added print to pdf options [Need to copy dynapdf.dll and StrStorage.dll to TourPlus or Window/System directory to implement pdf feature]
Added 2nd round single elimination to 8-person brackets
Added "Most Pins - Least Time" report
Added ability to identify printers that center paper and card stock (applicable to 4x6 Registration Cards only)
Added function to click on match number to print/preview single bout slip
Added function to print blank Registration Cards under Reports - Print Misc Forms; Added capability to print Multiple Copies
Added Match Numbering option to start all brackets in round 1
Added Match Numbers to 16-person final bracket sheet

2.04c - 12/1/05  (includes interim changes of 12/18/05 through 2/16/06)

Modified Match Number Assignment for Not Numbering Byes to take care of 8-person bracket second consi round (frmSetMatchNumbers)
Fixed queries to fetch winners of 2nd and 3rd place matches in round robin brackets
Fixed 4-person RR problem with team name not showing for second place
Added "Most Pins" report (under "Scoring" on menu bar)
Fixed code that omitted match number for match involving wrestler with RecordNumber 0001
Fixed bug in 32-person first championship round; if the bottom wrestler in bout #3 won the match, it would change the winner back to the other wrestler after leaving that record
Added Clear function for 16-person championship qtrs to remove losing wrestler sent to consolation side when the results of those matches were cleared
Fixed bug in 16-person championship semi (button for selecting the winner was partially hidden by the field containing the name of the wrestler and would not work)

Added an option in Numbering Matches to keep Round Robin matches more sequential rather than waiting

Added an option in Numbering Matches to select individual Mats for numbering

Added option to show 5th through 8th place winners in 8- and 16-person double elimination brackets (including additional matches)

Added error message when printing bout slips for rounds where there is an empty name field

Added 6-person round robin to 'Print Brackets and Bout Slips' screen

Fixed problem with Team Scores remaining in memory from a previously loaded tournament

Fixed 8-place team winners report (7th and 8th place sub reports were wrong)

Fixed display problem with Match Numbers in 16-person consolation round

Fixed issues with Match Numbers in 32-person brackets (match nos on reports didn't match screen)

Changed margins on 11x17 bracket sheet to 0.5" all sides

Fixed Contacts screen to allow ZIP codes above 32767 (max number allowed as "integer" by Microsoft)

2.04b - 10/28/05

Added 'Seeding Comments' to Registration by Weight report

Fixed Place Points Only team scoring for Round Robin brackets where no points are scored

Fixed additional scenarios for 6-person RR auto placement

Added option to print 8.5x11, 8.5x14 or 11x17 Bracket Sheets for 32-person brackets (added optional logos/watermark)

2.04a - 9/26/05

Added function to create and use a "Master Registration List" to select wrestlers for a particular tournament

Fixed Menu Bar on "Set Match Numbers" form

Fixed Calculation of Team Scores for 6-person Round Robin

Revised 2/3-person Round Robin bracket to be n1, n2, n3 vs. n1, n8, n5 (allows quickly changing a 2/3-person bracket to a 4-person bracket or larger)

2.04 - 9/12/05

Added Wrestle Back for Second Place - only added to 8 and 16-person brackets so far.

Added capability to NOT assign match numbers to Byes

Added "Wins" and "Pts" for round robin brackets onto the printed bracket sheets. Deleted placement criteria text.

Changed registration backups to allow backup to other than A:

Fixed label on 16-person 2nd consolation match

Changed Bracket Sheet print selection to include Round Robin Brackets when "All" is selected.

Fixed Import Utility to import DOB from registration spreadsheet.

The following items were added as the result of user comments/requests:

Added report for printing Bracketed Wrestlers for a specific team to menu [Reports menu].

Added report for printing Mat Assignments to menu [Reports menu].

Modified report of all Bracketed Wresters by Team to show headers on all pages.

Fixed tab order on 5-Person bracket entry screen.

Added input mask to the D.O.B. field in the Registration screen [--/--/--]

Added a form to see if any wrestlers in the Registration form have team names that are not in the "Contacts and Invitations" form [located under Registration menu item]

Added an automatic check, when entering a wrestler number in the Data Entry screen, to see if that wrestler has already been bracketed. If so, a warning message will appear.

Added a field in the drop down menu when entering a wrestler Data Entry screen that shows any bracket that this wrestler has already been put into. ["Approx Wgt" is registration weight, "Bracket" is the weight class into which a wrestler has been placed.

Added a check in the Registration screen to let you know, when using Fixed Weights, if you are assigning an "Approx Wgt" that does not match a weight you have created for that Division.

Added a button on the Bracket Sheet screen to take you to the "Print Brackets and Bout Slips" screen with the Division and Weight already selected. The button is labeled "BS".

Fixed 8-person bracket sheet printout to show "loser Match xx" when Match Numbering is used.

Fixed Weigh-In Card Print Form to print instead of preview when "Print Cards" is clicked.

Added Team Scoring by Place Points only (previously available only with Round Robin brackets)

Added ability to run 6-person Round Robin brackets (each person wrestles 5 times)

Fixed label problem on bracket sheet report where they did not print.

2.03b - 1/15/05

Added code to prevent clearing the names of the Consolation Quarter-Final winners when running a 16-person bracket with first round single elimination.

2.03a - 1/10/05

Corrected Match Numbering to eliminate duplicate numbers assigned to 16-person brackets, championship quarter finals (first match duplicates the fourth match number of previous bracket)

2.03 - 12/23/04

Added drop down buttons to Pig-Tail form for adding wrestlers by choosing from list

Fixed Team Score display to refresh divisions 7-10

Fixed query to print winners' list (qry-winners1)

Fixed printing problem with Pig Tail bout slips

2.02 - 11/30/04

Added Divisions 8 - 10

Added Divisions 6 and 7 to registration summary reports

Correct 8-place scoring values in default settings

Fix bug in double-click on wrestler number in Data Entry form if adding an unregistered wrestler

Added Bulk spreadsheet import; cleaned up registration import and division update codes; added DOB to Register.xls and to tblRegistration_New

Corrected instances of Else: and reference to RecordNumber2

Removed RR=0 from BS and LC queries; resized qryBracketsheets16; made RR default to 0 in tblPairings

Added error messages to trap common errors on printing brackets and bout slips

"Un-Rem'd" Call UpdateButton in frmLineChart.OnCurrent

2.01 - 6/26/2004

Fixed bug in 8-person brackets (advance loser of bouts 7 and 8 and Update Button)

Fixed 32-person Data Entry to update registration info from changed registration card

Added report of All Registrations by Name

2.0 - 4/1/2004

Added automatic placement option (button) for Round Robin brackets

Added 6th and 7th Division capabilities

Added ability to compact data database file from the menu bar

Added ability to save tournament files to other external drive (other than A:) or to other specified path

Added automatic bout numbering / match numbers

Added 32-person double elimination brackets

Added 5-person round robin brackets

Added 64-person Pig-Tail round

Added single elimination option for first round in 8, 16 and 32 person brackets and second round in 16 and 32 person brackets

Added import feature for registration (requires use of specially formatted Registration.xls) and query to check for duplicates in Imported registrations

Added option for specifying place points in round robin brackets based of various brackets sizes

Added capability to save multiple tournament files to hard drive in addition to floppy drive

Added code to allow exporting final brackets sheets as *.snp file (readable with Snapshot Viewer by Microsoft)

Added report to show all match numbers assigned by weight class

Changed RecordNumber to an Auto Number field to allow import of un-numbered registrations

Included script to automatically compact TourPlus_Data.mdb when starting new tournament

Added code to notify user if non-allowed characters are used in division names (bug fix)

Corrected Data Entry screen to allow closing it without specifying a Division and a Weight (bug fix)

Corrected Bracket Sheet screen to allow editing team scores for the two Championship Finals wrestlers in a 16-person bracket (bug fix)

Corrected problem with tblDivisionNames becoming un-linked (bug fix)

Corrected problem with frmLineChart16a that caused "You have copied data to clipboard..." message (bug fix)

1.03 - 1/31/04

Fixed problem with trying to backup and restore tournament files to Drive A:. (was seeing A:\ as A:\\)

1.02 - 1/27/04

Added ability to backup and restore tournament files to other than Drive A:. Does not apply to "Backup Registration to A:" and "Append/Replace Registration from A:" features.

Fixed feature that updates wrestler name and team when you double click on the wrestler number, make the change in the registration for and then return to the bracket sheet.

Changed form that opens when you click the yellow question mark on the "Set Scoring Points" screen. The new form shows typical team scoring for 4, 6 and 8 place tournaments for both NCAA and NFHSA guidelines.

1.01 - 1/12/04

Fixed bug in Weight Classes and Mats form that knocked you out of the form when you tried to enter a new Weight.

Please note that you can enter Weight Classes in the Weight Classes and Mats form, but you can only edit them and delete them from the Data Entry form. Mat Assignments and Bracket Numbers may be assigned in either form as well.

Added the ability to assign a "Bracket Number" to each Weight Class in either the Weight Classes and Mats form or the Data Entry form. This is intended to aid in identifying matches by number (Bracket Number + Bout Number = Match Number).

Added the "Bracket Number" field to Bout Slip and Bracket Sheet printouts.

Corrected some file import and export problems with saving the tournament files to a floppy drive and with starting a new tournament.

The import/export procedures no longer use a tab delimited format. The *.txt files saved from revision 1.0 must be changed in order to allow them to be imported into revision 1.01. For instructions on how to do this, email me at rbm@brownbagdata.com

1.0 - Initial