高尔夫球推杆模型_在Excel中设置高尔夫球发球时间

There's a Golf Tee Time Excel workbook on the Contextures site, that I've updated, to add a few new features. You'll list all the players, then set up golf tee times in Excel.

我已更新了Contextures网站上的Golf Tee Time Excel工作簿，以添加一些新功能。 您将列出所有球员，然后在Excel中设置高尔夫开球时间。

The new version of the Golf Tee Time file has data validation in column C, which limits the selection to 4 names, and you can't mark a name that is already booked. The time selector only shows tee times that haven't been assigned.

新版本的Golf Tee Time文件在C列中进行了数据验证，这将选择范围限制为4个名称，并且您不能标记已预订的名称。 时间选择器仅显示尚未分配的发球时间。

分配高尔夫球发球时间 (Assign Golf Tee Times)

On the MemberList sheet, you can enter a list of names in column B. Mark up to 4 names, by typing an X in column C.

在MemberList表上，您可以在B列中输入名称列表。通过在C列中输入X，最多可以标记4个名称。

Then, select a start time for the marked names.

然后，为标记名称选择开始时间。

The drop down list only shows the available times. In the example below, the 8:20 AM time has been filled, so it's not in the drop down list.

下拉列表仅显示可用时间。 在下面的示例中，已经填满了上午8:20的时间，因此不在下拉列表中。

Finally, click the Book Times button, to add the marked names to the selected time slot.

最后，单击“预订时间”按钮，以将标记的名称添加到所选的时间段。

发球时间选择器的工作原理 (How the Tee Time Selector Works)

When you click the Book Times button, a macro filters the marked names into a hidden column (H) on the MemberList sheet. The criteria range for the advanced filter is range F3:F4.

当您单击“预订时间”按钮时，宏会将标记的名称过滤到MemberList表上的隐藏列(H)中。 高级过滤器的标准范围是F3：F4。

Then, those names are copied, and transposed onto the TeeOffTimes sheet, in the row that matches the selected time.

然后，将这些名称复制并转置到与所选时间匹配的行中的TeeOffTimes工作表上。

After pasting the names, the Mark column is cleared, so you can select the next group of names.

粘贴名称后，“标记”列将被清除，因此您可以选择下一组名称。

To start over, clear all the names from the TeeOffTimes sheet (the green cells in the screen shot above).

要重新开始，请清除TeeOffTimes工作表中的所有名称(上面屏幕截图中的绿色单元格)。

下载样本文件 (Download the Sample File)

To get the golf tee time workbook, go to the Golf Tee Off Times page on my Contextures site.

要获取高尔夫球开球时间工作簿， 请转到 Contextures网站上的“高尔夫球开球时间”页面 。

The file is in xlsm format, and is zipped. The workbook contains macros, so you'll need to enable macros if you want to test the time booking feature in the sample file. __________

该文件为xlsm格式，并已压缩。 该工作簿包含宏，因此，如果要测试示例文件中的时间预订功能，则需要启用宏。 __________