Standard EIA Decade Values Table

A resource for technical documentation. Datasheets, application notes, instruction manuals, books and links to resources are found in the Document Library.
Post Reply
User avatar
mediatechnology
Posts: 4901
Joined: Sat Aug 11, 2007 2:34 pm
Location: Oak Cliff, Texas
Contact:

Standard EIA Decade Values Table

Post by mediatechnology » Tue Jan 05, 2021 8:03 am

Standard EIA Decade Values Table

E6-E192 values.

Standard EIA Decade Values Table: https://proaudiodesignforum.com/images/ ... Table.html

Dark theme version: https://proaudiodesignforum.com/images/ ... Theme.html

Tables courtesy of logwell.com
https://ka-electronics.com

Covidland (The Movie) Part 1: Lockdown https://banned.video/watch?id=615f96b3aa816336dbd21792

Directing Orson Welles: "What Is It That You Want?": https://waynekirkwood.com/content/Orson ... u_Want.mp3
Americas Frontline Doctors Lawsuit Motion For Preliminary Injunction Of Covid-19 Vaccine Emergency Use Authorization: https://waynekirkwood.com/images/pdf/Am ... zation.pdf

flyboy71
Posts: 52
Joined: Thu Nov 21, 2019 7:56 am

Re: Standard EIA Decade Values Table

Post by flyboy71 » Thu Jan 07, 2021 3:05 pm

Or if you wanna mess with math you can calculate the values using 10^(x/E) where E is the number of the tolerance family (i.e 24, 48 etc) and x is 0 to the max value of E. Then multiply the result by the decade of resistance (10,100,1k,etc). :geek:

I had to use this in a program I wrote once to calculate a bunch of network values or some parameteric sweep something or other. I believe this also works for inductors but not capacitors.
https://ornerscorner.neocities.org/

"Things are more like they are now then they ever were before" - Dwight

User avatar
mediatechnology
Posts: 4901
Joined: Sat Aug 11, 2007 2:34 pm
Location: Oak Cliff, Texas
Contact:

Re: Standard EIA Decade Values Table

Post by mediatechnology » Thu Jan 07, 2021 3:15 pm

I use this formula in spreadsheets to round values to E96.

This following calculates the E96 value of the contents of cell "E8".
=IF(E8<(ROUND(10^(INT(96*LOG10(E8))/96),2-INT(LOG10(E8)))+ROUND(10^(INT(96*LOG10(E8)+1)/96),2-INT(LOG10(E8))))/2,ROUND(10^(INT(96*LOG10(E8))/96),2-INT(LOG10(E8))),ROUND(10^(INT(96*LOG10(E8)+1)/96),2-INT(LOG10(E8))))
I forget the source for this formula - I used it in the THAT1510 gain spreadsheet here: https://proaudiodesignforum.com/forum/p ... 142&p=1160
https://ka-electronics.com

Covidland (The Movie) Part 1: Lockdown https://banned.video/watch?id=615f96b3aa816336dbd21792

Directing Orson Welles: "What Is It That You Want?": https://waynekirkwood.com/content/Orson ... u_Want.mp3
Americas Frontline Doctors Lawsuit Motion For Preliminary Injunction Of Covid-19 Vaccine Emergency Use Authorization: https://waynekirkwood.com/images/pdf/Am ... zation.pdf

flyboy71
Posts: 52
Joined: Thu Nov 21, 2019 7:56 am

Re: Standard EIA Decade Values Table

Post by flyboy71 » Thu Jan 07, 2021 9:40 pm

That's a long formula. My eyes bled halfway through it. I was first introduced to the calculation by an Engineer when I was still plodding through my EE classes in college as a "did you know" moment.

This site shows my explanation but explains it a bit better: https://www.rfcafe.com/references/elect ... values.htm
https://ornerscorner.neocities.org/

"Things are more like they are now then they ever were before" - Dwight

User avatar
mediatechnology
Posts: 4901
Joined: Sat Aug 11, 2007 2:34 pm
Location: Oak Cliff, Texas
Contact:

Re: Standard EIA Decade Values Table

Post by mediatechnology » Fri Jan 08, 2021 6:24 am

That's a long formula. My eyes bled halfway through it.
That's why I always copy and paste that one. :D
https://ka-electronics.com

Covidland (The Movie) Part 1: Lockdown https://banned.video/watch?id=615f96b3aa816336dbd21792

Directing Orson Welles: "What Is It That You Want?": https://waynekirkwood.com/content/Orson ... u_Want.mp3
Americas Frontline Doctors Lawsuit Motion For Preliminary Injunction Of Covid-19 Vaccine Emergency Use Authorization: https://waynekirkwood.com/images/pdf/Am ... zation.pdf

Post Reply