Is Excel alike dealing with sensorEDGE's aggregated IO-Link sensor data - as the real-time processing platform e.g. 'Streamsheets' is offering it - possible?

Is Excel alike dealing with sensorEDGE's aggregated IO-Link sensor data - as the real-time processing platform e.g. 'Streamsheets' is supporting it - possible?

Yes this is possible since the sensorEDGE solution is providing the IO-Link-sensor data on MQTT over an Internet hosted MQTT broker.

STEP 1:

For a simple test sign up for a trial playground account under https://cedalo.com/pro-streamsheets/trial-signup/ and confirm your email address.

STEP 2:

You will be receiving another email including your personal cloud hosted Streamsheets Pro URL and username and password. Use the given credentials to login.

STEP 3:

Create a new Streamsheets App in your workspace by clicking the "+" in the top right corner. Give the app a name. Using a template is not necessary.

STEP 4:

Create a new connection of type MQTT by clicking the icon  and the "+" and then on "MQTT"

STEP 5:

a. Watch your personal "sensorEDGE data service credentials" page on your www.sensoredge.io account.

b. Copy and paste the information Username/Password/Endpoint URL from the page into the Streamsheets MQTT "Settings" form. Uncheck the "Validate CA Certificate" checkbox!

d. Watch the MQTT light turning green if there is a connection successfully established

d. Click the Streamsheets MQTT "Subscriptions" tab as next

e. Click the "+" and copy and paste the Base Topic value of exactly that sensorEDGE device in your list of sensorEDGE devices you want to receive data from into the column Topic. Make sure the topic value ends with a hash "#".

STEP 6:

Start your Streamsheets sheet by clicking the play button

STEP 7:

Watch the JSON coded payload of the incoming messages in the payload window to the left (update rate depends on your configured sensorEDGE data update rate)

STEP 8:

a. Draw a line chart on your sheet using the icon 

b. From the payload window drag and drop any value you want to monitor to your sheet. The example shows the object "Temperature" and its value right next to it.