MESSAGE · EXCEL

DIY Workout Tracker in Excel — the DIY Solution.

bebrassie, Arccos, and Shot Scope are the pro tools — but your own Excel tracker has unbeatable advantages: full flexibility, no subscription, complete data control. How to build a senior golf tracker in Excel and which three tabs are indispensable.

My first Excel tracker was created when I was 64—before Bebrassie and Arccos. Three tabs: Round KPIs, Drills, Club Calibration. Excel doesn't do any step automatically, but: I maintain full control, can build in my own calculations, and store all historical data in one file. Apps come and go—Excel data remains.

Custom Excel trackers are a valid alternative to apps in senior golf. Advantages: full data control, no cloud dependency, unlimited customization, no subscription fees. Disadvantages: manual data entry, no automatic tracking. A strong option for senior players with Excel experience and a desire for data control.

Three essential tabs in the Senior Training Tracker

Tab 1 — Round KPIs

One line per round.

Per round, record a line with: Date, Course, Gross Score, Putts, GIR, FIR, Up-and-Down. Optional: Weather, Tee Box, Playing Partner. Over 30+ rounds, this creates a statistically reliable database.

Tab 2 — Drills

✓ THREE-CIRCLE + LONG-DELAY.

Pro Drill-Session: Date, Drill Type (Three-Circle, Long Lag, Wedge Calibration), Quota, Conditions. Trend chart shows progress over time. Senior Motivation Tool.

Tab 3 — Racket Calibration

✓ MEDIAN AND DISPERSION.

Pro Bat: Median Carry, Dispersion, Date of Last Measurement. Bag Map Directly Derivable. Semi-Annual Update. Senior Discipline Tool.

30+ laps

Excel database for statistically sound senior analyses

MyTPI Self-Tracking Methodology 2024

Excel trackers are app-independent and valuable in the long term. Senior data sovereignty.

Three tips for a good senior Excel tracker

Tip 1 — Just get started

✓ THREE TABLETS ARE ENOUGH.

First Excel tracker with only three tabs (Rounds, Drills, Clubs). Expand complexity only after 3-6 months of experience. Avoid senior over-complexity.

Tip 2 — Automatic Calculations

✓ AVERAGE, TREND.

Excel Formulas: Average over the last 10 rounds, moving average, year-on-year comparison. One hour of setup, years of automatic evaluation.

Tip 3 — Backup Discipline

✓ MONTHLY CLOUD BACKUP.

Back up the Excel file monthly to the cloud (Dropbox, Google Drive, OneDrive). Losing data after 5 years of tracking would be devastating. Strict backup discipline is mandatory.

Apps come and go. Excel files stay. For senior golfers tracking data over decades, ownership matters as much as automation.

— Frank Brohl, IAGTO Vice President

Three senior Excel advantages.

Full data control

No cloud dependency, no app updates that remove features. Senior sovereignty.

No subscription, no vendor lock-in

Excel is a one-time investment in Office. Apps often require monthly subscriptions. There is a significant cost difference over 10 years.

Unlimited Customization

Your own analyses, your own calculations, your own charts. Bebrassie can only do what it’s capable of. Excel can do everything.

Common Misunderstandings about Excel Trackers

Misunderstanding 1 — „Excel is too complicated for senior golfers”

Wrong. Anyone who has used Word or email in their professional life can also use Excel. The three basic functions (fill a cell, SUM, AVERAGE) are enough for 90% of all golf statistics. Over-complexity is the real pitfall—with just three tabs, any Excel tracker remains manageable.

Misunderstanding 2: „Brass takes care of all of this automatically.”

Only partially. Bebrassie automatically captures rounds—but drills, wedge calibration, and individual training metrics are left out. The Excel tracker perfectly complements Bebrassie and fills precisely those gaps.

Misunderstanding 3 - „Manual entry is too time-consuming”

Incorrect. Anyone who logs 5 minutes after each round will have the most complete golf data of their life after 6 months. Effort: 5 min x 25 rounds = 2 hours per year. In return: Full data sovereignty for life.

THE SYSTEM

My Path to a Better Score

Complete method

On this page

ON THIS PAGE

01 Three essential tabs

02 Three Excel Tips

03 Common Misunderstandings

04 What Excel doesn't replace

Mathias Struwe

PUBLISHER · HCP 31 · 68 YRS.

30+ laps

Excel database for reliable analysis.

REFERENCE

Broadie, M. (2014): Every Shot Counts. TrackMan Performance Database 2024. MyTPI Senior Performance Research. PGA Tour Stats 2014–2024. IAGTO Senior Golf Analysis 2024.

What Excel Tracker doesn't replace

Excel Tracker provides data, but it doesn't replace training or automatic tracking. Senior players with Excel discipline have full control but must manually log every round. Hybrid solution: Bebrassie for automatic logging + Excel for personal analysis.

THREE FIRST STEPS