Resistor spreadsheet?

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


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