Link Sensor Data to Excel - DIY IOT

Posted on 02 Dec 2015

As we deploy more and sensors and gateways into more diverse applications it is becoming apparent that the users don’t always know what to expect from the data. How does the differential pressure across a filter relate to when the filter needs changing? How does the temperature of a bearing vary with load and what is the impact of wear and tear? By getting data and then analysing so much more can be understood, and it is sometimes possible to use just a few sensors to get a large amount of useful information.

The processes, machines, vehicles, storage tanks or whatever else is being monitored are usally best understood by our clients and giving them the tools to 'play' with their data, investigating relationships, creating bespoke reports from calculated fields, looking at averages, maximums, minimums, comparisons and counts helps them get to a point where they can benefit quicker. To facilitate this we have developed a plug in for Microsoft excel meaning they can have a spreadsheet with ‘live’ and historical data from any number of devices and they can start to build up the formulae and reports themselves. Many users have good skills with excel and are loving the freedom this new tool brings. Thanks to the power of excel then we have been able to create reports, for example, on the number of deliveries made to tanks, the typical delivery size and how this relates to the size of the tank, so the clients can analyse where they can make improvements.


This approach suits small scale roll outs or can be used as a way of defining requirements before committing to a more involved software development. When coupled with the Metron hardware & software platform, which can take signals from any sensor anywhere and make it accessible securely via the internet, then getting reliable, accurate and useable sensor data has never been easier. From sensor to excel, in a proven, easy, flexible and affordable way giving you do it yourself internet of things.

Telemetry Systems

We connect your sensors to the internet making the data available to you. View on your computer, tablet or smartphone; integrate to other software; configurable alerts. Compatible with tens of thousands of sensors from major manufacturers. Indexed and proven. Ready to use.

Powelectrics award-winning Telemetry Systems take signals from sensors & machines and make the readings available via the internet using web browsers and API’s. We can send alarms if a parameter goes over or under a threshold. The same technology can be used to get data into SCADA systems which is especially good when there are parameters that need monitoring that are a distance from the main network. We provide solutions for environments where there is no power.

Our technology works 'out of the box' and is proven with a wide range of sensors from many different manufacturers in many different applications. Devices can be easily centrally managed meaning the units can be reconfigured by the click of a mouse. We have catalogued hundreds of sensors meaning you can plug and play, deploying your remote monitoring solution with confidence.

Powelectrics Telemetry Systems are proven globally in many different industries. Our Telemetry Systems are not only flexible and reliable but also affordable. Benefit from accurate real time data wherever you are, wherever your equipment is.

Read More »

Enquire Now

If you're interested in Link Sensor Data to Excel - DIY IOT or anything related to it we'd be pleased to hear from you. Either give us a call on 44(0) 1827 310 666 or fill out the short form below.