FactBox

Showing posts with label Graphs solar sunrise sunset. Show all posts
Showing posts with label Graphs solar sunrise sunset. Show all posts

Monday, 19 December 2011

Playing

OK. So since I have a few day's off work for Christmas I've had some time to play with the Google docs links. I have a few more things working, have imported my original tracking spreadsheet and so will crack on with the graph conversion. This should allow a more automated update process in the future, however there are one or two teething problems to be resolved. 

One addition to the blog are the key sunrise/sunset stats etc at the top. This is linked in to a today() spreadsheet function along with a vlookup() which should automatically populate the table above for 5 days, centred on today. Well that's the theory, I shall see if it works automatically over the next few days. If not then I will remove the gadget and publish the full table elsewhere. 

Earlier I lost all my charts on the right and so have rebuilt the links. Hopefully this wont be a regular occurrence, time will tell. 

In the mean time, it's been a dull, damp day with drizzle after a promising sunrise. I don't have the figures yet, but I suspect I've generated less than a kWh today. But that's in line with the weather forecast, so I suppose I shouldn't complain. Any units at this time of year are welcome - it all helps.