How to determine the circuit component constants of a BJT amplifier 

When designing an amplifier using transistors
The circuit component constants must be calculated to achieve optimal design. Most transistor design focuses on circuit analysis.
What is really needed is to determine the constants of the circuit.
After a long period of research, I found the answer.
It refers to the absolute parameters and electrical characteristics of the transistor. Microsoft's spreadsheet describes the calculation process for determining the amplifier's constant. It was coded using
You can view the gain and phase by simulating the amplifier's board diagram.
You can download the design and simulation files by clicking the link below.
cafe.daum.net/...