1% tolerance resistor spreadsheet

Status
This old topic is closed. If you want to reopen this topic, contact a moderator using the "Report Post" button.
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.

MR
 
Status
This old topic is closed. If you want to reopen this topic, contact a moderator using the "Report Post" button.