Excel VBA Agent using MindConnect API (Southbound)

[NayanRamnanan]

I was able to write a southbound agent in Excel VBA (see attached)

Thanks to Senh Mo Chuang (CMO), and the training at the MindSphere Academy in Austin TX, I was able to do this in a couple of days. 

How practical is this? It's great for a demo.

No programming software needed, no add-ins, no ten different files to jump around to find - just Excel 2013 or higher!

If you want to learn the functionality of the southbound API, you can start here. 

I tried to make the code simple to follow, and avoided a class strucuture. I hope it works for you, and provides some insight into developing your own agent.

Instructions on how to use this to send time series data to MindSphere can be found in the first worksheet.

This assumes you know how to use Asset Manager and Fleet Manager.

[Jagannath]

Senh Mo is a cool guy.

[Rex_Chen]

Legend.

[NayanRamnanan]

I've updated the Excel VBA Agent (attached) so that it can send data continuously. It auto generates data in Excel and sends to MindSphere.

I've done demos with this twice, and has been well received with reactions of how easy it was to send data to MindSphere!

[_And_]

Is there a limit in amount of transferred datapoints?