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.
No comments:
Post a Comment