Electricity usage

GLOpro

Board Regular
Joined
Jul 30, 2005
Messages
113
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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,882
Office Version
2013
Platform
Windows
Have you considered creating a Pivot table and associated chart ?
 
Last edited:

GLOpro

Board Regular
Joined
Jul 30, 2005
Messages
113
that was my first thought but i cant figure out how to represent the 30min time intervals.
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,882
Office Version
2013
Platform
Windows
Can you post a sample of your data and it's layout ?
 
Last edited:

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,352
you might try a simple approach - select a cell in the data then press F11
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,882
Office Version
2013
Platform
Windows
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...:LOL:
 

GLOpro

Board Regular
Joined
Jul 30, 2005
Messages
113
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...:LOL:

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

Well-known Member
Joined
Oct 27, 2005
Messages
18,882
Office Version
2013
Platform
Windows
Deleting the zero value rows will reduce your data set down to 48193 rows, takes a couple of minutes to run

Code:
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 ??
 

Watch MrExcel Video

Forum statistics

Threads
1,099,571
Messages
5,469,467
Members
406,654
Latest member
MR_EXCEL_16

This Week's Hot Topics

Top