barrybridges
Head Pro
Before I begin, I know you're all going to say 'you have far too much time on my hands', which I do.
I would like to ask people for their constructive feedback and thoughts on something I've created.
As we all know, slow play is the bane of most golfers' lives. After yet another 5+ hour round at my local club yesterday I thought I'd do something constructive about it.
Available below is a spreadsheet that I have put together:
http://www.barrybridges.biz/GOLF.xlsx
What I've been thinking about is whether golf clubs could think more intelligently about their tee times, so as to better avoid congestion on the course.
At the moment, most clubs that operate pre-booked times don't really think much about where to slot people in - or if they do, they base their decision purely on the basis of how many players are in a group.
What I've done is create a system that looks not only at numbers, but handicaps - and takes the average performances for different players to semi-accurately (I hope) predict round times.
What this then does is recommend tee times for any given group based on their handicap, in a way that statistically minimises the chance of that group either catching a group ahead, or being caught by a group behind.
Obviously this is based on the 'law of averages', so won't work every time. BUT, statistically, it should work better than the current systems being used out there.
I'd really like to get your thoughts - obviously it's just a spreadsheet for now, but in particularly I'd be keen for people to have a nose under the bonnet and give feedback on my formulae. If people think it's interesting, I'm going to build a proper piece of software with this as its basis, so that clubs can use it (if they want).
To get things going, you just need to enter the hole details for the local course you play on, on the CALCULATOR tab.
On the same tab, you need to specify the number of players in the group in cell S10 - and then enter the handicaps of those players in the cells above. If you don't know, it's fine to put an estimate.
If you're a club, you can specify the intervals between tee times on the TIMESHEET tab.
The rest then takes care of itself. It takes into account strokes, time walking, lost balls and more.
If you then go to the TIMESHEET tab it will recommend tee times for you based on times where you won't catch or be caught by others. Obviously, this bit is geared towards whoever looks after the bookings for tee times.
Anyway, I'd welcome your thoughts. The only change it might make is that when someone takes a booking, they need to ask for the handicaps of those playing - and even then it'll work with an average or estimate.
I would like to ask people for their constructive feedback and thoughts on something I've created.
As we all know, slow play is the bane of most golfers' lives. After yet another 5+ hour round at my local club yesterday I thought I'd do something constructive about it.
Available below is a spreadsheet that I have put together:
http://www.barrybridges.biz/GOLF.xlsx
What I've been thinking about is whether golf clubs could think more intelligently about their tee times, so as to better avoid congestion on the course.
At the moment, most clubs that operate pre-booked times don't really think much about where to slot people in - or if they do, they base their decision purely on the basis of how many players are in a group.
What I've done is create a system that looks not only at numbers, but handicaps - and takes the average performances for different players to semi-accurately (I hope) predict round times.
What this then does is recommend tee times for any given group based on their handicap, in a way that statistically minimises the chance of that group either catching a group ahead, or being caught by a group behind.
Obviously this is based on the 'law of averages', so won't work every time. BUT, statistically, it should work better than the current systems being used out there.
I'd really like to get your thoughts - obviously it's just a spreadsheet for now, but in particularly I'd be keen for people to have a nose under the bonnet and give feedback on my formulae. If people think it's interesting, I'm going to build a proper piece of software with this as its basis, so that clubs can use it (if they want).
To get things going, you just need to enter the hole details for the local course you play on, on the CALCULATOR tab.
On the same tab, you need to specify the number of players in the group in cell S10 - and then enter the handicaps of those players in the cells above. If you don't know, it's fine to put an estimate.
If you're a club, you can specify the intervals between tee times on the TIMESHEET tab.
The rest then takes care of itself. It takes into account strokes, time walking, lost balls and more.
If you then go to the TIMESHEET tab it will recommend tee times for you based on times where you won't catch or be caught by others. Obviously, this bit is geared towards whoever looks after the bookings for tee times.
Anyway, I'd welcome your thoughts. The only change it might make is that when someone takes a booking, they need to ask for the handicaps of those playing - and even then it'll work with an average or estimate.