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

golf tee off times workbook

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.

conditional formatting for assigned players

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.

no numbers for assigned 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.

times missing from drop down 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.

add player to tee off times sheet

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

previously selected players highlighted in player list

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


Excel Workbook for Golf Tee Off Times Update

Excel Workbook for Golf Tee Off Times Update


Original source: https://contexturesblog.com/archives/2021/09/02/excel-workbook-for-golf-tee-off-times-update/?utm_source=rss&utm_medium=rss&utm_campaign=excel-workbook-for-golf-tee-off-times-update

Leave a Reply

Close Menu