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

 

 

Report Summaries and Saved Summaries

The Report Summaries and Saved Summaries sheets allow you to compare several reports side-by-side when you create reports using the Prepare Report or New Report buttons. Each time you create a new report, a summary of the report is added to a column on the Report Summaries sheet. You can create additonal reports which add new columns to the Report Summaries sheet and lets you compare your statistics for different conditions. For example, you may want to compare your performance on two different courses or you may want to compare your statistics for last year vs. this year or last month vs. this month, etc. You can also compare statistics for different golfers, different teams, different course ratings, slope ratings, different weather and course conditions, etc. The possibilities are almost endless.

Once you've created multiple reports that show up on the Report Summaries sheet, you can save a copy of the Summary using the Save Summary button. When you click this button you will be prompted for a name for your Summary and it will be copied to the Saved Summaries sheet. Both sheets function the same way and show your data in the same column oriented format to allow for an easy comparison of all your golf statistics. The report parameters for each summary are shown in the top rows, with all your statistics being grouped by statistical category in the lower sections. Both sheets allow you to delete report summaries using the Delete Summary button and rearrange summaries using the left and right arrow buttons.

The data on the Report Summaries and Saved Summaries sheets are grouped by category. You will notice the small minus or plus buttons in the left margin of both sheets that allow to collapse and expand each cateogory. This helps facilitate better views of your data without having to constantly scroll up and down the sheets.

If you would like to save a copy of either of the Summary sheets, you can use Excel's File-Export function or the Print to PDF feature in Windows to save a PDF copy of either worksheet. Just use Excel's Page Layout features to tweak the PDF printout to your liking.

Preparing Reports

Preparing Charts