Go Back   Home > Forums > >
Home Forums Rules Articles diyAudio Store Blogs Gallery Wiki 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.

Resistor spreadsheet?
Resistor spreadsheet?
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
jackinnj is offline jackinnj  United States
diyAudio Member
jackinnj's Avatar
Join Date: Apr 2002
Location: Llanddewi Brefi, NJ
Resistor spreadsheet?
Texas Instruments has a freeware resistor calculator on their website.
  Reply With Quote
Old 29th January 2006, 05:59 AM   #4
peranders is offline peranders  Sweden
Electrons are yellow and more is better!
diyAudio Member
peranders's Avatar
Join Date: Apr 2002
Location: Göteborg, Sweden
Resistor spreadsheet?
Guys, why don't you use Google?


This was very neat.

/Per-Anders (my first name) or P-A as my friends call me
Group buy: DCT03 DC trap for big toroidal transformers. Sign up for interest HERE. 27 pcb's in interest.
  Reply With Quote


Resistor spreadsheet?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

Forum Jump

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 02:51 AM.

Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 16.67%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2018 DragonByte Technologies Ltd.
Copyright ©1999-2018 diyAudio