DDE / Excel Connections

Run calculations and analytics in real time

Excel is the tool of choice for running calculations and analyzing data in data sets large and small.  Useful as it is for financial and business systems, Excel can also enhance industrial applications.  Adding the power of Excel to your system with the Cogent DataHub provides a way to generate real-time analytics based on your live process data.

Dynamic Data Exchange (DDE) is a high-speed Windows data communications protocols supported by Excel and widely used in real-time financial applications.

Drag and drop your data into a spreadsheet and instantly see live updates. Save the spreadsheet and the next time you open it, all the data is refreshed and you have reports with up to the moment accuracy. The Cogent DataHub also makes it easy for your to pull data back out of Excel and use it as input to your control systems, or as analysis results you can share with a colleague.

  • Integrate Excel with your OPC or Modbus system.
  • View your Excel data from a web-based HMI with a drag-and-drop editor for building pages.
  • Send emails based on changes to the data in any worksheet.