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 IG 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 all other Get Golfing courses.
England Golf Handicap Calculator
England Golf’s mixed-tee spreadsheet calculator:
mixed-tee-calculator-2024-update-120
Intelligent Golf Handicap Calculator
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. For all other formats, IG will provide the Course and Playing Handicaps automatically, following the settings of the club competitions.
However, JTCalc has certain advantages over the EG and IG calculators:
a) Like the IG calculator, for the nine 18-hole SOGC courses, the Slope, Course Rating and Par are built into the spreadsheet. Other course ratings can easily be added, on request.
b) Unlike the IG or EG calculators, JTCalc reveals the full details of how the calculation is done, which can be useful if the Calculated shots are disputed.
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.
d) Related to c), it is easy to add in the ratings for other local courses, which would not be the case for the ig calculator.
Because our Knock-Out competitions can have each match be played on either SOGC course, the competition is set up with the course selection left “open”, so that IG does not automatically provide the appropriate Course or Playing Handicaps. This was the main initial reason for building JTCalc.