In order to enjoy all the features that our Excel applications provide, it is necessary to have macros enabled in Excel. You may receive a security warning that the file "contains macros by DJI Computer Solutions." In order for Handicap Manager for Excel to do its job, you will need to enable the macros it contains. Rest assured that the macros are safe and perform only basic Excel functions. They have been digitally signed and protected to insure that they were created by DJI Computer Solutions. To enable the macros and eliminate future warning for files published by DJI Computer Solutions, check the "Always trust macros from this publisher" check box and click the Enable Macros button. If you are still having problems enabling macros or would like additional information, click this link to our Security page.
This problem is caused by the presence of quotation marks in any golfer's name on the Golfer's sheet. Excel misinterprets the quotation marks when querying the golfer's scores in order to calculate his or her handicap index. To correct the problem, go to the Golfers sheet and change the golfer's name to remove any quotation marks. Then go to the Scores sheet and Uncombined Nines sheet and change the golfer's name on any scores that are listed for that golfer. You can use the copy and paste function to make it easier.
This problem is caused when a golfer's name is manually changed on the Golfers sheet but not changed on the Scores and Uncombined Nines sheets. Excel uses each golfers name exactly as it is entered on the Golfers sheet to match scores to that golfer. If the name is changed on the Golfers sheet but not on the Scores sheet, Excel does not identify the score as belonging to that golfer. To correct the problem, go to the Scores sheet and Uncombined Nines sheet and change the golfer's name on any scores that are listed for that golfer to match his or her name exactly as it appears on the Golfers sheet. You can use the copy and paste function to make it easier.
This problem occurred under certain circumstances when the program automatically combined nine hole scores. The issue was present in version 3.0, 3.0a & 3.0b. It was corrected with version 3.0d or higher.
This problem was due to an obscure bug in Excel 97 and did not occur in more recent versions of Excel. The issue was corrected with the release of Version 3.6c or higher. Download and install the latest version of the program if you are using Excel 97 and run into this problem.
This occurred when switching golfers but not golf courses when entering scores and would sometimes result in an incorrect course handicap and net score being entered on the Scores sheet. It did not affect handicap calculations. The issue was present in version 3.0, 3.0a & 3.0b. It was corrected with version 3.0d or higher.
This problem occurred in version 3.0 and has been corrected with version 3.0a and higher. You can work around the problem in your existing version by using the "Prepare Golfer Reports" function. This will automatically correct the problem. To check the version number of your existing program, click on the Golf Course graphic on the Main Menu sheet to display the Welcome dialog. The version number is displayed in the title bar. If no version number is listed, you are not using the latest version.
This problem is caused when the golfer's home course listed on the Golfers sheet is not listed on the Golf Courses sheet. It is important that each golfer's home course have an exact match on the Golf Courses sheet. This usually occurs when the name of the home course is typed directly into the Golfers sheet and a typo is made. The problem has been corrected with version 3.0b and higher. You can work around the problem in your existing version by making sure that each golfer's home course has an exact match on the Golf Courses sheet. To check the version number of your existing program, click on the Golf Course graphic on the Main Menu sheet to display the Welcome dialog. The version number is displayed in the title bar. If no version number is listed, you are not using the latest version.
This problem is caused when the golfer's home course listed on the Golfers sheet is not listed on the Golf Courses sheet. Since Handicap Manager does not recognize the golf course, it substitutes the first golf course on the Golf Courses sheet. This usually occurs when the name of the home course is typed directly into the Golfers sheet and a typo is made. To avoid the problem, always use the buttons on the Main Menu sheet to initiate data entry instead of typing information directly into the various sheets. You can correct the problem by making sure that each golfer's home course has an exact match on the Golf Courses sheet.
This is a confirmed bug with version 2.0, 2.1 and 2.1a and has been fixed with version 2.1b which is currently available for download on the Handicap Manager main page. Once you have used the "Delete Old Scores" function, the data in the Score, Course Handicap and Net Score columns will be shifted to different rows and will no longer correspond to the correct score entry. None of this information is used for the handicap calculation so the best solution is to simply delete all the data in these three columns. When deleting the data, be sure to extend your deletion well beyond the last row of your existing data as there may be data from the last three rows stranded lower in the worksheet. Be sure not to delete the column headings.
You may be able to copy the data in the last three columns to the correct location farther up in the worksheet but this will be a difficult process if you are managing a large number of golfers. Some of the data remaining in the last three rows will be left over from score entries that were deleted, but if you can determine which data belongs to which golfer, you can start with the most recent post and just copy the data for the number of scores remaining for each golfer. Even if you copy it to the wrong location, this data is not used for the handicap calculation and will not affect the functionality of the program.
With the wide variety of printers and print drivers on the market, adjustments are necessary to make the cards print correctly on some printers. This problem can often be fixed by adjusting the page margins as follows:
Many inkjet printers do not support bottom margins as low as 0.5 inches. If you have already adjusted the bottom margin to zero and the page break is still too high, you will need to adjust the paper size using your printer driver as follows.
Make sure you are using Avery Inkjet (8371) or Laser (5371) business cards or equivalent. Business card sheets that are not this exact specification will not work correctly.
If the card rows are spaced correctly but are all shifted up, down, left or right, you will need to adjust the margins as follows:
If the cards are not spaced correctly, i.e., the first row is correct but rows near the bottom are too far up or down, you will need to adjust the row heights in the Handicap Card sheet as follows:
Make sure that you have downloaded the most recent version from the Handicap Manager for Excel home page.
Your data from any previous version of Handicap Manager for Excel can be easily imported into the new version using the automatic import feature. Click on the golf course picture at the bottom of the Main Menu sheet to display the "Welcome" dialog box. Then click the "Import Data from a Previous Version" bottom and follow the directions on the screen carefully. All of your data will be imported in just a few seconds.
The imported data will overwrite any existing data so make sure you are starting with a blank copy of the Handicap Manager workbook.
In order for the old version to be recognized, it must be saved with the "Main Menu" sheet active. Open the old version, make the "Main Menu" sheet active, save and close the file, and then try the Import again from the new version. This problem will be fixed in a future release. Also, make sure you are opening the correct Handicap Maanger for Excel file.
The dates are showing as dollar signs because the system short date format on your computer has been modified to use a four digit year and the longer dates no longer fit in the cells. There was an incorrect rumor that this was necessary to make Windows Y2K compliant and many Y2K programs made this modification automatically. This problem was fixed with a maintenance release of Handicap Manger (version 1.8). Version 2 is available for download on the Handicap Manager home page. You can also fix the problem by changing the system short date format back to a two digit year if you don't want to download the free upgrade.
If you are using the USGA Handicap Method, the "Scores Posted" should be equal to the number of scores previously posted during the handicap revision period set by the "Previous" and "Current" handicap calculation dates. For example, if the previous handicap calculation date is 8/1/2001 and the current handicap calculation date is 8/14/2001, the "Scores Posted" will be the total number of scores posted from 8/1/2001 through 8/14/2001. This number is meant to show how much a golfer has played recently.
You can define the scores posted calculation in the most recent versions of the program. Just hit the F1 key while the Handicap Calculation dialog box is displayed to bring up the help information and it will explain this topic in detail.
Handicap Manager for Excel can be used to calculate either 18 or 9 hole handicaps. However, you cannot enter both 9 hole and 18 hole scores into the same file. If you want to calculate nine hole handicaps, you must enter all nine hole scores, splitting any 18 hole scores into two 9 hole scores. If you want to calculate eighteen hole handicaps, you must enter all 18 hole scores, combining any 9 hole scores to make 18 hole scores.
If you wish to track both 9 and 18 hole handicaps, save separate copies of the Handicap Manager workbook with different names, designating one for 9 hole handicaps and one for 18 hole handicaps.
There was an obscure bug in earlier versions of Handicap Manager for Excel that caused this problem on some machines running Excel 97 or Excel 2000. This problem has been corrected in versions 1.9 and higher. You can download the latest version from our Handicap Manager Home Page. To see instructions for importing your data from a previous version to the new version, click the previous link.
The context sensitive help feature in the custom dialog boxes is not supported in Excel 97. This feature is only available to users of Excel 2000 or higher. To access the help file, click on the "Help" button on the Main Menu sheet. You can then use the Contents or Index buttons to find the desired help topic. Keep the help file minimized on the Windows Task Bar so that it is available as needed while you are using the program.
This problem is caused by a bug in Office/Excel 97 and you can correct the problem by downloading the latest patches for Office 97. The bug is due to a program installing a newer version of the Office Automation files (including OLEAUT32.DLL) that is not completely compatible with Excel 97. You can determine which Excel patches you need to apply by reading the Microsoft Knowledgebase article Q232652 at: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232652
If you are experiencing frequent crashes in Excel 2000 or Excel 2002/XP, use the Detect and Repair option on the Help menu to verify that your Excel installation has not been damaged and the Office automation features are still intact. You can also go to Microsoft's Office web site and use the Office Update feature to install the latest patches. When installing the latest patches, Excel's macro security policy will be modified without your permission. Click this link to our Virus Protection page for more details.
Excel 97 doesn't support the VBA calls for the automation of the web publishing feature. (All the other program features work properly in Excel 97.) However, the process is very simple and you can still save a copy of your data in HTML format from Excel 97, which is what Handicap Manager does with the publishing feature. We simply automate the process to simplify the range selection.
To publish your reports in HTML with Excel 97, follow these directions.
1) Go to the sheet you want to publish and select the range you want to included in your HTML file.
2) Once you have the range selected, choose File - Save as HTML from the Excel menu.
3) The HTML wizard will guide you through the process. You can just accept the defaults and click the Next button until finished.