Using standard resistor values can greatly impact the accuracy and predictability of a circuit by eliminating rounding errors incurred at the end of the design. Selecting resistor values traditionally ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

The formula will calculate the nearest 1%-resistor for the value in cell A1. This formula can be copied and replicated to other cells just like any standard Excel cell formula.

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