Electricity usage

[GLOpro]

Hi,

I have a data file CSV from my energy provider.

The data is in 30min increments and reports on 3 meters (General, Solar and Controlled Load)

How can I represent that in Excel graphically?

Thanks

 

[Michael M]

Have you considered creating a Pivot table and associated chart ?

 

[GLOpro]

that was my first thought but i cant figure out how to represent the 30min time intervals.

 

[Michael M]

Can you post a sample of your data and it's layout ?

 

[Fazza]

you might try a simple approach - select a cell in the data then press F11

 

[GLOpro]

Sure,

Here is the data set via Google drive as a CSV.

https://drive.google.com/file/d/1qNsLH8A9SjRdbe1EWDA7SGj5n5EZeg2N/view?usp=sharing

 

[Michael M]

Surely you don't want 3 years of data in 30 min intervals....there is 105000 lines of data ??
A couple of things to consider
1. Can all the zero profile reads be removed / filtered out ?
2. Controlled usage seems to be 00:00 to 4am
3. General is anytime
4. Solar is 7:30 to 3pm....approx

Can you report on these seperately ??
and finally...why bother with 30 min increments.....seems like spending $10 to save 5 cents...but I'm sure you have good reasons...

 

[GLOpro]

Surely you don't want 3 years of data in 30 min intervals....there is 105000 lines of data ??
A couple of things to consider
1. Can all the zero profile reads be removed / filtered out ?
2. Controlled usage seems to be 00:00 to 4am
3. General is anytime
4. Solar is 7:30 to 3pm....approx

Can you report on these seperately ??
and finally...why bother with 30 min increments.....seems like spending $10 to save 5 cents...but I'm sure you have good reasons...

That’s 24months of data, but I don’t need all of it.

I just want to get the data into excel that could display this in a similar fashion (but horizontally, rather than vertically in the app)

[trying to figure out how to attach an image here]

 

[Michael M]

Sorry, you're right I just looked at the years...
So we could remove ALL of the zero profile reads ?
Have a look here for how to attach

https://www.mrexcel.com/forum/about-board/508133-attachments.html

or upload to Imgur or similar and post the link back here.

 

[Michael M]

Deleting the zero value rows will reduce your data set down to 48193 rows, takes a couple of minutes to run

Sub MM1()
Dim lr As Long, r As Long
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "I").End(xlUp).Row
 For r = lr To 2 Step -1
    If Cells(r, "I").Value = 0 Then Rows(r).Delete
Next r
Application.ScreenUpdating = True
End Sub

Anything else we can eliminate ??