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

 

 

Preparing Trend Charts

The Trend Charts tab in the Report Chart form provides fourteen different line charts to trend your report data. Just select the chart you wish to display and click OK. Here is an explanation of all the trend charts.

• Driving Distance and Accuracy - Charts a trend of driving distance and % drives in the fairway.
• Distance, Fairways & Greens - Charts a trend of driving distance, % drives in the fairway, and % greens in regulation.
• Shot Making Accuracy - Charts a trend of proximity to pin for all approaches, proximity to pin for greens in regulation, and % greens in regulation.
• Save Percentages - Charts a trend of save percentages from the fairway, rough and sand traps (bunkers).
• Short Game Proximity - Charts a trend of proximity to pin for short game shots from the fairway, rough and sand traps (bunkers).
• Putting - Charts a trend of putts per hole, putts per green in regulation, and strokes gained putting. (All strokes gained calculations are based on average PGA tour performance.)
• Putt Lengths - Charts a trend of the average length of your first putt, average length of the putt you holed, and length of total putts made for each round.
• Putting Efficiency - Charts a trend of One-Putt Efficiency (one-putts / one-putt chances %, Birdie Efficiency (birdies / birdie chances %, and putts per round.
• Bounce Back Statistics - Charts a trend of % Bounce Back Pars (bogey or worse followed by a par), and Bounce Back Birdies (bogey or worse followed by a birdie or better).
• Scoring by Hole Par - Charts a trend of +/- par on Par 3's, Par 4's and Par 5's.
• Scoring by Hole Difficulty - Charts a trend of +/- par on Easiest, Middle, and Hardest holes.
• Scoring - Charts a trend of Course Par, Course Rating and Score.
• Strokes Gained - Charts a trend of Strokes Gained - Off the Tee, Approach, Short Game, and Putting. (All strokes gained calculations are based on average PGA tour performance.)
• Personal Ratings - Charts a trend of Personal Ratings - Driving, Shot Making, Short Game, and Putting.

On Trend Charts, each data point represents a single round of golf, or a running average of several rounds of golf. You can designate how many consecutive rounds to average together for the chart data using the Rounds to Average setting in the Running Averages for Data Points section of the Report Charts form. If you set this value to 1, each data point on the chart represents one round of golf. If you set the value to 2 or higher, the program use a running average of that many rounds for each data point. The default value is 3, so using that as an example, the first point would average rounds one through three, the second point would average rounds two through four, the third point rounds three through five, etc. This provides a smoother trend that does a better job of representing a golfer's progress over a longer period of time.

When creating Trend charts, you can choose to display comparison statistics for an average PGA tour pro, a typical scratch golfer, or an average golfer by selecting the appropriate check box and option button in the Chart Comparisons section. (This option is not available for some charts as the data was not available or it didn't make sense for that particular category.) The PGA tour pro statistics reflect the data for the average of all players on the PGA tour in 2022. The scratch golfer statistics reflect the capability of a golfer with a 0 handicap index and the average golfer statistics reflect the capability of a golfer who shoots in the mid-eighties. These comparisons allow you to track your progress as you strive to become a better golfer, or even a scratch golfer. Keep in mind that the PGA tour pros play on extremely difficult courses so there's no reason you can't strive to match their abilities on the typical golf course, especially in the approach, short game and putting categories.