# Understanding energy CSV output and tryingt to calculate energy usage

**URL:** <https://community.homey.app/t/understanding-energy-csv-output-and-tryingt-to-calculate-energy-usage/87829>\
**Category:** Questions & Help\
**Created:** [August 23, 2023, 5:09pm UTC](https://community.homey.app/t/understanding-energy-csv-output-and-tryingt-to-calculate-energy-usage/87829 "2023-08-23T17:09:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Halono007](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/halono007/32/80378_2.png) [@Halono007](https://community.homey.app/u/Halono007)\
**Post date:** [August 23, 2023, 5:09pm UTC](https://community.homey.app/t/understanding-energy-csv-output-and-tryingt-to-calculate-energy-usage/87829/1 "2023-08-23T17:09:58Z")

</div>

I went to insights and then showed last 24 hours for my measurement of a heater (EVA Zigbee Smart Plug 16A plug ).  
The report this for some measurements on energy usage (watts)

Example snip from output:

| 2023-08-21T19:35:00.000Z | 4.42 |
| --- | --- |
| 2023-08-21T19:40:00.000Z | 3.75 |
| 2023-08-21T19:45:00.000Z | 861.83 |
| 2023-08-21T19:50:00.000Z | 1894.68 |
| 2023-08-21T19:55:00.000Z | 1906.23 |

Is this the total watts per 5 minutes? I wonder because the numbers don’t add up when I try looking at last 24 hours. The sum then becomes extremely large and it cannot be right. Maybe there’s an app to show this correctly?

---

<div class="post-metadata">

**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\
**Post date:** [August 23, 2023, 7:08pm UTC](https://community.homey.app/t/understanding-energy-csv-output-and-tryingt-to-calculate-energy-usage/87829/2 "2023-08-23T19:08:55Z")

</div>

Try this app

> [@\[APP\]\[Pro\] Power by the Hour: Insights per hour, day, month and year](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535):
>
> Appstore stable version: [Power by the Hour App for Homey | Homey](https://homey.app/a/com.gruijter.powerhour) Appstore test version: [Power by the Hour App for Homey | Homey](https://homey.app/a/com.gruijter.powerhour/test)Power by the Hour Get data from a Homey power/gas/water meter device, and show the usage / production per hour, per day, per month and per year. Know the monetary value and use dynamic tariffs. Know how much your Always-on appliances are using and safe hundreds of Euros per year! This app can be used for instance together with the Enelogic and Youl…

---

<div class="post-metadata">

**Author:** ![Halono007](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/halono007/32/80378_2.png) [@Halono007](https://community.homey.app/u/Halono007)\
**Post date:** [August 28, 2023, 6:46am UTC](https://community.homey.app/t/understanding-energy-csv-output-and-tryingt-to-calculate-energy-usage/87829/3 "2023-08-28T06:46:54Z")

</div>

Nice. however it seems really chaotic when adding all devices a second time just to monitor power usage.