Path: EDN Asia >> Design Centre >> Test & Measurement >> Compute standard resistor values in Excel
Test & Measurement Share print

Compute standard resistor values in Excel

05 Nov 2013  | Donald Schelle

Share this page with your friends

Once installed, using the add-in is as easy as any standard Excel function. The function (STDEIA) has three arguments and returns a single value. The arguments are: 1) an arbitrary value in Ohms; 2) a desired tolerance value (1%, 2%, "E12," "E96," etc.); and 3) an optional value that selects the closest numerical value (FALSE or blank), or the closest ratiometric value (TRUE). Examples of the function are presented in figure 4.

Figure 3: Installing the code as an Excel add-in ensures that the custom function will be available from any open spreadsheet.

Figure 4: When installed, apply the code like a standard Excel function making it easy to integrate into existing spreadsheet calculations. The first example (top) looks for the closest numerical 1% (E96) resistance value for 35,534Ω. The second example (bottom) returns the closest 10% (E12) ratiometric value for 34Ω.

An Internet search yields many similar solutions. However, none of them are as complete or as flexible as the one presented here. Edit the code for your own purposes by downloading the .xls spreadsheet at:

Standard EIA Decade Resistor Values Table,

About the author
Donald Schelle is an Analogue Field Applications Engineer for Texas Instruments power group and has more than a decade of engineering experience. He received his Bachelor of Electrical Engineering from Lakehead University, Thunder Bay, Ontario, Canada.

To download the PDF version of this article, click here.

 First Page Previous Page 1 • 2

Want to more of this to be delivered to you for FREE?

Subscribe to EDN Asia alerts and receive the latest design ideas and product news in your inbox.

Got to make sure you're not a robot. Please enter the code displayed on the right.

Time to activate your subscription - it's easy!

We have sent an activate request to your registerd e-email. Simply click on the link to activate your subscription.

We're doing this to protect your privacy and ensure you successfully receive your e-mail alerts.

Add New Comment
Visitor (To avoid code verification, simply login or register with us. It is fast and free!)
*Verify code:
Tech Impact

Regional Roundup
Control this smart glass with the blink of an eye
K-Glass 2 detects users' eye movements to point the cursor to recognise computer icons or objects in the Internet, and uses winks for commands. The researchers call this interface the "i-Mouse."

GlobalFoundries extends grants to Singapore students
ARM, Tencent Games team up to improve mobile gaming

News | Products | Design Features | Regional Roundup | Tech Impact