In my last post, I described how I use a spreadsheet to keep track of my plant information. You can see how to set up the details for a garden record keeping spreadsheet here. I attached a sample spreadsheet to show how useful it can be for sorting plants by different categories. I’ve included a screencast here to show how it can rearrange information about your plants.
Here is a flash demo sorting the northern shade spreadsheet by height. It starts automatically and the cursor shows the steps being completed. Just click the green arrow in the bottom left to see it again. This just shows the upper left corner of the spreadsheet, but I hope it gives a better picture.
This is shown using Microsoft Excel 2007, but I use an open source program called OpenOffice.org calc to create my spreadsheets. It is very similar.
Although I find it very helpful to organize my plant data and keep records for planning, I realize that sometimes beauty is intangible and hard to quantify.