The answer is yes! And the estimate is fascinating. [...says Jake as Katie snores...] If youve been following this blog for any amount of time, you probably know that a spreadsheet is about to appear. And so we begin, with three sets of columns: one each for supper, breakfast, and lunch.
 |
Into each set of columns, we enter recipes (copied and pasted from memory or the internet), specify the number of times per year were going to prepare them, and make sure units and ingredient names are consistent (e.g., that we dont say tomato in one recipe and tomatoes in another). |
 |
Then we use a pivot table (one each for supper, breakfast, and lunch) to count everything up. Its a bummer we dont know how to make a pivot table from more than one range at a time (theres probably a way), but thats ok. The workaround isnt too hard. From each individual pivot table, we create a master pivot table. From the master pivot table, we can estimate how much of everything we need to acquire during the course of the year. For example, we learn that we need about 54 dozen eggs, 49 gallons of milk, and 110 loaves of bread (assuming 12 slices per loaf). If youve been in our kitchen, you know that works out to a surprisingly accurate figure of roughly one dozen eggs, one gallon of milk, and two loaves of bread per week. And also 23 pounds of mushrooms, which sounds delicious. Model validated! |
 |
| More importantly (and to the point), we can estimate how many pounds of vegetables well have to grow and how many pounds of meat well have to catch to be self-sufficient. Clearly, if we want to keep taking carrots to work for lunch, well need to grow a ton. (Or, a one-fourteenth of a ton, rather). Similarly, we can see that we ought to devote a lot of our remaining garden space to tomatoes, potatoes, onions, garlic, and greens. Of course, were going to grow a larger variety of veggies than that, but the quantities we tend to eat (and would need to find storage space for) are instructive. And honestly, well probably try to grow more winter squash, green beans, and peppers than the chart suggests. |
 |
| On a similar note, if we want to keep on our current diet, well need to grow another batch of chickens and catch one large deer and a quarter of a pig. (Or raise one deer and catch a flock of wild chickens. But we dont have space to raise both!) |
 |
| All things considered, its a pretty balanced diet, not too far from Harvards Healthy Eating Plate. Were a little heavier on the veggies, but hey! Maybe well end up being a very localized blue zone. |
Its important to keep in mind that these numbers are just guidelines; were not locking ourselves into a whole year of rigidly following recipes. We substitute veggies and meats in and out of a recipe like a Wall Street bankster swaps stocks (although we hope none of our meals would be considered subprime or toxic assets). But its nice to have a set of go-to dishes we can pick from and toss together from stuff in the fridge or pantry if weve already spent our creative energy for the day and still need to make supper. Whatchagotamology at its finest!
We wont vouch for the user friendliness of the spreadsheet, but if you want to play around with it, you can download it here. Suggestions welcome!
Do you make meal plans? Whats your planning strategy? Let us know in the comments section below!
