Countdown to Turkey Day November 12, 2010: The Shopping List Clarification

Dear Home Ec 101,

Can you clarify your directions for making the shopping list from your Thanksgiving menu using a spreadsheet?

Signed,

Confused in Conyers

Heather says:

Sure thing, a visual might help and keep in mind I was cooking for 20, before you freak out over 2lbs of butter.

Click the image for a bigger version.

At the top of each row is the name of the recipe. Since almost all of the recipes are available on this site, I have the recipe linked underneath. Otherwise I would just have them near me as I created the spreadsheet.

Below each recipe I list the ingredients (all of them, even salt, pepper etc)

Below the ingredient lists, I made headings of grocery store sections: Dry Goods, Produce, Butcher, etc.

Then I copied and pasted the ingredients from below each recipe heading into the appropriate grocery store section. I also indicated the quantity of the item when it was necessary: pounds of potatoes, bunches of celery etc.

When all was said and done, I copied and pasted the grocery store sections onto a new tab and printed.

I hope this clarifies things for you.

Send your questions to helpme@home-ec101.com.



Leave a Comment