Transistor Amplifier Calculator

[prenato]

I use this simple one-transistor amplifier circuit quite often, so this time I decided to create an Excel calculator that others could use. It includes the "basic" biasing, Gain, Zi and Zo calculations. A more "advanced" feature is the noise estimation:

http://paulorenato.com/joomla/index.php?option=com_content&view=article&id=104

I did my best to make it accurate (and compared the results against practical implementations in the lab). However, it is possible there is some error there so, for the experts in the blog, would appreciate any corrections and/or suggestions for improvement.

Thanks in advance,

Paulo

[jeroen74]

Or you use this little program I came across a few days ago:

http://en.transistoramp.de/

[prenato]

Hi jeroen74. Thanks for the link. It looks interesting. It doesn't seem to estimate noise though:)...

[c4757p]

Looks nice  I'm no Excel wizard, so I don't know, but is it possible to have it do proper engineering notation instead? "200E-8" feels awkward, but if it could say "2E-6" I'd immediately recognize that as "2 micro".

[prenato]

Hi jeroen74. Thanks for the link. It looks interesting. It doesn't seem to estimate noise though:)...

...and it also doesn't cover this particular biasing arrangement (feedback resistor from collector to base). There are many resources out there for the common emitter amplifier, but i didn't find calculators for this specific biasing network (which is why I decided to write this).
Paulo

[jeroen74]

Maybe you can collaborate with that guy to improve his program with your equations.

[c4757p]

I've had a little project on the back burner for some time - I've been meaning to write up a whole bunch of little useful electronics calculators - not just like the little ones you see scattered around that are no more convenient than a pocket calculator - and put them in a collection online. (My favorite so far is a voltage divider calculator that can do arbitrary series/parallel networks, multiple taps, etc, has different ways of specification - voltages at different points, ratios, decibels attenuation, and so on, and computes the best E-series values.)

If I ever get it finished, do you mind if I borrow some of the equations from your spreadsheet as part of the transistor bias calculator? With proper attribution, of course!

[prenato]

I've had a little project on the back burner for some time - I've been meaning to write up a whole bunch of little useful electronics calculators - not just like the little ones you see scattered around that are no more convenient than a pocket calculator - and put them in a collection online. (My favorite so far is a voltage divider calculator that can do arbitrary series/parallel networks, multiple taps, etc, has different ways of specification - voltages at different points, ratios, decibels attenuation, and so on, and computes the best E-series values.)

If I ever get it finished, do you mind if I borrow some of the equations from your spreadsheet as part of the transistor bias calculator? With proper attribution, of course!

Hi c4757p,

Sure; no problem when people reuse the work with proper attribution:). Thanks for asking... not everyone does that.

Paulo

[prenato]

Looks nice  I'm no Excel wizard, so I don't know, but is it possible to have it do proper engineering notation instead? "200E-8" feels awkward, but if it could say "2E-6" I'd immediately recognize that as "2 micro".

Actually,  it does that already. Let me know if you found some cell that doesn't. I did apply a specific numbering format to each cell that would result in engineering notation, but it's possible I forgot one or two places...?

[c4757p]

(Sorry for the late reply) It's my fault, I was using it in LibreOffice/OpenOffice and it didn't occur to me that something like that wouldn't be compatible.