[StickySli]

Good day everybody! This is my first post as you might tell, and if not, you already have
I am an EE student that loves music and tinkering with audio.

I am currently designing a HiFi Class-D amplifier based on the TPA3255 using the PFFB design, and I wanted to use a stepped attenuator for the input stage. I was going to use a 24-step attenuator you can easily find on Chinese wholesale websites like AE for less than 10$. Since I didn't like the currently available calculators online, I decided to make my own spreadsheet in Excel 2021 using not-so-fancy equations to calculate the resistor standard series and so on. No VBA, so no macros!!!

This is how it looks like at the moment:

I'm not going to post the Excel file yet, since I'm unfamiliar with the rules. I hope someone can enlighten me first.

 

[StickySli]

I kinda forgot about the project and about this post. For anyone interested, you can download the project spreadsheet from here: 24-step Shunt Stepped Attenuator calculator (onedrive)
This file is protected by CC 4.0 NC-BY-SA.

 

[megabigeye]

I think you need more posts to post in other forums, but you might get more interest in the DIY sub-forum.