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!

Visit Checkbook on Facebook

Visit Handicap Manager on Facebook

Golf Tracker for Excel Help

• Introduction
• Welcome
• Registration
• License Agreement
• Installation
• Importing Previous Version
• Instructions
• Quick Start Guide
• Golf Courses
• Golfers
• Program Options
• Rounds
• Entering New Rounds
• Entering Hole Data
• Data Collection Tips
• Managing Rounds
• Scorecards
• Reports, Charts & Analysis
• Preparing Reports
• Report Summaries
• Preparing Charts
• Trend Charts
• Summary Charts
• Approach Shot Analysis
• Short Game Analysis
• Hole Statistics
• Additional Information
• Exporting Worksheets
• Printing Worksheets
• Handicap Calculation
• Golf Tips
• Enabling Content (Macros)
• Backing Up Your Data
• Troubleshooting & Tech Support

 

 

Entering Hole Data

Golf Tracker for Excel collects detailed information about each shot you play on each hole, assuming you didn't make a really high score. This may seem overwhelming at first, but the information below and our Data Collection Tips topic provide some guidance to make the process easier. The program walks you through each hole from tee to green using the form shown below. The form in interactive and changes based on the par for the hole and the information that you enter, so it's important to start at the tee and work your way to the green just like playing the hole. You can use your mouse to enter all the data, selecting locations for your shots, using the arrowed scroll bars and spin controls to increase and decrease distance values, and picking the clubs you used from the drop-down lists. You can also type values into the fields if you prefer.

For par 4's and 5's, starting with your drive, select the club you used off the tee and where your tee shot came to rest. (The golf course graphic provides locations for Fairway, First Cut, Rough, Bunker, Penalty Area and Out of Bounds. The program doesn't track left/right location so even though your ball landed in the right bunker and the hole graphic shows the bunker on the left, just select the bunker option regardless of left/right position.) Also, enter the distance of your tee shot. (Don't worry about an exact distance, just use your best estimate. Usually subtracting the distance left to the green from the hole yardage will get you pretty close.) If the hole is a par 5, enter the same information for you second shot.

If you hit your drive (or second shot on par 5's) into a penalty area or other bad location and had to punch out or take a drop, check the "Punch Out/Drop" checkbox and select the location where you dropped or where your punch out shot came to rest. Enter information for your approach shot. This would be your tee shot on par 3's. Select the club you used, distance to the pin and location where it came to rest. (The program does not track left/right/short/long so just select the green, bunker, rough, etc. where it came to rest.) If the hole was a drivable par 4 or par 5 that you could reach in two, you might want to count your drive (or 2nd shot on par 5) as an approach shot. To do this simply check the "Use Drive (2nd Shot) as Approach" box and update the information as necessary. If for some reason you don't want to count an approach shot for the hole, check the 'No Approach" box. You  might want to do this if you had to punch out, but were able to get your shot up around the green. In that case, don't count an approach and just enter information for your chip/pitch.

Next, select how many putts you took and enter the length of each putt. (Just make your best estimate.) For putts less than a foot, enter 1 foot. If you missed the green with your approach, you can enter short game shots in the section to the right of the green graphic. Just select the club you used and distance to the pin from where the chip/pitch originated. The program can track up to two chips/pitches, so if you missed the green with your first attempt, enter 2 into the attempts field and you can select a club and location for your second attempt. Make sure the numbers in the Saves and Attempts fields are correct.

There is also an optional Mental Game section. The focus rating can be a value from 1 to 3, with 1 being terrible focus and 3 being good focus on all shots. There is a field for entering any positive comments about shots you made on the hole. Research shows that reinforcing good shots by writing down positive comments about them will help improve confidence in your game. Negative comments should be avoided. Just forget about bad shots and move on.

Check the information that you already entered, make sure the Score is correct, and click the Enter Hole button to store the data and move to the next hole. The program will check the data and warn you if something is missing or appears incorrect. You can use the left and right arrow buttons to move from hole to hole, but the data for that hole is only saved if you click the Enter Hole button. Always use the Enter Hole button to save the data you've entered or updated.

Use the Save Round button to save all the data for the holes you've already entered (The Enter Hole button only stores the data temporarily.) Once you've entered information for all the holes you played, the program will let you know that you've entered data for all the holes. Just click the Save Round button to save the round and display the enhanced scorecard for the round. If you get interrupted while entering hole data for a round and want to stop for some reason, be sure to use the Save Round button to save the data for the holes you've already entered. You can use the Manage Rounds function to come back later and finish entering the rest of the holes.

Entering all the data for a round of golf can seem cumbersome at first, but it get's much easier over time. Use the link below to read the Date Collection Tips topic for some tips on making collecting and entering data easier.

 

Data Collection Tips

Managing Rounds