The power supply design software model for mine based on VBA technology

Baoquan Jin, Xiaohui Hao, Hongjuan Zhang, Yan Gao

Key Lab of Advanced Transducers and Intelligent Control System, Ministry of Education, Taiyuan University of Technology, Taiyuan, China

Coal mine power supply system is increasingly complex, resulting in difficulties for power computing and tuning.  A software design program is proposed by using VBA development tools embedded in AutoCAD secondary development, adopt object-oriented program, ActiveX automation technology and visual programming techniques to achieve human-computer interface and database interaction, design one of the mine power supply design software with function mapping, statistical calculations, protection setting, design reports automatically output, data maintenance. The study shows that the software can greatly simplify the power supply design process, improve efficiency, and can effectively improve the coal mine management level.