宇航计测技术 ›› 2013, Vol. 33 ›› Issue (1): 49-52.doi: 10.12060/j.issn.1000-7202.2013.01.10

• 论文 • 上一篇    下一篇

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

张若林1,2；刘民2   

  1. 1、中国空间技术研究院，北京 100086；
    2、北京东方计量测试研究所，北京 100086
  • 出版日期:2013-02-15 发布日期:2013-02-15

Algorithm of Complex Number in the Impedance Measurement

ZHANG Ruo-lin1,2；LIU Min2   

  1. 1、China Academy of Space Technology,Beijing 100086;
    2、Beijing Orient Institute of Measurement and Test, Beijing 100086
  • Online:2013-02-15 Published:2013-02-15

PDF (PC)

被引次数

8

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

关键词: 阻抗测量, 复数计算, 开短路补偿, Excel

Abstract: The paper introduces a kind of complex number calculations tool，Excel .Compared with other tools, such as Matlab and Labview, Excel is expediently to operate, easy to provide control interfaces, 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.

Key words: Impedance Measurement, Complex number calculations, Open/short compensation, Excel

京ICP备09048426号-4　 京公网安备 11010602060144号　版权所有 © 《宇航计测技术》编辑部