Introduction
This page provides a spreadsheet, “JTcalc”, which calculates Course Handicaps, Playing Handicaps and strokes given for pairs matches. All calculations comply with the latest WHS specifications from England Golf and CONGU.
JTcalc covers Fourball, Foursomes and Greensomes formats, including any mixed-tee matches. It includes par adjustments for mixed matchplay, where the pars of different tees being played may differ (as is the case, for example, for some mixed-tee interclub away matches).
JTcalc has course ratings bult in for 29 courses: all the GetGolfing courses and quite a few local courses which SOGC teams play against. Other courses can be added on request.
The handicap calculators provided by England Golf and Golf Genius are also discussed.
Using the Calculator with Excel
You can download the Excel spreadsheet here:
If you wish to run it on your PC in Excel, then you need Excel 2019 or a later version. If you don’t have Excel on your PC, then the spreadsheet will also work in the (free) online version of Excel available at: https://www.microsoft.com/en-gb/microsoft-365/free-office-online-for-the-web.
Note: V3 of the calculator has added the course ratings for other Get Golfing courses.
England Golf Handicap Calculator
England Golf’s mixed-tee spreadsheet calculator:
mixed-tee-calculator-2024-update-120
Intelligent Golf and Golf Genius Handicap Calculators
[JT: Note that SOGC has now changed from, to Golf Genius, for all competition functions, Golf Genius, provides a (fairly rudimentary) handicap calculator and I will update this page in due course.]
The IG app has a calculator which will produce Course and Playing Handicaps for all “Acceptable” formats of play and also for some other formats.
The advantage of the IG calculator over the England Golf one is that it has all the SOGC course Ratings built in, so these do not have to be typed in, as in the EG one.
JT’s Calculator (JTCalc)
JTCalc calculator only calculates for Pairs Matchplay formats.
However, JTCalc has certain advantages over the EG calculator:
a) The Slope, Course Rating and Par are built into the spreadsheet. Other course ratings can easily be added, on request.
b) Unlike the EG calculator, JTCalc reveals the full details of how the calculation is done, which can be useful if the calculated shots are disputed by your match opponents.
c) The calculation “block” of cells for each format can be directly copy/pasted to make “Fixture sheets” for multiple matches, for example in interclub matches, which cannot easily be done for the IG or myEG apps.
[Because our Knock-Out competitions can have each match be played on either SOGC course, the Knock-Out competitions were set up, in IG, with the course selection left “open”, so that IG did not automatically provide the appropriate Course or Playing Handicaps. This was the initial reason for building JTCalc. Winter 2024/25 Knock-Out competitions are going to be completed on the legacy IG system. We will update this page once we have confirmed how Golf Genius will be configured for summer 2025 Knock-Out competitions.