|
| 摘要: |
| 在电力系统的规划、设计与运行中,需要大量的故障计算、分析,手工计算方法是繁锁、困难的。论述了计算电路常用的节点电位法和回路电流法,即从求解节点导纳方程和节点阻抗方程而计算故障点参数。说明Excel是广泛应用的办公软件,具有强大的计算、数据分析和图表处理等功能。用实例阐明了Excel在电力系统故障计算时的方法,即建立系统等值序网络和各序网络节点导纳矩阵,用Excel矩阵求逆函数获得阻抗矩阵,求得阻抗方程,再计算出故障电气参数。Excel软件的应用使故障计算准确、方便、直观。 |
| 关键词: Excel表格,故障,节点,网络,矩阵 |
| DOI： |
| 分类号:TM744 TP317.3 |
| 基金项目: |
|
| Application of Excel in electric power fault calculation |
|
SU De-jia
|
| Abstract: |
| Plenty of fault calculation and data analysis are necessary in the electric power planning,design and operation,which is difficult to be carried out manually.Commonly used methods,the node electrical potential law and the circuit current law,are discussed,which calculate fault parameters based on solutions of the node admittance equation and the node impedance equation.Excel is a widely-used office software with powerful functions of computation,data analysis and graphic processing.Its application in electric power fault calculation is illustrated with examples:establish system equivalent sequential networks and their node admittance matrices;convert them into impedance matrices using the matrix reverse function of Excel;solve the impedance equation;and calculate fault parameters.The fault calculation becomes precise,convenient and direct. |
| Key words: Excel spreadsheet,fault,node,network,matrix |
