用Excel求解电路线性方程组

Solving the Set of Circuit Equations by Using Microsoft Excel

Excel不但具有强大的数据分析和处理功能,而且具有丰富的函数和强大的加载宏功能,在数据计算中发挥着不容忽视的作用。本文给出了用Excel求解电路线性方程组的两种方法,即矩阵运算法和加载宏"规划求解"法。

Excel has not only powerful ability of data analyzing and dealing, but it also has abundart functions and powerful macros function, which plays an important role on data calculations. In this paper, two methods in calculations of circuit operations are introduced particularly, one is matrix operations, and the other is programming fuaction.