[OBSOLETE] Power Meter Logging SmartApps (PlotWatt, ThingSpeak, SmartEnergyGroups)

[RightHand]

[OBSOLETE] Simple Event Logger

If you extract the date from the date/time column into a new column, you can use a pivot table to get the daily totals for all the devices. Once the data is in that layout you should be able to easily create the graph you’re looking for. Make a copy of the sheet because if it’s updating while you’re messing with it you may experience problems. Add a new column and use “Date” for the header. Enter the formula below into the first cell and then copy that cell and paste it to the rest of the cells in that column. =int(a2) Then click the column header so that the whole date column is selected and change the number format to date. The next version of the SmartApp will have an option for automatically including the date column so that you don’t have to manually perform those steps. Then…

Google Sheets Charts

There are a couple Google Sheet data logging smart apps (GoogleSheetsLogging and SimpleEventLogger) and I just wanted to share a way to get a chart from a Google Sheet that could be used in SmartTiles or potentially a DH in the SmartThings App. The trick is to publish the chart as an image; from that, you have a URL that can be used anywhere you can reference an image on the internet. 1-set up your preferred logging smart app 2-insert chart from button bar, set up a chart as you like. Note: make sure to include the last row of the sheet in data ranges and this will allow the chart to refresh the new data added by your smart app. 3-(optional)from chart pulldown, select ‘move to own sheet’ (now the chart will have its own tab) 4-click publish, under link, change interactive pulldown to…