Insane crop planning spreadsheet

Ok, you can blame Patti and Derrick – they asked for it! And I had to do something to keep up with Rob’s amazing garden bed rotation spreadsheet. So, here’s Emily’s Totally Insane Spreadsheet for Planning What to Plant to Live Out Of Your Garden. Also known as “can I feed my family on one acre?” (Answer: Yes. But you might not want to.) And yes, I realize I have waaaaaaay too much time on my hands.

It’s in GoogleDocs spreadsheet format. Click the little orange triangles for comments. Be sure to look at both sheets (tabs along the bottom) and scroll down – calorie crops are at the top and vegetables at the bottom. You should be able to click the GoogleDocs File menu and export it to your own GoogleDocs account, or to Excel or .csv format. Then you’ll be able to play with the numbers, add foods, etc. If you’re as big a geek as I am, this is the fun part.

The basic idea is it takes just short of a million calories to feed a person 2500 calories per day for a year. I’ve looked up the number of calories per pound of food, and the number of pounds of food that can grow in a square foot (using John Jeavons’s Biointensive raised-bed methods). Put in the number of people you’ll be feeding, and the spreadsheet keeps a running tally of how many calories you’ve planted and how many more you’ll need to grow to feed everyone for a year. As you’re planning, be realistic about what you like to eat, what you can store, what’s a pain in the butt to raise or process, and get a good variety so you don’t get scurvy or really, really sick of parsnips.

Even if you don’t intend to live off your 1/4 acre lot, this is eye opening. Think your 1000 sf tomato garden is great shakes? Calorie-wise, that’ll feed one person for two months. I’m growing wheat on a very, very small scale right now, and had been thinking of expanding. But looking at the scale needed, and the work involved in harvesting wheat by hand, makes me think what communities need is a central wheat farm with big machines and individual gardens full of potatoes and rutabagas (swedes).

Have fun kids!

Published by Emily

I'm an instructional designer and gardener based in Ann Arbor, Michigan. Free moments find me in my garden or the forest, hugging trees and all that jazz.

5 thoughts on “Insane crop planning spreadsheet

  1. I am so glad that I found your blog. I have been reading it off and on all afternoon. We started gardening in my side yard (the only portion that is fenced) and already neighbors have commented about my large pepper plants growing in the circle “flower” garden around the base of my newly planted tree. I am growing cucumbers up a trellis on my side porch and zuchinni right next to it in a planter box.

  2. all I can think about after reading that is who will help me plant the wheat asked the little red hen. Who will help me cut the wheat asked the little red hen…

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

%d bloggers like this: