I created a Google Sheet to track some of the most important elements of our PV systems. Feel free to download if you wish.
I upgraded and automated my tracking in 2026. I track the amount of electricity we’ve used each day (the Load), the amount our PV system has produced both in total and at the individual “string” level, and how many kilowatt hours we’ve put into and taken out of our batteries. The sheet also calculates the difference between those values (“Net Loads”, “Net Energy” and “Net Battery”). Energy used by the Mitsubishi Ecodan air-water heat pump and to recharge our EV are also tracked separately as they are the biggest energy users (the Ecodan only in heating season, of course).
I also wanted to keep track of any days when we had to run the generator. If that happens, I just put an “X” in the appropriate cell for that day. And finally, I record the lowest state of charge for the batteries for that day. Home Assistant appends these values to Google Sheets just before midnight each day, and then the data resets.
The house (the “barnpartment”) and the studio each have their own tab in the 2026 spreadsheet.
If you decide to download and use a copy, I hope you find it useful.
A word on using them: These sheets and the data in them are shared as-is, for your own use at your own risk. They reflect my systems, my equipment, and my occasional mistakes; I make no promises that they’re accurate, complete, or right for your situation. If you download, copy, or rely on them, you agree that you’re responsible for how you use them and that I’m not liable for any errors, problems, or decisions that come from doing so.