Back in the beginning of the season, I decided to attempt to measure bloom saturation in my garden for the season. Every 7-14 days or so, I would walk around everywhere and record my observations. I wasn't sure (and still am not sure) what the final visual would be to represent my findings. But I thought I would at least gather the raw data and work on doing something more with it over the winter.
Well, its winter tomorrow. I just finished the data entry of the raw data. Now I am scratching my head to figure out how to represent it visually in some sort of graph or chart. Of course, I don't know Excel graphs or charts, which doesn't help!!!
This is pretty tiny, but it gives an idea of what I am starting with. I have formulas in all the tally columns. I got the idea of the 5 levels of bloom from the Landscape Message report. It wasn't enough to measure on a scale from 1 to 5. I wanted to preserve the bloom cycle from starting to peak to done. I also have each specific garden location noted, but not sure I want to take it to that level.
So any clever people and/or Excel wiz's out there to point me in the right direction?
I uploaded the actual spreadsheet to Google Docs so you could see the whole thing. Of course, Google spreadsheets won't have the full power of Excel, but you can take a look at the data. It seems to have converted very well.
And here is a mini snapshot excerpt: