Hi,
Well this is the formula:
x(y+500)/(x+y+500) = 1520
x should be near 2249 and y, near 4189.
Could you help me to solve that equation, step by step. My knowledge of algebra is very low and quite far away. ....45 years away!
Thanks!
Alain
Hi,
Thanks! You see, I would like to use excell to compute the values of 2 resistors in parallel combine with a variable resistor to obtain a certain output resistance value. Like in the image the output value (R eqv.) would be between 1520 and 1660 Ohms when the variable resistor is turned from 0 to 100%. The values computed for the 2 resistors are 2249 and 4189.
This is the reply that I received from another forum about that:
It's fairly straightforward, if the resistances are x and y then
x(y+500)/(x+y+500) = 1520
y(x+500)/(x+y+500) = 1660
I was lazy and solved them iteratively in Excel, if you did it manually - you'd get a quadratic, the solutions are:
x=(377000√17+1861000)/(325√17+179)
y=(1625√17+5875)/3
Now if possible I would like to have the step by step sequence for solving that problem. I would then be able to do an Excell sheet to compute different scenario.
Thanks again!
Alain
Hi,
Thanks! You see, I would like to use excell to compute the values of 2 resistors in parallel combine with a variable resistor to obtain a certain output resistance value. Like in the image the output value (R eqv.) would be between 1520 and 1660 Ohms when the variable resistor is turned from 0 to 100%. The values computed for the 2 resistors are 2249 and 4189.
This is the reply that I received from another forum about that:
It's fairly straightforward, if the resistances are x and y then
x(y+500)/(x+y+500) = 1520
y(x+500)/(x+y+500) = 1660
I was lazy and solved them iteratively in Excel, if you did it manually - you'd get a quadratic, the solutions are:
x=(377000√17+1861000)/(325√17+179)
y=(1625√17+5875)/3
Now if possible I would like to have the step by step sequence for solving that problem. I would then be able to do an Excell sheet to compute different scenario.
Thanks again!
Alain