Energy consumption per square meter

[Temp]

I've built an Arduino based data logger to record outdoor temperatures and what my oil boiler is doing (run times) so I can work out roughly how much energy my house uses. 

 

I don't have much data yet but it looks like over the past month (two cold and two mild weeks?) the boiler has been firing for 25% of the time. Means the heat loss and DHW consumption averaged about 9kW. 

 

Can anyone suggest interesting ways to munge and graph the data in excel?  

[SteamyTea]

16 minutes ago, Temp said:

Can anyone suggest interesting ways to munge and graph the data in excel?  

 

Yes, but it depends what you actually want to show.

I can sort my data by time i.e. day, month.  I chart the energy usage by time of day, then plot usage, temperature inside and out, and show the amounts used and the date that is relevant.  Just working on a new template that can more easily take the 6 second data that my logger collect.