c#中excel创建新表_在Excel中创建计划

c#中excel创建新表

This weekend is our Canadian Thanksgiving, and we'll have 16 people here for dinner. To make sure that all the dishes are ready on time, I'll use Excel to schedule everything that has to be done. We’ve been using this meal planner for years now, and would be lost without it!

这个周末是我们的加拿大感恩节，我们将有16个人在这里共进晚餐。 为了确保所有餐具都能按时准备好，我将使用Excel安排必须完成的一切。 我们多年来一直在使用这个膳食计划器，如果没有它，它会迷路的！

从头开始 (Start With the End)

In some projects, you decide when to start, calculate how long each step will take, then estimate when the project will be finished. Since the goal of this project is to serve dinner at a specific time, we’ll plan the schedule backwards, instead of forwards.

在某些项目中，您决定何时开始，计算每个步骤将花费多长时间，然后估计项目何时完成。 由于该项目的目标是在特定时间提供晚餐，因此我们将计划的时间安排在后退而不是后退。

So, the first thing you’ll do in this meal scheduler is to enter the time that you want to serve dinner. You don’t even have to type the time -- there is a drop down list of times, that was created with Data Validation.

因此，您将在此膳食安排器中做的第一件事是输入您要提供晚餐的时间。 您甚至不必键入时间-下拉列表是使用Data Validation创建的。

输入任务 (Enter the Tasks)

Whether your project is preparing a holiday dinner, or a software release, or anything else, you need to know what steps are involved.

无论您的项目是准备节日晚宴，还是软件版本，或其他任何事情，您都需要知道涉及哪些步骤。

For this dinner schedule, you’ll enter all the preparation steps for the menu items, and an estimated time for each step. You can enter the time in minutes or hours, whichever you prefer.

对于此晚餐时间表，您将输入菜单项的所有准备步骤，以及每个步骤的估计时间。 您可以选择以分钟或小时为单位输入时间。

The Item and Location columns have drop down lists too. You can add or remove items on the Lists sheet.

“项目”和“位置”列也具有下拉列表。 您可以在“列表”表上添加或删除项目。

For example, I have an electric pressure cooker now, so maybe I’ll make something in that this year. Or maybe I’ll stick with the appliances that I know more about!

例如，我现在有一个电压力锅，所以也许今年我会有所作为。 或者，也许我会坚持使用我更了解的电器！

打印时间表 (Print the Schedule)

There are formulas in the first column, to calculate the start times. After you enter everything, sort by the Start time column, and you’re ready to start cooking.

第一列中有公式，用于计算开始时间。 输入所有内容后，请按“开始时间”列排序，然后就可以开始烹饪了。

You can print the schedule in a worksheet list, and cross off the items as you complete them.

您可以将进度表打印在工作表列表中，并在完成时将其划掉。

Or, if you like to see a timeline, print a Gantt chart that shows the schedule.

或者，如果您想查看时间线，请打印一个显示计划的甘特图。

下载工作簿 (Download the Workbook)

If you’d like a copy of the workbook, go to the Excel Holiday Dinner Planner. page on my Contextures website. On that page, scroll down the  Download section, and click the workbook link.

如果您需要工作簿的副本，请转到Excel Holiday Dinner Planner 。 我的Contextures网站上的页面。 在该页面上，向下滚动“下载”部分，然后单击工作簿链接。

And Happy Thanksgiving, if you’re celebrating!

感恩节快乐，如果您正在庆祝！

翻译自: https://contexturesblog.com/archives/2016/10/06/create-a-schedule-in-excel/

c#中excel创建新表