# \[APP\]\[Pro\] Power by the Hour: Insights per hour, day, month and year **URL:** \ **Category:** Apps\ **Tags:** app, tools\ **Created:** [November 10, 2019, 10:06pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535 "2019-11-10T22:06:03Z")\ **Posts on this page:** 20\ **Page:** 141
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 10, 2025, 7:17am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2860 "2025-01-10T07:17:33Z")
![](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/0/80de29f014eb37d309111c9d3148f9f82fd684ef.jpeg) This graphic of today is wrong for the **00:00 - 05:00** part. ---
**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:** [January 10, 2025, 9:08am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2861 "2025-01-10T09:08:34Z")
Hi Theo, thx for all the input. I see there is a problem with gas prices. But so many apps, so little time. Since the gasprice bug impact is limited, it is not top of my list. Be (very?) patient 😉 ---
**Author:** ![Andreas\_Kjork](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/andreas_kjork/32/8354_2.png) [@Andreas\_Kjork](https://community.homey.app/u/Andreas_Kjork)\ **Post date:** [January 10, 2025, 1:34pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2862 "2025-01-10T13:34:14Z")
In Sweden, and possibly other countries, we will no longer have hourly pricing starting June 11. Instead, we will have quarter-hour pricing, meaning a new price every 15 minutes. Is this something that is being worked on? ---
**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:** [January 10, 2025, 1:56pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2863 "2025-01-10T13:56:33Z")
Yes, when i have time and energy 😉 ---
**Author:** ![Andreas\_Kjork](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/andreas_kjork/32/8354_2.png) [@Andreas\_Kjork](https://community.homey.app/u/Andreas_Kjork)\ **Post date:** [January 10, 2025, 2:10pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2864 "2025-01-10T14:10:37Z")
Thanks 🙏 ---
**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:** [January 10, 2025, 9:42pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2865 "2025-01-10T21:42:52Z")
@Theo_de_Koning many thx for your kind donation! 🥰🥳🍻 ---
**Author:** ![El\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/el_m/32/121876_2.png) [@El\_M](https://community.homey.app/u/El_M)\ **Post date:** [January 15, 2025, 1:56pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2866 "2025-01-15T13:56:22Z")
Hi - I have my power consumption logged to a google sheet (Gas, Electricity & Water). What I notice is that values are (seem?) not consistently logged. Take the below example: ![Screenshot 2025-01-15 145201](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/7/d773a9c0865b3c9e4cb32f667908fd7dd57699ae.jpeg) Consumption on Jan 9th is 9.289 (m3 gas) and on the 10th is 12.25 and the 11th 10.414. The actual values written into the cells are 9289 and 12.25 and 10414 respectively. Adding these numbers to e.g. weekly or monthly totals then doesn’t make sense. How come it seems to store the values inconsistently? I have tried to adjust the notation of the google sheet, but that is merely a ‘cosmetic’ change - it doesn’t address the underlying inconsistent data. thanks! ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 15, 2025, 2:31pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2867 "2025-01-15T14:31:47Z")
> [@El\_M](#): > > The actual values written into the cells are 9289 and 12.25 and 10414 respectively For me is it 9.289 en 10.414 in the cells. Make the column 3 digits wide then you get 12.250. ---
**Author:** ![El\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/el_m/32/121876_2.png) [@El\_M](https://community.homey.app/u/El_M)\ **Post date:** [January 15, 2025, 2:47pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2868 "2025-01-15T14:47:14Z")
I have done that, but it only changes the ‘cosmetics’ - not the underlying number. If I exaggerate by showing more decimals I get the following: ![Screenshot 2025-01-15 154625](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/9/39b69f2d7f97e31c0c1def05d66669c949b58777.jpeg) ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 15, 2025, 3:11pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2869 "2025-01-15T15:11:46Z")
If you using Google sheet then it’s something tricky for getting the notation right. Therefore I do this: ![](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/5/f/5fa7e91e30365c5ed4431b38c162e9673d27a682.jpeg) Try things out for your county Before I had often to adjust the cell by hand. **By picture** Oops, of a cell = for a cell. ---
**Author:** ![El\_M](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/el_m/32/121876_2.png) [@El\_M](https://community.homey.app/u/El_M)\ **Post date:** [January 15, 2025, 3:17pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2870 "2025-01-15T15:17:01Z")
thanks Theo - I will try this tonight. Didn’t know ‘better logic library’ - but how you describe it, makes perfect sense! In the meantime I have installed better logic library and followed your examples. Looks like it works 🙂 ---
**Author:** ![hoverzx](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/hoverzx/32/91062_2.png) [@hoverzx](https://community.homey.app/u/hoverzx)\ **Post date:** [January 15, 2025, 7:17pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2871 "2025-01-15T19:17:44Z")
Thank you for providing such a great app for Homey, and I have been using it since I have Homey (almost a year). It works perfectly for all my single devices, such as Air Conditioners, Boilers, etc. Recently I installed 40 Zigbee LED downlight, it is around 12W each. They are in different zones. Is there any way to measure the energy consumption for all the LEDs? Either by Zone or by type? Thank you very much ! ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 16, 2025, 4:36pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2872 "2025-01-16T16:36:50Z")
News from my grid operator. My energy supplier have ask them to read the e-meter per 15 minutes. It’s going to happend also here. In my flows I worked already with 15 minutes for the kWh so, “only” do that idem with the prices then. 😉 _Where is the tabel/spreadsheet variable._ ---
**Author:** ![johan\_W](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_w/32/17556_2.png) [@johan\_W](https://community.homey.app/u/johan_W)\ **Post date:** [January 16, 2025, 5:02pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2873 "2025-01-16T17:02:05Z")
[quote=“Theo\_de\_Koning, post:2872, topic:20535”] But will your supplier all so bill you for every 15 min. (i see you have zonneplan) and they advertice only with hour prices. Or is with a combination off a home battery setup? ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 16, 2025, 5:22pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2874 "2025-01-16T17:22:28Z")
It’s known that we going to 15 minutes pricing. In post 2802 here, I read Sweden starting 11 June. ---
**Author:** ![johan\_W](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/johan_w/32/17556_2.png) [@johan\_W](https://community.homey.app/u/johan_W)\ **Post date:** [January 17, 2025, 5:38pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2875 "2025-01-17T17:38:10Z")
Maybe some hints for @Gruijter that we can expect 15 min prices this in the future. ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 17, 2025, 6:58pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2876 "2025-01-17T18:58:07Z")
When a problem is solved then I find it normal to give feedback. The **gas** JSON file for “today” and “tomrrow” are right now. Thanks @Gruijter👍 ---
**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:** [January 17, 2025, 7:38pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2877 "2025-01-17T19:38:18Z")
Thx! But the issue cannot be gone since I didnt change anything 😉 ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [January 17, 2025, 8:24pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2878 "2025-01-17T20:24:11Z")
LOL 😂 This morning I try to make a little adjustment to the FM price for today and that was not working. Even the graphic in the virtual device was gone. Therefore I reset the app but with no result. Later I get my flow messages that the new gas price for tomorrow was there. Looking to the JSON file of “tomorrow” I saw the old and the new price. But also in the JSON file of “today”. Then I was thinking ‘it’s repaired’. 😉 The 2nd time to adjust FM price it was direct accepted and good. Is this now not also an error? 🤔 ---
**Author:** ![Rrrr](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rrrr/32/629_2.png) [@Rrrr](https://community.homey.app/u/Rrrr)\ **Post date:** [January 20, 2025, 9:04am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2879 "2025-01-20T09:04:01Z")
@Gruijter I have not received new prices since yesterday (DAP Estonia). The last update was 11 hours ago at 11CET or midnight local time. I rebooted the app, but it did not help. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/b/dbf0c63a35bca54ca2e01d02b5e8b6ca622016e0.png) @Gruijter Update: 1400 local time: prices were updated for Price Now only, the +1H…+7H periods have the same price as Price now 1500 local time: same prices as at 1400 [Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=140) [Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=142)