Genu9
Member
Back during lockdown when we could play golf but not go in the Clubhouse I arranged a few ad-hoc competitions. The problem was how to collect the scores when ‘social distancing’ didn’t allow it. (even handling of others scorecards was taboo).
So, I devised a spread sheet in Google Sheet so that scores could be collected ‘online’. It started out as a simple ‘put the gross scores in’ and I’d covert them to Stableford points and published the winner(s).
Well over the last two years it grew out of all recognition as I included more and more options until today, I have an ‘Ad-Hoc Competition Spreadsheet’ that covers all various formats, (I think), WHS calculations, Course Slope etc. (including Mixed format)
I’ve used it successfully for various competitions that fall outside the normal ‘club’ systems, especially on awaydays where you can’t use any system. It has its limitations, I’ve only made it for 20 teams (80 Players), it relies on having a good 4G signal or WiFi connection and ideally works best on a Windows based PC, although it does work using Chromebook and Android.
I’d now like to share it (for free) with fellow golfers who could make use of it, I’m thinking Societies especially. Because of the nature of Google Sheets I can’t just post one link because people would be tripping over each other if they access the same file at the same time, so I need to send an individual link.
If you think you could make use of it, PM me and I’ll send you your own link. In the mean time you could view this presentation I created a while back. It has moved on quite considerably since then but you’ll get the idea.
Ad-hoc comp Video
So, I devised a spread sheet in Google Sheet so that scores could be collected ‘online’. It started out as a simple ‘put the gross scores in’ and I’d covert them to Stableford points and published the winner(s).
Well over the last two years it grew out of all recognition as I included more and more options until today, I have an ‘Ad-Hoc Competition Spreadsheet’ that covers all various formats, (I think), WHS calculations, Course Slope etc. (including Mixed format)
I’ve used it successfully for various competitions that fall outside the normal ‘club’ systems, especially on awaydays where you can’t use any system. It has its limitations, I’ve only made it for 20 teams (80 Players), it relies on having a good 4G signal or WiFi connection and ideally works best on a Windows based PC, although it does work using Chromebook and Android.
I’d now like to share it (for free) with fellow golfers who could make use of it, I’m thinking Societies especially. Because of the nature of Google Sheets I can’t just post one link because people would be tripping over each other if they access the same file at the same time, so I need to send an individual link.
If you think you could make use of it, PM me and I’ll send you your own link. In the mean time you could view this presentation I created a while back. It has moved on quite considerably since then but you’ll get the idea.
Ad-hoc comp Video