Based on the number of people who didn't think I was crazy and wanted their very own copy of the Access file lauded in the previous post, I have made the file available for download here, along with a video tutorial of how to use it.
Okay, so there are 2 versions.
First, the Simple Grocery List Maker.
This is an Excel file that will create grocery lists for you. You enter in meals/ingredients, select which you want to make, and the file creates a grocery list ready to print and take to the store.
Download the file here: https://sites.google.com/site/erinsandbox/documents/GroceryListMaker.xls?attredirects=0&d=1
Watch the video tutorial (recommended):
(Link to YouTube video)
Second, the Ultimate Meal Planner.
This is an Access database that will create printable recipe cards and a grocery list. If you're really serious about this, choose this option because once you're already entering in meals and ingredients, you may as well get a formatted recipe card out of it. In this database, you fill out recipe forms to create your cards (ready to print on 4x6 cards). Use the grocery form to select meals and generate a list ready to print and take to the store.
Download the file here
https://sites.google.com/site/erinsandbox/documents/Recipes.accdb?attredirects=0&d=1
Watch the video tutorials (strongly, highly, very recommended):
(Link to YouTube video)
(Link to YouTube video)
Showing posts with label Access. Show all posts
Showing posts with label Access. Show all posts
Thursday, November 4, 2010
Monday, November 1, 2010
what do you get when you cross a stay-at-home mom with a spreadsheet freak?
Me!
With the end result of an Access database that generates 4x6 recipe cards and my weekly grocery lists with just a few clicks.
The inefficiencies of my meal planning system have been gnawing at me for a while now. Searching for recipes stuffed into recipe boxes, saved on my delicious.com account, scribbled on a napkin at the bottom of my purse. Or, spending 20 minutes writing my grocery list and getting home to discover I've forgotten the noodles for spaghetti. Or, eating the same foods week after week because it's too hard to look in various places mentioned above for recipes I haven't made in a while.
Over the last 2 weeks I have streamlined a solution. In my Access database, I can fill out a form to enter in a new recipe. The recipe automatically uploads into a report that prints onto a 4x6 card so I can add it to my "recipe ring". The recipe ring frees cards from the constraints of a box. Instead cards are clipped together with 2 rings that allows for faster flip-through. Plus the card won't ever leave the box and mysteriously disappear - the whole bunch stays together on the ring.
That's pretty handy. But the best part is that all of those recipes feed into a grocery list creator. Okay, it's really just a pivot table. The coolest pivot table ever.* It gives me a drop-down list of my recipes. I select which meals I want to make that week and it gives me a list of ingredients I need to buy. And quantities - summed across recipes. And it sorts it by store section (produce, bakery, meat, etc). One Ctrl+P later and I've got a complete, sorted grocery list to take with me to the store.
The only flaw in the system (which I've encountered twice now) is when I leave the grocery list sitting on the kitchen table. Operator error.
I know this all sounds a little crazy. But meal planning has always been a thing with me. Have I ever written about the time I was gearing up for a very busy school semester, so I planned out 16 weeks of dinners? I printed out 16 pages of grocery lists, one for each week, that had the week's dinners and necessary ingredients. I set the stack on my nightstand and didn't think about what to make for dinner for the next 4 months. Talk about efficient.
At this point, you may be feeling one of two ways. 1) Wow! Maybe Erin will send me a copy of her Access database so I can use it too (I'd be happy to). 2) Wow! This is the scariest Halloween post I've ever read.
*Credit for the pivot table goes to my friend Melissa, who first came up with this concept using the pivot tables in Excel.
With the end result of an Access database that generates 4x6 recipe cards and my weekly grocery lists with just a few clicks.
The inefficiencies of my meal planning system have been gnawing at me for a while now. Searching for recipes stuffed into recipe boxes, saved on my delicious.com account, scribbled on a napkin at the bottom of my purse. Or, spending 20 minutes writing my grocery list and getting home to discover I've forgotten the noodles for spaghetti. Or, eating the same foods week after week because it's too hard to look in various places mentioned above for recipes I haven't made in a while.
Over the last 2 weeks I have streamlined a solution. In my Access database, I can fill out a form to enter in a new recipe. The recipe automatically uploads into a report that prints onto a 4x6 card so I can add it to my "recipe ring". The recipe ring frees cards from the constraints of a box. Instead cards are clipped together with 2 rings that allows for faster flip-through. Plus the card won't ever leave the box and mysteriously disappear - the whole bunch stays together on the ring.
That's pretty handy. But the best part is that all of those recipes feed into a grocery list creator. Okay, it's really just a pivot table. The coolest pivot table ever.* It gives me a drop-down list of my recipes. I select which meals I want to make that week and it gives me a list of ingredients I need to buy. And quantities - summed across recipes. And it sorts it by store section (produce, bakery, meat, etc). One Ctrl+P later and I've got a complete, sorted grocery list to take with me to the store.
The only flaw in the system (which I've encountered twice now) is when I leave the grocery list sitting on the kitchen table. Operator error.
I know this all sounds a little crazy. But meal planning has always been a thing with me. Have I ever written about the time I was gearing up for a very busy school semester, so I planned out 16 weeks of dinners? I printed out 16 pages of grocery lists, one for each week, that had the week's dinners and necessary ingredients. I set the stack on my nightstand and didn't think about what to make for dinner for the next 4 months. Talk about efficient.
At this point, you may be feeling one of two ways. 1) Wow! Maybe Erin will send me a copy of her Access database so I can use it too (I'd be happy to). 2) Wow! This is the scariest Halloween post I've ever read.
*Credit for the pivot table goes to my friend Melissa, who first came up with this concept using the pivot tables in Excel.
Subscribe to:
Posts (Atom)
Posts
