« a night at the movies | Main | in bad odour »

the front 40

I recently "upgraded" to Office 2010 (for work). and as far as I can tell, its not much crazier than 2007 with the ribbon of whack but Outlook seems to be trying to take over my desktop.

But this is nothing really; I'm just looking for an excuse to transition into what I really want to talk about. Which is my TOTALLY AWESOME spreadsheet for all the plants I am growing from seed, indoors ( I did my spreadsheet in Excel 2010 - see! ).

Anyway, I've got about 31 jiffy pellets/pots of various sizes underneath my grow light, containing a variety of tomatoes, peppers, eggplants, beets, and kohlrabi. Because they are all in different sizes, I keep rearranging them, and pruning off the undesired sprouts, and generally micro-managing the heck out of them.

Which is why I needed a spreadsheet, because the constant redrawing of my seed pot vegetable configuration on post-it notes was getting old. And my spreadsheet is so cool! Using the data validation and conditional formatting options in excel, I've got it set up so that I can drop-down list populate any cell from a master inventory list, and once the cell is populated, it automatically color codes itself based on the type of vegetable it is!!!

I can create a color-coded representation of my plants in seconds, EVERY TIME I REARRANGE THEM!

who knew gardening was so fun?!


TrackBack URL for this entry:


This page contains a single entry from the blog posted on March 31, 2011 9:40 PM.

The previous post in this blog was a night at the movies.

The next post in this blog is in bad odour.

Many more can be found on the main index page or by looking through the archives.

Creative Commons License
This weblog is licensed under a Creative Commons License.
Powered by
Movable Type 5.2.6