Redundant in Google Sheets with the year name and a database MySQL. Each table name in the database gets the year as prefix for differentiation. For example the readings for July 2020 are found in the "2020" Google workbook on sheet "07". In the database it is in table "2020-07".
Sheets and tables per month
There is another sheet "hourly" and table "2020-hourly":
And finally there is a daily sheet and a table 2020-daily:
We started with the measurement of the voltages of both solar panel and battery at 10:00 AM on May 21st, 2020. We soon realized that the MPPT from the hybrid controller only applies to the wind generator part and that we drain the battery completely with our 60W light bulb that was intended to shine 4 hours after sunset.
Recap: The MPPT does not apply for the solar panel, it is directly connected to the battery and looses therefore a lot of energy. Secondly: The floating limit for our battery was set too low at 13.8 Volt, so it was never really charged since installation on May 15th. New limit is 14.7 Volt floating and overvoltage limit 14.8 Volt. Third - the lower voltage limit was set too low at 10.8 Volt, it is adjusted now at 11.0 Volt. The load was reduced from 120 W to 60 W. Let’s see if the weekend brings an improvement.
Rainy Saturday, battery charged very little, drained after 1.5 hours.
Switch from a 60 Watt load to a 5 Watt load for 4 hours after sunset.
Battery fully charged, controller disconnects solar panel during the day. Load now on for 7 hours after sunset.
Battery drained again with 60 Watt load from 11:00 AM to 5:00 PM. Then installed new MPPT solar charger.
With MPPT higher solar voltage for charging - for increased efficiency. Compare May 28th to May 25th.
Graduation for Seniors 2020 started 3:00 PM after the thunderstorm 1:00 PM - solar panel went off.
On the last day of school, June 5th, the setup was finished to measure the current of the solar panel as well. And during Monday, June 8th, we tested the circuit to measure the AC voltage of the wind generator. It was soldered on Tuesday, June 9th, and installed. Now we have a comprehensive picture of solar and wind energy available in Nha Be:
2020/05/18
Here is the graph for the voltage output of 6V 2W solar panel on 39 Ohm resistor:
2020/05/19
With a load of 3 kOhm we get almost the free floating voltage of the solar cell. At 7 Volt the test circuit only consumes 2.3 mA or 16 mW - while having a maximum power of 2000 mW - this is 0.8% of what it should be able to deliver. Thats the output over the day:
2020/05/25
I combined several measurements from May 18th to May 24th with different loads on the 6 Volt 2 Watt solar panel that was placed in Phu My Hung to an overview from 5:00 AM tp 7:00 PM: