We have four sources of data we combine to get our various solar power usage charts. We have data from the production of the solar panels on the house (PV1&2) and separate data from the new solar panels on the garage roof (PV3). We have data from a Wattson meter on how much power we consume in the house, and data from the Zappi on how much we use to charge the car (either overnight off the grid, or during the day from excess solar). Combining these is tricky, because they all have different granularities (from every 30s to every hour).
The combination is even trickier when the clocks change. None of the data sources tell us whether the timestamps are in GMT, BST, or something else, but we have guessed, probably correctly. When the clocks went back last week, the Wattson and PV3 systems simply repeated the times for the relevant hour, with the different data. But the PV1&2 and Zappi systems overwrote the first hour of data. Aaargh.
Thankfully for my sanity at least, it's my other half who combines the data. I use the combined data to plot the charts. So he was tearing his hair out, rather than me doing so. He has now completed the task.
But still. Honestly, it's not as if daylight savings is a new thing! It reminds me of the very first item on the list of Falsehoods programmers believe about time. At least it gives me an excuse to re-read the list, anyway.)
No comments:
Post a Comment