I just figured I'd share the Excel sheet that I use for testing amplifiers in my shop. It's basically a suite of 17 tests to figure out if an amplifier is working properly/performing in spec.
Most of the tests assume that you have some form of distortion meter, like a HP 339A or a low-noise spectrum analyser, but there's a few tests that don't require that, like the damping factor calculator (which just requires a multimeter, dummy load and signal generator) and the noise floor/SNR calculator (requires a microvoltmeter for quiet amps).
It should be quite self-explanatory to use if you know amplifier testing. Mind that I'm no Excel wizard, so it might be a bit fidgety if you enter incorrect data in some fields. Lots of formulas are interdependent upon each other, so I don't recommend you try to reformat it too much unless you're prepared to spend hours figuring out why everything broke. 😉 You really aren't supposed to ever type anything other than numbers into the data fields.
It should export quite well to PDF/printed paper (A4 size), and you can export it to an image by highlighting all the cells you want and copy-pasting them into an image editor (like Irfanview or Photoshop).
Either way, here it is. Feel free to share and improve upon it. All formulas should be correct, but math was never my strong suite, so I can't say that with absolute certainty.
Amplifier performance sheet V5
Example filled sheet
Example PDF export
Most of the tests assume that you have some form of distortion meter, like a HP 339A or a low-noise spectrum analyser, but there's a few tests that don't require that, like the damping factor calculator (which just requires a multimeter, dummy load and signal generator) and the noise floor/SNR calculator (requires a microvoltmeter for quiet amps).
It should be quite self-explanatory to use if you know amplifier testing. Mind that I'm no Excel wizard, so it might be a bit fidgety if you enter incorrect data in some fields. Lots of formulas are interdependent upon each other, so I don't recommend you try to reformat it too much unless you're prepared to spend hours figuring out why everything broke. 😉 You really aren't supposed to ever type anything other than numbers into the data fields.
It should export quite well to PDF/printed paper (A4 size), and you can export it to an image by highlighting all the cells you want and copy-pasting them into an image editor (like Irfanview or Photoshop).
Either way, here it is. Feel free to share and improve upon it. All formulas should be correct, but math was never my strong suite, so I can't say that with absolute certainty.
Amplifier performance sheet V5
Example filled sheet
Example PDF export