Page **1** of **1**

### Standard EIA Decade Values Table

Posted: **Tue Jan 05, 2021 8:03 am**

by **mediatechnology**

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

### Re: Standard EIA Decade Values Table

Posted: **Thu Jan 07, 2021 3:05 pm**

by **flyboy71**

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

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.

### Re: Standard EIA Decade Values Table

Posted: **Thu Jan 07, 2021 3:15 pm**

by **mediatechnology**

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

### Re: Standard EIA Decade Values Table

Posted: **Thu Jan 07, 2021 9:40 pm**

by **flyboy71**

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

### Re: Standard EIA Decade Values Table

Posted: **Fri Jan 08, 2021 6:24 am**

by **mediatechnology**

That's a long formula. My eyes bled halfway through it.

That's why I always copy and paste that one.