And That’s Fun For You?

Most of my database creations begin with a single thought, “I wonder…”  For instance, I wonder how many movies I’ve watched in my lifetime.  Yep, I keep track of that, have been for 13 years.  I started it on Excel with just movie titles and my rating of those movies and their genres and ratings.  When I learned Microsoft Access I transferred my table.  I’ve added actors and actresses I care to list, directors, it’s release date, whether or not I own it, and whether my husband has seen it.  (This last one is very useful.  I can see what my highest rated movies are that he hasn’t seen and then have a special viewing with him.)  joseph hasn't seen

Is this a waste of time?  Maybe, but it’s a hobby so I don’t have to defend its practicality.  I can pull up my database by genre and tell you my favorite comedy or drama or whatever.  I even started tracking which movies I saw in the theater, 294 now.  People who know ask me, “What did you rate…” or “How many are you up to now?”  Currently 1564 movies.  movies in the theater

It’s not my largest database though.  Not anymore  My husband began the “I wonder…” statement this time:  “I wonder how many times we’ve had this meal recently.”  He also told me he thought it would be cool to see what things we’ve made and loved, but forgot to make again.   If only there was a way to search your past meals…

Yep, I’ve got a database for that now.

meal database master query

Because MyFitnessPal keeps your food diary history forever, if I’ve logged it I can look it up and I’ve been a very faithful food logger.  The problem is that it’s logging individual foods, so a Pear Cranberry Salad looks like this…


I needed to translate the food items into meals.  It took nearly a week of free time, but I have now logged all of my food history (Breakfast, Lunch, and Dinner, a few snacks and desserts) since April 26, 2012.  That’s 3,666 data entries.

I’m still searching for what all I will do with this information.

I use it to see just how many times we’re eating out for meals.  When you look at a whole year at a time it’s alarming.  We went out to eat for lunches and suppers 99 times in 2014, that’s 14% of our meals.  That’s not counting our weekly Saturday morning doughnuts.  I just looked it up… we’re actually doing okay comparatively.  We’re eating out about half as much as the average American.  Phew!

I keep track of whether those meals were eaten while we were on the road traveling.  I also designate any meals we ate with friends, family, or at church, and whether our meals were vegetarian or leftovers.  Here’s my meals that are leftovers and how many times we’ve eaten them as leftovers in the last three years.  (With a database, whatever I categorize I can sort or filter by.)meals database

I thought getting to look at my meals would feel like a pat on the back, thinking I’m so diverse with my cooking, but the truth is that I see a lot of repeats.  My pride was a little wounded after seeing on the screen that I mostly cook the same handful of things again and again.  I’m sure a lot of people do.  Granted, my list will be different than yours.  My most repeatedly cooked meals (not counting when we ate leftovers) in the last 3 years are…

3. Hummus and vegetables (fixed 29 times)

2. Northern Style Curry over rice (also fixed 29 times)

1. Thai Basil Turkey over rice (fixed 35 times)

While I want to get down on myself about cooking these things so many times, I still find them delicious and am very glad that they have pretty good nutrition in them (if you don’t count the sodium from an abundance of fish sauce.)  I think next I’ll add a rating system onto my meals.  If the meals we’re eating the most often are not 8’s or more, then something is off.  What my database is telling me is that, yes, I fix the same things repeatedly, but we’re enjoying what I fix so why should I care?

Our goal with this database was also met.  We have found a few forgotten treasures in the backlogs that we need to make more of like warm Asian cabbage and chicken slaw and Peeking pancakes.  Yum!

It also has some meals we made once and were ultimate failures and were never made again, another success really.  It’s like the graveyard of recipes.  Why do I try cooking lentils?  I really don’t like them, but every so often I try them again.

What about you?  Have you kept track of your meal planning?  What would you do with this kind of information?


2 thoughts on “And That’s Fun For You?

  1. I have attempted to list all the meal options for us before–but abandoned it. It was a pen and paper only endeavor–I’m not great with Access–and since I’m kind of thrifty/a cheapskate, we are doing more and more via Google Docs and don’t even have Office Suite anymore. I read about a woman keeping track of her meals for years–she blogs at Dinner: A Love Story. (I might have mentioned it before.)

    I do keep track of some things—books I read (on a secret pinterest board), answered prayers ( in a notebook by the bedside) and instead of traditional baby books I write witty sayings, milestones, fun excursions, etc on a wall calendar for each of the kiddos and then file it away when the year’s over and buy a new one at Target’s dollar spot.

    I like your comment about a hobby not having to be justifiable; I need to remember that.

    Liked by 1 person

    1. Ooo I really like the calendar idea. I keep a journal for each of them, but I forget the milestones a lot. I wish your book Pinterest board wasn’t secret. I love seeing what people actually read like on Goodreads.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s