CAJ | 학술논문

研究一种基于Excel环境的直流变换器设计方法及其实现软件,以一个多路输出Forward变换器设计为例,介绍了应用Excel软件辅助电路设计的思路、方法和要点。通过Excel强大的数据计算功能,完成设计过程中各计算公式的运算和参数整理;Excel对数据库数据的调用、数据筛选等功能完成了电路设计中各功率器件的选取,步骤清晰地阐述了磁性元器件的设计。利用软件自带的VBA编程平台,使用VBA编程语言实现软件的界面优化,并解决了常规电路设计中遇到的主要问题,如效率估算、迭代计算、控制占空比丢失等。
연구일충기우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.