Getting Started Quickly
Handicap Manager for Excel is very user friendly and requires little preparation to use. All the data entry takes place in easy to understand input forms that are initiated from the Main Menu worksheet. This section describes how to get started quickly using the program. For more detailed instructions and comprehensive descriptions of all the functions of Handicap Manager for Excel, click one of the links below to take you to the appropriate section. You can also display context-sensitive help for any of the input forms by clicking the help button in the upper right hand corner of the form and then clicking anywhere on the form. Helpful tips are automatically displayed by holding the mouse pointer over an input field.
To start Handicap Manager for Excel, use the Handicap Manager shortcut in the Windows Start Menu program group or start Microsoft Excel and open the HCPXL700.XLS file in your Documents folder. The first time you run the program, you will be prompted to decide between an eighteen-hole or nine-hole handicap format. The 18 Hole format is the normal handicap format. It allows you to post 18 hole scores and provides an 18 hole handicap. It also allows you to post 9 hole scores, which it automatically combines into 18 holes scores when a second nine-hole score has been posted. The 9 Hole format is limited and should only be used for 9 hole leagues or for other circumstances where players want only a 9 hole handicap and play 9 hole rounds almost exclusively. When using the 9 Hole format you can only post 9 hole scores. Make your selection and click OK to continue. The Main Menu sheet will appear with the command buttons which initiate the various program functions. Just click on the buttons to use one of the functions. Almost all the data entry and program functions can be accessed from the Main Menu sheet.
First, you need to enter information on the home golf course or golf courses for the players you will be tracking. Just click the Golf Course Information button and the golf course information form will appear that allows you to enter the necessary information. Enter the name of the golf course and any other information that you feel is pertinent. You must enter the eighteen hole par, course rating, slope rating and gender for at least one set of tees. Don't worry if you don't know the nine hole information, it's not necessary for the program to function properly.
Next, enter information about the golfers you will be tracking by clicking the Golfer Information button. A pop-up data entry form will be displayed for entering information for each player. The only information that is required is the golfer's name, home course, the tees they normally play and their gender. All the address information is optional.
You are now ready to enter scores for individual players. Click the Enter Scores button to display the Score Entry form. Select the golfer, golf course, the tees that were played and whether nine or eighteen holes were played then enter the score. The par, course rating and slope rating change automatically depending on which golf course and tees are selected. If the round was played on a course that is not listed, you will need to type the name of the course into the "Golf Course" field and manually enter the par, course rating and slope rating. If scores are being used to calculate World Handicap Indexes or Traditional Handicap Indexes, then the Limited Gross Score must be adjusted based on the Limited Stroke Control (LSC) limits. If the score is from an event/tournament, or is a penalty score, check the appropriate checkbox. The program also provides the option of entering five additional user defined statistics. The additional statistics can be enabled and defined using the Options button on the Main Menu sheet.
If you also wish to track team competitions, you can assign players to teams using the Enter Team Assignments button. You can allow the program to assign teams automatically or choose to do it manually, selecting individual players for each team. Once you have assigned players to teams, you can use the Enter Team Scores button to enter team scores and match results. Players' individual scores should be entered before the team scores are entered. This allows the program to automatically calculate the team scores for those dates from the individual scores.
After you have entered enough scores for the players you are tracking, you can calculate handicaps. Click the Calculate Handicaps button and enter the current revision date for the calculation. The current revision date will be today's date unless you change it and is the cut-off date for scores you want included in the handicap calculation. Scores posted later than the current revision date will not be included. The default calculation method is Global; click the Calculation Method button to change to a different method.
You can use the Prepare Golfer Report button to limit the information that is visible on the Golfers worksheet and to display just golfers from a particular golf club. This is convenient for preparing printed reports or PDF reports.
The Golfer Statistics button displays scoring and handicap information for individual golfers.
The Prepare Scoring Reports button automatically prepares scoring records for all the golfers in the program and displays them on the Scoring Reports worksheet. This is convenient for preparing printed reports or PDF reports of detailed scoring records.
The Prepare Handicap Cards function automatically prepares handicap cards in a format that will print out in standard 2" x 3½" business card size (Avery 8371 or equivalent).
The Prepare Tournament Sheet function automatically prepares a Tournament sheet for an upcoming tournament, league play or other round of golf.
The Prepare Team Report function allows you to prepare a customized report displaying a summary of team scoring and match information.
The Prepare Date Report function automatically prepares an individual player or team summary of scoring and match information by date.
The Course Handicap Calculator button displays the Course Handicap Calculator. Just follow the directions in the form to automatically calculate course handicaps.
The Create Web HTML Reports button initiates Excel's web publishing feature and allows the Golfers Report, Scoring Report, Team Report, Date Report or Tournament Sheet to be saved as HTML files for publishing on an Internet web site.
The Member Mode button provides a method for club or league members to enter scores into the program from a common computer without having access to other program functions.
Visit Checkbook on Facebook
Visit Handicap Manager on Facebook