Use this Excel chicken dinner planner when you're making the Julia Child roast chicken recipe. Enter your meal time and the chicken weight. The planner shows the start and end time for each step
About once a month, I make a roast chicken dinner, using Julia Child's Roast Chicken recipe. It always turns out beautifully, and the cooking time is based on a formula. There is a base cooking time of 45 minutes, plus 7 minutes per pound.
To make it easier to calculate the cooking times, I've created this Excel Chicken Dinner Planner that you can download. Just enter the meal time and chicken weight, and let Excel calculate the time to start each step. Or, use the interactive Excel file below, if your browser supports that feature.
The first step is to enter the time when you want to have your chicken dinner.
Next, choose a measurement type from the drop down list in cell F4.
Then, type the chicken's weight in cell F5, as a decimal number.
After you enter the meal information in the 3 green cells on the DinnerPlan sheet, Excel shows the steps with their start times.
After the 3 green cells at the top have been filled in, Excel calculates the start time for each step.
Then, you can print the steps schedule, and take it to the kitchen.
First, though, you can hide the 3 columns at the right - columns G, H and I. They have calculations, and don't need to be printed
You don't need to know how the step time calculations work -- you can just fill in the green cells, and print your schedule. But, if you're interested in how the Chicken Dinner Planner works, this section explains:
To calculate the cooking times, there are formulas on the Calcs sheet. These are based on Julia Child's formula -- a base cooking time of 45 minutes, plus 7 minutes per pound.
To calculate the start and end time for each step there are formulas on the DinnerPlan sheet.
First, in column G, there is a simple formula to convert the minutes to hours: =F10/60
Next, in column I, a step number is typed in each row. This is the step number for the step that starts when the current step ends.
Some steps can be started before the previous step is completed, so this column gives us better control over the timing.
For example, we can start step #3 (heat oven to 425°) before step #2(bring to room temp) is completed. So, the End Cell Link for step 3 is "4" -- the lemon should go into the chicken after it is at room temperature.
In some cases, multiple steps have the same End Cell Link -- both step 3 and step for are linked to step 5.
In column H, there is an INDEX and MATCH formula that gets the value from the Start cell that is entered in the End Cell Links cell.
In column B, the last Start Time, in cell B21, is linked to cell F3 (DinnerTime), where you entered your meal time.
In all the other Start Time cells, a formula refers to the end time in that row, and subtracts the step's hours, divided by 24
For the "Bring to room temp" step,
If your browser supports it, try the Chicken Dinner planner in this embedded Excel workbook.
In the green cells at the top of the DinnerPlan sheet, enter your Meal Time, Measurement Unit and Weight, to see when each step starts.
Download a copy of the free Chicken Dinner Planner.
The zipped file is in xlsx format, and does not contain any macros.
Last updated: July 25, 2018 11:22 AM
Contextures RSS Feed