Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
Solar Client1.xlsm | 2013-09-14 | 72.0 kB | |
readme.txt | 2013-09-12 | 531 Bytes | |
Totals: 2 Items | 72.5 kB | 0 |
Excel based solar client ------------------------ This excel sheet connects to the solar server file every minute and pulls the current data and plots it in the following charts: - Daily Chart: displays day energy data, hour by hour (in KWh) and also current generation on the left (in Watts) - Weekly monthly, yearly charts: sums data and displays accumulated KWh and generated savings. Technical details - Must enable macros. - The sheet "Solar data" range in A1 needs to point to the server DB file.