Golf Stats & Handicap Math: Score Differentials, Net Scores, Club Gapping & Strokes Gained
Track rounds, compute a simplified handicap, net scores and points, gap your clubs and see where strokes are gained, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you analyse a fictional club golfer's season in a spreadsheet that checks every cell as you go. You turn a scorecard into scores to par, fairways hit and putts on greens in regulation, and convert rounds on different courses into score differentials with course rating and slope. You average the best 8 of the last 20 into a simplified, fictional handicap index, turn it into a course handicap and give out strokes by stroke index. You score holes in net strokes and points, gap the clubs from launch-monitor carries with STDEV.S, measure strokes gained against a baseline and build a season dashboard.
Lessons
- The Scorecard: Score to Par, Nines, Fairways, Greens & Putts Pro
- Score Differentials: Course Rating, Slope & Comparing Rounds on Different Courses Pro
- The Handicap Index: Best 8 of the Last 20 Differentials and Its Trend Pro
- Course Handicap & Strokes Received per Hole by Stroke Index Pro
- Net Scores and Points per Hole: Scoring a Club Competition Pro
- Club Gapping: Average Carry, Gaps Between Clubs & Dispersion Pro
- Strokes Gained: Shots Against a Baseline of Expected Strokes Pro
- Season Dashboard: Scores by Course, Handicap Trend & Practice Priorities Pro