After reading an article in Pip Issue 6 (Australian Permaculture magazine) about how to plan planting of food so that there is an on-going harvest instead of periodic gluts and then scarcity, I got inspired.
Evita and I are both poor at keeping a notebook/diary of what is planted, where, and when. And we’ve had the feast and famine cycle happen a few times too. I decided to create a spreadsheet of the table featured in the article.
It is a Google Document Spreadsheet that we can both edit, even at the same time! In the spirit of People Care and Fair Shares, I have made the spreadsheet available for everyone to use. Click HERE to open it.
(N.B. you will need a Google Account logged in). Please don't Request Access. To use the spreadsheet yourself, click on File, Make a copy… this will make a copy for you to use in your Google Docs. If you don’t use Google Docs, you can save it as an Excel file from here: Successional planting – PLAN.xls - click on the Download icon in top right corner. Once downloaded, open it in Excel.
How to use the spreadsheet
The video above will guide you through using the planner, but below is also some advice.
Most cells have a dropdown list, click the little arrow in the cell to access it – this makes it quicker and prevents typos (if there are any, let me know by commenting on the original). Also, let me know if there are vegetables to add to the main dropdown list. So, choose a vegetable you intend or have already sowed, choose variety if you know it, then follow the Key on the right hand side to show how and when it is sowed, when the Harvest is expected and so on. Here is a little example:
To delete a cell’s contents, select the cell and press the Delete key on your keyboard, then click away on another cell.
If the vegetable is not in the list, you can just type it in OR to change the whole list:
Click Data, then Validation, then add it to the list. This rule has to be copied to all other subsequent cells. Assuming this is all the cells below where you are, then click the tiny little square at the bottom right of the selected cell and drag it down the cells below.
If you want to change the colours used, then follow the tip above except you click on Format and then Conditional formatting, make your changes and then copy across and down so all cells get the formatting rules.
For a video guide to using in Excel, watch here: www.youtube.com/watch?v=khv6HTJGzpk
Charles Dowding & Steph Hafferty's No Dig Organic Home and Garden