- The most important thing here was to make a list of entrees that we actually cook at our house. That alone is a great resource for planning new menus.
- "Aaron likes lists, and solving a problem with a new list makes him happy" isn't really anything new. But this is the first time I've tried to make a relatively comprehensive list of meals.
- We're trying to plan our weeks more tightly. It's ok if we change the plan mid-week. But I'm finding it more useful than ever to have a plan for the whole week.
- This is of some use in avoiding letting food we buy go bad before we cook it, but only if I stay on top of that issue.
I'm only talking about dinners here. I tried to find the lowest-tech way I could do this fast, and also something that would keep whatever data I generated in a common format. So, here's what I did:
- Made a list of meal options in one column of an Excel spreadsheet
- Inserted random numbers in the next column, using "=RAND()" in each cell.
- SORT the list using the column of random numbers as the sort key.
The sort trick isn't my idea, I got it from searching on ideas for how to randomly sort rows in Excel.
That's it. I made it slightly fancier by writing a macro to do the sort and tying that to a key combo, but really I didn't do that until I had it for a while.
Each week I sort the list and then take the top 10 or so options and pick the actual ones I feel like making, freely throwing out stuff we ate recently or that sounds too involved for this week.
At first I thought I would be generating a list of 5 or 10 items,but sorting the WHOLE list and then just taking the top few items works fine. If I hate most of the top choices, I can just go deeper in the list.