Application of EXCEL for analyzing DC/DC converters

Abstract

EXCEL is an often used and easily accessible calculation and drawing tool. The application for analyzing converters is therefore obvious. A special step-down converter is used to explain and to show the efficiency and usefulness of this tool for technical applications. The use of tapped inductors in the classical buck converter leads to high step-down ratios overcoming the extreme duty ratios of the active switch and the high peak currents in the active and passive switches. The dimensioning of the converters, the behavior, and the component stresses are analyzed.