For the detailed explanation about this template, read https://electronicsbeliever.com/synchronous-buck-converter-design-calculator-excel-external-switches/.
If you find this design template useful, please share it and follow electronicsbeliever.com in our FB page.