funcode高尔夫_高尔夫发球时间的Excel工作簿

funcode高尔夫

The golf courses aren't too crowded here this summer, because of the social distancing rules. So, if you're trying to spread out the players at your course, use this Excel workbook for golf tee off times.

由于社会疏远的规定，今年夏天这里的高尔夫球场不太拥挤。 因此，如果您想在课程中分散球员，请使用此Excel工作簿进行高尔夫开球时间。

高尔夫发球时间练习册 (Workbook for Golf Tee Off Times)

Watch this video to see how you can schedule player tee off times with the Golf Tee Off Times workbook.

观看此视频，了解如何使用“高尔夫发球时间”工作簿来安排球员发球时间。

NOTE: There's a link at the end of this post, where you can get the workbook.

注意：这篇文章的末尾有一个链接，您可以在其中获取工作簿。

演示地址

入门 (Getting Started)

In the workbook for golf tee off times, drop down lists and macro buttons make it easy to select players, and assign them to starting times.

在高尔夫开球时间的工作簿中，下拉列表和宏按钮使您可以轻松选择球员并将其分配给开始时间。

To set things up, you'll enter a date and number of players on the Summary sheet.

要进行设置，您将在“摘要”表上输入日期和玩家人数。

The Summary sheet says "Golf Tournament Tee Off Times" but some people use this to book plays for a specific date at their golf club.

“摘要”表上显示“高尔夫比赛发球时间”，但有些人用它在高尔夫俱乐部预订特定日期的比赛。

添加玩家 (Add the Players)

The next step is to add the player names, on the PlayerList sheet. You might enter all the member names for your golf club, or people who have signed up for a tournament.

下一步是在PlayerList表上添加玩家名称。 您可以输入高尔夫俱乐部的所有会员名，或者输入已注册锦标赛的人的姓名。

添加开球时间 (Add the 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.

接下来，转到TeeOffTimes工作表，在该工作表中有一个Excel表，其中输入了开球时间的列表，以及4列球员姓名。

You can use the Tee Off Times list as it is, or type different times in the Times column. You might need more time between the groups now, to keep people further apart.

您可以按原样使用“发球时间”列表，或在“时间”列中键入不同的时间。 您现在可能需要在小组之间留出更多时间，以使人们之间保持更远的距离。

选择球员开球时间 (Choose Players for Tee Off Times)

Finally, you'll go to the PlayerList sheet, and assign players to a tee off time.

最后，您将进入PlayerList表，并为开球时间分配球员。

• 

  At the top left, select an available  Tee Off Time from the drop down list.

  在左上方，从下拉列表中选择可用的发球时间。

• Then, in the list of players, type an X  in the Mark column, for each player you want to assign to that tee off time.

  然后，在玩家列表中，为要分配给该发球时间的每个玩家在“标记”列中键入X。

  

检查摘要表 (Check the Summary Sheet)

To see how things are going, you can check the Summary sheet.

要查看进展情况，可以查看摘要表。

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.

一览无余，您可以查看是否所有玩家都已预定开球时间，以及是否在工作簿中输入了足够的开球时间。

保持距离 (Keep Your Distance)

If the golf tee off times workbook doesn't help you keep the players far enough apart, here's another idea – add more hazards. That will keep the players moving along.

如果高尔夫开球时间练习簿不能帮助您使球员保持足够的距离，这是另一个想法–增加更多的危险。 这将使玩家继续前进。

We spent a few winters in South Carolina, and the golf courses there had a special feature – alligators! My husband lost his ball in that pond, and didn't even think about stopping to retrieve it!

我们在南卡罗来纳州度过了几个冬天，那里的高尔夫球场有一个特色-鳄鱼皮！ 我丈夫在那个池塘丢了球，甚至没有想过要停下来找球！

获取工作簿 (Get the Workbook)

To get the workbook for golf tee off times, and to learn how it works, go to my Contextures website.

要获取高尔夫开球时间的工作簿并了解其工作原理， 请访问我的Contextures网站 。

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

该文件为xlsm格式，并包含宏。 当您打开工作簿时，如果要测试“高尔夫发球时间”工作簿，请启用宏

翻译自: https://contexturesblog.com/archives/2020/06/11/excel-workbook-for-golf-tee-off-times/

funcode高尔夫