I reset my Aeon kWh energy usage every month so it starts at zero. Unfortunately my meter is misread 
by a human on different day every month so I canāt make it match up with my electric bill exactly. I use CoRE, something like this to do it:
IF Date is 20th of month, 12:01am THEN using home energy meter, reset
1 Like
I use this smartapp to handle the reset of the enerygy usage every month
would that work for the v2?
I only get a Date & Time or Time option when creating a piston. I do not see a Date only option. when selection Date and Time, I am unable to chose a specific day of the month (i dont get an IS option either, but i would assume i use IS AFTER) the date and Time variable option doesnāt let me choose a specific day of the month.
EDIT:: Found it, set to occur every day at midnight, but only if that day is the last day of the monthā¦
I have a guy come and read my meter on random days as wellā¦ so i might just look for a MIN MAX difference in the google sheets???
i scheduled CoRE to do a reset 5 min in to the FUUUTUURE!!! (sorry had to do it). Anyway, it did not reset the HEMās energy value i.e, kWhs. It will not reset back to 0. posted this in the Device handler page im using (https://goo.gl/BMoqr8) but no response as of yet.
Thats why i wanted to filter the data on the google sheet as per my previous post.
Does it reset correctly if you hit the āreset energyā tile in the app device for your HEM?
To calculate the kWh comparable to the electric company meter I have to do some calculations. If I reset on 20th but they read on the 22nd, add the max value on 20th plus the smaller value on the 22nd minus the value on previous month reading. I added a column in the Google Sheet and manually insert the company meter reading on noted day, then it is more clear on what to add & subtract.
NO the HEM will not reset if i hit the reset tile.
Ok, i figured i would have to do something similar to that.
I will post this here in case anyone else is interested.
I use my Google Calendar for my sports teams that I follow. I use the GCal smart app on here for turning on a switch when a game is on (so they show up on my ActionTiles dashboard). What I really wanted was a way to view the next weekās worth of games/events.
I have finally got it working using this thread as a basis.
What it will do:
Take any existing calendar events and import them to sheets to use in tables, charts, or for sorting.
What it wonāt do:
Automatically update when you add new events to your calendar. You must re-import to get new data.
How I did it:
- I have added all the calendars to my Google Account (this actually works best if itās all added to the SAME calendar, but it can be done with multiple calendars, although youāll probably need an extra sheet for aggregating the data, which is what I had to do)
- Add the Calendar Event Importer add-on to Sheets (https://chrome.google.com/webstore/detail/calendar-event-importer/ffkehpeilnhbpobkeojanjohnocolbhi?utm_source=permalink)
- Open a new Sheet and go to Add-ons, Calendar Event Importer, Import events from calendars. This will open up a side-pane on the right where you can select which calendar(s) to pull data from. If you have multiple calendars selected, each will generate its own sheet. Fill out the date range and Import.
- Hide your excess columns for easy viewing (I only needed title, date, time, duration).
- Combine your data, if necessary (typically only required for multiple calendar import setups). To do this, I copied all data from each sheet and pasted into the main sheet.
- Create a new sheet for your Filtered Data. I called my original sheet Data and this new sheet Filtered Data.
- Use a filter formula in your Filtered Data to show only the information you are wanting (this is what you will use to make your Chart).
=filter(Data!A2:G400,Data!B2:B400>=TODAY()-1,Data!B2:B400<=TODAY()+7)is the Filter formula I used as it allows me to check back 1 day (to see the games from yesterday) and check the next 7 days, including today. I only have about 250 events currently imported with a range of 1/1/2017-12/31/2017, but I left room for next yearās schedules for teams on the wraparound seasons for when I import later and add to it. I can always increase the number of rows by changing that Filter formula. I can also change the import date range to include a larger selection (end date further from today) or a smaller selection (start date closer to today). - Select your Filtered Data and go to Insert Chart. The chart type I used is Table and itās at the very bottom of the list on the Chart Type tab.
- Follow steps 3-7 from OP for publishing chart and getting a URL for ActionTiles.
1 Like
Iām having the issue of blank cells also, but I have a Gen5 HEM, and the DH for the gen5 doesnāt have an option for time interval or watt interval. Is there a solution for Gen5 owners?
Question on google sheets for you. Do I need to add enough rows for the data or will google sheets logging add the rows for me? If it adds the rows for me how do I now what range to use in my chart?
It should add the rows for you.
The chart range should expand to follow the added rows.
I did have some issues with this at first but it seems okay now.
1 Like
Is there a special formula for the chart range to expand automatically?
Not that I know of. You might post your question in the Google Sheets Logging thread ā¦ Log events to Google Sheets [see post 154 for current Github repo and v1.1]
I think it describes a test as well where you just add to your sheet directly with a specicific URL separately from SmartThings just to make sure the Sheets part is working. Then you can go to the next step.
@diehllane , Is your sports calendar āchartā still working? I was trying to do something similar for my regular calendar events but when I try to publish the ātable chartā I donāt see the options to make it an image. Sheets just publishes it as a mini-spreadsheet (not full sheets UI)ā¦ not an image for ActionTiles though.
Yea. Mine is still working.
I just made a new one for testing.
When I am on the chart sheet I select Publish Chart.
I have it on the Link tab. The first box is empty (I have no name for my chart) and the second one I change from Interactive to Image. Iām not Publishing the sheet that the Chart is on (I put it on its own sheet and itās called Chart1), but the chart itself.
Thank you, now I see it. I swear it seems to hide from me sometimes. 
Another question, does this Calender Event Importer (I found the same one earlier) automatically refresh/sync the events? I donāt see mention of that, seems like a one time import. I would like it to refresh/sync continually without interaction. Thanks again!
It is a 1 time importer.
It works fine for my needs (as I can import an entire sports schedule prior to the season).
I do not know of a way to have it constantly refresh itself, but that would likely required a paid extension.
Anyone have a way to display non-numerical data? Iām trying to visualize on a timeline when my HVAC is running. The data is coming in from my Ecobee into a google sheet, but I havenāt found a chart that will allow it. I just want to plot something like this:
No idea if itās possible with google sheets, but Iād like to try!
Can we presume that the data is currently in a format like āactiveā / :āinactiveā? If so, have you considered converting that to text?
I did something similar with my motion sensorsā¦ Sensor 1 on = 1, off = 0ā¦ Sensor 2 on = 2.5, off = 1.5ā¦ etc
Then, I created a chart with three columns (or more if you have more sensors). Time, Sensor 1, Sensor 2. Each row has the associated dataā¦ Works well for me, I published it to a chart and have it automatically updateā¦ Using it in actiontiles without issueā¦ so farā¦