Excel Workbook for Golf Tee Off Times Update

Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site, and you could adapt it for building other types of schedules. This week, I uploaded a second version of the file – it gives you more flexibility in assigning people to specific times.

Golf Tee Off Times

There’s a Golf Tee Off Times workbook on my Contextures site, where you can:

select a starting time from a drop down list
mark 4 player names with an X
click a button to assign those players to the daily schedule

Player List Formatting

After a player has been assigned to a start time, conditional formatting shades that row

In the Time column, an INDEX/MATCH formulas show the tee off time for that player.

Start Time Drop Down List

After you assign players to a starting time, that time disappears from the drop down list.

In this example, players have been assigned to the 8:00 AM and 8:30 AM tee off times.

When you go to choose the next start time, the 8:00 AM and 8:30 AM tee off times are missing from the list.

Allow Partially Filled Time Slots

In the original version of the Golf Tee Off Times workbook, a starting time was treated as filled, if you assigned 1 or more players to that time.

If you changed your mind later, and wanted to add more players, you could go to the Tee Off Times sheet, and add the names there, manually.

In this screen shot, a name will be added to the 9:10 AM start time, by typing in cell D11.

Keep Time Slots Open

Someone asked how they could change the workbook, to allow additions to partially-filled time slots. So, I made a new version of the workbook, where you can do that.

In the new version, only the completely filled time slots disappear from the drop down list.

And, if you select a partially-filled time, the previously selected players are highlighted in the player list.

Just mark those players again, if you want to keep them at that time
Then, mark additional players, to a maximum of 4 names

Video: Golf Tee Off Times

This video shows how the original Golf Tee Off Times file works, and the newer version is almost the same.

Get the Workbooks

To get one or both of the Excel workbooks for golf tee off times, and for details on how they work, go to my Contextures website.

The files are in xlsm format, and contain macros. When you open the workbook, enable macros if you want to test the Golf Tee Off Times workbook

_________________________