Get this free Excel golf tee off times workbook, to choose player tee off times for golf tournaments. Select a start time, choose 4 players, and click a button to add them to the schedule.
Use this workbook to set up the tee off times for your golf tournament. Drop down lists and macro buttons make this golf tee off times workbook easy to use.
First, you'll enter 2 details on the Summary sheet, and then complete these 3 steps:
Watch this video to see how you can schedule player tee off times with the Golf Tee Off Times workbook. The video also shows how the formulas and macros work, if you're interested in learning about that.
To customize the Golf TeeOff Times workbook, the first quick step is to enter your tournament date, and the number of players, on the Summary sheet.
Note: The grey cells have formulas, so don't type anything in those cells.
If the workbook has been used before, and you want to start fresh for a new tournament, click the Clear Bookings button, to remove player names from the TeeOffTimes sheet.
The next step is to enter your player names on the PlayerList sheet. That sheet has an Excel table with placeholder names -- Name01, Name02, etc.
Note: There are formulas in the "Booked" and "Time" column, so don't make changes there.
Next, go to the TeeOffTimes sheet, where there is an Excel table with a list of tee off times entered, and 4 columns for player names. A macro will fill in the player names for you later.
The tournament date (from the Summary sheet), appears at the top of this sheet.
You can use the Tee Off Times list as it is, or type different times in the Times column.
Note: Do NOT enter duplicate tee off times - each time must be listed only once, or the macro that adds the player names to this sheet won't work correctly.
If you need more tee off times, follow these steps to add them:
On the Admin_Times sheet, follow these steps to add the new TimeIDs:
The final step is to assign players to a tee off time.
After a player is assigned to a tee off time, their row in the Players list changes, like the Toni W row in the screen shot below:
The Excel Golf Tee Off Times workbook uses formulas and macros to assign selected players to their tee off times.
There are 2 macros in the workbook, and they run when you click the buttons on the worksheets.
This macro clears all the player names from the table on the TeeOffTimes sheet. To run the macro, click "Clear Bookings" on the Summary sheet or click "Clear Names" on the TeeOffTimes sheet.
This macro puts the selected player names onto the table on the TeeOffTimes sheet, at the selected time. The macros stops, if you haven't selected a tee off time.
There are formulas on most of the worksheets, and here is a brief look at what the formulas do.
There is a formula in the first column (Open), to number the tee off times that have NOT been booked.
The formula counts the entries in the Player columns, and
Those numbers are used on the Admin_Times sheet, to create a list for the Tee Off Time drop down.
The Admin_Times sheet has a table with Time IDs. In the TimeCalc column, a formula gets the tee off time for each ID, from the TeeOffTimes list.
Time IDs are manually entered in the TimeID column, and there must be one ID for each tee off time on the TeeOffTimes sheet. There are simple formulas in cells E1:E3, to check if the numbers are the same. If not, cell E3 changes to yellow fill, with conditional formatting.
Only the tee off times with numbers will appear in the Tee Off Times drop down list on the PlayersList sheet. In this example, 8:00 AM and 8:30 AM are booked, so they're not in the drop down list.
To see the formula for the TimeList named range, go to the Formulas tab, and click Name Manager, then click on TimeList.
The PlayerList sheet has two columns with formulas - Booked and Time
Shows a Y if the player's name is in the TeeOffTimes sheet. The COUNTIF function checks for the name.
Shows the player's tee off time, from the TeeOffTimes sheet. This complex formula is array-entered, with Ctrl-Shift-Enter
The Summary sheet has several simple formulas, in the grey cells, to count the players and times.
At a glance, you can see if all the players have teen booked to tee off times, and if enough tee off times have been entered in the workbook.
Download the zipped Golf Tee Off Times workbook. The file is in xlsm format, and contains macros. When you open the workbook, enable macros if you want to test the Golf Tee Off Times workbook
Last updated: May 24, 2019 2:14 PM