Low cost environment for rapid prototyping of control algorithms for mechatronic plants based on Microsoft Office Excel application

• Autorzy: Tutaj A. , Augustyn J.
• Języki publikacji: EN

Abstrakty

EN

The paper presents a low cost rapid prototyping environment for control algorithm development based on Microsoft Excel program and a measurement and control board built on an ARM Cortex M core microcontroller. The solution is intended mainly for mechatronic devices. It provides tools for computer simulations and soft real time closed loop control experiments. An application to a fast and unstable mechatronic plant of an inverted pendulum on a cart is presented to show system capabilities.

Słowa kluczowe

EN

rapid prototyping; mechatronic system; Microsoft Office Excel; VBA; soft real time

• Wydawca: Wydawnictwo PAK
• Czasopismo: Measurement Automation Monitoring
• Rocznik: 2015
• Tom: Vol. 61, No. 2
• Strony: 43--46
• Opis fizyczny: Bibliogr. 7 poz., rys., tab.

Twórcy

autor

Tutaj A.

• AGH University of Science and Technology, al. A. Mickiewicza 30, 30-059 Krakow

autor

Augustyn J.

• AGH University of Science and Technology, al. A. Mickiewicza 30, 30-059 Krakow

Bibliografia

• [1] Yao J., Du Q. L.: A simple data acquisition software for serial devices based on Excel VBA and its application in rotary kilns. Advanced Materials Research, vol. 591 593, pp. 1638-1644, 2012.
• [2] Aliane N.: Data acquisition and real time control using spreadsheets: Interfacing Excel with external hardware. ISA Transactions, vol. 49, iss. 3, pp. 264-269, Jul 2010.
• [3] Bottero M., Dalla Chiara B., Deflorio F. P.: Wireless sensor networks for traffic monitoring in a logistic centre. Transportation Research Part C: Emerging Technologies, vol. 26, pp. 99-124, Jan 2013.
• [4] Pineda Sanchez M., Perez Cruz J.: Real time connection of programmable logic controllers to Excel spreadsheets. Proceedings of the 2002 IEEE International Symposium on Industrial Electronics, vol. 1, pp. 233-238, 2002.
• [5] Hall K.: NSA using EXCEL '97 with GPIB allows making measurement and analysis less tedious. IEEE International Symposium on Electromagnetic Compatibility, vol. 1, pp. 515-518, 19 23 Aug 2002.
• [6] Aliane N.: Spreadsheet based control system analysis and design: A command oriented toolbox for education. IEEE Control Systems Magazine, vol. 28, iss. 5, pp. 108-113, 2008.
• [7] Mirapalheta G. C., Penedo S .R. M., Justo, J. F.: A feedback system dynamic response analysis by root locus method using Excel spreadsheet and XNumbers add in package. International Journal of Electrical Engineering Education, vol. 50, iss. 1, pp. 69-79, Jan 2013.