Crop Planning Files Available



For years I’ve been meaning to figure out a way to make my crop planning files available on line. Actually, one of the things that has been delaying me is that I didn’t really want to put them up without some instructions on how to use them. The files themselves are probably interesting to some, but the process of creating them, editing them, and using them effectively isn’t completely self evident just looking at the files themselves so I’ve been wanting to write up some tips to go along with them.

Last week I was at the Future Harvest -Chesapeake Alliance for Sustainable Agriculture annual conference and one of the workshops I presented was the basics of how to use this planning system. I offered to email folks these sample files  but I decided, after years of emailing individuals copies that it would be good if I just put them up in a public place for people to access.

There are four files I’m making available. The first is a PDF version of the slides from my presentation. These give a very rough outline of the process.  There is also a sample harvest plan, sample “master” which is basically the full planting plan, and sample maps. All three of these files are .xls files and have tons of bad data in them, don’t trust the data. They are simply a sample of the kinds of sheets that I produce for different projects and they contain examples of the kinds of formulas that I use in the planning process, examples of how I format different cells and one way to layout the information needed in a season for planting out a diverse bunch of vegetables.

Feel free to download these files and let me know if you have questions. My intention is still to put up more information on this site on how to use them, and also examples of other sheets, maybe even some with good data in them. I’m currently using Apple’s Numbers more than Excel, and to be honest the sample sheets were created in NeoOffice, or maybe OpenOffice, I can’t remember which. Numbers makes things look nice and simplifies some of the sorting, but it’s less flexible and powerful than Excel, or the open source options.

Lots of folks have asked me if I sell these spread sheets and the short answer is that I don’t. I would love to have folks who find these useful donate to the site and let me know what works for them and what doesn’t, what they’d like more information on. I’d also like to hear if folks make improvements they think are significant. If you’d like to have a training on how to use the sheets that’s what I sell. I can do trainings for individual farms, or for groups and typically the basics take about 3 hours to go through in a group.

Keep an eye on this site for more information on the sheets. The next conference I’ll be talking about the sheets at is MOSES’s Organic U (linked to below).

MOSES Organic Farming Conference


MOSES Organic Farming Conference

Usually I reserve this blog for updates about the site, but today I wanted to point out an update to the site. I just updated the workshops page for the site with workshops from January into March in Pennsylvania, Virginia, Wisconsin, and Oregon. The MOSES folks in Wisconsin asked me to put up the “badge” above. If you click on it it’ll take you to their site. I love having the opportunity to travel around the country, and even internationally, and having the opportunity to talk to farmers who are doing amazing things. I feel really lucky to be able to be a connector in that way, bringing back ideas to the Northwest, but also spreading ideas as I travel.

On that same workshops page you can also see a list of most of the workshops I’ve done for the past four years. There are already a few more in discussion for 2013 so keep an eye on the page, and this blog, if you’re interested.

Hello world!

Pretty soon I’ll be up and running here.  First up will be revisiting the old posts from the original website which has now changed.  There was some good material there and I’ll make sure to bring it back and update where necessary.