论文总字数：29869字

摘 要

众所周知在我们的生活中，电能是主要的能源之一，而随着科技的不断发展，各种电气设备对电能的质量要求也是更高了。且系统中的关键是变电所。对于这个情况，设计一个更加合理、更加经济实用的变电所就是我们要做的课题。在电力系统设计中，计算机的应用已越来越广泛。相比于人力计算短路电流并校验电气设备，通过运用计算机建立电力系统的数学模型与备选电气设备的数据库，可以极大得提升工程设计人员的工作效率。

变电所作为系统核心，影响着整个系统的稳定与有效运行，在发电厂和用户里，它起到了过度作用，起到变换、分配电能的目的。那么对它进行有效设计是必要的，更好的变电所可以充分满足各种需求，还可减小投资及减少能源损失。而且我们也知道，变电所设计不仅内容广泛而且步骤复杂、计算量大，为了方便工程设计师设计变电所，所以用Microsoft Office Excel、Microsoft Office Visio软件及VBA对变电所系统程序进行开发设计，以一种共享数据库为中心，使用该系统将原始参数、资料导入，继而可以进行对变压器的选择校验，主接线的方案拟定，短路电流计算还有各种电气设备的选择和校验等项目。而我的课题任务是对互感器选择和校验模块进行设计，这不仅大大减轻了工程设计师的负担，而且解决了手工计算时准确性不高、计算量巨大且麻烦、费时费力等不可避免问题，并且大大的缩短了设计周期。

本次设计为了完善对变电所的设计，分多个模块讨论了每一步设计步骤，在电气设备选择部分主要针对互感器的选择和校验模块。利用了Microsoft Office Excel，Microsoft Office Visio及VBA实现了软件的开发，最终运行结果表明该软件计算精确，计算效率较高，具有一定的实用价值，对促进电气工程向标准化、智能化、集成化的发展具有重要的现实意义。

关键词： 电能 变电所设计 Microsoft Office Excel Microsoft Office Visio 互感器的选择和校验模块。

Abstract

It is well known that in our life, electric energy is one of the main energy sources, and with the continuous development of science and technology, all kinds of electrical equipment have higher requirements for the quality of electric energy. And the key in the system is the substation. For this situation, the design of a more reasonable, more economical and practical substation is our subject to do. In power system design, the application of computer has been more and more extensive. Compared with manual calculation of short-circuit current and calibration of electrical equipment, the use of computers to establish a mathematical model of the power system and the database of alternative electrical equipment can greatly improve the work efficiency of engineering designers.

As the core of the system, substation affects the stability and effective operation of the whole system. In power plants and users, it plays an excessive role in transforming and distributing electric energy. So it is necessary to design it effectively, better substation can fully meet the needs, but also reduce investment and reduce energy losses. And we also know that, substation design contents and steps of not only complex, large amount of calculation, in order to facilitate engineering designer substation, so the use of Microsoft Office Excel, Microsoft Office Visio software and VBA program of substation system development and design, in a Shared database as the center, to use the system will be the original parameters, data import, then can carry out for calibration, the selection of the transformer main wiring plan, along with a variety of short circuit current calculation, electrical equipment selection and calibration. My task is to design the transformer selection and calibration module, which not only greatly reduces the burden of engineering designers, but also solves the ineluctable problems such as inaccurate manual calculation, huge calculation amount, trouble, time consuming and laborious, and greatly shortens the design cycle.

In this design, in order to improve the design of the substation, each design step is discussed in several modules. In the electrical equipment selection part, the selection and calibration modules of the transformer are mainly used. Microsoft Office Excel, Microsoft Office Visio and VBA are used to realize the software development. The final running results show that the software has accurate calculation, high calculation efficiency and certain practical value, which has important practical significance for promoting the development of electrical engineering towards standardization, intelligence and integration.

Key words: electric energy substation design Microsoft Office Excel Microsoft Office Visio transformer selection and calibration module.

目录

第一章 绪论 1

1.1课题背景与意义 1

1.2 变电所设计的内容 1

1.3变电所设计的发展趋势 1

1.4本章小结 2

第二章 变电所计算机辅助设计系统的开发 3

2.1概述 3

2.2系统的构成： 3

2.2.1总体结构和大概的框图： 3

2.2.2本系统主要由以下几个模块构成： 4

2.3本章小结 5

第三章 电气主接线模块 6

3.1 主变压器的选择 6

3.1.1主变压器型式的选择依据 6

3.1.2主变压器的容量选择 6

3.1.3主变压器的台数选择 6

3.2电气主接线的设计 6

3.2.1电气主接线的设计原则 6

3.2.2主接线设计 7

3.3本章小结 9

第四章 短路电流计算 10

4.1短路电流的危害分析 10

4.2短路电流计算的目的 10

4.3短路电流计算的一般规定 10

4.4短路电流计算机算法的介绍 12

4.4.1短路计算概述 12

4.4.2 短路电流运算曲线 13

4.4.3 短路电流运算曲线数字化 14

4.4.4样条插值法 15

4.5 本章小结 17

第五章 互感器的选择和校验模块 18

5.1电气设备选择的一般条件 18

5.2 互感器的选择和校验模块 20

5.3 本章小结 22

第六章 程序设计 23

6.1开发工具的介绍 23

6.1.1 Microsoft Office Visio的功能特点介绍： 23

6.1.2 Microsoft Office Visio主界面 24

6.1.3 Visual Basic for Applications宏语言功能特点介绍 25

6.1.4 Visual Basic主界面 26

6.1.5 部分使用操作介绍 26

6.2 程序模块设计： 28

6.2.1电气计算软件的总体结构 28

6.2.2电力系统模型及分析子系统 28

6.2.3网络维护子系统 28

6.2.4面向对象的电力系统表示 29

6.3程序设计 30

6.3.1Visio编程模块 30

6.3.2建立电力元件模具库 30

6.3.3利用ShapeSheet添加自定义属性 32

6.3.4VBA编程 34

6.3.5 Excel的编辑功能 35

6.4本章小结： 36

结 论 37

致 谢 38

参考文献： 39

第一章 绪论

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