Page 1 of 1
Data Downloads
Posted: Thu Jul 23, 2026 4:44 pm
by spiral
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.
Re: Data Downloads
Posted: Thu Aug 06, 2026 4:08 pm
by spiral
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.