Pages

Monday, September 23, 2013

A view of the shopping list for our cooking day - the first step

Our shopping list is about three pages long in Excel, so I'll just show you how I did it so you can have an idea how to do it.

As you can see, I numbered the meals, then put the number needed per meal.  This worked out well for me.  In Excel, if you don't use letters in the columns you can add up all the stuff, just using the formula for adding.  So you have to make sure you keep all amounts the same (i.e. convert everything to Tablespoons  or back to teaspoons, whichever works best).  Then make a column for totals.  This saves so much on second guessing whether you added right.

We had 39 recipes and a side and a sauce and way more ingredients than this.   I tried to divide the ingredients between 7 people, but it was not super even.  We'll even it up when we figure out who still owes money and who needs to be reimbursed.


#1 #2 #3 #4 #5 #6
# of recipes 5 5 2 6 6 2
allspice
aluminum foil
aluminum pan (9x13) 5 6
aluminum pan (pie) 4
baking potatoes
basil
Bay leaves
beef
beef boullion
bread crumbs 3
broccoli 12
brown sugar
butter 10

No comments:

Post a Comment