Jump to content
inghamspur

Golf tour competition spreadsheet

4 posts / 1106 viewsLast Reply

Recommended Posts

Hi there. New to the forum so not sure if this has already been out there. Going away for a 3 day golf break soon and I am the 'Keeper of the spreadsheet'. The spreadsheet we use at the moment is one that I devised but still involves too much manual input and prove to human error. Therefore, was wondering whether there was something ready made out there. 12 of us in the group and we normally have singles, pairs & team comps. If not, then I'll hone my spreadsheet skills!!

Share this post


Link to post
Share on other sites

Want to hide this ad? Register for free today!

4 hours ago, inghamspur said:

but still involves too much manual input

Welcome to TST. I can throw a few ideas with spreadsheets which I have created.
Send me a PM to discuss the games which you guys play and payouts.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

On 4/7/2018 at 5:08 PM, Club Rat said:

Welcome to TST. I can throw a few ideas with spreadsheets which I have created.
Send me a PM to discuss the games which you guys play and payouts.

Hi I run a competition each week where up to 120 players play in the season. Each week we play an individual stableford where the top 5/6 players win. As a result the winners are peanalised  shots for a number of weeks (first 4, second 3...) in addition the shots penalty depends on handicap category so Div 1 = 1 shot thru to Div 4 4 shots.

The penalty remains until the player has played for the required number of weeks. If the player misses a week the penalty moves on.

I manually input the scores each week which takes about an hour. I am looking for ways to automate the input of scores and then calculate the penalties. Can you help?

I attach the spreadsheet,   

Tuesday Swidle.xlsx

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

The popup will be closed in 10 seconds...