 # BJT Voltage Divider Bias Design Template

## 1. Voltage Divider Bias Design Template in Excel Applicable Circuit

This Voltage Divider Bias Design Template in Excel will work only on below circuit. This circuit is a Voltage Divider Bias. VCC and VBB are both referenced to the circuit ground. In case VBB is tied to VCC, then the value of VBB is same to VCC.

## 2. Requirements to Use this Voltage Divider Bias Design Template in Excel

The user must have computer with Microsoft excel application in order to use this Voltage Divider Bias Design Template in Excel.

VCC and VBB are both referenced to the circuit ground. In case VBB is tied to VCC, then the value of VBB is same to VCC.

## 3. How the Template Works?

The template is designed in excel. Excel is a very common office tool. So, everybody has access on it in their laptops or PC. It is designed based on the above circuit.

The user just needs to input all the parameters. Change values until the desired parameters are attained.

Given Data

All the fields in green are inputs. The user must enter value on it.

Computed Data

The fields in yellow are calculation results. These should not be altered.

Current Calculation

The template computes the circuit currents; base (Ib), collector (Ic) and emitter (Ie).  The unit is express in both Amperes (A) and in microampere (uA) or milliampere (mA).

Power Dissipation Calculation

The design template will do power dissipation computations for all the parts on the circuit. The units are in watts (W) and milliwatts (mW).

Power Stress Calculation

The template is also able to compute the power stress of the components in the circuit. However, the power rating of each component must be provided on the corresponding field. For power stress, just set a limit of 50% to ensure high reliability.

Transistor Operation State

The excel design template is also able to determine if the transistor operates in Linear or Saturation mode. Linear mode is what is desired for amplifier application. On the other hand, saturation is what is needed for a switch operation.

## 4. Design Template Integrity

The template is double checked via Mathcad derivations and template. They have the same result. Furthermore, there is an LTspice simulation that shows the same results.

If you want to check your calculations, then this is perfect for you. If you have no time to do all the analysis, simply use this template and you can have instant design. All you need to do is to play on it.

Related Articles:

NPN Transistor Fixed Bias Circuit Design Template

How to Know if a Transistor Defective

NPN Transistor Principles and Practical Uses

Transistor Operation Mode Determination

NPN Transistor Biasing Tool and Checker in Excel

Complete Analysis of a Fixed Bias Circuit using NPN Transistor

How to Select a Transistor For Switch and Linear Applications

How to Saturate a PNP Transistor

PNP Transistor Biasing Calculator – Automated Template for All Configurations

NPN Transistor Switch or Linear Circuit Designer

How to Drive a Transistor into Hard Saturation