Skip to main content
Version: Streamsheets 3.0

Introduction

Eclipse Streamsheets are server-based spreadsheets that consume, produce, process and forward data streams. Data streams can originate from many sources, e.g. sensors, machines, websites, databases, applications, and many more. How incoming data streams are processed, analyzed, visualized, and combined, as well as which outgoing data streams are produced, is modeled entirely with spreadsheet formulas and especially without a single line of program code.

An important characteristic of Streamsheets is that sheets are recalculated automatically based on one of the multiple possible triggers. So a calculation can be executed, when a new message arrives or by a time interval elapses (e.g. every second). This can be configured in the Inbox settings of each sheet. Consequently, conditions and formulas are considered continuously and based on these triggers, decisions are taken and visualizations are updated dynamically. This way new information is processed in real-time.

Overview1

Streamsheets allow you to send, publish, store or provide data, hence, they not only consume data streams but produce them as well. Multiple sheets form a Streamsheets app, multiple Streamsheets run in one application. In contrast to other spreadsheet applications, a sheet is calculated to left to right and top to bottom. This way you can control the flow of calculation or execution of actions (e.g. you are allowed to assemble and publish data. Then the order of execution or calculation is most probably important).

Use Cases

Streamsheets can be utilized in many fields. While the open-source version mainly targets usage in a non-productive environment, the premium version is targeting industrial and business use cases:

  • Data stream analytics and data stream synchronization
  • Dynamic Business Data Monitoring and Analysis
  • Workflow automation
  • Rule Engines, conditional alerting & actions, like sending emails, as well as soft PLCs
  • Monitoring and real-time dashboards
  • Edge-to-cloud and cloud-cloud connectivity
  • Protocol conversion and Semantic Mappings (e.g. MQTT ↔ OPC UA)
  • Pre-processing on the edge
  • Pre-Processing for AI-Systems
  • Simulation of data sources and devices
  • Fast prototyping

Target Group

Streamsheets is a tool to reach many people, but has a focus on process engineers with a high understanding of unsolved tasks in the big data and data streaming realm in their workplace environment.

The no-code characteristic allows everybody to implement their applications with minimal prior knowledge. Leveraging the widely known spreadsheet characteristics (e.g. usage of functions and references), a first Streamsheets application is possible within minutes.

How to continue

The Getting Started section guides you through the installation procedure and provides a first steps guide to give you a a short overview, how a Streamsheet can be created and explains the general approach to subscribe data and work with it.

In the Overview section, the core components of Streamsheets are introduced. Streamsheet Management, handling external connections, exporting sheets as well as administration are explained.

The guides sections explain creating and using Streamsheets in detail, showing all the different aspects of a Streamsheets App like using stream data, calculation, publishing data and other specifics to Streamsheets, but also working with Charts and Dashboards.

The Function reference explain all functions available on a sheet in detail.