Cooking with RTM

brumley says:
I love to cook and RTM has helped me a great deal. I have three list I use (dinner, grocery, pantry)
The Dinner List
Like erlang http://www.rememberthemilk.com/forums/tips/10570/ I also have a "dinner" list. I put all the dishes I have made before or would like to make. Each dish is tagged with #cuisine and #course but no due date.
Because I have hundreds of tags, all my food related tags are prefixed with an underscore _ so they are seperated from my work tags
Cuisine is prefixed with _+
_+italian
_+mexican
_+asian
Course is prefixed with _-
_-appetizer
_-side
_-main
_-dessert
Latter the dish is used to tag ingredients in my grocery list
_tortilla soup
_paella
_tuscan chicken
I use the url to add a link to any youtube clip related to preparation or if not available, to a webpage.
I add several notes,
1. Ingredients
2. Preparation
3. Pairings (wine, side dishes, etc)
4. Leftover Ideas (grilled chicken --> chicken Caesar salad --> buffalo chicken wraps --> chicken and pesto pizza --> fajitas)
5. Search tags to recall grocery list ie. tag:_paella AND status:completed
When I am ready to plan I search by cuisine and give the courses a due date I plan to make the dish. When done I remove the due date.
The Grocery List
I have the items I usually buy at my local store in an excel spreadsheet list. In excel I select the items I want to buy, filter the list and email the list to RTM.
My spreadsheet is set up like this.
Column 1 - Store section
Column 2 - Frequency (so I can filter list to hide infrequent items)
Column 3-5 - Sorting categories (Produce-Fruit-Citrus, Produce-Vegatable-Root)
Column 6 - The name I want to see in my list ie. Orange or Potato
Column 7 - descriptive info ie Navel or Yukon Gold
Column 8 - Qty
Column 9 - a formula to convert the store section into an hour (necessary to reset the item count in column 10 when section changes)
Column 10 - a formula to convert the item in the section into a minute (increments until section changes then starts back at 1)
I have my list sorted by due date. The due date is Today Section:Item. I know I could have put them as a prefix but I like the cleanness of this method.
Column 11 - a formula to build the smart add line. It concates Column 6, Column 7 and adds due date in the form of ^Today at section;item. The formula looks at the header in column 8 and if it is more than three characters, it assumes this is an ingredient list for a particular dish and adds the dish tag. ie _tortillasoup to the line..
When completed I select the drop down button on the autofiltered list in the Qty column and select non-blanks. I then select the items in column 10, copy and paste into an email to send to my RTM Grocery List
A completed line might look like this
Potatoes, Yukon Gold #_potatoeslyonaise ^Today at 01:01
Onions, Sweet #_potatoeslyonaise ^Today at 01:02
Butter, unsalted #_potatoeslyonaise ^Today at 15:01
Once in RTM, I can always go to my note for the dish in my dinner list and copy and paste the search string to pull up the shopping list then select and uncomplete.
For things I normally keep stocked in my pantry and fridge, I selected the items in my excel list and emailed to another list tagged with and called Pantry. Periodically I will inventory the pantry. When things get low, I change the priority to 3, then 2, then 1. I check this list at the grocery store to see if I need to replenish.
The Dinner List
Like erlang http://www.rememberthemilk.com/forums/tips/10570/ I also have a "dinner" list. I put all the dishes I have made before or would like to make. Each dish is tagged with #cuisine and #course but no due date.
Because I have hundreds of tags, all my food related tags are prefixed with an underscore _ so they are seperated from my work tags
Cuisine is prefixed with _+
_+italian
_+mexican
_+asian
Course is prefixed with _-
_-appetizer
_-side
_-main
_-dessert
Latter the dish is used to tag ingredients in my grocery list
_tortilla soup
_paella
_tuscan chicken
I use the url to add a link to any youtube clip related to preparation or if not available, to a webpage.
I add several notes,
1. Ingredients
2. Preparation
3. Pairings (wine, side dishes, etc)
4. Leftover Ideas (grilled chicken --> chicken Caesar salad --> buffalo chicken wraps --> chicken and pesto pizza --> fajitas)
5. Search tags to recall grocery list ie. tag:_paella AND status:completed
When I am ready to plan I search by cuisine and give the courses a due date I plan to make the dish. When done I remove the due date.
The Grocery List
I have the items I usually buy at my local store in an excel spreadsheet list. In excel I select the items I want to buy, filter the list and email the list to RTM.
My spreadsheet is set up like this.
Column 1 - Store section
Column 2 - Frequency (so I can filter list to hide infrequent items)
Column 3-5 - Sorting categories (Produce-Fruit-Citrus, Produce-Vegatable-Root)
Column 6 - The name I want to see in my list ie. Orange or Potato
Column 7 - descriptive info ie Navel or Yukon Gold
Column 8 - Qty
Column 9 - a formula to convert the store section into an hour (necessary to reset the item count in column 10 when section changes)
Column 10 - a formula to convert the item in the section into a minute (increments until section changes then starts back at 1)
I have my list sorted by due date. The due date is Today Section:Item. I know I could have put them as a prefix but I like the cleanness of this method.
Column 11 - a formula to build the smart add line. It concates Column 6, Column 7 and adds due date in the form of ^Today at section;item. The formula looks at the header in column 8 and if it is more than three characters, it assumes this is an ingredient list for a particular dish and adds the dish tag. ie _tortillasoup to the line..
When completed I select the drop down button on the autofiltered list in the Qty column and select non-blanks. I then select the items in column 10, copy and paste into an email to send to my RTM Grocery List
A completed line might look like this
Potatoes, Yukon Gold #_potatoeslyonaise ^Today at 01:01
Onions, Sweet #_potatoeslyonaise ^Today at 01:02
Butter, unsalted #_potatoeslyonaise ^Today at 15:01
Once in RTM, I can always go to my note for the dish in my dinner list and copy and paste the search string to pull up the shopping list then select and uncomplete.
For things I normally keep stocked in my pantry and fridge, I selected the items in my excel list and emailed to another list tagged with and called Pantry. Periodically I will inventory the pantry. When things get low, I change the priority to 3, then 2, then 1. I check this list at the grocery store to see if I need to replenish.

anna.santos says:
Great idea! I came here looking to see how other people are using RTM for grocery shopping.

jennwilgo says:
amazing! thanks so much for the tip!

emily (Remember The Milk) says:
Hi brumley, thanks for sharing! You're this week's Tips & Tricks Tuesday winner, and we've shared your tip on our blog. We've also upgraded your account with a free year of Remember The Milk Pro :)
Log in
to post a reply.