Is there a way to get a monthly download with the data presented similarly to the daily download i.e. with readings at 5 min intervals? The monthly download just summarises the daily totals and I'd rather not have to copy and paste all of the daily figures into one document.
Solar Panels: Aiko Neostar 3S 475W All Black ABC N-Type Mono × 18
Inverter: Fox ESS KH 7kW 1ph Hybrid Inverter
Battery: Fox ESS EP6 Plus 5.76kWh Li-ion Battery w/ heating function
Inverter: Fox ESS KH 7kW 1ph Hybrid Inverter
Battery: Fox ESS EP6 Plus 5.76kWh Li-ion Battery w/ heating function
Although not exactly what I was after I found away to do this (of sorts) using an excel power query.
Basically download each day into a set folder.
In Excel, I'm using office 2019 so other versions may be different, go to the data ribbon.
Select get data - from file - from folder and select the desired folder.
A window will appear.
At the bottom select combine and load.
In the next window select OK.
Voila, you have a table with all of the days combined.
If you save this spreadsheet and continue to download into the previous folder, when opening the spreadsheet, a refresh of the table using a right click, pulls in the new data.
You can also add your own formulas adjacent to the table and they get extended when new data is imported.
Basically download each day into a set folder.
In Excel, I'm using office 2019 so other versions may be different, go to the data ribbon.
Select get data - from file - from folder and select the desired folder.
A window will appear.
At the bottom select combine and load.
In the next window select OK.
Voila, you have a table with all of the days combined.
If you save this spreadsheet and continue to download into the previous folder, when opening the spreadsheet, a refresh of the table using a right click, pulls in the new data.
You can also add your own formulas adjacent to the table and they get extended when new data is imported.
Solar Panels: Aiko Neostar 3S 475W All Black ABC N-Type Mono × 18
Inverter: Fox ESS KH 7kW 1ph Hybrid Inverter
Battery: Fox ESS EP6 Plus 5.76kWh Li-ion Battery w/ heating function
Inverter: Fox ESS KH 7kW 1ph Hybrid Inverter
Battery: Fox ESS EP6 Plus 5.76kWh Li-ion Battery w/ heating function