The resistive voltage divider—a basic circuit taught in every introductory
electronics course—may cause some problems during its implementation.
If you've ever stood in front of a resistor kit while punching values into your
calculator, this article is for you.
Typical kits don't include every value. So, finding an elusive ratio for which
both values are commonly available can be a challenge. The small spreadsheet
described below not only provides a table of 1% resistor values, it also makes
it a snap to find the ratio you need using two available resistors.
Most engineers don't know that 1% resistor values are logarithmically spaced
in increments of exactly 1/96th of a decade. Figure 1 shows a spreadsheet table
of 1% resistor values, rounded to three significant digits. For example, the
formula in cell B5 is =10^((B$4+$A5)/96), which is copied to B5 through G20.
Only the yellow highlighted values are commonly available in resistor kits.
A typical kit contains slightly more than one-fourth of the values.
In a typical application for resistive dividers, the divider ratio R2/(R1 +
R2) supplies external feedback to the 4-MHz regulated stepdown converter (Fig.
2). (The feedback threshold at the FB terminal is 0.6 V, and the desired
output is 1.5 V.)
To calculate values for R1 and R2, enter the regulator's desired output voltage
(voltage at the top of the divider) in cell B3 and the regulator's feedback
threshold (voltage at the divider midpoint) in cell C3. Then, the spreadsheet
formula in cell D3 is =96*LOG(B3/C3-1), which returns a value of +16.9 steps
for this example. That result is the number of 1% resistor-value steps separating
R1 from R2.
Therefore, if you use R2 = 100 kΩ (cell B5), you would move +17 steps
down the list to R1 = 150 kΩ (cell C6). That would be a good choice because
both resistors are highlighted in yellow (commonly available). Very quickly
from the spreadsheet table, you can see that R2 = 110 kΩ isn't a good
choice for this example because R1 = 165 kΩ isn't commonly available.
You can also quickly identify an exhaustive list of commonly available resistor
values that would be suitable: 1.00:1.50, 1.21:1.82, 1.62:2.43, 1.82:2.74, 2.00:3.01,
2.21:3.32, 3.32:4.99, and 4.99:7.50. When the number of steps (D3) is negative,
R1 is less than R2. Therefore, you should move in the opposite direction on
the value list. In either direction, you may wrap around the list from 9.76
to 1.00, which means that you've moved to the next decade of resistance values.
If you use resistive dividers for purposes other than regulator feedback, you
may wish to rename cells B2 and C2 as "Vtop" and "Vmid," respectively.
The Figure 1 spreadsheet is available for
download in Microsoft Excel format (DB2195XLspreadsheet.xls) and also in Pocket
Excel format for Pocket PC (DB2195POCKETXLspreadsheet.PXL), formatted to fit
the Pocket PC screen at 60% zoom, at ED Online 12236 at www.electronicdesign.com.