CFP last date
22 April 2024
Reseach Article

A Virtual-Lab Tool for Teaching the Fundamentals of a DC Motor-Generator Operation using Excel-VBA

by Cleber Gustavo Dias, Luiz Carlos Da Silva
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 183 - Number 24
Year of Publication: 2021
Authors: Cleber Gustavo Dias, Luiz Carlos Da Silva
10.5120/ijca2021921627

Cleber Gustavo Dias, Luiz Carlos Da Silva . A Virtual-Lab Tool for Teaching the Fundamentals of a DC Motor-Generator Operation using Excel-VBA. International Journal of Computer Applications. 183, 24 ( Sep 2021), 1-8. DOI=10.5120/ijca2021921627

@article{ 10.5120/ijca2021921627,
author = { Cleber Gustavo Dias, Luiz Carlos Da Silva },
title = { A Virtual-Lab Tool for Teaching the Fundamentals of a DC Motor-Generator Operation using Excel-VBA },
journal = { International Journal of Computer Applications },
issue_date = { Sep 2021 },
volume = { 183 },
number = { 24 },
month = { Sep },
year = { 2021 },
issn = { 0975-8887 },
pages = { 1-8 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume183/number24/32072-2021921627/ },
doi = { 10.5120/ijca2021921627 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T01:17:43.986589+05:30
%A Cleber Gustavo Dias
%A Luiz Carlos Da Silva
%T A Virtual-Lab Tool for Teaching the Fundamentals of a DC Motor-Generator Operation using Excel-VBA
%J International Journal of Computer Applications
%@ 0975-8887
%V 183
%N 24
%P 1-8
%D 2021
%I Foundation of Computer Science (FCS), NY, USA
Abstract

This paper presents an Excel-VBA implementation tool for teaching some fundamentals of rotating electrical machines in undergraduate and graduate level, particularly for electrical engineering curriculum. The basic concepts of a Direct Current (DC) motor operation and a DC generator have been simulated for several operational scenarios. The simulation results have been compared to mathematical models implemented in the Matlab/Simulink© environment using the 4th Runge-Kutta method for numerical solution of the differential equations that correspond to the dynamic behavior of the electrical machine. In addition, some experimental results have shown a good approximation between the simulation results obtained from the proposed virtual tool and the experimental data. Therefore, the present development is capable of serving as a potential virtual lab for a better understanding of rotating electrical machines concepts, particularly for undergraduate courses.

References
  1. R. G. Belu and I. C. Husanu, “Using a virtual platform for teaching electrical machines and power systems courses,” in 120th ASEE Annual Conference and Exposition, 2013, pp. 1– 18.
  2. M. Salunke and J. Kittur, “An experiential learning in electrical machines laboratory course,” in 2017 5th IEEE International Conference on MOOCs, Innovation and Technology in Education (MITE), 2017, pp. 15–20.
  3. M. Torrent, E. Martinez, and J. I. Perat, “Application work using software tools and didactic equipment of electrical machines in electrical engineering studies,” Computer Applications in Engineering Education, vol. 28, no. 2, pp. 435–443, 2020. [Online]. Available: https://onlinelibrary. wiley.com/doi/abs/10.1002/cae.22205
  4. C. Hao, A. Zheng, Y. Wang, and B. Jiang, “Experiment information system based on an online virtual laboratory,” Future Internet, vol. 13, no. 2, 2021. [Online]. Available: https://www.mdpi.com/1999-5903/13/2/27
  5. B. Balamuralithara and P. C. Woods, “Virtual laboratories in engineering education: The simulation lab and remote lab,” Computer Applications in Engineering Education, vol. 17, no. 1, pp. 108–118, 2009. [Online]. Available: https://onlinelibrary.wiley.com/doi/abs/10.1002/cae.20186
  6. V. Potkonjak, M. Gardner, V. Callaghan, P. Mattila, C. Guetl, V. M. Petrovi´c, and K. Jovanovi´c, “Virtual laboratories for education in science, technology, and engineering: A review,” Computers and Education, vol. 95, pp. 309–327, 2016. [Online]. Available: https://www.sciencedirect.com/science/ article/pii/S0360131516300227
  7. A. Hidayat and V. G. Utomo, “Virtual laboratory implementation to support high school learning,” International Journal of Computer Applications, vol. 120, no. 16, pp. 14–18, 2015.
  8. K. H. Cheong and J. M. Koh, “Integrated virtual laboratory in engineering mathematics education: Fourier theory,” IEEE Access, vol. 6, pp. 58 231–58 243, 2018.
  9. A. Yazidi, H. Henao, G.-A. Capolino, F. Betin, and F. Filippetti, “A web-based remote laboratory for monitoring and diagnosis of ac electrical machines,” IEEE Transactions on Industrial Electronics, vol. 58, no. 10, pp. 4950–4959, 2011.
  10. J. S´aenz, J. Chac´on, L. De La Torre, A. Visioli, and S. Dormido, “Open and low-cost virtual and remote labs on control engineering,” IEEE Access, vol. 3, pp. 805–814, 2015.
  11. D. Lowe, H. Yeung, M. Tawfik, E. Sancristobal, M. Castro, P. Ordu˜na, and T. Richter, “Interoperating remote laboratory management systems (rlmss) for more efficient sharing of laboratory resources,” Computer Standards & Interfaces, vol. 43, pp. 21–29, 2016. [Online]. Available: https://www. sciencedirect.com/science/article/pii/S0920548915000859
  12. E. Tanyildizi and A. Orhan, “A virtual electric machine laboratory for synchronous machine application,” Computer Applications in Engineering Education, vol. 17, no. 2, pp. 187– 195, 2009.
  13. J.J. Fuertes, M. Dom´ınguez, M. A. Prada, S. Alonso, and A. Mor´an, “A virtual laboratory of d.c. motors for learning control theory,” The International Journal of Electrical Engineering & Education, vol. 50, no. 2, pp. 172–187, 2013. [Online]. Available: https://doi.org/10.7227/IJEEE.50.2.6
  14. L. Yong, Z. Meng, W. Qian, S. Jing, L. Fei, and R. Liuyang, “Design and realization of a novel visual educating device for rotating magnetic fields,” in 2017 20th International Conference on Electrical Machines and Systems (ICEMS), 2017, pp. 1–6.
  15. S. Kadiman, A. Basuki, and D. Suwarti, “Virtual laboratory of unbalanced transient condition in synchronous generator,” Indonesian Journal of Electrical Engineering and Computer Science, vol. 5, no. 1, pp. 1–10, 2017.
  16. B. Golman and A. Yermukhambetova, “An excel vbabased educational module for simulation and energy optimization of spray drying process,” Computer Applications in Engineering Education, vol. 27, no. 5, pp. 1103–1112, 2019. [Online]. Available: https://onlinelibrary.wiley.com/ doi/abs/10.1002/cae.22139
  17. L. Briones, V. Morales, J. Iglesias, G. Morales, and J. M. Escola, “Application of the microsoft excel solver tool in the optimization of distillation sequences problems,” Computer Applications in Engineering Education, vol. 28, no. 2, pp. 304–313, 2020. [Online]. Available: https://onlinelibrary.wiley.com/doi/abs/10.1002/cae.22193
  18. S. Demir, S. Duman, N. Manav Demir, A. Karadeniz, and E. Lubura, “An ms excel add-in for teaching hydraulics of pipe flow in engineering curricula,” Computer Applications in Engineering Education, vol. 26, no. 3, pp. 449–459, 2018.
  19. K. Yanase, “An introduction to fe analysis with excelvba,” Computer Applications in Engineering Education, vol. 25, no. 2, pp. 311–319, 2017. [Online]. Available: https://onlinelibrary.wiley.com/doi/abs/10.1002/cae.21799
  20. O. Krause, P.C and S. Sudhoff, Analysis of electric machinery and drive systems. IEEE Press, 2002.
  21. S.-H. A. Mahdy and H. Hanafy, “Small wind turbine emulator with separately excited dc motor using analog electronic circuit,” IET Conference on Renewable Power Generation, pp. 1–6, 2011.
  22. R. Issa, “Separately excited dc motor optimal efficiency controller,” Journal of Engineering and Innovative Technology (IJEIT), pp. 533–539, 2013.
  23. A. P. Yadav, S. Xu, B. C. Schafer, and A. Davoudi, “Hardware-assisted simulation of voltage-behind-reactance models of electric machines on fpga,” IEEE Transactions on Energy Conversion, vol. 35, no. 3, pp. 1247–1257, 2020.
  24. A. Akpunar and S. Iplikci, “Runge-kutta model predictive speed control for permanent magnet synchronous motors,” Energies, vol. 13, no. 5, 2020. [Online]. Available: https: //www.mdpi.com/1996-1073/13/5/1216
  25. T. S. A. V.W. T. Press,William H. and B. P. Flannery, Numerical Recipes: The Art of Scientific Computing, third edition ed. Cambridge University Press, 2007.
Index Terms

Computer Science
Information Sciences

Keywords

Engineering Education Virtual Lab Rotating Machines STEM Learning Visual Basic for Applications