The Sports Statbook~ For the IBM Personal Computer PC, PC XT, PC AT, PCjr, PS/2 and compatible micros Copyright 1986 by RJL Systems 106 New Haven Avenue Milford, CT 06460 203-878-0376 Trademarks The name The Sports Statbook is trademark of RJL Systems. The name DOS refers to PC-DOS which is a trademark of the IBM Corporation. C o n t e n t s Chapter 1 General Information 1 1.1 Introduction . . . . . . . . . . . . . . . . . . . . 1 1.2 Creating Backups . . . . . . . . . . . . . . . . . . 1 1.3 System Overview . . . . . . . . . . . . . . . . . . . 2 1.4 System Users . . . . . . . . . . . . . . . . . . . . 2 1.5 The Team File . . . . . . . . . . . . . . . . . . . . 2 1.6 Team File Organization . . . . . . . . . . . . . . . 3 1.7 Statistics Maintained . . . . . . . . . . . . . . . . 3 1.8 Data Entry Conventions Used . . . . . . . . . . . . . 3 1.9 Program Operation . . . . . . . . . . . . . . . . . . 5 1.9.1 Useful Keys . . . . . . . . . . . . . . . . . . 5 1.9.2 Printer Preparation . . . . . . . . . . . . . . 5 1.9.2.1 Continuous Form Paper 5 1.9.2.2 132 Column Printouts 5 1.9.2.3 Serial Printers 6 1.9.2.4 Configuring Printer Parameters 6 1.9.3 Screen Output Problems . . . . . . . . . . . . . 6 1.9.4 System Shutdown . . . . . . . . . . . . . . . . 7 1.10 Installation . . . . . . . . . . . . . . . . . . . . 8 1.10.1 Preliminary Steps of Installation . . . . . . . 8 1.10.1.1 Users Without a Fixed Disk 8 1.10.1.2 Fixed-Disk Users 8 1.10.2 Final Steps of Installation . . . . . . . . . . 9 1.10.2.1 Automatic Update Parameter 9 1.10.2.2 Color Monitor Parameter 9 1.10.2.3 Historical Print Parameter 9 1.10.2.4 Paper Height Parameter 10 1.10.2.5 Paper Type Parameter 10 1.10.2.6 Lines per Inch Parameter 10 1.10.2.7 Blank Lines at Top of Page Parameter 10 1.10.2.8 Save Game Stats Parameter 10 1.10.2.9 Save Team Standings Parameter 10 1.10.2.10 User-defined Stat Parameters 11 Chapter 2 Using The Sports Statbook 14 2.1 Getting Started . . . . . . . . . . . . . . . . . . 14 2.2 Adding a Record . . . . . . . . . . . . . . . . . . 18 2.2.1 Team Record . . . . . . . . . . . . . . . . . 18 2.2.2 Player Record . . . . . . . . . . . . . . . . 19 2.2.3 User-defined Record . . . . . . . . . . . . . 20 2.2.4 Final Points When Adding Records . . . . . . . 21 2.3 Changing a Record . . . . . . . . . . . . . . . . . 22 2.3.1 Deleting a Record . . . . . . . . . . . . . . 24 2.4 Displaying Team/Club Stats . . . . . . . . . . . . 24 i 2.5 Recording Game Statistics . . . . . . . . . . . . . 25 2.6 Changing Game Statistics . . . . . . . . . . . . . 27 2.7 Displaying Cumulative Team/Club Game Stats . . . . 27 2.8 Clearing Yearly Statistics . . . . . . . . . . . . 27 2.9 User-defined Reports . . . . . . . . . . . . . . . 29 2.9.1 Defining a Report . . . . . . . . . . . . . . 29 2.9.1.1 Report Type 30 2.9.1.2 Player Category 30 2.9.1.3 Sort by Stat Nos. 30 2.9.1.4 Sort Order 31 2.9.1.5 Qualify Sort by Stat No. 31 2.9.1.6 80 or 132 Columns 31 2.9.1.7 Line Spacing 31 2.9.1.8 Report Headings 31 2.9.1.9 Stat No. for Print Pos. 1-15 32 2.9.1.10 Calculated Stats 32 2.9.2 Changing a Report . . . . . . . . . . . . . . 34 2.9.3 Printing a Report . . . . . . . . . . . . . . 35 2.10 Printing Team Standings . . . . . . . . . . . . . 36 2.11 Printing Team Rosters . . . . . . . . . . . . . . 36 2.12 Saving Statistics . . . . . . . . . . . . . . . . 36 2.13 Creating a Backup Diskette . . . . . . . . . . . . 37 2.14 Restoring the Team File . . . . . . . . . . . . . 39 2.15 Changing a Team Name . . . . . . . . . . . . . . . 40 2.16 Changing a Conference Name . . . . . . . . . . . . 40 Appendices A-B ii The Sports Statbook C h a p t e r 1 G e n e r a l I n f o r m a t i o n 1 . 1 I n t r o d u c t i o n Welcome to The Sports Statbook. We sincerely hope our product will be most useful in providing you a means of maintaining player and team statistics for hockey, soccer, volleyball as well as any other sport not normally having to maintain an extensive amount of statistics. For baseball, football and basketball statistics, you will want to use our Baseball Statbook, Football Statbook and Basketball Statbook systems. The Sports Statbook has been designed to significantly reduce the time and effort in keeping statistics. The system is easy to use and yet very versatile. Some users of the system include Hockey Central of Philadelphia and the LA Kings (R). 1 . 2 C r e a t i n g B a c k u p s Before using the system, it is important to back up (make a copy of) all master diskettes of The Sports Statbook to blank formatted diskettes. One-drive-system users must use the DISKCOPY command; all other users should use the COPY *.* command to accomplish these backups (refer to your DOS manual if necessary). Note on a non-IBM computer, the DISKCOPY command may be unsuccessful due to disk format differences. If you experience such a problem, use the COPY command instead for each file on a diskette. If you are going to use The Sports Statbook for more than one sport, keep your statistics separate by making a team file diskette (disk #3) for each sport. To identify each diskette, use an appropriate label. Once backup copies are made, use the backup diskettes as working copies and store the original master diskettes in a safe place. Never use the original master diskettes as working copies. Use the original master diskettes only to make additional working copies should that event ever become necessary. You should also back up your team file every time you make file updates (additions, changes or deletions). A backup facility is provided in the main programs. This facility will be discussed in detail under section 2.13. It is recommended that you back up your team file with this facility as well as with the DOS COPY command. Having a backup copy of the team file is essential for recovering lost data (usually caused by human error) or a damaged file. In short, creating backups represents a prudent and sound data processing practice. RJL Systems 1 The Sports Statbook 1 . 3 S y s t e m O v e r v i e w The Sports Statbook is comprised of 3 diskettes. Disks #1 and #2 contain the programs of the system. Disk #3 contains your team and parameter files. The team file is used to store all pertinent player and team information. The parameter file consists of a number of program variables and parameters to define your statistics. Once the system is installed (section 1.10), you must first add records to the team file using program SS2. Any year-to-date and/or historical player statistics that you have maintained manually or on another computer system can be inputted when adding records. After each game is played, you will enter the game statistics in the record game function of program SS. Year-to-date and historical statistics will be automatically updated unless you chose otherwise when installing the system. Displaying/changing player information is done in the change/display game routine and the change/display player routine of programs SS and SS2 respectively. Printing statistics is done in program SSPRINT. Printing rosters and team standings is done in SSPRINT2. Before the beginning of a new season, you will have to clear all year-to-date statistics using the clear yearly statistics routine of program SS. 1 . 4 S y s t e m U s e r s The Sports Statbook can be used by virtually any team that plays in a sports league. Pro and semipro teams, high school and college teams, company-sponsored teams, etc. are some of the organizations which can benefit by using the system. Moreover, the system can be used by those persons who must keep track of teams within a league, league statistics or team standings. 1 . 5 T h e T e a m F i l e The cornerstone of the system will be your team file (on disk #3) which you maintain using The Sports Statbook. Records can be added, changed and deleted as your needs require. The system comes with the team file already created so that you can start adding records immediately. One point concerning the team file should be emphasized now: to avoid damage to your team file, always exit The Sports Statbook before executing another program, turning off your computer or performing a system restart (CTRL-ALT-DEL). 2 RJL Systems The Sports Statbook 1 . 6 T e a m F i l e O r g a n i z a t i o n The team file actually consists of two files on disk: a data file named SSTEAM.FIL and an indexed file called SSTEAM.KEY. The indexed file is structured to point to records in the data file thereby enabling rapid access and display of individual records. The size of each record (including the key portion) is approximately 600 bytes. The file comes with one dummy record with all D's in the team name field. After adding a few records of your own, you should delete this dummy record. 1 . 7 S t a t i s t i c s M a i n t a i n e d The Sports Statbook maintains three types of statistical records: unlimited player records, one team record per team and unlimited user- defined records. Player records consist of games played and twenty-five user-defined cumulative statistics. The team record consists of games played, wins, losses, ties and fifteen user-defined cumulative statistics. In addition, three user-defined calculated statistics per report can be defined. User-defined records consist of six user-defined statistics. 1 . 8 D a t a E n t r y C o n v e n t i o n s U s e d For certain data entry errors, such as the typing of a nondigit into a numeric field, a COBOL (the programming language in which The Sports Statbook is written) editing feature will prevent such input and provide you a warning by beeping. Typos and other errors can be corrected with the aid of the editing keys: the cursor control left and right keys, the backspace key, the space bar and the F5 function key used as a substitute for the backtab key (the tab key plus the shift key). If you detect an error in a field before pressing the enter key, use the appropriate cursor control key or the backspace key for positioning and then simply retype the erroneous character(s). Note the backspace key is not always operative in an alphanumeric field -- use the cursor control keys and the space bar instead. To correct an error in an already entered field, use the F5 function key to move the cursor to the field in error then make the necessary change(s). When entering numeric data, integers or the integer part of a number will move from right to left. When entering a number with a decimal, the RJL Systems 3 The Sports Statbook integer portion is entered first followed by a decimal point (period) which will move the cursor to the right of the decimal point so that you can enter the decimal portion. Use the enter key to enter data. In most cases, the cursor will move automatically to the next field to be entered once a field is filled thus eliminating the need to press the enter key. 4 RJL Systems The Sports Statbook 1 . 9 P r o g r a m O p e r a t i o n 1.9.1 Useful Keys The ESC key (escape key) is used to exit from the main menus of The Sports Statbook. This key also can often be used to exit a field on a message line. Use this key if you have made a mistake in entering a menu selection or if you just wish to discontinue inputting data for any reason. In those screens where entering numeric data might cause the accidental hitting of the ESC key, the F7 & F10 keys are used in lieu of the ESC key to exit from the screen. Pressing the SCROLL/BREAK key while the CTRL key is depressed will cancel the execution of a program and return you to DOS. You can use this method to discontinue the printing of a listing or to exit from an unrecoverable situation. Always try using the ESC key first, however, before resorting to this method. Avoid the use of the system restart keys, CTRL-ALT-DEL, to exit the system since this method may cause serious damage to your team file. 1.9.2 Printer Preparation 1.9.2.1 Continuous Form Paper To assure that the printing of each page of a report starts at the top of a page, you must make sure that the paper is initially positioned at the top of a page. Set the on-line button on your printer to the off position. Then press the form feed button to position the paper to the top of a page. If the paper fails to move to the top of the page (the horizontal perforation in the paper should be aligned slightly below the top of the ribbon), you will have to position the paper manually with the printer's roller knob (refer to your printer manual for the correct method to do this alignment). If you align the paper manually, you should first turn the printer off before adjusting the paper and then turn it back on after alignment is made. 1.9.2.2 132 Column Printouts In The Sports Statbook, player statistics can be printed out in full 132 columns or 80 columns. If you desire 132 column printouts, you will need a printer that supports 132 column printing in either standard or compressed mode. Many eighty column printers, such as IBM's and Epson's, support 132 column printing in compressed mode. To print in compressed RJL Systems 5 The Sports Statbook mode on an 80 column printer, you must execute the following DOS MODE command before you attempt any printing: MODE LPT1:132. This MODE command must be executed while your printer is on and in ready status and your DOS diskette in the current drive. Alternatively, you can enter the following command while in BASIC to print in compressed format: LPRINT CHR$(XX); where XX represents the decimal value for the compressed-mode printer control code which you should be able to find in the appendix section of you printer manual. For most printers this value is 15. 1.9.2.3 Serial Printers Special steps must be taken if you have a serial printer. Two MODE commands must be executed before attempting any printouts (place your DOS diskette in the current drive before executing these commands). One MODE command is needed to initialize the asynchronous communications adapter and the other MODE command is needed to redirect parallel printer output to the asynchronous communications adapter. An example of the required commands is listed below. MODE COM1:30,P MODE LPT1:=COM1 The parameters listed in the above example may not apply to your particular situation. Refer to your DOS and printer manuals for complete information. To automatically have the system execute these commands, you may want to create an AUTOEXEC.BAT file on your DOS diskette which includes these two MODE commands (see your DOS manual if necessary). 1.9.2.4 Configuring Printer Parameters You must make sure that the paper height and lines per inch parameters on the parameter file are properly set to your specific requirements. If you are using single sheet paper, your must also set the paper type parameter on the parameter file to S. See installation (section 1.10) on how to make changes to program parameters. 1.9.3 Screen Output Problems Certain monitor/display adapter configurations may cause screen output problems such as the lack of a cursor. Users experiencing such dif- ficulties will have to use the MODE CO80, MODE BW80 or MODE MONO command to properly set their monitor before using the system. 6 RJL Systems The Sports Statbook 1.9.4 System Shutdown Always exit from The Sports Statbook before executing another program, turning off your computer or performing a system restart (CTRL-ALT-DEL). Failure to do so could result in serious damage to your team file. RJL Systems 7 The Sports Statbook 1 . 1 0 I n s t a l l a t i o n Before attempting to install the system, make sure you have made backup copies of all master diskettes that come with The Sports Statbook and are using a set of working-copy diskettes only to install the system. 1.10.1 Preliminary Steps of Installation 1.10.1.1 Users Without a Fixed Disk The Sports Statbook is a three disk system with your team file residing on disk #3. Copy SSTEAM.FIL, SSTEAM.KEY, SSPARM.FIL, SSBACK.FIL, SSMENU.EXE and COBRUN.EXE from disk #2 to a blank formatted disk. Mark the third disk '#3 TEAM FILE'. After making disk #3, erase SSTEAM.FIL, SSTEAM.KEY, SSPARM.FIL and SSBACK.FIL from disk #2. All programs of The Sports Statbook are placed into computer memory in an area where DOS stores its COMMAND.COM program. Every time one of the programs of The Sports Statbook ends, COMMAND.COM must be placed back into its original location in memory by reinserting the DOS diskette in the current drive. To avoid this situation, you should copy COMMAND.COM from your DOS diskette to each diskette of The Sports Statbook. 1.10.1.2 Fixed-Disk Users The diskettes of The Sports Statbook should be copied to your fixed disk. Before performing this copy, you should first make sure that there are no common (duplicate) file names between the files on The Sports Statbook diskettes and the files on your fixed disk. Use the DIR command (refer to your DOS manual if necessary) to check for duplicate names. If there are duplicate names, you should rename the files with the duplicate names on your fixed disk using the RENAME command (refer to your DOS manual if necessary) to prevent their being destroyed when the copy takes place. Another choice you have is to copy The Sports Statbook diskettes to a separate directory on your fixed disk. Use the DOS MKDIR and CHDIR commands (see your DOS manual if necessary) to accomplish this task. Once you are ready to do the copying, place one of The Sports Statbook diskettes in drive A and type and enter one of the following commands just to the right of the DOS prompt, A>, to accomplish this transfer. COPY *.* C: or COPY *.* D: whichever drive applies. Perform the same copy procedure for the other diskette. 8 RJL Systems The Sports Statbook Because all programs now reside on your fixed disk, you can disregard any instruction in this guide or from the system itself referencing the inserting of a diskette of The Sports Statbook. Once you have finished with the copy procedure, change the current drive to your fixed-disk drive by typing and entering C: (or D:) next to the A> prompt. 1.10.2 Final Steps of Installation To complete the installation of The Sports Statbook, place disk #1 in the current drive (fixed-disk users remember to disregard inserting any diskettes) and type and enter SS3. After the initial copyright screen is displayed and you enter the drive the team file (disk #3) is on (A or B for nonfixed-disk users, C or D for fixed-disk users), you will see the main menu of the SS3 program. Press F1 to change/display program variables. The change/display parameter screen will now be displayed. To change a parameter, move the cursor to the desired parameter using the enter key and then enter the new data. Once you have finished making all required changes, press the F1 function key to record the changes to the file. You can return to the SS3 main menu by pressing the F7 function key. An explanation of each parameter is described below. 1.10.2.1 Automatic Update Parameter This parameter is initially set to Y. A Y indicates that year-to-date and historical statistics will be automatically updated when entering game information -- the record game and change game functions in program SS. Changing this parameter to an N will prevent automatic updating. 1.10.2.2 Color Monitor Parameter This parameter tells the system whether you are using a color or black and white monitor. It is initially set to N. If you are using a color monitor, set this parameter to Y. If this parameter is set to Y and you switch back to using a noncolor monitor, The Sports Statbook may become unusable. To avoid this situation, change this parameter to N before switching to a noncolor monitor. 1.10.2.3 Historical Print Parameter This parameter is initially set to F. An F represents a full file listing when printing historical statistics. If you want only active RJL Systems 9 The Sports Statbook players printed, change the value to A. If you want only inactive players printed, change the value to I. 1.10.2.4 Paper Height Parameter This printer parameter is set to 11 representing 11 inches for standard letter-size paper. If you are using paper for your printouts of 8.5 inches or any other size, this parameter must be changed accordingly. You may have to measure the paper height to determine the correct number of inches. 1.10.2.5 Paper Type Parameter This parameter is set to C representing continuous form paper. If you are using single sheet paper and want the print programs to pause before printing so you can insert a sheet of paper in your printer, set this parameter to S. 1.10.2.6 Lines per Inch Parameter This printer parameter is set to 6 representing six lines per inch. If your printer is not set up to print six lines per inch, which is standard for most printers, then change this parameter to the proper value. Al- ternatively, you can change your printer setting by using the DOS MODE command. For more information on the MODE command, refer to your DOS manual. 1.10.2.7 Blank Lines at Top of Page Parameter This parameter is initially set to 1 meaning one blank line will be printed at top of each page of a printout. If you want more space at the top of your printouts, set this parameter accordingly. 1.10.2.8 Save Game Stats Parameter This parameter is initially set to N. An N means that the system will not remind you to save the prior game statistics to disk (SSSAVE) when recording statistics for a new game. If this parameter is set to Y, a reminder will be given by the system. Keep this parameter set to N if you do not want to save game statistics. 1.10.2.9 Save Team Standings Parameter This parameter is initially set to N. If you want team standings to be saved to disk when printing team standings, set this parameter to Y. 10 RJL Systems The Sports Statbook 1.10.2.10 User-defined Stat Parameters Most of the statistics maintained by The Sports Statbook are user- definable. There are twenty-five user-defined player statistics and fifteen user-defined team statistics which are represented by the enclosed parentheses. The digit to the right of an enclosed parentheses represents the decimal place desired for a statistic, which should always be set to zero except in rare cases. To define a statistic, simply enter an up to three character abbreviation for the statistic in the leftmost unfilled enclosed parentheses shown on your screen. Always begin an abbreviation in the first position within an enclosed parentheses. Once defined, statistics will appear on screen displays and printouts when specified. Additional statistics can be defined until all enclosed parentheses are filled. Note you do not have to define all your statistics the first time you install the system but can come back and define additional statistics at a subsequent time. RJL Systems 11 The Sports Statbook Example 1 The below illustration shows how the first fifteen player stat parameters should look after defining the following player statistics for a hockey team: goals (GL ), assists (A ), penalties (PEN), shots (SHT), +- (+- ), penalty minutes (PMI), goal tending minutes (MIN), goals allowed (GLA), empty net goals (GLE), shutouts (SHO) and saves (SAV). DEFINABLE PLAYER STATS 1-5 (GL )0 (A )0 (PEN)0 (SHT)0 (+-)0 DEFINABLE PLAYER STATS 6-10 (PMI)0 (F1 )0 (F2 )0 (F3 )0 (MIN)0 DEFINABLE PLAYER STATS 11-15 (GLA)0 (GLE)0 (SHO)0 (SAV)0 ( )0 For easier data entry when adding and recording statistics, we separated nongoalie and goalie statistics with the statistics F1, F2 and F3 which can be used for additional/future nongoalie statistics. Note all user-definable statistics are cumulative. Calculated statistics like points and shooting percentage should be defined on the report you want them to appear on (section 2.9). After defining your statistics, you should annotate the name of the statistics and their abbreviations in the applicable tables found in Appendix A. The tables can then later be used as an aid when defining your reports. You should also annotate each statistic's abbreviation on the data entry forms also found in appendix A. The data entry forms can be used when adding and recording player and team statistics and should lessen the chance of data entry errors. A sample of a player statistical table and a data entry form using the statistics we just defined for our hockey team can be found at the end of Appendix A. Note: Please remember to press the update key, the F1 function key, to record all changes made to program parameters. 12 RJL Systems The Sports Statbook RJL Systems 13 The Sports Statbook C h a p t e r 2 U s i n g T h e S p o r t s S t a t b o o k 2 . 1 G e t t i n g S t a r t e d You should now be ready to start using The Sports Statbook. The system is entirely menu-driven providing the user with a clear and understandable set of options to choose from. In addition to the main menus, each function screen will have its own menu called the selection line(s) appearing near the bottom of the screen similar to the one shown below. F1 -> UPDATE F4 -> NEXT PLAYER F5 -> PREVIOUS ENTRY F7 -> MAIN MENU The function key assignments are standard from screen to screen. For instance, the F1 function key appearing on a selection line will perform the update routine, the F5 function key will move the cursor to a previously entered field, the F7 function key will return you to the main menu of a program and so forth. The first thing you want to do is to add players to the team file with the SS2 program. Insert disk #1 in the current drive and type and enter SS2. After the characters SS2 are entered, you will see a screen which should look similar to the one that is shown on the next page. Note: You can also access most of the functions of the system using a master menu. Use the master menu whenever you forget the function(s) a particular program performs. To obtain the master menu, just insert one of your disks in the current drive and type and enter SSMENU at the DOS prompt. A master menu will appear. To execute any of the functions in the menu, just insert the proper disk in the current drive and then type and enter the number corresponding to the function you want to perform. For example, if you want to add players to your team file insert disk 1 in 14 RJL Systems The Sports Statbook the current drive and type and enter 2 or if you want to print team standings, insert disk 2 in the current drive and type and enter 4. For users with color monitors, the master menu can only be obtained in color when executed from disk #3. RJL Systems 15 The Sports Statbook The Sports Statbook Copyright l986 by RJL Systems Remove disk 1 if necessary. Type the letter of the drive containing the parameter and team files. Insert disk #3 in the desired drive then type the letter of the drive where you just inserted the diskette. Note: Never remove the diskette containing the team file (disk #3) until you end execution of a program or the system lets you know the diskette can be removed. 16 RJL Systems The Sports Statbook Pressing any key other than the ESC key will produce the main menu screen of the SS2 program that will look similar to the one shown below. The Sports Statbook PRESS DESIRED KEY MAIN MENU F1 ADD TEAM/PLAYER NAMES & STATS F2 CHANGE/DISPLAY TEAM/PLAYER STATS F3 DISPLAY CUMULATIVE TEAM/CLUB STATS F4 RECORD GAME STATS (SS) F5 CHANGE PARAMETERS/DEFINE STATS (SS3) F6 DEFINE A REPORT (SSDEFINE) F7 PRINT A REPORT (SSPRINT) F8 CREATE BACKUP ESC RETURN TO DOS As the above menu indicates to add teams and players, press the F1 function key. The other functions of the SS2 program will be discussed later. RJL Systems 17 The Sports Statbook 2 . 2 A d d i n g a R e c o r d After pressing the F1 function key while in the SS2 main menu, you will see a screen that will look similar to the one shown below. ADD STATISTICS TEAM NAME: STAT TYPE: PLAYER NAME/PAGE ID: POS: NO: YRS: PLAYER CATG: STATUS: INACTIVE YEAR: DESC: YEAR-TO-DATE HISTORICAL Statistics entered here F1 -> UPDATE F5 -> PREVIOUS ENTRY F7 -> MAIN MENU F8 -> CREATE BACKUP F10 -> TO DOS When adding records, sequencing of records is based on ASCII code order. These codes can be found in the appendix section of your BASIC manual. Note that upper-case and lower-case letters are assigned different values. For ease of use and readability reasons, it is recommended that you enter all letters in upper-case format by pressing the CAPS lock key. Data entry forms are provided in Appendix A to aid you in entering your data and it is recommended you use them. The system will arrange all team statistical records in ascending order by team name. Under each team, records are further arranged in ascending statistic type as follows: player statistics (PS) first and user-defined records (TT) last. Under each statistic type, records are further arranged in ascending player name/page id sequence. 2.2.1 Team Record Before you can add players to the team file, you must first add the team statistical record. Enter the team name in the team name field, followed by TS in the statistic-type field. The conference field is optional. If 18 RJL Systems The Sports Statbook you are keeping multiple teams and want to obtain player statistics printed by conference, enter an up to four character conference identifier for the conference the team belongs to. The division field is also optional. If you are keeping multiple teams and want to print team standings, enter an up to four character identifier for the division the team belongs to. If you have any year-to-date and historical team statistics, you can enter them in the fields shown on your screen. After entering your year- to-date and historical team statistics or if you do not have any statis- tics, just press the F1 function key to add the team statistical record to the team file. Note any statistic that you did not enter will be set to zero. 2.2.2 Player Record Player statistics can now be added for the team. The only fields that are required to be entered for a player are the team name, statistic type (PS) and the player name. Each player name under a team must be unique on the file, i.e., duplicates are not allowed. If you have two players for a team with the same name, add an initial to one of the players' names to make the name unique. Enter the last name, then the first name (e.g. SMITH, JOHN). For the position field, you may enter a two character abbreviation of a player's primary position (e.g. C for center). The next field is a three character player number field. The fifth field represents the number of years the player has been on the team. The next field is the player category field. Its primary purpose is to categorize players when printing statistics. In our hockey team example, goalies and nongoalies can be categorized by placing a GL for goalies and NG for nongoalies in this field. Categorizing players is required if you want just a certain group of players to appear on a particular player report (also see section 2.9.1.2). The seventh field on the screen is the status indicator. This field is automatically set to A meaning an active player. If the player you are entering is a former member of the team, you should reset this indicator to I meaning an inactive player. The eighth field on the screen is the inactive year indicator. If the player is inactive (status = I), then you must enter either a C or P in this field. A C means that the player has become inactive in the current year (season) and therefore will appear on year-to-date printouts. A P means that the player became inactive in a prior year and will not appear on year-to-date printouts. The last field that appears at the top of the screen is a twenty-five character description field. You can enter a player's height, weight or any other information you want in this field. Any data entered in this field will appear on roster printouts. The statistical fields appear next. Any past statistical data which you may have kept manually or on another computer system may be entered if RJL Systems 19 The Sports Statbook desired. Year-to-date information represents current seasonal statis- tics. Historical statistics represent lifetime or career statistics. Once all desired information is entered, you must press the update key, the F1 function key, to physically add the record to the team file. A record is also added without pressing the F1 function key when you enter data in the last field on the screen. In either case, a message will appear at the bottom of the screen informing you that the add was completed. After a record is added, you can continue adding more records or exit the screen using either the F7 or F10 function key as shown on the selection line. If you are adding statistics for more than one team, be sure to change the team name to the new team name before adding additional records. 2.2.3 User-defined Record User-defined records can be added to your team file by placing a TT in the statistic-type field followed by a page identifier. User-defined records are not updated automatically by the system when entering game information. These records must be updated manually using the change/display team/player function (section 2.3). Also the print programs do not print out user-defined records. If you need to print out user-defined records, use the Shift and Prtsc keys to print out these records. Additional team or player statistics which can not be kept on team or player statistical records can be maintained on these records. After placing a TT in the statistic-type field, a user-defined record will be displayed on your screen. The description of the statistic is entered where underlines are shown. The statistical value is entered where zeros are shown. There are six statistics that can be entered per page. After entering all desired data, press the F1 function key to actually add the record to the team file. After a record is added, you can continue adding records or exit the screen by using either the F7 or F10 function key as shown on the selection line. Note if you want user-defined records for a team to appear in numerical sequence, the numbers you use as page identifiers must all have the same amount of digits as the largest number you plan to use. This means that you must use leading zeros for any number not having the same amount of digits as your largest number (e.g. 001 ... 050 ... 999). The numbers must also begin in the same position in your identifier field for all pages. An example of information that can be kept on a user-defined record is given on the next page. 20 RJL Systems The Sports Statbook Example 2: To keep track of how many goals were scored in each period. TEAM NAME: CARDINALS STAT TYPE: TT PLAYER NAME/PAGE ID: GOALS FIRST PERIOD 145 SECOND PERIOD 127 THIRD PERIOD 31 2.2.4 Final Points When Adding Records Special care must be taken when adding additional records for a team at a subsequent time. You must make sure the team name is spelled exactly as it was spelled when records for the team were being added for the first time. If the team name is not spelled exactly the same, the system will provide an error message stating the team statistical record must be added first. If you get this message, it means you have spelled the team name incorrectly. Another important point to remember is that if you are adding several records, you should create periodic backups of the team file as a safety measure. To invoke the backup routine, simply press the F8 function key. DOS does not truly add a record to disk each time an update takes place. DOS first stores records in an area in memory called a buffer. When the buffer becomes full or when you end execution of the program by recommended methods, DOS takes the records in the buffer and adds them to disk. The same is true when records are changed or deleted. That's another reason to always exit The Sports Statbook before turning off your computer and is also why you should never remove the diskette containing your team file, normally disk #3, until you end execution of a program or the system lets you know whether a diskette can be removed. A last point is if you add many records, it is recommended that backing up (section 2.13) and restoring (section 2.14) your team file be performed in order to organize the team file into its most efficient structure on disk. RJL Systems 21 The Sports Statbook 2 . 3 C h a n g i n g a R e c o r d Updating year-to-date and historical statistics is normally done automat- ically using the record game and change game routines. However, if you added a record with the wrong statistical information, discovered that you entered some prior game information incorrectly or need to modify an alphanumeric field such as the status field, you can use this function to make the necessary changes. This function must also be used to update user-defined records after a game is played since these records are not updated upon recording game information. Use this function to delete records also. You use program SS2 to change/display team/player information. After inserting disk #1 in the current drive and obtaining the main menu of the SS2 program, press the F2 function key to display or make changes to a record. A screen will appear and look similar to the one shown in the add player screen (section 2.2) except for the addition of the find next player option (F4) in the selection line. Find the desired record by typing the name of the team, the statistic type (PS, TS or TT) and player/page id whose record you want to change. The full name of the team, the statistic type and the first few letters of the player's name/page id should be sufficient for the program to find the record. If it isn't, use the F4 function key or retype the player's name/page id in full. To start at the first record for a team, you need only enter the team name followed by blank (no) information in the statistic-type and player-name fields. Remember that the letters of the team and player's name/page id must be typed as they were typed when they were added to the file. If the names as they appear on the team file consist of all upper-case letters, then you must enter all upper-case letters (CAPS lock key set) in order for the system to find the required record. Once you have located the desired record, keep on pressing the enter key until the cursor is positioned at the field you want to change, then enter the new data. In order to physically change the record, press the update key, the F1 function key. After a record is changed, you can perform the same procedure to change another record or exit the screen using either the F7 or F10 function key as shown on the selection line. Due to the structure of the team file, the team, statistic-type and player-name/page id fields can not be changed. If the statistic-type and/or player-name/page id fields require changes, the record must be deleted and then added to the file with the correct information using the add record function (section 2.2). Should only the team name require a 22 RJL Systems The Sports Statbook change, a global copy of all records for a team can be made using the global team name copy function (see section 2.15). RJL Systems 23 The Sports Statbook 2.3.1 Deleting a Record Deleting unwanted records on the team file also takes place in the change record screen. After displaying the record you want deleted, enter a D in the status field to invoke the delete routine. Pressing a D again in response to the message that will appear at the bottom of the screen will logically delete the record from the file. The system will not recognize the record but the record will still physically remain on the file. To physically remove deleted records, the team file must be reorganized -- a backup created and then the team file restored. Refer to the sections on creating backups and restoring the team file (sections 2.13 & 2.14). A reorganization should only be necessary if you delete numerous records or add many records. The dummy record with all D's in the team-name field that came with the team file should be deleted using this function after you have added a few records of your own to the team file. 2 . 4 D i s p l a y i n g T e a m / C l u b S t a t s Team statistics consist of those statistics on the team statistical record (TS) and cumulative player statistics. A number of cumulative year-to-date player statistics can be displayed on your screen. You use program SS2 to display cumulative year-to-date statistics. After inserting disk #1 in the current drive and obtaining the main menu of the SS2 program, press the F3 function key to display cumulative team/club year-to-date statistics. After entering a team name, the program will accumulate and display these statistics. 24 RJL Systems The Sports Statbook 2 . 5 R e c o r d i n g G a m e S t a t i s t i c s Using this function will enable you to record game statistics. Before using this function, all players you plan to record statistics for and are not currently on the team file should be added to the team file. Note that since this function will reset all prior game statistics to zero, any player or team game statistics that you want printed or saved to disk (SSSAVE) should be done before using this function. You use program SS to record game information. Insert disk #1 in the current drive and type and enter SS. After obtaining the main menu of the SS program, press the F1 function key to record game statistics. Pressing the F1 function key will produce a screen that looks similar to the one shown below. RECORD GAME STATISTICS Press Y to clear all team game stats or any other key to exit. Typing the letter Y will clear all teams' prior game statistics so that statistics of a new game can be entered. After the statistics are cleared and you have pressed any key, you will see a screen which should look similar to the one shown on the next page. RJL Systems 25 The Sports Statbook RECORD GAME STATISTICS TEAM NAME: STAT TYPE: PLAYER NAME/PAGE ID: Game Statistics Entered Here F1 -> UPDATE F4 -> NEXT PLAYER F5 -> PREVIOUS ENTRY F7 -> MAIN MENU F8 -> CREATE BACKUP F10 -> RETURN TO DOS To record team statistics, just enter the team name and a TS in the stat-type field. To record statistics for a player, you must enter data for the following three fields: the team name, a PS in the stat-type field and the player name. Entering only the first few letters of the player's name is all that is usually needed in order for the system to locate the desired record. To start recording statistics from the first player under a team, enter the team name in the team-name field, then enter spaces (no data) in the stat-type and player-name fields. Remember that letters of the team and player names must be typed as they were typed when they were added to the file. If the names as they appear on the team file consist of all upper-case letters, then you should enter all upper-case letters (CAPS lock key set) in order for the system to find the required record. Once the desired record is displayed on the screen, enter all statistics that you are maintaining. The first statistic is the game indicator. If the player played in the game, this indicator must be set to Y in order for the system to recognize any statistics you enter and to update year- to-date and historical statistics. Once you have finished entering the statistics for a player, you must press the update key, the F1 function key, for the information to be recorded to the file. Recording also takes place after entering data in the last field on the screen. Pressing the F1 function key causes the updating of game information and also the updating of year-to-date and historical figures if the automatic update indicator on the parameter file is set to Y. As a safety measure, you should make periodic backups while recording game statistics. Simply press the F8 function key to invoke the backup routine. After all of the teams' game information is entered, you can use the change/display game function (section 2.6) to browse through the file (F4 key) and see if 26 RJL Systems The Sports Statbook any mistakes were made. If you detect any errors, they can be corrected in the screen where the error is found. Mistakes in entering game information can also be detected using the display cumulative team/club game function (section 2.7). Note that once game statistics are updated they can only be changed using the change/display game function. Another point is that once you exit the record game routine you should not return to this function if you did not finish recording game statistics or forgot to update any records since all game statistics that you did enter will be cleared. Use the change/display game function instead to finish recording game sta- tistics. 2 . 6 C h a n g i n g G a m e S t a t i s t i c s Using this function will enable you to correct any errors in game sta- tistics or to finish recording statistics not entered in the record game function. You use program SS to change/display game information. After inserting disk #1 in the current drive and obtaining the main menu of the SS program, press the F2 function key to display or make changes to game statistics. Enter information in the same fashion as the record game function. After changes for a record have been entered, press the F1 function key to update the record on the file. You can continue chang- ing records or exit the screen by pressing either the F7 or F10 function key as shown on the selection line. 2 . 7 D i s p l a y i n g C u m u l a t i v e T e a m / C l u b G a m e S t a t s Team game statistics consist of those statistics on the team record (TS) and cumulative player game statistics. A number of cumulative player game statistics can be displayed on your screen. You use program SS to display cumulative game statistics. Displaying cumulative game statistics gives you the opportunity to see if you have entered most of your player game statistics correctly. After inserting disk #1 in the current drive and obtaining the main menu of the SS program, press the F3 function key to display cumulative team/club game statistics. After entering a team name, the program will accumulate and display these statistics. RJL Systems 27 The Sports Statbook 2 . 8 C l e a r i n g Y e a r l y S t a t i s t i c s Clearing year-to-date statistics will be necessary every year before the beginning of a new season. Using this function will zero out all year-to- date figures. If you want to save year-to-date figures on disk for his- torical reasons, you can copy the files listed below to a separate diskette (or directory) with its proper label before you perform the clear routine. SSTEAM.FIL, SSTEAM.KEY, SSBACK.FIL & SSPARM.FIL If you save yearly statistics, the diskette containing the copied files can be used by the system whenever desired. Additionally, you may save the yearly statistics to disk in ASCII format (refer to program SSSAVE under section 2.12). You use program SS to clear yearly statistics. After inserting disk #1 in the current drive and obtaining the main menu of the SS program, press the F4 function key to clear year-to-date statistics. Pressing Y in response to the message that you will receive will clear the yearly sta- tistics. 28 RJL Systems The Sports Statbook 2 . 9 U s e r - d e f i n e d R e p o r t s 2.9.1 Defining a Report Before a report can be printed by the SSPRINT program, you must create a report file defining the statistics you want to appear on a report, the sort criteria and other pertinent information. Defining a report is done in SSDEFINE. Place disk #2 in the current drive and type and enter SSDEFINE. After the main menu is displayed, press the F1 function key to create a report file to define your report variables. The following screen will appear. CREATE REPORT Enter report file name _ REPORT TYPE/PLAYER CATG P SORT BY STAT NOS. 30 30 SORT ORDER (A/D) D QUALIFY SORT BY STAT NO. 30 80 OR 132 COLUMNS 80 LINE SPACING 1 REPORT HEADING 1 ******************** REPORT HEADING 2 ******************** STAT NO. FOR PRINT POS. 1 30 STAT NO. FOR PRINT POS. 2 30 STAT NO. FOR PRINT POS. 3 30 STAT NO. FOR PRINT POS. 4 30 STAT NO. FOR PRINT POS. 5 30 STAT NO. FOR PRINT POS. 6 30 STAT NO. FOR PRINT POS. 7 30 STAT NO. FOR PRINT POS. 8 30 STAT NO. FOR PRINT POS. 9 30 STAT NO. FOR PRINT POS. 10 30 STAT NO. FOR PRINT POS. 11 30 STAT NO. FOR PRINT POS. 12 30 STAT NO. FOR PRINT POS. 13 30 STAT NO. FOR PRINT POS. 14 30 STAT NO. FOR PRINT POS. 15 30 F1 -> UPDATE F5 -> PREVIOUS ENTRY F7 -> MAIN MENU F9 -> CALCULATED STATS You must first enter a unique report file name. This name can be up to eight characters and is the file name that will be written to disk once RJL Systems 29 The Sports Statbook the file is created by pressing the F1 function key. This file will then be used by program SSPRINT to print your report to the criteria you selected. Since you must enter the appropriate report file name while in SSPRINT, always use a descriptive report file name (e.g. PLAY80, PLAY132, TEAM80, TEAM132, GOALIE etc.). Should you forget the name of a report file, you can display all report file names on your team file disk using the DOS DIR command. There is no limit to the number of different reports you may create. You can obtain several different reports by creating a different report file for each report you want (e.g. separate report files can be created to obtain leaders for each statistic you maintain). To define a report, just enter information for each report variable. After entering all desired information, press the F1 function key to have the file written to disk. A description of each report file variable follows. 2.9.1.1 Report Type There are two different type of reports you may create. Enter P for a player report (statistics found on a player record) or a T for a team report (statistics found on a team record). 2.9.1.2 Player Category This variable pertains to a player report. If you have categorized player statistics (see section 2.2.2), only players under the player category you specify here will be printed. In our hockey team example, entering GL would print statistics for goalies only and entering NG would print statistics for all other players. If you want to print all players, leave this field blank. 2.9.1.3 Sort by Stat Nos. These variables define the statistics you want your report sorted by. Refer to tables A and B for the number corresponding to a particular statistic. Be sure you look up the correct table. If the report is for players, report type P, use the player table. If the report is for a team(s), report type T, use the team table. If you don't want to sort your report by a statistic, enter 30 for these two fields. The first variable represents the primary sort and the second variable represents the secondary sort. The secondary sort is applicable only when printing player statistics and represents the criteria determining who will be placed first when two or more players tie under the primary sort 30 RJL Systems The Sports Statbook criteria. In our hockey team example if you wanted to sort by goals, you would place a 2 in the primary sort field. 2.9.1.4 Sort Order This variable determines the sequence of the primary sort. Enter D to sort your report in descending/high to low order (e.g. goals) or A in ascending/low to high order (e.g. goals allowed). 2.9.1.5 Qualify Sort by Stat No. This variable pertains to a player report only. You can qualify a sort by any cumulative statistic. Players not meeting the qualifications will be placed last by the sort. In our hockey team example, you might want to qualify shooting percent by stat no. 5, shots taken. 2.9.1.6 80 or 132 Columns You can receive either 80 or 132 column printouts. On 80 column printouts a maximum of eight statistics can be printed. On 132 column printouts a maximum of fifteen statistics can be printed. Enter 80 to print an 80 column report or 132 to print a 132 column report. 2.9.1.7 Line Spacing Enter 1 to single space your report. Enter 2 to double space your report. Note this variable has no effect when printing player statistics collectively. 2.9.1.8 Report Headings If you want any information to appear at the top of your report such as a company heading, league name, etc., enter the data in these two fields. Note asterisks must delimit each heading on the right (e.g. Grapefruit League*********) to have the headings centered properly on your report. RJL Systems 31 The Sports Statbook 2.9.1.9 Stat No. for Print Pos. 1-15 These fields are the fifteen print positions on a report and determine where and what statistics you want to appear on your report. Eight statistics can be printed on an 80 column report and fifteen statistics on a 132 column report. Enter the statistic nos. corresponding to the statistics you want to have printed on your report in these fields. Refer to tables A or B for the number corresponding to a particular statistic. Be sure you look up the correct table. If your report is for players, report type P, use the player table. If the report type is for a team(s), report type T, use the team table. If you do not want to have a statistic printed for a print position field, enter 30. In our hockey team example, placing a 1, 2, 3, 4, 5 and 6 in these fields on a player report will print out the following statistics respectively: games played, goals, assists, penalties, shots, +-. 2.9.1.10 Calculated Stats You can define statistics calculated from other statistics. Press the F9 function key while in the first report variable screen. The second report variable screen will now be displayed. To define a calculated statistic, enter an up to three character abbreviation for this statistic in the topmost unfilled enclosed parentheses shown on your screen. Additional calculated statistics can be defined until all enclosed parentheses are filled. Once a calculated statistic is defined, it is then necessary to set up the correct formula. After entering an abbreviation, the cursor will move to the decimal place field. After entering the decimal place accuracy for the statistic, the cursor will move to the fields defining the formula. The numbers under the stat no. column represent the statistic number for a particular statistic (refer to tables A and B). The symbol under the op (operation) field represents the desired mathematical operation you want to perform. The permitted operations are as follows: + addition, - subtraction, / division by, | division into and * multiplication. Computation is from left to right within the enclosed brackets with the final result being multiplied by the multiplying factor. Note computation ends within the enclosed brackets when the last operation is reached or when a space is encountered in an operation code field. Examples of Calculated Statistics The below examples define some calculated statistics for our hockey team. The correct stat nos. can be determined by looking at the Table A sample on our hockey team in appendix A. 32 RJL Systems The Sports Statbook Example 1: Define shooting percent on a player report for nongoalies. 27 (SH%) = 1 100 * < 2 / 5 space 1 + 1 + 1 > Example 2: Define points scored on a player report for nongoalies. 28 (PTS) = 0 1 * < 2 + 3 space + 1 + 1 + 1 > Example 3: Define save percentage on a player report for goalies. 27 (SV%) = 2 100 * < 12 + 15 | 15 space 1 + 1 > Example 4: Define goals allowed per game on a player report for goalies. Average goals allowed per game would require two calculated statistics and can be defined as follows. 28 (MPH) = 3 60 * < 1 / 1 space 1 + 1 + 1 > 29 (GPG) = 2 1 * < 11 / 28 | 12 space 1 + 1 > Notes: 1. A calculated statistic can use another calculated statistic in its formula only if the other calculated statistic's stat no. is less than its own stat no. 2. Defining a calculated statistic does not automatically have the statistic appear on your report. To have a calculated statistic appear on a report, you must place its stat no. in one of the print position fields. For instance in the first example above, 27 would have to be entered in one of the print position fields on a player report for nongoalies to have shooting percent show up on the report. RJL Systems 33 The Sports Statbook 2.9.2 Changing a Report Once a report file has been created, the report file variables can be changed if desired. Changing a report is done in SSDEFINE. Place disk #2 in the current drive and type and enter SSDEFINE. After the main menu is displayed, press the F2 function key to change a report file to redefine your report variables. A screen similar to the one shown in the define report file variable screen will appear. After entering the name of the report file you want to change, the report file variables will be displayed on your screen. To change any of the report file variables, move the cursor to the desired field and enter the new data. After making all desired changes, press the update key, F1 function key, to record the desired changes to the report file. 34 RJL Systems The Sports Statbook 2.9.3 Printing a Report Printing reports requires the team file to be sorted. To sort the team file successfully, you must have nonused computer memory and/or available disk space in the current drive equal to approximately three times the records you are sorting. If your team file is not on the current drive, place a blank formatted diskette in the current drive before attempting to print any statistics. Note insufficient memory while sorting can either tie up your computer system making it necessary to turn it off and restart it or produce bad print routine input causing a program cancellation. After defining a report(s) (see section 2.9.1), you can now print it. Printing statistics is done in SSPRINT. To invoke the program, place disk #2 in the current drive and type and enter SSPRINT. After typing and entering the drive containing the team and parameter files, the main menu of the SSPRINT program similar to the one below will appear. PRINT MENU F1 YEARLY - PRINT ONE TEAM F2 YEARLY - PRINT ALL TEAMS SEPARATELY F3 YEARLY - PRINT ALL TEAMS COLLECTIVELY F4 HISTORICAL - PRINT ONE TEAM F5 HISTORICAL - PRINT ALL TEAMS SEPARATELY F6 HISTORICAL - PRINT ALL TEAMS COLLECTIVELY F7 GAME - PRINT ONE TEAM F8 GAME - PRINT ALL TEAMS SEPARATELY F9 PRINT TEAM STANDINGS/ROSTERS (SSPRINT2) F10 DEFINE/REDEFINE REPORTS (SSDEFINE) ESC RETURN TO DOS You can print game, year-to-date or historical (lifetime) player/team statistics. League leaders can be obtained by printing all teams collectively. After making the desired selection, the program will request the name of the report file you will be using for your report. Once the report file name is entered, the program will extract and sort the statistics that you defined to be included on the report before commencing printing. Notes: If there is not enough computer memory to sort your statistics, the sort routine will create work files on the disk in the current drive. These files are normally erased by the system but if the files do not get erased, use the DOS ERASE command to delete them. Sort-work-file file names are of the format SORT001.TMP, SORT002.TMP, etc. RJL Systems 35 The Sports Statbook 2 . 1 0 P r i n t i n g T e a m S t a n d i n g s Team standings are printed out by program SSPRINT2. To invoke the program, place disk #2 in the current drive and type and enter SSPRINT2. After typing and entering the drive containing the team and parameter files, the main menu of the SSPRINT2 program will appear where you can select the F2 function to print out your team standings. 2 . 1 1 P r i n t i n g T e a m R o s t e r s Team rosters are printed out by program SSPRINT2. To invoke the program, place disk #2 in the current drive and type and enter SSPRINT2. After typing and entering the drive containing the team and parameter files, the main menu of the SSPRINT2 program will appear where you can select the F1 function to print out your team roster. 2 . 1 2 S a v i n g S t a t i s t i c s SSSAVE is the program that saves game, year-to-date, and historical sta- tistics to disk in ASCII format. The files created by the program can be viewed and/or edited with a word processor or text editor that uses ASCII format. These files can also be viewed using either the DOS TYPE or MORE command. The game file is named SSGAME.FIL, the yearly file is named SSYEAR.FIL and the historical file is named SSHIST.FIL. Saving statistics requires the team file to be sorted. To sort the team file successfully, you must have nonused computer memory and/or available disk space in the current drive equal to three times the records you are sorting. If your team file is not on the current drive, place a blank formatted diskette in the current drive before attempting to save any statistics. Note insufficient memory while sorting can tie up your computer system making it necessary to turn it off and restart it. To save statistics, insert disk #2 in the current drive then type and enter SSSAVE next to the DOS prompt. After typing and entering the drive containing the team and parameter files, a menu similar to the main menu of the SSPRINT program (section 2.9.3) will appear where you can make the desired save selection. 36 RJL Systems The Sports Statbook 2 . 1 3 C r e a t i n g a B a c k u p D i s k e t t e Using this function (function key F8) will create a backup of your team 1 file. This facility creates one file named SSBACK.FIL. It is important that you create a backup of your team file after you have finished updating the file. Do not use this facility until you have added some records to your team file. Having a current backup will prevent your having to reinput updates to the team file later on in the event the file must be restored for any reason. Please note that this facility can not be used by fixed-disk users if the size of the team file becomes greater than a diskette can hold (however a backup can be made to a second fixed disk or the same fixed disk). In such an event, you can use IBM's BACKUP (and RESTORE) utility program under DOS to back up the SSTEAM.FIL and the SSTEAM.KEY files to multiple diskettes. After making the appropriate selection in the SS or SS2 main menu screen or the applicable function screens, you will see the message below appear at the bottom of the screen. Keep team file on drive __. Type drive letter of backup disk (ESC to exit). Type the drive specification of the drive where you will insert the backup diskette (permissible values are A, B, C, or D). If you have only one disk drive, you must enter an A since the team file and the backup will reside on the same diskette. After the drive specification has been entered, you will see the team- file backup screen, which should look similar to the one shown on the next page (only if the backup routine is invoked from the main menus of the SS & SS2 programs). ----------- 1. A backup of the team file can also be made by copying the SSTEAM.FIL and SSTEAM.KEY files using the DOS COPY command. You may want to back up the team file in this manner in addition to using the normal backup facility provided by The Sports Statbook. RJL Systems 37 The Sports Statbook BACK UP TEAM FILE PRESS DESIRED KEY F1 CREATE BACKUP F7 MAIN MENU F10 RETURN TO DOS Insert diskette in drive A then press F1 for backup. You can now insert a backup diskette in the drive indicated on the 2 screen (in the above illustration drive A was selected). After the diskette is inserted, press the F1 function key and the backup will begin. When the backup is completed, the following message will appear at the bottom of the screen. Backup of file completed. ____ records written to backup diskette. Those who have a two-disk-drive system can now create another backup diskette (it is advisable to keep more than one), return to the main menu or return to DOS by pressing the assigned function key. After finishing making a backup, you should label your backup diskette with the date and approximate time the backup was created. An important point to remember is that you should never use a backup 3 diskette that contains your most current team-file backup. If you do and the system crashes while the backup is executing, both your team file and your most current team-file backup could be lost permanently making recovery long and arduous. You should also never attempt to exit the backup screen while the actual backup is in progress. ----------- 2. If the drive indicated on the backup screen and the team-file drive are identical, the backup will take place on your team file diskette, and no new diskette must be inserted. 3. User's with only one disk drive can not avoid this situation. As a precaution, the backup file, SSBACK.FIL, should be copied to another diskette using the DOS COPY command prior to backing up your team file. 38 RJL Systems The Sports Statbook 2 . 1 4 R e s t o r i n g t h e T e a m F i l e SSR is the program that restores (re-creates) the team file when that file becomes unusable for any reason. To re-create the team file, SSR uses the team-file backup, SSBACK.FIL, created by the backup facility provided by The Sports Statbook. The program re-creates both the data file SSTEAM.FIL and the indexed file SSTEAM.KEY that comprise the team file. By executing this program, the team file is not only re-created but also reorganized more 4 efficiently. A reorganization does not take place if you utilize the 5 DOS COPY command to restore the team file. The ability to reorganize the team file is one of the principal reasons for using the backup and restore features provided by The Sports Statbook. Program SSR resides on disk #1. Insert this diskette in the current drive and type and enter SSR next to the DOS prompt. The following message will appear at the bottom of the screen. Type the drive letter of the drive where the team file will be re-created. Type the drive specification where the diskette that will contain the re- created team file, normally disk #3, will be inserted. Permissible values are A, B, C or D. The next message will request the drive specification where the diskette containing the team-file backup, SSBACK.FIL, will be inserted. Enter A, B, C or D only. For one-drive systems, the team file and the backup team file will reside on the same diskette. The program will then request you to insert the required diskette(s) in the drive(s) which you selected. Remember to use your most current team-file backup diskette. Once the diskette(s) is inserted, pressing any key (except ESC) will start the actual re-creating of the team file. ----------- 4. An indexed file tends to become disorganized and inefficient to use when it has been updated frequently; therefore, it should be restored periodically. 5. The COPY command will have to be used for both the SSTEAM.FIL and SSTEAM.KEY backup files. RJL Systems 39 The Sports Statbook When the program is finished re-creating the file, it will let you know that the file was successfully restored by displaying the following messages just before returning control to DOS. Total records written = _____. Team file restored successfully. Note that in performance tests using two disk drives, SSR was found to run at least five times faster with a system having a fixed disk than one without. 2 . 1 5 C h a n g i n g a T e a m N a m e Due to the structure of the team file the name of a team can not be change directly. To change a team name, The Sports Statbook writes copies of the old records changing only the old team name with the new team name you supply. Thus the old records remain on the file and must be deleted using the delete function (section 2.3.1). Use this function if a team on the team file changes its name or you just want to give a team a different team name. To change a team name, place disk #1 in the current drive and type and enter SS3. After entering the letter of the drive your team file is on, the main menu of the SS3 program will appear where you should make the global team name copy menu selection (function key F6). Once in the global team name copy update screen, enter the old team name then the new team name. 2 . 1 6 C h a n g i n g a C o n f e r e n c e N a m e To change the name of a conference a team belongs to, place disk #1 in the current drive and type and enter SS3. After entering the letter of the drive your team file is on, the main menu of the SS3 program will appear where you should make the global conference name update menu selection (function key F7). Once in the global conference name update screen, enter a team name and a new conference name. 40 RJL Systems The Sports Statbook Appendix A Statistic Tables and Data Entry Forms The Sports Statbook Table A Player Statistics Stat no. Stat Description Abbrev. 1. GAMES PLAYED G system-defined 2. ( ) user-defined 1 (cum.) 3. ( ) user-defined 2 (cum.) 4. ( ) user-defined 3 (cum.) 5. ( ) user-defined 4 (cum.) 6. ( ) user-defined 5 (cum.) 7. ( ) user-defined 6 (cum.) 8. ( ) user-defined 7 (cum.) 9. ( ) user-defined 8 (cum.) 10. ( ) user-defined 9 (cum.) 11. ( ) user-defined 10 (cum.) 12. ( ) user-defined 11 (cum.) 13. ( ) user-defined 12 (cum.) 14. ( ) user-defined 13 (cum.) 15. ( ) user-defined 14 (cum.) 16. ( ) user-defined 15 (cum.) 17. ( ) user-defined 16 (cum.) 18. ( ) user-defined 17 (cum.) 19. ( ) user-defined 18 (cum.) 20. ( ) user-defined 19 (cum.) 21. ( ) user-defined 20 (cum.) 22. ( ) user-defined 21 (cum.) 23. ( ) user-defined 22 (cum.) 24. ( ) user-defined 23 (cum.) 25. ( ) user-defined 24 (cum.) 26. ( ) user-defined 25 (cum.) 27. ( Varies with report ) Report file calc. 1 28. ( Varies with report ) Report file calc. 2 29. ( Varies with report ) Report file calc. 3 The Sports Statbook Table B Team Statistics Stat no. Stat Description Abbrev. 1. GAMES PLAYED G system-defined 2. WINS WIN system-defined 3. LOSSES LOSS system-defined 4. TIES TIE system-defined 5. ( ) user-defined 1 (cum.) 6. ( ) user-defined 2 (cum.) 7. ( ) user-defined 3 (cum.) 8. ( ) user-defined 4 (cum.) 9. ( ) user-defined 5 (cum.) 10. ( ) user-defined 6 (cum.) 11. ( ) user-defined 7 (cum.) 12. ( ) user-defined 8 (cum.) 13. ( ) user-defined 9 (cum.) 14. ( ) user-defined 10 (cum.) 15. ( ) user-defined 11 (cum.) 16. ( ) user-defined 12 (cum.) 17. ( ) user-defined 13 (cum.) 18. ( ) user-defined 14 (cum.) 19. ( ) user-defined 15 (cum.) 20. ( Varies with report ) Report file calc. 1 21. ( Varies with report ) Report file calc. 2 22. ( Varies with report ) Report file calc. 3 The Sports Statbook DATA ENTRY FORM ADD PLAYER STATS TEAM NAME: ______________________ STAT TYPE ____ PLAYER NAME/PAGE ID: ______________________ POS: ___ NO: ___ YRS: ___ PLAYER CATG: _______ STATUS: ___ INACTIVE YR: __ DESC: _______________________________ YEAR-TO-DATE HISTORICAL GAMES PLAYED _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / _____ _____ TEAM NAME: ______________________ STAT TYPE ____ PLAYER NAME/PAGE ID: ______________________ POS: ___ NO: ___ YRS: ___ PLAYER CATG: _______ STATUS: ___ INACTIVE YR: __ DESC: _______________________________ YEAR-TO-DATE HISTORICAL GAMES PLAYED _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / _____ _____ The Sports Statbook DATA ENTRY FORM ADD TEAM STATS TEAM NAME: ______________________ STAT TYPE ____ CONFER: _______ DIVISION _______ YEAR-TO-DATE HISTORICAL GAMES PLAYED _____ _____ WIN/LOSS/TIE _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ TEAM NAME: ______________________ STAT TYPE ____ CONFER: _______ DIVISION _______ YEAR-TO-DATE HISTORICAL GAMES PLAYED _____ _____ WIN/LOSS/TIE _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ / / / / _____ _____ _____ _____ _____ _____ The Sports Statbook DATA ENTRY FORM RECORD PLAYER GAME STATS TEAM NAME: ______________________ STAT TYPE ____ PLAYER NAME/PAGE ID: ______________________ GAME (Y/N) _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / _____ TEAM NAME: ______________________ STAT TYPE ____ PLAYER NAME/PAGE ID: ______________________ GAME (Y/N) _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / _____ The Sports Statbook DATA ENTRY FORM RECORD TEAM GAME STATS TEAM NAME: ______________________ STAT TYPE ____ WIN/L/T (Y/N) _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ TEAM NAME: ______________________ STAT TYPE ____ WIN/L/T (Y/N) _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ / / / / _____ _____ _____ The Sports Statbook Appendix B Error Messages This appendix includes more detailed information on a number of program error messages that you may encounter when using the system. It is not an all-inclusive list. Self-explanatory error messages and those that should rarely occur have been omitted. - Abort, Retry, Ignore * This is a DOS error message that can occur for a number of reasons. Always try to recover from this situation by correcting the applicable problem and pressing R. Avoid the abort selection if possible since your team file may become damaged. - COBOL RUN TIME ERROR * There are a number of COBOL file errors and run time errors that could occur on rare cases. There is no point in provid- ing a description and explanation of each error, since in all likelihood they would have little meaning to you. Some of these errors are of a serious nature. If you do encounter this type of error, please notify RJL Systems. - DATA BEFORE BEING ENTERED HERE MUST BE ENTERED IN PRIOR ( ). * When defining statistics with the SS3 program, you must place your abbreviation which defines a statistic in the leftmost unfilled parentheses for each statistic type: player and team. Remove the data you placed in the field using the space bar. - DATA MUST BE ENTERED HERE SINCE DATA HAS BEEN ENTERED INTO THE NEXT ( ). * When defining/redefining a player or team statistic using the SS3 program, you placed spaces within an enclosed parentheses when the enclosed parentheses to the right contained an abbreviation defining another statistic. Statis- RJL Systems B1 The Sports Statbook tics must be defined consecutively for each statistic type: player and team. Place an abbreviation in the field. - ENTER Y FOR YES OR N FOR NO. * A character other than Y or N was entered in response to a program request which expects a yes or no answer. Enter either a Y or N only. - INACTIVE YEAR MUST EQUAL C FOR CURRENT YEAR OR P FOR PRIOR YEAR. * The inactive year indicator on an inactive record was entered incorrectly. Enter either C for current year or P for prior year. - INCORRECT KEY PRESSED -- PRESS AN ASSIGNED KEY. * A key that was not assigned to a menu selection was pressed in one of the menu screens. Press only a key shown on the screen. - NAME/ID ALREADY EXISTS ON FILE FOR TEAM ENTERED -- RETRY. * In the add statistic screen, you tried to name a player or user-defined record with an existing player's/page id's name. The team, statistic type (PS or TT) and player name/page id in combination must be unique on the file. Make the player's/page id's name unique in order to add the record to the file. - NAME MUST BE ENTERED. * A name was not entered in the name field. Enter a player's/page id's name in the add routine or just the first few letters of the player's/page id's name in the change/display routines. - NO CORRESPONDING PLAYER/TEAM OR NO PLAYERS/TEAMS EXIST ON FILE. * The name of the player/team which was entered could not be found on the team file. Make sure that the team name, sta- tistic type (PS or TT) and player's name were spelled correctly. - NO PLAYERS/TEAMS ON FILE. PRESS ANY KEY. * A program could not find any players/teams on the team file to perform one of the following requested routines: create B2 RJL Systems The Sports Statbook backup, clear yearly statistics, print file. Make sure you have added players to the file before requesting these routines. - PARAMETER FILE NOT FOUND ON CURRENT/SPECIFIED DRIVE. CORRECT PRO- BLEM THEN RESTART PROGRAM. * A program could not find the parameter file. This could happen for a few reasons; however, the most likely one is that the diskette containing the parameter file was not inserted in the current/specified drive. - RECORD HAS ALREADY BEEN UPDATED. USE CHANGE GAME (F2) TO MAKE CHANGES. * In the record game routine, a team's game statistics or a player's game statistics were already updated (normally by pressing the F1 key). To change a game statistic, use the change game function after finishing recording all game sta- tistics. - REPORT FILE NOT FOUND. * The print program SSPRINT or the change routine of the SSDEFINE program could not find the name of report file you just entered. The most likely cause of the error is your spelling the report file name incorrectly. If necessary, do a DIR of you team file diskette to list all report file names. - REWRITE ERROR TEAM FILE. THE SPORTS STATBOOK CANCELLED. * Possible programming error. More likely your team file has become disorganized and the index file manager has placed a record in the wrong sequence. Backing up your team file and then restoring it (SSR) should correct the problem. - TEAM FILE NOT FOUND. * A program could not find the team file. This could happen for a few reasons, however, the most likely one is that the diskette containing the team file (disk #3) was not inserted in the current/specified drive. - TEAM FILE SERIOUSLY DAMAGED. THE FILE MUST BE RESTORED USING PROGRAM SSR. * The team file's indexed structure has been damaged rendering the file unusable. A damaged file can result from a system crash or failure to exit The Sports Statbook before turning off your computer or before performing a system restart using the CTRL-ALT-DEL keys. RJL Systems B3 The Sports Statbook - TEAM NAME MUST BE ENTERED. * In the add screens and the record/change game screens, the program requires the entering of the team name. - TEAM STATISTICS (TS) MUST BE ADDED BEFORE PLAYER STATISTICS. * When adding a team to the team file, add the team statistical record (TS) first. If you have already added the team statis- tical record for a team, this message indicates you have spelled the team name wrong. The team name must be spelled the same as when you added records for that team the first time. - TEAM STATS ALREADY EXISTS ON FILE FOR TEAM ENTERED -- RETRY. * In effect, you are trying to add a team to the team file with an existing team name. The most likely caused of the error is you entered TS for the statistic-type field by mistake when adding records. - TEAM STATS CAN NOT BE DELETED UNLESS ALL PLAYER STATS ARE DELETED. * All player statistical records must be deleted prior to deleting the team statistical record. - WHEN GAME IND = N, GAME STATS ARE SET TO ZERO UPON UPDATING. * In the record/change game routine, the game indicator for a player record was set to N meaning the player did not play in the game. If the player played in the game, reset the game indicator to Y before updating. - WHEN WIN/LOSS/TIE IND. ARE ALL N, GAME STATS ARE SET TO ZERO UPON UPDATING. * In the record/change game routine, the win-loss-tie indicators for a team record were all set to N meaning the team did not play a game. If the team played a game, reset one of these indicators to Y before updating. B4 RJL Systems