I’ve recently been doing a lot with Excel, which is not something I’ve previously worked with much. So, in order to familiarize myself with it, I decided to take on a personal project. Lately I’ve been trying to organize my home life, and I decided to apply Excel to creating something to help me. I decided to try to make the perfect meal planner.
I started by finding templates that appealed to me, and I settled on a free download from Microsoft. At some point the macros had been removed from the workbook, so it was really only a shell with extremely limited functionality. This was great for my purposes, so I decided to expand on it. I added more tabs and functions and kept it all live so I didn’t have to use macros to activate anything.
This is the result: this Weekly Meal Planner. I put so much work into it that I feel like it’s wasted if I don’t share it with other people who might find it useful. Feel free to change it any way you want, but be aware that the background calculations aren’t all labeled – I was only doing this for personal use. I added an instructions page to explain some of the logic behind its use, but modifying it will still probably be a pain. There are a few areas that I find a bit clunky and could probably be improved, but overall I’m pretty happy with it.
If you decide to use it and you find something that doesn’t work the way it should, just let me know and I’ll do what I can to fix it.