DJI Computer Solutions
Software Applications for Microsoft Excel
The most unique, full featured spreadsheet applications on the web. These are not your father's spreadsheets!
The most unique, full featured spreadsheet applications on the web. These are not your father's spreadsheets!
To enter a round of golf into the Golf Tracker for Excel, click the Enter New Round button on the Main Menu sheet. The form shown below will be displayed to collect some general information about your round. Select the golfer, golf course, and tees you played. Choose how many holes you played and which hole was played first. The current date will be in the date box, change it if necessary. Also, select whether it was a competition or casual round.
There are four fields in the form for entering Personal Ratings for Driving, Shot Making, Short Game and Putting. These fields are provided to keep track of how you personally felt about the various aspects of your game during the round. All too often the statistics for the round don't accurately reflect how well you played. For example, you may have hit every shot solid and straight at the pin but hit the wrong club all day long. In this case, you would have hit very few greens in regulation, but your personal rating for Shot Making would be high because you struck the ball so well. Conversely, you might have hit your drives poorly but because the ground was firm, your driving distance was actually good. However, your personal rating for Driving would be low because your drives didn't carry very far. The four categories are pretty much self explanatory. The Driving rating should reflect how you felt about your driving distance and accuracy. The Shot Making rating should reflect how well you felt you struck the ball on shots when you were taking full swings, regardless of the results. The Short Game rating should indicate how you felt you hit shorter shots from around the green and the Putting rating should reflect how well you felt you putted the ball regardless of how many putts dropped. The ratings range from 1 to 10 where 1 is doing nothing right and 10 is perfect. Rate yourself accordingly in all four categories.
You can track the weather and course conditions that can potentially impact your round using the Course Conditions section. Estimate the temperature and average wind speed and enter them into the appropriate fields. Enter the general firmness of the course on a scale from 1 to 10, where 1 is completely soggy where the ball plugs in the fairways and on the greens and 10 is extremely firm where no amount of spin will get the ball to stop on the green. You can also enter the green speed. We recommend estimating the stimp measurement of the greens. As a guide, most municipal courses have a stimp reading between 7 and 10. A reading of 10 or higher is considered fast. Most professional tournaments are played on greens with a stimp reading between 11 and 13. The greens at Augusta National for the Masters have a stimp reading of about 13. Oakmont Country Club greens typically read 14 and sometimes higher on the stimpmeter. A stimp measurement of 5 or 6 would be extremely slow. There is also a field for comments. This is a good place to put information about unusual conditions such as rain, aerated greens, winter rules, etc. Once you have entered all the information, click OK and the Hole Entry form will be displayed. Click the link below for information on entering hole by hole data into the program.
Visit Checkbook on Facebook
Visit Handicap Manager on Facebook