# Excel Golf Tee Off Times

Get this free Excel golf tee off times workbook, to choose player tee off times for golf tournaments, or for daily players at a golf course. Select a start time, choose 4 players, and click a button to add them to the schedule.

## Golf Tee Off Times Intro

Use this workbook to set up the tee off times for your golf tournaments, or for daily players at a golf course. 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:

• Set Player Tee Off Times

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.

## Summary Sheet

To customize the Golf Tee Off 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.

NOTE: In the "Partially-Filled" version of the Tee Off Times workbook, there is an extra row with formulas. The formulas show how many time slots are completely filled, and how many are partially filled.

## Enter Player Names

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.

• Type over those placeholder names, to replace them with your player names.
• Then, delete any rows that you don't need, or add more rows to the table, if necessary.
• Optional - Sort the names A-Z, so they're easier to find

Note: There are formulas in the "Booked" and "Time" column, so don't make changes there.

## Enter Tee Off Times

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.

#### Edit the Tee Off Times

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.

#### Add More Tee Off Times

If you need more tee off times, follow these steps to add them:

• Click in the blank cell, directly below the last time entered in the table
• Type the next starting time, and press Enter
• The table will expand automatically, and a number will appear in the first column
• Next, check cell G1, to see if there is a message about adding more Time IDs.
• If you see a message, click the link, to go to the Admin_Times sheet

• Check the yellow cell (E3) at the top of the sheet - it shows the number of new TimeIDs needed
• Click in the empty cell, directly below the last TimeID in the list
• Type the next number in sequence, and press Enter
• The table will expand automatically, and the formula in the TimeCalc column will automatically fill in.
• Repeat these steps, if necessary, until cell E3 shows a zero, and changes to grey fill

## Set Player Tee Off Times

The final step is to assign players to a tee off time. There are 2 versions of the Excel workbook, Original and Partially-Filled, and the steps for each version are shown below.

#### 1. Tee Off Time

On the PlayerList sheet, select a Tee Off Time from the drop down list.

NOTE: Only the available times show up in this drop down - booked times are hidden.

• Original version: If 1 or more players are booked for a tee off time, that time does not appear in the drop down list
• Partial version: If any spots are left in a tee off time, that time does appear in the drop down list

#### 2. Mark Players

In the list of players, type an X or x in the Mark column, beside each player you want to assign to that tee off time. If you try to mark more than 4 names, an error message will appear.

Original Version

Mark the players you want to add to the selected tee off time.

Partial Version

For partially-filled tee off times, the previously selected players are highlighted, in the Time column.

To keep those players in the time slot, mark them with an X. Otherwise, they'll be removed from that time slot.

#### 3. Book Times

Click the Book Times button, to add those players to the TeeOffTimes sheet, at the selected time.

#### Player List Updated

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:

• Fill colour in Mark column changes to white
• "Y" appears in the Booked column
• Player's tee off time appears in the Time column

## How It Works

The Excel Golf Tee Off Times workbook uses formulas and macros to assign selected players to their tee off times.

### Macros

There are 2 macros in the workbook, and they run when you click the buttons on the worksheets.

#### ClearNames

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.

#### PlayerTimes

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.

• Otherwise, the names marked with an X are filtered onto the Admin_Macro sheet. The Advanced Filter uses the criteria on that sheet, in cells H1:H2
• Then the list is copied, and pasted horizontally in cells L2:O2 (named NamesTrans).
• Next, the horizontal list is pasted on the the TeeOff Times sheet
• Finally, the Tee Time cell on the PlayerList sheet is cleared

### Formulas

There are formulas on most of the worksheets, and here is a brief look at what the formulas do.

#### TeeOffTimes

There is a formula in the first column (Open), to number the tee off times that are still available. Those numbers are used on the Admin_Times sheet, to create a list for the Tee Off Time drop down.

The formula is slightly different in each version.

Original Version

Tee off times with any number of players are NOT available, so here's what the formula does:

• counts the entries in the Player columns
• if the count is > zero, the result is an empty string -- ""
• ff the count is zero, it finds the highest number in cells above, and adds 1

=IF(COUNTA(tblTOT[@[Player1]:[Player4]]), "", MAX(\$A\$3:A4)+1)

Partially-Filled Version

Tee off times with fewer than 4 players ARE available, so here's what the formula does:

• counts the entries in the Player columns
• if the count is 4, the result is an empty string -- ""
• ff the count is <4, it finds the highest number in cells above, and adds 1

=IF(COUNTA(tblTOT[@[Player1]:[Player4]])=4,"",MAX(\$A\$3:A3)+1)

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.

• =IF(B2>MAX(TimesCount),"", INDEX(TimesFill, MATCH(B2,TimesCount,1)))

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.

##### Drop Down List of Times

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.

That list is created with data validation, and the list based on a named range = TimeList. It is a dynamic range, and only includes the rows with times in the TimeCalc column.

To see the formula for the TimeList named range, go to the Formulas tab, and click Name Manager, then click on TimeList.

#### PlayerList

The PlayerList sheet has two columns with formulas - Booked and Time

##### Booked

Shows a Y if the player's name is in the TeeOffTimes sheet. The COUNTIF function checks for the name.

• =IF(COUNTIF(TimesBooked,E4),"Y","")
##### Time

Shows the player's tee off time, from the TeeOffTimes sheet. This complex formula is array-entered, with Ctrl-Shift-Enter

• =IFERROR(INDEX(TimesFill, MATCH(1, MMULT(--(TimesBooked=E4), TRANSPOSE(COLUMN(TimesBooked)^0)), 0)),"")
##### Conditional Formatting

For partially-filled tee off times, the Time column has conditional formatting, so previously selected players are highlighted.

#### Summary

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 been booked to tee off times, and if enough tee off times have been entered in the workbook.

NOTE: In the "Partially-Filled" version of the Tee Off Times workbook, there is an extra row with formulas. The formulas show how many time slots are completely filled, and how many are partially filled.

## Get the Workbook

1. Original File: Get the zipped Golf Tee Off Times workbook. This version only shows time slots that have NO players assigned. 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
2. Partially Filled Times: Get the zipped Golf Tee Off Times Partial Fill workbook. This version shows time slots that are partially filled, so you can complete them later. 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

## Related Pages

Excel Golf Scores