This capability is not active in Multi-Season Mode (Section 15) as individual game by game statistics are combined into composite season statistics.
maintains identifying information for individual games. A separate
Game Schedulepage is generated (Figure 2-8). The
Display / Schedulecommand can be used to view the current Schedule. Games are displayed in ascending order by Game Number. Schedule information can be entered from an external schedule file (Section 5.2.2) or manually (Section 5.2.3).
For each game, the following attributes are maintained:
Home Team Name
Visiting Team Name
Statusfield is optional and can be used for additional identifying information for the game. Examples might be to flag a game as cancelled, rained out, postponed, tournament info, highlights, etc.
A game schedule may be imported into a Team Worksheet via the
File / Import Schedule command or tool
. This command is available as long as the main
Team Namehas been selected from the
General Preferencesoptions. The file can be either an Excel
worksheet or a comma-separated variables
The supported file formats are:
The format is shown in Figure 5-3. Three game entries are shown for simplicity.
The first line of the file identifies the file as an
formatted schedule file with the entry
lines contain optional identifying information in cells
B3respectively for the schedule and will be placed on on the first two lines of the Schedule page (Figure 4-6) if the
Process Titlesoption is selected (Section 22.214.171.124) . If the
B3cell is blank, then the corresponding line on the Schedule page will be unchanged.
Figure 5-3 – Schedule Import File Format With Opponents - SBC
A header line (
A4-F4) describes the cell locations of the attributes of each game. Subsequent lines describe individual game entries. The games can be in any order. A blank line entry (Example: Row 8 in Figure 5-3) terminates the import process.
The rules for the game attributes are as follows:
Positive integer value identifying the game by number.
Date, Time, Field
Attributes that identify the game. These can be any value or blank.
Optional information about the game. This can be any value or blank.
This can be another division or non-division team. If the Opponent team is not known, leave the field blank. . If this is an away game, annotate the game with a leading
NOTE: The Opponent team name cannot be the same as the Main Team name.
Alternatively, the matchups may be entered with the
teams as shown in Figure 5-4. Either the
team (but not both !) must be the main
Figure 5-5 – Schedule Import File Format With Visitor/Home - SBC
Generalformat is a flexible format that automatically detects the locations of the field identifiers. Schedules can be created by a user with a text editor or Excel or via an export file from a third-party scheduling program.
A header line describes the ten possible cell locations of the field identifiers. Subsequent lines describe individual game entries.
Only the minimum field identifiers are necessary. Any others that may appear are ignored. The minimum required field identifiers are as follows:
Team matchups must be specified as well. The
Generalformat can accept one of two team matchup definition methods:
One of these teams should be the main
Team Name. If the matchups are not determined,
leave the field(s) blank.
This can be another division or non-division team. If this is an away game, annotate the game with a leading
‘at ‘prefix. If the
team is not known, leave the field blank.
NOTE: The Opponent team name cannot be the same as the Main Team name.
Generalformats allow for a
number field but this is not required. If not specified, a sequential
number will be assigned to each entry during the import process.
field may be included. information about the game. This can be any value or blank.
An example of the
Generalfile format is shown in Figure 5-6. A truncated schedule is shown for simplicity.
Figure 5-6 – Schedule Import File Format – General
A blank line entry (Example: Row 7 in Figure 5-6) terminates the import process.
If the import file type is
, any valid Excel Date format can be used. If the import file type is
, the Date format cannot have an embedded comma (eg:
MMM DD, YYYY
Import Schedule command will prompt the user for processing options shown in Figure 5-5. The option settings will be preserved for subsequent recalls of the
Figure 5-5 – Schedule Import Processing Options
Select the file format (Section 5.2.2) consistant with the source of your schedule.
With Existing Schedule
This option will add any new games from the import file to the existing schedule.
Entries that match an existing game schedule entry will be overwritten if the team names match. Existing line score will be preserved. If the team names do not match, the user will be prompted for confirmation. If confirmed, the schedule information and will be overwritten and the line score will be cleared.
Append New Games Only
Only games from the file that do not exist in the schedule will be added. Matching games will be ignored.
Overwrite Existing Schedule
Any existing Game Schedule entries and associated line scores (if any) will be cleared. The user will be alerted to confirm this operation.
Add New Teams to Division
Any new team names that do not exist in the Division will be added with a record of 0-0-0. This will only occur for processed schedule entries. This can be useful when setting up a new schedule to automatically populate the divison teams. The number of new teams added will be reported at the end of the import process.
Process Titles (
Controls whether the
entries will be placed on the title lines of the Schedule page. If unchecked, the existing titles on the Schedule page remain unchanged.
The importer will pre-scan the import file for basic formatting errors:
Missing or incorrect labels in Cells
Game numbers that are not positive integer values
Invalid team matchup names
Missing or incorrect labels in first row
Invalid team matchup names
Any errors detected will be reported to the user with the source line where it occurred and a description. The schedule will not be updated.
At the end of the import process, a summary of the processing will be displayed. This can be recalled by the
Display / Import Summary command.
Starting Schedule Sizeand
Updated Schedule Sizevalues reflect the number of games that have schedule entries. This may be less than the total number of active games if some game stats were entered without schedule information.
Figure 5-5 – Schedule Import Processing Summary
Add New Teams to Divisionoption was enabled, a count of the number of new teams added to the Division is diplayed. If there was insufficient space in the Division to add all new teams, an asterisk will be shown next to the count. The user will be alerted to this condition. If this occurs, check the Opponent team names in the source schedule file and the resulting Division area to resolve.
Add New Teams to Divisionoption was disabled, the
New Teams Added:will show as
After importing, an entry may be modified by using
the Edit / Schedulecommand or
toolbar button. Any bulk changes can be made in the source schedule import file and re-imported.
The user can manually create a new entry or modify an existing entry via the
Edit / Schedulecommand or
toolbar botton which will invoke the dialog in Figure 5-6.
Gamelist will show all available games. A game may have a schedule entry only, game stats only or both. If there is a line score for the game, it will be displayed. If not,
will be shown. The current attributes for the game will be displayed. If these are all blank, this indcates that there are player stats for this game but no schedule information.
Figure 5-6 – Edit Schedule Dialog
Changing the game selection via the dropdown list will update the display.The
Previousbuttons can be used as well to sequence through the game list.
The attributes for a specific game can be modified as desired. Any line score or player stats associated with this game are unchanged. The use of the
Statusfield is optional. Some common entries are contained in the dropdown list (Figure 5-7). Hit
Figure 5-7 – Predefined Status Field Values
Use caution when modifying Opponent team or Home Game status for a game that has been played as it may have an impact on an existing line score for that game. The user will be warned if this condition exists.
An entry for a new game which is not in the list can be added by modifying the
field and associated attributes. Hit
Gamefunction will remove the schedule entry for the selected game. This will also remove the line score associated with this game if one had been entered. A check will be performed to see if there are player stats for this game. The user will be asked to verify this operation as it is un-doable. This operation will not delete any player stats for this game. If desired, this can be performed by the
Player / Delete All Player Stats
By Game Rangecommand.
Clear Attributesfunction will reset all of the fields in the dialog to blank entries. The dialog box remains open.
Delete All Gamesfunction will remove all game schedule and associated line score entries. Use caution as this is an un-doable operation. The user will be prompted to confirm this operation. Optionally, the W/L/T records for all teams in the Division Standings can be cleared at this time.
Clear Scorefunction will remove the line score entry for the selected game. Use caution as this is an un-doable operation. The user will be prompted if the line score does not exist.
Delete All Scoresfunction will purge all available line scores. Game attribute information will remain unchanged. Use caution as this is an un-doable operation. The user will be prompted to confirm this operation. Optionally, the W/L/T records for all teams in the Division Standings can be cleared at this time.
If the selected game is the same as the current game displayed in the Box Score, the user will be prompted to update the attribute fields in the Box Score area. The Line Score (if any) will be unchanged.
These options are selected via the
General Preferencescommand (Section 4.1.4).
When checked, the Game Numbers assigned to each game will be displayed in the first column.
If unchecked, these cells and the column title will be blanked out initially. As these cells are unprotected, the user may leave them blank or chose to put other information (eg: an arrow to indicate next game to be played). Subsequent schedule updates will not affect these cells.
Games will appear in ascending order by Game Number regardless of this setting.
When checked, this option automatically recomputes the Division Standings from the scores that have been entered into the Game Schedule. The update will occur anytime there have been changes in the scores including when game(s) have been deleted. This is useful when just tracking the results of the other teams in the division to your team (head-to-head match-ups).
Uncheck this option if you wish to enter the W/L/T values and compute the Division Standings manually.
If checked, a schedule entry without a line score can be marked:
TBP (To Be Played) - If the game date is today or beyond
(Not Reported) - If the game date has passed
Statusfield entry (eg: Rainout) will override the marking.
When checked, the first game in the list that has not been played and not marked with a
Statusfield entry (eg: Rainout) will be highlighted (Example: Game 20 in Figure 2-8).
If there is space, this will be posted in the first empty slot in the
Noticesarea on the Summary page. An example is:
Next Game: Thu Sep 20 9:20PM at Marvin vs. Misfits
The font and styling in the
Noticesblock for this entry is unchanged. This entry will be removed from the
Noticesarea if there are no unplayed games left.
This controls the inclusion of the Schedule page for both printing and web page. If you use a custom formatted schedule via the User Notes page or via a custom external link to a league web site., you may choose to disable this option. The internal schedule page will still be visible and active. Auto-update of division standings and display of game numbers are still functional.
Table of Contents