Golf Match Play Calculations

[PDXGolfGuy]

Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have figured out basic calculations for the individual net scores sheet.

First Goal:
Goal is to have a player enter their score for a hole, take into account there handicap and if it should be applied (example, I am 18 HDCP therefore I get a stroke subtracted from my entered score each hole, whereas one of my players is a 2 HDCP and based on the course only gets 2 strokes subtracted on holes 6 and 12) and therefore give a score for them.

Second Goal:
Teams are put together during the 3 day tournament (teams 1 and 2, since it's 2 foursomes of golf its 2v2 or team 1A vs team 2A and team 1B vs team 2B. That said I would like to take into account individual scores from above and then based on teams compare which individual had lowest score per hole (i.e. {Player 1 team 1A scores 4, Player 2 team 1A scores a 3; Player 3 team 2A scores 4, Player 4 team 2A scores 5, therefore since player 2 team 1A scored a 3 their score would 'Win' their team the hole. If the hole is tied I would like a notation of either Halved or tied.

I have a added a link of the sheet 'Team Scores' https://drive.google.com/open?id=0B0Af3Tf2bzsLNWk1N2JaZWJiOEE and the look I am going for...and I am open to any suggestions, feedback, etc....

Thank you,
Excel Newb

 

[rpaulson]

this formula should work for you First goal.

Enter it in cell C28 Then fill right and fill down for the rest for the players scorecards.

=IF(C$3<=$B5,C5-1,C5)

Not sure what you are looking for in second Goal.

hth,

Ross

 

[rpaulson]

I posted a file here for you to check out.

http://computermaninc.net/Golf Scores - October (RAP).xlsx

Ross

 

[PDXGolfGuy]

Ross,

Thank you soo much, this totally works, you are awesome If I wanted to copy sheets for different course and update the course handicap information (Static portion in Grey - different for each course), will the calculations update automatically?

PDXGolfGuy

 

[rpaulson]

GolfGuy,

your project was interesting so I made you a new kick-a s s file with some VBA

http://www.computermaninc.net/Golf Scores - October (RAP).xlsm

Enjoy

 

[RyboFlavin]

GolfGuy,

your project was interesting so I made you a new kick-a s s file with some VBA

http://www.computermaninc.net/Golf Scores - October (RAP).xlsm

Enjoy

Hi, I know this is an old post, but I was wondering if you could make your Golf Scores sheet available for download again. I have a very similar need and it seems you may have already developed a great solution.

 

[rpaulson]

i put it back up. enjoy!

 

[dannyboy1990]

I would love to also see this spreadsheet please ,

Im trying to create something like this

 

[rpaulson]

the download link still works:
http://www.computermaninc.net/Golf Scores - October (RAP).xlsm

 

[dannyboy1990]

Ah ok may have to try on my desk top im currently on my phone