# Calculate energy per day **URL:** \ **Category:** Questions & Help\ **Created:** [October 12, 2020, 9:50pm UTC](https://community.homey.app/t/calculate-energy-per-day/35885 "2020-10-12T21:50:33Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Sander](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sander/32/2507_2.png) [@Sander](https://community.homey.app/u/Sander)\ **Post date:** [October 12, 2020, 9:50pm UTC](https://community.homey.app/t/calculate-energy-per-day/35885/1 "2020-10-12T21:50:33Z")
I have a shelly P1 in my garage. I get power from my neighbour. I want 2 things. 1 calculate per 24h the total KWh i used 2 link with IFTTT Google spreadsheet so the power Usage wil be inserted in the document Is that possible ? ---
**Author:** ![DirkG](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dirkg/32/118897_2.png) [@DirkG](https://community.homey.app/u/DirkG)\ **Post date:** [October 13, 2020, 6:12am UTC](https://community.homey.app/t/calculate-energy-per-day/35885/2 "2020-10-13T06:12:38Z")
> [@Sander](#): > > 1 calculate per 24h the total KWh i used The easiest way is to use the App [Power by the Hour](https://homey.app/de-de/app/com.gruijter.powerhour/Power-by-the-Hour/). If you want no extra App is it also possible with variables. With point 2 I can’t help. ---
**Author:** ![Igy](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/igy/32/22144_2.png) [@Igy](https://community.homey.app/u/Igy)\ **Post date:** [October 13, 2020, 11:55am UTC](https://community.homey.app/t/calculate-energy-per-day/35885/3 "2020-10-13T11:55:00Z")
For 2nd point, you can downlod csv data directly from shelly device. At least from shelly 3EM its possible. Just log directly to device via its IP addres and you will see download icon next to the actual consumption.