基于VBA的配電網(wǎng)輔助決策平臺(tái)開發(fā)
王亞，汪超，黃進(jìn)，付佳佳，張向陽
（國(guó)網(wǎng)蕪湖供電公司，安徽 蕪湖 241000）
摘 要：為了解決配電網(wǎng)三相電壓不平衡故障判斷和單相接地選線耗時(shí)長(zhǎng)的缺點(diǎn)，采用VBA語言編程開發(fā)配電網(wǎng)輔助決策平臺(tái)。在WPS 表格環(huán)境下建立用戶窗體，使用VBA語言編寫三相電壓不平衡故障自動(dòng)判斷程序、接地變電站母線信息自動(dòng)查詢程序。對(duì)配電網(wǎng)輔助決策平臺(tái)進(jìn)行實(shí)踐驗(yàn)證，結(jié)果表明基于VBA的配電網(wǎng)輔助決策平臺(tái)可以實(shí)現(xiàn)配電網(wǎng)三相電壓不平衡故障的輔助判斷和變電站單相接地母線選線順序的輔助生成。
關(guān)鍵詞：VBA；WPS；用戶窗體；三相電壓不平衡；輔助決策
中圖分類號(hào)：TM711 文獻(xiàn)標(biāo)識(shí)碼：B 文章編號(hào)：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
參考文獻(xiàn)
[1] 陳久奇，白曉龍，石小帥.10 kV線路單相接地故障試?yán)沸蛭槐韀J]. 農(nóng)村電氣化，2013(6)：33-34.
[2] 李媛，李易斯，張司宇，等.10 kV線路選拉接地序位表的制定[J]. 江西電力，2015(2)：45-47.
[3] 黃建業(yè)，錢健，陳春生，等. 配電網(wǎng)單相接地現(xiàn)場(chǎng)試驗(yàn)及結(jié)果分析[J]. 供用電，2018(5)：31-37.
[4] 劉哲，沈雯婷. 小電流接地系統(tǒng)故障選線法的分析[J]. 電工電氣，2018(2)：1-5.
