Use this workbook to plan the timeline for holiday meal preparation. Enter the dinner time, then list the menu items and the time for each step. Print a timetable list, or a Gantt chart
The first step is to select a dinner time. Go to the DinnerPlan sheet, and select a time from the drop down list in cell H2. The drop down list was created with Data Validation, and the times are in a table on the Lists sheet.
There are meal items, time, cooking locations, and process lists, on the Lists sheet. You can add more items, if you need to. The lists are in named Excel tables, so they will expand automatically.
To add an item to one of the lists:
Next, go to the DinnerPlan sheet, where you will enter all the preparation steps for each food that you'll serve, with the time required for each step.
You'll enter items in the green cells (instructions below).
There are hidden columns (I:N) that contain formulas.
For each food item that is on your menu, enter all the preparation activities on the DinnerPlan sheet. Type in the green cells only-- the grey cells have formulas..
For example, there are 5 preparation steps for the Turkey -- prepare stuffing, stuff the turkey, cook the turkey, let the turkey stand a few minutes after cooking, and finally, carve the turkey.
It doesn't matter what order you enter the food items, because the list will be sorted later.
To enter the first activity, follow these steps:
Move down to the next row, and repeat those steps, to enter the other 4 preparation steps for the turkey, and the other meal items.
After all the preparation activities have been entered, follow these steps to sort the timetable.
After the meal items have been entered, and the list is sorted by Start Time, you can print the schedule. There are two options for printing:
To go to either printout sheet, click the link in column O of the DinnerPlan sheet.
Here is the printed timeline, showing when the preparation has to get started, and all the steps for getting the meal ready.
Here is the dinner preparation schedule in a Gantt chart timeline.
1. Basic Planner: Download a copy of the free Excel Holiday Dinner Planner. The zipped file is in xlsx format, and does not contain any macros.
2. With Recipe Finder: Download a copy of the free Excel Holiday Dinner Planner and Recipe Finder. The zipped file is in xlsmx format, and contains macros and connections for the recipe finder.
3. Excel 2003: Download a copy of the free Excel Holiday Dinner Planner and Recipe Finder for Excel 2003. The zipped file is in xls format, and contains macros and connections for the recipe finder.
Last updated: July 9, 2021 7:22 PM