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.

1% tolerance resistor spreadsheet
1% tolerance 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 13th December 2002, 03:29 PM   #1
MRehorst is offline MRehorst
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, 04:38 PM   #2
LaMa is offline LaMa
diyAudio Member
Join Date: Sep 2002
Location: NL
  Reply With Quote


1% tolerance resistor spreadsheetHide 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
Capacitor tolerance boxerboxer Parts 18 31st May 2009 03:40 AM
Jupiters: Tolerance: 26% over spec: o.k.? boneshaker Tubes / Valves 1 26th April 2006 08:48 AM
Resistor spreadsheet? vinnie Parts 3 29th January 2006 06:59 AM
900% Vas tolerance? Otter Subwoofers 1 10th May 2005 01:16 AM
0.01% tolerance 10 and 100 ohm resistors SkinnyBoy Swap Meet 2 26th November 2003 11:38 AM

New To Site? Need Help?

All times are GMT. The time now is 05:38 PM.

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