基于VBA的配电网辅助决策平台开发
王亚，汪超，黄进，付佳佳，张向阳
（国网芜湖供电公司，安徽 芜湖 241000）
摘 要：为了解决配电网三相电压不平衡故障判断和单相接地选线耗时长的缺点，采用VBA语言编程开发配电网辅助决策平台。在WPS 表格环境下建立用户窗体，使用VBA语言编写三相电压不平衡故障自动判断程序、接地变电站母线信息自动查询程序。对配电网辅助决策平台进行实践验证，结果表明基于VBA的配电网辅助决策平台可以实现配电网三相电压不平衡故障的辅助判断和变电站单相接地母线选线顺序的辅助生成。
关键词：VBA；WPS；用户窗体；三相电压不平衡；辅助决策
中图分类号：TM711 文献标识码：B 文章编号：1007-3175(2019)08-0050-04
Development of Auxiliary Decision Platform for Distribution Network Based on Visual Basic for Application
WANG Ya, WANG Chao, HUANG Jin, FU Jia-jia, ZHANG Xiang-yang
（State Grid Wuhu Power Supply Company, Wuhu 241000, China）
Abstract: In order to solve the problem of long time for judging unbalanced three-phase voltage and one-phase ground fault line selection in distribution network, this paper adopted the visual basic for application (VBA) language to develop the auxiliary decision-making platform of distribution network. User forms were built in WPS table environment. The VBA language was used to write the automatic judgment program for three-phase voltage unbalance faults and the automatic inquiry program for bus information of grounded substation. The practical verification of distribution network auxiliary decision-making platform shows that this platform based on VBA can realize the auxiliary judgment of threephase unbalanced voltage fault in distribution network and the auxiliary generation of single-phase-to-ground bus line selection sequence.
Key words: visual basic for application; word processing system; user forms; three-phase voltage unbalance; auxiliary decision
参考文献
[1] 陈久奇，白晓龙，石小帅.10 kV线路单相接地故障试拉路序位表[J]. 农村电气化，2013(6)：33-34.
[2] 李媛，李易斯，张司宇，等.10 kV线路选拉接地序位表的制定[J]. 江西电力，2015(2)：45-47.
[3] 黄建业，钱健，陈春生，等. 配电网单相接地现场试验及结果分析[J]. 供用电，2018(5)：31-37.
[4] 刘哲，沈雯婷. 小电流接地系统故障选线法的分析[J]. 电工电气，2018(2)：1-5.
