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). The ...

The resistor color code is a long-standing standard in both the electronics and electrical industries which indicates the value of resistance of a resistor. Ohm’s Law is the foundation of measuring ...

What analog designer hasn't had to derive a nonstandard resistor value by using series/parallel combinations of standard resistor values? In efforts to avoid a production trimpot tweak, we can use 0.1 ...

When using a spreadsheet to calculate circuit values, determining “standard” component values to be used in subsequent calculations can produce more accurate results. This approach will also result in ...