Condensing Data (1 Viewer)

Peter Quill

Member
Local time
Today, 05:24
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

  • January 2023 Solar.zip
    247.2 KB · Views: 63

Gasman

Enthusiastic Amateur
Local time
Today, 00:24
Joined
Sep 21, 2011
Messages
14,310
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

Top Bottom