Link Sensor Data to Excel - DIY IOT
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.
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.