摘要
研究一种基于Excel环境的直流变换器设计方法及其实现软件,以一个多路输出Forward变换器设计为例,介绍了应用Excel软件辅助电路设计的思路、方法和要点。通过Excel强大的数据计算功能,完成设计过程中各计算公式的运算和参数整理;Excel对数据库数据的调用、数据筛选等功能完成了电路设计中各功率器件的选取,步骤清晰地阐述了磁性元器件的设计。利用软件自带的VBA编程平台,使用VBA编程语言实现软件的界面优化,并解决了常规电路设计中遇到的主要问题,如效率估算、迭代计算、控制占空比丢失等。
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.
出处
《电源学报》
2012年第4期49-53,共5页
Journal of Power Supply
关键词
直流变换器
效率估算
迭代计算
占空比
DC converter
efficiency estimate
iterative calculation
duty cycle
