課程資料
課程簡介
Learn how to use Microsoft Excel to communicate Serially or via TCP/IP with any Modbus Slave
If you design and implement projects in the area of Process Automation or SCADA, you will know from your experience that "one size does not fit all" when it comes to data acquisition and Human Machine Interfaces (HMIs). There is always some type of customization to be done. Always some feature that the standard HMI software does not offer.
And sometimes, using a very expensive HMI with all sorts of bells and whistles for a small project can just be overkill. There are times when you just need a very simple application that acquires a few data points from a Modbus network and displays them on a computer screen.
These are the reasons for this course!
I teach you how to use Microsoft Excel to create your own Modbus Master application and Human Machine Interface.
If you apply yourself in this course and execute all that I ask you to do, then at the end, you would be essentially be creating an application with all of the superb data analysis capabilities of Microsoft Excel and applying it to Modbus data!
This is the start of your journey into a whole new area of Process Automation / SCADA and one that is increasingly in very high demand!
Looking forward to seeing you on the inside!
課程章節
- 7 個章節
- 17 堂課
- 第 1 章 Introduction
- 第 2 章 The Software We Will Be Using
- 第 3 章 Quick Start - Our First Excel Modbus Master HMI Application
- 第 4 章 Expanding the Quick Start Excel Modbus Master Example
- 第 5 章 Adding Modbus Write Commands to the Excel Application
- 第 6 章 Changing from Modbus Serial Communications to Modbus TC/IP Communications
- 第 7 章 Bonus Section - How to Always get the Lowest Prices for my Courses
課程內容
- Have an understanding of how ActiveX controls work with Microsoft Excel, Install the MBAXP Modbus ActiveX control in Microsoft Excel, Write VBA code to read Modbus data from a Modbus Slave/Server, Write VBA code to write Modbus data to a Modbus Slave/Server, Use Modsim32 as a Modbus Test Slave and Server, Establish both Modbus Serial and TCP/IP Communications using Microsoft Excel
此課程所涵蓋的技能
評價
-
SSHOHARAT ALI ANSARI
The detailing in explanation is very good.
-
RRodolfo Alonso Rodríguez Aguilar
.
-
FFong WK
Looking forward to working with Modbus/Excel
-
GGonzalo Carbo
The course was extremely clear and useful for me. As soon as I finished it, I could succesfully meet my initial goal which was to establish a modbus tcp link between an Excel spreadsheet and a Schneider M221 plc. Thanks a lot to the teacher for this course, now I'm sure I'll take other courses from him in the near future.