oops, sorry for the delay, i was convinced i had setup the notify on reply but no... anyway, ive been looking at your posts and letme go by order:
@jahonen: excellent soft it's almost what i had in mind, but i don't quite inderstand what's "upper and lower" resistors and it seems oriented for voltage divider, i don't quite follow it (for example, to use series alone, do i put the same value in to/from, then check series, ignore division factor, check available values and choose how many resistors in series to consider?, am i wrong?).
@saturation: i already have this bunch of precision/non precision resistors and want to see what if i could accomplish the values i need with them, if i need to go get new resistors, it defeats the initial purpose.
@johnmx: umfortunately not what i was looking for, that rescad soft you input a value and it tells you what closest Exx values you need to accomplish it and with what error, seeing as to reach a value i can use thousands of combinations with the resistors i have at hand it's not of much use.
@boredatwork: explain it.
@blackdog: similar to rescad it's for the reverse path of what i need(you need an X value and the program tells you the Exx combinations closest for it, then you go buy them/check those specific values), but again, i add a layer of complexity in that the soft should check not a Exx range, but a finite list of existing resistors to make the combinations(and it also uses a 2-resistor limit). All in all it's almost there but on the reverse path
.
What it is is extremely useful to find the combination(or direct value) for a resistor you just calculated in your circuit based on Exx values.
I like how it presents the other results below, so far i think it's the closest to what i need
Nice spreadsheet, i'll save it for future use(doesn't has what i need for this problem as well)
thanks everybody, now to see if the circuit works...