Calculate average KWH from datalog

Post any questions you may have about our current range of USB data loggers
Post Reply
Posts: 0
Joined: Fri Jul 26, 2013 8:18 am

Calculate average KWH from datalog

Post by rodolphe » Fri Jul 26, 2013 9:41 am

We set-up the datalogger on a machine for nearly 9 hours.
The machine is a three phase (400V AC). For info it is a box-wrapper and heat-shrink tunnel.

How can I calculate the average power consumption of the machine in KHW?
The machine plate is written 35KWH. I want to know what is the peak load and the average running load.

I put the logs into an excel spreadsheet attached to this post. I hope you can reply on it so I understand the calculations.

The datalogs were every second.
The readings are in Amps.


Site Admin
Site Admin
Posts: 3714
Joined: Fri Jun 10, 2011 8:15 am
Location: St. Neots

Re: Calculate average KWH from datalog

Post by Martyn » Tue Jul 30, 2013 1:29 pm

Please send in your spreadsheet and question to and the guys there will look at your data
Technical Support Manager

Post Reply