Hi,
I have 4 years of data from my solar monitoring software (by SolarAnalytics).
Data includes 30min increments for usage, solar generation and feed bacl to the grid, and even down to the 12 channels for greater detail.
Im seeking help in finding the best way to query this data using Excel or Google sheets.
Query's would allow me to report how much electricity was recorded during each window period ie 11am-2pm or 10am-3pm etc. As well as allowing to define the date window.
I can post a sample spreadsheet of the data shortly.
Thanks in advance.
I have 4 years of data from my solar monitoring software (by SolarAnalytics).
Data includes 30min increments for usage, solar generation and feed bacl to the grid, and even down to the 12 channels for greater detail.
Im seeking help in finding the best way to query this data using Excel or Google sheets.
Query's would allow me to report how much electricity was recorded during each window period ie 11am-2pm or 10am-3pm etc. As well as allowing to define the date window.
I can post a sample spreadsheet of the data shortly.
Thanks in advance.