Condensing Data

Peter Quill

Member
Local time
Today, 21:07
Joined
Apr 13, 2023
Messages
30
Hello Everyone,

I'm having trouble overlaying data from both solar and usage data for electricity. The problem is that the solar data is measured in 15-minute intervals and the usage data is done by the hour. I have tried to organize the data according to that, but the problem is that the usage data shows up as 1/4th the size of the solar data, and fills the missing data with zeros. I have attached the workbook. Please help!
 

Attachments

Get the data correct first.
You have some Usage entries that have 5 intervals to an hour, others 3? :(
 

Users who are viewing this thread

Back
Top Bottom