阻抗测量中的一种复数计算工具

Algorithm of Complex Number in the Impedance Measurement

介绍了一种应用于阻抗测量的复数计算工具——Excel复数计算函数。Excel和其它工具相比,如Matlab,LabVIEW,具有操作方便灵活、函数库丰富、对控制软件接口方便等优点,非常适用于非编程人员进行复数计算。以"对阻抗测量仪器进行开短路数据补偿"为例,具体介绍了利用Microsoft Excel 2007处理复数计算的方法。该方法操作非常简便,容易掌握,无须进行烦琐的编程,随着电脑和Excel软件的普及,本方法具备了推广和应用的可能。

The paper introduces a kind of complex other tools, such as Matlab and Labview, Excel is number calculations tool, Excel . Compared with expediently to operate, easy to provide control inter- faces, abundant functions, and suitable for non-programmer to calculate complex number. In order to solve the problems presented in the open/short compensation during impedance measurement, a method for the open and short compensation of using Microsoft Excel 2007 is provided. This method is easy to learn, which is without fussy program. It is possible to spread the method in the following years.