A Simple Data Acquisition Software for Serial Devices Based on Excel VBA and Its Application in Rotary Kilns
In order to collect field data of rotary kilns for detailed analysis before automatic control system were designed and implemented,a simple data acquisition software for serial devices on the basis of Excel VBA was introduced in this paper.The serial communication module was coded with MSComm control.Data were presented both in tables and curves by the charting tools of Excel.A modified 53H algorithm was presented for online abnormal value detection while several data filtering functions were provided.Organized workbooks and worksheets were used as storage structures rather than a database system.Its application in a Lithopone rotary kiln proved its effectiveness in data acquisition,storage,query and preprocessing.This kind of simple data acquisition software has advantages in economical efficiency and simplicity,and is suitable for data acquisition applications with low sampling rates.
Excel VBA Serial communication Data acquisition system Data preprocessing
Jing Yao Qi Liang Du
School of Mechanical & Electrical Engineering,Guangzhou University,Guangzhou,China College of Automation Science and Technology,South China University of Technology,Guangzhou,China
国际会议
广州
英文
1638-1644
2012-11-16（万方平台首次上网日期，不代表论文的发表时间）