# Get an average Watt value

**URL:** <https://community.homey.app/t/get-an-average-watt-value/6319>\
**Category:** Questions & Help\
**Created:** [January 4, 2019, 11:59pm UTC](https://community.homey.app/t/get-an-average-watt-value/6319 "2019-01-04T23:59:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dENNtoet](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/denntoet/32/3622_2.png) [@dENNtoet](https://community.homey.app/u/dENNtoet)\
**Post date:** [January 4, 2019, 11:59pm UTC](https://community.homey.app/t/get-an-average-watt-value/6319/1 "2019-01-04T23:59:05Z")

</div>

Hi everyone,

This might be a very stupid question for some, but this just isn’t my cup of tea…so bare with me.

I have a freezer which I suspects eats alot of power. I have the freezer plugged in to a Xiaomi Smart socket which can collect ‘Power (Watt)’ data. The graph it generates is below:

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/5/58f8d91df8d96833f5125b15013eb70838dc4795.png)

I just want to know how much kwh it uses so I can calculate how much kwh it consumes over a year… I just don’t know how ☹

---

<div class="post-metadata">

**Author:** ![Robin\_van\_Kekem](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robin_van_kekem/32/8187_2.png) [@Robin\_van\_Kekem](https://community.homey.app/u/Robin_van_Kekem)\
**Post date:** [January 5, 2019, 11:35pm UTC](https://community.homey.app/t/get-an-average-watt-value/6319/2 "2019-01-05T23:35:56Z")

</div>

This might get you in the right direction:  
[https://www.saveonenergy.com/energy-consumption/](https://www.saveonenergy.com/energy-consumption/)

---

<div class="post-metadata">

**Author:** ![JPe4619](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jpe4619/32/9017_2.png) [@JPe4619](https://community.homey.app/u/JPe4619)\
**Post date:** [January 6, 2019, 1:16am UTC](https://community.homey.app/t/get-an-average-watt-value/6319/3 "2019-01-06T01:16:51Z")

</div>

If your socket is not capable to supply the kWh information, then you need a socket that can do that.  
 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/4/416b86a94eff0dbbac490d187564eedc0c30fdf9.png)  
This is anAEOTEC Smart switch 6

---

<div class="post-metadata">

**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\
**Post date:** [January 6, 2019, 7:29am UTC](https://community.homey.app/t/get-an-average-watt-value/6319/4 "2019-01-06T07:29:06Z")

</div>

You could export the data as CSV using [this app](https://apps.athom.com/app/com.gruijter.insights2csv), import it into Excel, average the wattage over a time period and calculate a kWh amount from that.

---

<div class="post-metadata">

**Author:** ![bvdbos](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bvdbos/32/2352_2.png) [@bvdbos](https://community.homey.app/u/bvdbos)\
**Post date:** [January 6, 2019, 7:41am UTC](https://community.homey.app/t/get-an-average-watt-value/6319/5 "2019-01-06T07:41:59Z")

</div>

Insights has a download-button too:

 ![6%20hour%20total](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/5/5ba3d018ff5427b009e1fee3e5933155d9bb2c5a.png)

---

<div class="post-metadata">

**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\
**Post date:** [January 6, 2019, 7:48am UTC](https://community.homey.app/t/get-an-average-watt-value/6319/6 "2019-01-06T07:48:50Z")

</div>

From the original screenshot I inferred OP is still using 1.5 🙂