This golf tournament manager and tracker spreadsheet is one of spreadsheets that I have prepared several years ago. I created it when I was learning to play golf. I am being reminded again when I watched The Open golf tournament, one of major golf tournament, won by Francesco Molinari. It is very unfortunate that Tiger Woods couldn't keep up with him in the back nine of the last round.
I have finally finished this spreadsheet with stroke play format while watching the last round of The Open Championship and you will see that I simulated that tournament in this spreadsheet by putting results from those four rounds. But, sorry, this is not a free spreadsheet. But, you can try the demo version to see whether if it fits your own tournament. Or, you can use this to simulate many tournaments to track particular player statistics.
This spreadsheet consists of six big parts,
You can start using this spreadsheet by putting golf course information. You can fill until 100 golf courses information in this worksheet. It is expandable as well. Put golf course names at the table in the right side before you type respective information for those golf courses. Put par, stroke index and distance information in particular rows and columns, as you can see in this Demo spreadsheet. You can fill only Par information and leave other information empty.
Put names of your tournament in this worksheet. You can organize until maximum 4 rounds per tournament (like The Open Championship). Then, type respective scoresheet number and select courses that you want to use. Put tournament dates where you can see them marked in Calendar next to tournament table. At the right side, you will see point table where you can fill your own point if you want to implement Point Race system for all of your tournaments.
Put player names, with their handicap, nationality and additional notes in this worksheet. You can extend the table to include other important information. This player list will be used as a player dropdown list in every game scoresheets. You can put until 400 players and you can extend it easily by inserting rows to any numbers. In demo version, I put 156 The Open Championship participants sorted by their first names.
Notes for handicap: If handicap for particular players are changed after some games, you can update it in game scoresheet directly.
In Demo version, I put four scoresheets with results from all four rounds of The Open championship to help you understanding how this spreadsheet works.
In the first scoresheet, I copied player names from player list (I don't have to select it one by one) and paste it into player name column (you need to paste it as values to keep the prevent dropdown list being overwritten). Select your course, type game date, select distance category (black, white, yellow, blue, red) before starting to put golfer's scores in hole 1 - 18 columns. You may set their group, tee time and start holes. At the right side, you will see golfer's rank for particular round.
In the second game scoresheet, I put player names based on their results in the first round. How to do it quickly? Just copy player names from golfer's rank table in previous round and paste it (as values) in player names column.
In the third game scoresheet, I repeated copying and pasting player names, except there are players that won't be included because players with scores +4 and above are getting cut.
Again, in the fourth game scoresheet, you can copy and paste player names from leaderboard. It will make you organize group pairing and their tee time easily.
Here, you can track your player's ranks in any rounds, from the first until the fourth round. Just pick your tournament name, select particular round and the formula will rank all golfers automatically. There is an option to rank them based on Best Gross and Best Net by toggling cell D6.
Also, there is a Play Off table for deciding tournament champion if more than one golfer are tying in the first position. You just need to type "V" for playoff winner in "WON" column. There is point column in this worksheet. It will award points based on ranks. It follows PGA rule where only top 70 that will get points. If more than one golfer is sharing similar position, then they will get similar points by averaging points for their position. In this demo version, leaderboard worksheet is not linked with game scoresheet. It will show you The Open Championship result only.
You can play around with this Demo version before purchasing the Pro version. You can read more information on features and how to purchase in About worksheet inside the Demo version spreadsheet.
One thing, there is Google Spreadsheets version where any golf courses and golf event organizer can use it to record and share it directly to all event participants online. Also, it should fit you who want to collect, track and simulate any golf tournaments.
You can drop me email if you want to customize this golf tournament manager and tracker spreadsheet since you might have specific regulation for your tournaments.
How useful was this template?
Click on a star to rate it!
