中圖分類號(hào)：TN7
文獻(xiàn)標(biāo)志碼：A
DOI: 10.16157/j.issn.0258-7998.223467
中文引用格式： 周軍，丁濤杰，毛臻. 基于Excel VBA的電源電流檢測(cè)電路快速參數(shù)選定[J]. 電子技術(shù)應(yīng)用，2023，49(5)：67-70.
英文引用格式： Zhou Jun，Ding Taojie，Mao Zhen. Fast parameter selection of power supply current detection circuit based on Excel VBA[J]. Application of Electronic Technique，2023，49(5)：67-70.

Fast parameter selection of power supply current detection circuit based on Excel VBA

Abstract： For the actual power supply circuit system, the current detection circuit is designed to realize the real-time detection of each power supply current. In the process of current detection circuit design, it is usually necessary to select and calculate the resistance values of the sampling resistance and conditioning resistance. In view of this complicated and highly repetitive work, the technology of using Excel VBA to compile resistance selection calculation module including series, parallel and proportion is proposed. It can quickly and effectively solve the problem of resistance selection in current detection circuit. The results show that using VBA program to calculate the resistance data can automatically generate the target resistance value on the Excel worksheet cells. This method can effectively improve the accuracy and efficiency of the resistance selection calculation of the sampling resistance and conditioning resistance.

Key words : current detection；calculation of resistance value；Excel；VBA