Excel VBA技术在矿井采区供电设计计算中应用  

Application of Excel VBA Technology in Power Supply Design and Calculation of Well Mining Area

作　　者：王俊飞[1] 靳宝全[2] 王明奎[3] Wang Junfei;Jin Baoquan;Wang Mingkui(Engineering and Technical College,Chengdu University of Technology,Leshan 614000,China;College of Electrical and Power Engineering,Taiyuan University of Technology,Taiyuan 030024,China;Changping Mine,Shanxi Jincheng Anthracite Coal Mining Group,Changzhi 048006,China)

机构地区：[1]成都理工大学工程技术学院,四川乐山614000 [2]太原理工大学电气与动力工程学院,太原030024 [3]山西晋煤集团长平矿,山西长治048006

出　　处：《煤矿机械》2018年第9期114-117,共4页Coal Mine Machinery

基　　金：成都理工大学工程技术学院青年基金(C122016019)

摘　　要：随着煤矿生产机械化,采区用电设备增多,采区安全可靠供电对煤矿安全、高效生产至关重要。针对目前仍然有多数煤矿依靠人工进行供电计算,缺乏科学性与准确性且效率低下,给安全生产埋下隐患,提出依托通用办公软件Excel 2007为平台,利用其内嵌VBA进行二次开发,使供电设计计算实现了可视化、交互式、自动化,且自动生成各种报表与设计说明书,并应用Excel与Internet交互技术将设计结果发布到网页供相关人员进行查阅,同时实现了设备管理网络化,方便设计人员进行设备选型。实际应用表明:该系统有效保证了供电计算的准确性、科学性、快速性,提高了矿井采区供电设计效率,对煤矿机电技术人员具有较高应用价值。With the mechanization of coal production, the electrical equipment in the mining area is increased, so the safe and reliable power supply of the mining area is very important to the safe and efficient production of the coal. At present, there are still most mines complete the power supply calculation relying on manual,it is lack of science and accuracy,and it is low efficiency, so that hidden trouble for safe production of coal mine,in view of this situation,the thesis puts forward advanced development on the common office software Excel 2007 platform using its embedded VBA, Thus the design and calculation of power supply can be visualized, interactive and automated, and can automatically generate various reports and design instructions. The design results are published to the web page through using Excel and Internet interaction technology for the relevant personnel to refer,at the same time, the network of equipment management has been realized, which makes it convenient for designers to select equipment. The practical application shows that the system effectively ensures the accuracy, scientificity and speediness of power supply calculation, and improves the efficiency of power supply design in mining area,it has high application value for coal mine mechanical and electrical technicians.

关 键 词：矿井采区 供电设计计算 EXCEL二次开发 VBA 

分 类 号：TM769[电气工程—电力系统及自动化]