Testing the Serial Data Streaming Feature of Microsoft Excel using an Angle Control System
Ion-Cornel Mituleţu, Vlad Mureşan · 2024
In the paper, a method to achieve a hardware-software control system is presented, it could be an example for other control algorithms developing as well as an alternative to high-cost control implementation, especially in the research area. The hardware side consists of two ESP32 for high-speed and real-time wireless data exchange and an Arduino Due as USB interface with the PC. The angle value is acquired from a six-axis gyro-accelerometer sensor and send to the control algorithm implemented in Excel, which provides the command value to control the angular position. Wireless data transmission at high-speed is accomplished using ESP-NOW protocol designed by Espressif, and the serial communication between Arduino DUE and Excel is facilitated by Data Streamer a Microsoft developed add tool. Tests performed on the simulated drone arm show interesting characteristics that can be obtained if control technics are implemented in common software as Excel, also defining a low-cost method possible to be widely used in the future researches.