planting calendar on an excel sheet?

lucia_ca(z9 CA)March 30, 2008

Hi everyone,

I've had a raised bed vegetable garden for a couple of years now and would like to take the next step and turn it into a year-round producer....which I believe is possible given that I'm in CA USDA zone 9 and Sunset zone 14-15.

I'm confused about what to do and when, so I really need to rely on a calendar to remind me. I've begun an excel spreadsheet...listing vegetables/fruit down the page and all the stats across the page....when to plant, what the spacing is, etc. etc.

I can create a spreadsheet with a column containing a formula that calculates the average planting dates of all the items based on the average date of first/last frost. For example, if you are supposed to plant "x" 2 weeks after the average date of last frost, and your local average date of last frost is 3/1 then the calculation would tell you to plant "x" around 3/16. It seems though, that someone else has already probably gone through this tedious exercise.

Has anyone done this already so that I don't waste time in reinventing this wheel? If so, can you share a template? If not, have any tips, suggestions, ideas on how to do it best?


---Lucia in CoCo County, CA

Thank you for reporting this comment. Undo
grandad_2003(9A/sunset 28)

Lucia, I have a spreadsheet which I use for laying out vegetagles (i.e. a vegetable planting plan), for keeping notes on what worked well & what did not work well, for spacings between plants, notes on seeding planting dates etc. For knowing WHEN it is time to plant I've just referred to the state planting guide published by the Cooperative Extension Service. Actually, I used to do this moreso in the past because I now have the dates committed to memory. Having a notification algorithm in my spreadsheet would seemingly be more sophistication than what I would need. (If I did feel the need to have a reminder, I'd simply take the start planting dates out of my state planning guide and add these as reminders in the calendar program on my PC.)

    Bookmark   April 1, 2008 at 3:09PM
Thank you for reporting this comment. Undo

I think such a spreadsheet is available at

I've considered using one, but a more primitive system works fine for me -- writing things down on a wall calendar. It stays right out in the main room where I'm less likely to forget it. When I'm planning the garden, I go through with a colorful pen and write my target dates for doing things, and later make notes of what I planted when. At the end of the season, I can stash it in my seed box.

Here is a link that might be useful: my website

    Bookmark   April 5, 2008 at 6:59AM
Thank you for reporting this comment. Undo
angela12345(7b NC Mixed-Humid)

Link to spreadsheet ...

    Bookmark   June 19, 2009 at 6:00PM
Sign Up to comment
More Discussions
Im having tons of issues container gardening here..
OMG..I am soo frustrated. I've only been gardening...
Protecting your garden
I have a question to ask of you gardeners, especially...
Coldframe/hoophouse question/confusion
Hi All. I'm hoping some of you that have grown in cold...
To Build or To Buy, that is the question
I am looking into beginning a year round garden on...
First Winter Garden/Groundhogs
I am planting my first winter garden this year and...
© 2015 Houzz Inc. Houzz® The new way to design your home™