Build a functional condition monitoring dashboard with Streamsheets in 30 minutes.
How Streamsheets work – Stream Processing and IoT for Non-Programmers
Streamsheets is a powerful application used to build IoT applications. With Streamsheets, you don’t need to have any coding skills. To help you understand how Streamsheets works, this post is sectioned into 3 video sessions:
- In the first video just below you see how the data connection is established and how the necessary spreadsheet formulas and charts are created. This includes an energy monitoring and an automatic shutdown if the energy consumption or operating temperature is too high. In addition, the first video shows how to set up the Streamsheet to automatically send emails in the event of an alarm and how to make entries in a log database (here MongoDB).
- The second video extends the demo to show how you can created visual representations of the device status directly in the Streamsheets. This is done simply by dynamically linking the attributes of graphical objects with the contents of Streamsheet cells (cells, which then in turn are linked to the JSON data from the MQTT messages)
- In the third video we confess, that we actually did not use the MQTT connectivity of the Shelly 2.5 device. Instead we used the REST API which delivers very complete JSON payloads. This gave us another use case, namely to show how easy it is to use a Streamsheet to build a highly flexible REST-to-MQTT Gateway just using spreadsheet formulas.
I recommended to watch the following video in full screen mode. The video is 10 minutes long, but the first 5 minutes are enough to understand the basic principle of Streamsheets.
Did you like this blog post? Share it now
More Articles Like This
Get an indepth overview of Mosquitto 2.0 in this webinar by the lead developer, Roger Light.
Streamsheets and Apache Kafka – Interactively build real-time Dashboards and Streaming Apps just using your Spreadsheet Skills
Curious about what you can do with Streamsheets and Apache Kafka? Find out in this joint webinar by Cedalo and Confluent.