论文总字数：17563字

摘 要

在变电所设计软件设计过程中，为明确流程并分担压力，会将整体分为不同模块进行。变电所设计过程中有很多模块的工作可以借助计算机编程进行解决，如电力计算模块、设备选择和校验模块等模块，完全可以将程序所需数据在Excel中进行录入保存，并利用内嵌VBA程序进行编程，在相应模块开始工作时能快速将数据进行输送传递。本变电所设计软件过程中会使用到Excel、Visio及VBA编程软件，这些都是Microsoft Office软件套装中常见软件。其中Visio中大量的内置图形库在变电所主接线绘制时起到十分重要的作用。而利用Excel进行数据处理大大节省了计算时间，提高整体效率。

在该软件程序中，设计人员在图形模块中初步完成对变电所的一次主接线设计，之后程序会对相应节点数据进行自动生成，之后将被传输至电力计算模块进行潮流计算及短路计算来得出系统潮流分布和短路电流分布。之后设备选择与校验模块将根据这些来进行给各项设备的选择和校验，并将最终选择结果显示在图形模块。相较于纯人工进行变电所设计，这类辅助软件更具积极作用，能大大提高效率，确保结果准确性。

关键词： 潮流计算；P-Q分解法；Excel；VBA

Development of Power Design Software Based on Office——PQ Decomposition Method Power Flow Calculation Module

Abstract

In the software design process of the substation design, in order to clarify the process and share the pressure, the whole will be divided into different modules. In the design process of the substation, there are many modules that can be solved by computer programming, such as power calculation module, equipment selection and verification module, etc., the data required by the program can be completely saved in Excel and embedded The VBA program is programmed so that the data can be quickly transferred when the corresponding module starts to work. Excel, Visio and VBA programming software are used in the software design process of this substation. These are common software in the Microsoft Office software suite. Among them, a large number of built-in graphics libraries in Visio play a very important role in drawing the main wiring of the substation. The use of Excel for data processing greatly saves calculation time and improves overall efficiency.

In this software program, the designer preliminarily completes the primary wiring design of the substation in the graphics module, and then the program will automatically generate the corresponding node data, and then will be transmitted to the power calculation module for power flow calculation and short circuit calculation The power flow distribution and short circuit current distribution of the system. The device selection and verification module will then select and verify each device based on these, and display the final selection results in the graphics module. Compared with the design of purely manual substations, this type of auxiliary software has a more positive effect, which can greatly improve efficiency and ensure the accuracy of results.

Keywords: power flow calculation; P-Q decomposition method; Excel; VBA

目 录

摘 要 I

Abstract II

目 录 III

第一章 绪 论 1

1.1 课题的内容、意义 1

1.1.1 课题的内容 1

1.1.2 课题的意义 1

1.2 课题背景 1

第二章 变电所设计程序的设计 3

2.1 变电所设计程序的构成 3

2.2 主要功能模块介绍 4

2.2.1 电力网接线绘制和图形建模模块 4

2.2.2 电力计算模块 4

2.2.3 设备选择与校验模块 4

2.2.4 图形模块（主接线绘制） 4

2.2 本章小结 5

第三章 潮流计算模块 6

3.1 参数输入子模块 6

3.2潮流计算子模块 6

3.2.1 潮流计算意义及方法 6

3.2.2 P-Q分解法原理 7

3.3 程序接口子模块 10

3.4 本章小结 10

第四章 设备选择与校验模块 11

4.1 电压互感器选择与校验模块 11

4.2 电流互感器选择与校验模块 11

4.3主变压器的选择与检验模块 11

4.4 母线的选择与校验模块 12

4.5 电抗器选择与校验模块 12

4.6 支柱绝缘子和穿墙套管选择与校验模块 12

4.7高压断路器和隔离开关选择与校验模块 13

第五章 图形模块（主接线绘制） 14

第六章 结论 15

致谢 16

参考文献 17

剩余内容已隐藏，请支付后下载全文，论文总字数：17563字