excel自动排班有假期_Excel假期晚餐时间表

excel自动排班有假期

Excel假期晚餐时间表 (Excel Timetable for Your Holiday Dinner)

Happy Thanksgiving, if you’re celebrating today! Our Canadian Thanksgiving was last month, so I don’t have to worry about organizing a big dinner today.

感恩节快乐，如果您今天正在庆祝！ 我们的加拿大感恩节是上个月，所以我不必担心今天要组织一顿大餐。

If you’re responsible for getting the family meal on the table today, you can use my Excel Holiday Dinner Planner.

如果您今天负责餐桌上的家庭用餐，则可以使用我的Excel Holiday Dinner Planner 。

Yes, it takes a few minutes to set up, by entering all the food items, and the preparation steps, but it will be worth the effort! You probably don't vary the holiday menu too much, so you can reuse the worksheet, year after year.

是的，输入所有食品和准备步骤需要花费几分钟的时间进行设置，但这值得您付出努力！ 您可能不会对假期菜单进行太多更改，因此可以年复一年地重复使用工作表。

计算开始时间 (Calculate the Start Time)

After you enter all the dinner items, go to the top of the worksheet, and select the time that you want to serve dinner. Automatically, the Excel dinner planner calculates the preparation start time for each item.

输入所有晚餐项目之后，请转到工作表的顶部，然后选择要提供晚餐的时间。 Excel晚餐计划者自动计算每个项目的准备开始时间。

跟随清单 (Follow the List)

With the planner, you'll have a complete list of dinner items, with preparation start and end times. Follow the list, and you won't be likely to forget those dinner rolls in the oven, or leave the cranberry sauce in the fridge.

使用计划器，您将获得晚餐项目的完整列表，以及准备工作的开始和结束时间。 按照清单进行操作，您将不会忘记将那些晚餐面包卷放在烤箱中，或者将酸果蔓酱放在冰箱中。

You can print a list, or a Gantt chart version, to show the preparation schedule.

您可以打印列表或甘特图版本以显示准备时间表。

You can find more instructions, and download links, on the Excel Holiday Dinner Planner page on the Contextures website.

您可以在Contextures网站的Excel Holiday Dinner Planner页面上找到更多说明并下载链接。

Enjoy your dinner!

祝您晚餐愉快！

翻译自: https://contexturesblog.com/archives/2013/11/28/excel-timetable-for-your-holiday-dinner/

excel自动排班有假期