Resistor spreadsheet? - diyAudio
Go Back   Home > Forums > Design & Build > Parts
Home Forums Rules Articles diyAudio Store Gallery Wiki Blogs Register Donations FAQ Calendar Search Today's Posts Mark Forums Read

Parts Where to get, and how to make the best bits. PCB's, caps, transformers, etc.

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
Thread Tools Search this Thread
Old 29th January 2006, 01:14 AM   #1
vinnie is offline vinnie  Norway
diyAudio Member
Join Date: Jul 2004
Location: Here
Default 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?
  Reply With Quote
Old 29th January 2006, 01:33 AM   #2
poobah is offline poobah  United States
diyAudio Member
poobah's Avatar
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...

  Reply With Quote
Old 29th January 2006, 01:38 AM   #3
diyAudio Member
jackinnj's Avatar
Join Date: Apr 2002
Location: Llanddewi Brefi, NJ
Texas Instruments has a freeware resistor calculator on their website.
  Reply With Quote
Old 29th January 2006, 05:59 AM   #4
Electrons are yellow and more is better!
diyAudio Member
peranders's Avatar
Join Date: Apr 2002
Location: Göteborg, Sweden
Blog Entries: 4
Guys, why don't you use Google?

This was very neat.
/Per-Anders (my first name) or P-A as my friends call me
PA03 LM4780 amplifier group buy, SIGN UP HERE for the group buy 0 boards left. 118 paid.
  Reply With Quote


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

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?

All times are GMT. The time now is 07:48 AM.

vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Copyright ©1999-2017 diyAudio

Content Relevant URLs by vBSEO 3.3.2