Tournament Manager Baseball Spreadsheets

Baseball Tournament Schedule Excel Templates - You will need Microsoft Excel to read and update the spreadsheets.

These spreadsheets contain macros (for assigning teams). When you open the spreadsheet it will ask you if you want to run Macros. To enable the spreadsheet will require that you answer Enable Macros.

The Excel spreadsheets referenced below are for use with our tournament websites. They are not authorized for use on any other web site.

Notes:

1.This schedule example uses 150 minute game slots. You can lengthen or shorten the game time slots.

2. The template spreadsheet file name denote an abbreviation of the bracket. b_4x4SF_3day.htm means baseball - two 4 team groups with a Semi-Final (S) game, Final (F) Game and the tournament is scheduled over 3 days. When you make your tournament spreadsheet brackets you would use an abbreviation for the actual age group and level instead of the coded file names used herein; e.g. B14uMajor.xls.

3. You will be making a seperate spreadsheet for each tournament bracket. To accomplish first identify the brackets you need. Then click on the appropriate file below, then when prompted by your browser click "Save" and store it on your PC's hard disk. If you are not prompted to "Save" then you will need to save the file via your browser File Menu. You should then make copies of the downloaded files, thus preserving the original (possibly create a new directory on your PC for your tournament sheets. When you get ready to assign teams to the bracket open the.xls file and change the fields "Team 1, Team 2 etc" (in the upper Group Results box) to denote the real team names. The spreadsheet automatically fills in the team name on the schedule below.

4. Abbreviations used on the templates sheets: P - games played, W - win, L - loss, T - tie, RF - runs for, RA - runs against, SO - shutouts, RD - Run differential, G - game number, vs - versus.

5. The "Points Differential" calculation is not limited. If your organization uses this for a tie-breaker then you may wish to limit the maximum differential per game, e.g. 3. Like the "Points Calculation", this field is a "Protected" field and the same comment above (Note 5) applies. Also you may wish to limit the maximum number of "Runs For" per game if used as a tie breaker.

6. Tournaments may wish to use a "coin toss" to determine the home team in the quarter, semi, and final rounds. A notation should be made if you choose to do this to eliminate any confusion.

7. Playing locations (field) are scheduled for 1, 2, 3, or 4 fields depending on the number of teams

8. Most cells on the worksheet are by default "protected". A cell is protected when it generally is not needed to be changed. On the worksheet the only "unprotected cells" are the score cells. By protecting the other cells it alleviates the problem of making an inadvertent error on game day. However, all fields on the sheet can be changed but to do so, the sheet must be first "unprotected". InfoSports recommends that you leave the worksheet "protected" then if necessary to override a calculation then temporarily "unprotect" the worksheet, make the change, then re"protect" the worksheet.

9. The worksheets contained in this workbook have been carefully "hand crafted" for the best possible display and printing. Also, game times have been set to try and make the bracket as "fair" as possible;

10. The spreadsheet is coded such that an additional row can not be added before row 2 and the title must be in Row 1. Note: There is Excel coding that requires the cell locations in R2 to be unchanged.

11. The days on the schedule are labeled Saturday, Sunday, Monday (for 3 day tournaments). The date cells should be changed to the actual date and day of the week when you make up your schedule.

12. Some tournaments may wish to award points for a win or tie. These spreadsheets does not include points. An identical set of spreadsheets which use points per game are shown in the second group below (filenames start with bp_). Instructions for setting the points per game are described below the bracket set.

Bracket set using points per win/tie.

13. Instructions for setting points
On each spreadsheet the scoring system is contained in cells in R2 (row 2). When the files are released the values in R2 are ""hidden"". If you need to change the scoring system follow the following steps:

a. Unhide the R2 by first selecting it, then Format (top bar), select Number tab, select General formatting, then OK. The hidden cells in R2 will now appear.

b. You will see a cells that look like W6 L0 T3 DS1 S1 MS1. The abbreviations are W-Win, L-Loss, T-Tie, DS-Defensive Shutout, S-Points for each score (e.g. goal, run), MS - Most Scores (goals, runs) allowed. The number after the letter is the amount awarded. So by default a win counts as 6, a tie 3, a loss 0, etc.

c. Change the numbers next to the letters to whatever your tournament uses.

d. Reprotect the cells by first selecting R2, then Format cells, select Number tab, select Custom, then clear out the selection field (click on it then select backspace), then enter ;;; three semi-colons, then OK. The 3 semi-colons instruct the Excel cell formatting to hide the cell."