Aeotec home energy meter V1(DSB09104-ZWUS) log to spread sheet

rebelbah · January 10, 2019, 1:56pm

Hi All
Has anyone been able to use the Aeotec HEM v1 to log to a spread sheet, either local or to a cloud service such as onedrive or google drive

greg · January 10, 2019, 2:11pm

I think these are probably the two most popular.

[OBSOLETE] Simple Event Logger Community Created SmartApps

This SmartApp will stop working when the Groovy platform is retired This SmartApp is no longer supported because SmartThings made some changes to the way events are handled which has impacted some users and it will most likely completely stop working in the near future. There’s another SmartApp called something like Google Sheets Logger that subscribes to the events instead of retrieving them from the device history so it most likely won’t have the same issues as this one. Simple Event Logger is a fully customizable SmartApp that allows you to accurately log all device activity to a Google Sheets Spreadsheet. Each event is stored on a separate row so that you have their exact time and details. Google Sheets has an easy to use filter feature which allows you to do things like view all e…

Here is a “round up” that doesn’t include SEL. I think some of the other information might be outdated as well. I think Plotwatt plotzed

ROUNDUP: Data Logging and Charting Solutions FAQ

There’s loads of data logging and charting solutions, so I thought I’d create an index. Reply with any solutions I’ve missed and I will update this post. Amazon DynamoDB [cloud (free/paid)]: Elastic Stack (LogStash+Beats+Elasticsearch+Kibana) [private (free) / cloud (paid)]: Can’t see a specific thread on the community, but here’s a github link: Google Sheets [cloud (free)]: [image] GroveStreams [cloud (free/paid)]: [image] InfluxData TICK Stack (Telegraf+InfluxDB+Chronograf+Kapacitor ) + Grafana [private (free) / cloud (paid)]: [image] Initial State [cloud (free/paid)]: [image] PlotWatt [cloud (free/paid)]: Note: PlotWatt is discontinuing its support for 3rd party residential energy monitors on March 31st, 2017 [image] ThingLayer [cloud (free)]: Discontin…

rebelbah · January 10, 2019, 2:48pm

found this after doing a google search, logs to google spread sheet

github.com

krlaframboise/SmartThings/blob/master/smartapps/krlaframboise/simple-event-logger.src/ReadMe.md#simple-event-logger

<h1 id="simple-event-logger">Simple Event Logger - v1.4.1</h1>
<p>By Kevin LaFramboise (krlaframboise)</p>

<p><img align="right" src="https://raw.githubusercontent.com/krlaframboise/Resources/master/simple-event-logger/app-SimpleEventLogger@3x.png" alt="Simple Event Logger Logo" />The Simple Event Logger is a fully customizable SmartApp that allows you to accurately log all device activity to a Google Sheets Spreadsheet.  Each event is stored on a separate row so that you have their exact time and details.</p>

<p>Google Sheets has an easy to use filter feature which allows you to do things like view all events for a specific device(s), in a specified date/range and/or specific types of events like temperature.</p>

<p>Since all of your data will be stored in one spreadsheet,advanced users can easily generate pivot tables and graphs for any information they need.  It also eliminates the need to update the code in multiple spreadsheets every time a new version is released.</p>

<hr>

<h2>Menu</h2>

<ul>
	<li><a href="#features">Features</a></li>
	<li>Installation<br>
		<ul>
			<li><a href="#google-sheets-setup">Google Sheets Web App Installation</a></li>
			<li><a href="#smartapp-setup">SmartApp Installation</a></li>			
		</ul>

This file has been truncated. show original

Topic		Replies	Views
Energy monitoring? Apps & Clients	1	2392	March 4, 2017
Aeon Home Energy Meter - daily usage and cost summary FAQ	4	5316	January 25, 2017
Get Sensor to log data to google sheets? Projects & Stories logging	5	896	August 4, 2023
Aeotec Home Energy Meter Gen5, Z-Wave Plus electricity use monitor Devices & Integrations	3	696	August 8, 2020
[OBSOLETE] Log events to Google Sheets [see post /36719/154 for Github repo and v1.1] Community Created SmartApps	470	55158	February 28, 2023

Aeotec home energy meter V1(DSB09104-ZWUS) log to spread sheet

Related topics