An Excel Based High Frequency Transistor Amplifier Calculator

amplifier calculator

 

[Paulo] just tipped us about an Excel based high frequency transistor amplifier calculator he made. We’re guessing that some of our readers already are familiar with these class A amplifiers, commonly used to amplify small audio signals. Skipping over the fact that their efficiency is quite low — they are cheap to make, don’t require many components and usually are a great way to introduce transistors to new electronics enthusiasts. All you usually need to do is a few calculations to properly set your output signals and you’re good to go.

Things are however more complex when you are amplifying 200MHz+ signals, as all the components (complex) impedances have to be taken into account so you can get a nice amplification system. On a side note, at these frequencies your transmission lines impedances may even vary depending on how much solder and flux you left on your SMT pads along the way. [Paulo]’s calculator will therefore compute most of the characteristics of two class A common emitter/collector amplifiers for specified loads.

 

6 thoughts on “An Excel Based High Frequency Transistor Amplifier Calculator

      1. I’m an open source moron and the .xlsx file loads perfectly on LibreOffice 4.2.5.2 under Debian Linux, so no need to complain.

  1. In addition to the virtues you mentioned for class-A amplifiers, it should be noted that they are the most linear of the amp classes, and for small-signal use, that is their most important value.

  2. I would like to see the amplifier that is calculated from this fed to LTSpice and get the AC analysis (transfer function plot) for checking the performance.

Leave a Reply to Todd K7TFCCancel reply

Please be kind and respectful to help make the comments section excellent. (Comment Policy)

This site uses Akismet to reduce spam. Learn how your comment data is processed.