Garden Planner Spreadsheet

I've been putting this spreadsheet together for several years now, and it's finally in a fairly useful stage. Since I haven't been convinced by anyone to make it into a 'real' application, it's currently in a Microsoft Excel spreadsheet, with heavy use of multi-worksheet formulas, form controls, and a couple macros.

The final output (at right) is a form with drop-down crop variety selections, room for cultivars, order info, source, and it automatically populates a weekly calendar with tasks for the garden. The succession planting column allows for scheduling multiple iterations of the crop without confusing the scheduler. Everything is based off the Last Frost date as entered in the spreadsheet, so the scheduler is portable to other zones.

Future improvements I'm still working on are a automatic bed plan, and some different output options for the schedule. The bed plan will order crops by family (Legumes, Brassicas, Roots, Curcurbits & Grains, Solanaceae, and Alliaceae); and keeps historical records from the last several years of crops to facilitate rotation for pest control and maintain soil nutrients. Schedule output options I'd like to add are a printable schedule based on popular binder-style planners, and outputs to Microsoft Outlook and/or Google Calendar appointment systems.

I've created a small version that I could email, if you want to try it out for yourself.

--Mickey