Resistor spreadsheet?

vinnie · 29th January 2006, 01:14 AM

Im about to make a wallin jig and have a box of resistors with 38 different values ranging from 2,37ohm up to 887k(5 of each), 0,25 watt types. in the jig I need 2w resistors, so I need to do some paralelling, but I have trouble finding what values to use.
does anyone know of a spreadsheet that could do this calculations?

poobah · 29th January 2006, 01:33 AM

I don't have a spreadsheet for that but here is the formula to derive standard (E96) resistor values:

10 ^ (X/96)

Where X = 0 to 96 for all the values from 1 to 10 ohms

X = 96 to 192 for all that values from 10 to 100 oms

so on and so forth.

This is for E96 Values for E24 values... well you can see...

jackinnj · 29th January 2006, 01:38 AM

Texas Instruments has a freeware resistor calculator on their website.

peranders · 29th January 2006, 05:59 AM

Guys, why don't you use Google?

http://www.google.com/search?&q=calc...istor+parallel

This was very neat.

http://www.computertorture.com/noncompliant/parallel/

29th January 2006, 01:14 AM	#1
vinnie diyAudio Member Join Date: Jul 2004 Location: Here	Resistor spreadsheet? Im about to make a wallin jig and have a box of resistors with 38 different values ranging from 2,37ohm up to 887k(5 of each), 0,25 watt types. in the jig I need 2w resistors, so I need to do some paralelling, but I have trouble finding what values to use. does anyone know of a spreadsheet that could do this calculations?

29th January 2006, 05:59 AM	#4
peranders Electrons are yellow and more is better! diyAudio Member Join Date: Apr 2002 Location: Göteborg, Sweden Blog Entries: 4	Guys, why don't you use Google? http://www.google.com/search?&q=calc...istor+parallel This was very neat. http://www.computertorture.com/noncompliant/parallel/ __________________ /Per-Anders (my first name) or P-A as my friends call me

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
problem with FRC spreadsheet	nitronori	Multi-Way	4	4th February 2009 09:02 PM
BDS spreadsheet questions	weinstro	Multi-Way	2	3rd July 2008 11:03 AM
ML-TQWT spreadsheet?	tubee	Multi-Way	13	11th October 2007 05:29 PM
Best-ever T/S parameter spreadsheet.	Circlotron	Multi-Way	21	20th March 2004 10:25 AM
1% tolerance resistor spreadsheet	MRehorst	Parts	1	16th December 2002 03:38 PM

New To Site?	Need Help?
Register to Participate Search Privacy Statement Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read


	Please consider donating to help us continue to serve you. Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving

29th January 2006, 01:33 AM	#2
poobah diyAudio Member Join Date: Nov 2005	I don't have a spreadsheet for that but here is the formula to derive standard (E96) resistor values: 10 ^ (X/96) Where X = 0 to 96 for all the values from 1 to 10 ohms X = 96 to 192 for all that values from 10 to 100 oms so on and so forth. This is for E96 Values for E24 values... well you can see...

29th January 2006, 01:38 AM	#3
jackinnj diyAudio Member Join Date: Apr 2002 Location: Llanddewi Brefi, NJ	Texas Instruments has a freeware resistor calculator on their website.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)