All the food blogs I read agree: meal planning is the way to go if you want to avoid food waste, daily shopping trips, lack of inspiration and general cooking malaise.
For the last few weeks I've been kicking around an idea for a meal planner that takes a list of possible meals, along with a points value based on healthiness, ease of cooking and opinion (so for example something that is complicated, unhealthy and not really popular would get three points, whilst something that is quick, healthy and delicious would get one) and then generates a weekly meal plan with a maximum of fifty points per week, ten per day.
That was the plan. When I sat down at my computer to create the spreadsheet I had envisaged, I hit a problem. I had absolutely no idea how to do it.