Data acquisition and real-time control using spreadsheets: Interfacing Excel with external hardware

作者：Aliane Nourdine^*

来源：ISA Transactions, 2010, 49(3): 264-269.

DOI：10.1016/j.isatra.2010.03.009

• Data acquisition
• Real-time control
• PID controller
• Spreadsheets
• VBA

Spreadsheets have become a popular computational tool and a powerful platform for performing engineering calculations. Moreover, spreadsheets include a macro language, which permits the inclusion of standard computer code in worksheets, and thereby enable developers to greatly extend spreadsheets' capabilities by designing specific add-ins. This paper describes how to use Excel spreadsheets in conjunction to Visual Basic for Application programming language to perform data acquisition and real-time control. Afterwards, the paper presents two Excel applications with interactive user interfaces developed for laboratory demonstrations and experiments in an introductory course in control.

• 出版日期2010-7