1% tolerance 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 13th December 2002, 02:29 PM   #1
diyAudio Member
MRehorst's Avatar
Join Date: May 2002
Default 1% tolerance resistor spreadsheet

The spreadsheet here:
Standard 1% resistor selector
allows you to enter an arbitrary resistance value and returns the nearest standard 1% tolerance part.

I got the formula in cell F12 from EDN a few months back. It was originally developed by a couple people at TI. No, I didn't type all that. I scanned the page, then used OCR to convert to editable text, then plugged it into the spreadsheet.

I have protected the sheet to prevent accidents, but you can unprotect it if you want to copy the formula to another sheet- there is no password on the sheet protection.

  Reply With Quote
Old 16th December 2002, 03:38 PM   #2
diyAudio Member
Join Date: Sep 2002
Location: NL
  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
Capacitor tolerance boxerboxer Parts 18 31st May 2009 02:40 AM
Jupiters: Tolerance: 26% over spec: o.k.? boneshaker Tubes / Valves 1 26th April 2006 07:48 AM
Resistor spreadsheet? vinnie Parts 3 29th January 2006 05:59 AM
900% Vas tolerance? Otter Subwoofers 1 10th May 2005 12:16 AM
0.01% tolerance 10 and 100 ohm resistors SkinnyBoy Swap Meet 2 26th November 2003 10:38 AM

New To Site? Need Help?

All times are GMT. The time now is 01:08 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