Excel环境下直流变换器辅助设计

摘要

The DC-DC converter design and implement software using in Excel was introduced. Taking a multi-output Forward converter design for example, the auxiliary circuit Excel software application design ideas, methods and points were given. The powerful data via Excel calculations was used to complete the design process of the formula and parameters for finishing operations. The database data via Excel call and other functions were used to complete the circuit design of each power device selection and the magnetic component design. VBA programming language optimized software interface was used to solve the main problems about conventional circuit design, such as the efficiency estimates, iterative calculation, duty cycle control lost and so on.%研究一种基于Excel环境的直流变换器设计方法及其实现软件,以一个多路输出Forward变换器设计为例,介绍了应用Excel软件辅助电路设计的思路、方法和要点。通过Excel强大的数据计算功能,完成设计过程中各计算公式的运算和参数整理;Excel对数据库数据的调用、数据筛选等功能完成了电路设计中各功率器件的选取,步骤清晰地阐述了磁性元器件的设计。利用软件自带的VBA编程平台,使用VBA编程语言实现软件的界面优化,并解决了常规电路设计中遇到的主要问题,如效率估算、迭代计算、控制占空比丢失等。