1) Get eight decimal thumbwheel switches. 2) Collect nine identical resistors for each switch, from 1 ohm through 10 megohms. (E.g., nine 1-ohm resistors for the first, nine 10-ohm resistors for ...

A 1% 1M resistor will be somewhere within 10k of a megohm. The device’s 1M setting will actually be somewhere between 1,010,000 and 990,000 ohms. ... and 1-9 Ohm resistors, ...

1/38 + 1/38 + 1/38 + 1/1000 gives 1/0.8 = 12.5 ohms. The additional current path added by the piezo, being so high impedance, takes away just 0.2 ohms from the total impedance.

Multiply 39 by 1 and you get the base Ohm value of the resistor: 39. The final band is always silver or gold. This shows how much variance there might be to the resistor's Ohm value.

The Excel cell formula below calculates the nearest standard 1%-resistor value without using a lookup table or macro. Type or electronically paste the text below into any cell (other than A1).